689b001aa4c4b: POST https://beta.jinchangxiao.com/vue/erp-payment-ticket/save-settle at 2025-08-12 04:49:30 pm by 114.254.2.139
Log Messages
总计171条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 16:49:30.674 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 16:49:30.674 | trace | yii\base\Module::getModule | Loading module: debug |
| 16:49:30.674 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 16:49:30.674 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 16:49:30.675 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 16:49:30.675 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:49:30.675 | trace | yii\base\Module::getModule | Loading module: gii |
| 16:49:30.675 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 16:49:30.675 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 16:49:30.675 | trace | yii\web\Application::handleRequest | Route requested: 'vue/erp-payment-ticket/save-settle' |
| 16:49:30.675 | trace | yii\base\Module::getModule | Loading module: vue |
| 16:49:30.675 | info | yii\web\Session::open | Session started |
| 16:49:30.676 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 16:49:30.676 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 16:49:30.681 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:49:30.681 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:49:30.681 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:49:30.681 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:49:30.681 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:49:30.683 | trace | yii\base\Controller::runAction | Route to run: vue/erp-payment-ticket/save-settle |
| 16:49:30.684 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:49:30.685 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 16:49:30.685 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\ErpPaymentTicketController::actionSaveSettle() |
| 16:49:30.685 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_tickets" WHERE "id"='2069' |
| 16:49:30.685 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:49:30.686 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:49:30.686 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:49:30.686 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:49:30.687 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:49:30.687 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:49:30.687 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 16:49:30.688 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_payment_tickets" SET "is_payment_settle"=TRUE WHERE "id"=2069 |
| 16:49:30.689 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:49:30.689 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:49:30.689 | 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\ErpPaymentTickets', 2069, 'a:0:{}', '', 1001, '114.254.2.139') |
| 16:49:30.690 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" WHERE "erp_payment_ticket_id"=2069 |
| 16:49:30.691 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:49:30.691 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:49:30.691 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 16:49:30.691 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" WHERE ("erp_payment_ticket_id"=2069) AND (erp_advance_payment_ticket_id is not null) |
| 16:49:30.692 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" WHERE ("erp_payment_ticket_id"=2069) AND (erp_other_collect_ticket_id is not null) |
| 16:49:30.692 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" WHERE "erp_payment_ticket_id"=2069 |
| 16:49:30.693 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" ("erp_payment_ticket_id", "erp_bank_id", "amount", "description") VALUES (2069, 1, '1', '111') |
| 16:49:30.694 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" WHERE "erp_payment_ticket_id"=2069 |
| 16:49:30.694 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20020) AND ("object_id"=2069) |
| 16:49:30.696 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:49:30.696 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:49:30.697 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20020) AND ("object_id"=2069) |
| 16:49:30.699 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (20020, 2069, 27245), (20020, 2069, 27245) |
| 16:49:30.700 | 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)) |
| 16:49:30.701 | 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)) |
| 16:49:30.702 | 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)) |
| 16:49:30.703 | 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)) |
| 16:49:30.704 | 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) |
| 16:49:30.704 | 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)) |
| 16:49:30.705 | 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)) |
| 16:49:30.706 | 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) |
| 16:49:30.707 | 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)) |
| 16:49:30.708 | 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) |
| 16:49:30.708 | 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) |
| 16:49:30.709 | 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) |
| 16:49:30.710 | 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) |
| 16:49:30.711 | 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) |
| 16:49:30.712 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='2222098' WHERE "id"=1 |
| 16:49:30.714 | 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";i:2222098;}', '', 1001, '114.254.2.139') |
| 16:49:30.715 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 16:49:30.715 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71 |
| 16:49:30.715 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:49:30.716 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:49:30.716 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_account_captions" SET "balance_amount"='2222098', "created_at"='2025-08-11 19:05:28', "updated_at"='2025-08-11 19:42:11' WHERE "id"=71 |
| 16:49:30.717 | 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:7:"2222098";}', '', 1001, '114.254.2.139') |
| 16:49:30.718 | 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.2.139') |
| 16:49:30.719 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" WHERE "erp_payment_ticket_id"=2069 ORDER BY "id" |
| 16:49:30.719 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 16:49:30.719 | 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)) |
| 16:49:30.720 | 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)) |
| 16:49:30.720 | 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)) |
| 16:49:30.721 | 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)) |
| 16:49:30.721 | 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) |
| 16:49:30.722 | 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)) |
| 16:49:30.722 | 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)) |
| 16:49:30.723 | 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) |
| 16:49:30.723 | 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)) |
| 16:49:30.724 | 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) |
| 16:49:30.724 | 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) |
| 16:49:30.724 | 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) |
| 16:49:30.725 | 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) |
| 16:49:30.725 | 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) |
| 16:49:30.726 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='2222098' WHERE "id"=1 |
| 16:49:30.727 | 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.2.139') |
| 16:49:30.727 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 16:49:30.728 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71 |
| 16:49:30.728 | 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 |
| 16:49:30.729 | 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.2.139') |
| 16:49:30.730 | 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.2.139') |
| 16:49:30.731 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_approve_payment_settles" WHERE "erp_payment_ticket_id"=2069 ORDER BY "id" |
| 16:49:30.732 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" WHERE (purchase_contract_id is not null) AND ("erp_payment_ticket_id"=2069) ORDER BY "id" |
| 16:49:30.733 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:49:30.733 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:49:30.733 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4056 |
| 16:49:30.734 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:49:30.734 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:49:30.735 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4056) AND ("t"."status" IN (2, 5, 1)) |
| 16:49:30.735 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4056) AND ("t"."status" IN (2, 5, 1)) |
| 16:49:30.736 | 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"."purchase_contract_id"=4056) AND ("t"."status" IN (2, 5, 1)) |
| 16:49:30.736 | 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"."purchase_contract_id"=4056) AND ("t"."status" IN (2, 5, 1)) |
| 16:49:30.737 | info | yii\db\Command::query | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4056) AND ("t"."status"=1)) |
| 16:49:30.738 | 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"."purchase_contract_id"=4056) AND ("t"."status"=1)) |
| 16:49:30.738 | 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"."purchase_contract_id"=4056) AND ("t"."status"=1) |
| 16:49:30.739 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contracts" SET "erp_settle_amount"='3', "erp_un_settle_amount"='384643' WHERE "id"=4056 |
| 16:49:30.740 | 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\PurchaseContracts', 4056, 'a:0:{}', '', 1001, '114.254.2.139') |
| 16:49:30.741 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=90 |
| 16:49:30.742 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:49:30.742 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:49:30.742 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id"=4056 |
| 16:49:30.743 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4056 |
| 16:49:30.743 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:49:30.743 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:49:30.743 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4056 |
| 16:49:30.745 | info | yii\db\Command::query | SELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4056) AND ("t"."status" IN (2, 5, 1)) |
| 16:49:30.745 | info | yii\db\Command::query | SELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4056) AND ("t"."status" IN (2, 5, 1)) |
| 16:49:30.746 | info | yii\db\Command::query | SELECT r.amount, t.created_at 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"."purchase_contract_id"=4056) AND ("t"."status" IN (2, 5, 1)) |
| 16:49:30.746 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=4056) AND (amount > paid_amount) ORDER BY "remind_date" |
| 16:49:30.747 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='1' WHERE "id"=792 |
| 16:49:30.748 | 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\PurchaseContractPaymentCollectionRemindDates', 792, 'a:0:{}', '', 1001, '114.254.2.139') |
| 16:49:30.749 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=4056) AND (amount > paid_amount) ORDER BY "remind_date" |
| 16:49:30.750 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='2' WHERE "id"=792 |
| 16:49:30.750 | 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\PurchaseContractPaymentCollectionRemindDates', 792, 'a:1:{s:11:"paid_amount";i:2;}', '', 1001, '114.254.2.139') |
| 16:49:30.752 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=4056) AND (amount > paid_amount) ORDER BY "remind_date" |
| 16:49:30.752 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='3' WHERE "id"=792 |
| 16:49:30.753 | 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\PurchaseContractPaymentCollectionRemindDates', 792, 'a:1:{s:11:"paid_amount";i:3;}', '', 1001, '114.254.2.139') |
| 16:49:30.754 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" WHERE (sales_contract_id is not null) AND ("erp_payment_ticket_id"=2069) ORDER BY "id" |
| 16:49:30.755 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" WHERE (erp_cost_ticket_id is not null) AND ("erp_payment_ticket_id"=2069) ORDER BY "id" |
| 16:49:30.755 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" WHERE (erp_other_payment_ticket_id is not null) AND ("erp_payment_ticket_id"=2069) ORDER BY "id" |
| 16:49:30.755 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" WHERE (erp_advance_payment_ticket_id is not null) AND ("erp_payment_ticket_id"=2069) ORDER BY "id" |
| 16:49:30.756 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" WHERE (erp_other_collect_ticket_id is not null) AND ("erp_payment_ticket_id"=2069) ORDER BY "id" |
| 16:49:30.756 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_tickets" WHERE "id"=2069 |
| 16:49:30.756 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" WHERE "erp_payment_ticket_id"=2069 ORDER BY "id" |
| 16:49:30.757 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 16:49:30.757 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:49:30.757 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:49:30.758 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:49:30.758 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (9, 'status', 2069, 20012, 1001, 'now()', '["\u652f\u4ed8\u5b9d:\uffe51;"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u7ed3\u7b97\u4fe1\u606f","d4":["\u652f\u4ed8\u5b9d:\uffe51;"]}') |
| 16:49:30.759 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" WHERE "erp_payment_ticket_id"=2069 ORDER BY "id" |
| 16:49:30.759 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 16:49:30.759 | 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)) |
| 16:49:30.760 | 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)) |
| 16:49:30.760 | 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)) |
| 16:49:30.761 | 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)) |
| 16:49:30.761 | 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) |
| 16:49:30.762 | 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)) |
| 16:49:30.762 | 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)) |
| 16:49:30.762 | 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) |
| 16:49:30.763 | 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)) |
| 16:49:30.763 | 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) |
| 16:49:30.764 | 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) |
| 16:49:30.764 | 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) |
| 16:49:30.765 | 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) |
| 16:49:30.765 | 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) |
| 16:49:30.765 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='2222098' WHERE "id"=1 |
| 16:49:30.766 | 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.2.139') |
| 16:49:30.767 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 16:49:30.768 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71 |
| 16:49:30.768 | 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 |
| 16:49:30.769 | 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.2.139') |
| 16:49:30.770 | 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.2.139') |
| 16:49:30.771 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:49:30.771 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:49:30.771 | 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-payment-ticket/save-settle', '{"id":"2069","files":["27245"],"erpPaymentTicketBankOuts":[{"amount":"1","id":"1","description":"111"}],"erpPaymentTicketPayments":"","web_access_token":"Hc6bcOPECvJmn-MxoPjAzgccBe0xyT-M"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u7ed3\u7b97\u6210\u529f","error":""}],"mod":0}', FALSE, '2025-08-12 16:49:30') RETURNING "id" |
| 16:49:30.772 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:49:30.772 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |