68c3d93f49ee5: POST https://beta.jinchangxiao.com/v2/project/list at 2025-09-12 04:26:39 pm by 114.246.237.213
Database Queries
总计63条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 16:26:39.306 | 2.6 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='aHkemdL-FzzGDDN3FUg-tUfVIXoO8gyc' |
| 16:26:39.309 | 1.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:26:39.314 | 19.7 ms | SELECT | 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 (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("c"."sales_rep"='5300') GROUP BY "p"."id" ORDER BY "p"."updated_at" DESC) "c" |
| 16:26:39.334 | 22.1 ms | SELECT | 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 (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("c"."sales_rep"='5300') GROUP BY "p"."id" ORDER BY "p"."updated_at" DESC LIMIT 10 |
| 16:26:39.358 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2166, 2146, 3379, 1181, 497, 3370, 97, 287, 3284) |
| 16:26:39.358 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300 |
| 16:26:39.359 | 0.3 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300) |
| 16:26:39.359 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id" IN (5, 1, 6) |
| 16:26:39.360 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (43, 1, 80) |
| 16:26:39.360 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id" IN (13, 17, 5, 57, 4, 16, 14) |
| 16:26:39.361 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2) |
| 16:26:39.361 | 1.0 ms | SELECT | 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 (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580) ORDER BY "contribution" DESC, "engineer_id" |
| 16:26:39.362 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (3, 2, 5) |
| 16:26:39.363 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (4, 5, 9, 3) |
| 16:26:39.363 | 0.7 ms | SELECT | 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 (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580) |
| 16:26:39.364 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580) |
| 16:26:39.365 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (164, 142, 1, 2, 215, 5, 226, 184, 189, 197, 199, 136, 172, 229, 349, 377, 181, 369, 356, 352)) ORDER BY "sort" |
| 16:26:39.365 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580) |
| 16:26:39.366 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (164, 142, 1, 2, 215, 5, 226, 184, 189, 197, 199, 136, 172, 229, 349, 377, 181, 369, 356, 352)) ORDER BY "sort" |
| 16:26:39.366 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580) |
| 16:26:39.367 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (164, 142, 1, 2, 215, 5, 226, 184, 189, 197, 199, 136, 172, 229, 349, 377, 181, 369, 356, 352)) ORDER BY "sort" |
| 16:26:39.367 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300 |
| 16:26:39.368 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300) |
| 16:26:39.368 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
| 16:26:39.368 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5413) |
| 16:26:39.369 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5413, 5300)) |
| 16:26:39.369 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2166, 2146, 3379, 1181, 497, 3370, 97, 287, 3284) |
| 16:26:39.370 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300 |
| 16:26:39.370 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300) |
| 16:26:39.370 | 5.4 ms | SELECT | 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 (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580) GROUP BY "c"."project_id" |
| 16:26:39.376 | 0.5 ms | SELECT | SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("project_id" IN (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580)) GROUP BY "project_id" |
| 16:26:39.377 | 1.0 ms | SELECT | SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580) GROUP BY "project_id" |
| 16:26:39.378 | 0.5 ms | SELECT | 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 (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580)) GROUP BY "project_id" |
| 16:26:39.379 | 5.5 ms | SELECT | 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 (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580)) GROUP BY "c"."project_id" |
| 16:26:39.384 | 2.3 ms | SELECT | 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 (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580)) GROUP BY "c"."project_id" |
| 16:26:39.387 | 0.4 ms | SELECT | 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 (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580)) GROUP BY "project_id" |
| 16:26:39.387 | 1.5 ms | SELECT | SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580)) GROUP BY "project_id" |
| 16:26:39.389 | 0.8 ms | SELECT | SELECT "id", "from_project", "payment_collection_remind_ahead", "serial_no", "is_settle", "is_deliver", "is_outbound", "erp_settle_amount", "erp_un_settle_amount", "including_tax", "amount" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580) |
| 16:26:39.390 | 2.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id"=4135) |
| 16:26:39.393 | 1.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id"=4135) |
| 16:26:39.394 | 1.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id"=4135) |
| 16:26:39.396 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE ("status"=2) AND ("sales_contract_id"=4135) ORDER BY "id" DESC |
| 16:26:39.397 | 2.3 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) )) "sub") "r" WHERE "contract_id"=4135 ORDER BY "id" DESC |
| 16:26:39.400 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4135 ORDER BY "id" |
| 16:26:39.400 | 0.5 ms | SELECT | 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"=4135 ORDER BY "remind_date" |
| 16:26:39.401 | 0.3 ms | SELECT | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4135 |
| 16:26:39.401 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5087, 5300) |
| 16:26:39.402 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5087, 5300)) |
| 16:26:39.402 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id"=4135 |
| 16:26:39.402 | 0.3 ms | SELECT | SELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580) |
| 16:26:39.403 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1005) |
| 16:26:39.403 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1005)) |
| 16:26:39.404 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580) |
| 16:26:39.404 | 20.3 ms | SELECT | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580)) GROUP BY "object_id" |
| 16:26:39.425 | 17.2 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=1) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580)) GROUP BY "object_id" |
| 16:26:39.442 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580) |
| 16:26:39.443 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580)) |
| 16:26:39.444 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id" IN (3955, 3946, 3944, 3952, 3942, 3943, 3888, 3778, 3486, 3580) |
| 16:26:39.445 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id" IN (115, 129, 142, 186) |
| 16:26:39.445 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "project_used_client_id", "remind_date", "amount", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id" IN (115, 129, 142, 186) |
| 16:26:39.445 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id" IN (115, 129, 142, 186) |
| 16:26:39.446 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id" IN (115, 129, 142, 186) |
| 16:26:39.448 | 2.7 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 0, 266, 'v2/project/list', '{"access_token":"aHkemdL-FzzGDDN3FUg-tUfVIXoO8gyc","ProjectSearch":{"projectProductTypes":"","created_by":"5300","salesForecast":"","project_status":"","project_progress":"","engineer_id":""},"device_type":"0","version_code":"266","page":"1","token":"f3d9b097f06bc19cc6bc39b61fd45bf4","posttime":"1757665599","pagesize":"10"}', '{"code":200,"data":{"list":[{"id":3955,"client_id":2166,"project_status":3,"project_progress":4,"budget":"129992","profit_pct":"16.58","bargain_date":"2025-09-10","description":null,"created_by":5300,"created_at":"2025-08-25 16:25:50","updated_at":"2025-09-10 16:53:25","engineer_id":null,"project_title":"\u6df1\u4fe1\u670d\u96f6\u4fe1\u4efb\u65b0\u8d2d-G-2025","collected":"0","status_updated_at":"2025-09-10 16:53:25.881047+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-08-25 16:25:50.449572+08","forecast_updated_at":"2025-08-25 16:25:50.449572+08","end_at":"","pinyin_shortcut":"sxflxrxgG2025","creator":5300,"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,"change_status_to":null,"is_verify":false,"profits":"21552.673600000000000000","remain":"1 day 23:33:13.4551","progress_remain":"18 days 00:00:48.886575","forecast_remain":"18 days 00:00:48.886575","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"18 days 00:00:48.886575","issued_invoices":null,"client":{"id":2166,"key":2166,"name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8","logo":null,"client_type":1,"client_class":43,"client_industry":5,"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":5,"key":5,"name":"\u5236\u9020"}},"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":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":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"80000","pct":"10","profit":"8000","project_id":3955},{"id":8,"product_type_id":8,"key":8,"name":"\u4e91\u684c\u9762","budget":"24556","pct":"14.46","profit":"3550.79","project_id":3955},{"id":88,"product_type_id":88,"key":88,"name":"\u79c1\u6709\u4e91","budget":"25436","pct":"39.31","profit":"10000","project_id":3955}],"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":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":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4135,"from_project":3955,"payment_collection_remind_ahead":"1 day","serial_no":"2025-09-10-001","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"0","erp_un_settle_amount":"129992","including_tax":true,"amount":"129992","contractScans":[],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8899,"user_id":1001,"key":1001,"contract_id":4135,"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"}}},{"id":8900,"user_id":5087,"key":5087,"contract_id":4135,"user":{"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"}}},{"id":8901,"user_id":5300,"key":5300,"contract_id":4135,"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"}}}],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"1\u5929","invoiced":0},"projectRemindReceivers":[{"id":1772,"user_id":1001,"key":1001,"project_id":3955,"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"}}},{"id":1773,"user_id":1005,"key":1005,"project_id":3955,"user":{"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"}}}],"projectProductRels":[],"commentCount":{"object_id":3955,"comment":4},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1580,"serial_no":"XSDD-20250910-00003","from_date":null,"wrote_date":"2025-09-10","handler":5300,"client_id":2166,"purchase_contract_id":null,"project_id":3955,"sales_contract_id":4135,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-09-10 16:53:38","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"129992","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"5087\",\"5300\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":true,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-09-10 16:53:26","updated_at":"2025-09-10 16:53:38"},"projectUsedClient":{"id":186,"project_id":3955,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"remain_display":1,"progress_remain_display":18,"forecast_remain_display":18,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":129992,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","can_invoice":true,"can_payment":true,"duration_display":18,"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":"13\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":"129992","un_invoiced":129992},{"id":3946,"client_id":2146,"project_status":2,"project_progress":4,"budget":"170000","profit_pct":"10","bargain_date":"2025-11-30","description":null,"created_by":5300,"created_at":"2025-08-13 16:17:13","updated_at":"2025-09-01 10:00:16","engineer_id":null,"project_title":"\u601d\u79d1\u786c\u4ef6\u7ef4\u4fdd-k-2025","collected":"0","status_updated_at":"2025-08-13 16:17:13.645693+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-08-13 16:17:13.645693+08","forecast_updated_at":"2025-08-13 16:17:13.645693+08","end_at":"","pinyin_shortcut":"skyjwbk2025","creator":5300,"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,"change_status_to":null,"is_verify":false,"profits":"17000.0000000000000000","remain":"30 days 00:09:25.690454","progress_remain":"30 days 00:09:25.690454","forecast_remain":"30 days 00:09:25.690454","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"30 days 00:09:25.690454","issued_invoices":null,"client":{"id":2146,"key":2146,"name":"\u8054\u60f3\u51cc\u62d3\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":80,"client_industry":4,"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":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"clientIndustry":{"id":4,"key":4,"name":"\u901a\u4fe1"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"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":4,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"170000","pct":"10","profit":"17000","project_id":3946}],"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":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[{"id":1729,"user_id":1001,"key":1001,"project_id":3946,"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"}}},{"id":1730,"user_id":1005,"key":1005,"project_id":3946,"user":{"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"}}}],"projectProductRels":[],"commentCount":{"object_id":3946,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"remain_display":30,"progress_remain_display":30,"forecast_remain_display":30,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":170000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_invoice":false,"can_payment":false,"duration_display":30,"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":"17\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":0,"un_invoiced":0},{"id":3944,"client_id":3379,"project_status":2,"project_progress":5,"budget":"290000","profit_pct":"14.83","bargain_date":"2025-11-30","description":null,"created_by":5300,"created_at":"2025-08-10 17:23:42","updated_at":"2025-09-01 09:58:29","engineer_id":null,"project_title":"\u673a\u623f\u642c\u8fc1+\u786c\u4ef6\u65b0\u8d2d-G-2025","collected":"0","status_updated_at":"2025-08-10 17:23:42.356297+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-08-10 17:23:42.356297+08","forecast_updated_at":"2025-08-10 17:23:42.356297+08","end_at":"","pinyin_shortcut":"jfbqyjxgG2025","creator":5300,"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,"change_status_to":null,"is_verify":false,"profits":"43007.000000000000000000","remain":"32 days 23:02:56.97985","progress_remain":"32 days 23:02:56.97985","forecast_remain":"32 days 23:02:56.97985","lost_contact_days":"14.7733719461458","last_contact":"2025-08-28 21:53:00","last_arrive_days":"14.7733719461458","last_arrive":"2025-08-28 21:53:00+08","duration":"32 days 23:02:56.97985","issued_invoices":null,"client":{"id":3379,"key":3379,"name":"\u591a\u70b9\uff08\u6df1\u5733\uff09\u6570\u5b57\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":17,"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":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":17,"key":17,"name":"\u96f6\u552e"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3944,"value":"1","key":1022,"name":"\u5f90\u7855"}],"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7","description":"\u5b9a\u4e49\uff1a1.\u62a5\u4ef7\u6709\u6548\u671f 2.\u6838\u7b97\u5229\u6da6\u7387 3. \u4ea4\u8d27\u65b9\u5f0f\u53ca\u65f6\u95f4 4.\u9a8c\u6536\u65b9\u5f0f 5.\u6536\u6b3e\u65b9\u5f0f 6.\u8fdd\u7ea6\u6761\u6b3e \n\u65b9\u6cd5\uff1a\u7528\u516c\u53f8\u6807\u51c6\u7684\u62a5\u4ef7\u5355\u6837\u5f0f\u5411\u5ba2\u6237\u63d0\u4f9b\u62a5\u4ef7\u3002"},"projectProductTypes":[{"id":4,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"200000","pct":"6.5","profit":"13000","project_id":3944},{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"30000","pct":"80","profit":"24000","project_id":3944},{"id":14,"product_type_id":14,"key":14,"name":"UPS","budget":"10000","pct":"10","profit":"1000","project_id":3944},{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"50000","pct":"10","profit":"5000","project_id":3944}],"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":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":3944,"count":2},"caseCount":null,"salesTimeCount":{"project_id":3944,"hours":"6.91666666666667","times":2},"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[{"id":1715,"user_id":1001,"key":1001,"project_id":3944,"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"}}},{"id":1716,"user_id":1005,"key":1005,"project_id":3944,"user":{"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"}}}],"projectProductRels":[],"commentCount":{"object_id":3944,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"remain_display":32,"progress_remain_display":32,"forecast_remain_display":32,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":290000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"14\u5929\u524d","project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_invoice":false,"can_payment":false,"duration_display":32,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"14\u5929\u524d","can_view_product":true,"budget_display":"29\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":0,"un_invoiced":0},{"id":3952,"client_id":1181,"project_status":2,"project_progress":5,"budget":"120000","profit_pct":"20","bargain_date":"2025-10-31","description":null,"created_by":5300,"created_at":"2025-08-21 17:15:43","updated_at":"2025-09-01 09:58:06","engineer_id":null,"project_title":"VM300\u7ef4\u4fdd-G-2025","collected":"0","status_updated_at":"2025-08-25 10:26:14.786253+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-08-25 10:26:14.786253+08","forecast_updated_at":"2025-08-25 10:26:14.786253+08","end_at":"","pinyin_shortcut":"VM300wbG2025","creator":5300,"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,"change_status_to":null,"is_verify":false,"profits":"24000.0000000000000000","remain":"18 days 06:00:24.549894","progress_remain":"18 days 06:00:24.549894","forecast_remain":"18 days 06:00:24.549894","lost_contact_days":"13.2685108350347","last_contact":"2025-08-30 10:00:00","last_arrive_days":"22.0067052794792","last_arrive":"2025-08-21 16:17:00+08","duration":"21 days 23:10:56.071688","issued_invoices":null,"client":{"id":1181,"key":1181,"name":"\u5148\u6b63\u8fbe\u751f\u7269\u79d1\u6280(\u4e2d\u56fd);\u5148\u6b63\u8fbe(\u4e2d\u56fd)\u6295\u8d44\u6709\u9650\u516c\u53f8;\u5317\u4eac\u65ed\u65e5\u4f73\u4e1a\u7f51\u7edc\u6709\u9650\u516c\u53f8\uff08CAE\/EDA\/BIO\uff09","logo":null,"client_type":5,"client_class":1,"client_industry":57,"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":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237","notice_days":10,"color":"#E89F0E"},"clientIndustry":{"id":57,"key":57,"name":"EDA\/CAE"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7","description":"\u5b9a\u4e49\uff1a1.\u62a5\u4ef7\u6709\u6548\u671f 2.\u6838\u7b97\u5229\u6da6\u7387 3. \u4ea4\u8d27\u65b9\u5f0f\u53ca\u65f6\u95f4 4.\u9a8c\u6536\u65b9\u5f0f 5.\u6536\u6b3e\u65b9\u5f0f 6.\u8fdd\u7ea6\u6761\u6b3e \n\u65b9\u6cd5\uff1a\u7528\u516c\u53f8\u6807\u51c6\u7684\u62a5\u4ef7\u5355\u6837\u5f0f\u5411\u5ba2\u6237\u63d0\u4f9b\u62a5\u4ef7\u3002"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"120000","pct":"20","profit":"24000","project_id":3952}],"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":3952,"count":2},"caseCount":null,"salesTimeCount":{"project_id":3952,"hours":"0.783333333333333","times":1},"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[{"id":1745,"user_id":1001,"key":1001,"project_id":3952,"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"}}},{"id":1746,"user_id":1005,"key":1005,"project_id":3952,"user":{"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"}}}],"projectProductRels":[],"commentCount":{"object_id":3952,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"remain_display":18,"progress_remain_display":18,"forecast_remain_display":18,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":120000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"22\u5929\u524d","project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_invoice":false,"can_payment":false,"duration_display":21,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"13\u5929\u524d","can_view_product":true,"budget_display":"12\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":0,"un_invoiced":0},{"id":3942,"client_id":497,"project_status":2,"project_progress":9,"budget":"49500","profit_pct":"80","bargain_date":"2025-10-31","description":null,"created_by":5300,"created_at":"2025-08-10 17:15:04","updated_at":"2025-09-01 09:52:54","engineer_id":null,"project_title":"\u865a\u62df\u5316\u8fd0\u7ef4-2025","collected":"0","status_updated_at":"2025-08-18 10:20:48.635928+08","success_rate":null,"comment":"","contract_type":2,"progress_updated_at":"2025-08-18 10:20:48.635928+08","forecast_updated_at":"2025-08-18 10:20:48.635928+08","end_at":"","pinyin_shortcut":"xnhyw2025","creator":5300,"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,"change_status_to":null,"is_verify":false,"profits":"39600.0000000000000000","remain":"25 days 06:05:50.700219","progress_remain":"25 days 06:05:50.700219","forecast_remain":"25 days 06:05:50.700219","lost_contact_days":"13.1851775017014","last_contact":"2025-08-30 12:00:00","last_arrive_days":null,"last_arrive":null,"duration":"32 days 23:11:35.251948","issued_invoices":null,"client":{"id":497,"key":497,"name":"\u5317\u4eac\u7ea2\u661f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":null,"client_type":1,"client_class":1,"client_industry":5,"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":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237","notice_days":10,"color":"#E89F0E"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"usedClient":null,"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[],"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"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":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"49500","pct":"80","profit":"39600","project_id":3942}],"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":3942,"count":2},"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[{"id":1711,"user_id":1001,"key":1001,"project_id":3942,"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"}}},{"id":1712,"user_id":1005,"key":1005,"project_id":3942,"user":{"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"}}}],"projectProductRels":[],"commentCount":{"object_id":3942,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"remain_display":25,"progress_remain_display":25,"forecast_remain_display":25,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":49500,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_invoice":false,"can_payment":false,"duration_display":32,"contract_type_display":"\u8fd0\u7ef4\u670d\u52a1","can_change_status":true,"is_admin":true,"lost_contact_days_display":"13\u5929\u524d","can_view_product":true,"budget_display":"4.95\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":0,"un_invoiced":0},{"id":3943,"client_id":497,"project_status":2,"project_progress":9,"budget":"65000","profit_pct":"43.07","bargain_date":"2025-09-30","description":null,"created_by":5300,"created_at":"2025-08-10 17:16:52","updated_at":"2025-09-01 09:52:24","engineer_id":null,"project_title":"PA\u7eed\u4fdd-K-2025","collected":"0","status_updated_at":"2025-08-18 10:19:57.924694+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-08-18 10:19:57.924694+08","forecast_updated_at":"2025-08-18 10:19:57.924694+08","end_at":"","pinyin_shortcut":"PAxbK2025","creator":5300,"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,"change_status_to":null,"is_verify":false,"profits":"27995.500000000000000000","remain":"25 days 06:06:41.411453","progress_remain":"25 days 06:06:41.411453","forecast_remain":"25 days 06:06:41.411453","lost_contact_days":"23.2157330572569","last_contact":"2025-08-20 11:16:00","last_arrive_days":"23.2157330572569","last_arrive":"2025-08-20 11:16:00+08","duration":"32 days 23:09:46.658524","issued_invoices":null,"client":{"id":497,"key":497,"name":"\u5317\u4eac\u7ea2\u661f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":null,"client_type":1,"client_class":1,"client_industry":5,"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":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237","notice_days":10,"color":"#E89F0E"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"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":"65000","pct":"43.07","profit":"28000","project_id":3943}],"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":3943,"count":1},"caseCount":null,"salesTimeCount":{"project_id":3943,"hours":"0.9","times":1},"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[{"id":1713,"user_id":1001,"key":1001,"project_id":3943,"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"}}},{"id":1714,"user_id":1005,"key":1005,"project_id":3943,"user":{"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"}}}],"projectProductRels":[],"commentCount":{"object_id":3943,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"remain_display":25,"progress_remain_display":25,"forecast_remain_display":25,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":65000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"23\u5929\u524d","project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_invoice":false,"can_payment":false,"duration_display":32,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"23\u5929\u524d","can_view_product":true,"budget_display":"6.5\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":0,"un_invoiced":0},{"id":3888,"client_id":3370,"project_status":2,"project_progress":9,"budget":"200000","profit_pct":"7","bargain_date":"2025-09-30","description":null,"created_by":5300,"created_at":"2025-06-10 13:43:05","updated_at":"2025-09-01 09:51:30","engineer_id":null,"project_title":"\u8054\u60f3\u670d\u52a1\u5668\u65b0\u8d2d-K-2025","collected":"0","status_updated_at":"2025-09-01 09:50:14.405276+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-09-01 09:50:14.405276+08","forecast_updated_at":"2025-09-01 09:50:14.405276+08","end_at":"","pinyin_shortcut":"lxfwqxgK2025","creator":5300,"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,"change_status_to":null,"is_verify":false,"profits":"14000.0000000000000000","remain":"11 days 06:36:24.930871","progress_remain":"11 days 06:36:24.930871","forecast_remain":"11 days 06:36:24.930871","lost_contact_days":"21.9351775017014","last_contact":"2025-08-21 18:00:00","last_arrive_days":null,"last_arrive":null,"duration":"94 days 02:43:33.684664","issued_invoices":null,"client":{"id":3370,"key":3370,"name":"\u4e2d\u5173\u6751\u79d1\u5b66\u57ce\u57ce\u5e02\u5927\u8111\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13,"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":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3888,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"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":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"200000","pct":"7","profit":"0","project_id":3888}],"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":3888,"count":2},"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[{"id":1720,"user_id":1001,"key":1001,"project_id":3888,"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":[],"commentCount":{"object_id":3888,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":{"id":142,"project_id":3888,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"remain_display":11,"progress_remain_display":11,"forecast_remain_display":11,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":200000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_invoice":false,"can_payment":false,"duration_display":94,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"21\u5929\u524d","can_view_product":true,"budget_display":"20\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":0,"un_invoiced":0},{"id":3778,"client_id":97,"project_status":2,"project_progress":9,"budget":"550000","profit_pct":"15","bargain_date":"2025-08-31","description":null,"created_by":5300,"created_at":"2025-02-17 11:25:43","updated_at":"2025-09-01 09:49:56","engineer_id":null,"project_title":"\u670d\u52a1\u5668\u5b58\u50a8\u865a\u62df\u5316\u65b0\u8d2d-K-2025","collected":"0","status_updated_at":"2025-08-18 10:15:00.786909+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-08-18 10:15:00.786909+08","forecast_updated_at":"2025-08-18 10:15:00.786909+08","end_at":"","pinyin_shortcut":"fwqccxnhxgK2025","creator":5300,"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,"change_status_to":null,"is_verify":false,"profits":"82500.0000000000000000","remain":"25 days 06:11:38.549238","progress_remain":"25 days 06:11:38.549238","forecast_remain":"25 days 06:11:38.549238","lost_contact_days":"16.0803163905903","last_contact":"2025-08-27 14:31:00","last_arrive_days":"16.0803163905903","last_arrive":"2025-08-27 14:31:00+08","duration":"207 days 05:00:55.646582","issued_invoices":null,"client":{"id":97,"key":97,"name":"\u534e\u745e\u4e16\u7eaa\u63a7\u80a1\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u5c71\u897f\u534e\u745e\u7164\u4e1a\u6709\u9650\u516c\u53f8)","logo":null,"client_type":5,"client_class":43,"client_industry":16,"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":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":16,"key":16,"name":"\u80fd\u6e90"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"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":"550000","pct":"15","profit":"82500","project_id":3778}],"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":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":3778,"count":13},"caseCount":null,"salesTimeCount":{"project_id":3778,"hours":"5.68333333333333","times":7},"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3778,"sum":"282.00"},"buildContract":null,"projectRemindReceivers":[{"id":1611,"user_id":1001,"key":1001,"project_id":3778,"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":[],"commentCount":{"object_id":3778,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":{"id":129,"project_id":3778,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"remain_display":25,"progress_remain_display":25,"forecast_remain_display":25,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":550000,"is_exceeded":true,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"16\u5929\u524d","project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_invoice":false,"can_payment":false,"duration_display":207,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"16\u5929\u524d","can_view_product":true,"budget_display":"55\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":0,"un_invoiced":0},{"id":3486,"client_id":287,"project_status":5,"project_progress":9,"budget":"540000","profit_pct":"16.8","bargain_date":"2025-02-28","description":null,"created_by":5300,"created_at":"2024-03-28 22:28:38","updated_at":"2025-09-01 00:12:46","engineer_id":null,"project_title":"\u9f50\u6cbb\u5821\u5792\u673a\u65b0\u8d2d-2024-G","collected":"0","status_updated_at":"2024-12-30 15:15:59.514272+08","success_rate":null,"comment":"\u9f50\u6cbb\u5821\u5792\u673a 2\u53f0 2000\u70b9","contract_type":1,"progress_updated_at":"2024-10-28 10:00:27.831579+08","forecast_updated_at":"2024-12-30 15:15:59.514272+08","end_at":"2024-12-30 15:15:59","pinyin_shortcut":"qzbljxg2024G","creator":5300,"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,"change_status_to":null,"is_verify":false,"profits":"90720.00000000000000000","remain":"256 days 01:10:39.821875","progress_remain":"319 days 06:26:11.504568","forecast_remain":"256 days 01:10:39.821875","lost_contact_days":"13.1018441683681","last_contact":"2025-08-30 14:00:00","last_arrive_days":"125.875455279479","last_arrive":"2025-05-09 19:26:00+08","duration":"276 days 16:47:20.743698","issued_invoices":null,"client":{"id":287,"key":287,"name":"\u5317\u4eac\u5954\u9a70\u6c7d\u8f66\u6709\u9650\u516c\u53f8\uff08\u70df\u53f0\u4fca\u9a70\u7535\u6c14\u81ea\u52a8\u5316\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6d69\u60a6\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09","logo":null,"client_type":5,"client_class":1,"client_industry":5,"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":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237","notice_days":10,"color":"#E89F0E"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"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":"540000.00","pct":"16.8","profit":"90720","project_id":3486}],"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":{"project_id":3486,"points":"487"},"workLogCount":{"project_id":3486,"count":41},"caseCount":{"project_id":3486,"count":5},"salesTimeCount":{"project_id":3486,"hours":"6.26666666666667","times":3},"implementTimeCount":{"project_id":3486,"sum":"15.3833333333333","times":"5"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3486,"sum":"974.33"},"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":3486,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"remain_display":256,"progress_remain_display":319,"forecast_remain_display":256,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":540000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"4\u4e2a\u6708\u524d","project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_invoice":false,"can_payment":false,"duration_display":276,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"13\u5929\u524d","can_view_product":true,"budget_display":"54\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":0,"un_invoiced":0},{"id":3580,"client_id":3284,"project_status":5,"project_progress":3,"budget":"100000","profit_pct":"10","bargain_date":"2025-07-31","description":null,"created_by":5300,"created_at":"2024-06-28 11:26:20","updated_at":"2025-08-29 22:54:45","engineer_id":null,"project_title":"\u4e91\u684c\u9762","collected":"0","status_updated_at":"2025-06-23 15:49:31.441577+08","success_rate":null,"comment":"\u4e91\u684c\u9762\u89e3\u51b3\u65b9\u6848","contract_type":1,"progress_updated_at":"2024-09-14 13:01:35.553182+08","forecast_updated_at":"2025-06-23 15:49:31.441577+08","end_at":"2025-06-23 15:49:31","pinyin_shortcut":"yzm","creator":5413,"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,"change_status_to":null,"is_verify":false,"profits":"10000.0000000000000000","remain":"81 days 00:37:07.89457","progress_remain":"363 days 03:25:03.782965","forecast_remain":"81 days 00:37:07.89457","lost_contact_days":"14.1504552794792","last_contact":"2025-08-29 12:50:00","last_arrive_days":"14.1504552794792","last_arrive":"2025-08-29 12:50:00+08","duration":"360 days 04:23:10.970643","issued_invoices":null,"client":{"id":3284,"key":3284,"name":"\u5149\u660e\u7f51\u4f20\u5a92\u6709\u9650\u516c\u53f8","logo":null,"client_type":6,"client_class":43,"client_industry":14,"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":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":14,"key":14,"name":"\u5e7f\u7535"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{"id":3,"key":3,"name":"\u65b9\u6848\u8bbe\u8ba1","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u9762\u4e34\u7684\u95ee\u9898\u53ca\u6311\u6218\uff0c \u63d0\u51fa\u6211\u65b9\u7684\u4ea7\u54c1\u65b9\u6848\u3002\u5177\u4f53\u7684\u54c1\u724c\uff0c \u578b\u53f7\uff0c\u914d\u7f6e\uff0c\u4fdd\u4fee\u3002 \n\u65b9\u6cd5\uff1a\u5c06\u5ba2\u6237\u7684\u95ee\u9898\u53ca\u9700\u6c42\u7528\u6587\u5b57\u63cf\u8ff0\u51fa\u6765\uff0c\u4ea4\u7ed9\u552e\u524d\u6216\u5382\u5546\u3002"},"projectProductTypes":[{"id":88,"product_type_id":88,"key":88,"name":"\u79c1\u6709\u4e91","budget":"100000","pct":"10","profit":"10000","project_id":3580}],"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":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":5413,"key":5413,"name":"\u8096\u6167\u4e3d","sex":"F","department_id":9,"avatar":{"id":159,"user_id":5413,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ca02da0e-7d82-3904-be85-f050ca37c3c5.jpg"}},"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":3580,"points":"50"},"workLogCount":{"project_id":3580,"count":19},"caseCount":{"project_id":3580,"count":1},"salesTimeCount":{"project_id":3580,"hours":"17.9333333333333","times":11},"implementTimeCount":null,"presalesTimeCount":{"project_id":3580,"sum":"1.45305555555556","times":"1"},"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3580,"sum":"539.70"},"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":3580,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":{"id":115,"project_id":3580,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"remain_display":81,"progress_remain_display":363,"forecast_remain_display":81,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":100000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"14\u5929\u524d","project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_invoice":false,"can_payment":false,"duration_display":360,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"14\u5929\u524d","can_view_product":true,"budget_display":"10\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":0,"un_invoiced":0}],"pagenation":{"totalcount":412,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-12 16:26:39') RETURNING "id" |