📄 advquery.vm
字号:
{
alert("起始日期必须小于终止日期!");
return false;
}
str="条件:"+vlinkflag+vtype+" "+opr+" "+starttime+"和"+endtime+"之间";
}
else
{
if(keyv=="")
{
alert("请输入查询条件!");
return false;
}
str="条件:"+vlinkflag+vtype+" "+opr+" "+keyt;
}
if (oprv=="inrange")
{
//转换[字符
var regS=new RegExp("[[]","gi");
keyv=keyv.replace(regS,"[[]");
strv=" "+vlinkflagv+" "+vtypev+" like '%"+keyv+"%'"
}
else if (oprv=="eqrange")
{
strv=" "+vlinkflagv+" "+vtypev+" ='"+keyv+"'"
}
else if (oprv=="lt")
{
strv=" "+vlinkflagv+" "+vtypev+" >'"+keyv+"'"
}
else if (oprv=="st")
{
strv=" "+vlinkflagv+" "+vtypev+" <'"+keyv+"'"
}
else if (oprv=="eq")
{
strv=" "+vlinkflagv+" "+vtypev+" ='"+keyv+"'"
}
else if(oprv=="jy")
{
strv=" "+vlinkflagv+" ("+vtypev+" <'"+DateAdd(endtimev,1,"d")+"' and "+vtypev+" >='"+starttimev+"') "
}
var ooption = document.createElement("OPTION");
ooption.text=str;
ooption.value=strv;
document.mform.se.options.add(ooption);
document.mform.vlinkflag.selectedIndex=0;
document.mform.vlinkflag.disabled=false;
}
function del_it(){
if(document.mform.se.selectedIndex==-1){
alert("请选择查询条件！");
return false;
}
document.mform.se.options.remove(document.mform.se.selectedIndex);
}
function cxfz()
{
/*
if(document.mform.se.length==0)
{
alert("请您自定义查询条件!");
return ;
}
*/
document.mform.where.value="";
for (i=0;i<document.mform.se.length;i++)
{
if (document.mform.where.value!="")
{
document.mform.where.value=" ("+document.mform.where.value+") ";
}
document.mform.where.value=document.mform.where.value+" "+document.mform.se.item(i).value;
}
if (document.mform.scopewhere.value!="")
{
if (document.mform.where.value!="")
{
document.mform.where.value=" ("+document.mform.where.value+") "+" and "+document.mform.scopewhere.value;
}
else
{
document.mform.where.value=document.mform.where.value+" "+document.mform.scopewhere.value;
}
}
mform.action=document.mform.Url.value;
mform.submit();
}
function del_list()
{
while(document.mform.se.options.length>0)
{
document.mform.se.options.remove(document.mform.se.options.length-1);
}
}
function changescope(scopevalue)
{
if (parseInt(scopevalue)>0 && parseInt(scopevalue)<8)
{
document.mform.Url.value="$request.getContextPath()/sendquery.do?method=sendadvquery";
}
if (parseInt(scopevalue)>7)
{
document.mform.Url.value="$request.getContextPath()/recvquery.do?method=recvadvquery";
}
if (scopevalue=="1")
{
document.mform.scopewhere.value="";
}
if (scopevalue=="8")
{
document.mform.scopewhere.value=" docId in (select recvDocForm from RecvPermission where unitId=$!userinfo.getUnit().getUnitId()) ";
}
if (scopevalue=="2") document.mform.scopewhere.value=" status in ('0') ";
if (scopevalue=="3") document.mform.scopewhere.value=" status in ('1') ";
if (scopevalue=="4") document.mform.scopewhere.value=" status in ('2') ";
if (scopevalue=="5") document.mform.scopewhere.value=" status in ('3') ";
if (scopevalue=="6") document.mform.scopewhere.value=" status in ('5') ";
if (scopevalue=="7") document.mform.scopewhere.value=" status in ('10','11','12','13') ";
if (scopevalue=="9") document.mform.scopewhere.value=" docId in (select recvDocForm from RecvPermission where status in ('0') and unitId=$!userinfo.getUnit().getUnitId()) ";
if (scopevalue=="10") document.mform.scopewhere.value=" docId in (select recvDocForm from RecvPermission where status in ('2') and unitId=$!userinfo.getUnit().getUnitId()) ";
if (scopevalue=="11") document.mform.scopewhere.value=" docId in (select recvDocForm from RecvPermission where status in ('4') and unitId=$!userinfo.getUnit().getUnitId()) ";
if (scopevalue=="12") document.mform.scopewhere.value=" docId in (select recvDocForm from RecvPermission where status in ('6') and unitId=$!userinfo.getUnit().getUnitId()) ";
//if (scopevalue=="13") document.mform.scopewhere.value=" docId in (select recvDocForm from RecvPermission where status in ('8') and unitId=$!userinfo.getUnit().getUnitId()) ";
}
</script>
<body>
<br><br>
<form method="post" name="mform">
<input type="hidden" name="Url" value="$request.getContextPath()/sendquery.do?method=sendadvquery">
<input type="hidden" name="where">
<input type="hidden" name="scopewhere" value="">
<table width="520" border="0" align="center" cellpadding="0">
<tr><td height="1" align=center><b><font color="#570017" size="4" face="楷体_GB2312">高 级 查 询</font></b></td></tr>
<tr><td height="1"><HR width="100%" color="#570017"></td></tr>
</table>
<table border="0" width=420 cellspacing="0" cellpadding="0" align="center" valign="center">
<tr height=35>
<td>查询范围：
<select name=scope style="width:100;background-color:#DEDFDE; font-size:9pt" onChange="changescope(this.value)">
<option value="1">发文</option>
<option value="2">文件草稿</option>
<option value="4">待发送文件</option>
<option value="5">已发送文件</option>
<option value="8">收文</option>
<option value="9">待签收文件</option>
<option value="10">已签收文件</option>
<option value="11">已退回文件</option>
</select>
</td>
</tr>
<tr>
<td width="100%">
<select name="se" size=5 style="width=420"></select>
<option></option>
</td>
</tr>
<tr height=25>
<td align="right"><button onclick="javascript:return del_it();">删除</button></td>
</tr>
</table>
<table width="420" cellspacing="1" cellpadding="3" bgcolor="#000000" align=center>
<tr>
<td bgcolor="#F0f0f0" height="1" colspan="2">自定义条件：<img src="$request.getContextPath()/image/shim.gif" width="1" height="1"></td>
</tr>
<tr height=25>
<td bgcolor="#FFFFFF">查询要素：
<select name="vtype" onchange="javascript:create_comp()" style="background-color:#DEDFDE; font-size:9pt">
<option value="docTitle">标题</option>
<option value="docNoPre+'['+yearNo+']'+waterNo">文号</option>
<option value="subject">主题词</option>
<option value="secret">秘级程度</option>
<option value="emergency">紧急程度</option>
<option value="creator">登记人</option>
<option value="createdate">登记时间</option>
</select>
</td>
<td bgcolor="#FFFFFF"> 查询动作：
<select name=operate1 style="background-color:#DEDFDE; font-size:9pt">
<option value=inrange selected>包含</option>
<option value=eqrange>等于</option>
</select>
</td>
</tr>
<tr height=25>
<td colspan=2 bgcolor="#FFFFFF">值或范围：
<div id="z1" style="position:absolute; left:275px; top:268px; width:250px; height:14px; z-index:8; visibility: visible">
<input type="text" name=keywords class="inputStyle1" style="width:230" maxlength=20>
</div>
<div id="z2" style="position:absolute; left:275px; top:268px; width:250px; height:14px; z-index:8; visibility: hidden">
<select name="select_type" style="width:73;">
<option value="0">请选择</option>
</select>
</div>
<div id="z3" style="position:absolute; left:275px; top:268px; width:250px; height:14px; z-index:8; visibility: hidden">
<input type="text" name=time class="inputStyle1" style="width:90" readonly><img src="$request.getContextPath()/image/checkdate.gif" onclick="DoCal(time)" >
</div>
<div id="z4" style="position:absolute; left:275px; top:268px; width:250px; height:14px; z-index:8; visibility: hidden">
<input type="text" name=timestart class="inputStyle1" style="width:90" readonly><img src="$request.getContextPath()/image/checkdate.gif" onclick="DoCal(timestart)" > 至 <input type="text" name=timeend class="inputStyle1" style="width:90" readonly><img src="$request.getContextPath()/image/checkdate.gif" onclick="DoCal(timeend)" >
</div>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align=left>
连接符：
<select name="vlinkflag" style="background-color:#DEDFDE; font-size:9pt" disabled>
<option value="">请选择连接符</option>
<option value="and">并且</option>
<option value="or">或者</option>
</select>
</td>
<td bgcolor="#FFFFFF" align=right><button onclick="add_it()">添加</button></td>
</tr>
</table>
<table width="520" border="0" align="center" cellpadding="0">
<tr><td height="1"><HR width="100%" color="#570017"></td></tr>
</table>
<table width="400" border="0" align="center" cellpadding="0">
<tr>
<td width="100%" colspan="2">
<p align="center">
<button onclick="cxfz();" accesskey="Q">执行查询(Q)</button>
<button onclick="del_list()" accesskey="R">新 检 索(R)</button>
</p>
</td>
</tr>
</table>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -