ConstructionCost/web/rationLibEditor/js/dinge.js

/**
 * Created by Syusuke on 2017/3/17.
 */
var rationLibName = getQueryString("rationname");//获取定额库参数
function getQueryString(key){
    var reg = new RegExp("(^|&)"+key+"=([^&]*)(&|$)");
    var result = window.location.search.substr(1).match(reg);
    return result?decodeURIComponent(result[2]):null;
}
//----------------------------------------------------页面初始化
var properties = {};//综合属性
properties.sectionSelected = "";//选择的章节
properties.rationSelected = "";//选择的定额
function getRealLib(){
    $.ajax({
        type:"POST",
        url:"http://localhost:6060/rationLibEditor/getRealLibName",
        data:{"rationName":rationLibName},
        async:false,
        dataType:"json",
        cache:false,
        timeout:1000,
        success:function(result){
            properties.realLibName = result.data[0].DBName
        },
        error:function(){}
    })
}
$(document).ready(function(){
    getRealLib();
    getRationTree();
    mkRationItemSpread();
});
//---------------------------------------------------初始化章节树界面
function  getRationTree(){
    $.ajax({
        type:"POST",
        url:"http://localhost:6060/rationLibEditor/getRationTree",
        data:{"rationLibName": properties.realLibName},
        dataType:"json",
        cache:false,
        timeout:500000,
        success:function(result,textStatus,status){
            if(status.status == 200) createRationTree(result.data);//根据返回的全部定额章节对象，构架树。
            else{
                treeObj = $.fn.zTree.init($("#treeDemo"), setting, zNodes);
                saveTempTree();
            }
        },
        error:function(){
            alert("caonima")
        }
    })
}
//根据返回的节点集合构建树节点
function createRationTree(obj){
    var treeArr;
    treeArr = makeNodes(obj);
    var  maxIDNode = obj.reduce(function(a,b){
        return (a.id> b.id)?a:b;
    });
    newCount = maxIDNode.id;
    treeObj = $.fn.zTree.init($("#treeDemo"), setting, treeArr);
}
function makeNodes(obj){
    var arr=[];
    arr = obj.filter(function(x){
        return x.ParentID==0
    })
    arr.forEach(function(x){
        x.id = x.SectionID;
        x.pId = x.ParentID;
        x.nId = x.NextSiblingID;
        x.name = x.Name;
        x.isParent = true
        x.lev = 0
    });
    arr  =  sortArray(arr);
    for(var i=0;i<arr.length;i++){
        var L1 = [];
        L1 = obj.filter(function(x){
            return x.ParentID ==arr[i].id;
        });
        L1.forEach(function(x){
            x.id = x.SectionID;
            x.pId = x.ParentID;
            x.nId = x.NextSiblingID;
            x.name = x.Name;
            x.isParent = true
            x.lev = 1
        });
        L1=sortArray(L1);
        for(var j=0; j<L1.length;j++){
            var L2 = [];
            L2 =obj.filter(function(x){
                return x.ParentID == L1[j].id;
            })
            L2.forEach(function(x){
                x.id = x.SectionID;
                x.pId = x.ParentID;
                x.nId = x.NextSiblingID;
                x.name = x.Name;
                x.isParent = false;
                x.lev = 2
            })
            L2=sortArray(L2)
            L1[j].children = L2;
        }
        arr[i].children = L1;
    }
    return arr;
}
function sortArray(arr){
    var a = [];
    for(var i=0;i<arr.length;i++)
        if (arr[i].NextSiblingID == -1)
            a.push(arr[i])
    for(; a.length < arr.length;){
        for(var j=0;j<arr.length;j++) {
            if (arr[j].NextSiblingID == a[0].SectionID)
            {a.unshift(arr[j]); break;}
        }
    }
    return a ;
}
//新建的定额库保存模板节点
function saveTempTree(){
    var N = []
    for(i=0;i<zNodes.length;i++){
        var node ={}
        node.SectionID = zNodes[i].id;
        node.ParentID = zNodes[i].pId;

        node.NextSiblingID = zNodes[i].nId;
        node.Name =zNodes[i].name;
        N.push(node);
    }
    var rationTempTree = JSON.stringify(N)
    $.ajax({
        type:"POST",
        url:"http://localhost:6060/rationLibEditor/saveTempRationTree",
        data:{"rationName":rationLibName,"rationTempTree":rationTempTree},
        dataType:"json",
        cache:false,
        timeout:1000,
        success:function(result){

        },
        error:function(){

        }
    })
}
//--------------------------------------------------------树处理事件
var newCount = 13;
//新增树节点
function addHoverDom(treeId, treeNode) {
    var sObj = $("#" + treeNode.tId + "_span");
    if (treeNode.editNameFlag || $("#addBtn_"+treeNode.tId).length>0||(treeNode.level==2)) return;
    var addStr = "<span class='button add' id='addBtn_" + treeNode.tId
        + "' title='add node' onfocus='this.blur();'></span>";
    sObj.after(addStr);
    var btn = $("#addBtn_"+treeNode.tId);
    if (btn) btn.bind("click", function(){
        var zTree = $.fn.zTree.getZTreeObj("treeDemo");
        if((treeNode.level==0)){
            var newNode = zTree.addNodes(treeNode, {id:(++newCount), pId:treeNode.id,nId:-1,isParent:true, name:"请输入章节名称",children:[]});

        }
        else{
            var newNode = zTree.addNodes(treeNode, {id:(++newCount), pId:treeNode.id,nId:-1,isParent:false, name:"请输入章节名称"});

        }
        saveNewSection(newNode[0]);
        var pnode = newNode[0].getPreNode()
        if(pnode){
            pnode.nId = newNode[0].id;
            saveNewSection(pnode);
        }
        return false;
    });
};
//保存新增的节点
function saveNewSection(n){
    var sec={};
    sec.SectionID = n.id;
    sec.ParentID = n.pId;
    sec.NextSiblingID = n.nId;
    sec.Name = n.name;
    var section = JSON.stringify(sec);
    $.ajax({
        type:"POST",
        url:"http://localhost:6060/rationLibEditor/addSection",
        data:{"rationLibName":properties.realLibName,"rationSection":section},
        dataType:"json",
        cache:false,
        timeout:1000,
        success:function(result){
        },
        error:function(){
        }
    })
}
//编辑树节点事件（添加节点到数据库）
function onRename(e, treeId, treeNode, isCancel) {
    saveNewSection(treeNode);
}
function onRemove(e, treeId, treeNode) {
    var id = treeNode.id;
    var pNodes = treeNode.getParentNode().children;
    for(var i=0;i<pNodes.length;i++){
        if(pNodes[i].nId==id){
            pNodes[i].nId = -1;
            saveNewSection(pNodes[i]);
        }
    }
    $.ajax({
        type:"POST",
        url:"http://localhost:6060/rationLibEditor/deleteSection",
        data:{"rationLibName":properties.realLibName,"sectionID": treeNode.id},
        dataType:"json",
        cache:false,
        timeout:1000,
        success:function(result){
            //if(result){
            //    caseDeleteTreeNode(result.data)
            //}
        },
        error:function(){
        }
    })
    removeSection(id)
    $("#rationTbody").html("");
    $("#rationGLJTbody").html("");
}
//--------------------------------------------------------定额spreadjs
var spSetting_ration = {
    spType:"Ration",
    view:{
        comboBox:[
            {row:-1,col:2,rowCount:-1,colCount:1}
        ],
        lockedCells:[
            {row:-1,col:3,rowCount:-1, colCount:1}
        ]
    }
};
var spSetting_rationGLJ = {
    spType:"RationGLJ",
    view:{
        comboBox:[],
        lockedCells:[
            {row:-1,col:1,rowCount:-1, colCount:1},
            {row:-1,col:2,rowCount:-1, colCount:1},
            {row:-1,col:3,rowCount:-1, colCount:1},
            {row:-1,col:5,rowCount:-1, colCount:1},
            {row:-1,col:6,rowCount:-1, colCount:1}
        ]
    }
};
var ration_header = [
    {headerName:"编码",headerWidth:120},
    {headerName:"名称",headerWidth:400},
    {headerName:"单位",headerWidth:120},
    {headerName:"基价",headerWidth:120},
    {headerName:"显示名称（以%s表示参数）",headerWidth:450},
    {headerName:"取费专业",headerWidth:120}
]
var rationGLJ_header = [
    {headerName:"编码",headerWidth:160},
    {headerName:"名称",headerWidth:400},
    {headerName:"单位",headerWidth:160},
    {headerName:"单位基价",headerWidth:160},
    {headerName:"定额消耗",headerWidth:160},
    {headerName:"类型",headerWidth:160},
    {headerName:"操作",headerWidth:130}
]
function editRationStarting(spread_setting,args){
    properties.rationSelected = args.editingText;
}
function editRationEnding(spread,spread_setting,args){
    if(spread_setting.event.remove)
        Remove(spread_setting,args);
    else{
        var ActiveSheet = spread.getActiveSheet();
        var rationItem = {}
     // rationItem.RationCode = ActiveSheet.getValue(args.row,0);
        rationItem.RationCode = args.editingText;
        rationItem.RationName = ActiveSheet.getValue(args.row,1);
        rationItem.Unit = ActiveSheet.getValue(args.row,2);
        rationItem.BasePrice = Number(ActiveSheet.getValue(args.row,3));
        if(properties.sectionSelected = "")
        {
            alert("请选择章节点")
            return;
        }
        else
        rationItem.SectionID = properties.sectionSelected;
        rationItem.ContentID = 0;
        rationItem.Caption = ActiveSheet.getValue(args.row,4);
        rationItem.FeeType = Number(ActiveSheet.getValue(args.row,5))
        upsert(spread_setting,rationItem);
    }
}
//通用remove
function Remove(spread_setting,args){
    AjaxRemove(spread_setting);
}
//通用upsert
function upsert(spread_setting,data){
    AjaxUpsert(spread_setting,data)
}
function AjaxRemove(spread_setting){
    var pro = JSON.stringify(properties);
    $.ajax({
        type:"POST",
        url:"http://localhost:6060/rationLibEditor/remove"+spread_setting.name,
        data:{"setting":spread_setting,"properties":pro},
        dataType:"json",
        cache:false,
        timeout:1000,
        success:function(result){
            spread_setting.event.remove = false;
        },
        error:function(){}
    })
}
function AjaxUpsert(spread_setting,data){
    var pro = JSON.stringify(spread_setting.properties);
    var dataStr = JSON.stringify(data);
    $.ajax({
        type:"POST",
        url:"http://localhost:6060/rationLibEditor/upsert"+spread_setting.name,
        data:{"properties":pro,"data":dataStr},
        dataType:"json",
        cache:false,
        timeout:1000,
        success:function(result){
            spread_setting.event.upsert = false;
        },
        error:function(){}
    })
}
function mkRationItemSpread(){
    var rationSpread =  $.fn.Spread.init($("#rationItemsSheet"),spSetting_ration,ration_header);
    var rationGLJSpread =  $.fn.Spread.init($("#rationGLJSheet"),spSetting_rationGLJ,rationGLJ_header);
}