15:10:48.469 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
15:10:48.469 | trace | yii\base\Module::getModule | Loading module: debug |
15:10:48.469 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
15:10:48.470 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
15:10:48.470 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
15:10:48.470 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:10:48.470 | trace | yii\base\Module::getModule | Loading module: gii |
15:10:48.470 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
15:10:48.470 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
15:10:48.470 | trace | yii\web\Application::handleRequest | Route requested: 'v2/reimbursement/save-new' |
15:10:48.470 | trace | yii\base\Module::getModule | Loading module: v2 |
15:10:48.471 | info | yii\web\Session::open | Session started |
15:10:48.471 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
15:10:48.473 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u' |
15:10:48.476 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:10:48.476 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
15:10:48.476 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:10:48.476 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
15:10:48.476 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
15:10:48.478 | trace | yii\base\Controller::runAction | Route to run: v2/reimbursement/save-new |
15:10:48.478 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:10:48.479 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
15:10:48.479 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\ReimbursementController::actionSaveNew() |
15:10:48.479 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:10:48.479 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
15:10:48.479 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'attachmentFiles' in 'app\models\Reimbursements'. |
15:10:48.480 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000) |
15:10:48.480 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815') |
15:10:48.481 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000) |
15:10:48.481 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815') |
15:10:48.481 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_reimbursements" ("amount", "client_id", "description", "implement_record_id", "occurrence_at", "pre_sales_id", "project_id", "work_log_id", "created_by", "status") VALUES ('110', 2815, '', NULL, '2025-06-25 15:00', NULL, NULL, NULL, 1000, 1) RETURNING "id" |
15:10:48.485 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:10:48.485 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
15:10:48.485 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Reimbursements', 7439, 'a:18:{s:2:"id";i:7439;s:6:"status";i:1;s:6:"amount";s:3:"110";s:13:"occurrence_at";s:19:"2025-06-25 15:00:00";s:18:"settle_accounts_at";N;s:18:"settle_accounts_by";N;s:11:"description";s:0:"";s:10:"created_by";i:1000;s:10:"created_at";N;s:10:"updated_at";N;s:18:"refuse_description";N;s:9:"client_id";s:4:"2815";s:10:"project_id";s:0:"";s:16:"next_verify_user";N;s:13:"is_resubmited";N;s:11:"work_log_id";s:0:"";s:12:"pre_sales_id";s:0:"";s:19:"implement_record_id";s:0:"";}', '', 1000, '223.104.41.148') |
15:10:48.487 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=19) AND ("object_id"=7439) |
15:10:48.488 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:10:48.488 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
15:10:48.488 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (19, 7439, 24776) |
15:10:48.489 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=7439) AND ("term_id"=15) |
15:10:48.490 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:10:48.490 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
15:10:48.490 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='185') |
15:10:48.490 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=15) |
15:10:48.491 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (15, 185, 7439) RETURNING "id" |
15:10:48.492 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\TermTaxonomyRelationships', 118037, 'a:7:{s:2:"id";i:118037;s:9:"object_id";i:7439;s:11:"taxonomy_id";s:3:"185";s:7:"term_id";i:15;s:5:"value";N;s:11:"object_type";N;s:9:"extra_int";N;}', '', 1000, '223.104.41.148') |
15:10:48.493 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=7439) AND ("term_id"=18) |
15:10:48.493 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='369') |
15:10:48.493 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=18) |
15:10:48.493 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (18, 369, 7439) RETURNING "id" |
15:10:48.494 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\TermTaxonomyRelationships', 118038, 'a:7:{s:2:"id";i:118038;s:9:"object_id";i:7439;s:11:"taxonomy_id";s:3:"369";s:7:"term_id";i:18;s:5:"value";N;s:11:"object_type";N;s:9:"extra_int";N;}', '', 1000, '223.104.41.148') |
15:10:48.495 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE "reimbursement_id"=7439 |
15:10:48.496 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:10:48.497 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
15:10:48.497 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_reimbursement_verify_rels" ("reimbursement_id", "user_id", "status") VALUES (7439, 1000, 0) |
15:10:48.498 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" WHERE "reimbursement_id"=7439 |
15:10:48.498 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:10:48.498 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
15:10:48.498 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" ("reimbursement_id", "user_id") VALUES (7439, 5252) |
15:10:48.499 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE "reimbursement_id"=7439 |
15:10:48.500 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:10:48.500 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
15:10:48.500 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_reimbursement_settle_rels" ("reimbursement_id", "user_id") VALUES (7439, 1000) |
15:10:48.501 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status"=0) AND ("reimbursement_id"=7439) ORDER BY "id" |
15:10:48.502 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000) |
15:10:48.503 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815') |
15:10:48.503 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_reimbursements" SET "next_verify_user"=1000 WHERE "id"=7439 |
15:10:48.504 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Reimbursements', 7439, 'a:1:{s:13:"occurrence_at";s:19:"2025-06-25 15:00:00";}', '', 1000, '223.104.41.148') |
15:10:48.505 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
15:10:48.505 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"=7439 |
15:10:48.506 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status"=0) AND ("reimbursement_id"=7439) ORDER BY "id" |
15:10:48.507 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
15:10:48.507 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:10:48.507 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
15:10:48.508 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 7439, 20, 1000, '2025-06-25 15:10:48', '{"id":7439,"status":1,"amount":"110","occurrence_at":"2025-06-25 15:00:00","settle_accounts_at":null,"settle_accounts_by":null,"description":"","created_by":1000,"created_at":"2025-06-25 15:10:48","updated_at":"2025-06-25 15:10:48","refuse_description":null,"client_id":2815,"project_id":null,"next_verify_user":1000,"is_resubmited":false,"work_log_id":null,"pre_sales_id":null,"implement_record_id":null}', '{"id":7439,"status":1,"amount":"110","occurrence_at":"2025-06-25 15:00:00","settle_accounts_at":null,"settle_accounts_by":null,"description":"","created_by":1000,"created_at":"2025-06-25 15:10:48","updated_at":"2025-06-25 15:10:48","refuse_description":null,"client_id":2815,"project_id":null,"next_verify_user":1000,"is_resubmited":false,"work_log_id":null,"pre_sales_id":null,"implement_record_id":null}', '{"d1":"\u66f9\u6c38\u751f","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u62a5\u9500","d4":[]}') RETURNING "id" |
15:10:48.509 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 509562, 'a:13:{s:2:"id";i:509562;s:9:"object_id";i:7439;s:11:"object_type";i:20;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:405:"{"id":7439,"status":1,"amount":"110","occurrence_at":"2025-06-25 15:00:00","settle_accounts_at":null,"settle_accounts_by":null,"description":"","created_by":1000,"created_at":"2025-06-25 15:10:48","updated_at":"2025-06-25 15:10:48","refuse_description":null,"client_id":2815,"project_id":null,"next_verify_user":1000,"is_resubmited":false,"work_log_id":null,"pre_sales_id":null,"implement_record_id":null}";s:9:"new_value";s:405:"{"id":7439,"status":1,"amount":"110","occurrence_at":"2025-06-25 15:00:00","settle_accounts_at":null,"settle_accounts_by":null,"description":"","created_by":1000,"created_at":"2025-06-25 15:10:48","updated_at":"2025-06-25 15:10:48","refuse_description":null,"client_id":2815,"project_id":null,"next_verify_user":1000,"is_resubmited":false,"work_log_id":null,"pre_sales_id":null,"implement_record_id":null}";s:11:"description";s:93:"{"d1":"\u66f9\u6c38\u751f","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u62a5\u9500","d4":[]}";s:10:"created_by";i:1000;s:10:"created_at";s:19:"2025-06-25 15:10:48";s:9:"is_delete";N;}', '', 1000, '223.104.41.148') |
15:10:48.510 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:10:48.510 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
15:10:48.510 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815 |
15:10:48.511 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=2815 |
15:10:48.512 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2815) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
15:10:48.521 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:10:48.521 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
15:10:48.521 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2815, 1004, 'now()', NULL) RETURNING "id" |
15:10:48.523 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 164992, 'a:5:{s:2:"id";i:164992;s:9:"client_id";i:2815;s:9:"sales_rep";i:1004;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1000, '223.104.41.148') |
15:10:48.524 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 2815, 'a:0:{}', '', 1000, '223.104.41.148') |
15:10:48.525 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=7439 |
15:10:48.525 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=15) AND ("id" IN (185, 369)) |
15:10:48.525 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:10:48.525 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
15:10:48.526 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
15:10:48.526 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 2815, 10, 7439, 20, 1000, '[7439]', '[7439]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u62a5\u9500","d4":["\u62db\u5f85\u8d39"]}') RETURNING "id" |
15:10:48.527 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 509563, 'a:13:{s:2:"id";i:509563;s:9:"object_id";i:2815;s:11:"object_type";i:10;s:9:"target_id";i:7439;s:18:"target_object_type";i:20;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[7439]";s:9:"new_value";s:6:"[7439]";s:11:"description";s:113:"{"d1":"\u66f9\u6c38\u751f","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u62a5\u9500","d4":["\u62db\u5f85\u8d39"]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '223.104.41.148') |
15:10:48.528 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:10:48.528 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
15:10:48.528 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 2, 1141, 'v2/reimbursement/save-new', '{"Reimbursements":{"amount":"110","attachmentFiles":["24776"],"client_id":"2815","description":"","form_costType":"369","form_reimbursementCarbonCopyRels":["5252"],"form_reimbursementSettleRels":["1000"],"form_reimbursementVerifyRels":["1000"],"form_type":"185","implement_record_id":"","occurrence_at":"2025-06-25 15:00","pre_sales_id":"","project_id":"","work_log_id":""},"access_token":"rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u","device_type":"2","posttime":"1750835456","token":"4bbc64a435112eb22860c2591b8d0ac6","version_code":"1141"}', '{"code":200,"data":{"id":7439},"status":1,"msg":[{"name":"success","success":"\u65b0\u62a5\u9500\u5df2\u521b\u5efa\u6210\u529f","error":""}]}', FALSE, '2025-06-25 15:10:48') RETURNING "id" |