The Thought<\/h2>\n
A venture time-tracking system ought to enable entry of:<\/p>\n
- \n
- Purchasers have a number of tasks consisting of a number of duties.<\/li>\n
- Duties have timesheet entries, accomplished by individuals getting into hours working for a consumer.\u00a0<\/li>\n
- Invoices are created by including bill gadgets linked to billable timesheet traces. \u00a0<\/li>\n
- As soon as the bill is marked as prepared, ship the knowledge to Kafka for bill processing.<\/li>\n<\/ul>\n
The Immediate<\/h2>\n
GenAI Logic<\/a> is an online web page, like many chatbots, that permits the consumer to enter a immediate. The extra particulars offered, the higher the consequence (though you possibly can iterate so as to add or change the end result utilizing the \u201cIterate\u201d button). \u00a0<\/p>\n
You need to describe the mannequin and attribute, the logic, and the use circumstances as totally as potential. Then, merely click on \u201cCreate Tasks\u201d and wait about 90 seconds.\u00a0<\/p>\n
One notice: Beneath \u201cAdvance Settings,\u201d change the information mannequin dimension to eight (the variety of tables to create).\u00a0<\/span>This prevents GenAI from including extra tables which are wanted.<\/p>\n
![\"Data](\"https:\/\/dz2cdn1.dzone.com\/storage\/temp\/18236667-screenshot-2025-02-20-at-104910am.png\")
<\/p>\n\n\n\nUse these names for tables and attributes:\n\n* Shopper (id, identify, electronic mail, telephone, total_hours, total_amount, budget_amount, is_over_budget)\n* Venture ( id, client_id, identify, total_project_hours, total_project_amount, project_budget_amount, is_over_budget, is_active)\n* Bill: (id, invoice_date, project_id, invoice_amount, payment_total, invoice_balance, is_paid, is_ready,task_count,completed_task_count)\n* InvoiceItem(id, invoice_id, task_id, task_amount, is_completed)\n* Activity (id, project_id, identify, description, total_task_hours_worked, total_task_amount_billed, task_budget_hours, is_over_budget,is_completed)\n* Individual (id, client_id, identify, electronic mail, telephone, billing_rate, total_hours_entered, total_amount_billed)\n* Timesheet (id,task_id, person_id, date_worked, hours_worked, billing_rate, total_amount_billed, is_billable)\n* Fee (id, invoice_id, quantity, payment_date, notes)<\/code><\/pre>\n<\/p><\/div><\/div>\n<\/div>\nEnterprise Logic<\/h2>\n
Break down the logic into use circumstances, beginning with timesheets, to explain the enterprise logic. For instance: \u201cCopy the individual\u2019s
billing_rate<\/code> multiplied by thehours_worked<\/code> to get thetotal_amount_billed<\/code>.\u201d\u00a0<\/p>\nThen, modify the use case rule to solely carry out the calculation if the
is_billable<\/code> flag is ready toTrue<\/code> (some duties are non-billable). The sums and counts are rolled up from Activity to Venture to Shopper. Theis_over_budget<\/code> flag is decided based mostly on thebudget_amount<\/code> of the Shopper and Venture.<\/p>\nThe bill has an
is_ready<\/code> flag that, when set totrue<\/code>, sends the bill row to Kafka. This enables a Kafka client to provoke the workflow integration in a separate container. Different workflows and integrations might be simply added to the use circumstances.<\/p>\nEnterprise Guidelines (Logic)<\/strong><\/h3>\n
\n\n\nUse LogicBank to implement enterprise logic.\n\nUse case: Individual\nWhole Hours entered is sum of timesheet hours labored\nWhole quantity billed is complete hours entered occasions billing fee\nBilling fee have to be larger than 0 and fewer than 200\n\nUse case: Timesheet\nCopy billing fee from Individual billing fee\nIf is_billable then the overall quantity billed is the billing fee occasions hours labored \nHours labored have to be larger than 0 and fewer than 15\n\nUse Case: Activity\nWhole process hours labored is the sum of the Timesheet hours labored\nWhole process quantity billed is the sum of the Timesheet complete quantity billed\nMethod: is Over Price range when complete process hours labored exceeds process funds hours\n\nUse Case: Venture\nWhole venture hours is the sum of Activity complete process hours labored\nWhole venture quantity is the sum of Activity complete quantity billed\nMethod: is Over Price range when complete venture quantity exceeds venture funds quantity\n\nUse Case: Shopper\nWhole hours is the sum of Venture complete venture hours\nWhole quantity is the sum of Venture complete venture quantity\nMethod: is Over Price range equals true when complete quantity exceeds funds quantity\n\nUse Case: Bill\nBill Quantity is the sum of InvoiceItem process quantity\nFee complete is the sum of Fee quantity\nBill stability is bill quantity much less cost complete\nMethod: is_paid when bill stability is than or equal to zero\nActivity Rely is rely of InvoiceItem \nActivity accomplished rely is rely of InvoiceItem the place is_completed is True\nMethod: is prepared when Activity Rely is the same as Activity Accomplished Rely\nShip bill to Kafka when is_ready is True\n\nUse Case: InvoiceItem\nInvoiceItem process quantity is copied from Activity complete process quantity billed\nInvoiceItem is_completed is sum of Activity is_completed when True<\/code><\/pre>\n<\/p><\/div><\/div>\n<\/div>\nThe Venture\u00a0<\/h2>\n
When accomplished, GenAI Logic creates an SQL Database (SQLite), a SQLAlchemy ORM mannequin, an API (JSON API), a react-admin consumer, full enterprise logic (25+ guidelines), and pattern information for testing. This is able to simply be over 1,000 traces of code to deal with all of the use circumstances of including, updating, deleting, and reparenting entries. The whole venture might be downloaded from GitHub or a zipper file for the developer to overview.<\/p>\n
Only for enjoyable, the system additionally created a single-page software touchdown web page to exhibit your venture immediate.\u00a0<\/p>\n
![\"ProjectTrue\"\/](\"https:\/\/dz2cdn1.dzone.com\/storage\/temp\/18236679-screenshot-2025-02-20-at-95003am.png\")
<\/p>\nThe Information Mannequin<\/h2>\n
The \u201cBackend Admin\u201d button results in the working web page that features the logic, the mannequin, a pattern react-admin software (for testing the foundations), and instruments for the developer. This was the mannequin created from the immediate.\u00a0<\/p>\n
![\"Automatically](\"https:\/\/dz2cdn1.dzone.com\/storage\/temp\/18236684-screenshot-2025-02-20-at-95032am.png\")
<\/p>\nDiscover the Venture<\/h2>\n
The API entities at the moment are prepared to check on the left (a react software) to see take a look at information. Enter a Shopper, Venture, Activity, and Timesheet for a Individual and watch the sums, counts, and constraint guidelines change worth.<\/p>\n
You too can run the generated software domestically utilizing Docker or click on on the GitHub hyperlink to see the code and run the applying utilizing GitHub CodeSpaces<\/a>.\u00a0<\/p>\n
![\"ProjectTimeTracker\"\/](\"https:\/\/dz2cdn1.dzone.com\/storage\/temp\/18236685-screenshot-2025-02-21-at-14810pm.png\")
\u00a0<\/p>\nLastly, discover the API endpoints utilizing OpenAPI (Swagger). If the \u201c> Logic Guidelines\u201d have any points, they are often individually reviewed, edited, rejected, or accepted. GenAI may even recommend logic based mostly in your mannequin (see the \u201cLogic\u201d button).\u00a0<\/span><\/p>\n
Word<\/strong>: You too can run the Docker<\/span> model domestically.<\/p>\n
![](\"https:\/\/dz2cdn1.dzone.com\/storage\/temp\/18236669-screenshot-2025-02-20-at-100947am.png\"\/)
<\/p>\n![](\"https:\/\/dz2cdn1.dzone.com\/storage\/temp\/18236670-screenshot-2025-02-20-at-95828am.png\"\/)
\n <\/h2>\nThe Logic Logs: Auditable and Clear<\/h2>\n
Enterprise logic<\/a> shouldn’t be a black field. As API endpoints are accessed (POST, PATCH, and DELETE), the foundations hearth on state adjustments of dependent entities and attributes. An entire log of guidelines that fired and the order they fired, together with the row values impacted, provides a full, clear view of the processing. This isn’t a black field however a real companion to companies that require auditable and clear logic transactions.<\/p>\n
Word that the
before_flush<\/code> exhibits the state change of every row impacted so as, and theafter_flush<\/code> exhibits the ultimate assortment of guidelines that fired (it is a lot of element, however it’s\u00a0<\/span>essential if that you must move an audit).\u00a0<\/p>\nAdditionally, notice that the order begins with the timesheet change and cascades as much as the mother or father Shopper. Guidelines are unordered within the declaration (see logic folder) and might simply be added\/modified with out impacting different guidelines.<\/p>\n
\n\n\nLogic Section:\t\tROW LOGIC\t\t(session=0xffffac2f0bf0) (sqlalchemy before_flush)\t\t\t\n..Timesheet[3] {Replace - consumer} id: 3, task_id: 12, person_id: 6, date_worked: [2025-02-20-->] 2025-02-20 00:00:00, hours_worked: [12.00-->] 10, billing_rate: 100, total_amount_billed: 1200, is_billable: True row: 0xffffac2443b0 session: 0xffffac2f0bf0 ins_upd_dlt: upd, preliminary: upd\n..Timesheet[3] {Method total_amount_billed} id: 3, task_id: 12, person_id: 6, date_worked: [2025-02-20-->] 2025-02-20 00:00:00, hours_worked: [12.00-->] 10, billing_rate: 100, total_amount_billed: [1200-->] 1000, is_billable: True row: 0xffffac2443b0 session: 0xffffac2f0bf0 ins_upd_dlt: upd, preliminary: upd\n....Individual[6] {Replace - Adjusting individual: total_hours_entered} id: 6, client_id: 8, identify: Individual (New Shopper), electronic mail: individual@consumer.com, telephone: 8885551212, billing_rate: 100.00, total_hours_entered: [12.00-->] 10.00, total_amount_billed: 1200.00 row: 0xffffac244380 session: 0xffffac2f0bf0 ins_upd_dlt: upd, preliminary: upd\n....Individual[6] {Method total_amount_billed} id: 6, client_id: 8, identify: Individual (New Shopper), electronic mail: individual@consumer.com, telephone: 8885551212, billing_rate: 100.00, total_hours_entered: [12.00-->] 10.00, total_amount_billed: [1200.00-->] 1000.0000 row: 0xffffac244380 session: 0xffffac2f0bf0 ins_upd_dlt: upd, preliminary: upd\n....Activity[12] {Replace - Adjusting process: total_task_hours_worked, total_task_amount_billed} id: 12, project_id: 6, identify: New Activity, description: , total_task_hours_worked: [12.00-->] 10.00, total_task_amount_billed: [1200.00-->] 1000.00, task_budget_hours: 1000.00, is_over_budget: False, is_completed: False row: 0xffffac2450a0 session: 0xffffac2f0bf0 ins_upd_dlt: upd, preliminary: upd\n......Venture[6] {Replace - Adjusting venture: total_project_hours, total_project_amount} id: 6, client_id: 8, identify: New Venture, total_project_hours: [12.00-->] 10.00, total_project_amount: [1200.00-->] 1000.00, project_budget_amount: 1000.00, is_over_budget: True, is_active: False row: 0xffffac247860 session: 0xffffac2f0bf0 ins_upd_dlt: upd, preliminary: upd\n......Venture[6] {Method is_over_budget} id: 6, client_id: 8, identify: New Venture, total_project_hours: [12.00-->] 10.00, total_project_amount: [1200.00-->] 1000.00, project_budget_amount: 1000.00, is_over_budget: [True-->] False, is_active: False row: 0xffffac247860 session: 0xffffac2f0bf0 ins_upd_dlt: upd, preliminary: upd\n........Shopper[8] {Replace - Adjusting consumer: total_hours, total_amount} id: 8, identify: New Shopper, electronic mail: , telephone: , total_hours: [12.00-->] 10.00, total_amount: [1200.00-->] 1000.00, budget_amount: 0.00, is_over_budget: True row: 0xffffac2321e0 session: 0xffffac2f0bf0 ins_upd_dlt: upd, preliminary: upd\n\nLogic Section:\t\tCOMMIT LOGIC\t\t(session=0xffffac2f0bf0) \t\t\t\t\nLogic Section:\t\tAFTER_FLUSH LOGIC\t(session=0xffffac2f0bf0) \t\t\t\t\t\t\t\t\t\t\nThese Guidelines Fired (see Logic Phases, above, for precise order):\t\t##\n Shopper\t\t##\n 1. Derive.total_hours as Sum(Venture.total_project_hours The place - None)\t\t##\n 2. Derive .total_amount as Sum(Venture.total_project_amount The place - None)\t\t##\n 3. Derive .is_over_budget as Method (1): Rule.method(derive=Shopper.is_over_budget, as_exp [...]\t\t##\n Individual\t\t##\n 4. Derive .total_amount_billed as Method (1): Rule.method(derive=Individual.total_amount_billed, a [...]\t\t##\n 5. Derive .total_hours_entered as Sum(Timesheet.hours_worked The place - None)\n Venture\t\t##\n 6. Derive .total_project_amount as Sum(Activity.total_task_amount_billed The place - None) \n 7. Derive .is_over_budget as Method (1): Rule.method(derive=Venture.is_over_budget, \n as_ex [...]\t\t##\n 8. Derive .total_project_hours as Sum(Activity.total_task_hours_worked The place - None)\t Activity\t\t##\n 9. Derive .total_task_amount_billed as Sum(Timesheet.total_amount_billed The place - None)\n 10. Derive .is_over_budget as Method (1): Rule.method(derive=Activity.is_over_budget, \n as_expre [...]\t\t##\n 11. Derive .total_task_hours_worked as Sum(Timesheet.hours_worked The place - None)\n Timesheet\t\t##\n 12. Derive .total_amount_billed as Method (1): Rule.method(derive=Timesheet.total_amount_billed [...]\t\t##\n\nLogic Section:\t\tCOMPLETE(session=0xffffac2f0bf0)) \u00a0<\/class><\/class><\/class><\/class><\/class><\/class><\/class><\/class><\/class><\/class><\/class><\/class><\/code><\/pre>\n<\/p><\/div><\/div>\n<\/div>\n <\/h2>\n
ApiLogicServer: The Developer Journey<\/h2>\n
![\"TimeTracker](\"https:\/\/dz2cdn1.dzone.com\/storage\/temp\/18236683-screenshot-2025-02-20-at-14532pm.png\")
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/strong><\/p>\n![\"TreeView](\"https:\/\/dz2cdn1.dzone.com\/storage\/temp\/18245941-screenshot-2025-02-25-at-41135pm.png\")
<\/p>\n