68955fa257903: POST https://beta.jinchangxiao.com/v2/sales-contract/of-client at 2025-08-08 10:23:30 am by 223.104.39.199
Database Queries
总计53条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 10:23:30.522 | 5.1 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA' |
| 10:23:30.531 | 1.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 10:23:30.534 | 1.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='304') AND ("deleted"=FALSE) |
| 10:23:30.537 | 6.5 ms | SELECT | SELECT COUNT(*) FROM (SELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE "client"."id"='304' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c" |
| 10:23:30.544 | 5.3 ms | SELECT | 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"='304' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10 |
| 10:23:30.550 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=304 |
| 10:23:30.550 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 10:23:30.551 | 0.3 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295) |
| 10:23:30.551 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "orig_name", "extension", "path" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (9033, 1276) |
| 10:23:30.552 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "orig_name", "extension", "path" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (9096, 1320) |
| 10:23:30.552 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 5015) |
| 10:23:30.552 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 5015)) |
| 10:23:30.553 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (1, 9) |
| 10:23:30.553 | 19.6 ms | SELECT | SELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (2351, 2150, 519)) GROUP BY "object_id" |
| 10:23:30.573 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (2914, 2667, 682) |
| 10:23:30.574 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (682, 2667, 2914)) |
| 10:23:30.574 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name", "description", "total_contact_point", "paid_contact_point", "is_sales_order_ready", "project_product_version_id", "bargain_date", "collected", "profit_pct", "budget" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (2914, 2667, 682) |
| 10:23:30.575 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (682, 2667, 2914)) |
| 10:23:30.576 | 0.6 ms | SELECT | SELECT "id", "product_type_id", "product_type_id" AS "key", "name", "budget", "pct", "project_id", "profit" FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (682, 2667, 2914) |
| 10:23:30.576 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (682, 2667, 2914) |
| 10:23:30.577 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (682, 2667, 2914) |
| 10:23:30.577 | 1.9 ms | SELECT | SELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (682, 2667, 2914)) |
| 10:23:30.579 | 1.5 ms | SELECT | SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (682, 2667, 2914)) GROUP BY "project_id" |
| 10:23:30.581 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (2351, 2150, 519) |
| 10:23:30.582 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (137, 86, 239, 59, 57, 50, 363, 87, 65, 63) |
| 10:23:30.582 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (2352, 2171, 526, 2153, 2170, 565, 566, 2169, 561, 562, 591) |
| 10:23:30.583 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id"=1 |
| 10:23:30.583 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 1008) |
| 10:23:30.584 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1008, 5295)) |
| 10:23:30.584 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("reminded"=FALSE) AND ("contract_id" IN (2351, 2150, 519)) ORDER BY "remind_date" |
| 10:23:30.584 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id" IN (2351, 2150, 519) |
| 10:23:30.585 | 0.4 ms | SELECT | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (2351, 2150, 519) |
| 10:23:30.585 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5295) |
| 10:23:30.585 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 5295)) |
| 10:23:30.586 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (2351, 2150, 519) |
| 10:23:30.586 | 0.3 ms | SELECT | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (2351, 2150, 519) |
| 10:23:30.587 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 10:23:30.587 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295) |
| 10:23:30.587 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (2351, 2150, 519) ORDER BY "remind_date" |
| 10:23:30.588 | 3.2 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "created_at", "description", "collected_date", "amount" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) )) "sub") "r" WHERE "contract_id" IN (2351, 2150, 519) ORDER BY "id" DESC |
| 10:23:30.591 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1014 |
| 10:23:30.592 | 0.6 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (2351, 2150, 519) ORDER BY "id" |
| 10:23:30.592 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=9133 |
| 10:23:30.593 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (793, 1151)) |
| 10:23:30.594 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (793, 1151)) |
| 10:23:30.596 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=9133 |
| 10:23:30.596 | 1.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (2351, 2150, 519)) |
| 10:23:30.598 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (1276, 9033, 10707) |
| 10:23:30.598 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (2351, 2150, 519)) |
| 10:23:30.599 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (9096, 1320, 10688) |
| 10:23:30.600 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (2351, 2150, 519)) |
| 10:23:30.601 | 16.9 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=7) AND (remind_user_id = 5295 AND is_read = false) AND ("object_id" IN (2351, 2150, 519)) GROUP BY "object_id" |
| 10:23:30.619 | 1.9 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5295, 2, 1146, 'v2/sales-contract/of-client', '{"access_token":"qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA","device_type":"2","id":"304","page":"1","posttime":"1754619776","token":"1120bd5ec70526aebd165df2f0716a74","version_code":"1146"}', '{"code":200,"data":{"list":[{"id":2351,"client_id":304,"signed_at":"2022-07-26","amount":"4500","handler":5295,"description":"","created_by":5295,"created_at":"2022-07-26 10:19:35","updated_at":"2023-05-29 10:05:47","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":2914,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZE-2022072601","payment_collection_remind_ahead":"","from_project":2914,"receipt_date":null,"verify_date":null,"including_tax":false,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":"","is_verify":false,"is_draft":false,"erp_settle_amount":"4500","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":null,"passed":1,"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8","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":null,"receiptScan":null,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2351,"comment":1},"project":{"id":2914,"key":2914,"name":"\u7f51\u7edc\u4ea7\u54c1\u65b0\u8d2d","erpSalesOrder":null},"fromProject":{"id":2914,"key":2914,"name":"\u7f51\u7edc\u4ea7\u54c1\u65b0\u8d2d","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2022-07-26","collected":"4500","profit_pct":"10","budget":"4500","erpSalesOrder":null,"projectProductTypes":[{"id":3827,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"4500.00","pct":"10","project_id":2914,"profit":"450"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":450,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":80,"contract_id":2351,"supplier_id":137,"purchase_id":2352,"supplier":{"id":137,"key":137,"name":"\u5317\u4eac\u79e6\u8fbe\u5609\u5174\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2352,"key":2352,"serial_no":"20220726"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":3757,"user_id":5295,"key":5295,"contract_id":2351,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1015,"key":1015,"contract_id":2351,"name":"2022-07-26","value":"4400","overdue_days":0,"status":1,"pct":97.78,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"11295","key":"11295","contract_id":2351,"value":"4500","created_by":1014,"created_at":"2022-07-26 17:54:16","description":null,"collected_date":"2022-07-26 17:54:16","amount":"4500","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[],"contractScans":[{"id":18614,"object_type":105,"object_id":2351,"attachment_id":10707,"attachment":{"id":10707,"key":10707,"name":"0a225fca-cc89-364f-bf87-c943c6863323","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/0a225fca-cc89-364f-bf87-c943c6863323\/2022_08_01_16_09_38.pdf","orig_name":"2022_08_01_16_09_38.pdf"}}],"receiptScans":[{"id":15706,"object_type":106,"object_id":2351,"attachment_id":10688,"attachment":{"id":10688,"key":10688,"name":"a86571b5-0d8a-3dff-be50-584cb1f15e83","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/a86571b5-0d8a-3dff-be50-584cb1f15e83\/2022_07_28_10_20_24.pdf","orig_name":"2022_07_28_10_20_24.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":4400,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":0,"un_invoiced":0,"collected":"4500","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":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":2150,"client_id":304,"signed_at":"2021-12-03","amount":"371000","handler":5295,"description":"\u65b0\u8d2d\u4e24\u53f0HP\u670d\u52a1\u5668+\u4e24\u4e2a\u4ea4\u6362\u673a+\u6a21\u5757","created_by":5295,"created_at":"2021-12-06 11:21:48","updated_at":"2021-12-31 11:16:08","contract_scan":9033,"receipt_scan":9096,"contract_type":1,"project_id":2667,"valid_date":null,"expire_date":"2024-12-02","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"TS-WZW-2021120301","payment_collection_remind_ahead":"7 days","from_project":2667,"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":"","is_verify":false,"is_draft":false,"erp_settle_amount":"371000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":249,"passed":2,"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8","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":9033,"key":9033,"name":"39fb0142-7988-3df9-bbb9-34da7690602c","orig_name":"2021_12_08_11_21_25.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/39fb0142-7988-3df9-bbb9-34da7690602c\/2021_12_08_11_21_25.pdf","download":"\/vue\/attachment\/download?name=39fb0142-7988-3df9-bbb9-34da7690602c"},"receiptScan":{"id":9096,"key":9096,"name":"3114222f-90f7-3347-b66b-2ef6da866437","orig_name":"2021_12_13_09_26_54.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/3114222f-90f7-3347-b66b-2ef6da866437\/2021_12_13_09_26_54.pdf","download":"\/vue\/attachment\/download?name=3114222f-90f7-3347-b66b-2ef6da866437"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2150,"comment":1},"project":{"id":2667,"key":2667,"name":"\u670d\u52a1\u5668\u65b0\u8d2d","erpSalesOrder":null},"fromProject":{"id":2667,"key":2667,"name":"\u670d\u52a1\u5668\u65b0\u8d2d","description":"\u65b0\u8d2d\u4e24\u53f0HP\u670d\u52a1\u5668+\u4e24\u4e2a\u4ea4\u6362\u673a+\u6a21\u5757","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2021-12-03","collected":"371000","profit_pct":"9.67","budget":"371000","erpSalesOrder":null,"projectProductTypes":[{"id":3957,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"371000.00","pct":"9.67","project_id":2667,"profit":"35875.7"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":2667,"sum":"813.54"},"profit":35875.7,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":193,"contract_id":2150,"supplier_id":86,"purchase_id":2171,"supplier":{"id":86,"key":86,"name":"\u5317\u4eac\u6234\u5fb7\u5b8f\u4fe1\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":2171,"key":2171,"serial_no":"TSKJ20211213"}},{"id":410,"contract_id":2150,"supplier_id":86,"purchase_id":2153,"supplier":{"id":86,"key":86,"name":"\u5317\u4eac\u6234\u5fb7\u5b8f\u4fe1\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":2153,"key":2153,"serial_no":"BJTSKJ20211208"}},{"id":867,"contract_id":2150,"supplier_id":59,"purchase_id":2170,"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":2170,"key":2170,"serial_no":"TGXC20211115-1"}},{"id":979,"contract_id":2150,"supplier_id":363,"purchase_id":2169,"supplier":{"id":363,"key":363,"name":"\u5317\u4eac\u53cc\u8fea\u6c38\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2169,"key":2169,"serial_no":"\u65e0"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":6474,"user_id":1011,"key":1011,"contract_id":2150,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":6475,"user_id":5295,"key":5295,"contract_id":2150,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":2951,"user_id":5295,"key":5295,"contract_id":2150,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":947,"key":947,"contract_id":2150,"name":"2021-12-31","value":"185500","overdue_days":null,"status":1,"pct":50,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"1657","key":"1657","contract_id":2150,"value":"185500","created_by":1014,"created_at":"2021-12-07 15:53:09","description":null,"collected_date":"2021-12-07 15:53:09","amount":"185500","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":50},{"id":"1656","key":"1656","contract_id":2150,"value":"185500","created_by":1014,"created_at":"2021-12-22 17:02:44","description":null,"collected_date":"2021-12-22 17:02:44","amount":"185500","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":50}],"salesContractInvoices":[{"id":1151,"key":1151,"contract_id":2150,"value":"371000.00","attachment_id":9133,"from_date":"2021-12-16","description":null,"is_draft":true,"attachment":{"id":9133,"key":9133,"name":"5e2f554a-8cd5-39a8-b02b-af2ba69100d4","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/5e2f554a-8cd5-39a8-b02b-af2ba69100d4\/2021_12_16_11_24_03.pdf","orig_name":"2021_12_16_11_24_03.pdf"},"attachmentRelationships":[],"files":[{"id":6663,"object_type":102,"object_id":1151,"attachment_id":9133,"attachment":{"id":9133,"key":9133,"name":"5e2f554a-8cd5-39a8-b02b-af2ba69100d4","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/5e2f554a-8cd5-39a8-b02b-af2ba69100d4\/2021_12_16_11_24_03.pdf","orig_name":"2021_12_16_11_24_03.pdf"}}]}],"contractScans":[{"id":12253,"object_type":105,"object_id":2150,"attachment_id":9033,"attachment":{"id":9033,"key":9033,"name":"39fb0142-7988-3df9-bbb9-34da7690602c","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/39fb0142-7988-3df9-bbb9-34da7690602c\/2021_12_08_11_21_25.pdf","orig_name":"2021_12_08_11_21_25.pdf"}}],"receiptScans":[{"id":13044,"object_type":106,"object_id":2150,"attachment_id":9096,"attachment":{"id":9096,"key":9096,"name":"3114222f-90f7-3347-b66b-2ef6da866437","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/3114222f-90f7-3347-b66b-2ef6da866437\/2021_12_13_09_26_54.pdf","orig_name":"2021_12_13_09_26_54.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":185500,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":371000,"un_invoiced":0,"collected":"371000","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":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":519,"client_id":304,"signed_at":"2018-05-25","amount":"245420","handler":1008,"description":"HP380g9\u670d\u52a1\u56682\u53f0\uff0c360G9\u4e00\u53f0\uff0c\u601d\u79d1\u4ea4\u6362\u673a3650\u4e00\u53f0\uff0c2960\u4e00\u53f0\uff0cT628\u7626\u5ba2\u6237\u673a20\u53f0\uff0c\u89e3\u51b3\u5ba2\u6237\u90e8\u5206\u7535\u8111\u8bbf\u95ee\u5916\u7f51","created_by":5015,"created_at":"2018-06-01 09:01:59","updated_at":"2021-06-24 15:06:32","contract_scan":1276,"receipt_scan":1320,"contract_type":1,"project_id":682,"valid_date":null,"expire_date":"2021-05-24","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"TS-BFHC-20180525","payment_collection_remind_ahead":"","from_project":682,"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":"","is_verify":false,"is_draft":false,"erp_settle_amount":"245420","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":1537,"passed":2,"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8","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":1276,"key":1276,"name":"82344465-7755-3aec-9af4-3428bc94b077","orig_name":"\u5317\u4eac\u4e03\u661f\u534e\u521b\u7535\u5b50\u80a1\u4efd\u6709\u9650\u516c\u53f8\u201420180525\u2014245420.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/82344465-7755-3aec-9af4-3428bc94b077\/\u5317\u4eac\u4e03\u661f\u534e\u521b\u7535\u5b50\u80a1\u4efd\u6709\u9650\u516c\u53f8\u201420180525\u2014245420.pdf","download":"\/vue\/attachment\/download?name=82344465-7755-3aec-9af4-3428bc94b077"},"receiptScan":{"id":1320,"key":1320,"name":"15c22edd-1998-3bf1-9639-1b2888d64252","orig_name":"\u5317\u65b9\u534e\u521b.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/15c22edd-1998-3bf1-9639-1b2888d64252\/\u5317\u65b9\u534e\u521b.pdf","download":"\/vue\/attachment\/download?name=15c22edd-1998-3bf1-9639-1b2888d64252"},"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":null,"project":{"id":682,"key":682,"name":"\u865a\u62df\u684c\u9762","erpSalesOrder":null},"fromProject":{"id":682,"key":682,"name":"\u865a\u62df\u684c\u9762","description":"HP380g9\u670d\u52a1\u56682\u53f0\uff0c360G9\u4e00\u53f0\uff0c\u601d\u79d1\u4ea4\u6362\u673a3650\u4e00\u53f0\uff0c2960\u4e00\u53f0\uff0cT628\u7626\u5ba2\u6237\u673a20\u53f0\uff0c\u89e3\u51b3\u5ba2\u6237\u90e8\u5206\u7535\u8111\u8bbf\u95ee\u5916\u7f51","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2018-05-25","collected":"245420","profit_pct":"20.71","budget":"245420","erpSalesOrder":null,"projectProductTypes":[{"id":3681,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"43420.00","pct":"20.71","project_id":682,"profit":"8992.282"},{"id":4010,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"202000.00","pct":"20.71","project_id":682,"profit":"41834.2"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":50826.482,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":273,"contract_id":519,"supplier_id":239,"purchase_id":526,"supplier":{"id":239,"key":239,"name":"\u5317\u4eac\u7ecf\u4f1f\u4f73\u4e1a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":526,"key":526,"serial_no":"-"}},{"id":906,"contract_id":519,"supplier_id":57,"purchase_id":565,"supplier":{"id":57,"key":57,"name":"\u5317\u4eac\u9510\u7f51\u65f6\u4ee3\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8(\u4e91\u9f0e\u521b\u9510(\u5317\u4eac)\u79d1\u6280\u6709\u9650\u516c\u53f8)"},"purchase":{"id":565,"key":565,"serial_no":"-"}},{"id":907,"contract_id":519,"supplier_id":50,"purchase_id":566,"supplier":{"id":50,"key":50,"name":"\u5317\u4eac\u9e3f\u539f\u5728\u7ebf\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":566,"key":566,"serial_no":"-"}},{"id":1123,"contract_id":519,"supplier_id":87,"purchase_id":561,"supplier":{"id":87,"key":87,"name":"\u5317\u4eac\u601d\u6e90\u4f73\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u5317\u4eac\u65b0\u8fc8\u4e92\u8054\u79d1\u6280\u6709\u9650\u516c\u53f8)"},"purchase":{"id":561,"key":561,"serial_no":"-"}},{"id":1177,"contract_id":519,"supplier_id":65,"purchase_id":562,"supplier":{"id":65,"key":65,"name":"\u5317\u4eac\u7f51\u8054\u672a\u6765\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":562,"key":562,"serial_no":"-"}},{"id":1218,"contract_id":519,"supplier_id":63,"purchase_id":591,"supplier":{"id":63,"key":63,"name":"\u5317\u4eac\u6167\u535a\u4e16\u7eaa\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":591,"key":591,"serial_no":"-"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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":5458,"user_id":1011,"key":1011,"contract_id":519,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":"1683","key":"1683","contract_id":519,"value":"123470.00","created_by":null,"created_at":"2018-06-01 09:01:59","description":null,"collected_date":"2018-06-01 09:01:59","amount":"123470.00","createdBy":null,"pct":50.31},{"id":"1682","key":"1682","contract_id":519,"value":"69000.00","created_by":null,"created_at":"2018-06-01 09:01:59","description":null,"collected_date":"2018-06-01 09:01:59","amount":"69000.00","createdBy":null,"pct":28.12},{"id":"1681","key":"1681","contract_id":519,"value":"52950.00","created_by":null,"created_at":"2018-06-01 09:01:59","description":null,"collected_date":"2018-06-01 09:01:59","amount":"52950.00","createdBy":null,"pct":21.58}],"salesContractInvoices":[{"id":793,"key":793,"contract_id":519,"value":"245420.00","attachment_id":null,"from_date":null,"description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12891,"object_type":105,"object_id":519,"attachment_id":1276,"attachment":{"id":1276,"key":1276,"name":"82344465-7755-3aec-9af4-3428bc94b077","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/82344465-7755-3aec-9af4-3428bc94b077\/\u5317\u4eac\u4e03\u661f\u534e\u521b\u7535\u5b50\u80a1\u4efd\u6709\u9650\u516c\u53f8\u201420180525\u2014245420.pdf","orig_name":"\u5317\u4eac\u4e03\u661f\u534e\u521b\u7535\u5b50\u80a1\u4efd\u6709\u9650\u516c\u53f8\u201420180525\u2014245420.pdf"}}],"receiptScans":[{"id":13554,"object_type":106,"object_id":519,"attachment_id":1320,"attachment":{"id":1320,"key":1320,"name":"15c22edd-1998-3bf1-9639-1b2888d64252","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/15c22edd-1998-3bf1-9639-1b2888d64252\/\u5317\u65b9\u534e\u521b.pdf","orig_name":"\u5317\u65b9\u534e\u521b.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":245420,"un_invoiced":0,"collected":"245420","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":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false}],"pagenation":{"totalcount":3,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-08-08 10:23:30') RETURNING "id" |