2025-07-14 11:58:49|INFO|JwtAuthorizationFilter check|authorization:
2025-07-14 11:58:49|INFO|JwtAuthorizationFilter check|authorization:
2025-07-14 12:01:34|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjgyMjk0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjU0MTQ5NH0.9bfQrudFRmEAA6k3uB3lEh73z_UoSaRdexrpFaEjBhU
2025-07-14 12:01:34|INFO|logout|params:{"orderId":"406","timestamp":"1752282306"}
2025-07-14 12:01:34|SQL|[#1 - 0.61ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Model/DataModel.php(165):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_order_uuid    SELECT * FROM dat_order_uuid WHERE (order_id = '406') AND (ts <= ?) LIMIT 0,1; -- '1752282306'|{"request":{"service":"App.Order_Order.logout"}}
2025-07-14 12:01:34|SQL|[#2 - 0.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatOrderUuid.php(53):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_order_uuid    SELECT * FROM dat_order_uuid WHERE (order_id = '406') LIMIT 0,100;|{"request":{"service":"App.Order_Order.logout"}}
2025-07-14 12:01:34|SQL|[#3 - 2.62ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Order/Order.php(1317):    App\Domain\Order\DatOrderUuid::deleteByOrderId()    u433670985_test.dat_order_uuid    DELETE FROM dat_order_uuid WHERE (id = 460);|{"request":{"service":"App.Order_Order.logout"}}
2025-07-14 12:01:34|INFO|logout|delete count:1
2025-07-14 12:01:34|SQL|[#4 - 3.57ms - 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 `check_state` = 0 WHERE (order_id = '406');|{"request":{"service":"App.Order_Order.logout"}}
2025-07-14 12:07:38|INFO|mt_ss login|params:{"loginId":"admin","pw":"urutoraman1"}
2025-07-14 12:07:38|SQL|[#1 - 0.53ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Model/DataModel.php(165):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (log_in = 'admin') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.Login"}}
2025-07-14 12:07:38|INFO|mt_ss login|user:{"ID":18,"category":9,"ss_name":"admin","display_name":null,"en_name":"admin","section":null,"section_id":null,"log_in":"admin","pw":"urutoraman1","manager_flag":1,"comp_1":null,"comp_2":null,"comp_3":null,"comp_4":null,"comp_5":null,"test_marketing_flag":1,"rent_a_car":1,"towing":null,"Delete_date":null,"line_openid":"C","zip":null,"address":null,"telno":null,"faxno":null}
2025-07-14 12:07:38|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1752466058,"data":{"ssid":18}}
2025-07-14 12:07:38|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2MDU4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTI0Njk2NTh9.nMv82ZQnoke_pdPVdDY2885d9Tfd8AM-Qof9tth4wxs
2025-07-14 12:07:38|INFO|orderList|shopId:
2025-07-14 12:07:38|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1752466058,"data":{"ssid":18},"scopes":"role_access","exp":1752469658}
2025-07-14 12:07:38|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null}
2025-07-14 12:07:38|INFO|getOrderList|担当者所属的店铺id:18
2025-07-14 12:07:38|SQL|[#1 - 0.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(167):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-14 12:07:38|SQL|[#2 - 0.14ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-14 12:07:38|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2025-07-14 12:07:38|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-07-14 12:07:38|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-07-14 12:07:38|SQL|[#3 - 3.01ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(212):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT res.Order_ID,max(res.ss_storage_date) as ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12, -12)) AND (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22)));|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-14 12:07:38|INFO|getOrderList|查询结果条数:126
2025-07-14 12:07:38|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2MDU4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTI0Njk2NTh9.nMv82ZQnoke_pdPVdDY2885d9Tfd8AM-Qof9tth4wxs
2025-07-14 12:07:38|SQL|[#1 - 0.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(52):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.AdminUser_MtSsUser.GetAllSS"}}
2025-07-14 12:07:38|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2MDU4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTI0Njk2NTh9.nMv82ZQnoke_pdPVdDY2885d9Tfd8AM-Qof9tth4wxs
2025-07-14 12:07:38|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1752466058,"data":{"ssid":18},"scopes":"role_access","exp":1752469658}
2025-07-14 12:07:38|SQL|[#1 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(59):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2025-07-14 12:07:38|SQL|[#2 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(63):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (category <> ?) LIMIT 0,100; -- 9|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2025-07-14 12:10:18|INFO|qrCodePng|orderId:222
2025-07-14 12:10:18|INFO|qrCodePng|aes encrypt：bsFKyaoiuWca6Epx27wn163
2025-07-14 12:10:18|INFO|qrCodePng|base64 encode:YnNGS3lhb2l1V2NhNkVweDI3d24xNjMgMjIy
2025-07-14 12:10:50|INFO|mt_ss getSsInfoFromSession|sessionUserName:admin
2025-07-14 12:10:50|SQL|[#1 - 0.44ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Model/DataModel.php(165):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (log_in = 'admin') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.GetSsInfoFromSession"}}
2025-07-14 12:10:50|INFO|mt_ss getSsInfoFromSession|user:{"ID":18,"category":9,"ss_name":"admin","display_name":null,"en_name":"admin","section":null,"section_id":null,"log_in":"admin","pw":"urutoraman1","manager_flag":1,"comp_1":null,"comp_2":null,"comp_3":null,"comp_4":null,"comp_5":null,"test_marketing_flag":1,"rent_a_car":1,"towing":null,"Delete_date":null,"line_openid":"C","zip":null,"address":null,"telno":null,"faxno":null}
2025-07-14 12:19:59|INFO|checkSourceUpdate|file:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../appview/dist.zip
2025-07-14 12:19:59|INFO|checkSourceUpdate|crc32:854971ee
2025-07-14 12:20:24|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2ODAyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNjAwMn0.AW4f8qaujBmMNpd7hgFduKFzoEiIb_uJAOarfb3EXDo
2025-07-14 12:20:24|SQL|[#1 - 1.05ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/OBD/MtObdError.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_obd_error    SELECT * FROM mt_obd_error LIMIT 0,100;|{"request":{"service":"App.Cars_Cars.getObdErrorInfo"}}
2025-07-14 12:20:27|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2ODAyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNjAwMn0.AW4f8qaujBmMNpd7hgFduKFzoEiIb_uJAOarfb3EXDo
2025-07-14 12:20:27|INFO|verification|params:{"orderId":"3022","uuid":"00d7289d-5b93-4363-87fb-5fe4714b8f93","ciphertext":"ZR0lcviBx25ueSXtLDiX943"}
2025-07-14 12:20:27|INFO|verification|aes decrypt:3022
2025-07-14 12:20:27|SQL|[#1 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '3022') LIMIT 1;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-14 12:21:11|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2MjUwLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNTQ1MH0.FKWSQMA_VK6Jv5jLbj0YaMfUncapb0n6NYcCImgd2nA
2025-07-14 12:21:11|INFO|doCopyOrder|jwt:{"iss":"http:\/\/www.shimars.net","iat":1752466250,"data":{"orderId":null,"uuid":null},"scopes":"role_access","exp":1752725450}
2025-07-14 12:21:11|SQL|[#1 - 0.45ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(111):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '406') LIMIT 1;|{"request":{"service":"App.Order_Order.doCopyOrder"}}
2025-07-14 12:21:11|SQL|[#2 - 0.51ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(145):    App\Model\Cars\DatCars::findCarsByCarId()    u433670985_test.dat_cars    SELECT * FROM dat_cars WHERE (CarID = 1783) LIMIT 1;|{"request":{"service":"App.Order_Order.doCopyOrder"}}
2025-07-14 12:21:11|SQL|[#3 - 2.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(147):    PhalApi\Model\DataModel::insert()    u433670985_test.dat_cars    INSERT  INTO dat_cars (`CarID`, `customer_ID`, `InventoryCategory`, `Year`, `syodo_date`, `make`, `Car_Name`, `Grade`, `Color`, `katashiki`, `gendouki`, `VIN`, `Custmer_Trigger`, `Syaken`, `Millage`, `purpose`, `syubetu`, `kubun`, `keijyou`, `teiin`, `saidaisekisairyou`, `jyuuryou`, `soujyuuryou`, `ruibetsu`, `Katashiki_Shitei`, `nagasa`, `haba`, `takasa`, `haikiryou`, `nenryou`, `Number`, `ZIP`, `addr`, `contruct_customer`, `Syoyuu_ken`, `Registry_Name`, `Registry_Address`, `Phone_Number1`, `kaitori_address`, `ex_shiyousya_name`, `ex_shiyousya_address`, `Quarity_Grade`, `Document_Limit`, `Car_Info_Remarks`, `Inspection_Date`, `Purchase_Staff`, `Contract_Date`, `Arrival_Schedule`, `Arrival_Date`, `Payment_Schedule`, `Payment_Date`, `Pricing_Price`, `Custmer_Price`, `Presentation_Price`, `presentation_price_tax`, `GN_Price`, `CS_Price`, `AS_Price`, `Result`, `Purchase_Negosiate_Remarks`, `Sales_Negosiate_Date`, `Sales_Staff`, `Sales_Close_Date`, `Delivary_Schedule`, `Delivary_Date`, `Car_Price`, `sales_tax`, `total_amount`, `total_amount_tax`, `basic_maintenance`, `basic_maintenance_tax`, `less_price`, `less_price_tax`, `commission`, `commition_tax`, `parts`, `parts_tax`, `sales_option`, `sales_option_tax`, `other_tax`, `Recycle`, `extra_maintenance`, `extra_maintenance_tax`, `jizei_hyouka`, `Expence`, `Deposit_Schedule`, `Deposit_Date`, `Custmer_Name`, `Phone_Number2`, `Custmer_Address`, `birthday`, `seinengappi`, `nouzeisya_name`, `nouzeisya_address`, `syoyuusya_name`, `syoyuusya_address`, `shiyousya_name`, `shiyousya_address`, `parking_address`, `AA_Schedule`, `AA`, `Profit`, `Sales_Negosiate_Remarks`, `Approved_Date`, `Approved_Staff`, `Determination_date`, `Create_Date`, `LastModify_Date`, `Last_editer`, `Dalete_Date`, `data_lock`, `drive`, `ss_id`) VALUES (NULL, 105, NULL, '2010(H22)', '2010-03-01', 'ニッサン', NULL, NULL, NULL, 'DBA-H92W', '3G83', 'H92W-0558741', 7, '2027-03-29', 74000, '乗用', '軽自動車', NULL, 'ステーションワゴン', 4, '-', 800, 1020, 2001, 15411, 339, 147, 155, 1, 1, '富山580ち3575', NULL, NULL, NULL, NULL, '使用者に同じ', 'A', NULL, NULL, '株式会社　ＳＨＩＭＡカーライフコネクテッド', 'A', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-05-21', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '使用者に同じ', 'A', '株式会社　ＳＨＩＭＡカーライフコネクテッド', 'A', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-07-12 00:53:17', NULL, NULL, NULL, '設定値無し', NULL);|{"request":{"service":"App.Order_Order.doCopyOrder"}}
2025-07-14 12:21:11|SQL|[#4 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Model/Order/DatSyakenOrderList.php(27):    PhalApi\Model\DataModel::insert()    u433670985_test.dat_syaken_order_list    INSERT  INTO dat_syaken_order_list (`Order_ID`, `Customer_ID`, `Car_ID`, `Shop_ID`, `staff`, `Enquite_Date`, `Tenken_Date`, `Mitsumori_Date`, `Arrival_Date`, `Complete_Date`, `Delivary_Date`, `Void_reason`, `contact_id`, `check_state`, `service`, `state`, `remark`, `questionnaire_answer_id`, `general_order_id`, `vehicle_inspection_quote_answer_id`, `car_photo`, `reason`, `miscellaneous_expenses_id`, `repair_estimate_id`, `deposit_withdrawal_record_id`, `discount_record_id`, `deposit_withdrawal_total`, `extra_discount`, `new_flag`, `cancel_flag`, `recept_date`, `reply_date`, `mc_stock_date`, `settle_date`, `ss_return_date`, `delivered_date`, `syaken_send_date`) VALUES (NULL, 105, 1784, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, 4, NULL, 178, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);|{"request":{"service":"App.Order_Order.doCopyOrder"}}
2025-07-14 12:21:11|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2MjUwLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNTQ1MH0.FKWSQMA_VK6Jv5jLbj0YaMfUncapb0n6NYcCImgd2nA
2025-07-14 12:21:11|INFO|orderList|shopId:
2025-07-14 12:21:11|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1752466250,"data":{"orderId":null,"uuid":null},"scopes":"role_access","exp":1752725450}
2025-07-14 12:21:11|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":-1,"$freeword":null,"$orderId":null}
2025-07-14 12:21:11|INFO|getOrderList|担当者所属的店铺id:-1
2025-07-14 12:21:11|SQL|[#1 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(167):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = -1);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-14 12:21:11|INFO|getOrderList|担当者所属的店铺ids:-1
2025-07-14 12:21:11|INFO|getOrderList|where:{"Shop_ID":-1}
2025-07-14 12:21:11|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":-1}
2025-07-14 12:21:11|SQL|[#2 - 0.49ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(212):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT res.Order_ID,max(res.ss_storage_date) as ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12, -12)) AND (A.Shop_ID = -1);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-14 12:21:11|INFO|getOrderList|查询结果条数:0
2025-07-14 12:21:18|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2MjUwLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNTQ1MH0.FKWSQMA_VK6Jv5jLbj0YaMfUncapb0n6NYcCImgd2nA
2025-07-14 12:21:18|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1752466250,"data":{"orderId":null,"uuid":null},"scopes":"role_access","exp":1752725450}
2025-07-14 12:21:18|SQL|[#1 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(59):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = -1);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2025-07-14 12:21:18|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2MjUwLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNTQ1MH0.FKWSQMA_VK6Jv5jLbj0YaMfUncapb0n6NYcCImgd2nA
2025-07-14 12:21:18|SQL|[#1 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(52):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.AdminUser_MtSsUser.GetAllSS"}}
2025-07-14 12:21:18|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2MjUwLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNTQ1MH0.FKWSQMA_VK6Jv5jLbj0YaMfUncapb0n6NYcCImgd2nA
2025-07-14 12:21:18|INFO|orderList|shopId:
2025-07-14 12:21:18|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1752466250,"data":{"orderId":null,"uuid":null},"scopes":"role_access","exp":1752725450}
2025-07-14 12:21:18|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":-1,"$freeword":null,"$orderId":null}
2025-07-14 12:21:18|INFO|getOrderList|担当者所属的店铺id:-1
2025-07-14 12:21:18|SQL|[#1 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(167):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = -1);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-14 12:21:18|INFO|getOrderList|担当者所属的店铺ids:-1
2025-07-14 12:21:18|INFO|getOrderList|where:{"Shop_ID":-1}
2025-07-14 12:21:18|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":-1}
2025-07-14 12:21:18|SQL|[#2 - 0.5ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(212):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT res.Order_ID,max(res.ss_storage_date) as ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12, -12)) AND (A.Shop_ID = -1);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-14 12:21:18|INFO|getOrderList|查询结果条数:0
2025-07-14 12:21:26|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2MjUwLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNTQ1MH0.FKWSQMA_VK6Jv5jLbj0YaMfUncapb0n6NYcCImgd2nA
2025-07-14 12:21:26|SQL|[#1 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(52):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.AdminUser_MtSsUser.GetAllSS"}}
2025-07-14 12:21:26|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2MjUwLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNTQ1MH0.FKWSQMA_VK6Jv5jLbj0YaMfUncapb0n6NYcCImgd2nA
2025-07-14 12:21:26|INFO|orderList|shopId:
2025-07-14 12:21:26|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1752466250,"data":{"orderId":null,"uuid":null},"scopes":"role_access","exp":1752725450}
2025-07-14 12:21:26|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":-1,"$freeword":null,"$orderId":null}
2025-07-14 12:21:26|INFO|getOrderList|担当者所属的店铺id:-1
2025-07-14 12:21:26|SQL|[#1 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(167):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = -1);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-14 12:21:26|INFO|getOrderList|担当者所属的店铺ids:-1
2025-07-14 12:21:26|INFO|getOrderList|where:{"Shop_ID":-1}
2025-07-14 12:21:26|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":-1}
2025-07-14 12:21:26|SQL|[#2 - 0.69ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(212):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT res.Order_ID,max(res.ss_storage_date) as ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12, -12)) AND (A.Shop_ID = -1);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-14 12:21:26|INFO|getOrderList|查询结果条数:0
2025-07-14 12:21:26|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2MjUwLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNTQ1MH0.FKWSQMA_VK6Jv5jLbj0YaMfUncapb0n6NYcCImgd2nA
2025-07-14 12:21:26|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1752466250,"data":{"orderId":null,"uuid":null},"scopes":"role_access","exp":1752725450}
2025-07-14 12:21:26|SQL|[#1 - 0.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(59):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = -1);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2025-07-14 12:21:30|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2MjUwLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNTQ1MH0.FKWSQMA_VK6Jv5jLbj0YaMfUncapb0n6NYcCImgd2nA
2025-07-14 12:21:30|SQL|[#1 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(52):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.AdminUser_MtSsUser.GetAllSS"}}
2025-07-14 12:21:30|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2MjUwLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNTQ1MH0.FKWSQMA_VK6Jv5jLbj0YaMfUncapb0n6NYcCImgd2nA
2025-07-14 12:21:30|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1752466250,"data":{"orderId":null,"uuid":null},"scopes":"role_access","exp":1752725450}
2025-07-14 12:21:30|SQL|[#1 - 0.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(59):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = -1);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2025-07-14 12:21:30|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2MjUwLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNTQ1MH0.FKWSQMA_VK6Jv5jLbj0YaMfUncapb0n6NYcCImgd2nA
2025-07-14 12:21:30|INFO|orderList|shopId:
2025-07-14 12:21:30|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1752466250,"data":{"orderId":null,"uuid":null},"scopes":"role_access","exp":1752725450}
2025-07-14 12:21:30|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":-1,"$freeword":null,"$orderId":null}
2025-07-14 12:21:30|INFO|getOrderList|担当者所属的店铺id:-1
2025-07-14 12:21:30|SQL|[#1 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(167):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = -1);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-14 12:21:30|INFO|getOrderList|担当者所属的店铺ids:-1
2025-07-14 12:21:30|INFO|getOrderList|where:{"Shop_ID":-1}
2025-07-14 12:21:30|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":-1}
2025-07-14 12:21:30|SQL|[#2 - 0.65ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(212):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT res.Order_ID,max(res.ss_storage_date) as ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12, -12)) AND (A.Shop_ID = -1);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-14 12:21:30|INFO|getOrderList|查询结果条数:0
2025-07-14 12:21:47|INFO|mt_ss login|params:{"loginId":"admin","pw":"urutoraman1"}
2025-07-14 12:21:47|SQL|[#1 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Model/DataModel.php(165):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (log_in = 'admin') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.Login"}}
2025-07-14 12:21:47|INFO|mt_ss login|user:{"ID":18,"category":9,"ss_name":"admin","display_name":null,"en_name":"admin","section":null,"section_id":null,"log_in":"admin","pw":"urutoraman1","manager_flag":1,"comp_1":null,"comp_2":null,"comp_3":null,"comp_4":null,"comp_5":null,"test_marketing_flag":1,"rent_a_car":1,"towing":null,"Delete_date":null,"line_openid":"C","zip":null,"address":null,"telno":null,"faxno":null}
2025-07-14 12:21:47|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1752466907,"data":{"ssid":18}}
2025-07-14 12:21:47|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2OTA3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTI0NzA1MDd9.8qJ7IqlsByEmJVtgVzTtobpTz7o4s492oDxWQudkSgU
2025-07-14 12:21:47|SQL|[#1 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(52):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.AdminUser_MtSsUser.GetAllSS"}}
2025-07-14 12:21:47|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2OTA3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTI0NzA1MDd9.8qJ7IqlsByEmJVtgVzTtobpTz7o4s492oDxWQudkSgU
2025-07-14 12:21:47|INFO|orderList|shopId:
2025-07-14 12:21:47|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1752466907,"data":{"ssid":18},"scopes":"role_access","exp":1752470507}
2025-07-14 12:21:47|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null}
2025-07-14 12:21:47|INFO|getOrderList|担当者所属的店铺id:18
2025-07-14 12:21:47|SQL|[#1 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(167):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-14 12:21:47|SQL|[#2 - 0.13ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-14 12:21:47|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2025-07-14 12:21:47|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-07-14 12:21:47|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-07-14 12:21:47|SQL|[#3 - 1.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(212):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT res.Order_ID,max(res.ss_storage_date) as ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12, -12)) AND (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22)));|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-14 12:21:47|INFO|getOrderList|查询结果条数:127
2025-07-14 12:21:47|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2OTA3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTI0NzA1MDd9.8qJ7IqlsByEmJVtgVzTtobpTz7o4s492oDxWQudkSgU
2025-07-14 12:21:47|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1752466907,"data":{"ssid":18},"scopes":"role_access","exp":1752470507}
2025-07-14 12:21:47|SQL|[#1 - 0.39ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(59):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2025-07-14 12:21:47|SQL|[#2 - 0.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(63):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (category <> ?) LIMIT 0,100; -- 9|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2025-07-14 12:21:53|INFO|qrCodePng|orderId:407
2025-07-14 12:21:53|INFO|qrCodePng|aes encrypt：2ZuhApoqM3bZ1tgx1gaY0K3
2025-07-14 12:21:53|INFO|qrCodePng|base64 encode:Mlp1aEFwb3FNM2JaMXRneDFnYVkwSzMgNDA3
2025-07-14 12:21:59|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2ODI3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNjAyN30.xL_sWU1mUNkjuDuHwSbWdEuP4cJ_bgUVL1ElK2H8Jw0
2025-07-14 12:21:59|SQL|[#1 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/OBD/MtObdError.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_obd_error    SELECT * FROM mt_obd_error LIMIT 0,100;|{"request":{"service":"App.Cars_Cars.getObdErrorInfo"}}
2025-07-14 12:22:00|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2ODI3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNjAyN30.xL_sWU1mUNkjuDuHwSbWdEuP4cJ_bgUVL1ElK2H8Jw0
2025-07-14 12:22:00|INFO|verification|params:{"orderId":"407","uuid":"00d7289d-5b93-4363-87fb-5fe4714b8f93","ciphertext":"2ZuhApoqM3bZ1tgx1gaY0K3"}
2025-07-14 12:22:00|INFO|verification|aes decrypt:407
2025-07-14 12:22:00|SQL|[#1 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '407') LIMIT 1;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-14 12:22:00|SQL|[#2 - 0.24ms - 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 `check_state` = 1 WHERE (order_id = '407');|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-14 12:22:00|SQL|[#3 - 0.74ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatOrderUuid.php(31):    App\Model\Order\DatOrderUuid::addOrderUuid()    u433670985_test.dat_order_uuid    INSERT  INTO dat_order_uuid (`order_id`, `uuid`, `create_time`, `ts`) VALUES ('407', '00d7289d-5b93-4363-87fb-5fe4714b8f93', '2025-07-14 12:22:00', 1752466920);|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-14 12:22:00|SQL|[#4 - 0.35ms - 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 = 1784);|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-14 12:22:00|SQL|[#5 - 0.47ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Filmthickness/DatVcFilmThickness.php(24):    App\Model\Filmthickness\DatVcFilmThickness::findFilmThicknessByCarId()    u433670985_test.dat_vc_film_thickness    SELECT * FROM dat_vc_film_thickness WHERE (car_id = 1784) LIMIT 1;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-14 12:22:00|SQL|[#6 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/OBD/DatVcObd.php(55):    App\Model\OBD\DatVcObd::getObdErrorListByCarId()    u433670985_test.dat_vc_obd    SELECT obd.error_no,oe.message FROM dat_vc_obd AS obd LEFT JOIN mt_obd_error AS oe ON obd.error_no = oe.error_no WHERE (obd.car_id = 1784);|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-14 12:22:00|SQL|[#7 - 0.58ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/OBD/MtObdUnitPrice.php(20):    App\Model\OBD\MtObdUnitPrice::getObdUnitPriceByKatashiki()    u433670985_test.mt_obd_unit_price    SELECT error_no,price FROM `mt_obd_unit_price` \n        where katashiki = :katashiki and price is not null\n        order by error_no; -- 'DBA-H92W'|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-14 12:22:00|SQL|[#8 - 0.21ms - 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 = 105) LIMIT 1;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-14 12:22:00|SQL|[#9 - 0.38ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/FormCtrl/MtVcFormCtrl.php(14):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_vc_form_ctrl    SELECT * FROM mt_vc_form_ctrl WHERE (view_id = 'car') LIMIT 0,100;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-14 12:22:00|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2ODI3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNjAyN30.xL_sWU1mUNkjuDuHwSbWdEuP4cJ_bgUVL1ElK2H8Jw0
2025-07-14 12:22:00|SQL|[#1 - 0.44ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Quote/DatVehicleInspectionQuote.php(24):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_vehicle_inspection_quote    SELECT * FROM dat_vehicle_inspection_quote WHERE (service = '2') LIMIT 0,100;|{"request":{"service":"App.Quote_VehicleInspectionQuote.vehicleInspectionQuoteInfo"}}
2025-07-14 12:22:00|SQL|[#2 - 0.85ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Quote/DatVehicleInspectionQuote.php(25):    App\Model\Quote\DatVehicleInspectionQuote::getVehicleInspectionQuoteDetailInfo()    u433670985_test.dat_vehicle_inspection_quote    SELECT q.title,qd.id,qd.vehicle_inspection_quote_id,qd.answer FROM dat_vehicle_inspection_quote AS q LEFT JOIN dat_vehicle_inspection_quote_detail AS qd ON q.id = qd.vehicle_inspection_quote_id;|{"request":{"service":"App.Quote_VehicleInspectionQuote.vehicleInspectionQuoteInfo"}}
2025-07-14 12:22:19|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2ODI3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNjAyN30.xL_sWU1mUNkjuDuHwSbWdEuP4cJ_bgUVL1ElK2H8Jw0
2025-07-14 12:22:19|INFO|downloadImg|params:{"orderId":"407","fileName":"report.jpg"}
2025-07-14 12:22:19|INFO|downloadImg|img path url:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/407_report.jpg
2025-07-14 12:23:58|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2ODI3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNjAyN30.xL_sWU1mUNkjuDuHwSbWdEuP4cJ_bgUVL1ElK2H8Jw0
2025-07-14 12:23:58|INFO|getVehicleInformation|orderId:407
2025-07-14 12:23:58|INFO|getVehicleInformation|electCertMgNo:0512250087290
2025-07-14 12:23:58|SQL|[#1 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '407') LIMIT 1;|{"request":{"service":"App.Task_NfcApi.getVehicleInformation"}}
2025-07-14 12:23:58|INFO|getVehicleInformation|data:{"electCertMgNo":"0512250087290","entryNo":"","carNo":"","carId":""}
2025-07-14 12:23:59|INFO|getVehicleInformation|response:"{\"result\":0,\"carIdInfo\":[{\"acceptoutputno\":\"00701\",\"electCertMgNo\":\"0512250087290\",\"carId\":\"K9664UH1307807\",\"electCertPublishDateE\":\"\u4ee4\u548c\",\"electCertPublishDateY\":\" 7\",\"electCertPublishDateM\":\" 5\",\"electCertPublishDateD\":\"21\",\"applicationDateE\":\"\u4ee4\u548c\",\"applicationDateY\":\" 7\",\"applicationDateM\":\" 5\",\"applicationDateD\":\"21\",\"entryNoSyaryono\":\"\u5bcc\u5c71\u3000\uff15\uff18\uff10\u3000\u3061\u3000\uff13\uff15\uff17\uff15\",\"grantdateE\":\"\u4ee4\u548c\",\"grantdateY\":\" 7\",\"grantdateM\":\" 5\",\"grantdateD\":\"21\",\"firstexamdateE\":\"\u5e73\u6210\",\"firstexamdateY\":\"22\",\"firstexamdateM\":\" 3\",\"carName\":\"\u30cb\u30c3\u30b5\u30f3\",\"carNameCode\":\"[213]\",\"carNo\":\"\uff28\uff19\uff12\uff37\uff0d\uff10\uff15\uff15\uff18\uff17\uff14\uff11\",\"model\":\"\uff24\uff22\uff21\uff0d\uff28\uff19\uff12\uff37\",\"engineModel\":\"\uff13\uff27\uff18\uff13\",\"ownernameLowLevelChar\":\"\u4f7f\u7528\u8005\u306b\u540c\u3058\",\"ownernameHighLevelChar\":\"\u4f7f\u7528\u8005\u306b\u540c\u3058\",\"ownerCode\":\"\",\"ownerAddress\":\"\u4f7f\u7528\u8005\u4f4f\u6240\u306b\u540c\u3058\",\"ownerAddressCode\":\"\",\"usernameLowLevelChar\":\"\u682a\u5f0f\u4f1a\u793e\u3000\uff33\uff28\uff29\uff2d\uff21\u30ab\u30fc\u30e9\u30a4\u30d5\u30b3\u30cd\u30af\u30c6\u30c3\u30c9\",\"usernameHighLevelChar\":\"\u682a\u5f0f\u4f1a\u793e\u3000\uff33\uff28\uff29\uff2d\uff21\u30ab\u30fc\u30e9\u30a4\u30d5\u30b3\u30cd\u30af\u30c6\u30c3\u30c9\",\"userCode\":\"[47506]\",\"userAddress\":\"\u5bcc\u5c71\u770c\u5bcc\u5c71\u5e02\u77f3\u5742\uff11\uff11\uff16\uff19\uff0d\uff11\",\"userAddressCode\":\"\",\"useheadqrter\":\"\u4f7f\u7528\u8005\u4f4f\u6240\u306b\u540c\u3058\",\"useheadqrterCode\":\"\",\"carKind\":\"\u8efd\u81ea\u52d5\u8eca\",\"use\":\"\u4e57\u7528\",\"privateBusiness\":\"\u81ea\u5bb6\u7528\",\"carShape\":\"\u30b9\u30c6\u30fc\u30b7\u30e7\u30f3\u30ef\u30b4\u30f3\",\"carShapeCode\":\"[003]\",\"cap\":\"4\",\"maxloadage\":\"-\",\"carWgt\":\"800\",\"carTotalWgt\":\"1020\",\"length\":\"339\",\"width\":\"147\",\"height\":\"155\",\"fAxWgt\":\"490\",\"rAxWgt\":\"310\",\"displacement\":\"0.65\",\"displacementUnit\":\"L\",\"fuelClass\":\"\u30ac\u30bd\u30ea\u30f3\",\"modelSp\":\"15411\",\"classNo\":\"2001\",\"validPeriodExpirdateE\":\"\u4ee4\u548c\",\"validPeriodExpirdateY\":\" 9\",\"validPeriodExpirdateM\":\" 3\",\"validPeriodExpirdateD\":\"29\",\"noteInfo\":\"\u3010\u5bcc\u5c71\u3011\\n\u8a18\u9332\u5909\u66f4\\n\u5e73\u6210\uff12\uff12\u5e74\u5ea6\u71c3\u8cbb\u57fa\u6e96\uff12\uff10\uff05\u5411\u4e0a\u9054\u6210\u8eca\\n\u5e73\u6210\uff11\uff10\u5e74\u9a12\u97f3\u898f\u5236\u8eca\u3000\u8fd1\u63a5\u6392\u6c17\u9a12\u97f3\u898f\u5236\u5024\uff19\uff16\uff44\uff22\\n\u4ee4\u548c\uff11\uff12\u5e74\u5ea6\u30a8\u30cd\u30eb\u30ae\u30fc\u6d88\u8cbb\u52b9\u7387\uff08\uff37\uff2c\uff34\uff23\u30e2\u30fc\u30c9\u71c3\u8cbb\u5024\uff09\u7b97\u5b9a\u672a\u4e86 \u4ee4\u548c\uff12\u5e74\u5ea6\u30a8\u30cd\u30eb\u30ae\u30fc\u6d88\u8cbb\u52b9\u7387\uff08\uff37\uff2c\uff34\uff23\u30e2\u30fc\u30c9\u71c3\u8cbb\u5024\uff09\u7b97\u5b9a\u672a\u4e86 \u4ee4\u548c\uff12\u5e74\u5ea6\u30a8\u30cd\u30eb\u30ae\u30fc\u6d88\u8cbb\u52b9\u7387\uff08\uff2a\uff23\uff10\uff18\u30e2\u30fc\u30c9\u71c3\u8cbb\u5024\uff09\u7b97\u5b9a\u672a\u4e86\\n\u3010\u8d70\u884c\u8ddd\u96e2\u8a08\u8868\u793a\u5024\u3011\uff11\uff11\uff15\uff0c\uff11\uff10\uff10\uff4b\uff4d\uff08\u4ee4\u548c\uff17\u5e74\uff13\u6708\uff11\uff13\u65e5\uff09\\n\u3010\u65e7\u8d70\u884c\u8ddd\u96e2\u8a08\u8868\u793a\u5024\u3011\uff11\uff10\uff14\uff0c\uff12\uff10\uff10\uff4b\uff4d\uff08\u4ee4\u548c\uff15\u5e74\uff13\u6708\uff11\uff16\u65e5\uff09\\n\u3010\u53d7\u691c\u7a2e\u5225\u3011\u6307\u5b9a\u6574\u5099\u8eca\u3000\u3010\u691c\u67fb\u6642\u306e\u70b9\u691c\u6574\u5099\u5b9f\u65bd\u72b6\u6cc1\u3011\u70b9\u691c\u6574\u5099\u8a18\u9332\u7c3f\u8a18\u8f09\u3042\u308a\\n\u3010\u53d7\u691c\u5f62\u614b\u3011\u6307\u5b9a\u6574\u5099\u5de5\u5834\",\"twodcInfoEntryNoSyaryono\":\"\u5bcc\u5c71\u3000\u3000\uff15\uff18\uff10\u3061\uff13\uff15\uff17\uff15\",\"twodcInfoCarNo\":\"H92W-0558741\",\"twodcInfoValdperdexpirdate\":\"270329\",\"twodcInfoModel\":\"DBA-H92W\",\"twodcInfoModelSpClassNo\":\"154112001\",\"twodcInfoCharInfo\":\"1\",\"twodcInfoEngineModel\":\"3G83\",\"twodcInfoCarNoStampPlace\":\"-  \",\"twodcInfoFirstexamdate\":\"1003\",\"twodcInfoFfAxWgt\":\"0049\",\"twodcInfoFrAxWgt\":\"-\",\"twodcInfoRfAxWgt\":\"-\",\"twodcInfoRrAxWgt\":\"0031\",\"twodcInfoNoiseReg\":\"10\",\"twodcInfoNearNoiseReg\":\"096\",\"twodcInfoDriveMethod\":\"-\",\"twodcInfoOpacimeterMeasCar\":\"-\",\"twodcInfoNoxPmMeasMode\":\"-\",\"twodcInfoNoxValue\":\"-   \",\"twodcInfoPmValue\":\"-    \",\"twodcInfoFuelClassCode\":\"01\",\"twodcInfoYobi\":\"999\"}]}"
2025-07-14 12:23:59|SQL|[#2 - 0.75ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Task/NfcApi.php(53):    PhalApi\Model\DataModel::insert()    u433670985_test.dat_nfc_car_json    INSERT  INTO dat_nfc_car_json (`order_id`, `elect_cert_mg_no`, `body`) VALUES ('407', '0512250087290', '{\"result\":0,\"carIdInfo\":[{\"acceptoutputno\":\"00701\",\"electCertMgNo\":\"0512250087290\",\"carId\":\"K9664UH1307807\",\"electCertPublishDateE\":\"令和\",\"electCertPublishDateY\":\" 7\",\"electCertPublishDateM\":\" 5\",\"electCertPublishDateD\":\"21\",\"applicationDateE\":\"令和\",\"applicationDateY\":\" 7\",\"applicationDateM\":\" 5\",\"applicationDateD\":\"21\",\"entryNoSyaryono\":\"富山　５８０　ち　３５７５\",\"grantdateE\":\"令和\",\"grantdateY\":\" 7\",\"grantdateM\":\" 5\",\"grantdateD\":\"21\",\"firstexamdateE\":\"平成\",\"firstexamdateY\":\"22\",\"firstexamdateM\":\" 3\",\"carName\":\"ニッサン\",\"carNameCode\":\"[213]\",\"carNo\":\"Ｈ９２Ｗ－０５５８７４１\",\"model\":\"ＤＢＡ－Ｈ９２Ｗ\",\"engineModel\":\"３Ｇ８３\",\"ownernameLowLevelChar\":\"使用者に同じ\",\"ownernameHighLevelChar\":\"使用者に同じ\",\"ownerCode\":\"\",\"ownerAddress\":\"使用者住所に同じ\",\"ownerAddressCode\":\"\",\"usernameLowLevelChar\":\"株式会社　ＳＨＩＭＡカーライフコネクテッド\",\"usernameHighLevelChar\":\"株式会社　ＳＨＩＭＡカーライフコネクテッド\",\"userCode\":\"[47506]\",\"userAddress\":\"富山県富山市石坂１１６９－１\",\"userAddressCode\":\"\",\"useheadqrter\":\"使用者住所に同じ\",\"useheadqrterCode\":\"\",\"carKind\":\"軽自動車\",\"use\":\"乗用\",\"privateBusiness\":\"自家用\",\"carShape\":\"ステーションワゴン\",\"carShapeCode\":\"[003]\",\"cap\":\"4\",\"maxloadage\":\"-\",\"carWgt\":\"800\",\"carTotalWgt\":\"1020\",\"length\":\"339\",\"width\":\"147\",\"height\":\"155\",\"fAxWgt\":\"490\",\"rAxWgt\":\"310\",\"displacement\":\"0.65\",\"displacementUnit\":\"L\",\"fuelClass\":\"ガソリン\",\"modelSp\":\"15411\",\"classNo\":\"2001\",\"validPeriodExpirdateE\":\"令和\",\"validPeriodExpirdateY\":\" 9\",\"validPeriodExpirdateM\":\" 3\",\"validPeriodExpirdateD\":\"29\",\"noteInfo\":\"【富山】\\n記録変更\\n平成２２年度燃費基準２０％向上達成車\\n平成１０年騒音規制車　近接排気騒音規制値９６ｄＢ\\n令和１２年度エネルギー消費効率（ＷＬＴＣモード燃費値）算定未了 令和２年度エネルギー消費効率（ＷＬＴＣモード燃費値）算定未了 令和２年度エネルギー消費効率（ＪＣ０８モード燃費値）算定未了\\n【走行距離計表示値】１１５，１００ｋｍ（令和７年３月１３日）\\n【旧走行距離計表示値】１０４，２００ｋｍ（令和５年３月１６日）\\n【受検種別】指定整備車　【検査時の点検整備実施状況】点検整備記録簿記載あり\\n【受検形態】指定整備工場\",\"twodcInfoEntryNoSyaryono\":\"富山　　５８０ち３５７５\",\"twodcInfoCarNo\":\"H92W-0558741\",\"twodcInfoValdperdexpirdate\":\"270329\",\"twodcInfoModel\":\"DBA-H92W\",\"twodcInfoModelSpClassNo\":\"154112001\",\"twodcInfoCharInfo\":\"1\",\"twodcInfoEngineModel\":\"3G83\",\"twodcInfoCarNoStampPlace\":\"-  \",\"twodcInfoFirstexamdate\":\"1003\",\"twodcInfoFfAxWgt\":\"0049\",\"twodcInfoFrAxWgt\":\"-\",\"twodcInfoRfAxWgt\":\"-\",\"twodcInfoRrAxWgt\":\"0031\",\"twodcInfoNoiseReg\":\"10\",\"twodcInfoNearNoiseReg\":\"096\",\"twodcInfoDriveMethod\":\"-\",\"twodcInfoOpacimeterMeasCar\":\"-\",\"twodcInfoNoxPmMeasMode\":\"-\",\"twodcInfoNoxValue\":\"-   \",\"twodcInfoPmValue\":\"-    \",\"twodcInfoFuelClassCode\":\"01\",\"twodcInfoYobi\":\"999\"}]}');|{"request":{"service":"App.Task_NfcApi.getVehicleInformation"}}
2025-07-14 12:23:59|SQL|[#3 - 0.52ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Task/NfcApi.php(75):    App\Model\Cars\DatCars::updateCarsInfo()    u433670985_test.dat_cars    UPDATE dat_cars SET `Year` = '2010(H22)', `syodo_date` = '2010-3-01', `make` = 'ニッサン', `katashiki` = 'DBA-H92W', `gendouki` = '3G83', `VIN` = 'H92W-0558741', `Syaken` = '2027-3-29', `purpose` = '乗用', `syubetu` = '軽自動車', `keijyou` = 'ステーションワゴン', `teiin` = '4', `saidaisekisairyou` = '-', `jyuuryou` = '800', `soujyuuryou` = '1020', `ruibetsu` = '2001', `Katashiki_Shitei` = '15411', `nagasa` = '339', `haba` = '147', `takasa` = '155', `haikiryou` = '0.65', `nenryou` = '01', `Delivary_Date` = '2025-5-21', `syoyuusya_name` = '使用者に同じ', `Registry_Name` = '使用者に同じ', `shiyousya_name` = '株式会社　ＳＨＩＭＡカーライフコネクテッド', `ex_shiyousya_name` = '株式会社　ＳＨＩＭＡカーライフコネクテッド', `drive` = '-', `Number` = '富山　５８０　ち　３５７５' WHERE (CarID = 1784);|{"request":{"service":"App.Task_NfcApi.getVehicleInformation"}}
2025-07-14 12:23:59|INFO|getVehicleInformation|return:{"Year":"2010(H22)","syodo_date":"2010-3-01","make":"\u30cb\u30c3\u30b5\u30f3","Color":null,"katashiki":"DBA-H92W","gendouki":"3G83","VIN":"H92W-0558741","Syaken":"2027-3-29","Millage":null,"purpose":"\u4e57\u7528","syubetu":"\u8efd\u81ea\u52d5\u8eca","keijyou":"\u30b9\u30c6\u30fc\u30b7\u30e7\u30f3\u30ef\u30b4\u30f3","teiin":"4","saidaisekisairyou":"-","jyuuryou":"800","soujyuuryou":"1020","ruibetsu":"2001","Katashiki_Shitei":"15411","nagasa":"339","haba":"147","takasa":"155","haikiryou":"0.65","nenryou":"01","Delivary_Date":"2025-5-21","syoyuusya_name":"\u4f7f\u7528\u8005\u306b\u540c\u3058","Registry_Name":"\u4f7f\u7528\u8005\u306b\u540c\u3058","syoyuusya_address":"","Registry_Address":"","shiyousya_name":"\u682a\u5f0f\u4f1a\u793e\u3000\uff33\uff28\uff29\uff2d\uff21\u30ab\u30fc\u30e9\u30a4\u30d5\u30b3\u30cd\u30af\u30c6\u30c3\u30c9","ex_shiyousya_name":"\u682a\u5f0f\u4f1a\u793e\u3000\uff33\uff28\uff29\uff2d\uff21\u30ab\u30fc\u30e9\u30a4\u30d5\u30b3\u30cd\u30af\u30c6\u30c3\u30c9","shiyousya_address":"","ex_shiyousya_address":"","drive":"-","Number":"\u5bcc\u5c71\u3000\uff15\uff18\uff10\u3000\u3061\u3000\uff13\uff15\uff17\uff15","Car_ID":1784}
2025-07-14 12:24:40|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2ODI3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNjAyN30.xL_sWU1mUNkjuDuHwSbWdEuP4cJ_bgUVL1ElK2H8Jw0
2025-07-14 12:24:40|INFO|downloadImg|params:{"orderId":"407","fileName":"report.jpg"}
2025-07-14 12:24:40|INFO|downloadImg|img path url:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/407_report.jpg
2025-07-14 12:25:18|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2ODI3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNjAyN30.xL_sWU1mUNkjuDuHwSbWdEuP4cJ_bgUVL1ElK2H8Jw0
2025-07-14 12:25:18|INFO|getVehicleInformation|orderId:407
2025-07-14 12:25:18|INFO|getVehicleInformation|electCertMgNo:571250052838
2025-07-14 12:25:18|SQL|[#1 - 0.39ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '407') LIMIT 1;|{"request":{"service":"App.Task_NfcApi.getVehicleInformation"}}
2025-07-14 12:25:18|INFO|getVehicleInformation|data:{"electCertMgNo":"571250052838","entryNo":"","carNo":"","carId":""}
2025-07-14 12:25:19|INFO|getVehicleInformation|response:"{\"result\":0,\"carIdInfo\":[{\"acceptoutputno\":\"01571\",\"formType\":\"\uff21\",\"electCertMgNo\":\"571250052838\",\"carId\":\"T9471KJ8397037\",\"electCertPublishDateE\":\"\u4ee4\u548c\",\"electCertPublishDateY\":\" 7\",\"electCertPublishDateM\":\" 6\",\"electCertPublishDateD\":\"30\",\"grantDateE\":\"\u4ee4\u548c\",\"grantDateY\":\" 7\",\"grantDateM\":\" 6\",\"grantDateD\":\"30\",\"transbrhChiefName\":\"\u5bcc\u5c71\u904b\u8f38\u652f\u5c40\u9577\",\"entryNoSyaryono\":\"\u5bcc\u5c71\u3000\uff15\uff10\uff12\u3000\u3059\u3000\uff15\uff10\uff15\uff17\",\"reggrantdateE\":\"\u4ee4\u548c\",\"reggrantdateY\":\" 7\",\"reggrantdateM\":\" 6\",\"reggrantdateD\":\"30\",\"firstregistdateE\":\"\u5e73\u6210\",\"firstregistdateY\":\"28\",\"firstregistdateM\":\"10\",\"carName\":\"\u30c8\u30e8\u30bf\",\"carNameCode\":\"[194]\",\"carNo\":\"\uff2e\uff28\uff30\uff11\uff10\uff0d\uff16\uff15\uff14\uff17\uff18\uff10\uff17\",\"model\":\"\uff24\uff21\uff21\uff0d\uff2e\uff28\uff30\uff11\uff10\",\"engineModel\":\"\uff11\uff2e\uff3a\uff0d\uff11\uff2c\uff2d\",\"ownernameLowLevelChar\":\"\u682a\u5f0f\u4f1a\u793e\u3000\uff33\uff28\uff29\uff2d\uff21\u30ab\u30fc\u30e9\u30a4\u30d5\u30b3\u30cd\u30af\u30c6\u30c3\u30c9\",\"ownernameHighLevelChar\":\"\u682a\u5f0f\u4f1a\u793e\u3000\uff33\uff28\uff29\uff2d\uff21\u30ab\u30fc\u30e9\u30a4\u30d5\u30b3\u30cd\u30af\u30c6\u30c3\u30c9\",\"ownerAddressChar\":\"\u5bcc\u5c71\u770c\u5bcc\u5c71\u5e02\u77f3\u5742\",\"ownerAddressNumValue\":\"\uff11\uff11\uff16\uff19\uff0d\uff11\",\"ownerAddressCode\":\"[47506]\",\"usernameLowLevelChar\":\"\uff0a\uff0a\uff0a\",\"usernameHighLevelChar\":\"\uff0a\uff0a\uff0a\",\"userAddressChar\":\"\uff0a\uff0a\uff0a\",\"userAddressNumValue\":\"\",\"userAddressCode\":\"\",\"useheadqrterChar\":\"\uff0a\uff0a\uff0a\",\"useheadqrterNumValue\":\"\",\"useheadqrterCode\":\"\",\"carKind\":\"\u5c0f\u3000\u578b\",\"use\":\"\u4e57\u7528\",\"privateBusiness\":\"\u81ea\u5bb6\u7528\",\"carShape\":\"\u7bb1\u578b\",\"carShapeCode\":\"[001]\",\"noteCap\":\"\",\"cap\":\"5\",\"noteMaxloadage\":\"\",\"maxloadage\":\"-\",\"noteCarWgt\":\"\",\"carWgt\":\"1080\",\"noteCarTotalWgt\":\"\",\"carTotalWgt\":\"1355\",\"noteLength\":\"\",\"length\":\"399\",\"noteWidth\":\"\",\"width\":\"169\",\"noteHeight\":\"\",\"height\":\"145\",\"ffAxWgt\":\"680\",\"frAxWgt\":\"-\",\"rfAxWgt\":\"-\",\"rrAxWgt\":\"400\",\"displacement\":\"1.49\",\"fuelClass\":\"\u30ac\u30bd\u30ea\u30f3\",\"modelSp\":\"17053\",\"classNo\":\"0445\",\"validPeriodExpirdateE\":\"\u4ee4\u548c\",\"validPeriodExpirdateY\":\" 7\",\"validPeriodExpirdateM\":\"10\",\"validPeriodExpirdateD\":\"28\",\"noteInfo\":\"\uff3b\u5bcc\u5c71\uff3d\uff0c\u79fb\u8ee2\u767b\u9332\\n\uff3b\uff12\uff17\u5e74\u5ea6\u7a0e\u5236\uff3d\u5e73\u6210\uff12\uff18\u5e74\uff11\uff10\u6708\uff12\uff16\u65e5\u3000\u65b0\u898f\u767b\u9332\u3000\u514d\u7a0e\u63aa\u7f6e\u6e08\u307f\\n\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u4ee4\u548c\uff11\u5e74\uff11\uff10\u6708\uff12\uff19\u65e5\u3000\u7d99\u7d9a\u691c\u67fb\u3000\u514d\u7a0e\u63aa\u7f6e\u6e08\u307f\\n\u4ee4\u548c\uff11\uff12\u5e74\u5ea6\u30a8\u30cd\u30eb\u30ae\u30fc\u6d88\u8cbb\u52b9\u7387\uff08\uff37\uff2c\uff34\uff23\u30e2\u30fc\u30c9\u71c3\u8cbb\u5024\uff09\u7b97\u5b9a\u672a\u4e86\\n\u4ee4\u548c\uff12\u5e74\u5ea6\u71c3\u8cbb\u57fa\u6e96\uff11\uff15\uff10\uff05\u9054\u6210\u8eca\\n\u4ee4\u548c\uff12\u5e74\u5ea6\u30a8\u30cd\u30eb\u30ae\u30fc\u6d88\u8cbb\u52b9\u7387\uff08\uff37\uff2c\uff34\uff23\u30e2\u30fc\u30c9\u71c3\u8cbb\u5024\uff09\u7b97\u5b9a\u672a\u4e86\\n\u5e73\u6210\uff12\uff17\u5e74\u5ea6\u71c3\u8cbb\u57fa\u6e96\uff12\uff10\uff05\u5411\u4e0a\u9054\u6210\u8eca\\n\uff3b\u8d70\u884c\u8ddd\u96e2\u8a08\u8868\u793a\u5024\uff3d\uff15\uff14\uff0c\uff19\uff10\uff10\uff4b\uff4d\uff08\u4ee4\u548c\uff15\u5e74\uff11\uff10\u6708\uff11\uff18\u65e5\uff09\\n\uff3b\u65e7\u8d70\u884c\u8ddd\u96e2\u8a08\u8868\u793a\u5024\uff3d\uff13\uff19\uff0c\uff11\uff10\uff10\uff4b\uff4d\uff08\u4ee4\u548c\uff13\u5e74\uff11\uff10\u6708\uff18\u65e5\uff09\\n\u30cf\u30a4\u30d6\u30ea\u30c3\u30c9\u8eca\\n\u5e73\u6210\uff11\uff10\u5e74\u9a12\u97f3\u898f\u5236\u8eca\uff0c\u8fd1\u63a5\u6392\u6c17\u9a12\u97f3\u898f\u5236\u5024\u3000\uff19\uff16\uff44\uff22\\n\u30de\u30d5\u30e9\u30fc\u52a0\u901f\u9a12\u97f3\u898f\u5236\u9069\u7528\u8eca\\n\uff3b\u53d7\u691c\u7a2e\u5225\uff3d\u6307\u5b9a\u6574\u5099\u8eca\\n\uff3b\u691c\u67fb\u6642\u306e\u70b9\u691c\u6574\u5099\u5b9f\u65bd\u72b6\u6cc1\uff3d\u70b9\u691c\u6574\u5099\u8a18\u9332\u7c3f\u8a18\u8f09\u3042\u308a\\n\uff3b\u53d7\u691c\u5f62\u614b\uff3d\u6307\u5b9a\u6574\u5099\u5de5\u5834\\n\uff3b\u6574\u5099\u5de5\u5834\u30b3\u30fc\u30c9\uff3d\uff15\uff17\uff0d\uff13\uff10\uff11\uff15\uff12\",\"twodcInfoEntryNoSyaryono\":\"\u5bcc\u5c71\u3000\u3000\uff15\uff10\uff12\u3059\uff15\uff10\uff15\uff17\",\"twodcInfoCarNo\":\"NHP10-6547807\",\"twodcInfoValdperdexpirdate\":\"251028\",\"twodcInfoModel\":\"DAA-NHP10\",\"twodcInfoModelSpClassNo\":\"170530445\",\"twodcInfoCharInfo\":\"1\",\"twodcInfoEngineModel\":\"1NZ-1LM\",\"twodcInfoCarNoStampPlace\":\"-  \",\"twodcInfoFirstregistdate\":\"1610\",\"twodcInfoFfAxWgt\":\"0068\",\"twodcInfoFrAxWgt\":\"-   \",\"twodcInfoRfAxWgt\":\"-   \",\"twodcInfoRrAxWgt\":\"0040\",\"twodcInfoNoiseReg\":\"10\",\"twodcInfoNearNoiseReg\":\"096\",\"twodcInfoDriveMethod\":\"2\",\"twodcInfoOpacimeterMeasCar\":\"0\",\"twodcInfoNoxPmMeasMode\":\"I\",\"twodcInfoNoxValue\":\"0001\",\"twodcInfoPmValue\":\"-    \",\"twodcInfoSafeStdDate\":\"161024\",\"twodcInfoFuelClassCode\":\"01\"}]}"
2025-07-14 12:25:19|SQL|[#2 - 0.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Task/NfcApi.php(53):    PhalApi\Model\DataModel::insert()    u433670985_test.dat_nfc_car_json    INSERT  INTO dat_nfc_car_json (`order_id`, `elect_cert_mg_no`, `body`) VALUES ('407', '571250052838', '{\"result\":0,\"carIdInfo\":[{\"acceptoutputno\":\"01571\",\"formType\":\"Ａ\",\"electCertMgNo\":\"571250052838\",\"carId\":\"T9471KJ8397037\",\"electCertPublishDateE\":\"令和\",\"electCertPublishDateY\":\" 7\",\"electCertPublishDateM\":\" 6\",\"electCertPublishDateD\":\"30\",\"grantDateE\":\"令和\",\"grantDateY\":\" 7\",\"grantDateM\":\" 6\",\"grantDateD\":\"30\",\"transbrhChiefName\":\"富山運輸支局長\",\"entryNoSyaryono\":\"富山　５０２　す　５０５７\",\"reggrantdateE\":\"令和\",\"reggrantdateY\":\" 7\",\"reggrantdateM\":\" 6\",\"reggrantdateD\":\"30\",\"firstregistdateE\":\"平成\",\"firstregistdateY\":\"28\",\"firstregistdateM\":\"10\",\"carName\":\"トヨタ\",\"carNameCode\":\"[194]\",\"carNo\":\"ＮＨＰ１０－６５４７８０７\",\"model\":\"ＤＡＡ－ＮＨＰ１０\",\"engineModel\":\"１ＮＺ－１ＬＭ\",\"ownernameLowLevelChar\":\"株式会社　ＳＨＩＭＡカーライフコネクテッド\",\"ownernameHighLevelChar\":\"株式会社　ＳＨＩＭＡカーライフコネクテッド\",\"ownerAddressChar\":\"富山県富山市石坂\",\"ownerAddressNumValue\":\"１１６９－１\",\"ownerAddressCode\":\"[47506]\",\"usernameLowLevelChar\":\"＊＊＊\",\"usernameHighLevelChar\":\"＊＊＊\",\"userAddressChar\":\"＊＊＊\",\"userAddressNumValue\":\"\",\"userAddressCode\":\"\",\"useheadqrterChar\":\"＊＊＊\",\"useheadqrterNumValue\":\"\",\"useheadqrterCode\":\"\",\"carKind\":\"小　型\",\"use\":\"乗用\",\"privateBusiness\":\"自家用\",\"carShape\":\"箱型\",\"carShapeCode\":\"[001]\",\"noteCap\":\"\",\"cap\":\"5\",\"noteMaxloadage\":\"\",\"maxloadage\":\"-\",\"noteCarWgt\":\"\",\"carWgt\":\"1080\",\"noteCarTotalWgt\":\"\",\"carTotalWgt\":\"1355\",\"noteLength\":\"\",\"length\":\"399\",\"noteWidth\":\"\",\"width\":\"169\",\"noteHeight\":\"\",\"height\":\"145\",\"ffAxWgt\":\"680\",\"frAxWgt\":\"-\",\"rfAxWgt\":\"-\",\"rrAxWgt\":\"400\",\"displacement\":\"1.49\",\"fuelClass\":\"ガソリン\",\"modelSp\":\"17053\",\"classNo\":\"0445\",\"validPeriodExpirdateE\":\"令和\",\"validPeriodExpirdateY\":\" 7\",\"validPeriodExpirdateM\":\"10\",\"validPeriodExpirdateD\":\"28\",\"noteInfo\":\"［富山］，移転登録\\n［２７年度税制］平成２８年１０月２６日　新規登録　免税措置済み\\n　　　　　　　　令和１年１０月２９日　継続検査　免税措置済み\\n令和１２年度エネルギー消費効率（ＷＬＴＣモード燃費値）算定未了\\n令和２年度燃費基準１５０％達成車\\n令和２年度エネルギー消費効率（ＷＬＴＣモード燃費値）算定未了\\n平成２７年度燃費基準２０％向上達成車\\n［走行距離計表示値］５４，９００ｋｍ（令和５年１０月１８日）\\n［旧走行距離計表示値］３９，１００ｋｍ（令和３年１０月８日）\\nハイブリッド車\\n平成１０年騒音規制車，近接排気騒音規制値　９６ｄＢ\\nマフラー加速騒音規制適用車\\n［受検種別］指定整備車\\n［検査時の点検整備実施状況］点検整備記録簿記載あり\\n［受検形態］指定整備工場\\n［整備工場コード］５７－３０１５２\",\"twodcInfoEntryNoSyaryono\":\"富山　　５０２す５０５７\",\"twodcInfoCarNo\":\"NHP10-6547807\",\"twodcInfoValdperdexpirdate\":\"251028\",\"twodcInfoModel\":\"DAA-NHP10\",\"twodcInfoModelSpClassNo\":\"170530445\",\"twodcInfoCharInfo\":\"1\",\"twodcInfoEngineModel\":\"1NZ-1LM\",\"twodcInfoCarNoStampPlace\":\"-  \",\"twodcInfoFirstregistdate\":\"1610\",\"twodcInfoFfAxWgt\":\"0068\",\"twodcInfoFrAxWgt\":\"-   \",\"twodcInfoRfAxWgt\":\"-   \",\"twodcInfoRrAxWgt\":\"0040\",\"twodcInfoNoiseReg\":\"10\",\"twodcInfoNearNoiseReg\":\"096\",\"twodcInfoDriveMethod\":\"2\",\"twodcInfoOpacimeterMeasCar\":\"0\",\"twodcInfoNoxPmMeasMode\":\"I\",\"twodcInfoNoxValue\":\"0001\",\"twodcInfoPmValue\":\"-    \",\"twodcInfoSafeStdDate\":\"161024\",\"twodcInfoFuelClassCode\":\"01\"}]}');|{"request":{"service":"App.Task_NfcApi.getVehicleInformation"}}
2025-07-14 12:25:19|SQL|[#3 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Task/NfcApi.php(75):    App\Model\Cars\DatCars::updateCarsInfo()    u433670985_test.dat_cars    UPDATE dat_cars SET `Year` = '2016(H28)', `syodo_date` = '2016-10-01', `make` = 'トヨタ', `katashiki` = 'DAA-NHP10', `gendouki` = '1NZ-1LM', `VIN` = 'NHP10-6547807', `Syaken` = '2025-10-28', `purpose` = '乗用', `syubetu` = '小　型', `keijyou` = '箱型', `teiin` = '5', `saidaisekisairyou` = '-', `jyuuryou` = '1080', `soujyuuryou` = '1355', `ruibetsu` = '0445', `Katashiki_Shitei` = '17053', `nagasa` = '399', `haba` = '169', `takasa` = '145', `haikiryou` = '1.49', `nenryou` = '01', `Delivary_Date` = '2025-6-30', `syoyuusya_name` = '株式会社　ＳＨＩＭＡカーライフコネクテッド', `Registry_Name` = '株式会社　ＳＨＩＭＡカーライフコネクテッド', `syoyuusya_address` = '富山県富山市石坂１１６９－１[47506]', `Registry_Address` = '富山県富山市石坂１１６９－１[47506]', `shiyousya_name` = '＊＊＊', `ex_shiyousya_name` = '＊＊＊', `shiyousya_address` = '＊＊＊', `ex_shiyousya_address` = '＊＊＊', `drive` = '2', `Number` = '富山　５０２　す　５０５７' WHERE (CarID = 1784);|{"request":{"service":"App.Task_NfcApi.getVehicleInformation"}}
2025-07-14 12:25:19|INFO|getVehicleInformation|return:{"Year":"2016(H28)","syodo_date":"2016-10-01","make":"\u30c8\u30e8\u30bf","Color":null,"katashiki":"DAA-NHP10","gendouki":"1NZ-1LM","VIN":"NHP10-6547807","Syaken":"2025-10-28","Millage":null,"purpose":"\u4e57\u7528","syubetu":"\u5c0f\u3000\u578b","keijyou":"\u7bb1\u578b","teiin":"5","saidaisekisairyou":"-","jyuuryou":"1080","soujyuuryou":"1355","ruibetsu":"0445","Katashiki_Shitei":"17053","nagasa":"399","haba":"169","takasa":"145","haikiryou":"1.49","nenryou":"01","Delivary_Date":"2025-6-30","syoyuusya_name":"\u682a\u5f0f\u4f1a\u793e\u3000\uff33\uff28\uff29\uff2d\uff21\u30ab\u30fc\u30e9\u30a4\u30d5\u30b3\u30cd\u30af\u30c6\u30c3\u30c9","Registry_Name":"\u682a\u5f0f\u4f1a\u793e\u3000\uff33\uff28\uff29\uff2d\uff21\u30ab\u30fc\u30e9\u30a4\u30d5\u30b3\u30cd\u30af\u30c6\u30c3\u30c9","syoyuusya_address":"\u5bcc\u5c71\u770c\u5bcc\u5c71\u5e02\u77f3\u5742\uff11\uff11\uff16\uff19\uff0d\uff11[47506]","Registry_Address":"\u5bcc\u5c71\u770c\u5bcc\u5c71\u5e02\u77f3\u5742\uff11\uff11\uff16\uff19\uff0d\uff11[47506]","shiyousya_name":"\uff0a\uff0a\uff0a","ex_shiyousya_name":"\uff0a\uff0a\uff0a","shiyousya_address":"\uff0a\uff0a\uff0a","ex_shiyousya_address":"\uff0a\uff0a\uff0a","drive":"2","Number":"\u5bcc\u5c71\u3000\uff15\uff10\uff12\u3000\u3059\u3000\uff15\uff10\uff15\uff17","Car_ID":1784}
2025-07-14 12:32:12|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2ODI3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNjAyN30.xL_sWU1mUNkjuDuHwSbWdEuP4cJ_bgUVL1ElK2H8Jw0
2025-07-14 12:32:12|INFO|downloadImg|params:{"orderId":"407","fileName":"report.jpg"}
2025-07-14 12:32:12|INFO|downloadImg|img path url:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/407_report.jpg
2025-07-14 12:33:18|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2ODI3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNjAyN30.xL_sWU1mUNkjuDuHwSbWdEuP4cJ_bgUVL1ElK2H8Jw0
2025-07-14 12:33:18|INFO|getVehicleInformation|orderId:407
2025-07-14 12:33:18|INFO|getVehicleInformation|electCertMgNo:0512250087290
2025-07-14 12:33:18|SQL|[#1 - 0.38ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '407') LIMIT 1;|{"request":{"service":"App.Task_NfcApi.getVehicleInformation"}}
2025-07-14 12:33:18|INFO|getVehicleInformation|data:{"electCertMgNo":"0512250087290","entryNo":"","carNo":"","carId":""}
2025-07-14 12:33:19|INFO|getVehicleInformation|response:"{\"result\":0,\"carIdInfo\":[{\"acceptoutputno\":\"00701\",\"electCertMgNo\":\"0512250087290\",\"carId\":\"K9664UH1307807\",\"electCertPublishDateE\":\"\u4ee4\u548c\",\"electCertPublishDateY\":\" 7\",\"electCertPublishDateM\":\" 5\",\"electCertPublishDateD\":\"21\",\"applicationDateE\":\"\u4ee4\u548c\",\"applicationDateY\":\" 7\",\"applicationDateM\":\" 5\",\"applicationDateD\":\"21\",\"entryNoSyaryono\":\"\u5bcc\u5c71\u3000\uff15\uff18\uff10\u3000\u3061\u3000\uff13\uff15\uff17\uff15\",\"grantdateE\":\"\u4ee4\u548c\",\"grantdateY\":\" 7\",\"grantdateM\":\" 5\",\"grantdateD\":\"21\",\"firstexamdateE\":\"\u5e73\u6210\",\"firstexamdateY\":\"22\",\"firstexamdateM\":\" 3\",\"carName\":\"\u30cb\u30c3\u30b5\u30f3\",\"carNameCode\":\"[213]\",\"carNo\":\"\uff28\uff19\uff12\uff37\uff0d\uff10\uff15\uff15\uff18\uff17\uff14\uff11\",\"model\":\"\uff24\uff22\uff21\uff0d\uff28\uff19\uff12\uff37\",\"engineModel\":\"\uff13\uff27\uff18\uff13\",\"ownernameLowLevelChar\":\"\u4f7f\u7528\u8005\u306b\u540c\u3058\",\"ownernameHighLevelChar\":\"\u4f7f\u7528\u8005\u306b\u540c\u3058\",\"ownerCode\":\"\",\"ownerAddress\":\"\u4f7f\u7528\u8005\u4f4f\u6240\u306b\u540c\u3058\",\"ownerAddressCode\":\"\",\"usernameLowLevelChar\":\"\u682a\u5f0f\u4f1a\u793e\u3000\uff33\uff28\uff29\uff2d\uff21\u30ab\u30fc\u30e9\u30a4\u30d5\u30b3\u30cd\u30af\u30c6\u30c3\u30c9\",\"usernameHighLevelChar\":\"\u682a\u5f0f\u4f1a\u793e\u3000\uff33\uff28\uff29\uff2d\uff21\u30ab\u30fc\u30e9\u30a4\u30d5\u30b3\u30cd\u30af\u30c6\u30c3\u30c9\",\"userCode\":\"[47506]\",\"userAddress\":\"\u5bcc\u5c71\u770c\u5bcc\u5c71\u5e02\u77f3\u5742\uff11\uff11\uff16\uff19\uff0d\uff11\",\"userAddressCode\":\"\",\"useheadqrter\":\"\u4f7f\u7528\u8005\u4f4f\u6240\u306b\u540c\u3058\",\"useheadqrterCode\":\"\",\"carKind\":\"\u8efd\u81ea\u52d5\u8eca\",\"use\":\"\u4e57\u7528\",\"privateBusiness\":\"\u81ea\u5bb6\u7528\",\"carShape\":\"\u30b9\u30c6\u30fc\u30b7\u30e7\u30f3\u30ef\u30b4\u30f3\",\"carShapeCode\":\"[003]\",\"cap\":\"4\",\"maxloadage\":\"-\",\"carWgt\":\"800\",\"carTotalWgt\":\"1020\",\"length\":\"339\",\"width\":\"147\",\"height\":\"155\",\"fAxWgt\":\"490\",\"rAxWgt\":\"310\",\"displacement\":\"0.65\",\"displacementUnit\":\"L\",\"fuelClass\":\"\u30ac\u30bd\u30ea\u30f3\",\"modelSp\":\"15411\",\"classNo\":\"2001\",\"validPeriodExpirdateE\":\"\u4ee4\u548c\",\"validPeriodExpirdateY\":\" 9\",\"validPeriodExpirdateM\":\" 3\",\"validPeriodExpirdateD\":\"29\",\"noteInfo\":\"\u3010\u5bcc\u5c71\u3011\\n\u8a18\u9332\u5909\u66f4\\n\u5e73\u6210\uff12\uff12\u5e74\u5ea6\u71c3\u8cbb\u57fa\u6e96\uff12\uff10\uff05\u5411\u4e0a\u9054\u6210\u8eca\\n\u5e73\u6210\uff11\uff10\u5e74\u9a12\u97f3\u898f\u5236\u8eca\u3000\u8fd1\u63a5\u6392\u6c17\u9a12\u97f3\u898f\u5236\u5024\uff19\uff16\uff44\uff22\\n\u4ee4\u548c\uff11\uff12\u5e74\u5ea6\u30a8\u30cd\u30eb\u30ae\u30fc\u6d88\u8cbb\u52b9\u7387\uff08\uff37\uff2c\uff34\uff23\u30e2\u30fc\u30c9\u71c3\u8cbb\u5024\uff09\u7b97\u5b9a\u672a\u4e86 \u4ee4\u548c\uff12\u5e74\u5ea6\u30a8\u30cd\u30eb\u30ae\u30fc\u6d88\u8cbb\u52b9\u7387\uff08\uff37\uff2c\uff34\uff23\u30e2\u30fc\u30c9\u71c3\u8cbb\u5024\uff09\u7b97\u5b9a\u672a\u4e86 \u4ee4\u548c\uff12\u5e74\u5ea6\u30a8\u30cd\u30eb\u30ae\u30fc\u6d88\u8cbb\u52b9\u7387\uff08\uff2a\uff23\uff10\uff18\u30e2\u30fc\u30c9\u71c3\u8cbb\u5024\uff09\u7b97\u5b9a\u672a\u4e86\\n\u3010\u8d70\u884c\u8ddd\u96e2\u8a08\u8868\u793a\u5024\u3011\uff11\uff11\uff15\uff0c\uff11\uff10\uff10\uff4b\uff4d\uff08\u4ee4\u548c\uff17\u5e74\uff13\u6708\uff11\uff13\u65e5\uff09\\n\u3010\u65e7\u8d70\u884c\u8ddd\u96e2\u8a08\u8868\u793a\u5024\u3011\uff11\uff10\uff14\uff0c\uff12\uff10\uff10\uff4b\uff4d\uff08\u4ee4\u548c\uff15\u5e74\uff13\u6708\uff11\uff16\u65e5\uff09\\n\u3010\u53d7\u691c\u7a2e\u5225\u3011\u6307\u5b9a\u6574\u5099\u8eca\u3000\u3010\u691c\u67fb\u6642\u306e\u70b9\u691c\u6574\u5099\u5b9f\u65bd\u72b6\u6cc1\u3011\u70b9\u691c\u6574\u5099\u8a18\u9332\u7c3f\u8a18\u8f09\u3042\u308a\\n\u3010\u53d7\u691c\u5f62\u614b\u3011\u6307\u5b9a\u6574\u5099\u5de5\u5834\",\"twodcInfoEntryNoSyaryono\":\"\u5bcc\u5c71\u3000\u3000\uff15\uff18\uff10\u3061\uff13\uff15\uff17\uff15\",\"twodcInfoCarNo\":\"H92W-0558741\",\"twodcInfoValdperdexpirdate\":\"270329\",\"twodcInfoModel\":\"DBA-H92W\",\"twodcInfoModelSpClassNo\":\"154112001\",\"twodcInfoCharInfo\":\"1\",\"twodcInfoEngineModel\":\"3G83\",\"twodcInfoCarNoStampPlace\":\"-  \",\"twodcInfoFirstexamdate\":\"1003\",\"twodcInfoFfAxWgt\":\"0049\",\"twodcInfoFrAxWgt\":\"-\",\"twodcInfoRfAxWgt\":\"-\",\"twodcInfoRrAxWgt\":\"0031\",\"twodcInfoNoiseReg\":\"10\",\"twodcInfoNearNoiseReg\":\"096\",\"twodcInfoDriveMethod\":\"-\",\"twodcInfoOpacimeterMeasCar\":\"-\",\"twodcInfoNoxPmMeasMode\":\"-\",\"twodcInfoNoxValue\":\"-   \",\"twodcInfoPmValue\":\"-    \",\"twodcInfoFuelClassCode\":\"01\",\"twodcInfoYobi\":\"999\"}]}"
2025-07-14 12:33:19|SQL|[#2 - 0.38ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Task/NfcApi.php(53):    PhalApi\Model\DataModel::insert()    u433670985_test.dat_nfc_car_json    INSERT  INTO dat_nfc_car_json (`order_id`, `elect_cert_mg_no`, `body`) VALUES ('407', '0512250087290', '{\"result\":0,\"carIdInfo\":[{\"acceptoutputno\":\"00701\",\"electCertMgNo\":\"0512250087290\",\"carId\":\"K9664UH1307807\",\"electCertPublishDateE\":\"令和\",\"electCertPublishDateY\":\" 7\",\"electCertPublishDateM\":\" 5\",\"electCertPublishDateD\":\"21\",\"applicationDateE\":\"令和\",\"applicationDateY\":\" 7\",\"applicationDateM\":\" 5\",\"applicationDateD\":\"21\",\"entryNoSyaryono\":\"富山　５８０　ち　３５７５\",\"grantdateE\":\"令和\",\"grantdateY\":\" 7\",\"grantdateM\":\" 5\",\"grantdateD\":\"21\",\"firstexamdateE\":\"平成\",\"firstexamdateY\":\"22\",\"firstexamdateM\":\" 3\",\"carName\":\"ニッサン\",\"carNameCode\":\"[213]\",\"carNo\":\"Ｈ９２Ｗ－０５５８７４１\",\"model\":\"ＤＢＡ－Ｈ９２Ｗ\",\"engineModel\":\"３Ｇ８３\",\"ownernameLowLevelChar\":\"使用者に同じ\",\"ownernameHighLevelChar\":\"使用者に同じ\",\"ownerCode\":\"\",\"ownerAddress\":\"使用者住所に同じ\",\"ownerAddressCode\":\"\",\"usernameLowLevelChar\":\"株式会社　ＳＨＩＭＡカーライフコネクテッド\",\"usernameHighLevelChar\":\"株式会社　ＳＨＩＭＡカーライフコネクテッド\",\"userCode\":\"[47506]\",\"userAddress\":\"富山県富山市石坂１１６９－１\",\"userAddressCode\":\"\",\"useheadqrter\":\"使用者住所に同じ\",\"useheadqrterCode\":\"\",\"carKind\":\"軽自動車\",\"use\":\"乗用\",\"privateBusiness\":\"自家用\",\"carShape\":\"ステーションワゴン\",\"carShapeCode\":\"[003]\",\"cap\":\"4\",\"maxloadage\":\"-\",\"carWgt\":\"800\",\"carTotalWgt\":\"1020\",\"length\":\"339\",\"width\":\"147\",\"height\":\"155\",\"fAxWgt\":\"490\",\"rAxWgt\":\"310\",\"displacement\":\"0.65\",\"displacementUnit\":\"L\",\"fuelClass\":\"ガソリン\",\"modelSp\":\"15411\",\"classNo\":\"2001\",\"validPeriodExpirdateE\":\"令和\",\"validPeriodExpirdateY\":\" 9\",\"validPeriodExpirdateM\":\" 3\",\"validPeriodExpirdateD\":\"29\",\"noteInfo\":\"【富山】\\n記録変更\\n平成２２年度燃費基準２０％向上達成車\\n平成１０年騒音規制車　近接排気騒音規制値９６ｄＢ\\n令和１２年度エネルギー消費効率（ＷＬＴＣモード燃費値）算定未了 令和２年度エネルギー消費効率（ＷＬＴＣモード燃費値）算定未了 令和２年度エネルギー消費効率（ＪＣ０８モード燃費値）算定未了\\n【走行距離計表示値】１１５，１００ｋｍ（令和７年３月１３日）\\n【旧走行距離計表示値】１０４，２００ｋｍ（令和５年３月１６日）\\n【受検種別】指定整備車　【検査時の点検整備実施状況】点検整備記録簿記載あり\\n【受検形態】指定整備工場\",\"twodcInfoEntryNoSyaryono\":\"富山　　５８０ち３５７５\",\"twodcInfoCarNo\":\"H92W-0558741\",\"twodcInfoValdperdexpirdate\":\"270329\",\"twodcInfoModel\":\"DBA-H92W\",\"twodcInfoModelSpClassNo\":\"154112001\",\"twodcInfoCharInfo\":\"1\",\"twodcInfoEngineModel\":\"3G83\",\"twodcInfoCarNoStampPlace\":\"-  \",\"twodcInfoFirstexamdate\":\"1003\",\"twodcInfoFfAxWgt\":\"0049\",\"twodcInfoFrAxWgt\":\"-\",\"twodcInfoRfAxWgt\":\"-\",\"twodcInfoRrAxWgt\":\"0031\",\"twodcInfoNoiseReg\":\"10\",\"twodcInfoNearNoiseReg\":\"096\",\"twodcInfoDriveMethod\":\"-\",\"twodcInfoOpacimeterMeasCar\":\"-\",\"twodcInfoNoxPmMeasMode\":\"-\",\"twodcInfoNoxValue\":\"-   \",\"twodcInfoPmValue\":\"-    \",\"twodcInfoFuelClassCode\":\"01\",\"twodcInfoYobi\":\"999\"}]}');|{"request":{"service":"App.Task_NfcApi.getVehicleInformation"}}
2025-07-14 12:33:19|SQL|[#3 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Task/NfcApi.php(75):    App\Model\Cars\DatCars::updateCarsInfo()    u433670985_test.dat_cars    UPDATE dat_cars SET `Year` = '2010(H22)', `syodo_date` = '2010-3-01', `make` = 'ニッサン', `katashiki` = 'DBA-H92W', `gendouki` = '3G83', `VIN` = 'H92W-0558741', `Syaken` = '2027-3-29', `purpose` = '乗用', `syubetu` = '軽自動車', `keijyou` = 'ステーションワゴン', `teiin` = '4', `saidaisekisairyou` = '-', `jyuuryou` = '800', `soujyuuryou` = '1020', `ruibetsu` = '2001', `Katashiki_Shitei` = '15411', `nagasa` = '339', `haba` = '147', `takasa` = '155', `haikiryou` = '0.65', `nenryou` = '01', `Delivary_Date` = '2025-5-21', `syoyuusya_name` = '使用者に同じ', `Registry_Name` = '使用者に同じ', `shiyousya_name` = '株式会社　ＳＨＩＭＡカーライフコネクテッド', `ex_shiyousya_name` = '株式会社　ＳＨＩＭＡカーライフコネクテッド', `drive` = '-', `Number` = '富山　５８０　ち　３５７５' WHERE (CarID = 1784);|{"request":{"service":"App.Task_NfcApi.getVehicleInformation"}}
2025-07-14 12:33:19|INFO|getVehicleInformation|return:{"Year":"2010(H22)","syodo_date":"2010-3-01","make":"\u30cb\u30c3\u30b5\u30f3","Color":null,"katashiki":"DBA-H92W","gendouki":"3G83","VIN":"H92W-0558741","Syaken":"2027-3-29","Millage":null,"purpose":"\u4e57\u7528","syubetu":"\u8efd\u81ea\u52d5\u8eca","keijyou":"\u30b9\u30c6\u30fc\u30b7\u30e7\u30f3\u30ef\u30b4\u30f3","teiin":"4","saidaisekisairyou":"-","jyuuryou":"800","soujyuuryou":"1020","ruibetsu":"2001","Katashiki_Shitei":"15411","nagasa":"339","haba":"147","takasa":"155","haikiryou":"0.65","nenryou":"01","Delivary_Date":"2025-5-21","syoyuusya_name":"\u4f7f\u7528\u8005\u306b\u540c\u3058","Registry_Name":"\u4f7f\u7528\u8005\u306b\u540c\u3058","syoyuusya_address":"","Registry_Address":"","shiyousya_name":"\u682a\u5f0f\u4f1a\u793e\u3000\uff33\uff28\uff29\uff2d\uff21\u30ab\u30fc\u30e9\u30a4\u30d5\u30b3\u30cd\u30af\u30c6\u30c3\u30c9","ex_shiyousya_name":"\u682a\u5f0f\u4f1a\u793e\u3000\uff33\uff28\uff29\uff2d\uff21\u30ab\u30fc\u30e9\u30a4\u30d5\u30b3\u30cd\u30af\u30c6\u30c3\u30c9","shiyousya_address":"","ex_shiyousya_address":"","drive":"-","Number":"\u5bcc\u5c71\u3000\uff15\uff18\uff10\u3000\u3061\u3000\uff13\uff15\uff17\uff15","Car_ID":1784}
2025-07-14 12:49:52|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2ODI3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNjAyN30.xL_sWU1mUNkjuDuHwSbWdEuP4cJ_bgUVL1ElK2H8Jw0
2025-07-14 12:49:52|INFO|downloadImg|params:{"orderId":"407","fileName":"report.jpg"}
2025-07-14 12:49:52|INFO|downloadImg|img path url:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/407_report.jpg
2025-07-14 12:50:28|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY2ODI3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyNjAyN30.xL_sWU1mUNkjuDuHwSbWdEuP4cJ_bgUVL1ElK2H8Jw0
2025-07-14 12:50:28|INFO|getVehicleInformation|orderId:407
2025-07-14 12:50:28|INFO|getVehicleInformation|electCertMgNo:0512250087290
2025-07-14 12:50:28|SQL|[#1 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '407') LIMIT 1;|{"request":{"service":"App.Task_NfcApi.getVehicleInformation"}}
2025-07-14 12:50:28|INFO|getVehicleInformation|data:{"electCertMgNo":"0512250087290","entryNo":"","carNo":"","carId":""}
2025-07-14 12:50:29|INFO|getVehicleInformation|response:"{\"result\":0,\"carIdInfo\":[{\"acceptoutputno\":\"00701\",\"electCertMgNo\":\"0512250087290\",\"carId\":\"K9664UH1307807\",\"electCertPublishDateE\":\"\u4ee4\u548c\",\"electCertPublishDateY\":\" 7\",\"electCertPublishDateM\":\" 5\",\"electCertPublishDateD\":\"21\",\"applicationDateE\":\"\u4ee4\u548c\",\"applicationDateY\":\" 7\",\"applicationDateM\":\" 5\",\"applicationDateD\":\"21\",\"entryNoSyaryono\":\"\u5bcc\u5c71\u3000\uff15\uff18\uff10\u3000\u3061\u3000\uff13\uff15\uff17\uff15\",\"grantdateE\":\"\u4ee4\u548c\",\"grantdateY\":\" 7\",\"grantdateM\":\" 5\",\"grantdateD\":\"21\",\"firstexamdateE\":\"\u5e73\u6210\",\"firstexamdateY\":\"22\",\"firstexamdateM\":\" 3\",\"carName\":\"\u30cb\u30c3\u30b5\u30f3\",\"carNameCode\":\"[213]\",\"carNo\":\"\uff28\uff19\uff12\uff37\uff0d\uff10\uff15\uff15\uff18\uff17\uff14\uff11\",\"model\":\"\uff24\uff22\uff21\uff0d\uff28\uff19\uff12\uff37\",\"engineModel\":\"\uff13\uff27\uff18\uff13\",\"ownernameLowLevelChar\":\"\u4f7f\u7528\u8005\u306b\u540c\u3058\",\"ownernameHighLevelChar\":\"\u4f7f\u7528\u8005\u306b\u540c\u3058\",\"ownerCode\":\"\",\"ownerAddress\":\"\u4f7f\u7528\u8005\u4f4f\u6240\u306b\u540c\u3058\",\"ownerAddressCode\":\"\",\"usernameLowLevelChar\":\"\u682a\u5f0f\u4f1a\u793e\u3000\uff33\uff28\uff29\uff2d\uff21\u30ab\u30fc\u30e9\u30a4\u30d5\u30b3\u30cd\u30af\u30c6\u30c3\u30c9\",\"usernameHighLevelChar\":\"\u682a\u5f0f\u4f1a\u793e\u3000\uff33\uff28\uff29\uff2d\uff21\u30ab\u30fc\u30e9\u30a4\u30d5\u30b3\u30cd\u30af\u30c6\u30c3\u30c9\",\"userCode\":\"[47506]\",\"userAddress\":\"\u5bcc\u5c71\u770c\u5bcc\u5c71\u5e02\u77f3\u5742\uff11\uff11\uff16\uff19\uff0d\uff11\",\"userAddressCode\":\"\",\"useheadqrter\":\"\u4f7f\u7528\u8005\u4f4f\u6240\u306b\u540c\u3058\",\"useheadqrterCode\":\"\",\"carKind\":\"\u8efd\u81ea\u52d5\u8eca\",\"use\":\"\u4e57\u7528\",\"privateBusiness\":\"\u81ea\u5bb6\u7528\",\"carShape\":\"\u30b9\u30c6\u30fc\u30b7\u30e7\u30f3\u30ef\u30b4\u30f3\",\"carShapeCode\":\"[003]\",\"cap\":\"4\",\"maxloadage\":\"-\",\"carWgt\":\"800\",\"carTotalWgt\":\"1020\",\"length\":\"339\",\"width\":\"147\",\"height\":\"155\",\"fAxWgt\":\"490\",\"rAxWgt\":\"310\",\"displacement\":\"0.65\",\"displacementUnit\":\"L\",\"fuelClass\":\"\u30ac\u30bd\u30ea\u30f3\",\"modelSp\":\"15411\",\"classNo\":\"2001\",\"validPeriodExpirdateE\":\"\u4ee4\u548c\",\"validPeriodExpirdateY\":\" 9\",\"validPeriodExpirdateM\":\" 3\",\"validPeriodExpirdateD\":\"29\",\"noteInfo\":\"\u3010\u5bcc\u5c71\u3011\\n\u8a18\u9332\u5909\u66f4\\n\u5e73\u6210\uff12\uff12\u5e74\u5ea6\u71c3\u8cbb\u57fa\u6e96\uff12\uff10\uff05\u5411\u4e0a\u9054\u6210\u8eca\\n\u5e73\u6210\uff11\uff10\u5e74\u9a12\u97f3\u898f\u5236\u8eca\u3000\u8fd1\u63a5\u6392\u6c17\u9a12\u97f3\u898f\u5236\u5024\uff19\uff16\uff44\uff22\\n\u4ee4\u548c\uff11\uff12\u5e74\u5ea6\u30a8\u30cd\u30eb\u30ae\u30fc\u6d88\u8cbb\u52b9\u7387\uff08\uff37\uff2c\uff34\uff23\u30e2\u30fc\u30c9\u71c3\u8cbb\u5024\uff09\u7b97\u5b9a\u672a\u4e86 \u4ee4\u548c\uff12\u5e74\u5ea6\u30a8\u30cd\u30eb\u30ae\u30fc\u6d88\u8cbb\u52b9\u7387\uff08\uff37\uff2c\uff34\uff23\u30e2\u30fc\u30c9\u71c3\u8cbb\u5024\uff09\u7b97\u5b9a\u672a\u4e86 \u4ee4\u548c\uff12\u5e74\u5ea6\u30a8\u30cd\u30eb\u30ae\u30fc\u6d88\u8cbb\u52b9\u7387\uff08\uff2a\uff23\uff10\uff18\u30e2\u30fc\u30c9\u71c3\u8cbb\u5024\uff09\u7b97\u5b9a\u672a\u4e86\\n\u3010\u8d70\u884c\u8ddd\u96e2\u8a08\u8868\u793a\u5024\u3011\uff11\uff11\uff15\uff0c\uff11\uff10\uff10\uff4b\uff4d\uff08\u4ee4\u548c\uff17\u5e74\uff13\u6708\uff11\uff13\u65e5\uff09\\n\u3010\u65e7\u8d70\u884c\u8ddd\u96e2\u8a08\u8868\u793a\u5024\u3011\uff11\uff10\uff14\uff0c\uff12\uff10\uff10\uff4b\uff4d\uff08\u4ee4\u548c\uff15\u5e74\uff13\u6708\uff11\uff16\u65e5\uff09\\n\u3010\u53d7\u691c\u7a2e\u5225\u3011\u6307\u5b9a\u6574\u5099\u8eca\u3000\u3010\u691c\u67fb\u6642\u306e\u70b9\u691c\u6574\u5099\u5b9f\u65bd\u72b6\u6cc1\u3011\u70b9\u691c\u6574\u5099\u8a18\u9332\u7c3f\u8a18\u8f09\u3042\u308a\\n\u3010\u53d7\u691c\u5f62\u614b\u3011\u6307\u5b9a\u6574\u5099\u5de5\u5834\",\"twodcInfoEntryNoSyaryono\":\"\u5bcc\u5c71\u3000\u3000\uff15\uff18\uff10\u3061\uff13\uff15\uff17\uff15\",\"twodcInfoCarNo\":\"H92W-0558741\",\"twodcInfoValdperdexpirdate\":\"270329\",\"twodcInfoModel\":\"DBA-H92W\",\"twodcInfoModelSpClassNo\":\"154112001\",\"twodcInfoCharInfo\":\"1\",\"twodcInfoEngineModel\":\"3G83\",\"twodcInfoCarNoStampPlace\":\"-  \",\"twodcInfoFirstexamdate\":\"1003\",\"twodcInfoFfAxWgt\":\"0049\",\"twodcInfoFrAxWgt\":\"-\",\"twodcInfoRfAxWgt\":\"-\",\"twodcInfoRrAxWgt\":\"0031\",\"twodcInfoNoiseReg\":\"10\",\"twodcInfoNearNoiseReg\":\"096\",\"twodcInfoDriveMethod\":\"-\",\"twodcInfoOpacimeterMeasCar\":\"-\",\"twodcInfoNoxPmMeasMode\":\"-\",\"twodcInfoNoxValue\":\"-   \",\"twodcInfoPmValue\":\"-    \",\"twodcInfoFuelClassCode\":\"01\",\"twodcInfoYobi\":\"999\"}]}"
2025-07-14 12:50:29|SQL|[#2 - 3.03ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Task/NfcApi.php(53):    PhalApi\Model\DataModel::insert()    u433670985_test.dat_nfc_car_json    INSERT  INTO dat_nfc_car_json (`order_id`, `elect_cert_mg_no`, `body`) VALUES ('407', '0512250087290', '{\"result\":0,\"carIdInfo\":[{\"acceptoutputno\":\"00701\",\"electCertMgNo\":\"0512250087290\",\"carId\":\"K9664UH1307807\",\"electCertPublishDateE\":\"令和\",\"electCertPublishDateY\":\" 7\",\"electCertPublishDateM\":\" 5\",\"electCertPublishDateD\":\"21\",\"applicationDateE\":\"令和\",\"applicationDateY\":\" 7\",\"applicationDateM\":\" 5\",\"applicationDateD\":\"21\",\"entryNoSyaryono\":\"富山　５８０　ち　３５７５\",\"grantdateE\":\"令和\",\"grantdateY\":\" 7\",\"grantdateM\":\" 5\",\"grantdateD\":\"21\",\"firstexamdateE\":\"平成\",\"firstexamdateY\":\"22\",\"firstexamdateM\":\" 3\",\"carName\":\"ニッサン\",\"carNameCode\":\"[213]\",\"carNo\":\"Ｈ９２Ｗ－０５５８７４１\",\"model\":\"ＤＢＡ－Ｈ９２Ｗ\",\"engineModel\":\"３Ｇ８３\",\"ownernameLowLevelChar\":\"使用者に同じ\",\"ownernameHighLevelChar\":\"使用者に同じ\",\"ownerCode\":\"\",\"ownerAddress\":\"使用者住所に同じ\",\"ownerAddressCode\":\"\",\"usernameLowLevelChar\":\"株式会社　ＳＨＩＭＡカーライフコネクテッド\",\"usernameHighLevelChar\":\"株式会社　ＳＨＩＭＡカーライフコネクテッド\",\"userCode\":\"[47506]\",\"userAddress\":\"富山県富山市石坂１１６９－１\",\"userAddressCode\":\"\",\"useheadqrter\":\"使用者住所に同じ\",\"useheadqrterCode\":\"\",\"carKind\":\"軽自動車\",\"use\":\"乗用\",\"privateBusiness\":\"自家用\",\"carShape\":\"ステーションワゴン\",\"carShapeCode\":\"[003]\",\"cap\":\"4\",\"maxloadage\":\"-\",\"carWgt\":\"800\",\"carTotalWgt\":\"1020\",\"length\":\"339\",\"width\":\"147\",\"height\":\"155\",\"fAxWgt\":\"490\",\"rAxWgt\":\"310\",\"displacement\":\"0.65\",\"displacementUnit\":\"L\",\"fuelClass\":\"ガソリン\",\"modelSp\":\"15411\",\"classNo\":\"2001\",\"validPeriodExpirdateE\":\"令和\",\"validPeriodExpirdateY\":\" 9\",\"validPeriodExpirdateM\":\" 3\",\"validPeriodExpirdateD\":\"29\",\"noteInfo\":\"【富山】\\n記録変更\\n平成２２年度燃費基準２０％向上達成車\\n平成１０年騒音規制車　近接排気騒音規制値９６ｄＢ\\n令和１２年度エネルギー消費効率（ＷＬＴＣモード燃費値）算定未了 令和２年度エネルギー消費効率（ＷＬＴＣモード燃費値）算定未了 令和２年度エネルギー消費効率（ＪＣ０８モード燃費値）算定未了\\n【走行距離計表示値】１１５，１００ｋｍ（令和７年３月１３日）\\n【旧走行距離計表示値】１０４，２００ｋｍ（令和５年３月１６日）\\n【受検種別】指定整備車　【検査時の点検整備実施状況】点検整備記録簿記載あり\\n【受検形態】指定整備工場\",\"twodcInfoEntryNoSyaryono\":\"富山　　５８０ち３５７５\",\"twodcInfoCarNo\":\"H92W-0558741\",\"twodcInfoValdperdexpirdate\":\"270329\",\"twodcInfoModel\":\"DBA-H92W\",\"twodcInfoModelSpClassNo\":\"154112001\",\"twodcInfoCharInfo\":\"1\",\"twodcInfoEngineModel\":\"3G83\",\"twodcInfoCarNoStampPlace\":\"-  \",\"twodcInfoFirstexamdate\":\"1003\",\"twodcInfoFfAxWgt\":\"0049\",\"twodcInfoFrAxWgt\":\"-\",\"twodcInfoRfAxWgt\":\"-\",\"twodcInfoRrAxWgt\":\"0031\",\"twodcInfoNoiseReg\":\"10\",\"twodcInfoNearNoiseReg\":\"096\",\"twodcInfoDriveMethod\":\"-\",\"twodcInfoOpacimeterMeasCar\":\"-\",\"twodcInfoNoxPmMeasMode\":\"-\",\"twodcInfoNoxValue\":\"-   \",\"twodcInfoPmValue\":\"-    \",\"twodcInfoFuelClassCode\":\"01\",\"twodcInfoYobi\":\"999\"}]}');|{"request":{"service":"App.Task_NfcApi.getVehicleInformation"}}
2025-07-14 12:50:29|SQL|[#3 - 0.51ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Task/NfcApi.php(75):    App\Model\Cars\DatCars::updateCarsInfo()    u433670985_test.dat_cars    UPDATE dat_cars SET `Year` = '2010(H22)', `syodo_date` = '2010-3-01', `make` = 'ニッサン', `katashiki` = 'DBA-H92W', `gendouki` = '3G83', `VIN` = 'H92W-0558741', `Syaken` = '2027-3-29', `purpose` = '乗用', `syubetu` = '軽自動車', `keijyou` = 'ステーションワゴン', `teiin` = '4', `saidaisekisairyou` = '-', `jyuuryou` = '800', `soujyuuryou` = '1020', `ruibetsu` = '2001', `Katashiki_Shitei` = '15411', `nagasa` = '339', `haba` = '147', `takasa` = '155', `haikiryou` = '0.65', `nenryou` = '01', `Delivary_Date` = '2025-5-21', `syoyuusya_name` = '使用者に同じ', `Registry_Name` = '使用者に同じ', `syoyuusya_address` = '使用者住所に同じ', `Registry_Address` = '使用者住所に同じ', `shiyousya_name` = '株式会社　ＳＨＩＭＡカーライフコネクテッド', `ex_shiyousya_name` = '株式会社　ＳＨＩＭＡカーライフコネクテッド', `shiyousya_address` = '富山県富山市石坂１１６９－１', `ex_shiyousya_address` = '富山県富山市石坂１１６９－１', `drive` = '-', `Number` = '富山　５８０　ち　３５７５' WHERE (CarID = 1784);|{"request":{"service":"App.Task_NfcApi.getVehicleInformation"}}
2025-07-14 12:50:29|INFO|getVehicleInformation|return:{"Year":"2010(H22)","syodo_date":"2010-3-01","make":"\u30cb\u30c3\u30b5\u30f3","Color":null,"katashiki":"DBA-H92W","gendouki":"3G83","VIN":"H92W-0558741","Syaken":"2027-3-29","Millage":null,"purpose":"\u4e57\u7528","syubetu":"\u8efd\u81ea\u52d5\u8eca","keijyou":"\u30b9\u30c6\u30fc\u30b7\u30e7\u30f3\u30ef\u30b4\u30f3","teiin":"4","saidaisekisairyou":"-","jyuuryou":"800","soujyuuryou":"1020","ruibetsu":"2001","Katashiki_Shitei":"15411","nagasa":"339","haba":"147","takasa":"155","haikiryou":"0.65","nenryou":"01","Delivary_Date":"2025-5-21","syoyuusya_name":"\u4f7f\u7528\u8005\u306b\u540c\u3058","Registry_Name":"\u4f7f\u7528\u8005\u306b\u540c\u3058","syoyuusya_address":"\u4f7f\u7528\u8005\u4f4f\u6240\u306b\u540c\u3058","Registry_Address":"\u4f7f\u7528\u8005\u4f4f\u6240\u306b\u540c\u3058","shiyousya_name":"\u682a\u5f0f\u4f1a\u793e\u3000\uff33\uff28\uff29\uff2d\uff21\u30ab\u30fc\u30e9\u30a4\u30d5\u30b3\u30cd\u30af\u30c6\u30c3\u30c9","ex_shiyousya_name":"\u682a\u5f0f\u4f1a\u793e\u3000\uff33\uff28\uff29\uff2d\uff21\u30ab\u30fc\u30e9\u30a4\u30d5\u30b3\u30cd\u30af\u30c6\u30c3\u30c9","shiyousya_address":"\u5bcc\u5c71\u770c\u5bcc\u5c71\u5e02\u77f3\u5742\uff11\uff11\uff16\uff19\uff0d\uff11","ex_shiyousya_address":"\u5bcc\u5c71\u770c\u5bcc\u5c71\u5e02\u77f3\u5742\uff11\uff11\uff16\uff19\uff0d\uff11","drive":"-","Number":"\u5bcc\u5c71\u3000\uff15\uff18\uff10\u3000\u3061\u3000\uff13\uff15\uff17\uff15","Car_ID":1784}
2025-07-14 13:01:43|INFO|checkSourceUpdate|file:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../appview/dist.zip
2025-07-14 13:01:43|INFO|checkSourceUpdate|crc32:854971ee
2025-07-14 13:02:27|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY5MzA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyODUwN30.IP2xUewUA8wLqznDrB8b5XwwaFxsXhCVsWdRzdNfHfI
2025-07-14 13:02:27|SQL|[#1 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/OBD/MtObdError.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_obd_error    SELECT * FROM mt_obd_error LIMIT 0,100;|{"request":{"service":"App.Cars_Cars.getObdErrorInfo"}}
2025-07-14 13:02:37|INFO|mt_ss login|params:{"loginId":"admin","pw":"urutoraman1"}
2025-07-14 13:02:37|SQL|[#1 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Model/DataModel.php(165):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (log_in = 'admin') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.Login"}}
2025-07-14 13:02:37|INFO|mt_ss login|user:{"ID":18,"category":9,"ss_name":"admin","display_name":null,"en_name":"admin","section":null,"section_id":null,"log_in":"admin","pw":"urutoraman1","manager_flag":1,"comp_1":null,"comp_2":null,"comp_3":null,"comp_4":null,"comp_5":null,"test_marketing_flag":1,"rent_a_car":1,"towing":null,"Delete_date":null,"line_openid":"C","zip":null,"address":null,"telno":null,"faxno":null}
2025-07-14 13:02:37|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1752469357,"data":{"ssid":18}}
2025-07-14 13:02:37|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY5MzU3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTI0NzI5NTd9.J73xUYrUBIQEJr7hJl8OqG9SJzXnzw3wuFwe1OuRg6c
2025-07-14 13:02:37|INFO|orderList|shopId:
2025-07-14 13:02:37|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1752469357,"data":{"ssid":18},"scopes":"role_access","exp":1752472957}
2025-07-14 13:02:37|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null}
2025-07-14 13:02:37|INFO|getOrderList|担当者所属的店铺id:18
2025-07-14 13:02:37|SQL|[#1 - 0.21ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(167):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-14 13:02:37|SQL|[#2 - 0.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-14 13:02:37|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2025-07-14 13:02:37|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-07-14 13:02:37|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-07-14 13:02:37|SQL|[#3 - 1.11ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(212):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT res.Order_ID,max(res.ss_storage_date) as ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12, -12)) AND (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22)));|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-14 13:02:37|INFO|getOrderList|查询结果条数:127
2025-07-14 13:02:37|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY5MzU3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTI0NzI5NTd9.J73xUYrUBIQEJr7hJl8OqG9SJzXnzw3wuFwe1OuRg6c
2025-07-14 13:02:37|SQL|[#1 - 0.48ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(52):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.AdminUser_MtSsUser.GetAllSS"}}
2025-07-14 13:02:37|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY5MzU3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTI0NzI5NTd9.J73xUYrUBIQEJr7hJl8OqG9SJzXnzw3wuFwe1OuRg6c
2025-07-14 13:02:37|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1752469357,"data":{"ssid":18},"scopes":"role_access","exp":1752472957}
2025-07-14 13:02:37|SQL|[#1 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(59):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2025-07-14 13:02:37|SQL|[#2 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(63):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (category <> ?) LIMIT 0,100; -- 9|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2025-07-14 13:02:47|INFO|qrCodePng|orderId:407
2025-07-14 13:02:47|INFO|qrCodePng|aes encrypt：2ZuhApoqM3bZ1tgx1gaY0K3
2025-07-14 13:02:47|INFO|qrCodePng|base64 encode:Mlp1aEFwb3FNM2JaMXRneDFnYVkwSzMgNDA3
2025-07-14 13:02:49|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY5MzA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyODUwN30.IP2xUewUA8wLqznDrB8b5XwwaFxsXhCVsWdRzdNfHfI
2025-07-14 13:02:49|INFO|verification|params:{"orderId":"407","uuid":"00d7289d-5b93-4363-87fb-5fe4714b8f93","ciphertext":"2ZuhApoqM3bZ1tgx1gaY0K3"}
2025-07-14 13:02:49|INFO|verification|aes decrypt:407
2025-07-14 13:02:49|SQL|[#1 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '407') LIMIT 1;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-14 13:02:49|SQL|[#2 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatOrderUuid.php(21):    App\Model\Order\DatOrderUuid::getUuidByOrderId()    u433670985_test.dat_order_uuid    SELECT uuid FROM dat_order_uuid WHERE (order_id = '407') LIMIT 1;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-14 13:02:49|SQL|[#3 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatOrderUuid.php(42):    App\Model\Order\DatOrderUuid::updateOrderUuid()    u433670985_test.dat_order_uuid    UPDATE dat_order_uuid SET `ts` = 1752469369 WHERE (order_id = '407');|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-14 13:02:49|SQL|[#4 - 0.32ms - 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 = 1784);|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-14 13:02:49|SQL|[#5 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Filmthickness/DatVcFilmThickness.php(24):    App\Model\Filmthickness\DatVcFilmThickness::findFilmThicknessByCarId()    u433670985_test.dat_vc_film_thickness    SELECT * FROM dat_vc_film_thickness WHERE (car_id = 1784) LIMIT 1;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-14 13:02:49|SQL|[#6 - 0.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/OBD/DatVcObd.php(55):    App\Model\OBD\DatVcObd::getObdErrorListByCarId()    u433670985_test.dat_vc_obd    SELECT obd.error_no,oe.message FROM dat_vc_obd AS obd LEFT JOIN mt_obd_error AS oe ON obd.error_no = oe.error_no WHERE (obd.car_id = 1784);|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-14 13:02:49|SQL|[#7 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/OBD/MtObdUnitPrice.php(20):    App\Model\OBD\MtObdUnitPrice::getObdUnitPriceByKatashiki()    u433670985_test.mt_obd_unit_price    SELECT error_no,price FROM `mt_obd_unit_price` \n        where katashiki = :katashiki and price is not null\n        order by error_no; -- 'DBA-H92W'|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-14 13:02:49|SQL|[#8 - 0.23ms - 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 = 105) LIMIT 1;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-14 13:02:49|SQL|[#9 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/FormCtrl/MtVcFormCtrl.php(14):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_vc_form_ctrl    SELECT * FROM mt_vc_form_ctrl WHERE (view_id = 'car') LIMIT 0,100;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-14 13:02:49|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY5MzA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyODUwN30.IP2xUewUA8wLqznDrB8b5XwwaFxsXhCVsWdRzdNfHfI
2025-07-14 13:02:49|SQL|[#1 - 0.46ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Quote/DatVehicleInspectionQuote.php(24):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_vehicle_inspection_quote    SELECT * FROM dat_vehicle_inspection_quote WHERE (service = '2') LIMIT 0,100;|{"request":{"service":"App.Quote_VehicleInspectionQuote.vehicleInspectionQuoteInfo"}}
2025-07-14 13:02:49|SQL|[#2 - 0.68ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Quote/DatVehicleInspectionQuote.php(25):    App\Model\Quote\DatVehicleInspectionQuote::getVehicleInspectionQuoteDetailInfo()    u433670985_test.dat_vehicle_inspection_quote    SELECT q.title,qd.id,qd.vehicle_inspection_quote_id,qd.answer FROM dat_vehicle_inspection_quote AS q LEFT JOIN dat_vehicle_inspection_quote_detail AS qd ON q.id = qd.vehicle_inspection_quote_id;|{"request":{"service":"App.Quote_VehicleInspectionQuote.vehicleInspectionQuoteInfo"}}
2025-07-14 13:02:55|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY5MzA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyODUwN30.IP2xUewUA8wLqznDrB8b5XwwaFxsXhCVsWdRzdNfHfI
2025-07-14 13:02:55|INFO|downloadImg|params:{"orderId":"407","fileName":"report.jpg"}
2025-07-14 13:02:55|INFO|downloadImg|img path url:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/407_report.jpg
2025-07-14 13:03:28|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY5MzA3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjcyODUwN30.IP2xUewUA8wLqznDrB8b5XwwaFxsXhCVsWdRzdNfHfI
2025-07-14 13:03:28|INFO|downloadImg|params:{"orderId":"407","fileName":"report.jpg"}
2025-07-14 13:03:28|INFO|downloadImg|img path url:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/407_report.jpg
2025-07-14 13:04:49|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY5MzU3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTI0NzI5NTd9.J73xUYrUBIQEJr7hJl8OqG9SJzXnzw3wuFwe1OuRg6c
2025-07-14 13:04:49|INFO|getOrderDetailInfo|orderId:405
2025-07-14 13:04:49|SQL|[#1 - 0.45ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '405') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-14 13:04:49|SQL|[#2 - 0.25ms - 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 = 1782);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-14 13:04:49|SQL|[#3 - 1.61ms - 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 = 521) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-14 13:04:49|SQL|[#4 - 7.73ms - 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 = 514) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-14 13:04:49|SQL|[#5 - 0.36ms - 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"}}
2025-07-14 13:04:49|SQL|[#6 - 0.19ms - 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 = 105) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-14 13:04:49|SQL|[#7 - 0.31ms - 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"}}
2025-07-14 13:04:49|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY5MzU3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTI0NzI5NTd9.J73xUYrUBIQEJr7hJl8OqG9SJzXnzw3wuFwe1OuRg6c
2025-07-14 13:04:49|SQL|[#1 - 0.21ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.Discount_Discount.list"}}
2025-07-14 13:04:49|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY5MzU3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTI0NzI5NTd9.J73xUYrUBIQEJr7hJl8OqG9SJzXnzw3wuFwe1OuRg6c
2025-07-14 13:04:49|INFO|getCarPhotos|params:{"orderId":"405"}
2025-07-14 13:04:49|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY5MzU3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTI0NzI5NTd9.J73xUYrUBIQEJr7hJl8OqG9SJzXnzw3wuFwe1OuRg6c
2025-07-14 13:04:49|INFO|getOrderPdfs|params:{"orderId":"405"}
2025-07-14 13:04:50|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyNDY5MzU3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTI0NzI5NTd9.J73xUYrUBIQEJr7hJl8OqG9SJzXnzw3wuFwe1OuRg6c
2025-07-14 13:04:50|SQL|[#1 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '10');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}