江湖数字化平台
登录

页面

12111

页面总览

_page结构

  1. CREATE TABLE `_page` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `pageId` varchar(255)  DEFAULT NULL COMMENT 'pageId',
  4.   `pageName` varchar(255)  DEFAULT NULL COMMENT 'page name',
  5.   `pageHook` varchar(1000)  DEFAULT NULL,
  6.   `pageFile` varchar(255)  DEFAULT NULL COMMENT 'page文件指定; 默认使用pageId.html',
  7.   `pageType` varchar(255)  DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  8.   `pageIcon` text ,
  9.   `sort` varchar(255)  DEFAULT NULL,
  10.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  11.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  12.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  13.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  14.   PRIMARY KEY (`id`) USING BTREE
  15. ) ENGINE = InnoDB AUTO_INCREMENT = 86 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": "view01_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": "view01_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 null 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 null 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 null 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 null 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

通知/待办

  • 页面信息
pageName pageId pageType pageFile sort pageHook
通知/待办 https://demo.jianghujs.org/task/page/noticeManagement showInRightMenu null null null

_page语句

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