ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
689bf7cc27dc2: POST https://beta.jinchangxiao.com/vue/erp-sales-order/list at 2025-08-13 10:26:20 am by 124.64.23.198

Performance Profiling

Total processing time: 92 ms; Peak memory: 5.734 MB. Show Profiling Timeline

总计37条数据
TimeDurationCategoryInfo
  
10:26:20.20819.9 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=20007) AND ("object_id" IN (912, 911, 910, 909, 908, 907, 906, 905, 904, 903, 902, 901, 900, 899, 898, 897, 896, 895, 894, 893)) GROUP BY "object_id"
10:26:20.22817.0 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=20007) AND (remind_user_id = 5016 AND is_read = false) AND ("object_id" IN (912, 911, 910, 909, 908, 907, 906, 905, 904, 903, 902, 901, 900, 899, 898, 897, 896, 895, 894, 893)) GROUP BY "object_id"
10:26:20.1814.9 msyii\db\Command::querySELECT r.* FROM "a57be577deb434"."tbl_erp_sales_orders" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_order_verify_rels" "rvr" ON rvr.erp_sales_order_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_order_products" "epop" ON epop.erp_sales_order_id = r.id LEFT JOIN "a57be577deb434"."tbl_products" "product" ON epop.product_id = product.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id WHERE ("r"."status"=2) AND (("r"."outbound_status"='0') AND (r.is_done = false)) AND (("client"."sales_rep"=5016) OR ("r"."created_by"=5016) OR ("rvr"."user_id"=5016) OR ("r"."created_by" IN (1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1025, 1026, 1027, 1028, 1029, 1030, 5015, 5016, 5022, 5023, 5024, 5025, 5026, 5027, 5028, 5029, 5030, 5031, 5032, 5033, 5037, 5043, 5044, 5045, 5047, 5048, 5049, 5050, 5062, 5063, 5064, 5065, 5066, 5069, 5070, 5071, 5072, 5073, 5074, 5075, 5076, 5078, 5079, 5080, 5081, 5082, 5083, 5085, 5086, 5087, 5088, 5089, 5093, 5094, 5095, 5096, 5101, 5102, 5104, 5105, 5123, 5124, 5125, 5126, 5128, 5135, 5203, 5208, 5209, 5229, 5230, 5247, 5248, 5249, 5250, 5252, 5258, 5259, 5293, 5294, 5295, 5296, 5297, 5298, 5299, 5300, 5301, 5302, 5303, 5304, 5305, 5309, 5311, 5329, 5332, 5333, 5351, 5356, 5357, 5358, 5359, 5360, 5364, 5388, 5393, 5404, 5409, 5411, 5412, 5413, 5419, 5420, 5440, 5445, 5446, 5448, 5449))) AND (("r"."status" != 0) OR (("r"."status"=0) AND ("r"."created_by"=5016))) GROUP BY "r"."id" ORDER BY "r"."updated_at" DESC LIMIT 20 OFFSET 60
10:26:20.2474.9 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5016, 5, 'vue/erp-sales-order/list', '{"Filter":{"name":"updated_at","sort":"DESC"},"ErpSalesOrderSearch":{"wrote_date_period":"","from_date_period":"","status":"","outbound_status":"0","handler":"","created_by":"","number_range_to":"","number_range_from":"","amount_range_to":"","amount_range_from":""},"page":"4","web_access_token":"sfV9klrLTktQI4MbYaQCZfnxDwGMxUBc"}', '{"code":2000,"result":{"list":[{"id":912,"serial_no":"XSDD-20221103-00001","from_date":"","wrote_date":"2022-09-29","handler":5295,"client_id":1301,"purchase_contract_id":"","project_id":2974,"sales_contract_id":2423,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-09-26 16:31:22","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"242364","created_by":5295,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-09-26 16:31:22","updated_at":"2022-09-26 16:31:22","createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"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)"},"project":{"id":2974,"key":2974,"name":"\u670d\u52a1\u5668\u65b0\u8d2d"},"salesContract":{"id":2423,"key":2423,"name":"DW2022-XXH001","contractScans":[{"id":25349,"object_type":105,"object_id":2423,"attachment_id":11144,"attachment":{"id":11144,"key":11144,"name":"5af8d3c3-6f7b-3369-a40e-28a76c1ace40","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/10\/","orig_name":"2022_10_08_14_04_04.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":911,"serial_no":"XSDD-20221128-00001","from_date":"","wrote_date":"2022-09-19","handler":1005,"client_id":1492,"purchase_contract_id":"","project_id":2994,"sales_contract_id":2422,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u601d\u79d1\u670d\u52a1\u5668\u7528\u768432G\u5185\u5b58\uff0c32\u6839","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-09-25 23:07:19","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"32000","created_by":1005,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-09-25 23:07:19","updated_at":"2022-09-25 23:07:19","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":1492,"key":1492,"name":"\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u751f\u7269\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\u6709\u9650\u516c\u53f8)"},"project":{"id":2994,"key":2994,"name":"\u601d\u79d1\u670d\u52a1\u5668\u7528\u5185\u5b58"},"salesContract":{"id":2422,"key":2422,"name":"TS-ZHY-2022091902","contractScans":[{"id":16463,"object_type":105,"object_id":2422,"attachment_id":11103,"attachment":{"id":11103,"key":11103,"name":"0f1c896d-94d5-3e9e-a996-7280229e90cb","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/09\/","orig_name":"2022_09_26_11_33_02.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":910,"serial_no":"XSDD-20221012-00001","from_date":"","wrote_date":"2022-09-13","handler":1001,"client_id":2205,"purchase_contract_id":"","project_id":2894,"sales_contract_id":2419,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"PA3220\u9632\u706b\u5899\u8bbe\u5907\u4e00\u5e74\u7ef4\u4fdd\uff1b\u5305\u542bTP\/\u786c\u4ef6\u4e00\u5e74\u4fdd","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-09-23 09:49:48","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"117825","created_by":1001,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-09-23 09:49:48","updated_at":"2022-09-23 09:49:48","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"client":{"id":2205,"key":2205,"name":"\u5317\u4eac\u6613\u8f66\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":2894,"key":2894,"name":"PA3220\u9632\u706b\u5899\u4e00\u5e74\u7eed\u4fdd\u670d\u52a1"},"salesContract":{"id":2419,"key":2419,"name":"TSKJ-HYF-2022091302","contractScans":[{"id":16228,"object_type":105,"object_id":2419,"attachment_id":11088,"attachment":{"id":11088,"key":11088,"name":"3d5f7511-b3f8-35b4-b1c0-ef7de8c546ee","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/09\/","orig_name":"\u6613\u8f66-\u5408\u540c.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":909,"serial_no":"XSDD-20220916-00001","from_date":"","wrote_date":"2022-09-14","handler":5295,"client_id":2032,"purchase_contract_id":"","project_id":2972,"sales_contract_id":2413,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u7fa4\u6656\u5b58\u50a8","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-09-15 11:14:23","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"84950","created_by":5295,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-09-15 11:14:23","updated_at":"2022-09-15 11:14:23","createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8)"},"project":{"id":2972,"key":2972,"name":"\u5b58\u50a8\u65b0\u8d2d"},"salesContract":{"id":2413,"key":2413,"name":"TS-WZW-2022091426","contractScans":[{"id":16234,"object_type":105,"object_id":2413,"attachment_id":11102,"attachment":{"id":11102,"key":11102,"name":"7e4c62f6-ed53-300e-9068-5a6f118bf082","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/09\/","orig_name":"\u7075\u72d0\u5408\u540c.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":908,"serial_no":"XSDD-20220919-00001","from_date":"","wrote_date":"2022-08-30","handler":5295,"client_id":16,"purchase_contract_id":"","project_id":2986,"sales_contract_id":2410,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u62d3\u5b9e\u670d\u52a1\u4e09\u6b21","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-09-14 12:10:03","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"1000","created_by":5295,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-09-14 12:10:03","updated_at":"2022-09-14 12:10:03","createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":16,"key":16,"name":"\u5317\u4eac\u6e38\u5b66\u7f51\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"project":{"id":2986,"key":2986,"name":"\u62d3\u5b9e\u6280\u672f\u670d\u52a12022"},"salesContract":{"id":2410,"key":2410,"name":"TSKJ20220830-WZW-002","contractScans":[{"id":16242,"object_type":105,"object_id":2410,"attachment_id":11145,"attachment":{"id":11145,"key":11145,"name":"1ed1367e-12cf-395a-8d3e-a7e20145de8b","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/10\/","orig_name":"2022_10_09_09_46_26.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":907,"serial_no":"XSDD-20220930-00001","from_date":"","wrote_date":"2022-09-13","handler":5295,"client_id":90,"purchase_contract_id":"","project_id":2984,"sales_contract_id":2409,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-09-13 15:39:23","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"26808","created_by":5295,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-09-13 15:39:23","updated_at":"2022-09-13 15:39:23","createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":{"id":2984,"key":2984,"name":"\u7f51\u7edc\u4ea7\u54c1\u7eed\u4fdd5"},"salesContract":{"id":2409,"key":2409,"name":"TS-WZW-20211001\u8865\u5145\u534f\u8bae-1","contractScans":[{"id":17107,"object_type":105,"object_id":2409,"attachment_id":10973,"attachment":{"id":10973,"key":10973,"name":"5030a9d3-a074-3192-b822-11fa3d3b80bc","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/09\/","orig_name":"2022_09_13_15_37_22.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":906,"serial_no":"XSDD-20220909-00001","from_date":"","wrote_date":"2022-09-05","handler":5300,"client_id":1196,"purchase_contract_id":"","project_id":2978,"sales_contract_id":2407,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"AC\u7eed\u4fdd\uff0cURL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea71\u5957\uff0c\u4ea7\u54c1\u8d28\u4fdd\u4e00\u5e74\uff0c\u8f6f\u4ef6\u5347\u7ea7\u4e00\u5e74\u3002","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-09-09 15:07:26","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"1848","created_by":5300,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-09-09 15:07:26","updated_at":"2022-09-09 15:07:26","createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":1196,"key":1196,"name":"\u5317\u4eac\u536b\u4fe1\u6770\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"project":{"id":2978,"key":2978,"name":"AC\u7eed\u4fdd-2022\u5e74"},"salesContract":{"id":2407,"key":2407,"name":"TS-SQY-2022090501","contractScans":[{"id":16230,"object_type":105,"object_id":2407,"attachment_id":10936,"attachment":{"id":10936,"key":10936,"name":"9a5d1f8a-8f04-3e45-a35e-04ac978f8848","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/09\/","orig_name":"1.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":905,"serial_no":"XSDD-20221111-00001","from_date":"","wrote_date":"2022-08-10","handler":1004,"client_id":286,"purchase_contract_id":"","project_id":2980,"sales_contract_id":2401,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u601d\u79d1\u4ea4\u6362\u673a\u6a21\u5757*4\uff0c\u6536\u53d1\u5668*4","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-09-08 15:44:25","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"5076","created_by":1004,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-09-08 15:44:25","updated_at":"2022-09-08 15:44:25","createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":286,"key":286,"name":"\u5609\u91cc\u5927\u901a\u7269\u6d41\u6709\u9650\u516c\u53f8(\u5929\u6d25\u5609\u901a\u7269\u6d41\u6709\u9650\u516c\u53f8)"},"project":{"id":2980,"key":2980,"name":"\u4ea4\u6362\u6a21\u5757\u6269\u5bb9"},"salesContract":{"id":2401,"key":2401,"name":"TS-YJC-20220810","contractScans":[{"id":16502,"object_type":105,"object_id":2401,"attachment_id":11379,"attachment":{"id":11379,"key":11379,"name":"9f86676e-e07f-35a5-8f1e-2c621cdcc334","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/11\/","orig_name":"2022_11_09_17_01_36.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":904,"serial_no":"XSDD-20221024-00001","from_date":"","wrote_date":"2022-09-08","handler":5329,"client_id":2220,"purchase_contract_id":"","project_id":2941,"sales_contract_id":2400,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u6269\u5c554g\u5185\u5b58","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-09-08 14:27:53","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"2700","created_by":5329,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-09-08 14:27:53","updated_at":"2022-09-08 14:27:53","createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":2220,"key":2220,"name":"\u5317\u4eac\u529b\u901a\u901a\u4fe1\u6709\u9650\u516c\u53f8"},"project":{"id":2941,"key":2941,"name":"\u7fa4\u6656ds918\u6269\u5c55\u5185\u5b58"},"salesContract":{"id":2400,"key":2400,"name":"TS-GZ-2022090875","contractScans":[{"id":16227,"object_type":105,"object_id":2400,"attachment_id":10981,"attachment":{"id":10981,"key":10981,"name":"8b7c5d57-6d17-37e7-95a2-874befdb7eee","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/09\/","orig_name":"2022_09_14_14_11_06.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":903,"serial_no":"XSDD-20230210-00001","from_date":"","wrote_date":"2022-08-26","handler":1005,"client_id":57,"purchase_contract_id":"","project_id":2977,"sales_contract_id":2399,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"HP SAS 15K 300GB 627195-001 ","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-09-08 11:10:23","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"700","created_by":1005,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-09-08 11:10:23","updated_at":"2022-09-08 11:10:23","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"project":{"id":2977,"key":2977,"name":"PO#20220822002\u670d\u52a1\u5668\u574f\u76d8\u66f4\u6362"},"salesContract":{"id":2399,"key":2399,"name":"PO#20220822002","contractScans":[{"id":16240,"object_type":105,"object_id":2399,"attachment_id":10925,"attachment":{"id":10925,"key":10925,"name":"fe28cb41-5231-379b-a361-116e594893c2","extension":"png","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/09\/","orig_name":"\u5c4f\u5e55\u5feb\u7167 2022-09-08 \u4e0b\u53482.39.55.png"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":902,"serial_no":"XSDD-20221014-00001","from_date":"","wrote_date":"2022-09-01","handler":5295,"client_id":528,"purchase_contract_id":"","project_id":2973,"sales_contract_id":2397,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u670d\u52a1\u5668\u786c\u76d8\u5185\u5b58","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-09-06 15:35:06","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"6550","created_by":5295,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-09-06 15:35:06","updated_at":"2022-09-06 15:35:06","createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":528,"key":528,"name":"\u5317\u4eac\u8bfa\u8bda\u5065\u534e\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8(\u5357\u4eac\u5929\u5370\u5065\u534e\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8;\u5317\u4eac\u5929\u8bda\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8;\u5317\u4eac\u6c47\u8bda\u5065\u534e)"},"project":{"id":2973,"key":2973,"name":"\u786c\u76d8\u65b0\u8d2d"},"salesContract":{"id":2397,"key":2397,"name":"P2022071849","contractScans":[{"id":16232,"object_type":105,"object_id":2397,"attachment_id":10912,"attachment":{"id":10912,"key":10912,"name":"08cc6d80-cf12-3b30-a8ff-0da0bd1c8861","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/09\/","orig_name":"HP \u5185\u5b58\u3001\u786c\u76d8 \u8ba2\u5355 to \u62d3\u5b9e 20220901.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":901,"serial_no":"XSDD-20220916-00001","from_date":"","wrote_date":"2022-08-16","handler":5295,"client_id":498,"purchase_contract_id":"","project_id":2922,"sales_contract_id":2395,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"2\u53f0PA3220\u7eed\u4fdd","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-09-02 11:18:09","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"199000","created_by":5295,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-09-02 11:18:09","updated_at":"2022-09-02 11:18:09","createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":498,"key":498,"name":"\u7231\u6155\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"project":{"id":2922,"key":2922,"name":"PA\u4ea7\u54c1\u7eed\u4fdd"},"salesContract":{"id":2395,"key":2395,"name":"TS-WZW-2022081639","contractScans":[{"id":16231,"object_type":105,"object_id":2395,"attachment_id":10907,"attachment":{"id":10907,"key":10907,"name":"17076af5-4c42-342c-9e95-fe2e3d68a7fa","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/09\/","orig_name":"PA\u5408\u540c-\u7231\u6155\u80a1\u4efd\u201420220823.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":900,"serial_no":"XSDD-20230113-00001","from_date":"","wrote_date":"2022-08-15","handler":1005,"client_id":57,"purchase_contract_id":"","project_id":2960,"sales_contract_id":2388,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"PA 820 \u7eed\u4fdd","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-08-28 21:56:51","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"65750","created_by":1005,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-08-28 21:56:51","updated_at":"2022-08-28 21:56:51","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"project":{"id":2960,"key":2960,"name":"\u4fdd\u8bfaPA820\u7eed\u4fddSN:012001019832&012001019838"},"salesContract":{"id":2388,"key":2388,"name":"PO#20220815040-042","contractScans":[{"id":15994,"object_type":105,"object_id":2388,"attachment_id":10892,"attachment":{"id":10892,"key":10892,"name":"635cc73b-a5a8-35b6-aea6-5153ce5ea358","extension":"jpg","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/09\/","orig_name":"11181661995924_.pic.jpg"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":899,"serial_no":"XSDD-20230112-00001","from_date":"","wrote_date":"2022-08-08","handler":1005,"client_id":57,"purchase_contract_id":"","project_id":2899,"sales_contract_id":2387,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"PA 820\u7eed\u4fdd","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-08-28 21:53:40","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"32875","created_by":1005,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-08-28 21:53:40","updated_at":"2022-08-28 21:53:40","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"project":{"id":2899,"key":2899,"name":"\u4e0a\u6d77\u6da6\u8bfaPA-820\u7eed\u4fdd\u670d\u52a1SN:012001019836"},"salesContract":{"id":2387,"key":2387,"name":"PO#20220808001","contractScans":[{"id":15995,"object_type":105,"object_id":2387,"attachment_id":10894,"attachment":{"id":10894,"key":10894,"name":"ffce9462-e5f0-3ed2-888b-6fec8ae45809","extension":"jpg","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/09\/","orig_name":"11201661996601_.pic.jpg"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":898,"serial_no":"XSDD-20220913-00001","from_date":"","wrote_date":"2022-07-14","handler":1004,"client_id":2230,"purchase_contract_id":"","project_id":2959,"sales_contract_id":2386,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u89c6\u9891\u4f1a\u8bae\u5ba4\uff1a\u6295\u5f71\u673a\u3001\u5e55\u5e03\u3001\u5e73\u677f\u7535\u89c6\u3001\u97f3\u7bb1\u3001\u6444\u50cf\u5934\u7b49","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-08-28 09:29:42","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"64090","created_by":1004,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-08-28 09:29:42","updated_at":"2022-08-28 09:29:42","createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":2230,"key":2230,"name":"\u8d75\u4e9a\u8fd0\u5c0f\u5de5\u7a0b\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"project":{"id":2959,"key":2959,"name":"\u89c6\u9891\u4f1a\u8bae"},"salesContract":{"id":2386,"key":2386,"name":"TS-YJC-20220714","contractScans":[{"id":16237,"object_type":105,"object_id":2386,"attachment_id":10982,"attachment":{"id":10982,"key":10982,"name":"f797ecf1-c57b-3655-a953-e61b5f1d81b3","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/09\/","orig_name":"2022_09_08_14_22_16.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":897,"serial_no":"XSDD-20221024-00001","from_date":"","wrote_date":"2022-08-22","handler":5295,"client_id":2118,"purchase_contract_id":"","project_id":2708,"sales_contract_id":2385,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u7fa4\u6656\u5b58\u50a8","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-08-26 17:18:27","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"49892","created_by":5295,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-08-26 17:18:27","updated_at":"2022-08-26 17:18:27","createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":2118,"key":2118,"name":"\u5317\u4eac\u65f6\u533b\u5eb7\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8(\u5317\u4eac\u533b\u89c6\u65f6\u4ee3\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8 )"},"project":{"id":2708,"key":2708,"name":"\u5b58\u50a8\u5347\u7ea7"},"salesContract":{"id":2385,"key":2385,"name":"TS-WZW-2022082205","contractScans":[{"id":16226,"object_type":105,"object_id":2385,"attachment_id":11023,"attachment":{"id":11023,"key":11023,"name":"cf78dc19-f9c9-3ffb-87fe-0f2596afe55f","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/09\/","orig_name":"2022_09_16_10_13_28.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":896,"serial_no":"XSDD-20230130-00001","from_date":"","wrote_date":"2022-08-23","handler":5295,"client_id":2221,"purchase_contract_id":"","project_id":2957,"sales_contract_id":2384,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-08-25 09:31:14","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"29779","created_by":5295,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-08-25 09:31:14","updated_at":"2022-08-25 09:31:14","createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":2221,"key":2221,"name":"(\u8fc7\u5355)\u4e2d\u5efa\u65b0\u79d1\u88c5\u9970\u5de5\u7a0b\u6709\u9650\u516c\u53f8"},"project":{"id":2957,"key":2957,"name":"\u65b0\u8d2d\u9632\u706b\u5899"},"salesContract":{"id":2384,"key":2384,"name":"TSKJ-WZW-2022080805","contractScans":[{"id":16233,"object_type":105,"object_id":2384,"attachment_id":10890,"attachment":{"id":10890,"key":10890,"name":"491e32d8-6750-319c-9691-41d1991c7112","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/09\/","orig_name":"2022_09_01_09_23_43.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":895,"serial_no":"XSDD-20220920-00001","from_date":"","wrote_date":"2022-07-20","handler":1005,"client_id":2226,"purchase_contract_id":"","project_id":2950,"sales_contract_id":2379,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u6df1\u4fe1\u670dEDR1\u5e74\u7eed\u4fdd\n","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-08-19 10:42:06","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"50000","created_by":1005,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-08-19 10:42:06","updated_at":"2022-08-19 10:42:06","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":2226,"key":2226,"name":"\u5317\u4eac\u767e\u8fbe\u4fe1\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"project":{"id":2950,"key":2950,"name":"\u6df1\u4fe1\u670dEDR1\u5e74\u7eed\u4fdd"},"salesContract":{"id":2379,"key":2379,"name":"TS-ZHY-2022072001","contractScans":[{"id":15966,"object_type":105,"object_id":2379,"attachment_id":10832,"attachment":{"id":10832,"key":10832,"name":"3d2a9c76-cefd-3159-b5ff-5e1bcdf76bbd","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/08\/","orig_name":"\u767e\u8fbe\u4fe1\u901a\u201420220720.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":894,"serial_no":"XSDD-20220825-00001","from_date":"","wrote_date":"2022-08-18","handler":5295,"client_id":2225,"purchase_contract_id":"","project_id":2949,"sales_contract_id":2377,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u786c\u76d82\u5757","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-08-18 14:36:15","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"1800","created_by":5295,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-08-18 14:36:15","updated_at":"2022-08-18 14:36:15","createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":2225,"key":2225,"name":"\u5317\u4eac\u7f8e\u6377\u7f8e\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":2949,"key":2949,"name":"NETAPP\u786c\u76d8\u914d\u4ef6"},"salesContract":{"id":2377,"key":2377,"name":"TS-WZW-2022081873","contractScans":[{"id":15957,"object_type":105,"object_id":2377,"attachment_id":10825,"attachment":{"id":10825,"key":10825,"name":"35d6c969-318e-3f82-9af3-c45ec15db402","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/08\/","orig_name":"\u7f8e\u6377\u7f8e\u201420220818_\u5df2\u7b7e\u7ae0.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true},{"id":893,"serial_no":"XSDD-20220825-00001","from_date":"","wrote_date":"2022-08-16","handler":5295,"client_id":2032,"purchase_contract_id":"","project_id":2947,"sales_contract_id":2376,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u6df1\u4fe1\u670d\u7eed\u4fdd","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-08-17 09:37:15","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"21049","created_by":5295,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-08-17 09:37:15","updated_at":"2022-08-17 09:37:15","createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8)"},"project":{"id":2947,"key":2947,"name":"\u6df1\u4fe1\u670dAC\u7eed\u4fdd2022"},"salesContract":{"id":2376,"key":2376,"name":"TS-WZW-2022081622","contractScans":[{"id":15958,"object_type":105,"object_id":2376,"attachment_id":10851,"attachment":{"id":10851,"key":10851,"name":"95ca473a-742a-330f-863c-18a78be2c2ea","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/08\/","orig_name":"2022_08_22_17_22_54.pdf"}}]},"erpSalesOrderCarbonCopyRels":[],"erpSalesOrderVerifyRels":[],"lastErpSalesOrderVerifyRel":{},"haveErpSalesOrderVerifyRel":{},"selfErpSalesOrderVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{},"erpSendType":"","erpSalesOrderProducts":[],"erpSalesOrderStopVerifyRels":[],"lastErpSalesOrderStopVerifyRel":"","haveErpSalesOrderStopVerifyRel":"","selfErpSalesOrderStopVerifyRel":"","erpSalesOrderStopProducts":[],"erpSalesOrderCancelVerifyRels":[],"lastErpSalesOrderCancelVerifyRel":"","haveErpSalesOrderCancelVerifyRel":"","selfErpSalesOrderCancelVerifyRel":"","commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_stop_verify":false,"can_stop_refuse":false,"can_cancel":true,"can_cancel_verify":false,"can_cancel_refuse":false,"can_done":true,"can_cancel_done":false,"can_create_erp_sales_outbound":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true}],"can_create":true,"pagenation":{"totalcount":971,"thispage":4,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-13 10:26:20') RETURNING "id"
10:26:20.1764.8 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT r.* FROM "a57be577deb434"."tbl_erp_sales_orders" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_order_verify_rels" "rvr" ON rvr.erp_sales_order_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_order_products" "epop" ON epop.erp_sales_order_id = r.id LEFT JOIN "a57be577deb434"."tbl_products" "product" ON epop.product_id = product.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id WHERE ("r"."status"=2) AND (("r"."outbound_status"='0') AND (r.is_done = false)) AND (("client"."sales_rep"=5016) OR ("r"."created_by"=5016) OR ("rvr"."user_id"=5016) OR ("r"."created_by" IN (1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1025, 1026, 1027, 1028, 1029, 1030, 5015, 5016, 5022, 5023, 5024, 5025, 5026, 5027, 5028, 5029, 5030, 5031, 5032, 5033, 5037, 5043, 5044, 5045, 5047, 5048, 5049, 5050, 5062, 5063, 5064, 5065, 5066, 5069, 5070, 5071, 5072, 5073, 5074, 5075, 5076, 5078, 5079, 5080, 5081, 5082, 5083, 5085, 5086, 5087, 5088, 5089, 5093, 5094, 5095, 5096, 5101, 5102, 5104, 5105, 5123, 5124, 5125, 5126, 5128, 5135, 5203, 5208, 5209, 5229, 5230, 5247, 5248, 5249, 5250, 5252, 5258, 5259, 5293, 5294, 5295, 5296, 5297, 5298, 5299, 5300, 5301, 5302, 5303, 5304, 5305, 5309, 5311, 5329, 5332, 5333, 5351, 5356, 5357, 5358, 5359, 5360, 5364, 5388, 5393, 5404, 5409, 5411, 5412, 5413, 5419, 5420, 5440, 5445, 5446, 5448, 5449))) AND (("r"."status" != 0) OR (("r"."status"=0) AND ("r"."created_by"=5016))) GROUP BY "r"."id" ORDER BY "r"."updated_at" DESC) "c"
10:26:20.1952.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (10825, 10851, 10832, 10892, 10894, 11023, 10981, 11088, 10936, 10907, 10912, 10890, 11102, 10982, 10925, 11145, 11103, 11379, 10973, 11144)
10:26:20.1922.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (2387, 2422, 2376, 2399, 2388, 2419, 2407, 2377, 2397, 2395, 2409, 2385, 2400, 2384, 2410, 2423, 2386, 2413, 2401, 2379))
10:26:20.1662.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5016
10:26:20.1641.8 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:26:20.2001.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20011) AND ("object_id" IN (912, 911, 910, 909, 908, 907, 906, 905, 904, 903, 902, 901, 900, 899, 898, 897, 896, 895, 894, 893))
10:26:20.2011.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20012) AND ("object_id" IN (912, 911, 910, 909, 908, 907, 906, 905, 904, 903, 902, 901, 900, 899, 898, 897, 896, 895, 894, 893))
10:26:20.1691.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016
10:26:20.1911.0 msyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" AS "name" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (2423, 2422, 2419, 2413, 2410, 2409, 2407, 2401, 2400, 2399, 2397, 2395, 2388, 2387, 2386, 2385, 2384, 2379, 2377, 2376)
10:26:20.1900.8 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (2974, 2994, 2894, 2972, 2986, 2984, 2978, 2980, 2941, 2977, 2973, 2922, 2960, 2899, 2959, 2708, 2957, 2950, 2949, 2947)
10:26:20.1870.8 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 5329, 1005, 1004, 5300))
10:26:20.2030.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id" IN (912, 911, 910, 909, 908, 907, 906, 905, 904, 903, 902, 901, 900, 899, 898, 897, 896, 895, 894, 893)
10:26:20.1750.6 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" ORDER BY "id"
10:26:20.2060.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id" IN (912, 911, 910, 909, 908, 907, 906, 905, 904, 903, 902, 901, 900, 899, 898, 897, 896, 895, 894, 893)
10:26:20.1880.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1)
10:26:20.1900.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (1301, 1492, 2205, 2032, 16, 90, 1196, 286, 2220, 57, 528, 498, 2230, 2118, 2221, 2226, 2225)
10:26:20.1870.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 1005, 1001, 5300, 1004, 5329)
10:26:20.2040.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (912, 911, 910, 909, 908, 907, 906, 905, 904, 903, 902, 901, 900, 899, 898, 897, 896, 895, 894, 893) ORDER BY "id"
10:26:20.1980.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_carbon_copy_rels" WHERE "erp_sales_order_id" IN (912, 911, 910, 909, 908, 907, 906, 905, 904, 903, 902, 901, 900, 899, 898, 897, 896, 895, 894, 893)
10:26:20.2060.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE "erp_sales_order_id" IN (912, 911, 910, 909, 908, 907, 906, 905, 904, 903, 902, 901, 900, 899, 898, 897, 896, 895, 894, 893) ORDER BY "id"
10:26:20.1990.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE ("status" != 0) AND ("erp_sales_order_id" IN (912, 911, 910, 909, 908, 907, 906, 905, 904, 903, 902, 901, 900, 899, 898, 897, 896, 895, 894, 893)) ORDER BY "id"
10:26:20.2050.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("status" = 0) AND ("user_id"=5016) AND ("erp_sales_order_id" IN (912, 911, 910, 909, 908, 907, 906, 905, 904, 903, 902, 901, 900, 899, 898, 897, 896, 895, 894, 893))
10:26:20.1890.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 1005, 1001, 5300, 1004, 5329)
10:26:20.2050.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id" IN (912, 911, 910, 909, 908, 907, 906, 905, 904, 903, 902, 901, 900, 899, 898, 897, 896, 895, 894, 893)) ORDER BY "id"
10:26:20.1990.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id" IN (912, 911, 910, 909, 908, 907, 906, 905, 904, 903, 902, 901, 900, 899, 898, 897, 896, 895, 894, 893)) ORDER BY "id"
10:26:20.1890.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 (1001, 5295, 5329, 1005, 1004, 5300))
10:26:20.2070.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id" IN (912, 911, 910, 909, 908, 907, 906, 905, 904, 903, 902, 901, 900, 899, 898, 897, 896, 895, 894, 893)) ORDER BY "id"
10:26:20.1980.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (912, 911, 910, 909, 908, 907, 906, 905, 904, 903, 902, 901, 900, 899, 898, 897, 896, 895, 894, 893) ORDER BY "id"
10:26:20.2070.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("status" = 0) AND ("user_id"=5016) AND ("erp_sales_order_id" IN (912, 911, 910, 909, 908, 907, 906, 905, 904, 903, 902, 901, 900, 899, 898, 897, 896, 895, 894, 893))
10:26:20.2050.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("status" != 0) AND ("erp_sales_order_id" IN (912, 911, 910, 909, 908, 907, 906, 905, 904, 903, 902, 901, 900, 899, 898, 897, 896, 895, 894, 893)) ORDER BY "id"
10:26:20.2070.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("status" != 0) AND ("erp_sales_order_id" IN (912, 911, 910, 909, 908, 907, 906, 905, 904, 903, 902, 901, 900, 899, 898, 897, 896, 895, 894, 893)) ORDER BY "id"
10:26:20.1990.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE ("status" = 0) AND ("user_id"=5016) AND ("erp_sales_order_id" IN (912, 911, 910, 909, 908, 907, 906, 905, 904, 903, 902, 901, 900, 899, 898, 897, 896, 895, 894, 893))
10:26:20.1890.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1)