6a577f540c359: POST https://beta.jinchangxiao.com/v2/contact/of-supplier at 2026-07-15 08:38:44 pm by 111.9.5.127
Log Messages
总计42条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 20:38:44.049 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 20:38:44.049 | trace | yii\base\Module::getModule | Loading module: debug |
| 20:38:44.049 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 20:38:44.050 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 20:38:44.050 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 20:38:44.050 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:38:44.050 | info | time tracing start | 1784119124050920960 |
| 20:38:44.051 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 20:38:44.051 | trace | yii\web\Application::handleRequest | Route requested: 'v2/contact/of-supplier' |
| 20:38:44.051 | trace | yii\base\Module::getModule | Loading module: v2 |
| 20:38:44.108 | info | yii\web\Session::open | Session started |
| 20:38:44.110 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 20:38:44.111 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm' |
| 20:38:44.112 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:38:44.112 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:38:44.112 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:38:44.113 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:38:44.113 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 20:38:44.114 | trace | yii\base\Controller::runAction | Route to run: v2/contact/of-supplier |
| 20:38:44.114 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:38:44.116 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 20:38:44.116 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\ContactController::actionOfSupplier() |
| 20:38:44.116 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='138' |
| 20:38:44.116 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:38:44.116 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:38:44.117 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT c.* FROM "a57be577deb434"."tbl_contacts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id WHERE "supplier"."id"='138' GROUP BY "c"."id" ORDER BY (case c.user_status when 3 then 1 when 1 then 0 else c.user_status end) DESC, c.updated_at DESC) "c" |
| 20:38:44.119 | info | yii\db\Command::query | SELECT c.* FROM "a57be577deb434"."tbl_contacts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id WHERE "supplier"."id"='138' GROUP BY "c"."id" ORDER BY (case c.user_status when 3 then 1 when 1 then 0 else c.user_status end) DESC, c.updated_at DESC LIMIT 10 |
| 20:38:44.121 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:38:44.121 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:38:44.121 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id"=2 |
| 20:38:44.122 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360, 5023) |
| 20:38:44.123 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_contact_key_roles" WHERE "contact_id" IN (6025, 5179, 3386, 5020, 4608, 4534, 4505, 4154, 4132, 3533) ORDER BY "key_role" |
| 20:38:44.123 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (6025, 5179, 3386, 5020, 4608, 4534, 4505, 4154, 4132, 3533) |
| 20:38:44.125 | info | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=14) AND ("object_id" IN (6025, 5179, 3386, 5020, 4608, 4534, 4505, 4154, 4132, 3533)) GROUP BY "object_id" |
| 20:38:44.147 | info | yii\db\Command::query | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=14) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (6025, 5179, 3386, 5020, 4608, 4534, 4505, 4154, 4132, 3533)) GROUP BY "object_id" |
| 20:38:44.164 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:38:44.165 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:38:44.166 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: deleteSupplierContact |
| 20:38:44.166 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 20:38:44.168 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:38:44.168 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:38:44.169 | 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", "duration") VALUES (200, 'a57be577deb434', 1000, 2, 1161, 'v2/contact/of-supplier', '{"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","device_type":"2","id":"138","posttime":"1784119168","token":"cd4727534313b63fdece2b32bcb917c4","version_code":"1161"}', '{"code":200,"data":{"list":[{"id":6025,"name":"\u4e54\u5bff\u51ef","email":"qiaoshoukai@sangfor.com.cn","pinyin_shortcut":"qsk","sex":"M","birth_date":null,"department":"\u5546\u4e1a\u5e02\u573a","job_position":"\u9500\u552e","mobile":"","telephone":"","client_id":null,"supplier_id":138,"created_by":1011,"created_at":"2025-04-02 14:43:39","updated_at":"2025-04-02 14:45:25","user_status":2,"description":"\u53e6\u4e00\u4e2a\u7535\u8bdd\uff1a15095198179","contact_type":"2","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"qiao","pinyin2":"shou","pinyin3":"kai","pinyin4":null,"namecut1":"\u4e54","namecut2":"\u5bff","namecut3":"\u51ef","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1011,"email":"hanyafang@toast.com.cn","name":"\u97e9\u96c5\u82b3","user_status":"1","pinyin_shortcut":"hyf","sex":"F","birth_date":"1987-03-07","entry_date":"2011-08-08","department_id":3,"department_position_id":18,"mobile":"13126639155","telephone":"88864628","created_at":"2017-02-06 13:11:52","updated_at":"2024-11-01 17:28:04","id_number":"131128198703076043","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u6cb3\u5317\u5eca\u574a\u5e08\u8303\u5b66\u9662","specialty":"\u751f\u7269\u6280\u672f\u5de5\u7a0b","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"831","leave_date":null,"pinyin1":"han","pinyin2":"ya","pinyin3":"fang","pinyin4":null,"namecut1":"\u97e9","namecut2":"\u96c5","namecut3":"\u82b3","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true},"keyRoles":[],"mobiles":[{"id":6807,"contact_id":6025,"mobile":"13321131975","mp_open_id":null}],"commentCount":null,"unreadComments":null,"can_update":true,"can_delete":true,"unread":0},{"id":5179,"name":"\u674e\u51ef","email":"likai30418@sangfor.com.cn","pinyin_shortcut":"lk","sex":"M","birth_date":null,"department":"\u5546\u4e1a\u4e09\u7ec4","job_position":"\u6e20\u9053\u7ecf\u7406","mobile":"","telephone":"","client_id":null,"supplier_id":138,"created_by":1011,"created_at":"2024-01-23 09:22:57","updated_at":"2024-01-23 13:27:16","user_status":2,"description":"","contact_type":"2","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"li","pinyin2":"kai","pinyin3":null,"pinyin4":null,"namecut1":"\u674e","namecut2":"\u51ef","namecut3":null,"namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1011,"email":"hanyafang@toast.com.cn","name":"\u97e9\u96c5\u82b3","user_status":"1","pinyin_shortcut":"hyf","sex":"F","birth_date":"1987-03-07","entry_date":"2011-08-08","department_id":3,"department_position_id":18,"mobile":"13126639155","telephone":"88864628","created_at":"2017-02-06 13:11:52","updated_at":"2024-11-01 17:28:04","id_number":"131128198703076043","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u6cb3\u5317\u5eca\u574a\u5e08\u8303\u5b66\u9662","specialty":"\u751f\u7269\u6280\u672f\u5de5\u7a0b","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"831","leave_date":null,"pinyin1":"han","pinyin2":"ya","pinyin3":"fang","pinyin4":null,"namecut1":"\u97e9","namecut2":"\u96c5","namecut3":"\u82b3","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true},"keyRoles":[],"mobiles":[{"id":5967,"contact_id":5179,"mobile":"13810362028","mp_open_id":null}],"commentCount":null,"unreadComments":null,"can_update":true,"can_delete":true,"unread":0},{"id":3386,"name":"\u5b5f\u5f3a","email":"","pinyin_shortcut":"mq","sex":"M","birth_date":null,"department":"\u5546\u4e1a\u4e8c\u7ec4\u7ec4\u957f","job_position":"\u9500\u552e","mobile":"","telephone":"","client_id":null,"supplier_id":138,"created_by":1011,"created_at":"2020-10-27 14:31:39","updated_at":"2024-01-23 13:26:56","user_status":2,"description":"","contact_type":"2","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"meng","pinyin2":"qiang","pinyin3":null,"pinyin4":null,"namecut1":"\u5b5f","namecut2":"\u5f3a","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1011,"email":"hanyafang@toast.com.cn","name":"\u97e9\u96c5\u82b3","user_status":"1","pinyin_shortcut":"hyf","sex":"F","birth_date":"1987-03-07","entry_date":"2011-08-08","department_id":3,"department_position_id":18,"mobile":"13126639155","telephone":"88864628","created_at":"2017-02-06 13:11:52","updated_at":"2024-11-01 17:28:04","id_number":"131128198703076043","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u6cb3\u5317\u5eca\u574a\u5e08\u8303\u5b66\u9662","specialty":"\u751f\u7269\u6280\u672f\u5de5\u7a0b","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"831","leave_date":null,"pinyin1":"han","pinyin2":"ya","pinyin3":"fang","pinyin4":null,"namecut1":"\u97e9","namecut2":"\u96c5","namecut3":"\u82b3","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true},"keyRoles":[],"mobiles":[{"id":3818,"contact_id":3386,"mobile":"13810979012","mp_open_id":null}],"commentCount":null,"unreadComments":null,"can_update":true,"can_delete":true,"unread":0},{"id":5020,"name":"\u90d1\u6cfd\u5b99","email":"zhengzezhou@sangfor.com.cn","pinyin_shortcut":"zzz","sex":"M","birth_date":null,"department":"\u5317\u4eac\u533a","job_position":"\u5546\u4e1a\u4e09\u7ec4\u7ec4\u957f","mobile":"","telephone":"","client_id":null,"supplier_id":138,"created_by":5360,"created_at":"2023-11-06 15:55:36","updated_at":"2023-11-06 15:55:36","user_status":2,"description":"","contact_type":"2","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"zheng","pinyin2":"ze","pinyin3":"zhou","pinyin4":null,"namecut1":"\u90d1","namecut2":"\u6cfd","namecut3":"\u5b99","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":5360,"email":"zhanghongfang@toast.com.cn","name":"\u5f20\u7ea2\u82b3","user_status":"1","pinyin_shortcut":"zhf","sex":"F","birth_date":"1997-04-07","entry_date":"2023-04-24","department_id":3,"department_position_id":60,"mobile":"18660100116","telephone":"88864628","created_at":"2023-04-24 09:37:05","updated_at":"2023-04-25 06:04:57","id_number":"371421199704072969","native_place":"\u5c71\u4e1c\u7701\u9675\u53bf","graduate_school":"\u5c71\u4e1c\u5e08\u8303\u5927\u5b66","specialty":"\u8ba1\u7b97\u673a\u7f51\u8def\u6280\u672f","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"819","leave_date":null,"pinyin1":"zhang","pinyin2":"hong","pinyin3":"fang","pinyin4":null,"namecut1":"\u5f20","namecut2":"\u7ea2","namecut3":"\u82b3","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true},"keyRoles":[],"mobiles":[{"id":5816,"contact_id":5020,"mobile":"17801562391","mp_open_id":null}],"commentCount":null,"unreadComments":null,"can_update":true,"can_delete":true,"unread":0},{"id":4608,"name":"\u674e\u6625\u6d69","email":"lichunhao@sangfor.com.cn","pinyin_shortcut":"lch","sex":"M","birth_date":null,"department":"\u5317\u4eac\u529e\u56fd\u4f01\u7ec4","job_position":"\u884c\u4e1a\u9500\u552e\u7ecf\u7406","mobile":"","telephone":"","client_id":null,"supplier_id":138,"created_by":5360,"created_at":"2023-04-28 14:58:08","updated_at":"2023-04-28 14:58:08","user_status":2,"description":"\u8d1f\u8d23\u7ea2\u661f\u7528\u6237","contact_type":"2","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"li","pinyin2":"chun","pinyin3":"hao","pinyin4":null,"namecut1":"\u674e","namecut2":"\u6625","namecut3":"\u6d69","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":5360,"email":"zhanghongfang@toast.com.cn","name":"\u5f20\u7ea2\u82b3","user_status":"1","pinyin_shortcut":"zhf","sex":"F","birth_date":"1997-04-07","entry_date":"2023-04-24","department_id":3,"department_position_id":60,"mobile":"18660100116","telephone":"88864628","created_at":"2023-04-24 09:37:05","updated_at":"2023-04-25 06:04:57","id_number":"371421199704072969","native_place":"\u5c71\u4e1c\u7701\u9675\u53bf","graduate_school":"\u5c71\u4e1c\u5e08\u8303\u5927\u5b66","specialty":"\u8ba1\u7b97\u673a\u7f51\u8def\u6280\u672f","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"819","leave_date":null,"pinyin1":"zhang","pinyin2":"hong","pinyin3":"fang","pinyin4":null,"namecut1":"\u5f20","namecut2":"\u7ea2","namecut3":"\u82b3","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true},"keyRoles":[],"mobiles":[{"id":5418,"contact_id":4608,"mobile":"15900221828","mp_open_id":null},{"id":5419,"contact_id":4608,"mobile":"19910030505","mp_open_id":null}],"commentCount":null,"unreadComments":null,"can_update":true,"can_delete":true,"unread":0},{"id":4534,"name":"\u6b66\u5af1\u6587","email":"wuqiangwen@sangfor.com.cn","pinyin_shortcut":"wqw","sex":"F","birth_date":null,"department":"\u884c\u4e1a\u603b\u90e8\u670d\u52a1\u90e8","job_position":"\u670d\u52a1\u9500\u552e\u7ecf\u7406","mobile":"","telephone":"","client_id":null,"supplier_id":138,"created_by":1011,"created_at":"2023-03-16 08:52:44","updated_at":"2023-03-16 08:52:44","user_status":2,"description":"\u624b\u673a\uff1a13651130103","contact_type":"2","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"wu","pinyin2":"qiang","pinyin3":"wen","pinyin4":null,"namecut1":"\u6b66","namecut2":"\u5af1","namecut3":"\u6587","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1011,"email":"hanyafang@toast.com.cn","name":"\u97e9\u96c5\u82b3","user_status":"1","pinyin_shortcut":"hyf","sex":"F","birth_date":"1987-03-07","entry_date":"2011-08-08","department_id":3,"department_position_id":18,"mobile":"13126639155","telephone":"88864628","created_at":"2017-02-06 13:11:52","updated_at":"2024-11-01 17:28:04","id_number":"131128198703076043","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u6cb3\u5317\u5eca\u574a\u5e08\u8303\u5b66\u9662","specialty":"\u751f\u7269\u6280\u672f\u5de5\u7a0b","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"831","leave_date":null,"pinyin1":"han","pinyin2":"ya","pinyin3":"fang","pinyin4":null,"namecut1":"\u97e9","namecut2":"\u96c5","namecut3":"\u82b3","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true},"keyRoles":[],"mobiles":[{"id":5348,"contact_id":4534,"mobile":"13613535443","mp_open_id":null}],"commentCount":null,"unreadComments":null,"can_update":true,"can_delete":true,"unread":0},{"id":4505,"name":"\u738b\u5b50\u61ff","email":"wangziyi@sangfor.com.cn","pinyin_shortcut":"wzy","sex":"M","birth_date":null,"department":"\u5317\u4eac\u529e\u6559\u80b2\u7ec4","job_position":"\u884c\u4e1a\u9500\u552e\u7ecf\u7406","mobile":"","telephone":"","client_id":null,"supplier_id":138,"created_by":1011,"created_at":"2023-02-24 17:06:00","updated_at":"2023-02-24 17:06:00","user_status":2,"description":"\u4e2d\u56fd\u79d1\u5b66\u9662\u5927\u5b66\u8d1f\u8d23\u4eba","contact_type":"2","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"wang","pinyin2":"zi","pinyin3":"yi","pinyin4":null,"namecut1":"\u738b","namecut2":"\u5b50","namecut3":"\u61ff","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1011,"email":"hanyafang@toast.com.cn","name":"\u97e9\u96c5\u82b3","user_status":"1","pinyin_shortcut":"hyf","sex":"F","birth_date":"1987-03-07","entry_date":"2011-08-08","department_id":3,"department_position_id":18,"mobile":"13126639155","telephone":"88864628","created_at":"2017-02-06 13:11:52","updated_at":"2024-11-01 17:28:04","id_number":"131128198703076043","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u6cb3\u5317\u5eca\u574a\u5e08\u8303\u5b66\u9662","specialty":"\u751f\u7269\u6280\u672f\u5de5\u7a0b","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"831","leave_date":null,"pinyin1":"han","pinyin2":"ya","pinyin3":"fang","pinyin4":null,"namecut1":"\u97e9","namecut2":"\u96c5","namecut3":"\u82b3","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true},"keyRoles":[],"mobiles":[{"id":5319,"contact_id":4505,"mobile":"13311291529","mp_open_id":null}],"commentCount":null,"unreadComments":null,"can_update":true,"can_delete":true,"unread":0},{"id":4154,"name":"\u4e01\u4e2d\u8d24","email":"","pinyin_shortcut":"dzx","sex":"M","birth_date":null,"department":"","job_position":"\u5ba2\u6237\u7ecf\u7406","mobile":"","telephone":"","client_id":null,"supplier_id":138,"created_by":1011,"created_at":"2022-10-10 16:22:07","updated_at":"2022-10-10 16:22:07","user_status":2,"description":"\u8d1f\u8d23\u91cd\u578b\u673a\u68b0","contact_type":"2","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"ding","pinyin2":"zhong","pinyin3":"xian","pinyin4":null,"namecut1":"\u4e01","namecut2":"\u4e2d","namecut3":"\u8d24","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1011,"email":"hanyafang@toast.com.cn","name":"\u97e9\u96c5\u82b3","user_status":"1","pinyin_shortcut":"hyf","sex":"F","birth_date":"1987-03-07","entry_date":"2011-08-08","department_id":3,"department_position_id":18,"mobile":"13126639155","telephone":"88864628","created_at":"2017-02-06 13:11:52","updated_at":"2024-11-01 17:28:04","id_number":"131128198703076043","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u6cb3\u5317\u5eca\u574a\u5e08\u8303\u5b66\u9662","specialty":"\u751f\u7269\u6280\u672f\u5de5\u7a0b","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"831","leave_date":null,"pinyin1":"han","pinyin2":"ya","pinyin3":"fang","pinyin4":null,"namecut1":"\u97e9","namecut2":"\u96c5","namecut3":"\u82b3","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true},"keyRoles":[],"mobiles":[{"id":4980,"contact_id":4154,"mobile":"13011066327","mp_open_id":null}],"commentCount":null,"unreadComments":null,"can_update":true,"can_delete":true,"unread":0},{"id":4132,"name":"\u9ad8\u96f7","email":"","pinyin_shortcut":"gl","sex":"M","birth_date":null,"department":"\u770b\u8d1d\u745e","job_position":"","mobile":"","telephone":"","client_id":null,"supplier_id":138,"created_by":1011,"created_at":"2022-09-14 13:47:32","updated_at":"2022-09-14 13:47:32","user_status":2,"description":"","contact_type":"2","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"gao","pinyin2":"lei","pinyin3":null,"pinyin4":null,"namecut1":"\u9ad8","namecut2":"\u96f7","namecut3":null,"namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1011,"email":"hanyafang@toast.com.cn","name":"\u97e9\u96c5\u82b3","user_status":"1","pinyin_shortcut":"hyf","sex":"F","birth_date":"1987-03-07","entry_date":"2011-08-08","department_id":3,"department_position_id":18,"mobile":"13126639155","telephone":"88864628","created_at":"2017-02-06 13:11:52","updated_at":"2024-11-01 17:28:04","id_number":"131128198703076043","native_place":"\u6cb3\u5317\u7701\u8861\u6c34\u5e02","graduate_school":"\u6cb3\u5317\u5eca\u574a\u5e08\u8303\u5b66\u9662","specialty":"\u751f\u7269\u6280\u672f\u5de5\u7a0b","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"831","leave_date":null,"pinyin1":"han","pinyin2":"ya","pinyin3":"fang","pinyin4":null,"namecut1":"\u97e9","namecut2":"\u96c5","namecut3":"\u82b3","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true},"keyRoles":[],"mobiles":[{"id":4959,"contact_id":4132,"mobile":"13104423343","mp_open_id":null}],"commentCount":null,"unreadComments":null,"can_update":true,"can_delete":true,"unread":0},{"id":3533,"name":"\u90ed\u7693\u741b","email":"","pinyin_shortcut":"ghc","sex":"M","birth_date":null,"department":"\u9500\u552e\u90e8\u2014\u592e\u4f01","job_position":"","mobile":"","telephone":"","client_id":null,"supplier_id":138,"created_by":5023,"created_at":"2021-02-04 09:20:25","updated_at":"2022-09-14 13:46:38","user_status":2,"description":"\u5546\u52a1\u5408\u540c\u8054\u7cfb\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u5317\u4e09\u73af\u4e2d\u8def43\u53f7\u966219\u53f7\u697c\u6df1\u4fe1\u670d\u79d1\u6280\u5317\u4eac\u603b\u90e8\u674e\u79c0\u4e3d176 9597 5956","contact_type":"2","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"guo","pinyin2":"hao","pinyin3":"chen","pinyin4":null,"namecut1":"\u90ed","namecut2":"\u7693","namecut3":"\u741b","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":5023,"email":"60c33652136bd_xujingnan@toast.com.cn","name":"\u5f90\u4eac\u5357","user_status":"-1","pinyin_shortcut":"xjn","sex":"F","birth_date":"1987-05-18","entry_date":"2017-09-04","department_id":3,"department_position_id":18,"mobile":"60c3365213702_13466320295","telephone":"88864628","created_at":"2017-09-06 11:34:45","updated_at":"2021-06-11 18:09:22","id_number":"110109198705180027","native_place":"\u5317\u4eac","graduate_school":"\u5317\u4eac\u7535\u5b50\u79d1\u6280\u804c\u4e1a\u5b66\u9662","specialty":"\u56fd\u9645\u5546\u52a1\uff08\u7269\u6d41\uff09","education":"\u4e13\u79d1","telephone_area_code":"","telephone_extension_number":"819","leave_date":"2021-06-11","pinyin1":"xu","pinyin2":"jing","pinyin3":"nan","pinyin4":null,"namecut1":"\u5f90","namecut2":"\u4eac","namecut3":"\u5357","namecut4":null,"budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":false,"client_remind_alarm_before":null,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"view_product_cost":true},"keyRoles":[],"mobiles":[{"id":4075,"contact_id":3533,"mobile":"13391502173","mp_open_id":null}],"commentCount":null,"unreadComments":null,"can_update":true,"can_delete":true,"unread":0}],"pagenation":{"totalcount":48,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"111.9.5.127","ua":"jinchangxiao\/2.3.158 (iPhone 12 mini; iOS 26.2; Scale\/3.00)"}', FALSE, '2026-07-15 20:38:44', 117975040) RETURNING "id" |