58 lines
2.2 KiB
Plaintext
58 lines
2.2 KiB
Plaintext
<%@ page contentType="text/html; charset=GBK"%>
|
||
<%@ include file="/Frame/resources/include/include_begin.jspf"%>
|
||
<%
|
||
String PG_TITLE = "本行信贷业务固定统计报表"; // 浏览器窗口标题 <title> PG_TITLE </title>
|
||
String PG_CONTENT_TITLE = " 固定报表查询 "; //默认的内容区标题
|
||
String PG_CONTNET_TEXT = "请点击左侧列表";//默认的内容区文字
|
||
String PG_LEFT_WIDTH = "280";//默认的treeview宽度
|
||
%>
|
||
<%@ include file="/Frame/resources/include/include_main.jspf"%>
|
||
<script type="text/javascript">
|
||
function TreeViewOnClick(){
|
||
var node = getCurTVItem();
|
||
var sCurItemType = node.type;
|
||
var sSheetID = node.value;
|
||
alert(sSheetID);
|
||
if(sCurItemType != 'folder'){
|
||
OpenPage("/FixStat/FixSheetShow.jsp?SheetID="+sSheetID+"&DisplayCriteria=true&rand="+randomNumber(),"right");
|
||
setTitle(getCurTVItem().name);
|
||
}
|
||
}
|
||
|
||
function startMenu(){
|
||
<%
|
||
/* TREEVIEW 报表展现范围控制
|
||
* 通过报表模板中权限标志RightInfo与系统中用户的角色RoleID相结合
|
||
* 存在两种控制手段：1、报表具体到角色级别，即一张报表对应多个许可的访问角色
|
||
* 2、报表具体到访问区域，即一张报表简单对应具有相同角色特征的访问角色
|
||
*/
|
||
//控制方法1
|
||
String sUserRole = "and EXISTS ("
|
||
+" select RI.RoleID "
|
||
+" from USER_ROLE UR,ROLE_INFO RI "
|
||
+" where RI.RoleID=UR.RoleID "
|
||
//+" and S_SHEET_MODEL.RightInfo like '%UR.RoleID%' "
|
||
//+" and UR.UserID='"+CurUser.getUserID()+"' "
|
||
+" ) ";
|
||
//控制方法2
|
||
/*
|
||
String sUserRole = "and RightInfo like '%'||( "
|
||
+" select RI.RoleID[1,1] "
|
||
+" from USER_ROLE UR,ROLE_INFO RI "
|
||
+" where RI.RoleID=UR.RoleID "
|
||
//+" and UR.RoleID like R_SHEET_MODEL.RightInfo||'%' "
|
||
+" and UR.UserID='"+CurUser.getUserID()+"' "
|
||
+" )||'%'";
|
||
*/
|
||
OHTMLTreeView tviTemp = new OHTMLTreeView(CurPage, "固定报表查询列表","right");
|
||
tviTemp.init(JBOFactory.getBizObjectManager("jbo.report.R_SHEET_MODEL"), "OrderNo", "SheetTitle", "SheetID", "Describea", "", "FROM O where OrderNo not like 'h%' AND OrderNo not like 'H%' and (OrderNo is not null and OrderNo <> ' ') ");
|
||
out.println(tviTemp.generateHTMLTreeView());
|
||
%>
|
||
expandNode('root');
|
||
click_change(0, true);
|
||
}
|
||
|
||
startMenu();
|
||
setTitle("固定报表查询", true);
|
||
</script>
|
||
<%@ include file="/Frame/resources/include/include_end.jspf"%> |