ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a4c7ba12e2fb: POST https://beta.jinchangxiao.com/vue/erp-sales-order-outbound-statistics/list at 2026-07-07 12:08:01 pm by 114.244.130.20

Log Messages

总计49条数据
TimeLevelCategoryMessage
 
12:08:01.188traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
12:08:01.188traceyii\base\Module::getModuleLoading module: debug
12:08:01.189traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
12:08:01.189traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
12:08:01.189traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
12:08:01.190traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:08:01.190infotime tracing start1783397281190692864
12:08:01.191traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
12:08:01.191traceyii\web\Application::handleRequestRoute requested: 'vue/erp-sales-order-outbound-statistics/list'
12:08:01.191traceyii\base\Module::getModuleLoading module: vue
12:08:01.192infoyii\web\Session::openSession started
12:08:01.194infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
12:08:01.194infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
12:08:01.196traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:08:01.197traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
12:08:01.198infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
12:08:01.199traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:08:01.200traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
12:08:01.200infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
12:08:01.201traceyii\base\Controller::runActionRoute to run: vue/erp-sales-order-outbound-statistics/list
12:08:01.202traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:08:01.205traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
12:08:01.205traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ErpSalesOrderOutboundStatisticsController::actionList()
12:08:01.207traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:08:01.208traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:08:01.210infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" ORDER BY "id"
12:08:01.212infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT epop.*, COALESCE(max(outbound_count.outbound_number), 0) as outbound_number_count, COALESCE(max(return_count.return_number), 0) as return_number_count, epop.number - COALESCE(max(outbound_count.outbound_number), 0) + COALESCE(max(return_count.return_number), 0) as un_outbound_sort, max(eso.created_at) as sales_order_created_at FROM "a57be577deb434"."tbl_erp_sales_order_products" "epop" INNER JOIN "a57be577deb434"."tbl_erp_sales_orders" "eso" ON eso.id = epop.erp_sales_order_id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = eso.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON project.id = eso.project_id LEFT JOIN "a57be577deb434"."tbl_products" "product" ON product.id = epop.product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_order_verify_rels" "rvr" ON rvr.erp_sales_order_id = eso.id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "purchase_rel" ON purchase_rel.project_id = eso.project_id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "purchase_contract" ON purchase_contract.id = purchase_rel.contract_id AND purchase_contract.cost_type = 1 LEFT JOIN (SELECT esop.erp_sales_order_product_id, sum(esop.number) as outbound_number FROM "a57be577deb434"."tbl_erp_sales_outbound_products" "esop" INNER JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esob" ON esob.id = esop.erp_sales_outbound_id WHERE "esob"."status" IN (1, 2, 5) GROUP BY "esop"."erp_sales_order_product_id") "outbound_count" ON outbound_count.erp_sales_order_product_id = epop.id LEFT JOIN (SELECT esop.erp_sales_order_product_id, sum(esrp.number) as return_number FROM "a57be577deb434"."tbl_erp_sales_return_products" "esrp" INNER JOIN "a57be577deb434"."tbl_erp_sales_returns" "esr" ON esr.id = esrp.erp_sales_return_id INNER JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esosp" ON esosp.id = esrp.erp_sales_outbound_spent_product_id INNER JOIN "a57be577deb434"."tbl_erp_sales_outbound_products" "esop" ON esop.id = esosp.erp_sales_outbound_product_id INNER JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esob" ON esob.id = esop.erp_sales_outbound_id WHERE ("esr"."status" IN (2, 5)) AND ("esob"."status" IN (1, 2, 5)) GROUP BY "esop"."erp_sales_order_product_id") "return_count" ON return_count.erp_sales_order_product_id = epop.id WHERE (("eso"."status"=2) AND ("eso"."is_done"=FALSE)) AND ("epop"."number" > 0) AND (("client"."sales_rep"=1001) OR ("eso"."created_by"=1001) OR ("rvr"."user_id"=1001) OR ("eso"."created_by" IN (1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1025, 1026, 1027, 1028, 1029, 1030, 5015, 5016, 5022, 5023, 5024, 5025, 5026, 5027, 5028, 5029, 5030, 5031, 5032, 5033, 5037, 5043, 5044, 5045, 5047, 5048, 5049, 5050, 5062, 5063, 5064, 5065, 5066, 5069, 5070, 5071, 5072, 5073, 5074, 5075, 5076, 5078, 5079, 5080, 5081, 5082, 5083, 5085, 5086, 5087, 5088, 5089, 5093, 5094, 5095, 5096, 5101, 5102, 5104, 5105, 5123, 5124, 5125, 5126, 5128, 5135, 5203, 5208, 5209, 5229, 5230, 5247, 5248, 5249, 5250, 5252, 5258, 5259, 5293, 5294, 5295, 5296, 5297, 5298, 5299, 5300, 5301, 5302, 5303, 5304, 5305, 5309, 5311, 5329, 5332, 5333, 5351, 5356, 5357, 5358, 5359, 5360, 5364, 5388, 5393, 5404, 5409, 5411, 5412, 5413, 5419, 5420, 5440, 5445, 5446, 5448, 5449, 5461, 5467, 5476, 5497, 5499, 5500))) GROUP BY "epop"."id" HAVING epop.number - COALESCE(max(outbound_count.outbound_number), 0) + COALESCE(max(return_count.return_number), 0) > 0 ORDER BY un_outbound_sort DESC nulls last, sales_order_created_at DESC, epop.id DESC) "c"
12:08:01.227infoyii\db\Command::querySELECT epop.*, COALESCE(max(outbound_count.outbound_number), 0) as outbound_number_count, COALESCE(max(return_count.return_number), 0) as return_number_count, epop.number - COALESCE(max(outbound_count.outbound_number), 0) + COALESCE(max(return_count.return_number), 0) as un_outbound_sort, max(eso.created_at) as sales_order_created_at FROM "a57be577deb434"."tbl_erp_sales_order_products" "epop" INNER JOIN "a57be577deb434"."tbl_erp_sales_orders" "eso" ON eso.id = epop.erp_sales_order_id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = eso.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON project.id = eso.project_id LEFT JOIN "a57be577deb434"."tbl_products" "product" ON product.id = epop.product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_order_verify_rels" "rvr" ON rvr.erp_sales_order_id = eso.id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "purchase_rel" ON purchase_rel.project_id = eso.project_id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "purchase_contract" ON purchase_contract.id = purchase_rel.contract_id AND purchase_contract.cost_type = 1 LEFT JOIN (SELECT esop.erp_sales_order_product_id, sum(esop.number) as outbound_number FROM "a57be577deb434"."tbl_erp_sales_outbound_products" "esop" INNER JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esob" ON esob.id = esop.erp_sales_outbound_id WHERE "esob"."status" IN (1, 2, 5) GROUP BY "esop"."erp_sales_order_product_id") "outbound_count" ON outbound_count.erp_sales_order_product_id = epop.id LEFT JOIN (SELECT esop.erp_sales_order_product_id, sum(esrp.number) as return_number FROM "a57be577deb434"."tbl_erp_sales_return_products" "esrp" INNER JOIN "a57be577deb434"."tbl_erp_sales_returns" "esr" ON esr.id = esrp.erp_sales_return_id INNER JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esosp" ON esosp.id = esrp.erp_sales_outbound_spent_product_id INNER JOIN "a57be577deb434"."tbl_erp_sales_outbound_products" "esop" ON esop.id = esosp.erp_sales_outbound_product_id INNER JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esob" ON esob.id = esop.erp_sales_outbound_id WHERE ("esr"."status" IN (2, 5)) AND ("esob"."status" IN (1, 2, 5)) GROUP BY "esop"."erp_sales_order_product_id") "return_count" ON return_count.erp_sales_order_product_id = epop.id WHERE (("eso"."status"=2) AND ("eso"."is_done"=FALSE)) AND ("epop"."number" > 0) AND (("client"."sales_rep"=1001) OR ("eso"."created_by"=1001) OR ("rvr"."user_id"=1001) OR ("eso"."created_by" IN (1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1025, 1026, 1027, 1028, 1029, 1030, 5015, 5016, 5022, 5023, 5024, 5025, 5026, 5027, 5028, 5029, 5030, 5031, 5032, 5033, 5037, 5043, 5044, 5045, 5047, 5048, 5049, 5050, 5062, 5063, 5064, 5065, 5066, 5069, 5070, 5071, 5072, 5073, 5074, 5075, 5076, 5078, 5079, 5080, 5081, 5082, 5083, 5085, 5086, 5087, 5088, 5089, 5093, 5094, 5095, 5096, 5101, 5102, 5104, 5105, 5123, 5124, 5125, 5126, 5128, 5135, 5203, 5208, 5209, 5229, 5230, 5247, 5248, 5249, 5250, 5252, 5258, 5259, 5293, 5294, 5295, 5296, 5297, 5298, 5299, 5300, 5301, 5302, 5303, 5304, 5305, 5309, 5311, 5329, 5332, 5333, 5351, 5356, 5357, 5358, 5359, 5360, 5364, 5388, 5393, 5404, 5409, 5411, 5412, 5413, 5419, 5420, 5440, 5445, 5446, 5448, 5449, 5461, 5467, 5476, 5497, 5499, 5500))) GROUP BY "epop"."id" HAVING epop.number - COALESCE(max(outbound_count.outbound_number), 0) + COALESCE(max(return_count.return_number), 0) > 0 ORDER BY un_outbound_sort DESC nulls last, sales_order_created_at DESC, epop.id DESC LIMIT 20
12:08:01.237traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:08:01.237traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
12:08:01.238infoyii\db\Command::querySELECT "id", "id" AS "key", "serial_no", "status", "client_id", "project_id", "created_at" FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id" IN (1715, 1701, 1711, 1690, 1692, 1681, 1676, 1670, 1699, 1705, 1704, 1659, 1709)
12:08:01.239infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3433, 982, 3389, 2150, 3436, 3286, 2182, 2125, 3359, 3462, 2128)
12:08:01.239infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (4084, 4161, 4167, 4169, 4151, 4155, 4112, 4142, 4139, 4113, 4077, 4174, 3854)
12:08:01.240infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "product_type", "product_component", "product_brand", "product_serie", "product_unit" FROM "a57be577deb434"."tbl_products" WHERE "id" IN (2261, 2177, 2171, 2269, 2262, 2242, 1485, 1483, 1672, 2255, 1528, 1562, 1584, 1504, 2266, 2263, 2265, 2268)
12:08:01.242infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (7, 21, 3, 23, 4, 5)
12:08:01.242infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (28, 32, 159, 188, 229, 29, 14, 15, 227, 195, 221, 52, 157, 35, 36, 139)
12:08:01.243infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (151, 18, 270, 12, 134, 285, 27, 278, 284, 286, 4, 8)
12:08:01.244infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1313, 1253, 1724, 743, 1776, 1782, 525, 1785, 1786, 1767, 1775, 1783, 1769, 1781, 1358, 1244, 1730)
12:08:01.245infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 8, 3, 1, 4, 9)
12:08:01.246infoyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "is_delete"=FALSE ORDER BY "sort", "id"
12:08:01.247infoyii\db\Command::querySELECT product_id, erp_store_id, sum(inventory) as inventory FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE ("product_id" IN (2261, 2177, 2171, 2269, 2262, 2242, 1485, 1483, 1672, 2255, 1528, 1562, 1584, 1504, 2266, 2263, 2265, 2268)) AND ("inventory" > 0) GROUP BY "product_id", "erp_store_id"
12:08:01.248infoyii\db\Command::querySELECT pc.id, pc.id as key, pc.serial_no, pc.serial_no as name, pcr.project_id FROM "a57be577deb434"."tbl_purchase_contracts" "pc" INNER JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = pc.id WHERE ("pcr"."project_id" IN (3854, 4167, 4174, 4139, 4142, 4113, 4112, 4077, 4161, 4151, 4169, 4084, 4155)) AND ("pc"."cost_type"=1) GROUP BY "pc"."id", "pc"."serial_no", "pcr"."project_id" ORDER BY "pc"."serial_no"
12:08:01.251traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:08:01.252traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
12:08:01.256traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:08:01.256traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
12:08:01.257infoyii\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-sales-order-outbound-statistics/list', '{"client_id":"","project_id":"","product_brand":"","product_serie":"","product_type":"","product_component":"","Filter":{"name":"un_outbound","sort":"DESC"},"keyword":"","page":"1","web_access_token":"niM9Np1xaU2lIsoGJh5qM6IxT9naEHjn"}', '{"code":2000,"result":{"list":[{"id":2251,"erp_sales_order_id":1715,"erp_store_id":"","product_id":2261,"description":"","number":"22","outbound":"4","last_number":"22","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOrder":{"id":1715,"key":1715,"serial_no":"XSDD-20260605-00004","status":2,"client_id":2128,"project_id":3854,"created_at":"2026-06-05 11:10:13","client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":3854,"key":3854,"name":"\u5907\u4efd\u9879\u76ee\u4e8c\u671f","client_id":2128}},"product":{"id":2261,"key":2261,"name":"MK-MC300","product_type":4,"product_component":52,"product_brand":4,"product_serie":1769,"product_unit":3,"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"}},"storeInventory1":{"erp_store_id":1,"inventory":"47"},"storeInventory2":{"erp_store_id":2,"inventory":"1"},"erp_sales_order_product_id":2251,"client_id":2128,"project_id":3854,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":3854,"key":3854,"name":"\u5907\u4efd\u9879\u76ee\u4e8c\u671f","client_id":2128},"purchase_contracts":[{"id":4502,"key":4502,"serial_no":"\u6d4b\u8bd5\u9500\u552e\u8ba2\u5355\u51fa\u5e93\u7edf\u8ba1","name":"\u6d4b\u8bd5\u9500\u552e\u8ba2\u5355\u51fa\u5e93\u7edf\u8ba1"}],"purchase_contracts_display":"\u6d4b\u8bd5\u9500\u552e\u8ba2\u5355\u51fa\u5e93\u7edf\u8ba1","order_number":"22","outbound_number":4,"un_outbound":18,"total_available_inventory":48,"is_inventory_shortage":false,"shortage_text":"","can_create_erp_sales_outbound":true},{"id":2235,"erp_sales_order_id":1701,"erp_store_id":"","product_id":2177,"description":"","number":"12","outbound":"0","last_number":"12","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOrder":{"id":1701,"key":1701,"serial_no":"XSDD-20260520-00001","status":2,"client_id":982,"project_id":4167,"created_at":"2026-05-20 17:28:38","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"project":{"id":4167,"key":4167,"name":"\u65b0\u5efa\u9879\u76ee","client_id":982}},"product":{"id":2177,"key":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_unit":2,"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"}},"storeInventory1":{"erp_store_id":1,"inventory":"1"},"storeInventory2":{"erp_store_id":2,"inventory":"1"},"erp_sales_order_product_id":2235,"client_id":982,"project_id":4167,"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"project":{"id":4167,"key":4167,"name":"\u65b0\u5efa\u9879\u76ee","client_id":982},"purchase_contracts":[],"purchase_contracts_display":"","order_number":"12","outbound_number":0,"un_outbound":12,"total_available_inventory":2,"is_inventory_shortage":true,"shortage_text":"\u5e93\u5b58\u4e0d\u8db3","can_create_erp_sales_outbound":true},{"id":2260,"erp_sales_order_id":1711,"erp_store_id":"","product_id":2171,"description":"","number":"9","outbound":"0","last_number":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOrder":{"id":1711,"key":1711,"serial_no":"XSDD-20260602-00001","status":2,"client_id":3462,"project_id":4174,"created_at":"2026-06-02 16:53:15","client":{"id":3462,"key":3462,"name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c"},"project":{"id":4174,"key":4174,"name":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260602001","client_id":3462}},"product":{"id":2171,"key":2171,"name":"\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1","product_type":7,"product_component":159,"product_brand":270,"product_serie":1724,"product_unit":2,"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"}},"storeInventory1":{"erp_store_id":1,"inventory":"2"},"storeInventory2":{"erp_store_id":2,"inventory":"1"},"erp_sales_order_product_id":2260,"client_id":3462,"project_id":4174,"client":{"id":3462,"key":3462,"name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c"},"project":{"id":4174,"key":4174,"name":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260602001","client_id":3462},"purchase_contracts":[],"purchase_contracts_display":"","order_number":"9","outbound_number":0,"un_outbound":9,"total_available_inventory":3,"is_inventory_shortage":true,"shortage_text":"\u5e93\u5b58\u4e0d\u8db3","can_create_erp_sales_outbound":true},{"id":2215,"erp_sales_order_id":1690,"erp_store_id":"","product_id":2269,"description":"","number":"8","outbound":"0","last_number":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOrder":{"id":1690,"key":1690,"serial_no":"XSDD-20260320-00001","status":2,"client_id":2182,"project_id":4139,"created_at":"2026-03-20 17:58:32","client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"project":{"id":4139,"key":4139,"name":"\u7fa4\u6656\u5907\u4efd\u5b58\u50a8\u91c7\u8d2d-2026","client_id":2182}},"product":{"id":2269,"key":2269,"name":"HAT5320-24T","product_type":3,"product_component":15,"product_brand":27,"product_serie":1786,"product_unit":4,"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"}},"storeInventory1":{"erp_store_id":1,"inventory":"4"},"storeInventory2":{"erp_store_id":2,"inventory":"1"},"erp_sales_order_product_id":2215,"client_id":2182,"project_id":4139,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"project":{"id":4139,"key":4139,"name":"\u7fa4\u6656\u5907\u4efd\u5b58\u50a8\u91c7\u8d2d-2026","client_id":2182},"purchase_contracts":[{"id":4445,"key":4445,"serial_no":"20260814SYNTS01","name":"20260814SYNTS01"}],"purchase_contracts_display":"20260814SYNTS01","order_number":"8","outbound_number":0,"un_outbound":8,"total_available_inventory":5,"is_inventory_shortage":true,"shortage_text":"\u5e93\u5b58\u4e0d\u8db3","can_create_erp_sales_outbound":true},{"id":2213,"erp_sales_order_id":1692,"erp_store_id":"","product_id":2262,"description":"","number":"6","outbound":"0","last_number":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOrder":{"id":1692,"key":1692,"serial_no":"XSDD-20260323-00001","status":2,"client_id":3286,"project_id":4142,"created_at":"2026-03-23 17:48:02","client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"project":{"id":4142,"key":4142,"name":"PA1420 \u4e24\u53f0\u65b0\u8d2d\u9879\u76ee","client_id":3286}},"product":{"id":2262,"key":2262,"name":"PAN-SFP-PLUS-SR","product_type":5,"product_component":157,"product_brand":8,"product_serie":1781,"product_unit":3,"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"}},"storeInventory1":{"erp_store_id":1,"inventory":"2"},"storeInventory2":{"erp_store_id":2,"inventory":"1"},"erp_sales_order_product_id":2213,"client_id":3286,"project_id":4142,"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"project":{"id":4142,"key":4142,"name":"PA1420 \u4e24\u53f0\u65b0\u8d2d\u9879\u76ee","client_id":3286},"purchase_contracts":[{"id":4447,"key":4447,"serial_no":"DZ202603233147774","name":"DZ202603233147774"}],"purchase_contracts_display":"DZ202603233147774","order_number":"6","outbound_number":0,"un_outbound":6,"total_available_inventory":3,"is_inventory_shortage":true,"shortage_text":"\u5e93\u5b58\u4e0d\u8db3","can_create_erp_sales_outbound":true},{"id":2179,"erp_sales_order_id":1681,"erp_store_id":"","product_id":2242,"description":"","number":"6","outbound":"0","last_number":"6","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOrder":{"id":1681,"key":1681,"serial_no":"XSDD-20260128-00002","status":2,"client_id":2125,"project_id":4113,"created_at":"2026-01-28 16:25:20","client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8"},"project":{"id":4113,"key":4113,"name":"\u4f1a\u8bae\u5ba4\u7cfb\u7edf-K","client_id":2125}},"product":{"id":2242,"key":2242,"name":"CB-992F","product_type":21,"product_component":227,"product_brand":278,"product_serie":1767,"product_unit":1,"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"}},"storeInventory1":{"erp_store_id":1,"inventory":"4"},"storeInventory2":{"erp_store_id":2,"inventory":"0"},"erp_sales_order_product_id":2179,"client_id":2125,"project_id":4113,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8"},"project":{"id":4113,"key":4113,"name":"\u4f1a\u8bae\u5ba4\u7cfb\u7edf-K","client_id":2125},"purchase_contracts":[{"id":4410,"key":4410,"serial_no":"HHZD20260203","name":"HHZD20260203"},{"id":4416,"key":4416,"serial_no":"SLKX20260210","name":"SLKX20260210"},{"id":4391,"key":4391,"serial_no":"TSKJ20260126-HYF-01","name":"TSKJ20260126-HYF-01"},{"id":4402,"key":4402,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3386275004811263","name":"\u8ba2\u5355\u53f7\uff1a 3386275004811263"},{"id":4405,"key":4405,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3394275014663107","name":"\u8ba2\u5355\u53f7\uff1a 3394275014663107"},{"id":4438,"key":4438,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3437475000857790","name":"\u8ba2\u5355\u53f7\uff1a 3437475000857790"},{"id":4440,"key":4440,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3442475016987410","name":"\u8ba2\u5355\u53f7\uff1a 3442475016987410"},{"id":4412,"key":4412,"serial_no":"\u8ba2\u5355\u53f7: 5053305530461592710","name":"\u8ba2\u5355\u53f7: 5053305530461592710"}],"purchase_contracts_display":"HHZD20260203\nSLKX20260210\nTSKJ20260126-HYF-01\n\u8ba2\u5355\u53f7\uff1a 3386275004811263\n\u8ba2\u5355\u53f7\uff1a 3394275014663107\n\u8ba2\u5355\u53f7\uff1a 3437475000857790\n\u8ba2\u5355\u53f7\uff1a 3442475016987410\n\u8ba2\u5355\u53f7: 5053305530461592710","order_number":"6","outbound_number":0,"un_outbound":6,"total_available_inventory":4,"is_inventory_shortage":true,"shortage_text":"\u5e93\u5b58\u4e0d\u8db3","can_create_erp_sales_outbound":true},{"id":2154,"erp_sales_order_id":1676,"erp_store_id":"","product_id":1485,"description":"","number":"6","outbound":"0","last_number":"6","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOrder":{"id":1676,"key":1676,"serial_no":"XSDD-20260122-00002","status":2,"client_id":3436,"project_id":4112,"created_at":"2026-01-22 17:30:35","client":{"id":3436,"key":3436,"name":"\u5317\u4eac\u5f18\u96c5\u745e\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"project":{"id":4112,"key":4112,"name":"\u6d77\u6dc0\u8fdb\u4fee\u5b66\u682126\u5e74\u7eed\u4fdd","client_id":3436}},"product":{"id":1485,"key":1485,"name":"DS V20.0 \u65e0\u4ee3\u7406forVMware \u9632\u75c5\u6bd2\u6a21\u5757\u4fdd\u5185\u7eed\u4fdd \u670d\u52a1","product_type":7,"product_component":32,"product_brand":18,"product_serie":1253,"product_unit":2,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":32,"key":32,"name":"\u9632\u75c5\u6bd2\u8f6f\u4ef6"},"productBrand":{"id":18,"key":18,"name":"\u4e9a\u4fe1"},"productSerie":{"id":1253,"key":1253,"name":"\u4e9a\u4fe1\u5b89\u5168\u4e91\u4e3b\u673a\u6df1\u5ea6\u5b89\u5168\u9632\u62a4\u7cfb\u7edf\u5e94\u7528\u8f6f\u4ef6DeepSecurity V20.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"storeInventory1":{"erp_store_id":1,"inventory":"0"},"storeInventory2":{"erp_store_id":2,"inventory":"0"},"erp_sales_order_product_id":2154,"client_id":3436,"project_id":4112,"client":{"id":3436,"key":3436,"name":"\u5317\u4eac\u5f18\u96c5\u745e\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"project":{"id":4112,"key":4112,"name":"\u6d77\u6dc0\u8fdb\u4fee\u5b66\u682126\u5e74\u7eed\u4fdd","client_id":3436},"purchase_contracts":[{"id":4392,"key":4392,"serial_no":"XM20260123000275","name":"XM20260123000275"}],"purchase_contracts_display":"XM20260123000275","order_number":"6","outbound_number":0,"un_outbound":6,"total_available_inventory":0,"is_inventory_shortage":true,"shortage_text":"\u5e93\u5b58\u4e0d\u8db3","can_create_erp_sales_outbound":false},{"id":2152,"erp_sales_order_id":1676,"erp_store_id":"","product_id":1483,"description":"","number":"6","outbound":"0","last_number":"6","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOrder":{"id":1676,"key":1676,"serial_no":"XSDD-20260122-00002","status":2,"client_id":3436,"project_id":4112,"created_at":"2026-01-22 17:30:35","client":{"id":3436,"key":3436,"name":"\u5317\u4eac\u5f18\u96c5\u745e\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"project":{"id":4112,"key":4112,"name":"\u6d77\u6dc0\u8fdb\u4fee\u5b66\u682126\u5e74\u7eed\u4fdd","client_id":3436}},"product":{"id":1483,"key":1483,"name":"DS V20.0 \u6709\u4ee3\u7406\u5ba2\u6237\u7aef\u9632\u75c5\u6bd2\u6a21\u5757\u7eed\u4fdd\u670d\u52a1","product_type":7,"product_component":32,"product_brand":18,"product_serie":1253,"product_unit":2,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":32,"key":32,"name":"\u9632\u75c5\u6bd2\u8f6f\u4ef6"},"productBrand":{"id":18,"key":18,"name":"\u4e9a\u4fe1"},"productSerie":{"id":1253,"key":1253,"name":"\u4e9a\u4fe1\u5b89\u5168\u4e91\u4e3b\u673a\u6df1\u5ea6\u5b89\u5168\u9632\u62a4\u7cfb\u7edf\u5e94\u7528\u8f6f\u4ef6DeepSecurity V20.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"storeInventory1":{"erp_store_id":1,"inventory":"0"},"storeInventory2":{"erp_store_id":2,"inventory":"0"},"erp_sales_order_product_id":2152,"client_id":3436,"project_id":4112,"client":{"id":3436,"key":3436,"name":"\u5317\u4eac\u5f18\u96c5\u745e\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"project":{"id":4112,"key":4112,"name":"\u6d77\u6dc0\u8fdb\u4fee\u5b66\u682126\u5e74\u7eed\u4fdd","client_id":3436},"purchase_contracts":[{"id":4392,"key":4392,"serial_no":"XM20260123000275","name":"XM20260123000275"}],"purchase_contracts_display":"XM20260123000275","order_number":"6","outbound_number":0,"un_outbound":6,"total_available_inventory":0,"is_inventory_shortage":true,"shortage_text":"\u5e93\u5b58\u4e0d\u8db3","can_create_erp_sales_outbound":false},{"id":2218,"erp_sales_order_id":1670,"erp_store_id":"","product_id":1672,"description":"","number":"6","outbound":"0","last_number":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOrder":{"id":1670,"key":1670,"serial_no":"XSDD-20260114-00002","status":2,"client_id":3359,"project_id":4077,"created_at":"2026-01-14 15:07:38","client":{"id":3359,"key":3359,"name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":4077,"key":4077,"name":"\u91cd\u673a\u4fe1\u521b\u8f6f\u4ef6\u4e09\u671f","client_id":3359}},"product":{"id":1672,"key":1672,"name":"\u94f6\u6cb3\u9e92\u9e9f\u9ad8\u7ea7\u670d\u52a1\u5668\u64cd\u4f5c\u7cfb\u7edfV10","product_type":7,"product_component":28,"product_brand":151,"product_serie":1313,"product_unit":2,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":28,"key":28,"name":"\u64cd\u4f5c\u7cfb\u7edf"},"productBrand":{"id":151,"key":151,"name":"\u94f6\u6cb3\u9e92\u9e9f"},"productSerie":{"id":1313,"key":1313,"name":"\u94f6\u6cb3\u9e92\u9e9f\u670d\u52a1\u5668\u64cd\u4f5c\u7cfb\u7edf"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"storeInventory1":{"erp_store_id":1,"inventory":"0"},"storeInventory2":{"erp_store_id":2,"inventory":"0"},"erp_sales_order_product_id":2218,"client_id":3359,"project_id":4077,"client":{"id":3359,"key":3359,"name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":4077,"key":4077,"name":"\u91cd\u673a\u4fe1\u521b\u8f6f\u4ef6\u4e09\u671f","client_id":3359},"purchase_contracts":[{"id":4439,"key":4439,"serial_no":"TSKJ20260318-HYF-01","name":"TSKJ20260318-HYF-01"},{"id":4423,"key":4423,"serial_no":"XM20260210000270","name":"XM20260210000270"}],"purchase_contracts_display":"TSKJ20260318-HYF-01\nXM20260210000270","order_number":"6","outbound_number":0,"un_outbound":6,"total_available_inventory":0,"is_inventory_shortage":true,"shortage_text":"\u5e93\u5b58\u4e0d\u8db3","can_create_erp_sales_outbound":false},{"id":2230,"erp_sales_order_id":1699,"erp_store_id":"","product_id":2261,"description":"","number":"5","outbound":"1","last_number":"5","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOrder":{"id":1699,"key":1699,"serial_no":"XSDD-20260423-00001","status":2,"client_id":982,"project_id":4161,"created_at":"2026-04-23 16:49:39","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"project":{"id":4161,"key":4161,"name":"3535","client_id":982}},"product":{"id":2261,"key":2261,"name":"MK-MC300","product_type":4,"product_component":52,"product_brand":4,"product_serie":1769,"product_unit":3,"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"}},"storeInventory1":{"erp_store_id":1,"inventory":"47"},"storeInventory2":{"erp_store_id":2,"inventory":"1"},"erp_sales_order_product_id":2230,"client_id":982,"project_id":4161,"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"project":{"id":4161,"key":4161,"name":"3535","client_id":982},"purchase_contracts":[],"purchase_contracts_display":"","order_number":"5","outbound_number":1,"un_outbound":4,"total_available_inventory":48,"is_inventory_shortage":false,"shortage_text":"","can_create_erp_sales_outbound":true},{"id":2189,"erp_sales_order_id":1681,"erp_store_id":"","product_id":2255,"description":"1\u7c73\u540a\u67b6\u300110\u7c73\u7535\u6e90\u7ebf\u300115\u7c73\u9ad8\u6e05\u7ebf","number":"3","outbound":"0","last_number":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOrder":{"id":1681,"key":1681,"serial_no":"XSDD-20260128-00002","status":2,"client_id":2125,"project_id":4113,"created_at":"2026-01-28 16:25:20","client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8"},"project":{"id":4113,"key":4113,"name":"\u4f1a\u8bae\u5ba4\u7cfb\u7edf-K","client_id":2125}},"product":{"id":2255,"key":2255,"name":"\u6295\u5f71\u4eea\u5b89\u88c5\u914d\u4ef6\u8f85\u6599","product_type":21,"product_component":229,"product_brand":134,"product_serie":1776,"product_unit":2,"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"}},"storeInventory1":{"erp_store_id":1,"inventory":"4"},"storeInventory2":{"erp_store_id":2,"inventory":"0"},"erp_sales_order_product_id":2189,"client_id":2125,"project_id":4113,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8"},"project":{"id":4113,"key":4113,"name":"\u4f1a\u8bae\u5ba4\u7cfb\u7edf-K","client_id":2125},"purchase_contracts":[{"id":4410,"key":4410,"serial_no":"HHZD20260203","name":"HHZD20260203"},{"id":4416,"key":4416,"serial_no":"SLKX20260210","name":"SLKX20260210"},{"id":4391,"key":4391,"serial_no":"TSKJ20260126-HYF-01","name":"TSKJ20260126-HYF-01"},{"id":4402,"key":4402,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3386275004811263","name":"\u8ba2\u5355\u53f7\uff1a 3386275004811263"},{"id":4405,"key":4405,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3394275014663107","name":"\u8ba2\u5355\u53f7\uff1a 3394275014663107"},{"id":4438,"key":4438,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3437475000857790","name":"\u8ba2\u5355\u53f7\uff1a 3437475000857790"},{"id":4440,"key":4440,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3442475016987410","name":"\u8ba2\u5355\u53f7\uff1a 3442475016987410"},{"id":4412,"key":4412,"serial_no":"\u8ba2\u5355\u53f7: 5053305530461592710","name":"\u8ba2\u5355\u53f7: 5053305530461592710"}],"purchase_contracts_display":"HHZD20260203\nSLKX20260210\nTSKJ20260126-HYF-01\n\u8ba2\u5355\u53f7\uff1a 3386275004811263\n\u8ba2\u5355\u53f7\uff1a 3394275014663107\n\u8ba2\u5355\u53f7\uff1a 3437475000857790\n\u8ba2\u5355\u53f7\uff1a 3442475016987410\n\u8ba2\u5355\u53f7: 5053305530461592710","order_number":"3","outbound_number":0,"un_outbound":3,"total_available_inventory":4,"is_inventory_shortage":false,"shortage_text":"","can_create_erp_sales_outbound":true},{"id":2242,"erp_sales_order_id":1705,"erp_store_id":"","product_id":1528,"description":"","number":"2","outbound":"0","last_number":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOrder":{"id":1705,"key":1705,"serial_no":"XSDD-20260522-00004","status":2,"client_id":2150,"project_id":4151,"created_at":"2026-05-22 17:08:02","client":{"id":2150,"key":2150,"name":"\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)"},"project":{"id":4151,"key":4151,"name":"PA460 \u8bbe\u5907\u65b0\u8d2d\u9879\u76ee","client_id":2150}},"product":{"id":1528,"key":1528,"name":"\u6df1\u4fe1\u670d\u8ba1\u7b97\u670d\u52a1\u5668\u865a\u62df\u5316\u8f6f\u4ef6V6.0","product_type":7,"product_component":29,"product_brand":12,"product_serie":525,"product_unit":2,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":29,"key":29,"name":"\u865a\u62df\u5316\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":525,"key":525,"name":"\u6df1\u4fe1\u670d\u865a\u62df\u5316\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"storeInventory1":{"erp_store_id":1,"inventory":"0"},"storeInventory2":{"erp_store_id":2,"inventory":"0"},"erp_sales_order_product_id":2242,"client_id":2150,"project_id":4151,"client":{"id":2150,"key":2150,"name":"\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)"},"project":{"id":4151,"key":4151,"name":"PA460 \u8bbe\u5907\u65b0\u8d2d\u9879\u76ee","client_id":2150},"purchase_contracts":[],"purchase_contracts_display":"","order_number":"2","outbound_number":0,"un_outbound":2,"total_available_inventory":0,"is_inventory_shortage":true,"shortage_text":"\u5e93\u5b58\u4e0d\u8db3","can_create_erp_sales_outbound":false},{"id":2241,"erp_sales_order_id":1704,"erp_store_id":"","product_id":2261,"description":"","number":"2","outbound":"0","last_number":"2","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOrder":{"id":1704,"key":1704,"serial_no":"XSDD-20260522-00003","status":2,"client_id":3389,"project_id":4169,"created_at":"2026-05-22 17:05:11","client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"project":{"id":4169,"key":4169,"name":"\u65b9\u5f0f\u5730\u65b9","client_id":3389}},"product":{"id":2261,"key":2261,"name":"MK-MC300","product_type":4,"product_component":52,"product_brand":4,"product_serie":1769,"product_unit":3,"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"}},"storeInventory1":{"erp_store_id":1,"inventory":"47"},"storeInventory2":{"erp_store_id":2,"inventory":"1"},"erp_sales_order_product_id":2241,"client_id":3389,"project_id":4169,"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"project":{"id":4169,"key":4169,"name":"\u65b9\u5f0f\u5730\u65b9","client_id":3389},"purchase_contracts":[],"purchase_contracts_display":"","order_number":"2","outbound_number":0,"un_outbound":2,"total_available_inventory":48,"is_inventory_shortage":false,"shortage_text":"","can_create_erp_sales_outbound":true},{"id":2212,"erp_sales_order_id":1692,"erp_store_id":"","product_id":1562,"description":"","number":"2","outbound":"0","last_number":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOrder":{"id":1692,"key":1692,"serial_no":"XSDD-20260323-00001","status":2,"client_id":3286,"project_id":4142,"created_at":"2026-03-23 17:48:02","client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"project":{"id":4142,"key":4142,"name":"PA1420 \u4e24\u53f0\u65b0\u8d2d\u9879\u76ee","client_id":3286}},"product":{"id":1562,"key":1562,"name":"PAN-PWR-450W-AC","product_type":5,"product_component":36,"product_brand":8,"product_serie":1244,"product_unit":2,"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"}},"storeInventory1":{"erp_store_id":1,"inventory":"2"},"storeInventory2":{"erp_store_id":2,"inventory":"0"},"erp_sales_order_product_id":2212,"client_id":3286,"project_id":4142,"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"project":{"id":4142,"key":4142,"name":"PA1420 \u4e24\u53f0\u65b0\u8d2d\u9879\u76ee","client_id":3286},"purchase_contracts":[{"id":4447,"key":4447,"serial_no":"DZ202603233147774","name":"DZ202603233147774"}],"purchase_contracts_display":"DZ202603233147774","order_number":"2","outbound_number":0,"un_outbound":2,"total_available_inventory":2,"is_inventory_shortage":false,"shortage_text":"","can_create_erp_sales_outbound":true},{"id":2211,"erp_sales_order_id":1692,"erp_store_id":"","product_id":1584,"description":"","number":"2","outbound":"0","last_number":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOrder":{"id":1692,"key":1692,"serial_no":"XSDD-20260323-00001","status":2,"client_id":3286,"project_id":4142,"created_at":"2026-03-23 17:48:02","client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"project":{"id":4142,"key":4142,"name":"PA1420 \u4e24\u53f0\u65b0\u8d2d\u9879\u76ee","client_id":3286}},"product":{"id":1584,"key":1584,"name":"PAN-SVC-BKLN-1420","product_type":5,"product_component":35,"product_brand":8,"product_serie":1358,"product_unit":2,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1358,"key":1358,"name":"PA-1420\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"storeInventory1":{"erp_store_id":1,"inventory":"0"},"storeInventory2":{"erp_store_id":2,"inventory":"0"},"erp_sales_order_product_id":2211,"client_id":3286,"project_id":4142,"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"project":{"id":4142,"key":4142,"name":"PA1420 \u4e24\u53f0\u65b0\u8d2d\u9879\u76ee","client_id":3286},"purchase_contracts":[{"id":4447,"key":4447,"serial_no":"DZ202603233147774","name":"DZ202603233147774"}],"purchase_contracts_display":"DZ202603233147774","order_number":"2","outbound_number":0,"un_outbound":2,"total_available_inventory":0,"is_inventory_shortage":true,"shortage_text":"\u5e93\u5b58\u4e0d\u8db3","can_create_erp_sales_outbound":false},{"id":2099,"erp_sales_order_id":1659,"erp_store_id":"","product_id":1504,"description":"","number":"3","outbound":"1","last_number":"3","supplier_id":"","hardware_from":"2025-11-04","software_from":"2025-11-04","maintenance_from":"","hardware_to":"2026-11-03","software_to":"2026-11-03","maintenance_to":"","erpSalesOrder":{"id":1659,"key":1659,"serial_no":"XSDD-20251224-00002","status":2,"client_id":3433,"project_id":4084,"created_at":"2025-12-24 14:43:51","client":{"id":3433,"key":3433,"name":"\u5317\u4eac\u5b89\u5b81\u76c8\u79d1\u8f6f\u4ef6\u7cfb\u7edf\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09-\u96c6\u6210\u5546"},"project":{"id":4084,"key":4084,"name":"\u516c\u5b89\u90e8\u4e00\u6240\u6df1\u4fe1\u670d\u5b89\u5168\u670d\u52a1","client_id":3433}},"product":{"id":1504,"key":1504,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-2000-B2150\uff09","product_type":7,"product_component":188,"product_brand":12,"product_serie":743,"product_unit":8,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":188,"key":188,"name":"\u7cfb\u7edf\u8ba2\u9605\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":743,"key":743,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"storeInventory1":{"erp_store_id":1,"inventory":"0"},"storeInventory2":{"erp_store_id":2,"inventory":"0"},"erp_sales_order_product_id":2099,"client_id":3433,"project_id":4084,"client":{"id":3433,"key":3433,"name":"\u5317\u4eac\u5b89\u5b81\u76c8\u79d1\u8f6f\u4ef6\u7cfb\u7edf\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09-\u96c6\u6210\u5546"},"project":{"id":4084,"key":4084,"name":"\u516c\u5b89\u90e8\u4e00\u6240\u6df1\u4fe1\u670d\u5b89\u5168\u670d\u52a1","client_id":3433},"purchase_contracts":[{"id":4340,"key":4340,"serial_no":"H202512235124-001","name":"H202512235124-001"},{"id":4339,"key":4339,"serial_no":"TSKJ20251224-ZHY-01","name":"TSKJ20251224-ZHY-01"}],"purchase_contracts_display":"H202512235124-001\nTSKJ20251224-ZHY-01","order_number":"3","outbound_number":1,"un_outbound":2,"total_available_inventory":0,"is_inventory_shortage":true,"shortage_text":"\u5e93\u5b58\u4e0d\u8db3","can_create_erp_sales_outbound":false},{"id":2255,"erp_sales_order_id":1715,"erp_store_id":"","product_id":2266,"description":"","number":"1","outbound":"0","last_number":"1","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOrder":{"id":1715,"key":1715,"serial_no":"XSDD-20260605-00004","status":2,"client_id":2128,"project_id":3854,"created_at":"2026-06-05 11:10:13","client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":3854,"key":3854,"name":"\u5907\u4efd\u9879\u76ee\u4e8c\u671f","client_id":2128}},"product":{"id":2266,"key":2266,"name":"\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20","product_type":23,"product_component":221,"product_brand":286,"product_serie":1783,"product_unit":3,"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":221,"key":221,"name":"\u7535\u5b50\u4ea7\u54c1"},"productBrand":{"id":286,"key":286,"name":"\u677e\u4e0b"},"productSerie":{"id":1783,"key":1783,"name":"\u7535\u52a8\u5243\u987b\u5200"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"storeInventory1":{"erp_store_id":1,"inventory":"0"},"storeInventory2":{"erp_store_id":2,"inventory":"0"},"erp_sales_order_product_id":2255,"client_id":2128,"project_id":3854,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":3854,"key":3854,"name":"\u5907\u4efd\u9879\u76ee\u4e8c\u671f","client_id":2128},"purchase_contracts":[{"id":4502,"key":4502,"serial_no":"\u6d4b\u8bd5\u9500\u552e\u8ba2\u5355\u51fa\u5e93\u7edf\u8ba1","name":"\u6d4b\u8bd5\u9500\u552e\u8ba2\u5355\u51fa\u5e93\u7edf\u8ba1"}],"purchase_contracts_display":"\u6d4b\u8bd5\u9500\u552e\u8ba2\u5355\u51fa\u5e93\u7edf\u8ba1","order_number":"1","outbound_number":0,"un_outbound":1,"total_available_inventory":0,"is_inventory_shortage":true,"shortage_text":"\u5e93\u5b58\u4e0d\u8db3","can_create_erp_sales_outbound":false},{"id":2254,"erp_sales_order_id":1715,"erp_store_id":"","product_id":2263,"description":"","number":"1","outbound":"0","last_number":"1","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOrder":{"id":1715,"key":1715,"serial_no":"XSDD-20260605-00004","status":2,"client_id":2128,"project_id":3854,"created_at":"2026-06-05 11:10:13","client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":3854,"key":3854,"name":"\u5907\u4efd\u9879\u76ee\u4e8c\u671f","client_id":2128}},"product":{"id":2263,"key":2263,"name":"\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8","product_type":21,"product_component":229,"product_brand":285,"product_serie":1782,"product_unit":3,"productType":{"id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907"},"productComponent":{"id":229,"key":229,"name":"\u6570\u7801\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":285,"key":285,"name":"\u867e\u76ae"},"productSerie":{"id":1782,"key":1782,"name":"\u6295\u5f71\u5e55\u5e03"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"storeInventory1":{"erp_store_id":1,"inventory":"0"},"storeInventory2":{"erp_store_id":2,"inventory":"0"},"erp_sales_order_product_id":2254,"client_id":2128,"project_id":3854,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":3854,"key":3854,"name":"\u5907\u4efd\u9879\u76ee\u4e8c\u671f","client_id":2128},"purchase_contracts":[{"id":4502,"key":4502,"serial_no":"\u6d4b\u8bd5\u9500\u552e\u8ba2\u5355\u51fa\u5e93\u7edf\u8ba1","name":"\u6d4b\u8bd5\u9500\u552e\u8ba2\u5355\u51fa\u5e93\u7edf\u8ba1"}],"purchase_contracts_display":"\u6d4b\u8bd5\u9500\u552e\u8ba2\u5355\u51fa\u5e93\u7edf\u8ba1","order_number":"1","outbound_number":0,"un_outbound":1,"total_available_inventory":0,"is_inventory_shortage":true,"shortage_text":"\u5e93\u5b58\u4e0d\u8db3","can_create_erp_sales_outbound":false},{"id":2253,"erp_sales_order_id":1715,"erp_store_id":"","product_id":2265,"description":"","number":"1","outbound":"0","last_number":"1","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOrder":{"id":1715,"key":1715,"serial_no":"XSDD-20260605-00004","status":2,"client_id":2128,"project_id":3854,"created_at":"2026-06-05 11:10:13","client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":3854,"key":3854,"name":"\u5907\u4efd\u9879\u76ee\u4e8c\u671f","client_id":2128}},"product":{"id":2265,"key":2265,"name":"\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2","product_type":23,"product_component":195,"product_brand":284,"product_serie":1775,"product_unit":9,"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":195,"key":195,"name":"\u8425\u517b\u98df\u54c1\u6ecb\u8865"},"productBrand":{"id":284,"key":284,"name":"\u6b27\u4e3d\u8587\u5170"},"productSerie":{"id":1775,"key":1775,"name":"\u98df\u7528\u6cb9"},"productUnit":{"id":9,"key":9,"name":"\u76d2"}},"storeInventory1":{"erp_store_id":1,"inventory":"1"},"storeInventory2":{"erp_store_id":2,"inventory":"0"},"erp_sales_order_product_id":2253,"client_id":2128,"project_id":3854,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":3854,"key":3854,"name":"\u5907\u4efd\u9879\u76ee\u4e8c\u671f","client_id":2128},"purchase_contracts":[{"id":4502,"key":4502,"serial_no":"\u6d4b\u8bd5\u9500\u552e\u8ba2\u5355\u51fa\u5e93\u7edf\u8ba1","name":"\u6d4b\u8bd5\u9500\u552e\u8ba2\u5355\u51fa\u5e93\u7edf\u8ba1"}],"purchase_contracts_display":"\u6d4b\u8bd5\u9500\u552e\u8ba2\u5355\u51fa\u5e93\u7edf\u8ba1","order_number":"1","outbound_number":0,"un_outbound":1,"total_available_inventory":1,"is_inventory_shortage":false,"shortage_text":"","can_create_erp_sales_outbound":true},{"id":2246,"erp_sales_order_id":1709,"erp_store_id":"","product_id":2268,"description":"","number":"1","outbound":"0","last_number":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpSalesOrder":{"id":1709,"key":1709,"serial_no":"XSDD-20260525-00003","status":2,"client_id":982,"project_id":4155,"created_at":"2026-05-25 11:18:55","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"project":{"id":4155,"key":4155,"name":"\u6d4b\u8bd5\u65b0\u5efa\u5546\u673a","client_id":982}},"product":{"id":2268,"key":2268,"name":"DS1825+","product_type":3,"product_component":14,"product_brand":27,"product_serie":1785,"product_unit":1,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":14,"key":14,"name":"\u5b58\u50a8\u4e3b\u673a"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1785,"key":1785,"name":"DS1825+ NAS\u5b58\u50a8"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"storeInventory1":{"erp_store_id":1,"inventory":"0"},"storeInventory2":{"erp_store_id":2,"inventory":"0"},"erp_sales_order_product_id":2246,"client_id":982,"project_id":4155,"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"project":{"id":4155,"key":4155,"name":"\u6d4b\u8bd5\u65b0\u5efa\u5546\u673a","client_id":982},"purchase_contracts":[],"purchase_contracts_display":"","order_number":"1","outbound_number":0,"un_outbound":1,"total_available_inventory":0,"is_inventory_shortage":true,"shortage_text":"\u5e93\u5b58\u4e0d\u8db3","can_create_erp_sales_outbound":false}],"stores":[{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"},{"id":2,"key":2,"name":"\u96f6\u914d\u4ef6"}],"pagenation":{"totalcount":40,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"114.244.130.20","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-07 12:08:01', 66461952) RETURNING "id"
12:08:01.262traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:08:01.262traceyii\redis\Connection::executeCommandExecuting Redis Command: SET