jxc_by_brand.jsp

我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统

<%@ page contentType="text/html; charset=gb2312"%>
<%@include file="/common/ValidateJavaScript.jsp"%>
<%@include file="/common/system_perms.jsp"%>
<%@page  import="net.intuitsoft.xeon.table.sale.*"%>
<%@page  import="net.intuitsoft.xeon.table.report.define.*"%>
<%@page  import="net.intuitsoft.xeon.table.sale.compare.*"%>
<%@page  import="intuitsoft.eclipse.table.common.*"%>
<%@page  import="net.intuitsoft.xeon.table.common.ItemActionBean"%>
<%@page  import="net.intuitsoft.xeon.table.common.ListBean"%>
<%@page  import="net.intuitsoft.xeon.table.warehouse.month.*"%>
<%@page  import="intuitsoft.eclipse.table.system.user.*"%>
<%@include file="/common/sales_perms.jsp"%>
<%




ListAdapter listAdapter = (ListAdapter)request.getAttribute("ListAdapter");
if(listAdapter == null) {
    listAdapter = new ConcreteListAdapter(loginInfo.getJndiName());
}

SaleCompareAdapter orderSheet = (SaleCompareAdapter)request.getAttribute("SaleCompareAdapter2");
if(orderSheet == null) {
    orderSheet = new SaleCompareAdapter(loginInfo.getJndiName());
}


StringBuffer goodsSql = new StringBuffer(50);
StringBuffer balSql = new StringBuffer(100);





if(orderSheet.getBrandID() != 0) {
	goodsSql.append(" and c.brandID=");
	goodsSql.append(orderSheet.getBrandID());


}else{
    goodsSql.append(intuitsoft.eclipse.table.system.perm.Perm.sqlCondSQL("c", "brandID", loginInfo.params.getBrandPerm(), orderSheet.getBrandID()));
}

if(!"".equals(orderSheet.getClassID())) {
	goodsSql.append(" and c.classID like '");
	goodsSql.append(orderSheet.getClassID());
	goodsSql.append("%'");
}



                if (orderSheet.getCode() != null &&
                    !"".equals(orderSheet.getCode())) {
                    int pos = orderSheet.getCode().indexOf(",");
                    if(pos == -1) {
                        goodsSql.append(" and isnull(c.gdsNo,'') +isnull(c.gdsName,'')+ isnull(c.code,'') like '%");
                        goodsSql.append(orderSheet.getCode());
                        goodsSql.append("%'");
                    }
                    else {
                        StringBuffer sb = new StringBuffer(100);
                        sb.append(" and (");
                        StringTokenizer  token = new StringTokenizer(orderSheet.getCode(),",");
                        int cc = 0;
                        int size = token.countTokens();
                        while(token.hasMoreElements()) {
                            cc++;
                            String label = token.nextElement().toString();
                            sb.append(" c.gdsNo='");
                            sb.append(label);
                            sb.append("'");
                            if(cc < size) {
                                sb.append(" or ");
                            }
                        }
                        sb.append(") ");
                        goodsSql.append(sb.toString());
                    }

                }







 



                StringBuffer tmp = new StringBuffer();


                if (!"".equals(orderSheet.getCreateDate1()) &&
                    !"".equals(orderSheet.getCreateDate3())) {
                    tmp.append(" and a.createDate  between '");
                    tmp.append(orderSheet.getCreateDate1());
                    tmp.append("' and '");
                    tmp.append(orderSheet.getCreateDate3());
                    tmp.append("'");
                }

                if (!"".equals(orderSheet.getCreateDate1()) &&
                    "".equals(orderSheet.getCreateDate3())) {
                    tmp.append(" and a.createDate  >= '");
                    tmp.append(orderSheet.getCreateDate1());
                    tmp.append("'");
                }
                if ("".equals(orderSheet.getCreateDate1()) &&
                    !"".equals(orderSheet.getCreateDate3())) {
                    tmp.append(" and a.createDate  <= '");
                    tmp.append(orderSheet.getCreateDate3());
                    tmp.append("'");
                }
				
tmp.append(ToolKit.dateBound(loginInfo.getJndiName(),"a",orderSheet, loginInfo.getSysUserCode()));
String orderSql = balSql.toString();
orderSql += tmp.toString();












String invSql = balSql.toString();
tmp = new StringBuffer();
tmp.append(ToolKit.dateBound(loginInfo.getJndiName(),"a","createDate",orderSheet, loginInfo.getSysUserCode()));
                if (!"".equals(orderSheet.getCreateDate1()) &&
                    !"".equals(orderSheet.getCreateDate3())) {
                    tmp.append(" and DATEADD(Day,-1,a.createDate)  between '");
                    tmp.append(orderSheet.getCreateDate1());
                    tmp.append("' and '");
                    tmp.append(orderSheet.getCreateDate3());
                    tmp.append("'");
                }

                if (!"".equals(orderSheet.getCreateDate1()) &&
                    "".equals(orderSheet.getCreateDate3())) {
                    tmp.append(" and DATEADD(Day,-1,a.createDate) >= '");
                    tmp.append(orderSheet.getCreateDate1());
                    tmp.append("'");
                }
                if ("".equals(orderSheet.getCreateDate1()) &&
                    !"".equals(orderSheet.getCreateDate3())) {
                    tmp.append(" and DATEADD(Day,-1,a.createDate)  <= '");
                    tmp.append(orderSheet.getCreateDate3());
                    tmp.append("'");
                }

invSql += tmp.toString();









String suppSql = orderSql;
String ioSql = orderSql;
String lostSql = orderSql;

if(orderSheet.getCustID() != 0) {
	orderSql += " and a.custID=" + orderSheet.getCustID();
}else{
    orderSql += intuitsoft.eclipse.table.system.perm.Perm.sqlCondSQL("a", "custID", loginInfo.params.getCustomerPerm(), orderSheet.getCustID());
}


if(!"".equals(orderSheet.getRegionID())) {
	orderSql += " and a.custID in (select custID from customer where regionID like '"+ orderSheet.getRegionID() + "%')";
}

if(orderSheet.getSuppID() != 0) {
	suppSql += " and b.suppID=" + orderSheet.getSuppID();
}else{
    suppSql += intuitsoft.eclipse.table.system.perm.Perm.sqlCondSQL("b", "suppID", loginInfo.params.getSupplierPerm(), orderSheet.getSuppID());
}

if(orderSheet.getSuppID() != 0) {
	ioSql += " and b.suppID=" + orderSheet.getSuppID();
}else{
    ioSql += intuitsoft.eclipse.table.system.perm.Perm.sqlCondSQL("b", "suppID", loginInfo.params.getSupplierPerm(), orderSheet.getSuppID());
}


String invSql1 = "";
String s1 = orderSheet.getCreateDate1();
if("".equals(orderSheet.getCreateDate1())) {
	WarehouseMonth wm1 = new WarehouseMonth(loginInfo.getJndiName());
	s1 = wm1.getMinDate();
	if(s1 == null) s1 = "1988-05-08";
}
 
invSql1 = " and b.sMonth = '" + s1 + "'";
invSql1 +=ToolKit.dateBound(loginInfo.getJndiName(),"b","sMonth",orderSheet, loginInfo.getSysUserCode());

String invSql2 = "";
String s2 = orderSheet.getCreateDate3();
if("".equals(orderSheet.getCreateDate3())) {
	WarehouseMonth wm2 = new WarehouseMonth(loginInfo.getJndiName());
	s2 = wm2.getMaxDate();
	if(s2 == null) s2 = "1988-05-08";
}
 
invSql2 = " and DATEADD(day, -1, b.sMonth) = '" + s2 + "'";
invSql2 +=ToolKit.dateBound(loginInfo.getJndiName(),"b","sMonth",orderSheet, loginInfo.getSysUserCode());





String warehouseSql = "";
if(orderSheet.getWarehouseCode() != 0) {
	suppSql += " and b.warehouseCode=" + orderSheet.getWarehouseCode();
	orderSql += " and b.warehouseCode=" + orderSheet.getWarehouseCode();
    invSql += " and a.warehouseCode=" + orderSheet.getWarehouseCode();
	invSql1 += " and b.warehouseCode=" + orderSheet.getWarehouseCode();
 	invSql2 += " and b.warehouseCode=" + orderSheet.getWarehouseCode();
	warehouseSql += " and a.warehouseCode=" + orderSheet.getWarehouseCode();
	ioSql += " and a.warehouseCode=" + orderSheet.getWarehouseCode();
	lostSql += " and a.warehouseCode=" + orderSheet.getWarehouseCode();
}else{
	suppSql += intuitsoft.eclipse.table.system.perm.Perm.sqlCondSQL("b", "warehouseCode", loginInfo.params.getWarehousePerm(), 0);
	orderSql += intuitsoft.eclipse.table.system.perm.Perm.sqlCondSQL("b", "warehouseCode", loginInfo.params.getWarehousePerm(), 0);
 	invSql += intuitsoft.eclipse.table.system.perm.Perm.sqlCondSQL("a", "warehouseCode", loginInfo.params.getWarehousePerm(), 0);
	invSql1 += intuitsoft.eclipse.table.system.perm.Perm.sqlCondSQL("b", "warehouseCode", loginInfo.params.getWarehousePerm(), 0);
 	invSql2 += intuitsoft.eclipse.table.system.perm.Perm.sqlCondSQL("b", "warehouseCode", loginInfo.params.getWarehousePerm(), 0);
	warehouseSql += intuitsoft.eclipse.table.system.perm.Perm.sqlCondSQL("a", "warehouseCode", loginInfo.params.getWarehousePerm(), 0);
	ioSql += intuitsoft.eclipse.table.system.perm.Perm.sqlCondSQL("a", "warehouseCode", loginInfo.params.getWarehousePerm(), 0);
	lostSql += intuitsoft.eclipse.table.system.perm.Perm.sqlCondSQL("a", "warehouseCode", loginInfo.params.getWarehousePerm(), 0);
}