页面

12132

页面总览

_page结构

CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  `pageFile` varchar(255)  DEFAULT NULL COMMENT 'page文件指定; 默认使用pageId.html',
  `pageName` varchar(255)  DEFAULT NULL COMMENT 'page name',
  `pageType` varchar(255)  DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  `pageIcon` text ,
  `sort` varchar(255)  DEFAULT NULL,
  `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 51 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'

帮助

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
帮助	help	dynamicInMenu	helpV4	11	undefined

登陆

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
登陆	login		loginV4		undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅登陆	login	passwordLogin	null	service	{"service": "user", "serviceFunction": "passwordLogin"}		{}	231	update	2022-04-27T15:32:57+08:00

审计模板列表

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
审计模板列表	auditProjectTemplate	showInMenu	null	1	undefined

审计项目列表

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
审计项目列表	auditProjectManagement	showInMenu	null	2	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅查询审计项目列表	auditProjectManagement	selectAuditProjectList	null	service	{"service": "auditProject", "serviceFunction": "selectAuditProjectList"}	{}	360	insert
✅查询列表	auditProjectManagement	selectItemList	null	sql	{ "table": "view01_audit_project", "operation": "select" }	{}	361	insert
✅创建审计项目	auditProjectManagement	createAuditProject	null	service	{"service": "auditProject", "serviceFunction": "createAuditProject"}	{}	362	insert
✅更新	auditProjectManagement	updateItem	{ "before": [], "after": [ { "service": "auditProject", "serviceFunction": "updateAuditProjectDirectoryAfterHook" } ] }	sql	{ "table": "audit_project", "operation": "jhUpdate" }	{}	363	insert
✅删除	auditProjectManagement	deleteItem	null	sql	{ "table": "audit_project", "operation": "jhDelete" }	{}	364	insert
✅审计列表-获取用户列表	auditProjectManagement	selectUserList	null	sql	{"table": "view01_user_select", "operation": "select"}	{}	382	insert
✅审计列表-移入回收站	auditProjectManagement	deletedProject	null	service	{"service": "auditProject", "serviceFunction": "deletedProject"}	{}	383	insert
✅审计列表-恢复数据	auditProjectManagement	restoreProject	null	service	{"service": "auditProject", "serviceFunction": "restoreProject"}	{}	384	insert
✅审计列表-创建账套	auditProjectManagement	createAppAccountOfManual	null	service	{"service": "auditProject", "serviceFunction": "syncAppAccountToFinanceOfManual"}	{}	394	insert
✅更新编制人	auditProjectManagement	updateProjectOrganizer	{ "before": [], "after": [ { "service": "auditProject", "serviceFunction": "syncAppAccountToFinance" } ] }	service	{"service": "auditProject", "serviceFunction": "updateProjectOrganizer"}	{}	400	insert

审计

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
审计	auditProjectDetail	dynamicInMenu	null	3	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	appDataSchema	id	operation
✅审计详情-下载审计包	auditProjectDetail	downloadAuditProject	null	service	{"service": "auditProject", "serviceFunction": "downloadAuditProject"}	{}	365	insert
✅审计详情-获取审计项目文件	auditProjectDetail	getProjectData	null	service	{"service": "auditProject", "serviceFunction": "getProjectData"}	{}	366	insert
✅审计详情-上传文件前置处理	auditProjectDetail	uploadFileBeforeHook	null	service	{"service": "auditProject", "serviceFunction": "uploadFileBeforeHook"}	{}	380	insert
✅审计详情-删除文件	auditProjectDetail	deleteFile	null	service	{"service": "auditProject", "serviceFunction": "deleteFile"}	{}	381	insert
✅查询列表	auditProjectDetail	selectAuditProject	null	sql	{ "table": "audit_project", "operation": "select" }	{}	385	insert
✅审核	auditProjectDetail	reviewItem	null	service	{"service": "auditProject", "serviceFunction": "reviewItem"}	{}	386	insert
✅查询审核数据	auditProjectDetail	selectReviewData	null	sql	{ "table": "audit_review", "operation": "select" }	{}	387	insert
✅审核批量	auditProjectDetail	reviewItemBatch	null	service	{"service": "auditProject", "serviceFunction": "reviewItemBatch"}	{}	388	insert
✅查询列表	auditProjectDetail	reviewSummary-selectItemList	null	sql	{ "table": "audit_review", "operation": "select" }	{}	389	insert
✅审计详情-获取审计信息	auditProjectDetail	getAuditReview	null	service	{"service": "auditProject", "serviceFunction": "getAuditReview"}	{}	393	insert
✅审计详情-获取分工审计项目文件	auditProjectDetail	getWorkProjectData	null	service	{"service": "auditProject", "serviceFunction": "getWorkProjectData"}	{}	410	insert

用户管理

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
用户管理	userManagement	showInAvatarMenu	null	6	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	id	operation	operationAt	requestDemo	responseDemo
✅用户管理-查询信息	userManagement	selectItemList	null	sql	{"table": "_user", "operation": "select"}	367	update	2022-04-29T16:33:28+08:00	{"appData": {"appId": "demo_advanced", "where": {}, "pageId": "userManagement", "orderBy": [{"order": "desc", "column": "operationAt"}], "actionId": "selectItemList", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651221207913_1347965", "packageType": "httpRequest"}	{"status": "success", "packageId": "1651221207913_1347965", "timestamp": "2022-04-29T16:33:28+08:00", "packageType": "httpResponse"}
✅用户管理-查询信息	userManagement	insertItem	null	service	{"service": "userManagement", "serviceFunction": "addUser"}	368	update	2022-04-28T16:36:00+08:00	{"appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "insertItem", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userId": "002", "username": "test", "clearTextPassword": "123456"}}, "packageId": "1651134960232_5022887", "packageType": "httpRequest"}	{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "insertItem", "resultData": {}}, "packageId": "1651134960232_5022887", "timestamp": "2022-04-28T16:36:00+08:00", "packageType": "httpResponse"}
✅用户管理-修改密码	userManagement	resetUserPassword	null	service	{"service": "userManagement", "serviceFunction": "resetUserPassword"}	369	update	2022-04-28T16:37:21+08:00	{"appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "resetUserPassword", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userId": "002", "clearTextPassword": "12345678"}}, "packageId": "1651135041149_9148309", "packageType": "httpRequest"}	{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "resetUserPassword", "resultData": {}}, "packageId": "1651135041149_9148309", "timestamp": "2022-04-28T16:37:21+08:00", "packageType": "httpResponse"}
✅用户管理-更新用户	userManagement	updateItem	null	sql	{"table": "_user", "operation": "jhUpdate"}	370	update	2022-04-29T16:33:27+08:00	{"appData": {"appId": "demo_advanced", "where": {"userId": "002"}, "pageId": "userManagement", "actionId": "updateItem", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userStatus": "active"}}, "packageId": "1651221207122_4349367", "packageType": "httpRequest"}	{"status": "success", "appData": {"rows": 1, "appId": "demo_advanced", "pageId": "userManagement", "actionId": "updateItem", "resultData": {"rows": 1}}, "packageId": "1651221207122_4349367", "timestamp": "2022-04-29T16:33:27+08:00", "packageType": "httpResponse"}

修改密码

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
修改密码	resetUserPassword	showInAvatarMenu	null	5	undefined

接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅修改用户密码	resetUserPassword	resetPassword	null	service	{ "service": "user", "serviceFunction": "resetPassword" }		{}	395	insert

通知/待办

页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
通知/待办	https://demo.jianghujs.org/task/page/noticeManagement	showInRightMenu	null	null	undefined

_page语句

INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', 'helpV4', '帮助', 'dynamicInMenu', NULL, '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', 'loginV4', '登陆', '', NULL, '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (36, 'auditProjectTemplate', NULL, '审计模板列表', 'showInMenu', NULL, '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (37, 'auditProjectManagement', NULL, '审计项目列表', 'showInMenu', NULL, '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (38, 'auditProjectDetail', NULL, '审计', 'dynamicInMenu', NULL, '3', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (40, 'userManagement', NULL, '用户管理', 'showInAvatarMenu', NULL, '6', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (41, 'resetUserPassword', NULL, '修改密码', 'showInAvatarMenu', NULL, '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (50, 'https://demo.jianghujs.org/task/page/noticeManagement', NULL, '通知/待办', 'showInRightMenu', '<svg width="28" height="28" viewBox="0 0 28 28" fill="none" xmlns="http://www.w3.org/2000/svg"> <g id="Frame 19"> <path id="Vector" d="M14 0C6.2695 0 0 6.2695 0 14C0 21.7305 6.2695 28 14 28C21.7305 28 28 21.7305 28 14C28 6.2695 21.7305 0 14 0Z" fill="#5DB55F"/> <g id="Frame"> <path id="Vector_2" d="M15.2698 19.44L15.307 19.4419C15.5022 19.4633 15.6398 19.6499 15.5895 19.8403L15.57 19.9088C15.3646 20.5638 14.7393 21.04 14.0001 21.04L13.9239 21.0384C13.193 21.0057 12.5866 20.5075 12.4103 19.8403L12.4033 19.8048C12.3758 19.6153 12.5284 19.44 12.7303 19.44H15.2698ZM14.0001 6.95996C14.1274 6.95996 14.2495 7.01053 14.3395 7.10055C14.4295 7.19057 14.4801 7.31266 14.4801 7.43996V7.94364C16.9402 8.191 18.8001 10.3545 18.8001 12.8556V16.24L18.802 16.288C18.8141 16.4489 18.8866 16.5994 19.0049 16.7091C19.1232 16.8189 19.2787 16.8799 19.4401 16.88H19.5543L19.6087 16.8816C20.0055 16.9065 20.3562 17.1993 20.3959 17.5974L20.3994 17.6486C20.4037 17.7562 20.3861 17.8635 20.3479 17.9642C20.3096 18.0648 20.2514 18.1567 20.1768 18.2343C20.1022 18.312 20.0127 18.3737 19.9137 18.4159C19.8146 18.4581 19.7081 18.4799 19.6004 18.48H8.44583L8.39143 18.4784C7.99463 18.4534 7.64391 18.1606 7.60423 17.7625L7.60071 17.7113C7.59649 17.6037 7.61404 17.4964 7.65231 17.3957C7.69058 17.295 7.74878 17.2031 7.82342 17.1255C7.89807 17.0479 7.98762 16.9861 8.0867 16.9439C8.18579 16.9017 8.29238 16.88 8.40007 16.88H8.56007L8.60807 16.8784C8.76908 16.8663 8.91956 16.7937 9.02935 16.6753C9.13914 16.5569 9.20012 16.4014 9.20007 16.24V12.72C9.20007 10.231 11.0945 8.1846 13.5201 7.94364V7.43996C13.5201 7.31266 13.5706 7.19057 13.6607 7.10055C13.7507 7.01053 13.8728 6.95996 14.0001 6.95996Z" fill="white"/> </g> </g> </svg>', NULL, 'insert', NULL, NULL, NULL);

# 页面总览

## _page结构

```sql
CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  `pageFile` varchar(255)  DEFAULT NULL COMMENT 'page文件指定; 默认使用pageId.html',
  `pageName` varchar(255)  DEFAULT NULL COMMENT 'page name',
  `pageType` varchar(255)  DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  `pageIcon` text ,
  `sort` varchar(255)  DEFAULT NULL,
  `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 51 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'
```

## 帮助

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 帮助 | help | dynamicInMenu | helpV4 | 11 | undefined |

## 登陆

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 登陆 | login |  | loginV4 |  | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅登陆 | login | passwordLogin | null | service | {"service": "user", "serviceFunction": "passwordLogin"} |  | {} | 231 | update | 2022-04-27T15:32:57+08:00 |  |  |  |  |

## 审计模板列表

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 审计模板列表 | auditProjectTemplate | showInMenu | null | 1 | undefined |

## 审计项目列表

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 审计项目列表 | auditProjectManagement | showInMenu | null | 2 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅查询审计项目列表 | auditProjectManagement | selectAuditProjectList | null | service | {"service": "auditProject", "serviceFunction": "selectAuditProjectList"} |  | {} | 360 | insert |  |  |  |  |  |
| ✅查询列表 | auditProjectManagement | selectItemList | null | sql | { "table": "view01_audit_project", "operation": "select" } |  | {} | 361 | insert |  |  |  |  |  |
| ✅创建审计项目 | auditProjectManagement | createAuditProject | null | service | {"service": "auditProject", "serviceFunction": "createAuditProject"} |  | {} | 362 | insert |  |  |  |  |  |
| ✅更新 | auditProjectManagement | updateItem | {   "before": [],   "after": [     {       "service": "auditProject",       "serviceFunction": "updateAuditProjectDirectoryAfterHook"     }   ] } | sql | { "table": "audit_project", "operation": "jhUpdate" } |  | {} | 363 | insert |  |  |  |  |  |
| ✅删除 | auditProjectManagement | deleteItem | null | sql | { "table": "audit_project", "operation": "jhDelete" } |  | {} | 364 | insert |  |  |  |  |  |
| ✅审计列表-获取用户列表 | auditProjectManagement | selectUserList | null | sql | {"table": "view01_user_select", "operation": "select"} |  | {} | 382 | insert |  |  |  |  |  |
| ✅审计列表-移入回收站 | auditProjectManagement | deletedProject | null | service | {"service": "auditProject", "serviceFunction": "deletedProject"} |  | {} | 383 | insert |  |  |  |  |  |
| ✅审计列表-恢复数据 | auditProjectManagement | restoreProject | null | service | {"service": "auditProject", "serviceFunction": "restoreProject"} |  | {} | 384 | insert |  |  |  |  |  |
| ✅审计列表-创建账套 | auditProjectManagement | createAppAccountOfManual | null | service | {"service": "auditProject", "serviceFunction": "syncAppAccountToFinanceOfManual"} |  | {} | 394 | insert |  |  |  |  |  |
| ✅更新编制人 | auditProjectManagement | updateProjectOrganizer | {   "before": [],   "after": [     {       "service": "auditProject",       "serviceFunction": "syncAppAccountToFinance"     }   ] } | service | {"service": "auditProject", "serviceFunction": "updateProjectOrganizer"} |  | {} | 400 | insert |  |  |  |  |  |

## 审计

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 审计 | auditProjectDetail | dynamicInMenu | null | 3 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅审计详情-下载审计包 | auditProjectDetail | downloadAuditProject | null | service | {"service": "auditProject", "serviceFunction": "downloadAuditProject"} |  | {} | 365 | insert |  |  |  |  |  |
| ✅审计详情-获取审计项目文件 | auditProjectDetail | getProjectData | null | service | {"service": "auditProject", "serviceFunction": "getProjectData"} |  | {} | 366 | insert |  |  |  |  |  |
| ✅审计详情-上传文件前置处理 | auditProjectDetail | uploadFileBeforeHook | null | service | {"service": "auditProject", "serviceFunction": "uploadFileBeforeHook"} |  | {} | 380 | insert |  |  |  |  |  |
| ✅审计详情-删除文件 | auditProjectDetail | deleteFile | null | service | {"service": "auditProject", "serviceFunction": "deleteFile"} |  | {} | 381 | insert |  |  |  |  |  |
| ✅查询列表 | auditProjectDetail | selectAuditProject | null | sql | { "table": "audit_project", "operation": "select" } |  | {} | 385 | insert |  |  |  |  |  |
| ✅审核 | auditProjectDetail | reviewItem | null | service | {"service": "auditProject", "serviceFunction": "reviewItem"} |  | {} | 386 | insert |  |  |  |  |  |
| ✅查询审核数据 | auditProjectDetail | selectReviewData | null | sql | { "table": "audit_review", "operation": "select" } |  | {} | 387 | insert |  |  |  |  |  |
| ✅审核批量 | auditProjectDetail | reviewItemBatch | null | service | {"service": "auditProject", "serviceFunction": "reviewItemBatch"} |  | {} | 388 | insert |  |  |  |  |  |
| ✅查询列表 | auditProjectDetail | reviewSummary-selectItemList | null | sql | { "table": "audit_review", "operation": "select" } |  | {} | 389 | insert |  |  |  |  |  |
| ✅审计详情-获取审计信息 | auditProjectDetail | getAuditReview | null | service | {"service": "auditProject", "serviceFunction": "getAuditReview"} |  | {} | 393 | insert |  |  |  |  |  |
| ✅审计详情-获取分工审计项目文件 | auditProjectDetail | getWorkProjectData | null | service | {"service": "auditProject", "serviceFunction": "getWorkProjectData"} |  | {} | 410 | insert |  |  |  |  |  |

## 用户管理

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 用户管理 | userManagement | showInAvatarMenu | null | 6 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅用户管理-查询信息 | userManagement | selectItemList | null | sql | {"table": "_user", "operation": "select"} |  |  | 367 | update | 2022-04-29T16:33:28+08:00 |  |  | {"appData": {"appId": "demo_advanced", "where": {}, "pageId": "userManagement", "orderBy": [{"order": "desc", "column": "operationAt"}], "actionId": "selectItemList", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651221207913_1347965", "packageType": "httpRequest"} | {"status": "success", "packageId": "1651221207913_1347965", "timestamp": "2022-04-29T16:33:28+08:00", "packageType": "httpResponse"} |
| ✅用户管理-查询信息 | userManagement | insertItem | null | service | {"service": "userManagement", "serviceFunction": "addUser"} |  |  | 368 | update | 2022-04-28T16:36:00+08:00 |  |  | {"appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "insertItem", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userId": "002", "username": "test", "clearTextPassword": "123456"}}, "packageId": "1651134960232_5022887", "packageType": "httpRequest"} | {"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "insertItem", "resultData": {}}, "packageId": "1651134960232_5022887", "timestamp": "2022-04-28T16:36:00+08:00", "packageType": "httpResponse"} |
| ✅用户管理-修改密码 | userManagement | resetUserPassword | null | service | {"service": "userManagement", "serviceFunction": "resetUserPassword"} |  |  | 369 | update | 2022-04-28T16:37:21+08:00 |  |  | {"appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "resetUserPassword", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userId": "002", "clearTextPassword": "12345678"}}, "packageId": "1651135041149_9148309", "packageType": "httpRequest"} | {"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "resetUserPassword", "resultData": {}}, "packageId": "1651135041149_9148309", "timestamp": "2022-04-28T16:37:21+08:00", "packageType": "httpResponse"} |
| ✅用户管理-更新用户 | userManagement | updateItem | null | sql | {"table": "_user", "operation": "jhUpdate"} |  |  | 370 | update | 2022-04-29T16:33:27+08:00 |  |  | {"appData": {"appId": "demo_advanced", "where": {"userId": "002"}, "pageId": "userManagement", "actionId": "updateItem", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userStatus": "active"}}, "packageId": "1651221207122_4349367", "packageType": "httpRequest"} | {"status": "success", "appData": {"rows": 1, "appId": "demo_advanced", "pageId": "userManagement", "actionId": "updateItem", "resultData": {"rows": 1}}, "packageId": "1651221207122_4349367", "timestamp": "2022-04-29T16:33:27+08:00", "packageType": "httpResponse"} |

## 修改密码

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 修改密码 | resetUserPassword | showInAvatarMenu | null | 5 | undefined |

- **接口信息**

| desc | pageId | actionId | resourceHook | resourceType | resourceData | accessControlTable | appDataSchema | id | operation | operationAt | operationByUser | operationByUserId | requestDemo | responseDemo |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| ✅修改用户密码 | resetUserPassword | resetPassword | null | service | { "service": "user", "serviceFunction": "resetPassword" } |  | {} | 395 | insert |  |  |  |  |  |

## 通知/待办

- **页面信息**

| pageName | pageId | pageType | pageFile | sort | pageHook |
| --- | --- | --- | --- | --- | --- |
| 通知/待办 | https://demo.jianghujs.org/task/page/noticeManagement | showInRightMenu | null | null | undefined |

## _page语句

```sql
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', 'helpV4', '帮助', 'dynamicInMenu', NULL, '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', 'loginV4', '登陆', '', NULL, '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (36, 'auditProjectTemplate', NULL, '审计模板列表', 'showInMenu', NULL, '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (37, 'auditProjectManagement', NULL, '审计项目列表', 'showInMenu', NULL, '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (38, 'auditProjectDetail', NULL, '审计', 'dynamicInMenu', NULL, '3', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (40, 'userManagement', NULL, '用户管理', 'showInAvatarMenu', NULL, '6', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (41, 'resetUserPassword', NULL, '修改密码', 'showInAvatarMenu', NULL, '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageFile, pageName, pageType, pageIcon, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (50, 'https://demo.jianghujs.org/task/page/noticeManagement', NULL, '通知/待办', 'showInRightMenu', '<svg width="28" height="28" viewBox="0 0 28 28" fill="none" xmlns="http://www.w3.org/2000/svg"> <g id="Frame 19"> <path id="Vector" d="M14 0C6.2695 0 0 6.2695 0 14C0 21.7305 6.2695 28 14 28C21.7305 28 28 21.7305 28 14C28 6.2695 21.7305 0 14 0Z" fill="#5DB55F"/> <g id="Frame"> <path id="Vector_2" d="M15.2698 19.44L15.307 19.4419C15.5022 19.4633 15.6398 19.6499 15.5895 19.8403L15.57 19.9088C15.3646 20.5638 14.7393 21.04 14.0001 21.04L13.9239 21.0384C13.193 21.0057 12.5866 20.5075 12.4103 19.8403L12.4033 19.8048C12.3758 19.6153 12.5284 19.44 12.7303 19.44H15.2698ZM14.0001 6.95996C14.1274 6.95996 14.2495 7.01053 14.3395 7.10055C14.4295 7.19057 14.4801 7.31266 14.4801 7.43996V7.94364C16.9402 8.191 18.8001 10.3545 18.8001 12.8556V16.24L18.802 16.288C18.8141 16.4489 18.8866 16.5994 19.0049 16.7091C19.1232 16.8189 19.2787 16.8799 19.4401 16.88H19.5543L19.6087 16.8816C20.0055 16.9065 20.3562 17.1993 20.3959 17.5974L20.3994 17.6486C20.4037 17.7562 20.3861 17.8635 20.3479 17.9642C20.3096 18.0648 20.2514 18.1567 20.1768 18.2343C20.1022 18.312 20.0127 18.3737 19.9137 18.4159C19.8146 18.4581 19.7081 18.4799 19.6004 18.48H8.44583L8.39143 18.4784C7.99463 18.4534 7.64391 18.1606 7.60423 17.7625L7.60071 17.7113C7.59649 17.6037 7.61404 17.4964 7.65231 17.3957C7.69058 17.295 7.74878 17.2031 7.82342 17.1255C7.89807 17.0479 7.98762 16.9861 8.0867 16.9439C8.18579 16.9017 8.29238 16.88 8.40007 16.88H8.56007L8.60807 16.8784C8.76908 16.8663 8.91956 16.7937 9.02935 16.6753C9.13914 16.5569 9.20012 16.4014 9.20007 16.24V12.72C9.20007 10.231 11.0945 8.1846 13.5201 7.94364V7.43996C13.5201 7.31266 13.5706 7.19057 13.6607 7.10055C13.7507 7.01053 13.8728 6.95996 14.0001 6.95996Z" fill="white"/> </g> </g> </svg>', NULL, 'insert', NULL, NULL, NULL);
```