社区方案1

package com.app.api.controller;

import java.util.ArrayList;

import java.util.Date;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.apache.shiro.authz.annotation.RequiresPermissions;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.ResponseBody;

import com.app.model.TApierp1003;

import com.app.model.TSample;

import com.app.model.TZndeliveryplan;

import com.app.service.EMS3DService;

import com.app.service.OtherReportService;

import com.app.service.SimpleSqlService;

import com.app.service.TApierp1003Service;

import com.app.service.TChengbenzdlService;

import com.app.service.TCodeService;

import com.app.service.TPlandayService;

import com.app.service.TPlanmonthService;

import com.app.service.TStorechartService;

import com.app.service.TZndeliveryplanService;

import com.app.service.TZnoutcarService;

import com.app.util.CommonUtil;

import com.app.util.HttpUtil;

import com.app.util.SendMessApi;

import com.system.util.ConvertUtil;

import com.system.util.Page;

import com.system.util.ResultUtil;

/**

 * ERP系统

 * 

 * @author Administrator

 *

 */

@Controller

@ResponseBody

@RequestMapping("/api/3d")

public class Api3DController {

@Autowired

private OtherReportService otherReportService;

@Autowired

private TPlanmonthService tplanmonthService;

@Autowired

private TPlandayService tplandayService;

@Autowired

private TStorechartService tstorechartService;

@Autowired

private TApierp1003Service tapierp1003Service;

@Autowired

private EMS3DService ems3dService;

@Autowired

private TChengbenzdlService tchengbenzdlService;

// 获取成本数据

@RequestMapping(value = "/testapi")

public ResultUtil testapi(HttpServletRequest req) {

return ResultUtil.ok();

}

// 原料投入日查询 (前一天）

@RequestMapping(value = "/getmstinputdaylist")

public ResultUtil getmstinputdaylist(HttpServletRequest req) {

String bday = req.getParameter("beginday");

String eday = req.getParameter("endday");

/*

* ResultUtil r = new ResultUtil(); r.setMsg("操作成功"); r.setCode(0);

* String bday = req.getParameter("beginday"); String eday =

* req.getParameter("endday");

* r.setData(this.ems3dService.getmstinstoreReport(bday, eday));

*/

List<Map<String, Object>> lst = this.otherReportService.gethometouliao(bday);

Page p = new Page();

p.setListdate(lst);

p.setTotalCnt(100L);

p.setPageIndex(0);

p.setPageSize(100);

ResultUtil resultUtil = new ResultUtil();

resultUtil.setCode(0);

resultUtil.setCount(p.getTotalCnt());

resultUtil.setData(p.getListdate());

/*

* 原料投入日查询 (前一天） getmstinputdaylist 传入参数 beginday 开始日期 2020-09-01 endday

* 结束日期 传出参数 mstname 物料名称 ywgt 本月累计重量 gjwgt 干基重量

*/

return resultUtil;

}

// 日产量

@RequestMapping(value = "/getmstworkdaylist")

public ResultUtil getmstworkdaylist(HttpServletRequest req) {

/*

* ResultUtil r = new ResultUtil(); r.setMsg("操作成功"); r.setCode(0);

* String bday = req.getParameter("beginday"); String eday =

* req.getParameter("endday");

* r.setData(this.ems3dService.getworkwgtdayreportPageList(bday, eday));

* return r;

*/

String bday = req.getParameter("beginday");

List<Map<String, Object>> lst = this.otherReportService.gethomewrktableList(bday);

Page p = new Page();

p.setListdate(lst);

p.setTotalCnt(100L);

p.setPageIndex(0);

p.setPageSize(100);

ResultUtil resultUtil = new ResultUtil();

resultUtil.setCode(0);

resultUtil.setCount(p.getTotalCnt());

resultUtil.setData(p.getListdate());

return resultUtil;

}

// 日能源消耗

@RequestMapping(value = "/getenedaylist")

public ResultUtil getenedaylist(HttpServletRequest req) {

ResultUtil r = new ResultUtil();

r.setMsg("操作成功");

r.setCode(0);

String bday = req.getParameter("beginday");

String eday = req.getParameter("endday");

r.setData(this.ems3dService.getenedayreportpagelist(bday, eday));

return r;

}

// 日能源消耗

@RequestMapping(value = "/getenedaylist2")

public String getenedaylist2(HttpServletRequest req) {

String bday = req.getParameter("beginday");

String eday = req.getParameter("endday");

Map<String, Object> mp = new HashMap<String, Object>();

String url ="http://10.84.28.30:8090/ZDLInfo/getenedaylist?beginday="+bday+"&endday="+eday;

return HttpUtil

.doGet(url);

// 2025年7月31日09:31:30 wz 和陆伟

/*

* ResultUtil r = new ResultUtil(); r.setMsg("操作成功"); r.setCode(0);

* String bday = req.getParameter("beginday"); String eday =

* req.getParameter("endday");

* r.setData(this.ems3dService.getenedayreportpagelist(bday, eday));

*/

// 日能源消耗

// getenedaylist

// 传入参数：

// beginday 开始日期 格式：2020-09-01

// endday 结束日期

// 输出参数

// g.day # 日期

// ,fngetcode(g.groupcd,'C021') as groupname #班组

// ,fngetcode(g.teamcd,'C010') as teamname # 班次

// ,t.cppkbl, # 转底炉车间转底炉煤气

// t.cppgll, # 转底炉车间转底炉煤气

// t.cppcys, # 转底炉车间除盐水

// t.cppgys, # 转底炉车间 工业新水=清水

// t.cppdql, # 转底炉车间氮气

// t.cppyql, # 转底炉车间氮气

// t.cppzql, # 转底炉车间蒸汽消耗

// t.cppdnl, #转底炉车间电能

// t.sxgyxs, # 水洗车间工业 清水

// t.sxzls, # 水洗车间 自来水

// t.sxdnl, # 水洗车间工业新水

// t.sxzql, # 水洗蒸汽消耗

// t.sxdql # 水洗车间氮气

}

// 日计划

@RequestMapping(value = "/getworkdayplanlist")

public ResultUtil getworkdayplanlist(HttpServletRequest req) {

ResultUtil r = new ResultUtil();

r.setMsg("操作成功");

r.setCode(0);

String bday = req.getParameter("beginday");

String eday = req.getParameter("endday");

r.setData(this.ems3dService.rijihua(bday, eday));

return r;

}

// 月计划

@RequestMapping(value = "/getworkmonthplanlist")

public ResultUtil getworkmonthplanlist(HttpServletRequest req) {

ResultUtil r = new ResultUtil();

r.setMsg("操作成功");

r.setCode(0);

String bday = req.getParameter("beginmonth");

String eday = req.getParameter("endmonth");

r.setData(this.ems3dService.yjihua(bday, eday));

return r;

}

// 库图

@RequestMapping(value = "/getstorechartlist")

public ResultUtil getstorechartlist(HttpServletRequest req) {

/*

* ResultUtil r = new ResultUtil(); r.setMsg("操作成功"); r.setCode(0);

* r.setData(this.ems3dService.getkutulist()); return r;

*/

List<Map<String, Object>> lst = this.otherReportService.gethomekc();

Page p = new Page();

p.setListdate(lst);

p.setTotalCnt(100L);

p.setPageIndex(0);

p.setPageSize(100);

ResultUtil resultUtil = new ResultUtil();

resultUtil.setCode(0);

resultUtil.setCount(p.getTotalCnt());

resultUtil.setData(p.getListdate());

return resultUtil;

}

// 生成实绩—生产总误时

@RequestMapping(value = "/getworkwushilist")

public ResultUtil getworkwushilist(HttpServletRequest req) {

ResultUtil r = new ResultUtil();

r.setMsg("操作成功");

r.setCode(0);

String bday = req.getParameter("beginday");

String eday = req.getParameter("endday");

r.setData(this.ems3dService.getworkwushilist(bday, eday));

return r;

}

// 智能物流-成品出厂

@RequestMapping(value = "/getproductoutlist")

public ResultUtil getproductoutlist(HttpServletRequest req) {

String bday = req.getParameter("beginday");

String eday = req.getParameter("endday");

ResultUtil r = new ResultUtil();

r.setMsg("操作成功");

r.setCode(0);

r.setData(this.ems3dService.getproductoutlist(bday, eday));

return r;

}

// 智能物流-原料进厂

@RequestMapping(value = "/getrawmstlist")

public ResultUtil getrawmstlist(HttpServletRequest req) {

String bday = req.getParameter("beginday");

String eday = req.getParameter("endday");

ResultUtil r = new ResultUtil();

r.setMsg("操作成功");

r.setCode(0);

// r.setData(this.ems3dService.getrawmstlist(bday, eday));

r.setData(this.otherReportService.gethomewbtableList(bday, eday));

return r;

}

// 成本模块-能源消耗成本

@RequestMapping(value = "/getenecostlist")

public ResultUtil getenecostlist(HttpServletRequest req) {

String bday = req.getParameter("beginday");

String eday = req.getParameter("endday");

ResultUtil r = new ResultUtil();

r.setMsg("操作成功");

r.setCode(0);

r.setData(this.otherReportService.getenecostlist(bday, eday));

return r;

}

// 智能物流-本日成本

@RequestMapping(value = "/getdaycostlist")

public ResultUtil getdaycostlist(HttpServletRequest req) {

String rq = req.getParameter("day");

List<Map<String, Object>> lst = this.tapierp1003Service.getdaytjlist(rq);

ResultUtil r = new ResultUtil();

r.setMsg("操作成功");

r.setCode(0);

r.setData(lst);

return r;

}

// 转运计划

@RequestMapping(value = "/getcarplanlist")

public ResultUtil getcarplanlist(HttpServletRequest req) {

String bday = req.getParameter("beginday");

String eday = req.getParameter("endday");

ResultUtil r = new ResultUtil();

r.setMsg("操作成功");

r.setCode(0);

r.setData(this.ems3dService.getcarplanlist(bday, eday));

return r;

}

// 转运计划

@RequestMapping(value = "/getcarplaninfolist")

public ResultUtil getcarplaninfolist(HttpServletRequest req) {

String bday = req.getParameter("id");// 开始

ResultUtil r = new ResultUtil();

r.setMsg("操作成功");

r.setCode(0);

r.setData(this.ems3dService.getcarplaninfolist(bday));

return r;

}

// 月统计

@RequestMapping(value = "/getmonthreport")

public ResultUtil getmonthreport(HttpServletRequest req) {

String month = req.getParameter("month");// 月份

ResultUtil r = new ResultUtil();

r.setMsg("操作成功");

r.setCode(0);

r.setData(this.ems3dService.getmonthreport(month));

return r;

}

// 转底炉日成本

@RequestMapping(value = "/getdaychengbenreport")

public ResultUtil getdaychengbenreport(HttpServletRequest req) {

String rq = req.getParameter("rq");// 日期

if (rq == "" || rq.length() < 10) {

return ResultUtil.error("日期不能为空，日期的格式如：2021-12-20");

}

Page p = this.tchengbenzdlService.getPage(1, 100, rq, "Y");

if (p.getTotalCnt() <= 0) {

this.tchengbenzdlService.initdata(rq, "admin");

p = this.tchengbenzdlService.getPage(1, 100, rq, "Y");

}

ResultUtil resultUtil = new ResultUtil();

resultUtil.setCode(0);

resultUtil.setCount(p.getTotalCnt());

resultUtil.setData(p.getListdate());

return resultUtil;

}

    

    public static void main(String [] args){

}

}