6a1d32f6656e8: POST https://beta.jinchangxiao.com/vue/erp-sales-outbound/list at 2026-06-01 03:21:26 pm by 43.224.72.82
Database Queries
总计56条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 15:21:26.423 | 6.3 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=5495 |
| 15:21:26.441 | 1.1 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495 |
| 15:21:26.446 | 0.9 ms | SELECT | SELECT "s"."accessible_user" FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_visibles" "s" LEFT JOIN "o6a13e2c574d5a"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5495) AND (s.accessible_user IS NOT NULL) GROUP BY "s"."id", "u"."id" ORDER BY "u"."name" |
| 15:21:26.448 | 7.3 ms | SELECT | SELECT COUNT(*) FROM (SELECT r.*, min( CASE WHEN 1 = r.verify_type THEN ( CASE WHEN rvr.status = 0 THEN 1 WHEN rsvr.status = 0 THEN 2 ELSE 4 END ) ELSE ( CASE WHEN rvr.status = 0 AND r.next_verify_user = 5495 THEN 1 WHEN rsvr.status = 0 AND r.next_stop_verify_user = 5495 THEN 2 ELSE 4 END ) END) AS need_verify_sort FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" "rvr" ON rvr.erp_sales_outbound_id = r.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" "rsvr" ON rsvr.erp_sales_outbound_id = r.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbound_products" "epop" ON epop.erp_sales_outbound_id = r.id LEFT JOIN "o6a13e2c574d5a"."tbl_products" "product" ON epop.product_id = product.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "client" ON client.id = r.client_id WHERE (("client"."sales_rep"=5495) OR ("r"."created_by"=5495) OR ("rvr"."user_id"=5495) OR ("r"."created_by" IN (5493, 5495, 5495))) AND (("r"."status" != 0) OR (("r"."status"=0) AND ("r"."created_by"=5495))) GROUP BY "r"."id" ORDER BY need_verify_sort asc, created_at DESC) "c" |
| 15:21:26.459 | 8.0 ms | SELECT | SELECT r.*, min( CASE WHEN 1 = r.verify_type THEN ( CASE WHEN rvr.status = 0 THEN 1 WHEN rsvr.status = 0 THEN 2 ELSE 4 END ) ELSE ( CASE WHEN rvr.status = 0 AND r.next_verify_user = 5495 THEN 1 WHEN rsvr.status = 0 AND r.next_stop_verify_user = 5495 THEN 2 ELSE 4 END ) END) AS need_verify_sort FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" "rvr" ON rvr.erp_sales_outbound_id = r.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" "rsvr" ON rsvr.erp_sales_outbound_id = r.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbound_products" "epop" ON epop.erp_sales_outbound_id = r.id LEFT JOIN "o6a13e2c574d5a"."tbl_products" "product" ON epop.product_id = product.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "client" ON client.id = r.client_id WHERE (("client"."sales_rep"=5495) OR ("r"."created_by"=5495) OR ("rvr"."user_id"=5495) OR ("r"."created_by" IN (5493, 5495, 5495))) AND (("r"."status" != 0) OR (("r"."status"=0) AND ("r"."created_by"=5495))) GROUP BY "r"."id" ORDER BY need_verify_sort asc, created_at DESC LIMIT 20 |
| 15:21:26.469 | 3.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 15:21:26.473 | 0.3 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493) |
| 15:21:26.473 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1 |
| 15:21:26.474 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 15:21:26.474 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493) |
| 15:21:26.475 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1 |
| 15:21:26.475 | 2.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_clients" WHERE "id"=1 |
| 15:21:26.481 | 7.1 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name", "bargain_date" FROM "o6a13e2c574d5a"."tbl_projects" WHERE "id"=1 |
| 15:21:26.491 | 1.4 ms | SELECT | SELECT "id", "id" AS "key", "serial_no" AS "name", "from_project", "erp_settle_amount", "erp_un_settle_amount" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "from_project"=1 |
| 15:21:26.493 | 0.4 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_carbon_copy_rels" WHERE "erp_sales_outbound_id"=1 |
| 15:21:26.494 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" WHERE "erp_sales_outbound_id"=1 ORDER BY "id" |
| 15:21:26.494 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" WHERE ("status"=0) AND ("erp_sales_outbound_id"=1) ORDER BY "id" |
| 15:21:26.494 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" WHERE ("status" != 0) AND ("erp_sales_outbound_id"=1) ORDER BY "id" |
| 15:21:26.495 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" WHERE ("status" = 0) AND ("user_id"=5495) AND ("erp_sales_outbound_id"=1) |
| 15:21:26.495 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_attachement_relationships" WHERE ("object_type"=20011) AND ("object_id"=1) |
| 15:21:26.495 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_attachement_relationships" WHERE ("object_type"=20012) AND ("object_id"=1) |
| 15:21:26.496 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "title" AS "name" FROM "o6a13e2c574d5a"."tbl_erp_stores" WHERE "id"=1 |
| 15:21:26.496 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_products" WHERE "erp_sales_outbound_id"=1 |
| 15:21:26.497 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "title" AS "name" FROM "o6a13e2c574d5a"."tbl_erp_stores" WHERE "id"=1 |
| 15:21:26.497 | 0.3 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_products" WHERE "id"=1 |
| 15:21:26.498 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_types" WHERE "id"=1 |
| 15:21:26.498 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_components" WHERE "id"=1 |
| 15:21:26.499 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_brands" WHERE "id"=1 |
| 15:21:26.499 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_series" WHERE "id"=1 |
| 15:21:26.499 | 1.0 ms | SELECT | SELECT "eip"."product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "o6a13e2c574d5a"."tbl_erp_inventory_products" "eip" WHERE "product_id"=1 GROUP BY "eip"."product_id" |
| 15:21:26.500 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id"=1 |
| 15:21:26.501 | 0.3 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_products" WHERE "id"=1 |
| 15:21:26.501 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_types" WHERE "id"=1 |
| 15:21:26.502 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_components" WHERE "id"=1 |
| 15:21:26.502 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_brands" WHERE "id"=1 |
| 15:21:26.502 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_series" WHERE "id"=1 |
| 15:21:26.503 | 0.3 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_spent_product_sns" WHERE "erp_sales_outbound_spent_product_id"=1 |
| 15:21:26.503 | 0.6 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=1 |
| 15:21:26.504 | 0.4 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_inventory_products" WHERE "id"=4 |
| 15:21:26.505 | 0.7 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_purchase_inbounds" WHERE "id"=4 |
| 15:21:26.506 | 0.3 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_order_products" WHERE "id"=1 |
| 15:21:26.506 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id"=1 |
| 15:21:26.507 | 0.3 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" WHERE "id"=1 |
| 15:21:26.507 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" WHERE "erp_sales_outbound_id"=1 ORDER BY "id" |
| 15:21:26.507 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" WHERE ("status"=0) AND ("erp_sales_outbound_id"=1) ORDER BY "id" |
| 15:21:26.508 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" WHERE ("status" != 0) AND ("erp_sales_outbound_id"=1) ORDER BY "id" |
| 15:21:26.508 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" WHERE ("status" = 0) AND ("user_id"=5495) AND ("erp_sales_outbound_id"=1) |
| 15:21:26.508 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_id"=1 |
| 15:21:26.509 | 0.3 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_products" WHERE "id"=1 |
| 15:21:26.509 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_types" WHERE "id"=1 |
| 15:21:26.509 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_components" WHERE "id"=1 |
| 15:21:26.510 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_brands" WHERE "id"=1 |
| 15:21:26.510 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_series" WHERE "id"=1 |
| 15:21:26.510 | 0.3 ms | SELECT | SELECT "object_id", count(*) as comment FROM "o6a13e2c574d5a"."tbl_comments" WHERE ("object_type"=20008) AND ("object_id"=1) GROUP BY "object_id" |
| 15:21:26.511 | 0.3 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "o6a13e2c574d5a"."tbl_unread_comments" WHERE ("object_type"=20008) AND (remind_user_id = 5495 AND is_read = false) AND ("object_id"=1) GROUP BY "object_id" |
| 15:21:26.513 | 1.5 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'o6a13e2c574d5a', 5495, 5, 'vue/erp-sales-outbound/list', '{"Filter":{"name":"default","sort":"DESC"},"ErpSalesOutboundSearch":{"wrote_date_period":"","created_at_period":"","status":"","erp_store_id":"","is_sales_order_ready":"","handler":"","created_by":"","number_range_to":"","number_range_from":"","amount_range_to":"","amount_range_from":""},"page":"1","web_access_token":"BVNSh9YfxWIaBBEpqELLGqJuWOoESJvj"}', '{"code":2000,"result":{"list":[{"id":1,"serial_no":"XSCKD-20260601-00001","from_date":"","wrote_date":"2026-06-01","handler":5493,"erp_sales_order_id":1,"client_id":1,"project_id":1,"erp_store_id":1,"status":2,"erp_send_type_id":"","abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-06-01 15:19:51","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"1","amount":"10000","created_by":5493,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":true,"created_at":"2026-06-01 15:19:51","updated_at":"2026-06-01 15:19:51","print_times":"","is_sales_order_ready":true,"need_verify_sort":4,"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":{},"department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"handlerPerson":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":{},"department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"client":{"id":1,"key":1,"name":"\u903b\u8f91\u6d4b\u8bd5-\u9500\u552e\u5408\u540c"},"project":{"id":1,"key":1,"name":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260527001","bargain_date":"2026-05-27","buildContract":{"id":8,"key":8,"name":"2026-05-27-001","from_project":1,"erp_settle_amount":"0","erp_un_settle_amount":"10000"}},"erpSalesOutboundCarbonCopyRels":[],"erpSalesOutboundVerifyRels":[],"lastErpSalesOutboundVerifyRel":{},"haveErpSalesOutboundVerifyRel":{},"selfErpSalesOutboundVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{"id":1,"key":1,"name":"\u4e3b\u4ed3\u5e93"},"erpSendType":"","erpSalesOutboundProducts":[{"id":1,"erp_sales_outbound_id":1,"erp_sales_order_id":1,"erp_sales_order_product_id":1,"erp_store_id":1,"product_id":1,"description":"","outbound":"0","number":1,"amount":"10000","total_amount":"10000.00","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{"id":1,"key":1,"name":"\u4e3b\u4ed3\u5e93"},"product":{"id":1,"name":"\u6df1\u4fe1\u670d AF-1210-A","product_type":1,"product_component":1,"product_brand":1,"product_serie":1,"product_misc":"","product_qa":"","pn":"","description":"","created_by":5493,"created_at":"2026-05-25 13:48:53","updated_at":"2026-06-01 15:21:10","pinyin_shortcut":"","product_unit":"","is_renew":false,"in_out_at":"2026-06-01 15:21:10.749785+08","productType":{"id":1,"key":1,"name":"\u9632\u706b\u5899"},"productComponent":{"id":1,"key":1,"name":"\u786c\u4ef6\u4e3b\u673a"},"productBrand":{"id":1,"key":1,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1,"key":1,"name":"\u6df1\u4fe1\u670dAF-1210"},"productUnit":"","erpInventoryCount":{"product_id":1,"outbound":"0","number":"2","inventory":"2","avg_amount":"200.0000000000000000","avg_total_amount":"80.0000000000000000","amount":"400"}},"erpSalesOutboundSpentProducts":[{"id":1,"erp_sales_outbound_id":1,"erp_sales_outbound_product_id":1,"erp_inventory_product_id":4,"product_id":1,"description":"","number":"1","amount":"10000","total_amount":"10000","cancel_number":"1","cancel_amount":"10000","cancel_total_amount":"10000","product":{"id":1,"name":"\u6df1\u4fe1\u670d AF-1210-A","product_type":1,"product_component":1,"product_brand":1,"product_serie":1,"product_misc":"","product_qa":"","pn":"","description":"","created_by":5493,"created_at":"2026-05-25 13:48:53","updated_at":"2026-06-01 15:21:10","pinyin_shortcut":"","product_unit":"","is_renew":false,"in_out_at":"2026-06-01 15:21:10.749785+08","productType":{"id":1,"key":1,"name":"\u9632\u706b\u5899"},"productComponent":{"id":1,"key":1,"name":"\u786c\u4ef6\u4e3b\u673a"},"productBrand":{"id":1,"key":1,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1,"key":1,"name":"\u6df1\u4fe1\u670dAF-1210"},"productUnit":""},"erpSalesOutboundSpentProductSns":[],"spent":{"id":1,"erp_purchase_order_id":"","erp_purchase_inbound_id":"","erp_inventory_product_id":4,"wrote_date":"2026-06-01","actual_amount":"200","actual_total_amount":"0","outbound":"0","amount":"10000","total_amount":"0","lost_outbound":"","erp_inventory_lost_product_id":"","erp_inventory_lost_id":"","erp_inventory_start_id":"","erp_inventory_build_id":"","build_spent_outbound":"","erp_inventory_build_spent_product_id":"","erp_inventory_build_spent_id":"","sales_outbound":"0","erp_sales_outbound_spent_product_id":1,"erp_sales_outbound_id":1,"erp_purchase_gift_id":"","sales_gift_outbound":"","erp_sales_gift_spent_product_id":"","erp_sales_gift_id":"","erp_inventory_disassemble_id":"","disassemble_spent_outbound":"","erp_inventory_disassemble_spent_product_id":"","erp_inventory_disassemble_spent_id":"","erp_inventory_overflow_id":"","erpInventoryProduct":{"id":4,"product_id":1,"erp_purchase_inbound_id":4,"erp_purchase_order_id":1,"erp_purchase_inbound_product_id":4,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-05-27","number":"1","outbound":"0","inventory":"1","amount":"200","total_amount":"200","actual_amount":"200","actual_total_amount":"200","is_build":false,"created_at":"2026-05-27 16:19:18","lost_outbound":"0","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"0","sales_outbound":"0","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"0","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"0","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":"","erpPurchaseInbound":{"id":4,"serial_no":"CGRKD-20260527-00004","from_date":"","wrote_date":"2026-05-27","handler":5495,"erp_purchase_order_id":1,"supplier_id":1,"purchase_contract_id":1,"erp_store_id":1,"status":2,"abstract":"","description":"\u5165\u5e933\u9000\u8d272","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-05-27 16:19:18","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"number":"3","amount":"600","cancel_number":"","cancel_amount":"","created_by":5495,"stop_description":"","is_used":false,"is_settle":false,"created_at":"2026-05-27 16:19:09","updated_at":"2026-05-27 16:19:18","print_times":""},"erpPurchaseGift":{},"erpInventoryStart":{},"erpInventoryBuild":{},"erpInventoryDisassemble":{},"erpInventoryOverflow":{}}}}],"erpSalesOrderProduct":{"id":1,"erp_sales_order_id":1,"erp_store_id":"","product_id":1,"description":"","number":"1","outbound":"0","amount":"10000","total_amount":"10000","last_number":"2","last_amount":"10000","last_total_amount":"20000","cost":"200","total_cost":"200","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOutboundProducts":[{"id":1,"erp_sales_outbound_id":1,"erp_sales_order_id":1,"erp_sales_order_product_id":1,"erp_store_id":1,"product_id":1,"description":"","outbound":"0","number":"1","amount":"10000","total_amount":"10000.00","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOutbound":{"id":1,"serial_no":"XSCKD-20260601-00001","from_date":"","wrote_date":"2026-06-01","handler":5493,"erp_sales_order_id":1,"client_id":1,"project_id":1,"erp_store_id":1,"status":2,"erp_send_type_id":"","abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-06-01 15:19:51","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"1","amount":"10000","created_by":5493,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":true,"created_at":"2026-06-01 15:19:51","updated_at":"2026-06-01 15:19:51","print_times":"","is_sales_order_ready":true}}],"un_outbound":2,"un_outbound_amount":10000},"spent_total_amount":0,"avg_spent_amount":0,"pct":100}],"erpSalesOutboundStopVerifyRels":[],"lastErpSalesOutboundStopVerifyRel":{},"haveErpSalesOutboundStopVerifyRel":{},"selfErpSalesOutboundStopVerifyRel":{},"erpSalesOutboundSpentProducts":[{"id":1,"erp_sales_outbound_id":1,"erp_sales_outbound_product_id":1,"erp_inventory_product_id":4,"product_id":1,"description":"","number":"1","amount":"10000","total_amount":"10000","cancel_number":"1","cancel_amount":"10000","cancel_total_amount":"10000","product":{"id":1,"name":"\u6df1\u4fe1\u670d AF-1210-A","product_type":1,"product_component":1,"product_brand":1,"product_serie":1,"product_misc":"","product_qa":"","pn":"","description":"","created_by":5493,"created_at":"2026-05-25 13:48:53","updated_at":"2026-06-01 15:21:10","pinyin_shortcut":"","product_unit":"","is_renew":false,"in_out_at":"2026-06-01 15:21:10.749785+08","productType":{"id":1,"key":1,"name":"\u9632\u706b\u5899"},"productComponent":{"id":1,"key":1,"name":"\u786c\u4ef6\u4e3b\u673a"},"productBrand":{"id":1,"key":1,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1,"key":1,"name":"\u6df1\u4fe1\u670dAF-1210"},"productUnit":""}}],"commentCount":{},"unreadComments":{},"cost":0,"profit":10000,"profit_pct":100,"unread":0,"can_update":false,"can_update_sn":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_create_erp_sales_return":false,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true,"can_make_sales_order":false,"sales_order_ready_display":true,"sales_order_un_ready_display":false}],"can_create":false,"pagenation":{"totalcount":1,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"43.224.72.82","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-01 15:21:26', 93380096) RETURNING "id" |