68955e77c03b2: POST https://beta.jinchangxiao.com/v2/project/of-client at 2025-08-08 10:18:31 am by 223.104.39.199
Database Queries
总计85条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 10:18:32.021 | 3.4 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA' |
| 10:18:32.027 | 2.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 10:18:32.033 | 1.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='90') AND ("deleted"=FALSE) |
| 10:18:32.039 | 17.8 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 (5295, 5311)) OR ("prr"."user_id"=5295) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295))) AND ("p"."client_id"=90) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC) "c" |
| 10:18:32.057 | 18.0 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 (5295, 5311)) OR ("prr"."user_id"=5295) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295))) AND ("p"."client_id"=90) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC LIMIT 10 |
| 10:18:32.077 | 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"=90 |
| 10:18:32.077 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 10:18:32.078 | 0.5 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295) |
| 10:18:32.079 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id"=1 |
| 10:18:32.079 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=1 |
| 10:18:32.080 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id"=10 |
| 10:18:32.080 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (2, 1) |
| 10:18:32.081 | 1.1 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 (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099) ORDER BY "contribution" DESC, "engineer_id" |
| 10:18:32.084 | 1.2 ms | SELECT | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (3, 5) |
| 10:18:32.086 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (5, 9, 7, 4) |
| 10:18:32.086 | 1.1 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 (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099) |
| 10:18:32.087 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099) |
| 10:18:32.088 | 0.8 ms | SELECT | SELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (5, 136, 215, 226, 184, 189, 2, 164, 142, 1, 167, 181, 135, 140, 185, 191, 205, 204, 192, 179, 232, 168, 348, 349, 359, 369)) ORDER BY "sort" |
| 10:18:32.089 | 4.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099) |
| 10:18:32.094 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (5, 136, 215, 226, 184, 189, 2, 164, 142, 1, 167, 181, 135, 140, 185, 191, 205, 204, 192, 179, 232, 168, 348, 349, 359, 369)) ORDER BY "sort" |
| 10:18:32.095 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099) |
| 10:18:32.095 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (5, 136, 215, 226, 184, 189, 2, 164, 142, 1, 167, 181, 135, 140, 185, 191, 205, 204, 192, 179, 232, 168, 348, 349, 359, 369)) ORDER BY "sort" |
| 10:18:32.096 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 10:18:32.096 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295) |
| 10:18:32.096 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
| 10:18:32.097 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 10:18:32.097 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295) |
| 10:18:32.097 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=90 |
| 10:18:32.098 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 10:18:32.098 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295) |
| 10:18:32.098 | 5.9 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 (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099) GROUP BY "c"."project_id" |
| 10:18:32.105 | 0.6 ms | SELECT | SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("project_id" IN (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099)) GROUP BY "project_id" |
| 10:18:32.105 | 1.0 ms | SELECT | SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099) GROUP BY "project_id" |
| 10:18:32.107 | 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 (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099)) GROUP BY "project_id" |
| 10:18:32.107 | 5.9 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 (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099)) GROUP BY "c"."project_id" |
| 10:18:32.114 | 2.4 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 (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099)) GROUP BY "c"."project_id" |
| 10:18:32.116 | 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"=2) AND ("project_id" IN (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099)) GROUP BY "project_id" |
| 10:18:32.117 | 1.6 ms | SELECT | SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099)) GROUP BY "project_id" |
| 10:18:32.119 | 1.0 ms | SELECT | SELECT "id", "from_project", "payment_collection_remind_ahead", "serial_no", "is_settle", "is_deliver", "is_outbound", "erp_settle_amount" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099) |
| 10:18:32.120 | 1.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (2753, 3597, 3696, 3027, 3061, 2563, 3188, 3200, 2593)) |
| 10:18:32.122 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (12436, 12084, 16770, 13993, 17070, 18329, 22148, 18240, 23080) |
| 10:18:32.123 | 1.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (2753, 3597, 3696, 3027, 3061, 2563, 3188, 3200, 2593)) |
| 10:18:32.124 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (12438, 14433, 22532, 17157, 17181, 18432, 19001, 23355) |
| 10:18:32.124 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (2753, 3597, 3696, 3027, 3061, 2563, 3188, 3200, 2593)) |
| 10:18:32.126 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE ("status"=2) AND ("sales_contract_id" IN (2753, 3597, 3696, 3027, 3061, 2563, 3188, 3200, 2593)) ORDER BY "id" DESC |
| 10:18:32.127 | 2.6 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 (2753, 3597, 3696, 3027, 3061, 2563, 3188, 3200, 2593) ORDER BY "id" DESC |
| 10:18:32.130 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 1014) |
| 10:18:32.130 | 0.5 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 (2753, 3597, 3696, 3027, 3061, 2563, 3188, 3200, 2593) ORDER BY "id" |
| 10:18:32.131 | 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 (2753, 3597, 3696, 3027, 3061, 2563, 3188, 3200, 2593) ORDER BY "remind_date" |
| 10:18:32.132 | 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 (2753, 3597, 3696, 3027, 3061, 2563, 3188, 3200, 2593) |
| 10:18:32.132 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 5388, 1001) |
| 10:18:32.132 | 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 (5295, 5388, 1001)) |
| 10:18:32.133 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (2753, 3597, 3696, 3027, 3061, 2563, 3188, 3200, 2593) |
| 10:18:32.134 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (165, 262, 608, 313, 503, 659, 68, 298, 671, 489) |
| 10:18:32.134 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (3093, 3827, 3213, 3090, 3288, 3217, 3262, 3216, 3351, 3352, 3037, 2731, 3036, 3643, 3667, 3599, 3938, 3718, 3688) |
| 10:18:32.135 | 0.3 ms | SELECT | SELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099) |
| 10:18:32.135 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 10:18:32.136 | 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) |
| 10:18:32.136 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099) |
| 10:18:32.137 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (116, 262, 659, 489, 165, 503, 313) |
| 10:18:32.137 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1034, 1834, 941, 1852, 1531, 1511, 1890, 1891, 237, 9, 505, 1541, 1542, 1543, 1544, 151, 229) |
| 10:18:32.138 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (7, 4, 2, 19, 5, 3) |
| 10:18:32.139 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (30, 47, 43, 12, 13, 19, 151, 35, 14, 15) |
| 10:18:32.139 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (16, 3, 133, 8, 9, 173, 6, 47) |
| 10:18:32.139 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1240, 1332, 1321, 68, 783, 1331, 592, 630, 1545, 1559, 61, 1149, 1058, 831, 1051, 1025) |
| 10:18:32.140 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 8, 4, 1, 7, 6, 3) |
| 10:18:32.140 | 19.6 ms | SELECT | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099)) GROUP BY "object_id" |
| 10:18:32.160 | 16.9 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=1) AND (remind_user_id = 5295 AND is_read = false) AND ("object_id" IN (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099)) GROUP BY "object_id" |
| 10:18:32.178 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099) |
| 10:18:32.178 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id"=443 |
| 10:18:32.179 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=90 |
| 10:18:32.179 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((443, 3296), (443, 3114), (443, 3236), (443, 3446), (443, 3731), (443, 3677)) |
| 10:18:32.180 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099)) |
| 10:18:32.180 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id" IN (3731, 3677, 3446, 3481, 3415, 3045, 3296, 3236, 3114, 3099) |
| 10:18:32.181 | 0.8 ms | SELECT | SELECT EXISTS(SELECT "p".* 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 WHERE ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5295, 5311)) OR ("prr"."user_id"=5295) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295))) AND ("p"."id"=3731)) |
| 10:18:32.183 | 0.8 ms | SELECT | SELECT EXISTS(SELECT "p".* 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 WHERE ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5295, 5311)) OR ("prr"."user_id"=5295) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295))) AND ("p"."id"=3677)) |
| 10:18:32.184 | 0.8 ms | SELECT | SELECT EXISTS(SELECT "p".* 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 WHERE ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5295, 5311)) OR ("prr"."user_id"=5295) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295))) AND ("p"."id"=3446)) |
| 10:18:32.185 | 0.7 ms | SELECT | SELECT EXISTS(SELECT "p".* 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 WHERE ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5295, 5311)) OR ("prr"."user_id"=5295) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295))) AND ("p"."id"=3481)) |
| 10:18:32.186 | 0.8 ms | SELECT | SELECT EXISTS(SELECT "p".* 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 WHERE ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5295, 5311)) OR ("prr"."user_id"=5295) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295))) AND ("p"."id"=3415)) |
| 10:18:32.187 | 0.7 ms | SELECT | SELECT EXISTS(SELECT "p".* 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 WHERE ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5295, 5311)) OR ("prr"."user_id"=5295) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295))) AND ("p"."id"=3045)) |
| 10:18:32.188 | 0.7 ms | SELECT | SELECT EXISTS(SELECT "p".* 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 WHERE ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5295, 5311)) OR ("prr"."user_id"=5295) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295))) AND ("p"."id"=3296)) |
| 10:18:32.189 | 0.7 ms | SELECT | SELECT EXISTS(SELECT "p".* 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 WHERE ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5295, 5311)) OR ("prr"."user_id"=5295) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295))) AND ("p"."id"=3236)) |
| 10:18:32.190 | 0.7 ms | SELECT | SELECT EXISTS(SELECT "p".* 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 WHERE ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5295, 5311)) OR ("prr"."user_id"=5295) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295))) AND ("p"."id"=3114)) |
| 10:18:32.191 | 0.7 ms | SELECT | SELECT EXISTS(SELECT "p".* 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 WHERE ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5295, 5311)) OR ("prr"."user_id"=5295) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295))) AND ("p"."id"=3099)) |
| 10:18:32.194 | 4.1 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', 5295, 2, 1146, 'v2/project/of-client', '{"access_token":"qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA","device_type":"2","id":"90","page":"1","posttime":"1754619520","token":"d183ecdc572571f36262181d793cf986","version_code":"1146"}', '{"code":200,"data":{"list":[{"id":3731,"client_id":90,"project_status":3,"project_progress":5,"budget":"229600","profit_pct":"48.22","bargain_date":"2024-11-29","description":"","created_by":5295,"created_at":"2024-12-03 11:51:27","updated_at":"2025-07-04 14:14:36","engineer_id":null,"project_title":"2024veeam\u548c\u5b58\u50a8\u7eed\u4fdd","collected":"229600","status_updated_at":"2024-12-06 10:29:06.148764+08","success_rate":null,"comment":"","contract_type":2,"progress_updated_at":"2024-12-03 11:51:27.337612+08","forecast_updated_at":"2024-12-03 11:51:27.337612+08","end_at":"2024-12-16 20:57:31","pinyin_shortcut":"2024veeamhccxb","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":"39000","paid_contact_point":"39000","project_product_version_id":779,"is_sales_order_ready":true,"collected_plan":229600,"change_status_to":null,"is_verify":false,"profits":"110713.120000000000000000","remain":"244 days 23:49:25.910759","progress_remain":"247 days 22:27:04.721911","forecast_remain":"247 days 22:27:04.721911","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"13 days 09:06:03.894033","issued_invoices":"229600.00","client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"client_type":1,"client_class":1,"client_industry":10,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237","notice_days":10,"color":"#E89F0E"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[{"project_id":3731,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"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":69,"product_type_id":69,"key":69,"name":"\u5907\u4efd","budget":"229600.00","pct":"48.22","profit":"110713.12","project_id":3731}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":{"project_id":3731,"points":"650"},"workLogCount":null,"caseCount":{"project_id":3731,"count":11},"salesTimeCount":null,"implementTimeCount":{"project_id":3731,"sum":"22.9166666666667","times":"11"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3731,"sum":"820.95"},"buildContract":{"id":3696,"from_project":3731,"payment_collection_remind_ahead":"7 days","serial_no":"TS-WZW-2024112901","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"229600","contractScans":[{"id":31527,"object_type":105,"object_id":3696,"attachment_id":23080,"attachment":{"id":23080,"key":23080,"name":"66ed48f1-eb01-3824-b927-c13490953ee7","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/66ed48f1-eb01-3824-b927-c13490953ee7\/\u82cf\u9ece\u4e16.pdf","orig_name":"\u82cf\u9ece\u4e16.pdf"}}],"receiptScans":[{"id":31279,"object_type":106,"object_id":3696,"attachment_id":23355,"attachment":{"id":23355,"key":23355,"name":"7fde2264-7c5d-3d1a-a93d-01a838dfd18f","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/7fde2264-7c5d-3d1a-a93d-01a838dfd18f\/\u82cf\u9ece\u4e16-\u8d27\u7269\u7b7e\u6536\u535520241220.pdf","orig_name":"\u82cf\u9ece\u4e16-\u8d27\u7269\u7b7e\u6536\u535520241220.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":185,"serial_no":"SKD-20241213-00002","wrote_date":"2024-12-13","from_date":null,"handler":5295,"user_id":null,"client_id":90,"sales_contract_id":3696,"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":"2024-12-13 09:12:00","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"229600","settle_amount":"229600","created_by":1013,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2024-12-13 09:12:00","updated_at":"2024-12-13 09:12:00","paid_amount":null}],"salesContractPayments":[{"id":"1185","key":"1185","contract_id":3696,"value":"229600","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1893,"key":1893,"contract_id":3696,"value":"229600.00","attachment_id":null,"from_date":"2024-12-09","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2219,"key":2219,"contract_id":3696,"name":"2024-12-20","value":"229600","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":7659,"user_id":5295,"key":5295,"contract_id":3696,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},{"id":7660,"user_id":5388,"key":5388,"contract_id":3696,"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":7661,"user_id":1001,"key":1001,"contract_id":3696,"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":2497,"contract_id":3696,"supplier_id":165,"purchase_id":3827,"supplier":{"id":165,"key":165,"name":"\u5317\u4eac\u7eb3\u6069\u6052\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3827,"key":3827,"serial_no":"20250213"}},{"id":2738,"contract_id":3696,"supplier_id":262,"purchase_id":3938,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":3938,"key":3938,"serial_no":"\u8ba2\u5355\u53f7\uff1a 318600351430"}},{"id":2309,"contract_id":3696,"supplier_id":659,"purchase_id":3718,"supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"purchase":{"id":3718,"key":3718,"serial_no":"XM2024121700120"}},{"id":2328,"contract_id":3696,"supplier_id":489,"purchase_id":3688,"supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3688,"key":3688,"serial_no":"TSKJ20241203-HYF-001"}}],"payment_collection_remind_ahead_display":"7\u5929"},"projectRemindReceivers":[{"id":1321,"user_id":1001,"key":1001,"project_id":3731,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"projectProductRels":[{"id":8802,"project_id":3731,"product_id":1511,"amount":"31800.00","number":1,"cost":"10008.00","description":"","supplier_id":659,"hardware_from":null,"software_from":"2024-12-22","maintenance_from":null,"hardware_to":null,"software_to":"2026-01-20","maintenance_to":null,"total_amount":"31800","total_cost":"10008","erp_sales_order_product_id":null,"supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"product":{"id":1511,"name":"V-FDNVUL-0I-SU1AR-00","product_type":7,"product_component":30,"product_brand":16,"product_serie":1240,"product_misc":null,"product_qa":null,"pn":"","description":"Veeam Data Platform Foundation Universal Subscription License. Includes Enterprise Plus Edition features. 1 Year Renewal Subscription Upfront Billing & Production (24\/7) Support. 10 instance pack.","created_by":1001,"created_at":"2024-03-13 17:49:30","updated_at":"2024-03-13 17:49:30","pinyin_shortcut":"VFDNVUL0ISU1AR00","product_unit":2,"is_renew":true,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":16,"key":16,"name":"Veeam"},"productSerie":{"id":1240,"key":1240,"name":"Veeam VDP\u4e00\u5e74\u8ba2\u9605\u5f0f\u4f01\u4e1a\u589e\u5f3a\u7248\uff08\u7eed\u4fdd\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":null},{"id":8803,"project_id":3731,"product_id":1511,"amount":"31800.00","number":3,"cost":"10008.00","description":"","supplier_id":659,"hardware_from":null,"software_from":"2025-01-21","maintenance_from":null,"hardware_to":null,"software_to":"2026-01-20","maintenance_to":null,"total_amount":"95400","total_cost":"30024","erp_sales_order_product_id":null,"supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"product":{"id":1511,"name":"V-FDNVUL-0I-SU1AR-00","product_type":7,"product_component":30,"product_brand":16,"product_serie":1240,"product_misc":null,"product_qa":null,"pn":"","description":"Veeam Data Platform Foundation Universal Subscription License. Includes Enterprise Plus Edition features. 1 Year Renewal Subscription Upfront Billing & Production (24\/7) Support. 10 instance pack.","created_by":1001,"created_at":"2024-03-13 17:49:30","updated_at":"2024-03-13 17:49:30","pinyin_shortcut":"VFDNVUL0ISU1AR00","product_unit":2,"is_renew":true,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":16,"key":16,"name":"Veeam"},"productSerie":{"id":1240,"key":1240,"name":"Veeam VDP\u4e00\u5e74\u8ba2\u9605\u5f0f\u4f01\u4e1a\u589e\u5f3a\u7248\uff08\u7eed\u4fdd\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":null},{"id":8804,"project_id":3731,"product_id":1890,"amount":"31800.00","number":1,"cost":"11167.00","description":"","supplier_id":659,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"31800","total_cost":"11167","erp_sales_order_product_id":null,"supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"product":{"id":1890,"name":"V-FDNVUL-0I-SU1YP-00","product_type":7,"product_component":30,"product_brand":16,"product_serie":61,"product_misc":null,"product_qa":null,"pn":"","description":"Veeam Data Platform Foundation Universal Subscription License. Includes Enterprise Plus Edition features. 10 instance pack. 1 Year Subscription Upfront Billing & Production (24\/7) Support.","created_by":1013,"created_at":"2024-12-10 11:30:30","updated_at":"2024-12-10 11:30:30","pinyin_shortcut":"VFDNVUL0ISU1YP00","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":16,"key":16,"name":"Veeam"},"productSerie":{"id":61,"key":61,"name":"Veeam \u865a\u62df\u5316\u5907\u4efd"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":null},{"id":8805,"project_id":3731,"product_id":941,"amount":"1900.00","number":12,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-01-01","hardware_to":null,"software_to":null,"maintenance_to":"2025-12-31","total_amount":"22800","total_cost":"0","erp_sales_order_product_id":null,"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":"2023-08-11 16:02:47","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":null},{"id":8806,"project_id":3731,"product_id":941,"amount":"11000.00","number":1,"cost":"0","description":"Netapp E2724","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-01-01","hardware_to":null,"software_to":null,"maintenance_to":"2025-12-31","total_amount":"11000","total_cost":"0","erp_sales_order_product_id":null,"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":"2023-08-11 16:02:47","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":null},{"id":8807,"project_id":3731,"product_id":941,"amount":"17000.00","number":1,"cost":"0","description":"Netapp FAS2750","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-01-01","hardware_to":null,"software_to":null,"maintenance_to":"2025-12-31","total_amount":"17000","total_cost":"0","erp_sales_order_product_id":null,"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":"2023-08-11 16:02:47","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":null},{"id":8808,"project_id":3731,"product_id":941,"amount":"14000.00","number":1,"cost":"0","description":"Netapp FAS2650","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-01-01","hardware_to":null,"software_to":null,"maintenance_to":"2025-12-31","total_amount":"14000","total_cost":"0","erp_sales_order_product_id":null,"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":"2023-08-11 16:02:47","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":null},{"id":8809,"project_id":3731,"product_id":941,"amount":"2800.00","number":1,"cost":"0","description":"HPE DL388G9","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-01-01","hardware_to":null,"software_to":null,"maintenance_to":"2025-12-31","total_amount":"2800","total_cost":"0","erp_sales_order_product_id":null,"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":"2023-08-11 16:02:47","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":null},{"id":8810,"project_id":3731,"product_id":941,"amount":"1500.00","number":2,"cost":"0","description":"\u601d\u79d19148S","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-01-01","hardware_to":null,"software_to":null,"maintenance_to":"2025-12-31","total_amount":"3000","total_cost":"0","erp_sales_order_product_id":null,"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":"2023-08-11 16:02:47","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":null},{"id":8811,"project_id":3731,"product_id":1891,"amount":"0","number":1,"cost":"800.00","description":"FAS2650\u7ef4\u4fdd\u5907\u4ef6\u76d8","supplier_id":489,"hardware_from":"2024-12-03","software_from":null,"maintenance_from":null,"hardware_to":"2025-12-02","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"800","erp_sales_order_product_id":null,"supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1891,"name":"X426A-R6","product_type":3,"product_component":15,"product_brand":6,"product_serie":1149,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-12-10 13:33:21","updated_at":"2024-12-10 13:33:21","pinyin_shortcut":"X426AR6","product_unit":4,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":6,"key":6,"name":"NetAPP"},"productSerie":{"id":1149,"key":1149,"name":"1.8T 10K 2.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":null},{"id":8812,"project_id":3731,"product_id":1891,"amount":"0","number":1,"cost":"600.00","description":"FAS2750\u7ef4\u4fdd\u5907\u4ef6\u76d8","supplier_id":165,"hardware_from":"2025-02-13","software_from":null,"maintenance_from":null,"hardware_to":"2026-02-12","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"600","erp_sales_order_product_id":null,"supplier":{"id":165,"key":165,"name":"\u5317\u4eac\u7eb3\u6069\u6052\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1891,"name":"X426A-R6","product_type":3,"product_component":15,"product_brand":6,"product_serie":1149,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-12-10 13:33:21","updated_at":"2024-12-10 13:33:21","pinyin_shortcut":"X426AR6","product_unit":4,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":6,"key":6,"name":"NetAPP"},"productSerie":{"id":1149,"key":1149,"name":"1.8T 10K 2.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":null}],"commentCount":{"object_id":3731,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":841,"project_id":3731,"contact_id":443,"point":"39000.00","paid_point":"39000","contact":{"id":443,"key":443,"name":"\u5b59\u51ef","client_id":90,"supplier_id":null,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"supplier":null},"projectContactPointRels":[{"id":148,"project_id":3731,"contact_id":443,"point":"39000.00","day_at":"2025-01-02","description":"","created_at":"2025-01-02 14:36:47"}],"status_display":"\u5df2\u6838\u9500"}],"erpSalesOrder":null,"projectUsedClient":null,"remain_display":244,"progress_remain_display":247,"forecast_remain_display":247,"projectProductTotalAmount":229600,"projectProductAllAmount":true,"projectProductTotalCost":52599,"projectProductAllCost":true,"projectProductTotalNumber":25,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":false,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":false,"can_payment":false,"duration_display":13,"contract_type_display":"\u8fd0\u7ef4\u670d\u52a1","can_change_status":false,"is_admin":false,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"22.96\u4e07","contact_points_status_display":"\u5df2\u6838\u9500","verify_display":0},{"id":3677,"client_id":90,"project_status":3,"project_progress":5,"budget":"406550","profit_pct":"7.87","bargain_date":"2024-10-12","description":"","created_by":5295,"created_at":"2024-10-08 16:57:59","updated_at":"2024-12-10 11:39:21","engineer_id":null,"project_title":"\u65b0\u8d2d\u6234\u5c14\u5b58\u50a8","collected":"406550","status_updated_at":"2024-10-15 16:17:44.109861+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-10-08 16:57:59.756962+08","forecast_updated_at":"2024-10-15 16:19:25.468274+08","end_at":"2024-12-06 11:20:28","pinyin_shortcut":"xgdecc","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":"65000","paid_contact_point":"65000","project_product_version_id":678,"is_sales_order_ready":true,"collected_plan":406550,"change_status_to":null,"is_verify":false,"profits":"31995.485000000000000000","remain":"296 days 18:00:47.949662","progress_remain":"303 days 17:20:32.302561","forecast_remain":"296 days 17:59:06.591249","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"58 days 18:22:28.71502","issued_invoices":"406550.00","client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"client_type":1,"client_class":1,"client_industry":10,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237","notice_days":10,"color":"#E89F0E"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3677,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"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":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"406550","pct":"7.87","profit":"31995.485","project_id":3677}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355","description":"\u4fdd\u63015%\u57fa\u672c\u5229\u6da6\u7387\uff0c\u5e2e\u52a9\u5382\u5546\u4ea4\u4ed8\u9879\u76ee\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":{"project_id":3677,"points":"100"},"workLogCount":null,"caseCount":{"project_id":3677,"count":4},"salesTimeCount":null,"implementTimeCount":{"project_id":3677,"sum":"30.1666666666667","times":"4"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3677,"sum":"5504.11"},"buildContract":{"id":3597,"from_project":3677,"payment_collection_remind_ahead":"7 days","serial_no":"TS-WEW2024101201","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"406550","contractScans":[{"id":31031,"object_type":105,"object_id":3597,"attachment_id":22148,"attachment":{"id":22148,"key":22148,"name":"047ad9f8-df0e-3b2d-8b0b-24cc18c44e4d","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/047ad9f8-df0e-3b2d-8b0b-24cc18c44e4d\/\u82cf\u9ece\u4e16.pdf","orig_name":"\u82cf\u9ece\u4e16.pdf"}}],"receiptScans":[{"id":30052,"object_type":106,"object_id":3597,"attachment_id":22532,"attachment":{"id":22532,"key":22532,"name":"042f6008-f596-334b-bee8-d01714881696","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/042f6008-f596-334b-bee8-d01714881696\/\u82cf\u9ece\u4e16.pdf","orig_name":"\u82cf\u9ece\u4e16.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":171,"serial_no":"SKD-20241206-00002","wrote_date":"2024-12-06","from_date":null,"handler":5295,"user_id":null,"client_id":90,"sales_contract_id":3597,"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":"2024-12-06 11:20:28","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"203275","settle_amount":"203275","created_by":1013,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2024-12-06 11:20:28","updated_at":"2024-12-06 11:20:28","paid_amount":null},{"id":170,"serial_no":"SKD-20241107-00001","wrote_date":"2024-11-07","from_date":null,"handler":5295,"user_id":null,"client_id":90,"sales_contract_id":3597,"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":"2024-11-07 17:07:22","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"203275","settle_amount":"203275","created_by":1013,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2024-11-07 17:07:22","updated_at":"2024-11-07 17:07:22","paid_amount":null}],"salesContractPayments":[{"id":"1171","key":"1171","contract_id":3597,"value":"203275","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":50},{"id":"1170","key":"1170","contract_id":3597,"value":"203275","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":50}],"salesContractInvoices":[{"id":1837,"key":1837,"contract_id":3597,"value":"406550.00","attachment_id":null,"from_date":"2024-10-24","attachment":null},{"id":1838,"key":1838,"contract_id":3597,"value":"-406550.00","attachment_id":null,"from_date":"2024-10-25","attachment":null},{"id":1839,"key":1839,"contract_id":3597,"value":"203275.00","attachment_id":null,"from_date":"2024-10-25","attachment":null},{"id":1872,"key":1872,"contract_id":3597,"value":"203275.00","attachment_id":null,"from_date":"2024-11-22","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2122,"key":2122,"contract_id":3597,"name":"2024-12-31","value":"406550","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":7300,"user_id":5295,"key":5295,"contract_id":3597,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},{"id":7301,"user_id":5388,"key":5388,"contract_id":3597,"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":7302,"user_id":1001,"key":1001,"contract_id":3597,"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":2187,"contract_id":3597,"supplier_id":298,"purchase_id":3643,"supplier":{"id":298,"key":298,"name":"\u5317\u4eac\u777f\u521b\u80dc\u4e3a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3643,"key":3643,"serial_no":"TSKJ20241101-HYF-001"}},{"id":2188,"contract_id":3597,"supplier_id":262,"purchase_id":3667,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":3667,"key":3667,"serial_no":"305882210752"}},{"id":2189,"contract_id":3597,"supplier_id":671,"purchase_id":3599,"supplier":{"id":671,"key":671,"name":"\u56db\u5ddd\u957f\u8679\u4f73\u534e\u6570\u5b57\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3599,"key":3599,"serial_no":"TSKJ20241016-HYF-001"}}],"payment_collection_remind_ahead_display":"7\u5929"},"projectRemindReceivers":[{"id":1269,"user_id":1001,"key":1001,"project_id":3677,"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":7894,"project_id":3677,"product_id":1834,"amount":"367550","number":1,"cost":"278000","description":"","supplier_id":116,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"367550","total_cost":"278000","erp_sales_order_product_id":null,"supplier":{"id":116,"key":116,"name":"\u56db\u5ddd\u957f\u8679\u4f73\u534e\u4fe1\u606f\u4ea7\u54c1\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"product":{"id":1834,"name":"Unity XT 480","product_type":3,"product_component":14,"product_brand":9,"product_serie":1545,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-10-16 09:35:39","updated_at":"2024-10-16 09:35:39","pinyin_shortcut":"UnityXT480","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":9,"key":9,"name":"\u6234\u5c14\uff08DELL\uff09"},"productSerie":{"id":1545,"key":1545,"name":"DELL EMC Unity XT 480 \u5b58\u50a8\u9635\u5217"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":null},{"id":7895,"project_id":3677,"product_id":941,"amount":"39000","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":"39000","total_cost":"0","erp_sales_order_product_id":null,"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":"2023-08-11 16:02:47","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":null},{"id":7896,"project_id":3677,"product_id":1852,"amount":"0","number":2,"cost":"37.79","description":"","supplier_id":262,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"75.57","erp_sales_order_product_id":null,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"product":{"id":1852,"name":"\u5c71\u6cfd LC-LC\u591a\u6a21\u53cc\u82afOM3-300\u4e07\u5146\u5149\u7ea4\u8df3\u7ebf15\u7c73\uff08G3-LCLC1\uff095","product_type":4,"product_component":43,"product_brand":173,"product_serie":1559,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-10-30 10:53:53","updated_at":"2024-10-30 10:53:53","pinyin_shortcut":"szLCLCdmsxOM3300wzgxtx15mG3LCLC15","product_unit":6,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":173,"key":173,"name":"\u5c71\u6cfd"},"productSerie":{"id":1559,"key":1559,"name":"\u5149\u7ea4\u7ebf"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":null}],"commentCount":{"object_id":3677,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":766,"project_id":3677,"contact_id":443,"point":"65000.00","paid_point":"65000","contact":{"id":443,"key":443,"name":"\u5b59\u51ef","client_id":90,"supplier_id":null,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"supplier":null},"projectContactPointRels":[{"id":130,"project_id":3677,"contact_id":443,"point":"65000.00","day_at":"2024-12-12","description":"","created_at":"2024-12-12 14:44:55"}],"status_display":"\u5df2\u6838\u9500"}],"erpSalesOrder":null,"projectUsedClient":null,"remain_display":296,"progress_remain_display":303,"forecast_remain_display":296,"projectProductTotalAmount":406550,"projectProductAllAmount":true,"projectProductTotalCost":278075.57,"projectProductAllCost":true,"projectProductTotalNumber":4,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":false,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":false,"can_payment":false,"duration_display":58,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":false,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"40.66\u4e07","contact_points_status_display":"\u5df2\u6838\u9500","verify_display":0},{"id":3446,"client_id":90,"project_status":3,"project_progress":9,"budget":"455400","profit_pct":"29.79","bargain_date":"2024-03-20","description":"","created_by":5295,"created_at":"2024-02-18 21:31:40","updated_at":"2025-05-06 17:26:39","engineer_id":null,"project_title":"\u601d\u79d1\u670d\u52a1\u5668\u65b0\u8d2d+\u6570\u636e\u8fc1\u79fb","collected":"455400","status_updated_at":"2024-03-20 14:40:18.150923+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-03-17 22:08:27.903552+08","forecast_updated_at":"2024-03-17 22:08:27.903552+08","end_at":"2024-06-14 11:18:48","pinyin_shortcut":"skfwqxgsjqy","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":"110000","paid_contact_point":"110000","project_product_version_id":324,"is_sales_order_ready":true,"collected_plan":455400,"change_status_to":null,"is_verify":false,"profits":"135663.660000000000000000","remain":"505 days 19:38:13.9086","progress_remain":"508 days 12:10:04.155971","forecast_remain":"508 days 12:10:04.155971","lost_contact_days":"430.842732170405","last_contact":"2024-06-03 14:05:00","last_arrive_days":null,"last_arrive":null,"duration":"116 days 13:47:08.194993","issued_invoices":"455400.00","client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"client_type":1,"client_class":1,"client_industry":10,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237","notice_days":10,"color":"#E89F0E"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3446,"value":"1","key":1015,"name":"\u5434\u660a"}],"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":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"455400.00","pct":"29.79","profit":"135663.66","project_id":3446}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":{"project_id":3446,"points":"1111"},"workLogCount":{"project_id":3446,"count":13},"caseCount":{"project_id":3446,"count":20},"salesTimeCount":null,"implementTimeCount":{"project_id":3446,"sum":"65.2155555555556","times":"19"},"presalesTimeCount":{"project_id":3446,"sum":"0.383333333333333","times":"1"},"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3446,"sum":"10614.89"},"buildContract":{"id":3188,"from_project":3446,"payment_collection_remind_ahead":"00:00:00","serial_no":"SLS-SLKX20240312","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"455400","contractScans":[{"id":26788,"object_type":105,"object_id":3188,"attachment_id":18240,"attachment":{"id":18240,"key":18240,"name":"a639526b-da7b-3686-b748-5de2e52bfff0","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/a639526b-da7b-3686-b748-5de2e52bfff0\/2024_03_20_14_10_23.pdf","orig_name":"2024_03_20_14_10_23.pdf"}}],"receiptScans":[{"id":25574,"object_type":106,"object_id":3188,"attachment_id":19001,"attachment":{"id":19001,"key":19001,"name":"1db31c32-f50b-328a-b7c9-36a55c6107f1","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/1db31c32-f50b-328a-b7c9-36a55c6107f1\/\u8d27\u7269\u7b7e\u6536\u5355.pdf","orig_name":"\u8d27\u7269\u7b7e\u6536\u5355.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":1744,"serial_no":"SKD-20240422-00002","wrote_date":"2024-04-22","from_date":null,"handler":5295,"user_id":null,"client_id":90,"sales_contract_id":3188,"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":"2024-04-22 15:09:59","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"227700","settle_amount":"227700","created_by":1013,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2024-04-22 15:09:59","updated_at":"2024-04-22 15:09:59","paid_amount":null},{"id":20,"serial_no":"SKD-20240614-00001","wrote_date":"2024-06-14","from_date":null,"handler":5295,"user_id":null,"client_id":90,"sales_contract_id":3188,"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":"2024-06-14 11:18:48","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"227700","settle_amount":"227700","created_by":1013,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2024-06-14 11:18:48","updated_at":"2024-06-14 11:18:48","paid_amount":null}],"salesContractPayments":[{"id":"120","key":"120","contract_id":3188,"value":"227700","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":50},{"id":"11744","key":"11744","contract_id":3188,"value":"227700","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":50}],"salesContractInvoices":[{"id":1618,"key":1618,"contract_id":3188,"value":"227700.00","attachment_id":null,"from_date":"2024-03-21","attachment":null},{"id":1672,"key":1672,"contract_id":3188,"value":"227700.00","attachment_id":null,"from_date":"2024-06-03","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1595,"key":1595,"contract_id":3188,"name":"2024-05-31","value":"455400","overdue_days":14,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":5609,"user_id":5295,"key":5295,"contract_id":3188,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesSupplierRels":[{"id":1468,"contract_id":3188,"supplier_id":608,"purchase_id":3288,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchase":{"id":3288,"key":3288,"serial_no":"\u8ba2\u5355\u53f7: 3886093334225161702"}},{"id":1469,"contract_id":3188,"supplier_id":313,"purchase_id":3217,"supplier":{"id":313,"key":313,"name":"\u5317\u4eac\u6c49\u91d1\u82f1\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"purchase":{"id":3217,"key":3217,"serial_no":"HJY20240409"}},{"id":1470,"contract_id":3188,"supplier_id":262,"purchase_id":3262,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":3262,"key":3262,"serial_no":" 293099050913"}},{"id":1471,"contract_id":3188,"supplier_id":503,"purchase_id":3216,"supplier":{"id":503,"key":503,"name":"\u5e7f\u4e1c\u82f1\u901a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3216,"key":3216,"serial_no":"XS\/20240403\/JXM01"}},{"id":1472,"contract_id":3188,"supplier_id":262,"purchase_id":3351,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":3351,"key":3351,"serial_no":"294035220947"}},{"id":1473,"contract_id":3188,"supplier_id":262,"purchase_id":3352,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":3352,"key":3352,"serial_no":"297018766565"}}],"payment_collection_remind_ahead_display":"\u4e0d\u63d0\u9192"},"projectRemindReceivers":[{"id":972,"user_id":1001,"key":1001,"project_id":3446,"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":5341,"project_id":3446,"product_id":1541,"amount":"91600","number":1,"cost":"50000","description":"","supplier_id":503,"hardware_from":"2024-04-10","software_from":null,"maintenance_from":null,"hardware_to":"2025-04-10","software_to":null,"maintenance_to":null,"total_amount":"91600","total_cost":"50000","erp_sales_order_product_id":null,"supplier":{"id":503,"key":503,"name":"\u5e7f\u4e1c\u82f1\u901a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1541,"name":"UCS-SP-5108-AC3","product_type":2,"product_component":12,"product_brand":3,"product_serie":68,"product_misc":null,"product_qa":null,"pn":"","description":"Select 5108 AC2 Chassisw\/2304 IO,4x SFPcab 3m","created_by":1013,"created_at":"2024-04-08 10:45:27","updated_at":"2024-04-08 10:45:27","pinyin_shortcut":"UCSSP5108AC3","product_unit":1,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":12,"key":12,"name":"\u670d\u52a1\u5668\u5200\u7247\u673a\u7bb1"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":68,"key":68,"name":"\u601d\u79d1UCS5108\u5200\u7247\u673a\u7bb1"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":null},{"id":5342,"project_id":3446,"product_id":1542,"amount":"1900","number":1,"cost":"0","description":"\u4ee3\u7406\u5546\u8d28\u4fdd\u4e00\u5e74","supplier_id":503,"hardware_from":"2024-04-10","software_from":null,"maintenance_from":null,"hardware_to":"2025-04-10","software_to":null,"maintenance_to":null,"total_amount":"1900","total_cost":"0","erp_sales_order_product_id":null,"supplier":{"id":503,"key":503,"name":"\u5e7f\u4e1c\u82f1\u901a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1542,"name":"CON-SNT-5108AC3","product_type":2,"product_component":13,"product_brand":3,"product_serie":783,"product_misc":null,"product_qa":null,"pn":"","description":"SMARTNET 8X5XNBD, UCS SP Select 5108 AC2 Chassis w\/2304 IO,","created_by":1013,"created_at":"2024-04-08 10:46:26","updated_at":"2024-04-08 10:46:26","pinyin_shortcut":"CONSNT5108AC3","product_unit":8,"is_renew":true,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":13,"key":13,"name":"\u670d\u52a1\u5668\u91d1\u724c\u670d\u52a1"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":783,"key":783,"name":"\u601d\u79d1 5108\u5200\u7bb1\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":null},{"id":5343,"project_id":3446,"product_id":1543,"amount":"119500","number":2,"cost":"40000","description":"","supplier_id":503,"hardware_from":"2024-04-10","software_from":null,"maintenance_from":null,"hardware_to":"2025-04-10","software_to":null,"maintenance_to":null,"total_amount":"239000","total_cost":"80000","erp_sales_order_product_id":null,"supplier":{"id":503,"key":503,"name":"\u5e7f\u4e1c\u82f1\u901a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1543,"name":"UCS-FI-6332-16UP","product_type":4,"product_component":19,"product_brand":3,"product_serie":1331,"product_misc":null,"product_qa":null,"pn":"","description":"UCS 6332-16UP 1RU FI\/No PSU\/24 QSFP+ 16UP\/4x40G Lic\/8xUP Lic","created_by":1013,"created_at":"2024-04-08 10:48:44","updated_at":"2024-04-08 10:48:44","pinyin_shortcut":"UCSFI633216UP","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":19,"key":19,"name":"\u4ea4\u6362\u673a"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1331,"key":1331,"name":"\u601d\u79d1UCS-FI-6332-16UP\u4e92\u8054\u77e9\u9635\u4ea4\u6362\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":null},{"id":5344,"project_id":3446,"product_id":1544,"amount":"20750","number":2,"cost":"0","description":"\u4ee3\u7406\u5546\u8d28\u4fdd\u4e00\u5e74","supplier_id":503,"hardware_from":"2024-04-10","software_from":null,"maintenance_from":null,"hardware_to":"2025-04-10","software_to":null,"maintenance_to":null,"total_amount":"41500","total_cost":"0","erp_sales_order_product_id":null,"supplier":{"id":503,"key":503,"name":"\u5e7f\u4e1c\u82f1\u901a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1544,"name":"CON-SNT-633216UP","product_type":4,"product_component":47,"product_brand":3,"product_serie":1332,"product_misc":null,"product_qa":null,"pn":"","description":"SMARTNET 8X5XNBD, UCS 6332-16UP 1RU FI\/No PSU\/24 QSFP+ 16UP\/","created_by":1013,"created_at":"2024-04-08 10:49:45","updated_at":"2024-04-08 10:49:45","pinyin_shortcut":"CONSNT633216UP","product_unit":8,"is_renew":true,"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":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1332,"key":1332,"name":"\u601d\u79d1UCS-FI-6332-16UP\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":null},{"id":5345,"project_id":3446,"product_id":151,"amount":"0","number":4,"cost":"450","description":"","supplier_id":313,"hardware_from":"2024-04-10","software_from":null,"maintenance_from":null,"hardware_to":"2025-04-10","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"1800","erp_sales_order_product_id":null,"supplier":{"id":313,"key":313,"name":"\u5317\u4eac\u6c49\u91d1\u82f1\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"product":{"id":151,"name":"DS-SFP-FC16G-SW=","product_type":4,"product_component":43,"product_brand":3,"product_serie":1025,"product_misc":5,"product_qa":2,"pn":"","description":"","created_by":1013,"created_at":"2017-03-23 12:12:45","updated_at":"2024-01-26 11:30:11","pinyin_shortcut":"DSSFPFC16GSW","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1025,"key":1025,"name":"\u601d\u79d1DS-SFP-FC16G-SW\u5149\u7ea4\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":null},{"id":5346,"project_id":3446,"product_id":229,"amount":"950","number":12,"cost":"950","description":"\u5e93\u5b58","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2024-04-10","hardware_to":null,"software_to":null,"maintenance_to":"2025-04-10","total_amount":"11400","total_cost":"11400","erp_sales_order_product_id":null,"supplier":null,"product":{"id":229,"name":"SFP-10G-SR=","product_type":4,"product_component":43,"product_brand":3,"product_serie":1058,"product_misc":5,"product_qa":2,"pn":"","description":"","created_by":1013,"created_at":"2017-07-01 12:25:14","updated_at":"2024-01-30 16:00:59","pinyin_shortcut":"SFP10GSR","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1058,"key":1058,"name":"\u601d\u79d1SFP-10G-SR\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":null},{"id":5347,"project_id":3446,"product_id":941,"amount":"70000","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2024-04-10","hardware_to":null,"software_to":null,"maintenance_to":"2025-04-10","total_amount":"70000","total_cost":"0","erp_sales_order_product_id":null,"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":"2023-08-11 16:02:47","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":null}],"commentCount":{"object_id":3446,"comment":6},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":562,"project_id":3446,"contact_id":443,"point":"110000.00","paid_point":"110000","contact":{"id":443,"key":443,"name":"\u5b59\u51ef","client_id":90,"supplier_id":null,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"supplier":null},"projectContactPointRels":[{"id":103,"project_id":3446,"contact_id":443,"point":"110000.00","day_at":"2024-07-02","description":"","created_at":"2024-07-02 16:36:59"}],"status_display":"\u5df2\u6838\u9500"}],"erpSalesOrder":null,"projectUsedClient":null,"remain_display":505,"progress_remain_display":508,"forecast_remain_display":508,"projectProductTotalAmount":455400,"projectProductAllAmount":true,"projectProductTotalCost":143200,"projectProductAllCost":true,"projectProductTotalNumber":23,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":false,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":false,"can_payment":false,"duration_display":116,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":false,"lost_contact_days_display":"1\u5e74\u524d","can_view_product":true,"budget_display":"45.54\u4e07","contact_points_status_display":"\u5df2\u6838\u9500","verify_display":0},{"id":3481,"client_id":90,"project_status":3,"project_progress":7,"budget":"5300","profit_pct":"35.75","bargain_date":"2024-03-11","description":"","created_by":5295,"created_at":"2024-03-25 21:43:02","updated_at":"2024-05-13 14:30:36","engineer_id":null,"project_title":"\u65b0\u8d2d\u601d\u79d1\u4ea4\u6362\u673a\u6269\u5c55\u5361","collected":"5300","status_updated_at":"2024-03-25 21:43:02.814015+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-03-25 21:43:02.814015+08","forecast_updated_at":"2024-03-25 21:43:02.814015+08","end_at":"2024-04-30 14:58:31","pinyin_shortcut":"xgskjhjkzk","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":310,"is_sales_order_ready":true,"collected_plan":5300,"change_status_to":null,"is_verify":false,"profits":"1894.750000000000000000","remain":"500 days 12:35:29.245508","progress_remain":"500 days 12:35:29.245508","forecast_remain":"500 days 12:35:29.245508","lost_contact_days":"479.758704392627","last_contact":"2024-04-15 16:06:00","last_arrive_days":null,"last_arrive":null,"duration":"35 days 17:15:28.274631","issued_invoices":"5300.00","client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"client_type":1,"client_class":1,"client_industry":10,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237","notice_days":10,"color":"#E89F0E"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":7,"key":7,"name":"\u8fbe\u6210\u610f\u5411","description":"\u4e89\u53d6\u5ba2\u6237\u5728\u53e3\u5934\u4e0a\u8868\u8fbe\u610f\u613f\u3002\u6316\u6398\u5ba2\u6237\u987e\u8651\u3002\u6253\u6d88\u5ba2\u6237\u987e\u8651\u3002\n"},"projectProductTypes":[{"id":85,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"5300","pct":"35.75","profit":"1894.75","project_id":3481}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":null,"workLogCount":{"project_id":3481,"count":2},"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3200,"from_project":3481,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WZW-2024031145","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"5300","contractScans":[{"id":24935,"object_type":105,"object_id":3200,"attachment_id":18329,"attachment":{"id":18329,"key":18329,"name":"38682b96-476b-3b59-b534-b6a2c45542e4","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/38682b96-476b-3b59-b534-b6a2c45542e4\/2024_03_26_13_51_39.pdf","orig_name":"2024_03_26_13_51_39.pdf"}}],"receiptScans":[{"id":24883,"object_type":106,"object_id":3200,"attachment_id":18432,"attachment":{"id":18432,"key":18432,"name":"d2ab809b-e237-3cca-9625-65e9d5f9e4ae","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/d2ab809b-e237-3cca-9625-65e9d5f9e4ae\/2024_04_01_09_34_37.pdf","orig_name":"2024_04_01_09_34_37.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":839,"serial_no":"SKD-20240430-00002","wrote_date":"2024-04-30","from_date":null,"handler":5295,"user_id":null,"client_id":90,"sales_contract_id":3200,"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":"2024-04-30 14:58:30","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"5300","settle_amount":"5300","created_by":1013,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2024-04-30 14:58:30","updated_at":"2024-04-30 14:58:30","paid_amount":null}],"salesContractPayments":[{"id":"1839","key":"1839","contract_id":3200,"value":"5300","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1626,"key":1626,"contract_id":3200,"value":"5300.00","attachment_id":null,"from_date":"2024-03-28","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1584,"key":1584,"contract_id":3200,"name":"2024-05-10","value":"5300","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":4955,"user_id":5295,"key":5295,"contract_id":3200,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesSupplierRels":[{"id":1081,"contract_id":3200,"supplier_id":262,"purchase_id":3213,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":3213,"key":3213,"serial_no":"3827458874642161702"}}],"payment_collection_remind_ahead_display":"\u4e0d\u63d0\u9192"},"projectRemindReceivers":[{"id":964,"user_id":1001,"key":1001,"project_id":3481,"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":4093,"project_id":3481,"product_id":1531,"amount":"5300","number":1,"cost":"3000","description":"\u6dd8\u5b9d\u8d2d\u4e70\uff0c\u672a\u7a0e","supplier_id":262,"hardware_from":"2024-03-26","software_from":null,"maintenance_from":null,"hardware_to":"2025-03-25","software_to":null,"maintenance_to":null,"total_amount":"5300","total_cost":"3000","erp_sales_order_product_id":null,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"product":{"id":1531,"name":"NIM-2GE-CU-SFP=","product_type":4,"product_component":43,"product_brand":3,"product_serie":1321,"product_misc":null,"product_qa":null,"pn":"","description":"2-port GE WAN NIM, dual-mode RJ45 &SFP\n\u601d\u79d1ISR4331\u6269\u5c55\u677f\u5361","created_by":1013,"created_at":"2024-03-26 16:27:50","updated_at":"2024-03-28 14:59:34","pinyin_shortcut":"NIM2GECUSFP","product_unit":4,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1321,"key":1321,"name":"NIM-2GE-CU-SFP\u6269\u5c55\u677f\u5361"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":null}],"commentCount":{"object_id":3481,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"remain_display":500,"progress_remain_display":500,"forecast_remain_display":500,"projectProductTotalAmount":5300,"projectProductAllAmount":true,"projectProductTotalCost":3000,"projectProductAllCost":true,"projectProductTotalNumber":1,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":false,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":false,"can_payment":false,"duration_display":35,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":false,"lost_contact_days_display":"1\u5e74\u524d","can_view_product":true,"budget_display":"5300","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0},{"id":3415,"client_id":90,"project_status":3,"project_progress":9,"budget":"1800","profit_pct":"-508.25","bargain_date":"2024-01-04","description":"","created_by":5295,"created_at":"2024-01-04 14:58:42","updated_at":"2024-02-19 15:45:17","engineer_id":null,"project_title":"\u65b0\u8d2d\u9632\u706b\u5899\u6a21\u5757","collected":"1800","status_updated_at":"2024-01-04 14:58:42.928911+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-01-04 14:58:42.928911+08","forecast_updated_at":"2024-01-04 14:58:42.928911+08","end_at":"2024-01-18 17:31:00","pinyin_shortcut":"xgfhqmk","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":244,"is_sales_order_ready":true,"collected_plan":1800,"change_status_to":null,"is_verify":false,"profits":"-9148.500000000000000000","remain":"581 days 19:19:49.130612","progress_remain":"581 days 19:19:49.130612","forecast_remain":"581 days 19:19:49.130612","lost_contact_days":"581.759398837072","last_contact":"2024-01-04 16:05:00","last_arrive_days":null,"last_arrive":null,"duration":"14 days 02:32:17.30982","issued_invoices":"1800.00","client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"client_type":1,"client_class":1,"client_industry":10,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237","notice_days":10,"color":"#E89F0E"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"1800.00","pct":"-508.25","profit":"-9148.5","project_id":3415}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":null,"workLogCount":{"project_id":3415,"count":1},"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3061,"from_project":3415,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WZW-2024010403","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"1800","contractScans":[{"id":23955,"object_type":105,"object_id":3061,"attachment_id":17070,"attachment":{"id":17070,"key":17070,"name":"0b69b17c-dcd1-3d8c-84fb-bd3f5fa79944","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/0b69b17c-dcd1-3d8c-84fb-bd3f5fa79944\/2024_01_08_17_35_25.pdf","orig_name":"2024_01_08_17_35_25.pdf"}}],"receiptScans":[{"id":23132,"object_type":106,"object_id":3061,"attachment_id":17157,"attachment":{"id":17157,"key":17157,"name":"7daac9fa-78af-3988-8c04-e857d219e159","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/7daac9fa-78af-3988-8c04-e857d219e159\/2024_01_15_10_44_25.pdf","orig_name":"2024_01_15_10_44_25.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":543,"serial_no":"SKD-20240118-00001","wrote_date":"2024-01-18","from_date":null,"handler":5295,"user_id":null,"client_id":90,"sales_contract_id":3061,"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":"2024-01-18 17:31:00","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"1800","settle_amount":"1800","created_by":1014,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2024-01-18 17:31:00","updated_at":"2024-01-18 17:31:00","paid_amount":null}],"salesContractPayments":[{"id":"1543","key":"1543","contract_id":3061,"value":"1800","created_by":1014,"createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1579,"key":1579,"contract_id":3061,"value":"1800.00","attachment_id":null,"from_date":"2024-01-08","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1501,"key":1501,"contract_id":3061,"name":"2024-01-31","value":"1800","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":4835,"user_id":5295,"key":5295,"contract_id":3061,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesSupplierRels":[{"id":1216,"contract_id":3061,"supplier_id":262,"purchase_id":3090,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":3090,"key":3090,"serial_no":"3720041499068161702"}}],"payment_collection_remind_ahead_display":"\u4e0d\u63d0\u9192"},"projectRemindReceivers":[{"id":873,"user_id":1001,"key":1001,"project_id":3415,"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":3402,"project_id":3415,"product_id":505,"amount":"900","number":2,"cost":"144.3","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1800","total_cost":"288.6","erp_sales_order_product_id":null,"supplier":null,"product":{"id":505,"name":"MC3208411-T","product_type":4,"product_component":43,"product_brand":47,"product_serie":831,"product_misc":5,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2018-12-06 11:27:37","updated_at":"2024-01-15 14:52:49","pinyin_shortcut":"MC3208411T","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":47,"key":47,"name":"\u8fc8\u7edc\u601d"},"productSerie":{"id":831,"key":831,"name":"\u5343\u5146\u7535\u53e3\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":null}],"commentCount":{"object_id":3415,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"remain_display":581,"progress_remain_display":581,"forecast_remain_display":581,"projectProductTotalAmount":1800,"projectProductAllAmount":true,"projectProductTotalCost":288.6,"projectProductAllCost":true,"projectProductTotalNumber":2,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":false,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":false,"can_payment":false,"duration_display":14,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":false,"lost_contact_days_display":"1\u5e74\u524d","can_view_product":true,"budget_display":"1800","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0},{"id":3045,"client_id":90,"project_status":5,"project_progress":4,"budget":"300000","profit_pct":"15","bargain_date":"2023-12-31","description":"\u7231\u6570\u7f51\u76d8","created_by":5295,"created_at":"2022-11-25 20:45:57","updated_at":"2023-12-04 11:23:15","engineer_id":null,"project_title":"\u65b0\u8d2d\u7231\u6570\u7f51\u76d8-K","collected":"0","status_updated_at":"2023-12-04 11:23:15.736802+08","success_rate":null,"comment":"\u660e\u5e74\u518d\u542f\u52a8\n\u7231\u6570\u7f51\u76d8\n","contract_type":1,"progress_updated_at":"2022-11-25 20:45:57.034482+08","forecast_updated_at":"2023-03-13 12:06:06.808082+08","end_at":"2023-12-04 11:23:15","pinyin_shortcut":"xgaswpK","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"45000.0000000000000000","remain":"612 days 22:55:16.322721","progress_remain":"986 days 13:32:35.025041","forecast_remain":"878 days 22:12:25.251441","lost_contact_days":"706.800371059294","last_contact":"2023-09-01 15:06:00","last_arrive_days":"876.996204392627","last_arrive":"2023-03-15 10:24:00+08","duration":"373 days 14:37:18.70232","issued_invoices":null,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"client_type":1,"client_class":1,"client_industry":10,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237","notice_days":10,"color":"#E89F0E"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3045,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{"id":4,"key":4,"name":"\u786e\u8ba4\u65b9\u6848","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u7684\u53cd\u9988\uff0c\u4e0d\u65ad\u4f18\u5316\u89e3\u51b3\u65b9\u6848\uff0c\u76f4\u5230\u5ba2\u6237\u53e3\u5934\u6216\u4e66\u9762\u8ba4\u53ef\u65b9\u6848\u3002 \n\u65b9\u6cd5\uff1a\u4f7f\u7528\u573a\u666f\uff0c\u95ee\u9898\uff0c\u9700\u6c42\uff0c\u4ea7\u54c1\u53ca\u529f\u80fd\u7684\u65b9\u6cd5\u8bb2\u89e3\u65b9\u6848\u3002"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"300000.00","pct":"15","profit":"45000","project_id":3045}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":{"id":168,"key":168,"name":"\u670b\u53cb\u4ecb\u7ecd"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":{"project_id":3045,"points":"100"},"workLogCount":{"project_id":3045,"count":44},"caseCount":{"project_id":3045,"count":2},"salesTimeCount":{"project_id":3045,"hours":"2.01666666666667","times":2},"implementTimeCount":null,"presalesTimeCount":{"project_id":3045,"sum":"1.81666666666667","times":"2"},"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3045,"sum":"522.00"},"buildContract":null,"projectRemindReceivers":[{"id":800,"user_id":1001,"key":1001,"project_id":3045,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"projectProductRels":[],"commentCount":{"object_id":3045,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"remain_display":612,"progress_remain_display":986,"forecast_remain_display":878,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":300000,"is_exceeded":false,"can_update":true,"can_delete":false,"unread":0,"last_arrive_days_display":"2\u5e74\u524d","project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_invoice":false,"can_payment":false,"duration_display":373,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":false,"lost_contact_days_display":"1\u5e74\u524d","can_view_product":true,"budget_display":"30\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0},{"id":3296,"client_id":90,"project_status":3,"project_progress":9,"budget":"229840","profit_pct":"48.15","bargain_date":"2023-12-20","description":"","created_by":5295,"created_at":"2023-08-25 17:46:27","updated_at":"2025-03-18 13:40:51","engineer_id":null,"project_title":"veeam\u5907\u4efd\u7eed\u4fdd+PA\u9632\u706b\u5899\u6280\u672f\u670d\u52a1+\u786c\u4ef6\u8bbe\u5907\u7ef4\u4fdd","collected":"229840","status_updated_at":"2023-12-20 14:58:21.799185+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2023-12-17 21:30:36.420827+08","forecast_updated_at":"2023-12-17 21:30:36.420827+08","end_at":"2024-01-05 15:54:06","pinyin_shortcut":"veeambfxbPAfhqjsfwyjsbwb","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":"50000","paid_contact_point":"50000","project_product_version_id":180,"is_sales_order_ready":false,"collected_plan":229840,"change_status_to":null,"is_verify":false,"profits":"110667.960000000000000000","remain":"596 days 19:20:10.260338","progress_remain":"599 days 12:47:55.638696","forecast_remain":"599 days 12:47:55.638696","lost_contact_days":"588.759398837072","last_contact":"2023-12-28 16:05:00","last_arrive_days":"645.969815503738","last_arrive":"2023-11-01 11:02:00+08","duration":"132 days 22:07:39.49602","issued_invoices":"229840.00","client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"client_type":1,"client_class":1,"client_industry":10,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237","notice_days":10,"color":"#E89F0E"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3296,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"229840.00","pct":"48.15","profit":"110667.96","project_id":3296}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":{"id":167,"key":167,"name":"\u5382\u5546\u4ecb\u7ecd"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":{"project_id":3296,"points":"212"},"workLogCount":{"project_id":3296,"count":15},"caseCount":{"project_id":3296,"count":4},"salesTimeCount":{"project_id":3296,"hours":"1.31666666666667","times":1},"implementTimeCount":{"project_id":3296,"sum":"19.1411111111111","times":"4"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3296,"sum":"3468.08"},"buildContract":{"id":3027,"from_project":3296,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WZW-2023121145","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"229840","contractScans":[{"id":23603,"object_type":105,"object_id":3027,"attachment_id":16770,"attachment":{"id":16770,"key":16770,"name":"e1af474e-5629-381f-9728-6719fd02e3b2","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/e1af474e-5629-381f-9728-6719fd02e3b2\/2023_12_20_10_56_25.pdf","orig_name":"2023_12_20_10_56_25.pdf"}}],"receiptScans":[{"id":23156,"object_type":106,"object_id":3027,"attachment_id":17181,"attachment":{"id":17181,"key":17181,"name":"59a01f5e-5813-3fdf-aefb-cf617f2ce432","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/59a01f5e-5813-3fdf-aefb-cf617f2ce432\/\u7b7e\u6536\u5355.pdf","orig_name":"\u7b7e\u6536\u5355.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":1551,"serial_no":"SKD-20240105-00002","wrote_date":"2024-01-05","from_date":null,"handler":5295,"user_id":null,"client_id":90,"sales_contract_id":3027,"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":"2024-01-05 15:54:06","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"229840","settle_amount":"229840","created_by":1014,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2024-01-05 15:54:06","updated_at":"2024-01-05 15:54:06","paid_amount":null}],"salesContractPayments":[{"id":"11551","key":"11551","contract_id":3027,"value":"229840","created_by":1014,"createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1565,"key":1565,"contract_id":3027,"value":"229840.00","attachment_id":null,"from_date":"2023-12-20","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1473,"key":1473,"contract_id":3027,"name":"2024-02-29","value":"229840","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":4735,"user_id":5295,"key":5295,"contract_id":3027,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesSupplierRels":[{"id":65,"contract_id":3027,"supplier_id":165,"purchase_id":3093,"supplier":{"id":165,"key":165,"name":"\u5317\u4eac\u7eb3\u6069\u6052\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3093,"key":3093,"serial_no":""}},{"id":2057,"contract_id":3027,"supplier_id":659,"purchase_id":3037,"supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"purchase":{"id":3037,"key":3037,"serial_no":"XM20231221000645"}},{"id":2056,"contract_id":3027,"supplier_id":659,"purchase_id":3036,"supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"purchase":{"id":3036,"key":3036,"serial_no":"XM20231221000544"}}],"payment_collection_remind_ahead_display":"\u4e0d\u63d0\u9192"},"projectRemindReceivers":[{"id":854,"user_id":1001,"key":1001,"project_id":3296,"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":2978,"project_id":3296,"product_id":237,"amount":"35360","number":3,"cost":"8267","description":"V-FDNVUL-0I-SU1AR-00 ","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"106080","total_cost":"24801","erp_sales_order_product_id":null,"supplier":null,"product":{"id":237,"name":"Veeam\u865a\u62df\u5316\u5907\u4efd\u7eed\u4fdd\u670d\u52a1","product_type":7,"product_component":30,"product_brand":16,"product_serie":61,"product_misc":5,"product_qa":2,"pn":"","description":"","created_by":1013,"created_at":"2017-07-13 17:27:26","updated_at":"2023-08-14 15:55:11","pinyin_shortcut":"Veeamxnhbfxbfw","product_unit":8,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":16,"key":16,"name":"Veeam"},"productSerie":{"id":61,"key":61,"name":"Veeam \u865a\u62df\u5316\u5907\u4efd"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":null},{"id":2979,"project_id":3296,"product_id":9,"amount":"35360","number":1,"cost":"10300","description":"V-FDNVUL-0I- SU1YP-00","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"35360","total_cost":"10300","erp_sales_order_product_id":null,"supplier":null,"product":{"id":9,"name":"V-FDNVUL-0I- SU1YP-00","product_type":7,"product_component":30,"product_brand":16,"product_serie":1051,"product_misc":5,"product_qa":2,"pn":"","description":"Veeam Data Platform Foundation Universal Subscription License. Includes Enterprise Plus Edition features. 10 instance pack. 1 Year Subscription Upfront Billing & Production (24\/7) Support. ","created_by":1013,"created_at":"2017-02-09 17:00:55","updated_at":"2024-01-26 17:18:42","pinyin_shortcut":"VFDNVUL0ISU1YP00","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":16,"key":16,"name":"Veeam"},"productSerie":{"id":1051,"key":1051,"name":"Veeam VDP\u4e00\u5e74\u8ba2\u9605\u5f0f\u4f01\u4e1a\u589e\u5f3a\u7248"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":null},{"id":2980,"project_id":3296,"product_id":941,"amount":"88400","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":"88400","total_cost":"0","erp_sales_order_product_id":null,"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":"2023-08-11 16:02:47","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":null}],"commentCount":{"object_id":3296,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":335,"project_id":3296,"contact_id":443,"point":"50000.00","paid_point":"50000","contact":{"id":443,"key":443,"name":"\u5b59\u51ef","client_id":90,"supplier_id":null,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"supplier":null},"projectContactPointRels":[{"id":39,"project_id":3296,"contact_id":443,"point":"50000.00","day_at":"2024-01-11","description":"\u7fc1\u5bb6\u6210\u9001\u73b0\u91d1","created_at":"2024-01-11 15:34:35"}],"status_display":"\u5df2\u6838\u9500"}],"erpSalesOrder":null,"projectUsedClient":null,"remain_display":596,"progress_remain_display":599,"forecast_remain_display":599,"projectProductTotalAmount":229840,"projectProductAllAmount":true,"projectProductTotalCost":35101,"projectProductAllCost":true,"projectProductTotalNumber":5,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":false,"unread":0,"last_arrive_days_display":"1\u5e74\u524d","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":false,"can_payment":false,"duration_display":132,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":false,"lost_contact_days_display":"1\u5e74\u524d","can_view_product":true,"budget_display":"22.98\u4e07","contact_points_status_display":"\u5df2\u6838\u9500","verify_display":0},{"id":3236,"client_id":90,"project_status":3,"project_progress":9,"budget":"249830","profit_pct":"-2.91","bargain_date":"2023-07-11","description":"Prisma\u7528\u6237\u65b0\u8d2d","created_by":5295,"created_at":"2023-06-25 21:54:58","updated_at":"2024-11-19 09:30:16","engineer_id":null,"project_title":"PA\u4ea7\u54c1\u65b0\u8d2d-C","collected":"249830","status_updated_at":"2023-07-18 10:42:59.312806+08","success_rate":null,"comment":"Prisma\u7528\u6237\u65b0\u8d2d\r\n","contract_type":1,"progress_updated_at":"2023-07-02 19:52:38.721429+08","forecast_updated_at":"2023-07-02 19:52:38.721429+08","end_at":"2023-07-28 15:10:57","pinyin_shortcut":"PAcpxgC","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":"40000","paid_contact_point":"40000","project_product_version_id":236,"is_sales_order_ready":true,"collected_plan":249830,"change_status_to":null,"is_verify":false,"profits":"-7270.053000000000000000","remain":"751 days 23:35:32.746717","progress_remain":"767 days 14:25:53.338094","forecast_remain":"767 days 14:25:53.338094","lost_contact_days":"758.717732170405","last_contact":"2023-07-11 17:05:00","last_arrive_days":null,"last_arrive":null,"duration":"32 days 17:15:58.393388","issued_invoices":"249830.00","client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"client_type":1,"client_class":1,"client_industry":10,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237","notice_days":10,"color":"#E89F0E"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"249830","pct":"-2.91","profit":"-7270.053","project_id":3236}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":{"id":167,"key":167,"name":"\u5382\u5546\u4ecb\u7ecd"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":{"project_id":3236,"points":"31"},"workLogCount":{"project_id":3236,"count":4},"caseCount":{"project_id":3236,"count":1},"salesTimeCount":null,"implementTimeCount":{"project_id":3236,"sum":"2.61666666666667","times":"1"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3236,"sum":"88.90"},"buildContract":{"id":2753,"from_project":3236,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WZW-2023071145","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"249830","contractScans":[{"id":23756,"object_type":105,"object_id":2753,"attachment_id":13993,"attachment":{"id":13993,"key":13993,"name":"d720ea91-ac06-32d7-8bd6-95e4e3bc541f","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/d720ea91-ac06-32d7-8bd6-95e4e3bc541f\/2023_07_19_10_22_27.pdf","orig_name":"2023_07_19_10_22_27.pdf"}}],"receiptScans":[{"id":19932,"object_type":106,"object_id":2753,"attachment_id":14433,"attachment":{"id":14433,"key":14433,"name":"13f18fb1-f0c5-35b7-bce1-b70a322816a3","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/13f18fb1-f0c5-35b7-bce1-b70a322816a3\/20230815141500289.pdf","orig_name":"20230815141500289.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":1469,"serial_no":"SKD-20230728-00002","wrote_date":"2023-07-28","from_date":null,"handler":5295,"user_id":null,"client_id":90,"sales_contract_id":2753,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2023-07-28 15:10:57","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"249830","settle_amount":"249830","created_by":1014,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2023-07-28 15:10:57","updated_at":"2023-07-28 15:10:57","paid_amount":null}],"salesContractPayments":[{"id":"11469","key":"11469","contract_id":2753,"value":"249830","created_by":1014,"createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1437,"key":1437,"contract_id":2753,"value":"249830.00","attachment_id":null,"from_date":"2023-07-19","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1285,"key":1285,"contract_id":2753,"name":"2023-09-18","value":"249830","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":4806,"user_id":5295,"key":5295,"contract_id":2753,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesSupplierRels":[{"id":2105,"contract_id":2753,"supplier_id":68,"purchase_id":2731,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":2731,"key":2731,"serial_no":"BJ7067-PA-MJ-20230627"}}],"payment_collection_remind_ahead_display":"\u4e0d\u63d0\u9192"},"projectRemindReceivers":[{"id":636,"user_id":1001,"key":1001,"project_id":3236,"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":3326,"project_id":3236,"product_id":1034,"amount":"249830","number":1,"cost":"192000","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"249830","total_cost":"192000","erp_sales_order_product_id":null,"supplier":null,"product":{"id":1034,"name":"PA-\u4e13\u4e1a\u8ba2\u5236\u56fd\u5185\u6388\u6743\u548c\u670d\u52a1","product_type":5,"product_component":35,"product_brand":8,"product_serie":630,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-09-08 17:27:31","updated_at":"2023-09-08 17:27:31","pinyin_shortcut":"PAzydzgnsqhfw","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":8,"key":8,"name":"Paloalto"},"productSerie":{"id":630,"key":630,"name":"PA-China-Prisma"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":null}],"commentCount":{"object_id":3236,"comment":4},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":366,"project_id":3236,"contact_id":443,"point":"40000.00","paid_point":"40000","contact":{"id":443,"key":443,"name":"\u5b59\u51ef","client_id":90,"supplier_id":null,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"supplier":null},"projectContactPointRels":[{"id":38,"project_id":3236,"contact_id":443,"point":"40000.00","day_at":"2023-08-09","description":"","created_at":"2024-01-11 15:32:48"}],"status_display":"\u5df2\u6838\u9500"}],"erpSalesOrder":null,"projectUsedClient":null,"remain_display":751,"progress_remain_display":767,"forecast_remain_display":767,"projectProductTotalAmount":249830,"projectProductAllAmount":true,"projectProductTotalCost":192000,"projectProductAllCost":true,"projectProductTotalNumber":1,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":false,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":false,"can_payment":false,"duration_display":32,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":false,"lost_contact_days_display":"2\u5e74\u524d","can_view_product":true,"budget_display":"24.98\u4e07","contact_points_status_display":"\u5df2\u6838\u9500","verify_display":0},{"id":3114,"client_id":90,"project_status":3,"project_progress":5,"budget":"26808","profit_pct":"41.52","bargain_date":"2023-02-14","description":"\u601d\u79d1\u7f51\u7edc\u4ea7\u54c1\u7eed\u4fdd","created_by":5295,"created_at":"2023-02-14 17:16:12","updated_at":"2023-12-07 18:25:08","engineer_id":null,"project_title":"\u7f51\u7edc\u4ea7\u54c1\u7eed\u4fdd2023-2","collected":"26808","status_updated_at":"2023-02-14 17:16:12.592229+08","success_rate":null,"comment":"\u601d\u79d1\u7f51\u7edc\u4ea7\u54c1\u7eed\u4fdd\r\n","contract_type":2,"progress_updated_at":"2023-02-14 17:16:12.592229+08","forecast_updated_at":"2023-02-14 17:16:12.592229+08","end_at":"2023-04-13 17:41:36","pinyin_shortcut":"wlcpxb20232","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":"24000","paid_contact_point":"24000","project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":26808,"change_status_to":null,"is_verify":false,"profits":"11130.681600000000000000","remain":"905 days 17:02:19.467294","progress_remain":"905 days 17:02:19.467294","forecast_remain":"905 days 17:02:19.467294","lost_contact_days":"905.971204392627","last_contact":"2023-02-14 11:00:00","last_arrive_days":null,"last_arrive":null,"duration":"58 days 00:25:24.090892","issued_invoices":"26808.00","client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"client_type":1,"client_class":1,"client_industry":10,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237","notice_days":10,"color":"#E89F0E"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"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":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"26808","pct":"41.52","profit":"11130.6816","project_id":3114}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355","description":"\u4fdd\u63015%\u57fa\u672c\u5229\u6da6\u7387\uff0c\u5e2e\u52a9\u5382\u5546\u4ea4\u4ed8\u9879\u76ee\u3002"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":null,"workLogCount":{"project_id":3114,"count":1},"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":2563,"from_project":3114,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WZW-20211001\u8865\u5145\u534f\u8bae-3","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"26808","contractScans":[{"id":23010,"object_type":105,"object_id":2563,"attachment_id":12084,"attachment":{"id":12084,"key":12084,"name":"623661c7-d956-3a42-b16e-432e8d01081a","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/623661c7-d956-3a42-b16e-432e8d01081a\/2022_09_13_15_37_22.pdf","orig_name":"2022_09_13_15_37_22.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[{"id":1143,"serial_no":"SKD-20230413-00001","wrote_date":"2023-04-13","from_date":null,"handler":5295,"user_id":null,"client_id":90,"sales_contract_id":2563,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2023-04-13 17:41:36","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"26808","settle_amount":"26808","created_by":1014,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2023-04-13 17:41:36","updated_at":"2023-04-13 17:41:36","paid_amount":null}],"salesContractPayments":[{"id":"11143","key":"11143","contract_id":2563,"value":"26808","created_by":1014,"createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1347,"key":1347,"contract_id":2563,"value":"26808.00","attachment_id":null,"from_date":"2023-02-15","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1161,"key":1161,"contract_id":2563,"name":"2023-04-14","value":"26808","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":4461,"user_id":5295,"key":5295,"contract_id":2563,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"\u4e0d\u63d0\u9192"},"projectRemindReceivers":[{"id":411,"user_id":1001,"key":1001,"project_id":3114,"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":2121,"project_id":3114,"product_id":941,"amount":"26808","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":"26808","total_cost":"0","erp_sales_order_product_id":null,"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":"2023-08-11 16:02:47","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":null}],"commentCount":{"object_id":3114,"comment":4},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":176,"project_id":3114,"contact_id":443,"point":"24000.00","paid_point":"24000","contact":{"id":443,"key":443,"name":"\u5b59\u51ef","client_id":90,"supplier_id":null,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"supplier":null},"projectContactPointRels":[{"id":37,"project_id":3114,"contact_id":443,"point":"24000.00","day_at":"2023-04-19","description":"","created_at":"2024-01-11 15:31:58"}],"status_display":"\u5df2\u6838\u9500"}],"erpSalesOrder":null,"projectUsedClient":null,"remain_display":905,"progress_remain_display":905,"forecast_remain_display":905,"projectProductTotalAmount":26808,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":1,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":false,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":false,"can_payment":false,"duration_display":58,"contract_type_display":"\u8fd0\u7ef4\u670d\u52a1","can_change_status":false,"is_admin":false,"lost_contact_days_display":"2\u5e74\u524d","can_view_product":true,"budget_display":"2.68\u4e07","contact_points_status_display":"\u5df2\u6838\u9500","verify_display":0},{"id":3099,"client_id":90,"project_status":3,"project_progress":9,"budget":"4000","profit_pct":"93","bargain_date":"2023-02-07","description":"\u79df\u7528\u601d\u79d1\u4ea4\u6362\u673a","created_by":5295,"created_at":"2023-01-31 21:12:55","updated_at":"2023-12-07 18:24:05","engineer_id":null,"project_title":"\u79df\u7528\u4ea4\u6362\u673a","collected":"4000","status_updated_at":"2023-03-16 10:54:26.252121+08","success_rate":null,"comment":"\u79df\u7528\u601d\u79d1\u4ea4\u6362\u673a\r\n","contract_type":1,"progress_updated_at":"2023-02-07 19:05:13.310698+08","forecast_updated_at":"2023-03-13 12:05:58.78476+08","end_at":"2023-03-31 09:45:21","pinyin_shortcut":"zyjhj","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":4000,"change_status_to":null,"is_verify":false,"profits":"3720.0000000000000000","remain":"875 days 23:24:05.807402","progress_remain":"912 days 15:13:18.748825","forecast_remain":"878 days 22:12:33.274763","lost_contact_days":"876.044121059294","last_contact":"2023-03-16 09:15:00","last_arrive_days":null,"last_arrive":null,"duration":"58 days 12:32:26.055407","issued_invoices":"4000.00","client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"client_type":1,"client_class":1,"client_industry":10,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237","notice_days":10,"color":"#E89F0E"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3099,"value":"1","key":1015,"name":"\u5434\u660a"}],"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":"4000.00","pct":"93","profit":"3720","project_id":3099}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":{"project_id":3099,"points":"161"},"workLogCount":{"project_id":3099,"count":6},"caseCount":{"project_id":3099,"count":3},"salesTimeCount":null,"implementTimeCount":{"project_id":3099,"sum":"8.95","times":"2"},"presalesTimeCount":{"project_id":3099,"sum":"0.666666666666667","times":"1"},"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3099,"sum":"97"},"buildContract":{"id":2593,"from_project":3099,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WZW-2023020715","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"4000","contractScans":[{"id":17887,"object_type":105,"object_id":2593,"attachment_id":12436,"attachment":{"id":12436,"key":12436,"name":"16b642d7-301f-3440-af28-a1ce7ab15530","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/16b642d7-301f-3440-af28-a1ce7ab15530\/2023_03_16_11_27_46.pdf","orig_name":"2023_03_16_11_27_46.pdf"}}],"receiptScans":[{"id":17754,"object_type":106,"object_id":2593,"attachment_id":12438,"attachment":{"id":12438,"key":12438,"name":"5e2a409c-b12b-3648-b1eb-c38824e96854","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/5e2a409c-b12b-3648-b1eb-c38824e96854\/\u82cf\u9ece\u4e16.pdf","orig_name":"\u82cf\u9ece\u4e16.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":478,"serial_no":"SKD-20230331-00001","wrote_date":"2023-03-31","from_date":null,"handler":5295,"user_id":null,"client_id":90,"sales_contract_id":2593,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2023-03-31 09:45:21","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"4000","settle_amount":"4000","created_by":1014,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2023-03-31 09:45:21","updated_at":"2023-03-31 09:45:21","paid_amount":null}],"salesContractPayments":[{"id":"1478","key":"1478","contract_id":2593,"value":"4000","created_by":1014,"createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1362,"key":1362,"contract_id":2593,"value":"4000.00","attachment_id":null,"from_date":"2023-03-16","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1182,"key":1182,"contract_id":2593,"name":"2023-04-30","value":"4000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":3682,"user_id":5295,"key":5295,"contract_id":2593,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"\u4e0d\u63d0\u9192"},"projectRemindReceivers":[{"id":435,"user_id":1001,"key":1001,"project_id":3099,"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":20,"project_id":3099,"product_id":941,"amount":"2000","number":2,"cost":"0","description":null,"supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"4000","total_cost":"0","erp_sales_order_product_id":null,"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":"2023-08-11 16:02:47","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":null}],"commentCount":{"object_id":3099,"comment":4},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"remain_display":875,"progress_remain_display":912,"forecast_remain_display":878,"projectProductTotalAmount":4000,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":2,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":false,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":false,"can_payment":false,"duration_display":58,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":false,"lost_contact_days_display":"2\u5e74\u524d","can_view_product":true,"budget_display":"4000","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0}],"pagenation":{"totalcount":46,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-08-08 10:18:32') RETURNING "id" |