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

Performance Profiling

Total processing time: 104 ms; Peak memory: 5.735 MB. Show Profiling Timeline

总计37条数据
TimeDurationCategoryInfo
  
10:26:22.83025.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 (892, 891, 890, 889, 888, 887, 886, 885, 884, 883, 882, 881, 880, 879, 878, 877, 876, 875, 874, 873)) GROUP BY "object_id"
10:26:22.81019.9 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=20007) AND ("object_id" IN (892, 891, 890, 889, 888, 887, 886, 885, 884, 883, 882, 881, 880, 879, 878, 877, 876, 875, 874, 873)) GROUP BY "object_id"
10:26:22.7825.0 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 80
10:26:22.7764.9 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:22.8603.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":"5","web_access_token":"sfV9klrLTktQI4MbYaQCZfnxDwGMxUBc"}', '{"code":2000,"result":{"list":[{"id":892,"serial_no":"XSDD-20221010-00001","from_date":"","wrote_date":"2022-08-03","handler":5300,"client_id":1886,"purchase_contract_id":"","project_id":2933,"sales_contract_id":2375,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"AC-1000-D420-TS\n\u4ea7\u54c1\u8d28\u4fdd+URL\u5e93\u5347\u7ea7 1\u5e74","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-08-15 17:07:08","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"5850","created_by":5300,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-08-15 17:07:08","updated_at":"2022-08-15 17:07:08","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":1886,"key":1886,"name":"\u5317\u4eac\u534e\u76ca\u5065\u5eb7\u836f\u7269\u7814\u7a76\u4e2d\u5fc3(\u5168\u7403\u5065\u5eb7\u836f\u7269\u7814\u53d1\u4e2d\u5fc3)(\u4e9a\u4fe1)"},"project":{"id":2933,"key":2933,"name":"AC\u7eed\u4fdd-1\u5e74-2022"},"salesContract":{"id":2375,"key":2375,"name":"TS-SQY-2022080201","contractScans":[{"id":15953,"object_type":105,"object_id":2375,"attachment_id":10812,"attachment":{"id":10812,"key":10812,"name":"6caf5f3e-3bc7-315b-ae03-a2b0a1c9a84c","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/08\/","orig_name":"2022_08_16_10_20_49.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":891,"serial_no":"XSDD-20220825-00001","from_date":"","wrote_date":"2022-08-01","handler":5295,"client_id":121,"purchase_contract_id":"","project_id":2888,"sales_contract_id":2371,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"PA\u7eed\u4fdd","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-08-08 10:16:13","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"158120","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-08 10:16:13","updated_at":"2022-08-08 10:16:13","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":121,"key":121,"name":"\u56db\u5ddd\u6d77\u5e95\u635e\u9910\u996e\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u9890\u6d77(\u4e0a\u6d77)\u98df\u54c1\u6709\u9650\u516c\u53f8\u3001\u6d77\u9e3f\u8fbe\u3001\u90d1\u5dde\u8700\u6d77)"},"project":{"id":2888,"key":2888,"name":"2022PA\u7eed\u4fdd"},"salesContract":{"id":2371,"key":2371,"name":"TS-WZW-2022080125","contractScans":[{"id":15956,"object_type":105,"object_id":2371,"attachment_id":10770,"attachment":{"id":10770,"key":10770,"name":"c791d957-bef4-3554-832e-9003a804299b","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/08\/","orig_name":"e1a8205b-8bef-37fe-8667-45fe4d2a42a0.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":890,"serial_no":"XSDD-20220811-00001","from_date":"","wrote_date":"2022-08-05","handler":5295,"client_id":1301,"purchase_contract_id":"","project_id":2936,"sales_contract_id":2370,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u786c\u76d81\u5757","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-08-05 17:21:06","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"650","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-05 17:21:06","updated_at":"2022-08-05 17:21: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":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":2936,"key":2936,"name":"\u786c\u76d8\u65b0\u8d2d"},"salesContract":{"id":2370,"key":2370,"name":"TS-WZW-2022080562","contractScans":[{"id":15959,"object_type":105,"object_id":2370,"attachment_id":10813,"attachment":{"id":10813,"key":10813,"name":"765ae7d5-13ba-31aa-92e0-9eeed540d198","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/08\/","orig_name":"2022_08_16_11_41_52.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":889,"serial_no":"XSDD-20230210-00001","from_date":"","wrote_date":"2022-08-03","handler":1005,"client_id":57,"purchase_contract_id":"","project_id":2895,"sales_contract_id":2369,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u65b0\u697c\u6539\u9020\uff0c\u4ebf\u8054\u8bed\u97f3\u8bbe\u5907","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-08-05 17:20:04","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"118800","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-05 17:20:04","updated_at":"2022-08-05 17:20:04","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":2895,"key":2895,"name":"\u5317\u4eac\u65b0\u529e\u516c\u533a\u8bed\u97f3\u8bbe\u5907\u65b0\u5efa"},"salesContract":{"id":2369,"key":2369,"name":"PO#20220718046","contractScans":[{"id":15965,"object_type":105,"object_id":2369,"attachment_id":10744,"attachment":{"id":10744,"key":10744,"name":"875af3ca-90be-353f-b403-cab393e4449d","extension":"png","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/08\/","orig_name":"\u5c4f\u5e55\u5feb\u7167 2022-08-05 \u4e0b\u53485.30.39.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":888,"serial_no":"XSDD-20230206-00001","from_date":"","wrote_date":"2022-08-01","handler":1005,"client_id":57,"purchase_contract_id":"","project_id":2805,"sales_contract_id":2368,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u5317\u4eac\uff0c\u4e0a\u6d77\uff0c\u77f3\u5bb6\u5e84\uff0c\u65e0\u9521\uff0c\u7f51\u7edc\u5b9e\u65bd\u4eba\u5de5\u670d\u52a1","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-08-05 17:18:30","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"75700","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-05 17:18:30","updated_at":"2022-08-05 17:18:30","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":2805,"key":2805,"name":"\u5404\u5206\u516c\u53f8\u7f51\u7edc\u5b9e\u65bd\u670d\u52a1"},"salesContract":{"id":2368,"key":2368,"name":"PO#20220722050","contractScans":[{"id":16467,"object_type":105,"object_id":2368,"attachment_id":10746,"attachment":{"id":10746,"key":10746,"name":"2b3b945f-0124-3947-9778-587710f728fb","extension":"png","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/08\/","orig_name":"\u5c4f\u5e55\u5feb\u7167 2022-08-05 \u4e0b\u53485.30.20.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":887,"serial_no":"XSDD-20230814-00001","from_date":"","wrote_date":"2022-07-29","handler":5300,"client_id":2202,"purchase_contract_id":"","project_id":2904,"sales_contract_id":2367,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u601d\u79d1\u65e0\u7ebfAp 3\u4e2a\u70b9\u4f4d+\u65bd\u5de5","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-08-04 16:32:31","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"35870","created_by":5300,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-08-04 16:32:31","updated_at":"2022-08-04 16:32:31","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":2202,"key":2202,"name":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u4e50\u6210\u5b66\u6821\uff08\u5317\u4eac\u5e02\u671d\u9633\u533a\u4e50\u6210\u5e7c\u513f\u56ed\uff09"},"project":{"id":2904,"key":2904,"name":"\u601d\u79d1AP-2022-G"},"salesContract":{"id":2367,"key":2367,"name":"TS-SQY-2022072901","contractScans":[{"id":16229,"object_type":105,"object_id":2367,"attachment_id":10740,"attachment":{"id":10740,"key":10740,"name":"1f12e5a1-d6ae-378e-b321-676a7f236315","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/08\/","orig_name":"\u4e50\u6210\u56fd\u9645\u5b66\u6821.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":886,"serial_no":"XSDD-20220825-00001","from_date":"","wrote_date":"2022-07-05","handler":5295,"client_id":90,"purchase_contract_id":"","project_id":2887,"sales_contract_id":2361,"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-01 11:19:47","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"83000","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-01 11:19:47","updated_at":"2022-08-01 11:19:47","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":2887,"key":2887,"name":"\u5b58\u50a8\u6269\u5bb92750"},"salesContract":{"id":2361,"key":2361,"name":"TS-WZW-2022070538","contractScans":[{"id":15960,"object_type":105,"object_id":2361,"attachment_id":10704,"attachment":{"id":10704,"key":10704,"name":"7a35397c-d244-36c8-b57f-bed58ed9c726","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/08\/","orig_name":"2022_08_01_11_11_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":885,"serial_no":"XSDD-20230130-00001","from_date":"","wrote_date":"2022-07-31","handler":5087,"client_id":2128,"purchase_contract_id":"","project_id":2882,"sales_contract_id":2358,"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-01 05:31:01","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"590000","created_by":5087,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-08-01 05:31:01","updated_at":"2022-08-01 05:31:01","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handlerPerson":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u7814\u7a76\u624033\u6240"},"project":{"id":2882,"key":2882,"name":"\u8d1f\u8f7d\u5747\u8861"},"salesContract":{"id":2358,"key":2358,"name":"Z2022Q085ONT","contractScans":[{"id":16197,"object_type":105,"object_id":2358,"attachment_id":11118,"attachment":{"id":11118,"key":11118,"name":"49a1a27a-f11b-3ff9-b88f-3734f967dd61","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/09\/","orig_name":"2022_09_28_14_23_39.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":884,"serial_no":"XSDD-20220914-00001","from_date":"","wrote_date":"2022-06-29","handler":5295,"client_id":518,"purchase_contract_id":"","project_id":2892,"sales_contract_id":2357,"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-07-29 20:54:26","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"31000","created_by":5295,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-07-29 20:54:26","updated_at":"2022-07-29 20:54:26","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":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"},"project":{"id":2892,"key":2892,"name":"\u7f51\u7edc\u5b89\u5168\u52a0\u56fa"},"salesContract":{"id":2357,"key":2357,"name":"TS-WZW-2022062901","contractScans":[{"id":15961,"object_type":105,"object_id":2357,"attachment_id":10701,"attachment":{"id":10701,"key":10701,"name":"43529277-069a-3421-9461-d630e56adccc","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/08\/","orig_name":"\u56fd\u79d1\u73af\u5b87\u201420220629.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":883,"serial_no":"XSDD-20220810-00001","from_date":"","wrote_date":"2022-07-05","handler":5300,"client_id":497,"purchase_contract_id":"","project_id":2910,"sales_contract_id":2354,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u865a\u62df\u5316\u53ca\u5907\u4efd\u670d\u52a1\u652f\u6301","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-07-27 11:10:57","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"38990","created_by":5300,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-07-27 11:10:57","updated_at":"2022-07-27 11:10:57","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":497,"key":497,"name":"\u5317\u4eac\u7ea2\u661f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"project":{"id":2910,"key":2910,"name":"\u865a\u62df\u5316\u53ca\u5907\u4efd\u7ef4\u4fdd-2022"},"salesContract":{"id":2354,"key":2354,"name":"TS-SQY-20220622","contractScans":[{"id":15750,"object_type":105,"object_id":2354,"attachment_id":10685,"attachment":{"id":10685,"key":10685,"name":"3b567d1a-2d7f-3956-8496-c45eb3b3996e","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/07\/","orig_name":"\u7ea2\u661f\u201438990\u201420220705.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":882,"serial_no":"XSDD-20220810-00001","from_date":"","wrote_date":"2022-07-05","handler":5300,"client_id":497,"purchase_contract_id":"","project_id":2854,"sales_contract_id":2353,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"PA\u9632\u706b\u5899\u7eed\u4fdd\u4e00\u5e74\nPA820\u4e00\u53f0\nPA220 \u4e00\u53f0","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-07-27 11:09:32","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"50610","created_by":5300,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-07-27 11:09:32","updated_at":"2022-07-27 11:09:32","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":497,"key":497,"name":"\u5317\u4eac\u7ea2\u661f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"project":{"id":2854,"key":2854,"name":"PA\u7eed\u4fdd-2022\u5e74"},"salesContract":{"id":2353,"key":2353,"name":"TS-SQY-2022060201","contractScans":[{"id":15954,"object_type":105,"object_id":2353,"attachment_id":10686,"attachment":{"id":10686,"key":10686,"name":"afae2841-d4ae-3c19-b6d1-fc78c60af1e3","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/07\/","orig_name":"\u7ea2\u661f\u201450610\u201420220705.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":881,"serial_no":"XSDD-20220726-00001","from_date":"","wrote_date":"2022-07-26","handler":5295,"client_id":304,"purchase_contract_id":"","project_id":2914,"sales_contract_id":2351,"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-07-26 10:19:35","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"4500","created_by":5295,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-07-26 10:19:35","updated_at":"2022-07-26 10:19:35","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":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8"},"project":{"id":2914,"key":2914,"name":"\u7f51\u7edc\u4ea7\u54c1\u65b0\u8d2d"},"salesContract":{"id":2351,"key":2351,"name":"TS-WZE-2022072601","contractScans":[{"id":18614,"object_type":105,"object_id":2351,"attachment_id":10707,"attachment":{"id":10707,"key":10707,"name":"0a225fca-cc89-364f-bf87-c943c6863323","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/08\/","orig_name":"2022_08_01_16_09_38.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":880,"serial_no":"XSDD-20221010-00001","from_date":"","wrote_date":"2022-07-21","handler":1001,"client_id":2150,"purchase_contract_id":"","project_id":2893,"sales_contract_id":2349,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"PA-5220\u9632\u706b\u5899\u4e00\u5e74\u7ef4\u4fdd\uff0c\u5305\u542bADVURL\/TP\/DNS\/PAN-SVC-BKLN-5220-R","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-07-21 10:34:01","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"154483","created_by":1001,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-07-21 10:34:01","updated_at":"2022-07-21 10:34:01","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":2150,"key":2150,"name":"\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)"},"project":{"id":2893,"key":2893,"name":"PA5220\u9632\u706b\u5899\u8bbe\u5907\u4e00\u5e74\u7ef4\u4fdd"},"salesContract":{"id":2349,"key":2349,"name":"HT02-202207150002","contractScans":[{"id":15950,"object_type":105,"object_id":2349,"attachment_id":10631,"attachment":{"id":10631,"key":10631,"name":"83167516-8193-3332-bf27-8f1b46bc9750","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/07\/","orig_name":"2022_07_21_10_46_31.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":879,"serial_no":"XSDD-20220803-00001","from_date":"","wrote_date":"2022-07-13","handler":5300,"client_id":1331,"purchase_contract_id":"","project_id":2908,"sales_contract_id":2342,"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-07-15 13:47:10","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"1200","created_by":5300,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-07-15 13:47:10","updated_at":"2022-07-15 13:47:10","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":1331,"key":1331,"name":"\u4e09\u76db\u667a\u6167\u6559\u80b2\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4e2d\u80b2\u8d1d\u62c9\u56fd\u9645\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6c47\u51a0\u89e6\u6478\u6280\u672f\u6709\u9650\u516c\u53f8"},"project":{"id":2908,"key":2908,"name":"\u670d\u52a1\u5668\u8c03\u8bd5\/\u4e00\u6b21\u4e0a\u95e8"},"salesContract":{"id":2342,"key":2342,"name":"TS-SQY-2022071301","contractScans":[{"id":15751,"object_type":105,"object_id":2342,"attachment_id":10590,"attachment":{"id":10590,"key":10590,"name":"fe1551ae-fbbd-35ee-92c0-9a351ce848c6","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/07\/","orig_name":"\u4e09\u76db\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":878,"serial_no":"XSDD-20220719-00001","from_date":"","wrote_date":"2022-07-07","handler":1001,"client_id":2207,"purchase_contract_id":"","project_id":2907,"sales_contract_id":2340,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"Netapp\u5b58\u50a8\u6570\u636e\u4fee\u590d\u670d\u52a1","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-07-15 10:14:14","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"10000","created_by":1001,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-07-15 10:14:14","updated_at":"2022-07-15 10:14:14","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":2207,"key":2207,"name":"\u5317\u4eac\u4e2d\u79d1\u5764\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":2907,"key":2907,"name":"Netapp\u5b58\u50a8\u6570\u636e\u4fee\u590d\u670d\u52a1"},"salesContract":{"id":2340,"key":2340,"name":"TS-LRC-20220629","contractScans":[{"id":15596,"object_type":105,"object_id":2340,"attachment_id":10586,"attachment":{"id":10586,"key":10586,"name":"a851ffc7-354f-3420-9657-712d6ecc4f05","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/07\/","orig_name":"2022_07_15_09_59_49.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":877,"serial_no":"XSDD-20220810-00001","from_date":"","wrote_date":"2022-07-15","handler":5295,"client_id":2177,"purchase_contract_id":"","project_id":2823,"sales_contract_id":2338,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u5353\u8c6a\u8f6f\u4ef6\u7eed\u4fdd\n","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-07-14 15:03:50","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"14700","created_by":5295,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-07-14 15:03:50","updated_at":"2022-07-14 15:03:50","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":2177,"key":2177,"name":"\u4e2d\u79cd\u56fd\u9645\u79cd\u5b50\u6709\u9650\u516c\u53f8"},"project":{"id":2823,"key":2823,"name":"\u8fd0\u7ef4\u8f6f\u4ef6\u7eed\u4fdd"},"salesContract":{"id":2338,"key":2338,"name":"TS-WZW-2022070549","contractScans":[{"id":15951,"object_type":105,"object_id":2338,"attachment_id":10583,"attachment":{"id":10583,"key":10583,"name":"a53ba34c-6263-3ea1-8825-f4fd4ae9b939","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/07\/","orig_name":"\u4e2d\u79cd\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":876,"serial_no":"XSDD-20220812-00001","from_date":"","wrote_date":"2022-07-14","handler":1004,"client_id":48,"purchase_contract_id":"","project_id":2906,"sales_contract_id":2337,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"netapp\u786c\u76d8\u4e00\u5757","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-07-14 11:43:12","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"1600","created_by":1004,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-07-14 11:43:12","updated_at":"2022-07-14 11:43:12","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":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8"},"project":{"id":2906,"key":2906,"name":"netapp\u5b58\u50a8\u786c\u76d8"},"salesContract":{"id":2337,"key":2337,"name":"TS-YJC-2022071401","contractScans":[{"id":15759,"object_type":105,"object_id":2337,"attachment_id":10587,"attachment":{"id":10587,"key":10587,"name":"a91f384e-8541-35cd-b8e7-654c74ddee26","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/07\/","orig_name":"2022_07_15_10_51_44.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":875,"serial_no":"XSDD-20221101-00001","from_date":"","wrote_date":"2022-06-30","handler":1004,"client_id":5,"purchase_contract_id":"","project_id":2859,"sales_contract_id":2333,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"\u601d\u79d1\u4ea4\u6362\u673a\u8bbe\u5907\u7eed\u4fdd\uff1aN9504\u7b49","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-07-10 20:30:47","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"740792","created_by":1004,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-07-10 20:30:47","updated_at":"2022-07-10 20:30:47","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":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":2859,"key":2859,"name":"2022\u4ea4\u6362\u673a\u7eed\u4fdd"},"salesContract":{"id":2333,"key":2333,"name":"TS-YJC-2022061302","contractScans":[{"id":16781,"object_type":105,"object_id":2333,"attachment_id":10516,"attachment":{"id":10516,"key":10516,"name":"7496731d-e8e4-3c7f-b780-1e0eeaab7ff8","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/07\/","orig_name":"\u666e\u5929\u5408\u540c740792.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":874,"serial_no":"XSDD-20221017-00001","from_date":"","wrote_date":"2022-06-30","handler":5300,"client_id":1181,"purchase_contract_id":"","project_id":2843,"sales_contract_id":2325,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"PA\uff1aVM-300\u865a\u62df\u9632\u706b\u5899\u7eed\u4fdd\n2022\u5e745\u670829\u65e5\u5230\u671f","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-07-04 17:57:27","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"58990","created_by":5300,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-07-04 17:57:27","updated_at":"2022-07-04 17:57:27","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":1181,"key":1181,"name":"\u5148\u6b63\u8fbe\u751f\u7269\u79d1\u6280(\u4e2d\u56fd);\u5148\u6b63\u8fbe(\u4e2d\u56fd)\u6295\u8d44\u6709\u9650\u516c\u53f8;\u5317\u4eac\u65ed\u65e5\u4f73\u4e1a\u7f51\u7edc\u6709\u9650\u516c\u53f8\uff08CAE\/EDA\/BIO\uff09"},"project":{"id":2843,"key":2843,"name":"PA:VM-300\u865a\u62df\u9632\u706b\u5899\u7eed\u4fdd"},"salesContract":{"id":2325,"key":2325,"name":"PO\uff1a1100198185","contractScans":[{"id":15748,"object_type":105,"object_id":2325,"attachment_id":10582,"attachment":{"id":10582,"key":10582,"name":"b0535da7-31c1-30b7-a2b0-1d43b0439d01","extension":"jpeg","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/07\/","orig_name":"WechatIMG437[1].jpeg"}}]},"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":873,"serial_no":"XSDD-20221024-00001","from_date":"","wrote_date":"2022-06-20","handler":5300,"client_id":43,"purchase_contract_id":"","project_id":2889,"sales_contract_id":2324,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"1\tHPE\tDL388\t1\u53f0\n2\t\u7fa4\u6656\tDS720+\tDS720+\u5854\u5f0f\u4e24\u76d8\u4f4d 1\u53f0","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2022-07-04 17:57:15","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"0","amount":"29750","created_by":5300,"stop_description":"","extra":"","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2022-07-04 17:57:15","updated_at":"2022-07-04 17:57:15","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":43,"key":43,"name":"\u5317\u4eac\u5065\u529b\u6e90\u9910\u996e\u7ba1\u7406\u6709\u9650\u516c\u53f8"},"project":{"id":2889,"key":2889,"name":"\u60e0\u666e\u670d\u52a1\u5668+\u7fa4\u8f89\u5b58\u50a8"},"salesContract":{"id":2324,"key":2324,"name":"JLY-BJ20220413","contractScans":[{"id":15462,"object_type":105,"object_id":2324,"attachment_id":10486,"attachment":{"id":10486,"key":10486,"name":"7519fe2c-c812-30c1-aad1-fb1df8eb3128","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2022\/07\/","orig_name":"\u5065\u529b\u6e90\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}],"can_create":true,"pagenation":{"totalcount":971,"thispage":5,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-13 10:26:22') RETURNING "id"
10:26:22.7963.0 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (10486, 10586, 10582, 10685, 10590, 10587, 10631, 10583, 10812, 10686, 10770, 10813, 10704, 10701, 10744, 11118, 10740, 10746, 10516, 10707)
10:26:22.7942.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (2370, 2375, 2371, 2367, 2368, 2354, 2358, 2353, 2351, 2369, 2333, 2337, 2324, 2340, 2349, 2342, 2338, 2325, 2361, 2357))
10:26:22.7662.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5016
10:26:22.7641.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:26:22.8021.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20011) AND ("object_id" IN (892, 891, 890, 889, 888, 887, 886, 885, 884, 883, 882, 881, 880, 879, 878, 877, 876, 875, 874, 873))
10:26:22.8041.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20012) AND ("object_id" IN (892, 891, 890, 889, 888, 887, 886, 885, 884, 883, 882, 881, 880, 879, 878, 877, 876, 875, 874, 873))
10:26:22.7701.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016
10:26:22.7911.2 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (2933, 2888, 2936, 2895, 2805, 2904, 2887, 2882, 2892, 2910, 2854, 2914, 2893, 2908, 2907, 2823, 2906, 2859, 2843, 2889)
10:26:22.7931.1 msyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" AS "name" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (2375, 2371, 2370, 2369, 2368, 2367, 2361, 2358, 2357, 2354, 2353, 2351, 2349, 2342, 2340, 2338, 2337, 2333, 2325, 2324)
10:26:22.7880.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, 1005, 5087, 1004, 5300))
10:26:22.8050.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id" IN (892, 891, 890, 889, 888, 887, 886, 885, 884, 883, 882, 881, 880, 879, 878, 877, 876, 875, 874, 873)
10:26:22.7750.6 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" ORDER BY "id"
10:26:22.8080.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id" IN (892, 891, 890, 889, 888, 887, 886, 885, 884, 883, 882, 881, 880, 879, 878, 877, 876, 875, 874, 873)
10:26:22.7890.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1)
10:26:22.7870.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5295, 1005, 5087, 1001, 1004)
10:26:22.7910.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (1886, 121, 1301, 57, 2202, 90, 2128, 518, 497, 304, 2150, 1331, 2207, 2177, 48, 5, 1181, 43)
10:26:22.8060.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (892, 891, 890, 889, 888, 887, 886, 885, 884, 883, 882, 881, 880, 879, 878, 877, 876, 875, 874, 873) ORDER BY "id"
10:26:22.8000.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_carbon_copy_rels" WHERE "erp_sales_order_id" IN (892, 891, 890, 889, 888, 887, 886, 885, 884, 883, 882, 881, 880, 879, 878, 877, 876, 875, 874, 873)
10:26:22.8080.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE "erp_sales_order_id" IN (892, 891, 890, 889, 888, 887, 886, 885, 884, 883, 882, 881, 880, 879, 878, 877, 876, 875, 874, 873) ORDER BY "id"
10:26:22.8010.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE ("status" != 0) AND ("erp_sales_order_id" IN (892, 891, 890, 889, 888, 887, 886, 885, 884, 883, 882, 881, 880, 879, 878, 877, 876, 875, 874, 873)) ORDER BY "id"
10:26:22.7900.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, 1005, 5087, 1004, 5300))
10:26:22.7890.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5295, 1005, 5087, 1001, 1004)
10:26:22.8070.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id" IN (892, 891, 890, 889, 888, 887, 886, 885, 884, 883, 882, 881, 880, 879, 878, 877, 876, 875, 874, 873)) ORDER BY "id"
10:26:22.8000.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (892, 891, 890, 889, 888, 887, 886, 885, 884, 883, 882, 881, 880, 879, 878, 877, 876, 875, 874, 873) ORDER BY "id"
10:26:22.8010.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id" IN (892, 891, 890, 889, 888, 887, 886, 885, 884, 883, 882, 881, 880, 879, 878, 877, 876, 875, 874, 873)) ORDER BY "id"
10:26:22.8090.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id" IN (892, 891, 890, 889, 888, 887, 886, 885, 884, 883, 882, 881, 880, 879, 878, 877, 876, 875, 874, 873)) ORDER BY "id"
10:26:22.8070.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 (892, 891, 890, 889, 888, 887, 886, 885, 884, 883, 882, 881, 880, 879, 878, 877, 876, 875, 874, 873))
10:26:22.8070.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("status" != 0) AND ("erp_sales_order_id" IN (892, 891, 890, 889, 888, 887, 886, 885, 884, 883, 882, 881, 880, 879, 878, 877, 876, 875, 874, 873)) ORDER BY "id"
10:26:22.8090.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("status" != 0) AND ("erp_sales_order_id" IN (892, 891, 890, 889, 888, 887, 886, 885, 884, 883, 882, 881, 880, 879, 878, 877, 876, 875, 874, 873)) ORDER BY "id"
10:26:22.8100.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 (892, 891, 890, 889, 888, 887, 886, 885, 884, 883, 882, 881, 880, 879, 878, 877, 876, 875, 874, 873))
10:26:22.8010.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 (892, 891, 890, 889, 888, 887, 886, 885, 884, 883, 882, 881, 880, 879, 878, 877, 876, 875, 874, 873))
10:26:22.7900.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1)