ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2bbaa2015d3: POST https://beta.jinchangxiao.com/v2/sales-contract/of-client at 2026-06-12 03:52:02 pm by 223.104.41.38

Log Messages

总计110条数据
TimeLevelCategoryMessage
 
15:52:02.004traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
15:52:02.004traceyii\base\Module::getModuleLoading module: debug
15:52:02.005traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
15:52:02.005traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
15:52:02.006traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
15:52:02.018traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:52:02.023infotime tracing start1781250722023667968
15:52:02.023traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
15:52:02.023traceyii\web\Application::handleRequestRoute requested: 'v2/sales-contract/of-client'
15:52:02.023traceyii\base\Module::getModuleLoading module: v2
15:52:02.394infoyii\web\Session::openSession started
15:52:02.396infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:52:02.397infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC'
15:52:02.400traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:52:02.401traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:52:02.401traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:52:02.402traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:52:02.402infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:52:02.404traceyii\base\Controller::runActionRoute to run: v2/sales-contract/of-client
15:52:02.404traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:52:02.407traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:52:02.407traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\SalesContractController::actionOfClient()
15:52:02.407infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='93') AND ("deleted"=FALSE)
15:52:02.408traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:52:02.409traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:52:02.414traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:52:02.419infoyii\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_sales_contracts' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
15:52:02.425infoyii\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_sales_contracts' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
15:52:02.452traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:52:02.453traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
15:52:02.495traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:52:02.497traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:52:02.500infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE "client"."id"='93' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"
15:52:02.515infoyii\db\Command::querySELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE "client"."id"='93' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10
15:52:02.532infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=93
15:52:02.533infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
15:52:02.534infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)
15:52:02.535infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
15:52:02.536infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)
15:52:02.537infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
15:52:02.538infoyii\db\Command::querySELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (4497, 4074, 3705, 3679, 3325)) GROUP BY "object_id"
15:52:02.580infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (4146, 3488, 3699, 3700, 3417)
15:52:02.581infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (3700, 3699, 3488, 4146, 3417))
15:52:02.587infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (1253, 1394, 1407, 1560) ORDER BY "id"
15:52:02.589infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (1253, 1394, 1407, 1560) ORDER BY "id"
15:52:02.591infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id" IN (4497, 4074, 3705, 3679, 3325) ORDER BY "id" DESC
15:52:02.593infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (1719, 1560, 1407, 1394, 1253) ORDER BY "id"
15:52:02.594infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (1719, 1560, 1407, 1394, 1253) ORDER BY "id"
15:52:02.595infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE "erp_sales_order_id" IN (1719, 1560, 1407, 1394, 1253) ORDER BY "id"
15:52:02.597infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "description", "total_contact_point", "paid_contact_point", "is_sales_order_ready", "project_product_version_id", "bargain_date", "collected", "profit_pct", "budget" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (4146, 3488, 3699, 3700, 3417)
15:52:02.599infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (3700, 3699, 3488, 4146, 3417))
15:52:02.601infoyii\db\Command::querySELECT "id", "product_type_id", "product_type_id" AS "key", "name", "budget", "pct", "project_id", "profit" FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (3700, 3699, 3488, 4146, 3417)
15:52:02.602infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3700, 3699, 3488, 4146, 3417) ORDER BY "id"
15:52:02.604infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (614, 262, 534, 68)
15:52:02.605infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1625, 1626, 1627, 1628, 1629, 1630, 1631, 1632, 1633, 1634, 1635, 1636, 1637, 1638, 941, 1227, 942, 899, 900, 1886, 220, 1906, 1907, 2127, 952, 2126)
15:52:02.607infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (5, 7, 19, 22, 3, 4, 23)
15:52:02.608infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (26, 35, 153, 151, 189, 15, 39, 43, 14, 193)
15:52:02.609infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (40, 137, 134, 133, 27, 4, 190)
15:52:02.610infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1383, 1386, 1384, 1387, 1385, 1388, 1389, 1390, 1391, 1701, 1392, 593, 1702, 592, 564, 1393, 1394, 338, 1577, 1578, 1127, 563, 598, 812)
15:52:02.611infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (1, 8, 2, 7, 4, 6, 3)
15:52:02.611infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 919, 920, 921, 922, 923, 924, 1434, 1435, 1436, 1437, 1395, 1396, 1397, 1398, 1399, 1400, 1401, 1402, 1403, 1875, 1876, 1874, 1877)
15:52:02.612infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3700, 3699, 3488, 4146, 3417)
15:52:02.613infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (4701, 5876)
15:52:02.614infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=93
15:52:02.614infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((4701, 3417), (4701, 3700), (4701, 3488), (5876, 3488))
15:52:02.615infoyii\db\Command::querySELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (3700, 3699, 3488, 4146, 3417))
15:52:02.626infoyii\db\Command::querySELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (3700, 3699, 3488, 4146, 3417)) GROUP BY "project_id"
15:52:02.630infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (4497, 4074, 3705, 3679, 3325)
15:52:02.631infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (729, 614, 534, 68, 262)
15:52:02.631infoyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4137, 3340, 3817, 3687, 3387, 3461, 3723)
15:52:02.632infoyii\db\Command::querySELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id"=1
15:52:02.632infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
15:52:02.633infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)
15:52:02.633infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("reminded"=FALSE) AND ("contract_id" IN (4497, 4074, 3705, 3679, 3325)) ORDER BY "remind_date"
15:52:02.652infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id" IN (4497, 4074, 3705, 3679, 3325)
15:52:02.653infoyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (4497, 4074, 3705, 3679, 3325)
15:52:02.658infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
15:52:02.658infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)
15:52:02.659infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (4497, 4074, 3705, 3679, 3325)
15:52:02.662infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
15:52:02.663infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)
15:52:02.664infoyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (4497, 4074, 3705, 3679, 3325)
15:52:02.666infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 1001, 5087)
15:52:02.667infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5087, 1005))
15:52:02.668infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4497, 4074, 3705, 3679, 3325) ORDER BY "remind_date"
15:52:02.670infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "created_at", "description", "collected_date", "amount" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.wrote_date as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "r" WHERE "contract_id" IN (4497, 4074, 3705, 3679, 3325) ORDER BY "id" DESC
15:52:02.675infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013
15:52:02.676infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft", "is_cancel" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (4497, 4074, 3705, 3679, 3325) ORDER BY "id"
15:52:02.680infoyii\db\Command::querySELECT "id", "sales_invoice_id", "amount", "tax_rate" FROM "a57be577deb434"."tbl_sales_invoice_amounts" WHERE "sales_invoice_id" IN (1696, 1910, 1931, 2010, 2011, 2018, 2024, 2025, 2028, 2029, 2200) ORDER BY "id"
15:52:02.693infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (1696, 1910, 1931, 2010, 2011, 2018, 2024, 2025, 2028, 2029, 2200))
15:52:02.697infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (1696, 1910, 1931, 2010, 2011, 2018, 2024, 2025, 2028, 2029, 2200))
15:52:02.701infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (19971, 23365, 23610, 25037, 25038, 25331, 25368, 25369, 25408, 29873)
15:52:02.705infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (4497, 4074, 3705, 3679, 3325))
15:52:02.709infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (19507, 23140, 22964, 27622)
15:52:02.710infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (4497, 4074, 3705, 3679, 3325))
15:52:02.713infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (19978, 23653, 23652)
15:52:02.714infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (4497, 4074, 3705, 3679, 3325))
15:52:02.717infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (20020, 25332, 29909)
15:52:02.718infoyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=7) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (4497, 4074, 3705, 3679, 3325)) GROUP BY "object_id"
15:52:02.753infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4497
15:52:02.755traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewProduct
15:52:02.756traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
15:52:02.756traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:52:02.756infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4074
15:52:02.757infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=3705
15:52:02.759infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=3679
15:52:02.760infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=3325
15:52:02.766traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:52:02.767traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:52:02.768infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 2, 1159, 'v2/sales-contract/of-client', '{"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"2","id":"93","page":"1","posttime":"1781250688","token":"9e0b3bf781a601ea1ae60dd479e08372","version_code":"1159"}', '{"code":200,"data":{"list":[{"id":4497,"client_id":93,"signed_at":"2026-06-05","amount":"500000","handler":1005,"description":"","created_by":1005,"created_at":"2026-06-05 11:26:50","updated_at":"2026-06-05 11:26:50","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":4146,"valid_date":null,"expire_date":null,"sla":null,"remind_ahead":null,"expire_remind_ahead":null,"expire_reminded":false,"serial_no":"2026-06-05-007","payment_collection_remind_ahead":"1 day","from_project":4146,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":"2026-06-05 11:27:18","is_verify":false,"is_draft":true,"erp_settle_amount":"0","erp_un_settle_amount":"500000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"0","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":false,"is_edit_verify":false,"is_chargeback_verify":true,"b_date":null,"passed":1,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":4497,"comment":3},"project":{"id":4146,"key":4146,"name":"\u98de\u5854\u96f6\u4fe1\u4efb\u65b0\u8d2d","erpSalesOrder":null},"erpSalesOrder":{"id":1719,"serial_no":"XSDD-20260605-00008","from_date":null,"wrote_date":"2026-06-05","handler":1005,"client_id":93,"purchase_contract_id":null,"project_id":4146,"sales_contract_id":4497,"erp_store_id":null,"status":7,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":1001,"verify_at":"2026-06-05 11:26:50","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"500000","created_by":1005,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"5087\",\"1005\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-06-05 11:26:44","updated_at":"2026-06-05 11:27:18","print_times":null,"erpSalesOrderVerifyRels":[{"id":148,"erp_sales_order_id":1719,"user_id":1001,"status":1,"description":"","verify_at":"2026-06-05 11:26:50"}],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[{"id":6,"erp_sales_order_id":1719,"user_id":1001,"status":0,"description":null,"verify_at":""}]},"fromProject":{"id":4146,"key":4146,"name":"\u98de\u5854\u96f6\u4fe1\u4efb\u65b0\u8d2d","description":null,"total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":null,"bargain_date":"2026-06-05","collected":"0","profit_pct":"15","budget":"500000","erpSalesOrder":null,"projectProductTypes":[{"id":8636,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"500000","pct":"15","project_id":4146,"profit":"75000"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":75000,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":10168,"user_id":1001,"key":1001,"contract_id":4497,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},{"id":10169,"user_id":5087,"key":5087,"contract_id":4497,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},{"id":10170,"user_id":1005,"key":1005,"contract_id":4497,"user":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":null,"un_invoiced":500000,"collected":"0","un_collected":500000,"is_collected":false,"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":500000},{"id":4074,"client_id":93,"signed_at":"2025-07-31","amount":"545000","handler":1005,"description":"","created_by":1005,"created_at":"2025-07-31 11:45:20","updated_at":"2026-01-14 09:38:52","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3488,"valid_date":null,"expire_date":"2028-07-31","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":false,"serial_no":"C202507230036","payment_collection_remind_ahead":"1 day","from_project":3488,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-07-31 11:45:20","is_verify":false,"is_draft":false,"erp_settle_amount":"545000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"545000","receipt_scan_uploaded":false,"verify_scan_uploaded":true,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":780,"passed":2,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":4074,"comment":9},"project":{"id":3488,"key":3488,"name":"\u591a\u56e0\u7d20\u8ba4\u8bc1-\u5b81\u76fe5000\u70b9","erpSalesOrder":{"id":1560,"serial_no":"XSDD-20250731-00002","from_date":null,"wrote_date":"2025-07-31","handler":1005,"client_id":93,"purchase_contract_id":null,"project_id":3488,"sales_contract_id":4074,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"5005","amount":"545000","created_by":1005,"stop_description":null,"extra":null,"outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2025-07-31 11:45:20","updated_at":"2025-07-31 11:45:20","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1560,"serial_no":"XSDD-20250731-00002","from_date":null,"wrote_date":"2025-07-31","handler":1005,"client_id":93,"purchase_contract_id":null,"project_id":3488,"sales_contract_id":4074,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"5005","amount":"545000","created_by":1005,"stop_description":null,"extra":null,"outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2025-07-31 11:45:20","updated_at":"2025-07-31 11:45:20","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3488,"key":3488,"name":"\u591a\u56e0\u7d20\u8ba4\u8bc1-\u5b81\u76fe5000\u70b9","description":"","total_contact_point":"70000","paid_contact_point":"70000","is_sales_order_ready":true,"project_product_version_id":1069,"bargain_date":"2025-07-31","collected":"545000","profit_pct":"15.95","budget":"545000","erpSalesOrder":{"id":1560,"serial_no":"XSDD-20250731-00002","from_date":null,"wrote_date":"2025-07-31","handler":1005,"client_id":93,"purchase_contract_id":null,"project_id":3488,"sales_contract_id":4074,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"5005","amount":"545000","created_by":1005,"stop_description":null,"extra":null,"outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2025-07-31 11:45:20","updated_at":"2025-07-31 11:45:20","print_times":null},"projectProductTypes":[{"id":8110,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"90000","pct":"15.95","project_id":3488,"profit":"14355"},{"id":8111,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"455000","pct":"15.95","project_id":3488,"profit":"72572.5"}],"projectProductRels":[{"id":11015,"project_id":3488,"product_id":2127,"amount":"90000","number":1,"cost":"24000","description":"","supplier_id":null,"hardware_from":null,"software_from":"2025-09-04","maintenance_from":null,"hardware_to":null,"software_to":"2028-09-03","maintenance_to":null,"total_amount":"90000","total_cost":"24000","erp_sales_order_product_id":1875,"supplier":null,"product":{"id":2127,"name":"\u5b81\u76fe\u6280\u672f\u652f\u6301\u670d\u52a1","product_type":22,"product_component":189,"product_brand":137,"product_serie":1702,"product_misc":null,"product_qa":null,"pn":"","description":"\u514d\u8d39\u63d0\u4f9b\u4e09\u5e74\u8f6f\u4ef6\u5347\u7ea7\u53ca\u63d0\u4f9b\u65e5\u5e38\u5de1\u68c0\u30015*8\u7684\u6280\u672f\u4fdd\u969c\uff0c\u5e38\u89c4\u4e8b\u4ef6\u54cd\u5e94\u65f6\u95f4\uff081\u5c0f\u65f6\u7684\u7535\u8bdd\u54cd\u5e94\uff0c2\u5c0f\u65f6\u5185\u627e\u51fa\u89e3\u51b3\u65b9\u6848\uff09\u3001\u7d27\u6025\u6545\u969c\u5e743\u6b21\u73b0\u573a\u670d\u52a1\u3002","created_by":1013,"created_at":"2025-09-03 11:04:41","updated_at":"2025-11-10 11:30:48","pinyin_shortcut":"ndjszcfw","product_unit":8,"is_renew":false,"in_out_at":"2025-11-10 11:30:48.584708+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":137,"key":137,"name":"\u5b81\u76fe"},"productSerie":{"id":1702,"key":1702,"name":"\u539f\u5382\u4e09\u5e74\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":1875,"erp_sales_order_id":1560,"erp_store_id":null,"product_id":2127,"description":"","number":"1","outbound":"1","amount":"90000","total_amount":"90000","last_number":"1","last_amount":"90000","last_total_amount":"90000","cost":"24000","total_cost":"24000","supplier_id":null,"hardware_from":null,"software_from":"2025-09-04","maintenance_from":null,"hardware_to":null,"software_to":"2028-09-03","maintenance_to":null}},{"id":11016,"project_id":3488,"product_id":952,"amount":"59","number":5000,"cost":"40","description":"","supplier_id":null,"hardware_from":null,"software_from":"2025-09-04","maintenance_from":null,"hardware_to":null,"software_to":"2028-09-03","maintenance_to":null,"total_amount":"295000","total_cost":"200000","erp_sales_order_product_id":1876,"supplier":null,"product":{"id":952,"name":"\u52a8\u6001\u4ee4\u724c","product_type":7,"product_component":153,"product_brand":137,"product_serie":598,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 16:34:36","updated_at":"2025-11-10 11:30:48","pinyin_shortcut":"dtlp","product_unit":2,"is_renew":false,"in_out_at":"2025-11-10 11:30:48.584708+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":153,"key":153,"name":"\u8ba4\u8bc1\u5e73\u53f0"},"productBrand":{"id":137,"key":137,"name":"\u5b81\u76fe"},"productSerie":{"id":598,"key":598,"name":"\u52a8\u6001\u4ee4\u724c"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1876,"erp_sales_order_id":1560,"erp_store_id":null,"product_id":952,"description":"","number":"5000","outbound":"5000","amount":"59","total_amount":"295000","last_number":"5000","last_amount":"59","last_total_amount":"295000","cost":"40","total_cost":"200000","supplier_id":null,"hardware_from":null,"software_from":"2025-09-04","maintenance_from":null,"hardware_to":null,"software_to":"2028-09-03","maintenance_to":null}},{"id":11017,"project_id":3488,"product_id":942,"amount":"0","number":3,"cost":"3000","description":"\u5b89\u88c5\u670d\u52a1","supplier_id":null,"hardware_from":null,"software_from":"2025-09-04","maintenance_from":null,"hardware_to":null,"software_to":"2028-09-03","maintenance_to":null,"total_amount":"0","total_cost":"9000","erp_sales_order_product_id":1874,"supplier":null,"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":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2026-01-28 10:32:39","pinyin_shortcut":"dsfwcjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-01-28 10:32:39.333577+08","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"}},"erpSalesOrderProduct":{"id":1874,"erp_sales_order_id":1560,"erp_store_id":null,"product_id":942,"description":"\u5b89\u88c5\u670d\u52a1","number":"3","outbound":"3","amount":"0","total_amount":"0","last_number":"3","last_amount":"0","last_total_amount":"0","cost":"3000","total_cost":"9000","supplier_id":null,"hardware_from":null,"software_from":"2025-09-04","maintenance_from":null,"hardware_to":null,"software_to":"2028-09-03","maintenance_to":null}},{"id":11018,"project_id":3488,"product_id":2126,"amount":"160000","number":1,"cost":"107000","description":"","supplier_id":null,"hardware_from":null,"software_from":"2025-09-04","maintenance_from":null,"hardware_to":null,"software_to":"2028-09-03","maintenance_to":null,"total_amount":"160000","total_cost":"107000","erp_sales_order_product_id":1877,"supplier":null,"product":{"id":2126,"name":"\u53cc\u56e0\u5b50\u8ba4\u8bc1\u8f6f\u4ef6\uff0dPro","product_type":7,"product_component":153,"product_brand":137,"product_serie":1701,"product_misc":null,"product_qa":null,"pn":"","description":"\u4e13\u4e1a\u7248\u5e73\u53f0\uff0c\u4e0d\u9650\u5236\u5e94\u7528\u6570\u4ee5\u53ca\u7528\u6237\u6570\u63a5\u5165\uff0cExchange\/Citrix\/SSL VPN\/VMWare View\/Web\/\u5821\u5792\u673a\/\u670d\u52a1\u5668\u7b49\u5728\u5e10\u53f7\u5bc6\u7801\u8ba4\u8bc1\u57fa\u7840\u4e0a\u589e\u52a0\u52a8\u6001\u5bc6\u7801\u4fdd\u62a4\u3002\u63d0\u4f9b\u6807\u51c6\u5f97API\u63a5\u53e3\uff1b","created_by":1013,"created_at":"2025-09-03 11:03:06","updated_at":"2025-11-10 11:30:48","pinyin_shortcut":"syzrzrjPro","product_unit":2,"is_renew":false,"in_out_at":"2025-11-10 11:30:48.584708+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":153,"key":153,"name":"\u8ba4\u8bc1\u5e73\u53f0"},"productBrand":{"id":137,"key":137,"name":"\u5b81\u76fe"},"productSerie":{"id":1701,"key":1701,"name":"\u53cc\u56e0\u5b50\u8ba4\u8bc1\u5e73\u53f0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1877,"erp_sales_order_id":1560,"erp_store_id":null,"product_id":2126,"description":"","number":"1","outbound":"1","amount":"160000","total_amount":"160000","last_number":"1","last_amount":"160000","last_total_amount":"160000","cost":"107000","total_cost":"107000","supplier_id":null,"hardware_from":null,"software_from":"2025-09-04","maintenance_from":null,"hardware_to":null,"software_to":"2028-09-03","maintenance_to":null}}],"projectContactPoints":[{"id":1348,"project_id":3488,"contact_id":4701,"point":"50000.00","paid_point":"50000","contact":{"id":4701,"key":4701,"name":"\u5218\u6653\u51cc","client_id":93,"supplier_id":null,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":236,"project_id":3488,"contact_id":4701,"point":"50000.00","day_at":"2025-12-15","description":"","created_at":"2025-12-15 09:17:12"}],"status_display":"\u5df2\u6838\u9500"},{"id":1349,"project_id":3488,"contact_id":5876,"point":"20000.00","paid_point":"20000","contact":{"id":5876,"key":5876,"name":"\u51af\u5b66\u9e4f","client_id":93,"supplier_id":null,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":237,"project_id":3488,"contact_id":5876,"point":"20000.00","day_at":"2025-12-15","description":"","created_at":"2025-12-15 09:17:12"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":13466,"project_id":3488},{"id":13468,"project_id":3488},{"id":13469,"project_id":3488},{"id":13467,"project_id":3488}],"reimbursementAmountSum":null,"profit":86927.5,"contact_points_status_display":"\u5df2\u6838\u9500","total_contact_paid_point":70000,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":3881,"contract_id":4074,"supplier_id":729,"purchase_id":4137,"supplier":{"id":729,"key":729,"name":"\u5317\u4eac\u7f8e\u7f51\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4137,"key":4137,"serial_no":"TSKJ20250903-HYF-01"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8667,"user_id":1005,"key":1005,"contract_id":4074,"user":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":9752,"user_id":1005,"key":1005,"contract_id":4074,"user":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2538,"key":2538,"contract_id":4074,"name":"2025-11-30","value":"545000","overdue_days":8,"status":1,"remind_date":"2025-11-30","pct":100,"overdue_display":"\u903e\u671f8\u5929"}],"salesContractPayments":[{"id":"12104","key":"12104","contract_id":4074,"value":"545000","created_by":1013,"created_at":"2025-12-08 15:28:41","description":null,"collected_date":"2025-12-08 00:00:00","amount":"545000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2200,"key":2200,"contract_id":4074,"value":"545000.00","attachment_id":null,"from_date":"2025-11-18","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":3023,"sales_invoice_id":2200,"amount":"455000","tax_rate":"13"},{"id":3024,"sales_invoice_id":2200,"amount":"90000","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":52714,"object_type":102,"object_id":2200,"attachment_id":29873,"attachment":{"id":29873,"key":29873,"name":"9c49969a-2ab9-3c22-bf9a-2fcd3483b6b8","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/9c49969a-2ab9-3c22-bf9a-2fcd3483b6b8\/dzfp_25112000000253541547_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8_20251118141022.pdf","orig_name":"dzfp_25112000000253541547_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8_20251118141022.pdf"}}]}],"contractScans":[{"id":55304,"object_type":105,"object_id":4074,"attachment_id":27622,"attachment":{"id":27622,"key":27622,"name":"715e29f5-527f-3158-88c5-219d554ccfc3","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/715e29f5-527f-3158-88c5-219d554ccfc3\/2025_07_31_12_03_07.pdf","orig_name":"2025_07_31_12_03_07.pdf"}}],"receiptScans":[],"verifyScans":[{"id":52821,"object_type":107,"object_id":4074,"attachment_id":29909,"attachment":{"id":29909,"key":29909,"name":"d834d250-b54e-3357-af83-884b4857b551","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/d834d250-b54e-3357-af83-884b4857b551\/2025_11_21_13_20_49.pdf","orig_name":"2025_11_21_13_20_49.pdf"}}],"unreadComments":null,"collected_plan":545000,"projectProductTotalAmount":545000,"projectProductAllAmount":true,"projectProductTotalCost":340000,"projectProductAllCost":true,"projectProductTotalCount":5005,"invoiced":"545000.00","un_invoiced":0,"collected":"545000","un_collected":0,"is_collected":true,"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":true,"can_view_product_cost":true,"erp_all_un_settle_amount":0},{"id":3705,"client_id":93,"signed_at":"2024-11-29","amount":"458000","handler":1005,"description":"","created_by":1005,"created_at":"2024-12-12 13:39:18","updated_at":"2025-04-27 15:07:41","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3699,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"C202411290020","payment_collection_remind_ahead":"7 days","from_project":3699,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2024-12-30 11:50:43","is_verify":false,"is_draft":false,"erp_settle_amount":"458000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"458000","receipt_scan_uploaded":true,"verify_scan_uploaded":true,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3705,"comment":12},"project":{"id":3699,"key":3699,"name":"\u7b2c\u4e8c\u56ed\u533a\u65b0\u8d2d\u51fa\u53e3\u9632\u706b\u5899-\u98de\u5854","erpSalesOrder":{"id":1407,"serial_no":"XSDD-20241212-00001","from_date":null,"wrote_date":"2024-11-29","handler":1005,"client_id":93,"purchase_contract_id":null,"project_id":3699,"sales_contract_id":3705,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-05-16 16:54:30","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"6","amount":"458000","created_by":1005,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-12-12 13:39:18","updated_at":"2025-05-16 16:54:30","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1407,"serial_no":"XSDD-20241212-00001","from_date":null,"wrote_date":"2024-11-29","handler":1005,"client_id":93,"purchase_contract_id":null,"project_id":3699,"sales_contract_id":3705,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-05-16 16:54:30","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"6","amount":"458000","created_by":1005,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-12-12 13:39:18","updated_at":"2025-05-16 16:54:30","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3699,"key":3699,"name":"\u7b2c\u4e8c\u56ed\u533a\u65b0\u8d2d\u51fa\u53e3\u9632\u706b\u5899-\u98de\u5854","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":802,"bargain_date":"2024-11-29","collected":"458000","profit_pct":"11.13","budget":"458000","erpSalesOrder":{"id":1407,"serial_no":"XSDD-20241212-00001","from_date":null,"wrote_date":"2024-11-29","handler":1005,"client_id":93,"purchase_contract_id":null,"project_id":3699,"sales_contract_id":3705,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-05-16 16:54:30","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"6","amount":"458000","created_by":1005,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-12-12 13:39:18","updated_at":"2025-05-16 16:54:30","print_times":null},"projectProductTypes":[{"id":5845,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"458000.00","pct":"11.13","project_id":3699,"profit":"50975.4"}],"projectProductRels":[{"id":8952,"project_id":3699,"product_id":1625,"amount":"72983.00","number":2,"cost":"62866.00","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"145966","total_cost":"125732","erp_sales_order_product_id":1434,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1625,"name":"FG-401F","product_type":5,"product_component":26,"product_brand":40,"product_serie":1383,"product_misc":null,"product_qa":null,"pn":"","description":"FG-401F 18 x GE RJ45 ports (including 1 x MGMT port, 1 X HA port, 16 x switch ports), 8 x GE SFP slots, 8 x 10GE SFP+ slots, SPU NP7 and CP9 hardware accelerated, 960GB onboard SSD storage, dual AC power supplies","created_by":1013,"created_at":"2024-05-31 16:02:22","updated_at":"2024-05-31 16:02:22","pinyin_shortcut":"FG401F","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1383,"key":1383,"name":"FG-401F\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1434,"erp_sales_order_id":1407,"erp_store_id":null,"product_id":1625,"description":"","number":"2","outbound":"0","amount":"72983.00","total_amount":"145966","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"62866.00","total_cost":"125732","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":8953,"project_id":3699,"product_id":1626,"amount":"153265.00","number":2,"cost":"131830.00","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"306530","total_cost":"263660","erp_sales_order_product_id":1435,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1626,"name":"FC-10-0401F-950-02-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":1384,"product_misc":null,"product_qa":null,"pn":"","description":"FG-401F Unified Threat Protection (UTP) (IPS, Advanced Malware Protection, Application Control, URL, DNS & Video Filtering, Antispam Service, and FortiCare Premium) -3Year","created_by":1013,"created_at":"2024-05-31 16:04:08","updated_at":"2024-05-31 16:04:08","pinyin_shortcut":"FC100401F9500236","product_unit":2,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1384,"key":1384,"name":"FG-401F\u9632\u706b\u5899\u4e09\u5e74\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1435,"erp_sales_order_id":1407,"erp_store_id":null,"product_id":1626,"description":"","number":"2","outbound":"0","amount":"153265.00","total_amount":"306530","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"131830.00","total_cost":"263660","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":8954,"project_id":3699,"product_id":941,"amount":"5504.00","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"5504","total_cost":"0","erp_sales_order_product_id":1436,"supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2026-02-05 16:37:56","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-02-05 16:37:56.557723+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1436,"erp_sales_order_id":1407,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"0","amount":"5504.00","total_amount":"5504","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":8955,"project_id":3699,"product_id":942,"amount":"0","number":1,"cost":"31000.00","description":"","supplier_id":534,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"31000","erp_sales_order_product_id":1437,"supplier":{"id":534,"key":534,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"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":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2026-01-28 10:32:39","pinyin_shortcut":"dsfwcjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-01-28 10:32:39.333577+08","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"}},"erpSalesOrderProduct":{"id":1437,"erp_sales_order_id":1407,"erp_store_id":null,"product_id":942,"description":"","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"31000.00","total_cost":"31000","supplier_id":534,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12463,"project_id":3699},{"id":12465,"project_id":3699},{"id":12464,"project_id":3699},{"id":12467,"project_id":3699},{"id":12466,"project_id":3699},{"id":12704,"project_id":3699}],"reimbursementAmountSum":{"project_id":3699,"sum":"137"},"profit":50975.4,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":2529,"contract_id":3705,"supplier_id":534,"purchase_id":3817,"supplier":{"id":534,"key":534,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3817,"key":3817,"serial_no":"2025022801-TSZHY5"}},{"id":2300,"contract_id":3705,"supplier_id":614,"purchase_id":3723,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3723,"key":3723,"serial_no":"BQ-S-2024-12-07-P"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7638,"user_id":1005,"key":1005,"contract_id":3705,"user":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},{"id":7640,"user_id":1001,"key":1001,"contract_id":3705,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2254,"key":2254,"contract_id":3705,"name":"2025-02-28","value":"458000","overdue_days":77,"status":1,"remind_date":"2025-02-28","pct":100,"overdue_display":"\u903e\u671f77\u5929"}],"salesContractPayments":[{"id":"1328","key":"1328","contract_id":3705,"value":"458000","created_by":1013,"created_at":"2025-05-16 16:54:30","description":null,"collected_date":"2025-05-16 00:00:00","amount":"458000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2018,"key":2018,"contract_id":3705,"value":"458000.00","attachment_id":null,"from_date":"2025-04-27","description":"","is_draft":false,"is_cancel":true,"salesInvoiceAmounts":[{"id":3069,"sales_invoice_id":2018,"amount":"452496","tax_rate":"13"},{"id":3070,"sales_invoice_id":2018,"amount":"5504","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":33824,"object_type":102,"object_id":2018,"attachment_id":25331,"attachment":{"id":25331,"key":25331,"name":"067a7ce5-fa89-316b-983f-3b2c7814e96d","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/067a7ce5-fa89-316b-983f-3b2c7814e96d\/dzfp_25112000000085883336_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8_20250427145552.pdf","orig_name":"dzfp_25112000000085883336_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8_20250427145552.pdf"}}]},{"id":2024,"key":2024,"contract_id":3705,"value":"-458000.00","attachment_id":null,"from_date":"2025-04-29","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":3005,"sales_invoice_id":2024,"amount":"-452496","tax_rate":"13"},{"id":3006,"sales_invoice_id":2024,"amount":"-5504","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":33871,"object_type":102,"object_id":2024,"attachment_id":25368,"attachment":{"id":25368,"key":25368,"name":"15a8022d-3b80-3d9d-ad68-90c3e463a335","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/15a8022d-3b80-3d9d-ad68-90c3e463a335\/dzfp_25112000000084956850_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8_20250429101559.pdf","orig_name":"dzfp_25112000000084956850_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8_20250429101559.pdf"}}]},{"id":2025,"key":2025,"contract_id":3705,"value":"458000.00","attachment_id":null,"from_date":"2025-04-28","description":"","is_draft":false,"is_cancel":true,"salesInvoiceAmounts":[{"id":3049,"sales_invoice_id":2025,"amount":"452496","tax_rate":"13"},{"id":3050,"sales_invoice_id":2025,"amount":"5504","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":33872,"object_type":102,"object_id":2025,"attachment_id":25369,"attachment":{"id":25369,"key":25369,"name":"b623e184-4069-3b1e-8b7b-1e8c5f623294","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/b623e184-4069-3b1e-8b7b-1e8c5f623294\/dzfp_25112000000087089773_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8_20250428180346.pdf","orig_name":"dzfp_25112000000087089773_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8_20250428180346.pdf"}}]},{"id":2028,"key":2028,"contract_id":3705,"value":"-458000.00","attachment_id":null,"from_date":"2025-04-30","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":3021,"sales_invoice_id":2028,"amount":"-452496","tax_rate":"13"},{"id":3022,"sales_invoice_id":2028,"amount":"-5504","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":33923,"object_type":102,"object_id":2028,"attachment_id":25408,"attachment":{"id":25408,"key":25408,"name":"8a601662-6ec6-30af-981f-9af2cd677fd2","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/8a601662-6ec6-30af-981f-9af2cd677fd2\/dzfp_25112000000088243009_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8_20250430153315.pdf","orig_name":"dzfp_25112000000088243009_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8_20250430153315.pdf"}}]},{"id":2029,"key":2029,"contract_id":3705,"value":"458000.00","attachment_id":null,"from_date":"2025-04-30","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":2893,"sales_invoice_id":2029,"amount":"458000","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":31512,"object_type":105,"object_id":3705,"attachment_id":23140,"attachment":{"id":23140,"key":23140,"name":"221be467-2e34-378b-a893-1dc8bbcc49c3","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/221be467-2e34-378b-a893-1dc8bbcc49c3\/\u5eb7\u9f99\u5316\u6210.pdf","orig_name":"\u5eb7\u9f99\u5316\u6210.pdf"}}],"receiptScans":[{"id":33825,"object_type":106,"object_id":3705,"attachment_id":23652,"attachment":{"id":23652,"key":23652,"name":"a0dbfb7d-deaa-30cb-ac43-f293a9cd8d43","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/a0dbfb7d-deaa-30cb-ac43-f293a9cd8d43\/\u9632\u706b\u5899.pdf","orig_name":"\u9632\u706b\u5899.pdf"}}],"verifyScans":[{"id":33826,"object_type":107,"object_id":3705,"attachment_id":25332,"attachment":{"id":25332,"key":25332,"name":"bac7e3d9-59f3-325b-bf16-1e79aab93f2c","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/bac7e3d9-59f3-325b-bf16-1e79aab93f2c\/\u98de\u5854\u9632\u706b\u5899\u9a8c\u8bc1\u62a5\u544a.pdf","orig_name":"\u98de\u5854\u9632\u706b\u5899\u9a8c\u8bc1\u62a5\u544a.pdf"}}],"unreadComments":null,"collected_plan":458000,"projectProductTotalAmount":458000,"projectProductAllAmount":true,"projectProductTotalCost":420392,"projectProductAllCost":true,"projectProductTotalCount":6,"invoiced":"458000.00","un_invoiced":0,"collected":"458000","un_collected":0,"is_collected":true,"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":0},{"id":3679,"client_id":93,"signed_at":"2024-11-21","amount":"550000","handler":1005,"description":"","created_by":1005,"created_at":"2024-11-29 11:35:53","updated_at":"2025-04-22 10:01:24","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3700,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-ZHY-2024112101","payment_collection_remind_ahead":"7 days","from_project":3700,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2024-12-30 11:27:13","is_verify":false,"is_draft":false,"erp_settle_amount":"550000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"550000","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3679,"comment":10},"project":{"id":3700,"key":3700,"name":"ADME \u5b9e\u9a8c\u5ba4\u5907\u4efd\u66ff\u6362","erpSalesOrder":{"id":1394,"serial_no":"XSDD-20241129-00002","from_date":null,"wrote_date":"2024-11-21","handler":1005,"client_id":93,"purchase_contract_id":null,"project_id":3700,"sales_contract_id":3679,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-04-17 17:16:20","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"48","amount":"550000","created_by":1005,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-11-29 11:35:53","updated_at":"2025-04-17 17:16:20","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1394,"serial_no":"XSDD-20241129-00002","from_date":null,"wrote_date":"2024-11-21","handler":1005,"client_id":93,"purchase_contract_id":null,"project_id":3700,"sales_contract_id":3679,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-04-17 17:16:20","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"48","amount":"550000","created_by":1005,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-11-29 11:35:53","updated_at":"2025-04-17 17:16:20","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3700,"key":3700,"name":"ADME \u5b9e\u9a8c\u5ba4\u5907\u4efd\u66ff\u6362","description":"","total_contact_point":"100000","paid_contact_point":"100000","is_sales_order_ready":true,"project_product_version_id":723,"bargain_date":"2024-11-21","collected":"550000","profit_pct":"5.21","budget":"550000","erpSalesOrder":{"id":1394,"serial_no":"XSDD-20241129-00002","from_date":null,"wrote_date":"2024-11-21","handler":1005,"client_id":93,"purchase_contract_id":null,"project_id":3700,"sales_contract_id":3679,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-04-17 17:16:20","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"48","amount":"550000","created_by":1005,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-11-29 11:35:53","updated_at":"2025-04-17 17:16:20","print_times":null},"projectProductTypes":[{"id":6248,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"550000.00","pct":"5.21","project_id":3700,"profit":"28655"}],"projectProductRels":[{"id":9250,"project_id":3700,"product_id":899,"amount":"170000.00","number":2,"cost":"131500.00","description":"","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null,"total_amount":"340000","total_cost":"263000","erp_sales_order_product_id":1395,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":899,"name":"HD6500","product_type":3,"product_component":14,"product_brand":27,"product_serie":563,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-03-08 14:51:14","updated_at":"2024-01-16 11:50:50","pinyin_shortcut":"HD6500","product_unit":1,"is_renew":false,"in_out_at":null,"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":563,"key":563,"name":"HD6500 NAS\u5b58\u50a8"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1395,"erp_sales_order_id":1394,"erp_store_id":null,"product_id":899,"description":"","number":"2","outbound":"0","amount":"170000.00","total_amount":"340000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"131500.00","total_cost":"263000","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null}},{"id":9251,"project_id":3700,"product_id":900,"amount":"4800.00","number":26,"cost":"3710.00","description":"","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null,"total_amount":"124800","total_cost":"96460","erp_sales_order_product_id":1396,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":900,"name":"HAS5300-16T","product_type":3,"product_component":15,"product_brand":27,"product_serie":564,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-03-08 14:56:07","updated_at":"2024-01-16 13:48:58","pinyin_shortcut":"HAS530016T","product_unit":4,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":564,"key":564,"name":"16TB 7.2K 3.5 SAS\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":1396,"erp_sales_order_id":1394,"erp_store_id":null,"product_id":900,"description":"","number":"26","outbound":"0","amount":"4800.00","total_amount":"124800","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"3710.00","total_cost":"96460","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null}},{"id":9252,"project_id":3700,"product_id":1886,"amount":"5650.00","number":2,"cost":"5305.00","description":"","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null,"total_amount":"11300","total_cost":"10610","erp_sales_order_product_id":1397,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":1886,"name":"D4ER01-32G","product_type":3,"product_component":39,"product_brand":27,"product_serie":1577,"product_misc":null,"product_qa":null,"pn":"","description":"\u7fa4\u665632GB\u5185\u5b58","created_by":1013,"created_at":"2024-12-03 15:31:33","updated_at":"2024-12-03 15:31:33","pinyin_shortcut":"D4ER0132G","product_unit":6,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1577,"key":1577,"name":"\u5b58\u50a8\u5185\u5b58"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":{"id":1397,"erp_sales_order_id":1394,"erp_store_id":null,"product_id":1886,"description":"","number":"2","outbound":"0","amount":"5650.00","total_amount":"11300","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"5305.00","total_cost":"10610","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null}},{"id":9253,"project_id":3700,"product_id":220,"amount":"200.00","number":4,"cost":"70.00","description":"","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null,"total_amount":"800","total_cost":"280","erp_sales_order_product_id":1398,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":220,"name":"46C3447","product_type":4,"product_component":43,"product_brand":4,"product_serie":1127,"product_misc":8,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-06-16 09:28:20","updated_at":"2024-02-01 11:07:29","pinyin_shortcut":"46C3447","product_unit":3,"is_renew":false,"in_out_at":null,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1127,"key":1127,"name":"\u8054\u60f346C3447\u4e07\u5146\u591a\u6a21SFP+\u5149\u7ea4\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1398,"erp_sales_order_id":1394,"erp_store_id":null,"product_id":220,"description":"","number":"4","outbound":"0","amount":"200.00","total_amount":"800","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"70.00","total_cost":"280","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null}},{"id":9254,"project_id":3700,"product_id":941,"amount":"9020.00","number":1,"cost":"0","description":"","supplier_id":68,"hardware_from":null,"software_from":null,"maintenance_from":"2024-12-27","hardware_to":null,"software_to":null,"maintenance_to":"2029-12-27","total_amount":"9020","total_cost":"0","erp_sales_order_product_id":1399,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2026-02-05 16:37:56","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-02-05 16:37:56.557723+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1399,"erp_sales_order_id":1394,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"0","amount":"9020.00","total_amount":"9020","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":68,"hardware_from":null,"software_from":null,"maintenance_from":"2024-12-27","hardware_to":null,"software_to":null,"maintenance_to":"2029-12-27"}},{"id":9255,"project_id":3700,"product_id":941,"amount":"9000.00","number":5,"cost":"0","description":"","supplier_id":68,"hardware_from":null,"software_from":null,"maintenance_from":"2024-12-27","hardware_to":null,"software_to":null,"maintenance_to":"2029-12-27","total_amount":"45000","total_cost":"0","erp_sales_order_product_id":1400,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2026-02-05 16:37:56","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-02-05 16:37:56.557723+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1400,"erp_sales_order_id":1394,"erp_store_id":null,"product_id":941,"description":"","number":"5","outbound":"0","amount":"9000.00","total_amount":"45000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":68,"hardware_from":null,"software_from":null,"maintenance_from":"2024-12-27","hardware_to":null,"software_to":null,"maintenance_to":"2029-12-27"}},{"id":9256,"project_id":3700,"product_id":1906,"amount":"945.00","number":4,"cost":"885.00","description":"","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null,"total_amount":"3780","total_cost":"3540","erp_sales_order_product_id":1401,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":1906,"name":"E10G18-T1","product_type":3,"product_component":39,"product_brand":27,"product_serie":1578,"product_misc":null,"product_qa":null,"pn":"","description":"\u5355\u7aef\u53e310G\u7535\u53e3\u7f51\u5361","created_by":1013,"created_at":"2024-12-24 15:38:55","updated_at":"2024-12-24 15:38:55","pinyin_shortcut":"E10G18T1","product_unit":3,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1578,"key":1578,"name":"\u5b58\u50a8\u9002\u914d\u5361"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1401,"erp_sales_order_id":1394,"erp_store_id":null,"product_id":1906,"description":"","number":"4","outbound":"0","amount":"945.00","total_amount":"3780","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"885.00","total_cost":"3540","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null}},{"id":9257,"project_id":3700,"product_id":1907,"amount":"2000.00","number":2,"cost":"1655.00","description":"","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null,"total_amount":"4000","total_cost":"3310","erp_sales_order_product_id":1402,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":1907,"name":"E10G30-F2","product_type":3,"product_component":39,"product_brand":27,"product_serie":1578,"product_misc":null,"product_qa":null,"pn":"","description":"\u53cc\u7aef\u53e310G SFP+\u7f51\u5361","created_by":1013,"created_at":"2024-12-24 15:39:26","updated_at":"2024-12-24 15:39:26","pinyin_shortcut":"E10G30F2","product_unit":3,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1578,"key":1578,"name":"\u5b58\u50a8\u9002\u914d\u5361"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1402,"erp_sales_order_id":1394,"erp_store_id":null,"product_id":1907,"description":"","number":"2","outbound":"0","amount":"2000.00","total_amount":"4000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"1655.00","total_cost":"3310","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null}},{"id":9258,"project_id":3700,"product_id":1886,"amount":"5650.00","number":2,"cost":"0","description":"\u5e93\u5b58\u4ea7\u54c1","supplier_id":null,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null,"total_amount":"11300","total_cost":"0","erp_sales_order_product_id":1403,"supplier":null,"product":{"id":1886,"name":"D4ER01-32G","product_type":3,"product_component":39,"product_brand":27,"product_serie":1577,"product_misc":null,"product_qa":null,"pn":"","description":"\u7fa4\u665632GB\u5185\u5b58","created_by":1013,"created_at":"2024-12-03 15:31:33","updated_at":"2024-12-03 15:31:33","pinyin_shortcut":"D4ER0132G","product_unit":6,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1577,"key":1577,"name":"\u5b58\u50a8\u5185\u5b58"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":{"id":1403,"erp_sales_order_id":1394,"erp_store_id":null,"product_id":1886,"description":"\u5e93\u5b58\u4ea7\u54c1","number":"2","outbound":"0","amount":"5650.00","total_amount":"11300","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null}}],"projectContactPoints":[{"id":957,"project_id":3700,"contact_id":4701,"point":"100000.00","paid_point":"100000","contact":{"id":4701,"key":4701,"name":"\u5218\u6653\u51cc","client_id":93,"supplier_id":null,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":189,"project_id":3700,"contact_id":4701,"point":"100000.00","day_at":"2025-04-22","description":"\u73b0\u91d1\u4ea4\u4e8e\u8d75\u6657\u7131\u672c\u4eba","created_at":"2025-04-22 10:01:24"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":12416,"project_id":3700},{"id":12417,"project_id":3700},{"id":12430,"project_id":3700},{"id":12431,"project_id":3700},{"id":12425,"project_id":3700},{"id":12424,"project_id":3700},{"id":12459,"project_id":3700},{"id":12458,"project_id":3700},{"id":12457,"project_id":3700},{"id":12456,"project_id":3700},{"id":12455,"project_id":3700},{"id":12454,"project_id":3700},{"id":12453,"project_id":3700},{"id":12452,"project_id":3700},{"id":12451,"project_id":3700},{"id":12450,"project_id":3700},{"id":12449,"project_id":3700},{"id":12448,"project_id":3700},{"id":12447,"project_id":3700},{"id":12446,"project_id":3700},{"id":12445,"project_id":3700},{"id":12444,"project_id":3700},{"id":12443,"project_id":3700},{"id":12442,"project_id":3700},{"id":12441,"project_id":3700},{"id":12440,"project_id":3700},{"id":12439,"project_id":3700},{"id":12438,"project_id":3700},{"id":12437,"project_id":3700},{"id":12436,"project_id":3700},{"id":12435,"project_id":3700},{"id":12434,"project_id":3700},{"id":12433,"project_id":3700},{"id":12432,"project_id":3700},{"id":12423,"project_id":3700},{"id":12422,"project_id":3700},{"id":12421,"project_id":3700},{"id":12420,"project_id":3700},{"id":12419,"project_id":3700},{"id":12418,"project_id":3700},{"id":12428,"project_id":3700},{"id":12427,"project_id":3700},{"id":12426,"project_id":3700},{"id":12429,"project_id":3700}],"reimbursementAmountSum":{"project_id":3700,"sum":"3065.63"},"profit":28655,"contact_points_status_display":"\u5df2\u6838\u9500","total_contact_paid_point":100000,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":2604,"contract_id":3679,"supplier_id":68,"purchase_id":3687,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":3687,"key":3687,"serial_no":"BJ7067IM202401203-01"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8255,"user_id":1005,"key":1005,"contract_id":3679,"user":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},{"id":8257,"user_id":1001,"key":1001,"contract_id":3679,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2252,"key":2252,"contract_id":3679,"name":"2025-01-31","value":"550000","overdue_days":76,"status":1,"remind_date":"2025-01-31","pct":100,"overdue_display":"\u903e\u671f76\u5929"}],"salesContractPayments":[{"id":"1293","key":"1293","contract_id":3679,"value":"550000","created_by":1013,"created_at":"2025-04-17 17:16:20","description":null,"collected_date":"2025-04-17 00:00:00","amount":"550000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1931,"key":1931,"contract_id":3679,"value":"550000.00","attachment_id":null,"from_date":"2025-01-09","description":"","is_draft":false,"is_cancel":true,"salesInvoiceAmounts":[{"id":3039,"sales_invoice_id":1931,"amount":"495980","tax_rate":"13"},{"id":3040,"sales_invoice_id":1931,"amount":"54020","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":31662,"object_type":102,"object_id":1931,"attachment_id":23610,"attachment":{"id":23610,"key":23610,"name":"08b34e4a-aa2b-3786-8326-8c26c9ca0d11","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/08b34e4a-aa2b-3786-8326-8c26c9ca0d11\/dzfp_25112000000007071218_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8_20250109152827.pdf","orig_name":"dzfp_25112000000007071218_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8_20250109152827.pdf"}}]},{"id":2010,"key":2010,"contract_id":3679,"value":"-550000.00","attachment_id":null,"from_date":"2025-04-10","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":2999,"sales_invoice_id":2010,"amount":"-495980","tax_rate":"13"},{"id":3000,"sales_invoice_id":2010,"amount":"-54020","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":33472,"object_type":102,"object_id":2010,"attachment_id":25037,"attachment":{"id":25037,"key":25037,"name":"cc80ff97-7c13-35e2-9cab-325724bf91f4","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/cc80ff97-7c13-35e2-9cab-325724bf91f4\/dzfp_25112000000071477663_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8_20250410110632.pdf","orig_name":"dzfp_25112000000071477663_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8_20250410110632.pdf"}}]},{"id":2011,"key":2011,"contract_id":3679,"value":"550000.00","attachment_id":null,"from_date":"2025-04-10","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":566,"sales_invoice_id":2011,"amount":"550000","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":33473,"object_type":102,"object_id":2011,"attachment_id":25038,"attachment":{"id":25038,"key":25038,"name":"db339989-4727-39de-8a23-145b5f89b80b","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/db339989-4727-39de-8a23-145b5f89b80b\/dzfp_25112000000072095200_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8_20250410105952.pdf","orig_name":"dzfp_25112000000072095200_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8_20250410105952.pdf"}}]}],"contractScans":[{"id":33719,"object_type":105,"object_id":3679,"attachment_id":22964,"attachment":{"id":22964,"key":22964,"name":"779fa961-1727-3dd3-a93f-3e0fdd79d44a","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/779fa961-1727-3dd3-a93f-3e0fdd79d44a\/\u5eb7\u9f99\u5316\u6210.pdf","orig_name":"\u5eb7\u9f99\u5316\u6210.pdf"}}],"receiptScans":[{"id":31724,"object_type":106,"object_id":3679,"attachment_id":23653,"attachment":{"id":23653,"key":23653,"name":"5db488b9-8429-3f03-9446-f1ea5a5dcf03","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/5db488b9-8429-3f03-9446-f1ea5a5dcf03\/\u7fa4\u6656.pdf","orig_name":"\u7fa4\u6656.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":550000,"projectProductTotalAmount":550000,"projectProductAllAmount":true,"projectProductTotalCost":377200,"projectProductAllCost":true,"projectProductTotalCount":48,"invoiced":"550000.00","un_invoiced":0,"collected":"550000","un_collected":0,"is_collected":true,"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":0},{"id":3325,"client_id":93,"signed_at":"2024-05-14","amount":"2630000","handler":1005,"description":"","created_by":1005,"created_at":"2024-05-31 11:50:54","updated_at":"2024-09-30 11:27:26","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3417,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"7 days","expire_remind_ahead":"","expire_reminded":false,"serial_no":"C202405150012","payment_collection_remind_ahead":"7 days","from_project":3417,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2024-07-28 23:11:21","is_verify":false,"is_draft":false,"erp_settle_amount":"2630000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"2630000","receipt_scan_uploaded":true,"verify_scan_uploaded":true,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3325,"comment":23},"project":{"id":3417,"key":3417,"name":"\u8fb9\u754c\u9632\u706b\u5899\u66ff\u6362","erpSalesOrder":{"id":1253,"serial_no":"XSDD-20240531-00001","from_date":null,"wrote_date":"2024-05-14","handler":1005,"client_id":93,"purchase_contract_id":null,"project_id":3417,"sales_contract_id":3325,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-01-07 16:51:14","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"53","amount":"2630000","created_by":1005,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-05-31 11:50:54","updated_at":"2025-01-07 16:51:14","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1253,"serial_no":"XSDD-20240531-00001","from_date":null,"wrote_date":"2024-05-14","handler":1005,"client_id":93,"purchase_contract_id":null,"project_id":3417,"sales_contract_id":3325,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-01-07 16:51:14","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"53","amount":"2630000","created_by":1005,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-05-31 11:50:54","updated_at":"2025-01-07 16:51:14","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3417,"key":3417,"name":"\u8fb9\u754c\u9632\u706b\u5899\u66ff\u6362","description":"","total_contact_point":"100000","paid_contact_point":"100000","is_sales_order_ready":true,"project_product_version_id":467,"bargain_date":"2024-05-14","collected":"2630000","profit_pct":"14.16","budget":"2630000","erpSalesOrder":{"id":1253,"serial_no":"XSDD-20240531-00001","from_date":null,"wrote_date":"2024-05-14","handler":1005,"client_id":93,"purchase_contract_id":null,"project_id":3417,"sales_contract_id":3325,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-01-07 16:51:14","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"53","amount":"2630000","created_by":1005,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-05-31 11:50:54","updated_at":"2025-01-07 16:51:14","print_times":null},"projectProductTypes":[{"id":5009,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"2630000","pct":"14.16","project_id":3417,"profit":"372408"}],"projectProductRels":[{"id":6556,"project_id":3417,"product_id":1625,"amount":"72983","number":4,"cost":"62866","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"291932","total_cost":"251464","erp_sales_order_product_id":909,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1625,"name":"FG-401F","product_type":5,"product_component":26,"product_brand":40,"product_serie":1383,"product_misc":null,"product_qa":null,"pn":"","description":"FG-401F 18 x GE RJ45 ports (including 1 x MGMT port, 1 X HA port, 16 x switch ports), 8 x GE SFP slots, 8 x 10GE SFP+ slots, SPU NP7 and CP9 hardware accelerated, 960GB onboard SSD storage, dual AC power supplies","created_by":1013,"created_at":"2024-05-31 16:02:22","updated_at":"2024-05-31 16:02:22","pinyin_shortcut":"FG401F","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1383,"key":1383,"name":"FG-401F\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":909,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1625,"description":"","number":"4","outbound":"0","amount":"72983","total_amount":"291932","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"62866","total_cost":"251464","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6557,"project_id":3417,"product_id":1626,"amount":"153265","number":4,"cost":"131830","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"613060","total_cost":"527320","erp_sales_order_product_id":910,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1626,"name":"FC-10-0401F-950-02-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":1384,"product_misc":null,"product_qa":null,"pn":"","description":"FG-401F Unified Threat Protection (UTP) (IPS, Advanced Malware Protection, Application Control, URL, DNS & Video Filtering, Antispam Service, and FortiCare Premium) -3Year","created_by":1013,"created_at":"2024-05-31 16:04:08","updated_at":"2024-05-31 16:04:08","pinyin_shortcut":"FC100401F9500236","product_unit":2,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1384,"key":1384,"name":"FG-401F\u9632\u706b\u5899\u4e09\u5e74\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":910,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1626,"description":"","number":"4","outbound":"0","amount":"153265","total_amount":"613060","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"131830","total_cost":"527320","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6558,"project_id":3417,"product_id":1627,"amount":"34288","number":1,"cost":"42091","description":"\u5408\u540c\u4f18\u60e030101","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"34288","total_cost":"42091","erp_sales_order_product_id":911,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1627,"name":"FG-400E","product_type":5,"product_component":26,"product_brand":40,"product_serie":1385,"product_misc":null,"product_qa":null,"pn":"","description":"18 x GE RJ45 ports (including 1 x MGMT port, 1 X HA port, 16 x switch ports), 16 x GE SFP slots, SPU NP6 and CP9 hardware accelerated\n\u5e76\u53d1 SSL VPN \u7528\u6237\uff08\u5efa\u8bae\u7684\u6700\u5927\u6570\u91cf\uff0c\u96a7\u9053\u6a21\u5f0f\uff09\uff1a5000\u4eba","created_by":1013,"created_at":"2024-05-31 16:05:08","updated_at":"2024-05-31 16:05:08","pinyin_shortcut":"FG400E","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1385,"key":1385,"name":"FG-400E\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":911,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1627,"description":"\u5408\u540c\u4f18\u60e030101","number":"1","outbound":"0","amount":"34288","total_amount":"34288","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"42091","total_cost":"42091","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6559,"project_id":3417,"product_id":1628,"amount":"22472","number":1,"cost":"25254","description":"\u5408\u540c\u4f18\u60e030101","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"22472","total_cost":"25254","erp_sales_order_product_id":912,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1628,"name":"FC-10-0400E-247-02-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":1386,"product_misc":null,"product_qa":null,"pn":"","description":"FortiCare Premium Support - 3Year","created_by":1013,"created_at":"2024-05-31 16:06:10","updated_at":"2024-05-31 16:06:10","pinyin_shortcut":"FC100400E2470236","product_unit":8,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1386,"key":1386,"name":"FG-400E\u4e09\u5e74\u539f\u5382\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":912,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1628,"description":"\u5408\u540c\u4f18\u60e030101","number":"1","outbound":"0","amount":"22472","total_amount":"22472","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"25254","total_cost":"25254","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6560,"project_id":3417,"product_id":1629,"amount":"31677","number":6,"cost":"27311","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"190062","total_cost":"163866","erp_sales_order_product_id":913,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1629,"name":"FG-201F","product_type":5,"product_component":26,"product_brand":40,"product_serie":1387,"product_misc":null,"product_qa":null,"pn":"","description":"FG-201F 18 x GE RJ45 (including 1 x MGMT port, 1 X HA port, 16 x switch ports), 8 x GE SFP slots, 4 x 10GE SFP+ slots, NP6XLite and CP9 hardware accelerated, 480GB onboard SSD storage","created_by":1013,"created_at":"2024-05-31 16:06:57","updated_at":"2024-05-31 16:06:57","pinyin_shortcut":"FG201F","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1387,"key":1387,"name":"FG-201F\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":913,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1629,"description":"","number":"6","outbound":"0","amount":"31677","total_amount":"190062","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"27311","total_cost":"163866","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6561,"project_id":3417,"product_id":1630,"amount":"66521","number":6,"cost":"57322","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"399126","total_cost":"343932","erp_sales_order_product_id":914,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1630,"name":"FC-10-F201F-950-02-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":1388,"product_misc":null,"product_qa":null,"pn":"","description":"FG-201F Unified Threat Protection (UTP) (IPS, Advanced Malware Protection, Application Control, URL, DNS & Video Filtering, Antispam Service, and FortiCare Premium) -3Year","created_by":1013,"created_at":"2024-05-31 16:08:03","updated_at":"2024-05-31 16:08:03","pinyin_shortcut":"FC10F201F9500236","product_unit":2,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1388,"key":1388,"name":"FG-201F\u9632\u706b\u5899\u4e09\u5e74\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":914,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1630,"description":"","number":"6","outbound":"0","amount":"66521","total_amount":"399126","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"57322","total_cost":"343932","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6562,"project_id":3417,"product_id":1631,"amount":"16398","number":8,"cost":"14124","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"131184","total_cost":"112992","erp_sales_order_product_id":915,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1631,"name":"FG-121G","product_type":5,"product_component":26,"product_brand":40,"product_serie":1389,"product_misc":null,"product_qa":null,"pn":"","description":"FG-121G 18 x GE RJ45 ports (including 1 x MGMT port, 1 X HA port, 16 x switch ports), 8 x GE SFP slots, 4 x 10GE SFP+ slots, SP5 hardware accelerated, 480GB onboard SSD storage, dual AC power supplies","created_by":1013,"created_at":"2024-05-31 16:08:45","updated_at":"2024-05-31 16:08:45","pinyin_shortcut":"FG121G","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1389,"key":1389,"name":"FG-121G\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":915,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1631,"description":"","number":"8","outbound":"0","amount":"16398","total_amount":"131184","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"14124","total_cost":"112992","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6563,"project_id":3417,"product_id":1632,"amount":"34435","number":8,"cost":"29661","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"275480","total_cost":"237288","erp_sales_order_product_id":916,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1632,"name":"FC-10-F121G-950-02-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":1390,"product_misc":null,"product_qa":null,"pn":"","description":"FG-121G Unified Threat Protection (UTP) (IPS, Advanced Malware Protection, Application Control, URL, DNS & Video Filtering, Antispam Service, and FortiCare Premium) -3Year","created_by":1013,"created_at":"2024-05-31 16:09:37","updated_at":"2024-05-31 16:09:37","pinyin_shortcut":"FC10F121G9500236","product_unit":2,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1390,"key":1390,"name":"FG-121G\u9632\u706b\u5899\u4e09\u5e74\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":916,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1632,"description":"","number":"8","outbound":"0","amount":"34435","total_amount":"275480","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"29661","total_cost":"237288","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6564,"project_id":3417,"product_id":1633,"amount":"9824","number":1,"cost":"8475","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"9824","total_cost":"8475","erp_sales_order_product_id":917,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1633,"name":"FG-81F","product_type":5,"product_component":26,"product_brand":40,"product_serie":1391,"product_misc":null,"product_qa":null,"pn":"","description":"FG-81F 8 x GE RJ45 ports, 2 x RJ45\/SFP shared media WAN ports, 128GB SSD","created_by":1013,"created_at":"2024-05-31 16:10:29","updated_at":"2024-05-31 16:10:29","pinyin_shortcut":"FG81F","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1391,"key":1391,"name":"FG-81F\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":917,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1633,"description":"","number":"1","outbound":"0","amount":"9824","total_amount":"9824","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"8475","total_cost":"8475","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6565,"project_id":3417,"product_id":1634,"amount":"18569","number":1,"cost":"16008","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"18569","total_cost":"16008","erp_sales_order_product_id":918,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1634,"name":"FC-10-0081F-950-02-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":1392,"product_misc":null,"product_qa":null,"pn":"","description":"FG-81F Unified Threat Protection (UTP) (IPS, Advanced Malware Protection, Application Control, URL, DNS & Video Filtering, Antispam Service, and FortiCare Premium)-3Year","created_by":1013,"created_at":"2024-05-31 16:11:05","updated_at":"2024-05-31 16:11:05","pinyin_shortcut":"FC100081F9500236","product_unit":2,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1392,"key":1392,"name":"FG-81F\u9632\u706b\u5899\u4e09\u5e74\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":918,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1634,"description":"","number":"1","outbound":"0","amount":"18569","total_amount":"18569","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"16008","total_cost":"16008","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6566,"project_id":3417,"product_id":1635,"amount":"4448","number":3,"cost":"3884","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"13344","total_cost":"11652","erp_sales_order_product_id":919,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1635,"name":"FG-61F","product_type":5,"product_component":26,"product_brand":40,"product_serie":1393,"product_misc":null,"product_qa":null,"pn":"","description":"FG-61F 10 x GE RJ45 ports (including 2 x WAN Ports, 1 x DMZ Port, 7 x Internal Ports), 128GB SSD onboard storage","created_by":1013,"created_at":"2024-05-31 16:11:43","updated_at":"2024-05-31 16:11:43","pinyin_shortcut":"FG61F","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1393,"key":1393,"name":"FG-61F\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":919,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1635,"description":"","number":"3","outbound":"0","amount":"4448","total_amount":"13344","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"3884","total_cost":"11652","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6567,"project_id":3417,"product_id":1636,"amount":"8408","number":3,"cost":"7297","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"25224","total_cost":"21891","erp_sales_order_product_id":920,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1636,"name":"FC-10-0061F-950-02-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":1394,"product_misc":null,"product_qa":null,"pn":"","description":"FG-61F Unified Threat Protection (UTP) (IPS, Advanced Malware Protection, Application Control, URL, DNS & Video Filtering, Antispam Service, and FortiCare Premium)-3Year","created_by":1013,"created_at":"2024-05-31 16:12:19","updated_at":"2024-05-31 16:12:19","pinyin_shortcut":"FC100061F9500236","product_unit":2,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1394,"key":1394,"name":"FG-61F\u9632\u706b\u5899\u4e09\u5e74\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":920,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1636,"description":"","number":"3","outbound":"0","amount":"8408","total_amount":"25224","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"7297","total_cost":"21891","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6568,"project_id":3417,"product_id":1637,"amount":"6941","number":3,"cost":"5414","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"20823","total_cost":"16242","erp_sales_order_product_id":921,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1637,"name":"FC1-10-FMGVS-258-01-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":338,"product_misc":null,"product_qa":null,"pn":"","description":"FortiManager-VM Subscription License with Support 3 Year Subscription license for 10 devices\/vdoms managed by FortiManager VM S-series, including FortiCare Premium.","created_by":1013,"created_at":"2024-05-31 16:12:49","updated_at":"2024-05-31 16:12:49","pinyin_shortcut":"FC110FMGVS2580136","product_unit":2,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":338,"key":338,"name":"\u98de\u5854\u865a\u62df\u673a\u7248\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":921,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1637,"description":"","number":"3","outbound":"0","amount":"6941","total_amount":"20823","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"5414","total_cost":"16242","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6569,"project_id":3417,"product_id":1638,"amount":"152306","number":2,"cost":"115346","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"304612","total_cost":"230692","erp_sales_order_product_id":922,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1638,"name":"FC2-10-AZVMS-465-01-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":338,"product_misc":null,"product_qa":null,"pn":"","description":"Subscription license for 50 GB\/Day Central Logging & Analytics. Include FortiCare Premium support, IOC, Security Automation Service and FortiGuard Outbreak Detection Service.-3Year","created_by":1013,"created_at":"2024-05-31 16:13:12","updated_at":"2024-05-31 16:13:12","pinyin_shortcut":"FC210AZVMS4650136","product_unit":2,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":338,"key":338,"name":"\u98de\u5854\u865a\u62df\u673a\u7248\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":922,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1638,"description":"","number":"2","outbound":"0","amount":"152306","total_amount":"304612","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"115346","total_cost":"230692","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6570,"project_id":3417,"product_id":941,"amount":"280000","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"280000","total_cost":"0","erp_sales_order_product_id":923,"supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2026-02-05 16:37:56","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-02-05 16:37:56.557723+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":923,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"0","amount":"280000","total_amount":"280000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6571,"project_id":3417,"product_id":1227,"amount":"0","number":1,"cost":"7909.16","description":"\u8d60\u9001","supplier_id":262,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"7909.16","erp_sales_order_product_id":924,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"product":{"id":1227,"name":"A2896\uff08\u94f6\u8272\uff09","product_type":23,"product_component":193,"product_brand":190,"product_serie":812,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-01-12 16:18:41","updated_at":"2024-01-12 16:18:41","pinyin_shortcut":"A2896ys","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":193,"key":193,"name":"\u6570\u7801\u7535\u5b50\u4ea7\u54c1"},"productBrand":{"id":190,"key":190,"name":"Apple\/\u82f9\u679c"},"productSerie":{"id":812,"key":812,"name":"Apple iPhone 14 Pro Max 256GB"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":924,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1227,"description":"\u8d60\u9001","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"7909.16","total_cost":"7909.16","supplier_id":262,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[{"id":675,"project_id":3417,"contact_id":4701,"point":"100000.00","paid_point":"100000","contact":{"id":4701,"key":4701,"name":"\u5218\u6653\u51cc","client_id":93,"supplier_id":null,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":120,"project_id":3417,"contact_id":4701,"point":"100000.00","day_at":"2024-09-29","description":"\u8f6c\u5230\u8d75\u6657\u7131\u5361\u91cc\uff0c\u7533\u8bf7\u7684\u81ea\u9001","created_at":"2024-09-30 11:27:25"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":12289,"project_id":3417},{"id":9346,"project_id":3417},{"id":9342,"project_id":3417},{"id":9338,"project_id":3417},{"id":9334,"project_id":3417},{"id":9331,"project_id":3417},{"id":9327,"project_id":3417},{"id":9323,"project_id":3417},{"id":9366,"project_id":3417},{"id":9361,"project_id":3417},{"id":9362,"project_id":3417},{"id":9363,"project_id":3417},{"id":9358,"project_id":3417},{"id":9359,"project_id":3417},{"id":9355,"project_id":3417},{"id":9351,"project_id":3417},{"id":9364,"project_id":3417},{"id":9347,"project_id":3417},{"id":9353,"project_id":3417},{"id":9341,"project_id":3417},{"id":9350,"project_id":3417},{"id":9348,"project_id":3417},{"id":9336,"project_id":3417},{"id":9333,"project_id":3417},{"id":9329,"project_id":3417},{"id":9321,"project_id":3417},{"id":9349,"project_id":3417},{"id":9339,"project_id":3417},{"id":9337,"project_id":3417},{"id":9335,"project_id":3417},{"id":9332,"project_id":3417},{"id":9330,"project_id":3417},{"id":9328,"project_id":3417},{"id":9314,"project_id":3417},{"id":9326,"project_id":3417},{"id":9324,"project_id":3417},{"id":9322,"project_id":3417},{"id":9320,"project_id":3417},{"id":9318,"project_id":3417},{"id":9316,"project_id":3417},{"id":9345,"project_id":3417},{"id":9356,"project_id":3417},{"id":9343,"project_id":3417},{"id":9360,"project_id":3417},{"id":9354,"project_id":3417},{"id":9357,"project_id":3417},{"id":9365,"project_id":3417},{"id":9352,"project_id":3417},{"id":9344,"project_id":3417},{"id":9340,"project_id":3417},{"id":9325,"project_id":3417},{"id":9319,"project_id":3417},{"id":9317,"project_id":3417}],"reimbursementAmountSum":{"project_id":3417,"sum":"5136.36"},"profit":372408,"contact_points_status_display":"\u5df2\u6838\u9500","total_contact_paid_point":100000,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":2118,"contract_id":3325,"supplier_id":614,"purchase_id":3340,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3340,"key":3340,"serial_no":"TSKJ20240531-HYF-004"}},{"id":1834,"contract_id":3325,"supplier_id":262,"purchase_id":3387,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":3387,"key":3387,"serial_no":" 294739496177"}},{"id":1835,"contract_id":3325,"supplier_id":534,"purchase_id":3461,"supplier":{"id":534,"key":534,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3461,"key":3461,"serial_no":"20240809-TSZHY5"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remindDate":{"id":487,"key":487,"contract_id":3325,"remind_date":"2026-06-30"},"serviceContractRemindDates":[{"id":487,"key":487,"contract_id":3325,"name":"2026-06-30"},{"id":480,"key":480,"contract_id":3325,"name":"2024-09-30"},{"id":481,"key":481,"contract_id":3325,"name":"2024-12-31"},{"id":482,"key":482,"contract_id":3325,"name":"2025-03-31"},{"id":483,"key":483,"contract_id":3325,"name":"2025-06-30"},{"id":484,"key":484,"contract_id":3325,"name":"2025-09-30"},{"id":485,"key":485,"contract_id":3325,"name":"2025-12-31"},{"id":486,"key":486,"contract_id":3325,"name":"2026-03-31"}],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[{"id":451,"contract_id":3325,"user_id":1005,"user":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"salesContractPaymentCollectionRemindReceivers":[{"id":6715,"user_id":1005,"key":1005,"contract_id":3325,"user":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},{"id":6716,"user_id":1001,"key":1001,"contract_id":3325,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1865,"key":1865,"contract_id":3325,"name":"2024-07-26","value":"940000","overdue_days":null,"status":1,"remind_date":"2024-07-26","pct":35.74,"overdue_display":""},{"id":1866,"key":1866,"contract_id":3325,"name":"2024-08-31","value":"1410000","overdue_days":20,"status":1,"remind_date":"2024-08-31","pct":53.61,"overdue_display":"\u903e\u671f20\u5929"},{"id":1867,"key":1867,"contract_id":3325,"name":"2024-10-31","value":"280000","overdue_days":68,"status":1,"remind_date":"2024-10-31","pct":10.65,"overdue_display":"\u903e\u671f68\u5929"}],"salesContractPayments":[{"id":"141","key":"141","contract_id":3325,"value":"940000","created_by":1013,"created_at":"2024-07-04 17:12:46","description":null,"collected_date":"2024-07-04 00:00:00","amount":"940000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":35.74},{"id":"1204","key":"1204","contract_id":3325,"value":"280000","created_by":1013,"created_at":"2025-01-07 16:51:13","description":null,"collected_date":"2025-01-07 00:00:00","amount":"280000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":10.65},{"id":"1108","key":"1108","contract_id":3325,"value":"1410000","created_by":1013,"created_at":"2024-09-20 17:44:35","description":null,"collected_date":"2024-09-20 00:00:00","amount":"1410000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":53.61}],"salesContractInvoices":[{"id":1696,"key":1696,"contract_id":3325,"value":"2350000.00","attachment_id":null,"from_date":"2024-06-26","description":"","is_draft":true,"is_cancel":false,"salesInvoiceAmounts":[{"id":2690,"sales_invoice_id":1696,"amount":"2350000.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":26727,"object_type":102,"object_id":1696,"attachment_id":19971,"attachment":{"id":19971,"key":19971,"name":"67d50d8e-34f9-3289-b72a-020fe7a37fb2","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/67d50d8e-34f9-3289-b72a-020fe7a37fb2\/dzfp_24112000000070080551_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8_20240626160454.pdf","orig_name":"dzfp_24112000000070080551_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8_20240626160454.pdf"}}]},{"id":1910,"key":1910,"contract_id":3325,"value":"280000.00","attachment_id":null,"from_date":"2024-12-24","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":225,"sales_invoice_id":1910,"amount":"280000","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":31292,"object_type":102,"object_id":1910,"attachment_id":23365,"attachment":{"id":23365,"key":23365,"name":"d6dd146a-de2d-3234-b024-e100cbf0934f","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/d6dd146a-de2d-3234-b024-e100cbf0934f\/dzfp_24112000000220335590_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8_20241224141227.pdf","orig_name":"dzfp_24112000000220335590_\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8_20241224141227.pdf"}}]}],"contractScans":[{"id":29032,"object_type":105,"object_id":3325,"attachment_id":19507,"attachment":{"id":19507,"key":19507,"name":"934c58d9-6044-3a30-89c2-e1c23dda3e85","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/934c58d9-6044-3a30-89c2-e1c23dda3e85\/\u5eb7\u9f99\u5316\u6210.pdf","orig_name":"\u5eb7\u9f99\u5316\u6210.pdf"}}],"receiptScans":[{"id":26772,"object_type":106,"object_id":3325,"attachment_id":19978,"attachment":{"id":19978,"key":19978,"name":"ccb8cd70-d3a1-31c9-9063-043c6e49fd24","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/ccb8cd70-d3a1-31c9-9063-043c6e49fd24\/\u5317\u4eac\u62d3\u5b9e\u8d27\u7269\u7b7e\u6536\u5355.pdf","orig_name":"\u5317\u4eac\u62d3\u5b9e\u8d27\u7269\u7b7e\u6536\u5355.pdf"}}],"verifyScans":[{"id":26773,"object_type":107,"object_id":3325,"attachment_id":20020,"attachment":{"id":20020,"key":20020,"name":"06c9e3df-706a-3ed0-870c-49a8b359fe9f","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/06c9e3df-706a-3ed0-870c-49a8b359fe9f\/\u5eb7\u9f99\u5316\u6210-\u9a8c\u6536\u62a5\u544a2024.7.2.pdf","orig_name":"\u5eb7\u9f99\u5316\u6210-\u9a8c\u6536\u62a5\u544a2024.7.2.pdf"}}],"unreadComments":null,"collected_plan":2630000,"projectProductTotalAmount":2630000,"projectProductAllAmount":true,"projectProductTotalCost":2017076.16,"projectProductAllCost":true,"projectProductTotalCount":53,"invoiced":"2630000.00","un_invoiced":0,"collected":"2630000","un_collected":0,"is_collected":true,"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remind_date":"2026-06-30","remind_ahead_display":"\u63d0\u524d7\u5929","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":0}],"pagenation":{"totalcount":5,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"223.104.41.38","ua":"jinchangxiao\/2.3.156 (iPhone 12; iOS 26.5; Scale\/3.00)"}', FALSE, '2026-06-12 15:52:02', 744394240) RETURNING "id"