6868bfbf5ed9f: POST https://beta.jinchangxiao.com/vue/analysis/client-project-list at 2025-07-05 02:01:35 pm by 223.72.35.175
Database Queries
总计41条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 14:01:35.392 | 2.9 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=5250 |
| 14:01:35.400 | 1.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250 |
| 14:01:35.404 | 1.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='5') AND ("deleted"=FALSE) |
| 14:01:35.411 | 15.0 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 (project_status != 3) AND ("p"."client_id"=5) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC) "c" |
| 14:01:35.427 | 14.3 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 (project_status != 3) AND ("p"."client_id"=5) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC LIMIT 20 |
| 14:01:35.442 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=5 |
| 14:01:35.443 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id"=6 |
| 14:01:35.443 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=47 |
| 14:01:35.444 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id"=6 |
| 14:01:35.444 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2) |
| 14:01:35.445 | 0.8 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 (3150, 3151, 2897, 1519) |
| 14:01:35.446 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=4 |
| 14:01:35.447 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "project_progress" AS "name" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (5, 2) |
| 14:01:35.447 | 1.0 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 (3150, 3151, 2897, 1519) |
| 14:01:35.448 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3150, 3151, 2897, 1519) |
| 14:01:35.449 | 0.7 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (5, 227, 160, 140, 128, 179, 172, 184, 194, 2, 185, 191, 319, 196, 204, 188, 1, 164, 232, 215, 181, 153, 340, 355, 369, 373)) ORDER BY "sort" |
| 14:01:35.450 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3150, 3151, 2897, 1519) |
| 14:01:35.450 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (5, 227, 160, 140, 128, 179, 172, 184, 194, 2, 185, 191, 319, 196, 204, 188, 1, 164, 232, 215, 181, 153, 340, 355, 369, 373)) ORDER BY "sort" |
| 14:01:35.451 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3150, 3151, 2897, 1519) |
| 14:01:35.452 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (5, 227, 160, 140, 128, 179, 172, 184, 194, 2, 185, 191, 319, 196, 204, 188, 1, 164, 232, 215, 181, 153, 340, 355, 369, 373)) ORDER BY "sort" |
| 14:01:35.452 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
| 14:01:35.453 | 0.8 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1004) |
| 14:01:35.454 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
| 14:01:35.454 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
| 14:01:35.455 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1004) |
| 14:01:35.455 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=5 |
| 14:01:35.456 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
| 14:01:35.456 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1004) |
| 14:01:35.456 | 3.3 ms | SELECT | SELECT s.id, project_id, client_id, schedule_title, end_at, created_by, is_complete, is_closed, complete_description, set_top_at, CASE WHEN is_complete = true THEN 3 WHEN is_complete = false AND end_at <= NOW() THEN 2 ELSE 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (("is_complete"=FALSE) OR ("end_at" >= '2025-06-21')) AND ((("is_public"=1) AND ("created_by" != 5250)) OR ("created_by"=5250) OR ("ccr"."user_id"=5250)) AND ("s"."project_id" IN (3150, 3151, 2897, 1519)) ORDER BY set_top_at DESC nulls last, sort ASC, CASE WHEN is_complete = true THEN complete_at END DESC, CASE WHEN is_complete = false THEN end_at END ASC, end_at DESC |
| 14:01:35.460 | 0.6 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 (3150, 3151, 2897, 1519)) GROUP BY "project_id" |
| 14:01:35.461 | 8.8 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 (3150, 3151, 2897, 1519)) GROUP BY "c"."project_id" |
| 14:01:35.470 | 3.3 ms | SELECT | SELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_pre_sales" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=1) AND ("c"."project_id" IN (3150, 3151, 2897, 1519)) GROUP BY "c"."project_id" |
| 14:01:35.473 | 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 (3150, 3151, 2897, 1519)) GROUP BY "project_id" |
| 14:01:35.474 | 2.0 ms | SELECT | SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (3, 2)) AND ("project_id" IN (3150, 3151, 2897, 1519)) GROUP BY "project_id" |
| 14:01:35.476 | 0.8 ms | SELECT | SELECT "id", "from_project", "payment_collection_remind_ahead" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3150, 3151, 2897, 1519) |
| 14:01:35.477 | 23.2 ms | SELECT | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (3150, 3151, 2897, 1519)) GROUP BY "object_id" |
| 14:01:35.501 | 19.5 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=1) AND (remind_user_id = 5250 AND is_read = false) AND ("object_id" IN (3150, 3151, 2897, 1519)) GROUP BY "object_id" |
| 14:01:35.524 | 0.8 ms | SELECT | SELECT count(*) as count, sum(budget), "project_status" FROM (SELECT budget, CASE WHEN project_status = 3 and budget <= collected THEN -1 WHEN project_status = 3 and budget > collected THEN 3 ELSE project_status END as project_status FROM "a57be577deb434"."tbl_projects" "p" WHERE ("p"."client_id"=5) AND (project_status != 3)) "sub" GROUP BY "project_status" |
| 14:01:35.526 | 5.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5250) AND ("object_type"=23) AND ("visit_date"='2025-07-05') |
| 14:01:35.531 | 1.2 ms | UPDATE | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=113, "last_visit_at"='now()' WHERE "id"=49799 |
| 14:01:35.533 | 2.6 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5250, 5, 'vue/analysis/client-project-list', '{"id":"5","other":"1","page":"1","status":"other_budgets","web_access_token":"lF6lDSiCl5CRIFfE8shlx2wSeme229Hs"}', '{"code":2000,"result":{"list":[{"id":3150,"client_id":5,"project_status":4,"project_progress":5,"budget":"2550000","profit_pct":"40","bargain_date":"2023-05-18","description":"\u601d\u79d1\u53canetapp\u8bbe\u5907\u7eed\u4fdd","created_by":1004,"created_at":"2023-03-13 17:36:32","updated_at":"2025-03-04 17:02:54","engineer_id":"","project_title":"2023\u5e74\u786c\u4ef6\u7eed\u4fdd-C","collected":"0","status_updated_at":"2023-05-08 20:02:43.170129+08","success_rate":"","comment":"\u601d\u79d1\u53canetapp\u8bbe\u5907\u7eed\u4fdd\r\n","contract_type":1,"progress_updated_at":"2023-03-13 17:36:32.045121+08","forecast_updated_at":"2023-05-08 20:02:43.170129+08","end_at":"2023-05-08 20:02:43","pinyin_shortcut":"2023nyjxbC","creator":1004,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"profits":"1020000.000000000000","remain":"788 days 17:58:52.258639","progress_remain":"844 days 20:25:03.383647","forecast_remain":"788 days 17:58:52.258639","lost_contact_days":"616.997632277407","last_contact":"2023-10-27 14:05:00","last_arrive_days":"","last_arrive":"","duration":"56 days 02:26:11.125008","issued_invoices":"","client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":47,"client_industry":6,"sales_rep":1004,"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":6,"key":6,"name":"\u7535\u5546"}},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3150,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7"},"projectProductTypes":[{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"2550000.00","pct":"40","profit":"1020000","project_id":3150}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":128,"key":128,"name":"\u516c\u5f00\u62db\u6807"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"schedules":[],"salesTimeCount":{},"implementTimeCount":{"project_id":3150,"sum":"528.466666666667","times":"150"},"presalesTimeCount":{"project_id":3150,"sum":"27","times":"3"},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":3150,"sum":"30048.06"},"buildContract":{},"commentCount":{"object_id":3150,"comment":2},"unreadComments":{},"lost_contact_days_display":"1\u5e74\u524d","last_arrive_days_display":"","unissued_invoice":2550000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","remain_display":788,"progress_remain_display":844,"forecast_remain_display":788,"duration_display":56,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"budget_display":"255\u4e07"},{"id":3151,"client_id":5,"project_status":4,"project_progress":5,"budget":"3400000","profit_pct":"30","bargain_date":"2023-04-30","description":"VMware+veeam\u8f6f\u4ef6\u7eed\u4fdd","created_by":1004,"created_at":"2023-03-13 17:39:02","updated_at":"2025-01-16 13:40:53","engineer_id":"","project_title":"2023\u5e74\u8f6f\u4ef6\u7eed\u4fdd\u9879\u76ee","collected":"0","status_updated_at":"2023-04-17 17:48:40.13089+08","success_rate":"","comment":"VMware+veeam\u8f6f\u4ef6\u7eed\u4fdd\r\n","contract_type":1,"progress_updated_at":"2023-03-13 17:39:02.721904+08","forecast_updated_at":"2023-04-17 17:48:40.13089+08","end_at":"2023-04-17 17:48:40","pinyin_shortcut":"2023nrjxbxm","creator":1004,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"profits":"1020000.000000000000","remain":"809 days 20:12:55.297878","progress_remain":"844 days 20:22:32.706864","forecast_remain":"809 days 20:12:55.297878","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"35 days 00:09:37.408986","issued_invoices":"","client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":47,"client_industry":6,"sales_rep":1004,"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":6,"key":6,"name":"\u7535\u5546"}},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3151,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7"},"projectProductTypes":[{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"3400000.00","pct":"30","profit":"1020000","project_id":3151}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":128,"key":128,"name":"\u516c\u5f00\u62db\u6807"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"schedules":[],"salesTimeCount":{},"implementTimeCount":{"project_id":3151,"sum":"26.4833333333333","times":"15"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":3151,"sum":"221.76"},"buildContract":{},"commentCount":{"object_id":3151,"comment":2},"unreadComments":{},"lost_contact_days_display":"","last_arrive_days_display":"","unissued_invoice":3400000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","remain_display":809,"progress_remain_display":844,"forecast_remain_display":809,"duration_display":35,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"budget_display":"340\u4e07"},{"id":2897,"client_id":5,"project_status":4,"project_progress":5,"budget":"68160","profit_pct":"30","bargain_date":"2022-08-31","description":"\u8054\u60f3SR650\u670d\u52a1\u56686\u53f0\u7eed\u4fdd","created_by":1004,"created_at":"2022-07-10 20:30:18","updated_at":"2022-08-21 15:16:12","engineer_id":"","project_title":"\u8054\u60f3\u670d\u52a1\u5668\u7eed\u4fdd","collected":"0","status_updated_at":"2022-08-21 14:57:31.4799+08","success_rate":"","comment":"\u8054\u60f3SR650\u670d\u52a1\u56686\u53f0\u7eed\u4fdd\r\n","contract_type":2,"progress_updated_at":"2022-07-10 20:30:18.873602+08","forecast_updated_at":"2022-08-21 14:57:31.4799+08","end_at":"2022-08-21 14:57:31","pinyin_shortcut":"lxfwqxb","creator":1004,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"profits":"20448.0000000000000000","remain":"1048 days 23:04:03.948868","progress_remain":"1090 days 17:31:16.555166","forecast_remain":"1048 days 23:04:03.948868","lost_contact_days":"1052.13999338852","last_contact":"2022-08-18 10:40:00","last_arrive_days":"","last_arrive":"","duration":"41 days 18:27:12.606298","issued_invoices":"","client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":47,"client_industry":6,"sales_rep":1004,"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":6,"key":6,"name":"\u7535\u5546"}},"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[],"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7"},"projectProductTypes":[{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"68160.00","pct":"30","profit":"20448","project_id":2897}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"schedules":[],"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{},"commentCount":{"object_id":2897,"comment":2},"unreadComments":{},"lost_contact_days_display":"2\u5e74\u524d","last_arrive_days_display":"","unissued_invoice":68160,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","remain_display":1048,"progress_remain_display":1090,"forecast_remain_display":1048,"duration_display":41,"contract_type_display":"\u8fd0\u7ef4\u670d\u52a1","can_change_status":true,"budget_display":"6.82\u4e07"},{"id":1519,"client_id":5,"project_status":4,"project_progress":2,"budget":"2800000.00","profit_pct":"40","bargain_date":"2020-05-31","description":"netapp A800\u4e00\u5957","created_by":1004,"created_at":"2019-10-21 09:06:10","updated_at":"2024-12-24 14:39:46","engineer_id":"","project_title":"\u6570\u636e\u5e93\u5b58\u50a8","collected":"0","status_updated_at":"2020-06-01 08:44:00.906526+08","success_rate":"","comment":"netapp A800\u4e00\u5957\r\n1.\u5ba2\u6237\u5173\u6ce8\u70b9\uff1a\u670d\u52a1\u80fd\u529b\n2.\u8d62\u5355\u5173\u952e\u6761\u4ef6\uff1a\u641e\u5b9a\u4fe1\u606f\u4e2d\u5fc3CIO\n3.\u9879\u76ee\u89e3\u51b3\u7684\u95ee\u9898\uff1a\u6570\u636e\u5e93\u6027\u80fd\u3002\n4.\u5ba2\u6237\u503e\u5411\u7684\u65b9\u6848\u662f\uff1a\u5ba2\u6237\u81ea\u9009\uff1f\u6211\u4eec\u63a8\u8350\uff1f\u7ade\u4e89\u5bf9\u624b\u63a8\u8350\uff1f\uff0c\u6211\u4eec\u63a8\u8350\u3002\n5.\u7ade\u4e89\u5bf9\u624b\u7684\u65b9\u6848\uff1a\u65e0\n6.\u662f\u5426\u6709\u9886\u8def\u4eba\uff1a\u6709\n7.\u5ba2\u6237\u5173\u952e\u4eba\u662f\u5426\u652f\u6301\u6211\u4eec\uff1a\u662f\u7684\n8.\u5382\u5546\u662f\u5426\u652f\u6301\u6211\u4eec\uff1a\u672a\u77e5\n9.\u5408\u4f5c\u65b9\u5f0f\uff1a\u5ba2\u6237\u6346\u7ed1\uff1f\u5382\u5546\u6346\u7ed1\uff1f\u8ddf\u5ba2\u6237\u6346\u7ed1\u3002\n10.\u4ed8\u6b3e\u65b9\u5f0f\uff1a\u4ea4\u8d27\u540e30\u5929\n11.\u51b3\u7b56\u6d41\u7a0b\uff1a\u4fe1\u606f\u4e2d\u5fc3\u65b9\u6848\u5ba1\u6838-\u4fe1\u606f\u4e2d\u5fc3\u7533\u8bf7-\u8001\u603b\u5ba1\u6279-\u9080\u6807\u3002\n12.\u6211\u7684\u95ee\u9898\uff1a\u65e0 ","contract_type":1,"progress_updated_at":"2020-06-01 08:44:00.906526+08","forecast_updated_at":"2020-06-01 08:44:00.906526+08","end_at":"2021-06-01 09:21:49","pinyin_shortcut":"sjkcc","creator":1004,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"profits":"1120000.000000000000","remain":"1860 days 05:17:34.522242","progress_remain":"1860 days 05:17:34.522242","forecast_remain":"1860 days 05:17:34.522242","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"589 days 00:15:39.346286","issued_invoices":"","client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":47,"client_industry":6,"sales_rep":1004,"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":6,"key":6,"name":"\u7535\u5546"}},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":1519,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"2800000.00","pct":"40","profit":"1120000","project_id":1519}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":128,"key":128,"name":"\u516c\u5f00\u62db\u6807"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"schedules":[],"salesTimeCount":{},"implementTimeCount":{"project_id":1519,"sum":"22.2","times":"10"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":1519,"sum":"449.48"},"buildContract":{},"commentCount":{},"unreadComments":{},"lost_contact_days_display":"","last_arrive_days_display":"","unissued_invoice":2800000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","remain_display":1860,"progress_remain_display":1860,"forecast_remain_display":1860,"duration_display":589,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"budget_display":"280\u4e07"}],"count":[{"count":0,"key":1,"name":"\u9690\u6027\u9700\u6c42","sum":0},{"count":0,"key":2,"name":"\u660e\u786e\u9700\u6c42","sum":0},{"count":0,"key":3,"name":"\u5546\u673a\u6210\u4ea4","sum":0},{"count":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","sum":"8818160.00"},{"count":0,"key":5,"name":"\u5546\u673a\u6401\u7f6e","sum":0},{"count":0,"key":-1,"name":"\u6536\u6b3e\u5b8c\u6210","sum":0}],"can_create":false,"pagenation":{"totalcount":4,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-05 14:01:35') RETURNING "id" |