=== Inventory Flow Analysis ===
Total outgoing transactions: 20
Outgoing transactions with project_id: 20
Total outgoing items: 31
Total incoming operations: 6
Total incoming operation items: 7
Total inventory records: 11
Total stock movements: 19

--- Sample Outgoing Transactions ---
ID: 1, Project: 13, Date: 2025-12-04, Status: pending, MRN: MR-20251204-477
ID: 2, Project: 13, Date: 2025-12-05, Status: successful, MRN: MR-20251204-477-INV
ID: 3, Project: 13, Date: 2025-12-05, Status: successful, MRN: MR-20251204-477-INV
ID: 4, Project: 13, Date: 2025-12-05, Status: successful, MRN: MR-20251204-477-INV
ID: 5, Project: 3, Date: 2025-12-05, Status: pending, MRN: MR-20251205-540

--- Sample Outgoing Items ---
Item: 1, Requested: 1000.00, Released: 0.00, Project: 13, Status: pending
Item: 2, Requested: 300.00, Released: 0.00, Project: 13, Status: pending
Item: 1, Requested: 100.00, Released: 100.00, Project: 13, Status: successful
Item: 2, Requested: 50.00, Released: 50.00, Project: 13, Status: successful
Item: 1, Requested: 100.00, Released: 100.00, Project: 13, Status: successful

--- Sample Stock Movements ---
Item: 1, Type: out, Ref: outgoing:2, Qty: 100.00, Date: 2025-12-05 07:59:27
Item: 2, Type: out, Ref: outgoing:2, Qty: 50.00, Date: 2025-12-05 07:59:27
Item: 1, Type: out, Ref: outgoing:3, Qty: 100.00, Date: 2025-12-05 11:03:18
Item: 2, Type: out, Ref: outgoing:3, Qty: 30.00, Date: 2025-12-05 11:03:18
Item: 1, Type: out, Ref: outgoing:4, Qty: 200.00, Date: 2025-12-05 11:22:59

--- Site Return Data ---
Return transactions: 0
Return items: 0
Incoming operations (site returns): 6