17:27:16.858 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
17:27:16.858 | trace | yii\base\Module::getModule | Loading module: debug |
17:27:16.859 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
17:27:16.859 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
17:27:16.859 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
17:27:16.859 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:16.859 | trace | yii\base\Module::getModule | Loading module: gii |
17:27:16.859 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
17:27:16.859 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
17:27:16.859 | trace | yii\web\Application::handleRequest | Route requested: 'vue/erp-collect-ticket/save-new' |
17:27:16.859 | trace | yii\base\Module::getModule | Loading module: vue |
17:27:16.860 | info | yii\web\Session::open | Session started |
17:27:16.860 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
17:27:16.860 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
17:27:16.865 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:16.865 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:27:16.865 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:16.865 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:27:16.865 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
17:27:16.867 | trace | yii\base\Controller::runAction | Route to run: vue/erp-collect-ticket/save-new |
17:27:16.867 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:16.868 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
17:27:16.868 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\ErpCollectTicketController::actionSaveNew() |
17:27:16.869 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'id' in 'app\models\ErpCollectTickets'. |
17:27:16.869 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'auto_id' in 'app\models\ErpCollectTickets'. |
17:27:16.869 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'auto_name' in 'app\models\ErpCollectTickets'. |
17:27:16.869 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'auto_type' in 'app\models\ErpCollectTickets'. |
17:27:16.869 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:16.869 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:27:16.869 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'handler_name' in 'app\models\ErpCollectTickets'. |
17:27:16.869 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'client_name' in 'app\models\ErpCollectTickets'. |
17:27:16.869 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'supplier_name' in 'app\models\ErpCollectTickets'. |
17:27:16.869 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'files' in 'app\models\ErpCollectTickets'. |
17:27:16.869 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'erpCollectTicketVerifyRels' in 'app\models\ErpCollectTickets'. |
17:27:16.869 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'erpCollectTicketBankIns' in 'app\models\ErpCollectTickets'. |
17:27:16.869 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'erpCollectTicketPayments' in 'app\models\ErpCollectTickets'. |
17:27:16.869 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'erpCollectTicketSettles' in 'app\models\ErpCollectTickets'. |
17:27:16.869 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:16.870 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:16.870 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE ("created_at" >= '2025-08-08 00:00:00') AND ("created_at" <= '2025-08-08 23:59:59') AND ("serial_no" ILIKE '%FK-20250808-%') AND (LENGTH(serial_no) = 17) ORDER BY "serial_no" DESC |
17:27:16.872 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE "serial_no"='FK-20250808-00002') |
17:27:16.873 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1001') |
17:27:16.874 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3286') |
17:27:16.874 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
17:27:16.875 | 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") VALUES (1001, '2025-08-08', 'FK-20250808-00002', '', '', 3286, NULL, 1, 1001, 'now()', 1, FALSE, '0', '0') RETURNING "id" |
17:27:16.879 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:16.879 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:27:16.880 | 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', 1991, 'a:29:{s:2:"id";i:1991;s:9:"serial_no";s:17:"FK-20250808-00002";s:10:"wrote_date";s:10:"2025-08-08";s:9:"from_date";N;s:7:"handler";s:4:"1001";s:7:"user_id";N;s:9:"client_id";s:4:"3286";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;}', '', 1001, '124.64.23.198') |
17:27:16.882 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20022) AND ("object_id"=1991) |
17:27:16.883 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE "erp_collect_ticket_id"=1991 |
17:27:16.884 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:16.884 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:27:16.884 | 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 (1991, 4075, NULL, NULL, NULL, '1') RETURNING "id" |
17:27:16.889 | 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', 1996, 'a:8:{s:2:"id";i:1996;s:21:"erp_collect_ticket_id";i:1991;s:17:"sales_contract_id";s:4:"4075";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;}', '', 1001, '124.64.23.198') |
17:27:16.891 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" WHERE "erp_collect_ticket_id"=1991 |
17:27:16.892 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:16.892 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:27:16.893 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" ("erp_collect_ticket_id", "erp_bank_id", "amount", "description") VALUES (1991, 1, '1', '') |
17:27:16.895 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" WHERE ("status"=0) AND ("erp_collect_ticket_id"=1991) ORDER BY "id" |
17:27:16.896 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_collect_tickets" SET "amount"='1', "next_verify_user"=NULL WHERE "id"=1991 |
17:27:16.897 | 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', 1991, 'a:0:{}', '', 1001, '124.64.23.198') |
17:27:16.897 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE "id"=1991 |
17:27:16.898 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" WHERE "erp_collect_ticket_id"=1991 ORDER BY "id" |
17:27:16.898 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
17:27:16.899 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:16.899 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:27:16.899 | 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)) |
17:27:16.904 | 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)) |
17:27:16.905 | 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)) |
17:27:16.907 | 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)) |
17:27:16.912 | 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) |
17:27:16.913 | 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)) |
17:27:16.915 | 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)) |
17:27:16.916 | 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) |
17:27:16.917 | 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)) |
17:27:16.918 | 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) |
17:27:16.920 | 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) |
17:27:16.922 | 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) |
17:27:16.923 | 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) |
17:27:16.925 | 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)) AND ("t"."is_payment_settle"=TRUE) |
17:27:16.926 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='9999889.54' WHERE "id"=1 |
17:27:16.927 | 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, '124.64.23.198') |
17:27:16.927 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
17:27:16.928 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71 |
17:27:16.928 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:16.928 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:27:16.929 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_account_captions" SET "created_at"='2025-08-04 10:34:39', "updated_at"='2025-08-07 18:01:25' WHERE "id"=71 |
17:27:16.929 | 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, '124.64.23.198') |
17:27:16.930 | 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, '124.64.23.198') |
17:27:16.931 | 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"=1991) ORDER BY "id" |
17:27:16.932 | 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"=1991) ORDER BY "id" |
17:27:16.932 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4075 |
17:27:16.933 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:16.933 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:27:16.933 | 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"=4075) AND ("t"."status" IN (2, 5, 1)) |
17:27:16.934 | 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"=4075) AND ("t"."status" IN (2, 5, 1)) |
17:27:16.934 | 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"=4075) AND ("t"."status" IN (2, 5, 1)) |
17:27:16.935 | 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"=4075) AND ("t"."status"=1)) |
17:27:16.936 | 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"=4075) AND ("t"."status"=1)) |
17:27:16.936 | 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"=4075) AND ("t"."status"=1)) |
17:27:16.937 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='1', "erp_un_settle_amount"='59999', "erp_collect_ticket_is_verify"=TRUE WHERE "id"=4075 |
17:27:16.938 | 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', 4075, 'a:2:{s:17:"erp_settle_amount";s:1:"0";s:20:"erp_un_settle_amount";i:59999;}', '', 1001, '124.64.23.198') |
17:27:16.939 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3286 |
17:27:16.940 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:16.940 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:27:16.940 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3927 |
17:27:16.941 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:16.941 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:27:16.941 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3927 |
17:27:16.958 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "collected"='1' WHERE "id"=3927 |
17:27:16.959 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3927) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
17:27:16.961 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:16.962 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:27:16.962 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_change_logs" SET "end_at"='now()' WHERE "id"=16649 |
17:27:16.963 | 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', 16649, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '124.64.23.198') |
17:27:16.964 | 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 (3927, 3, '60000', '99.33', '1', 'now()', NULL) RETURNING "id" |
17:27:16.965 | 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', 16663, 'a:8:{s:2:"id";i:16663;s:10:"project_id";i:3927;s:14:"project_status";i:3;s:6:"budget";s:5:"60000";s:10:"profit_pct";s:5:"99.33";s:9:"collected";i:1;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '124.64.23.198') |
17:27:16.966 | 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', 3927, 'a:1:{s:9:"collected";s:1:"0";}', '', 1001, '124.64.23.198') |
17:27:16.966 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3286 |
17:27:16.967 | 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"=1991) ORDER BY "id" |
17:27:16.967 | 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"=1991) ORDER BY "id" |
17:27:16.969 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" WHERE "erp_collect_ticket_id"=1991 ORDER BY "id" |
17:27:16.969 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
17:27:16.969 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" WHERE ("status"=0) AND ("erp_collect_ticket_id"=1991) ORDER BY "id" |
17:27:16.970 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_collect_tickets" SET "status"=2, "verify_at"='now()', "updated_at"='now()' WHERE "id"=1991 |
17:27:16.971 | 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', 1991, 'a:2:{s:6:"status";i:2;s:9:"verify_at";s:5:"now()";}', '', 1001, '124.64.23.198') |
17:27:16.971 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" WHERE "erp_collect_ticket_id"=1991 ORDER BY "id" |
17:27:16.972 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
17:27:16.972 | 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)) |
17:27:16.973 | 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)) |
17:27:16.973 | 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)) |
17:27:16.973 | 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)) |
17:27:16.974 | 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) |
17:27:16.974 | 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)) |
17:27:16.975 | 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)) |
17:27:16.975 | 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) |
17:27:16.975 | 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)) |
17:27:16.976 | 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) |
17:27:16.976 | 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) |
17:27:16.977 | 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) |
17:27:16.977 | 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) |
17:27:16.977 | 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)) AND ("t"."is_payment_settle"=TRUE) |
17:27:16.978 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='9999890.54' WHERE "id"=1 |
17:27:16.979 | 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:1:{s:14:"balance_amount";d:9999890.5399999991;}', '', 1001, '124.64.23.198') |
17:27:16.979 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
17:27:16.980 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71 |
17:27:16.980 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_account_captions" SET "balance_amount"='9999890.54', "created_at"='2025-08-04 10:34:39', "updated_at"='2025-08-07 18:01:25' WHERE "id"=71 |
17:27:16.981 | 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:1:{s:14:"balance_amount";s:10:"9999890.54";}', '', 1001, '124.64.23.198') |
17:27:16.982 | 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, '124.64.23.198') |
17:27:16.983 | 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"=1991) ORDER BY "id" |
17:27:16.983 | 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"=1991) ORDER BY "id" |
17:27:16.983 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4075 |
17:27:16.984 | 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"=4075) AND ("t"."status" IN (2, 5, 1)) |
17:27:16.984 | 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"=4075) AND ("t"."status" IN (2, 5, 1)) |
17:27:16.985 | 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"=4075) AND ("t"."status" IN (2, 5, 1)) |
17:27:16.985 | 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"=4075) AND ("t"."status"=1)) |
17:27:16.986 | 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"=4075) AND ("t"."status"=1)) |
17:27:16.986 | 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"=4075) AND ("t"."status"=1)) |
17:27:16.987 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='1', "erp_un_settle_amount"='59999', "erp_collect_ticket_is_verify"=FALSE WHERE "id"=4075 |
17:27:16.988 | 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', 4075, 'a:0:{}', '', 1001, '124.64.23.198') |
17:27:16.989 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3286 |
17:27:16.989 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3927 |
17:27:16.990 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3927 |
17:27:16.991 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "collected"='1' WHERE "id"=3927 |
17:27:16.991 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3927) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
17:27:16.993 | 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', 3927, 'a:0:{}', '', 1001, '124.64.23.198') |
17:27:16.994 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3286 |
17:27:16.994 | 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"=1991) ORDER BY "id" |
17:27:16.994 | 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"=1991) ORDER BY "id" |
17:27:16.995 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" WHERE "erp_collect_ticket_id"=1991 ORDER BY "id" |
17:27:16.996 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE "id"=1991 |
17:27:16.997 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:16.997 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:27:16.997 | 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-20250808-00002', '2025-08-08', '', '', 3286, NULL, 1001, '2025-08-08 17:27:16', '2025-08-08 17:27:16', '2025-08-08 17:27:16.970375+08') RETURNING "id" |
17:27:16.998 | 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', 53, 'a:13:{s:2:"id";i:53;s:9:"serial_no";s:17:"FK-20250808-00002";s:11:"ticket_type";i:20013;s:10:"wrote_date";s:10:"2025-08-08";s:6:"status";i:2;s:11:"supplier_id";N;s:9:"client_id";i:3286;s:8:"abstract";s:0:"";s:11:"description";s:0:"";s:9:"verify_at";s:29:"2025-08-08 17:27:16.970375+08";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-08-08 17:27:16";s:10:"updated_at";s:19:"2025-08-08 17:27:16";}', '', 1001, '124.64.23.198') |
17:27:17.000 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:17.000 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:27:17.000 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_erp_ticket_change_log_handlers" ("erp_ticket_change_log_id", "user_id") VALUES (53, 1001) |
17:27:17.001 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
17:27:17.002 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:17.002 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:27:17.002 | 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', 1991, 20013, 1001, '2025-08-08 17:27:16', '{"id":1991,"serial_no":"FK-20250808-00002","wrote_date":"2025-08-08","from_date":null,"handler":1001,"user_id":null,"client_id":3286,"sales_contract_id":null,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":"","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":1001,"stop_description":null,"is_settle":false,"is_old":false,"created_at":"2025-08-08 17:27:16","updated_at":"1970-01-01 08:00:00","paid_amount":null}', '{"id":1991,"serial_no":"FK-20250808-00002","wrote_date":"2025-08-08","from_date":null,"handler":1001,"user_id":null,"client_id":3286,"sales_contract_id":null,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":"","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":1001,"stop_description":null,"is_settle":false,"is_old":false,"created_at":"2025-08-08 17:27:16","updated_at":"1970-01-01 08:00:00","paid_amount":null}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u6536\u6b3e\u5355\u7533\u8bf7","d4":[]}') RETURNING "id" |
17:27:17.003 | 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', 551931, 'a:13:{s:2:"id";i:551931;s:9:"object_id";i:1991;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:597:"{"id":1991,"serial_no":"FK-20250808-00002","wrote_date":"2025-08-08","from_date":null,"handler":1001,"user_id":null,"client_id":3286,"sales_contract_id":null,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":"","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":1001,"stop_description":null,"is_settle":false,"is_old":false,"created_at":"2025-08-08 17:27:16","updated_at":"1970-01-01 08:00:00","paid_amount":null}";s:9:"new_value";s:597:"{"id":1991,"serial_no":"FK-20250808-00002","wrote_date":"2025-08-08","from_date":null,"handler":1001,"user_id":null,"client_id":3286,"sales_contract_id":null,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":"","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":1001,"stop_description":null,"is_settle":false,"is_old":false,"created_at":"2025-08-08 17:27:16","updated_at":"1970-01-01 08:00:00","paid_amount":null}";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-08 17:27:16";s:9:"is_delete";N;}', '', 1001, '124.64.23.198') |
17:27:17.004 | 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"=1991) ORDER BY "id" |
17:27:17.004 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE 0=1 |
17:27:17.005 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:17.005 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:27:17.005 | 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":"3286","auto_name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8","auto_type":"client","handler":"1001","handler_name":"","wrote_date":"2025-08-08","serial_no":"FK-20250808-00002","abstract":"","description":"","client_id":"3286","client_name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8","supplier_id":"","supplier_name":"","files":"","erpCollectTicketVerifyRels":"","erpCollectTicketBankIns":[{"amount":"1","id":"1","description":""}],"erpCollectTicketPayments":"","erpCollectTicketSettles":[{"purchase_contract_id":"","sales_contract_id":"4075","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"1","erpCollectTicketApprovePaymentSettles":""}]},"web_access_token":"0Bjt7zsA4RpFpNhApjLlKpy587hFcKCO"}', '{"code":2000,"result":{"id":1991},"status":1,"msg":[{"name":"success","success":"\u65b0\u6536\u6b3e\u5355\u5df2\u521b\u5efa\u6210\u529f","error":""}],"mod":0}', FALSE, '2025-08-08 17:27:17') RETURNING "id" |
17:27:17.006 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:27:17.006 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |