{"ts":"2026-05-07 11:29:02","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.name' in 'field list'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":105,"context":{"method":"App\\Api\\Repositories\\BaseRepository::query","table":"complaint","sql":"SELECT\r\n                    c.id,\r\n                    c.complaint_key,\r\n                    c.id_shop,\r\n                    c.id_supplier,\r\n                    c.id_order,\r\n                    c.reported_at,\r\n                    c.status,\r\n                    c.supplier_sku,\r\n                    c.reason_code,\r\n                    c.qty,\r\n                    c.description,\r\n                    mat.name AS material_name,\r\n                    fs.name AS shop_name,\r\n                    ord.order_key,\n                    u.name AS unit_name\r\n                FROM complaint c\r\n                LEFT JOIN material mat ON mat.id = c.id_material\r\n                LEFT JOIN franchisee_shop fs ON fs.id = c.id_shop\r\n                LEFT JOIN material_order ord ON ord.id = c.id_order\r\n                WHERE c.id_supplier = :supplierId AND c.status IN ('NEW','IN_REVIEW')\r\n                ORDER BY c.reported_at DESC","params":{"supplierId":1}}}
{"ts":"2026-05-07 15:23:59","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.name' in 'field list'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":105,"context":{"method":"App\\Api\\Repositories\\BaseRepository::query","table":"complaint","sql":"SELECT\r\n                    c.id,\r\n                    c.complaint_key,\r\n                    c.id_shop,\r\n                    c.id_supplier,\r\n                    c.id_order,\r\n                    c.reported_at,\r\n                    c.status,\r\n                    c.supplier_sku,\r\n                    c.reason_code,\r\n                    c.qty,\r\n                    c.description,\r\n                    mat.name AS material_name,\r\n                    fs.name AS shop_name,\r\n                    ord.order_key,\n                    u.name AS unit_name\r\n                FROM complaint c\r\n                LEFT JOIN material mat ON mat.id = c.id_material\r\n                LEFT JOIN franchisee_shop fs ON fs.id = c.id_shop\r\n                LEFT JOIN material_order ord ON ord.id = c.id_order\r\n                WHERE c.id_supplier = :supplierId AND c.status IN ('NEW','IN_REVIEW')\r\n                ORDER BY c.reported_at DESC","params":{"supplierId":1}}}
{"ts":"2026-05-07 15:39:45","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.name' in 'field list'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":105,"context":{"method":"App\\Api\\Repositories\\BaseRepository::query","table":"complaint","sql":"SELECT\r\n                    c.id,\r\n                    c.complaint_key,\r\n                    c.id_shop,\r\n                    c.id_supplier,\r\n                    c.id_order,\r\n                    c.reported_at,\r\n                    c.status,\r\n                    c.supplier_sku,\r\n                    c.reason_code,\r\n                    c.qty,\r\n                    c.description,\r\n                    mat.name AS material_name,\r\n                    fs.name AS shop_name,\r\n                    ord.order_key,\n                    u.name AS unit_name\r\n                FROM complaint c\r\n                LEFT JOIN material mat ON mat.id = c.id_material\r\n                LEFT JOIN franchisee_shop fs ON fs.id = c.id_shop\r\n                LEFT JOIN material_order ord ON ord.id = c.id_order\r\n                WHERE c.id_supplier = :supplierId AND c.status IN ('NEW','IN_REVIEW')\r\n                ORDER BY c.reported_at DESC","params":{"supplierId":1}}}
{"ts":"2026-05-07 15:39:46","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.name' in 'field list'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":105,"context":{"method":"App\\Api\\Repositories\\BaseRepository::query","table":"complaint","sql":"SELECT\r\n                    c.id,\r\n                    c.complaint_key,\r\n                    c.id_shop,\r\n                    c.id_supplier,\r\n                    c.id_order,\r\n                    c.reported_at,\r\n                    c.status,\r\n                    c.supplier_sku,\r\n                    c.reason_code,\r\n                    c.qty,\r\n                    c.description,\r\n                    mat.name AS material_name,\r\n                    fs.name AS shop_name,\r\n                    ord.order_key,\n                    u.name AS unit_name\r\n                FROM complaint c\r\n                LEFT JOIN material mat ON mat.id = c.id_material\r\n                LEFT JOIN franchisee_shop fs ON fs.id = c.id_shop\r\n                LEFT JOIN material_order ord ON ord.id = c.id_order\r\n                WHERE c.id_supplier = :supplierId\r\n                ORDER BY c.reported_at DESC","params":{"supplierId":1}}}
{"ts":"2026-05-07 15:39:46","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.name' in 'field list'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":105,"context":{"method":"App\\Api\\Repositories\\BaseRepository::query","table":"complaint","sql":"SELECT\r\n                    c.id,\r\n                    c.complaint_key,\r\n                    c.id_shop,\r\n                    c.id_supplier,\r\n                    c.id_order,\r\n                    c.reported_at,\r\n                    c.status,\r\n                    c.supplier_sku,\r\n                    c.reason_code,\r\n                    c.qty,\r\n                    c.description,\r\n                    mat.name AS material_name,\r\n                    fs.name AS shop_name,\r\n                    ord.order_key,\n                    u.name AS unit_name\r\n                FROM complaint c\r\n                LEFT JOIN material mat ON mat.id = c.id_material\r\n                LEFT JOIN franchisee_shop fs ON fs.id = c.id_shop\r\n                LEFT JOIN material_order ord ON ord.id = c.id_order\r\n                WHERE c.id_supplier = :supplierId AND c.status IN ('NEW','IN_REVIEW')\r\n                ORDER BY c.reported_at DESC","params":{"supplierId":1}}}
{"ts":"2026-05-07 15:39:48","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.name' in 'field list'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":105,"context":{"method":"App\\Api\\Repositories\\BaseRepository::query","table":"complaint","sql":"SELECT\r\n                    c.id,\r\n                    c.complaint_key,\r\n                    c.id_shop,\r\n                    c.id_supplier,\r\n                    c.id_order,\r\n                    c.reported_at,\r\n                    c.status,\r\n                    c.supplier_sku,\r\n                    c.reason_code,\r\n                    c.qty,\r\n                    c.description,\r\n                    mat.name AS material_name,\r\n                    fs.name AS shop_name,\r\n                    ord.order_key,\n                    u.name AS unit_name\r\n                FROM complaint c\r\n                LEFT JOIN material mat ON mat.id = c.id_material\r\n                LEFT JOIN franchisee_shop fs ON fs.id = c.id_shop\r\n                LEFT JOIN material_order ord ON ord.id = c.id_order\r\n                WHERE c.id_supplier = :supplierId AND c.status IN ('NEW')\r\n                ORDER BY c.reported_at DESC","params":{"supplierId":1}}}
{"ts":"2026-05-07 15:39:48","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.name' in 'field list'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":105,"context":{"method":"App\\Api\\Repositories\\BaseRepository::query","table":"complaint","sql":"SELECT\r\n                    c.id,\r\n                    c.complaint_key,\r\n                    c.id_shop,\r\n                    c.id_supplier,\r\n                    c.id_order,\r\n                    c.reported_at,\r\n                    c.status,\r\n                    c.supplier_sku,\r\n                    c.reason_code,\r\n                    c.qty,\r\n                    c.description,\r\n                    mat.name AS material_name,\r\n                    fs.name AS shop_name,\r\n                    ord.order_key,\n                    u.name AS unit_name\r\n                FROM complaint c\r\n                LEFT JOIN material mat ON mat.id = c.id_material\r\n                LEFT JOIN franchisee_shop fs ON fs.id = c.id_shop\r\n                LEFT JOIN material_order ord ON ord.id = c.id_order\r\n                WHERE c.id_supplier = :supplierId AND c.status IN ('NEW','IN_REVIEW')\r\n                ORDER BY c.reported_at DESC","params":{"supplierId":1}}}
{"ts":"2026-05-07 15:39:50","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.name' in 'field list'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":105,"context":{"method":"App\\Api\\Repositories\\BaseRepository::query","table":"complaint","sql":"SELECT\r\n                    c.id,\r\n                    c.complaint_key,\r\n                    c.id_shop,\r\n                    c.id_supplier,\r\n                    c.id_order,\r\n                    c.reported_at,\r\n                    c.status,\r\n                    c.supplier_sku,\r\n                    c.reason_code,\r\n                    c.qty,\r\n                    c.description,\r\n                    mat.name AS material_name,\r\n                    fs.name AS shop_name,\r\n                    ord.order_key,\n                    u.name AS unit_name\r\n                FROM complaint c\r\n                LEFT JOIN material mat ON mat.id = c.id_material\r\n                LEFT JOIN franchisee_shop fs ON fs.id = c.id_shop\r\n                LEFT JOIN material_order ord ON ord.id = c.id_order\r\n                WHERE c.id_supplier = :supplierId AND c.status IN ('IN_REVIEW')\r\n                ORDER BY c.reported_at DESC","params":{"supplierId":1}}}
{"ts":"2026-05-07 15:39:50","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.name' in 'field list'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":105,"context":{"method":"App\\Api\\Repositories\\BaseRepository::query","table":"complaint","sql":"SELECT\r\n                    c.id,\r\n                    c.complaint_key,\r\n                    c.id_shop,\r\n                    c.id_supplier,\r\n                    c.id_order,\r\n                    c.reported_at,\r\n                    c.status,\r\n                    c.supplier_sku,\r\n                    c.reason_code,\r\n                    c.qty,\r\n                    c.description,\r\n                    mat.name AS material_name,\r\n                    fs.name AS shop_name,\r\n                    ord.order_key,\n                    u.name AS unit_name\r\n                FROM complaint c\r\n                LEFT JOIN material mat ON mat.id = c.id_material\r\n                LEFT JOIN franchisee_shop fs ON fs.id = c.id_shop\r\n                LEFT JOIN material_order ord ON ord.id = c.id_order\r\n                WHERE c.id_supplier = :supplierId AND c.status IN ('NEW','IN_REVIEW')\r\n                ORDER BY c.reported_at DESC","params":{"supplierId":1}}}
{"ts":"2026-05-07 15:39:52","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.name' in 'field list'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":105,"context":{"method":"App\\Api\\Repositories\\BaseRepository::query","table":"complaint","sql":"SELECT\r\n                    c.id,\r\n                    c.complaint_key,\r\n                    c.id_shop,\r\n                    c.id_supplier,\r\n                    c.id_order,\r\n                    c.reported_at,\r\n                    c.status,\r\n                    c.supplier_sku,\r\n                    c.reason_code,\r\n                    c.qty,\r\n                    c.description,\r\n                    mat.name AS material_name,\r\n                    fs.name AS shop_name,\r\n                    ord.order_key,\n                    u.name AS unit_name\r\n                FROM complaint c\r\n                LEFT JOIN material mat ON mat.id = c.id_material\r\n                LEFT JOIN franchisee_shop fs ON fs.id = c.id_shop\r\n                LEFT JOIN material_order ord ON ord.id = c.id_order\r\n                WHERE c.id_supplier = :supplierId AND c.status IN ('ACCEPTED')\r\n                ORDER BY c.reported_at DESC","params":{"supplierId":1}}}
{"ts":"2026-05-07 15:39:52","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.name' in 'field list'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":105,"context":{"method":"App\\Api\\Repositories\\BaseRepository::query","table":"complaint","sql":"SELECT\r\n                    c.id,\r\n                    c.complaint_key,\r\n                    c.id_shop,\r\n                    c.id_supplier,\r\n                    c.id_order,\r\n                    c.reported_at,\r\n                    c.status,\r\n                    c.supplier_sku,\r\n                    c.reason_code,\r\n                    c.qty,\r\n                    c.description,\r\n                    mat.name AS material_name,\r\n                    fs.name AS shop_name,\r\n                    ord.order_key,\n                    u.name AS unit_name\r\n                FROM complaint c\r\n                LEFT JOIN material mat ON mat.id = c.id_material\r\n                LEFT JOIN franchisee_shop fs ON fs.id = c.id_shop\r\n                LEFT JOIN material_order ord ON ord.id = c.id_order\r\n                WHERE c.id_supplier = :supplierId AND c.status IN ('NEW','IN_REVIEW')\r\n                ORDER BY c.reported_at DESC","params":{"supplierId":1}}}
{"ts":"2026-05-07 15:39:53","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.name' in 'field list'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":105,"context":{"method":"App\\Api\\Repositories\\BaseRepository::query","table":"complaint","sql":"SELECT\r\n                    c.id,\r\n                    c.complaint_key,\r\n                    c.id_shop,\r\n                    c.id_supplier,\r\n                    c.id_order,\r\n                    c.reported_at,\r\n                    c.status,\r\n                    c.supplier_sku,\r\n                    c.reason_code,\r\n                    c.qty,\r\n                    c.description,\r\n                    mat.name AS material_name,\r\n                    fs.name AS shop_name,\r\n                    ord.order_key,\n                    u.name AS unit_name\r\n                FROM complaint c\r\n                LEFT JOIN material mat ON mat.id = c.id_material\r\n                LEFT JOIN franchisee_shop fs ON fs.id = c.id_shop\r\n                LEFT JOIN material_order ord ON ord.id = c.id_order\r\n                WHERE c.id_supplier = :supplierId AND c.status IN ('REJECTED')\r\n                ORDER BY c.reported_at DESC","params":{"supplierId":1}}}
{"ts":"2026-05-07 15:39:53","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.name' in 'field list'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":105,"context":{"method":"App\\Api\\Repositories\\BaseRepository::query","table":"complaint","sql":"SELECT\r\n                    c.id,\r\n                    c.complaint_key,\r\n                    c.id_shop,\r\n                    c.id_supplier,\r\n                    c.id_order,\r\n                    c.reported_at,\r\n                    c.status,\r\n                    c.supplier_sku,\r\n                    c.reason_code,\r\n                    c.qty,\r\n                    c.description,\r\n                    mat.name AS material_name,\r\n                    fs.name AS shop_name,\r\n                    ord.order_key,\n                    u.name AS unit_name\r\n                FROM complaint c\r\n                LEFT JOIN material mat ON mat.id = c.id_material\r\n                LEFT JOIN franchisee_shop fs ON fs.id = c.id_shop\r\n                LEFT JOIN material_order ord ON ord.id = c.id_order\r\n                WHERE c.id_supplier = :supplierId AND c.status IN ('NEW','IN_REVIEW')\r\n                ORDER BY c.reported_at DESC","params":{"supplierId":1}}}
{"ts":"2026-05-07 15:42:44","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.name' in 'field list'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":105,"context":{"method":"App\\Api\\Repositories\\BaseRepository::query","table":"complaint","sql":"SELECT\r\n                    c.id,\r\n                    c.complaint_key,\r\n                    c.id_shop,\r\n                    c.id_supplier,\r\n                    c.id_order,\r\n                    c.reported_at,\r\n                    c.status,\r\n                    c.supplier_sku,\r\n                    c.reason_code,\r\n                    c.qty,\r\n                    c.description,\r\n                    mat.name AS material_name,\r\n                    fs.name AS shop_name,\r\n                    ord.order_key,\n                    u.name AS unit_name\r\n                FROM complaint c\r\n                LEFT JOIN material mat ON mat.id = c.id_material\r\n                LEFT JOIN franchisee_shop fs ON fs.id = c.id_shop\r\n                LEFT JOIN material_order ord ON ord.id = c.id_order\r\n                WHERE c.id_supplier = :supplierId AND c.status IN ('NEW','IN_REVIEW')\r\n                ORDER BY c.reported_at DESC","params":{"supplierId":1}}}
{"ts":"2026-05-07 15:42:46","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.name' in 'field list'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":105,"context":{"method":"App\\Api\\Repositories\\BaseRepository::query","table":"complaint","sql":"SELECT\r\n                    c.id,\r\n                    c.complaint_key,\r\n                    c.id_shop,\r\n                    c.id_supplier,\r\n                    c.id_order,\r\n                    c.reported_at,\r\n                    c.status,\r\n                    c.supplier_sku,\r\n                    c.reason_code,\r\n                    c.qty,\r\n                    c.description,\r\n                    mat.name AS material_name,\r\n                    fs.name AS shop_name,\r\n                    ord.order_key,\n                    u.name AS unit_name\r\n                FROM complaint c\r\n                LEFT JOIN material mat ON mat.id = c.id_material\r\n                LEFT JOIN franchisee_shop fs ON fs.id = c.id_shop\r\n                LEFT JOIN material_order ord ON ord.id = c.id_order\r\n                WHERE c.id_supplier = :supplierId\r\n                ORDER BY c.reported_at DESC","params":{"supplierId":1}}}
{"ts":"2026-05-07 15:42:46","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.name' in 'field list'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":105,"context":{"method":"App\\Api\\Repositories\\BaseRepository::query","table":"complaint","sql":"SELECT\r\n                    c.id,\r\n                    c.complaint_key,\r\n                    c.id_shop,\r\n                    c.id_supplier,\r\n                    c.id_order,\r\n                    c.reported_at,\r\n                    c.status,\r\n                    c.supplier_sku,\r\n                    c.reason_code,\r\n                    c.qty,\r\n                    c.description,\r\n                    mat.name AS material_name,\r\n                    fs.name AS shop_name,\r\n                    ord.order_key,\n                    u.name AS unit_name\r\n                FROM complaint c\r\n                LEFT JOIN material mat ON mat.id = c.id_material\r\n                LEFT JOIN franchisee_shop fs ON fs.id = c.id_shop\r\n                LEFT JOIN material_order ord ON ord.id = c.id_order\r\n                WHERE c.id_supplier = :supplierId AND c.status IN ('NEW','IN_REVIEW')\r\n                ORDER BY c.reported_at DESC","params":{"supplierId":1}}}
{"ts":"2026-05-07 15:42:47","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.name' in 'field list'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":105,"context":{"method":"App\\Api\\Repositories\\BaseRepository::query","table":"complaint","sql":"SELECT\r\n                    c.id,\r\n                    c.complaint_key,\r\n                    c.id_shop,\r\n                    c.id_supplier,\r\n                    c.id_order,\r\n                    c.reported_at,\r\n                    c.status,\r\n                    c.supplier_sku,\r\n                    c.reason_code,\r\n                    c.qty,\r\n                    c.description,\r\n                    mat.name AS material_name,\r\n                    fs.name AS shop_name,\r\n                    ord.order_key,\n                    u.name AS unit_name\r\n                FROM complaint c\r\n                LEFT JOIN material mat ON mat.id = c.id_material\r\n                LEFT JOIN franchisee_shop fs ON fs.id = c.id_shop\r\n                LEFT JOIN material_order ord ON ord.id = c.id_order\r\n                WHERE c.id_supplier = :supplierId\r\n                ORDER BY c.reported_at DESC","params":{"supplierId":1}}}
{"ts":"2026-05-07 15:42:47","type":"PDOException","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.name' in 'field list'","code":"42S22","file":"/var/www/html/api/core/BaseRepository.php","line":105,"context":{"method":"App\\Api\\Repositories\\BaseRepository::query","table":"complaint","sql":"SELECT\r\n                    c.id,\r\n                    c.complaint_key,\r\n                    c.id_shop,\r\n                    c.id_supplier,\r\n                    c.id_order,\r\n                    c.reported_at,\r\n                    c.status,\r\n                    c.supplier_sku,\r\n                    c.reason_code,\r\n                    c.qty,\r\n                    c.description,\r\n                    mat.name AS material_name,\r\n                    fs.name AS shop_name,\r\n                    ord.order_key,\n                    u.name AS unit_name\r\n                FROM complaint c\r\n                LEFT JOIN material mat ON mat.id = c.id_material\r\n                LEFT JOIN franchisee_shop fs ON fs.id = c.id_shop\r\n                LEFT JOIN material_order ord ON ord.id = c.id_order\r\n                WHERE c.id_supplier = :supplierId AND c.status IN ('NEW','IN_REVIEW')\r\n                ORDER BY c.reported_at DESC","params":{"supplierId":1}}}