2025-08-25 17:01:09|INFO|JwtAuthorizationFilter check|authorization:
2025-08-25 17:01:09|INFO|JwtAuthorizationFilter check|authorization:
2025-08-25 17:01:11|INFO|mt_ss login|params:{"loginId":"admin","pw":"urutoraman1"}
2025-08-25 17:01:11|SQL|[#1 - 0.41ms - 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-08-25 17:01:11|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-08-25 17:01:11|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1756112471,"data":{"ssid":18}}
2025-08-25 17:01:11|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MTEyNDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYxMTYwNzF9.VMQQCbVrt8MJkPW6NU33ZKXdN3VUrH500_9xNOkMvVc
2025-08-25 17:01:11|INFO|orderList|shopId:
2025-08-25 17:01:11|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1756112471,"data":{"ssid":18},"scopes":"role_access","exp":1756116071}
2025-08-25 17:01:11|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null}
2025-08-25 17:01:11|INFO|getOrderList|担当者所属的店铺id:18
2025-08-25 17:01:11|SQL|[#1 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(169):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-08-25 17:01:11|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-08-25 17:01:11|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-08-25 17:01:11|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-08-25 17:01:11|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-08-25 17:01:11|SQL|[#3 - 3.35ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(214):    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-08-25 17:01:11|INFO|getOrderList|查询结果条数:131
2025-08-25 17:01:11|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MTEyNDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYxMTYwNzF9.VMQQCbVrt8MJkPW6NU33ZKXdN3VUrH500_9xNOkMvVc
2025-08-25 17:01:11|SQL|[#1 - 0.2ms - 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-08-25 17:01:11|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MTEyNDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYxMTYwNzF9.VMQQCbVrt8MJkPW6NU33ZKXdN3VUrH500_9xNOkMvVc
2025-08-25 17:01:11|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1756112471,"data":{"ssid":18},"scopes":"role_access","exp":1756116071}
2025-08-25 17:01:11|SQL|[#1 - 0.24ms - 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-08-25 17:01:11|SQL|[#2 - 0.18ms - 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-08-25 17:01:26|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MTEyNDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYxMTYwNzF9.VMQQCbVrt8MJkPW6NU33ZKXdN3VUrH500_9xNOkMvVc
2025-08-25 17:01:26|SQL|[#1 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(81):    App\Model\AdminUser\MtSs::queryList()    u433670985_test.mt_ss    SELECT ID,ss_name,category,section_id FROM mt_ss WHERE (Delete_date is null);|{"request":{"service":"App.AdminUser_MtSsUser.getBindSS"}}
2025-08-25 17:01:26|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MTEyNDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYxMTYwNzF9.VMQQCbVrt8MJkPW6NU33ZKXdN3VUrH500_9xNOkMvVc
2025-08-25 17:01:26|INFO|getLineUserList|params:{} ssid=18currentPage=1pageSize=10querySsid=freeword=
2025-08-25 17:01:26|SQL|[#1 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/LineUser/LineUser.php(72):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '18');|{"request":{"service":"App.LineUser_LineUser.getLineUserList"}}
2025-08-25 17:01:26|SQL|[#2 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineUser.php(58):    App\Model\Line\DatLineUser::listLineUser()    u433670985_test.dat_line_user    SELECT COUNT(userId) FROM dat_line_user;|{"request":{"service":"App.LineUser_LineUser.getLineUserList"}}
2025-08-25 17:01:26|SQL|[#3 - 0.13ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineUser.php(58):    App\Model\Line\DatLineUser::listLineUser()    u433670985_test.dat_line_user    SELECT * FROM dat_line_user LIMIT 0,10;|{"request":{"service":"App.LineUser_LineUser.getLineUserList"}}
2025-08-25 17:01:42|SQL|[#1 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(45):    App\Model\Line\DatLineMsg::getLastSendTime()    u433670985_test.dat_line_msg    SELECT send_time FROM dat_line_msg WHERE (send_time is not null) ORDER BY send_time DESC LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}}
2025-08-25 17:01:42|INFO|sendLine|lastSendTime:{"send_time":"2025-03-27 16:49:27"}
2025-08-25 17:01:42|SQL|[#2 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(55):    App\Model\Line\DatLineMsg::getToSendMessage()    u433670985_test.dat_line_msg    SELECT * FROM dat_line_msg WHERE (status = 0) ORDER BY create_time LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}}
2025-08-25 17:02:22|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MTEyNDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYxMTYwNzF9.VMQQCbVrt8MJkPW6NU33ZKXdN3VUrH500_9xNOkMvVc
2025-08-25 17:02:22|SQL|[#1 - 0.35ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(81):    App\Model\AdminUser\MtSs::queryList()    u433670985_test.mt_ss    SELECT ID,ss_name,category,section_id FROM mt_ss WHERE (Delete_date is null);|{"request":{"service":"App.AdminUser_MtSsUser.getBindSS"}}
2025-08-25 17:02:22|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MTEyNDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYxMTYwNzF9.VMQQCbVrt8MJkPW6NU33ZKXdN3VUrH500_9xNOkMvVc
2025-08-25 17:02:22|INFO|getLineUserList|params:{} ssid=18currentPage=1pageSize=10querySsid=freeword=
2025-08-25 17:02:22|SQL|[#1 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/LineUser/LineUser.php(72):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '18');|{"request":{"service":"App.LineUser_LineUser.getLineUserList"}}
2025-08-25 17:02:22|SQL|[#2 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineUser.php(58):    App\Model\Line\DatLineUser::listLineUser()    u433670985_test.dat_line_user    SELECT COUNT(userId) FROM dat_line_user;|{"request":{"service":"App.LineUser_LineUser.getLineUserList"}}
2025-08-25 17:02:22|SQL|[#3 - 0.18ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineUser.php(58):    App\Model\Line\DatLineUser::listLineUser()    u433670985_test.dat_line_user    SELECT * FROM dat_line_user LIMIT 0,10;|{"request":{"service":"App.LineUser_LineUser.getLineUserList"}}
2025-08-25 17:11:19|SQL|[#1 - 0.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(45):    App\Model\Line\DatLineMsg::getLastSendTime()    u433670985_test.dat_line_msg    SELECT send_time FROM dat_line_msg WHERE (send_time is not null) ORDER BY send_time DESC LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}}
2025-08-25 17:11:19|INFO|sendLine|lastSendTime:{"send_time":"2025-03-27 16:49:27"}
2025-08-25 17:11:19|SQL|[#2 - 0.21ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(55):    App\Model\Line\DatLineMsg::getToSendMessage()    u433670985_test.dat_line_msg    SELECT * FROM dat_line_msg WHERE (status = 0) ORDER BY create_time LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}}
2025-08-25 17:11:19|INFO|sendLine|toUserId:Ud9ffe82daa8e16406120af7c6683ee08, msg: SS出庫準備が整いました。（MC、ｂＢ、富山502ぬ1845）
2025-08-25 17:11:19|INFO|sendLine|data:{"to":"Ud9ffe82daa8e16406120af7c6683ee08","messages":[{"type":"text","text":"SS\u51fa\u5eab\u6e96\u5099\u304c\u6574\u3044\u307e\u3057\u305f\u3002\uff08MC\u3001bB\u3001\u5bcc\u5c71502\u306c1845\uff09"}]}
2025-08-25 17:11:19|INFO|sendLine|response:"{\"message\":\"Failed to send messages\"}"
2025-08-25 17:11:19|INFO|sendLine|response:"{\"message\":\"Failed to send messages\"}"
2025-08-25 17:11:19|SQL|[#3 - 0.42ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Task/Index.php(167):    App\Domain\Line\DatLineMsg::update()    u433670985_test.dat_line_msg    UPDATE dat_line_msg SET `id` = 364, `create_time` = '2025-07-11 02:21:02', `status` = 1, `send_time` = '2025-08-25 17:11:19', `message` = 'SS出庫準備が整いました。（MC、ｂＢ、富山502ぬ1845）', `to_openid` = 'Ud9ffe82daa8e16406120af7c6683ee08', `Order_ID` = 404 WHERE (id = 364);|{"request":{"service":"App.Task_Index.sendLine"}}
2025-08-25 17:11:39|SQL|[#1 - 0.35ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(45):    App\Model\Line\DatLineMsg::getLastSendTime()    u433670985_test.dat_line_msg    SELECT send_time FROM dat_line_msg WHERE (send_time is not null) ORDER BY send_time DESC LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}}
2025-08-25 17:11:39|INFO|sendLine|lastSendTime:{"send_time":"2025-08-25 17:11:19"}
2025-08-25 17:11:39|SQL|[#2 - 0.19ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(55):    App\Model\Line\DatLineMsg::getToSendMessage()    u433670985_test.dat_line_msg    SELECT * FROM dat_line_msg WHERE (status = 0) ORDER BY create_time LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}}