10:03:44.614 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
10:03:44.614 | trace | yii\base\Module::getModule | Loading module: debug |
10:03:44.614 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
10:03:44.614 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
10:03:44.615 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
10:03:44.615 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:03:44.615 | trace | yii\base\Module::getModule | Loading module: gii |
10:03:44.615 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
10:03:44.615 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
10:03:44.615 | trace | yii\web\Application::handleRequest | Route requested: 'v2/project/save-edit' |
10:03:44.615 | trace | yii\base\Module::getModule | Loading module: v2 |
10:03:44.615 | info | yii\web\Session::open | Session started |
10:03:44.616 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
10:03:44.618 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH' |
10:03:44.621 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:03:44.621 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
10:03:44.621 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:03:44.621 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
10:03:44.621 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
10:03:44.623 | trace | yii\base\Controller::runAction | Route to run: v2/project/save-edit |
10:03:44.623 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:03:44.624 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
10:03:44.624 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\ProjectController::actionSaveEdit() |
10:03:44.624 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3817' |
10:03:44.625 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:03:44.625 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
10:03:44.625 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:03:44.625 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:03:44.626 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'id' in 'app\models\Projects'. |
10:03:44.626 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'projectProductTypes' in 'app\models\Projects'. |
10:03:44.626 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'projectRemindReceivers' in 'app\models\Projects'. |
10:03:44.626 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'purchaseType' in 'app\models\Projects'. |
10:03:44.626 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'salesForecast' in 'app\models\Projects'. |
10:03:44.626 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'id' in 'app\models\Projects'. |
10:03:44.626 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'projectProductTypes' in 'app\models\Projects'. |
10:03:44.626 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'projectRemindReceivers' in 'app\models\Projects'. |
10:03:44.626 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'purchaseType' in 'app\models\Projects'. |
10:03:44.626 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'salesForecast' in 'app\models\Projects'. |
10:03:44.626 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3817 |
10:03:44.627 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (5, 226, 129, 160, 142, 184, 189, 349)) ORDER BY "sort" |
10:03:44.628 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:03:44.628 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
10:03:44.628 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='2815') AND ("project_title"='离开就好') AND ("id" != 3817)) |
10:03:44.629 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1') |
10:03:44.629 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815') |
10:03:44.630 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"='6') |
10:03:44.630 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='1') |
10:03:44.631 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004) |
10:03:44.631 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3817 |
10:03:44.632 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3817 |
10:03:44.632 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
10:03:44.633 | info | yii\db\Command::execute | |
10:03:44.633 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
10:03:44.634 | info | yii\db\Command::execute | |
10:03:44.634 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "client_id"=2815, "project_status"=1, "project_progress"=6, "budget"='0', "profit_pct"='0', "updated_at"='now()', "contract_type"=1, "used_client"=NULL, "from_contact"=NULL WHERE "id"=3817 |
10:03:44.636 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3817) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
10:03:44.638 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:03:44.638 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
10:03:44.638 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:03:44.638 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
10:03:44.638 | 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', 3817, 'a:0:{}', '', 1000, '223.104.40.121') |
10:03:44.639 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815' |
10:03:44.640 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:03:44.640 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
10:03:44.640 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
10:03:44.641 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3817 |
10:03:44.641 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (5, 226, 129, 160, 142, 184, 189, 349)) ORDER BY "sort" |
10:03:44.641 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=129 |
10:03:44.642 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='129' |
10:03:44.642 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3817) AND ("term_id"=9) |
10:03:44.643 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:03:44.643 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
10:03:44.643 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (9, 129, 3817) |
10:03:44.644 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=142 |
10:03:44.644 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='142' |
10:03:44.645 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3817) AND ("term_id"=13) |
10:03:44.645 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (13, 142, 3817) |
10:03:44.646 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3817 |
10:03:44.647 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:03:44.647 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
10:03:44.647 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3817 |
10:03:44.648 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_project_remind_receivers" ("project_id", "user_id") VALUES (3817, 1017) RETURNING "id" |
10:03:44.649 | 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', 1621, 'a:3:{s:2:"id";i:1621;s:10:"project_id";i:3817;s:7:"user_id";s:4:"1017";}', '', 1000, '223.104.40.121') |
10:03:44.650 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3817 |
10:03:44.651 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815' |
10:03:44.651 | 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) |
10:03:44.652 | 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 |
10:03:44.664 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:03:44.664 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
10:03:44.664 | 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" |
10:03:44.666 | 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', 165239, 'a:5:{s:2:"id";i:165239;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.40.121') |
10:03:44.666 | 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.40.121') |
10:03:44.668 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: INCR |
10:03:44.668 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: HSET |
10:03:44.668 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: LPUSH |
10:03:44.668 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: INCR |
10:03:44.668 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: HSET |
10:03:44.668 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: LPUSH |
10:03:44.668 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:03:44.668 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
10:03:44.668 | 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-11","client_id":"2815","comment":"","contract_type":"1","from_contact":"","id":"3817","projectProductTypes":"","projectRemindReceivers":["1017"],"project_progress":"6","project_status":"1","project_title":"\u79bb\u5f00\u5c31\u597d","purchaseType":"129","salesForecast":"142","used_client":""},"access_token":"oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH","device_type":"2","posttime":"1752199424","token":"a386c0a40cdf1fccb239f6051671cadd","version_code":"1141"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u5546\u673a\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-07-11 10:03:44') RETURNING "id" |