ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c149725c83e: POST https://beta.jinchangxiao.com/vue/project/get-edit at 2025-09-10 05:48:34 pm by 114.246.239.150

Log Messages

总计154条数据
TimeLevelCategoryMessage
 
17:48:34.378traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
17:48:34.378traceyii\base\Module::getModuleLoading module: debug
17:48:34.378traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
17:48:34.379traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
17:48:34.379traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
17:48:34.379traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:34.379traceyii\base\Module::getModuleLoading module: gii
17:48:34.379traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
17:48:34.379traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
17:48:34.379traceyii\web\Application::handleRequestRoute requested: 'vue/project/get-edit'
17:48:34.379traceyii\base\Module::getModuleLoading module: vue
17:48:34.379infoyii\web\Session::openSession started
17:48:34.380infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5064
17:48:34.380infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:48:34.384traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:34.385traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:48:34.385traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:34.385traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:48:34.385infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064
17:48:34.387traceyii\base\Controller::runActionRoute to run: vue/project/get-edit
17:48:34.387traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:34.388traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:48:34.388traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ProjectController::actionGetEdit()
17:48:34.389infoyii\db\Command::querySELECT p.*, now() - status_updated_at AS remain, now() - progress_updated_at AS progress_remain, now() - forecast_updated_at AS forecast_remain, CASE WHEN p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END AS duration, 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, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices AS i WHERE i.project_id = p.id) AS issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id 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 WHERE "p"."id"='3796' GROUP BY "p"."id"
17:48:34.392traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:34.392traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:48:34.393infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2125
17:48:34.394infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
17:48:34.394infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087)
17:48:34.395infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id"=6
17:48:34.395infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=47
17:48:34.396infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id"=20
17:48:34.396infoyii\db\Command::querySELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id"=1
17:48:34.396infoyii\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"=3796 ORDER BY "contribution" DESC, "engineer_id"
17:48:34.397traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:34.397traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:48:34.397infoyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=2
17:48:34.398infoyii\db\Command::querySELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"=3
17:48:34.398infoyii\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"=3796
17:48:34.399infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3796
17:48:34.399infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (5, 128, 142, 369)) ORDER BY "sort"
17:48:34.400infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3796
17:48:34.400infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (5, 128, 142, 369)) ORDER BY "sort"
17:48:34.400infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3796
17:48:34.401infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (5, 128, 142, 369)) ORDER BY "sort"
17:48:34.401infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
17:48:34.401infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087)
17:48:34.402infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
17:48:34.402infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
17:48:34.402infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087)
17:48:34.403infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2125
17:48:34.403infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
17:48:34.404infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087)
17:48:34.404infoyii\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"=3796 GROUP BY "c"."project_id"
17:48:34.409traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:34.409traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:48:34.409infoyii\db\Command::querySELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("project_id"=3796) GROUP BY "project_id"
17:48:34.410infoyii\db\Command::querySELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "project_id"=3796 GROUP BY "project_id"
17:48:34.411infoyii\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"=3796) GROUP BY "project_id"
17:48:34.411infoyii\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"=3796) GROUP BY "c"."project_id"
17:48:34.416infoyii\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"=3796) GROUP BY "c"."project_id"
17:48:34.418infoyii\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"=3796) GROUP BY "project_id"
17:48:34.418infoyii\db\Command::querySELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id"=3796) GROUP BY "project_id"
17:48:34.420infoyii\db\Command::querySELECT "id", "from_project", "payment_collection_remind_ahead", "serial_no", "is_settle", "is_deliver", "is_outbound", "erp_settle_amount", "erp_un_settle_amount", "including_tax", "amount" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3796
17:48:34.420infoyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3796
17:48:34.421infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:48:34.421infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
17:48:34.421infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3796
17:48:34.422infoyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id"=3796) GROUP BY "object_id"
17:48:34.451infoyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=1) AND (remind_user_id = 5064 AND is_read = false) AND ("object_id"=3796) GROUP BY "object_id"
17:48:34.469infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=3796
17:48:34.470infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3796)
17:48:34.470infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id"=3796
17:48:34.471infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id"=188
17:48:34.471infoyii\db\Command::querySELECT "id", "id" AS "key", "project_used_client_id", "remind_date", "amount", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id"=188
17:48:34.472infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id"=188
17:48:34.472infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id"=188
17:48:34.473infoyii\db\Command::querySELECT s.id, project_id, client_id, schedule_title, complete_at, start_at, end_at, created_by, is_complete, is_closed, complete_description, set_top_at, CASE WHEN is_complete = true THEN 3 WHEN is_complete = false AND end_at <= NOW() THEN 2 ELSE 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (("is_complete"=FALSE) OR ("complete_at" >= '2025-08-27')) AND ((("is_public"=1) AND ("created_by" != 5064)) OR ("created_by"=5064) OR ("ccr"."user_id"=5064)) AND ("s"."project_id"=3796) ORDER BY set_top_at DESC nulls last, sort ASC, CASE WHEN is_complete = true THEN complete_at END DESC, CASE WHEN is_complete = false THEN end_at END ASC, end_at DESC
17:48:34.475traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:34.475traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:48:34.475infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
17:48:34.475infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087)
17:48:34.476infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE "schedule_id"=17677 ORDER BY "created_at" DESC
17:48:34.477traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:34.478traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:34.479infoyii\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 (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 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, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5064) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5064))) AND ("p"."id"=3796))
17:48:34.480traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:34.480traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:48:34.480infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2125
17:48:34.481infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_user_visit_clients" WHERE ("user_id"=5064) AND ("client_id"=2125))
17:48:34.481traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewProduct
17:48:34.481traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
17:48:34.481traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:48:34.482traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: createSchedule
17:48:34.482traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
17:48:34.482traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
17:48:34.482traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
17:48:34.482traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
17:48:34.482traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 电话销售
17:48:34.482traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
17:48:34.482traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesManager
17:48:34.482traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 人力资源
17:48:34.482traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesDirector
17:48:34.482traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: GM
17:48:34.482traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 软件开发
17:48:34.482traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: updateSchedule
17:48:34.482traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
17:48:34.482traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
17:48:34.482traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
17:48:34.482traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:48:34.482infoyii\db\Command::querySELECT product_type_id, name, sum(budget) as sum_budget, sum(profit) as sum_profit FROM "a57be577deb434"."tbl_project_product_types" "pt" WHERE "project_id"=3796 GROUP BY "product_type_id", "name"
17:48:34.483infoyii\db\Command::querySELECT product_type_id, name, count(it.id) as value FROM "a57be577deb434"."tbl_implement_product_types" "it" WHERE "implement_id" IN (SELECT "ir"."id" FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = ir.case_id WHERE ("ir"."is_draft"=FALSE) AND ("c"."project_id"=3796)) GROUP BY "product_type_id", "name"
17:48:34.486infoyii\db\Command::querySELECT w.scenario_option_id, wso.name, count(w.id) as value FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wso" ON w.scenario_option_id = wso.id WHERE ("w"."is_draft"=FALSE) AND ("w"."scenario_id"=1) AND ("w"."project_id"=3796) GROUP BY "w"."scenario_option_id", "wso"."name"
17:48:34.487infoyii\db\Command::querySELECT *, CASE WHEN collected >= total_this THEN 1 ELSE 0 END as status FROM (SELECT scpcrd.* ,( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_sales_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), p.collected, sc.project_id FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON scpcrd.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id WHERE (sc.from_project is not null) AND ("p"."id"=3796)) "sub" ORDER BY "remind_date" DESC
17:48:34.488infoyii\db\Command::querySELECT "remind_user" FROM "a57be577deb434"."tbl_contract_default_remind_users" WHERE ("user_id"=5064) AND ("type"=1)
17:48:34.489infoyii\db\Command::querySELECT *, CASE WHEN used_client_collected >= total_this THEN 1 ELSE 0 END as status FROM (SELECT scpcrd.* ,( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_project_used_client_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.project_used_client_id = scpcrd.project_used_client_id ), p.used_client_collected, sc.project_id FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_project_used_clients" "sc" ON scpcrd.project_used_client_id = sc.id LEFT JOIN (SELECT t0.project_id AS project_id, COALESCE(sum(t0.budget), 0) as used_client_budget, COALESCE(sum(t1.amount), 0) AS used_client_collected FROM "a57be577deb434"."tbl_project_used_clients" "t0" LEFT JOIN "a57be577deb434"."tbl_project_used_client_payments" "t1" ON t0.id = t1.project_used_client_id GROUP BY "t0"."project_id") "p" ON sc.project_id = p.project_id WHERE "sc"."project_id"=3796) "sub" ORDER BY "remind_date" DESC
17:48:34.491infoyii\db\Command::querySELECT "esgps".* FROM "a57be577deb434"."tbl_erp_sales_gift_products" "esgps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "esgs" ON esgps.erp_sales_gift_id = esgs.id WHERE "esgs"."project_id"=3796
17:48:34.491infoyii\db\Command::querySELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "is_delete"=FALSE ORDER BY "order", "id"
17:48:34.492infoyii\db\Command::querySELECT "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("is_delete"=FALSE) ORDER BY "sort", "id"
17:48:34.492infoyii\db\Command::querySELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("is_delete"=FALSE) ORDER BY "sort", "id"
17:48:34.493infoyii\db\Command::querySELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("is_delete"=FALSE) ORDER BY "sort", "id"
17:48:34.493infoyii\db\Command::querySELECT "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "is_delete"=FALSE ORDER BY "order"
17:48:34.493traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: changeProjectStatus3
17:48:34.493traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesManager
17:48:34.493traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:48:34.493traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: changeProjectStatus4
17:48:34.493traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesManager
17:48:34.493traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:48:34.493traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: changeProjectStatus5
17:48:34.493traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesManager
17:48:34.493traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:48:34.494infoyii\db\Command::querySELECT "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (1, 2, 3, 4, 5) ORDER BY "order"
17:48:34.494infoyii\db\Command::querySELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" "urcl" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON urcl.user_id = u.id WHERE ("role_name"='Engineer') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2025-09-10 17:48:34, 2025-09-10 17:48:34]'::tsrange) GROUP BY "user_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
17:48:34.495traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:34.495traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:48:34.495infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "department_id", "pinyin_shortcut" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND ("id" IN (5085, 5248, 1015, 1022, 1023)) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
17:48:34.496infoyii\db\Command::querySELECT "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "is_delete"=FALSE ORDER BY "sort"
17:48:34.496infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" ORDER BY "order"
17:48:34.496infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "department_id", "pinyin_shortcut" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND ("department_id" IN (4, 1, 2, 3, 9, 8, 6, 7, 10)) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
17:48:34.497infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1000, 5250, 5016, 1011, 5085, 5332, 5446, 1001, 5087, 5300, 5311, 5252, 5295, 5248, 1013, 1015, 1022, 5388, 5064, 1004, 5360, 1005, 5449, 1023))
17:48:34.497infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" ORDER BY "order"
17:48:34.498infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "department_id", "pinyin_shortcut" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND ("department_id" IN (4, 1, 2, 3, 9, 8, 6, 7, 10)) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
17:48:34.498infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1000, 5250, 5016, 1011, 5085, 5332, 5446, 1001, 5087, 5300, 5311, 5252, 5295, 5248, 1013, 1015, 1022, 5388, 5064, 1004, 5360, 1005, 5449, 1023))
17:48:34.499traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:34.499traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:48:34.500infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("user_id"=5064) AND ("object_type"=1) AND ("object_id"='3796')
17:48:34.500traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:34.500traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:48:34.500infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_object_histories" SET "last_visit_at"='now()' WHERE "id"=186841
17:48:34.501infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_visit_object_histories" WHERE "user_id"=5064 ORDER BY "last_visit_at" DESC LIMIT 10
17:48:34.502infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("id" NOT IN (186841, 186840, 186339, 186338, 186786, 186784, 186785, 186337, 186336, 186335)) AND ("user_id"=5064)
17:48:34.502infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5064, 5, 'vue/project/get-edit', '{"id":"3796","web_access_token":"LDTcnA1-CvwkRlebCRg_-13YT_Nb9wuu"}', '{"code":2000,"result":{"model":{"id":3796,"client_id":2125,"project_status":2,"project_progress":3,"budget":"790000","profit_pct":"25","bargain_date":"2025-09-10","description":"","created_by":5087,"created_at":"2025-03-09 10:00:35","updated_at":"2025-09-10 17:48:33","engineer_id":"","project_title":"deepseek\u79c1\u6709\u5316\u90e8\u7f72-239-K","collected":"0","status_updated_at":"2025-09-10 17:48:33.816744+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-05-25 16:43:18.119966+08","forecast_updated_at":"2025-05-25 16:43:18.119966+08","end_at":"","pinyin_shortcut":"deepseeksyhbs239K","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":"","is_sales_order_ready":true,"collected_plan":0,"change_status_to":3,"is_verify":true,"remain":"00:00:00.573826","progress_remain":"108 days 01:05:16.270604","forecast_remain":"108 days 01:05:16.270604","duration":"185 days 07:47:59.259051","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","issued_invoices":"","client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382","logo":"","client_type":6,"client_class":47,"client_industry":20,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"usedClient":{},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3796,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":3,"key":3,"name":"\u65b9\u6848\u8bbe\u8ba1","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u9762\u4e34\u7684\u95ee\u9898\u53ca\u6311\u6218\uff0c \u63d0\u51fa\u6211\u65b9\u7684\u4ea7\u54c1\u65b9\u6848\u3002\u5177\u4f53\u7684\u54c1\u724c\uff0c \u578b\u53f7\uff0c\u914d\u7f6e\uff0c\u4fdd\u4fee\u3002 \n\u65b9\u6cd5\uff1a\u5c06\u5ba2\u6237\u7684\u95ee\u9898\u53ca\u9700\u6c42\u7528\u6587\u5b57\u63cf\u8ff0\u51fa\u6765\uff0c\u4ea4\u7ed9\u552e\u524d\u6216\u5382\u5546\u3002"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"790000.00","pct":"25","profit":"197500","project_id":3796}],"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":{},"purchaseType":{"id":128,"key":128,"name":"\u516c\u5f00\u62db\u6807"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"casePoints":{"project_id":3796,"points":"31"},"workLogCount":"","caseCount":{"project_id":3796,"count":1},"salesTimeCount":{},"implementTimeCount":{"project_id":3796,"sum":"2.01666666666667","times":"1"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":3796,"sum":"119.63"},"buildContract":{},"projectRemindReceivers":[{"id":1779,"user_id":1001,"key":1001,"project_id":3796,"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"}}}],"projectProductRels":[],"commentCount":{"object_id":3796,"comment":1},"unreadComments":{},"fromContact":"","projectContactPoints":[],"erpSalesOrder":"","projectUsedClient":{"id":188,"project_id":3796,"used_client":"","budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","usedClient":{},"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":"","over_due_display":"","over_due_uncollected":0},"schedules":[{"id":17677,"project_id":3796,"client_id":2125,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u65b9\u6848\u8bbe\u8ba1\n\u76ee\u7684\uff1a\u786e\u5b9a\u914d\u7f6e\u65b9\u6848\n\u52a8\u4f5c\uff1a\u8054\u7cfb\u5e9e\u8001\u5e08","complete_at":"","start_at":"","end_at":"2025-10-31 00:00:00","created_by":5087,"is_complete":false,"is_closed":false,"complete_description":"","set_top_at":"","sort":1,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"scheduleDescriptions":[{"id":16098,"schedule_id":17677,"description":"\u4e0a\u5468 \u603b\u7ed3 \uff1a\u8d85\u7b97\u548c\u667a\u7b97\u6ca1\u6709\u5206\u4fdd\u6807\u51c6\uff0c\u95e8\u6237\u7cfb\u7edf\u548c\u524d\u540e\u5904\u7406\u6a21\u5757\u9700\u8981\u8fc7\u5206\u4fdd\uff0c\u672c\u5468\u8ba1\u5212\uff1a\u8054\u7cfb\u5e9e\u8001\u5e08","created_at":"2025-08-31 22:35:27","created_at_display":"08-31 22:35"},{"id":15925,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0\uff0c\u672c\u5468\u8ba1\u5212\uff1a\u4e86\u89e3\u5927\u6a21\u578b\u5efa\u8bbe\u6d4b\u8bc4\u662f\u5426\u6709\u6807\u51c6\u3002","created_at":"2025-08-25 00:05:16","created_at_display":"08-25 00:05"},{"id":15634,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u8054\u7cfb\u5e9e\u8001\u5e08\u4e86\u89e3\u8fdb\u5ea6\uff0c\u73b0\u5728\u95ee\u9898\u662f\u5927\u6a21\u578b\u5efa\u8bbe\u80fd\u4e0d\u80fd\u8fc7\u6d4b\u8bc4 \u672c\u5468\u8ba1\u5212\uff1a\u4e86\u89e3\u5927\u6a21\u578b\u5efa\u8bbe\u6d4b\u8bc4\u662f\u5426\u51fa\u6807\u51c6\u4e86\uff0c\u95ee\u5382\u5546\u6709\u6ca1\u6709\u8fc7\u6d4b\u7684\u6848\u4f8b","created_at":"2025-08-11 00:03:48","created_at_display":"08-11 00:03"},{"id":15520,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-08-03 22:32:18","created_at_display":"08-03 22:32"},{"id":15303,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0\u3002\u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-07-27 14:02:59","created_at_display":"07-27 14:02"},{"id":15149,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0\u3002","created_at":"2025-07-20 14:52:26","created_at_display":"07-20 14:52"},{"id":14994,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0\uff0c\u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-07-13 23:41:09","created_at_display":"07-13 23:41"},{"id":14798,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0\uff0c\u672c\u5468\u8ba1\u5212\uff1a\u65e0\u3002","created_at":"2025-07-06 22:35:29","created_at_display":"07-06 22:35"},{"id":14715,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0\u3002\u672c\u5468\u8ba1\u5212\uff1a\u65e0\u3002","created_at":"2025-06-30 05:35:56","created_at_display":"06-30 05:35"},{"id":14555,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0\u3002\u672c\u5468\u8ba1\u5212\uff1a\u65e0\u3002","created_at":"2025-06-23 00:01:22","created_at_display":"06-23 00:01"},{"id":14378,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u8054\u7cfb\u8303\u4e3b\u4efb\u9879\u76ee\u6ca1\u6709\u8fdb\u5c55\u3002\u672c\u5468\u8ba1\u5212 \uff1a\u65e0\u3002","created_at":"2025-06-15 23:29:18","created_at_display":"06-15 23:29"},{"id":14276,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0\u3002\u672c\u5468\u8ba1\u5212 \uff1a\u8054\u7cfb\u8303\u4e3b\u4efb\u63a8\u8fdb\u9879\u76ee\u3002","created_at":"2025-06-08 23:32:18","created_at_display":"06-08 23:32"},{"id":14033,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0\uff0c\u672c\u5468\u8ba1\u5212\uff1a\u65e0\u3002","created_at":"2025-06-02 19:01:59","created_at_display":"06-02 19:01"},{"id":13861,"schedule_id":17677,"description":"\u4e0a\u5468\u9879\u76ee \u8ddf\u8fdb\uff0c\u672c\u5468\u65e0\u3002","created_at":"2025-05-25 16:28:22","created_at_display":"05-25 16:28"},{"id":13723,"schedule_id":17677,"description":"\u4e0a\u5468\u8054\u7cfb\u5e9e\u8001\u5e08\uff0c\u672c\u5468\u8ddf\u8fdb\u9879\u76ee\u3002","created_at":"2025-05-18 23:08:37","created_at_display":"05-18 23:08"},{"id":13565,"schedule_id":17677,"description":"\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u65e0\u3002","created_at":"2025-05-12 00:30:55","created_at_display":"05-12 00:30"},{"id":13377,"schedule_id":17677,"description":"\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u65e0\u3002","created_at":"2025-05-05 23:07:15","created_at_display":"05-05 23:07"},{"id":13211,"schedule_id":17677,"description":"\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u65e0\u3002","created_at":"2025-04-27 23:26:57","created_at_display":"04-27 23:26"},{"id":13039,"schedule_id":17677,"description":"\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u65e0\u3002","created_at":"2025-04-20 22:15:24","created_at_display":"04-20 22:15"},{"id":12834,"schedule_id":17677,"description":"\u4e0a\u5468\u8ddf\u8fdb\uff0c\u672c\u5468\u65e0 \u3002","created_at":"2025-04-13 08:15:55","created_at_display":"04-13 08:15"},{"id":12681,"schedule_id":17677,"description":"\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u8ddf\u8fdb\u3002","created_at":"2025-04-05 09:00:09","created_at_display":"04-05 09:00"},{"id":12525,"schedule_id":17677,"description":"\u4e0a\u5468\u8054\u7cfb\u5e9e\u8001\u5e08\uff0c\u672c\u5468\u7ee7\u7eed\u8ddf\u8fdb\u3002","created_at":"2025-03-29 08:26:18","created_at_display":"03-29 08:26"},{"id":12430,"schedule_id":17677,"description":"\u4e0a\u5468\u62a5\u4ef7\uff0c\u672c\u5468\u8ddf\u8fdb\u3002","created_at":"2025-03-23 23:33:23","created_at_display":"03-23 23:33"},{"id":12282,"schedule_id":17677,"description":"\u4e0a\u5468\u8054\u7cfb\u5e9e\u8001\u5e08\uff0c\u672c\u5468\u7ed9\u51fa\u62a5\u4ef7\u3002","created_at":"2025-03-16 08:36:29","created_at_display":"03-16 08:36"}],"schedule_status":0,"complete_at_display":"","complete_at_display2":"","end_at_display":"10-31 00:00","end_at_display2":"","is_overdue":false,"start_at_display":"","can_report":false,"can_update":true}],"remain_display":0,"progress_remain_display":108,"forecast_remain_display":108,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":790000,"is_exceeded":false,"can_update":false,"can_delete":true,"unread":0,"last_arrive_days_display":"","project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_invoice":false,"can_payment":false,"duration_display":185,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"","can_view_product":true,"budget_display":"79\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","verify_display":1,"un_collected":0,"un_invoiced":0,"is_only_cp":false,"profit":197500,"bargain_date_display":"2025\u5e7409\u670810\u65e5","over_due_display":"","over_due_uncollected":0,"defaultSalesContractPaymentCollectionRemindReceivers":[5449,5087],"erpSalesGiftProducts":[],"p_total_amount":0,"p_total_cost":0,"p_un_budget":790000,"p_m_total_amount":0,"p_m_total_amount_pct":0,"p_j_total_amount_pct":0,"p_j_total_amount":-119.63,"budgetCounts":[{"product_type_id":2,"name":"\u670d\u52a1\u5668","sum_budget":"790000.00","sum_profit":"197500","y":100}],"implementTimes":[{"product_type_id":2,"name":"\u670d\u52a1\u5668","value":1,"y":100}],"salesTimes":[],"can_view_implement":true,"can_view_work_log":true,"can_create_task_group":true},"paymentRemindDateList":[],"projectUsedClientPaymentRemindDateList":[],"options":{"Projects[projectProductTypes]":{"key":"Projects[projectProductTypes]","name":"\u5546\u673a\u7c7b\u578b","value":[{"key":2,"name":"\u670d\u52a1\u5668"},{"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},{"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},{"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},{"key":88,"name":"\u79c1\u6709\u4e91"},{"key":8,"name":"\u4e91\u684c\u9762"},{"key":7,"name":"\u8f6f\u4ef6"},{"key":10,"name":"\u56fe\u5f62\u5de5\u4f5c\u7ad9"},{"key":69,"name":"\u5907\u4efd"},{"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},{"key":12,"name":"\u7b14\u8bb0\u672c"},{"key":13,"name":"\u6253\u5370\u673a"},{"key":14,"name":"UPS"},{"key":16,"name":"\u8fd0\u7ef4\u670d\u52a1"},{"key":17,"name":"\u5de5\u63a7\u673a"},{"key":18,"name":"\u673a\u623f\u8bbe\u5907"},{"key":19,"name":"\u6280\u672f\u670d\u52a1"},{"key":20,"name":"\u529e\u516c\u8bbe\u5907"},{"key":21,"name":"\u6570\u7801\u8bbe\u5907"},{"key":22,"name":"\u670d\u52a1"},{"key":23,"name":"\u793c\u54c1"},{"key":75,"name":"\u8f6f\u4ef6\u5f00\u53d1"}]},"Projects[salesForecast]":{"key":"Projects[salesForecast]","name":"\u9500\u552e\u9884\u6d4b","value":[{"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"},{"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"},{"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%"},{"key":232,"name":"\u5382\u5546\u8fc7\u5355","description":"\u4fdd\u63015%\u57fa\u672c\u5229\u6da6\u7387\uff0c\u5e2e\u52a9\u5382\u5546\u4ea4\u4ed8\u9879\u76ee\u3002"}]},"Projects[purchaseType]":{"key":"Projects[purchaseType]","name":"\u91c7\u8d2d\u65b9\u5f0f","value":[{"key":128,"name":"\u516c\u5f00\u62db\u6807"},{"key":129,"name":"\u7279\u7ea6\u9080\u6807"},{"key":130,"name":"\u7ade\u4e89\u8c08\u5224"},{"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},{"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},{"key":182,"name":"\u56f4\u6807"}]},"Projects[opportunityFrom]":{"key":"Projects[opportunityFrom]","name":"\u5546\u673a\u6765\u6e90","value":[{"key":131,"name":"\u5e7f\u544a\u63a8\u5e7f"},{"key":132,"name":"\u5ba2\u6237\u4ecb\u7ecd"},{"key":167,"name":"\u5382\u5546\u4ecb\u7ecd"},{"key":168,"name":"\u670b\u53cb\u4ecb\u7ecd"},{"key":169,"name":"\u540c\u5b66\u4ecb\u7ecd"},{"key":170,"name":"\u601d\u79d1MSO"},{"key":171,"name":"cold call"},{"key":179,"name":"\u8001\u5ba2\u6237"},{"key":180,"name":"\u5382\u5546\u7529\u5355"}]},"Projects[project_progress]":{"key":"Projects[project_progress]","name":"\u9500\u552e\u9636\u6bb5","value":[{"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"},{"key":3,"name":"\u65b9\u6848\u8bbe\u8ba1","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u9762\u4e34\u7684\u95ee\u9898\u53ca\u6311\u6218\uff0c \u63d0\u51fa\u6211\u65b9\u7684\u4ea7\u54c1\u65b9\u6848\u3002\u5177\u4f53\u7684\u54c1\u724c\uff0c \u578b\u53f7\uff0c\u914d\u7f6e\uff0c\u4fdd\u4fee\u3002 \n\u65b9\u6cd5\uff1a\u5c06\u5ba2\u6237\u7684\u95ee\u9898\u53ca\u9700\u6c42\u7528\u6587\u5b57\u63cf\u8ff0\u51fa\u6765\uff0c\u4ea4\u7ed9\u552e\u524d\u6216\u5382\u5546\u3002"},{"key":4,"name":"\u786e\u8ba4\u65b9\u6848","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u7684\u53cd\u9988\uff0c\u4e0d\u65ad\u4f18\u5316\u89e3\u51b3\u65b9\u6848\uff0c\u76f4\u5230\u5ba2\u6237\u53e3\u5934\u6216\u4e66\u9762\u8ba4\u53ef\u65b9\u6848\u3002 \n\u65b9\u6cd5\uff1a\u4f7f\u7528\u573a\u666f\uff0c\u95ee\u9898\uff0c\u9700\u6c42\uff0c\u4ea7\u54c1\u53ca\u529f\u80fd\u7684\u65b9\u6cd5\u8bb2\u89e3\u65b9\u6848\u3002"},{"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"},{"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},{"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"},{"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},{"key":49,"name":"\u6536\u6b3e\u4e2d","description":"\u5b9a\u4e49\uff1a\u5f00\u53d1\u7968\uff0c\u5b8c\u6210\u6536\u6b3e \u3002\n\u65b9\u6cd5\uff1a\u5411\u8d22\u52a1\u7533\u8bf7\u5f00\u53d1\u7968\u3002"}]},"Projects[project_status]":{"key":"Projects[project_status]","name":"\u5546\u673a\u72b6\u6001","value":[{"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},{"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},{"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},{"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},{"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"}]},"ProjectArchitects[engineer_id]":{"key":"ProjectArchitects[engineer_id]","name":"\u552e\u524d\u652f\u6301","value":[{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","department_id":2,"pinyin_shortcut":"hdy"},{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99","department_id":2,"pinyin_shortcut":"wjl"},{"id":1015,"key":1015,"name":"\u5434\u660a","department_id":2,"pinyin_shortcut":"wh"},{"id":1022,"key":1022,"name":"\u5f90\u7855","department_id":2,"pinyin_shortcut":"xs"},{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","department_id":2,"pinyin_shortcut":"zzj"}]},"Projects[contract_type]":{"key":"Projects[contract_type]","name":"\u5408\u540c\u7c7b\u578b","value":[{"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},{"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"}]},"Projects[payment_collection_remind_ahead]":{"key":"Projects[payment_collection_remind_ahead]","name":"\u6536\u6b3e\u63d0\u9192\u65f6\u95f4","value":[{"key":"","name":"\u4e0d\u63d0\u9192"},{"key":"1 day","name":"\u63d0\u524d1\u5929"},{"key":"2 days","name":"\u63d0\u524d2\u5929"},{"key":"7 days","name":"\u63d0\u524d7\u5929"},{"key":"15 days","name":"\u63d0\u524d15\u5929"},{"key":"30 days","name":"\u63d0\u524d30\u5929"}]},"Projects[projectUsedClient][remind_ahead]":{"key":"Projects[projectUsedClient][remind_ahead]","name":"\u7528\u6237\u6536\u6b3e\u63d0\u9192\u65f6\u95f4","value":[{"key":"","name":"\u4e0d\u63d0\u9192"},{"key":"1 day","name":"\u63d0\u524d1\u5929"},{"key":"2 days","name":"\u63d0\u524d2\u5929"},{"key":"7 days","name":"\u63d0\u524d7\u5929"},{"key":"15 days","name":"\u63d0\u524d15\u5929"},{"key":"30 days","name":"\u63d0\u524d30\u5929"}]},"Projects[projectRemindReceivers]":{"key":"Projects[projectRemindReceivers]","name":" \u6284\u9001\u4eba","value":[{"id":4,"key":4,"name":"\u603b\u7ecf\u7406","child":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","department_id":4,"pinyin_shortcut":"lrc","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}]},{"id":1,"key":1,"name":"\u9500\u552e\u90e8","child":[{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","department_id":1,"pinyin_shortcut":"hwc","avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"}},{"id":5087,"key":5087,"name":"\u5218\u5fae","department_id":1,"pinyin_shortcut":"lw","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","department_id":1,"pinyin_shortcut":"sqy","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","department_id":1,"pinyin_shortcut":"wzw","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","department_id":1,"pinyin_shortcut":"yjc","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","department_id":1,"pinyin_shortcut":"zhy","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},{"id":5449,"key":5449,"name":"\u5468\u4e3d\u98de","department_id":1,"pinyin_shortcut":"zlf","avatar":{}}]},{"id":2,"key":2,"name":"\u6280\u672f\u90e8","child":[{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","department_id":2,"pinyin_shortcut":"hdy","avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"}},{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99","department_id":2,"pinyin_shortcut":"wjl","avatar":{"id":135,"user_id":5248,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b4458545-7f88-3479-97be-6f43b2b50454.png"}},{"id":1015,"key":1015,"name":"\u5434\u660a","department_id":2,"pinyin_shortcut":"wh","avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"}},{"id":1022,"key":1022,"name":"\u5f90\u7855","department_id":2,"pinyin_shortcut":"xs","avatar":{"id":6,"user_id":1022,"name":"\/files\/cdn\/a57be577deb434\/avatar\/2b5ec94d-d83c-38b4-ac3a-38720c369f91.png"}},{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","department_id":2,"pinyin_shortcut":"zzj","avatar":{"id":4,"user_id":1023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg"}}]},{"id":3,"key":3,"name":"\u5546\u52a1\u90e8","child":[{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","department_id":3,"pinyin_shortcut":"hyf","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","department_id":3,"pinyin_shortcut":"zhf","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}]},{"id":9,"key":9,"name":"\u9879\u76ee\u90e8","child":[{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","department_id":9,"pinyin_shortcut":"tskj","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}]},{"id":8,"key":8,"name":"\u4eba\u529b\u8d44\u6e90","child":[{"id":5446,"key":5446,"name":"\u5218\u5a1f","department_id":8,"pinyin_shortcut":"lj","avatar":{"id":164,"user_id":5446,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5631bbfb-fa6e-308e-b87c-b159e8042209.jpg"}}]},{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8","child":[{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","department_id":6,"pinyin_shortcut":"wxx","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","department_id":6,"pinyin_shortcut":"yyx","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}]},{"id":7,"key":7,"name":"\u5e93\u623f\u90e8","child":[{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","department_id":7,"pinyin_shortcut":"wjc","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}]},{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1","child":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","department_id":10,"pinyin_shortcut":"cys","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"}},{"id":5250,"key":5250,"name":"\u8463\u8363","department_id":10,"pinyin_shortcut":"dr","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}},{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","department_id":10,"pinyin_shortcut":"gjy","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}},{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","department_id":10,"pinyin_shortcut":"yxc","avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}}]}]},"Projects[salesContractPaymentCollectionRemindReceivers]":{"key":"Projects[salesContractPaymentCollectionRemindReceivers]","name":"\u6536\u6b3e\u63d0\u9192\u4eba","value":[{"id":4,"key":4,"name":"\u603b\u7ecf\u7406","child":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","department_id":4,"pinyin_shortcut":"lrc","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}]},{"id":1,"key":1,"name":"\u9500\u552e\u90e8","child":[{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","department_id":1,"pinyin_shortcut":"hwc","avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"}},{"id":5087,"key":5087,"name":"\u5218\u5fae","department_id":1,"pinyin_shortcut":"lw","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","department_id":1,"pinyin_shortcut":"sqy","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","department_id":1,"pinyin_shortcut":"wzw","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","department_id":1,"pinyin_shortcut":"yjc","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","department_id":1,"pinyin_shortcut":"zhy","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},{"id":5449,"key":5449,"name":"\u5468\u4e3d\u98de","department_id":1,"pinyin_shortcut":"zlf","avatar":{}}]},{"id":2,"key":2,"name":"\u6280\u672f\u90e8","child":[{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","department_id":2,"pinyin_shortcut":"hdy","avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"}},{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99","department_id":2,"pinyin_shortcut":"wjl","avatar":{"id":135,"user_id":5248,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b4458545-7f88-3479-97be-6f43b2b50454.png"}},{"id":1015,"key":1015,"name":"\u5434\u660a","department_id":2,"pinyin_shortcut":"wh","avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"}},{"id":1022,"key":1022,"name":"\u5f90\u7855","department_id":2,"pinyin_shortcut":"xs","avatar":{"id":6,"user_id":1022,"name":"\/files\/cdn\/a57be577deb434\/avatar\/2b5ec94d-d83c-38b4-ac3a-38720c369f91.png"}},{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","department_id":2,"pinyin_shortcut":"zzj","avatar":{"id":4,"user_id":1023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg"}}]},{"id":3,"key":3,"name":"\u5546\u52a1\u90e8","child":[{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","department_id":3,"pinyin_shortcut":"hyf","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","department_id":3,"pinyin_shortcut":"zhf","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}]},{"id":9,"key":9,"name":"\u9879\u76ee\u90e8","child":[{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","department_id":9,"pinyin_shortcut":"tskj","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}]},{"id":8,"key":8,"name":"\u4eba\u529b\u8d44\u6e90","child":[{"id":5446,"key":5446,"name":"\u5218\u5a1f","department_id":8,"pinyin_shortcut":"lj","avatar":{"id":164,"user_id":5446,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5631bbfb-fa6e-308e-b87c-b159e8042209.jpg"}}]},{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8","child":[{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","department_id":6,"pinyin_shortcut":"wxx","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","department_id":6,"pinyin_shortcut":"yyx","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}]},{"id":7,"key":7,"name":"\u5e93\u623f\u90e8","child":[{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","department_id":7,"pinyin_shortcut":"wjc","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}]},{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1","child":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","department_id":10,"pinyin_shortcut":"cys","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"}},{"id":5250,"key":5250,"name":"\u8463\u8363","department_id":10,"pinyin_shortcut":"dr","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}},{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","department_id":10,"pinyin_shortcut":"gjy","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}},{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","department_id":10,"pinyin_shortcut":"yxc","avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}}]}]},"Projects[projectUsedClient][projectUsedClientPaymentCollectionRemindReceivers]":{"key":"Projects[projectUsedClient][projectUsedClientPaymentCollectionRemindReceivers]","name":"\u7528\u6237\u6536\u6b3e\u63d0\u9192\u4eba","value":[{"id":4,"key":4,"name":"\u603b\u7ecf\u7406","child":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","department_id":4,"pinyin_shortcut":"lrc","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}]},{"id":1,"key":1,"name":"\u9500\u552e\u90e8","child":[{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","department_id":1,"pinyin_shortcut":"hwc","avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"}},{"id":5087,"key":5087,"name":"\u5218\u5fae","department_id":1,"pinyin_shortcut":"lw","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","department_id":1,"pinyin_shortcut":"sqy","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","department_id":1,"pinyin_shortcut":"wzw","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","department_id":1,"pinyin_shortcut":"yjc","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","department_id":1,"pinyin_shortcut":"zhy","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},{"id":5449,"key":5449,"name":"\u5468\u4e3d\u98de","department_id":1,"pinyin_shortcut":"zlf","avatar":{}}]},{"id":2,"key":2,"name":"\u6280\u672f\u90e8","child":[{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","department_id":2,"pinyin_shortcut":"hdy","avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"}},{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99","department_id":2,"pinyin_shortcut":"wjl","avatar":{"id":135,"user_id":5248,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b4458545-7f88-3479-97be-6f43b2b50454.png"}},{"id":1015,"key":1015,"name":"\u5434\u660a","department_id":2,"pinyin_shortcut":"wh","avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"}},{"id":1022,"key":1022,"name":"\u5f90\u7855","department_id":2,"pinyin_shortcut":"xs","avatar":{"id":6,"user_id":1022,"name":"\/files\/cdn\/a57be577deb434\/avatar\/2b5ec94d-d83c-38b4-ac3a-38720c369f91.png"}},{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","department_id":2,"pinyin_shortcut":"zzj","avatar":{"id":4,"user_id":1023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg"}}]},{"id":3,"key":3,"name":"\u5546\u52a1\u90e8","child":[{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","department_id":3,"pinyin_shortcut":"hyf","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","department_id":3,"pinyin_shortcut":"zhf","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}]},{"id":9,"key":9,"name":"\u9879\u76ee\u90e8","child":[{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","department_id":9,"pinyin_shortcut":"tskj","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}]},{"id":8,"key":8,"name":"\u4eba\u529b\u8d44\u6e90","child":[{"id":5446,"key":5446,"name":"\u5218\u5a1f","department_id":8,"pinyin_shortcut":"lj","avatar":{"id":164,"user_id":5446,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5631bbfb-fa6e-308e-b87c-b159e8042209.jpg"}}]},{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8","child":[{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","department_id":6,"pinyin_shortcut":"wxx","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","department_id":6,"pinyin_shortcut":"yyx","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}]},{"id":7,"key":7,"name":"\u5e93\u623f\u90e8","child":[{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","department_id":7,"pinyin_shortcut":"wjc","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}]},{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1","child":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","department_id":10,"pinyin_shortcut":"cys","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"}},{"id":5250,"key":5250,"name":"\u8463\u8363","department_id":10,"pinyin_shortcut":"dr","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}},{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","department_id":10,"pinyin_shortcut":"gjy","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}},{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","department_id":10,"pinyin_shortcut":"yxc","avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}}]}]}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-10 17:48:34') RETURNING "id"
17:48:34.505traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:34.505traceyii\redis\Connection::executeCommandExecuting Redis Command: SET