68625c31c892b: POST https://beta.jinchangxiao.com/v2/project/save-edit at 2025-06-30 05:43:13 pm by 223.104.41.148
Log Messages
总计101条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 17:43:13.820 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 17:43:13.820 | trace | yii\base\Module::getModule | Loading module: debug |
| 17:43:13.821 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 17:43:13.821 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 17:43:13.821 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 17:43:13.822 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:43:13.822 | trace | yii\base\Module::getModule | Loading module: gii |
| 17:43:13.822 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 17:43:13.822 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 17:43:13.822 | trace | yii\web\Application::handleRequest | Route requested: 'v2/project/save-edit' |
| 17:43:13.822 | trace | yii\base\Module::getModule | Loading module: v2 |
| 17:43:13.822 | info | yii\web\Session::open | Session started |
| 17:43:13.823 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 17:43:13.826 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u' |
| 17:43:13.830 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:43:13.832 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:43:13.832 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:43:13.833 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:43:13.833 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 17:43:13.835 | trace | yii\base\Controller::runAction | Route to run: v2/project/save-edit |
| 17:43:13.835 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:43:13.836 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 17:43:13.836 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\ProjectController::actionSaveEdit() |
| 17:43:13.836 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3814' |
| 17:43:13.837 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:43:13.838 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:43:13.838 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:43:13.839 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:43:13.840 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'id' in 'app\models\Projects'. |
| 17:43:13.840 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'projectProductTypes' in 'app\models\Projects'. |
| 17:43:13.840 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'projectRemindReceivers' in 'app\models\Projects'. |
| 17:43:13.840 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'purchaseType' in 'app\models\Projects'. |
| 17:43:13.840 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'salesForecast' in 'app\models\Projects'. |
| 17:43:13.840 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'id' in 'app\models\Projects'. |
| 17:43:13.840 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'projectProductTypes' in 'app\models\Projects'. |
| 17:43:13.840 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'projectRemindReceivers' in 'app\models\Projects'. |
| 17:43:13.840 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'purchaseType' in 'app\models\Projects'. |
| 17:43:13.840 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'salesForecast' in 'app\models\Projects'. |
| 17:43:13.840 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3814 |
| 17:43:13.841 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (1, 165, 135, 140, 172, 197, 199, 377)) ORDER BY "sort" |
| 17:43:13.844 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:43:13.844 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:43:13.846 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='2815') AND ("project_title"='几节课') AND ("id" != 3814)) |
| 17:43:13.848 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1') |
| 17:43:13.849 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815') |
| 17:43:13.850 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"='9') |
| 17:43:13.851 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='1') |
| 17:43:13.851 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004) |
| 17:43:13.852 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3814 |
| 17:43:13.853 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3814 |
| 17:43:13.853 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 17:43:13.855 | info | yii\db\Command::execute | |
| 17:43:13.855 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 17:43:13.857 | info | yii\db\Command::execute | |
| 17:43:13.872 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "client_id"=2815, "project_status"=1, "project_progress"=9, "budget"='0', "profit_pct"='0', "updated_at"='now()', "contract_type"=1, "used_client"=NULL, "from_contact"=NULL WHERE "id"=3814 |
| 17:43:13.885 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3814) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:43:13.896 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:43:13.896 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:43:13.897 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:43:13.897 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:43:13.898 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3814, 'a:0:{}', '', 1000, '223.104.41.148') |
| 17:43:13.908 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815' |
| 17:43:13.909 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:43:13.910 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:43:13.910 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 17:43:13.910 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3814 |
| 17:43:13.911 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (1, 165, 135, 140, 172, 197, 199, 377)) ORDER BY "sort" |
| 17:43:13.911 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=165 |
| 17:43:13.912 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='165' |
| 17:43:13.912 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3814) AND ("term_id"=9) |
| 17:43:13.913 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:43:13.913 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:43:13.913 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (9, 165, 3814) |
| 17:43:13.920 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=172 |
| 17:43:13.921 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='172' |
| 17:43:13.921 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3814) AND ("term_id"=13) |
| 17:43:13.922 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (13, 172, 3814) |
| 17:43:13.923 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3814 |
| 17:43:13.924 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:43:13.924 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:43:13.924 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3814 |
| 17:43:13.925 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_project_remind_receivers" ("project_id", "user_id") VALUES (3814, 1001) RETURNING "id" |
| 17:43:13.929 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectRemindReceivers', 1609, 'a:3:{s:2:"id";i:1609;s:10:"project_id";i:3814;s:7:"user_id";s:4:"1001";}', '', 1000, '223.104.41.148') |
| 17:43:13.930 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3814 |
| 17:43:13.933 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815' |
| 17:43:13.933 | info | yii\db\Command::query | SELECT 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"=2815) |
| 17:43:13.936 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2815) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:43:13.960 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:43:13.960 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:43:13.960 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2815, 1004, 'now()', NULL) RETURNING "id" |
| 17:43:13.966 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 165015, 'a:5:{s:2:"id";i:165015;s:9:"client_id";i:2815;s:9:"sales_rep";i:1004;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1000, '223.104.41.148') |
| 17:43:13.967 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 2815, 'a:0:{}', '', 1000, '223.104.41.148') |
| 17:43:13.975 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: INCR |
| 17:43:13.975 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: HSET |
| 17:43:13.975 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: LPUSH |
| 17:43:13.976 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: INCR |
| 17:43:13.976 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: HSET |
| 17:43:13.976 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: LPUSH |
| 17:43:13.976 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:43:13.976 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:43:13.976 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 2, 1141, 'v2/project/save-edit', '{"Projects":{"bargain_date":"2025-09-30","client_id":"2815","comment":"\u4f60\u90fd\u4e0d\u5403\u5427","contract_type":"1","from_contact":"","id":"3814","projectProductTypes":"","projectRemindReceivers":["1001"],"project_progress":"9","project_status":"1","project_title":"\u51e0\u8282\u8bfe","purchaseType":"165","salesForecast":"172","used_client":""},"access_token":"rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u","device_type":"2","posttime":"1751276544","token":"f9dfe10cf5531f54b988c455da83c410","version_code":"1141"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u5546\u673a\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-06-30 17:43:13') RETURNING "id" |