ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c90d279fea0: POST https://beta.jinchangxiao.com/vue/analysis/sales-product-list-all at 2025-09-16 03:09:27 pm by 114.244.128.96

Performance Profiling

Total processing time: 90 ms; Peak memory: 5.694 MB. Show Profiling Timeline

总计24条数据
TimeDurationCategoryInfo
  
15:09:27.68810.3 msyii\db\Command::querySELECT sum(total_amount) as budget, sum(total_cost) as cost, sum(total_amount - total_cost) as profits, sum(total_amount - total_cost) / sum(total_amount) * 100 as profit_pct FROM (SELECT COALESCE(ppr.amount, 0) as amount, COALESCE(ppr.cost, 0) as cost, ppr.*, project.bargain_date, (ppr.total_amount - ppr.total_cost) as total_profit, CASE WHEN ppr.amount > 0 THEN (ppr.amount - ppr.cost) / ppr.amount * 100 ELSE null END as total_profit_pct FROM "a57be577deb434"."tbl_project_product_rels" "ppr" LEFT JOIN "a57be577deb434"."tbl_products" "p" ON ppr.product_id = p.id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON ppr.project_id = project.id WHERE ("project"."created_by" IN (5301, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 5448, 5420, 1001, 5087, 1008, 5230, 5088, 5208, 1003, 5294, 5357, 5076, 5300, 5089, 5311, 5364, 5295, 1013, 5128, 5203, 1004, 5072, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND (((project.budget > project.collected) AND ("project"."project_status" IN ('3', '-1'))) OR ((project.budget <= project.collected) AND ("project"."project_status"=3)))) "sub"
15:09:27.7105.6 msyii\db\Command::querySELECT 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_project_product_rels' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
15:09:27.7055.2 msyii\db\Command::querySELECT COALESCE(ppr.amount, 0) as amount, COALESCE(ppr.cost, 0) as cost, ppr.*, project.bargain_date, (ppr.total_amount - ppr.total_cost) as total_profit, CASE WHEN ppr.amount > 0 THEN (ppr.amount - ppr.cost) / ppr.amount * 100 ELSE null END as total_profit_pct FROM "a57be577deb434"."tbl_project_product_rels" "ppr" LEFT JOIN "a57be577deb434"."tbl_products" "p" ON ppr.product_id = p.id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON ppr.project_id = project.id WHERE ("project"."created_by" IN (5301, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 5448, 5420, 1001, 5087, 1008, 5230, 5088, 5208, 1003, 5294, 5357, 5076, 5300, 5089, 5311, 5364, 5295, 1013, 5128, 5203, 1004, 5072, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND (((project.budget > project.collected) AND ("project"."project_status" IN ('3', '-1'))) OR ((project.budget <= project.collected) AND ("project"."project_status"=3))) ORDER BY "project"."bargain_date" DESC, "project"."updated_at" DESC LIMIT 20
15:09:27.6995.1 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT COALESCE(ppr.amount, 0) as amount, COALESCE(ppr.cost, 0) as cost, ppr.*, project.bargain_date, (ppr.total_amount - ppr.total_cost) as total_profit, CASE WHEN ppr.amount > 0 THEN (ppr.amount - ppr.cost) / ppr.amount * 100 ELSE null END as total_profit_pct FROM "a57be577deb434"."tbl_project_product_rels" "ppr" LEFT JOIN "a57be577deb434"."tbl_products" "p" ON ppr.product_id = p.id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON ppr.project_id = project.id WHERE ("project"."created_by" IN (5301, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 5448, 5420, 1001, 5087, 1008, 5230, 5088, 5208, 1003, 5294, 5357, 5076, 5300, 5089, 5311, 5364, 5295, 1013, 5128, 5203, 1004, 5072, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND (((project.budget > project.collected) AND ("project"."project_status" IN ('3', '-1'))) OR ((project.budget <= project.collected) AND ("project"."project_status"=3))) ORDER BY "project"."bargain_date" DESC, "project"."updated_at" DESC) "c"
15:09:27.7164.5 msyii\db\Command::queryselect 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_project_product_rels' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
15:09:27.6644.0 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:09:27.7343.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1011) AND ("object_type"=23) AND ("visit_date"='2025-09-16')
15:09:27.6783.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
15:09:27.6682.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1011
15:09:27.7402.4 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1011, 5, 'vue/analysis/sales-product-list-all', '{"page":"1","project_status":["3","-1"],"web_access_token":"18_8RvXePAHKXb4kC8IN2O6XIdrtwTnd"}', '{"code":2000,"result":{"list":[{"amount":"788888.00","cost":"89","id":10736,"project_id":3959,"product_id":1040,"number":1,"description":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"788888","total_cost":"89.00","erp_sales_order_product_id":1878,"bargain_date":"2025-09-11","total_profit":"788799.00","total_profit_pct":"99.99","project":{"id":3959,"client_id":1661,"project_status":3,"project_progress":2,"budget":"788888","profit_pct":"99.98","bargain_date":"2025-09-11","description":"","created_by":1001,"created_at":"2025-09-11 10:48:23","updated_at":"2025-09-12 17:01:06","engineer_id":"","project_title":"\u5409\u5fb7\u79d1\u5a03","collected":"88","status_updated_at":"2025-09-11 10:49:29.797789+08","success_rate":"","comment":"\u91d1\u5a1c\u5a1c","contract_type":1,"progress_updated_at":"2025-09-11 10:48:23.373331+08","forecast_updated_at":"2025-09-11 10:48:23.373331+08","end_at":"","pinyin_shortcut":"jdkw","creator":1000,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1014,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4140,"from_project":3959,"serial_no":"2025-09-11-001"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":1040,"name":"\u5b81\u76fe\u4ee4\u724c\u8f6f\u4ef6V1.0","product_type":7,"product_component":32,"product_brand":137,"product_serie":633,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-09-25 16:31:25","updated_at":"2025-09-15 16:19:45","pinyin_shortcut":"ndlprjV10","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":32,"key":32,"name":"\u9632\u75c5\u6bd2\u8f6f\u4ef6"},"productBrand":{"id":137,"key":137,"name":"\u5b81\u76fe"},"productSerie":{"id":633,"key":633,"name":"\u4ee4\u724c"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"amount":"790000.00","cost":"32.00","id":10734,"project_id":3796,"product_id":1040,"number":2,"description":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"1580000","total_cost":"64","erp_sales_order_product_id":1877,"bargain_date":"2025-09-10","total_profit":"1579936","total_profit_pct":"100.00","project":{"id":3796,"client_id":2125,"project_status":3,"project_progress":3,"budget":"1580000","profit_pct":"99.99","bargain_date":"2025-09-10","description":"","created_by":5087,"created_at":"2025-03-09 10:00:35","updated_at":"2025-09-10 17:52:12","engineer_id":"","project_title":"deepseek\u79c1\u6709\u5316\u90e8\u7f72-239-K","collected":"0","status_updated_at":"2025-09-10 17:48:33.816744+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-05-25 16:43:18.119966+08","forecast_updated_at":"2025-05-25 16:43:18.119966+08","end_at":"","pinyin_shortcut":"deepseeksyhbs239K","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1013,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382"},"usedClient":"","buildContract":{"id":4139,"from_project":3796,"serial_no":"2025-09-10-005"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":1040,"name":"\u5b81\u76fe\u4ee4\u724c\u8f6f\u4ef6V1.0","product_type":7,"product_component":32,"product_brand":137,"product_serie":633,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-09-25 16:31:25","updated_at":"2025-09-15 16:19:45","pinyin_shortcut":"ndlprjV10","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":32,"key":32,"name":"\u9632\u75c5\u6bd2\u8f6f\u4ef6"},"productBrand":{"id":137,"key":137,"name":"\u5b81\u76fe"},"productSerie":{"id":633,"key":633,"name":"\u4ee4\u724c"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"amount":"1150000.00","cost":"0","id":10731,"project_id":3854,"product_id":1040,"number":1,"description":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"1150000","total_cost":"0","erp_sales_order_product_id":1876,"bargain_date":"2025-09-10","total_profit":"1150000","total_profit_pct":"100.00","project":{"id":3854,"client_id":2128,"project_status":3,"project_progress":5,"budget":"1150000","profit_pct":"100","bargain_date":"2025-09-10","description":"","created_by":5087,"created_at":"2025-05-13 09:35:09","updated_at":"2025-09-10 17:46:14","engineer_id":"","project_title":"\u58f9\u8fdb\u5236\u5907\u4efd\u4e8c\u671f","collected":"0","status_updated_at":"2025-09-10 17:41:01.360267+08","success_rate":"","comment":"\u4e8c\u671f\u6269\u5bb9","contract_type":1,"progress_updated_at":"2025-05-25 16:44:14.571721+08","forecast_updated_at":"2025-05-25 16:44:14.571721+08","end_at":"","pinyin_shortcut":"yjzbfeq","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1011,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u7814\u7a76\u624033\u6240"},"usedClient":"","buildContract":{"id":4138,"from_project":3854,"serial_no":"2025-09-10-004"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":1040,"name":"\u5b81\u76fe\u4ee4\u724c\u8f6f\u4ef6V1.0","product_type":7,"product_component":32,"product_brand":137,"product_serie":633,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-09-25 16:31:25","updated_at":"2025-09-15 16:19:45","pinyin_shortcut":"ndlprjV10","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":32,"key":32,"name":"\u9632\u75c5\u6bd2\u8f6f\u4ef6"},"productBrand":{"id":137,"key":137,"name":"\u5b81\u76fe"},"productSerie":{"id":633,"key":633,"name":"\u4ee4\u724c"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"amount":"0","cost":"0","id":10699,"project_id":3945,"product_id":2124,"number":1,"description":"","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"0","total_cost":"0","erp_sales_order_product_id":1864,"bargain_date":"2025-08-26","total_profit":"0","total_profit_pct":"0.00","project":{"id":3945,"client_id":1301,"project_status":3,"project_progress":9,"budget":"99786","profit_pct":"35.11","bargain_date":"2025-08-26","description":"","created_by":5295,"created_at":"2025-08-12 17:38:50","updated_at":"2025-09-01 10:01:29","engineer_id":"","project_title":"\u65b0\u8d2d\u5b89\u5168\u8bbe\u5907","collected":"159.9","status_updated_at":"2025-08-27 09:38:28.637361+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-25 10:08:39.306048+08","forecast_updated_at":"2025-08-18 10:42:23.506394+08","end_at":"","pinyin_shortcut":"xgaqsb","creator":5295,"used_client":"","from_contact":"","total_contact_point":"4000","paid_contact_point":"","project_product_version_id":1006,"is_sales_order_ready":false,"collected_plan":"99786.0","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"usedClient":"","buildContract":{"id":4130,"from_project":3945,"serial_no":"TS-WZW-20250826006"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2124,"name":"\u5b9a\u5236\u5197\u4f59\u4ea4\u6d41\u7535\u6e9040\/60W","product_type":5,"product_component":157,"product_brand":12,"product_serie":1699,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-29 10:01:17","updated_at":"2025-08-29 10:01:17","pinyin_shortcut":"dzryjldy4060W","product_unit":3,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1699,"key":1699,"name":"\u5b9a\u5236\u5197\u4f59\u4ea4\u6d41\u7535\u6e9040\/60W"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"amount":"26320.00","cost":"16876.87","id":10702,"project_id":3945,"product_id":2122,"number":1,"description":"","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"26320","total_cost":"16876.87","erp_sales_order_product_id":1867,"bargain_date":"2025-08-26","total_profit":"9443.13","total_profit_pct":"35.88","project":{"id":3945,"client_id":1301,"project_status":3,"project_progress":9,"budget":"99786","profit_pct":"35.11","bargain_date":"2025-08-26","description":"","created_by":5295,"created_at":"2025-08-12 17:38:50","updated_at":"2025-09-01 10:01:29","engineer_id":"","project_title":"\u65b0\u8d2d\u5b89\u5168\u8bbe\u5907","collected":"159.9","status_updated_at":"2025-08-27 09:38:28.637361+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-25 10:08:39.306048+08","forecast_updated_at":"2025-08-18 10:42:23.506394+08","end_at":"","pinyin_shortcut":"xgaqsb","creator":5295,"used_client":"","from_contact":"","total_contact_point":"4000","paid_contact_point":"","project_product_version_id":1006,"is_sales_order_ready":false,"collected_plan":"99786.0","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"usedClient":"","buildContract":{"id":4130,"from_project":3945,"serial_no":"TS-WZW-20250826006"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2122,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH2150B\uff09","product_type":7,"product_component":188,"product_brand":12,"product_serie":742,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-29 09:56:09","updated_at":"2025-08-29 09:56:09","pinyin_shortcut":"sxffhqrjV80syyAF1000FH2150B","product_unit":2,"is_renew":false,"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":742,"key":742,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6V8.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"amount":"3055.00","cost":"1961.87","id":10701,"project_id":3945,"product_id":2121,"number":1,"description":"","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"3055","total_cost":"1961.87","erp_sales_order_product_id":1866,"bargain_date":"2025-08-26","total_profit":"1093.13","total_profit_pct":"35.78","project":{"id":3945,"client_id":1301,"project_status":3,"project_progress":9,"budget":"99786","profit_pct":"35.11","bargain_date":"2025-08-26","description":"","created_by":5295,"created_at":"2025-08-12 17:38:50","updated_at":"2025-09-01 10:01:29","engineer_id":"","project_title":"\u65b0\u8d2d\u5b89\u5168\u8bbe\u5907","collected":"159.9","status_updated_at":"2025-08-27 09:38:28.637361+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-25 10:08:39.306048+08","forecast_updated_at":"2025-08-18 10:42:23.506394+08","end_at":"","pinyin_shortcut":"xgaqsb","creator":5295,"used_client":"","from_contact":"","total_contact_point":"4000","paid_contact_point":"","project_product_version_id":1006,"is_sales_order_ready":false,"collected_plan":"99786.0","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"usedClient":"","buildContract":{"id":4130,"from_project":3945,"serial_no":"TS-WZW-20250826006"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2121,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH2150B\uff09","product_type":7,"product_component":188,"product_brand":12,"product_serie":743,"product_misc":"","product_qa":"","pn":"","description":"\u6309\u5e74\u6536\u8d39\uff0c\u5305\u62ecWEB\u5e94\u7528\u9632\u62a4\u8bc6\u522b\u5e93\u3001IPS\u7279\u5f81\u5e93\u3001\u50f5\u5c38\u7f51\u7edc\u9632\u62a4\u5e93\u3001\u5b9e\u65f6\u6f0f\u6d1e\u5206\u6790\u8bc6\u522b\u5e93\u548cURL&\u5e94\u7528\u8bc6\u522b\u5e93\u5b9a\u671f\u66f4\u65b0\uff0c\u4fdd\u6301\u8bbe\u5907\u5177\u5907\u68c0\u6d4b\u9632\u5fa1\u6700\u65b0\u5a01\u80c1\u7684\u80fd\u529b\u3002","created_by":1013,"created_at":"2025-08-29 09:55:04","updated_at":"2025-08-29 09:55:04","pinyin_shortcut":"sxfaqynyzdyrjV80syyAF1000FH2150B","product_unit":2,"is_renew":false,"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":2,"key":2,"name":"\u5957"}}},{"amount":"5900.00","cost":"3923.74","id":10700,"project_id":3945,"product_id":2123,"number":1,"description":"","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"5900","total_cost":"3923.74","erp_sales_order_product_id":1865,"bargain_date":"2025-08-26","total_profit":"1976.26","total_profit_pct":"33.50","project":{"id":3945,"client_id":1301,"project_status":3,"project_progress":9,"budget":"99786","profit_pct":"35.11","bargain_date":"2025-08-26","description":"","created_by":5295,"created_at":"2025-08-12 17:38:50","updated_at":"2025-09-01 10:01:29","engineer_id":"","project_title":"\u65b0\u8d2d\u5b89\u5168\u8bbe\u5907","collected":"159.9","status_updated_at":"2025-08-27 09:38:28.637361+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-25 10:08:39.306048+08","forecast_updated_at":"2025-08-18 10:42:23.506394+08","end_at":"","pinyin_shortcut":"xgaqsb","creator":5295,"used_client":"","from_contact":"","total_contact_point":"4000","paid_contact_point":"","project_product_version_id":1006,"is_sales_order_ready":false,"collected_plan":"99786.0","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"usedClient":"","buildContract":{"id":4130,"from_project":3945,"serial_no":"TS-WZW-20250826006"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2123,"name":"\u6df1\u4fe1\u670d\u4e91\u5a01\u80c1\u60c5\u62a5\u7f51\u5173\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH2150B\uff09","product_type":7,"product_component":188,"product_brand":12,"product_serie":1640,"product_misc":"","product_qa":"","pn":"","description":"\u6309\u5e74\u6536\u8d39\uff0c\u60a8\u5c06\u83b7\u5f97\u4ee5\u4e0b\u80fd\u529b\uff1a\n\u3010\u4e91\u7aef\u767e\u4ebf\u7ea7\u5a01\u80c1\u60c5\u62a5\u89c4\u5219\u5e93\uff0c\u5931\u9677\u5916\u8054\u5b9e\u65f6\u68c0\u6d4b\u4e0e\u62e6\u622a\u3011\u901a\u8fc7\u672c\u5730&\u4e91\u7aef\u767e\u4ebf\u7ea7\u5a01\u80c1\u60c5\u62a5\u548c\u5168\u56fd30+\u8fd0\u8425\u5546POP\u8282\u70b9 \uff0c\u5b9e\u65f6\u963b\u65ad\u4e3b\u673a\/PC\u5931\u9677\u5916\u8054\u3001\u6316\u77ff\u3001URL\u9493\u9c7c\u7b49\u98ce\u9669\uff1b\n\u3010\u65b0\u5a01\u80c1\/\u672a\u77e5\u5a01\u80c15min\u5185\u540c\u6b65\u3011\u83b7\u53d6\u4e91\u7aefAI\u667a\u80fd\u5f15\u64ce\u68c0\u6d4b\u80fd\u529b\uff0c\u672c\u5730\u9632\u706b\u5899\u89c4\u5219\u5e93\u6bcf5\u5206\u949f\u66f4\u65b0\u4e00\u6b21\uff0c\u540c\u6b65\u6700\u65b0\u7684\u672a\u77e5\u5a01\u80c1\u60c5\u62a5\u81f3\u5ba2\u6237\u672c\u5730\uff0c\u5b9e\u65f6\u83b7\u53d6\u672a\u77e5\u5a01\u80c1\u7684\u9632\u5fa1\u80fd\u529b\uff08\u5982\u6f0f\u6d1e\\\u6076\u610fIP\\\u9493\u9c7cURL\u7b49\uff09\u907f\u514d\u6210\u4e3a\u65b0\u578b\u5a01\u80c1\u7684\u9996\u6279\u53d7\u5bb3\u8005\uff1b\n\u3010\u6740\u6bd2\u529f\u80fd\u4e0e\u66f4\u65b0\u3011\u63d0\u4f9b\u672c\u5730\u8bbe\u5907\u7f51\u7edc\u6740\u6bd2\u529f\u80fd\u4e0e\u66f4\u65b0\u670d\u52a1\uff0c\u672a\u77e5\u6587\u4ef6MD5\u503c\u5b9e\u65f6\u4e91\u67e5\u529f\u80fd\u3002","created_by":1013,"created_at":"2025-08-29 09:58:18","updated_at":"2025-08-29 09:58:18","pinyin_shortcut":"sxfywxqbwgrjV80syyAF1000FH2150B","product_unit":2,"is_renew":false,"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":1640,"key":1640,"name":"\u6df1\u4fe1\u670d\u4e91\u5a01\u80c1\u60c5\u62a5\u7f51\u5173\u8f6f\u4ef6V8.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"amount":"5730.00","cost":"3643.77","id":10705,"project_id":3945,"product_id":2106,"number":1,"description":"","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"5730","total_cost":"3643.77","erp_sales_order_product_id":1870,"bargain_date":"2025-08-26","total_profit":"2086.23","total_profit_pct":"36.41","project":{"id":3945,"client_id":1301,"project_status":3,"project_progress":9,"budget":"99786","profit_pct":"35.11","bargain_date":"2025-08-26","description":"","created_by":5295,"created_at":"2025-08-12 17:38:50","updated_at":"2025-09-01 10:01:29","engineer_id":"","project_title":"\u65b0\u8d2d\u5b89\u5168\u8bbe\u5907","collected":"159.9","status_updated_at":"2025-08-27 09:38:28.637361+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-25 10:08:39.306048+08","forecast_updated_at":"2025-08-18 10:42:23.506394+08","end_at":"","pinyin_shortcut":"xgaqsb","creator":5295,"used_client":"","from_contact":"","total_contact_point":"4000","paid_contact_point":"","project_product_version_id":1006,"is_sales_order_ready":false,"collected_plan":"99786.0","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"usedClient":"","buildContract":{"id":4130,"from_project":3945,"serial_no":"TS-WZW-20250826006"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2106,"name":"\u6df1\u4fe1\u670dURL\u7cfb\u7edf\u8f6f\u4ef6V5.0\uff08\u9002\u7528\u4e8eAC-1000-B1500\uff09","product_type":4,"product_component":23,"product_brand":12,"product_serie":172,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-19 11:35:15","updated_at":"2025-08-21 17:31:40","pinyin_shortcut":"sxfURLxtrjV50syyAC1000B1500","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":23,"key":23,"name":"\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":172,"key":172,"name":"\u6df1\u4fe1\u670dAC-1000\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u5668"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"amount":"49620.00","cost":"30911.65","id":10706,"project_id":3945,"product_id":2105,"number":1,"description":"","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"49620","total_cost":"30911.65","erp_sales_order_product_id":1871,"bargain_date":"2025-08-26","total_profit":"18708.35","total_profit_pct":"37.70","project":{"id":3945,"client_id":1301,"project_status":3,"project_progress":9,"budget":"99786","profit_pct":"35.11","bargain_date":"2025-08-26","description":"","created_by":5295,"created_at":"2025-08-12 17:38:50","updated_at":"2025-09-01 10:01:29","engineer_id":"","project_title":"\u65b0\u8d2d\u5b89\u5168\u8bbe\u5907","collected":"159.9","status_updated_at":"2025-08-27 09:38:28.637361+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-25 10:08:39.306048+08","forecast_updated_at":"2025-08-18 10:42:23.506394+08","end_at":"","pinyin_shortcut":"xgaqsb","creator":5295,"used_client":"","from_contact":"","total_contact_point":"4000","paid_contact_point":"","project_product_version_id":1006,"is_sales_order_ready":false,"collected_plan":"99786.0","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"usedClient":"","buildContract":{"id":4130,"from_project":3945,"serial_no":"TS-WZW-20250826006"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2105,"name":"\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6V13.0\uff08\u9002\u7528\u4e8eAC-1000-B1500\uff09","product_type":4,"product_component":23,"product_brand":12,"product_serie":172,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-19 11:34:25","updated_at":"2025-09-15 16:26:30","pinyin_shortcut":"sxfqwxwglxtrjV130syyAC1000B1500","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":23,"key":23,"name":"\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":172,"key":172,"name":"\u6df1\u4fe1\u670dAC-1000\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u5668"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"amount":"6025.00","cost":"5014.00","id":10707,"project_id":3945,"product_id":2099,"number":1,"description":"","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"6025","total_cost":"5014","erp_sales_order_product_id":1872,"bargain_date":"2025-08-26","total_profit":"1011","total_profit_pct":"16.78","project":{"id":3945,"client_id":1301,"project_status":3,"project_progress":9,"budget":"99786","profit_pct":"35.11","bargain_date":"2025-08-26","description":"","created_by":5295,"created_at":"2025-08-12 17:38:50","updated_at":"2025-09-01 10:01:29","engineer_id":"","project_title":"\u65b0\u8d2d\u5b89\u5168\u8bbe\u5907","collected":"159.9","status_updated_at":"2025-08-27 09:38:28.637361+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-25 10:08:39.306048+08","forecast_updated_at":"2025-08-18 10:42:23.506394+08","end_at":"","pinyin_shortcut":"xgaqsb","creator":5295,"used_client":"","from_contact":"","total_contact_point":"4000","paid_contact_point":"","project_product_version_id":1006,"is_sales_order_ready":false,"collected_plan":"99786.0","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"usedClient":"","buildContract":{"id":4130,"from_project":3945,"serial_no":"TS-WZW-20250826006"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2099,"name":"AC-1000-B1500","product_type":4,"product_component":23,"product_brand":12,"product_serie":172,"product_misc":"","product_qa":"","pn":"","description":"\u6027\u80fd\u53c2\u6570\uff1a\u7f51\u7edc\u5c42\u541e\u5410\u91cf\uff08\u5927\u5305\uff09\uff1a5.8Gb\uff0c\u5e94\u7528\u5c42\u541e\u5410\u91cf\uff1a750Mb\uff0c\u5e26\u5bbd\u6027\u80fd\uff1a500Mb\uff0cIPSEC VPN\u52a0\u5bc6\u6027\u80fd\uff08\u6700\u9ad8\u6027\u80fd\uff09\uff1a120Mb\uff0c\u652f\u6301\u7528\u6237\u6570\uff1a4000\uff0c\u51c6\u5165\u7ec8\u7aef\u6570\uff08\u652f\u6301\u5ba2\u6237\u7aef\u6388\u6743-\u9700\u5355\u72ec\u6536\u8d39\uff09\uff1a2000\uff0c\u51c6\u5165\u7ec8\u7aef\u6570\u7684\u6269\u5bb9\u4e0a\u9650\uff08\u652f\u6301\u5ba2\u6237\u7aef\u6388\u6743-\u9700\u5355\u72ec\u6536\u8d39\uff09\uff1a4000\uff0c\u9632\u6cc4\u5bc6\u7ec8\u7aef\u6570\u4e0a\u9650(\u9700\u5355\u72ec\u6536\u8d39)\uff1a8000\uff0c\u5305\u8f6c\u53d1\u7387\uff1a90Kpps\uff0c\u6bcf\u79d2\u65b0\u5efa\u8fde\u63a5\u6570\uff1a10000\uff0c\u6700\u5927\u5e76\u53d1\u8fde\u63a5\u6570\uff1a500000\u3002\n\u786c\u4ef6\u53c2\u6570\uff1a\u89c4\u683c\uff1a1U\uff0c\u5185\u5b58\u5927\u5c0f\uff1a8G\uff0c\u786c\u76d8\u5bb9\u91cf\uff1a128G SSD+960G SSD\uff0c\u7535\u6e90\uff1a\u5355\u7535\u6e90\uff0c\u63a5\u53e3\uff1a6\u5343\u5146\u7535\u53e3+2\u4e07\u5146\u5149\u53e3SFP+\u3002\n\u529f\u80fd\u63cf\u8ff0\uff1a\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u805a\u7126\u4f01\u4e8b\u4e1a\u7ec4\u7ec7\u7f51\u7edc\u884c\u4e3a\u5b89\u5168\uff0c\u5b9e\u73b0\u5168\u7f51\u8d44\u4ea7\u3001\u8eab\u4efd\u3001\u884c\u4e3a\u53ef\u89c6\u53ef\u63a7\uff0c\u667a\u80fd\u611f\u77e5\u5185\u90e8\u5a01\u80c1\u98ce\u9669\uff0c\u5e2e\u52a9\u7528\u6237\u6784\u5efa\u6709\u6548\u9632\u5fa1\u4f53\u7cfb\u3002","created_by":1013,"created_at":"2025-08-14 09:11:10","updated_at":"2025-08-21 17:31:40","pinyin_shortcut":"AC1000B1500","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":23,"key":23,"name":"\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":172,"key":172,"name":"\u6df1\u4fe1\u670dAC-1000\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"amount":"3136.00","cost":"2415.00","id":10703,"project_id":3945,"product_id":2119,"number":1,"description":"","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"3136","total_cost":"2415","erp_sales_order_product_id":1868,"bargain_date":"2025-08-26","total_profit":"721","total_profit_pct":"22.99","project":{"id":3945,"client_id":1301,"project_status":3,"project_progress":9,"budget":"99786","profit_pct":"35.11","bargain_date":"2025-08-26","description":"","created_by":5295,"created_at":"2025-08-12 17:38:50","updated_at":"2025-09-01 10:01:29","engineer_id":"","project_title":"\u65b0\u8d2d\u5b89\u5168\u8bbe\u5907","collected":"159.9","status_updated_at":"2025-08-27 09:38:28.637361+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-25 10:08:39.306048+08","forecast_updated_at":"2025-08-18 10:42:23.506394+08","end_at":"","pinyin_shortcut":"xgaqsb","creator":5295,"used_client":"","from_contact":"","total_contact_point":"4000","paid_contact_point":"","project_product_version_id":1006,"is_sales_order_ready":false,"collected_plan":"99786.0","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"usedClient":"","buildContract":{"id":4130,"from_project":3945,"serial_no":"TS-WZW-20250826006"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2119,"name":"AF-1000-FH2150B","product_type":5,"product_component":26,"product_brand":12,"product_serie":1033,"product_misc":"","product_qa":"","pn":"","description":"\u6027\u80fd\u53c2\u6570\uff1a\u7f51\u7edc\u5c42\u541e\u5410\u91cf\uff1a20G\uff0c\u5e94\u7528\u5c42\u541e\u5410\u91cf\uff1a10G\uff0c\u9632\u75c5\u6bd2\u541e\u5410\u91cf\uff1a1.5G\uff0cIPS\u541e\u5410\u91cf\uff1a1.5G\uff0c\u5168\u5a01\u80c1\u541e\u5410\u91cf\uff08\u4e0d\u542bWAF\uff09\uff1a1G\uff0c\u5e76\u53d1\u8fde\u63a5\u6570\uff1a300\u4e07\uff0cHTTP\u65b0\u5efa\u8fde\u63a5\u6570\uff1a9\u4e07\uff0cSSL VPN\u63a8\u8350\u7528\u6237\u6570\uff08\u5355\u72ec\u8d2d\u4e70\uff09\uff1a30\uff0cSSL VPN\u6700\u5927\u7528\u6237\u6570\uff08\u5355\u72ec\u8d2d\u4e70\uff09\uff1a80\uff0cSSL VPN\u6700\u5927\u7406\u8bba\u52a0\u5bc6\u6d41\u91cf\uff08\u5355\u72ec\u8d2d\u4e70\uff09\uff1a250M\uff0cIPSec VPN \u6700\u5927\u63a5\u5165\u6570\uff1a1000\uff0cIPSec VPN\u541e\u5410\u91cf\uff1a700M\u3002\n\u786c\u4ef6\u53c2\u6570\uff1a\u89c4\u683c\uff1a1U\uff0c\u5185\u5b58\u5927\u5c0f\uff1a8G\uff0c\u786c\u76d8\u5bb9\u91cf\uff1a128G SSD\uff0c\u7535\u6e90\uff1a\u5355\u7535\u6e90\uff0c\u63a5\u53e3\uff1a8\u5343\u5146\u7535\u53e3+2\u4e07\u5146\u5149\u53e3SFP+\u3002\n\u529f\u80fd\u63cf\u8ff0\uff1a\u6df1\u4fe1\u670d\u4e0b\u4e00\u4ee3\u9632\u706b\u5899\u4ee5\u4fdd\u969c\u7528\u6237\u6838\u5fc3\u8d44\u4ea7\u4e3a\u76ee\u6807\uff0c\u63d0\u4f9bL2-L7\u5c42\u5404\u7c7b\u5a01\u80c1\u7684\u68c0\u6d4b\u548c\u9632\u62a4\uff0c\u662f\u4e00\u6b3e\u80fd\u591f\u6709\u6548\u5e94\u5bf9\u4f20\u7edf\u7f51\u7edc\u653b\u51fb\u548c\u672a\u77e5\u5a01\u80c1\u653b\u51fb\u7684\u7f51\u7edc\u5b89\u5168\u4ea7\u54c1\u3002","created_by":1013,"created_at":"2025-08-29 09:49:49","updated_at":"2025-08-29 09:49:49","pinyin_shortcut":"AF1000FH2150B","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1033,"key":1033,"name":"\u6df1\u4fe1\u670d AF-1000\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"amount":"0","cost":"0","id":10704,"project_id":3945,"product_id":2118,"number":1,"description":"","supplier_id":236,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"0","total_cost":"0","erp_sales_order_product_id":1869,"bargain_date":"2025-08-26","total_profit":"0","total_profit_pct":"0.00","project":{"id":3945,"client_id":1301,"project_status":3,"project_progress":9,"budget":"99786","profit_pct":"35.11","bargain_date":"2025-08-26","description":"","created_by":5295,"created_at":"2025-08-12 17:38:50","updated_at":"2025-09-01 10:01:29","engineer_id":"","project_title":"\u65b0\u8d2d\u5b89\u5168\u8bbe\u5907","collected":"159.9","status_updated_at":"2025-08-27 09:38:28.637361+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-25 10:08:39.306048+08","forecast_updated_at":"2025-08-18 10:42:23.506394+08","end_at":"","pinyin_shortcut":"xgaqsb","creator":5295,"used_client":"","from_contact":"","total_contact_point":"4000","paid_contact_point":"","project_product_version_id":1006,"is_sales_order_ready":false,"collected_plan":"99786.0","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"usedClient":"","buildContract":{"id":4130,"from_project":3945,"serial_no":"TS-WZW-20250826006"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2118,"name":"\u5b9a\u5236\u5197\u4f59\u4ea4\u6d41\u7535\u6e90150W","product_type":4,"product_component":43,"product_brand":12,"product_serie":1698,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-29 09:46:49","updated_at":"2025-08-29 09:46:49","pinyin_shortcut":"dzryjldy150W","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1698,"key":1698,"name":"\u5b9a\u5236\u5197\u4f59\u4ea4\u6d41\u7535\u6e90"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"amount":"680","cost":"390.00","id":10688,"project_id":3956,"product_id":2116,"number":2,"description":"","supplier_id":626,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"1360.00","total_cost":"780","erp_sales_order_product_id":1863,"bargain_date":"2025-08-26","total_profit":"580.00","total_profit_pct":"42.65","project":{"id":3956,"client_id":2182,"project_status":3,"project_progress":4,"budget":"1360","profit_pct":"35.1","bargain_date":"2025-08-26","description":"","created_by":5300,"created_at":"2025-08-26 13:53:37","updated_at":"2025-08-29 10:39:09","engineer_id":"","project_title":"\u534e\u4e09\u9762\u677fAP\u65b0\u8d2d-2025","collected":"1360","status_updated_at":"2025-08-27 13:35:36.075805+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-26 13:53:37.769647+08","forecast_updated_at":"2025-08-27 13:32:57.462933+08","end_at":"2025-09-03 15:35:31","pinyin_shortcut":"hsmbAPxg2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1005,"is_sales_order_ready":true,"collected_plan":"1360","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4129,"from_project":3956,"serial_no":"TS-SQY-2025082701"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"},"product":{"id":2116,"name":"EWP-WA6522H-LI-FIT","product_type":4,"product_component":21,"product_brand":20,"product_serie":531,"product_misc":"","product_qa":"","pn":"","description":"\u5343\u5146\u53cc\u9891 WIFI6\u9762\u677f \u65e0\u7ebfAP","created_by":1013,"created_at":"2025-08-26 13:51:29","updated_at":"2025-08-27 15:51:12","pinyin_shortcut":"EWPWA6522HLIFIT","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":21,"key":21,"name":"\u65e0\u7ebfAP"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":531,"key":531,"name":"WA6522H-HI Wi-Fi 6\u65e0\u7ebf\u63a5\u5165\u8bbe\u5907"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"amount":"0","cost":"0","id":10729,"project_id":3927,"product_id":2095,"number":1,"description":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"0","total_cost":"0","erp_sales_order_product_id":1875,"bargain_date":"2025-08-22","total_profit":"0","total_profit_pct":"0.00","project":{"id":3927,"client_id":3286,"project_status":3,"project_progress":6,"budget":"40932","profit_pct":"11.14","bargain_date":"2025-08-22","description":"","created_by":1001,"created_at":"2025-07-22 11:05:23","updated_at":"2025-09-16 14:25:49","engineer_id":"","project_title":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","collected":"1","status_updated_at":"2025-08-22 10:58:30.751668+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-22 11:05:23.224714+08","forecast_updated_at":"2025-07-22 11:05:23.224714+08","end_at":"","pinyin_shortcut":"PAVMfhqwbxy","creator":1011,"used_client":"","from_contact":5957,"total_contact_point":"","paid_contact_point":"","project_product_version_id":1010,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4112,"from_project":3927,"serial_no":"PO2500925\/PO2500926"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2095,"name":"SA3610","product_type":3,"product_component":14,"product_brand":27,"product_serie":1691,"product_misc":"","product_qa":"","pn":"","description":"2U\u673a\u67b6\u5f0f12 \u69fd\u673a\u67b6\u5f0f\u670d\u52a1\u5668\uff0cCPU\uff1aIntel\u00ae Xeon\u00ae D-1567\uff1b\u5185\u5b58\uff1a16 GB DDR4 ECC RDIMM\uff08\u53ef\u6269\u5145\u81f3 128 GB\uff09\uff1b12 x 3.5 \u82f1\u5bf8 Synology SAS\/SATA HDD\u30012.5 \u82f1\u5bf8 Synology SATA SSD \u6216 2.5 \u82f1\u5bf8 SAS SSD\uff08\u4e0d\u542b\u786c\u76d8\uff09\uff1b\u652f\u6301\u70ed\u63d2\u62d4\u786c\u76d8\uff1b2 x USB 3.2 \u7b2c 1 \u4ee3\u7aef\u53e3\u548c1 x \u6269\u5145\u7aef\u53e3 (Mini-SAS HD)\uff1b5\u5e74\u4fdd\u4fee\u3002","created_by":1013,"created_at":"2025-08-14 09:06:15","updated_at":"2025-09-15 16:23:59","pinyin_shortcut":"SA3610","product_unit":1,"is_renew":false,"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":1691,"key":1691,"name":"SA3610 NAS\u5b58\u50a8\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"amount":"1516","cost":"1393.00","id":10728,"project_id":3927,"product_id":1624,"number":13,"description":"\u7eed\u7ea6","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"19708","total_cost":"18109","erp_sales_order_product_id":1861,"bargain_date":"2025-08-22","total_profit":"1599","total_profit_pct":"8.11","project":{"id":3927,"client_id":3286,"project_status":3,"project_progress":6,"budget":"40932","profit_pct":"11.14","bargain_date":"2025-08-22","description":"","created_by":1001,"created_at":"2025-07-22 11:05:23","updated_at":"2025-09-16 14:25:49","engineer_id":"","project_title":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","collected":"1","status_updated_at":"2025-08-22 10:58:30.751668+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-22 11:05:23.224714+08","forecast_updated_at":"2025-07-22 11:05:23.224714+08","end_at":"","pinyin_shortcut":"PAVMfhqwbxy","creator":1011,"used_client":"","from_contact":5957,"total_contact_point":"","paid_contact_point":"","project_product_version_id":1010,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4112,"from_project":3927,"serial_no":"PO2500925\/PO2500926"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2025-09-04 11:42:10","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"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":1382,"key":1382,"name":"PA\u865a\u62df\u9632\u706b\u5899\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"amount":"1516","cost":"1393.00","id":10727,"project_id":3927,"product_id":1624,"number":14,"description":"\u65b0\u8d2d","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"21224.00","total_cost":"19502","erp_sales_order_product_id":1860,"bargain_date":"2025-08-22","total_profit":"1722.00","total_profit_pct":"8.11","project":{"id":3927,"client_id":3286,"project_status":3,"project_progress":6,"budget":"40932","profit_pct":"11.14","bargain_date":"2025-08-22","description":"","created_by":1001,"created_at":"2025-07-22 11:05:23","updated_at":"2025-09-16 14:25:49","engineer_id":"","project_title":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","collected":"1","status_updated_at":"2025-08-22 10:58:30.751668+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-22 11:05:23.224714+08","forecast_updated_at":"2025-07-22 11:05:23.224714+08","end_at":"","pinyin_shortcut":"PAVMfhqwbxy","creator":1011,"used_client":"","from_contact":5957,"total_contact_point":"","paid_contact_point":"","project_product_version_id":1010,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4112,"from_project":3927,"serial_no":"PO2500925\/PO2500926"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2025-09-04 11:42:10","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"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":1382,"key":1382,"name":"PA\u865a\u62df\u9632\u706b\u5899\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"amount":"706.00","cost":"500.00","id":10685,"project_id":3953,"product_id":1613,"number":7,"description":"","supplier_id":649,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"4942","total_cost":"3500","erp_sales_order_product_id":1862,"bargain_date":"2025-08-22","total_profit":"1442","total_profit_pct":"29.18","project":{"id":3953,"client_id":12,"project_status":3,"project_progress":4,"budget":"4942","profit_pct":"23.39","bargain_date":"2025-08-22","description":"","created_by":5300,"created_at":"2025-08-22 16:43:27","updated_at":"2025-08-27 11:06:15","engineer_id":"","project_title":"POCN25085613-8\u53e3POE\u4ea4\u6362\u673a","collected":"0","status_updated_at":"2025-08-22 16:43:27.537541+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-22 16:43:27.537541+08","forecast_updated_at":"2025-08-22 16:43:27.537541+08","end_at":"","pinyin_shortcut":"POCN250856138kPOEjhj","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1001,"is_sales_order_ready":true,"collected_plan":"4942","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4120,"from_project":3953,"serial_no":"SMC\u4e2d\u56fd\u8ba2\u5355POCN25085613"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":1613,"name":"H3C 1208V-HPWR","product_type":4,"product_component":19,"product_brand":20,"product_serie":1374,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-05-11 15:48:33","updated_at":"2025-08-25 16:46:33","pinyin_shortcut":"H3C1208VHPWR","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":19,"key":19,"name":"\u4ea4\u6362\u673a"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1374,"key":1374,"name":"H3C 1208V-HPWR \u4ea4\u6362\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"amount":"26666.66","cost":"1000","id":10725,"project_id":3950,"product_id":2095,"number":3,"description":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"80000.00","total_cost":"3000.00","erp_sales_order_product_id":1874,"bargain_date":"2025-08-21","total_profit":"77000.00","total_profit_pct":"96.25","project":{"id":3950,"client_id":3389,"project_status":3,"project_progress":6,"budget":"80000","profit_pct":"96.25","bargain_date":"2025-08-21","description":"","created_by":1001,"created_at":"2025-08-21 12:26:55","updated_at":"2025-09-12 10:08:49","engineer_id":"","project_title":"\u6d4b-\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355\uff1a\u6df1\u4fe1\u670d\u9632\u706b\u5899AF-1000-FH2300B","collected":"80000","status_updated_at":"2025-09-03 15:40:10.300517+08","success_rate":"","comment":"\u6d4b\u8bd5\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355","contract_type":1,"progress_updated_at":"2025-08-21 12:26:55.466653+08","forecast_updated_at":"2025-08-21 12:26:55.466653+08","end_at":"2025-09-04 09:21:06","pinyin_shortcut":"cxsyjftdsxffhqAF1000FH2300B","creator":1011,"used_client":"","from_contact":5912,"total_contact_point":"","paid_contact_point":"","project_product_version_id":1009,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":true,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"usedClient":"","buildContract":{"id":4131,"from_project":3950,"serial_no":"2025-09-03-001"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"},"product":{"id":2095,"name":"SA3610","product_type":3,"product_component":14,"product_brand":27,"product_serie":1691,"product_misc":"","product_qa":"","pn":"","description":"2U\u673a\u67b6\u5f0f12 \u69fd\u673a\u67b6\u5f0f\u670d\u52a1\u5668\uff0cCPU\uff1aIntel\u00ae Xeon\u00ae D-1567\uff1b\u5185\u5b58\uff1a16 GB DDR4 ECC RDIMM\uff08\u53ef\u6269\u5145\u81f3 128 GB\uff09\uff1b12 x 3.5 \u82f1\u5bf8 Synology SAS\/SATA HDD\u30012.5 \u82f1\u5bf8 Synology SATA SSD \u6216 2.5 \u82f1\u5bf8 SAS SSD\uff08\u4e0d\u542b\u786c\u76d8\uff09\uff1b\u652f\u6301\u70ed\u63d2\u62d4\u786c\u76d8\uff1b2 x USB 3.2 \u7b2c 1 \u4ee3\u7aef\u53e3\u548c1 x \u6269\u5145\u7aef\u53e3 (Mini-SAS HD)\uff1b5\u5e74\u4fdd\u4fee\u3002","created_by":1013,"created_at":"2025-08-14 09:06:15","updated_at":"2025-09-15 16:23:59","pinyin_shortcut":"SA3610","product_unit":1,"is_renew":false,"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":1691,"key":1691,"name":"SA3610 NAS\u5b58\u50a8\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"amount":"7300.00","cost":"6700.00","id":10689,"project_id":3947,"product_id":2100,"number":1,"description":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"7300","total_cost":"6700","erp_sales_order_product_id":1857,"bargain_date":"2025-08-21","total_profit":"600","total_profit_pct":"8.22","project":{"id":3947,"client_id":304,"project_status":3,"project_progress":9,"budget":"7300","profit_pct":"5.15","bargain_date":"2025-08-21","description":"","created_by":5295,"created_at":"2025-08-19 10:48:28","updated_at":"2025-09-03 17:13:07","engineer_id":"","project_title":"\u91c7\u8d2dAdobe\u8f6f\u4ef6","collected":"0","status_updated_at":"2025-08-21 11:40:59.153148+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-19 10:48:28.917403+08","forecast_updated_at":"2025-08-19 10:48:28.917403+08","end_at":"","pinyin_shortcut":"cgAdoberj","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1004,"is_sales_order_ready":false,"collected_plan":"7300","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4111,"from_project":3947,"serial_no":"2025-08-21-002"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2100,"name":"Adobe\u5168\u5bb6\u6876","product_type":7,"product_component":159,"product_brand":261,"product_serie":"","product_misc":"","product_qa":"","pn":"","description":"Creative Cloud for teams All Apps 12 months \u5168\u5bb6\u6876","created_by":1013,"created_at":"2025-08-15 14:51:48","updated_at":"2025-09-15 16:23:59","pinyin_shortcut":"Adobeqjt","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":159,"key":159,"name":"\u529e\u516c\u8f6f\u4ef6"},"productBrand":{"id":261,"key":261,"name":"Adobe"},"productSerie":"","productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"amount":"460","cost":"258.00","id":10680,"project_id":3951,"product_id":2112,"number":8,"description":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"3680","total_cost":"2064","erp_sales_order_product_id":1859,"bargain_date":"2025-08-21","total_profit":"1616","total_profit_pct":"43.91","project":{"id":3951,"client_id":2136,"project_status":3,"project_progress":5,"budget":"3680","profit_pct":"43.91","bargain_date":"2025-08-21","description":"","created_by":5087,"created_at":"2025-08-21 14:09:04","updated_at":"2025-08-31 22:38:03","engineer_id":"","project_title":"\u8bfb\u5361\u5668\u91c7\u8d2d","collected":"0","status_updated_at":"2025-08-21 14:24:26.262442+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-21 14:09:04.397257+08","forecast_updated_at":"2025-08-25 10:30:45.275316+08","end_at":"","pinyin_shortcut":"dkqcg","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":997,"is_sales_order_ready":true,"collected_plan":"3680","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"usedClient":"","buildContract":{"id":4109,"from_project":3951,"serial_no":"2025-08-21-001"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2112,"name":"\u975e\u63a5\u89e6\u8bfb\u5361\u5668","product_type":20,"product_component":184,"product_brand":134,"product_serie":1697,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-21 15:30:37","updated_at":"2025-08-25 13:23:02","pinyin_shortcut":"fjcdkq","product_unit":1,"is_renew":false,"productType":{"id":20,"key":20,"name":"\u529e\u516c\u8bbe\u5907"},"productComponent":{"id":184,"key":184,"name":"\u6742\u7269\u7c7b"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1697,"key":1697,"name":"\u8bfb\u5361\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}}],"countArr":{"budget":"125005440.09","cost":"87850069.47","profits":"37155370.62","profit_pct":"29.72"},"pagenation":{"totalcount":1872,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-16 15:09:27') RETURNING "id"
15:09:27.7301.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (743, 172, 1697, 742, 531, 1698, 1033, 1640, 1699, 1374, 1691, 1382, 633)
15:09:27.7380.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=60, "last_visit_at"='now()' WHERE "id"=56587
15:09:27.7250.7 msyii\db\Command::querySELECT "id", "from_project", "serial_no" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3950, 3854, 3953, 3956, 3945, 3927, 3951, 3947, 3796, 3959)
15:09:27.7210.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3959, 3796, 3854, 3945, 3956, 3927, 3953, 3950, 3947, 3951)
15:09:27.7250.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1040, 2124, 2122, 2121, 2123, 2106, 2105, 2099, 2119, 2118, 2116, 2095, 1624, 1613, 2100, 2112)
15:09:27.7240.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3389, 2128, 12, 2182, 1301, 3286, 2136, 304, 2125, 1661)
15:09:27.7290.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (188, 23, 184, 21, 43, 26, 157, 19, 159, 14, 36, 32)
15:09:27.7230.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_group_relationships" WHERE "sales_id" IN (1001, 5295, 5087, 5300)
15:09:27.7290.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (7, 4, 20, 5, 3)
15:09:27.7220.3 msyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
15:09:27.7320.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 1, 3)
15:09:27.7240.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_groups" WHERE "id" IN (1, 80)
15:09:27.7300.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (12, 134, 20, 261, 27, 8, 137)
15:09:27.7230.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5087, 5300, 5295)