2026-02-02 08:59:41|INFO|JwtAuthorizationFilter check|authorization:
2026-02-02 08:59:42|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5ODQ5NDA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDEwODYwN30.udovSQjJBZkryT826dt4VtGbMXHfmvi-WGaGOb3Fbrk
2026-02-02 08:59:42|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5ODQ5NDA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDEwODYwN30.udovSQjJBZkryT826dt4VtGbMXHfmvi-WGaGOb3Fbrk
2026-02-02 08:59:42|SQL|[#1 - 0.56ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtPaymentType.php(13):    App\Model\Sales\MtPaymentType::queryList()    u433670985_test.mt_payment_type    SELECT id,payment FROM mt_payment_type WHERE (Delete_Date is null);|{"request":{"service":"App.Sales_Sales.getPaymentTypeList"}}
2026-02-02 08:59:42|SQL|[#1 - 30.18ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(527):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,o.collection_flag,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total  FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE  o.cancel_flag != 1 and  o.state != -9 and  o.service !=1 and  o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-02-02 09:00:23|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5ODQ5NDA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDEwODYwN30.udovSQjJBZkryT826dt4VtGbMXHfmvi-WGaGOb3Fbrk
2026-02-02 09:00:23|SQL|[#1 - 0.43ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `collection_flag` = '2' WHERE (order_id = '226');|{"request":{"service":"App.Order_Order.updateCollectionFlag"}}
2026-02-02 09:00:23|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5ODQ5NDA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDEwODYwN30.udovSQjJBZkryT826dt4VtGbMXHfmvi-WGaGOb3Fbrk
2026-02-02 09:00:23|SQL|[#1 - 12.74ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(527):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,o.collection_flag,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total  FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE  o.cancel_flag != 1 and  o.state != -9 and  o.service !=1 and  o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-02-02 09:00:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5ODQ5NDA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDEwODYwN30.udovSQjJBZkryT826dt4VtGbMXHfmvi-WGaGOb3Fbrk
2026-02-02 09:00:27|SQL|[#1 - 0.49ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `collection_flag` = '3' WHERE (order_id = '225');|{"request":{"service":"App.Order_Order.updateCollectionFlag"}}
2026-02-02 09:00:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5ODQ5NDA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDEwODYwN30.udovSQjJBZkryT826dt4VtGbMXHfmvi-WGaGOb3Fbrk
2026-02-02 09:00:27|SQL|[#1 - 12.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(527):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,o.collection_flag,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total  FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE  o.cancel_flag != 1 and  o.state != -9 and  o.service !=1 and  o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-02-02 09:00:34|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5ODQ5NDA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDEwODYwN30.udovSQjJBZkryT826dt4VtGbMXHfmvi-WGaGOb3Fbrk
2026-02-02 09:00:34|SQL|[#1 - 2.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `collection_flag` = '0' WHERE (order_id = '225');|{"request":{"service":"App.Order_Order.updateCollectionFlag"}}
2026-02-02 09:00:34|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5ODQ5NDA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDEwODYwN30.udovSQjJBZkryT826dt4VtGbMXHfmvi-WGaGOb3Fbrk
2026-02-02 09:00:34|SQL|[#1 - 18.97ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(527):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,o.collection_flag,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total  FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE  o.cancel_flag != 1 and  o.state != -9 and  o.service !=1 and  o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-02-02 09:08:28|INFO|JwtAuthorizationFilter check|authorization:
2026-02-02 09:08:28|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5ODQ5NDA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDEwODYwN30.udovSQjJBZkryT826dt4VtGbMXHfmvi-WGaGOb3Fbrk
2026-02-02 09:08:28|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5ODQ5NDA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDEwODYwN30.udovSQjJBZkryT826dt4VtGbMXHfmvi-WGaGOb3Fbrk
2026-02-02 09:08:28|SQL|[#1 - 0.42ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtPaymentType.php(13):    App\Model\Sales\MtPaymentType::queryList()    u433670985_test.mt_payment_type    SELECT id,payment FROM mt_payment_type WHERE (Delete_Date is null);|{"request":{"service":"App.Sales_Sales.getPaymentTypeList"}}
2026-02-02 09:08:28|SQL|[#1 - 11.75ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(527):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,o.collection_flag,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total  FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE  o.cancel_flag != 1 and  o.state != -9 and  o.service !=1 and  o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-02-02 09:11:36|INFO|JwtAuthorizationFilter check|authorization:
2026-02-02 09:11:36|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5ODQ5NDA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDEwODYwN30.udovSQjJBZkryT826dt4VtGbMXHfmvi-WGaGOb3Fbrk
2026-02-02 09:11:36|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5ODQ5NDA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDEwODYwN30.udovSQjJBZkryT826dt4VtGbMXHfmvi-WGaGOb3Fbrk
2026-02-02 09:11:36|SQL|[#1 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtPaymentType.php(13):    App\Model\Sales\MtPaymentType::queryList()    u433670985_test.mt_payment_type    SELECT id,payment FROM mt_payment_type WHERE (Delete_Date is null);|{"request":{"service":"App.Sales_Sales.getPaymentTypeList"}}
2026-02-02 09:11:36|SQL|[#1 - 18.62ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(527):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,o.collection_flag,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total  FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE  o.cancel_flag != 1 and  o.state != -9 and  o.service !=1 and  o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-02-02 09:11:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5ODQ5NDA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDEwODYwN30.udovSQjJBZkryT826dt4VtGbMXHfmvi-WGaGOb3Fbrk
2026-02-02 09:11:41|SQL|[#1 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtPaymentType.php(13):    App\Model\Sales\MtPaymentType::queryList()    u433670985_test.mt_payment_type    SELECT id,payment FROM mt_payment_type WHERE (Delete_Date is null);|{"request":{"service":"App.Sales_Sales.getPaymentTypeList"}}
2026-02-02 09:11:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5ODQ5NDA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDEwODYwN30.udovSQjJBZkryT826dt4VtGbMXHfmvi-WGaGOb3Fbrk
2026-02-02 09:11:41|SQL|[#1 - 17.62ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(527):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,o.collection_flag,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total  FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE  o.cancel_flag != 1 and  o.state != -9 and  o.service !=1 and  o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-02-02 09:15:59|INFO|JwtAuthorizationFilter check|authorization:
2026-02-02 09:15:59|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5ODQ5NDA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDEwODYwN30.udovSQjJBZkryT826dt4VtGbMXHfmvi-WGaGOb3Fbrk
2026-02-02 09:15:59|SQL|[#1 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtPaymentType.php(13):    App\Model\Sales\MtPaymentType::queryList()    u433670985_test.mt_payment_type    SELECT id,payment FROM mt_payment_type WHERE (Delete_Date is null);|{"request":{"service":"App.Sales_Sales.getPaymentTypeList"}}
2026-02-02 09:15:59|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5ODQ5NDA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDEwODYwN30.udovSQjJBZkryT826dt4VtGbMXHfmvi-WGaGOb3Fbrk
2026-02-02 09:15:59|SQL|[#1 - 10.81ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(527):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,o.collection_flag,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total  FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE  o.cancel_flag != 1 and  o.state != -9 and  o.service !=1 and  o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-02-02 09:17:47|INFO|JwtAuthorizationFilter check|authorization:
2026-02-02 09:17:47|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5ODQ5NDA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDEwODYwN30.udovSQjJBZkryT826dt4VtGbMXHfmvi-WGaGOb3Fbrk
2026-02-02 09:17:47|SQL|[#1 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtPaymentType.php(13):    App\Model\Sales\MtPaymentType::queryList()    u433670985_test.mt_payment_type    SELECT id,payment FROM mt_payment_type WHERE (Delete_Date is null);|{"request":{"service":"App.Sales_Sales.getPaymentTypeList"}}
2026-02-02 09:17:47|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5ODQ5NDA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDEwODYwN30.udovSQjJBZkryT826dt4VtGbMXHfmvi-WGaGOb3Fbrk
2026-02-02 09:17:47|SQL|[#1 - 11.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(527):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,o.collection_flag,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total  FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE  o.cancel_flag != 1 and  o.state != -9 and  o.service !=1 and  o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-02-02 10:38:50|INFO|JwtAuthorizationFilter check|authorization:
2026-02-02 10:38:50|INFO|JwtAuthorizationFilter check|authorization:
2026-02-02 10:38:54|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5OTk5OTM0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDI1OTEzNH0.zDZU2RGv8tpdKt_mZIE740nbVBvYnmn2z-86Bpb9YEc
2026-02-02 10:38:54|SQL|[#1 - 1.38ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(534):    App\Model\Order\DatSyakenOrderList::listBySalesByYear()    u433670985_test.dat_syaken_order_list    select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total  from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-02-02 10:38:54|SQL|[#2 - 0.55ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13):    App\Model\Sales\MtMcBudget::getBudgetByYear()    u433670985_test.mt_mc_budget    SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-02-02 10:38:56|INFO|JwtAuthorizationFilter check|authorization:
2026-02-02 10:38:56|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5OTk5OTM0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDI1OTEzNH0.zDZU2RGv8tpdKt_mZIE740nbVBvYnmn2z-86Bpb9YEc
2026-02-02 10:38:56|SQL|[#1 - 0.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtPaymentType.php(13):    App\Model\Sales\MtPaymentType::queryList()    u433670985_test.mt_payment_type    SELECT id,payment FROM mt_payment_type WHERE (Delete_Date is null);|{"request":{"service":"App.Sales_Sales.getPaymentTypeList"}}
2026-02-02 10:38:56|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5OTk5OTM0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDI1OTEzNH0.zDZU2RGv8tpdKt_mZIE740nbVBvYnmn2z-86Bpb9YEc
2026-02-02 10:38:57|SQL|[#1 - 12.41ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(527):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,o.collection_flag,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total  FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE  o.cancel_flag != 1 and  o.state != -9 and  o.service !=1 and  o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-02-02 10:39:24|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5OTk5OTM0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDI1OTEzNH0.zDZU2RGv8tpdKt_mZIE740nbVBvYnmn2z-86Bpb9YEc
2026-02-02 10:39:24|SQL|[#1 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `collection_flag` = '' WHERE (order_id = '224');|{"request":{"service":"App.Order_Order.updateCollectionFlag"}}
2026-02-02 10:39:24|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5OTk5OTM0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDI1OTEzNH0.zDZU2RGv8tpdKt_mZIE740nbVBvYnmn2z-86Bpb9YEc
2026-02-02 10:39:24|SQL|[#1 - 18.93ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(527):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,o.collection_flag,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total  FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE  o.cancel_flag != 1 and  o.state != -9 and  o.service !=1 and  o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-02-02 16:52:37|INFO|JwtAuthorizationFilter check|authorization:
2026-02-02 16:52:37|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5OTk5OTM0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDI1OTEzNH0.zDZU2RGv8tpdKt_mZIE740nbVBvYnmn2z-86Bpb9YEc
2026-02-02 16:52:37|SQL|[#1 - 0.62ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtPaymentType.php(13):    App\Model\Sales\MtPaymentType::queryList()    u433670985_test.mt_payment_type    SELECT id,payment FROM mt_payment_type WHERE (Delete_Date is null);|{"request":{"service":"App.Sales_Sales.getPaymentTypeList"}}
2026-02-02 16:52:37|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5OTk5OTM0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDI1OTEzNH0.zDZU2RGv8tpdKt_mZIE740nbVBvYnmn2z-86Bpb9YEc
2026-02-02 16:52:37|SQL|[#1 - 28.45ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(527):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,o.collection_flag,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total  FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE  o.cancel_flag != 1 and  o.state != -9 and  o.service !=1 and  o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-02-02 16:52:42|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcwMDIyMzYyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDI4MTU2Mn0.g-1QLb09s2MGAErXHZPCV12Yze_BJ5LCo3fVVqIoEiM
2026-02-02 16:52:42|SQL|[#1 - 1.39ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(534):    App\Model\Order\DatSyakenOrderList::listBySalesByYear()    u433670985_test.dat_syaken_order_list    select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total  from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-02-02 16:52:42|SQL|[#2 - 0.82ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13):    App\Model\Sales\MtMcBudget::getBudgetByYear()    u433670985_test.mt_mc_budget    SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-02-02 16:52:43|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcwMDIyMzYzLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDI4MTU2M30.RV-pd6LmJsvIfVD_GZ59-PnwxWAlA70pRAiFztmPFqE
2026-02-02 16:52:43|SQL|[#1 - 1.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(534):    App\Model\Order\DatSyakenOrderList::listBySalesByYear()    u433670985_test.dat_syaken_order_list    select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total  from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-02-02 16:52:43|SQL|[#2 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13):    App\Model\Sales\MtMcBudget::getBudgetByYear()    u433670985_test.mt_mc_budget    SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-02-02 16:52:44|INFO|JwtAuthorizationFilter check|authorization:
2026-02-02 16:52:44|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcwMDIyMzYzLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDI4MTU2M30.RV-pd6LmJsvIfVD_GZ59-PnwxWAlA70pRAiFztmPFqE
2026-02-02 16:52:44|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcwMDIyMzYzLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDI4MTU2M30.RV-pd6LmJsvIfVD_GZ59-PnwxWAlA70pRAiFztmPFqE
2026-02-02 16:52:44|SQL|[#1 - 29.6ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(527):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,o.collection_flag,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total  FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE  o.cancel_flag != 1 and  o.state != -9 and  o.service !=1 and  o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-6-01', '2025-7-01', '2025-6-01', '2025-7-01', '2025-6-01', '2025-7-01', '2025-6-01', '2025-7-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-02-02 16:52:44|SQL|[#1 - 0.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtPaymentType.php(13):    App\Model\Sales\MtPaymentType::queryList()    u433670985_test.mt_payment_type    SELECT id,payment FROM mt_payment_type WHERE (Delete_Date is null);|{"request":{"service":"App.Sales_Sales.getPaymentTypeList"}}
2026-02-02 16:54:56|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcwMDIyNDk2LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDI4MTY5Nn0.bpgwy7Z9CPJLIcI9KBgyPgeHZPDUkGrcGIz6S-c6VqY
2026-02-02 16:54:56|SQL|[#1 - 1.46ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(534):    App\Model\Order\DatSyakenOrderList::listBySalesByYear()    u433670985_test.dat_syaken_order_list    select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total  from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-02-02 16:54:56|SQL|[#2 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13):    App\Model\Sales\MtMcBudget::getBudgetByYear()    u433670985_test.mt_mc_budget    SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-02-02 16:54:58|INFO|JwtAuthorizationFilter check|authorization:
2026-02-02 16:54:58|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcwMDIyNDk2LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDI4MTY5Nn0.bpgwy7Z9CPJLIcI9KBgyPgeHZPDUkGrcGIz6S-c6VqY
2026-02-02 16:54:58|SQL|[#1 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtPaymentType.php(13):    App\Model\Sales\MtPaymentType::queryList()    u433670985_test.mt_payment_type    SELECT id,payment FROM mt_payment_type WHERE (Delete_Date is null);|{"request":{"service":"App.Sales_Sales.getPaymentTypeList"}}
2026-02-02 16:54:58|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcwMDIyNDk2LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MDI4MTY5Nn0.bpgwy7Z9CPJLIcI9KBgyPgeHZPDUkGrcGIz6S-c6VqY
2026-02-02 16:54:58|SQL|[#1 - 13.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(527):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,o.collection_flag,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total  FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE  o.cancel_flag != 1 and  o.state != -9 and  o.service !=1 and  o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}