21:21:07.799 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
21:21:07.799 | trace | yii\base\Module::getModule | Loading module: debug |
21:21:07.799 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
21:21:07.800 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
21:21:07.800 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
21:21:07.800 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
21:21:07.800 | trace | yii\base\Module::getModule | Loading module: gii |
21:21:07.800 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
21:21:07.800 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
21:21:07.800 | trace | yii\web\Application::handleRequest | Route requested: 'vue/erp-collect-ticket/save-new' |
21:21:07.800 | trace | yii\base\Module::getModule | Loading module: vue |
21:21:07.801 | info | yii\web\Session::open | Session started |
21:21:07.801 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
21:21:07.801 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
21:21:07.805 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
21:21:07.806 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
21:21:07.806 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
21:21:07.806 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
21:21:07.806 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
21:21:07.808 | trace | yii\base\Controller::runAction | Route to run: vue/erp-collect-ticket/save-new |
21:21:07.808 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
21:21:07.809 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
21:21:07.809 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\ErpCollectTicketController::actionSaveNew() |
21:21:07.810 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'id' in 'app\models\ErpCollectTickets'. |
21:21:07.810 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'auto_id' in 'app\models\ErpCollectTickets'. |
21:21:07.810 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'auto_name' in 'app\models\ErpCollectTickets'. |
21:21:07.810 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'auto_type' in 'app\models\ErpCollectTickets'. |
21:21:07.810 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
21:21:07.810 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
21:21:07.810 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'handler_name' in 'app\models\ErpCollectTickets'. |
21:21:07.810 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'erpCollectTicketVerifyRels' in 'app\models\ErpCollectTickets'. |
21:21:07.810 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'client_name' in 'app\models\ErpCollectTickets'. |
21:21:07.810 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'supplier_name' in 'app\models\ErpCollectTickets'. |
21:21:07.810 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'user_name' in 'app\models\ErpCollectTickets'. |
21:21:07.810 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'contact_name' in 'app\models\ErpCollectTickets'. |
21:21:07.810 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'files' in 'app\models\ErpCollectTickets'. |
21:21:07.810 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'erpCollectTicketBankIns' in 'app\models\ErpCollectTickets'. |
21:21:07.810 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'erpCollectTicketPayments' in 'app\models\ErpCollectTickets'. |
21:21:07.810 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'erpCollectTicketSettles' in 'app\models\ErpCollectTickets'. |
21:21:07.810 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
21:21:07.811 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
21:21:07.811 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE ("created_at" >= '2025-08-17 00:00:00') AND ("created_at" <= '2025-08-17 23:59:59') AND ("serial_no" ILIKE '%SKD-20250817-%') AND (LENGTH(serial_no) = 18) ORDER BY "serial_no" DESC |
21:21:07.813 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE "serial_no"='SKD-20250817-00003') |
21:21:07.814 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1000') |
21:21:07.814 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
21:21:07.815 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"='3649') |
21:21:07.815 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_collect_tickets" ("handler", "wrote_date", "serial_no", "abstract", "description", "client_id", "supplier_id", "user_id", "contact_id", "verify_type", "created_by", "created_at", "status", "is_resubmitted", "amount", "settle_amount") VALUES (1000, '2025-08-17', 'SKD-20250817-00003', '', '', NULL, NULL, NULL, 3649, 1, 1001, 'now()', 1, FALSE, '0', '0') RETURNING "id" |
21:21:07.819 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
21:21:07.819 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
21:21:07.819 | 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', 1996, 'a:30:{s:2:"id";i:1996;s:9:"serial_no";s:18:"SKD-20250817-00003";s:10:"wrote_date";s:10:"2025-08-17";s:9:"from_date";N;s:7:"handler";s:4:"1000";s:7:"user_id";s:0:"";s:9:"client_id";s:0:"";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:0:"";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:1001;s:16:"stop_description";N;s:9:"is_settle";N;s:6:"is_old";N;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:10:"updated_at";N;s:11:"paid_amount";N;s:10:"contact_id";s:4:"3649";}', '', 1001, '114.254.228.198') |
21:21:07.820 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20022) AND ("object_id"=1996) |
21:21:07.822 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" WHERE "erp_collect_ticket_id"=1996 |
21:21:07.822 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
21:21:07.822 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
21:21:07.822 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" ("erp_collect_ticket_id", "user_id", "status") VALUES (1996, 1001, 0) |
21:21:07.824 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE "erp_collect_ticket_id"=1996 |
21:21:07.824 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
21:21:07.824 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
21:21:07.824 | 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 (1996, NULL, NULL, NULL, 3, '22') RETURNING "id" |
21:21:07.826 | 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', 1999, 'a:8:{s:2:"id";i:1999;s:21:"erp_collect_ticket_id";i:1996;s:17:"sales_contract_id";s:0:"";s:20:"purchase_contract_id";s:0:"";s:26:"erp_other_income_ticket_id";s:0:"";s:27:"erp_other_collect_ticket_id";s:1:"3";s:6:"amount";s:2:"22";s:11:"description";N;}', '', 1001, '114.254.228.198') |
21:21:07.827 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" WHERE "erp_collect_ticket_id"=1996 |
21:21:07.827 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
21:21:07.827 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
21:21:07.832 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" ("erp_collect_ticket_id", "erp_bank_id", "amount", "description") VALUES (1996, 1, '22', '') |
21:21:07.833 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" WHERE ("status"=0) AND ("erp_collect_ticket_id"=1996) ORDER BY "id" |
21:21:07.834 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_collect_tickets" SET "amount"='22', "next_verify_user"=1001 WHERE "id"=1996 |
21:21:07.835 | 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', 1996, 'a:1:{s:6:"amount";i:22;}', '', 1001, '114.254.228.198') |
21:21:07.837 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE "id"=1996 |
21:21:07.837 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" WHERE "erp_collect_ticket_id"=1996 ORDER BY "id" |
21:21:07.838 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
21:21:07.838 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
21:21:07.838 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
21:21:07.838 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
21:21:07.840 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_tickets" "t" ON r.erp_bank_transfer_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
21:21:07.841 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_tickets" "t" ON r.erp_bank_transfer_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
21:21:07.842 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
21:21:07.843 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" ON r.erp_advance_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
21:21:07.844 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_payment_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "t" ON r.erp_other_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
21:21:07.845 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
21:21:07.846 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
21:21:07.847 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
21:21:07.848 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_social_insurance_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON r.erp_social_insurance_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
21:21:07.849 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_provident_fund_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON r.erp_provident_fund_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
21:21:07.850 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_personal_tax_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON r.erp_personal_tax_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
21:21:07.851 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_prize_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_prizes" "t" ON r.erp_wage_prize_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
21:21:07.852 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
21:21:07.853 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='2435161' WHERE "id"=1 |
21:21:07.854 | 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\ErpBanks', 1, 'a:0:{}', '', 1001, '114.254.228.198') |
21:21:07.855 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
21:21:07.855 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71 |
21:21:07.856 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
21:21:07.856 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
21:21:07.856 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_account_captions" SET "created_at"='2025-08-11 19:05:28', "updated_at"='2025-08-11 19:42:11' WHERE "id"=71 |
21:21:07.857 | 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\ErpAccountCaptions', 71, 'a:0:{}', '', 1001, '114.254.228.198') |
21:21:07.858 | 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\ErpBanks', 1, 'a:0:{}', '', 1001, '114.254.228.198') |
21:21:07.858 | 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"=1996) ORDER BY "id" |
21:21:07.859 | 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"=1996) ORDER BY "id" |
21:21:07.859 | 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"=1996) ORDER BY "id" |
21:21:07.860 | 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"=1996) ORDER BY "id" |
21:21:07.860 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=3 |
21:21:07.860 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
21:21:07.861 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
21:21:07.861 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."erp_other_collect_ticket_id"=3) AND ("t"."status" IN (2, 5)) |
21:21:07.861 | 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"."erp_other_collect_ticket_id"=3) AND ("t"."status" IN (2, 5)) |
21:21:07.862 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_amount_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id WHERE ("r"."erp_other_collect_ticket_id"=3) AND ("t"."status" IN (2, 5)) |
21:21:07.863 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_other_collect_tickets" SET "settle_amount"='0' WHERE "id"=3 |
21:21:07.864 | 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\ErpOtherCollectTickets', 3, 'a:0:{}', '', 1001, '114.254.228.198') |
21:21:07.864 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" WHERE "erp_collect_ticket_id"=1996 ORDER BY "id" |
21:21:07.865 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
21:21:07.865 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" WHERE ("status"=0) AND ("erp_collect_ticket_id"=1996) ORDER BY "id" |
21:21:07.866 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
21:21:07.866 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
21:21:07.866 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
21:21:07.866 | 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', 1996, 20013, 1001, '2025-08-17 21:21:07', '{"id":1996,"serial_no":"SKD-20250817-00003","wrote_date":"2025-08-17","from_date":null,"handler":1000,"user_id":null,"client_id":null,"sales_contract_id":null,"supplier_id":null,"purchase_contract_id":null,"status":1,"abstract":"","description":"","verify_type":1,"next_verify_user":1001,"next_stop_verify_user":null,"verify_at":null,"stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"22","settle_amount":"0","created_by":1001,"stop_description":null,"is_settle":false,"is_old":false,"created_at":"2025-08-17 21:21:07","updated_at":"2025-08-17 21:21:07","paid_amount":null,"contact_id":3649}', '{"id":1996,"serial_no":"SKD-20250817-00003","wrote_date":"2025-08-17","from_date":null,"handler":1000,"user_id":null,"client_id":null,"sales_contract_id":null,"supplier_id":null,"purchase_contract_id":null,"status":1,"abstract":"","description":"","verify_type":1,"next_verify_user":1001,"next_stop_verify_user":null,"verify_at":null,"stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"22","settle_amount":"0","created_by":1001,"stop_description":null,"is_settle":false,"is_old":false,"created_at":"2025-08-17 21:21:07","updated_at":"2025-08-17 21:21:07","paid_amount":null,"contact_id":3649}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u6536\u6b3e\u5355\u7533\u8bf7","d4":[]}') RETURNING "id" |
21:21:07.867 | 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', 553845, 'a:13:{s:2:"id";i:553845;s:9:"object_id";i:1996;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:614:"{"id":1996,"serial_no":"SKD-20250817-00003","wrote_date":"2025-08-17","from_date":null,"handler":1000,"user_id":null,"client_id":null,"sales_contract_id":null,"supplier_id":null,"purchase_contract_id":null,"status":1,"abstract":"","description":"","verify_type":1,"next_verify_user":1001,"next_stop_verify_user":null,"verify_at":null,"stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"22","settle_amount":"0","created_by":1001,"stop_description":null,"is_settle":false,"is_old":false,"created_at":"2025-08-17 21:21:07","updated_at":"2025-08-17 21:21:07","paid_amount":null,"contact_id":3649}";s:9:"new_value";s:614:"{"id":1996,"serial_no":"SKD-20250817-00003","wrote_date":"2025-08-17","from_date":null,"handler":1000,"user_id":null,"client_id":null,"sales_contract_id":null,"supplier_id":null,"purchase_contract_id":null,"status":1,"abstract":"","description":"","verify_type":1,"next_verify_user":1001,"next_stop_verify_user":null,"verify_at":null,"stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"22","settle_amount":"0","created_by":1001,"stop_description":null,"is_settle":false,"is_old":false,"created_at":"2025-08-17 21:21:07","updated_at":"2025-08-17 21:21:07","paid_amount":null,"contact_id":3649}";s:11:"description";s:99:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u6536\u6b3e\u5355\u7533\u8bf7","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-08-17 21:21:07";s:9:"is_delete";N;}', '', 1001, '114.254.228.198') |
21:21:07.868 | 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"=1996) ORDER BY "id" |
21:21:07.869 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
21:21:07.869 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
21:21:07.869 | 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', 1001, 5, 'vue/erp-collect-ticket/save-new', '{"ErpCollectTickets":{"id":"","auto_id":"3649","auto_name":"\u59da\u96ea\u7eaf(\u5ba2\u6237\uff1a\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240)","auto_type":"contact","handler":"1000","handler_name":"","wrote_date":"2025-08-17","serial_no":"SKD-20250817-00003","erpCollectTicketVerifyRels":["1001"],"abstract":"","description":"","client_id":"","client_name":"","supplier_id":"","supplier_name":"","user_id":"","user_name":"","contact_id":"3649","contact_name":"\u59da\u96ea\u7eaf(\u5ba2\u6237\uff1a\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240)","files":"","erpCollectTicketBankIns":[{"amount":"22","id":"1","description":""}],"erpCollectTicketPayments":"","erpCollectTicketSettles":[{"purchase_contract_id":"","sales_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"3","amount":"22","erpCollectTicketApprovePaymentSettles":""}]},"web_access_token":"BMGt48y3qPFgSCE_7v0QuJKVG4C78oer"}', '{"code":2000,"result":{"id":1996},"status":1,"msg":[{"name":"success","success":"\u65b0\u6536\u6b3e\u5355\u5df2\u521b\u5efa\u6210\u529f","error":""}],"mod":0}', FALSE, '2025-08-17 21:21:07') RETURNING "id" |
21:21:07.870 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
21:21:07.870 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |