ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c7c7ed843ad: POST https://beta.jinchangxiao.com/vue/erp-advance-payment-ticket/save-edit at 2025-09-15 04:01:49 pm by 114.246.237.213

Log Messages

总计199条数据
TimeLevelCategoryMessage
 
16:01:49.541traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
16:01:49.541traceyii\base\Module::getModuleLoading module: debug
16:01:49.541traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
16:01:49.541traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
16:01:49.541traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
16:01:49.541traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.542traceyii\base\Module::getModuleLoading module: gii
16:01:49.542traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
16:01:49.542traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
16:01:49.542traceyii\web\Application::handleRequestRoute requested: 'vue/erp-advance-payment-ticket/save-edit'
16:01:49.542traceyii\base\Module::getModuleLoading module: vue
16:01:49.542infoyii\web\Session::openSession started
16:01:49.543infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:01:49.543infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:01:49.547traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.547traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:01:49.547traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.548traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:01:49.548infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:01:49.549traceyii\base\Controller::runActionRoute to run: vue/erp-advance-payment-ticket/save-edit
16:01:49.550traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.551traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
16:01:49.551traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ErpAdvancePaymentTicketController::actionSaveEdit()
16:01:49.551infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"='2'
16:01:49.551traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.552traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:01:49.552infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_verify_rels" WHERE ("status" != 0) AND ("erp_advance_payment_ticket_id"=2) ORDER BY "id"
16:01:49.553traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: updateErpAdvancePaymentTicket
16:01:49.553traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
16:01:49.553traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'id' in 'app\models\ErpAdvancePaymentTickets'.
16:01:49.553traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'auto_id' in 'app\models\ErpAdvancePaymentTickets'.
16:01:49.553traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'auto_name' in 'app\models\ErpAdvancePaymentTickets'.
16:01:49.553traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'auto_type' in 'app\models\ErpAdvancePaymentTickets'.
16:01:49.553traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'files' in 'app\models\ErpAdvancePaymentTickets'.
16:01:49.553traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'attachmentFile' in 'app\models\ErpAdvancePaymentTickets'.
16:01:49.553traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'client_name' in 'app\models\ErpAdvancePaymentTickets'.
16:01:49.553traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'supplier_name' in 'app\models\ErpAdvancePaymentTickets'.
16:01:49.553traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'erpAdvancePaymentTicketVerifyRels' in 'app\models\ErpAdvancePaymentTickets'.
16:01:49.553traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'erpAdvancePaymentTicketBankOuts' in 'app\models\ErpAdvancePaymentTickets'.
16:01:49.553traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'erpAdvancePaymentTicketApprovePaymentSettles' in 'app\models\ErpAdvancePaymentTickets'.
16:01:49.553infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "serial_no"='YFKD-20250915-00001' LIMIT 2
16:01:49.554infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2133')
16:01:49.555infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1001')
16:01:49.555infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
16:01:49.556infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:01:49.556infoyii\db\Command::execute
16:01:49.556infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "handler"=1001, "client_id"=2133, "supplier_id"=NULL WHERE "id"=2
16:01:49.558traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.558traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:01:49.558infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213')
16:01:49.559infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20033) AND ("object_id"=2)
16:01:49.561traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.561traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:01:49.561infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20033) AND ("object_id"=2)
16:01:49.564infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (20033, 2, 28158)
16:01:49.565infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_verify_rels" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id"
16:01:49.565traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.565traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:01:49.565infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:01:49.566infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:01:49.566traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.566traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:01:49.567infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'erpAdvancePaymentTicketVerifyRels', 2, 20019, 1001, 'now()', '[[]]', '[["\u5218\u4eba\u8bda"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5ba1\u6279\u4eba","d4":["\u5218\u4eba\u8bda; <b>\u53d8\u4e3a<\/b> (\u672a\u8bbe\u7f6e)"]}')
16:01:49.568infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_verify_rels" WHERE "erp_advance_payment_ticket_id"=2
16:01:49.569infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_carbon_copy_rels" WHERE "erp_advance_payment_ticket_id"=2
16:01:49.569infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_carbon_copy_rels" WHERE "erp_advance_payment_ticket_id"=2
16:01:49.570infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id"
16:01:49.570traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.570traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:01:49.570traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.570traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:01:49.570infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
16:01:49.571infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"='1'
16:01:49.571infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" WHERE "erp_advance_payment_ticket_id"=2
16:01:49.572infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" ("erp_advance_payment_ticket_id", "erp_bank_id", "amount", "description") VALUES (2, 1, '22.97', '')
16:01:49.573infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_approve_payment_settles" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id"
16:01:49.573infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_approve_payment_settles" WHERE "erp_advance_payment_ticket_id"=2
16:01:49.574infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "amount"='22.97' WHERE "id"=2
16:01:49.574infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213')
16:01:49.575infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_verify_rels" WHERE ("erp_advance_payment_ticket_id"=2) AND ("status"=0) ORDER BY "id"
16:01:49.576infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "next_verify_user"=NULL, "updated_at"='now()' WHERE "id"=2
16:01:49.577infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213')
16:01:49.578infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2
16:01:49.578infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_approve_payment_settles" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id"
16:01:49.578infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id"
16:01:49.578infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
16:01:49.579infoyii\db\Command::querySELECT 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:01:49.580infoyii\db\Command::querySELECT 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:01:49.581infoyii\db\Command::querySELECT 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:01:49.581infoyii\db\Command::querySELECT 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)
16:01:49.584infoyii\db\Command::querySELECT 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:01:49.584infoyii\db\Command::querySELECT 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:01:49.585infoyii\db\Command::querySELECT 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:01:49.586infoyii\db\Command::querySELECT 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:01:49.587infoyii\db\Command::querySELECT 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:01:49.588infoyii\db\Command::querySELECT 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:01:49.589infoyii\db\Command::querySELECT 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:01:49.589infoyii\db\Command::querySELECT 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:01:49.590infoyii\db\Command::querySELECT 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:01:49.591infoyii\db\Command::querySELECT 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))
16:01:49.592infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='115322.97' WHERE "id"=1
16:01:49.593infoyii\db\Command::executeINSERT 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.246.237.213')
16:01:49.593infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
16:01:49.594infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71
16:01:49.594traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.595traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:01:49.595infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_account_captions" SET "created_at"='2025-08-01 23:14:45', "updated_at"='2025-08-08 18:50:15' WHERE "id"=71
16:01:49.596infoyii\db\Command::executeINSERT 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.246.237.213')
16:01:49.596infoyii\db\Command::executeINSERT 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.246.237.213')
16:01:49.597infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2
16:01:49.598infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "settle_amount"='0' WHERE "id"=2
16:01:49.599infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213')
16:01:49.599infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2
16:01:49.600infoyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("r"."erp_advance_payment_ticket_id"=2) AND ("t"."status" IN (2, 5))
16:01:49.600infoyii\db\Command::querySELECT 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_advance_payment_ticket_id"=2) AND ("t"."status" IN (2, 5))
16:01:49.601infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "paid_amount"='0', "un_paid_amount"='22.97' WHERE "id"=2
16:01:49.602infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213')
16:01:49.603infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:01:49.603infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_verify_rels" WHERE ("status"=0) AND ("erp_advance_payment_ticket_id"=2) ORDER BY "id"
16:01:49.604infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "status"=2, "verify_at"='now()', "updated_at"='now()' WHERE "id"=2
16:01:49.604infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpAdvancePaymentTickets', 2, 'a:2:{s:6:"status";i:1;s:9:"verify_at";s:5:"now()";}', '', 1001, '114.246.237.213')
16:01:49.605infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_approve_payment_settles" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id"
16:01:49.606infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id"
16:01:49.606infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
16:01:49.606infoyii\db\Command::querySELECT 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:01:49.607infoyii\db\Command::querySELECT 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:01:49.607infoyii\db\Command::querySELECT 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:01:49.607infoyii\db\Command::querySELECT 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)
16:01:49.610infoyii\db\Command::querySELECT 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:01:49.610infoyii\db\Command::querySELECT 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:01:49.610infoyii\db\Command::querySELECT 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:01:49.611infoyii\db\Command::querySELECT 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:01:49.611infoyii\db\Command::querySELECT 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:01:49.612infoyii\db\Command::querySELECT 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:01:49.612infoyii\db\Command::querySELECT 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:01:49.613infoyii\db\Command::querySELECT 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:01:49.613infoyii\db\Command::querySELECT 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:01:49.614infoyii\db\Command::querySELECT 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))
16:01:49.614infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='115322.97' WHERE "id"=1
16:01:49.615infoyii\db\Command::executeINSERT 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.246.237.213')
16:01:49.616infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
16:01:49.616infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71
16:01:49.616infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_account_captions" SET "created_at"='2025-08-01 23:14:45', "updated_at"='2025-08-08 18:50:15' WHERE "id"=71
16:01:49.617infoyii\db\Command::executeINSERT 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.246.237.213')
16:01:49.618infoyii\db\Command::executeINSERT 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.246.237.213')
16:01:49.619infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2
16:01:49.619infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "settle_amount"='0' WHERE "id"=2
16:01:49.620infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213')
16:01:49.621infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2
16:01:49.621infoyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("r"."erp_advance_payment_ticket_id"=2) AND ("t"."status" IN (2, 5))
16:01:49.622infoyii\db\Command::querySELECT 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_advance_payment_ticket_id"=2) AND ("t"."status" IN (2, 5))
16:01:49.622infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "paid_amount"='0', "un_paid_amount"='22.97' WHERE "id"=2
16:01:49.623infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213')
16:01:49.624infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2
16:01:49.624infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:01:49.625infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_carbon_copy_rels" WHERE "erp_advance_payment_ticket_id"=2
16:01:49.625infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_verify_rels" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id"
16:01:49.625infoyii\db\Command::querySELECT "user_id" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "item_name"='Treasurer'
16:01:49.626traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.626traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:01:49.626traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.626traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.627traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.627traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:01:49.627infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2
16:01:49.628infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
16:01:49.628infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '20019', 2, '刘人诚通过了这个审批', TRUE, 'YFKD-20250915-00001') RETURNING "id"
16:01:49.629infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 191363, 'a:11:{s:2:"id";i:191363;s:9:"object_id";i:2;s:11:"object_type";s:5:"20019";s:6:"parent";N;s:11:"description";s:30:"刘人诚通过了这个审批";s:10:"created_by";i:1001;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:19:"YFKD-20250915-00001";}', '', 1001, '114.246.237.213')
16:01:49.630traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.630traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:01:49.630infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (2, '20019', 191363, 1013), (2, '20019', 191363, 5388)
16:01:49.632infoyii\db\Command::querySELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id" IN (1013, 5388)) AND ("id" != 1001) AND (channel_id IS NOT NULL)
16:01:49.632infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:01:49.633traceyii\redis\Connection::executeCommandExecuting Redis Command: INCR
16:01:49.633traceyii\redis\Connection::executeCommandExecuting Redis Command: HSET
16:01:49.633traceyii\redis\Connection::executeCommandExecuting Redis Command: LPUSH
16:01:49.633infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2133
16:01:49.634traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.634traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:01:49.634traceyii\redis\Connection::executeCommandExecuting Redis Command: INCR
16:01:49.634traceyii\redis\Connection::executeCommandExecuting Redis Command: HSET
16:01:49.634traceyii\redis\Connection::executeCommandExecuting Redis Command: LPUSH
16:01:49.634infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2
16:01:49.635traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.635traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:01:49.635infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_ticket_change_logs" ("status", "ticket_type", "serial_no", "wrote_date", "description", "abstract", "amount", "client_id", "supplier_id", "contact_id", "user_id", "created_by", "created_at", "updated_at", "object_id", "verify_at") VALUES (2, 20019, 'YFKD-20250915-00001', '2025-09-15', '三分大赛', 'f史蒂夫', '22.97', 2133, NULL, NULL, NULL, 1001, '2025-09-15 16:00:55', '2025-09-15 16:01:49', 2, '2025-09-15 16:01:49.604228+08') RETURNING "id"
16:01:49.638infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpTicketChangeLogs', 534, 'a:17:{s:2:"id";i:534;s:9:"serial_no";s:19:"YFKD-20250915-00001";s:11:"ticket_type";i:20019;s:10:"wrote_date";s:10:"2025-09-15";s:6:"status";i:2;s:11:"supplier_id";N;s:9:"client_id";i:2133;s:8:"abstract";s:10:"f史蒂夫";s:11:"description";s:12:"三分大赛";s:9:"verify_at";s:29:"2025-09-15 16:01:49.604228+08";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-09-15 16:00:55";s:10:"updated_at";s:19:"2025-09-15 16:01:49";s:10:"contact_id";N;s:7:"user_id";N;s:6:"amount";s:5:"22.97";s:9:"object_id";i:2;}', '', 1001, '114.246.237.213')
16:01:49.639traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.639traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:01:49.639infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_ticket_change_log_handlers" ("erp_ticket_change_log_id", "user_id") VALUES (534, 1001)
16:01:49.643traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.643traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:01:49.643infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-09-15')
16:01:49.647traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.647traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:01:49.647infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=1438, "last_visit_at"='now()' WHERE "id"=56557
16:01:49.648infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-advance-payment-ticket/save-edit', '{"ErpAdvancePaymentTickets":{"id":"2","auto_id":"2133","auto_name":"\u5317\u4eac\u5e02\u4e2d\u4fdd\u7f51\u76fe\u79d1\u6280\u6709\u9650\u516c\u53f8","auto_type":"client","handler":"1001","from_date":"2025-09-15","serial_no":"YFKD-20250915-00001","abstract":"f\u53f2\u8482\u592b","files":["28158"],"attachmentFile":{"28158":"\u56fe\u7247.png"},"description":"\u4e09\u5206\u5927\u8d5b","client_id":"2133","client_name":"\u5317\u4eac\u5e02\u4e2d\u4fdd\u7f51\u76fe\u79d1\u6280\u6709\u9650\u516c\u53f8","supplier_id":"","supplier_name":"","erpAdvancePaymentTicketVerifyRels":"","erpAdvancePaymentTicketBankOuts":[{"amount":"22.97","id":"1","description":""}],"erpAdvancePaymentTicketApprovePaymentSettles":""},"web_access_token":"S7OJrULURAq348jTGnVvRiAMpe10N7Zn"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u9884\u4ed8\u6b3e\u5355\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-09-15 16:01:49') RETURNING "id"
16:01:49.649traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:01:49.649traceyii\redis\Connection::executeCommandExecuting Redis Command: SET