页面

12114

页面总览

_page结构

CREATE TABLE `_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  `pageName` varchar(255)  DEFAULT NULL COMMENT 'page name',
  `pageHook` varchar(1000)  DEFAULT NULL,
  `pageFile` varchar(255)  DEFAULT NULL COMMENT 'page文件指定; 默认使用pageId.html',
  `pageType` varchar(255)  DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  `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`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 62 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '页面表; 软删除未启用;'

帮助

• 页面信息

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

登陆

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
登陆	login		loginV4		null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅登陆	login	passwordLogin	null	service	{ "service": "user", "serviceFunction": "passwordLogin" }		{}	231	insert

[员工组织]员工管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[员工组织]员工管理	employeeManagement	showInMenu	null	2	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅员工管理-查询列表	employeeManagement	selectItemList	null	sql	{ "table": "view02_employee", "operation": "select" }		{}	317	insert
✅员工管理-添加成员	employeeManagement	insertItem	{ "before": [ { "service": "employee", "serviceFunction": "addEmployeeInsertBeforeHook" } ] }	sql	{ "table": "employee", "operation": "jhInsert" }		{}	318	insert
✅员工管理-更新成员	employeeManagement	updateItem	null	sql	{ "table": "employee", "operation": "jhUpdate" }		{}	319	insert
✅员工管理-删除信息	employeeManagement	deleteItem	null	sql	{ "table": "employee", "operation": "jhDelete" }		{}	320	insert
✅员工管理-获取自定义字段	employeeManagement	getEmployeeField	null	sql	{ "table": "employee_field", "operation": "select" }		{}	321	insert
✅员工管理-状态统计	employeeManagement	getStatusCount	null	service	{ "service": "employee", "serviceFunction": "getStatusCount" }		{}	322	insert
✅员工管理-查询社保方案	employeeManagement	getInsuranceScheme	null	sql	{ "table": "view01_insurance_month", "operation": "select" }		{}	323	insert
✅员工管理-修改参保方案	employeeManagement	insuranceSave	null	sql	{ "table": "employee_social_security_info", "operation": "jhUpdate" }		{}	324	insert
✅员工管理-办理离职	employeeManagement	quitInfoSave	{ "before": [ { "service": "employee", "serviceFunction": "quitInsertBeforeHook" } ], "after": [ { "service": "employee", "serviceFunction": "quitAfterHook" } ] }	sql	{ "table": "employee_quit_info", "operation": "jhInsert"}		{}	325	insert
✅员工管理-调整部门/岗位、晋升/降级	employeeManagement	changeSave	{ "before": [ { "service": "employee", "serviceFunction": "changeInsertBeforeHook" } ], "after": [ { "service": "employee", "serviceFunction": "changeAfterHook" } ] }	sql	{ "table": "employee_change_record", "operation": "jhInsert"}		{}	326	insert
✅员工管理-查询部门	employeeManagement	getDept	null	sql	{ "table": "org", "operation": "select" }		{}	327	insert
✅员工管理-查询员工	employeeManagement	getEmployee	null	sql	{ "table": "view02_employee", "operation": "select" }		{}	328	insert
✅员工管理-新建员工	employeeManagement	addEmployeeSave	{ "before": [ { "service": "employee", "serviceFunction": "addEmployeeInsertBeforeHook" } ] }	sql	{ "table": "employee", "operation": "jhInsert" }		{}	329	insert
✅员工管理-查询系统用户	employeeManagement	getAdminUser	null	sql	{ "table": "admin_user", "operation": "select" }		{}	330	insert
✅员工管理-导出	employeeManagement	getExcelData	null	service	{ "service": "employee", "serviceFunction": "getExcelData" }		{}	331	insert
✅员工管理-导入	employeeManagement	uploadItem	null	service	{ "service": "employee", "serviceFunction": "uploadItem" }		{}	332	insert
✅查询列表	employeeManagement	selectItemList	null	sql	{ "table": "employee", "operation": "select" }		{}	403	insert
✅添加	employeeManagement	insertItem	{ "before": [ { "service": "employee", "serviceFunction": "addEmployeeInsertBeforeHook" } ] }	sql	{ "table": "employee", "operation": "insert" }		{}	404	insert
✅更新	employeeManagement	updateItem	null	sql	{ "table": "employee", "operation": "jhUpdate" }		{}	405	insert
✅删除	employeeManagement	deleteItem	null	sql	{ "table": "employee", "operation": "jhDelete" }		{}	406	insert
✅获取社保方案列表	employeeManagement	getInsuranceList	null	sql	{ "table": "insurance_scheme", "operation": "select" }			493	insert
✅获取合同到期列表	employeeManagement	getEmployeeWarnList	null	service	{"service":"employee","serviceFunction":"getEmployeeWarnList"}			511	insert
✅员工附件查询	employeeManagement	fileUpload-selectItemList	null	sql	{ "table": "employee_file", "operation": "select" }		{}	515	insert
✅员工附件上传	employeeManagement	fileUpload-insertItem	{ "before": [ { "service": "employee", "serviceFunction": "fillInsertFileParamsBeforeHook" } ], "after": [] }	sql	{ "table": "employee_file","operation": "insert" }		{}	516	insert
✅员工附件修改	employeeManagement	fileUpload-updateItem	null	sql	{ "table": "employee_file", "operation": "jhUpdate" }		{}	517	insert
✅添加	employeeManagement	insertDepartRequestItem	null	sql	{ "table": "employee_request", "operation": "insert" }		{}	528	insert

[员工组织]员工组织管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[员工组织]员工组织管理	memberOrgRoleManagement	showInMenu	null	4	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询组织下所有成员	memberOrgRoleManagement	selectItemList	null	service	{"service": "member", "serviceFunction": "selectMemberFromOgrId"}		{}	369	insert
✅删除组织成员	memberOrgRoleManagement	deleteItem	null	sql	{ "table": "member_org_role", "operation": "jhDelete" }		{}	370	insert
✅批量添加组织成员	memberOrgRoleManagement	batchAddMemberOrgRole	null	service	{ "service": "org", "serviceFunction": "batchAddMemberOrgRole" }		{}	371	insert
✅更新成员组织	memberOrgRoleManagement	updateItem	null	sql	{ "table": "member_org_role", "operation": "jhUpdate" }		{}	372	insert
✅查询组织成员	memberOrgRoleManagement	selectItem	null	sql	{ "table": "view01_member_org_role", "operation": "select" }		{}	373	insert
✅更新成员组织	memberOrgRoleManagement	updateRoleItem	null	service	{"service":"member","serviceFunction":"updateRoleItem"}		{}	524	insert

[绩效]考核管理(开发中)

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[绩效]考核管理(开发中)	performanceManagement	showInMenu	null	15	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	performanceManagement	selectItemList	null	sql	{ "table": "performance", "operation": "select" }		{}	486	insert
✅添加	performanceManagement	insertItem	{ "before": [ { "service": "performance", "serviceFunction": "addPerformanceInsertBeforeHook" } ] }	sql	{ "table": "performance", "operation": "insert" }		{}	487	insert
✅更新	performanceManagement	updateItem	null	sql	{ "table": "performance", "operation": "jhUpdate" }		{}	488	insert
✅删除	performanceManagement	deleteItem	null	sql	{ "table": "performance", "operation": "jhDelete" }		{}	489	insert
✅查询	performanceManagement	getEmployeeList	null	sql	{ "table": "employee", "operation": "select" }			491	insert
✅新增评分数据	performanceManagement	insertPerformanceRateItem	null	service	{ "service": "performance", "serviceFunction": "insertPerformanceRateItem" }		{}	494	insert
✅新增归档数据	performanceManagement	insertEndPerformanceItem	{ "before": [ { "service": "performance", "serviceFunction": "deleteResultBeforeDeleteItem" } ] }	service	{ "service": "performance", "serviceFunction": "insertPerformanceResult" }		{}	500	insert
✅查询归档数据	performanceManagement	selectResultItemList	null	sql	{ "table": "performance_result", "operation": "select" }		{}	501	insert
✅查询列表	performanceManagement	selectTemplateList	null	sql	{ "table": "performance_tmp", "operation": "select" }		{}	522	insert
✅查询	performanceManagement	getOrgList	null	sql	{ "table": "org", "operation": "select" }			523	insert

[绩效]考核计划 (开发中)

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[绩效]考核计划 (开发中)	appraisalPlanManagement	dynamicInMenu	null	16	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅服务端查询-查询列表	appraisalPlanManagement	selectItemList	null	sql	{ "table": "achievement_appraisal", "operation": "select" }		{}	374	insert

[绩效]绩效档案(开发中)

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[绩效]绩效档案(开发中)	archivesSetup	dynamicInMenu	null	17	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅服务端查询-查询列表	archivesSetup	selectItemList	null	sql	{ "table": "achievement_employee_appraisal", "operation": "select" }		{}	375	insert

[绩效]考勤管理(开发中)

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[绩效]考勤管理(开发中)	clockManagement	showInMenu	null	18	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	clockManagement	selectItemList	null	sql	{ "table": "view01_attendance_clock", "operation": "select" }		{}	380	insert
✅添加	clockManagement	insertItem	null	sql	{ "table": "attendance_clock", "operation": "insert" }		{}	381	insert
✅更新	clockManagement	updateItem	null	sql	{ "table": "attendance_clock", "operation": "jhUpdate" }		{}	382	insert
✅删除	clockManagement	deleteItem	null	sql	{ "table": "attendance_clock", "operation": "jhDelete" }		{}	383	insert

[社保]社保方案

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[社保]社保方案	insuranceSchemeSetup	showInMenu	null	8	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	insuranceSchemeSetup	selectItemList	{ "before": [], "after": [ { "service": "insurance", "serviceFunction": "afterSchemeAppendProjectHook" } ] }	sql	{ "table": "insurance_scheme", "operation": "select" }		{}	388	update	2022-11-14T22:40:56+08:00	vscode	vscode
✅添加	insuranceSchemeSetup	insertItem	{ "before": [ { "service": "insurance", "serviceFunction": "beforeCreateSchemeIdHook" } ], "after": [] }	sql	{ "table": "insurance_scheme", "operation": "insert" }		{}	389	update	2022-11-14T22:40:56+08:00	vscode	vscode
✅更新	insuranceSchemeSetup	updateItem	null	sql	{ "table": "insurance_scheme", "operation": "jhUpdate" }		{}	390	update	2022-11-14T22:40:56+08:00	vscode	vscode
✅删除	insuranceSchemeSetup	deleteItem	null	sql	{ "table": "insurance_scheme", "operation": "jhDelete" }		{}	391	update	2022-11-14T22:40:56+08:00	vscode	vscode

[薪资]薪资组

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[薪资]薪资组	salaryGroupManagement	showInMenu	salary/salaryGroupManagement	9	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	salaryGroupManagement	selectItemList	null	sql	{ "table": "salary_group", "operation": "select" }		{}	392	update	2022-11-15T10:48:48+08:00	vscode	vscode
✅添加	salaryGroupManagement	insertItem	{ "before": [ { "service": "salary", "serviceFunction": "beforeInsertSalaryGroupHook" } ], "after": [] }	sql	{ "table": "salary_group", "operation": "insert" }		{}	393	update	2022-11-15T10:48:48+08:00	vscode	vscode
✅更新	salaryGroupManagement	updateItem	null	sql	{ "table": "salary_group", "operation": "jhUpdate" }		{}	394	update	2022-11-15T10:48:48+08:00	vscode	vscode
✅删除	salaryGroupManagement	deleteItem	null	sql	{ "table": "salary_group", "operation": "jhDelete" }		{}	395	update	2022-11-15T10:48:48+08:00	vscode	vscode
✅查询-查询列表	salaryGroupManagement	getSalaryTaxRuleList	null	sql	{"table":"salary_tax_rule","operation":"select"}			396	update	2022-11-15T10:48:48+08:00	vscode	vscode
✅员工列表	salaryGroupManagement	getEmployeeList	null	sql	{ "table": "employee", "operation": "select" }			533	insert

[薪资]计薪规则

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[薪资]计薪规则	salaryTaxRuleManagement	showInMenu	salary/salaryTaxRuleManagement	10	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	salaryTaxRuleManagement	selectItemList	null	sql	{ "table": "salary_tax_rule", "operation": "select" }		{}	397	insert
✅添加	salaryTaxRuleManagement	insertItem	null	sql	{ "table": "salary_tax_rule", "operation": "insert" }		{}	398	insert
✅更新	salaryTaxRuleManagement	updateItem	null	sql	{ "table": "salary_tax_rule", "operation": "jhUpdate" }		{}	399	insert
✅删除	salaryTaxRuleManagement	deleteItem	null	sql	{ "table": "salary_tax_rule", "operation": "jhDelete" }		{}	400	insert

工作台

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
工作台	workbench	showInMenu	null	1	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅工作台统计数	workbench	getWorkbenchCount	null	service	{"service":"workbench","serviceFunction":"getWorkbenchCount"}			510	insert

[招聘]招聘职位管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[招聘]招聘职位管理	jobPostingsManagement	showInMenu	job/jobPostingsManagement	5	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	jobPostingsManagement	selectItemList	null	sql	{ "table": "job_postings", "operation": "select" }		{}	408	insert
✅添加	jobPostingsManagement	insertItem	{ "after": [], "before": [ { "service": "job", "serviceFunction": "beforHookForGenerateJobId" } ] }	sql	{ "table": "job_postings", "operation": "insert" }		{}	409	insert
✅更新	jobPostingsManagement	updateItem	null	sql	{ "table": "job_postings", "operation": "jhUpdate" }		{}	410	insert
✅删除	jobPostingsManagement	deleteItem	null	sql	{ "table": "job_postings", "operation": "jhDelete" }		{}	411	insert

[招聘]投递简历列表

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[招聘]投递简历列表	jobResumeManagement	showInMenu	job/jobResumeManagement	5	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	jobResumeManagement	selectItemList	null	sql	{ "table": "job_resume", "operation": "select" }		{}	412	insert
✅添加	jobResumeManagement	selectJobList	null	sql	{ "table": "job_postings", "operation": "select" }		{}	413	insert
✅更新	jobResumeManagement	updateItem	null	sql	{ "table": "job_resume", "operation": "jhUpdate" }		{}	414	insert
✅删除	jobResumeManagement	deleteItem	null	sql	{ "table": "job_resume", "operation": "jhDelete" }		{}	415	insert
✅简历管理-状态统计	jobResumeManagement	getStatusCount	null	service	{ "service": "job", "serviceFunction": "getStatusCount" }		{}	490	insert
✅录用员工	jobResumeManagement	employItem	{ "after": [ { "service": "job", "serviceFunction": "afterEmployItemHook" } ] }	sql	{ "table": "job_resume", "operation": "jhUpdate" }			495	insert

简历预览

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
简历预览	jobResumePreview	dynamicInMenu	job/jobResumePreview	null	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询简历	jobResumePreview	getResumeData	null	sql	{ "table": "job_resume", "operation": "select" }			416	insert

[社保]月社保详情

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[社保]月社保详情	insuranceSchemeDetail	dynamicInMenu	null	null	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询-查询列表	insuranceSchemeDetail	getMonthRecordInfo	null	sql	{"table":"insurance_month_record","operation":"select"}			421	update	2022-11-10T15:07:51+08:00	vscode	vscode
✅查询-查询列表	insuranceSchemeDetail	getMonthEmpList	null	sql	{"table":"view01_month_emp_record_detail","operation":"select"}			422	update	2022-11-10T15:07:51+08:00	vscode	vscode
✅查询-查询列表	insuranceSchemeDetail	getEmployeeList	null	sql	{"table":"view01_employee_quit_list","operation":"select"}			423	update	2022-11-10T15:07:51+08:00	vscode	vscode
✅新增-添加数据	insuranceSchemeDetail	insertEmployeeRecord	{}	service	{"service":"insurance","serviceFunction":"insertEmployeeRecord"}			424	update	2022-11-10T15:07:51+08:00	vscode	vscode
✅查询-查询列表	insuranceSchemeDetail	getEmpProjectRecordList	null	sql	{"table":"insurance_month_emp_project_record","operation":"select"}			425	update	2022-11-10T15:07:51+08:00	vscode	vscode
✅查询-查询列表	insuranceSchemeDetail	getSchemeList	null	sql	{"table":"insurance_scheme","operation":"select"}			426	update	2022-11-10T15:07:51+08:00	vscode	vscode
✅查询-查询列表	insuranceSchemeDetail	getSchemeProjectList	null	sql	{"table":"insurance_project","operation":"select"}			427	update	2022-11-10T15:07:51+08:00	vscode	vscode
✅查询-查询列表	insuranceSchemeDetail	updateEmpSchemeRecord	null	service	{"service":"insurance","serviceFunction":"updateEmpSchemeRecord"}			428	update	2022-11-10T15:07:51+08:00	vscode	vscode

[社保]社保管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[社保]社保管理	insuranceSchemeManagement	showInMenu	null	5	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	insuranceSchemeManagement	selectItemList	{ "after": [ { "service": "insurance", "serviceFunction": "checkNewMonthRecord" } ] }	sql	{"table":"view01_insurance_month","operation":"select"}		{}	417	update	2022-11-10T15:29:22+08:00	vscode	vscode
✅添加	insuranceSchemeManagement	insertMonthRecord	null	service	{"service":"insurance","serviceFunction":"insertMonthRecord"}		{}	418	update	2022-11-10T15:29:22+08:00	vscode	vscode
✅更新	insuranceSchemeManagement	updateItem	null	sql	{ "table": "insurance_month_emp_record", "operation": "jhUpdate" }		{}	419	update	2022-11-10T15:29:22+08:00	vscode	vscode
✅删除	insuranceSchemeManagement	deleteItem	{ "before": [ { "service": "insurance", "serviceFunction": "beforeCheckDelMonthRecord" } ], "after": [ { "service": "insurance", "serviceFunction": "afterDelEmpRecord" } ] }	sql	{"table":"insurance_month_record","operation":"delete"}		{}	420	update	2022-11-10T15:29:22+08:00	vscode	vscode

[薪资]薪资档案

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[薪资]薪资档案	archivesManagement	showInMenu	salary/archivesManagement	4	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	archivesManagement	selectItemList	{ "before": [], "after": [ { "service": "salary", "serviceFunction": "afterAppendNewChangeRecordHook" } ] }	sql	{"table":"view01_employee_archives","operation":"select"}		{}	433	update	2022-11-12T22:07:01+08:00	vscode	vscode
✅添加	archivesManagement	insertItem	null	sql	{ "table": "salary_archives", "operation": "insert" }		{}	434	update	2022-11-12T22:07:01+08:00	vscode	vscode
✅更新	archivesManagement	updateItem	null	sql	{ "table": "salary_archives", "operation": "jhUpdate" }		{}	435	update	2022-11-12T22:07:01+08:00	vscode	vscode
✅删除	archivesManagement	deleteItem	null	sql	{ "table": "salary_archives", "operation": "jhDelete" }		{}	436	update	2022-11-12T22:07:01+08:00	vscode	vscode
✅查询-查询列表	archivesManagement	getSalaryOption	null	sql	{"table":"_constant","operation":"select"}			441	update	2022-11-12T22:07:02+08:00	vscode	vscode
✅定薪	archivesManagement	makeEmployeeArchives	null	service	{"service":"salary","serviceFunction":"makeEmployeeArchives"}			446	update	2022-11-12T22:07:02+08:00	vscode	vscode
✅调薪	archivesManagement	updateEmployeeArchives	null	service	{"service":"salary","serviceFunction":"updateEmployeeArchives"}			447	insert	2022-11-12T22:07:02+08:00	vscode	vscode

[薪资]薪资管理

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[薪资]薪资管理	monthEmpRecord	showInMenu	salary/monthEmpRecord	11	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	monthEmpRecord	selectItemList	null	service	{"service":"salary","serviceFunction":"monthEmpRecord"}		{}	452	update	2022-11-23T15:44:48+08:00	vscode	vscode
✅添加	monthEmpRecord	insertItem	null	service	{"service":"salary","serviceFunction":"createMonthRecord"}		{}	453	update	2022-11-23T15:44:48+08:00	vscode	vscode
✅更新	monthEmpRecord	updateItem	null	sql	{ "table": "salary_month_emp_record", "operation": "jhUpdate" }		{}	454	update	2022-11-23T15:44:48+08:00	vscode	vscode
✅删除	monthEmpRecord	deleteItem	null	service	{"service":"salary","serviceFunction":"delMonthRecord"}		{}	455	update	2022-11-23T15:44:48+08:00	vscode	vscode
✅核算工资	monthEmpRecord	createMonthRecord	null	service	{"service":"salary","serviceFunction":"createMonthRecord"}			456	update	2022-11-23T15:44:48+08:00	vscode	vscode
✅查询-查询列表	monthEmpRecord	getLastConfig	null	service	{"service":"salary","serviceFunction":"getLastConfig"}			457	update	2022-11-23T15:44:48+08:00	vscode	vscode
✅查询-查询列表	monthEmpRecord	createSlipRecord	null	service	{"service":"salary","serviceFunction":"createSlipRecord"}			466	insert	2022-11-23T15:44:48+08:00	vscode	vscode
✅在线编辑-批量修改保存	monthEmpRecord	batchUpdateItem	null	service	{"service":"salary","serviceFunction":"batchUpdate"}			531	insert	2022-11-23T15:44:48+08:00	vscode	vscode

[薪资]发放记录2

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[薪资]发放记录2	salarySlipManagement	dynamicInMenu	salary/salarySlipManagement	8	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	salarySlipManagement	selectItemList	null	sql	{ "table": "salary_slip", "operation": "select" }		{}	458	insert
✅添加	salarySlipManagement	insertItem	null	sql	{ "table": "salary_slip", "operation": "insert" }		{}	459	insert
✅更新	salarySlipManagement	updateItem	null	sql	{ "table": "salary_slip", "operation": "jhUpdate" }		{}	460	insert
✅删除	salarySlipManagement	deleteItem	null	sql	{ "table": "salary_slip", "operation": "jhDelete" }		{}	461	insert

[薪资]历史工资

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[薪资]历史工资	slipRecordManagement	showInMenu	salary/slipRecordManagement	2	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	slipRecordManagement	selectItemList	null	sql	{ "table": "view01_salary_month_record", "operation": "select" }		{}	462	insert
✅添加	slipRecordManagement	insertItem	null	sql	{ "table": "salary_slip_record", "operation": "insert" }		{}	463	insert
✅更新	slipRecordManagement	updateItem	null	sql	{ "table": "salary_slip_record", "operation": "jhUpdate" }		{}	464	insert
✅删除	slipRecordManagement	deleteItem	null	sql	{ "table": "salary_slip_record", "operation": "jhDelete" }		{}	465	insert

[招聘]招聘列表-web

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[招聘]招聘列表-web	jobs	showInMenu	job/jobs	1	{
"beforeHook":[

{"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
    {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"},
    {"field": "jobList", "service": "job", "serviceFunc": "list"},
    {"field": "hotJobList", "service": "job", "serviceFunc": "hotList"}

]
} |

[招聘]岗位详情-web

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[招聘]岗位详情-web	detail	seo	job/detail	1	{
"beforeHook":[

{"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
    {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"},
    {"field": "job", "service": "job", "serviceFunc": "detail"}

]
} |

[招聘]填写简历-web

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[招聘]填写简历-web	form	seo	job/form	1	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅列表	form	getResumeData	null	sql	{ "table": "job_resume", "operation": "select" }			468	insert
✅提交	form	submitResume	{ "after": [ { "service": "job", "serviceFunction": "afterReturnJobResumeId" } ], "before": [ { "service": "job", "serviceFunction": "beforHookForGenerateJobResumeId" } ] }	sql	{ "table": "job_resume", "operation": "jhInsert" }			469	insert
✅列表	form	getJobData	null	sql	{ "table": "job_postings", "operation": "select" }			470	insert

[招聘]招聘职位的候选人

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[招聘]招聘职位的候选人	jobResumeOfJobPosition	dynamicInMenu	job/jobResumeOfJobPosition	1	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	jobResumeOfJobPosition	selectItemList	null	sql	{ "table": "view01_job_resume2", "operation": "select" }		{}	471	insert
✅简历管理-状态统计	jobResumeOfJobPosition	getStatusCount	null	sql	{ "table": "view01_job_resume2", "operation": "select" }		{}	472	insert
✅添加	jobResumeOfJobPosition	insertItem	null	sql	{ "table": "job_resume", "operation": "insert" }		{}	473	insert
✅更新	jobResumeOfJobPosition	updateItem	null	sql	{ "table": "job_resume", "operation": "jhUpdate" }		{}	474	insert
✅删除	jobResumeOfJobPosition	deleteItem	null	sql	{ "table": "job_resume", "operation": "jhDelete" }		{}	475	insert
✅已入职后创建员工信息	jobResumeOfJobPosition	creatEmployeeItem	{ "before": [ { "service": "employee", "serviceFunction": "addEmployeeInsertBeforeHook" } ] }	sql	{ "table": "employee", "operation": "insert" }		{}	492	insert

[员工组织]员工离职批准

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[员工组织]员工离职批准	employeeDepartApproved	showInMenu	null	3	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询	employeeDepartApproved	selectItemList	null	sql	{ "table": "employee", "operation": "select" }		{}	525	insert
✅更新	employeeDepartApproved	updateItem	null	sql	{ "table": "employee", "operation": "jhUpdate" }		{}	526	insert
✅更新	employeeDepartApproved	updateEntryStatus	null	sql	{ "table": "employee", "operation": "jhUpdate" }		{}	527	insert

[绩效]考核打分

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[绩效]考核打分	performanceEmployeeRateManagement	showInMenu	null	5	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	performanceEmployeeRateManagement	selectItemList	null	sql	{ "table": "view02_performance_employee_rate", "operation": "select" }		{}	506	insert
✅添加	performanceEmployeeRateManagement	insertItem	null	sql	{ "table": "performance_employee_rate", "operation": "insert" }		{}	507	insert
✅更新	performanceEmployeeRateManagement	updateItem	null	sql	{ "table": "performance_employee_rate", "operation": "jhUpdate" }		{}	508	insert
✅删除	performanceEmployeeRateManagement	deleteItem	null	sql	{ "table": "performance_employee_rate", "operation": "jhDelete" }		{}	509	insert

[绩效]考核模板

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[绩效]考核模板	performanceTemplate	showInMenu	null	20	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	performanceTemplate	selectItemList	null	sql	{ "table": "performance_tmp", "operation": "select" }		{}	518	insert
✅添加	performanceTemplate	insertItem	{ "before": [ { "service": "performanceTemplate", "serviceFunction": "addTemplateIdBeforeHook" } ], "after": [] }	sql	{ "table": "performance_tmp", "operation": "insert" }		{}	519	insert
✅更新	performanceTemplate	updateItem	null	sql	{ "table": "performance_tmp", "operation": "jhUpdate" }		{}	520	insert
✅删除	performanceTemplate	deleteItem	null	sql	{ "table": "performance_tmp", "operation": "jhDelete" }		{}	521	insert

[薪资]薪资导入

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[薪资]薪资导入	salaryImport	showInMenu	salary/salaryImport	11	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅薪资导入-导入	salaryImport	importSalaryData	null	service	{"service":"salary","serviceFunction":"importSalaryData"}		{}	529	insert
✅薪资导入-检查数据	salaryImport	checkSalaryData	null	service	{"service":"salary","serviceFunction":"checkSalaryData"}		{}	530	insert

[薪资]历史工资明细

• 页面信息

pageName	pageId	pageType	pageFile	sort	pageHook
[薪资]历史工资明细	monthEmpHistory	dynamicInMenu	salary/monthEmpHistory	12	null

• 接口信息

desc	pageId	actionId	resourceHook	resourceType	resourceData	accessControlTable	appDataSchema	id	operation	operationAt	operationByUser	operationByUserId	requestDemo	responseDemo
✅查询列表	monthEmpHistory	selectItemList	null	service	{"service":"salary","serviceFunction":"monthEmpRecord"}		{}	532	update	2022-11-23T15:44:48+08:00	vscode	vscode

_page语句

INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'help', '帮助', NULL, 'helpV4', 'dynamicInMenu', '11', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'login', '登陆', NULL, 'loginV4', '', '', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (29, 'employeeManagement', '[员工组织]员工管理', NULL, NULL, 'showInMenu', '2', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (30, 'memberOrgRoleManagement', '[员工组织]员工组织管理', NULL, NULL, 'showInMenu', '4', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (31, 'performanceManagement', '[绩效]考核管理(开发中)', NULL, NULL, 'showInMenu', '15', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (32, 'appraisalPlanManagement', '[绩效]考核计划 (开发中)', NULL, NULL, 'dynamicInMenu', '16', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (33, 'archivesSetup', '[绩效]绩效档案(开发中)', NULL, NULL, 'dynamicInMenu', '17', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (35, 'clockManagement', '[绩效]考勤管理(开发中)', NULL, NULL, 'showInMenu', '18', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (37, 'insuranceSchemeSetup', '[社保]社保方案', NULL, NULL, 'showInMenu', '8', 'update', 'vscode', 'vscode', '2022-11-14T21:19:59+08:00');
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (38, 'salaryGroupManagement', '[薪资]薪资组', NULL, 'salary/salaryGroupManagement', 'showInMenu', '9', 'update', 'vscode', 'vscode', '2022-11-15T10:29:48+08:00');
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (39, 'salaryTaxRuleManagement', '[薪资]计薪规则', NULL, 'salary/salaryTaxRuleManagement', 'showInMenu', '10', 'update', 'vscode', 'vscode', '2022-11-15T11:01:29+08:00');
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (42, 'workbench', '工作台', NULL, NULL, 'showInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (43, 'jobPostingsManagement', '[招聘]招聘职位管理', NULL, 'job/jobPostingsManagement', 'showInMenu', '5', 'insert', 'insert', NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (44, 'jobResumeManagement', '[招聘]投递简历列表', NULL, 'job/jobResumeManagement', 'showInMenu', '5', 'insert', 'insert', NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (46, 'jobResumePreview', '简历预览', NULL, 'job/jobResumePreview', 'dynamicInMenu', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (47, 'insuranceSchemeDetail', '[社保]月社保详情', NULL, NULL, 'dynamicInMenu', NULL, 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (48, 'insuranceSchemeManagement', '[社保]社保管理', NULL, NULL, 'showInMenu', '5', 'update', 'vscode', 'vscode', '2022-11-08T09:57:49+08:00');
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (49, 'archivesManagement', '[薪资]薪资档案', NULL, 'salary/archivesManagement', 'showInMenu', '4', 'update', 'vscode', 'vscode', '2022-11-10T22:42:17+08:00');
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (50, 'monthEmpRecord', '[薪资]薪资管理', NULL, 'salary/monthEmpRecord', 'showInMenu', '11', 'update', 'vscode', 'vscode', '2022-11-22T15:58:21+08:00');
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (51, 'salarySlipManagement', '[薪资]发放记录2', NULL, 'salary/salarySlipManagement', 'dynamicInMenu', '8', 'update', 'vscode', 'vscode', '2022-11-23T16:29:41+08:00');
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (52, 'slipRecordManagement', '[薪资]历史工资', NULL, 'salary/slipRecordManagement', 'showInMenu', '2', 'update', 'vscode', 'vscode', '2022-11-23T16:29:51+08:00');
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (53, 'jobs', '[招聘]招聘列表-web', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
        {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"},
        {"field": "jobList", "service": "job", "serviceFunc": "list"},
        {"field": "hotJobList", "service": "job", "serviceFunc": "hotList"}
  ]
}', 'job/jobs', 'showInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (54, 'detail', '[招聘]岗位详情-web', '{
  "beforeHook":[
    {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
        {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"},
        {"field": "job", "service": "job", "serviceFunc": "detail"}
  ]
}', 'job/detail', 'seo', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (55, 'form', '[招聘]填写简历-web', NULL, 'job/form', 'seo', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (56, 'jobResumeOfJobPosition', '[招聘]招聘职位的候选人', NULL, 'job/jobResumeOfJobPosition', 'dynamicInMenu', '1', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (57, 'employeeDepartApproved', '[员工组织]员工离职批准', NULL, NULL, 'showInMenu', '3', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (58, 'performanceEmployeeRateManagement', '[绩效]考核打分', NULL, NULL, 'showInMenu', '5', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (59, 'performanceTemplate', '[绩效]考核模板', NULL, NULL, 'showInMenu', '20', 'insert', NULL, NULL, NULL);
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (60, 'salaryImport', '[薪资]薪资导入', NULL, 'salary/salaryImport', 'showInMenu', '11', 'update', 'vscode', 'vscode', '2022-11-22T15:58:21+08:00');
INSERT INTO _page (id, pageId, pageName, pageHook, pageFile, pageType, sort, operation, operationByUserId, operationByUser, operationAt) VALUES (61, 'monthEmpHistory', '[薪资]历史工资明细', NULL, 'salary/monthEmpHistory', 'dynamicInMenu', '12', 'insert', NULL, NULL, NULL);