package com.ruoyi.chargingPile.controller;
|
|
|
import com.alibaba.excel.EasyExcelFactory;
|
import com.alibaba.excel.ExcelWriter;
|
import com.alibaba.excel.write.builder.ExcelWriterBuilder;
|
import com.alibaba.excel.write.metadata.WriteSheet;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.ruoyi.chargingPile.api.dto.ApplyChargingQuery;
|
import com.ruoyi.chargingPile.api.dto.ApplyChargingRemarkDto;
|
import com.ruoyi.chargingPile.api.model.TApplyChargingPile;
|
import com.ruoyi.chargingPile.dto.TApplyChargingPileExportDto;
|
import com.ruoyi.chargingPile.service.TApplyChargingPileService;
|
import com.ruoyi.common.core.constant.Constants;
|
import com.ruoyi.common.core.domain.R;
|
import com.ruoyi.common.core.web.domain.AjaxResult;
|
import com.ruoyi.common.log.annotation.Log;
|
import com.ruoyi.common.log.enums.BusinessType;
|
import com.ruoyi.common.log.enums.OperatorType;
|
import com.ruoyi.common.security.service.TokenService;
|
import io.swagger.annotations.ApiOperation;
|
import org.apache.commons.codec.CharEncoding;
|
import org.springframework.beans.BeanUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.web.bind.annotation.*;
|
|
import javax.servlet.http.HttpServletResponse;
|
import java.io.IOException;
|
import java.io.InputStream;
|
import java.io.UnsupportedEncodingException;
|
import java.net.URL;
|
import java.net.URLEncoder;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
/**
|
* <p>
|
* 前端控制器
|
* </p>
|
*
|
* @author xiaochen
|
* @since 2024-08-07
|
*/
|
@RestController
|
@RequestMapping("/t-apply-charging-pile")
|
public class TApplyChargingPileController {
|
|
private final TApplyChargingPileService applyChargingPileService;
|
private final TokenService tokenService;
|
|
@Autowired
|
public TApplyChargingPileController(TApplyChargingPileService applyChargingPileService, TokenService tokenService) {
|
this.applyChargingPileService = applyChargingPileService;
|
this.tokenService = tokenService;
|
}
|
|
/**
|
* 建桩申请
|
*/
|
@Log(title = "建桩申请", businessType = BusinessType.INSERT,operatorType = OperatorType.MOBILE)
|
@ApiOperation(tags = {"小程序-建桩申请"},value = "建桩申请")
|
@PostMapping(value = "/add")
|
public AjaxResult<Boolean> add(@RequestBody TApplyChargingPile dto) {
|
// 用户id
|
Long userId = tokenService.getLoginUserApplet().getUserId();
|
dto.setAppUserId(userId);
|
return AjaxResult.ok(applyChargingPileService.save(dto));
|
}
|
|
@Log(title = "建桩申请", businessType = BusinessType.INSERT,operatorType = OperatorType.MOBILE)
|
@ApiOperation(tags = {"后台-申请表单-申请建桩"},value = "建桩申请")
|
@PostMapping(value = "/manage/add")
|
public AjaxResult<Boolean> manageAdd(@RequestBody TApplyChargingPile dto) {
|
|
return AjaxResult.ok(applyChargingPileService.save(dto));
|
}
|
|
@ApiOperation(tags = {"后台-申请表单-申请建桩"},value = "列表")
|
@PostMapping(value = "/page")
|
public AjaxResult<Page<TApplyChargingPile>> page(ApplyChargingQuery applyChargingQuery) {
|
Page<TApplyChargingPile> page = applyChargingPileService.lambdaQuery()
|
.like(applyChargingQuery.getName() != null && !applyChargingQuery.getName().equals(""), TApplyChargingPile::getAgentPhone, applyChargingQuery.getName())
|
.page(Page.of(applyChargingQuery.getPageCurr(), applyChargingQuery.getPageSize()));
|
return AjaxResult.ok(page);
|
}
|
|
|
@ApiOperation(tags = {"后台-申请表单-申请建桩"},value = "导出")
|
@PutMapping(value = "/export")
|
public R export(HttpServletResponse response) {
|
try {
|
response.setCharacterEncoding(Constants.UTF8);
|
response.setContentType("application/vnd.ms-excel");
|
response.setHeader("Access-Control-Expose-Headers", "Content-disposition");
|
response.setHeader("Content-Disposition", "attachment;filename=" +
|
URLEncoder.encode("申请建桩数据", CharEncoding.UTF_8) + ".xlsx");
|
} catch (UnsupportedEncodingException e) {
|
return R.fail("excel导出失败！");
|
}
|
try {
|
List<TApplyChargingPile> list = applyChargingPileService.lambdaQuery().list();
|
|
List<TApplyChargingPileExportDto> exportDtos =new ArrayList<>();
|
for (TApplyChargingPile tApplyChargingPile : list) {
|
TApplyChargingPileExportDto applyChargingPileExportDto = new TApplyChargingPileExportDto();
|
BeanUtils.copyProperties(tApplyChargingPile,applyChargingPileExportDto);
|
applyChargingPileExportDto.setLandlordFrontIdCard(new URL(tApplyChargingPile.getLandlordFrontIdCard()));
|
applyChargingPileExportDto.setLandlordBackIdCard(new URL(tApplyChargingPile.getLandlordBackIdCard()));
|
applyChargingPileExportDto.setAgentBackIdCard(new URL(tApplyChargingPile.getAgentBackIdCard()));
|
applyChargingPileExportDto.setAgentFrontIdCard(new URL(tApplyChargingPile.getAgentFrontIdCard()));
|
List<URL> urls = new ArrayList<>();
|
urls.add(new URL("https://img-blog.csdnimg.cn/direct/c11088e1790049a5b84a0fda21a271b1.png"));
|
urls.add(new URL("https://img-blog.csdnimg.cn/direct/c11088e1790049a5b84a0fda21a271b1.png"));
|
urls.add(new URL("https://img-blog.csdnimg.cn/direct/c11088e1790049a5b84a0fda21a271b1.png"));
|
applyChargingPileExportDto.setUrls(urls);
|
exportDtos.add(applyChargingPileExportDto);
|
|
}
|
|
// excel模板封装
|
ExcelWriterBuilder excelWriterBuilder = EasyExcelFactory.write(response.getOutputStream());
|
InputStream stream = Thread.currentThread().getContextClassLoader().getResourceAsStream("template/" +"充电桩申请记录" + ".xlsx");
|
// 自动释放资源
|
try (ExcelWriter excelWriter = excelWriterBuilder.withTemplate(stream).build()) {
|
WriteSheet writeSheet = EasyExcelFactory.writerSheet().build();
|
excelWriter.fill(list, writeSheet);
|
excelWriter.finish();
|
} catch (Exception e) {
|
return R.fail("excel导出失败！");
|
}
|
} catch (IOException e) {
|
return R.fail("excel导出失败！");
|
}
|
return R.ok();
|
}
|
|
@ApiOperation(tags = {"后台-申请表单-申请建桩"},value = "详情")
|
@PostMapping(value = "/detail/{id}")
|
public AjaxResult<TApplyChargingPile> detail(@PathVariable Integer id) {
|
|
return AjaxResult.ok(applyChargingPileService.getById(id));
|
}
|
|
@ApiOperation(tags = {"后台-申请表单-申请建桩"},value = "修改备注")
|
@PostMapping(value = "/remark")
|
public AjaxResult<TApplyChargingPile> remark(@RequestBody ApplyChargingRemarkDto applyChargingRemarkDt) {
|
TApplyChargingPile byId = applyChargingPileService.getById(applyChargingRemarkDt.getId());
|
byId.setRemark(applyChargingRemarkDt.getRemark());
|
applyChargingPileService.updateById(byId);
|
return AjaxResult.success();
|
}
|
@ApiOperation(tags = {"后台-申请表单-申请建桩"},value = "删除")
|
@DeleteMapping(value = "/remark")
|
public AjaxResult remark(String ids) {
|
|
String[] split = ids.split(",");
|
for (String s : split) {
|
applyChargingPileService.removeById(s);
|
|
}
|
return AjaxResult.success();
|
|
}
|
|
|
|
|
|
|
}
|
