skyversation
/
meidu2021


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270
							<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@include file="/context/mytags.jsp"%>
<!doctype html>
<html>
<head>
    <t:base type="jquery,easyui,tools,DatePicker"></t:base>
    <meta charset="utf-8" />
    <meta name="spreadjs culture" content="zh-cn" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <style>
        .sample-spreadsheets {
            width: calc(100% - 350px);
            height: 100%;
            overflow: hidden;
            float: left;
        }
        .options-container{
            float: right;
            width: 350px;
            padding: 12px;
            height: 100%;
            box-sizing: border-box;
            background: #fbfbfb;
            overflow: auto;
        }
        .option-row {
            font-size: 14px;
            padding: 5px;
            margin-top: 10px;
        }
    </style>
    <script>
        <c:if test="${periodEntity==null}">
        alert('${tempSheet.periodYear}年未设置预算周期，请联系管理员');
        history.go(-1);
        </c:if>
    </script>
</head>
<body style="background:#FFFFFF">
<!-- <form id="form1" runat="server"> -->
<div>
    <div id="div2">
        <%@include file="budgetTempSheet-buttons.jsp"%>
    </div>

    <div class="sample-tutorial" style="top: 20px;width:calc(100vw - 80px); height: calc(100vh - 120px);">
        <div id="ss" class="sample-spreadsheets" ></div>
        <div class="options-container">
            <div class="option-row" style="text-align:center">
                ${tempSheet.name}
            </div>
            <div class="option-row" id="rowInfo" style="display:none">
                <fieldset style="border:1px solid #666666;padding:5px">
                    <legend>行维度</legend>
                    <table>
                        <tr>
                            <td>预算主体：</td>
                            <td>
                                <input type="text" id="rowEntityInput" style="width: 150px;" readonly="readonly">
                            </td>
                            <td>
                                <a  href="#" class="easyui-linkbutton l-btn"  iconcls="icon-synchronization" id="rowEntityBind" onclick="setEntityRow()">
                                    绑定
                                </a>
                            </td>
                        </tr>
                        <tr>
                            <td>时间维度：</td>
                            <td>
                                <input type="text" id="rowTimeInput" style="width: 150px;" readonly="readonly">
                            </td>
                            <td>
                                <a  href="#" class="easyui-linkbutton l-btn"  iconcls="icon-synchronization" id="rowTimeBind" onclick="setTimeRow()">
                                    绑定
                                </a>
                            </td>
                        </tr>
                        <tr>
                            <td>指标维度：</td>
                            <td><input type="text" id="rowGoalsInput" style="width: 150px;" readonly="readonly"></td>
                            <td>
                                <a  href="#" class="easyui-linkbutton l-btn"  iconcls="icon-synchronization" id="rowGoalsBind" onclick="setMeasureRow()">
                                    绑定
                                </a>
                            </td>
                        </tr>
                        <tr>
                            <td>含税维度：</td>
                            <td>
                                <input type="radio" name="includeTaxRow" value="1" onclick="setIncludeTaxRow()">含税
                                <input type="radio" name="includeTaxRow" value="0" onclick="setIncludeTaxRow()">不含税
                            </td>
                        </tr>
                        <tr>
                            <td>预实维度：</td>
                            <td>
                                <input type="radio" name="expectRow" value="1" onclick="setExpectRow()">预算数
                                <input type="radio" name="expectRow" value="0" onclick="setExpectRow()">实际数
                            </td>
                        </tr>
                        <tr>
                            <td colspan="3" align="center">
                                <a  href="#" class="easyui-linkbutton l-btn"  iconcls="icon-remove"  onclick="removeRowBind()">
                                    清空行维度
                                </a>
                            </td>
                        </tr>
                    </table>
                </fieldset>
            </div>
            <div class="option-row" id="colInfo" style="display:none">
                <fieldset style="border:1px solid #666666;padding:5px">
                    <legend>列维度</legend>
                    <table>
                        <tr>
                            <td>预算主体：</td>
                            <td>
                                <input type="text" id="colEntityInput" style="width: 150px;" readonly="readonly">
                            </td>
                            <td>
                                <a  href="#" class="easyui-linkbutton l-btn"  iconcls="icon-synchronization" id="colEntityBind" onclick="setEntityCol()">
                                    绑定
                                </a>
                            </td>
                        </tr>
                        <tr>
                            <td>时间维度：</td>
                            <td>
                                <input type="text" id="colTimeInput" style="width: 150px;" readonly="readonly">
                            </td>
                            <td>
                                <a  href="#" class="easyui-linkbutton l-btn"  iconcls="icon-synchronization" id="colTimeBind" onclick="setTimeCol()">
                                    绑定
                                </a>
                            </td>
                        </tr>
                        <tr>
                            <td>指标维度：</td>
                            <td><input type="text" id="colGoalsInput" style="width: 150px;" readonly="readonly"></td>
                            <td>
                                <a  href="#" class="easyui-linkbutton l-btn"  iconcls="icon-synchronization" id="colGoalsBind" onclick="setMeasureCol()">
                                    绑定
                                </a>
                            </td>
                        </tr>
                        <tr>
                            <td>含税维度：</td>
                            <td>
                                <input type="radio" name="includeTaxCol" value="1" onclick="setIncludeTaxCol()">含税
                                <input type="radio" name="includeTaxCol" value="0" onclick="setIncludeTaxCol()">不含税
                            </td>
                        </tr>
                        <tr>
                            <td>预实维度：</td>
                            <td>
                                <input type="radio" name="expectCol" value="1" onclick="setExpectCol()">预算数
                                <input type="radio" name="expectCol" value="0" onclick="setExpectCol()">实际数
                            </td>
                        </tr>
                        <tr>
                            <td colspan="3" align="center">
                                <a  href="#" class="easyui-linkbutton l-btn"  iconcls="icon-remove"  onclick="removeColBind()">
                                    清空列维度
                                </a>
                            </td>
                        </tr>
                    </table>
                </fieldset>
            </div>
            <div class="option-row" id="info2" style="display:none">
                <fieldset style="border:1px solid #666666;padding:5px">
                    <legend>单元格维度</legend>
                    <table>
                        <tr>
                            <td>预算主体：</td>
                            <td>
                                <input type="text" id="entityInput" style="width: 150px;" readonly="readonly">
                            </td>
                        </tr>
                        <tr>
                            <td>时间维度：</td>
                            <td>
                                <input type="text" id="timeInput" style="width: 150px;" readonly="readonly">
                            </td>
                        </tr>
                        <tr>
                            <td>指标维度：</td>
                            <td><input type="text" id="goalsInput" style="width: 150px;" readonly="readonly"></td>
                        </tr>
                        <tr>
                            <td>含税维度：</td>
                            <td>
                                <input type="radio" name="includeTax" value="1" disabled="disabled">含税
                                <input type="radio" name="includeTax" value="0" disabled="disabled">不含税
                            </td>
                        </tr>
                        <tr>
                            <td>预实维度：</td>
                            <td>
                                <input type="radio" name="expect" value="1" disabled="disabled">预算数
                                <input type="radio" name="expect" value="0" disabled="disabled">实际数
                            </td>
                        </tr>
                    </table>
                </fieldset>
            </div>
            <div class="option-row" id="info3" style="display: none;">
                <fieldset style="border:1px solid #666666;padding:5px">
                    <legend>单元格属性</legend>
                    <div>只读:<span id="readOnly"></span></div>
                    <div>数据类型:<span id="goalsDataType"></span></div>
                    <div style="display: none;" id="controlFlagName">预算控制:<span></span></div>
                    <div style="display: none;" id="showFuntionTxt">维度公式:<span></span></div>
                </fieldset>
            </div>
        </div>
        <!--  <div  id="detail" class="options-container"> -->
        <!-- <div class="option-row">
            操作<br/>
            <div class="option-row">
                <input id="addBackgroundColorMenuSelection" type="checkbox" />
                <label for="addBackgroundColorMenuSelection">Add background color menu selection</label>
            </div>
        </div> -->
    </div>
</div>
<script>
    var periodDetailList = [];
    <c:forEach items="${periodDetailList}" var="detail" varStatus="i">
    var detail${i.index} = {};
    detail${i.index}.id = '${detail.id}';
    detail${i.index}.name = '${detail.name}';
    periodDetailList.push(detail${i.index});
    </c:forEach>

    var measureDataTypeList={};
    <c:forEach items="${measureDataTypeList}" var="type" varStatus="i">
    measureDataTypeList['${type.typecode}'] ='${type.typename}';
    </c:forEach>

    var entityList =[];
    <c:forEach items="${entityList}" var="entity" varStatus="i">
    entityList.push({id:'${entity.id}',name:'${entity.entityName}'});
    </c:forEach>
    var actualStaKind='${tempSheet.actualStaKind}';

    function addEntity(){
        var sheet = spread.getActiveSheet();
        var sheetTag = sheet.tag();
        var ids ='';
        if(sheetTag && sheetTag.ids){
            ids =sheetTag.ids.join(',');
        }
        _openDialog('budgetEntityController.do?select&excludeIds='+ids,'选择预算主体',function(iframe){
            var selectRows = iframe.getSelectRows();
            spread.suspendPaint();
            for(var i=0;i<selectRows.length;i++){
                var one=selectRows[i];
                var oneObj = {id:one.id,name:one.entityName};
                addOne(oneObj);
            }
            spread.resumePaint();
        },'800px','600px');
    }
</script>
<script src="webpage/cn/com/lzt/budget/tempsheet/budgetTempSheet-leader.js" type="text/javascript"></script>
<script src="webpage/cn/com/lzt/budget/tempsheet/js/actual_sta_branch.js" type="text/javascript"></script>
<script src="webpage/cn/com/lzt/budget/tempsheet/js/actual_sta_main.js" type="text/javascript"></script>
</body>
</html>