ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a55ea203ba78: POST https://beta.jinchangxiao.com/v2/client/get-edit at 2026-07-14 03:49:52 pm by 39.156.194.178

Log Messages

总计82条数据
TimeLevelCategoryMessage
 
15:49:52.243traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
15:49:52.243traceyii\base\Module::getModuleLoading module: debug
15:49:52.243traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
15:49:52.244traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
15:49:52.245traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
15:49:52.245traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:49:52.245infotime tracing start1784015392245865216
15:49:52.246traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
15:49:52.246traceyii\web\Application::handleRequestRoute requested: 'v2/client/get-edit'
15:49:52.246traceyii\base\Module::getModuleLoading module: v2
15:49:52.247infoyii\web\Session::openSession started
15:49:52.249infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:49:52.249infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm'
15:49:52.251traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:49:52.252traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:49:52.252traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:49:52.253traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:49:52.253infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:49:52.254traceyii\base\Controller::runActionRoute to run: v2/client/get-edit
15:49:52.254traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\ClientController::actionGetEdit()
15:49:52.255infoyii\db\Command::querySELECT DISTINCT c.*, CASE WHEN c.sales_rep IS NULL THEN 0 ELSE c.sales_rep END AS sales_rep, CASE WHEN c.sales_rep IS NULL THEN 0 ELSE 1 END AS is_public, CASE WHEN p.id IS NULL THEN false ELSE true END AS cooperated, sl_agg.lost_contact_days, arrive_agg.last_arrive_days, sl_agg.last_contact, cc.notice_days AS notice_days FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN (SELECT client_id, extract(epoch from (now() - max(end_at))) / 86400 AS last_arrive_days FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL) AND ("client_id"='1188') GROUP BY "client_id") "arrive_agg" ON arrive_agg.client_id = c.id LEFT JOIN (SELECT client_id, extract(epoch from (now() - max(end_at))) / 86400 AS lost_contact_days, max(end_at) as last_contact FROM "a57be577deb434"."tbl_work_logs" WHERE "client_id"='1188' GROUP BY "client_id") "sl_agg" ON sl_agg.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.client_id = c.id AND p.project_status = 3 LEFT JOIN "a57be577deb434"."tbl_client_classes" "cc" ON cc.id = c.client_class WHERE ("c"."id"='1188') AND ("c"."deleted"=FALSE)
15:49:52.263traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:49:52.263traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:49:52.266infoyii\db\Command::querySELECT *, geolocation[0] AS lng, geolocation[1] AS lat FROM "a57be577deb434"."tbl_addresses" WHERE "id"=1612
15:49:52.268infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id"=6
15:49:52.268infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_company_natures" WHERE "id"=1
15:49:52.269infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id"=16
15:49:52.269infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "client_lock" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
15:49:52.270infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)
15:49:52.271infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=1188
15:49:52.272infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=14) AND ("id" IN (11, 5, 229, 212, 97, 128, 179, 135, 136, 140, 173, 153, 185, 191, 319, 369)) ORDER BY "sort"
15:49:52.273infoyii\db\Command::querySELECT "id", "client_id" FROM "a57be577deb434"."tbl_cases" WHERE ("case_status" NOT IN (5, 6)) AND ("client_id"=1188)
15:49:52.275infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5096
15:49:52.276infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5096)
15:49:52.276infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
15:49:52.277infoyii\db\Command::querySELECT "client_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("client_id"=1188) GROUP BY "client_id"
15:49:52.278infoyii\db\Command::querySELECT "client_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "client_id"=1188 GROUP BY "client_id"
15:49:52.279infoyii\db\Command::querySELECT "client_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=1) AND (("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL)) AND ("client_id"=1188) GROUP BY "client_id"
15:49:52.280infoyii\db\Command::querySELECT "c"."client_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(left_at - arrived_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_implement_records" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=2) AND ("c"."client_id"=1188) GROUP BY "c"."client_id"
15:49:52.283infoyii\db\Command::querySELECT "c"."client_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_pre_sales" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=1) AND ("c"."client_id"=1188) GROUP BY "c"."client_id"
15:49:52.286traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:49:52.287traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:49:52.287infoyii\db\Command::querySELECT "client_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=2) AND ("client_id"=1188) GROUP BY "client_id"
15:49:52.288infoyii\db\Command::querySELECT "client_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("client_id"=1188) GROUP BY "client_id"
15:49:52.291infoyii\db\Command::querySELECT "id", "id" AS "key", "address" AS "name", "client_id" FROM "a57be577deb434"."tbl_client_addresses" WHERE "client_id"=1188
15:49:52.292infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "client_id"=1188
15:49:52.294infoyii\db\Command::querySELECT "id", "id" AS "key", "status" AS "name" FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id" IN (2, 1)
15:49:52.295infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5026, 5096)
15:49:52.295infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (3794, 3795, 2374, 2963)
15:49:52.296infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3794, 3795, 2374, 2963)
15:49:52.297infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (2, 164, 179, 136, 140, 142, 153, 197, 199, 2100000000, 377, 354, 215, 177, 184, 189, 349, 181, 369, 1, 165)) ORDER BY "sort"
15:49:52.298infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3794, 3795, 2374, 2963)
15:49:52.298infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (2, 164, 179, 136, 140, 142, 153, 197, 199, 2100000000, 377, 354, 215, 177, 184, 189, 349, 181, 369, 1, 165)) ORDER BY "sort"
15:49:52.299infoyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=10) AND ("object_id"=1188) GROUP BY "object_id"
15:49:52.350infoyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=10) AND (("remind_user_id"=1000) AND ("is_read"=FALSE)) AND ("object_id"=1188) GROUP BY "object_id"
15:49:52.376infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_address_rels" WHERE "client_id"=1188
15:49:52.378infoyii\db\Command::querySELECT *, geolocation[0] AS lng, geolocation[1] AS lat FROM "a57be577deb434"."tbl_addresses" WHERE ("address2" != '') AND ("address2" IS NOT NULL) AND ("id"=1612)
15:49:52.379traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:49:52.381traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:49:52.383infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" "c" WHERE (("c"."sales_rep" IN (5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("c"."sales_rep" IS NULL) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) AND ("c"."id"=1188))
15:49:52.385infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:49:52.386traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:49:52.388traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: createClientContact
15:49:52.388traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
15:49:52.388traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
15:49:52.388traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
15:49:52.388traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
15:49:52.388traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
15:49:52.388traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesDirector
15:49:52.388traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: CommercialAttache
15:49:52.388traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: GM
15:49:52.388traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Accountant
15:49:52.388traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesManager
15:49:52.388traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Treasurer
15:49:52.388traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 电话销售
15:49:52.389infoyii\db\Command::querySELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE ("is_delete"=FALSE) OR ("id"=6) ORDER BY "order"
15:49:52.390infoyii\db\Command::querySELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_classes" WHERE ("is_delete"=FALSE) OR ("id" IS NULL) ORDER BY "order"
15:49:52.390infoyii\db\Command::querySELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_company_natures" WHERE ("is_delete"=FALSE) OR ("id"=1) ORDER BY "order"
15:49:52.391infoyii\db\Command::querySELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE ("is_delete"=FALSE) OR ("id"=16) ORDER BY "order"
15:49:52.392traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:49:52.392traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:49:52.393infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 0, 276, 'v2/client/get-edit', '{"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","device_type":"0","version_code":"276","id":"1188","token":"97641af1ad0ba4ee04d9b8c3089e2b91","posttime":"1784015391"}', '{"code":200,"data":{"model":{"id":1188,"name":"\u4e2d\u56fd\u7164\u70ad\u5730\u8d28\u603b\u5c40","abbr":null,"pinyin_shortcut":"zgmtdzzj","description":"","corp_rep":"\u8d75\u5e73\uff08\u515a\u59d4\u6570\u636e\uff0c\u5c40\u957f\uff09","website":"http:\/\/www.ccgc.cn\/","capital":null,"established_at":"1953-01-01","headcount":"","reg_address":null,"working_address":1612,"telephone":"010-63903775 010-63903982 ","fax":"010-63903707","scale":"2020\u5e74269.92\u4ebf\uff0c2019\u5e74242.10\u4ebf","branch":"\u662f\u56fd\u52a1\u9662\u56fd\u8d44\u59d4\u76f4\u63a5\u7ba1\u7406\u7684\u4e2d\u592e\u4f01\u4e1a\uff0c\u4e0b\u8f96\u4e2d\u5316\u5730\u8d28\u77ff\u5c71\u603b\u5c40\u3001\u4e13\u4e1a\u76f4\u5c5e\u5c40\u3001\u7701\uff08\u533a\uff09\u7164\u70ad\u5730\u8d28\u5c40\u4ee5\u53ca\u4e2d\u5fc3\u3001\u9662\uff08\u961f\uff09\u7b49\u5355\u4f4d200\u4f59\u5bb6\uff0c\u5206\u5e03\u5728\u5168\u56fd22\u4e2a\u7701\uff08\u5e02\u3001\u533a\uff09","purchase_scale_per_yr":"0","purchase_freq":"","company_nature":1,"client_class":null,"client_industry":16,"client_type":6,"sales_rep":1005,"main_contact":null,"created_by":5096,"created_at":"2018-11-06 18:49:53","updated_at":"2026-06-02 17:03:08","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"China National Administration of Coal Geology","pick_at":"2025-05-26 17:35:34","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":7,"client_key_info_count":1,"contact_count":3,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":null,"tax_no":null,"is_public":1,"cooperated":false,"lost_contact_days":"745.986021511597","last_arrive_days":"1670.22822058567","last_contact":"2024-06-28 16:10:00","notice_days":null,"workingAddress":{"id":1612,"name":"\u4e2d\u56fd\u7164\u70ad\u5730\u8d28\u603b\u5c40","address1":null,"address2":"\u4e2d\u56fd\u7164\u70ad\u5730\u8d28\u603b\u5c40","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u6d77\u6dc0\u533a","zip":"100038","country":"\u4e2d\u56fd","geolocation":"(116.323089,39.898668)","created_by":5329,"created_at":"2018-11-06 18:49:54","updated_at":"2023-06-27 23:11:16","state_id":110000,"city_id":110100,"region_id":110108,"country_id":1,"lng":"116.323089","lat":"39.898668"},"clientType":{"id":6,"key":6,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09"},"clientClass":null,"companyNature":{"id":1,"key":1,"name":"\u56fd\u6709\u4e0a\u5e02"},"clientIndustry":{"id":16,"key":16,"name":"\u80fd\u6e90"},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","client_lock":false,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientFrom":{"id":153,"key":153,"name":"\u516c\u6d77\u5ba2\u6237"},"unCloseCases":[],"createdBy":{"id":5096,"key":5096,"name":"\u674e\u6c5f\u661f","sex":"F","department_id":1,"avatar":{"id":55,"user_id":5096,"name":"\/files\/cdn\/a57be577deb434\/avatar\/dfb8e15a-c62e-3531-a805-e436f46176e6.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"workLogCount":{"client_id":1188,"count":72},"caseCount":{"client_id":1188,"count":5},"salesTimeCount":{"client_id":1188,"hours":"7.48861111111111","times":6},"implementTimeCount":null,"presalesTimeCount":{"client_id":1188,"sum":"5.80666666666667","times":"5"},"engineerTimeCount":null,"reimbursementAmountSum":{"client_id":1188,"sum":"244.00"},"addresses":[{"id":949,"key":949,"name":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u7f8a\u574a\u5e97\u4e1c\u8def21\u53f7\u9662\u4e2d\u56fd\u7164\u5730\u5927\u53a61603","client_id":1188}],"contacts":[{"id":3794,"name":"\u5434\u534e\u777f","email":"","pinyin_shortcut":"whr","sex":"M","birth_date":null,"department":"\u91c7\u8d2d\u90e8","job_position":"","mobile":"","telephone":"63903921","client_id":1188,"supplier_id":null,"created_by":5300,"created_at":"2021-10-26 15:49:03","updated_at":"2021-10-26 15:49:03","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":null,"pinyin1":"wu","pinyin2":"hua","pinyin3":"rui","pinyin4":null,"namecut1":"\u5434","namecut2":"\u534e","namecut3":"\u777f","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","user_status":"1"},"mobiles":[],"contactKeyRoles":[],"contactAttitude":null},{"id":3795,"name":"\u5b59\u4ef2\u5f64","email":"","pinyin_shortcut":"szt","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"63903936","client_id":1188,"supplier_id":null,"created_by":5300,"created_at":"2021-10-26 15:49:50","updated_at":"2021-10-26 15:49:50","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":null,"pinyin1":"sun","pinyin2":"zhong","pinyin3":"tong","pinyin4":null,"namecut1":"\u5b59","namecut2":"\u4ef2","namecut3":"\u5f64","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","user_status":"1"},"mobiles":[],"contactKeyRoles":[],"contactAttitude":null},{"id":2374,"name":"\u738b\u91d1\u8f89","email":"","pinyin_shortcut":"wjh","sex":"M","birth_date":null,"department":"","job_position":"\u4fe1\u606f\u7ba1\u7406\u5904\u5904\u957f","mobile":"","telephone":"","client_id":1188,"supplier_id":null,"created_by":5026,"created_at":"2018-11-06 18:50:26","updated_at":"2019-10-29 13:17:38","user_status":1,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"wang","pinyin2":"jin","pinyin3":"hui","pinyin4":null,"namecut1":"\u738b","namecut2":"\u91d1","namecut3":"\u8f89","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":5026,"key":5026,"name":"\u4e1c\u5cf0","sex":"M","user_status":"-1"},"mobiles":[{"id":3108,"contact_id":2374,"mobile":"18631259775","mp_open_id":null}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":2963,"name":"\u82cf\u5904\u957f","email":"","pinyin_shortcut":"scz","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u90e8","job_position":"","mobile":"","telephone":"63903709","client_id":1188,"supplier_id":null,"created_by":5096,"created_at":"2019-10-29 13:15:35","updated_at":"2019-10-29 13:17:28","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"su","pinyin2":"chu","pinyin3":"zhang","pinyin4":null,"namecut1":"\u82cf","namecut2":"\u5904","namecut3":"\u957f","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5096,"key":5096,"name":"\u674e\u6c5f\u661f","sex":"F","user_status":"-1"},"mobiles":[{"id":3107,"contact_id":2963,"mobile":"13269276327","mp_open_id":null}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}}],"commentCount":{"object_id":1188,"comment":6},"unreadComments":null,"fromContact":null,"workingAddresses":[{"id":1612,"name":"\u4e2d\u56fd\u7164\u70ad\u5730\u8d28\u603b\u5c40","address1":null,"address2":"\u4e2d\u56fd\u7164\u70ad\u5730\u8d28\u603b\u5c40","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u6d77\u6dc0\u533a","zip":"100038","country":"\u4e2d\u56fd","geolocation":"(116.323089,39.898668)","created_by":5329,"created_at":"2018-11-06 18:49:54","updated_at":"2023-06-27 23:11:16","state_id":110000,"city_id":110100,"region_id":110108,"country_id":1,"lng":"116.323089","lat":"39.898668"}],"unread":0,"lost_contact_days_display":"2\u5e74\u524d","last_arrive_days_display":null,"bgcolor":"gray","overdue_display":"","last_arrive_overdue_display":"","can_pick_up":false,"can_transfer":true,"can_update":true,"can_delete":false,"can_give_up":true,"can_create_contact":true,"can_edit_contact":true,"object_type":10,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true},"options":[{"key":"sales_rep","name":"\u5ba2\u6237\u7ecf\u7406","value":[{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}]},{"key":"client_industry","name":"\u5ba2\u6237\u884c\u4e1a","value":[{"key":57,"name":"EDA\/CAE"},{"key":1,"name":"\u653f\u5e9c"},{"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"},{"key":2,"name":"\u6559\u80b2\uff08\u9ad8\u6821\uff09"},{"key":24,"name":"\u6559\u80b2\uff08\u666e\u6559\uff09"},{"key":3,"name":"\u533b\u7597"},{"key":4,"name":"\u901a\u4fe1"},{"key":5,"name":"\u5236\u9020"},{"key":58,"name":"\u519b\u5de5"},{"key":6,"name":"\u7535\u5546"},{"key":7,"name":"\u9152\u5e97"},{"key":8,"name":"\u7269\u6d41"},{"key":9,"name":"\u5730\u4ea7"},{"key":10,"name":"\u91d1\u878d"},{"key":11,"name":"\u4ea4\u901a"},{"key":12,"name":"\u5e7f\u544a"},{"key":13,"name":"SI\/ISV"},{"key":14,"name":"\u5e7f\u7535"},{"key":15,"name":"\u7535\u529b"},{"key":16,"name":"\u80fd\u6e90"},{"key":17,"name":"\u96f6\u552e"},{"key":18,"name":"\u5a92\u4f53"},{"key":19,"name":"OTT"},{"key":20,"name":"\u5176\u4ed6"},{"key":59,"name":"\u8d38\u6613"}]},{"key":"company_nature","name":"\u516c\u53f8\u6027\u8d28","value":[{"key":1,"name":"\u56fd\u6709\u4e0a\u5e02"},{"key":2,"name":"\u6c11\u8425\u4e0a\u5e02"},{"key":3,"name":"\u56fd\u6709\u4f01\u4e1a"},{"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},{"key":6,"name":"\u5916\u8d44\u4f01\u4e1a"}]},{"key":"client_class","name":"\u5ba2\u6237\u7ea7\u522b","value":[{"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},{"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237"},{"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},{"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"}]},{"key":"client_type","name":"\u5ba2\u6237\u6027\u8d28","value":[{"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},{"key":6,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09"},{"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},{"key":3,"name":"\u4e2a\u4eba\u6d88\u8d39\u8005"}]}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"39.156.194.178","ua":"jinchangxiao\/2.3.176 (HUAWEIVOG-AL00; Android 10)"}', FALSE, '2026-07-14 15:49:52', 147344640) RETURNING "id"