==== Brand Analytics Final Hotfix v2 test results ====

==== BA-14 price-volume-mix ====
{"ok":true,"data":{"comparison_sales":2340906670668,"price_effect":283606865481.2236,"volume_effect":-506773347906.7769,"mix_effect":-60248994207.44672,"new_products_effect":850031710,"discontinued_products_effect":-1836912700,"current_sales":2056504313045,"reconciliation_difference":0,"method":"laspeyres_v1","method_details":{"price_effect":"sum(current_qty * (current_unit_price - comparison_unit_price)) for common products","volume_effect":"(current_common_qty - comparison_common_qty) * comparison_common_weighted_average_price","mix_effect":"quantity_at_comparison_price_effect - volume_effect; quantity-zero monetary residuals are included here","new_products_effect":"current minus comparison sales for products without a comparison unit price","discontinued_products_effect":"current minus comparison sales for products without a current unit price"},"product_counts":{"common":546,"new":22,"discontinued":54}},"meta":{"request_id":"aa71a4de-8876-4153-b40a-072c68b3a6b8","generated_at":"2026-08-26T14:58:52+03:30","data_updated_at":"2026-07-31T23:59:59+03:30","currency":"IRR","timezone":"Asia/Tehran","applied_filters":{"brand_id":6514,"period":{"from":"2026-06-01","to":"2026-07-31","granularity":"month"},"comparison":{"type":"previous_period","from":"2026-04-01","to":"2026-05-31"},"filters":{"product_group_ids":[],"category_ids":[],"product_ids":[],"store_ids":[],"provinces":[],"cities":[],"regions":[],"store_grades":[],"channels":[]}},"warnings":[]}}

==== LOOKUP brands by ID ====
{"ok":true,"data":{"items":[{"id":6514,"name":"کاله","code":"6514","active":true}],"page":1,"page_size":10,"total_items":1,"total_pages":1},"meta":{"request_id":"4cdb5926-d639-425e-b1ba-a7ca92ffae2d","generated_at":"2026-08-26T14:59:13+03:30","data_updated_at":"2026-07-31T23:59:59+03:30","currency":"IRR","timezone":"Asia/Tehran","applied_filters":{},"warnings":[]}}

==== LOOKUP product-groups ====
{"ok":true,"data":{"items":[{"id":1,"name":"چاشنی و افزودنی ها","code":"1","active":true},{"id":2,"name":"چای ، قهوه ، محصولات پودری","code":"2","active":true},{"id":3,"name":"خشکبار و تنقلات","code":"3","active":true},{"id":4,"name":"خواروبار و کالای اساسی","code":"4","active":true},{"id":5,"name":"دخانیات","code":"5","active":true},{"id":6,"name":"دسر و شیرینی","code":"6","active":true},{"id":7,"name":"شوینده و بهداشتی","code":"7","active":true},{"id":8,"name":"لبنیات","code":"8","active":true},{"id":9,"name":"لوازم آشپزخانه ، مصرفی و فرهنگی","code":"9","active":true},{"id":10,"name":"نوشیدنی","code":"10","active":true},{"id":11,"name":"کمپوت و کنسرو","code":"11","active":true},{"id":12,"name":"یخچالی و انجمادی","code":"12","active":true}]},"meta":{"request_id":"2804e0fa-2ba0-4da7-b61b-110a5527cb1d","generated_at":"2026-08-26T14:59:14+03:30","data_updated_at":"2026-07-31T23:59:59+03:30","currency":"IRR","timezone":"Asia/Tehran","applied_filters":{},"warnings":[]}}

==== LOOKUP categories ====
<br />
<b>Fatal error</b>:  Maximum execution time of 120 seconds exceeded in <b>C:\xampp\htdocs\dashboard-project\src\helpers\BrandAnalytics.php</b> on line <b>685</b><br />


==== LOOKUP cities ====
{"ok":true,"data":{"items":[{"id":"آبعلی","name":"آبعلی","code":"آبعلی","active":true,"parent_id":"تهران"},{"id":"آذرشهر","name":"آذرشهر","code":"آذرشهر","active":true,"parent_id":"اذربایجان شرقی"},{"id":"احمد آباد","name":"احمد آباد","code":"احمد آباد","active":true,"parent_id":"تهران"},{"id":"اردبیل","name":"اردبیل","code":"اردبیل","active":true,"parent_id":"اردبیل"},{"id":"ارومیه","name":"ارومیه","code":"ارومیه","active":true,"parent_id":"اذربایجان غربی"},{"id":"اسد آباد","name":"اسد آباد","code":"اسد آباد","active":true,"parent_id":"تهران"},{"id":"اسلامشهر","name":"اسلامشهر","code":"اسلامشهر","active":true,"parent_id":"تهران"},{"id":"اسکو","name":"اسکو","code":"اسکو","active":true,"parent_id":"اذربایجان شرقی"},{"id":"اصفهان","name":"اصفهان","code":"اصفهان","active":true,"parent_id":"اصفهان"},{"id":"اهر","name":"اهر","code":"اهر","active":true,"parent_id":"اذربایجان شرقی"},{"id":"اهواز","name":"اهواز","code":"اهواز","active":true,"parent_id":"خوزستان"},{"id":"باروق","name":"باروق","code":"باروق","active":true,"parent_id":"اذربایجان غربی"},{"id":"باسمنج","name":"باسمنج","code":"باسمنج","active":true,"parent_id":"اذربایجان شرقی"},{"id":"بروجرد","name":"بروجرد","code":"بروجرد","active":true,"parent_id":"لرستان"},{"id":"بستان آباد","name":"بستان آباد","code":"بستان آباد","active":true,"parent_id":"اذربایجان شرقی"},{"id":"بناب","name":"بناب","code":"بناب","active":true,"parent_id":"اذربایجان شرقی"},{"id":"بندر شرفخانه","name":"بندر شرفخانه","code":"بندر شرفخانه","active":true,"parent_id":"اذربایجان شرقی"},{"id":"بهارستان","name":"بهارستان","code":"بهارستان","active":true,"parent_id":"تهران"},{"id":"بهاریستان","name":"بهاریستان","code":"بهاریستان","active":true,"parent_id":"تهران"},{"id":"بومهن","name":"بومهن","code":"بومهن","active":true,"parent_id":"تهران"},{"id":"بوکان","name":"بوکان","code":"بوکان","active":true,"parent_id":"اذربایجان غربی"},{"id":"پاکدشت","name":"پاکدشت","code":"پاکدشت","active":true,"parent_id":"تهران"},{"id":"پردیس","name":"پردیس","code":"پردیس","active":true,"parent_id":"تهران"},{"id":"پرند","name":"پرند","code":"پرند","active":true,"parent_id":"تهران"},{"id":"تبریز","name":"تبریز","code":"تبریز","active":true,"parent_id":"اذربایجان شرقی"},{"id":"تسوج","name":"تسوج","code":"تسوج","active":true,"parent_id":"اذربایجان شرقی"},{"id":"تهران","name":"تهران","code":"تهران","active":true,"parent_id":"تهران"},{"id":"تهران دشت","name":"تهران دشت","code":"تهران دشت","active":true,"parent_id":"البرز"},{"id":"تکاب","name":"تکاب","code":"تکاب","active":true,"parent_id":"اذربایجان غربی"},{"id":"جلفا","name":"جلفا","code":"جلفا","active":true,"parent_id":"اذربایجان شرقی"},{"id":"چهاربرج","name":"چهاربرج","code":"چهاربرج","active":true,"parent_id":"اذربایجان غربی"},{"id":"چهاردانگه","name":"چهاردانگه","code":"چهاردانگه","active":true,"parent_id":"تهران"},{"id":"حصارک","name":"حصارک","code":"حصارک","active":true,"parent_id":"تهران"},{"id":"خ المهدی","name":"خ المهدی","code":"خ المهدی","active":true,"parent_id":"اذربایجان غربی"},{"id":"خ8شهریور","name":"خ8شهریور","code":"خ8شهریور","active":true,"parent_id":"اذربایجان غربی"},{"id":"خامنه","name":"خامنه","code":"خامنه","active":true,"parent_id":"اذربایجان شرقی"},{"id":"خاوران","name":"خاوران","code":"خاوران","active":true,"parent_id":"اذربایجان شرقی"},{"id":"خسرو شاه","name":"خسرو شاه","code":"خسرو شاه","active":true,"parent_id":"اذربایجان شرقی"},{"id":"دماوند","name":"دماوند","code":"دماوند","active":true,"parent_id":"تهران"},{"id":"رباط کریم","name":"رباط کریم","code":"رباط کریم","active":true,"parent_id":"تهران"},{"id":"رودهن","name":"رودهن","code":"رودهن","active":true,"parent_id":"تهران"},{"id":"ساوه","name":"ساوه","code":"ساوه","active":true,"parent_id":"مرکزی"},{"id":"سردرود","name":"سردرود","code":"سردرود","active":true,"parent_id":"اذربایجان شرقی"},{"id":"سرعین","name":"سرعین","code":"سرعین","active":true,"parent_id":"اردبیل"},{"id":"سقز","name":"سقز","code":"سقز","active":true,"parent_id":"کردستان"},{"id":"سلطان آباد","name":"سلطان آباد","code":"سلطان آباد","active":true,"parent_id":"تهران"},{"id":"سلماس","name":"سلماس","code":"سلماس","active":true,"parent_id":"اذربایجان غربی"},{"id":"سلمان شهر","name":"سلمان شهر","code":"سلمان شهر","active":true,"parent_id":"مازندران"},{"id":"شاهین دژ","name":"شاهین دژ","code":"شاهین دژ","active":true,"parent_id":"اذربایجان غربی"},{"id":"شبستر","name":"شبستر","code":"شبستر","active":true,"parent_id":"اذربایجان شرقی"},{"id":"شمیرانات","name":"شمیرانات","code":"شمیرانات","active":true,"parent_id":"تهران"},{"id":"شند آباد","name":"شند آباد","code":"شند آباد","active":true,"parent_id":"اذربایجان شرقی"},{"id":"شهر قدس","name":"شهر قدس","code":"شهر قدس","active":true,"parent_id":"تهران"},{"id":"شهرقدس","name":"شهرقدس","code":"شهرقدس","active":true,"parent_id":"تهران"},{"id":"شهریار","name":"شهریار","code":"شهریار","active":true,"parent_id":"تهران"},{"id":"صالحیه","name":"صالحیه","code":"صالحیه","active":true,"parent_id":"تهران"},{"id":"صوفیان","name":"صوفیان","code":"صوفیان","active":true,"parent_id":"اذربایجان شرقی"},{"id":"عجب شیر","name":"عجب شیر","code":"عجب شیر","active":true,"parent_id":"اذربایجان شرقی"},{"id":"علیشاه","name":"علیشاه","code":"علیشاه","active":true,"parent_id":"اذربایجان شرقی"},{"id":"فردیس","name":"فردیس","code":"فردیس","active":true,"parent_id":"البرز"},{"id":"قائمیه","name":"قائمیه","code":"قائمیه","active":true,"parent_id":"تهران"},{"id":"قرچک","name":"قرچک","code":"قرچک","active":true,"parent_id":"تهران"},{"id":"قم","name":"قم","code":"قم","active":true,"parent_id":"قم"},{"id":"گرمدره","name":"گرمدره","code":"گرمدره","active":true,"parent_id":"البرز"},{"id":"گلستان","name":"گلستان","code":"گلستان","active":true,"parent_id":"تهران"},{"id":"لواسان","name":"لواسان","code":"لواسان","active":true,"parent_id":"تهران"},{"id":"لیان","name":"لیان","code":"لیان","active":true,"parent_id":"اذربایجان شرقی"},{"id":"مارلیک","name":"مارلیک","code":"مارلیک","active":true,"parent_id":"تهران"},{"id":"ماهدشت","name":"ماهدشت","code":"ماهدشت","active":true,"parent_id":"البرز"},{"id":"مرتضی گرد","name":"مرتضی گرد","code":"مرتضی گرد","active":true,"parent_id":"تهران"},{"id":"مرند","name":"مرند","code":"مرند","active":true,"parent_id":"اذربایجان شرقی"},{"id":"مشهد","name":"مشهد","code":"مشهد","active":true,"parent_id":"خراسان"},{"id":"ملارد","name":"ملارد","code":"ملارد","active":true,"parent_id":"تهران"},{"id":"ملکان","name":"ملکان","code":"ملکان","active":true,"parent_id":"اذربایجان شرقی"},{"id":"میاندوآب","name":"میاندوآب","code":"میاندوآب","active":true,"parent_id":"اذربایجان غربی"},{"id":"میاندواب","name":"میاندواب","code":"میاندواب","active":true,"parent_id":"اذربایجان غربی"},{"id":"نسیم شهر","name":"نسیم شهر","code":"نسیم شهر","active":true,"parent_id":"تهران"},{"id":"نصیر آباد","name":"نصیر آباد","code":"نصیر آباد","active":true,"parent_id":"تهران"},{"id":"نصیر شهر","name":"نصیر شهر","code":"نصیر شهر","active":true,"parent_id":"تهران"},{"id":"نظرلو","name":"نظرلو","code":"نظرلو","active":true,"parent_id":"اذربایجان شرقی"},{"id":"نقده","name":"نقده","code":"نقده","active":true,"parent_id":"اذربایجان غربی"},{"id":"هادی شهر","name":"هادی شهر","code":"هادی شهر","active":true,"parent_id":"اذربایجان شرقی"},{"id":"هشترود","name":"هشترود","code":"هشترود","active":true,"parent_id":"اذربایجان شرقی"},{"id":"همدانک","name":"همدانک","code":"همدانک","active":true,"parent_id":"تهران"},{"id":"واوان","name":"واوان","code":"واوان","active":true,"parent_id":"تهران"},{"id":"وایقان","name":"وایقان","code":"وایقان","active":true,"parent_id":"اذربایجان شرقی"},{"id":"وجه آباد","name":"وجه آباد","code":"وجه آباد","active":true,"parent_id":"تهران"},{"id":"ورامین","name":"ورامین","code":"ورامین","active":true,"parent_id":"تهران"},{"id":"ولیعصر","name":"ولیعصر","code":"ولیعصر","active":true,"parent_id":"اذربایجان شرقی"},{"id":"کرج","name":"کرج","code":"کرج","active":true,"parent_id":"البرز"},{"id":"کشاورز","name":"کشاورز","code":"کشاورز","active":true,"parent_id":"اذربایجان غربی"},{"id":"کوزه کنان","name":"کوزه کنان","code":"کوزه کنان","active":true,"parent_id":"اذربایجان شرقی"},{"id":"کیش","name":"کیش","code":"کیش","active":true,"parent_id":"هرمزگان"}]},"meta":{"request_id":"307988b3-14a6-4852-b011-90a8b0104068","generated_at":"2026-08-26T15:01:14+03:30","data_updated_at":"2026-07-31T23:59:59+03:30","currency":"IRR","timezone":"Asia/Tehran","applied_filters":{},"warnings":[]}}

==== LOOKUP regions Tehran ====
{"ok":true,"data":{"items":[]},"meta":{"request_id":"a1be0d24-3542-48e2-821b-9b517d131e3d","generated_at":"2026-08-26T15:01:14+03:30","data_updated_at":"2026-07-31T23:59:59+03:30","currency":"IRR","timezone":"Asia/Tehran","applied_filters":{},"warnings":[]}}

==== LOOKUP store-grades ====
{"ok":true,"data":{"items":[{"id":"A+","name":"A+","code":"A+","active":true},{"id":"A","name":"A","code":"A","active":true},{"id":"B","name":"B","code":"B","active":true},{"id":"C","name":"C","code":"C","active":true}]},"meta":{"request_id":"ffa4c550-d1c4-41e2-8388-eb1422cf0ded","generated_at":"2026-08-26T15:01:14+03:30","data_updated_at":"2026-07-31T23:59:59+03:30","currency":"IRR","timezone":"Asia/Tehran","applied_filters":{},"warnings":[]}}

==== LOOKUP channels ====
{"ok":true,"data":{"items":[{"id":"online","name":"آنلاین","code":"online","active":true},{"id":"offline","name":"حضوری","code":"offline","active":true}]},"meta":{"request_id":"1a2b3acc-b196-44f2-adee-83a35eb73dc0","generated_at":"2026-08-26T15:01:14+03:30","data_updated_at":"2026-07-31T23:59:59+03:30","currency":"IRR","timezone":"Asia/Tehran","applied_filters":{},"warnings":[]}}

==== LOOKUP products by ID ====
{"ok":true,"data":{"items":[{"id":19441,"name":"ماست همزده کم چرب پروبیوتیک سون کاله 1.8 کیلوگرمی","code":"19441","active":true,"parent_id":8,"brand_id":6514}],"page":1,"page_size":10,"total_items":1,"total_pages":1},"meta":{"request_id":"8ed003eb-8371-4bb9-a2f6-a1f346403da0","generated_at":"2026-08-26T15:01:38+03:30","data_updated_at":"2026-07-31T23:59:59+03:30","currency":"IRR","timezone":"Asia/Tehran","applied_filters":{},"warnings":[]}}
