2026-03-14 16:55:40|INFO|downloadSrc|file:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../appview/dist.zip
2026-03-14 16:55:40|INFO|downloadSrc|size:2364565
2026-03-14 16:55:53|INFO|mt_ss login|params:{"loginId":"mecha","pw":"6630_Mecha"}
2026-03-14 16:55:53|SQL|[#1 - 2.05ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Model/DataModel.php(165):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (log_in = 'mecha') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.Login"}}
2026-03-14 16:55:53|INFO|mt_ss login|user:{"ID":22,"category":2,"ss_name":"MC","display_name":null,"en_name":"mecha","section":null,"section_id":4,"log_in":"mecha","pw":"6630_Mecha","manager_flag":0,"comp_1":null,"comp_2":null,"comp_3":null,"comp_4":null,"comp_5":null,"test_marketing_flag":null,"rent_a_car":null,"towing":null,"Delete_date":null,"line_openid":"4aHxP8CIZAnRDcfexnWoX90e7ij0gNefQCBYGemP2jZ","zip":null,"address":null,"telno":null,"faxno":null}
2026-03-14 16:55:53|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1773478553,"data":{"ssid":22}}
2026-03-14 16:55:53|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzczNDc4NTUzLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NzM0ODIxNTN9.5UEVCSd4iOMvOrhKXSGuKdlEm-jJKA9UAgDUhIR2a-I
2026-03-14 16:55:53|INFO|orderList|shopId:
2026-03-14 16:55:53|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1773478553,"data":{"ssid":22},"scopes":"role_access","exp":1773482153}
2026-03-14 16:55:53|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":22,"$freeword":null,"$orderId":null}
2026-03-14 16:55:53|INFO|getOrderList|担当者所属的店铺id:22
2026-03-14 16:55:53|SQL|[#1 - 0.35ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(170):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 22);|{"request":{"service":"App.Order_Order.OrderList"}}
2026-03-14 16:55:53|SQL|[#2 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2026-03-14 16:55:53|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2026-03-14 16:55:53|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2026-03-14 16:55:53|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2026-03-14 16:55:54|SQL|[#3 - 4.79ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(215):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT res.Order_ID,max(res.ss_storage_date) as ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12, -12)) AND (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22)));|{"request":{"service":"App.Order_Order.OrderList"}}
2026-03-14 16:55:54|INFO|getOrderList|查询结果条数:144
2026-03-14 16:55:54|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzczNDc4NTUzLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NzM0ODIxNTN9.5UEVCSd4iOMvOrhKXSGuKdlEm-jJKA9UAgDUhIR2a-I
2026-03-14 16:55:54|SQL|[#1 - 2.21ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(52):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.AdminUser_MtSsUser.GetAllSS"}}
2026-03-14 16:55:54|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzczNDc4NTUzLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NzM0ODIxNTN9.5UEVCSd4iOMvOrhKXSGuKdlEm-jJKA9UAgDUhIR2a-I
2026-03-14 16:55:54|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1773478553,"data":{"ssid":22},"scopes":"role_access","exp":1773482153}
2026-03-14 16:55:54|SQL|[#1 - 9.7ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(59):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 22);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2026-03-14 16:55:55|INFO|qrCodePng|orderId:220
2026-03-14 16:55:55|INFO|qrCodePng|aes encrypt：JUmtBIlE4x3GHw21AZsOMx12
2026-03-14 16:55:55|INFO|qrCodePng|base64 encode:SlVtdEJJbEU0eDNHSHcyMUFac09NeDEyIDIyMA==
2026-03-14 16:56:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzczNDc4NTUzLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NzM0ODIxNTN9.5UEVCSd4iOMvOrhKXSGuKdlEm-jJKA9UAgDUhIR2a-I
2026-03-14 16:56:08|INFO|doCopyOrder|jwt:{"iss":"http:\/\/www.shimars.net","iat":1773478553,"data":{"ssid":22},"scopes":"role_access","exp":1773482153}
2026-03-14 16:56:08|SQL|[#1 - 0.72ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(112):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '445') LIMIT 1;|{"request":{"service":"App.Order_Order.doCopyOrder"}}
2026-03-14 16:56:08|SQL|[#2 - 1.96ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(148):    App\Model\Cars\DatCars::findCarsByCarId()    u433670985_test.dat_cars    SELECT * FROM dat_cars WHERE (CarID = 1804) LIMIT 1;|{"request":{"service":"App.Order_Order.doCopyOrder"}}
2026-03-14 16:56:08|SQL|[#3 - 0.45ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(150):    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, 23, NULL, '2015(H27)', '2015-07-01', NULL, 'クラウン', NULL, NULL, 'DBA-K13', 'HR12', 'K13-381017', 7, '2024-07-29', 13220, NULL, NULL, NULL, '箱型', NULL, NULL, 950, NULL, 18, 16470, NULL, NULL, NULL, NULL, 1, '富山531ね729', NULL, NULL, NULL, NULL, '有限会社SHIMAカーライフコネクテッド', '富山県富山市上赤江町２丁目２−２２', NULL, NULL, '有限会社SHIMAカーライフコネクテッド', '富山県富山市上赤江町２丁目２−２２', NULL, NULL, NULL, '2024-04-22', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-07-05', 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, '有限会社SHIMAカーライフコネクテッド', '富山県富山市上赤江町２丁目２−２２', '有限会社SHIMAカーライフコネクテッド', '富山県富山市上赤江町２丁目２−２２', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-04-21', '2025-05-21 04:16:20', NULL, NULL, NULL, '2WD', 2);|{"request":{"service":"App.Order_Order.doCopyOrder"}}
2026-03-14 16:56:08|SQL|[#4 - 0.47ms - 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`, `ss_return_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`, `delivered_date`, `syaken_send_date`, `collection_flag`, `print_flag`) VALUES (NULL, 23, 1806, 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, 4, NULL, 82, NULL, NULL, '/cars/279_1719559618377_car.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);|{"request":{"service":"App.Order_Order.doCopyOrder"}}
2026-03-14 16:56:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzczNDc4NTUzLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NzM0ODIxNTN9.5UEVCSd4iOMvOrhKXSGuKdlEm-jJKA9UAgDUhIR2a-I
2026-03-14 16:56:08|INFO|orderList|shopId:
2026-03-14 16:56:08|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1773478553,"data":{"ssid":22},"scopes":"role_access","exp":1773482153}
2026-03-14 16:56:08|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":22,"$freeword":null,"$orderId":null}
2026-03-14 16:56:08|INFO|getOrderList|担当者所属的店铺id:22
2026-03-14 16:56:08|SQL|[#1 - 1.15ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(170):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 22);|{"request":{"service":"App.Order_Order.OrderList"}}
2026-03-14 16:56:08|SQL|[#2 - 5.11ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2026-03-14 16:56:08|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2026-03-14 16:56:08|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2026-03-14 16:56:08|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2026-03-14 16:56:08|SQL|[#3 - 1.61ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(215):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT res.Order_ID,max(res.ss_storage_date) as ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12, -12)) AND (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22)));|{"request":{"service":"App.Order_Order.OrderList"}}
2026-03-14 16:56:08|INFO|getOrderList|查询结果条数:145
2026-03-14 16:56:10|INFO|qrCodePng|orderId:448
2026-03-14 16:56:10|INFO|qrCodePng|aes encrypt：1c3IqDkZj5h2lnianp6bg1
2026-03-14 16:56:10|INFO|qrCodePng|base64 encode:MWMzSXFEa1pqNWgybG5pYW5wNmJnMSA0NDg=