68c3d91d9c48e: POST https://beta.jinchangxiao.com/v2/project/list at 2025-09-12 04:26:05 pm by 114.246.237.213
Log Messages
总计119条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 16:26:05.639 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 16:26:05.639 | trace | yii\base\Module::getModule | Loading module: debug |
| 16:26:05.640 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 16:26:05.640 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 16:26:05.640 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 16:26:05.640 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:26:05.640 | trace | yii\base\Module::getModule | Loading module: gii |
| 16:26:05.640 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 16:26:05.641 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 16:26:05.641 | trace | yii\web\Application::handleRequest | Route requested: 'v2/project/list' |
| 16:26:05.641 | trace | yii\base\Module::getModule | Loading module: v2 |
| 16:26:05.641 | info | yii\web\Session::open | Session started |
| 16:26:05.642 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 16:26:05.645 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='aHkemdL-FzzGDDN3FUg-tUfVIXoO8gyc' |
| 16:26:05.649 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:26:05.649 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:26:05.649 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:26:05.650 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:26:05.650 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:26:05.652 | trace | yii\base\Controller::runAction | Route to run: v2/project/list |
| 16:26:05.652 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:26:05.654 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 16:26:05.654 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\ProjectController::actionList() |
| 16:26:05.654 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:26:05.654 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:26:05.655 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:26:05.656 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:26:05.658 | 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 (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("c"."sales_rep"='1001') GROUP BY "p"."id" ORDER BY "p"."updated_at" DESC) "c" |
| 16:26:05.687 | 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 (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("c"."sales_rep"='1001') GROUP BY "p"."id" ORDER BY "p"."updated_at" DESC LIMIT 10 |
| 16:26:05.702 | 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" IN (1661, 3389, 3278, 3286, 2545, 3372, 2845) |
| 16:26:05.703 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:26:05.703 | 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) |
| 16:26:05.704 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id"=5 |
| 16:26:05.704 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=43 |
| 16:26:05.705 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id" IN (13, 10, 18) |
| 16:26:05.706 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id"=1 |
| 16:26:05.706 | 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 (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760) ORDER BY "contribution" DESC, "engineer_id" |
| 16:26:05.707 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:26:05.708 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:26:05.708 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (3, 2) |
| 16:26:05.709 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (49, 6, 2, 9) |
| 16:26:05.710 | 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 (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760) |
| 16:26:05.711 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760) |
| 16:26:05.712 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (184, 189, 136, 139, 165, 167, 166, 226, 2, 5, 215, 1, 142, 185, 192, 197, 199, 191, 348, 2100000000, 232, 349, 369, 377, 340, 356, 172, 181, 129)) ORDER BY "sort" |
| 16:26:05.713 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760) |
| 16:26:05.714 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (184, 189, 136, 139, 165, 167, 166, 226, 2, 5, 215, 1, 142, 185, 192, 197, 199, 191, 348, 2100000000, 232, 349, 369, 377, 340, 356, 172, 181, 129)) ORDER BY "sort" |
| 16:26:05.715 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760) |
| 16:26:05.715 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (184, 189, 136, 139, 165, 167, 166, 226, 2, 5, 215, 1, 142, 185, 192, 197, 199, 191, 348, 2100000000, 232, 349, 369, 377, 340, 356, 172, 181, 129)) ORDER BY "sort" |
| 16:26:05.716 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:26:05.716 | 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) |
| 16:26:05.717 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4 |
| 16:26:05.717 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1011, 1000) |
| 16:26:05.718 | 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 (1011, 1001, 1000)) |
| 16:26:05.718 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (1661, 3389, 3278, 3286, 2545, 3372, 2845) |
| 16:26:05.720 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:26:05.720 | 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) |
| 16:26:05.720 | 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 (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760) GROUP BY "c"."project_id" |
| 16:26:05.729 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:26:05.729 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:26:05.730 | 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 (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760)) GROUP BY "project_id" |
| 16:26:05.730 | info | yii\db\Command::query | SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760) GROUP BY "project_id" |
| 16:26:05.731 | 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 (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760)) GROUP BY "project_id" |
| 16:26:05.732 | 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 (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760)) GROUP BY "c"."project_id" |
| 16:26:05.738 | 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 (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760)) GROUP BY "c"."project_id" |
| 16:26:05.739 | 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 (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760)) GROUP BY "project_id" |
| 16:26:05.740 | 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 (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760)) GROUP BY "project_id" |
| 16:26:05.741 | 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 (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760) |
| 16:26:05.743 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (3364, 3746, 3967, 3978, 1558, 4106, 4131, 4112, 4140)) |
| 16:26:05.745 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (5271, 19980, 23648, 26100, 26337, 27658, 27758, 27759, 28121) |
| 16:26:05.748 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (3364, 3746, 3967, 3978, 1558, 4106, 4131, 4112, 4140)) |
| 16:26:05.750 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (5320, 20715, 23714, 26404, 26612) |
| 16:26:05.751 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (3364, 3746, 3967, 3978, 1558, 4106, 4131, 4112, 4140)) |
| 16:26:05.753 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE ("status"=2) AND ("sales_contract_id" IN (3364, 3746, 3967, 3978, 1558, 4106, 4131, 4112, 4140)) ORDER BY "id" DESC |
| 16:26:05.754 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) )) "sub") "r" WHERE "contract_id" IN (3364, 3746, 3967, 3978, 1558, 4106, 4131, 4112, 4140) ORDER BY "id" DESC |
| 16:26:05.757 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 1001) |
| 16:26:05.757 | 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" IN (3364, 3746, 3967, 3978, 1558, 4106, 4131, 4112, 4140) ORDER BY "id" |
| 16:26:05.758 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=5400 |
| 16:26:05.758 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (3364, 3746, 3967, 3978, 1558, 4106, 4131, 4112, 4140) ORDER BY "remind_date" |
| 16:26:05.759 | 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" IN (3364, 3746, 3967, 3978, 1558, 4106, 4131, 4112, 4140) |
| 16:26:05.760 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5388, 1001, 1011) |
| 16:26:05.760 | 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 (1011, 1001, 5388)) |
| 16:26:05.760 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (3364, 3746, 3967, 3978, 1558, 4106, 4131, 4112, 4140) |
| 16:26:05.761 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (365, 678, 38, 90, 236, 708, 478, 431) |
| 16:26:05.764 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (1559, 3747, 3773, 3365, 3969, 3982, 3987, 4118, 4103, 4122, 4133, 4141) |
| 16:26:05.764 | 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 (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760) |
| 16:26:05.765 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:26:05.765 | 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) |
| 16:26:05.766 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760) |
| 16:26:05.767 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (90, 678, 236, 708) |
| 16:26:05.767 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (2108, 969, 1586, 1657, 498, 1923, 1104, 1372, 1997, 1999, 2000, 1190, 1191, 2008, 2009, 1874, 1639, 1640, 2095, 1624, 1040) |
| 16:26:05.775 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (2, 5, 4, 7, 3) |
| 16:26:05.776 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (49, 5, 214, 7, 19, 43, 35, 188, 36, 26, 4, 2, 39, 191, 14, 32) |
| 16:26:05.776 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (4, 8, 54, 12, 10, 24, 134, 27, 137) |
| 16:26:05.777 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1630, 42, 1694, 1632, 1395, 386, 1359, 743, 1640, 1243, 103, 104, 607, 31, 315, 666, 741, 1047, 1691, 1382, 633) |
| 16:26:05.780 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (3, 2, 1, 6) |
| 16:26:05.781 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (1855, 969, 970, 971, 1484, 1485, 1486, 1487, 1709, 1710, 1711, 1713, 1714, 1715, 1716, 1717, 1718, 1719, 1874, 1860, 1875, 1861, 1878) |
| 16:26:05.784 | info | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760)) GROUP BY "object_id" |
| 16:26:05.804 | info | yii\db\Command::query | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=1) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760)) GROUP BY "object_id" |
| 16:26:05.822 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (5912, 1262, 5957, 4640, 5980) |
| 16:26:05.826 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (1262, 4640, 5912, 5957, 5980) |
| 16:26:05.827 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2545 |
| 16:26:05.828 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (100, 511, 90) |
| 16:26:05.829 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760) |
| 16:26:05.830 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (1262, 4640) |
| 16:26:05.832 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2545 |
| 16:26:05.832 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=100 |
| 16:26:05.833 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((1262, 3577), (4640, 3760), (4640, 3886), (4640, 3890)) |
| 16:26:05.836 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760)) |
| 16:26:05.838 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id" IN (1791, 3950, 3959, 3958, 3577, 3927, 3886, 3890, 3949, 3760) |
| 16:26:05.839 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id" IN (132, 177, 180, 184) |
| 16:26:05.839 | 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 (132, 177, 180, 184) |
| 16:26:05.840 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id" IN (132, 177, 180, 184) |
| 16:26:05.840 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id" IN (132, 177, 180, 184) |
| 16:26:05.841 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: viewProduct |
| 16:26:05.841 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: StoreKeeper |
| 16:26:05.841 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 16:26:05.845 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:26:05.845 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:26:05.846 | 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") VALUES (200, 'a57be577deb434', 1001, 0, 266, 'v2/project/list', '{"access_token":"aHkemdL-FzzGDDN3FUg-tUfVIXoO8gyc","ProjectSearch":{"created_by":"1001"},"device_type":"0","version_code":"266","page":"1","token":"3987fecc9b65cc09bdda0de94b4839c3","posttime":"1757665565","pagesize":"10"}', '{"code":200,"data":{"list":[{"id":1791,"client_id":1661,"project_status":3,"project_progress":49,"budget":"514761.00","profit_pct":"0.56","bargain_date":"2020-06-03","description":"1\u53f05500VX-HW\u8bbe\u5907","created_by":1001,"created_at":"2020-06-23 16:32:19","updated_at":"2025-09-12 16:21:37","engineer_id":null,"project_title":"\u706b\u773c5500VX\u91c7\u8d2d\u9879\u76ee","collected":"514761","status_updated_at":"2020-08-10 17:52:12.720678+08","success_rate":null,"comment":"1\u53f05500VX-HW\u8bbe\u5907\r\n1.\n2.\n3.\n","contract_type":1,"progress_updated_at":"2025-09-10 15:43:58.295057+08","forecast_updated_at":"2025-09-10 15:43:44.87371+08","end_at":"2021-04-19 22:25:38","pinyin_shortcut":"hy5500VXcgxm","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":514761,"change_status_to":null,"is_verify":false,"profits":"2882.661600000000000000","remain":"1858 days 22:33:52.968843","progress_remain":"2 days 00:42:07.394464","forecast_remain":"2 days 00:42:20.815811","lost_contact_days":"0.105621406493056","last_contact":"2025-09-12 13:54:00","last_arrive_days":"0.105621406493056","last_arrive":"2025-09-12 13:54:00+08","duration":"300 days 05:53:19.020575","issued_invoices":"514761.00","client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":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":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"514761.00","pct":"0.56","profit":"2882.6616","project_id":1791}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":{"id":167,"key":167,"name":"\u5382\u5546\u4ecb\u7ecd"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"casePoints":null,"workLogCount":{"project_id":1791,"count":5},"caseCount":null,"salesTimeCount":{"project_id":1791,"hours":"0.02","times":3},"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":{"project_id":1791,"hours":"0","times":1},"reimbursementAmountSum":{"project_id":1791,"sum":"633.76"},"buildContract":{"id":1558,"from_project":1791,"payment_collection_remind_ahead":"1 day","serial_no":"TSKJ20200602-HYF-004","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"514761","erp_un_settle_amount":"0","including_tax":true,"amount":"514761.00","contractScans":[{"id":12313,"object_type":105,"object_id":1558,"attachment_id":5271,"attachment":{"id":5271,"key":5271,"name":"1727e634-855f-3aa3-86ce-f19c5df0e9dd","extension":"pdf","path":"\/v2\/attachment\/preview\/aHkemdL-FzzGDDN3FUg-tUfVIXoO8gyc\/1727e634-855f-3aa3-86ce-f19c5df0e9dd\/2020_06_29_09_03_56.pdf","orig_name":"2020_06_29_09_03_56.pdf"}}],"receiptScans":[{"id":13085,"object_type":106,"object_id":1558,"attachment_id":5320,"attachment":{"id":5320,"key":5320,"name":"b0db54c2-4b7d-3b26-b333-1bcd84fc2666","extension":"pdf","path":"\/v2\/attachment\/preview\/aHkemdL-FzzGDDN3FUg-tUfVIXoO8gyc\/b0db54c2-4b7d-3b26-b333-1bcd84fc2666\/\u626b\u63cf\u5168\u80fd\u738b 2020-07-08 14.11.10.pdf","orig_name":"\u626b\u63cf\u5168\u80fd\u738b 2020-07-08 14.11.10.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":423,"serial_no":"SKD-19700101-00001","wrote_date":null,"from_date":null,"handler":1001,"user_id":null,"client_id":1661,"sales_contract_id":1558,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2020-06-23 16:32:19","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"514761.00","settle_amount":"514761.00","created_by":null,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2020-06-23 16:32:19","updated_at":"2020-06-23 16:32:19","paid_amount":null,"contact_id":null}],"salesContractPayments":[{"id":"1423","key":"1423","contract_id":1558,"value":"514761.00","created_by":null,"createdBy":null,"pct":100}],"salesContractInvoices":[{"id":854,"key":854,"contract_id":1558,"value":"514761.00","attachment_id":5400,"from_date":"2020-07-15","attachment":{"id":5400,"key":5400,"name":"b0be27a4-0269-36ec-99ed-ef2ca596d429","extension":"pdf","path":"\/v2\/attachment\/preview\/aHkemdL-FzzGDDN3FUg-tUfVIXoO8gyc\/b0be27a4-0269-36ec-99ed-ef2ca596d429\/2020_07_15_11_35_57.pdf","orig_name":"2020_07_15_11_35_57.pdf"}}],"salesContractPaymentCollectionRemindDates":[{"id":550,"key":550,"contract_id":1558,"name":"2020-08-11","value":"514761.00","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":1252,"user_id":1001,"key":1001,"contract_id":1558,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"id":1253,"user_id":1011,"key":1011,"contract_id":1558,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}],"salesSupplierRels":[{"id":635,"contract_id":1558,"supplier_id":365,"purchase_id":1559,"supplier":{"id":365,"key":365,"name":"\u5317\u4eac\u767e\u8fbe\u4fe1\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":1559,"key":1559,"serial_no":"TSKJ20200603-HYF-002"}},{"id":3207,"contract_id":1558,"supplier_id":431,"purchase_id":4141,"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchase":{"id":4141,"key":4141,"serial_no":"\u800c\u7279\u70ed\u821e"}}],"payment_collection_remind_ahead_display":"1\u5929","invoiced":514761},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":1791,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":584,"serial_no":"XSDD-20210419-00001","from_date":null,"wrote_date":"2020-06-03","handler":5015,"client_id":1661,"purchase_contract_id":null,"project_id":1791,"sales_contract_id":1558,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u5b89\u5168 ","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2021-04-19 22:25:38","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"514761","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2020-06-23 16:32:19","updated_at":"2021-04-19 22:25:38"},"projectUsedClient":null,"remain_display":1858,"progress_remain_display":2,"forecast_remain_display":2,"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":"2\u5c0f\u65f6\u524d","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":300,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"2\u5c0f\u65f6\u524d","can_view_product":true,"budget_display":"51.48\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":"0","un_invoiced":0},{"id":3950,"client_id":3389,"project_status":3,"project_progress":6,"budget":"80000","profit_pct":"96.25","bargain_date":"2025-08-21","description":null,"created_by":1001,"created_at":"2025-08-21 12:26:55","updated_at":"2025-09-12 10:08:49","engineer_id":null,"project_title":"\u6d4b-\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355\uff1a\u6df1\u4fe1\u670d\u9632\u706b\u5899AF-1000-FH2300B","collected":"80000","status_updated_at":"2025-09-03 15:40:10.300517+08","success_rate":null,"comment":"\u6d4b\u8bd5\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355","contract_type":1,"progress_updated_at":"2025-08-21 12:26:55.466653+08","forecast_updated_at":"2025-08-21 12:26:55.466653+08","end_at":"2025-09-04 09:21:06","pinyin_shortcut":"cxsyjftdsxffhqAF1000FH2300B","creator":1011,"used_client":null,"from_contact":5912,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":1009,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":true,"profits":"77000.000000000000000000","remain":"9 days 00:45:55.389004","progress_remain":"22 days 03:59:10.222868","forecast_remain":"22 days 03:59:10.222868","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"13 days 20:54:11.184413","issued_invoices":null,"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":18,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":18,"key":18,"name":"\u5a92\u4f53"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"80000","pct":"96.25","profit":"77000","project_id":3950}],"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":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4131,"from_project":3950,"payment_collection_remind_ahead":"1 day","serial_no":"2025-09-03-001","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"80000","erp_un_settle_amount":"0","including_tax":true,"amount":"80000","contractScans":[],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[{"id":"12021","key":"12021","contract_id":4131,"value":"80000","created_by":1001,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":100}],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8889,"user_id":1001,"key":1001,"contract_id":4131,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"1\u5929","invoiced":0},"projectRemindReceivers":[],"projectProductRels":[{"id":10725,"project_id":3950,"product_id":2095,"amount":"26666.66","number":3,"cost":"1000","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"80000.00","total_cost":"3000.00","erp_sales_order_product_id":1874,"supplier":null,"product":{"id":2095,"name":"SA3610","product_type":3,"product_component":14,"product_brand":27,"product_serie":1691,"product_misc":null,"product_qa":null,"pn":"","description":"2U\u673a\u67b6\u5f0f12 \u69fd\u673a\u67b6\u5f0f\u670d\u52a1\u5668\uff0cCPU\uff1aIntel\u00ae Xeon\u00ae D-1567\uff1b\u5185\u5b58\uff1a16 GB DDR4 ECC RDIMM\uff08\u53ef\u6269\u5145\u81f3 128 GB\uff09\uff1b12 x 3.5 \u82f1\u5bf8 Synology SAS\/SATA HDD\u30012.5 \u82f1\u5bf8 Synology SATA SSD \u6216 2.5 \u82f1\u5bf8 SAS SSD\uff08\u4e0d\u542b\u786c\u76d8\uff09\uff1b\u652f\u6301\u70ed\u63d2\u62d4\u786c\u76d8\uff1b2 x USB 3.2 \u7b2c 1 \u4ee3\u7aef\u53e3\u548c1 x \u6269\u5145\u7aef\u53e3 (Mini-SAS HD)\uff1b5\u5e74\u4fdd\u4fee\u3002","created_by":1013,"created_at":"2025-08-14 09:06:15","updated_at":"2025-09-04 11:02:52","pinyin_shortcut":"SA3610","product_unit":1,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":14,"key":14,"name":"\u5b58\u50a8\u4e3b\u673a"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1691,"key":1691,"name":"SA3610 NAS\u5b58\u50a8\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1874,"erp_sales_order_id":1576,"erp_store_id":null,"product_id":2095,"description":"","number":"3","outbound":"2","amount":"26666.66","total_amount":"80000.00","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"1000","total_cost":"3000.00","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3950,"comment":3},"unreadComments":null,"fromContact":{"id":5912,"key":5912,"name":"\u97e9\u5f66\u5e73","client_id":null,"supplier_id":511,"mobiles":[],"client":null,"supplier":{"id":511,"key":511,"name":"\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"}},"projectContactPoints":[],"erpSalesOrder":{"id":1576,"serial_no":"XSDD-20250903-00001","from_date":null,"wrote_date":"2025-08-21","handler":1001,"client_id":3389,"purchase_contract_id":null,"project_id":3950,"sales_contract_id":4131,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-09-03 15:41:50","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"3","amount":"80000","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-09-03 15:40:10","updated_at":"2025-09-03 15:41:50"},"projectUsedClient":{"id":184,"project_id":3950,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"remain_display":9,"progress_remain_display":22,"forecast_remain_display":22,"projectProductTotalAmount":80000,"projectProductAllAmount":true,"projectProductTotalCost":3000,"projectProductAllCost":true,"projectProductTotalNumber":3,"unissued_invoice":80000,"is_exceeded":false,"can_update":false,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":13,"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":"8\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":3,"un_collected":"0","un_invoiced":80000},{"id":3959,"client_id":1661,"project_status":3,"project_progress":2,"budget":"788888","profit_pct":"99.98","bargain_date":"2025-09-11","description":"","created_by":1001,"created_at":"2025-09-11 10:48:23","updated_at":"2025-09-11 15:05:12","engineer_id":null,"project_title":"\u5409\u5fb7\u79d1\u5a03","collected":"0","status_updated_at":"2025-09-11 10:49:29.797789+08","success_rate":null,"comment":"\u91d1\u5a1c\u5a1c","contract_type":1,"progress_updated_at":"2025-09-11 10:48:23.373331+08","forecast_updated_at":"2025-09-11 10:48:23.373331+08","end_at":"","pinyin_shortcut":"jdkw","creator":1000,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":1014,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"788730.222400000000000000","remain":"1 day 05:36:35.891732","progress_remain":"1 day 05:37:42.31619","forecast_remain":"1 day 05:37:42.31619","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"1 day 05:37:42.31619","issued_invoices":null,"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3959,"value":"0.5","key":1022,"name":"\u5f90\u7855"},{"project_id":3959,"value":"0.5","key":1023,"name":"\u5468\u5b50\u5065"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"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":7,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"788888","pct":"99.98","profit":"788799","project_id":3959}],"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":129,"key":129,"name":"\u7279\u7ea6\u9080\u6807"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4140,"from_project":3959,"payment_collection_remind_ahead":"00:00:00","serial_no":"2025-09-11-001","is_settle":false,"is_deliver":false,"is_outbound":true,"erp_settle_amount":"0","erp_un_settle_amount":"788888","including_tax":true,"amount":"788888","contractScans":[{"id":49514,"object_type":105,"object_id":4140,"attachment_id":28121,"attachment":{"id":28121,"key":28121,"name":"491d3f89-894f-3cf5-abf2-361d6f604b0e","extension":"png","path":"\/v2\/attachment\/preview\/aHkemdL-FzzGDDN3FUg-tUfVIXoO8gyc\/491d3f89-894f-3cf5-abf2-361d6f604b0e\/\u56fe\u7247.png","orig_name":"\u56fe\u7247.png"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"\u4e0d\u63d0\u9192","invoiced":0},"projectRemindReceivers":[],"projectProductRels":[{"id":10736,"project_id":3959,"product_id":1040,"amount":"788888.00","number":1,"cost":"89","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"788888","total_cost":"89.00","erp_sales_order_product_id":1878,"supplier":null,"product":{"id":1040,"name":"\u5b81\u76fe\u4ee4\u724c\u8f6f\u4ef6V1.0","product_type":7,"product_component":32,"product_brand":137,"product_serie":633,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-09-25 16:31:25","updated_at":"2025-09-12 15:58:12","pinyin_shortcut":"ndlprjV10","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":32,"key":32,"name":"\u9632\u75c5\u6bd2\u8f6f\u4ef6"},"productBrand":{"id":137,"key":137,"name":"\u5b81\u76fe"},"productSerie":{"id":633,"key":633,"name":"\u4ee4\u724c"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1878,"erp_sales_order_id":1586,"erp_store_id":null,"product_id":1040,"description":"","number":"1","outbound":"1","amount":"788888.00","total_amount":"788888","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"89","total_cost":"89.00","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3959,"comment":4},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1586,"serial_no":"XSDD-20250911-00001","from_date":null,"wrote_date":"2025-09-11","handler":1001,"client_id":1661,"purchase_contract_id":null,"project_id":3959,"sales_contract_id":4140,"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-09-11 15:03:36","stop_at":"2025-09-11 15:04:20.586248+08","cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"788888","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":null,\"salesContractPaymentCollectionRemindReceivers\":null,\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-09-11 10:49:29","updated_at":"2025-09-11 15:04:57"},"projectUsedClient":null,"remain_display":1,"progress_remain_display":1,"forecast_remain_display":1,"projectProductTotalAmount":788888,"projectProductAllAmount":true,"projectProductTotalCost":89,"projectProductAllCost":true,"projectProductTotalNumber":1,"unissued_invoice":788888,"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":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":"78.89\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":"788888","un_invoiced":788888},{"id":3958,"client_id":1661,"project_status":2,"project_progress":2,"budget":"10000","profit_pct":"12","bargain_date":"2025-11-01","description":"","created_by":1001,"created_at":"2025-09-10 15:45:44","updated_at":"2025-09-10 16:16:07","engineer_id":null,"project_title":"\u6770\u592b\u54c8\u8fea\u5bb6","collected":"0","status_updated_at":"2025-09-10 16:16:07.63847+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-09-10 15:45:44.512754+08","forecast_updated_at":"2025-09-10 15:45:44.512754+08","end_at":"","pinyin_shortcut":"jfhdj","creator":1000,"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":"1200.0000000000000000","remain":"2 days 00:09:58.051051","progress_remain":"2 days 00:40:21.176767","forecast_remain":"2 days 00:40:21.176767","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"2 days 00:40:21.176767","issued_invoices":null,"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3958,"value":"1","key":1023,"name":"\u5468\u5b50\u5065"}],"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":"10000.00","pct":"12","profit":"1200","project_id":3958}],"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":129,"key":129,"name":"\u7279\u7ea6\u9080\u6807"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":3958,"comment":2},"unreadComments":{"object_id":3958,"unread":1},"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"remain_display":2,"progress_remain_display":2,"forecast_remain_display":2,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":10000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":1,"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":2,"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":"10000","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":0,"un_invoiced":0},{"id":3577,"client_id":3278,"project_status":3,"project_progress":9,"budget":"198354","profit_pct":"-0.71","bargain_date":"2024-06-25","description":"","created_by":1001,"created_at":"2024-06-26 10:50:35","updated_at":"2025-09-05 11:16:23","engineer_id":null,"project_title":"PA1410\u9632\u706b\u58992\u5957\u65b0\u8d2d\u9879\u76ee","collected":"198354","status_updated_at":"2024-06-26 10:50:35.474112+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-06-26 10:50:35.474112+08","forecast_updated_at":"2024-06-26 10:50:35.474112+08","end_at":"2024-09-24 13:35:40","pinyin_shortcut":"PA1410fhq2txgxm","creator":1001,"used_client":null,"from_contact":1262,"total_contact_point":"26476","paid_contact_point":"26476","project_product_version_id":523,"is_sales_order_ready":true,"collected_plan":198354,"change_status_to":null,"is_verify":false,"profits":"-1408.313400000000000000","remain":"443 days 05:35:30.215409","progress_remain":"443 days 05:35:30.215409","forecast_remain":"443 days 05:35:30.215409","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"90 days 02:45:04.663669","issued_invoices":"198354.00","client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"198354.00","pct":"-0.71","profit":"-1408.3134","project_id":3577}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355","description":"\u4fdd\u63015%\u57fa\u672c\u5229\u6da6\u7387\uff0c\u5e2e\u52a9\u5382\u5546\u4ea4\u4ed8\u9879\u76ee\u3002"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3364,"from_project":3577,"payment_collection_remind_ahead":"7 days","serial_no":"TS-HYF-2024062501","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"198354","erp_un_settle_amount":"0","including_tax":true,"amount":"198354","contractScans":[{"id":31070,"object_type":105,"object_id":3364,"attachment_id":19980,"attachment":{"id":19980,"key":19980,"name":"3f4fb0c6-72d6-34ed-ade6-f90f9c306016","extension":"pdf","path":"\/v2\/attachment\/preview\/aHkemdL-FzzGDDN3FUg-tUfVIXoO8gyc\/3f4fb0c6-72d6-34ed-ade6-f90f9c306016\/\u521b\u5b89\u5149\u901a.pdf","orig_name":"\u521b\u5b89\u5149\u901a.pdf"}}],"receiptScans":[{"id":27594,"object_type":106,"object_id":3364,"attachment_id":20715,"attachment":{"id":20715,"key":20715,"name":"4626bfd6-f39b-38de-bc6e-d57b6a614c1b","extension":"jpeg","path":"\/v2\/attachment\/preview\/aHkemdL-FzzGDDN3FUg-tUfVIXoO8gyc\/4626bfd6-f39b-38de-bc6e-d57b6a614c1b\/WechatIMG180.jpeg","orig_name":"WechatIMG180.jpeg"}}],"verifyScans":[],"erpCollectTickets":[{"id":115,"serial_no":"SKD-20240924-00002","wrote_date":"2024-09-24","from_date":null,"handler":1001,"user_id":null,"client_id":3278,"sales_contract_id":3364,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2024-09-24 13:35:39","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"198354","settle_amount":"198354","created_by":1013,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2024-09-24 13:35:39","updated_at":"2024-09-24 13:35:39","paid_amount":null,"contact_id":null}],"salesContractPayments":[{"id":"1115","key":"1115","contract_id":3364,"value":"198354","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1740,"key":1740,"contract_id":3364,"value":"198354.00","attachment_id":null,"from_date":"2024-08-05","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2010,"key":2010,"contract_id":3364,"name":"2024-09-19","value":"198354","overdue_days":5,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":7324,"user_id":5388,"key":5388,"contract_id":3364,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7325,"user_id":1001,"key":1001,"contract_id":3364,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesSupplierRels":[{"id":2199,"contract_id":3364,"supplier_id":90,"purchase_id":3365,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3365,"key":3365,"serial_no":"X_2024SBQ15876"}},{"id":3205,"contract_id":3364,"supplier_id":431,"purchase_id":4133,"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchase":{"id":4133,"key":4133,"serial_no":"\u65b9\u5f0f\u5730\u65b9\u662f"}}],"payment_collection_remind_ahead_display":"7\u5929","invoiced":198354},"projectRemindReceivers":[{"id":1091,"user_id":1001,"key":1001,"project_id":3577,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"projectProductRels":[{"id":7951,"project_id":3577,"product_id":969,"amount":"47830","number":2,"cost":"35000","description":"","supplier_id":90,"hardware_from":"2025-07-31","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-31","software_to":null,"maintenance_to":null,"total_amount":"95660","total_cost":"70000","erp_sales_order_product_id":969,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":969,"name":"PAN-PA-1410","product_type":5,"product_component":26,"product_brand":8,"product_serie":607,"product_misc":null,"product_qa":null,"pn":"","description":"Palo Alto Networks PA-1410","created_by":1013,"created_at":"2023-08-04 15:49:28","updated_at":"2024-01-12 15:43:25","pinyin_shortcut":"PANPA1410","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":607,"key":607,"name":"PA-1410\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":969,"erp_sales_order_id":1271,"erp_store_id":null,"product_id":969,"description":"","number":"2","outbound":"0","amount":"47830","total_amount":"95660","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"35000","total_cost":"70000","supplier_id":90,"hardware_from":"2025-07-31","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-31","software_to":null,"maintenance_to":null}},{"id":7952,"project_id":3577,"product_id":1586,"amount":"11868","number":2,"cost":"15203.5","description":"","supplier_id":90,"hardware_from":"2025-07-31","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-31","software_to":null,"maintenance_to":null,"total_amount":"23736","total_cost":"30407.0","erp_sales_order_product_id":970,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1586,"name":"PAN-SVC-BKLN-1410","product_type":5,"product_component":35,"product_brand":8,"product_serie":1359,"product_misc":null,"product_qa":null,"pn":"","description":"PA-1410, Partner enabled premium support, 1 year (12 months) term.","created_by":1013,"created_at":"2024-04-26 09:35:29","updated_at":"2024-06-26 13:07:03","pinyin_shortcut":"PANSVCBKLN1410","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1359,"key":1359,"name":"PA-1410\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":970,"erp_sales_order_id":1271,"erp_store_id":null,"product_id":1586,"description":"","number":"2","outbound":"0","amount":"11868","total_amount":"23736","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"15203.5","total_cost":"30407.0","supplier_id":90,"hardware_from":"2025-07-31","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-31","software_to":null,"maintenance_to":null}},{"id":7953,"project_id":3577,"product_id":1657,"amount":"39479","number":2,"cost":"30000","description":"","supplier_id":90,"hardware_from":null,"software_from":"2024-08-01","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-31","maintenance_to":null,"total_amount":"78958","total_cost":"60000","erp_sales_order_product_id":971,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1657,"name":"PAN-PA-1410-BND-CORESEC","product_type":5,"product_component":36,"product_brand":8,"product_serie":1243,"product_misc":null,"product_qa":null,"pn":"","description":"PA-1410, Core Security Subscription Bundle (Advanced Threat Prevention, Advanced URL Filtering, Advanced Wildfire, DNS Security and SD-WAN ), 1 years (12 months) term\n","created_by":1013,"created_at":"2024-06-26 10:53:31","updated_at":"2024-06-26 10:53:31","pinyin_shortcut":"PANPA1410BNDCORESEC","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1243,"key":1243,"name":"PA1410\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":971,"erp_sales_order_id":1271,"erp_store_id":null,"product_id":1657,"description":"","number":"2","outbound":"0","amount":"39479","total_amount":"78958","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"30000","total_cost":"60000","supplier_id":90,"hardware_from":null,"software_from":"2024-08-01","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-31","maintenance_to":null}}],"commentCount":{"object_id":3577,"comment":3},"unreadComments":null,"fromContact":{"id":1262,"key":1262,"name":"\u5218\u70b3\u5764","client_id":null,"supplier_id":100,"mobiles":[{"id":6789,"contact_id":1262,"mobile":"15810817538","mp_open_id":null}],"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPoints":[{"id":774,"project_id":3577,"contact_id":1262,"point":"26476.00","paid_point":"26476","contact":{"id":1262,"key":1262,"name":"\u5218\u70b3\u5764","client_id":null,"supplier_id":100,"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPointRels":[{"id":138,"project_id":3577,"contact_id":1262,"point":"26476.00","day_at":"2024-12-16","description":"","created_at":"2024-12-16 10:10:44"}],"status_display":"\u5df2\u6838\u9500"}],"erpSalesOrder":{"id":1271,"serial_no":"XSDD-20240924-00001","from_date":null,"wrote_date":"2024-06-25","handler":1001,"client_id":3278,"purchase_contract_id":null,"project_id":3577,"sales_contract_id":3364,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-09-24 13:35:40","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"6","amount":"198354","created_by":1001,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-06-26 10:50:35","updated_at":"2024-09-24 13:35:40"},"projectUsedClient":null,"remain_display":443,"progress_remain_display":443,"forecast_remain_display":443,"projectProductTotalAmount":198354,"projectProductAllAmount":true,"projectProductTotalCost":160407,"projectProductAllCost":true,"projectProductTotalNumber":6,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":90,"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":"19.84\u4e07","contact_points_status_display":"\u5df2\u6838\u9500","verify_display":0,"un_collected":"0","un_invoiced":0},{"id":3927,"client_id":3286,"project_status":3,"project_progress":6,"budget":"40932","profit_pct":"11.14","bargain_date":"2025-08-22","description":"","created_by":1001,"created_at":"2025-07-22 11:05:23","updated_at":"2025-09-04 11:42:10","engineer_id":null,"project_title":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","collected":"1","status_updated_at":"2025-08-22 10:58:30.751668+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-07-22 11:05:23.224714+08","forecast_updated_at":"2025-07-22 11:05:23.224714+08","end_at":"","pinyin_shortcut":"PAVMfhqwbxy","creator":1011,"used_client":null,"from_contact":5957,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":1010,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"4559.824800000000000000","remain":"21 days 05:27:34.937853","progress_remain":"52 days 05:20:42.464807","forecast_remain":"52 days 05:20:42.464807","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"52 days 05:20:42.464807","issued_invoices":"21224.00","client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"40932","pct":"11.14","profit":"4732","project_id":3927}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4112,"from_project":3927,"payment_collection_remind_ahead":"1 day","serial_no":"PO2500925\/PO2500926","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"1","erp_un_settle_amount":"40931","including_tax":true,"amount":"40932","contractScans":[{"id":49444,"object_type":105,"object_id":4112,"attachment_id":27758,"attachment":{"id":27758,"key":27758,"name":"7ee83baa-e612-3fd5-bd97-de0e41ad46c7","extension":"pdf","path":"\/v2\/attachment\/preview\/aHkemdL-FzzGDDN3FUg-tUfVIXoO8gyc\/7ee83baa-e612-3fd5-bd97-de0e41ad46c7\/PO2500925.pdf","orig_name":"PO2500925.pdf"}},{"id":49445,"object_type":105,"object_id":4112,"attachment_id":27759,"attachment":{"id":27759,"key":27759,"name":"d40dfb56-6c1a-3498-b015-b8c1de8944bf","extension":"pdf","path":"\/v2\/attachment\/preview\/aHkemdL-FzzGDDN3FUg-tUfVIXoO8gyc\/d40dfb56-6c1a-3498-b015-b8c1de8944bf\/PO2500926.pdf","orig_name":"PO2500926.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[{"id":"12022","key":"12022","contract_id":4112,"value":"1","created_by":1001,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":0}],"salesContractInvoices":[{"id":2137,"key":2137,"contract_id":4112,"value":"21224.00","attachment_id":null,"from_date":"2025-08-28","attachment":null}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8890,"user_id":1001,"key":1001,"contract_id":4112,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"id":8891,"user_id":5388,"key":5388,"contract_id":4112,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":8892,"user_id":1011,"key":1011,"contract_id":4112,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}],"salesSupplierRels":[{"id":3202,"contract_id":4112,"supplier_id":90,"purchase_id":4122,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4122,"key":4122,"serial_no":"X_2025SBQ23652"}}],"payment_collection_remind_ahead_display":"1\u5929","invoiced":21224},"projectRemindReceivers":[],"projectProductRels":[{"id":10727,"project_id":3927,"product_id":1624,"amount":"1516","number":14,"cost":"1393.00","description":"\u65b0\u8d2d","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"21224.00","total_cost":"19502","erp_sales_order_product_id":1860,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2025-09-04 11:42:10","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1382,"key":1382,"name":"PA\u865a\u62df\u9632\u706b\u5899\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1860,"erp_sales_order_id":1571,"erp_store_id":null,"product_id":1624,"description":"\u65b0\u8d2d","number":"14","outbound":"0","amount":"1516","total_amount":"21224.00","last_number":"14","last_amount":"1516","last_total_amount":"21224.00","cost":"1393.00","total_cost":"19502","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10729,"project_id":3927,"product_id":2095,"amount":"0","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"0","erp_sales_order_product_id":1875,"supplier":null,"product":{"id":2095,"name":"SA3610","product_type":3,"product_component":14,"product_brand":27,"product_serie":1691,"product_misc":null,"product_qa":null,"pn":"","description":"2U\u673a\u67b6\u5f0f12 \u69fd\u673a\u67b6\u5f0f\u670d\u52a1\u5668\uff0cCPU\uff1aIntel\u00ae Xeon\u00ae D-1567\uff1b\u5185\u5b58\uff1a16 GB DDR4 ECC RDIMM\uff08\u53ef\u6269\u5145\u81f3 128 GB\uff09\uff1b12 x 3.5 \u82f1\u5bf8 Synology SAS\/SATA HDD\u30012.5 \u82f1\u5bf8 Synology SATA SSD \u6216 2.5 \u82f1\u5bf8 SAS SSD\uff08\u4e0d\u542b\u786c\u76d8\uff09\uff1b\u652f\u6301\u70ed\u63d2\u62d4\u786c\u76d8\uff1b2 x USB 3.2 \u7b2c 1 \u4ee3\u7aef\u53e3\u548c1 x \u6269\u5145\u7aef\u53e3 (Mini-SAS HD)\uff1b5\u5e74\u4fdd\u4fee\u3002","created_by":1013,"created_at":"2025-08-14 09:06:15","updated_at":"2025-09-04 11:02:52","pinyin_shortcut":"SA3610","product_unit":1,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":14,"key":14,"name":"\u5b58\u50a8\u4e3b\u673a"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1691,"key":1691,"name":"SA3610 NAS\u5b58\u50a8\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1875,"erp_sales_order_id":1571,"erp_store_id":null,"product_id":2095,"description":"","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":10728,"project_id":3927,"product_id":1624,"amount":"1516","number":13,"cost":"1393.00","description":"\u7eed\u7ea6","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"19708","total_cost":"18109","erp_sales_order_product_id":1861,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2025-09-04 11:42:10","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1382,"key":1382,"name":"PA\u865a\u62df\u9632\u706b\u5899\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1861,"erp_sales_order_id":1571,"erp_store_id":null,"product_id":1624,"description":"\u7eed\u7ea6","number":"13","outbound":"13","amount":"1516","total_amount":"19708","last_number":"14","last_amount":"1516","last_total_amount":"21224.00","cost":"1393.00","total_cost":"19502","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3927,"comment":3},"unreadComments":null,"fromContact":{"id":5957,"key":5957,"name":"\u674e\u777f\uff08Rick Li\uff09","client_id":null,"supplier_id":100,"mobiles":[{"id":6746,"contact_id":5957,"mobile":"13910153435","mp_open_id":null}],"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPoints":[],"erpSalesOrder":{"id":1571,"serial_no":"XSDD-20250822-00001","from_date":null,"wrote_date":"2025-08-22","handler":1001,"client_id":3286,"purchase_contract_id":null,"project_id":3927,"sales_contract_id":4112,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-08-22 10:59:39","stop_at":"2025-08-26 13:45:57.84962+08","cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"28","amount":"40932","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"5388\",\"1011\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2025-10-22\",\"amount\":\"42448\",\"pct\":\"100\"}]}","outbound_status":false,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-08-22 10:58:31","updated_at":"2025-08-26 16:06:50"},"projectUsedClient":{"id":180,"project_id":3927,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"remain_display":21,"progress_remain_display":52,"forecast_remain_display":52,"projectProductTotalAmount":40932,"projectProductAllAmount":true,"projectProductTotalCost":37611,"projectProductAllCost":true,"projectProductTotalNumber":28,"unissued_invoice":19708,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","can_invoice":true,"can_payment":true,"duration_display":52,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"4.09\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":"40931","un_invoiced":19708},{"id":3886,"client_id":2545,"project_status":3,"project_progress":9,"budget":"26550","profit_pct":"13.4","bargain_date":"2025-06-09","description":"","created_by":1001,"created_at":"2025-06-09 18:07:28","updated_at":"2025-08-27 16:14:53","engineer_id":null,"project_title":"SR650\u670d\u52a1\u5668\u914d\u4ef6\u91c7\u8d2d\u9879\u76ee","collected":"26550","status_updated_at":"2025-06-09 18:07:28.189522+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-06-09 18:07:28.189522+08","forecast_updated_at":"2025-06-11 11:50:32.439502+08","end_at":"2025-06-12 14:02:12","pinyin_shortcut":"SR650fwqpjcgxm","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":"4200","paid_contact_point":"4200","project_product_version_id":914,"is_sales_order_ready":true,"collected_plan":26550,"change_status_to":null,"is_verify":false,"profits":"3557.70000000000000000","remain":"94 days 22:18:37.499999","progress_remain":"94 days 22:18:37.499999","forecast_remain":"93 days 04:35:33.250019","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"2 days 19:54:44.388328","issued_invoices":"26550.00","client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":10,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"26550","pct":"13.4","profit":"3557.7","project_id":3886}],"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":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3967,"from_project":3886,"payment_collection_remind_ahead":"1 day","serial_no":"TSC-LRC-20250609001","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"26550","erp_un_settle_amount":"0","including_tax":true,"amount":"26550","contractScans":[{"id":35457,"object_type":105,"object_id":3967,"attachment_id":26100,"attachment":{"id":26100,"key":26100,"name":"993d8569-1fff-3e3b-8a24-655835029f06","extension":"pdf","path":"\/v2\/attachment\/preview\/aHkemdL-FzzGDDN3FUg-tUfVIXoO8gyc\/993d8569-1fff-3e3b-8a24-655835029f06\/\u786c\u76d8\u53ca\u80cc\u677f\u9635\u5217\u5361\u9500\u552e\u5408\u540c-\u7528\u5370\u7248.pdf","orig_name":"\u786c\u76d8\u53ca\u80cc\u677f\u9635\u5217\u5361\u9500\u552e\u5408\u540c-\u7528\u5370\u7248.pdf"}}],"receiptScans":[{"id":35198,"object_type":106,"object_id":3967,"attachment_id":26404,"attachment":{"id":26404,"key":26404,"name":"6635e529-d6ed-3b34-baf4-cde571180c1b","extension":"pdf","path":"\/v2\/attachment\/preview\/aHkemdL-FzzGDDN3FUg-tUfVIXoO8gyc\/6635e529-d6ed-3b34-baf4-cde571180c1b\/20250613144851-0001.pdf","orig_name":"20250613144851-0001.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":349,"serial_no":"SKD-20250612-00003","wrote_date":"2025-06-12","from_date":null,"handler":1001,"user_id":null,"client_id":2545,"sales_contract_id":3967,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2025-06-12 14:02:12","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"26550","settle_amount":"26550","created_by":1013,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2025-06-12 14:02:12","updated_at":"2025-06-12 14:02:12","paid_amount":null,"contact_id":null}],"salesContractPayments":[{"id":"1349","key":"1349","contract_id":3967,"value":"26550","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2070,"key":2070,"contract_id":3967,"value":"26550.00","attachment_id":null,"from_date":"2025-06-10","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2461,"key":2461,"contract_id":3967,"name":"2025-06-13","value":"26550","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":8610,"user_id":1001,"key":1001,"contract_id":3967,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"id":8611,"user_id":5388,"key":5388,"contract_id":3967,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":8612,"user_id":1011,"key":1011,"contract_id":3967,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}],"salesSupplierRels":[{"id":2899,"contract_id":3967,"supplier_id":678,"purchase_id":3969,"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3969,"key":3969,"serial_no":"TSKJ20250610-HYF-002"}}],"payment_collection_remind_ahead_display":"1\u5929","invoiced":26550},"projectRemindReceivers":[{"id":1567,"user_id":1001,"key":1001,"project_id":3886,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"projectProductRels":[{"id":10094,"project_id":3886,"product_id":1997,"amount":"6000.00","number":1,"cost":"500.00","description":"","supplier_id":678,"hardware_from":"2025-06-10","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-10","software_to":null,"maintenance_to":null,"total_amount":"6000","total_cost":"500","erp_sales_order_product_id":1709,"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1997,"name":"01GV283","product_type":2,"product_component":49,"product_brand":4,"product_serie":1630,"product_misc":null,"product_qa":null,"pn":"","description":"ThinkSystem SR650 2.5\" SATA\/SAS 8-Bay Backplane Kit ","created_by":1013,"created_at":"2025-06-10 14:02:34","updated_at":"2025-06-10 14:02:34","pinyin_shortcut":"01GV283","product_unit":3,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":49,"key":49,"name":"\u670d\u52a1\u5668\u786c\u76d8\u6269\u5c55\u5957\u4ef6"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1630,"key":1630,"name":"\u8054\u60f3\u670d\u52a1\u5668 2.5\u82f1\u5bf8\u786c\u76d8\u80cc\u677f\u6269\u5c55\u677f"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1709,"erp_sales_order_id":1519,"erp_store_id":null,"product_id":1997,"description":"","number":"1","outbound":"0","amount":"6000.00","total_amount":"6000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"500.00","total_cost":"500","supplier_id":678,"hardware_from":"2025-06-10","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-10","software_to":null,"maintenance_to":null}},{"id":10095,"project_id":3886,"product_id":1999,"amount":"1600.00","number":10,"cost":"1200.00","description":"","supplier_id":678,"hardware_from":"2025-06-10","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-10","software_to":null,"maintenance_to":null,"total_amount":"16000","total_cost":"12000","erp_sales_order_product_id":1710,"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1999,"name":"31110976","product_type":2,"product_component":5,"product_brand":4,"product_serie":42,"product_misc":null,"product_qa":null,"pn":"","description":"Lenovo 2.5\" ESS5600 960GB SATA SSD\u8054\u60f3\u56fa\u6001\u786c\u76d8","created_by":1013,"created_at":"2025-06-10 14:10:45","updated_at":"2025-06-10 14:10:45","pinyin_shortcut":"31110976","product_unit":3,"is_renew":false,"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":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1710,"erp_sales_order_id":1519,"erp_store_id":null,"product_id":1999,"description":"","number":"10","outbound":"0","amount":"1600.00","total_amount":"16000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"1200.00","total_cost":"12000","supplier_id":678,"hardware_from":"2025-06-10","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-10","software_to":null,"maintenance_to":null}},{"id":10096,"project_id":3886,"product_id":2000,"amount":"4550.00","number":1,"cost":"3800.00","description":"","supplier_id":678,"hardware_from":"2025-06-10","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-10","software_to":null,"maintenance_to":null,"total_amount":"4550","total_cost":"3800","erp_sales_order_product_id":1711,"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":2000,"name":"7Y37A01085","product_type":2,"product_component":7,"product_brand":4,"product_serie":1632,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2025-06-11 10:50:41","updated_at":"2025-06-11 10:50:41","pinyin_shortcut":"7Y37A01085","product_unit":3,"is_renew":false,"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":1632,"key":1632,"name":"\u8054\u60f3 RAID 930-16i 4GB Flash PCIe 12Gb"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1711,"erp_sales_order_id":1519,"erp_store_id":null,"product_id":2000,"description":"","number":"1","outbound":"0","amount":"4550.00","total_amount":"4550","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"3800.00","total_cost":"3800","supplier_id":678,"hardware_from":"2025-06-10","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-10","software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3886,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":1060,"project_id":3886,"contact_id":4640,"point":"4200.00","paid_point":"4200","contact":{"id":4640,"key":4640,"name":"\u5218\u82f1\u6960","client_id":2545,"supplier_id":null,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":201,"project_id":3886,"contact_id":4640,"point":"4200.00","day_at":"2025-07-01","description":"","created_at":"2025-07-01 10:54:10"}],"status_display":"\u5df2\u6838\u9500"}],"erpSalesOrder":{"id":1519,"serial_no":"XSDD-20250612-00001","from_date":null,"wrote_date":"2025-06-09","handler":1001,"client_id":2545,"purchase_contract_id":null,"project_id":3886,"sales_contract_id":3967,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-06-12 14:02:12","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"12","amount":"26550","created_by":1001,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-06-09 18:07:28","updated_at":"2025-06-12 14:02:12"},"projectUsedClient":null,"remain_display":94,"progress_remain_display":94,"forecast_remain_display":93,"projectProductTotalAmount":26550,"projectProductAllAmount":true,"projectProductTotalCost":16300,"projectProductAllCost":true,"projectProductTotalNumber":12,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":2,"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":"2.66\u4e07","contact_points_status_display":"\u5df2\u6838\u9500","verify_display":0,"un_collected":"0","un_invoiced":0},{"id":3890,"client_id":3372,"project_status":3,"project_progress":6,"budget":"35000","profit_pct":"9.76","bargain_date":"2025-06-16","description":"","created_by":1001,"created_at":"2025-06-13 14:53:56","updated_at":"2025-08-27 15:33:53","engineer_id":null,"project_title":"\u6df1\u4fe1\u670d\u9632\u706b\u5899+\u9510\u6377\u4ea4\u6362\u673a\u91c7\u8d2d\u9879\u76ee","collected":"35000","status_updated_at":"2025-06-16 11:32:46.233596+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-06-13 14:53:56.050883+08","forecast_updated_at":"2025-06-13 14:53:56.050883+08","end_at":"2025-06-30 09:53:22","pinyin_shortcut":"sxffhqrjjhjcgxm","creator":1001,"used_client":null,"from_contact":4640,"total_contact_point":"2940","paid_contact_point":"2940","project_product_version_id":909,"is_sales_order_ready":true,"collected_plan":35000,"change_status_to":null,"is_verify":false,"profits":"3416.000000000000000000","remain":"88 days 04:53:19.455925","progress_remain":"91 days 01:32:09.638638","forecast_remain":"91 days 01:32:09.638638","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"16 days 18:59:26.641628","issued_invoices":"35000.00","client":{"id":3372,"key":3372,"name":"\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09","logo":null,"client_type":5,"client_class":43,"client_industry":10,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"25000","pct":"9.76","profit":"2440","project_id":3890},{"id":4,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"10000","pct":"9.76","profit":"976","project_id":3890}],"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":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"casePoints":{"project_id":3890,"points":"219"},"workLogCount":null,"caseCount":{"project_id":3890,"count":4},"salesTimeCount":null,"implementTimeCount":{"project_id":3890,"sum":"11.7666666666667","times":"4"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3890,"sum":"62.88"},"buildContract":{"id":3978,"from_project":3890,"payment_collection_remind_ahead":"1 day","serial_no":"TSC-LRC-20250616001","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"35000","erp_un_settle_amount":"0","including_tax":true,"amount":"35000","contractScans":[{"id":35458,"object_type":105,"object_id":3978,"attachment_id":26337,"attachment":{"id":26337,"key":26337,"name":"758565a5-f84a-3aea-bf07-742e8b64d8a0","extension":"pdf","path":"\/v2\/attachment\/preview\/aHkemdL-FzzGDDN3FUg-tUfVIXoO8gyc\/758565a5-f84a-3aea-bf07-742e8b64d8a0\/\u9632\u706b\u5899\u4ea4\u6362\u673a\u9500\u552e\u5408\u540c \uff08\u53cc\u65b9\u5747\u5df2\u76d6\u7ae0\u7248\u672c\uff09.pdf","orig_name":"\u9632\u706b\u5899\u4ea4\u6362\u673a\u9500\u552e\u5408\u540c \uff08\u53cc\u65b9\u5747\u5df2\u76d6\u7ae0\u7248\u672c\uff09.pdf"}}],"receiptScans":[{"id":35436,"object_type":106,"object_id":3978,"attachment_id":26612,"attachment":{"id":26612,"key":26612,"name":"668f4e91-77e7-3bcf-9fc5-20e220b68d31","extension":"pdf","path":"\/v2\/attachment\/preview\/aHkemdL-FzzGDDN3FUg-tUfVIXoO8gyc\/668f4e91-77e7-3bcf-9fc5-20e220b68d31\/2025_06_30_10_01_23.pdf","orig_name":"2025_06_30_10_01_23.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":363,"serial_no":"SKD-20250630-00002","wrote_date":"2025-06-30","from_date":null,"handler":1001,"user_id":null,"client_id":3372,"sales_contract_id":3978,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2025-06-30 09:53:22","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"17500","settle_amount":"17500","created_by":1013,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2025-06-30 09:53:22","updated_at":"2025-06-30 09:53:22","paid_amount":null,"contact_id":null},{"id":362,"serial_no":"SKD-20250617-00005","wrote_date":"2025-06-17","from_date":null,"handler":1001,"user_id":null,"client_id":3372,"sales_contract_id":3978,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2025-06-17 11:10:10","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"17500","settle_amount":"17500","created_by":1013,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2025-06-17 11:10:10","updated_at":"2025-06-17 11:10:10","paid_amount":null,"contact_id":null}],"salesContractPayments":[{"id":"1363","key":"1363","contract_id":3978,"value":"17500","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":50},{"id":"1362","key":"1362","contract_id":3978,"value":"17500","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":50}],"salesContractInvoices":[{"id":2085,"key":2085,"contract_id":3978,"value":"35000.00","attachment_id":null,"from_date":"2025-06-25","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2465,"key":2465,"contract_id":3978,"name":"2025-06-17","value":"17500","overdue_days":0,"pct":50,"collect_status":"\u5df2\u5b8c\u6210"},{"id":2466,"key":2466,"contract_id":3978,"name":"2025-06-30","value":"17500","overdue_days":0,"pct":50,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":8613,"user_id":1001,"key":1001,"contract_id":3978,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"id":8614,"user_id":5388,"key":5388,"contract_id":3978,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":8615,"user_id":1011,"key":1011,"contract_id":3978,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}],"salesSupplierRels":[{"id":2900,"contract_id":3978,"supplier_id":236,"purchase_id":3982,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3982,"key":3982,"serial_no":"TSKJ20250616-HYF-001"}},{"id":2901,"contract_id":3978,"supplier_id":708,"purchase_id":3987,"supplier":{"id":708,"key":708,"name":"\u5317\u4eac\u701a\u6d77\u660e\u5929\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3987,"key":3987,"serial_no":"HHMT-BJ-BJTS-0088-20250618"}}],"payment_collection_remind_ahead_display":"1\u5929","invoiced":35000},"projectRemindReceivers":[{"id":1572,"user_id":1001,"key":1001,"project_id":3890,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"projectProductRels":[{"id":10097,"project_id":3890,"product_id":1190,"amount":"25000.00","number":1,"cost":"2030.00","description":"","supplier_id":236,"hardware_from":"2025-06-21","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-20","software_to":null,"maintenance_to":null,"total_amount":"25000","total_cost":"2030","erp_sales_order_product_id":1713,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1190,"name":"AF-1000-FH1600B","product_type":5,"product_component":191,"product_brand":12,"product_serie":741,"product_misc":null,"product_qa":null,"pn":"","description":"\u6027\u80fd\u53c2\u6570\uff1a\u7f51\u7edc\u5c42\u541e\u5410\u91cf\uff1a4G\uff0c\u5e94\u7528\u5c42\u541e\u5410\u91cf\uff1a2G\uff0c\u9632\u75c5\u6bd2\u541e\u5410\u91cf\uff1a600M\uff0cIPS\u541e\u5410\u91cf\uff1a600M\uff0c\u5168\u5a01\u80c1\u541e\u5410\u91cf\uff1a450M\uff0c\u5e76\u53d1\u8fde\u63a5\u6570\uff1a200\u4e07\uff0cHTTP\u65b0\u5efa\u8fde\u63a5\u6570\uff1a6\u4e07\uff0cSSL VPN\u63a8\u8350\u7528\u6237\u6570\uff08\u5355\u72ec\u8d2d\u4e70\uff09\uff1a20\uff0cSSL VPN\u6700\u5927\u7528\u6237\u6570\uff08\u5355\u72ec\u8d2d\u4e70\uff09\uff1a60\uff0cSSL VPN\u6700\u5927\u7406\u8bba\u52a0\u5bc6\u6d41\u91cf\uff08\u5355\u72ec\u8d2d\u4e70\uff09\uff1a160M\uff0cIPSec VPN \u6700\u5927\u63a5\u5165\u6570\uff1a300\uff0cIPSec VPN\u541e\u5410\u91cf\uff1a270M\u3002\n\u786c\u4ef6\u53c2\u6570\uff1a\u89c4\u683c\uff1a1U\uff0c\u5185\u5b58\u5927\u5c0f\uff1a4G\uff0c\u786c\u76d8\u5bb9\u91cf\uff1a128G SSD\uff0c\u7535\u6e90\uff1a\u5355\u7535\u6e90\uff0c\u63a5\u53e3\uff1a8\u5343\u5146\u7535\u53e3+2\u5343\u5146\u5149\u53e3SFP\u3002","created_by":1013,"created_at":"2024-01-09 14:58:07","updated_at":"2024-01-09 14:58:07","pinyin_shortcut":"AF1000FH1600B","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":191,"key":191,"name":"\u6df1\u4fe1\u670dAF-1000\u9632\u706b\u5899"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":741,"key":741,"name":"\u6df1\u4fe1\u670dAF-1000-FH1600B\u6807\u51c6\u4ea7\u54c1"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1713,"erp_sales_order_id":1521,"erp_store_id":null,"product_id":1190,"description":"","number":"1","outbound":"0","amount":"25000.00","total_amount":"25000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"2030.00","total_cost":"2030","supplier_id":236,"hardware_from":"2025-06-21","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-20","software_to":null,"maintenance_to":null}},{"id":10098,"project_id":3890,"product_id":1191,"amount":"0","number":1,"cost":"9609.49","description":"","supplier_id":236,"hardware_from":"2025-06-21","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-20","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"9609.49","erp_sales_order_product_id":1714,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1191,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH1600B\uff09","product_type":5,"product_component":35,"product_brand":12,"product_serie":103,"product_misc":null,"product_qa":null,"pn":"","description":"\u4ea7\u54c1\u51fa\u5382\u9ed8\u8ba4\u81ea\u5e26\u529f\u80fd\uff0c\u5305\u62ecACL\u63a7\u5236\u3001\u5e94\u7528\u8bc6\u522b\u4e0e\u6d41\u63a7\u3001\u5165\u4fb5\u9632\u5fa1\u3001\u50f5\u5c38\u7f51\u7edc\u68c0\u6d4b\u7b49\u529f\u80fd","created_by":1013,"created_at":"2024-01-09 14:59:50","updated_at":"2024-07-31 17:30:05","pinyin_shortcut":"sxffhqrjV80syyAF1000FH1600B","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":103,"key":103,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1714,"erp_sales_order_id":1521,"erp_store_id":null,"product_id":1191,"description":"","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"9609.49","total_cost":"9609.49","supplier_id":236,"hardware_from":"2025-06-21","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-20","software_to":null,"maintenance_to":null}},{"id":10099,"project_id":3890,"product_id":2008,"amount":"0","number":1,"cost":"1047.55","description":"","supplier_id":236,"hardware_from":"2025-06-21","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-20","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"1047.55","erp_sales_order_product_id":1715,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":2008,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08AF-1000-FH1600B\uff09","product_type":7,"product_component":188,"product_brand":12,"product_serie":743,"product_misc":null,"product_qa":null,"pn":"","description":"\u6309\u5e74\u6536\u8d39\uff0c\u5305\u62ecWEB\u5e94\u7528\u9632\u62a4\u8bc6\u522b\u5e93\u3001IPS\u7279\u5f81\u5e93\u3001\u50f5\u5c38\u7f51\u7edc\u9632\u62a4\u5e93\u3001\u5b9e\u65f6\u6f0f\u6d1e\u5206\u6790\u8bc6\u522b\u5e93\u548cURL&\u5e94\u7528\u8bc6\u522b\u5e93\u5b9a\u671f\u66f4\u65b0\uff0c\u4fdd\u6301\u8bbe\u5907\u5177\u5907\u68c0\u6d4b\u9632\u5fa1\u6700\u65b0\u5a01\u80c1\u7684\u80fd\u529b\u3002","created_by":1013,"created_at":"2025-06-16 11:40:41","updated_at":"2025-06-16 11:40:41","pinyin_shortcut":"sxfaqynyzdyrjV80AF1000FH1600B","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":188,"key":188,"name":"\u7cfb\u7edf\u8ba2\u9605\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":743,"key":743,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1715,"erp_sales_order_id":1521,"erp_store_id":null,"product_id":2008,"description":"","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"1047.55","total_cost":"1047.55","supplier_id":236,"hardware_from":"2025-06-21","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-20","software_to":null,"maintenance_to":null}},{"id":10100,"project_id":3890,"product_id":2009,"amount":"0","number":1,"cost":"2095.10","description":"","supplier_id":236,"hardware_from":"2025-06-21","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-20","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"2095.1","erp_sales_order_product_id":1716,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":2009,"name":"\u6df1\u4fe1\u670d\u4e91\u5a01\u80c1\u60c5\u62a5\u7f51\u5173\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH1600B\uff09","product_type":7,"product_component":188,"product_brand":12,"product_serie":1640,"product_misc":null,"product_qa":null,"pn":"","description":"\u6309\u5e74\u6536\u8d39\uff0c\u60a8\u5c06\u83b7\u5f97\u4ee5\u4e0b\u80fd\u529b\uff1a\n\u3010\u4e91\u7aef\u767e\u4ebf\u7ea7\u5a01\u80c1\u60c5\u62a5\u89c4\u5219\u5e93\uff0c\u5931\u9677\u5916\u8054\u5b9e\u65f6\u68c0\u6d4b\u4e0e\u62e6\u622a\u3011\u901a\u8fc7\u672c\u5730&\u4e91\u7aef\u767e\u4ebf\u7ea7\u5a01\u80c1\u60c5\u62a5\u548c\u5168\u56fd30+\u8fd0\u8425\u5546POP\u8282\u70b9 \uff0c\u5b9e\u65f6\u963b\u65ad\u4e3b\u673a\/PC\u5931\u9677\u5916\u8054\u3001\u6316\u77ff\u3001URL\u9493\u9c7c\u7b49\u98ce\u9669\uff1b\n\u3010\u65b0\u5a01\u80c1\/\u672a\u77e5\u5a01\u80c15min\u5185\u540c\u6b65\u3011\u83b7\u53d6\u4e91\u7aefAI\u667a\u80fd\u5f15\u64ce\u68c0\u6d4b\u80fd\u529b\uff0c\u672c\u5730\u9632\u706b\u5899\u89c4\u5219\u5e93\u6bcf5\u5206\u949f\u66f4\u65b0\u4e00\u6b21\uff0c\u540c\u6b65\u6700\u65b0\u7684\u672a\u77e5\u5a01\u80c1\u60c5\u62a5\u81f3\u5ba2\u6237\u672c\u5730\uff0c\u5b9e\u65f6\u83b7\u53d6\u672a\u77e5\u5a01\u80c1\u7684\u9632\u5fa1\u80fd\u529b\uff08\u5982\u6f0f\u6d1e\\\u6076\u610fIP\\\u9493\u9c7cURL\u7b49\uff09\u907f\u514d\u6210\u4e3a\u65b0\u578b\u5a01\u80c1\u7684\u9996\u6279\u53d7\u5bb3\u8005\uff1b\n\u3010\u6740\u6bd2\u529f\u80fd\u4e0e\u66f4\u65b0\u3011\u63d0\u4f9b\u672c\u5730\u8bbe\u5907\u7f51\u7edc\u6740\u6bd2\u529f\u80fd\u4e0e\u66f4\u65b0\u670d\u52a1\uff0c\u672a\u77e5\u6587\u4ef6MD5\u503c\u5b9e\u65f6\u4e91\u67e5\u529f\u80fd\u3002","created_by":1013,"created_at":"2025-06-16 11:43:18","updated_at":"2025-06-16 11:43:18","pinyin_shortcut":"sxfywxqbwgrjV80syyAF1000FH1600B","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":188,"key":188,"name":"\u7cfb\u7edf\u8ba2\u9605\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1640,"key":1640,"name":"\u6df1\u4fe1\u670d\u4e91\u5a01\u80c1\u60c5\u62a5\u7f51\u5173\u8f6f\u4ef6V8.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1716,"erp_sales_order_id":1521,"erp_store_id":null,"product_id":2009,"description":"","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"2095.10","total_cost":"2095.1","supplier_id":236,"hardware_from":"2025-06-21","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-20","software_to":null,"maintenance_to":null}},{"id":10101,"project_id":3890,"product_id":1874,"amount":"0","number":1,"cost":"2807.86","description":"","supplier_id":236,"hardware_from":"2025-06-21","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-20","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"2807.86","erp_sales_order_product_id":1717,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1874,"name":"\u6df1\u4fe1\u670dSSL VPN\u6388\u6743\u8f6f\u4ef6 V6.0","product_type":5,"product_component":35,"product_brand":12,"product_serie":104,"product_misc":null,"product_qa":null,"pn":"","description":"\u79fb\u52a8\u63a5\u5165\u6388\u6743","created_by":1013,"created_at":"2024-11-08 11:17:07","updated_at":"2024-11-08 11:17:07","pinyin_shortcut":"sxfSSLVPNsqrjV60","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":104,"key":104,"name":"\u6df1\u4fe1\u670dVPN\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1717,"erp_sales_order_id":1521,"erp_store_id":null,"product_id":1874,"description":"","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"2807.86","total_cost":"2807.86","supplier_id":236,"hardware_from":"2025-06-21","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-20","software_to":null,"maintenance_to":null}},{"id":10102,"project_id":3890,"product_id":1639,"amount":"10000.00","number":1,"cost":"8276.00","description":"","supplier_id":708,"hardware_from":"2025-06-21","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-20","software_to":null,"maintenance_to":null,"total_amount":"10000","total_cost":"8276","erp_sales_order_product_id":1718,"supplier":{"id":708,"key":708,"name":"\u5317\u4eac\u701a\u6d77\u660e\u5929\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1639,"name":"RG-S5750C-24GT8XS-X","product_type":4,"product_component":19,"product_brand":54,"product_serie":1395,"product_misc":null,"product_qa":null,"pn":"","description":"24\u7aef\u53e3\u5343\u5146\u4ee5\u592a\u7f51\u7535\u53e3(RJ45)+8\u7aef\u53e3\u4e07\u5146\u4ee5\u592a\u7f51\u5149\u53e3(SFP+)","created_by":1013,"created_at":"2024-05-31 16:43:40","updated_at":"2024-05-31 16:43:40","pinyin_shortcut":"RGS5750C24GT8XSX","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":19,"key":19,"name":"\u4ea4\u6362\u673a"},"productBrand":{"id":54,"key":54,"name":"\u9510\u6377"},"productSerie":{"id":1395,"key":1395,"name":"\u9510\u6377RG-S5750C-24GT8XS-X\u4ea4\u6362\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1718,"erp_sales_order_id":1521,"erp_store_id":null,"product_id":1639,"description":"","number":"1","outbound":"0","amount":"10000.00","total_amount":"10000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"8276.00","total_cost":"8276","supplier_id":708,"hardware_from":"2025-06-21","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-20","software_to":null,"maintenance_to":null}},{"id":10103,"project_id":3890,"product_id":1640,"amount":"0","number":2,"cost":"258.00","description":"","supplier_id":708,"hardware_from":"2025-06-21","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-20","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"516","erp_sales_order_product_id":1719,"supplier":{"id":708,"key":708,"name":"\u5317\u4eac\u701a\u6d77\u660e\u5929\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1640,"name":"XG-SR-MM850","product_type":4,"product_component":43,"product_brand":54,"product_serie":386,"product_misc":null,"product_qa":null,"pn":"","description":"\u9510\u6377\u4e07\u5146\u591a\u6a21\u6a21\u5757","created_by":1013,"created_at":"2024-05-31 16:44:50","updated_at":"2024-05-31 16:44:50","pinyin_shortcut":"XGSRMM850","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":54,"key":54,"name":"\u9510\u6377"},"productSerie":{"id":386,"key":386,"name":"\u9510\u6377SFP+\u4e07\u514610Gb\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1719,"erp_sales_order_id":1521,"erp_store_id":null,"product_id":1640,"description":"","number":"2","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"258.00","total_cost":"516","supplier_id":708,"hardware_from":"2025-06-21","software_from":null,"maintenance_from":null,"hardware_to":"2026-06-20","software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3890,"comment":3},"unreadComments":null,"fromContact":{"id":4640,"key":4640,"name":"\u5218\u82f1\u6960","client_id":2545,"supplier_id":null,"mobiles":[{"id":5450,"contact_id":4640,"mobile":"13601232524","mp_open_id":null}],"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPoints":[{"id":1061,"project_id":3890,"contact_id":4640,"point":"2940.00","paid_point":"2940","contact":{"id":4640,"key":4640,"name":"\u5218\u82f1\u6960","client_id":2545,"supplier_id":null,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":202,"project_id":3890,"contact_id":4640,"point":"2940.00","day_at":"2025-07-01","description":"","created_at":"2025-07-01 10:55:10"}],"status_display":"\u5df2\u6838\u9500"}],"erpSalesOrder":{"id":1521,"serial_no":"XSDD-20250630-00001","from_date":null,"wrote_date":"2025-06-16","handler":1001,"client_id":3372,"purchase_contract_id":null,"project_id":3890,"sales_contract_id":3978,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-06-30 09:53:22","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"8","amount":"35000","created_by":1001,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-06-16 11:32:46","updated_at":"2025-06-30 09:53:22"},"projectUsedClient":{"id":132,"project_id":3890,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"remain_display":88,"progress_remain_display":91,"forecast_remain_display":91,"projectProductTotalAmount":35000,"projectProductAllAmount":true,"projectProductTotalCost":26382,"projectProductAllCost":true,"projectProductTotalNumber":8,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":16,"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":"3.5\u4e07","contact_points_status_display":"\u5df2\u6838\u9500","verify_display":0,"un_collected":"0","un_invoiced":0},{"id":3949,"client_id":2845,"project_status":3,"project_progress":6,"budget":"15340","profit_pct":"2.35","bargain_date":"2025-08-19","description":"","created_by":1001,"created_at":"2025-08-19 16:55:09","updated_at":"2025-08-22 15:54:38","engineer_id":null,"project_title":"PA1410\u4e00\u5e74\u670d\u52a1","collected":"0","status_updated_at":"2025-08-19 17:45:00.090435+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-08-19 16:55:09.854722+08","forecast_updated_at":"2025-08-19 16:55:09.854722+08","end_at":"","pinyin_shortcut":"PA1410ynfw","creator":1011,"used_client":null,"from_contact":5980,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":984,"is_sales_order_ready":true,"collected_plan":15340,"change_status_to":null,"is_verify":false,"profits":"360.490000000000000000","remain":"23 days 22:41:05.599086","progress_remain":"23 days 23:30:55.834799","forecast_remain":"23 days 23:30:55.834799","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"23 days 23:30:55.834799","issued_invoices":"15340.00","client":{"id":2845,"key":2845,"name":"\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08PA\u8fc7\u5355\uff09","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"15340","pct":"2.35","profit":"360.49","project_id":3949}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4106,"from_project":3949,"payment_collection_remind_ahead":"1 day","serial_no":"TS-LRC-2025081901","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"0","erp_un_settle_amount":"15340","including_tax":true,"amount":"15340","contractScans":[{"id":48837,"object_type":105,"object_id":4106,"attachment_id":27658,"attachment":{"id":27658,"key":27658,"name":"3d37d904-ae5a-3dd6-80e0-4ffe662ea0ae","extension":"pdf","path":"\/v2\/attachment\/preview\/aHkemdL-FzzGDDN3FUg-tUfVIXoO8gyc\/3d37d904-ae5a-3dd6-80e0-4ffe662ea0ae\/\u5408\u540c\u76d6\u7ae0\u4ef6.pdf","orig_name":"\u5408\u540c\u76d6\u7ae0\u4ef6.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[],"salesContractInvoices":[{"id":2131,"key":2131,"contract_id":4106,"value":"15340.00","attachment_id":null,"from_date":"2025-08-25","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2549,"key":2549,"contract_id":4106,"name":"2025-09-05","value":"15340","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f7\u5929"}],"salesContractPaymentCollectionRemindReceivers":[{"id":8853,"user_id":1001,"key":1001,"contract_id":4106,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"id":8854,"user_id":1011,"key":1011,"contract_id":4106,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":8855,"user_id":5388,"key":5388,"contract_id":4106,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}}],"salesSupplierRels":[{"id":3168,"contract_id":4106,"supplier_id":90,"purchase_id":4103,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4103,"key":4103,"serial_no":"X_2025SBQ23003"}}],"payment_collection_remind_ahead_display":"1\u5929","invoiced":15340},"projectRemindReceivers":[],"projectProductRels":[{"id":10668,"project_id":3949,"product_id":2108,"amount":"15340.00","number":1,"cost":"14573.00","description":"","supplier_id":90,"hardware_from":null,"software_from":"2025-08-20","maintenance_from":null,"hardware_to":null,"software_to":"2026-08-20","maintenance_to":null,"total_amount":"15340","total_cost":"14573","erp_sales_order_product_id":1855,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":2108,"name":"PAN-SVC-BKLN-1410-R","product_type":5,"product_component":214,"product_brand":8,"product_serie":1694,"product_misc":null,"product_qa":null,"pn":"","description":"PA-1410, Partner enabled premium support, 1 year (12 months) term, renewal.","created_by":1013,"created_at":"2025-08-19 16:53:04","updated_at":"2025-08-21 16:46:27","pinyin_shortcut":"PANSVCBKLN1410R","product_unit":2,"is_renew":true,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":214,"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1694,"key":1694,"name":"PA1410\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1855,"erp_sales_order_id":1566,"erp_store_id":null,"product_id":2108,"description":"","number":"1","outbound":"1","amount":"15340.00","total_amount":"15340","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"14573.00","total_cost":"14573","supplier_id":90,"hardware_from":null,"software_from":"2025-08-20","maintenance_from":null,"hardware_to":null,"software_to":"2026-08-20","maintenance_to":null}}],"commentCount":{"object_id":3949,"comment":3},"unreadComments":null,"fromContact":{"id":5980,"key":5980,"name":"\u738b\u5b66\u5a05","client_id":null,"supplier_id":90,"mobiles":[{"id":6767,"contact_id":5980,"mobile":"13811457427","mp_open_id":null}],"client":null,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"projectContactPoints":[],"erpSalesOrder":{"id":1566,"serial_no":"XSDD-20250819-00001","from_date":null,"wrote_date":"2025-08-19","handler":1001,"client_id":2845,"purchase_contract_id":null,"project_id":3949,"sales_contract_id":4106,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-08-20 14:58:35","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"15340","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"1011\",\"5388\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2025-09-05\",\"amount\":\"15340\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-08-19 17:45:00","updated_at":"2025-08-20 14:58:35"},"projectUsedClient":{"id":177,"project_id":3949,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"remain_display":23,"progress_remain_display":23,"forecast_remain_display":23,"projectProductTotalAmount":15340,"projectProductAllAmount":true,"projectProductTotalCost":14573,"projectProductAllCost":true,"projectProductTotalNumber":1,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","can_invoice":true,"can_payment":true,"duration_display":23,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"1.53\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":0,"un_collected":"15340","un_invoiced":0},{"id":3760,"client_id":2545,"project_status":3,"project_progress":9,"budget":"121890","profit_pct":"19.97","bargain_date":"2025-01-08","description":"","created_by":1001,"created_at":"2025-01-09 10:12:48","updated_at":"2025-08-22 15:17:13","engineer_id":null,"project_title":"\u8054\u60f33\u5957\u4e8c\u624b\u670d\u52a1\u5668SR650\u91c7\u8d2d\u9879\u76ee","collected":"121890","status_updated_at":"2025-01-09 10:12:48.131449+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-01-09 10:12:48.131449+08","forecast_updated_at":"2025-01-09 10:12:48.131449+08","end_at":"2025-01-17 14:41:35","pinyin_shortcut":"lx3tesfwqSR650cgxm","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":"31500","paid_contact_point":"31500","project_product_version_id":750,"is_sales_order_ready":true,"collected_plan":121890,"change_status_to":null,"is_verify":false,"profits":"24341.433000000000000000","remain":"246 days 06:13:17.558072","progress_remain":"246 days 06:13:17.558072","forecast_remain":"246 days 06:13:17.558072","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"8 days 04:28:47.182076","issued_invoices":"121890.00","client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":10,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"121890.00","pct":"19.97","profit":"24341.433","project_id":3760}],"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":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"casePoints":{"project_id":3760,"points":"31"},"workLogCount":null,"caseCount":{"project_id":3760,"count":1},"salesTimeCount":null,"implementTimeCount":{"project_id":3760,"sum":"2","times":"1"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3760,"sum":"301.82"},"buildContract":{"id":3746,"from_project":3760,"payment_collection_remind_ahead":"1 day","serial_no":"TSC-LRC-2025010801","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"121890","erp_un_settle_amount":"0","including_tax":true,"amount":"121890","contractScans":[{"id":32009,"object_type":105,"object_id":3746,"attachment_id":23648,"attachment":{"id":23648,"key":23648,"name":"1c798a97-9234-39da-882e-ed20e36d5997","extension":"pdf","path":"\/v2\/attachment\/preview\/aHkemdL-FzzGDDN3FUg-tUfVIXoO8gyc\/1c798a97-9234-39da-882e-ed20e36d5997\/\u8d44\u821f.pdf","orig_name":"\u8d44\u821f.pdf"}}],"receiptScans":[{"id":31798,"object_type":106,"object_id":3746,"attachment_id":23714,"attachment":{"id":23714,"key":23714,"name":"2bca3898-3c7e-30e0-a274-e553398b8d93","extension":"jpg","path":"\/v2\/attachment\/preview\/aHkemdL-FzzGDDN3FUg-tUfVIXoO8gyc\/2bca3898-3c7e-30e0-a274-e553398b8d93\/\u8d44\u821f.jpg","orig_name":"\u8d44\u821f.jpg"}}],"verifyScans":[],"erpCollectTickets":[{"id":225,"serial_no":"SKD-20250117-00003","wrote_date":"2025-01-17","from_date":null,"handler":1001,"user_id":null,"client_id":2545,"sales_contract_id":3746,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2025-01-17 14:41:35","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"60945","settle_amount":"60945","created_by":1013,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2025-01-17 14:41:35","updated_at":"2025-01-17 14:41:35","paid_amount":null,"contact_id":null},{"id":224,"serial_no":"SKD-20250110-00002","wrote_date":"2025-01-10","from_date":null,"handler":1001,"user_id":null,"client_id":2545,"sales_contract_id":3746,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2025-01-10 16:56:17","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"60945","settle_amount":"60945","created_by":1013,"stop_description":null,"is_settle":false,"is_old":true,"created_at":"2025-01-10 16:56:17","updated_at":"2025-01-10 16:56:17","paid_amount":null,"contact_id":null}],"salesContractPayments":[{"id":"1225","key":"1225","contract_id":3746,"value":"60945","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":50},{"id":"1224","key":"1224","contract_id":3746,"value":"60945","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":50}],"salesContractInvoices":[{"id":1928,"key":1928,"contract_id":3746,"value":"60945.00","attachment_id":null,"from_date":"2025-01-09","attachment":null},{"id":1934,"key":1934,"contract_id":3746,"value":"60945.00","attachment_id":null,"from_date":"2025-01-14","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2302,"key":2302,"contract_id":3746,"name":"2025-01-16","value":"60945","overdue_days":null,"pct":50,"collect_status":"\u5df2\u5b8c\u6210"},{"id":2303,"key":2303,"contract_id":3746,"name":"2025-01-31","value":"60945","overdue_days":null,"pct":50,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":7777,"user_id":1001,"key":1001,"contract_id":3746,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"id":7778,"user_id":1011,"key":1011,"contract_id":3746,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":7779,"user_id":5388,"key":5388,"contract_id":3746,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}}],"salesSupplierRels":[{"id":2374,"contract_id":3746,"supplier_id":678,"purchase_id":3747,"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3747,"key":3747,"serial_no":"YTYG2025"}},{"id":2385,"contract_id":3746,"supplier_id":38,"purchase_id":3773,"supplier":{"id":38,"key":38,"name":"\u5317\u4eac\u4e91\u9526\u975e\u51e1\u79d1\u6280\u6709\u9650\u516c\u53f8 \/\u5317\u4eac\u5929\u52e4\u76ca\u8fbe\u79d1\u6280\u6709\u9650\u516c\u53f8\u3010\u5b89\u82af\u64ce\u5929(\u5929\u6d25)\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011\/\u5317\u4eac\u5747\u4f18\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3773,"key":3773,"serial_no":"TSKJ20250110-WJC-001"}},{"id":3166,"contract_id":3746,"supplier_id":478,"purchase_id":4118,"supplier":{"id":478,"key":478,"name":"\u5317\u4eac\u957f\u987a\u7f51\u8054\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4118,"key":4118,"serial_no":"JK-T-2025-01-09-0002"}}],"payment_collection_remind_ahead_display":"1\u5929","invoiced":121890},"projectRemindReceivers":[{"id":1360,"user_id":1001,"key":1001,"project_id":3760,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"projectProductRels":[{"id":8728,"project_id":3760,"product_id":498,"amount":"38000.00","number":3,"cost":"13400.00","description":"2*480G SSD","supplier_id":678,"hardware_from":"2025-01-10","software_from":null,"maintenance_from":null,"hardware_to":"2026-01-10","software_to":null,"maintenance_to":null,"total_amount":"114000","total_cost":"40200","erp_sales_order_product_id":1484,"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":498,"name":"\u8054\u60f3 SR650\u670d\u52a1\u5668","product_type":2,"product_component":2,"product_brand":4,"product_serie":315,"product_misc":2,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2018-11-30 13:58:06","updated_at":"2023-08-14 10:20:52","pinyin_shortcut":"lxSR650fwq","product_unit":1,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":315,"key":315,"name":"\u8054\u60f3 SR650 \u670d\u52a1\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1484,"erp_sales_order_id":1427,"erp_store_id":null,"product_id":498,"description":"2*480G SSD","number":"3","outbound":"0","amount":"38000.00","total_amount":"114000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"13400.00","total_cost":"40200","supplier_id":678,"hardware_from":"2025-01-10","software_from":null,"maintenance_from":null,"hardware_to":"2026-01-10","software_to":null,"maintenance_to":null}},{"id":8729,"project_id":3760,"product_id":1923,"amount":"0","number":24,"cost":"230.00","description":"","supplier_id":null,"hardware_from":"2025-01-10","software_from":null,"maintenance_from":null,"hardware_to":"2026-01-10","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"5520","erp_sales_order_product_id":1485,"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":"2025-01-09 10:41:37","pinyin_shortcut":"32GBPC42666Pnc","product_unit":6,"is_renew":false,"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":1485,"erp_sales_order_id":1427,"erp_store_id":null,"product_id":1923,"description":"","number":"24","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"230.00","total_cost":"5520","supplier_id":null,"hardware_from":"2025-01-10","software_from":null,"maintenance_from":null,"hardware_to":"2026-01-10","software_to":null,"maintenance_to":null}},{"id":8730,"project_id":3760,"product_id":1104,"amount":"2500.00","number":3,"cost":"1200.00","description":"","supplier_id":678,"hardware_from":"2025-01-10","software_from":null,"maintenance_from":null,"hardware_to":"2026-01-10","software_to":null,"maintenance_to":null,"total_amount":"7500","total_cost":"3600","erp_sales_order_product_id":1486,"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1104,"name":"QLE2692 Dual Port 16Gb","product_type":3,"product_component":39,"product_brand":24,"product_serie":666,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-11-27 15:10:06","updated_at":"2024-01-16 14:46:51","pinyin_shortcut":"QLE2692DualPort16Gb","product_unit":3,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":24,"key":24,"name":"\u6d6a\u6f6e"},"productSerie":{"id":666,"key":666,"name":"16GB \u53cc\u53e3 HBA\u5361"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1486,"erp_sales_order_id":1427,"erp_store_id":null,"product_id":1104,"description":"","number":"3","outbound":"0","amount":"2500.00","total_amount":"7500","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"1200.00","total_cost":"3600","supplier_id":678,"hardware_from":"2025-01-10","software_from":null,"maintenance_from":null,"hardware_to":"2026-01-10","software_to":null,"maintenance_to":null}},{"id":8731,"project_id":3760,"product_id":1372,"amount":"65.00","number":6,"cost":"25.00","description":"","supplier_id":678,"hardware_from":"2025-01-10","software_from":null,"maintenance_from":null,"hardware_to":"2026-01-10","software_to":null,"maintenance_to":null,"total_amount":"390","total_cost":"150","erp_sales_order_product_id":1487,"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"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":"2025-08-27 13:24:36","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":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":{"id":1487,"erp_sales_order_id":1427,"erp_store_id":null,"product_id":1372,"description":"","number":"6","outbound":"0","amount":"65.00","total_amount":"390","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"25.00","total_cost":"150","supplier_id":678,"hardware_from":"2025-01-10","software_from":null,"maintenance_from":null,"hardware_to":"2026-01-10","software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3760,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":856,"project_id":3760,"contact_id":4640,"point":"31500.00","paid_point":"31500","contact":{"id":4640,"key":4640,"name":"\u5218\u82f1\u6960","client_id":2545,"supplier_id":null,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":154,"project_id":3760,"contact_id":4640,"point":"31500.00","day_at":"2025-01-21","description":"","created_at":"2025-01-21 11:43:34"}],"status_display":"\u5df2\u6838\u9500"}],"erpSalesOrder":{"id":1427,"serial_no":"XSDD-20250117-00001","from_date":null,"wrote_date":"2025-01-08","handler":1001,"client_id":2545,"purchase_contract_id":null,"project_id":3760,"sales_contract_id":3746,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-01-17 14:41:35","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"36","amount":"121890","created_by":1001,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-01-09 10:12:48","updated_at":"2025-01-17 14:41:35"},"projectUsedClient":null,"remain_display":246,"progress_remain_display":246,"forecast_remain_display":246,"projectProductTotalAmount":121890,"projectProductAllAmount":true,"projectProductTotalCost":49470,"projectProductAllCost":true,"projectProductTotalNumber":36,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":8,"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":"12.19\u4e07","contact_points_status_display":"\u5df2\u6838\u9500","verify_display":0,"un_collected":"0","un_invoiced":0}],"pagenation":{"totalcount":99,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-12 16:26:05') RETURNING "id" |