ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a4fa3b6a1b11: POST https://beta.jinchangxiao.com/v2/sales-contract/of-client at 2026-07-09 09:35:50 pm by 117.176.186.26

Performance Profiling

Total processing time: 489 ms; Peak memory: 5.791 MB. Show Profiling Timeline

总计63条数据
TimeDurationCategoryInfo
  
21:35:50.89962.4 msyii\db\Command::querySELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (1930, 1734, 1702, 26)) GROUP BY "object_id"
21:35:51.07554.4 msyii\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 (1930, 1734, 1702, 26)) GROUP BY "object_id"
21:35:50.81219.0 msyii\db\Command::querySELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE "client"."id"='146' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10
21:35:50.79016.7 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE "client"."id"='146' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"
21:35:50.67111.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm'
21:35:51.01110.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id" IN (1930, 1734, 1702, 26) ORDER BY "id" DESC
21:35:50.9679.8 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (2504, 1963, 1938, 88)
21:35:50.9869.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (14, 624, 638, 699) ORDER BY "id"
21:35:51.0008.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (14, 624, 638, 699) ORDER BY "id"
21:35:50.8838.1 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "orig_name", "extension", "path" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (7202, 6136, 6034, 134)
21:35:50.8477.9 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
21:35:50.8597.6 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
21:35:50.8717.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "orig_name", "extension", "path" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (7201, 6135, 6033, 773)
21:35:50.7346.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='146') AND ("deleted"=FALSE)
21:35:50.7136.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
21:35:50.8376.0 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=146
21:35:50.8924.0 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5015, 1010)
21:35:51.0393.3 msyii\db\Command::querySELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (88, 1963, 1938, 2504))
21:35:51.0613.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (661, 920, 934, 1036))
21:35:51.0573.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (661, 920, 934, 1036))
21:35:51.0653.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (1930, 1734, 1702, 26))
21:35:51.0692.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (1930, 1734, 1702, 26))
21:35:50.6682.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
21:35:51.0722.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (1930, 1734, 1702, 26))
21:35:51.1382.7 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 2, 1161, 'v2/sales-contract/of-client', '{"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","device_type":"2","id":"146","page":"1","posttime":"1783604096","token":"0846ce2c709fa2ee674baa8d8d0e0245","version_code":"1161"}', '{"code":200,"data":{"list":[{"id":1930,"client_id":146,"signed_at":"2021-04-01","amount":"12930","handler":1005,"description":"288 3\u53f0","created_by":5015,"created_at":"2021-04-02 16:46:57","updated_at":"2021-08-19 15:56:16","contract_scan":7201,"receipt_scan":7202,"contract_type":1,"project_id":2504,"valid_date":null,"expire_date":"2022-03-31","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"POT-21010008","payment_collection_remind_ahead":"","from_project":2504,"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":"12930","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"12930","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":1561,"passed":2,"client":{"id":146,"key":146,"name":"smc(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8-(\u91cd\u590d\u5ba2\u6237)","logo":null,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},"contractScan":{"id":7201,"key":7201,"name":"07be8f3c-6aab-37f3-ac14-0f30ef259a50","orig_name":"2021_04_06_09_23_21.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/07be8f3c-6aab-37f3-ac14-0f30ef259a50\/2021_04_06_09_23_21.pdf","download":"\/vue\/attachment\/download?name=07be8f3c-6aab-37f3-ac14-0f30ef259a50"},"receiptScan":{"id":7202,"key":7202,"name":"b31b5e2c-a20d-38b5-9ea4-1030a3354f84","orig_name":"2021_04_06_09_23_21.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/b31b5e2c-a20d-38b5-9ea4-1030a3354f84\/2021_04_06_09_23_21.pdf","download":"\/vue\/attachment\/download?name=b31b5e2c-a20d-38b5-9ea4-1030a3354f84"},"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":1930,"comment":1},"project":{"id":2504,"key":2504,"name":"hp288PC","erpSalesOrder":{"id":699,"serial_no":"XSDD-20210406-00001","from_date":null,"wrote_date":"2021-04-01","handler":5015,"client_id":146,"purchase_contract_id":null,"project_id":2504,"sales_contract_id":1930,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u529e\u516c","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2021-04-06 09:25:04","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"12930","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2021-04-02 16:46:57","updated_at":"2021-04-06 09:25:04","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":699,"serial_no":"XSDD-20210406-00001","from_date":null,"wrote_date":"2021-04-01","handler":5015,"client_id":146,"purchase_contract_id":null,"project_id":2504,"sales_contract_id":1930,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u529e\u516c","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2021-04-06 09:25:04","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"12930","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2021-04-02 16:46:57","updated_at":"2021-04-06 09:25:04","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":2504,"key":2504,"name":"hp288PC","description":"288 3\u53f0","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2021-04-01","collected":"12930","profit_pct":"0","budget":"12930","erpSalesOrder":{"id":699,"serial_no":"XSDD-20210406-00001","from_date":null,"wrote_date":"2021-04-01","handler":5015,"client_id":146,"purchase_contract_id":null,"project_id":2504,"sales_contract_id":1930,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u529e\u516c","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2021-04-06 09:25:04","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"12930","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2021-04-02 16:46:57","updated_at":"2021-04-06 09:25:04","print_times":null},"projectProductTypes":[{"id":4114,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"12930","pct":"0","project_id":2504,"profit":"0"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":"0","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8184,"user_id":1001,"key":1001,"contract_id":1930,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},{"id":5962,"user_id":1011,"key":1011,"contract_id":1930,"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":"11500","key":"11500","contract_id":1930,"value":"12930.00","created_by":1014,"created_at":"2021-04-26 10:42:31","description":null,"collected_date":"2021-04-26 00:00:00","amount":"12930.00","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1036,"key":1036,"contract_id":1930,"value":"12930.00","attachment_id":7207,"from_date":"2021-04-06","description":null,"is_draft":true,"is_cancel":false,"salesInvoiceAmounts":[{"id":2292,"sales_invoice_id":1036,"amount":"12930.00","tax_rate":"13"}],"attachment":{"id":7207,"key":7207,"name":"8773903e-01de-3247-be7b-1b7693a82cad","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/8773903e-01de-3247-be7b-1b7693a82cad\/2021_04_06_15_50_44\uff08\u88ab\u62d6\u79fb\uff09.pdf","orig_name":"2021_04_06_15_50_44\uff08\u88ab\u62d6\u79fb\uff09.pdf"},"attachmentRelationships":[],"files":[{"id":6597,"object_type":102,"object_id":1036,"attachment_id":7207,"attachment":{"id":7207,"key":7207,"name":"8773903e-01de-3247-be7b-1b7693a82cad","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/8773903e-01de-3247-be7b-1b7693a82cad\/2021_04_06_15_50_44\uff08\u88ab\u62d6\u79fb\uff09.pdf","orig_name":"2021_04_06_15_50_44\uff08\u88ab\u62d6\u79fb\uff09.pdf"}}]}],"contractScans":[{"id":12488,"object_type":105,"object_id":1930,"attachment_id":7201,"attachment":{"id":7201,"key":7201,"name":"07be8f3c-6aab-37f3-ac14-0f30ef259a50","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/07be8f3c-6aab-37f3-ac14-0f30ef259a50\/2021_04_06_09_23_21.pdf","orig_name":"2021_04_06_09_23_21.pdf"}}],"receiptScans":[{"id":13221,"object_type":106,"object_id":1930,"attachment_id":7202,"attachment":{"id":7202,"key":7202,"name":"b31b5e2c-a20d-38b5-9ea4-1030a3354f84","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/b31b5e2c-a20d-38b5-9ea4-1030a3354f84\/2021_04_06_09_23_21.pdf","orig_name":"2021_04_06_09_23_21.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":"12930.00","un_invoiced":0,"collected":"12930","un_collected":0,"is_collected":true,"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":0},{"id":1734,"client_id":146,"signed_at":"2020-11-02","amount":"31922.23","handler":1003,"description":"1.\u60e0\u666e 450G7\u7b14\u8bb0\u672c 1\u53f0 \n2\uff0c\u60e0\u666e P22\u663e\u793a\u5668 6\u53f0 \n3\uff0c\u60e0\u666e288\u53f0\u5f0f\u673a 6\u53f0 ","created_by":5015,"created_at":"2020-11-03 15:36:09","updated_at":"2020-11-04 14:57:06","contract_scan":6135,"receipt_scan":6136,"contract_type":1,"project_id":1963,"valid_date":null,"expire_date":"2021-11-01","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"\u8be6\u89c1pdf","payment_collection_remind_ahead":"1 day","from_project":1963,"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":"31922.23","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"31922.23","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":1711,"passed":2,"client":{"id":146,"key":146,"name":"smc(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8-(\u91cd\u590d\u5ba2\u6237)","logo":null,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},"contractScan":{"id":6135,"key":6135,"name":"0a8a4aaa-7421-3570-95e8-b4815be79ab9","orig_name":"smc.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/0a8a4aaa-7421-3570-95e8-b4815be79ab9\/smc.pdf","download":"\/vue\/attachment\/download?name=0a8a4aaa-7421-3570-95e8-b4815be79ab9"},"receiptScan":{"id":6136,"key":6136,"name":"e969e5c9-9b85-3ad4-92b7-eaa12431a8a9","orig_name":"smc.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/e969e5c9-9b85-3ad4-92b7-eaa12431a8a9\/smc.pdf","download":"\/vue\/attachment\/download?name=e969e5c9-9b85-3ad4-92b7-eaa12431a8a9"},"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":1734,"comment":1},"project":{"id":1963,"key":1963,"name":"\u529e\u516c\u8bbe\u5907\u65b0\u589e 20201102","erpSalesOrder":{"id":638,"serial_no":"XSDD-20201103-00002","from_date":null,"wrote_date":"2020-11-02","handler":5015,"client_id":146,"purchase_contract_id":null,"project_id":1963,"sales_contract_id":1734,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u529e\u516c","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2021-01-04 16:55:07","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"31922.23","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2020-11-03 15:36:09","updated_at":"2021-01-04 16:55:07","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":638,"serial_no":"XSDD-20201103-00002","from_date":null,"wrote_date":"2020-11-02","handler":5015,"client_id":146,"purchase_contract_id":null,"project_id":1963,"sales_contract_id":1734,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u529e\u516c","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2021-01-04 16:55:07","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"31922.23","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2020-11-03 15:36:09","updated_at":"2021-01-04 16:55:07","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":1963,"key":1963,"name":"\u529e\u516c\u8bbe\u5907\u65b0\u589e 20201102","description":"1.\u60e0\u666e 450G7\u7b14\u8bb0\u672c 1\u53f0 \n2\uff0c\u60e0\u666e P22\u663e\u793a\u5668 6\u53f0 \n3\uff0c\u60e0\u666e288\u53f0\u5f0f\u673a 6\u53f0 ","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2020-11-02","collected":"31922.23","profit_pct":"7.21","budget":"31922.23","erpSalesOrder":{"id":638,"serial_no":"XSDD-20201103-00002","from_date":null,"wrote_date":"2020-11-02","handler":5015,"client_id":146,"purchase_contract_id":null,"project_id":1963,"sales_contract_id":1734,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u529e\u516c","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2021-01-04 16:55:07","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"31922.23","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2020-11-03 15:36:09","updated_at":"2021-01-04 16:55:07","print_times":null},"projectProductTypes":[{"id":4043,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"31922.23","pct":"7.21","project_id":1963,"profit":"2301.592783"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":2301.592783,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8183,"user_id":1001,"key":1001,"contract_id":1734,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},{"id":4579,"user_id":1011,"key":1011,"contract_id":1734,"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":[{"id":1954,"user_id":1003,"key":1003,"contract_id":1734,"user":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":710,"key":710,"contract_id":1734,"name":"2021-01-29","value":"31922.23","overdue_days":null,"status":1,"remind_date":"2021-01-29","pct":100,"overdue_display":""}],"salesContractPayments":[{"id":"11572","key":"11572","contract_id":1734,"value":"31922.23","created_by":1014,"created_at":"2020-11-13 14:07:21","description":null,"collected_date":"2020-11-13 00:00:00","amount":"31922.23","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":920,"key":920,"contract_id":1734,"value":"31922.23","attachment_id":6144,"from_date":"2020-11-04","description":null,"is_draft":true,"is_cancel":false,"salesInvoiceAmounts":[{"id":2211,"sales_invoice_id":920,"amount":"31922.23","tax_rate":"13"}],"attachment":{"id":6144,"key":6144,"name":"7ea1e786-1a98-3955-816d-43e346f6dd3f","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/7ea1e786-1a98-3955-816d-43e346f6dd3f\/2020_11_04_14_54_47.pdf","orig_name":"2020_11_04_14_54_47.pdf"},"attachmentRelationships":[],"files":[{"id":6516,"object_type":102,"object_id":920,"attachment_id":6144,"attachment":{"id":6144,"key":6144,"name":"7ea1e786-1a98-3955-816d-43e346f6dd3f","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/7ea1e786-1a98-3955-816d-43e346f6dd3f\/2020_11_04_14_54_47.pdf","orig_name":"2020_11_04_14_54_47.pdf"}}]}],"contractScans":[{"id":12416,"object_type":105,"object_id":1734,"attachment_id":6135,"attachment":{"id":6135,"key":6135,"name":"0a8a4aaa-7421-3570-95e8-b4815be79ab9","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/0a8a4aaa-7421-3570-95e8-b4815be79ab9\/smc.pdf","orig_name":"smc.pdf"}}],"receiptScans":[{"id":13159,"object_type":106,"object_id":1734,"attachment_id":6136,"attachment":{"id":6136,"key":6136,"name":"e969e5c9-9b85-3ad4-92b7-eaa12431a8a9","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/e969e5c9-9b85-3ad4-92b7-eaa12431a8a9\/smc.pdf","orig_name":"smc.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":31922.23,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":"31922.23","un_invoiced":0,"collected":"31922.23","un_collected":0,"is_collected":true,"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":0},{"id":1702,"client_id":146,"signed_at":"2020-10-14","amount":"1500","handler":1003,"description":"1.MOXO \u5361 1\u5757 ","created_by":5015,"created_at":"2020-10-14 16:30:33","updated_at":"2021-06-24 15:44:40","contract_scan":6033,"receipt_scan":6034,"contract_type":1,"project_id":1938,"valid_date":null,"expire_date":"2021-10-13","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"POT-20100001","payment_collection_remind_ahead":"1 day","from_project":1938,"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":"1500","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"1500","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":1730,"passed":2,"client":{"id":146,"key":146,"name":"smc(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8-(\u91cd\u590d\u5ba2\u6237)","logo":null,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},"contractScan":{"id":6033,"key":6033,"name":"7be91070-902c-39f2-a04f-8ba879376c92","orig_name":"WechatIMG1314.jpeg","extension":"jpeg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/7be91070-902c-39f2-a04f-8ba879376c92\/WechatIMG1314.jpeg","download":"\/vue\/attachment\/download?name=7be91070-902c-39f2-a04f-8ba879376c92"},"receiptScan":{"id":6034,"key":6034,"name":"cd39695f-44d0-3e6e-9069-07de0c0c421b","orig_name":"WechatIMG1314.jpeg","extension":"jpeg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/cd39695f-44d0-3e6e-9069-07de0c0c421b\/WechatIMG1314.jpeg","download":"\/vue\/attachment\/download?name=cd39695f-44d0-3e6e-9069-07de0c0c421b"},"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":1702,"comment":1},"project":{"id":1938,"key":1938,"name":"\u529e\u516c\u8bbe\u5907\u91c7\u8d2d 20201014","erpSalesOrder":{"id":624,"serial_no":"XSDD-20201014-00001","from_date":null,"wrote_date":"2020-10-14","handler":5015,"client_id":146,"purchase_contract_id":null,"project_id":1938,"sales_contract_id":1702,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u914d\u4ef6","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2020-11-30 10:25:39","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"1500","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2020-10-14 16:30:33","updated_at":"2020-11-30 10:25:39","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":624,"serial_no":"XSDD-20201014-00001","from_date":null,"wrote_date":"2020-10-14","handler":5015,"client_id":146,"purchase_contract_id":null,"project_id":1938,"sales_contract_id":1702,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u914d\u4ef6","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2020-11-30 10:25:39","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"1500","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2020-10-14 16:30:33","updated_at":"2020-11-30 10:25:39","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":1938,"key":1938,"name":"\u529e\u516c\u8bbe\u5907\u91c7\u8d2d 20201014","description":"1.MOXO \u5361 1\u5757 ","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2020-10-14","collected":"1500","profit_pct":"43","budget":"1500","erpSalesOrder":{"id":624,"serial_no":"XSDD-20201014-00001","from_date":null,"wrote_date":"2020-10-14","handler":5015,"client_id":146,"purchase_contract_id":null,"project_id":1938,"sales_contract_id":1702,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u914d\u4ef6","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2020-11-30 10:25:39","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"1500","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2020-10-14 16:30:33","updated_at":"2020-11-30 10:25:39","print_times":null},"projectProductTypes":[{"id":4083,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"1500","pct":"43","project_id":1938,"profit":"645"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":645,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8185,"user_id":1001,"key":1001,"contract_id":1702,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},{"id":5493,"user_id":1011,"key":1011,"contract_id":1702,"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":[{"id":2520,"user_id":1003,"key":1003,"contract_id":1702,"user":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"}}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":"11618","key":"11618","contract_id":1702,"value":"1500.00","created_by":1014,"created_at":"2020-11-30 10:25:40","description":null,"collected_date":"2020-11-30 00:00:00","amount":"1500.00","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":934,"key":934,"contract_id":1702,"value":"1500.00","attachment_id":6316,"from_date":"2020-11-19","description":null,"is_draft":true,"is_cancel":false,"salesInvoiceAmounts":[{"id":2274,"sales_invoice_id":934,"amount":"1500.00","tax_rate":"13"}],"attachment":{"id":6316,"key":6316,"name":"3be3eeff-65bd-387f-9815-8c637bdaeae0","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/3be3eeff-65bd-387f-9815-8c637bdaeae0\/2020_11_30_10_26_51.pdf","orig_name":"2020_11_30_10_26_51.pdf"},"attachmentRelationships":[],"files":[{"id":6579,"object_type":102,"object_id":934,"attachment_id":6316,"attachment":{"id":6316,"key":6316,"name":"3be3eeff-65bd-387f-9815-8c637bdaeae0","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/3be3eeff-65bd-387f-9815-8c637bdaeae0\/2020_11_30_10_26_51.pdf","orig_name":"2020_11_30_10_26_51.pdf"}}]}],"contractScans":[{"id":12181,"object_type":105,"object_id":1702,"attachment_id":6033,"attachment":{"id":6033,"key":6033,"name":"7be91070-902c-39f2-a04f-8ba879376c92","extension":"jpeg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/7be91070-902c-39f2-a04f-8ba879376c92\/WechatIMG1314.jpeg","orig_name":"WechatIMG1314.jpeg"}}],"receiptScans":[{"id":13010,"object_type":106,"object_id":1702,"attachment_id":6034,"attachment":{"id":6034,"key":6034,"name":"cd39695f-44d0-3e6e-9069-07de0c0c421b","extension":"jpeg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/cd39695f-44d0-3e6e-9069-07de0c0c421b\/WechatIMG1314.jpeg","orig_name":"WechatIMG1314.jpeg"}}],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":"1500.00","un_invoiced":0,"collected":"1500","un_collected":0,"is_collected":true,"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":0},{"id":26,"client_id":146,"signed_at":"2017-02-24","amount":"21500","handler":1003,"description":"1.\u60e0\u666e ZBOOK17 G3 M9L91AV \u4e00\u53f0","created_by":1010,"created_at":"2017-03-06 15:47:17","updated_at":"2021-06-25 10:24:51","contract_scan":773,"receipt_scan":134,"contract_type":1,"project_id":88,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"-","payment_collection_remind_ahead":"","from_project":88,"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":"21500","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"21500","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":146,"key":146,"name":"smc(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8-(\u91cd\u590d\u5ba2\u6237)","logo":null,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},"contractScan":{"id":773,"key":773,"name":"27ec0725-3da8-378b-9083-9e73de570741","orig_name":"smc\uff08\u5929\u6d25\uff09\u5236\u9020\u6709\u9650\u516c\u53f8\u201420170224\u201421500.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/27ec0725-3da8-378b-9083-9e73de570741\/smc\uff08\u5929\u6d25\uff09\u5236\u9020\u6709\u9650\u516c\u53f8\u201420170224\u201421500.pdf","download":"\/vue\/attachment\/download?name=27ec0725-3da8-378b-9083-9e73de570741"},"receiptScan":{"id":134,"key":134,"name":"8f061fdf-db34-3591-8bc0-1ba2f07f53f4","orig_name":"20170426_164326.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/8f061fdf-db34-3591-8bc0-1ba2f07f53f4\/20170426_164326.pdf","download":"\/vue\/attachment\/download?name=8f061fdf-db34-3591-8bc0-1ba2f07f53f4"},"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":null,"project":{"id":88,"key":88,"name":"\u60e0\u666e ZBOOK17 G3","erpSalesOrder":{"id":14,"serial_no":"XSDD-20170306-00001","from_date":null,"wrote_date":"2017-03-06","handler":1010,"client_id":146,"purchase_contract_id":null,"project_id":88,"sales_contract_id":26,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u529e\u516c","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2019-05-14 11:16:54","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"21500","created_by":1010,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2017-03-06 15:47:17","updated_at":"2019-05-14 11:16:54","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":14,"serial_no":"XSDD-20170306-00001","from_date":null,"wrote_date":"2017-03-06","handler":1010,"client_id":146,"purchase_contract_id":null,"project_id":88,"sales_contract_id":26,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u529e\u516c","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2019-05-14 11:16:54","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"21500","created_by":1010,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2017-03-06 15:47:17","updated_at":"2019-05-14 11:16:54","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":88,"key":88,"name":"\u60e0\u666e ZBOOK17 G3","description":"1.\u60e0\u666e ZBOOK17 G3 M9L91AV \u4e00\u53f0","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-03-06","collected":"21500","profit_pct":"13","budget":"21500","erpSalesOrder":{"id":14,"serial_no":"XSDD-20170306-00001","from_date":null,"wrote_date":"2017-03-06","handler":1010,"client_id":146,"purchase_contract_id":null,"project_id":88,"sales_contract_id":26,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u529e\u516c","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2019-05-14 11:16:54","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"21500","created_by":1010,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2017-03-06 15:47:17","updated_at":"2019-05-14 11:16:54","print_times":null},"projectProductTypes":[{"id":4137,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"21500","pct":"13","project_id":88,"profit":"2795"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":2795,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8182,"user_id":1001,"key":1001,"contract_id":26,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":"11077","key":"11077","contract_id":26,"value":"21500.00","created_by":null,"created_at":"2017-03-06 15:47:17","description":null,"collected_date":"","amount":"21500.00","createdBy":null,"pct":100}],"salesContractInvoices":[{"id":661,"key":661,"contract_id":26,"value":"21500.00","attachment_id":null,"from_date":null,"description":null,"is_draft":true,"is_cancel":false,"salesInvoiceAmounts":[{"id":1981,"sales_invoice_id":661,"amount":"21500.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12620,"object_type":105,"object_id":26,"attachment_id":773,"attachment":{"id":773,"key":773,"name":"27ec0725-3da8-378b-9083-9e73de570741","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/27ec0725-3da8-378b-9083-9e73de570741\/smc\uff08\u5929\u6d25\uff09\u5236\u9020\u6709\u9650\u516c\u53f8\u201420170224\u201421500.pdf","orig_name":"smc\uff08\u5929\u6d25\uff09\u5236\u9020\u6709\u9650\u516c\u53f8\u201420170224\u201421500.pdf"}}],"receiptScans":[{"id":13322,"object_type":106,"object_id":26,"attachment_id":134,"attachment":{"id":134,"key":134,"name":"8f061fdf-db34-3591-8bc0-1ba2f07f53f4","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/8f061fdf-db34-3591-8bc0-1ba2f07f53f4\/20170426_164326.pdf","orig_name":"20170426_164326.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":"21500.00","un_invoiced":0,"collected":"21500","un_collected":0,"is_collected":true,"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.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,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":0}],"pagenation":{"totalcount":4,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"117.176.186.26","ua":"jinchangxiao\/2.3.158 (iPhone 12 mini; iOS 26.2; Scale\/3.00)"}', FALSE, '2026-07-09 21:35:51', 471904000) RETURNING "id"
21:35:51.0422.6 msyii\db\Command::querySELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (88, 1963, 1938, 2504)) GROUP BY "project_id"
21:35:50.9822.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (88, 1963, 1938, 2504))
21:35:51.0531.9 msyii\db\Command::querySELECT "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.wrote_date as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "r" WHERE "contract_id" IN (1930, 1734, 1702, 26) ORDER BY "id" DESC
21:35:51.0261.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE "erp_sales_order_id" IN (699, 638, 624, 14) ORDER BY "id"
21:35:51.0321.2 msyii\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 (2504, 1963, 1938, 88)
21:35:51.0331.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (88, 1963, 1938, 2504))
21:35:51.0350.8 msyii\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 (88, 1963, 1938, 2504)
21:35:51.0370.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (88, 1963, 1938, 2504) ORDER BY "id"
21:35:51.1300.6 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=1930
21:35:51.0560.6 msyii\db\Command::querySELECT "id", "sales_invoice_id", "amount", "tax_rate" FROM "a57be577deb434"."tbl_sales_invoice_amounts" WHERE "sales_invoice_id" IN (661, 920, 934, 1036) ORDER BY "id"
21:35:51.0480.5 msyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (1930, 1734, 1702, 26)
21:35:51.0240.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (699, 638, 624, 14) ORDER BY "id"
21:35:51.0520.5 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (1930, 1734, 1702, 26) ORDER BY "remind_date"
21:35:51.0450.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (1930, 1734, 1702, 26)
21:35:51.1320.5 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=1734
21:35:51.0500.4 msyii\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 (1930, 1734, 1702, 26)
21:35:50.8980.4 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5015, 1010))
21:35:51.0550.4 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft", "is_cancel" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (1930, 1734, 1702, 26) ORDER BY "id"
21:35:51.1330.3 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=1702
21:35:51.0250.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (699, 638, 624, 14) ORDER BY "id"
21:35:51.0470.3 msyii\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 (1930, 1734, 1702, 26)) ORDER BY "remind_date"
21:35:51.0470.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1005, 1003))
21:35:51.0550.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1014
21:35:51.0720.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (6034, 6136, 7202, 134)
21:35:51.0460.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 1003)
21:35:51.0570.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (6144, 6316, 7207)
21:35:51.0480.3 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id" IN (1930, 1734, 1702, 26)
21:35:51.0490.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1011)
21:35:51.1330.3 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=26
21:35:51.0680.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (773, 6033, 6135, 7201)
21:35:51.0640.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (6144, 6316, 7207)
21:35:50.8980.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=9
21:35:51.0500.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (1930, 1734, 1702, 26)
21:35:51.0380.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (88, 1963, 1938, 2504)
21:35:51.0460.3 msyii\db\Command::querySELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id"=1
21:35:51.0490.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1001))
21:35:51.0510.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1003
21:35:51.0510.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1003)