ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6897acc362a79: GET https://beta.jinchangxiao.com/vue/analysis/sales-product-list-all at 2025-08-10 04:17:07 am by 114.119.138.59

Log Messages

总计55条数据
TimeLevelCategoryMessage
 
04:17:07.403traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
04:17:07.403traceyii\base\Module::getModuleLoading module: debug
04:17:07.404traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
04:17:07.404traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
04:17:07.404traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
04:17:07.404traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
04:17:07.404traceyii\base\Module::getModuleLoading module: gii
04:17:07.404traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
04:17:07.404traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
04:17:07.405traceyii\web\Application::handleRequestRoute requested: 'vue/analysis/sales-product-list-all'
04:17:07.405traceyii\base\Module::getModuleLoading module: vue
04:17:07.405infoyii\web\Session::openSession started
04:17:07.406infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
04:17:07.406infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
04:17:07.411traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
04:17:07.411traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
04:17:07.412traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
04:17:07.412traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
04:17:07.412infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
04:17:07.414traceyii\base\Controller::runActionRoute to run: vue/analysis/sales-product-list-all
04:17:07.414traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
04:17:07.415traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
04:17:07.415traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\AnalysisController::actionSalesProductListAll()
04:17:07.417traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
04:17:07.418traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
04:17:07.419infoyii\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 (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) "sub"
04:17:07.431infoyii\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 (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093) ORDER BY "project"."bargain_date" DESC, "project"."updated_at" DESC) "c"
04:17:07.435infoyii\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 (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093) ORDER BY "project"."bargain_date" DESC, "project"."updated_at" DESC LIMIT 20
04:17:07.440traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
04:17:07.440infoyii\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;
04:17:07.445infoyii\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
04:17:07.458traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
04:17:07.458traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
04:17:07.458infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3927, 3930, 3928, 3929, 3751, 3924, 3925, 3926, 3922)
04:17:07.462infoyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
04:17:07.462infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5087, 5300, 5295)
04:17:07.463infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_group_relationships" WHERE "sales_id" IN (5295, 5087, 5300, 1001)
04:17:07.463infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_groups" WHERE "id" IN (1, 80)
04:17:07.464infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2553, 2136, 12, 3383, 3286)
04:17:07.464infoyii\db\Command::querySELECT "id", "from_project", "serial_no" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3751, 3922, 3924, 3925, 3926, 3927, 3928, 3929, 3930)
04:17:07.465infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (2067, 1691, 2056, 2058, 2055, 2057, 2059, 1690, 1372, 1647, 2069, 2066, 2068, 978, 942)
04:17:07.472infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (4, 11, 19, 5, 7)
04:17:07.473infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (43, 179, 151, 26, 157, 214, 36, 23, 51, 41)
04:17:07.475infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (20, 10, 43, 134, 8, 12)
04:17:07.477infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1401, 1438, 1439, 593, 1663, 1012, 615, 1665, 1664, 172, 231, 1277, 1047)
04:17:07.484infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (3, 6, 7, 1, 2)
04:17:07.486traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
04:17:07.486traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
04:17:07.487infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-08-10')
04:17:07.490traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
04:17:07.490traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
04:17:07.490infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=14, "last_visit_at"='now()' WHERE "id"=55005
04:17:07.492infoyii\db\Command::queryINSERT 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-product-list-all', '[]', '{"code":2000,"result":{"list":[{"amount":"60000.00","cost":"400.00","id":10582,"project_id":3927,"product_id":2067,"number":1,"description":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"60000","total_cost":"400","erp_sales_order_product_id":"","bargain_date":"2025-08-05","total_profit":"59600","total_profit_pct":"99.33","project":{"id":3927,"client_id":3286,"project_status":3,"project_progress":6,"budget":"60000","profit_pct":"99.33","bargain_date":"2025-08-05","description":"","created_by":1001,"created_at":"2025-07-22 11:05:23","updated_at":"2025-08-08 13:55:45","engineer_id":"","project_title":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","collected":"1","status_updated_at":"2025-08-05 17:19:18.559826+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-22 11:05:23.224714+08","forecast_updated_at":"2025-08-08 13:55:45.64593+08","end_at":"","pinyin_shortcut":"PAVMfhqwbxy","creator":1011,"used_client":"","from_contact":5957,"total_contact_point":"","paid_contact_point":"","project_product_version_id":966,"is_sales_order_ready":false,"collected_plan":"345","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":4075,"from_project":3927,"serial_no":""},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2067,"name":"\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6V13.0(\u9002\u7528\u4e8eAC-1000-B1100-4D)","product_type":4,"product_component":51,"product_brand":12,"product_serie":231,"product_misc":"","product_qa":"","pn":"","description":"\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6V13.0","created_by":1013,"created_at":"2025-07-28 14:45:38","updated_at":"2025-07-28 14:50:11","pinyin_shortcut":"sxfqwxwglxtrjV130syyAC1000B11004D","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":231,"key":231,"name":"\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"amount":"299.00","cost":"130.00","id":10517,"project_id":3930,"product_id":1691,"number":1,"description":"","supplier_id":608,"hardware_from":"2025-07-25","software_from":"","maintenance_from":"","hardware_to":"2026-07-25","software_to":"","maintenance_to":"","total_amount":"299","total_cost":"130","erp_sales_order_product_id":"","bargain_date":"2025-07-25","total_profit":"169","total_profit_pct":"56.52","project":{"id":3930,"client_id":12,"project_status":3,"project_progress":9,"budget":"299","profit_pct":"47.17","bargain_date":"2025-07-25","description":"","created_by":5300,"created_at":"2025-07-25 15:44:47","updated_at":"2025-07-28 17:55:50","engineer_id":"","project_title":"POTJ25078337-\u56fa\u6001\u786c\u76d8-2025","collected":"0","status_updated_at":"2025-07-25 15:44:47.422414+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-25 15:44:47.422414+08","forecast_updated_at":"2025-07-25 15:44:47.422414+08","end_at":"","pinyin_shortcut":"POTJ25078337gtyp2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":964,"is_sales_order_ready":true,"collected_plan":"299","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":4068,"from_project":3930,"serial_no":"SMC\u5929\u6d25POTJ25078337"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":1691,"name":"BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8","product_type":11,"product_component":179,"product_brand":43,"product_serie":1439,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:51:53","updated_at":"2024-07-25 17:51:53","pinyin_shortcut":"BG5256G2230PCIE40NVMEgtyp","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":43,"key":43,"name":"\u4e1c\u829d"},"productSerie":{"id":1439,"key":1439,"name":"\u4e1c\u829d BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"amount":"299.00","cost":"130.00","id":10506,"project_id":3928,"product_id":1691,"number":2,"description":"","supplier_id":608,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"598","total_cost":"260","erp_sales_order_product_id":"","bargain_date":"2025-07-24","total_profit":"338","total_profit_pct":"56.52","project":{"id":3928,"client_id":12,"project_status":3,"project_progress":9,"budget":"598","profit_pct":"47.17","bargain_date":"2025-07-24","description":"","created_by":5300,"created_at":"2025-07-24 13:27:15","updated_at":"2025-07-28 10:03:28","engineer_id":"","project_title":"OTJ25077428-\u56fa\u6001\u786c\u76d8-G-2025","collected":"0","status_updated_at":"2025-07-24 13:27:15.878417+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-24 13:27:15.878417+08","forecast_updated_at":"2025-07-24 13:27:15.878417+08","end_at":"","pinyin_shortcut":"OTJ25077428gtypG2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":962,"is_sales_order_ready":true,"collected_plan":"598","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":4064,"from_project":3928,"serial_no":"SMC\u5929\u6d25POTJ25077428"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":1691,"name":"BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8","product_type":11,"product_component":179,"product_brand":43,"product_serie":1439,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:51:53","updated_at":"2024-07-25 17:51:53","pinyin_shortcut":"BG5256G2230PCIE40NVMEgtyp","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":43,"key":43,"name":"\u4e1c\u829d"},"productSerie":{"id":1439,"key":1439,"name":"\u4e1c\u829d BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"amount":"299.00","cost":"130.00","id":10505,"project_id":3929,"product_id":1691,"number":2,"description":"","supplier_id":608,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"598","total_cost":"260","erp_sales_order_product_id":"","bargain_date":"2025-07-24","total_profit":"338","total_profit_pct":"56.52","project":{"id":3929,"client_id":12,"project_status":3,"project_progress":9,"budget":"598","profit_pct":"47.17","bargain_date":"2025-07-24","description":"","created_by":5300,"created_at":"2025-07-24 13:29:19","updated_at":"2025-07-28 10:03:03","engineer_id":"","project_title":"OTJ25077468-\u56fa\u6001\u786c\u76d8-G-2025","collected":"0","status_updated_at":"2025-07-24 13:31:12.133905+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-24 13:29:19.317641+08","forecast_updated_at":"2025-07-24 13:29:19.317641+08","end_at":"","pinyin_shortcut":"OTJ25077468gtypG2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":961,"is_sales_order_ready":true,"collected_plan":"598","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":4065,"from_project":3929,"serial_no":"SMC\u5929\u6d25POTJ25077468"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":1691,"name":"BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8","product_type":11,"product_component":179,"product_brand":43,"product_serie":1439,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:51:53","updated_at":"2024-07-25 17:51:53","pinyin_shortcut":"BG5256G2230PCIE40NVMEgtyp","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":43,"key":43,"name":"\u4e1c\u829d"},"productSerie":{"id":1439,"key":1439,"name":"\u4e1c\u829d BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"amount":"5365.33","cost":"800.00","id":10493,"project_id":3751,"product_id":2056,"number":6,"description":"","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"32192.00","total_cost":"4800","erp_sales_order_product_id":"","bargain_date":"2025-07-21","total_profit":"27392.00","total_profit_pct":"85.09","project":{"id":3751,"client_id":2553,"project_status":3,"project_progress":9,"budget":"885300","profit_pct":"2.74","bargain_date":"2025-07-21","description":"","created_by":1001,"created_at":"2024-12-24 15:50:46","updated_at":"2025-08-07 12:11:41","engineer_id":"","project_title":"10\u53f0 PA445 \u8bbe\u5907\u91c7\u8d2d\u9879\u76ee\uff08\u6c99\u7279\u9879\u76ee\uff09","collected":"0","status_updated_at":"2025-07-25 11:40:23.236058+08","success_rate":"","comment":"\u62db\u6807\u7f16\u53f7\uff1aPOWRCHINA-0120009-250118","contract_type":1,"progress_updated_at":"2025-07-25 11:40:23.236058+08","forecast_updated_at":"2024-12-24 15:50:46.744407+08","end_at":"","pinyin_shortcut":"10tPA445sbcgxmstxm","creator":1001,"used_client":"","from_contact":5957,"total_contact_point":"342291","paid_contact_point":"","project_product_version_id":951,"is_sales_order_ready":false,"collected_plan":"885300","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":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4055,"from_project":3751,"serial_no":""},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2056,"name":"PAN-PA-400-POE-PWR-150W","product_type":5,"product_component":157,"product_brand":8,"product_serie":1012,"product_misc":"","product_qa":"","pn":"","description":"150W Power Adaptor for PoE Enabled PA-415, PA-445, and PA-415-5G","created_by":1013,"created_at":"2025-07-21 14:50:36","updated_at":"2025-07-21 14:50:36","pinyin_shortcut":"PANPA400POEPWR150W","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":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1012,"key":1012,"name":"PA-440\/450\/460\u7535\u6e90"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"amount":"15644.80","cost":"16764.60","id":10492,"project_id":3751,"product_id":2058,"number":10,"description":"","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"156448","total_cost":"167646","erp_sales_order_product_id":"","bargain_date":"2025-07-21","total_profit":"-11198","total_profit_pct":"-7.16","project":{"id":3751,"client_id":2553,"project_status":3,"project_progress":9,"budget":"885300","profit_pct":"2.74","bargain_date":"2025-07-21","description":"","created_by":1001,"created_at":"2024-12-24 15:50:46","updated_at":"2025-08-07 12:11:41","engineer_id":"","project_title":"10\u53f0 PA445 \u8bbe\u5907\u91c7\u8d2d\u9879\u76ee\uff08\u6c99\u7279\u9879\u76ee\uff09","collected":"0","status_updated_at":"2025-07-25 11:40:23.236058+08","success_rate":"","comment":"\u62db\u6807\u7f16\u53f7\uff1aPOWRCHINA-0120009-250118","contract_type":1,"progress_updated_at":"2025-07-25 11:40:23.236058+08","forecast_updated_at":"2024-12-24 15:50:46.744407+08","end_at":"","pinyin_shortcut":"10tPA445sbcgxmstxm","creator":1001,"used_client":"","from_contact":5957,"total_contact_point":"342291","paid_contact_point":"","project_product_version_id":951,"is_sales_order_ready":false,"collected_plan":"885300","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":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4055,"from_project":3751,"serial_no":""},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2058,"name":"PAN-PA-445-BND-CORESEC-3YR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1664,"product_misc":"","product_qa":"","pn":"","description":"PA-445, Precision AI Network Security Subscription Bundle (Advanced Threat Prevention, Advanced URL Filtering, Advanced Wildfire, Advanced DNS Security and Advanced SD-WAN ), 3 years (36 months) term","created_by":1013,"created_at":"2025-07-21 14:53:01","updated_at":"2025-07-21 14:56:05","pinyin_shortcut":"PANPA445BNDCORESEC3YR","product_unit":3,"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":1664,"key":1664,"name":"PA445\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"amount":"22137.00","cost":"13200.00","id":10491,"project_id":3751,"product_id":2055,"number":10,"description":"","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"221370","total_cost":"132000","erp_sales_order_product_id":"","bargain_date":"2025-07-21","total_profit":"89370","total_profit_pct":"40.37","project":{"id":3751,"client_id":2553,"project_status":3,"project_progress":9,"budget":"885300","profit_pct":"2.74","bargain_date":"2025-07-21","description":"","created_by":1001,"created_at":"2024-12-24 15:50:46","updated_at":"2025-08-07 12:11:41","engineer_id":"","project_title":"10\u53f0 PA445 \u8bbe\u5907\u91c7\u8d2d\u9879\u76ee\uff08\u6c99\u7279\u9879\u76ee\uff09","collected":"0","status_updated_at":"2025-07-25 11:40:23.236058+08","success_rate":"","comment":"\u62db\u6807\u7f16\u53f7\uff1aPOWRCHINA-0120009-250118","contract_type":1,"progress_updated_at":"2025-07-25 11:40:23.236058+08","forecast_updated_at":"2024-12-24 15:50:46.744407+08","end_at":"","pinyin_shortcut":"10tPA445sbcgxmstxm","creator":1001,"used_client":"","from_contact":5957,"total_contact_point":"342291","paid_contact_point":"","project_product_version_id":951,"is_sales_order_ready":false,"collected_plan":"885300","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":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4055,"from_project":3751,"serial_no":""},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2055,"name":"PAN-PA-445","product_type":5,"product_component":26,"product_brand":8,"product_serie":1663,"product_misc":"","product_qa":"","pn":"","description":"Palo Alto Networks PA-445","created_by":1013,"created_at":"2025-07-21 14:49:47","updated_at":"2025-07-21 14:49:47","pinyin_shortcut":"PANPA445","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":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1663,"key":1663,"name":"PA-445\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"amount":"3312.00","cost":"800.00","id":10495,"project_id":3751,"product_id":2057,"number":10,"description":"","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"33120","total_cost":"8000","erp_sales_order_product_id":"","bargain_date":"2025-07-21","total_profit":"25120","total_profit_pct":"75.85","project":{"id":3751,"client_id":2553,"project_status":3,"project_progress":9,"budget":"885300","profit_pct":"2.74","bargain_date":"2025-07-21","description":"","created_by":1001,"created_at":"2024-12-24 15:50:46","updated_at":"2025-08-07 12:11:41","engineer_id":"","project_title":"10\u53f0 PA445 \u8bbe\u5907\u91c7\u8d2d\u9879\u76ee\uff08\u6c99\u7279\u9879\u76ee\uff09","collected":"0","status_updated_at":"2025-07-25 11:40:23.236058+08","success_rate":"","comment":"\u62db\u6807\u7f16\u53f7\uff1aPOWRCHINA-0120009-250118","contract_type":1,"progress_updated_at":"2025-07-25 11:40:23.236058+08","forecast_updated_at":"2024-12-24 15:50:46.744407+08","end_at":"","pinyin_shortcut":"10tPA445sbcgxmstxm","creator":1001,"used_client":"","from_contact":5957,"total_contact_point":"342291","paid_contact_point":"","project_product_version_id":951,"is_sales_order_ready":false,"collected_plan":"885300","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":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4055,"from_project":3751,"serial_no":""},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2057,"name":"PAN-PA-400-POE-RACKTRAY","product_type":5,"product_component":157,"product_brand":8,"product_serie":615,"product_misc":"","product_qa":"","pn":"","description":"Rack-Mountable Tray for PoE enabled PA-415 and PA-445","created_by":1013,"created_at":"2025-07-21 14:51:17","updated_at":"2025-07-21 14:56:19","pinyin_shortcut":"PANPA400POERACKTRAY","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":8,"key":8,"name":"Paloalto"},"productSerie":{"id":615,"key":615,"name":"PA-440\/450\/460\u5bfc\u8f68"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"amount":"44217.00","cost":"6900.00","id":10494,"project_id":3751,"product_id":2059,"number":10,"description":"","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"442170","total_cost":"69000","erp_sales_order_product_id":"","bargain_date":"2025-07-21","total_profit":"373170","total_profit_pct":"84.40","project":{"id":3751,"client_id":2553,"project_status":3,"project_progress":9,"budget":"885300","profit_pct":"2.74","bargain_date":"2025-07-21","description":"","created_by":1001,"created_at":"2024-12-24 15:50:46","updated_at":"2025-08-07 12:11:41","engineer_id":"","project_title":"10\u53f0 PA445 \u8bbe\u5907\u91c7\u8d2d\u9879\u76ee\uff08\u6c99\u7279\u9879\u76ee\uff09","collected":"0","status_updated_at":"2025-07-25 11:40:23.236058+08","success_rate":"","comment":"\u62db\u6807\u7f16\u53f7\uff1aPOWRCHINA-0120009-250118","contract_type":1,"progress_updated_at":"2025-07-25 11:40:23.236058+08","forecast_updated_at":"2024-12-24 15:50:46.744407+08","end_at":"","pinyin_shortcut":"10tPA445sbcgxmstxm","creator":1001,"used_client":"","from_contact":5957,"total_contact_point":"342291","paid_contact_point":"","project_product_version_id":951,"is_sales_order_ready":false,"collected_plan":"885300","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":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4055,"from_project":3751,"serial_no":""},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2059,"name":"PAN-SVC-PREM-445-3YR","product_type":5,"product_component":214,"product_brand":8,"product_serie":1665,"product_misc":"","product_qa":"","pn":"","description":"PA-445, Premium support, 3 years (36 months) term","created_by":1013,"created_at":"2025-07-21 14:55:55","updated_at":"2025-07-21 14:55:55","pinyin_shortcut":"PANSVCPREM4453YR","product_unit":3,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":214,"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1665,"key":1665,"name":"PA445\u4e09\u5e74\u670d\u52a1"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"amount":"0","cost":"800.00","id":10496,"project_id":3751,"product_id":2056,"number":4,"description":"\u8c03\u6574\u6295\u6807\u4ef7\u683c\uff0c4\u4e2a\u7535\u6e90\u7b97\u8d60\u9001","supplier_id":90,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"0","total_cost":"3200","erp_sales_order_product_id":"","bargain_date":"2025-07-21","total_profit":"-3200","total_profit_pct":"0.00","project":{"id":3751,"client_id":2553,"project_status":3,"project_progress":9,"budget":"885300","profit_pct":"2.74","bargain_date":"2025-07-21","description":"","created_by":1001,"created_at":"2024-12-24 15:50:46","updated_at":"2025-08-07 12:11:41","engineer_id":"","project_title":"10\u53f0 PA445 \u8bbe\u5907\u91c7\u8d2d\u9879\u76ee\uff08\u6c99\u7279\u9879\u76ee\uff09","collected":"0","status_updated_at":"2025-07-25 11:40:23.236058+08","success_rate":"","comment":"\u62db\u6807\u7f16\u53f7\uff1aPOWRCHINA-0120009-250118","contract_type":1,"progress_updated_at":"2025-07-25 11:40:23.236058+08","forecast_updated_at":"2024-12-24 15:50:46.744407+08","end_at":"","pinyin_shortcut":"10tPA445sbcgxmstxm","creator":1001,"used_client":"","from_contact":5957,"total_contact_point":"342291","paid_contact_point":"","project_product_version_id":951,"is_sales_order_ready":false,"collected_plan":"885300","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":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4055,"from_project":3751,"serial_no":""},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2056,"name":"PAN-PA-400-POE-PWR-150W","product_type":5,"product_component":157,"product_brand":8,"product_serie":1012,"product_misc":"","product_qa":"","pn":"","description":"150W Power Adaptor for PoE Enabled PA-415, PA-445, and PA-415-5G","created_by":1013,"created_at":"2025-07-21 14:50:36","updated_at":"2025-07-21 14:50:36","pinyin_shortcut":"PANPA400POEPWR150W","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":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1012,"key":1012,"name":"PA-440\/450\/460\u7535\u6e90"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"amount":"299.00","cost":"130.00","id":10555,"project_id":3924,"product_id":1691,"number":2,"description":"","supplier_id":608,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"598","total_cost":"260","erp_sales_order_product_id":"","bargain_date":"2025-07-21","total_profit":"338","total_profit_pct":"56.52","project":{"id":3924,"client_id":12,"project_status":3,"project_progress":9,"budget":"598","profit_pct":"47.17","bargain_date":"2025-07-21","description":"","created_by":5300,"created_at":"2025-07-21 10:18:07","updated_at":"2025-07-28 10:10:52","engineer_id":"","project_title":"OTJ25076163-\u56fa\u6001\u786c\u76d8-G-2025","collected":"0","status_updated_at":"2025-07-21 10:19:01.388059+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-21 10:18:07.061698+08","forecast_updated_at":"2025-07-21 10:18:07.061698+08","end_at":"","pinyin_shortcut":"OTJ25076163gtypG2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":949,"is_sales_order_ready":true,"collected_plan":"598","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":4049,"from_project":3924,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25076163"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":1691,"name":"BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8","product_type":11,"product_component":179,"product_brand":43,"product_serie":1439,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:51:53","updated_at":"2024-07-25 17:51:53","pinyin_shortcut":"BG5256G2230PCIE40NVMEgtyp","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":43,"key":43,"name":"\u4e1c\u829d"},"productSerie":{"id":1439,"key":1439,"name":"\u4e1c\u829d BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"amount":"295.00","cost":"199.31","id":10509,"project_id":3925,"product_id":1690,"number":2,"description":"","supplier_id":608,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"590","total_cost":"398.63","erp_sales_order_product_id":"","bargain_date":"2025-07-21","total_profit":"191.37","total_profit_pct":"32.44","project":{"id":3925,"client_id":12,"project_status":3,"project_progress":9,"budget":"590","profit_pct":"26.22","bargain_date":"2025-07-21","description":"","created_by":5300,"created_at":"2025-07-21 10:21:43","updated_at":"2025-07-28 10:09:23","engineer_id":"","project_title":"OTJ25076289-\u5185\u5b58\u6761-G-2025","collected":"0","status_updated_at":"2025-07-21 10:21:43.366273+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-21 10:21:43.366273+08","forecast_updated_at":"2025-07-21 10:21:43.366273+08","end_at":"","pinyin_shortcut":"OTJ25076289nctG2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":948,"is_sales_order_ready":true,"collected_plan":"590","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":4050,"from_project":3925,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25076289"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":1690,"name":"16GB DDR4-3200\u5185\u5b58","product_type":11,"product_component":179,"product_brand":10,"product_serie":1438,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:45:24","updated_at":"2024-07-25 17:45:24","pinyin_shortcut":"16GBDDR43200nc","product_unit":6,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":10,"key":10,"name":"\u4e09\u661f"},"productSerie":{"id":1438,"key":1438,"name":"\u4e09\u661f 16G DDR4 3200 \u5185\u5b58"},"productUnit":{"id":6,"key":6,"name":"\u6761"}}},{"amount":"28.00","cost":"25","id":10507,"project_id":3926,"product_id":1372,"number":10,"description":"","supplier_id":478,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"280","total_cost":"250","erp_sales_order_product_id":"","bargain_date":"2025-07-21","total_profit":"30","total_profit_pct":"10.71","project":{"id":3926,"client_id":3383,"project_status":3,"project_progress":6,"budget":"840","profit_pct":"5.25","bargain_date":"2025-07-21","description":"","created_by":5295,"created_at":"2025-07-21 13:33:14","updated_at":"2025-07-28 10:05:16","engineer_id":"","project_title":"\u65b0\u8d2d\u4ea4\u6362\u673a\u6a21\u5757\u548c\u7ebf\u7f06","collected":"0","status_updated_at":"2025-07-21 13:33:14.708949+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-21 13:33:14.708949+08","forecast_updated_at":"2025-07-21 13:33:14.708949+08","end_at":"","pinyin_shortcut":"xgjhjmkhxl","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":959,"is_sales_order_ready":true,"collected_plan":"840","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":3383,"key":3383,"name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8-\u9b4f\u6cfd\u6587\uff08\u8fc7\u5355\uff09"},"usedClient":"","buildContract":{"id":4054,"from_project":3926,"serial_no":"TS-WZW-20250721-01"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":1372,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73","product_type":4,"product_component":43,"product_brand":134,"product_serie":1047,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-01-26 16:48:55","updated_at":"2024-01-26 16:48:55","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"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":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1047,"key":1047,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73"},"productUnit":{"id":6,"key":6,"name":"\u6761"}}},{"amount":"280.00","cost":"260.00","id":10508,"project_id":3926,"product_id":1647,"number":2,"description":"","supplier_id":626,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"560","total_cost":"520","erp_sales_order_product_id":"","bargain_date":"2025-07-21","total_profit":"40","total_profit_pct":"7.14","project":{"id":3926,"client_id":3383,"project_status":3,"project_progress":6,"budget":"840","profit_pct":"5.25","bargain_date":"2025-07-21","description":"","created_by":5295,"created_at":"2025-07-21 13:33:14","updated_at":"2025-07-28 10:05:16","engineer_id":"","project_title":"\u65b0\u8d2d\u4ea4\u6362\u673a\u6a21\u5757\u548c\u7ebf\u7f06","collected":"0","status_updated_at":"2025-07-21 13:33:14.708949+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-21 13:33:14.708949+08","forecast_updated_at":"2025-07-21 13:33:14.708949+08","end_at":"","pinyin_shortcut":"xgjhjmkhxl","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":959,"is_sales_order_ready":true,"collected_plan":"840","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":3383,"key":3383,"name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8-\u9b4f\u6cfd\u6587\uff08\u8fc7\u5355\uff09"},"usedClient":"","buildContract":{"id":4054,"from_project":3926,"serial_no":"TS-WZW-20250721-01"},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":1647,"name":"SFP-GE-T-D","product_type":4,"product_component":43,"product_brand":20,"product_serie":1401,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-06-04 16:47:10","updated_at":"2024-06-04 16:47:10","pinyin_shortcut":"SFPGETD","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":20,"key":20,"name":"H3C"},"productSerie":{"id":1401,"key":1401,"name":"H3C \u5343\u5146RJ45\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"amount":"100.00","cost":"60.32","id":10549,"project_id":3922,"product_id":2069,"number":20,"description":"","supplier_id":138,"hardware_from":"2025-07-28","software_from":"","maintenance_from":"","hardware_to":"2028-07-27","software_to":"","maintenance_to":"","total_amount":"2000","total_cost":"1206.40","erp_sales_order_product_id":"","bargain_date":"2025-07-20","total_profit":"793.60","total_profit_pct":"39.68","project":{"id":3922,"client_id":2136,"project_status":3,"project_progress":9,"budget":"45500","profit_pct":"34.06","bargain_date":"2025-07-20","description":"","created_by":5087,"created_at":"2025-07-20 14:44:13","updated_at":"2025-07-28 14:54:03","engineer_id":"","project_title":"\u4e92\u8054\u7f51\u5ba1\u8ba1\u9879\u76ee","collected":"0","status_updated_at":"2025-07-27 14:06:33.545922+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-27 14:06:33.545922+08","forecast_updated_at":"2025-07-27 14:06:33.545922+08","end_at":"","pinyin_shortcut":"hlwsjxm","creator":5087,"used_client":"","from_contact":"","total_contact_point":"5000","paid_contact_point":"","project_product_version_id":965,"is_sales_order_ready":false,"collected_plan":"45500","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":4061,"from_project":3922,"serial_no":""},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2069,"name":"\u6df1\u4fe1\u670d\u9632\u6cc4\u5bc6\u5916\u53d1\u5ba1\u8ba1\u8f6f\u4ef6V7.0\uff08\u9002\u7528\u4e8e AC-1000-B1100-4D \uff09","product_type":4,"product_component":51,"product_brand":12,"product_serie":231,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-07-28 14:49:44","updated_at":"2025-07-28 14:49:44","pinyin_shortcut":"sxffxmwfsjrjV70syyAC1000B11004D","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":231,"key":231,"name":"\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"amount":"23500.00","cost":"1829.00","id":10548,"project_id":3922,"product_id":2066,"number":1,"description":"","supplier_id":138,"hardware_from":"2025-07-28","software_from":"","maintenance_from":"","hardware_to":"2028-07-27","software_to":"","maintenance_to":"","total_amount":"23500","total_cost":"1829","erp_sales_order_product_id":"","bargain_date":"2025-07-20","total_profit":"21671","total_profit_pct":"92.22","project":{"id":3922,"client_id":2136,"project_status":3,"project_progress":9,"budget":"45500","profit_pct":"34.06","bargain_date":"2025-07-20","description":"","created_by":5087,"created_at":"2025-07-20 14:44:13","updated_at":"2025-07-28 14:54:03","engineer_id":"","project_title":"\u4e92\u8054\u7f51\u5ba1\u8ba1\u9879\u76ee","collected":"0","status_updated_at":"2025-07-27 14:06:33.545922+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-27 14:06:33.545922+08","forecast_updated_at":"2025-07-27 14:06:33.545922+08","end_at":"","pinyin_shortcut":"hlwsjxm","creator":5087,"used_client":"","from_contact":"","total_contact_point":"5000","paid_contact_point":"","project_product_version_id":965,"is_sales_order_ready":false,"collected_plan":"45500","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":4061,"from_project":3922,"serial_no":""},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2066,"name":"AC-1000-B1100-4D","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\uff1a2Gb\uff0c\u5e94\u7528\u5c42\u541e\u5410\u91cf\uff1a150Mb\uff0c\u5e26\u5bbd\u6027\u80fd\uff1a100Mb\uff0cIPSEC VPN\u52a0\u5bc6\u6027\u80fd\uff08\u6700\u9ad8\u6027\u80fd\uff09\uff1a20Mb\uff0c\u652f\u6301\u7528\u6237\u6570\uff1a500\uff0c\u51c6\u5165\u7ec8\u7aef\u6570\uff08\u652f\u6301\u5ba2\u6237\u7aef\u6388\u6743-\u9700\u5355\u72ec\u6536\u8d39\uff09\uff1a250\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\uff1a500\uff0c\u9632\u6cc4\u5bc6\u7ec8\u7aef\u6570\u4e0a\u9650(\u9700\u5355\u72ec\u6536\u8d39)\uff1a1500\uff0c\u5305\u8f6c\u53d1\u7387\uff1a14.4Kpps\uff0c\u6bcf\u79d2\u65b0\u5efa\u8fde\u63a5\u6570\uff1a1000\uff0c\u6700\u5927\u5e76\u53d1\u8fde\u63a5\u6570\uff1a50000\u3002\n\u786c\u4ef6\u53c2\u6570\uff1a\u89c4\u683c\uff1a1U\uff0c\u5185\u5b58\u5927\u5c0f\uff1a4G\uff0c\u786c\u76d8\u5bb9\u91cf\uff1a128G minisata SSD\uff0c\u7535\u6e90\uff1a\u5355\u7535\u6e90\uff0c\u63a5\u53e3\uff1a4\u5343\u5146\u7535\u53e3","created_by":1013,"created_at":"2025-07-28 14:44:29","updated_at":"2025-07-28 14:44:29","pinyin_shortcut":"AC1000B11004D","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":"8000.00","cost":"7973.84","id":10551,"project_id":3922,"product_id":2067,"number":1,"description":"","supplier_id":138,"hardware_from":"2025-07-28","software_from":"","maintenance_from":"","hardware_to":"2028-07-27","software_to":"","maintenance_to":"","total_amount":"8000","total_cost":"7973.84","erp_sales_order_product_id":"","bargain_date":"2025-07-20","total_profit":"26.16","total_profit_pct":"0.33","project":{"id":3922,"client_id":2136,"project_status":3,"project_progress":9,"budget":"45500","profit_pct":"34.06","bargain_date":"2025-07-20","description":"","created_by":5087,"created_at":"2025-07-20 14:44:13","updated_at":"2025-07-28 14:54:03","engineer_id":"","project_title":"\u4e92\u8054\u7f51\u5ba1\u8ba1\u9879\u76ee","collected":"0","status_updated_at":"2025-07-27 14:06:33.545922+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-27 14:06:33.545922+08","forecast_updated_at":"2025-07-27 14:06:33.545922+08","end_at":"","pinyin_shortcut":"hlwsjxm","creator":5087,"used_client":"","from_contact":"","total_contact_point":"5000","paid_contact_point":"","project_product_version_id":965,"is_sales_order_ready":false,"collected_plan":"45500","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":4061,"from_project":3922,"serial_no":""},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2067,"name":"\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6V13.0(\u9002\u7528\u4e8eAC-1000-B1100-4D)","product_type":4,"product_component":51,"product_brand":12,"product_serie":231,"product_misc":"","product_qa":"","pn":"","description":"\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6V13.0","created_by":1013,"created_at":"2025-07-28 14:45:38","updated_at":"2025-07-28 14:50:11","pinyin_shortcut":"sxfqwxwglxtrjV130syyAC1000B11004D","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":231,"key":231,"name":"\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"amount":"1000.00","cost":"998.68","id":10550,"project_id":3922,"product_id":2068,"number":3,"description":"","supplier_id":138,"hardware_from":"2025-07-28","software_from":"","maintenance_from":"","hardware_to":"2028-07-27","software_to":"","maintenance_to":"","total_amount":"3000","total_cost":"2996.04","erp_sales_order_product_id":"","bargain_date":"2025-07-20","total_profit":"3.96","total_profit_pct":"0.13","project":{"id":3922,"client_id":2136,"project_status":3,"project_progress":9,"budget":"45500","profit_pct":"34.06","bargain_date":"2025-07-20","description":"","created_by":5087,"created_at":"2025-07-20 14:44:13","updated_at":"2025-07-28 14:54:03","engineer_id":"","project_title":"\u4e92\u8054\u7f51\u5ba1\u8ba1\u9879\u76ee","collected":"0","status_updated_at":"2025-07-27 14:06:33.545922+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-27 14:06:33.545922+08","forecast_updated_at":"2025-07-27 14:06:33.545922+08","end_at":"","pinyin_shortcut":"hlwsjxm","creator":5087,"used_client":"","from_contact":"","total_contact_point":"5000","paid_contact_point":"","project_product_version_id":965,"is_sales_order_ready":false,"collected_plan":"45500","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":4061,"from_project":3922,"serial_no":""},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":2068,"name":"\u6df1\u4fe1\u670dURL\u7cfb\u7edf\u8f6f\u4ef6V5.0\uff08\u9002\u7528\u4e8eAC-1000-B1100-4D\uff09","product_type":4,"product_component":51,"product_brand":12,"product_serie":231,"product_misc":"","product_qa":"","pn":"","description":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7","created_by":1013,"created_at":"2025-07-28 14:46:34","updated_at":"2025-07-28 14:49:58","pinyin_shortcut":"sxfURLxtrjV50syyAC1000B11004D","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":231,"key":231,"name":"\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"amount":"4000.00","cost":"3994.72","id":10552,"project_id":3922,"product_id":978,"number":1,"description":"","supplier_id":138,"hardware_from":"2025-07-28","software_from":"","maintenance_from":"","hardware_to":"2028-07-27","software_to":"","maintenance_to":"","total_amount":"4000","total_cost":"3994.72","erp_sales_order_product_id":"","bargain_date":"2025-07-20","total_profit":"5.28","total_profit_pct":"0.13","project":{"id":3922,"client_id":2136,"project_status":3,"project_progress":9,"budget":"45500","profit_pct":"34.06","bargain_date":"2025-07-20","description":"","created_by":5087,"created_at":"2025-07-20 14:44:13","updated_at":"2025-07-28 14:54:03","engineer_id":"","project_title":"\u4e92\u8054\u7f51\u5ba1\u8ba1\u9879\u76ee","collected":"0","status_updated_at":"2025-07-27 14:06:33.545922+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-27 14:06:33.545922+08","forecast_updated_at":"2025-07-27 14:06:33.545922+08","end_at":"","pinyin_shortcut":"hlwsjxm","creator":5087,"used_client":"","from_contact":"","total_contact_point":"5000","paid_contact_point":"","project_product_version_id":965,"is_sales_order_ready":false,"collected_plan":"45500","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":4061,"from_project":3922,"serial_no":""},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":978,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u63a5\u5165\u5b89\u5168\u8f6f\u4ef6V3.0","product_type":7,"product_component":41,"product_brand":12,"product_serie":1277,"product_misc":"","product_qa":"","pn":"","description":"V3.0","created_by":1013,"created_at":"2023-08-09 09:29:27","updated_at":"2024-03-11 13:59:51","pinyin_shortcut":"sxfzdjraqrjV30","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":41,"key":41,"name":"\u5b89\u5168\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1277,"key":1277,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u63a5\u5165\u5b89\u5168\u8f6f\u4ef6V3.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"amount":"5000.00","cost":"5000.00","id":10553,"project_id":3922,"product_id":942,"number":1,"description":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"5000","total_cost":"5000","erp_sales_order_product_id":"","bargain_date":"2025-07-20","total_profit":"0","total_profit_pct":"0.00","project":{"id":3922,"client_id":2136,"project_status":3,"project_progress":9,"budget":"45500","profit_pct":"34.06","bargain_date":"2025-07-20","description":"","created_by":5087,"created_at":"2025-07-20 14:44:13","updated_at":"2025-07-28 14:54:03","engineer_id":"","project_title":"\u4e92\u8054\u7f51\u5ba1\u8ba1\u9879\u76ee","collected":"0","status_updated_at":"2025-07-27 14:06:33.545922+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-27 14:06:33.545922+08","forecast_updated_at":"2025-07-27 14:06:33.545922+08","end_at":"","pinyin_shortcut":"hlwsjxm","creator":5087,"used_client":"","from_contact":"","total_contact_point":"5000","paid_contact_point":"","project_product_version_id":965,"is_sales_order_ready":false,"collected_plan":"45500","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":4061,"from_project":3922,"serial_no":""},"project_status_display":"\u5546\u673a\u6210\u4ea4"},"product":{"id":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":134,"product_serie":593,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2023-08-11 16:02:40","pinyin_shortcut":"dsfwcjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}}}],"countArr":{"budget":"121740934.42","cost":"88030365.07","profits":"33710569.35","profit_pct":"27.69"},"pagenation":{"totalcount":1839,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-10 04:17:07') RETURNING "id"
04:17:07.495traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
04:17:07.495traceyii\redis\Connection::executeCommandExecuting Redis Command: SET