工资管理系统
2026/4/9大约 3 分钟
工资管理系统
添加导出按钮
1.vue
1.1在<template></template>中找到其他按钮的位置，添加导入按钮
<el-col :span="1.5">
<el-button
type="info"
plain
icon="el-icon-upload2"
size="mini"
@click="handleImport"
v-hasPermi="['system:user:import']"
>导入
</el-button>
</el-col>1.2添加导入对话框
<!-- 用户导入对话框 -->
<el-dialog :title="upload.title" :visible.sync="upload.open" width="400px">
<el-upload
ref="upload"
:limit="1"
accept=".xlsx, .xls"
:headers="upload.headers"
:action="upload.url + '?updateSupport=' + upload.updateSupport"
:disabled="upload.isUploading"
:on-progress="handleFileUploadProgress"
:on-success="handleFileSuccess"
:auto-upload="false"
drag
>
<i class="el-icon-upload"></i>
<div class="el-upload__text">
将文件拖到此处，或
<em>点击上传</em>
</div>
<div class="el-upload__tip" slot="tip">
<el-checkbox v-model="upload.updateSupport"/>
是否更新已经存在的用户数据
<el-link type="info" style="font-size:12px" @click="importTemplate">下载模板</el-link>
</div>
<div class="el-upload__tip" style="color:red" slot="tip">提示：仅允许导入“xls”或“xlsx”格式文件！</div>
</el-upload>
<div slot="footer" class="dialog-footer">
<el-button type="primary" @click="submitFileForm">确 定</el-button>
<el-button @click="upload.open = false">取 消</el-button>
</div>
</el-dialog>1.3在export default的methods添加函数:
handleImport() {
this.upload.title = "用户导入";
this.upload.open = true;
},
/** 下载模板操作 */
importTemplate() {
importTemplate().then(response => {
this.download(response.msg);
});
},
// 文件上传中处理
handleFileUploadProgress(event, file, fileList) {
this.upload.isUploading = true;
},
// 文件上传成功处理
handleFileSuccess(response, file, fileList) {
this.upload.open = false;
this.upload.isUploading = false;
this.$refs.upload.clearFiles();
this.$alert(response.msg, "导入结果", {dangerouslyUseHTMLString: true});
this.getList();
},
// 提交上传文件
submitFileForm() {
this.$refs.upload.submit();
},2.Mapper里添加接口
3.实现接口方法
@Override
public String importSalary(List<SysSalary> salaryList, Boolean isUpdateSupport, String operName) {
if (StringUtils.isNull(salaryList) || salaryList.size() == 0)
{
throw new ServiceException("导入用户数据不能为空！");
}
int successNum = 0;
int failureNum = 0;
StringBuilder successMsg = new StringBuilder();
StringBuilder failureMsg = new StringBuilder();
for (SysSalary sysSalary : salaryList)
{
try
{
// 验证是否存在这个用户
SysSalary u = sysSalaryMapper.selectSysSalaryBySalaryId(sysSalary.getSalaryId());
if (StringUtils.isNull(u))
{
sysSalary.setSalaryId(sysSalary.getSalaryId());
this.insertSysSalary(sysSalary);
successNum++;
successMsg.append("<br/>" + successNum + "工资信息" + sysSalary.getSalaryId() + " 导入成功");
}
else if (isUpdateSupport)
{
sysSalary.setUpdateBy(operName);
this.updateSysSalary(sysSalary);
successNum++;
successMsg.append("<br/>" + successNum + "工资信息 " + sysSalary.getSalaryId() + " 更新成功");
}
else
{
failureNum++;
failureMsg.append("<br/>" + failureNum + "工资信息" + sysSalary.getSalaryId() + " 已存在");
}
}
catch (Exception e)
{
failureNum++;
String msg = "<br/>" + failureNum + "工资" + sysSalary.getSalaryId() + " 导入失败：";
failureMsg.append(msg + e.getMessage());
log.error(msg, e);
}
}
if (failureNum > 0)
{
failureMsg.insert(0, "很抱歉，导入失败！共 " + failureNum + " 条数据格式不正确，错误如下：");
throw new ServiceException(failureMsg.toString());
}
else
{
successMsg.insert(0, "恭喜您，数据已全部导入成功！共 " + successNum + " 条，数据如下：");
}
return successMsg.toString();
}4.在controller层中实现与前端api的对接
public AjaxResult importData(MultipartFile file, boolean updateSupport) throws Exception
{
ExcelUtil<SysSalary> util = new ExcelUtil<SysSalary>(SysSalary.class);
List<SysSalary> salaryList = util.importExcel(file.getInputStream());
// LoginUser loginUser = tokenService.getLoginUser(ServletUtils.getRequest());
String operName = getUsername();
String message = sysSalaryService.importSalary(salaryList, updateSupport, operName);
return AjaxResult.success(message);
}
@GetMapping("/importTemplate")
public AjaxResult importTemplate()
{
ExcelUtil<SysSalary> util = new ExcelUtil<SysSalary>(SysSalary.class);
return util.importTemplateExcel("用户数据");
}添加由学校工资表导出给银行的表的导出按钮
1.在ISysSalaryService接口中添加方法
/**
* 由工资表生成银行表
* @param sysSalary 工资
* @return 银行表集合
*/
public List<SysBank> createBankList(SysSalary sysSalary);2.在SysSalaryServiceImpl.java中实现接口
/**
* 从工资表中拿出银行表所需要的对应数据
* @param sysSalary 工资
* @return
*/
@Override
public List<SysBank> createBankList(SysSalary sysSalary) {
List<SysSalary> salaryList = sysSalaryMapper.selectSysSalaryList(sysSalary);
List<SysBank> res = new ArrayList<>();
for (SysSalary aSysSalary:salaryList){
SysBank aBankData = SpringUtils.getBean("SysBank");
aBankData.setBankcardId(aSysSalary.getBankcardId());
aBankData.setUserName(sysUserMapper.selectUserById(aSysSalary.getUserId()).getUserName());
res.add(aBankData);
}
return res;
}3.在``层对接接口
/**
* 导出递交给银行的工资列表
*/
@PreAuthorize("@ss.hasPermi('system:salary:export')")
@Log(title = "递交给银行的表", businessType = BusinessType.EXPORT)
@PostMapping("/bankExport")
public void bankExport(HttpServletResponse response, SysSalary sysSalary)
{
List<SysBank> list = sysSalaryService.createBankList(sysSalary);
ExcelUtil<SysBank> util = new ExcelUtil<SysBank>(SysBank.class);
util.exportExcel(response, list, "递交给银行的表");
}4.中vue中添加对应按钮
<el-col :span="1.5">
<el-button
type="warning"
plain
icon="el-icon-download"
size="mini"
@click="handleBankExport"
v-hasPermi="['system:salary:export']"
>导出递交给银行的表</el-button>
</el-col>5.添加按钮的函数
/** 导出按钮操作 */
handleBankExport() {
this.download('system/salary/bankExport', {
...this.queryParams
}, `salary_${new Date().getTime()}.xlsx`)
}工具类的位置
bean工场在com.ruoyi.common.utils.spring.SpringUtils中
日期格式处理
mysql
java
vue
Vue element el-table-column标签中对日期进行格式化（全局过滤器） - sunny-cf - 博客园 (cnblogs.com)
使用导出功能的时候必须要有注解和getter srtter方法才能生效