ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6878df7b0da78: POST https://beta.jinchangxiao.com/v2/sales-contract/of-client at 2025-07-17 07:33:15 pm by 139.159.170.26

Log Messages

总计93条数据
TimeLevelCategoryMessage
 
19:33:15.055traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
19:33:15.055traceyii\base\Module::getModuleLoading module: debug
19:33:15.055traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
19:33:15.056traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
19:33:15.056traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
19:33:15.056traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19:33:15.056traceyii\base\Module::getModuleLoading module: gii
19:33:15.056traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
19:33:15.056traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
19:33:15.056traceyii\web\Application::handleRequestRoute requested: 'v2/sales-contract/of-client'
19:33:15.056traceyii\base\Module::getModuleLoading module: v2
19:33:15.057infoyii\web\Session::openSession started
19:33:15.057infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
19:33:15.059infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH'
19:33:15.062traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19:33:15.062traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
19:33:15.062traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19:33:15.062traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
19:33:15.062infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
19:33:15.064traceyii\base\Controller::runActionRoute to run: v2/sales-contract/of-client
19:33:15.064traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19:33:15.065traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
19:33:15.065traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\SalesContractController::actionOfClient()
19:33:15.065infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='141') AND ("deleted"=FALSE)
19:33:15.066traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19:33:15.066traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
19:33:15.066traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19:33:15.066traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
19:33:15.066traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19:33:15.067traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19:33:15.068infoyii\db\Command::querySELECT 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 "client"."id"='141' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"
19:33:15.074infoyii\db\Command::querySELECT 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 "client"."id"='141' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10
19:33:15.081infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=141
19:33:15.081infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300
19:33:15.082infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300)
19:33:15.082infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5364)
19:33:15.083infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5364, 5300))
19:33:15.083infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
19:33:15.083infoyii\db\Command::querySELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (3732, 3731, 3543, 2993)) GROUP BY "object_id"
19:33:15.102infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3739, 3692, 3493, 3375)
19:33:15.102infoyii\db\Command::querySELECT "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 (3739, 3692, 3493, 3375)
19:33:15.103infoyii\db\Command::querySELECT "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 (3375, 3493, 3692, 3739)
19:33:15.104infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3375, 3493, 3692, 3739)
19:33:15.105infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (564, 640)
19:33:15.105infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1917, 1918, 1919, 1920, 1921, 1125, 1786, 980, 981, 1196)
19:33:15.106infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (4, 5, 7, 3)
19:33:15.107infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (25, 26, 214, 35, 41, 14, 43)
19:33:15.107infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (12, 3, 24)
19:33:15.107infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1508, 1587, 1588, 1589, 1276, 1275, 170, 748)
19:33:15.108infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (1, 2, 3)
19:33:15.108infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3375, 3493, 3692, 3739)
19:33:15.109infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id"=846
19:33:15.109infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=141
19:33:15.110infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((846, 3493))
19:33:15.110infoyii\db\Command::querySELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (3375, 3493, 3692, 3739))
19:33:15.120infoyii\db\Command::querySELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (3, 2)) AND ("project_id" IN (3375, 3493, 3692, 3739)) GROUP BY "project_id"
19:33:15.121infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (3732, 3731, 3543, 2993)
19:33:15.122infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (564, 640)
19:33:15.122infoyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (3003, 3575, 3741)
19:33:15.123infoyii\db\Command::querySELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id"=1
19:33:15.123infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5364)
19:33:15.123infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5364, 5300))
19:33:15.124infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("reminded"=FALSE) AND ("contract_id" IN (3732, 3731, 3543, 2993)) ORDER BY "remind_date"
19:33:15.126infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id" IN (3732, 3731, 3543, 2993)
19:33:15.126infoyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (3732, 3731, 3543, 2993)
19:33:15.129infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300
19:33:15.129infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300)
19:33:15.130infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (3732, 3731, 3543, 2993)
19:33:15.131infoyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (3732, 3731, 3543, 2993)
19:33:15.132infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5388, 1001)
19:33:15.132infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5388, 5300))
19:33:15.132infoyii\db\Command::querySELECT "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 (3732, 3731, 3543, 2993) ORDER BY "remind_date"
19:33:15.133infoyii\db\Command::querySELECT "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 (3732, 3731, 3543, 2993) ORDER BY "id"
19:33:15.134infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1014, 5388, 1013)
19:33:15.134infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=109) AND ("object_id" IN (1740, 1776, 1975, 2000, 2064, 2065))
19:33:15.135infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21726, 16929, 17569, 22339, 23502, 23503)
19:33:15.141infoyii\db\Command::querySELECT "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 (3732, 3731, 3543, 2993) ORDER BY "id"
19:33:15.142infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (1552, 1801, 1913, 1914))
19:33:15.143infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (1552, 1801, 1913, 1914))
19:33:15.145infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (16421, 21531, 23429, 23428)
19:33:15.146infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (3732, 3731, 3543, 2993))
19:33:15.147infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21514, 16429, 23420, 23419)
19:33:15.148infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (3732, 3731, 3543, 2993))
19:33:15.149infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (22679, 16495, 23650, 23792)
19:33:15.149infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (3732, 3731, 3543, 2993))
19:33:15.151infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21878, 17033)
19:33:15.151infoyii\db\Command::querySELECT "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 (3732, 3731, 3543, 2993)) GROUP BY "object_id"
19:33:15.167traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewProduct
19:33:15.167traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Accountant
19:33:15.167traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
19:33:15.168traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19:33:15.168traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
19:33:15.168infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 6, 167, 'v2/sales-contract/of-client', '{"id":"141","page":"1","pagesize":"10","posttime":"1752751995","access_token":"oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH","device_type":"6","version_code":"167","token":"4acc5ed04b6cef634e2ffa857946210b"}', '{"code":200,"data":{"list":[{"id":3732,"client_id":141,"signed_at":"2024-12-24","amount":"167000","handler":5300,"description":"","created_by":5300,"created_at":"2024-12-27 14:20:51","updated_at":"2025-01-17 13:25:19","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3739,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-SQY-2024122402","payment_collection_remind_ahead":"7 days","from_project":3739,"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":"2024-12-30 17:52:48.210537+08","b_date":null,"passed":1,"client":{"id":141,"key":141,"name":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3732,"comment":8},"project":{"id":3739,"key":3739,"name":"\u601d\u79d1\u9632\u706b\u58991140*2+1120*1\u65b0\u8d2d-K-2024"},"fromProject":{"id":3739,"key":3739,"name":"\u601d\u79d1\u9632\u706b\u58991140*2+1120*1\u65b0\u8d2d-K-2024","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":744,"bargain_date":"2024-12-24","collected":"167000","profit_pct":"7.21","budget":"167000","projectProductTypes":[{"id":5840,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"167000.00","pct":"7.21","project_id":3739,"profit":"12040.7"}],"projectProductRels":[{"id":8369,"project_id":3739,"product_id":1917,"amount":"35300.00","number":2,"cost":"36308.00","description":"","supplier_id":564,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"70600","total_cost":"72616","supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1917,"name":"FPR1140-NGFW-K9","product_type":5,"product_component":26,"product_brand":3,"product_serie":1587,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-12-30 17:01:27","updated_at":"2024-12-30 17:01:27","pinyin_shortcut":"FPR1140NGFWK9","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1587,"key":1587,"name":"Cisco Firepower 1000 \u7cfb\u5217"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":8370,"project_id":3739,"product_id":1918,"amount":"0","number":2,"cost":"4000.00","description":"","supplier_id":564,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"8000","supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1918,"name":"CON-SNT-FR11P40N","product_type":5,"product_component":214,"product_brand":3,"product_serie":1588,"product_misc":null,"product_qa":null,"pn":"","description":"SNTC-8X5XNBD Cisco Firepower 1140 NGFW Appliance, 1U","created_by":1013,"created_at":"2024-12-30 17:03:18","updated_at":"2024-12-30 17:03:18","pinyin_shortcut":"CONSNTFR11P40N","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":214,"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1588,"key":1588,"name":"\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8371,"project_id":3739,"product_id":1919,"amount":"26700.00","number":2,"cost":"21700.00","description":"","supplier_id":564,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"53400","total_cost":"43400","supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1919,"name":"L-FPR1140T-TMC-1Y","product_type":5,"product_component":35,"product_brand":3,"product_serie":1589,"product_misc":null,"product_qa":null,"pn":"","description":"Cisco FPR1140 Threat Defense Threat, Malware and URL 1Y Subs","created_by":1013,"created_at":"2024-12-30 17:09:46","updated_at":"2024-12-30 17:09:46","pinyin_shortcut":"LFPR1140TTMC1Y","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1589,"key":1589,"name":"Cisco Firepower 1000 \u7cfb\u5217\u9632\u706b\u5899\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8372,"project_id":3739,"product_id":1920,"amount":"39690.00","number":1,"cost":"22000.00","description":"","supplier_id":564,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"39690","total_cost":"22000","supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1920,"name":"FPR1120-ASA-K9","product_type":5,"product_component":26,"product_brand":3,"product_serie":1587,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-12-30 17:11:17","updated_at":"2024-12-30 17:11:17","pinyin_shortcut":"FPR1120ASAK9","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1587,"key":1587,"name":"Cisco Firepower 1000 \u7cfb\u5217"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":8373,"project_id":3739,"product_id":1921,"amount":"3310.00","number":1,"cost":"3310.00","description":"","supplier_id":564,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"3310","total_cost":"3310","supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1921,"name":"CON-SNT-FPR1120A","product_type":5,"product_component":214,"product_brand":3,"product_serie":1588,"product_misc":null,"product_qa":null,"pn":"","description":"SNTC-8X5XNBD Cisco Firepower 1120 ASA Appliance","created_by":1013,"created_at":"2024-12-30 17:12:26","updated_at":"2024-12-30 17:12:26","pinyin_shortcut":"CONSNTFPR1120A","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":214,"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1588,"key":1588,"name":"\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12650,"project_id":3739},{"id":12653,"project_id":3739},{"id":12654,"project_id":3739},{"id":12652,"project_id":3739},{"id":12651,"project_id":3739},{"id":12649,"project_id":3739}],"reimbursementAmountSum":{"project_id":3739,"sum":"464"},"profit":12040.7,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2314,"contract_id":3732,"supplier_id":564,"purchase_id":3741,"supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3741,"key":3741,"serial_no":"TSKJ20241231-SQY-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7623,"user_id":5300,"key":5300,"contract_id":3732,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":7624,"user_id":5388,"key":5388,"contract_id":3732,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7625,"user_id":1001,"key":1001,"contract_id":3732,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2294,"key":2294,"contract_id":3732,"name":"2025-01-31","value":"167000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2064,"key":2064,"contract_id":3732,"value":"167000","created_by":5388,"created_at":"2024-12-31 17:14:28","description":"","collected_date":"2024-12-31","amount":"167000","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"files":[{"id":31492,"object_type":109,"object_id":2064,"attachment_id":23502,"attachment":{"id":23502,"key":23502,"name":"c1035125-c282-32c6-8d03-0d3e04fd1670","extension":"jpg","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/c1035125-c282-32c6-8d03-0d3e04fd1670\/\u878d\u5b9d167000.jpg","orig_name":"\u878d\u5b9d167000.jpg"}}],"pct":100}],"salesContractInvoices":[{"id":1914,"key":1914,"contract_id":3732,"value":"167000.00","attachment_id":null,"from_date":"2024-12-27","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":31395,"object_type":102,"object_id":1914,"attachment_id":23429,"attachment":{"id":23429,"key":23429,"name":"76eb8ee1-3dda-3a50-ae58-870c2b7b1a12","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/76eb8ee1-3dda-3a50-ae58-870c2b7b1a12\/dzfp_24112000000224162879_\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8_20241227163319.pdf","orig_name":"dzfp_24112000000224162879_\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8_20241227163319.pdf"}}]}],"contractScans":[{"id":31507,"object_type":105,"object_id":3732,"attachment_id":23420,"attachment":{"id":23420,"key":23420,"name":"759c10b9-9087-3408-8efe-baa757db57e2","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/759c10b9-9087-3408-8efe-baa757db57e2\/167000.pdf","orig_name":"167000.pdf"}}],"receiptScans":[{"id":31897,"object_type":106,"object_id":3732,"attachment_id":23792,"attachment":{"id":23792,"key":23792,"name":"2cb0740b-151a-3575-8f99-f5a467c79b90","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/2cb0740b-151a-3575-8f99-f5a467c79b90\/\u201c2025\u62d3\u5b9e\u7b7e\u6536\u5355\u201d\u7684\u526f\u672c.pdf","orig_name":"\u201c2025\u62d3\u5b9e\u7b7e\u6536\u5355\u201d\u7684\u526f\u672c.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":167000,"projectProductTotalAmount":167000,"projectProductAllAmount":true,"projectProductTotalCost":149326,"projectProductAllCost":true,"projectProductTotalCount":8,"invoiced":167000,"un_invoiced":0,"collected":167000,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3731,"client_id":141,"signed_at":"2024-12-24","amount":"186000","handler":5300,"description":"","created_by":5300,"created_at":"2024-12-27 14:17:13","updated_at":"2025-01-13 09:27:35","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3692,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-SQY-2024122401","payment_collection_remind_ahead":"7 days","from_project":3692,"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":"2024-12-30 17:52:27.709363+08","b_date":null,"passed":1,"client":{"id":141,"key":141,"name":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3731,"comment":8},"project":{"id":3692,"key":3692,"name":"\u601d\u79d1\u9632\u706b\u5899\u65b0\u8d2d1140*3\u65b0\u8d2d-K-2024"},"fromProject":{"id":3692,"key":3692,"name":"\u601d\u79d1\u9632\u706b\u5899\u65b0\u8d2d1140*3\u65b0\u8d2d-K-2024","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":743,"bargain_date":"2024-12-24","collected":"186000","profit_pct":"-2.13","budget":"186000","projectProductTypes":[{"id":5841,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"186000.00","pct":"-2.13","project_id":3692,"profit":"-3961.8"}],"projectProductRels":[{"id":8374,"project_id":3692,"product_id":1917,"amount":"35300.00","number":3,"cost":"36308.00","description":"","supplier_id":564,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"105900","total_cost":"108924","supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1917,"name":"FPR1140-NGFW-K9","product_type":5,"product_component":26,"product_brand":3,"product_serie":1587,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-12-30 17:01:27","updated_at":"2024-12-30 17:01:27","pinyin_shortcut":"FPR1140NGFWK9","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1587,"key":1587,"name":"Cisco Firepower 1000 \u7cfb\u5217"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":8375,"project_id":3692,"product_id":1918,"amount":"0","number":3,"cost":"4000.00","description":"\u4e00\u5e74\u670d\u52a1","supplier_id":564,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"12000","supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1918,"name":"CON-SNT-FR11P40N","product_type":5,"product_component":214,"product_brand":3,"product_serie":1588,"product_misc":null,"product_qa":null,"pn":"","description":"SNTC-8X5XNBD Cisco Firepower 1140 NGFW Appliance, 1U","created_by":1013,"created_at":"2024-12-30 17:03:18","updated_at":"2024-12-30 17:03:18","pinyin_shortcut":"CONSNTFR11P40N","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":214,"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1588,"key":1588,"name":"\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8376,"project_id":3692,"product_id":1919,"amount":"26700.00","number":3,"cost":"21700.00","description":"","supplier_id":564,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"80100","total_cost":"65100","supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1919,"name":"L-FPR1140T-TMC-1Y","product_type":5,"product_component":35,"product_brand":3,"product_serie":1589,"product_misc":null,"product_qa":null,"pn":"","description":"Cisco FPR1140 Threat Defense Threat, Malware and URL 1Y Subs","created_by":1013,"created_at":"2024-12-30 17:09:46","updated_at":"2024-12-30 17:09:46","pinyin_shortcut":"LFPR1140TTMC1Y","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":1589,"key":1589,"name":"Cisco Firepower 1000 \u7cfb\u5217\u9632\u706b\u5899\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12657,"project_id":3692},{"id":12658,"project_id":3692},{"id":12659,"project_id":3692},{"id":12655,"project_id":3692},{"id":12656,"project_id":3692}],"reimbursementAmountSum":{"project_id":3692,"sum":"224.86"},"profit":-3961.8,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2315,"contract_id":3731,"supplier_id":564,"purchase_id":3741,"supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3741,"key":3741,"serial_no":"TSKJ20241231-SQY-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7626,"user_id":5300,"key":5300,"contract_id":3731,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":7627,"user_id":5388,"key":5388,"contract_id":3731,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7628,"user_id":1001,"key":1001,"contract_id":3731,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2293,"key":2293,"contract_id":3731,"name":"2025-01-31","value":"186000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2065,"key":2065,"contract_id":3731,"value":"186000","created_by":5388,"created_at":"2024-12-31 17:14:55","description":"","collected_date":"2024-12-31","amount":"186000","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"files":[{"id":31493,"object_type":109,"object_id":2065,"attachment_id":23503,"attachment":{"id":23503,"key":23503,"name":"2bcb6fa6-1a13-3191-8fd1-daab87ebfb3a","extension":"jpg","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/2bcb6fa6-1a13-3191-8fd1-daab87ebfb3a\/\u878d\u5b9d186000.jpg","orig_name":"\u878d\u5b9d186000.jpg"}}],"pct":100}],"salesContractInvoices":[{"id":1913,"key":1913,"contract_id":3731,"value":"186000.00","attachment_id":null,"from_date":"2024-12-27","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":31396,"object_type":102,"object_id":1913,"attachment_id":23428,"attachment":{"id":23428,"key":23428,"name":"14690154-b736-3070-9401-7f0128093a79","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/14690154-b736-3070-9401-7f0128093a79\/dzfp_24112000000224282371_\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8_20241227163435.pdf","orig_name":"dzfp_24112000000224282371_\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8_20241227163435.pdf"}}]}],"contractScans":[{"id":31508,"object_type":105,"object_id":3731,"attachment_id":23419,"attachment":{"id":23419,"key":23419,"name":"f79c73cf-7481-3d32-95e0-87a3231dbf75","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/f79c73cf-7481-3d32-95e0-87a3231dbf75\/186000.pdf","orig_name":"186000.pdf"}}],"receiptScans":[{"id":31721,"object_type":106,"object_id":3731,"attachment_id":23650,"attachment":{"id":23650,"key":23650,"name":"1adc2d45-5e06-3111-a522-44c8e23f2bdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/1adc2d45-5e06-3111-a522-44c8e23f2bdf\/2025_01_13_09_11_26.pdf","orig_name":"2025_01_13_09_11_26.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":186000,"projectProductTotalAmount":186000,"projectProductAllAmount":true,"projectProductTotalCost":186024,"projectProductAllCost":true,"projectProductTotalCount":9,"invoiced":186000,"un_invoiced":0,"collected":186000,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3543,"client_id":141,"signed_at":"2024-08-10","amount":"172600","handler":5300,"description":"","created_by":5300,"created_at":"2024-09-13 14:48:40","updated_at":"2024-11-14 11:09:46","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3493,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-SQY-2024080101","payment_collection_remind_ahead":"7 days","from_project":3493,"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":"2024-10-10 15:42:16.886123+08","b_date":null,"passed":1,"client":{"id":141,"key":141,"name":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3543,"comment":9},"project":{"id":3493,"key":3493,"name":"\u6df1\u4fe1\u670d\u5bc6\u8bc4VPN-K-2024"},"fromProject":{"id":3493,"key":3493,"name":"\u6df1\u4fe1\u670d\u5bc6\u8bc4VPN-K-2024","description":"","total_contact_point":"55028","paid_contact_point":"55028","is_sales_order_ready":true,"project_product_version_id":607,"bargain_date":"2024-08-10","collected":"172600","profit_pct":"2.05","budget":"172600","projectProductTypes":[{"id":5528,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"172600","pct":"2.05","project_id":3493,"profit":"3538.3"}],"projectProductRels":[{"id":7283,"project_id":3493,"product_id":1786,"amount":"86300","number":2,"cost":"6000","description":"","supplier_id":640,"hardware_from":"2024-09-23","software_from":null,"maintenance_from":null,"hardware_to":"2027-09-23","software_to":null,"maintenance_to":null,"total_amount":"172600","total_cost":"12000","supplier":{"id":640,"key":640,"name":"\u5317\u4eac\u4e16\u7eaa\u7f51\u6e90\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1786,"name":"aTrust-1000-S1035M","product_type":4,"product_component":25,"product_brand":12,"product_serie":1508,"product_misc":null,"product_qa":null,"pn":"","description":"SSL\u6027\u80fd\u53c2\u6570\uff1a\u6700\u5927\u7406\u8bba\u52a0\u5bc6\u6d41\u91cf\uff08Mbps\uff09\uff1a480Mbps\uff0c\u6700\u5927\u7406\u8bba\u5efa\u8bae\u5e76\u53d1\u7528\u6237\u6570\uff08\u4e2a\uff09\uff1a1000\u3002\n\u786c\u4ef6\u53c2\u6570\uff1a\u89c4\u683c\uff1a1U\uff0c\u5185\u5b58\u5927\u5c0f\uff1a16G\uff0c\u786c\u76d8\u5bb9\u91cf\uff1a128G SSD\uff0c\u7535\u6e90\uff1a\u5197\u4f59\u7535\u6e90\uff0c\u63a5\u53e3\uff1a6\u5343\u5146\u7535\u53e3+4\u5343\u5146\u5149\u53e3SFP\u3002\n\u529f\u80fd\u63cf\u8ff0\uff1a\u6df1\u4fe1\u670daTrust-1000-S\u7cfb\u5217\u5546\u5bc6\u578b\u53f7\u4ea7\u54c1\uff0c\u91c7\u7528\u56fd\u5bb6\u5bc6\u7801\u7ba1\u7406\u5c40\u9881\u5e03\u7684SM1\u3001SM2\u3001SM3\u3001SM4\u5bc6\u7801\u7b97\u6cd5\u53ca\u5176\u534f\u8bae\uff0c\u652f\u6301\u591a\u79cd\u8eab\u4efd\u8ba4\u8bc1\u65b9\u5f0f\u3001\u7ec6\u7c92\u5ea6\u8bbf\u95ee\u6743\u9650\u63a7\u5236\u7b49\u4e3b\u8981\u529f\u80fd\uff0c\u53e6\u5916\u53ef\u9009\u914d\u6269\u5c55\u652f\u6301UEM\u529f\u80fd\uff08\u5355\u72ec\u6536\u8d39\uff09\uff0c\u4fdd\u8bc1\u8fdc\u7a0b\u7cfb\u7edf\u63a5\u5165\u7684\u7528\u6237\u8eab\u4efd\u5b89\u5168\u3001\u7ec8\u7aef\/\u6570\u636e\u5b89\u5168\u3001\u4f20\u8f93\u5b89\u5168\u3001\u5e94\u7528\u6743\u9650\u5b89\u5168\u548c\u5ba1\u8ba1\u5b89\u5168\uff0c\u7b26\u5408\u56fd\u5bb6\u5546\u7528\u5bc6\u7801\u6807\u51c6\uff0c\u5177\u6709\u5feb\u901f\u3001\u6613\u7528\u3001\u5168\u9762\u7b49\u4f18\u52bf\u7279\u70b9\u3002","created_by":1013,"created_at":"2024-09-19 14:23:11","updated_at":"2024-09-19 14:23:11","pinyin_shortcut":"aTrust1000S1035M","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":25,"key":25,"name":"\u5b89\u5168\u63a5\u5165\u7f51\u5173"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1508,"key":1508,"name":"\u6df1\u4fe1\u670d\u8bbf\u95ee\u63a7\u5236\u7cfb\u7edfaTrust-1000-S1035M"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":7284,"project_id":3493,"product_id":980,"amount":"0","number":2,"cost":"35000","description":"\u9002\u7528\u4e8eaTrust-1000-S1035M","supplier_id":640,"hardware_from":null,"software_from":"2024-09-23","maintenance_from":null,"hardware_to":null,"software_to":"2027-09-23","maintenance_to":null,"total_amount":"0","total_cost":"70000","supplier":{"id":640,"key":640,"name":"\u5317\u4eac\u4e16\u7eaa\u7f51\u6e90\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":980,"name":"\u6df1\u4fe1\u670d\u96f6\u4fe1\u4efb\u8bbf\u95ee\u63a7\u5236\u7cfb\u7edf\u8f6f\u4ef6V2.0","product_type":7,"product_component":41,"product_brand":12,"product_serie":1276,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-09 09:32:41","updated_at":"2024-03-11 13:56:59","pinyin_shortcut":"sxflxrfwkzxtrjV20","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":41,"key":41,"name":"\u5b89\u5168\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1276,"key":1276,"name":"\u6df1\u4fe1\u670d\u96f6\u4fe1\u4efb\u8bbf\u95ee\u63a7\u5236\u7cfb\u7edf\u8f6f\u4ef6V2.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":7285,"project_id":3493,"product_id":981,"amount":"0","number":30,"cost":"250","description":"\u6388\u6743\u4e70\u65ad","supplier_id":640,"hardware_from":null,"software_from":"2024-09-23","maintenance_from":null,"hardware_to":null,"software_to":"2027-09-23","maintenance_to":null,"total_amount":"0","total_cost":"7500","supplier":{"id":640,"key":640,"name":"\u5317\u4eac\u4e16\u7eaa\u7f51\u6e90\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":981,"name":"\u6df1\u4fe1\u670d\u96f6\u4fe1\u4efb\u63a5\u5165\u6388\u6743\u8f6f\u4ef6V2.0","product_type":7,"product_component":41,"product_brand":12,"product_serie":1275,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-09 09:33:19","updated_at":"2024-03-11 13:56:43","pinyin_shortcut":"sxflxrjrsqrjV20","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":41,"key":41,"name":"\u5b89\u5168\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1275,"key":1275,"name":"\u6df1\u4fe1\u670d\u96f6\u4fe1\u4efb\u63a5\u5165\u6388\u6743\u8f6f\u4ef6V2.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":7286,"project_id":3493,"product_id":1196,"amount":"0","number":4,"cost":"275","description":"","supplier_id":640,"hardware_from":"2024-09-23","software_from":null,"maintenance_from":null,"hardware_to":"2027-09-23","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"1100","supplier":{"id":640,"key":640,"name":"\u5317\u4eac\u4e16\u7eaa\u7f51\u6e90\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1196,"name":"\u5343\u5146\u591a\u6a21-850-550m-\u53cc\u7ea4","product_type":4,"product_component":43,"product_brand":12,"product_serie":748,"product_misc":null,"product_qa":null,"pn":"","description":"SFP\u5343\u5146\u591a\u6a21\u5149\u6a21\u5757\uff0c\u901f\u7387\uff1a1.25Gb\/s\uff0c\u6ce2\u957f\uff1a850nm\uff0c\u4f20\u8f93\u8ddd\u79bb\uff1a0.55km\uff0c\u53ccLC\u63a5\u53e3","created_by":1013,"created_at":"2024-01-09 16:10:20","updated_at":"2024-01-09 16:10:20","pinyin_shortcut":"qzdm850550msx","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":748,"key":748,"name":"\u6df1\u4fe1\u670d\u5343\u5146\u591a\u6a21\u5149\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}}],"projectContactPoints":[{"id":727,"project_id":3493,"contact_id":846,"point":"55028.00","paid_point":"55028","contact":{"id":846,"key":846,"name":"\u674e\u4e1c","client_id":141,"supplier_id":null,"client":{"id":141,"key":141,"name":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":127,"project_id":3493,"contact_id":846,"point":"55028.00","day_at":"2024-11-07","description":"","created_at":"2024-11-07 10:34:23"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":11025,"project_id":3493},{"id":11026,"project_id":3493},{"id":11027,"project_id":3493},{"id":11024,"project_id":3493},{"id":11000,"project_id":3493},{"id":11001,"project_id":3493},{"id":11002,"project_id":3493},{"id":11003,"project_id":3493},{"id":11004,"project_id":3493},{"id":11005,"project_id":3493},{"id":11006,"project_id":3493},{"id":11007,"project_id":3493},{"id":11008,"project_id":3493},{"id":11009,"project_id":3493},{"id":11010,"project_id":3493},{"id":11011,"project_id":3493},{"id":11012,"project_id":3493},{"id":11013,"project_id":3493},{"id":11014,"project_id":3493},{"id":11015,"project_id":3493},{"id":11016,"project_id":3493},{"id":11017,"project_id":3493},{"id":11018,"project_id":3493},{"id":11019,"project_id":3493},{"id":11020,"project_id":3493},{"id":11021,"project_id":3493},{"id":11022,"project_id":3493},{"id":11023,"project_id":3493},{"id":9815,"project_id":3493},{"id":9814,"project_id":3493},{"id":11028,"project_id":3493},{"id":11029,"project_id":3493},{"id":11030,"project_id":3493},{"id":11031,"project_id":3493},{"id":11032,"project_id":3493},{"id":11033,"project_id":3493},{"id":11034,"project_id":3493},{"id":11035,"project_id":3493}],"reimbursementAmountSum":{"project_id":3493,"sum":"1068"},"profit":3538.3,"contact_points_status_display":"\u5df2\u6838\u9500"},"salesSupplierRels":[{"id":1977,"contract_id":3543,"supplier_id":640,"purchase_id":3575,"supplier":{"id":640,"key":640,"name":"\u5317\u4eac\u4e16\u7eaa\u7f51\u6e90\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3575,"key":3575,"serial_no":"TSKJ20241009-HYF-003"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7015,"user_id":5300,"key":5300,"contract_id":3543,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":7016,"user_id":5388,"key":5388,"contract_id":3543,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7017,"user_id":1001,"key":1001,"contract_id":3543,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2071,"key":2071,"contract_id":3543,"name":"2024-09-30","value":"129450","overdue_days":null,"pct":75,"collect_status":"\u5df2\u5b8c\u6210"},{"id":2072,"key":2072,"contract_id":3543,"name":"2024-11-15","value":"43150","overdue_days":null,"pct":25,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1975,"key":1975,"contract_id":3543,"value":"129450","created_by":5388,"created_at":"2024-09-26 17:57:38","description":"","collected_date":"2024-09-26","amount":"129450","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"files":[{"id":28989,"object_type":109,"object_id":1975,"attachment_id":21726,"attachment":{"id":21726,"key":21726,"name":"83687756-7d86-3dbc-9ac7-f546a2cf5a07","extension":"png","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/83687756-7d86-3dbc-9ac7-f546a2cf5a07\/image.png","orig_name":"image.png"}}],"pct":75},{"id":2000,"key":2000,"contract_id":3543,"value":"43150","created_by":1013,"created_at":"2024-10-30 11:04:54","description":"","collected_date":"2024-10-30","amount":"43150","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":29791,"object_type":109,"object_id":2000,"attachment_id":22339,"attachment":{"id":22339,"key":22339,"name":"4bccf83c-444e-32fe-bde0-089064eeec4d","extension":"png","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/4bccf83c-444e-32fe-bde0-089064eeec4d\/image.png","orig_name":"image.png"}}],"pct":25}],"salesContractInvoices":[{"id":1801,"key":1801,"contract_id":3543,"value":"172600.00","attachment_id":null,"from_date":"2024-09-14","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":28750,"object_type":102,"object_id":1801,"attachment_id":21531,"attachment":{"id":21531,"key":21531,"name":"a0386ebc-20ef-3ef7-8e73-8daa9ae36d04","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/a0386ebc-20ef-3ef7-8e73-8daa9ae36d04\/dzfp_24112000000130796745_\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8_20240914171247.pdf","orig_name":"dzfp_24112000000130796745_\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8_20240914171247.pdf"}}]}],"contractScans":[{"id":30053,"object_type":105,"object_id":3543,"attachment_id":21514,"attachment":{"id":21514,"key":21514,"name":"c1082e45-ee27-3c13-81ea-10cace19938f","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/c1082e45-ee27-3c13-81ea-10cace19938f\/20240913143217076.pdf","orig_name":"20240913143217076.pdf"}}],"receiptScans":[{"id":30381,"object_type":106,"object_id":3543,"attachment_id":22679,"attachment":{"id":22679,"key":22679,"name":"896dfb1a-b335-3c7c-9fc5-f2dc1753a109","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/896dfb1a-b335-3c7c-9fc5-f2dc1753a109\/20241114094644311.pdf","orig_name":"20241114094644311.pdf"}}],"verifyScans":[{"id":30382,"object_type":107,"object_id":3543,"attachment_id":21878,"attachment":{"id":21878,"key":21878,"name":"391f6a32-c4ea-3f4a-9052-ac9a4a339430","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/391f6a32-c4ea-3f4a-9052-ac9a4a339430\/\u5929\u6d25\u878d\u5b9d\u9a8c\u6536\u5355.pdf","orig_name":"\u5929\u6d25\u878d\u5b9d\u9a8c\u6536\u5355.pdf"}}],"unreadComments":null,"collected_plan":172600,"projectProductTotalAmount":172600,"projectProductAllAmount":true,"projectProductTotalCost":90600,"projectProductAllCost":true,"projectProductTotalCount":38,"invoiced":172600,"un_invoiced":0,"collected":172600,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":2993,"client_id":141,"signed_at":"2023-11-30","amount":"175000","handler":5364,"description":"","created_by":5364,"created_at":"2023-12-07 14:29:20","updated_at":"2024-05-10 14:27:16","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3375,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WYC-2023113001","payment_collection_remind_ahead":"","from_project":3375,"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":141,"key":141,"name":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5364,"key":5364,"name":"\u738b\u827a\u742e","sex":"F","department_id":1,"avatar":{"id":154,"user_id":5364,"name":"\/files\/cdn\/a57be577deb434\/avatar\/a0b46fdc-d67f-305c-82e5-5b2e01c08e21.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2993,"comment":5},"project":{"id":3375,"key":3375,"name":"\u6d6a\u6f6e\u5b58\u50a8\u78c1\u76d8\u9635\u5217"},"fromProject":{"id":3375,"key":3375,"name":"\u6d6a\u6f6e\u5b58\u50a8\u78c1\u76d8\u9635\u5217","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":132,"bargain_date":"2023-11-30","collected":"175000","profit_pct":"2.05","budget":"175000","projectProductTypes":[{"id":2703,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"175000.00","pct":"2.05","project_id":3375,"profit":"3587.5"}],"projectProductRels":[{"id":2845,"project_id":3375,"product_id":1125,"amount":"175000","number":1,"cost":"166250","description":"\u6d6a\u6f6eAS2600G2\uff0812\uff09 - 64GB\uff0c\u53cc\u63a7, \u6807\u914d64GB\u7f13\u5b58\uff1b\u6807\u914dBBU+Flash\uff1b\u6807\u914d\u672c\u5730\u590d\u5236\uff08\u5feb\u7167\u3001\u5377\u955c\u50cf\u3001\u5377\u514b\u9686\u3001\u5377\u5907\u4efd\u3001\u8fc1\u79fb\uff09\u3001\u81ea\u7cbe\u7b80\u3001QoS\u3001DRAID\u529f\u80fd\uff1b\u6807\u914d8\u4e2a1Gb iSCSI\u4e3b\u673a\u63a5\u53e3\uff0c\u53ef\u6269\u5c55FC\u3001\u4e07\u5146\u3001\u5343\u5146\u3001FCoE\u4e3b\u673a\u63a5\u53e3 14T*12 \/\u667a\u80fd\u6587\u4ef6\u670d\u52a1\u8f6f\u4ef6(NAS)\u542b\u4e09\u5e74\u8d28\u4fdd\u4e0e\u534f\u52a9\u5b89\u88c5\u90e8\u7f72\u670d\u52a1","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"175000","total_cost":"166250","supplier":null,"product":{"id":1125,"name":"AS2600G2","product_type":3,"product_component":14,"product_brand":24,"product_serie":170,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-12-07 14:34:21","updated_at":"2024-01-16 14:38:47","pinyin_shortcut":"AS2600G2","product_unit":1,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":14,"key":14,"name":"\u5b58\u50a8\u4e3b\u673a"},"productBrand":{"id":24,"key":24,"name":"\u6d6a\u6f6e"},"productSerie":{"id":170,"key":170,"name":"AS2600G2\u5b58\u50a8"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":5651,"project_id":3375}],"reimbursementAmountSum":null,"profit":3587.5,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":1141,"contract_id":2993,"supplier_id":564,"purchase_id":3003,"supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3003,"key":3003,"serial_no":"TSKJ20231212-HYF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5364,"key":5364,"name":"\u738b\u827a\u742e","sex":"F","department_id":1,"avatar":{"id":154,"user_id":5364,"name":"\/files\/cdn\/a57be577deb434\/avatar\/a0b46fdc-d67f-305c-82e5-5b2e01c08e21.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8058,"user_id":5300,"key":5300,"contract_id":2993,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[{"id":1445,"key":1445,"contract_id":2993,"name":"2023-12-15","value":"131250","overdue_days":12,"pct":75,"collect_status":"\u5df2\u5b8c\u6210"},{"id":1446,"key":1446,"contract_id":2993,"name":"2024-01-10","value":"43750","overdue_days":26,"pct":25,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1740,"key":1740,"contract_id":2993,"value":"131250","created_by":1014,"created_at":"2023-12-27 10:54:47","description":"","collected_date":"2023-12-27","amount":"131250","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[{"id":22745,"object_type":109,"object_id":1740,"attachment_id":16929,"attachment":{"id":16929,"key":16929,"name":"a62de9d7-4108-3764-8abc-e3e9cdc5a796","extension":"png","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/a62de9d7-4108-3764-8abc-e3e9cdc5a796\/image.png","orig_name":"image.png"}}],"pct":75},{"id":1776,"key":1776,"contract_id":2993,"value":"43750","created_by":1014,"created_at":"2024-02-19 09:48:12","description":"","collected_date":"2024-02-05","amount":"43750","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[{"id":23926,"object_type":109,"object_id":1776,"attachment_id":17569,"attachment":{"id":17569,"key":17569,"name":"3a35b575-fe87-343c-ac58-e23605b783e2","extension":"png","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/3a35b575-fe87-343c-ac58-e23605b783e2\/image.png","orig_name":"image.png"}}],"pct":25}],"salesContractInvoices":[{"id":1552,"key":1552,"contract_id":2993,"value":"175000.00","attachment_id":null,"from_date":"2023-12-07","description":"","is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":22205,"object_type":102,"object_id":1552,"attachment_id":16421,"attachment":{"id":16421,"key":16421,"name":"672693f7-15f3-354c-bcb9-13c0f5f13444","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/672693f7-15f3-354c-bcb9-13c0f5f13444\/2023_12_07_17_06_59.pdf","orig_name":"2023_12_07_17_06_59.pdf"}}]}],"contractScans":[{"id":23556,"object_type":105,"object_id":2993,"attachment_id":16429,"attachment":{"id":16429,"key":16429,"name":"e0ae577a-938e-3068-946e-996b667238c6","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/e0ae577a-938e-3068-946e-996b667238c6\/2023_12_08_10_02_10.pdf","orig_name":"2023_12_08_10_02_10.pdf"}}],"receiptScans":[{"id":22898,"object_type":106,"object_id":2993,"attachment_id":16495,"attachment":{"id":16495,"key":16495,"name":"ea550987-10bc-3002-beb2-ee88523be156","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/ea550987-10bc-3002-beb2-ee88523be156\/20231211151028392.pdf","orig_name":"20231211151028392.pdf"}}],"verifyScans":[{"id":22899,"object_type":107,"object_id":2993,"attachment_id":17033,"attachment":{"id":17033,"key":17033,"name":"54a754e8-a1d6-3b9d-a309-9e60155269f5","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/54a754e8-a1d6-3b9d-a309-9e60155269f5\/2024_01_05_14_32_57.pdf","orig_name":"2024_01_05_14_32_57.pdf"}}],"unreadComments":null,"collected_plan":175000,"projectProductTotalAmount":175000,"projectProductAllAmount":true,"projectProductTotalCost":166250,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":175000,"un_invoiced":0,"collected":175000,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.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}],"pagenation":{"totalcount":4,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-17 19:33:15') RETURNING "id"