ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a490916bad5d: POST https://beta.jinchangxiao.com/vue/erp-inventory-product/product-list at 2026-07-04 09:22:30 pm by 111.194.208.14

Performance Profiling

Total processing time: 89 ms; Peak memory: 5.962 MB. Show Profiling Timeline

总计19条数据
TimeDurationCategoryInfo
  
21:22:30.78214.5 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT "p".*, COALESCE(max(eipv.inventory_occupied_verifying), 0) as inventory_occupied_verifying FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.product_id = p.id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "epis" ON epis.id = eip.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_projects" "epips" ON epis.id = epips.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_projects" "pp" ON pp.id = epips.project_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = epips.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "eiss" ON eiss.id = eip.erp_inventory_start_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eibs" ON eibs.id = eip.erp_inventory_build_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eids" ON eids.id = eip.erp_inventory_disassemble_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gifts" "epgs" ON epgs.id = eip.erp_purchase_gift_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflows" "eios" ON eios.id = eip.erp_inventory_overflow_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esosps" ON eip.id = esosps.erp_inventory_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esos" ON esos.id = esosps.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_projects" "sp" ON sp.id = esos.project_id LEFT JOIN (SELECT eip.product_id, sum(eips.outbound) as inventory_occupied_verifying, sum(eips.actual_total_amount) as total_amount_occupied_verifying FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "eips" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eips.erp_inventory_product_id = eip.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esos" ON eips.erp_sales_outbound_id = esos.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "esg" ON eips.erp_sales_gift_id = esg.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_losts" "eil" ON eips.erp_inventory_lost_id = eil.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eib" ON eips.erp_inventory_build_spent_id = eib.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eid" ON eips.erp_inventory_disassemble_spent_id = eid.id WHERE (("eips"."erp_sales_outbound_id" IS NOT NULL) AND ("esos"."status"=1)) OR (("eips"."erp_sales_gift_id" IS NOT NULL) AND ("esg"."status"=1)) OR (("eips"."erp_inventory_lost_id" IS NOT NULL) AND ("eil"."status"=1)) OR (("eips"."erp_inventory_build_spent_id" IS NOT NULL) AND ("eib"."status"=1)) OR (("eips"."erp_inventory_disassemble_spent_id" IS NOT NULL) AND ("eid"."status"=1)) GROUP BY "eip"."product_id") "eipv" ON eipv.product_id = p.id WHERE "eip"."inventory" > 0 GROUP BY "p"."id" ORDER BY p.in_out_at DESC nulls last, p.updated_at DESC) "c"
21:22:30.82911.6 msyii\db\Command::querySELECT sum(sub.inventory_occupied_verifying) as inventory_occupied_verifying, sum(sub.total_amount_occupied_verifying) as total_amount_occupied_verifying FROM (SELECT eip.product_id, sum(eips.outbound) as inventory_occupied_verifying, sum(eips.actual_total_amount) as total_amount_occupied_verifying FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "eips" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eips.erp_inventory_product_id = eip.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esos" ON eips.erp_sales_outbound_id = esos.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "esg" ON eips.erp_sales_gift_id = esg.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_losts" "eil" ON eips.erp_inventory_lost_id = eil.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eib" ON eips.erp_inventory_build_spent_id = eib.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eid" ON eips.erp_inventory_disassemble_spent_id = eid.id WHERE ((("eips"."erp_sales_outbound_id" IS NOT NULL) AND ("esos"."status"=1)) OR (("eips"."erp_sales_gift_id" IS NOT NULL) AND ("esg"."status"=1)) OR (("eips"."erp_inventory_lost_id" IS NOT NULL) AND ("eil"."status"=1)) OR (("eips"."erp_inventory_build_spent_id" IS NOT NULL) AND ("eib"."status"=1)) OR (("eips"."erp_inventory_disassemble_spent_id" IS NOT NULL) AND ("eid"."status"=1))) AND ("eip"."product_id" IN (SELECT p.id FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.product_id = p.id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "epis" ON epis.id = eip.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_projects" "epips" ON epis.id = epips.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_projects" "pp" ON pp.id = epips.project_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = epips.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "eiss" ON eiss.id = eip.erp_inventory_start_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eibs" ON eibs.id = eip.erp_inventory_build_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eids" ON eids.id = eip.erp_inventory_disassemble_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gifts" "epgs" ON epgs.id = eip.erp_purchase_gift_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflows" "eios" ON eios.id = eip.erp_inventory_overflow_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esosps" ON eip.id = esosps.erp_inventory_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esos" ON esos.id = esosps.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_projects" "sp" ON sp.id = esos.project_id LEFT JOIN (SELECT eip.product_id, sum(eips.outbound) as inventory_occupied_verifying, sum(eips.actual_total_amount) as total_amount_occupied_verifying FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "eips" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eips.erp_inventory_product_id = eip.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esos" ON eips.erp_sales_outbound_id = esos.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "esg" ON eips.erp_sales_gift_id = esg.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_losts" "eil" ON eips.erp_inventory_lost_id = eil.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eib" ON eips.erp_inventory_build_spent_id = eib.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eid" ON eips.erp_inventory_disassemble_spent_id = eid.id WHERE (("eips"."erp_sales_outbound_id" IS NOT NULL) AND ("esos"."status"=1)) OR (("eips"."erp_sales_gift_id" IS NOT NULL) AND ("esg"."status"=1)) OR (("eips"."erp_inventory_lost_id" IS NOT NULL) AND ("eil"."status"=1)) OR (("eips"."erp_inventory_build_spent_id" IS NOT NULL) AND ("eib"."status"=1)) OR (("eips"."erp_inventory_disassemble_spent_id" IS NOT NULL) AND ("eid"."status"=1)) GROUP BY "eip"."product_id") "eipv" ON eipv.product_id = p.id WHERE "eip"."inventory" > 0 GROUP BY "p"."id")) GROUP BY "eip"."product_id") "sub"
21:22:30.7989.0 msyii\db\Command::querySELECT "p".*, COALESCE(max(eipv.inventory_occupied_verifying), 0) as inventory_occupied_verifying FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.product_id = p.id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "epis" ON epis.id = eip.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_projects" "epips" ON epis.id = epips.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_projects" "pp" ON pp.id = epips.project_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = epips.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "eiss" ON eiss.id = eip.erp_inventory_start_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eibs" ON eibs.id = eip.erp_inventory_build_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eids" ON eids.id = eip.erp_inventory_disassemble_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gifts" "epgs" ON epgs.id = eip.erp_purchase_gift_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflows" "eios" ON eios.id = eip.erp_inventory_overflow_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esosps" ON eip.id = esosps.erp_inventory_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esos" ON esos.id = esosps.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_projects" "sp" ON sp.id = esos.project_id LEFT JOIN (SELECT eip.product_id, sum(eips.outbound) as inventory_occupied_verifying, sum(eips.actual_total_amount) as total_amount_occupied_verifying FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "eips" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eips.erp_inventory_product_id = eip.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esos" ON eips.erp_sales_outbound_id = esos.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "esg" ON eips.erp_sales_gift_id = esg.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_losts" "eil" ON eips.erp_inventory_lost_id = eil.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eib" ON eips.erp_inventory_build_spent_id = eib.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eid" ON eips.erp_inventory_disassemble_spent_id = eid.id WHERE (("eips"."erp_sales_outbound_id" IS NOT NULL) AND ("esos"."status"=1)) OR (("eips"."erp_sales_gift_id" IS NOT NULL) AND ("esg"."status"=1)) OR (("eips"."erp_inventory_lost_id" IS NOT NULL) AND ("eil"."status"=1)) OR (("eips"."erp_inventory_build_spent_id" IS NOT NULL) AND ("eib"."status"=1)) OR (("eips"."erp_inventory_disassemble_spent_id" IS NOT NULL) AND ("eid"."status"=1)) GROUP BY "eip"."product_id") "eipv" ON eipv.product_id = p.id WHERE "eip"."inventory" > 0 GROUP BY "p"."id" ORDER BY p.in_out_at DESC nulls last, p.updated_at DESC LIMIT 20
21:22:30.8217.8 msyii\db\Command::querySELECT sum(inventory) as inventory_available, sum(actual_amount * inventory) as total_amount_available FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" WHERE "eip"."product_id" IN (SELECT p.id FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.product_id = p.id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "epis" ON epis.id = eip.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_projects" "epips" ON epis.id = epips.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_projects" "pp" ON pp.id = epips.project_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = epips.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "eiss" ON eiss.id = eip.erp_inventory_start_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eibs" ON eibs.id = eip.erp_inventory_build_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eids" ON eids.id = eip.erp_inventory_disassemble_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gifts" "epgs" ON epgs.id = eip.erp_purchase_gift_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflows" "eios" ON eios.id = eip.erp_inventory_overflow_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esosps" ON eip.id = esosps.erp_inventory_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esos" ON esos.id = esosps.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_projects" "sp" ON sp.id = esos.project_id LEFT JOIN (SELECT eip.product_id, sum(eips.outbound) as inventory_occupied_verifying, sum(eips.actual_total_amount) as total_amount_occupied_verifying FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "eips" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eips.erp_inventory_product_id = eip.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esos" ON eips.erp_sales_outbound_id = esos.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "esg" ON eips.erp_sales_gift_id = esg.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_losts" "eil" ON eips.erp_inventory_lost_id = eil.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eib" ON eips.erp_inventory_build_spent_id = eib.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eid" ON eips.erp_inventory_disassemble_spent_id = eid.id WHERE (("eips"."erp_sales_outbound_id" IS NOT NULL) AND ("esos"."status"=1)) OR (("eips"."erp_sales_gift_id" IS NOT NULL) AND ("esg"."status"=1)) OR (("eips"."erp_inventory_lost_id" IS NOT NULL) AND ("eil"."status"=1)) OR (("eips"."erp_inventory_build_spent_id" IS NOT NULL) AND ("eib"."status"=1)) OR (("eips"."erp_inventory_disassemble_spent_id" IS NOT NULL) AND ("eid"."status"=1)) GROUP BY "eip"."product_id") "eipv" ON eipv.product_id = p.id WHERE "eip"."inventory" > 0 GROUP BY "p"."id")
21:22:30.8453.5 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-inventory-product/product-list', '{"Filter":{"name":"in_out_at","sort":"DESC"},"ErpProductSearch":{"erp_store_id":"","product_type":"","product_component":"","product_brand":"","product_serie":"","handler":"","sales_rep":"","number_range_to":"","number_range_from":"","inventory":"1"},"page":"1","web_access_token":"wx4hXh9V-DIrZeBjtGStxgwx5HvDWnxk"}', '{"code":2000,"result":{"stores":[{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"},{"id":2,"key":2,"name":"\u96f6\u914d\u4ef6"}],"list":[{"id":2261,"name":"MK-MC300","product_type":4,"product_component":52,"product_brand":4,"product_serie":1769,"product_misc":"","product_qa":"","pn":"","description":"MK-MC300\u62fe\u97f3\u9ea6\u514b\u98ce\uff0c\u542b5\u7c73\u7ebf","created_by":1013,"created_at":"2026-03-16 10:07:43","updated_at":"2026-07-04 20:49:32","pinyin_shortcut":"MKMC300","product_unit":3,"is_renew":false,"in_out_at":"2026-07-04 20:49:32.738821+08","inventory_occupied_verifying":"6","everyStoreErpInventoryCount":[{"product_id":2261,"erp_store_id":1,"outbound":"13","number":"66","inventory":"53","avg_amount":"7952.3561111111111111","avg_total_amount":"345.1111111111111111"},{"product_id":2261,"erp_store_id":2,"outbound":"0","number":"1","inventory":"1","avg_amount":"1.00000000000000000000","avg_total_amount":"1.00000000000000000000"}],"erpInventoryCount":{"product_id":2261,"outbound":"13","number":"67","inventory":"54","avg_amount":"7157.2205000000000000","avg_total_amount":"310.7000000000000000","amount":"3107.000","inventory_available":60,"inventory_occupied_verifying":"6"},"erpInventoryCount2":{"product_id":2261,"inventory":"54","avg_amount":180.4,"amount":3107},"erpInventoryCount3":[{"id":494,"product_id":2261,"erp_purchase_inbound_id":212,"erp_purchase_order_id":2212,"erp_purchase_inbound_product_id":431,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-04-30","number":"1","outbound":"0","inventory":"1","amount":"222","total_amount":"222.00","actual_amount":"222","actual_total_amount":"222","is_build":false,"created_at":"2026-05-09 17:09:10","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":502,"product_id":2261,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":2,"wrote_date":"2026-05-20","number":"1","outbound":"0","inventory":"1","amount":"1","total_amount":"1.00","actual_amount":"1","actual_total_amount":"1","is_build":false,"created_at":"2026-05-20 14:04:02","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":5,"erp_inventory_overflow_product_id":6},{"id":509,"product_id":2261,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-05-20","number":"1","outbound":"0","inventory":"1","amount":"200","total_amount":"200.00","actual_amount":"200","actual_total_amount":"200","is_build":false,"created_at":"2026-05-21 16:54:55","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":6,"erp_inventory_overflow_product_id":10},{"id":510,"product_id":2261,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-05-21","number":"1","outbound":"0","inventory":"1","amount":"434","total_amount":"434.00","actual_amount":"434","actual_total_amount":"434","is_build":false,"created_at":"2026-05-21 17:10:01","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":9,"erp_inventory_overflow_product_id":13},{"id":470,"product_id":2261,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-04-08","number":"56","outbound":"6","inventory":"50","amount":"45","total_amount":"2520","actual_amount":"45","actual_total_amount":"2250","is_build":false,"created_at":"2026-04-08 09:35:32","lost_outbound":"0","erp_inventory_start_id":32,"erp_inventory_start_product_id":49,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"1","sales_outbound":"5","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":""}],"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":52,"key":52,"name":"\u534f\u4f5c"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1769,"key":1769,"name":"\u5168\u5411\u9ea6\u514b\u98ce"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"everyStoreErpInventoryCount1":{"product_id":2261,"erp_store_id":1,"outbound":"13","number":"66","inventory":"53","avg_amount":"7952.3561111111111111","avg_total_amount":"345.1111111111111111"},"everyStoreErpInventoryCount2":{"product_id":2261,"erp_store_id":2,"outbound":"0","number":"1","inventory":"1","avg_amount":"1.00000000000000000000","avg_total_amount":"1.00000000000000000000"}},{"id":1372,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73","product_type":4,"product_component":43,"product_brand":134,"product_serie":1047,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-01-26 16:48:55","updated_at":"2026-07-04 20:47:05","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"is_renew":false,"in_out_at":"2026-07-04 20:47:05.174817+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":1372,"erp_store_id":2,"outbound":"0","number":"1","inventory":"1","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000"},{"product_id":1372,"erp_store_id":1,"outbound":"34","number":"48","inventory":"14","avg_amount":"22.1666666666666667","avg_total_amount":"55.5000000000000000"}],"erpInventoryCount":{"product_id":1372,"outbound":"34","number":"49","inventory":"15","avg_amount":"19.0000000000000000","avg_total_amount":"47.5714285714285714","amount":"333","inventory_available":15,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":1372,"inventory":"15","avg_amount":16.6,"amount":333},"erpInventoryCount3":[{"id":95,"product_id":1372,"erp_purchase_inbound_id":26,"erp_purchase_order_id":2042,"erp_purchase_inbound_product_id":44,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-27","number":"10","outbound":"1","inventory":"9","amount":"25","total_amount":"250","actual_amount":"25","actual_total_amount":"225","is_build":false,"created_at":"2025-08-27 13:18:21","lost_outbound":"0","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"1","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":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":486,"product_id":1372,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-04-22","number":"1","outbound":"0","inventory":"1","amount":"33","total_amount":"33.00","actual_amount":"33","actual_total_amount":"33","is_build":false,"created_at":"2026-04-23 16:19:02","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":1,"erp_inventory_disassemble_product_id":2,"disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":479,"product_id":1372,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":2,"wrote_date":"2026-04-08","number":"1","outbound":"0","inventory":"1","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-04-08 16:24:05","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":17,"erp_purchase_gift_product_id":18,"sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":480,"product_id":1372,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-04-08","number":"1","outbound":"0","inventory":"1","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-04-08 16:24:05","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":17,"erp_purchase_gift_product_id":19,"sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":44,"product_id":1372,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-08","number":"13","outbound":"10","inventory":"3","amount":"25","total_amount":"325","actual_amount":"25","actual_total_amount":"75","is_build":false,"created_at":"2025-08-08 18:11:19","lost_outbound":"","erp_inventory_start_id":30,"erp_inventory_start_product_id":44,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"10","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1047,"key":1047,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73"},"productUnit":{"id":6,"key":6,"name":"\u6761"},"everyStoreErpInventoryCount2":{"product_id":1372,"erp_store_id":2,"outbound":"0","number":"1","inventory":"1","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000"},"everyStoreErpInventoryCount1":{"product_id":1372,"erp_store_id":1,"outbound":"34","number":"48","inventory":"14","avg_amount":"22.1666666666666667","avg_total_amount":"55.5000000000000000"}},{"id":1025,"name":"FOC-1010","product_type":4,"product_component":43,"product_brand":152,"product_serie":714,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-09-05 11:10:11","updated_at":"2026-07-04 20:47:05","pinyin_shortcut":"FOC1010","product_unit":6,"is_renew":false,"in_out_at":"2026-07-04 20:47:05.174817+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":1025,"erp_store_id":1,"outbound":"0","number":"2","inventory":"2","avg_amount":"10.0000000000000000","avg_total_amount":"20.0000000000000000"}],"erpInventoryCount":{"product_id":1025,"outbound":"0","number":"2","inventory":"2","avg_amount":"10.0000000000000000","avg_total_amount":"20.0000000000000000","amount":"20","inventory_available":2,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":1025,"inventory":"2","avg_amount":10,"amount":20},"erpInventoryCount3":[{"id":45,"product_id":1025,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-08","number":"2","outbound":"0","inventory":"2","amount":"10","total_amount":"20","actual_amount":"10","actual_total_amount":"20","is_build":false,"created_at":"2025-08-08 18:11:19","lost_outbound":"","erp_inventory_start_id":30,"erp_inventory_start_product_id":45,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":152,"key":152,"name":"\u80dc\u4e3a"},"productSerie":{"id":714,"key":714,"name":"\u4e07\u5146\u591a\u6a21\u5149\u7ea4\u8df3\u7ebfLC-LC 1\u7c73"},"productUnit":{"id":6,"key":6,"name":"\u6761"},"everyStoreErpInventoryCount1":{"product_id":1025,"erp_store_id":1,"outbound":"0","number":"2","inventory":"2","avg_amount":"10.0000000000000000","avg_total_amount":"20.0000000000000000"}},{"id":2267,"name":"\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681","product_type":23,"product_component":221,"product_brand":287,"product_serie":1784,"product_misc":"","product_qa":"","pn":"","description":"\u5168\u5e74\u88c5\u793c\u76d2\u5237\u5934*5","created_by":1013,"created_at":"2026-03-20 14:43:11","updated_at":"2026-07-04 20:40:30","pinyin_shortcut":"flpznyyddysHX5681","product_unit":3,"is_renew":false,"in_out_at":"2026-07-04 20:40:30.898817+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":2267,"erp_store_id":1,"outbound":"10","number":"14","inventory":"4","avg_amount":"275.5366000000000000","avg_total_amount":"180.0000000000000000"}],"erpInventoryCount":{"product_id":2267,"outbound":"10","number":"14","inventory":"4","avg_amount":"275.5366000000000000","avg_total_amount":"180.0000000000000000","amount":"900.000","inventory_available":4,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":2267,"inventory":"4","avg_amount":150,"amount":900},"erpInventoryCount3":[{"id":531,"product_id":2267,"erp_purchase_inbound_id":216,"erp_purchase_order_id":2223,"erp_purchase_inbound_product_id":437,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-07-04","number":"3","outbound":"0","inventory":"3","amount":"300","total_amount":"900","actual_amount":"300","actual_total_amount":"900","is_build":false,"created_at":"2026-07-04 20:38:24","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":532,"product_id":2267,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-07-04","number":"1","outbound":"0","inventory":"1","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-07-04 20:40:30","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":26,"erp_purchase_gift_product_id":41,"sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":221,"key":221,"name":"\u7535\u5b50\u4ea7\u54c1"},"productBrand":{"id":287,"key":287,"name":"\u98de\u5229\u6d66"},"productSerie":{"id":1784,"key":1784,"name":"\u7535\u52a8\u7259\u5237"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"everyStoreErpInventoryCount1":{"product_id":2267,"erp_store_id":1,"outbound":"10","number":"14","inventory":"4","avg_amount":"275.5366000000000000","avg_total_amount":"180.0000000000000000"}},{"id":969,"name":"PAN-PA-1410","product_type":5,"product_component":26,"product_brand":8,"product_serie":607,"product_misc":"","product_qa":"","pn":"","description":"Palo Alto Networks PA-1410","created_by":1013,"created_at":"2023-08-04 15:49:28","updated_at":"2026-07-03 22:59:46","pinyin_shortcut":"PANPA1410","product_unit":1,"is_renew":false,"in_out_at":"2026-07-03 22:59:46.770949+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":969,"erp_store_id":1,"outbound":"2","number":"123","inventory":"121","avg_amount":"12226.6666666666666667","avg_total_amount":"0.00000000000000000000"}],"erpInventoryCount":{"product_id":969,"outbound":"2","number":"123","inventory":"121","avg_amount":"12226.6666666666666667","avg_total_amount":"0.00000000000000000000","amount":"0","inventory_available":121,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":969,"inventory":"121","avg_amount":0,"amount":0},"erpInventoryCount3":[{"id":522,"product_id":969,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-07-03","number":"55","outbound":"0","inventory":"55","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-07-03 22:39:48","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":25,"erp_purchase_gift_product_id":33,"sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":520,"product_id":969,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-07-03","number":"66","outbound":"0","inventory":"66","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-07-03 22:39:02","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":24,"erp_purchase_gift_product_id":31,"sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":607,"key":607,"name":"PA-1410\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"everyStoreErpInventoryCount1":{"product_id":969,"erp_store_id":1,"outbound":"2","number":"123","inventory":"121","avg_amount":"12226.6666666666666667","avg_total_amount":"0.00000000000000000000"}},{"id":989,"name":"PAN-PA-400-RACKTRAY","product_type":5,"product_component":157,"product_brand":8,"product_serie":615,"product_misc":"","product_qa":"","pn":"","description":"Rack mountable tray for up to two PA-400s and 4 power adapters for a 4 post rack mount (PA-440\/450\/460 models only)","created_by":1013,"created_at":"2023-08-09 16:14:38","updated_at":"2026-07-03 22:59:46","pinyin_shortcut":"PANPA400RACKTRAY","product_unit":2,"is_renew":false,"in_out_at":"2026-07-03 22:59:46.770949+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":989,"erp_store_id":1,"outbound":"1","number":"72","inventory":"71","avg_amount":"577.0000000000000000","avg_total_amount":"0.00000000000000000000"}],"erpInventoryCount":{"product_id":989,"outbound":"1","number":"72","inventory":"71","avg_amount":"577.0000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0","inventory_available":71,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":989,"inventory":"71","avg_amount":0,"amount":0},"erpInventoryCount3":[{"id":521,"product_id":989,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-07-03","number":"66","outbound":"0","inventory":"66","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-07-03 22:39:02","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":24,"erp_purchase_gift_product_id":32,"sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":527,"product_id":989,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-07-03","number":"5","outbound":"0","inventory":"5","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-07-03 22:39:48","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":25,"erp_purchase_gift_product_id":38,"sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":615,"key":615,"name":"PA-440\/450\/460\u5bfc\u8f68"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"everyStoreErpInventoryCount1":{"product_id":989,"erp_store_id":1,"outbound":"1","number":"72","inventory":"71","avg_amount":"577.0000000000000000","avg_total_amount":"0.00000000000000000000"}},{"id":2232,"name":"PAN-SVC-BKLN-3440-3YR","product_type":5,"product_component":214,"product_brand":8,"product_serie":1760,"product_misc":"","product_qa":"","pn":"","description":"Partner enabled premium support 3-year term, PA-3440","created_by":1013,"created_at":"2026-01-12 11:15:06","updated_at":"2026-07-03 22:59:46","pinyin_shortcut":"PANSVCBKLN34403YR","product_unit":2,"is_renew":false,"in_out_at":"2026-07-03 22:59:46.770949+08","inventory_occupied_verifying":"16","everyStoreErpInventoryCount":[{"product_id":2232,"erp_store_id":1,"outbound":"17","number":"56","inventory":"39","avg_amount":"64139.000000000000","avg_total_amount":"0.00000000000000000000"}],"erpInventoryCount":{"product_id":2232,"outbound":"17","number":"56","inventory":"39","avg_amount":"64139.000000000000","avg_total_amount":"0.00000000000000000000","amount":"0","inventory_available":55,"inventory_occupied_verifying":"16"},"erpInventoryCount2":{"product_id":2232,"inventory":"39","avg_amount":0,"amount":0},"erpInventoryCount3":[{"id":529,"product_id":2232,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-07-03","number":"55","outbound":"16","inventory":"39","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-07-03 22:39:48","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":"16","erp_purchase_gift_id":25,"erp_purchase_gift_product_id":40,"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":""}],"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":214,"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1760,"key":1760,"name":"\u4e09\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"everyStoreErpInventoryCount1":{"product_id":2232,"erp_store_id":1,"outbound":"17","number":"56","inventory":"39","avg_amount":"64139.000000000000","avg_total_amount":"0.00000000000000000000"}},{"id":867,"name":"LIS-F1000-AK-IPS-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":1222,"product_misc":"","product_qa":"","pn":"","description":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:44:42","updated_at":"2026-07-03 22:59:46","pinyin_shortcut":"LISF1000AKIPS1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-03 22:59:46.770949+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":867,"erp_store_id":1,"outbound":"1","number":"122","inventory":"121","avg_amount":"259.0000000000000000","avg_total_amount":"0.00000000000000000000"}],"erpInventoryCount":{"product_id":867,"outbound":"1","number":"122","inventory":"121","avg_amount":"259.0000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0","inventory_available":121,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":867,"inventory":"121","avg_amount":0,"amount":0},"erpInventoryCount3":[{"id":518,"product_id":867,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-07-03","number":"66","outbound":"0","inventory":"66","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-07-03 22:39:02","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":24,"erp_purchase_gift_product_id":29,"sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":524,"product_id":867,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-07-03","number":"55","outbound":"0","inventory":"55","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-07-03 22:39:48","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":25,"erp_purchase_gift_product_id":35,"sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1222,"key":1222,"name":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"},"everyStoreErpInventoryCount1":{"product_id":867,"erp_store_id":1,"outbound":"1","number":"122","inventory":"121","avg_amount":"259.0000000000000000","avg_total_amount":"0.00000000000000000000"}},{"id":868,"name":"LIS-F1000-AK-URL-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":1223,"product_misc":"","product_qa":"","pn":"","description":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:45:05","updated_at":"2026-07-03 22:59:46","pinyin_shortcut":"LISF1000AKURL1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-03 22:59:46.770949+08","inventory_occupied_verifying":"9","everyStoreErpInventoryCount":[{"product_id":868,"erp_store_id":1,"outbound":"10","number":"723","inventory":"713","avg_amount":"178.2500000000000000","avg_total_amount":"0.00000000000000000000"}],"erpInventoryCount":{"product_id":868,"outbound":"10","number":"723","inventory":"713","avg_amount":"178.2500000000000000","avg_total_amount":"0.00000000000000000000","amount":"0","inventory_available":722,"inventory_occupied_verifying":"9"},"erpInventoryCount2":{"product_id":868,"inventory":"713","avg_amount":0,"amount":0},"erpInventoryCount3":[{"id":523,"product_id":868,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-07-03","number":"55","outbound":"0","inventory":"55","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-07-03 22:39:48","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":25,"erp_purchase_gift_product_id":34,"sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":516,"product_id":868,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-07-03","number":"666","outbound":"8","inventory":"658","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-07-03 22:39:02","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":"8","erp_purchase_gift_id":24,"erp_purchase_gift_product_id":27,"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":""}],"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1223,"key":1223,"name":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd"},"productUnit":{"id":8,"key":8,"name":"\u5e74"},"everyStoreErpInventoryCount1":{"product_id":868,"erp_store_id":1,"outbound":"10","number":"723","inventory":"713","avg_amount":"178.2500000000000000","avg_total_amount":"0.00000000000000000000"}},{"id":870,"name":"LIS-F1000-AK-AV-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":551,"product_misc":"","product_qa":"","pn":"","description":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:46:22","updated_at":"2026-07-03 22:59:46","pinyin_shortcut":"LISF1000AKAV1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-03 22:59:46.770949+08","inventory_occupied_verifying":"17","everyStoreErpInventoryCount":[{"product_id":870,"erp_store_id":1,"outbound":"18","number":"122","inventory":"104","avg_amount":"291.3333333333333333","avg_total_amount":"0.00000000000000000000"}],"erpInventoryCount":{"product_id":870,"outbound":"18","number":"122","inventory":"104","avg_amount":"291.3333333333333333","avg_total_amount":"0.00000000000000000000","amount":"0","inventory_available":121,"inventory_occupied_verifying":"17"},"erpInventoryCount2":{"product_id":870,"inventory":"104","avg_amount":0,"amount":0},"erpInventoryCount3":[{"id":525,"product_id":870,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-07-03","number":"55","outbound":"0","inventory":"55","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-07-03 22:39:48","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":25,"erp_purchase_gift_product_id":36,"sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":517,"product_id":870,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-07-03","number":"66","outbound":"17","inventory":"49","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-07-03 22:39:02","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":"17","erp_purchase_gift_id":24,"erp_purchase_gift_product_id":28,"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":""}],"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":551,"key":551,"name":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License"},"productUnit":{"id":8,"key":8,"name":"\u5e74"},"everyStoreErpInventoryCount1":{"product_id":870,"erp_store_id":1,"outbound":"18","number":"122","inventory":"104","avg_amount":"291.3333333333333333","avg_total_amount":"0.00000000000000000000"}},{"id":1558,"name":"PAN-PA-1420","product_type":5,"product_component":26,"product_brand":8,"product_serie":1344,"product_misc":"","product_qa":"","pn":"","description":"Palo Alto Networks PA-1420","created_by":1013,"created_at":"2024-04-15 15:38:17","updated_at":"2026-07-03 22:59:46","pinyin_shortcut":"PANPA1420","product_unit":1,"is_renew":false,"in_out_at":"2026-07-03 22:59:46.770949+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":1558,"erp_store_id":1,"outbound":"2","number":"126","inventory":"124","avg_amount":"19849.775000000000","avg_total_amount":"0.00000000000000000000"}],"erpInventoryCount":{"product_id":1558,"outbound":"2","number":"126","inventory":"124","avg_amount":"19849.775000000000","avg_total_amount":"0.00000000000000000000","amount":"0.0","inventory_available":124,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":1558,"inventory":"124","avg_amount":0,"amount":0},"erpInventoryCount3":[{"id":514,"product_id":1558,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-06-05","number":"3","outbound":"0","inventory":"3","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-07-02 10:50:14","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":22,"erp_purchase_gift_product_id":24,"sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":515,"product_id":1558,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-07-03","number":"66","outbound":"0","inventory":"66","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-07-03 22:39:02","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":24,"erp_purchase_gift_product_id":26,"sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":526,"product_id":1558,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-07-03","number":"55","outbound":"0","inventory":"55","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-07-03 22:39:48","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":25,"erp_purchase_gift_product_id":37,"sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1344,"key":1344,"name":"PA-1420\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"everyStoreErpInventoryCount1":{"product_id":1558,"erp_store_id":1,"outbound":"2","number":"126","inventory":"124","avg_amount":"19849.775000000000","avg_total_amount":"0.00000000000000000000"}},{"id":2231,"name":"PAN-PA-3440-ATP-3YR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1759,"product_misc":"","product_qa":"","pn":"","description":"dvanced Threat Prevention subscription 3-year term, PA-3440","created_by":1013,"created_at":"2026-01-12 11:13:10","updated_at":"2026-07-03 22:59:46","pinyin_shortcut":"PANPA3440ATP3YR","product_unit":2,"is_renew":false,"in_out_at":"2026-07-03 22:59:46.770949+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":2231,"erp_store_id":1,"outbound":"1","number":"122","inventory":"121","avg_amount":"81196.000000000000","avg_total_amount":"0.00000000000000000000"}],"erpInventoryCount":{"product_id":2231,"outbound":"1","number":"122","inventory":"121","avg_amount":"81196.000000000000","avg_total_amount":"0.00000000000000000000","amount":"0","inventory_available":121,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":2231,"inventory":"121","avg_amount":0,"amount":0},"erpInventoryCount3":[{"id":519,"product_id":2231,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-07-03","number":"66","outbound":"0","inventory":"66","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-07-03 22:39:02","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":24,"erp_purchase_gift_product_id":30,"sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":528,"product_id":2231,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-07-03","number":"55","outbound":"0","inventory":"55","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-07-03 22:39:48","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":25,"erp_purchase_gift_product_id":39,"sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1759,"key":1759,"name":"PA3440\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"everyStoreErpInventoryCount1":{"product_id":2231,"erp_store_id":1,"outbound":"1","number":"122","inventory":"121","avg_amount":"81196.000000000000","avg_total_amount":"0.00000000000000000000"}},{"id":1562,"name":"PAN-PWR-450W-AC","product_type":5,"product_component":36,"product_brand":8,"product_serie":1244,"product_misc":"","product_qa":"","pn":"","description":"PA-3400,PA-1400, ION 5200 and ION 9200 450W spare power supply","created_by":1013,"created_at":"2024-04-15 15:40:42","updated_at":"2026-06-26 17:28:49","pinyin_shortcut":"PANPWR450WAC","product_unit":2,"is_renew":false,"in_out_at":"2026-06-26 17:28:49.689912+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":1562,"erp_store_id":1,"outbound":"2","number":"4","inventory":"2","avg_amount":"9606.9250000000000000","avg_total_amount":"9540.8500000000000000"}],"erpInventoryCount":{"product_id":1562,"outbound":"2","number":"4","inventory":"2","avg_amount":"9606.9250000000000000","avg_total_amount":"9540.8500000000000000","amount":"19081.70","inventory_available":2,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":1562,"inventory":"2","avg_amount":9540.85,"amount":19081.7},"erpInventoryCount3":[{"id":490,"product_id":1562,"erp_purchase_inbound_id":211,"erp_purchase_order_id":2204,"erp_purchase_inbound_product_id":427,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-04-30","number":"2","outbound":"0","inventory":"2","amount":"9540.85","total_amount":"19081.7","actual_amount":"9540.85","actual_total_amount":"19081.7","is_build":false,"created_at":"2026-04-30 14:34:15","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1244,"key":1244,"name":"PA1420\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"everyStoreErpInventoryCount1":{"product_id":1562,"erp_store_id":1,"outbound":"2","number":"4","inventory":"2","avg_amount":"9606.9250000000000000","avg_total_amount":"9540.8500000000000000"}},{"id":2177,"name":"\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0","product_type":7,"product_component":139,"product_brand":12,"product_serie":1730,"product_misc":"","product_qa":"","pn":"","description":"\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0\uff08\u7eaf\u8f6f\u7248\uff09\n\u4e91\u7aef\u667a\u80fd\u5927\u8111\u8f6f\u4ef6\uff0c\u5305\u542b\u4ee5\u4e0b\u80fd\u529b\uff1a\n1. 7*24H\u5168\u6808\u5728\u7ebf\u76d1\u6d4b\uff0c\u5305\u62ec\u670d\u52a1\u5668\u786c\u4ef6\u3001\u4e91\u5e73\u53f0\u3001\u4e91\u4e3b\u673aOS\u7b49\uff1b\n2. \u98ce\u9669\u4e3b\u52a8\u9884\u6d4b\uff0c\u5305\u62ec\u786c\u76d8\u5361\u6162\/\u574f\u9053\u3001SDD\u5bff\u547d\u3001\u5185\u5b58ECC\u9519\u8bef\u3001\u5e73\u53f0HA\u5931\u6548\u7b49\u98ce\u9669\u63d0\u524d\u9884\u8b66\uff1b\n3. \u98ce\u9669\/\u6545\u969c\u53ca\u65f6\u544a\u8b66\uff0c\u652f\u6301\u5c0f\u7a0b\u5e8f\u3001\u77ed\u4fe1\u3001\u90ae\u4ef6\u3001\u8bed\u97f3\u3001\u4f01\u4e1a\u5fae\u4fe1\/\u9489\u9489\/\u98de\u4e66\u673a\u5668\u4eba\u7b49\u591a\u901a\u8def\u901a\u77e5\uff1b\n4. \u4e91\u7aef\u667a\u80fd\u8fd0\u7ef4\uff0c\u652f\u6301\u544a\u8b66\u964d\u566a\u3001\u6839\u56e0\u5206\u6790\u548c\u5f71\u54cd\u9762\u8bc4\u4f30\uff0c\u63d0\u5347\u95ee\u9898\u5b9a\u4f4d\u6392\u969c\u6548\u7387\uff1b\n5. \u8fd0\u7ef4\u62a5\u544a\u8ba2\u9605\uff0c\u5e73\u53f0\u652f\u6301\u751f\u6210\u8fd0\u7ef4\u62a5\u544a\uff0c\u5305\u62ec\u5e73\u53f0\u670d\u52a1\u5668\u5065\u5eb7\u98ce\u9669\u9884\u6d4b\u548c\u8bc4\u4f30\uff08\u5982\uff1aCPU\/\u5185\u5b58\/\u786c\u76d8\/Raid\u5361\/\u7f51\u5361\u7b49\uff09\u3001\u4e91\u4e3b\u673a\u8fd0\u884c\u72b6\u6001\uff08\u5982\uff1aCPU\/\u5185\u5b58\/\u7f51\u7edc\u7b49\uff09\u98ce\u9669\u8bc4\u4f30\u7b49\uff1b\n\u914d\u5957\u670d\u52a1\u5982\u4e0b\uff1a\n\u8f6f\u4ef6\u5347\u7ea7\uff0c\u5305\u62ec\uff1a\u4e3b\u7ebf\u7248\u672c\/R\u7248\u672c\/SP\u7248\u672c\u7b49\u5728\u7ebf\u5347\u7ea7\u548c\u5b9a\u671f\u8865\u4e01\u66f4\u65b0\uff1b","created_by":1013,"created_at":"2025-11-28 11:49:14","updated_at":"2026-06-26 15:59:48","pinyin_shortcut":"sxfSDDCjcywrjV10","product_unit":2,"is_renew":false,"in_out_at":"2026-06-26 15:59:48.583981+08","inventory_occupied_verifying":"1","everyStoreErpInventoryCount":[{"product_id":2177,"erp_store_id":1,"outbound":"11","number":"12","inventory":"1","avg_amount":"29895.980000000000","avg_total_amount":"0.10000000000000000000"},{"product_id":2177,"erp_store_id":2,"outbound":"1","number":"2","inventory":"1","avg_amount":"888.0000000000000000","avg_total_amount":"444.0000000000000000"}],"erpInventoryCount":{"product_id":2177,"outbound":"12","number":"14","inventory":"2","avg_amount":"25061.316666666667","avg_total_amount":"74.0833333333333333","amount":"889.00","inventory_available":3,"inventory_occupied_verifying":"1"},"erpInventoryCount2":{"product_id":2177,"inventory":"2","avg_amount":444.5,"amount":889},"erpInventoryCount3":[{"id":506,"product_id":2177,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":2,"wrote_date":"2026-05-20","number":"2","outbound":"1","inventory":"1","amount":"888","total_amount":"1776.00","actual_amount":"888","actual_total_amount":"888","is_build":false,"created_at":"2026-05-20 14:04:06","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":"1","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":4,"erp_inventory_overflow_product_id":4},{"id":469,"product_id":2177,"erp_purchase_inbound_id":202,"erp_purchase_order_id":2206,"erp_purchase_inbound_product_id":414,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-03-31","number":"1","outbound":"0","inventory":"1","amount":"1","total_amount":"1","actual_amount":"1","actual_total_amount":"1","is_build":false,"created_at":"2026-03-31 17:32:55","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":""}],"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":139,"key":139,"name":"\u8d85\u878d\u5408\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1730,"key":1730,"name":"\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"everyStoreErpInventoryCount1":{"product_id":2177,"erp_store_id":1,"outbound":"11","number":"12","inventory":"1","avg_amount":"29895.980000000000","avg_total_amount":"0.10000000000000000000"},"everyStoreErpInventoryCount2":{"product_id":2177,"erp_store_id":2,"outbound":"1","number":"2","inventory":"1","avg_amount":"888.0000000000000000","avg_total_amount":"444.0000000000000000"}},{"id":2262,"name":"PAN-SFP-PLUS-SR","product_type":5,"product_component":157,"product_brand":8,"product_serie":1781,"product_misc":"","product_qa":"","pn":"","description":"SFP+ form factor, SR 10Gb optical transceiver, short reach 300m, OM3 MMF, duplex LC, IEEE 802.3ae 10GBASE-SR compliant","created_by":1013,"created_at":"2026-03-17 14:26:23","updated_at":"2026-06-26 14:39:52","pinyin_shortcut":"PANSFPPLUSSR","product_unit":3,"is_renew":false,"in_out_at":"2026-06-26 14:39:52.094142+08","inventory_occupied_verifying":"1","everyStoreErpInventoryCount":[{"product_id":2262,"erp_store_id":1,"outbound":"1","number":"3","inventory":"2","avg_amount":"9540.8500000000000000","avg_total_amount":"9540.8500000000000000"},{"product_id":2262,"erp_store_id":2,"outbound":"0","number":"1","inventory":"1","avg_amount":"1.00000000000000000000","avg_total_amount":"1.00000000000000000000"}],"erpInventoryCount":{"product_id":2262,"outbound":"1","number":"4","inventory":"3","avg_amount":"6360.9000000000000000","avg_total_amount":"6360.9000000000000000","amount":"19082.70","inventory_available":4,"inventory_occupied_verifying":"1"},"erpInventoryCount2":{"product_id":2262,"inventory":"3","avg_amount":4770.93,"amount":19082.7},"erpInventoryCount3":[{"id":505,"product_id":2262,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":2,"wrote_date":"2026-05-20","number":"1","outbound":"0","inventory":"1","amount":"1","total_amount":"1.00","actual_amount":"1","actual_total_amount":"1","is_build":false,"created_at":"2026-05-20 14:04:02","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":5,"erp_inventory_overflow_product_id":9},{"id":493,"product_id":2262,"erp_purchase_inbound_id":211,"erp_purchase_order_id":2204,"erp_purchase_inbound_product_id":430,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-04-30","number":"2","outbound":"0","inventory":"2","amount":"9540.85","total_amount":"19081.7","actual_amount":"9540.85","actual_total_amount":"19081.7","is_build":false,"created_at":"2026-04-30 14:34:15","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1781,"key":1781,"name":"\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"everyStoreErpInventoryCount1":{"product_id":2262,"erp_store_id":1,"outbound":"1","number":"3","inventory":"2","avg_amount":"9540.8500000000000000","avg_total_amount":"9540.8500000000000000"},"everyStoreErpInventoryCount2":{"product_id":2262,"erp_store_id":2,"outbound":"0","number":"1","inventory":"1","avg_amount":"1.00000000000000000000","avg_total_amount":"1.00000000000000000000"}},{"id":2171,"name":"\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1","product_type":7,"product_component":159,"product_brand":270,"product_serie":1724,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-11-24 16:16:45","updated_at":"2026-06-23 13:48:49","pinyin_shortcut":"jcxCRMrjfw","product_unit":2,"is_renew":false,"in_out_at":"2026-06-23 13:48:49.894578+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":2171,"erp_store_id":2,"outbound":"0","number":"1","inventory":"1","avg_amount":"1.00000000000000000000","avg_total_amount":"1.00000000000000000000"},{"product_id":2171,"erp_store_id":1,"outbound":"2","number":"4","inventory":"2","avg_amount":"150.0000000000000000","avg_total_amount":"150.0000000000000000"}],"erpInventoryCount":{"product_id":2171,"outbound":"2","number":"5","inventory":"3","avg_amount":"120.2000000000000000","avg_total_amount":"120.2000000000000000","amount":"601","inventory_available":3,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":2171,"inventory":"3","avg_amount":200.33,"amount":601},"erpInventoryCount3":[{"id":512,"product_id":2171,"erp_purchase_inbound_id":215,"erp_purchase_order_id":2223,"erp_purchase_inbound_product_id":435,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-06-23","number":"1","outbound":"0","inventory":"1","amount":"600","total_amount":"600","actual_amount":"600","actual_total_amount":"600","is_build":false,"created_at":"2026-06-23 13:46:50","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":487,"product_id":2171,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-04-30","number":"1","outbound":"0","inventory":"1","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-04-30 13:38:29","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":21,"erp_purchase_gift_product_id":23,"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":""},{"id":503,"product_id":2171,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":2,"wrote_date":"2026-05-20","number":"1","outbound":"0","inventory":"1","amount":"1","total_amount":"1.00","actual_amount":"1","actual_total_amount":"1","is_build":false,"created_at":"2026-05-20 14:04:02","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":5,"erp_inventory_overflow_product_id":7}],"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":159,"key":159,"name":"\u529e\u516c\u8f6f\u4ef6"},"productBrand":{"id":270,"key":270,"name":"\u91d1\u7545\u900d"},"productSerie":{"id":1724,"key":1724,"name":"\u91d1\u7545\u900dCRM\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"everyStoreErpInventoryCount2":{"product_id":2171,"erp_store_id":2,"outbound":"0","number":"1","inventory":"1","avg_amount":"1.00000000000000000000","avg_total_amount":"1.00000000000000000000"},"everyStoreErpInventoryCount1":{"product_id":2171,"erp_store_id":1,"outbound":"2","number":"4","inventory":"2","avg_amount":"150.0000000000000000","avg_total_amount":"150.0000000000000000"}},{"id":2269,"name":"HAT5320-24T","product_type":3,"product_component":15,"product_brand":27,"product_serie":1786,"product_misc":"","product_qa":"","pn":"","description":"24T 3.5\" 7.2K SATA HDD","created_by":1013,"created_at":"2026-03-23 09:37:57","updated_at":"2026-06-08 18:13:18","pinyin_shortcut":"HAT532024T","product_unit":4,"is_renew":false,"in_out_at":"2026-06-08 18:13:18.8309+08","inventory_occupied_verifying":"10","everyStoreErpInventoryCount":[{"product_id":2269,"erp_store_id":2,"outbound":"4","number":"5","inventory":"1","avg_amount":"0.50000000000000000000","avg_total_amount":"0.50000000000000000000"},{"product_id":2269,"erp_store_id":1,"outbound":"69","number":"77","inventory":"8","avg_amount":"4517.6923076923076923","avg_total_amount":"7010.2307692307692308"}],"erpInventoryCount":{"product_id":2269,"outbound":"73","number":"82","inventory":"9","avg_amount":"3915.4000000000000000","avg_total_amount":"6075.6000000000000000","amount":"91134","inventory_available":19,"inventory_occupied_verifying":"10"},"erpInventoryCount2":{"product_id":2269,"inventory":"9","avg_amount":7594.83,"amount":91134},"erpInventoryCount3":[{"id":474,"product_id":2269,"erp_purchase_inbound_id":206,"erp_purchase_order_id":2208,"erp_purchase_inbound_product_id":421,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-04-08","number":"2","outbound":"0","inventory":"2","amount":"2323","total_amount":"4646","actual_amount":"2323","actual_total_amount":"4646","is_build":false,"created_at":"2026-04-08 11:02:21","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":482,"product_id":2269,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-04-09","number":"2","outbound":"1","inventory":"1","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-04-09 10:28:25","lost_outbound":"0","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"1","sales_outbound":"0","erp_purchase_gift_id":19,"erp_purchase_gift_product_id":21,"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":""},{"id":495,"product_id":2269,"erp_purchase_inbound_id":214,"erp_purchase_order_id":2209,"erp_purchase_inbound_product_id":433,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-05-12","number":"1","outbound":"0","inventory":"1","amount":"3","total_amount":"3.00","actual_amount":"3","actual_total_amount":"3","is_build":false,"created_at":"2026-05-12 14:24:10","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":484,"product_id":2269,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-04-23","number":"2","outbound":"0","inventory":"2","amount":"43242","total_amount":"86484.00","actual_amount":"43242","actual_total_amount":"86484","is_build":false,"created_at":"2026-04-23 16:16:15","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":2,"erp_inventory_disassemble_product_id":3,"disassemble_spent_outbound":"0","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":504,"product_id":2269,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":2,"wrote_date":"2026-05-20","number":"1","outbound":"0","inventory":"1","amount":"1","total_amount":"1.00","actual_amount":"1","actual_total_amount":"1","is_build":false,"created_at":"2026-05-20 14:04:02","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":5,"erp_inventory_overflow_product_id":8},{"id":481,"product_id":2269,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-04-09","number":"2","outbound":"0","inventory":"2","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-04-09 10:27:35","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":18,"erp_purchase_gift_product_id":20,"sales_gift_outbound":"0","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1786,"key":1786,"name":"HAT5300 \u7cfb\u5217\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"},"everyStoreErpInventoryCount2":{"product_id":2269,"erp_store_id":2,"outbound":"4","number":"5","inventory":"1","avg_amount":"0.50000000000000000000","avg_total_amount":"0.50000000000000000000"},"everyStoreErpInventoryCount1":{"product_id":2269,"erp_store_id":1,"outbound":"69","number":"77","inventory":"8","avg_amount":"4517.6923076923076923","avg_total_amount":"7010.2307692307692308"}},{"id":2242,"name":"CB-992F","product_type":21,"product_component":227,"product_brand":278,"product_serie":1767,"product_misc":"","product_qa":"","pn":"","description":"\u9ad8\u6e05\u5206\u8fa8\u73871920*1080\u3001\u5bf9\u6bd4\u5ea616000:1\u30014000\u6d41\u660e\uff0c\u767d\u5929\u76f4\u6295","created_by":1013,"created_at":"2026-01-29 14:25:19","updated_at":"2026-03-31 17:15:49","pinyin_shortcut":"CB992F","product_unit":1,"is_renew":false,"in_out_at":"2026-03-31 17:15:49.970866+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":2242,"erp_store_id":1,"outbound":"6","number":"10","inventory":"4","avg_amount":"17028.333333333333","avg_total_amount":"59393.333333333333"}],"erpInventoryCount":{"product_id":2242,"outbound":"6","number":"10","inventory":"4","avg_amount":"17028.333333333333","avg_total_amount":"59393.333333333333","amount":"178180","inventory_available":4,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":2242,"inventory":"4","avg_amount":44545,"amount":178180},"erpInventoryCount3":[{"id":465,"product_id":2242,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-03-31","number":"4","outbound":"0","inventory":"4","amount":"44545","total_amount":"178180.00","actual_amount":"44545","actual_total_amount":"178180","is_build":false,"created_at":"2026-03-31 16:41:14","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":5,"erp_inventory_build_product_id":5,"build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907"},"productComponent":{"id":227,"key":227,"name":"\u6295\u5f71\u673a"},"productBrand":{"id":278,"key":278,"name":"\u7231\u666e\u751f"},"productSerie":{"id":1767,"key":1767,"name":"\u9ad8\u4eae\u5546\u6559\u6295\u5f71\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"everyStoreErpInventoryCount1":{"product_id":2242,"erp_store_id":1,"outbound":"6","number":"10","inventory":"4","avg_amount":"17028.333333333333","avg_total_amount":"59393.333333333333"}},{"id":2255,"name":"\u6295\u5f71\u4eea\u5b89\u88c5\u914d\u4ef6\u8f85\u6599","product_type":21,"product_component":229,"product_brand":134,"product_serie":1776,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-02-04 16:29:24","updated_at":"2026-03-20 15:12:53","pinyin_shortcut":"tyyazpjfl","product_unit":2,"is_renew":false,"in_out_at":"2026-03-20 15:12:53.544213+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":2255,"erp_store_id":1,"outbound":"0","number":"4","inventory":"4","avg_amount":"285.0000000000000000","avg_total_amount":"1140.0000000000000000"}],"erpInventoryCount":{"product_id":2255,"outbound":"0","number":"4","inventory":"4","avg_amount":"285.0000000000000000","avg_total_amount":"1140.0000000000000000","amount":"1140","inventory_available":4,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":2255,"inventory":"4","avg_amount":285,"amount":1140},"erpInventoryCount3":[{"id":457,"product_id":2255,"erp_purchase_inbound_id":195,"erp_purchase_order_id":2188,"erp_purchase_inbound_product_id":402,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-03-20","number":"4","outbound":"0","inventory":"4","amount":"285","total_amount":"1140.00","actual_amount":"285","actual_total_amount":"1140","is_build":false,"created_at":"2026-03-20 15:12:53","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907"},"productComponent":{"id":229,"key":229,"name":"\u6570\u7801\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1776,"key":1776,"name":"\u6295\u5f71\u4eea\u5b89\u88c5\u914d\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"everyStoreErpInventoryCount1":{"product_id":2255,"erp_store_id":1,"outbound":"0","number":"4","inventory":"4","avg_amount":"285.0000000000000000","avg_total_amount":"1140.0000000000000000"}},{"id":2074,"name":"\u4e50\u4e8b\u5370\u52a0\u971e\u591a\u4e3d\u767d\u8461\u8404\u9152","product_type":23,"product_component":194,"product_brand":256,"product_serie":1676,"product_misc":"","product_qa":"","pn":"","description":"705ML","created_by":1001,"created_at":"2025-08-08 16:47:20","updated_at":"2026-03-16 13:47:44","pinyin_shortcut":"lsyjxdlbptj","product_unit":11,"is_renew":false,"in_out_at":"2026-03-16 13:47:44.809959+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":2074,"erp_store_id":1,"outbound":"24","number":"48","inventory":"24","avg_amount":"150.0000000000000000","avg_total_amount":"3600.0000000000000000"}],"erpInventoryCount":{"product_id":2074,"outbound":"24","number":"48","inventory":"24","avg_amount":"150.0000000000000000","avg_total_amount":"3600.0000000000000000","amount":"3600","inventory_available":24,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":2074,"inventory":"24","avg_amount":150,"amount":3600},"erpInventoryCount3":[{"id":12,"product_id":2074,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-08","number":"48","outbound":"24","inventory":"24","amount":"150","total_amount":"7200","actual_amount":"150","actual_total_amount":"3600","is_build":false,"created_at":"2025-08-08 16:47:56","lost_outbound":"","erp_inventory_start_id":6,"erp_inventory_start_product_id":12,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"24","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":194,"key":194,"name":"\u70df\u9152\u8336\u53f6"},"productBrand":{"id":256,"key":256,"name":"\u4e50\u4e8b\u5370\u52a0"},"productSerie":{"id":1676,"key":1676,"name":"\u7ea2\u9152"},"productUnit":{"id":11,"key":11,"name":"\u74f6"},"everyStoreErpInventoryCount1":{"product_id":2074,"erp_store_id":1,"outbound":"24","number":"48","inventory":"24","avg_amount":"150.0000000000000000","avg_total_amount":"3600.0000000000000000"}}],"pagenation":{"totalcount":40,"thispage":1,"pagesize":20},"can_create_inventory_lost":true,"can_create_inventory_overflow":true,"can_create_inventory_build":true,"can_create_inventory_disassemble":true,"count":{"inventory":"1725","total_amount":499898.29166667,"inventory_available":1785,"total_amount_available":"411926.2366666664","inventory_occupied_verifying":"60","total_amount_occupied_verifying":"87972.055"}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"111.194.208.14","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-07-04 21:22:30', 78253056) RETURNING "id"
21:22:30.8111.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE (inventory > 0) AND ("product_id" IN (2261, 1372, 1025, 2267, 969, 989, 2232, 867, 868, 870, 1558, 2231, 1562, 2177, 2262, 2171, 2269, 2242, 2255, 2074))
21:22:30.8071.1 msyii\db\Command::querySELECT "product_id", "erp_store_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(amount) as avg_amount, avg(amount * inventory) as avg_total_amount FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "product_id" IN (2261, 1372, 1025, 2267, 969, 989, 2232, 867, 868, 870, 1558, 2231, 1562, 2177, 2262, 2171, 2269, 2242, 2255, 2074) GROUP BY "product_id", "erp_store_id"
21:22:30.8091.0 msyii\db\Command::querySELECT "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 "a57be577deb434"."tbl_erp_inventory_products" "eip" WHERE "product_id" IN (2261, 1372, 1025, 2267, 969, 989, 2232, 867, 868, 870, 1558, 2231, 1562, 2177, 2262, 2171, 2269, 2242, 2255, 2074) GROUP BY "eip"."product_id"
21:22:30.7701.0 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5064
21:22:30.8100.9 msyii\db\Command::querySELECT "product_id", sum(inventory) as inventory, avg(actual_amount) as avg_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE (inventory > 0) AND ("product_id" IN (2261, 1372, 1025, 2267, 969, 989, 2232, 867, 868, 870, 1558, 2231, 1562, 2177, 2262, 2171, 2269, 2242, 2255, 2074)) GROUP BY "product_id"
21:22:30.7720.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
21:22:30.8200.6 msyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "is_delete"=FALSE ORDER BY "sort", "id"
21:22:30.7690.5 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
21:22:30.7740.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
21:22:30.8130.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (4, 23, 5, 7, 3, 21)
21:22:30.8150.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1769, 1047, 714, 1784, 607, 615, 1760, 1222, 1223, 551, 1344, 1759, 1244, 1730, 1781, 1724, 1786, 1767, 1776, 1676)
21:22:30.8160.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (3, 6, 1, 2, 8, 4, 11)
21:22:30.8140.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (52, 43, 221, 26, 157, 214, 35, 36, 139, 159, 15, 227, 229, 194)
21:22:30.8140.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (4, 134, 152, 287, 8, 20, 12, 270, 27, 278, 256)