Database Queries

总计45条数据

Time	Duration	Type	Query

16:19:38.724	2.3 ms	SELECT	SELECT * FROM "global"."vw_user_login" WHERE "id"=5250 /var/www/beta/models/Login.php:65 /var/www/beta/vendor/uranus/web/User.php:201 /var/www/beta/modules/vue/controllers/CommonController.php:106 [+] Explain
16:19:38.727	1.5 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250 /var/www/beta/modules/vue/controllers/CommonController.php:122 /var/www/beta/modules/vue/controllers/ClientController.php:118 [+] Explain
16:19:38.733	28.3 ms	SELECT	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 259::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 259::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"='5332')) AND (("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"=5250))) 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" /var/www/beta/modules/vue/controllers/ClientController.php:466 [+] Explain
16:19:38.762	23.6 ms	SELECT	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 259::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 259::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"='5332')) AND (("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"=5250))) 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 20 /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.786	0.4 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id" IN (6, 1, 5) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.787	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name", "notice_days", "color", "visit_base" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (47, 43) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.787	0.6 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2125, 85, 2138, 3326, 57, 101, 2205, 1276, 20) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.788	0.6 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=14) AND ("id" IN (96, 101, 165, 179, 142, 100, 97, 107, 226, 164, 171, 181, 8, 212, 160, 327, 183, 190, 136, 140, 205, 199, 197, 184, 189, 94, 154, 167, 157, 166, 5, 1, 2, 185, 191, 210, 11, 217, 213, 131, 172, 331, 156, 114, 112, 317, 319, 2100000000, 349, 369, 377, 324, 340, 326, 359)) ORDER BY "sort" /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.789	0.3 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id" IN (20, 5, 1, 19) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.789	0.3 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_company_natures" WHERE "id" IN (1, 4, 6) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.790	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name", "sex", "client_lock" FROM "a57be577deb434"."tbl_users" WHERE "id"=5332 /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.790	0.5 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5332) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.791	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5087, 1005, 5413, 1006, 1011, 5096) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.791	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 5413, 5096, 1006, 1005, 5087)) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.791	0.4 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (3, 9, 1) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.792	21.2 ms	SELECT	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=10) AND ("object_id" IN (2125, 85, 2138, 3326, 57, 101, 2205, 1276, 20)) GROUP BY "object_id" /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.813	0.5 ms	SELECT	SELECT *, geolocation[0] AS lng, geolocation[1] AS lat FROM "a57be577deb434"."tbl_addresses" WHERE "id" IN (2653, 824, 668, 641, 2746, 647) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.814	1.1 ms	SELECT	SELECT "id", "client_id" FROM "a57be577deb434"."tbl_cases" WHERE ("case_status" NOT IN (5, 6)) AND ("client_id" IN (2125, 85, 2138, 3326, 57, 101, 2205, 1276, 20)) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.815	1.1 ms	SELECT	SELECT "client_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("start_at" >= '2025-01-01 00:00:00') AND ("start_at" <= '2025-12-31 23:59:59') AND ("client_id" IN (2125, 85, 2138, 3326, 57, 101, 2205, 1276, 20)) GROUP BY "client_id" /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.817	1.1 ms	SELECT	SELECT "client_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE ("created_at" >= '2025-01-01 00:00:00') AND ("created_at" <= '2025-12-31 23:59:59') AND ("client_id" IN (2125, 85, 2138, 3326, 57, 101, 2205, 1276, 20)) GROUP BY "client_id" /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.818	1.1 ms	SELECT	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 ("start_at" >= '2025-01-01 00:00:00') AND ("start_at" <= '2025-12-31 23:59:59') AND ("client_id" IN (2125, 85, 2138, 3326, 57, 101, 2205, 1276, 20)) GROUP BY "client_id" /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.819	5.8 ms	SELECT	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 ("created_at" >= '2025-01-01 00:00:00') AND ("created_at" <= '2025-12-31 23:59:59') AND ("c"."client_id" IN (2125, 85, 2138, 3326, 57, 101, 2205, 1276, 20)) GROUP BY "c"."client_id" /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.826	2.5 ms	SELECT	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 ("created_at" >= '2025-01-01 00:00:00') AND ("created_at" <= '2025-12-31 23:59:59') AND ("c"."client_id" IN (2125, 85, 2138, 3326, 57, 101, 2205, 1276, 20)) GROUP BY "c"."client_id" /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.828	1.1 ms	SELECT	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 (2125, 85, 2138, 3326, 57, 101, 2205, 1276, 20)) GROUP BY "client_id" /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.829	1.4 ms	SELECT	SELECT "client_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("occurrence_at" >= '2025-01-01 00:00:00') AND ("occurrence_at" <= '2025-12-31 23:59:59') AND ("client_id" IN (2125, 85, 2138, 3326, 57, 101, 2205, 1276, 20)) GROUP BY "client_id" /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.831	0.4 ms	SELECT	SELECT "id", "id" AS "key", "address" AS "name", "client_id" FROM "a57be577deb434"."tbl_client_addresses" WHERE "client_id" IN (2125, 85, 2138, 3326, 57, 101, 2205, 1276, 20) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.832	1.4 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "client_id" IN (2125, 85, 2138, 3326, 57, 101, 2205, 1276, 20) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.833	0.3 ms	SELECT	SELECT "id", "id" AS "key", "status" AS "name" FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id" IN (2, 1) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.834	0.3 ms	SELECT	SELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5311, 5087, 1023, 1005, 5299, 1022, 1015, 5063, 5088, 5096, 1016, 1006, 5082, 1011, 5015, 5413) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.834	1.6 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (3887, 3871, 3979, 514, 3829, 2954, 3768, 3773, 767, 1143, 850, 2250, 3017, 181, 3624, 3492, 515, 3652, 3549, 1331, 731, 3324, 2591, 1334, 3023, 1335, 979, 100, 1087, 25, 1785, 1568, 837, 1847, 2930, 1861, 2062, 2795, 1073, 2979, 4051, 4106, 4147, 4149, 4402, 4448, 4449, 4583, 4584, 4642, 4690, 4745, 5055, 5200, 5756, 5801, 5798, 5809, 5845, 5936, 5955, 5996, 6045, 6053) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.836	2.0 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3887, 3871, 3979, 514, 3829, 2954, 3768, 3773, 767, 1143, 850, 2250, 3017, 181, 3624, 3492, 515, 3652, 3549, 1331, 731, 3324, 2591, 1334, 3023, 1335, 979, 100, 1087, 25, 1785, 1568, 837, 1847, 2930, 1861, 2062, 2795, 1073, 2979, 4051, 4106, 4147, 4149, 4402, 4448, 4449, 4583, 4584, 4642, 4690, 4745, 5055, 5200, 5756, 5801, 5798, 5809, 5845, 5936, 5955, 5996, 6045, 6053) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.839	0.5 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (97, 213, 212, 165, 179, 142, 1, 128, 107, 173, 153, 46, 101, 5, 100, 164, 167, 181, 129, 102, 6, 168, 140, 131, 135, 8, 183, 184, 194, 177, 2, 189, 197, 199, 156, 200, 154, 94, 7, 9, 11, 210, 166, 136, 139, 226, 208, 105, 160, 198, 202, 205, 204, 215, 229, 172, 133, 137, 134, 158, 196, 175, 185, 191, 331, 313, 138, 163, 232, 333, 114, 130, 178, 265, 174, 319, 320, 337, 307, 309, 317, 340, 2100000000, 316, 349, 311, 315, 324, 155, 354, 359, 366, 369, 374, 377, 326, 344, 332, 341, 352, 356, 379, 2100000001)) ORDER BY "sort" /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.840	1.8 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3887, 3871, 3979, 514, 3829, 2954, 3768, 3773, 767, 1143, 850, 2250, 3017, 181, 3624, 3492, 515, 3652, 3549, 1331, 731, 3324, 2591, 1334, 3023, 1335, 979, 100, 1087, 25, 1785, 1568, 837, 1847, 2930, 1861, 2062, 2795, 1073, 2979, 4051, 4106, 4147, 4149, 4402, 4448, 4449, 4583, 4584, 4642, 4690, 4745, 5055, 5200, 5756, 5801, 5798, 5809, 5845, 5936, 5955, 5996, 6045, 6053) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.842	0.5 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (97, 213, 212, 165, 179, 142, 1, 128, 107, 173, 153, 46, 101, 5, 100, 164, 167, 181, 129, 102, 6, 168, 140, 131, 135, 8, 183, 184, 194, 177, 2, 189, 197, 199, 156, 200, 154, 94, 7, 9, 11, 210, 166, 136, 139, 226, 208, 105, 160, 198, 202, 205, 204, 215, 229, 172, 133, 137, 134, 158, 196, 175, 185, 191, 331, 313, 138, 163, 232, 333, 114, 130, 178, 265, 174, 319, 320, 337, 307, 309, 317, 340, 2100000000, 316, 349, 311, 315, 324, 155, 354, 359, 366, 369, 374, 377, 326, 344, 332, 341, 352, 356, 379, 2100000001)) ORDER BY "sort" /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.843	17.8 ms	SELECT	SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=10) AND (remind_user_id = 5250 AND is_read = false) AND ("object_id" IN (2125, 85, 2138, 3326, 57, 101, 2205, 1276, 20)) GROUP BY "object_id" /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.861	0.4 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_client_address_rels" WHERE "client_id" IN (2125, 85, 2138, 3326, 57, 101, 2205, 1276, 20) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.862	0.5 ms	SELECT	SELECT *, geolocation[0] AS lng, geolocation[1] AS lat FROM "a57be577deb434"."tbl_addresses" WHERE ("address2" != '') AND ("address2" IS NOT NULL) AND ("id" IN (641, 668, 2653, 824, 647, 2746, 4002, 4119)) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.862	1.8 ms	SELECT	SELECT s.id, client_id, project_id, schedule_title, complete_at, start_at, end_at, created_by, is_complete, is_closed, complete_description, set_top_at, CASE WHEN is_complete = true then 3 WHEN is_complete = false and end_at <= NOW() then 2 else 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (("is_complete"=FALSE) OR ("complete_at" >= '2025-09-02')) AND ((("is_public"=1) AND ("created_by" != 5250)) OR ("created_by"=5250) OR ("ccr"."user_id"=5250)) AND ("s"."client_id" IN (2125, 85, 2138, 3326, 57, 101, 2205, 1276, 20)) ORDER BY set_top_at DESC nulls last, sort ASC, case when is_complete = true then complete_at END desc, case when is_complete = false then end_at END asc, end_at DESC /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.864	0.5 ms	SELECT	SELECT "id", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE ("project_status"='3') AND ("client_id" IN (2125, 85, 2138, 3326, 57, 101, 2205, 1276, 20)) /var/www/beta/modules/vue/controllers/ClientController.php:468 [+] Explain
16:19:38.867	0.3 ms	SELECT	SELECT "id", "name", "sex", "client_lock" FROM "a57be577deb434"."tbl_users" WHERE "id"='5332' /var/www/beta/modules/vue/controllers/ClientController.php:486 [+] Explain
16:19:38.867	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5332) /var/www/beta/modules/vue/controllers/ClientController.php:486 [+] Explain
16:19:38.868	23.0 ms	SELECT	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 259::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 259::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"='5332')) AND (("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"=5250))) AND ("deleted"=FALSE) AND (("c"."sales_rep" IN (SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE ("id" 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)) AND ("user_status"=1) AND ("client_lock"=FALSE) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first)) OR (c.sales_rep IS NULL)) GROUP BY "c"."id", "cl"."id", "cooperated", "lost_contact_days", "last_contact" ORDER BY "is_public" DESC) "c" /var/www/beta/modules/vue/controllers/ClientController.php:506 [+] Explain
16:19:38.894	3.7 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5250) AND ("object_type"=10) AND ("visit_date"='2025-09-16') /var/www/beta/modules/vue/controllers/CommonController.php:772 /var/www/beta/modules/vue/controllers/CommonController.php:566 /var/www/beta/modules/vue/controllers/CommonController.php:363 [+] Explain
16:19:38.898	0.9 ms	UPDATE	UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=25, "last_visit_at"='now()' WHERE "id"=56607 /var/www/beta/modules/vue/controllers/CommonController.php:784 /var/www/beta/modules/vue/controllers/CommonController.php:566 /var/www/beta/modules/vue/controllers/CommonController.php:363 [+] Explain
16:19:38.900	3.4 ms	INSERT	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5250, 5, 'vue/client/list', '{"ClientSearch":{"sales_rep":["5332"],"group":"","client_class":"","has_contact":"","cooperated":"","client_type":"","company_nature":"","client_industry":"","from_contact_name":"","from_contact":"","state_id":"","created_period":"","created_by":""},"is_all":"0","other_period":"currentfascalyear","Filter":{"name":"lost_contact_days","sort":"DESC"},"page":"1","web_access_token":"3uawlwxh65Fl0RYHt8Wv0NFz9kaCjHtV"}', '{"code":2000,"result":{"list":[{"id":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382","abbr":"","pinyin_shortcut":"bjhxjqzzyxgs239c","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":2653,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":20,"client_type":6,"sales_rep":5332,"main_contact":"","created_by":5087,"created_at":"2021-12-19 18:01:00","updated_at":"2025-09-16 16:19:28","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2025-09-16 16:19:28","it_budget":"","deployment_mode":"","it_per_num":"19\u4eba","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":6,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":1,"case_implement_count":17,"is_overdue_remind":false,"from_contact":"","tax_no":"","cooperated":true,"is_public":1,"lost_contact_days":"22.7115597603819","last_arrive_days":"","last_contact":"2025-08-24 23:15:00","last_arrive":"","score":"46","clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3","visit_base":10},"clientFrom":{"id":157,"key":157,"name":"\u670b\u53cb\u4ecb\u7ecd"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"},"companyNature":{"id":1,"key":1,"name":"\u56fd\u6709\u4e0a\u5e02"},"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":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{},"workingAddress":{"id":2653,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382","address1":"","address2":"\u5317\u4eac\u5e02\u4e1c\u57ce\u533a:\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u4e1c\u57ce\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.421783,39.953888)","created_by":5087,"created_at":"2021-12-19 18:01:01","updated_at":"2021-12-24 06:32:49","state_id":110000,"city_id":110100,"region_id":110101,"country_id":1,"lng":"116.421783","lat":"39.953888"},"unCloseCases":[],"workLogCount":{"client_id":2125,"count":9},"caseCount":{"client_id":2125,"count":18},"salesTimeCount":"","implementTimeCount":{"client_id":2125,"sum":"55.65","times":"17"},"presalesTimeCount":{"client_id":2125,"sum":"3.58333333333333","times":"1"},"engineerTimeCount":"","reimbursementAmountSum":{"client_id":2125,"sum":"1865.10"},"addresses":[],"contacts":[{"id":4583,"name":"\u674e\u660e","email":"","pinyin_shortcut":"lm","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2125,"supplier_id":"","created_by":5087,"created_at":"2023-04-19 11:26:39","updated_at":"2023-04-19 11:26:39","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"li","pinyin2":"ming","pinyin3":"","pinyin4":"","namecut1":"\u674e","namecut2":"\u660e","namecut3":"","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":5393,"contact_id":4583,"mobile":"18514568846","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""},{"id":4584,"name":"\u4e01\u654f","email":"","pinyin_shortcut":"dm","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2125,"supplier_id":"","created_by":5087,"created_at":"2023-04-19 11:30:35","updated_at":"2023-04-19 11:30:35","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"ding","pinyin2":"min","pinyin3":"","pinyin4":"","namecut1":"\u4e01","namecut2":"\u654f","namecut3":"","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":5394,"contact_id":4584,"mobile":"18810268988","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""},{"id":4690,"name":"\u56fd\u96f7\u519b","email":"","pinyin_shortcut":"glj","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2125,"supplier_id":"","created_by":5087,"created_at":"2023-07-12 10:36:58","updated_at":"2023-07-12 10:36:58","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"guo","pinyin2":"lei","pinyin3":"jun","pinyin4":"","namecut1":"\u56fd","namecut2":"\u96f7","namecut3":"\u519b","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":5498,"contact_id":4690,"mobile":"18610592628","mp_open_id":""}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":5845,"name":"\u8303\u6c5f\u73b2","email":"","pinyin_shortcut":"fjl","sex":"F","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2125,"supplier_id":"","created_by":5087,"created_at":"2024-08-09 12:13:45","updated_at":"2024-08-09 12:13:45","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"fan","pinyin2":"jiang","pinyin3":"ling","pinyin4":"","namecut1":"\u8303","namecut2":"\u6c5f","namecut3":"\u73b2","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":6638,"contact_id":5845,"mobile":"13661306528","mp_open_id":""}],"contactKeyRoles":[{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":5936,"name":"\u674e\u658c","email":"","pinyin_shortcut":"lb","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2125,"supplier_id":"","created_by":5087,"created_at":"2024-11-18 11:26:13","updated_at":"2024-11-18 11:26:13","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"li","pinyin2":"bin","pinyin3":"","pinyin4":"","namecut1":"\u674e","namecut2":"\u658c","namecut3":"","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":6725,"contact_id":5936,"mobile":"13911294460","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""},{"id":5996,"name":"\u5e9e\u5fd7\u806a","email":"","pinyin_shortcut":"pzc","sex":"M","birth_date":"","department":"\u7f51\u4fe1\u90e8","job_position":"","mobile":"","telephone":"","client_id":2125,"supplier_id":"","created_by":5087,"created_at":"2025-02-25 12:27:23","updated_at":"2025-02-25 12:27:23","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"pang","pinyin2":"zhi","pinyin3":"cong","pinyin4":"","namecut1":"\u5e9e","namecut2":"\u5fd7","namecut3":"\u806a","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":6781,"contact_id":5996,"mobile":"13810869295","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""}],"unreadComments":{},"fromContact":"","workingAddresses":[{"id":2653,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382","address1":"","address2":"\u5317\u4eac\u5e02\u4e1c\u57ce\u533a:\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u4e1c\u57ce\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.421783,39.953888)","created_by":5087,"created_at":"2021-12-19 18:01:01","updated_at":"2021-12-24 06:32:49","state_id":110000,"city_id":110100,"region_id":110101,"country_id":1,"lng":"116.421783","lat":"39.953888"}],"schedules":[],"cooperatedProjects":[{"id":3249,"client_id":2125},{"id":3796,"client_id":2125}],"unread":0,"lost_contact_days_display":"22\u5929\u524d","last_arrive_days_display":"","bgcolor":"#EB13C3","overdue_display":"","last_arrive_overdue_display":"\u903e\u671f1357\u5929\u672a\u62dc\u8bbf","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},{"id":85,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u6240 31\u6240","abbr":"","pinyin_shortcut":"bjdljxyjs31s","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":194,"working_address":824,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":5,"client_type":1,"sales_rep":5332,"main_contact":"","created_by":1005,"created_at":"2017-02-20 09:32:47","updated_at":"2025-09-16 16:19:28","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2025-09-16 16:19:28","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":6,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":7,"is_overdue_remind":false,"from_contact":"","tax_no":"","cooperated":true,"is_public":1,"lost_contact_days":"22.7129486492708","last_arrive_days":"","last_contact":"2025-08-24 23:13:00","last_arrive":"","score":"31","clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3","visit_base":10},"clientFrom":{"id":157,"key":157,"name":"\u670b\u53cb\u4ecb\u7ecd"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"},"companyNature":{"id":1,"key":1,"name":"\u56fd\u6709\u4e0a\u5e02"},"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":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":85,"comment":2},"workingAddress":{"id":824,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u6240 31\u6240","address1":"","address2":"\u5317\u4eac\u5e02\u4e30\u53f0\u533a\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u6240","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u4e30\u53f0\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.141535,39.813041)","created_by":5087,"created_at":"2017-11-22 07:33:34","updated_at":"2022-10-08 15:10:47","state_id":110000,"city_id":110100,"region_id":110106,"country_id":1,"lng":"116.141535","lat":"39.813041"},"unCloseCases":[],"workLogCount":{"client_id":85,"count":8},"caseCount":{"client_id":85,"count":7},"salesTimeCount":"","implementTimeCount":{"client_id":85,"sum":"10.0333333333333","times":"7"},"presalesTimeCount":"","engineerTimeCount":{"client_id":85,"hours":"2","times":1},"reimbursementAmountSum":{"client_id":85,"sum":"825.18"},"addresses":[{"id":461,"key":461,"name":"\u5317\u4eac\u5e02\u4e30\u53f0\u533a\u4e91\u5c97\u897f\u8def17\u53f7\u966231\u6240","client_id":85}],"contacts":[{"id":3887,"name":"\u5f20\u5fb7\u90fd","email":"","pinyin_shortcut":"zdd","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":85,"supplier_id":"","created_by":5311,"created_at":"2022-01-24 17:28:09","updated_at":"2022-01-24 17:28:09","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhang","pinyin2":"de","pinyin3":"du","pinyin4":"","namecut1":"\u5f20","namecut2":"\u5fb7","namecut3":"\u90fd","namecut4":"","is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","user_status":"1"},"mobiles":[{"id":4706,"contact_id":3887,"mobile":"17801218538","mp_open_id":"oagch6YSN6zEHe0_HevDp2lNTEEc"}],"contactKeyRoles":[],"contactAttitude":""},{"id":2954,"name":"1","email":"","pinyin_shortcut":"1","sex":"M","birth_date":"","department":"\u6280\u672f\u90e8","job_position":"","mobile":"","telephone":"","client_id":85,"supplier_id":"","created_by":1023,"created_at":"2019-10-21 17:41:55","updated_at":"2020-08-21 13:22:44","user_status":1,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"","pinyin2":"","pinyin3":"","pinyin4":"","namecut1":"1","namecut2":"","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","user_status":"1"},"mobiles":[],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":1143,"name":"1","email":"","pinyin_shortcut":"1","sex":"M","birth_date":"","department":"\u4fe1\u606f\u5316","job_position":"","mobile":"","telephone":"68743557","client_id":85,"supplier_id":"","created_by":1005,"created_at":"2017-09-25 16:15:42","updated_at":"2020-08-21 13:22:12","user_status":1,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"","pinyin2":"","pinyin3":"","pinyin4":"","namecut1":"1","namecut2":"","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":850,"name":"1","email":"","pinyin_shortcut":"1","sex":"M","birth_date":"","department":"\u4fe1\u606f\u5316","job_position":"","mobile":"","telephone":"","client_id":85,"supplier_id":"","created_by":1022,"created_at":"2017-06-16 13:29:34","updated_at":"2020-08-21 13:23:04","user_status":1,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"","pinyin2":"","pinyin3":"","pinyin4":"","namecut1":"1","namecut2":"","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1022,"key":1022,"name":"\u5f90\u7855","sex":"M","user_status":"1"},"mobiles":[],"contactKeyRoles":[],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":181,"name":"1","email":"","pinyin_shortcut":"1","sex":"M","birth_date":"","department":"\u4fe1\u606f\u5316","job_position":"\u5b58\u50a8\u5de5\u7a0b\u5e08","mobile":"","telephone":"","client_id":85,"supplier_id":"","created_by":1005,"created_at":"2017-02-20 10:39:33","updated_at":"2020-08-21 13:23:38","user_status":1,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"","pinyin2":"","pinyin3":"","pinyin4":"","namecut1":"1","namecut2":"","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[],"contactKeyRoles":[{"id":138,"key":138,"name":"Coach"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":3324,"name":"\u82cf\u96e8\u8d3a","email":"","pinyin_shortcut":"syh","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":85,"supplier_id":"","created_by":1023,"created_at":"2020-09-01 17:00:57","updated_at":"2021-07-19 15:51:57","user_status":1,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"su","pinyin2":"yu","pinyin3":"he","pinyin4":"","namecut1":"\u82cf","namecut2":"\u96e8","namecut3":"\u8d3a","namecut4":"","is_mp_bind":"","contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","user_status":"1"},"mobiles":[{"id":4381,"contact_id":3324,"mobile":"13263263764","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""},{"id":2062,"name":"1","email":"","pinyin_shortcut":"1","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":85,"supplier_id":"","created_by":1023,"created_at":"2018-06-19 08:56:30","updated_at":"2020-08-21 13:22:54","user_status":1,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"","pinyin2":"","pinyin3":"","pinyin4":"","namecut1":"1","namecut2":"","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","user_status":"1"},"mobiles":[],"contactKeyRoles":[],"contactAttitude":""},{"id":4402,"name":"\u521d\u5947","email":"","pinyin_shortcut":"cq","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":85,"supplier_id":"","created_by":5015,"created_at":"2022-10-27 10:52:18","updated_at":"2022-12-29 15:05:53","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"chu","pinyin2":"qi","pinyin3":"","pinyin4":"","namecut1":"\u521d","namecut2":"\u5947","namecut3":"","namecut4":"","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":5214,"contact_id":4402,"mobile":"18600586965","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""},{"id":4448,"name":"\u5b54\u7965\u9f99","email":"","pinyin_shortcut":"kxl","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":85,"supplier_id":"","created_by":5087,"created_at":"2022-12-29 23:49:20","updated_at":"2022-12-29 23:49:20","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"kong","pinyin2":"xiang","pinyin3":"long","pinyin4":"","namecut1":"\u5b54","namecut2":"\u7965","namecut3":"\u9f99","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":5261,"contact_id":4448,"mobile":"13581511563","mp_open_id":""}],"contactKeyRoles":[{"id":137,"key":137,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":4449,"name":"\u90ed\u957f\u5761","email":"","pinyin_shortcut":"gzp","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":85,"supplier_id":"","created_by":5087,"created_at":"2022-12-29 23:53:00","updated_at":"2022-12-29 23:53:00","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"guo","pinyin2":"zhang","pinyin3":"po","pinyin4":"","namecut1":"\u90ed","namecut2":"\u957f","namecut3":"\u5761","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":5262,"contact_id":4449,"mobile":"13810554566","mp_open_id":""}],"contactKeyRoles":[{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":5055,"name":"\u9ad8\u6893\u539f","email":"","pinyin_shortcut":"gzy","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":85,"supplier_id":"","created_by":5087,"created_at":"2023-11-27 17:49:26","updated_at":"2023-11-27 17:49:26","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"gao","pinyin2":"zi","pinyin3":"yuan","pinyin4":"","namecut1":"\u9ad8","namecut2":"\u6893","namecut3":"\u539f","namecut4":"","is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":5847,"contact_id":5055,"mobile":"13269623203","mp_open_id":"oagch6a7IwpGntoVMjYEz0hNAbrE"}],"contactKeyRoles":[{"id":138,"key":138,"name":"Coach"}],"contactAttitude":""},{"id":5756,"name":"\u59da\u5b50\u9510","email":"","pinyin_shortcut":"yzr","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":85,"supplier_id":"","created_by":1023,"created_at":"2024-05-11 16:34:37","updated_at":"2024-05-11 16:34:37","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"yao","pinyin2":"zi","pinyin3":"rui","pinyin4":"","namecut1":"\u59da","namecut2":"\u5b50","namecut3":"\u9510","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","user_status":"1"},"mobiles":[{"id":6548,"contact_id":5756,"mobile":"17710468215","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""}],"unreadComments":{},"fromContact":"","workingAddresses":[{"id":824,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u6240 31\u6240","address1":"","address2":"\u5317\u4eac\u5e02\u4e30\u53f0\u533a\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u6240","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u4e30\u53f0\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.141535,39.813041)","created_by":5087,"created_at":"2017-11-22 07:33:34","updated_at":"2022-10-08 15:10:47","state_id":110000,"city_id":110100,"region_id":110106,"country_id":1,"lng":"116.141535","lat":"39.813041"}],"schedules":[],"cooperatedProjects":[{"id":3125,"client_id":85},{"id":44,"client_id":85},{"id":521,"client_id":85},{"id":219,"client_id":85},{"id":189,"client_id":85},{"id":3387,"client_id":85}],"unread":0,"lost_contact_days_display":"22\u5929\u524d","last_arrive_days_display":"","bgcolor":"#EB13C3","overdue_display":"","last_arrive_overdue_display":"\u903e\u671f3121\u5929\u672a\u62dc\u8bbf","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},{"id":2138,"name":"\u56fd\u5bb6\u7a0e\u52a1\u5c40\u897f\u57ce\u5206\u5c40\uff08\u4eb2\u5c5e\uff09","abbr":"","pinyin_shortcut":"gjswjxcfjqs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":1,"client_class":43,"client_industry":1,"client_type":1,"sales_rep":5332,"main_contact":"","created_by":5087,"created_at":"2022-01-11 09:14:51","updated_at":"2025-09-16 16:19:28","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2025-09-16 16:19:28","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":"","tax_no":"","cooperated":false,"is_public":1,"lost_contact_days":"22.7143375381597","last_arrive_days":"","last_contact":"2025-08-24 23:11:00","last_arrive":"","score":"8","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":157,"key":157,"name":"\u670b\u53cb\u4ecb\u7ecd"},"clientIndustry":{"id":1,"key":1,"name":"\u653f\u5e9c"},"companyNature":{"id":1,"key":1,"name":"\u56fd\u6709\u4e0a\u5e02"},"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":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{},"workingAddress":"","unCloseCases":[],"workLogCount":{"client_id":2138,"count":4},"caseCount":"","salesTimeCount":"","implementTimeCount":"","presalesTimeCount":"","engineerTimeCount":"","reimbursementAmountSum":"","addresses":[],"contacts":[{"id":3871,"name":"\u8bb8\u4e45\u83ca","email":"","pinyin_shortcut":"xjj","sex":"F","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":2138,"supplier_id":"","created_by":5087,"created_at":"2022-01-11 09:27:53","updated_at":"2022-01-11 09:27:53","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"xu","pinyin2":"jiu","pinyin3":"ju","pinyin4":"","namecut1":"\u8bb8","namecut2":"\u4e45","namecut3":"\u83ca","namecut4":"","is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":4689,"contact_id":3871,"mobile":"13264397628","mp_open_id":"oagch6aBOXAFWnznXbl6j-nJDII0"}],"contactKeyRoles":[],"contactAttitude":""}],"unreadComments":{},"fromContact":"","workingAddresses":[{"id":4002,"name":"\u56fd\u5bb6\u7a0e\u52a1\u5c40\u897f\u57ce\u5206\u5c40\uff08\u4eb2\u5c5e\uff09","address1":"","address2":"\u5317\u4eac\u5e02\u897f\u57ce\u533a:\u56fd\u5bb6\u7a0e\u52a1\u603b\u5c40\u5317\u4eac\u5e02\u897f\u57ce\u533a\u7a0e\u52a1\u5c40\u7b2c\u4e8c\u7a0e\u52a1\u6240","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u897f\u57ce\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.37066,39.943017)","created_by":5087,"created_at":"2024-11-17 22:59:55","updated_at":"2024-11-17 22:59:55","state_id":110000,"city_id":110100,"region_id":110102,"country_id":1,"lng":"116.37066","lat":"39.943017"}],"schedules":[],"cooperatedProjects":[],"unread":0,"lost_contact_days_display":"22\u5929\u524d","last_arrive_days_display":"","bgcolor":"#1EE6DC","overdue_display":"","last_arrive_overdue_display":"\u903e\u671f1330\u5929\u672a\u62dc\u8bbf","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},{"id":3326,"name":"\u4fdd\u5b9a\u6c90\u69ff\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08304\u8fc7\u5355\uff09","abbr":"","pinyin_shortcut":"bdmjwlkjyxgs304gd","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":20,"client_type":5,"sales_rep":5332,"main_contact":"","created_by":5413,"created_at":"2024-12-02 17:05:04","updated_at":"2025-09-16 16:19:28","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2025-09-16 16:19:28","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":0,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","cooperated":true,"is_public":1,"lost_contact_days":"22.7150319826042","last_arrive_days":"","last_contact":"2025-08-24 23:10:00","last_arrive":"","score":"27","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":{},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\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":5413,"key":5413,"name":"\u8096\u6167\u4e3d","sex":"F","department_id":9,"avatar":{"id":159,"user_id":5413,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ca02da0e-7d82-3904-be85-f050ca37c3c5.jpg"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{},"workingAddress":"","unCloseCases":[],"workLogCount":{"client_id":3326,"count":4},"caseCount":"","salesTimeCount":"","implementTimeCount":"","presalesTimeCount":"","engineerTimeCount":"","reimbursementAmountSum":"","addresses":[],"contacts":[{"id":5955,"name":"\u90ed\u660e\u9633","email":"","pinyin_shortcut":"gmy","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":3326,"supplier_id":"","created_by":5413,"created_at":"2024-12-02 17:05:04","updated_at":"2024-12-02 17:05:04","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"guo","pinyin2":"ming","pinyin3":"yang","pinyin4":"","namecut1":"\u90ed","namecut2":"\u660e","namecut3":"\u9633","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5413,"key":5413,"name":"\u8096\u6167\u4e3d","sex":"F","user_status":"-1"},"mobiles":[{"id":6744,"contact_id":5955,"mobile":"13932288764","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""}],"unreadComments":{},"fromContact":"","workingAddresses":[],"schedules":[],"cooperatedProjects":[{"id":3769,"client_id":3326},{"id":3736,"client_id":3326}],"unread":0,"lost_contact_days_display":"22\u5929\u524d","last_arrive_days_display":"","bgcolor":"#1EE6DC","overdue_display":"","last_arrive_overdue_display":"\u903e\u671f273\u5929\u672a\u62dc\u8bbf","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},{"id":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8","abbr":"","pinyin_shortcut":"bnkjbjyxgsshrnzgdzxtgcdejsyxgssdyyyjsshyxzrgs","description":"","corp_rep":"\u9093\u5929\u656c","website":"","capital":"1800","established_at":"2006-01-06","headcount":"","reg_address":125,"working_address":668,"telephone":"010-80768000","fax":"","scale":"","branch":"","purchase_scale_per_yr":"50","purchase_freq":"","company_nature":6,"client_class":47,"client_industry":5,"client_type":5,"sales_rep":5332,"main_contact":"","created_by":1006,"created_at":"2017-02-14 12:28:19","updated_at":"2025-09-16 16:19:28","main_business":"\u7814\u7a76\u3001\u5f00\u53d1\u751f\u7269\u5236\u836f\u4ea7\u54c1\u53ca\u539f\u6599\u3001\u5316\u5b66\u533b\u836f\u4ea7\u54c1\u53ca\u539f\u6599\u3001\u533b\u7597\u5668\u68b0\u4ea7\u54c1\u53ca\u90e8\u4ef6\u3001\u533b\u5b66\u8bca\u65ad\u4ea7\u54c1\u53ca\u8bd5\u5242\u539f\u6599\uff1b","deleted":false,"capital_currency":"usd","invoice_info":"91110000783203401M","logo":"","en_name":"","pick_at":"2025-09-16 16:19:28","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":6,"client_key_info_count":1,"contact_count":12,"visit_count":1,"cooperate_count":0,"case_pre_sales_count":2,"case_implement_count":4,"is_overdue_remind":false,"from_contact":"","tax_no":"","cooperated":true,"is_public":1,"lost_contact_days":"26.2150319826042","last_arrive_days":"140.094893093715","last_contact":"2025-08-21 11:10:00","last_arrive":"2025-04-29 14:03:00+08","score":"50","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3","visit_base":10},"clientFrom":{"id":156,"key":156,"name":"\u5382\u5546\u4ecb\u7ecd"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"},"companyNature":{"id":6,"key":6,"name":"\u5916\u8d44\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":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":57,"comment":54},"workingAddress":{"id":668,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8","address1":"\u5317\u4eac\u5e02\u660c\u5e73\u533a\u751f\u547d\u56ed\u8def29\u53f7\u521b\u65b0\u5927\u53a6E201","address2":"\u5317\u4eac\u5e02\u660c\u5e73\u533a\u521b\u65b0\u5927\u53a6(\u751f\u547d\u56ed\u897f\u73af\u8def)","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u660c\u5e73\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.278017,40.090529)","created_by":1005,"created_at":"2017-09-08 16:22:36","updated_at":"2022-09-29 10:34:40","state_id":110000,"city_id":110100,"region_id":110114,"country_id":1,"lng":"116.278017","lat":"40.090529"},"unCloseCases":[],"workLogCount":{"client_id":57,"count":10},"caseCount":{"client_id":57,"count":6},"salesTimeCount":{"client_id":57,"hours":"0","times":1},"implementTimeCount":{"client_id":57,"sum":"8.96666666666667","times":"4"},"presalesTimeCount":{"client_id":57,"sum":"5.03333333333333","times":"2"},"engineerTimeCount":{"client_id":57,"hours":"14","times":6},"reimbursementAmountSum":"","addresses":[{"id":140,"key":140,"name":"\u5317\u4eac\u5e02\u660c\u5e73\u533a\u751f\u547d\u56ed\u8def29\u53f7\u521b\u65b0\u5927\u53a6E201","client_id":57},{"id":141,"key":141,"name":"\u5317\u4eac\u5e02\u660c\u5e73\u533a\u751f\u547d\u56ed\u8def29\u53f7\u751f\u547d\u79d1\u5b66\u521b\u65b0\u5927\u53a6","client_id":57}],"contacts":[{"id":3768,"name":"\u9648\u9633","email":"","pinyin_shortcut":"cy","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":57,"supplier_id":"","created_by":1022,"created_at":"2021-09-23 11:24:17","updated_at":"2021-09-23 11:24:17","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"chen","pinyin2":"yang","pinyin3":"","pinyin4":"","namecut1":"\u9648","namecut2":"\u9633","namecut3":"","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1022,"key":1022,"name":"\u5f90\u7855","sex":"M","user_status":"1"},"mobiles":[{"id":4582,"contact_id":3768,"mobile":"13383041203","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""},{"id":767,"name":"\u5c39\u5360\u6c38","email":"zhanyong.yin@bioduro.com","pinyin_shortcut":"yzy","sex":"M","birth_date":"","department":"IT\u90e8","job_position":"\u5317\u4eacIT\u8fd0\u7ef4\u5de5\u7a0b\u5e08","mobile":"","telephone":"","client_id":57,"supplier_id":"","created_by":1015,"created_at":"2017-06-01 17:32:30","updated_at":"2021-07-19 09:57:50","user_status":2,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"yin","pinyin2":"zhan","pinyin3":"yong","pinyin4":"","namecut1":"\u5c39","namecut2":"\u5360","namecut3":"\u6c38","namecut4":"","is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","user_status":"1"},"mobiles":[{"id":4376,"contact_id":767,"mobile":"13521883580","mp_open_id":"oagch6ec17uXe70D4VDHLXkttYFw"}],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":2250,"name":"\u9648\u4f1f","email":"Wei.Chen@bioduro.com","pinyin_shortcut":"cw","sex":"M","birth_date":"","department":"IT\u90e8","job_position":"\u4e0a\u6d77\u6da6\u8bfa\u8fd0\u7ef4\u5de5\u7a0b\u5e08","mobile":"","telephone":"","client_id":57,"supplier_id":"","created_by":5063,"created_at":"2018-09-10 13:49:25","updated_at":"2022-08-31 17:03:52","user_status":2,"description":"\u4e0a\u6d77\u5e02\u6d66\u4e1c\u65b0\u533a\u5bcc\u7279\u5317\u8def233\u53f7\n\u6709\u4e2a\u5973\u513f\uff0c\u5927\u69822015-16\u5e74\u51fa\u751f\u3002\u8001\u5a46\u662f\u5b66\u9738\u3002\u4e0a\u6d77\u4eba","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"chen","pinyin2":"wei","pinyin3":"","pinyin4":"","namecut1":"\u9648","namecut2":"\u4f1f","namecut3":"","namecut4":"","is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","user_status":"-1"},"mobiles":[{"id":4375,"contact_id":2250,"mobile":"18501603924","mp_open_id":"oagch6a2JfkMiO3wruCzj8N1Fjmc"}],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":163,"key":163,"name":"\u5ffd\u8fdc\u5ffd\u8fd1"}},{"id":3492,"name":"\u82ae\u9e4f","email":"","pinyin_shortcut":"rp","sex":"M","birth_date":"","department":"IT\u90e8","job_position":"\u4fdd\u8bfa\u65e0\u9521\u8fd0\u7ef4\u5de5\u7a0b\u5e08","mobile":"","telephone":"","client_id":57,"supplier_id":"","created_by":1016,"created_at":"2021-01-05 17:10:02","updated_at":"2024-06-19 16:49:16","user_status":1,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"rui","pinyin2":"peng","pinyin3":"","pinyin4":"","namecut1":"\u82ae","namecut2":"\u9e4f","namecut3":"","namecut4":"","is_mp_bind":true,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1016,"key":1016,"name":"\u8346\u626c","sex":"M","user_status":"-1"},"mobiles":[{"id":4378,"contact_id":3492,"mobile":"15151952996","mp_open_id":""}],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":3652,"name":"\u5d14\u5a77\u5a77","email":"","pinyin_shortcut":"ctt","sex":"M","birth_date":"","department":"\u91c7\u8d2d\u90e8","job_position":"\u4e0a\u6d77\u6da6\u8bfa\u91c7\u8d2d\u4e13\u5458","mobile":"","telephone":"31751007","client_id":57,"supplier_id":"","created_by":1006,"created_at":"2021-07-05 15:47:11","updated_at":"2021-07-19 09:57:40","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"021","telephone_extension_number":"","mp_open_id":"","pinyin1":"cui","pinyin2":"ting","pinyin3":"ting","pinyin4":"","namecut1":"\u5d14","namecut2":"\u5a77","namecut3":"\u5a77","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":3549,"name":"\u5f20\u4fca\u8d24","email":"","pinyin_shortcut":"zjx","sex":"M","birth_date":"","department":"\u91c7\u8d2d\u90e8","job_position":"\u4fdd\u8bfa\u65e0\u9521\u91c7\u8d2d\u4e13\u5458","mobile":"","telephone":"","client_id":57,"supplier_id":"","created_by":1006,"created_at":"2021-03-22 10:14:30","updated_at":"2021-07-19 09:57:58","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhang","pinyin2":"jun","pinyin3":"xian","pinyin4":"","namecut1":"\u5f20","namecut2":"\u4fca","namecut3":"\u8d24","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":4377,"contact_id":3549,"mobile":"13665193002","mp_open_id":""}],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":731,"name":"armand","email":"armand.amin@bioduro.com","pinyin_shortcut":"armand","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":57,"supplier_id":"","created_by":1006,"created_at":"2017-05-27 16:13:10","updated_at":"2022-09-29 10:33:51","user_status":1,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"armand","pinyin2":"","pinyin3":"","pinyin4":"","namecut1":"a","namecut2":"r","namecut3":"m","namecut4":"a","is_mp_bind":"","contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":979,"name":"\u6768\u4e2d\u82f1","email":"zhongying.yang@bioduro.com","pinyin_shortcut":"yzy","sex":"F","birth_date":"","department":"\u91c7\u8d2d\u90e8","job_position":"\u5317\u4eac\u4fdd\u8bfa\u91c7\u8d2d\u4e13\u5458","mobile":"","telephone":"80768052","client_id":57,"supplier_id":"","created_by":1006,"created_at":"2017-07-20 14:12:03","updated_at":"2021-07-19 09:56:46","user_status":2,"description":"\u5c0f\u6069\u5c0f\u60e0","contact_type":"1","contact_attitude":1,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"yang","pinyin2":"zhong","pinyin3":"ying","pinyin4":"","namecut1":"\u6768","namecut2":"\u4e2d","namecut3":"\u82f1","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":4372,"contact_id":979,"mobile":"15810856507","mp_open_id":""}],"contactKeyRoles":[{"id":138,"key":138,"name":"Coach"},{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":100,"name":"\u5218\u6653\u51cc","email":"jackie.liu@bioduro.com","pinyin_shortcut":"lxl","sex":"M","birth_date":"","department":"IT\u90e8","job_position":"IT\u603b\u76d1","mobile":"","telephone":"","client_id":57,"supplier_id":"","created_by":1006,"created_at":"2017-02-14 12:29:20","updated_at":"2023-07-16 17:56:07","user_status":1,"description":"\u5317\u4eac\u5e02\u660c\u5e73\u533a\u57ce\u5317\u8857\u9053\u4e1c\u5173\u5317\u91cc8\u53f7\u697c\u4e8c\u5355\u5143502\u5ba4 \u5218\u6653\u51cc 18601034651","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"liu","pinyin2":"xiao","pinyin3":"ling","pinyin4":"","namecut1":"\u5218","namecut2":"\u6653","namecut3":"\u51cc","namecut4":"","is_mp_bind":true,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":4379,"contact_id":100,"mobile":"18601034651","mp_open_id":""}],"contactKeyRoles":[{"id":137,"key":137,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":1785,"name":"\u5f20\u6625\u751f(\u767e\u6d4e\u795e\u5dde)","email":"","pinyin_shortcut":"zcsbjsz","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":57,"supplier_id":"","created_by":1006,"created_at":"2018-02-26 09:44:24","updated_at":"2021-07-19 09:53:12","user_status":1,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhang","pinyin2":"chun","pinyin3":"sheng","pinyin4":"bai","namecut1":"\u5f20","namecut2":"\u6625","namecut3":"\u751f","namecut4":"(","is_mp_bind":"","contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":4366,"contact_id":1785,"mobile":"13910038687","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""},{"id":1568,"name":"\u5434\u5065","email":"Beijing.Gen@bioduro.com","pinyin_shortcut":"wj","sex":"M","birth_date":"","department":"IT\u90e8","job_position":"\u91c7\u8d2d\u4e13\u5458\uff08\u5f80\u6765\u53d1\u7968\u6536\u4ef6\u4eba\uff09","mobile":"","telephone":"","client_id":57,"supplier_id":"","created_by":1006,"created_at":"2018-01-22 10:45:32","updated_at":"2021-07-19 09:55:39","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"wu","pinyin2":"jian","pinyin3":"","pinyin4":"","namecut1":"\u5434","namecut2":"\u5065","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":4370,"contact_id":1568,"mobile":"15011583570","mp_open_id":""}],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":1861,"name":"Peter(\u767e\u6d4e\u795e\u821f)","email":"","pinyin_shortcut":"Peterbjsz","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"58958035","client_id":57,"supplier_id":"","created_by":1006,"created_at":"2018-03-28 09:50:07","updated_at":"2021-07-19 09:53:54","user_status":1,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"peter","pinyin2":"bai","pinyin3":"ji","pinyin4":"shen","namecut1":"p","namecut2":"e","namecut3":"t","namecut4":"e","is_mp_bind":"","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":""},{"id":1073,"name":"\u8c22\u767b\u5cf0","email":"Dengfeng.xie@bioduro.com","pinyin_shortcut":"xdf","sex":"M","birth_date":"","department":"\u91c7\u8d2d\u4e0e\u7269\u6d41\u90e8","job_position":"\u91c7\u8d2d\u7ecf\u7406","mobile":"","telephone":"80768287","client_id":57,"supplier_id":"","created_by":1006,"created_at":"2017-08-29 18:12:05","updated_at":"2018-03-28 09:50:35","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"xie","pinyin2":"deng","pinyin3":"feng","pinyin4":"","namecut1":"\u8c22","namecut2":"\u767b","namecut3":"\u5cf0","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":1732,"contact_id":1073,"mobile":"13910134499","mp_open_id":""}],"contactKeyRoles":[{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":4149,"name":"\u81ea\u6676\u6676","email":"jjzi@bioduro-sundia.com","pinyin_shortcut":"zjj","sex":"F","birth_date":"","department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d","mobile":"","telephone":"510986412","client_id":57,"supplier_id":"","created_by":1005,"created_at":"2022-09-29 10:37:35","updated_at":"2022-10-26 09:55:21","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"021","telephone_extension_number":"7223","mp_open_id":"","pinyin1":"zi","pinyin2":"jing","pinyin3":"jing","pinyin4":"","namecut1":"\u81ea","namecut2":"\u6676","namecut3":"\u6676","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[{"id":5207,"contact_id":4149,"mobile":"13611775118","mp_open_id":""}],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":4745,"name":"\u674e\u8273\u79cb","email":"yanqiu.li@bioduro-sundia.com","pinyin_shortcut":"lyq","sex":"F","birth_date":"","department":"","job_position":"\u603b\u76d1","mobile":"","telephone":"","client_id":57,"supplier_id":"","created_by":1005,"created_at":"2023-07-27 08:42:31","updated_at":"2023-08-28 09:46:59","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"li","pinyin2":"yan","pinyin3":"qiu","pinyin4":"","namecut1":"\u674e","namecut2":"\u8273","namecut3":"\u79cb","namecut4":"","is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[{"id":5552,"contact_id":4745,"mobile":"18511589681","mp_open_id":"oagch6SoSes6O_wRt5H8dtyhOxgg"}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":5801,"name":"\u8303\u52e4\u534e","email":"","pinyin_shortcut":"fqh","sex":"M","birth_date":"","department":"\u4e0a\u6d77\u5e93\u623f","job_position":"\u6536\u4ef6\u4eba","mobile":"","telephone":"31064788","client_id":57,"supplier_id":"","created_by":1005,"created_at":"2024-06-13 10:46:25","updated_at":"2024-06-13 10:46:25","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"021","telephone_extension_number":"","mp_open_id":"","pinyin1":"fan","pinyin2":"qin","pinyin3":"hua","pinyin4":"","namecut1":"\u8303","namecut2":"\u52e4","namecut3":"\u534e","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":""},{"id":5798,"name":"\u8303\u660e\u6d0b","email":"","pinyin_shortcut":"fmy","sex":"M","birth_date":"","department":"\u65e0\u9521\u5e93\u623f","job_position":"","mobile":"","telephone":"","client_id":57,"supplier_id":"","created_by":1005,"created_at":"2024-06-11 17:05:21","updated_at":"2024-06-13 10:46:44","user_status":2,"description":"\u65e0\u9521\u5e93\u623f\u8054\u7cfb\u4eba","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"fan","pinyin2":"ming","pinyin3":"yang","pinyin4":"","namecut1":"\u8303","namecut2":"\u660e","namecut3":"\u6d0b","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[{"id":6592,"contact_id":5798,"mobile":"18018331307","mp_open_id":""}],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":""}],"unreadComments":{},"fromContact":"","workingAddresses":[{"id":668,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8","address1":"\u5317\u4eac\u5e02\u660c\u5e73\u533a\u751f\u547d\u56ed\u8def29\u53f7\u521b\u65b0\u5927\u53a6E201","address2":"\u5317\u4eac\u5e02\u660c\u5e73\u533a\u521b\u65b0\u5927\u53a6(\u751f\u547d\u56ed\u897f\u73af\u8def)","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u660c\u5e73\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.278017,40.090529)","created_by":1005,"created_at":"2017-09-08 16:22:36","updated_at":"2022-09-29 10:34:40","state_id":110000,"city_id":110100,"region_id":110114,"country_id":1,"lng":"116.278017","lat":"40.090529"}],"schedules":[],"cooperatedProjects":[{"id":3282,"client_id":57},{"id":2960,"client_id":57},{"id":3002,"client_id":57},{"id":1803,"client_id":57},{"id":3055,"client_id":57},{"id":3156,"client_id":57},{"id":3155,"client_id":57},{"id":3539,"client_id":57},{"id":3562,"client_id":57},{"id":3563,"client_id":57},{"id":3628,"client_id":57},{"id":3672,"client_id":57},{"id":3540,"client_id":57},{"id":3659,"client_id":57},{"id":3696,"client_id":57},{"id":2689,"client_id":57},{"id":3317,"client_id":57},{"id":2680,"client_id":57},{"id":3064,"client_id":57},{"id":3111,"client_id":57},{"id":1940,"client_id":57},{"id":1043,"client_id":57},{"id":3303,"client_id":57},{"id":1958,"client_id":57},{"id":2022,"client_id":57},{"id":2601,"client_id":57},{"id":806,"client_id":57},{"id":1884,"client_id":57},{"id":2771,"client_id":57},{"id":838,"client_id":57},{"id":678,"client_id":57},{"id":1430,"client_id":57},{"id":3145,"client_id":57},{"id":2501,"client_id":57},{"id":1165,"client_id":57},{"id":3588,"client_id":57},{"id":1024,"client_id":57},{"id":3091,"client_id":57},{"id":849,"client_id":57},{"id":1086,"client_id":57},{"id":3629,"client_id":57},{"id":271,"client_id":57},{"id":587,"client_id":57},{"id":705,"client_id":57},{"id":960,"client_id":57},{"id":151,"client_id":57},{"id":1472,"client_id":57},{"id":2690,"client_id":57},{"id":1350,"client_id":57},{"id":1427,"client_id":57},{"id":1438,"client_id":57},{"id":1417,"client_id":57},{"id":3183,"client_id":57},{"id":1774,"client_id":57},{"id":2977,"client_id":57},{"id":2681,"client_id":57},{"id":128,"client_id":57},{"id":1565,"client_id":57},{"id":1564,"client_id":57},{"id":3600,"client_id":57},{"id":3601,"client_id":57},{"id":3602,"client_id":57},{"id":1988,"client_id":57},{"id":2805,"client_id":57},{"id":3365,"client_id":57},{"id":3370,"client_id":57},{"id":3178,"client_id":57},{"id":2899,"client_id":57},{"id":2832,"client_id":57},{"id":3163,"client_id":57},{"id":3567,"client_id":57},{"id":1202,"client_id":57},{"id":3316,"client_id":57},{"id":1625,"client_id":57},{"id":839,"client_id":57},{"id":2538,"client_id":57},{"id":1576,"client_id":57},{"id":2895,"client_id":57},{"id":2652,"client_id":57}],"unread":0,"lost_contact_days_display":"26\u5929\u524d","last_arrive_days_display":"4\u4e2a\u6708\u524d","bgcolor":"#EB13C3","overdue_display":"","last_arrive_overdue_display":"\u903e\u671f131\u5929\u672a\u62dc\u8bbf","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},{"id":101,"name":"\u4e2d\u56fd\u516c\u8def\u5de5\u7a0b\u54a8\u8be2\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u4e2d\u54a8\u6570\u636e\u6709\u9650\u516c\u53f8)","abbr":"","pinyin_shortcut":"zgglgczxjtyxgszzsjyxgs","description":"","corp_rep":"\u4e0a\u5b98\u7526","website":"","capital":"74976.46615","established_at":"1984-04-10","headcount":"709","reg_address":215,"working_address":641,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":1,"client_type":6,"sales_rep":5332,"main_contact":"","created_by":1005,"created_at":"2017-02-23 15:14:41","updated_at":"2025-09-16 16:19:28","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"China Highway Engineering Consulting Group Co., Ltd.","pick_at":"2025-09-16 16:19:28","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":1,"contact_count":3,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":6,"is_overdue_remind":false,"from_contact":"","tax_no":"","cooperated":true,"is_public":1,"lost_contact_days":"26.2219764270486","last_arrive_days":"564.115031982604","last_contact":"2025-08-21 11:00:00","last_arrive":"2024-03-01 13:34:00+08","score":"36","clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3","visit_base":10},"clientFrom":{"id":154,"key":154,"name":"\u5e7f\u544a\u63a8\u5e7f"},"clientIndustry":{"id":1,"key":1,"name":"\u653f\u5e9c"},"companyNature":{"id":1,"key":1,"name":"\u56fd\u6709\u4e0a\u5e02"},"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":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":101,"comment":35},"workingAddress":{"id":641,"name":"\u4e2d\u56fd\u516c\u8def\u5de5\u7a0b\u54a8\u8be2\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u4e2d\u54a8\u6570\u636e\u6709\u9650\u516c\u53f8)","address1":"","address2":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u5317\u4eac\u5e02\u653f\u96c6\u56e2\u5927\u53a6","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u6d77\u6dc0\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.308584,39.940448)","created_by":1005,"created_at":"2017-09-08 09:37:58","updated_at":"2021-12-05 23:12:51","state_id":110000,"city_id":110100,"region_id":110108,"country_id":1,"lng":"116.308584","lat":"39.940448"},"unCloseCases":[],"workLogCount":{"client_id":101,"count":10},"caseCount":{"client_id":101,"count":6},"salesTimeCount":"","implementTimeCount":{"client_id":101,"sum":"10","times":"6"},"presalesTimeCount":"","engineerTimeCount":{"client_id":101,"hours":"1","times":1},"reimbursementAmountSum":"","addresses":[{"id":208,"key":208,"name":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u4e09\u73af\u5317\u8def\u660c\u8fd0\u5bab17\u53f7","client_id":101},{"id":209,"key":209,"name":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u5317\u82d1\u8def170\u53f73\u53f7\u697c4\u5c421\u5355\u5143502\u5ba4","client_id":101}],"contacts":[{"id":3979,"name":"\u6c5f\u6cfd\u6d77","email":"","pinyin_shortcut":"jzh","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":101,"supplier_id":"","created_by":1023,"created_at":"2022-04-20 15:07:23","updated_at":"2022-04-20 15:07:23","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"jiang","pinyin2":"ze","pinyin3":"hai","pinyin4":"","namecut1":"\u6c5f","namecut2":"\u6cfd","namecut3":"\u6d77","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","user_status":"1"},"mobiles":[{"id":4796,"contact_id":3979,"mobile":"18831636016","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""},{"id":1331,"name":"\u738b\u5929\u6cfd","email":"","pinyin_shortcut":"wtz","sex":"M","birth_date":"","department":"\u6280\u672f\u90e8","job_position":"\u6280\u672f","mobile":"","telephone":"57050666","client_id":101,"supplier_id":"","created_by":1005,"created_at":"2017-11-27 11:27:24","updated_at":"2023-12-28 11:06:28","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"oagch6cTwzSNUMjxr81BmuohmDWI","pinyin1":"wang","pinyin2":"tian","pinyin3":"ze","pinyin4":"","namecut1":"\u738b","namecut2":"\u5929","namecut3":"\u6cfd","namecut4":"","is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[{"id":3223,"contact_id":1331,"mobile":"15011393680","mp_open_id":"oagch6cTwzSNUMjxr81BmuohmDWI"}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":837,"name":"\u5218\u633a","email":"550319521@qq.com","pinyin_shortcut":"lt","sex":"M","birth_date":"","department":"\u6280\u672f\u90e8","job_position":"\u6280\u672f\u7ecf\u7406","mobile":"","telephone":"57050666","client_id":101,"supplier_id":"","created_by":1005,"created_at":"2017-06-13 14:31:44","updated_at":"2019-11-04 17:11:15","user_status":1,"description":"liuting@checc.com.cn","contact_type":"1","contact_attitude":2,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"liu","pinyin2":"ting","pinyin3":"","pinyin4":"","namecut1":"\u5218","namecut2":"\u633a","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[{"id":3139,"contact_id":837,"mobile":"13811893506","mp_open_id":""}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":2795,"name":"\u5b59\u5b87","email":"","pinyin_shortcut":"sy","sex":"M","birth_date":"","department":"\u6280\u672f\u90e8","job_position":"\u8fd0\u7ef4\u6280\u672f","mobile":"","telephone":"","client_id":101,"supplier_id":"","created_by":1016,"created_at":"2019-07-16 17:56:46","updated_at":"2019-12-13 14:58:09","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"sun","pinyin2":"yu","pinyin3":"","pinyin4":"","namecut1":"\u5b59","namecut2":"\u5b87","namecut3":"","namecut4":"","is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1016,"key":1016,"name":"\u8346\u626c","sex":"M","user_status":"-1"},"mobiles":[{"id":3224,"contact_id":2795,"mobile":"18310428918","mp_open_id":"oagch6WT2aV8STtt0ORxnP6tDxmg"}],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}}],"unreadComments":{},"fromContact":"","workingAddresses":[{"id":641,"name":"\u4e2d\u56fd\u516c\u8def\u5de5\u7a0b\u54a8\u8be2\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u4e2d\u54a8\u6570\u636e\u6709\u9650\u516c\u53f8)","address1":"","address2":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u5317\u4eac\u5e02\u653f\u96c6\u56e2\u5927\u53a6","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u6d77\u6dc0\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.308584,39.940448)","created_by":1005,"created_at":"2017-09-08 09:37:58","updated_at":"2021-12-05 23:12:51","state_id":110000,"city_id":110100,"region_id":110108,"country_id":1,"lng":"116.308584","lat":"39.940448"}],"schedules":[],"cooperatedProjects":[{"id":56,"client_id":101},{"id":3728,"client_id":101},{"id":332,"client_id":101},{"id":2338,"client_id":101},{"id":3159,"client_id":101},{"id":2784,"client_id":101}],"unread":0,"lost_contact_days_display":"26\u5929\u524d","last_arrive_days_display":"1\u5e74\u524d","bgcolor":"#EB13C3","overdue_display":"","last_arrive_overdue_display":"\u903e\u671f555\u5929\u672a\u62dc\u8bbf","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},{"id":2205,"name":"\u5317\u4eac\u6613\u8f66\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjycxxkjyxgs","description":"","corp_rep":"","website":"https:\/\/www.yiche.com","capital":"20000","established_at":"2005-11-30","headcount":"","reg_address":"","working_address":2746,"telephone":"4000168168","fax":"010-68492726","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":47,"client_industry":19,"client_type":5,"sales_rep":5332,"main_contact":"","created_by":1011,"created_at":"2022-06-30 16:19:03","updated_at":"2025-09-16 16:19:28","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2025-09-16 16:19:28","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":6,"client_key_info_count":0,"contact_count":5,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","cooperated":true,"is_public":1,"lost_contact_days":"26.2289208714931","last_arrive_days":"915.252531982604","last_contact":"2025-08-21 10:50:00","last_arrive":"2023-03-16 10:16:00+08","score":"35","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3","visit_base":10},"clientFrom":{"id":156,"key":156,"name":"\u5382\u5546\u4ecb\u7ecd"},"clientIndustry":{"id":19,"key":19,"name":"OTT"},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\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":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2205,"comment":15},"workingAddress":{"id":2746,"name":"\u5317\u4eac\u6613\u8f66\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8","address1":"","address2":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a:\u817e\u8fbe\u5927\u53a6","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u6d77\u6dc0\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.327443,39.938093)","created_by":1011,"created_at":"2022-06-30 16:19:03","updated_at":"2022-06-30 16:19:03","state_id":110000,"city_id":110100,"region_id":110108,"country_id":1,"lng":"116.327443","lat":"39.938093"},"unCloseCases":[],"workLogCount":{"client_id":2205,"count":5},"caseCount":"","salesTimeCount":"","implementTimeCount":"","presalesTimeCount":"","engineerTimeCount":"","reimbursementAmountSum":"","addresses":[{"id":1423,"key":1423,"name":"\u6ce8\u518c\u5730\u5740\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u76f4\u95e8\u5916\u5927\u8857168\u53f7\u817e\u8fbe\u5927\u53a603\u5c4210\u53f7","client_id":2205}],"contacts":[{"id":4051,"name":"\u738b\u521a","email":"wanggang5@yiche.com","pinyin_shortcut":"wg","sex":"M","birth_date":"","department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d","mobile":"","telephone":"","client_id":2205,"supplier_id":"","created_by":1011,"created_at":"2022-06-30 16:19:03","updated_at":"2025-05-16 15:35:33","user_status":1,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"wang","pinyin2":"gang","pinyin3":"","pinyin4":"","namecut1":"\u738b","namecut2":"\u521a","namecut3":"","namecut4":"","is_mp_bind":false,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":4872,"contact_id":4051,"mobile":"18811342321","mp_open_id":""}],"contactKeyRoles":[{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"}],"contactAttitude":""},{"id":4147,"name":"\u6bdb\u9879\u9f99","email":"maoxl@yiche.com","pinyin_shortcut":"mxl","sex":"M","birth_date":"","department":"\u6280\u672f\u90e8","job_position":"\u5de5\u7a0b\u5e08","mobile":"","telephone":"","client_id":2205,"supplier_id":"","created_by":1011,"created_at":"2022-09-28 14:55:55","updated_at":"2022-09-28 14:56:05","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"mao","pinyin2":"xiang","pinyin3":"long","pinyin4":"","namecut1":"\u6bdb","namecut2":"\u9879","namecut3":"\u9f99","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":4974,"contact_id":4147,"mobile":"18501358067","mp_open_id":""}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":4642,"name":"\u674e\u5ada","email":"liman@yiche.com","pinyin_shortcut":"lm","sex":"F","birth_date":"","department":"\u7cfb\u7edf\u5e73\u53f0\u4e2d\u5fc3","job_position":"\u5546\u52a1","mobile":"","telephone":"","client_id":2205,"supplier_id":"","created_by":1011,"created_at":"2023-06-14 16:46:21","updated_at":"2023-06-14 16:46:21","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"li","pinyin2":"man","pinyin3":"","pinyin4":"","namecut1":"\u674e","namecut2":"\u5ada","namecut3":"","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":5452,"contact_id":4642,"mobile":"18600219599","mp_open_id":""}],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":5809,"name":"\u738b\u8d85","email":"wangchao21@yiche.com","pinyin_shortcut":"wc","sex":"M","birth_date":"","department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d\u7ecf\u7406","mobile":"","telephone":"","client_id":2205,"supplier_id":"","created_by":1011,"created_at":"2024-06-25 16:54:30","updated_at":"2024-06-25 16:54:30","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"wang","pinyin2":"chao","pinyin3":"","pinyin4":"","namecut1":"\u738b","namecut2":"\u8d85","namecut3":"","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":6602,"contact_id":5809,"mobile":"15011353823","mp_open_id":""}],"contactKeyRoles":[{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":6045,"name":"\u5218\u4e16\u6797","email":"","pinyin_shortcut":"lsl","sex":"M","birth_date":"","department":"","job_position":"IT","mobile":"","telephone":"","client_id":2205,"supplier_id":"","created_by":1011,"created_at":"2025-04-23 15:29:19","updated_at":"2025-04-23 15:29:19","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"liu","pinyin2":"shi","pinyin3":"lin","pinyin4":"","namecut1":"\u5218","namecut2":"\u4e16","namecut3":"\u6797","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":6827,"contact_id":6045,"mobile":"13520812760","mp_open_id":""}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":""},{"id":6053,"name":"\u9648\u5fb7\u946b","email":"chendexin@yiche.com","pinyin_shortcut":"cdx","sex":"M","birth_date":"","department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d","mobile":"","telephone":"68616666","client_id":2205,"supplier_id":"","created_by":1011,"created_at":"2025-05-08 15:10:42","updated_at":"2025-05-08 15:10:42","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"","pinyin1":"chen","pinyin2":"de","pinyin3":"xin","pinyin4":"","namecut1":"\u9648","namecut2":"\u5fb7","namecut3":"\u946b","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","user_status":"1"},"mobiles":[{"id":6835,"contact_id":6053,"mobile":"15010238405","mp_open_id":""}],"contactKeyRoles":[{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}}],"unreadComments":{},"fromContact":"","workingAddresses":[{"id":2746,"name":"\u5317\u4eac\u6613\u8f66\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8","address1":"","address2":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a:\u817e\u8fbe\u5927\u53a6","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u6d77\u6dc0\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.327443,39.938093)","created_by":1011,"created_at":"2022-06-30 16:19:03","updated_at":"2022-06-30 16:19:03","state_id":110000,"city_id":110100,"region_id":110108,"country_id":1,"lng":"116.327443","lat":"39.938093"}],"schedules":[],"cooperatedProjects":[{"id":3831,"client_id":2205},{"id":3553,"client_id":2205},{"id":3217,"client_id":2205},{"id":2894,"client_id":2205}],"unread":0,"lost_contact_days_display":"26\u5929\u524d","last_arrive_days_display":"2\u5e74\u524d","bgcolor":"#EB13C3","overdue_display":"","last_arrive_overdue_display":"\u903e\u671f906\u5929\u672a\u62dc\u8bbf","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},{"id":1276,"name":"\u5317\u4eac\u777f\u82af\u9ad8\u901a\u91cf\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4e2d\u79d1\u777f\u82af\u667a\u80fd\u8ba1\u7b97\u4ea7\u4e1a\u7814\u7a76\u9662\u6709\u9650\u516c\u53f8\/\u4e2d\u56fd\u79d1\u5b66\u9662\u8ba1\u7b97\u6280\u672f\u7814\u7a76\u6240)\/\u76d0\u57ce\u4e2d\u79d1\u9ad8\u901a\u91cf\u8ba1\u7b97\u7814\u7a76\u9662\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u777f\u82af\u4f17\u6838\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjrxgtlkjyxgsbjzkrxznjscyyjyyxgszgkxyjsjsyjsyczkgtljsyjyyxgsbjrxzhkjyxgs","description":"","corp_rep":"\u5f20\u9759","website":"www.graph100.cn","capital":"100","established_at":"2016-11-21","headcount":"400","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"5\u4e2a\u5206\u652f","purchase_scale_per_yr":"0","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":1,"client_type":5,"sales_rep":5332,"main_contact":"","created_by":5096,"created_at":"2019-05-09 10:55:53","updated_at":"2025-09-16 16:19:28","main_business":"\u4e91\u8ba1\u7b97\u4ea7\u54c1\uff1b\u667a\u6167\u793e\u533a\uff1b\u52a0\u901f\u5361\uff1b","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2025-09-16 16:19:28","it_budget":"\u4e0d\u56fa\u5b9a","deployment_mode":"\u81ea\u6709\u6570\u636e\u4e2d\u5fc3","it_per_num":"200","public_relations_difficulty":"","it_status":"100+\u670d\u52a1\u5668\uff0c","decision_process":"\u9700\u6c42\u90e8\u95e8-\u9886\u5bfc-\u674e\u817e\uff08\u674e\u817e-\u9886\u5bfc\uff09-\u91c7\u8d2d-\u674e\u817e","coach":"\u674e\u817e","competitor":"","peers":"","supplier":"","main_product":"\u82af\u7247\uff08\u7528\u4e8e\u89c6\u9891\u52a0\u901f\uff09\u3001\u91d1\u77b3\uff08\u667a\u6167\u57ce\u5e02\uff0c\u548c\u6d77\u5eb7\u5a01\u89c6\u6218\u7565\u5408\u4f5c\uff09\u3001\u4e91\u8ba1\u7b97\u7b49\u4ea7\u54c1\u7814\u53d1","client_base_info_count":6,"client_key_info_count":9,"contact_count":7,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":1,"is_overdue_remind":false,"from_contact":"","tax_no":"","cooperated":true,"is_public":1,"lost_contact_days":"26.2428097603819","last_arrive_days":"441.044893093715","last_contact":"2025-08-21 10:30:00","last_arrive":"2024-07-02 15:15:00+08","score":"30","clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3","visit_base":10},"clientFrom":{"id":157,"key":157,"name":"\u670b\u53cb\u4ecb\u7ecd"},"clientIndustry":{"id":1,"key":1,"name":"\u653f\u5e9c"},"companyNature":{"id":1,"key":1,"name":"\u56fd\u6709\u4e0a\u5e02"},"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":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":1276,"comment":28},"workingAddress":"","unCloseCases":[],"workLogCount":{"client_id":1276,"count":7},"caseCount":{"client_id":1276,"count":1},"salesTimeCount":"","implementTimeCount":{"client_id":1276,"sum":"1.5","times":"1"},"presalesTimeCount":"","engineerTimeCount":"","reimbursementAmountSum":"","addresses":[{"id":912,"key":912,"name":"\u6d77\u6dc0\u5317\u6e05\u8def156\u53f7\u4e2d\u5173\u6751\u73af\u4fdd\u79d1\u6280\u56ed\u6587\u677e\u8def1\u53f7\u9662","client_id":1276}],"contacts":[{"id":3829,"name":"\u674e\u5174\u71d5","email":"","pinyin_shortcut":"lxy","sex":"F","birth_date":"","department":"\u91c7\u8d2d","job_position":"","mobile":"","telephone":"","client_id":1276,"supplier_id":"","created_by":5299,"created_at":"2021-11-24 15:56:50","updated_at":"2021-11-24 15:56:50","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"li","pinyin2":"xing","pinyin3":"yan","pinyin4":"","namecut1":"\u674e","namecut2":"\u5174","namecut3":"\u71d5","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5299,"key":5299,"name":"\u4f55\u806a","sex":"M","user_status":"-1"},"mobiles":[{"id":4646,"contact_id":3829,"mobile":"15001043509","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""},{"id":3773,"name":"\u4f55\u806a","email":"","pinyin_shortcut":"hc","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":1276,"supplier_id":"","created_by":5299,"created_at":"2021-09-27 13:26:57","updated_at":"2022-06-19 23:05:30","user_status":1,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"he","pinyin2":"cong","pinyin3":"","pinyin4":"","namecut1":"\u4f55","namecut2":"\u806a","namecut3":"","namecut4":"","is_mp_bind":true,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":5299,"key":5299,"name":"\u4f55\u806a","sex":"M","user_status":"-1"},"mobiles":[{"id":4586,"contact_id":3773,"mobile":"15604998877","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""},{"id":3017,"name":"\u67f3\u68c0","email":"","pinyin_shortcut":"lj","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":1276,"supplier_id":"","created_by":5088,"created_at":"2019-12-29 22:44:13","updated_at":"2020-03-13 11:10:30","user_status":2,"description":"\u8d1f\u8d23\u4e2d\u5173\u6751\u65b0\u529e\u516c\u5ba4\u5f31\u7535\uff0c\u673a\u623f\uff0c\u95e8\u7981\u76d1\u63a7","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"liu","pinyin2":"jian","pinyin3":"","pinyin4":"","namecut1":"\u67f3","namecut2":"\u68c0","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5088,"key":5088,"name":"\u7f57\u7199","sex":"F","user_status":"-1"},"mobiles":[{"id":3355,"contact_id":3017,"mobile":"13718057202","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""},{"id":3624,"name":"\u5218\u4f73\u6021","email":"","pinyin_shortcut":"ljy","sex":"F","birth_date":"","department":"","job_position":"\u9500\u552e","mobile":"","telephone":"","client_id":1276,"supplier_id":"","created_by":5096,"created_at":"2021-06-09 20:13:51","updated_at":"2022-05-15 19:19:14","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"liu","pinyin2":"jia","pinyin3":"yi","pinyin4":"","namecut1":"\u5218","namecut2":"\u4f73","namecut3":"\u6021","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5096,"key":5096,"name":"\u674e\u6c5f\u661f","sex":"F","user_status":"-1"},"mobiles":[],"contactKeyRoles":[],"contactAttitude":""},{"id":2591,"name":"\u80dc\u6653\u6d77","email":"","pinyin_shortcut":"sxh","sex":"M","birth_date":"","department":"\u91c7\u8d2d\u90e8","job_position":"","mobile":"","telephone":"62600377","client_id":1276,"supplier_id":"","created_by":5088,"created_at":"2019-05-09 10:56:53","updated_at":"2019-12-22 02:37:26","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"oagch6UsjHtRCk4HALtdTU1_dGmA","pinyin1":"sheng","pinyin2":"xiao","pinyin3":"hai","pinyin4":"","namecut1":"\u80dc","namecut2":"\u6653","namecut3":"\u6d77","namecut4":"","is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5088,"key":5088,"name":"\u7f57\u7199","sex":"F","user_status":"-1"},"mobiles":[{"id":3243,"contact_id":2591,"mobile":"13681339807","mp_open_id":"oagch6UsjHtRCk4HALtdTU1_dGmA"}],"contactKeyRoles":[{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"}],"contactAttitude":""},{"id":3023,"name":"\u60e0\u6d69\u6d69","email":"","pinyin_shortcut":"hhh","sex":"M","birth_date":"","department":"\u76d0\u57ce\u7f51\u7edc\u8fd0\u7ef4\u5de5\u7a0b\u5e08","job_position":"","mobile":"","telephone":"","client_id":1276,"supplier_id":"","created_by":5082,"created_at":"2020-01-10 13:51:24","updated_at":"2020-01-10 13:51:54","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"hui","pinyin2":"hao","pinyin3":"hao","pinyin4":"","namecut1":"\u60e0","namecut2":"\u6d69","namecut3":"\u6d69","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5082,"key":5082,"name":"\u674e\u5fd7\u535a","sex":"M","user_status":"-1"},"mobiles":[{"id":3270,"contact_id":3023,"mobile":"18291965411","mp_open_id":""}],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":""},{"id":2930,"name":"\u59ec\u5f3a","email":"","pinyin_shortcut":"jq","sex":"M","birth_date":"","department":"\u4fe1\u606f\u90e8","job_position":"\u8fd0\u7ef4","mobile":"","telephone":"","client_id":1276,"supplier_id":"","created_by":5088,"created_at":"2019-10-11 20:21:48","updated_at":"2020-01-17 10:27:53","user_status":2,"description":"\u76d0\u57ce\u6570\u636e\u4e2d\u5fc3\u8d1f\u8d23\u4eba\u4e4b\u4e00","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"oagch6Qrpwwki6Lj6qNmKGcw-fuE","pinyin1":"ji","pinyin2":"qiang","pinyin3":"","pinyin4":"","namecut1":"\u59ec","namecut2":"\u5f3a","namecut3":"","namecut4":"","is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5088,"key":5088,"name":"\u7f57\u7199","sex":"F","user_status":"-1"},"mobiles":[{"id":3276,"contact_id":2930,"mobile":"13466590316","mp_open_id":"oagch6Qrpwwki6Lj6qNmKGcw-fuE"}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":2979,"name":"\u674e\u817e","email":"","pinyin_shortcut":"lt","sex":"M","birth_date":"","department":"\u6280\u672f\u90e8","job_position":"","mobile":"","telephone":"62600374","client_id":1276,"supplier_id":"","created_by":5088,"created_at":"2019-11-08 12:47:43","updated_at":"2023-04-24 16:41:19","user_status":2,"description":"\u5317\u4eac\u9879\u76ee\u6280\u672f\u8d1f\u8d23\u4eba","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"oagch6YX3xipjOhoeVbnBqukse0A","pinyin1":"li","pinyin2":"teng","pinyin3":"","pinyin4":"","namecut1":"\u674e","namecut2":"\u817e","namecut3":"","namecut4":"","is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5088,"key":5088,"name":"\u7f57\u7199","sex":"F","user_status":"-1"},"mobiles":[{"id":4331,"contact_id":2979,"mobile":"13466787831","mp_open_id":"oagch6YX3xipjOhoeVbnBqukse0A"}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"},{"id":138,"key":138,"name":"Coach"}],"contactAttitude":""}],"unreadComments":{},"fromContact":"","workingAddresses":[{"id":4119,"name":"\u5317\u4eac\u777f\u82af\u9ad8\u901a\u91cf\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4e2d\u79d1\u777f\u82af\u667a\u80fd\u8ba1\u7b97\u4ea7\u4e1a\u7814\u7a76\u9662\u6709\u9650\u516c\u53f8\/\u4e2d\u56fd\u79d1\u5b66\u9662\u8ba1\u7b97\u6280\u672f\u7814\u7a76\u6240)\/\u76d0\u57ce\u4e2d\u79d1\u9ad8\u901a\u91cf\u8ba1\u7b97\u7814\u7a76\u9662\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u777f\u82af\u4f17\u6838\u79d1\u6280\u6709\u9650\u516c\u53f8","address1":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a:\u4e2d\u5173\u6751\u4e1c\u5347\u79d1\u6280\u56ed\u4e09\u671f\u4e1c\u7554\u79d1\u521b\u4e2d\u5fc3","address2":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u4e1c\u5347\u79d1\u6280\u56ed\u4e09\u671f","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u6d77\u6dc0\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.366037,40.003281)","created_by":1005,"created_at":"2025-03-30 20:53:46","updated_at":"2025-03-30 20:53:46","state_id":110000,"city_id":110100,"region_id":110108,"country_id":1,"lng":"116.366037","lat":"40.003281"}],"schedules":[],"cooperatedProjects":[{"id":1604,"client_id":1276},{"id":1603,"client_id":1276},{"id":2816,"client_id":1276},{"id":2375,"client_id":1276},{"id":3122,"client_id":1276},{"id":1622,"client_id":1276},{"id":2659,"client_id":1276},{"id":1609,"client_id":1276},{"id":1629,"client_id":1276},{"id":1763,"client_id":1276},{"id":3346,"client_id":1276},{"id":1495,"client_id":1276},{"id":1602,"client_id":1276}],"unread":0,"lost_contact_days_display":"26\u5929\u524d","last_arrive_days_display":"1\u5e74\u524d","bgcolor":"#EB13C3","overdue_display":"","last_arrive_overdue_display":"\u903e\u671f432\u5929\u672a\u62dc\u8bbf","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},{"id":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","abbr":"","pinyin_shortcut":"zgzxjxyxgsgjzxzbjpzddsdyxgs","description":"","corp_rep":"\u8096\u5e73","website":"www.chmc.cc","capital":"100000","established_at":"1981-01-30","headcount":"244","reg_address":38,"working_address":647,"telephone":"010-68296106","fax":"","scale":"","branch":"\u56fd\u5de5\u57fa\u5730\uff0c\u91d1\u8fb9","purchase_scale_per_yr":"","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":5,"client_type":6,"sales_rep":5332,"main_contact":"","created_by":1005,"created_at":"2017-02-09 11:54:30","updated_at":"2025-09-16 16:19:28","main_business":"\u627f\u5305\u56fd\u5916\u5de5\u7a0b\u9879\u76ee","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"China National Heavy Machinery Corporation","pick_at":"2025-09-16 16:19:28","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":7,"client_key_info_count":2,"contact_count":7,"visit_count":1,"cooperate_count":3,"case_pre_sales_count":2,"case_implement_count":20,"is_overdue_remind":false,"from_contact":"","tax_no":"","cooperated":true,"is_public":1,"lost_contact_days":"26.2497542048264","last_arrive_days":"167.20808753816","last_contact":"2025-08-21 10:20:00","last_arrive":"2025-04-02 11:20:00+08","score":"71","clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3","visit_base":10},"clientFrom":{"id":166,"key":166,"name":"cold call"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"},"companyNature":{"id":1,"key":1,"name":"\u56fd\u6709\u4e0a\u5e02"},"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":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":20,"comment":31},"workingAddress":{"id":647,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","address1":"","address2":"\u5317\u4eac\u5e02\u4e30\u53f0\u533a\u65b0\u6751\u8857\u9053\u6c49\u5a01\u56fd\u9645\u5e7f\u573a2\u533a","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u4e30\u53f0\u533a","zip":"100070","country":"\u4e2d\u56fd","geolocation":"(116.295237,39.826447)","created_by":1005,"created_at":"2017-09-08 11:15:05","updated_at":"2021-12-05 23:16:09","state_id":110000,"city_id":110100,"region_id":110106,"country_id":1,"lng":"116.295237","lat":"39.826447"},"unCloseCases":[],"workLogCount":{"client_id":20,"count":9},"caseCount":{"client_id":20,"count":22},"salesTimeCount":{"client_id":20,"hours":"0","times":1},"implementTimeCount":{"client_id":20,"sum":"54.9166666666667","times":"20"},"presalesTimeCount":{"client_id":20,"sum":"3.05","times":"2"},"engineerTimeCount":{"client_id":20,"hours":"22.5","times":11},"reimbursementAmountSum":{"client_id":20,"sum":"672.37"},"addresses":[{"id":301,"key":301,"name":"\u5317\u4eac\u4e30\u53f0\u533a\u5357\u56db\u73af\u897f\u8def186\u53f7\u6c49\u5a01\u56fd\u9645\u4e8c\u533a8\u53f7\u697c","client_id":20}],"contacts":[{"id":514,"name":"\u9ec4\u745e\u5f3a","email":"huangruiqiang@chmc.cc","pinyin_shortcut":"hrq","sex":"M","birth_date":"","department":"\u6280\u672f\u90e8","job_position":"\u526f\u90e8\u957f","mobile":"","telephone":"68296001","client_id":20,"supplier_id":"","created_by":1005,"created_at":"2017-04-25 17:32:16","updated_at":"2024-02-22 12:07:21","user_status":2,"description":"\u9ec4\u745e\u5f3a 610103197908022411\n\u6709\u4e2a\u5973\u513f\uff0c12\u5e743\u6708\u51fa\u751f\u3002\n\u5317\u4eac\u5e02\u4e1c\u57ce\u533a\u8c46\u74e3\u80e1\u540c2\u53f7\u697c9\u5355\u5143704\n66137567@qq.com","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"oagch6R88oQvH42iJfrM61b-APkk","pinyin1":"huang","pinyin2":"rui","pinyin3":"qiang","pinyin4":"","namecut1":"\u9ec4","namecut2":"\u745e","namecut3":"\u5f3a","namecut4":"","is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[{"id":3222,"contact_id":514,"mobile":"15810707715","mp_open_id":"oagch6R88oQvH42iJfrM61b-APkk"}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":515,"name":"\u9646\u6587\u4fca","email":"","pinyin_shortcut":"lwj","sex":"M","birth_date":"","department":"\u7ba1\u7406\u5c42","job_position":"\u8463\u4e8b\u957f","mobile":"","telephone":"68296106","client_id":20,"supplier_id":"","created_by":1005,"created_at":"2017-04-25 17:38:14","updated_at":"2021-07-28 09:45:11","user_status":1,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"lu","pinyin2":"wen","pinyin3":"jun","pinyin4":"","namecut1":"\u9646","namecut2":"\u6587","namecut3":"\u4fca","namecut4":"","is_mp_bind":"","contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[],"contactKeyRoles":[{"id":133,"key":133,"name":"\u603b\u51b3\u7b56\u4eba"},{"id":134,"key":134,"name":"\u8d22\u52a1\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":1334,"name":"\u751f\u4f73\u7acb","email":"","pinyin_shortcut":"sjl","sex":"F","birth_date":"","department":"\u6280\u672f\u90e8","job_position":"\u6587\u5458","mobile":"","telephone":"","client_id":20,"supplier_id":"","created_by":1005,"created_at":"2017-11-27 18:16:38","updated_at":"2018-07-30 08:52:15","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"sheng","pinyin2":"jia","pinyin3":"li","pinyin4":"","namecut1":"\u751f","namecut2":"\u4f73","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[{"id":982,"contact_id":1334,"mobile":"","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":1335,"name":"\u5218\u7545","email":"","pinyin_shortcut":"lc","sex":"F","birth_date":"","department":"\u6280\u672f\u90e8","job_position":"\u6587\u5458","mobile":"","telephone":"","client_id":20,"supplier_id":"","created_by":1005,"created_at":"2017-11-27 18:17:14","updated_at":"2018-07-30 08:52:05","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"liu","pinyin2":"chang","pinyin3":"","pinyin4":"","namecut1":"\u5218","namecut2":"\u7545","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[{"id":1049,"contact_id":1335,"mobile":"","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":1087,"name":"\u9c81\u6842\u4e3d","email":"","pinyin_shortcut":"lgl","sex":"F","birth_date":"","department":"\u4fe1\u606f\u5316","job_position":"\u8f6f\u4ef6","mobile":"","telephone":"","client_id":20,"supplier_id":"","created_by":1005,"created_at":"2017-09-04 20:08:12","updated_at":"2018-02-09 11:31:50","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"lu","pinyin2":"gui","pinyin3":"li","pinyin4":"","namecut1":"\u9c81","namecut2":"\u6842","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[{"id":1291,"contact_id":1087,"mobile":"\u202d134 6639 9347\u202c","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""},{"id":25,"name":"\u674e\u521a","email":"ligang@chmc2003.com","pinyin_shortcut":"lg","sex":"M","birth_date":"","department":"\u4fe1\u606f\u5316","job_position":"\u90e8\u957f","mobile":"","telephone":"68211861","client_id":20,"supplier_id":"","created_by":1005,"created_at":"2017-02-09 11:56:30","updated_at":"2021-07-28 09:43:46","user_status":1,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"li","pinyin2":"gang","pinyin3":"","pinyin4":"","namecut1":"\u674e","namecut2":"\u521a","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[{"id":4403,"contact_id":25,"mobile":"13681050139","mp_open_id":""}],"contactKeyRoles":[{"id":133,"key":133,"name":"\u603b\u51b3\u7b56\u4eba"},{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"},{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"},{"id":137,"key":137,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":1847,"name":"\u8d75\u5b8f\u4f1f","email":"","pinyin_shortcut":"zhw","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":20,"supplier_id":"","created_by":1005,"created_at":"2018-03-22 15:19:47","updated_at":"2018-03-22 15:19:47","user_status":2,"description":"\u8d75\u5b8f\u4f1f 510602197505106810\r\n\u5fb7\u9633\u4e8c\u91cd\u5458\u5de5","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"zhao","pinyin2":"hong","pinyin3":"wei","pinyin4":"","namecut1":"\u8d75","namecut2":"\u5b8f","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[{"id":1719,"contact_id":1847,"mobile":"13778200085","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":4106,"name":"\u5218\u5531","email":"","pinyin_shortcut":"lc","sex":"F","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":20,"supplier_id":"","created_by":1023,"created_at":"2022-08-24 14:02:28","updated_at":"2022-08-24 14:02:28","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"liu","pinyin2":"chang","pinyin3":"","pinyin4":"","namecut1":"\u5218","namecut2":"\u5531","namecut3":"","namecut4":"","is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","user_status":"1"},"mobiles":[{"id":4928,"contact_id":4106,"mobile":"13146590795","mp_open_id":"oagch6Q7tNfnGMainx2TmIsAMH2Y"}],"contactKeyRoles":[],"contactAttitude":""},{"id":5200,"name":"\u5180\u6653\u9e4f","email":"","pinyin_shortcut":"jxp","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":20,"supplier_id":"","created_by":1005,"created_at":"2024-01-31 16:01:14","updated_at":"2024-01-31 16:01:14","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"ji","pinyin2":"xiao","pinyin3":"peng","pinyin4":"","namecut1":"\u5180","namecut2":"\u6653","namecut3":"\u9e4f","namecut4":"","is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[{"id":5988,"contact_id":5200,"mobile":"13552776255","mp_open_id":"oagch6XX7REPbRRWbbUG29EuEzH8"}],"contactKeyRoles":[],"contactAttitude":""}],"unreadComments":{},"fromContact":"","workingAddresses":[{"id":647,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","address1":"","address2":"\u5317\u4eac\u5e02\u4e30\u53f0\u533a\u65b0\u6751\u8857\u9053\u6c49\u5a01\u56fd\u9645\u5e7f\u573a2\u533a","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u4e30\u53f0\u533a","zip":"100070","country":"\u4e2d\u56fd","geolocation":"(116.295237,39.826447)","created_by":1005,"created_at":"2017-09-08 11:15:05","updated_at":"2021-12-05 23:16:09","state_id":110000,"city_id":110100,"region_id":110106,"country_id":1,"lng":"116.295237","lat":"39.826447"}],"schedules":[],"cooperatedProjects":[{"id":3142,"client_id":20},{"id":3138,"client_id":20},{"id":3564,"client_id":20},{"id":2961,"client_id":20},{"id":3586,"client_id":20},{"id":3664,"client_id":20},{"id":1783,"client_id":20},{"id":3285,"client_id":20},{"id":3205,"client_id":20},{"id":1784,"client_id":20},{"id":2332,"client_id":20},{"id":2651,"client_id":20},{"id":2656,"client_id":20},{"id":2589,"client_id":20},{"id":2962,"client_id":20},{"id":2765,"client_id":20},{"id":1749,"client_id":20},{"id":314,"client_id":20},{"id":713,"client_id":20},{"id":3097,"client_id":20},{"id":639,"client_id":20},{"id":962,"client_id":20},{"id":1009,"client_id":20},{"id":145,"client_id":20},{"id":3495,"client_id":20},{"id":1525,"client_id":20},{"id":3605,"client_id":20},{"id":3792,"client_id":20},{"id":3721,"client_id":20},{"id":5,"client_id":20},{"id":3823,"client_id":20},{"id":3462,"client_id":20},{"id":3423,"client_id":20},{"id":3416,"client_id":20},{"id":1249,"client_id":20},{"id":2028,"client_id":20}],"unread":0,"lost_contact_days_display":"26\u5929\u524d","last_arrive_days_display":"5\u4e2a\u6708\u524d","bgcolor":"#EB13C3","overdue_display":"","last_arrive_overdue_display":"\u903e\u671f158\u5929\u672a\u62dc\u8bbf","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}],"thisUser":{"id":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"}},"extra":0,"is_lock":false,"unlock_count":9,"can_lock":true,"can_create":true,"can_import":true,"can_export":true,"can_transfer":true,"can_delete":true,"can_give_up":true,"can_create_work_log":true,"can_create_schedule":true,"pagenation":{"totalcount":9,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-16 16:19:38') RETURNING "id" /var/www/beta/modules/vue/controllers/CommonController.php:665 /var/www/beta/modules/vue/controllers/CommonController.php:363 /var/www/beta/modules/vue/controllers/ClientController.php:530 [+] Explain

[+] Explain all