<%@page import="com.forgon.disinfectsystem.entity.packing.ReviewedBasket"%>
<%@page import="com.forgon.databaseadapter.service.DateQueryAdapter"%>
<%@page import="com.forgon.disinfectsystem.tousse.toussedefinition.service.TousseInstanceManager"%>
<%@page import="com.forgon.disinfectsystem.entity.basedatamanager.toussedefinition.TousseInstance"%>
<%@page import="java.util.Date"%>
<%@page import="java.text.SimpleDateFormat"%>
<%@page import="com.forgon.disinfectsystem.stocktakerecordmanager.service.StockTakeRecordManager"%>
<%@ page contentType="text/html; charset=UTF-8"%><%@ page
	import="com.forgon.tools.*,org.apache.commons.lang.*,com.forgon.directory.service.*"%><%
String fileName= "器械包查询.xls";
ServletOutputStream servletOutputStream = response.getOutputStream();
response.setContentType("application/octet-stream");
response.addHeader("Content-Disposition","attachment;filename=" + new String(fileName.getBytes("GBK"), "ISO8859_1"));
TousseInstanceManager tousseInstanceManager = (TousseInstanceManager)SpringBeanManger.getBean("tousseInstanceManager");
DateQueryAdapter dateQueryAdapter = (DateQueryAdapter)SpringBeanManger.getBean("dateQueryAdapter");

String barcode  = request.getParameter("barcode");
String tousseName  = request.getParameter("tousseName");
String sterilizationStartDate  = request.getParameter("sterilizationDate");
String sterilizationEndDate  = request.getParameter("sterilizationEndDate");
String sterilizerName  = request.getParameter("sterilizerName");
String frequency = request.getParameter("frequency");
String sql = "";
boolean selectAll = true;
if (StringUtils.isNotBlank(sterilizationStartDate)
		|| StringUtils.isNotBlank(sterilizationEndDate)
        || StringUtils.isNotBlank(sterilizerName)
        || StringUtils.isNotBlank(frequency)
        || StringUtils.isNotBlank(tousseName)
        || StringUtils.isNotBlank(barcode)) {
	selectAll = false;
}

if (StringUtils.isNotBlank(sterilizationStartDate)) {
    sql += " and " + dateQueryAdapter.stringFieldToDate("po.sterileEndTime")
            + " >= " + dateQueryAdapter.dateAdapter(sterilizationStartDate
                    + " 00:00:00");
}

if (StringUtils.isNotBlank(sterilizationEndDate)) {
    sql += " and " +  dateQueryAdapter.stringFieldToDate("po.sterileEndTime")
            + " <= " +dateQueryAdapter.dateAdapter(sterilizationEndDate
                    + " 23:59:59");
}
if (StringUtils.isNotBlank(sterilizerName)) {
    sql += " and po.sterilizerName = '" + sterilizerName + "'";
}
if (StringUtils.isNotBlank(frequency)) {
    sql += " and po.sterileFrequency = '" + frequency + "'";
}
if (StringUtils.isNotBlank(tousseName)) {
    sql += " and po.tousseName = '" + tousseName + "'";
}
if (StringUtils.isNotBlank(barcode)) {
    sql = " and po.barcode = '" + barcode + "'";
}

String listSql = "select po from "
		+ TousseInstance.class.getSimpleName()
        + " po where 1=1 "
        + sql + " order by po.operationTime desc ";

tousseInstanceManager.exportQueryTousseInstance(listSql,response.getOutputStream());
servletOutputStream.flush();
out.clear();
out = pageContext.pushBody();
%>