Database Queries

总计16条数据
TimeDurationTypeQuery
  
18:39:26.9770.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

18:39:26.9800.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

18:39:26.9927.8 msSELECTSELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_sales_order_items' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

18:39:27.00016.5 msSELECTselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_sales_order_items' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

18:39:27.02681.1 msSELECTSELECT COUNT(*) FROM (SELECT DISTINCT s.* FROM "a57be577deb434"."tbl_sales_order_items" "s" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_users" "salesRep" ON "salesRep"."id" = "client"."sales_rep" LEFT JOIN "a57be577deb434"."tbl_products" "product" ON "product"."id" = "product_id" LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON "project"."id" = "s"."project_id" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON "supplier"."id" = "supplier_id" LEFT JOIN "a57be577deb434"."tbl_sales_order_item_renew_logs" "log" ON log.sales_order_item_id = s.id WHERE ("client"."deleted"=FALSE) AND (("client"."sales_rep" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND (s.is_renew = false) GROUP BY "s"."id" ORDER BY "s"."sales_date" DESC, "s"."created_at" DESC) "c"

18:39:27.11442.7 msSELECTSELECT DISTINCT s.* FROM "a57be577deb434"."tbl_sales_order_items" "s" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_users" "salesRep" ON "salesRep"."id" = "client"."sales_rep" LEFT JOIN "a57be577deb434"."tbl_products" "product" ON "product"."id" = "product_id" LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON "project"."id" = "s"."project_id" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON "supplier"."id" = "supplier_id" LEFT JOIN "a57be577deb434"."tbl_sales_order_item_renew_logs" "log" ON log.sales_order_item_id = s.id WHERE ("client"."deleted"=FALSE) AND (("client"."sales_rep" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND (s.is_renew = false) GROUP BY "s"."id" ORDER BY "s"."sales_date" DESC, "s"."created_at" DESC LIMIT 20

18:39:27.1690.9 msSELECTSELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (918, 982, 3359, 2032, 3448, 2021, 89, 79, 2125)

18:39:27.1710.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5295, 5311, 1001, 5087)

18:39:27.1720.6 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3290, 4161, 4077, 4130, 4124, 4121, 4123, 4103, 4113)

18:39:27.1722.7 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_products" WHERE "id" IN (923, 2177, 1671, 867, 868, 870, 2260, 2259, 2258, 2257, 1275, 1780, 1925, 2241)

18:39:27.1751.8 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (630, 686, 757, 59, 598, 660)

18:39:27.1780.4 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 1001, 5360)

18:39:27.1780.4 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5360, 1011, 1001))

18:39:27.1790.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (3, 4)

18:39:27.1800.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_order_item_renew_logs" WHERE "sales_order_item_id" IN (5334, 13947, 13944, 13943, 13942, 13941, 13940, 13939, 13938, 13937, 13936, 13935, 13934, 13933, 13932, 13931, 13930, 13929, 13925, 13924) ORDER BY "sales_date", "created_at"

18:39:27.1832.8 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/sales-order', '[]', '{"code":2000,"result":{"list":[{"id":5334,"sales_order_id":"","product_id":923,"parent":"","sn":"","supplier_id":"","order":0,"created_by":1011,"created_at":"2024-01-22 10:27:18","updated_at":"2024-01-22 10:27:18","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"","new_maintenance_deadline":"","client_id":918,"project_id":3290,"sales_rep":1005,"sales_date":"","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"5000","cost":"3906","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":"","erp_sales_gift_id":"","client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1005,"logo":"","salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},"project":{"id":3290,"key":3290,"name":"2023\u5e74-2024\u5e74\u7eed\u4fdd\u5408\u540c"},"product":{"id":923,"key":923,"name":"\u6df1\u4fe1\u670d\u6f0f\u6d1e\u626b\u63cf\u7eed\u4fdd\u670d\u52a1"},"supplier":"","productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"renewLogs":[],"bgcolor":"#89c541"},{"id":13947,"sales_order_id":"","product_id":2177,"parent":"","sn":"","supplier_id":"","order":0,"created_by":1001,"created_at":"2026-05-21 16:13:21","updated_at":"2026-05-21 16:13:21","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"","new_maintenance_deadline":"","client_id":982,"project_id":4161,"sales_rep":1001,"sales_date":"2026-05-21","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"1","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":155,"erp_sales_gift_id":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"project":{"id":4161,"key":4161,"name":"3535"},"product":{"id":2177,"key":2177,"name":"\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0"},"supplier":"","productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"renewLogs":[],"bgcolor":"#89c541"},{"id":13944,"sales_order_id":"","product_id":1671,"parent":"","sn":"","supplier_id":630,"order":0,"created_by":1011,"created_at":"2026-03-11 16:31:54","updated_at":"2026-03-11 16:31:54","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"","new_maintenance_deadline":"","client_id":3359,"project_id":4077,"sales_rep":1005,"sales_date":"2026-03-11","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"68760","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":145,"erp_sales_gift_id":"","client":{"id":3359,"key":3359,"name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1005,"logo":"","salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},"project":{"id":4077,"key":4077,"name":"\u91cd\u673a\u4fe1\u521b\u8f6f\u4ef6\u4e09\u671f"},"product":{"id":1671,"key":1671,"name":"\u91d1\u4ed3\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf V8.0"},"supplier":{"id":630,"key":630,"name":"\u4f1f\u4ed5\u4f73\u6770\uff08\u91cd\u5e86\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"renewLogs":[],"bgcolor":"#89c541"},{"id":13943,"sales_order_id":"","product_id":1671,"parent":"","sn":"","supplier_id":630,"order":0,"created_by":1011,"created_at":"2026-03-11 16:31:54","updated_at":"2026-03-11 16:31:54","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"","new_maintenance_deadline":"","client_id":3359,"project_id":4077,"sales_rep":1005,"sales_date":"2026-03-11","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"68760","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":145,"erp_sales_gift_id":"","client":{"id":3359,"key":3359,"name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1005,"logo":"","salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},"project":{"id":4077,"key":4077,"name":"\u91cd\u673a\u4fe1\u521b\u8f6f\u4ef6\u4e09\u671f"},"product":{"id":1671,"key":1671,"name":"\u91d1\u4ed3\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf V8.0"},"supplier":{"id":630,"key":630,"name":"\u4f1f\u4ed5\u4f73\u6770\uff08\u91cd\u5e86\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"renewLogs":[],"bgcolor":"#89c541"},{"id":13942,"sales_order_id":"","product_id":867,"parent":"","sn":"","supplier_id":686,"order":0,"created_by":1011,"created_at":"2026-03-10 15:07:33","updated_at":"2026-03-10 15:07:33","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"","new_maintenance_deadline":"","client_id":2032,"project_id":4130,"sales_rep":5295,"sales_date":"2026-03-10","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"1300","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":144,"erp_sales_gift_id":"","client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","sales_rep":5295,"logo":"","salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},"project":{"id":4130,"key":4130,"name":"2026\u9632\u706b\u5899\u7eed\u4fdd"},"product":{"id":867,"key":867,"name":"LIS-F1000-AK-IPS-1Y"},"supplier":{"id":686,"key":686,"name":"\u5317\u4eac\u4e07\u7f51\u878d\u901a\u4fe1\u606f\u7cfb\u7edf\u6709\u9650\u516c\u53f8"},"productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"renewLogs":[],"bgcolor":"#89c541"},{"id":13941,"sales_order_id":"","product_id":868,"parent":"","sn":"","supplier_id":686,"order":0,"created_by":1011,"created_at":"2026-03-10 15:07:33","updated_at":"2026-03-10 15:07:33","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"","new_maintenance_deadline":"","client_id":2032,"project_id":4130,"sales_rep":5295,"sales_date":"2026-03-10","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"1400","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":144,"erp_sales_gift_id":"","client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","sales_rep":5295,"logo":"","salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},"project":{"id":4130,"key":4130,"name":"2026\u9632\u706b\u5899\u7eed\u4fdd"},"product":{"id":868,"key":868,"name":"LIS-F1000-AK-URL-1Y"},"supplier":{"id":686,"key":686,"name":"\u5317\u4eac\u4e07\u7f51\u878d\u901a\u4fe1\u606f\u7cfb\u7edf\u6709\u9650\u516c\u53f8"},"productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"renewLogs":[],"bgcolor":"#89c541"},{"id":13940,"sales_order_id":"","product_id":870,"parent":"","sn":"","supplier_id":686,"order":0,"created_by":1011,"created_at":"2026-03-10 15:07:33","updated_at":"2026-03-10 15:07:33","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"","new_maintenance_deadline":"","client_id":2032,"project_id":4130,"sales_rep":5295,"sales_date":"2026-03-10","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"1200","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":144,"erp_sales_gift_id":"","client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","sales_rep":5295,"logo":"","salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},"project":{"id":4130,"key":4130,"name":"2026\u9632\u706b\u5899\u7eed\u4fdd"},"product":{"id":870,"key":870,"name":"LIS-F1000-AK-AV-1Y"},"supplier":{"id":686,"key":686,"name":"\u5317\u4eac\u4e07\u7f51\u878d\u901a\u4fe1\u606f\u7cfb\u7edf\u6709\u9650\u516c\u53f8"},"productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"renewLogs":[],"bgcolor":"#89c541"},{"id":13939,"sales_order_id":"","product_id":2260,"parent":"","sn":"","supplier_id":757,"order":0,"created_by":1011,"created_at":"2026-03-04 16:35:47","updated_at":"2026-03-04 16:35:47","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"2026-03-04","maintenance_from":"","hardware_to":"","software_to":"2027-03-03","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"2027-03-03","new_maintenance_deadline":"","client_id":3448,"project_id":4124,"sales_rep":1005,"sales_date":"2026-03-04","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"1400","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":143,"erp_sales_gift_id":"","client":{"id":3448,"key":3448,"name":"\u5317\u4eac\u5723\u5609\u5965\u5bb6\u5177\u6709\u9650\u516c\u53f8-\u91d1\u7545\u900d","sales_rep":1005,"logo":"","salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},"project":{"id":4124,"key":4124,"name":"\u6df1\u4fe1\u670d\u6258\u7ba1\u4e91\u65b0\u8d2d"},"product":{"id":2260,"key":2260,"name":"\u516c\u6709\u4e91 \u4e13\u4eab\u670d\u52a1-\u8d34\u5fc3\u670d\u52a1\uff08\u6807\u51c6\u7248-M\uff09"},"supplier":{"id":757,"key":757,"name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"},"productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"renewLogs":[],"bgcolor":"#89c541"},{"id":13938,"sales_order_id":"","product_id":2259,"parent":"","sn":"","supplier_id":757,"order":0,"created_by":1011,"created_at":"2026-03-04 16:35:47","updated_at":"2026-03-04 16:35:47","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"2026-03-04","maintenance_from":"","hardware_to":"","software_to":"2027-03-03","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"2027-03-03","new_maintenance_deadline":"","client_id":3448,"project_id":4124,"sales_rep":1005,"sales_date":"2026-03-04","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"300","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":143,"erp_sales_gift_id":"","client":{"id":3448,"key":3448,"name":"\u5317\u4eac\u5723\u5609\u5965\u5bb6\u5177\u6709\u9650\u516c\u53f8-\u91d1\u7545\u900d","sales_rep":1005,"logo":"","salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},"project":{"id":4124,"key":4124,"name":"\u6df1\u4fe1\u670d\u6258\u7ba1\u4e91\u65b0\u8d2d"},"product":{"id":2259,"key":2259,"name":"\u7f51\u7edc\u4e0eCDN \u7535\u4fe1\u5e26\u5bbd\u3001IP\u4f18\u60e0\u5305-\u6e56\u5357\uff08\u957f\u6c99\u4e00\u533a\uff09"},"supplier":{"id":757,"key":757,"name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"},"productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"renewLogs":[],"bgcolor":"#89c541"},{"id":13937,"sales_order_id":"","product_id":2258,"parent":"","sn":"","supplier_id":757,"order":0,"created_by":1011,"created_at":"2026-03-04 16:35:47","updated_at":"2026-03-04 16:35:47","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"2026-03-04","maintenance_from":"","hardware_to":"","software_to":"2027-03-03","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"2027-03-03","new_maintenance_deadline":"","client_id":3448,"project_id":4124,"sales_rep":1005,"sales_date":"2026-03-04","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"600","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":143,"erp_sales_gift_id":"","client":{"id":3448,"key":3448,"name":"\u5317\u4eac\u5723\u5609\u5965\u5bb6\u5177\u6709\u9650\u516c\u53f8-\u91d1\u7545\u900d","sales_rep":1005,"logo":"","salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},"project":{"id":4124,"key":4124,"name":"\u6df1\u4fe1\u670d\u6258\u7ba1\u4e91\u65b0\u8d2d"},"product":{"id":2258,"key":2258,"name":"\u516c\u6709\u4e91 \u4e91\u4e3b\u673a\uff08\u5357\u533a\uff09\u670d\u52a1\u8d39 \u9ad8\u6027\u80fd\u5757\u5b58\u50a8\uff08\u6807\u51c6\u578b\uff09"},"supplier":{"id":757,"key":757,"name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"},"productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"renewLogs":[],"bgcolor":"#89c541"},{"id":13936,"sales_order_id":"","product_id":2257,"parent":"","sn":"","supplier_id":757,"order":0,"created_by":1011,"created_at":"2026-03-04 16:35:47","updated_at":"2026-03-04 16:35:47","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"2026-03-04","maintenance_from":"","hardware_to":"","software_to":"2027-03-03","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"2027-03-03","new_maintenance_deadline":"","client_id":3448,"project_id":4124,"sales_rep":1005,"sales_date":"2026-03-04","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"100","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":143,"erp_sales_gift_id":"","client":{"id":3448,"key":3448,"name":"\u5317\u4eac\u5723\u5609\u5965\u5bb6\u5177\u6709\u9650\u516c\u53f8-\u91d1\u7545\u900d","sales_rep":1005,"logo":"","salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},"project":{"id":4124,"key":4124,"name":"\u6df1\u4fe1\u670d\u6258\u7ba1\u4e91\u65b0\u8d2d"},"product":{"id":2257,"key":2257,"name":"\u516c\u6709\u4e91 \u4e91\u4e3b\u673a\uff08\u5357\u533a\uff09\u670d\u52a1\u8d39 ecs.c6.large\uff082\u68384G\uff09"},"supplier":{"id":757,"key":757,"name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"},"productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"renewLogs":[],"bgcolor":"#89c541"},{"id":13935,"sales_order_id":"","product_id":1275,"parent":"","sn":"SGC0087199","supplier_id":59,"order":0,"created_by":1011,"created_at":"2026-03-04 15:51:10","updated_at":"2026-03-05 10:31:22","pn":"AJ737A","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2026-02-28","software_from":"","maintenance_from":"","hardware_to":"2027-02-28","software_to":"","maintenance_to":"","new_hardware_deadline":"2027-02-28","new_software_deadline":"","new_maintenance_deadline":"","client_id":2021,"project_id":4121,"sales_rep":5300,"sales_date":"2026-03-04","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"720","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":142,"erp_sales_gift_id":"","client":{"id":2021,"key":2021,"name":"\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5311,"logo":"","salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280"}},"project":{"id":4121,"key":4121,"name":"\u786c\u76d8\u786c\u76d8-HP P2000-SAS 450GB-20260227"},"product":{"id":1275,"key":1275,"name":"AJ737A\uff08480939-001\uff09"},"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"renewLogs":[],"bgcolor":"#89c541"},{"id":13934,"sales_order_id":"","product_id":1780,"parent":"","sn":"X0V0A0KYF4UR","supplier_id":598,"order":0,"created_by":1011,"created_at":"2026-03-02 15:03:21","updated_at":"2026-03-04 15:01:02","pn":"X343A-R6","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2026-03-02","software_from":"","maintenance_from":"","hardware_to":"2027-03-02","software_to":"","maintenance_to":"","new_hardware_deadline":"2027-03-02","new_software_deadline":"","new_maintenance_deadline":"","client_id":89,"project_id":4123,"sales_rep":1005,"sales_date":"2026-03-02","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"3100","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":141,"erp_sales_gift_id":"","client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","sales_rep":1005,"logo":"","salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},"project":{"id":4123,"key":4123,"name":"FAS8300\u786c\u76d8\u6269\u5bb9-6\u5757 1.8T SAS"},"product":{"id":1780,"key":1780,"name":"X343A-R6"},"supplier":{"id":598,"key":598,"name":"\u5317\u4eac\u94f6\u65af\u6cf0\u7ecf\u8d38\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"renewLogs":[],"bgcolor":"#89c541"},{"id":13933,"sales_order_id":"","product_id":1780,"parent":"","sn":"Y070A07HF4VR","supplier_id":598,"order":0,"created_by":1011,"created_at":"2026-03-02 15:03:21","updated_at":"2026-03-04 15:01:24","pn":"X343A-R6","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2026-03-02","software_from":"","maintenance_from":"","hardware_to":"2027-03-02","software_to":"","maintenance_to":"","new_hardware_deadline":"2027-03-02","new_software_deadline":"","new_maintenance_deadline":"","client_id":89,"project_id":4123,"sales_rep":1005,"sales_date":"2026-03-02","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"3100","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":141,"erp_sales_gift_id":"","client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","sales_rep":1005,"logo":"","salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},"project":{"id":4123,"key":4123,"name":"FAS8300\u786c\u76d8\u6269\u5bb9-6\u5757 1.8T SAS"},"product":{"id":1780,"key":1780,"name":"X343A-R6"},"supplier":{"id":598,"key":598,"name":"\u5317\u4eac\u94f6\u65af\u6cf0\u7ecf\u8d38\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"renewLogs":[],"bgcolor":"#89c541"},{"id":13932,"sales_order_id":"","product_id":1780,"parent":"","sn":"X0P0A066F4UR","supplier_id":598,"order":0,"created_by":1011,"created_at":"2026-03-02 15:03:21","updated_at":"2026-03-04 15:01:47","pn":"X343A-R6","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2026-03-02","software_from":"","maintenance_from":"","hardware_to":"2027-03-02","software_to":"","maintenance_to":"","new_hardware_deadline":"2027-03-02","new_software_deadline":"","new_maintenance_deadline":"","client_id":89,"project_id":4123,"sales_rep":1005,"sales_date":"2026-03-02","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"3100","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":141,"erp_sales_gift_id":"","client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","sales_rep":1005,"logo":"","salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},"project":{"id":4123,"key":4123,"name":"FAS8300\u786c\u76d8\u6269\u5bb9-6\u5757 1.8T SAS"},"product":{"id":1780,"key":1780,"name":"X343A-R6"},"supplier":{"id":598,"key":598,"name":"\u5317\u4eac\u94f6\u65af\u6cf0\u7ecf\u8d38\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"renewLogs":[],"bgcolor":"#89c541"},{"id":13931,"sales_order_id":"","product_id":1780,"parent":"","sn":"X0X0A04WF4VR","supplier_id":598,"order":0,"created_by":1011,"created_at":"2026-03-02 15:03:21","updated_at":"2026-03-04 15:02:19","pn":"X343A-R6","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2026-03-02","software_from":"","maintenance_from":"","hardware_to":"2027-03-02","software_to":"","maintenance_to":"","new_hardware_deadline":"2027-03-02","new_software_deadline":"","new_maintenance_deadline":"","client_id":89,"project_id":4123,"sales_rep":1005,"sales_date":"2026-03-02","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"3100","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":141,"erp_sales_gift_id":"","client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","sales_rep":1005,"logo":"","salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},"project":{"id":4123,"key":4123,"name":"FAS8300\u786c\u76d8\u6269\u5bb9-6\u5757 1.8T SAS"},"product":{"id":1780,"key":1780,"name":"X343A-R6"},"supplier":{"id":598,"key":598,"name":"\u5317\u4eac\u94f6\u65af\u6cf0\u7ecf\u8d38\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"renewLogs":[],"bgcolor":"#89c541"},{"id":13930,"sales_order_id":"","product_id":1780,"parent":"","sn":"X0X0A0BVF4VR","supplier_id":598,"order":0,"created_by":1011,"created_at":"2026-03-02 15:03:21","updated_at":"2026-03-04 15:02:44","pn":"X343A-R6","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2026-03-02","software_from":"","maintenance_from":"","hardware_to":"2027-03-02","software_to":"","maintenance_to":"","new_hardware_deadline":"2027-03-02","new_software_deadline":"","new_maintenance_deadline":"","client_id":89,"project_id":4123,"sales_rep":1005,"sales_date":"2026-03-02","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"3100","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":141,"erp_sales_gift_id":"","client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","sales_rep":1005,"logo":"","salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},"project":{"id":4123,"key":4123,"name":"FAS8300\u786c\u76d8\u6269\u5bb9-6\u5757 1.8T SAS"},"product":{"id":1780,"key":1780,"name":"X343A-R6"},"supplier":{"id":598,"key":598,"name":"\u5317\u4eac\u94f6\u65af\u6cf0\u7ecf\u8d38\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"renewLogs":[],"bgcolor":"#89c541"},{"id":13929,"sales_order_id":"","product_id":1780,"parent":"","sn":"Y070A00FF4VR","supplier_id":598,"order":0,"created_by":1011,"created_at":"2026-03-02 15:03:21","updated_at":"2026-03-04 15:03:15","pn":"X343A-R6","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2026-03-02","software_from":"","maintenance_from":"","hardware_to":"2027-03-02","software_to":"","maintenance_to":"","new_hardware_deadline":"2027-03-02","new_software_deadline":"","new_maintenance_deadline":"","client_id":89,"project_id":4123,"sales_rep":1005,"sales_date":"2026-03-02","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"3100","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":141,"erp_sales_gift_id":"","client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","sales_rep":1005,"logo":"","salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},"project":{"id":4123,"key":4123,"name":"FAS8300\u786c\u76d8\u6269\u5bb9-6\u5757 1.8T SAS"},"product":{"id":1780,"key":1780,"name":"X343A-R6"},"supplier":{"id":598,"key":598,"name":"\u5317\u4eac\u94f6\u65af\u6cf0\u7ecf\u8d38\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"renewLogs":[],"bgcolor":"#89c541"},{"id":13925,"sales_order_id":"","product_id":1925,"parent":"","sn":"","supplier_id":757,"order":0,"created_by":5360,"created_at":"2026-02-27 15:13:44","updated_at":"2026-02-27 16:44:19","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"2026-01-21","maintenance_from":"","hardware_to":"","software_to":"2027-02-28","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"2027-02-28","new_maintenance_deadline":"","client_id":79,"project_id":4103,"sales_rep":5295,"sales_date":"2026-02-27","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"4250","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":140,"erp_sales_gift_id":"","client":{"id":79,"key":79,"name":"\u5317\u4eac\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8(\u5317\u4eac\u79c0\u6c34\u8857\u5e02\u573a\u6709\u9650\u516c\u53f8)","sales_rep":5295,"logo":"","salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},"project":{"id":4103,"key":4103,"name":"2026\u6df1\u4fe1\u670d\u9632\u706b\u5899\u7eed\u4fdd"},"product":{"id":1925,"key":1925,"name":"SASE-SWG\u4e92\u8054\u7f51\u5b89\u5168\u8bbf\u95ee\u670d\u52a1-\u5206\u652f\u7248(100M\u5e26\u5bbd\uff09"},"supplier":{"id":757,"key":757,"name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"},"productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"renewLogs":[],"bgcolor":"#89c541"},{"id":13924,"sales_order_id":"","product_id":2241,"parent":"","sn":"AM2601FF0158A82A","supplier_id":660,"order":0,"created_by":1011,"created_at":"2026-02-10 15:21:23","updated_at":"2026-03-05 10:45:06","pn":"XMS1000","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2026-02-10","software_from":"","maintenance_from":"","hardware_to":"2027-02-09","software_to":"","maintenance_to":"","new_hardware_deadline":"2027-02-09","new_software_deadline":"","new_maintenance_deadline":"","client_id":2125,"project_id":4113,"sales_rep":5087,"sales_date":"2026-02-10","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"312000","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":139,"erp_sales_gift_id":"","client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","sales_rep":5087,"logo":"","salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},"project":{"id":4113,"key":4113,"name":"\u4f1a\u8bae\u5ba4\u7cfb\u7edf-K"},"product":{"id":2241,"key":2241,"name":"XMS1000"},"supplier":{"id":660,"key":660,"name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"productType":"","productComponent":"","productBrand":"","productSerie":"","productMisc":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"renewLogs":[],"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":9199,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"66.249.66.8","ua":"Mozilla\/5.0 (Linux; Android 6.0.1; Nexus 5X Build\/MMB29P) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/150.0.7871.46 Mobile Safari\/537.36 (compatible; GoogleOther)"}', FALSE, '2026-07-07 18:39:27', 326630656) RETURNING "id"