[2026-07-20 17:42:20] live.INFO: Product Category Analytics Request {"business_id":"1","start_date":"2026-06-21","end_date":"2026-07-20","location_ids":[],"category_ids":[]} 
[2026-07-20 17:42:20] live.INFO: Category contribution data {"categories_count":36,"summary":{"total_categories":36,"total_sales":1202199.868,"total_profit":159733.09700000007,"avg_margin":13.286733866119512},"raw_data":{"categories":{"Illuminate\\Support\\Collection":[{"category_id":"382","category_name":"BULK ITEM","total_quantity":"1248.8830","gross_sales":"269603.90800000","total_sales":"268457.44800000","gross_profit":"17311.23700000","transaction_count":"327","unique_products":"31","avg_unit_price":"297.90316206","sales_contribution":22.330517174869627,"profit_contribution":10.837601802712179,"profit_margin":6.448410028840028,"avg_transaction_value":820.9707889908257},{"category_id":"370","category_name":"FOOD ITEMS","total_quantity":"1168.8220","gross_sales":"227582.45000000","total_sales":"227022.45000000","gross_profit":"39177.29000000","transaction_count":"380","unique_products":"128","avg_unit_price":"286.05962521","sales_contribution":18.883919058956344,"profit_contribution":24.52672034525192,"profit_margin":17.25701136605653,"avg_transaction_value":597.4275},{"category_id":"372","category_name":"Beverege item","total_quantity":"659.0000","gross_sales":"152020.00000000","total_sales":"152020.00000000","gross_profit":"16667.82000000","transaction_count":"448","unique_products":"105","avg_unit_price":"235.55555556","sales_contribution":12.645151945732872,"profit_contribution":10.43479423678863,"profit_margin":10.964228391001184,"avg_transaction_value":339.33035714285717},{"category_id":"375","category_name":"ICE CREAM ITEM","total_quantity":"419.0000","gross_sales":"111730.00000000","total_sales":"107170.00000000","gross_profit":"16122.52000000","transaction_count":"210","unique_products":"31","avg_unit_price":"359.57264957","sales_contribution":8.914491080280172,"profit_contribution":10.093412262581996,"profit_margin":15.043874218531306,"avg_transaction_value":510.3333333333333},{"category_id":"369","category_name":"Biscuit Item","total_quantity":"486.0000","gross_sales":"100320.00000000","total_sales":"97960.00000000","gross_profit":"11315.00000000","transaction_count":"278","unique_products":"68","avg_unit_price":"219.00000000","sales_contribution":8.148395504565135,"profit_contribution":7.083691615895981,"profit_margin":11.550632911392405,"avg_transaction_value":352.37410071942446},{"category_id":"389","category_name":"SPICES","total_quantity":"198.0000","gross_sales":"42410.00000000","total_sales":"42400.00000000","gross_profit":"6738.25000000","transaction_count":"90","unique_products":"30","avg_unit_price":"207.23404255","sales_contribution":3.5268677969943014,"profit_contribution":4.218443219691657,"profit_margin":15.892099056603772,"avg_transaction_value":471.1111111111111},{"category_id":"367","category_name":"Soap","total_quantity":"139.0000","gross_sales":"37470.00000000","total_sales":"37370.00000000","gross_profit":"3561.66000000","transaction_count":"85","unique_products":"26","avg_unit_price":"277.75700935","sales_contribution":3.108468150322572,"profit_contribution":2.229757055295809,"profit_margin":9.53080010703773,"avg_transaction_value":439.6470588235294},{"category_id":"386","category_name":"YOGHURT","total_quantity":"588.0000","gross_sales":"43080.00000000","total_sales":"36000.00000000","gross_profit":"4314.00000000","transaction_count":"127","unique_products":"3","avg_unit_price":"61.84615385","sales_contribution":2.994510393674407,"profit_contribution":2.7007552479872086,"profit_margin":11.983333333333333,"avg_transaction_value":283.46456692913387},{"category_id":"383","category_name":"MILK POWDER","total_quantity":"27.0000","gross_sales":"28990.00000000","total_sales":"28990.00000000","gross_profit":"1669.83000000","transaction_count":"26","unique_products":"3","avg_unit_price":"1068.84615385","sales_contribution":2.4114126753505847,"profit_contribution":1.0453876068026149,"profit_margin":5.7600206967919965,"avg_transaction_value":1115.0},{"category_id":"371","category_name":"chocolat item","total_quantity":"174.0000","gross_sales":"28100.00000000","total_sales":"28100.00000000","gross_profit":"2931.00000000","transaction_count":"111","unique_products":"53","avg_unit_price":"170.60606061","sales_contribution":2.337381723951412,"profit_contribution":1.8349359369148142,"profit_margin":10.430604982206406,"avg_transaction_value":253.15315315315314},{"category_id":"393","category_name":"CHICKEN","total_quantity":"25.6320","gross_sales":"25862.13000000","total_sales":"25739.25000000","gross_profit":"6543.53000000","transaction_count":"27","unique_products":"4","avg_unit_price":"982.67857143","sales_contribution":2.1410125458439992,"profit_contribution":4.0965398673763875,"profit_margin":25.422380216983786,"avg_transaction_value":953.3055555555555},{"category_id":"394","category_name":"SAUSAGE","total_quantity":"49.0000","gross_sales":"14445.00000000","total_sales":"14445.00000000","gross_profit":"2397.80000000","transaction_count":"34","unique_products":"8","avg_unit_price":"319.44444444","sales_contribution":1.2015472954618558,"profit_contribution":1.5011290991246473,"profit_margin":16.599515403253722,"avg_transaction_value":424.8529411764706},{"category_id":"373","category_name":"TEA ITEM","total_quantity":"56.0000","gross_sales":"13620.00000000","total_sales":"13620.00000000","gross_profit":"1458.81000000","transaction_count":"43","unique_products":"9","avg_unit_price":"238.60465116","sales_contribution":1.1329230989401506,"profit_contribution":0.9132797318767314,"profit_margin":10.710792951541851,"avg_transaction_value":316.74418604651163},{"category_id":"385","category_name":"ICE CREAM CONE","total_quantity":"72.0000","gross_sales":"13240.00000000","total_sales":"13160.00000000","gross_profit":"4880.00000000","transaction_count":"13","unique_products":"1","avg_unit_price":"190.76923077","sales_contribution":1.0946599105765331,"profit_contribution":3.0550963398649924,"profit_margin":37.08206686930091,"avg_transaction_value":1012.3076923076923},{"category_id":"362","category_name":"toothpaste","total_quantity":"57.0000","gross_sales":"13360.00000000","total_sales":"13155.00000000","gross_profit":"1337.29000000","transaction_count":"43","unique_products":"7","avg_unit_price":"235.57777778","sales_contribution":1.0942440063551895,"profit_contribution":0.8372028246594377,"profit_margin":10.165640440896997,"avg_transaction_value":305.93023255813955},{"category_id":"361","category_name":"balm itam","total_quantity":"323.0000","gross_sales":"11150.72000000","total_sales":"11150.72000000","gross_profit":"3972.65000000","transaction_count":"29","unique_products":"10","avg_unit_price":"91.34589744","sales_contribution":0.9275263038042523,"profit_contribution":2.487055015279644,"profit_margin":35.62684741433737,"avg_transaction_value":384.5075862068965},{"category_id":"360","category_name":"Bathroom item","total_quantity":"45.0000","gross_sales":"10019.00000000","total_sales":"10019.00000000","gross_profit":"1261.64000000","transaction_count":"35","unique_products":"17","avg_unit_price":"266.54285714","sales_contribution":0.8333888787284413,"profit_contribution":0.7898425709482109,"profit_margin":12.59247429883222,"avg_transaction_value":286.25714285714287},{"category_id":"387","category_name":"GROCERY","total_quantity":"667.0000","gross_sales":"8916.00000000","total_sales":"8916.00000000","gross_profit":"3824.90000000","transaction_count":"125","unique_products":"8","avg_unit_price":"20.75000000","sales_contribution":0.7416404075000281,"profit_contribution":2.3945569652355756,"profit_margin":42.89928218932257,"avg_transaction_value":71.328},{"category_id":"381","category_name":"BUTTER","total_quantity":"17.0000","gross_sales":"8590.00000000","total_sales":"8590.00000000","gross_profit":"846.89000000","transaction_count":"16","unique_products":"9","avg_unit_price":"505.29411765","sales_contribution":0.714523452268421,"profit_contribution":0.5301906842762835,"profit_margin":9.859022118742725,"avg_transaction_value":536.875},{"category_id":"384","category_name":"SHAMPOO","total_quantity":"22.0000","gross_sales":"7680.00000000","total_sales":"7680.00000000","gross_profit":"842.70000000","transaction_count":"22","unique_products":"9","avg_unit_price":"349.09090909","sales_contribution":0.6388288839838735,"profit_contribution":0.5275675585254569,"profit_margin":10.97265625,"avg_transaction_value":349.09090909090907},{"category_id":"395","category_name":"HOME CARE","total_quantity":"19.0000","gross_sales":"7020.00000000","total_sales":"6995.00000000","gross_profit":"1275.00000000","transaction_count":"29","unique_products":"7","avg_unit_price":"548.96551724","sales_contribution":0.5818500056597911,"profit_contribution":0.7982065232229232,"profit_margin":18.227305218012866,"avg_transaction_value":241.20689655172413},{"category_id":"376","category_name":"CHEESE WEDGES","total_quantity":"26.0000","gross_sales":"6720.00000000","total_sales":"6720.00000000","gross_profit":"5136.60000000","transaction_count":"14","unique_products":"1","avg_unit_price":"420.00000000","sales_contribution":0.5589752734858893,"profit_contribution":3.215739315440681,"profit_margin":76.4375,"avg_transaction_value":480.0},{"category_id":"363","category_name":"syrup item","total_quantity":"26.0000","gross_sales":"5980.00000000","total_sales":"5980.00000000","gross_profit":"897.00000000","transaction_count":"14","unique_products":"1","avg_unit_price":"230.00000000","sales_contribution":0.4974214487270264,"profit_contribution":0.5615617657497742,"profit_margin":15.0,"avg_transaction_value":427.14285714285717},{"category_id":"391","category_name":"CLEANING ITEM","total_quantity":"35.0000","gross_sales":"6550.00000000","total_sales":"5800.00000000","gross_profit":"790.25000000","transaction_count":"19","unique_products":"8","avg_unit_price":"186.31578947","sales_contribution":0.4824488967586545,"profit_contribution":0.49473153331522746,"profit_margin":13.625000000000002,"avg_transaction_value":305.2631578947368},{"category_id":"366","category_name":"toothbrush","total_quantity":"31.0000","gross_sales":"3930.00000000","total_sales":"3930.00000000","gross_profit":"574.80000000","transaction_count":"22","unique_products":"6","avg_unit_price":"127.91666667","sales_contribution":0.32690071797612275,"profit_contribution":0.35985028199885194,"profit_margin":14.625954198473282,"avg_transaction_value":178.63636363636363},{"category_id":"379","category_name":"CHIPS","total_quantity":"52.0000","gross_sales":"3260.00000000","total_sales":"3260.00000000","gross_profit":"601.00000000","transaction_count":"31","unique_products":"9","avg_unit_price":"68.33333333","sales_contribution":0.27116955231607126,"profit_contribution":0.3762526434956681,"profit_margin":18.435582822085887,"avg_transaction_value":105.16129032258064},{"category_id":"390","category_name":"SPICES","total_quantity":"15.0000","gross_sales":"2790.00000000","total_sales":"2790.00000000","gross_profit":"392.50000000","transaction_count":"15","unique_products":"3","avg_unit_price":"186.00000000","sales_contribution":0.23207455550976652,"profit_contribution":0.24572240028627243,"profit_margin":14.068100358422939,"avg_transaction_value":186.0},{"category_id":"378","category_name":"TOFFEE","total_quantity":"259.0000","gross_sales":"2605.00000000","total_sales":"2605.00000000","gross_profit":"437.40000000","transaction_count":"92","unique_products":"7","avg_unit_price":"10.69148936","sales_contribution":0.21668609932005084,"profit_contribution":0.2738317907903581,"profit_margin":16.790786948176585,"avg_transaction_value":28.315217391304348},{"category_id":"388","category_name":"CREAM","total_quantity":"6.0000","gross_sales":"2460.00000000","total_sales":"2460.00000000","gross_profit":"319.47000000","transaction_count":"6","unique_products":"5","avg_unit_price":"410.00000000","sales_contribution":0.20462487690108447,"profit_contribution":0.20000238272472728,"profit_margin":12.986585365853658,"avg_transaction_value":410.0},{"category_id":"365","category_name":"oil items","total_quantity":"3.2500","gross_sales":"2200.00000000","total_sales":"2200.00000000","gross_profit":"469.02000000","transaction_count":"5","unique_products":"2","avg_unit_price":"720.00000000","sales_contribution":0.18299785739121374,"profit_contribution":0.2936273125662866,"profit_margin":21.319090909090907,"avg_transaction_value":440.0},{"category_id":"392","category_name":"KITCHEN ITEM","total_quantity":"4.0000","gross_sales":"1750.00000000","total_sales":"1750.00000000","gross_profit":"520.00000000","transaction_count":"4","unique_products":"2","avg_unit_price":"437.50000000","sales_contribution":0.14556647747028365,"profit_contribution":0.3255430526085648,"profit_margin":29.714285714285715,"avg_transaction_value":437.5},{"category_id":"368","category_name":"incense sticks","total_quantity":"20.0000","gross_sales":"2310.00000000","total_sales":"1710.00000000","gross_profit":"493.95000000","transaction_count":"15","unique_products":"7","avg_unit_price":"86.84210526","sales_contribution":0.14223924369953433,"profit_contribution":0.30923459776153955,"profit_margin":28.885964912280706,"avg_transaction_value":114.0},{"category_id":"380","category_name":"MATCHES","total_quantity":"78.0000","gross_sales":"1560.00000000","total_sales":"1560.00000000","gross_profit":"390.00000000","transaction_count":"19","unique_products":"1","avg_unit_price":"20.00000000","sales_contribution":0.1297621170592243,"profit_contribution":0.24415728945642357,"profit_margin":25.0,"avg_transaction_value":82.10526315789474},{"category_id":"374","category_name":"DETERGENT ITEM","total_quantity":"5.0000","gross_sales":"1195.00000000","total_sales":"1195.00000000","gross_profit":"108.65000000","transaction_count":"5","unique_products":"2","avg_unit_price":"239.00000000","sales_contribution":0.09940110890113657,"profit_contribution":0.06801971666523185,"profit_margin":9.092050209205022,"avg_transaction_value":239.0},{"category_id":"364","category_name":"cologne item","total_quantity":"2.0000","gross_sales":"730.00000000","total_sales":"730.00000000","gross_profit":"81.14000000","transaction_count":"2","unique_products":"2","avg_unit_price":"365.00000000","sales_contribution":0.06072201631617547,"profit_contribution":0.05079723709357489,"profit_margin":11.115068493150684,"avg_transaction_value":365.0},{"category_id":"397","category_name":"SWEET","total_quantity":"4.0000","gross_sales":"550.00000000","total_sales":"550.00000000","gross_profit":"71.50000000","transaction_count":"4","unique_products":"2","avg_unit_price":"137.50000000","sales_contribution":0.045749464347803435,"profit_contribution":0.04476216973367765,"profit_margin":13.0,"avg_transaction_value":137.5}]},"summary":{"total_categories":36,"total_sales":1202199.868,"total_profit":159733.09700000007,"avg_margin":13.286733866119512}}} 
[2026-07-20 17:42:20] live.INFO: Seasonal patterns monthly data count: 63  
[2026-07-20 17:42:20] live.INFO: Seasonal patterns monthly sample: [{"category_name":"balm itam","month":"6","month_name":"June","sales":"1180.00000000","quantity":"16.0000"},{"category_name":"balm itam","month":"7","month_name":"July","sales":"9970.72000000","quantity":"307.0000"},{"category_name":"Bathroom item","month":"6","month_name":"June","sales":"1715.00000000","quantity":"5.0000"},{"category_name":"Bathroom item","month":"7","month_name":"July","sales":"8304.00000000","quantity":"40.0000"},{"category_name":"Beverege item","month":"6","month_name":"June","sales":"31600.00000000","quantity":"138.0000"}]  
[2026-07-20 17:42:20] live.INFO: Processed monthly patterns: {"balm itam":{"6":"1180.00000000","7":"9970.72000000"},"Bathroom item":{"6":"1715.00000000","7":"8304.00000000"},"Beverege item":{"6":"31600.00000000","7":"120420.00000000"},"Biscuit Item":{"6":"21880.00000000","7":"76080.00000000"},"BULK ITEM":{"6":"23876.45000000","7":"244580.99800000"},"BUTTER":{"7":"8590.00000000"},"CHEESE WEDGES":{"6":"560.00000000","7":"6160.00000000"},"CHICKEN":{"7":"25739.25000000"},"CHIPS":{"6":"650.00000000","7":"2610.00000000"},"chocolat item":{"6":"8800.00000000","7":"19300.00000000"},"CLEANING ITEM":{"6":"740.00000000","7":"5060.00000000"},"cologne item":{"6":"380.00000000","7":"350.00000000"},"CREAM":{"6":"200.00000000","7":"2260.00000000"},"DETERGENT ITEM":{"6":"150.00000000","7":"1045.00000000"},"FOOD ITEMS":{"6":"57210.00000000","7":"169812.45000000"},"GROCERY":{"6":"2436.00000000","7":"6480.00000000"},"HOME CARE":{"7":"6995.00000000"},"ICE CREAM CONE":{"6":"10440.00000000","7":"2720.00000000"},"ICE CREAM ITEM":{"6":"21430.00000000","7":"85740.00000000"},"incense sticks":{"7":"1710.00000000"},"KITCHEN ITEM":{"6":"650.00000000","7":"1100.00000000"},"MATCHES":{"6":"380.00000000","7":"1180.00000000"},"MILK POWDER":{"6":"1540.00000000","7":"27450.00000000"},"oil items":{"7":"2200.00000000"},"SAUSAGE":{"7":"14445.00000000"},"SHAMPOO":{"6":"2070.00000000","7":"5610.00000000"},"Soap":{"6":"7665.00000000","7":"29705.00000000"},"SPICES":{"6":"4270.00000000","7":"40920.00000000"},"SWEET":{"7":"550.00000000"},"syrup item":{"6":"1150.00000000","7":"4830.00000000"},"TEA ITEM":{"6":"2685.00000000","7":"10935.00000000"},"TOFFEE":{"6":"410.00000000","7":"2195.00000000"},"toothbrush":{"6":"640.00000000","7":"3290.00000000"},"toothpaste":{"6":"1530.00000000","7":"11625.00000000"},"YOGHURT":{"6":"1920.00000000","7":"34080.00000000"}}  
[2026-07-20 18:09:42] live.INFO: Today's sales for date 2026-07-20: 34148.4600  
[2026-07-20 18:09:42] live.INFO: Today's purchases for date 2026-07-20: 0  
[2026-07-20 18:09:42] live.INFO: Today's expenses for date 2026-07-20: 0  
[2026-07-20 18:09:42] live.INFO: === CALCULATING CASH IN HAND FOR DATE: 2026-07-20 ===  
[2026-07-20 18:09:42] live.INFO: Cash in hand calculated for 2026-07-20: 1337734.3300  
[2026-07-20 18:09:42] live.INFO: === CALCULATING BANK BALANCE FOR DATE: 2026-07-20 ===  
[2026-07-20 18:09:42] live.INFO: Bank balance calculated for 2026-07-20: 13033.0000  
[2026-07-20 18:09:42] live.INFO: Today's collections for date 2026-07-20: 34148.4600  
[2026-07-20 18:09:42] live.INFO: Calculating opening balance for date 2026-07-20, using previous date: 2026-07-19  
[2026-07-20 18:09:42] live.INFO: === CALCULATING CASH IN HAND FOR DATE: 2026-07-19 ===  
[2026-07-20 18:09:42] live.INFO: Cash in hand calculated for 2026-07-19: 1303585.8700  
[2026-07-20 18:09:42] live.INFO: === CALCULATING BANK BALANCE FOR DATE: 2026-07-19 ===  
[2026-07-20 18:09:42] live.INFO: Bank balance calculated for 2026-07-19: 13033.0000  
[2026-07-20 18:09:42] live.INFO: === DAILY REPORT DEBUG END ===  
[2026-07-20 18:09:42] live.INFO: Original end_date from request: 20/07/2026  
[2026-07-20 18:09:42] live.INFO: Date converted manually from DD/MM/YYYY to: 2026-07-20  
[2026-07-20 18:09:42] live.INFO: Final parameters - Date: 2026-07-20, Location: null, Business: 1  
[2026-07-20 18:09:42] live.INFO: === SALES BREAKDOWN METHOD START ===  
[2026-07-20 18:09:42] live.INFO: Parameters - Business ID: 1, Date: 2026-07-20, Location: null  
[2026-07-20 18:09:42] live.INFO: Base query built for business 1, date 2026-07-20  
[2026-07-20 18:09:42] live.INFO: Final SQL query: select * from `transactions` where `business_id` = ? and `type` = ? and `status` = ? and date(`transaction_date`) = ?  
[2026-07-20 18:09:42] live.INFO: Query bindings: ["1","sell","final","2026-07-20"]  
[2026-07-20 18:09:42] live.INFO: Total transactions found: 73  
[2026-07-20 18:09:42] live.INFO: Raw SQL result: {"count":"73","subtotal":"34148.4600","tax":"0.0000","discount":"0.0000","total":"34148.4600","paid_amount":"34148.4600","due_amount":"0.0000","partial_amount":"0.0000"}  
[2026-07-20 18:09:42] live.INFO: Final processed result: {"count":73,"subtotal":34148.46,"tax":0,"discount":0,"total":34148.46,"paid_amount":34148.46,"due_amount":0,"partial_amount":0}  
[2026-07-20 18:09:42] live.INFO: === SALES BREAKDOWN METHOD END ===  
[2026-07-20 18:09:42] live.INFO: === GETTING MONTHLY CASH BREAKDOWN UP TO DATE: 2026-07-20 ===  
[2026-07-20 18:09:42] live.INFO: Monthly cash breakdown calculated: [{"month":"2026-07","month_name":"July 2026","transaction_count":2374,"net_cash_flow":1120711.88,"running_total":1337734.3299999998},{"month":"2026-06","month_name":"June 2026","transaction_count":418,"net_cash_flow":217022.45,"running_total":217022.45}]