<%@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="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 sterilizationDate  = request.getParameter("sterilizationDate");
String sterilizationEndDate  = request.getParameter("sterilizationEndDate");
String sterilizerName  = request.getParameter("sterilizerName");
String frequency = request.getParameter("frequency");
String sql = " where 1=1 ";
boolean selectAll = true;
if (StringUtils.isNotBlank(sterilizationDate)
        || StringUtils.isNotBlank(sterilizerName)
        || StringUtils.isNotBlank(frequency)) {
	selectAll = false;
}

if (StringUtils.isNotBlank(sterilizationDate)) {
    sql += " and sr.startDate >= "
            + dateQueryAdapter.dateAdapter(sterilizationDate
                    + " 00:00:00");
}

if (StringUtils.isNotBlank(sterilizationEndDate)) {
    sql += " and sr.startDate <= "
            + dateQueryAdapter.dateAdapter(sterilizationEndDate
                    + " 23:59:59");
}
if (StringUtils.isNotBlank(sterilizerName)) {
    sql += " and sr.sterilizer.name = '" + sterilizerName + "'";
}
if (StringUtils.isNotBlank(frequency)) {
    sql += " and sr.frequency = " + frequency;
}
if (StringUtils.isNotBlank(barcode)) {
    sql = " where 1=1 and po.barcode = '" + barcode + "'";
}
String listSql = "select po from "
        + ReviewedBasket.class.getSimpleName()
        + " rb right join rb.tousseInstances po inner join po.sterilizationRecords sr "
        + sql + " order by po.operationTime desc ";
String basketTousseSql = "select po from "
        + ReviewedBasket.class.getSimpleName()
        + " rb right join rb.tousseInstances po inner join rb.sterilizationRecords sr "
        + sql + " order by po.operationTime desc";

tousseInstanceManager.exportQueryTousseInstance(listSql,basketTousseSql,selectAll,response.getOutputStream());
servletOutputStream.flush();
out.clear();
out = pageContext.pushBody();
%>