2026-03-25 01:26:27|INFO|JwtAuthorizationFilter check|authorization:
2026-03-25 06:26:29|INFO|JwtAuthorizationFilter check|authorization:
2026-03-25 11:26:33|INFO|JwtAuthorizationFilter check|authorization:
2026-03-25 16:23:39|INFO|JwtAuthorizationFilter check|authorization:
2026-03-25 16:23:39|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc0MjMzOTgyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NDQ5MzE4Mn0.3zeyMUEqAqXi7NousWQ2XA5yea_pmLEx3G0OxKXq7N4
2026-03-25 16:23:39|SQL|[#1 - 0.46ms - 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-03-25 16:23:39|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc0MjMzOTgyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NDQ5MzE4Mn0.3zeyMUEqAqXi7NousWQ2XA5yea_pmLEx3G0OxKXq7N4
2026-03-25 16:23:39|SQL|[#1 - 22.9ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(540):    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-03-25 16:25:31|INFO|JwtAuthorizationFilter check|authorization:
2026-03-25 16:25:31|INFO|JwtAuthorizationFilter check|authorization:
2026-03-25 16:25:31|INFO|JwtAuthorizationFilter check|authorization:
2026-03-25 16:25:31|INFO|JwtAuthorizationFilter check|authorization:
2026-03-25 16:25:31|INFO|JwtAuthorizationFilter check|authorization:
2026-03-25 16:25:31|INFO|JwtAuthorizationFilter check|authorization:
2026-03-25 16:25:35|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc0MjMzNzYwLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDUzMzc3NjB9.p3uCIA304-BgsaGLN7_patfOdHv6mKHd_beKOpctr0w
2026-03-25 16:25:35|INFO|JwtAuthorizationFilter check|authorization:
2026-03-25 16:25:35|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc0MjMzNzYwLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDUzMzc3NjB9.p3uCIA304-BgsaGLN7_patfOdHv6mKHd_beKOpctr0w
2026-03-25 16:25:35|INFO|JwtAuthorizationFilter check|authorization:
2026-03-25 16:25:35|INFO|JwtAuthorizationFilter check|authorization:
2026-03-25 16:25:35|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc0MjMzNzYwLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDUzMzc3NjB9.p3uCIA304-BgsaGLN7_patfOdHv6mKHd_beKOpctr0w
2026-03-25 16:25:35|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc0MjMzNzYwLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDUzMzc3NjB9.p3uCIA304-BgsaGLN7_patfOdHv6mKHd_beKOpctr0w
2026-03-25 16:25:35|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc0MjMzNzYwLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDUzMzc3NjB9.p3uCIA304-BgsaGLN7_patfOdHv6mKHd_beKOpctr0w
2026-03-25 16:25:35|SQL|[#1 - 0.64ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/MtRepairItem.php(18):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_repair_item    SELECT * FROM mt_repair_item LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairItemList"}}
2026-03-25 16:25:35|SQL|[#1 - 0.38ms - 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.OrderDetail_OrderDetail.getTax"}}
2026-03-25 16:25:35|SQL|[#2 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(209):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_repair_classification    SELECT * FROM mt_repair_classification LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairItemList"}}
2026-03-25 16:25:35|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc0MjMzNzYwLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDUzMzc3NjB9.p3uCIA304-BgsaGLN7_patfOdHv6mKHd_beKOpctr0w
2026-03-25 16:25:35|INFO|getOrderDetailInfo|orderId:261
2026-03-25 16:25:35|SQL|[#1 - 0.41ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(39):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '261') LIMIT 1;|{"request":{"service":"App.Order_Order.clearNewFlag"}}
2026-03-25 16:25:35|SQL|[#1 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/MtMechanic.php(12):    App\Model\Repair\MtMechanic::queryList()    u433670985_test.mt_mechanic    SELECT ID,name FROM mt_mechanic WHERE (Delete_date is null);|{"request":{"service":"App.OrderDetail_OrderDetail.getAllMcStaffName"}}
2026-03-25 16:25:35|SQL|[#3 - 3.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(213):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_repair_remarks    SELECT * FROM mt_repair_remarks LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairItemList"}}
2026-03-25 16:25:35|SQL|[#2 - 1.21ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(107):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `new_flag` = 0 WHERE (order_id = '261');|{"request":{"service":"App.Order_Order.clearNewFlag"}}
2026-03-25 16:25:35|SQL|[#1 - 0.47ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(39):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '261') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-03-25 16:25:35|SQL|[#1 - 1.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatMcMemo.php(12):    App\Model\Repair\DatMcMemo::getMcMemoByOrderId()    u433670985_test.dat_mc_memo    SELECT * FROM dat_mc_memo WHERE (Order_ID = '261') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairEstimateList"}}
2026-03-25 16:25:35|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc0MjMzNzYwLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDUzMzc3NjB9.p3uCIA304-BgsaGLN7_patfOdHv6mKHd_beKOpctr0w
2026-03-25 16:25:35|SQL|[#2 - 2.59ms - 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 = 1584);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-03-25 16:25:35|SQL|[#3 - 0.88ms - 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 = 517) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-03-25 16:25:35|SQL|[#2 - 14.78ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(39):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '261') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairEstimateList"}}
2026-03-25 16:25:35|SQL|[#3 - 2.26ms - 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 = 552) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairEstimateList"}}
2026-03-25 16:25:35|SQL|[#4 - 3.07ms - 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 = 552) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-03-25 16:25:35|SQL|[#5 - 0.34ms - 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-03-25 16:25:35|SQL|[#6 - 0.3ms - 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 = 22) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-03-25 16:25:35|SQL|[#7 - 0.61ms - 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-03-25 16:25:35|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc0MjMzNzYwLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDUzMzc3NjB9.p3uCIA304-BgsaGLN7_patfOdHv6mKHd_beKOpctr0w
2026-03-25 16:25:35|SQL|[#1 - 0.57ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(39):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '261') LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-03-25 16:25:35|SQL|[#2 - 0.54ms - 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 * FROM dat_cars WHERE (CarID = 1584);|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-03-25 16:25:35|SQL|[#1 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/MtCustomerBasicFee.php(17):    App\Model\Repair\MtCustomerBasicFee::findBasicFeeByOrderId()    u433670985_test.mt_customer_basic_fee     SELECT cbf.* FROM dat_syaken_order_list ord \n            LEFT JOIN dat_customer cust on ord.Customer_ID = cust.base_customerID\n            LEFT JOIN mt_customer_basic_fee cbf on cust.basic_fee_id = cbf.id\n            where ord.Order_ID = ? ; -- '261'|{"request":{"service":"App.OrderDetail_OrderDetail.getCustomerBasicFee"}}
2026-03-25 16:25:35|SQL|[#3 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Order/Order.php(2424):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 2);|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-03-25 16:25:35|SQL|[#4 - 0.33ms - 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 = 22) LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-03-25 16:25:35|SQL|[#5 - 0.76ms - 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 = 517) LIMIT 0,100;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-03-25 16:25:35|SQL|[#6 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/MtMiscellaneousExpensesItem.php(11):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_miscellaneous_expenses_item    SELECT * FROM mt_miscellaneous_expenses_item LIMIT 0,100;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-03-25 16:25:35|INFO|doSaveBudget|Start handler miscellaneousExpensesDetailList
2026-03-25 16:25:35|INFO|doSaveBudget|End handler miscellaneousExpensesDetailList
2026-03-25 16:25:35|SQL|[#7 - 1.95ms - 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 = 552) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-03-25 16:25:35|SQL|[#8 - 0.21ms - 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 IS NULL);|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-03-25 16:25:35|SQL|[#9 - 0.24ms - 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.Order_Order.getBudgetData"}}
2026-03-25 16:25:35|SQL|[#10 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(39):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '261') LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-03-25 16:25:35|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc0MjMzNzYwLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDUzMzc3NjB9.p3uCIA304-BgsaGLN7_patfOdHv6mKHd_beKOpctr0w
2026-03-25 16:25:35|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc0MjMzNzYwLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDUzMzc3NjB9.p3uCIA304-BgsaGLN7_patfOdHv6mKHd_beKOpctr0w
2026-03-25 16:25:35|INFO|MtRepairUnitPrice|where:{"(repair_item, classification, category, category_detail)":[{"repair_item":"\u57fa\u672c\u6599\u91d1","classification":"\u70b9\u691c","category":"\u6cd5\u5b9a\u70b9\u691c","category_detail":"\u6cd5\u5b9a24\u30f6\u6708\u70b9\u691c\u6599"},{"repair_item":"\u57fa\u672c\u6599\u91d1","classification":"\u6e2c\u5b9a","category":"\u4fdd\u5b89\u691c\u67fb","category_detail":"\u4fdd\u5b89\u78ba\u8a8d\u691c\u67fb\u6599"},{"repair_item":"\u57fa\u672c\u6599\u91d1","classification":"\u70b9\u691c","category":"\u30cf\u30f3\u30c9\u30eb","category_detail":"\u30cf\u30f3\u30c9\u30eb\u304c\u305f\u3064\u304d"}]}
2026-03-25 16:25:35|SQL|[#11 - 0.68ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/MtRepairUnitPrice.php(32):    App\Model\Repair\MtRepairUnitPrice::fetchList()    u433670985_test.mt_repair_unit_price    SELECT * FROM mt_repair_unit_price WHERE ((repair_item, classification, category, category_detail) IN (('基本料金', '点検', '法定点検', '法定24ヶ月点検料'), ('基本料金', '測定', '保安検査', '保安確認検査料'), ('基本料金', '点検', 'ハンドル', 'ハンドルがたつき')));|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-03-25 16:25:35|INFO|doSaveBudget|Start handler repairEstimateDetailList
2026-03-25 16:25:35|INFO|doSaveBudget|End handler repairEstimateDetailList
2026-03-25 16:25:35|INFO|doSaveBudget|Start handler discounts
2026-03-25 16:25:35|INFO|doSaveBudget|End handler discounts
2026-03-25 16:25:35|INFO|doSaveBudget|Start handler depositWithdrawalRecords
2026-03-25 16:25:35|INFO|doSaveBudget|End handler depositWithdrawalRecords
2026-03-25 16:25:35|INFO|doSaveBudget|final data: {"cost1":0,"cost2":0,"cost3":0,"cost4":0,"weightPrice":0,"carTaxPrice":0,"insurancePrice":0,"paperPrice":0,"servicePrice":0,"checkPrice":9800,"maintenancePrice":0,"partsPrice":0,"repairPrice":0,"securityPrice":0,"otherPrices":0,"discountPrice":0,"payed":0,"priceTotal":9800,"total":9800,"toPayTotal":-9800,"tax":891}
2026-03-25 16:25:37|INFO|JwtAuthorizationFilter check|authorization:
2026-03-25 16:25:37|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc0MjMzOTgyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NDQ5MzE4Mn0.3zeyMUEqAqXi7NousWQ2XA5yea_pmLEx3G0OxKXq7N4
2026-03-25 16:25:37|SQL|[#1 - 0.35ms - 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-03-25 16:25:37|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc0MjMzOTgyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NDQ5MzE4Mn0.3zeyMUEqAqXi7NousWQ2XA5yea_pmLEx3G0OxKXq7N4
2026-03-25 16:25:37|SQL|[#1 - 6.92ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(540):    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"}}