SELECT COUNT(*) as total FROM erp_warehouse_inventory w WHERE ;totala SELECT w.id, w.item_code, w.item_name, w.material_group, w.unit, w.quantity_received, w.quantity_remaining, w.unit_price_vnd, w.total_value_vnd, w.supplier_name, w.supplier_tax_code, w.source_invoice_id, w.invoice_series_number, w.receipt_date, w.warehouse_location, w.status, w.allocated_project_id, w.notes, p.project_name as allocated_project_name, p.project_code as allocated_project_code FROM erp_warehouse_inventory w LEFT JOIN projects p ON w.allocated_project_id = p.id WHERE z} ORDER BY w.receipt_date DESC, w.created_at DESC LIMIT %s OFFSET %s; c,g|]}t|Sdict.0rs LC:\Projects\DSCons\app\modules\invoices\application\invoice_truth\queries.py z>TruthQueriesMixin.list_warehouse_inventory..Hs...AQ...N) get_connectioncursorappendstripextendjoinexecutefetchonefetchall)selfrr r r rconncur where_clausesparamss_like where_sql total_cntqueryrowss rlist_warehouse_inventoryz*TruthQueriesMixin.list_warehouse_inventory s " "3 :d2 :#!& $&!2!(()@AAAMM.111*!((999MM&)))D2222F!((IMM6666"BCCC#LL77  aU^aaa LLNN73 %" ufo... E6***||~~..... 9e2 :2 :2 :2 :2 :2 :2 :3 :3 :3 :3 :3 :3 :3 :3 :2 :2 :2 :2 :2 :2 :2 :2 :2 :3 :3 :3 :3 :3 :3 :3 :3 :3 :3 :3 :3 :3 :3 :3 :3 :3 :3 :s5FEF- FF F F FF#&F#List[Dict[str, Any]]c:|5}|5}|d|}d|DcdddcdddS#1swxYwYddddS#1swxYwYdS)zIFetch all owned equipment extracted directly from real purchase invoices.aF SELECT e.id, e.equipment_code, e.equipment_name, e.equipment_type, e.license_plate, e.brand_model, e.ownership_type, e.hourly_rate_standard, e.fuel_norm_per_hour, e.status, e.purchase_cost_vnd, e.purchase_invoice_series_number, e.supplier_name, e.source_invoice_id, e.notes, e.created_at, p.project_name as current_project_name, p.project_code as current_project_code FROM erp_equipment e LEFT JOIN projects p ON e.current_project_id = p.id WHERE e.ownership_type = 'owned' ORDER BY e.purchase_cost_vnd DESC, e.created_at DESC; c,g|]}t|Srrrs rrz:TruthQueriesMixin.list_truth_equipment..]s***DGG***rN)rr r%r')r(r)r*r1s rlist_truth_equipmentz&TruthQueriesMixin.list_truth_equipmentJs7  " " +dDKKMM +S KK   <<>>D**T***# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +s4B5A8 B8A< <B?A< BBBDict[str, Any]c ^|5}|5}|d|}|d|}|d|}|dt |d|dt |d|dd |Dd cd d d cd d d S#1swxYwY d d d d S#1swxYwYd S) zEAggregate summary metrics of Truth equipment and warehouse materials.a SELECT COUNT(*) as total_owned_equipment, COALESCE(SUM(purchase_cost_vnd), 0) as total_equipment_value_vnd FROM erp_equipment WHERE ownership_type = 'owned'; ub SELECT COUNT(*) as total_material_lots, COALESCE(SUM(total_value_vnd), 0) as total_warehouse_value_vnd, COUNT(*) FILTER (WHERE status = 'CHỜ_XUẤT_CÔNG_TRƯỜNG') as pending_dispatch_count FROM erp_warehouse_inventory; a  SELECT material_group, COUNT(*) as count, COALESCE(SUM(total_value_vnd), 0) as total_value FROM erp_warehouse_inventory GROUP BY material_group ORDER BY total_value DESC; total_owned_equipmenttotal_equipment_value_vndtotal_material_lotstotal_warehouse_value_vndpending_dispatch_countc,g|]}t|Srr)rgs rrz7TruthQueriesMixin.get_truth_summary..s'I'I'IAQ'I'I'Ir)r9r:r;r<r=group_breakdownN)rr r%r&r'float)r(r)r*eq_statwh_statr@s rget_truth_summaryz#TruthQueriesMixin.get_truth_summary_s  " "* d) # ,,.. ,,..  #&,,...55L-M16 ;<22,33H+I16 ;<22/66N.O'I'I'I'I'I  =) ) ) ) ) ) ) * * * * * * * * ) ) ) ) ) ) ) ) ) * * * * * * * * * * * * * * * * * * s5D"CD 0 D" D D"D D""D&)D&)NNNrr) rr r r r r r r rr rr)rr3)rr7)__name__ __module__ __qualname____doc__r2r6rDrrrrr smRR&*!! <:<:<:<:<:|++++*,,,,,,rr) __future__rloggingtypingr getLoggerloggerrrrrrNs""""""  9 : :BBBBBBBBBBr