KYGK/src/main/java/com/liang/controller/PrjAnnualbudgetController.java

package com.liang.controller;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.liang.common.JsonTool;
import com.liang.common.base.BaseController;
import com.liang.common.base.BaseResult;
import com.liang.common.utils.ExcelPoiUtil;
import com.liang.entity.*;
import com.liang.service.*;
//import com.liang.vo.service.*;
import io.swagger.annotations.ApiOperation;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.http.ResponseEntity;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletResponse;
import java.util.*;

/**
 * 年度预算(PrjAnnualbudget)表控制层
 *
 * @author makejava
 * @since 2023-05-17 08:56:49
 */
@Controller
@RequestMapping("prjAnnualbudget")
public class PrjAnnualbudgetController extends BaseController {
    /**
     * 服务对象
     */
    @Resource
    private PrjAnnualbudgetService prjAnnualbudgetService;
    @Resource
    private SysDictInfoService sysDictInfoService;
    @Resource
    private BaseProjecttypeService projecttypeService;
    @Resource
    private PrjAnnualbudgetdetailService prjAnnualbudgetdetailService;
    @Resource
    private SysPostInfoService sysPostInfoService;
    @Resource
    private PrjApproverecordService prjApproverecordService;
    @Resource
    private PrjProjectService prjProjectService;
    @Resource
    private PrjFeeschemeService prjFeeschemeService;
    @Resource
    private StaBudgetapprovalService staBudgetapprovalService;
    @Resource
    private CyyService cyyService;

    @Resource
    private   SysUserInfoService  sysUserInfoService;

    @Resource
    private   PrjCompletecompanyService  prjCompletecompanyService;




    /**
     * 分页查询
     *
     * @param prjAnnualbudget 筛选条件
     * @param pageRequest      分页对象
     * @return 查询结果
     */
    @GetMapping
    public ResponseEntity<Page<PrjAnnualbudget>> queryByPage(PrjAnnualbudget prjAnnualbudget, PageRequest pageRequest) {
        return ResponseEntity.ok(this.prjAnnualbudgetService.queryByPage(prjAnnualbudget, pageRequest));
    }

    /**
     * 通过主键查询单条数据
     *
     * @param id 主键
     * @return 单条数据
     */
    @GetMapping("{id}")
    public ResponseEntity<PrjAnnualbudget> queryById(@PathVariable("id") Integer id) {
        return ResponseEntity.ok(this.prjAnnualbudgetService.queryById(id));
    }

    /**
     * 删除数据
     *
     * @param id 主键
     * @return 删除是否成功
     */
    @DeleteMapping
    public ResponseEntity<Boolean> deleteById(Integer id) {
        return ResponseEntity.ok(this.prjAnnualbudgetService.deleteById(id));
    }

    /**
     * 列表初始化
     * @param model
     * @return
     */
    @ApiOperation(value = "页面初始化", notes = "页面初始化")
    @RequestMapping(value = "/init", method = RequestMethod.GET)
    public String init(Model model) {
        //项目类型
        List<Map<String, String>> xmlxList = projecttypeService.getXMLX();
        model.addAttribute("xmlxList", xmlxList);
        //审批状态
        List<Map<String, String>> approveList = sysDictInfoService.queryByCode("xm_status");
        model.addAttribute("approveList", approveList);
        //年份
        List<String> yearList = prjAnnualbudgetService.getYearList();
        model.addAttribute("yearList", yearList);
        //当前用户ID
        model.addAttribute("userId", getSysUserId());

        return "annualbudget/list";
    }

    @ResponseBody
    @RequestMapping(value = "/list", method = RequestMethod.POST)
    public BaseResult list(@RequestParam("page") Integer pageNum,
                           @RequestParam("limit") Integer pageSize,
                           @RequestParam(required = false, defaultValue = "", value = "xmmc") String xmmc,
                           @RequestParam(required = false, defaultValue = "", value = "erpbh") String erpbh,
                           @RequestParam(required = false, defaultValue = "", value = "xmlx") String xmlx,
                           @RequestParam(required = false, defaultValue = "", value = "ssbmmc") String ssbmmc,
                           @RequestParam(required = false, defaultValue = "", value = "spzt") String spzt,
                           @RequestParam(required = false, defaultValue = "", value = "rwsmc") String rwsmc,
                           @RequestParam(required = false, defaultValue = "", value = "nf") String nf,
                           @RequestParam(required = false, defaultValue = "", value = "sortName") String sortName,
                           @RequestParam(required = false, defaultValue = "", value = "sortOrder") String sortOrder) {
        PageHelper.startPage(pageNum, pageSize);

        Map<String, String> paraMap = new HashMap<>();
        paraMap.put("sortName", sortName);
        paraMap.put("sortOrder", sortOrder);
        paraMap.put("xmmc", xmmc);
        paraMap.put("erpbh", erpbh);
        paraMap.put("xmlx", xmlx);

        paraMap.put("ssbmmc", ssbmmc);
        paraMap.put("spzt", spzt);
        paraMap.put("rwsmc", rwsmc);
        paraMap.put("nf", nf);
        List<PrjAnnualbudget> list = prjAnnualbudgetService.getNdysList(paraMap);

        PageInfo<PrjAnnualbudget> pageinfo = new PageInfo<>(list);
        //取出查询结果
        List<PrjAnnualbudget> rows = pageinfo.getList();
        int total = (int) pageinfo.getTotal();
        Map<String, Object> result = new HashMap<>();
        result.put(RESULT_ROWS, rows);
        result.put(RESULT_TOTAL, total);

        return BaseResult.success(result);
    }

    @ApiOperation(value = "页面初始化", notes = "页面初始化")
    @RequestMapping(value = "/init_mylist", method = RequestMethod.GET)
    public String init_mylist(Model model) {
        //项目类型
        List<Map<String, String>> xmlxList = projecttypeService.getXMLX();
        model.addAttribute("xmlxList", xmlxList);
        //审批状态
        List<Map<String, String>> approveList = sysDictInfoService.queryByCode("xm_status");
        model.addAttribute("approveList", approveList);
        //年份
        List<String> yearList = prjAnnualbudgetService.getYearList();
        model.addAttribute("yearList", yearList);

        return "annualbudget/mylist";
    }

    @ResponseBody
    @RequestMapping(value = "/mylist", method = RequestMethod.POST)
    public BaseResult mylist(@RequestParam("page") Integer pageNum,
                             @RequestParam("limit") Integer pageSize,
                             @RequestParam(required = false, defaultValue = "", value = "xmmc") String xmmc,
                             @RequestParam(required = false, defaultValue = "", value = "erpbh") String erpbh,
                             @RequestParam(required = false, defaultValue = "", value = "xmlx") String xmlx,
                             @RequestParam(required = false, defaultValue = "", value = "ssbmmc") String ssbmmc,
                             @RequestParam(required = false, defaultValue = "", value = "spzt") String spzt,
                             @RequestParam(required = false, defaultValue = "", value = "rwsmc") String rwsmc,
                             @RequestParam(required = false, defaultValue = "", value = "nf") String nf,
                             @RequestParam(required = false, defaultValue = "", value = "sortName") String sortName,
                             @RequestParam(required = false, defaultValue = "", value = "sortOrder") String sortOrder) {
        SysUserInfo userInfo = getSysUserInfo();
        List<String> postName = sysUserInfoService.getPostNameByUserId(userInfo.getUserId());
        String post="";
        if(postName.size()>0){
            for (int i = 0; i < postName.size(); i++) {
                if("科研专责".equals(postName.get(i))){
                    post="过";
                }
            }
        }
        PageHelper.startPage(pageNum, pageSize);

        Map<String, String> paraMap = new HashMap<>();
        paraMap.put("sortName", sortName);
        paraMap.put("sortOrder", sortOrder);
        paraMap.put("xmmc", xmmc);
        paraMap.put("erpbh", erpbh);
        paraMap.put("xmlx", xmlx);
        paraMap.put("ssbmmc", ssbmmc);
        paraMap.put("spzt", spzt);
        paraMap.put("rwsmc", rwsmc);
        paraMap.put("nf", nf);

        if(!userInfo.getAccount().equals("admin")){
            if(!"过".equals(post)){
                paraMap.put("userId", userInfo.getUserId().toString());
            }
        }
        List<PrjAnnualbudget> list = prjAnnualbudgetService.getNdysList(paraMap);

        PageInfo<PrjAnnualbudget> pageinfo = new PageInfo<>(list);
        //取出查询结果
        List<PrjAnnualbudget> rows = pageinfo.getList();
        int total = (int) pageinfo.getTotal();
        Map<String, Object> result = new HashMap<>();
        result.put(RESULT_ROWS, rows);
        result.put(RESULT_TOTAL, total);

        return BaseResult.success(result);
    }

    /**
     * 新建数据
     *
     * @return
     */
    @RequestMapping(value = "/forAdd", method = RequestMethod.GET)
    public String forAdd(Model model)
    {
        SysUserInfo userInfo = getSysUserInfo();
        model.addAttribute("userInfo", userInfo);
        return "annualbudget/add_annualbudget";
    }

    @ApiOperation(value = "页面初始化", notes = "页面初始化")
    @RequestMapping(value = "/init_project", method = RequestMethod.GET)
    public String init_rws(Model model) {
        //项目类型
        List<Map<String, String>> xmlxList = projecttypeService.getXMLX();
        model.addAttribute("xmlxList", xmlxList);

        return "annualbudget/list_project";
    }
    /**
     * 获取项目预算列表
     * @return
     */
    @ResponseBody
    @RequestMapping(value = "/list/{nys}", method = RequestMethod.POST)
    public Object list(@PathVariable Integer nys) {
        List<PrjAnnualbudgetdetail> list = prjAnnualbudgetdetailService.getBudgetList(nys);
        Double xmzys=0.0;
//        for (PrjAnnualbudgetdetail prj:list) {
//            Double dw1 = prj.getDw1();
//            Double xmzys = prj.setXmzys(0.0);
//            if (dw1!=null){
//                prj.setXmzys(dw1);
//            }else{
//                prj.setXmzys(0.0);
//            }
//      }
        if (list.size()>0){
            int fy=0;
            int fy1=0;
            int fy2=0;
            int fy3=0;
            int zjfy=0;
            for(int i=0;i<list.size();i++){
                if("总计".equals(list.get(i).getFymc())){
                    zjfy=i;
                    list.get(i).setXmzys(list.get(i).getXmzys());
                }
                if((list.get(i).getFymc()).endsWith("外委支出费")&&!(list.get(i).getFymc()).startsWith("（1）")){
                    fy1=i;
                }
                if("1.外委研究支出费".equals(list.get(i).getFymc())){
                    fy=i;
                }
                if("2.仪器设备租赁费".equals(list.get(i).getFymc())){
                    fy2=i;
                }
                if("3.外协测试试验与加工费".equals(list.get(i).getFymc())){
                    fy3=i;
                }
            }
            double rwsys=0.0;
            double _xmzys=0.0;
            if(list.get(fy).getXmzys()!=null) {
                _xmzys=list.get(fy).getXmzys();
            }
            if(list.get(fy).getRwsys()!=null){
                rwsys=list.get(fy).getRwsys();
            }
            if (_xmzys < (rwsys-_xmzys)||rwsys==_xmzys) {
                PrjAnnualbudget prjAnnualbudget = prjAnnualbudgetService.queryById(nys);
                List<PrjCompletecompany> compList = prjCompletecompanyService.queryByXM(prjAnnualbudget.getRws());
                List flag=new ArrayList<>();
                if(compList.size()>0){
                    for (int i = 0; i < compList.size(); i++) {
                        if("国网陕西省电力公司".equals(compList.get(i).getDwqc())||"国网陕西省电力有限公司".equals(compList.get(i).getDwqc())||"国网陕西省电力公司电力科学研究院".equals(compList.get(i).getDwqc())||"国网陕西省电力有限公司电力科学研究院".equals(compList.get(i).getDwqc())){
                            continue;
                        }
                        flag.add(i);
                    }
                }
                if(flag.size()>0){
                    for (int j = 0; j < flag.size(); j++) {
                        switch (flag.get(j).toString()){
                            case "0":
                                if(list.get(zjfy).getDw1()!=null){
                                    xmzys=xmzys+list.get(zjfy).getDw1();
                                }else{
                                    xmzys=xmzys+0.0;
                                }
                                break;
                            case "1":
                                if(list.get(zjfy).getDw2()!=null){
                                    xmzys=xmzys+list.get(zjfy).getDw2();
                                }else{
                                    xmzys=xmzys+0.0;
                                }
                                break;
                            case "2":
                                if(list.get(zjfy).getDw3()!=null){
                                    xmzys=xmzys+list.get(zjfy).getDw3();
                                }else{
                                    xmzys=xmzys+0.0;
                                }
                                break;
                            case "3":
                                if(list.get(zjfy).getDw4()!=null){
                                    xmzys=xmzys+list.get(zjfy).getDw4();
                                }else{
                                    xmzys=xmzys+0.0;
                                }
                                break;
                            case "4":
                                if(list.get(zjfy).getDw5()!=null){
                                    xmzys=xmzys+list.get(zjfy).getDw5();
                                }else{
                                    xmzys=xmzys+0.0;
                                }
                                break;
                            case "5":
                                if(list.get(zjfy).getDw6()!=null){
                                    xmzys=xmzys+list.get(zjfy).getDw6();
                                }else{
                                    xmzys=xmzys+0.0;
                                }
                                break;
                            case "6":
                                if(list.get(zjfy).getDw7()!=null){
                                    xmzys=xmzys+list.get(zjfy).getDw7();
                                }else{
                                    xmzys=xmzys+0.0;
                                }
                                break;
                            case "7":
                                if(list.get(zjfy).getDw8()!=null){
                                    xmzys=xmzys+list.get(zjfy).getDw8();
                                }else{
                                    xmzys=xmzys+0.0;
                                }
                                break;
                            case "8":
                                if(list.get(zjfy).getDw9()!=null){
                                    xmzys=xmzys+list.get(zjfy).getDw9();
                                }else{
                                    xmzys=xmzys+0.0;
                                }
                                break;
                            case "9":
                                if(list.get(zjfy).getDw10()!=null){
                                    xmzys=xmzys+list.get(zjfy).getDw10();
                                }else{
                                    xmzys=xmzys+0.0;
                                }
                                break;
                            default:
                                System.out.println("flagflag:"+flag);
                                break;
                        }
                    }
                }
            }

            Double xmzyswwje = list.get(fy).getXmzys();
            if(xmzyswwje!=null){
                xmzys=xmzys+xmzyswwje;
            }
            list.get(fy).setXmzys(xmzys);
            Double wwzc=0.0;
            if(list.get(fy).getXmzys()!=null&&fy!=0){
                wwzc=list.get(fy).getXmzys();
            }
            if(list.get(fy2).getXmzys()!=null&&fy2!=0){
                wwzc=wwzc+list.get(fy2).getXmzys();
            }
            if(list.get(fy3).getXmzys()!=null&&fy3!=0){
                wwzc=wwzc+list.get(fy3).getXmzys();
            }
            if(wwzc>0){
                list.get(fy1).setXmzys(wwzc);
            }
//            list.get(fy).setXmzys(xmzys);
        }
        String strData = JsonTool.toJsonString(list);
        return strData;
    }

    /**
     * 保存数据（我的年度预算：基本信息）
     *
     * @return
     */
    @ResponseBody
    @RequestMapping(value = "/doAdd", method = RequestMethod.POST)
    public BaseResult doAdd(PrjAnnualbudget annualbudget)
    {
        annualbudget.setSpzt("未提交");
        int num = prjAnnualbudgetService.insert(annualbudget);
        if (num > 0) {
            //经费预算项插入
            prjAnnualbudgetdetailService.insertBatchByXm(annualbudget.getRws(), annualbudget.getId());
            return BaseResult.success("保存成功!", annualbudget);
        } else if(num == -1) {
            return BaseResult.failure("该项目 " + annualbudget.getNf() + " 年度预算已存在！");
        } else {
            return BaseResult.failure("保存失败!");
        }
    }

    /**
     * 编辑数据（我的年度预算：基本信息）
     *
     * @return
     */
    @ResponseBody
    @RequestMapping(value = "/doUpdate", method = RequestMethod.POST)
    public BaseResult doUpdate(PrjAnnualbudget annualbudget)
    {
        int num = prjAnnualbudgetService.update(annualbudget);
        if (num > 0) {
            return BaseResult.success("保存成功!");
        } else if(num == -1) {
            return BaseResult.failure("该项目 " + annualbudget.getNf() + " 年度预算已存在！");
        } else {
            return BaseResult.failure("保存失败!");
        }
    }
    /**
     * 撤销数据（基本信息）
     *
     * @return
     */
    @ResponseBody
    @RequestMapping(value = "/TJrevokeApprove", method = RequestMethod.POST)
    public BaseResult TJrevokeApprove(@RequestBody String data) {
        //PrjProject rws = JsonTool.parseObject(data, PrjProject.class);
        PrjAnnualbudget ndys = JsonTool.parseObject(data, PrjAnnualbudget.class);
        int num;
        int  temp;
        num = prjAnnualbudgetService.tjrevokeApprove(ndys);
        //修改审批列表里的状态为完成
        temp = prjApproverecordService.updateRevokeRecord(ndys.getId());
        //return BaseResult.success(num+"撤销成功!");
        if (num > 0 && temp > 0) {
            return BaseResult.success("撤销成功!");
        } else {
            return BaseResult.failure("撤销失败!");
        }
    }

    /**
     * 批量删除
     * @param data
     * @return
     */
    @RequestMapping(value = "/batchDelete", method = RequestMethod.POST)
    @ResponseBody
    public BaseResult batchDelete(@RequestBody String data)
    {
        List<PrjAnnualbudget> prjList = JsonTool.parseArray(data, PrjAnnualbudget.class);
        List<Integer> idList = new ArrayList<>();
        prjList.forEach(item -> {
            idList.add(item.getId());
        });

        int num = prjAnnualbudgetService.batchDelete(idList);
        if (num > 0) {
            return BaseResult.success("批量删除成功!");
        } else {
            return BaseResult.failure("批量删除失败!");
        }
    }

//    /**
//     * 编辑数据
//     *
//     * @return
//     */
//    @RequestMapping(value = "/forUpdate/{id}", method = RequestMethod.GET)
//    public String forUpdate(Model model, @PathVariable Integer id)
//    {
//        PrjAnnualbudget annualbudget = prjAnnualbudgetService.queryById(id);
//        model.addAttribute("annualbudget", annualbudget);
//
//        String xmzxq = annualbudget.getXmzxq();
//        model.addAttribute("qs", xmzxq.substring(0, 4));
//        int index = xmzxq.trim().indexOf("至") + 2;
//        model.addAttribute("wc", xmzxq.substring(index, index + 4));
//
//        PrjProject project = prjProjectService.queryById(annualbudget.getRws());
//        model.addAttribute("rwsys", project.getYsje());
//
//       Map<String, String> paraMap = new HashMap<>();
//       paraMap.put("xm", annualbudget.getRws().toString());
//       paraMap.put("nf", annualbudget.getNf());
//       double ndczje = prjFeeschemeService.getNdFeeScheme(paraMap);
//       model.addAttribute("ndczje", ndczje);
//
//
//        return "annualbudget/update_annualbudget";
//    }
    /**
     * 编辑数据
     *
     * @return
     */
    @RequestMapping(value = "/forUpdate/{id}", method = RequestMethod.GET)
    public String forUpdate(Model model, @PathVariable Integer id)
    {
        PrjAnnualbudget annualbudget = prjAnnualbudgetService.queryById(id);
        model.addAttribute("annualbudget", annualbudget);

        String xmzxq = annualbudget.getXmzxq();
        model.addAttribute("qs", xmzxq.substring(0, 4));
        int index = xmzxq.trim().indexOf("至") + 2;
        model.addAttribute("wc", xmzxq.substring(index, index + 4));

        PrjProject project = prjProjectService.queryById(annualbudget.getRws());
        model.addAttribute("rwsys", project.getYsje());

        Map<String, String> paraMap = new HashMap<>();
        if("政府类项目".equals(annualbudget.getXmlxmc())) {
            List<Integer> nfList = prjFeeschemeService.getYearList(annualbudget.getRws());
            paraMap.put("xm", annualbudget.getRws().toString());
            paraMap.put("nf", nfList.get(nfList.size() - 1).toString());
        }else{
            paraMap.put("xm", annualbudget.getRws().toString());
            paraMap.put("nf", annualbudget.getNf());
        }
        Double ndczje;
        if("国网公司科技项目".equals((annualbudget.getXmlxmc()))){
            ndczje= prjFeeschemeService.getNdFeeSchemeofDKY(paraMap);
        }else {
            ndczje= prjFeeschemeService.getNdFeeScheme(paraMap);

        }
        model.addAttribute("ndczje", ndczje);

        return "annualbudget/update_annualbudget";
    }


    /**
     * 查看数据
     *
     * @return
     */
    @RequestMapping(value = "/forView/{id}", method = RequestMethod.GET)
    public String forView(Model model, @PathVariable Integer id)
    {
        PrjAnnualbudget annualbudget = prjAnnualbudgetService.queryById(id);
        model.addAttribute("annualbudget", annualbudget);

        PrjProject project = prjProjectService.queryById(annualbudget.getRws());
        model.addAttribute("rwsys", project.getYsje());

        Map<String, String> paraMap = new HashMap<>();

        if("政府类项目".equals(annualbudget.getXmlxmc())) {
            List<Integer> nfList = prjFeeschemeService.getYearList(annualbudget.getRws());
            paraMap.put("xm", annualbudget.getRws().toString());
            paraMap.put("nf", nfList.get(nfList.size() - 1).toString());
        }else{
            paraMap.put("xm", annualbudget.getRws().toString());
            paraMap.put("nf", annualbudget.getNf());
        }
        Double ndczje;
        if ("国网公司科技项目".equals(annualbudget.getXmlxmc())){
           ndczje = prjFeeschemeService.getNdFeeSchemeofDKY(paraMap);
        }else {
            ndczje = prjFeeschemeService.getNdFeeScheme(paraMap);
        }
        model.addAttribute("ndczje", ndczje);

        return "annualbudget/view_annualbudget";
    }

    /**
     * 查看数据(根据任务书ID)
     *
     * @return
     */
    @RequestMapping(value = "/forNdysView/{rws}", method = RequestMethod.GET)
    public String forNdysView(Model model, @PathVariable Integer rws)
    {
        PrjAnnualbudget annualbudget = prjAnnualbudgetService.queryByRws(rws);
        model.addAttribute("annualbudget", annualbudget);

        return "annualbudget/view_annualbudget";
    }

    /**
     * 新建数据(提交审批)
     *
     * @return
     */
    @RequestMapping(value = "/forApproveAdd", method = RequestMethod.GET)
    public String forApproveAdd(Model model)
    {
        //部门主任岗位
        Map<String, String> paraMap = new HashMap<>();
//        paraMap.put("postName", "部门主任");
        paraMap.put("postName", "科技项目管理专责");
        SysPostInfo postInfo = sysPostInfoService.getSysPostInfo(paraMap);
        if(postInfo == null)
            postInfo = new SysPostInfo();
        model.addAttribute("postInfo", postInfo);

        //系统当前用户
        SysUserInfo userInfo = getSysUserInfo();
        model.addAttribute("userInfo", userInfo);

        return "annualbudget/add_approve";
    }

    /**
     * 更新审批状态
     *
     * @return
     */
    @ResponseBody
    @RequestMapping(value = "/updateSpzt", method = RequestMethod.POST)
    public BaseResult updateSpzt(@RequestBody String strData)
    {
        PrjAnnualbudget annualbudget = JsonTool.parseObject(strData, PrjAnnualbudget.class);
        int num = prjAnnualbudgetService.updateSpzt(annualbudget);
        if (num > 0) {
            return BaseResult.success("保存成功!");
        }
        else {
            return BaseResult.failure("保存失败!");
        }
    }

    /**
     * 编辑数据（提交审批）
     *
     * @return
     */
    @RequestMapping(value = "/forApproveUpdate/{xmid}", method = RequestMethod.GET)
    public String forApproveUpdate(Model model, @PathVariable Integer xmid, @RequestParam String spzt)
    {
        //系统当前用户
        SysUserInfo userInfo = getSysUserInfo();
        model.addAttribute("userInfo", userInfo);

        Map<String, String> paraMap1 = new HashMap<>();
        paraMap1.put("xmid", xmid.toString());
        paraMap1.put("zt", spzt);
        paraMap1.put("wc", "0");
        List<PrjApproverecord> approveList = prjApproverecordService.getApproveByXmId(paraMap1);
        if(approveList.size() > 0)
            model.addAttribute("approveInfo", approveList.get(0));
        else {
            PrjAnnualbudget annualbudget = prjAnnualbudgetService.queryById(xmid);
            PrjApproverecord approveInfo = new PrjApproverecord();
            approveInfo.setXmid(xmid);
            approveInfo.setXm(annualbudget.getMc());
            approveInfo.setZt("数据不匹配");
            model.addAttribute("approveInfo", approveInfo);
        }
//        List<CyyEntriy> cyyList =cyyService.queryByAccount(String.valueOf(userInfo.getUserId()));
//        model.addAttribute("cyyList", cyyList);


        if(spzt.contains("未提交")) {
            Map<String, String> paraMap2 = new HashMap<>();
            paraMap2.put("postName", "科技项目管理专责");

            SysPostInfo postInfo = sysPostInfoService.getSysPostInfo(paraMap2);
            if(postInfo == null)
                postInfo = new SysPostInfo();
            model.addAttribute("postInfo", postInfo);

            return "annualbudget/back_approve";
        } else {
            return "annualbudget/finish_approve";
        }
    }

    //初始化下拉
    @RequestMapping(value = "/init_cyy/{userId}", method = RequestMethod.GET)
    @ResponseBody
    public List<CyyEntriy> init_cyy(Model model,@PathVariable Integer userId) {
        List<CyyEntriy> cyyList =cyyService.queryByAccount(String.valueOf(userId));
        return cyyList;
    }

    /**
     * 审批列表
     * @return
     */
    @RequestMapping(value = "/forApproveList", method = RequestMethod.GET)
    public String forApproveList() {
        return "annualbudget/list_approve";
    }

    /**
     * 新建数据
     *
     * @return
     */
    @RequestMapping(value = "/forApplyAdd/{id}", method = RequestMethod.GET)
    public String forApplyAdd(Model model, @PathVariable Integer id)
    {
        //登录用户
        SysUserInfo userInfo = getSysUserInfo();
        model.addAttribute("userInfo", userInfo);
        //当前预算
        PrjAnnualbudget annualbudget = this.prjAnnualbudgetService.queryById(id);
        model.addAttribute("annualbudget", annualbudget);
        //项目总体费用信息
        StaBudgetapproval xmFyInfo = staBudgetapprovalService.getXmFyInfo(id);
        if(xmFyInfo == null) {
            xmFyInfo = new StaBudgetapproval();
            xmFyInfo.setSqje(0.0);
            xmFyInfo.setBzje(0.0);
        } else {
            if(xmFyInfo.getSqje() == null){
                xmFyInfo.setSqje(0.0);
            }else if(xmFyInfo.getBzje()==null){
                xmFyInfo.setBzje(xmFyInfo.getSqje());
            }
            if(xmFyInfo.getBzje() == null)
                xmFyInfo.setBzje(0.0);

        }
        xmFyInfo.setYsje(annualbudget.getYsje());
        model.addAttribute("xmFyInfo", xmFyInfo);

        return "annualbudget/add_apply";
    }

    /**
     * 导出列表到excel
     * @param response
     */
    @ApiOperation(value = "导出全部数据到excel", notes = "导出全部数据到excel")
    @RequestMapping(value = "/exportExcel", method = RequestMethod.GET)
    @ResponseBody
    public void exportExcel(HttpServletResponse response) {
        List<PrjAnnualbudget> annualBudgets = prjAnnualbudgetService.getNdysList(new HashMap<>());

        List<String> listName = Arrays.asList("名称", "审批状态", "ERP编号", "项目类型", "可研报告", "任务书", "年份", "创建人", "创建时间", "说明");
        List<Map<String, String>> list = new ArrayList<>();
        for (PrjAnnualbudget budget : annualBudgets) {
            Map<String, String> map = new HashMap<>();
            map.put("名称", budget.getMc());
            map.put("审批状态", budget.getSpzt());
            map.put("ERP编号", budget.getErpbh());
            map.put("项目类型", budget.getXmlxmc());
            map.put("可研报告", budget.getXmmc());
            map.put("任务书", budget.getRwsmc());
            map.put("年份", budget.getNf());
            map.put("申请人", budget.getSqrxm());
            map.put("申请时间", budget.getSqsj().toString());
            map.put("说明", budget.getSm());
            list.add(map);
        }

        ExcelPoiUtil.excelPort("年度预算", listName, list, null, response);
    }
}