2026-01-27 16:05:43|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMTQzLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDM0M30.qgVB-vc_6Td8Dhe98gWxC_wkabZ0CNvboIQctOxSzLw 2026-01-27 16:05:43|SQL|[#1 - 0.75ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = '');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2026-01-27 16:05:54|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMTQzLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDM0M30.qgVB-vc_6Td8Dhe98gWxC_wkabZ0CNvboIQctOxSzLw 2026-01-27 16:05:54|SQL|[#1 - 1.94ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): 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-01-27 16:05:54|SQL|[#2 - 0.53ms - 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-01-27 16:05:55|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMTQzLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDM0M30.qgVB-vc_6Td8Dhe98gWxC_wkabZ0CNvboIQctOxSzLw 2026-01-27 16:05:55|SQL|[#1 - 15.13ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): 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-01-27 16:06:25|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMTQzLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDM0M30.qgVB-vc_6Td8Dhe98gWxC_wkabZ0CNvboIQctOxSzLw 2026-01-27 16:06:25|SQL|[#1 - 6.02ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): 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-01-27 16:06:43|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMTQzLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDM0M30.qgVB-vc_6Td8Dhe98gWxC_wkabZ0CNvboIQctOxSzLw 2026-01-27 16:06:43|SQL|[#1 - 5.61ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): 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-01-27 16:06:57|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMTQzLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDM0M30.qgVB-vc_6Td8Dhe98gWxC_wkabZ0CNvboIQctOxSzLw 2026-01-27 16:06:57|SQL|[#1 - 5ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): 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-01-27 16:07:38|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMTQzLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDM0M30.qgVB-vc_6Td8Dhe98gWxC_wkabZ0CNvboIQctOxSzLw 2026-01-27 16:07:38|SQL|[#1 - 7.76ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): 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-01-27 16:07:46|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMTQzLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDM0M30.qgVB-vc_6Td8Dhe98gWxC_wkabZ0CNvboIQctOxSzLw 2026-01-27 16:07:46|SQL|[#1 - 6.93ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): 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-01-27 16:07:50|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMTQzLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDM0M30.qgVB-vc_6Td8Dhe98gWxC_wkabZ0CNvboIQctOxSzLw 2026-01-27 16:07:50|INFO|getWholeBudgetbyMonth|detailImagePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/_2025-6_whole_budget.jpg 2026-01-27 16:07:50|INFO|savePdf|savePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/pdf/_2025-6_MC_合計請求書.pdf 2026-01-27 16:07:50|INFO|savePdf|images:["\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/zebra\/_2025-6_whole_budget.jpg"] 2026-01-27 16:08:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMTQzLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDM0M30.qgVB-vc_6Td8Dhe98gWxC_wkabZ0CNvboIQctOxSzLw 2026-01-27 16:08:41|SQL|[#1 - 8.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): 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-01-27 16:08:43|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzIyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDUyMn0.mZzsvYHnAtbNWPYIxj6Sjfkb8vBRuU8pELYMduTIRIE 2026-01-27 16:08:43|SQL|[#1 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = '22');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2026-01-27 16:08:44|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzIyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDUyMn0.mZzsvYHnAtbNWPYIxj6Sjfkb8vBRuU8pELYMduTIRIE 2026-01-27 16:08:44|SQL|[#1 - 1.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): 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-01-27 16:08:44|SQL|[#2 - 0.32ms - 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-01-27 16:08:44|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzI0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDUyNH0.btZbEhOCPjsBhrgQGqU24q_i1RqhTNtZnIjFYmyZOxM 2026-01-27 16:08:44|SQL|[#1 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = '18');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2026-01-27 16:08:44|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzI0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDUyNH0.btZbEhOCPjsBhrgQGqU24q_i1RqhTNtZnIjFYmyZOxM 2026-01-27 16:08:44|SQL|[#1 - 1.05ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): 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-01-27 16:08:44|SQL|[#2 - 0.25ms - 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-01-27 16:09:07|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzQ3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDU0N30.RbND8Tp4C-iEyl--6kQu-2PyZzUKsQeaOG6BQVBGa6s 2026-01-27 16:09:07|SQL|[#1 - 0.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = '18');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2026-01-27 16:09:07|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzQ3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDU0N30.RbND8Tp4C-iEyl--6kQu-2PyZzUKsQeaOG6BQVBGa6s 2026-01-27 16:09:07|SQL|[#1 - 1.44ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): 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-01-27 16:09:07|SQL|[#2 - 0.28ms - 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-01-27 16:09:15|INFO|mt_ss login|params:{"loginId":"mecha","pw":"6630_Mecha"} 2026-01-27 16:09:15|SQL|[#1 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Model/DataModel.php(165): PhalApi\Model\DataModel::getList() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (log_in = 'mecha') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.Login"}} 2026-01-27 16:09:15|INFO|mt_ss login|user:{"ID":22,"category":2,"ss_name":"MC","display_name":null,"en_name":"mecha","section":null,"section_id":4,"log_in":"mecha","pw":"6630_Mecha","manager_flag":0,"comp_1":null,"comp_2":null,"comp_3":null,"comp_4":null,"comp_5":null,"test_marketing_flag":null,"rent_a_car":null,"towing":null,"Delete_date":null,"line_openid":"4aHxP8CIZAnRDcfexnWoX90e7ij0gNefQCBYGemP2jZ","zip":null,"address":null,"telno":null,"faxno":null} 2026-01-27 16:09:15|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1769501355,"data":{"ssid":22}} 2026-01-27 16:09:15|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzU1LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Njk1MDQ5NTV9.9z3-BSPha1d3V3pIDlpNfSMT7vO4c5emoB1JVtmhj8k 2026-01-27 16:09:15|INFO|orderList|shopId: 2026-01-27 16:09:15|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1769501355,"data":{"ssid":22},"scopes":"role_access","exp":1769504955} 2026-01-27 16:09:15|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":22,"$freeword":null,"$orderId":null} 2026-01-27 16:09:15|INFO|getOrderList|担当者所属的店铺id:22 2026-01-27 16:09:15|SQL|[#1 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(169): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = 22);|{"request":{"service":"App.Order_Order.OrderList"}} 2026-01-27 16:09:15|SQL|[#2 - 0.18ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35): PhalApi\Model\DataModel::getList() u433670985_test.mt_ss SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}} 2026-01-27 16:09:15|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}] 2026-01-27 16:09:15|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]} 2026-01-27 16:09:15|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]} 2026-01-27 16:09:15|SQL|[#3 - 2.44ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(214): App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer() u433670985_test.dat_syaken_order_list SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT res.Order_ID,max(res.ss_storage_date) as ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12, -12)) AND (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22)));|{"request":{"service":"App.Order_Order.OrderList"}} 2026-01-27 16:09:15|INFO|getOrderList|查询结果条数:142 2026-01-27 16:09:15|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzU1LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Njk1MDQ5NTV9.9z3-BSPha1d3V3pIDlpNfSMT7vO4c5emoB1JVtmhj8k 2026-01-27 16:09:15|SQL|[#1 - 0.39ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(52): PhalApi\Model\DataModel::getList() u433670985_test.mt_ss SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.AdminUser_MtSsUser.GetAllSS"}} 2026-01-27 16:09:15|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzU1LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Njk1MDQ5NTV9.9z3-BSPha1d3V3pIDlpNfSMT7vO4c5emoB1JVtmhj8k 2026-01-27 16:09:15|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1769501355,"data":{"ssid":22},"scopes":"role_access","exp":1769504955} 2026-01-27 16:09:15|SQL|[#1 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(59): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = 22);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}} 2026-01-27 16:09:18|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzU1LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Njk1MDQ5NTV9.9z3-BSPha1d3V3pIDlpNfSMT7vO4c5emoB1JVtmhj8k 2026-01-27 16:09:18|INFO|getCarPhotos|params:{"orderId":"220"} 2026-01-27 16:09:18|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzU1LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Njk1MDQ5NTV9.9z3-BSPha1d3V3pIDlpNfSMT7vO4c5emoB1JVtmhj8k 2026-01-27 16:09:18|INFO|getOrderPdfs|params:{"orderId":"220"} 2026-01-27 16:09:18|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzU1LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Njk1MDQ5NTV9.9z3-BSPha1d3V3pIDlpNfSMT7vO4c5emoB1JVtmhj8k 2026-01-27 16:09:18|INFO|getOrderDetailInfo|orderId:220 2026-01-27 16:09:18|SQL|[#1 - 0.58ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38): App\Model\Order\DatSyakenOrderList::findOrderByOrderId() u433670985_test.dat_syaken_order_list SELECT * FROM dat_syaken_order_list WHERE (order_id = '220') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2026-01-27 16:09:18|SQL|[#2 - 0.56ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26): App\Model\Cars\DatCars::get() u433670985_test.dat_cars SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1489);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2026-01-27 16:09:18|SQL|[#3 - 0.75ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(25): PhalApi\Model\DataModel::getList() u433670985_test.dat_miscellaneous_expenses_detail SELECT * FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id = 496) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2026-01-27 16:09:18|SQL|[#4 - 1.71ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19): PhalApi\Model\DataModel::getList() u433670985_test.dat_repair_estimate_detail SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 522) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2026-01-27 16:09:18|SQL|[#5 - 0.6ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21): PhalApi\Model\DataModel::getList() u433670985_test.mt_discount SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2026-01-27 16:09:18|SQL|[#6 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(70): App\Model\Customer\DatCustomer::findCustomerByCustomerId() u433670985_test.dat_customer SELECT * FROM dat_customer WHERE (base_customerID = 7) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2026-01-27 16:09:18|SQL|[#7 - 0.63ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(78): App\Model\Repair\MtCustomerBasicFee::getById() u433670985_test.mt_customer_basic_fee SELECT * FROM mt_customer_basic_fee WHERE (id = 1) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2026-01-27 16:09:18|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzU1LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Njk1MDQ5NTV9.9z3-BSPha1d3V3pIDlpNfSMT7vO4c5emoB1JVtmhj8k 2026-01-27 16:09:18|SQL|[#1 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21): PhalApi\Model\DataModel::getList() u433670985_test.mt_discount SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.Discount_Discount.list"}} 2026-01-27 16:09:18|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzU1LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Njk1MDQ5NTV9.9z3-BSPha1d3V3pIDlpNfSMT7vO4c5emoB1JVtmhj8k 2026-01-27 16:09:18|INFO|viewImg|params:{"path":"\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/cars\/","fileName":"220_1748053751851_car.jpg"} 2026-01-27 16:09:18|INFO|viewImg|imgPath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/cars/220_1748053751851_car.jpg 2026-01-27 16:09:18|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzU1LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Njk1MDQ5NTV9.9z3-BSPha1d3V3pIDlpNfSMT7vO4c5emoB1JVtmhj8k 2026-01-27 16:09:18|SQL|[#1 - 0.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = '1');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2026-01-27 16:09:18|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzU1LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Njk1MDQ5NTV9.9z3-BSPha1d3V3pIDlpNfSMT7vO4c5emoB1JVtmhj8k 2026-01-27 16:09:18|SQL|[#1 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecordDetail.php(16): App\Model\Discount\DatDiscountRecordDetail::getDiscountByRecordId() u433670985_test.dat_discount_record_detail SELECT * FROM dat_discount_record_detail WHERE (discount_record_id = '9');|{"request":{"service":"App.Discount_Discount.listByRecordId"}} 2026-01-27 16:20:09|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzI0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDUyNH0.btZbEhOCPjsBhrgQGqU24q_i1RqhTNtZnIjFYmyZOxM 2026-01-27 16:20:09|SQL|[#1 - 6.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): 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-01-27 16:20:14|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzI0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDUyNH0.btZbEhOCPjsBhrgQGqU24q_i1RqhTNtZnIjFYmyZOxM 2026-01-27 16:20:14|INFO|getWholeBudgetbyMonth|detailImagePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/_2025-6_whole_budget.jpg 2026-01-27 16:20:14|INFO|savePdf|savePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/pdf/_2025-6_MC_合計請求書2.pdf 2026-01-27 16:20:14|INFO|savePdf|images:["\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/zebra\/_2025-6_whole_budget.jpg"] 2026-01-27 16:24:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzI0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDUyNH0.btZbEhOCPjsBhrgQGqU24q_i1RqhTNtZnIjFYmyZOxM 2026-01-27 16:24:41|INFO|getWholeBudgetbyMonth|detailImagePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/_2025-6_whole_budget.jpg 2026-01-27 16:24:41|INFO|savePdf|savePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/pdf/_2025-6_MC_合計請求書3.pdf 2026-01-27 16:24:41|INFO|savePdf|images:["\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/zebra\/_2025-6_whole_budget.jpg"] 2026-01-27 16:39:19|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzI0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDUyNH0.btZbEhOCPjsBhrgQGqU24q_i1RqhTNtZnIjFYmyZOxM 2026-01-27 16:39:19|INFO|getWholeBudgetbyMonth|detailImagePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/21_2025-6_whole_budget.jpg 2026-01-27 16:39:19|INFO|savePdf|savePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/pdf/21_2025-6_MC_合計請求書.pdf 2026-01-27 16:39:19|INFO|savePdf|images:["\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/zebra\/21_2025-6_whole_budget.jpg"] 2026-01-27 16:53:19|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzI0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDUyNH0.btZbEhOCPjsBhrgQGqU24q_i1RqhTNtZnIjFYmyZOxM 2026-01-27 16:53:19|INFO|getPaddingLeftString|(14): SS東京 2026-01-27 16:53:19|INFO|getPaddingLeftString|raw length: 6 2026-01-27 16:53:19|INFO|getPaddingLeftString|(14) result: " SS東京" 2026-01-27 16:53:19|INFO|getPaddingLeftString|(25): 100,000円 2026-01-27 16:53:19|INFO|getPaddingLeftString|raw length: 9 2026-01-27 16:53:19|INFO|getPaddingLeftString|(25) result: " 100,000円" 2026-01-27 16:53:19|INFO|getPaddingLeftString|(18): 1234SS大阪 2026-01-27 16:53:19|INFO|getPaddingLeftString|raw length: 10 2026-01-27 16:53:19|INFO|getPaddingLeftString|(18) result: " 1234SS大阪" 2026-01-27 16:53:19|INFO|getPaddingLeftString|(25): 150,000円 2026-01-27 16:53:19|INFO|getPaddingLeftString|raw length: 9 2026-01-27 16:53:19|INFO|getPaddingLeftString|(25) result: " 150,000円" 2026-01-27 16:53:19|INFO|getPaddingLeftString|(19): 12345SS大阪 2026-01-27 16:53:19|INFO|getPaddingLeftString|raw length: 11 2026-01-27 16:53:19|INFO|getPaddingLeftString|(19) result: " 12345SS大阪" 2026-01-27 16:53:19|INFO|getPaddingLeftString|(25): 250,000円 2026-01-27 16:53:19|INFO|getPaddingLeftString|raw length: 9 2026-01-27 16:53:19|INFO|getPaddingLeftString|(25) result: " 250,000円" 2026-01-27 16:53:19|INFO|getPaddingLeftString|(14): SS福岡 2026-01-27 16:53:19|INFO|getPaddingLeftString|raw length: 6 2026-01-27 16:53:19|INFO|getPaddingLeftString|(14) result: " SS福岡" 2026-01-27 16:53:19|INFO|getPaddingLeftString|(25): 250,000円 2026-01-27 16:53:19|INFO|getPaddingLeftString|raw length: 9 2026-01-27 16:53:19|INFO|getPaddingLeftString|(25) result: " 250,000円" 2026-01-27 16:53:19|INFO|getPaddingLeftString|(14): SS福岡 2026-01-27 16:53:19|INFO|getPaddingLeftString|raw length: 6 2026-01-27 16:53:19|INFO|getPaddingLeftString|(14) result: " SS福岡" 2026-01-27 16:53:19|INFO|getPaddingLeftString|(25): 200,000円 2026-01-27 16:53:19|INFO|getPaddingLeftString|raw length: 9 2026-01-27 16:53:19|INFO|getPaddingLeftString|(25) result: " 200,000円" 2026-01-27 16:53:19|INFO|getWholeBudgetbyMonth|detailImagePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/21_2025-6_whole_budget.jpg 2026-01-27 16:53:19|INFO|savePdf|savePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/pdf/21_2025-6_MC_合計請求書2.pdf 2026-01-27 16:53:19|INFO|savePdf|images:["\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/zebra\/21_2025-6_whole_budget.jpg"] 2026-01-27 16:57:39|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzI0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDUyNH0.btZbEhOCPjsBhrgQGqU24q_i1RqhTNtZnIjFYmyZOxM 2026-01-27 16:57:39|INFO|getPaddingLeftString|(14): SS東京 2026-01-27 16:57:39|INFO|getPaddingLeftString|raw length: 6 2026-01-27 16:57:39|INFO|getPaddingLeftString|(14) result: " SS東京" 2026-01-27 16:57:39|INFO|getPaddingLeftString|(25): 100,000円 2026-01-27 16:57:39|INFO|getPaddingLeftString|raw length: 9 2026-01-27 16:57:39|INFO|getPaddingLeftString|(25) result: " 100,000円" 2026-01-27 16:57:39|INFO|getPaddingLeftString|(18): 1234SS大阪 2026-01-27 16:57:39|INFO|getPaddingLeftString|raw length: 10 2026-01-27 16:57:39|INFO|getPaddingLeftString|(18) result: " 1234SS大阪" 2026-01-27 16:57:39|INFO|getPaddingLeftString|(25): 11,150,000円 2026-01-27 16:57:39|INFO|getPaddingLeftString|raw length: 12 2026-01-27 16:57:39|INFO|getPaddingLeftString|(25) result: " 11,150,000円" 2026-01-27 16:57:39|INFO|getPaddingLeftString|(19): 12345SS大阪 2026-01-27 16:57:39|INFO|getPaddingLeftString|raw length: 11 2026-01-27 16:57:39|INFO|getPaddingLeftString|(19) result: " 12345SS大阪" 2026-01-27 16:57:39|INFO|getPaddingLeftString|(25): 2,250,000円 2026-01-27 16:57:39|INFO|getPaddingLeftString|raw length: 11 2026-01-27 16:57:39|INFO|getPaddingLeftString|(25) result: " 2,250,000円" 2026-01-27 16:57:39|INFO|getPaddingLeftString|(14): SS福岡 2026-01-27 16:57:39|INFO|getPaddingLeftString|raw length: 6 2026-01-27 16:57:39|INFO|getPaddingLeftString|(14) result: " SS福岡" 2026-01-27 16:57:39|INFO|getPaddingLeftString|(25): 25,000円 2026-01-27 16:57:39|INFO|getPaddingLeftString|raw length: 8 2026-01-27 16:57:39|INFO|getPaddingLeftString|(25) result: " 25,000円" 2026-01-27 16:57:39|INFO|getPaddingLeftString|(14): SS福岡 2026-01-27 16:57:39|INFO|getPaddingLeftString|raw length: 6 2026-01-27 16:57:39|INFO|getPaddingLeftString|(14) result: " SS福岡" 2026-01-27 16:57:39|INFO|getPaddingLeftString|(25): 2,000円 2026-01-27 16:57:39|INFO|getPaddingLeftString|raw length: 7 2026-01-27 16:57:39|INFO|getPaddingLeftString|(25) result: " 2,000円" 2026-01-27 16:57:39|INFO|getWholeBudgetbyMonth|detailImagePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/21_2025-6_whole_budget.jpg 2026-01-27 16:57:39|INFO|savePdf|savePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/pdf/21_2025-6_MC_合計請求書3.pdf 2026-01-27 16:57:39|INFO|savePdf|images:["\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/zebra\/21_2025-6_whole_budget.jpg"] 2026-01-27 17:00:53|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzI0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDUyNH0.btZbEhOCPjsBhrgQGqU24q_i1RqhTNtZnIjFYmyZOxM 2026-01-27 17:00:53|INFO|getPaddingLeftString|(11): SS東京 2026-01-27 17:00:53|INFO|getPaddingLeftString|raw length: 6 2026-01-27 17:00:53|INFO|getPaddingLeftString|(11) result: " SS東京" 2026-01-27 17:00:53|INFO|getPaddingLeftString|(25): 100,000 2026-01-27 17:00:53|INFO|getPaddingLeftString|raw length: 7 2026-01-27 17:00:53|INFO|getPaddingLeftString|(25) result: " 100,000" 2026-01-27 17:00:53|INFO|getPaddingLeftString|(13): 1234SS大阪 2026-01-27 17:00:53|INFO|getPaddingLeftString|raw length: 10 2026-01-27 17:00:53|INFO|getPaddingLeftString|(13) result: " 1234SS大阪" 2026-01-27 17:00:53|INFO|getPaddingLeftString|(25): 11,150,000 2026-01-27 17:00:53|INFO|getPaddingLeftString|raw length: 10 2026-01-27 17:00:53|INFO|getPaddingLeftString|(25) result: " 11,150,000" 2026-01-27 17:00:53|INFO|getPaddingLeftString|(13): 12345SS大阪 2026-01-27 17:00:53|INFO|getPaddingLeftString|raw length: 11 2026-01-27 17:00:53|INFO|getPaddingLeftString|(13) result: " 12345SS大阪" 2026-01-27 17:00:53|INFO|getPaddingLeftString|(25): 2,250,000 2026-01-27 17:00:53|INFO|getPaddingLeftString|raw length: 9 2026-01-27 17:00:53|INFO|getPaddingLeftString|(25) result: " 2,250,000" 2026-01-27 17:00:53|INFO|getPaddingLeftString|(11): SS福岡 2026-01-27 17:00:53|INFO|getPaddingLeftString|raw length: 6 2026-01-27 17:00:53|INFO|getPaddingLeftString|(11) result: " SS福岡" 2026-01-27 17:00:53|INFO|getPaddingLeftString|(25): 25,000 2026-01-27 17:00:53|INFO|getPaddingLeftString|raw length: 6 2026-01-27 17:00:53|INFO|getPaddingLeftString|(25) result: " 25,000" 2026-01-27 17:00:53|INFO|getPaddingLeftString|(11): SS福岡 2026-01-27 17:00:53|INFO|getPaddingLeftString|raw length: 6 2026-01-27 17:00:53|INFO|getPaddingLeftString|(11) result: " SS福岡" 2026-01-27 17:00:53|INFO|getPaddingLeftString|(25): 2,000 2026-01-27 17:00:53|INFO|getPaddingLeftString|raw length: 5 2026-01-27 17:00:53|INFO|getPaddingLeftString|(25) result: " 2,000" 2026-01-27 17:00:53|INFO|getWholeBudgetbyMonth|detailImagePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/21_2025-6_whole_budget.jpg 2026-01-27 17:00:53|INFO|savePdf|savePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/pdf/21_2025-6_MC_合計請求書4.pdf 2026-01-27 17:00:53|INFO|savePdf|images:["\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/zebra\/21_2025-6_whole_budget.jpg"] 2026-01-27 17:02:35|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzI0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDUyNH0.btZbEhOCPjsBhrgQGqU24q_i1RqhTNtZnIjFYmyZOxM 2026-01-27 17:02:35|INFO|getPaddingLeftString|(11): SS東京 2026-01-27 17:02:35|INFO|getPaddingLeftString|raw length: 6 2026-01-27 17:02:35|INFO|getPaddingLeftString|(11) result: " SS東京" 2026-01-27 17:02:35|INFO|getPaddingLeftString|(25): 100,000 2026-01-27 17:02:35|INFO|getPaddingLeftString|raw length: 7 2026-01-27 17:02:35|INFO|getPaddingLeftString|(25) result: " 100,000" 2026-01-27 17:02:35|INFO|getPaddingLeftString|(13): 1234SS大阪 2026-01-27 17:02:35|INFO|getPaddingLeftString|raw length: 10 2026-01-27 17:02:35|INFO|getPaddingLeftString|(13) result: " 1234SS大阪" 2026-01-27 17:02:35|INFO|getPaddingLeftString|(25): 11,150,000 2026-01-27 17:02:35|INFO|getPaddingLeftString|raw length: 10 2026-01-27 17:02:35|INFO|getPaddingLeftString|(25) result: " 11,150,000" 2026-01-27 17:02:35|INFO|getPaddingLeftString|(13): 12345SS大阪 2026-01-27 17:02:35|INFO|getPaddingLeftString|raw length: 11 2026-01-27 17:02:35|INFO|getPaddingLeftString|(13) result: " 12345SS大阪" 2026-01-27 17:02:35|INFO|getPaddingLeftString|(25): 2,250,000 2026-01-27 17:02:35|INFO|getPaddingLeftString|raw length: 9 2026-01-27 17:02:35|INFO|getPaddingLeftString|(25) result: " 2,250,000" 2026-01-27 17:02:35|INFO|getPaddingLeftString|(11): SS福岡 2026-01-27 17:02:35|INFO|getPaddingLeftString|raw length: 6 2026-01-27 17:02:35|INFO|getPaddingLeftString|(11) result: " SS福岡" 2026-01-27 17:02:35|INFO|getPaddingLeftString|(25): 25,000 2026-01-27 17:02:35|INFO|getPaddingLeftString|raw length: 6 2026-01-27 17:02:35|INFO|getPaddingLeftString|(25) result: " 25,000" 2026-01-27 17:02:35|INFO|getPaddingLeftString|(11): SS福岡 2026-01-27 17:02:35|INFO|getPaddingLeftString|raw length: 6 2026-01-27 17:02:35|INFO|getPaddingLeftString|(11) result: " SS福岡" 2026-01-27 17:02:35|INFO|getPaddingLeftString|(25): 2,000 2026-01-27 17:02:35|INFO|getPaddingLeftString|raw length: 5 2026-01-27 17:02:35|INFO|getPaddingLeftString|(25) result: " 2,000" 2026-01-27 17:02:35|INFO|getWholeBudgetbyMonth|detailImagePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/21_2025-6_whole_budget.jpg 2026-01-27 17:02:35|INFO|savePdf|savePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/pdf/21_2025-6_MC_合計請求書5.pdf 2026-01-27 17:02:35|INFO|savePdf|images:["\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/zebra\/21_2025-6_whole_budget.jpg"] 2026-01-27 17:04:12|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5NTAxMzI0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTc2MDUyNH0.btZbEhOCPjsBhrgQGqU24q_i1RqhTNtZnIjFYmyZOxM 2026-01-27 17:04:12|INFO|getPaddingLeftString|(11): SS東京 2026-01-27 17:04:12|INFO|getPaddingLeftString|raw length: 6 2026-01-27 17:04:12|INFO|getPaddingLeftString|(11) result: " SS東京" 2026-01-27 17:04:12|INFO|getPaddingLeftString|(25): 100,000 2026-01-27 17:04:12|INFO|getPaddingLeftString|raw length: 7 2026-01-27 17:04:12|INFO|getPaddingLeftString|(25) result: " 100,000" 2026-01-27 17:04:12|INFO|getPaddingLeftString|(13): 1234SS大阪 2026-01-27 17:04:12|INFO|getPaddingLeftString|raw length: 10 2026-01-27 17:04:12|INFO|getPaddingLeftString|(13) result: " 1234SS大阪" 2026-01-27 17:04:12|INFO|getPaddingLeftString|(25): 11,150,000 2026-01-27 17:04:12|INFO|getPaddingLeftString|raw length: 10 2026-01-27 17:04:12|INFO|getPaddingLeftString|(25) result: " 11,150,000" 2026-01-27 17:04:12|INFO|getPaddingLeftString|(13): 12345SS大阪 2026-01-27 17:04:12|INFO|getPaddingLeftString|raw length: 11 2026-01-27 17:04:12|INFO|getPaddingLeftString|(13) result: " 12345SS大阪" 2026-01-27 17:04:12|INFO|getPaddingLeftString|(25): 2,250,000 2026-01-27 17:04:12|INFO|getPaddingLeftString|raw length: 9 2026-01-27 17:04:12|INFO|getPaddingLeftString|(25) result: " 2,250,000" 2026-01-27 17:04:12|INFO|getPaddingLeftString|(11): SS福岡 2026-01-27 17:04:12|INFO|getPaddingLeftString|raw length: 6 2026-01-27 17:04:12|INFO|getPaddingLeftString|(11) result: " SS福岡" 2026-01-27 17:04:12|INFO|getPaddingLeftString|(25): 25,000 2026-01-27 17:04:12|INFO|getPaddingLeftString|raw length: 6 2026-01-27 17:04:12|INFO|getPaddingLeftString|(25) result: " 25,000" 2026-01-27 17:04:12|INFO|getPaddingLeftString|(11): SS福岡 2026-01-27 17:04:12|INFO|getPaddingLeftString|raw length: 6 2026-01-27 17:04:12|INFO|getPaddingLeftString|(11) result: " SS福岡" 2026-01-27 17:04:12|INFO|getPaddingLeftString|(25): 2,000 2026-01-27 17:04:12|INFO|getPaddingLeftString|raw length: 5 2026-01-27 17:04:12|INFO|getPaddingLeftString|(25) result: " 2,000" 2026-01-27 17:04:12|INFO|getWholeBudgetbyMonth|detailImagePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/21_2025-6_whole_budget.jpg 2026-01-27 17:04:12|INFO|savePdf|savePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/pdf/21_2025-6_MC_合計請求書6.pdf 2026-01-27 17:04:12|INFO|savePdf|images:["\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/zebra\/21_2025-6_whole_budget.jpg"]