ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68955f38bd255: POST https://beta.jinchangxiao.com/v2/purchase-contract/of-client at 2025-08-08 10:21:44 am by 223.104.39.199

Performance Profiling

Total processing time: 164 ms; Peak memory: 5.403 MB. Show Profiling Timeline

总计37条数据
TimeDurationCategoryInfo
  
10:21:44.87120.3 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=13) AND ("object_id" IN (2352, 2171, 2169, 2153, 2170, 591, 566, 526, 565, 562)) GROUP BY "object_id"
10:21:44.91316.9 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=13) AND (remind_user_id = 5295 AND is_read = false) AND ("object_id" IN (2352, 2171, 2169, 2153, 2170, 591, 566, 526, 565, 562)) GROUP BY "object_id"
10:21:44.8935.8 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "collected_date", "created_at", "created_by", "description" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone 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 "t"."status" IN (2, 5, 1)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone 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 "t"."status" IN (2, 5, 1) )) "sub") "r" WHERE "contract_id" IN (2352, 2171, 2169, 2153, 2170, 591, 566, 526, 565, 562) ORDER BY "id" DESC
10:21:44.8584.8 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT c.* FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id 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 = 108 LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE (("client"."sales_rep" IN (5295, 5311)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295)) OR ("pcr"."id" IS NULL)) AND ("pcr"."client_id"='304') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"
10:21:44.8463.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA'
10:21:44.9093.5 msyii\db\Command::querySELECT "r".* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) AND ("r"."purchase_contract_id" IN (2352, 2171, 2169, 2153, 2170, 591, 566, 526, 565, 562)) GROUP BY "r"."id"
10:21:44.8633.1 msyii\db\Command::querySELECT c.* FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id 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 = 108 LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE (("client"."sales_rep" IN (5295, 5311)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295)) OR ("pcr"."id" IS NULL)) AND ("pcr"."client_id"='304') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10
10:21:44.8432.5 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:21:44.9342.2 msyii\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', 5295, 2, 1146, 'v2/purchase-contract/of-client', '{"access_token":"qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA","device_type":"2","id":"304","page":"1","posttime":"1754619648","token":"9c0b440c4ccce65dd10f34dabb6d47f2","version_code":"1146"}', '{"code":200,"data":{"list":[{"id":2352,"supplier_id":137,"contract_type":1,"signed_at":"2022-12-19","amount":"10410.00","handler":1011,"description":"3800 \u5317\u65b9\u534e\u521b+1200 \u4e1c\u65b9\u8ba1\u91cf+2160 33\u6240+3250\u7acb\u8fc8\u80dc","contract_scan":null,"created_by":1011,"created_at":"2022-07-26 14:56:30","updated_at":"2022-12-22 13:10:55","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"20220726","payment_collection_remind_ahead":null,"including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"10410","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":137,"key":137,"name":"\u5317\u4eac\u79e6\u8fbe\u5609\u5174\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"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"}},"commentCount":null,"purchaseClientRels":[{"id":1222,"contract_id":2352,"client_id":304,"project_id":2914,"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":2914,"key":2914,"name":"\u7f51\u7edc\u4ea7\u54c1\u65b0\u8d2d","project_status":3,"clickable":1}},{"id":1223,"contract_id":2352,"client_id":1121,"project_id":2869,"client":{"id":1121,"key":1121,"name":"\u5317\u4eac\u4e1c\u65b9\u8ba1\u91cf\u6d4b\u8bd5\u7814\u7a76\u6240","sales_rep":5295,"clickable":1},"project":{"id":2869,"key":2869,"name":"\u673a\u623f\u642c\u8fc12022","project_status":3,"clickable":1}},{"id":1224,"contract_id":2352,"client_id":2128,"project_id":2882,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u7814\u7a76\u624033\u6240","sales_rep":5087,"clickable":0,"msg":"\u60a8\u65e0\u6743\u8bbf\u95ee\u6b64\u5ba2\u6237"},"project":{"id":2882,"key":2882,"name":"\u8d1f\u8f7d\u5747\u8861","project_status":3,"clickable":0,"msg":"\u60a8\u65e0\u6743\u8bbf\u95ee\u6b64\u5546\u673a"}},{"id":1225,"contract_id":2352,"client_id":2184,"project_id":2970,"client":{"id":2184,"key":2184,"name":"\u5317\u4eac\u7acb\u8fc8\u80dc\u63a7\u5236\u6280\u672f\u6709\u9650\u8d23\u4efb\u516c\u53f8","sales_rep":5311,"clickable":1},"project":{"id":2970,"key":2970,"name":"\u534e\u4e09\u4ea4\u6362\u673a+\u7fa4\u8f89\u5b58\u50a8","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1508","key":"1508","contract_id":2352,"value":"3250.00","collected_date":"2022-12-22 17:04:52","created_at":"2022-12-22 17:04:52","created_by":1011,"description":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"pct":31.22},{"id":"1507","key":"1507","contract_id":2352,"value":"2160.00","collected_date":"2022-09-29 11:01:52","created_at":"2022-09-29 11:01:52","created_by":5298,"description":null,"createdBy":{"id":5298,"key":5298,"name":"\u675c\u6587\u98de","sex":"F","department_id":3},"pct":20.75},{"id":"1506","key":"1506","contract_id":2352,"value":"5000.00","collected_date":"2022-09-21 16:39:33","created_at":"2022-09-21 16:39:33","created_by":1011,"description":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"pct":48.03}],"purchaseContractInvoices":[{"id":1207,"key":1207,"contract_id":2352,"amount":"7160","value":"7160","attachment_id":null,"from_date":"2022-09-20","description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":16155,"object_type":103,"object_id":1207,"attachment_id":11079,"attachment":{"id":11079,"key":11079,"name":"9a920af2-702a-3a84-b5f2-0222121d26ae","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/9a920af2-702a-3a84-b5f2-0222121d26ae\/2022_09_21_10_02_28.pdf","orig_name":"2022_09_21_10_02_28.pdf"}}]},{"id":1261,"key":1261,"contract_id":2352,"amount":"3250.00","value":"3250.00","attachment_id":null,"from_date":"2022-12-19","description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[{"id":16822,"object_type":103,"object_id":1261,"attachment_id":11690,"attachment":{"id":11690,"key":11690,"name":"0386feee-d21d-333e-bcc2-f5bccec7373a","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/0386feee-d21d-333e-bcc2-f5bccec7373a\/2022_12_21_14_42_06.pdf","orig_name":"2022_12_21_14_42_06.pdf"}}]}],"contractScans":[{"id":16838,"object_type":108,"object_id":2352,"attachment_id":11689,"attachment":{"id":11689,"key":11689,"name":"ad379551-77ff-36bc-847e-3e1dec968c12","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/ad379551-77ff-36bc-847e-3e1dec968c12\/2022_12_21_14_42_06 2.pdf","orig_name":"2022_12_21_14_42_06 2.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":10410,"approve_amount":0,"un_approve_amount":10410,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"10410","un_collected":0,"collected_plan":0,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":2171,"supplier_id":86,"contract_type":1,"signed_at":"2021-12-13","amount":"1200.00","handler":1011,"description":"\u8d60\u90014\u4e2a\u6a21\u5757\uff0cOMXD30000","contract_scan":9148,"created_by":1011,"created_at":"2021-12-17 10:47:43","updated_at":"2021-12-17 15:29:23","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20211213","payment_collection_remind_ahead":null,"including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"1200","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":86,"key":86,"name":"\u5317\u4eac\u6234\u5fb7\u5b8f\u4fe1\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"contractScan":{"id":9148,"key":9148,"name":"\/files\/protected\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/6f4e536d-bd79-3438-aee7-0ffc1fc6e845\/2021_12_17_15_28_15.pdf6f4e536d-bd79-3438-aee7-0ffc1fc6e845.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/6f4e536d-bd79-3438-aee7-0ffc1fc6e845\/2021_12_17_15_28_15.pdf","orig_name":"2021_12_17_15_28_15.pdf","download":"\/vue\/attachment\/download?name=6f4e536d-bd79-3438-aee7-0ffc1fc6e845"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"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"}},"commentCount":null,"purchaseClientRels":[{"id":946,"contract_id":2171,"client_id":304,"project_id":2667,"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":2667,"key":2667,"name":"\u670d\u52a1\u5668\u65b0\u8d2d","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"11352","key":"11352","contract_id":2171,"value":"1200.00","collected_date":"2022-01-18 14:01:17","created_at":"2022-01-18 14:01:17","created_by":5298,"description":null,"createdBy":{"id":5298,"key":5298,"name":"\u675c\u6587\u98de","sex":"F","department_id":3},"pct":100}],"purchaseContractInvoices":[{"id":1097,"key":1097,"contract_id":2171,"amount":"1200.00","value":"1200.00","attachment_id":9144,"from_date":"2021-12-16","description":null,"is_draft":true,"attachment":{"id":9144,"key":9144,"name":"c95af0fa-c7c9-3df0-914e-3021c985277f","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/c95af0fa-c7c9-3df0-914e-3021c985277f\/2021_12_17_10_20_50 2.pdf","orig_name":"2021_12_17_10_20_50 2.pdf"},"attachmentRelationships":[],"files":[{"id":7628,"object_type":103,"object_id":1097,"attachment_id":9144,"attachment":{"id":9144,"key":9144,"name":"c95af0fa-c7c9-3df0-914e-3021c985277f","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/c95af0fa-c7c9-3df0-914e-3021c985277f\/2021_12_17_10_20_50 2.pdf","orig_name":"2021_12_17_10_20_50 2.pdf"}}]}],"contractScans":[{"id":14531,"object_type":108,"object_id":2171,"attachment_id":9148,"attachment":{"id":9148,"key":9148,"name":"6f4e536d-bd79-3438-aee7-0ffc1fc6e845","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/6f4e536d-bd79-3438-aee7-0ffc1fc6e845\/2021_12_17_15_28_15.pdf","orig_name":"2021_12_17_15_28_15.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":1200,"approve_amount":0,"un_approve_amount":1200,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"1200","un_collected":0,"collected_plan":0,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":2169,"supplier_id":363,"contract_type":1,"signed_at":"2021-12-08","amount":"97800.00","handler":5298,"description":"","contract_scan":9139,"created_by":5298,"created_at":"2021-12-17 10:30:40","updated_at":"2021-12-17 10:38:20","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"\u65e0","payment_collection_remind_ahead":null,"including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"97800","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":363,"key":363,"name":"\u5317\u4eac\u53cc\u8fea\u6c38\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{"id":9139,"key":9139,"name":"\/files\/protected\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/ad5ebccf-33f1-3a90-9b8f-e607e4b2d1ff\/1.pdfad5ebccf-33f1-3a90-9b8f-e607e4b2d1ff.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/ad5ebccf-33f1-3a90-9b8f-e607e4b2d1ff\/1.pdf","orig_name":"1.pdf","download":"\/vue\/attachment\/download?name=ad5ebccf-33f1-3a90-9b8f-e607e4b2d1ff"},"createdBy":{"id":5298,"key":5298,"name":"\u675c\u6587\u98de","sex":"F","department_id":3,"avatar":{"id":140,"user_id":5298,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3cd222c9-8884-3376-9440-91cc91755fcb.jpg"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":5298,"key":5298,"name":"\u675c\u6587\u98de","sex":"F","avatar":{"id":140,"user_id":5298,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3cd222c9-8884-3376-9440-91cc91755fcb.jpg"}},"commentCount":null,"purchaseClientRels":[{"id":940,"contract_id":2169,"client_id":304,"project_id":2667,"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":2667,"key":2667,"name":"\u670d\u52a1\u5668\u65b0\u8d2d","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1989","key":"1989","contract_id":2169,"value":"97800.00","collected_date":"2022-01-05 13:00:33","created_at":"2022-01-05 13:00:33","created_by":5298,"description":null,"createdBy":{"id":5298,"key":5298,"name":"\u675c\u6587\u98de","sex":"F","department_id":3},"pct":100}],"purchaseContractInvoices":[{"id":1094,"key":1094,"contract_id":2169,"amount":"97800.00","value":"97800.00","attachment_id":9140,"from_date":"2021-12-16","description":null,"is_draft":true,"attachment":{"id":9140,"key":9140,"name":"ab105b61-c898-35b8-8f0f-eeada6c6dd4a","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/ab105b61-c898-35b8-8f0f-eeada6c6dd4a\/2021_12_17_10_25_00\u526f\u672c.pdf","orig_name":"2021_12_17_10_25_00\u526f\u672c.pdf"},"attachmentRelationships":[],"files":[{"id":7625,"object_type":103,"object_id":1094,"attachment_id":9140,"attachment":{"id":9140,"key":9140,"name":"ab105b61-c898-35b8-8f0f-eeada6c6dd4a","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/ab105b61-c898-35b8-8f0f-eeada6c6dd4a\/2021_12_17_10_25_00\u526f\u672c.pdf","orig_name":"2021_12_17_10_25_00\u526f\u672c.pdf"}}]}],"contractScans":[{"id":14555,"object_type":108,"object_id":2169,"attachment_id":9139,"attachment":{"id":9139,"key":9139,"name":"ad5ebccf-33f1-3a90-9b8f-e607e4b2d1ff","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/ad5ebccf-33f1-3a90-9b8f-e607e4b2d1ff\/1.pdf","orig_name":"1.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":97800,"approve_amount":0,"un_approve_amount":97800,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"97800","un_collected":0,"collected_plan":0,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":2153,"supplier_id":86,"contract_type":1,"signed_at":"2021-12-08","amount":"207000.00","handler":1011,"description":"\u4ea4\u6362\u673a\u548c\u9632\u706b\u5899\u4ea7\u54c1","contract_scan":9037,"created_by":1011,"created_at":"2021-12-08 15:52:00","updated_at":"2021-12-08 15:52:00","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"BJTSKJ20211208","payment_collection_remind_ahead":null,"including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"207000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":86,"key":86,"name":"\u5317\u4eac\u6234\u5fb7\u5b8f\u4fe1\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"contractScan":{"id":9037,"key":9037,"name":"\/files\/protected\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/8ee1da5b-ca03-35fe-8cf2-184b6a51637c\/2021_12_08_15_23_54.pdf8ee1da5b-ca03-35fe-8cf2-184b6a51637c.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/8ee1da5b-ca03-35fe-8cf2-184b6a51637c\/2021_12_08_15_23_54.pdf","orig_name":"2021_12_08_15_23_54.pdf","download":"\/vue\/attachment\/download?name=8ee1da5b-ca03-35fe-8cf2-184b6a51637c"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"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"}},"commentCount":null,"purchaseClientRels":[{"id":926,"contract_id":2153,"client_id":304,"project_id":2667,"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":2667,"key":2667,"name":"\u670d\u52a1\u5668\u65b0\u8d2d","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1691","key":"1691","contract_id":2153,"value":"207000.00","collected_date":"2022-01-05 13:00:45","created_at":"2022-01-05 13:00:45","created_by":5298,"description":null,"createdBy":{"id":5298,"key":5298,"name":"\u675c\u6587\u98de","sex":"F","department_id":3},"pct":100}],"purchaseContractInvoices":[{"id":1096,"key":1096,"contract_id":2153,"amount":"207000.00","value":"207000.00","attachment_id":9143,"from_date":"2021-12-16","description":null,"is_draft":true,"attachment":{"id":9143,"key":9143,"name":"7f175aea-171e-3fb6-8d80-1d5bb67b66dc","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/7f175aea-171e-3fb6-8d80-1d5bb67b66dc\/2021_12_17_10_20_50 2.pdf","orig_name":"2021_12_17_10_20_50 2.pdf"},"attachmentRelationships":[],"files":[{"id":7627,"object_type":103,"object_id":1096,"attachment_id":9143,"attachment":{"id":9143,"key":9143,"name":"7f175aea-171e-3fb6-8d80-1d5bb67b66dc","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/7f175aea-171e-3fb6-8d80-1d5bb67b66dc\/2021_12_17_10_20_50 2.pdf","orig_name":"2021_12_17_10_20_50 2.pdf"}}]}],"contractScans":[{"id":14547,"object_type":108,"object_id":2153,"attachment_id":9037,"attachment":{"id":9037,"key":9037,"name":"8ee1da5b-ca03-35fe-8cf2-184b6a51637c","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/8ee1da5b-ca03-35fe-8cf2-184b6a51637c\/2021_12_08_15_23_54.pdf","orig_name":"2021_12_08_15_23_54.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":207000,"approve_amount":0,"un_approve_amount":207000,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"207000","un_collected":0,"collected_plan":0,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":2170,"supplier_id":59,"contract_type":1,"signed_at":"2021-11-15","amount":"11150.00","handler":1011,"description":"\u786c\u76d8\uff1a900GB \u5355\u4ef7\uff1a\uffe5750\u5143\uff0c\u4e3a\u591a\u7ef4\u8054\u5408\u7684\u914d\u4ef6\uff1b\n\u786c\u76d8\uff1a300GB \u5355\u4ef7\uff1a\uffe5400\u5143\uff0c\u4e3aSMC\u552e\u540e\u7684\u76d8\n\u5176\u5b83\u4e3a\uff1a\u5317\u65b9\u534e\u521b\u51fa\u8d27","contract_scan":9141,"created_by":5298,"created_at":"2021-12-17 10:32:14","updated_at":"2021-12-17 10:38:29","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TGXC20211115-1","payment_collection_remind_ahead":null,"including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"11150","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"contractScan":{"id":9141,"key":9141,"name":"\/files\/protected\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/4282639c-bf4a-3481-ae27-7ccc87617d6c\/\u592a\u8c37\u8baf\u8bda.pdf4282639c-bf4a-3481-ae27-7ccc87617d6c.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/4282639c-bf4a-3481-ae27-7ccc87617d6c\/\u592a\u8c37\u8baf\u8bda.pdf","orig_name":"\u592a\u8c37\u8baf\u8bda.pdf","download":"\/vue\/attachment\/download?name=4282639c-bf4a-3481-ae27-7ccc87617d6c"},"createdBy":{"id":5298,"key":5298,"name":"\u675c\u6587\u98de","sex":"F","department_id":3,"avatar":{"id":140,"user_id":5298,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3cd222c9-8884-3376-9440-91cc91755fcb.jpg"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"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"}},"commentCount":null,"purchaseClientRels":[{"id":941,"contract_id":2170,"client_id":304,"project_id":2667,"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":2667,"key":2667,"name":"\u670d\u52a1\u5668\u65b0\u8d2d","project_status":3,"clickable":1}},{"id":942,"contract_id":2170,"client_id":12,"project_id":null,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","sales_rep":5300,"clickable":0,"msg":"\u60a8\u65e0\u6743\u8bbf\u95ee\u6b64\u5ba2\u6237"},"project":null},{"id":943,"contract_id":2170,"client_id":1301,"project_id":2647,"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":5295,"clickable":1},"project":{"id":2647,"key":2647,"name":"\u5b89\u5168\u52a0\u56fa(\u4e1a\u52a1\u7f51)","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"11777","key":"11777","contract_id":2170,"value":"9200.00","collected_date":"2022-01-05 13:01:31","created_at":"2022-01-05 13:01:31","created_by":5298,"description":null,"createdBy":{"id":5298,"key":5298,"name":"\u675c\u6587\u98de","sex":"F","department_id":3},"pct":82.51},{"id":"11776","key":"11776","contract_id":2170,"value":"1950.00","collected_date":"2021-12-24 16:36:11","created_at":"2021-12-24 16:36:11","created_by":5298,"description":null,"createdBy":{"id":5298,"key":5298,"name":"\u675c\u6587\u98de","sex":"F","department_id":3},"pct":17.49}],"purchaseContractInvoices":[{"id":1095,"key":1095,"contract_id":2170,"amount":"11150.00","value":"11150.00","attachment_id":9142,"from_date":"2021-12-16","description":null,"is_draft":true,"attachment":{"id":9142,"key":9142,"name":"c7348678-1079-38c4-83bb-5b02ed8e2727","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/c7348678-1079-38c4-83bb-5b02ed8e2727\/2021_12_17_10_20_50.pdf","orig_name":"2021_12_17_10_20_50.pdf"},"attachmentRelationships":[],"files":[{"id":7626,"object_type":103,"object_id":1095,"attachment_id":9142,"attachment":{"id":9142,"key":9142,"name":"c7348678-1079-38c4-83bb-5b02ed8e2727","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/c7348678-1079-38c4-83bb-5b02ed8e2727\/2021_12_17_10_20_50.pdf","orig_name":"2021_12_17_10_20_50.pdf"}}]}],"contractScans":[{"id":14556,"object_type":108,"object_id":2170,"attachment_id":9141,"attachment":{"id":9141,"key":9141,"name":"4282639c-bf4a-3481-ae27-7ccc87617d6c","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/4282639c-bf4a-3481-ae27-7ccc87617d6c\/\u592a\u8c37\u8baf\u8bda.pdf","orig_name":"\u592a\u8c37\u8baf\u8bda.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":11150,"approve_amount":0,"un_approve_amount":11150,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"11150","un_collected":0,"collected_plan":0,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":591,"supplier_id":63,"contract_type":1,"signed_at":"2018-06-10","amount":"15200","handler":1011,"description":"\u670d\u52a1\u5668","contract_scan":1412,"created_by":5023,"created_at":"2018-07-10 10:46:53","updated_at":"2020-05-27 10:59:34","client_id":304,"project_id":682,"sales_rep":null,"serial_no":"-","payment_collection_remind_ahead":null,"including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"15200","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":63,"key":63,"name":"\u5317\u4eac\u6167\u535a\u4e16\u7eaa\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{"id":1412,"key":1412,"name":"\/files\/protected\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/aedce200-b714-3b34-9b94-a25461588f3d\/\u6167\u535a\u4e16\u7eaa.pdfaedce200-b714-3b34-9b94-a25461588f3d.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/aedce200-b714-3b34-9b94-a25461588f3d\/\u6167\u535a\u4e16\u7eaa.pdf","orig_name":"\u6167\u535a\u4e16\u7eaa.pdf","download":"\/vue\/attachment\/download?name=aedce200-b714-3b34-9b94-a25461588f3d"},"createdBy":{"id":5023,"key":5023,"name":"\u5f90\u4eac\u5357","sex":"F","department_id":3,"avatar":{"id":33,"user_id":5023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e77516c8-4c47-3e32-acbb-7c25718f4d57.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"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"}},"commentCount":null,"purchaseClientRels":[{"id":98,"contract_id":591,"client_id":304,"project_id":682,"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":682,"key":682,"name":"\u865a\u62df\u684c\u9762","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"11141","key":"11141","contract_id":591,"value":"15200.00","collected_date":"2018-07-10 10:46:53","created_at":"2018-07-10 10:46:53","created_by":null,"description":null,"createdBy":null,"pct":100}],"purchaseContractInvoices":[{"id":273,"key":273,"contract_id":591,"amount":"15200.00","value":"15200.00","attachment_id":null,"from_date":null,"description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":13752,"object_type":108,"object_id":591,"attachment_id":1412,"attachment":{"id":1412,"key":1412,"name":"aedce200-b714-3b34-9b94-a25461588f3d","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/aedce200-b714-3b34-9b94-a25461588f3d\/\u6167\u535a\u4e16\u7eaa.pdf","orig_name":"\u6167\u535a\u4e16\u7eaa.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":15200,"approve_amount":0,"un_approve_amount":15200,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"15200","un_collected":0,"collected_plan":0,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":566,"supplier_id":50,"contract_type":1,"signed_at":"2018-06-08","amount":"37000","handler":1011,"description":"\u7626\u673a","contract_scan":1374,"created_by":5023,"created_at":"2018-07-02 15:50:19","updated_at":"2020-05-27 10:59:49","client_id":304,"project_id":682,"sales_rep":null,"serial_no":"-","payment_collection_remind_ahead":null,"including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"37000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":50,"key":50,"name":"\u5317\u4eac\u9e3f\u539f\u5728\u7ebf\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"contractScan":{"id":1374,"key":1374,"name":"\/files\/protected\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/ef9a3af7-b86b-31c6-a5ae-8bbd41155631\/\u5b8f\u8fdc\u5728\u7ebf.pdfef9a3af7-b86b-31c6-a5ae-8bbd41155631.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/ef9a3af7-b86b-31c6-a5ae-8bbd41155631\/\u5b8f\u8fdc\u5728\u7ebf.pdf","orig_name":"\u5b8f\u8fdc\u5728\u7ebf.pdf","download":"\/vue\/attachment\/download?name=ef9a3af7-b86b-31c6-a5ae-8bbd41155631"},"createdBy":{"id":5023,"key":5023,"name":"\u5f90\u4eac\u5357","sex":"F","department_id":3,"avatar":{"id":33,"user_id":5023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e77516c8-4c47-3e32-acbb-7c25718f4d57.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"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"}},"commentCount":null,"purchaseClientRels":[{"id":160,"contract_id":566,"client_id":304,"project_id":682,"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":682,"key":682,"name":"\u865a\u62df\u684c\u9762","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1949","key":"1949","contract_id":566,"value":"37000.00","collected_date":"2018-07-02 15:50:19","created_at":"2018-07-02 15:50:19","created_by":null,"description":null,"createdBy":null,"pct":100}],"purchaseContractInvoices":[{"id":275,"key":275,"contract_id":566,"amount":"37000.00","value":"37000.00","attachment_id":null,"from_date":null,"description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":13817,"object_type":108,"object_id":566,"attachment_id":1374,"attachment":{"id":1374,"key":1374,"name":"ef9a3af7-b86b-31c6-a5ae-8bbd41155631","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/ef9a3af7-b86b-31c6-a5ae-8bbd41155631\/\u5b8f\u8fdc\u5728\u7ebf.pdf","orig_name":"\u5b8f\u8fdc\u5728\u7ebf.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":37000,"approve_amount":0,"un_approve_amount":37000,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"37000","un_collected":0,"collected_plan":0,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":526,"supplier_id":239,"contract_type":1,"signed_at":"2018-06-08","amount":"850","handler":1011,"description":"\u5218\u66e6\u7433-\u745e\u62d3\u7535\u5b50-\u5317\u65b9\u534e\u521b","contract_scan":1296,"created_by":1011,"created_at":"2018-06-08 13:51:54","updated_at":"2020-05-27 11:00:53","client_id":304,"project_id":682,"sales_rep":null,"serial_no":"-","payment_collection_remind_ahead":null,"including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"850","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":239,"key":239,"name":"\u5317\u4eac\u7ecf\u4f1f\u4f73\u4e1a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{"id":1296,"key":1296,"name":"\/files\/protected\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/e6238cc6-67ca-3e3b-93a2-382cd29ef5d0\/\u91c7\u8d2d\u5408\u540c.pdfe6238cc6-67ca-3e3b-93a2-382cd29ef5d0.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/e6238cc6-67ca-3e3b-93a2-382cd29ef5d0\/\u91c7\u8d2d\u5408\u540c.pdf","orig_name":"\u91c7\u8d2d\u5408\u540c.pdf","download":"\/vue\/attachment\/download?name=e6238cc6-67ca-3e3b-93a2-382cd29ef5d0"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"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"}},"commentCount":null,"purchaseClientRels":[{"id":184,"contract_id":526,"client_id":304,"project_id":682,"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":682,"key":682,"name":"\u865a\u62df\u684c\u9762","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1612","key":"1612","contract_id":526,"value":"850.00","collected_date":"2018-06-08 13:51:54","created_at":"2018-06-08 13:51:54","created_by":null,"description":null,"createdBy":null,"pct":100}],"purchaseContractInvoices":[{"id":278,"key":278,"contract_id":526,"amount":"850.00","value":"850.00","attachment_id":null,"from_date":null,"description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":13841,"object_type":108,"object_id":526,"attachment_id":1296,"attachment":{"id":1296,"key":1296,"name":"e6238cc6-67ca-3e3b-93a2-382cd29ef5d0","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/e6238cc6-67ca-3e3b-93a2-382cd29ef5d0\/\u91c7\u8d2d\u5408\u540c.pdf","orig_name":"\u91c7\u8d2d\u5408\u540c.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":850,"approve_amount":0,"un_approve_amount":850,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"850","un_collected":0,"collected_plan":0,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":565,"supplier_id":57,"contract_type":1,"signed_at":"2018-06-06","amount":"320","handler":1011,"description":"HP\u7ebf","contract_scan":1373,"created_by":5023,"created_at":"2018-07-02 15:47:56","updated_at":"2020-05-27 11:01:12","client_id":304,"project_id":682,"sales_rep":null,"serial_no":"-","payment_collection_remind_ahead":null,"including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"320","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"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)"},"contractScan":{"id":1373,"key":1373,"name":"\/files\/protected\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/be79b993-28a0-3be8-8d12-85cf121adcd7\/6.6_\u9510\u7f51.pdfbe79b993-28a0-3be8-8d12-85cf121adcd7.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/be79b993-28a0-3be8-8d12-85cf121adcd7\/6.6_\u9510\u7f51.pdf","orig_name":"6.6_\u9510\u7f51.pdf","download":"\/vue\/attachment\/download?name=be79b993-28a0-3be8-8d12-85cf121adcd7"},"createdBy":{"id":5023,"key":5023,"name":"\u5f90\u4eac\u5357","sex":"F","department_id":3,"avatar":{"id":33,"user_id":5023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e77516c8-4c47-3e32-acbb-7c25718f4d57.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"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"}},"commentCount":null,"purchaseClientRels":[{"id":99,"contract_id":565,"client_id":304,"project_id":682,"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":682,"key":682,"name":"\u865a\u62df\u684c\u9762","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1948","key":"1948","contract_id":565,"value":"320.00","collected_date":"2018-07-02 15:47:56","created_at":"2018-07-02 15:47:56","created_by":null,"description":null,"createdBy":null,"pct":100}],"purchaseContractInvoices":[{"id":280,"key":280,"contract_id":565,"amount":"320.00","value":"320.00","attachment_id":null,"from_date":null,"description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":13753,"object_type":108,"object_id":565,"attachment_id":1373,"attachment":{"id":1373,"key":1373,"name":"be79b993-28a0-3be8-8d12-85cf121adcd7","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/be79b993-28a0-3be8-8d12-85cf121adcd7\/6.6_\u9510\u7f51.pdf","orig_name":"6.6_\u9510\u7f51.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":320,"approve_amount":0,"un_approve_amount":320,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"320","un_collected":0,"collected_plan":0,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":562,"supplier_id":65,"contract_type":1,"signed_at":"2018-06-05","amount":"73900","handler":1011,"description":"HP","contract_scan":1370,"created_by":5023,"created_at":"2018-07-02 15:37:53","updated_at":"2020-05-27 11:02:38","client_id":304,"project_id":682,"sales_rep":null,"serial_no":"-","payment_collection_remind_ahead":null,"including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"73900","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":65,"key":65,"name":"\u5317\u4eac\u7f51\u8054\u672a\u6765\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"contractScan":{"id":1370,"key":1370,"name":"\/files\/protected\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/40d8fb9d-fdd8-36c0-a8c2-39bce2a2aebb\/\u534e\u6c0f.pdf40d8fb9d-fdd8-36c0-a8c2-39bce2a2aebb.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/40d8fb9d-fdd8-36c0-a8c2-39bce2a2aebb\/\u534e\u6c0f.pdf","orig_name":"\u534e\u6c0f.pdf","download":"\/vue\/attachment\/download?name=40d8fb9d-fdd8-36c0-a8c2-39bce2a2aebb"},"createdBy":{"id":5023,"key":5023,"name":"\u5f90\u4eac\u5357","sex":"F","department_id":3,"avatar":{"id":33,"user_id":5023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e77516c8-4c47-3e32-acbb-7c25718f4d57.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"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"}},"commentCount":null,"purchaseClientRels":[{"id":164,"contract_id":562,"client_id":304,"project_id":682,"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":682,"key":682,"name":"\u865a\u62df\u684c\u9762","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"11941","key":"11941","contract_id":562,"value":"73900.00","collected_date":"2018-07-02 15:37:53","created_at":"2018-07-02 15:37:53","created_by":null,"description":null,"createdBy":null,"pct":100}],"purchaseContractInvoices":[{"id":284,"key":284,"contract_id":562,"amount":"73900.00","value":"73900.00","attachment_id":null,"from_date":null,"description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":13821,"object_type":108,"object_id":562,"attachment_id":1370,"attachment":{"id":1370,"key":1370,"name":"40d8fb9d-fdd8-36c0-a8c2-39bce2a2aebb","extension":"pdf","path":"\/v2\/attachment\/preview\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/40d8fb9d-fdd8-36c0-a8c2-39bce2a2aebb\/\u534e\u6c0f.pdf","orig_name":"\u534e\u6c0f.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"invoiced":73900,"approve_amount":0,"un_approve_amount":73900,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"73900","un_collected":0,"collected_plan":0,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false}],"pagenation":{"totalcount":11,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-08-08 10:21:44') RETURNING "id"
10:21:44.8511.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
10:21:44.9011.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (273, 275, 278, 280, 284, 1094, 1095, 1096, 1097, 1207, 1261))
10:21:44.9021.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (273, 275, 278, 280, 284, 1094, 1095, 1096, 1097, 1207, 1261))
10:21:44.9041.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id" IN (2352, 2171, 2169, 2153, 2170, 591, 566, 526, 565, 562))
10:21:44.9061.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id" IN (2352, 2171, 2169, 2153, 2170, 591, 566, 526, 565, 562))
10:21:44.9000.8 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id" IN (2352, 2171, 2169, 2153, 2170, 591, 566, 526, 565, 562) ORDER BY "id"
10:21:44.9120.7 msyii\db\Command::querySELECT "pt".*, "taxonomy_id" AS "key", "tt"."name" AS "name", "out_amount" AS "amount", "value" AS "description", "extra_int" AS "parent_id", "tt"."serial_no" FROM "a57be577deb434"."tbl_term_taxonomy_relationships" "pt" LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON taxonomy_id = tt.id WHERE ("pt"."term_id"=18) AND ("pt"."object_type"=8) AND ("pt"."object_id" IN (2352, 2171, 2169, 2153, 2170, 591, 566, 526, 565, 562)) ORDER BY "id"
10:21:44.9310.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "purchase_contract_id" IN (2352, 2171, 2169, 2153, 2170, 591, 566, 526, 565, 562)
10:21:44.9310.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id" IN (2352, 2171, 2169, 2153, 2170, 591, 566, 526, 565, 562)
10:21:44.8920.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (2352, 2171, 2169, 2153, 2170, 591, 566, 526, 565, 562) ORDER BY "id"
10:21:44.9080.5 msyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (2352, 2171, 2169, 2153, 2170, 591, 566, 526, 565, 562)
10:21:44.8670.5 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id"=682
10:21:44.9080.4 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN (2352, 2171, 2169, 2153, 2170, 591, 566, 526, 565, 562) ORDER BY "remind_date"
10:21:44.8680.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (9148, 9139, 9037, 9141, 1412, 1374, 1296, 1373, 1370)
10:21:44.8690.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, 5023, 5298))
10:21:44.8700.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3
10:21:44.8930.3 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (682, 2667, 2647, 2914, 2869, 2882, 2970)
10:21:44.8670.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=304
10:21:44.8920.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (304, 12, 1301, 1121, 2128, 2184)
10:21:44.8680.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (137, 86, 363, 59, 63, 50, 239, 57, 65)
10:21:44.9040.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (9140, 9142, 9143, 9144, 11079, 11690)
10:21:44.9060.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (1412, 1373, 1374, 1370, 1296, 9148, 9037, 9139, 9141, 11689)
10:21:44.8690.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5298, 5023)
10:21:44.8990.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5298, 1011)
10:21:44.8670.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
10:21:44.9010.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (9140, 9142, 9143, 9144)
10:21:44.8700.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5298)
10:21:44.8710.2 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, 5298))