6a20e09d054ae: POST https://beta.jinchangxiao.com/v2/project/of-client at 2026-06-04 10:19:09 am by 223.104.42.221
Log Messages
总计114条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 10:19:09.021 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 10:19:09.021 | trace | yii\base\Module::getModule | Loading module: debug |
| 10:19:09.021 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 10:19:09.021 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 10:19:09.021 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 10:19:09.022 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:19:09.023 | info | time tracing start | 1780539549023994880 |
| 10:19:09.024 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 10:19:09.024 | trace | yii\web\Application::handleRequest | Route requested: 'v2/project/of-client' |
| 10:19:09.024 | trace | yii\base\Module::getModule | Loading module: v2 |
| 10:19:09.295 | info | yii\web\Session::open | Session started |
| 10:19:09.296 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 10:19:09.297 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC' |
| 10:19:09.299 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:19:09.302 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 10:19:09.302 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:19:09.302 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 10:19:09.302 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 10:19:09.303 | trace | yii\base\Controller::runAction | Route to run: v2/project/of-client |
| 10:19:09.304 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:19:09.305 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 10:19:09.305 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\ProjectController::actionOfClient() |
| 10:19:09.306 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='2128') AND ("deleted"=FALSE) |
| 10:19:09.306 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:19:09.307 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 10:19:09.307 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:19:09.307 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 10:19:09.309 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:19:09.311 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:19:09.315 | info | 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 (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 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"=1000) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) AND ("p"."client_id"=2128) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC) "c" |
| 10:19:09.339 | info | 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 (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 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"=1000) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) AND ("p"."client_id"=2128) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC LIMIT 10 |
| 10:19:09.365 | info | 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"=2128 |
| 10:19:09.366 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087 |
| 10:19:09.366 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087) |
| 10:19:09.368 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id"=6 |
| 10:19:09.369 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=47 |
| 10:19:09.369 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id"=20 |
| 10:19:09.370 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 10:19:09.370 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2) |
| 10:19:09.371 | info | 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 (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132) ORDER BY "contribution" DESC, "engineer_id" |
| 10:19:09.374 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:19:09.374 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 10:19:09.374 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (2, 3, 5, 4) |
| 10:19:09.375 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (5, 2, 49, 10, 3) |
| 10:19:09.375 | info | 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 (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132) |
| 10:19:09.377 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132) |
| 10:19:09.378 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (1, 2, 5, 226, 184, 189, 185, 191, 136, 135, 140, 197, 199, 164, 179, 142, 232, 183, 188, 323, 349, 369, 377, 165, 172, 416, 128, 181)) ORDER BY "sort" |
| 10:19:09.378 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132) |
| 10:19:09.380 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (1, 2, 5, 226, 184, 189, 185, 191, 136, 135, 140, 197, 199, 164, 179, 142, 232, 183, 188, 323, 349, 369, 377, 165, 172, 416, 128, 181)) ORDER BY "sort" |
| 10:19:09.383 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132) |
| 10:19:09.384 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (1, 2, 5, 226, 184, 189, 185, 191, 136, 135, 140, 197, 199, 164, 179, 142, 232, 183, 188, 323, 349, 369, 377, 165, 172, 416, 128, 181)) ORDER BY "sort" |
| 10:19:09.386 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087 |
| 10:19:09.386 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087) |
| 10:19:09.387 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
| 10:19:09.387 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5087, 1001) |
| 10:19:09.388 | info | 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 (1001, 5087)) |
| 10:19:09.388 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 10:19:09.389 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087 |
| 10:19:09.389 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087) |
| 10:19:09.389 | info | 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 (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132) GROUP BY "c"."project_id" |
| 10:19:09.402 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:19:09.402 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 10:19:09.403 | info | yii\db\Command::query | SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("project_id" IN (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132)) GROUP BY "project_id" |
| 10:19:09.406 | info | yii\db\Command::query | SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132) GROUP BY "project_id" |
| 10:19:09.410 | info | 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 (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132)) GROUP BY "project_id" |
| 10:19:09.411 | info | 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 (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132)) GROUP BY "c"."project_id" |
| 10:19:09.426 | info | 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 (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132)) GROUP BY "c"."project_id" |
| 10:19:09.431 | info | 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 (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132)) GROUP BY "project_id" |
| 10:19:09.432 | info | yii\db\Command::query | SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132)) GROUP BY "project_id" |
| 10:19:09.435 | info | 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 (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132) |
| 10:19:09.437 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id"=4289) |
| 10:19:09.442 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=30794 |
| 10:19:09.443 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id"=4289) |
| 10:19:09.447 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=31683 |
| 10:19:09.448 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id"=4289) |
| 10:19:09.452 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE ("status"=2) AND ("sales_contract_id"=4289) ORDER BY "id" DESC |
| 10:19:09.454 | info | 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"=4289 ORDER BY "id" DESC |
| 10:19:09.458 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013 |
| 10:19:09.458 | info | 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"=4289 ORDER BY "id" |
| 10:19:09.459 | info | 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"=4289 ORDER BY "remind_date" |
| 10:19:09.460 | info | 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"=4289 |
| 10:19:09.461 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087 |
| 10:19:09.461 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087) |
| 10:19:09.461 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id"=4289 |
| 10:19:09.462 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (661, 678, 262, 695, 505, 59) |
| 10:19:09.463 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4355, 4368, 4370, 3888, 4379, 4387, 4369) |
| 10:19:09.464 | info | yii\db\Command::query | SELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132) |
| 10:19:09.464 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 10:19:09.465 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 10:19:09.465 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132) ORDER BY "id" |
| 10:19:09.467 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1942, 2227, 2226, 2225, 2041, 1923, 587, 2228, 2261, 1372, 2265, 2263, 2266) |
| 10:19:09.468 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (2, 7, 21, 4, 23) |
| 10:19:09.469 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (9, 5, 30, 4, 7, 229, 52, 195, 221, 43) |
| 10:19:09.469 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (5, 4, 21, 227, 10, 285, 284, 286, 134) |
| 10:19:09.470 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1658, 42, 1756, 1600, 31, 1754, 1755, 41, 1782, 1769, 1775, 1783, 1047) |
| 10:19:09.471 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (4, 2, 6, 3, 9) |
| 10:19:09.472 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (2139, 2140, 2141, 2142, 2143, 2144, 2159, 2160) |
| 10:19:09.473 | info | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132)) GROUP BY "object_id" |
| 10:19:09.508 | info | yii\db\Command::query | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=1) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132)) GROUP BY "object_id" |
| 10:19:09.534 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132) |
| 10:19:09.535 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132)) |
| 10:19:09.537 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id" IN (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132) |
| 10:19:09.538 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 10:19:09.539 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id" IN (35, 89, 124, 192, 310, 314, 158) |
| 10:19:09.539 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_used_client_id", "remind_date", "amount", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id" IN (35, 89, 124, 192, 310, 314, 158) |
| 10:19:09.540 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id" IN (35, 89, 124, 192, 310, 314, 158) |
| 10:19:09.540 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id" IN (35, 89, 124, 192, 310, 314, 158) |
| 10:19:09.541 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status"=1) AND ("project_id" IN (3854, 4133, 4165, 4109, 4132, 3695, 3977, 3559, 3124, 3132)) |
| 10:19:09.542 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: viewProduct |
| 10:19:09.542 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: StoreKeeper |
| 10:19:09.542 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 10:19:09.546 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:19:09.547 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 10:19:09.547 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 2, 1159, 'v2/project/of-client', '{"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"2","id":"2128","page":"1","posttime":"1780539520","token":"07bdc824e77c4d5592868273ae1cca3b","version_code":"1159"}', '{"code":200,"data":{"list":[{"id":3854,"client_id":2128,"project_status":2,"project_progress":5,"budget":"44540520","profit_pct":"25","bargain_date":"2026-12-31","description":null,"created_by":5087,"created_at":"2025-05-13 09:35:09","updated_at":"2026-05-21 17:47:35","engineer_id":null,"project_title":"\u5907\u4efd\u9879\u76ee\u4e8c\u671f","collected":"0","status_updated_at":"2025-05-25 16:44:14.571721+08","success_rate":null,"comment":"\u4e8c\u671f\u6269\u5bb9","contract_type":1,"progress_updated_at":"2025-05-25 16:44:14.571721+08","forecast_updated_at":"2025-05-25 16:44:14.571721+08","end_at":"","pinyin_shortcut":"bfxmeq","creator":5087,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":1349,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"11135130.000000000000","remain":"374 days 17:34:54.769775","progress_remain":"374 days 17:34:54.769775","forecast_remain":"374 days 17:34:54.769775","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"387 days 00:43:59.811572","issued_invoices":null,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":6,"client_class":47,"client_industry":20,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"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":20,"key":20,"name":"\u5176\u4ed6"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3854,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7","description":"\u5b9a\u4e49\uff1a1.\u62a5\u4ef7\u6709\u6548\u671f 2.\u6838\u7b97\u5229\u6da6\u7387 3. \u4ea4\u8d27\u65b9\u5f0f\u53ca\u65f6\u95f4 4.\u9a8c\u6536\u65b9\u5f0f 5.\u6536\u6b3e\u65b9\u5f0f 6.\u8fdd\u7ea6\u6761\u6b3e \n\u65b9\u6cd5\uff1a\u7528\u516c\u53f8\u6807\u51c6\u7684\u62a5\u4ef7\u5355\u6837\u5f0f\u5411\u5ba2\u6237\u63d0\u4f9b\u62a5\u4ef7\u3002"},"projectProductTypes":[{"id":23,"product_type_id":23,"key":23,"name":"\u793c\u54c1","budget":"53588","pct":"25","profit":"13397","project_id":3854},{"id":21,"product_type_id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907","budget":"44","pct":"25","profit":"11","project_id":3854},{"id":4,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"44486888","pct":"25","profit":"11121722","project_id":3854}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"casePoints":{"project_id":3854,"points":"113"},"workLogCount":null,"caseCount":{"project_id":3854,"count":3},"salesTimeCount":null,"implementTimeCount":{"project_id":3854,"sum":"8.1","times":"1"},"presalesTimeCount":{"project_id":3854,"sum":"0.05","times":"1"},"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3854,"sum":"194.66"},"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[{"id":12044,"project_id":3854,"product_id":2261,"amount":"44433443","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"44433443","total_cost":null,"erp_sales_order_product_id":null,"supplier":null,"product":{"id":2261,"name":"MK-MC300","product_type":4,"product_component":52,"product_brand":4,"product_serie":1769,"product_misc":null,"product_qa":null,"pn":"","description":"MK-MC300\u62fe\u97f3\u9ea6\u514b\u98ce\uff0c\u542b5\u7c73\u7ebf","created_by":1013,"created_at":"2026-03-16 10:07:43","updated_at":"2026-05-21 18:10:51","pinyin_shortcut":"MKMC300","product_unit":3,"is_renew":false,"in_out_at":"2026-05-21 18:10:51.145864+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":52,"key":52,"name":"\u534f\u4f5c"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1769,"key":1769,"name":"\u5168\u5411\u9ea6\u514b\u98ce"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":null},{"id":12045,"project_id":3854,"product_id":1372,"amount":"53445","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"53445","total_cost":null,"erp_sales_order_product_id":null,"supplier":null,"product":{"id":1372,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73","product_type":4,"product_component":43,"product_brand":134,"product_serie":1047,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-01-26 16:48:55","updated_at":"2026-04-23 16:19:02","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"is_renew":false,"in_out_at":"2026-04-23 16:19:02.133182+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1047,"key":1047,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":null},{"id":12046,"project_id":3854,"product_id":2265,"amount":"53534","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"53534","total_cost":null,"erp_sales_order_product_id":null,"supplier":null,"product":{"id":2265,"name":"\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2","product_type":23,"product_component":195,"product_brand":284,"product_serie":1775,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:34:40","updated_at":"2026-03-25 09:28:29","pinyin_shortcut":"olwlOlivoilagly500MLx2jxlh","product_unit":9,"is_renew":false,"in_out_at":"2026-03-25 09:28:29.365794+08","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":195,"key":195,"name":"\u8425\u517b\u98df\u54c1\u6ecb\u8865"},"productBrand":{"id":284,"key":284,"name":"\u6b27\u4e3d\u8587\u5170"},"productSerie":{"id":1775,"key":1775,"name":"\u98df\u7528\u6cb9"},"productUnit":{"id":9,"key":9,"name":"\u76d2"}},"erpSalesOrderProduct":null},{"id":12047,"project_id":3854,"product_id":2263,"amount":"44","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"44","total_cost":null,"erp_sales_order_product_id":null,"supplier":null,"product":{"id":2263,"name":"\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8","product_type":21,"product_component":229,"product_brand":285,"product_serie":1782,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:32:00","updated_at":"2026-03-20 15:16:21","pinyin_shortcut":"xptymb100c","product_unit":3,"is_renew":false,"in_out_at":"2026-03-20 15:16:21.988041+08","productType":{"id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907"},"productComponent":{"id":229,"key":229,"name":"\u6570\u7801\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":285,"key":285,"name":"\u867e\u76ae"},"productSerie":{"id":1782,"key":1782,"name":"\u6295\u5f71\u5e55\u5e03"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":null},{"id":12048,"project_id":3854,"product_id":2266,"amount":"54","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"54","total_cost":null,"erp_sales_order_product_id":null,"supplier":null,"product":{"id":2266,"name":"\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20","product_type":23,"product_component":221,"product_brand":286,"product_serie":1783,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:38:56","updated_at":"2026-03-25 09:28:29","pinyin_shortcut":"sxddtxdxfhminibxkCM20","product_unit":3,"is_renew":false,"in_out_at":"2026-03-25 09:28:29.365794+08","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":221,"key":221,"name":"\u7535\u5b50\u4ea7\u54c1"},"productBrand":{"id":286,"key":286,"name":"\u677e\u4e0b"},"productSerie":{"id":1783,"key":1783,"name":"\u7535\u52a8\u5243\u987b\u5200"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":null}],"commentCount":{"object_id":3854,"comment":7},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":{"id":310,"project_id":3854,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"erpSalesOrderVerify":null,"remain_display":374,"progress_remain_display":374,"forecast_remain_display":374,"projectProductTotalAmount":44540520,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":false,"projectProductTotalNumber":5,"unissued_invoice":44540520,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_invoice":false,"can_payment":false,"duration_display":387,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"4454.05\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},{"id":4133,"client_id":2128,"project_status":2,"project_progress":5,"budget":"4350000","profit_pct":"16","bargain_date":"2026-07-31","description":null,"created_by":5087,"created_at":"2026-03-05 18:23:59","updated_at":"2026-03-22 19:40:06","engineer_id":null,"project_title":"\u5e94\u7528\u7cfb\u7edf\u670d\u52a1\u5668\u91c7\u8d2d-K","collected":"0","status_updated_at":"2026-03-09 00:13:53.573869+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2026-03-09 00:13:53.573869+08","forecast_updated_at":"2026-03-09 00:13:53.573869+08","end_at":"","pinyin_shortcut":"yyxtfwqcgK","creator":5087,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"696000.000000000000","remain":"87 days 10:05:15.767627","progress_remain":"87 days 10:05:15.767627","forecast_remain":"87 days 10:05:15.767627","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"90 days 15:55:09.522092","issued_invoices":null,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":6,"client_class":47,"client_industry":20,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"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":20,"key":20,"name":"\u5176\u4ed6"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7","description":"\u5b9a\u4e49\uff1a1.\u62a5\u4ef7\u6709\u6548\u671f 2.\u6838\u7b97\u5229\u6da6\u7387 3. \u4ea4\u8d27\u65b9\u5f0f\u53ca\u65f6\u95f4 4.\u9a8c\u6536\u65b9\u5f0f 5.\u6536\u6b3e\u65b9\u5f0f 6.\u8fdd\u7ea6\u6761\u6b3e \n\u65b9\u6cd5\uff1a\u7528\u516c\u53f8\u6807\u51c6\u7684\u62a5\u4ef7\u5355\u6837\u5f0f\u5411\u5ba2\u6237\u63d0\u4f9b\u62a5\u4ef7\u3002"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"4350000","pct":"16","profit":"696000","project_id":4133}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":128,"key":128,"name":"\u516c\u5f00\u62db\u6807"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[{"id":2134,"user_id":1001,"key":1001,"project_id":4133,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"projectProductRels":[],"commentCount":{"object_id":4133,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":87,"progress_remain_display":87,"forecast_remain_display":87,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":4350000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_invoice":false,"can_payment":false,"duration_display":90,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"435\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},{"id":4165,"client_id":2128,"project_status":2,"project_progress":2,"budget":"1000000","profit_pct":"5","bargain_date":"2026-07-01","description":null,"created_by":5087,"created_at":"2026-04-08 12:16:03","updated_at":"2026-04-08 12:16:03","engineer_id":null,"project_title":"\u667a\u7b97\u670d\u52a1\u5668\u91c7\u8d2d","collected":"0","status_updated_at":"2026-04-08 12:16:03.944425+08","success_rate":null,"comment":null,"contract_type":1,"progress_updated_at":"2026-04-08 12:16:03.944425+08","forecast_updated_at":"2026-04-08 12:16:03.944425+08","end_at":"","pinyin_shortcut":"zsfwqcg","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"50000.0000000000000000","remain":"56 days 22:03:05.397071","progress_remain":"56 days 22:03:05.397071","forecast_remain":"56 days 22:03:05.397071","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"56 days 22:03:05.397071","issued_invoices":null,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":6,"client_class":47,"client_industry":20,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"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":20,"key":20,"name":"\u5176\u4ed6"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":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":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"1000000.0","pct":"5","profit":"50000.0","project_id":4165}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":4165,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":56,"progress_remain_display":56,"forecast_remain_display":56,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":1000000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_invoice":false,"can_payment":false,"duration_display":56,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"100\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},{"id":4109,"client_id":2128,"project_status":2,"project_progress":2,"budget":"516000","profit_pct":"25","bargain_date":"2026-06-30","description":null,"created_by":5087,"created_at":"2026-01-18 20:32:27","updated_at":"2026-03-22 19:37:00","engineer_id":null,"project_title":"\u865a\u62df\u684c\u9762\u5efa\u8bbe-K","collected":"0","status_updated_at":"2026-01-18 20:32:27.86405+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2026-01-18 20:32:27.86405+08","forecast_updated_at":"2026-01-18 20:32:27.86405+08","end_at":"","pinyin_shortcut":"xnzmjsK","creator":5087,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"129000.0000000000000000","remain":"136 days 13:46:41.477446","progress_remain":"136 days 13:46:41.477446","forecast_remain":"136 days 13:46:41.477446","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"136 days 13:46:41.477446","issued_invoices":null,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":6,"client_class":47,"client_industry":20,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"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":20,"key":20,"name":"\u5176\u4ed6"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":4109,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"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":8,"product_type_id":8,"key":8,"name":"\u4e91\u684c\u9762","budget":"516000","pct":"25","profit":"129000","project_id":4109}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":128,"key":128,"name":"\u516c\u5f00\u62db\u6807"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"casePoints":{"project_id":4109,"points":"50"},"workLogCount":null,"caseCount":{"project_id":4109,"count":1},"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":{"project_id":4109,"sum":"1.83333333333333","times":"1"},"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[{"id":2083,"user_id":1001,"key":1001,"project_id":4109,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"projectProductRels":[],"commentCount":{"object_id":4109,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":136,"progress_remain_display":136,"forecast_remain_display":136,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":516000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_invoice":false,"can_payment":false,"duration_display":136,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"51.6\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},{"id":4132,"client_id":2128,"project_status":2,"project_progress":5,"budget":"5500000","profit_pct":"20","bargain_date":"2026-04-30","description":null,"created_by":5087,"created_at":"2026-03-05 09:40:01","updated_at":"2026-03-25 09:31:50","engineer_id":null,"project_title":"AI\u670d\u52a1\u5668\u91c7\u8d2d","collected":"0","status_updated_at":"2026-03-09 00:02:20.988792+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2026-03-09 00:02:20.988792+08","forecast_updated_at":"2026-03-09 00:02:20.988792+08","end_at":"","pinyin_shortcut":"AIfwqcg","creator":5087,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":true,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"1100000.000000000000","remain":"87 days 10:16:48.352704","progress_remain":"87 days 10:16:48.352704","forecast_remain":"87 days 10:16:48.352704","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"91 days 00:39:07.521808","issued_invoices":null,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":6,"client_class":47,"client_industry":20,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"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":20,"key":20,"name":"\u5176\u4ed6"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7","description":"\u5b9a\u4e49\uff1a1.\u62a5\u4ef7\u6709\u6548\u671f 2.\u6838\u7b97\u5229\u6da6\u7387 3. \u4ea4\u8d27\u65b9\u5f0f\u53ca\u65f6\u95f4 4.\u9a8c\u6536\u65b9\u5f0f 5.\u6536\u6b3e\u65b9\u5f0f 6.\u8fdd\u7ea6\u6761\u6b3e \n\u65b9\u6cd5\uff1a\u7528\u516c\u53f8\u6807\u51c6\u7684\u62a5\u4ef7\u5355\u6837\u5f0f\u5411\u5ba2\u6237\u63d0\u4f9b\u62a5\u4ef7\u3002"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"5500000","pct":"20","profit":"1100000","project_id":4132}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":128,"key":128,"name":"\u516c\u5f00\u62db\u6807"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"casePoints":{"project_id":4132,"points":"250"},"workLogCount":null,"caseCount":{"project_id":4132,"count":3},"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":{"project_id":4132,"sum":"3.13333333333333","times":"3"},"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[{"id":2140,"user_id":1001,"key":1001,"project_id":4132,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"projectProductRels":[],"commentCount":{"object_id":4132,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":{"id":314,"project_id":4132,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"erpSalesOrderVerify":null,"remain_display":87,"progress_remain_display":87,"forecast_remain_display":87,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":5500000,"is_exceeded":true,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_invoice":false,"can_payment":false,"duration_display":91,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"550\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},{"id":3695,"client_id":2128,"project_status":3,"project_progress":49,"budget":"631660","profit_pct":"42.15","bargain_date":"2025-11-30","description":"","created_by":5087,"created_at":"2024-10-20 19:25:01","updated_at":"2026-04-22 15:46:13","engineer_id":null,"project_title":"\u5907\u4efd\u7cfb\u7edf\u56fd\u4ea7\u5316\u66ff\u4ee3-K","collected":"600077","status_updated_at":"2026-03-15 20:20:30.924155+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2026-03-15 20:20:30.924155+08","forecast_updated_at":"2026-03-15 20:20:30.924155+08","end_at":"","pinyin_shortcut":"bfxtgchtdK","creator":5087,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":1312,"is_sales_order_ready":true,"collected_plan":631660,"change_status_to":null,"is_verify":false,"profits":"266244.690000000000000000","remain":"80 days 13:58:38.417341","progress_remain":"80 days 13:58:38.417341","forecast_remain":"80 days 13:58:38.417341","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"591 days 14:54:07.983199","issued_invoices":"631660.00","client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":6,"client_class":47,"client_industry":20,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"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":20,"key":20,"name":"\u5176\u4ed6"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3695,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":49,"key":49,"name":"\u6536\u6b3e\u4e2d","description":"\u5b9a\u4e49\uff1a\u5f00\u53d1\u7968\uff0c\u5b8c\u6210\u6536\u6b3e \u3002\n\u65b9\u6cd5\uff1a\u5411\u8d22\u52a1\u7533\u8bf7\u5f00\u53d1\u7968\u3002"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"63139","pct":"42.15","profit":"26613.08","project_id":3695},{"id":7,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"568521","pct":"42.15","profit":"239631.60","project_id":3695}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"casePoints":{"project_id":3695,"points":"942"},"workLogCount":null,"caseCount":{"project_id":3695,"count":12},"salesTimeCount":null,"implementTimeCount":{"project_id":3695,"sum":"83.05","times":"12"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3695,"sum":"2028.08"},"buildContract":{"id":4289,"from_project":3695,"payment_collection_remind_ahead":"30 days","serial_no":"2025-12-07-002","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"600077","erp_un_settle_amount":"31583","including_tax":true,"amount":"631660","contractScans":[{"id":55990,"object_type":105,"object_id":4289,"attachment_id":30794,"attachment":{"id":30794,"key":30794,"name":"de846180-cf65-3d7b-a817-1ad2d09cc669","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/de846180-cf65-3d7b-a817-1ad2d09cc669\/33\u6240-\u5907\u4efd\u5347\u7ea7\u6539\u9020\u5408\u540c.pdf","orig_name":"33\u6240-\u5907\u4efd\u5347\u7ea7\u6539\u9020\u5408\u540c.pdf"}}],"receiptScans":[{"id":56088,"object_type":106,"object_id":4289,"attachment_id":31683,"attachment":{"id":31683,"key":31683,"name":"c3987c2e-496d-3cf7-822f-67198b6d3098","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/c3987c2e-496d-3cf7-822f-67198b6d3098\/2026_02_02_08_55_58.pdf","orig_name":"2026_02_02_08_55_58.pdf"}}],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[{"id":"12196","key":"12196","contract_id":4289,"value":"600077","created_by":1013,"collected_date":"2026-03-25 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":95}],"salesContractInvoices":[{"id":2257,"key":2257,"contract_id":4289,"value":"631660.00","attachment_id":null,"from_date":"2025-12-23","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2703,"key":2703,"contract_id":4289,"name":"2026-01-31","value":"189498","overdue_days":53,"status":1,"remind_date":"2026-01-31","pct":30,"overdue_display":"\u903e\u671f53\u5929"},{"id":2704,"key":2704,"contract_id":4289,"name":"2026-04-30","value":"410579","overdue_days":null,"status":1,"remind_date":"2026-04-30","pct":65,"overdue_display":""},{"id":2705,"key":2705,"contract_id":4289,"name":"2027-01-31","value":"31583","overdue_days":null,"status":0,"remind_date":"2027-01-31","pct":5,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":9983,"user_id":5087,"key":5087,"contract_id":4289,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}}],"salesSupplierRels":[{"id":4074,"contract_id":4289,"supplier_id":661,"purchase_id":4355,"supplier":{"id":661,"key":661,"name":"\u822a\u5929\u58f9\u8fdb\u5236\uff08\u6c5f\u82cf\uff09\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4355,"key":4355,"serial_no":"Unary-SO-2025122311"}},{"id":4075,"contract_id":4289,"supplier_id":678,"purchase_id":4368,"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4368,"key":4368,"serial_no":"ZLQS20260107"}},{"id":4077,"contract_id":4289,"supplier_id":262,"purchase_id":4370,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":4370,"key":4370,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3371274017958727\/3371274017959694"}},{"id":4078,"contract_id":4289,"supplier_id":695,"purchase_id":3888,"supplier":{"id":695,"key":695,"name":"\u9b4f\u82f1\u660e"},"purchase":{"id":3888,"key":3888,"serial_no":"TSKJ20250430-HYF-001"}},{"id":4079,"contract_id":4289,"supplier_id":678,"purchase_id":4379,"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4379,"key":4379,"serial_no":"ZLQS20260115"}},{"id":4080,"contract_id":4289,"supplier_id":505,"purchase_id":4387,"supplier":{"id":505,"key":505,"name":"\u795e\u5dde\u6167\u667a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4387,"key":4387,"serial_no":"TSKJ20260120-ZHF-001"}},{"id":4113,"contract_id":4289,"supplier_id":59,"purchase_id":4369,"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":4369,"key":4369,"serial_no":"TGXC20260107-1"}}],"payment_collection_remind_ahead_display":"\u63d0\u524d30\u5929","invoiced":631660},"projectRemindReceivers":[{"id":1985,"user_id":1001,"key":1001,"project_id":3695,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"projectProductRels":[{"id":11903,"project_id":3695,"product_id":1942,"amount":"568521","number":1,"cost":"250000","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"568521","total_cost":"250000","erp_sales_order_product_id":2139,"supplier":null,"product":{"id":1942,"name":"\u58f9\u8fdb\u5236\u9ed1\u65b9\u5bb9\u707e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6 V6","product_type":7,"product_component":30,"product_brand":227,"product_serie":1600,"product_misc":null,"product_qa":null,"pn":"","description":"\"\u8f6f\u4ef6\u57fa\u7840\u5e73\u53f0\uff1a\n64bit \u4f01\u4e1a\u7ea7 Linux \u5185\u6838\uff0c\u57fa\u4e8eWEB \u754c\u9762\u7684\u6570\u636e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf \u8f6f\u4ef6\uff0c\u6807\u914d\u6587\u4ef6\/\u6570\u636e\u5e93\n\/Windows\/Linux\/\u865a\u62df\u5316\u5b9a\u65f6\u5907\u4efd\u529f\u80fd\u3002\n\u5bb9\u91cf\u6388\u6743\uff1a\nUnaRDP-1P\uff1a1P \u5b9a\u65f6\u5907\u4efd\u5bb9\u91cf\u6388\u6743\u3002\n\u9ad8\u7ea7\u529f\u80fd\u6388\u6743\uff1a\nUnaDedupe-LIC*3\uff1a3\u4e2a\u91cd\u5220\u529f\u80fd \u6388\u6743\uff0c\u542b\u6e90\u7aef\u548c\u76ee\u6807\u7aef\u91cd\u5220\uff1b\u5b9e \u65f6\u5907\u4efd\u5bb9\u91cf\u4e0d\u652f\u6301\u91cd\u5220\u529f\u80fd\uff1bCDM \u529f\u80fd\u6253\u5f00\u65f6\u4ec5\u652f\u6301\u76ee\u6807\u7aef\u91cd\u5220\u3002\n(\u6ce8\uff1a\u5982\u679c\u9009\u62e9\u91cd\u5220\u529f\u80fd\uff0c\u5fc5\u987b\u589e \u914d RAID \u5361\u6389\u7535\u4fdd\u62a4)\u3002\nUnaD2D2R-LIC*3\uff1a3\u4e2a\u4e24\u53f0\u9ed1\u65b9\u670d \u52a1\u5668\u4e4b\u95f4\u7684\u6570\u636e\u5f02\u5730\u540c\u6b65\u901a\u9053\u6388 \u6743\uff0c\u652f\u6301\u5c06\u672c\u5730\u9ed1\u65b9\u670d\u52a1\u5668\u4e2d\u5907 \u4efd\u6216\u5bb9\u707e\u6570\u636e\u96c6\u540c\u6b65\u81f3\u5f02\u5730\u9ed1\u65b9 \u670d\u52a1\u5668\u3002\u76ee\u7684\u7aef\u53ea\u9700\u786e\u4fdd\u914d\u7f6e\u57fa \u672c\u4ef6\uff0c\u65e0\u9700\u914d\u7f6e\u8fdc\u7a0b\u590d\u5236\u4ee3\u7406\u3002\u8fdc\u7a0b\u590d\u5236\u4ee3\u7406\u6570\u91cf\u7531\u6e90\u7aef\u7ba1\u7406\u63a7 \u5236\u53f0\u7684\u6570\u91cf\u51b3\u5b9a\u3002\"\n","created_by":1013,"created_at":"2025-02-26 11:00:56","updated_at":"2026-01-23 17:26:34","pinyin_shortcut":"yjzhfrzbfyhfxtrjV6","product_unit":2,"is_renew":false,"in_out_at":"2026-01-23 17:26:34.477698+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":227,"key":227,"name":"\u58f9\u8fdb\u5236"},"productSerie":{"id":1600,"key":1600,"name":"\u58f9\u8fdb\u5236\u9ed1\u65b9\u5bb9\u707e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6 V6.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":2139,"erp_sales_order_id":1635,"erp_store_id":null,"product_id":1942,"description":"","number":"1","outbound":"1","amount":"568521","total_amount":"568521","last_number":"1","last_amount":"568521","last_total_amount":"568521","cost":"250000","total_cost":"250000","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11904,"project_id":3695,"product_id":2227,"amount":"3580","number":9,"cost":"3766.67","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"32220","total_cost":"33900","erp_sales_order_product_id":2140,"supplier":null,"product":{"id":2227,"name":"00Y9087","product_type":2,"product_component":5,"product_brand":4,"product_serie":41,"product_misc":null,"product_qa":null,"pn":"","description":"\u8054\u60f3 00Y9087 4XB7A13911 16TB SAS 3.5\u5bf8","created_by":1013,"created_at":"2026-01-08 10:11:34","updated_at":"2026-01-23 17:26:34","pinyin_shortcut":"00Y9087","product_unit":4,"is_renew":false,"in_out_at":"2026-01-23 17:26:34.477698+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":41,"key":41,"name":"SATA"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":2140,"erp_sales_order_id":1635,"erp_store_id":null,"product_id":2227,"description":"","number":"9","outbound":"9","amount":"3580","total_amount":"32220","last_number":"9","last_amount":"3580","last_total_amount":"32220","cost":"3766.67","total_cost":"33900","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11905,"project_id":3695,"product_id":2226,"amount":"2640","number":1,"cost":"2500","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"2640","total_cost":"2500","erp_sales_order_product_id":2141,"supplier":null,"product":{"id":2226,"name":"\u8054\u60f3RAID\u5361 730-8i-2G\u7f13\u5b58\/\u542b\u7535\u6c60","product_type":2,"product_component":7,"product_brand":4,"product_serie":1755,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2026-01-08 10:03:59","updated_at":"2026-01-23 17:26:34","pinyin_shortcut":"lxRAIDk7308i2Ghchdc","product_unit":3,"is_renew":false,"in_out_at":"2026-01-23 17:26:34.477698+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":7,"key":7,"name":"\u670d\u52a1\u5668\u9635\u5217\u5361"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1755,"key":1755,"name":"RAID\u5361 730-8i-2G"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":2141,"erp_sales_order_id":1635,"erp_store_id":null,"product_id":2226,"description":"","number":"1","outbound":"1","amount":"2640","total_amount":"2640","last_number":"1","last_amount":"2640","last_total_amount":"2640","cost":"2500","total_cost":"2500","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11906,"project_id":3695,"product_id":2225,"amount":"2640","number":1,"cost":"1400","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"2640","total_cost":"1400","erp_sales_order_product_id":2142,"supplier":null,"product":{"id":2225,"name":"Mega RAID SAS 9361-8i 1G\u542b\u6389\u7535\u4fdd\u62a4","product_type":2,"product_component":7,"product_brand":4,"product_serie":1754,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2026-01-08 10:02:49","updated_at":"2026-01-23 17:26:34","pinyin_shortcut":"MegaRAIDSAS93618i1Ghddbh","product_unit":3,"is_renew":false,"in_out_at":"2026-01-23 17:26:34.477698+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":7,"key":7,"name":"\u670d\u52a1\u5668\u9635\u5217\u5361"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1754,"key":1754,"name":"Mega RAID SAS 9361-8i"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":2142,"erp_sales_order_id":1635,"erp_store_id":null,"product_id":2225,"description":"","number":"1","outbound":"1","amount":"2640","total_amount":"2640","last_number":"1","last_amount":"2640","last_total_amount":"2640","cost":"1400","total_cost":"1400","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11907,"project_id":3695,"product_id":2041,"amount":"1539","number":1,"cost":"800","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1539","total_cost":"800","erp_sales_order_product_id":2143,"supplier":null,"product":{"id":2041,"name":"X710-DA2","product_type":2,"product_component":9,"product_brand":5,"product_serie":1658,"product_misc":null,"product_qa":null,"pn":"","description":" intel \u53cc\u53e3\u4e07\u5146\u5149\u7ea4\u7f51\u5361 X710-DA2 10G SFP+\u7f51\u5361\uff08\u542b\u6a21\u5757\uff09","created_by":1013,"created_at":"2025-07-15 13:52:12","updated_at":"2026-01-23 17:26:34","pinyin_shortcut":"X710DA2","product_unit":4,"is_renew":false,"in_out_at":"2026-01-23 17:26:34.477698+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":9,"key":9,"name":"\u670d\u52a1\u5668\u7f51\u5361"},"productBrand":{"id":5,"key":5,"name":"\u82f1\u7279\u5c14"},"productSerie":{"id":1658,"key":1658,"name":"X710-DA2\u53cc\u53e3\u4e07\u5146\u7f51\u5361"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":2143,"erp_sales_order_id":1635,"erp_store_id":null,"product_id":2041,"description":"","number":"1","outbound":"1","amount":"1539","total_amount":"1539","last_number":"1","last_amount":"1539","last_total_amount":"1539","cost":"800","total_cost":"800","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11908,"project_id":3695,"product_id":1923,"amount":"2250","number":6,"cost":"2233","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"13500","total_cost":"13398","erp_sales_order_product_id":2144,"supplier":null,"product":{"id":1923,"name":"32GB PC4-2666P\u5185\u5b58","product_type":2,"product_component":4,"product_brand":10,"product_serie":31,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2025-01-09 10:41:37","updated_at":"2026-01-23 17:26:34","pinyin_shortcut":"32GBPC42666Pnc","product_unit":6,"is_renew":false,"in_out_at":"2026-01-23 17:26:34.477698+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":4,"key":4,"name":"\u670d\u52a1\u5668\u5185\u5b58"},"productBrand":{"id":10,"key":10,"name":"\u4e09\u661f"},"productSerie":{"id":31,"key":31,"name":"DDR4"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":{"id":2144,"erp_sales_order_id":1635,"erp_store_id":null,"product_id":1923,"description":"","number":"6","outbound":"6","amount":"2250","total_amount":"13500","last_number":"6","last_amount":"2250","last_total_amount":"13500","cost":"2233","total_cost":"13398","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11909,"project_id":3695,"product_id":587,"amount":"2650","number":2,"cost":"2000","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"5300","total_cost":"4000","erp_sales_order_product_id":2159,"supplier":null,"product":{"id":587,"name":"4XB7A10154","product_type":2,"product_component":5,"product_brand":4,"product_serie":42,"product_misc":8,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2019-07-22 11:15:57","updated_at":"2026-01-23 17:26:34","pinyin_shortcut":"4XB7A10154","product_unit":4,"is_renew":false,"in_out_at":"2026-01-23 17:26:34.477698+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":42,"key":42,"name":"960G SATA SSD 2.5 \u56fa\u6001\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":2159,"erp_sales_order_id":1635,"erp_store_id":null,"product_id":587,"description":"","number":"2","outbound":"2","amount":"2650","total_amount":"5300","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"2000","total_cost":"4000","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11910,"project_id":3695,"product_id":2228,"amount":"2650","number":2,"cost":"2399","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"5300","total_cost":"4798","erp_sales_order_product_id":2160,"supplier":null,"product":{"id":2228,"name":"XA960LE10016","product_type":2,"product_component":5,"product_brand":21,"product_serie":1756,"product_misc":null,"product_qa":null,"pn":"","description":"\u5e0c\u6377Nytro1361\u7cfb\u5217 960G SATA SSD\u56fa\u6001\u786c\u76d8","created_by":1013,"created_at":"2026-01-08 10:20:33","updated_at":"2026-01-23 17:26:34","pinyin_shortcut":"XA960LE10016","product_unit":4,"is_renew":false,"in_out_at":"2026-01-23 17:26:34.477698+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":21,"key":21,"name":"\u5e0c\u6377"},"productSerie":{"id":1756,"key":1756,"name":"SSD"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":2160,"erp_sales_order_id":1635,"erp_store_id":null,"product_id":2228,"description":"","number":"2","outbound":"2","amount":"2650","total_amount":"5300","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"2399","total_cost":"4798","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3695,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1635,"serial_no":"XSDD-20251207-00002","from_date":null,"wrote_date":"2025-11-30","handler":5087,"client_id":2128,"purchase_contract_id":null,"project_id":3695,"sales_contract_id":4289,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-07 22:24:07","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"23","amount":"631660","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-12-07 22:23:52","updated_at":"2025-12-07 22:24:07","print_times":null},"projectUsedClient":{"id":158,"project_id":3695,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"erpSalesOrderVerify":null,"remain_display":80,"progress_remain_display":80,"forecast_remain_display":80,"projectProductTotalAmount":631660,"projectProductAllAmount":true,"projectProductTotalCost":310796,"projectProductAllCost":true,"projectProductTotalNumber":23,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","can_invoice":true,"can_payment":true,"duration_display":591,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"63.17\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"31583","un_invoiced":0,"object_type":1},{"id":3977,"client_id":2128,"project_status":5,"project_progress":5,"budget":"850000","profit_pct":"47.05","bargain_date":"2025-10-31","description":null,"created_by":5087,"created_at":"2025-09-21 23:53:48","updated_at":"2026-01-23 14:52:07","engineer_id":null,"project_title":"\u5907\u4efd\u7cfb\u7edf\u56fd\u4ea7\u5316\u66ff\u4ee3\u9879\u76ee","collected":"0","status_updated_at":"2025-09-22 00:14:08.836626+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-09-21 23:53:48.930941+08","forecast_updated_at":"2025-09-22 00:14:08.836626+08","end_at":"2025-09-22 00:14:08","pinyin_shortcut":"bfxtgchtdxm","creator":5087,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"399925.000000000000000000","remain":"255 days 10:05:00.50487","progress_remain":"255 days 10:25:20.410555","forecast_remain":"255 days 10:05:00.50487","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"00:20:19.905685","issued_invoices":null,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":6,"client_class":47,"client_industry":20,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"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":20,"key":20,"name":"\u5176\u4ed6"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3977,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7","description":"\u5b9a\u4e49\uff1a1.\u62a5\u4ef7\u6709\u6548\u671f 2.\u6838\u7b97\u5229\u6da6\u7387 3. \u4ea4\u8d27\u65b9\u5f0f\u53ca\u65f6\u95f4 4.\u9a8c\u6536\u65b9\u5f0f 5.\u6536\u6b3e\u65b9\u5f0f 6.\u8fdd\u7ea6\u6761\u6b3e \n\u65b9\u6cd5\uff1a\u7528\u516c\u53f8\u6807\u51c6\u7684\u62a5\u4ef7\u5355\u6837\u5f0f\u5411\u5ba2\u6237\u63d0\u4f9b\u62a5\u4ef7\u3002"},"projectProductTypes":[{"id":69,"product_type_id":69,"key":69,"name":"\u5907\u4efd","budget":"850000","pct":"47.05","profit":"400000","project_id":3977}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"casePoints":{"project_id":3977,"points":"650"},"workLogCount":null,"caseCount":{"project_id":3977,"count":5},"salesTimeCount":null,"implementTimeCount":{"project_id":3977,"sum":"2","times":"1"},"presalesTimeCount":{"project_id":3977,"sum":"4.25","times":"4"},"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3977,"sum":"26.00"},"buildContract":null,"projectRemindReceivers":[{"id":1801,"user_id":1001,"key":1001,"project_id":3977,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"projectProductRels":[],"commentCount":{"object_id":3977,"comment":5},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":{"id":192,"project_id":3977,"used_client":2128,"budget":"850000","profit":"400000","profit_pct":"47","collected_plan":"850000","remind_ahead":null,"usedClient":{"id":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjkjyxgs","description":"","corp_rep":"","website":"","capital":null,"established_at":null,"headcount":"","reg_address":null,"working_address":null,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":20,"client_type":6,"sales_rep":5087,"main_contact":null,"created_by":5087,"created_at":"2021-12-19 21:44:13","updated_at":"2026-05-27 19:24:26","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2021-12-19 21:44:13","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":7,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":3,"case_implement_count":10,"is_overdue_remind":false,"from_contact":null,"tax_no":""},"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[{"id":6,"key":6,"project_used_client_id":192,"remind_date":"2026-10-31","amount":85000,"name":"2026-10-31","value":85000,"overdue_days":null,"pct":10,"collect_status":""},{"id":3,"key":3,"project_used_client_id":192,"remind_date":"2025-11-30","amount":255000,"name":"2025-11-30","value":255000,"overdue_days":null,"pct":30,"collect_status":"\u903e\u671f186\u5929"},{"id":4,"key":4,"project_used_client_id":192,"remind_date":"2025-12-31","amount":255000,"name":"2025-12-31","value":255000,"overdue_days":null,"pct":30,"collect_status":"\u903e\u671f155\u5929"},{"id":5,"key":5,"project_used_client_id":192,"remind_date":"2026-01-31","amount":255000,"name":"2026-01-31","value":255000,"overdue_days":null,"pct":30,"collect_status":"\u903e\u671f124\u5929"}],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":850000,"un_collected":850000,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":850000,"project_used_client_collected_plan_pct":100},"erpSalesOrderVerify":null,"remain_display":255,"progress_remain_display":255,"forecast_remain_display":255,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":850000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_invoice":false,"can_payment":false,"duration_display":1,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"85\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},{"id":3559,"client_id":2128,"project_status":5,"project_progress":10,"budget":"6345580","profit_pct":"6","bargain_date":"2025-07-31","description":null,"created_by":5087,"created_at":"2024-06-03 18:45:31","updated_at":"2025-07-31 13:55:12","engineer_id":null,"project_title":"\u56fe\u5f62\u8bbe\u8ba1\u4e0e\u4eff\u771f\u8ba1\u7b97\u4e00\u4f53\u5316\u5e73\u53f0-K","collected":"0","status_updated_at":"2025-07-14 11:23:32.121951+08","success_rate":null,"comment":"","contract_type":2,"progress_updated_at":"2025-07-13 23:32:18.661229+08","forecast_updated_at":"2025-07-14 11:23:32.121951+08","end_at":"2025-07-14 11:23:32","pinyin_shortcut":"txsjyfzjsythptK","creator":5087,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":true,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"380734.800000000000","remain":"324 days 22:55:37.219545","progress_remain":"325 days 10:46:50.680267","forecast_remain":"324 days 22:55:37.219545","lost_contact_days":"619.501497008055","last_contact":"2024-09-22 22:17:00","last_arrive_days":null,"last_arrive":null,"duration":"405 days 16:38:00.874786","issued_invoices":null,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":6,"client_class":47,"client_industry":20,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"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":20,"key":20,"name":"\u5176\u4ed6"}},"usedClient":null,"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[{"project_id":3559,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"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":"6345580.00","pct":"6","profit":"380734.8","project_id":3559}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"casePoints":{"project_id":3559,"points":"50"},"workLogCount":{"project_id":3559,"count":2},"caseCount":{"project_id":3559,"count":1},"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":{"project_id":3559,"sum":"0.983333333333333","times":"1"},"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3559,"sum":"1607.00"},"buildContract":null,"projectRemindReceivers":[{"id":1630,"user_id":1001,"key":1001,"project_id":3559,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"projectProductRels":[],"commentCount":{"object_id":3559,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":{"id":124,"project_id":3559,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"erpSalesOrderVerify":null,"remain_display":324,"progress_remain_display":325,"forecast_remain_display":324,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":6345580,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_invoice":false,"can_payment":false,"duration_display":405,"contract_type_display":"\u8fd0\u7ef4\u670d\u52a1","can_change_status":true,"is_admin":true,"lost_contact_days_display":"1\u5e74\u524d","can_view_product":true,"budget_display":"634.56\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},{"id":3124,"client_id":2128,"project_status":4,"project_progress":3,"budget":"0","profit_pct":"0","bargain_date":"2023-06-30","description":"1.\u81ea\u4e3b\u53ef\u63a7\u670d\u52a1\u533a\u865a\u62dfX86\u7684\u5e94\u7528\uff0c\u7136\u540e\u901a\u8fc7BS\u67b6\u6784\u53d1\u5e03\u51fa\u6765\uff0c\u8ba9\u81ea\u4e3b\u53ef\u63a7\u7ec8\u7aef\u80fd\u7528\uff0c2.\u5728\u6cb8\u817e+\u9e92\u9e9f\u4e0a\u865a\u51faX86\u6700\u540e\u7684\u76ee\u7684\u662f\uff0c\u540e\u53f0\u662f\u81ea\u4e3b\u53ef\u63a7\u8d70\u8def\u7531\u5668\u524d\u7aef\u4e5f\u662f\u81ea\u4e3b\u53ef\u63a7\u7ec8\u7aef\u7136\u540e\u80fd\u7528X86\u7684\u5e94\u7528\u3002","created_by":5087,"created_at":"2023-02-27 02:26:17","updated_at":"2023-03-05 22:19:48","engineer_id":null,"project_title":"\u81ea\u4e3b\u53ef\u63a7\u5e94\u7528","collected":"0","status_updated_at":"2023-03-05 22:19:48.442532+08","success_rate":null,"comment":"1.\u81ea\u4e3b\u53ef\u63a7\u670d\u52a1\u533a\u865a\u62dfX86\u7684\u5e94\u7528\uff0c\u7136\u540e\u901a\u8fc7BS\u67b6\u6784\u53d1\u5e03\u51fa\u6765\uff0c\u8ba9\u81ea\u4e3b\u53ef\u63a7\u7ec8\u7aef\u80fd\u7528\uff0c2.\u5728\u6cb8\u817e+\u9e92\u9e9f\u4e0a\u865a\u51faX86\u6700\u540e\u7684\u76ee\u7684\u662f\uff0c\u540e\u53f0\u662f\u81ea\u4e3b\u53ef\u63a7\u8d70\u8def\u7531\u5668\u524d\u7aef\u4e5f\u662f\u81ea\u4e3b\u53ef\u63a7\u7ec8\u7aef\u7136\u540e\u80fd\u7528X86\u7684\u5e94\u7528\u3002\r\n","contract_type":1,"progress_updated_at":"2023-02-27 02:26:17.442213+08","forecast_updated_at":"2023-03-05 22:19:48.442532+08","end_at":"2023-03-05 22:19:48","pinyin_shortcut":"zzkkyy","creator":5087,"used_client":2128,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"0.00000000000000000000","remain":"1186 days 11:59:20.898964","progress_remain":"1193 days 07:52:51.899283","forecast_remain":"1186 days 11:59:20.898964","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"6 days 19:53:31.000319","issued_invoices":null,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":6,"client_class":47,"client_industry":20,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"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":20,"key":20,"name":"\u5176\u4ed6"}},"usedClient":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"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":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":[],"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":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":3124,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":{"id":89,"project_id":3124,"used_client":2128,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":{"id":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjkjyxgs","description":"","corp_rep":"","website":"","capital":null,"established_at":null,"headcount":"","reg_address":null,"working_address":null,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":20,"client_type":6,"sales_rep":5087,"main_contact":null,"created_by":5087,"created_at":"2021-12-19 21:44:13","updated_at":"2026-05-27 19:24:26","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2021-12-19 21:44:13","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":7,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":3,"case_implement_count":10,"is_overdue_remind":false,"from_contact":null,"tax_no":""},"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"erpSalesOrderVerify":null,"remain_display":1186,"progress_remain_display":1193,"forecast_remain_display":1186,"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":null,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_invoice":false,"can_payment":false,"duration_display":6,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"0","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},{"id":3132,"client_id":2128,"project_status":4,"project_progress":3,"budget":"400000","profit_pct":"20","bargain_date":"2023-05-31","description":"\u66f4\u6362\u5b9e\u9a8c\u7f51\u6838\u5fc3\u4ea4\u6362\u673a","created_by":5087,"created_at":"2023-03-05 22:28:24","updated_at":"2023-03-06 17:37:34","engineer_id":null,"project_title":"\u5b9e\u9a8c\u7f51\u4ea4\u6362\u673a\u91c7\u8d2d","collected":"0","status_updated_at":"2023-03-06 17:37:34.925797+08","success_rate":null,"comment":"\u66f4\u6362\u5b9e\u9a8c\u7f51\u6838\u5fc3\u4ea4\u6362\u673a\r\n","contract_type":1,"progress_updated_at":"2023-03-05 22:29:22.342551+08","forecast_updated_at":"2023-03-06 17:37:34.925797+08","end_at":"2023-03-06 17:37:34","pinyin_shortcut":"sywjhjcg","creator":5087,"used_client":2128,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"80000.0000000000000000","remain":"1185 days 16:41:34.415699","progress_remain":"1186 days 11:49:46.998945","forecast_remain":"1185 days 16:41:34.415699","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"19:09:10.494573","issued_invoices":null,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":6,"client_class":47,"client_industry":20,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"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":20,"key":20,"name":"\u5176\u4ed6"}},"usedClient":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"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":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":85,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"400000.00","pct":"20","profit":"80000","project_id":3132}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355","description":"\u4fdd\u63015%\u57fa\u672c\u5229\u6da6\u7387\uff0c\u5e2e\u52a9\u5382\u5546\u4ea4\u4ed8\u9879\u76ee\u3002"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":3132,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":{"id":35,"project_id":3132,"used_client":2128,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":{"id":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjkjyxgs","description":"","corp_rep":"","website":"","capital":null,"established_at":null,"headcount":"","reg_address":null,"working_address":null,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":20,"client_type":6,"sales_rep":5087,"main_contact":null,"created_by":5087,"created_at":"2021-12-19 21:44:13","updated_at":"2026-05-27 19:24:26","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2021-12-19 21:44:13","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":7,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":3,"case_implement_count":10,"is_overdue_remind":false,"from_contact":null,"tax_no":""},"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"erpSalesOrderVerify":null,"remain_display":1185,"progress_remain_display":1186,"forecast_remain_display":1185,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":400000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_invoice":false,"can_payment":false,"duration_display":1,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"40\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}],"pagenation":{"totalcount":17,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"223.104.42.221","ua":"jinchangxiao\/2.3.156 (iPhone 12; iOS 26.5; Scale\/3.00)"}', FALSE, '2026-06-04 10:19:09', 523552256) RETURNING "id" |