| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494 |
- <%@ 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="viewport" content="width=device-width, initial-scale=1.0" />
- <style>
- .function_left {
- flex:1;
- border:1px solid #cccccc;
- padding:5px;
- margin-right:10px;
- margin-top:10px;
- }
- .function_right {
- flex:1
- }
- .unSignItem {
- width:100px;
- height:20px;
- display: inline-block;
- font-size:20px;
- text-align: center;
- padding:2px;
- cursor:pointer;
- border:2px solid gray;
- border-radius:20px;
- }
- .signItem {
- font-size:20px;
- text-align: center;
- }
- .itemSelected{
- border:2px solid green;
- border-radius:20px;
- }
- .table-bordered td {
- border-bottom: 1px solid #cbcbcb;
- padding-top:5px;
- padding-bottom:5px;
- }
- .table-bordered tbody>tr:last-child>td {
- border-bottom-width: 0;
- }
- .formtable tr {
- height:45px;
- }
- </style>
- </head>
- <body style="width:99%">
- <input id="id" name="id" type="hidden" value="${entity.id }"/>
- <div>
- <a href="javascript:void(0)" class="easyui-linkbutton" plain="true" onclick="sign('+')"> + </a>
- <a href="javascript:void(0)" class="easyui-linkbutton" plain="true" onclick="sign('-')"> - </a>
- <a href="javascript:void(0)" class="easyui-linkbutton" plain="true" onclick="sign('*')"> * </a>
- <a href="javascript:void(0)" class="easyui-linkbutton" plain="true" onclick="sign('/')"> / </a>
- </div>
- <div style="width:100%;display: flex;">
- <fieldset class="function_left">
- <legend>公式内容</legend>
- <div id="function_txt">
- </div>
- </fieldset>
- <div class="function_right">
- <table cellpadding="0" cellspacing="1" class="formtable">
- <%--<tr>
- <td>维度</td>
- <td>选值</td>
- </tr>--%>
- <tr >
- <td align="right"><label class="Validform_label">公式名称:</label></td>
- <td class="value">
- <input id="name" name="name" type="text" style="width: 150px" class="inputxt" placeholder="请输入公式名称"/>
- </td>
- </tr>
- <tr>
- <td align="right">样表:</td>
- <td class="value">
- <input id="tempSheetId" name="tempSheetId" type="hidden"/>
- <input id="tempSheetName" name="tempSheetName" type="text" style="width: 150px" readonly="readonly" class="inputxt" placeholder="请选择预算样表"/>
- <a href="javascript:void(0)" class="easyui-linkbutton" plain="true" icon="icon-select" onclick="openTempSheet()">选择</a>
- </td>
- </tr>
- <tr>
- <td align="right">预算主体:</td>
- <td class="value">
- <input id="entityId" name="entityId" type="hidden"/>
- <input id="entityName" name="entityName" type="text" style="width: 150px" readonly="readonly" class="inputxt" placeholder="请选择预算主体"/>
- <a href="javascript:void(0)" class="easyui-linkbutton" plain="true" icon="icon-select" onclick="openEntity('select')">选择</a>
- <a href="javascript:void(0)" class="easyui-linkbutton" plain="true" icon="icon-select" onclick="openEntity('current','当前主体')">当前主体</a>
- <a href="javascript:void(0)" class="easyui-linkbutton" plain="true" icon="icon-select" onclick="openEntity('all','所有主体')">所有主体</a>
- </td>
- </tr>
- <tr>
- <td align="right">指标维度:</td>
- <td class="value">
- <input id="measureId" name="measureId" type="hidden"/>
- <input id="measureName" name="measureName" type="text" style="width: 150px" readonly="readonly" class="inputxt" placeholder="请选择指标维度"/>
- <a href="javascript:void(0)" class="easyui-linkbutton" plain="true" icon="icon-select" onclick="openMeasure('select')">选择</a>
- <a href="javascript:void(0)" class="easyui-linkbutton" plain="true" icon="icon-select" onclick="openMeasure('current','当前指标')">当前指标</a>
- </td>
- </tr>
- <tr>
- <td align="right">时间维度:</td>
- <td class="value">
- <input id="periodId" name="periodId" type="hidden"/>
- <input id="periodName" name="periodName" type="text" style="width: 150px" readonly="readonly" class="inputxt" placeholder="请选择时间维度"/>
- <a href="javascript:void(0)" class="easyui-linkbutton" plain="true" icon="icon-select" onclick="openPeriodDetail('select')">选择</a>
- <a href="javascript:void(0)" class="easyui-linkbutton" plain="true" icon="icon-select" onclick="openPeriodDetail('current','当前时间')">当前时间</a>
- <a href="javascript:void(0)" class="easyui-linkbutton" plain="true" icon="icon-select" onclick="openPeriodDetail('all','全年')">全年</a>
- </td>
- </tr>
- <tr>
- <td align="right">含税维度:</td>
- <td class="value">
- <input type="radio" name="includeTax" value="1" checked="checked">含税
- <input type="radio" name="includeTax" value="0">不含税
- </td>
- </tr>
- <tr>
- <td align="right">预实维度:</td>
- <td class="value">
- <input type="radio" name="expect" value="1" checked="checked">预算数
- <input type="radio" name="expect" value="0">实际数
- </td>
- </tr>
- </table>
- <table class="table-bordered">
- <tr>
- <td>
- <a href="javascript:void(0)" class="easyui-linkbutton" plain="true" icon="icon-add" operationCode="add" onclick="addDetail()" id="addDetailButton">增加</a>
- <a href="javascript:void(0)" class="easyui-linkbutton" plain="true" icon="icon-save" onclick="updateDetail()" id="updateDetailButton" style="display:none">保存</a>
- <a href="javascript:void(0)" class="easyui-linkbutton" plain="true" icon="icon-remove" operationCode="remove" onclick="delDetail()" id="delDetailButton" style="display:none">删除</a>
- <a href="javascript:void(0)" class="easyui-linkbutton" plain="true" icon="icon-select" onclick="selectOtherDetail()" >选择已有公式</a>
- </td>
- </tr>
- </table>
- </div>
- </div>
- <script>
- var signFlag = true;
- var dialog;
- function openTempSheet() {
- var url ='budgetTempSheetController.do?select';
- _select(url, '选择样表', function (selectedRows) {
- var one = selectedRows[0];
- var id = one.id;
- var name = one.name;
- $('#tempSheetId').val(id);
- $('#tempSheetName').val(name);
- clear(false);
- }, '800px', '600px')
- }
- function addDetail(update){
- if(signFlag||update){
- var name=$('#name').val();
- if(!name) {
- _alert('请输入公式名称');
- return;
- }
- var tempSheetId=$('#tempSheetId').val();
- if(!tempSheetId){
- _alert('请选择样表');
- return;
- }
- var entityId=$('#entityId').val();
- if(!entityId){
- _alert('请选择预算主体');
- return;
- }
- var measureId=$('#measureId').val();
- if(!measureId){
- _alert('请选择指标维度');
- return;
- }
- var periodId=$('#periodId').val();
- if(!periodId){
- _alert('请选择时间维度');
- return;
- }
- var params={};
- params.fkId=$("#id").val();
- params.name=name;
- params.tempSheetId=tempSheetId;
- params.tempSheetName=$("#tempSheetName").val();
- params.entityId=entityId;
- params.entityName=$("#entityName").val();
- params.measureId=measureId;
- params.measureName=$('#measureName').val();
- params.periodId=$('#periodId').val();
- params.periodName=$('#periodName').val();
- params.includeTax=$('input[name="includeTax"]:checked').val();
- params.expect=$('input[name="expect"]:checked').val();
- params.type='tempsheet';
- if(currentClickItem){
- params.id=currentClickItem.attr('id');
- }
- $.ajax({
- url: 'budgetDimFunctionDetailController.do?doAdd'
- ,data:params
- ,dataType:'json'
- ,type:'POST'
- ,async:false
- ,success:function (d) {
- if(currentClickItem){
- tip('保存成功')
- currentClickItem.html(name);
- }else{
- var item=$('<span></span>');
- item.html(name);
- item.attr('id',d.obj);
- item.attr('sign',false);
- item.attr('class','unSignItem');
- item.attr('onclick','itemClick(this)');
- $('#function_txt').append(item);
- clear(true);
- signFlag =false;
- }
- }
- });
- }
- }
- function sign(s){
- var last=$('#function_txt').children(':last');
- if(last.length==0) return;
- if(last.attr('sign')=='false'){
- var obj = $('<span></span>');
- obj.attr('sign',true);
- obj.attr('class','signItem');
- obj.html(s);
- $('#function_txt').append(obj);
- }else{
- last.html(s);
- }
- signFlag=true;
- }
- function updateDetail(){
- addDetail(true);
- }
- function getDimFunctionInfo(){
- var obj = {};
- obj.functionId = $('#id').val();
- obj.functionTxt=$('#function_txt').text();
- obj.functionType='tempsheet';
- return obj;
- }
- function makeInfo(d) {
- var info =d.attributes;
- var budgetDemoDep = info.budgetDemoDep;
- for(var i=0;i<budgetDemoDep.length;i++){
- console.log(budgetDemoDep[i])
- }
- }
- function saveFunction(){
- var url = "budgetDimFunctionController.do?doUpdate";
- var params={};
- params.id=$('#id').val();
- var functionTxt = $('#function_txt');
- params.expressionTxt=functionTxt.html().trim();
- var children = functionTxt.children();
- var exp="";
- for(var i=0;i<children.length;i++){
- var child = $(children[i]);
- var sign = child.attr('sign');
- if(sign=='true'){
- exp+=child.html();
- }else {
- exp+=child.attr('id');
- }
- }
- params.expression =exp;
- $.post(url,params,function(){});
- }
- function openEntity(selectType,selectName) {
- var tempSheetId=$('#tempSheetId').val();
- if(!tempSheetId){
- _alert('请先选择样表');
- return;
- }
- if(selectType=='select'){
- var url ='budgetEntityController.do?selectByTempSheet&tempSheetId='+tempSheetId;
- dialog=_select(url, '选择预算主体', function (selectedRows) {
- var one = selectedRows[0];
- var id = one.id;
- var entityName = one.entityName;
- $('#entityId').val(id);
- $('#entityName').val(entityName);
- }, '800px', '600px');
- }else {
- $('#entityId').val(selectType);
- $('#entityName').val(selectName);
- }
- }
- function openMeasure(selectType,selectName) {
- var tempSheetId=$('#tempSheetId').val();
- if(!tempSheetId){
- _alert('请先选择样表');
- return;
- }
- if(selectType=='select') {
- var url = 'budgetMeasureController.do?selectByTempSheet&tempSheetId=' + tempSheetId;
- dialog = _select(url, '选择指标维度', function (selectedRows) {
- var one = selectedRows[0];
- var id = one.id;
- var name = one.name;
- $('#measureId').val(id);
- $('#measureName').val(name);
- }, '800px', '600px')
- }else {
- $('#measureId').val(selectType);
- $('#measureName').val(selectName);
- }
- }
- function openPeriodDetail(selectType,selectName){
- var tempSheetId=$('#tempSheetId').val();
- if(!tempSheetId){
- _alert('请先选择样表');
- return;
- }
- if(selectType=='select') {
- var url ='budgetPeriodDetailController.do?selectByTempSheet&tempSheetId='+tempSheetId;
- _select(url, '选择时间维度', function (selectedRows) {
- var ids = new Array();
- var names=new Array();
- for(var i=0;i<selectedRows.length;i++){
- var one = selectedRows[i];
- var id = one.id;
- var name = one.name;
- ids.push(id);
- names.push(name);
- }
- $('#periodId').val(ids.join(','));
- $('#periodName').val(names.join(','));
- }, '800px', '600px')
- }else {
- $('#periodId').val(selectType);
- $('#periodName').val(selectName);
- }
- }
- $(function(){
- init();
- })
- function init() {
- $('#function_txt').html('${entity.expressionTxt}');
- $('#function_txt').find('span').each(function () {
- var t=$(this);
- if(t.attr('isSelect')=='true'){
- itemClick(t);
- }
- })
- resetSignFlag();
- $(document).keyup(function(e){
- if(e.keyCode == 46) {
- delDetail();
- }
- });
- }
- function clear(includeDemo){
- if(includeDemo) {
- $('#name').val('');
- $('#tempSheetId').val('');
- $("#tempSheetName").val('');
- }
- $('#entityId').val('');
- $("#entityName").val('');
- $('#measureId').val('');
- $('#measureName').val('');
- $('#periodId').val('');
- $('#periodName').val('');
- }
- var currentClickItem;
- function itemClick(obj){
- var t=$(obj);
- if(t.attr('isSelect')=='true'){
- clear(true);
- t.attr('isSelect',false);
- t.removeClass('itemSelected');
- $('#addDetailButton').show();
- $('#updateDetailButton').hide();
- $('#delDetailButton').hide();
- currentClickItem = null;
- }else {
- t.parent().children().each(function(){
- $(this).removeClass('itemSelected');
- $(this).attr('isSelect',false);
- });
- t.addClass('itemSelected');
- t.attr('isSelect',true);
- if(t.attr('sign')=='false'){
- var id = t.attr('id');
- var url='budgetDimFunctionDetailController/'+id+'.do';
- $.get(url,{},function(d){
- $('#name').val(d.name);
- $('#tempSheetId').val(d.tempSheetId);
- $("#tempSheetName").val(d.tempSheetName);
- $('#entityId').val(d.entityId);
- $("#entityName").val(d.entityName);
- $('#measureId').val(d.measureId);
- $('#measureName').val(d.measureName);
- $('#periodId').val(d.periodId);
- $('#periodName').val(d.periodName);
- $('input[name="includeTax"][value="'+d.includeTax+'"]').attr("checked","checked");
- $('input[name="expect"][value="'+d.expect+'"]').attr("checked","checked");
- $('#addDetailButton').hide();
- $('#updateDetailButton').show();
- $('#delDetailButton').show();
- currentClickItem = t;
- },'json');
- }
- }
- }
- function delDetail() {
- if(currentClickItem!=null) {
- var next = currentClickItem.next();
- if(next.length>0) next.remove();
- currentClickItem.remove();
- clear(true);
- resetSignFlag();
- currentClickItem=null;
- $('#addDetailButton').show();
- $('#updateDetailButton').hide();
- $('#delDetailButton').hide();
- }
- }
- function resetSignFlag(){
- var last=$('#function_txt').children(':last');
- if(last.length!=0) {
- signFlag = last.attr('sign')=='true';
- }else {
- signFlag = true;
- }
- }
- function setMacro(item,k,v) {
- if(item=='dep'){
- $('#entityId').val(k);
- $('#entityName').val(v);
- }else if(item=='measure'){
- $('#measureId').val(k);
- $('#measureName').val(v);
- }
- dialog.close();
- }
- function selectOtherDetail(){
- var url ='budgetDimFunctionDetailController.do?select';
- _openDialog(url,'选择公式',function(iframe){
- var selectedRows = iframe.getSelectRows();
- if(selectedRows.length==0){
- iframe.tip('请至少选择一项');
- return false;
- }
- var one = selectedRows[0];
- $('#name').val(one.name);
- $('#tempSheetId').val(one.tempSheetId);
- $('#tempSheetName').val(one.tempSheetName);
- $('#entityId').val(one.entityId);
- $('#entityName').val(one.entityName);
- $('#measureId').val(one.measureId);
- $('#measureName').val(one.measureName);
- $('#periodId').val(one.periodId);
- $('#periodName').val(one.periodName);
- // $('#includeTax').val(one.includeTax);
- // $('#expect').val(one.expect);
- $('input[name="includeTax"]').removeAttr("checked");
- $('input[name="expect"]').removeAttr("checked");
- $('input[name="includeTax"][value="'+one.includeTax+'"]').attr("checked","checked");
- $('input[name="expect"][value="'+one.expect+'"]').attr("checked","checked");
- });
- }
- </script>
- <script src="webpage/cn/com/lzt/budget/data/js/budget_tools.js" type="text/javascript"></script>
- </body>
- </html>
|