ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
69427d6bd7b54: POST https://beta.jinchangxiao.com/v2/purchase-contract/of-client at 2025-12-17 05:52:43 pm by 221.216.117.150

Performance Profiling

Total processing time: 163 ms; Peak memory: 6.176 MB. Show Profiling Timeline

总计56条数据
TimeDurationCategoryInfo
  
17:52:43.92729.2 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=13) AND ("object_id" IN (4079, 3820, 3806, 3700, 3535, 3572, 3513, 3511, 3505, 2800)) GROUP BY "object_id"
17:52:43.99224.7 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=13) AND (remind_user_id = 5064 AND is_read = false) AND ("object_id" IN (4079, 3820, 3806, 3700, 3535, 3572, 3513, 3511, 3505, 2800)) GROUP BY "object_id"
17:52:43.9038.4 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 ("c"."cost_type" IN (1, 2)) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5064)) OR ("pcr"."id" IS NULL)) AND ("pcr"."client_id"='518') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"
17:52:43.9595.3 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"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5))) 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) ) 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"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) 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) )) "sub") "r" WHERE "contract_id" IN (4079, 3820, 3806, 3700, 3535, 3572, 3513, 3511, 3505, 2800) ORDER BY "id" DESC
17:52:43.9125.0 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 ("c"."cost_type" IN (1, 2)) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5064)) OR ("pcr"."id" IS NULL)) AND ("pcr"."client_id"='518') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10
17:52:43.9714.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (1417, 1883, 1885, 1907, 1917, 1952, 2071, 2164, 2170, 2396))
17:52:43.9764.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id" IN (4079, 3820, 3806, 3700, 3535, 3572, 3513, 3511, 3505, 2800))
17:52:43.8894.0 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG'
17:52:43.9663.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (1417, 1883, 1885, 1907, 1917, 1952, 2071, 2164, 2170, 2396))
17:52:43.9813.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id" IN (4079, 3820, 3806, 3700, 3535, 3572, 3513, 3511, 3505, 2800))
17:52:43.8863.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:52:44.0403.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', 5064, 2, 1153, 'v2/purchase-contract/of-client', '{"access_token":"-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG","device_type":"2","id":"518","page":"1","posttime":"1765965184","token":"fbd3ba0f41d1f8cc78b62d2124a37334","version_code":"1153"}', '{"code":200,"data":{"list":[{"id":4079,"supplier_id":236,"contract_type":1,"signed_at":"2025-08-04","amount":"2513","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-08-04 16:12:18","updated_at":"2025-08-06 11:13:03","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20250804-HYYF-001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-04 16:12:31","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"2513","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"2513","client":null,"project":null,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\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":{"object_id":4079,"comment":2},"purchaseClientRels":[{"id":3713,"contract_id":4079,"client_id":518,"project_id":3935,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":3935,"key":3935,"name":"\u65b0\u8d2d\u9632\u706b\u5899SSL VPN\u6388\u6743","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"12067","key":"12067","contract_id":4079,"value":"2513","collected_date":"2025-08-04 17:35:53","created_at":"2025-08-04 17:35:53","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2396,"key":2396,"contract_id":4079,"amount":"2513","value":"2513","attachment_id":null,"from_date":"2025-08-08","description":"","is_draft":false,"is_cancel":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":48181,"object_type":103,"object_id":2396,"attachment_id":27328,"attachment":{"id":27328,"key":27328,"name":"a913644a-cbda-30d1-a314-fcb198ea1629","extension":"pdf","path":"\/v2\/attachment\/view\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/a913644a-cbda-30d1-a314-fcb198ea1629\/dzfp_25112000000165961965_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250808154515.pdf","orig_name":"dzfp_25112000000165961965_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250808154515.pdf"}}]}],"contractScans":[{"id":37554,"object_type":108,"object_id":4079,"attachment_id":27290,"attachment":{"id":27290,"key":27290,"name":"00eca117-f0bb-367c-9358-ad7287e24709","extension":"pdf","path":"\/v2\/attachment\/preview\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/00eca117-f0bb-367c-9358-ad7287e24709\/\u62d3\u5b9e\u5408\u540c (2).pdf","orig_name":"\u62d3\u5b9e\u5408\u540c (2).pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1376,"user_id":1011,"key":1011,"contract_id":4079,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":1377,"user_id":5360,"key":5360,"contract_id":4079,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":813,"key":813,"contract_id":4079,"name":"2025-08-04","value":"2513","overdue_days":0,"status":1,"remind_date":"2025-08-04","pct":100,"overdue_display":"\u903e\u671f0\u5929"}],"paymentApproves":[{"id":2126,"client_id":518,"project_id":3935,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-08-04 16:54:07","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8SSL VPN\u4ea7\u54c1\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe52513\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u6587\u4ef6\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2025-08-04 16:21:23","updated_at":"2025-08-04 16:54:07","supplier_id":236,"purchase_contract_id":4079,"amount":"2513","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"2513","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":null,"cancel_at":null,"cancel_description":null,"erp_payment_all_settle_amount":"2513"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":1,"purchase_contract_id":4079,"erp_store_id":null,"erp_purchase_order_product_id":1,"product_id":2049,"description":"","number":"1","amount":"2513","total_amount":"2513","erpStore":null,"product":{"id":2049,"name":"\u6df1\u4fe1\u670dSSL VPN\u6388\u6743\u8f6f\u4ef6V6.0","product_type":5,"product_component":35,"product_brand":12,"product_serie":103,"product_misc":null,"product_qa":null,"pn":"","description":"\u79fb\u52a8\u63a5\u5165\u6388\u6743\n\u6df1\u4fe1\u670dSSL VPN\u63a5\u5165\u6388\u6743\uff08\u6bcf\u589e\u52a0\u4e00\u4e2aSSL\u63a5\u5165\u8bb8\u53ef\uff09","created_by":1013,"created_at":"2025-07-16 10:55:32","updated_at":"2025-07-16 10:55:32","pinyin_shortcut":"sxfSSLVPNsqrjV60","product_unit":2,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":103,"key":103,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":1,"erp_purchase_order_id":2008,"erp_store_id":null,"product_id":2049,"description":"","number":"1","into_inventory":"0","amount":"2513","total_amount":"2513","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2008,"serial_no":"CGDD-20250804-00002","from_date":null,"wrote_date":"2025-08-04","handler":1011,"supplier_id":236,"purchase_contract_id":4079,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-08-04 16:12:18","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"1","amount":null,"created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2025-08-04 16:12:18","updated_at":"2025-08-06 11:13:03","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":"2513","approve_amount":2513,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"2513","un_collected":0,"collected_plan":2513,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":2513,"product_number":1,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":3820,"supplier_id":676,"contract_type":1,"signed_at":"2025-03-07","amount":"25000.00","handler":5360,"description":"","contract_scan":null,"created_by":5360,"created_at":"2025-03-07 13:47:55","updated_at":"2025-03-11 09:17:42","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"ALX-Q20250310-0105","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-07 13:48:10","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"25000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"25000","client":null,"project":null,"supplier":{"id":676,"key":676,"name":"\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":null,"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}},"commentCount":{"object_id":3820,"comment":2},"purchaseClientRels":[{"id":3097,"contract_id":3820,"client_id":518,"project_id":3772,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":3772,"key":3772,"name":"2025\u65b0\u8d2d4090\u663e\u5361-K","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1326","key":"1326","contract_id":3820,"value":"25000.00","collected_date":"2025-03-07 14:49:25","created_at":"2025-03-07 14:49:25","created_by":5388,"description":null,"createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2164,"key":2164,"contract_id":3820,"amount":"25000","value":"25000","attachment_id":null,"from_date":"2025-03-11","description":"","is_draft":false,"is_cancel":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":32817,"object_type":103,"object_id":2164,"attachment_id":24493,"attachment":{"id":24493,"key":24493,"name":"65e1c5d3-de95-3d27-ad81-9feb7132e760","extension":"pdf","path":"\/v2\/attachment\/view\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/65e1c5d3-de95-3d27-ad81-9feb7132e760\/dzfp_25112000000048539295_\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8_20250311160622.pdf","orig_name":"dzfp_25112000000048539295_\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8_20250311160622.pdf"}}]}],"contractScans":[{"id":32799,"object_type":108,"object_id":3820,"attachment_id":24482,"attachment":{"id":24482,"key":24482,"name":"7fc110e4-d613-3b33-b60f-3a8ad7d46624","extension":"pdf","path":"\/v2\/attachment\/preview\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/7fc110e4-d613-3b33-b60f-3a8ad7d46624\/2025_03_11_09_15_24.pdf","orig_name":"2025_03_11_09_15_24.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":987,"user_id":1011,"key":1011,"contract_id":3820,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":988,"user_id":5360,"key":5360,"contract_id":3820,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":603,"key":603,"contract_id":3820,"name":"2025-03-07","value":"25000","overdue_days":0,"status":1,"remind_date":"2025-03-07","pct":100,"overdue_display":"\u903e\u671f0\u5929"}],"paymentApproves":[{"id":1694,"client_id":518,"project_id":3772,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-03-07 14:23:28","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u56fd\u79d1\u73af\u5b87-\u663e\u5361\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d25000\u5143\uff0c\u663e\u5361\u9700\u8981\u73b0\u7ed3\u624d\u80fd\u53d1\u8d27\uff0c\u7533\u8bf7\u4eca\u65e5\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":null,"is_resubmited":false,"created_by":5360,"created_at":"2025-03-07 14:10:17","updated_at":"2025-03-07 14:23:28","supplier_id":676,"purchase_contract_id":3820,"amount":"25000","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"25000","erp_payment_un_settle_amount":"-25000","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":null,"cancel_at":null,"cancel_description":null,"erp_payment_all_settle_amount":"25000"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1865,"serial_no":"CGDD-20250307-00004","from_date":null,"wrote_date":"2025-03-07","handler":5360,"supplier_id":676,"purchase_contract_id":3820,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-03-07 13:47:55","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"25000.00","created_by":5360,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2025-03-07 13:47:55","updated_at":"2025-03-11 09:17:42","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":"25000","approve_amount":25000,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"25000","un_collected":0,"collected_plan":25000,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":3806,"supplier_id":59,"contract_type":1,"signed_at":"2025-03-03","amount":"800.00","handler":5360,"description":"","contract_scan":null,"created_by":5360,"created_at":"2025-03-04 09:39:32","updated_at":"2025-03-11 13:25:18","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TGXC20250303-1","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-04 09:39:45","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"800","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"800","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":null,"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}},"commentCount":{"object_id":3806,"comment":8},"purchaseClientRels":[{"id":3180,"contract_id":3806,"client_id":518,"project_id":3788,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":3788,"key":3788,"name":"\u65b0\u8d2d\u670d\u52a1\u5668\u786c\u76d8","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1364","key":"1364","contract_id":3806,"value":"800.00","collected_date":"2025-04-11 12:52:42","created_at":"2025-04-11 12:52:42","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2170,"key":2170,"contract_id":3806,"amount":"800","value":"800","attachment_id":null,"from_date":"2025-03-11","description":"","is_draft":false,"is_cancel":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":32835,"object_type":103,"object_id":2170,"attachment_id":24504,"attachment":{"id":24504,"key":24504,"name":"29dcc02e-8721-31ae-81b2-c99cecfb677e","extension":"pdf","path":"\/v2\/attachment\/view\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/29dcc02e-8721-31ae-81b2-c99cecfb677e\/\u53d1\u7968-\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f83.11\uff08800\u5143\uff09.pdf","orig_name":"\u53d1\u7968-\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f83.11\uff08800\u5143\uff09.pdf"}}]}],"contractScans":[{"id":32815,"object_type":108,"object_id":3806,"attachment_id":24492,"attachment":{"id":24492,"key":24492,"name":"8cc43939-d5a9-3d1a-ae3e-8f160be7dab0","extension":"pdf","path":"\/v2\/attachment\/preview\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/8cc43939-d5a9-3d1a-ae3e-8f160be7dab0\/2025_03_11_13_23_30.pdf","orig_name":"2025_03_11_13_23_30.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":969,"user_id":1011,"key":1011,"contract_id":3806,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":970,"user_id":5360,"key":5360,"contract_id":3806,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":594,"key":594,"contract_id":3806,"name":"2025-04-03","value":"800","overdue_days":8,"status":1,"remind_date":"2025-04-03","pct":100,"overdue_display":"\u903e\u671f8\u5929"}],"paymentApproves":[{"id":1779,"client_id":518,"project_id":3788,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-04-07 11:27:58","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u56fd\u79d1\u73af\u5b87-\u670d\u52a1\u5668\u786c\u76d8\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d800\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":null,"is_resubmited":false,"created_by":5360,"created_at":"2025-04-07 09:28:31","updated_at":"2025-04-07 11:27:58","supplier_id":59,"purchase_contract_id":3806,"amount":"800","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"800","erp_payment_un_settle_amount":"-800","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":null,"cancel_at":null,"cancel_description":null,"erp_payment_all_settle_amount":"800"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1857,"serial_no":"CGDD-20250304-00001","from_date":null,"wrote_date":"2025-03-03","handler":5360,"supplier_id":59,"purchase_contract_id":3806,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-03-04 09:39:32","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"800.00","created_by":5360,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2025-03-04 09:39:32","updated_at":"2025-03-11 13:25:18","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":"800","approve_amount":800,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"800","un_collected":0,"collected_plan":800,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":3700,"supplier_id":236,"contract_type":1,"signed_at":"2024-12-10","amount":"17089.00","handler":5360,"description":"","contract_scan":null,"created_by":5360,"created_at":"2024-12-10 15:17:31","updated_at":"2024-12-16 10:37:36","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20241210-ZHF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-12-10 15:17:48","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"17089","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"17089","client":null,"project":null,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"contractScan":null,"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}},"commentCount":{"object_id":3700,"comment":1},"purchaseClientRels":[{"id":2912,"contract_id":3700,"client_id":518,"project_id":3737,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":3737,"key":3737,"name":"2024\u65b0\u8d2d\u6df1\u4fe1\u670d\u9632\u706b\u5899","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1244","key":"1244","contract_id":3700,"value":"17089.00","collected_date":"2024-12-10 15:18:32","created_at":"2024-12-10 15:18:32","created_by":5360,"description":null,"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3},"pct":100}],"purchaseContractInvoices":[{"id":2071,"key":2071,"contract_id":3700,"amount":"17089","value":"17089","attachment_id":null,"from_date":"2024-12-13","description":"","is_draft":false,"is_cancel":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":31176,"object_type":103,"object_id":2071,"attachment_id":23278,"attachment":{"id":23278,"key":23278,"name":"ca2f0bf9-1b72-3a2b-afb9-aa9321f9fa8c","extension":"pdf","path":"\/v2\/attachment\/view\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/ca2f0bf9-1b72-3a2b-afb9-aa9321f9fa8c\/dzfp_24112000000209617343_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20241213151140.pdf","orig_name":"dzfp_24112000000209617343_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20241213151140.pdf"}}]}],"contractScans":[{"id":30991,"object_type":108,"object_id":3700,"attachment_id":23115,"attachment":{"id":23115,"key":23115,"name":"ee78649f-eff5-3485-83cf-e4b20830c9ef","extension":"pdf","path":"\/v2\/attachment\/preview\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/ee78649f-eff5-3485-83cf-e4b20830c9ef\/\u62d3\u5b9e-\u56fd\u79d1\u73af\u5b87AF\u91c7\u8d2d\u5408\u540c20241210.pdf","orig_name":"\u62d3\u5b9e-\u56fd\u79d1\u73af\u5b87AF\u91c7\u8d2d\u5408\u540c20241210.pdf"}}],"receiptScans":[{"id":31074,"object_type":111,"object_id":3700,"attachment_id":23177,"attachment":{"id":23177,"key":23177,"name":"215d7ae3-1f46-31fe-b91d-68a89fe5c308","extension":"jpg","path":"\/v2\/attachment\/preview\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/215d7ae3-1f46-31fe-b91d-68a89fe5c308\/11611734316533_.pic_hd.jpg","orig_name":"11611734316533_.pic_hd.jpg"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":813,"user_id":1011,"key":1011,"contract_id":3700,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":814,"user_id":5360,"key":5360,"contract_id":3700,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":500,"key":500,"contract_id":3700,"name":"2024-12-10","value":"17089","overdue_days":0,"status":1,"remind_date":"2024-12-10","pct":100,"overdue_display":"\u903e\u671f0\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1804,"serial_no":"CGDD-20241210-00002","from_date":null,"wrote_date":"2024-12-10","handler":5360,"supplier_id":236,"purchase_contract_id":3700,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-12-10 15:17:31","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"17089.00","created_by":5360,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-12-10 15:17:31","updated_at":"2024-12-16 10:37:36","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":"17089","approve_amount":0,"un_approve_amount":17089,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"17089","un_collected":0,"collected_plan":17089,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":3535,"supplier_id":203,"contract_type":1,"signed_at":"2024-08-30","amount":"113412.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2024-09-10 15:24:11","updated_at":"2024-09-10 15:28:18","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"YZ-XSA24135","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-09-10 15:26:02","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"113412","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"113412","client":null,"project":null,"supplier":{"id":203,"key":203,"name":"\u5317\u4eac\u5353\u4f18\u4e91\u667a\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":{"object_id":3535,"comment":2},"purchaseClientRels":[{"id":2965,"contract_id":3535,"client_id":518,"project_id":3642,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":3642,"key":3642,"name":"\u901f\u77f3\u9ad8\u6027\u80fd\u5e73\u53f0+\u5b58\u50a8\u65b0\u8d2d","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1213","key":"1213","contract_id":3535,"value":"113412.00","collected_date":"2024-09-12 14:10:10","created_at":"2024-09-12 14:10:10","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1907,"key":1907,"contract_id":3535,"amount":"113412","value":"113412","attachment_id":null,"from_date":"2024-09-13","description":"","is_draft":false,"is_cancel":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":28745,"object_type":103,"object_id":1907,"attachment_id":21525,"attachment":{"id":21525,"key":21525,"name":"f497f2d1-1a7f-3bd8-b115-575793a3fb04","extension":"pdf","path":"\/v2\/attachment\/view\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/f497f2d1-1a7f-3bd8-b115-575793a3fb04\/dzfp_24112000000129458000_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240913120538.YZ-XSA24135pdf.pdf","orig_name":"dzfp_24112000000129458000_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240913120538.YZ-XSA24135pdf.pdf"}}]}],"contractScans":[{"id":28603,"object_type":108,"object_id":3535,"attachment_id":21427,"attachment":{"id":21427,"key":21427,"name":"835726f2-351c-3d2c-9270-8bbd95364ebb","extension":"pdf","path":"\/v2\/attachment\/preview\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/835726f2-351c-3d2c-9270-8bbd95364ebb\/2024_09_02_14_32_03.pdf","orig_name":"2024_09_02_14_32_03.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":503,"user_id":1011,"key":1011,"contract_id":3535,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":504,"user_id":5360,"key":5360,"contract_id":3535,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":332,"key":332,"contract_id":3535,"name":"2024-09-10","value":"113412","overdue_days":2,"status":1,"remind_date":"2024-09-10","pct":100,"overdue_display":"\u903e\u671f2\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1701,"serial_no":"CGDD-20240910-00006","from_date":null,"wrote_date":"2024-08-30","handler":1011,"supplier_id":203,"purchase_contract_id":3535,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-09-10 15:24:11","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"113412.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-09-10 15:24:11","updated_at":"2024-09-10 15:28:18","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":"113412","approve_amount":0,"un_approve_amount":113412,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"113412","un_collected":0,"collected_plan":113412,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":3572,"supplier_id":598,"contract_type":1,"signed_at":"2024-08-29","amount":"100000.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2024-10-08 16:13:28","updated_at":"2024-12-31 16:58:13","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20240829-HYF-004","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-10-08 16:13:49","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"100000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"100000","client":null,"project":null,"supplier":{"id":598,"key":598,"name":"\u5317\u4eac\u94f6\u65af\u6cf0\u7ecf\u8d38\u6709\u9650\u8d23\u4efb\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":{"object_id":3572,"comment":3},"purchaseClientRels":[{"id":2967,"contract_id":3572,"client_id":518,"project_id":3642,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":3642,"key":3642,"name":"\u901f\u77f3\u9ad8\u6027\u80fd\u5e73\u53f0+\u5b58\u50a8\u65b0\u8d2d","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1119","key":"1119","contract_id":3572,"value":"100000.00","collected_date":"2024-10-12 13:12:42","created_at":"2024-10-12 13:12:42","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1952,"key":1952,"contract_id":3572,"amount":"100000","value":"100000","attachment_id":null,"from_date":"2024-10-10","description":"","is_draft":false,"is_cancel":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":31491,"object_type":103,"object_id":1952,"attachment_id":23501,"attachment":{"id":23501,"key":23501,"name":"fcba2b33-888f-3110-9d3b-cccc46954b23","extension":"pdf","path":"\/v2\/attachment\/view\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/fcba2b33-888f-3110-9d3b-cccc46954b23\/dzfp_24112000000148518901_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20241010143931.pdf","orig_name":"dzfp_24112000000148518901_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20241010143931.pdf"}}]}],"contractScans":[{"id":31490,"object_type":108,"object_id":3572,"attachment_id":23378,"attachment":{"id":23378,"key":23378,"name":"dde400bd-3ea7-3316-8e4b-e11afc4ed9ff","extension":"pdf","path":"\/v2\/attachment\/preview\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/dde400bd-3ea7-3316-8e4b-e11afc4ed9ff\/2024_12_25_09_37_08.pdf","orig_name":"2024_12_25_09_37_08.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":563,"user_id":1011,"key":1011,"contract_id":3572,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":564,"user_id":5360,"key":5360,"contract_id":3572,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":366,"key":366,"contract_id":3572,"name":"2024-10-11","value":"100000","overdue_days":1,"status":1,"remind_date":"2024-10-11","pct":100,"overdue_display":"\u903e\u671f1\u5929"}],"paymentApproves":[{"id":1272,"client_id":518,"project_id":3642,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u94f6\u65af\u6cf0\u7ecf\u8d38\u6709\u9650\u8d23\u4efb\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2024-10-10 15:56:05","description":"\u8001\u5927\uff0c\u7533\u8bf7\u652f\u4ed8\u8d27\u6b3e\uff0c\u91d1\u989d\uffe5100000\uff0c\u8bf7\u5ba1\u6279\uff01\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u3002","refuse_description":null,"is_resubmited":false,"created_by":5360,"created_at":"2024-10-10 15:20:32","updated_at":"2024-10-10 15:56:05","supplier_id":598,"purchase_contract_id":3572,"amount":"100000","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"100000","erp_payment_un_settle_amount":"-100000","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":null,"cancel_at":null,"cancel_description":null,"erp_payment_all_settle_amount":"100000"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1722,"serial_no":"CGDD-20241008-00001","from_date":null,"wrote_date":"2024-08-29","handler":1011,"supplier_id":598,"purchase_contract_id":3572,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-10-08 16:13:28","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"100000.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-10-08 16:13:28","updated_at":"2024-12-31 16:58:13","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":"100000","approve_amount":100000,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"100000","un_collected":0,"collected_plan":100000,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":3513,"supplier_id":548,"contract_type":1,"signed_at":"2024-08-29","amount":"600.00","handler":5360,"description":"","contract_scan":null,"created_by":5360,"created_at":"2024-08-30 11:28:32","updated_at":"2024-09-24 11:23:56","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"2024-8-26","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-08-30 11:28:47","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"600","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"600","client":null,"project":null,"supplier":{"id":548,"key":548,"name":"\u5317\u4eac\u745e\u5408\u91d1\u521b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"contractScan":null,"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}},"commentCount":{"object_id":3513,"comment":3},"purchaseClientRels":[{"id":2966,"contract_id":3513,"client_id":518,"project_id":3642,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":3642,"key":3642,"name":"\u901f\u77f3\u9ad8\u6027\u80fd\u5e73\u53f0+\u5b58\u50a8\u65b0\u8d2d","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1137","key":"1137","contract_id":3513,"value":"600.00","collected_date":"2024-10-08 13:57:50","created_at":"2024-10-08 13:57:50","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1917,"key":1917,"contract_id":3513,"amount":"600","value":"600","attachment_id":null,"from_date":"2024-09-24","description":"","is_draft":false,"is_cancel":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":28918,"object_type":103,"object_id":1917,"attachment_id":21672,"attachment":{"id":21672,"key":21672,"name":"b5c3d557-2347-340b-855a-825bf0488693","extension":"pdf","path":"\/v2\/attachment\/view\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/b5c3d557-2347-340b-855a-825bf0488693\/dzfp_24112000000137296197_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240924100241.pdf","orig_name":"dzfp_24112000000137296197_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240924100241.pdf"}}]}],"contractScans":[{"id":28921,"object_type":108,"object_id":3513,"attachment_id":21674,"attachment":{"id":21674,"key":21674,"name":"6a16c3e3-4f6f-3287-9b50-c8be39e503c5","extension":"pdf","path":"\/v2\/attachment\/preview\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/6a16c3e3-4f6f-3287-9b50-c8be39e503c5\/\u62d3\u5b9e-\u745e\u5408\u91d1\u521b600\u5143-.pdf","orig_name":"\u62d3\u5b9e-\u745e\u5408\u91d1\u521b600\u5143-.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":451,"user_id":1011,"key":1011,"contract_id":3513,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":452,"user_id":5360,"key":5360,"contract_id":3513,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":305,"key":305,"contract_id":3513,"name":"2024-09-30","value":"600","overdue_days":8,"status":1,"remind_date":"2024-09-30","pct":100,"overdue_display":"\u903e\u671f8\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1686,"serial_no":"CGDD-20240830-00001","from_date":null,"wrote_date":"2024-08-29","handler":5360,"supplier_id":548,"purchase_contract_id":3513,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-08-30 11:28:32","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"600.00","created_by":5360,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-08-30 11:28:32","updated_at":"2024-09-24 11:23:56","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":"600","approve_amount":0,"un_approve_amount":600,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"600","un_collected":0,"collected_plan":600,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":3511,"supplier_id":632,"contract_type":1,"signed_at":"2024-08-29","amount":"37000.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2024-08-29 15:29:32","updated_at":"2024-08-29 15:29:45","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20240829-HYF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-08-29 15:29:45","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":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"37000","client":null,"project":null,"supplier":{"id":632,"key":632,"name":"\u5317\u4eac\u4f1f\u601d\u521b\u79d1\u6280\u80a1\u4efd\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":{"object_id":3511,"comment":3},"purchaseClientRels":[{"id":2964,"contract_id":3511,"client_id":518,"project_id":3642,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":3642,"key":3642,"name":"\u901f\u77f3\u9ad8\u6027\u80fd\u5e73\u53f0+\u5b58\u50a8\u65b0\u8d2d","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1153","key":"1153","contract_id":3511,"value":"37000.00","collected_date":"2024-10-08 14:05:05","created_at":"2024-10-08 14:05:05","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1883,"key":1883,"contract_id":3511,"amount":"37000","value":"37000","attachment_id":null,"from_date":"2024-09-09","description":"","is_draft":false,"is_cancel":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":28513,"object_type":103,"object_id":1883,"attachment_id":21348,"attachment":{"id":21348,"key":21348,"name":"ef9e13eb-dc36-3907-a300-d7ab1a224a60","extension":"pdf","path":"\/v2\/attachment\/view\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/ef9e13eb-dc36-3907-a300-d7ab1a224a60\/dzfp_24112000000125469285_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240909114845(1).pdf","orig_name":"dzfp_24112000000125469285_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240909114845(1).pdf"}}]}],"contractScans":[{"id":28256,"object_type":108,"object_id":3511,"attachment_id":21161,"attachment":{"id":21161,"key":21161,"name":"f129b3f2-975b-39b3-ba6e-daab0cfb7e97","extension":"pdf","path":"\/v2\/attachment\/preview\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/f129b3f2-975b-39b3-ba6e-daab0cfb7e97\/2024_08_29_15_27_08.pdf","orig_name":"2024_08_29_15_27_08.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":449,"user_id":1011,"key":1011,"contract_id":3511,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":450,"user_id":5360,"key":5360,"contract_id":3511,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":304,"key":304,"contract_id":3511,"name":"2024-09-30","value":"37000","overdue_days":8,"status":1,"remind_date":"2024-09-30","pct":100,"overdue_display":"\u903e\u671f8\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1685,"serial_no":"CGDD-20240829-00005","from_date":null,"wrote_date":"2024-08-29","handler":1011,"supplier_id":632,"purchase_contract_id":3511,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-08-29 15:29:32","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"37000.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-08-29 15:29:32","updated_at":"2024-08-29 15:29:45","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":"37000","approve_amount":0,"un_approve_amount":37000,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"37000","un_collected":0,"collected_plan":37000,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":3505,"supplier_id":106,"contract_type":1,"signed_at":"2024-08-28","amount":"31000.00","handler":5360,"description":"","contract_scan":null,"created_by":5360,"created_at":"2024-08-29 09:24:28","updated_at":"2024-08-29 14:10:25","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20240828-ZHF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-08-29 11:42:53","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"31000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"31000","client":null,"project":null,"supplier":{"id":106,"key":106,"name":"\u5317\u4eac\u8fd0\u8054\u7cfb\u7edf\u96c6\u6210\u6709\u9650\u516c\u53f8"},"contractScan":null,"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}},"commentCount":{"object_id":3505,"comment":3},"purchaseClientRels":[{"id":2963,"contract_id":3505,"client_id":518,"project_id":3642,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":3642,"key":3642,"name":"\u901f\u77f3\u9ad8\u6027\u80fd\u5e73\u53f0+\u5b58\u50a8\u65b0\u8d2d","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1140","key":"1140","contract_id":3505,"value":"31000.00","collected_date":"2024-10-08 13:59:55","created_at":"2024-10-08 13:59:55","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1885,"key":1885,"contract_id":3505,"amount":"31000","value":"31000","attachment_id":null,"from_date":"2024-09-09","description":"","is_draft":false,"is_cancel":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":28519,"object_type":103,"object_id":1885,"attachment_id":21351,"attachment":{"id":21351,"key":21351,"name":"5ae99676-0b6a-39fa-875f-babff5dac67b","extension":"pdf","path":"\/v2\/attachment\/view\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/5ae99676-0b6a-39fa-875f-babff5dac67b\/dzfp_24112000000125650570_\u5317\u4eac\u8fd0\u8054\u7cfb\u7edf\u96c6\u6210\u6709\u9650\u516c\u53f8_20240909135942.pdf","orig_name":"dzfp_24112000000125650570_\u5317\u4eac\u8fd0\u8054\u7cfb\u7edf\u96c6\u6210\u6709\u9650\u516c\u53f8_20240909135942.pdf"}}]}],"contractScans":[{"id":28254,"object_type":108,"object_id":3505,"attachment_id":21159,"attachment":{"id":21159,"key":21159,"name":"a5c20d47-b663-3260-8ed9-61dcbdc3815d","extension":"pdf","path":"\/v2\/attachment\/preview\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/a5c20d47-b663-3260-8ed9-61dcbdc3815d\/\u62d3\u5b9e\u5408\u540c20240828.pdf","orig_name":"\u62d3\u5b9e\u5408\u540c20240828.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":445,"user_id":1011,"key":1011,"contract_id":3505,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":446,"user_id":5360,"key":5360,"contract_id":3505,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":302,"key":302,"contract_id":3505,"name":"2024-09-29","value":"31000","overdue_days":9,"status":1,"remind_date":"2024-09-29","pct":100,"overdue_display":"\u903e\u671f9\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1681,"serial_no":"CGDD-20240829-00001","from_date":null,"wrote_date":"2024-08-28","handler":5360,"supplier_id":106,"purchase_contract_id":3505,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-08-29 09:24:28","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"31000.00","created_by":5360,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-08-29 09:24:28","updated_at":"2024-08-29 14:10:25","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":"31000","approve_amount":0,"un_approve_amount":31000,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"31000","un_collected":0,"collected_plan":31000,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":2800,"supplier_id":67,"contract_type":1,"signed_at":"2023-08-04","amount":"282800.00","handler":1011,"description":"\u91cd\u5e86\u4f73\u6770\u521b\u76c8\u79d1\u6280\u6709\u9650\u516c\u53f8","contract_scan":null,"created_by":1011,"created_at":"2023-08-14 09:55:04","updated_at":"2023-08-17 10:05:33","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"XM20230804000108","payment_collection_remind_ahead":"","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":"282800","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"282800","client":null,"project":null,"supplier":{"id":67,"key":67,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\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":1476,"contract_id":2800,"client_id":518,"project_id":3258,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":3258,"key":3258,"name":"\u65b0\u8d2d\u66d9\u5149\u670d\u52a1\u5668-K","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1624","key":"1624","contract_id":2800,"value":"282800.00","collected_date":"2023-08-14 09:55:04","created_at":"2023-08-14 09:55:04","created_by":1011,"description":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"pct":100}],"purchaseContractInvoices":[{"id":1417,"key":1417,"contract_id":2800,"amount":"282800.00","value":"282800.00","attachment_id":null,"from_date":"2023-08-18","description":null,"is_draft":true,"is_cancel":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":20019,"object_type":103,"object_id":1417,"attachment_id":14521,"attachment":{"id":14521,"key":14521,"name":"05d5c7d5-39c3-36bd-b966-a6b1aed55d05","extension":"pdf","path":"\/v2\/attachment\/view\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/05d5c7d5-39c3-36bd-b966-a6b1aed55d05\/2023_08_21_09_08_29.pdf","orig_name":"2023_08_21_09_08_29.pdf"}}]}],"contractScans":[{"id":19960,"object_type":108,"object_id":2800,"attachment_id":14459,"attachment":{"id":14459,"key":14459,"name":"08406a12-cfae-35fa-b5f6-6ecf7089d0aa","extension":"pdf","path":"\/v2\/attachment\/preview\/-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG\/08406a12-cfae-35fa-b5f6-6ecf7089d0aa\/\u4f73\u6770.pdf","orig_name":"\u4f73\u6770.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1259,"serial_no":"CGDD-20230814-00001","from_date":null,"wrote_date":"2023-08-04","handler":1011,"supplier_id":67,"purchase_contract_id":2800,"erp_store_id":null,"status":2,"abstract":null,"description":"\u91cd\u5e86\u4f73\u6770\u521b\u76c8\u79d1\u6280\u6709\u9650\u516c\u53f8","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-08-14 09:55:04","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"282800.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2023-08-14 09:55:04","updated_at":"2023-08-17 10:05:33","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":"282800.00","approve_amount":0,"un_approve_amount":282800,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"282800","un_collected":0,"collected_plan":0,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true}],"pagenation":{"totalcount":19,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"221.216.117.150","ua":"jinchangxiao\/2.3.151 (iPhone 12; iOS 18.6.2; Scale\/3.00)"}', FALSE, '2025-12-17 17:52:44') RETURNING "id"
17:52:43.9882.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 (4079, 3820, 3806, 3700, 3535, 3572, 3513, 3511, 3505, 2800)) GROUP BY "r"."id"
17:52:43.9212.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, 5360))
17:52:43.8942.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064
17:52:44.0221.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "purchase_contract_id" IN (4079, 3820, 3806, 3700, 3535, 3572, 3513, 3511, 3505, 2800)
17:52:43.9651.1 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft", "is_cancel" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id" IN (4079, 3820, 3806, 3700, 3535, 3572, 3513, 3511, 3505, 2800) ORDER BY "id"
17:52:44.0271.1 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4079) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
17:52:43.9911.0 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 (4079, 3820, 3806, 3700, 3535, 3572, 3513, 3511, 3505, 2800)) ORDER BY "id"
17:52:43.9191.0 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (236, 676, 59, 203, 598, 548, 632, 106, 67)
17:52:44.0360.8 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=2800) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
17:52:44.0330.8 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3513) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
17:52:43.9560.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (4079, 3820, 3806, 3700, 3535, 3572, 3513, 3511, 3505, 2800) ORDER BY "id"
17:52:44.0350.8 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3505) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
17:52:44.0340.8 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3511) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
17:52:44.0290.7 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3820) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
17:52:43.9580.7 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3258, 3737, 3642, 3772, 3788, 3935)
17:52:44.0300.7 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3700) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
17:52:44.0310.7 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3535) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
17:52:44.0290.7 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3806) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
17:52:44.0320.7 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3572) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
17:52:43.9870.6 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_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4079, 3820, 3806, 3700, 3535, 3572, 3513, 3511, 3505, 2800) ORDER BY "remind_date"
17:52:43.9850.6 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 (4079, 3820, 3806, 3700, 3535, 3572, 3513, 3511, 3505, 2800)
17:52:44.0180.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2049
17:52:44.0260.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id" IN (4079, 3820, 3806, 3700, 3535, 3572, 3513, 3511, 3505, 2800)
17:52:43.9750.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21672, 14521, 21348, 21351, 21525, 23278, 23501, 24493, 24504, 27328)
17:52:44.0170.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id" IN (4079, 3820, 3806, 3700, 3535, 3572, 3513, 3511, 3505, 2800)
17:52:43.9250.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3
17:52:44.0240.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_verify_rels" WHERE "erp_purchase_order_id" IN (1259, 1681, 1685, 1686, 1701, 1722, 1804, 1857, 1865, 2008) ORDER BY "id"
17:52:44.0220.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_products" WHERE "id"=1
17:52:44.0250.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_stop_verify_rels" WHERE "erp_purchase_order_id" IN (1259, 1681, 1685, 1686, 1701, 1722, 1804, 1857, 1865, 2008) ORDER BY "id"
17:52:44.0190.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5
17:52:44.0200.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id"=35
17:52:44.0250.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_cancel_verify_rels" WHERE "erp_purchase_order_id" IN (1259, 1681, 1685, 1686, 1701, 1722, 1804, 1857, 1865, 2008) ORDER BY "id"
17:52:44.0210.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id"=103
17:52:44.0200.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=12
17:52:43.9570.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=518
17:52:43.9800.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21674, 14459, 23115, 21159, 21161, 21427, 23378, 24482, 24492, 27290)
17:52:43.9200.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)
17:52:43.9650.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 1013, 5388, 5360)
17:52:44.0210.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2
17:52:43.9260.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)
17:52:43.9860.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)
17:52:43.9860.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, 5360))
17:52:43.9260.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, 5360))
17:52:43.9850.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=23177