2025-07-08 09:44:11|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8 2025-07-08 09:44:11|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8 2025-07-08 09:44:11|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8 2025-07-08 09:44:14|INFO|mt_ss login|params:{"loginId":"admin","pw":"urutoraman1"} 2025-07-08 09:44:14|SQL|[#1 - 0.51ms - 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-08 09:44:14|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-08 09:44:14|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1751939054,"data":{"ssid":18}} 2025-07-08 09:44:14|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxOTM5MDU0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE5NDI2NTR9.yiN-h9cNGKZgPPe3uF8YOUwDQffCDePGshS9h9HcOVs 2025-07-08 09:44:14|INFO|orderList|shopId: 2025-07-08 09:44:14|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1751939054,"data":{"ssid":18},"scopes":"role_access","exp":1751942654} 2025-07-08 09:44:14|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null} 2025-07-08 09:44:14|INFO|getOrderList|担当者所属的店铺id:18 2025-07-08 09:44:14|SQL|[#1 - 0.26ms - 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-08 09:44:14|SQL|[#2 - 0.17ms - 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-08 09:44:14|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-08 09:44:14|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-08 09:44:14|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-08 09:44:14|SQL|[#3 - 3.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 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-08 09:44:14|INFO|getOrderList|查询结果条数:128 2025-07-08 09:44:33|INFO|qrCodePng|orderId:398 2025-07-08 09:44:33|INFO|qrCodePng|aes encrypt：WKJWMBh9mNqST14B3kx2JM2 2025-07-08 09:44:33|INFO|qrCodePng|base64 encode:V0tKV01CaDltTnFTVDE0QjNreDJKTTIgMzk4 2025-07-08 09:44:39|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjgxNTAxLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MTk0MDcwMX0.lBsZHVfEzT0vGi8KlctmnlM9Cys0Rl1D7876WbLEGrw 2025-07-08 09:44:39|SQL|[#1 - 0.83ms - 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-08 09:44:40|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjgxNTAxLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MTk0MDcwMX0.lBsZHVfEzT0vGi8KlctmnlM9Cys0Rl1D7876WbLEGrw 2025-07-08 09:44:40|INFO|verification|params:{"orderId":"398","uuid":"4e5da4e4-1bc6-4861-87cd-16ab625df8f6","ciphertext":"WKJWMBh9mNqST14B3kx2JM2"} 2025-07-08 09:44:40|INFO|verification|aes decrypt:398 2025-07-08 09:44:40|SQL|[#1 - 0.42ms - 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 = '398') LIMIT 1;|{"request":{"service":"App.Order_Order.Verification"}} 2025-07-08 09:44:40|SQL|[#2 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106): App\Model\Order\DatSyakenOrderList::updateOrderInfo() u433670985_test.dat_syaken_order_list UPDATE dat_syaken_order_list SET `check_state` = 1 WHERE (order_id = '398');|{"request":{"service":"App.Order_Order.Verification"}} 2025-07-08 09:44:40|SQL|[#3 - 0.62ms - 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 ('398', '4e5da4e4-1bc6-4861-87cd-16ab625df8f6', '2025-07-08 09:44:40', 1751939080);|{"request":{"service":"App.Order_Order.Verification"}} 2025-07-08 09:44:40|SQL|[#4 - 0.38ms - 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 = 1776);|{"request":{"service":"App.Order_Order.Verification"}} 2025-07-08 09:44:40|SQL|[#5 - 0.43ms - 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 = 1776) LIMIT 1;|{"request":{"service":"App.Order_Order.Verification"}} 2025-07-08 09:44:40|SQL|[#6 - 0.38ms - 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 = 1776);|{"request":{"service":"App.Order_Order.Verification"}} 2025-07-08 09:44:40|SQL|[#7 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(24): App\Model\Customer\DatCustomer::findCustomerByCustomerId() u433670985_test.dat_customer SELECT * FROM dat_customer WHERE (base_customerID = 23) LIMIT 1;|{"request":{"service":"App.Order_Order.Verification"}} 2025-07-08 09:44:40|SQL|[#8 - 0.47ms - 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-08 09:44:40|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjgxNTAxLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MTk0MDcwMX0.lBsZHVfEzT0vGi8KlctmnlM9Cys0Rl1D7876WbLEGrw 2025-07-08 09:44:40|SQL|[#1 - 0.45ms - 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 = '4') LIMIT 0,100;|{"request":{"service":"App.Quote_VehicleInspectionQuote.vehicleInspectionQuoteInfo"}} 2025-07-08 09:44:40|SQL|[#2 - 0.81ms - 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-08 09:44:46|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjgxNTAxLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MTk0MDcwMX0.lBsZHVfEzT0vGi8KlctmnlM9Cys0Rl1D7876WbLEGrw 2025-07-08 09:44:46|INFO|downloadImg|params:{"orderId":"398","fileName":"report.jpg"} 2025-07-08 09:44:46|INFO|downloadImg|img path url:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/398_report.jpg