package com.jieling.controller;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.jieling.common.BaseContext;
import com.jieling.common.R;
import com.jieling.dao.Jxc_b_receiptsDao;
import com.jieling.dao.Jxc_m_receipttypeDao;
import com.jieling.dao.basicDataDao.M_provinceDao;
import com.jieling.domain.Jxc_b_receipts;
import com.jieling.domain.Jxc_m_receipttype;
import com.jieling.domain.S_department;
import com.jieling.domain.basicDataDomain.M_manager;
import com.jieling.domain.basicDataDomain.M_province;
import com.jieling.dto.ReceiptsDto;
import com.jieling.dto.basicDataDTO.GoodsDto;
import com.jieling.dto.basicDataDTO.ManagerDto;
import com.jieling.dto.basicDataDTO.ProvinceDto;
import com.jieling.dto.basicDataDTO.SuppliersDto;
import com.jieling.service.IJxc_b_receiptsService;
import com.jieling.utils.DocumentCodeUtils;
import com.jieling.utils.POIUtils;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
import org.apache.ibatis.logging.stdout.StdOutImpl;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
import javax.servlet.http.HttpServletRequest;
import java.math.BigDecimal;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.util.ArrayList;
import java.util.List;
/**
* <p>
* 收款单
* 前端控制器
* </p>
*
* @author 梁勇文
* @since 2023-05-03
*/
@RestController
@Slf4j
@RequestMapping("/api/receipts")
public class Jxc_b_receiptsController {
@Autowired
private IJxc_b_receiptsService receiptsService;//收款单
@Autowired
private Jxc_b_receiptsDao receiptsDao;
@Autowired
private Jxc_m_receipttypeDao receipttypeDao;//单据类型
@Autowired
private M_provinceDao provinceDao;//省区名称
//根据ID查找
@GetMapping("/{id}")
public R<Jxc_b_receipts> getById(@PathVariable String id) {
Jxc_b_receipts receipts = receiptsService.getById(id);
if (receipts != null) {
return R.success(receipts);
}
return R.error("没有数据");
}
//分页查询
@PostMapping("/page")
public R<Page> page(@RequestBody ReceiptsDto receiptsDto) {
//ReceiptsDto receiptsDto1 = new ReceiptsDto();
//1、判空
//单据日期
LocalDate[] daterange = receiptsDto.getDaterange();
if (receiptsDto.getDaterange().length > 0) {
receiptsDto.setStrDate(daterange[0]);//开始时间
receiptsDto.setEndDate(daterange[1]);//结束时间
}
//是否审核
if (receiptsDto.getHasExamine() != null) {
//是否审核
receiptsDto.setHasExamine(receiptsDto.getHasExamine());
}
//单据编号
if (StringUtils.isNotEmpty(receiptsDto.getBillNo())) {
receiptsDto.setBillNo(receiptsDto.getBillNo());
}
//省区
if (StringUtils.isNotEmpty(receiptsDto.getMpGuid())) {
receiptsDto.setMpGuid(receiptsDto.getMpGuid());
}
//大区
if (StringUtils.isNotEmpty(receiptsDto.getMaGuid())) {
receiptsDto.setMaGuid(receiptsDto.getMaGuid());
System.out.println("进来了。。。" + receiptsDto.getMaGuid());
}
//客户名称
if (StringUtils.isNotEmpty(receiptsDto.getCustomerName())) {
receiptsDto.setCustomerName(receiptsDto.getCustomerName());
}
//所属系统
if (StringUtils.isNotEmpty(receiptsDto.getPriceGroupMainGuid())) {
receiptsDto.setPriceGroupMainGuid(receiptsDto.getPriceGroupMainGuid());
}
//回款名称
if (StringUtils.isNotEmpty(receiptsDto.getReturnAmontName())) {
receiptsDto.setReturnAmontName(receiptsDto.getReturnAmontName());
}
//收支方式
if (StringUtils.isNotEmpty(receiptsDto.getMSettleGuid())) {
receiptsDto.setMSettleGuid(receiptsDto.getMSettleGuid());
}
//收支账户
// mAccountGuid
System.out.println("收支账户GUID是：" + receiptsDto.getMAccountGuid());
System.out.println("收支账户名称是：" + receiptsDto.getMAccountName());
if (StringUtils.isNotEmpty(receiptsDto.getMAccountGuid())) {
receiptsDto.setMAccountGuid(receiptsDto.getMAccountGuid());
}
//收款类型
//客户类型
//备注
if (StringUtils.isNotEmpty(receiptsDto.getRemark())) {
receiptsDto.setRemark(receiptsDto.getRemark());
}
Page<ReceiptsDto> receiptsDtoPage = new Page<>(receiptsDto.getPage(), receiptsDto.getPageSize());
receiptsDao.getAll(receiptsDtoPage, receiptsDto);
long total = receiptsDtoPage.getTotal();
if (total == 0) {
return R.error("该查询条件下没有数据");
}
return R.success(receiptsDtoPage);
}
//新增
@PostMapping()
public R<String> add(@RequestBody ReceiptsDto receiptsDto) {
//用单据编号工具类生成单据编号
//收款单的单据编号是CB
DocumentCodeUtils utils = new DocumentCodeUtils();
String documentCodeFormat = utils.documentCodeFormat("CB", receiptsDto.getMpGuid());
receiptsDto.setBillNo(documentCodeFormat);
boolean save = receiptsService.save(receiptsDto);
if (!save) {
return R.error("新增失败了");
}
return R.success("新增成功了");
}
//修改
@PutMapping("/{id}")
public R<String> update(@PathVariable String id, @RequestBody ReceiptsDto receiptsDto) {
log.info("id...{}", id);
boolean b = receiptsService.updateById(receiptsDto);
if (!b) {
return R.error("修改失败");
}
return R.success("修改成功");
}
//审核、撤回
@PutMapping("/updateByHasExamine")
public R<String> updateByHasExamine(HttpServletRequest request, @RequestBody ReceiptsDto receiptsDto) {
// String id = (String) request.getSession().getAttribute("");
String name = BaseContext.getCurrentName().getMmName();//获取登录人员的登录名
//则更新
System.out.println(" 主键id:" + receiptsDto.getReceiptsGuid());
receiptsDto.setExUser(name);//设置审核人
receiptsDto.setExDate(LocalDateTime.now());//设置审核时间
boolean b = receiptsService.updateById(receiptsDto);
if (b) {
return R.success("修改成功");
}
return R.error("修改失败");
}
//删除
@DeleteMapping("/{id}")
public R<String> delete(@PathVariable String id) {
boolean b = receiptsService.removeById(id);
if (!b) {
return R.error("删除失败");
}
return R.success("删除成功");
}
/**
* 上传excel文件导入数据
*
* @param file
* @return
* @throws Exception
*/
@PostMapping("/upload")
public R<String> upload(@RequestParam("file") MultipartFile file) throws Exception {
if (file.isEmpty()) {
return R.error("上传文件失败，请选择文件");
}
int add = 0;
List<String[]> list = POIUtils.readExcel(file);
List<ReceiptsDto> receiptsDtoList = new ArrayList<>();
if (list != null && list.size() > 0) {
// 遍历读取电子表
for (String[] strings : list) {
//创建对象
ReceiptsDto receiptsDto = new ReceiptsDto();
//省区名称
receiptsDto.setMpName(strings[0]);
//客户名称
receiptsDto.setMCustomerName(strings[1]);
//单据日期
receiptsDto.setBillDate(LocalDateTime.parse(strings[2]));
//支票号
receiptsDto.setBillNo(strings[3]);
//回款名称
receiptsDto.setReturnAmontName(strings[4]);
//结算方式
receiptsDto.setMSettleName(strings[5]);
//收支账户
receiptsDto.setMAccountName(strings[6]);
//实收金额
BigDecimal incomeDecimal = new BigDecimal(strings[7]);
receiptsDto.setIncomeAmount(incomeDecimal);
//流水类型
receiptsDto.setFlowType(Integer.valueOf(strings[8]));
//付款单号
receiptsDto.setSbCode(strings[9]);
//备注
receiptsDto.setRemark(strings[10]);
//添加到receiptsDtoList集合中
receiptsDtoList.add(receiptsDto);
}
}
// 调用服务
add = receiptsService.add(receiptsDtoList);
return R.success("导入成功，导入了：" + add + "条数据");
}
private String getString(String string) {
if ("".equals(string)) {
string = "0";
}
return string;
}
}
网友评论