package com.ruoyi.web.controller.api;
|
|
import com.ruoyi.common.annotation.Log;
|
import com.ruoyi.common.core.controller.BaseController;
|
import com.ruoyi.common.core.domain.AjaxResult;
|
import com.ruoyi.common.enums.BusinessType;
|
import com.ruoyi.system.dto.SysCardDeleteRequest;
|
import com.ruoyi.system.dto.SysCardDetailRequest;
|
import com.ruoyi.system.dto.SysCardEmployeeRequest;
|
import com.ruoyi.system.dto.SysCardPageRequest;
|
import com.ruoyi.system.dto.SysCardSaveRequest;
|
import com.ruoyi.system.service.ISysCardService;
|
import com.ruoyi.system.vo.SysCardVO;
|
import org.apache.poi.ss.usermodel.Cell;
|
import org.apache.poi.ss.usermodel.Row;
|
import org.apache.poi.ss.usermodel.Sheet;
|
import org.apache.poi.ss.usermodel.Workbook;
|
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.security.access.prepost.PreAuthorize;
|
import org.springframework.web.bind.annotation.PostMapping;
|
import org.springframework.web.bind.annotation.RequestBody;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.RequestParam;
|
import org.springframework.web.bind.annotation.RestController;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import javax.servlet.http.HttpServletResponse;
|
import java.io.IOException;
|
import java.net.URLEncoder;
|
import java.text.SimpleDateFormat;
|
import java.util.List;
|
|
/**
|
* 卡片管理接口。卡片属于本地设备侧数据，不受中台版本管控。
|
*/
|
@RestController
|
@RequestMapping("/system/card")
|
public class SysCardController extends BaseController
|
{
|
@Autowired
|
private ISysCardService cardService;
|
|
@Log(title = "卡片管理", businessType = BusinessType.SELECT)
|
@PreAuthorize("@ss.hasPermi('visitor:card:view')")
|
@PostMapping("/page")
|
public AjaxResult page(@RequestBody(required = false) SysCardPageRequest request)
|
{
|
return success(cardService.pageList(request));
|
}
|
|
@Log(title = "卡片管理", businessType = BusinessType.SELECT)
|
@PreAuthorize("@ss.hasPermi('visitor:card:view')")
|
@PostMapping("/detail")
|
public AjaxResult detail(@RequestBody SysCardDetailRequest request)
|
{
|
return success(cardService.detail(request));
|
}
|
|
@Log(title = "卡片管理", businessType = BusinessType.SELECT)
|
@PreAuthorize("@ss.hasPermi('visitor:card:view')")
|
@PostMapping("/employee")
|
public AjaxResult employee(@RequestBody SysCardEmployeeRequest request)
|
{
|
return success(cardService.findEmployee(request));
|
}
|
|
@Log(title = "卡片管理", businessType = BusinessType.INSERT)
|
@PreAuthorize("@ss.hasPermi('visitor:card:add')")
|
@PostMapping("/add")
|
public AjaxResult add(@RequestBody SysCardSaveRequest request)
|
{
|
return toAjax(cardService.save(request, getUsername()));
|
}
|
|
@Log(title = "卡片管理", businessType = BusinessType.UPDATE)
|
@PreAuthorize("@ss.hasPermi('visitor:card:edit')")
|
@PostMapping("/edit")
|
public AjaxResult edit(@RequestBody SysCardSaveRequest request)
|
{
|
return toAjax(cardService.save(request, getUsername()));
|
}
|
|
@Log(title = "卡片管理", businessType = BusinessType.UPDATE)
|
@PreAuthorize("@ss.hasPermi('visitor:card:bind')")
|
@PostMapping("/bind")
|
public AjaxResult bind(@RequestBody SysCardSaveRequest request)
|
{
|
return toAjax(cardService.save(request, getUsername()));
|
}
|
|
@Log(title = "卡片管理", businessType = BusinessType.UPDATE)
|
@PreAuthorize("@ss.hasPermi('visitor:card:unbind')")
|
@PostMapping("/unbind")
|
public AjaxResult unbind(@RequestBody SysCardSaveRequest request)
|
{
|
request.setEmployeeId(null);
|
request.setEmployeeName(null);
|
return toAjax(cardService.save(request, getUsername()));
|
}
|
|
@Log(title = "卡片管理", businessType = BusinessType.DELETE)
|
@PreAuthorize("@ss.hasPermi('visitor:card:remove')")
|
@PostMapping("/delete")
|
public AjaxResult delete(@RequestBody SysCardDeleteRequest request)
|
{
|
return toAjax(cardService.delete(request, getUsername()));
|
}
|
|
@Log(title = "卡片管理", businessType = BusinessType.IMPORT)
|
@PreAuthorize("@ss.hasPermi('visitor:card:import')")
|
@PostMapping("/importData")
|
public AjaxResult importData(@RequestParam("file") MultipartFile file) throws IOException
|
{
|
if (file == null || file.isEmpty())
|
{
|
return error("请选择导入文件");
|
}
|
return success(cardService.importData(file.getInputStream(), getUsername()));
|
}
|
|
@Log(title = "卡片管理", businessType = BusinessType.EXPORT)
|
@PreAuthorize("@ss.hasPermi('visitor:card:export')")
|
@PostMapping("/export")
|
public void export(@RequestBody(required = false) SysCardPageRequest request, HttpServletResponse response) throws IOException
|
{
|
response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
|
response.setCharacterEncoding("utf-8");
|
String fileName = URLEncoder.encode("卡片列表", "UTF-8").replaceAll("\\+", "%20");
|
response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
|
List<SysCardVO> cards = cardService.list(request);
|
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
try (Workbook workbook = new XSSFWorkbook())
|
{
|
Sheet sheet = workbook.createSheet("卡片列表");
|
String[] headers = {"卡号", "员工姓名", "联系方式", "所属部门", "绑定时间", "卡片状态"};
|
Row headerRow = sheet.createRow(0);
|
for (int index = 0; index < headers.length; index++)
|
{
|
Cell cell = headerRow.createCell(index);
|
cell.setCellValue(headers[index]);
|
sheet.setColumnWidth(index, 22 * 256);
|
}
|
for (int index = 0; index < cards.size(); index++)
|
{
|
SysCardVO card = cards.get(index);
|
Row row = sheet.createRow(index + 1);
|
row.createCell(0).setCellValue(value(card.getCardNo()));
|
row.createCell(1).setCellValue(value(card.getEmployeeName()));
|
row.createCell(2).setCellValue(value(card.getContactPhone()));
|
row.createCell(3).setCellValue(value(card.getDeptName()));
|
row.createCell(4).setCellValue(card.getBindTime() == null ? "" : dateFormat.format(card.getBindTime()));
|
row.createCell(5).setCellValue(Boolean.TRUE.equals(card.getBound()) ? "已绑定" : "未绑定");
|
}
|
workbook.write(response.getOutputStream());
|
}
|
}
|
|
@Log(title = "卡片管理", businessType = BusinessType.EXPORT)
|
@PreAuthorize("@ss.hasPermi('visitor:card:import')")
|
@PostMapping("/importTemplate")
|
public void importTemplate(HttpServletResponse response) throws IOException
|
{
|
response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
|
response.setCharacterEncoding("utf-8");
|
String fileName = URLEncoder.encode("卡片导入模板", "UTF-8").replaceAll("\\+", "%20");
|
response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
|
try (Workbook workbook = new XSSFWorkbook())
|
{
|
Sheet sheet = workbook.createSheet("卡片导入");
|
String[] headers = {"卡号", "员工姓名"};
|
Row headerRow = sheet.createRow(0);
|
for (int index = 0; index < headers.length; index++)
|
{
|
headerRow.createCell(index).setCellValue(headers[index]);
|
sheet.setColumnWidth(index, 24 * 256);
|
}
|
workbook.write(response.getOutputStream());
|
}
|
}
|
|
private String value(String value)
|
{
|
return value == null ? "" : value;
|
}
|
}
|
