YangHuCost/web/building_saas/main/js/views/locate_view.js

/**
 * Created by zhang on 2018/11/16.
 */
let locateObject={
    bills_setting:{
        header:[
            {headerName: "编码", headerWidth: 120, dataCode: "code", dataType: "String"},
            {headerName: "项目名称", headerWidth: 100, dataCode: "name", dataType: "String"},
            {headerName: "单位", headerWidth: 50, dataCode: "unit", dataType: "String",hAlign: "center"},
            {headerName: "工程量", headerWidth: 65, dataCode: "quantity", dataType: "Number", hAlign: "right"},
            {headerName: "综合单价", headerWidth: 65, dataCode: "unitPrice", dataType: "Number", hAlign: "right"},
            {headerName: "综合合价", headerWidth: 65, dataCode: "totalPrice", dataType: "Number", hAlign: "right"}
        ],
        view: {
            lockColumns: [0,1,2,3,4,5],
            colHeaderHeight:30
        }
    },
    ration_setting:{
        header:[
            {headerName: "定额编码", headerWidth: 100, dataCode: "code", dataType: "String"},
            {headerName: "定额名称", headerWidth: 180, dataCode: "name", dataType: "String"},
            {headerName: "单位", headerWidth: 50, dataCode: "unit", dataType: "String",hAlign: "center"},
            {headerName: "工程量", headerWidth: 65, dataCode: "quantity", dataType: "Number", hAlign: "right",decimalField: "ration.quantity"}
        ],
        view: {
            lockColumns: [0,1,2,3],
            colHeaderHeight:30
        }
    },
    ration_glj_setting:{
        header:[
            {headerName: "编码", headerWidth: 120, dataCode: "code", dataType: "String"},
            {headerName: "名称", headerWidth: 80, dataCode: "name", dataType: "String"},
            {headerName: "规格型号", headerWidth: 80, dataCode: "specs", dataType: "String"},
            {headerName: "单位", headerWidth: 50, dataCode: "unit", dataType: "String",hAlign: "center"},
            {headerName: "市场价", headerWidth: 65, dataCode: "marketPrice", dataType: "Number", hAlign: "right"}
        ],
        view: {
            lockColumns: [0,1,2,3,4],
            colHeaderHeight:30
        }
    },
    datas:[],
    bookMarkSetting:{
        header:[
            {headerName: "编码", headerWidth: 120, dataCode: "code", dataType: "String"},
            {headerName: "书签名称", headerWidth: 200, dataCode: "name", dataType: "String"},
        ],
        view: {
            lockColumns: [0,1],
            colHeaderHeight:30
        }
    },
    //为了兼容旧项目，这里给个默认值
    bookmarkPropertySetting:{
        settingList :[
            {background:"E2F2C5",describe:""},
            {background:"F9E2CF",describe:""},
            {background:"F2EFD9",describe:"hehe"},
            {background:"F5D1DA",describe:""},
            {background:"E3E3E3",describe:""},
            {background:"B6F3F2",describe:""},
            {background:"ECE0F5",describe:""}
        ],
        selected:"E2F2C5"
    },
    initMainSpread:function(){
        if(!this.mainSpread){
            this.mainSpread = SheetDataHelper.createNewSpread($("#locate_result")[0],3);
            sheetCommonObj.spreadDefaultStyle(this.mainSpread);
            this.initMainSheet();
        }else {
            this.mainSpread.refresh();
        }
    },
    initMainSheet:function () {
        //初始化清单表格
        sheetCommonObj.initSheet(this.mainSpread .getSheet(0),this.bills_setting);
        this.mainSpread .getSheet(0).setRowCount(0);
        //初始化定额表格
        sheetCommonObj.initSheet(this.mainSpread .getSheet(1),this.ration_setting);
        this.mainSpread .getSheet(1).setRowCount(0);
        //初始化人材机表格
        sheetCommonObj.initSheet(this.mainSpread.getSheet(2),this.ration_glj_setting);
        this.mainSpread .getSheet(2).setRowCount(0);
        this.mainSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick,this.onSheetDoubleClick);
        this.mainSpread .getSheet(2).bind(GC.Spread.Sheets.Events.SelectionChanged,this.gljSelectionChange);
    },
    initSubSpread:function () {
        if(!this.subSpread){
            this.subSpread = SheetDataHelper.createNewSpread($("#locate_sub")[0]);
            sheetCommonObj.spreadDefaultStyle(this.subSpread);
            this.initSubSheet();
            this.subSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick,this.onSheetDoubleClick);
        }else {
            this.subSpread.refresh();
        }
    },
    initBookmarkSpread:function(){
        if(!this.bookmarkSpread){
            this.bookmarkSpread = SheetDataHelper.createNewSpread($("#bookmarkSpread")[0]);
            sheetCommonObj.spreadDefaultStyle(this.bookmarkSpread);
            this.initBookmarkSheet();
           // this.subSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick,this.onSheetDoubleClick);
        }else {
            this.bookmarkSpread.refresh();
        }
    },
    refreshWorkBook: function () {
        if (this.mainSpread) this.mainSpread.refresh();
        if (this.subSpread) this.subSpread.refresh();
        if (this.bookmarkSpread) this.bookmarkSpread.refresh();

    },
    initSubSheet:function () {
        this.subSheet = this.subSpread .getSheet(0);
        sheetCommonObj.initSheet( this.subSheet, this.ration_setting);
        this.subSheet.setRowCount(0);
        this.subSheet.name('locate_sub');
    },
    initBookmarkSheet:function () {
        this.bookmarkSheet = this.bookmarkSpread .getSheet(0);
        sheetCommonObj.initSheet( this.bookmarkSheet, this.bookMarkSetting);
        this.bookmarkSheet.setRowCount(0);
        this.bookmarkSheet.name('bookmark');
    },
    initOutstanding:function () {
        if(!projectObj.project.property.locateSetting) return;
        let outstd = projectObj.project.property.locateSetting;
        $("#outstanding").prop("checked",outstd.outstanding);
        $("#outInp").val(parseFloat(outstd.outInp));
    },
    initBookmarkSetting:function () {
        $("#bookmarkSettingList").empty();
        let setting = projectObj.project.property.bookmarkSetting?projectObj.project.property.bookmarkSetting:this.bookmarkPropertySetting;
        for(let s of setting.settingList){
            let b = `<div class="input-group input-group-sm mb-2" style="width:200px">
                          <div class="input-group-prepend">
                              <span class="input-group-text " style="background: #${s.background}">&nbsp;&nbsp;&nbsp;&nbsp;</span>
                          </div>
                          <input type="text" class="form-control" id="${s.background}"  placeholder="描述" value="${s.describe}">
                     </div>`;
            $("#bookmarkSettingList").append(b);
            $("#"+s.background).bind('focus', bookmarkSelected);
        }
    },
    showMainData:function (datas,setting) {
        sheetCommonObj.showData(this.mainSpread.getActiveSheet(),setting,datas);
        this.mainSpread.getActiveSheet().setRowCount(datas.length);
    },
    showSubRateDatas:function () {
        this.subRationDatas = this.getSubRationDatas();
        sheetCommonObj.showData(this.subSheet,this.ration_setting,this.subRationDatas);
        this.subSheet.setRowCount(this.subRationDatas.length);
    },

    getSubRationDatas:function () {
        let datas = [];
        let sheet = this.mainSpread.getActiveSheet();
        let oldSel = sheet.getSelections()[0];
        if(this.gljDatas && this.gljDatas.length > 0){
            let glj = this.gljDatas[oldSel.row];
            if(!glj) return datas;
            let  nodes = projectObj.project.projectGLJ.getImpactRationNodes([glj.reference]);
            for(let n of nodes){
                datas.push(this.getShowRationDatas(n.data));
            }
        }
        return datas;
    },

    refreshView: function (options, refreshWorkBook) {
        let me = this;
        let mainHeight = $(window).height()-$(".header").height()-$(".toolsbar").height()-$("#searchPanel").height();
        let subHeight = 0;
        if(options == "bookmark"){
            let bookMarkLibResize  = getBookmarkResize();
            loadHeight(bookMarkLibResize);
        }else {
            $('#locateTopDiv').height(mainHeight);
            $('#locate_result').height(mainHeight);
            $('#locateBottomDiv').height(subHeight);
            $('#locate_sub').height(subHeight - 7);
            if(options == "ration_glj"){
                let locateLibResize = getLocateLibResize();
                loadHeight(locateLibResize);
            }
        }

        function loadHeight(libResize) {
            SlideResize.loadVerticalHeight(libResize.eleObj.module, libResize.eleObj, libResize.limit, function () {
                locateObject.refreshWorkBook();
            });
        }

        if (refreshWorkBook) {
            me.refreshWorkBook();
        }
    },
    init:function () {
        let me = this;
        let options = $("input[name='content_type']:checked").val();
        let callback = function () {
            me.refreshView(options, false);
            me.initMainSpread();
            me.initSubSpread();
            me.initBookmarkSpread();
        };
        if(options == 'bookmark'){
            $("#aboutLocateDiv").hide();
            $("#outstandingOptions").hide();
            me.initBookmarkSetting();
            $("#aboutBookmarkDiv").show(0,callback);
        }else {
            $("#aboutBookmarkDiv").hide();
            $("#aboutLocateDiv").show(0,function () {
                if(options == "bills") me.initOutstanding();
                options == "bills"?$("#outstandingOptions").show(0,callback):$("#outstandingOptions").hide(0,callback);
            });
        }
    },
    findRecodes:function () {
        let options = $("input[name='content_type']:checked").val();
        let keyword = $("#locateInput").val();
        switch (options){
            case "bills":
                this.billsDatas = this.findBills(keyword);
                this.showMainData(this.billsDatas,this.bills_setting);
                break;
            case "ration":
                this.rationDatas = this.findRations(keyword);
                this.showMainData(this.rationDatas,this.ration_setting);
                break;
            case "ration_glj":
                this.gljDatas = this.findGLJs(keyword);
                this.showMainData(this.gljDatas,this.ration_glj_setting);
                this.showSubRateDatas();
                break;
        }
    },
    onshow:function () {
        locateObject.init();
    },
    matchItem:function (keyword,i) {//true 匹配上，false匹配失败
        let match = false;
        if(keyword && keyword !="") {//如果keyword为空，匹配所有
            if (i.code && i.code.indexOf(keyword) != -1) match = true;
            if (i.name && i.name.indexOf(keyword) != -1) match = true;
            if(match == false) return false
        }
        return true;
    },
    findGLJs:function(keyword){
        let datas = [];
        let gljList = projectObj.project.projectGLJ.datas.gljList;
        gljList =  sortProjectGLJ(gljList);
        for(let glj of gljList){
            // if(glj.quantity == 0 || glj.quantity == '0') continue;  2019-07-01 需求改成消耗量为0也显示
            let match = this.matchItem(keyword,glj);
            if(match == false) continue;
            let data = getGLJDatas(glj);
            gljOprObj.setGLJPrice(data,glj);
            datas.push(data);
        }
        return datas;
        function getGLJDatas(tem) {
            return{
                ID:tem.id,
                name:tem.name,
                code:tem.code,
                unit:tem.unit,
                specs:tem.specs,
                reference:tem
            }
        }

    },
    findRations:function (keyword) {
        let datas = [];
        let items = projectObj.project.mainTree.items;
        for(let  i of items){
            if(i.sourceType == ModuleNames.ration){
                let match = this.matchItem(keyword,i.data);
                if(match == false) continue;
                let bills = this.getShowRationDatas(i.data);
                datas.push(bills);
            }
        }
        return datas;
    },
    getShowRationDatas:function(data){
        return{
            ID:data.ID,
            name:data.name,
            code:data.code,
            unit:data.unit,
            quantity:data.quantity
        }
    },
    findBills:function(keyword){
        let datas = [],priceMap={};
        let items = projectObj.project.mainTree.items;
        for(let  i of items){
            if(i.sourceType == ModuleNames.bills){
                let match = this.matchItem(keyword,i.data);
                if(match == false) continue;
                let bills = getBillData(i.data);
                priceMap = setPriceMap(bills,priceMap);
                datas.push(bills);
            }
        }
        setBgColour(datas,priceMap);
        datas =  _.sortByAll(datas,['code']);
        return datas;


        function setBgColour(bills,map) {
            let outStd = $("#outstanding").prop("checked");
            let outInp = $("#outInp").val();
            if(outStd == true && outInp && outInp!=""){
                for(let b of bills){
                    if(b.code && b.code.length >= 9){
                        let key = b.code.substr(0,9);
                        if(map[key] && map[key].count > 1){
                            let avg = map[key].total/map[key].count;
                            let unitPrice = b.unitPrice?parseFloat(b.unitPrice):0;
                            if(unitPrice ==0 ) continue;
                            if(Math.abs(unitPrice - avg)/avg * 100  >= parseFloat(outInp)) b.bgColour = "#FFFACD"
                        }
                    }
                }
            }
        }
        function setPriceMap (bills,map) {
            if(bills.code && bills.code.length >= 9){
                let key = bills.code.substr(0,9);
                let unitPrice = bills.unitPrice?parseFloat(bills.unitPrice):0;
                if(map[key]){
                    map[key].total += unitPrice;
                    map[key].count ++;
                }else {
                    map[key] = {total:unitPrice,count:1}
                }

            }

            return map;
        }

        function getBillData(data) {
            return{
                ID:data.ID,
                name:data.name,
                code:data.code,
                unit:data.unit,
                quantity:data.quantity,
                unitPrice:data.feesIndex&&data.feesIndex.common?data.feesIndex.common.unitFee:"",
                totalPrice:data.feesIndex&&data.feesIndex.common?data.feesIndex.common.totalFee:"",
                bgColour:"white"
            }
        }
    },
    onSheetDoubleClick:function (e,args) {
        let me = locateObject;
        let options = $("input[name='content_type']:checked").val();
        let sheetName = args.sheet.name()
        if(options == "ration_glj"&&sheetName != "locate_sub" ) return;
        let datas = options == "bills"? me.billsDatas:me.rationDatas;
        if( args.sheet.name() == "locate_sub") datas = me.subRationDatas;
        me.locateNode(datas[args.row].ID);
    },
    gljSelectionChange:function (e,args) {
        let me = locateObject;
        let newSel = args.newSelections[0];
        let oldSel = args.oldSelections?args.oldSelections[0]:{};
        if(newSel.row != oldSel.row){
            me.showSubRateDatas();
        }
    },
    locateNode:function (ID) {
        let node =  projectObj.project.mainTree.findNode(ID);
        if(node) projectObj.loadFocusLocation(node.serialNo(),1);
    },
    updateOutStanding:function (outstanding,outInp) {
        let outstd = {outstanding:outstanding,outInp:outInp};
        let updateData = {type:ModuleNames.project,data:{'ID' : projectObj.project.ID(),'property.locateSetting':outstd}};
        projectObj.project.updateNodes([updateData],function () {
            projectObj.project.property.locateSetting = outstd;
        });
    }

};


$("#locate_btn").click(function () {
    locateObject.findRecodes();
});

//回车键搜索
$('#locateInput').bind('keypress', function (event) {
    if(event.keyCode === 13){
        $(this).blur();
        locateObject.findRecodes();
    }
});

$("input[name='content_type']").each(function(){
    $(this).click(function(){
        let options = $(this).val();
        switch (options){
            case "bills":
                locateObject.mainSpread.setActiveSheetIndex(0);
                break;
            case "ration":
                locateObject.mainSpread.setActiveSheetIndex(1);
                break;
            case "ration_glj":
                locateObject.mainSpread.setActiveSheetIndex(2);
                break;
        }
        locateObject.init();
    });
});


$('#outInp').change(function(){
    let me = locateObject;
    let process = getDecimal('process');
    var newVal = $(this).val();
    let outInp = scMathUtil.roundForObj(newVal,process);
    let outStd = $("#outstanding").prop("checked");
    me.updateOutStanding(outStd,outInp);
});
$('#outstanding').change(function(){
    let me = locateObject;
    let outInp = $("#outInp").val();
    let outStd = $("#outstanding").prop("checked");
    me.updateOutStanding(outStd,scMathUtil.roundForObj(outInp,getDecimal('process')));
});

$('#bookmarkSettingDropdown').on('shown.bs.dropdown', function showDropdown() {
    let setting = projectObj.project.property.bookmarkSetting?projectObj.project.property.bookmarkSetting:locateObject.bookmarkPropertySetting;
    $("#"+setting.selected).focus();
});

function bookmarkSelected() {
    console.log("hehe");
    $("#bookmarkSelected").val($(this)[0].id);
}