ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
686b904884f1b: POST https://beta.jinchangxiao.com/v2/client-map/list at 2025-07-07 05:15:52 pm by 223.160.230.231

Log Messages

总计38条数据
TimeLevelCategoryMessage
 
17:15:52.543traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
17:15:52.544traceyii\base\Module::getModuleLoading module: debug
17:15:52.544traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
17:15:52.544traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
17:15:52.544traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
17:15:52.544traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:15:52.545traceyii\base\Module::getModuleLoading module: gii
17:15:52.545traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
17:15:52.545traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
17:15:52.545traceyii\web\Application::handleRequestRoute requested: 'v2/client-map/list'
17:15:52.545traceyii\base\Module::getModuleLoading module: v2
17:15:52.546infoyii\web\Session::openSession started
17:15:52.547infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:15:52.549infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd'
17:15:52.553traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:15:52.553traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:15:52.553traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:15:52.554traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:15:52.554infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:15:52.556traceyii\base\Controller::runActionRoute to run: v2/client-map/list
17:15:52.556traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:15:52.557traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:15:52.557traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\ClientMapController::actionList()
17:15:52.559traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:15:52.559traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:15:52.559traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:15:52.560traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:15:52.561infoyii\db\Command::querySELECT "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, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("user_status"='1') 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
17:15:52.563infoyii\db\Command::querySELECT c.id AS client_id, c.name, c.sales_rep, c.client_class, c.client_type, CASE WHEN p.id IS NULL THEN false ELSE true END AS cooperated, CASE WHEN ad.id IS NULL OR ad.geolocation IS NULL THEN 0 ELSE ad.geolocation[0] END AS lng, CASE WHEN ad.id IS NULL OR ad.geolocation IS NULL THEN 0 ELSE ad.geolocation[1] END AS lat FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.client_id = c.id AND p.project_status = 3 LEFT JOIN "a57be577deb434"."tbl_client_address_rels" "car" ON c.id = car.client_id LEFT JOIN "a57be577deb434"."tbl_addresses" "ad" ON ad.id = car.address_id WHERE ("ad"."geolocation" IS NOT NULL) AND (ad.geolocation != '(0,0)'::point) AND ("deleted"=FALSE) AND ("sales_rep"=5329)
17:15:52.618infoyii\db\Command::querySELECT "id", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5329
17:15:52.623infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5329)
17:15:52.623infoyii\db\Command::querySELECT "id", "name" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (43, 47)
17:15:52.624infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id" IN (6, 1, 5)
17:15:52.625infoyii\db\Command::querySELECT "id", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5329
17:15:52.625infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5329)
17:15:52.626traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:15:52.626traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:15:52.627infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 6, 166, 'v2/client-map/list', '{"posttime":"1751879752","access_token":"Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd","device_type":"6","version_code":"166","token":"c7e3cd2717b669ab0b69b1b207c7f6fe"}', '{"code":200,"data":{"list":[{"name":"\u4e2d\u56fd\u6c11\u822a\u673a\u573a\u5efa\u8bbe\u96c6\u56e2","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":true,"lng":"116.421957","lat":"39.989293","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":2148},{"name":"\u56fd\u836f\u96c6\u56e2\u836f\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":true,"lng":"116.389090418816","lat":"39.8704439700158","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":60},{"name":"\u90ae\u653f\u79d1\u5b66\u7814\u7a76\u89c4\u5212\u9662","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":true,"lng":"116.337308","lat":"40.059094","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":579},{"name":"\u4e2d\u56fd\u7535\u5b50\u5b66\u4f1a","sales_rep":5329,"client_class":43,"client_type":1,"cooperated":true,"lng":"116.305963","lat":"39.912331","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"id":1128},{"name":"\u4e2d\u8f66\u5de5\u4e1a\u7814\u7a76\u9662\u6709\u9650\u516c\u53f8\/\u4e2d\u8f66\u5de5\u4e1a\u7814\u7a76\u9662(\u9752\u5c9b)\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":true,"lng":"116.302301","lat":"39.827106","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":521},{"name":"\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u6559\u80b2\u59d4\u5458\u4f1a","sales_rep":5329,"client_class":43,"client_type":1,"cooperated":true,"lng":"116.198571","lat":"39.911416","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"id":2708},{"name":"\u4e2d\u8f66\u5de5\u4e1a\u7814\u7a76\u9662\u6709\u9650\u516c\u53f8\/\u4e2d\u8f66\u5de5\u4e1a\u7814\u7a76\u9662(\u9752\u5c9b)\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":true,"lng":"116.302301","lat":"39.827106","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":521},{"name":"\u4e2d\u4ea4\u4e00\u516c\u5c40\u7b2c\u4e00\u5de5\u7a0b\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":true,"lng":"116.139272","lat":"40.143984","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":576},{"name":"\u4e2d\u5171\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u59d4\u653f\u6cd5\u59d4\u5458\u4f1a","sales_rep":5329,"client_class":43,"client_type":1,"cooperated":true,"lng":"116.223015","lat":"39.906304","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"id":2715},{"name":"\u5317\u6c7d\u84dd\u8c37\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":true,"lng":"116.506555","lat":"39.792206","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":1640},{"name":"\u4e2d\u4ea4\u4e00\u516c\u5c40\u7b2c\u4e00\u5de5\u7a0b\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":true,"lng":"116.139272","lat":"40.143984","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":576},{"name":"\u4e2d\u5171\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u59d4\u653f\u6cd5\u59d4\u5458\u4f1a","sales_rep":5329,"client_class":43,"client_type":1,"cooperated":true,"lng":"116.223015","lat":"39.906304","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"id":2715},{"name":"\u4e2d\u5171\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u59d4\u653f\u6cd5\u59d4\u5458\u4f1a","sales_rep":5329,"client_class":43,"client_type":1,"cooperated":true,"lng":"116.223015","lat":"39.906304","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"id":2715},{"name":"\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u6559\u80b2\u59d4\u5458\u4f1a","sales_rep":5329,"client_class":43,"client_type":1,"cooperated":true,"lng":"116.198571","lat":"39.911416","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"id":2708},{"name":"\u4e2d\u56fd\u7535\u5b50\u5b66\u4f1a","sales_rep":5329,"client_class":43,"client_type":1,"cooperated":true,"lng":"116.305963","lat":"39.912331","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"id":1128},{"name":"\u56fd\u836f\u96c6\u56e2\u836f\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":true,"lng":"116.389090418816","lat":"39.8704439700158","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":60},{"name":"\u5317\u4eac\u56fd\u9645\u4e91\u8f6c\u64ad\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":5,"cooperated":true,"lng":"116.153","lat":"39.911045","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"id":2218},{"name":"\u90ae\u653f\u79d1\u5b66\u7814\u7a76\u89c4\u5212\u9662","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":true,"lng":"116.337308","lat":"40.059094","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":579},{"name":"\u4e2d\u4ea4\u4e00\u516c\u5c40\u7b2c\u4e00\u5de5\u7a0b\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":true,"lng":"116.139272","lat":"40.143984","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":576},{"name":"\u4e2d\u4ea4\u4e00\u516c\u5c40\u7b2c\u4e00\u5de5\u7a0b\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":true,"lng":"116.139272","lat":"40.143984","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":576},{"name":"\u4e2d\u4ea4\u4e00\u516c\u5c40\u7b2c\u4e00\u5de5\u7a0b\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":true,"lng":"116.139272","lat":"40.143984","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":576},{"name":"\u4e2d\u56fd\u7535\u5b50\u5b66\u4f1a","sales_rep":5329,"client_class":43,"client_type":1,"cooperated":true,"lng":"116.305963","lat":"39.912331","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"id":1128},{"name":"\u4e2d\u8f66\u5de5\u4e1a\u7814\u7a76\u9662\u6709\u9650\u516c\u53f8\/\u4e2d\u8f66\u5de5\u4e1a\u7814\u7a76\u9662(\u9752\u5c9b)\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":true,"lng":"116.302301","lat":"39.827106","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":521},{"name":"\u4e2d\u8f66\u5de5\u4e1a\u7814\u7a76\u9662\u6709\u9650\u516c\u53f8\/\u4e2d\u8f66\u5de5\u4e1a\u7814\u7a76\u9662(\u9752\u5c9b)\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":true,"lng":"116.302301","lat":"39.827106","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":521},{"name":"\u4e2d\u8f66\u5de5\u4e1a\u7814\u7a76\u9662\u6709\u9650\u516c\u53f8\/\u4e2d\u8f66\u5de5\u4e1a\u7814\u7a76\u9662(\u9752\u5c9b)\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":true,"lng":"116.302301","lat":"39.827106","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":521},{"name":"\u4e2d\u6d4b\u65b0\u56fe(\u5317\u4eac)\u9065\u611f\u6280\u672f\u6709\u9650\u8d23\u4efb\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":true,"lng":"116.261301","lat":"39.903497","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":539},{"name":"\u4e2d\u56fd\u79d1\u5b66\u9662\u5927\u5b66 \u4e2d\u5173\u6751\u6821\u533a","sales_rep":5329,"client_class":43,"client_type":1,"cooperated":false,"lng":"116.332009","lat":"39.981837","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"id":1369},{"name":"\u4e2d\u5de5\u56fd\u9645\u5de5\u7a0b\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":false,"lng":"116.311603","lat":"39.979547","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":1945},{"name":"\u5317\u4eac\u4eac\u57ce\u673a\u7535\u63a7\u80a1\u6709\u9650\u8d23\u4efb\u516c\u53f8","sales_rep":5329,"client_class":47,"client_type":6,"cooperated":false,"lng":"116.460479","lat":"39.897045","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":47,"name":"\u76ee\u6807\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":295},{"name":"\u4e2d\u56fd\u7164\u70ad\u5730\u8d28\u603b\u5c40","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":false,"lng":"116.323089","lat":"39.898668","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":1188},{"name":"\u4e2d\u6d77\u77f3\u6cb9\u6c14\u7535\u96c6\u56e2\u6709\u9650\u8d23\u4efb\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":false,"lng":"116.438565","lat":"39.977757","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":2567},{"name":"\u5efa\u4fe1\u57fa\u91d1\u7ba1\u7406\u6709\u9650\u8d23\u4efb\u516c\u53f8","sales_rep":5329,"client_class":47,"client_type":6,"cooperated":false,"lng":"116.357825","lat":"39.920574","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":47,"name":"\u76ee\u6807\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":2572},{"name":"\u4e2d\u94c1\u5efa\u5efa\u7b51\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":false,"lng":"116.232223","lat":"39.881626","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":2522},{"name":"\u4e2d\u5e7f\u6838\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":47,"client_type":6,"cooperated":false,"lng":"116.311609","lat":"39.925276","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":47,"name":"\u76ee\u6807\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":977},{"name":"\u4e2d\u56fd\u79d1\u5b66\u9662\u5149\u7535\u7814\u7a76\u9662(\u8d75\u6657\u7131\u8f6c\u51fa)","sales_rep":5329,"client_class":null,"client_type":1,"cooperated":false,"lng":"116.280974","lat":"40.071526","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":null,"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"id":556},{"name":"\u5317\u4eac\u5317\u91cd\u6c7d\u8f6e\u7535\u673a\u6709\u9650\u8d23\u4efb\u516c\u53f8","sales_rep":5329,"client_class":47,"client_type":6,"cooperated":false,"lng":"116.233980953693","lat":"39.8911728418009","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":47,"name":"\u76ee\u6807\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":1475},{"name":"\u4e94\u77ff\u96c6\u56e2\u8d22\u52a1\u8d23\u4efb\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":false,"lng":"116.332194","lat":"39.933868","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":2802},{"name":"\u56fd\u91d1\u57fa\u91d1\u7ba1\u7406\u6709\u9650\u516c\u53f8(S)","sales_rep":5329,"client_class":47,"client_type":6,"cooperated":false,"lng":"116.360388","lat":"39.911401","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":47,"name":"\u76ee\u6807\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":129},{"name":"\u4e2d\u822a\u91d1\u7f51(\u5317\u4eac)\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":false,"lng":"116.517078727484","lat":"39.7826128664178","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":1213},{"name":"\u56fd\u5bb6\u673a\u5173\u4e8b\u52a1\u7ba1\u7406\u5c40S","sales_rep":5329,"client_class":43,"client_type":1,"cooperated":false,"lng":"116.379685","lat":"39.922441","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"id":99},{"name":"\u4e2d\u6d77\u6cb9\u7814\u7a76\u603b\u9662","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":false,"lng":"116.438565","lat":"39.977757","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":2570},{"name":"\u4e2d\u56fd\u94c1\u9053\u79d1\u5b66\u7814\u7a76\u9662\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":47,"client_type":6,"cooperated":false,"lng":"116.337911188602","lat":"39.9553522179233","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":47,"name":"\u76ee\u6807\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":1040},{"name":"\u4e2d\u5efa\u8d22\u52a1\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":false,"lng":"116.4062","lat":"39.97831","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":1844},{"name":"\u4e2d\u4ea4\u4e00\u516c\u5c40\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":false,"lng":"116.584235876799","lat":"39.9105715358307","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":1856},{"name":"\u4e2d\u56fd\u90ae\u653f\u4f9b\u5e94\u94fe","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":false,"lng":"116.596337","lat":"40.131578","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":248},{"name":"\u5317\u65b9\u96c6\u6210\u7535\u8def\u6280\u672f\u521b\u65b0\u4e2d\u5fc3\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":false,"lng":"116.504192","lat":"39.782091","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":2812},{"name":"\u91d1\u822a\u6570\u7801\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":false,"lng":"116.45919","lat":"39.963389","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":1654},{"name":"\u4e2d\u56fd\u94dd\u4e1a\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":47,"client_type":6,"cooperated":false,"lng":"116.357628107071","lat":"39.9452296126194","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":47,"name":"\u76ee\u6807\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":294},{"name":"\u4e94\u77ff\u6709\u8272\u91d1\u5c5e\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":false,"lng":"116.332631","lat":"39.93519","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":611},{"name":"\u56fd\u6295\u4e2d\u9c81\u679c\u6c41\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":47,"client_type":6,"cooperated":false,"lng":"116.354637444019","lat":"39.9227192862094","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":47,"name":"\u76ee\u6807\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":1016},{"name":"\u4e2d\u56fd\u8239\u8236\u91cd\u5de5\u96c6\u56e2\u56fd\u9645\u5de5\u7a0b\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":false,"lng":"116.292049","lat":"39.946678","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":944},{"name":"\u4e2d\u56fd\u8f7b\u5de5\u96c6\u56e2\u516c\u53f8","sales_rep":5329,"client_class":43,"client_type":6,"cooperated":false,"lng":"116.490959","lat":"40.005394","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":1212},{"name":"\u4e2d\u56fd\u73b0\u4ee3\u6587\u5b66\u9986","sales_rep":5329,"client_class":47,"client_type":1,"cooperated":false,"lng":"116.430013","lat":"39.984713","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":47,"name":"\u76ee\u6807\u5ba2\u6237"},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"id":2826},{"name":"\u4e2d\u56fd\u519c\u4e1a\u53d1\u5c55\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":5329,"client_class":47,"client_type":6,"cooperated":false,"lng":"116.372331976891","lat":"39.9090562588453","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":47,"name":"\u76ee\u6807\u5ba2\u6237"},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"id":1411},{"name":"\u56fd\u5bb6\u536b\u5efa\u59d4","sales_rep":5329,"client_class":43,"client_type":1,"cooperated":false,"lng":"116.354215","lat":"39.936961","salesRep":{"id":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"clientClass":{"id":43,"name":"\u6f5c\u529b\u5ba2\u6237"},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"id":2795}],"thisUser":{"id":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-07 17:15:52') RETURNING "id"