6a2101e100289: POST https://beta.jinchangxiao.com/vue/project/list at 2026-06-04 12:41:04 pm by 221.216.117.119
Performance Profiling
Total processing time: 2,670 ms; Peak memory: 8.213 MB. Show Profiling Timeline
总计74条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 12:41:07.368 | 78.2 ms | yii\db\Command::query | SELECT SUM(case when need_analysis = true THEN amount ELSE 0 END) FROM "a57be577deb434"."tbl_sales_contracts" WHERE ("id" IN (SELECT "id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (SELECT "p"."id" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) GROUP BY "p"."id"))) AND ("including_tax"=TRUE) |
| 12:41:06.893 | 76.2 ms | yii\db\Command::query | SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) GROUP BY "p"."id" ORDER BY "p"."created_at" LIMIT 20 |
| 12:41:07.453 | 61.1 ms | yii\db\Command::query | SELECT SUM(erp_settle_amount) FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (SELECT "id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (SELECT "p"."id" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) GROUP BY "p"."id")) |
| 12:41:06.833 | 59.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) GROUP BY "p"."id" ORDER BY "p"."created_at") "c" |
| 12:41:07.112 | 53.8 ms | yii\db\Command::query | SELECT count(*) as count, sum(budget), "project_status" FROM (SELECT p.budget, CASE WHEN project_status = 3 and p.budget <= collected THEN -1 WHEN project_status = 3 and p.budget > collected THEN 3 ELSE project_status END as project_status FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) GROUP BY "p"."id") "sub" GROUP BY "project_status" |
| 12:41:07.514 | 52.7 ms | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (SELECT "id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (SELECT "p"."id" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) GROUP BY "p"."id")) |
| 12:41:07.316 | 51.7 ms | yii\db\Command::query | SELECT SUM(case when need_analysis = true THEN amount ELSE 0 END) FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (SELECT "id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (SELECT "p"."id" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) GROUP BY "p"."id")) |
| 12:41:07.568 | 50.5 ms | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (SELECT "id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE ("id" IN (SELECT "id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (SELECT "p"."id" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) GROUP BY "p"."id"))) AND ("including_tax"=TRUE)) |
| 12:41:07.166 | 49.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) GROUP BY "p"."id") "sub" |
| 12:41:07.241 | 39.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("p"."project_status"=3) GROUP BY "p"."id") "sub" |
| 12:41:07.619 | 37.5 ms | yii\db\Command::query | SELECT SUM(total_contact_point - coalesce(paid_contact_point, 0)) FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (SELECT "from_project" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (SELECT "id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (SELECT "p"."id" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) GROUP BY "p"."id"))) |
| 12:41:07.281 | 33.8 ms | yii\db\Command::query | SELECT SUM(budget) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("p"."project_status"=3) GROUP BY "p"."id") "sub" |
| 12:41:07.055 | 27.0 ms | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23)) GROUP BY "object_id" |
| 12:41:07.217 | 23.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("p"."project_status" IN (1, 2)) GROUP BY "p"."id") "sub" |
| 12:41:07.082 | 22.0 ms | yii\db\Command::query | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=1) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23)) GROUP BY "object_id" |
| 12:41:07.013 | 10.6 ms | yii\db\Command::query | SELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(left_at - arrived_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_implement_records" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=2) AND ("c"."project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23)) GROUP BY "c"."project_id" |
| 12:41:07.003 | 6.0 ms | yii\db\Command::query | SELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", sum(points) as points FROM "a57be577deb434"."tbl_case_assignments" GROUP BY "case_id") "ca" ON ca.case_id = c.id WHERE "c"."project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23) GROUP BY "c"."project_id" |
| 12:41:07.661 | 4.3 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/project/list', '{"ProjectSearch":{"group":"1","project_status":"","creator":"","purchaseType":"","engineer_group":"","period":"","budget":"","profit_pct":"","invoice_status":"","payment_status":"","collected_plan":"","project_progress":"","salesForecast":"","projectProductTypes":"","contact_point_status":"","from_contact_name":"","from_contact":"","contract_type":"","is_sales_order_ready":"","created_period":""},"Filter":{"name":"created_at","sort":"ASC"},"page":"1","web_access_token":"-ooNs73DKJQ01PCpcbuHx_usnaO5SdwJ"}', '{"code":2000,"result":{"count":{"statusCount":[{"count":16,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#f49b00","sum":"27134400"},{"count":51,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#4e6ef2","sum":"73265232.06"},{"count":59,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#3fad00","sum":"41073624.17"},{"count":472,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a","sum":"176920434.10"},{"count":916,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222","sum":"365269837.27"},{"count":1638,"key":-1,"name":"\u6536\u6b3e\u5b8c\u6210","color":"#6200fe","sum":"356414006.45"}]},"simpleCount":[{"name":"\u5546\u673a\u603b\u6570\u91cf","value":3152},{"name":"\u5546\u673a\u8fdb\u884c\u4e2d","value":67},{"name":"\u5546\u673a\u6210\u4ea4\u6570\u91cf","value":1697},{"name":"\u603b\u91d1\u989d","value":"397487630.62"}],"list":[{"id":2,"client_id":5,"project_status":3,"project_progress":10,"budget":"4065723","profit_pct":"30","bargain_date":"2017-08-31","description":"\u601d\u79d1UCS UCS B200*6\/B420*4\/N9372*2\/3560*4\/2960*3\/vspere*8\/\u5b58\u50a8LIes\/DS9148S*2\u7b49\uff08\u6210\u5355\u738780%\uff09","created_by":1004,"created_at":"2017-02-08 16:42:36","updated_at":"2021-06-29 16:59:28","engineer_id":1017,"project_title":"\u6570\u636e\u4e2d\u5fc3\u5bb9\u707e\u5907\u4efd","collected":"4065723","status_updated_at":"2018-05-23 10:24:44.115055+08","success_rate":100,"comment":"\u601d\u79d1UCS UCS B200*6\/B420*4\/N9372*2\/3560*4\/2960*3\/vspere*8\/\u5b58\u50a8LIes\/DS9148S*2\u7b49\uff08\u6210\u5355\u738780%\uff09\r\n","contract_type":1,"progress_updated_at":"2019-05-05 20:29:03.988722+08","forecast_updated_at":"2019-05-05 20:29:03.988722+08","end_at":"2019-05-05 20:29:03","pinyin_shortcut":"sjzxrzbf","creator":1004,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"1219716.900000000000","remain":"2934 days 02:16:22.780075","progress_remain":"2586 days 16:12:02.906408","forecast_remain":"2586 days 16:12:02.906408","lost_contact_days":"2277.09799647141","last_contact":"2020-03-10 10:20:00","last_arrive_days":"","last_arrive":"","duration":"816 days 03:46:27.034134","issued_invoices":"4065723","client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":47,"client_industry":6,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":6,"key":6,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":6,"key":6,"name":"\u7535\u5546"}},"usedClient":{},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":2,"value":"0.5","key":1015,"name":"\u5434\u660a"},{"project_id":2,"value":"0.5","key":1017,"name":"\u8f66\u660e\u98de"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":85,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"951400.00","pct":"30","profit":"285420","project_id":2},{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"2237064.00","pct":"30","profit":"671119.2","project_id":2},{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"80000.00","pct":"30","profit":"24000","project_id":2},{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"344187.00","pct":"30","profit":"103256.1","project_id":2},{"id":88,"product_type_id":88,"key":88,"name":"\u79c1\u6709\u4e91","budget":"453072.00","pct":"30","profit":"135921.6","project_id":2}],"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":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":{"project_id":2,"points":"346"},"workLogCount":{"project_id":2,"count":1},"caseCount":{"project_id":2,"count":10},"salesTimeCount":{},"implementTimeCount":{"project_id":2,"sum":"57.5","times":"9"},"presalesTimeCount":{"project_id":2,"sum":"0.75","times":"1"},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":2,"sum":"3115.64"},"buildContract":{"id":229,"from_project":2,"payment_collection_remind_ahead":"00:00:00","serial_no":"H20170831S01","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"4065723","erp_un_settle_amount":"0","including_tax":true,"amount":"4065723","contractScans":[{"id":12492,"object_type":105,"object_id":229,"attachment_id":665,"attachment":{"id":665,"key":665,"name":"c2bf8ba9-e249-35d4-ab50-c7d3b190e365","extension":"pdf","path":"\/vue\/attachment\/preview\/c2bf8ba9-e249-35d4-ab50-c7d3b190e365\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\u201420170831\u20144065723.pdf","orig_name":"\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\u201420170831\u20144065723.pdf"}}],"receiptScans":[{"id":13225,"object_type":106,"object_id":229,"attachment_id":676,"attachment":{"id":676,"key":676,"name":"5b89ab3e-1a6f-3636-a7a3-61e83b6bf812","extension":"pdf","path":"\/vue\/attachment\/preview\/5b89ab3e-1a6f-3636-a7a3-61e83b6bf812\/\u666e\u5929\u592a\u529b\u201420171127.pdf","orig_name":"\u666e\u5929\u592a\u529b\u201420171127.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":1372,"serial_no":"SKD-20170831-00003","wrote_date":"","from_date":"","handler":1004,"user_id":"","client_id":5,"sales_contract_id":229,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2017-08-31 14:23:57","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"203286.00","settle_amount":"203286.00","created_by":"","stop_description":"","is_settle":true,"is_old":true,"created_at":"2017-08-31 14:23:57","updated_at":"2017-08-31 14:23:57","paid_amount":"","contact_id":"","bank_settle_at":"","print_times":""},{"id":1371,"serial_no":"SKD-20170831-00002","wrote_date":"","from_date":"","handler":1004,"user_id":"","client_id":5,"sales_contract_id":229,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2017-08-31 14:23:57","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"3862437.00","settle_amount":"3862437.00","created_by":"","stop_description":"","is_settle":true,"is_old":true,"created_at":"2017-08-31 14:23:57","updated_at":"2017-08-31 14:23:57","paid_amount":"","contact_id":"","bank_settle_at":"","print_times":""}],"salesContractPayments":[{"id":"11372","key":"11372","contract_id":229,"value":"203286.00","created_by":"","collected_date":"","createdBy":{},"pct":5},{"id":"11371","key":"11371","contract_id":229,"value":"3862437.00","created_by":"","collected_date":"","createdBy":{},"pct":95}],"salesContractInvoices":[{"id":799,"key":799,"contract_id":229,"value":"4065723.00","attachment_id":"","from_date":"","attachment":{}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[{"id":109,"contract_id":229,"supplier_id":46,"purchase_id":285,"supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"purchase":{"id":285,"key":285,"serial_no":"-"}},{"id":278,"contract_id":229,"supplier_id":147,"purchase_id":393,"supplier":{"id":147,"key":147,"name":"\u6d6a\u6f6e\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"purchase":{"id":393,"key":393,"serial_no":"-"}},{"id":301,"contract_id":229,"supplier_id":46,"purchase_id":224,"supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"purchase":{"id":224,"key":224,"serial_no":"-"}},{"id":425,"contract_id":229,"supplier_id":68,"purchase_id":303,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":303,"key":303,"serial_no":"-"}},{"id":919,"contract_id":229,"supplier_id":68,"purchase_id":288,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":288,"key":288,"serial_no":"-"}},{"id":1347,"contract_id":229,"supplier_id":95,"purchase_id":295,"supplier":{"id":95,"key":95,"name":"\u5317\u4eac\u5de8\u548c\u62d3\u65b0\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":295,"key":295,"serial_no":"-"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":4065723},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":{"id":83,"serial_no":"XSDD-20170831-00002","from_date":"","wrote_date":"2017-08-31","handler":5015,"client_id":5,"purchase_contract_id":"","project_id":2,"sales_contract_id":229,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u865a\u62df\u5316\u3001\u7f51\u7edc ","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2019-05-05 20:29:03","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"4065723","created_by":5015,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2017-08-31 14:23:57","updated_at":"2019-05-05 20:29:03","print_times":""},"projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":2934,"progress_remain_display":2586,"forecast_remain_display":2586,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":816,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"6\u5e74\u524d","can_view_product":true,"budget_display":"406.57\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"can_view_product_cost":true},{"id":3,"client_id":12,"project_status":3,"project_progress":10,"budget":"16150","profit_pct":"17","bargain_date":"2017-02-09","description":"1.\u7f57\u6280\u9f20\u6807 M100 5\u4e2a\r\n2.Z440\u5de5\u4f5c\u7ad9 \uff1a\u5355E5-1630v3\/32GB DDR\/1TB \/ K2200 4GB\/525W\/\u952e\u9f20\/V223 \u4e00\u5957","created_by":1003,"created_at":"2017-02-09 11:57:39","updated_at":"2021-06-25 10:23:40","engineer_id":1020,"project_title":"hp\u5de5\u4f5c\u7ad9","collected":"16150","status_updated_at":"2017-05-31 15:34:38.705455+08","success_rate":100,"comment":"1.\u7f57\u6280\u9f20\u6807 M100 5\u4e2a\r\n2.Z440\u5de5\u4f5c\u7ad9 \uff1a\u5355E5-1630v3\/32GB DDR\/1TB \/ K2200 4GB\/525W\/\u952e\u9f20\/V223 \u4e00\u5957\r\n","contract_type":1,"progress_updated_at":"2019-05-14 11:17:27.411265+08","forecast_updated_at":"2019-05-14 11:17:27.411265+08","end_at":"2019-05-14 11:17:27","pinyin_shortcut":"hpgzz","creator":1003,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"2745.5000000000000000","remain":"3290 days 21:06:28.189675","progress_remain":"2578 days 01:23:39.483865","forecast_remain":"2578 days 01:23:39.483865","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"823 days 23:19:48.255543","issued_invoices":"16150","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":80,"client_industry":5,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"usedClient":{},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3,"value":"1","key":1020,"name":"\u738b\u6069\u56fd"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"16150","pct":"17","profit":"2745.5","project_id":3}],"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":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"}},"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"casePoints":"","workLogCount":"","caseCount":"","salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":2,"from_project":3,"payment_collection_remind_ahead":"00:00:00","serial_no":"-","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"16150","erp_un_settle_amount":"0","including_tax":true,"amount":"16150","contractScans":[{"id":12592,"object_type":105,"object_id":2,"attachment_id":122,"attachment":{"id":122,"key":122,"name":"e66c2a59-8b1c-39b9-bdcf-39902aea1aa1","extension":"pdf","path":"\/vue\/attachment\/preview\/e66c2a59-8b1c-39b9-bdcf-39902aea1aa1\/SMC_\u4e2d\u56fd_\u6709\u9650\u516c\u53f8\u201420170322\u201416150.pdf","orig_name":"SMC_\u4e2d\u56fd_\u6709\u9650\u516c\u53f8\u201420170322\u201416150.pdf"}}],"receiptScans":[{"id":13296,"object_type":106,"object_id":2,"attachment_id":26,"attachment":{"id":26,"key":26,"name":"9c77fe3d-28c3-35c8-b869-2dbbf33060f1","extension":"pdf","path":"\/vue\/attachment\/preview\/9c77fe3d-28c3-35c8-b869-2dbbf33060f1\/smc16150.pdf","orig_name":"smc16150.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":516,"serial_no":"SKD-20170209-00001","wrote_date":"","from_date":"","handler":5300,"user_id":"","client_id":12,"sales_contract_id":2,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2017-02-09 12:02:04","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"16150.00","settle_amount":"16150.00","created_by":"","stop_description":"","is_settle":true,"is_old":true,"created_at":"2017-02-09 12:02:04","updated_at":"2017-02-09 12:02:04","paid_amount":"","contact_id":"","bank_settle_at":"","print_times":""}],"salesContractPayments":[{"id":"1516","key":"1516","contract_id":2,"value":"16150.00","created_by":"","collected_date":"","createdBy":{},"pct":100}],"salesContractInvoices":[{"id":446,"key":446,"contract_id":2,"value":"16150.00","attachment_id":"","from_date":"","attachment":{}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"\u65e0","invoiced":16150},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":{"id":1,"serial_no":"XSDD-20170209-00001","from_date":"","wrote_date":"2017-02-09","handler":1010,"client_id":12,"purchase_contract_id":"","project_id":3,"sales_contract_id":2,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u8ba1\u7b97","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2019-05-14 11:17:27","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"16150","created_by":1010,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2017-02-09 12:02:04","updated_at":"2019-05-14 11:17:27","print_times":""},"projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":3290,"progress_remain_display":2578,"forecast_remain_display":2578,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":823,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"","can_view_product":true,"budget_display":"1.62\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"can_view_product_cost":true},{"id":4,"client_id":23,"project_status":4,"project_progress":2,"budget":"370000","profit_pct":"20","bargain_date":"2017-10-20","description":"2554 \u5f02\u5730\u5907\u4efd","created_by":1005,"created_at":"2017-02-09 12:32:55","updated_at":"2019-05-05 22:33:36","engineer_id":1015,"project_title":"2554 \u5f02\u5730\u5907\u4efd","collected":"0","status_updated_at":"2017-06-15 16:08:01.841928+08","success_rate":0,"comment":"2554 \u5f02\u5730\u5907\u4efd\r\n","contract_type":1,"progress_updated_at":"2019-05-05 22:33:36.993032+08","forecast_updated_at":"2019-05-05 22:33:36.993032+08","end_at":"2019-05-05 22:33:36","pinyin_shortcut":"2554ydbf","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"74000.0000000000000000","remain":"3275 days 20:33:05.053202","progress_remain":"2586 days 14:07:29.902098","forecast_remain":"2586 days 14:07:29.902098","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"815 days 10:00:41.714661","issued_invoices":"","client":{"id":23,"key":23,"name":"\u5a01\u8baf\u8054\u5408\u534a\u5bfc\u4f53(\u5317\u4eac)\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":5,"sales_rep":"","salesRep":"","clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"usedClient":{},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":4,"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","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"370000","pct":"20","profit":"74000","project_id":4}],"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":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesRep":"","casePoints":"","workLogCount":"","caseCount":"","salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":"","projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":3275,"progress_remain_display":2586,"forecast_remain_display":2586,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":370000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"","project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_invoice":false,"can_payment":false,"duration_display":815,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"","can_view_product":true,"budget_display":"37\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":0,"un_invoiced":0,"object_type":1,"can_view_product_cost":true},{"id":5,"client_id":20,"project_status":3,"project_progress":10,"budget":"2800000","profit_pct":"20","bargain_date":"2017-11-24","description":"\u4ea4\u6362\u673a\uff0c\u8def\u7531\u5668\uff0c\u9632\u706b\u5899\uff0c\u65e0\u7ebf","created_by":1005,"created_at":"2017-02-09 12:34:10","updated_at":"2024-12-25 15:17:21","engineer_id":1017,"project_title":"\u697c\u5b87\u7f51\u7edc\u65b0\u5efa\u9879\u76ee","collected":"2800000","status_updated_at":"2018-04-23 15:57:01.145126+08","success_rate":100,"comment":"\u4ea4\u6362\u673a\uff0c\u8def\u7531\u5668\uff0c\u9632\u706b\u5899\uff0c\u65e0\u7ebf\r\n","contract_type":1,"progress_updated_at":"2019-05-05 22:30:16.361831+08","forecast_updated_at":"2019-05-05 22:30:16.361831+08","end_at":"2019-05-05 22:30:16","pinyin_shortcut":"lywlxjxm","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"560000.000000000000","remain":"2963 days 20:44:05.750004","progress_remain":"2586 days 14:10:50.533299","forecast_remain":"2586 days 14:10:50.533299","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"815 days 09:56:06.268661","issued_invoices":"8400000","client":{"id":20,"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","logo":"","client_type":6,"client_class":47,"client_industry":5,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientType":{"id":6,"key":6,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"usedClient":{},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":5,"value":"1","key":1017,"name":"\u8f66\u660e\u98de"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":85,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"2067500.00","pct":"20","profit":"413500","project_id":5},{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"171500.00","pct":"20","profit":"34300","project_id":5},{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"561000.00","pct":"20","profit":"112200","project_id":5}],"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":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":129,"key":129,"name":"\u7279\u7ea6\u9080\u6807"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"casePoints":{"project_id":5,"points":"51"},"workLogCount":"","caseCount":{"project_id":5,"count":2},"salesTimeCount":{},"implementTimeCount":{"project_id":5,"sum":"3","times":"2"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":311,"from_project":5,"payment_collection_remind_ahead":"00:00:00","serial_no":"CHMC_XXB_2017_2","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"2800000","erp_un_settle_amount":"0","including_tax":true,"amount":"2800000","contractScans":[{"id":12702,"object_type":105,"object_id":311,"attachment_id":672,"attachment":{"id":672,"key":672,"name":"e709f87f-26bd-39d9-a830-adb2889e9590","extension":"pdf","path":"\/vue\/attachment\/preview\/e709f87f-26bd-39d9-a830-adb2889e9590\/\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u201420171124\u20143900000.pdf","orig_name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u201420171124\u20143900000.pdf"}}],"receiptScans":[{"id":13395,"object_type":106,"object_id":311,"attachment_id":1098,"attachment":{"id":1098,"key":1098,"name":"50eb7a6e-61e4-3a2c-be5e-0722976fb134","extension":"pdf","path":"\/vue\/attachment\/preview\/50eb7a6e-61e4-3a2c-be5e-0722976fb134\/\u91cd\u578b\u673a\u68b0.pdf","orig_name":"\u91cd\u578b\u673a\u68b0.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":1650,"serial_no":"SKD-20171124-00006","wrote_date":"","from_date":"","handler":1005,"user_id":"","client_id":20,"sales_contract_id":311,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2017-11-24 17:35:42","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"70000.00","settle_amount":"70000.00","created_by":"","stop_description":"","is_settle":true,"is_old":true,"created_at":"2017-11-24 17:35:42","updated_at":"2017-11-24 17:35:42","paid_amount":"","contact_id":"","bank_settle_at":"","print_times":""},{"id":1649,"serial_no":"SKD-20171124-00005","wrote_date":"","from_date":"","handler":1005,"user_id":"","client_id":20,"sales_contract_id":311,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2017-11-24 17:35:42","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"2730000.00","settle_amount":"2730000.00","created_by":"","stop_description":"","is_settle":true,"is_old":true,"created_at":"2017-11-24 17:35:42","updated_at":"2017-11-24 17:35:42","paid_amount":"","contact_id":"","bank_settle_at":"","print_times":""}],"salesContractPayments":[{"id":"11650","key":"11650","contract_id":311,"value":"70000.00","created_by":"","collected_date":"","createdBy":{},"pct":2.5},{"id":"11649","key":"11649","contract_id":311,"value":"2730000.00","created_by":"","collected_date":"","createdBy":{},"pct":97.5}],"salesContractInvoices":[{"id":297,"key":297,"contract_id":311,"value":"1950000.00","attachment_id":"","from_date":"","attachment":{}},{"id":484,"key":484,"contract_id":311,"value":"780000.00","attachment_id":"","from_date":"","attachment":{}},{"id":578,"key":578,"contract_id":311,"value":"70000.00","attachment_id":"","from_date":"","attachment":{}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[{"id":510,"contract_id":311,"supplier_id":122,"purchase_id":370,"supplier":{"id":122,"key":122,"name":"\u5317\u4eac\u6b23\u90a6\u5b9d\u901a\u8ba1\u7b97\u673a\u7f51\u7edc\u7cfb\u7edf\u5f00\u53d1\u6709\u9650\u516c\u53f8"},"purchase":{"id":370,"key":370,"serial_no":"-"}},{"id":549,"contract_id":311,"supplier_id":163,"purchase_id":358,"supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":358,"key":358,"serial_no":"-"}},{"id":777,"contract_id":311,"supplier_id":146,"purchase_id":340,"supplier":{"id":146,"key":146,"name":"\u5317\u4eac\u7f51\u5b89\u6377\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":340,"key":340,"serial_no":"-"}},{"id":940,"contract_id":311,"supplier_id":104,"purchase_id":388,"supplier":{"id":104,"key":104,"name":"\u5317\u4eac\u57fa\u4e1a\u50b2\u817e\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":388,"key":388,"serial_no":"-"}},{"id":1281,"contract_id":311,"supplier_id":204,"purchase_id":337,"supplier":{"id":204,"key":204,"name":"\u5317\u4eac\u946b\u88d5\u5bcc\u534e\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":337,"key":337,"serial_no":"-"}},{"id":2242,"contract_id":311,"supplier_id":675,"purchase_id":375,"supplier":{"id":675,"key":675,"name":"\u7d2b\u5149\u6570\u7801(\u82cf\u5dde)\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"purchase":{"id":375,"key":375,"serial_no":"20171208"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":2800000},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":{"id":119,"serial_no":"XSDD-20171124-00002","from_date":"","wrote_date":"2017-11-24","handler":5015,"client_id":20,"purchase_contract_id":"","project_id":5,"sales_contract_id":311,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u7f51\u7edc\u3001\u5b89\u5168\u3001\u5b58\u50a8 ","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2019-05-05 22:30:16","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"2800000","created_by":5015,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2017-11-24 17:35:42","updated_at":"2019-05-05 22:30:16","print_times":""},"projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":2963,"progress_remain_display":2586,"forecast_remain_display":2586,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":-5600000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":815,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"","can_view_product":true,"budget_display":"280\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"can_view_product_cost":true},{"id":6,"client_id":3,"project_status":4,"project_progress":1,"budget":"1500000","profit_pct":"20","bargain_date":"2017-12-31","description":"\u6df1\u4fe1\u670d\u865a\u62df\u684c\u9762*400\u4e2a\u70b9","created_by":1006,"created_at":"2017-02-09 16:37:28","updated_at":"2019-05-05 21:22:38","engineer_id":"","project_title":"\u6df1\u4fe1\u670d\u865a\u62df\u684c\u9762","collected":"0","status_updated_at":"2017-06-04 18:19:37.99473+08","success_rate":0,"comment":"\u6df1\u4fe1\u670d\u865a\u62df\u684c\u9762*400\u4e2a\u70b9\r\n","contract_type":1,"progress_updated_at":"2019-05-05 21:22:38.953946+08","forecast_updated_at":"2019-05-05 21:22:38.953946+08","end_at":"2019-05-05 21:22:38","pinyin_shortcut":"sxfxnzm","creator":1006,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"300000.000000000000","remain":"3286 days 18:21:28.9004","progress_remain":"2586 days 15:18:27.941184","forecast_remain":"2586 days 15:18:27.941184","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"815 days 04:45:10.23018","issued_invoices":"","client":{"id":3,"key":3,"name":"\u5317\u4eac\u4e50\u9014\u6c47\u8bda\u7f51\u7edc\u6280\u672f\u6709\u9650\u8d23\u4efb\u516c\u53f8-S","logo":"","client_type":1,"client_class":43,"client_industry":19,"sales_rep":"","salesRep":"","clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":19,"key":19,"name":"OTT"}},"usedClient":{},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{"id":1,"key":1,"name":"\u521d\u76f8\u8bc6","description":"\u5411\u5ba2\u6237\u4ecb\u7ecd\u81ea\u8eab\u4ef7\u503c\uff1a\n1.\u4ea7\u54c1\u9009\u578b\n2.\u6210\u672c\u4f18\u5316\n3.\u4ea7\u54c1\u4ea4\u4ed8\n4.\u540e\u671f\u8fd0\u7ef4"},"projectProductTypes":[{"id":94,"product_type_id":94,"key":94,"name":"\u6df1\u4fe1\u670dAdesk","budget":"1500000","pct":"20","profit":"300000","project_id":6}],"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":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"}},"salesRep":"","casePoints":"","workLogCount":"","caseCount":"","salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":"","projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":3286,"progress_remain_display":2586,"forecast_remain_display":2586,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":1500000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"","project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_invoice":false,"can_payment":false,"duration_display":815,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"","can_view_product":true,"budget_display":"150\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":0,"un_invoiced":0,"object_type":1,"can_view_product_cost":true},{"id":7,"client_id":24,"project_status":3,"project_progress":10,"budget":"178850","profit_pct":"20","bargain_date":"2017-03-23","description":"388G9*4","created_by":1006,"created_at":"2017-02-09 16:38:27","updated_at":"2024-01-16 17:36:26","engineer_id":1015,"project_title":"388G9*4","collected":"178850","status_updated_at":"2017-05-31 17:51:55.880206+08","success_rate":100,"comment":"388G9*4\r\n","contract_type":1,"progress_updated_at":"2019-05-05 21:51:42.736202+08","forecast_updated_at":"2019-05-05 21:51:42.736202+08","end_at":"2019-05-05 21:51:42","pinyin_shortcut":"388G94","creator":1006,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"35770.0000000000000000","remain":"3290 days 18:49:11.014924","progress_remain":"2586 days 14:49:24.158928","forecast_remain":"2586 days 14:49:24.158928","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"815 days 05:13:15.590427","issued_invoices":"178850","client":{"id":24,"key":24,"name":"\u4e2d\u822a\u946b\u6e2f\u62c5\u4fdd\u6709\u9650\u516c\u53f8","logo":"","client_type":1,"client_class":43,"client_industry":10,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":{},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":7,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"178850","pct":"20","profit":"35770","project_id":7}],"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":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"}},"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"casePoints":"","workLogCount":"","caseCount":"","salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":24,"from_project":7,"payment_collection_remind_ahead":"","serial_no":"TSC-X-2017022001","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"178850","erp_un_settle_amount":"0","including_tax":true,"amount":"178850","contractScans":[{"id":12684,"object_type":105,"object_id":24,"attachment_id":795,"attachment":{"id":795,"key":795,"name":"327f8a9e-8fbb-3149-a35f-34a92a07eb18","extension":"pdf","path":"\/vue\/attachment\/preview\/327f8a9e-8fbb-3149-a35f-34a92a07eb18\/\u4e2d\u822a\u946b\u6e2f\u62c5\u4fdd\u6709\u9650\u516c\u53f8\u201420170310\u2014178850.pdf","orig_name":"\u4e2d\u822a\u946b\u6e2f\u62c5\u4fdd\u6709\u9650\u516c\u53f8\u201420170310\u2014178850.pdf"}}],"receiptScans":[{"id":13379,"object_type":106,"object_id":24,"attachment_id":106,"attachment":{"id":106,"key":106,"name":"9b44257d-46ab-31a0-a26b-3deb991cfa72","extension":"pdf","path":"\/vue\/attachment\/preview\/9b44257d-46ab-31a0-a26b-3deb991cfa72\/\u4e2d\u822a\u946b\u6e2f.pdf","orig_name":"\u4e2d\u822a\u946b\u6e2f.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":1157,"serial_no":"SKD-20170303-00001","wrote_date":"","from_date":"","handler":5300,"user_id":"","client_id":24,"sales_contract_id":24,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2017-03-03 17:30:27","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"178850.00","settle_amount":"178850.00","created_by":"","stop_description":"","is_settle":true,"is_old":true,"created_at":"2017-03-03 17:30:27","updated_at":"2017-03-03 17:30:27","paid_amount":"","contact_id":"","bank_settle_at":"","print_times":""}],"salesContractPayments":[{"id":"11157","key":"11157","contract_id":24,"value":"178850.00","created_by":"","collected_date":"","createdBy":{},"pct":100}],"salesContractInvoices":[{"id":766,"key":766,"contract_id":24,"value":"178850.00","attachment_id":"","from_date":"","attachment":{}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"\u65e0","invoiced":178850},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":{"id":13,"serial_no":"XSDD-20170303-00001","from_date":"","wrote_date":"2017-03-23","handler":1010,"client_id":24,"purchase_contract_id":"","project_id":7,"sales_contract_id":24,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u8ba1\u7b97","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2019-05-05 21:51:42","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"178850","created_by":1010,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2017-03-03 17:30:27","updated_at":"2019-05-05 21:51:42","print_times":""},"projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":3290,"progress_remain_display":2586,"forecast_remain_display":2586,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":815,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"","can_view_product":true,"budget_display":"17.89\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"can_view_product_cost":true},{"id":8,"client_id":16,"project_status":5,"project_progress":1,"budget":"30000","profit_pct":"65","bargain_date":"2017-04-30","description":"webex 100\u65b9","created_by":1006,"created_at":"2017-02-09 16:43:11","updated_at":"2019-05-05 21:48:59","engineer_id":1017,"project_title":"webex \u670d\u52a1","collected":"0","status_updated_at":"2017-06-12 12:28:34.628695+08","success_rate":10,"comment":"webex 100\u65b9\r\n","contract_type":1,"progress_updated_at":"2019-05-05 21:48:59.728356+08","forecast_updated_at":"2019-05-05 21:48:59.728356+08","end_at":"2019-05-05 21:48:59","pinyin_shortcut":"webexfw","creator":1006,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"19500.0000000000000000","remain":"3279 days 00:12:32.266435","progress_remain":"2586 days 14:52:07.166774","forecast_remain":"2586 days 14:52:07.166774","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"815 days 05:05:48.295169","issued_invoices":"","client":{"id":16,"key":16,"name":"\u5317\u4eac\u6e38\u5b66\u7f51\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8","logo":"","client_type":1,"client_class":80,"client_industry":25,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"clientIndustry":{"id":25,"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"}},"usedClient":{},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":8,"value":"1","key":1017,"name":"\u8f66\u660e\u98de"}],"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{"id":1,"key":1,"name":"\u521d\u76f8\u8bc6","description":"\u5411\u5ba2\u6237\u4ecb\u7ecd\u81ea\u8eab\u4ef7\u503c\uff1a\n1.\u4ea7\u54c1\u9009\u578b\n2.\u6210\u672c\u4f18\u5316\n3.\u4ea7\u54c1\u4ea4\u4ed8\n4.\u540e\u671f\u8fd0\u7ef4"},"projectProductTypes":[{"id":71,"product_type_id":71,"key":71,"name":"\u5176\u4ed6","budget":"0","pct":"0","profit":"0","project_id":8},{"id":91,"product_type_id":91,"key":91,"name":"\u534f\u4f5c","budget":"0","pct":"0","profit":"0","project_id":8}],"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":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"}},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"casePoints":"","workLogCount":"","caseCount":"","salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":"","projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":3279,"progress_remain_display":2586,"forecast_remain_display":2586,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":30000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"","project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_invoice":false,"can_payment":false,"duration_display":815,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"","can_view_product":true,"budget_display":"3\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":0,"un_invoiced":0,"object_type":1,"can_view_product_cost":true},{"id":10,"client_id":16,"project_status":5,"project_progress":1,"budget":"100000","profit_pct":"40","bargain_date":"2017-04-30","description":"VPN\u8bbe\u5907*2","created_by":1006,"created_at":"2017-02-09 16:44:31","updated_at":"2019-05-05 21:48:19","engineer_id":"","project_title":"VPN\u8bbe\u5907","collected":"0","status_updated_at":"2017-06-02 18:14:25.852963+08","success_rate":10,"comment":"VPN\u8bbe\u5907*2\r\n","contract_type":1,"progress_updated_at":"2019-05-05 21:48:19.077071+08","forecast_updated_at":"2019-05-05 21:48:19.077071+08","end_at":"2019-05-05 21:48:19","pinyin_shortcut":"VPNsb","creator":1006,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"40000.0000000000000000","remain":"3288 days 18:26:41.042167","progress_remain":"2586 days 14:52:47.818059","forecast_remain":"2586 days 14:52:47.818059","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"815 days 05:03:48.02239","issued_invoices":"","client":{"id":16,"key":16,"name":"\u5317\u4eac\u6e38\u5b66\u7f51\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8","logo":"","client_type":1,"client_class":80,"client_industry":25,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"clientIndustry":{"id":25,"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"}},"usedClient":{},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{"id":1,"key":1,"name":"\u521d\u76f8\u8bc6","description":"\u5411\u5ba2\u6237\u4ecb\u7ecd\u81ea\u8eab\u4ef7\u503c\uff1a\n1.\u4ea7\u54c1\u9009\u578b\n2.\u6210\u672c\u4f18\u5316\n3.\u4ea7\u54c1\u4ea4\u4ed8\n4.\u540e\u671f\u8fd0\u7ef4"},"projectProductTypes":[{"id":71,"product_type_id":71,"key":71,"name":"\u5176\u4ed6","budget":"100000","pct":"40","profit":"40000","project_id":10}],"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":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":182,"key":182,"name":"\u56f4\u6807"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"}},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"casePoints":"","workLogCount":"","caseCount":"","salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":"","projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":3288,"progress_remain_display":2586,"forecast_remain_display":2586,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":100000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"","project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_invoice":false,"can_payment":false,"duration_display":815,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"","can_view_product":true,"budget_display":"10\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":0,"un_invoiced":0,"object_type":1,"can_view_product_cost":true},{"id":11,"client_id":25,"project_status":3,"project_progress":10,"budget":"5400","profit_pct":"81","bargain_date":"2018-03-12","description":"\uff08DS*1\uff0cAV*6\uff0cofficescan*1\uff09\u5b89\u88c5\u670d\u52a1\u8d39","created_by":1006,"created_at":"2017-02-09 16:56:15","updated_at":"2021-06-28 15:24:44","engineer_id":"","project_title":"\u8d8b\u52bf\u6740\u6bd2","collected":"5400","status_updated_at":"2018-05-18 15:03:58.941822+08","success_rate":100,"comment":"\uff08DS*1\uff0cAV*6\uff0cofficescan*1\uff09\u5b89\u88c5\u670d\u52a1\u8d39\r\n","contract_type":2,"progress_updated_at":"2019-05-05 21:13:26.260253+08","forecast_updated_at":"2019-05-05 21:13:26.260253+08","end_at":"2019-05-05 21:13:26","pinyin_shortcut":"qssd","creator":1006,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"4374.0000000000000000","remain":"2938 days 21:37:07.953308","progress_remain":"2586 days 15:27:40.634877","forecast_remain":"2586 days 15:27:40.634877","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"815 days 04:17:11.188354","issued_invoices":"5400","client":{"id":25,"key":25,"name":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u6559\u5e08\u8fdb\u4fee\u5b66\u6821","logo":"","client_type":1,"client_class":47,"client_industry":2,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":2,"key":2,"name":"\u6559\u80b2\uff08\u9ad8\u6821\uff09"}},"usedClient":{},"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":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"5400","pct":"81","profit":"4374","project_id":11}],"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":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"casePoints":"","workLogCount":"","caseCount":"","salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":479,"from_project":11,"payment_collection_remind_ahead":"00:00:00","serial_no":"-","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"5400","erp_un_settle_amount":"0","including_tax":true,"amount":"5400","contractScans":[{"id":12730,"object_type":105,"object_id":479,"attachment_id":1168,"attachment":{"id":1168,"key":1168,"name":"95a096ed-4691-38bd-990a-05e8083727ac","extension":"pdf","path":"\/vue\/attachment\/preview\/95a096ed-4691-38bd-990a-05e8083727ac\/\u5f00\u83b1\u5174\u4e1a.pdf","orig_name":"\u5f00\u83b1\u5174\u4e1a.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[{"id":788,"serial_no":"SKD-20180417-00001","wrote_date":"","from_date":"","handler":1005,"user_id":"","client_id":25,"sales_contract_id":479,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2018-04-17 10:05:18","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"5400.00","settle_amount":"5400.00","created_by":"","stop_description":"","is_settle":true,"is_old":true,"created_at":"2018-04-17 10:05:18","updated_at":"2018-04-17 10:05:18","paid_amount":"","contact_id":"","bank_settle_at":"","print_times":""}],"salesContractPayments":[{"id":"1788","key":"1788","contract_id":479,"value":"5400.00","created_by":"","collected_date":"","createdBy":{},"pct":100}],"salesContractInvoices":[{"id":317,"key":317,"contract_id":479,"value":"5400.00","attachment_id":"","from_date":"","attachment":{}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"\u65e0","invoiced":5400},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":11,"comment":1},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":{"id":176,"serial_no":"XSDD-20180417-00001","from_date":"","wrote_date":"2018-03-12","handler":5015,"client_id":25,"purchase_contract_id":"","project_id":11,"sales_contract_id":479,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u6280\u672f\u670d\u52a1\u8d39","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2019-05-05 21:13:26","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"5400","created_by":5015,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2018-04-17 10:05:18","updated_at":"2019-05-05 21:13:26","print_times":""},"projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":2938,"progress_remain_display":2586,"forecast_remain_display":2586,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":815,"contract_type_display":"\u8fd0\u7ef4\u670d\u52a1","can_change_status":false,"is_admin":true,"lost_contact_days_display":"","can_view_product":true,"budget_display":"5400","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"can_view_product_cost":true},{"id":12,"client_id":18,"project_status":4,"project_progress":7,"budget":"800000","profit_pct":"20","bargain_date":"2017-11-10","description":"Netapp FAST 8200 20T+2*9148S +\u90ae\u4ef6\u53caVEEAM\u6210\u5355\u7387\uff1a80%\uff0c\u5931\u8d25\u539f\u56e0\uff1a\u56e0\u4e3a\u6211\u4eec\u5bf9\u8f6f\u4ef6\u90e8\u4efd\u7684Excheng\u65b9\u6848\u6ca1\u6709\uff0c\u4e0d\u4e13\u4e1a\uff0c\u5ba2\u6237\u611f\u89c9\u6211\u4eec\u4e0d\u91cd\u89c6\u53ca\u6280\u672f\u80fd\u529b\u4e0d\u884c\u3002\u6240\u4ee5\u6ca1\u9009\u62e9\u6211\u4eec\u3002","created_by":1004,"created_at":"2017-02-09 17:16:23","updated_at":"2021-08-24 22:16:38","engineer_id":1015,"project_title":"\u5b58\u50a8\u5907\u4efd\u6539\u9020","collected":"0","status_updated_at":"2017-08-07 20:15:31.009763+08","success_rate":0,"comment":"Netapp FAST 8200 20T+2*9148S +\u90ae\u4ef6\u53caVEEAM\u6210\u5355\u7387\uff1a80%\uff0c\u5931\u8d25\u539f\u56e0\uff1a\u56e0\u4e3a\u6211\u4eec\u5bf9\u8f6f\u4ef6\u90e8\u4efd\u7684Excheng\u65b9\u6848\u6ca1\u6709\uff0c\u4e0d\u4e13\u4e1a\uff0c\u5ba2\u6237\u611f\u89c9\u6211\u4eec\u4e0d\u91cd\u89c6\u53ca\u6280\u672f\u80fd\u529b\u4e0d\u884c\u3002\u6240\u4ee5\u6ca1\u9009\u62e9\u6211\u4eec\u3002\r\n","contract_type":1,"progress_updated_at":"2019-05-05 20:26:24.710697+08","forecast_updated_at":"2019-05-05 20:26:24.710697+08","end_at":"2019-05-05 20:26:24","pinyin_shortcut":"ccbfgz","creator":1004,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"160000.0000000000000000","remain":"3222 days 16:25:35.885367","progress_remain":"2586 days 16:14:42.184433","forecast_remain":"2586 days 16:14:42.184433","lost_contact_days":"1744.91054276771","last_contact":"2021-08-24 14:49:56","last_arrive_days":"1744.91054276771","last_arrive":"2021-08-24 14:49:56+08","duration":"815 days 03:10:01.247478","issued_invoices":"","client":{"id":18,"key":18,"name":"\u4e2d\u5fb7\u8bc1\u5238\u6709\u9650\u8d23\u4efb\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":10,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":{},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":12,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"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":69,"product_type_id":69,"key":69,"name":"\u5907\u4efd","budget":"0","pct":"0","profit":"0","project_id":12},{"id":71,"product_type_id":71,"key":71,"name":"\u5176\u4ed6","budget":"0","pct":"0","profit":"0","project_id":12},{"id":83,"product_type_id":83,"key":83,"name":"\u601d\u79d1\u7f51\u7edc","budget":"0","pct":"0","profit":"0","project_id":12},{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"0","pct":"0","profit":"0","project_id":12}],"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":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"casePoints":{"project_id":12,"points":"50"},"workLogCount":{"project_id":12,"count":2},"caseCount":{"project_id":12,"count":1},"salesTimeCount":{"project_id":12,"hours":"0.605833333333333","times":1},"implementTimeCount":{},"presalesTimeCount":{"project_id":12,"sum":"0.216666666666667","times":"1"},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":"","projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":3222,"progress_remain_display":2586,"forecast_remain_display":2586,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":800000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"4\u5e74\u524d","project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_invoice":false,"can_payment":false,"duration_display":815,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"4\u5e74\u524d","can_view_product":true,"budget_display":"80\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":0,"un_invoiced":0,"object_type":1,"can_view_product_cost":true},{"id":13,"client_id":27,"project_status":3,"project_progress":10,"budget":"491000","profit_pct":"25","bargain_date":"2017-03-10","description":"\u6570\u636e\u4e2d\u5fc3\u65b0\u5efa","created_by":1006,"created_at":"2017-02-09 17:16:42","updated_at":"2024-12-25 15:16:43","engineer_id":1017,"project_title":"\u6570\u636e\u4e2d\u5fc3\u65b0\u5efa","collected":"491000","status_updated_at":"2018-05-08 10:27:52.188238+08","success_rate":100,"comment":"\u6570\u636e\u4e2d\u5fc3\u65b0\u5efa\r\n","contract_type":1,"progress_updated_at":"2019-01-21 10:53:42.172906+08","forecast_updated_at":"2019-01-21 10:53:42.172906+08","end_at":"2019-01-21 10:53:42","pinyin_shortcut":"sjzxxj","creator":1006,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"122750.0000000000000000","remain":"2949 days 02:13:14.706892","progress_remain":"2691 days 01:47:24.722224","forecast_remain":"2691 days 01:47:24.722224","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"710 days 17:36:59.909065","issued_invoices":"1473000","client":{"id":27,"key":27,"name":"\u5317\u4eac\u6c7d\u8f66\u6613\u751f\u6d3b\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u4e2d\u6cb9\u623f\u5c71\u71d5\u5bbe\u6cb9\u6599\u9500\u552e\u6709\u9650\u516c\u53f8\uff09","logo":"","client_type":5,"client_class":43,"client_industry":19,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":19,"key":19,"name":"OTT"}},"usedClient":{},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":13,"value":"1","key":1017,"name":"\u8f66\u660e\u98de"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":85,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"30000.00","pct":"25","profit":"7500","project_id":13},{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"153200.00","pct":"25","profit":"38300","project_id":13},{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"17477.00","pct":"25","profit":"4369.25","project_id":13},{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"210523.00","pct":"25","profit":"52630.75","project_id":13},{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"79800.00","pct":"25","profit":"19950","project_id":13}],"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":{},"purchaseType":{},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"}},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"casePoints":"","workLogCount":"","caseCount":"","salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":17,"from_project":13,"payment_collection_remind_ahead":"00:00:00","serial_no":"TSC-Z-2016122901","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"491000","erp_un_settle_amount":"0","including_tax":true,"amount":"491000","contractScans":[{"id":12615,"object_type":105,"object_id":17,"attachment_id":806,"attachment":{"id":806,"key":806,"name":"153e48be-fa5b-3ba0-acff-c360fc3a4642","extension":"pdf","path":"\/vue\/attachment\/preview\/153e48be-fa5b-3ba0-acff-c360fc3a4642\/\u5317\u4eac\u6c7d\u8f66\u6613\u751f\u6d3b\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\u201420170329\u2014491000.pdf","orig_name":"\u5317\u4eac\u6c7d\u8f66\u6613\u751f\u6d3b\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\u201420170329\u2014491000.pdf"}}],"receiptScans":[{"id":13318,"object_type":106,"object_id":17,"attachment_id":247,"attachment":{"id":247,"key":247,"name":"f218be23-4bf7-36c0-8a93-ca95213ba5d7","extension":"pdf","path":"\/vue\/attachment\/preview\/f218be23-4bf7-36c0-8a93-ca95213ba5d7\/\u6c7d\u8f66\u6613\u751f\u6d3b.pdf","orig_name":"\u6c7d\u8f66\u6613\u751f\u6d3b.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":1868,"serial_no":"SKD-20170224-00004","wrote_date":"","from_date":"","handler":5295,"user_id":"","client_id":27,"sales_contract_id":17,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2017-02-24 13:45:33","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"24550.00","settle_amount":"24550.00","created_by":"","stop_description":"","is_settle":true,"is_old":true,"created_at":"2017-02-24 13:45:33","updated_at":"2017-02-24 13:45:33","paid_amount":"","contact_id":"","bank_settle_at":"","print_times":""},{"id":1867,"serial_no":"SKD-20170224-00003","wrote_date":"","from_date":"","handler":5295,"user_id":"","client_id":27,"sales_contract_id":17,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2017-02-24 13:45:33","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"466450.00","settle_amount":"466450.00","created_by":"","stop_description":"","is_settle":true,"is_old":true,"created_at":"2017-02-24 13:45:33","updated_at":"2017-02-24 13:45:33","paid_amount":"","contact_id":"","bank_settle_at":"","print_times":""}],"salesContractPayments":[{"id":"11868","key":"11868","contract_id":17,"value":"24550.00","created_by":"","collected_date":"","createdBy":{},"pct":5},{"id":"11867","key":"11867","contract_id":17,"value":"466450.00","created_by":"","collected_date":"","createdBy":{},"pct":95}],"salesContractInvoices":[{"id":351,"key":351,"contract_id":17,"value":"213431.10","attachment_id":"","from_date":"","attachment":{}},{"id":486,"key":486,"contract_id":17,"value":"24568.90","attachment_id":"","from_date":"","attachment":{}},{"id":612,"key":612,"contract_id":17,"value":"253000.00","attachment_id":"","from_date":"","attachment":{}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[{"id":652,"contract_id":17,"supplier_id":104,"purchase_id":49,"supplier":{"id":104,"key":104,"name":"\u5317\u4eac\u57fa\u4e1a\u50b2\u817e\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":49,"key":49,"serial_no":"-"}},{"id":1143,"contract_id":17,"supplier_id":153,"purchase_id":61,"supplier":{"id":153,"key":153,"name":"\u5317\u4eac\u6052\u4fe1\u81f4\u8fdc\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":61,"key":61,"serial_no":"-"}},{"id":2241,"contract_id":17,"supplier_id":675,"purchase_id":47,"supplier":{"id":675,"key":675,"name":"\u7d2b\u5149\u6570\u7801(\u82cf\u5dde)\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"purchase":{"id":47,"key":47,"serial_no":"20170324"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":491000},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":{"id":7,"serial_no":"XSDD-20170224-00001","from_date":"","wrote_date":"2017-03-10","handler":1010,"client_id":27,"purchase_contract_id":"","project_id":13,"sales_contract_id":17,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u8ba1\u7b97\u3001\u7f51\u7edc","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2019-01-21 10:53:42","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"491000","created_by":1010,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2017-02-24 13:45:33","updated_at":"2019-01-21 10:53:42","print_times":""},"projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":2949,"progress_remain_display":2691,"forecast_remain_display":2691,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":-982000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":710,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"","can_view_product":true,"budget_display":"49.1\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"can_view_product_cost":true},{"id":14,"client_id":28,"project_status":3,"project_progress":10,"budget":"692800","profit_pct":"35","bargain_date":"2017-05-18","description":"\u865a\u62df\u5316\u6574\u5408\r\nFAS2552-R6 \u53cc\u63a7 24x1.2TB\r\nNexus 3524x, 24 10G Ports*2\r\nVeeam Backup*10\r\n\u6269\u5bb9\u914d\u4ef6CPU 2620V4*1 \u786c\u76d82T*3 \u5185\u5b5816G*31\r\n\u5149\u7ea4\u7ebf20\u3001 \u7f51\u7ebf10\r\nVMware*12 \u4e09\u5e74\u670d\u52a1\uff08\u8fdc\u7a0b\u7535\u8bdd\u4eba\u5de5\u4e09\u5e74\uff0c\u6bcf\u5e744\u6b21\u5de1\u68c0\uff09","created_by":1007,"created_at":"2017-02-10 09:59:22","updated_at":"2024-02-19 11:48:07","engineer_id":"","project_title":"\u865a\u62df\u5316\u6574\u5408","collected":"692800","status_updated_at":"2017-11-02 19:34:31.441605+08","success_rate":100,"comment":"\u865a\u62df\u5316\u6574\u5408\r\nFAS2552-R6 \u53cc\u63a7 24x1.2TB\r\nNexus 3524x, 24 10G Ports*2\r\nVeeam Backup*10\r\n\u6269\u5bb9\u914d\u4ef6CPU 2620V4*1 \u786c\u76d82T*3 \u5185\u5b5816G*31\r\n\u5149\u7ea4\u7ebf20\u3001 \u7f51\u7ebf10\r\nVMware*12 \u4e09\u5e74\u670d\u52a1\uff08\u8fdc\u7a0b\u7535\u8bdd\u4eba\u5de5\u4e09\u5e74\uff0c\u6bcf\u5e744\u6b21\u5de1\u68c0\uff09\r\n","contract_type":1,"progress_updated_at":"2019-05-08 15:14:19.744527+08","forecast_updated_at":"2019-05-08 15:14:19.744527+08","end_at":"2019-05-08 15:14:19","pinyin_shortcut":"xnhzh","creator":1007,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"242480.0000000000000000","remain":"3135 days 17:06:35.453525","progress_remain":"2583 days 21:26:47.150603","forecast_remain":"2583 days 21:26:47.150603","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"817 days 05:14:57.049343","issued_invoices":"692800","client":{"id":28,"key":28,"name":"\u5317\u4eac\u6052\u4fe1\u901a\u7535\u4fe1\u670d\u52a1\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":"","client_industry":10,"sales_rep":"","salesRep":"","clientType":{"id":6,"key":6,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09"},"clientClass":"","clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":{},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":14,"value":"0.8","key":1015,"name":"\u5434\u660a"},{"project_id":14,"value":"0.2","key":1017,"name":"\u8f66\u660e\u98de"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":85,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"492800.00","pct":"35","profit":"172480","project_id":14},{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"200000.00","pct":"35","profit":"70000","project_id":14}],"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":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":128,"key":128,"name":"\u516c\u5f00\u62db\u6807"},"createdBy":{"id":1007,"key":1007,"name":"\u5b59\u6167","sex":"F","department_id":9,"avatar":{"id":7,"user_id":1007,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1007.jpg"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"projectCreator":{"id":1007,"key":1007,"name":"\u5b59\u6167","sex":"F","department_id":9,"avatar":{"id":7,"user_id":1007,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1007.jpg"}},"salesRep":"","casePoints":"","workLogCount":"","caseCount":"","salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":108,"from_project":14,"payment_collection_remind_ahead":"00:00:00","serial_no":"TSC-X-2017051708","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"692800","erp_un_settle_amount":"0","including_tax":true,"amount":"692800","contractScans":[{"id":12648,"object_type":105,"object_id":108,"attachment_id":188,"attachment":{"id":188,"key":188,"name":"2e12f290-13b4-3e83-b8ff-f861572cd359","extension":"pdf","path":"\/vue\/attachment\/preview\/2e12f290-13b4-3e83-b8ff-f861572cd359\/\u5317\u4eac\u6052\u4fe1\u901a\u7535\u4fe1\u670d\u52a1\u6709\u9650\u516c\u53f8\u201420170517\u2014692800.pdf","orig_name":"\u5317\u4eac\u6052\u4fe1\u901a\u7535\u4fe1\u670d\u52a1\u6709\u9650\u516c\u53f8\u201420170517\u2014692800.pdf"}}],"receiptScans":[{"id":13346,"object_type":106,"object_id":108,"attachment_id":344,"attachment":{"id":344,"key":344,"name":"ec0335b7-b7de-3064-a38b-376a341865d4","extension":"pdf","path":"\/vue\/attachment\/preview\/ec0335b7-b7de-3064-a38b-376a341865d4\/\u6052\u4fe1\u901a\u201420170719.pdf","orig_name":"\u6052\u4fe1\u901a\u201420170719.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":639,"serial_no":"SKD-20170519-00002","wrote_date":"","from_date":"","handler":"","user_id":"","client_id":28,"sales_contract_id":108,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2017-05-19 09:58:35","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"522800.00","settle_amount":"522800.00","created_by":"","stop_description":"","is_settle":true,"is_old":true,"created_at":"2017-05-19 09:58:35","updated_at":"2017-05-19 09:58:35","paid_amount":"","contact_id":"","bank_settle_at":"","print_times":""},{"id":638,"serial_no":"SKD-20170519-00001","wrote_date":"","from_date":"","handler":"","user_id":"","client_id":28,"sales_contract_id":108,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2017-05-19 09:58:35","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"170000.00","settle_amount":"170000.00","created_by":"","stop_description":"","is_settle":true,"is_old":true,"created_at":"2017-05-19 09:58:35","updated_at":"2017-05-19 09:58:35","paid_amount":"","contact_id":"","bank_settle_at":"","print_times":""}],"salesContractPayments":[{"id":"1639","key":"1639","contract_id":108,"value":"522800.00","created_by":"","collected_date":"","createdBy":{},"pct":75.46},{"id":"1638","key":"1638","contract_id":108,"value":"170000.00","created_by":"","collected_date":"","createdBy":{},"pct":24.54}],"salesContractInvoices":[{"id":362,"key":362,"contract_id":108,"value":"692800.00","attachment_id":"","from_date":"","attachment":{}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[{"id":634,"contract_id":108,"supplier_id":46,"purchase_id":157,"supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"purchase":{"id":157,"key":157,"serial_no":"-"}},{"id":1085,"contract_id":108,"supplier_id":46,"purchase_id":169,"supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"purchase":{"id":169,"key":169,"serial_no":"TS-HYF20170531"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":692800},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":{"id":48,"serial_no":"XSDD-20170519-00001","from_date":"","wrote_date":"2017-05-18","handler":1028,"client_id":28,"purchase_contract_id":"","project_id":14,"sales_contract_id":108,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u5b58\u50a8\u3001\u7f51\u7edc\u3001\u5907\u4efd","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2019-05-08 15:14:19","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"692800","created_by":1028,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2017-05-19 09:58:35","updated_at":"2019-05-08 15:14:19","print_times":""},"projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":3135,"progress_remain_display":2583,"forecast_remain_display":2583,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":817,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"","can_view_product":true,"budget_display":"69.28\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"can_view_product_cost":true},{"id":15,"client_id":31,"project_status":3,"project_progress":10,"budget":"31000","profit_pct":"80","bargain_date":"2017-06-15","description":"VMWARE\u670d\u52a1\u8d39","created_by":1006,"created_at":"2017-02-10 10:47:02","updated_at":"2021-06-29 16:12:28","engineer_id":1015,"project_title":"\u865a\u62df\u5316\u7ef4\u4fdd","collected":"31000","status_updated_at":"2017-07-07 12:06:15.964234+08","success_rate":100,"comment":"VMWARE\u670d\u52a1\u8d39\r\n","contract_type":2,"progress_updated_at":"2019-05-08 14:49:32.0758+08","forecast_updated_at":"2019-05-08 14:49:32.0758+08","end_at":"2019-05-08 14:49:32","pinyin_shortcut":"xnhwb","creator":1006,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"24800.0000000000000000","remain":"3254 days 00:34:50.930896","progress_remain":"2583 days 21:51:34.81933","forecast_remain":"2583 days 21:51:34.81933","lost_contact_days":"2529.00771869363","last_contact":"2019-07-02 12:30:00","last_arrive_days":"","last_arrive":"","duration":"817 days 04:02:29.871141","issued_invoices":"31000","client":{"id":31,"key":31,"name":"\u4e1c\u65b9\u7f51\u529b\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":1,"client_class":43,"client_industry":19,"sales_rep":"","salesRep":"","clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":19,"key":19,"name":"OTT"}},"usedClient":{},"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[{"project_id":15,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":65,"product_type_id":65,"key":65,"name":"\u5546\u4e1a\u8f6f\u4ef6","budget":"10000.00","pct":"80","profit":"8000","project_id":15},{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"21000.00","pct":"80","profit":"16800","project_id":15}],"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":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":182,"key":182,"name":"\u56f4\u6807"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"}},"salesRep":"","casePoints":"","workLogCount":{"project_id":15,"count":1},"caseCount":"","salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":15,"sum":"84"},"buildContract":{"id":132,"from_project":15,"payment_collection_remind_ahead":"00:00:00","serial_no":"-","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"31000","erp_un_settle_amount":"0","including_tax":true,"amount":"31000","contractScans":[{"id":12628,"object_type":105,"object_id":132,"attachment_id":262,"attachment":{"id":262,"key":262,"name":"799e73d2-6463-3215-91ba-348c210bf84c","extension":"pdf","path":"\/vue\/attachment\/preview\/799e73d2-6463-3215-91ba-348c210bf84c\/\u4e1c\u65b9\u7f51\u529b\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u201420170615\u201431000.pdf","orig_name":"\u4e1c\u65b9\u7f51\u529b\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u201420170615\u201431000.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[{"id":1011,"serial_no":"SKD-20170615-00001","wrote_date":"","from_date":"","handler":5295,"user_id":"","client_id":31,"sales_contract_id":132,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2017-06-15 14:14:45","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"31000.00","settle_amount":"31000.00","created_by":"","stop_description":"","is_settle":true,"is_old":true,"created_at":"2017-06-15 14:14:45","updated_at":"2017-06-15 14:14:45","paid_amount":"","contact_id":"","bank_settle_at":"","print_times":""}],"salesContractPayments":[{"id":"11011","key":"11011","contract_id":132,"value":"31000.00","created_by":"","collected_date":"","createdBy":{},"pct":100}],"salesContractInvoices":[{"id":230,"key":230,"contract_id":132,"value":"31000.00","attachment_id":"","from_date":"","attachment":{}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"\u65e0","invoiced":31000},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":{"id":57,"serial_no":"XSDD-20170615-00001","from_date":"","wrote_date":"2017-06-15","handler":1028,"client_id":31,"purchase_contract_id":"","project_id":15,"sales_contract_id":132,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u865a\u62df\u5316\u7ef4\u4fdd","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2019-05-08 14:49:32","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"31000","created_by":1028,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2017-06-15 14:14:45","updated_at":"2019-05-08 14:49:32","print_times":""},"projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":3254,"progress_remain_display":2583,"forecast_remain_display":2583,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":817,"contract_type_display":"\u8fd0\u7ef4\u670d\u52a1","can_change_status":false,"is_admin":true,"lost_contact_days_display":"6\u5e74\u524d","can_view_product":true,"budget_display":"3.1\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"can_view_product_cost":true},{"id":16,"client_id":9,"project_status":5,"project_progress":3,"budget":"420000","profit_pct":"30","bargain_date":"2017-08-31","description":"3\u53f0\u670d\u52a1\u5668 netapp FAS2540*1+vpn-2050-Y+50\u4e2a\u5e76\u53d1+VMware*6C+VEEAM+6C+\u670d\u52a1\u5668*1+\u4ea4\u6362\u673a2960*2 50%","created_by":1008,"created_at":"2017-02-10 11:11:41","updated_at":"2019-05-05 19:57:25","engineer_id":1020,"project_title":"\u865a\u62df\u5316\u6574\u5408","collected":"0","status_updated_at":"2017-08-04 17:43:51.97038+08","success_rate":10,"comment":"3\u53f0\u670d\u52a1\u5668 netapp FAS2540*1+vpn-2050-Y+50\u4e2a\u5e76\u53d1+VMware*6C+VEEAM+6C+\u670d\u52a1\u5668*1+\u4ea4\u6362\u673a2960*2 50%\r\n","contract_type":1,"progress_updated_at":"2019-05-05 19:57:25.343911+08","forecast_updated_at":"2019-05-05 19:57:25.343911+08","end_at":"2019-05-05 19:57:25","pinyin_shortcut":"xnhzh","creator":1008,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"126000.0000000000000000","remain":"3225 days 18:57:14.92475","progress_remain":"2586 days 16:43:41.551219","forecast_remain":"2586 days 16:43:41.551219","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"814 days 08:45:43.443546","issued_invoices":"","client":{"id":9,"key":9,"name":"\u5317\u4eac\u4eac\u4e1c\u65b9\u7f6e\u4e1a\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":"","client_industry":9,"sales_rep":"","salesRep":"","clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":"","clientIndustry":{"id":9,"key":9,"name":"\u5730\u4ea7"}},"usedClient":{},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":16,"value":"1","key":1020,"name":"\u738b\u6069\u56fd"}],"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{"id":3,"key":3,"name":"\u65b9\u6848\u8bbe\u8ba1","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u9762\u4e34\u7684\u95ee\u9898\u53ca\u6311\u6218\uff0c \u63d0\u51fa\u6211\u65b9\u7684\u4ea7\u54c1\u65b9\u6848\u3002\u5177\u4f53\u7684\u54c1\u724c\uff0c \u578b\u53f7\uff0c\u914d\u7f6e\uff0c\u4fdd\u4fee\u3002 \n\u65b9\u6cd5\uff1a\u5c06\u5ba2\u6237\u7684\u95ee\u9898\u53ca\u9700\u6c42\u7528\u6587\u5b57\u63cf\u8ff0\u51fa\u6765\uff0c\u4ea4\u7ed9\u552e\u524d\u6216\u5382\u5546\u3002"},"projectProductTypes":[{"id":78,"product_type_id":78,"key":78,"name":"VMware\u79c1\u6709\u4e91","budget":"0","pct":"0","profit":"0","project_id":16},{"id":83,"product_type_id":83,"key":83,"name":"\u601d\u79d1\u7f51\u7edc","budget":"0","pct":"0","profit":"0","project_id":16},{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"0","pct":"0","profit":"0","project_id":16},{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"0","pct":"0","profit":"0","project_id":16},{"id":69,"product_type_id":69,"key":69,"name":"\u5907\u4efd","budget":"0","pct":"0","profit":"0","project_id":16}],"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":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"}},"salesRep":"","casePoints":"","workLogCount":"","caseCount":"","salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":"","projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":3225,"progress_remain_display":2586,"forecast_remain_display":2586,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":420000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"","project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_invoice":false,"can_payment":false,"duration_display":814,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"","can_view_product":true,"budget_display":"42\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":0,"un_invoiced":0,"object_type":1,"can_view_product_cost":true},{"id":18,"client_id":6,"project_status":5,"project_progress":1,"budget":"340000","profit_pct":"30","bargain_date":"2018-04-06","description":" 100\u4e2a\u865a\u62df\u684c\u9762\u7684\u70b9\uff08\u6df1\u4fe1\u670d \uff0950%","created_by":1008,"created_at":"2017-02-10 11:25:34","updated_at":"2019-05-05 19:44:48","engineer_id":1020,"project_title":"\u865a\u62df\u684c\u9762","collected":"0","status_updated_at":"2019-05-05 19:44:48.113849+08","success_rate":10,"comment":" 100\u4e2a\u865a\u62df\u684c\u9762\u7684\u70b9\uff08\u6df1\u4fe1\u670d \uff0950%\r\n","contract_type":1,"progress_updated_at":"2019-05-05 19:44:48.113849+08","forecast_updated_at":"2019-05-05 19:44:48.113849+08","end_at":"2019-05-05 19:44:48","pinyin_shortcut":"xnzm","creator":1008,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"102000.0000000000000000","remain":"2586 days 16:56:18.781281","progress_remain":"2586 days 16:56:18.781281","forecast_remain":"2586 days 16:56:18.781281","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"814 days 08:19:13.640433","issued_invoices":"","client":{"id":6,"key":6,"name":"\u5317\u4eac\u8054\u5fb7\u77e5\u8bc6\u4ea7\u6743\u4ee3\u7406\u6709\u9650\u516c\u53f8(\u5317\u4eac\u5e02\u8054\u5fb7\u5f8b\u5e08\u4e8b\u52a1\u6240)","logo":"","client_type":5,"client_class":"","client_industry":18,"sales_rep":"","salesRep":"","clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":"","clientIndustry":{"id":18,"key":18,"name":"\u5a92\u4f53"}},"usedClient":{},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":18,"value":"1","key":1020,"name":"\u738b\u6069\u56fd"}],"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{"id":1,"key":1,"name":"\u521d\u76f8\u8bc6","description":"\u5411\u5ba2\u6237\u4ecb\u7ecd\u81ea\u8eab\u4ef7\u503c\uff1a\n1.\u4ea7\u54c1\u9009\u578b\n2.\u6210\u672c\u4f18\u5316\n3.\u4ea7\u54c1\u4ea4\u4ed8\n4.\u540e\u671f\u8fd0\u7ef4"},"projectProductTypes":[{"id":94,"product_type_id":94,"key":94,"name":"\u6df1\u4fe1\u670dAdesk","budget":"340000","pct":"30","profit":"102000","project_id":18}],"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":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":182,"key":182,"name":"\u56f4\u6807"},"createdBy":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"}},"salesRep":"","casePoints":"","workLogCount":"","caseCount":"","salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":"","projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":2586,"progress_remain_display":2586,"forecast_remain_display":2586,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":340000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"","project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_invoice":false,"can_payment":false,"duration_display":814,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"","can_view_product":true,"budget_display":"34\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":0,"un_invoiced":0,"object_type":1,"can_view_product_cost":true},{"id":19,"client_id":17,"project_status":3,"project_progress":10,"budget":"56320","profit_pct":"15","bargain_date":"2017-02-15","description":" veeam strandard *8c ","created_by":1008,"created_at":"2017-02-10 11:28:21","updated_at":"2024-11-08 15:47:26","engineer_id":"","project_title":"veeam strandard","collected":"56320","status_updated_at":"2017-06-15 18:20:03.662142+08","success_rate":100,"comment":" veeam strandard *8c \r\n","contract_type":1,"progress_updated_at":"2019-01-21 11:27:31.518667+08","forecast_updated_at":"2019-01-21 11:27:31.518667+08","end_at":"2019-01-21 11:27:31","pinyin_shortcut":"veeamstrandard","creator":1008,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"8448.0000000000000000","remain":"3275 days 18:21:03.232988","progress_remain":"2691 days 01:13:35.376463","forecast_remain":"2691 days 01:13:35.376463","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"709 days 23:59:10.410409","issued_invoices":"56320","client":{"id":17,"key":17,"name":"\u5317\u4eac\u62d3\u84dd\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":5,"sales_rep":"","salesRep":"","clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"usedClient":{},"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":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":65,"product_type_id":65,"key":65,"name":"\u5546\u4e1a\u8f6f\u4ef6","budget":"56320","pct":"15","profit":"8448","project_id":19}],"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":{},"purchaseType":{},"createdBy":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"}},"salesRep":"","casePoints":"","workLogCount":"","caseCount":"","salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":6,"from_project":19,"payment_collection_remind_ahead":"00:00:00","serial_no":"\u65e0","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"56320","erp_un_settle_amount":"0","including_tax":true,"amount":"56320","contractScans":[{"id":12640,"object_type":105,"object_id":6,"attachment_id":148,"attachment":{"id":148,"key":148,"name":"f70de6b1-bfb8-3916-9a9a-331a7aa87e87","extension":"pdf","path":"\/vue\/attachment\/preview\/f70de6b1-bfb8-3916-9a9a-331a7aa87e87\/\u5317\u4eac\u62d3\u84dd\u79d1\u6280\u6709\u9650\u516c\u53f8\u201420170111\u201456320.pdf","orig_name":"\u5317\u4eac\u62d3\u84dd\u79d1\u6280\u6709\u9650\u516c\u53f8\u201420170111\u201456320.pdf"}}],"receiptScans":[{"id":13340,"object_type":106,"object_id":6,"attachment_id":259,"attachment":{"id":259,"key":259,"name":"95a11861-866b-31b7-b569-17d74bd22e16","extension":"pdf","path":"\/vue\/attachment\/preview\/95a11861-866b-31b7-b569-17d74bd22e16\/\u62d3\u84dd\u79d1\u6280.pdf","orig_name":"\u62d3\u84dd\u79d1\u6280.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":1281,"serial_no":"SKD-20170213-00001","wrote_date":"","from_date":"","handler":"","user_id":"","client_id":17,"sales_contract_id":6,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2017-02-13 09:04:47","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"56320.00","settle_amount":"56320.00","created_by":"","stop_description":"","is_settle":true,"is_old":true,"created_at":"2017-02-13 09:04:47","updated_at":"2017-02-13 09:04:47","paid_amount":"","contact_id":"","bank_settle_at":"","print_times":""}],"salesContractPayments":[{"id":"11281","key":"11281","contract_id":6,"value":"56320.00","created_by":"","collected_date":"","createdBy":{},"pct":100}],"salesContractInvoices":[{"id":179,"key":179,"contract_id":6,"value":"56320.00","attachment_id":"","from_date":"","attachment":{}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[{"id":1990,"contract_id":6,"supplier_id":659,"purchase_id":71,"supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"purchase":{"id":71,"key":71,"serial_no":"BJCCS1702002X"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":56320},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":{"id":2,"serial_no":"XSDD-20170213-00001","from_date":"","wrote_date":"2017-02-15","handler":1028,"client_id":17,"purchase_contract_id":"","project_id":19,"sales_contract_id":6,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u5907\u4efd","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2019-01-21 11:27:31","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"56320","created_by":1028,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2017-02-13 09:04:47","updated_at":"2019-01-21 11:27:31","print_times":""},"projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":3275,"progress_remain_display":2691,"forecast_remain_display":2691,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":709,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"","can_view_product":true,"budget_display":"5.63\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"can_view_product_cost":true},{"id":20,"client_id":6,"project_status":3,"project_progress":10,"budget":"13200","profit_pct":"19","bargain_date":"2017-04-18","description":"8G\u5185\u5b58\u6761*24 90%+usb server *1","created_by":1009,"created_at":"2017-02-10 11:30:20","updated_at":"2019-01-21 10:44:23","engineer_id":1015,"project_title":"\u5185\u5b58\u6761","collected":"13200","status_updated_at":"2017-06-05 13:13:03.377722+08","success_rate":100,"comment":"8G\u5185\u5b58\u6761*24 90%+usb server *1\r\n","contract_type":1,"progress_updated_at":"2019-01-21 10:44:23.852904+08","forecast_updated_at":"2019-01-21 10:44:23.852904+08","end_at":"2019-01-21 10:44:23","pinyin_shortcut":"nct","creator":1009,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"2508.0000000000000000","remain":"3285 days 23:28:03.517408","progress_remain":"2691 days 01:56:43.042226","forecast_remain":"2691 days 01:56:43.042226","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"709 days 23:14:03.654426","issued_invoices":"13200","client":{"id":6,"key":6,"name":"\u5317\u4eac\u8054\u5fb7\u77e5\u8bc6\u4ea7\u6743\u4ee3\u7406\u6709\u9650\u516c\u53f8(\u5317\u4eac\u5e02\u8054\u5fb7\u5f8b\u5e08\u4e8b\u52a1\u6240)","logo":"","client_type":5,"client_class":"","client_industry":18,"sales_rep":"","salesRep":"","clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":"","clientIndustry":{"id":18,"key":18,"name":"\u5a92\u4f53"}},"usedClient":{},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":20,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"13200","pct":"19","profit":"2508","project_id":20}],"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":{},"purchaseType":{},"createdBy":{"id":1009,"key":1009,"name":"\u9b4f\u78ca","sex":"M","department_id":1,"avatar":{},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1009,"key":1009,"name":"\u9b4f\u78ca","sex":"M","department_id":1,"avatar":{}},"salesRep":"","casePoints":"","workLogCount":"","caseCount":"","salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":84,"from_project":20,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-LD-20170413","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"13200","erp_un_settle_amount":"0","including_tax":true,"amount":"13200","contractScans":[{"id":12670,"object_type":105,"object_id":84,"attachment_id":128,"attachment":{"id":128,"key":128,"name":"2ffa9618-5436-3a91-8045-ff9f4b2e50f8","extension":"pdf","path":"\/vue\/attachment\/preview\/2ffa9618-5436-3a91-8045-ff9f4b2e50f8\/\u5317\u4eac\u5e02\u8054\u5fb7\u5f8b\u5e08\u4e8b\u52a1\u6240\u201420170413\u201413200.pdf","orig_name":"\u5317\u4eac\u5e02\u8054\u5fb7\u5f8b\u5e08\u4e8b\u52a1\u6240\u201420170413\u201413200.pdf"}}],"receiptScans":[{"id":13367,"object_type":106,"object_id":84,"attachment_id":147,"attachment":{"id":147,"key":147,"name":"9bd8b5fa-e511-3af0-a244-99c228d919fc","extension":"pdf","path":"\/vue\/attachment\/preview\/9bd8b5fa-e511-3af0-a244-99c228d919fc\/\u8054\u5fb7\u7b7e\u6536\u5355.pdf","orig_name":"\u8054\u5fb7\u7b7e\u6536\u5355.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":630,"serial_no":"SKD-20170420-00001","wrote_date":"","from_date":"","handler":"","user_id":"","client_id":6,"sales_contract_id":84,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2017-04-20 20:06:39","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"13200.00","settle_amount":"13200.00","created_by":"","stop_description":"","is_settle":true,"is_old":true,"created_at":"2017-04-20 20:06:39","updated_at":"2017-04-20 20:06:39","paid_amount":"","contact_id":"","bank_settle_at":"","print_times":""}],"salesContractPayments":[{"id":"1630","key":"1630","contract_id":84,"value":"13200.00","created_by":"","collected_date":"","createdBy":{},"pct":100}],"salesContractInvoices":[{"id":831,"key":831,"contract_id":84,"value":"13200.00","attachment_id":"","from_date":"","attachment":{}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"\u65e0","invoiced":13200},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":{"id":39,"serial_no":"XSDD-20170420-00002","from_date":"","wrote_date":"2017-04-18","handler":1028,"client_id":6,"purchase_contract_id":"","project_id":20,"sales_contract_id":84,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u914d\u4ef6","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2019-01-21 10:44:23","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"13200","created_by":1028,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2017-04-20 20:06:39","updated_at":"2019-01-21 10:44:23","print_times":""},"projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":3285,"progress_remain_display":2691,"forecast_remain_display":2691,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":709,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"","can_view_product":true,"budget_display":"1.32\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"can_view_product_cost":true},{"id":21,"client_id":42,"project_status":3,"project_progress":10,"budget":"48400","profit_pct":"20","bargain_date":"2017-03-24","description":"\u865a\u62df\u5316\u5e73\u53f0\u7ef4\u4fdd\uff083\u53f0\u670d\u52a1\u5668\u786c\u4ef6+3CPU\u5e74\u5ea6\u7ef4\u62a4\uff09\r\n6\u5757300GB\u786c\u76d8\r\n1\u53f0LS-3100-52TP-SI-H3(\u542b\u7ea7\u8054\u8fde\u63a5\u6a21\u5757)","created_by":1007,"created_at":"2017-02-10 14:48:42","updated_at":"2024-02-19 14:23:10","engineer_id":"","project_title":"\u865a\u62df\u5316\u5e73\u53f0\u7ef4\u4fdd","collected":"48400","status_updated_at":"2017-06-30 11:18:50.218174+08","success_rate":100,"comment":"\u865a\u62df\u5316\u5e73\u53f0\u7ef4\u4fdd\uff083\u53f0\u670d\u52a1\u5668\u786c\u4ef6+3CPU\u5e74\u5ea6\u7ef4\u62a4\uff09\r\n6\u5757300GB\u786c\u76d8\r\n1\u53f0LS-3100-52TP-SI-H3(\u542b\u7ea7\u8054\u8fde\u63a5\u6a21\u5757)\r\n","contract_type":2,"progress_updated_at":"2019-05-08 15:20:03.645801+08","forecast_updated_at":"2019-05-08 15:20:03.645801+08","end_at":"2019-05-08 15:20:03","pinyin_shortcut":"xnhptwb","creator":1007,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"9680.0000000000000000","remain":"3261 days 01:22:16.676956","progress_remain":"2583 days 21:21:03.249329","forecast_remain":"2583 days 21:21:03.249329","lost_contact_days":"1805.89829739734","last_contact":"2021-06-24 15:07:34","last_arrive_days":"1805.89829739734","last_arrive":"2021-06-24 15:07:34+08","duration":"817 days 00:31:21.387068","issued_invoices":"48400","client":{"id":42,"key":42,"name":"\u5317\u4eac\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8\u6709\u9650\u516c\u53f8","logo":"","client_type":1,"client_class":43,"client_industry":3,"sales_rep":"","salesRep":"","clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":3,"key":3,"name":"\u533b\u7597"}},"usedClient":{},"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[{"project_id":21,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":85,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"5500.00","pct":"20","profit":"1100","project_id":21},{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"5400.00","pct":"20","profit":"1080","project_id":21},{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"37500.00","pct":"20","profit":"7500","project_id":21}],"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":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1007,"key":1007,"name":"\u5b59\u6167","sex":"F","department_id":9,"avatar":{"id":7,"user_id":1007,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1007.jpg"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"projectCreator":{"id":1007,"key":1007,"name":"\u5b59\u6167","sex":"F","department_id":9,"avatar":{"id":7,"user_id":1007,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1007.jpg"}},"salesRep":"","casePoints":{"project_id":21,"points":"100"},"workLogCount":{"project_id":21,"count":1},"caseCount":{"project_id":21,"count":2},"salesTimeCount":{"project_id":21,"hours":"0.776388888888889","times":1},"implementTimeCount":{"project_id":21,"sum":"0.483333333333333","times":"2"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":21,"sum":"121.72"},"buildContract":{"id":18,"from_project":21,"payment_collection_remind_ahead":"00:00:00","serial_no":"-","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"48400","erp_un_settle_amount":"0","including_tax":true,"amount":"48400","contractScans":[{"id":12682,"object_type":105,"object_id":18,"attachment_id":27,"attachment":{"id":27,"key":27,"name":"74b6589a-6ff5-3f63-bb59-ed2a72e6058f","extension":"pdf","path":"\/vue\/attachment\/preview\/74b6589a-6ff5-3f63-bb59-ed2a72e6058f\/\u5317\u4eac\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8\u6709\u9650\u516c\u53f8_20170220__\u5408\u540c.pdf","orig_name":"\u5317\u4eac\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8\u6709\u9650\u516c\u53f8_20170220__\u5408\u540c.pdf"}}],"receiptScans":[{"id":13377,"object_type":106,"object_id":18,"attachment_id":252,"attachment":{"id":252,"key":252,"name":"75f1ad7c-012d-3ef0-97d4-9c6d71e2c901","extension":"pdf","path":"\/vue\/attachment\/preview\/75f1ad7c-012d-3ef0-97d4-9c6d71e2c901\/\u4e50\u5065\u533b\u7597.pdf","orig_name":"\u4e50\u5065\u533b\u7597.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":574,"serial_no":"SKD-20170224-00002","wrote_date":"","from_date":"","handler":5311,"user_id":"","client_id":42,"sales_contract_id":18,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2017-02-24 23:30:32","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"48400.00","settle_amount":"48400.00","created_by":"","stop_description":"","is_settle":true,"is_old":true,"created_at":"2017-02-24 23:30:32","updated_at":"2017-02-24 23:30:32","paid_amount":"","contact_id":"","bank_settle_at":"","print_times":""}],"salesContractPayments":[{"id":"1574","key":"1574","contract_id":18,"value":"48400.00","created_by":"","collected_date":"","createdBy":{},"pct":100}],"salesContractInvoices":[{"id":62,"key":62,"contract_id":18,"value":"48400.00","attachment_id":"","from_date":"","attachment":{}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"\u65e0","invoiced":48400},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":{"id":8,"serial_no":"XSDD-20170224-00002","from_date":"","wrote_date":"2017-03-24","handler":1010,"client_id":42,"purchase_contract_id":"","project_id":21,"sales_contract_id":18,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u7f51\u7edc\uff0c\uff08\u81f32018\u5e742\u670826\u65e5\uff09","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2019-05-08 15:20:03","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"48400","created_by":1010,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2017-02-24 23:30:32","updated_at":"2019-05-08 15:20:03","print_times":""},"projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":3261,"progress_remain_display":2583,"forecast_remain_display":2583,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"4\u5e74\u524d","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":817,"contract_type_display":"\u8fd0\u7ef4\u670d\u52a1","can_change_status":false,"is_admin":true,"lost_contact_days_display":"4\u5e74\u524d","can_view_product":true,"budget_display":"4.84\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"can_view_product_cost":true},{"id":22,"client_id":4,"project_status":3,"project_progress":10,"budget":"138000","profit_pct":"20","bargain_date":"2017-04-18","description":"\u601d\u79d1UCS\u670d\u52a1\u5668FI\u7ef4\u4fdd \uff0c3048\u6838\u5fc3\u4ea4\u6362\u673a1\u53f0\uff0c\u5b58\u50a8\u6269\u5bb96\u5feb1.2T\u786c\u76d8 100%","created_by":1008,"created_at":"2017-02-10 15:03:08","updated_at":"2024-12-26 14:06:32","engineer_id":1020,"project_title":"\u601d\u79d1UCS\u670d\u52a1\u5668FI\u7ef4\u4fdd","collected":"138000","status_updated_at":"2018-09-19 11:43:01.285144+08","success_rate":100,"comment":"\u601d\u79d1UCS\u670d\u52a1\u5668FI\u7ef4\u4fdd \uff0c3048\u6838\u5fc3\u4ea4\u6362\u673a1\u53f0\uff0c\u5b58\u50a8\u6269\u5bb96\u5feb1.2T\u786c\u76d8 100%\r\n","contract_type":1,"progress_updated_at":"2019-05-05 20:03:31.580341+08","forecast_updated_at":"2019-05-05 20:03:31.580341+08","end_at":"2019-05-05 20:03:31","pinyin_shortcut":"skUCSfwqFIwb","creator":1008,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"27600.0000000000000000","remain":"2815 days 00:58:05.609986","progress_remain":"2586 days 16:37:35.314789","forecast_remain":"2586 days 16:37:35.314789","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"814 days 05:00:22.704256","issued_invoices":"138000","client":{"id":4,"key":4,"name":"\u9ad8\u7891\u5e97\u5e02\u76db\u4e49\u8c6a\u5546\u8d38\u6709\u9650\u516c\u53f8\/\u6cb3\u5317\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8\/\u6cb3\u5317\u5c1a\u548c\u5546\u8d38\u6709\u9650\u516c\u53f8","logo":"","client_type":1,"client_class":43,"client_industry":17,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":17,"key":17,"name":"\u96f6\u552e"}},"usedClient":{},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":22,"value":"1","key":1020,"name":"\u738b\u6069\u56fd"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":85,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"52200.00","pct":"20","profit":"10440","project_id":22},{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"85800.00","pct":"20","profit":"17160","project_id":22}],"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":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"}},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"casePoints":"","workLogCount":"","caseCount":"","salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":85,"from_project":22,"payment_collection_remind_ahead":"00:00:00","serial_no":"YJW-TS-20170531","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"138000","erp_un_settle_amount":"0","including_tax":true,"amount":"138000","contractScans":[{"id":12571,"object_type":105,"object_id":85,"attachment_id":2022,"attachment":{"id":2022,"key":2022,"name":"c4c4a347-884f-3b5d-a8fd-475f40194bf0","extension":"pdf","path":"\/vue\/attachment\/preview\/c4c4a347-884f-3b5d-a8fd-475f40194bf0\/\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8\u201420170531\u2014138000.pdf","orig_name":"\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8\u201420170531\u2014138000.pdf"}}],"receiptScans":[{"id":13280,"object_type":106,"object_id":85,"attachment_id":424,"attachment":{"id":424,"key":424,"name":"d007b0d7-5053-3d0a-8f04-b09d49aee82c","extension":"pdf","path":"\/vue\/attachment\/preview\/d007b0d7-5053-3d0a-8f04-b09d49aee82c\/\u5b9c\u4f73\u65fa\u201420170816.pdf","orig_name":"\u5b9c\u4f73\u65fa\u201420170816.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":1450,"serial_no":"SKD-20170420-00005","wrote_date":"","from_date":"","handler":5300,"user_id":"","client_id":4,"sales_contract_id":85,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2017-04-20 20:07:55","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"131100.00","settle_amount":"131100.00","created_by":"","stop_description":"","is_settle":true,"is_old":true,"created_at":"2017-04-20 20:07:55","updated_at":"2017-04-20 20:07:55","paid_amount":"","contact_id":"","bank_settle_at":"","print_times":""},{"id":1449,"serial_no":"SKD-20170420-00004","wrote_date":"","from_date":"","handler":5300,"user_id":"","client_id":4,"sales_contract_id":85,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2017-04-20 20:07:55","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"6900.00","settle_amount":"6900.00","created_by":"","stop_description":"","is_settle":true,"is_old":true,"created_at":"2017-04-20 20:07:55","updated_at":"2017-04-20 20:07:55","paid_amount":"","contact_id":"","bank_settle_at":"","print_times":""}],"salesContractPayments":[{"id":"11450","key":"11450","contract_id":85,"value":"131100.00","created_by":"","collected_date":"","createdBy":{},"pct":95},{"id":"11449","key":"11449","contract_id":85,"value":"6900.00","created_by":"","collected_date":"","createdBy":{},"pct":5}],"salesContractInvoices":[{"id":798,"key":798,"contract_id":85,"value":"138000.00","attachment_id":"","from_date":"","attachment":{}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[{"id":457,"contract_id":85,"supplier_id":183,"purchase_id":199,"supplier":{"id":183,"key":183,"name":"\u4ebf\u6e90\u6570\u901a\u7f51\u7edc\u5de5\u7a0b\uff08\u5317\u4eac\uff09\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"purchase":{"id":199,"key":199,"serial_no":"-"}},{"id":1355,"contract_id":85,"supplier_id":46,"purchase_id":221,"supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"purchase":{"id":221,"key":221,"serial_no":"-"}},{"id":2256,"contract_id":85,"supplier_id":676,"purchase_id":260,"supplier":{"id":676,"key":676,"name":"\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":260,"key":260,"serial_no":"20170816"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":138000},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":{"id":40,"serial_no":"XSDD-20170420-00003","from_date":"","wrote_date":"2017-04-18","handler":1028,"client_id":4,"purchase_contract_id":"","project_id":22,"sales_contract_id":85,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u7f51\u7edc\u3001\u5b58\u50a8\r\n","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2019-05-05 20:03:31","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"138000","created_by":1028,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2017-04-20 20:07:55","updated_at":"2019-05-05 20:03:31","print_times":""},"projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":2815,"progress_remain_display":2586,"forecast_remain_display":2586,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":814,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"","can_view_product":true,"budget_display":"13.8\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"can_view_product_cost":true},{"id":23,"client_id":4,"project_status":4,"project_progress":2,"budget":"385000","profit_pct":"24","bargain_date":"2017-04-30","description":"\u5c71\u7279UPS C10KS\uff0cASE\u7535\u6c6012V100AH 80\u5757\uff0c\u7535\u6c60\u67dcA32 2\u4e2a\uff0cA16 1\u4e2a\uff0c\u7535\u6c60\u8fde\u63a5\u7ebf\uff0c\u5f00\u5173\u7bb1\u7b49\u3002PA\u9632\u706b\u58993020\u4e00\u53f0\uff0cTP\uff0cURL\u6a21\u5757 \uff0c\u5b89\u654fWAF1000 80%","created_by":1008,"created_at":"2017-02-10 15:04:29","updated_at":"2019-05-05 20:02:34","engineer_id":1020,"project_title":"\u5c71\u7279UPS C10KS","collected":"0","status_updated_at":"2017-06-12 12:03:35.732154+08","success_rate":0,"comment":"\u5c71\u7279UPS C10KS\uff0cASE\u7535\u6c6012V100AH 80\u5757\uff0c\u7535\u6c60\u67dcA32 2\u4e2a\uff0cA16 1\u4e2a\uff0c\u7535\u6c60\u8fde\u63a5\u7ebf\uff0c\u5f00\u5173\u7bb1\u7b49\u3002PA\u9632\u706b\u58993020\u4e00\u53f0\uff0cTP\uff0cURL\u6a21\u5757 \uff0c\u5b89\u654fWAF1000 80%\r\n","contract_type":1,"progress_updated_at":"2019-05-05 20:02:34.961152+08","forecast_updated_at":"2019-05-05 20:02:34.961152+08","end_at":"2019-05-05 20:02:34","pinyin_shortcut":"stUPSC10KS","creator":1008,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":false,"collected_plan":0,"change_status_to":"","is_verify":false,"profits":"92400.0000000000000000","remain":"3279 days 00:37:31.162976","progress_remain":"2586 days 16:38:31.933978","forecast_remain":"2586 days 16:38:31.933978","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"814 days 04:58:05.549436","issued_invoices":"","client":{"id":4,"key":4,"name":"\u9ad8\u7891\u5e97\u5e02\u76db\u4e49\u8c6a\u5546\u8d38\u6709\u9650\u516c\u53f8\/\u6cb3\u5317\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8\/\u6cb3\u5317\u5c1a\u548c\u5546\u8d38\u6709\u9650\u516c\u53f8","logo":"","client_type":1,"client_class":43,"client_industry":17,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":17,"key":17,"name":"\u96f6\u552e"}},"usedClient":{},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":23,"value":"1","key":1020,"name":"\u738b\u6069\u56fd"}],"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectProductTypes":[{"id":71,"product_type_id":71,"key":71,"name":"\u5176\u4ed6","budget":"0","pct":"0","profit":"0","project_id":23},{"id":101,"product_type_id":101,"key":101,"name":"Palo Alto\u9632\u706b\u5899","budget":"0","pct":"0","profit":"0","project_id":23}],"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":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"}},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"casePoints":"","workLogCount":"","caseCount":"","salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":"","projectUsedClient":{},"erpSalesOrderVerify":{},"schedules":[],"is_only_cp":false,"remain_display":3279,"progress_remain_display":2586,"forecast_remain_display":2586,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":385000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"","project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_invoice":false,"can_payment":false,"duration_display":814,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"","can_view_product":true,"budget_display":"38.5\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":0,"un_invoiced":0,"object_type":1,"can_view_product_cost":true}],"thisUser":"","options":{"Projects[project_status]":{"key":"Projects[project_status]","name":"\u5546\u673a\u72b6\u6001","value":[{"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},{"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},{"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},{"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},{"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"}]}},"can_create":true,"can_create_work_log":true,"can_create_schedule":true,"pagenation":{"totalcount":3152,"thispage":1,"pagesize":20},"count2":[{"name":"\u5408\u540c\u603b\u91d1\u989d","value":"397501875.62"},{"name":"\u5df2\u6536\u6b3e","value":"371005027.91"},{"name":"\u672a\u6536\u6b3e","value":26496847.71},{"name":"\u5df2\u5f00\u53d1\u7968","value":"378530223.85"},{"name":"\u672a\u5f00\u53d1\u7968","value":18967151.77}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-04 12:41:07', 2659307008) RETURNING "id" |
| 12:41:07.024 | 3.9 ms | yii\db\Command::query | SELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_pre_sales" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=1) AND ("c"."project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23)) GROUP BY "c"."project_id" |
| 12:41:07.041 | 3.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (229, 85, 24, 2, 17, 84, 132, 6, 108, 18, 311, 479)) |
| 12:41:07.037 | 3.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (229, 85, 24, 2, 17, 84, 132, 6, 108, 18, 311, 479)) |
| 12:41:06.986 | 3.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23) |
| 12:41:07.033 | 2.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (229, 85, 24, 2, 17, 84, 132, 6, 108, 18, 311, 479)) |
| 12:41:07.029 | 2.2 ms | yii\db\Command::query | SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23)) GROUP BY "project_id" |
| 12:41:06.994 | 2.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23) |
| 12:41:06.982 | 2.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23) |
| 12:41:07.046 | 1.9 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "collected_date" 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.wrote_date 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))) 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"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) 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"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "r" WHERE "contract_id" IN (229, 85, 24, 2, 17, 84, 132, 6, 108, 18, 311, 479) ORDER BY "id" DESC |
| 12:41:07.105 | 1.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23)) |
| 12:41:07.011 | 1.4 ms | yii\db\Command::query | SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23) GROUP BY "project_id" |
| 12:41:06.980 | 1.4 ms | yii\db\Command::query | SELECT id, product_type_id, product_type_id as key, name, coalesce(budget, 0) as budget, coalesce(pct, 0) as pct, coalesce(profit, 0) as profit, project_id FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23) |
| 12:41:07.045 | 1.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE ("status"=2) AND ("sales_contract_id" IN (229, 85, 24, 2, 17, 84, 132, 6, 108, 18, 311, 479)) ORDER BY "id" DESC |
| 12:41:07.032 | 1.1 ms | yii\db\Command::query | SELECT "id", "from_project", "payment_collection_remind_ahead", "serial_no", "is_settle", "is_deliver", "is_outbound", "erp_settle_amount", "erp_un_settle_amount", "including_tax", "amount" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23) |
| 12:41:06.975 | 1.0 ms | yii\db\Command::query | SELECT "project_id", "contribution" AS "value", "engineer_id" AS "key", "u"."name" FROM "a57be577deb434"."tbl_project_architects" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON engineer_id = u.id WHERE "a57be577deb434"."tbl_project_architects"."project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23) ORDER BY "contribution" DESC, "engineer_id" |
| 12:41:07.109 | 1.0 ms | yii\db\Command::query | SELECT s.id, project_id, client_id, schedule_title, complete_at, start_at, 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 ("complete_at" >= '2026-05-21')) AND ((("is_public"=1) AND ("created_by" != 1001)) OR ("created_by"=1001) OR ("ccr"."user_id"=1001)) AND ("s"."project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23)) 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 |
| 12:41:07.054 | 0.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23) ORDER BY "id" |
| 12:41:07.001 | 0.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (5, 12, 23, 20, 3, 24, 16, 25, 18, 27, 28, 31, 9, 6, 17, 42, 4) |
| 12:41:06.990 | 0.8 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (100, 97, 96, 46, 99, 8, 112, 182, 179, 142, 165, 128, 213, 2, 7, 212, 5, 1, 94, 229, 215, 6, 136, 196, 204, 133, 137, 135, 134, 197, 194, 139, 140, 129, 198, 201, 164, 205, 203, 184, 189, 153, 185, 191, 199, 202, 166, 226, 231, 207, 224, 223, 214, 219, 9, 208, 210, 211, 227, 216, 93, 228, 11, 209, 217, 230, 218, 10, 221, 225, 222, 265, 157, 331, 332, 311, 315, 316, 317, 2100000000, 313, 340, 341, 349, 156, 324, 326, 359, 369, 377, 356, 327, 352, 432, 429, 433, 402, 400, 416, 380, 430, 401, 437, 410, 399, 384, 374, 438, 439, 386)) ORDER BY "sort" |
| 12:41:07.048 | 0.7 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (229, 85, 24, 2, 17, 84, 132, 6, 108, 18, 311, 479) ORDER BY "id" |
| 12:41:06.997 | 0.7 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (100, 97, 96, 46, 99, 8, 112, 182, 179, 142, 165, 128, 213, 2, 7, 212, 5, 1, 94, 229, 215, 6, 136, 196, 204, 133, 137, 135, 134, 197, 194, 139, 140, 129, 198, 201, 164, 205, 203, 184, 189, 153, 185, 191, 199, 202, 166, 226, 231, 207, 224, 223, 214, 219, 9, 208, 210, 211, 227, 216, 93, 228, 11, 209, 217, 230, 218, 10, 221, 225, 222, 265, 157, 331, 332, 311, 315, 316, 317, 2100000000, 313, 340, 341, 349, 156, 324, 326, 359, 369, 377, 356, 327, 352, 432, 429, 433, 402, 400, 416, 380, 430, 401, 437, 410, 399, 384, 374, 438, 439, 386)) ORDER BY "sort" |
| 12:41:06.824 | 0.7 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 12:41:06.985 | 0.7 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (100, 97, 96, 46, 99, 8, 112, 182, 179, 142, 165, 128, 213, 2, 7, 212, 5, 1, 94, 229, 215, 6, 136, 196, 204, 133, 137, 135, 134, 197, 194, 139, 140, 129, 198, 201, 164, 205, 203, 184, 189, 153, 185, 191, 199, 202, 166, 226, 231, 207, 224, 223, 214, 219, 9, 208, 210, 211, 227, 216, 93, 228, 11, 209, 217, 230, 218, 10, 221, 225, 222, 265, 157, 331, 332, 311, 315, 316, 317, 2100000000, 313, 340, 341, 349, 156, 324, 326, 359, 369, 377, 356, 327, 352, 432, 429, 433, 402, 400, 416, 380, 430, 401, 437, 410, 399, 384, 374, 438, 439, 386)) ORDER BY "sort" |
| 12:41:07.051 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (229, 85, 24, 2, 17, 84, 132, 6, 108, 18, 311, 479) |
| 12:41:07.108 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status"=1) AND ("project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23)) |
| 12:41:06.971 | 0.6 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (5, 12, 23, 20, 3, 24, 16, 25, 18, 27, 28, 31, 9, 6, 17, 42, 4) |
| 12:41:07.012 | 0.6 ms | yii\db\Command::query | SELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=1) AND (("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL)) AND ("project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23)) GROUP BY "project_id" |
| 12:41:07.028 | 0.5 ms | yii\db\Command::query | SELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=2) AND ("project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23)) GROUP BY "project_id" |
| 12:41:07.050 | 0.5 ms | yii\db\Command::query | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (229, 85, 24, 2, 17, 84, 132, 6, 108, 18, 311, 479) |
| 12:41:07.001 | 0.5 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1008, 1006, 1007, 1009, 1004, 1005, 1003)) |
| 12:41:07.049 | 0.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (229, 85, 24, 2, 17, 84, 132, 6, 108, 18, 311, 479) ORDER BY "remind_date" |
| 12:41:06.826 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 12:41:07.010 | 0.5 ms | yii\db\Command::query | SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23)) GROUP BY "project_id" |
| 12:41:07.053 | 0.5 ms | yii\db\Command::query | SELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23) |
| 12:41:07.107 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23) |
| 12:41:07.105 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 22, 23) |
| 12:41:07.052 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (285, 393, 224, 303, 199, 370, 358, 157, 49, 340, 288, 388, 169, 61, 337, 295, 221, 71, 47, 375, 260) |
| 12:41:07.315 | 0.4 ms | yii\db\Command::query | SELECT "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (1, 2, 3, 4, 5) ORDER BY "order" |
| 12:41:07.036 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (2022, 122, 806, 262, 148, 188, 128, 27, 795, 672, 1168, 665) |
| 12:41:07.052 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (46, 147, 68, 183, 122, 163, 104, 146, 153, 204, 95, 659, 675, 676) |
| 12:41:06.999 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 1003, 1005, 1006, 1007, 1008, 1009) |
| 12:41:06.973 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5311, 1004, 1005, 5300)) |
| 12:41:07.000 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 1003, 1005, 1006, 1007, 1008, 1009) |
| 12:41:07.040 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (676, 424, 26, 247, 259, 344, 147, 252, 106, 1098) |
| 12:41:06.972 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 5311, 5300, 1005) |
| 12:41:07.002 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 5311, 5300, 1005) |
| 12:41:07.003 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5311, 1004, 1005, 5300)) |
| 12:41:06.999 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1008, 1006, 1007, 1009, 1004, 1005, 1003)) |
| 12:41:06.979 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (3, 4, 5) |
| 12:41:06.980 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (10, 2, 1, 7, 3) |
| 12:41:06.974 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id" IN (6, 19, 10, 5, 17, 9, 2, 25, 3, 18) |
| 12:41:06.975 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2) |
| 12:41:06.974 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id" IN (6, 5, 1) |
| 12:41:06.974 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (47, 43, 80) |
| 12:41:07.000 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (1, 9) |
| 12:41:06.823 | 0.2 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |