BudgetDimensionMembe.jsp 12.9 KB
<%@page import="weaver.fna.general.FnaCommon"%>
<%@page import="org.apache.commons.lang.StringEscapeUtils"%>
<%@ taglib uri="/WEB-INF/weaver.tld" prefix="wea"%>
<%@page import="weaver.hrm.HrmUserVarify"%>
<%@page import="weaver.hrm.User"%>
<%@ page import="weaver.general.Util" %>
<%@ page import="weaver.workflow.field.BrowserComInfo" %>
<%@ taglib uri="/WEB-INF/tld/browser.tld" prefix="brow"%>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="UserDefaultManager" class="weaver.docs.tools.UserDefaultManager" scope="session" />

<%
	if(true) {
	    response.sendRedirect("/notice/noright.jsp") ;
	    return ;
	}

    String imagefilename = "/images/hdMaintenance_wev8.gif";
    String titlename = SystemEnv.getHtmlLabelName(332,user.getLanguage());//全部
    String needfav ="1";
    String needhelp ="";
    String mainId = Util.null2String(request.getParameter("id")); //维度id

    String tableName = Util.null2String(request.getParameter("tableName")); //维度表名
    String accountId = Util.null2String(request.getParameter("accountId")); //帐套id
    String dimensionName = "";
    String dimensionBody = "";
    String dimensionType = "";
    String description = "";
    String browsertype = "";
    String definebroswerType = "";
    String numberCode = "";
    if(!"".equalsIgnoreCase(tableName)) {
        rs.executeQuery("select * from " + StringEscapeUtils.escapeSql(tableName) + " where id=?", mainId);
        if (rs.next()) {
            dimensionName = Util.null2String(rs.getString("dimensionName")).trim();    //维度名称
            dimensionBody = Util.null2String(rs.getString("dimensionBody")).trim();     //维度主体
            dimensionType = Util.null2String(rs.getString("dimensionType")).trim();     //维度类型
            browsertype = Util.null2String(rs.getString("browsertype")).trim();     //自定义浏览按钮
            definebroswerType = Util.null2String(rs.getString("definebroswerType")).trim();     //自定义树形
            numberCode = Util.null2String(rs.getString("numberCode")).trim();     //维度编号
        }
    }
    String browserUrl = "";

    if("0".equals(dimensionBody)){ //预算周期
        //根据accountId查询周期表名
        String periodTableName = "";
        rs.executeQuery(" select * from FnaAccountDtl where accountId = ? and tableType = ? ", accountId, 3);
        if(rs.next()){
            periodTableName = Util.null2String(rs.getString("tableName"));
        }
        browserUrl = "/systeminfo/BrowserMain.jsp?url=/fna/mulDimensions/budgetDimension/browser/periodBrowser/PeriodBrowserMulti.jsp%3Fselectedid=#id#%26tableName="+periodTableName;
    }else if("1".equals(dimensionBody)){  //预算承担主体
        //根据accountId查询预算承担主体表名
        String bearerTableName = "";
        rs.executeQuery(" select * from FnaAccountDtl where accountId = ? and tableType = ? ", accountId, 0);
        if(rs.next()){
            bearerTableName = Util.null2String(rs.getString("tableName"));
        }
        browserUrl = "/systeminfo/BrowserMain.jsp?url=/fna/mulDimensions/budgetDimension/browser/budgetBearerBrowser/BudgetBearerBrowserMulti.jsp%3Fselectedid=#id#%26tableName="+bearerTableName;
    }else if("2".equals(dimensionBody)){  //人力资源
        browserUrl = new BrowserComInfo().getBrowserurl("17");
    }else if("3".equals(dimensionBody)){ //预算科目
        browserUrl = "/systeminfo/BrowserMain.jsp?url=/fna/mulDimensions/budgetDimension/browser/budgetSubjectBrowser/BudgetSubjectBrowserMulti.jsp%3Fselectedid=#id#%26accountId="+accountId;
    }else if("4".equals(dimensionBody)){ //项目
        browserUrl = new BrowserComInfo().getBrowserurl("135")+"%3FProjID=#id#";
    }else if("5".equals(dimensionBody)){ //客户
        browserUrl = new BrowserComInfo().getBrowserurl("18")+"%3FCustomerID=#id#";
    }else if("162".equals(dimensionBody)||"161".equals(dimensionBody)){ //自定义浏览按钮
        browserUrl =new BrowserComInfo().getBrowserurl(dimensionBody)+"%3Ftype="+browsertype+"%26selectedids=#id#";
    }else if("257".equals(dimensionBody)||"256".equals(dimensionBody)){ //自定义树形
        browserUrl = new BrowserComInfo().getBrowserurl(dimensionBody)+"%3Ftype="+definebroswerType+"_257%26selectedids=#id#";
    }
%>
<html>
<head>
    <LINK href="/css/Weaver_wev8.css" type=text/css rel=STYLESHEET>
    <script language="javascript" src="/js/weaver_wev8.js"></script>
    <script language="javascript" src="/fna/js/e8Common_wev8.js?r=3"></script>


</head>
<body style="overflow:hidden;">
<%@ include file="/systeminfo/TopTitle_wev8.jsp" %>
<%@ include file="/systeminfo/RightClickMenuConent_wev8.jsp" %>
<%
    RCMenu += "{"+SystemEnv.getHtmlLabelName(125217,user.getLanguage())+",javascript:addDimension(),_TOP} ";//新建
    RCMenuHeight += RCMenuHeightStep ;
    RCMenu += "{"+SystemEnv.getHtmlLabelName(32136,user.getLanguage())+",javascript:batchDel(),_TOP} ";//批量删除
    RCMenuHeight += RCMenuHeightStep ;
%>
<%@ include file="/systeminfo/RightClickMenu_wev8.jsp" %>
<form name="form2" method="post"  action="/fna/mulDimensions/budgetDimension/BudgetDimensionViewInner.jsp">
    <div style="display:none;">
        <brow:browser viewType="0"  name="dimensionBody" browserValue=''
                      browserUrl='<%=browserUrl%>'
                      hasInput="true" isSingle="false" hasBrowser="true" isMustInput="1"
                      completeUrl=''
                      browserSpanValue='' width="80%"
                      _callback="dimensionBody_callback" afterDelCallback="" >
        </brow:browser>
    </div>
    <input type="hidden" id="tableName" name="tableName" value="<%=tableName%>" />

    <table id="topTitle" cellpadding="0" cellspacing="0">
        <tr>
            <td>
            </td>
            <td class="rightSearchSpan" style="text-align:right; width:500px!important">
                <input type="button"  value="<%=SystemEnv.getHtmlLabelName(125217,user.getLanguage()) %>" class="e8_btn_top" onclick="addDimension();"/><!-- 新建 -->
                <input type="button" value="<%=SystemEnv.getHtmlLabelName(32136,user.getLanguage()) %>" class="e8_btn_top" onclick="batchDel()"/><!-- 批量删除 -->
                &nbsp;&nbsp;&nbsp;
                <span title="<%=SystemEnv.getHtmlLabelName(23036,user.getLanguage()) %>" class="cornerMenu"></span><!-- 菜单 -->
            </td>
        </tr>
    </table>

    <!-- advanced search -->
    <div class="advancedSearchDiv" id="advancedSearchDiv">
    </div>
    <%
        String tableString = "";
        if(!"".equals(tableName)){

            String number = tableName.split("_")[1];

            //设置好搜索条件
            String backfields = " id,dimensionId,fkVarchar,fkName,displayOrder";
            String fromSql = " from FnaDimensionMember_"+ number +"_"+numberCode;
            String sqlWhere = " where 1=1 ";

            String orderby = " displayOrder ";


            tableString = "<table instanceid=\"FNA_BUDGET_DIMENSIONMEMBE_INNER\" pageId=\""+PageIdConst.FNA_BUDGET_DIMENSIONMEMBE_INNER+"\" "+
                    " pagesize=\""+PageIdConst.getPageSize(PageIdConst.FNA_BUDGET_DIMENSIONMEMBE_INNER,user.getUID(),PageIdConst.FNA)+"\" tabletype=\"checkbox\">"+
                    "<sql backfields=\""+Util.toHtmlForSplitPage(backfields)+"\" sqlform=\""+Util.toHtmlForSplitPage(fromSql)+"\" sqlwhere=\""+Util.toHtmlForSplitPage(sqlWhere)+"\" sqlorderby=\""+Util.toHtmlForSplitPage(orderby)+"\" "+
                    " sqlprimarykey=\"id\" sqlsortway=\"Asc\" />"+
                    "<head>"+
                    "<col width=\"50%\"  text=\""+SystemEnv.getHtmlLabelName(81709,user.getLanguage())+"\" column=\"fkName\" orderkey=\"fkName\" />"+
                    "</head>"+
                    "		<operates>"+
                    "           <operate href=\"javascript:doDel_grid();\" text=\""+SystemEnv.getHtmlLabelName(91, user.getLanguage())+"\" index=\"3\"/>"+
                    "       </operates>"+
                    "</table>";
        }

    %>


    <%
        if(!"".equals(tableName)){
    %>
    <wea:layout type="4col">
        <wea:group context="" attributes="{\"groupDisplay\":\"none\"}" >
            <wea:item attributes="{'isTableList':'true'}">
                <input type="hidden" name="pageId" id="pageId" value="<%=PageIdConst.FNA_BUDGET_DIMENSIONMEMBE_INNER %>" />
                <wea:SplitPageTag  tableString='<%=tableString%>'  mode="run" />
            </wea:item>
        </wea:group>
    </wea:layout>
    <%
    } else{

    %>

    <div></div>

    <%
        }
    %>

</form>


<script language="javascript">
    var _Label33574 = "<%=SystemEnv.getHtmlLabelName(33574,user.getLanguage()) %>";//正在处理数据,请不要离开该页面,请稍等...

    var tableName = "<%=tableName%>";
    var accountId = "<%=accountId%>";
    var mainId = "<%=mainId%>";
    var dimensionBody = "<%=dimensionBody%>";
    var numberCode = "<%=numberCode%>";

    jQuery(function(){

    });


    //新建
    function addDimension(){
        jQuery("#dimensionBody_browserbtn").trigger("click");
    }

    //浏览按钮
    function dimensionBody_callback(event, datas, name, _callbackParams){
        var dataIds = datas.id;
        var dataNames = datas.name;
        if(dataIds==""){
            return;
        }
        var _data = "op=save&accountId="+accountId+"&numberCode="+numberCode+"&dataIds="+dataIds+"&dataNames="+dataNames+"&mainId="+mainId;
        jQuery.ajax({
            url : "/fna/mulDimensions/budgetDimension/budgetDimensionMembe/BudgetDimensionMembeOp.jsp",
            type : "post",
            cache : false,
            processData : false,
            data : _data,
            dataType : "json",
            success: function do4Success(_json){
                if(_json.status == 1){
                    window._table.reLoad();
                }else{
                    top.Dialog.alert(_json.errorInfo);
                }
            }
        });
    }



    //删除
    function doDel_grid(_id){

        if(_id == ""){
            _id = "0";
        }

        var _data = "op=delete&ids="+_id+"&accountId="+accountId+"&numberCode="+numberCode+"&mainId="+mainId;

        top.Dialog.confirm("<%=SystemEnv.getHtmlLabelName(15097,user.getLanguage())%>",
            function(){
                openNewDiv_FnaBudgetViewInner1(_Label33574);
                jQuery.ajax({
                    url : "/fna/mulDimensions/budgetDimension/budgetDimensionMembe/BudgetDimensionMembeOp.jsp",
                    type : "post",
                    cache : false,
                    processData : false,
                    data : _data,
                    dataType : "json",
                    success: function do4Success(_json){
                        try{closeNewDiv_FnaBudgetViewInner1();}catch(ex1){}
                        if(_json.status == 1){
                            window._table.reLoad();
                        }else{
                            top.Dialog.alert(_json.errorInfo);
                        }
                    }
                });
            }, function(){}
        );
    }

    //批量删除
    function batchDel(){

        var ids = _xtable_CheckedCheckboxId();
        if(ids==""){
            top.Dialog.alert("<%=SystemEnv.getHtmlLabelName(18214,user.getLanguage())+SystemEnv.getHtmlLabelName(387641,user.getLanguage()) %>");
            return;
        }
        var _data = "op=batchDel&ids="+ids+"&accountId="+accountId+"&numberCode="+numberCode+"&mainId="+mainId;

        top.Dialog.confirm("<%=SystemEnv.getHtmlLabelName(15097,user.getLanguage())%>",
            function(){
                openNewDiv_FnaBudgetViewInner1(_Label33574);
                jQuery.ajax({
                    url : "/fna/mulDimensions/budgetDimension/budgetDimensionMembe/BudgetDimensionMembeOp.jsp",
                    type : "post",
                    cache : false,
                    processData : false,
                    data : _data,
                    dataType : "json",
                    success: function do4Success(_json){
                        try{closeNewDiv_FnaBudgetViewInner1();}catch(ex1){}
                        if(_json.status == 1){
                            window._table.reLoad();
                        }else{
                            top.Dialog.alert(_json.errorInfo);
                        }

                    }
                });
            }, function(){}
        );
    }

    function OpenNewWindow(sURL,w,h){
        var iWidth = 0 ;
        var iHeight = 0 ;
        iWidth=(window.screen.availWidth-10)*w;
        iHeight=(window.screen.availHeight-50)*h;
        ileft=(window.screen.availWidth - iWidth)/2;
        itop= (window.screen.availHeight - iHeight + 50)/2;
        var szFeatures = "" ;
        szFeatures =  "resizable=no,status=no,menubar=no,width=" + iWidth + ",height=" + iHeight*h + ",top="+itop+",left="+ileft
        window.open(sURL,"",szFeatures)
    }


</script>

</body>
</html>