08:53:10.165 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
08:53:10.165 | trace | yii\base\Module::getModule | Loading module: debug |
08:53:10.166 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
08:53:10.166 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
08:53:10.166 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
08:53:10.166 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:53:10.166 | trace | yii\base\Module::getModule | Loading module: gii |
08:53:10.166 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
08:53:10.167 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
08:53:10.167 | trace | yii\web\Application::handleRequest | Route requested: 'vue/analysis/sandbox' |
08:53:10.167 | trace | yii\base\Module::getModule | Loading module: vue |
08:53:10.168 | info | yii\web\Session::open | Session started |
08:53:10.169 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5016 |
08:53:10.169 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
08:53:10.173 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:53:10.173 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:53:10.174 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:53:10.174 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:53:10.174 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016 |
08:53:10.175 | trace | yii\base\Controller::runAction | Route to run: vue/analysis/sandbox |
08:53:10.176 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:53:10.177 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
08:53:10.177 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\AnalysisController::actionSandbox() |
08:53:10.178 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "is_delete"=FALSE ORDER BY "order", "id" |
08:53:10.179 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:53:10.179 | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
t.typname AS data_type,
a.attlen AS character_maximum_length,
pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
a.atttypmod AS modifier,
a.attnotnull = false AS is_nullable,
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values,
CASE atttypid
WHEN 21 /*int2*/ THEN 16
WHEN 23 /*int4*/ THEN 32
WHEN 20 /*int8*/ THEN 64
WHEN 1700 /*numeric*/ THEN
CASE WHEN atttypmod = -1
THEN null
ELSE ((atttypmod - 4) >> 16) & 65535
END
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
ELSE null
END AS numeric_precision,
CASE
WHEN atttypid IN (21, 23, 20) THEN 0
WHEN atttypid IN (1700) THEN
CASE
WHEN atttypmod = -1 THEN null
ELSE (atttypmod - 4) & 65535
END
ELSE null
END AS numeric_scale,
CAST(
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
AS numeric
) AS size,
a.attnum = any (ct.conkey) as is_pkey
FROM
pg_class c
LEFT JOIN pg_attribute a ON a.attrelid = c.oid
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p'
WHERE
a.attnum > 0 and t.typname != ''
and c.relname = 'tbl_product_types'
and d.nspname = 'a57be577deb434'
ORDER BY
a.attnum; |
08:53:10.184 | info | yii\db\Command::query | select
ct.conname as constraint_name,
a.attname as column_name,
fc.relname as foreign_table_name,
fns.nspname as foreign_table_schema,
fa.attname as foreign_column_name
from
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
FROM pg_constraint ct
) AS ct
inner join pg_class c on c.oid=ct.conrelid
inner join pg_namespace ns on c.relnamespace=ns.oid
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
left join pg_class fc on fc.oid=ct.confrelid
left join pg_namespace fns on fc.relnamespace=fns.oid
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
ct.contype='f'
and c.relname='tbl_product_types'
and ns.nspname='a57be577deb434'
order by
fns.nspname, fc.relname, a.attnum |
08:53:10.193 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:53:10.193 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
08:53:10.193 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:53:10.193 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:53:10.193 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'page' in 'app\models\search\SandBoxSearch'. |
08:53:10.193 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'sales' in 'app\models\search\SandBoxSearch'. |
08:53:10.193 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'GroupId' in 'app\models\search\SandBoxSearch'. |
08:53:10.193 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'web_access_token' in 'app\models\search\SandBoxSearch'. |
08:53:10.194 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:53:10.195 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:53:10.196 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT
c.id,
c.name,
c.client_class,
CASE WHEN p.id IS NULL THEN false ELSE true END AS cooperated,
extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days,
max(sl.end_at) as last_contact,
c.sales_rep
FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.client_id = c.id AND p.project_status = 3 LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.client_id = c.id WHERE (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 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, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND ("deleted"=FALSE) GROUP BY "c"."id", "cooperated" ORDER BY lost_contact_days ASC NULLS LAST, "c"."created_at" DESC) "c" |
08:53:10.242 | info | yii\db\Command::query | SELECT
c.id,
c.name,
c.client_class,
CASE WHEN p.id IS NULL THEN false ELSE true END AS cooperated,
extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days,
max(sl.end_at) as last_contact,
c.sales_rep
FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.client_id = c.id AND p.project_status = 3 LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.client_id = c.id WHERE (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 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, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND ("deleted"=FALSE) GROUP BY "c"."id", "cooperated" ORDER BY lost_contact_days ASC NULLS LAST, "c"."created_at" DESC LIMIT 30 |
08:53:10.292 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 5332, 5300, 1013, 5295, 5087, 1005, 5311) |
08:53:10.293 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5311, 5332, 5295, 1005, 5087, 1004, 1013, 5300)) |
08:53:10.294 | info | yii\db\Command::query | SELECT "id", "project_status", "project_progress", "created_by", "client_id", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "client_id" IN (2815, 3337, 3333, 141, 3056, 3332, 2032, 2736, 189, 2182, 2600, 24, 145, 101, 54, 2491, 18, 2187, 2806, 3316, 3290, 2737, 21, 2186, 2242, 2094, 1492, 1276, 3179, 149) |
08:53:10.302 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (9, 10, 7, 49, 3, 6, 5, 8, 2, 1, 4) |
08:53:10.303 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3430, 293, 3465, 3468, 2604, 223, 3479, 2923, 2963, 3001, 3685, 3493, 3242, 2569, 3283, 644, 3692, 3284, 3025, 215, 3531, 7, 3287, 204, 3211, 3207, 3548, 3289, 3542, 3547, 3051, 3230, 3224, 3061, 43, 3301, 2857, 3720, 2816, 3266, 3445, 2935, 1005, 3447, 532, 3098, 3701, 50, 3704, 3698, 2338, 3728, 3716, 2345, 3739, 3118, 3585, 3745, 3159, 3770, 68, 3268, 3086, 2331, 3800, 3793, 3619, 3622, 2828, 3625, 1121, 1148, 1182, 2918, 332, 3105, 3049, 1147, 2077, 2600, 2947, 2972, 1149, 3241, 3255, 3196, 3538, 3278, 2537, 2994, 3082, 3122, 1049, 3431, 3527, 3069, 3226, 3144, 2455, 2879, 3306, 3324, 2851, 3337, 1712, 3343, 3346, 2622, 3375, 3388, 3390, 3401, 3396, 1495, 82, 3422, 3421, 1775, 669, 533, 1713, 733, 1032, 578, 2926, 87, 2784, 118, 28, 1033, 2655, 2838, 2968, 182, 1048, 2796, 3186, 2096, 2584, 2925, 2375, 3143, 3032, 3127, 3297, 1096, 446, 1011, 2711, 2751, 2852, 2639, 2797, 2511, 2772, 2677, 588, 2636, 399, 1129, 1595, 1891, 2431, 1629, 2376, 2524, 2566, 1594, 56, 2678, 1612, 964, 2516, 1620, 910, 564, 110, 714, 2097, 232, 422, 858, 770, 1100, 1220, 229, 531, 642, 957, 609, 1593, 1604, 1016, 2641, 1181, 1521, 1609, 2582, 1622, 1592, 1527, 1720, 1603, 2358, 1146, 1721, 2590, 2453, 2591, 2659, 1025, 900, 1541, 911, 1733, 844, 1758, 2374, 2550, 1797, 1103, 1031, 12, 2373, 2337, 1602, 411, 1763, 2858, 2831, 2839, 2898, 2330, 2614, 2903, 2586, 3804, 3783, 3805, 3815, 3811, 3814) |
08:53:10.334 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (96, 97, 100, 98, 46, 45, 101, 138, 153, 139, 130, 179, 181, 226, 165, 142, 1, 128, 107, 173, 5, 113, 164, 180, 232, 112, 116, 140, 205, 167, 203, 166, 105, 136, 196, 204, 102, 177, 8, 197, 199, 99, 213, 2, 7, 212, 215, 172, 184, 137, 183, 6, 194, 200, 189, 229, 133, 135, 175, 160, 178, 157, 208, 182, 94, 154, 185, 191, 188, 159, 206, 174, 93, 10, 210, 9, 129, 224, 114, 158, 11, 207, 2100000000, 320, 211, 106, 155, 192, 225, 176, 132, 216, 190, 156, 231, 222, 223, 214, 219, 227, 228, 209, 217, 230, 218, 221, 265, 171, 305, 168, 131, 198, 202, 319, 313, 307, 163, 309, 311, 316, 317, 315, 322, 323, 324, 326, 327, 330, 331, 334, 338, 340, 341, 348, 349, 350, 353, 354, 355, 356, 359, 360, 367, 369, 373, 374, 377)) ORDER BY "sort" |
08:53:10.338 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3430, 293, 3465, 3468, 2604, 223, 3479, 2923, 2963, 3001, 3685, 3493, 3242, 2569, 3283, 644, 3692, 3284, 3025, 215, 3531, 7, 3287, 204, 3211, 3207, 3548, 3289, 3542, 3547, 3051, 3230, 3224, 3061, 43, 3301, 2857, 3720, 2816, 3266, 3445, 2935, 1005, 3447, 532, 3098, 3701, 50, 3704, 3698, 2338, 3728, 3716, 2345, 3739, 3118, 3585, 3745, 3159, 3770, 68, 3268, 3086, 2331, 3800, 3793, 3619, 3622, 2828, 3625, 1121, 1148, 1182, 2918, 332, 3105, 3049, 1147, 2077, 2600, 2947, 2972, 1149, 3241, 3255, 3196, 3538, 3278, 2537, 2994, 3082, 3122, 1049, 3431, 3527, 3069, 3226, 3144, 2455, 2879, 3306, 3324, 2851, 3337, 1712, 3343, 3346, 2622, 3375, 3388, 3390, 3401, 3396, 1495, 82, 3422, 3421, 1775, 669, 533, 1713, 733, 1032, 578, 2926, 87, 2784, 118, 28, 1033, 2655, 2838, 2968, 182, 1048, 2796, 3186, 2096, 2584, 2925, 2375, 3143, 3032, 3127, 3297, 1096, 446, 1011, 2711, 2751, 2852, 2639, 2797, 2511, 2772, 2677, 588, 2636, 399, 1129, 1595, 1891, 2431, 1629, 2376, 2524, 2566, 1594, 56, 2678, 1612, 964, 2516, 1620, 910, 564, 110, 714, 2097, 232, 422, 858, 770, 1100, 1220, 229, 531, 642, 957, 609, 1593, 1604, 1016, 2641, 1181, 1521, 1609, 2582, 1622, 1592, 1527, 1720, 1603, 2358, 1146, 1721, 2590, 2453, 2591, 2659, 1025, 900, 1541, 911, 1733, 844, 1758, 2374, 2550, 1797, 1103, 1031, 12, 2373, 2337, 1602, 411, 1763, 2858, 2831, 2839, 2898, 2330, 2614, 2903, 2586, 3804, 3783, 3805, 3815, 3811, 3814) |
08:53:10.359 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (96, 97, 100, 98, 46, 45, 101, 138, 153, 139, 130, 179, 181, 226, 165, 142, 1, 128, 107, 173, 5, 113, 164, 180, 232, 112, 116, 140, 205, 167, 203, 166, 105, 136, 196, 204, 102, 177, 8, 197, 199, 99, 213, 2, 7, 212, 215, 172, 184, 137, 183, 6, 194, 200, 189, 229, 133, 135, 175, 160, 178, 157, 208, 182, 94, 154, 185, 191, 188, 159, 206, 174, 93, 10, 210, 9, 129, 224, 114, 158, 11, 207, 2100000000, 320, 211, 106, 155, 192, 225, 176, 132, 216, 190, 156, 231, 222, 223, 214, 219, 227, 228, 209, 217, 230, 218, 221, 265, 171, 305, 168, 131, 198, 202, 319, 313, 307, 163, 309, 311, 316, 317, 315, 322, 323, 324, 326, 327, 330, 331, 334, 338, 340, 341, 348, 349, 350, 353, 354, 355, 356, 359, 360, 367, 369, 373, 374, 377)) ORDER BY "sort" |
08:53:10.363 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3430, 293, 3465, 3468, 2604, 223, 3479, 2923, 2963, 3001, 3685, 3493, 3242, 2569, 3283, 644, 3692, 3284, 3025, 215, 3531, 7, 3287, 204, 3211, 3207, 3548, 3289, 3542, 3547, 3051, 3230, 3224, 3061, 43, 3301, 2857, 3720, 2816, 3266, 3445, 2935, 1005, 3447, 532, 3098, 3701, 50, 3704, 3698, 2338, 3728, 3716, 2345, 3739, 3118, 3585, 3745, 3159, 3770, 68, 3268, 3086, 2331, 3800, 3793, 3619, 3622, 2828, 3625, 1121, 1148, 1182, 2918, 332, 3105, 3049, 1147, 2077, 2600, 2947, 2972, 1149, 3241, 3255, 3196, 3538, 3278, 2537, 2994, 3082, 3122, 1049, 3431, 3527, 3069, 3226, 3144, 2455, 2879, 3306, 3324, 2851, 3337, 1712, 3343, 3346, 2622, 3375, 3388, 3390, 3401, 3396, 1495, 82, 3422, 3421, 1775, 669, 533, 1713, 733, 1032, 578, 2926, 87, 2784, 118, 28, 1033, 2655, 2838, 2968, 182, 1048, 2796, 3186, 2096, 2584, 2925, 2375, 3143, 3032, 3127, 3297, 1096, 446, 1011, 2711, 2751, 2852, 2639, 2797, 2511, 2772, 2677, 588, 2636, 399, 1129, 1595, 1891, 2431, 1629, 2376, 2524, 2566, 1594, 56, 2678, 1612, 964, 2516, 1620, 910, 564, 110, 714, 2097, 232, 422, 858, 770, 1100, 1220, 229, 531, 642, 957, 609, 1593, 1604, 1016, 2641, 1181, 1521, 1609, 2582, 1622, 1592, 1527, 1720, 1603, 2358, 1146, 1721, 2590, 2453, 2591, 2659, 1025, 900, 1541, 911, 1733, 844, 1758, 2374, 2550, 1797, 1103, 1031, 12, 2373, 2337, 1602, 411, 1763, 2858, 2831, 2839, 2898, 2330, 2614, 2903, 2586, 3804, 3783, 3805, 3815, 3811, 3814) |
08:53:10.380 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (96, 97, 100, 98, 46, 45, 101, 138, 153, 139, 130, 179, 181, 226, 165, 142, 1, 128, 107, 173, 5, 113, 164, 180, 232, 112, 116, 140, 205, 167, 203, 166, 105, 136, 196, 204, 102, 177, 8, 197, 199, 99, 213, 2, 7, 212, 215, 172, 184, 137, 183, 6, 194, 200, 189, 229, 133, 135, 175, 160, 178, 157, 208, 182, 94, 154, 185, 191, 188, 159, 206, 174, 93, 10, 210, 9, 129, 224, 114, 158, 11, 207, 2100000000, 320, 211, 106, 155, 192, 225, 176, 132, 216, 190, 156, 231, 222, 223, 214, 219, 227, 228, 209, 217, 230, 218, 221, 265, 171, 305, 168, 131, 198, 202, 319, 313, 307, 163, 309, 311, 316, 317, 315, 322, 323, 324, 326, 327, 330, 331, 334, 338, 340, 341, 348, 349, 350, 353, 354, 355, 356, 359, 360, 367, 369, 373, 374, 377)) ORDER BY "sort" |
08:53:10.384 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id" IN (3430, 293, 3465, 3468, 2604, 223, 3479, 2923, 2963, 3001, 3685, 3493, 3242, 2569, 3283, 644, 3692, 3284, 3025, 215, 3531, 7, 3287, 204, 3211, 3207, 3548, 3289, 3542, 3547, 3051, 3230, 3224, 3061, 43, 3301, 2857, 3720, 2816, 3266, 3445, 2935, 1005, 3447, 532, 3098, 3701, 50, 3704, 3698, 2338, 3728, 3716, 2345, 3739, 3118, 3585, 3745, 3159, 3770, 68, 3268, 3086, 2331, 3800, 3793, 3619, 3622, 2828, 3625, 1121, 1148, 1182, 2918, 332, 3105, 3049, 1147, 2077, 2600, 2947, 2972, 1149, 3241, 3255, 3196, 3538, 3278, 2537, 2994, 3082, 3122, 1049, 3431, 3527, 3069, 3226, 3144, 2455, 2879, 3306, 3324, 2851, 3337, 1712, 3343, 3346, 2622, 3375, 3388, 3390, 3401, 3396, 1495, 82, 3422, 3421, 1775, 669, 533, 1713, 733, 1032, 578, 2926, 87, 2784, 118, 28, 1033, 2655, 2838, 2968, 182, 1048, 2796, 3186, 2096, 2584, 2925, 2375, 3143, 3032, 3127, 3297, 1096, 446, 1011, 2711, 2751, 2852, 2639, 2797, 2511, 2772, 2677, 588, 2636, 399, 1129, 1595, 1891, 2431, 1629, 2376, 2524, 2566, 1594, 56, 2678, 1612, 964, 2516, 1620, 910, 564, 110, 714, 2097, 232, 422, 858, 770, 1100, 1220, 229, 531, 642, 957, 609, 1593, 1604, 1016, 2641, 1181, 1521, 1609, 2582, 1622, 1592, 1527, 1720, 1603, 2358, 1146, 1721, 2590, 2453, 2591, 2659, 1025, 900, 1541, 911, 1733, 844, 1758, 2374, 2550, 1797, 1103, 1031, 12, 2373, 2337, 1602, 411, 1763, 2858, 2831, 2839, 2898, 2330, 2614, 2903, 2586, 3804, 3783, 3805, 3815, 3811, 3814) |
08:53:10.390 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1017, 1015, 1022, 1023, 5296, 1020, 5124, 5123, 5125, 1016, 5082, 5248, 5085) |
08:53:10.392 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (3, 4, 5, 1, 2) |
08:53:10.393 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 1006, 5295, 5300, 5309, 1004, 1007, 5087, 5096, 5089, 5088, 5364, 5045, 5026, 5299, 5043, 5076, 1013, 5332) |
08:53:10.395 | info | yii\db\Command::query | SELECT "id", "product_type_id", "product_type_id" AS "key", "name", "budget", "pct", "project_id" FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (3430, 293, 3465, 3468, 2604, 223, 3479, 2923, 2963, 3001, 3685, 3493, 3242, 2569, 3283, 644, 3692, 3284, 3025, 215, 3531, 7, 3287, 204, 3211, 3207, 3548, 3289, 3542, 3547, 3051, 3230, 3224, 3061, 43, 3301, 2857, 3720, 2816, 3266, 3445, 2935, 1005, 3447, 532, 3098, 3701, 50, 3704, 3698, 2338, 3728, 3716, 2345, 3739, 3118, 3585, 3745, 3159, 3770, 68, 3268, 3086, 2331, 3800, 3793, 3619, 3622, 2828, 3625, 1121, 1148, 1182, 2918, 332, 3105, 3049, 1147, 2077, 2600, 2947, 2972, 1149, 3241, 3255, 3196, 3538, 3278, 2537, 2994, 3082, 3122, 1049, 3431, 3527, 3069, 3226, 3144, 2455, 2879, 3306, 3324, 2851, 3337, 1712, 3343, 3346, 2622, 3375, 3388, 3390, 3401, 3396, 1495, 82, 3422, 3421, 1775, 669, 533, 1713, 733, 1032, 578, 2926, 87, 2784, 118, 28, 1033, 2655, 2838, 2968, 182, 1048, 2796, 3186, 2096, 2584, 2925, 2375, 3143, 3032, 3127, 3297, 1096, 446, 1011, 2711, 2751, 2852, 2639, 2797, 2511, 2772, 2677, 588, 2636, 399, 1129, 1595, 1891, 2431, 1629, 2376, 2524, 2566, 1594, 56, 2678, 1612, 964, 2516, 1620, 910, 564, 110, 714, 2097, 232, 422, 858, 770, 1100, 1220, 229, 531, 642, 957, 609, 1593, 1604, 1016, 2641, 1181, 1521, 1609, 2582, 1622, 1592, 1527, 1720, 1603, 2358, 1146, 1721, 2590, 2453, 2591, 2659, 1025, 900, 1541, 911, 1733, 844, 1758, 2374, 2550, 1797, 1103, 1031, 12, 2373, 2337, 1602, 411, 1763, 2858, 2831, 2839, 2898, 2330, 2614, 2903, 2586, 3804, 3783, 3805, 3815, 3811, 3814) |
08:53:10.404 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_client_product_types" WHERE "client_id" IN (2815, 3337, 3333, 141, 3056, 3332, 2032, 2736, 189, 2182, 2600, 24, 145, 101, 54, 2491, 18, 2187, 2806, 3316, 3290, 2737, 21, 2186, 2242, 2094, 1492, 1276, 3179, 149) |
08:53:10.407 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (47, 80, 43) |
08:53:10.413 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:53:10.413 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:53:10.414 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5016) AND ("object_type"=23) AND ("visit_date"='2025-07-08') |
08:53:10.419 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:53:10.419 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:53:10.419 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=6, "last_visit_at"='now()' WHERE "id"=49804 |
08:53:10.421 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5016, 5, 'vue/analysis/sandbox', '{"page":"1","sales_rep":"","group":"","sales":"undefined","keyword":"","GroupId":"","client_class":"","cooperated":"","period":"","web_access_token":"KTg8BnZ5JFWa2YxBawF8Yj9F0pEyUuJt"}', '{"code":2000,"result":{"labels":[{"id":"client_name","key":"client_name","name":"\u5ba2\u6237\u540d\u79f0"},{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},{"id":88,"key":88,"name":"\u79c1\u6709\u4e91"},{"id":8,"key":8,"name":"\u4e91\u684c\u9762"},{"id":7,"key":7,"name":"\u8f6f\u4ef6"},{"id":10,"key":10,"name":"\u56fe\u5f62\u5de5\u4f5c\u7ad9"},{"id":69,"key":69,"name":"\u5907\u4efd"},{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},{"id":12,"key":12,"name":"\u7b14\u8bb0\u672c"},{"id":13,"key":13,"name":"\u6253\u5370\u673a"},{"id":14,"key":14,"name":"UPS"},{"id":16,"key":16,"name":"\u8fd0\u7ef4\u670d\u52a1"},{"id":17,"key":17,"name":"\u5de5\u63a7\u673a"},{"id":18,"key":18,"name":"\u673a\u623f\u8bbe\u5907"},{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},{"id":20,"key":20,"name":"\u529e\u516c\u8bbe\u5907"},{"id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907"},{"id":22,"key":22,"name":"\u670d\u52a1"},{"id":23,"key":23,"name":"\u793c\u54c1"},{"id":75,"key":75,"name":"\u8f6f\u4ef6\u5f00\u53d1"}],"list":[{"id":2815,"name":"\u4e2d\u56fd\u9ec4\u91d1","client_class":47,"cooperated":false,"lost_contact_days":"3.77508383319444","last_contact":"2025-07-04 14:17:03","sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"lost_contact_days_display":"3\u5929\u524d","projectProductType2":[{"id":2,"status":1,"count":1},{"id":2,"status":2,"count":1}],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":3337,"name":"\u6d77\u57fa\u4f1a\u57fa\u91d1\u4f1a","client_class":80,"cooperated":false,"lost_contact_days":"3.91122966652778","last_contact":"2025-07-04 11:01:00","sales_rep":5332,"salesRep":{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","sex":"M","avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"}},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"lost_contact_days_display":"3\u5929\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":3333,"name":"\u822a\u5929\u56db\u521b\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09","client_class":43,"cooperated":true,"lost_contact_days":"49.345164851713","last_contact":"2025-05-20 00:36:08","sales_rep":"","salesRep":{},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"1\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[{"id":69,"status":3,"count":1}],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":141,"name":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8","client_class":43,"cooperated":true,"lost_contact_days":"52.6820051294907","last_contact":"2025-05-16 16:31:05","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"1\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[{"id":3,"status":0,"count":1}],"projectProductType4":[],"projectProductType5":[{"id":5,"status":0,"count":2}],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":3056,"name":"\u4e2d\u56fd\u822a\u5929","client_class":43,"cooperated":true,"lost_contact_days":"56.9485676294907","last_contact":"2025-05-12 10:07:14","sales_rep":1013,"salesRep":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"1\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":3332,"name":"\u4e2d\u79d1\u5bd2\u6b66\u7eaa\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","client_class":43,"cooperated":false,"lost_contact_days":"112.700812999861","last_contact":"2025-03-17 16:04:00","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8)","client_class":43,"cooperated":true,"lost_contact_days":"112.700812999861","last_contact":"2025-03-17 16:04:00","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[{"id":2,"status":3,"count":1}],"projectProductType3":[{"id":3,"status":3,"count":1},{"id":3,"status":0,"count":1}],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[{"id":7,"status":3,"count":1}],"projectProductType10":[{"id":10,"status":3,"count":1}],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2736,"name":"\u5317\u4eac\u4e2d\u6570\u521b\u65b0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u7f51\u6839\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8)","client_class":43,"cooperated":true,"lost_contact_days":"112.703590777639","last_contact":"2025-03-17 16:00:00","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[{"id":16,"status":3,"count":1}],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":189,"name":"\u5317\u4eac\u4eac\u897f\u5b66\u6821","client_class":80,"cooperated":true,"lost_contact_days":"112.741785222083","last_contact":"2025-03-17 15:05:00","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[{"id":7,"status":0,"count":1}],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[{"id":22,"status":0,"count":2}],"projectProductType23":[],"projectProductType75":[],"clientProductType67":{"id":67,"color":"#d3e0ff","value":"{\"name\":\"\\u674e\\u6c5f\\u661f\",\"time\":\"2019-10-28\",\"content\":\"\\u65e0 \"}"},"clientProductType68":{"id":68,"color":"#d3e0ff","value":"{\"name\":\"\\u674e\\u6c5f\\u661f\",\"time\":\"2019-10-28\",\"content\":\"\\u65e0 \"}"},"clientProductType70":{"id":70,"color":"#d3e0ff","value":"{\"name\":\"\\u674e\\u6c5f\\u661f\",\"time\":\"2019-10-28\",\"content\":\"\\u65e0 \"}"},"clientProductType72":{"id":72,"color":"#d3e0ff","value":"{\"name\":\"\\u674e\\u6c5f\\u661f\",\"time\":\"2019-10-28\",\"content\":\"\\u65e0 \"}"},"clientProductType76":{"id":76,"color":"#d3e0ff","value":"{\"name\":\"\\u674e\\u6c5f\\u661f\",\"time\":\"2019-10-28\",\"content\":\"\\u65e0 \"}"},"clientProductType85":{"id":85,"color":"#d3e0ff","value":"{\"name\":\"\\u674e\\u6c5f\\u661f\",\"time\":\"2019-10-28\",\"content\":\"\\u65e0 \"}"},"clientProductType86":{"id":86,"color":"#d3e0ff","value":"{\"name\":\"\\u674e\\u6c5f\\u661f\",\"time\":\"2019-10-28\",\"content\":\"\\u65e0 \"}"},"clientProductType100":{"id":100,"color":"#d3e0ff","value":"{\"name\":\"\\u674e\\u6c5f\\u661f\",\"time\":\"2019-10-28\",\"content\":\"\\u65e0 \"}"},"clientProductType3":{"id":3,"color":"#d3e0ff","value":"{\"name\":\"\\u674e\\u6c5f\\u661f\",\"time\":\"2019-10-28\",\"content\":\"\\u65e0 \"}"},"clientProductType88":{"id":88,"color":"#d3e0ff","value":"{\"name\":\"\\u674e\\u6c5f\\u661f\",\"time\":\"2019-10-28\",\"content\":\"\\u65e0 \"}"},"can_edit":true},{"id":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","client_class":80,"cooperated":true,"lost_contact_days":"112.745257444306","last_contact":"2025-03-17 15:00:00","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[{"id":3,"status":0,"count":2}],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[{"id":22,"status":0,"count":1}],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2600,"name":"\u822a\u5929\u79d1\u5de5\uff08\u5317\u4eac\uff09\u7a7a\u95f4\u4fe1\u606f\u6709\u9650\u516c\u53f8","client_class":43,"cooperated":false,"lost_contact_days":"112.78345188875","last_contact":"2025-03-17 14:05:00","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":24,"name":"\u4e2d\u822a\u946b\u6e2f\u62c5\u4fdd\u6709\u9650\u516c\u53f8","client_class":43,"cooperated":true,"lost_contact_days":"112.953590777639","last_contact":"2025-03-17 10:00:00","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"clientProductType85":{"id":85,"color":"#d3e0ff","value":"{\"name\":\"\\u674e\\u6c5f\\u661f\",\"time\":\"2020-03-29\",\"content\":\"\\u65e0 \"}"},"clientProductType86":{"id":86,"color":"#d3e0ff","value":"{\"name\":\"\\u674e\\u6c5f\\u661f\",\"time\":\"2020-03-29\",\"content\":\"\\u65e0 \"}"},"clientProductType87":{"id":87,"color":"#d3e0ff","value":"{\"name\":\"\\u674e\\u6c5f\\u661f\",\"time\":\"2020-03-29\",\"content\":\"\\u65e0 \"}"},"clientProductType22":{"id":22,"color":"#d3e0ff","value":"{\"name\":\"\\u674e\\u6c5f\\u661f\",\"time\":\"2020-03-29\",\"content\":\"\\u65e0 \"}"},"clientProductType3":{"id":3,"color":"#d3e0ff","value":"{\"name\":\"\\u674e\\u6c5f\\u661f\",\"time\":\"2020-03-29\",\"content\":\"\\u65e0 \"}"},"clientProductType69":{"id":69,"color":"#d3e0ff","value":"{\"name\":\"\\u674e\\u6c5f\\u661f\",\"time\":\"2020-03-29\",\"content\":\"\\u65e0 \"}"},"can_edit":true},{"id":145,"name":"\u5317\u4eac\u5929\u665f\u767e\u7eb3\u5b89\u5168\u6280\u672f\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8d3e\u4e91\u98de\uff09","client_class":43,"cooperated":true,"lost_contact_days":"114.046646333194","last_contact":"2025-03-16 07:46:00","sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[{"id":22,"status":0,"count":1}],"projectProductType23":[],"projectProductType75":[],"can_edit":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)","client_class":80,"cooperated":true,"lost_contact_days":"115.613312999861","last_contact":"2025-03-14 18:10:00","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[{"id":22,"status":0,"count":6},{"id":22,"status":3,"count":1}],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":54,"name":"\u5317\u4eac\u519c\u6797\u79d1\u5b66\u9662(\u5317\u4eac\u5229\u97ec\u5174\u4e1a\u79d1\u6280\u6709\u9650\u516c\u53f8)","client_class":80,"cooperated":true,"lost_contact_days":"115.617479666528","last_contact":"2025-03-14 18:04:00","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[{"id":22,"status":0,"count":5},{"id":22,"status":4,"count":2}],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2491,"name":"\u5317\u4eac\u9886\u96c1\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","client_class":43,"cooperated":false,"lost_contact_days":"115.620257444306","last_contact":"2025-03-14 18:00:00","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":18,"name":"\u4e2d\u5fb7\u8bc1\u5238\u6709\u9650\u8d23\u4efb\u516c\u53f8","client_class":43,"cooperated":true,"lost_contact_days":"115.620257444306","last_contact":"2025-03-14 18:00:00","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[{"id":3,"status":4,"count":2},{"id":3,"status":5,"count":1},{"id":3,"status":0,"count":2}],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[{"id":69,"status":4,"count":1}],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2187,"name":"\u7d2b\u5149\u540c\u82af\u5fae\u7535\u5b50\u6709\u9650\u516c\u53f8\uff08\u4f1f\u4ed5\u4f73\u6770\uff08\u91cd\u5e86\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09","client_class":43,"cooperated":true,"lost_contact_days":"115.65845188875","last_contact":"2025-03-14 17:05:00","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[{"id":3,"status":5,"count":1}],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[{"id":22,"status":0,"count":1}],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2806,"name":"\u4e00\u6c7d(\u5317\u4eac)\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8","client_class":47,"cooperated":false,"lost_contact_days":"115.661924110972","last_contact":"2025-03-14 17:00:00","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":3316,"name":"\u822a\u5929\u79d1\u5de5\u96c6\u56e2\u7b2c\u4e8c\u7814\u7a76\u9662 206 \u6240","client_class":43,"cooperated":false,"lost_contact_days":"115.675812999861","last_contact":"2025-03-14 16:40:00","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":3290,"name":"\u4ebf\u4e00\u751f\u7269","client_class":43,"cooperated":false,"lost_contact_days":"115.693174110972","last_contact":"2025-03-14 16:15:00","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[{"id":3,"status":4,"count":1}],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2737,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\uff08\u6240\u529e\uff09","client_class":43,"cooperated":true,"lost_contact_days":"115.700118555417","last_contact":"2025-03-14 16:05:00","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":21,"name":"\u9f99\u82af\u4e2d\u79d1\u6280\u672f\u6709\u9650\u516c\u53f8(\u9f99\u82af\u4e2d\u79d1\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\u3001\u9f99\u82af\u4e2d\u79d1\u5357\u4eac\u6280\u672f\u6709\u9650\u516c\u53f8)\uff08EDA\uff09","client_class":43,"cooperated":true,"lost_contact_days":"115.700118555417","last_contact":"2025-03-14 16:05:00","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[{"id":3,"status":0,"count":19},{"id":3,"status":4,"count":1}],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"clientProductType85":{"id":85,"color":"#d3e0ff","value":"{\"name\":\"\\u5218\\u4eba\\u8bda\",\"time\":\"2020-09-02\",\"content\":\"test \"}"},"can_edit":true},{"id":2186,"name":"\u6210\u90fd\u6d77\u5149\u96c6\u6210\u7535\u8def\u8bbe\u8ba1\u6709\u9650\u516c\u53f8\uff08EDA)","client_class":43,"cooperated":true,"lost_contact_days":"115.700812999861","last_contact":"2025-03-14 16:04:00","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[{"id":3,"status":0,"count":1},{"id":3,"status":5,"count":1}],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2242,"name":"\u5317\u4eac\u516b\u5927\u5904\u5965\u535a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u91d1\u5ba2\u6765\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","client_class":43,"cooperated":false,"lost_contact_days":"115.703590777639","last_contact":"2025-03-14 16:00:00","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","client_class":43,"cooperated":true,"lost_contact_days":"115.710535222083","last_contact":"2025-03-14 15:50:00","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[{"id":4,"status":0,"count":2}],"projectProductType5":[{"id":5,"status":0,"count":1}],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[{"id":22,"status":0,"count":1}],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":1492,"name":"\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u751f\u7269\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\u6709\u9650\u516c\u53f8)","client_class":80,"cooperated":true,"lost_contact_days":"115.731368555417","last_contact":"2025-03-14 15:20:00","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[{"id":3,"status":0,"count":4}],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[{"id":22,"status":4,"count":3},{"id":22,"status":0,"count":5},{"id":22,"status":3,"count":1}],"projectProductType23":[],"projectProductType75":[],"can_edit":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","client_class":43,"cooperated":true,"lost_contact_days":"115.741785222083","last_contact":"2025-03-14 15:05:00","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[{"id":3,"status":4,"count":2}],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[{"id":22,"status":0,"count":6}],"projectProductType23":[],"projectProductType75":[],"clientProductType71":{"id":71,"color":"#d3e0ff","value":"{\"name\":\"\\u7f57\\u7199\",\"time\":\"2019-10-13\",\"content\":\"\\u4ea4\\u6362\\u673a\\u3001\\u9632\\u6cc4\\u5bc6 \\u5f02\\u5730\\u5bb9\\u707e\\u6216\\u53cc\\u6d3b \"}"},"clientProductType72":{"id":72,"color":"#d3e0ff","value":"{\"name\":\"\\u7f57\\u7199\",\"time\":\"2019-10-13\",\"content\":\"\\u6709 \"}"},"clientProductType83":{"id":83,"color":"#d3e0ff","value":"{\"name\":\"\\u7f57\\u7199\",\"time\":\"2019-10-13\",\"content\":\"\\u7528\\u601d\\u79d1IP\\u7535\\u8bdd \"}"},"clientProductType87":{"id":87,"color":"#d3e0ff","value":"{\"name\":\"\\u7f57\\u7199\",\"time\":\"2019-10-13\",\"content\":\"\\u9700\\u8981\\u4e00\\u53f0AF-1000-A400 \"}"},"clientProductType93":{"id":93,"color":"#d3e0ff","value":"{\"name\":\"\\u7f57\\u7199\",\"time\":\"2019-10-13\",\"content\":\"\\u6709\\u9700\\u8981 \"}"},"clientProductType103":{"id":103,"color":"#d3e0ff","value":"{\"name\":\"\\u7f57\\u7199\",\"time\":\"2019-10-13\",\"content\":\"\\u9700\\u8981 \"}"},"clientProductType3":{"id":3,"color":"#d3e0ff","value":"{\"name\":\"\\u7f57\\u7199\",\"time\":\"2019-10-13\",\"content\":\"\\u539f\\u6765\\u7528\\u7684\\u662f\\u670d\\u52a1\\u5668\\u5f53\\u5b58\\u50a8\\uff0c\\u73b0\\u5728\\u60f3\\u6362\\u6210\\u4e13\\u95e8\\u7684\\u5b58\\u50a8\\u8bbe\\u5907 \"}"},"can_edit":true},{"id":3179,"name":"\u4e2d\u79d1\u9a6d\u6570\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8","client_class":43,"cooperated":false,"lost_contact_days":"115.745257444306","last_contact":"2025-03-14 15:00:00","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[],"projectProductType18":[],"projectProductType19":[],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[],"projectProductType23":[],"projectProductType75":[],"can_edit":true},{"id":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)\uff08\u71d5\u4eac\uff09","client_class":80,"cooperated":true,"lost_contact_days":"115.745257444306","last_contact":"2025-03-14 15:00:00","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"lost_contact_days_display":"3\u4e2a\u6708\u524d","projectProductType2":[],"projectProductType3":[{"id":3,"status":0,"count":6}],"projectProductType4":[],"projectProductType5":[],"projectProductType88":[{"id":88,"status":0,"count":2}],"projectProductType8":[],"projectProductType7":[],"projectProductType10":[],"projectProductType69":[{"id":69,"status":0,"count":1}],"projectProductType11":[],"projectProductType12":[],"projectProductType13":[],"projectProductType14":[],"projectProductType16":[],"projectProductType17":[{"id":17,"status":3,"count":1}],"projectProductType18":[],"projectProductType19":[{"id":19,"status":3,"count":1}],"projectProductType20":[],"projectProductType21":[],"projectProductType22":[{"id":22,"status":0,"count":12},{"id":22,"status":3,"count":1},{"id":22,"status":4,"count":1}],"projectProductType23":[],"projectProductType75":[],"can_edit":true}],"pagenation":{"totalcount":1885,"thispage":1,"pagesize":30}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-08 08:53:10') RETURNING "id" |
08:53:10.425 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:53:10.425 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |