10:08:53.119 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
10:08:53.119 | trace | yii\base\Module::getModule | Loading module: debug |
10:08:53.120 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
10:08:53.120 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
10:08:53.120 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
10:08:53.120 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:08:53.120 | trace | yii\base\Module::getModule | Loading module: gii |
10:08:53.120 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
10:08:53.121 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
10:08:53.121 | trace | yii\web\Application::handleRequest | Route requested: 'v2/contact/save-edit' |
10:08:53.121 | trace | yii\base\Module::getModule | Loading module: v2 |
10:08:53.121 | info | yii\web\Session::open | Session started |
10:08:53.122 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
10:08:53.124 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH' |
10:08:53.128 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:08:53.129 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
10:08:53.129 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:08:53.129 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
10:08:53.129 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
10:08:53.131 | trace | yii\base\Controller::runAction | Route to run: v2/contact/save-edit |
10:08:53.131 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:08:53.133 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
10:08:53.133 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\ContactController::actionSaveEdit() |
10:08:53.133 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"='6012' |
10:08:53.134 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:08:53.134 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
10:08:53.134 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=689 |
10:08:53.135 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:08:53.135 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
10:08:53.135 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: updateSupplierContact |
10:08:53.135 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Accountant |
10:08:53.135 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
10:08:53.136 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'id' in 'app\models\Contacts'. |
10:08:53.136 | info | yii\db\Command::query | SELECT "c".* FROM "a57be577deb434"."tbl_contacts" "c" LEFT JOIN "a57be577deb434"."tbl_contact_mobiles" "cm" ON c.id = cm.contact_id WHERE ("client_id" IS NULL) AND (client_id is not null) AND ("c"."id" != 6012) AND ("cm"."mobile"='13000000000') AND ("c"."user_status" != 1) GROUP BY "c"."id" |
10:08:53.139 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id"='2') |
10:08:53.139 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='689') |
10:08:53.140 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000) |
10:08:53.140 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:08:53.141 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
10:08:53.141 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'contact.description', '689', 12, 1000, 'now()', '["\u5b9d\u8d1d\u5a1c\u5a1c"]', '[""]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5907\u6ce8(\u9e21\u86cb\u9171)","d4":["\u5b9d\u8d1d\u5a1c\u5a1c"]}') |
10:08:53.144 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id"='2') |
10:08:53.144 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='689') |
10:08:53.145 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000) |
10:08:53.147 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_contacts" SET "birth_date"=NULL, "supplier_id"=689, "updated_at"='now()', "user_status"=2, "description"='宝贝娜娜' WHERE "id"=6012 |
10:08:53.149 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:08:53.149 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
10:08:53.149 | 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\Contacts', 6012, 'a:1:{s:11:"description";s:12:"宝贝娜娜";}', '', 1000, '223.104.40.121') |
10:08:53.151 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='689' |
10:08:53.151 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id"=6012 |
10:08:53.152 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:08:53.152 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
10:08:53.152 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_contact_mobiles" WHERE ("contact_id"=6012) AND ("mobile"<>'13000000000') |
10:08:53.153 | info | yii\db\Command::execute | |
10:08:53.154 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=6012 |
10:08:53.154 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (1, 184, 189, 349)) ORDER BY "sort" |
10:08:53.155 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=6012) AND ("term_id"=11) |
10:08:53.156 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=6012 |
10:08:53.156 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (1, 184, 189, 349)) ORDER BY "sort" |
10:08:53.157 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=6012) AND ("term_id"=12) |
10:08:53.157 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
10:08:53.157 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
10:08:53.157 | 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/contact/save-edit', '{"Contacts":{"birth_date":"","department":"","description":"\u5b9d\u8d1d\u5a1c\u5a1c","email":"","id":"6012","job_position":"","mobiles":["13000000000"],"name":"\u9e21\u86cb\u9171","sex":"M","supplier_id":"689","telephone":"","telephone_area_code":"","telephone_extension_number":"","user_status":"2"},"access_token":"oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH","device_type":"2","posttime":"1752199680","token":"d6de01774c3f76d8188d03aa0b37b625","version_code":"1141"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u8054\u7cfb\u4eba\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-07-11 10:08:53') RETURNING "id" |