package cn.stylefeng.guns.modular.zsx.pm.salesOrder.controller;

import cn.afterturn.easypoi.entity.vo.MapExcelConstants;
import cn.afterturn.easypoi.excel.entity.ExportParams;
import cn.afterturn.easypoi.excel.entity.enmus.ExcelType;
import cn.afterturn.easypoi.excel.entity.params.ExcelExportEntity;
import cn.afterturn.easypoi.view.PoiBaseView;
import cn.stylefeng.guns.base.pojo.page.LayuiPageInfo;
import cn.stylefeng.guns.modular.zsx.pm.salesOrder.entity.SalesOrder;
import cn.stylefeng.guns.modular.zsx.pm.salesOrder.model.params.SalesOrderParam;
import cn.stylefeng.guns.modular.zsx.pm.salesOrder.service.SalesOrderService;
import cn.stylefeng.roses.core.base.controller.BaseController;
import cn.stylefeng.roses.kernel.model.response.ResponseData;
import cn.stylefeng.roses.core.mutidatasource.annotion.DataSource;
import com.baomidou.mybatisplus.extension.api.R;
import lombok.SneakyThrows;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestPart;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Objects;


/**
 * 生产订单控制器
 *
 * @author ruimin
 * @Date 2023-08-26 15:55:23
 */
@Controller
@RequestMapping("/salesOrder")
public class SalesOrderController extends BaseController {

    private String PREFIX = "/modular/pm/salesOrder";

    @Autowired
    private SalesOrderService salesOrderService;

    /**
     * 跳转到主页面
     *
     * @author ruimin
     * @Date 2023-08-26
     */
    @RequestMapping("")
    public String index() {
        return PREFIX + "/salesOrder.html";
    }

    /**
     * 新增页面
     *
     * @author ruimin
     * @Date 2023-08-26
     */
    @RequestMapping("/add")
    public String add() {
        return PREFIX + "/salesOrder_add.html";
    }

    /**
     * 编辑页面
     *
     * @author ruimin
     * @Date 2023-08-26
     */
    @RequestMapping("/edit")
    public String edit() {
        return PREFIX + "/salesOrder_edit.html";
    }

    /**
     * 拆分页面
     *
     * @author ruimin
     * @Date 2023-08-26
     */
    @RequestMapping("/split")
    public String split() {
        return PREFIX + "/split.html";
    }

    /**
     * 下发页面
     *
     * @author ruimin
     * @Date 2023-08-26
     */
    @RequestMapping("/bindParam")
    public String bindParam() {
        return PREFIX + "/bindParam.html";
    }

    /**
     * 新增接口
     *
     * @author ruimin
     * @Date 2023-08-26
     */
    @RequestMapping("/addItem")
    @ResponseBody
    @DataSource(name = "self")
    public ResponseData addItem(SalesOrderParam salesOrderParam) {
        this.salesOrderService.add(salesOrderParam);
        return ResponseData.success();
    }

    /**
     * 编辑接口
     *
     * @author ruimin
     * @Date 2023-08-26
     */
    @RequestMapping("/editItem")
    @ResponseBody
    @DataSource(name = "self")
    public ResponseData editItem(SalesOrderParam salesOrderParam) {
        this.salesOrderService.update(salesOrderParam);
        return ResponseData.success();
    }

    /**
     * 编辑接口
     *
     * @author ruimin
     * @Date 2023-08-26
     */
    @RequestMapping("/updateBySalesOrderId")
    @ResponseBody
    @DataSource(name = "self")
    public ResponseData updateBySalesOrderId(SalesOrderParam salesOrderParam) {
        SalesOrder byId = this.salesOrderService.getById(salesOrderParam.getId());
        byId.setState("2");
        this.salesOrderService.saveOrUpdate(byId);
        return ResponseData.success();
    }


    /**
     * 删除接口
     *
     * @author ruimin
     * @Date 2023-08-26
     */
    @RequestMapping("/delete")
    @ResponseBody
    @DataSource(name = "self")
    public ResponseData delete(SalesOrderParam salesOrderParam) {
        this.salesOrderService.delete(salesOrderParam);
        return ResponseData.success();
    }

    /**
     * 查看详情接口
     *
     * @author ruimin
     * @Date 2023-08-26
     */
    @RequestMapping("/detail")
    @ResponseBody
    @DataSource(name = "self")
    public ResponseData detail(SalesOrderParam salesOrderParam) {
        SalesOrder detail = this.salesOrderService.getById(salesOrderParam.getId());
        return ResponseData.success(detail);
    }

    /**
     * 查询列表
     *
     * @author ruimin
     * @Date 2023-08-26
     */
    @ResponseBody
    @RequestMapping("/list")
    @DataSource(name = "self")
    public LayuiPageInfo list(SalesOrderParam salesOrderParam) {
        return this.salesOrderService.findPageBySpec(salesOrderParam);
    }

    /**
     * 拆分订单方法
     *
     * @author ruimin
     * @Date 2023-08-26
     */
    @ResponseBody
    @RequestMapping("/breakDownOrders")
    @DataSource(name = "self")
    public LayuiPageInfo breakDownOrders(SalesOrderParam salesOrderParam) {
        return this.salesOrderService.breakDownOrders(salesOrderParam);
    }

    /**
     * 拆分绑定下发方法
     *
     * @author ruimin
     * @Date 2023-08-26
     */
    @ResponseBody
    @RequestMapping("/DistributeSalesOrder")
    @DataSource(name = "self")
    public ResponseData DistributeSalesOrder(SalesOrderParam salesOrderParam) {
        this.salesOrderService.DistributeSalesOrder(salesOrderParam);
        return ResponseData.success();
    }

    /**
     * 导入excel
     *
     * @author liwenya
     * @Date 2021-07-09
     */
    @SneakyThrows
    @RequestMapping(value = "/importIn")
    @ResponseBody
    @DataSource(name = "self")
    public ResponseData importIn(@RequestPart("file") MultipartFile file, HttpServletRequest request) throws IOException {

        List<SalesOrder> list = new ArrayList<>();
        XSSFWorkbook sheets = new XSSFWorkbook(file.getInputStream());
        //获取sheet
        XSSFSheet sheet = sheets.getSheet(sheets.getSheetName(0));
        int rows = sheet.getPhysicalNumberOfRows();
        for(int i = 2; i < rows; i++){
            //获取列数
            XSSFRow row = sheet.getRow(i);
            SalesOrder salesOrder = new SalesOrder();
            salesOrder.setSalesOrderCode(String.valueOf(row.getCell(0)).replace(".0", ""));
            salesOrder.setCustomerNo(String.valueOf(row.getCell(1)).replace(".0", ""));
            salesOrder.setCargoNo(row.getCell(2).toString().replace(".0", ""));
            salesOrder.setProductCode(row.getCell(3).toString().replace(".0", ""));
            salesOrder.setProductName(row.getCell(4).toString().replace(".0", ""));
            Cell planNumber = row.getCell(5);
            if(!Objects.equals(planNumber, null) && !Objects.equals(planNumber.toString(),"")){
                double d = planNumber.getNumericCellValue();
                salesOrder.setPlanNumber((int) d);
            }

            Cell planStartTime = row.getCell(6);
            if(HSSFDateUtil.isCellDateFormatted(planStartTime)){
                Date d = planStartTime.getDateCellValue();
                salesOrder.setPlanStartTime(d);
            }

            Cell planEndTime = row.getCell(7);
            if(HSSFDateUtil.isCellDateFormatted(planEndTime)){
                Date d = planEndTime.getDateCellValue();
                salesOrder.setPlanEndTime(d);
            }

            salesOrder.setWorkshopCode(row.getCell(8).toString().replace(".0", ""));
            salesOrder.setLineCode(row.getCell(9).toString().replace(".0", ""));

            Cell deliveryTime = row.getCell(10);
            if(HSSFDateUtil.isCellDateFormatted(deliveryTime)){
                Date d = deliveryTime.getDateCellValue();
                salesOrder.setDeliveryTime(d);
            }

            salesOrder.setOrderSource(row.getCell(11).toString().replace(".0", ""));
            salesOrder.setRemark(row.getCell(12).toString().replace(".0", ""));
            salesOrder.setState("1");
            list.add(salesOrder);
        }

        for(SalesOrder salesOrder : list){
            salesOrderService.save(salesOrder);
        }
        return ResponseData.success("上传成功");
    }

    /**
     * excel导出模板
     *
     * @author liwenya
     * @Date 2021年7月9日 17点01分
     */
    @RequestMapping("/exportOut")
    public void exportOut(ModelMap modelMap, HttpServletRequest request,
                          HttpServletResponse response) {
        List<ExcelExportEntity> entity = new ArrayList<>();
        entity.add(new ExcelExportEntity("订单编号", "salesOrderCode"));
        entity.add(new ExcelExportEntity("客户编号", "customerNo"));
        entity.add(new ExcelExportEntity("货号", "cargoNo"));
        entity.add(new ExcelExportEntity("产品编号", "productCode"));
        entity.add(new ExcelExportEntity("产品名称", "productName"));
        entity.add(new ExcelExportEntity("计划数量", "planNumber"));
        entity.add(new ExcelExportEntity("计划开始时间", "planStartTime"));
        entity.add(new ExcelExportEntity("计划结束时间", "planEndTime"));
        entity.add(new ExcelExportEntity("车间编码", "workshopCode"));
        entity.add(new ExcelExportEntity("产线编码", "lineCode"));
        entity.add(new ExcelExportEntity("交货时间", "deliveryTime"));
        entity.add(new ExcelExportEntity("订单来源", "orderSource"));
        entity.add(new ExcelExportEntity("备注", "remark"));

        ExportParams params = new ExportParams("生产订单", "生产订单", ExcelType.XSSF);
        modelMap.put(MapExcelConstants.MAP_LIST, new ArrayList<>());
        modelMap.put(MapExcelConstants.ENTITY_LIST, entity);
        modelMap.put(MapExcelConstants.PARAMS, params);
        modelMap.put(MapExcelConstants.FILE_NAME, "生产订单");
        PoiBaseView.render(modelMap, request, response, MapExcelConstants.EASYPOI_MAP_EXCEL_VIEW);
    }


}