ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6870b580a0cfa: POST https://beta.jinchangxiao.com/v2/sales-contract/list at 2025-07-11 02:56:00 pm by 223.104.40.121

Log Messages

总计76条数据
TimeLevelCategoryMessage
 
14:56:00.658traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
14:56:00.658traceyii\base\Module::getModuleLoading module: debug
14:56:00.658traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
14:56:00.658traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
14:56:00.658traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
14:56:00.658traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:56:00.659traceyii\base\Module::getModuleLoading module: gii
14:56:00.659traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
14:56:00.659traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
14:56:00.659traceyii\web\Application::handleRequestRoute requested: 'v2/sales-contract/list'
14:56:00.659traceyii\base\Module::getModuleLoading module: v2
14:56:00.659infoyii\web\Session::openSession started
14:56:00.660infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:56:00.662infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH'
14:56:00.664traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:56:00.665traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:56:00.665traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:56:00.665traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:56:00.665infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
14:56:00.666traceyii\base\Controller::runActionRoute to run: v2/sales-contract/list
14:56:00.667traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:56:00.667traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
14:56:00.667traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\SalesContractController::actionList()
14:56:00.667traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:56:00.668traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:56:00.668traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:56:00.669traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:56:00.670infoyii\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 (true) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) GROUP BY "c"."id" ORDER BY "passed" DESC, "b_date" DESC) "c"
14:56:00.680infoyii\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 (true) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) GROUP BY "c"."id" ORDER BY "passed" DESC, "b_date" DESC LIMIT 10
14:56:00.691infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (152, 15, 89, 57, 140, 531, 166, 574, 23, 90)
14:56:00.691infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5311, 5295, 1004)
14:56:00.692infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5311, 5295, 1005, 1004))
14:56:00.692infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "orig_name", "extension", "path" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (355, 306, 796, 833, 512, 615, 660, 669, 29, 797)
14:56:00.694infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "orig_name", "extension", "path" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (513, 30)
14:56:00.694infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1028, 1002, 1010, 5015)
14:56:00.694infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1028, 5015, 1002, 1010))
14:56:00.695infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (9, 4)
14:56:00.695infoyii\db\Command::querySELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (31, 139, 147, 192, 239, 281, 305, 308, 21, 335)) GROUP BY "object_id"
14:56:00.713infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (99, 237, 185, 271, 321, 364, 458, 486, 67, 534)
14:56:00.714infoyii\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 (99, 237, 185, 271, 321, 364, 458, 486, 67, 534)
14:56:00.715infoyii\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 (321, 458, 486, 185, 237, 534, 364, 99, 271, 67)
14:56:00.715infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (321, 458, 486, 185, 237, 534, 364, 99, 271, 67)
14:56:00.716infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (321, 458, 486, 185, 237, 534, 364, 99, 271, 67)
14:56:00.716infoyii\db\Command::querySELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (321, 458, 486, 185, 237, 534, 364, 99, 271, 67))
14:56:00.719infoyii\db\Command::querySELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (3, 2)) AND ("project_id" IN (321, 458, 486, 185, 237, 534, 364, 99, 271, 67)) GROUP BY "project_id"
14:56:00.720infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (31, 139, 147, 192, 239, 281, 305, 308, 21, 335)
14:56:00.721infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (261, 112)
14:56:00.721infoyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (816, 82)
14:56:00.722infoyii\db\Command::querySELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (2, 1)
14:56:00.723infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1007, 1004, 1006, 1008, 5045, 1005)
14:56:00.723infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1008, 1006, 1005, 1007, 1004, 5045))
14:56:00.724infoyii\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 (31, 139, 147, 192, 239, 281, 305, 308, 21, 335)) ORDER BY "remind_date"
14:56:00.724infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id" IN (31, 139, 147, 192, 239, 281, 305, 308, 21, 335)
14:56:00.724infoyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (31, 139, 147, 192, 239, 281, 305, 308, 21, 335)
14:56:00.725infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5311
14:56:00.725infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5311)
14:56:00.726infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (31, 139, 147, 192, 239, 281, 305, 308, 21, 335)
14:56:00.726infoyii\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 (31, 139, 147, 192, 239, 281, 305, 308, 21, 335)
14:56:00.726infoyii\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 (31, 139, 147, 192, 239, 281, 305, 308, 21, 335) ORDER BY "remind_date"
14:56:00.727infoyii\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 (31, 139, 147, 192, 239, 281, 305, 308, 21, 335) ORDER BY "id"
14:56:00.728infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=109) AND ("object_id" IN (49, 115, 266, 455, 465, 467, 611, 733, 765, 774))
14:56:00.729infoyii\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 (31, 139, 147, 192, 239, 281, 305, 308, 21, 335) ORDER BY "id"
14:56:00.730infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (123, 281, 305, 485, 536, 601, 614, 646, 812, 829))
14:56:00.731infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (123, 281, 305, 485, 536, 601, 614, 646, 812, 829))
14:56:00.732infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (31, 139, 147, 192, 239, 281, 305, 308, 21, 335))
14:56:00.733infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (660, 669, 796, 306, 615, 355, 833, 512, 797, 29)
14:56:00.734infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (31, 139, 147, 192, 239, 281, 305, 308, 21, 335))
14:56:00.735infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (30, 513)
14:56:00.735infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (31, 139, 147, 192, 239, 281, 305, 308, 21, 335))
14:56:00.737infoyii\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 (31, 139, 147, 192, 239, 281, 305, 308, 21, 335)) GROUP BY "object_id"
14:56:00.752traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewProduct
14:56:00.752traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Accountant
14:56:00.752traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
14:56:00.753traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:56:00.753traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:56:00.753infoyii\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, 2, 1141, 'v2/sales-contract/list', '{"Filter":{"name":"expire_date","sort":"DESC"},"SalesContractSearch":{"contract_type":"","handler":"","keyword":""},"access_token":"oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH","device_type":"2","posttime":"1752216960","token":"5e42d66c23332039d18a83d9a5765343","version_code":"1141"}', '{"code":200,"data":{"list":[{"id":31,"client_id":152,"signed_at":"2017-03-09","amount":"1000","handler":1007,"description":" \u7cfb\u7edf\u5b89\u88c5\u5b9e\u65bd","created_by":1028,"created_at":"2017-03-13 09:08:45","updated_at":"2021-06-28 14:20:36","contract_scan":355,"receipt_scan":null,"contract_type":2,"project_id":99,"valid_date":null,"expire_date":"2017-03-09","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"TSC-X-2017031007","payment_collection_remind_ahead":"","from_project":99,"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":3046,"passed":2,"client":{"id":152,"key":152,"name":"\u683c\u745e\u4fe1\u65c5\u6e38\u54a8\u8be2(\u5317\u4eac)\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":null,"salesRep":null},"contractScan":{"id":355,"key":355,"name":"a83779f1-7293-3446-9700-40789c7cbd75","orig_name":"\u683c\u745e\u4fe1\u65c5\u6e38\u54a8\u8be2\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\u201420170309\u20141000.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/a83779f1-7293-3446-9700-40789c7cbd75\/\u683c\u745e\u4fe1\u65c5\u6e38\u54a8\u8be2\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\u201420170309\u20141000.pdf","download":"\/vue\/attachment\/download?name=a83779f1-7293-3446-9700-40789c7cbd75"},"receiptScan":null,"createdBy":{"id":1028,"key":1028,"name":"\u5d14\u9e64\u5a77","sex":"F","department_id":9,"avatar":null,"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{"object_id":31,"comment":5},"project":{"id":99,"key":99,"name":"(\u672a\u8bbe\u7f6e)"},"fromProject":{"id":99,"key":99,"name":"(\u672a\u8bbe\u7f6e)","description":" \u7cfb\u7edf\u5b89\u88c5\u5b9e\u65bd","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-03-10","collected":"1000.00","profit_pct":"100","budget":"1000","projectProductTypes":[{"id":4138,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"1000","pct":"100","project_id":99,"profit":"1000"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":1000,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":1007,"key":1007,"name":"\u5b59\u6167","sex":"F","department_id":9,"avatar":{"id":7,"user_id":1007,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1007.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":49,"key":49,"contract_id":31,"value":"1000.00","created_by":null,"created_at":"","description":null,"collected_date":null,"amount":"1000.00","createdBy":null,"files":[],"pct":100}],"salesContractInvoices":[{"id":281,"key":281,"contract_id":31,"value":"1000.00","attachment_id":null,"from_date":null,"description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12646,"object_type":105,"object_id":31,"attachment_id":355,"attachment":{"id":355,"key":355,"name":"a83779f1-7293-3446-9700-40789c7cbd75","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/a83779f1-7293-3446-9700-40789c7cbd75\/\u683c\u745e\u4fe1\u65c5\u6e38\u54a8\u8be2\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\u201420170309\u20141000.pdf","orig_name":"\u683c\u745e\u4fe1\u65c5\u6e38\u54a8\u8be2\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\u201420170309\u20141000.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":1000,"un_invoiced":0,"collected":1000,"un_collected":0,"is_collected":true,"handlerPerson":null,"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":139,"client_id":15,"signed_at":"2017-06-02","amount":"3000","handler":1004,"description":"\u865a\u62df\u673a\u8fc1\u79fb","created_by":1002,"created_at":"2017-06-19 12:24:03","updated_at":"2021-06-22 16:28:57","contract_scan":306,"receipt_scan":null,"contract_type":2,"project_id":237,"valid_date":null,"expire_date":"2017-06-09","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"-","payment_collection_remind_ahead":"","from_project":237,"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":2954,"passed":2,"client":{"id":15,"key":15,"name":"\u4e2d\u51b6\u4eac\u8bda\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u4eac\u8bda\u745e\u8fbe\u7535\u6c14\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)(\u5317\u4eac\u4eac\u8bda\u8d5b\u745e\u56fe\u6587\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}},"contractScan":{"id":306,"key":306,"name":"a17872af-d814-3e2e-83ba-596fa19069d9","orig_name":"\u5317\u4eac\u4eac\u8bda\u745e\u8fbe\u7535\u5668\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\u201420170602\u20143000.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/a17872af-d814-3e2e-83ba-596fa19069d9\/\u5317\u4eac\u4eac\u8bda\u745e\u8fbe\u7535\u5668\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\u201420170602\u20143000.pdf","download":"\/vue\/attachment\/download?name=a17872af-d814-3e2e-83ba-596fa19069d9"},"receiptScan":null,"createdBy":{"id":1002,"key":1002,"name":"\u987e\u5a1c\u5a1c","sex":"F","department_id":4,"avatar":null,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{"object_id":139,"comment":5},"project":{"id":237,"key":237,"name":"\u8fc1\u79fb\u670d\u52a1"},"fromProject":{"id":237,"key":237,"name":"\u8fc1\u79fb\u670d\u52a1","description":"\u865a\u62df\u673a\u8fc1\u79fb","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-06-02","collected":"3000.00","profit_pct":"100","budget":"3000","projectProductTypes":[{"id":2081,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"3000","pct":"100","project_id":237,"profit":"3000"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":3000,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":195,"contract_id":139,"supplier_id":261,"purchase_id":816,"supplier":{"id":261,"key":261,"name":"\u5317\u4eac\u5929\u6e2f\u60e0\u8fbe\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":816,"key":816,"serial_no":"-"}}],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"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":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":765,"key":765,"contract_id":139,"value":"3000.00","created_by":null,"created_at":"","description":null,"collected_date":null,"amount":"3000.00","createdBy":null,"files":[],"pct":100}],"salesContractInvoices":[{"id":601,"key":601,"contract_id":139,"value":"3000.00","attachment_id":null,"from_date":null,"description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12572,"object_type":105,"object_id":139,"attachment_id":306,"attachment":{"id":306,"key":306,"name":"a17872af-d814-3e2e-83ba-596fa19069d9","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/a17872af-d814-3e2e-83ba-596fa19069d9\/\u5317\u4eac\u4eac\u8bda\u745e\u8fbe\u7535\u5668\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\u201420170602\u20143000.pdf","orig_name":"\u5317\u4eac\u4eac\u8bda\u745e\u8fbe\u7535\u5668\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\u201420170602\u20143000.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":3000,"un_invoiced":0,"collected":3000,"un_collected":0,"is_collected":true,"handlerPerson":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.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":147,"client_id":89,"signed_at":"2017-06-23","amount":"30000","handler":1006,"description":"\u673a\u623f\u8bbe\u5907\u642c\u8fc1","created_by":1010,"created_at":"2017-06-25 20:30:30","updated_at":"2021-06-23 17:02:49","contract_scan":796,"receipt_scan":null,"contract_type":2,"project_id":185,"valid_date":null,"expire_date":"2017-06-25","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"-","payment_collection_remind_ahead":"","from_project":185,"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":2938,"passed":2,"client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},"contractScan":{"id":796,"key":796,"name":"f9979833-a57d-3a0f-8f29-85730e896990","orig_name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u201420170623\u201430000.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/f9979833-a57d-3a0f-8f29-85730e896990\/\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u201420170623\u201430000.pdf","download":"\/vue\/attachment\/download?name=f9979833-a57d-3a0f-8f29-85730e896990"},"receiptScan":null,"createdBy":{"id":1010,"key":1010,"name":"\u9ad8\u73b2\u8273","sex":"F","department_id":9,"avatar":null,"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{"object_id":147,"comment":5},"project":{"id":185,"key":185,"name":"\u673a\u623f\u642c\u8fc1"},"fromProject":{"id":185,"key":185,"name":"\u673a\u623f\u642c\u8fc1","description":"\u673a\u623f\u8bbe\u5907\u642c\u8fc1","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-06-23","collected":"30000.00","profit_pct":"100","budget":"30000","projectProductTypes":[{"id":2078,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"30000","pct":"100","project_id":185,"profit":"30000"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":185,"sum":"16968"},"profit":30000,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":611,"key":611,"contract_id":147,"value":"30000.00","created_by":null,"created_at":"","description":null,"collected_date":null,"amount":"30000.00","createdBy":null,"files":[],"pct":100}],"salesContractInvoices":[{"id":536,"key":536,"contract_id":147,"value":"30000.00","attachment_id":null,"from_date":null,"description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12570,"object_type":105,"object_id":147,"attachment_id":796,"attachment":{"id":796,"key":796,"name":"f9979833-a57d-3a0f-8f29-85730e896990","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/f9979833-a57d-3a0f-8f29-85730e896990\/\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u201420170623\u201430000.pdf","orig_name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u201420170623\u201430000.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":30000,"un_invoiced":0,"collected":30000,"un_collected":0,"is_collected":true,"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.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":192,"client_id":57,"signed_at":"2017-07-19","amount":"200","handler":1006,"description":"ASA\u6392\u9519\u670d\u52a1","created_by":5015,"created_at":"2017-07-20 17:21:45","updated_at":"2021-06-23 17:02:34","contract_scan":833,"receipt_scan":null,"contract_type":2,"project_id":271,"valid_date":null,"expire_date":"2017-07-12","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"-","payment_collection_remind_ahead":"","from_project":271,"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":2921,"passed":2,"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8","logo":null,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},"contractScan":{"id":833,"key":833,"name":"6f6de126-3241-3480-8dc7-4a82dabecced","orig_name":"\u4fdd\u8bfa\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\u201420170711\u2014200.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/6f6de126-3241-3480-8dc7-4a82dabecced\/\u4fdd\u8bfa\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\u201420170711\u2014200.pdf","download":"\/vue\/attachment\/download?name=6f6de126-3241-3480-8dc7-4a82dabecced"},"receiptScan":null,"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","department_id":9,"avatar":{"id":5,"user_id":5015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{"object_id":192,"comment":5},"project":{"id":271,"key":271,"name":"ASA\u6280\u672f\u652f\u6301\u670d\u52a1"},"fromProject":{"id":271,"key":271,"name":"ASA\u6280\u672f\u652f\u6301\u670d\u52a1","description":"ASA\u6392\u9519\u670d\u52a1","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-07-20","collected":"200.00","profit_pct":"100","budget":"200","projectProductTypes":[{"id":2084,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"200","pct":"100","project_id":271,"profit":"200"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":200,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":455,"key":455,"contract_id":192,"value":"200.00","created_by":null,"created_at":"","description":null,"collected_date":null,"amount":"200.00","createdBy":null,"files":[],"pct":100}],"salesContractInvoices":[{"id":485,"key":485,"contract_id":192,"value":"200.00","attachment_id":null,"from_date":null,"description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12666,"object_type":105,"object_id":192,"attachment_id":833,"attachment":{"id":833,"key":833,"name":"6f6de126-3241-3480-8dc7-4a82dabecced","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/6f6de126-3241-3480-8dc7-4a82dabecced\/\u4fdd\u8bfa\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\u201420170711\u2014200.pdf","orig_name":"\u4fdd\u8bfa\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\u201420170711\u2014200.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":200,"un_invoiced":0,"collected":200,"un_collected":0,"is_collected":true,"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.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":239,"client_id":140,"signed_at":"2017-08-03","amount":"2100","handler":1007,"description":"4G\u5185\u5b58\u4e00\u6839\r\n1600\u7ef4\u62a4\u8c03\u8bd5\u8d39","created_by":5015,"created_at":"2017-09-06 15:45:13","updated_at":"2021-06-28 14:48:56","contract_scan":512,"receipt_scan":513,"contract_type":1,"project_id":321,"valid_date":null,"expire_date":"2017-08-03","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"-","payment_collection_remind_ahead":"","from_project":321,"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":2899,"passed":2,"client":{"id":140,"key":140,"name":"\u5317\u4eac\u8c0a\u5b89\u533b\u7597\u7cfb\u7edf\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","sales_rep":null,"salesRep":null},"contractScan":{"id":512,"key":512,"name":"714933b3-135b-3659-9851-30e927e203be","orig_name":"\u8c0a\u5b89\u533b\u7597\u20142100\u201420170803.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/714933b3-135b-3659-9851-30e927e203be\/\u8c0a\u5b89\u533b\u7597\u20142100\u201420170803.pdf","download":"\/vue\/attachment\/download?name=714933b3-135b-3659-9851-30e927e203be"},"receiptScan":{"id":513,"key":513,"name":"3576127e-fe76-3857-b022-d3d6c9462067","orig_name":"\u8c0a\u5b89\u533b\u7597\u20142100\u201420170803.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/3576127e-fe76-3857-b022-d3d6c9462067\/\u8c0a\u5b89\u533b\u7597\u20142100\u201420170803.pdf","download":"\/vue\/attachment\/download?name=3576127e-fe76-3857-b022-d3d6c9462067"},"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","department_id":9,"avatar":{"id":5,"user_id":5015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{"object_id":239,"comment":5},"project":{"id":321,"key":321,"name":"\u8bbe\u5907\u7ef4\u62a4"},"fromProject":{"id":321,"key":321,"name":"\u8bbe\u5907\u7ef4\u62a4","description":"4G\u5185\u5b58\u4e00\u6839\r\n1600\u7ef4\u62a4\u8c03\u8bd5\u8d39","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-08-03","collected":"2100.00","profit_pct":"80","budget":"2100","projectProductTypes":[{"id":4663,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"2100","pct":"80","project_id":321,"profit":"1680"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":1680,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1007,"key":1007,"name":"\u5b59\u6167","sex":"F","department_id":9,"avatar":{"id":7,"user_id":1007,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1007.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":774,"key":774,"contract_id":239,"value":"2100.00","created_by":null,"created_at":"","description":null,"collected_date":null,"amount":"2100.00","createdBy":null,"files":[],"pct":100}],"salesContractInvoices":[{"id":614,"key":614,"contract_id":239,"value":"2100.00","attachment_id":null,"from_date":null,"description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12693,"object_type":105,"object_id":239,"attachment_id":512,"attachment":{"id":512,"key":512,"name":"714933b3-135b-3659-9851-30e927e203be","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/714933b3-135b-3659-9851-30e927e203be\/\u8c0a\u5b89\u533b\u7597\u20142100\u201420170803.pdf","orig_name":"\u8c0a\u5b89\u533b\u7597\u20142100\u201420170803.pdf"}}],"receiptScans":[{"id":13387,"object_type":106,"object_id":239,"attachment_id":513,"attachment":{"id":513,"key":513,"name":"3576127e-fe76-3857-b022-d3d6c9462067","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/3576127e-fe76-3857-b022-d3d6c9462067\/\u8c0a\u5b89\u533b\u7597\u20142100\u201420170803.pdf","orig_name":"\u8c0a\u5b89\u533b\u7597\u20142100\u201420170803.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":2100,"un_invoiced":0,"collected":2100,"un_collected":0,"is_collected":true,"handlerPerson":null,"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":281,"client_id":531,"signed_at":"2017-10-17","amount":"800","handler":1008,"description":"\u6280\u672f\u670d\u52a1\u4e0a\u95e8\u6545\u969c\u68c0\u6d4b","created_by":5015,"created_at":"2017-10-21 10:52:38","updated_at":"2021-06-25 16:03:49","contract_scan":615,"receipt_scan":null,"contract_type":2,"project_id":364,"valid_date":null,"expire_date":"2017-10-18","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"-","payment_collection_remind_ahead":"","from_project":364,"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":2823,"passed":2,"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}},"contractScan":{"id":615,"key":615,"name":"e42b6b54-b75d-3280-b37b-6c739cb15868","orig_name":"\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8\u201420171018\u2014800.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/e42b6b54-b75d-3280-b37b-6c739cb15868\/\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8\u201420171018\u2014800.pdf","download":"\/vue\/attachment\/download?name=e42b6b54-b75d-3280-b37b-6c739cb15868"},"receiptScan":null,"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","department_id":9,"avatar":{"id":5,"user_id":5015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{"object_id":281,"comment":5},"project":{"id":364,"key":364,"name":"\u6280\u672f\u670d\u52a1"},"fromProject":{"id":364,"key":364,"name":"\u6280\u672f\u670d\u52a1","description":"\u6280\u672f\u670d\u52a1\u4e0a\u95e8\u6545\u969c\u68c0\u6d4b","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-10-18","collected":"800.00","profit_pct":"100","budget":"800","projectProductTypes":[{"id":2083,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"800","pct":"100","project_id":364,"profit":"800"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":800,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8360,"user_id":5311,"key":5311,"contract_id":281,"user":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":465,"key":465,"contract_id":281,"value":"800.00","created_by":null,"created_at":"","description":null,"collected_date":null,"amount":"800.00","createdBy":null,"files":[],"pct":100}],"salesContractInvoices":[{"id":305,"key":305,"contract_id":281,"value":"800.00","attachment_id":null,"from_date":null,"description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12613,"object_type":105,"object_id":281,"attachment_id":615,"attachment":{"id":615,"key":615,"name":"e42b6b54-b75d-3280-b37b-6c739cb15868","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/e42b6b54-b75d-3280-b37b-6c739cb15868\/\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8\u201420171018\u2014800.pdf","orig_name":"\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8\u201420171018\u2014800.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":800,"un_invoiced":0,"collected":800,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"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":305,"client_id":166,"signed_at":"2017-11-14","amount":"1800","handler":5045,"description":"\u670d\u52a1\u5668\u68c0\u6d4b\u53ca\u66f4\u6362\u4e3b\u677f","created_by":5015,"created_at":"2017-11-16 23:52:35","updated_at":"2021-06-28 16:18:21","contract_scan":660,"receipt_scan":null,"contract_type":2,"project_id":458,"valid_date":"2017-11-14","expire_date":"2017-11-14","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"-","payment_collection_remind_ahead":"","from_project":458,"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":2796,"passed":2,"client":{"id":166,"key":166,"name":"\u5317\u4eac\u65b0\u5965\u73af\u6807\u7406\u5316\u5206\u6790\u6d4b\u8bd5\u4e2d\u5fc3","logo":null,"sales_rep":null,"salesRep":null},"contractScan":{"id":660,"key":660,"name":"4e2dc6b2-b809-3e6f-ac03-dcbc3d9de1b8","orig_name":"\u5317\u4eac\u65b0\u5965\u73af\u6807\u7406\u5316\u5206\u6790\u6d4b\u8bd5\u4e2d\u5fc3\u201420171114\u20141800.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/4e2dc6b2-b809-3e6f-ac03-dcbc3d9de1b8\/\u5317\u4eac\u65b0\u5965\u73af\u6807\u7406\u5316\u5206\u6790\u6d4b\u8bd5\u4e2d\u5fc3\u201420171114\u20141800.pdf","download":"\/vue\/attachment\/download?name=4e2dc6b2-b809-3e6f-ac03-dcbc3d9de1b8"},"receiptScan":null,"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","department_id":9,"avatar":{"id":5,"user_id":5015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{"object_id":305,"comment":5},"project":{"id":458,"key":458,"name":"\u5317\u4eac\u65b0\u5965\u73af\u6807\u670d\u52a1\u5668\u68c0\u6d4b\u53ca\u66f4\u6362"},"fromProject":{"id":458,"key":458,"name":"\u5317\u4eac\u65b0\u5965\u73af\u6807\u670d\u52a1\u5668\u68c0\u6d4b\u53ca\u66f4\u6362","description":"\u670d\u52a1\u5668\u68c0\u6d4b\u53ca\u66f4\u6362\u4e3b\u677f","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-11-16","collected":"1800.00","profit_pct":"100","budget":"1800","projectProductTypes":[{"id":2127,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"1800","pct":"100","project_id":458,"profit":"1800"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":1800,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":5045,"key":5045,"name":"\u5218\u5c0a\u559c","sex":"M","department_id":1,"avatar":{"id":29,"user_id":5045,"name":"\/files\/cdn\/a57be577deb434\/avatar\/6e8fd0a1-a836-309d-90a7-c16ee123e8aa.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":733,"key":733,"contract_id":305,"value":"1800.00","created_by":null,"created_at":"","description":null,"collected_date":null,"amount":"1800.00","createdBy":null,"files":[],"pct":100}],"salesContractInvoices":[{"id":829,"key":829,"contract_id":305,"value":"1800.00","attachment_id":null,"from_date":null,"description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12541,"object_type":105,"object_id":305,"attachment_id":660,"attachment":{"id":660,"key":660,"name":"4e2dc6b2-b809-3e6f-ac03-dcbc3d9de1b8","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/4e2dc6b2-b809-3e6f-ac03-dcbc3d9de1b8\/\u5317\u4eac\u65b0\u5965\u73af\u6807\u7406\u5316\u5206\u6790\u6d4b\u8bd5\u4e2d\u5fc3\u201420171114\u20141800.pdf","orig_name":"\u5317\u4eac\u65b0\u5965\u73af\u6807\u7406\u5316\u5206\u6790\u6d4b\u8bd5\u4e2d\u5fc3\u201420171114\u20141800.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":1800,"un_invoiced":0,"collected":1800,"un_collected":0,"is_collected":true,"handlerPerson":null,"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":308,"client_id":574,"signed_at":"2017-11-22","amount":"800","handler":5045,"description":"\u68c0\u6d4b\u673a\u5668\uff0c\u5b89\u88c5\u64cd\u4f5c\u7cfb\u7edf\u3002","created_by":5015,"created_at":"2017-11-23 09:55:55","updated_at":"2021-06-28 15:12:21","contract_scan":669,"receipt_scan":null,"contract_type":2,"project_id":486,"valid_date":"2017-11-22","expire_date":"2017-11-22","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"-","payment_collection_remind_ahead":"","from_project":486,"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":2788,"passed":2,"client":{"id":574,"key":574,"name":"(\u516c\u53f8\u592a\u5c0f)\u5317\u4eac\u91d1\u9a6c\u6613\u5408\u54c1\u724c\u54a8\u8be2\u6709\u9650\u516c\u53f8","logo":"","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}},"contractScan":{"id":669,"key":669,"name":"edf12f68-3052-37e0-bca3-4ac78ec0551e","orig_name":"\u5317\u4eac\u91d1\u9a6c\u6613\u5408\u54c1\u724c\u54a8\u8be2\u6709\u9650\u516c\u53f8\u201420171122\u2014800.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/edf12f68-3052-37e0-bca3-4ac78ec0551e\/\u5317\u4eac\u91d1\u9a6c\u6613\u5408\u54c1\u724c\u54a8\u8be2\u6709\u9650\u516c\u53f8\u201420171122\u2014800.pdf","download":"\/vue\/attachment\/download?name=edf12f68-3052-37e0-bca3-4ac78ec0551e"},"receiptScan":null,"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","department_id":9,"avatar":{"id":5,"user_id":5015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{"object_id":308,"comment":5},"project":{"id":486,"key":486,"name":"\u5317\u4eac\u91d1\u9a6c\u6613\u5408\u552e\u540e\u670d\u52a1"},"fromProject":{"id":486,"key":486,"name":"\u5317\u4eac\u91d1\u9a6c\u6613\u5408\u552e\u540e\u670d\u52a1","description":"\u68c0\u6d4b\u673a\u5668\uff0c\u5b89\u88c5\u64cd\u4f5c\u7cfb\u7edf\u3002","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-11-22","collected":"800.00","profit_pct":"100","budget":"800","projectProductTypes":[{"id":2077,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"800","pct":"100","project_id":486,"profit":"800"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":800,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":5045,"key":5045,"name":"\u5218\u5c0a\u559c","sex":"M","department_id":1,"avatar":{"id":29,"user_id":5045,"name":"\/files\/cdn\/a57be577deb434\/avatar\/6e8fd0a1-a836-309d-90a7-c16ee123e8aa.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":6913,"user_id":5311,"key":5311,"contract_id":308,"user":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":266,"key":266,"contract_id":308,"value":"800.00","created_by":null,"created_at":"","description":null,"collected_date":null,"amount":"800.00","createdBy":null,"files":[],"pct":100}],"salesContractInvoices":[{"id":812,"key":812,"contract_id":308,"value":"800.00","attachment_id":null,"from_date":null,"description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12569,"object_type":105,"object_id":308,"attachment_id":669,"attachment":{"id":669,"key":669,"name":"edf12f68-3052-37e0-bca3-4ac78ec0551e","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/edf12f68-3052-37e0-bca3-4ac78ec0551e\/\u5317\u4eac\u91d1\u9a6c\u6613\u5408\u54c1\u724c\u54a8\u8be2\u6709\u9650\u516c\u53f8\u201420171122\u2014800.pdf","orig_name":"\u5317\u4eac\u91d1\u9a6c\u6613\u5408\u54c1\u724c\u54a8\u8be2\u6709\u9650\u516c\u53f8\u201420171122\u2014800.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":800,"un_invoiced":0,"collected":800,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"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":21,"client_id":23,"signed_at":"2016-12-29","amount":"39600","handler":1005,"description":"cisco 3925\u8def\u7531\u5668\uff0c2960\u4ea4\u6362\u673a","created_by":1010,"created_at":"2017-02-28 14:14:05","updated_at":"2021-06-28 14:02:38","contract_scan":29,"receipt_scan":30,"contract_type":1,"project_id":67,"valid_date":null,"expire_date":"2017-12-28","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"1417319","payment_collection_remind_ahead":"","from_project":67,"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":2752,"passed":2,"client":{"id":23,"key":23,"name":"\u5a01\u8baf\u8054\u5408\u534a\u5bfc\u4f53(\u5317\u4eac)\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":null,"salesRep":null},"contractScan":{"id":29,"key":29,"name":"cd2dc0e4-468b-35fd-b850-348cd77a072a","orig_name":"\u5a01\u8baf\u8054\u5408\u534a\u5bfc\u4f53\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff0d20161229\uff0d39600.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/cd2dc0e4-468b-35fd-b850-348cd77a072a\/\u5a01\u8baf\u8054\u5408\u534a\u5bfc\u4f53\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff0d20161229\uff0d39600.pdf","download":"\/vue\/attachment\/download?name=cd2dc0e4-468b-35fd-b850-348cd77a072a"},"receiptScan":{"id":30,"key":30,"name":"e56a7d07-c65f-3ed4-af7e-9137f5dc7c2b","orig_name":"\u5a01\u8baf\u8054\u5408\u534a\u5bfc\u4f53\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff0d20170216.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/e56a7d07-c65f-3ed4-af7e-9137f5dc7c2b\/\u5a01\u8baf\u8054\u5408\u534a\u5bfc\u4f53\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff0d20170216.pdf","download":"\/vue\/attachment\/download?name=e56a7d07-c65f-3ed4-af7e-9137f5dc7c2b"},"createdBy":{"id":1010,"key":1010,"name":"\u9ad8\u73b2\u8273","sex":"F","department_id":9,"avatar":null,"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{"object_id":21,"comment":5},"project":{"id":67,"key":67,"name":"cisco 3925\u8def\u7531\u5668\uff0c2960\u4ea4\u6362\u673a"},"fromProject":{"id":67,"key":67,"name":"cisco 3925\u8def\u7531\u5668\uff0c2960\u4ea4\u6362\u673a","description":"cisco 3925\u8def\u7531\u5668\uff0c2960\u4ea4\u6362\u673a","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-02-16","collected":"39600.00","profit_pct":"34","budget":"39600","projectProductTypes":[{"id":3735,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"39600","pct":"34","project_id":67,"profit":"13464"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":13464,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":1303,"contract_id":21,"supplier_id":112,"purchase_id":82,"supplier":{"id":112,"key":112,"name":"\u5317\u4eac\u5723\u901a\u4f73\u4e1a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":82,"key":82,"serial_no":"-"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":467,"key":467,"contract_id":21,"value":"39600.00","created_by":null,"created_at":"","description":null,"collected_date":null,"amount":"39600.00","createdBy":null,"files":[],"pct":100}],"salesContractInvoices":[{"id":123,"key":123,"contract_id":21,"value":"39600.00","attachment_id":null,"from_date":null,"description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12466,"object_type":105,"object_id":21,"attachment_id":29,"attachment":{"id":29,"key":29,"name":"cd2dc0e4-468b-35fd-b850-348cd77a072a","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/cd2dc0e4-468b-35fd-b850-348cd77a072a\/\u5a01\u8baf\u8054\u5408\u534a\u5bfc\u4f53\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff0d20161229\uff0d39600.pdf","orig_name":"\u5a01\u8baf\u8054\u5408\u534a\u5bfc\u4f53\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff0d20161229\uff0d39600.pdf"}}],"receiptScans":[{"id":13200,"object_type":106,"object_id":21,"attachment_id":30,"attachment":{"id":30,"key":30,"name":"e56a7d07-c65f-3ed4-af7e-9137f5dc7c2b","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/e56a7d07-c65f-3ed4-af7e-9137f5dc7c2b\/\u5a01\u8baf\u8054\u5408\u534a\u5bfc\u4f53\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff0d20170216.pdf","orig_name":"\u5a01\u8baf\u8054\u5408\u534a\u5bfc\u4f53\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff0d20170216.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":39600,"un_invoiced":0,"collected":39600,"un_collected":0,"is_collected":true,"handlerPerson":null,"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":335,"client_id":90,"signed_at":"2017-12-07","amount":"37348","handler":1006,"description":"PA\u9632\u706b\u5899\u7684\u9001\u8d27\u4e0a\u67b6\u670d\u52a1","created_by":5015,"created_at":"2017-12-07 09:05:15","updated_at":"2021-06-24 14:57:21","contract_scan":797,"receipt_scan":null,"contract_type":2,"project_id":534,"valid_date":null,"expire_date":"2017-12-29","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"-","payment_collection_remind_ahead":"","from_project":534,"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":2751,"passed":2,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"contractScan":{"id":797,"key":797,"name":"57feec90-916d-38e2-a8ec-d5c736ca8b2b","orig_name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8\u201420171207\u201437348.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/57feec90-916d-38e2-a8ec-d5c736ca8b2b\/\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8\u201420171207\u201437348.pdf","download":"\/vue\/attachment\/download?name=57feec90-916d-38e2-a8ec-d5c736ca8b2b"},"receiptScan":null,"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","department_id":9,"avatar":{"id":5,"user_id":5015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{"object_id":335,"comment":5},"project":{"id":534,"key":534,"name":"PA\u9632\u706b\u5899\u9001\u8d27\u3001\u4e0a\u67b6"},"fromProject":{"id":534,"key":534,"name":"PA\u9632\u706b\u5899\u9001\u8d27\u3001\u4e0a\u67b6","description":"PA\u9632\u706b\u5899\u7684\u9001\u8d27\u4e0a\u67b6\u670d\u52a1","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-12-07","collected":"37348.00","profit_pct":"30","budget":"37348","projectProductTypes":[{"id":4662,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"37348","pct":"30","project_id":534,"profit":"11204.4"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":11204.4,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":115,"key":115,"contract_id":335,"value":"37348.00","created_by":null,"created_at":"","description":null,"collected_date":null,"amount":"37348.00","createdBy":null,"files":[],"pct":100}],"salesContractInvoices":[{"id":646,"key":646,"contract_id":335,"value":"37348.00","attachment_id":null,"from_date":null,"description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12694,"object_type":105,"object_id":335,"attachment_id":797,"attachment":{"id":797,"key":797,"name":"57feec90-916d-38e2-a8ec-d5c736ca8b2b","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/57feec90-916d-38e2-a8ec-d5c736ca8b2b\/\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8\u201420171207\u201437348.pdf","orig_name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8\u201420171207\u201437348.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":37348,"un_invoiced":0,"collected":37348,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"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":1498,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-11 14:56:00') RETURNING "id"