meidu2021/daju/WebRoot/webpage/cn/com/lzt/budget/tempsheet/budgetTempSheet-buttons.jsp

<%@ page language="java" import="java.util.*" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<c:set var="readOnly" value="${param.readOnly=='true' || readOnly}"/>
<script>
    var spread;
    var tempSheetId = '${tempSheet.id}';
    var periodId = '${tempSheet.periodId}';
    var periodYear = '${tempSheet.periodYear}';
    var periodType = '${periodEntity.periodType}';
    var dbJson;
    <c:if test="${not empty tempSheet.json}">
    dbJson =${tempSheet.json};//初始化用
    </c:if>
    var readOnly = '${readOnly}';
    var status =${empty tempSheet.status?'0':tempSheet.status};//0 填报 1 下发
    $(function () {
        $('#uploadA').on('click', function () {
            $('#uploadExcel').click();
        });
        $('#uploadExcel').on('change', function () {
            var excelFile = document.getElementById("uploadExcel").files[0];
            var excelIo = new GC.Spread.Excel.IO();
            excelIo.open(excelFile, function (json) {
                var workbookObj = json;
                spread.fromJSON(workbookObj);
                var sheet0 = spread.getSheet(0);
                if (sheet0.name() == 'Evaluation Version') {
                    spread.removeSheet(0);
                }
                var sheetCount = spread.getSheetCount();
                while (sheetCount >= 2) {
                    spread.removeSheet(1);
                    sheetCount = spread.getSheetCount();
                }
            }, function (e) {
                // process error
                _alert(e.errorMessage);
                if (e.errorCode === 2/*noPassword*/ || e.errorCode === 3 /*invalidPassword*/) {
                    document.getElementById('password').onselect = null;
                }
            })
        });
    })

    function back() {
        _confirm('是否保存数据？', function () {
            save(function () {
                closeDialog();
            });
        }, function () {
            closeDialog();
        });
    }

    function closeDialog(msg, reload) {
        var win = frameElement.api.opener;
        frameElement.api.close();
        if (msg) {
            win.tip(msg);
        }
        if (reload) {
            win.reloadTable();
        }
    }

    //子页面调用
    function _commonSave(params, afterSaveFunction) {
        var layerIndex = layer.msg('保存中，请稍候···', {
            time: 3000 * 1000,
            shade: 0.1
        });
        var sheet = spread.getActiveSheet();
        loopAll(sheet, function (row, col) {
            var cellTag = sheet.getTag(row, col);
            if (cellTag && cellTag.dataCell) {
                var arr = [];
                var depends = getDependents(sheet, row, col);
                if (depends.length > 0) {
                    for (var i = 0; i < depends.length; i++) {
                        loopCellRange(depends[i], function (r, c) {
                            var cellTagd = sheet.getTag(r, c);
                            if (cellTagd && cellTagd.dataCell) {
                                arr.push(r + "#" + c);
                            }
                        });
                    }
                }
                addCellTagValue(sheet, row, col, {effectCell: arr.join(',')});
            }
        });
        var params = params || {};
        var json = spread.toJSON();
        var jsonString = JSON.stringify(json);
        params.json = jsonString;
        params.id = tempSheetId;
        $.post('budgetTempSheetController.do?doAddMeasure', params, function (d) {
            layer.close(layerIndex);
            if (afterSaveFunction) {
                afterSaveFunction();
            } else {
                $.messager.alert("信息", d.msg);
            }
        }, 'json');
    }

    function showColorPicker() {
        var sheet = spread.getActiveSheet();
        var selections = sheet.getSelections();
        var select = selections[0];
        var row = select.row;
        var col = select.col;
        var bg = sheet.getCell(row, col).backColor();
        if (!bg) {
            bg = '#ffffff';
        }
        if (bg == 'yellow') bg = '#ffff00';
        bg = bg.colorHex();
        $('.colorpicker-hexInput').val(bg);
        picker.setColorByInput(bg);
        picker.show();
    }

    function changeColor(color) {
        if (!spread) return;
        $('.colorpicker-hexInput').val(color);
        var sheet = spread.getActiveSheet();
        spread.suspendPaint();
        loopSelection(sheet, function (row, col) {
            sheet.getCell(row, col).backColor(color);
        });
        spread.resumePaint();
    }

    function changeAlign(align) {
        var sheet = spread.getActiveSheet();
        var hAlign;
        if (align == 'left') hAlign = GC.Spread.Sheets.HorizontalAlign.left;
        if (align == 'right') hAlign = GC.Spread.Sheets.HorizontalAlign.right;
        if (align == 'center') hAlign = GC.Spread.Sheets.HorizontalAlign.center;
        spread.suspendPaint();
        loopSelection(sheet, function (row, col) {
            sheet.getCell(row, col).hAlign(hAlign);
        });
        spread.resumePaint();
    }

    var picker;
    $(function () {
        picker = Colorpicker.create({
            el: "color-picker",
            color: "#ffffff",
            change: function (elem, hex) {
                changeColor(hex);
            }
        })
    })

    var reg = /^#([0-9a-fA-f]{3}|[0-9a-fA-f]{6})$/;
    /*RGB颜色转换为16进制*/
    String.prototype.colorHex = function () {
        var that = this;
        if (/^(rgb|RGB)/.test(that)) {
            var aColor = that.replace(/(?:\(|\)|rgb|RGB)*/g, "").split(",");
            var strHex = "#";
            for (var i = 0; i < aColor.length; i++) {
                var hex = Number(aColor[i]).toString(16);
                if (hex === "0") {
                    hex += hex;
                }
                strHex += hex;
            }
            if (strHex.length !== 7) {
                strHex = that;
            }
            return strHex;
        } else if (reg.test(that)) {
            var aNum = that.replace(/#/, "").split("");
            if (aNum.length === 6) {
                return that;
            } else if (aNum.length === 3) {
                var numHex = "#";
                for (var i = 0; i < aNum.length; i += 1) {
                    numHex += (aNum[i] + aNum[i]);
                }
                return numHex;
            }
        } else {
            return that;
        }
    };
</script>
<style>
    /*#uploadExcel{
        position: absolute;
        font-size: 100px;
        right: 0;
        top: 0;
        opacity: 0;
        filter: alpha(opacity=0);
        cursor: pointer
    }*/
</style>
<%--查询框begin --%>
<table cellpadding="0" cellspacing="1" class="formtable" style="margin-top:5px;margin-bottom:5px;"> <!--  bottom -->
    <tr>
        <td class="value">
            <span class="spancon" title="attType">预算年度：</span>
            <input id="periodYear" name="periodYear" type="text" style="width: 150px" class="Wdate" disabled="disabled"
                   value="${tempSheet.periodYear}"/>
        </td>
    </tr>
    <tr>
        <td>
            <c:if test="${!readOnly}">
                <c:if test="${tempSheet.type=='normal' || tempSheet.type=='normal_special'}">
                    <a href="#" class="easyui-linkbutton l-btn" iconcls="icon-lock" onclick="fix()">生成数据单元格</a>
                    <a href="#" class="easyui-linkbutton l-btn" iconcls="icon-put" id="uploadA">导入excel</a>
                    <input type="file" id="uploadExcel" style="display:none"/>
                </c:if>
                <c:if test="${tempSheet.type=='actual_sta'}"><%--执行统计表--%>
                    <a href="#" class="easyui-linkbutton l-btn" iconcls="icon-lock" onclick="fix()">生成数据单元格</a>
                    <a href="#" class="easyui-linkbutton l-btn" iconcls="icon-add" onclick="addEntity()">新增</a>
                    <c:if test="${tempSheet.actualStaKind=='leader'}">
                        <a href="#" class="easyui-linkbutton l-btn" iconcls="icon-select" onclick="selectShowColumn()">显示配置</a>
                    </c:if>
                </c:if>

                <a href="#" class="easyui-linkbutton l-btn" iconcls="icon-select" onclick="showColorPicker()">
                    <input class="picker" id="color-picker" style="width:0px;height:0px;"></input>
                    单元格颜色
                </a>

                <a href="#" class="easyui-linkbutton l-btn" onclick="changeAlign('left')"><i class="fa fa-align-left"
                                                                                             style="margin-right:5px"></i>左对齐
                </a>
                <a href="#" class="easyui-linkbutton l-btn" onclick="changeAlign('center')"><i
                        class="fa fa-align-center" style="margin-right:5px"></i>居中</a>
                <a href="#" class="easyui-linkbutton l-btn" onclick="changeAlign('right')"><i class="fa fa-align-right"
                                                                                              style="margin-right:5px"></i>右对齐</a>
                <a href="#" class="easyui-linkbutton l-btn" iconcls="icon-save" onclick="save()">保存</a>
            </c:if>
            <a href="#" class="easyui-linkbutton l-btn" iconcls="icon-return" onclick="back()">返回</a>
        </td>
    </tr>
</table>
<%--查询框end --%>

<link rel="stylesheet" type="text/css" href="plug-in/SpreadJS/css/gc.spread.sheets.excel2016colorful.13.1.0.css">
<script src="plug-in/SpreadJS/scripts/gc.spread.sheets.all.13.1.0.min.js" type="text/javascript"></script>
<script src="plug-in/SpreadJS/scripts/resources/zh/gc.spread.sheets.resources.zh.13.1.0.min.js"
        type="text/javascript"></script>
<script src="plug-in/SpreadJS/scripts/interop/gc.spread.excelio.13.1.0.min.js" type="text/javascript"></script>
<script src="plug-in/SpreadJS/license.js" type="text/javascript"></script>
<script src="webpage/cn/com/lzt/budget/data/js/budget_tools.js?v=8" type="text/javascript"></script>
<script src="plug-in/jscolor/colorpicker.js" type="text/javascript"></script>
<script>
    var lastShowColumnValues = ['a1', 'a2', 'a3', 'a4', 'a5', 'a6', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12'];
    var values = values == null ? lastShowColumnValues : values;
//闵总视图样表
    function selectShowColumn() {
        _openDialog('budgetCostBreakdownController.do?selectAuth2&values=' + values.join(','), '显示配置', function (iframe) {
            values = iframe.getSelected();
            var sheet = spread.getActiveSheet();
            sheet.suspendPaint();
            sheet.getRange(-1, 5, -1, 12 * 12).visible(true);
            for (var i = 6; i < lastShowColumnValues.length; i++) {
                if (values[i] == '-1') {
                    sheet.getRange(-1, ((i - 6) * 12 + 1 + 4), -1, 12).visible(false);
                }
            }
            for (let i = 0; i < 6; i++) {
                if (values[i] == '-1') {
                    for (var j = 0; j < 12; j++) {
                        sheet.getRange(-1, j * 12 + i * 2 + 1 + 4, -1, 2).visible(false);
                    }
                }
            }
            sheet.resumePaint();
        }, '500px', '300px');
    }
</script>