<%@ page language="java" import="java.util.*" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
|
<%@page import="com.yc.factory.FactoryBean" %>
|
<%@page import="com.yc.service.panel.time.PanelTimeDao" %>
|
<%@page import="com.yc.service.panel.SqlDBHelperIfc" %>
|
<%@page import="com.yc.service.impl.DBHelper" %>
|
<%@page import="com.yc.service.panel.SystemSettingsDao" %>
|
<%@page import="com.yc.utils.SessionKey" %>
|
<%@ page import="com.yc.sdk.shopping.util.SettingKey" %>
|
<%@ include file="dataHead.jsp" %>
|
<%
|
SqlDBHelperIfc sqlDBHelperIfc = (SqlDBHelperIfc) FactoryBean.getBean("SqlDBHelper");
|
PanelTimeDao PanelTimeBo = (PanelTimeDao) FactoryBean.getBean("PanelTime");
|
String path = request.getContextPath();
|
String openDoc = "@openDoc@";
|
sqlDBHelperIfc.execSql(DBHelper.getRepAll(openDoc, session, null, true));
|
|
|
// SystemSettingsDao systemsettingsdao=(SystemSettingsDao)FactoryBean.getBean("SystemSettings");
|
// int formidd=Integer.parseInt("@formId@");
|
// Map<String,Object> ms=systemsettingsdao.getFormIdInTable(formidd);
|
// String syt=session.getAttribute(SessionKey.USERCODE).toString();
|
// String rol=session.getAttribute(SessionKey.ROLE_NAME).toString();
|
//
|
// List<Map<String, Object>> queryList = systemsettingsdao.selecTH(ms.get("hdtable").toString(),syt,rol);
|
//
|
// String sys="";
|
// String adm="";
|
// String role="";
|
// try {
|
// sys=queryList.get(0).get("ReaderUsercodes").toString();
|
// adm=queryList.get(0).get("ReaderOrganizations").toString();
|
// role=queryList.get(0).get("ReaderRoles").toString();
|
// } catch (Exception e) {
|
// sys.toString();
|
// adm.toString();
|
// role.toString();
|
// }
|
dateformid = (dateformid.equals("#dataformid#")) ? "@formId@" : dateformid;
|
formdatafilters = (formdatafilters.equals("#formdatafilters#")) ? "" : formdatafilters;
|
%>
|
@linkscript@
|
<style>
|
.main_talbe td{
|
padding: 3px;
|
}
|
.main_talbe input{
|
border-radius: 5px;
|
border: 1px solid #99BBE8;
|
}
|
</style>
|
<script type="text/javascript"
|
src="/js/calendar/WdatePicker.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/calendar/WdatePicker.js")%>"
|
defer="defer"></script>
|
<script type="text/javascript"
|
src="/js/panel.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/panel.js")%>"></script>
|
<script type="text/javascript"
|
src="/js/pan_search.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/pan_search.js")%>"></script>
|
<table class="main_talbe" border="0" width="500" cellpadding="0" cellspacing="1" id="panTb" style="margin-top: 5px">
|
<tr>
|
<td height="24px" width="87" nowrap style="text-align: right">凭证日期：</td>
|
<td height="24px" colspan="5" nowrap>从<input id="begindayDate" value="1" type="hidden"/>
|
<INPUT name="beginday" id="beginday" onclick="showDate('beginday',true,'');"
|
onChange="getOder()" value="" class="Wdate" My97Mark="true">
|
到<input id="enddayDate" value="1" type="hidden"/>
|
<INPUT name="endday" id="endday" onclick="showDate('endday',true,'');"
|
onChange="getOder()" value="" class="Wdate" My97Mark="false"></td>
|
<td width="51" nowrap style="text-align: right">单据号</td>
|
<td width="300" nowrap>
|
<input class="Three_show" autocomplete="off" style="cursor: pointer;width:130px; height:24px;" id="DocCode" name="DocCode" size="15"
|
value="" onChange="getOder();"
|
onkeydown="keyDown('DocCode',event);"/>
|
<span style="margin-left:-20px;margin-top:5px;border:0px solid #000000;"><img src="<%=URL%>/images/ppp.gif" style="cursor: pointer;" onclick=""/></span></td>
|
</tr>
|
<tr>
|
<td height="24" nowrap style="text-align: right">筛选：</td>
|
<td height="24" colspan="7" nowrap>
|
<span style=" border:1px solid #99BBE8;border-radius: 5px;width: 52%;display: block">
|
<input name="RadioGroup1" type="radio" id="RadioGroup1_0" onClick="getOder()" value="本阶段" checked>
|
本阶段
|
<input type="radio" name="RadioGroup1" value="未确定" id="RadioGroup1_1" onClick="getOder()" align="absmiddle">
|
未确定 <input type="radio" name="RadioGroup1" value="已确定" id="RadioGroup1_0" onClick="getOder()">
|
已确定
|
<input name="RadioGroup1" type="radio" id="RadioGroup1_2" value="未送达" onClick="getOder()" align="absmiddle">
|
未送达
|
<input type="radio" name="RadioGroup1" value="已处理" id="RadioGroup1_3" onClick="getOder()">
|
已处理
|
<input type="radio" name="RadioGroup1" value="所有" id="RadioGroup1_4" onClick="getOder()" align="absmiddle">
|
所有 </span>
|
</td>
|
</tr>
|
<tr>
|
<td height="24" nowrap> </td>
|
<td height="24" colspan="7" nowrap>
|
<span>
|
<input name="checkbox1" type="checkbox" id="checkbox1_0" onClick="getOder()" value="尽含自制单">
|
仅含自制单
|
<input name="checkbox1" type="checkbox" id="checkbox1_1" onClick="getOder()" value="显示所有未确认单">
|
显示所有未确认单
|
<input name="checkbox1" type="checkbox" id="checkbox1_2" onClick="getOder()" value="隐藏作废单">
|
隐藏作废单 </span></td>
|
</tr>
|
</table>
|
<div id="tplt-grid">
|
<%@ include file="@formId@_grid.jsp" %>
|
</div>
|
<script type="text/javascript">
|
function keyDown(op, e) {
|
var event;
|
if (e != 'null') {
|
event = $.event.fix(e);
|
}
|
if (op == '123' || event.keyCode == 13) {
|
getOder();
|
}
|
}
|
|
var shaixuan = "";
|
|
function onRadioClick(op) {
|
var radioS = document.getElementsByName('RadioGroup1');
|
var radioIs = null;
|
for (var i = 0; i < radioS.length; i++) {
|
radioIs = radioS.item(i);
|
if (radioIs.checked) {
|
switch (radioIs.value) {
|
case "本阶段":
|
shaixuan = "( docstatus between 0 and 100 )";
|
break;
|
case "未确定":
|
shaixuan = "( docstatus = 0 )";
|
break;
|
case "已确定":
|
shaixuan = "( docstatus = 100 )";
|
break;
|
case "未送达":
|
shaixuan = "( docstatus < 0 )";
|
break;
|
case "已处理":
|
shaixuan = "( docstatus > 100 )";
|
break;
|
case "所有":
|
shaixuan = "( 1 = 1 )";
|
break;
|
}
|
break;
|
}
|
}
|
}
|
|
function getOder() {
|
var where = "";
|
var date = "( docdate between '" + document.getElementById('beginday').value + "' and '" + document.getElementById('endday').value + "' )";
|
onRadioClick('');
|
where += date + " and " + shaixuan;
|
where = getKuoHao(where);
|
var fuXuan = document.getElementById('checkbox1_1');
|
if (fuXuan.checked) {
|
where += " or ( Docstatus = 0 )"//所以未确认的单
|
where = getKuoHao(where);
|
}
|
var doccode = document.getElementById('DocCode').value;
|
if (doccode != null && doccode != "") {
|
where = " ( doccode like '" + doccode + "@~' )";
|
}
|
fuXuan = document.getElementById('checkbox1_0');
|
if (fuXuan.checked) {
|
where += " and ( entername like '@~@~' )";//自制单
|
}
|
fuXuan = document.getElementById('checkbox1_2');
|
if (fuXuan.checked) {
|
where += " and ( isnull(blscrap ,0) = 0 )";//隐藏单
|
}
|
where = getKuoHao(where);
|
where += " and ( formid in ( @formId@<%=dateformid%> ))<%=formdatafilters%> ";
|
//@whereAdd@
|
where += " and (<%=DBHelper.getQx(session)%>)";
|
where = getKuoHao(where);
|
where = where.replaceAll("\%", "@~");
|
create(encodeText(where), 1);
|
}
|
|
<%
|
HashMap<String, String> timeMap=PanelTimeBo.getTimeTag(Integer.parseInt("@formId@")).get(0);
|
%>
|
document.getElementById('beginday').value = '<%=timeMap.get("beginday").substring(0,10) %>';
|
document.getElementById('endday').value = '<%=timeMap.get("endday").substring(0,10) %>';
|
getOder();
|
</script>
|
