package com.northglass.service.reportform;
|
|
import java.math.BigDecimal;
|
import java.sql.CallableStatement;
|
import java.sql.Connection;
|
import java.sql.SQLException;
|
import java.text.DecimalFormat;
|
import java.text.ParseException;
|
import java.text.SimpleDateFormat;
|
import java.util.ArrayList;
|
import java.util.Calendar;
|
import java.util.Date;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
import javax.print.attribute.standard.DateTimeAtCompleted;
|
import javax.resource.cci.ResultSet;
|
import javax.servlet.http.HttpServletRequest;
|
|
import org.hibernate.transform.ResultTransformer;
|
import org.slf4j.Logger;
|
import org.slf4j.LoggerFactory;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Component;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import com.google.common.primitives.Ints;
|
import com.northglass.constants.StateConstants.CountMachineTaskState;
|
import com.northglass.constants.StateConstants.RackState;
|
import com.northglass.constants.StateConstants.ShelfRankState;
|
import com.northglass.entity.Cutmanagedetailis;
|
import com.northglass.entity.DropFrame;
|
import com.northglass.entity.DropFrame2;
|
import com.northglass.entity.GalssTask;
|
import com.northglass.entity.GalssTask2;
|
import com.northglass.entity.GalssTaskBuffer;
|
import com.northglass.entity.GalssTaskDetails;
|
import com.northglass.entity.GalssTaskStock;
|
import com.northglass.entity.LiuChengKaReport;
|
import com.northglass.entity.LoadRack;
|
import com.northglass.entity.Machines;
|
import com.northglass.entity.PatternTask;
|
import com.northglass.entity.PatternTaskBuffer;
|
import com.northglass.entity.Rank;
|
import com.northglass.entity.RawFile;
|
import com.northglass.entity.RawPackage;
|
import com.northglass.entity.ShelfRack;
|
import com.northglass.entity.ShelfTask;
|
import com.northglass.entity.Slicecage;
|
import com.northglass.entity.Yuanpianpandian;
|
import com.northglass.repository.CutmanagedetailisDao;
|
import com.northglass.repository.DropFrameDao;
|
import com.northglass.repository.DropFrameDao2;
|
import com.northglass.repository.GalssTaskBufferDao;
|
import com.northglass.repository.GalssTaskDao;
|
import com.northglass.repository.GalssTaskDao2;
|
import com.northglass.repository.GalssTaskDetailsDao;
|
import com.northglass.repository.GalssTaskStockDao;
|
import com.northglass.repository.LiuChengKaReportDao;
|
import com.northglass.repository.MachineDao;
|
import com.northglass.repository.MachinesTypeDao;
|
import com.northglass.repository.PatternTaskBufferDao;
|
import com.northglass.repository.RankDao;
|
import com.northglass.repository.RawFileDao;
|
import com.northglass.repository.ShelfRackDao;
|
import com.northglass.repository.YuanpianpandianDao;
|
import com.northglass.service.device.DeviceService;
|
|
import freemarker.core.ReturnInstruction.Return;
|
|
@Component
|
@Transactional
|
public class ReportformService {
|
|
private static final Logger LOGGER = LoggerFactory.getLogger(ReportformService.class);
|
|
@Autowired
|
private GalssTaskStockDao galssTaskStockDao;
|
|
@Autowired
|
private GalssTaskDetailsDao galssTaskDetailsDao;
|
|
@Autowired
|
private RawFileDao rawFileDao;
|
|
@Autowired
|
private GalssTaskBufferDao galssTaskBufferDao;
|
|
@Autowired
|
private PatternTaskBufferDao patternTaskBufferDao;
|
|
@Autowired
|
private YuanpianpandianDao yuanpianpandianDao;
|
|
@Autowired
|
private CutmanagedetailisDao cutmanagedetailisDao;
|
|
@Autowired
|
private ShelfRackDao shelfRackDao;
|
|
@Autowired
|
private RankDao rankDao;
|
|
@Autowired
|
private LiuChengKaReportDao liuchengkaDao;
|
|
public static String subZeroAndDot(double doublestr){
|
String doubleStr=doublestr+"";
|
if(null != doubleStr && doubleStr.indexOf(".") > 0){
|
doubleStr = doubleStr.replaceAll("0+?$", "");//去掉多余的0
|
doubleStr = doubleStr.replaceAll("[.]$", "");//如最后一位是.则去掉
|
}
|
return doubleStr;
|
}
|
public String shelfreportformhmtl() {
|
List<String> RawTypes=new ArrayList<>();
|
RawTypes.add("SL");
|
RawTypes.add("DL");
|
StringBuffer html = new StringBuffer();// 实例化缓存
|
|
List<ShelfRack> ranks = shelfRackDao.findBystate();
|
for (ShelfRack rank : ranks) {
|
if (rank.getRawPackage()!=null&&(rank.getState().equals(RackState.IN_WORK) || rank.getState().equals(RackState.ON_WAITING))) {
|
|
String unit="";
|
String size="";
|
String Color=rank.getRawPackage().getColor();
|
if(Color.length()>=2&&RawTypes.contains(Color.substring(0, 2))){
|
//膜玻 mm
|
unit="mm";
|
size=subZeroAndDot(rank.getRawPackage().getRawHeight())+"X"+subZeroAndDot(rank.getRawPackage().getRawWidth());
|
}else{
|
//白玻 单位 m
|
unit="m";
|
size=subZeroAndDot(rank.getRawPackage().getRawHeight()/1000)+"X"+subZeroAndDot(rank.getRawPackage().getRawWidth()/1000);
|
}
|
html.append("<tr>");
|
html.append("<td>" + rank.getNumber() + "</td>");
|
html.append("<td>" + (rank.getRawPackage().getBatchId()==null?"":rank.getRawPackage().getBatchId()) + "</td>");
|
html.append("<td>" + rank.getRawPackage().getRawType() + "</td>");
|
html.append("<td>" + rank.getRawPackage().getRawWidth() + "</td>");
|
html.append("<td>" + rank.getRawPackage().getRawHeight() + "</td>");
|
html.append("<td>" + rank.getRawPackage().getRawThickness() + "</td>");
|
html.append("<td>" + rank.getRawPackage().getLeftPieces() + "</td>");
|
html.append("<td>" + rank.getCreateTime() + "</td>");
|
html.append("<td>" + size + "</td>");
|
html.append("<td>" + unit + "</td>");
|
html.append("</tr>");
|
} else {
|
html.append("<tr>");
|
html.append("<td>" + rank.getNumber() + "</td>");
|
html.append("<td></td>");
|
html.append("<td></td>");
|
html.append("<td></td>");
|
html.append("<td></td>");
|
html.append("<td></td>");
|
html.append("<td></td>");
|
html.append("<td></td>");
|
html.append("<td></td>");
|
html.append("<td></td>");
|
html.append("</tr>");
|
}
|
}
|
return html.toString();// 返回料架信息
|
}
|
public String getData(int count){
|
SimpleDateFormat sdFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
Calendar c = Calendar.getInstance();
|
c.setTime(new Date());
|
c.add(Calendar.DATE, count); // number of days to add
|
return sdFormat.format(c.getTime());
|
}
|
public String shelfrankreportformhtml(HttpServletRequest request) {
|
SimpleDateFormat sdFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
// Long groups=Long.valueOf(request.getParameter("groups"));
|
List<Rank> ranks = rankDao.findAll();
|
String starttime;
|
String findtime;
|
String batchid;
|
try {
|
if ((request.getParameter("starttime") == "" || request.getParameter("findtime") == "")
|
&& request.getParameter("batchid") == "") {
|
|
starttime = getData(-30);//近30天的时间
|
//starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
|
} else if (request.getParameter("starttime") == null) {
|
starttime = getData(-30);//近30天的时间
|
//starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
ranks = rankDao.findalltime(aDate, aDate1);
|
|
} // 根据时间查询
|
else if (request.getParameter("starttime") != "" && request.getParameter("findtime") != ""
|
&& request.getParameter("batchid") == "") {
|
starttime = request.getParameter("starttime").replace("T", " ") + ":00";
|
findtime = request.getParameter("findtime").replace("T", " ") + ":00";
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
ranks = rankDao.findalltime(aDate, aDate1);
|
|
} else if (request.getParameter("starttime") != "" && request.getParameter("findtime") != ""
|
&& request.getParameter("batchid") != "") {
|
starttime = request.getParameter("starttime").replace("T", " ") + ":00";
|
findtime = request.getParameter("findtime").replace("T", " ") + ":00";
|
batchid = request.getParameter("batchid");
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
ranks = rankDao.findalltimebatchid(aDate, aDate1, batchid);
|
} else if (request.getParameter("starttime") == "" && request.getParameter("findtime") == ""
|
&& request.getParameter("engineeringid") != "") {
|
starttime = getData(-30);//近30天的时间
|
//starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
batchid = request.getParameter("batchid");
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
ranks = rankDao.findalltimebatchid(aDate, aDate1, batchid);
|
}
|
StringBuffer html = new StringBuffer();// 实例化缓存
|
|
for (Rank rank : ranks) {
|
|
html.append("<tr>");
|
if (rank.getBatchId() != null) {
|
|
html.append("<td>" + rank.getBatchId() + "</td>");
|
} else {
|
html.append("<td></td>");
|
}
|
html.append("<td>" + rank.getShelfRack().getNumber() + "</td>");
|
html.append("<td>" + rank.getGlassId() + "</td>");
|
html.append("<td>" + rank.getWidth() + "</td>");
|
html.append("<td>" + rank.getHeight() + "</td>");
|
html.append("<td>" + rank.getThickness() + "</td>");
|
html.append("<td>" + rank.getPieces() + "</td>");
|
html.append("<td>" + rank.getType() + "</td>");
|
html.append("<td>" + rank.getEndtime() + "</td>");
|
html.append("</tr>");
|
|
}
|
return html.toString();
|
} catch (Exception e) {
|
// TODO: handle exception
|
return "";
|
}
|
}
|
|
public String galssdetailsreportformhtml(HttpServletRequest request) {
|
SimpleDateFormat sdFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
// Long groups=Long.valueOf(request.getParameter("groups"));
|
List<GalssTaskDetails> galssTaskStocks = galssTaskDetailsDao.findallkucun4();
|
String starttime = "";
|
String findtime = "";
|
String processcardid;
|
String engineeringid;
|
|
try {
|
|
// 查询全部
|
if ((request.getParameter("starttime") == "" || request.getParameter("findtime") == "")
|
&& request.getParameter("engineeringid") == "" && request.getParameter("processcardid") == "") {
|
starttime = getData(-30);//近30天的时间
|
//starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
galssTaskStocks = galssTaskDetailsDao.findallkucun(aDate, aDate1);
|
}
|
// 查询全部
|
else if (request.getParameter("starttime") == null) {
|
starttime = getData(-30);//近30天的时间
|
//starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
galssTaskStocks = galssTaskDetailsDao.findallkucun(aDate, aDate1);
|
}
|
// 根据时间，流程卡，工程查询
|
else if (request.getParameter("engineeringid") != "" && request.getParameter("processcardid") != ""
|
&& request.getParameter("findtime") != "" && request.getParameter("starttime") != "") {
|
starttime = request.getParameter("starttime").replace("T", " ") + ":00";
|
findtime = request.getParameter("findtime").replace("T", " ") + ":00";
|
processcardid = request.getParameter("processcardid");
|
engineeringid = request.getParameter("engineeringid");
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
galssTaskStocks = galssTaskDetailsDao.findallkucun1(aDate, aDate1, processcardid, engineeringid);
|
}
|
// 根据时间查询
|
else if (request.getParameter("starttime") != "" && request.getParameter("findtime") != ""
|
&& request.getParameter("engineeringid") == "" && request.getParameter("processcardid") == "") {
|
starttime = request.getParameter("starttime").replace("T", " ") + ":00";
|
findtime = request.getParameter("findtime").replace("T", " ") + ":00";
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
galssTaskStocks = galssTaskDetailsDao.findallkucun(aDate, aDate1);
|
}
|
// 根据时间，流程卡查询
|
else if (request.getParameter("starttime") != "" && request.getParameter("findtime") != ""
|
&& request.getParameter("engineeringid") == "" && request.getParameter("processcardid") != "") {
|
starttime = request.getParameter("starttime").replace("T", " ") + ":00";
|
findtime = request.getParameter("findtime").replace("T", " ") + ":00";
|
processcardid = request.getParameter("processcardid");
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
galssTaskStocks = galssTaskDetailsDao.findallkucun2(aDate, aDate1, processcardid);
|
}
|
// 根据时间，工程查询
|
else if (request.getParameter("starttime") != "" && request.getParameter("findtime") != ""
|
&& request.getParameter("engineeringid") != "" && request.getParameter("processcardid") == "") {
|
starttime = request.getParameter("starttime").replace("T", " ") + ":00";
|
findtime = request.getParameter("findtime").replace("T", " ") + ":00";
|
engineeringid = request.getParameter("engineeringid");
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
galssTaskStocks = galssTaskDetailsDao.findallkucun3(aDate, aDate1, engineeringid);
|
}
|
// 工程查询
|
else if (request.getParameter("starttime") == "" && request.getParameter("findtime") == ""
|
&& request.getParameter("engineeringid") != "" && request.getParameter("processcardid") == "") {
|
starttime = getData(-30);//近30天的时间
|
//starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
engineeringid = request.getParameter("engineeringid");
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
galssTaskStocks = galssTaskDetailsDao.findallkucun3(aDate, aDate1, engineeringid);
|
}
|
// 流程卡查询
|
else if (request.getParameter("starttime") == "" && request.getParameter("findtime") == ""
|
&& request.getParameter("engineeringid") == "" && request.getParameter("processcardid") != "") {
|
starttime = getData(-30);//近30天的时间
|
//starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
processcardid = request.getParameter("processcardid");
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
galssTaskStocks = galssTaskDetailsDao.findallkucun2(aDate, aDate1, processcardid);
|
}
|
// 流程卡工程查询
|
else if (request.getParameter("starttime") == "" && request.getParameter("findtime") == ""
|
&& request.getParameter("engineeringid") != "" && request.getParameter("processcardid") != "") {
|
starttime = getData(-30);//近30天的时间
|
//starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
processcardid = request.getParameter("processcardid");
|
engineeringid = request.getParameter("engineeringid");
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
galssTaskStocks = galssTaskDetailsDao.findallkucun1(aDate, aDate1, processcardid, engineeringid);
|
}
|
|
StringBuffer html = new StringBuffer();// 实例化缓存
|
int index = 1;
|
// List<GalssTaskStock> galssTaskStocks =
|
// galssTaskStockDao.findallkucun(aDate,aDate1);
|
for (GalssTaskDetails galssTaskStock : galssTaskStocks) {
|
|
html.append("<tr>");
|
html.append("<td>" + index + "</td>");
|
html.append("<td>" + galssTaskStock.getGalssId() + "</td>");
|
html.append("<td>" + galssTaskStock.getEdgWidth() + "</td>");
|
html.append("<td>" + galssTaskStock.getEdgHeight() + "</td>");
|
html.append("<td>" + galssTaskStock.getThickness() + "</td>");
|
html.append("<td>" + galssTaskStock.getColor() + "</td>");
|
html.append("<td>" + galssTaskStock.getProcesscardId() + "</td>");
|
html.append("<td>" + galssTaskStock.getEngineeringId() + "</td>");
|
if (galssTaskStock.getChamferSize() != null) {
|
html.append("<td>" + galssTaskStock.getChamferSize() + "</td>");
|
} else {
|
html.append("<td></td>");
|
}
|
|
html.append("<td>" + galssTaskStock.getFinshTime() + "</td>");
|
html.append("</tr>");
|
index++;
|
}
|
return html.toString();
|
|
} catch (Exception e) {
|
// TODO: handle exception
|
return "";
|
}
|
|
}
|
|
public String galssdetailsreportformhtml1(HttpServletRequest request) {
|
SimpleDateFormat sdFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
// Long groups=Long.valueOf(request.getParameter("groups"));
|
List<GalssTaskDetails> galssTaskStocks = galssTaskDetailsDao.findallkucun4();
|
String starttime = "";
|
String findtime = "";
|
String processcardid;
|
String engineeringid;
|
|
try {
|
|
// 查询全部
|
if ((request.getParameter("starttime") == "" || request.getParameter("findtime") == "")
|
&& request.getParameter("engineeringid") == "" && request.getParameter("processcardid") == "") {
|
starttime = getData(-30);//近30天的时间
|
//starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
galssTaskStocks = galssTaskDetailsDao.findallkucun(aDate, aDate1);
|
}
|
// 查询全部
|
else if (request.getParameter("starttime") == null) {
|
starttime = getData(-30);//近30天的时间
|
//starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
galssTaskStocks = galssTaskDetailsDao.findallkucun(aDate, aDate1);
|
}
|
// 根据时间，流程卡，工程查询
|
else if (request.getParameter("engineeringid") != "" && request.getParameter("processcardid") != ""
|
&& request.getParameter("findtime") != "" && request.getParameter("starttime") != "") {
|
starttime = request.getParameter("starttime").replace("T", " ") + ":00";
|
findtime = request.getParameter("findtime").replace("T", " ") + ":00";
|
processcardid = request.getParameter("processcardid");
|
engineeringid = request.getParameter("engineeringid");
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
galssTaskStocks = galssTaskDetailsDao.findallkucun1(aDate, aDate1, processcardid, engineeringid);
|
}
|
// 根据时间查询
|
else if (request.getParameter("starttime") != "" && request.getParameter("findtime") != ""
|
&& request.getParameter("engineeringid") == "" && request.getParameter("processcardid") == "") {
|
starttime = request.getParameter("starttime").replace("T", " ") + ":00";
|
findtime = request.getParameter("findtime").replace("T", " ") + ":00";
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
galssTaskStocks = galssTaskDetailsDao.findallkucun(aDate, aDate1);
|
}
|
// 根据时间，流程卡查询
|
else if (request.getParameter("starttime") != "" && request.getParameter("findtime") != ""
|
&& request.getParameter("engineeringid") == "" && request.getParameter("processcardid") != "") {
|
starttime = request.getParameter("starttime").replace("T", " ") + ":00";
|
findtime = request.getParameter("findtime").replace("T", " ") + ":00";
|
processcardid = request.getParameter("processcardid");
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
galssTaskStocks = galssTaskDetailsDao.findallkucun2(aDate, aDate1, processcardid);
|
}
|
// 根据时间，工程查询
|
else if (request.getParameter("starttime") != "" && request.getParameter("findtime") != ""
|
&& request.getParameter("engineeringid") != "" && request.getParameter("processcardid") == "") {
|
starttime = request.getParameter("starttime").replace("T", " ") + ":00";
|
findtime = request.getParameter("findtime").replace("T", " ") + ":00";
|
engineeringid = request.getParameter("engineeringid");
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
galssTaskStocks = galssTaskDetailsDao.findallkucun3(aDate, aDate1, engineeringid);
|
}
|
// 工程查询
|
else if (request.getParameter("starttime") == "" && request.getParameter("findtime") == ""
|
&& request.getParameter("engineeringid") != "" && request.getParameter("processcardid") == "") {
|
starttime = getData(-30);//近30天的时间
|
//starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
engineeringid = request.getParameter("engineeringid");
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
galssTaskStocks = galssTaskDetailsDao.findallkucun3(aDate, aDate1, engineeringid);
|
}
|
// 流程卡查询
|
else if (request.getParameter("starttime") == "" && request.getParameter("findtime") == ""
|
&& request.getParameter("engineeringid") == "" && request.getParameter("processcardid") != "") {
|
starttime = getData(-30);//近30天的时间
|
//starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
processcardid = request.getParameter("processcardid");
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
galssTaskStocks = galssTaskDetailsDao.findallkucun2(aDate, aDate1, processcardid);
|
}
|
// 流程卡工程查询
|
else if (request.getParameter("starttime") == "" && request.getParameter("findtime") == ""
|
&& request.getParameter("engineeringid") != "" && request.getParameter("processcardid") != "") {
|
starttime = getData(-30);//近30天的时间
|
//starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
processcardid = request.getParameter("processcardid");
|
engineeringid = request.getParameter("engineeringid");
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
galssTaskStocks = galssTaskDetailsDao.findallkucun1(aDate, aDate1, processcardid, engineeringid);
|
}
|
|
StringBuffer html = new StringBuffer();// 实例化缓存
|
|
// List<GalssTaskStock> galssTaskStocks =
|
// galssTaskStockDao.findallkucun(aDate,aDate1);
|
double sum = 0;
|
double sum1 = 0;
|
|
int count = galssTaskStocks.size();
|
for (GalssTaskDetails galssTaskStock : galssTaskStocks) {
|
sum = sum + (Double.parseDouble(galssTaskStock.getEdgWidth())
|
* Double.parseDouble(galssTaskStock.getEdgHeight()));
|
sum1 = sum1 + (Double.parseDouble(galssTaskStock.getEdgWidth())
|
+ Double.parseDouble(galssTaskStock.getEdgHeight())) * 2;
|
|
}
|
BigDecimal sums = new BigDecimal(sum);
|
BigDecimal sums1 = new BigDecimal(sum1);
|
html.append("总面积：" + sums + " 总周长：" + sums1 + " 总片数：" + count + "");
|
return html.toString();
|
|
} catch (Exception e) {
|
// TODO: handle exception
|
return "";
|
}
|
|
}
|
|
public String cutmanagerepoortformhtml(HttpServletRequest request) {
|
try {
|
SimpleDateFormat sdFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
// Long groups=Long.valueOf(request.getParameter("groups"));
|
List<Cutmanagedetailis> cutmanagedetailis = cutmanagedetailisDao.findall2();
|
String starttime;
|
String findtime;
|
String dengluname="";
|
Date aDate;
|
Date aDate1;
|
starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
aDate = sdFormat.parse(starttime);
|
aDate1 = sdFormat.parse(findtime);
|
|
if ((request.getParameter("starttime") == null || request.getParameter("findtime") == null
|
|| request.getParameter("starttime") == "" || request.getParameter("findtime") == "")
|
&&(request.getParameter("dengluname") == ""||request.getParameter("dengluname") == null)) {
|
starttime = getData(-30);//近30天的时间
|
//starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
aDate = sdFormat.parse(starttime);
|
aDate1 = sdFormat.parse(findtime);
|
cutmanagedetailis = cutmanagedetailisDao.findall2();
|
|
} else if (request.getParameter("starttime") != null && request.getParameter("findtime") != null
|
&& request.getParameter("starttime") != "" && request.getParameter("findtime") != ""
|
&&request.getParameter("dengluname") != ""&&request.getParameter("dengluname") != null) {
|
starttime = request.getParameter("starttime").replace("T", " ") + ":00";
|
findtime = request.getParameter("findtime").replace("T", " ") + ":00";
|
dengluname=request.getParameter("dengluname");
|
aDate = sdFormat.parse(starttime);
|
aDate1 = sdFormat.parse(findtime);
|
cutmanagedetailis = cutmanagedetailisDao.findallgroups4(aDate, aDate1,dengluname);
|
|
}else if ((request.getParameter("starttime") == null || request.getParameter("findtime") == null
|
|| request.getParameter("starttime") == "" || request.getParameter("findtime") == "")
|
&&request.getParameter("dengluname") != ""&&request.getParameter("dengluname") != null) {
|
starttime = getData(-30);//近30天的时间
|
//starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
dengluname=request.getParameter("dengluname");
|
aDate = sdFormat.parse(starttime);
|
aDate1 = sdFormat.parse(findtime);
|
cutmanagedetailis = cutmanagedetailisDao.findallgroups4(aDate, aDate1,dengluname);
|
|
} else if (request.getParameter("starttime") != null && request.getParameter("findtime") != null
|
&& request.getParameter("starttime") != "" && request.getParameter("findtime") != ""
|
&&(request.getParameter("dengluname") == ""||request.getParameter("dengluname") == null)) {
|
starttime = request.getParameter("starttime").replace("T", " ") + ":00";
|
findtime = request.getParameter("findtime").replace("T", " ") + ":00";
|
aDate = sdFormat.parse(starttime);
|
aDate1 = sdFormat.parse(findtime);
|
cutmanagedetailis = cutmanagedetailisDao.findallgroups(aDate, aDate1);
|
|
}
|
StringBuffer html = new StringBuffer();// 实例化缓存
|
double mianji = 0;
|
for (Cutmanagedetailis cutmanagedetaili : cutmanagedetailis) {
|
int pieces = cutmanagedetailisDao.findallpieces(cutmanagedetaili.getWidth(),
|
cutmanagedetaili.getHeight(), cutmanagedetaili.getThickness(), cutmanagedetaili.getColor(),
|
cutmanagedetaili.getGroups(), aDate, aDate1,cutmanagedetaili.getDengluname());
|
mianji = cutmanagedetaili.getWidth() * cutmanagedetaili.getHeight() * pieces/1000000;
|
BigDecimal bg = new BigDecimal(mianji);
|
html.append("<tr>");
|
html.append("<td>" + cutmanagedetaili.getWidth() + "</td>");
|
html.append("<td>" + cutmanagedetaili.getHeight() + "</td>");
|
html.append("<td>" + cutmanagedetaili.getThickness() + "</td>");
|
html.append("<td>" + cutmanagedetaili.getColor() + "</td>");
|
html.append("<td>" + pieces + "</td>");
|
html.append("<td>" + cutmanagedetaili.getGroups() + "</td>");
|
if (cutmanagedetaili.getDengluname()!=null) {
|
html.append("<td>" + cutmanagedetaili.getDengluname() + "</td>");
|
|
}else {
|
html.append("<td></td>");
|
}
|
html.append("<td>" + mianji + "</td>");
|
html.append("</tr>");
|
|
}
|
return html.toString();
|
} catch (Exception e) {
|
// TODO: handle exception
|
return "";
|
}
|
|
}
|
|
public String cutmanagerepoortformhtml1(HttpServletRequest request) {
|
SimpleDateFormat sdFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
// Long groups=Long.valueOf(request.getParameter("groups"));
|
String starttime;
|
String findtime;
|
if (request.getParameter("starttime") == null || request.getParameter("findtime") == null
|
|| request.getParameter("starttime") == "" || request.getParameter("findtime") == "") {
|
/*starttime=(request.getParameter("starttime") == null||request.getParameter("starttime") =="")==true?"":"";*/
|
starttime = getData(-10);//近30天的时间
|
//starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
System.out.println(starttime);
|
} else {
|
starttime = request.getParameter("starttime").replace("T", " ") + ":00";
|
findtime = request.getParameter("findtime").replace("T", " ") + ":00";
|
}
|
|
try {
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
StringBuffer html = new StringBuffer();// 实例化缓存
|
|
List<Cutmanagedetailis> cutmanagedetailis = cutmanagedetailisDao.findallgroups1(aDate, aDate1);
|
|
double mianji;
|
List<String> RawTypes=new ArrayList<>();
|
RawTypes.add("SL");
|
RawTypes.add("DL");
|
|
for (Cutmanagedetailis cutmanagedetaili : cutmanagedetailis) {
|
int pieces = cutmanagedetailisDao.findallpieces1(cutmanagedetaili.getWidth(),
|
cutmanagedetaili.getHeight(), cutmanagedetaili.getThickness(), cutmanagedetaili.getColor(),
|
aDate, aDate1);
|
mianji = (int) cutmanagedetaili.getWidth() * cutmanagedetaili.getHeight() * pieces/1000000;
|
BigDecimal bg = new BigDecimal(mianji);
|
String unit="";
|
String size="";
|
String Color=cutmanagedetaili.getColor();
|
if(Color.length()>=2&&RawTypes.contains(Color.substring(0, 2))){
|
//膜玻 mm
|
unit="mm";
|
size=subZeroAndDot(cutmanagedetaili.getHeight())+"X"+subZeroAndDot(cutmanagedetaili.getWidth());
|
}else{
|
//白玻 单位 m
|
unit="m";
|
size=subZeroAndDot(cutmanagedetaili.getHeight()/1000)+"X"+subZeroAndDot(cutmanagedetaili.getWidth()/1000);
|
}
|
|
html.append("<tr>");
|
html.append("<td>" + cutmanagedetaili.getWidth() + "</td>");
|
html.append("<td>" + cutmanagedetaili.getHeight() + "</td>");
|
html.append("<td>" + cutmanagedetaili.getThickness() + "</td>");
|
html.append("<td>" + cutmanagedetaili.getColor() + "</td>");
|
html.append("<td>" + pieces + "</td>");
|
html.append("<td>" + mianji + "</td>");
|
html.append("<td>" + size + "</td>");
|
html.append("<td>" + unit + "</td>");
|
html.append("</tr>");
|
|
}
|
return html.toString();
|
} catch (Exception e) {
|
// TODO: handle exception
|
return "";
|
}
|
|
}
|
|
public String cutmanagerepoortformhtml2(HttpServletRequest request) {
|
SimpleDateFormat sdFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
// Long groups=Long.valueOf(request.getParameter("groups"));
|
List<Cutmanagedetailis> cutmanagedetailis = cutmanagedetailisDao.findall();
|
String starttime;
|
String findtime;
|
String dengluname;
|
try {
|
if ((request.getParameter("starttime") == null || request.getParameter("findtime") == null
|
|| request.getParameter("starttime") == "" || request.getParameter("findtime") == "")
|
&&(request.getParameter("dengluname") == ""||request.getParameter("dengluname") == null)) {
|
starttime = getData(-30);//近30天的时间
|
//starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
cutmanagedetailis = cutmanagedetailisDao.findall();
|
|
} else if (request.getParameter("starttime") != null && request.getParameter("findtime") != null
|
&& request.getParameter("starttime") != "" && request.getParameter("findtime") != ""
|
&&request.getParameter("dengluname") != ""&&request.getParameter("dengluname") != null) {
|
starttime = request.getParameter("starttime").replace("T", " ") + ":00";
|
findtime = request.getParameter("findtime").replace("T", " ") + ":00";
|
dengluname=request.getParameter("dengluname");
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
cutmanagedetailis = cutmanagedetailisDao.findallgroups3(aDate, aDate1,dengluname);
|
|
}else if ((request.getParameter("starttime") == null || request.getParameter("findtime") == null
|
|| request.getParameter("starttime") == "" || request.getParameter("findtime") == "")
|
&&request.getParameter("dengluname") != ""&&request.getParameter("dengluname") != null) {
|
starttime = getData(-30);//近30天的时间
|
//starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
dengluname=request.getParameter("dengluname");
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
cutmanagedetailis = cutmanagedetailisDao.findallgroups3(aDate, aDate1,dengluname);
|
|
} else if (request.getParameter("starttime") != null && request.getParameter("findtime") != null
|
&& request.getParameter("starttime") != "" && request.getParameter("findtime") != ""
|
&&(request.getParameter("dengluname") == ""||request.getParameter("dengluname") == null)) {
|
starttime = request.getParameter("starttime").replace("T", " ") + ":00";
|
findtime = request.getParameter("findtime").replace("T", " ") + ":00";
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
cutmanagedetailis = cutmanagedetailisDao.findallgroups2(aDate, aDate1);
|
|
}
|
|
StringBuffer html = new StringBuffer();// 实例化缓存
|
|
for (Cutmanagedetailis cutmanagedetaili : cutmanagedetailis) {
|
|
html.append("<tr>");
|
html.append("<td>" + cutmanagedetaili.getEngineeringId() + "</td>");
|
html.append("<td>" + cutmanagedetaili.getWidth() + "</td>");
|
html.append("<td>" + cutmanagedetaili.getHeight() + "</td>");
|
html.append("<td>" + cutmanagedetaili.getThickness() + "</td>");
|
html.append("<td>" + cutmanagedetaili.getColor() + "</td>");
|
html.append("<td>" + cutmanagedetaili.getBatchId() + "</td>");
|
html.append("<td>" + cutmanagedetaili.getProductionTime() + "</td>");
|
html.append("<td>" + cutmanagedetaili.getWarehousingTime() + "</td>");
|
html.append("<td>" + cutmanagedetaili.getStatrtime() + "</td>");
|
if (cutmanagedetaili.getDengluname()!=null) {
|
html.append("<td>" + cutmanagedetaili.getDengluname() + "</td>");
|
|
}else {
|
html.append("<td></td>");
|
}
|
html.append("</tr>");
|
|
}
|
return html.toString();
|
} catch (Exception e) {
|
// TODO: handle exception
|
return "";
|
}
|
|
}
|
|
public String yuanpianpandianhtml(HttpServletRequest request) {
|
SimpleDateFormat sdFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
// Long groups=Long.valueOf(request.getParameter("groups"));
|
String starttime;
|
String findtime;
|
if (request.getParameter("starttime") == null || request.getParameter("findtime") == null
|
|| request.getParameter("starttime") == "" || request.getParameter("findtime") == "") {
|
starttime = getData(-30);//近30天的时间
|
//starttime = "1900-01-01 00:00:00";
|
findtime = sdFormat.format(new Date());
|
} else {
|
starttime = request.getParameter("starttime").replace("T", " ") + ":00";
|
findtime = request.getParameter("findtime").replace("T", " ") + ":00";
|
}
|
try {
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
StringBuffer html = new StringBuffer();// 实例化缓存
|
|
List<Yuanpianpandian> yuanpianpandianlist = yuanpianpandianDao.findallgroups(aDate, aDate1);
|
|
for (Yuanpianpandian yuanpianpandian : yuanpianpandianlist) {
|
|
html.append("<tr>");
|
html.append("<td>" + yuanpianpandian.getShelfId() + "</td>");
|
html.append("<td>" + yuanpianpandian.getGlass() + "</td>");
|
html.append("<td>" + yuanpianpandian.getWidthHeight() + "</td>");
|
html.append("<td>" + yuanpianpandian.getKucunshuliang() + "</td>");
|
html.append("<td>" + yuanpianpandian.getPandianshuliang() + "</td>");
|
html.append("<td>" + yuanpianpandian.getShenheshuliang() + "</td>");
|
html.append("<td>" + yuanpianpandian.getDateshijian() + "</td>");
|
html.append("<td>" + yuanpianpandian.getJianlitime() + "</td>");
|
html.append("</tr>");
|
|
}
|
return html.toString();
|
} catch (Exception e) {
|
// TODO: handle exception
|
return "";
|
}
|
|
}
|
|
public String galssmeasurereportformhtml(HttpServletRequest request) {
|
SimpleDateFormat sdFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
String starttime;
|
String findtime;
|
String engineeringid;
|
List<RawFile> rawFilelist;
|
try {
|
|
if ((request.getParameter("starttime") == "" || request.getParameter("findtime") == "")
|
&& request.getParameter("engineeringid") == "") {
|
rawFilelist = rawFileDao.findfileNameall();
|
|
} else if (request.getParameter("starttime") == null) {
|
rawFilelist = rawFileDao.findfileNameall();
|
|
} // 根据时间查询
|
else if (request.getParameter("starttime") != "" && request.getParameter("findtime") != ""
|
&& request.getParameter("engineeringid") == "") {
|
starttime = request.getParameter("starttime").replace("T", " ") + ":00";
|
findtime = request.getParameter("findtime").replace("T", " ") + ":00";
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
rawFilelist = rawFileDao.findalltime(aDate, aDate1);
|
|
} else if (request.getParameter("starttime") != "" && request.getParameter("findtime") != ""
|
&& request.getParameter("engineeringid") != "") {
|
rawFilelist = rawFileDao.findfileNameall();
|
} else if (request.getParameter("starttime") == "" && request.getParameter("findtime") == ""
|
&& request.getParameter("engineeringid") != "") {
|
engineeringid = request.getParameter("engineeringid");
|
rawFilelist = rawFileDao.findfileNamelist(engineeringid);
|
} else {
|
rawFilelist = rawFileDao.findfileNameall();
|
}
|
|
StringBuffer html = new StringBuffer();// 实例化缓存
|
|
for (RawFile rawFile : rawFilelist) {
|
|
html.append("<tr>");
|
html.append("<td>" + rawFile.getFileName() + "</td>");
|
html.append("<td>" + rawFile.getGalssmeasure() + "</td>");
|
html.append("<td>" + rawFile.getPatternmeasure() + "</td>");
|
html.append("<td>" + rawFile.getCuttingRate() + "%</td>");
|
html.append("<td>" + rawFile.getOperator() + "</td>");
|
html.append("<td>" + rawFile.getCreateTime() + "</td>");
|
html.append("<td>" + rawFile.getReceiveTime() + "</td>");
|
html.append("</tr>");
|
|
}
|
return html.toString();
|
} catch (Exception e) {
|
// TODO: handle exception
|
return "";
|
}
|
|
}
|
|
public String galssmeasurereportformhtml1(HttpServletRequest request) {
|
SimpleDateFormat sdFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
DecimalFormat df = new DecimalFormat("#.00");
|
String starttime;
|
String findtime;
|
String galssmeasure;
|
String patternmeasure;
|
double cuttingRate;
|
List<RawFile> rawFilelist = rawFileDao.findfileNamealls();
|
try {
|
|
StringBuffer html = new StringBuffer();// 实例化缓存
|
|
for (RawFile rawFile : rawFilelist) {
|
if ((request.getParameter("starttime") == "" || request.getParameter("findtime") == "")
|
&& request.getParameter("engineeringid") == "") {
|
galssmeasure = rawFileDao.findfileNameall1(rawFile.getOperator());
|
patternmeasure = rawFileDao.findfileNameall2(rawFile.getOperator());
|
if (galssmeasure.equals("0.0")) {
|
cuttingRate = 0;
|
} else {
|
cuttingRate = Double.parseDouble(galssmeasure) / Double.parseDouble(patternmeasure) * 100;
|
}
|
|
} else if (request.getParameter("starttime") == null) {
|
galssmeasure = rawFileDao.findfileNameall1(rawFile.getOperator());
|
patternmeasure = rawFileDao.findfileNameall2(rawFile.getOperator());
|
if (galssmeasure.equals("0.0")) {
|
cuttingRate = 0;
|
} else {
|
cuttingRate = Double.parseDouble(galssmeasure) / Double.parseDouble(patternmeasure) * 100;
|
}
|
|
} // 根据时间查询
|
else if (request.getParameter("starttime") != "" && request.getParameter("findtime") != "") {
|
starttime = request.getParameter("starttime").replace("T", " ") + ":00";
|
findtime = request.getParameter("findtime").replace("T", " ") + ":00";
|
Date aDate = sdFormat.parse(starttime);
|
Date aDate1 = sdFormat.parse(findtime);
|
galssmeasure = rawFileDao.findfileNameall3(aDate, aDate1, rawFile.getOperator());
|
patternmeasure = rawFileDao.findfileNameall4(aDate, aDate1, rawFile.getOperator());
|
if (galssmeasure.equals("0.0")) {
|
cuttingRate = 0;
|
} else {
|
cuttingRate = Double.parseDouble(galssmeasure) / Double.parseDouble(patternmeasure) * 100;
|
}
|
|
} else {
|
galssmeasure = rawFileDao.findfileNameall1(rawFile.getOperator());
|
patternmeasure = rawFileDao.findfileNameall2(rawFile.getOperator());
|
if (galssmeasure.equals("0.0")) {
|
cuttingRate = 0;
|
} else {
|
cuttingRate = Double.parseDouble(galssmeasure) / Double.parseDouble(patternmeasure) * 100;
|
}
|
}
|
|
html.append("<tr>");
|
html.append("<td>" + rawFile.getOperator() + "</td>");
|
html.append("<td>" + galssmeasure + "</td>");
|
html.append("<td>" + patternmeasure + "</td>");
|
if (cuttingRate == 0) {
|
html.append("<td>" + cuttingRate + "%</td>");
|
} else {
|
html.append("<td>" + df.format(cuttingRate) + "%</td>");
|
}
|
|
html.append("</tr>");
|
|
}
|
return html.toString();
|
} catch (Exception e) {
|
// TODO: handle exception
|
return "";
|
}
|
|
}
|
|
// 流程卡切裁率报表
|
public String LiuChengKaReportFormHtml(HttpServletRequest request) {
|
SimpleDateFormat sdFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
|
String starttime;
|
String findtime;
|
String gckh_;
|
String lckh_;
|
//List<LiuChengKaReport> lckRows = liuchengkaDao.GetLiuChengKaReportAll();
|
List<LiuChengKaReport> lckRows = null;
|
|
try {
|
starttime = request.getParameter("starttime");
|
findtime = request.getParameter("findtime");
|
gckh_ = request.getParameter("gckh");
|
lckh_ = request.getParameter("lckh");
|
|
lckRows=GetShowLiuChengKaData(gckh_,lckh_,starttime,findtime);
|
|
|
StringBuffer html = new StringBuffer();// 实例化缓存
|
java.text.DecimalFormat df = new java.text.DecimalFormat("#.00");
|
int i = 1;
|
for (LiuChengKaReport rawFile : lckRows) {
|
|
RawFile rf = rawFileDao.GetGongChengByGCH(rawFile.getgongchenghao());
|
|
html.append("<tr>");
|
html.append("<td style=\"width:50px\">" + i++ + "</td>");
|
html.append("<td>" + rawFile.getgongchenghao() + "</td>");
|
html.append("<td>" + rawFile.getliuchengkahao() + "</td>");
|
html.append("<td>" + rawFile.getthinckness() + "</td>");
|
html.append("<td>" + rawFile.getcolor() + "</td>");
|
html.append("<td>" + rawFile.getshuliang() + "</td>");
|
|
html.append("<td>" + Double.parseDouble(df.format(rawFile.getmianji() / 1000000)) + "</td>");
|
html.append("<td>" + rf.getCuttingRate() + "%</td>");
|
html.append("<td>" + rawFile.getstartTime() + "</td>");
|
html.append("</tr>");
|
}
|
return html.toString();
|
} catch (Exception e) {
|
// TODO: handle exception
|
return "";
|
}
|
}
|
|
public List<LiuChengKaReport> GetShowLiuChengKaData(String gc, String lck, String sTime, String eTime)
|
throws ParseException {
|
List<LiuChengKaReport> lckRows = null;
|
|
boolean gcIsNull = (gc == null || gc == "") ? true : false;
|
boolean lckIsNull = (lck == null || lck == "") ? true : false;
|
boolean sTimeIsNull = (sTime == null || sTime == "") ? true : false;
|
boolean eTimeIsNull = (eTime == null || eTime == "") ? true : false;
|
|
SimpleDateFormat sdFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
// 当时间为空时
|
if (sTimeIsNull && eTimeIsNull) {
|
if (gcIsNull && lckIsNull) {
|
lckRows = liuchengkaDao.GetLiuChengKaReportAll();
|
lckRows = lckRows.subList(0, 300);
|
} else if (!gcIsNull && lckIsNull) {
|
lckRows = liuchengkaDao.GetLiuChengKaReportByGCNO("%" + gc + "%");
|
} else if (gcIsNull && !lckIsNull) {
|
lckRows = liuchengkaDao.GetLiuChengKaReportByLCKNO("%" + lck + "%");
|
} else {
|
lckRows = liuchengkaDao.GetLiuChengKaReportByNO("%" + gc + "%", "%" + lck + "%");
|
}
|
}
|
// 当开始时间不为空时
|
else if (!sTimeIsNull && eTimeIsNull) {
|
|
sTime = sTime.replace("T", " ") + ":00";
|
Date sDate = sdFormat.parse(sTime);
|
|
if (gcIsNull && lckIsNull) {
|
lckRows = liuchengkaDao.GetLiuChengKaReportByTime2(sDate);
|
} else if (!gcIsNull && !lckIsNull) {
|
lckRows = liuchengkaDao.GetLiuChengKaReport2(sDate, "%" + gc + "%", "%" + lck + "%");
|
} else {
|
lckRows = liuchengkaDao.GetLiuChengKaReport3(sDate, "%" + gc + "%", "%" + lck + "%");
|
}
|
|
}
|
// 当结束时间不为空时
|
else if (sTimeIsNull && !eTimeIsNull) {
|
|
eTime = eTime.replace("T", " ") + ":00";
|
Date eDate = sdFormat.parse(eTime);
|
if (gcIsNull && lckIsNull) {
|
lckRows = liuchengkaDao.GetLiuChengKaReportByTime3(eDate);
|
} else if (!gcIsNull && !lckIsNull) {
|
lckRows = liuchengkaDao.GetLiuChengKaReport4(eDate, "%" + gc + "%", "%" + lck + "%");
|
} else {
|
lckRows = liuchengkaDao.GetLiuChengKaReport5(eDate, "%" + gc + "%", "%" + lck + "%");
|
}
|
}
|
// 当时间都不为空时
|
else {
|
sTime = sTime.replace("T", " ") + ":00";
|
eTime = eTime.replace("T", " ") + ":00";
|
|
Date sDate2 = sdFormat.parse(sTime);
|
|
Date eDate2 = sdFormat.parse(eTime);
|
|
if (gcIsNull && lckIsNull) {
|
|
lckRows = liuchengkaDao.GetLiuChengKaReportByTime(sDate2, eDate2);
|
// lckRows =
|
// liuchengkaDao.GetLiuChengKaReportByStrTime(sTime,eTime);
|
} else if (!gcIsNull && !lckIsNull) {
|
|
lckRows = liuchengkaDao.GetLiuChengKaReport(sDate2, eDate2, "%" + gc + "%", "%" + lck + "%");
|
} else {
|
lckRows = liuchengkaDao.GetLiuChengKaReport1(sDate2, eDate2, "%" + gc + "%", "%" + lck + "%");
|
|
}
|
}
|
|
return lckRows;
|
}
|
}
|
