收款单控制层

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;
    }


}