ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a22407dd4518: POST https://beta.jinchangxiao.com/vue/project/save-edit at 2026-06-05 11:20:29 am by 221.216.117.119

Log Messages

总计249条数据
TimeLevelCategoryMessage
 
11:20:29.869traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
11:20:29.869traceyii\base\Module::getModuleLoading module: debug
11:20:29.869traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
11:20:29.869traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
11:20:29.869traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
11:20:29.869traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.870infotime tracing start1780629629870153984
11:20:29.870traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
11:20:29.870traceyii\web\Application::handleRequestRoute requested: 'vue/project/save-edit'
11:20:29.870traceyii\base\Module::getModuleLoading module: vue
11:20:29.870infoyii\web\Session::openSession started
11:20:29.871infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:20:29.871infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:20:29.872traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.872traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:29.872traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.872traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:29.873infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:20:29.873traceyii\base\Controller::runActionRoute to run: vue/project/save-edit
11:20:29.873traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.874traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
11:20:29.874traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ProjectController::actionSaveEdit()
11:20:29.874infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3957'
11:20:29.875traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.875traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:29.875traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.876traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.878traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'id' in 'app\models\Projects'.
11:20:29.878traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'client_name' in 'app\models\Projects'.
11:20:29.878traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'profit' in 'app\models\Projects'.
11:20:29.878traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'from_contact_name' in 'app\models\Projects'.
11:20:29.878traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'salesForecast' in 'app\models\Projects'.
11:20:29.878traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'purchaseType' in 'app\models\Projects'.
11:20:29.878traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'opportunityFrom' in 'app\models\Projects'.
11:20:29.878traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectArchitects' in 'app\models\Projects'.
11:20:29.878traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectRemindReceivers' in 'app\models\Projects'.
11:20:29.878traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'payment_collection_remind_ahead' in 'app\models\Projects'.
11:20:29.878traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'salesContractPaymentCollectionRemindReceivers' in 'app\models\Projects'.
11:20:29.878traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectProductRels' in 'app\models\Projects'.
11:20:29.878traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectContactPoints' in 'app\models\Projects'.
11:20:29.878traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectContactPointRels' in 'app\models\Projects'.
11:20:29.878traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectUsedClient' in 'app\models\Projects'.
11:20:29.878traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'salesContractPaymentCollectionRemindDates' in 'app\models\Projects'.
11:20:29.879traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectProductTypes' in 'app\models\Projects'.
11:20:29.879infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3957
11:20:29.879infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (1, 128, 142, 184, 189, 349)) ORDER BY "sort"
11:20:29.880traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.880traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:29.880infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='2130') AND ("project_title"='中国人民解放军总参谋部第五十一研究所试制工厂-高性能') AND ("id" != 3957))
11:20:29.894infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1')
11:20:29.894infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2130')
11:20:29.895infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"='2')
11:20:29.895infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='4')
11:20:29.895infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5087)
11:20:29.896infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5087)
11:20:29.896infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3957)
11:20:29.897traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.897traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:29.898traceyii\db\Transaction::beginBegin transaction
11:20:29.898infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:20:29.899infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3957
11:20:29.899traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.900traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:29.900infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3957
11:20:29.900traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.900traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:29.900infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=2
11:20:29.901infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (3957, 2, '服务器', '20000000', 20, '4000000')
11:20:29.905infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3957 ORDER BY "id"
11:20:29.906infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:29.906infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3957 ORDER BY "id"
11:20:29.914infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3957) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:20:29.916traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.916traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:29.917traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.917traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:29.917infoyii\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\Projects', 3957, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:29.922infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130
11:20:29.923traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.923traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:29.923infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:29.923infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3957 ORDER BY "id"
11:20:29.924infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_order_items" WHERE "project_id"=3957
11:20:29.934infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3957) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:20:29.935infoyii\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\Projects', 3957, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:29.936infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130
11:20:29.936infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:29.937infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=3957
11:20:29.938infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=3957
11:20:29.939infoyii\db\Command::execute
11:20:29.940infoyii\db\Command::execute
11:20:29.940infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "client_id"=2130, "project_progress"=2, "budget"='20000000', "profit_pct"='20', "updated_at"='now()', "status_updated_at"='now()', "contract_type"=1, "from_contact"=NULL, "change_status_to"=4 WHERE "id"=3957
11:20:29.943infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3957) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:20:29.945infoyii\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\Projects', 3957, 'a:1:{s:16:"change_status_to";s:1:"4";}', '', 1001, '221.216.117.119')
11:20:29.945infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2130'
11:20:29.946infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:20:29.946infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3957
11:20:29.946traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.947traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:29.947infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3957
11:20:29.947infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_architects" ("project_id", "engineer_id", "contribution", "created_by") VALUES (3957, 1015, '1', 1001)
11:20:29.951infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3957
11:20:29.951infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (1, 128, 142, 184, 189, 349)) ORDER BY "sort"
11:20:29.952infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=128
11:20:29.952infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='128'
11:20:29.952infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3957) AND ("term_id"=9)
11:20:29.952traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.952traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:29.953infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (9, 128, 3957)
11:20:29.959infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=142
11:20:29.959infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='142'
11:20:29.959infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3957) AND ("term_id"=13)
11:20:29.960infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (13, 142, 3957)
11:20:29.960infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3957
11:20:29.960traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.960traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:29.960infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3957
11:20:29.961infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_project_remind_receivers" ("project_id", "user_id") VALUES (3957, 1001) RETURNING "id"
11:20:29.964infoyii\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\ProjectRemindReceivers', 2194, 'a:3:{s:2:"id";i:2194;s:10:"project_id";i:3957;s:7:"user_id";s:4:"1001";}', '', 1001, '221.216.117.119')
11:20:29.965infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3957
11:20:29.967traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.967traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:29.967infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3957 ORDER BY "id")
11:20:29.968infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "amount"='20000000', "contract_type"=1, "save_collection_at"='now()' WHERE "id"=4496
11:20:29.970infoyii\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\SalesContracts', 4496, 'a:1:{s:18:"save_collection_at";s:5:"now()";}', '', 1001, '221.216.117.119')
11:20:29.970infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130
11:20:29.971infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:29.971infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_contract_default_remind_users" WHERE ("user_id"=1001) AND ("type"=1)
11:20:29.972traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.972traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:29.972infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_contract_default_remind_users" ("user_id", "remind_user", "type") VALUES (1001, 1001, 1), (1001, 5087, 1)
11:20:29.975infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4496
11:20:29.975traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.975traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:29.975infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4496
11:20:29.976infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4496, 1001) RETURNING "id"
11:20:29.980infoyii\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\SalesContractPaymentCollectionRemindReceivers', 10163, 'a:3:{s:2:"id";i:10163;s:11:"contract_id";i:4496;s:7:"user_id";s:4:"1001";}', '', 1001, '221.216.117.119')
11:20:29.980infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4496, 5087) RETURNING "id"
11:20:29.980infoyii\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\SalesContractPaymentCollectionRemindReceivers', 10164, 'a:3:{s:2:"id";i:10164;s:11:"contract_id";i:4496;s:7:"user_id";s:4:"5087";}', '', 1001, '221.216.117.119')
11:20:29.981infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4496
11:20:29.981infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4496
11:20:29.981infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4496
11:20:29.982traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:29.982traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:29.982infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4496
11:20:29.982infoyii\db\Command::querySELECT r.amount, t.created_at 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"=4496) AND ("t"."status" IN (2, 5, 1))
11:20:29.983infoyii\db\Command::querySELECT r.amount, t.wrote_date as created_at 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"=4496) AND ("t"."status" IN (2, 5, 1))
11:20:29.984infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:29.984infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4496
11:20:29.985infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3957) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:20:29.987infoyii\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\Projects', 3957, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:29.987infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130
11:20:29.987infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4496) AND (amount > paid_amount) ORDER BY "remind_date"
11:20:29.988infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4496
11:20:29.989infoyii\db\Command::querySELECT 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"=4496) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5))
11:20:29.989infoyii\db\Command::querySELECT 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"=4496) AND ("t"."status" IN (2, 5))
11:20:29.990infoyii\db\Command::querySELECT 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"=4496) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
11:20:29.991infoyii\db\Command::querySELECT 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"=4496) AND ("t"."status"=1))
11:20:29.991infoyii\db\Command::querySELECT 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"=4496) AND ("t"."status"=1))
11:20:29.992infoyii\db\Command::querySELECT 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"=4496) AND ("t"."status"=1))
11:20:29.992infoyii\db\Command::querySELECT 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"=4496) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (1, 2, 5))
11:20:29.994infoyii\db\Command::querySELECT 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"=4496) AND ("t"."status" IN (1, 2, 5))
11:20:29.995infoyii\db\Command::querySELECT 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"=4496) AND ("t"."status" IN (1, 2, 5))
11:20:29.998infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='20000000', "erp_all_settle_amount"='0' WHERE "id"=4496
11:20:30.000infoyii\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\SalesContracts', 4496, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:30.004infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130
11:20:30.009infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:30.010infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:30.011infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=3957
11:20:30.012infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3957) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:20:30.014infoyii\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\Projects', 3957, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:30.015infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130
11:20:30.016infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_status_logs" WHERE "project_id"=3957 ORDER BY "created_at" DESC
11:20:30.019traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:30.019traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:30.019infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4496
11:20:30.020infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4496
11:20:30.020infoyii\db\Command::querySELECT r.amount, t.created_at 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"=4496) AND ("t"."status" IN (2, 5, 1))
11:20:30.021infoyii\db\Command::querySELECT r.amount, t.wrote_date as created_at 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"=4496) AND ("t"."status" IN (2, 5, 1))
11:20:30.022infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:30.022infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4496
11:20:30.024infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3957) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:20:30.026infoyii\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\Projects', 3957, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:30.026infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130
11:20:30.027infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4496) AND (amount > paid_amount) ORDER BY "remind_date"
11:20:30.028infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id"=3957
11:20:30.028traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:30.029traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:30.029infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE 0=1
11:20:30.031infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE 0=1
11:20:30.033infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE 0=1
11:20:30.034infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE 0=1
11:20:30.035infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2130'
11:20:30.036infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_projects" WHERE ("project_status"=3) AND ("bargain_date" >= '2026-01-01 00:00:00') AND ("bargain_date" <= '2026-12-31 23:59:59') AND ("client_id"=2130)
11:20:30.038infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2130) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:20:30.962traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:30.962traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:30.962infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2130, 5087, 'now()', NULL) RETURNING "id"
11:20:30.964infoyii\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\ClientAmChangeLogs', 199918, 'a:5:{s:2:"id";i:199918;s:9:"client_id";i:2130;s:9:"sales_rep";i:5087;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119')
11:20:30.964infoyii\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\Clients', 2130, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:30.971traceyii\redis\Connection::executeCommandExecuting Redis Command: INCR
11:20:30.971traceyii\redis\Connection::executeCommandExecuting Redis Command: HSET
11:20:30.971traceyii\redis\Connection::executeCommandExecuting Redis Command: LPUSH
11:20:30.972traceyii\redis\Connection::executeCommandExecuting Redis Command: INCR
11:20:30.972traceyii\redis\Connection::executeCommandExecuting Redis Command: HSET
11:20:30.972traceyii\redis\Connection::executeCommandExecuting Redis Command: LPUSH
11:20:30.972infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:30.972infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3957)
11:20:30.973infoyii\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\ErpSalesOrders', 1717, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:30.973infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3957
11:20:30.974infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4496 ORDER BY "id" DESC
11:20:30.975infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "is_verify"=TRUE WHERE "id"=3957
11:20:30.976infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3957) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:20:30.977infoyii\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\Projects', 3957, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:30.978infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130
11:20:30.978infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "is_chargeback_verify"=TRUE WHERE "id"=4496
11:20:30.979infoyii\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\SalesContracts', 4496, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:30.979infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130
11:20:30.980infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:30.981traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:30.981traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:30.981infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_verify_rels" SET "status"=3 WHERE ("erp_sales_order_id"=1717) AND ("status"=0)
11:20:30.983infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE "erp_sales_order_id"=1717
11:20:30.984infoyii\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\ErpSalesOrders', 1717, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:30.985traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:30.985traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:30.985infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE "id"=6
11:20:30.990infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE ("id"='1001') AND ("user_status"='1') ORDER BY array_position(array[1001], id)
11:20:30.991traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:30.991traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:30.991infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" ("erp_sales_order_id", "user_id", "status") VALUES (1717, 1001, 0)
11:20:30.995infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("erp_sales_order_id"=1717) AND ("status"=0) ORDER BY "id"
11:20:30.996infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "status"=7, "next_cancel_verify_user"=1001, "updated_at"='now()' WHERE "id"=1717
11:20:30.996infoyii\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\ErpSalesOrders', 1717, 'a:2:{s:6:"status";i:7;s:23:"next_cancel_verify_user";i:1001;}', '', 1001, '221.216.117.119')
11:20:30.996infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
11:20:30.997infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=1717) ORDER BY "id"
11:20:30.997infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=1717) ORDER BY "id"
11:20:30.998infoyii\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\ErpSalesOrders', 1717, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:30.998infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:20:30.998infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:20:30.999traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:30.999traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:30.999infoyii\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 (15, 'status', 1717, 20007, 1001, 'now()', '["\u5218\u4eba\u8bda"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u9000\u5355\u4e86","d3":"\u9500\u552e\u8ba2\u5355\u7533\u8bf7","d4":""}')
11:20:31.003traceyii\db\Transaction::commitCommit transaction
11:20:31.004traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:31.004traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:20:31.004infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/project/save-edit', '{"Projects":{"id":"3957","client_name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","client_id":"2130","project_status":"4","project_progress":"2","profit":"4000000","profit_pct":"20","bargain_date":"2026-06-05","project_title":"\u4e2d\u56fd\u4eba\u6c11\u89e3\u653e\u519b\u603b\u53c2\u8c0b\u90e8\u7b2c\u4e94\u5341\u4e00\u7814\u7a76\u6240\u8bd5\u5236\u5de5\u5382-\u9ad8\u6027\u80fd","from_contact_name":"","from_contact":"","salesForecast":"142","purchaseType":"128","opportunityFrom":"","contract_type":"1","projectArchitects":{"1015":"1"},"comment":"\u9884\u7b972000\u4e07","projectRemindReceivers":["1001"],"payment_collection_remind_ahead":"1 day","project_product_version_id":"","salesContractPaymentCollectionRemindReceivers":["1001","5087"],"projectProductRels":"","projectContactPoints":"","projectContactPointRels":"","projectUsedClient":{"used_client":"","budget":"","profit":"","profit_pct":"","projectUsedClientPaymentCollectionRemindReceivers":"","projectUsedClientPaymentCollectionRemindDates":"","remind_ahead":"","projectUsedClientPayments":"","projectUsedClientInvoices":""},"salesContractPaymentCollectionRemindDates":"","projectProductTypes":{"2":{"budget":"20000000","profit":"4000000","pct":"20"}}},"web_access_token":"l4p3M_87vSdo8QF-blMLH4iPaepKw7vp"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u5546\u673a\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-05 11:20:31', 1134237952) RETURNING "id"
11:20:31.005traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:20:31.005traceyii\redis\Connection::executeCommandExecuting Redis Command: SET