接口
12111接口总览
_resource结构
CREATE TABLE `_resource` (`id` int(11) NOT NULL AUTO_INCREMENT,`accessControlTable` varchar(255) DEFAULT NULL COMMENT '数据规则控制表',`resourceHook` text COMMENT '[ "before": {"service": "xx", "serviceFunction": "xxx"}, "after": [] }',`pageId` varchar(255) DEFAULT NULL COMMENT 'page id; E.g: index',`actionId` varchar(255) DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',`desc` varchar(255) DEFAULT NULL COMMENT '描述',`resourceType` varchar(255) DEFAULT NULL COMMENT 'resource 类型; E.g: auth service sql',`appDataSchema` text COMMENT 'appData 参数校验',`resourceData` text COMMENT 'resource 数据; { "service": "auth", "serviceFunction": "passwordLogin" } or { "table": "${tableName}", "action": "select", "whereCondition": ".where(function() {this.whereNot( { recordStatus: \\"active\\" })})" }',`requestDemo` text COMMENT '请求Demo',`responseDemo` text COMMENT '响应Demo',`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 = 534 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'
_resource 内容
| id | desc | pageId | actionId | resourceType | resourceHook | resourceData |
|---|---|---|---|---|---|---|
| 5 | ✅ 文件分片上传-所有分片上传完毕 | allPage | uploadFileDone | service | null | { "service": "file", "serviceFunction": "uploadFileDone" } |
| 6 | ✅ 文件分片上传-http文件流 | allPage | httpUploadByStream | service | null | { "service": "file", "serviceFunction": "uploadFileChunkByStream" } |
| 7 | ✅ 文件分片上传-http base64 | allPage | httpUploadByBase64 | service | null | { "service": "file", "serviceFunction": "uploadFileChunkByBase64" } |
| 231 | ✅登陆 | login | passwordLogin | service | null | { "service": "user", "serviceFunction": "passwordLogin" } |
| 251 | ✅登出 | allPage | logout | service | null | { "service": "user", "serviceFunction": "logout" } |
| 253 | ✅获取用户信息 | allPage | userInfo | service | null | { "service": "user", "serviceFunction": "userInfo" } |
| 258 | ✅查询常量 | allPage | getConstantList | sql | null | { "table": "_constant", "operation": "select" } |
| 317 | ✅员工管理-查询列表 | employeeManagement | selectItemList | sql | null | { "table": "view01_employee", "operation": "select" } |
| 318 | ✅员工管理-添加成员 | employeeManagement | insertItem | sql | { "before": [ { "service": "employee", "serviceFunction": "addEmployeeInsertBeforeHook" } ] } | { "table": "employee", "operation": "jhInsert" } |
| 319 | ✅员工管理-更新成员 | employeeManagement | updateItem | sql | null | { "table": "employee", "operation": "jhUpdate" } |
| 320 | ✅员工管理-删除信息 | employeeManagement | deleteItem | sql | null | { "table": "employee", "operation": "jhDelete" } |
| 321 | ✅员工管理-获取自定义字段 | employeeManagement | getEmployeeField | sql | null | { "table": "employee_field", "operation": "select" } |
| 322 | ✅员工管理-状态统计 | employeeManagement | getStatusCount | service | null | { "service": "employee", "serviceFunction": "getStatusCount" } |
| 323 | ✅员工管理-查询社保方案 | employeeManagement | getInsuranceScheme | sql | null | { "table": "view01_insurance_month", "operation": "select" } |
| 324 | ✅员工管理-修改参保方案 | employeeManagement | insuranceSave | sql | null | { "table": "employee_social_security_info", "operation": "jhUpdate" } |
| 325 | ✅员工管理-办理离职 | employeeManagement | quitInfoSave | sql | { "before": [ { "service": "employee", "serviceFunction": "quitInsertBeforeHook" } ], "after": [ { "service": "employee", "serviceFunction": "quitAfterHook" } ] } | { "table": "employee_quit_info", "operation": "jhInsert" } |
| 326 | ✅员工管理-调整部门/岗位、晋升/降级 | employeeManagement | changeSave | sql | { "before": [ { "service": "employee", "serviceFunction": "changeInsertBeforeHook" } ], "after": [ { "service": "employee", "serviceFunction": "changeAfterHook" } ] } | { "table": "employee_change_record", "operation": "jhInsert" } |
| 327 | ✅员工管理-查询部门 | employeeManagement | getDept | sql | null | { "table": "org", "operation": "select" } |
| 328 | ✅员工管理-查询员工 | employeeManagement | getEmployee | sql | null | { "table": "view01_employee", "operation": "select" } |
| 329 | ✅员工管理-新建员工 | employeeManagement | addEmployeeSave | sql | { "before": [ { "service": "employee", "serviceFunction": "addEmployeeInsertBeforeHook" } ] } | { "table": "employee", "operation": "jhInsert" } |
| 330 | ✅员工管理-查询系统用户 | employeeManagement | getAdminUser | sql | null | { "table": "admin_user", "operation": "select" } |
| 331 | ✅员工管理-导出 | employeeManagement | getExcelData | service | null | { "service": "employee", "serviceFunction": "getExcelData" } |
| 332 | ✅员工管理-导入 | employeeManagement | uploadItem | service | null | { "service": "employee", "serviceFunction": "uploadItem" } |
| 365 | ✅查询列表 | orgManagement | selectItemList | sql | null | { "table": "org", "operation": "select" } |
| 366 | ✅添加 | orgManagement | insertItem | service | null | { "service": "org", "serviceFunction": "insertItem" } |
| 367 | ✅更新 | orgManagement | updateItem | service | null | { "service": "org", "serviceFunction": "updateItem" } |
| 368 | ✅删除 | orgManagement | deleteItem | service | null | { "service": "org", "serviceFunction": "deleteItem" } |
| 369 | ✅查询组织下所有成员 | memberOrgRoleManagement | selectItemList | service | null | { "service": "member", "serviceFunction": "selectMemberFromOgrId" } |
| 370 | ✅删除组织成员 | memberOrgRoleManagement | deleteItem | sql | null | { "table": "member_org_role", "operation": "jhDelete" } |
| 371 | ✅批量添加组织成员 | memberOrgRoleManagement | batchAddMemberOrgRole | service | null | { "service": "org", "serviceFunction": "batchAddMemberOrgRole" } |
| 372 | ✅更新成员组织 | memberOrgRoleManagement | updateItem | sql | null | { "table": "member_org_role", "operation": "jhUpdate" } |
| 373 | ✅查询组织成员 | memberOrgRoleManagement | selectItem | sql | null | { "table": "view01_member_org_role", "operation": "select" } |
| 374 | ✅服务端查询-查询列表 | appraisalPlanManagement | selectItemList | sql | null | { "table": "achievement_appraisal", "operation": "select" } |
| 375 | ✅服务端查询-查询列表 | archivesSetup | selectItemList | sql | null | { "table": "achievement_employee_appraisal", "operation": "select" } |
| 376 | ✅服务端查询-查询列表 | studentManagement | selectItemList | sql | null | { "table": "student", "operation": "select" } |
| 377 | ✅服务端查询-添加成员 | studentManagement | insertItem | sql | null | { "table": "student", "operation": "insert" } |
| 378 | ✅服务端查询-更新成员 | studentManagement | updateItem | sql | null | { "table": "student", "operation": "jhUpdate" } |
| 379 | ✅服务端查询-删除信息 | studentManagement | deleteItem | sql | null | { "table": "student", "operation": "jhDelete" } |
| 380 | ✅查询列表 | clockManagement | selectItemList | sql | null | { "table": "view01_attendance_clock", "operation": "select" } |
| 381 | ✅添加 | clockManagement | insertItem | sql | null | { "table": "attendance_clock", "operation": "insert" } |
| 382 | ✅更新 | clockManagement | updateItem | sql | null | { "table": "attendance_clock", "operation": "jhUpdate" } |
| 383 | ✅删除 | clockManagement | deleteItem | sql | null | { "table": "attendance_clock", "operation": "jhDelete" } |
| 384 | ✅服务端查询-查询列表 | studentManagement | selectItemList | sql | null | { "table": "student", "operation": "select" } |
| 385 | ✅服务端查询-添加成员 | studentManagement | insertItem | sql | null | { "table": "student", "operation": "insert" } |
| 386 | ✅服务端查询-更新成员 | studentManagement | updateItem | sql | null | { "table": "student", "operation": "jhUpdate" } |
| 387 | ✅服务端查询-删除信息 | studentManagement | deleteItem | sql | null | { "table": "student", "operation": "jhDelete" } |
| 388 | ✅查询列表 | insuranceSchemeSetup | selectItemList | sql | { "before": [], "after": [ { "service": "insurance", "serviceFunction": "afterSchemeAppendProjectHook" } ] } | { "table": "insurance_scheme", "operation": "select" } |
| 389 | ✅添加 | insuranceSchemeSetup | insertItem | sql | { "before": [ { "service": "insurance", "serviceFunction": "beforeCreateSchemeIdHook" } ], "after": [] } | { "table": "insurance_scheme", "operation": "insert" } |
| 390 | ✅更新 | insuranceSchemeSetup | updateItem | sql | null | { "table": "insurance_scheme", "operation": "jhUpdate" } |
| 391 | ✅删除 | insuranceSchemeSetup | deleteItem | sql | null | { "table": "insurance_scheme", "operation": "jhDelete" } |
| 392 | ✅查询列表 | salaryGroupManagement | selectItemList | sql | null | { "table": "salary_group", "operation": "select" } |
| 393 | ✅添加 | salaryGroupManagement | insertItem | sql | { "before": [ { "service": "salary", "serviceFunction": "beforeInsertSalaryGroupHook" } ], "after": [] } | { "table": "salary_group", "operation": "insert" } |
| 394 | ✅更新 | salaryGroupManagement | updateItem | sql | null | { "table": "salary_group", "operation": "jhUpdate" } |
| 395 | ✅删除 | salaryGroupManagement | deleteItem | sql | null | { "table": "salary_group", "operation": "jhDelete" } |
| 396 | ✅查询-查询列表 | salaryGroupManagement | getSalaryTaxRuleList | sql | null | { "table": "salary_tax_rule", "operation": "select" } |
| 397 | ✅查询列表 | salaryTaxRuleManagement | selectItemList | sql | null | { "table": "salary_tax_rule", "operation": "select" } |
| 398 | ✅添加 | salaryTaxRuleManagement | insertItem | sql | null | { "table": "salary_tax_rule", "operation": "insert" } |
| 399 | ✅更新 | salaryTaxRuleManagement | updateItem | sql | null | { "table": "salary_tax_rule", "operation": "jhUpdate" } |
| 400 | ✅删除 | salaryTaxRuleManagement | deleteItem | sql | null | { "table": "salary_tax_rule", "operation": "jhDelete" } |
| 401 | ✅服务端查询-查询列表 | candidateManagement | selectItemList | sql | null | { "table": "recruit_candidate", "operation": "select" } |
| 402 | ✅服务端查询-查询列表 | recruitPpostManagement | selectItemList | sql | null | { "table": "recruit_post", "operation": "select" } |
| 403 | ✅查询列表 | employeeManagement | selectItemList | sql | null | { "table": "employee", "operation": "select" } |
| 404 | ✅添加 | employeeManagement | insertItem | sql | { "before": [ { "service": "employee", "serviceFunction": "addEmployeeInsertBeforeHook" } ] } | { "table": "employee", "operation": "insert" } |
| 405 | ✅更新 | employeeManagement | updateItem | sql | null | { "table": "employee", "operation": "jhUpdate" } |
| 406 | ✅删除 | employeeManagement | deleteItem | sql | null | { "table": "employee", "operation": "jhDelete" } |
| 408 | ✅查询列表 | jobPostingsManagement | selectItemList | sql | null | { "table": "job_postings", "operation": "select" } |
| 409 | ✅添加 | jobPostingsManagement | insertItem | sql | { "after": [], "before": [ { "service": "job", "serviceFunction": "beforHookForGenerateJobId" } ] } | { "table": "job_postings", "operation": "insert" } |
| 410 | ✅更新 | jobPostingsManagement | updateItem | sql | null | { "table": "job_postings", "operation": "jhUpdate" } |
| 411 | ✅删除 | jobPostingsManagement | deleteItem | sql | null | { "table": "job_postings", "operation": "jhDelete" } |
| 412 | ✅查询列表 | jobResumeManagement | selectItemList | sql | null | { "table": "job_resume", "operation": "select" } |
| 413 | ✅添加 | jobResumeManagement | selectJobList | sql | null | { "table": "job_postings", "operation": "select" } |
| 414 | ✅更新 | jobResumeManagement | updateItem | sql | null | { "table": "job_resume", "operation": "jhUpdate" } |
| 415 | ✅删除 | jobResumeManagement | deleteItem | sql | null | { "table": "job_resume", "operation": "jhDelete" } |
| 416 | ✅查询简历 | jobResumePreview | getResumeData | sql | null | { "table": "job_resume", "operation": "select" } |
| 417 | ✅查询列表 | insuranceSchemeManagement | selectItemList | sql | { "after": [ { "service": "insurance", "serviceFunction": "checkNewMonthRecord" } ] } | { "table": "view01_insurance_month", "operation": "select" } |
| 418 | ✅添加 | insuranceSchemeManagement | insertMonthRecord | service | null | { "service": "insurance", "serviceFunction": "insertMonthRecord" } |
| 419 | ✅更新 | insuranceSchemeManagement | updateItem | sql | null | { "table": "insurance_month_emp_record", "operation": "jhUpdate" } |
| 420 | ✅删除 | insuranceSchemeManagement | deleteItem | sql | { "before": [ { "service": "insurance", "serviceFunction": "beforeCheckDelMonthRecord" } ], "after": [ { "service": "insurance", "serviceFunction": "afterDelEmpRecord" } ] } | { "table": "insurance_month_record", "operation": "delete" } |
| 421 | ✅查询-查询列表 | insuranceSchemeDetail | getMonthRecordInfo | sql | null | { "table": "insurance_month_record", "operation": "select" } |
| 422 | ✅查询-查询列表 | insuranceSchemeDetail | getMonthEmpList | sql | null | { "table": "view01_month_emp_record_detail", "operation": "select" } |
| 423 | ✅查询-查询列表 | insuranceSchemeDetail | getEmployeeList | sql | null | { "table": "view01_employee_quit_list", "operation": "select" } |
| 424 | ✅新增-添加数据 | insuranceSchemeDetail | insertEmployeeRecord | service | {} | { "service": "insurance", "serviceFunction": "insertEmployeeRecord" } |
| 425 | ✅查询-查询列表 | insuranceSchemeDetail | getEmpProjectRecordList | sql | null | { "table": "insurance_month_emp_project_record", "operation": "select" } |
| 426 | ✅查询-查询列表 | insuranceSchemeDetail | getSchemeList | sql | null | { "table": "insurance_scheme", "operation": "select" } |
| 427 | ✅查询-查询列表 | insuranceSchemeDetail | getSchemeProjectList | sql | null | { "table": "insurance_project", "operation": "select" } |
| 428 | ✅查询-查询列表 | insuranceSchemeDetail | updateEmpSchemeRecord | service | null | { "service": "insurance", "serviceFunction": "updateEmpSchemeRecord" } |
| 429 | ✅查询列表 | monthRecordManagement | selectItemList | sql | null | { "table": "salary_month_record", "operation": "select" } |
| 430 | ✅添加 | monthRecordManagement | insertItem | sql | null | { "table": "salary_month_record", "operation": "insert" } |
| 431 | ✅更新 | monthRecordManagement | updateItem | sql | null | { "table": "salary_month_record", "operation": "jhUpdate" } |
| 432 | ✅删除 | monthRecordManagement | deleteItem | sql | null | { "table": "salary_month_record", "operation": "jhDelete" } |
| 433 | ✅查询列表 | archivesManagement | selectItemList | sql | { "before": [], "after": [ { "service": "salary", "serviceFunction": "afterAppendNewChangeRecordHook" } ] } | { "table": "view01_employee_archives", "operation": "select" } |
| 434 | ✅添加 | archivesManagement | insertItem | sql | null | { "table": "salary_archives", "operation": "insert" } |
| 435 | ✅更新 | archivesManagement | updateItem | sql | null | { "table": "salary_archives", "operation": "jhUpdate" } |
| 436 | ✅删除 | archivesManagement | deleteItem | sql | null | { "table": "salary_archives", "operation": "jhDelete" } |
| 437 | ✅查询列表 | slipTmp | selectItemList | sql | null | { "table": "view01_salary_slip_template", "operation": "select" } |
| 438 | ✅添加 | slipTmp | insertItem | service | null | { "service": "salary", "serviceFunction": "updateSlipOption" } |
| 439 | ✅更新 | slipTmp | updateItem | service | null | { "service": "salary", "serviceFunction": "updateSlipOption" } |
| 440 | ✅删除 | slipTmp | deleteItem | service | null | { "service": "salary", "serviceFunction": "deleteSlipOption" } |
| 441 | ✅查询-查询列表 | archivesManagement | getSalaryOption | sql | null | { "table": "_constant", "operation": "select" } |
| 442 | ✅查询列表 | changeTmp | selectItemList | sql | null | { "table": "salary_change_template", "operation": "select" } |
| 443 | ✅添加 | changeTmp | insertItem | sql | { "before": [ { "service": "salary", "serviceFunction": "beforeCreateChangeTmpHook" } ] } | { "table": "salary_change_template", "operation": "jhInsert" } |
| 444 | ✅更新 | changeTmp | updateItem | sql | null | { "table": "salary_change_template", "operation": "jhUpdate" } |
| 445 | ✅删除 | changeTmp | deleteItem | sql | null | { "table": "salary_change_template", "operation": "jhDelete" } |
| 446 | ✅定薪 | archivesManagement | makeEmployeeArchives | service | null | { "service": "salary", "serviceFunction": "makeEmployeeArchives" } |
| 447 | ✅调薪 | archivesManagement | updateEmployeeArchives | service | null | { "service": "salary", "serviceFunction": "updateEmployeeArchives" } |
| 448 | ✅查询列表 | changeRecord | selectItemList | sql | null | { "table": "salary_change_record", "operation": "select" } |
| 449 | ✅添加 | changeRecord | insertItem | sql | null | { "table": "salary_change_record", "operation": "insert" } |
| 450 | ✅更新 | changeRecord | updateItem | sql | null | { "table": "salary_change_record", "operation": "jhUpdate" } |
| 451 | ✅删除 | changeRecord | deleteItem | sql | null | { "table": "salary_change_record", "operation": "jhDelete" } |
| 452 | ✅查询列表 | monthEmpRecord | selectItemList | service | null | { "service": "salary", "serviceFunction": "monthEmpRecord" } |
| 453 | ✅添加 | monthEmpRecord | insertItem | service | null | { "service": "salary", "serviceFunction": "createMonthRecord" } |
| 454 | ✅更新 | monthEmpRecord | updateItem | sql | null | { "table": "salary_month_emp_record", "operation": "jhUpdate" } |
| 455 | ✅删除 | monthEmpRecord | deleteItem | service | null | { "service": "salary", "serviceFunction": "delMonthRecord" } |
| 456 | ✅核算工资 | monthEmpRecord | createMonthRecord | service | null | { "service": "salary", "serviceFunction": "createMonthRecord" } |
| 457 | ✅查询-查询列表 | monthEmpRecord | getLastConfig | service | null | { "service": "salary", "serviceFunction": "getLastConfig" } |
| 458 | ✅查询列表 | salarySlipManagement | selectItemList | sql | null | { "table": "salary_slip", "operation": "select" } |
| 459 | ✅添加 | salarySlipManagement | insertItem | sql | null | { "table": "salary_slip", "operation": "insert" } |
| 460 | ✅更新 | salarySlipManagement | updateItem | sql | null | { "table": "salary_slip", "operation": "jhUpdate" } |
| 461 | ✅删除 | salarySlipManagement | deleteItem | sql | null | { "table": "salary_slip", "operation": "jhDelete" } |
| 462 | ✅查询列表 | slipRecordManagement | selectItemList | sql | null | { "table": "view01_salary_month_record", "operation": "select" } |
| 463 | ✅添加 | slipRecordManagement | insertItem | sql | null | { "table": "salary_slip_record", "operation": "insert" } |
| 464 | ✅更新 | slipRecordManagement | updateItem | sql | null | { "table": "salary_slip_record", "operation": "jhUpdate" } |
| 465 | ✅删除 | slipRecordManagement | deleteItem | sql | null | { "table": "salary_slip_record", "operation": "jhDelete" } |
| 466 | ✅查询-查询列表 | monthEmpRecord | createSlipRecord | service | null | { "service": "salary", "serviceFunction": "createSlipRecord" } |
| 467 | ✅查询-查询列表 | monthRecordManagement | monthEmpRecordByYearMonth | service | null | { "service": "salary", "serviceFunction": "monthEmpRecordByYearMonth" } |
| 468 | ✅列表 | form | getResumeData | sql | null | { "table": "job_resume", "operation": "select" } |
| 469 | ✅提交 | form | submitResume | sql | { "after": [ { "service": "job", "serviceFunction": "afterReturnJobResumeId" } ], "before": [ { "service": "job", "serviceFunction": "beforHookForGenerateJobResumeId" } ] } | { "table": "job_resume", "operation": "jhInsert" } |
| 470 | ✅列表 | form | getJobData | sql | null | { "table": "job_postings", "operation": "select" } |
| 471 | ✅查询列表 | jobResumeOfJobPosition | selectItemList | sql | null | { "table": "view01_job_resume2", "operation": "select" } |
| 472 | ✅简历管理-状态统计 | jobResumeOfJobPosition | getStatusCount | sql | null | { "table": "view01_job_resume2", "operation": "select" } |
| 473 | ✅添加 | jobResumeOfJobPosition | insertItem | sql | null | { "table": "job_resume", "operation": "insert" } |
| 474 | ✅更新 | jobResumeOfJobPosition | updateItem | sql | null | { "table": "job_resume", "operation": "jhUpdate" } |
| 475 | ✅删除 | jobResumeOfJobPosition | deleteItem | sql | null | { "table": "job_resume", "operation": "jhDelete" } |
| 486 | ✅查询列表 | performanceManagement | selectItemList | sql | null | { "table": "performance", "operation": "select" } |
| 487 | ✅添加 | performanceManagement | insertItem | sql | { "before": [ { "service": "performance", "serviceFunction": "addPerformanceInsertBeforeHook" } ] } | { "table": "performance", "operation": "insert" } |
| 488 | ✅更新 | performanceManagement | updateItem | sql | null | { "table": "performance", "operation": "jhUpdate" } |
| 489 | ✅删除 | performanceManagement | deleteItem | sql | null | { "table": "performance", "operation": "jhDelete" } |
| 490 | ✅简历管理-状态统计 | jobResumeManagement | getStatusCount | service | null | { "service": "job", "serviceFunction": "getStatusCount" } |
| 491 | ✅查询 | performanceManagement | getEmployeeList | sql | null | { "table": "employee", "operation": "select" } |
| 492 | ✅已入职后创建员工信息 | jobResumeOfJobPosition | creatEmployeeItem | sql | { "before": [ { "service": "employee", "serviceFunction": "addEmployeeInsertBeforeHook" } ] } | { "table": "employee", "operation": "insert" } |
| 493 | ✅获取社保方案列表 | employeeManagement | getInsuranceList | sql | null | { "table": "insurance_scheme", "operation": "select" } |
| 494 | ✅新增评分数据 | performanceManagement | insertPerformanceRateItem | service | null | { "service": "performance", "serviceFunction": "insertPerformanceRateItem" } |
| 495 | ✅录用员工 | jobResumeManagement | employItem | sql | { "after": [ { "service": "job", "serviceFunction": "afterEmployItemHook" } ] } | { "table": "job_resume", "operation": "jhUpdate" } |
| 496 | ✅查询列表 | performanceRateManagement | selectItemList | sql | { "before": [ { "service": "performance", "serviceFunction": "addPerformanceInsertBeforeHook" } ] } | { "table": "performance_employee_rate", "operation": "select" } |
| 497 | ✅添加 | performanceRateManagement | insertItem | sql | null | { "table": "performance_employee_rate", "operation": "insert" } |
| 498 | ✅更新 | performanceRateManagement | updateItem | sql | null | { "table": "performance_employee_rate", "operation": "jhUpdate" } |
| 499 | ✅删除 | performanceRateManagement | deleteItem | sql | null | { "table": "performance_employee_rate", "operation": "jhDelete" } |
| 500 | ✅新增归档数据 | performanceManagement | insertEndPerformanceItem | service | { "before": [ { "service": "performance", "serviceFunction": "deleteResultBeforeDeleteItem" } ] } | { "service": "performance", "serviceFunction": "insertPerformanceResult" } |
| 501 | ✅查询归档数据 | performanceManagement | selectResultItemList | sql | null | { "table": "performance_result", "operation": "select" } |
| 502 | ✅查询列表 | performanceResultManagement | selectItemList | sql | null | { "table": "performance_result", "operation": "select" } |
| 503 | ✅添加 | performanceResultManagement | insertItem | sql | null | { "table": "performance_result", "operation": "insert" } |
| 504 | ✅更新 | performanceResultManagement | updateItem | sql | null | { "table": "performance_result", "operation": "jhUpdate" } |
| 505 | ✅删除 | performanceResultManagement | deleteItem | sql | null | { "table": "performance_result", "operation": "jhDelete" } |
| 506 | ✅查询列表 | performanceEmployeeRateManagement | selectItemList | sql | null | { "table": "view02_performance_employee_rate", "operation": "select" } |
| 507 | ✅添加 | performanceEmployeeRateManagement | insertItem | sql | null | { "table": "performance_employee_rate", "operation": "insert" } |
| 508 | ✅更新 | performanceEmployeeRateManagement | updateItem | sql | null | { "table": "performance_employee_rate", "operation": "jhUpdate" } |
| 509 | ✅删除 | performanceEmployeeRateManagement | deleteItem | sql | null | { "table": "performance_employee_rate", "operation": "jhDelete" } |
| 510 | ✅工作台统计数 | workbench | getWorkbenchCount | service | null | { "service": "workbench", "serviceFunction": "getWorkbenchCount" } |
| 511 | ✅获取合同到期列表 | employeeManagement | getEmployeeWarnList | service | null | { "service": "employee", "serviceFunction": "getEmployeeWarnList" } |
| 515 | ✅员工附件查询 | employeeManagement | fileUpload-selectItemList | sql | null | { "table": "employee_file", "operation": "select" } |
| 516 | ✅员工附件上传 | employeeManagement | fileUpload-insertItem | sql | { "before": [ { "service": "employee", "serviceFunction": "fillInsertFileParamsBeforeHook" } ], "after": [] } | { "table": "employee_file", "operation": "insert" } |
| 517 | ✅员工附件修改 | employeeManagement | fileUpload-updateItem | sql | null | { "table": "employee_file", "operation": "jhUpdate" } |
| 518 | ✅查询列表 | performanceTemplate | selectItemList | sql | null | { "table": "performance_tmp", "operation": "select" } |
| 519 | ✅添加 | performanceTemplate | insertItem | sql | { "before": [ { "service": "performanceTemplate", "serviceFunction": "addTemplateIdBeforeHook" } ], "after": [] } | { "table": "performance_tmp", "operation": "insert" } |
| 520 | ✅更新 | performanceTemplate | updateItem | sql | null | { "table": "performance_tmp", "operation": "jhUpdate" } |
| 521 | ✅删除 | performanceTemplate | deleteItem | sql | null | { "table": "performance_tmp", "operation": "jhDelete" } |
| 522 | ✅查询列表 | performanceManagement | selectTemplateList | sql | null | { "table": "performance_tmp", "operation": "select" } |
| 523 | ✅查询 | performanceManagement | getOrgList | sql | null | { "table": "org", "operation": "select" } |
| 524 | ✅更新成员组织 | memberOrgRoleManagement | updateRoleItem | service | null | { "service": "member", "serviceFunction": "updateRoleItem" } |
| 525 | ✅查询 | employeeDepartApproved | selectItemList | sql | null | { "table": "employee", "operation": "select" } |
| 526 | ✅更新 | employeeDepartApproved | updateItem | sql | null | { "table": "employee", "operation": "jhUpdate" } |
| 527 | ✅更新 | employeeDepartApproved | updateEntryStatus | sql | null | { "table": "employee", "operation": "jhUpdate" } |
| 528 | ✅添加 | employeeManagement | insertDepartRequestItem | sql | null | { "table": "employee_request", "operation": "insert" } |
| 529 | ✅薪资导入-导入 | salaryImport | importSalaryData | service | null | { "service": "salary", "serviceFunction": "importSalaryData" } |
| 530 | ✅薪资导入-检查数据 | salaryImport | checkSalaryData | service | null | { "service": "salary", "serviceFunction": "checkSalaryData" } |
| 531 | ✅在线编辑-批量修改保存 | monthEmpRecord | batchUpdateItem | service | null | { "service": "salary", "serviceFunction": "batchUpdate" } |
| 532 | ✅查询列表 | monthEmpHistory | selectItemList | service | null | { "service": "salary", "serviceFunction": "monthEmpRecord" } |
| 533 | ✅员工列表 | salaryGroupManagement | getEmployeeList | sql | null | { "table": "employee", "operation": "select" } |
_resource语句
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (5, NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileDone" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (6, NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }', NULL, NULL, 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (7, NULL, NULL, 'allPage', 'httpUploadByBase64', '✅ 文件分片上传-http base64', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByBase64" }', NULL, NULL, 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (231, NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{ "service": "user", "serviceFunction": "passwordLogin" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (251, NULL, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{ "service": "user", "serviceFunction": "logout" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (253, NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{ "service": "user", "serviceFunction": "userInfo" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (258, NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{ "table": "_constant", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (317, NULL, NULL, 'employeeManagement', 'selectItemList', '✅员工管理-查询列表', 'sql', '{}', '{ "table": "view01_employee", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (318, NULL, '{ "before": [{"service": "employee", "serviceFunction": "addEmployeeInsertBeforeHook"}]}', 'employeeManagement', 'insertItem', '✅员工管理-添加成员', 'sql', '{}', '{ "table": "employee", "operation": "jhInsert" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (319, NULL, NULL, 'employeeManagement', 'updateItem', '✅员工管理-更新成员', 'sql', '{}', '{ "table": "employee", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (320, NULL, NULL, 'employeeManagement', 'deleteItem', '✅员工管理-删除信息', 'sql', '{}', '{ "table": "employee", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (321, NULL, NULL, 'employeeManagement', 'getEmployeeField', '✅员工管理-获取自定义字段', 'sql', '{}', '{ "table": "employee_field", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (322, NULL, NULL, 'employeeManagement', 'getStatusCount', '✅员工管理-状态统计', 'service', '{}', '{ "service": "employee", "serviceFunction": "getStatusCount" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (323, NULL, NULL, 'employeeManagement', 'getInsuranceScheme', '✅员工管理-查询社保方案', 'sql', '{}', '{ "table": "view01_insurance_month", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (324, NULL, NULL, 'employeeManagement', 'insuranceSave', '✅员工管理-修改参保方案', 'sql', '{}', '{ "table": "employee_social_security_info", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (325, NULL, '{ "before": [{"service": "employee", "serviceFunction": "quitInsertBeforeHook"}], "after": [{"service": "employee", "serviceFunction": "quitAfterHook"}] }', 'employeeManagement', 'quitInfoSave', '✅员工管理-办理离职', 'sql', '{}', '{ "table": "employee_quit_info", "operation": "jhInsert"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (326, NULL, '{ "before": [{"service": "employee", "serviceFunction": "changeInsertBeforeHook"}], "after": [{"service": "employee", "serviceFunction": "changeAfterHook"}] }', 'employeeManagement', 'changeSave', '✅员工管理-调整部门/岗位、晋升/降级', 'sql', '{}', '{ "table": "employee_change_record", "operation": "jhInsert"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (327, NULL, NULL, 'employeeManagement', 'getDept', '✅员工管理-查询部门', 'sql', '{}', '{ "table": "org", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (328, NULL, NULL, 'employeeManagement', 'getEmployee', '✅员工管理-查询员工', 'sql', '{}', '{ "table": "view01_employee", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (329, NULL, '{ "before": [{"service": "employee", "serviceFunction": "addEmployeeInsertBeforeHook"}]}', 'employeeManagement', 'addEmployeeSave', '✅员工管理-新建员工', 'sql', '{}', '{ "table": "employee", "operation": "jhInsert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (330, NULL, NULL, 'employeeManagement', 'getAdminUser', '✅员工管理-查询系统用户', 'sql', '{}', '{ "table": "admin_user", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (331, NULL, NULL, 'employeeManagement', 'getExcelData', '✅员工管理-导出', 'service', '{}', '{ "service": "employee", "serviceFunction": "getExcelData" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (332, NULL, NULL, 'employeeManagement', 'uploadItem', '✅员工管理-导入', 'service', '{}', '{ "service": "employee", "serviceFunction": "uploadItem" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (365, NULL, NULL, 'orgManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "org", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (366, NULL, NULL, 'orgManagement', 'insertItem', '✅添加', 'service', '{}', '{"service": "org", "serviceFunction": "insertItem"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (367, NULL, NULL, 'orgManagement', 'updateItem', '✅更新', 'service', '{}', '{"service": "org", "serviceFunction": "updateItem"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (368, NULL, NULL, 'orgManagement', 'deleteItem', '✅删除', 'service', '{}', '{"service": "org", "serviceFunction": "deleteItem"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (369, NULL, NULL, 'memberOrgRoleManagement', 'selectItemList', '✅查询组织下所有成员', 'service', '{}', '{"service": "member", "serviceFunction": "selectMemberFromOgrId"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (370, NULL, NULL, 'memberOrgRoleManagement', 'deleteItem', '✅删除组织成员', 'sql', '{}', '{ "table": "member_org_role", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (371, NULL, NULL, 'memberOrgRoleManagement', 'batchAddMemberOrgRole', '✅批量添加组织成员', 'service', '{}', '{ "service": "org", "serviceFunction": "batchAddMemberOrgRole" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (372, NULL, NULL, 'memberOrgRoleManagement', 'updateItem', '✅更新成员组织', 'sql', '{}', '{ "table": "member_org_role", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (373, NULL, NULL, 'memberOrgRoleManagement', 'selectItem', '✅查询组织成员', 'sql', '{}', '{ "table": "view01_member_org_role", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (374, NULL, NULL, 'appraisalPlanManagement', 'selectItemList', '✅服务端查询-查询列表', 'sql', '{}', '{ "table": "achievement_appraisal", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (375, NULL, NULL, 'archivesSetup', 'selectItemList', '✅服务端查询-查询列表', 'sql', '{}', '{ "table": "achievement_employee_appraisal", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (376, NULL, NULL, 'studentManagement', 'selectItemList', '✅服务端查询-查询列表', 'sql', '{}', '{ "table": "student", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (377, NULL, NULL, 'studentManagement', 'insertItem', '✅服务端查询-添加成员', 'sql', '{}', '{ "table": "student", "operation": "insert" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (378, NULL, NULL, 'studentManagement', 'updateItem', '✅服务端查询-更新成员', 'sql', '{}', '{ "table": "student", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (379, NULL, NULL, 'studentManagement', 'deleteItem', '✅服务端查询-删除信息', 'sql', '{}', '{ "table": "student", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (380, NULL, NULL, 'clockManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_attendance_clock", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (381, NULL, NULL, 'clockManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "attendance_clock", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (382, NULL, NULL, 'clockManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "attendance_clock", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (383, NULL, NULL, 'clockManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "attendance_clock", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (384, NULL, NULL, 'studentManagement', 'selectItemList', '✅服务端查询-查询列表', 'sql', '{}', '{ "table": "student", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (385, NULL, NULL, 'studentManagement', 'insertItem', '✅服务端查询-添加成员', 'sql', '{}', '{ "table": "student", "operation": "insert" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (386, NULL, NULL, 'studentManagement', 'updateItem', '✅服务端查询-更新成员', 'sql', '{}', '{ "table": "student", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (387, NULL, NULL, 'studentManagement', 'deleteItem', '✅服务端查询-删除信息', 'sql', '{}', '{ "table": "student", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (388, NULL, '{"before":[],"after":[{"service":"insurance","serviceFunction":"afterSchemeAppendProjectHook"}]}', 'insuranceSchemeSetup', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "insurance_scheme", "operation": "select" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-14T22:40:56+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (389, NULL, '{"before":[{"service":"insurance","serviceFunction":"beforeCreateSchemeIdHook"}],"after":[]}', 'insuranceSchemeSetup', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "insurance_scheme", "operation": "insert" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-14T22:40:56+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (390, NULL, NULL, 'insuranceSchemeSetup', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "insurance_scheme", "operation": "jhUpdate" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-14T22:40:56+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (391, NULL, NULL, 'insuranceSchemeSetup', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "insurance_scheme", "operation": "jhDelete" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-14T22:40:56+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (392, NULL, NULL, 'salaryGroupManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "salary_group", "operation": "select" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-15T10:48:48+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (393, NULL, '{"before":[{"service":"salary","serviceFunction":"beforeInsertSalaryGroupHook"}],"after":[]}', 'salaryGroupManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "salary_group", "operation": "insert" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-15T10:48:48+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (394, NULL, NULL, 'salaryGroupManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "salary_group", "operation": "jhUpdate" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-15T10:48:48+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (395, NULL, NULL, 'salaryGroupManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "salary_group", "operation": "jhDelete" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-15T10:48:48+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (396, NULL, NULL, 'salaryGroupManagement', 'getSalaryTaxRuleList', '✅查询-查询列表', 'sql', NULL, '{"table":"salary_tax_rule","operation":"select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-15T10:48:48+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (397, NULL, NULL, 'salaryTaxRuleManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "salary_tax_rule", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (398, NULL, NULL, 'salaryTaxRuleManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "salary_tax_rule", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (399, NULL, NULL, 'salaryTaxRuleManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "salary_tax_rule", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (400, NULL, NULL, 'salaryTaxRuleManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "salary_tax_rule", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (401, NULL, NULL, 'candidateManagement', 'selectItemList', '✅服务端查询-查询列表', 'sql', '{}', '{ "table": "recruit_candidate", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (402, NULL, NULL, 'recruitPpostManagement', 'selectItemList', '✅服务端查询-查询列表', 'sql', '{}', '{ "table": "recruit_post", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (403, NULL, NULL, 'employeeManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "employee", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (404, NULL, '{ "before": [{"service": "employee", "serviceFunction": "addEmployeeInsertBeforeHook"}]}', 'employeeManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "employee", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (405, NULL, NULL, 'employeeManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "employee", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (406, NULL, NULL, 'employeeManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "employee", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (408, NULL, NULL, 'jobPostingsManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "job_postings", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (409, NULL, '{"after": [], "before": [{"service": "job", "serviceFunction": "beforHookForGenerateJobId"}]}', 'jobPostingsManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "job_postings", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (410, NULL, NULL, 'jobPostingsManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "job_postings", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (411, NULL, NULL, 'jobPostingsManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "job_postings", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (412, NULL, NULL, 'jobResumeManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "job_resume", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (413, NULL, NULL, 'jobResumeManagement', 'selectJobList', '✅添加', 'sql', '{}', '{ "table": "job_postings", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (414, NULL, NULL, 'jobResumeManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "job_resume", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (415, NULL, NULL, 'jobResumeManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "job_resume", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (416, NULL, NULL, 'jobResumePreview', 'getResumeData', '✅查询简历', 'sql', NULL, '{ "table": "job_resume", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (417, NULL, '{"after":[{"service":"insurance","serviceFunction":"checkNewMonthRecord"}]}', 'insuranceSchemeManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{"table":"view01_insurance_month","operation":"select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-10T15:29:22+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (418, NULL, NULL, 'insuranceSchemeManagement', 'insertMonthRecord', '✅添加', 'service', '{}', '{"service":"insurance","serviceFunction":"insertMonthRecord"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-10T15:29:22+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (419, NULL, NULL, 'insuranceSchemeManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "insurance_month_emp_record", "operation": "jhUpdate" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-10T15:29:22+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (420, NULL, '{"before":[{"service":"insurance","serviceFunction":"beforeCheckDelMonthRecord"}],"after":[{"service":"insurance","serviceFunction":"afterDelEmpRecord"}]}', 'insuranceSchemeManagement', 'deleteItem', '✅删除', 'sql', '{}', '{"table":"insurance_month_record","operation":"delete"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-10T15:29:22+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (421, NULL, NULL, 'insuranceSchemeDetail', 'getMonthRecordInfo', '✅查询-查询列表', 'sql', NULL, '{"table":"insurance_month_record","operation":"select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-10T15:07:51+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (422, NULL, NULL, 'insuranceSchemeDetail', 'getMonthEmpList', '✅查询-查询列表', 'sql', NULL, '{"table":"view01_month_emp_record_detail","operation":"select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-10T15:07:51+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (423, NULL, NULL, 'insuranceSchemeDetail', 'getEmployeeList', '✅查询-查询列表', 'sql', NULL, '{"table":"view01_employee_quit_list","operation":"select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-10T15:07:51+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (424, NULL, '{}', 'insuranceSchemeDetail', 'insertEmployeeRecord', '✅新增-添加数据', 'service', NULL, '{"service":"insurance","serviceFunction":"insertEmployeeRecord"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-10T15:07:51+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (425, NULL, NULL, 'insuranceSchemeDetail', 'getEmpProjectRecordList', '✅查询-查询列表', 'sql', NULL, '{"table":"insurance_month_emp_project_record","operation":"select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-10T15:07:51+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (426, NULL, NULL, 'insuranceSchemeDetail', 'getSchemeList', '✅查询-查询列表', 'sql', NULL, '{"table":"insurance_scheme","operation":"select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-10T15:07:51+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (427, NULL, NULL, 'insuranceSchemeDetail', 'getSchemeProjectList', '✅查询-查询列表', 'sql', NULL, '{"table":"insurance_project","operation":"select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-10T15:07:51+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (428, NULL, NULL, 'insuranceSchemeDetail', 'updateEmpSchemeRecord', '✅查询-查询列表', 'service', NULL, '{"service":"insurance","serviceFunction":"updateEmpSchemeRecord"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-10T15:07:51+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (429, NULL, NULL, 'monthRecordManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "salary_month_record", "operation": "select" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-23T16:42:20+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (430, NULL, NULL, 'monthRecordManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "salary_month_record", "operation": "insert" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-23T16:42:21+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (431, NULL, NULL, 'monthRecordManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "salary_month_record", "operation": "jhUpdate" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-23T16:42:21+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (432, NULL, NULL, 'monthRecordManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "salary_month_record", "operation": "jhDelete" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-23T16:42:21+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (433, NULL, '{"before":[],"after":[{"service":"salary","serviceFunction":"afterAppendNewChangeRecordHook"}]}', 'archivesManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{"table":"view01_employee_archives","operation":"select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-12T22:07:01+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (434, NULL, NULL, 'archivesManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "salary_archives", "operation": "insert" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-12T22:07:01+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (435, NULL, NULL, 'archivesManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "salary_archives", "operation": "jhUpdate" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-12T22:07:01+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (436, NULL, NULL, 'archivesManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "salary_archives", "operation": "jhDelete" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-12T22:07:01+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (437, NULL, NULL, 'slipTmp', 'selectItemList', '✅查询列表', 'sql', '{}', '{"table":"view01_salary_slip_template","operation":"select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-11T15:09:13+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (438, NULL, NULL, 'slipTmp', 'insertItem', '✅添加', 'service', '{}', '{"service":"salary","serviceFunction":"updateSlipOption"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-11T15:09:13+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (439, NULL, NULL, 'slipTmp', 'updateItem', '✅更新', 'service', '{}', '{"service":"salary","serviceFunction":"updateSlipOption"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-11T15:09:13+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (440, NULL, NULL, 'slipTmp', 'deleteItem', '✅删除', 'service', '{}', '{"service":"salary","serviceFunction":"deleteSlipOption"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-11T15:09:13+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (441, NULL, NULL, 'archivesManagement', 'getSalaryOption', '✅查询-查询列表', 'sql', NULL, '{"table":"_constant","operation":"select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-12T22:07:02+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (442, NULL, NULL, 'changeTmp', 'selectItemList', '✅查询列表', 'sql', '{}', '{"table":"salary_change_template","operation":"select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-11T15:09:13+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (443, NULL, '{"before": [{"service": "salary", "serviceFunction": "beforeCreateChangeTmpHook"}]}', 'changeTmp', 'insertItem', '✅添加', 'sql', '{}', '{"table":"salary_change_template","operation":"jhInsert"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-11T15:09:13+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (444, NULL, NULL, 'changeTmp', 'updateItem', '✅更新', 'sql', '{}', '{"table":"salary_change_template","operation":"jhUpdate"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-11T15:09:13+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (445, NULL, NULL, 'changeTmp', 'deleteItem', '✅删除', 'sql', '{}', '{"table":"salary_change_template","operation":"jhDelete"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-11T15:09:13+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (446, NULL, NULL, 'archivesManagement', 'makeEmployeeArchives', '✅定薪', 'service', NULL, '{"service":"salary","serviceFunction":"makeEmployeeArchives"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-12T22:07:02+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (447, NULL, NULL, 'archivesManagement', 'updateEmployeeArchives', '✅调薪', 'service', NULL, '{"service":"salary","serviceFunction":"updateEmployeeArchives"}', NULL, NULL, 'insert', 'vscode', 'vscode', '2022-11-12T22:07:02+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (448, NULL, NULL, 'changeRecord', 'selectItemList', '✅查询列表', 'sql', '{}', '{"table":"salary_change_record","operation":"select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-14T15:25:56+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (449, NULL, NULL, 'changeRecord', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "salary_change_record", "operation": "insert" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-14T15:25:56+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (450, NULL, NULL, 'changeRecord', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "salary_change_record", "operation": "jhUpdate" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-14T15:25:56+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (451, NULL, NULL, 'changeRecord', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "salary_change_record", "operation": "jhDelete" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-14T15:25:56+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (452, NULL, NULL, 'monthEmpRecord', 'selectItemList', '✅查询列表', 'service', '{}', '{"service":"salary","serviceFunction":"monthEmpRecord"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-23T15:44:48+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (453, NULL, NULL, 'monthEmpRecord', 'insertItem', '✅添加', 'service', '{}', '{"service":"salary","serviceFunction":"createMonthRecord"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-23T15:44:48+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (454, NULL, NULL, 'monthEmpRecord', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "salary_month_emp_record", "operation": "jhUpdate" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-23T15:44:48+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (455, NULL, NULL, 'monthEmpRecord', 'deleteItem', '✅删除', 'service', '{}', '{"service":"salary","serviceFunction":"delMonthRecord"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-23T15:44:48+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (456, NULL, NULL, 'monthEmpRecord', 'createMonthRecord', '✅核算工资', 'service', NULL, '{"service":"salary","serviceFunction":"createMonthRecord"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-23T15:44:48+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (457, NULL, NULL, 'monthEmpRecord', 'getLastConfig', '✅查询-查询列表', 'service', NULL, '{"service":"salary","serviceFunction":"getLastConfig"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-23T15:44:48+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (458, NULL, NULL, 'salarySlipManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "salary_slip", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (459, NULL, NULL, 'salarySlipManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "salary_slip", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (460, NULL, NULL, 'salarySlipManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "salary_slip", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (461, NULL, NULL, 'salarySlipManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "salary_slip", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (462, NULL, NULL, 'slipRecordManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_salary_month_record", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (463, NULL, NULL, 'slipRecordManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "salary_slip_record", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (464, NULL, NULL, 'slipRecordManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "salary_slip_record", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (465, NULL, NULL, 'slipRecordManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "salary_slip_record", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (466, NULL, NULL, 'monthEmpRecord', 'createSlipRecord', '✅查询-查询列表', 'service', NULL, '{"service":"salary","serviceFunction":"createSlipRecord"}', NULL, NULL, 'insert', 'vscode', 'vscode', '2022-11-23T15:44:48+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (467, NULL, NULL, 'monthRecordManagement', 'monthEmpRecordByYearMonth', '✅查询-查询列表', 'service', NULL, '{"service":"salary","serviceFunction":"monthEmpRecordByYearMonth"}', NULL, NULL, 'insert', 'vscode', 'vscode', '2022-11-23T16:42:21+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (468, NULL, NULL, 'form', 'getResumeData', '✅列表', 'sql', NULL, '{ "table": "job_resume", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (469, NULL, '{"after": [{"service": "job", "serviceFunction": "afterReturnJobResumeId"}], "before": [{"service": "job", "serviceFunction": "beforHookForGenerateJobResumeId"}]}', 'form', 'submitResume', '✅提交', 'sql', NULL, '{ "table": "job_resume", "operation": "jhInsert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (470, NULL, NULL, 'form', 'getJobData', '✅列表', 'sql', NULL, '{ "table": "job_postings", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (471, NULL, NULL, 'jobResumeOfJobPosition', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view01_job_resume2", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (472, NULL, NULL, 'jobResumeOfJobPosition', 'getStatusCount', '✅简历管理-状态统计', 'sql', '{}', '{ "table": "view01_job_resume2", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (473, NULL, NULL, 'jobResumeOfJobPosition', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "job_resume", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (474, NULL, NULL, 'jobResumeOfJobPosition', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "job_resume", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (475, NULL, NULL, 'jobResumeOfJobPosition', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "job_resume", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (486, NULL, NULL, 'performanceManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "performance", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (487, NULL, '{ "before": [{"service": "performance", "serviceFunction": "addPerformanceInsertBeforeHook"}]}', 'performanceManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "performance", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (488, NULL, NULL, 'performanceManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "performance", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (489, NULL, NULL, 'performanceManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "performance", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (490, NULL, NULL, 'jobResumeManagement', 'getStatusCount', '✅简历管理-状态统计', 'service', '{}', '{ "service": "job", "serviceFunction": "getStatusCount" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (491, NULL, NULL, 'performanceManagement', 'getEmployeeList', '✅查询', 'sql', NULL, '{ "table": "employee", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (492, NULL, '{ "before": [{"service": "employee", "serviceFunction": "addEmployeeInsertBeforeHook"}]}', 'jobResumeOfJobPosition', 'creatEmployeeItem', '✅已入职后创建员工信息', 'sql', '{}', '{ "table": "employee", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (493, NULL, NULL, 'employeeManagement', 'getInsuranceList', '✅获取社保方案列表', 'sql', NULL, '{ "table": "insurance_scheme", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (494, NULL, NULL, 'performanceManagement', 'insertPerformanceRateItem', '✅新增评分数据', 'service', '{}', '{ "service": "performance", "serviceFunction": "insertPerformanceRateItem" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (495, NULL, '{ "after": [{"service": "job", "serviceFunction": "afterEmployItemHook"}]}', 'jobResumeManagement', 'employItem', '✅录用员工', 'sql', NULL, '{ "table": "job_resume", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (496, NULL, '{ "before": [{"service": "performance", "serviceFunction": "addPerformanceInsertBeforeHook"}]}', 'performanceRateManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "performance_employee_rate", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (497, NULL, NULL, 'performanceRateManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "performance_employee_rate", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (498, NULL, NULL, 'performanceRateManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "performance_employee_rate", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (499, NULL, NULL, 'performanceRateManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "performance_employee_rate", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (500, NULL, '{ "before": [{"service": "performance", "serviceFunction": "deleteResultBeforeDeleteItem"}]}', 'performanceManagement', 'insertEndPerformanceItem', '✅新增归档数据', 'service', '{}', '{ "service": "performance", "serviceFunction": "insertPerformanceResult" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (501, NULL, NULL, 'performanceManagement', 'selectResultItemList', '✅查询归档数据', 'sql', '{}', '{ "table": "performance_result", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (502, NULL, NULL, 'performanceResultManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "performance_result", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (503, NULL, NULL, 'performanceResultManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "performance_result", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (504, NULL, NULL, 'performanceResultManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "performance_result", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (505, NULL, NULL, 'performanceResultManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "performance_result", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (506, NULL, NULL, 'performanceEmployeeRateManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "view02_performance_employee_rate", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (507, NULL, NULL, 'performanceEmployeeRateManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "performance_employee_rate", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (508, NULL, NULL, 'performanceEmployeeRateManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "performance_employee_rate", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (509, NULL, NULL, 'performanceEmployeeRateManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "performance_employee_rate", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (510, NULL, NULL, 'workbench', 'getWorkbenchCount', '✅工作台统计数', 'service', NULL, '{"service":"workbench","serviceFunction":"getWorkbenchCount"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (511, NULL, NULL, 'employeeManagement', 'getEmployeeWarnList', '✅获取合同到期列表', 'service', NULL, '{"service":"employee","serviceFunction":"getEmployeeWarnList"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (515, NULL, NULL, 'employeeManagement', 'fileUpload-selectItemList', '✅员工附件查询', 'sql', '{}', '{ "table": "employee_file", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (516, NULL, '{ "before": [{"service": "employee", "serviceFunction": "fillInsertFileParamsBeforeHook"}], "after": [] }', 'employeeManagement', 'fileUpload-insertItem', '✅员工附件上传', 'sql', '{}', '{ "table": "employee_file","operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (517, NULL, NULL, 'employeeManagement', 'fileUpload-updateItem', '✅员工附件修改', 'sql', '{}', '{ "table": "employee_file", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (518, NULL, NULL, 'performanceTemplate', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "performance_tmp", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (519, NULL, '{ "before": [{"service": "performanceTemplate", "serviceFunction": "addTemplateIdBeforeHook"}], "after": [] }', 'performanceTemplate', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "performance_tmp", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (520, NULL, NULL, 'performanceTemplate', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "performance_tmp", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (521, NULL, NULL, 'performanceTemplate', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "performance_tmp", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (522, NULL, NULL, 'performanceManagement', 'selectTemplateList', '✅查询列表', 'sql', '{}', '{ "table": "performance_tmp", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (523, NULL, NULL, 'performanceManagement', 'getOrgList', '✅查询', 'sql', NULL, '{ "table": "org", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (524, NULL, NULL, 'memberOrgRoleManagement', 'updateRoleItem', '✅更新成员组织', 'service', '{}', '{"service":"member","serviceFunction":"updateRoleItem"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (525, NULL, NULL, 'employeeDepartApproved', 'selectItemList', '✅查询', 'sql', '{}', '{ "table": "employee", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (526, NULL, NULL, 'employeeDepartApproved', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "employee", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (527, NULL, NULL, 'employeeDepartApproved', 'updateEntryStatus', '✅更新', 'sql', '{}', '{ "table": "employee", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (528, NULL, NULL, 'employeeManagement', 'insertDepartRequestItem', '✅添加', 'sql', '{}', '{ "table": "employee_request", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (529, NULL, NULL, 'salaryImport', 'importSalaryData', '✅薪资导入-导入', 'service', '{}', '{"service":"salary","serviceFunction":"importSalaryData"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (530, NULL, NULL, 'salaryImport', 'checkSalaryData', '✅薪资导入-检查数据', 'service', '{}', '{"service":"salary","serviceFunction":"checkSalaryData"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (531, NULL, NULL, 'monthEmpRecord', 'batchUpdateItem', '✅在线编辑-批量修改保存', 'service', NULL, '{"service":"salary","serviceFunction":"batchUpdate"}', NULL, NULL, 'insert', 'vscode', 'vscode', '2022-11-23T15:44:48+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (532, NULL, NULL, 'monthEmpHistory', 'selectItemList', '✅查询列表', 'service', '{}', '{"service":"salary","serviceFunction":"monthEmpRecord"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-11-23T15:44:48+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (533, NULL, NULL, 'salaryGroupManagement', 'getEmployeeList', '✅员工列表', 'sql', NULL, '{ "table": "employee", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);