ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68737ab3a2658: POST https://beta.jinchangxiao.com/v2/project/of-client at 2025-07-13 05:21:55 pm by 120.244.156.33

Log Messages

总计146条数据
TimeLevelCategoryMessage
 
17:21:55.664traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
17:21:55.664traceyii\base\Module::getModuleLoading module: debug
17:21:55.665traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
17:21:55.665traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
17:21:55.665traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
17:21:55.665traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:55.666traceyii\base\Module::getModuleLoading module: gii
17:21:55.666traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
17:21:55.667traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
17:21:55.667traceyii\web\Application::handleRequestRoute requested: 'v2/project/of-client'
17:21:55.667traceyii\base\Module::getModuleLoading module: v2
17:21:55.668infoyii\web\Session::openSession started
17:21:55.669infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:21:55.671infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc'
17:21:55.676traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:55.676traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:21:55.676traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:55.677traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:21:55.677infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004
17:21:55.679traceyii\base\Controller::runActionRoute to run: v2/project/of-client
17:21:55.679traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:55.681traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:21:55.681traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewProject
17:21:55.681traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Accountant
17:21:55.681traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:21:55.681traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
17:21:55.681traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: CommercialAttache
17:21:55.681traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
17:21:55.681traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesDirector
17:21:55.681traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\ProjectController::actionOfClient()
17:21:55.681infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='2094') AND ("deleted"=FALSE)
17:21:55.683traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:55.683traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:21:55.683traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:55.684traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:21:55.684traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:55.686traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:55.688infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1004, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("prr"."user_id"=1004) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1004))) AND ("p"."client_id"=2094) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC) "c"
17:21:55.695infoyii\db\Command::querySELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1004, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("prr"."user_id"=1004) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1004))) AND ("p"."client_id"=2094) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC LIMIT 10
17:21:55.707infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2094
17:21:55.707infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
17:21:55.709infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)
17:21:55.712infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id"=1
17:21:55.714infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=43
17:21:55.715infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id"=1
17:21:55.717infoyii\db\Command::querySELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2)
17:21:55.718infoyii\db\Command::querySELECT "project_id", "contribution" AS "value", "engineer_id" AS "key", "u"."name" FROM "a57be577deb434"."tbl_project_architects" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON engineer_id = u.id WHERE "a57be577deb434"."tbl_project_architects"."project_id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590) ORDER BY "contribution" DESC, "engineer_id"
17:21:55.719infoyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (3, 5)
17:21:55.724infoyii\db\Command::querySELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (9, 5, 2, 8)
17:21:55.725infoyii\db\Command::querySELECT id, product_type_id, product_type_id as key, name, coalesce(budget, 0) as budget, coalesce(pct, 0) as pct, coalesce(profit, 0) as profit, project_id FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590)
17:21:55.726infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590)
17:21:55.728infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (129, 179, 181, 158, 5, 1, 226, 164, 173, 165, 167, 175, 140, 185, 191, 172, 182, 142, 133, 2, 205, 204, 197, 199, 184, 189, 128, 177, 215, 349, 359, 369, 377)) ORDER BY "sort"
17:21:55.729infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590)
17:21:55.729infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (129, 179, 181, 158, 5, 1, 226, 164, 173, 165, 167, 175, 140, 185, 191, 172, 182, 142, 133, 2, 205, 204, 197, 199, 184, 189, 128, 177, 215, 349, 359, 369, 377)) ORDER BY "sort"
17:21:55.730infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590)
17:21:55.731infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (129, 179, 181, 158, 5, 1, 226, 164, 173, 165, 167, 175, 140, 185, 191, 172, 182, 142, 133, 2, 205, 204, 197, 199, 184, 189, 128, 177, 215, 349, 359, 369, 377)) ORDER BY "sort"
17:21:55.743infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
17:21:55.751infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)
17:21:55.752infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
17:21:55.753infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
17:21:55.753infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)
17:21:55.754infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2094
17:21:55.754infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
17:21:55.755infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)
17:21:55.755infoyii\db\Command::querySELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", sum(points) as points FROM "a57be577deb434"."tbl_case_assignments" GROUP BY "case_id") "ca" ON ca.case_id = c.id WHERE "c"."project_id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590) GROUP BY "c"."project_id"
17:21:55.765traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:55.766traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:21:55.766infoyii\db\Command::querySELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("project_id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590)) GROUP BY "project_id"
17:21:55.766infoyii\db\Command::querySELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590) GROUP BY "project_id"
17:21:55.768infoyii\db\Command::querySELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=1) AND (("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL)) AND ("project_id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590)) GROUP BY "project_id"
17:21:55.771infoyii\db\Command::querySELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(left_at - arrived_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_implement_records" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=2) AND ("c"."project_id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590)) GROUP BY "c"."project_id"
17:21:55.782infoyii\db\Command::querySELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_pre_sales" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=1) AND ("c"."project_id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590)) GROUP BY "c"."project_id"
17:21:55.784infoyii\db\Command::querySELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=2) AND ("project_id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590)) GROUP BY "project_id"
17:21:55.792infoyii\db\Command::querySELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (3, 2)) AND ("project_id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590)) GROUP BY "project_id"
17:21:55.794infoyii\db\Command::querySELECT "id", "from_project", "payment_collection_remind_ahead", "serial_no", "is_settle", "is_deliver", "is_outbound" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590)
17:21:55.796infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (2014, 3170, 3649, 3636, 2733, 2732, 2551))
17:21:55.801infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (8114, 22513, 17887, 13794, 13795, 12073, 22334)
17:21:55.811infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (2014, 3170, 3649, 3636, 2733, 2732, 2551))
17:21:55.820infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (11249, 12770, 14028, 14569, 23354)
17:21:55.821infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (2014, 3170, 3649, 3636, 2733, 2732, 2551))
17:21:55.823infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "created_at", "collected_date" FROM "a57be577deb434"."tbl_sales_contract_payments" WHERE "contract_id" IN (2014, 3170, 3649, 3636, 2733, 2732, 2551) ORDER BY "id"
17:21:55.826infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1014, 1013)
17:21:55.826infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (2014, 3170, 3649, 3636, 2733, 2732, 2551) ORDER BY "id"
17:21:55.827infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=8031
17:21:55.828infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (2014, 3170, 3649, 3636, 2733, 2732, 2551) ORDER BY "remind_date"
17:21:55.828infoyii\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 (2014, 3170, 3649, 3636, 2733, 2732, 2551)
17:21:55.829infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5388, 1001)
17:21:55.830infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5388, 1005))
17:21:55.830infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (2014, 3170, 3649, 3636, 2733, 2732, 2551)
17:21:55.831infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (123, 496, 138, 425, 424, 665, 314)
17:21:55.834infoyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (2082, 2567, 2012, 2036, 2046, 2017, 2728, 2729, 3641, 2016, 2714, 3650, 3654, 3707)
17:21:55.836infoyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590)
17:21:55.837infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590)
17:21:55.838infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (496, 138, 316)
17:21:55.838infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1862, 1871, 1872, 1863, 1864, 1865, 1866, 1867, 1868, 1873, 1874, 1196, 1197, 1869, 1870, 942, 1850, 1615, 625, 909, 916, 917, 941)
17:21:55.840infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (4, 19, 5, 7)
17:21:55.840infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (19, 151, 20, 35, 26, 43, 188, 68, 51, 24)
17:21:55.841infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (7, 134, 133, 12, 88)
17:21:55.842infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1376, 593, 592, 1558, 104, 1565, 1033, 103, 1566, 749, 744, 377, 1449, 1567, 1568, 572, 577, 1232, 748)
17:21:55.843infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (1, 7, 2, 6, 3)
17:21:55.844infoyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590)) GROUP BY "object_id"
17:21:55.864infoyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=1) AND (remind_user_id = 1004 AND is_read = false) AND ("object_id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590)) GROUP BY "object_id"
17:21:55.883infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590)
17:21:55.884infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (4844, 1314)
17:21:55.885infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (149, 2598)
17:21:55.885infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((4844, 3468), (1314, 3704), (1314, 3701))
17:21:55.886infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id" IN (3704, 3701, 3468, 3241, 3242, 3086, 2655, 2590)
17:21:55.886traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: updateProject
17:21:55.886traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Accountant
17:21:55.886traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:21:55.887traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesDirector
17:21:55.887infoyii\db\Command::querySELECT EXISTS(SELECT "p".* FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1004, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("prr"."user_id"=1004) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1004))) AND ("p"."id"=3704))
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: deleteProject
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: updateSalesContract
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Accountant
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: CommercialAttache
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 电话销售
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: GM
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewProduct
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Accountant
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: CommercialAttache
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 电话销售
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: GM
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 软件开发
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
17:21:55.889traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
17:21:55.890infoyii\db\Command::querySELECT EXISTS(SELECT "p".* FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1004, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("prr"."user_id"=1004) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1004))) AND ("p"."id"=3701))
17:21:55.895infoyii\db\Command::querySELECT EXISTS(SELECT "p".* FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1004, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("prr"."user_id"=1004) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1004))) AND ("p"."id"=3468))
17:21:55.897infoyii\db\Command::querySELECT EXISTS(SELECT "p".* FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1004, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("prr"."user_id"=1004) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1004))) AND ("p"."id"=3241))
17:21:55.899infoyii\db\Command::querySELECT EXISTS(SELECT "p".* FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1004, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("prr"."user_id"=1004) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1004))) AND ("p"."id"=3242))
17:21:55.901infoyii\db\Command::querySELECT EXISTS(SELECT "p".* FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1004, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("prr"."user_id"=1004) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1004))) AND ("p"."id"=3086))
17:21:55.903infoyii\db\Command::querySELECT EXISTS(SELECT "p".* FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1004, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("prr"."user_id"=1004) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1004))) AND ("p"."id"=2655))
17:21:55.905infoyii\db\Command::querySELECT EXISTS(SELECT "p".* FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1004, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("prr"."user_id"=1004) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1004))) AND ("p"."id"=2590))
17:21:55.907traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: createProject
17:21:55.907traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesDirector
17:21:55.909traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:55.909traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:21:55.910infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1004, 2, 1141, 'v2/project/of-client', '{"access_token":"NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc","device_type":"2","id":"2094","page":"1","posttime":"1752398464","token":"3c4b10916ba7ae8eba027d87f520fbc0","version_code":"1141"}', '{"code":200,"data":{"list":[{"id":3704,"client_id":2094,"project_status":3,"project_progress":9,"budget":"217500","profit_pct":"24.99","bargain_date":"2024-11-04","description":"","created_by":1005,"created_at":"2024-11-01 10:48:25","updated_at":"2024-12-22 22:21:38","engineer_id":null,"project_title":"\u5ba2\u6237\u81ea\u7528-\u6df1\u4fe1\u670d\u9632\u706b\u5899\uff0c\u8d1f\u8f7d\uff0c\u4ea4\u6362\u673a","collected":"217500","status_updated_at":"2024-11-06 09:37:20.013523+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-11-01 10:48:25.58806+08","forecast_updated_at":"2024-11-01 10:48:25.58806+08","end_at":"2024-12-18 11:01:22","pinyin_shortcut":"khzysxffhqfzjhj","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":"7575","paid_contact_point":"7575","project_product_version_id":707,"is_sales_order_ready":true,"collected_plan":217500,"profits":"54353.250000000000000000","remain":"249 days 07:44:35.683539","progress_remain":"254 days 06:33:30.109002","forecast_remain":"254 days 06:33:30.109002","lost_contact_days":"207.126339086366","last_contact":"2024-12-18 14:20:00","last_arrive_days":null,"last_arrive":null,"duration":"47 days 00:12:57.119775","issued_invoices":"217500.00","client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","logo":null,"client_type":1,"client_class":43,"client_industry":1,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":1,"key":1,"name":"\u653f\u5e9c"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"84700.00","pct":"24.99","profit":"21166.53","project_id":3704},{"id":4,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"132800.00","pct":"24.99","profit":"33186.72","project_id":3704}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","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"}},"projectCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"casePoints":null,"workLogCount":{"project_id":3704,"count":1},"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3649,"from_project":3704,"payment_collection_remind_ahead":"7 days","serial_no":"TS-ZHY-2024110401","is_settle":true,"is_deliver":true,"is_outbound":true,"contractScans":[{"id":30423,"object_type":105,"object_id":3649,"attachment_id":22513,"attachment":{"id":22513,"key":22513,"name":"20c595ed-4407-322e-bc97-ca90d4d620f8","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/20c595ed-4407-322e-bc97-ca90d4d620f8\/\u4e2d\u5929\u950b217500.pdf","orig_name":"\u4e2d\u5929\u950b217500.pdf"}}],"receiptScans":[],"verifyScans":[],"salesContractPayments":[{"id":2016,"key":2016,"contract_id":3649,"value":"217500","created_by":1013,"created_at":"2024-11-19 11:16:31","collected_date":"2024-11-19","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1861,"key":1861,"contract_id":3649,"value":"217500.00","attachment_id":null,"from_date":"2024-11-15","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2211,"key":2211,"contract_id":3649,"name":"2024-12-06","value":"217500","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":7361,"user_id":1005,"key":1005,"contract_id":3649,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},{"id":7362,"user_id":5388,"key":5388,"contract_id":3649,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7363,"user_id":1001,"key":1001,"contract_id":3649,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesSupplierRels":[{"id":2102,"contract_id":3649,"supplier_id":496,"purchase_id":3650,"supplier":{"id":496,"key":496,"name":"\u5317\u4eac\u839e\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3650,"key":3650,"serial_no":"TSKJ20241106-HYF-001"}},{"id":2103,"contract_id":3649,"supplier_id":138,"purchase_id":3654,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"purchase":{"id":3654,"key":3654,"serial_no":"SFXSH202411080052"}},{"id":2190,"contract_id":3649,"supplier_id":138,"purchase_id":3707,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"purchase":{"id":3707,"key":3707,"serial_no":"SXF-LX-20241212994"}}],"payment_collection_remind_ahead_display":"7\u5929"},"projectRemindReceivers":[],"projectProductRels":[{"id":7998,"project_id":3704,"product_id":1862,"amount":"33900","number":2,"cost":"31064","description":"","supplier_id":496,"hardware_from":"2024-11-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-11-18","software_to":null,"maintenance_to":null,"total_amount":"67800","total_cost":"62128","supplier":{"id":496,"key":496,"name":"\u5317\u4eac\u839e\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1862,"name":"RS6300-50Q-EI-24X","product_type":4,"product_component":19,"product_brand":88,"product_serie":1565,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-08 09:41:39","updated_at":"2024-11-08 09:41:39","pinyin_shortcut":"RS630050QEI24X","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":19,"key":19,"name":"\u4ea4\u6362\u673a"},"productBrand":{"id":88,"key":88,"name":"\u4fe1\u9510"},"productSerie":{"id":1565,"key":1565,"name":"\u4fe1\u9510RS6300\u5b89\u89c6\u4ea4\u6362\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":7999,"project_id":3704,"product_id":1871,"amount":"0","number":24,"cost":"289","description":"","supplier_id":496,"hardware_from":"2024-11-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-11-18","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"6936","supplier":{"id":496,"key":496,"name":"\u5317\u4eac\u839e\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1871,"name":"SFP-10G-MM850","product_type":4,"product_component":43,"product_brand":88,"product_serie":1567,"product_misc":null,"product_qa":null,"pn":"","description":"\u4fe1\u9510\u591a\u6a21\u5149\u7ea4\u6a21\u5757","created_by":1013,"created_at":"2024-11-08 11:10:04","updated_at":"2024-11-08 11:10:44","pinyin_shortcut":"SFP10GMM850","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":88,"key":88,"name":"\u4fe1\u9510"},"productSerie":{"id":1567,"key":1567,"name":"\u4fe1\u9510\u4e07\u5146\u591a\u6a21\u5343\u5146\u5149\u7ea4\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"id":8000,"project_id":3704,"product_id":1872,"amount":"0","number":24,"cost":"39","description":"","supplier_id":496,"hardware_from":"2024-11-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-11-18","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"936","supplier":{"id":496,"key":496,"name":"\u5317\u4eac\u839e\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1872,"name":"\u5149\u7ea4\u8df3\u7ebf-\u53cc\u8054-\u591a\u6a21-LC-LC-3M","product_type":4,"product_component":43,"product_brand":88,"product_serie":1568,"product_misc":null,"product_qa":null,"pn":"","description":"\u5149\u7ea4\u8df3\u7ebf","created_by":1013,"created_at":"2024-11-08 11:12:13","updated_at":"2024-11-08 11:12:13","pinyin_shortcut":"gxtxsldmLCLC3M","product_unit":6,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":88,"key":88,"name":"\u4fe1\u9510"},"productSerie":{"id":1568,"key":1568,"name":"\u4fe1\u95103M LC-LC\u5149\u7ea4\u8df3\u7ebf"},"productUnit":{"id":6,"key":6,"name":"\u6761"}}},{"id":8001,"project_id":3704,"product_id":1863,"amount":"32500","number":2,"cost":"2126","description":"","supplier_id":138,"hardware_from":"2024-11-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-11-18","software_to":null,"maintenance_to":null,"total_amount":"65000","total_cost":"4252","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1863,"name":"AF-1000-FH1600B-VX","product_type":5,"product_component":26,"product_brand":12,"product_serie":1033,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-08 10:40:03","updated_at":"2024-11-08 10:40:03","pinyin_shortcut":"AF1000FH1600BVX","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1033,"key":1033,"name":"\u6df1\u4fe1\u670d AF-1000\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":8002,"project_id":3704,"product_id":1864,"amount":"0","number":2,"cost":"5200.49","description":"","supplier_id":138,"hardware_from":null,"software_from":"2024-11-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-11-08","maintenance_to":null,"total_amount":"0","total_cost":"10400.98","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1864,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH1600B-VX\uff09","product_type":5,"product_component":35,"product_brand":12,"product_serie":103,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-08 10:42:14","updated_at":"2024-11-08 10:42:14","pinyin_shortcut":"sxffhqrjV80syyAF1000FH1600BVX","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":103,"key":103,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8003,"project_id":3704,"product_id":1865,"amount":"0","number":2,"cost":"759.04","description":"","supplier_id":138,"hardware_from":null,"software_from":"2024-11-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-11-08","maintenance_to":null,"total_amount":"0","total_cost":"1518.08","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1865,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u589e\u5f3a\u7ea7\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH1600B-VX\uff09","product_type":5,"product_component":35,"product_brand":12,"product_serie":103,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-08 10:42:57","updated_at":"2024-11-08 10:42:57","pinyin_shortcut":"sxffhqzqjrjV80syyAF1000FH1600BVX","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":103,"key":103,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8004,"project_id":3704,"product_id":1866,"amount":"0","number":6,"cost":"759.04","description":"","supplier_id":138,"hardware_from":null,"software_from":"2024-11-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-11-08","maintenance_to":null,"total_amount":"0","total_cost":"4554.24","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1866,"name":"\u6df1\u4fe1\u670d\u7f51\u5173\u6740\u6bd2\u8f6f\u4ef6V6.0\uff08\u7f51\u5173\u6740\u6bd2\u66f4\u65b0\uff09\uff08\u9002\u7528\u4e8eAF-1000-FH1600B-VX\uff09","product_type":5,"product_component":35,"product_brand":12,"product_serie":1566,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-08 10:49:40","updated_at":"2024-11-08 10:49:40","pinyin_shortcut":"sxfwgsdrjV60wgsdgxsyyAF1000FH1600BVX","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1566,"key":1566,"name":"\u6df1\u4fe1\u670d\u7f51\u5173\u6740\u6bd2\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8005,"project_id":3704,"product_id":1867,"amount":"0","number":2,"cost":"759.04","description":"","supplier_id":138,"hardware_from":null,"software_from":"2024-11-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-11-08","maintenance_to":null,"total_amount":"0","total_cost":"1518.08","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1867,"name":"\u6df1\u4fe1\u670d\u7f51\u5173\u6740\u6bd2\u8f6f\u4ef6V6.0\uff08\u7f51\u5173\u6740\u6bd2\u6a21\u5757\uff09\uff08\u9002\u7528\u4e8eAF-1000-FH1600B-VX\uff09","product_type":5,"product_component":35,"product_brand":12,"product_serie":1566,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-08 10:50:35","updated_at":"2024-11-08 10:50:35","pinyin_shortcut":"sxfwgsdrjV60wgsdmksyyAF1000FH1600BVX","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1566,"key":1566,"name":"\u6df1\u4fe1\u670d\u7f51\u5173\u6740\u6bd2\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8006,"project_id":3704,"product_id":1868,"amount":"0","number":6,"cost":"759.04","description":"","supplier_id":138,"hardware_from":null,"software_from":"2024-11-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-11-08","maintenance_to":null,"total_amount":"0","total_cost":"4554.24","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1868,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH1600B-VX\uff09","product_type":7,"product_component":188,"product_brand":12,"product_serie":744,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-08 10:51:47","updated_at":"2024-11-08 10:51:47","pinyin_shortcut":"sxfaqynyzdyrjV80syyAF1000FH1600BVX","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":188,"key":188,"name":"\u7cfb\u7edf\u8ba2\u9605\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":744,"key":744,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u9274\u8ba2\u9605\u8f6f\u4ef6V8.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8007,"project_id":3704,"product_id":1873,"amount":"0","number":2,"cost":"1831.1","description":"","supplier_id":138,"hardware_from":null,"software_from":"2024-11-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-11-08","maintenance_to":null,"total_amount":"0","total_cost":"3662.2","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1873,"name":"\u6df1\u4fe1\u670dSSL VPN\u8f6f\u4ef6V6.0","product_type":5,"product_component":35,"product_brand":12,"product_serie":104,"product_misc":null,"product_qa":null,"pn":"","description":"\u79fb\u52a8\u63a5\u5165\u6388\u6743\u6a21\u5757","created_by":1013,"created_at":"2024-11-08 11:16:40","updated_at":"2024-11-08 11:16:40","pinyin_shortcut":"sxfSSLVPNrjV60","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":104,"key":104,"name":"\u6df1\u4fe1\u670dVPN\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8008,"project_id":3704,"product_id":1874,"amount":"0","number":50,"cost":"82.55","description":"","supplier_id":138,"hardware_from":null,"software_from":"2024-11-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-11-08","maintenance_to":null,"total_amount":"0","total_cost":"4127.50","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1874,"name":"\u6df1\u4fe1\u670dSSL VPN\u6388\u6743\u8f6f\u4ef6 V6.0","product_type":5,"product_component":35,"product_brand":12,"product_serie":104,"product_misc":null,"product_qa":null,"pn":"","description":"\u79fb\u52a8\u63a5\u5165\u6388\u6743","created_by":1013,"created_at":"2024-11-08 11:17:07","updated_at":"2024-11-08 11:17:07","pinyin_shortcut":"sxfSSLVPNsqrjV60","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":104,"key":104,"name":"\u6df1\u4fe1\u670dVPN\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8009,"project_id":3704,"product_id":1196,"amount":"0","number":4,"cost":"244","description":"","supplier_id":138,"hardware_from":"2024-11-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-11-18","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"976","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1196,"name":"\u5343\u5146\u591a\u6a21-850-550m-\u53cc\u7ea4","product_type":4,"product_component":43,"product_brand":12,"product_serie":748,"product_misc":null,"product_qa":null,"pn":"","description":"SFP\u5343\u5146\u591a\u6a21\u5149\u6a21\u5757\uff0c\u901f\u7387\uff1a1.25Gb\/s\uff0c\u6ce2\u957f\uff1a850nm\uff0c\u4f20\u8f93\u8ddd\u79bb\uff1a0.55km\uff0c\u53ccLC\u63a5\u53e3","created_by":1013,"created_at":"2024-01-09 16:10:20","updated_at":"2024-01-09 16:10:20","pinyin_shortcut":"qzdm850550msx","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":748,"key":748,"name":"\u6df1\u4fe1\u670d\u5343\u5146\u591a\u6a21\u5149\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"id":8010,"project_id":3704,"product_id":1197,"amount":"0","number":4,"cost":"48","description":"","supplier_id":138,"hardware_from":"2024-11-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-11-18","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"192","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1197,"name":"\u5149\u7ea4\u7ebf-\u591a\u6a21-LC-LC-3M","product_type":4,"product_component":43,"product_brand":12,"product_serie":749,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-01-09 16:12:21","updated_at":"2024-01-09 16:12:21","pinyin_shortcut":"gxxdmLCLC3M","product_unit":6,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":749,"key":749,"name":"\u6df1\u4fe1\u670d\u591a\u6a21-LC-LC\u5149\u7ea4\u8df3\u7ebf"},"productUnit":{"id":6,"key":6,"name":"\u6761"}}},{"id":8011,"project_id":3704,"product_id":1869,"amount":"42350","number":2,"cost":"2879","description":"","supplier_id":138,"hardware_from":"2024-11-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-11-18","software_to":null,"maintenance_to":null,"total_amount":"84700","total_cost":"5758","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1869,"name":"AD-1000-B1200-VX","product_type":4,"product_component":68,"product_brand":12,"product_serie":377,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-08 10:53:07","updated_at":"2024-11-08 10:53:07","pinyin_shortcut":"AD1000B1200VX","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":68,"key":68,"name":"\u5e94\u7528\u4ea4\u4ed8\u7f51\u5173"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":377,"key":377,"name":"AD-1000\u7cfb\u5217"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":8012,"project_id":3704,"product_id":1870,"amount":"0","number":2,"cost":"13659.34","description":"","supplier_id":138,"hardware_from":null,"software_from":"2024-11-08","maintenance_from":null,"hardware_to":null,"software_to":"2027-11-08","maintenance_to":null,"total_amount":"0","total_cost":"27318.68","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1870,"name":"\u6df1\u4fe1\u670d\u5e94\u7528\u4ea4\u4ed8\u8f6f\u4ef6V7.0\uff08\u9002\u7528\u4e8eAD-1000-B1200-VX\uff09","product_type":4,"product_component":51,"product_brand":12,"product_serie":1449,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-11-08 10:57:53","updated_at":"2024-11-08 10:57:53","pinyin_shortcut":"sxfyyjfrjV70syyAD1000B1200VX","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1449,"key":1449,"name":"\u6df1\u4fe1\u670d\u5e94\u7528\u4ea4\u4ed8\u8f6f\u4ef6V7.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":8013,"project_id":3704,"product_id":1872,"amount":"0","number":4,"cost":"48","description":"","supplier_id":138,"hardware_from":"2024-11-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-11-18","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"192","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1872,"name":"\u5149\u7ea4\u8df3\u7ebf-\u53cc\u8054-\u591a\u6a21-LC-LC-3M","product_type":4,"product_component":43,"product_brand":88,"product_serie":1568,"product_misc":null,"product_qa":null,"pn":"","description":"\u5149\u7ea4\u8df3\u7ebf","created_by":1013,"created_at":"2024-11-08 11:12:13","updated_at":"2024-11-08 11:12:13","pinyin_shortcut":"gxtxsldmLCLC3M","product_unit":6,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":88,"key":88,"name":"\u4fe1\u9510"},"productSerie":{"id":1568,"key":1568,"name":"\u4fe1\u95103M LC-LC\u5149\u7ea4\u8df3\u7ebf"},"productUnit":{"id":6,"key":6,"name":"\u6761"}}},{"id":8014,"project_id":3704,"product_id":1196,"amount":"0","number":4,"cost":"244","description":"","supplier_id":138,"hardware_from":"2024-11-08","software_from":null,"maintenance_from":null,"hardware_to":"2027-11-18","software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"976","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"product":{"id":1196,"name":"\u5343\u5146\u591a\u6a21-850-550m-\u53cc\u7ea4","product_type":4,"product_component":43,"product_brand":12,"product_serie":748,"product_misc":null,"product_qa":null,"pn":"","description":"SFP\u5343\u5146\u591a\u6a21\u5149\u6a21\u5757\uff0c\u901f\u7387\uff1a1.25Gb\/s\uff0c\u6ce2\u957f\uff1a850nm\uff0c\u4f20\u8f93\u8ddd\u79bb\uff1a0.55km\uff0c\u53ccLC\u63a5\u53e3","created_by":1013,"created_at":"2024-01-09 16:10:20","updated_at":"2024-01-09 16:10:20","pinyin_shortcut":"qzdm850550msx","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":748,"key":748,"name":"\u6df1\u4fe1\u670d\u5343\u5146\u591a\u6a21\u5149\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"id":8015,"project_id":3704,"product_id":942,"amount":"0","number":1,"cost":"292.91","description":"\u8bbe\u5907\u5230\u4ed8\u5feb\u9012\u8d39","supplier_id":138,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"292.91","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"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":"2023-08-11 16:02:40","pinyin_shortcut":"dsfwcjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}}}],"commentCount":{"object_id":3704,"comment":6},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":779,"project_id":3704,"contact_id":1314,"point":"7575.00","paid_point":"7575","contact":{"id":1314,"key":1314,"name":"\u8d3a\u840c\u840c","client_id":149,"supplier_id":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)\uff08\u71d5\u4eac\uff09"},"supplier":null},"projectContactPointRels":[{"id":140,"project_id":3704,"contact_id":1314,"point":"7575.00","day_at":"2024-12-18","description":"","created_at":"2024-12-18 11:01:22"}],"status_display":"\u5df2\u6838\u9500"}],"projectUsedClient":null,"remain_display":249,"progress_remain_display":254,"forecast_remain_display":254,"projectProductTotalAmount":217500,"projectProductAllAmount":true,"projectProductTotalCost":140292.91,"projectProductAllCost":true,"projectProductTotalNumber":143,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":false,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":false,"can_payment":false,"duration_display":47,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":false,"lost_contact_days_display":"6\u4e2a\u6708\u524d","can_view_product":true,"budget_display":"21.75\u4e07","contact_points_status_display":"\u5df2\u6838\u9500"},{"id":3701,"client_id":2094,"project_status":3,"project_progress":9,"budget":"19350","profit_pct":"4.27","bargain_date":"2024-10-28","description":"","created_by":1005,"created_at":"2024-10-27 21:02:28","updated_at":"2025-01-22 15:00:54","engineer_id":null,"project_title":"\u5ba2\u6237\u81ea\u7528-\u534e\u4e3a\u7f51\u7edc\u8bbe\u5907-2024 \u5e74","collected":"19350","status_updated_at":"2024-10-30 09:37:05.696766+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-10-27 21:17:17.867432+08","forecast_updated_at":"2024-10-27 21:17:17.867432+08","end_at":"2024-12-18 11:01:55","pinyin_shortcut":"khzyhwwlsb2024n","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":"4687.5","paid_contact_point":"4687.5","project_product_version_id":642,"is_sales_order_ready":true,"collected_plan":19350,"profits":"826.245000000000000000","remain":"256 days 07:44:50.000296","progress_remain":"258 days 20:04:37.82963","forecast_remain":"258 days 20:04:37.82963","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"51 days 13:59:26.575464","issued_invoices":"19350.00","client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","logo":null,"client_type":1,"client_class":43,"client_industry":1,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":1,"key":1,"name":"\u653f\u5e9c"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":4,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"19350.00","pct":"4.27","profit":"826.245","project_id":3701}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":182,"key":182,"name":"\u56f4\u6807"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","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"}},"projectCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3701,"sum":"105.34"},"buildContract":{"id":3636,"from_project":3701,"payment_collection_remind_ahead":"7 days","serial_no":"TS-ZHY-2024102801","is_settle":true,"is_deliver":true,"is_outbound":true,"contractScans":[{"id":30280,"object_type":105,"object_id":3636,"attachment_id":22334,"attachment":{"id":22334,"key":22334,"name":"fd52cfa2-3aa8-3d4f-9546-b5afc31e5cf1","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/fd52cfa2-3aa8-3d4f-9546-b5afc31e5cf1\/\u4e2d\u5929\u950b.pdf","orig_name":"\u4e2d\u5929\u950b.pdf"}}],"receiptScans":[{"id":31278,"object_type":106,"object_id":3636,"attachment_id":23354,"attachment":{"id":23354,"key":23354,"name":"4cee6a3d-545d-3080-a947-b3f2ff91ba85","extension":"jpeg","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/4cee6a3d-545d-3080-a947-b3f2ff91ba85\/2024\u5e7412\u670823\u65e5\u56db\u53f0\u8bbe\u5907\u7684\u7b7e\u6536\u5355.jpeg","orig_name":"2024\u5e7412\u670823\u65e5\u56db\u53f0\u8bbe\u5907\u7684\u7b7e\u6536\u5355.jpeg"}}],"verifyScans":[],"salesContractPayments":[{"id":2022,"key":2022,"contract_id":3636,"value":"19350","created_by":1013,"created_at":"2024-11-22 16:26:08","collected_date":"2024-11-22","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1854,"key":1854,"contract_id":3636,"value":"19350.00","attachment_id":null,"from_date":"2024-11-06","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2212,"key":2212,"contract_id":3636,"name":"2024-12-31","value":"19350","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":7364,"user_id":1005,"key":1005,"contract_id":3636,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},{"id":7365,"user_id":5388,"key":5388,"contract_id":3636,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7366,"user_id":1001,"key":1001,"contract_id":3636,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesSupplierRels":[{"id":2121,"contract_id":3636,"supplier_id":665,"purchase_id":3641,"supplier":{"id":665,"key":665,"name":"\u5317\u4eac\u4fe1\u62d3\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3641,"key":3641,"serial_no":"\u4fe1\u62d3TSKJ20241030-HYF-006"}}],"payment_collection_remind_ahead_display":"7\u5929"},"projectRemindReceivers":[],"projectProductRels":[{"id":8016,"project_id":3701,"product_id":1850,"amount":"4900","number":3,"cost":"2250","description":"","supplier_id":316,"hardware_from":"2024-11-03","software_from":null,"maintenance_from":null,"hardware_to":"2025-11-02","software_to":null,"maintenance_to":null,"total_amount":"14700","total_cost":"6750","supplier":{"id":316,"key":316,"name":"\u5317\u4eac\u6c38\u8d8a\u660c\u76db\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1850,"name":"AR6121EC-S","product_type":4,"product_component":20,"product_brand":7,"product_serie":1558,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-10-30 10:19:35","updated_at":"2024-10-30 10:19:35","pinyin_shortcut":"AR6121ECS","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":20,"key":20,"name":"\u8def\u7531\u5668"},"productBrand":{"id":7,"key":7,"name":"\u534e\u4e3a"},"productSerie":{"id":1558,"key":1558,"name":"\u534e\u4e3a NetEngine AR6100\u7cfb\u5217\u4f01\u4e1a\u8def\u7531\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":8017,"project_id":3701,"product_id":1615,"amount":"1550","number":3,"cost":"1670","description":"","supplier_id":316,"hardware_from":"2024-09-28","software_from":null,"maintenance_from":null,"hardware_to":"2025-09-27","software_to":null,"maintenance_to":null,"total_amount":"4650","total_cost":"5010","supplier":{"id":316,"key":316,"name":"\u5317\u4eac\u6c38\u8d8a\u660c\u76db\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1615,"name":"S5735S-S24T4S-XA","product_type":4,"product_component":19,"product_brand":7,"product_serie":1376,"product_misc":null,"product_qa":null,"pn":"","description":"S5735S-S24T4S-X\u7ec4\u5408\u914d\u7f6e(24\u4e2a10\/100\/1000BASE-T\u4ee5\u592a\u7f51\u7aef\u53e3,4\u4e2a\u5343\u5146SFP,\u542b1\u4e2a\u4ea4\u6d41\u7535\u6e90)","created_by":1013,"created_at":"2024-05-14 09:10:14","updated_at":"2024-05-14 09:10:14","pinyin_shortcut":"S5735SS24T4SXA","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":19,"key":19,"name":"\u4ea4\u6362\u673a"},"productBrand":{"id":7,"key":7,"name":"\u534e\u4e3a"},"productSerie":{"id":1376,"key":1376,"name":"\u534e\u4e3aS5735S-S24T4S-XA\u4ea4\u6362\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}}],"commentCount":{"object_id":3701,"comment":10},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":780,"project_id":3701,"contact_id":1314,"point":"4687.50","paid_point":"4687.5","contact":{"id":1314,"key":1314,"name":"\u8d3a\u840c\u840c","client_id":149,"supplier_id":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)\uff08\u71d5\u4eac\uff09"},"supplier":null},"projectContactPointRels":[{"id":141,"project_id":3701,"contact_id":1314,"point":"4687.50","day_at":"2024-12-18","description":"","created_at":"2024-12-18 11:01:55"}],"status_display":"\u5df2\u6838\u9500"}],"projectUsedClient":null,"remain_display":256,"progress_remain_display":258,"forecast_remain_display":258,"projectProductTotalAmount":19350,"projectProductAllAmount":true,"projectProductTotalCost":11760,"projectProductAllCost":true,"projectProductTotalNumber":6,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":false,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":false,"can_payment":false,"duration_display":51,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":false,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"1.94\u4e07","contact_points_status_display":"\u5df2\u6838\u9500"},{"id":3468,"client_id":2094,"project_status":3,"project_progress":9,"budget":"176660","profit_pct":"88.92","bargain_date":"2024-02-27","description":"","created_by":1005,"created_at":"2024-03-07 17:52:28","updated_at":"2024-10-28 17:56:21","engineer_id":null,"project_title":"\u786c\u4ef6\u52a0\u5de5\u96c6\u6210\uff0c\u4ea7\u54c1\u6837\u673a\u6574\u4f53\u8054\u8c03\u670d\u52a1","collected":"176660","status_updated_at":"2024-03-07 17:52:28.380515+08","success_rate":null,"comment":"\u79ef\u52066267.15","contract_type":2,"progress_updated_at":"2024-03-07 17:52:28.380515+08","forecast_updated_at":"2024-03-07 17:52:28.380515+08","end_at":"2024-10-28 11:33:54","pinyin_shortcut":"yjjgjccpyjztldfw","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":"6267.15","paid_contact_point":null,"project_product_version_id":626,"is_sales_order_ready":true,"collected_plan":176660,"profits":"157086.072000000000000000","remain":"492 days 23:29:27.316547","progress_remain":"492 days 23:29:27.316547","forecast_remain":"492 days 23:29:27.316547","lost_contact_days":"450.261755753032","last_contact":"2024-04-19 11:05:00","last_arrive_days":null,"last_arrive":null,"duration":"234 days 17:41:26.381827","issued_invoices":"176660.00","client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","logo":null,"client_type":1,"client_class":43,"client_industry":1,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":1,"key":1,"name":"\u653f\u5e9c"}},"usedClient":null,"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"176660.00","pct":"88.92","profit":"157086.072","project_id":3468}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","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"}},"projectCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"casePoints":null,"workLogCount":{"project_id":3468,"count":1},"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3170,"from_project":3468,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-ZHY-2024022701","is_settle":true,"is_deliver":true,"is_outbound":true,"contractScans":[{"id":29652,"object_type":105,"object_id":3170,"attachment_id":17887,"attachment":{"id":17887,"key":17887,"name":"11557230-fc85-3771-8c01-9e73046b437a","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/11557230-fc85-3771-8c01-9e73046b437a\/\u4e00\u6240.pdf","orig_name":"\u4e00\u6240.pdf"}}],"receiptScans":[],"verifyScans":[],"salesContractPayments":[{"id":1801,"key":1801,"contract_id":3170,"value":"52998","created_by":1013,"created_at":"2024-03-18 11:29:32","collected_date":"2024-03-18","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":30},{"id":1828,"key":1828,"contract_id":3170,"value":"123662","created_by":1013,"created_at":"2024-04-22 17:47:01","collected_date":"2024-04-22","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":70}],"salesContractInvoices":[{"id":1613,"key":1613,"contract_id":3170,"value":"52998.00","attachment_id":null,"from_date":"2024-03-08","attachment":null},{"id":1631,"key":1631,"contract_id":3170,"value":"123662.00","attachment_id":null,"from_date":"2024-04-12","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2095,"key":2095,"contract_id":3170,"name":"2024-03-31","value":"52998","overdue_days":null,"pct":30,"collect_status":"\u5df2\u5b8c\u6210"},{"id":2096,"key":2096,"contract_id":3170,"name":"2024-04-30","value":"123662","overdue_days":null,"pct":70,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":6905,"user_id":1005,"key":1005,"contract_id":3170,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"\u4e0d\u63d0\u9192"},"projectRemindReceivers":[],"projectProductRels":[{"id":7044,"project_id":3468,"product_id":941,"amount":"176660","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":"176660","total_cost":"0","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":"2023-08-11 16:02:47","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":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"}}}],"commentCount":{"object_id":3468,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":699,"project_id":3468,"contact_id":4844,"point":"6267.15","paid_point":null,"contact":{"id":4844,"key":4844,"name":"\u738b\u660e\u4eae","client_id":2598,"supplier_id":null,"client":{"id":2598,"key":2598,"name":"\u5173\u7cfb\u6237"},"supplier":null},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"}],"projectUsedClient":null,"remain_display":492,"progress_remain_display":492,"forecast_remain_display":492,"projectProductTotalAmount":176660,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":1,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":false,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":false,"can_payment":false,"duration_display":234,"contract_type_display":"\u8fd0\u7ef4\u670d\u52a1","can_change_status":false,"is_admin":false,"lost_contact_days_display":"1\u5e74\u524d","can_view_product":true,"budget_display":"17.67\u4e07","contact_points_status_display":"\u672a\u6838\u9500"},{"id":3241,"client_id":2094,"project_status":3,"project_progress":9,"budget":"87000","profit_pct":"32.8","bargain_date":"2023-06-27","description":"AD-1000-B1800-TP1\u53f0","created_by":1005,"created_at":"2023-07-04 09:53:32","updated_at":"2024-02-01 16:34:22","engineer_id":null,"project_title":"\u6df1\u4fe1\u670d\u8d1f\u8f7d\u5747\u8861\u9879\u76ee","collected":"87000","status_updated_at":"2023-07-04 09:53:32.48577+08","success_rate":null,"comment":"AD-1000-B1800-TP1\u53f0\r\n\u6210\u672c44000\u3002\u7528\u8fd9\u4e2a\u5355\u5b50\u8865\u4e4b\u524d\u7684\u5229\u6da6\n\u91c7\u8d2d\uff1a\u738b\u4f1f 13681468909","contract_type":1,"progress_updated_at":"2023-07-04 09:53:32.48577+08","forecast_updated_at":"2023-07-04 09:53:32.48577+08","end_at":"2023-07-24 17:00:26","pinyin_shortcut":"sxffzjhxm","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":87,"is_sales_order_ready":true,"collected_plan":87000,"profits":"28536.00000000000000000","remain":"740 days 07:28:23.211292","progress_remain":"740 days 07:28:23.211292","forecast_remain":"740 days 07:28:23.211292","lost_contact_days":"745.334672419699","last_contact":"2023-06-29 09:20:00","last_arrive_days":null,"last_arrive":null,"duration":"20 days 07:06:53.692469","issued_invoices":"87000.00","client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","logo":null,"client_type":1,"client_class":43,"client_industry":1,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":1,"key":1,"name":"\u653f\u5e9c"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"87000.00","pct":"32.8","profit":"28536","project_id":3241}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":129,"key":129,"name":"\u7279\u7ea6\u9080\u6807"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","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"}},"projectCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"casePoints":{"project_id":3241,"points":"31"},"workLogCount":{"project_id":3241,"count":1},"caseCount":{"project_id":3241,"count":1},"salesTimeCount":null,"implementTimeCount":{"project_id":3241,"sum":"0.318888888888889","times":"1"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3241,"sum":"53.45"},"buildContract":{"id":2732,"from_project":3241,"payment_collection_remind_ahead":"00:00:00","serial_no":"HT23061625106520","is_settle":true,"is_deliver":true,"is_outbound":true,"contractScans":[{"id":23429,"object_type":105,"object_id":2732,"attachment_id":13794,"attachment":{"id":13794,"key":13794,"name":"cade6b35-e271-3f6f-8da2-7b35b40e424e","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/cade6b35-e271-3f6f-8da2-7b35b40e424e\/\u4e00\u624087000\u5408\u540c.pdf","orig_name":"\u4e00\u624087000\u5408\u540c.pdf"}}],"receiptScans":[{"id":19461,"object_type":106,"object_id":2732,"attachment_id":14028,"attachment":{"id":14028,"key":14028,"name":"394a9f77-2b14-388d-822e-91af19820acf","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/394a9f77-2b14-388d-822e-91af19820acf\/2023_07_20_16_20_31.pdf","orig_name":"2023_07_20_16_20_31.pdf"}}],"verifyScans":[],"salesContractPayments":[{"id":1577,"key":1577,"contract_id":2732,"value":"87000","created_by":1014,"created_at":"2023-07-24 17:00:26","collected_date":"2023-07-24","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1433,"key":1433,"contract_id":2732,"value":"87000.00","attachment_id":null,"from_date":"2023-07-14","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1273,"key":1273,"contract_id":2732,"name":"2023-08-04","value":"87000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":4634,"user_id":1005,"key":1005,"contract_id":2732,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"salesSupplierRels":[{"id":1408,"contract_id":2732,"supplier_id":138,"purchase_id":2714,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"purchase":{"id":2714,"key":2714,"serial_no":"SFXSH202106180019"}}],"payment_collection_remind_ahead_display":"\u4e0d\u63d0\u9192"},"projectRemindReceivers":[],"projectProductRels":[{"id":2671,"project_id":3241,"product_id":625,"amount":"87000","number":1,"cost":"44000","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"87000","total_cost":"44000","supplier":null,"product":{"id":625,"name":"AD-1000","product_type":4,"product_component":68,"product_brand":12,"product_serie":377,"product_misc":5,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2020-01-03 15:28:29","updated_at":"2023-08-14 10:06:32","pinyin_shortcut":"AD1000","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":68,"key":68,"name":"\u5e94\u7528\u4ea4\u4ed8\u7f51\u5173"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":377,"key":377,"name":"AD-1000\u7cfb\u5217"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"commentCount":{"object_id":3241,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"projectUsedClient":null,"remain_display":740,"progress_remain_display":740,"forecast_remain_display":740,"projectProductTotalAmount":87000,"projectProductAllAmount":true,"projectProductTotalCost":44000,"projectProductAllCost":true,"projectProductTotalNumber":1,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":false,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":false,"can_payment":false,"duration_display":20,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":false,"lost_contact_days_display":"2\u5e74\u524d","can_view_product":true,"budget_display":"8.7\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e"},{"id":3242,"client_id":2094,"project_status":3,"project_progress":9,"budget":"89000","profit_pct":"27.93","bargain_date":"2023-06-21","description":"YJ-1000-VX(\u6df1\u4fe1\u670d\u4e91\u955c\u7f51\u7edc\u8d44\u4ea7\u8106\u5f31\u6027\u626b\u63cf\u7cfb\u7edf\u8f6f\u4ef6V3.0)","created_by":1005,"created_at":"2023-07-04 09:59:37","updated_at":"2024-02-01 17:45:47","engineer_id":null,"project_title":"\u6df1\u4fe1\u670d\u4e91\u955c","collected":"89000","status_updated_at":"2023-07-04 09:59:37.976347+08","success_rate":null,"comment":"YJ-1000-VX(\u6df1\u4fe1\u670d\u4e91\u955c\u7f51\u7edc\u8d44\u4ea7\u8106\u5f31\u6027\u626b\u63cf\u7cfb\u7edf\u8f6f\u4ef6V3.0)\r\n\u8d60\u90011\u4ebaT1+T2\u57f9\u8bad\n\u91c7\u8d2d\uff1a\u79e6\u975913641138311","contract_type":1,"progress_updated_at":"2023-07-04 09:59:37.976347+08","forecast_updated_at":"2023-07-04 09:59:37.976347+08","end_at":"2023-08-08 15:16:54","pinyin_shortcut":"sxfyj","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":88,"is_sales_order_ready":true,"collected_plan":89000,"profits":"24857.700000000000000000","remain":"740 days 07:22:17.720715","progress_remain":"740 days 07:22:17.720715","forecast_remain":"740 days 07:22:17.720715","lost_contact_days":"737.293005753032","last_contact":"2023-07-07 10:20:00","last_arrive_days":null,"last_arrive":null,"duration":"35 days 05:17:16.381128","issued_invoices":"89000.00","client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","logo":null,"client_type":1,"client_class":43,"client_industry":1,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":1,"key":1,"name":"\u653f\u5e9c"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"89000.00","pct":"27.93","profit":"24857.7","project_id":3242}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":129,"key":129,"name":"\u7279\u7ea6\u9080\u6807"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","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"}},"projectCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"casePoints":null,"workLogCount":{"project_id":3242,"count":1},"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":2733,"from_project":3242,"payment_collection_remind_ahead":"00:00:00","serial_no":"HW20230615275","is_settle":true,"is_deliver":true,"is_outbound":true,"contractScans":[{"id":23430,"object_type":105,"object_id":2733,"attachment_id":13795,"attachment":{"id":13795,"key":13795,"name":"889c8520-c5ea-3c37-8be4-188853be4fd7","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/889c8520-c5ea-3c37-8be4-188853be4fd7\/\u4e00\u624089000\u5408\u540c.pdf","orig_name":"\u4e00\u624089000\u5408\u540c.pdf"}}],"receiptScans":[{"id":20067,"object_type":106,"object_id":2733,"attachment_id":14569,"attachment":{"id":14569,"key":14569,"name":"ef664a60-c632-3f9b-afd8-ce9b84fbaf38","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/ef664a60-c632-3f9b-afd8-ce9b84fbaf38\/\u8d27\u7269\u7b7e\u6536\u5355(1).pdf","orig_name":"\u8d27\u7269\u7b7e\u6536\u5355(1).pdf"}}],"verifyScans":[],"salesContractPayments":[{"id":1598,"key":1598,"contract_id":2733,"value":"89000","created_by":1014,"created_at":"2023-08-08 15:16:54","collected_date":"2023-08-08","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1442,"key":1442,"contract_id":2733,"value":"89000.00","attachment_id":null,"from_date":"2023-07-25","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1272,"key":1272,"contract_id":2733,"name":"2023-08-11","value":"89000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":4635,"user_id":1005,"key":1005,"contract_id":2733,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"salesSupplierRels":[{"id":918,"contract_id":2733,"supplier_id":138,"purchase_id":2728,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"purchase":{"id":2728,"key":2728,"serial_no":"SFPSFWCGH202306210113"}},{"id":995,"contract_id":2733,"supplier_id":138,"purchase_id":2729,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"purchase":{"id":2729,"key":2729,"serial_no":"SFXSH202306210113"}}],"payment_collection_remind_ahead_display":"\u4e0d\u63d0\u9192"},"projectRemindReceivers":[],"projectProductRels":[{"id":2672,"project_id":3242,"product_id":909,"amount":"89000","number":1,"cost":"25800","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"89000","total_cost":"25800","supplier":null,"product":{"id":909,"name":"YJ-1000-B1120","product_type":4,"product_component":24,"product_brand":12,"product_serie":572,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-03-14 14:59:12","updated_at":"2024-03-11 14:08:28","pinyin_shortcut":"YJ1000B1120","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":24,"key":24,"name":"\u6f0f\u6d1e\u626b\u63cf\u7cfb\u7edf"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":572,"key":572,"name":"YJ-1000-B1120"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":2673,"project_id":3242,"product_id":942,"amount":"0","number":1,"cost":"24200","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"24200","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":"2023-08-11 16:02:40","pinyin_shortcut":"dsfwcjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}}}],"commentCount":{"object_id":3242,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"projectUsedClient":null,"remain_display":740,"progress_remain_display":740,"forecast_remain_display":740,"projectProductTotalAmount":89000,"projectProductAllAmount":true,"projectProductTotalCost":50000,"projectProductAllCost":true,"projectProductTotalNumber":2,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":false,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":false,"can_payment":false,"duration_display":35,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":false,"lost_contact_days_display":"2\u5e74\u524d","can_view_product":true,"budget_display":"8.9\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e"},{"id":3086,"client_id":2094,"project_status":3,"project_progress":5,"budget":"144400","profit_pct":"50.05","bargain_date":"2023-02-13","description":"\u62d3\u5b9e\u62a5\u4ef7\uff1a\n\u4fe1\u9510 RS5300-52T-4F-D,\u62a5\u4ef7\uff1a35200*4\uff1b\u4fe1\u9510 RS3320-12M-LI\uff0c\u62a5\u4ef7\uff1a1200*4\uff0c\u603b\u4ef7\uff1a145600\n\n\u5176\u4f59\u4e24\u5bb6\uff1a\n35800*4+1200*4=148000\n36000*4+1100*4=148400","created_by":1005,"created_at":"2023-01-08 23:29:27","updated_at":"2024-02-02 14:19:03","engineer_id":null,"project_title":"\u56ed\u533a\u63a5\u5165\u4ea4\u6362\u673a\u7535\u5b50\u7ade\u4ef7 DZJJ230105100154920","collected":"144400","status_updated_at":"2023-01-30 17:09:03.497206+08","success_rate":null,"comment":"\u62d3\u5b9e\u62a5\u4ef7\uff1a\n\u4fe1\u9510 RS5300-52T-4F-D,\u62a5\u4ef7\uff1a35200*4\uff1b\u4fe1\u9510 RS3320-12M-LI\uff0c\u62a5\u4ef7\uff1a1200*4\uff0c\u603b\u4ef7\uff1a145600\n\n\u5176\u4f59\u4e24\u5bb6\uff1a\n35800*4+1200*4=148000\n36000*4+1100*4=148400\r\n\u6df1\u4fe1\u670d\u8fc7\u5355\n\n\u666e\u7968+\u7535\u5b50\u9a8c\u6536\u5355","contract_type":1,"progress_updated_at":"2023-01-08 23:30:00.467644+08","forecast_updated_at":"2023-01-08 23:30:15.952619+08","end_at":"2023-06-20 17:12:07","pinyin_shortcut":"yqjrjhjdzjjDZJJ230105100154920","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":89,"is_sales_order_ready":true,"collected_plan":144400,"profits":"72272.200000000000000000","remain":"895 days 00:12:52.199856","progress_remain":"916 days 17:51:55.229418","forecast_remain":"916 days 17:51:39.744443","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"162 days 17:42:40.055199","issued_invoices":"144400.00","client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","logo":null,"client_type":1,"client_class":43,"client_industry":1,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":1,"key":1,"name":"\u653f\u5e9c"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7","description":"\u5b9a\u4e49\uff1a1.\u62a5\u4ef7\u6709\u6548\u671f 2.\u6838\u7b97\u5229\u6da6\u7387 3. \u4ea4\u8d27\u65b9\u5f0f\u53ca\u65f6\u95f4 4.\u9a8c\u6536\u65b9\u5f0f 5.\u6536\u6b3e\u65b9\u5f0f 6.\u8fdd\u7ea6\u6761\u6b3e \n\u65b9\u6cd5\uff1a\u7528\u516c\u53f8\u6807\u51c6\u7684\u62a5\u4ef7\u5355\u6837\u5f0f\u5411\u5ba2\u6237\u63d0\u4f9b\u62a5\u4ef7\u3002"},"projectProductTypes":[{"id":85,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"144400.00","pct":"50.05","profit":"72272.2","project_id":3086}],"salesForecast":{"id":177,"key":177,"name":"70%","description":"\u8ddf\u5ba2\u6237\u5173\u952e\u51b3\u7b56\u4eba\u5728\u5229\u76ca\u4e0a\u8fbe\u6210\u4e00\u81f4"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":128,"key":128,"name":"\u516c\u5f00\u62db\u6807"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","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"}},"projectCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":2551,"from_project":3086,"payment_collection_remind_ahead":"00:00:00","serial_no":"HT23013029114920","is_settle":true,"is_deliver":true,"is_outbound":true,"contractScans":[{"id":23431,"object_type":105,"object_id":2551,"attachment_id":12073,"attachment":{"id":12073,"key":12073,"name":"b210e7d0-8975-3963-bdd9-116eb12e02d8","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/b210e7d0-8975-3963-bdd9-116eb12e02d8\/2023_02_14_10_17_12.pdf","orig_name":"2023_02_14_10_17_12.pdf"}}],"receiptScans":[{"id":18074,"object_type":106,"object_id":2551,"attachment_id":12770,"attachment":{"id":12770,"key":12770,"name":"fde6648d-8907-38e2-84a8-90e958de4b58","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/fde6648d-8907-38e2-84a8-90e958de4b58\/2023_04_18_17_14_17.pdf","orig_name":"2023_04_18_17_14_17.pdf"}}],"verifyScans":[],"salesContractPayments":[{"id":1555,"key":1555,"contract_id":2551,"value":"144400","created_by":1014,"created_at":"2023-06-20 17:12:07","collected_date":"2023-06-20","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1351,"key":1351,"contract_id":2551,"value":"144400.00","attachment_id":null,"from_date":"2023-02-27","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1159,"key":1159,"contract_id":2551,"name":"2023-03-31","value":"144400","overdue_days":81,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":4636,"user_id":1005,"key":1005,"contract_id":2551,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"salesSupplierRels":[{"id":225,"contract_id":2551,"supplier_id":496,"purchase_id":2567,"supplier":{"id":496,"key":496,"name":"\u5317\u4eac\u839e\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2567,"key":2567,"serial_no":"TSKJ20230216-HYF-001"}}],"payment_collection_remind_ahead_display":"\u4e0d\u63d0\u9192"},"projectRemindReceivers":[],"projectProductRels":[{"id":2674,"project_id":3086,"product_id":916,"amount":"35000","number":4,"cost":"8800","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"140000","total_cost":"35200","supplier":null,"product":{"id":916,"name":"RS5300","product_type":4,"product_component":19,"product_brand":88,"product_serie":1232,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-04-12 15:09:59","updated_at":"2024-02-22 17:14:25","pinyin_shortcut":"RS5300","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":19,"key":19,"name":"\u4ea4\u6362\u673a"},"productBrand":{"id":88,"key":88,"name":"\u4fe1\u9510"},"productSerie":{"id":1232,"key":1232,"name":"\u4fe1\u9510RS5300\u5b89\u89c6\u4ea4\u6362\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":2675,"project_id":3086,"product_id":917,"amount":"1100","number":4,"cost":"2300","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"4400","total_cost":"9200","supplier":null,"product":{"id":917,"name":"RS3320","product_type":4,"product_component":19,"product_brand":88,"product_serie":577,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-04-12 15:11:00","updated_at":"2024-02-22 17:14:54","pinyin_shortcut":"RS3320","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":19,"key":19,"name":"\u4ea4\u6362\u673a"},"productBrand":{"id":88,"key":88,"name":"\u4fe1\u9510"},"productSerie":{"id":577,"key":577,"name":"\u4fe1\u9510RS3320\u5b89\u89c6\u4ea4\u6362\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}}],"commentCount":{"object_id":3086,"comment":4},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"projectUsedClient":null,"remain_display":895,"progress_remain_display":916,"forecast_remain_display":916,"projectProductTotalAmount":144400,"projectProductAllAmount":true,"projectProductTotalCost":44400,"projectProductAllCost":true,"projectProductTotalNumber":8,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":false,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":false,"can_payment":false,"duration_display":162,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":false,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"14.44\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e"},{"id":2655,"client_id":2094,"project_status":5,"project_progress":2,"budget":"2000000","profit_pct":"20","bargain_date":"2021-12-30","description":"\u673a\u623f\u5efa\u8bbe","created_by":1005,"created_at":"2021-09-16 08:11:06","updated_at":"2022-08-03 10:55:18","engineer_id":null,"project_title":"\u65b0\u5efa\u673a\u623f","collected":"0","status_updated_at":"2021-11-15 12:56:22.842662+08","success_rate":null,"comment":"\u673a\u623f\u5efa\u8bbe\r\n\u89e3\u51b3\u7684\u95ee\u9898\uff1a\u65b0\u4e0a\u7684\u5927\u6570\u636e\u9879\u76ee\uff0c\u786c\u4ef6\u65e0\u5904\u5b89\u653e\n\u51b3\u7b56\u6d41\u7a0b\uff1a\u6240\u91cc\u6279\u94b1-\u516c\u53f8\u5185\u90e8\u51b3\u7b56\n\u7ade\u4e89\u5bf9\u624b\uff1a\u534e\u4e3a","contract_type":1,"progress_updated_at":"2021-09-16 08:11:06.748928+08","forecast_updated_at":"2021-11-15 12:56:22.842662+08","end_at":"2021-11-15 12:56:22","pinyin_shortcut":"xjjf","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":0,"profits":"400000.000000000000","remain":"1336 days 04:25:32.8544","progress_remain":"1396 days 09:10:48.948134","forecast_remain":"1336 days 04:25:32.8544","lost_contact_days":"1373.2721724197","last_contact":"2021-10-09 10:50:00","last_arrive_days":null,"last_arrive":null,"duration":"60 days 04:45:16.093734","issued_invoices":null,"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","logo":null,"client_type":1,"client_class":43,"client_industry":1,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":1,"key":1,"name":"\u653f\u5e9c"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectProductTypes":[{"id":85,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"2000000.00","pct":"20","profit":"400000","project_id":2655}],"salesForecast":{"id":173,"key":173,"name":"60%","description":"\u5f97\u5230\u4e86\u5ba2\u6237\u6280\u672f\u90e8\u4eec\u5bf9\u65b9\u6848\u7684\u8ba4\u53ef"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","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"}},"projectCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"casePoints":null,"workLogCount":{"project_id":2655,"count":1},"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":2655,"sum":"312.29"},"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":null,"unreadComments":null,"fromContact":null,"projectContactPoints":[],"projectUsedClient":null,"remain_display":1336,"progress_remain_display":1396,"forecast_remain_display":1336,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":2000000,"is_exceeded":false,"can_update":true,"can_delete":false,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_invoice":false,"can_payment":false,"duration_display":60,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":false,"lost_contact_days_display":"3\u5e74\u524d","can_view_product":true,"budget_display":"200\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e"},{"id":2590,"client_id":2094,"project_status":3,"project_progress":8,"budget":"1421100","profit_pct":"3.39","bargain_date":"2021-08-02","description":"AF-2000-B2130(\u6df1\u4fe1\u670d\u9632\u706b\u5899)\t2\nEDR(\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0\u8f6f\u4ef6V3.0)\t1\n\u76db\u90a6\u5b89\u5168 \u6297DDOS\u8bbe\u5907 RayADS-4000(\u5f02\u5e38\u6d41\u91cf\u6e05\u6d17\u4e0e\u6297\u62d2\u7edd\u670d\u52a1\u7cfb\u7edf)\t1\naServer-R-2205(\u8d85\u878d\u5408\u4e00\u4f53\u673a)\t4\naRack-1200-42U(\u673a\u67dc)\t2\nRS6300-26Q-EI-24X\t2\nRS3300-28T-4F\t3\n\u5b89\u5168\u9694\u79bb\u4e0e\u5355\u5411\u4f20\u8f93\u7cfb\u7edf\t2\n\u5b89\u5168\u6570\u636e\u4ea4\u6362\u7cfb\u7edf \t1\nDC\u8bf7\u6c42\u4e0e\u54cd\u5e94\u4ea4\u6362\u6a21\u5757\u6388\u6743\t1\n\u96c6\u4e2d\u76d1\u63a7\u7ba1\u7406\u7cfb\u7edf\t1\n\u96c6\u4e2d\u76d1\u63a7\u7ba1\u7406\u63a2\u9488\u7cfb\u7edf\t1","created_by":1005,"created_at":"2021-06-18 15:13:35","updated_at":"2021-09-30 16:18:04","engineer_id":null,"project_title":"\u5927\u6570\u636e\u5e73\u53f0\u65b0\u5efa","collected":"1421100","status_updated_at":"2021-08-13 09:38:27.363567+08","success_rate":null,"comment":"AF-2000-B2130(\u6df1\u4fe1\u670d\u9632\u706b\u5899)\t2\nEDR(\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0\u8f6f\u4ef6V3.0)\t1\n\u76db\u90a6\u5b89\u5168 \u6297DDOS\u8bbe\u5907 RayADS-4000(\u5f02\u5e38\u6d41\u91cf\u6e05\u6d17\u4e0e\u6297\u62d2\u7edd\u670d\u52a1\u7cfb\u7edf)\t1\naServer-R-2205(\u8d85\u878d\u5408\u4e00\u4f53\u673a)\t4\naRack-1200-42U(\u673a\u67dc)\t2\nRS6300-26Q-EI-24X\t2\nRS3300-28T-4F\t3\n\u5b89\u5168\u9694\u79bb\u4e0e\u5355\u5411\u4f20\u8f93\u7cfb\u7edf\t2\n\u5b89\u5168\u6570\u636e\u4ea4\u6362\u7cfb\u7edf \t1\nDC\u8bf7\u6c42\u4e0e\u54cd\u5e94\u4ea4\u6362\u6a21\u5757\u6388\u6743\t1\n\u96c6\u4e2d\u76d1\u63a7\u7ba1\u7406\u7cfb\u7edf\t1\n\u96c6\u4e2d\u76d1\u63a7\u7ba1\u7406\u63a2\u9488\u7cfb\u7edf\t1\r\n\u5382\u5546\u8fc7\u5355\n\u5382\u5546\u5e74\u5ea6\u6700\u91cd\u8981\u7684\u9879\u76ee","contract_type":1,"progress_updated_at":"2021-06-24 15:44:17.770632+08","forecast_updated_at":"2021-08-13 09:38:05.481069+08","end_at":"2021-08-13 09:40:43","pinyin_shortcut":"dsjptxj","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":1361100,"profits":"48175.29000000000000","remain":"1430 days 07:43:28.333495","progress_remain":"1480 days 01:37:37.92643","forecast_remain":"1430 days 07:43:50.215993","lost_contact_days":"1426.2534224197","last_contact":"2021-08-17 11:17:00","last_arrive_days":"1426.2534224197","last_arrive":"2021-08-17 11:17:00+08","duration":"55 days 18:27:07.767183","issued_invoices":"1421100","client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","logo":null,"client_type":1,"client_class":43,"client_industry":1,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":1,"key":1,"name":"\u653f\u5e9c"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":8,"key":8,"name":"\u6295\u6807\u8bae\u4ef7","description":"\u51c6\u5907\u62db\u6807\u6587\u4ef6\u53ca\u4ef7\u683c\u3002\n\u6ce8\u610f\uff1a\u8d27\u671f\uff0c\u7a0e\u7387\uff0c\u6536\u6b3e\u6761\u4ef6\uff0c\u4fdd\u4fee\u6761\u4ef6"},"projectProductTypes":[{"id":85,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"697100.00","pct":"3.39","profit":"23631.69","project_id":2590},{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"724000.00","pct":"3.39","profit":"24543.6","project_id":2590}],"salesForecast":{"id":175,"key":175,"name":"100%","description":"\u6210\u529f\u7b7e\u8ba2\u5408\u540c"},"opportunityFrom":{"id":167,"key":167,"name":"\u5382\u5546\u4ecb\u7ecd"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","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"}},"projectCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"casePoints":null,"workLogCount":{"project_id":2590,"count":2},"caseCount":null,"salesTimeCount":{"project_id":2590,"hours":"6.78333333333333","times":2},"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":2590,"sum":"2030.05"},"buildContract":{"id":2014,"from_project":2590,"payment_collection_remind_ahead":"2 days","serial_no":"TS-ZHY_20210715T5","is_settle":false,"is_deliver":false,"is_outbound":false,"contractScans":[{"id":12243,"object_type":105,"object_id":2014,"attachment_id":8114,"attachment":{"id":8114,"key":8114,"name":"0eba5644-681f-31b2-9d77-020667f3a67f","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/0eba5644-681f-31b2-9d77-020667f3a67f\/2021_08_10_10_35_50.pdf","orig_name":"2021_08_10_10_35_50.pdf"}}],"receiptScans":[{"id":16349,"object_type":106,"object_id":2014,"attachment_id":11249,"attachment":{"id":11249,"key":11249,"name":"d9891cf8-049e-3b82-9f05-2db5b0e3f708","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/d9891cf8-049e-3b82-9f05-2db5b0e3f708\/\u5df2\u90ae\u4ef6\u7533\u8bf7\u4e0d\u6536\u56de\u7b7e\u6536\u5355.pdf","orig_name":"\u5df2\u90ae\u4ef6\u7533\u8bf7\u4e0d\u6536\u56de\u7b7e\u6536\u5355.pdf"}}],"verifyScans":[],"salesContractPayments":[{"id":1201,"key":1201,"contract_id":2014,"value":"1421100","created_by":1001,"created_at":"2021-08-13 09:40:43","collected_date":"2021-08-13","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":100}],"salesContractInvoices":[{"id":1096,"key":1096,"contract_id":2014,"value":"1421100.00","attachment_id":8031,"from_date":"2021-07-19","attachment":{"id":8031,"key":8031,"name":"a55627c6-6a6b-3e38-ab7a-da36ba668bcb","extension":"pdf","path":"\/v2\/attachment\/preview\/NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc\/a55627c6-6a6b-3e38-ab7a-da36ba668bcb\/\u4e2d\u5929\u950b\u53d1\u7968.pdf","orig_name":"\u4e2d\u5929\u950b\u53d1\u7968.pdf"}}],"salesContractPaymentCollectionRemindDates":[{"id":904,"key":904,"contract_id":2014,"name":"2021-07-02","value":"952770","overdue_days":42,"pct":67.04,"collect_status":"\u5df2\u5b8c\u6210"},{"id":905,"key":905,"contract_id":2014,"name":"2021-07-25","value":"408330","overdue_days":19,"pct":28.73,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPaymentCollectionRemindReceivers":[{"id":2854,"user_id":1005,"key":1005,"contract_id":2014,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"salesSupplierRels":[{"id":52,"contract_id":2014,"supplier_id":123,"purchase_id":2082,"supplier":{"id":123,"key":123,"name":"\u667a\u76df\u4e16\u7eaa(\u5317\u4eac)\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u5317\u8054\u84dd\u8baf\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":2082,"key":2082,"serial_no":"--"}},{"id":240,"contract_id":2014,"supplier_id":138,"purchase_id":2012,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"purchase":{"id":2012,"key":2012,"serial_no":"SFXSH202106230348"}},{"id":468,"contract_id":2014,"supplier_id":425,"purchase_id":2036,"supplier":{"id":425,"key":425,"name":"\u5317\u4eac\u6770\u521b\u8bda\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2036,"key":2036,"serial_no":"TSKJ20210715-HYF-001"}},{"id":642,"contract_id":2014,"supplier_id":138,"purchase_id":2046,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"purchase":{"id":2046,"key":2046,"serial_no":"SFXSH202107210185"}},{"id":854,"contract_id":2014,"supplier_id":424,"purchase_id":2017,"supplier":{"id":424,"key":424,"name":"\u5317\u4eac\u76db\u4e16\u7f51\u8fbe\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":2017,"key":2017,"serial_no":"TSKJ20210616-HYF-002"}},{"id":1294,"contract_id":2014,"supplier_id":314,"purchase_id":2016,"supplier":{"id":314,"key":314,"name":"\u5317\u4eac\u745e\u79d1\u8fdc\u4e1c\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2016,"key":2016,"serial_no":"rkyd20210618001"}}],"payment_collection_remind_ahead_display":"2\u5929"},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":2590,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"projectUsedClient":null,"remain_display":1430,"progress_remain_display":1480,"forecast_remain_display":1430,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":false,"unread":0,"last_arrive_days_display":"3\u5e74\u524d","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":false,"can_payment":false,"duration_display":55,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":false,"lost_contact_days_display":"3\u5e74\u524d","can_view_product":true,"budget_display":"142.11\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e"}],"pagenation":{"totalcount":8,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-13 17:21:55') RETURNING "id"