ConstructionCost/web/building_saas/main/js/views/calc_base_view.js

/**
 * Created by Zhong on 2017/12/1.
 */
/*
* 计算基数,清单、定额统一ui
* */
let calcBaseView = {
    //可用计算基数的清单固定列映射(与fixedFlag)
    inputExpr: $('#calcBaseExp'),
    confirmBtn: $('#calcBaseConf'),
    type: {bills: 'bills', ration: 'ration'},
    billsCBClass:{ALL: [], FBFX: [], CSXM: [], QTXM: [], FBF: [], RCJ: [], GF: [], SJ: [], SQGCZJ: []},
    curType: null,
    editingCell: null,
    workBook: null,
    setting:{
        billsHeader: [
            {name: '计算基础名称', dataCode: 'base', width: 280, vAlign: 'center', hAlign: 'left'},
            {name: '金额', dataCode: 'price', width: 120, vAlign: 'center', hAlign: 'right'}
        ],
        rationHeader: [
            {name: '定额计算程序基数名称', dataCode: 'base', width: 400, vAlign: 'center', hAlign: 'left'}
        ],
        options: {
            tabStripVisible:  false,
            allowCopyPasteExcelStyle : false,
            allowExtendPasteRange: false,
            allowUserDragDrop : false,
            allowUserDragFill: false,
            scrollbarMaxAlign : true
        },
        locked: {
            rows: [],
            cols: [0]
        }
    },

    renderSheetFuc: function (sheet, fuc) {
        sheet.suspendPaint();
        sheet.suspendEvent();
        fuc();
        sheet.resumePaint();
        sheet.resumeEvent();
    },

    setOptions: function (workbook, opts) {
        for(let opt in opts){
            workbook.options[opt] = opts[opt];
        }
    },

    buildHeader: function (sheet, headers) {
        let me = calcBaseView;
        let fuc = function () {
            sheet.options.clipBoardOptions = GC.Spread.Sheets.ClipboardPasteOptions.values;
            sheet.options.isProtected = true;
            sheet.setColumnCount(headers.length);
            sheet.setRowHeight(0, 40, GC.Spread.Sheets.SheetArea.colHeader);
            for(let i = 0, len = headers.length; i < len; i++){
                sheet.setValue(0, i, headers[i].name, GC.Spread.Sheets.SheetArea.colHeader);
                sheet.setColumnWidth(i, headers[i].width, GC.Spread.Sheets.SheetArea.colHeader);
            }
        };
        me.renderSheetFuc(sheet, fuc);
    },

    buildSheet: function () {
        if(!this.workBook){
            this.workBook = new GC.Spread.Sheets.Workbook($('#billsBaseSpread')[0], {sheetCount: 1});
            this.setOptions(this.workBook, this.setting.options);
            //bills
            if(this.curType === this.type.bills){
                this.setting.header = this.setting.billsHeader;
            }
            //ration
            else {
                this.setting.header = this.setting.rationHeader;
            }
            this.buildHeader(this.workBook.getActiveSheet(), this.setting.header);
            this.bindEvent(this.workBook);
        }
    },

    bindEvent: function (workBook) {
        const _events = GC.Spread.Sheets.Events;
        let sheet = workBook.getActiveSheet();
        sheet.bind(_events.CellDoubleClick, this.onCellDoubleClick);
    },

    showData(datas){
        let me = calcBaseView;
        let sheet = this.workBook.getActiveSheet();
        let cols = this.setting.header;
        let fuc = function () {
            sheet.setRowCount(datas.length);
            let style = new GC.Spread.Sheets.Style();
            //style.formatter = MainTreeCol.getNumberFormatter(decimalObj.bills.totalPrice, true);
            sheet.setStyle(-1, 1, style);
            for(let col = 0, cLen = cols.length; col < cLen; col++){
                sheet.getRange(-1, col, -1, 1).hAlign(GC.Spread.Sheets.HorizontalAlign[cols[col]['hAlign']]);
                sheet.getRange(-1, col, -1, 1).vAlign(GC.Spread.Sheets.VerticalAlign[cols[col]['vAlign']]);
                for(let row = 0, rLen = datas.length; row < rLen; row++){
                    sheet.setValue(row, col, datas[row][cols[col]['dataCode']]);
                }
            }
        };
        this.renderSheetFuc(sheet, fuc);
    },

    onCellDoubleClick: function (sender, args) {
        let me = calcBaseView;
        if(args.col === 0){
            let v = args.sheet.getValue(args.row, args.col);
            if(!me.isDef(v)){
                return;
            }
            let baseFigure = '';
            if(me.curType == me.type.bills)
                baseFigure = `{${v}}`
            else if (me.curType == me.type.ration)
                baseFigure = `[${v}]`;
            if(baseFigure.trim() !== ''){
                //在光标后面插入
                let insertStr = me.insertStr(baseFigure);
                me.inputExpr.val(insertStr);
            }
        }
        me.inputExpr.focus();
    },
    isDef: function (v) {
        return v !== undefined && v !== null;
    },
    ifEdit: function () {
        var selected = projectObj.project.mainTree.selected;
        return MainTreeCol.readOnly.forCalcBase(selected)?false:true;
    },
    bindClassBtn: function () {
        let me = this;
        for(let clas in me.billsCBClass){
            let jqS = `#cb_${clas}`;
            $(jqS).click(function () {
                sheetCommonObj.cleanData(me.workBook.getSheet(0), me.setting, -1);
                me.showData(me.billsCBClass[clas]);
                $('#cbClassList li .btn ').removeClass('btn btn-outline-secondary btn-sm active');
                $(this).addClass('btn btn-outline-secondary btn-sm active');
            });
        }
    },
    //计算基数转换为显示数据Obj to Array, 给清单基数分类赋值
    toViewData: function (obj) {
        let rst = [];
        for(let figure in obj){
            let figureObj = Object.create(null);
            figureObj.base = figure;
            figureObj.price = projectObj.project.calcBase.getBase(figure);
            rst.push(figureObj);
            //set class datas
            this.billsCBClass.ALL.push(figureObj);
            this.billsCBClass[obj[figure]['class']].push(figureObj);
        }
        return this.billsCBClass.ALL;
    },

    initCalctor: function (type) {//type = bills、ration
        let me = calcBaseView;
        let showDatas;
        me.curType = type;
        if (type === me.type.bills) {
            //显示清单基数分类
            $('#cbClassList').show();
            $('#qd-jsjs .modal-content').css('width', '670px');
            $('#cbRowDiv').addClass('row');
            $('#billsBaseSpread').addClass('col-9');
            //
            let node = projectObj.project.mainTree.selected;
            //输入框显示原本的
            if (me.isDef(node.data.calcBase)) {
                me.inputExpr.val(cbParser.toFExpr(node.data.calcBase));
            }
            let baseObj = projectObj.project.calcBase.getBaseByClass(node);
            showDatas = me.toViewData(baseObj);
            $('#cbClassList li .btn ').removeClass('btn btn-outline-secondary btn-sm active');
            $('#cb_ALL').addClass('btn btn-outline-secondary btn-sm active');
        }
        else if (type == me.type.ration) {
            //去除清单基数分类
            $('#cbClassList').hide();
            $('#qd-jsjs .modal-content').css('width', '');
            $('#cbRowDiv').removeClass('row');
            $('#billsBaseSpread').removeClass('col-9');

            let calcItem = calcProgramManage.getSelectionInfo().calcItem;
            if (calcItem.dispExprUser) {
                me.inputExpr.val(calcItem.dispExpr);
                if (calcItem.dispExpr == '0'){
                    me.inputExpr.focus();
                    me.inputExpr.select();
                }
            }
            let bnArr = Object.keys(rationCalcBases);
            let baseArr = [];
            for (let bn of bnArr) {
                baseArr.push({base: bn})
            };
            showDatas = baseArr;
        }

        me.buildSheet();
        me.showData(showDatas);
        $('#qd-jsjs').modal('show');
    },

    getInputExpr: function () {
        return this.inputExpr.val();
    },

    //四则运算符控制，不可连续出现: ++ +*...
    arithmeticLegal: function (v) {
        let rex = /[\+,\-,\*,\/]{2}/g;
        let rex2 = /[{]{2}/g;
        let rex3 = /[}]{2}/g;
        let rex4 = /[F]{2}/g;
        let rex5 = /[.]{2}/g;
        let rex6 = /[%]{2}/g;
        return !rex.test(v) && !rex2.test(v) && !rex3.test(v) && !rex4.test(v) && !rex5.test(v) && !rex6.test(v);
    },

    //运算符点击显示到运算窗口
    clickOpr: function (operators) {
        let me = calcBaseView;
        for(let i = 0, len = operators.length; i < len; i++){
            operators[i].bind('click', function () {
                let v = $(this)[0].textContent;
                let insertStr = me.insertStr(v);
                if(me.arithmeticLegal(insertStr)){
                    me.inputExpr.val(insertStr);
                }
                me.inputExpr.focus();
            });
        }
    },

    //光标处插入（替换选中）
    insertStr: function (v) {
        let me = calcBaseView;
        //在光标后面插入
        let exp = me.getInputExpr();
        let startIdx = me.inputExpr[0].selectionStart;
        let endIdx = me.inputExpr[0].selectionEnd;
        let startStr = exp.substring(0, startIdx);
        let endStr = exp.substring(endIdx, exp.length);
        return startStr + v + endStr;
    },

    //输入窗口控制
    inputControl: function () {
        let me = calcBaseView;
        me.inputExpr.keydown(function (e) {
            if(!me.arithmeticLegal(me.inputExpr.val() + e.key)){
                return false;
            }
        });
    },

    //确认按钮
    calcBaseConf: function () {
        let me = calcBaseView;
        me.confirmBtn.bind('click', function () {
            //bills
            if(me.curType === me.type.bills){
                let selected = projectObj.project.mainTree.selected;
                projectObj.updateCellValue(selected, me.getInputExpr(), {data: {field: 'calcBase'}});
                if(projectObj.project.calcBase.success){
                    $('#qd-jsjs').modal('hide');
                }
            }
            else if (me.curType === me.type.ration) {
                let expr = me.inputExpr.val();
                expr = analyzer.standard(expr);
                me.inputExpr.val(expr);

                let template = calcProgramManage.getSelectionInfo().template;
                let calcItem = calcProgramManage.getSelectionInfo().calcItem;

                if (calcItem.dispExpr != expr){
                    if (analyzer.isLegal(expr, calcItem.ID, template)){
                        let cp = projectObj.project.calcProgram;
                        let lc = analyzer.calcItemLabourCoe(calcItem);
                        calcItem.dispExpr = expr;
                        calcItem.dispExprUser = analyzer.getDispExprUser(expr, lc);
                        calcItem.expression = analyzer.getExpression(expr, template);
                        calcItem.compiledExpr = analyzer.getCompiledExpr(calcItem.expression, lc);
                        calcItem.statement = analyzer.getStatement(calcItem.expression, template);

                        let data = {
                            'projectID': projectObj.project.ID(),
                            'templatesID': template.ID,
                            'calcItem': calcItem
                        };
                        calcProgramManage.saveCalcItem(data, function (rst) {
                            if (rst){
                                cp.compileTemplate(template);
                                cp.calcAllNodesAndSave();
                                calcProgramManage.refreshDetailSheet();
                                $('#qd-jsjs').modal('hide');
                                $.bootstrapLoading.end();
                            }
                        });
                    };
                }
                else
                    $('#qd-jsjs').modal('hide');
            }
        });
    },

    getCalcBaseCellType:function (type) {
        var ns = GC.Spread.Sheets;
        function CalcBaseCellType() {
            var init=false;
        }
        CalcBaseCellType.prototype = new ns.CellTypes.Text();
        CalcBaseCellType.prototype.paint = function (ctx, value, x, y, w, h, style, options) {
            //  if(value!=null){
            // ctx.fillText(value,x+3+ctx.measureText(value).width,y+h-3);
            // ctx.fillText(value,x+w-3,y+h-3);
            GC.Spread.Sheets.CellTypes.Text.prototype.paint.apply(this, arguments);
            // }
            if(calcBaseView.editingCell){
                if(calcBaseView.editingCell.row==options.row&&calcBaseView.editingCell.col==options.col){
                    var image = document.getElementById('f_btn'),imageMagin = 3;
                    var imageHeight = h-2*imageMagin;
                    var imageWidth = w*2/(type=='bills'?7:20);
                    var imageX = x + w - imageWidth- imageMagin, imageY = y + h / 2 - imageHeight / 2;
                    ctx.save();
                    ctx.drawImage(image, imageX, imageY,imageWidth,imageHeight);
                    ctx.beginPath();
                    ctx.arc(imageX+imageWidth/2,imageY+imageHeight/2,1,0,360,false);
                    ctx.arc(imageX+imageWidth/2-4,imageY+imageHeight/2,1,0,360,false);
                    ctx.arc(imageX+imageWidth/2+4,imageY+imageHeight/2,1,0,360,false);
                    ctx.fillStyle="black";//填充颜色,默认是黑色
                    ctx.fill();//画实心圆
                    ctx.closePath();
                    ctx.restore();
                }
            }
        };
        CalcBaseCellType.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) {
            return {
                x: x,
                y: y,
                row: context.row,
                col: context.col,
                cellStyle: cellStyle,
                cellRect: cellRect,
                sheetArea: context.sheetArea
            };
        };
        CalcBaseCellType.prototype.processMouseDown = function (hitinfo) {
            let me=calcBaseView;
            me.pmLeave = false;
            if(me.editingCell==null){
                var showSelectBtn = true;
                if(hitinfo.sheet.name()!='calc_detail'){
                    showSelectBtn=me.ifEdit();
                }
                if(showSelectBtn){
                    me.editingCell={
                        row:hitinfo.row,
                        col:hitinfo.col
                    }
                    hitinfo.sheet.invalidateLayout();
                    hitinfo.sheet.repaint();
                }
            }else if(hitinfo.row==me.editingCell.row){
                var offset=hitinfo.cellRect.x+hitinfo.cellRect.width-6;
                var imageMagin=3;
                var imageHeight = hitinfo.cellRect.height-2*imageMagin;
                var imageWidth = hitinfo.cellRect.width*2/7;
                if(hitinfo.x<offset&&hitinfo.x>offset-imageWidth){
                    calcBaseView.initCalctor(type);
                }
            }
        };
        CalcBaseCellType.prototype.processMouseLeave = function (hitinfo) {
            if(!calcBaseView.pmLeave){
                calcBaseView.editingCell=null;
                hitinfo.sheet.invalidateLayout();
                hitinfo.sheet.repaint();
                calcBaseView.pmLeave = true;
            }
        }
        return new CalcBaseCellType();
    },
};

$(document).ready(function () {
    $('#qd-jsjs').on('shown.bs.modal', function () {
        calcBaseView.workBook.refresh();
    });

    $('#qd-jsjs').on('hidden.bs.modal', function () {
        //清空输入框
        calcBaseView.inputExpr.val('');
        calcBaseView.workBook.destroy();
        calcBaseView.workBook = null;
        //清空清单分类数据
        for(let attr in calcBaseView.billsCBClass){
            calcBaseView.billsCBClass[attr] = [];
        }
    });

    //bind operator click function
    calcBaseView.clickOpr([$('#addOpr'), $('#subOpr'), $('#mulOpr'), $('#divOpr'), $('#leftOpr'), $('#rightOpr')]);

    //bind input control
    calcBaseView.inputControl();

    //confirmBtn
    calcBaseView.calcBaseConf();

    //class btn
    calcBaseView.bindClassBtn();
});