ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
689996f155986: POST https://beta.jinchangxiao.com/vue/project/save-edit at 2025-08-11 03:08:33 pm by 124.64.23.198

Log Messages

总计452条数据
TimeLevelCategoryMessage
 
15:08:33.350traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
15:08:33.350traceyii\base\Module::getModuleLoading module: debug
15:08:33.350traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
15:08:33.350traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
15:08:33.350traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
15:08:33.350traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.351traceyii\base\Module::getModuleLoading module: gii
15:08:33.351traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
15:08:33.351traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
15:08:33.351traceyii\web\Application::handleRequestRoute requested: 'vue/project/save-edit'
15:08:33.351traceyii\base\Module::getModuleLoading module: vue
15:08:33.351infoyii\web\Session::openSession started
15:08:33.352infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5252
15:08:33.352infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:08:33.356traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.356traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.357infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:08:33.357traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.358traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.358infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.360traceyii\base\Controller::runActionRoute to run: vue/project/save-edit
15:08:33.360traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.361traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:08:33.361traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ProjectController::actionSaveEdit()
15:08:33.361infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3880'
15:08:33.362traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.362traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.362traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.363traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.363traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'id' in 'app\models\Projects'.
15:08:33.363traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'payment_collection_remind_ahead' in 'app\models\Projects'.
15:08:33.363traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'salesContractPaymentCollectionRemindReceivers' in 'app\models\Projects'.
15:08:33.363traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'salesContractPaymentCollectionRemindDates' in 'app\models\Projects'.
15:08:33.363traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'client_name' in 'app\models\Projects'.
15:08:33.363traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'profit' in 'app\models\Projects'.
15:08:33.363traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'from_contact_name' in 'app\models\Projects'.
15:08:33.363traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'salesForecast' in 'app\models\Projects'.
15:08:33.363traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'purchaseType' in 'app\models\Projects'.
15:08:33.363traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'opportunityFrom' in 'app\models\Projects'.
15:08:33.363traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectRemindReceivers' in 'app\models\Projects'.
15:08:33.363traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectProductRels' in 'app\models\Projects'.
15:08:33.363traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectContactPoints' in 'app\models\Projects'.
15:08:33.363traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectContactPointRels' in 'app\models\Projects'.
15:08:33.363traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectUsedClient' in 'app\models\Projects'.
15:08:33.363traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectProductTypes' in 'app\models\Projects'.
15:08:33.363traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectArchitects' in 'app\models\Projects'.
15:08:33.364infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3880
15:08:33.365infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (5, 128, 308, 310, 375)) ORDER BY "sort"
15:08:33.369infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='2747') AND ("project_title"='“两地三中心”灾备平台规划设计') AND ("id" != 3880))
15:08:33.371infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1')
15:08:33.371infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2747')
15:08:33.372infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"='2')
15:08:33.372infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='3')
15:08:33.373infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5449)
15:08:33.373infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3880)
15:08:33.374infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3880
15:08:33.375traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.375traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.375traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.375traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.375infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5
15:08:33.376infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
15:08:33.376infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5
15:08:33.376infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.377traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.377traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.377infoyii\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, 'projectProductTypes', 3880, 1, 1001, 'now()', '[["\u5b89\u5168\u8bbe\u5907:543534\u5143 100%","\u7f51\u7edc\u8bbe\u5907 :54454\u5143 99.99%"]]', '[["\u5b89\u5168\u8bbe\u5907:543534\u5143 100%"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u91d1\u989d","d4":["\u5b89\u5168\u8bbe\u5907:543534\u5143 100%; <b>\u53d8\u4e3a<\/b> \u5b89\u5168\u8bbe\u5907:543534\u5143 100%;\u7f51\u7edc\u8bbe\u5907 :54454\u5143 99.99%;"]}')
15:08:33.378infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2747'
15:08:33.379traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.379traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.379infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.380traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.380traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.380infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'projectProductTypes', 3880, 1, 1001, 'now()', '[["\u5b89\u5168\u8bbe\u5907:543534\u5143 100%","\u7f51\u7edc\u8bbe\u5907 :54454\u5143 99.99%"]]', '[["\u5b89\u5168\u8bbe\u5907:543534\u5143 100%"]]', array[5449], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u91d1\u989d","d4":["\u5b89\u5168\u8bbe\u5907:543534\u5143 100%; <b>\u53d8\u4e3a<\/b> \u5b89\u5168\u8bbe\u5907:543534\u5143 100%;\u7f51\u7edc\u8bbe\u5907 :54454\u5143 99.99%;"]}')
15:08:33.381infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3880
15:08:33.382infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3880
15:08:33.384infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5
15:08:33.384infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
15:08:33.384infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (3880, 5, '安全设备', '543534', 100, '543534'), (3880, 4, '网络设备 ', '54454', 99.99, '54453')
15:08:33.386infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3880
15:08:33.386traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.386traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.386traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.387traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.387infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=947
15:08:33.387infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=8
15:08:33.388traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.388traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.388infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2067
15:08:33.388infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2
15:08:33.388infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='947'
15:08:33.389infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=8
15:08:33.389infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2067'
15:08:33.389infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2
15:08:33.390infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.390infoyii\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, 'projectProducts', 3880, 1, 1001, 'now()', '[["PAN-SVC-BKLN-3260:\u5408\u540c\u5355\u4ef7 543534.00\u5143 \u6570\u91cf 1\u5e74 \u6210\u672c\u5355\u4ef7 0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6V13.0(\u9002\u7528\u4e8eAC-1000-B1100-4D):\u5408\u540c\u5355\u4ef7 54454.00\u5143 \u6570\u91cf 1\u5957 \u6210\u672c\u5355\u4ef7 1.00\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '[["PAN-SVC-BKLN-3260:\u5408\u540c\u5355\u4ef7 543534.00\u5143 \u6570\u91cf 1\u5e74 \u6210\u672c\u5355\u4ef7 0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6V13.0(\u9002\u7528\u4e8eAC-1000-B1100-4D):\u5408\u540c\u5355\u4ef7 54454.00\u5143 \u6570\u91cf 1\u5957 \u6210\u672c\u5355\u4ef7 -\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u6e05\u5355","d4":["PAN-SVC-BKLN-3260:\u5408\u540c\u5355\u4ef7 543534.00\u5143 \u6570\u91cf 1\u5e74 \u6210\u672c\u5355\u4ef7 0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6V13.0(\u9002\u7528\u4e8eAC-1000-B1100-4D):\u5408\u540c\u5355\u4ef7 54454.00\u5143 \u6570\u91cf 1\u5957 \u6210\u672c\u5355\u4ef7 -\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -; <b>\u53d8\u4e3a<\/b> PAN-SVC-BKLN-3260:\u5408\u540c\u5355\u4ef7 543534.00\u5143 \u6570\u91cf 1\u5e74 \u6210\u672c\u5355\u4ef7 0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6V13.0(\u9002\u7528\u4e8eAC-1000-B1100-4D):\u5408\u540c\u5355\u4ef7 54454.00\u5143 \u6570\u91cf 1\u5957 \u6210\u672c\u5355\u4ef7 1.00\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;"]}')
15:08:33.391infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.392infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'projectProducts', 3880, 1, 1001, 'now()', '[["PAN-SVC-BKLN-3260:\u5408\u540c\u5355\u4ef7 543534.00\u5143 \u6570\u91cf 1\u5e74 \u6210\u672c\u5355\u4ef7 0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6V13.0(\u9002\u7528\u4e8eAC-1000-B1100-4D):\u5408\u540c\u5355\u4ef7 54454.00\u5143 \u6570\u91cf 1\u5957 \u6210\u672c\u5355\u4ef7 1.00\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '[["PAN-SVC-BKLN-3260:\u5408\u540c\u5355\u4ef7 543534.00\u5143 \u6570\u91cf 1\u5e74 \u6210\u672c\u5355\u4ef7 0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6V13.0(\u9002\u7528\u4e8eAC-1000-B1100-4D):\u5408\u540c\u5355\u4ef7 54454.00\u5143 \u6570\u91cf 1\u5957 \u6210\u672c\u5355\u4ef7 -\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', array[5449], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u6e05\u5355","d4":["PAN-SVC-BKLN-3260:\u5408\u540c\u5355\u4ef7 543534.00\u5143 \u6570\u91cf 1\u5e74 \u6210\u672c\u5355\u4ef7 0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6V13.0(\u9002\u7528\u4e8eAC-1000-B1100-4D):\u5408\u540c\u5355\u4ef7 54454.00\u5143 \u6570\u91cf 1\u5957 \u6210\u672c\u5355\u4ef7 -\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -; <b>\u53d8\u4e3a<\/b> PAN-SVC-BKLN-3260:\u5408\u540c\u5355\u4ef7 543534.00\u5143 \u6570\u91cf 1\u5e74 \u6210\u672c\u5355\u4ef7 0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6V13.0(\u9002\u7528\u4e8eAC-1000-B1100-4D):\u5408\u540c\u5355\u4ef7 54454.00\u5143 \u6570\u91cf 1\u5957 \u6210\u672c\u5355\u4ef7 1.00\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;"]}')
15:08:33.393infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3880
15:08:33.393infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=10587
15:08:33.393infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=947, "number"=1, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=10587
15:08:33.394traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.394traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.395infoyii\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\ProjectProductRels', 10587, 'a:0:{}', '', 1001, '124.64.23.198')
15:08:33.396infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=10588
15:08:33.396infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2067, "number"=1, "cost"='1.00', "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL, "total_cost"='1' WHERE "id"=10588
15:08:33.397infoyii\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\ProjectProductRels', 10588, 'a:1:{s:4:"cost";s:4:"1.00";}', '', 1001, '124.64.23.198')
15:08:33.398infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_rels" WHERE 0=1
15:08:33.398infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3880
15:08:33.398infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3880
15:08:33.399traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.399traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.399infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_project_product_versions" ("project_id", "created_by", "created_at") VALUES (3880, 1001, '2025-08-11 15:08:33') RETURNING "id"
15:08:33.400infoyii\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\ProjectProductVersions', 973, 'a:4:{s:2:"id";i:973;s:10:"project_id";i:3880;s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-08-11 15:08:33";}', '', 1001, '124.64.23.198')
15:08:33.401infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.402infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 3880, 1, 973, 112, 1001, '[973]', '[973]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2025-08-11 15:08\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}') RETURNING "id"
15:08:33.403infoyii\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\ObjectChangeLogs', 552163, 'a:13:{s:2:"id";i:552163;s:9:"object_id";i:3880;s:11:"object_type";i:1;s:9:"target_id";i:973;s:18:"target_object_type";i:112;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:5:"[973]";s:9:"new_value";s:5:"[973]";s:11:"description";s:183:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2025-08-11 15:08\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '124.64.23.198')
15:08:33.403infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3880
15:08:33.405infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "project_product_version_id"=973 WHERE "id"=3880
15:08:33.407infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3880) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
15:08:33.408traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.408traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.408infoyii\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', 3880, 'a:1:{s:26:"project_product_version_id";i:973;}', '', 1001, '124.64.23.198')
15:08:33.409infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2747
15:08:33.410traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.410traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.410infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_product_version_rels" ("project_product_version_id", "product_id", "amount", "cost", "number", "total_amount", "total_cost", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (973, 947, '543534.00', '0', 1, '543534', '0', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (973, 2067, '54454.00', '1.00', 1, '54454', '1', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
15:08:33.412infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3880
15:08:33.412infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3880
15:08:33.412infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_order_items" WHERE "project_id"=3880
15:08:33.416infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3880) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
15:08:33.417infoyii\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', 3880, 'a:0:{}', '', 1001, '124.64.23.198')
15:08:33.418infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2747
15:08:33.419infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3880
15:08:33.419infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=3880
15:08:33.420infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=3880
15:08:33.420infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=3880
15:08:33.420infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=3880
15:08:33.420infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE 0=1
15:08:33.421infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.421traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.421infoyii\db\Command::querySELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_contract_types' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
15:08:33.426infoyii\db\Command::queryselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_contract_types' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
15:08:33.437traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.438traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
15:08:33.438infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1'
15:08:33.438infoyii\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, 'bargain_date', 3880, 1, 1001, 'now()', '["2025-08-11"]', '["2025-12-31"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6210\u4ea4\u65e5\u671f","d4":["2025-12-31 <b>\u53d8\u4e3a<\/b> 2025-08-11"]}'), (2, 'contract_type', 3880, 1, 1001, 'now()', '["\u4ea7\u54c1\u9500\u552e"]', '[null]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c\u7c7b\u578b","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> \u4ea7\u54c1\u9500\u552e"]}')
15:08:33.439infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.440infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1'
15:08:33.440infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'bargain_date', 3880, 1, 1001, 'now()', '["2025-08-11"]', '["2025-12-31"]', array[5449], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6210\u4ea4\u65e5\u671f","d4":["2025-12-31 <b>\u53d8\u4e3a<\/b> 2025-08-11"]}'), (2, 'contract_type', 3880, 1, 1001, 'now()', '["\u4ea7\u54c1\u9500\u552e"]', '[null]', array[5449], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c\u7c7b\u578b","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> \u4ea7\u54c1\u9500\u552e"]}')
15:08:33.442infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "client_id"=2747, "project_progress"=2, "budget"='597988', "profit_pct"='100', "bargain_date"='2025-08-11', "updated_at"='now()', "status_updated_at"='now()', "contract_type"=1, "forecast_updated_at"='now()', "from_contact"=NULL, "project_product_version_id"=973, "change_status_to"=3 WHERE "id"=3880
15:08:33.443infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3880) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
15:08:33.444infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_change_logs" SET "end_at"='now()' WHERE "id"=16669
15:08:33.445infoyii\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\ProjectChangeLogs', 16669, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '124.64.23.198')
15:08:33.446infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_project_change_logs" ("project_id", "project_status", "budget", "profit_pct", "collected", "start_from", "end_at") VALUES (3880, 1, '597988', '100', '0', 'now()', NULL) RETURNING "id"
15:08:33.447infoyii\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\ProjectChangeLogs', 16670, 'a:8:{s:2:"id";i:16670;s:10:"project_id";i:3880;s:14:"project_status";i:1;s:6:"budget";i:597988;s:10:"profit_pct";d:100;s:9:"collected";s:1:"0";s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '124.64.23.198')
15:08:33.448infoyii\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', 3880, 'a:4:{s:6:"budget";i:597988;s:12:"bargain_date";s:10:"2025-08-11";s:26:"project_product_version_id";i:973;s:16:"change_status_to";i:3;}', '', 1001, '124.64.23.198')
15:08:33.449infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2747'
15:08:33.449infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.450infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3880
15:08:33.450infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3880
15:08:33.451infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3880
15:08:33.451infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (5, 128, 308, 310, 375)) ORDER BY "sort"
15:08:33.451traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.451traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.451infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=128
15:08:33.452infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='128'
15:08:33.452infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3880) AND ("term_id"=9)
15:08:33.453traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.453traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.453infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (9, 128, 3880)
15:08:33.454infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='181'
15:08:33.454infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.455infoyii\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, 'salesForecast', 3880, 1, 1001, 'now()', '["\u6211\u81ea\u5df1\u505a\u5e84"]', '[""]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9500\u552e\u9884\u6d4b","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> \u6211\u81ea\u5df1\u505a\u5e84"]}')
15:08:33.456infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.456infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'salesForecast', 3880, 1, 1001, 'now()', '["\u6211\u81ea\u5df1\u505a\u5e84"]', '[""]', array[5449], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9500\u552e\u9884\u6d4b","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> \u6211\u81ea\u5df1\u505a\u5e84"]}')
15:08:33.457infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3880) AND ("term_id"=13)
15:08:33.457infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (13, 181, 3880)
15:08:33.458infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3880
15:08:33.459traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.459traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.459infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3880
15:08:33.459infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_project_remind_receivers" ("project_id", "user_id") VALUES (3880, 1005) RETURNING "id"
15:08:33.461infoyii\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', 1704, 'a:3:{s:2:"id";i:1704;s:10:"project_id";i:3880;s:7:"user_id";s:4:"1005";}', '', 1001, '124.64.23.198')
15:08:33.461infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3880
15:08:33.462infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id"=3880
15:08:33.463traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.463traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.463infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_used_clients" SET "used_client"=NULL, "budget"=NULL, "profit"=NULL, "profit_pct"=NULL WHERE "id"=127
15:08:33.464infoyii\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\ProjectUsedClients', 127, 'a:0:{}', '', 1001, '124.64.23.198')
15:08:33.465infoyii\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\ProjectUsedClients', 127, 'a:0:{}', '', 1001, '124.64.23.198')
15:08:33.465infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id"=127
15:08:33.466infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id"=127
15:08:33.466infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id"=127
15:08:33.466infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id"=127
15:08:33.467infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id"=127
15:08:33.467infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id"=127
15:08:33.467infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE 0=1
15:08:33.467infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "id"=127
15:08:33.468traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.468traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.468infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_used_client_payments" SET "paid_amount"='0' WHERE "project_used_client_id"=127
15:08:33.468traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.468traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.468infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "project_used_client_id"=127
15:08:33.468infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id"=127
15:08:33.469infoyii\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\ProjectUsedClients', 127, 'a:0:{}', '', 1001, '124.64.23.198')
15:08:33.470infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE ("project_used_client_id"=127) AND (amount > paid_amount) ORDER BY "collected_date", "created_at"
15:08:33.470infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id"=127
15:08:33.471infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id"=127
15:08:33.471infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE 0=1
15:08:33.471infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2747'
15:08:33.472infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=2747
15:08:33.474infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2747) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
15:08:33.485traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.485traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.485infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2747, 5449, 'now()', NULL) RETURNING "id"
15:08:33.486infoyii\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', 177479, 'a:5:{s:2:"id";i:177479;s:9:"client_id";i:2747;s:9:"sales_rep";i:5449;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '124.64.23.198')
15:08:33.487infoyii\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', 2747, 'a:0:{}', '', 1001, '124.64.23.198')
15:08:33.488infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.489infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 2747, 10, 3880, 1, 1001, '[3880]', '[3880]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u201c\u4e24\u5730\u4e09\u4e2d\u5fc3\u201d\u707e\u5907\u5e73\u53f0\u89c4\u5212\u8bbe\u8ba1"]}') RETURNING "id"
15:08:33.489infoyii\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\ObjectChangeLogs', 552167, 'a:13:{s:2:"id";i:552167;s:9:"object_id";s:4:"2747";s:11:"object_type";i:10;s:9:"target_id";i:3880;s:18:"target_object_type";i:1;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[3880]";s:9:"new_value";s:6:"[3880]";s:11:"description";s:173:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u201c\u4e24\u5730\u4e09\u4e2d\u5fc3\u201d\u707e\u5907\u5e73\u53f0\u89c4\u5212\u8bbe\u8ba1"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '124.64.23.198')
15:08:33.490infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2747'
15:08:33.491infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_projects" WHERE ("project_status"=3) AND ("bargain_date" >= '2025-01-01 00:00:00') AND ("bargain_date" <= '2025-12-31 23:59:59') AND ("client_id"=2747)
15:08:33.492infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2747) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
15:08:33.501infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2747, 5449, 'now()', NULL) RETURNING "id"
15:08:33.502infoyii\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', 177480, 'a:5:{s:2:"id";i:177480;s:9:"client_id";i:2747;s:9:"sales_rep";i:5449;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '124.64.23.198')
15:08:33.503infoyii\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', 2747, 'a:0:{}', '', 1001, '124.64.23.198')
15:08:33.504traceyii\redis\Connection::executeCommandExecuting Redis Command: INCR
15:08:33.504traceyii\redis\Connection::executeCommandExecuting Redis Command: HSET
15:08:33.504traceyii\redis\Connection::executeCommandExecuting Redis Command: LPUSH
15:08:33.504traceyii\redis\Connection::executeCommandExecuting Redis Command: INCR
15:08:33.504traceyii\redis\Connection::executeCommandExecuting Redis Command: HSET
15:08:33.504traceyii\redis\Connection::executeCommandExecuting Redis Command: LPUSH
15:08:33.504infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3880
15:08:33.505infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3880)
15:08:33.506infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "is_verify"=TRUE WHERE "id"=3880
15:08:33.507infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3880) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
15:08:33.508infoyii\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', 3880, 'a:0:{}', '', 1001, '124.64.23.198')
15:08:33.509infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2747
15:08:33.509infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3880
15:08:33.510infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("created_at" >= '2025-08-11 00:00:00') AND ("created_at" <= '2025-08-11 23:59:59') AND ("serial_no" ILIKE '%XSDD-20250811-%') AND (LENGTH(serial_no) = 19) ORDER BY "serial_no" DESC
15:08:33.511traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.511traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.512traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.512traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.512infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE "id"=6
15:08:33.512infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_orders" ("serial_no", "handler", "created_by", "wrote_date", "created_at", "verify_type", "status", "client_id", "project_id", "description", "extra", "outbound_status") VALUES ('XSDD-20250811-00001', 5449, 1001, '2025-08-11', 'now()', 1, 1, 2747, 3880, NULL, '{"payment_collection_remind_ahead":"1 day","salesContractPaymentCollectionRemindReceivers":["1001","5449"],"salesContractPaymentCollectionRemindDates":[{"remind_date":"2025-08-12","amount":"2222","pct":"0.3715"}]}', FALSE) RETURNING "id"
15:08:33.518infoyii\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\ErpSalesOrders', 3, 'a:36:{s:2:"id";i:3;s:9:"serial_no";s:19:"XSDD-20250811-00001";s:9:"from_date";N;s:10:"wrote_date";s:10:"2025-08-11";s:7:"handler";i:5449;s:9:"client_id";i:2747;s:20:"purchase_contract_id";N;s:10:"project_id";i:3880;s:17:"sales_contract_id";N;s:12:"erp_store_id";N;s:6:"status";i:1;s:16:"erp_send_type_id";N;s:8:"abstract";N;s:11:"description";N;s:11:"verify_type";s:1:"1";s:16:"next_verify_user";N;s:21:"next_stop_verify_user";N;s:23:"next_cancel_verify_user";N;s:9:"verify_at";N;s:7:"stop_at";N;s:9:"cancel_at";N;s:18:"refuse_description";N;s:14:"is_resubmitted";N;s:7:"is_done";N;s:6:"number";N;s:6:"amount";N;s:10:"created_by";i:1001;s:16:"stop_description";N;s:5:"extra";s:213:"{"payment_collection_remind_ahead":"1 day","salesContractPaymentCollectionRemindReceivers":["1001","5449"],"salesContractPaymentCollectionRemindDates":[{"remind_date":"2025-08-12","amount":"2222","pct":"0.3715"}]}";s:15:"outbound_status";b:0;s:7:"is_used";N;s:9:"is_cancel";N;s:9:"is_settle";N;s:6:"is_old";N;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:10:"updated_at";N;}', '', 1001, '124.64.23.198')
15:08:33.519infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=3) ORDER BY "id"
15:08:33.520infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "amount"='0', "number"='0', "next_verify_user"=NULL WHERE "id"=3
15:08:33.521infoyii\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', 3, 'a:2:{s:6:"number";i:0;s:6:"amount";i:0;}', '', 1001, '124.64.23.198')
15:08:33.522infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id"=3
15:08:33.522infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.523infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=3) ORDER BY "id"
15:08:33.523infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "status"=2, "verify_at"='now()', "updated_at"='now()' WHERE "id"=3
15:08:33.524infoyii\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', 3, 'a:2:{s:6:"status";i:2;s:9:"verify_at";s:5:"now()";}', '', 1001, '124.64.23.198')
15:08:33.525infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3880
15:08:33.525infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.526traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.526traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.526infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
15:08:33.526infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=1
15:08:33.526infoyii\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, 'project_status', 3880, 1, 1001, 'now()', '["\u5546\u673a\u6210\u4ea4"]', '["\u9690\u6027\u9700\u6c42"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u72b6\u6001","d4":["\u9690\u6027\u9700\u6c42 <b>\u53d8\u4e3a<\/b> \u5546\u673a\u6210\u4ea4"]}')
15:08:33.527infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.528infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
15:08:33.528infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=1
15:08:33.528infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2747
15:08:33.529infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'project_status', 3880, 1, 1001, 'now()', '["\u5546\u673a\u6210\u4ea4"]', '["\u9690\u6027\u9700\u6c42"]', array[5449], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u72b6\u6001","d4":["\u9690\u6027\u9700\u6c42 <b>\u53d8\u4e3a<\/b> \u5546\u673a\u6210\u4ea4"]}')
15:08:33.530traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.530traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.531infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_project_status_logs" ("project_id", "old_status", "new_status", "created_by", "created_at") VALUES (3880, 1, 3, 1001, 'now()') RETURNING "id"
15:08:33.532infoyii\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\ProjectStatusLogs', 3691, 'a:6:{s:2:"id";i:3691;s:10:"project_id";i:3880;s:10:"new_status";i:3;s:10:"old_status";i:1;s:10:"created_by";i:1001;s:10:"created_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '124.64.23.198')
15:08:33.533infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "project_status"=3, "change_status_to"=NULL, "is_verify"=FALSE WHERE "id"=3880
15:08:33.534infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3880) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
15:08:33.536infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_change_logs" SET "end_at"='now()' WHERE "id"=16670
15:08:33.536infoyii\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\ProjectChangeLogs', 16670, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '124.64.23.198')
15:08:33.537infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_project_change_logs" ("project_id", "project_status", "budget", "profit_pct", "collected", "start_from", "end_at") VALUES (3880, 3, '597988', '100', '0', 'now()', NULL) RETURNING "id"
15:08:33.538infoyii\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\ProjectChangeLogs', 16671, 'a:8:{s:2:"id";i:16671;s:10:"project_id";i:3880;s:14:"project_status";i:3;s:6:"budget";s:6:"597988";s:10:"profit_pct";s:3:"100";s:9:"collected";s:1:"0";s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '124.64.23.198')
15:08:33.539infoyii\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', 3880, 'a:0:{}', '', 1001, '124.64.23.198')
15:08:33.540infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2747
15:08:33.540infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.541infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=1
15:08:33.541infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
15:08:33.541infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3880
15:08:33.542traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.542traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.542infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3880
15:08:33.543infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
15:08:33.543infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "is_system", "description", "description2") VALUES (1001, '1', 3880, TRUE, '刘人诚更新了一条商机状态隐性需求变为商机成交', '') RETURNING "id"
15:08:33.544infoyii\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', 185502, 'a:11:{s:2:"id";i:185502;s:9:"object_id";i:3880;s:11:"object_type";s:1:"1";s:6:"parent";N;s:11:"description";s:66:"刘人诚更新了一条商机状态隐性需求变为商机成交";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:0:"";}', '', 1001, '124.64.23.198')
15:08:33.545traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.545traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.545infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (3880, '1', 185502, 1005), (3880, '1', 185502, 5449)
15:08:33.547infoyii\db\Command::querySELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id" IN (1005, 5449)) AND ("id" != 1001) AND (channel_id IS NOT NULL)
15:08:33.548infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.548traceyii\redis\Connection::executeCommandExecuting Redis Command: INCR
15:08:33.548traceyii\redis\Connection::executeCommandExecuting Redis Command: HSET
15:08:33.548traceyii\redis\Connection::executeCommandExecuting Redis Command: LPUSH
15:08:33.548infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5449
15:08:33.549traceyii\redis\Connection::executeCommandExecuting Redis Command: INCR
15:08:33.549traceyii\redis\Connection::executeCommandExecuting Redis Command: HSET
15:08:33.549traceyii\redis\Connection::executeCommandExecuting Redis Command: LPUSH
15:08:33.549infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3880
15:08:33.550traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.550traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.550infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_contracts" ("contract_type", "client_id", "project_id", "from_project", "amount", "signed_at", "handler", "created_by", "build_by_project", "need_analysis") VALUES (1, 2747, 3880, 3880, '597988', '2025-08-11', 5449, 1001, TRUE, TRUE) RETURNING "id"
15:08:33.552infoyii\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\SalesContracts', 4083, 'a:39:{s:2:"id";i:4083;s:9:"client_id";i:2747;s:9:"signed_at";s:10:"2025-08-11";s:6:"amount";s:6:"597988";s:7:"handler";i:5449;s:11:"description";N;s:10:"created_by";i:1001;s:10:"created_at";N;s:10:"updated_at";N;s:13:"contract_scan";N;s:12:"receipt_scan";N;s:13:"contract_type";i:1;s:10:"project_id";i:3880;s:10:"valid_date";N;s:11:"expire_date";N;s:3:"sla";N;s:12:"remind_ahead";N;s:19:"expire_remind_ahead";N;s:15:"expire_reminded";N;s:9:"serial_no";N;s:31:"payment_collection_remind_ahead";N;s:12:"from_project";i:3880;s:12:"receipt_date";N;s:11:"verify_date";N;s:13:"including_tax";N;s:16:"build_by_project";b:1;s:13:"need_analysis";b:1;s:9:"is_settle";N;s:10:"is_deliver";N;s:11:"is_outbound";N;s:18:"is_save_collection";N;s:18:"save_collection_at";N;s:9:"is_verify";N;s:8:"is_draft";N;s:17:"erp_settle_amount";N;s:20:"erp_un_settle_amount";N;s:28:"erp_payment_ticket_is_verify";N;s:28:"erp_collect_ticket_is_verify";N;s:30:"erp_cash_cost_ticket_is_verify";N;}', '', 1001, '124.64.23.198')
15:08:33.553infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2747
15:08:33.554infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3880
15:08:33.554infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "sales_contract_id"=4083 WHERE "id"=3
15:08:33.555infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4083
15:08:33.555infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.556infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 4083, 7, 1001, '2025-08-11 15:08:33', '{"id":4083,"client_id":2747,"signed_at":"2025-08-11","amount":"597988","handler":5449,"description":null,"created_by":1001,"created_at":"2025-08-11 15:08:33","updated_at":"2025-08-11 15:08:33","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3880,"valid_date":null,"expire_date":null,"sla":null,"remind_ahead":null,"expire_remind_ahead":null,"expire_reminded":false,"serial_no":null,"payment_collection_remind_ahead":"00:00:00","from_project":3880,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":false,"save_collection_at":null,"is_verify":false,"is_draft":false,"erp_settle_amount":null,"erp_un_settle_amount":null,"erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false}', '{"id":4083,"client_id":2747,"signed_at":"2025-08-11","amount":"597988","handler":5449,"description":null,"created_by":1001,"created_at":"2025-08-11 15:08:33","updated_at":"2025-08-11 15:08:33","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3880,"valid_date":null,"expire_date":null,"sla":null,"remind_ahead":null,"expire_remind_ahead":null,"expire_reminded":false,"serial_no":null,"payment_collection_remind_ahead":"00:00:00","from_project":3880,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":false,"save_collection_at":null,"is_verify":false,"is_draft":false,"erp_settle_amount":null,"erp_un_settle_amount":null,"erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":[]}') RETURNING "id"
15:08:33.557infoyii\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\ObjectChangeLogs', 552169, 'a:13:{s:2:"id";i:552169;s:9:"object_id";i:4083;s:11:"object_type";i:7;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:887:"{"id":4083,"client_id":2747,"signed_at":"2025-08-11","amount":"597988","handler":5449,"description":null,"created_by":1001,"created_at":"2025-08-11 15:08:33","updated_at":"2025-08-11 15:08:33","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3880,"valid_date":null,"expire_date":null,"sla":null,"remind_ahead":null,"expire_remind_ahead":null,"expire_reminded":false,"serial_no":null,"payment_collection_remind_ahead":"00:00:00","from_project":3880,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":false,"save_collection_at":null,"is_verify":false,"is_draft":false,"erp_settle_amount":null,"erp_un_settle_amount":null,"erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false}";s:9:"new_value";s:887:"{"id":4083,"client_id":2747,"signed_at":"2025-08-11","amount":"597988","handler":5449,"description":null,"created_by":1001,"created_at":"2025-08-11 15:08:33","updated_at":"2025-08-11 15:08:33","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3880,"valid_date":null,"expire_date":null,"sla":null,"remind_ahead":null,"expire_remind_ahead":null,"expire_reminded":false,"serial_no":null,"payment_collection_remind_ahead":"00:00:00","from_project":3880,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":false,"save_collection_at":null,"is_verify":false,"is_draft":false,"erp_settle_amount":null,"erp_un_settle_amount":null,"erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false}";s:11:"description";s:93:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-08-11 15:08:33";s:9:"is_delete";N;}', '', 1001, '124.64.23.198')
15:08:33.558infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.558infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 2747, 10, 4083, 7, 1001, '[4083]', '[4083]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}') RETURNING "id"
15:08:33.559infoyii\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\ObjectChangeLogs', 552170, 'a:13:{s:2:"id";i:552170;s:9:"object_id";i:2747;s:11:"object_type";i:10;s:9:"target_id";i:4083;s:18:"target_object_type";i:7;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[4083]";s:9:"new_value";s:6:"[4083]";s:11:"description";s:140:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '124.64.23.198')
15:08:33.560infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.560infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 3880, 1, 4083, 7, 1001, '[4083]', '[4083]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}') RETURNING "id"
15:08:33.561infoyii\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\ObjectChangeLogs', 552171, 'a:13:{s:2:"id";i:552171;s:9:"object_id";i:3880;s:11:"object_type";i:1;s:9:"target_id";i:4083;s:18:"target_object_type";i:7;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[4083]";s:9:"new_value";s:6:"[4083]";s:11:"description";s:140:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '124.64.23.198')
15:08:33.562infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2747
15:08:33.562infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.563infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "users", "description") VALUES (1, 'create', 3880, 1, 4083, 7, 1001, '4083', '4083', array[5449], '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}') RETURNING "id"
15:08:33.564infoyii\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\UserActionLogs', 149065, 'a:15:{s:2:"id";i:149065;s:9:"object_id";i:3880;s:11:"object_type";i:1;s:9:"target_id";i:4083;s:18:"target_object_type";i:7;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:4:"4083";s:9:"new_value";s:4:"4083";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[5449]";s:6:"params";a:0:{}}s:11:"description";s:140:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1001, '124.64.23.198')
15:08:33.565infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "project_id"=3880
15:08:33.568infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.569infoyii\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, 'payment_collection_remind_ahead', 3880, 1, 1001, 'now()', '["\u63d0\u524d1\u5929"]', '["\u4e0d\u63d0\u9192"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6536\u6b3e\u63d0\u9192\u65f6\u95f4","d4":["\u4e0d\u63d0\u9192 <b>\u53d8\u4e3a<\/b> \u63d0\u524d1\u5929"]}')
15:08:33.570infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.570infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'payment_collection_remind_ahead', 3880, 1, 1001, 'now()', '["\u63d0\u524d1\u5929"]', '["\u4e0d\u63d0\u9192"]', array[5449], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6536\u6b3e\u63d0\u9192\u65f6\u95f4","d4":["\u4e0d\u63d0\u9192 <b>\u53d8\u4e3a<\/b> \u63d0\u524d1\u5929"]}')
15:08:33.571infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3880)
15:08:33.572infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "payment_collection_remind_ahead"='1 day', "is_save_collection"=TRUE, "save_collection_at"='now()' WHERE "id"=4083
15:08:33.573infoyii\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', 4083, 'a:25:{s:11:"description";N;s:13:"contract_scan";N;s:12:"receipt_scan";N;s:10:"valid_date";N;s:11:"expire_date";N;s:3:"sla";N;s:12:"remind_ahead";N;s:19:"expire_remind_ahead";N;s:15:"expire_reminded";N;s:9:"serial_no";N;s:31:"payment_collection_remind_ahead";s:5:"1 day";s:12:"receipt_date";N;s:11:"verify_date";N;s:13:"including_tax";N;s:9:"is_settle";N;s:10:"is_deliver";N;s:11:"is_outbound";N;s:18:"save_collection_at";s:5:"now()";s:9:"is_verify";N;s:8:"is_draft";N;s:17:"erp_settle_amount";N;s:20:"erp_un_settle_amount";N;s:28:"erp_payment_ticket_is_verify";N;s:28:"erp_collect_ticket_is_verify";N;s:30:"erp_cash_cost_ticket_is_verify";N;}', '', 1001, '124.64.23.198')
15:08:33.574infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2747
15:08:33.574infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3880
15:08:33.575infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_contract_default_remind_users" WHERE ("user_id"=1001) AND ("type"=1)
15:08:33.575traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.575traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.575infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_contract_default_remind_users" ("user_id", "remind_user", "type") VALUES (1001, 1001, 1), (1001, 5449, 1)
15:08:33.576infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4083
15:08:33.577infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1001'
15:08:33.577infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5449'
15:08:33.578infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.578infoyii\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, 'salesContractPaymentCollectionRemindReceivers', 4083, 7, 1001, 'now()', '[["\u5218\u4eba\u8bda","\u5468\u4e3d\u98de"]]', '[[]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6536\u6b3e\u63d0\u9192\u4eba","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> \u5218\u4eba\u8bda;\u5468\u4e3d\u98de;"]}')
15:08:33.579infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4083
15:08:33.579traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.579traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.579infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4083, 1001) RETURNING "id"
15:08:33.580infoyii\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', 8818, 'a:3:{s:2:"id";i:8818;s:11:"contract_id";i:4083;s:7:"user_id";s:4:"1001";}', '', 1001, '124.64.23.198')
15:08:33.581infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4083, 5449) RETURNING "id"
15:08:33.582infoyii\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', 8819, 'a:3:{s:2:"id";i:8819;s:11:"contract_id";i:4083;s:7:"user_id";s:4:"5449";}', '', 1001, '124.64.23.198')
15:08:33.583infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4083
15:08:33.584infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.584infoyii\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, 'salesContractPaymentCollectionRemindDates', 3880, 1, 1001, 'now()', '[[]]', '[[]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6536\u6b3e\u8ba1\u5212","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> (\u672a\u8bbe\u7f6e)"]}')
15:08:33.585infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.585infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'salesContractPaymentCollectionRemindDates', 3880, 1, 1001, 'now()', '[[]]', '[[]]', array[5449], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6536\u6b3e\u8ba1\u5212","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> (\u672a\u8bbe\u7f6e)"]}')
15:08:33.586infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4083
15:08:33.586traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.587traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.587infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4083)
15:08:33.587infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" ("contract_id", "remind_date", "amount", "pct", "reminded") VALUES (4083, '2025-08-12', '2222', 0.3715, FALSE) RETURNING "id"
15:08:33.588infoyii\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\SalesContractPaymentCollectionRemindDates', 2558, 'a:9:{s:2:"id";i:2558;s:11:"contract_id";i:4083;s:11:"remind_date";s:10:"2025-08-12";s:8:"reminded";b:0;s:6:"amount";i:2222;s:11:"paid_amount";N;s:12:"overdue_days";N;s:6:"status";N;s:3:"pct";d:0.3715;}', '', 1001, '124.64.23.198')
15:08:33.589infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4083
15:08:33.590infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4083
15:08:33.591infoyii\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"=4083) AND ("t"."status" IN (2, 5, 1))
15:08:33.591infoyii\db\Command::querySELECT r.amount, t.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"=4083) AND ("t"."status" IN (2, 5, 1))
15:08:33.592infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3880
15:08:33.593infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4083
15:08:33.594infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "collected_plan"='2222' WHERE "id"=3880
15:08:33.595infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3880) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
15:08:33.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\Projects', 3880, 'a:1:{s:14:"collected_plan";s:4:"2222";}', '', 1001, '124.64.23.198')
15:08:33.597infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2747
15:08:33.597infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4083
15:08:33.598infoyii\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"=4083) AND ("t"."status" IN (2, 5, 1))
15:08:33.598infoyii\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"=4083) AND ("t"."status" IN (2, 5, 1))
15:08:33.599infoyii\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"=4083) AND ("t"."status" IN (2, 5, 1))
15:08:33.600infoyii\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"=4083) AND ("t"."status"=1))
15:08:33.600infoyii\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"=4083) AND ("t"."status"=1))
15:08:33.601infoyii\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"=4083) AND ("t"."status"=1))
15:08:33.601infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='597988' WHERE "id"=4083
15:08:33.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\SalesContracts', 4083, 'a:1:{s:17:"erp_settle_amount";i:0;}', '', 1001, '124.64.23.198')
15:08:33.603infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2747
15:08:33.603infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3880
15:08:33.604infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3880
15:08:33.605infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=3880
15:08:33.606infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3880) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
15:08:33.607infoyii\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', 3880, 'a:0:{}', '', 1001, '124.64.23.198')
15:08:33.608infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2747
15:08:33.609infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2747
15:08:33.610infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=2747
15:08:33.610infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2747) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
15:08:33.619infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2747, 5449, 'now()', NULL) RETURNING "id"
15:08:33.620infoyii\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', 177481, 'a:5:{s:2:"id";i:177481;s:9:"client_id";i:2747;s:9:"sales_rep";i:5449;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '124.64.23.198')
15:08:33.621infoyii\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', 2747, 'a:0:{}', '', 1001, '124.64.23.198')
15:08:33.622infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.623infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 2747, 10, 3880, 1, 1001, '[3880]', '[3880]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u201c\u4e24\u5730\u4e09\u4e2d\u5fc3\u201d\u707e\u5907\u5e73\u53f0\u89c4\u5212\u8bbe\u8ba1"]}') RETURNING "id"
15:08:33.623infoyii\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\ObjectChangeLogs', 552175, 'a:13:{s:2:"id";i:552175;s:9:"object_id";i:2747;s:11:"object_type";i:10;s:9:"target_id";i:3880;s:18:"target_object_type";i:1;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[3880]";s:9:"new_value";s:6:"[3880]";s:11:"description";s:173:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u201c\u4e24\u5730\u4e09\u4e2d\u5fc3\u201d\u707e\u5907\u5e73\u53f0\u89c4\u5212\u8bbe\u8ba1"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '124.64.23.198')
15:08:33.624infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2747
15:08:33.625infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_projects" WHERE ("project_status"=3) AND ("bargain_date" >= '2025-01-01 00:00:00') AND ("bargain_date" <= '2025-12-31 23:59:59') AND ("client_id"=2747)
15:08:33.626infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "cooperate_count"=1 WHERE "id"=2747
15:08:33.627infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2747) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
15:08:33.635infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2747, 5449, 'now()', NULL) RETURNING "id"
15:08:33.636infoyii\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', 177482, 'a:5:{s:2:"id";i:177482;s:9:"client_id";i:2747;s:9:"sales_rep";i:5449;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '124.64.23.198')
15:08:33.637infoyii\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', 2747, 'a:0:{}', '', 1001, '124.64.23.198')
15:08:33.638traceyii\redis\Connection::executeCommandExecuting Redis Command: INCR
15:08:33.638traceyii\redis\Connection::executeCommandExecuting Redis Command: HSET
15:08:33.638traceyii\redis\Connection::executeCommandExecuting Redis Command: LPUSH
15:08:33.638traceyii\redis\Connection::executeCommandExecuting Redis Command: INCR
15:08:33.638traceyii\redis\Connection::executeCommandExecuting Redis Command: HSET
15:08:33.638traceyii\redis\Connection::executeCommandExecuting Redis Command: LPUSH
15:08:33.638infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3880
15:08:33.639infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3880)
15:08:33.639infoyii\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', 3, 'a:0:{}', '', 1001, '124.64.23.198')
15:08:33.640infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE 0=1
15:08:33.642infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id"=3
15:08:33.642traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.642traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.643infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_ticket_change_logs" ("status", "ticket_type", "serial_no", "wrote_date", "description", "abstract", "client_id", "supplier_id", "created_by", "created_at", "updated_at", "verify_at") VALUES (2, 20007, 'XSDD-20250811-00001', '2025-08-11', NULL, NULL, 2747, NULL, 1001, '2025-08-11 15:08:33', '2025-08-11 15:08:33', '2025-08-11 15:08:33.523634+08') RETURNING "id"
15:08:33.649infoyii\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', 66, 'a:13:{s:2:"id";i:66;s:9:"serial_no";s:19:"XSDD-20250811-00001";s:11:"ticket_type";i:20007;s:10:"wrote_date";s:10:"2025-08-11";s:6:"status";i:2;s:11:"supplier_id";N;s:9:"client_id";i:2747;s:8:"abstract";N;s:11:"description";N;s:9:"verify_at";s:29:"2025-08-11 15:08:33.523634+08";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-08-11 15:08:33";s:10:"updated_at";s:19:"2025-08-11 15:08:33";}', '', 1001, '124.64.23.198')
15:08:33.650traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.651traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.651infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_ticket_change_log_handlers" ("erp_ticket_change_log_id", "user_id") VALUES (66, 5449)
15:08:33.654infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:08:33.655infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 3, 20007, 1001, '2025-08-11 15:08:33', '{"id":3,"serial_no":"XSDD-20250811-00001","from_date":null,"wrote_date":"2025-08-11","handler":5449,"client_id":2747,"purchase_contract_id":null,"project_id":3880,"sales_contract_id":null,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"now()","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"0","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"5449\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2025-08-12\",\"amount\":\"2222\",\"pct\":\"0.3715\"}]}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-08-11 15:08:33","updated_at":"1970-01-01 08:00:00"}', '{"id":3,"serial_no":"XSDD-20250811-00001","from_date":null,"wrote_date":"2025-08-11","handler":5449,"client_id":2747,"purchase_contract_id":null,"project_id":3880,"sales_contract_id":null,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"now()","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"0","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"5449\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2025-08-12\",\"amount\":\"2222\",\"pct\":\"0.3715\"}]}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-08-11 15:08:33","updated_at":"1970-01-01 08:00:00"}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8ba2\u5355\u7533\u8bf7","d4":[]}') RETURNING "id"
15:08:33.656infoyii\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\ObjectChangeLogs', 552176, 'a:13:{s:2:"id";i:552176;s:9:"object_id";i:3;s:11:"object_type";i:20007;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:972:"{"id":3,"serial_no":"XSDD-20250811-00001","from_date":null,"wrote_date":"2025-08-11","handler":5449,"client_id":2747,"purchase_contract_id":null,"project_id":3880,"sales_contract_id":null,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"now()","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"0","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"5449\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2025-08-12\",\"amount\":\"2222\",\"pct\":\"0.3715\"}]}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-08-11 15:08:33","updated_at":"1970-01-01 08:00:00"}";s:9:"new_value";s:972:"{"id":3,"serial_no":"XSDD-20250811-00001","from_date":null,"wrote_date":"2025-08-11","handler":5449,"client_id":2747,"purchase_contract_id":null,"project_id":3880,"sales_contract_id":null,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"now()","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"0","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"5449\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2025-08-12\",\"amount\":\"2222\",\"pct\":\"0.3715\"}]}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-08-11 15:08:33","updated_at":"1970-01-01 08:00:00"}";s:11:"description";s:105:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8ba2\u5355\u7533\u8bf7","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-08-11 15:08:33";s:9:"is_delete";N;}', '', 1001, '124.64.23.198')
15:08:33.657infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3880
15:08:33.657traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.657traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.658infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "cost", "total_cost", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (3, 947, '1', '543534.00', '543534', '', '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id"
15:08:33.661infoyii\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\ErpSalesOrderProducts', 3, 'a:21:{s:2:"id";i:3;s:18:"erp_sales_order_id";i:3;s:12:"erp_store_id";N;s:10:"product_id";i:947;s:11:"description";s:0:"";s:6:"number";i:1;s:8:"outbound";N;s:6:"amount";s:9:"543534.00";s:12:"total_amount";s:6:"543534";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";s:1:"0";s:10:"total_cost";s:1:"0";s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '124.64.23.198')
15:08:33.661infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "erp_sales_order_product_id"=3 WHERE "id"=10587
15:08:33.662infoyii\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\ProjectProductRels', 10587, 'a:1:{s:26:"erp_sales_order_product_id";i:3;}', '', 1001, '124.64.23.198')
15:08:33.663infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "cost", "total_cost", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (3, 2067, '1', '54454.00', '54454', '', '1.00', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id"
15:08:33.664infoyii\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\ErpSalesOrderProducts', 4, 'a:21:{s:2:"id";i:4;s:18:"erp_sales_order_id";i:3;s:12:"erp_store_id";N;s:10:"product_id";i:2067;s:11:"description";s:0:"";s:6:"number";i:1;s:8:"outbound";N;s:6:"amount";s:8:"54454.00";s:12:"total_amount";s:5:"54454";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";s:4:"1.00";s:10:"total_cost";s:1:"1";s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '124.64.23.198')
15:08:33.665infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "erp_sales_order_product_id"=4 WHERE "id"=10588
15:08:33.666infoyii\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\ProjectProductRels', 10588, 'a:1:{s:26:"erp_sales_order_product_id";i:4;}', '', 1001, '124.64.23.198')
15:08:33.667infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "amount"='597988', "number"='2' WHERE "id"=3
15:08:33.668infoyii\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', 3, 'a:2:{s:6:"amount";i:597988;s:6:"number";i:2;}', '', 1001, '124.64.23.198')
15:08:33.669infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=3
15:08:33.670infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id" IN (3, 4)
15:08:33.674infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=3
15:08:33.675infoyii\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\ErpSalesOrderProducts', 3, 'a:0:{}', '', 1001, '124.64.23.198')
15:08:33.676infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=4
15:08:33.676infoyii\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\ErpSalesOrderProducts', 4, 'a:0:{}', '', 1001, '124.64.23.198')
15:08:33.677infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "is_used"=FALSE WHERE "id"=3
15:08:33.678infoyii\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', 3, 'a:0:{}', '', 1001, '124.64.23.198')
15:08:33.679infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE 0=1
15:08:33.679traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.679traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:08:33.679infoyii\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/project/save-edit', '{"Projects":{"id":"3880","payment_collection_remind_ahead":"1 day","salesContractPaymentCollectionRemindReceivers":["1001","5449"],"salesContractPaymentCollectionRemindDates":[{"remind_date":"2025-08-12","amount":"2222","pct":"0.3715"}],"client_name":"\u4e2d\u56fd\u5316\u5b66\u5de5\u7a0b\u96c6\u56e2","client_id":"2747","project_status":"3","project_progress":"2","profit":"597987","profit_pct":"99.99","bargain_date":"2025-08-11","project_title":"\u201c\u4e24\u5730\u4e09\u4e2d\u5fc3\u201d\u707e\u5907\u5e73\u53f0\u89c4\u5212\u8bbe\u8ba1","from_contact_name":"","from_contact":"","salesForecast":"181","purchaseType":"128","opportunityFrom":"","contract_type":"1","comment":"","projectRemindReceivers":["1005"],"project_product_version_id":"","projectProductRels":{"10587":{"product_id":"947","amount":"543534.00","total_amount":"543534","number":"1","cost":"0","total_cost":"0","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"10588":{"product_id":"2067","amount":"54454.00","total_amount":"54454","number":"1","cost":"1.00","total_cost":"1","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""}},"projectContactPoints":"","projectContactPointRels":"","projectUsedClient":{"used_client":"","budget":"","profit":"","profit_pct":"","projectUsedClientPaymentCollectionRemindReceivers":"","projectUsedClientPaymentCollectionRemindDates":"","remind_ahead":"","projectUsedClientPayments":"","projectUsedClientInvoices":""},"projectProductTypes":{"5":{"budget":"543534","profit":"543534","pct":"100"},"4":{"budget":"54454","profit":"54453","pct":"99.99"}},"projectArchitects":""},"web_access_token":"HcPbdczjiT4Sp46OV0lNGsvc5AuI1uUw"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u5546\u673a\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-08-11 15:08:33') RETURNING "id"
15:08:33.681traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:08:33.681traceyii\redis\Connection::executeCommandExecuting Redis Command: SET