ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
688e1b95d2edf: GET https://beta.jinchangxiao.com/vue/analysis/sales-order at 2025-08-02 10:07:17 pm by 52.0.105.244

Database Queries

总计18条数据
TimeDurationTypeQuery
  
22:07:17.8742.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
22:07:17.8771.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
22:07:17.8828.5 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;

[+] Explain
22:07:17.89117.1 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

[+] Explain
22:07:17.95448.5 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, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 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"

[+] Explain
22:07:18.00323.2 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, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 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

[+] Explain
22:07:18.0300.5 msSELECTSELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2708, 918, 107, 12, 2548, 3281, 518, 2736, 93, 531, 4, 3329)

[+] Explain
22:07:18.0300.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5295, 5087, 5300, 5329, 5311)

[+] Explain
22:07:18.0310.9 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3400, 3290, 3777, 3794, 3750, 3771, 3772, 3793, 3699, 3666, 3791, 3789, 3780)

[+] Explain
22:07:18.0326.6 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_products" WHERE "id" IN (941, 923, 942, 1956, 1770, 950, 1529, 1955, 922, 542, 1954, 1953)

[+] Explain
22:07:18.0391.6 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (236, 608, 516, 583, 676, 534, 684, 678, 489, 623)

[+] Explain
22:07:18.0400.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)

[+] Explain
22:07:18.0410.4 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 5360))

[+] Explain
22:07:18.0410.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3

[+] Explain
22:07:18.0420.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_order_item_renew_logs" WHERE "sales_order_item_id" IN (5359, 5347, 5334, 5330, 5329, 5328, 5327, 12710, 12709, 12708, 12707, 12706, 12705, 12704, 12703, 12702, 12701, 12700, 12699, 12698) ORDER BY "sales_date", "created_at"

[+] Explain
22:07:18.0448.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-08-02')

[+] Explain
22:07:18.0532.2 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=4, "last_visit_at"='now()' WHERE "id"=49888

[+] Explain
22:07:18.0562.6 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/sales-order', '[]', '{"code":2000,"result":{"list":[{"id":5359,"sales_order_id":"","product_id":941,"parent":"","sn":"","supplier_id":"","order":0,"created_by":1011,"created_at":"2024-01-23 10:36:46","updated_at":"2024-01-23 10:36:46","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":2708,"project_id":3400,"sales_rep":5359,"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":"300","cost":"0","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":2708,"key":2708,"name":"\u5317\u4eac\u5e02\u77f3\u666f\u5c71\u533a\u6559\u80b2\u59d4\u5458\u4f1a","sales_rep":5329,"logo":"","salesRep":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5"}},"project":{"id":3400,"key":3400,"name":"\u8fc7\u4fdd\u7ef4\u4fee"},"product":{"id":941,"key":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\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":5347,"sales_order_id":"","product_id":941,"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":"121650","cost":"0","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"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\u6657\u7131"}},"project":{"id":3290,"key":3290,"name":"2023\u5e74-2024\u5e74\u7eed\u4fdd\u5408\u540c"},"product":{"id":941,"key":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\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":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,"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\u6657\u7131"}},"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":5330,"sales_order_id":"","product_id":942,"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":"2500","cost":"1500","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"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\u6657\u7131"}},"project":{"id":3290,"key":3290,"name":"2023\u5e74-2024\u5e74\u7eed\u4fdd\u5408\u540c"},"product":{"id":942,"key":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\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":5329,"sales_order_id":"","product_id":942,"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":"2500","cost":"1500","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"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\u6657\u7131"}},"project":{"id":3290,"key":3290,"name":"2023\u5e74-2024\u5e74\u7eed\u4fdd\u5408\u540c"},"product":{"id":942,"key":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\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":5328,"sales_order_id":"","product_id":942,"parent":"","sn":"","supplier_id":"","order":0,"created_by":1011,"created_at":"2024-01-22 10:27:17","updated_at":"2024-01-22 10:27:17","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":"2500","cost":"1500","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"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\u6657\u7131"}},"project":{"id":3290,"key":3290,"name":"2023\u5e74-2024\u5e74\u7eed\u4fdd\u5408\u540c"},"product":{"id":942,"key":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\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":5327,"sales_order_id":"","product_id":942,"parent":"","sn":"","supplier_id":"","order":0,"created_by":1011,"created_at":"2024-01-22 10:27:17","updated_at":"2024-01-22 10:27:17","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":"2500","cost":"1500","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"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\u6657\u7131"}},"project":{"id":3290,"key":3290,"name":"2023\u5e74-2024\u5e74\u7eed\u4fdd\u5408\u540c"},"product":{"id":942,"key":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\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":12710,"sales_order_id":"","product_id":1956,"parent":"","sn":"","supplier_id":236,"order":0,"created_by":5360,"created_at":"2025-03-14 11:27:10","updated_at":"2025-03-14 11:27:35","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":107,"project_id":3777,"sales_rep":5295,"sales_date":"2025-03-14","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":"390.00","cost":"104.20","is_renew":false,"renew_to_sales_order_item_id":"","number":90,"is_merge":true,"need_sn":true,"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","sales_rep":5295,"logo":"","salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},"project":{"id":3777,"key":3777,"name":"2025\u65b0\u8d2d\u6df1\u4fe1\u670dEDR-K"},"product":{"id":1956,"key":1956,"name":"\u6df1\u4fe1\u670d\u7aef\u70b9\u5b89\u5168\u8f6f\u4ef6V6.0\uff08PC\u5168\u91cf\u7248\uff09"},"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\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":12709,"sales_order_id":"","product_id":1770,"parent":"","sn":"832C12N1EY7U","supplier_id":608,"order":0,"created_by":5360,"created_at":"2025-03-12 13:42:10","updated_at":"2025-03-14 10:08:24","pn":"KBG50ZNS512G","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2025-03-12","software_from":"","maintenance_from":"","hardware_to":"2026-03-11","software_to":"","maintenance_to":"","new_hardware_deadline":"2026-03-11","new_software_deadline":"","new_maintenance_deadline":"","client_id":12,"project_id":3794,"sales_rep":5300,"sales_date":"2025-03-12","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":"511.00","cost":"256.00","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","sales_rep":5300,"logo":"","salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},"project":{"id":3794,"key":3794,"name":"POBJ25031110-\u56fa\u6001\u786c\u76d8-G-2025"},"product":{"id":1770,"key":1770,"name":"BG5 512G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8"},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"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":12708,"sales_order_id":"","product_id":950,"parent":"","sn":"","supplier_id":516,"order":0,"created_by":1011,"created_at":"2025-03-11 10:34:26","updated_at":"2025-03-11 10:34:26","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":2548,"project_id":3750,"sales_rep":1005,"sales_date":"2025-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":"774255.00","cost":"617500.00","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":2548,"key":2548,"name":"\u5317\u4eac\u6da6\u7fd4\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1005,"logo":"","salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"project":{"id":3750,"key":3750,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f"},"product":{"id":950,"key":950,"name":"\u4e8c\u4ee3\u8bc1\u751f\u4ea7\u81ea\u52a8\u5316\u8bbe\u5907"},"supplier":{"id":516,"key":516,"name":"\u5929\u6d25\u665f\u6e90\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":12707,"sales_order_id":"","product_id":1529,"parent":"","sn":"","supplier_id":583,"order":0,"created_by":1011,"created_at":"2025-03-10 16:25:50","updated_at":"2025-03-10 16:25:50","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"2025-01-16","maintenance_from":"","hardware_to":"","software_to":"2025-02-16","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"2025-02-16","new_maintenance_deadline":"","client_id":3281,"project_id":3771,"sales_rep":5295,"sales_date":"2025-03-10","description":"","software_reminded":true,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":true,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"5869.50","cost":"4871.66","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":3281,"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09","sales_rep":5295,"logo":"","salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},"project":{"id":3771,"key":3771,"name":"\u6269\u5bb9\u901f\u77f31\u53f0\u8ba1\u7b97\u8282\u70b9"},"product":{"id":1529,"key":1529,"name":"FCP-SUITE-CPU-Level1"},"supplier":{"id":583,"key":583,"name":"\u4e0a\u6d77\u901f\u77f3\u4fe1\u606f\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":12706,"sales_order_id":"","product_id":1955,"parent":"","sn":"409020250200059","supplier_id":676,"order":0,"created_by":5360,"created_at":"2025-03-10 13:19:19","updated_at":"2025-03-10 14:55:56","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"","maintenance_from":"2025-03-10","hardware_to":"","software_to":"","maintenance_to":"2028-03-09","new_hardware_deadline":"","new_software_deadline":"","new_maintenance_deadline":"2028-03-09","client_id":518,"project_id":3772,"sales_rep":5295,"sales_date":"2025-03-10","description":"\u4ee3\u7406\u5546\u8d28\u4fdd3\u5e74","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":"28000.00","cost":"25000.00","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"logo":"","salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},"project":{"id":3772,"key":3772,"name":"2025\u65b0\u8d2d4090\u663e\u5361-K"},"product":{"id":1955,"key":1955,"name":"NVIDIA RTX A4090"},"supplier":{"id":676,"key":676,"name":"\u5317\u4eac\u5b89\u8054\u901a\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":12705,"sales_order_id":"","product_id":941,"parent":"","sn":"","supplier_id":"","order":0,"created_by":1011,"created_at":"2025-03-10 11:15:27","updated_at":"2025-03-11 10:39:41","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":2736,"project_id":3793,"sales_rep":5300,"sales_date":"2025-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":"2500.00","cost":"0","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":false,"client":{"id":2736,"key":2736,"name":"\u5317\u4eac\u4e2d\u6570\u521b\u65b0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u7f51\u6839\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8)","sales_rep":5300,"logo":"","salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},"project":{"id":3793,"key":3793,"name":"\u9632\u706b\u5899\u6545\u969c\u5904\u7f6e\u548c\u79df\u8d41-G-2025"},"product":{"id":941,"key":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\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":12704,"sales_order_id":"","product_id":942,"parent":"","sn":"","supplier_id":534,"order":0,"created_by":1011,"created_at":"2025-03-07 11:57:29","updated_at":"2025-03-07 13:26:30","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":93,"project_id":3699,"sales_rep":1005,"sales_date":"2025-03-07","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":"0","cost":"31000.00","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":false,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1005,"logo":"","salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"project":{"id":3699,"key":3699,"name":"\u7b2c\u4e8c\u56ed\u533a\u65b0\u8d2d\u51fa\u53e3\u9632\u706b\u5899-\u98de\u5854"},"product":{"id":942,"key":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\u670d\u52a1"},"supplier":{"id":534,"key":534,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\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":12703,"sales_order_id":"","product_id":922,"parent":"","sn":"\u7f51\u5173ID:6616425403","supplier_id":684,"order":0,"created_by":1011,"created_at":"2025-03-07 11:56:22","updated_at":"2025-03-07 17:17:15","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"2025-03-07","maintenance_from":"","hardware_to":"","software_to":"2026-03-07","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"2026-03-07","new_maintenance_deadline":"","client_id":918,"project_id":3666,"sales_rep":1005,"sales_date":"2025-03-07","description":"55\u4e2a\u670d\u52a1\u5668\u7aef \u7248\u672c\uff1aAES 6.0.2R1","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":"0","cost":"3500.00","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"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\u6657\u7131"}},"project":{"id":3666,"key":3666,"name":"24-25\u5e74\u7eed\u4fdd\u9879\u76ee"},"product":{"id":922,"key":922,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0EDR\u7eed\u4fdd\u670d\u52a1"},"supplier":{"id":684,"key":684,"name":"\u6e56\u5357\u6df1\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":12702,"sales_order_id":"","product_id":542,"parent":"","sn":"SMD7A01866J3B306K3A0X","supplier_id":678,"order":0,"created_by":5360,"created_at":"2025-03-06 15:40:44","updated_at":"2025-03-06 17:24:06","pn":"00YK017","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2025-03-05","software_from":"","maintenance_from":"","hardware_to":"2025-03-06","software_to":"","maintenance_to":"","new_hardware_deadline":"2025-03-06","new_software_deadline":"","new_maintenance_deadline":"","client_id":531,"project_id":3791,"sales_rep":5300,"sales_date":"2025-03-06","description":"","software_reminded":false,"hardware_reminded":true,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":true,"maintenance_advance_reminded":false,"is_system":true,"amount":"3150.00","cost":"1300.00","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)","sales_rep":5311,"logo":"","salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587"}},"project":{"id":3791,"key":3791,"name":"\u786c\u76d81.8T1\u5757-K-2025"},"product":{"id":542,"key":542,"name":"00YK017"},"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\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":12701,"sales_order_id":"","product_id":1954,"parent":"","sn":"PSD057174356703","supplier_id":489,"order":0,"created_by":1011,"created_at":"2025-03-06 10:05:52","updated_at":"2025-03-07 17:51:21","pn":"114-00065+B0","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2025-03-06","software_from":"","maintenance_from":"","hardware_to":"2026-03-05","software_to":"","maintenance_to":"","new_hardware_deadline":"2026-03-05","new_software_deadline":"","new_maintenance_deadline":"","client_id":4,"project_id":3789,"sales_rep":5300,"sales_date":"2025-03-06","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":"850.00","cost":"500.00","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":4,"key":4,"name":"\u6cb3\u5317\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8\/\u6cb3\u5317\u5c1a\u548c\u5546\u8d38\u6709\u9650\u516c\u53f8","sales_rep":5300,"logo":"","salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},"project":{"id":3789,"key":3789,"name":"\u7535\u6e90-netapp-FAS2240-2\u5757-G-2025"},"product":{"id":1954,"key":1954,"name":"114-00087+C0"},"supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\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":12700,"sales_order_id":"","product_id":1954,"parent":"","sn":"PSD057174356716","supplier_id":489,"order":0,"created_by":1011,"created_at":"2025-03-06 10:05:52","updated_at":"2025-03-07 17:51:04","pn":"114-00065+B0","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2025-03-06","software_from":"","maintenance_from":"","hardware_to":"2026-03-05","software_to":"","maintenance_to":"","new_hardware_deadline":"2026-03-05","new_software_deadline":"","new_maintenance_deadline":"","client_id":4,"project_id":3789,"sales_rep":5300,"sales_date":"2025-03-06","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":"850.00","cost":"500.00","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":4,"key":4,"name":"\u6cb3\u5317\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8\/\u6cb3\u5317\u5c1a\u548c\u5546\u8d38\u6709\u9650\u516c\u53f8","sales_rep":5300,"logo":"","salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},"project":{"id":3789,"key":3789,"name":"\u7535\u6e90-netapp-FAS2240-2\u5757-G-2025"},"product":{"id":1954,"key":1954,"name":"114-00087+C0"},"supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\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":12699,"sales_order_id":"","product_id":1953,"parent":"","sn":"2MCC11730","supplier_id":623,"order":0,"created_by":1011,"created_at":"2025-03-06 10:01:12","updated_at":"2025-03-06 17:29:48","pn":"CS5260H2","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2024-12-24","software_from":"","maintenance_from":"","hardware_to":"2028-01-31","software_to":"","maintenance_to":"","new_hardware_deadline":"2028-01-31","new_software_deadline":"","new_maintenance_deadline":"","client_id":3329,"project_id":3780,"sales_rep":5087,"sales_date":"2025-03-06","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":"46250","cost":"37000.00","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":3329,"key":3329,"name":"\u6df1\u5733\u9f50\u5fc3\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8 (\u8fc7\u5355\uff09","sales_rep":5087,"logo":"","salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},"project":{"id":3780,"key":3780,"name":"59\u6240\u56fd\u4ea7\u670d\u52a1\u5668\u91c7\u8d2d -k"},"product":{"id":1953,"key":1953,"name":"CS5260H2"},"supplier":{"id":623,"key":623,"name":"\u5317\u4eac\u9f50\u4fe1\u5171\u8d62\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":12698,"sales_order_id":"","product_id":1953,"parent":"","sn":"2MCC11710","supplier_id":623,"order":0,"created_by":1011,"created_at":"2025-03-06 10:01:12","updated_at":"2025-03-06 17:30:57","pn":"CS5260H2","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2024-12-28","software_from":"","maintenance_from":"","hardware_to":"2028-01-31","software_to":"","maintenance_to":"","new_hardware_deadline":"2028-01-31","new_software_deadline":"","new_maintenance_deadline":"","client_id":3329,"project_id":3780,"sales_rep":5087,"sales_date":"2025-03-06","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":"46250","cost":"37000.00","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":3329,"key":3329,"name":"\u6df1\u5733\u9f50\u5fc3\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8 (\u8fc7\u5355\uff09","sales_rep":5087,"logo":"","salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},"project":{"id":3780,"key":3780,"name":"59\u6240\u56fd\u4ea7\u670d\u52a1\u5668\u91c7\u8d2d -k"},"product":{"id":1953,"key":1953,"name":"CS5260H2"},"supplier":{"id":623,"key":623,"name":"\u5317\u4eac\u9f50\u4fe1\u5171\u8d62\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":8292,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-02 22:07:18') RETURNING "id"

[+] Explain