6870b560a5aee: POST https://beta.jinchangxiao.com/v2/sales-contract/list at 2025-07-11 02:55:28 pm by 223.104.40.121
Log Messages
总计89条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 14:55:28.678 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 14:55:28.678 | trace | yii\base\Module::getModule | Loading module: debug |
| 14:55:28.678 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 14:55:28.678 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 14:55:28.678 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 14:55:28.678 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:55:28.679 | trace | yii\base\Module::getModule | Loading module: gii |
| 14:55:28.679 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 14:55:28.679 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 14:55:28.679 | trace | yii\web\Application::handleRequest | Route requested: 'v2/sales-contract/list' |
| 14:55:28.679 | trace | yii\base\Module::getModule | Loading module: v2 |
| 14:55:28.679 | info | yii\web\Session::open | Session started |
| 14:55:28.680 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 14:55:28.682 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH' |
| 14:55:28.684 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:55:28.685 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:55:28.685 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:55:28.685 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:55:28.685 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 14:55:28.686 | trace | yii\base\Controller::runAction | Route to run: v2/sales-contract/list |
| 14:55:28.687 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:55:28.687 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 14:55:28.687 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\SalesContractController::actionList() |
| 14:55:28.687 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:55:28.687 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:55:28.688 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:55:28.689 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:55:28.690 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE (true) AND ("client"."sales_rep"='5329') AND ("client"."sales_rep"='5329') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c" |
| 14:55:28.696 | info | yii\db\Command::query | SELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE (true) AND ("client"."sales_rep"='5329') AND ("client"."sales_rep"='5329') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10 |
| 14:55:28.701 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2715, 2708, 576, 2218, 2148, 1128) |
| 14:55:28.702 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5329 |
| 14:55:28.702 | 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"=5329) |
| 14:55:28.703 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "orig_name", "extension", "path" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (9654, 8715, 7612) |
| 14:55:28.707 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "orig_name", "extension", "path" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (9655, 7791) |
| 14:55:28.708 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5359, 1004, 5329, 1005, 5299, 5294) |
| 14:55:28.709 | 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 (5299, 5329, 5359, 1005, 1004, 5294)) |
| 14:55:28.709 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
| 14:55:28.709 | info | yii\db\Command::query | SELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (3183, 3088, 2980, 2950, 2938, 2479, 2429, 2212, 2104, 1989)) GROUP BY "object_id" |
| 14:55:28.728 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3475, 3400, 3383, 3368, 3362, 2979, 2942, 2763, 2658, 2547) |
| 14:55:28.735 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name", "description", "total_contact_point", "paid_contact_point", "is_sales_order_ready", "project_product_version_id", "bargain_date", "collected", "profit_pct", "budget" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3475, 3400, 3383, 3368, 3362, 2979, 2942, 2763, 2658, 2547) |
| 14:55:28.736 | info | yii\db\Command::query | SELECT "id", "product_type_id", "product_type_id" AS "key", "name", "budget", "pct", "project_id", "profit" FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (2763, 3362, 2979, 3475, 2658, 3368, 3383, 3400, 2547, 2942) |
| 14:55:28.737 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (2763, 3362, 2979, 3475, 2658, 3368, 3383, 3400, 2547, 2942) |
| 14:55:28.738 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=560 |
| 14:55:28.738 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1085, 941, 1335) |
| 14:55:28.740 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (19, 11) |
| 14:55:28.741 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (151, 179) |
| 14:55:28.741 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (133, 121) |
| 14:55:28.741 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (592, 707, 1005) |
| 14:55:28.743 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (7, 3, 4) |
| 14:55:28.743 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (2763, 3362, 2979, 3475, 2658, 3368, 3383, 3400, 2547, 2942) |
| 14:55:28.744 | info | yii\db\Command::query | SELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (2763, 3362, 2979, 3475, 2658, 3368, 3383, 3400, 2547, 2942)) |
| 14:55:28.746 | info | yii\db\Command::query | SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (3, 2)) AND ("project_id" IN (2763, 3362, 2979, 3475, 2658, 3368, 3383, 3400, 2547, 2942)) GROUP BY "project_id" |
| 14:55:28.748 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (3183, 3088, 2980, 2950, 2938, 2479, 2429, 2212, 2104, 1989) |
| 14:55:28.749 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (174, 137, 560, 68, 460, 659, 107) |
| 14:55:28.749 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (2451, 1984, 2936, 3185, 2442, 2982, 2953, 2510, 3089, 2120, 2512, 2485) |
| 14:55:28.757 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2) |
| 14:55:28.757 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5359, 1004, 5329, 1005, 5299, 5294) |
| 14:55:28.758 | 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 (5299, 5329, 5359, 1005, 1004, 5294)) |
| 14:55:28.758 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("reminded"=FALSE) AND ("contract_id" IN (3183, 3088, 2980, 2950, 2938, 2479, 2429, 2212, 2104, 1989)) ORDER BY "remind_date" |
| 14:55:28.758 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id" IN (3183, 3088, 2980, 2950, 2938, 2479, 2429, 2212, 2104, 1989) |
| 14:55:28.759 | info | yii\db\Command::query | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (3183, 3088, 2980, 2950, 2938, 2479, 2429, 2212, 2104, 1989) |
| 14:55:28.759 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5329) |
| 14:55:28.760 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 5329)) |
| 14:55:28.760 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (3183, 3088, 2980, 2950, 2938, 2479, 2429, 2212, 2104, 1989) |
| 14:55:28.760 | 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 (3183, 3088, 2980, 2950, 2938, 2479, 2429, 2212, 2104, 1989) |
| 14:55:28.761 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5329, 1004) |
| 14:55:28.761 | 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 (5329, 1005, 1004)) |
| 14:55:28.762 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (3183, 3088, 2980, 2950, 2938, 2479, 2429, 2212, 2104, 1989) ORDER BY "remind_date" |
| 14:55:28.762 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "created_at", "description", "collected_date", "amount" FROM "a57be577deb434"."tbl_sales_contract_payments" WHERE "contract_id" IN (3183, 3088, 2980, 2950, 2938, 2479, 2429, 2212, 2104, 1989) ORDER BY "id" |
| 14:55:28.763 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1014, 1013) |
| 14:55:28.763 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=109) AND ("object_id" IN (1263, 1297, 1307, 1411, 1439, 1479, 1686, 1687, 1707, 1767, 1812)) |
| 14:55:28.764 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (16508, 17458, 18452) |
| 14:55:28.768 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (3183, 3088, 2980, 2950, 2938, 2479, 2429, 2212, 2104, 1989) ORDER BY "id" |
| 14:55:28.769 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (7614, 8624) |
| 14:55:28.770 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (1065, 1127, 1176, 1277, 1306, 1529, 1539, 1550, 1589, 1619)) |
| 14:55:28.771 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (1065, 1127, 1176, 1277, 1306, 1529, 1539, 1550, 1589, 1619)) |
| 14:55:28.773 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (9656, 7614, 8624, 11135, 11397, 16103, 16213, 16420, 17349, 18310) |
| 14:55:28.779 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (3183, 3088, 2980, 2950, 2938, 2479, 2429, 2212, 2104, 1989)) |
| 14:55:28.780 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (8715, 7612, 9654, 11137, 11396, 16127, 16399, 16246, 17296, 18335) |
| 14:55:28.783 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (3183, 3088, 2980, 2950, 2938, 2479, 2429, 2212, 2104, 1989)) |
| 14:55:28.784 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (7791, 9672, 11293, 16218, 16236, 16458, 17379, 18347) |
| 14:55:28.787 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (3183, 3088, 2980, 2950, 2938, 2479, 2429, 2212, 2104, 1989)) |
| 14:55:28.788 | info | yii\db\Command::query | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=7) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (3183, 3088, 2980, 2950, 2938, 2479, 2429, 2212, 2104, 1989)) GROUP BY "object_id" |
| 14:55:28.804 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: viewProduct |
| 14:55:28.804 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Accountant |
| 14:55:28.804 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 14:55:28.805 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:55:28.805 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:55:28.805 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 2, 1141, 'v2/sales-contract/list', '{"Filter":{"name":"","sort":""},"SalesContractSearch":{"contract_type":"","handler":"5329"},"access_token":"oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH","device_type":"2","posttime":"1752216960","token":"e1177c130b0fd153f3c5a054888572c1","version_code":"1141"}', '{"code":200,"data":{"list":[{"id":3183,"client_id":2715,"signed_at":"2024-03-18","amount":"620","handler":5359,"description":"","created_by":5359,"created_at":"2024-03-18 17:12:04","updated_at":"2024-04-03 15:57:30","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3475,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-ZHR-2024031801","payment_collection_remind_ahead":"","from_project":3475,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":null,"b_date":null,"passed":1,"client":{"id":2715,"key":2715,"name":"\u4e2d\u5171\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u59d4\u653f\u6cd5\u59d4\u5458\u4f1a","logo":null,"sales_rep":5329,"salesRep":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5359,"key":5359,"name":"\u5f20\u6d69\u7136","sex":"M","department_id":1,"avatar":{"id":152,"user_id":5359,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f72d857a-546f-314b-aca7-026822e84cd2.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3183,"comment":7},"project":{"id":3475,"key":3475,"name":"\u6e05\u534e\u540c\u65b9\u8fc7\u4fdd\u7ef4\u4fee\uff0c\u663e\u5361"},"fromProject":{"id":3475,"key":3475,"name":"\u6e05\u534e\u540c\u65b9\u8fc7\u4fdd\u7ef4\u4fee\uff0c\u663e\u5361","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":299,"bargain_date":"2024-03-18","collected":"620","profit_pct":"36.59","budget":"620","projectProductTypes":[{"id":2731,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"620.00","pct":"36.59","project_id":3475,"profit":"226.858"}],"projectProductRels":[{"id":4092,"project_id":3475,"product_id":1335,"amount":"620","number":1,"cost":"345","description":"","supplier_id":560,"hardware_from":"2024-03-19","software_from":null,"maintenance_from":null,"hardware_to":"2024-03-19","software_to":null,"maintenance_to":null,"total_amount":"620","total_cost":"345","supplier":{"id":560,"key":560,"name":"\u5e7f\u5dde\u4e2d\u601d\u8a89\u6052\u79d1\u6280\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"product":{"id":1335,"name":"Radeon 520 1G 64B D3 VHM LP","product_type":11,"product_component":179,"product_brand":121,"product_serie":1005,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-01-24 14:25:47","updated_at":"2024-02-22 17:15:59","pinyin_shortcut":"Radeon5201G64BD3VHMLP","product_unit":4,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":121,"key":121,"name":"\u6e05\u534e\u540c\u65b9"},"productSerie":{"id":1005,"key":1005,"name":"\u6e05\u534e\u540c\u65b9Radeon 520 1G 64B D3 VHM LP\u663e\u5361"},"productUnit":{"id":4,"key":4,"name":"\u5757"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":8965,"project_id":3475}],"reimbursementAmountSum":{"project_id":3475,"sum":"58.31"},"profit":226.858,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":483,"contract_id":3183,"supplier_id":560,"purchase_id":3185,"supplier":{"id":560,"key":560,"name":"\u5e7f\u5dde\u4e2d\u601d\u8a89\u6052\u79d1\u6280\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchase":{"id":3185,"key":3185,"serial_no":"TSKJ20240318-ZHF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5359,"key":5359,"name":"\u5f20\u6d69\u7136","sex":"M","department_id":1,"avatar":{"id":152,"user_id":5359,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f72d857a-546f-314b-aca7-026822e84cd2.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8092,"user_id":5329,"key":5329,"contract_id":3183,"user":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[{"id":1560,"key":1560,"contract_id":3183,"name":"2024-03-31","value":"620","overdue_days":2,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1812,"key":1812,"contract_id":3183,"value":"620","created_by":1013,"created_at":"2024-04-02 16:33:35","description":"","collected_date":"2024-04-02","amount":"620","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":24913,"object_type":109,"object_id":1812,"attachment_id":18452,"attachment":{"id":18452,"key":18452,"name":"a2b9e945-caff-361c-b454-4cd229ef008b","extension":"png","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/a2b9e945-caff-361c-b454-4cd229ef008b\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1619,"key":1619,"contract_id":3183,"value":"620.00","attachment_id":null,"from_date":"2024-03-25","description":"","is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":24761,"object_type":102,"object_id":1619,"attachment_id":18310,"attachment":{"id":18310,"key":18310,"name":"be4ee766-626d-3576-8766-4c02c583a9ff","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/be4ee766-626d-3576-8766-4c02c583a9ff\/dzfp_24112000000013882332_\u4e2d\u5171\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u59d4\u653f\u6cd5\u59d4\u5458\u4f1a_20240326093110.pdf","orig_name":"dzfp_24112000000013882332_\u4e2d\u5171\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u59d4\u653f\u6cd5\u59d4\u5458\u4f1a_20240326093110.pdf"}}]}],"contractScans":[{"id":24934,"object_type":105,"object_id":3183,"attachment_id":18335,"attachment":{"id":18335,"key":18335,"name":"b6ffaab5-9d19-3fdd-a6f5-861d829d8e3a","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/b6ffaab5-9d19-3fdd-a6f5-861d829d8e3a\/2024_03_26_13_51_15.pdf","orig_name":"2024_03_26_13_51_15.pdf"}}],"receiptScans":[{"id":24796,"object_type":106,"object_id":3183,"attachment_id":18347,"attachment":{"id":18347,"key":18347,"name":"5eeaffac-8e81-3c67-903e-86533bd027a0","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/5eeaffac-8e81-3c67-903e-86533bd027a0\/2024_03_26_16_36_04.pdf","orig_name":"2024_03_26_16_36_04.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":620,"projectProductTotalAmount":620,"projectProductAllAmount":true,"projectProductTotalCost":345,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":620,"un_invoiced":0,"collected":620,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3088,"client_id":2708,"signed_at":"2024-01-17","amount":"920","handler":5359,"description":"","created_by":5359,"created_at":"2024-01-17 09:46:38","updated_at":"2024-02-19 15:44:40","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3400,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-ZHR-2024011701","payment_collection_remind_ahead":"","from_project":3400,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":null,"b_date":null,"passed":1,"client":{"id":2708,"key":2708,"name":"\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u6559\u80b2\u59d4\u5458\u4f1a","logo":null,"sales_rep":5329,"salesRep":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5359,"key":5359,"name":"\u5f20\u6d69\u7136","sex":"M","department_id":1,"avatar":{"id":152,"user_id":5359,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f72d857a-546f-314b-aca7-026822e84cd2.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3088,"comment":3},"project":{"id":3400,"key":3400,"name":"\u8fc7\u4fdd\u7ef4\u4fee"},"fromProject":{"id":3400,"key":3400,"name":"\u8fc7\u4fdd\u7ef4\u4fee","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":3,"bargain_date":"2024-01-17","collected":"920","profit_pct":"34.29","budget":"920","projectProductTypes":[{"id":2242,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"920.00","pct":"34.29","project_id":3400,"profit":"315.468"}],"projectProductRels":[{"id":3397,"project_id":3400,"product_id":1085,"amount":"620","number":1,"cost":"350","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"620","total_cost":"350","supplier":null,"product":{"id":1085,"name":"R7 340 1G D3 64B V+H LP","product_type":11,"product_component":179,"product_brand":121,"product_serie":707,"product_misc":null,"product_qa":null,"pn":"","description":"R7 340 1G D3 64B V+H LP\u663e\u5361\u7693\u7a0bHynix","created_by":1013,"created_at":"2023-11-16 15:19:10","updated_at":"2024-02-22 17:16:20","pinyin_shortcut":"R73401GD364BVHLP","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":121,"key":121,"name":"\u6e05\u534e\u540c\u65b9"},"productSerie":{"id":707,"key":707,"name":"\u6e05\u534e\u540c\u65b9R7 340 1G D3 64B\u663e\u5361"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"id":3398,"project_id":3400,"product_id":941,"amount":"300","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"300","total_cost":"0","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":"2023-08-11 16:02:47","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"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"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":5358,"project_id":3400},{"id":5359,"project_id":3400}],"reimbursementAmountSum":{"project_id":3400,"sum":"135.58"},"profit":315.468,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":1230,"contract_id":3088,"supplier_id":560,"purchase_id":3089,"supplier":{"id":560,"key":560,"name":"\u5e7f\u5dde\u4e2d\u601d\u8a89\u6052\u79d1\u6280\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchase":{"id":3089,"key":3089,"serial_no":"20240117-HYF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5359,"key":5359,"name":"\u5f20\u6d69\u7136","sex":"M","department_id":1,"avatar":{"id":152,"user_id":5359,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f72d857a-546f-314b-aca7-026822e84cd2.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8091,"user_id":5329,"key":5329,"contract_id":3088,"user":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[{"id":1515,"key":1515,"contract_id":3088,"name":"2024-02-16","value":"920","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1767,"key":1767,"contract_id":3088,"value":"920","created_by":1014,"created_at":"2024-01-29 17:20:20","description":"","collected_date":"2024-01-29","amount":"920","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[{"id":23794,"object_type":109,"object_id":1767,"attachment_id":17458,"attachment":{"id":17458,"key":17458,"name":"45762d1f-0029-3280-9486-279a23f1e275","extension":"png","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/45762d1f-0029-3280-9486-279a23f1e275\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1589,"key":1589,"contract_id":3088,"value":"920.00","attachment_id":null,"from_date":"2024-01-23","description":"","is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":23452,"object_type":102,"object_id":1589,"attachment_id":17349,"attachment":{"id":17349,"key":17349,"name":"b0eb1085-29f6-368e-a8ec-8b8a85c56ff7","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/b0eb1085-29f6-368e-a8ec-8b8a85c56ff7\/dzfp_24112000000002641820_\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u6559\u80b2\u59d4\u5458\u4f1a_20240123170144.pdf","orig_name":"dzfp_24112000000002641820_\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u6559\u80b2\u59d4\u5458\u4f1a_20240123170144.pdf"}}]}],"contractScans":[{"id":23951,"object_type":105,"object_id":3088,"attachment_id":17296,"attachment":{"id":17296,"key":17296,"name":"3790546c-85d4-3ee1-b9d4-47fbc00db69e","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/3790546c-85d4-3ee1-b9d4-47fbc00db69e\/2024_01_22_15_31_35.pdf","orig_name":"2024_01_22_15_31_35.pdf"}}],"receiptScans":[{"id":23617,"object_type":106,"object_id":3088,"attachment_id":17379,"attachment":{"id":17379,"key":17379,"name":"4f4b45a4-3cfe-37fd-9ff2-6635545f9f64","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/4f4b45a4-3cfe-37fd-9ff2-6635545f9f64\/2024_01_24_10_35_51.pdf","orig_name":"2024_01_24_10_35_51.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":920,"projectProductTotalAmount":920,"projectProductAllAmount":true,"projectProductTotalCost":350,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":920,"un_invoiced":0,"collected":920,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":2980,"client_id":2715,"signed_at":"2023-12-04","amount":"920","handler":5359,"description":"","created_by":5359,"created_at":"2023-12-04 15:55:55","updated_at":"2024-01-30 15:52:23","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3383,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-ZHR-2023120403","payment_collection_remind_ahead":"","from_project":3383,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":null,"b_date":null,"passed":1,"client":{"id":2715,"key":2715,"name":"\u4e2d\u5171\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u59d4\u653f\u6cd5\u59d4\u5458\u4f1a","logo":null,"sales_rep":5329,"salesRep":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5359,"key":5359,"name":"\u5f20\u6d69\u7136","sex":"M","department_id":1,"avatar":{"id":152,"user_id":5359,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f72d857a-546f-314b-aca7-026822e84cd2.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2980,"comment":5},"project":{"id":3383,"key":3383,"name":"\u6e05\u534e\u540c\u65b9\u8fc7\u4fdd\u7ef4\u4fee"},"fromProject":{"id":3383,"key":3383,"name":"\u6e05\u534e\u540c\u65b9\u8fc7\u4fdd\u7ef4\u4fee","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":29,"bargain_date":"2023-12-04","collected":"920","profit_pct":"-48.23","budget":"920","projectProductTypes":[{"id":2208,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"920.00","pct":"-48.23","project_id":3383,"profit":"-443.716"}],"projectProductRels":[{"id":2524,"project_id":3383,"product_id":1085,"amount":"620","number":1,"cost":"345","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"620","total_cost":"345","supplier":null,"product":{"id":1085,"name":"R7 340 1G D3 64B V+H LP","product_type":11,"product_component":179,"product_brand":121,"product_serie":707,"product_misc":null,"product_qa":null,"pn":"","description":"R7 340 1G D3 64B V+H LP\u663e\u5361\u7693\u7a0bHynix","created_by":1013,"created_at":"2023-11-16 15:19:10","updated_at":"2024-02-22 17:16:20","pinyin_shortcut":"R73401GD364BVHLP","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":121,"key":121,"name":"\u6e05\u534e\u540c\u65b9"},"productSerie":{"id":707,"key":707,"name":"\u6e05\u534e\u540c\u65b9R7 340 1G D3 64B\u663e\u5361"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"id":2525,"project_id":3383,"product_id":941,"amount":"300","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"300","total_cost":"0","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":"2023-08-11 16:02:47","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"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"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":5649,"project_id":3383},{"id":5650,"project_id":3383}],"reimbursementAmountSum":{"project_id":3383,"sum":"123.64"},"profit":-443.716,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":667,"contract_id":2980,"supplier_id":560,"purchase_id":2982,"supplier":{"id":560,"key":560,"name":"\u5e7f\u5dde\u4e2d\u601d\u8a89\u6052\u79d1\u6280\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchase":{"id":2982,"key":2982,"serial_no":"20231204"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5359,"key":5359,"name":"\u5f20\u6d69\u7136","sex":"M","department_id":1,"avatar":{"id":152,"user_id":5359,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f72d857a-546f-314b-aca7-026822e84cd2.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8088,"user_id":5329,"key":5329,"contract_id":2980,"user":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[{"id":1424,"key":1424,"contract_id":2980,"name":"2023-12-25","value":"920","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1707,"key":1707,"contract_id":2980,"value":"920","created_by":1014,"created_at":"2023-12-12 14:33:03","description":"\u6c47\u6b3e\u4eba\uff1a\u77f3\u666f\u5c71\u533a\u673a\u5173\u4e8b\u52a1\u7ba1\u7406\u670d\u52a1\u4e2d\u5fc3","collected_date":"2023-12-12","amount":"920","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[{"id":22297,"object_type":109,"object_id":1707,"attachment_id":16508,"attachment":{"id":16508,"key":16508,"name":"4c1e0249-34bd-3a09-b5a4-cc742a7621e7","extension":"png","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/4c1e0249-34bd-3a09-b5a4-cc742a7621e7\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1550,"key":1550,"contract_id":2980,"value":"920.00","attachment_id":null,"from_date":"2023-12-07","description":"","is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":22204,"object_type":102,"object_id":1550,"attachment_id":16420,"attachment":{"id":16420,"key":16420,"name":"c9dcb69f-f7c3-3ad0-b1d0-766d306cb8b7","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/c9dcb69f-f7c3-3ad0-b1d0-766d306cb8b7\/2023_12_07_15_16_17.pdf","orig_name":"2023_12_07_15_16_17.pdf"}}]}],"contractScans":[{"id":23350,"object_type":105,"object_id":2980,"attachment_id":16399,"attachment":{"id":16399,"key":16399,"name":"6e42f127-aa49-3cf0-8323-d2b755538d96","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/6e42f127-aa49-3cf0-8323-d2b755538d96\/2023_12_07_09_54_58.pdf","orig_name":"2023_12_07_09_54_58.pdf"}}],"receiptScans":[{"id":22242,"object_type":106,"object_id":2980,"attachment_id":16458,"attachment":{"id":16458,"key":16458,"name":"89dca6bb-74ea-3711-b8f7-3025b4b5e705","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/89dca6bb-74ea-3711-b8f7-3025b4b5e705\/2023_12_11_11_28_34.pdf","orig_name":"2023_12_11_11_28_34.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":920,"projectProductTotalAmount":920,"projectProductAllAmount":true,"projectProductTotalCost":345,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":920,"un_invoiced":0,"collected":920,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":2950,"client_id":2715,"signed_at":"2023-11-20","amount":"920","handler":5359,"description":"","created_by":5359,"created_at":"2023-11-20 17:18:44","updated_at":"2024-01-30 15:54:41","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3368,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-ZHR-2023112001","payment_collection_remind_ahead":"","from_project":3368,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":null,"b_date":null,"passed":1,"client":{"id":2715,"key":2715,"name":"\u4e2d\u5171\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u59d4\u653f\u6cd5\u59d4\u5458\u4f1a","logo":null,"sales_rep":5329,"salesRep":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5359,"key":5359,"name":"\u5f20\u6d69\u7136","sex":"M","department_id":1,"avatar":{"id":152,"user_id":5359,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f72d857a-546f-314b-aca7-026822e84cd2.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2950,"comment":3},"project":{"id":3368,"key":3368,"name":"\u6e05\u534e\u540c\u65b9\u7535\u8111\u8fc7\u4fdd\u7ef4\u4fee"},"fromProject":{"id":3368,"key":3368,"name":"\u6e05\u534e\u540c\u65b9\u7535\u8111\u8fc7\u4fdd\u7ef4\u4fee","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":30,"bargain_date":"2023-11-20","collected":"920","profit_pct":"-80.76","budget":"920","projectProductTypes":[{"id":2237,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"920.00","pct":"-80.76","project_id":3368,"profit":"-742.992"}],"projectProductRels":[{"id":3045,"project_id":3368,"product_id":941,"amount":"300","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"300","total_cost":"0","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":"2023-08-11 16:02:47","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"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"}}},{"id":3046,"project_id":3368,"product_id":1085,"amount":"620","number":1,"cost":"345","description":"Radeon 520 1G 64B D3 V+HDMI LP\u663e\u5361\u51cc\u5b9cNANYA \u5347\u7ea7\u663e\u5b58\u9891\u7387","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"620","total_cost":"345","supplier":null,"product":{"id":1085,"name":"R7 340 1G D3 64B V+H LP","product_type":11,"product_component":179,"product_brand":121,"product_serie":707,"product_misc":null,"product_qa":null,"pn":"","description":"R7 340 1G D3 64B V+H LP\u663e\u5361\u7693\u7a0bHynix","created_by":1013,"created_at":"2023-11-16 15:19:10","updated_at":"2024-02-22 17:16:20","pinyin_shortcut":"R73401GD364BVHLP","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":121,"key":121,"name":"\u6e05\u534e\u540c\u65b9"},"productSerie":{"id":707,"key":707,"name":"\u6e05\u534e\u540c\u65b9R7 340 1G D3 64B\u663e\u5361"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":5977,"project_id":3368},{"id":5976,"project_id":3368}],"reimbursementAmountSum":{"project_id":3368,"sum":"101.50"},"profit":-742.992,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":730,"contract_id":2950,"supplier_id":560,"purchase_id":2953,"supplier":{"id":560,"key":560,"name":"\u5e7f\u5dde\u4e2d\u601d\u8a89\u6052\u79d1\u6280\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchase":{"id":2953,"key":2953,"serial_no":"ZSYH20231121"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5359,"key":5359,"name":"\u5f20\u6d69\u7136","sex":"M","department_id":1,"avatar":{"id":152,"user_id":5359,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f72d857a-546f-314b-aca7-026822e84cd2.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8090,"user_id":5329,"key":5329,"contract_id":2950,"user":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[{"id":1401,"key":1401,"contract_id":2950,"name":"2023-12-31","value":"920","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1687,"key":1687,"contract_id":2950,"value":"920","created_by":1014,"created_at":"2023-11-29 15:11:56","description":"\u6c47\u6b3e\u4eba\u540d\u79f0\uff1a\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u673a\u5173\u4e8b\u52a1\u7ba1\u7406\u670d\u52a1\u4e2d\u5fc3","collected_date":"2023-11-29","amount":"920","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[],"pct":100}],"salesContractInvoices":[{"id":1539,"key":1539,"contract_id":2950,"value":"920.00","attachment_id":null,"from_date":"2023-11-24","description":"","is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":21900,"object_type":102,"object_id":1539,"attachment_id":16213,"attachment":{"id":16213,"key":16213,"name":"39d5e734-c230-35a3-a19a-d975549a534c","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/39d5e734-c230-35a3-a19a-d975549a534c\/2023_11_24_09_37_23.pdf","orig_name":"2023_11_24_09_37_23.pdf"}}]}],"contractScans":[{"id":23637,"object_type":105,"object_id":2950,"attachment_id":16246,"attachment":{"id":16246,"key":16246,"name":"680207a8-b3c2-3524-90bc-ccf0df842c14","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/680207a8-b3c2-3524-90bc-ccf0df842c14\/2023_11_28_09_54_15.pdf","orig_name":"2023_11_28_09_54_15.pdf"}}],"receiptScans":[{"id":21947,"object_type":106,"object_id":2950,"attachment_id":16236,"attachment":{"id":16236,"key":16236,"name":"cf267eee-d647-3454-aef0-9300a752f51d","extension":"jpg","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/cf267eee-d647-3454-aef0-9300a752f51d\/33211701075441_.pic_hd.jpg","orig_name":"33211701075441_.pic_hd.jpg"}}],"verifyScans":[],"unreadComments":null,"collected_plan":920,"projectProductTotalAmount":920,"projectProductAllAmount":true,"projectProductTotalCost":345,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":920,"un_invoiced":0,"collected":920,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":2938,"client_id":2708,"signed_at":"2023-11-15","amount":"920","handler":1004,"description":"","created_by":1004,"created_at":"2023-11-16 11:27:26","updated_at":"2024-01-23 11:25:54","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3362,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-YJC-2023111501","payment_collection_remind_ahead":"","from_project":3362,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":null,"b_date":null,"passed":1,"client":{"id":2708,"key":2708,"name":"\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u6559\u80b2\u59d4\u5458\u4f1a","logo":null,"sales_rep":5329,"salesRep":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2938,"comment":3},"project":{"id":3362,"key":3362,"name":"\u540c\u65b9\u914d\u4ef6\u53ca\u7ef4\u4fee"},"fromProject":{"id":3362,"key":3362,"name":"\u540c\u65b9\u914d\u4ef6\u53ca\u7ef4\u4fee","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":28,"bargain_date":"2023-11-15","collected":"920","profit_pct":"45.3","budget":"920","projectProductTypes":[{"id":4342,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"920","pct":"45.3","project_id":3362,"profit":"416.76"}],"projectProductRels":[{"id":2522,"project_id":3362,"product_id":941,"amount":"300","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"300","total_cost":"0","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":"2023-08-11 16:02:47","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"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"}}},{"id":2523,"project_id":3362,"product_id":1085,"amount":"620","number":1,"cost":"420","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"620","total_cost":"420","supplier":null,"product":{"id":1085,"name":"R7 340 1G D3 64B V+H LP","product_type":11,"product_component":179,"product_brand":121,"product_serie":707,"product_misc":null,"product_qa":null,"pn":"","description":"R7 340 1G D3 64B V+H LP\u663e\u5361\u7693\u7a0bHynix","created_by":1013,"created_at":"2023-11-16 15:19:10","updated_at":"2024-02-22 17:16:20","pinyin_shortcut":"R73401GD364BVHLP","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":121,"key":121,"name":"\u6e05\u534e\u540c\u65b9"},"productSerie":{"id":707,"key":707,"name":"\u6e05\u534e\u540c\u65b9R7 340 1G D3 64B\u663e\u5361"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":5974,"project_id":3362},{"id":5973,"project_id":3362}],"reimbursementAmountSum":{"project_id":3362,"sum":"66.72"},"profit":416.76,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":341,"contract_id":2938,"supplier_id":560,"purchase_id":2936,"supplier":{"id":560,"key":560,"name":"\u5e7f\u5dde\u4e2d\u601d\u8a89\u6052\u79d1\u6280\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchase":{"id":2936,"key":2936,"serial_no":"20231115"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8089,"user_id":5329,"key":5329,"contract_id":2938,"user":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":4575,"user_id":1004,"key":1004,"contract_id":2938,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1396,"key":1396,"contract_id":2938,"name":"2023-11-30","value":"920","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1686,"key":1686,"contract_id":2938,"value":"920","created_by":1014,"created_at":"2023-11-28 15:34:07","description":"","collected_date":"2023-11-28","amount":"920","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[],"pct":100}],"salesContractInvoices":[{"id":1529,"key":1529,"contract_id":2938,"value":"920.00","attachment_id":null,"from_date":"2023-11-17","description":"","is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":21762,"object_type":102,"object_id":1529,"attachment_id":16103,"attachment":{"id":16103,"key":16103,"name":"b5c0c266-7656-3718-997d-16ba2415d571","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/b5c0c266-7656-3718-997d-16ba2415d571\/2023_11_17_11_17_45.pdf","orig_name":"2023_11_17_11_17_45.pdf"}}]}],"contractScans":[{"id":23349,"object_type":105,"object_id":2938,"attachment_id":16127,"attachment":{"id":16127,"key":16127,"name":"7182c68e-b30e-3b9b-9cf2-c29806d6c90b","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/7182c68e-b30e-3b9b-9cf2-c29806d6c90b\/2023_11_20_11_14_52.pdf","orig_name":"2023_11_20_11_14_52.pdf"}}],"receiptScans":[{"id":21915,"object_type":106,"object_id":2938,"attachment_id":16218,"attachment":{"id":16218,"key":16218,"name":"25e75076-4a7f-3299-a404-37356b1016c7","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/25e75076-4a7f-3299-a404-37356b1016c7\/2023_11_27_09_37_54.pdf","orig_name":"2023_11_27_09_37_54.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":920,"projectProductTotalAmount":920,"projectProductAllAmount":true,"projectProductTotalCost":420,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":920,"un_invoiced":0,"collected":920,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":2479,"client_id":576,"signed_at":"2022-10-31","amount":"18500","handler":5329,"description":"\u7eed\u4fdd\u4e00\u5e74","created_by":5329,"created_at":"2022-11-11 10:53:08","updated_at":"2022-12-30 16:09:32","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":2979,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-GZ-2022103149","payment_collection_remind_ahead":"","from_project":2979,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":null,"b_date":null,"passed":1,"client":{"id":576,"key":576,"name":"\u4e2d\u4ea4\u4e00\u516c\u5c40\u7b2c\u4e00\u5de5\u7a0b\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5329,"salesRep":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2479,"comment":1},"project":{"id":2979,"key":2979,"name":"veeam\u7eed\u4fdd2022"},"fromProject":{"id":2979,"key":2979,"name":"veeam\u7eed\u4fdd2022","description":"\u7eed\u4fdd\u4e00\u5e74","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2022-10-31","collected":"18500","profit_pct":"43.34","budget":"18500","projectProductTypes":[{"id":3133,"product_type_id":65,"key":65,"name":"\u5546\u4e1a\u8f6f\u4ef6","budget":"18500","pct":"43.34","project_id":2979,"profit":"8017.9"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":8017.9,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2044,"contract_id":2479,"supplier_id":659,"purchase_id":2485,"supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"purchase":{"id":2485,"key":2485,"serial_no":"XM20221111000121"}}],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":3489,"user_id":5329,"key":5329,"contract_id":2479,"user":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1081,"key":1081,"contract_id":2479,"name":"2023-01-11","value":"18500","overdue_days":19,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1479,"key":1479,"contract_id":2479,"value":"18500","created_by":1014,"created_at":"2023-01-30 09:52:54","description":null,"collected_date":"2023-01-30","amount":"18500","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[],"pct":100}],"salesContractInvoices":[{"id":1306,"key":1306,"contract_id":2479,"value":"18500.00","attachment_id":null,"from_date":"2022-11-11","description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":16527,"object_type":102,"object_id":1306,"attachment_id":11397,"attachment":{"id":11397,"key":11397,"name":"69ee8da3-5c5f-3066-9417-bc3c54656465","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/69ee8da3-5c5f-3066-9417-bc3c54656465\/2022_11_11_13_52_37.pdf","orig_name":"2022_11_11_13_52_37.pdf"}}]}],"contractScans":[{"id":17018,"object_type":105,"object_id":2479,"attachment_id":11396,"attachment":{"id":11396,"key":11396,"name":"2925d49b-6840-383a-b734-a0f413e59145","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/2925d49b-6840-383a-b734-a0f413e59145\/\u4e2d\u4ea4\u4e00\u516c\u5c40\u201420221031.pdf","orig_name":"\u4e2d\u4ea4\u4e00\u516c\u5c40\u201420221031.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":18500,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":18500,"un_invoiced":0,"collected":18500,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":2429,"client_id":2218,"signed_at":"2022-09-20","amount":"37000","handler":5329,"description":"\u7fa4\u6656nas3618xs\n\u7fa4\u6656\u5bfc\u8f68\n16t\u5e0c\u6377\u786c\u76d8*2","created_by":5329,"created_at":"2022-09-30 09:44:07","updated_at":"2022-11-01 16:40:40","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":2942,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-GZ-2022092032","payment_collection_remind_ahead":"","from_project":2942,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":null,"b_date":null,"passed":1,"client":{"id":2218,"key":2218,"name":"\u5317\u4eac\u56fd\u9645\u4e91\u8f6c\u64ad\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5329,"salesRep":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2429,"comment":1},"project":{"id":2942,"key":2942,"name":"\u6587\u4ef6\u5171\u4eab\u5907\u4efd"},"fromProject":{"id":2942,"key":2942,"name":"\u6587\u4ef6\u5171\u4eab\u5907\u4efd","description":"\u7fa4\u6656nas3618xs\n\u7fa4\u6656\u5bfc\u8f68\n16t\u5e0c\u6377\u786c\u76d8*2","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2022-09-20","collected":"37000","profit_pct":"12.45","budget":"37000","projectProductTypes":[{"id":2640,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"37000.00","pct":"12.45","project_id":2942,"profit":"4606.5"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":2942,"sum":"302.36"},"profit":4606.5,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":76,"contract_id":2429,"supplier_id":174,"purchase_id":2451,"supplier":{"id":174,"key":174,"name":"\u5317\u4eac\u79d1\u534e\u5609\u4e1a\u79d1\u8d38\u6709\u9650\u516c\u53f8"},"purchase":{"id":2451,"key":2451,"serial_no":"20221027"}},{"id":553,"contract_id":2429,"supplier_id":68,"purchase_id":2442,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":2442,"key":2442,"serial_no":"BJ706720220929A01"}},{"id":933,"contract_id":2429,"supplier_id":460,"purchase_id":2510,"supplier":{"id":460,"key":460,"name":"\u5317\u4eac\u798f\u7965\u5de8\u8fbe\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2510,"key":2510,"serial_no":"TSKJ-20221130-HYF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":3383,"user_id":5329,"key":5329,"contract_id":2429,"user":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1064,"key":1064,"contract_id":2429,"name":"2022-10-21","value":"11100","overdue_days":3,"pct":30,"collect_status":"\u5df2\u5b8c\u6210"},{"id":1065,"key":1065,"contract_id":2429,"name":"2022-11-28","value":"25900","overdue_days":null,"pct":70,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1411,"key":1411,"contract_id":2429,"value":"11100","created_by":1014,"created_at":"2022-10-24 10:29:28","description":null,"collected_date":"2022-10-24","amount":"11100","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[],"pct":30},{"id":1439,"key":1439,"contract_id":2429,"value":"25900","created_by":1014,"created_at":"2022-11-21 16:58:57","description":null,"collected_date":"2022-11-21","amount":"25900","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[],"pct":70}],"salesContractInvoices":[{"id":1277,"key":1277,"contract_id":2429,"value":"37000.00","attachment_id":null,"from_date":"2022-09-29","description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":16215,"object_type":102,"object_id":1277,"attachment_id":11135,"attachment":{"id":11135,"key":11135,"name":"6e909998-406f-3f68-8a41-6891a27d2292","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/6e909998-406f-3f68-8a41-6891a27d2292\/2022_09_29_13_54_58.pdf","orig_name":"2022_09_29_13_54_58.pdf"}}]}],"contractScans":[{"id":16455,"object_type":105,"object_id":2429,"attachment_id":11137,"attachment":{"id":11137,"key":11137,"name":"e6651132-4ed2-38c1-a2d5-d71fc46aaadb","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/e6651132-4ed2-38c1-a2d5-d71fc46aaadb\/\u56fd\u9645\u4e91\u8f6c\u64ad.pdf","orig_name":"\u56fd\u9645\u4e91\u8f6c\u64ad.pdf"}}],"receiptScans":[{"id":16398,"object_type":106,"object_id":2429,"attachment_id":11293,"attachment":{"id":11293,"key":11293,"name":"8b889521-e88e-335f-8350-94f54e5e61c7","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/8b889521-e88e-335f-8350-94f54e5e61c7\/2022_10_26_13_50_31.pdf","orig_name":"2022_10_26_13_50_31.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":37000,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":37000,"un_invoiced":0,"collected":37000,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":2212,"client_id":2148,"signed_at":"2022-02-14","amount":"1500","handler":1005,"description":"\u670d\u52a1\u5668\u786c\u76d8","created_by":1005,"created_at":"2022-02-23 19:49:43","updated_at":"2022-03-03 11:00:55","contract_scan":9654,"receipt_scan":9655,"contract_type":2,"project_id":2763,"valid_date":null,"expire_date":"2023-02-13","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"TS-ZHY-2022021401","payment_collection_remind_ahead":"1 day","from_project":2763,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":null,"b_date":879,"passed":2,"client":{"id":2148,"key":2148,"name":"\u4e2d\u56fd\u6c11\u822a\u673a\u573a\u5efa\u8bbe\u96c6\u56e2","logo":null,"sales_rep":5329,"salesRep":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}},"contractScan":{"id":9654,"key":9654,"name":"eb39935a-3477-3b2d-b6e2-12565b640ad6","orig_name":"\u4e2d\u56fd\u6c11\u822a\u673a\u573a\u5408\u540c.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/eb39935a-3477-3b2d-b6e2-12565b640ad6\/\u4e2d\u56fd\u6c11\u822a\u673a\u573a\u5408\u540c.pdf","download":"\/vue\/attachment\/download?name=eb39935a-3477-3b2d-b6e2-12565b640ad6"},"receiptScan":{"id":9655,"key":9655,"name":"f722a9a4-1deb-3485-9904-cdda06f4899f","orig_name":"\u4e2d\u56fd\u6c11\u822a\u673a\u573a\u5408\u540c.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/f722a9a4-1deb-3485-9904-cdda06f4899f\/\u4e2d\u56fd\u6c11\u822a\u673a\u573a\u5408\u540c.pdf","download":"\/vue\/attachment\/download?name=f722a9a4-1deb-3485-9904-cdda06f4899f"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2212,"comment":1},"project":{"id":2763,"key":2763,"name":"\u670d\u52a1\u5668\u786c\u76d8\u66f4\u6362"},"fromProject":{"id":2763,"key":2763,"name":"\u670d\u52a1\u5668\u786c\u76d8\u66f4\u6362","description":"\u670d\u52a1\u5668\u786c\u76d8","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2022-02-14","collected":"1500","profit_pct":"56","budget":"1500","projectProductTypes":[{"id":4015,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"1500.00","pct":"56","project_id":2763,"profit":"840"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":2763,"sum":"142.81"},"profit":840,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":1394,"contract_id":2212,"supplier_id":107,"purchase_id":2512,"supplier":{"id":107,"key":107,"name":"\u5317\u4eac\u8fdc\u5927\u534e\u4fe1\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u878d\u521b\u777f\u901a\u6280\u672f\u5f00\u53d1\u6709\u9650\u516c\u53f8"},"purchase":{"id":2512,"key":2512,"serial_no":""}}],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":6598,"user_id":1011,"key":1011,"contract_id":2212,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":7114,"user_id":5329,"key":5329,"contract_id":2212,"user":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":3013,"user_id":1005,"key":1005,"contract_id":2212,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":971,"key":971,"contract_id":2212,"name":"2022-03-16","value":"1500","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1297,"key":1297,"contract_id":2212,"value":"1500","created_by":1014,"created_at":"2022-03-14 15:26:09","description":null,"collected_date":"2022-03-14","amount":"1500","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[],"pct":100}],"salesContractInvoices":[{"id":1176,"key":1176,"contract_id":2212,"value":"1500.00","attachment_id":null,"from_date":"2022-02-21","description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":12163,"object_type":102,"object_id":1176,"attachment_id":9656,"attachment":{"id":9656,"key":9656,"name":"eb742d48-e4c7-33de-99de-49e550df52a7","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/eb742d48-e4c7-33de-99de-49e550df52a7\/\u4e2d\u56fd\u6c11\u822a\u673a\u573a\u53d1\u7968.pdf","orig_name":"\u4e2d\u56fd\u6c11\u822a\u673a\u573a\u53d1\u7968.pdf"}}]}],"contractScans":[{"id":14590,"object_type":105,"object_id":2212,"attachment_id":9654,"attachment":{"id":9654,"key":9654,"name":"eb39935a-3477-3b2d-b6e2-12565b640ad6","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/eb39935a-3477-3b2d-b6e2-12565b640ad6\/\u4e2d\u56fd\u6c11\u822a\u673a\u573a\u5408\u540c.pdf","orig_name":"\u4e2d\u56fd\u6c11\u822a\u673a\u573a\u5408\u540c.pdf"}}],"receiptScans":[{"id":14572,"object_type":106,"object_id":2212,"attachment_id":9672,"attachment":{"id":9672,"key":9672,"name":"9c2a2fc9-9e25-320e-b08c-fd748fcd4d9f","extension":"jpeg","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/9c2a2fc9-9e25-320e-b08c-fd748fcd4d9f\/WechatIMG4938.jpeg","orig_name":"WechatIMG4938.jpeg"}}],"verifyScans":[],"unreadComments":null,"collected_plan":1500,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":1500,"un_invoiced":0,"collected":1500,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":2104,"client_id":576,"signed_at":"2021-10-15","amount":"18500","handler":5299,"description":"\u7eed\u4fdd\u4e00\u5e74\u670d\u52a1","created_by":5299,"created_at":"2021-10-13 14:46:52","updated_at":"2021-11-16 10:28:05","contract_scan":8715,"receipt_scan":null,"contract_type":2,"project_id":2658,"valid_date":null,"expire_date":"2022-10-14","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"TS-HC-2021101538","payment_collection_remind_ahead":"","from_project":2658,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":null,"b_date":1001,"passed":2,"client":{"id":576,"key":576,"name":"\u4e2d\u4ea4\u4e00\u516c\u5c40\u7b2c\u4e00\u5de5\u7a0b\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5329,"salesRep":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}},"contractScan":{"id":8715,"key":8715,"name":"211adf1e-5f3a-3582-8ffd-fb39b612e03b","orig_name":"2021_10_22_10_31_03.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/211adf1e-5f3a-3582-8ffd-fb39b612e03b\/2021_10_22_10_31_03.pdf","download":"\/vue\/attachment\/download?name=211adf1e-5f3a-3582-8ffd-fb39b612e03b"},"receiptScan":null,"createdBy":{"id":5299,"key":5299,"name":"\u4f55\u806a","sex":"M","department_id":1,"avatar":{"id":139,"user_id":5299,"name":"\/files\/cdn\/a57be577deb434\/avatar\/a99798df-3541-322a-a63b-2f6c43e4dfb9.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2104,"comment":1},"project":{"id":2658,"key":2658,"name":"veeam\u7eed\u4fdd2021"},"fromProject":{"id":2658,"key":2658,"name":"veeam\u7eed\u4fdd2021","description":"\u7eed\u4fdd\u4e00\u5e74\u670d\u52a1","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2021-10-15","collected":"18500","profit_pct":"36.51","budget":"18500","projectProductTypes":[{"id":3086,"product_type_id":65,"key":65,"name":"\u5546\u4e1a\u8f6f\u4ef6","budget":"18500","pct":"36.51","project_id":2658,"profit":"6754.35"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":6754.35,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2037,"contract_id":2104,"supplier_id":659,"purchase_id":2120,"supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"purchase":{"id":2120,"key":2120,"serial_no":"TSKJ20211025-DWF-001"}}],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":5299,"key":5299,"name":"\u4f55\u806a","sex":"M","department_id":1,"avatar":{"id":139,"user_id":5299,"name":"\/files\/cdn\/a57be577deb434\/avatar\/a99798df-3541-322a-a63b-2f6c43e4dfb9.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":6206,"user_id":1011,"key":1011,"contract_id":2104,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":7185,"user_id":5329,"key":5329,"contract_id":2104,"user":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[{"id":930,"key":930,"contract_id":2104,"name":"2021-12-18","value":"18500","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1263,"key":1263,"contract_id":2104,"value":"18500","created_by":1014,"created_at":"2021-12-14 11:28:16","description":null,"collected_date":"2021-12-10","amount":"18500","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[],"pct":100}],"salesContractInvoices":[{"id":1127,"key":1127,"contract_id":2104,"value":"18500.00","attachment_id":8624,"from_date":"2021-10-13","description":null,"is_draft":true,"attachment":{"id":8624,"key":8624,"name":"d82b6c37-8a5f-3fa7-8942-a028891ae2d4","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/d82b6c37-8a5f-3fa7-8942-a028891ae2d4\/2021_10_13_14_53_29.pdf","orig_name":"2021_10_13_14_53_29.pdf"},"attachmentRelationships":[],"files":[{"id":6635,"object_type":102,"object_id":1127,"attachment_id":8624,"attachment":{"id":8624,"key":8624,"name":"d82b6c37-8a5f-3fa7-8942-a028891ae2d4","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/d82b6c37-8a5f-3fa7-8942-a028891ae2d4\/2021_10_13_14_53_29.pdf","orig_name":"2021_10_13_14_53_29.pdf"}}]}],"contractScans":[{"id":12316,"object_type":105,"object_id":2104,"attachment_id":8715,"attachment":{"id":8715,"key":8715,"name":"211adf1e-5f3a-3582-8ffd-fb39b612e03b","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/211adf1e-5f3a-3582-8ffd-fb39b612e03b\/2021_10_22_10_31_03.pdf","orig_name":"2021_10_22_10_31_03.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":18500,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":18500,"un_invoiced":0,"collected":18500,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":1989,"client_id":1128,"signed_at":"2021-05-24","amount":"8900","handler":5294,"description":"\uff081\uff09\u66f4\u6362\uff1a\u534e\u4e3a\u7684\u5343\u5146\u5149\u63a5\u53e3\u677f\uff0c\u578b\u53f7\u662f\uff1aG24SA\u3002\n\uff082\uff09\u6062\u590d\u5ba2\u6237\u4ea4\u6362\u673a\u539f\u6709\u914d\u7f6e\u3001\u4e24\u53f0\u6838\u5fc3\u4ea4\u6362\u673a\u5185\u914d\u7f6e\u540c\u6b65-\u70ed\u5907\uff08\u52a0\u666e\u901a\u7f51\u7ebf\u65b9\u5f0f\uff09\u3001\u9632\u706b\u5899\u5916\u7f51\u7aef\u53e3\u94fe\u8def\u805a\u5408\u3002","created_by":5294,"created_at":"2021-06-01 15:58:26","updated_at":"2021-08-19 16:18:16","contract_scan":7612,"receipt_scan":7791,"contract_type":1,"project_id":2547,"valid_date":null,"expire_date":"2022-05-23","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"\u65e0","payment_collection_remind_ahead":"","from_project":2547,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":null,"b_date":1145,"passed":2,"client":{"id":1128,"key":1128,"name":"\u4e2d\u56fd\u7535\u5b50\u5b66\u4f1a","logo":null,"sales_rep":5329,"salesRep":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}},"contractScan":{"id":7612,"key":7612,"name":"25a322d8-ef66-3b60-81e0-9810bf72c9db","orig_name":"\u4e2d\u56fd\u7535\u5b50\u5b66\u4f1a.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/25a322d8-ef66-3b60-81e0-9810bf72c9db\/\u4e2d\u56fd\u7535\u5b50\u5b66\u4f1a.pdf","download":"\/vue\/attachment\/download?name=25a322d8-ef66-3b60-81e0-9810bf72c9db"},"receiptScan":{"id":7791,"key":7791,"name":"9bbaf163-6c52-3de5-9c9b-e8e07c975c5c","orig_name":"2021_06_22_10_12_58.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/9bbaf163-6c52-3de5-9c9b-e8e07c975c5c\/2021_06_22_10_12_58.pdf","download":"\/vue\/attachment\/download?name=9bbaf163-6c52-3de5-9c9b-e8e07c975c5c"},"createdBy":{"id":5294,"key":5294,"name":"\u9a6c\u6069\u65ed","sex":"M","department_id":1,"avatar":null,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":1989,"comment":1},"project":{"id":2547,"key":2547,"name":"\u534e\u4e3a\u5149\u63a5\u53e3\u677f\u66f4\u6362"},"fromProject":{"id":2547,"key":2547,"name":"\u534e\u4e3a\u5149\u63a5\u53e3\u677f\u66f4\u6362","description":"\uff081\uff09\u66f4\u6362\uff1a\u534e\u4e3a\u7684\u5343\u5146\u5149\u63a5\u53e3\u677f\uff0c\u578b\u53f7\u662f\uff1aG24SA\u3002\n\uff082\uff09\u6062\u590d\u5ba2\u6237\u4ea4\u6362\u673a\u539f\u6709\u914d\u7f6e\u3001\u4e24\u53f0\u6838\u5fc3\u4ea4\u6362\u673a\u5185\u914d\u7f6e\u540c\u6b65-\u70ed\u5907\uff08\u52a0\u666e\u901a\u7f51\u7ebf\u65b9\u5f0f\uff09\u3001\u9632\u706b\u5899\u5916\u7f51\u7aef\u53e3\u94fe\u8def\u805a\u5408\u3002","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2021-05-24","collected":"8900","profit_pct":"16.57","budget":"8900","projectProductTypes":[{"id":3690,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"8900","pct":"16.57","project_id":2547,"profit":"1474.73"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":2547,"sum":"52.2"},"profit":1474.73,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":96,"contract_id":1989,"supplier_id":137,"purchase_id":1984,"supplier":{"id":137,"key":137,"name":"\u5317\u4eac\u79e6\u8fbe\u5609\u5174\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":1984,"key":1984,"serial_no":"A202105-26"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5294,"key":5294,"name":"\u9a6c\u6069\u65ed","sex":"M","department_id":1,"avatar":null},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":5996,"user_id":1011,"key":1011,"contract_id":1989,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":7089,"user_id":5329,"key":5329,"contract_id":1989,"user":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":1307,"key":1307,"contract_id":1989,"value":"8900","created_by":1014,"created_at":"2022-03-29 16:14:15","description":null,"collected_date":"2021-06-15","amount":"8900","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[],"pct":100}],"salesContractInvoices":[{"id":1065,"key":1065,"contract_id":1989,"value":"8900.00","attachment_id":7614,"from_date":"2021-06-01","description":null,"is_draft":true,"attachment":{"id":7614,"key":7614,"name":"607ac56b-7a62-3497-8040-034e54669c39","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/607ac56b-7a62-3497-8040-034e54669c39\/2021_06_01_15_48_12.pdf","orig_name":"2021_06_01_15_48_12.pdf"},"attachmentRelationships":[],"files":[{"id":6491,"object_type":102,"object_id":1065,"attachment_id":7614,"attachment":{"id":7614,"key":7614,"name":"607ac56b-7a62-3497-8040-034e54669c39","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/607ac56b-7a62-3497-8040-034e54669c39\/2021_06_01_15_48_12.pdf","orig_name":"2021_06_01_15_48_12.pdf"}}]}],"contractScans":[{"id":12402,"object_type":105,"object_id":1989,"attachment_id":7612,"attachment":{"id":7612,"key":7612,"name":"25a322d8-ef66-3b60-81e0-9810bf72c9db","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/25a322d8-ef66-3b60-81e0-9810bf72c9db\/\u4e2d\u56fd\u7535\u5b50\u5b66\u4f1a.pdf","orig_name":"\u4e2d\u56fd\u7535\u5b50\u5b66\u4f1a.pdf"}}],"receiptScans":[{"id":13149,"object_type":106,"object_id":1989,"attachment_id":7791,"attachment":{"id":7791,"key":7791,"name":"9bbaf163-6c52-3de5-9c9b-e8e07c975c5c","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/9bbaf163-6c52-3de5-9c9b-e8e07c975c5c\/2021_06_22_10_12_58.pdf","orig_name":"2021_06_22_10_12_58.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":8900,"un_invoiced":0,"collected":8900,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true}],"pagenation":{"totalcount":26,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-11 14:55:28') RETURNING "id" |