📄 right.js
字号:
function trini(){
var sql="";
var layer="";
var layernew="";
oid=document.all.operid.value;
if(oid==""){
alert("XXGZDA-026:没取到当前登陆操作员!");
return;
}
var tag=self.location.href;
//alert(tag);
if(tag.indexOf("=")<=0){
return;
}
if(tag.indexOf("hqosearch")>0){
tag=tag.substring(tag.indexOf("=")+1,tag.length);
var where=" where "+tag.substring(0,tag.indexOf("*"))+" like '%"+tag.substring(tag.indexOf("*")+1,tag.length)+"%'";
//alert(where);
//var sql=" SELECT NAME, CREATEDATE,URL,TYPE FROM T_GZDA_FILEMANAGERABSTR "+where +" and URL<>'A' and OPERID='"+oid+"' ";
var sql="select * from (" +
" select a.url, a.name,a.createdate,a.type ,c.mc "+
" from t_gzda_filemanagerabstr a, t_dm_gy_swry b, t_dm_gy_swjg c "+
" where a.filetype = '1' and a.operid = b.swry_dm and b.swjg_dm = c.swjg_dm "+
" and "+
" (b.swjg_dm in "+
" (select swjg_dm "+
" from t_dm_gy_swjg "+
" connect by prior swjg_dm = sjswjg_dm "+
" start with swjg_dm in "+
" (select swjg_dm "+
" from t_qxgl_swry_zn_jgfw "+
" where swry_dm = '"+oid+"' and zn_dm = '0' "+
" ) "+
" ) "+
" or "+
" a.operid = '"+oid+"' "+
" or "+
" url in "+
" (select sj_xh "+
" from t_qxgl_gx "+
" where jgry_dm in "+
" ((select '01' || swjg_dm "+
" from t_qxgl_swry_zn_jgfw "+
" where swry_dm = '"+oid+"' and zn_dm = '1' "+
" ) "+
" union "+
" select '02' || '"+oid+"' from dual) and table_name = 'T_GZDA_FILEMANAGERABSTR' "+
" ) "+
" ) "+
" order by leve asc "+
" ) " +where;
var oRnt=execute(sql,"gov.gdlt.ssgly.taxcore.taxblh.gzda.service.SqlSelectBLH");
var str=createHTML(oRnt,"没查到满足条件的数据或你权限不够!");
document.all.ttable.outerHTML=str;
}else{
tag=tag.substring(tag.indexOf("=")+1,tag.length);
var cname=tag.substring(0,tag.indexOf("*"));
layer=tag.substring(tag.indexOf("#")+1,tag.indexOf("@"));
var code=tag.substring(tag.indexOf("@")+1,tag.length);
var codelen=code.length;
gcname="**"+cname;
if(cname.indexOf("精华区")>0){
cxJH(layer,cname);
return;
}
var sql="select min(LEVE) LEVE from T_GZDA_FILEMANAGERABSTR WHERE LEVE >"+layer+" and length(trim(CODE)) <= "+codelen+" ORDER BY LEVE ASC ";
// myMessage(sql);
var oRnt=execute(sql,"gov.gdlt.ssgly.taxcore.taxblh.gzda.service.SqlSelectBLH");
layernew=oRnt.selectSingleNode("//root/params/item/LEVE").text;
if(layernew=='0'){
var sql="select max(LEVE) LEVE from T_GZDA_FILEMANAGERABSTR ";
var oRnt=execute(sql,"gov.gdlt.ssgly.taxcore.taxblh.gzda.service.SqlSelectBLH");
layernew=oRnt.selectSingleNode("//root/params/item/LEVE").text;
var la=parseInt(layernew) + 1;
layernew=la.toString();
}
ly=layer;
lyn=layernew;
//var sql=" SELECT count(*) COU FROM T_GZDA_FILEMANAGERABSTR "+
// " where( leve>"+layer+" and LEVE<"+layernew+" and URL<>'A' AND FILESTATUE='0' and OPERID='"+oid+"') or ("+
// " leve>"+layer+" and LEVE<"+layernew+" and URL<>'A' AND FILESTATUE='1' )" +
// " ORDER BY LEVE ASC " ;
glbcode=code;
if((code=='FA')||(code=='FAX')){
var sql=" SELECT count(*) COU FROM T_GZDA_FILEMANAGERABSTR "+
" where leve>"+layer+" and LEVE<"+layernew+" and URL<>'A' "+
" and tpayerid in ( "+
" select to_char(a.nsrnbm) from t_flgl_nsrflxx a ,t_flgl_flxx b where a.fl_xh=b.fl_xh "+
" and b.lrry_dm='"+oid+"' "+
" ) "+
" ORDER BY LEVE ASC " ;
}else{
var sql="select count(*) COU from (" +
" select a.url, a.name,a.createdate,a.type ,c.mc "+
" from t_gzda_filemanagerabstr a, t_dm_gy_swry b, t_dm_gy_swjg c "+
" where a.filetype = '1' and a.operid = b.swry_dm and b.swjg_dm = c.swjg_dm "+
" and "+
" (b.swjg_dm in "+
" (select swjg_dm "+
" from t_dm_gy_swjg "+
" connect by prior swjg_dm = sjswjg_dm "+
" start with swjg_dm in "+
" (select swjg_dm "+
" from t_qxgl_swry_zn_jgfw "+
" where swry_dm = '"+oid+"' and zn_dm = '0' "+
" ) "+
" ) "+
" or "+
" a.operid = '"+oid+"' "+
" or "+
" url in "+
" (select sj_xh "+
" from t_qxgl_gx "+
" where jgry_dm in "+
" ((select '01' || swjg_dm "+
" from t_qxgl_swry_zn_jgfw "+
" where swry_dm = '"+oid+"' and zn_dm = '1' "+
" ) "+
" union "+
" select '02' || '"+oid+"' from dual) and table_name = 'T_GZDA_FILEMANAGERABSTR' "+
" ) "+
" ) and leve >"+layer+" and leve<"+layernew+
" order by leve asc "+
" ) " ;
}
//myMessage(sql);
var oRnt=execute(sql,"gov.gdlt.ssgly.taxcore.taxblh.gzda.service.SqlSelectBLH");
var pagc=oRnt.selectSingleNode("//root/params/item/COU").text;
pagcount=parseInt(pagc);
if(pagcount>isevl){
document.all.next.disabled=false;
}
if(pagcount % isevl!=0){
pagcount=Math.floor(pagcount/isevl) + 1;
}else{
pagcount=Math.floor(pagcount/isevl);
}
//var sql="select NAME, CREATEDATE,URL,TYPE from (" +
// " SELECT rownum myrow, NAME, CREATEDATE,URL,TYPE FROM T_GZDA_FILEMANAGERABSTR "+
// " where( leve>"+layer+" and LEVE<"+layernew+" and URL<>'A' AND FILESTATUE='0' and OPERID='"+oid+"') or ("+
// " leve>"+layer+" and LEVE<"+layernew+" and URL<>'A' AND FILESTATUE='1' )" +
// " ORDER BY LEVE ASC " +
// " ) where myrow>="+pags+" and myrow<="+page ;
if((code=='FA')||(code=='FAX')){
var sql="select NAME, CREATEDATE,URL,TYPE from (" +
" SELECT rownum myrow, NAME, CREATEDATE,URL,TYPE FROM T_GZDA_FILEMANAGERABSTR "+
" where leve>"+layer+" and LEVE<"+layernew+" and URL<>'A' "+
" and tpayerid in ( "+
" select to_char(a.nsrnbm) from t_flgl_nsrflxx a ,t_flgl_flxx b where a.fl_xh=b.fl_xh "+
" and b.lrry_dm='"+oid+"' "+
" ) "+
" ORDER BY LEVE ASC " +
" ) where myrow>="+pags+" and myrow<="+page ;
;
}else{
var sql="select NAME, CREATEDATE,URL,TYPE from (" +
" select rownum myrow,a.url, a.name,a.createdate,a.type ,c.mc "+
" from t_gzda_filemanagerabstr a, t_dm_gy_swry b, t_dm_gy_swjg c "+
" where a.filetype = '1' and a.operid = b.swry_dm and b.swjg_dm = c.swjg_dm "+
" and "+
" (b.swjg_dm in "+
" (select swjg_dm "+
" from t_dm_gy_swjg "+
" connect by prior swjg_dm = sjswjg_dm "+
" start with swjg_dm in "+
" (select swjg_dm "+
" from t_qxgl_swry_zn_jgfw "+
" where swry_dm = '"+oid+"' and zn_dm = '0' "+
" ) "+
" ) "+
" or "+
" a.operid = '"+oid+"' "+
" or "+
" url in "+
" (select sj_xh "+
" from t_qxgl_gx "+
" where jgry_dm in "+
" ((select '01' || swjg_dm "+
" from t_qxgl_swry_zn_jgfw "+
" where swry_dm = '"+oid+"' and zn_dm = '1' "+
" ) "+
" union "+
" select '02' || '"+oid+"' from dual) and table_name = 'T_GZDA_FILEMANAGERABSTR' "+
" ) "+
" ) and leve >"+layer+" and leve<"+layernew+
" order by leve asc "+
" ) where myrow>="+pags+" and myrow<="+page ;
}
//myMessage(sql);
var oRnt=execute(sql,"gov.gdlt.ssgly.taxcore.taxblh.gzda.service.SqlSelectBLH");
//MyMessage(oRnt);
var str=createHTML(oRnt,"没有你需要查看的文件!");
document.all.ttable.innerHTML=str;
}
}
function createHTML(obj,mess,statue){
//<input name='checkbox9' type='checkbox' value='checkbox'>
var str="<table width='98%' border='0' cellspacing='1' cellpadding='3'>";
var para=obj.selectSingleNode("//root/params");
var plen=para.childNodes.length;
tbod=document.all.addtable;
if(plen>0){
str+="<tr>"+
"<td>"+
"<table width='100%' id='tsw' border='0' cellspacing='0' id='hqo' cellpadding='0'>" ;
for(var i=0;i<plen;i++){
var item=para.childNodes[i];
var name=item.getElementsByTagName("NAME")(0).text;
var cdate=item.getElementsByTagName("CREATEDATE")(0).text;
var url=item.getElementsByTagName("URL")(0).text;
var typ=item.getElementsByTagName("TYPE")(0).text;
if(statue){
str+="<tr>"+
"<td width='25' align='center' valign='top'> "+
"<input name='checkbox' id='"+url+"' disabled=true type='checkbox' onclick='parseCheck(this)' value='checkbox'>"+
"</td>"+
"<td class='p126579AC' valign='top' name='"+typ+"' id='hqo"+url+"' onclick='teshow(this)' onmouseover='showlj(this)'> <a class='ablue' href='javascript:void(null)' onclick='' > "+name+"</td>"+
"<td class='p126579AC' width='70' valign='top'>"+cdate+"</td>"+
"</tr>" ;
}else{
str+="<tr>"+
"<td width='25' align='center' valign='top'> "+
"<input name='checkbox' id='"+url+"' type='checkbox' onclick='parseCheck(this)' value='checkbox'>"+
"</td>"+
"<td class='p126579AC' valign='top' name='"+typ+"' id='hqo"+url+"' onclick='teshow(this)' onmouseover='showlj(this)'> <a class='ablue' href='javascript:void(null)' onclick='' > "+name+"</td>"+
"<td class='p126579AC' width='70' valign='top'>"+cdate+"</td>"+
"</tr>" ;
}
} //end for
str+="</table>"+
"</td>"+
"</tr>";
}else{
alert("XXGZDA-025:"+mess);
}
str+="</table>";
return str;
}
function teshow(obj){
url=obj.id ;
//alert(url);
url=url.substring(3,url.length)
document.all.editvalue.value="";
type=obj.name;
switch(type){
case "doc" :
//parent.work.location.href="DocEdit.jsp?caseno="+url+"&EditType=0&UserName="
// parent.work.location.href="word.jsp?caseno="+url+"&EditType=0&UserName="
parent.work.document.all.filedetail.src="word.jsp?caseno="+url+"&EditType=0&UserName=" ;
//parent.work.document.all.filedetail.src="DocEdit.jsp?caseno="+url+"&EditType=0&UserName=" ;
document.all.editvalue.value=type+"-"+url;
break;
case "xls" :
//parent.work.location.href="excel.jsp?caseno="+url+"&EditType=0&UserName="
//parent.work.location.href="ExcelEdit.jsp?caseno="+url+"&EditType=0&UserName="
parent.work.document.all.filedetail.src="excel.jsp?caseno="+url+"&EditType=0&UserName=";
document.all.editvalue.value=type+"-"+url;
break;
case "txt" :
//parent.work.location.href="text.jsp?caseno="+url+"&EditType=0&UserName="
parent.work.document.all.filedetail.src="text.jsp?caseno="+url+"&EditType=0&UserName=";
break;
case "htm" :
parent.work.document.all.filedetail.src="text.jsp?caseno="+url+"&EditType=0&UserName=";
//parent.work.location.href="../htmledit/editor.jsp?module=12&caseno="+url+"&EditType=0&UserName="
break;
case "jpg" :
//parent.work.location.href="jpg.jsp?caseno="+url+"&EditType=0&UserName="
parent.work.document.all.filedetail.src="jpg.jsp?caseno="+url+"&EditType=0&UserName=";
break;
case "ppt" :
//parent.work.location.href="ppt.jsp?caseno="+url+"&EditType=0&UserName="
parent.work.document.all.filedetail.src="ppt.jsp?caseno="+url+"&EditType=0&UserName=";
break;
}
}
var svalue="X";
function parseCheck(obj){
var id=obj.id;
var res=eval("/X"+id+"/g");
var s="";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -