2026-02-25 02:05:53|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcxOTU2MzUyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MjIxNTU1Mn0.W5ZPvizsOYnTRgzevEOglUANWqfLVCBY7CUYIVIfzZM 2026-02-25 02:05:53|SQL|[#1 - 2.52ms - 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-25 02:05:53|SQL|[#2 - 0.65ms - 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-25 08:48:34|INFO|JwtAuthorizationFilter check|authorization: 2026-02-25 08:48:34|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcwNzgwMTE1LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MTAzOTMxNX0.2OSOlKfQEguFPqj9ZwNiVBLviww4K3G5gDcunsPgOsI 2026-02-25 08:48:34|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcwNzgwMTE1LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MTAzOTMxNX0.2OSOlKfQEguFPqj9ZwNiVBLviww4K3G5gDcunsPgOsI 2026-02-25 08:48:39|INFO|JwtAuthorizationFilter check|authorization: 2026-02-25 08:48:39|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcwNjA2MjY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NzA2MDk4Njh9._8hsHljVj5CSCeCL6vdkirwMzP6MJAONKCzjZwfpHgo 2026-02-25 08:48:40|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcwNjA2MjY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NzA2MDk4Njh9._8hsHljVj5CSCeCL6vdkirwMzP6MJAONKCzjZwfpHgo 2026-02-25 08:48:40|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcwNjA2MjY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NzA2MDk4Njh9._8hsHljVj5CSCeCL6vdkirwMzP6MJAONKCzjZwfpHgo 2026-02-25 08:48:40|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcwNjA2MjY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NzA2MDk4Njh9._8hsHljVj5CSCeCL6vdkirwMzP6MJAONKCzjZwfpHgo 2026-02-25 13:30:02|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcxOTk3NDAyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MjI1NjYwMn0.L5-FkdVhtQwESkmXqXN25fEUvJQW27ZE0IDZH3-AvjM 2026-02-25 13:30:02|SQL|[#1 - 2.42ms - 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-25 13:30:02|SQL|[#2 - 0.77ms - 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-25 13:30:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcxOTk3NDAyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MjI1NjYwMn0.L5-FkdVhtQwESkmXqXN25fEUvJQW27ZE0IDZH3-AvjM 2026-02-25 13:30:06|SQL|[#1 - 105.5ms - 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-25 13:30:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcxOTk3NDAyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MjI1NjYwMn0.L5-FkdVhtQwESkmXqXN25fEUvJQW27ZE0IDZH3-AvjM 2026-02-25 13:30:07|SQL|[#1 - 2.26ms - 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-25 13:30:10|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcxOTk3NDAyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MjI1NjYwMn0.L5-FkdVhtQwESkmXqXN25fEUvJQW27ZE0IDZH3-AvjM 2026-02-25 13:30:10|SQL|[#1 - 1.1ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(24): App\Model\Customer\DatCustomer::findCustomerByCustomerId() u433670985_test.dat_customer SELECT * FROM dat_customer WHERE (base_customerID = '14') LIMIT 1;|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:11|SQL|[#2 - 12.99ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(541): App\Model\Order\DatSyakenOrderList::listWholeBudgetByOrderIds() u433670985_test.dat_syaken_order_list SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.Customer_ID,s.ss_name,c.Number,c.Car_Name,\n (IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,IFNULL(re2.a2, 0) as miscellaneous_total,\n o.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,IFNULL(o.deposit_withdrawal_total, 0) as deposit_withdrawal_total\n FROM 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 \n LEFT JOIN mt_ss as s on s.ID = o.Shop_ID \n left join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \n LEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \n where cancel_flag != 1 and state != -9 and service !=1 and o1.Customer_ID = ? and ss_return_date between ? and ? \n AND 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 \n left join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \n LEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \n where cancel_flag != 1 and state != -9 and service !=1 and o1.Customer_ID = ? 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 \n left join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total FROM dat_syaken_order_list as o1 \n LEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\n where cancel_flag != 1 and state != -9 and service !=1 and o1.Customer_ID = ? 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 \n WHERE o.cancel_flag != 1 and o.state != -9 and o.service !=1 and o.ss_return_date between ? and ? and o.Customer_ID = ? ORDER BY `o`.`ss_return_date` ASC; -- '14', '2025-5-01', '2025-06-01', '14', '2025-5-01', '2025-06-01', '14', '2025-5-01', '2025-06-01', '2025-5-01', '2025-06-01', '14'|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:11|SQL|[#3 - 0.61ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(298): PhalApi\Model\DataModel::getList() u433670985_test.mt_tax SELECT * FROM mt_tax LIMIT 0,100;|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:11|SQL|[#4 - 0.56ms - 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 `print_flag` = 1 WHERE (order_id IN (224, 225, 226, 228));|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:11|SQL|[#5 - 0.86ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(548): App\Model\Order\DatSyakenOrderList::listLastMonthOrderMoney() u433670985_test.dat_syaken_order_list select a.Customer_ID,count(a.Order_ID) sales_num,IFNULL(sum(a.a1-a.deposit_withdrawal_total),0) sales_total,IFNULL(sum(a.a1),0) payed_total from (SELECT o.Customer_ID,o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,IFNULL(SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END),0) AS a1,IFNULL(o.deposit_withdrawal_total, 0) as 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 and Customer_ID = :customerId GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY a.Customer_ID; -- '2025-04-01', '2025-5-01', '14'|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:11|INFO|getWholeBudgetData|budgetData:{"category":0,"customerName":"\u5c0f\u677e \u30df\u30e4\u69d8","zipCode":"\u3012963-1311","customerAddress":"\u548c\u6b4c\u5c71\u770c\u6709\u7530\u90e1\u6709\u7530\u5ddd\u753a\u62bc\u624b1-1-1201","totalWithTax":"190,900\u5186\uff08\u6d88\u8cbb\u7a0e17,355\u5186\uff09","noTaxMoney":"133,710\u5186","taxchosei":"0\u5186","thisMonthOrderMoney":324610,"totalAmount":"324,610\u5186\uff08\u6d88\u8cbb\u7a0e17,355\u5186\uff09","detail":[{"ss_return_date":"2025\u5e7405\u670817\u65e5","Order_ID":224,"ssName":"\u30a4\u30f3\u30bf\u30fc","total":104050,"miscellaneous_total":73850},{"ss_return_date":"2025\u5e7405\u670817\u65e5","Order_ID":225,"ssName":"\u30a4\u30f3\u30bf\u30fc","total":193360,"miscellaneous_total":34360},{"ss_return_date":"2025\u5e7405\u670817\u65e5","Order_ID":226,"ssName":"\u30a4\u30f3\u30bf\u30fc","total":18150,"miscellaneous_total":16450},{"ss_return_date":"2025\u5e7405\u670817\u65e5","Order_ID":228,"ssName":"\u30a4\u30f3\u30bf\u30fc","total":9050,"miscellaneous_total":9050}],"printDate":"2026\u5e7402\u670825\u65e5","orderMonth":"2025\u5e7405\u6708","payExpireDate":"2025\u5e7406\u670830\u65e5","lastMonthOrderMoney":"33062.00","lastMonthPayedMoney":"11102","balance":21960,"totalMoney":346570} 2026-02-25 13:30:11|INFO|getPaddingLeftString|(10): 33,062 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 6 2026-02-25 13:30:11|INFO|getPaddingLeftString|(10) result: " 33,062" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(10): 11,102 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 6 2026-02-25 13:30:11|INFO|getPaddingLeftString|(10) result: " 11,102" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(10): 21,960 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 6 2026-02-25 13:30:11|INFO|getPaddingLeftString|(10) result: " 21,960" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(10): 324,610 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 7 2026-02-25 13:30:11|INFO|getPaddingLeftString|(10) result: " 324,610" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(10): 346,570 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 7 2026-02-25 13:30:11|INFO|getPaddingLeftString|(10) result: " 346,570" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(8): 1 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:30:11|INFO|getPaddingLeftString|(8) result: " 1" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(11): インター 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 8 2026-02-25 13:30:11|INFO|getPaddingLeftString|(11) result: " インター" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(25): 104,050 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 7 2026-02-25 13:30:11|INFO|getPaddingLeftString|(25) result: " 104,050" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(8): 2 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:30:11|INFO|getPaddingLeftString|(8) result: " 2" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(11): インター 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 8 2026-02-25 13:30:11|INFO|getPaddingLeftString|(11) result: " インター" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(25): 193,360 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 7 2026-02-25 13:30:11|INFO|getPaddingLeftString|(25) result: " 193,360" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(8): 3 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:30:11|INFO|getPaddingLeftString|(8) result: " 3" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(11): インター 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 8 2026-02-25 13:30:11|INFO|getPaddingLeftString|(11) result: " インター" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(25): 18,150 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 6 2026-02-25 13:30:11|INFO|getPaddingLeftString|(25) result: " 18,150" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(8): 4 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:30:11|INFO|getPaddingLeftString|(8) result: " 4" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(11): インター 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 8 2026-02-25 13:30:11|INFO|getPaddingLeftString|(11) result: " インター" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(25): 9,050 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 5 2026-02-25 13:30:11|INFO|getPaddingLeftString|(25) result: " 9,050" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(30): 190,900円（消費税17,355円） 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 27 2026-02-25 13:30:11|INFO|getPaddingLeftString|(30) result: " 190,900円（消費税17,355円）" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(30): 133,710円 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 9 2026-02-25 13:30:11|INFO|getPaddingLeftString|(30) result: " 133,710円" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(30): 0円 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 3 2026-02-25 13:30:11|INFO|getPaddingLeftString|(30) result: " 0円" 2026-02-25 13:30:11|INFO|getPaddingLeftString|(30): 324,610円（消費税17,355円） 2026-02-25 13:30:11|INFO|getPaddingLeftString|raw length: 27 2026-02-25 13:30:11|INFO|getPaddingLeftString|(30) result: " 324,610円（消費税17,355円）" 2026-02-25 13:30:11|INFO|getWholeBudgetbyMonth|detailImagePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/14_2025-5_whole_budget_first.jpg 2026-02-25 13:30:11|INFO|getWholeBudgetbyMonth|detail2ImagePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/14_2025-5_whole_budget_last.jpg 2026-02-25 13:30:11|INFO|savePdf|savePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/pdf/14_2025-5_MC_合計請求書40.pdf 2026-02-25 13:30:11|INFO|savePdf|images:["\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/zebra\/14_2025-5_whole_budget_first.jpg","\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/zebra\/14_2025-5_whole_budget_last.jpg"] 2026-02-25 13:30:25|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcxOTk3NDAyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MjI1NjYwMn0.L5-FkdVhtQwESkmXqXN25fEUvJQW27ZE0IDZH3-AvjM 2026-02-25 13:30:25|SQL|[#1 - 0.39ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(24): App\Model\Customer\DatCustomer::findCustomerByCustomerId() u433670985_test.dat_customer SELECT * FROM dat_customer WHERE (base_customerID = '27') LIMIT 1;|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:25|SQL|[#2 - 3.99ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(541): App\Model\Order\DatSyakenOrderList::listWholeBudgetByOrderIds() u433670985_test.dat_syaken_order_list SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.Customer_ID,s.ss_name,c.Number,c.Car_Name,\n (IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,IFNULL(re2.a2, 0) as miscellaneous_total,\n o.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,IFNULL(o.deposit_withdrawal_total, 0) as deposit_withdrawal_total\n FROM 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 \n LEFT JOIN mt_ss as s on s.ID = o.Shop_ID \n left join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \n LEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \n where cancel_flag != 1 and state != -9 and service !=1 and o1.Customer_ID = ? and ss_return_date between ? and ? \n AND 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 \n left join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \n LEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \n where cancel_flag != 1 and state != -9 and service !=1 and o1.Customer_ID = ? 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 \n left join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total FROM dat_syaken_order_list as o1 \n LEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\n where cancel_flag != 1 and state != -9 and service !=1 and o1.Customer_ID = ? 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 \n WHERE o.cancel_flag != 1 and o.state != -9 and o.service !=1 and o.ss_return_date between ? and ? and o.Customer_ID = ? ORDER BY `o`.`ss_return_date` ASC; -- '27', '2025-5-01', '2025-06-01', '27', '2025-5-01', '2025-06-01', '27', '2025-5-01', '2025-06-01', '2025-5-01', '2025-06-01', '27'|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:25|SQL|[#3 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(298): PhalApi\Model\DataModel::getList() u433670985_test.mt_tax SELECT * FROM mt_tax LIMIT 0,100;|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:25|SQL|[#4 - 0.25ms - 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 `print_flag` = 1 WHERE (order_id IN (282));|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:25|SQL|[#5 - 0.64ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(548): App\Model\Order\DatSyakenOrderList::listLastMonthOrderMoney() u433670985_test.dat_syaken_order_list select a.Customer_ID,count(a.Order_ID) sales_num,IFNULL(sum(a.a1-a.deposit_withdrawal_total),0) sales_total,IFNULL(sum(a.a1),0) payed_total from (SELECT o.Customer_ID,o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,IFNULL(SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END),0) AS a1,IFNULL(o.deposit_withdrawal_total, 0) as 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 and Customer_ID = :customerId GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY a.Customer_ID; -- '2025-04-01', '2025-5-01', '27'|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:25|INFO|getWholeBudgetData|budgetData:{"category":0,"customerName":"\u7530\u6751 \u308b\u308b\u69d8","zipCode":"\u3012160-0007","customerAddress":"\u6771\u4eac\u90fd\u65b0\u5bbf\u533a\u8352\u6728\u753a1-1","totalWithTax":"8,800\u5186\uff08\u6d88\u8cbb\u7a0e800\u5186\uff09","noTaxMoney":"16,600\u5186","taxchosei":"0\u5186","thisMonthOrderMoney":25400,"totalAmount":"25,400\u5186\uff08\u6d88\u8cbb\u7a0e800\u5186\uff09","detail":[{"ss_return_date":"2025\u5e7405\u670824\u65e5","Order_ID":282,"ssName":"\u5927\u9580\u5c0f\u6cc9SS","total":25400,"miscellaneous_total":16600}],"printDate":"2026\u5e7402\u670825\u65e5","orderMonth":"2025\u5e7405\u6708","payExpireDate":"2025\u5e7406\u670830\u65e5","lastMonthOrderMoney":0,"lastMonthPayedMoney":0,"balance":0,"totalMoney":25400} 2026-02-25 13:30:25|INFO|getPaddingLeftString|(7): 0 2026-02-25 13:30:25|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:30:25|INFO|getPaddingLeftString|(7) result: " 0" 2026-02-25 13:30:25|INFO|getPaddingLeftString|(7): 0 2026-02-25 13:30:25|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:30:25|INFO|getPaddingLeftString|(7) result: " 0" 2026-02-25 13:30:25|INFO|getPaddingLeftString|(7): 0 2026-02-25 13:30:25|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:30:25|INFO|getPaddingLeftString|(7) result: " 0" 2026-02-25 13:30:25|INFO|getPaddingLeftString|(10): 25,400 2026-02-25 13:30:25|INFO|getPaddingLeftString|raw length: 6 2026-02-25 13:30:25|INFO|getPaddingLeftString|(10) result: " 25,400" 2026-02-25 13:30:25|INFO|getPaddingLeftString|(10): 25,400 2026-02-25 13:30:25|INFO|getPaddingLeftString|raw length: 6 2026-02-25 13:30:25|INFO|getPaddingLeftString|(10) result: " 25,400" 2026-02-25 13:30:25|INFO|getPaddingLeftString|(8): 1 2026-02-25 13:30:25|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:30:25|INFO|getPaddingLeftString|(8) result: " 1" 2026-02-25 13:30:25|INFO|getPaddingLeftString|(12): 大門小泉SS 2026-02-25 13:30:25|INFO|getPaddingLeftString|raw length: 10 2026-02-25 13:30:25|INFO|getPaddingLeftString|(12) result: " 大門小泉SS" 2026-02-25 13:30:25|INFO|getPaddingLeftString|(25): 25,400 2026-02-25 13:30:25|INFO|getPaddingLeftString|raw length: 6 2026-02-25 13:30:25|INFO|getPaddingLeftString|(25) result: " 25,400" 2026-02-25 13:30:25|INFO|getPaddingLeftString|(30): 8,800円（消費税800円） 2026-02-25 13:30:25|INFO|getPaddingLeftString|raw length: 22 2026-02-25 13:30:25|INFO|getPaddingLeftString|(30) result: " 8,800円（消費税800円）" 2026-02-25 13:30:25|INFO|getPaddingLeftString|(30): 16,600円 2026-02-25 13:30:25|INFO|getPaddingLeftString|raw length: 8 2026-02-25 13:30:25|INFO|getPaddingLeftString|(30) result: " 16,600円" 2026-02-25 13:30:25|INFO|getPaddingLeftString|(30): 0円 2026-02-25 13:30:25|INFO|getPaddingLeftString|raw length: 3 2026-02-25 13:30:25|INFO|getPaddingLeftString|(30) result: " 0円" 2026-02-25 13:30:25|INFO|getPaddingLeftString|(30): 25,400円（消費税800円） 2026-02-25 13:30:25|INFO|getPaddingLeftString|raw length: 23 2026-02-25 13:30:25|INFO|getPaddingLeftString|(30) result: " 25,400円（消費税800円）" 2026-02-25 13:30:25|INFO|getWholeBudgetbyMonth|detailImagePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/27_2025-5_whole_budget_first.jpg 2026-02-25 13:30:25|INFO|getWholeBudgetbyMonth|detail2ImagePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/27_2025-5_whole_budget_last.jpg 2026-02-25 13:30:25|INFO|savePdf|savePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/pdf/27_2025-5_MC_合計請求書8.pdf 2026-02-25 13:30:25|INFO|savePdf|images:["\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/zebra\/27_2025-5_whole_budget_first.jpg","\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/zebra\/27_2025-5_whole_budget_last.jpg"] 2026-02-25 13:30:37|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcxOTk3NDAyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MjI1NjYwMn0.L5-FkdVhtQwESkmXqXN25fEUvJQW27ZE0IDZH3-AvjM 2026-02-25 13:30:37|SQL|[#1 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(24): App\Model\Customer\DatCustomer::findCustomerByCustomerId() u433670985_test.dat_customer SELECT * FROM dat_customer WHERE (base_customerID = '15') LIMIT 1;|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:37|SQL|[#2 - 3.06ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(541): App\Model\Order\DatSyakenOrderList::listWholeBudgetByOrderIds() u433670985_test.dat_syaken_order_list SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.Customer_ID,s.ss_name,c.Number,c.Car_Name,\n (IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,IFNULL(re2.a2, 0) as miscellaneous_total,\n o.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,IFNULL(o.deposit_withdrawal_total, 0) as deposit_withdrawal_total\n FROM 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 \n LEFT JOIN mt_ss as s on s.ID = o.Shop_ID \n left join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \n LEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \n where cancel_flag != 1 and state != -9 and service !=1 and o1.Customer_ID = ? and ss_return_date between ? and ? \n AND 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 \n left join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \n LEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \n where cancel_flag != 1 and state != -9 and service !=1 and o1.Customer_ID = ? 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 \n left join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total FROM dat_syaken_order_list as o1 \n LEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\n where cancel_flag != 1 and state != -9 and service !=1 and o1.Customer_ID = ? 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 \n WHERE o.cancel_flag != 1 and o.state != -9 and o.service !=1 and o.ss_return_date between ? and ? and o.Customer_ID = ? ORDER BY `o`.`ss_return_date` ASC; -- '15', '2025-5-01', '2025-06-01', '15', '2025-5-01', '2025-06-01', '15', '2025-5-01', '2025-06-01', '2025-5-01', '2025-06-01', '15'|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:37|SQL|[#3 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(298): PhalApi\Model\DataModel::getList() u433670985_test.mt_tax SELECT * FROM mt_tax LIMIT 0,100;|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:37|SQL|[#4 - 0.22ms - 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 `print_flag` = 1 WHERE (order_id IN (229));|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:37|SQL|[#5 - 0.58ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(548): App\Model\Order\DatSyakenOrderList::listLastMonthOrderMoney() u433670985_test.dat_syaken_order_list select a.Customer_ID,count(a.Order_ID) sales_num,IFNULL(sum(a.a1-a.deposit_withdrawal_total),0) sales_total,IFNULL(sum(a.a1),0) payed_total from (SELECT o.Customer_ID,o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,IFNULL(SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END),0) AS a1,IFNULL(o.deposit_withdrawal_total, 0) as 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 and Customer_ID = :customerId GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY a.Customer_ID; -- '2025-04-01', '2025-5-01', '15'|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:37|INFO|getWholeBudgetData|budgetData:{"category":0,"customerName":"\u5f8c\u85e4 \u7fd4\u69d8","zipCode":"\u3012937-0047","customerAddress":"\u5bcc\u5c71\u770c\u9b5a\u6d25\u5e02\u76f8\u6728\u65b07-2-1802","totalWithTax":"-2,000\u5186\uff08\u6d88\u8cbb\u7a0e-182\u5186\uff09","noTaxMoney":"13,042\u5186","taxchosei":"0\u5186","thisMonthOrderMoney":11042,"totalAmount":"11,042\u5186\uff08\u6d88\u8cbb\u7a0e-182\u5186\uff09","detail":[{"ss_return_date":"2025\u5e7405\u670818\u65e5","Order_ID":229,"ssName":"\u30a4\u30f3\u30bf\u30fc","total":11042,"miscellaneous_total":13042}],"printDate":"2026\u5e7402\u670825\u65e5","orderMonth":"2025\u5e7405\u6708","payExpireDate":"2025\u5e7406\u670830\u65e5","lastMonthOrderMoney":0,"lastMonthPayedMoney":0,"balance":0,"totalMoney":11042} 2026-02-25 13:30:37|INFO|getPaddingLeftString|(7): 0 2026-02-25 13:30:37|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:30:37|INFO|getPaddingLeftString|(7) result: " 0" 2026-02-25 13:30:37|INFO|getPaddingLeftString|(7): 0 2026-02-25 13:30:37|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:30:37|INFO|getPaddingLeftString|(7) result: " 0" 2026-02-25 13:30:37|INFO|getPaddingLeftString|(7): 0 2026-02-25 13:30:37|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:30:37|INFO|getPaddingLeftString|(7) result: " 0" 2026-02-25 13:30:37|INFO|getPaddingLeftString|(10): 11,042 2026-02-25 13:30:37|INFO|getPaddingLeftString|raw length: 6 2026-02-25 13:30:37|INFO|getPaddingLeftString|(10) result: " 11,042" 2026-02-25 13:30:37|INFO|getPaddingLeftString|(10): 11,042 2026-02-25 13:30:37|INFO|getPaddingLeftString|raw length: 6 2026-02-25 13:30:37|INFO|getPaddingLeftString|(10) result: " 11,042" 2026-02-25 13:30:37|INFO|getPaddingLeftString|(8): 1 2026-02-25 13:30:37|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:30:37|INFO|getPaddingLeftString|(8) result: " 1" 2026-02-25 13:30:37|INFO|getPaddingLeftString|(11): インター 2026-02-25 13:30:37|INFO|getPaddingLeftString|raw length: 8 2026-02-25 13:30:37|INFO|getPaddingLeftString|(11) result: " インター" 2026-02-25 13:30:37|INFO|getPaddingLeftString|(25): 11,042 2026-02-25 13:30:37|INFO|getPaddingLeftString|raw length: 6 2026-02-25 13:30:37|INFO|getPaddingLeftString|(25) result: " 11,042" 2026-02-25 13:30:37|INFO|getPaddingLeftString|(30): -2,000円（消費税-182円） 2026-02-25 13:30:37|INFO|getPaddingLeftString|raw length: 24 2026-02-25 13:30:37|INFO|getPaddingLeftString|(30) result: " -2,000円（消費税-182円）" 2026-02-25 13:30:37|INFO|getPaddingLeftString|(30): 13,042円 2026-02-25 13:30:37|INFO|getPaddingLeftString|raw length: 8 2026-02-25 13:30:37|INFO|getPaddingLeftString|(30) result: " 13,042円" 2026-02-25 13:30:37|INFO|getPaddingLeftString|(30): 0円 2026-02-25 13:30:37|INFO|getPaddingLeftString|raw length: 3 2026-02-25 13:30:37|INFO|getPaddingLeftString|(30) result: " 0円" 2026-02-25 13:30:37|INFO|getPaddingLeftString|(30): 11,042円（消費税-182円） 2026-02-25 13:30:37|INFO|getPaddingLeftString|raw length: 24 2026-02-25 13:30:37|INFO|getPaddingLeftString|(30) result: " 11,042円（消費税-182円）" 2026-02-25 13:30:37|INFO|getWholeBudgetbyMonth|detailImagePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/15_2025-5_whole_budget_first.jpg 2026-02-25 13:30:37|INFO|getWholeBudgetbyMonth|detail2ImagePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/15_2025-5_whole_budget_last.jpg 2026-02-25 13:30:37|INFO|savePdf|savePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/pdf/15_2025-5_MC_合計請求書.pdf 2026-02-25 13:30:37|INFO|savePdf|images:["\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/zebra\/15_2025-5_whole_budget_first.jpg","\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/zebra\/15_2025-5_whole_budget_last.jpg"] 2026-02-25 13:30:42|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcxOTk3NDQyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MjI1NjY0Mn0.FSZxds6M9SOJfhz-ErfNKZOTVW3FOdtkSdbNn5QAsWY 2026-02-25 13:30:42|SQL|[#1 - 1.41ms - 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-25 13:30:42|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-02-25 13:30:44|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcxOTk3NDQyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MjI1NjY0Mn0.FSZxds6M9SOJfhz-ErfNKZOTVW3FOdtkSdbNn5QAsWY 2026-02-25 13:30:44|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-25 13:30:44|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcxOTk3NDQyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MjI1NjY0Mn0.FSZxds6M9SOJfhz-ErfNKZOTVW3FOdtkSdbNn5QAsWY 2026-02-25 13:30:44|SQL|[#1 - 4.54ms - 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-4-01', '2025-5-01', '2025-4-01', '2025-5-01', '2025-4-01', '2025-5-01', '2025-4-01', '2025-5-01'|{"request":{"service":"App.Order_Order.getSalesList"}} 2026-02-25 13:30:47|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcxOTk3NDQ3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MjI1NjY0N30.Z_vFQzPrtsUQ11xV6PmdwSnty8lr4kLCWTlrmdZTWqc 2026-02-25 13:30:47|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-25 13:30:47|SQL|[#2 - 0.3ms - 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-25 13:30:48|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcxOTk3NDQ3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MjI1NjY0N30.Z_vFQzPrtsUQ11xV6PmdwSnty8lr4kLCWTlrmdZTWqc 2026-02-25 13:30:48|SQL|[#1 - 24.24ms - 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-25 13:30:48|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcxOTk3NDQ3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MjI1NjY0N30.Z_vFQzPrtsUQ11xV6PmdwSnty8lr4kLCWTlrmdZTWqc 2026-02-25 13:30:48|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-25 13:30:54|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcxOTk3NDQ3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MjI1NjY0N30.Z_vFQzPrtsUQ11xV6PmdwSnty8lr4kLCWTlrmdZTWqc 2026-02-25 13:30:54|SQL|[#1 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(24): App\Model\Customer\DatCustomer::findCustomerByCustomerId() u433670985_test.dat_customer SELECT * FROM dat_customer WHERE (base_customerID = '23') LIMIT 1;|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:54|SQL|[#2 - 9.15ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(541): App\Model\Order\DatSyakenOrderList::listWholeBudgetByOrderIds() u433670985_test.dat_syaken_order_list SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.Customer_ID,s.ss_name,c.Number,c.Car_Name,\n (IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,IFNULL(re2.a2, 0) as miscellaneous_total,\n o.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,IFNULL(o.deposit_withdrawal_total, 0) as deposit_withdrawal_total\n FROM 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 \n LEFT JOIN mt_ss as s on s.ID = o.Shop_ID \n left join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \n LEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \n where cancel_flag != 1 and state != -9 and service !=1 and o1.Customer_ID = ? and ss_return_date between ? and ? \n AND 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 \n left join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \n LEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \n where cancel_flag != 1 and state != -9 and service !=1 and o1.Customer_ID = ? 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 \n left join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total FROM dat_syaken_order_list as o1 \n LEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\n where cancel_flag != 1 and state != -9 and service !=1 and o1.Customer_ID = ? 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 \n WHERE o.cancel_flag != 1 and o.state != -9 and o.service !=1 and o.ss_return_date between ? and ? and o.Customer_ID = ? ORDER BY `o`.`ss_return_date` ASC; -- '23', '2025-6-01', '2025-07-01', '23', '2025-6-01', '2025-07-01', '23', '2025-6-01', '2025-07-01', '2025-6-01', '2025-07-01', '23'|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:54|SQL|[#3 - 0.44ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(298): PhalApi\Model\DataModel::getList() u433670985_test.mt_tax SELECT * FROM mt_tax LIMIT 0,100;|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:54|SQL|[#4 - 0.41ms - 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 `print_flag` = 1 WHERE (order_id IN (395, 263, 264));|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:54|SQL|[#5 - 0.67ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(548): App\Model\Order\DatSyakenOrderList::listLastMonthOrderMoney() u433670985_test.dat_syaken_order_list select a.Customer_ID,count(a.Order_ID) sales_num,IFNULL(sum(a.a1-a.deposit_withdrawal_total),0) sales_total,IFNULL(sum(a.a1),0) payed_total from (SELECT o.Customer_ID,o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,IFNULL(SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END),0) AS a1,IFNULL(o.deposit_withdrawal_total, 0) as 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 and Customer_ID = :customerId GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY a.Customer_ID; -- '2025-05-01', '2025-6-01', '23'|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:30:54|INFO|getWholeBudgetData|budgetData:{"category":0,"customerName":"\u9ed2\u5ddd \u307f\u3044\u69d8","zipCode":"\u3012250-0211","customerAddress":"\u795e\u5948\u5ddd\u770c\u5c0f\u7530\u539f\u5e02\u9b3c\u67f37-7","totalWithTax":"76,700\u5186\uff08\u6d88\u8cbb\u7a0e6,973\u5186\uff09","noTaxMoney":"228,577\u5186","taxchosei":"0\u5186","thisMonthOrderMoney":305277,"totalAmount":"305,277\u5186\uff08\u6d88\u8cbb\u7a0e6,973\u5186\uff09","detail":[{"ss_return_date":"2025\u5e7406\u670803\u65e5","Order_ID":395,"ssName":"\u5927\u9580\u5c0f\u6cc9SS","total":290777,"miscellaneous_total":226977},{"ss_return_date":"2025\u5e7406\u670826\u65e5","Order_ID":263,"ssName":"\u5927\u9580\u5c0f\u6cc9SS","total":0,"miscellaneous_total":0},{"ss_return_date":"2025\u5e7406\u670827\u65e5","Order_ID":264,"ssName":"\u5927\u9580\u5c0f\u6cc9SS","total":14500,"miscellaneous_total":1600}],"printDate":"2026\u5e7402\u670825\u65e5","orderMonth":"2025\u5e7406\u6708","payExpireDate":"2025\u5e7407\u670831\u65e5","lastMonthOrderMoney":0,"lastMonthPayedMoney":0,"balance":0,"totalMoney":305277} 2026-02-25 13:30:54|INFO|getPaddingLeftString|(7): 0 2026-02-25 13:30:54|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:30:54|INFO|getPaddingLeftString|(7) result: " 0" 2026-02-25 13:30:54|INFO|getPaddingLeftString|(7): 0 2026-02-25 13:30:54|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:30:54|INFO|getPaddingLeftString|(7) result: " 0" 2026-02-25 13:30:54|INFO|getPaddingLeftString|(7): 0 2026-02-25 13:30:54|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:30:54|INFO|getPaddingLeftString|(7) result: " 0" 2026-02-25 13:30:54|INFO|getPaddingLeftString|(10): 305,277 2026-02-25 13:30:54|INFO|getPaddingLeftString|raw length: 7 2026-02-25 13:30:54|INFO|getPaddingLeftString|(10) result: " 305,277" 2026-02-25 13:30:54|INFO|getPaddingLeftString|(10): 305,277 2026-02-25 13:30:54|INFO|getPaddingLeftString|raw length: 7 2026-02-25 13:30:54|INFO|getPaddingLeftString|(10) result: " 305,277" 2026-02-25 13:30:54|INFO|getPaddingLeftString|(8): 1 2026-02-25 13:30:54|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:30:54|INFO|getPaddingLeftString|(8) result: " 1" 2026-02-25 13:30:54|INFO|getPaddingLeftString|(12): 大門小泉SS 2026-02-25 13:30:54|INFO|getPaddingLeftString|raw length: 10 2026-02-25 13:30:54|INFO|getPaddingLeftString|(12) result: " 大門小泉SS" 2026-02-25 13:30:54|INFO|getPaddingLeftString|(25): 290,777 2026-02-25 13:30:54|INFO|getPaddingLeftString|raw length: 7 2026-02-25 13:30:54|INFO|getPaddingLeftString|(25) result: " 290,777" 2026-02-25 13:30:54|INFO|getPaddingLeftString|(8): 2 2026-02-25 13:30:54|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:30:54|INFO|getPaddingLeftString|(8) result: " 2" 2026-02-25 13:30:54|INFO|getPaddingLeftString|(12): 大門小泉SS 2026-02-25 13:30:54|INFO|getPaddingLeftString|raw length: 10 2026-02-25 13:30:54|INFO|getPaddingLeftString|(12) result: " 大門小泉SS" 2026-02-25 13:30:54|INFO|getPaddingLeftString|(25): 0 2026-02-25 13:30:54|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:30:54|INFO|getPaddingLeftString|(25) result: " 0" 2026-02-25 13:30:54|INFO|getPaddingLeftString|(8): 3 2026-02-25 13:30:54|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:30:54|INFO|getPaddingLeftString|(8) result: " 3" 2026-02-25 13:30:54|INFO|getPaddingLeftString|(12): 大門小泉SS 2026-02-25 13:30:54|INFO|getPaddingLeftString|raw length: 10 2026-02-25 13:30:54|INFO|getPaddingLeftString|(12) result: " 大門小泉SS" 2026-02-25 13:30:54|INFO|getPaddingLeftString|(25): 14,500 2026-02-25 13:30:54|INFO|getPaddingLeftString|raw length: 6 2026-02-25 13:30:54|INFO|getPaddingLeftString|(25) result: " 14,500" 2026-02-25 13:30:54|INFO|getPaddingLeftString|(30): 76,700円（消費税6,973円） 2026-02-25 13:30:54|INFO|getPaddingLeftString|raw length: 25 2026-02-25 13:30:54|INFO|getPaddingLeftString|(30) result: " 76,700円（消費税6,973円）" 2026-02-25 13:30:54|INFO|getPaddingLeftString|(30): 228,577円 2026-02-25 13:30:54|INFO|getPaddingLeftString|raw length: 9 2026-02-25 13:30:54|INFO|getPaddingLeftString|(30) result: " 228,577円" 2026-02-25 13:30:54|INFO|getPaddingLeftString|(30): 0円 2026-02-25 13:30:54|INFO|getPaddingLeftString|raw length: 3 2026-02-25 13:30:54|INFO|getPaddingLeftString|(30) result: " 0円" 2026-02-25 13:30:54|INFO|getPaddingLeftString|(30): 305,277円（消費税6,973円） 2026-02-25 13:30:54|INFO|getPaddingLeftString|raw length: 26 2026-02-25 13:30:54|INFO|getPaddingLeftString|(30) result: " 305,277円（消費税6,973円）" 2026-02-25 13:30:54|INFO|getWholeBudgetbyMonth|detailImagePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/23_2025-6_whole_budget_first.jpg 2026-02-25 13:30:54|INFO|getWholeBudgetbyMonth|detail2ImagePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/23_2025-6_whole_budget_last.jpg 2026-02-25 13:30:54|INFO|savePdf|savePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/pdf/23_2025-6_MC_合計請求書.pdf 2026-02-25 13:30:54|INFO|savePdf|images:["\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/zebra\/23_2025-6_whole_budget_first.jpg","\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/zebra\/23_2025-6_whole_budget_last.jpg"] 2026-02-25 13:31:31|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzcxOTk3NDQ3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3MjI1NjY0N30.Z_vFQzPrtsUQ11xV6PmdwSnty8lr4kLCWTlrmdZTWqc 2026-02-25 13:31:31|SQL|[#1 - 0.35ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(24): App\Model\Customer\DatCustomer::findCustomerByCustomerId() u433670985_test.dat_customer SELECT * FROM dat_customer WHERE (base_customerID = '20') LIMIT 1;|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:31:31|SQL|[#2 - 11.74ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(541): App\Model\Order\DatSyakenOrderList::listWholeBudgetByOrderIds() u433670985_test.dat_syaken_order_list SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.Customer_ID,s.ss_name,c.Number,c.Car_Name,\n (IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,IFNULL(re2.a2, 0) as miscellaneous_total,\n o.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,IFNULL(o.deposit_withdrawal_total, 0) as deposit_withdrawal_total\n FROM 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 \n LEFT JOIN mt_ss as s on s.ID = o.Shop_ID \n left join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \n LEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \n where cancel_flag != 1 and state != -9 and service !=1 and o1.Customer_ID = ? and ss_return_date between ? and ? \n AND 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 \n left join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \n LEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \n where cancel_flag != 1 and state != -9 and service !=1 and o1.Customer_ID = ? 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 \n left join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total FROM dat_syaken_order_list as o1 \n LEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\n where cancel_flag != 1 and state != -9 and service !=1 and o1.Customer_ID = ? 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 \n WHERE o.cancel_flag != 1 and o.state != -9 and o.service !=1 and o.ss_return_date between ? and ? and o.Customer_ID = ? ORDER BY `o`.`ss_return_date` ASC; -- '20', '2025-6-01', '2025-07-01', '20', '2025-6-01', '2025-07-01', '20', '2025-6-01', '2025-07-01', '2025-6-01', '2025-07-01', '20'|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:31:31|SQL|[#3 - 0.19ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(298): PhalApi\Model\DataModel::getList() u433670985_test.mt_tax SELECT * FROM mt_tax LIMIT 0,100;|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:31:31|SQL|[#4 - 0.23ms - 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 `print_flag` = 1 WHERE (order_id IN (244, 245, 246, 247, 248, 249));|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:31:31|SQL|[#5 - 0.49ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(548): App\Model\Order\DatSyakenOrderList::listLastMonthOrderMoney() u433670985_test.dat_syaken_order_list select a.Customer_ID,count(a.Order_ID) sales_num,IFNULL(sum(a.a1-a.deposit_withdrawal_total),0) sales_total,IFNULL(sum(a.a1),0) payed_total from (SELECT o.Customer_ID,o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,IFNULL(SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END),0) AS a1,IFNULL(o.deposit_withdrawal_total, 0) as 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 and Customer_ID = :customerId GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY a.Customer_ID; -- '2025-05-01', '2025-6-01', '20'|{"request":{"service":"App.Order_Order.doSaveWholeBudget"}} 2026-02-25 13:31:31|INFO|getWholeBudgetData|budgetData:{"category":1,"customerName":"\u672c\u7530 \u5065\u4e8c\u69d8","zipCode":"\u3012930-0892","customerAddress":"\u5bcc\u5c71\u770c\u5bcc\u5c71\u5e02\u77f3\u57421-1-1203","totalWithTax":"3,500\u5186\uff08\u6d88\u8cbb\u7a0e318\u5186\uff09","noTaxMoney":"92,616\u5186","taxchosei":"0\u5186","thisMonthOrderMoney":96116,"totalAmount":"96,116\u5186\uff08\u6d88\u8cbb\u7a0e318\u5186\uff09","detail":[{"ss_return_date":"2025\u5e7406\u670825\u65e5","Order_ID":null,"ssName":"\u5bcc\u5c71301\u306d7247","total":52207,"miscellaneous_total":58707},{"ss_return_date":"2025\u5e7406\u670826\u65e5","Order_ID":null,"ssName":"\u5bcc\u5c71301\u306d7247","total":0,"miscellaneous_total":0},{"ss_return_date":"2025\u5e7406\u670827\u65e5","Order_ID":"\u30c0\u30a4\u30cf\u30c4","ssName":"\u5bcc\u5c71531\u306d729","total":0,"miscellaneous_total":0},{"ss_return_date":"2025\u5e7406\u670828\u65e5","Order_ID":null,"ssName":"\u5bcc\u5c71301\u306d7247","total":23909,"miscellaneous_total":23909},{"ss_return_date":"2025\u5e7406\u670829\u65e5","Order_ID":null,"ssName":"\u5bcc\u5c71301\u306d7247","total":0,"miscellaneous_total":0},{"ss_return_date":"2025\u5e7406\u670830\u65e5","Order_ID":"\u672c\u7530","ssName":"\u5bcc\u5c71531\u306d729","total":20000,"miscellaneous_total":10000}],"printDate":"2026\u5e7402\u670825\u65e5","orderMonth":"2025\u5e7406\u6708","payExpireDate":"2025\u5e7407\u670831\u65e5","lastMonthOrderMoney":0,"lastMonthPayedMoney":0,"balance":0,"totalMoney":96116} 2026-02-25 13:31:31|INFO|getPaddingLeftString|(7): 0 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:31:31|INFO|getPaddingLeftString|(7) result: " 0" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(7): 0 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:31:31|INFO|getPaddingLeftString|(7) result: " 0" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(7): 0 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:31:31|INFO|getPaddingLeftString|(7) result: " 0" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(10): 96,116 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 6 2026-02-25 13:31:31|INFO|getPaddingLeftString|(10) result: " 96,116" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(10): 96,116 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 6 2026-02-25 13:31:31|INFO|getPaddingLeftString|(10) result: " 96,116" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(8): 1 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:31:31|INFO|getPaddingLeftString|(8) result: " 1" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(14): 富山301ね7247 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 13 2026-02-25 13:31:31|INFO|getPaddingLeftString|(14) result: " 富山301ね7247" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(25): 52,207 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 6 2026-02-25 13:31:31|INFO|getPaddingLeftString|(25) result: " 52,207" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(8): 2 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:31:31|INFO|getPaddingLeftString|(8) result: " 2" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(14): 富山301ね7247 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 13 2026-02-25 13:31:31|INFO|getPaddingLeftString|(14) result: " 富山301ね7247" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(25): 0 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:31:31|INFO|getPaddingLeftString|(25) result: " 0" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(8): 3 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:31:31|INFO|getPaddingLeftString|(8) result: " 3" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(13): 富山531ね729 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 12 2026-02-25 13:31:31|INFO|getPaddingLeftString|(13) result: " 富山531ね729" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(25): 0 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:31:31|INFO|getPaddingLeftString|(25) result: " 0" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(8): 4 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:31:31|INFO|getPaddingLeftString|(8) result: " 4" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(14): 富山301ね7247 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 13 2026-02-25 13:31:31|INFO|getPaddingLeftString|(14) result: " 富山301ね7247" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(25): 23,909 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 6 2026-02-25 13:31:31|INFO|getPaddingLeftString|(25) result: " 23,909" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(8): 5 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:31:31|INFO|getPaddingLeftString|(8) result: " 5" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(14): 富山301ね7247 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 13 2026-02-25 13:31:31|INFO|getPaddingLeftString|(14) result: " 富山301ね7247" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(25): 0 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:31:31|INFO|getPaddingLeftString|(25) result: " 0" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(8): 6 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 1 2026-02-25 13:31:31|INFO|getPaddingLeftString|(8) result: " 6" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(13): 富山531ね729 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 12 2026-02-25 13:31:31|INFO|getPaddingLeftString|(13) result: " 富山531ね729" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(25): 20,000 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 6 2026-02-25 13:31:31|INFO|getPaddingLeftString|(25) result: " 20,000" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(30): 3,500円（消費税318円） 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 22 2026-02-25 13:31:31|INFO|getPaddingLeftString|(30) result: " 3,500円（消費税318円）" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(30): 92,616円 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 8 2026-02-25 13:31:31|INFO|getPaddingLeftString|(30) result: " 92,616円" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(30): 0円 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 3 2026-02-25 13:31:31|INFO|getPaddingLeftString|(30) result: " 0円" 2026-02-25 13:31:31|INFO|getPaddingLeftString|(30): 96,116円（消費税318円） 2026-02-25 13:31:31|INFO|getPaddingLeftString|raw length: 23 2026-02-25 13:31:31|INFO|getPaddingLeftString|(30) result: " 96,116円（消費税318円）" 2026-02-25 13:31:31|INFO|getWholeBudgetbyMonth|detailImagePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/20_2025-6_whole_budget_first.jpg 2026-02-25 13:31:31|INFO|getWholeBudgetbyMonth|detail2ImagePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/20_2025-6_whole_budget_last.jpg 2026-02-25 13:31:31|INFO|savePdf|savePath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/pdf/20_2025-6_MC_合計請求書24.pdf 2026-02-25 13:31:31|INFO|savePdf|images:["\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/zebra\/20_2025-6_whole_budget_first.jpg","\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/zebra\/20_2025-6_whole_budget_last.jpg"]