685b5e2018f90: POST https://beta.jinchangxiao.com/v2/project/of-client at 2025-06-25 10:25:36 am by 223.104.41.148
Performance Profiling
Total processing time: 540 ms; Peak memory: 6.173 MB. Show Profiling Timeline
总计77条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 10:25:36.362 | 27.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (3543, 3731, 3732, 2993) ORDER BY "id" |
| 10:25:36.604 | 27.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id" IN (3739, 3692, 3493, 3297, 3375, 110) |
| 10:25:36.547 | 24.5 ms | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (3739, 3692, 3493, 3297, 3375, 110)) GROUP BY "object_id" |
| 10:25:36.572 | 22.2 ms | yii\db\Command::query | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=1) AND (remind_user_id = 5016 AND is_read = false) AND ("object_id" IN (3739, 3692, 3493, 3297, 3375, 110)) GROUP BY "object_id" |
| 10:25:36.486 | 20.6 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (3003, 3575, 3741) |
| 10:25:36.134 | 19.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND ("p"."client_id"=141) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC) "c" |
| 10:25:36.405 | 18.8 ms | yii\db\Command::query | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (3543, 3731, 3732, 2993) |
| 10:25:36.467 | 16.0 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (564, 640) |
| 10:25:36.154 | 15.3 ms | yii\db\Command::query | SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND ("p"."client_id"=141) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC LIMIT 10 |
| 10:25:36.338 | 15.1 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "created_at", "collected_date" FROM "a57be577deb434"."tbl_sales_contract_payments" WHERE "contract_id" IN (3543, 3731, 3732, 2993) ORDER BY "id" |
| 10:25:36.190 | 13.9 ms | 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_project_architects' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 10:25:36.450 | 13.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (3543, 3731, 3732, 2993) |
| 10:25:36.223 | 12.6 ms | yii\db\Command::query | SELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", sum(points) as points FROM "a57be577deb434"."tbl_case_assignments" GROUP BY "case_id") "ca" ON ca.case_id = c.id WHERE "c"."project_id" IN (3739, 3692, 3493, 3297, 3375, 110) GROUP BY "c"."project_id" |
| 10:25:36.391 | 11.7 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (3543, 3731, 3732, 2993) ORDER BY "remind_date" |
| 10:25:36.289 | 9.9 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21514, 16429, 23420, 23419) |
| 10:25:36.310 | 9.0 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (22679, 16495, 23650, 23792) |
| 10:25:36.511 | 8.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3739, 3692, 3493, 3297, 3375, 110) |
| 10:25:36.328 | 8.0 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21878, 17033) |
| 10:25:36.280 | 7.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (3543, 3731, 3732, 2993)) |
| 10:25:36.301 | 7.0 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (3543, 3731, 3732, 2993)) |
| 10:25:36.427 | 6.8 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5388, 1001) |
| 10:25:36.437 | 6.8 ms | 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 (1001, 5388, 5300)) |
| 10:25:36.521 | 6.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1917, 1918, 1919, 1920, 1921, 1125, 1786, 980, 981, 1196) |
| 10:25:36.206 | 6.4 ms | yii\db\Command::query | SELECT id, product_type_id, product_type_id as key, name, coalesce(budget, 0) as budget, coalesce(pct, 0) as pct, coalesce(profit, 0) as profit, project_id FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (3739, 3692, 3493, 3297, 3375, 110) |
| 10:25:36.184 | 6.1 ms | 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_project_architects' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 10:25:36.321 | 6.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (3543, 3731, 3732, 2993)) |
| 10:25:36.249 | 5.9 ms | yii\db\Command::query | SELECT "id", "from_project", "payment_collection_remind_ahead", "serial_no", "is_settle", "is_deliver", "is_outbound" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3739, 3692, 3493, 3297, 3375, 110) |
| 10:25:36.104 | 5.7 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 10:25:36.533 | 5.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (25, 26, 214, 35, 41, 14, 43) |
| 10:25:36.355 | 5.0 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1014, 5388, 1013) |
| 10:25:36.594 | 4.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3739, 3692, 3493, 3297, 3375, 110) |
| 10:25:36.540 | 4.6 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1508, 1587, 1588, 1589, 1276, 1275, 170, 748) |
| 10:25:36.242 | 3.8 ms | yii\db\Command::query | SELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_pre_sales" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=1) AND ("c"."project_id" IN (3739, 3692, 3493, 3297, 3375, 110)) GROUP BY "c"."project_id" |
| 10:25:36.109 | 3.6 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L' |
| 10:25:36.635 | 3.5 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5016, 2, 1141, 'v2/project/of-client', '{"access_token":"J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L","device_type":"2","id":"141","page":"1","posttime":"1750818304","token":"256d9a220d0f328279b36e9a0b5c48cd","version_code":"1141"}', '{"code":200,"data":{"list":[{"id":3739,"client_id":141,"project_status":3,"project_progress":9,"budget":"167000","profit_pct":"7.21","bargain_date":"2024-12-24","description":"","created_by":5300,"created_at":"2024-12-11 16:25:34","updated_at":"2025-06-12 20:21:43","engineer_id":null,"project_title":"\u601d\u79d1\u9632\u706b\u58991140*2+1120*1\u65b0\u8d2d-K-2024","collected":"167000","status_updated_at":"2024-12-27 14:20:51.811571+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-12-23 10:00:48.132401+08","forecast_updated_at":"2024-12-23 10:00:48.132401+08","end_at":"2024-12-31 17:14:28","pinyin_shortcut":"skfhq1140211201xgK2024","creator":5300,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":744,"is_sales_order_ready":true,"collected_plan":167000,"profits":"12040.700000000000000000","remain":"179 days 20:04:44.3447","progress_remain":"184 days 00:24:48.02387","forecast_remain":"184 days 00:24:48.02387","lost_contact_days":"39.7461939383218","last_contact":"2025-05-16 16:31:05","last_arrive_days":"39.7461939383218","last_arrive":"2025-05-16 16:31:05+08","duration":"20 days 00:48:53.516581","issued_invoices":"167000.00","client":{"id":141,"key":141,"name":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8","logo":null,"client_type":1,"client_class":43,"client_industry":10,"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"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"167000.00","pct":"7.21","profit":"12040.7","project_id":3739}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"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"}},"casePoints":null,"workLogCount":{"project_id":3739,"count":12},"caseCount":null,"salesTimeCount":{"project_id":3739,"hours":"0.852222222222222","times":2},"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3739,"sum":"464"},"buildContract":{"id":3732,"from_project":3739,"payment_collection_remind_ahead":"7 days","serial_no":"TS-SQY-2024122402","is_settle":true,"is_deliver":true,"is_outbound":true,"contractScans":[{"id":31507,"object_type":105,"object_id":3732,"attachment_id":23420,"attachment":{"id":23420,"key":23420,"name":"759c10b9-9087-3408-8efe-baa757db57e2","extension":"pdf","path":"\/v2\/attachment\/preview\/J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L\/759c10b9-9087-3408-8efe-baa757db57e2\/167000.pdf","orig_name":"167000.pdf"}}],"receiptScans":[{"id":31897,"object_type":106,"object_id":3732,"attachment_id":23792,"attachment":{"id":23792,"key":23792,"name":"2cb0740b-151a-3575-8f99-f5a467c79b90","extension":"pdf","path":"\/v2\/attachment\/preview\/J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L\/2cb0740b-151a-3575-8f99-f5a467c79b90\/\u201c2025\u62d3\u5b9e\u7b7e\u6536\u5355\u201d\u7684\u526f\u672c.pdf","orig_name":"\u201c2025\u62d3\u5b9e\u7b7e\u6536\u5355\u201d\u7684\u526f\u672c.pdf"}}],"verifyScans":[],"salesContractPayments":[{"id":2064,"key":2064,"contract_id":3732,"value":"167000","created_by":5388,"created_at":"2024-12-31 17:14:28","collected_date":"2024-12-31","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1914,"key":1914,"contract_id":3732,"value":"167000.00","attachment_id":null,"from_date":"2024-12-27","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2294,"key":2294,"contract_id":3732,"name":"2025-01-31","value":"167000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":7623,"user_id":5300,"key":5300,"contract_id":3732,"user":{"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"}}},{"id":7624,"user_id":5388,"key":5388,"contract_id":3732,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7625,"user_id":1001,"key":1001,"contract_id":3732,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesSupplierRels":[{"id":2314,"contract_id":3732,"supplier_id":564,"purchase_id":3741,"supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3741,"key":3741,"serial_no":"TSKJ20241231-SQY-001"}}],"payment_collection_remind_ahead_display":"7\u5929"},"projectRemindReceivers":[{"id":1344,"user_id":1001,"key":1001,"project_id":3739,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"projectProductRels":[{"id":8369,"project_id":3739,"product_id":1917,"amount":"35300.00","number":2,"cost":"36308.00","description":"","supplier_id":564,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"70600","total_cost":"72616","supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1917,"name":"FPR1140-NGFW-K9","product_type":5,"product_component":26,"product_brand":3,"product_serie":1587,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-12-30 17:01:27","updated_at":"2024-12-30 17:01:27","pinyin_shortcut":"FPR1140NGFWK9","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1587,"key":1587,"name":"Cisco Firepower 1000 \u7cfb\u5217"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":8370,"project_id":3739,"product_id":1918,"amount":"0","number":2,"cost":"4000.00","description":"","supplier_id":564,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"8000","supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1918,"name":"CON-SNT-FR11P40N","product_type":5,"product_component":214,"product_brand":3,"product_serie":1588,"product_misc":null,"product_qa":null,"pn":"","description":"SNTC-8X5XNBD Cisco Firepower 1140 NGFW Appliance, 1U","created_by":1013,"created_at":"2024-12-30 17:03:18","updated_at":"2024-12-30 17:03:18","pinyin_shortcut":"CONSNTFR11P40N","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":214,"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1588,"key":1588,"name":"\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8371,"project_id":3739,"product_id":1919,"amount":"26700.00","number":2,"cost":"21700.00","description":"","supplier_id":564,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"53400","total_cost":"43400","supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1919,"name":"L-FPR1140T-TMC-1Y","product_type":5,"product_component":35,"product_brand":3,"product_serie":1589,"product_misc":null,"product_qa":null,"pn":"","description":"Cisco FPR1140 Threat Defense Threat, Malware and URL 1Y Subs","created_by":1013,"created_at":"2024-12-30 17:09:46","updated_at":"2024-12-30 17:09:46","pinyin_shortcut":"LFPR1140TTMC1Y","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1589,"key":1589,"name":"Cisco Firepower 1000 \u7cfb\u5217\u9632\u706b\u5899\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8372,"project_id":3739,"product_id":1920,"amount":"39690.00","number":1,"cost":"22000.00","description":"","supplier_id":564,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"39690","total_cost":"22000","supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1920,"name":"FPR1120-ASA-K9","product_type":5,"product_component":26,"product_brand":3,"product_serie":1587,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-12-30 17:11:17","updated_at":"2024-12-30 17:11:17","pinyin_shortcut":"FPR1120ASAK9","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1587,"key":1587,"name":"Cisco Firepower 1000 \u7cfb\u5217"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":8373,"project_id":3739,"product_id":1921,"amount":"3310.00","number":1,"cost":"3310.00","description":"","supplier_id":564,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"3310","total_cost":"3310","supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1921,"name":"CON-SNT-FPR1120A","product_type":5,"product_component":214,"product_brand":3,"product_serie":1588,"product_misc":null,"product_qa":null,"pn":"","description":"SNTC-8X5XNBD Cisco Firepower 1120 ASA Appliance","created_by":1013,"created_at":"2024-12-30 17:12:26","updated_at":"2024-12-30 17:12:26","pinyin_shortcut":"CONSNTFPR1120A","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":214,"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1588,"key":1588,"name":"\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"commentCount":{"object_id":3739,"comment":8},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"projectUsedClient":null,"remain_display":179,"progress_remain_display":184,"forecast_remain_display":184,"projectProductTotalAmount":167000,"projectProductAllAmount":true,"projectProductTotalCost":149326,"projectProductAllCost":true,"projectProductTotalNumber":8,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"1\u4e2a\u6708\u524d","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":20,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"1\u4e2a\u6708\u524d","can_view_product":true,"budget_display":"16.7\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e"},{"id":3692,"client_id":141,"project_status":3,"project_progress":9,"budget":"186000","profit_pct":"-2.13","bargain_date":"2024-12-24","description":"","created_by":5300,"created_at":"2024-10-17 15:46:16","updated_at":"2025-02-20 13:41:45","engineer_id":null,"project_title":"\u601d\u79d1\u9632\u706b\u5899\u65b0\u8d2d1140*3\u65b0\u8d2d-K-2024","collected":"186000","status_updated_at":"2024-12-27 14:17:13.649516+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-12-23 09:58:12.331114+08","forecast_updated_at":"2024-12-23 09:58:12.331114+08","end_at":"2024-12-31 17:14:55","pinyin_shortcut":"skfhqxg11403xgK2024","creator":5300,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":743,"is_sales_order_ready":true,"collected_plan":186000,"profits":"-3961.800000000000000000","remain":"179 days 20:08:22.506755","progress_remain":"184 days 00:27:23.825157","forecast_remain":"184 days 00:27:23.825157","lost_contact_days":"197.809446253137","last_contact":"2024-12-09 15:00:00","last_arrive_days":"228.824724030914","last_arrive":"2024-11-08 14:38:00+08","duration":"75 days 01:28:38.997776","issued_invoices":"186000.00","client":{"id":141,"key":141,"name":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8","logo":null,"client_type":1,"client_class":43,"client_industry":10,"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"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"186000.00","pct":"-2.13","profit":"-3961.8","project_id":3692}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"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"}},"casePoints":null,"workLogCount":{"project_id":3692,"count":7},"caseCount":null,"salesTimeCount":{"project_id":3692,"hours":"6.55","times":4},"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3692,"sum":"224.86"},"buildContract":{"id":3731,"from_project":3692,"payment_collection_remind_ahead":"7 days","serial_no":"TS-SQY-2024122401","is_settle":true,"is_deliver":true,"is_outbound":true,"contractScans":[{"id":31508,"object_type":105,"object_id":3731,"attachment_id":23419,"attachment":{"id":23419,"key":23419,"name":"f79c73cf-7481-3d32-95e0-87a3231dbf75","extension":"pdf","path":"\/v2\/attachment\/preview\/J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L\/f79c73cf-7481-3d32-95e0-87a3231dbf75\/186000.pdf","orig_name":"186000.pdf"}}],"receiptScans":[{"id":31721,"object_type":106,"object_id":3731,"attachment_id":23650,"attachment":{"id":23650,"key":23650,"name":"1adc2d45-5e06-3111-a522-44c8e23f2bdf","extension":"pdf","path":"\/v2\/attachment\/preview\/J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L\/1adc2d45-5e06-3111-a522-44c8e23f2bdf\/2025_01_13_09_11_26.pdf","orig_name":"2025_01_13_09_11_26.pdf"}}],"verifyScans":[],"salesContractPayments":[{"id":2065,"key":2065,"contract_id":3731,"value":"186000","created_by":5388,"created_at":"2024-12-31 17:14:55","collected_date":"2024-12-31","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1913,"key":1913,"contract_id":3731,"value":"186000.00","attachment_id":null,"from_date":"2024-12-27","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2293,"key":2293,"contract_id":3731,"name":"2025-01-31","value":"186000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":7626,"user_id":5300,"key":5300,"contract_id":3731,"user":{"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"}}},{"id":7627,"user_id":5388,"key":5388,"contract_id":3731,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7628,"user_id":1001,"key":1001,"contract_id":3731,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesSupplierRels":[{"id":2315,"contract_id":3731,"supplier_id":564,"purchase_id":3741,"supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3741,"key":3741,"serial_no":"TSKJ20241231-SQY-001"}}],"payment_collection_remind_ahead_display":"7\u5929"},"projectRemindReceivers":[{"id":1343,"user_id":1001,"key":1001,"project_id":3692,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"projectProductRels":[{"id":8374,"project_id":3692,"product_id":1917,"amount":"35300.00","number":3,"cost":"36308.00","description":"","supplier_id":564,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"105900","total_cost":"108924","supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1917,"name":"FPR1140-NGFW-K9","product_type":5,"product_component":26,"product_brand":3,"product_serie":1587,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-12-30 17:01:27","updated_at":"2024-12-30 17:01:27","pinyin_shortcut":"FPR1140NGFWK9","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1587,"key":1587,"name":"Cisco Firepower 1000 \u7cfb\u5217"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":8375,"project_id":3692,"product_id":1918,"amount":"0","number":3,"cost":"4000.00","description":"\u4e00\u5e74\u670d\u52a1","supplier_id":564,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"12000","supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1918,"name":"CON-SNT-FR11P40N","product_type":5,"product_component":214,"product_brand":3,"product_serie":1588,"product_misc":null,"product_qa":null,"pn":"","description":"SNTC-8X5XNBD Cisco Firepower 1140 NGFW Appliance, 1U","created_by":1013,"created_at":"2024-12-30 17:03:18","updated_at":"2024-12-30 17:03:18","pinyin_shortcut":"CONSNTFR11P40N","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":214,"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1588,"key":1588,"name":"\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8376,"project_id":3692,"product_id":1919,"amount":"26700.00","number":3,"cost":"21700.00","description":"","supplier_id":564,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"80100","total_cost":"65100","supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1919,"name":"L-FPR1140T-TMC-1Y","product_type":5,"product_component":35,"product_brand":3,"product_serie":1589,"product_misc":null,"product_qa":null,"pn":"","description":"Cisco FPR1140 Threat Defense Threat, Malware and URL 1Y Subs","created_by":1013,"created_at":"2024-12-30 17:09:46","updated_at":"2024-12-30 17:09:46","pinyin_shortcut":"LFPR1140TTMC1Y","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1589,"key":1589,"name":"Cisco Firepower 1000 \u7cfb\u5217\u9632\u706b\u5899\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"commentCount":{"object_id":3692,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"projectUsedClient":null,"remain_display":179,"progress_remain_display":184,"forecast_remain_display":184,"projectProductTotalAmount":186000,"projectProductAllAmount":true,"projectProductTotalCost":186024,"projectProductAllCost":true,"projectProductTotalNumber":9,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"7\u4e2a\u6708\u524d","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":75,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"6\u4e2a\u6708\u524d","can_view_product":true,"budget_display":"18.6\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e"},{"id":3493,"client_id":141,"project_status":3,"project_progress":9,"budget":"172600","profit_pct":"2.05","bargain_date":"2024-08-10","description":"","created_by":5300,"created_at":"2024-04-08 16:36:11","updated_at":"2024-11-07 10:34:24","engineer_id":null,"project_title":"\u6df1\u4fe1\u670d\u5bc6\u8bc4VPN-K-2024","collected":"172600","status_updated_at":"2024-09-13 14:48:40.002294+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-08-05 09:30:43.509355+08","forecast_updated_at":"2024-08-05 09:30:43.509355+08","end_at":"2024-10-30 11:04:54","pinyin_shortcut":"sxfmpVPNK2024","creator":5364,"used_client":null,"from_contact":null,"total_contact_point":"55028","paid_contact_point":"55028","project_product_version_id":607,"is_sales_order_ready":true,"collected_plan":172600,"profits":"3538.300000000000000000","remain":"284 days 19:36:56.153977","progress_remain":"324 days 00:54:52.646916","forecast_remain":"324 days 00:54:52.646916","lost_contact_days":"231.976112919803","last_contact":"2024-11-05 11:00:00","last_arrive_days":"335.795557364248","last_arrive":"2024-07-24 15:20:00+08","duration":"204 days 18:28:43.106547","issued_invoices":"172600.00","client":{"id":141,"key":141,"name":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8","logo":null,"client_type":1,"client_class":43,"client_industry":10,"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"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"172600","pct":"2.05","profit":"3538.3","project_id":3493}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355","description":"\u4fdd\u63015%\u57fa\u672c\u5229\u6da6\u7387\uff0c\u5e2e\u52a9\u5382\u5546\u4ea4\u4ed8\u9879\u76ee\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5364,"key":5364,"name":"\u738b\u827a\u742e","sex":"F","department_id":1,"avatar":{"id":154,"user_id":5364,"name":"\/files\/cdn\/a57be577deb434\/avatar\/a0b46fdc-d67f-305c-82e5-5b2e01c08e21.png"}},"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"}},"casePoints":null,"workLogCount":{"project_id":3493,"count":13},"caseCount":null,"salesTimeCount":{"project_id":3493,"hours":"4.46666666666667","times":3},"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3493,"sum":"1068"},"buildContract":{"id":3543,"from_project":3493,"payment_collection_remind_ahead":"7 days","serial_no":"TS-SQY-2024080101","is_settle":true,"is_deliver":true,"is_outbound":true,"contractScans":[{"id":30053,"object_type":105,"object_id":3543,"attachment_id":21514,"attachment":{"id":21514,"key":21514,"name":"c1082e45-ee27-3c13-81ea-10cace19938f","extension":"pdf","path":"\/v2\/attachment\/preview\/J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L\/c1082e45-ee27-3c13-81ea-10cace19938f\/20240913143217076.pdf","orig_name":"20240913143217076.pdf"}}],"receiptScans":[{"id":30381,"object_type":106,"object_id":3543,"attachment_id":22679,"attachment":{"id":22679,"key":22679,"name":"896dfb1a-b335-3c7c-9fc5-f2dc1753a109","extension":"pdf","path":"\/v2\/attachment\/preview\/J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L\/896dfb1a-b335-3c7c-9fc5-f2dc1753a109\/20241114094644311.pdf","orig_name":"20241114094644311.pdf"}}],"verifyScans":[{"id":30382,"object_type":107,"object_id":3543,"attachment_id":21878,"attachment":{"id":21878,"key":21878,"name":"391f6a32-c4ea-3f4a-9052-ac9a4a339430","extension":"pdf","path":"\/v2\/attachment\/preview\/J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L\/391f6a32-c4ea-3f4a-9052-ac9a4a339430\/\u5929\u6d25\u878d\u5b9d\u9a8c\u6536\u5355.pdf","orig_name":"\u5929\u6d25\u878d\u5b9d\u9a8c\u6536\u5355.pdf"}}],"salesContractPayments":[{"id":1975,"key":1975,"contract_id":3543,"value":"129450","created_by":5388,"created_at":"2024-09-26 17:57:38","collected_date":"2024-09-26","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":75},{"id":2000,"key":2000,"contract_id":3543,"value":"43150","created_by":1013,"created_at":"2024-10-30 11:04:54","collected_date":"2024-10-30","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":25}],"salesContractInvoices":[{"id":1801,"key":1801,"contract_id":3543,"value":"172600.00","attachment_id":null,"from_date":"2024-09-14","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2071,"key":2071,"contract_id":3543,"name":"2024-09-30","value":"129450","overdue_days":null,"pct":75,"collect_status":"\u5df2\u5b8c\u6210"},{"id":2072,"key":2072,"contract_id":3543,"name":"2024-11-15","value":"43150","overdue_days":null,"pct":25,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":7015,"user_id":5300,"key":5300,"contract_id":3543,"user":{"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"}}},{"id":7016,"user_id":5388,"key":5388,"contract_id":3543,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7017,"user_id":1001,"key":1001,"contract_id":3543,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesSupplierRels":[{"id":1977,"contract_id":3543,"supplier_id":640,"purchase_id":3575,"supplier":{"id":640,"key":640,"name":"\u5317\u4eac\u4e16\u7eaa\u7f51\u6e90\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3575,"key":3575,"serial_no":"TSKJ20241009-HYF-003"}}],"payment_collection_remind_ahead_display":"7\u5929"},"projectRemindReceivers":[],"projectProductRels":[{"id":7283,"project_id":3493,"product_id":1786,"amount":"86300","number":2,"cost":"6000","description":"","supplier_id":640,"hardware_from":"2024-09-23","software_from":null,"maintenance_from":null,"hardware_to":"2027-09-23","software_to":null,"maintenance_to":null,"total_amount":"172600","total_cost":"12000","supplier":{"id":640,"key":640,"name":"\u5317\u4eac\u4e16\u7eaa\u7f51\u6e90\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1786,"name":"aTrust-1000-S1035M","product_type":4,"product_component":25,"product_brand":12,"product_serie":1508,"product_misc":null,"product_qa":null,"pn":"","description":"SSL\u6027\u80fd\u53c2\u6570\uff1a\u6700\u5927\u7406\u8bba\u52a0\u5bc6\u6d41\u91cf\uff08Mbps\uff09\uff1a480Mbps\uff0c\u6700\u5927\u7406\u8bba\u5efa\u8bae\u5e76\u53d1\u7528\u6237\u6570\uff08\u4e2a\uff09\uff1a1000\u3002\n\u786c\u4ef6\u53c2\u6570\uff1a\u89c4\u683c\uff1a1U\uff0c\u5185\u5b58\u5927\u5c0f\uff1a16G\uff0c\u786c\u76d8\u5bb9\u91cf\uff1a128G SSD\uff0c\u7535\u6e90\uff1a\u5197\u4f59\u7535\u6e90\uff0c\u63a5\u53e3\uff1a6\u5343\u5146\u7535\u53e3+4\u5343\u5146\u5149\u53e3SFP\u3002\n\u529f\u80fd\u63cf\u8ff0\uff1a\u6df1\u4fe1\u670daTrust-1000-S\u7cfb\u5217\u5546\u5bc6\u578b\u53f7\u4ea7\u54c1\uff0c\u91c7\u7528\u56fd\u5bb6\u5bc6\u7801\u7ba1\u7406\u5c40\u9881\u5e03\u7684SM1\u3001SM2\u3001SM3\u3001SM4\u5bc6\u7801\u7b97\u6cd5\u53ca\u5176\u534f\u8bae\uff0c\u652f\u6301\u591a\u79cd\u8eab\u4efd\u8ba4\u8bc1\u65b9\u5f0f\u3001\u7ec6\u7c92\u5ea6\u8bbf\u95ee\u6743\u9650\u63a7\u5236\u7b49\u4e3b\u8981\u529f\u80fd\uff0c\u53e6\u5916\u53ef\u9009\u914d\u6269\u5c55\u652f\u6301UEM\u529f\u80fd\uff08\u5355\u72ec\u6536\u8d39\uff09\uff0c\u4fdd\u8bc1\u8fdc\u7a0b\u7cfb\u7edf\u63a5\u5165\u7684\u7528\u6237\u8eab\u4efd\u5b89\u5168\u3001\u7ec8\u7aef\/\u6570\u636e\u5b89\u5168\u3001\u4f20\u8f93\u5b89\u5168\u3001\u5e94\u7528\u6743\u9650\u5b89\u5168\u548c\u5ba1\u8ba1\u5b89\u5168\uff0c\u7b26\u5408\u56fd\u5bb6\u5546\u7528\u5bc6\u7801\u6807\u51c6\uff0c\u5177\u6709\u5feb\u901f\u3001\u6613\u7528\u3001\u5168\u9762\u7b49\u4f18\u52bf\u7279\u70b9\u3002","created_by":1013,"created_at":"2024-09-19 14:23:11","updated_at":"2024-09-19 14:23:11","pinyin_shortcut":"aTrust1000S1035M","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":25,"key":25,"name":"\u5b89\u5168\u63a5\u5165\u7f51\u5173"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1508,"key":1508,"name":"\u6df1\u4fe1\u670d\u8bbf\u95ee\u63a7\u5236\u7cfb\u7edfaTrust-1000-S1035M"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":7284,"project_id":3493,"product_id":980,"amount":"0","number":2,"cost":"35000","description":"\u9002\u7528\u4e8eaTrust-1000-S1035M","supplier_id":640,"hardware_from":null,"software_from":"2024-09-23","maintenance_from":null,"hardware_to":null,"software_to":"2027-09-23","maintenance_to":null,"total_amount":"0","total_cost":"70000","supplier":{"id":640,"key":640,"name":"\u5317\u4eac\u4e16\u7eaa\u7f51\u6e90\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":980,"name":"\u6df1\u4fe1\u670d\u96f6\u4fe1\u4efb\u8bbf\u95ee\u63a7\u5236\u7cfb\u7edf\u8f6f\u4ef6V2.0","product_type":7,"product_component":41,"product_brand":12,"product_serie":1276,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-09 09:32:41","updated_at":"2024-03-11 13:56:59","pinyin_shortcut":"sxflxrfwkzxtrjV20","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":41,"key":41,"name":"\u5b89\u5168\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1276,"key":1276,"name":"\u6df1\u4fe1\u670d\u96f6\u4fe1\u4efb\u8bbf\u95ee\u63a7\u5236\u7cfb\u7edf\u8f6f\u4ef6V2.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":7285,"project_id":3493,"product_id":981,"amount":"0","number":30,"cost":"250","description":"\u6388\u6743\u4e70\u65ad","supplier_id":640,"hardware_from":null,"software_from":"2024-09-23","maintenance_from":null,"hardware_to":null,"software_to":"2027-09-23","maintenance_to":null,"total_amount":"0","total_cost":"7500","supplier":{"id":640,"key":640,"name":"\u5317\u4eac\u4e16\u7eaa\u7f51\u6e90\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":981,"name":"\u6df1\u4fe1\u670d\u96f6\u4fe1\u4efb\u63a5\u5165\u6388\u6743\u8f6f\u4ef6V2.0","product_type":7,"product_component":41,"product_brand":12,"product_serie":1275,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-09 09:33:19","updated_at":"2024-03-11 13:56:43","pinyin_shortcut":"sxflxrjrsqrjV20","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":41,"key":41,"name":"\u5b89\u5168\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1275,"key":1275,"name":"\u6df1\u4fe1\u670d\u96f6\u4fe1\u4efb\u63a5\u5165\u6388\u6743\u8f6f\u4ef6V2.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":7286,"project_id":3493,"product_id":1196,"amount":"0","number":4,"cost":"275","description":"","supplier_id":640,"hardware_from":"2024-09-23","software_from":null,"maintenance_from":null,"hardware_to":"2027-09-23","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"1100","supplier":{"id":640,"key":640,"name":"\u5317\u4eac\u4e16\u7eaa\u7f51\u6e90\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1196,"name":"\u5343\u5146\u591a\u6a21-850-550m-\u53cc\u7ea4","product_type":4,"product_component":43,"product_brand":12,"product_serie":748,"product_misc":null,"product_qa":null,"pn":"","description":"SFP\u5343\u5146\u591a\u6a21\u5149\u6a21\u5757\uff0c\u901f\u7387\uff1a1.25Gb\/s\uff0c\u6ce2\u957f\uff1a850nm\uff0c\u4f20\u8f93\u8ddd\u79bb\uff1a0.55km\uff0c\u53ccLC\u63a5\u53e3","created_by":1013,"created_at":"2024-01-09 16:10:20","updated_at":"2024-01-09 16:10:20","pinyin_shortcut":"qzdm850550msx","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":748,"key":748,"name":"\u6df1\u4fe1\u670d\u5343\u5146\u591a\u6a21\u5149\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}}],"commentCount":{"object_id":3493,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":727,"project_id":3493,"contact_id":846,"point":"55028.00","paid_point":"55028","contact":{"id":846,"key":846,"name":"\u674e\u4e1c","client_id":141,"supplier_id":null,"client":{"id":141,"key":141,"name":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":127,"project_id":3493,"contact_id":846,"point":"55028.00","day_at":"2024-11-07","description":"","created_at":"2024-11-07 10:34:23"}],"status_display":"\u5df2\u6838\u9500"}],"projectUsedClient":null,"remain_display":284,"progress_remain_display":324,"forecast_remain_display":324,"projectProductTotalAmount":172600,"projectProductAllAmount":true,"projectProductTotalCost":90600,"projectProductAllCost":true,"projectProductTotalNumber":38,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"11\u4e2a\u6708\u524d","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":204,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"7\u4e2a\u6708\u524d","can_view_product":true,"budget_display":"17.26\u4e07","contact_points_status_display":"\u5df2\u6838\u9500"},{"id":3297,"client_id":141,"project_status":5,"project_progress":4,"budget":"500000","profit_pct":"10","bargain_date":"2024-07-31","description":null,"created_by":5300,"created_at":"2023-08-28 09:35:51","updated_at":"2024-06-07 10:30:05","engineer_id":null,"project_title":"\u670d\u52a1\u5668\u7eed\u4fdd-K","collected":"0","status_updated_at":"2024-06-03 17:14:01.862183+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2023-09-11 10:05:25.973112+08","forecast_updated_at":"2024-06-03 17:14:01.862183+08","end_at":"2024-06-03 17:14:01","pinyin_shortcut":"fwqxbK","creator":5364,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":true,"collected_plan":0,"profits":"50000.0000000000000000","remain":"386 days 17:11:34.294088","progress_remain":"653 days 00:20:10.183159","forecast_remain":"386 days 17:11:34.294088","lost_contact_days":"559.828196253137","last_contact":"2023-12-13 14:33:00","last_arrive_days":"559.828196253137","last_arrive":"2023-12-13 14:33:00+08","duration":"280 days 07:38:10.548919","issued_invoices":null,"client":{"id":141,"key":141,"name":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8","logo":null,"client_type":1,"client_class":43,"client_industry":10,"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"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3297,"value":"0.5","key":1015,"name":"\u5434\u660a"},{"project_id":3297,"value":"0.5","key":1017,"name":"\u8f66\u660e\u98de"}],"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{"id":4,"key":4,"name":"\u786e\u8ba4\u65b9\u6848","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u7684\u53cd\u9988\uff0c\u4e0d\u65ad\u4f18\u5316\u89e3\u51b3\u65b9\u6848\uff0c\u76f4\u5230\u5ba2\u6237\u53e3\u5934\u6216\u4e66\u9762\u8ba4\u53ef\u65b9\u6848\u3002 \n\u65b9\u6cd5\uff1a\u4f7f\u7528\u573a\u666f\uff0c\u95ee\u9898\uff0c\u9700\u6c42\uff0c\u4ea7\u54c1\u53ca\u529f\u80fd\u7684\u65b9\u6cd5\u8bb2\u89e3\u65b9\u6848\u3002"},"projectProductTypes":[{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"500000.00","pct":"10","profit":"50000","project_id":3297}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"opportunityFrom":{"id":171,"key":171,"name":"cold call"},"purchaseType":{"id":129,"key":129,"name":"\u7279\u7ea6\u9080\u6807"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5364,"key":5364,"name":"\u738b\u827a\u742e","sex":"F","department_id":1,"avatar":{"id":154,"user_id":5364,"name":"\/files\/cdn\/a57be577deb434\/avatar\/a0b46fdc-d67f-305c-82e5-5b2e01c08e21.png"}},"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"}},"casePoints":{"project_id":3297,"points":"313"},"workLogCount":{"project_id":3297,"count":20},"caseCount":{"project_id":3297,"count":4},"salesTimeCount":{"project_id":3297,"hours":"11.25","times":5},"implementTimeCount":null,"presalesTimeCount":{"project_id":3297,"sum":"53.3986111111111","times":"4"},"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3297,"sum":"480"},"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":3297,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"projectUsedClient":null,"remain_display":386,"progress_remain_display":653,"forecast_remain_display":386,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":500000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"1\u5e74\u524d","project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_invoice":false,"can_payment":false,"duration_display":280,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"1\u5e74\u524d","can_view_product":true,"budget_display":"50\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e"},{"id":3375,"client_id":141,"project_status":3,"project_progress":9,"budget":"175000","profit_pct":"2.05","bargain_date":"2023-11-30","description":"","created_by":5364,"created_at":"2023-11-28 14:02:17","updated_at":"2024-05-10 14:27:16","engineer_id":null,"project_title":"\u6d6a\u6f6e\u5b58\u50a8\u78c1\u76d8\u9635\u5217","collected":"175000","status_updated_at":"2023-12-07 14:29:20.222624+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2023-11-30 20:33:09.686968+08","forecast_updated_at":"2023-12-07 14:31:01.809681+08","end_at":"2024-02-19 09:48:12","pinyin_shortcut":"lccccpzl","creator":5364,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":132,"is_sales_order_ready":true,"collected_plan":175000,"profits":"3587.500000000000000000","remain":"565 days 19:56:15.933647","progress_remain":"572 days 13:52:26.469303","forecast_remain":"565 days 19:54:34.34659","lost_contact_days":"531.684446253137","last_contact":"2024-01-10 18:00:00","last_arrive_days":null,"last_arrive":null,"duration":"82 days 19:45:55.102812","issued_invoices":"175000.00","client":{"id":141,"key":141,"name":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8","logo":null,"client_type":1,"client_class":43,"client_industry":10,"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"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"175000.00","pct":"2.05","profit":"3587.5","project_id":3375}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5364,"key":5364,"name":"\u738b\u827a\u742e","sex":"F","department_id":1,"avatar":{"id":154,"user_id":5364,"name":"\/files\/cdn\/a57be577deb434\/avatar\/a0b46fdc-d67f-305c-82e5-5b2e01c08e21.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5364,"key":5364,"name":"\u738b\u827a\u742e","sex":"F","department_id":1,"avatar":{"id":154,"user_id":5364,"name":"\/files\/cdn\/a57be577deb434\/avatar\/a0b46fdc-d67f-305c-82e5-5b2e01c08e21.png"}},"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"}},"casePoints":null,"workLogCount":{"project_id":3375,"count":13},"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":2993,"from_project":3375,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WYC-2023113001","is_settle":true,"is_deliver":true,"is_outbound":true,"contractScans":[{"id":23556,"object_type":105,"object_id":2993,"attachment_id":16429,"attachment":{"id":16429,"key":16429,"name":"e0ae577a-938e-3068-946e-996b667238c6","extension":"pdf","path":"\/v2\/attachment\/preview\/J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L\/e0ae577a-938e-3068-946e-996b667238c6\/2023_12_08_10_02_10.pdf","orig_name":"2023_12_08_10_02_10.pdf"}}],"receiptScans":[{"id":22898,"object_type":106,"object_id":2993,"attachment_id":16495,"attachment":{"id":16495,"key":16495,"name":"ea550987-10bc-3002-beb2-ee88523be156","extension":"pdf","path":"\/v2\/attachment\/preview\/J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L\/ea550987-10bc-3002-beb2-ee88523be156\/20231211151028392.pdf","orig_name":"20231211151028392.pdf"}}],"verifyScans":[{"id":22899,"object_type":107,"object_id":2993,"attachment_id":17033,"attachment":{"id":17033,"key":17033,"name":"54a754e8-a1d6-3b9d-a309-9e60155269f5","extension":"pdf","path":"\/v2\/attachment\/preview\/J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L\/54a754e8-a1d6-3b9d-a309-9e60155269f5\/2024_01_05_14_32_57.pdf","orig_name":"2024_01_05_14_32_57.pdf"}}],"salesContractPayments":[{"id":1740,"key":1740,"contract_id":2993,"value":"131250","created_by":1014,"created_at":"2023-12-27 10:54:47","collected_date":"2023-12-27","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":75},{"id":1776,"key":1776,"contract_id":2993,"value":"43750","created_by":1014,"created_at":"2024-02-19 09:48:12","collected_date":"2024-02-05","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":25}],"salesContractInvoices":[{"id":1552,"key":1552,"contract_id":2993,"value":"175000.00","attachment_id":null,"from_date":"2023-12-07","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1445,"key":1445,"contract_id":2993,"name":"2023-12-15","value":"131250","overdue_days":12,"pct":75,"collect_status":"\u5df2\u5b8c\u6210"},{"id":1446,"key":1446,"contract_id":2993,"name":"2024-01-10","value":"43750","overdue_days":26,"pct":25,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[{"id":1141,"contract_id":2993,"supplier_id":564,"purchase_id":3003,"supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3003,"key":3003,"serial_no":"TSKJ20231212-HYF-001"}}],"payment_collection_remind_ahead_display":"\u4e0d\u63d0\u9192"},"projectRemindReceivers":[],"projectProductRels":[{"id":2845,"project_id":3375,"product_id":1125,"amount":"175000","number":1,"cost":"166250","description":"\u6d6a\u6f6eAS2600G2\uff0812\uff09 - 64GB\uff0c\u53cc\u63a7, \u6807\u914d64GB\u7f13\u5b58\uff1b\u6807\u914dBBU+Flash\uff1b\u6807\u914d\u672c\u5730\u590d\u5236\uff08\u5feb\u7167\u3001\u5377\u955c\u50cf\u3001\u5377\u514b\u9686\u3001\u5377\u5907\u4efd\u3001\u8fc1\u79fb\uff09\u3001\u81ea\u7cbe\u7b80\u3001QoS\u3001DRAID\u529f\u80fd\uff1b\u6807\u914d8\u4e2a1Gb iSCSI\u4e3b\u673a\u63a5\u53e3\uff0c\u53ef\u6269\u5c55FC\u3001\u4e07\u5146\u3001\u5343\u5146\u3001FCoE\u4e3b\u673a\u63a5\u53e3 14T*12 \/\u667a\u80fd\u6587\u4ef6\u670d\u52a1\u8f6f\u4ef6(NAS)\u542b\u4e09\u5e74\u8d28\u4fdd\u4e0e\u534f\u52a9\u5b89\u88c5\u90e8\u7f72\u670d\u52a1","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"175000","total_cost":"166250","supplier":null,"product":{"id":1125,"name":"AS2600G2","product_type":3,"product_component":14,"product_brand":24,"product_serie":170,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-12-07 14:34:21","updated_at":"2024-01-16 14:38:47","pinyin_shortcut":"AS2600G2","product_unit":1,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":14,"key":14,"name":"\u5b58\u50a8\u4e3b\u673a"},"productBrand":{"id":24,"key":24,"name":"\u6d6a\u6f6e"},"productSerie":{"id":170,"key":170,"name":"AS2600G2\u5b58\u50a8"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}}],"commentCount":{"object_id":3375,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"projectUsedClient":null,"remain_display":565,"progress_remain_display":572,"forecast_remain_display":565,"projectProductTotalAmount":175000,"projectProductAllAmount":true,"projectProductTotalCost":166250,"projectProductAllCost":true,"projectProductTotalNumber":1,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":82,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"1\u5e74\u524d","can_view_product":true,"budget_display":"17.5\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e"},{"id":110,"client_id":141,"project_status":5,"project_progress":4,"budget":"0","profit_pct":"0","bargain_date":"2017-06-30","description":"\u7f51\u7edc\u6539\u9020 \u601d\u79d1ASA5525\u5347\u7ea7\uff08\u6216PA\uff09","created_by":1007,"created_at":"2017-03-17 16:56:22","updated_at":"2017-09-20 17:26:47","engineer_id":1017,"project_title":"\u601d\u79d1ASA5525\u5347\u7ea7","collected":"0","status_updated_at":"2017-06-12 12:14:24.56855+08","success_rate":10,"comment":"\u7f51\u7edc\u6539\u9020 \u601d\u79d1ASA5525\u5347\u7ea7\uff08\u6216PA\uff09\r\n","contract_type":1,"progress_updated_at":"2017-09-20 17:26:47.11548+08","forecast_updated_at":"2017-09-20 17:26:47.11548+08","end_at":"2017-09-20 17:26:47","pinyin_shortcut":"skASA5525sj","creator":1007,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":0,"profits":"0.00000000000000000000","remain":"2934 days 22:11:11.587721","progress_remain":"2834 days 16:58:49.040791","forecast_remain":"2834 days 16:58:49.040791","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"187 days 00:30:24.982497","issued_invoices":null,"client":{"id":141,"key":141,"name":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8","logo":null,"client_type":1,"client_class":43,"client_industry":10,"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"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":110,"value":"1","key":1017,"name":"\u8f66\u660e\u98de"}],"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{"id":4,"key":4,"name":"\u786e\u8ba4\u65b9\u6848","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u7684\u53cd\u9988\uff0c\u4e0d\u65ad\u4f18\u5316\u89e3\u51b3\u65b9\u6848\uff0c\u76f4\u5230\u5ba2\u6237\u53e3\u5934\u6216\u4e66\u9762\u8ba4\u53ef\u65b9\u6848\u3002 \n\u65b9\u6cd5\uff1a\u4f7f\u7528\u573a\u666f\uff0c\u95ee\u9898\uff0c\u9700\u6c42\uff0c\u4ea7\u54c1\u53ca\u529f\u80fd\u7684\u65b9\u6cd5\u8bb2\u89e3\u65b9\u6848\u3002"},"projectProductTypes":[{"id":85,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"0","pct":"0","profit":"0","project_id":110}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":null,"createdBy":{"id":1007,"key":1007,"name":"\u5b59\u6167","sex":"F","department_id":9,"avatar":{"id":7,"user_id":1007,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1007.jpg"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"projectCreator":{"id":1007,"key":1007,"name":"\u5b59\u6167","sex":"F","department_id":9,"avatar":{"id":7,"user_id":1007,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1007.jpg"}},"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":null,"unreadComments":null,"fromContact":null,"projectContactPoints":[],"projectUsedClient":null,"remain_display":2934,"progress_remain_display":2834,"forecast_remain_display":2834,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_invoice":false,"can_payment":false,"duration_display":187,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"0","contact_points_status_display":"\u672a\u8bbe\u7f6e"}],"pagenation":{"totalcount":6,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-06-25 10:25:36') RETURNING "id" |
| 10:25:36.240 | 2.4 ms | yii\db\Command::query | SELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(left_at - arrived_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_implement_records" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=2) AND ("c"."project_id" IN (3739, 3692, 3493, 3297, 3375, 110)) GROUP BY "c"."project_id" |
| 10:25:36.247 | 2.3 ms | yii\db\Command::query | SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (3, 2)) AND ("project_id" IN (3739, 3692, 3493, 3297, 3375, 110)) GROUP BY "project_id" |
| 10:25:36.508 | 2.1 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 10:25:36.217 | 2.0 ms | 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 (5364, 1007, 5300)) |
| 10:25:36.602 | 1.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((846, 3493)) |
| 10:25:36.538 | 1.6 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (12, 3, 24) |
| 10:25:36.237 | 1.6 ms | yii\db\Command::query | SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (3739, 3692, 3493, 3297, 3375, 110) GROUP BY "project_id" |
| 10:25:36.118 | 1.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016 |
| 10:25:36.545 | 1.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (1, 2, 3) |
| 10:25:36.181 | 1.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id"=1 |
| 10:25:36.121 | 1.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='141') AND ("deleted"=FALSE) |
| 10:25:36.182 | 1.0 ms | yii\db\Command::query | SELECT "project_id", "contribution" AS "value", "engineer_id" AS "key", "u"."name" FROM "a57be577deb434"."tbl_project_architects" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON engineer_id = u.id WHERE "a57be577deb434"."tbl_project_architects"."project_id" IN (3739, 3692, 3493, 3297, 3375, 110) ORDER BY "contribution" DESC, "engineer_id" |
| 10:25:36.236 | 0.7 ms | yii\db\Command::query | SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("project_id" IN (3739, 3692, 3493, 3297, 3375, 110)) GROUP BY "project_id" |
| 10:25:36.239 | 0.7 ms | yii\db\Command::query | SELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=1) AND (("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL)) AND ("project_id" IN (3739, 3692, 3493, 3297, 3375, 110)) GROUP BY "project_id" |
| 10:25:36.600 | 0.7 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id"=846 |
| 10:25:36.212 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3739, 3692, 3493, 3297, 3375, 110) |
| 10:25:36.213 | 0.6 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (101, 107, 1, 142, 205, 204, 10, 5, 153, 136, 171, 226, 164, 184, 189, 197, 199, 2100000000, 181, 2, 129, 172, 349, 359, 377, 232)) ORDER BY "sort" |
| 10:25:36.532 | 0.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (4, 5, 7, 3) |
| 10:25:36.246 | 0.5 ms | yii\db\Command::query | SELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=2) AND ("project_id" IN (3739, 3692, 3493, 3297, 3375, 110)) GROUP BY "project_id" |
| 10:25:36.178 | 0.5 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300) |
| 10:25:36.221 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=141 |
| 10:25:36.214 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3739, 3692, 3493, 3297, 3375, 110) |
| 10:25:36.177 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=141 |
| 10:25:36.180 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=43 |
| 10:25:36.205 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (3, 5) |
| 10:25:36.507 | 0.4 ms | yii\db\Command::query | SELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (3739, 3692, 3493, 3297, 3375, 110) |
| 10:25:36.215 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3739, 3692, 3493, 3297, 3375, 110) |
| 10:25:36.179 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id"=1 |
| 10:25:36.215 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (101, 107, 1, 142, 205, 204, 10, 5, 153, 136, 171, 226, 164, 184, 189, 197, 199, 2100000000, 181, 2, 129, 172, 349, 359, 377, 232)) ORDER BY "sort" |
| 10:25:36.178 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300 |
| 10:25:36.220 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (1, 9) |
| 10:25:36.216 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (101, 107, 1, 142, 205, 204, 10, 5, 153, 136, 171, 226, 164, 184, 189, 197, 199, 2100000000, 181, 2, 129, 172, 349, 359, 377, 232)) ORDER BY "sort" |
| 10:25:36.205 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (9, 4) |
| 10:25:36.180 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id"=10 |
| 10:25:36.508 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 10:25:36.521 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (564, 640) |
| 10:25:36.601 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=141 |
| 10:25:36.216 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5364, 1007) |
| 10:25:36.221 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5364, 1007) |
| 10:25:36.221 | 0.2 ms | 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 (5364, 1007, 5300)) |
| 10:25:36.222 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300 |
| 10:25:36.222 | 0.2 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300) |