68c127f6d68dc: POST https://beta.jinchangxiao.com/v2/project/list at 2025-09-10 03:25:42 pm by 114.246.239.150
Database Queries
总计84条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 15:25:42.882 | 2.7 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om' |
| 15:25:42.886 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:25:42.891 | 26.4 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 (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1000) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) AND ("ttr2"."taxonomy_id"='172') GROUP BY "p"."id" ORDER BY "p"."updated_at" DESC) "c" |
| 15:25:42.918 | 38.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 (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1000) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) AND ("ttr2"."taxonomy_id"='172') GROUP BY "p"."id" ORDER BY "p"."updated_at" DESC LIMIT 10 |
| 15:25:42.957 | 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 (3286, 3343, 3284, 918, 93, 2845, 1663, 2553, 3384, 3376) |
| 15:25:42.958 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 1001, 1004, 5300) |
| 15:25:42.958 | 0.4 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, 1004, 5300)) |
| 15:25:42.959 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id" IN (6, 3, 5) |
| 15:25:42.959 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (47, 43, 80) |
| 15:25:42.960 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id" IN (5, 13, 14) |
| 15:25:42.960 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id"=1 |
| 15:25:42.961 | 0.7 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 (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902) ORDER BY "contribution" DESC, "engineer_id" |
| 15:25:42.962 | 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, 4) |
| 15:25:42.962 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (6, 5, 3, 9) |
| 15:25:42.962 | 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 (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902) |
| 15:25:42.963 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902) |
| 15:25:42.964 | 0.6 ms | SELECT | SELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (1, 2, 5, 226, 215, 160, 140, 164, 172, 129, 184, 189, 197, 199, 308, 204, 185, 191, 229, 349, 363, 369, 377, 130, 350, 340, 165, 182, 128)) ORDER BY "sort" |
| 15:25:42.965 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902) |
| 15:25:42.965 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (1, 2, 5, 226, 215, 160, 140, 164, 172, 129, 184, 189, 197, 199, 308, 204, 185, 191, 229, 349, 363, 369, 377, 130, 350, 340, 165, 182, 128)) ORDER BY "sort" |
| 15:25:42.966 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902) |
| 15:25:42.966 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (1, 2, 5, 226, 215, 160, 140, 164, 172, 129, 184, 189, 197, 199, 308, 204, 185, 191, 229, 349, 363, 369, 377, 130, 350, 340, 165, 182, 128)) ORDER BY "sort" |
| 15:25:42.967 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1004, 5300, 1005) |
| 15:25:42.967 | 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, 1004, 5300)) |
| 15:25:42.967 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1) |
| 15:25:42.968 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 1004, 5413, 1005, 5300, 1001) |
| 15:25:42.968 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1001, 5413, 1005, 1004, 5300)) |
| 15:25:42.968 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3286, 3343, 3284, 918, 93, 2845, 1663, 2553, 3384, 3376) |
| 15:25:42.969 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 1001, 1004, 5300) |
| 15:25:42.970 | 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, 1004, 5300)) |
| 15:25:42.970 | 5.8 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 (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902) GROUP BY "c"."project_id" |
| 15:25:42.976 | 0.4 ms | SELECT | SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("project_id" IN (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902)) GROUP BY "project_id" |
| 15:25:42.977 | 1.0 ms | SELECT | SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902) GROUP BY "project_id" |
| 15:25:42.978 | 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 (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902)) GROUP BY "project_id" |
| 15:25:42.979 | 5.7 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 (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902)) GROUP BY "c"."project_id" |
| 15:25:42.984 | 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 (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902)) GROUP BY "c"."project_id" |
| 15:25:42.987 | 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 (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902)) GROUP BY "project_id" |
| 15:25:42.988 | 1.5 ms | SELECT | SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902)) GROUP BY "project_id" |
| 15:25:42.989 | 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 (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902) |
| 15:25:42.991 | 2.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (3664, 4002, 3926, 4106, 4055, 4112, 4105)) |
| 15:25:42.993 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (22710, 25977, 26643, 27308, 27657, 27658, 27758, 27759) |
| 15:25:42.994 | 2.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (3664, 4002, 3926, 4106, 4055, 4112, 4105)) |
| 15:25:42.996 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (26503, 27307) |
| 15:25:42.996 | 1.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (3664, 4002, 3926, 4106, 4055, 4112, 4105)) |
| 15:25:42.998 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE ("status"=2) AND ("sales_contract_id" IN (3664, 4002, 3926, 4106, 4055, 4112, 4105)) ORDER BY "id" DESC |
| 15:25:42.999 | 2.7 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" IN (3664, 4002, 3926, 4106, 4055, 4112, 4105) ORDER BY "id" DESC |
| 15:25:43.002 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 1001, 5388) |
| 15:25:43.003 | 0.6 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" IN (3664, 4002, 3926, 4106, 4055, 4112, 4105) ORDER BY "id" |
| 15:25:43.003 | 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" IN (3664, 4002, 3926, 4106, 4055, 4112, 4105) ORDER BY "remind_date" |
| 15:25:43.004 | 0.4 ms | SELECT | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (3664, 4002, 3926, 4106, 4055, 4112, 4105) |
| 15:25:43.005 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5388, 1001, 5300, 1011) |
| 15:25:43.005 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1001, 1005, 5388, 5300)) |
| 15:25:43.005 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (3664, 4002, 3926, 4106, 4055, 4112, 4105) |
| 15:25:43.006 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (355, 696, 684, 138, 90, 608, 365, 661, 107) |
| 15:25:43.007 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (3785, 3891, 3818, 3774, 4056, 4098, 3927, 3928, 3929, 4003, 4032, 4103, 4122) |
| 15:25:43.007 | 0.3 ms | SELECT | SELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902) |
| 15:25:43.008 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 15:25:43.008 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 15:25:43.008 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902) |
| 15:25:43.009 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (90, 107, 661, 355, 74, 138, 684, 365) |
| 15:25:43.010 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1717, 2108, 2027, 2026, 2023, 2024, 2025, 2056, 2055, 2058, 2059, 2057, 941, 942, 853, 855, 329, 1876, 1881, 1877, 1737, 1148, 1879, 1880, 1878, 960, 1801, 1882, 922, 1623, 1983, 1624, 2095) |
| 15:25:43.011 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (5, 4, 2, 7, 19, 22, 18, 3) |
| 15:25:43.011 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (214, 35, 219, 2, 30, 151, 200, 189, 157, 51, 26, 36, 144, 47, 14) |
| 15:25:43.012 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (8, 227, 7, 134, 133, 12, 124, 20, 27) |
| 15:25:43.012 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1694, 356, 1651, 1653, 1600, 593, 592, 1024, 1470, 1514, 1012, 615, 1570, 1573, 1318, 1572, 1665, 1663, 1664, 231, 546, 544, 602, 103, 1620, 1455, 1691, 1382) |
| 15:25:43.013 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 1, 7, 8, 3) |
| 15:25:43.013 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (1856, 1855, 1735, 1736, 1737, 1738, 1739, 1812, 1807, 1808, 1809, 1810, 1811, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1384, 1385, 1386, 1678, 1679, 1680, 1681, 1860, 1875, 1861) |
| 15:25:43.014 | 20.0 ms | SELECT | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902)) GROUP BY "object_id" |
| 15:25:43.034 | 16.7 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=1) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902)) GROUP BY "object_id" |
| 15:25:43.051 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (5957, 5980, 4844) |
| 15:25:43.052 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (4844, 5957, 5980) |
| 15:25:43.053 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2598 |
| 15:25:43.053 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (100, 90) |
| 15:25:43.054 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902) |
| 15:25:43.054 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (6008, 1848, 5957) |
| 15:25:43.055 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (918, 3336) |
| 15:25:43.055 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=100 |
| 15:25:43.055 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((6008, 3902), (1848, 3666), (5957, 3751)) |
| 15:25:43.056 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902)) |
| 15:25:43.057 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id" IN (3927, 3807, 3580, 3666, 3461, 3949, 3827, 3751, 3931, 3902) |
| 15:25:43.057 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id" IN (115, 106, 145, 131, 140, 177, 172, 153, 180, 114) |
| 15:25:43.058 | 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, 106, 145, 131, 140, 177, 172, 153, 180, 114) |
| 15:25:43.058 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id" IN (115, 106, 145, 131, 140, 177, 172, 153, 180, 114) |
| 15:25:43.059 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id" IN (115, 106, 145, 131, 140, 177, 172, 153, 180, 114) |
| 15:25:43.063 | 4.4 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', 1000, 0, 266, 'v2/project/list', '{"access_token":"gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om","ProjectSearch":{"projectProductTypes":"","created_by":"","salesForecast":"172","project_status":"","project_progress":"","engineer_id":""},"device_type":"0","version_code":"266","page":"1","token":"63566949002433e0d03f36ca1adbdbd0","posttime":"1757489143","pagesize":"10"}', '{"code":200,"data":{"list":[{"id":3927,"client_id":3286,"project_status":3,"project_progress":6,"budget":"40932","profit_pct":"11.14","bargain_date":"2025-08-22","description":"","created_by":1001,"created_at":"2025-07-22 11:05:23","updated_at":"2025-09-04 11:42:10","engineer_id":null,"project_title":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","collected":"1","status_updated_at":"2025-08-22 10:58:30.751668+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-07-22 11:05:23.224714+08","forecast_updated_at":"2025-07-22 11:05:23.224714+08","end_at":"","pinyin_shortcut":"PAVMfhqwbxy","creator":1011,"used_client":null,"from_contact":5957,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":1010,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"4559.824800000000000000","remain":"19 days 04:27:12.167868","progress_remain":"50 days 04:20:19.694822","forecast_remain":"50 days 04:20:19.694822","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"50 days 04:20:19.694822","issued_invoices":"21224.00","client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"salesRep":{"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"}},"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":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"40932","pct":"11.14","profit":"4732","project_id":3927}],"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":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"salesRep":{"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4112,"from_project":3927,"payment_collection_remind_ahead":"1 day","serial_no":"PO2500925\/PO2500926","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"1","erp_un_settle_amount":"40931","including_tax":true,"amount":"40932","contractScans":[{"id":49444,"object_type":105,"object_id":4112,"attachment_id":27758,"attachment":{"id":27758,"key":27758,"name":"7ee83baa-e612-3fd5-bd97-de0e41ad46c7","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/7ee83baa-e612-3fd5-bd97-de0e41ad46c7\/PO2500925.pdf","orig_name":"PO2500925.pdf"}},{"id":49445,"object_type":105,"object_id":4112,"attachment_id":27759,"attachment":{"id":27759,"key":27759,"name":"d40dfb56-6c1a-3498-b015-b8c1de8944bf","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/d40dfb56-6c1a-3498-b015-b8c1de8944bf\/PO2500926.pdf","orig_name":"PO2500926.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[{"id":"12022","key":"12022","contract_id":4112,"value":"1","created_by":1001,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":0}],"salesContractInvoices":[{"id":2137,"key":2137,"contract_id":4112,"value":"21224.00","attachment_id":null,"from_date":"2025-08-28","attachment":null}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8890,"user_id":1001,"key":1001,"contract_id":4112,"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":8891,"user_id":5388,"key":5388,"contract_id":4112,"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":8892,"user_id":1011,"key":1011,"contract_id":4112,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}],"salesSupplierRels":[{"id":3202,"contract_id":4112,"supplier_id":90,"purchase_id":4122,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4122,"key":4122,"serial_no":"X_2025SBQ23652"}}],"payment_collection_remind_ahead_display":"1\u5929","invoiced":21224},"projectRemindReceivers":[],"projectProductRels":[{"id":10727,"project_id":3927,"product_id":1624,"amount":"1516","number":14,"cost":"1393.00","description":"\u65b0\u8d2d","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"21224.00","total_cost":"19502","erp_sales_order_product_id":1860,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2025-09-04 11:42:10","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1382,"key":1382,"name":"PA\u865a\u62df\u9632\u706b\u5899\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1860,"erp_sales_order_id":1571,"erp_store_id":null,"product_id":1624,"description":"\u65b0\u8d2d","number":"14","outbound":"0","amount":"1516","total_amount":"21224.00","last_number":"14","last_amount":"1516","last_total_amount":"21224.00","cost":"1393.00","total_cost":"19502","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10729,"project_id":3927,"product_id":2095,"amount":"0","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"0","erp_sales_order_product_id":1875,"supplier":null,"product":{"id":2095,"name":"SA3610","product_type":3,"product_component":14,"product_brand":27,"product_serie":1691,"product_misc":null,"product_qa":null,"pn":"","description":"2U\u673a\u67b6\u5f0f12 \u69fd\u673a\u67b6\u5f0f\u670d\u52a1\u5668\uff0cCPU\uff1aIntel\u00ae Xeon\u00ae D-1567\uff1b\u5185\u5b58\uff1a16 GB DDR4 ECC RDIMM\uff08\u53ef\u6269\u5145\u81f3 128 GB\uff09\uff1b12 x 3.5 \u82f1\u5bf8 Synology SAS\/SATA HDD\u30012.5 \u82f1\u5bf8 Synology SATA SSD \u6216 2.5 \u82f1\u5bf8 SAS SSD\uff08\u4e0d\u542b\u786c\u76d8\uff09\uff1b\u652f\u6301\u70ed\u63d2\u62d4\u786c\u76d8\uff1b2 x USB 3.2 \u7b2c 1 \u4ee3\u7aef\u53e3\u548c1 x \u6269\u5145\u7aef\u53e3 (Mini-SAS HD)\uff1b5\u5e74\u4fdd\u4fee\u3002","created_by":1013,"created_at":"2025-08-14 09:06:15","updated_at":"2025-09-04 11:02:52","pinyin_shortcut":"SA3610","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":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1691,"key":1691,"name":"SA3610 NAS\u5b58\u50a8\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1875,"erp_sales_order_id":1571,"erp_store_id":null,"product_id":2095,"description":"","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10728,"project_id":3927,"product_id":1624,"amount":"1516","number":13,"cost":"1393.00","description":"\u7eed\u7ea6","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"19708","total_cost":"18109","erp_sales_order_product_id":1861,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2025-09-04 11:42:10","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1382,"key":1382,"name":"PA\u865a\u62df\u9632\u706b\u5899\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1861,"erp_sales_order_id":1571,"erp_store_id":null,"product_id":1624,"description":"\u7eed\u7ea6","number":"13","outbound":"13","amount":"1516","total_amount":"19708","last_number":"14","last_amount":"1516","last_total_amount":"21224.00","cost":"1393.00","total_cost":"19502","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3927,"comment":3},"unreadComments":null,"fromContact":{"id":5957,"key":5957,"name":"\u674e\u777f\uff08Rick Li\uff09","client_id":null,"supplier_id":100,"mobiles":[{"id":6746,"contact_id":5957,"mobile":"13910153435","mp_open_id":null}],"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPoints":[],"erpSalesOrder":{"id":1571,"serial_no":"XSDD-20250822-00001","from_date":null,"wrote_date":"2025-08-22","handler":1001,"client_id":3286,"purchase_contract_id":null,"project_id":3927,"sales_contract_id":4112,"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-08-22 10:59:39","stop_at":"2025-08-26 13:45:57.84962+08","cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"28","amount":"40932","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"5388\",\"1011\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2025-10-22\",\"amount\":\"42448\",\"pct\":\"100\"}]}","outbound_status":false,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-08-22 10:58:31","updated_at":"2025-08-26 16:06:50"},"projectUsedClient":{"id":180,"project_id":3927,"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":19,"progress_remain_display":50,"forecast_remain_display":50,"projectProductTotalAmount":40932,"projectProductAllAmount":true,"projectProductTotalCost":37611,"projectProductAllCost":true,"projectProductTotalNumber":28,"unissued_invoice":19708,"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":50,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"4.09\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":"40931","un_invoiced":19708},{"id":3807,"client_id":3343,"project_status":2,"project_progress":5,"budget":"766940","profit_pct":"10","bargain_date":"2025-09-06","description":null,"created_by":1004,"created_at":"2025-03-27 10:46:13","updated_at":"2025-08-31 16:37:04","engineer_id":null,"project_title":"\u670d\u52a1\u5668\u786c\u4ef6\u91c7\u8d2d","collected":"0","status_updated_at":"2025-03-27 10:46:13.518937+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-03-27 10:46:13.518937+08","forecast_updated_at":"2025-03-27 10:46:13.518937+08","end_at":"","pinyin_shortcut":"fwqyjcg","creator":1004,"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":"76694.0000000000000000","remain":"167 days 04:39:29.400599","progress_remain":"167 days 04:39:29.400599","forecast_remain":"167 days 04:39:29.400599","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"167 days 04:39:29.400599","issued_invoices":null,"client":{"id":3343,"key":3343,"name":"\u5317\u4eac\u5317\u6c7d\u79d1\u6280\u670d\u52a1\u6709\u9650\u516c\u53f8(\u4e2d\u90fd\u4e09\u4ea7\uff09","logo":null,"client_type":5,"client_class":43,"client_industry":5,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"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":5,"key":5,"name":"\u5236\u9020"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3807,"value":"1","key":1015,"name":"\u5434\u660a"}],"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":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"766940.00","pct":"10","profit":"76694","project_id":3807}],"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":128,"key":128,"name":"\u516c\u5f00\u62db\u6807"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3807,"sum":"283.00"},"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":3807,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":{"id":114,"project_id":3807,"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":167,"progress_remain_display":167,"forecast_remain_display":167,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":766940,"is_exceeded":true,"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":167,"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":"76.69\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":"78 days 23:36:11.477959","progress_remain":"361 days 02:24:07.366354","forecast_remain":"78 days 23:36:11.477959","lost_contact_days":"12.1081356427778","last_contact":"2025-08-29 12:50:00","last_arrive_days":"12.1081356427778","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":78,"progress_remain_display":361,"forecast_remain_display":78,"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":"12\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":"12\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},{"id":3666,"client_id":918,"project_status":3,"project_progress":9,"budget":"387250","profit_pct":"25.15","bargain_date":"2024-11-30","description":"","created_by":1005,"created_at":"2024-09-22 19:33:32","updated_at":"2025-08-29 12:20:41","engineer_id":null,"project_title":"24-25\u5e74\u7eed\u4fdd\u9879\u76ee","collected":"348525","status_updated_at":"2024-11-15 10:43:29.936206+08","success_rate":null,"comment":"\u6df1\u4fe1\u670d\u7eed\u4fdd\uff0c\u4e00\u5e74\u4eba\u5de5\u670d\u52a1","contract_type":1,"progress_updated_at":"2024-10-27 21:05:15.017806+08","forecast_updated_at":"2025-06-11 17:50:23.026397+08","end_at":"","pinyin_shortcut":"2425nxbxm","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":"50000","paid_contact_point":null,"project_product_version_id":801,"is_sales_order_ready":true,"collected_plan":387250,"change_status_to":null,"is_verify":false,"profits":"97393.375000000000000000","remain":"299 days 04:42:12.98333","progress_remain":"317 days 18:20:27.90173","forecast_remain":"90 days 21:35:19.893139","lost_contact_days":"75.2609134205556","last_contact":"2025-06-27 09:10:00","last_arrive_days":null,"last_arrive":null,"duration":"352 days 19:52:10.394443","issued_invoices":"348525.00","client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8","logo":null,"client_type":6,"client_class":47,"client_industry":5,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"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":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":"387250.00","pct":"25.15","profit":"97393.375","project_id":3666}],"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":129,"key":129,"name":"\u7279\u7ea6\u9080\u6807"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"casePoints":{"project_id":3666,"points":"1410"},"workLogCount":{"project_id":3666,"count":2},"caseCount":{"project_id":3666,"count":39},"salesTimeCount":null,"implementTimeCount":{"project_id":3666,"sum":"68.6380555555556","times":"38"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3666,"sum":"275.13"},"buildContract":{"id":3664,"from_project":3666,"payment_collection_remind_ahead":"7 days","serial_no":"TS-ZHY-2024113001","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"348525","erp_un_settle_amount":"38725","including_tax":true,"amount":"387250","contractScans":[{"id":31511,"object_type":105,"object_id":3664,"attachment_id":22710,"attachment":{"id":22710,"key":22710,"name":"6fe0be15-6902-38a6-8c5c-2ed7eb8a2a13","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/6fe0be15-6902-38a6-8c5c-2ed7eb8a2a13\/\u571f\u6728\u6280\u672f\u670d\u52a1.pdf","orig_name":"\u571f\u6728\u6280\u672f\u670d\u52a1.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[{"id":356,"serial_no":"SKD-20250626-00001","wrote_date":"2025-06-26","from_date":null,"handler":1005,"user_id":null,"client_id":918,"sales_contract_id":3664,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2025-06-26 16:36:47","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"154900","settle_amount":"154900","created_by":1013,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2025-06-26 16:36:47","updated_at":"2025-06-26 16:36:47","paid_amount":null,"contact_id":null},{"id":237,"serial_no":"SKD-20250122-00002","wrote_date":"2025-01-22","from_date":null,"handler":1005,"user_id":null,"client_id":918,"sales_contract_id":3664,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2025-01-22 15:24:17","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"193625","settle_amount":"193625","created_by":1013,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2025-01-22 15:24:17","updated_at":"2025-01-22 15:24:17","paid_amount":null,"contact_id":null}],"salesContractPayments":[{"id":"1356","key":"1356","contract_id":3664,"value":"154900","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":40},{"id":"1237","key":"1237","contract_id":3664,"value":"193625","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":50}],"salesContractInvoices":[{"id":1868,"key":1868,"contract_id":3664,"value":"193625.00","attachment_id":null,"from_date":"2024-11-21","attachment":null},{"id":1923,"key":1923,"contract_id":3664,"value":"-193625.00","attachment_id":null,"from_date":"2025-01-03","attachment":null},{"id":1943,"key":1943,"contract_id":3664,"value":"193625.00","attachment_id":null,"from_date":"2025-01-20","attachment":null},{"id":2038,"key":2038,"contract_id":3664,"value":"154900.00","attachment_id":null,"from_date":"2025-05-12","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2271,"key":2271,"contract_id":3664,"name":"2025-01-30","value":"193625","overdue_days":null,"pct":50,"collect_status":"\u5df2\u5b8c\u6210"},{"id":2272,"key":2272,"contract_id":3664,"name":"2025-05-15","value":"154900","overdue_days":42,"pct":40,"collect_status":"\u5df2\u5b8c\u6210"},{"id":2273,"key":2273,"contract_id":3664,"name":"2025-11-30","value":"38725","overdue_days":null,"pct":10,"collect_status":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":7635,"user_id":1005,"key":1005,"contract_id":3664,"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"}}},{"id":7636,"user_id":5388,"key":5388,"contract_id":3664,"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":7637,"user_id":1001,"key":1001,"contract_id":3664,"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":2419,"contract_id":3664,"supplier_id":355,"purchase_id":3785,"supplier":{"id":355,"key":355,"name":"\u4e2d\u5317\u6c47\u901a(\u5317\u4eac)\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3785,"key":3785,"serial_no":"ZBHT2025021301"}},{"id":2691,"contract_id":3664,"supplier_id":696,"purchase_id":3891,"supplier":{"id":696,"key":696,"name":"\u65b0\u534e\u4e09\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3891,"key":3891,"serial_no":"\u8ba2\u5355\u7f16\u53f7\uff1aTRO20250508010005"}},{"id":2475,"contract_id":3664,"supplier_id":684,"purchase_id":3818,"supplier":{"id":684,"key":684,"name":"\u6e56\u5357\u6df1\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3818,"key":3818,"serial_no":"SFSHFWH202503060228"}},{"id":2389,"contract_id":3664,"supplier_id":138,"purchase_id":3774,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"purchase":{"id":3774,"key":3774,"serial_no":"SFJDFWH202501220039"}}],"payment_collection_remind_ahead_display":"7\u5929","invoiced":348525},"projectRemindReceivers":[],"projectProductRels":[{"id":8930,"project_id":3666,"product_id":941,"amount":"100000","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"100000","total_cost":"0","erp_sales_order_product_id":1365,"supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2025-08-18 13:55:12","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1365,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"0","amount":"100000","total_amount":"100000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":8931,"project_id":3666,"product_id":942,"amount":"10000","number":1,"cost":"6000","description":"","supplier_id":355,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"10000","total_cost":"6000","erp_sales_order_product_id":1366,"supplier":{"id":355,"key":355,"name":"\u4e2d\u5317\u6c47\u901a(\u5317\u4eac)\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":134,"product_serie":593,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2025-08-25 16:06:57","pinyin_shortcut":"dsfwcjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1366,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":942,"description":"","number":"1","outbound":"0","amount":"10000","total_amount":"10000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"6000","total_cost":"6000","supplier_id":355,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":8932,"project_id":3666,"product_id":941,"amount":"1100","number":1,"cost":"0","description":"\u574f\u4e86\u518d\u627e\u4eba\u4fee","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1100","total_cost":"0","erp_sales_order_product_id":1367,"supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2025-08-18 13:55:12","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1367,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":941,"description":"\u574f\u4e86\u518d\u627e\u4eba\u4fee","number":"1","outbound":"0","amount":"1100","total_amount":"1100","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":8933,"project_id":3666,"product_id":853,"amount":"40500","number":1,"cost":"20400","description":"","supplier_id":74,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"40500","total_cost":"20400","erp_sales_order_product_id":1368,"supplier":{"id":74,"key":74,"name":"\u65b0\u534e\u4e09\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":853,"name":"H3C SDN(SNA Center,MAC\u7cfb\u7edf)\u539f\u5382\u7eed\u4fdd","product_type":4,"product_component":47,"product_brand":20,"product_serie":544,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2022-07-25 16:53:52","updated_at":"2023-08-11 16:13:49","pinyin_shortcut":"H3CSDNSNACenterMACxtycxb","product_unit":8,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":47,"key":47,"name":"\u7f51\u7edc\u8bbe\u5907\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":544,"key":544,"name":"H3C SDN\u7eed\u4fdd"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":1368,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":853,"description":"","number":"1","outbound":"0","amount":"40500","total_amount":"40500","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"20400","total_cost":"20400","supplier_id":74,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":8934,"project_id":3666,"product_id":941,"amount":"16500","number":1,"cost":"0","description":"\u5907\u4efd\u8f6f\u4ef6\u539f\u5382\u7eed\u4fdd","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"16500","total_cost":"0","erp_sales_order_product_id":1369,"supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2025-08-18 13:55:12","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1369,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":941,"description":"\u5907\u4efd\u8f6f\u4ef6\u539f\u5382\u7eed\u4fdd","number":"1","outbound":"0","amount":"16500","total_amount":"16500","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":8935,"project_id":3666,"product_id":855,"amount":"36000","number":1,"cost":"19080","description":"","supplier_id":355,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"36000","total_cost":"19080","erp_sales_order_product_id":1370,"supplier":{"id":355,"key":355,"name":"\u4e2d\u5317\u6c47\u901a(\u5317\u4eac)\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":855,"name":"\u7ef4\u8c1b\u673a\u623f\u7cbe\u5bc6\u7a7a\u8c03\u4e00\u5e74\u7eed\u4fdd","product_type":18,"product_component":144,"product_brand":124,"product_serie":546,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2022-07-26 10:59:54","updated_at":"2023-08-11 16:13:35","pinyin_shortcut":"wdjfjmktynxb","product_unit":8,"is_renew":false,"productType":{"id":18,"key":18,"name":"\u673a\u623f\u8bbe\u5907"},"productComponent":{"id":144,"key":144,"name":"\u7a7a\u8c03"},"productBrand":{"id":124,"key":124,"name":"\u7ef4\u8c1b"},"productSerie":{"id":546,"key":546,"name":"\u673a\u623f\u7a7a\u8c03\u7eed\u4fdd"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":1370,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":855,"description":"","number":"1","outbound":"0","amount":"36000","total_amount":"36000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"19080","total_cost":"19080","supplier_id":355,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":8936,"project_id":3666,"product_id":329,"amount":"8700","number":1,"cost":"5548","description":"","supplier_id":138,"hardware_from":null,"software_from":"2025-02-01","maintenance_from":null,"hardware_to":null,"software_to":"2026-01-31","maintenance_to":null,"total_amount":"8700","total_cost":"5548","erp_sales_order_product_id":1371,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"product":{"id":329,"name":"\u6df1\u4fe1\u670dURL\u7cfb\u7edf\u8f6f\u4ef6V5.0","product_type":4,"product_component":51,"product_brand":12,"product_serie":231,"product_misc":5,"product_qa":2,"pn":"","description":"","created_by":1013,"created_at":"2018-01-04 11:22:48","updated_at":"2023-08-14 15:03:51","pinyin_shortcut":"sxfURLxtrjV50","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":231,"key":231,"name":"\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1371,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":329,"description":"","number":"1","outbound":"0","amount":"8700","total_amount":"8700","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"5548","total_cost":"5548","supplier_id":138,"hardware_from":null,"software_from":"2025-02-01","maintenance_from":null,"hardware_to":null,"software_to":"2026-01-31","maintenance_to":null}},{"id":8937,"project_id":3666,"product_id":1876,"amount":"0","number":1,"cost":"8277","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"0","total_cost":"8277","erp_sales_order_product_id":1372,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"product":{"id":1876,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-E600-BU\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1570,"product_misc":null,"product_qa":null,"pn":"","description":"400\u8fdc\u7a0b\u6280\u672f\u652f\u6301+\u8f6f\u4ef6\u5347\u7ea7+\u4ea7\u54c1\u8d28\u4fdd\uff08\u6807\u51c6\u7248\uff09","created_by":1013,"created_at":"2024-11-15 13:15:52","updated_at":"2024-11-15 13:15:52","pinyin_shortcut":"sxfcpzbrjsjfwsyyAC1000E600BU","product_unit":2,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1570,"key":1570,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-E600-BU\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1372,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":1876,"description":"","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"8277","total_cost":"8277","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null}},{"id":8938,"project_id":3666,"product_id":1881,"amount":"8700","number":1,"cost":"3787","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"8700","total_cost":"3787","erp_sales_order_product_id":1373,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"product":{"id":1881,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eVPN-1000-B400-BU\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":null,"product_misc":null,"product_qa":null,"pn":"","description":"400\u8fdc\u7a0b\u6280\u672f\u652f\u6301+\u8f6f\u4ef6\u5347\u7ea7+\u4ea7\u54c1\u8d28\u4fdd\uff08\u6807\u51c6\u7248\uff09","created_by":1013,"created_at":"2024-11-15 13:25:47","updated_at":"2024-11-15 13:25:47","pinyin_shortcut":"sxfcpzbrjsjfwsyyVPN1000B400BU","product_unit":2,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":null,"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1373,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":1881,"description":"","number":"1","outbound":"0","amount":"8700","total_amount":"8700","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"3787","total_cost":"3787","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null}},{"id":8939,"project_id":3666,"product_id":1877,"amount":"0","number":2,"cost":"7436","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"0","total_cost":"14872.00","erp_sales_order_product_id":1374,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"product":{"id":1877,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAF-1000-F640-BU\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":null,"product_misc":null,"product_qa":null,"pn":"","description":"400\u8fdc\u7a0b\u6280\u672f\u652f\u6301+\u8f6f\u4ef6\u5347\u7ea7+\u4ea7\u54c1\u8d28\u4fdd\uff08\u6807\u51c6\u7248\uff09","created_by":1013,"created_at":"2024-11-15 13:17:18","updated_at":"2024-11-15 13:17:18","pinyin_shortcut":"sxfcpzbrjsjfwsyyAF1000F640BU","product_unit":2,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":null,"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1374,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":1877,"description":"","number":"2","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"7436","total_cost":"14872.00","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null}},{"id":8940,"project_id":3666,"product_id":1737,"amount":"7875","number":2,"cost":"5116","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"15750","total_cost":"10232.00","erp_sales_order_product_id":1375,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"product":{"id":1737,"name":"\u6df1\u4fe1\u670d\u7f51\u5173\u6740\u6bd2\u8f6f\u4ef6V6.0 \u7eed\u4fdd\u670d\u52a1","product_type":22,"product_component":200,"product_brand":12,"product_serie":1470,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-12 13:18:49","updated_at":"2024-08-12 13:18:49","pinyin_shortcut":"sxfwgsdrjV60xbfw","product_unit":2,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1470,"key":1470,"name":"\u6df1\u4fe1\u670d\u7f51\u5173\u6740\u6bd2\u8f6f\u4ef6V6.0 \u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1375,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":1737,"description":"","number":"2","outbound":"0","amount":"7875","total_amount":"15750","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"5116","total_cost":"10232.00","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null}},{"id":8941,"project_id":3666,"product_id":1148,"amount":"7875","number":2,"cost":"5116","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"15750","total_cost":"10232.00","erp_sales_order_product_id":1376,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"product":{"id":1148,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6 V8.0","product_type":5,"product_component":35,"product_brand":12,"product_serie":103,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-12-13 14:20:48","updated_at":"2023-12-13 14:20:48","pinyin_shortcut":"sxfaqynyzdyrjV80","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":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":103,"key":103,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1376,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":1148,"description":"","number":"2","outbound":"0","amount":"7875","total_amount":"15750","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"5116","total_cost":"10232.00","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null}},{"id":8942,"project_id":3666,"product_id":1879,"amount":"0","number":2,"cost":"3081","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"0","total_cost":"6162","erp_sales_order_product_id":1377,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"product":{"id":1879,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAF-1000-D440-BU\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1573,"product_misc":null,"product_qa":null,"pn":"","description":"400\u8fdc\u7a0b\u6280\u672f\u652f\u6301+\u8f6f\u4ef6\u5347\u7ea7+\u4ea7\u54c1\u8d28\u4fdd\uff08\u6807\u51c6\u7248\uff09","created_by":1013,"created_at":"2024-11-15 13:23:01","updated_at":"2024-11-15 13:23:01","pinyin_shortcut":"sxfcpzbrjsjfwsyyAF1000D440BU","product_unit":2,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1573,"key":1573,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAF-1000-D440-BU\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1377,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":1879,"description":"","number":"2","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"3081","total_cost":"6162","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null}},{"id":8943,"project_id":3666,"product_id":1737,"amount":"4500","number":2,"cost":"1926","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"9000","total_cost":"3852","erp_sales_order_product_id":1378,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"product":{"id":1737,"name":"\u6df1\u4fe1\u670d\u7f51\u5173\u6740\u6bd2\u8f6f\u4ef6V6.0 \u7eed\u4fdd\u670d\u52a1","product_type":22,"product_component":200,"product_brand":12,"product_serie":1470,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-12 13:18:49","updated_at":"2024-08-12 13:18:49","pinyin_shortcut":"sxfwgsdrjV60xbfw","product_unit":2,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1470,"key":1470,"name":"\u6df1\u4fe1\u670d\u7f51\u5173\u6740\u6bd2\u8f6f\u4ef6V6.0 \u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1378,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":1737,"description":"","number":"2","outbound":"0","amount":"4500","total_amount":"9000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"1926","total_cost":"3852","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null}},{"id":8944,"project_id":3666,"product_id":1148,"amount":"4500","number":2,"cost":"1926","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"9000","total_cost":"3852","erp_sales_order_product_id":1379,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"product":{"id":1148,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6 V8.0","product_type":5,"product_component":35,"product_brand":12,"product_serie":103,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-12-13 14:20:48","updated_at":"2023-12-13 14:20:48","pinyin_shortcut":"sxfaqynyzdyrjV80","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":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":103,"key":103,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1379,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":1148,"description":"","number":"2","outbound":"0","amount":"4500","total_amount":"9000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"1926","total_cost":"3852","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null}},{"id":8945,"project_id":3666,"product_id":1880,"amount":"8850","number":2,"cost":"3108.5","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"17700","total_cost":"6217","erp_sales_order_product_id":1380,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"product":{"id":1880,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd\u670d\u52a1\uff08\u9002\u7528\u4e8eSdSec-1000-A600\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":null,"product_misc":null,"product_qa":null,"pn":"","description":"\u4ea7\u54c1\u8d28\u4fdd\uff08\u6807\u51c6\u7248\uff09+400\u8fdc\u7a0b\u6280\u672f\u652f\u6301","created_by":1013,"created_at":"2024-11-15 13:24:44","updated_at":"2024-11-15 13:24:44","pinyin_shortcut":"sxfcpzbfwsyySdSec1000A600","product_unit":2,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":null,"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1380,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":1880,"description":"","number":"2","outbound":"0","amount":"8850","total_amount":"17700","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"3108.5","total_cost":"6217","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null}},{"id":8946,"project_id":3666,"product_id":1878,"amount":"0","number":1,"cost":"5018","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"0","total_cost":"5018","erp_sales_order_product_id":1381,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"product":{"id":1878,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eSTA-100-B420-BU\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1572,"product_misc":null,"product_qa":null,"pn":"","description":"400\u8fdc\u7a0b\u6280\u672f\u652f\u6301+\u8f6f\u4ef6\u5347\u7ea7+\u4ea7\u54c1\u8d28\u4fdd\uff08\u6807\u51c6\u7248\uff09","created_by":1013,"created_at":"2024-11-15 13:18:32","updated_at":"2024-11-15 13:18:32","pinyin_shortcut":"sxfcpzbrjsjfwsyySTA100B420BU","product_unit":2,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1572,"key":1572,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eSTA-100-B420-BU\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1381,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":1878,"description":"","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"5018","total_cost":"5018","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null}},{"id":8947,"project_id":3666,"product_id":960,"amount":"7950","number":1,"cost":"3136","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"7950","total_cost":"3136","erp_sales_order_product_id":1382,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"product":{"id":960,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u611f\u77e5\u7cfb\u7edf\u63a2\u9488\u7279\u5f81\u5e93\u8f6f\u4ef6V2.0","product_type":4,"product_component":51,"product_brand":12,"product_serie":602,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-04 11:07:29","updated_at":"2023-08-11 15:59:57","pinyin_shortcut":"sxfaqgzxttztzkrjV20","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":602,"key":602,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u611f\u77e5\u7cfb\u7edf\u63a2\u9488\u7279\u5f81\u5e93\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1382,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":960,"description":"","number":"1","outbound":"0","amount":"7950","total_amount":"7950","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"3136","total_cost":"3136","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null}},{"id":8948,"project_id":3666,"product_id":1801,"amount":"0","number":1,"cost":"27174","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"0","total_cost":"27174","erp_sales_order_product_id":1383,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"product":{"id":1801,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08SIP-1000-B400\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1514,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-09-29 16:10:27","updated_at":"2024-09-29 16:10:27","pinyin_shortcut":"sxfcpzbrjsjfwSIP1000B400","product_unit":8,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1514,"key":1514,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eSIP-1000-B400\uff09"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":1383,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":1801,"description":"","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"27174","total_cost":"27174","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null}},{"id":8949,"project_id":3666,"product_id":1882,"amount":"51000","number":1,"cost":"18234","description":"","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null,"total_amount":"51000","total_cost":"18234","erp_sales_order_product_id":1384,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"product":{"id":1882,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u611f\u77e5\u7cfb\u7edf\u5e73\u53f0\u7279\u5f81\u5e93\u8f6f\u4ef6V2.0(\u9002\u7528\u4e8eSIP-1000-B400-BU)","product_type":4,"product_component":51,"product_brand":12,"product_serie":1318,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-15 14:13:40","updated_at":"2024-11-15 14:13:40","pinyin_shortcut":"sxfaqgzxtpttzkrjV20syySIP1000B400BU","product_unit":2,"is_renew":true,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1318,"key":1318,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u611f\u77e5\u7cfb\u7edf\u5e73\u53f0\u7279\u5f81\u5e93\u8f6f\u4ef6V2.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1384,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":1882,"description":"","number":"1","outbound":"0","amount":"51000","total_amount":"51000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"18234","total_cost":"18234","supplier_id":138,"hardware_from":"2025-02-01","software_from":"2025-02-01","maintenance_from":null,"hardware_to":"2026-01-31","software_to":"2026-01-31","maintenance_to":null}},{"id":8950,"project_id":3666,"product_id":922,"amount":"39600.00","number":1,"cost":"38840.00","description":"","supplier_id":138,"hardware_from":null,"software_from":"2025-02-01","maintenance_from":null,"hardware_to":null,"software_to":"2026-01-31","maintenance_to":null,"total_amount":"39600","total_cost":"38840","erp_sales_order_product_id":1385,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"product":{"id":922,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0EDR\u7eed\u4fdd\u670d\u52a1","product_type":22,"product_component":200,"product_brand":12,"product_serie":1024,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-05-08 12:11:04","updated_at":"2024-01-25 15:18:25","pinyin_shortcut":"sxfzdjcxyptEDRxbfw","product_unit":2,"is_renew":false,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1024,"key":1024,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0EDR\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1385,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":922,"description":"","number":"1","outbound":"0","amount":"39600.00","total_amount":"39600","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"38840.00","total_cost":"38840","supplier_id":138,"hardware_from":null,"software_from":"2025-02-01","maintenance_from":null,"hardware_to":null,"software_to":"2026-01-31","maintenance_to":null}},{"id":8951,"project_id":3666,"product_id":922,"amount":"0","number":1,"cost":"3500.00","description":"\u7f51\u5173ID\uff1a6616425403\uff0c\u7248\u672c\u662f6.0.2R1","supplier_id":684,"hardware_from":null,"software_from":"2025-03-07","maintenance_from":null,"hardware_to":null,"software_to":"2026-03-07","maintenance_to":null,"total_amount":"0","total_cost":"3500","erp_sales_order_product_id":1386,"supplier":{"id":684,"key":684,"name":"\u6e56\u5357\u6df1\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":922,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0EDR\u7eed\u4fdd\u670d\u52a1","product_type":22,"product_component":200,"product_brand":12,"product_serie":1024,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-05-08 12:11:04","updated_at":"2024-01-25 15:18:25","pinyin_shortcut":"sxfzdjcxyptEDRxbfw","product_unit":2,"is_renew":false,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1024,"key":1024,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0EDR\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1386,"erp_sales_order_id":1388,"erp_store_id":null,"product_id":922,"description":"\u7f51\u5173ID\uff1a6616425403\uff0c\u7248\u672c\u662f6.0.2R1","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"3500.00","total_cost":"3500","supplier_id":684,"hardware_from":null,"software_from":"2025-03-07","maintenance_from":null,"hardware_to":null,"software_to":"2026-03-07","maintenance_to":null}}],"commentCount":{"object_id":3666,"comment":9},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":834,"project_id":3666,"contact_id":1848,"point":"50000.00","paid_point":null,"contact":{"id":1848,"key":1848,"name":"\u674e\u58a8","client_id":918,"supplier_id":null,"client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"}],"erpSalesOrder":{"id":1388,"serial_no":"XSDD-20250718-00001","from_date":null,"wrote_date":"2024-11-30","handler":1005,"client_id":918,"purchase_contract_id":null,"project_id":3666,"sales_contract_id":3664,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"29","amount":"387250","created_by":1005,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-11-15 10:43:29","updated_at":"2024-11-15 10:43:29"},"projectUsedClient":{"id":131,"project_id":3666,"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":299,"progress_remain_display":317,"forecast_remain_display":90,"projectProductTotalAmount":387250,"projectProductAllAmount":true,"projectProductTotalCost":214413,"projectProductAllCost":true,"projectProductTotalNumber":29,"unissued_invoice":38725,"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":352,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"2\u4e2a\u6708\u524d","can_view_product":true,"budget_display":"38.73\u4e07","contact_points_status_display":"\u672a\u6838\u9500","verify_display":0,"un_collected":"38725","un_invoiced":38725},{"id":3461,"client_id":93,"project_status":4,"project_progress":6,"budget":"1000000","profit_pct":"20","bargain_date":"2025-08-31","description":null,"created_by":1005,"created_at":"2024-03-04 09:39:05","updated_at":"2025-08-25 11:38:20","engineer_id":null,"project_title":"\u6570\u636e\u5907\u4efd\u65b9\u6848\uff08\u542b\u5b9e\u9a8c\u5ba4\uff09-\u4f55\u5ca9\u9879\u76ee","collected":"0","status_updated_at":"2025-08-25 11:38:20.607799+08","success_rate":null,"comment":"NETAPP FAS2800*2","contract_type":1,"progress_updated_at":"2025-07-07 10:32:04.714509+08","forecast_updated_at":"2025-08-25 11:38:20.607799+08","end_at":"2025-08-25 11:38:20","pinyin_shortcut":"sjbffahsyshyxm","creator":1005,"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":"200000.0000000000000000","remain":"16 days 03:47:22.311737","progress_remain":"65 days 04:53:38.205027","forecast_remain":"16 days 03:47:22.311737","lost_contact_days":"363.976191198333","last_contact":"2024-09-11 16:00:00","last_arrive_days":null,"last_arrive":null,"duration":"539 days 01:59:15.022348","issued_invoices":null,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":3,"client_class":47,"client_industry":5,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientType":{"id":3,"key":3,"name":"\u5916\u4f01"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3461,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"1000000.00","pct":"20","profit":"200000","project_id":3461}],"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":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"casePoints":{"project_id":3461,"points":"31"},"workLogCount":{"project_id":3461,"count":3},"caseCount":{"project_id":3461,"count":1},"salesTimeCount":null,"implementTimeCount":{"project_id":3461,"sum":"1.62722222222222","times":"1"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3461,"sum":"249.95"},"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":3461,"comment":5},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":{"id":145,"project_id":3461,"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":16,"progress_remain_display":65,"forecast_remain_display":16,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":1000000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_invoice":false,"can_payment":false,"duration_display":539,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"11\u4e2a\u6708\u524d","can_view_product":true,"budget_display":"100\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":0,"un_invoiced":0},{"id":3949,"client_id":2845,"project_status":3,"project_progress":6,"budget":"15340","profit_pct":"2.35","bargain_date":"2025-08-19","description":"","created_by":1001,"created_at":"2025-08-19 16:55:09","updated_at":"2025-08-22 15:54:38","engineer_id":null,"project_title":"PA1410\u4e00\u5e74\u670d\u52a1","collected":"0","status_updated_at":"2025-08-19 17:45:00.090435+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-08-19 16:55:09.854722+08","forecast_updated_at":"2025-08-19 16:55:09.854722+08","end_at":"","pinyin_shortcut":"PA1410ynfw","creator":1011,"used_client":null,"from_contact":5980,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":984,"is_sales_order_ready":true,"collected_plan":15340,"change_status_to":null,"is_verify":false,"profits":"360.490000000000000000","remain":"21 days 21:40:42.829101","progress_remain":"21 days 22:30:33.064814","forecast_remain":"21 days 22:30:33.064814","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"21 days 22:30:33.064814","issued_invoices":"15340.00","client":{"id":2845,"key":2845,"name":"\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08PA\u8fc7\u5355\uff09","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"salesRep":{"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"}},"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":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"15340","pct":"2.35","profit":"360.49","project_id":3949}],"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":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"salesRep":{"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4106,"from_project":3949,"payment_collection_remind_ahead":"1 day","serial_no":"TS-LRC-2025081901","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"0","erp_un_settle_amount":"15340","including_tax":true,"amount":"15340","contractScans":[{"id":48837,"object_type":105,"object_id":4106,"attachment_id":27658,"attachment":{"id":27658,"key":27658,"name":"3d37d904-ae5a-3dd6-80e0-4ffe662ea0ae","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/3d37d904-ae5a-3dd6-80e0-4ffe662ea0ae\/\u5408\u540c\u76d6\u7ae0\u4ef6.pdf","orig_name":"\u5408\u540c\u76d6\u7ae0\u4ef6.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[],"salesContractInvoices":[{"id":2131,"key":2131,"contract_id":4106,"value":"15340.00","attachment_id":null,"from_date":"2025-08-25","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2549,"key":2549,"contract_id":4106,"name":"2025-09-05","value":"15340","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f5\u5929"}],"salesContractPaymentCollectionRemindReceivers":[{"id":8853,"user_id":1001,"key":1001,"contract_id":4106,"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":8854,"user_id":1011,"key":1011,"contract_id":4106,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":8855,"user_id":5388,"key":5388,"contract_id":4106,"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"}}}],"salesSupplierRels":[{"id":3168,"contract_id":4106,"supplier_id":90,"purchase_id":4103,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4103,"key":4103,"serial_no":"X_2025SBQ23003"}}],"payment_collection_remind_ahead_display":"1\u5929","invoiced":15340},"projectRemindReceivers":[],"projectProductRels":[{"id":10668,"project_id":3949,"product_id":2108,"amount":"15340.00","number":1,"cost":"14573.00","description":"","supplier_id":90,"hardware_from":null,"software_from":"2025-08-20","maintenance_from":null,"hardware_to":null,"software_to":"2026-08-20","maintenance_to":null,"total_amount":"15340","total_cost":"14573","erp_sales_order_product_id":1855,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":2108,"name":"PAN-SVC-BKLN-1410-R","product_type":5,"product_component":214,"product_brand":8,"product_serie":1694,"product_misc":null,"product_qa":null,"pn":"","description":"PA-1410, Partner enabled premium support, 1 year (12 months) term, renewal.","created_by":1013,"created_at":"2025-08-19 16:53:04","updated_at":"2025-08-21 16:46:27","pinyin_shortcut":"PANSVCBKLN1410R","product_unit":2,"is_renew":true,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":214,"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1694,"key":1694,"name":"PA1410\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1855,"erp_sales_order_id":1566,"erp_store_id":null,"product_id":2108,"description":"","number":"1","outbound":"1","amount":"15340.00","total_amount":"15340","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"14573.00","total_cost":"14573","supplier_id":90,"hardware_from":null,"software_from":"2025-08-20","maintenance_from":null,"hardware_to":null,"software_to":"2026-08-20","maintenance_to":null}}],"commentCount":{"object_id":3949,"comment":3},"unreadComments":null,"fromContact":{"id":5980,"key":5980,"name":"\u738b\u5b66\u5a05","client_id":null,"supplier_id":90,"mobiles":[{"id":6767,"contact_id":5980,"mobile":"13811457427","mp_open_id":null}],"client":null,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"projectContactPoints":[],"erpSalesOrder":{"id":1566,"serial_no":"XSDD-20250819-00001","from_date":null,"wrote_date":"2025-08-19","handler":1001,"client_id":2845,"purchase_contract_id":null,"project_id":3949,"sales_contract_id":4106,"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-08-20 14:58:35","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"15340","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"1011\",\"5388\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2025-09-05\",\"amount\":\"15340\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-08-19 17:45:00","updated_at":"2025-08-20 14:58:35"},"projectUsedClient":{"id":177,"project_id":3949,"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":21,"progress_remain_display":21,"forecast_remain_display":21,"projectProductTotalAmount":15340,"projectProductAllAmount":true,"projectProductTotalCost":14573,"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":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","can_invoice":true,"can_payment":true,"duration_display":21,"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":"1.53\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":"15340","un_invoiced":0},{"id":3827,"client_id":1663,"project_status":3,"project_progress":9,"budget":"191000","profit_pct":"3.2","bargain_date":"2025-05-26","description":"","created_by":5300,"created_at":"2025-04-25 20:23:19","updated_at":"2025-08-22 14:43:43","engineer_id":null,"project_title":"PA\u7eed\u4fdd1\u5e74-C-2025","collected":"191000","status_updated_at":"2025-05-26 13:22:06.575872+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-05-26 10:22:25.643838+08","forecast_updated_at":"2025-05-26 10:22:25.643838+08","end_at":"2025-08-11 16:58:42","pinyin_shortcut":"PAxb1nC2025","creator":5300,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":869,"is_sales_order_ready":true,"collected_plan":191000,"change_status_to":null,"is_verify":false,"profits":"6112.00000000000000000","remain":"107 days 02:03:36.343664","progress_remain":"107 days 05:03:17.275698","forecast_remain":"107 days 05:03:17.275698","lost_contact_days":"82.2261911983333","last_contact":"2025-06-20 10:00:00","last_arrive_days":"113.011607865","last_arrive":"2025-05-20 15:09:00+08","duration":"107 days 20:35:22.888898","issued_invoices":"191000.00","client":{"id":1663,"key":1663,"name":"\u5317\u4eac\u8f66\u4e4b\u5bb6\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\u3010\u6c7d\u8f66\u4e4b\u5bb6-\u5317\u4eac\u76ae\u5c14\u5e03\u83b1\u5c3c\u8f6f\u4ef6\u6709\u9650\u516c\u53f8-\u5317\u4eac\u9f50\u5c14\u5e03\u83b1\u7279\u79d1\u6280\u6709\u9650\u516c\u53f8-\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011","logo":null,"client_type":5,"client_class":80,"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":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"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":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":"191000.00","pct":"3.2","profit":"6112","project_id":3827}],"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":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":3827,"points":"220"},"workLogCount":{"project_id":3827,"count":5},"caseCount":{"project_id":3827,"count":3},"salesTimeCount":{"project_id":3827,"hours":"2.5","times":3},"implementTimeCount":{"project_id":3827,"sum":"11.0833333333333","times":"3"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3827,"sum":"92.00"},"buildContract":{"id":3926,"from_project":3827,"payment_collection_remind_ahead":"7 days","serial_no":"ATPE-2025018","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"191000","erp_un_settle_amount":"0","including_tax":true,"amount":"191000","contractScans":[{"id":34651,"object_type":105,"object_id":3926,"attachment_id":25977,"attachment":{"id":25977,"key":25977,"name":"f6fc6df1-0852-3136-b743-024044ae7c60","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/f6fc6df1-0852-3136-b743-024044ae7c60\/\u6c7d\u8f66\u4e4b\u5bb6191000.pdf","orig_name":"\u6c7d\u8f66\u4e4b\u5bb6191000.pdf"}}],"receiptScans":[{"id":35313,"object_type":106,"object_id":3926,"attachment_id":26503,"attachment":{"id":26503,"key":26503,"name":"da8de3e0-0ba8-3214-a128-a60d94179e5d","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/da8de3e0-0ba8-3214-a128-a60d94179e5d\/img-623144250-0001.pdf","orig_name":"img-623144250-0001.pdf"}}],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[{"id":"11996","key":"11996","contract_id":3926,"value":"191000","created_by":5388,"createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":2065,"key":2065,"contract_id":3926,"value":"191000.00","attachment_id":null,"from_date":"2025-06-09","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2435,"key":2435,"contract_id":3926,"name":"2025-08-15","value":"191000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":8458,"user_id":5300,"key":5300,"contract_id":3926,"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":[{"id":2779,"contract_id":3926,"supplier_id":90,"purchase_id":3927,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3927,"key":3927,"serial_no":"X_2025SBQ13217"}},{"id":2780,"contract_id":3926,"supplier_id":90,"purchase_id":3928,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3928,"key":3928,"serial_no":"X_2025SBQ13223"}},{"id":2781,"contract_id":3926,"supplier_id":365,"purchase_id":3929,"supplier":{"id":365,"key":365,"name":"\u5317\u4eac\u767e\u8fbe\u4fe1\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3929,"key":3929,"serial_no":"TSKJ20250527-HYF-001"}}],"payment_collection_remind_ahead_display":"7\u5929","invoiced":191000},"projectRemindReceivers":[{"id":1532,"user_id":1001,"key":1001,"project_id":3827,"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":9705,"project_id":3827,"product_id":1623,"amount":"84895.00","number":1,"cost":"64000.00","description":"","supplier_id":90,"hardware_from":"2025-05-23","software_from":null,"maintenance_from":null,"hardware_to":"2026-05-22","software_to":null,"maintenance_to":null,"total_amount":"84895","total_cost":"64000","erp_sales_order_product_id":1678,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1623,"name":"PAN-SVC-BKLN-5220-R","product_type":5,"product_component":35,"product_brand":8,"product_serie":356,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:18:17","updated_at":"2024-05-28 17:18:17","pinyin_shortcut":"PANSVCBKLN5220R","product_unit":2,"is_renew":true,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":356,"key":356,"name":"PA5220\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1678,"erp_sales_order_id":1504,"erp_store_id":null,"product_id":1623,"description":"","number":"1","outbound":"0","amount":"84895.00","total_amount":"84895","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"64000.00","total_cost":"64000","supplier_id":90,"hardware_from":"2025-05-23","software_from":null,"maintenance_from":null,"hardware_to":"2026-05-22","software_to":null,"maintenance_to":null}},{"id":9706,"project_id":3827,"product_id":1983,"amount":"84045.00","number":1,"cost":"71000.00","description":"","supplier_id":90,"hardware_from":null,"software_from":"2025-05-23","maintenance_from":null,"hardware_to":null,"software_to":"2026-05-22","maintenance_to":null,"total_amount":"84045","total_cost":"71000","erp_sales_order_product_id":1679,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1983,"name":"PAN-PA-5220-TP-HA2-R","product_type":22,"product_component":200,"product_brand":8,"product_serie":1620,"product_misc":null,"product_qa":null,"pn":"","description":"Threatpreventionsubscriptionfor device inan HA pairrenewal,PA-5220","created_by":1013,"created_at":"2025-05-27 14:43:27","updated_at":"2025-05-27 14:43:27","pinyin_shortcut":"PANPA5220TPHA2R","product_unit":8,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1620,"key":1620,"name":"PA-5220\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":1679,"erp_sales_order_id":1504,"erp_store_id":null,"product_id":1983,"description":"","number":"1","outbound":"0","amount":"84045.00","total_amount":"84045","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"71000.00","total_cost":"71000","supplier_id":90,"hardware_from":null,"software_from":"2025-05-23","maintenance_from":null,"hardware_to":null,"software_to":"2026-05-22","maintenance_to":null}},{"id":9707,"project_id":3827,"product_id":1624,"amount":"22060.00","number":1,"cost":"14001.00","description":"\u5b9e\u964513\u4e2a\uff0c\u5355\u4ef7\uff1a1077","supplier_id":90,"hardware_from":null,"software_from":"2025-05-23","maintenance_from":null,"hardware_to":null,"software_to":"2026-05-22","maintenance_to":null,"total_amount":"22060","total_cost":"14001","erp_sales_order_product_id":1680,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2025-09-04 11:42:10","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1382,"key":1382,"name":"PA\u865a\u62df\u9632\u706b\u5899\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1680,"erp_sales_order_id":1504,"erp_store_id":null,"product_id":1624,"description":"\u5b9e\u964513\u4e2a\uff0c\u5355\u4ef7\uff1a1077","number":"1","outbound":"0","amount":"22060.00","total_amount":"22060","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"14001.00","total_cost":"14001","supplier_id":90,"hardware_from":null,"software_from":"2025-05-23","maintenance_from":null,"hardware_to":null,"software_to":"2026-05-22","maintenance_to":null}},{"id":9708,"project_id":3827,"product_id":942,"amount":"0","number":1,"cost":"30539.00","description":"","supplier_id":365,"hardware_from":null,"software_from":null,"maintenance_from":"2025-05-23","hardware_to":null,"software_to":null,"maintenance_to":"2026-05-22","total_amount":"0","total_cost":"30539","erp_sales_order_product_id":1681,"supplier":{"id":365,"key":365,"name":"\u5317\u4eac\u767e\u8fbe\u4fe1\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":134,"product_serie":593,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2025-08-25 16:06:57","pinyin_shortcut":"dsfwcjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1681,"erp_sales_order_id":1504,"erp_store_id":null,"product_id":942,"description":"","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"30539.00","total_cost":"30539","supplier_id":365,"hardware_from":null,"software_from":null,"maintenance_from":"2025-05-23","hardware_to":null,"software_to":null,"maintenance_to":"2026-05-22"}}],"commentCount":{"object_id":3827,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1504,"serial_no":"XSDD-20250728-00001","from_date":null,"wrote_date":"2025-05-26","handler":5300,"client_id":1663,"purchase_contract_id":null,"project_id":3827,"sales_contract_id":3926,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"4","amount":"191000","created_by":5300,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-05-26 13:22:06","updated_at":"2025-05-26 13:22:06"},"projectUsedClient":{"id":106,"project_id":3827,"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":107,"progress_remain_display":107,"forecast_remain_display":107,"projectProductTotalAmount":191000,"projectProductAllAmount":true,"projectProductTotalCost":179540,"projectProductAllCost":true,"projectProductTotalNumber":4,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"3\u4e2a\u6708\u524d","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":107,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"2\u4e2a\u6708\u524d","can_view_product":true,"budget_display":"19.1\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":"0","un_invoiced":0},{"id":3751,"client_id":2553,"project_status":3,"project_progress":9,"budget":"885300","profit_pct":"2.74","bargain_date":"2025-07-21","description":"","created_by":1001,"created_at":"2024-12-24 15:50:46","updated_at":"2025-08-22 09:55:12","engineer_id":null,"project_title":"10\u53f0 PA445 \u8bbe\u5907\u91c7\u8d2d\u9879\u76ee\uff08\u6c99\u7279\u9879\u76ee\uff09","collected":"0","status_updated_at":"2025-07-25 11:40:23.236058+08","success_rate":null,"comment":"\u62db\u6807\u7f16\u53f7\uff1aPOWRCHINA-0120009-250118","contract_type":1,"progress_updated_at":"2025-07-25 11:40:23.236058+08","forecast_updated_at":"2024-12-24 15:50:46.744407+08","end_at":"","pinyin_shortcut":"10tPA445sbcgxmstxm","creator":1001,"used_client":null,"from_contact":5957,"total_contact_point":"348931.5","paid_contact_point":"365","project_product_version_id":951,"is_sales_order_ready":true,"collected_plan":885300,"change_status_to":null,"is_verify":false,"profits":"24257.220000000000000000","remain":"47 days 03:45:19.683478","progress_remain":"47 days 03:45:19.683478","forecast_remain":"259 days 23:34:56.175129","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"259 days 23:34:56.175129","issued_invoices":"885300.00","client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"salesRep":{"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"}},"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":[],"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":"885300","pct":"2.74","profit":"24257.22","project_id":3751}],"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":182,"key":182,"name":"\u56f4\u6807"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesRep":{"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"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4055,"from_project":3751,"payment_collection_remind_ahead":"1 day","serial_no":"W-KJ-CG-KXMTYB-20250729-01","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"0","erp_un_settle_amount":"885300","including_tax":true,"amount":"885300","contractScans":[{"id":48644,"object_type":105,"object_id":4055,"attachment_id":27308,"attachment":{"id":27308,"key":27308,"name":"7dec0e3f-c47c-3e5e-b8b6-03f27a6b1f53","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/7dec0e3f-c47c-3e5e-b8b6-03f27a6b1f53\/\u91c7\u8d2d\u5408\u540c--\u6c99\u7279\u5361\u897f\u59c6\u3001\u5854\u4f0a\u5df4\u3001\u62c9\u6bd4\u683c\u56db\u3001\u54c8\u65af\u5f66\u9879\u76eePA\u8bbe\u5907\u91c7\u8d2d\u5408\u540c.pdf","orig_name":"\u91c7\u8d2d\u5408\u540c--\u6c99\u7279\u5361\u897f\u59c6\u3001\u5854\u4f0a\u5df4\u3001\u62c9\u6bd4\u683c\u56db\u3001\u54c8\u65af\u5f66\u9879\u76eePA\u8bbe\u5907\u91c7\u8d2d\u5408\u540c.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[],"salesContractInvoices":[{"id":2123,"key":2123,"contract_id":4055,"value":"619710.00","attachment_id":null,"from_date":"2025-08-21","attachment":null},{"id":2125,"key":2125,"contract_id":4055,"value":"-619710.00","attachment_id":null,"from_date":"2025-08-22","attachment":null},{"id":2127,"key":2127,"contract_id":4055,"value":"349291.20","attachment_id":null,"from_date":"2025-08-22","attachment":null},{"id":2128,"key":2128,"contract_id":4055,"value":"178669.60","attachment_id":null,"from_date":"2025-08-22","attachment":null},{"id":2129,"key":2129,"contract_id":4055,"value":"178669.60","attachment_id":null,"from_date":"2025-08-22","attachment":null},{"id":2130,"key":2130,"contract_id":4055,"value":"178669.60","attachment_id":null,"from_date":"2025-08-22","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2551,"key":2551,"contract_id":4055,"name":"2025-08-22","value":"619710","overdue_days":null,"pct":70,"collect_status":"\u903e\u671f19\u5929"},{"id":2552,"key":2552,"contract_id":4055,"name":"2025-09-12","value":"177060","overdue_days":null,"pct":20,"collect_status":""},{"id":2553,"key":2553,"contract_id":4055,"name":"2026-07-31","value":"88530","overdue_days":null,"pct":10,"collect_status":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":8836,"user_id":1001,"key":1001,"contract_id":4055,"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":8837,"user_id":5388,"key":5388,"contract_id":4055,"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":8838,"user_id":1011,"key":1011,"contract_id":4055,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}],"salesSupplierRels":[{"id":3131,"contract_id":4055,"supplier_id":90,"purchase_id":4056,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4056,"key":4056,"serial_no":"X_2025SBQ18249"}},{"id":3132,"contract_id":4055,"supplier_id":608,"purchase_id":4098,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchase":{"id":4098,"key":4098,"serial_no":"\u8ba2\u5355\u53f7: 4692052404660161702"}}],"payment_collection_remind_ahead_display":"1\u5929","invoiced":885300},"projectRemindReceivers":[{"id":1742,"user_id":1001,"key":1001,"project_id":3751,"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":10496,"project_id":3751,"product_id":2056,"amount":"0","number":4,"cost":"800.00","description":"\u8c03\u6574\u6295\u6807\u4ef7\u683c\uff0c4\u4e2a\u7535\u6e90\u7b97\u8d60\u9001","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"3200","erp_sales_order_product_id":1812,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":2056,"name":"PAN-PA-400-POE-PWR-150W","product_type":5,"product_component":157,"product_brand":8,"product_serie":1012,"product_misc":null,"product_qa":null,"pn":"","description":"150W Power Adaptor for PoE Enabled PA-415, PA-445, and PA-415-5G","created_by":1013,"created_at":"2025-07-21 14:50:36","updated_at":"2025-08-15 11:54:21","pinyin_shortcut":"PANPA400POEPWR150W","product_unit":3,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1012,"key":1012,"name":"PA-440\/450\/460\u7535\u6e90"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1812,"erp_sales_order_id":1553,"erp_store_id":null,"product_id":2056,"description":"\u8c03\u6574\u6295\u6807\u4ef7\u683c\uff0c4\u4e2a\u7535\u6e90\u7b97\u8d60\u9001","number":"4","outbound":"4","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"800.00","total_cost":"3200","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10491,"project_id":3751,"product_id":2055,"amount":"22137.00","number":10,"cost":"13200.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"221370","total_cost":"132000","erp_sales_order_product_id":1807,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":2055,"name":"PAN-PA-445","product_type":5,"product_component":26,"product_brand":8,"product_serie":1663,"product_misc":null,"product_qa":null,"pn":"","description":"Palo Alto Networks PA-445","created_by":1013,"created_at":"2025-07-21 14:49:47","updated_at":"2025-08-15 11:54:21","pinyin_shortcut":"PANPA445","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":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1663,"key":1663,"name":"PA-445\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1807,"erp_sales_order_id":1553,"erp_store_id":null,"product_id":2055,"description":"","number":"10","outbound":"10","amount":"22137.00","total_amount":"221370","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"13200.00","total_cost":"132000","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10492,"project_id":3751,"product_id":2058,"amount":"15644.80","number":10,"cost":"16764.60","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"156448","total_cost":"167646","erp_sales_order_product_id":1808,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":2058,"name":"PAN-PA-445-BND-CORESEC-3YR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1664,"product_misc":null,"product_qa":null,"pn":"","description":"PA-445, Precision AI Network Security Subscription Bundle (Advanced Threat Prevention, Advanced URL Filtering, Advanced Wildfire, Advanced DNS Security and Advanced SD-WAN ), 3 years (36 months) term","created_by":1013,"created_at":"2025-07-21 14:53:01","updated_at":"2025-08-15 11:54:21","pinyin_shortcut":"PANPA445BNDCORESEC3YR","product_unit":3,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1664,"key":1664,"name":"PA445\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1808,"erp_sales_order_id":1553,"erp_store_id":null,"product_id":2058,"description":"","number":"10","outbound":"10","amount":"15644.80","total_amount":"156448","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"16764.60","total_cost":"167646","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10493,"project_id":3751,"product_id":2056,"amount":"5365.33","number":6,"cost":"800.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"32192.00","total_cost":"4800","erp_sales_order_product_id":1809,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":2056,"name":"PAN-PA-400-POE-PWR-150W","product_type":5,"product_component":157,"product_brand":8,"product_serie":1012,"product_misc":null,"product_qa":null,"pn":"","description":"150W Power Adaptor for PoE Enabled PA-415, PA-445, and PA-415-5G","created_by":1013,"created_at":"2025-07-21 14:50:36","updated_at":"2025-08-15 11:54:21","pinyin_shortcut":"PANPA400POEPWR150W","product_unit":3,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1012,"key":1012,"name":"PA-440\/450\/460\u7535\u6e90"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1809,"erp_sales_order_id":1553,"erp_store_id":null,"product_id":2056,"description":"","number":"6","outbound":"6","amount":"5365.33","total_amount":"32192.00","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"800.00","total_cost":"4800","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10494,"project_id":3751,"product_id":2059,"amount":"44217.00","number":10,"cost":"6900.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"442170","total_cost":"69000","erp_sales_order_product_id":1810,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":2059,"name":"PAN-SVC-PREM-445-3YR","product_type":5,"product_component":214,"product_brand":8,"product_serie":1665,"product_misc":null,"product_qa":null,"pn":"","description":"PA-445, Premium support, 3 years (36 months) term","created_by":1013,"created_at":"2025-07-21 14:55:55","updated_at":"2025-08-15 11:54:21","pinyin_shortcut":"PANSVCPREM4453YR","product_unit":3,"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":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1665,"key":1665,"name":"PA445\u4e09\u5e74\u670d\u52a1"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1810,"erp_sales_order_id":1553,"erp_store_id":null,"product_id":2059,"description":"","number":"10","outbound":"10","amount":"44217.00","total_amount":"442170","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"6900.00","total_cost":"69000","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10495,"project_id":3751,"product_id":2057,"amount":"3312.00","number":10,"cost":"800.00","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"33120","total_cost":"8000","erp_sales_order_product_id":1811,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":2057,"name":"PAN-PA-400-POE-RACKTRAY","product_type":5,"product_component":157,"product_brand":8,"product_serie":615,"product_misc":null,"product_qa":null,"pn":"","description":"Rack-Mountable Tray for PoE enabled PA-415 and PA-445","created_by":1013,"created_at":"2025-07-21 14:51:17","updated_at":"2025-08-15 11:54:21","pinyin_shortcut":"PANPA400POERACKTRAY","product_unit":3,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":615,"key":615,"name":"PA-440\/450\/460\u5bfc\u8f68"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1811,"erp_sales_order_id":1553,"erp_store_id":null,"product_id":2057,"description":"","number":"10","outbound":"10","amount":"3312.00","total_amount":"33120","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"800.00","total_cost":"8000","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3751,"comment":2},"unreadComments":null,"fromContact":{"id":5957,"key":5957,"name":"\u674e\u777f\uff08Rick Li\uff09","client_id":null,"supplier_id":100,"mobiles":[{"id":6746,"contact_id":5957,"mobile":"13910153435","mp_open_id":null}],"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPoints":[{"id":1130,"project_id":3751,"contact_id":5957,"point":"348931.50","paid_point":"365","contact":{"id":5957,"key":5957,"name":"\u674e\u777f\uff08Rick Li\uff09","client_id":null,"supplier_id":100,"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPointRels":[{"id":214,"project_id":3751,"contact_id":5957,"point":"365.00","day_at":"2025-08-21","description":"20\u6761\u7535\u6e90\u7ebf","created_at":"2025-08-21 12:20:40"}],"status_display":"\u672a\u6838\u9500"}],"erpSalesOrder":{"id":1553,"serial_no":"XSDD-20250807-00001","from_date":null,"wrote_date":"2025-07-21","handler":1001,"client_id":2553,"purchase_contract_id":null,"project_id":3751,"sales_contract_id":4055,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"50","amount":"885300","created_by":1001,"stop_description":null,"extra":null,"outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-07-21 14:10:34","updated_at":"2025-07-21 14:10:34"},"projectUsedClient":{"id":153,"project_id":3751,"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":47,"progress_remain_display":47,"forecast_remain_display":259,"projectProductTotalAmount":885300,"projectProductAllAmount":true,"projectProductTotalCost":384646,"projectProductAllCost":true,"projectProductTotalNumber":50,"unissued_invoice":0,"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":259,"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":"88.53\u4e07","contact_points_status_display":"\u672a\u6838\u9500","verify_display":0,"un_collected":"885300","un_invoiced":0},{"id":3931,"client_id":3384,"project_status":3,"project_progress":6,"budget":"300000","profit_pct":"5","bargain_date":"2025-08-05","description":"","created_by":1005,"created_at":"2025-07-27 23:30:12","updated_at":"2025-08-20 16:24:16","engineer_id":null,"project_title":"\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u9879\u76ee","collected":"0","status_updated_at":"2025-08-20 11:29:52.139839+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-07-27 23:30:12.784553+08","forecast_updated_at":"2025-07-27 23:30:12.784553+08","end_at":"","pinyin_shortcut":"sxfswxwglxm","creator":1005,"used_client":null,"from_contact":4844,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":986,"is_sales_order_ready":false,"collected_plan":300000,"change_status_to":null,"is_verify":false,"profits":"15000.0000000000000000","remain":"21 days 03:55:50.779697","progress_remain":"44 days 15:55:30.134983","forecast_remain":"44 days 15:55:30.134983","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"44 days 15:55:30.134983","issued_invoices":null,"client":{"id":3384,"key":3384,"name":"\u5e7f\u5dde\u7eb3\u667a\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"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":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectProductTypes":[{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"300000","pct":"5","profit":"15000","project_id":3931}],"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":130,"key":130,"name":"\u7ade\u4e89\u8c08\u5224"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4105,"from_project":3931,"payment_collection_remind_ahead":"1 day","serial_no":"TS-ZHY-20250408001","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"0","erp_un_settle_amount":"300000","including_tax":true,"amount":"300000","contractScans":[{"id":48678,"object_type":105,"object_id":4105,"attachment_id":27657,"attachment":{"id":27657,"key":27657,"name":"9bcaa591-d846-3f60-9d0e-f962107ea9d5","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/9bcaa591-d846-3f60-9d0e-f962107ea9d5\/\u5e7f\u5dde\u7eb3\u667a\u901a30\u4e07\u5408\u540c.pdf","orig_name":"\u5e7f\u5dde\u7eb3\u667a\u901a30\u4e07\u5408\u540c.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2548,"key":2548,"contract_id":4105,"name":"2025-09-30","value":"300000","overdue_days":null,"pct":100,"collect_status":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":8831,"user_id":1005,"key":1005,"contract_id":4105,"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"}}}],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"1\u5929","invoiced":0},"projectRemindReceivers":[],"projectProductRels":[{"id":10670,"project_id":3931,"product_id":1717,"amount":"300000.00","number":1,"cost":"285000.00","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"300000","total_cost":"285000","erp_sales_order_product_id":1856,"supplier":null,"product":{"id":1717,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1455,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-05 15:18:36","updated_at":"2025-08-20 11:08:18","pinyin_shortcut":"sxfcpzbrjsjfwsyyAC1000B1400","product_unit":2,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1455,"key":1455,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1856,"erp_sales_order_id":1567,"erp_store_id":null,"product_id":1717,"description":"","number":"1","outbound":"0","amount":"300000.00","total_amount":"300000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"285000.00","total_cost":"285000","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3931,"comment":2},"unreadComments":null,"fromContact":{"id":4844,"key":4844,"name":"\u738b\u660e\u4eae","client_id":2598,"supplier_id":null,"mobiles":[{"id":5639,"contact_id":4844,"mobile":"13011820912","mp_open_id":null}],"client":{"id":2598,"key":2598,"name":"\u5173\u7cfb\u6237"},"supplier":null},"projectContactPoints":[],"erpSalesOrder":{"id":1567,"serial_no":"XSDD-20250820-00001","from_date":null,"wrote_date":"2025-08-20","handler":1005,"client_id":3384,"purchase_contract_id":null,"project_id":3931,"sales_contract_id":4105,"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-08-20 14:55:55","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"300000","created_by":1005,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1005\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2025-09-30\",\"amount\":\"300000\",\"pct\":\"100\"}]}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-08-20 11:29:52","updated_at":"2025-08-20 14:55:55"},"projectUsedClient":{"id":172,"project_id":3931,"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":21,"progress_remain_display":44,"forecast_remain_display":44,"projectProductTotalAmount":300000,"projectProductAllAmount":true,"projectProductTotalCost":285000,"projectProductAllCost":true,"projectProductTotalNumber":1,"unissued_invoice":300000,"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":44,"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":"30\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":"300000","un_invoiced":300000},{"id":3902,"client_id":3376,"project_status":3,"project_progress":9,"budget":"600000","profit_pct":"6.94","bargain_date":"2025-06-30","description":"","created_by":1005,"created_at":"2025-06-30 12:02:35","updated_at":"2025-08-20 13:11:47","engineer_id":null,"project_title":"\u5b81\u6ce2\u6570\u5b57\u5b89\u5168\u4ea7\u4e1a\u57fa\u5730","collected":"300000","status_updated_at":"2025-06-30 12:05:19.732104+08","success_rate":null,"comment":"\u6709\u79ef\u5206\uff0c\u672a\u8ba1\u7b97","contract_type":1,"progress_updated_at":"2025-06-30 12:02:35.431859+08","forecast_updated_at":"2025-06-30 12:02:35.431859+08","end_at":"","pinyin_shortcut":"nbszaqcyjd","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":"110679","paid_contact_point":null,"project_product_version_id":944,"is_sales_order_ready":true,"collected_plan":600000,"change_status_to":null,"is_verify":false,"profits":"41640.000000000000000000","remain":"72 days 03:20:23.187432","progress_remain":"72 days 03:23:07.487677","forecast_remain":"72 days 03:23:07.487677","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"72 days 03:23:07.487677","issued_invoices":"600000.00","client":{"id":3376,"key":3376,"name":"\u8fb0\u5c79\u5bf0\u5b87\uff08\u4e0a\u6d77\uff09\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"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":[],"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":69,"product_type_id":69,"key":69,"name":"\u5907\u4efd","budget":"600000","pct":"6.94","profit":"41640","project_id":3902}],"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":130,"key":130,"name":"\u7ade\u4e89\u8c08\u5224"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4002,"from_project":3902,"payment_collection_remind_ahead":"1 day","serial_no":"TSKJ20250630-ZHY-001","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"300000","erp_un_settle_amount":"300000","including_tax":true,"amount":"600000","contractScans":[{"id":36084,"object_type":105,"object_id":4002,"attachment_id":26643,"attachment":{"id":26643,"key":26643,"name":"dc4d5b85-c541-3a0e-bb4e-66b0a7091df2","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/dc4d5b85-c541-3a0e-bb4e-66b0a7091df2\/2025_07_01_17_06_22.pdf","orig_name":"2025_07_01_17_06_22.pdf"}}],"receiptScans":[{"id":37571,"object_type":106,"object_id":4002,"attachment_id":27307,"attachment":{"id":27307,"key":27307,"name":"af2c3f4a-514d-3046-879b-40922af50cd9","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/af2c3f4a-514d-3046-879b-40922af50cd9\/\u8d27\u7269\u7b7e\u6536\u5355.pdf","orig_name":"\u8d27\u7269\u7b7e\u6536\u5355.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":327,"serial_no":"SKD-20250714-00001","wrote_date":"2025-07-14","from_date":null,"handler":1005,"user_id":null,"client_id":3376,"sales_contract_id":4002,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2025-07-14 17:04:34","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"300000","settle_amount":"300000","created_by":1013,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2025-07-14 17:04:34","updated_at":"2025-07-14 17:04:34","paid_amount":null,"contact_id":null}],"salesContractPayments":[{"id":"1327","key":"1327","contract_id":4002,"value":"300000","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":50}],"salesContractInvoices":[{"id":2089,"key":2089,"contract_id":4002,"value":"600000.00","attachment_id":null,"from_date":"2025-06-30","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2530,"key":2530,"contract_id":4002,"name":"2025-07-31","value":"300000","overdue_days":null,"pct":50,"collect_status":"\u5df2\u5b8c\u6210"},{"id":2531,"key":2531,"contract_id":4002,"name":"2025-08-30","value":"90000","overdue_days":null,"pct":15,"collect_status":"\u903e\u671f11\u5929"},{"id":2532,"key":2532,"contract_id":4002,"name":"2025-09-30","value":"60000","overdue_days":null,"pct":10,"collect_status":""},{"id":2533,"key":2533,"contract_id":4002,"name":"2025-12-31","value":"150000","overdue_days":null,"pct":25,"collect_status":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":8762,"user_id":1005,"key":1005,"contract_id":4002,"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"}}}],"salesSupplierRels":[{"id":3041,"contract_id":4002,"supplier_id":661,"purchase_id":4003,"supplier":{"id":661,"key":661,"name":"\u822a\u5929\u58f9\u8fdb\u5236\uff08\u6c5f\u82cf\uff09\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4003,"key":4003,"serial_no":"Unary-SO-2025061703"}},{"id":3042,"contract_id":4002,"supplier_id":107,"purchase_id":4032,"supplier":{"id":107,"key":107,"name":"\u5317\u4eac\u878d\u521b\u777f\u901a\u6280\u672f\u5f00\u53d1\u6709\u9650\u516c\u53f8"},"purchase":{"id":4032,"key":4032,"serial_no":"BJ-RCRT-2025-07-14-001"}}],"payment_collection_remind_ahead_display":"1\u5929","invoiced":600000},"projectRemindReceivers":[],"projectProductRels":[{"id":10543,"project_id":3902,"product_id":2027,"amount":"0","number":2,"cost":"24550.00","description":"","supplier_id":107,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"49100","erp_sales_order_product_id":1735,"supplier":{"id":107,"key":107,"name":"\u5317\u4eac\u878d\u521b\u777f\u901a\u6280\u672f\u5f00\u53d1\u6709\u9650\u516c\u53f8"},"product":{"id":2027,"name":"TaiShan200 (\u53cc\u8def\u9cb2\u9e4f920 2.6GHz CPU\uff0c64G DDR4\u5185\u5b58\uff0c2*480G SSD;1G\u7f13\u5b58\u7684\u786cRAID\u5361\uff0c2\u4e2a\u5343\u5146\u7535\u53e3\uff0c2\u4e2a\u4e07\u5146\u5149\u53e3(\u5e26\u6a21\u5757)\uff0c12* 10T3.5\u5bf8 \u786c\u76d8\uff0c\u5197\u4f59\u7535\u6e90900W)","product_type":2,"product_component":2,"product_brand":7,"product_serie":1653,"product_misc":null,"product_qa":null,"pn":"","description":"2U\u673a\u67b6\u5f0f\u670d\u52a1\u5668(\u542b\u5bfc\u8f68)\uff0c12\u4e2a3.5\"\u70ed\u63d2\u62d4\u76d8\u4f4d\uff0c\u53cc\u8def32\u6838\u9cb2\u9e4f920\n2.6GHz CPU\uff0c64G DDR4\u5185\u5b58\uff0c\u53cc\u9ad8\u901f480G SSD\u7cfb\u7edf\u76d8;\u652f\u6301raid0,1,5\uff0c6\uff0c10\uff0c50\uff0c60\uff0c\u652f\u63013.5\u201d\u6570\u636e\u76d8\uff0c\u6807\u914d\u542b1G\u7f13\u5b58\u7684\u786cRAID\u5361\uff0c\u53ef\u6269\u5c55\u6389\u7535\u4fdd\u62a4\uff0c\u9ed8\u8ba42\u4e2a\u5343\u5146\u7535\u53e3\uff0c2\u4e2a\u4e07\u5146\u5149\u53e3(\u5e26\u6a21\u5757)\uff0c\u914d\u7f6e12\u575710T 3.5\u5bf8 7200RPM\u786c\u76d8\u3002(\u989d\u5916\u63d0\u4f9b3\u4e2aPCIe\u63d2\u69fd)\u53ef\u6269\u5c55\u7f51\u5361\u3001 HBA\u5361\uff0c\u5197\u4f59\u7535\u6e90900W\u3002","created_by":1013,"created_at":"2025-07-01 14:09:20","updated_at":"2025-07-01 14:09:20","pinyin_shortcut":"TaiShan200slkp92026GHzCPU64GDDR4nc2480GSSD1GhcdyRAIDk2gqzdk2gwzgkdmk1210T35cyprydy900W","product_unit":1,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":7,"key":7,"name":"\u534e\u4e3a"},"productSerie":{"id":1653,"key":1653,"name":"\u9cb2\u9e4fTaiShan\u670d\u52a1\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1735,"erp_sales_order_id":1530,"erp_store_id":null,"product_id":2027,"description":"","number":"2","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"24550.00","total_cost":"49100","supplier_id":107,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10544,"project_id":3902,"product_id":2026,"amount":"0","number":1,"cost":"36050.00","description":"","supplier_id":107,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"36050","erp_sales_order_product_id":1736,"supplier":{"id":107,"key":107,"name":"\u5317\u4eac\u878d\u521b\u777f\u901a\u6280\u672f\u5f00\u53d1\u6709\u9650\u516c\u53f8"},"product":{"id":2026,"name":"TaiShan200(\u53cc\u8def\u9cb2\u9e4f920 2.6GHz CPU\uff0c128G DDR4\u5185\u5b58\uff0c2*480G SSD;1G\u7f13\u5b58\u7684\u786cRAID\u5361\uff0c2\u4e2a\u5343\u5146\u7535\u53e3\uff0c2\u4e2a\u4e07\u5146\u5149\u53e3(\u5e26\u6a21\u5757)\uff0c3* 8T3.5\u5bf8 \u786c\u76d8\uff0c\u5197\u4f59\u7535\u6e90900W)","product_type":2,"product_component":2,"product_brand":7,"product_serie":1653,"product_misc":null,"product_qa":null,"pn":"","description":"2U\u673a\u67b6\u5f0f\u670d\u52a1\u5668(\u542b\u5bfc\u8f68)\uff0c12\u4e2a3.5\"\u70ed\u63d2\u62d4\u76d8\u4f4d\uff0c\u53cc\u8def32\u6838\u9cb2\u9e4f920\n2.6GHz CPU\uff0c128G DDR4\u5185\u5b58\uff0c\u53cc\u9ad8\u901f480G SSD\u7cfb\u7edf\u76d8;\u652f\u6301raido,1,5,6\uff0c10\uff0c50\uff0c60\uff0c\u652f\u63013.5\u201d\u6570\u636e\u76d8\uff0c\u6807\u914d\u542b1G\u7f13\u5b58\u7684\u786cRAID\u5361\uff0c\u53ef\u6269\u5c55\u6389\u7535\u4fdd\u62a4 \uff0c\u9ed8\u8ba42\u4e2a\u5343\u5146\u7535\u53e3\uff0c2\u4e2a\u4e07\u5146\u5149\u53e3(\u5e26\u6a21\u5757)\uff0c\u914d\u7f6e3\u5757 8T3.5\u5bf8 7200RPM\u786c\u76d8\u3002(\u989d\u5916\u63d0\u4f9b3\u4e2aPCIe\u63d2\u69fd)\u53ef\u6269\u5c55\u7f51\u5361\u3001HBA\u5361\uff0c\u5197\u4f59\u7535\u6e90900W\u3002","created_by":1013,"created_at":"2025-07-01 14:08:33","updated_at":"2025-07-01 14:08:33","pinyin_shortcut":"TaiShan200slkp92026GHzCPU128GDDR4nc2480GSSD1GhcdyRAIDk2gqzdk2gwzgkdmk38T35cyprydy900W","product_unit":1,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":7,"key":7,"name":"\u534e\u4e3a"},"productSerie":{"id":1653,"key":1653,"name":"\u9cb2\u9e4fTaiShan\u670d\u52a1\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1736,"erp_sales_order_id":1530,"erp_store_id":null,"product_id":2026,"description":"","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"36050.00","total_cost":"36050","supplier_id":107,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10545,"project_id":3902,"product_id":2023,"amount":"150000.00","number":2,"cost":"79904.00","description":"","supplier_id":661,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"300000","total_cost":"159808","erp_sales_order_product_id":1737,"supplier":{"id":661,"key":661,"name":"\u822a\u5929\u58f9\u8fdb\u5236\uff08\u6c5f\u82cf\uff09\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":2023,"name":"\u707e\u5907\u4e91\u5e73\u53f0 \u58f9\u8fdb\u5236 UnaCloudP-Master3012","product_type":4,"product_component":219,"product_brand":227,"product_serie":1651,"product_misc":null,"product_qa":null,"pn":"","description":"\u4e3b\u63a7\u670d\u52a1\u8282\u70b9\uff1a\u58f9\u8fdb\u5236\u707e\u5907\u4e91\u7cfb\u7edf\u8f6f\u4ef6\uff08\u4e13\u4e1a\u7248\uff09\uff0c\u63d0\u4f9b\u5b8c\u6574\u7684\u707e\u5907\u670d\u52a1\u529f\u80fd\u4ee5\u53ca\u9762\u5411\u591a\u79df\u6237\u573a\u666f\u7684\u8fd0\u8425\u8fd0\u7ef4\u7ba1\u7406\u652f\u6301\u3002\u4e3b\u8981\u9762\u5411\u4e2d\u5c0f\u578b\u5171\u4eab\u707e\u5907\u573a\u666f\uff08\u6570\u636e\u91cf500T-4PB\uff0c\u7528\u6237\u91cf\u6700\u591a300\uff09\uff0c\u53ef\u81ea\u4e3b\u5f0f\u5b89\u88c5\u5728\u79c1\u6709\u4e91\u6216\u516c\u6709\u4e91\u7b49\u591a\u79cd\u73af\u5883\u4e2d\uff0c\u9762\u5411\u4e2d\u5c0f\u578b\u4e91\u6570\u636e\u4e2d\u5fc3\u3001\u591a\u5206\u652f\u673a\u6784\u7b49\u573a\u666f\uff0c\u63d0\u4f9b\u4ee5\u4e0b\u707e\u5907\u4e1a\u52a1\u670d\u52a1\u53ca\u57fa\u4e8e\u591a\u79df\u6237\u4f53\u7cfb\u7684\u8fd0\u8425\u8fd0\u7ef4\u4ee5\u53ca\u8d44\u6e90\u7ba1\u7406\u529f\u80fd\u3002\n\u707e\u5907\u4e1a\u52a1\u529f\u80fd\uff1a\u5305\u542b\u5b8c\u6574\u7684\u5e73\u53f0\u6267\u884c\u6846\u67b6\uff0c\u63d0\u4f9b\u707e\u5907\u4efb\u52a1\u6267\u884c\u3001\u707e\u5907\u4f5c\u4e1a\u96c6\u4e2d\u7ba1\u63a7\u3001\u81ea\u8eab\u5305\u542b\u5b9a\u65f6\u5907\u4efd\u529f\u80fd\u6388\u6743\uff0c\u4e0d\u5305\u542b\u5bb9\u91cf\u6388\u6743\uff0c\u5fc5\u987b\u9009\u62e9\u76f8\u5173\u5907\u4efd\u5bb9\u91cf\u6388\u6743\u3002\n\u591a\u79df\u6237\u8fd0\u8425\u8fd0\u7ef4\u529f\u80fd\uff1a\u63d0\u4f9b\u707e\u5907\u79df\u6237\u7ba1\u7406\u3001\u670d\u52a1\u8282\u70b9\u7edf\u4e00\u7ba1\u7406\u3001\u8fd0\u8425\u7ba1\u7406\u3001\u8fd0\u7ef4\u7ba1\u7406\u3001\u62a5\u8868\u7ba1\u7406\u7b49\u529f\u80fd\u3002\u58f9\u8fdb\u5236\u707e\u5907\u4e91\u7cfb\u7edf\u8f6f\u4ef6\uff08\u4e13\u4e1a\u7248\uff09\u652f\u6301\u4e0d\u8d85\u8fc7300\u4e2a\u7528\u6237\u8d26\u6237\u3002\n\u8d44\u6e90\u7ba1\u7406\u529f\u80fd\uff1a\u652f\u6301\u96c6\u4e2d\u7ba1\u7406\u63a5\u5165\u7684\u707e\u5907\u4e91\u4ecb\u8d28\u8282\u70b9\u3001\u652f\u6301\u5c06\u707e\u5907\u4e91\u4ecb\u8d28\u8282\u70b9\u8d44\u6e90\u5206\u914d\u7ed9\u79df\u6237\u3002\n\u58f9\u8fdb\u5236\u707e\u5907\u4e91\u7cfb\u7edf\uff08\u4e13\u4e1a\u7248\uff09\u7cfb\u7edf\u5185\u9ed8\u8ba4\u5305\u542b2\u4e2a\u4ecb\u8d28\u670d\u52a1\u5668\u8282\u70b9\u63a5\u5165\u6388\u6743\uff0c\u6700\u5927\u652f\u630124\u4e2a\u4ecb\u8d28\u670d\u52a1\u5668\u8282\u70b9\u3002\n\u4ecb\u8d28\u670d\u52a1\u5668\u8282\u70b9\u8f6f\u4ef6\u53ef\u4ee5\u901a\u8fc7\u754c\u9762\u4e0b\u8f7d\u6216\u63d0\u4f9b\u7b26\u5408\u4e91\u5e73\u53f0\u683c\u5f0f\u7684\u955c\u50cf\u4ee5\u8fdb\u884c\u5feb\u901f\u90e8\u7f72\uff0c\u4ea6\u53ef\u9009\u62e9\u90e8\u7f72\u5728\u4e13\u7528\u4ecb\u8d28\u670d\u52a1\u5668\u786c\u4ef6\u6216\u7b26\u5408\u8981\u6c42\u7684\u786c\u4ef6\u4e0a\u3002\n\u90e8\u7f72\u73af\u5883\uff1a\u4e0d\u4f4e\u4e8e8C CPU\uff0c\u4e0d\u4f4e\u4e8e32G\u5185\u5b58 \uff0c\u4e0d\u4f4e\u4e8e500G\u5b58\u50a8\u7a7a\u95f4\uff0cCentOS 7.6 \u64cd\u4f5c\u7cfb\u7edf\u3002\n\u8f6f\u4ef6\uff1a\u63d0\u4f9b\u707e\u5907\u4e91\u7cfb\u7edf\u8f6f\u4ef6\u7684\u707e\u5907\u79df\u6237\u7ba1\u7406\u3001\u670d\u52a1\u8282\u70b9\u7edf\u4e00\u7ba1\u7406\u3001\u707e\u5907\u4f5c\u4e1a\u96c6\u4e2d\u7ba1\u63a7\uff0c\u8fd0\u8425\u7ba1\u7406\u3001\u8fd0\u7ef4\u7ba1\u7406\u3001\u62a5\u8868\u7ba1\u7406\u7b49\u529f\u80fd\u3002","created_by":1013,"created_at":"2025-07-01 11:16:22","updated_at":"2025-07-01 16:22:26","pinyin_shortcut":"zbyptyjzUnaCloudPMaster3012","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":219,"key":219,"name":"\u707e\u5907\u4e91\u5e73\u53f0"},"productBrand":{"id":227,"key":227,"name":"\u58f9\u8fdb\u5236"},"productSerie":{"id":1651,"key":1651,"name":"\u58f9\u8fdb\u5236\u5bb9\u707e\u5907\u4efd\u73af\u5883"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1737,"erp_sales_order_id":1530,"erp_store_id":null,"product_id":2023,"description":"","number":"2","outbound":"0","amount":"150000.00","total_amount":"300000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"79904.00","total_cost":"159808","supplier_id":661,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10546,"project_id":3902,"product_id":2024,"amount":"160000.00","number":1,"cost":"72345.00","description":"","supplier_id":661,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"160000","total_cost":"72345","erp_sales_order_product_id":1738,"supplier":{"id":661,"key":661,"name":"\u822a\u5929\u58f9\u8fdb\u5236\uff08\u6c5f\u82cf\uff09\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":2024,"name":"\u707e\u5907\u4e91\u4ecb\u8d28\u8282\u70b9 \u58f9\u8fdb\u5236 UnaCloudP-UnaMDS3012","product_type":4,"product_component":219,"product_brand":227,"product_serie":1651,"product_misc":null,"product_qa":null,"pn":"","description":"1\u4e2a\u58f9\u8fdb\u5236\u707e\u5907\u4e91\u7cfb\u7edf\u8f6f\u4ef6 \u4ecb\u8d28\u8282\u70b9\uff08\u8f6f\u4ef6\u7248\/\u8f6f\u786c\u4e00\u4f53\u7248\uff09\u63a5\u5165\u6388\u6743\n\u63d0\u4f9b\u5c06\u4ecb\u8d28\u670d\u52a1\u5668\u8282\u70b9\u63a5\u5165\u58f9\u8fdb\u5236\u707e\u5907\u4e91\u7cfb\u7edf\u7684\u6388\u6743\u8bb8\u53ef\u3002","created_by":1013,"created_at":"2025-07-01 11:17:07","updated_at":"2025-07-01 16:20:47","pinyin_shortcut":"zbyjzjdyjzUnaCloudPUnaMDS3012","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":219,"key":219,"name":"\u707e\u5907\u4e91\u5e73\u53f0"},"productBrand":{"id":227,"key":227,"name":"\u58f9\u8fdb\u5236"},"productSerie":{"id":1651,"key":1651,"name":"\u58f9\u8fdb\u5236\u5bb9\u707e\u5907\u4efd\u73af\u5883"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1738,"erp_sales_order_id":1530,"erp_store_id":null,"product_id":2024,"description":"","number":"1","outbound":"0","amount":"160000.00","total_amount":"160000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"72345.00","total_cost":"72345","supplier_id":661,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10547,"project_id":3902,"product_id":2025,"amount":"140000.00","number":1,"cost":"74747.00","description":"","supplier_id":661,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"140000","total_cost":"74747","erp_sales_order_product_id":1739,"supplier":{"id":661,"key":661,"name":"\u822a\u5929\u58f9\u8fdb\u5236\uff08\u6c5f\u82cf\uff09\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":2025,"name":"\u5bb9\u91cf\u6388\u6743 \u58f9\u8fdb\u5236 UnaRDP-100T","product_type":7,"product_component":30,"product_brand":227,"product_serie":1600,"product_misc":null,"product_qa":null,"pn":"","description":"\u9ed1\u65b9\u5bb9\u707e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6V6 \n\u5b9a\u65f6\u5907\u4efd\u5bb9\u91cf\u6388\u6743\uff0c\u65e0\u9650\u5907\u4efd\u4e3b\u673a\u6570\u91cf,100TB\u6388\u6743\u3002","created_by":1013,"created_at":"2025-07-01 11:19:20","updated_at":"2025-07-15 10:20:23","pinyin_shortcut":"rlsqyjzUnaRDP100T","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":227,"key":227,"name":"\u58f9\u8fdb\u5236"},"productSerie":{"id":1600,"key":1600,"name":"\u58f9\u8fdb\u5236\u9ed1\u65b9\u5bb9\u707e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6 V6.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1739,"erp_sales_order_id":1530,"erp_store_id":null,"product_id":2025,"description":"","number":"1","outbound":"0","amount":"140000.00","total_amount":"140000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"74747.00","total_cost":"74747","supplier_id":661,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3902,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":1101,"project_id":3902,"contact_id":6008,"point":"110679.00","paid_point":null,"contact":{"id":6008,"key":6008,"name":"\u6c6a\u4e91\u98de","client_id":3336,"supplier_id":null,"client":{"id":3336,"key":3336,"name":"\u58f9\u8fdb\u5236\uff08\u5382\u5546\uff09"},"supplier":null},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"}],"erpSalesOrder":{"id":1530,"serial_no":"XSDD-20250804-00001","from_date":null,"wrote_date":"2025-06-30","handler":1005,"client_id":3376,"purchase_contract_id":null,"project_id":3902,"sales_contract_id":4002,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"7","amount":"600000","created_by":1005,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-06-30 12:05:19","updated_at":"2025-06-30 12:05:19"},"projectUsedClient":{"id":140,"project_id":3902,"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":72,"progress_remain_display":72,"forecast_remain_display":72,"projectProductTotalAmount":600000,"projectProductAllAmount":true,"projectProductTotalCost":392050,"projectProductAllCost":true,"projectProductTotalNumber":7,"unissued_invoice":0,"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":72,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"60\u4e07","contact_points_status_display":"\u672a\u6838\u9500","verify_display":0,"un_collected":"300000","un_invoiced":0}],"pagenation":{"totalcount":324,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-10 15:25:43') RETURNING "id" |