package org.jeecg.modules.arj.b.controller;


import cn.hutool.core.io.IoUtil;
import cn.hutool.poi.excel.ExcelReader;
import cn.hutool.poi.excel.ExcelUtil;
import cn.hutool.poi.excel.ExcelWriter;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.jeecg.modules.arj.b.entity.Sbjx;
import org.jeecg.modules.arj.b.entity.Scjh;
import org.jeecg.modules.arj.b.service.ScjhService;
import org.jeecg.modules.arj.b.vo.SbjxVo;
import org.jeecg.modules.arj.b.vo.ScjhVo;
import org.jeecg.modules.arj.config.AjaxResult;
import org.jeecg.modules.arj.entity.Head;
import org.jeecg.modules.arj.mapper.HeadMapper;
import org.jeecg.modules.arj.service.HeadService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import javax.annotation.Resource;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import java.io.InputStream;
import java.net.URLEncoder;
import java.util.List;

/*其中org.jeecg.modules.arj.b.service就等于 com.example.demo.service,ScjhService就等于SpiderdataSpiderxrmmwService*/
/*其中org.jeecg.modules.arj.b.entity就等于com.example.demo.entity，Scjh就等于SpiderdataSpiderxrmmw，一种Java的模板引擎语法*/

/**
 * <p>
 * 生产计划表 前端控制器
 * </p>
 *
 * @author hyy
 * @since 2023-05-08
 */
@Api(tags = "B1-生产计划表")
@RestController
@RequestMapping("/b/scjh")
public class ScjhController {

    @Resource
    private ScjhService scjhService;
    @Autowired
    private HeadService headService;

    @Autowired
    private HeadMapper headMapper;

    //新增和修改接口
    @ApiOperation("增加新数据")
    @PostMapping("/add")
    public AjaxResult save(@RequestBody ScjhVo scjhVo) {
        //新增或者更新
        //新增或者更新

        Head h = headService.insert(scjhVo.getHead());
        scjhVo.getScjhList().stream().forEach(item -> item.setHeadId(h.getId()));
        scjhService.saveOrUpdateBatch(scjhVo.getScjhList());

        return AjaxResult.success(h.getId());

    }



    /**
     * 获取最新数据
     *
     * @return 实例对象
     */
    @ApiOperation("获取最新数据")
    @PostMapping("/last")
    public AjaxResult getlastRecord(@RequestBody String leixing) {

        Head head = headService.queryLeixingChanxian("B1", null);
        ScjhVo scjhVo = new ScjhVo();

        if (head == null) return AjaxResult.error("访问无数据");
        List<Scjh> sbjxList = scjhService.queryByHeadId(head.getId());
        scjhVo.setHead(head);
        scjhVo.setScjhList(sbjxList);
        return AjaxResult.success(scjhVo);
    }
    @ApiOperation("通过ID查询单条数据")
    @GetMapping("/id")
    public AjaxResult queryById(String id){
        ScjhVo sbjxVo = new ScjhVo();
        Head head = headService.queryById(id);

        if( head == null ) return  AjaxResult.error("访问无数据");

        sbjxVo.setHead(head);
        sbjxVo.setScjhList(scjhService.queryByHeadId(head.getId()));
        return AjaxResult.success(sbjxVo);
    }
}