package cn.ksource.web.controller.tj;
|
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
import javax.annotation.Resource;
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
|
import net.sf.json.JSONArray;
|
import net.sf.json.JSONObject;
|
|
import org.apache.axis.client.HappyClient;
|
import org.springframework.stereotype.Controller;
|
import org.springframework.ui.Model;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.RequestMethod;
|
|
import cn.ksource.beans.CMDB_CI_BASE;
|
import cn.ksource.beans.SPARE_PART;
|
import cn.ksource.core.util.ConvertUtil;
|
import cn.ksource.core.util.DateUtil;
|
import cn.ksource.core.util.JsonUtil;
|
import cn.ksource.core.util.StringUtil;
|
import cn.ksource.core.web.WebUtil;
|
import cn.ksource.web.Constants;
|
import cn.ksource.web.facade.bpbj.SparePartsFacade;
|
import cn.ksource.web.facade.customermanage.CustomerManageFacade;
|
import cn.ksource.web.facade.tj.CiStatisFacade;
|
import cn.ksource.web.facade.tj.SparePartStatisFacade;
|
|
@RequestMapping("/business/pages/tj/sparePartStatis/")
|
@Controller
|
public class sparePartStatisController {
|
@Resource
|
private SparePartStatisFacade sparePartStatisfacade;
|
|
@Resource
|
private CustomerManageFacade customerFacade;
|
@Resource
|
private SparePartsFacade sparePartsFacade;
|
|
/**
|
*
|
* @param request
|
* @param response
|
* @return
|
*/
|
@RequestMapping(value="spareTypeChart.html",method=RequestMethod.GET)
|
public String spareTypeChart(Model model,HttpServletRequest request,HttpServletResponse response) {
|
return "/business/pages/tj/sparePartStatis/spareTypeChart";
|
}
|
|
/**
|
*
|
* @param request
|
* @param response
|
* @return
|
*/
|
@RequestMapping(value="spareCountChart.html",method=RequestMethod.GET)
|
public String ciTypetj(Model model,HttpServletRequest request,HttpServletResponse response) {
|
List lv1List = sparePartStatisfacade.getSpareCategoryList( null);
|
model.addAttribute("lv1List", lv1List);
|
return "/business/pages/tj/sparePartStatis/spareCountChart";
|
}
|
|
/**
|
* 获取设备分类下拉列表
|
* @param request
|
* @param response
|
*/
|
@RequestMapping("getCategotyList.html")
|
public void getCategotyList(HttpServletRequest request,HttpServletResponse response){
|
String lv1Id = request.getParameter("lv1Id");
|
List list = sparePartStatisfacade.getSpareCategoryList(lv1Id);
|
WebUtil.write(response, JsonUtil.list2Json(list));
|
}
|
/**
|
* 备品备件出入库统计
|
* @param request
|
* @param response
|
* @return
|
*/
|
@RequestMapping(value="deliveryTypetj.html",method=RequestMethod.GET)
|
public String deliveryTypetj(Model model,HttpServletRequest request,HttpServletResponse response) {
|
String endYear = DateUtil.getToday("yyyy");
|
model.addAttribute("lastYear", Integer.valueOf(endYear)-1);
|
model.addAttribute("year", Integer.valueOf(endYear));
|
model.addAttribute("flowYear", Integer.valueOf(endYear)-2);
|
return "/business/pages/tj/sparePartStatis/deliveryTypetj";
|
}
|
/**
|
*
|
* @param model
|
* @param request
|
* @param response
|
*/
|
@RequestMapping(value="deliveryDatatj.html",method=RequestMethod.POST)
|
public void deliveryDatatj(Model model,HttpServletRequest request,HttpServletResponse response){
|
|
String cate_id = request.getParameter("cate_id");
|
String year = request.getParameter("year");
|
String beginTime= "";
|
String endTime = "";
|
//List<List> series = new ArrayList<List>();
|
List<Map> series = new ArrayList<Map>();
|
List<Integer> rksls = new ArrayList<Integer>();
|
List<Integer> cksls = new ArrayList<Integer>();
|
List<Integer> slsls = new ArrayList<Integer>();
|
Map rk=new HashMap();
|
Map ck=new HashMap();
|
Map sl=new HashMap();
|
|
for(int i=1;i<12;i++){
|
String month="";
|
if(i<10){
|
month ="0"+i;
|
}else{
|
month=String.valueOf(i);
|
}
|
beginTime=year+month+"00";
|
endTime = year+month+"33";
|
List<Map> list = sparePartStatisfacade.getSpareTableTypeChart(cate_id,beginTime,endTime,"bjcrktj");
|
if(list!=null){
|
for(Map map:list){
|
Integer rksl=Integer.valueOf(ConvertUtil.obj2StrBlank(map.get("rksl")));
|
Integer cksl=Integer.valueOf(ConvertUtil.obj2StrBlank(map.get("cksl")));
|
Integer slsl=Integer.valueOf(ConvertUtil.obj2StrBlank(map.get("slsl")));
|
rksls.add(rksl);
|
cksls.add(cksl);
|
slsls.add(slsl);
|
}
|
}
|
}
|
rk.put("name", "入库数量");
|
rk.put("data", rksls);
|
|
ck.put("name", "出库数量");
|
ck.put("data", cksls);
|
|
sl.put("name", "申领数量");
|
sl.put("data", slsls);
|
series.add(rk);
|
series.add(ck);
|
series.add(sl);
|
System.out.print(JsonUtil.obj2Json(series));
|
|
WebUtil.write(response,JsonUtil.obj2Json(series));
|
}
|
/**
|
*
|
* @param model
|
* @param request
|
* @param response
|
*/
|
@RequestMapping(value="spareTypeChart.html",method=RequestMethod.POST)
|
public void ciTypeChart(Model model,HttpServletRequest request,HttpServletResponse response){
|
String lv1Id = request.getParameter("lv1Id");
|
String lv2Id = request.getParameter("lv2Id");
|
String queryType = request.getParameter("queryType");
|
List<Map> resMap = sparePartStatisfacade.getCiTypeChart(lv1Id,lv2Id,queryType);
|
System.out.print(JsonUtil.list2Json(resMap));
|
WebUtil.write(response, JsonUtil.list2Json(resMap));
|
}
|
/**
|
* 备品备件数量统计报表
|
* @param request
|
* @param response
|
* @return
|
*/
|
@RequestMapping("spareTypeTableIndex.html")
|
public String spareTypeTableIndex(Model model,HttpServletRequest request,HttpServletResponse response){
|
Long currentTime = DateUtil.getCurrentDate8();
|
String last1MonthTime = DateUtil.getMonthAdd("yyyyMMdd",-1);
|
model.addAttribute("beginTime", last1MonthTime);
|
model.addAttribute("endTime", currentTime);
|
return "/business/pages/tj/sparePartStatis/spareTypeTableIndex";
|
}
|
/**
|
* 备品备件数量统计数据
|
* @param model
|
* @param request
|
* @param response
|
* @return
|
*/
|
@RequestMapping("spareTypeTableData.html")
|
public String ciTypeTable(Model model,HttpServletRequest request,HttpServletResponse response){
|
String cate_id = request.getParameter("cate_id");
|
String beginTime = request.getParameter("beginTime");
|
String endTime = request.getParameter("endTime");
|
List list = sparePartStatisfacade.getSpareTableTypeChart(cate_id,beginTime,endTime,"bjsltj");
|
model.addAttribute("resMap", list);
|
return "/business/pages/tj/sparePartStatis/spareTypeTableData";
|
}
|
/**
|
* 备件申领统计
|
* @param request
|
* @param response
|
* @return
|
*/
|
@RequestMapping("stockTypetj.html")
|
public String stockTypetj(Model model,HttpServletRequest request,HttpServletResponse response){
|
Long currentTime = DateUtil.getCurrentDate8();
|
String last1MonthTime = DateUtil.getMonthAdd("yyyyMMdd",-1);
|
model.addAttribute("beginTime", last1MonthTime);
|
model.addAttribute("endTime", currentTime);
|
//项目列表
|
List<Map> cusList = sparePartsFacade.getCustomerList();
|
model.addAttribute("customers", cusList);
|
List lv1List = sparePartStatisfacade.getSpareCategoryList( null);
|
model.addAttribute("lv1List", lv1List);
|
return "/business/pages/tj/sparePartStatis/stockTypetj";
|
}
|
/**
|
* 备件申领统计数据
|
* @param model
|
* @param request
|
* @param response
|
*/
|
@RequestMapping(value="stockTypeDatetj.html",method=RequestMethod.POST)
|
public void stockTypeDatatj(Model model,HttpServletRequest request,HttpServletResponse response){
|
Map chartMap = sparePartStatisfacade.incidentInfluenceCol(request);
|
WebUtil.write(response, JsonUtil.map2Json(chartMap));
|
}
|
|
/**
|
* 项目备件申领统计
|
* @param request
|
* @param response
|
* @return
|
*/
|
@RequestMapping("projectSpareTableIndex.html")
|
public String projectSpareTableIndex(Model model,HttpServletRequest request,HttpServletResponse response){
|
Long currentTime = DateUtil.getCurrentDate8();
|
String last1MonthTime = DateUtil.getMonthAdd("yyyyMMdd",-1);
|
model.addAttribute("beginTime", last1MonthTime);
|
model.addAttribute("endTime", currentTime);
|
//项目列表
|
List<Map> cusList = sparePartsFacade.getCustomerList();
|
model.addAttribute("customers", cusList);
|
return "/business/pages/tj/sparePartStatis/projectSpareTableIndex";
|
}
|
/**
|
* 项目备件申领统计数据
|
* @param model
|
* @param request
|
* @param response
|
* @return
|
*/
|
@RequestMapping("projectSpareTableData.html")
|
public String projectSpareTableData(Model model,HttpServletRequest request,HttpServletResponse response){
|
String customer_id = request.getParameter("customer_id");
|
String beginTime = request.getParameter("beginTime");
|
String endTime = request.getParameter("endTime");
|
List list = sparePartStatisfacade.getProjectSpareTableTypeChart(customer_id,beginTime,endTime);
|
model.addAttribute("resMap", list);
|
return "/business/pages/tj/sparePartStatis/projectSpareTableData";
|
}
|
|
/**
|
* 供应商统计
|
* @param request
|
* @param response
|
* @return
|
*/
|
@RequestMapping("supplierSpareCountTableIndex.html")
|
public String SupplierSpareCountTableIndex(Model model,HttpServletRequest request,HttpServletResponse response){
|
Long currentTime = DateUtil.getCurrentDate8();
|
String last1MonthTime = DateUtil.getMonthAdd("yyyyMMdd",-1);
|
model.addAttribute("beginTime", last1MonthTime);
|
model.addAttribute("endTime", currentTime);
|
//项目列表
|
List<Map> cusList = sparePartsFacade.getCustomerList();
|
model.addAttribute("customers", cusList);
|
return "/business/pages/tj/sparePartStatis/supplierSpareCountTableIndex";
|
}
|
/**
|
* 供应商统计数据
|
* @param model
|
* @param request
|
* @param response
|
* @return
|
*/
|
@RequestMapping("supplierSpareCountTableData.html")
|
public String supplierSpareCountTableData(Model model,HttpServletRequest request,HttpServletResponse response){
|
String cate_id = request.getParameter("cate_id");
|
String beginTime = request.getParameter("beginTime");
|
String endTime = request.getParameter("endTime");
|
String pxtj = request.getParameter("pxtj");
|
String pxlx = request.getParameter("pxlx");
|
List list = sparePartStatisfacade.getSupplierSpareTableTypeChart(cate_id,beginTime,endTime,pxtj,pxlx);
|
model.addAttribute("resMap", list);
|
return "/business/pages/tj/sparePartStatis/supplierSpareCountTableData";
|
}
|
|
/**
|
* 备件明细报表
|
* @param request
|
* @param response
|
* @return
|
*/
|
@RequestMapping("spareSpartTableIndex.html")
|
public String spareSpartTableIndex(Model model,HttpServletRequest request,HttpServletResponse response){
|
Long currentTime = DateUtil.getCurrentDate8();
|
String last1MonthTime = DateUtil.getMonthAdd("yyyyMMdd",-1);
|
model.addAttribute("beginTime", last1MonthTime);
|
model.addAttribute("endTime", currentTime);
|
//项目列表
|
List<Map> cusList = sparePartsFacade.getCustomerList();
|
model.addAttribute("customers", cusList);
|
//供应商
|
List<Map> supplierList = sparePartsFacade.getSupplierList();
|
model.addAttribute("supplierList", supplierList);
|
return "/business/pages/tj/sparePartStatis/spareSpartTableIndex";
|
}
|
/**
|
* 备件明细报表
|
* @param model
|
* @param request
|
* @param response
|
* @return
|
*/
|
@RequestMapping("spareSpartTableData.html")
|
public String spareSpartTableData(Model model,HttpServletRequest request,HttpServletResponse response){
|
List<Map> ciList = sparePartStatisfacade.getSpareMainufacturerChart(request);
|
if(ciList!=null && ciList.size()>0){
|
for(Map map:ciList){
|
String ciId = ConvertUtil.obj2StrBlank(map.get("ID"));
|
Map baseMsg = new SPARE_PART(ciId).getBeanMapById();
|
//查询所有扩展数据的信息，以Map形式返回
|
Map resultMap = sparePartStatisfacade.queryStorageData(ciId);
|
Map data = (Map)resultMap.get("data");
|
Map label = (Map)resultMap.get("label");
|
map.put("baseMsg", baseMsg);
|
// map.put("groupProps", groupProps);
|
map.put("dataAll", data);
|
map.put("labelAll", label);
|
|
}
|
String cate_id=request.getParameter("cate_id");
|
if(StringUtil.isNotBlank(cate_id)){
|
List groupProps = sparePartStatisfacade.queryGroupPropsTwo(cate_id);
|
model.addAttribute("groupProps", groupProps);
|
}
|
Map props = sparePartStatisfacade.queryCommonProps(cate_id);
|
model.addAttribute("props", props);
|
model.addAttribute("ciList", ciList);
|
}
|
|
|
return "/business/pages/tj/sparePartStatis/spareSpartTableData";
|
}
|
|
|
/**
|
* 加盟商设备报表
|
* @param request
|
* @param response
|
* @return
|
*/
|
@RequestMapping("/ciMainufacturerTableIndex.html")
|
public String ciMainufacturerTableIndex(Model model,HttpServletRequest request,HttpServletResponse response){
|
List cusList = customerFacade.getCusList();
|
|
Map<String,String> MainufacturerfMap = Constants.CMDB_MAINUFACTURER_MAP;
|
List MainufacturerfList = new ArrayList<Map>();
|
for(String key : MainufacturerfMap.keySet()){
|
Map tempMap = new HashMap();
|
tempMap.put("id", key);
|
tempMap.put("value", MainufacturerfMap.get(key));
|
MainufacturerfList.add(tempMap);
|
}
|
model.addAttribute("cusList", cusList);
|
model.addAttribute("MainufacturerfList", MainufacturerfList);
|
return "/business/pages/tj/ciStatis/ciMainufacturerTableIndex";
|
}
|
|
}
|
