Sample application

Overview

Let's develop the sales management application with Transactd PHP ORM. This example focuses on how to construct the application with complex transaction. In particular, we will explain in detail about mission critical points such as record lock, read consistency and update conflict.

This application records increase and decrease in inventory, and total sales per day, every time sales is recorded. The daily summary table is not calculated by batch processing. It is recorded at the same time as saving sales record.

ER diagram for sample application

Index

  1. Overview
  2. Install
  3. Create database and tables
  4. Define model
  5. Create master data
  6. Create and save invoices
  7. Increase and decrease in stock quantity
  8. Calculate and save sales invoices
  9. Save daily summary
  10. Use models
  11. Souce code