12:25:50.139 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
12:25:50.139 | trace | yii\base\Module::getModule | Loading module: debug |
12:25:50.139 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
12:25:50.139 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
12:25:50.139 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
12:25:50.139 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
12:25:50.139 | trace | yii\base\Module::getModule | Loading module: gii |
12:25:50.139 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
12:25:50.140 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
12:25:50.140 | trace | yii\web\Application::handleRequest | Route requested: 'vue/erp-collect-ticket/save-new' |
12:25:50.140 | trace | yii\base\Module::getModule | Loading module: vue |
12:25:50.140 | info | yii\web\Session::open | Session started |
12:25:50.140 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5252 |
12:25:50.140 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
12:25:50.145 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
12:25:50.145 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
12:25:50.145 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
12:25:50.146 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
12:25:50.146 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252 |
12:25:50.148 | trace | yii\base\Controller::runAction | Route to run: vue/erp-collect-ticket/save-new |
12:25:50.148 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
12:25:50.149 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
12:25:50.149 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: createErpCollectTicket |
12:25:50.149 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
12:25:50.149 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Treasurer |
12:25:50.149 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: updatePurchaseContract |
12:25:50.149 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Accountant |
12:25:50.149 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\ErpCollectTicketController::actionSaveNew() |
12:25:50.150 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'id' in 'app\models\ErpCollectTickets'. |
12:25:50.150 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'auto_id' in 'app\models\ErpCollectTickets'. |
12:25:50.150 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'auto_name' in 'app\models\ErpCollectTickets'. |
12:25:50.150 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'auto_type' in 'app\models\ErpCollectTickets'. |
12:25:50.150 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
12:25:50.150 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
12:25:50.150 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'handler_name' in 'app\models\ErpCollectTickets'. |
12:25:50.150 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'client_name' in 'app\models\ErpCollectTickets'. |
12:25:50.150 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'supplier_name' in 'app\models\ErpCollectTickets'. |
12:25:50.150 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'files' in 'app\models\ErpCollectTickets'. |
12:25:50.150 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'erpCollectTicketVerifyRels' in 'app\models\ErpCollectTickets'. |
12:25:50.150 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'erpCollectTicketBankIns' in 'app\models\ErpCollectTickets'. |
12:25:50.150 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'erpCollectTicketPayments' in 'app\models\ErpCollectTickets'. |
12:25:50.150 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'erpCollectTicketSettles' in 'app\models\ErpCollectTickets'. |
12:25:50.150 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
12:25:50.150 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
12:25:50.151 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE ("created_at" >= '2025-08-04 00:00:00') AND ("created_at" <= '2025-08-04 23:59:59') AND ("serial_no" ILIKE '%FK-20250804-%') AND (LENGTH(serial_no) = 17) ORDER BY "serial_no" DESC |
12:25:50.153 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE "serial_no"='FK-20250804-00002') |
12:25:50.154 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1005') |
12:25:50.154 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3387') |
12:25:50.155 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252) |
12:25:50.156 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_collect_tickets" ("handler", "wrote_date", "serial_no", "abstract", "description", "client_id", "supplier_id", "verify_type", "created_by", "created_at", "status", "is_resubmitted", "amount", "settle_amount", "is_old") VALUES (1005, '2025-08-04', 'FK-20250804-00002', '方式是对方', '', 3387, NULL, 1, 5252, 'now()', 1, FALSE, '0', '0', TRUE) RETURNING "id" |
12:25:50.161 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
12:25:50.161 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
12:25:50.161 | 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\ErpCollectTickets', 1988, 'a:29:{s:2:"id";i:1988;s:9:"serial_no";s:17:"FK-20250804-00002";s:10:"wrote_date";s:10:"2025-08-04";s:9:"from_date";N;s:7:"handler";s:4:"1005";s:7:"user_id";N;s:9:"client_id";s:4:"3387";s:17:"sales_contract_id";N;s:11:"supplier_id";s:0:"";s:20:"purchase_contract_id";N;s:6:"status";i:1;s:8:"abstract";s:15:"方式是对方";s:11:"description";s:0:"";s:11:"verify_type";s:1:"1";s:16:"next_verify_user";N;s:21:"next_stop_verify_user";N;s:9:"verify_at";N;s:7:"stop_at";N;s:18:"refuse_description";N;s:14:"is_resubmitted";b:0;s:6:"amount";i:0;s:13:"settle_amount";i:0;s:10:"created_by";i:5252;s:16:"stop_description";N;s:9:"is_settle";N;s:6:"is_old";b:1;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:10:"updated_at";N;s:11:"paid_amount";N;}', '', 5252, '124.64.23.198') |
12:25:50.162 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20022) AND ("object_id"=1988) |
12:25:50.164 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE "erp_collect_ticket_id"=1988 |
12:25:50.164 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
12:25:50.164 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
12:25:50.164 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_collect_ticket_settles" ("erp_collect_ticket_id", "sales_contract_id", "purchase_contract_id", "erp_other_income_ticket_id", "erp_other_collect_ticket_id", "amount") VALUES (1988, 4071, NULL, NULL, NULL, '1') RETURNING "id" |
12:25:50.172 | 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\ErpCollectTicketSettles', 1991, 'a:8:{s:2:"id";i:1991;s:21:"erp_collect_ticket_id";i:1988;s:17:"sales_contract_id";s:4:"4071";s:20:"purchase_contract_id";s:0:"";s:26:"erp_other_income_ticket_id";s:0:"";s:27:"erp_other_collect_ticket_id";s:0:"";s:6:"amount";s:1:"1";s:11:"description";N;}', '', 5252, '124.64.23.198') |
12:25:50.174 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" WHERE ("status"=0) AND ("erp_collect_ticket_id"=1988) ORDER BY "id" |
12:25:50.175 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_collect_tickets" SET "amount"='1', "next_verify_user"=NULL WHERE "id"=1988 |
12:25:50.176 | 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\ErpCollectTickets', 1988, 'a:0:{}', '', 5252, '124.64.23.198') |
12:25:50.177 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE "id"=1988 |
12:25:50.178 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" WHERE "erp_collect_ticket_id"=1988 ORDER BY "id" |
12:25:50.180 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE (purchase_contract_id is not null) AND ("erp_collect_ticket_id"=1988) ORDER BY "id" |
12:25:50.180 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE (sales_contract_id is not null) AND ("erp_collect_ticket_id"=1988) ORDER BY "id" |
12:25:50.181 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4071 |
12:25:50.182 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
12:25:50.182 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
12:25:50.182 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4071) AND ("t"."status" IN (2, 5, 1)) |
12:25:50.184 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4071) AND ("t"."status" IN (2, 5, 1)) |
12:25:50.185 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."sales_contract_id"=4071) AND ("t"."status" IN (2, 5, 1)) |
12:25:50.186 | info | yii\db\Command::query | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4071) AND ("t"."status"=1)) |
12:25:50.187 | info | yii\db\Command::query | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4071) AND ("t"."status"=1)) |
12:25:50.188 | info | yii\db\Command::query | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."sales_contract_id"=4071) AND ("t"."status"=1)) |
12:25:50.189 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='114632', "erp_collect_ticket_is_verify"=TRUE WHERE "id"=4071 |
12:25:50.191 | 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\SalesContracts', 4071, 'a:2:{s:17:"erp_settle_amount";i:0;s:20:"erp_un_settle_amount";s:6:"114633";}', '', 5252, '124.64.23.198') |
12:25:50.192 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3387 |
12:25:50.193 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
12:25:50.193 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
12:25:50.193 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3934 |
12:25:50.194 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
12:25:50.194 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
12:25:50.194 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3934 |
12:25:50.212 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=3934 |
12:25:50.213 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3934) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
12:25:50.215 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
12:25:50.216 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
12:25:50.216 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_change_logs" SET "end_at"='now()' WHERE "id"=16644 |
12:25:50.217 | 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\ProjectChangeLogs', 16644, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 5252, '124.64.23.198') |
12:25:50.218 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_project_change_logs" ("project_id", "project_status", "budget", "profit_pct", "collected", "start_from", "end_at") VALUES (3934, 3, '114632', '20', '0', 'now()', NULL) RETURNING "id" |
12:25:50.223 | 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\ProjectChangeLogs', 16645, 'a:8:{s:2:"id";i:16645;s:10:"project_id";i:3934;s:14:"project_status";i:3;s:6:"budget";s:6:"114632";s:10:"profit_pct";s:2:"20";s:9:"collected";i:0;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 5252, '124.64.23.198') |
12:25:50.223 | 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\Projects', 3934, 'a:1:{s:9:"collected";i:0;}', '', 5252, '124.64.23.198') |
12:25:50.224 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3387 |
12:25:50.225 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE (erp_other_income_ticket_id is not null) AND ("erp_collect_ticket_id"=1988) ORDER BY "id" |
12:25:50.225 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE (erp_other_collect_ticket_id is not null) AND ("erp_collect_ticket_id"=1988) ORDER BY "id" |
12:25:50.226 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" WHERE "erp_collect_ticket_id"=1988 ORDER BY "id" |
12:25:50.227 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252 |
12:25:50.228 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" WHERE ("status"=0) AND ("erp_collect_ticket_id"=1988) ORDER BY "id" |
12:25:50.228 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_collect_tickets" SET "status"=2, "verify_at"='now()', "updated_at"='now()' WHERE "id"=1988 |
12:25:50.229 | 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\ErpCollectTickets', 1988, 'a:2:{s:6:"status";i:2;s:9:"verify_at";s:5:"now()";}', '', 5252, '124.64.23.198') |
12:25:50.230 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" WHERE "erp_collect_ticket_id"=1988 ORDER BY "id" |
12:25:50.230 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE (purchase_contract_id is not null) AND ("erp_collect_ticket_id"=1988) ORDER BY "id" |
12:25:50.231 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE (sales_contract_id is not null) AND ("erp_collect_ticket_id"=1988) ORDER BY "id" |
12:25:50.231 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4071 |
12:25:50.231 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4071) AND ("t"."status" IN (2, 5, 1)) |
12:25:50.232 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4071) AND ("t"."status" IN (2, 5, 1)) |
12:25:50.232 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."sales_contract_id"=4071) AND ("t"."status" IN (2, 5, 1)) |
12:25:50.233 | info | yii\db\Command::query | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4071) AND ("t"."status"=1)) |
12:25:50.233 | info | yii\db\Command::query | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4071) AND ("t"."status"=1)) |
12:25:50.234 | info | yii\db\Command::query | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."sales_contract_id"=4071) AND ("t"."status"=1)) |
12:25:50.235 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='114632', "erp_collect_ticket_is_verify"=FALSE WHERE "id"=4071 |
12:25:50.235 | 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\SalesContracts', 4071, 'a:0:{}', '', 5252, '124.64.23.198') |
12:25:50.236 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3387 |
12:25:50.237 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3934 |
12:25:50.237 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3934 |
12:25:50.239 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=3934 |
12:25:50.239 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3934) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
12:25:50.241 | 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\Projects', 3934, 'a:0:{}', '', 5252, '124.64.23.198') |
12:25:50.242 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3387 |
12:25:50.242 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE (erp_other_income_ticket_id is not null) AND ("erp_collect_ticket_id"=1988) ORDER BY "id" |
12:25:50.243 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE (erp_other_collect_ticket_id is not null) AND ("erp_collect_ticket_id"=1988) ORDER BY "id" |
12:25:50.243 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" WHERE "erp_collect_ticket_id"=1988 ORDER BY "id" |
12:25:50.243 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE "id"=1988 |
12:25:50.244 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
12:25:50.244 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
12:25:50.244 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_ticket_change_logs" ("status", "ticket_type", "serial_no", "wrote_date", "description", "abstract", "client_id", "supplier_id", "created_by", "created_at", "updated_at", "verify_at") VALUES (2, 20013, 'FK-20250804-00002', '2025-08-04', '', '方式是对方', 3387, NULL, 5252, '2025-08-04 12:25:50', '2025-08-04 12:25:50', '2025-08-04 12:25:50.228866+08') RETURNING "id" |
12:25:50.245 | 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\ErpTicketChangeLogs', 16, 'a:13:{s:2:"id";i:16;s:9:"serial_no";s:17:"FK-20250804-00002";s:11:"ticket_type";i:20013;s:10:"wrote_date";s:10:"2025-08-04";s:6:"status";i:2;s:11:"supplier_id";N;s:9:"client_id";i:3387;s:8:"abstract";s:15:"方式是对方";s:11:"description";s:0:"";s:9:"verify_at";s:29:"2025-08-04 12:25:50.228866+08";s:10:"created_by";i:5252;s:10:"created_at";s:19:"2025-08-04 12:25:50";s:10:"updated_at";s:19:"2025-08-04 12:25:50";}', '', 5252, '124.64.23.198') |
12:25:50.246 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
12:25:50.246 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
12:25:50.246 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_erp_ticket_change_log_handlers" ("erp_ticket_change_log_id", "user_id") VALUES (16, 1005) |
12:25:50.248 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252 |
12:25:50.248 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
12:25:50.248 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
12:25:50.248 | 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', 1988, 20013, 5252, '2025-08-04 12:25:50', '{"id":1988,"serial_no":"FK-20250804-00002","wrote_date":"2025-08-04","from_date":null,"handler":1005,"user_id":null,"client_id":3387,"sales_contract_id":null,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":"\u65b9\u5f0f\u662f\u5bf9\u65b9","description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"now()","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"1","settle_amount":"0","created_by":5252,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2025-08-04 12:25:50","updated_at":"1970-01-01 08:00:00","paid_amount":null}', '{"id":1988,"serial_no":"FK-20250804-00002","wrote_date":"2025-08-04","from_date":null,"handler":1005,"user_id":null,"client_id":3387,"sales_contract_id":null,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":"\u65b9\u5f0f\u662f\u5bf9\u65b9","description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"now()","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"1","settle_amount":"0","created_by":5252,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2025-08-04 12:25:50","updated_at":"1970-01-01 08:00:00","paid_amount":null}', '{"d1":"\u738b\u7b11\u7b11","d2":"\u521b\u5efa\u4e86","d3":"\u6536\u6b3e\u5355\u7533\u8bf7","d4":[]}') RETURNING "id" |
12:25:50.250 | 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', 551521, 'a:13:{s:2:"id";i:551521;s:9:"object_id";i:1988;s:11:"object_type";i:20013;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:626:"{"id":1988,"serial_no":"FK-20250804-00002","wrote_date":"2025-08-04","from_date":null,"handler":1005,"user_id":null,"client_id":3387,"sales_contract_id":null,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":"\u65b9\u5f0f\u662f\u5bf9\u65b9","description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"now()","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"1","settle_amount":"0","created_by":5252,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2025-08-04 12:25:50","updated_at":"1970-01-01 08:00:00","paid_amount":null}";s:9:"new_value";s:626:"{"id":1988,"serial_no":"FK-20250804-00002","wrote_date":"2025-08-04","from_date":null,"handler":1005,"user_id":null,"client_id":3387,"sales_contract_id":null,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":"\u65b9\u5f0f\u662f\u5bf9\u65b9","description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"now()","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"1","settle_amount":"0","created_by":5252,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2025-08-04 12:25:50","updated_at":"1970-01-01 08:00:00","paid_amount":null}";s:11:"description";s:99:"{"d1":"\u738b\u7b11\u7b11","d2":"\u521b\u5efa\u4e86","d3":"\u6536\u6b3e\u5355\u7533\u8bf7","d4":[]}";s:10:"created_by";i:5252;s:10:"created_at";s:19:"2025-08-04 12:25:50";s:9:"is_delete";N;}', '', 5252, '124.64.23.198') |
12:25:50.251 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE (sales_contract_id is not null) AND ("erp_collect_ticket_id"=1988) ORDER BY "id" |
12:25:50.251 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE 0=1 |
12:25:50.252 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
12:25:50.252 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
12:25:50.252 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5252, 5, 'vue/erp-collect-ticket/save-new', '{"ErpCollectTickets":{"id":"","auto_id":"3387","auto_name":"\u5317\u4eac\u4e45\u5b89\u667a\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8","auto_type":"client","handler":"1005","handler_name":"","wrote_date":"2025-08-04","serial_no":"FK-20250804-00002","abstract":"\u65b9\u5f0f\u662f\u5bf9\u65b9","description":"","client_id":"3387","client_name":"\u5317\u4eac\u4e45\u5b89\u667a\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8","supplier_id":"","supplier_name":"","files":"","erpCollectTicketVerifyRels":"","erpCollectTicketBankIns":"","erpCollectTicketPayments":"","erpCollectTicketSettles":[{"purchase_contract_id":"","sales_contract_id":"4071","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"1","erpCollectTicketApprovePaymentSettles":""}]},"web_access_token":"zd4K9tC1F9pL73eX9UTaEjjdfA981F9e"}', '{"code":2000,"result":{"id":1988},"status":1,"msg":[{"name":"success","success":"\u65b0\u6536\u6b3e\u5355\u5df2\u521b\u5efa\u6210\u529f","error":""}],"mod":0}', FALSE, '2025-08-04 12:25:50') RETURNING "id" |
12:25:50.253 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
12:25:50.254 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |