ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c42fddd0fa5: POST https://beta.jinchangxiao.com/v2/project/save-edit at 2025-09-12 10:36:13 pm by 39.157.26.122

Log Messages

总计132条数据
TimeLevelCategoryMessage
 
22:36:13.855traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
22:36:13.855traceyii\base\Module::getModuleLoading module: debug
22:36:13.855traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
22:36:13.856traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
22:36:13.856traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
22:36:13.856traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:36:13.856traceyii\base\Module::getModuleLoading module: gii
22:36:13.856traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
22:36:13.856traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
22:36:13.856traceyii\web\Application::handleRequestRoute requested: 'v2/project/save-edit'
22:36:13.856traceyii\base\Module::getModuleLoading module: v2
22:36:13.857infoyii\web\Session::openSession started
22:36:13.857infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
22:36:13.859infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om'
22:36:13.862traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:36:13.862traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:36:13.862traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:36:13.863traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:36:13.863infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
22:36:13.864traceyii\base\Controller::runActionRoute to run: v2/project/save-edit
22:36:13.864traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:36:13.865traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
22:36:13.866traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\ProjectController::actionSaveEdit()
22:36:13.866infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3954'
22:36:13.867traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:36:13.867traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:36:13.867traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:36:13.868traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:36:13.869traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'purchaseType' in 'app\models\Projects'.
22:36:13.869traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'salesForecast' in 'app\models\Projects'.
22:36:13.869traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectArchitects' in 'app\models\Projects'.
22:36:13.869traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectProductTypes' in 'app\models\Projects'.
22:36:13.869traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectRemindReceivers' in 'app\models\Projects'.
22:36:13.869traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'id' in 'app\models\Projects'.
22:36:13.869traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'purchaseType' in 'app\models\Projects'.
22:36:13.869traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'salesForecast' in 'app\models\Projects'.
22:36:13.869traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectArchitects' in 'app\models\Projects'.
22:36:13.869traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectProductTypes' in 'app\models\Projects'.
22:36:13.869traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectRemindReceivers' in 'app\models\Projects'.
22:36:13.869traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'id' in 'app\models\Projects'.
22:36:13.869infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3954
22:36:13.870infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (215, 164, 142, 184, 189, 349)) ORDER BY "sort"
22:36:13.871traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:36:13.874traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:36:13.875infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='93') AND ("project_title"='群晖扩容') AND ("id" != 3954))
22:36:13.877infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1')
22:36:13.877infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='93')
22:36:13.878infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"='4')
22:36:13.879infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='2')
22:36:13.879infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1005)
22:36:13.880infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
22:36:13.881infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3954
22:36:13.882traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:36:13.882traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:36:13.882infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3954
22:36:13.883traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:36:13.883traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:36:13.883infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=3
22:36:13.884infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (3954, 3, '存储设备', '130000', 11.53, '14989')
22:36:13.886infoyii\db\Command::execute
22:36:13.886infoyii\db\Command::execute
22:36:13.887infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "client_id"=93, "project_status"=2, "project_progress"=4, "budget"='130000', "profit_pct"='11.53', "updated_at"='now()', "contract_type"=1, "used_client"=NULL, "from_contact"=NULL WHERE "id"=3954
22:36:13.889infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3954) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
22:36:13.891traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:36:13.891traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:36:13.892traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:36:13.892traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:36:13.892infoyii\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', 3954, 'a:0:{}', '', 1000, '39.157.26.122')
22:36:13.894infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='93'
22:36:13.894traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:36:13.894traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:36:13.895infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
22:36:13.895infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3954
22:36:13.896traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:36:13.896traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:36:13.896infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5085
22:36:13.896infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1023
22:36:13.897infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1023
22:36:13.897infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
22:36:13.898traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:36:13.898traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:36:13.898infoyii\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', 3954, 1, 1000, 'now()', '[["\u970d\u4e1c\u9633 30%","\u5468\u5b50\u5065 70%"]]', '[["\u5468\u5b50\u5065 100%"]]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u552e\u524d\u652f\u6301","d4":["\u5468\u5b50\u5065 100%; <b>\u53d8\u4e3a<\/b> \u970d\u4e1c\u9633 30%;\u5468\u5b50\u5065 70%;"]}')
22:36:13.899infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='93'
22:36:13.899infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
22:36:13.900traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:36:13.900traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:36:13.900infoyii\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', 3954, 1, 1000, 'now()', '[["\u970d\u4e1c\u9633 30%","\u5468\u5b50\u5065 70%"]]', '[["\u5468\u5b50\u5065 100%"]]', array[1005], '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u552e\u524d\u652f\u6301","d4":["\u5468\u5b50\u5065 100%; <b>\u53d8\u4e3a<\/b> \u970d\u4e1c\u9633 30%;\u5468\u5b50\u5065 70%;"]}')
22:36:13.901infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3954
22:36:13.902infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_architects" ("project_id", "engineer_id", "contribution", "created_by") VALUES (3954, 5085, '0.3', 1000), (3954, 1023, '0.7', 1000)
22:36:13.903infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3954
22:36:13.904infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (215, 164, 142, 184, 189, 349)) ORDER BY "sort"
22:36:13.904infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=164
22:36:13.904infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='164'
22:36:13.905infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3954) AND ("term_id"=9)
22:36:13.905traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:36:13.906traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:36:13.906infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (9, 164, 3954)
22:36:13.907infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=142
22:36:13.907infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='142'
22:36:13.907infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3954) AND ("term_id"=13)
22:36:13.908infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (13, 142, 3954)
22:36:13.909infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3954
22:36:13.909infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3954
22:36:13.910infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3954
22:36:13.911infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='93'
22:36:13.912infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=93
22:36:13.913infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=93) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
22:36:13.931traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:36:13.931traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:36:13.932infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (93, 1005, 'now()', NULL) RETURNING "id"
22:36:13.933infoyii\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', 180854, 'a:5:{s:2:"id";i:180854;s:9:"client_id";i:93;s:9:"sales_rep";i:1005;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1000, '39.157.26.122')
22:36:13.934infoyii\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', 93, 'a:0:{}', '', 1000, '39.157.26.122')
22:36:13.935infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
22:36:13.936infoyii\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', 93, 10, 3954, 1, 1000, '[3954]', '[3954]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u7fa4\u6656\u6269\u5bb9"]}') RETURNING "id"
22:36:13.937infoyii\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', 565258, 'a:13:{s:2:"id";i:565258;s:9:"object_id";s:2:"93";s:11:"object_type";i:10;s:9:"target_id";i:3954;s:18:"target_object_type";i:1;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[3954]";s:9:"new_value";s:6:"[3954]";s:11:"description";s:107:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u7fa4\u6656\u6269\u5bb9"]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '39.157.26.122')
22:36:13.938infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='93'
22:36:13.938infoyii\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"=93)
22:36:13.940infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=93) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
22:36:13.955infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (93, 1005, 'now()', NULL) RETURNING "id"
22:36:13.957infoyii\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', 180855, 'a:5:{s:2:"id";i:180855;s:9:"client_id";i:93;s:9:"sales_rep";i:1005;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1000, '39.157.26.122')
22:36:13.958infoyii\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', 93, 'a:0:{}', '', 1000, '39.157.26.122')
22:36:13.959traceyii\redis\Connection::executeCommandExecuting Redis Command: INCR
22:36:13.959traceyii\redis\Connection::executeCommandExecuting Redis Command: HSET
22:36:13.959traceyii\redis\Connection::executeCommandExecuting Redis Command: LPUSH
22:36:13.959traceyii\redis\Connection::executeCommandExecuting Redis Command: INCR
22:36:13.959traceyii\redis\Connection::executeCommandExecuting Redis Command: HSET
22:36:13.959traceyii\redis\Connection::executeCommandExecuting Redis Command: LPUSH
22:36:13.959infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3954
22:36:13.960infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3954)
22:36:13.961traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:36:13.961traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:36:13.962infoyii\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":"164","comment":"","salesForecast":"142","projectArchitects":{"5085":"0.3","1023":"0.7"},"project_status":"2","projectProductTypes":{"3":{"budget":"130000","pct":"11.53"}},"used_client":"","project_progress":"4","contract_type":"1","project_title":"\u7fa4\u6656\u6269\u5bb9","projectRemindReceivers":"","description":"","from_contact":"","id":"3954","bargain_date":"2025-10-01","client_id":"93"},"access_token":"gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om","device_type":"0","version_code":"266","token":"edc33acf3b2683b04c54542b17148a14","posttime":"1757687773"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u5546\u673a\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-09-12 22:36:13') RETURNING "id"