68c1264331f92: POST https://beta.jinchangxiao.com/v2/client/list at 2025-09-10 03:18:27 pm by 114.246.239.150
Log Messages
总计87条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 15:18:27.204 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 15:18:27.204 | trace | yii\base\Module::getModule | Loading module: debug |
| 15:18:27.204 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 15:18:27.204 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 15:18:27.204 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 15:18:27.204 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:18:27.205 | trace | yii\base\Module::getModule | Loading module: gii |
| 15:18:27.205 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 15:18:27.205 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 15:18:27.205 | trace | yii\web\Application::handleRequest | Route requested: 'v2/client/list' |
| 15:18:27.205 | trace | yii\base\Module::getModule | Loading module: v2 |
| 15:18:27.205 | info | yii\web\Session::open | Session started |
| 15:18:27.206 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 15:18:27.208 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om' |
| 15:18:27.211 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:18:27.211 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:18:27.211 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:18:27.211 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:18:27.211 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:18:27.213 | trace | yii\base\Controller::runAction | Route to run: v2/client/list |
| 15:18:27.213 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:18:27.214 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 15:18:27.214 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\ClientController::actionList() |
| 15:18:27.214 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:18:27.214 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:18:27.215 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:18:27.215 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:18:27.217 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT c.*, CASE WHEN p.client_id IS NULL THEN false ELSE true END AS cooperated, CASE WHEN c.sales_rep IS NULL THEN 0 ELSE 1 END AS is_public, sl.lost_contact_days, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, sl.last_contact, max(arrive.end_at) as last_arrive, CASE WHEN c.client_class IS NOT NULL THEN ( (CASE WHEN cl.contact_base > 0 THEN floor(CASE WHEN c.contact_count > cl.contact_base THEN 1 * 15 ELSE c.contact_count * 15 / cl.contact_base END) ELSE 15 END) + floor(c.client_base_info_count * 15 / 9) + (CASE WHEN cl.visit_base > 0 THEN floor(CASE WHEN c.visit_count > ceil((CASE WHEN extract(year from now()) = extract(year from c.created_at::date) THEN (now()::date - c.created_at::date + 1)::float ELSE 253::float END) / cl.visit_base::float) THEN 1 * 20 ELSE c.visit_count * 20 / ceil((CASE WHEN extract(year from now()) = extract(year from c.created_at::date) THEN (now()::date - c.created_at::date + 1)::float ELSE 253::float END) / cl.visit_base::float) END) ELSE 20 END) + (CASE WHEN cl.cooperate_base > 0 THEN floor(CASE WHEN c.cooperate_count > cl.cooperate_base THEN 1 * 20 ELSE c.cooperate_count * 20 / cl.cooperate_base END) ELSE 20 END) + (CASE WHEN cl.case_pre_sales_base > 0 THEN floor(CASE WHEN c.case_pre_sales_count > cl.case_pre_sales_base THEN 1 * 15 ELSE c.case_pre_sales_count * 15 / cl.case_pre_sales_base END) ELSE 15 END) + (CASE WHEN cl.case_implement_base > 0 THEN floor(CASE WHEN c.case_implement_count > cl.case_implement_base THEN 1 * 15 ELSE c.case_implement_count * 15 / cl.case_implement_base END) ELSE 15 END) ) ELSE NULL END as score FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_client_classes" "cl" ON cl.id = c.client_class LEFT JOIN "a57be577deb434"."tbl_client_address_rels" "car" ON car.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_addresses" "a" ON car.address_id = a.id LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "project_status"=3 GROUP BY "client_id") "p" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.client_id = c.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN (SELECT extract(epoch from (now() - max(end_at))) / 86400 AS lost_contact_days, max(end_at) as last_contact, client_id FROM "a57be577deb434"."tbl_work_logs" WHERE "is_draft"=FALSE GROUP BY "client_id") "sl" ON sl.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = c.id AND ttr.term_id = 14 LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_contacts" WHERE lower(name) LIKE '%%' GROUP BY "client_id") "cc" ON cc.client_id = c.id WHERE (("c"."sales_rep" IN (5049, 5301, 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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 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 ("client_industry"='25') AND ("deleted"=FALSE) GROUP BY "c"."id", "cl"."id", "cooperated", "lost_contact_days", "last_contact" ORDER BY "is_public" DESC, lost_contact_days ASC NULLS LAST, "c"."created_at" DESC) "c" |
| 15:18:27.235 | info | yii\db\Command::query | SELECT c.*, CASE WHEN p.client_id IS NULL THEN false ELSE true END AS cooperated, CASE WHEN c.sales_rep IS NULL THEN 0 ELSE 1 END AS is_public, sl.lost_contact_days, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, sl.last_contact, max(arrive.end_at) as last_arrive, CASE WHEN c.client_class IS NOT NULL THEN ( (CASE WHEN cl.contact_base > 0 THEN floor(CASE WHEN c.contact_count > cl.contact_base THEN 1 * 15 ELSE c.contact_count * 15 / cl.contact_base END) ELSE 15 END) + floor(c.client_base_info_count * 15 / 9) + (CASE WHEN cl.visit_base > 0 THEN floor(CASE WHEN c.visit_count > ceil((CASE WHEN extract(year from now()) = extract(year from c.created_at::date) THEN (now()::date - c.created_at::date + 1)::float ELSE 253::float END) / cl.visit_base::float) THEN 1 * 20 ELSE c.visit_count * 20 / ceil((CASE WHEN extract(year from now()) = extract(year from c.created_at::date) THEN (now()::date - c.created_at::date + 1)::float ELSE 253::float END) / cl.visit_base::float) END) ELSE 20 END) + (CASE WHEN cl.cooperate_base > 0 THEN floor(CASE WHEN c.cooperate_count > cl.cooperate_base THEN 1 * 20 ELSE c.cooperate_count * 20 / cl.cooperate_base END) ELSE 20 END) + (CASE WHEN cl.case_pre_sales_base > 0 THEN floor(CASE WHEN c.case_pre_sales_count > cl.case_pre_sales_base THEN 1 * 15 ELSE c.case_pre_sales_count * 15 / cl.case_pre_sales_base END) ELSE 15 END) + (CASE WHEN cl.case_implement_base > 0 THEN floor(CASE WHEN c.case_implement_count > cl.case_implement_base THEN 1 * 15 ELSE c.case_implement_count * 15 / cl.case_implement_base END) ELSE 15 END) ) ELSE NULL END as score FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_client_classes" "cl" ON cl.id = c.client_class LEFT JOIN "a57be577deb434"."tbl_client_address_rels" "car" ON car.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_addresses" "a" ON car.address_id = a.id LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "project_status"=3 GROUP BY "client_id") "p" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.client_id = c.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN (SELECT extract(epoch from (now() - max(end_at))) / 86400 AS lost_contact_days, max(end_at) as last_contact, client_id FROM "a57be577deb434"."tbl_work_logs" WHERE "is_draft"=FALSE GROUP BY "client_id") "sl" ON sl.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = c.id AND ttr.term_id = 14 LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_contacts" WHERE lower(name) LIKE '%%' GROUP BY "client_id") "cc" ON cc.client_id = c.id WHERE (("c"."sales_rep" IN (5049, 5301, 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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 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 ("client_industry"='25') AND ("deleted"=FALSE) GROUP BY "c"."id", "cl"."id", "cooperated", "lost_contact_days", "last_contact" ORDER BY "is_public" DESC, lost_contact_days ASC NULLS LAST, "c"."created_at" DESC LIMIT 10 |
| 15:18:27.251 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id" IN (1, 5, 6) |
| 15:18:27.251 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "notice_days", "color", "visit_base" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (43, 80) |
| 15:18:27.252 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (10, 1331, 2179, 16, 1438, 2263, 2255, 77, 154, 318) |
| 15:18:27.253 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=14) AND ("id" IN (46, 96, 100, 97, 105, 112, 99, 164, 167, 181, 182, 179, 142, 165, 102, 196, 204, 213, 1, 2, 7, 6, 5, 212, 136, 139, 184, 189, 8, 183, 153, 94, 106, 210, 176, 154, 231, 207, 229, 224, 223, 214, 219, 9, 208, 211, 226, 227, 216, 93, 228, 11, 209, 217, 230, 218, 10, 221, 225, 215, 222, 315, 137, 140, 160, 313, 320, 319, 340, 349, 367, 359, 377, 374, 369, 331, 432)) ORDER BY "sort" |
| 15:18:27.254 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id"=25 |
| 15:18:27.254 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_company_natures" WHERE "id" IN (4, 2, 3) |
| 15:18:27.255 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "client_lock" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5311, 5332) |
| 15:18:27.255 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5311, 5332)) |
| 15:18:27.255 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5089, 5096, 5015, 5088, 5332, 1003, 5209) |
| 15:18:27.256 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5089, 5015, 5332, 5096, 5209, 5088, 1003)) |
| 15:18:27.256 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (1, 9) |
| 15:18:27.257 | info | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=10) AND ("object_id" IN (10, 1331, 2179, 16, 1438, 2263, 2255, 77, 154, 318)) GROUP BY "object_id" |
| 15:18:27.278 | info | yii\db\Command::query | SELECT *, geolocation[0] AS lng, geolocation[1] AS lat FROM "a57be577deb434"."tbl_addresses" WHERE "id" IN (678, 1778, 3043, 679, 1812, 2791, 2785, 596, 337, 842) |
| 15:18:27.280 | info | yii\db\Command::query | SELECT "id", "client_id" FROM "a57be577deb434"."tbl_cases" WHERE ("case_status" NOT IN (5, 6)) AND ("client_id" IN (10, 1331, 2179, 16, 1438, 2263, 2255, 77, 154, 318)) |
| 15:18:27.281 | info | yii\db\Command::query | SELECT "client_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("client_id" IN (10, 1331, 2179, 16, 1438, 2263, 2255, 77, 154, 318)) GROUP BY "client_id" |
| 15:18:27.282 | info | yii\db\Command::query | SELECT "client_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "client_id" IN (10, 1331, 2179, 16, 1438, 2263, 2255, 77, 154, 318) GROUP BY "client_id" |
| 15:18:27.283 | info | yii\db\Command::query | SELECT "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" IN (10, 1331, 2179, 16, 1438, 2263, 2255, 77, 154, 318)) GROUP BY "client_id" |
| 15:18:27.284 | info | yii\db\Command::query | SELECT "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" IN (10, 1331, 2179, 16, 1438, 2263, 2255, 77, 154, 318)) GROUP BY "c"."client_id" |
| 15:18:27.290 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:18:27.290 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:18:27.291 | info | yii\db\Command::query | SELECT "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" IN (10, 1331, 2179, 16, 1438, 2263, 2255, 77, 154, 318)) GROUP BY "c"."client_id" |
| 15:18:27.293 | info | yii\db\Command::query | SELECT "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" IN (10, 1331, 2179, 16, 1438, 2263, 2255, 77, 154, 318)) GROUP BY "client_id" |
| 15:18:27.294 | info | yii\db\Command::query | SELECT "client_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("client_id" IN (10, 1331, 2179, 16, 1438, 2263, 2255, 77, 154, 318)) GROUP BY "client_id" |
| 15:18:27.296 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "address" AS "name", "client_id" FROM "a57be577deb434"."tbl_client_addresses" WHERE "client_id" IN (10, 1331, 2179, 16, 1438, 2263, 2255, 77, 154, 318) |
| 15:18:27.296 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "client_id" IN (10, 1331, 2179, 16, 1438, 2263, 2255, 77, 154, 318) |
| 15:18:27.298 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "status" AS "name" FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id" IN (2, 1, 3) |
| 15:18:27.298 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5015, 1018, 1006, 5089, 1003, 1023, 5045, 5027, 1005, 5301, 5332) |
| 15:18:27.299 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (3973, 869, 468, 3482, 450, 20, 11, 155, 424, 456, 446, 423, 313, 660, 664, 830, 766, 870, 1323, 1091, 1046, 1223, 2688, 2811, 13, 844, 3711, 1313, 2916, 4164, 4163) |
| 15:18:27.300 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3973, 869, 468, 3482, 450, 20, 11, 155, 424, 456, 446, 423, 313, 660, 664, 830, 766, 870, 1323, 1091, 1046, 1223, 2688, 2811, 13, 844, 3711, 1313, 2916, 4164, 4163) |
| 15:18:27.303 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (97, 46, 96, 162, 138, 139, 102, 94, 107, 133, 135, 136, 140, 134, 101, 45, 100, 165, 179, 142, 99, 164, 132, 8, 5, 137, 197, 199, 198, 202, 211, 173, 154, 327, 1, 7, 205, 203, 93, 153, 204, 128, 181, 196, 184, 189, 183, 188, 190, 2, 6, 9, 208, 319, 226, 167, 105, 106, 185, 191, 166, 112, 215, 194, 171, 315, 130, 231, 207, 229, 224, 223, 214, 219, 210, 227, 216, 228, 11, 209, 217, 230, 218, 10, 213, 221, 225, 222, 212, 114, 331, 313, 168, 317, 2100000000, 340, 316, 341, 160, 320, 349, 172, 323, 324, 358, 359, 369, 373, 377, 376, 378, 374, 367, 386)) ORDER BY "sort" |
| 15:18:27.304 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3973, 869, 468, 3482, 450, 20, 11, 155, 424, 456, 446, 423, 313, 660, 664, 830, 766, 870, 1323, 1091, 1046, 1223, 2688, 2811, 13, 844, 3711, 1313, 2916, 4164, 4163) |
| 15:18:27.305 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (97, 46, 96, 162, 138, 139, 102, 94, 107, 133, 135, 136, 140, 134, 101, 45, 100, 165, 179, 142, 99, 164, 132, 8, 5, 137, 197, 199, 198, 202, 211, 173, 154, 327, 1, 7, 205, 203, 93, 153, 204, 128, 181, 196, 184, 189, 183, 188, 190, 2, 6, 9, 208, 319, 226, 167, 105, 106, 185, 191, 166, 112, 215, 194, 171, 315, 130, 231, 207, 229, 224, 223, 214, 219, 210, 227, 216, 228, 11, 209, 217, 230, 218, 10, 213, 221, 225, 222, 212, 114, 331, 313, 168, 317, 2100000000, 340, 316, 341, 160, 320, 349, 172, 323, 324, 358, 359, 369, 373, 377, 376, 378, 374, 367, 386)) ORDER BY "sort" |
| 15:18:27.306 | info | yii\db\Command::query | SELECT "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" IN (10, 1331, 2179, 16, 1438, 2263, 2255, 77, 154, 318)) GROUP BY "object_id" |
| 15:18:27.324 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_client_address_rels" WHERE "client_id" IN (10, 1331, 2179, 16, 1438, 2263, 2255, 77, 154, 318) |
| 15:18:27.325 | info | yii\db\Command::query | SELECT *, geolocation[0] AS lng, geolocation[1] AS lat FROM "a57be577deb434"."tbl_addresses" WHERE ("address2" != '') AND ("address2" IS NOT NULL) AND ("id" IN (1778, 337, 679, 2785, 678, 2791, 3043, 842, 596, 1812)) |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: updateClient |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: StoreKeeper |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: createClientContact |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: StoreKeeper |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Engineer |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: TechDirector |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: ProjectManager |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: 电话销售 |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: AccountManager |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: SalesManager |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: SalesDirector |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: GM |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Accountant |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: CommercialAttache |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Treasurer |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: updateClientContact |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: StoreKeeper |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Engineer |
| 15:18:27.326 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 15:18:27.328 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:18:27.328 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:18:27.329 | 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, 0, 266, 'v2/client/list', '{"access_token":"gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om","Filter":{"sort":"","name":""},"ClientSearch":{"contact_status":"","sales_rep":"","cooperated":"","client_industry":"25","client_type":"","keyword":"","clientFrom":"","company_nature":"","client_class":""},"device_type":"0","version_code":"266","lat":"39.960398","lng":"116.28906","page":"1","token":"94bc3d178146e1ca88258d4ef24e6135","posttime":"1757488707","pagesize":"10"}', '{"code":200,"data":{"list":[{"id":10,"name":"\u5317\u4eac\u7ea2\u7f28\u65f6\u4ee3\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u5e38\u9752\u85e4\u667a\u5e93\uff08\u5317\u4eac\uff09\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09","abbr":null,"pinyin_shortcut":"bjhysdjykjyxgscqtzkbjjykjyxgs","description":"","corp_rep":"\u738b\u7ea2\u5175","website":"","capital":"500","established_at":"2010-01-07","headcount":"","reg_address":23,"working_address":678,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":null,"purchase_freq":"","company_nature":4,"client_class":43,"client_industry":25,"client_type":1,"sales_rep":5311,"main_contact":null,"created_by":5089,"created_at":"2017-02-08 17:05:33","updated_at":"2025-02-10 21:06:50","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2024-07-12 17:37:37","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":4,"client_key_info_count":0,"contact_count":8,"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,"cooperated":true,"is_public":1,"lost_contact_days":"212.051009688067","last_arrive_days":"743.011426354734","last_contact":"2025-02-10 14:05:00","last_arrive":"2023-08-29 15:02:00+08","score":"21","clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC","visit_base":15},"clientFrom":null,"clientIndustry":{"id":25,"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","client_lock":true,"avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"createdBy":{"id":5089,"key":5089,"name":"\u5b59\u5a77\u5a77","sex":"F","department_id":1,"avatar":{"id":52,"user_id":5089,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e3f43e80-a7e2-33bb-b317-0185418330b4.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":10,"comment":1},"workingAddress":{"id":678,"name":"\u5317\u4eac\u7ea2\u7f28\u65f6\u4ee3\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u5e38\u9752\u85e4\u667a\u5e93\uff08\u5317\u4eac\uff09\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09","address1":"","address2":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u5c0f\u5173\u8857\u9053\u5317\u5965\u5927\u53a6\u4f4f\u603b\u5730\u4ea7\u5927\u53a6","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u671d\u9633\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.425336450338,39.9881288525359)","created_by":5295,"created_at":"2017-09-08 17:07:52","updated_at":"2024-03-06 21:48:14","state_id":110000,"city_id":110100,"region_id":110105,"country_id":1,"lng":"116.425336450338","lat":"39.9881288525359"},"unCloseCases":[],"workLogCount":{"client_id":10,"count":131},"caseCount":{"client_id":10,"count":65},"salesTimeCount":{"client_id":10,"hours":"10.5833333333333","times":7},"implementTimeCount":{"client_id":10,"sum":"236.011666666667","times":"48"},"presalesTimeCount":{"client_id":10,"sum":"35.6166666666667","times":"19"},"engineerTimeCount":{"client_id":10,"hours":"7.5","times":4},"reimbursementAmountSum":{"client_id":10,"sum":"6158.78"},"addresses":[{"id":334,"key":334,"name":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u4e0a\u5730\u4e1c\u8def1\u53f7\u73af\u6d0b\u5927\u53a62\u5c42","client_id":10}],"contacts":[{"id":450,"name":"\u738b\u4e91\u751f","email":"wangyunsheng@vtronedu.com","pinyin_shortcut":"wys","sex":"M","birth_date":null,"department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d\u4e13\u5458","mobile":"","telephone":"","client_id":10,"supplier_id":null,"created_by":1006,"created_at":"2017-03-29 16:25:51","updated_at":"2019-05-28 15:52:25","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"wang","pinyin2":"yun","pinyin3":"sheng","pinyin4":null,"namecut1":"\u738b","namecut2":"\u4e91","namecut3":"\u751f","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":2718,"contact_id":450,"mobile":"18600891314","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":11,"name":"\u6bb7\u5f3a","email":"yinqiang@hoing.net","pinyin_shortcut":"yq","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u90e8","job_position":"\u8fd0\u7ef4\u4e3b\u7ba1","mobile":"","telephone":"","client_id":10,"supplier_id":null,"created_by":1006,"created_at":"2017-02-08 17:06:37","updated_at":"2017-06-01 16:55:33","user_status":1,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"yin","pinyin2":"qiang","pinyin3":null,"pinyin4":null,"namecut1":"\u6bb7","namecut2":"\u5f3a","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":42,"contact_id":11,"mobile":"18910072799","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":424,"name":"\u9c8d\u79c0\u5cf0","email":"baoxiufeng@vtronedu.com","pinyin_shortcut":"bxf","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u90e8","job_position":"\u4fe1\u606f\u90e8\u526f\u7ecf\u7406","mobile":"","telephone":"58843688","client_id":10,"supplier_id":null,"created_by":1006,"created_at":"2017-03-22 19:48:27","updated_at":"2021-11-12 16:03:35","user_status":2,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"010","telephone_extension_number":"866","mp_open_id":null,"pinyin1":"bao","pinyin2":"xiu","pinyin3":"feng","pinyin4":null,"namecut1":"\u9c8d","namecut2":"\u79c0","namecut3":"\u5cf0","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":2720,"contact_id":424,"mobile":"13522829605","mp_open_id":null}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":456,"name":"\u9f9a\u660e","email":"gongming@hoing.net","pinyin_shortcut":"gm","sex":"M","birth_date":null,"department":"\u8d22\u52a1\u90e8","job_position":"\u8d22\u52a1\u603b\u76d1","mobile":"","telephone":"","client_id":10,"supplier_id":null,"created_by":1006,"created_at":"2017-03-31 10:04:00","updated_at":"2017-05-04 15:40:19","user_status":2,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"gong","pinyin2":"ming","pinyin3":null,"pinyin4":null,"namecut1":"\u9f9a","namecut2":"\u660e","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":466,"contact_id":456,"mobile":"17710602836","mp_open_id":null}],"contactKeyRoles":[{"id":134,"key":134,"name":"\u8d22\u52a1\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":446,"name":"\u9f50\u7ecf\u7406","email":"","pinyin_shortcut":"qjl","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u4e2d\u5fc3","job_position":"\u4fe1\u606f\u4e2d\u5fc3\u4e3b\u4efb","mobile":"","telephone":"","client_id":10,"supplier_id":null,"created_by":1006,"created_at":"2017-03-28 19:46:30","updated_at":"2023-06-26 16:12:06","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"qi","pinyin2":"jing","pinyin3":"li","pinyin4":null,"namecut1":"\u9f50","namecut2":"\u7ecf","namecut3":"\u7406","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[],"contactKeyRoles":[],"contactAttitude":null},{"id":423,"name":"\u848b\u5176\u4f20","email":"jiangqichuan@vtronedu.com","pinyin_shortcut":"jqc","sex":"M","birth_date":null,"department":"\u4f9b\u5e94\u94fe\u4e2d\u5fc3","job_position":"\u4f9b\u5e94\u94fe\u4e2d\u5fc3\u603b\u7ecf\u7406","mobile":"","telephone":"58843505","client_id":10,"supplier_id":null,"created_by":1006,"created_at":"2017-03-22 19:47:11","updated_at":"2019-05-28 15:54:14","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":null,"pinyin1":"jiang","pinyin2":"qi","pinyin3":"chuan","pinyin4":null,"namecut1":"\u848b","namecut2":"\u5176","namecut3":"\u4f20","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":2721,"contact_id":423,"mobile":"13621298972","mp_open_id":null}],"contactKeyRoles":[{"id":133,"key":133,"name":"\u603b\u51b3\u7b56\u4eba"},{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":766,"name":"\u5bab\u5b66\u541b","email":"","pinyin_shortcut":"gxj","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u4e2d\u5fc3","job_position":"\u8fd0\u7ef4\u4e3b\u7ba1","mobile":"","telephone":"","client_id":10,"supplier_id":null,"created_by":1006,"created_at":"2017-06-01 16:56:01","updated_at":"2023-06-26 16:12:06","user_status":1,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"gong","pinyin2":"xue","pinyin3":"jun","pinyin4":null,"namecut1":"\u5bab","namecut2":"\u5b66","namecut3":"\u541b","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[],"contactKeyRoles":[],"contactAttitude":null},{"id":870,"name":"\u6768\u84d3\u84d3","email":"yangbeibei@hoing.net","pinyin_shortcut":"ybb","sex":"F","birth_date":null,"department":"\u91c7\u8d2d","job_position":"\u91c7\u8d2d\u4e3b\u7ba1","mobile":null,"telephone":"010-58843688-3510","client_id":10,"supplier_id":null,"created_by":1006,"created_at":"2017-06-20 10:35:13","updated_at":"2017-06-20 10:35:13","user_status":2,"description":null,"contact_type":"1","contact_attitude":1,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"yang","pinyin2":"bei","pinyin3":"bei","pinyin4":null,"namecut1":"\u6768","namecut2":"\u84d3","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":851,"contact_id":870,"mobile":"13520258906","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":13,"name":"\u9648\u5218\u4f73","email":"chenliujia@vtronedu.com","pinyin_shortcut":"clj","sex":"M","birth_date":null,"department":"\u6280\u672f\u90e8","job_position":"\u8fd0\u7ef4\u5de5\u7a0b\u5e08","mobile":"","telephone":"58851680","client_id":10,"supplier_id":null,"created_by":1006,"created_at":"2017-02-08 17:09:17","updated_at":"2023-07-24 11:38:33","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":null,"pinyin1":"chen","pinyin2":"liu","pinyin3":"jia","pinyin4":null,"namecut1":"\u9648","namecut2":"\u5218","namecut3":"\u4f73","namecut4":null,"is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":3124,"contact_id":13,"mobile":"18613839277","mp_open_id":"oagch6UaRi55oZ2MTWPDFbb4r_Zo"}],"contactKeyRoles":[{"id":137,"key":137,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":844,"name":"\u8d75\u4f1f","email":"zhaowei@vtronedu.com","pinyin_shortcut":"zw","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u4e2d\u5fc3","job_position":"\u8fd0\u7ef4\u4e3b\u7ba1","mobile":"","telephone":"","client_id":10,"supplier_id":null,"created_by":1006,"created_at":"2017-06-15 14:19:47","updated_at":"2020-03-27 13:53:38","user_status":1,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"zhao","pinyin2":"wei","pinyin3":null,"pinyin4":null,"namecut1":"\u8d75","namecut2":"\u4f1f","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":3383,"contact_id":844,"mobile":"13520953202","mp_open_id":null}],"contactKeyRoles":[{"id":138,"key":138,"name":"Coach"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":3711,"name":"\u7545\u78ca(\u6d4b\u8bd5)","email":"","pinyin_shortcut":"clcs","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":10,"supplier_id":null,"created_by":5301,"created_at":"2021-08-30 14:59:18","updated_at":"2021-08-30 14:59:32","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"oagch6aIXgK_S1wmDyepCZWP_Smk","pinyin1":"chang","pinyin2":"lei","pinyin3":"ce","pinyin4":"shi","namecut1":"\u7545","namecut2":"\u78ca","namecut3":"(","namecut4":"\u6d4b","is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5301,"key":5301,"name":"\u7545\u78ca","sex":"M","user_status":"-1"},"mobiles":[{"id":4481,"contact_id":3711,"mobile":"15513890560","mp_open_id":"oagch6aIXgK_S1wmDyepCZWP_Smk"}],"contactKeyRoles":[],"contactAttitude":{"id":162,"key":162,"name":"\u6068\u6211\u5165\u9aa8"}}],"unreadComments":null,"fromContact":null,"workingAddresses":[{"id":678,"name":"\u5317\u4eac\u7ea2\u7f28\u65f6\u4ee3\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u5e38\u9752\u85e4\u667a\u5e93\uff08\u5317\u4eac\uff09\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09","address1":"","address2":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u5c0f\u5173\u8857\u9053\u5317\u5965\u5927\u53a6\u4f4f\u603b\u5730\u4ea7\u5927\u53a6","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u671d\u9633\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.425336450338,39.9881288525359)","created_by":5295,"created_at":"2017-09-08 17:07:52","updated_at":"2024-03-06 21:48:14","state_id":110000,"city_id":110100,"region_id":110105,"country_id":1,"lng":"116.425336450338","lat":"39.9881288525359"}],"unread":0,"lost_contact_days_display":"7\u4e2a\u6708\u524d","last_arrive_days_display":"2\u5e74\u524d","bgcolor":"#1EE6DC","overdue_display":"\u903e\u671f153\u5929\u672a\u8054\u7cfb","last_arrive_overdue_display":"\u903e\u671f729\u5929\u672a\u62dc\u8bbf","can_pick_up":false,"can_transfer":false,"can_update":true,"can_delete":false,"can_give_up":false,"can_create_contact":true,"can_edit_contact":true,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true},{"id":1331,"name":"\u4e09\u76db\u667a\u6167\u6559\u80b2\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4e2d\u80b2\u8d1d\u62c9\u56fd\u9645\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6c47\u51a0\u89e6\u6478\u6280\u672f\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"sszhjykjgfyxgsbjzyblgjjykjyxgsbjhgcmjsyxgs","description":"","corp_rep":"\u6797\u8363\u6ee8","website":"www.ssedu.com","capital":"37430","established_at":"2003-09-03","headcount":"\u4e0d\u5230120\u4eba","reg_address":null,"working_address":1778,"telephone":"010-84573455","fax":"010-84574981","scale":"\u53bb\u5e74\u4e8f\u635f\u51e0\u4e2a\u4ebf","branch":"17\u5bb6\u5206\u652f","purchase_scale_per_yr":"0","purchase_freq":"","company_nature":2,"client_class":80,"client_industry":25,"client_type":5,"sales_rep":5311,"main_contact":null,"created_by":5096,"created_at":"2019-07-04 13:17:30","updated_at":"2024-12-30 16:29:46","main_business":"NC\u3001OA\u3001\u8baf\u98de\u3001ERP","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"Sansheng Intellectual Education Technology CO.,LTD.","pick_at":"2024-12-30 16:29:46","it_budget":"\u4e0d\u56fa\u5b9a","deployment_mode":"\u6570\u636e\u4e2d\u5fc3","it_per_num":"","public_relations_difficulty":"","it_status":"\u673a\u623f\u5c06\u8fd140\u53f0\u8bbe\u5907\uff0c\u6ca1\u6709\u9632\u706b\u5899\uff0c120\u53f0\u5de6\u53f3pc","decision_process":"\u9ad8\u78ca\u9700\u6c42\u2014\u90e8\u95e8\u9886\u5bfc\u2014\u5927\u9886\u5bfc","coach":"\u9ad8\u78ca","competitor":"","peers":"","supplier":"","main_product":"\u9760\u6295\u8d44\u6559\u80b2\u76c8\u5229\uff0c\u6536\u8d2d\u5b66\u6821\uff0c\u5efa\u8bbe\u7701\u5e02\u7ea7\u6559\u80b2\u4fe1\u606f\u5316\u90fd\u662f\u76c8\u5229\u76ee\u6807","client_base_info_count":8,"client_key_info_count":9,"contact_count":1,"visit_count":3,"cooperate_count":1,"case_pre_sales_count":1,"case_implement_count":1,"is_overdue_remind":false,"from_contact":null,"tax_no":null,"cooperated":true,"is_public":1,"lost_contact_days":"273.160037465845","last_arrive_days":"273.160037465845","last_contact":"2024-12-11 11:28:00","last_arrive":"2024-12-11 11:28:00+08","score":"90","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315","visit_base":60},"clientFrom":{"id":154,"key":154,"name":"\u5e7f\u544a\u63a8\u5e7f"},"clientIndustry":{"id":25,"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"},"companyNature":{"id":2,"key":2,"name":"\u6c11\u8425\u4e0a\u5e02"},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","client_lock":true,"avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"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"}},"commentCount":{"object_id":1331,"comment":14},"workingAddress":{"id":1778,"name":"\u4e09\u76db\u667a\u6167\u6559\u80b2\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4e2d\u80b2\u8d1d\u62c9\u56fd\u9645\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6c47\u51a0\u89e6\u6478\u6280\u672f\u6709\u9650\u516c\u53f8","address1":"","address2":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u9a6c\u8fde\u6d3c\u8857\u9053\u4e09\u76db\u5927\u53a6","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u6d77\u6dc0\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.2810523808,40.0425217788576)","created_by":5300,"created_at":"2019-07-04 13:17:30","updated_at":"2024-01-25 23:19:55","state_id":110000,"city_id":110100,"region_id":110108,"country_id":1,"lng":"116.2810523808","lat":"40.0425217788576"},"unCloseCases":[],"workLogCount":{"client_id":1331,"count":99},"caseCount":{"client_id":1331,"count":30},"salesTimeCount":{"client_id":1331,"hours":"32.7930555555556","times":20},"implementTimeCount":{"client_id":1331,"sum":"192.7875","times":"34"},"presalesTimeCount":{"client_id":1331,"sum":"12.4002777777778","times":"5"},"engineerTimeCount":null,"reimbursementAmountSum":{"client_id":1331,"sum":"3922.40"},"addresses":[{"id":1375,"key":1375,"name":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u5317\u65fa\u4e1c\u8def10\u53f7\u9662\u4e1c\u533a21\u53f7\u697c6\u5c42","client_id":1331},{"id":1058,"key":1058,"name":"\u5927\u5174\u533a\u901a\u9ec4\u8def\u4e1c\u8d75\u6865\u5357\u5927\u5b66\u8def1\u53f7\uff08\u4e2d\u80b2\u8d1d\u62c9\u56fd\u9645\u9ad8\u4e2d\uff09","client_id":1331}],"contacts":[{"id":2688,"name":"\u5546\u5148\u751f","email":"","pinyin_shortcut":"sxs","sex":"M","birth_date":null,"department":"\u6280\u672f\u90e8","job_position":"\u6280\u672f","mobile":"","telephone":"","client_id":1331,"supplier_id":null,"created_by":1005,"created_at":"2019-07-04 16:39:01","updated_at":"2021-07-13 10:27:01","user_status":1,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"shang","pinyin2":"xian","pinyin3":"sheng","pinyin4":null,"namecut1":"\u5546","namecut2":"\u5148","namecut3":"\u751f","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[{"id":4339,"contact_id":2688,"mobile":"15810480649","mp_open_id":null}],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":2916,"name":"\u9ad8\u78ca","email":"gaolei@ssedu.com","pinyin_shortcut":"gl","sex":"M","birth_date":null,"department":"\u6280\u672f\u90e8","job_position":"\u6280\u672f\u7ecf\u7406","mobile":"","telephone":"84573471","client_id":1331,"supplier_id":null,"created_by":5015,"created_at":"2019-09-27 10:52:17","updated_at":"2022-10-17 16:20:54","user_status":2,"description":"503822997@qq.com","contact_type":"1","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"oagch6ZqrW2morHlh6_CHow-Tevw","pinyin1":"gao","pinyin2":"lei","pinyin3":null,"pinyin4":null,"namecut1":"\u9ad8","namecut2":"\u78ca","namecut3":null,"namecut4":null,"is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","user_status":"-1"},"mobiles":[{"id":4364,"contact_id":2916,"mobile":"18210628608","mp_open_id":"oagch6ZqrW2morHlh6_CHow-Tevw"}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"},{"id":138,"key":138,"name":"Coach"}],"contactAttitude":null}],"unreadComments":null,"fromContact":null,"workingAddresses":[{"id":1778,"name":"\u4e09\u76db\u667a\u6167\u6559\u80b2\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4e2d\u80b2\u8d1d\u62c9\u56fd\u9645\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6c47\u51a0\u89e6\u6478\u6280\u672f\u6709\u9650\u516c\u53f8","address1":"","address2":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u9a6c\u8fde\u6d3c\u8857\u9053\u4e09\u76db\u5927\u53a6","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u6d77\u6dc0\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.2810523808,40.0425217788576)","created_by":5300,"created_at":"2019-07-04 13:17:30","updated_at":"2024-01-25 23:19:55","state_id":110000,"city_id":110100,"region_id":110108,"country_id":1,"lng":"116.2810523808","lat":"40.0425217788576"}],"unread":0,"lost_contact_days_display":"8\u4e2a\u6708\u524d","last_arrive_days_display":"8\u4e2a\u6708\u524d","bgcolor":"#0EE315","overdue_display":"\u903e\u671f244\u5929\u672a\u8054\u7cfb","last_arrive_overdue_display":"\u903e\u671f214\u5929\u672a\u62dc\u8bbf","can_pick_up":false,"can_transfer":false,"can_update":true,"can_delete":false,"can_give_up":false,"can_create_contact":true,"can_edit_contact":true,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true},{"id":2179,"name":"\u5317\u4eac\u9f99\u6587\u4e91\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5e7f\u5dde\u9f99\u6587\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjlwyjykjyxgsgzlwjykjyxgsbjfgs","description":"","corp_rep":"\u674e\u601d\u59b9","website":"","capital":"10000","established_at":"2015-05-27","headcount":"","reg_address":null,"working_address":3043,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"0","company_nature":4,"client_class":43,"client_industry":25,"client_type":5,"sales_rep":5311,"main_contact":null,"created_by":5015,"created_at":"2022-04-18 18:06:57","updated_at":"2024-03-22 17:09:22","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2024-03-22 17:09:22","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":4,"client_key_info_count":0,"contact_count":1,"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,"cooperated":false,"is_public":1,"lost_contact_days":"557.922537465845","last_arrive_days":null,"last_contact":"2024-03-01 17:10:00","last_arrive":null,"score":"13","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC","visit_base":15},"clientFrom":{"id":154,"key":154,"name":"\u5e7f\u544a\u63a8\u5e7f"},"clientIndustry":{"id":25,"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","client_lock":true,"avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","department_id":9,"avatar":{"id":5,"user_id":5015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":null,"workingAddress":{"id":3043,"name":"\u5317\u4eac\u9f99\u6587\u4e91\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5e7f\u5dde\u9f99\u6587\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8","address1":null,"address2":"","state":null,"city":null,"region":null,"zip":"","country":"\u4e2d\u56fd","geolocation":null,"created_by":1011,"created_at":"2023-02-10 14:57:57","updated_at":"2023-02-10 14:57:57","state_id":null,"city_id":null,"region_id":null,"country_id":1,"lng":null,"lat":null},"unCloseCases":[],"workLogCount":{"client_id":2179,"count":28},"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"addresses":[{"id":1458,"key":1458,"name":"\u5317\u4eac\u5e02\u897f\u57ce\u533a\u83dc\u5e02\u53e3\u5927\u8857\u75322\u53f7\u96625\u53f7\u697c1\u81f32\u5c42119","client_id":2179}],"contacts":[{"id":3973,"name":"\u4e8e\u5148\u751f","email":"","pinyin_shortcut":"yxs","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"13031129983","telephone":"","client_id":2179,"supplier_id":null,"created_by":5015,"created_at":"2022-04-18 18:06:57","updated_at":"2022-04-18 18:06:57","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"yu","pinyin2":"xian","pinyin3":"sheng","pinyin4":null,"namecut1":"\u4e8e","namecut2":"\u5148","namecut3":"\u751f","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","user_status":"-1"},"mobiles":[{"id":4790,"contact_id":3973,"mobile":"13031129983","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null}],"unreadComments":null,"fromContact":null,"workingAddresses":[],"unread":0,"lost_contact_days_display":"1\u5e74\u524d","last_arrive_days_display":null,"bgcolor":"#1EE6DC","overdue_display":"\u903e\u671f498\u5929\u672a\u8054\u7cfb","last_arrive_overdue_display":"\u903e\u671f1226\u5929\u672a\u62dc\u8bbf","can_pick_up":false,"can_transfer":false,"can_update":true,"can_delete":false,"can_give_up":false,"can_create_contact":true,"can_edit_contact":true,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true},{"id":16,"name":"\u5317\u4eac\u6e38\u5b66\u7f51\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjyxwxxfwyxgs","description":"","corp_rep":" \u5f20\u4fe1","website":" http:\/\/www.youxuewang.com.cn","capital":"100","established_at":"2008-03-19","headcount":"\u6280\u672f+\u4e1a\u52a1\u5dee\u4e0d\u591a50\u4eba\u5de6\u53f3","reg_address":33,"working_address":679,"telephone":"010-64812742","fax":"","scale":"\u8fd9\u4e24\u5e74\u4e0d\u600e\u4e48\u597d\uff0c\u5177\u4f53\u5ba2\u6237\u6ca1\u8bf4","branch":"","purchase_scale_per_yr":"0","purchase_freq":"","company_nature":4,"client_class":80,"client_industry":25,"client_type":1,"sales_rep":5311,"main_contact":null,"created_by":5088,"created_at":"2017-02-08 17:50:58","updated_at":"2024-01-31 11:13:40","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"9111010567280823XH","logo":null,"en_name":"","pick_at":"2024-01-15 09:06:20","it_budget":"\u51e0\u5341\u4e07\uff0c\u4e3b\u8981\u662f\u6bcf\u5e74\u7b49\u4fdd\u4e09\u7ea7\u8ba4\u8bc1\u7cfb\u7edf\u8d39\u7528\u6bd4\u8f83\u9ad8\uff0c\u5176\u4ed6\u7684\u6295\u5165\u6bd4\u8f83\u5c11\u3002","deployment_mode":"\u672c\u5730\u90e8\u7f72","it_per_num":"2\u4eba","public_relations_difficulty":"","it_status":"\u6df1\u4fe1\u670d2\u53f0\u684c\u9762\u4e91\uff0c\u534e\u4e3a\u9632\u706b\u5899\u548c\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406","decision_process":"\u6280\u672f\u90e8\u63d0\u9700\u6c42-\u9886\u5bfc\u5ba1\u6279","coach":"\u65e0","competitor":"\u65e0","peers":"","supplier":"","main_product":"\u4e3a\u5b66\u6821\u63d0\u4f9b\u7ec4\u7ec7\u6d3b\u52a8\uff0c\u6709\u5c0f\u5b66\u751f\uff0c\u521d\u4e2d\u751f\uff0c\u73b0\u5728\u6ca1\u6709\u56fd\u5916\u662f\u4e1a\u52a1\uff0c\u75ab\u60c5\u5bf9\u4e1a\u52a1\u5f71\u54cd\u633a\u5927\u7684\uff0c\u73b0\u5728\u4e0d\u50cf\u524d\u51e0\u5e74\u4e1a\u52a1\u597d\u4e86","client_base_info_count":7,"client_key_info_count":10,"contact_count":4,"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,"cooperated":true,"is_public":1,"lost_contact_days":"621.050315243623","last_arrive_days":"896.204481910289","last_contact":"2023-12-29 14:06:00","last_arrive":"2023-03-29 10:24:00+08","score":"26","clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315","visit_base":60},"clientFrom":{"id":153,"key":153,"name":"\u516c\u6d77\u5ba2\u6237"},"clientIndustry":{"id":25,"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","client_lock":true,"avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"createdBy":{"id":5088,"key":5088,"name":"\u7f57\u7199","sex":"F","department_id":1,"avatar":{"id":53,"user_id":5088,"name":"\/files\/cdn\/a57be577deb434\/avatar\/c97f622e-1ed8-3eaf-a309-ea855e309de3.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":16,"comment":7},"workingAddress":{"id":679,"name":"\u5317\u4eac\u6e38\u5b66\u7f51\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8","address1":"","address2":"\u5317\u4eac\u6e38\u5b66\u7f51\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u671d\u9633\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.416532,39.986721)","created_by":5295,"created_at":"2017-09-08 17:10:18","updated_at":"2021-08-01 16:07:51","state_id":110000,"city_id":110100,"region_id":110105,"country_id":1,"lng":"116.416532","lat":"39.986721"},"unCloseCases":[],"workLogCount":{"client_id":16,"count":66},"caseCount":{"client_id":16,"count":29},"salesTimeCount":{"client_id":16,"hours":"1.2","times":2},"implementTimeCount":{"client_id":16,"sum":"36.9166666666667","times":"22"},"presalesTimeCount":{"client_id":16,"sum":"11.1666666666667","times":"7"},"engineerTimeCount":{"client_id":16,"hours":"2","times":1},"reimbursementAmountSum":{"client_id":16,"sum":"149.84"},"addresses":[{"id":331,"key":331,"name":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u60e0\u65b0\u897f\u88579\u53f7\u9662\u60e0\u65b0\u82d17\u53f7\u697c405\u5ba4","client_id":16}],"contacts":[{"id":468,"name":"\u6bb5\u7ea2\u6f6e","email":"IT@dachao.com.cn","pinyin_shortcut":"dhc","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u90e8","job_position":"\u8fd0\u7ef4\u5de5\u7a0b\u5e08","mobile":null,"telephone":"","client_id":16,"supplier_id":null,"created_by":1006,"created_at":"2017-04-05 14:28:39","updated_at":"2017-04-05 14:28:39","user_status":2,"description":null,"contact_type":"1","contact_attitude":2,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":"oagch6QXIz3dkLx9s_mRV1xM3YPs","pinyin1":"duan","pinyin2":"hong","pinyin3":"chao","pinyin4":null,"namecut1":"\u6bb5","namecut2":"\u7ea2","namecut3":null,"namecut4":null,"is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":451,"contact_id":468,"mobile":"13910890782","mp_open_id":"oagch6QXIz3dkLx9s_mRV1xM3YPs"}],"contactKeyRoles":[{"id":137,"key":137,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":20,"name":"\u674e\u6653\u9ece","email":"lixiaoli@dachao.com","pinyin_shortcut":"lxl","sex":"M","birth_date":null,"department":"\u6280\u672f\u90e8","job_position":"\u6280\u672f\u603b\u76d1","mobile":null,"telephone":"","client_id":16,"supplier_id":null,"created_by":1006,"created_at":"2017-02-08 17:52:15","updated_at":"2017-02-08 17:52:15","user_status":2,"description":null,"contact_type":"1","contact_attitude":null,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"li","pinyin2":"xiao","pinyin3":"li","pinyin4":null,"namecut1":"\u674e","namecut2":"\u6653","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":3,"contact_id":20,"mobile":"13691237015","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":830,"name":"\u5f20\u5b89","email":"2881560308@qq.com","pinyin_shortcut":"za","sex":"M","birth_date":null,"department":"","job_position":"","mobile":null,"telephone":"","client_id":16,"supplier_id":null,"created_by":1023,"created_at":"2017-06-13 11:41:34","updated_at":"2017-08-15 18:05:55","user_status":2,"description":null,"contact_type":"1","contact_attitude":null,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"zhang","pinyin2":"an","pinyin3":null,"pinyin4":null,"namecut1":"\u5f20","namecut2":"\u5b89","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","user_status":"1"},"mobiles":[{"id":817,"contact_id":830,"mobile":"13810376713","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":1091,"name":"\u5f20\u603b","email":"","pinyin_shortcut":"zz","sex":"M","birth_date":null,"department":"\u603b\u7ecf\u7406","job_position":"","mobile":null,"telephone":"","client_id":16,"supplier_id":null,"created_by":1006,"created_at":"2017-09-07 07:23:30","updated_at":"2017-09-07 07:23:30","user_status":2,"description":null,"contact_type":"1","contact_attitude":2,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"zhang","pinyin2":"zong","pinyin3":null,"pinyin4":null,"namecut1":"\u5f20","namecut2":"\u603b","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":1084,"contact_id":1091,"mobile":"","mp_open_id":null}],"contactKeyRoles":[{"id":133,"key":133,"name":"\u603b\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":1046,"name":"\u674e\u6676","email":"ldm1020@hotmail.com","pinyin_shortcut":"lj","sex":"F","birth_date":null,"department":"\u4fe1\u606f\u4e2d\u5fc3","job_position":"\u8bbe\u8ba1\u603b\u76d1","mobile":"","telephone":"","client_id":16,"supplier_id":null,"created_by":1006,"created_at":"2017-08-08 13:29:03","updated_at":"2020-10-28 10:45:39","user_status":1,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"li","pinyin2":"jing","pinyin3":null,"pinyin4":null,"namecut1":"\u674e","namecut2":"\u6676","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":3819,"contact_id":1046,"mobile":"18710178180","mp_open_id":null}],"contactKeyRoles":[{"id":137,"key":137,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}}],"unreadComments":null,"fromContact":null,"workingAddresses":[{"id":679,"name":"\u5317\u4eac\u6e38\u5b66\u7f51\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8","address1":"","address2":"\u5317\u4eac\u6e38\u5b66\u7f51\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u671d\u9633\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.416532,39.986721)","created_by":5295,"created_at":"2017-09-08 17:10:18","updated_at":"2021-08-01 16:07:51","state_id":110000,"city_id":110100,"region_id":110105,"country_id":1,"lng":"116.416532","lat":"39.986721"}],"unread":0,"lost_contact_days_display":"1\u5e74\u524d","last_arrive_days_display":"2\u5e74\u524d","bgcolor":"#0EE315","overdue_display":"\u903e\u671f592\u5929\u672a\u8054\u7cfb","last_arrive_overdue_display":"\u903e\u671f837\u5929\u672a\u62dc\u8bbf","can_pick_up":false,"can_transfer":false,"can_update":true,"can_delete":false,"can_give_up":false,"can_create_contact":true,"can_edit_contact":true,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true},{"id":1438,"name":"(\u5e7f\u544a)\u6167\u79d1\u6559\u80b2\u79d1\u6280\u96c6\u56e2\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"gghkjykjjtyxgs","description":"\u4e0d\u9700\u8981\uff0c\u6ca1\u5174\u8da3","corp_rep":"","website":"","capital":null,"established_at":null,"headcount":"","reg_address":null,"working_address":1812,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"0","company_nature":4,"client_class":null,"client_industry":25,"client_type":5,"sales_rep":5311,"main_contact":null,"created_by":5089,"created_at":"2019-07-27 11:26:41","updated_at":"2022-09-01 15:09:14","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2022-03-29 15:51:47","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":1,"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,"cooperated":false,"is_public":1,"lost_contact_days":"1105.02531524362","last_arrive_days":null,"last_contact":"2022-09-01 14:42:00","last_arrive":null,"score":null,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":null,"clientFrom":{"id":154,"key":154,"name":"\u5e7f\u544a\u63a8\u5e7f"},"clientIndustry":{"id":25,"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","client_lock":true,"avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"createdBy":{"id":5089,"key":5089,"name":"\u5b59\u5a77\u5a77","sex":"F","department_id":1,"avatar":{"id":52,"user_id":5089,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e3f43e80-a7e2-33bb-b317-0185418330b4.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":null,"workingAddress":{"id":1812,"name":"(\u5e7f\u544a)\u6167\u79d1\u6559\u80b2\u79d1\u6280\u96c6\u56e2\u6709\u9650\u516c\u53f8","address1":null,"address2":"","state":null,"city":null,"region":null,"zip":"","country":"\u4e2d\u56fd","geolocation":null,"created_by":5295,"created_at":"2019-07-27 11:52:48","updated_at":"2021-09-14 16:04:53","state_id":null,"city_id":null,"region_id":null,"country_id":1,"lng":null,"lat":null},"unCloseCases":[],"workLogCount":{"client_id":1438,"count":3},"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"addresses":[],"contacts":[{"id":2811,"name":"\u738b\u5148\u751f","email":"","pinyin_shortcut":"wxs","sex":"M","birth_date":null,"department":null,"job_position":null,"mobile":"18513518560","telephone":"","client_id":1438,"supplier_id":null,"created_by":5089,"created_at":"2019-07-27 11:26:41","updated_at":"2019-07-27 11:26:41","user_status":2,"description":null,"contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"wang","pinyin2":"xian","pinyin3":"sheng","pinyin4":null,"namecut1":"\u738b","namecut2":"\u5148","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5089,"key":5089,"name":"\u5b59\u5a77\u5a77","sex":"F","user_status":"-1"},"mobiles":[{"id":2928,"contact_id":2811,"mobile":"18513518560","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null}],"unreadComments":null,"fromContact":null,"workingAddresses":[],"unread":0,"lost_contact_days_display":"3\u5e74\u524d","last_arrive_days_display":null,"bgcolor":"gray","overdue_display":"","last_arrive_overdue_display":"","can_pick_up":false,"can_transfer":false,"can_update":true,"can_delete":false,"can_give_up":false,"can_create_contact":true,"can_edit_contact":true,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true},{"id":2263,"name":"\u4e2d\u56fd\u5175\u5668\u5de5\u4e1a\u673a\u5173\u670d\u52a1\u4e2d\u5fc3\u5e7c\u513f\u56ed","abbr":null,"pinyin_shortcut":"zgbqgyjgfwzxyey","description":"2022.8.30\u5ba2\u6237\u518d\u5fd9\uff0c\u8981\u6c42\u7a0d\u540e\u518d\u6253\uff0c\u540c\u610f\u52a0\u5fae\u4fe1","corp_rep":"","website":"","capital":null,"established_at":null,"headcount":"","reg_address":null,"working_address":2791,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":3,"client_class":null,"client_industry":25,"client_type":6,"sales_rep":5332,"main_contact":null,"created_by":5332,"created_at":"2022-10-17 16:23:57","updated_at":"2022-10-24 17:01:03","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2022-10-17 16:23:57","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":1,"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,"cooperated":false,"is_public":1,"lost_contact_days":null,"last_arrive_days":null,"last_contact":"","last_arrive":null,"score":null,"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":null,"clientFrom":{"id":153,"key":153,"name":"\u516c\u6d77\u5ba2\u6237"},"clientIndustry":{"id":25,"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"},"companyNature":{"id":3,"key":3,"name":"\u56fd\u6709\u4f01\u4e1a"},"salesRep":{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","sex":"M","client_lock":false,"avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"}},"createdBy":{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","sex":"M","department_id":1,"avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":null,"workingAddress":{"id":2791,"name":"\u4e2d\u56fd\u5175\u5668\u5de5\u4e1a\u673a\u5173\u670d\u52a1\u4e2d\u5fc3\u5e7c\u513f\u56ed","address1":null,"address2":"","state":null,"city":null,"region":null,"zip":"","country":"\u4e2d\u56fd","geolocation":null,"created_by":5332,"created_at":"2022-10-17 16:23:57","updated_at":"2022-10-24 17:01:03","state_id":null,"city_id":null,"region_id":null,"country_id":1,"lng":null,"lat":null},"unCloseCases":[],"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"addresses":[],"contacts":[{"id":4164,"name":"\u674e\u542b","email":"","pinyin_shortcut":"lh","sex":"F","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":2263,"supplier_id":null,"created_by":5332,"created_at":"2022-10-17 16:23:58","updated_at":"2022-10-17 16:23:58","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"li","pinyin2":"han","pinyin3":null,"pinyin4":null,"namecut1":"\u674e","namecut2":"\u542b","namecut3":null,"namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","sex":"M","user_status":"1"},"mobiles":[{"id":4990,"contact_id":4164,"mobile":"13520048086","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null}],"unreadComments":null,"fromContact":null,"workingAddresses":[],"unread":0,"lost_contact_days_display":null,"last_arrive_days_display":null,"bgcolor":"#808080","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,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true},{"id":2255,"name":"\u4e2d\u56fd\u5175\u5668\u5de5\u4e1a\u96c6\u56e2\u4eba\u624d\u7814\u7a76\u4e2d\u5fc3","abbr":null,"pinyin_shortcut":"zgbqgyjtrcyjzx","description":"2022.8.30\u8bed\u97f3\u63d0\u793a\u62e8\u6253\u7684\u7528\u6237\u5fd9\u7a0d\u540e\u518d\u62e8\n2022.9.14\u5ba2\u6237\u516c\u53f8\u4fe1\u521bpc\u5df2\u7ecf\u90e8\u7f72\u5b8c\u6bd5\uff08\u6d6a\u6f6e\uff09\uff0c\u540c\u610f\u52a0\u5fae\u4fe1\n2022.9.15\u62dc\u8bbf\u60c5\u51b5\uff1a\u5ba2\u6237\u662f\u516c\u53f8\u91c7\u8d2d\uff0cpc\u56fd\u4ea7\u5316\u66ff\u4ee3\u5df2\u7ecf\u90e8\u7f72\u5b8c\u6210\uff08\u6d6a\u6f6e\uff09\uff0c\u5ba2\u6237\u8bf4\u540c\u65b9\u5982\u679c\u5f53\u65f6\u5728\u540d\u5f55\u91cc\u9762\u7684\u4f1a\u9009\u62e9\u540c\u65b9\uff0c\uff08\u5ba2\u6237\u524d\u4fe9\u4e09\u5e74\u5c31\u8fdb\u8d2d\u4e00\u6279\u540c\u65b9\u4ea7\u54c1\uff0c\u6d6a\u6f6e\u4ece\u6765\u6ca1\u6709\u7528\u8fc7\uff0c\u4e0d\u8fc7\u56e0\u4e3a\u5355\u4f4d\u4e5f\u662f\u6025\u9700\u6240\u4ee5\u91c7\u8d2d\u4e86\u6d6a\u6f6e\uff09\uff0c\u540c\u65b9\u4e5f\u662f\u540e\u6765\u624d\u52a0\u8fdb\u53bb\u7684\u3002\u4ece\u5ba2\u6237\u4e86\u89e3\u5230\u5317\u4eac\u4e0b\u5c5e\u5355\u4f4d\u56fd\u4ea7\u5316\u66ff\u4ee3\u90fd\u4f1a\u53c2\u7167\u4e2d\u5175\u603b\u90e8\u4fe1\u606f\u90e8\u63a8\u8350\u3002","corp_rep":"","website":"","capital":null,"established_at":null,"headcount":"","reg_address":null,"working_address":2785,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":3,"client_class":null,"client_industry":25,"client_type":6,"sales_rep":5332,"main_contact":null,"created_by":5332,"created_at":"2022-09-26 16:25:18","updated_at":"2022-10-31 10:20:25","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2022-09-26 16:25:18","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":1,"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,"cooperated":false,"is_public":1,"lost_contact_days":null,"last_arrive_days":null,"last_contact":"","last_arrive":null,"score":null,"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":null,"clientFrom":{"id":153,"key":153,"name":"\u516c\u6d77\u5ba2\u6237"},"clientIndustry":{"id":25,"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"},"companyNature":{"id":3,"key":3,"name":"\u56fd\u6709\u4f01\u4e1a"},"salesRep":{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","sex":"M","client_lock":false,"avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"}},"createdBy":{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","sex":"M","department_id":1,"avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":null,"workingAddress":{"id":2785,"name":"\u4e2d\u56fd\u5175\u5668\u5de5\u4e1a\u96c6\u56e2\u4eba\u624d\u7814\u7a76\u4e2d\u5fc3","address1":null,"address2":"","state":null,"city":null,"region":null,"zip":"","country":"\u4e2d\u56fd","geolocation":null,"created_by":5332,"created_at":"2022-09-26 16:25:18","updated_at":"2022-10-24 17:02:03","state_id":null,"city_id":null,"region_id":null,"country_id":1,"lng":null,"lat":null},"unCloseCases":[],"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"addresses":[{"id":1449,"key":1449,"name":"\u5317\u4eac\u5e02\u4e30\u53f0\u533a\u5357\u56db\u73af\u897f\u8def188\u53f7(\u603b\u90e8\u57fa\u5730)\u4e09\u533a","client_id":2255}],"contacts":[{"id":4163,"name":"\u5b8b\u7389\u9f99","email":"","pinyin_shortcut":"syl","sex":"M","birth_date":null,"department":"\u7efc\u5408\u7ba1\u7406","job_position":"\u91c7\u8d2d","mobile":"","telephone":"","client_id":2255,"supplier_id":null,"created_by":5332,"created_at":"2022-10-17 16:21:39","updated_at":"2022-10-17 16:21:39","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"song","pinyin2":"yu","pinyin3":"long","pinyin4":null,"namecut1":"\u5b8b","namecut2":"\u7389","namecut3":"\u9f99","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","sex":"M","user_status":"1"},"mobiles":[{"id":4989,"contact_id":4163,"mobile":"18611697267","mp_open_id":null}],"contactKeyRoles":[{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"}],"contactAttitude":null}],"unreadComments":null,"fromContact":null,"workingAddresses":[],"unread":0,"lost_contact_days_display":null,"last_arrive_days_display":null,"bgcolor":"#808080","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,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true},{"id":77,"name":"\u5317\u4eac\u7f8e\u51ef\u8fbe\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjmkdjykjyxgs","description":"","corp_rep":"\u6c99\u4e91\u9f99","website":"","capital":"1000","established_at":"2014-09-28","headcount":"30","reg_address":167,"working_address":596,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":25,"client_type":1,"sales_rep":null,"main_contact":null,"created_by":5088,"created_at":"2017-02-16 22:48:03","updated_at":"2024-07-04 17:36:07","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"","it_budget":null,"deployment_mode":null,"it_per_num":null,"public_relations_difficulty":null,"it_status":null,"decision_process":null,"coach":null,"competitor":null,"peers":null,"supplier":null,"main_product":null,"client_base_info_count":4,"client_key_info_count":1,"contact_count":2,"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,"cooperated":true,"is_public":0,"lost_contact_days":"432.9405930214","last_arrive_days":"1496.97639163251","last_contact":"2024-07-04 16:44:00","last_arrive":"2021-08-05 15:52:27+08","score":"21","clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC","visit_base":15},"clientFrom":{"id":153,"key":153,"name":"\u516c\u6d77\u5ba2\u6237"},"clientIndustry":{"id":25,"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"salesRep":null,"createdBy":{"id":5088,"key":5088,"name":"\u7f57\u7199","sex":"F","department_id":1,"avatar":{"id":53,"user_id":5088,"name":"\/files\/cdn\/a57be577deb434\/avatar\/c97f622e-1ed8-3eaf-a309-ea855e309de3.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":null,"workingAddress":{"id":596,"name":"\u5317\u4eac\u7f8e\u51ef\u8fbe\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8","address1":"","address2":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u6d77\u6dc0\u8857\u9053\u521b\u5bcc\u5927\u53a6","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u6d77\u6dc0\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.307905316353,39.9785680980463)","created_by":5302,"created_at":"2017-06-16 09:32:26","updated_at":"2021-07-14 11:37:09","state_id":110000,"city_id":110100,"region_id":110108,"country_id":1,"lng":"116.307905316353","lat":"39.9785680980463"},"unCloseCases":[],"workLogCount":{"client_id":77,"count":19},"caseCount":{"client_id":77,"count":1},"salesTimeCount":{"client_id":77,"hours":"0.194722222222222","times":1},"implementTimeCount":{"client_id":77,"sum":"1.2","times":"1"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"addresses":[{"id":382,"key":382,"name":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u4e2d\u5173\u6751\u4e39\u68f1\u885718\u53f7\u521b\u5bcc\u5927\u53a616\u5c42","client_id":77}],"contacts":[{"id":869,"name":"\u6731\u91d1\u5c71","email":"","pinyin_shortcut":"zjs","sex":"M","birth_date":null,"department":"","job_position":"","mobile":null,"telephone":"","client_id":77,"supplier_id":null,"created_by":1018,"created_at":"2017-06-20 08:46:45","updated_at":"2017-06-20 08:46:45","user_status":2,"description":null,"contact_type":"1","contact_attitude":null,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"zhu","pinyin2":"jin","pinyin3":"shan","pinyin4":null,"namecut1":"\u6731","namecut2":"\u91d1","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1018,"key":1018,"name":"\u7a0b\u946b\u658c","sex":"M","user_status":"-1"},"mobiles":[{"id":850,"contact_id":869,"mobile":"18513955783","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":155,"name":"\u7f57\u67ef","email":"luoke@pxjy.com","pinyin_shortcut":"lk","sex":"M","birth_date":null,"department":"\u6280\u672f\u90e8","job_position":"\u603b\u76d1","mobile":null,"telephone":"82605578-8043","client_id":77,"supplier_id":null,"created_by":1003,"created_at":"2017-02-16 22:48:58","updated_at":"2017-02-16 22:48:58","user_status":2,"description":null,"contact_type":"1","contact_attitude":null,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"luo","pinyin2":"ke","pinyin3":null,"pinyin4":null,"namecut1":"\u7f57","namecut2":"\u67ef","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","user_status":"-1"},"mobiles":[{"id":149,"contact_id":155,"mobile":"13683082529","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null}],"unreadComments":null,"fromContact":null,"workingAddresses":[{"id":596,"name":"\u5317\u4eac\u7f8e\u51ef\u8fbe\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8","address1":"","address2":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u6d77\u6dc0\u8857\u9053\u521b\u5bcc\u5927\u53a6","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u6d77\u6dc0\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.307905316353,39.9785680980463)","created_by":5302,"created_at":"2017-06-16 09:32:26","updated_at":"2021-07-14 11:37:09","state_id":110000,"city_id":110100,"region_id":110108,"country_id":1,"lng":"116.307905316353","lat":"39.9785680980463"}],"unread":0,"lost_contact_days_display":"1\u5e74\u524d","last_arrive_days_display":"4\u5e74\u524d","bgcolor":"#1EE6DC","overdue_display":"\u903e\u671f373\u5929\u672a\u8054\u7cfb","last_arrive_overdue_display":"\u903e\u671f1482\u5929\u672a\u62dc\u8bbf","can_pick_up":false,"can_transfer":true,"can_update":true,"can_delete":true,"can_give_up":false,"can_create_contact":true,"can_edit_contact":true,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true},{"id":154,"name":"\u5317\u4eac\u5c1a\u5fb7\u5728\u7ebf\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8-\u62d2\u7edd","abbr":null,"pinyin_shortcut":"bjsdzxjykjyxgsjj","description":"\u5ba2\u6237\u7684\u8bf4\u6cd5\u662f\u548c\u5382\u5546\u76f4\u63a5\u5728\u8c08\uff0c\u4e0d\u9700\u8981\u6211\u4eec\u3002","corp_rep":"\u5218\u901a\u535a ","website":"http:\/\/m.sunlands.com\/ls_bj\/pc2\/index.html?plan_id=92610&keyword_id=42196430","capital":"256.674236","established_at":"2013-09-27","headcount":"1000","reg_address":336,"working_address":337,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"100","purchase_freq":"3","company_nature":4,"client_class":43,"client_industry":25,"client_type":1,"sales_rep":null,"main_contact":null,"created_by":1003,"created_at":"2017-03-09 18:16:32","updated_at":"2023-11-10 21:38:08","main_business":"\u6280\u672f\u670d\u52a1\uff1b\u6559\u80b2\u54a8\u8be2","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":5,"client_key_info_count":2,"contact_count":2,"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,"cooperated":false,"is_public":0,"lost_contact_days":"670.210731910289","last_arrive_days":null,"last_contact":"2023-11-10 10:15:00","last_arrive":null,"score":"23","clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC","visit_base":15},"clientFrom":{"id":153,"key":153,"name":"\u516c\u6d77\u5ba2\u6237"},"clientIndustry":{"id":25,"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"salesRep":null,"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":154,"comment":5},"workingAddress":{"id":337,"name":"\u5317\u4eac\u5c1a\u5fb7\u5728\u7ebf\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8-\u62d2\u7edd","address1":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u6765\u5e7f\u8425\u671d\u6765\u79d1\u6280\u56ed26\u53f7\u697c2\u5c42","address2":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u671d\u6765\u9ad8\u79d1\u6280\u4ea7\u4e1a\u56ed(\u5317\u95e8)","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u77f3\u666f\u5c71\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.193511,39.939462)","created_by":5329,"created_at":"2017-03-09 18:16:33","updated_at":"2022-07-21 15:36:37","state_id":110000,"city_id":110100,"region_id":110107,"country_id":1,"lng":"116.193511","lat":"39.939462"},"unCloseCases":[],"workLogCount":{"client_id":154,"count":18},"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"addresses":[{"id":204,"key":204,"name":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u6765\u5e7f\u8425\u671d\u6765\u79d1\u6280\u56ed26\u53f7\u697c2\u5c42","client_id":154},{"id":205,"key":205,"name":"\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u5b9e\u5174\u5927\u885730\u53f7\u96623\u53f7\u697c2\u5c42A-0193\u623f\u95f4","client_id":154}],"contacts":[{"id":3482,"name":"\u53f2\u8001\u5e08","email":"","pinyin_shortcut":"sls","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":154,"supplier_id":null,"created_by":5089,"created_at":"2020-12-24 14:31:43","updated_at":"2020-12-24 14:31:43","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"shi","pinyin2":"lao","pinyin3":"shi","pinyin4":null,"namecut1":"\u53f2","namecut2":"\u8001","namecut3":"\u5e08","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5089,"key":5089,"name":"\u5b59\u5a77\u5a77","sex":"F","user_status":"-1"},"mobiles":[{"id":3979,"contact_id":3482,"mobile":"18910098110","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":313,"name":"\u59da\u4eae","email":"yaoliang@sunland.org.cn","pinyin_shortcut":"yl","sex":"M","birth_date":null,"department":"\u6280\u672f\u90e8","job_position":"\u7ecf\u7406","mobile":"","telephone":"","client_id":154,"supplier_id":null,"created_by":1003,"created_at":"2017-03-09 18:18:33","updated_at":"2020-09-10 14:10:34","user_status":3,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"yao","pinyin2":"liang","pinyin3":null,"pinyin4":null,"namecut1":"\u59da","namecut2":"\u4eae","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":3,"key":3,"name":"\u5931\u8054"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","user_status":"-1"},"mobiles":[{"id":3725,"contact_id":313,"mobile":"13581749409","mp_open_id":null}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":null},{"id":1223,"name":"\u7b80\u5148\u751f","email":"","pinyin_shortcut":"jxs","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":154,"supplier_id":null,"created_by":5027,"created_at":"2017-10-30 11:27:19","updated_at":"2017-10-30 11:27:19","user_status":2,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"jian","pinyin2":"xian","pinyin3":"sheng","pinyin4":null,"namecut1":"\u7b80","namecut2":"\u5148","namecut3":"\u751f","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5027,"key":5027,"name":"\u5b59\u5c11\u752b","sex":"M","user_status":"-1"},"mobiles":[{"id":1231,"contact_id":1223,"mobile":"15010435466","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":1313,"name":"\u5218\u6653\u5b87","email":"liuxiaoyu@sunland.org.cn","pinyin_shortcut":"lxy","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u90e8","job_position":"\u7ecf\u7406","mobile":"","telephone":"","client_id":154,"supplier_id":null,"created_by":1003,"created_at":"2017-11-22 16:41:53","updated_at":"2021-09-10 10:30:18","user_status":1,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"liu","pinyin2":"xiao","pinyin3":"yu","pinyin4":null,"namecut1":"\u5218","namecut2":"\u6653","namecut3":"\u5b87","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","user_status":"-1"},"mobiles":[{"id":3978,"contact_id":1313,"mobile":"15010752732","mp_open_id":null}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}}],"unreadComments":null,"fromContact":null,"workingAddresses":[{"id":337,"name":"\u5317\u4eac\u5c1a\u5fb7\u5728\u7ebf\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8-\u62d2\u7edd","address1":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u6765\u5e7f\u8425\u671d\u6765\u79d1\u6280\u56ed26\u53f7\u697c2\u5c42","address2":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u671d\u6765\u9ad8\u79d1\u6280\u4ea7\u4e1a\u56ed(\u5317\u95e8)","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u77f3\u666f\u5c71\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.193511,39.939462)","created_by":5329,"created_at":"2017-03-09 18:16:33","updated_at":"2022-07-21 15:36:37","state_id":110000,"city_id":110100,"region_id":110107,"country_id":1,"lng":"116.193511","lat":"39.939462"}],"unread":0,"lost_contact_days_display":"1\u5e74\u524d","last_arrive_days_display":null,"bgcolor":"#1EE6DC","overdue_display":"\u903e\u671f611\u5929\u672a\u8054\u7cfb","last_arrive_overdue_display":"\u903e\u671f3092\u5929\u672a\u62dc\u8bbf","can_pick_up":false,"can_transfer":true,"can_update":true,"can_delete":true,"can_give_up":false,"can_create_contact":true,"can_edit_contact":true,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true},{"id":318,"name":"\u5317\u4eac\u5317\u65b9\u6295\u8d44\u96c6\u56e2","abbr":null,"pinyin_shortcut":"bjbftzjt","description":"\u53ef\u9009","corp_rep":"","website":"","capital":null,"established_at":null,"headcount":"","reg_address":546,"working_address":842,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"10","purchase_freq":"","company_nature":4,"client_class":null,"client_industry":25,"client_type":1,"sales_rep":null,"main_contact":null,"created_by":5209,"created_at":"2017-05-18 17:05:49","updated_at":"2023-11-09 23:42:54","main_business":"\u6559\u80b2\u4ea7\u4e1a\u6295\u8d44\u3001\u57ce\u5e02\u4ea7\u4e1a\u6295\u8d44\uff08\u7269\u6d41\u5e02\u573a\u5efa\u8bbe\u3001\u4ea7\u4e1a\u5de5\u4e1a\u56ed\u6295\u8d44\u3001\u4ea7\u4e1a\u5e02\u573a\u6295\u8d44\uff09\u3001\u91d1\u878d\u6295\u8d44","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2023-06-08 23:02:32","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":1,"contact_count":1,"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,"cooperated":false,"is_public":0,"lost_contact_days":"670.691287465845","last_arrive_days":null,"last_contact":"2023-11-09 22:43:00","last_arrive":null,"score":null,"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":null,"clientFrom":{"id":153,"key":153,"name":"\u516c\u6d77\u5ba2\u6237"},"clientIndustry":{"id":25,"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"salesRep":null,"createdBy":{"id":5209,"key":5209,"name":"\u5d14\u5efa\u8def","sex":"M","department_id":1,"avatar":{"id":97,"user_id":5209,"name":"\/files\/cdn\/a57be577deb434\/avatar\/6c5d6a16-2d9e-3ca1-99ec-e704387ea298.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":318,"comment":3},"workingAddress":{"id":842,"name":"\u5317\u4eac\u5317\u65b9\u6295\u8d44\u96c6\u56e2","address1":"","address2":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u9890\u548c\u56ed\u8def5\u53f7","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u6d77\u6dc0\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.310905,39.992806)","created_by":5300,"created_at":"2017-11-27 18:06:07","updated_at":"2021-11-24 15:31:21","state_id":110000,"city_id":110100,"region_id":110108,"country_id":1,"lng":"116.310905","lat":"39.992806"},"unCloseCases":[],"workLogCount":{"client_id":318,"count":20},"caseCount":{"client_id":318,"count":1},"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":{"client_id":318,"sum":"2.5","times":"1"},"engineerTimeCount":null,"reimbursementAmountSum":null,"addresses":[{"id":43,"key":43,"name":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u961c\u6210\u8def\u5317\u4e09\u88578\u53f7","client_id":318}],"contacts":[{"id":660,"name":"\u674e\u5efa\u4e1c","email":"","pinyin_shortcut":"ljd","sex":"M","birth_date":null,"department":"\u540e\u52e4\u90e8","job_position":"\u526f\u603b\u7ecf\u7406","mobile":"","telephone":"68983288","client_id":318,"supplier_id":null,"created_by":1006,"created_at":"2017-05-18 17:06:58","updated_at":"2023-08-17 14:44:48","user_status":1,"description":"\u9000\u4f11\u4e86","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"li","pinyin2":"jian","pinyin3":"dong","pinyin4":null,"namecut1":"\u674e","namecut2":"\u5efa","namecut3":"\u4e1c","namecut4":null,"is_mp_bind":null,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":643,"contact_id":660,"mobile":"13701070701","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":664,"name":"\u5b54\u6210\u4f1f","email":"","pinyin_shortcut":"kcw","sex":"M","birth_date":null,"department":"\u62db\u6807\u91c7\u8d2d\u529e","job_position":"\u62db\u6807\u91c7\u8d2d\u4e3b\u4efb","mobile":null,"telephone":"","client_id":318,"supplier_id":null,"created_by":1006,"created_at":"2017-05-18 19:49:15","updated_at":"2018-05-23 16:03:46","user_status":1,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"kong","pinyin2":"cheng","pinyin3":"wei","pinyin4":null,"namecut1":"\u5b54","namecut2":"\u6210","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":719,"contact_id":664,"mobile":"13366399121","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":1323,"name":"\u8d75\u8015\u6797","email":"15011212426@163.com","pinyin_shortcut":"zgl","sex":"M","birth_date":null,"department":"\u603b\u5de5\u529e","job_position":"\u9ad8\u7ea7\u5de5\u7a0b\u5e08","mobile":null,"telephone":"","client_id":318,"supplier_id":null,"created_by":5045,"created_at":"2017-11-23 14:37:50","updated_at":"2017-11-23 14:37:50","user_status":2,"description":null,"contact_type":"1","contact_attitude":1,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"zhao","pinyin2":"geng","pinyin3":"lin","pinyin4":null,"namecut1":"\u8d75","namecut2":"\u8015","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5045,"key":5045,"name":"\u5218\u5c0a\u559c","sex":"M","user_status":"-1"},"mobiles":[{"id":882,"contact_id":1323,"mobile":"15011212426","mp_open_id":null}],"contactKeyRoles":[{"id":137,"key":137,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}}],"unreadComments":null,"fromContact":null,"workingAddresses":[{"id":842,"name":"\u5317\u4eac\u5317\u65b9\u6295\u8d44\u96c6\u56e2","address1":"","address2":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u9890\u548c\u56ed\u8def5\u53f7","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u6d77\u6dc0\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.310905,39.992806)","created_by":5300,"created_at":"2017-11-27 18:06:07","updated_at":"2021-11-24 15:31:21","state_id":110000,"city_id":110100,"region_id":110108,"country_id":1,"lng":"116.310905","lat":"39.992806"}],"unread":0,"lost_contact_days_display":"1\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":true,"can_give_up":false,"can_create_contact":true,"can_edit_contact":true,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":true}],"pagenation":{"totalcount":20,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-10 15:18:27') RETURNING "id" |