ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c3e15292166: POST https://beta.jinchangxiao.com/v2/project/save-edit at 2025-09-12 05:01:06 pm by 223.73.39.229

Log Messages

总计190条数据
TimeLevelCategoryMessage
 
17:01:06.597traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
17:01:06.597traceyii\base\Module::getModuleLoading module: debug
17:01:06.598traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
17:01:06.598traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
17:01:06.598traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
17:01:06.598traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.598traceyii\base\Module::getModuleLoading module: gii
17:01:06.598traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
17:01:06.599traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
17:01:06.599traceyii\web\Application::handleRequestRoute requested: 'v2/project/save-edit'
17:01:06.599traceyii\base\Module::getModuleLoading module: v2
17:01:06.599infoyii\web\Session::openSession started
17:01:06.600infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:01:06.601infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om'
17:01:06.604traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.604traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:01:06.605traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.605traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:01:06.605infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:01:06.606traceyii\base\Controller::runActionRoute to run: v2/project/save-edit
17:01:06.607traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.608traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:01:06.608traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\ProjectController::actionSaveEdit()
17:01:06.608infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3959'
17:01:06.609traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.609traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:01:06.609traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.609traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.610traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'purchaseType' in 'app\models\Projects'.
17:01:06.610traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'salesForecast' in 'app\models\Projects'.
17:01:06.610traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectArchitects' in 'app\models\Projects'.
17:01:06.610traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectProductTypes' in 'app\models\Projects'.
17:01:06.610traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectRemindReceivers' in 'app\models\Projects'.
17:01:06.610traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'salesContractPaymentCollectionRemindDates' in 'app\models\Projects'.
17:01:06.610traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'id' in 'app\models\Projects'.
17:01:06.610traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'payment_collection_remind_ahead' in 'app\models\Projects'.
17:01:06.610traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'purchaseType' in 'app\models\Projects'.
17:01:06.610traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'salesForecast' in 'app\models\Projects'.
17:01:06.610traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectArchitects' in 'app\models\Projects'.
17:01:06.610traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectProductTypes' in 'app\models\Projects'.
17:01:06.610traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectRemindReceivers' in 'app\models\Projects'.
17:01:06.610traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'salesContractPaymentCollectionRemindDates' in 'app\models\Projects'.
17:01:06.610traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'id' in 'app\models\Projects'.
17:01:06.610traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'payment_collection_remind_ahead' in 'app\models\Projects'.
17:01:06.610infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3959
17:01:06.611infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (5, 226, 129, 136, 139, 142, 184, 189, 349)) ORDER BY "sort"
17:01:06.612traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.612traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:01:06.612infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='1661') AND ("project_title"='吉德科娃') AND ("id" != 3959))
17:01:06.613infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1')
17:01:06.614infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='1661')
17:01:06.614infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"='2')
17:01:06.615infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='3')
17:01:06.615infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
17:01:06.615infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:01:06.616infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3959
17:01:06.616traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.617traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:01:06.617infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3959
17:01:06.618traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.618traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:01:06.618infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7
17:01:06.618infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (3959, 7, '软件', '788888', 99.98, '788730.2224')
17:01:06.620infoyii\db\Command::execute
17:01:06.620infoyii\db\Command::execute
17:01:06.621infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "client_id"=1661, "project_status"=3, "project_progress"=2, "budget"='788888', "profit_pct"='99.98', "updated_at"='now()', "contract_type"=1, "used_client"=NULL, "from_contact"=NULL WHERE "id"=3959
17:01:06.622infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3959) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:01:06.624traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.624traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:01:06.625traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.625traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:01:06.625infoyii\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', 3959, 'a:0:{}', '', 1000, '223.73.39.229')
17:01:06.627infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='1661'
17:01:06.628traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.628traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:01:06.628infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:01:06.629infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3959
17:01:06.629traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.629traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:01:06.629infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5085
17:01:06.630infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1022
17:01:06.630infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1023
17:01:06.631infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5085
17:01:06.631infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5248
17:01:06.631infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1015
17:01:06.632infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1022
17:01:06.632infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1023
17:01:06.633infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:01:06.633traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.633traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:01:06.633infoyii\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, 'projectArchitects', 3959, 1, 1000, 'now()', '[["\u970d\u4e1c\u9633 10%","\u5f90\u7855 50%","\u5468\u5b50\u5065 40%"]]', '[["\u970d\u4e1c\u9633 10%","\u6587\u4f73\u9f99 0%","\u5434\u660a 0%","\u5f90\u7855 50%","\u5468\u5b50\u5065 40%"]]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u552e\u524d\u652f\u6301","d4":["\u970d\u4e1c\u9633 10%;\u6587\u4f73\u9f99 0%;\u5434\u660a 0%;\u5f90\u7855 50%;\u5468\u5b50\u5065 40%; <b>\u53d8\u4e3a<\/b> \u970d\u4e1c\u9633 10%;\u5f90\u7855 50%;\u5468\u5b50\u5065 40%;"]}')
17:01:06.636infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='1661'
17:01:06.637infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:01:06.637traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.637traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:01:06.637infoyii\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, 'projectArchitects', 3959, 1, 1000, 'now()', '[["\u970d\u4e1c\u9633 10%","\u5f90\u7855 50%","\u5468\u5b50\u5065 40%"]]', '[["\u970d\u4e1c\u9633 10%","\u6587\u4f73\u9f99 0%","\u5434\u660a 0%","\u5f90\u7855 50%","\u5468\u5b50\u5065 40%"]]', array[1001], '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u552e\u524d\u652f\u6301","d4":["\u970d\u4e1c\u9633 10%;\u6587\u4f73\u9f99 0%;\u5434\u660a 0%;\u5f90\u7855 50%;\u5468\u5b50\u5065 40%; <b>\u53d8\u4e3a<\/b> \u970d\u4e1c\u9633 10%;\u5f90\u7855 50%;\u5468\u5b50\u5065 40%;"]}')
17:01:06.638infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3959
17:01:06.639infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_architects" ("project_id", "engineer_id", "contribution", "created_by") VALUES (3959, 5085, '0.1', 1000), (3959, 1022, '0.5', 1000), (3959, 1023, '0.4', 1000)
17:01:06.641infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3959
17:01:06.641infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (5, 226, 129, 136, 139, 142, 184, 189, 349)) ORDER BY "sort"
17:01:06.641infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=129
17:01:06.642infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='129'
17:01:06.642infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3959) AND ("term_id"=9)
17:01:06.643traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.643traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:01:06.643infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (9, 129, 3959)
17:01:06.646infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=142
17:01:06.646infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='142'
17:01:06.646infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3959) AND ("term_id"=13)
17:01:06.647infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (13, 142, 3959)
17:01:06.648infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3959
17:01:06.648infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3959
17:01:06.649infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3959
17:01:06.650traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.650traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:01:06.650infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3959)
17:01:06.650infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "amount"='788888', "contract_type"=1, "save_collection_at"='now()' WHERE "id"=4140
17:01:06.652infoyii\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', 4140, 'a:1:{s:18:"save_collection_at";s:5:"now()";}', '', 1000, '223.73.39.229')
17:01:06.653infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661
17:01:06.653infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3959
17:01:06.653infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_contract_default_remind_users" WHERE ("user_id"=1000) AND ("type"=1)
17:01:06.654infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4140
17:01:06.654infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4140
17:01:06.655infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4140
17:01:06.655traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.655traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:01:06.655infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4140
17:01:06.656infoyii\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"=4140) AND ("t"."status" IN (2, 5, 1))
17:01:06.656infoyii\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"=4140) AND ("t"."status" IN (2, 5, 1))
17:01:06.657infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3959
17:01:06.658infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4140
17:01:06.659infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3959) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:01:06.660infoyii\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', 3959, 'a:0:{}', '', 1000, '223.73.39.229')
17:01:06.661infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661
17:01:06.661infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4140
17:01:06.662infoyii\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"=4140) AND ("t"."status" IN (2, 5))
17:01:06.662infoyii\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"=4140) AND ("t"."status" IN (2, 5))
17:01:06.663infoyii\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"=4140) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
17:01:06.664infoyii\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"=4140) AND ("t"."status"=1))
17:01:06.664infoyii\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"=4140) AND ("t"."status"=1))
17:01:06.665infoyii\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"=4140) AND ("t"."status"=1))
17:01:06.665infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='788888' WHERE "id"=4140
17:01:06.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\SalesContracts', 4140, 'a:0:{}', '', 1000, '223.73.39.229')
17:01:06.667infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661
17:01:06.668infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3959
17:01:06.668infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3959
17:01:06.669infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=3959
17:01:06.670infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3959) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:01:06.671infoyii\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', 3959, 'a:0:{}', '', 1000, '223.73.39.229')
17:01:06.672infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661
17:01:06.673infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4140
17:01:06.673infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4140
17:01:06.673infoyii\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"=4140) AND ("t"."status" IN (2, 5, 1))
17:01:06.674infoyii\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"=4140) AND ("t"."status" IN (2, 5, 1))
17:01:06.674infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3959
17:01:06.675infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4140
17:01:06.675infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3959) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:01:06.677infoyii\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', 3959, 'a:0:{}', '', 1000, '223.73.39.229')
17:01:06.678infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661
17:01:06.678infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='1661'
17:01:06.679infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=1661
17:01:06.680infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=1661) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:01:06.694traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.694traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:01:06.694infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (1661, 1001, 'now()', NULL) RETURNING "id"
17:01:06.695infoyii\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', 180845, 'a:5:{s:2:"id";i:180845;s:9:"client_id";i:1661;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1000, '223.73.39.229')
17:01:06.696infoyii\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', 1661, 'a:0:{}', '', 1000, '223.73.39.229')
17:01:06.697infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:01:06.698infoyii\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', 1661, 10, 3959, 1, 1000, '[3959]', '[3959]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u5409\u5fb7\u79d1\u5a03"]}') RETURNING "id"
17:01:06.699infoyii\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', 565239, 'a:13:{s:2:"id";i:565239;s:9:"object_id";s:4:"1661";s:11:"object_type";i:10;s:9:"target_id";i:3959;s:18:"target_object_type";i:1;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[3959]";s:9:"new_value";s:6:"[3959]";s:11:"description";s:107:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u5409\u5fb7\u79d1\u5a03"]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '223.73.39.229')
17:01:06.699infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='1661'
17:01:06.700infoyii\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"=1661)
17:01:06.701infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=1661) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:01:06.710infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (1661, 1001, 'now()', NULL) RETURNING "id"
17:01:06.711infoyii\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', 180846, 'a:5:{s:2:"id";i:180846;s:9:"client_id";i:1661;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1000, '223.73.39.229')
17:01:06.711infoyii\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', 1661, 'a:0:{}', '', 1000, '223.73.39.229')
17:01:06.713traceyii\redis\Connection::executeCommandExecuting Redis Command: INCR
17:01:06.713traceyii\redis\Connection::executeCommandExecuting Redis Command: HSET
17:01:06.713traceyii\redis\Connection::executeCommandExecuting Redis Command: LPUSH
17:01:06.713traceyii\redis\Connection::executeCommandExecuting Redis Command: INCR
17:01:06.713traceyii\redis\Connection::executeCommandExecuting Redis Command: HSET
17:01:06.713traceyii\redis\Connection::executeCommandExecuting Redis Command: LPUSH
17:01:06.713infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3959
17:01:06.713infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3959)
17:01:06.714traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.714traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:01:06.715infoyii\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', 1586, 'a:0:{}', '', 1000, '223.73.39.229')
17:01:06.716traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:01:06.716traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:01:06.716infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, NULL, NULL, 'v2/project/save-edit', '{"Projects":{"purchaseType":"129","comment":"\u91d1\u5a1c\u5a1c","salesForecast":"142","projectArchitects":{"5085":"0.1","1022":"0.5","1023":"0.4"},"project_status":"3","used_client":"","project_progress":"2","contract_type":"1","projectProductTypes":{"7":{"pct":"99.98","budget":"788888"}},"project_title":"\u5409\u5fb7\u79d1\u5a03","projectRemindReceivers":"","description":"","salesContractPaymentCollectionRemindDates":"","from_contact":"","id":"3959","payment_collection_remind_ahead":"","bargain_date":"2025-09-11","client_id":"1661"},"access_token":"gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om","device_type":"0","version_code":"266","token":"abc93ed0ee98c8d968a0d9bb61d72473","posttime":"1757667667"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u5546\u673a\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-09-12 17:01:06') RETURNING "id"