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;//單據(jù)類型

    @Autowired
    private M_provinceDao provinceDao;//省區(qū)名稱

    //根據(jù)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("沒有數(shù)據(jù)");
    }

    //分頁(yè)查詢
    @PostMapping("/page")
    public R<Page> page(@RequestBody ReceiptsDto receiptsDto) {
        //ReceiptsDto receiptsDto1 = new ReceiptsDto();
        //1、判空
        //單據(jù)日期
        LocalDate[] daterange = receiptsDto.getDaterange();
        if (receiptsDto.getDaterange().length > 0) {

            receiptsDto.setStrDate(daterange[0]);//開始時(shí)間
            receiptsDto.setEndDate(daterange[1]);//結(jié)束時(shí)間
        }
        //是否審核
        if (receiptsDto.getHasExamine() != null) {
            //是否審核
            receiptsDto.setHasExamine(receiptsDto.getHasExamine());
        }
        //單據(jù)編號(hào)
        if (StringUtils.isNotEmpty(receiptsDto.getBillNo())) {
            receiptsDto.setBillNo(receiptsDto.getBillNo());
        }
        //省區(qū)

        if (StringUtils.isNotEmpty(receiptsDto.getMpGuid())) {
            receiptsDto.setMpGuid(receiptsDto.getMpGuid());
        }
        //大區(qū)
        if (StringUtils.isNotEmpty(receiptsDto.getMaGuid())) {
            receiptsDto.setMaGuid(receiptsDto.getMaGuid());
            System.out.println("進(jìn)來了。弄慰。柏副。" + receiptsDto.getMaGuid());
        }
        //客戶名稱
        if (StringUtils.isNotEmpty(receiptsDto.getCustomerName())) {
            receiptsDto.setCustomerName(receiptsDto.getCustomerName());
        }
        //所屬系統(tǒng)
        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("該查詢條件下沒有數(shù)據(jù)");
        }
        return R.success(receiptsDtoPage);
    }

    //新增
    @PostMapping()
    public R<String> add(@RequestBody ReceiptsDto receiptsDto) {
        //用單據(jù)編號(hào)工具類生成單據(jù)編號(hào)
        //收款單的單據(jù)編號(hào)是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);//設(shè)置審核人
        receiptsDto.setExDate(LocalDateTime.now());//設(shè)置審核時(shí)間
        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文件導(dǎo)入數(shù)據(jù)
     *
     * @param file
     * @return
     * @throws Exception
     */
    @PostMapping("/upload")
    public R<String> upload(@RequestParam("file") MultipartFile file) throws Exception {
        if (file.isEmpty()) {
            return R.error("上傳文件失敗音半，請(qǐng)選擇文件");
        }
        int add = 0;
        List<String[]> list = POIUtils.readExcel(file);
        List<ReceiptsDto> receiptsDtoList = new ArrayList<>();
        if (list != null && list.size() > 0) {
            // 遍歷讀取電子表
            for (String[] strings : list) {
                //創(chuàng)建對(duì)象
                ReceiptsDto receiptsDto = new ReceiptsDto();

                //省區(qū)名稱
                receiptsDto.setMpName(strings[0]);
                //客戶名稱
                receiptsDto.setMCustomerName(strings[1]);
                //單據(jù)日期
                receiptsDto.setBillDate(LocalDateTime.parse(strings[2]));
                //支票號(hào)
                receiptsDto.setBillNo(strings[3]);
                //回款名稱
                receiptsDto.setReturnAmontName(strings[4]);
                //結(jié)算方式
                receiptsDto.setMSettleName(strings[5]);
                //收支賬戶
                receiptsDto.setMAccountName(strings[6]);
                //實(shí)收金額
                BigDecimal incomeDecimal = new BigDecimal(strings[7]);
                receiptsDto.setIncomeAmount(incomeDecimal);
                //流水類型
                receiptsDto.setFlowType(Integer.valueOf(strings[8]));
                //付款單號(hào)
                receiptsDto.setSbCode(strings[9]);
                //備注
                receiptsDto.setRemark(strings[10]);
                //添加到receiptsDtoList集合中
                receiptsDtoList.add(receiptsDto);
            }
        }
        // 調(diào)用服務(wù)
        add = receiptsService.add(receiptsDtoList);
        return R.success("導(dǎo)入成功挪凑，導(dǎo)入了：" + add + "條數(shù)據(jù)");
    }

    private String getString(String string) {

        if ("".equals(string)) {
            string = "0";
        }
        return string;
    }


}