6a5480bc079bd: POST https://beta.jinchangxiao.com/v2/project/of-client at 2026-07-13 02:07:56 pm by 39.156.194.178
Log Messages
总计118条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 14:07:56.030 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 14:07:56.030 | trace | yii\base\Module::getModule | Loading module: debug |
| 14:07:56.031 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 14:07:56.031 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 14:07:56.031 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 14:07:56.032 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:07:56.032 | info | time tracing start | 1783922876032513024 |
| 14:07:56.032 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 14:07:56.032 | trace | yii\web\Application::handleRequest | Route requested: 'v2/project/of-client' |
| 14:07:56.032 | trace | yii\base\Module::getModule | Loading module: v2 |
| 14:07:56.034 | info | yii\web\Session::open | Session started |
| 14:07:56.035 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 14:07:56.036 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm' |
| 14:07:56.037 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:07:56.037 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:07:56.038 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:07:56.038 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:07:56.038 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 14:07:56.039 | trace | yii\base\Controller::runAction | Route to run: v2/project/of-client |
| 14:07:56.040 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:07:56.042 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 14:07:56.042 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\ProjectController::actionOfClient() |
| 14:07:56.042 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='48') AND ("deleted"=FALSE) |
| 14:07:56.043 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:07:56.043 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:07:56.043 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:07:56.044 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:07:56.044 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:07:56.046 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:07:56.047 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1000) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) AND ("p"."client_id"=48) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC) "c" |
| 14:07:56.065 | info | yii\db\Command::query | SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1000) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) AND ("p"."client_id"=48) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC LIMIT 10 |
| 14:07:56.082 | 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"=48 |
| 14:07:56.083 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
| 14:07:56.083 | 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"=1004) |
| 14:07:56.084 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id"=5 |
| 14:07:56.084 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=47 |
| 14:07:56.085 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id"=8 |
| 14:07:56.086 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2) |
| 14:07:56.089 | 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 (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543) ORDER BY "contribution" DESC, "engineer_id" |
| 14:07:56.090 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:07:56.090 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:07:56.091 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (2, 3) |
| 14:07:56.091 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (4, 6, 9, 10) |
| 14:07:56.092 | 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 (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543) |
| 14:07:56.093 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543) |
| 14:07:56.094 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (226, 5, 1, 215, 135, 140, 198, 202, 196, 204, 184, 189, 185, 192, 197, 199, 165, 181, 340, 348, 130, 164, 2, 324, 349, 377, 350)) ORDER BY "sort" |
| 14:07:56.095 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543) |
| 14:07:56.096 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (226, 5, 1, 215, 135, 140, 198, 202, 196, 204, 184, 189, 185, 192, 197, 199, 165, 181, 340, 348, 130, 164, 2, 324, 349, 377, 350)) ORDER BY "sort" |
| 14:07:56.097 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543) |
| 14:07:56.097 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (226, 5, 1, 215, 135, 140, 198, 202, 196, 204, 184, 189, 185, 192, 197, 199, 165, 181, 340, 348, 130, 164, 2, 324, 349, 377, 350)) ORDER BY "sort" |
| 14:07:56.098 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
| 14:07:56.099 | 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"=1004) |
| 14:07:56.099 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
| 14:07:56.100 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
| 14:07:56.100 | 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"=1004) |
| 14:07:56.100 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=48 |
| 14:07:56.101 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
| 14:07:56.101 | 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"=1004) |
| 14:07:56.102 | 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 (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543) GROUP BY "c"."project_id" |
| 14:07:56.110 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:07:56.110 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:07:56.111 | 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 (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543)) GROUP BY "project_id" |
| 14:07:56.111 | info | yii\db\Command::query | SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543) GROUP BY "project_id" |
| 14:07:56.113 | 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 (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543)) GROUP BY "project_id" |
| 14:07:56.114 | 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 (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543)) GROUP BY "c"."project_id" |
| 14:07:56.124 | 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 (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543)) GROUP BY "c"."project_id" |
| 14:07:56.128 | 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 (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543)) GROUP BY "project_id" |
| 14:07:56.129 | 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 (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543)) GROUP BY "project_id" |
| 14:07:56.132 | 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 (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543) |
| 14:07:56.134 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (3299, 3366, 3395, 3385, 3547, 3783, 3998, 4168, 4360)) |
| 14:07:56.138 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (19258, 20172, 20173, 19979, 22367, 23608, 31336, 28417, 26540, 24294) |
| 14:07:56.138 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (3299, 3366, 3395, 3385, 3547, 3783, 3998, 4168, 4360)) |
| 14:07:56.142 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (19377, 21603, 24182, 28388, 31327) |
| 14:07:56.142 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (3299, 3366, 3395, 3385, 3547, 3783, 3998, 4168, 4360)) |
| 14:07:56.146 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE ("status"=2) AND ("sales_contract_id" IN (3299, 3366, 3395, 3385, 3547, 3783, 3998, 4168, 4360)) ORDER BY "id" DESC |
| 14:07:56.147 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "collected_date" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.wrote_date as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "r" WHERE "contract_id" IN (3299, 3366, 3395, 3385, 3547, 3783, 3998, 4168, 4360) ORDER BY "id" DESC |
| 14:07:56.151 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5388, 1013) |
| 14:07:56.151 | 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 (3299, 3366, 3395, 3385, 3547, 3783, 3998, 4168, 4360) ORDER BY "id" |
| 14:07:56.152 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (3299, 3366, 3395, 3385, 3547, 3783, 3998, 4168, 4360) ORDER BY "remind_date" |
| 14:07:56.153 | 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 (3299, 3366, 3395, 3385, 3547, 3783, 3998, 4168, 4360) |
| 14:07:56.154 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 1001) |
| 14:07:56.154 | 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 (1004, 1001)) |
| 14:07:56.155 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (3299, 3366, 3395, 3385, 3547, 3783, 3998, 4168, 4360) |
| 14:07:56.156 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (489, 165, 598, 236, 90, 116, 174) |
| 14:07:56.157 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4361, 3561, 3292, 3411, 3424, 4167, 3722, 4004, 4220, 3784) |
| 14:07:56.158 | info | yii\db\Command::query | SELECT "id", "sales_contract_id", "status" FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id" IN (3299, 3366, 3395, 3385, 3547, 3783, 3998, 4168, 4360) ORDER BY "id" DESC |
| 14:07:56.159 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (1664, 1589, 1529, 1443, 1351, 1286, 1282, 1272, 1246) ORDER BY "id" |
| 14:07:56.160 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:07:56.161 | 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) |
| 14:07:56.161 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (1664, 1589, 1529, 1443, 1351, 1286, 1282, 1272, 1246) ORDER BY "id" |
| 14:07:56.162 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE "erp_sales_order_id" IN (1664, 1589, 1529, 1443, 1351, 1286, 1282, 1272, 1246) ORDER BY "id" |
| 14:07:56.163 | 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 (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543) |
| 14:07:56.164 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543) ORDER BY "id" |
| 14:07:56.165 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (598, 236, 90, 165, 116) |
| 14:07:56.166 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1620, 1663, 1664, 1665, 922, 1354, 1669, 1670, 1780, 941, 1376, 41, 1939) |
| 14:07:56.167 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (3, 22, 5, 19, 2) |
| 14:07:56.168 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (15, 17, 208, 36, 189, 35, 200, 151, 13) |
| 14:07:56.169 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (6, 12, 8, 133, 50, 4) |
| 14:07:56.169 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1015, 1147, 1414, 1026, 1415, 210, 1416, 1024, 592, 1149, 1598, 1052) |
| 14:07:56.170 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (4, 2, 7, 3, 8) |
| 14:07:56.171 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (896, 989, 990, 991, 992, 998, 999, 1000, 1227, 972, 973, 2121, 1896, 1734, 1732, 1733, 1730, 1731, 1525) |
| 14:07:56.172 | info | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543)) GROUP BY "object_id" |
| 14:07:56.203 | info | yii\db\Command::query | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=1) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543)) GROUP BY "object_id" |
| 14:07:56.222 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543) |
| 14:07:56.223 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543)) |
| 14:07:56.225 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id" IN (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543) |
| 14:07:56.226 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=48 |
| 14:07:56.227 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id" IN (138, 191, 275, 299) |
| 14:07:56.228 | 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 (138, 191, 275, 299) |
| 14:07:56.228 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id" IN (138, 191, 275, 299) |
| 14:07:56.229 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id" IN (138, 191, 275, 299) |
| 14:07:56.230 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status"=1) AND ("project_id" IN (4080, 4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543)) |
| 14:07:56.231 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: viewProduct |
| 14:07:56.231 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: StoreKeeper |
| 14:07:56.231 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 14:07:56.237 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:07:56.238 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:07:56.239 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 0, 276, 'v2/project/of-client', '{"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","device_type":"0","version_code":"276","id":"48","page":"1","token":"73c974e7f4a52fcce1c57c5de337ab2c","posttime":"1783922876","pagesize":"10"}', '{"code":200,"data":{"list":[{"id":4080,"client_id":48,"project_status":2,"project_progress":4,"budget":"68000","profit_pct":"20","bargain_date":"2026-03-31","description":null,"created_by":1004,"created_at":"2025-12-21 21:34:46","updated_at":"2026-03-22 22:25:38","engineer_id":null,"project_title":"\u96f6\u4fe1\u4efb\u9879\u76ee","collected":"0","status_updated_at":"2026-01-11 20:30:27.680898+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2026-01-11 20:30:27.680898+08","forecast_updated_at":"2026-01-11 20:30:27.680898+08","end_at":"","pinyin_shortcut":"lxrxm","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":true,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"13600.0000000000000000","remain":"182 days 17:37:28.38582","progress_remain":"182 days 17:37:28.38582","forecast_remain":"182 days 17:37:28.38582","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"203 days 16:33:09.114951","issued_invoices":null,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":4080,"value":"1","key":1022,"name":"\u5f90\u7855"}],"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":4,"key":4,"name":"\u786e\u8ba4\u65b9\u6848","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u7684\u53cd\u9988\uff0c\u4e0d\u65ad\u4f18\u5316\u89e3\u51b3\u65b9\u6848\uff0c\u76f4\u5230\u5ba2\u6237\u53e3\u5934\u6216\u4e66\u9762\u8ba4\u53ef\u65b9\u6848\u3002 \n\u65b9\u6cd5\uff1a\u4f7f\u7528\u573a\u666f\uff0c\u95ee\u9898\uff0c\u9700\u6c42\uff0c\u4ea7\u54c1\u53ca\u529f\u80fd\u7684\u65b9\u6cd5\u8bb2\u89e3\u65b9\u6848\u3002"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"68000","pct":"20","profit":"13600","project_id":4080}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":130,"key":130,"name":"\u7ade\u4e89\u8c08\u5224"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":4080,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":{"id":299,"project_id":4080,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"erpSalesOrderVerify":null,"remain_display":182,"progress_remain_display":182,"forecast_remain_display":182,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":68000,"is_exceeded":true,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_invoice":false,"can_payment":false,"duration_display":203,"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":"6.8\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":0,"un_invoiced":0,"object_type":1,"verifyList":[]},{"id":4090,"client_id":48,"project_status":3,"project_progress":6,"budget":"2000","profit_pct":"62.38","bargain_date":"2026-01-05","description":"","created_by":1004,"created_at":"2026-01-05 09:50:46","updated_at":"2026-01-12 14:50:57","engineer_id":null,"project_title":"2016\u5b58\u50a8\u786c\u76d8","collected":"2000","status_updated_at":"2026-01-05 15:32:06.287761+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2026-01-05 09:50:46.170745+08","forecast_updated_at":"2026-01-05 09:50:46.170745+08","end_at":"2026-01-22 16:25:03","pinyin_shortcut":"2016ccyp","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":1152,"is_sales_order_ready":true,"collected_plan":2000,"change_status_to":null,"is_verify":false,"profits":"1247.600000000000000000","remain":"188 days 22:35:49.778957","progress_remain":"189 days 04:17:09.895973","forecast_remain":"189 days 04:17:09.895973","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"17 days 06:34:17.268774","issued_invoices":"2000.00","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":4090,"value":"1","key":1023,"name":"\u5468\u5b50\u5065"}],"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":"2000","pct":"62.38","profit":"1247.6","project_id":4090}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":130,"key":130,"name":"\u7ade\u4e89\u8c08\u5224"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4360,"from_project":4090,"payment_collection_remind_ahead":"1 day","serial_no":"TS-YJC-202601","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"2000","erp_un_settle_amount":"0","including_tax":true,"amount":"2000","contractScans":[{"id":55250,"object_type":105,"object_id":4360,"attachment_id":31336,"attachment":{"id":31336,"key":31336,"name":"71c02d3c-a56f-395e-be25-f5e576433a74","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/71c02d3c-a56f-395e-be25-f5e576433a74\/2026_01_12_17_57_51_1.pdf","orig_name":"2026_01_12_17_57_51_1.pdf"}}],"receiptScans":[{"id":55236,"object_type":106,"object_id":4360,"attachment_id":31327,"attachment":{"id":31327,"key":31327,"name":"d177aa3c-4f71-313b-8f4a-428f99c6d645","extension":"jpg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/d177aa3c-4f71-313b-8f4a-428f99c6d645\/68931768199723_.pic_hd.jpg","orig_name":"68931768199723_.pic_hd.jpg"}}],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[{"id":"12160","key":"12160","contract_id":4360,"value":"2000","created_by":1013,"collected_date":"2026-01-22 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2280,"key":2280,"contract_id":4360,"value":"2000.00","attachment_id":null,"from_date":"2026-01-12","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2707,"key":2707,"contract_id":4360,"name":"2026-01-31","value":"2000","overdue_days":null,"status":1,"remind_date":"2026-01-31","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":9689,"user_id":1001,"key":1001,"contract_id":4360,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},{"id":9690,"user_id":1004,"key":1004,"contract_id":4360,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesSupplierRels":[{"id":3828,"contract_id":4360,"supplier_id":489,"purchase_id":4361,"supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4361,"key":4361,"serial_no":"TSKJ20260104-HYF-002"}}],"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","invoiced":2000},"projectRemindReceivers":[],"projectProductRels":[{"id":11452,"project_id":4090,"product_id":41,"amount":"1000","number":2,"cost":"260","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"2000","total_cost":"520","erp_sales_order_product_id":2121,"supplier":null,"product":{"id":41,"name":"X423A-R5","product_type":3,"product_component":15,"product_brand":6,"product_serie":1015,"product_misc":4,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-02-16 12:06:10","updated_at":"2026-01-06 11:47:31","pinyin_shortcut":"X423AR5","product_unit":4,"is_renew":false,"in_out_at":"2026-01-06 11:47:31.374476+08","productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":6,"key":6,"name":"NetApp"},"productSerie":{"id":1015,"key":1015,"name":"900G 10K 2.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":2121,"erp_sales_order_id":1664,"erp_store_id":null,"product_id":41,"description":"","number":"2","outbound":"2","amount":"1000","total_amount":"2000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"260","total_cost":"520","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":4090,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1664,"serial_no":"XSDD-20260105-00002","from_date":null,"wrote_date":"2026-01-05","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":4090,"sales_contract_id":4360,"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":"2026-01-05 15:32:18","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"2","amount":"2000","created_by":1004,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5388\",\"1001\",\"1004\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2026-01-31\",\"amount\":\"2000\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-01-05 15:32:06","updated_at":"2026-01-05 15:32:18","print_times":null},"projectUsedClient":{"id":275,"project_id":4090,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"erpSalesOrderVerify":null,"remain_display":188,"progress_remain_display":189,"forecast_remain_display":189,"projectProductTotalAmount":2000,"projectProductAllAmount":true,"projectProductTotalCost":520,"projectProductAllCost":true,"projectProductTotalNumber":2,"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":17,"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":"2000","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[{"id":102,"erp_sales_order_id":1664,"user_id":1001,"status":1,"description":null,"verify_at":"2026-01-05 15:32:18","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}]},{"id":3969,"client_id":48,"project_status":3,"project_progress":9,"budget":"2000","profit_pct":"62.38","bargain_date":"2025-09-17","description":"","created_by":1004,"created_at":"2025-09-18 09:35:38","updated_at":"2026-01-14 09:14:06","engineer_id":null,"project_title":"\u5b58\u50a8\u786c\u76d8\u914d\u4ef6","collected":"2000","status_updated_at":"2025-09-18 09:36:36.186218+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-09-18 09:35:38.644814+08","forecast_updated_at":"2025-09-18 09:35:38.644814+08","end_at":"2026-01-14 09:14:06","pinyin_shortcut":"ccyppj","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":1187,"is_sales_order_ready":true,"collected_plan":2000,"change_status_to":null,"is_verify":false,"profits":"1247.600000000000000000","remain":"298 days 04:31:19.8805","progress_remain":"298 days 04:32:17.421904","forecast_remain":"298 days 04:32:17.421904","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"117 days 23:38:27.67867","issued_invoices":"2000.00","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3969,"value":"1","key":1023,"name":"\u5468\u5b50\u5065"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"2000","pct":"62.38","profit":"1247.6","project_id":3969}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4168,"from_project":3969,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-YJC-20250917-01","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"2000","erp_un_settle_amount":"0","including_tax":true,"amount":"2000","contractScans":[{"id":55277,"object_type":105,"object_id":4168,"attachment_id":28417,"attachment":{"id":28417,"key":28417,"name":"6974d662-bd61-3e50-8d68-0bd1d1b637ad","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/6974d662-bd61-3e50-8d68-0bd1d1b637ad\/2025_09_19_15_45_58.pdf","orig_name":"2025_09_19_15_45_58.pdf"}}],"receiptScans":[{"id":50281,"object_type":106,"object_id":4168,"attachment_id":28388,"attachment":{"id":28388,"key":28388,"name":"93809ae5-25b7-3ecc-b0d6-62a432e7cafb","extension":"jpg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/93809ae5-25b7-3ecc-b0d6-62a432e7cafb\/66231758183049_.pic.jpg","orig_name":"66231758183049_.pic.jpg"}}],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[{"id":"12049","key":"12049","contract_id":4168,"value":"2000","created_by":1013,"collected_date":"2025-10-13 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2163,"key":2163,"contract_id":4168,"value":"2000.00","attachment_id":null,"from_date":"2025-09-26","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2585,"key":2585,"contract_id":4168,"name":"2025-09-30","value":"2000","overdue_days":13,"status":1,"remind_date":"2025-09-30","pct":100,"overdue_display":"\u903e\u671f13\u5929"}],"salesContractPaymentCollectionRemindReceivers":[{"id":9710,"user_id":1004,"key":1004,"contract_id":4168,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},{"id":9711,"user_id":1001,"key":1001,"contract_id":4168,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"salesSupplierRels":[{"id":3852,"contract_id":4168,"supplier_id":489,"purchase_id":4167,"supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4167,"key":4167,"serial_no":"TSKJ20250918-HYF-01"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":2000},"projectRemindReceivers":[],"projectProductRels":[{"id":11574,"project_id":3969,"product_id":41,"amount":"1000","number":2,"cost":"260","description":"","supplier_id":null,"hardware_from":"2025-09-18","software_from":null,"maintenance_from":null,"hardware_to":"2026-09-18","software_to":null,"maintenance_to":null,"total_amount":"2000","total_cost":"520","erp_sales_order_product_id":1896,"supplier":null,"product":{"id":41,"name":"X423A-R5","product_type":3,"product_component":15,"product_brand":6,"product_serie":1015,"product_misc":4,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-02-16 12:06:10","updated_at":"2026-01-06 11:47:31","pinyin_shortcut":"X423AR5","product_unit":4,"is_renew":false,"in_out_at":"2026-01-06 11:47:31.374476+08","productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":6,"key":6,"name":"NetApp"},"productSerie":{"id":1015,"key":1015,"name":"900G 10K 2.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":1896,"erp_sales_order_id":1589,"erp_store_id":null,"product_id":41,"description":"","number":"2","outbound":"2","amount":"1000","total_amount":"2000","last_number":"2","last_amount":"1000","last_total_amount":"2000","cost":"260","total_cost":"520","supplier_id":null,"hardware_from":"2025-09-18","software_from":null,"maintenance_from":null,"hardware_to":"2026-09-18","software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3969,"comment":4},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1589,"serial_no":"XSDD-20250918-00001","from_date":null,"wrote_date":"2025-09-18","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3969,"sales_contract_id":4168,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-09-18 09:49:20","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"2","amount":"2000","created_by":1004,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":null,\"salesContractPaymentCollectionRemindReceivers\":[\"1004\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-09-18 09:36:36","updated_at":"2025-09-18 09:49:20","print_times":null},"projectUsedClient":{"id":191,"project_id":3969,"used_client":48,"budget":"2000","profit":"1500","profit_pct":"75","collected_plan":"2000","remind_ahead":null,"usedClient":{"id":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"zdskgylglyxgs","description":"\u66fe\u7528\u540d\uff1a\u4e2d\u90fd\u7269\u6d41\u6709\u9650\u516c\u53f8","corp_rep":"\u5f20\u96ea\u6885","website":"http:\/\/www.capital-logistics.cn\/","capital":"45000","established_at":"2008-01-08","headcount":"200","reg_address":68,"working_address":null,"telephone":"010-89401168","fax":"","scale":"","branch":"\u6709","purchase_scale_per_yr":"150","purchase_freq":"\u591a\u6b21","company_nature":1,"client_class":47,"client_industry":8,"client_type":5,"sales_rep":1004,"main_contact":null,"created_by":1003,"created_at":"2017-02-11 23:21:36","updated_at":"2026-04-15 10:29:05","main_business":"\u65b0\u8f66\u7269\u6d41\uff0c\u5927\u578b\u8bbe\u5907\u7269\u6d41\u8fd0\u8f93","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2021-06-03 15:44:50","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":7,"client_key_info_count":2,"contact_count":9,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":1,"is_overdue_remind":false,"from_contact":null,"tax_no":null},"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[{"id":2,"key":2,"project_used_client_id":191,"remind_date":"2025-10-30","amount":2000,"name":"2025-10-30","value":2000,"overdue_days":null,"pct":100,"collect_status":"\u903e\u671f256\u5929"}],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":2000,"un_collected":2000,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":2000,"project_used_client_collected_plan_pct":100},"erpSalesOrderVerify":null,"remain_display":298,"progress_remain_display":298,"forecast_remain_display":298,"projectProductTotalAmount":2000,"projectProductAllAmount":true,"projectProductTotalCost":520,"projectProductAllCost":true,"projectProductTotalNumber":2,"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":117,"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":"2000","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[{"id":27,"erp_sales_order_id":1589,"user_id":1001,"status":1,"description":"","verify_at":"2025-09-18 09:49:20","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}]},{"id":3873,"client_id":48,"project_status":3,"project_progress":9,"budget":"62075.1","profit_pct":"76.05","bargain_date":"2025-06-24","description":"","created_by":1004,"created_at":"2025-05-29 14:02:17","updated_at":"2026-04-15 10:29:06","engineer_id":null,"project_title":"2025\u5e74\u6570\u636e\u4e2d\u5fc3\u7ef4\u4fdd","collected":"62075.1","status_updated_at":"2025-06-24 17:49:25.334992+08","success_rate":null,"comment":"","contract_type":2,"progress_updated_at":"2025-06-24 17:48:20.531314+08","forecast_updated_at":"2025-06-24 17:48:20.531314+08","end_at":"2026-01-14 09:54:04","pinyin_shortcut":"2025nsjzxwb","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":1234,"is_sales_order_ready":true,"collected_plan":62075.1,"change_status_to":null,"is_verify":false,"profits":"47208.113550000000000000","remain":"383 days 20:18:30.731726","progress_remain":"383 days 20:19:35.535404","forecast_remain":"383 days 20:19:35.535404","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"229 days 19:51:46.977064","issued_invoices":"62075.10","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"usedClient":null,"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":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":19,"product_type_id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1","budget":"21157.6","pct":"76.05","profit":"16090.35","project_id":3873},{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"26046.5","pct":"76.05","profit":"19808.36","project_id":3873},{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"14871","pct":"76.05","profit":"11309.39","project_id":3873}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":130,"key":130,"name":"\u7ade\u4e89\u8c08\u5224"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":{"project_id":3873,"points":"884"},"workLogCount":null,"caseCount":{"project_id":3873,"count":19},"salesTimeCount":null,"implementTimeCount":{"project_id":3873,"sum":"31.75","times":"18"},"presalesTimeCount":{"project_id":3873,"sum":"0.966666666666667","times":"1"},"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3873,"sum":"1044.63"},"buildContract":{"id":3998,"from_project":3873,"payment_collection_remind_ahead":"1 day","serial_no":"TS-YJC-20250526-001","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"62075.1","erp_un_settle_amount":"0","including_tax":true,"amount":"62075.1","contractScans":[{"id":55337,"object_type":105,"object_id":3998,"attachment_id":26540,"attachment":{"id":26540,"key":26540,"name":"f60f6e42-f01c-31e2-9913-9b08f0b63f0a","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f60f6e42-f01c-31e2-9913-9b08f0b63f0a\/\u4e2d\u90fd\u6570\u79d1\u5408\u540c.pdf","orig_name":"\u4e2d\u90fd\u6570\u79d1\u5408\u540c.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[{"id":361,"serial_no":"SKD-20250630-00001","wrote_date":"2025-06-30","from_date":null,"handler":1004,"user_id":null,"client_id":48,"sales_contract_id":3998,"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:50:54","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"62075.1","settle_amount":"62075.1","created_by":1013,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2025-06-30 09:50:54","updated_at":"2025-06-30 09:50:54","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1361","key":"1361","contract_id":3998,"value":"62075.1","created_by":1013,"collected_date":"2025-06-30 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2084,"key":2084,"contract_id":3998,"value":"62075.10","attachment_id":null,"from_date":"2025-06-25","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2475,"key":2475,"contract_id":3998,"name":"2025-07-31","value":"62075.1","overdue_days":null,"status":1,"remind_date":"2025-07-31","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":9790,"user_id":1004,"key":1004,"contract_id":3998,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesSupplierRels":[{"id":3949,"contract_id":3998,"supplier_id":236,"purchase_id":4004,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":4004,"key":4004,"serial_no":"TSKJ20250630-HYF-002"}},{"id":3950,"contract_id":3998,"supplier_id":116,"purchase_id":4220,"supplier":{"id":116,"key":116,"name":"\u56db\u5ddd\u957f\u8679\u4f73\u534e\u4fe1\u606f\u4ea7\u54c1\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"purchase":{"id":4220,"key":4220,"serial_no":"20251028001"}}],"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","invoiced":62075.1},"projectRemindReceivers":[],"projectProductRels":[{"id":11706,"project_id":3873,"product_id":922,"amount":"7800","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":"2025-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-25","maintenance_to":null,"total_amount":"7800","total_cost":null,"erp_sales_order_product_id":1734,"supplier":null,"product":{"id":922,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0EDR\u7eed\u4fdd\u670d\u52a1","product_type":22,"product_component":200,"product_brand":12,"product_serie":1024,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-05-08 12:11:04","updated_at":"2026-01-28 10:32:39","pinyin_shortcut":"sxfzdjcxyptEDRxbfw","product_unit":2,"is_renew":false,"in_out_at":"2026-01-28 10:32:39.333577+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1024,"key":1024,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0EDR\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1734,"erp_sales_order_id":1529,"erp_store_id":null,"product_id":922,"description":"","number":"1","outbound":"0","amount":"7800","total_amount":"7800","last_number":"1","last_amount":"7800","last_total_amount":"7800","cost":"5000.00","total_cost":"5000","supplier_id":null,"hardware_from":null,"software_from":"2025-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-25","maintenance_to":null}},{"id":11707,"project_id":3873,"product_id":1663,"amount":"3960","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":"2025-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-25","maintenance_to":null,"total_amount":"3960","total_cost":null,"erp_sales_order_product_id":1732,"supplier":null,"product":{"id":1663,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09","product_type":22,"product_component":208,"product_brand":12,"product_serie":1414,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-04 15:30:00","updated_at":"2024-07-04 15:30:00","pinyin_shortcut":"URLampyysbgzksjsyyAC1000B1250","product_unit":2,"is_renew":true,"in_out_at":null,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":208,"key":208,"name":"\u4ea7\u54c1\u5347\u7ea7"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1414,"key":1414,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1732,"erp_sales_order_id":1529,"erp_store_id":null,"product_id":1663,"description":"","number":"1","outbound":"0","amount":"3960","total_amount":"3960","last_number":"1","last_amount":"3960","last_total_amount":"3960","cost":"2714.00","total_cost":"2714","supplier_id":null,"hardware_from":null,"software_from":"2025-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-25","maintenance_to":null}},{"id":11708,"project_id":3873,"product_id":1664,"amount":"3111","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":"2025-07-25","software_from":null,"maintenance_from":null,"hardware_to":"2026-07-25","software_to":null,"maintenance_to":null,"total_amount":"3111","total_cost":null,"erp_sales_order_product_id":1733,"supplier":null,"product":{"id":1664,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1415,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-04 15:31:49","updated_at":"2024-07-04 15:31:49","pinyin_shortcut":"sxfcpzbrjsjfwsyyAC1000B1250","product_unit":2,"is_renew":true,"in_out_at":null,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1415,"key":1415,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1733,"erp_sales_order_id":1529,"erp_store_id":null,"product_id":1664,"description":"","number":"1","outbound":"0","amount":"3111","total_amount":"3111","last_number":"1","last_amount":"3111","last_total_amount":"3111","cost":"2261.00","total_cost":"2261","supplier_id":null,"hardware_from":"2025-07-25","software_from":null,"maintenance_from":null,"hardware_to":"2026-07-25","software_to":null,"maintenance_to":null}},{"id":11709,"project_id":3873,"product_id":941,"amount":"21157.6","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-07-14","hardware_to":null,"software_to":null,"maintenance_to":"2026-07-13","total_amount":"21157.6","total_cost":null,"erp_sales_order_product_id":1730,"supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2026-02-05 16:37:56","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-02-05 16:37:56.557723+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1730,"erp_sales_order_id":1529,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"0","amount":"21157.6","total_amount":"21157.6","last_number":"1","last_amount":"21157.6","last_total_amount":"21157.6","cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-07-14","hardware_to":null,"software_to":null,"maintenance_to":"2026-07-13"}},{"id":11710,"project_id":3873,"product_id":1376,"amount":"5209.3","number":5,"cost":"1500","description":"","supplier_id":null,"hardware_from":"2025-08-08","software_from":null,"maintenance_from":null,"hardware_to":"2026-08-07","software_to":null,"maintenance_to":null,"total_amount":"26046.50","total_cost":"7500","erp_sales_order_product_id":1731,"supplier":null,"product":{"id":1376,"name":"CBSOMA11M","product_type":2,"product_component":13,"product_brand":4,"product_serie":1052,"product_misc":null,"product_qa":null,"pn":"","description":"\u8054\u60f3\u539f\u5382\u4e00\u5e745*9\u670d\u52a1","created_by":1001,"created_at":"2024-01-26 17:55:26","updated_at":"2025-10-29 17:37:40","pinyin_shortcut":"CBSOMA11M","product_unit":8,"is_renew":false,"in_out_at":"2025-10-29 17:37:40.337224+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":13,"key":13,"name":"\u670d\u52a1\u5668\u91d1\u724c\u670d\u52a1"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1052,"key":1052,"name":"SR650\u670d\u52a1\u5668\u4e00\u5e745*9\u539f\u5382\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":1731,"erp_sales_order_id":1529,"erp_store_id":null,"product_id":1376,"description":"","number":"5","outbound":"5","amount":"5209.3","total_amount":"26046.50","last_number":"5","last_amount":"5209.3","last_total_amount":"26046.50","cost":"1500","total_cost":"7500","supplier_id":null,"hardware_from":"2025-08-08","software_from":null,"maintenance_from":null,"hardware_to":"2026-08-07","software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3873,"comment":8},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1529,"serial_no":"XSDD-20250624-00002","from_date":null,"wrote_date":"2025-06-24","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3873,"sales_contract_id":3998,"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:50:54","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"9","amount":"62075.1","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":true,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2025-06-24 17:49:25","updated_at":"2025-06-30 09:50:54","print_times":null},"projectUsedClient":{"id":138,"project_id":3873,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"erpSalesOrderVerify":null,"remain_display":383,"progress_remain_display":383,"forecast_remain_display":383,"projectProductTotalAmount":62075.1,"projectProductAllAmount":true,"projectProductTotalCost":7500,"projectProductAllCost":false,"projectProductTotalNumber":9,"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":229,"contract_type_display":"\u8fd0\u7ef4\u670d\u52a1","can_change_status":false,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"6.21\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":3776,"client_id":48,"project_status":3,"project_progress":6,"budget":"3200","profit_pct":"30.63","bargain_date":"2025-02-17","description":"","created_by":1004,"created_at":"2025-02-12 21:11:37","updated_at":"2026-01-14 10:58:46","engineer_id":null,"project_title":"\u7ea2\u886b\u5b58\u50a8\u786c\u76d8","collected":"3200","status_updated_at":"2025-02-12 21:12:32.970773+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-02-12 21:11:37.509695+08","forecast_updated_at":"2025-02-12 21:11:37.509695+08","end_at":"2026-01-14 10:58:46","pinyin_shortcut":"hsccyp","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":1302,"is_sales_order_ready":true,"collected_plan":3200,"change_status_to":null,"is_verify":false,"profits":"980.160000000000000000","remain":"515 days 16:55:23.095945","progress_remain":"515 days 16:56:18.557023","forecast_remain":"515 days 16:56:18.557023","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"335 days 13:47:08.667839","issued_invoices":"3200.00","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"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":"3200","pct":"30.63","profit":"980.16","project_id":3776}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":{"project_id":3776,"points":"31"},"workLogCount":null,"caseCount":{"project_id":3776,"count":1},"salesTimeCount":null,"implementTimeCount":{"project_id":3776,"sum":"0.6","times":"1"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3776,"sum":"365.39"},"buildContract":{"id":3783,"from_project":3776,"payment_collection_remind_ahead":"1 day","serial_no":"TS-YJC-20250217001","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"3200","erp_un_settle_amount":"0","including_tax":true,"amount":"3200","contractScans":[{"id":55425,"object_type":105,"object_id":3783,"attachment_id":24294,"attachment":{"id":24294,"key":24294,"name":"35d7e69c-6922-340d-98d1-9dc08c8647fb","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/35d7e69c-6922-340d-98d1-9dc08c8647fb\/2025_02_26_11_08_56.pdf","orig_name":"2025_02_26_11_08_56.pdf"}}],"receiptScans":[{"id":32368,"object_type":106,"object_id":3783,"attachment_id":24182,"attachment":{"id":24182,"key":24182,"name":"9b5931a8-b7d1-34db-801d-d3600dc40150","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/9b5931a8-b7d1-34db-801d-d3600dc40150\/DOC021825-02182025141505.pdf","orig_name":"DOC021825-02182025141505.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":228,"serial_no":"SKD-20250225-00001","wrote_date":"2025-02-25","from_date":null,"handler":1004,"user_id":null,"client_id":48,"sales_contract_id":3783,"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-02-25 17:11:38","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"3200","settle_amount":"3200","created_by":1013,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2025-02-25 17:11:38","updated_at":"2025-02-25 17:11:38","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1228","key":"1228","contract_id":3783,"value":"3200","created_by":1013,"collected_date":"2025-02-25 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1952,"key":1952,"contract_id":3783,"value":"3200.00","attachment_id":null,"from_date":"2025-02-18","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2334,"key":2334,"contract_id":3783,"name":"2025-03-31","value":"3200","overdue_days":null,"status":1,"remind_date":"2025-03-31","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":9920,"user_id":1004,"key":1004,"contract_id":3783,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesSupplierRels":[{"id":4051,"contract_id":3783,"supplier_id":174,"purchase_id":3784,"supplier":{"id":174,"key":174,"name":"\u5317\u4eac\u79d1\u534e\u5609\u4e1a\u79d1\u8d38\u6709\u9650\u516c\u53f8"},"purchase":{"id":3784,"key":3784,"serial_no":"TSKJ20250212-HYF-001"}}],"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","invoiced":3200},"projectRemindReceivers":[],"projectProductRels":[{"id":11863,"project_id":3776,"product_id":1939,"amount":"3200","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":"2025-02-13","software_from":null,"maintenance_from":null,"hardware_to":"2026-02-12","software_to":null,"maintenance_to":null,"total_amount":"3200","total_cost":null,"erp_sales_order_product_id":1525,"supplier":null,"product":{"id":1939,"name":"MS3M2HD002T0A3AEE","product_type":3,"product_component":15,"product_brand":50,"product_serie":1598,"product_misc":null,"product_qa":null,"pn":"","description":"\u5b8f\u6749\u5b58\u50a8MS2500G2-12C 2T 3.5\u82f1\u5bf8 7.2K HDD\u786c\u76d8","created_by":1013,"created_at":"2025-02-13 09:42:30","updated_at":"2025-02-13 10:32:57","pinyin_shortcut":"MS3M2HD002T0A3AEE","product_unit":4,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":50,"key":50,"name":"\u5b8f\u6749"},"productSerie":{"id":1598,"key":1598,"name":"2T 3.5\u82f1\u5bf8 7.2K HDD"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":1525,"erp_sales_order_id":1443,"erp_store_id":null,"product_id":1939,"description":"","number":"1","outbound":"0","amount":"3200","total_amount":"3200","last_number":"1","last_amount":"3200","last_total_amount":"3200","cost":"2000.00","total_cost":"2000","supplier_id":null,"hardware_from":"2025-02-13","software_from":null,"maintenance_from":null,"hardware_to":"2026-02-12","software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3776,"comment":7},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1443,"serial_no":"XSDD-20250212-00001","from_date":null,"wrote_date":"2025-02-17","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3776,"sales_contract_id":3783,"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-02-25 17:11:38","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"3200","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2025-02-12 21:12:33","updated_at":"2025-02-25 17:11:38","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":515,"progress_remain_display":515,"forecast_remain_display":515,"projectProductTotalAmount":3200,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":false,"projectProductTotalNumber":1,"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":335,"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":"3200","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":3658,"client_id":48,"project_status":3,"project_progress":6,"budget":"7600","profit_pct":"66.68","bargain_date":"2024-09-23","description":"","created_by":1004,"created_at":"2024-09-18 08:53:25","updated_at":"2024-10-31 09:26:38","engineer_id":null,"project_title":"Netapp\u5b58\u50a8\u786c\u76d8","collected":"7600","status_updated_at":"2024-09-18 09:31:24.620167+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-09-18 08:53:25.927694+08","forecast_updated_at":"2024-09-18 08:53:25.927694+08","end_at":"2024-10-23 17:15:47","pinyin_shortcut":"Netappccyp","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":584,"is_sales_order_ready":true,"collected_plan":7600,"change_status_to":null,"is_verify":false,"profits":"5067.680000000000000000","remain":"663 days 04:36:31.446551","progress_remain":"663 days 05:14:30.139024","forecast_remain":"663 days 05:14:30.139024","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"35 days 08:22:21.207825","issued_invoices":"7600.00","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3658,"value":"1","key":1023,"name":"\u5468\u5b50\u5065"}],"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":"7600.00","pct":"66.68","profit":"5067.68","project_id":3658}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3547,"from_project":3658,"payment_collection_remind_ahead":"7 days","serial_no":"TS-YJC-2024092301","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"7600","erp_un_settle_amount":"0","including_tax":true,"amount":"7600","contractScans":[{"id":31656,"object_type":105,"object_id":3547,"attachment_id":22367,"attachment":{"id":22367,"key":22367,"name":"724ba639-c78f-3d75-bf3a-5d4466247466","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/724ba639-c78f-3d75-bf3a-5d4466247466\/DOC103124-10312024091010 1.pdf","orig_name":"DOC103124-10312024091010 1.pdf"}},{"id":31657,"object_type":105,"object_id":3547,"attachment_id":23608,"attachment":{"id":23608,"key":23608,"name":"5d46879e-08b6-3d6f-b093-c89883f8ea45","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/5d46879e-08b6-3d6f-b093-c89883f8ea45\/\u4e2d\u90fd\u7269\u6d41.pdf","orig_name":"\u4e2d\u90fd\u7269\u6d41.pdf"}}],"receiptScans":[{"id":28836,"object_type":106,"object_id":3547,"attachment_id":21603,"attachment":{"id":21603,"key":21603,"name":"207c6494-1b11-3577-aa1f-7aefbc13848b","extension":"jpeg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/207c6494-1b11-3577-aa1f-7aefbc13848b\/WechatIMG280.jpeg","orig_name":"WechatIMG280.jpeg"}}],"verifyScans":[],"erpCollectTickets":[{"id":146,"serial_no":"SKD-20241023-00001","wrote_date":"2024-10-23","from_date":null,"handler":1004,"user_id":null,"client_id":48,"sales_contract_id":3547,"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-10-23 17:15:46","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"7600","settle_amount":"7600","created_by":1013,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2024-10-23 17:15:46","updated_at":"2024-10-23 17:15:46","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1146","key":"1146","contract_id":3547,"value":"7600","created_by":1013,"collected_date":"2024-10-23 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1810,"key":1810,"contract_id":3547,"value":"7600.00","attachment_id":null,"from_date":"2024-09-26","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2041,"key":2041,"contract_id":3547,"name":"2024-10-31","value":"7600","overdue_days":null,"status":1,"remind_date":"2024-10-31","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":6953,"user_id":1004,"key":1004,"contract_id":3547,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},{"id":6955,"user_id":1001,"key":1001,"contract_id":3547,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"salesSupplierRels":[{"id":1957,"contract_id":3547,"supplier_id":165,"purchase_id":3561,"supplier":{"id":165,"key":165,"name":"\u5317\u4eac\u7eb3\u6069\u6052\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3561,"key":3561,"serial_no":"20240918"}}],"payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","invoiced":7600},"projectRemindReceivers":[],"projectProductRels":[{"id":7167,"project_id":3658,"product_id":1780,"amount":"3800","number":2,"cost":"800","description":"\u4e8c\u624b\u914d\u4ef6,9.5\u6210\u65b0","supplier_id":165,"hardware_from":"2024-09-18","software_from":null,"maintenance_from":null,"hardware_to":"2025-09-17","software_to":null,"maintenance_to":null,"total_amount":"7600","total_cost":"1600","erp_sales_order_product_id":1227,"supplier":{"id":165,"key":165,"name":"\u5317\u4eac\u7eb3\u6069\u6052\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1780,"name":"X343A-R6","product_type":3,"product_component":15,"product_brand":6,"product_serie":1149,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-09-18 10:38:23","updated_at":"2026-03-03 09:37:09","pinyin_shortcut":"X343AR6","product_unit":3,"is_renew":false,"in_out_at":"2026-03-03 09:37:09.013419+08","productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":6,"key":6,"name":"NetApp"},"productSerie":{"id":1149,"key":1149,"name":"1.8T 10K 2.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1227,"erp_sales_order_id":1351,"erp_store_id":null,"product_id":1780,"description":"\u4e8c\u624b\u914d\u4ef6,9.5\u6210\u65b0","number":"2","outbound":"0","amount":"3800","total_amount":"7600","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"800","total_cost":"1600","supplier_id":165,"hardware_from":"2024-09-18","software_from":null,"maintenance_from":null,"hardware_to":"2025-09-17","software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3658,"comment":5},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1351,"serial_no":"XSDD-20241023-00001","from_date":null,"wrote_date":"2024-09-23","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3658,"sales_contract_id":3547,"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-10-23 17:15:47","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"2","amount":"7600","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-09-18 09:31:24","updated_at":"2024-10-23 17:15:47","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":663,"progress_remain_display":663,"forecast_remain_display":663,"projectProductTotalAmount":7600,"projectProductAllAmount":true,"projectProductTotalCost":1600,"projectProductAllCost":true,"projectProductTotalNumber":2,"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":35,"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":"7600","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":3582,"client_id":48,"project_status":3,"project_progress":6,"budget":"23951","profit_pct":"31.43","bargain_date":"2024-07-08","description":"","created_by":1004,"created_at":"2024-06-30 17:37:46","updated_at":"2025-09-10 11:23:32","engineer_id":null,"project_title":"2024\u6df1\u4fe1\u670d\u4ea7\u54c1\u7eed\u4fdd","collected":"23951","status_updated_at":"2024-07-04 11:03:26.805972+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-06-30 17:37:46.986087+08","forecast_updated_at":"2024-07-05 15:00:32.022344+08","end_at":"2024-07-15 10:23:01","pinyin_shortcut":"2024sxfcpxb","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":472,"is_sales_order_ready":true,"collected_plan":23951,"change_status_to":null,"is_verify":false,"profits":"7527.799300000000000000","remain":"739 days 03:04:29.260746","progress_remain":"742 days 20:30:09.080631","forecast_remain":"737 days 23:07:24.044374","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"14 days 16:45:14.372327","issued_invoices":"23951.00","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"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":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"23951","pct":"31.43","profit":"7527.7993","project_id":3582}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":{"project_id":3582,"points":"275"},"workLogCount":null,"caseCount":{"project_id":3582,"count":4},"salesTimeCount":null,"implementTimeCount":{"project_id":3582,"sum":"5.5","times":"4"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3385,"from_project":3582,"payment_collection_remind_ahead":"1 day","serial_no":"TS-YJC-2024062602","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"23951","erp_un_settle_amount":"0","including_tax":true,"amount":"23951","contractScans":[{"id":27553,"object_type":105,"object_id":3385,"attachment_id":20172,"attachment":{"id":20172,"key":20172,"name":"f065893f-bf54-3e13-8e09-3d7804b14607","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f065893f-bf54-3e13-8e09-3d7804b14607\/2024_07_09_16_20_31.pdf","orig_name":"2024_07_09_16_20_31.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[{"id":35,"serial_no":"SKD-20240715-00003","wrote_date":"2024-07-15","from_date":null,"handler":1004,"user_id":null,"client_id":48,"sales_contract_id":3385,"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-07-15 10:23:01","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"23951","settle_amount":"23951","created_by":1013,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2024-07-15 10:23:01","updated_at":"2024-07-15 10:23:01","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"135","key":"135","contract_id":3385,"value":"23951","created_by":1013,"collected_date":"2024-07-15 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1706,"key":1706,"contract_id":3385,"value":"23951.00","attachment_id":null,"from_date":"2024-07-04","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1820,"key":1820,"contract_id":3385,"name":"2024-07-26","value":"23951","overdue_days":null,"status":1,"remind_date":"2024-07-26","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":6084,"user_id":1004,"key":1004,"contract_id":3385,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesSupplierRels":[{"id":1607,"contract_id":3385,"supplier_id":236,"purchase_id":3411,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3411,"key":3411,"serial_no":"TSKJ20240715-HYF-002"}}],"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","invoiced":23951},"projectRemindReceivers":[],"projectProductRels":[{"id":5744,"project_id":3582,"product_id":1663,"amount":"3960","number":1,"cost":"2714","description":"","supplier_id":236,"hardware_from":null,"software_from":"2024-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-24","maintenance_to":null,"total_amount":"3960","total_cost":"2714","erp_sales_order_product_id":989,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1663,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09","product_type":22,"product_component":208,"product_brand":12,"product_serie":1414,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-04 15:30:00","updated_at":"2024-07-04 15:30:00","pinyin_shortcut":"URLampyysbgzksjsyyAC1000B1250","product_unit":2,"is_renew":true,"in_out_at":null,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":208,"key":208,"name":"\u4ea7\u54c1\u5347\u7ea7"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1414,"key":1414,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":989,"erp_sales_order_id":1282,"erp_store_id":null,"product_id":1663,"description":"","number":"1","outbound":"0","amount":"3960","total_amount":"3960","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"2714","total_cost":"2714","supplier_id":236,"hardware_from":null,"software_from":"2024-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-24","maintenance_to":null}},{"id":5745,"project_id":3582,"product_id":1664,"amount":"3111","number":1,"cost":"2171","description":"","supplier_id":236,"hardware_from":"2024-07-25","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-24","software_to":null,"maintenance_to":null,"total_amount":"3111","total_cost":"2171","erp_sales_order_product_id":990,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1664,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1415,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-04 15:31:49","updated_at":"2024-07-04 15:31:49","pinyin_shortcut":"sxfcpzbrjsjfwsyyAC1000B1250","product_unit":2,"is_renew":true,"in_out_at":null,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1415,"key":1415,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":990,"erp_sales_order_id":1282,"erp_store_id":null,"product_id":1664,"description":"","number":"1","outbound":"0","amount":"3111","total_amount":"3111","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"2171","total_cost":"2171","supplier_id":236,"hardware_from":"2024-07-25","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-24","software_to":null,"maintenance_to":null}},{"id":5746,"project_id":3582,"product_id":1665,"amount":"4540","number":2,"cost":"2931","description":"","supplier_id":236,"hardware_from":"2024-07-25","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-24","software_to":null,"maintenance_to":null,"total_amount":"9080","total_cost":"5862","erp_sales_order_product_id":991,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1665,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eVPN-1000-B1100\uff09","product_type":22,"product_component":200,"product_brand":12,"product_serie":1416,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-04 15:34:24","updated_at":"2024-07-04 15:34:24","pinyin_shortcut":"sxfcpzbrjsjfwsyyVPN1000B1100","product_unit":2,"is_renew":true,"in_out_at":null,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1416,"key":1416,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7 \u9002\u7528\u4e8e\uff08VPN-1000-B1100\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":991,"erp_sales_order_id":1282,"erp_store_id":null,"product_id":1665,"description":"","number":"2","outbound":"0","amount":"4540","total_amount":"9080","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"2931","total_cost":"5862","supplier_id":236,"hardware_from":"2024-07-25","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-24","software_to":null,"maintenance_to":null}},{"id":5747,"project_id":3582,"product_id":922,"amount":"7800","number":1,"cost":"4000","description":"","supplier_id":236,"hardware_from":null,"software_from":"2024-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-24","maintenance_to":null,"total_amount":"7800","total_cost":"4000","erp_sales_order_product_id":992,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":922,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0EDR\u7eed\u4fdd\u670d\u52a1","product_type":22,"product_component":200,"product_brand":12,"product_serie":1024,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-05-08 12:11:04","updated_at":"2026-01-28 10:32:39","pinyin_shortcut":"sxfzdjcxyptEDRxbfw","product_unit":2,"is_renew":false,"in_out_at":"2026-01-28 10:32:39.333577+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1024,"key":1024,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0EDR\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":992,"erp_sales_order_id":1282,"erp_store_id":null,"product_id":922,"description":"","number":"1","outbound":"0","amount":"7800","total_amount":"7800","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"4000","total_cost":"4000","supplier_id":236,"hardware_from":null,"software_from":"2024-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-24","maintenance_to":null}}],"commentCount":{"object_id":3582,"comment":8},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1282,"serial_no":"XSDD-20240704-00001","from_date":null,"wrote_date":"2024-07-08","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3582,"sales_contract_id":3385,"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-07-15 10:23:01","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"5","amount":"23951","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-07-04 11:03:26","updated_at":"2024-07-15 10:23:01","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":739,"progress_remain_display":742,"forecast_remain_display":737,"projectProductTotalAmount":23951,"projectProductAllAmount":true,"projectProductTotalCost":14747,"projectProductAllCost":true,"projectProductTotalNumber":5,"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":14,"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.4\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":3581,"client_id":48,"project_status":3,"project_progress":6,"budget":"110000","profit_pct":"23.54","bargain_date":"2024-06-26","description":"","created_by":1004,"created_at":"2024-06-30 17:36:39","updated_at":"2025-02-20 17:50:22","engineer_id":null,"project_title":"2024PA\u4ea7\u54c1\u7eed\u4fdd","collected":"110000","status_updated_at":"2024-07-09 16:20:09.675974+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-06-30 17:36:39.692222+08","forecast_updated_at":"2024-06-30 17:36:39.692222+08","end_at":"2024-07-19 14:33:20","pinyin_shortcut":"2024PAcpxb","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":491,"is_sales_order_ready":true,"collected_plan":110000,"change_status_to":null,"is_verify":false,"profits":"25894.000000000000000000","remain":"733 days 21:47:46.390744","progress_remain":"742 days 20:31:16.374496","forecast_remain":"742 days 20:31:16.374496","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"18 days 20:56:40.834344","issued_invoices":"110000.00","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"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":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"110000","pct":"23.54","profit":"25894","project_id":3581}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3395,"from_project":3581,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-YJC-2024062601","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"110000","erp_un_settle_amount":"0","including_tax":true,"amount":"110000","contractScans":[{"id":27554,"object_type":105,"object_id":3395,"attachment_id":20173,"attachment":{"id":20173,"key":20173,"name":"2699cca0-8676-3196-94b5-e7c1a01d059f","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/2699cca0-8676-3196-94b5-e7c1a01d059f\/2024_07_09_16_19_42.pdf","orig_name":"2024_07_09_16_19_42.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[{"id":53,"serial_no":"SKD-20240719-00001","wrote_date":"2024-07-19","from_date":null,"handler":1004,"user_id":null,"client_id":48,"sales_contract_id":3395,"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-07-19 14:33:20","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"110000","settle_amount":"110000","created_by":1013,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2024-07-19 14:33:20","updated_at":"2024-07-19 14:33:20","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"153","key":"153","contract_id":3395,"value":"110000","created_by":1013,"collected_date":"2024-07-19 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1710,"key":1710,"contract_id":3395,"value":"110000.00","attachment_id":null,"from_date":"2024-07-09","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1825,"key":1825,"contract_id":3395,"name":"2024-08-20","value":"110000","overdue_days":null,"status":1,"remind_date":"2024-08-20","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":6085,"user_id":1004,"key":1004,"contract_id":3395,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesSupplierRels":[{"id":1608,"contract_id":3395,"supplier_id":90,"purchase_id":3424,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3424,"key":3424,"serial_no":"X_2024SBQ18387"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":110000},"projectRemindReceivers":[],"projectProductRels":[{"id":5748,"project_id":3581,"product_id":1354,"amount":"20000","number":2,"cost":"11555.2","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":"40000","total_cost":"23110.4","erp_sales_order_product_id":998,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1354,"name":"PAN-PA-850-TP-HA2-R","product_type":5,"product_component":36,"product_brand":8,"product_serie":1026,"product_misc":null,"product_qa":null,"pn":"","description":"Threat prevention subscription for device in an HA pair year 1, PA-850\n","created_by":1013,"created_at":"2024-01-26 13:48:15","updated_at":"2024-01-26 13:52:20","pinyin_shortcut":"PANPA850TPHA2R","product_unit":2,"is_renew":false,"in_out_at":null,"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":1026,"key":1026,"name":"PA850\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":998,"erp_sales_order_id":1286,"erp_store_id":null,"product_id":1354,"description":"","number":"2","outbound":"0","amount":"20000","total_amount":"40000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"11555.2","total_cost":"23110.4","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}},{"id":5749,"project_id":3581,"product_id":1669,"amount":"20000","number":2,"cost":"17333","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":"40000","total_cost":"34666","erp_sales_order_product_id":999,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1669,"name":"PAN-PA-850-AWF-HA2-R","product_type":5,"product_component":36,"product_brand":8,"product_serie":1026,"product_misc":null,"product_qa":null,"pn":"","description":"Advanced WildFire subscription renewal for device in HA pair, PA-850 ","created_by":1013,"created_at":"2024-07-09 16:50:47","updated_at":"2024-07-09 16:50:47","pinyin_shortcut":"PANPA850AWFHA2R","product_unit":2,"is_renew":true,"in_out_at":null,"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":1026,"key":1026,"name":"PA850\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":999,"erp_sales_order_id":1286,"erp_store_id":null,"product_id":1669,"description":"","number":"2","outbound":"0","amount":"20000","total_amount":"40000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"17333","total_cost":"34666","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}},{"id":5750,"project_id":3581,"product_id":1670,"amount":"15000","number":2,"cost":"9965","description":"","supplier_id":90,"hardware_from":"2024-08-01","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-31","software_to":null,"maintenance_to":null,"total_amount":"30000","total_cost":"19930","erp_sales_order_product_id":1000,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1670,"name":"PAN-SVC-BKLN-850-R","product_type":5,"product_component":35,"product_brand":8,"product_serie":210,"product_misc":null,"product_qa":null,"pn":"","description":"Partner enabled premium support renewal, PA-850 ","created_by":1013,"created_at":"2024-07-09 16:51:27","updated_at":"2024-07-09 16:51:27","pinyin_shortcut":"PANSVCBKLN850R","product_unit":2,"is_renew":true,"in_out_at":null,"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":210,"key":210,"name":"PA850\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1000,"erp_sales_order_id":1286,"erp_store_id":null,"product_id":1670,"description":"","number":"2","outbound":"0","amount":"15000","total_amount":"30000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"9965","total_cost":"19930","supplier_id":90,"hardware_from":"2024-08-01","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-31","software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3581,"comment":6},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1286,"serial_no":"XSDD-20240709-00002","from_date":null,"wrote_date":"2024-06-26","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3581,"sales_contract_id":3395,"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-07-19 14:33:20","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"6","amount":"110000","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-07-09 16:20:09","updated_at":"2024-07-19 14:33:20","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":733,"progress_remain_display":742,"forecast_remain_display":742,"projectProductTotalAmount":110000,"projectProductAllAmount":true,"projectProductTotalCost":77706.4,"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":18,"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":"11\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":3556,"client_id":48,"project_status":3,"project_progress":6,"budget":"47204.1","profit_pct":"74.42","bargain_date":"2024-06-25","description":"","created_by":1004,"created_at":"2024-06-03 16:27:44","updated_at":"2025-06-19 17:36:01","engineer_id":null,"project_title":"2024\u5e74\u670d\u52a1\u5668\u53ca\u5b58\u50a8\u8fd0\u7ef4\u670d\u52a1","collected":"47204.1","status_updated_at":"2024-06-26 15:25:34.691733+08","success_rate":null,"comment":"","contract_type":2,"progress_updated_at":"2024-06-15 21:35:05.581025+08","forecast_updated_at":"2024-06-15 21:35:05.581025+08","end_at":"2024-07-19 15:53:28","pinyin_shortcut":"2024nfwqjccywfw","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":458,"is_sales_order_ready":true,"collected_plan":47204.1,"change_status_to":null,"is_verify":false,"profits":"35129.291220000000000000","remain":"746 days 22:42:21.374985","progress_remain":"757 days 16:32:50.485693","forecast_remain":"757 days 16:32:50.485693","lost_contact_days":"746.956898920347","last_contact":"2024-06-26 15:10:00","last_arrive_days":null,"last_arrive":null,"duration":"45 days 23:25:44.317365","issued_invoices":"47204.10","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"usedClient":null,"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[{"project_id":3556,"value":"1","key":1023,"name":"\u5468\u5b50\u5065"}],"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":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"47204.10","pct":"74.42","profit":"35129.29122","project_id":3556}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":{"project_id":3556,"points":"388"},"workLogCount":{"project_id":3556,"count":1},"caseCount":{"project_id":3556,"count":6},"salesTimeCount":null,"implementTimeCount":{"project_id":3556,"sum":"11.8833333333333","times":"6"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3556,"sum":"312.77"},"buildContract":{"id":3366,"from_project":3556,"payment_collection_remind_ahead":"7 days","serial_no":"TS-YJC-2024061301","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"47204.1","erp_un_settle_amount":"0","including_tax":true,"amount":"47204.1","contractScans":[{"id":31371,"object_type":105,"object_id":3366,"attachment_id":19979,"attachment":{"id":19979,"key":19979,"name":"f9a5630f-1384-37d7-a265-de60fa0fdea9","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f9a5630f-1384-37d7-a265-de60fa0fdea9\/\u4e2d\u90fd.pdf","orig_name":"\u4e2d\u90fd.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[{"id":57,"serial_no":"SKD-20240719-00004","wrote_date":"2024-07-19","from_date":null,"handler":1004,"user_id":null,"client_id":48,"sales_contract_id":3366,"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-07-19 15:53:28","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"47204.1","settle_amount":"47204.1","created_by":1013,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2024-07-19 15:53:28","updated_at":"2024-07-19 15:53:28","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"157","key":"157","contract_id":3366,"value":"47204.1","created_by":1013,"collected_date":"2024-07-19 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1698,"key":1698,"contract_id":3366,"value":"47204.10","attachment_id":null,"from_date":"2024-07-01","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2225,"key":2225,"contract_id":3366,"name":"2024-12-26","value":"47204.1","overdue_days":null,"status":1,"remind_date":"2024-12-26","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":7493,"user_id":1004,"key":1004,"contract_id":3366,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},{"id":7495,"user_id":1001,"key":1001,"contract_id":3366,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"salesSupplierRels":[{"id":2269,"contract_id":3366,"supplier_id":116,"purchase_id":3722,"supplier":{"id":116,"key":116,"name":"\u56db\u5ddd\u957f\u8679\u4f73\u534e\u4fe1\u606f\u4ea7\u54c1\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"purchase":{"id":3722,"key":3722,"serial_no":"20241224001"}}],"payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","invoiced":47204.1},"projectRemindReceivers":[],"projectProductRels":[{"id":8242,"project_id":3556,"product_id":941,"amount":"21157.6","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2024-07-14","hardware_to":null,"software_to":null,"maintenance_to":"2025-07-13","total_amount":"21157.6","total_cost":"0","erp_sales_order_product_id":972,"supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2026-02-05 16:37:56","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-02-05 16:37:56.557723+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":972,"erp_sales_order_id":1272,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"0","amount":"21157.6","total_amount":"21157.6","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":"2024-07-14","hardware_to":null,"software_to":null,"maintenance_to":"2025-07-13"}},{"id":8243,"project_id":3556,"product_id":1376,"amount":"5209.3","number":5,"cost":"1500","description":"","supplier_id":116,"hardware_from":"2024-08-08","software_from":null,"maintenance_from":null,"hardware_to":"2025-08-07","software_to":null,"maintenance_to":null,"total_amount":"26046.5","total_cost":"7500","erp_sales_order_product_id":973,"supplier":{"id":116,"key":116,"name":"\u56db\u5ddd\u957f\u8679\u4f73\u534e\u4fe1\u606f\u4ea7\u54c1\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"product":{"id":1376,"name":"CBSOMA11M","product_type":2,"product_component":13,"product_brand":4,"product_serie":1052,"product_misc":null,"product_qa":null,"pn":"","description":"\u8054\u60f3\u539f\u5382\u4e00\u5e745*9\u670d\u52a1","created_by":1001,"created_at":"2024-01-26 17:55:26","updated_at":"2025-10-29 17:37:40","pinyin_shortcut":"CBSOMA11M","product_unit":8,"is_renew":false,"in_out_at":"2025-10-29 17:37:40.337224+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":13,"key":13,"name":"\u670d\u52a1\u5668\u91d1\u724c\u670d\u52a1"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1052,"key":1052,"name":"SR650\u670d\u52a1\u5668\u4e00\u5e745*9\u539f\u5382\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":973,"erp_sales_order_id":1272,"erp_store_id":null,"product_id":1376,"description":"","number":"5","outbound":"0","amount":"5209.3","total_amount":"26046.5","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"1500","total_cost":"7500","supplier_id":116,"hardware_from":"2024-08-08","software_from":null,"maintenance_from":null,"hardware_to":"2025-08-07","software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3556,"comment":13},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1272,"serial_no":"XSDD-20240626-00003","from_date":null,"wrote_date":"2024-06-25","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3556,"sales_contract_id":3366,"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-07-19 15:53:28","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"6","amount":"47204.1","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-06-26 15:25:34","updated_at":"2024-07-19 15:53:28","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":746,"progress_remain_display":757,"forecast_remain_display":757,"projectProductTotalAmount":47204.1,"projectProductAllAmount":true,"projectProductTotalCost":7500,"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":45,"contract_type_display":"\u8fd0\u7ef4\u670d\u52a1","can_change_status":false,"is_admin":true,"lost_contact_days_display":"2\u5e74\u524d","can_view_product":true,"budget_display":"4.72\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":3543,"client_id":48,"project_status":3,"project_progress":10,"budget":"92000","profit_pct":"14.08","bargain_date":"2024-04-30","description":"","created_by":1004,"created_at":"2024-05-20 14:41:33","updated_at":"2024-07-18 10:10:06","engineer_id":null,"project_title":"\u5b58\u50a8\u6269\u5bb9","collected":"92000","status_updated_at":"2024-05-20 14:44:52.765566+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-05-20 14:41:33.526883+08","forecast_updated_at":"2024-05-20 14:41:33.526883+08","end_at":"2024-09-26 18:06:52","pinyin_shortcut":"cckr","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":403,"is_sales_order_ready":true,"collected_plan":92000,"change_status_to":null,"is_verify":false,"profits":"12953.600000000000000000","remain":"783 days 23:23:03.301152","progress_remain":"783 days 23:26:22.539835","forecast_remain":"783 days 23:26:22.539835","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"129 days 03:25:19.282512","issued_invoices":"92000.00","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3543,"value":"1","key":1023,"name":"\u5468\u5b50\u5065"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"92000.00","pct":"14.08","profit":"12953.6","project_id":3543}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":{"project_id":3543,"points":"63"},"workLogCount":null,"caseCount":{"project_id":3543,"count":1},"salesTimeCount":null,"implementTimeCount":{"project_id":3543,"sum":"0.75","times":"1"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3299,"from_project":3543,"payment_collection_remind_ahead":"7 days","serial_no":"TS-YJC-2024043019","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"92000","erp_un_settle_amount":"0","including_tax":true,"amount":"92000","contractScans":[{"id":26284,"object_type":105,"object_id":3299,"attachment_id":19258,"attachment":{"id":19258,"key":19258,"name":"37cd5dc2-81d3-3a71-ac3d-57866cb76207","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/37cd5dc2-81d3-3a71-ac3d-57866cb76207\/\u4e2d\u90fd\u5408\u540c.pdf","orig_name":"\u4e2d\u90fd\u5408\u540c.pdf"}}],"receiptScans":[{"id":26041,"object_type":106,"object_id":3299,"attachment_id":19377,"attachment":{"id":19377,"key":19377,"name":"7ea061a1-ac1a-3875-9733-c96ca8557d50","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/7ea061a1-ac1a-3875-9733-c96ca8557d50\/2024_05_22_11_18_36.pdf","orig_name":"2024_05_22_11_18_36.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":76,"serial_no":"SKD-20240926-00001","wrote_date":"2024-09-26","from_date":null,"handler":1004,"user_id":null,"client_id":48,"sales_contract_id":3299,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":"\u627f\u5151\u6c47\u7968\uff0c\u5230\u671f\u65e52024\u5e749\u670826\u65e5","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2024-09-26 18:06:52","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"92000","settle_amount":"92000","created_by":5388,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2024-09-26 18:06:52","updated_at":"2024-09-26 18:06:52","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"176","key":"176","contract_id":3299,"value":"92000","created_by":5388,"collected_date":"2024-09-26 00:00:00","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1677,"key":1677,"contract_id":3299,"value":"92000.00","attachment_id":null,"from_date":"2024-06-05","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1663,"key":1663,"contract_id":3299,"name":"2024-07-19","value":"92000","overdue_days":69,"status":1,"remind_date":"2024-07-19","pct":100,"overdue_display":"\u903e\u671f69\u5929"}],"salesContractPaymentCollectionRemindReceivers":[{"id":5290,"user_id":1004,"key":1004,"contract_id":3299,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},{"id":5292,"user_id":1001,"key":1001,"contract_id":3299,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"salesSupplierRels":[{"id":1427,"contract_id":3299,"supplier_id":598,"purchase_id":3292,"supplier":{"id":598,"key":598,"name":"\u5317\u4eac\u94f6\u65af\u6cf0\u7ecf\u8d38\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"purchase":{"id":3292,"key":3292,"serial_no":"2024051401"}}],"payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","invoiced":92000},"projectRemindReceivers":[],"projectProductRels":[{"id":5028,"project_id":3543,"product_id":1620,"amount":"92000","number":1,"cost":"75000","description":"","supplier_id":598,"hardware_from":"2024-05-20","software_from":null,"maintenance_from":null,"hardware_to":"2025-05-19","software_to":null,"maintenance_to":null,"total_amount":"92000","total_cost":"75000","erp_sales_order_product_id":896,"supplier":{"id":598,"key":598,"name":"\u5317\u4eac\u94f6\u65af\u6cf0\u7ecf\u8d38\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"product":{"id":1620,"name":"DS224C(1.8TB*20\u5757\u786c\u76d8)","product_type":3,"product_component":17,"product_brand":6,"product_serie":1147,"product_misc":null,"product_qa":null,"pn":"","description":"FAS2750\u6269\u5c55\u67dcDS224C+20\u57571.8TB\uff0c\u542b5M SAS\u8fde\u63a5\u7ebf\u7f06","created_by":1013,"created_at":"2024-05-20 14:49:53","updated_at":"2024-05-20 14:50:18","pinyin_shortcut":"DS224C18TB20kyp","product_unit":2,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":17,"key":17,"name":"\u5b58\u50a8\u6269\u5c55\u67dc"},"productBrand":{"id":6,"key":6,"name":"NetApp"},"productSerie":{"id":1147,"key":1147,"name":"Netapp DS224C\u6269\u5c55\u67dc"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":896,"erp_sales_order_id":1246,"erp_store_id":null,"product_id":1620,"description":"","number":"1","outbound":"0","amount":"92000","total_amount":"92000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"75000","total_cost":"75000","supplier_id":598,"hardware_from":"2024-05-20","software_from":null,"maintenance_from":null,"hardware_to":"2025-05-19","software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3543,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1246,"serial_no":"XSDD-20240926-00001","from_date":null,"wrote_date":"2024-04-30","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3543,"sales_contract_id":3299,"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-26 18:06:52","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"92000","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-05-20 14:44:52","updated_at":"2024-09-26 18:06:52","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":783,"progress_remain_display":783,"forecast_remain_display":783,"projectProductTotalAmount":92000,"projectProductAllAmount":true,"projectProductTotalCost":75000,"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":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":129,"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":"9.2\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]}],"pagenation":{"totalcount":56,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"39.156.194.178","ua":"jinchangxiao\/2.3.176 (HUAWEIVOG-AL00; Android 10)"}', FALSE, '2026-07-13 14:07:56', 206822144) RETURNING "id" |