spfm-market
/
spfm-market-front


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605
							<!DOCTYPE html>
<html>

<head lang='zh'>
    <meta charset='utf-8'>
    <meta http-equiv="X-UA-Compatible" content="IE=edge" />
    <meta name="renderer" content="webkit" />
    <meta name="viewport" content="width=device-width, initial-scale=1,user-scalable=0" />
    <title>Luckysheet</title>
    <link rel='stylesheet' href='/static/js/luckysheet/plugins/css/pluginsCss.css' />
    <link rel='stylesheet' href='/static/js/luckysheet/plugins/plugins.css' />
    <link rel='stylesheet' href='/static/js/luckysheet/css/luckysheet.css' />
    <link rel='stylesheet' href='/static/js/luckysheet/assets/iconfont/iconfont.css' />
    <link charset="utf-8" rel="stylesheet" href="/static/css/layui.css?v=1.0.0">
    <script>
        var _PageHeight = document.documentElement.clientHeight,
            _PageWidth = document.documentElement.clientWidth;
        var _LoadingTop = _PageHeight > 61 ? (_PageHeight - 61) / 2 : 0,
            _LoadingLeft = _PageWidth > 215 ? (_PageWidth - 215) / 2 : 0;
        var _LoadingHtml = '<div id="loadingDiv" style="position:absolute;left:0;width:100%;height:' + _PageHeight +
            'px;top:0;background:#f3f8ff;opacity:1;filter:alpha(opacity=80);z-index:10000;"><div style="position: absolute; cursor1: wait; left: ' +
            _LoadingLeft + 'px; top:' + _LoadingTop +
            'px; width: auto; height: 57px; line-height: 57px; padding-left: 50px; padding-right: 5px; color: #696969; font-family:\'Microsoft YaHei\';"><img style="width:200px;height:200px" src="../images/loading.gif"></div></div>';
        document.write(_LoadingHtml);
        document.onreadystatechange = completeLoading;

        function completeLoading() {
            if (document.readyState == "complete") {
                var loadingMask = document.getElementById('loadingDiv');
                loadingMask.parentNode.removeChild(loadingMask);
            }
        }

    </script>
    <script src="/static/js/layui.js?v=1.0.0"></script>
    <script src="/static/js/exceljs.js"></script>
    <script src="/static/js/fileSave.js"></script>
    <script src="/static/js/luckysheet/luckSheetExcel.js"></script>
    <script src="/static/js/luckysheet/plugins/js/plugin.js"></script>
    <script src="/static/js/luckysheet/luckysheet.umd.js"></script>
    <script src="/static/js/api.config.js"></script>
    <script src="/static/js/util.js?v=1.0.0"></script>
    <script src="/static/js/url.js?v=1.0.0"></script>
    <script src="/static/js/exportExcel.js"></script>
    <script src="/static/js/fullScreen.js"></script>
</head>
<style>
    * {
        padding: 0;
        margin: 0;
    }

    html,
    body {
        height: 100%;
    }

    #monthSelect {
        padding: 10px 0px;
    }

</style>

<body style="background: #fff;">
    <div class="layui-inline" id="monthSelect">
        <label class="layui-form-label">控制权限</label>
        <div class="layui-input-inline">
            <form class="layui-form mc-work-form">
                <select name="city" lay-filter="powerFlag" id="powerFlag">
                    <option value="0">开启</option>
                    <option value="1">关闭</option>
                </select>
            </form>
        </div>
    </div>
    <div id="waring" style="width: 100%;margin-right: 1%;text-align:right;color:red;font-size:22px">
        说明：首列禁止修改！
    </div>
    <div style="height:90%;width: 100%;">
        <div id="luckysheet" style="width:100%;height:100%">
        </div>
    </div>
    <script>
        //监听window是否全屏，并进行相应的操作,支持esc键退出
        window.onresize = function () {
            var isFull = !!(document.webkitIsFullScreen || document.mozFullScreen ||
                document.msFullscreenElement || document.fullscreenElement
            ); //!document.webkitIsFullScreen都为true。因此用!!
            if (isFull == false) {
                $("#exitFullScreen").css("display", "none");
                $("#fullScreen").css("display", "");
            } else {
                $("#exitFullScreen").css("display", "");
                $("#fullScreen").css("display", "none");
            }
        }

    </script>
    <script>
        // var lockFlag = 'see'; // 模板状态--see查看add新增updates修改
        var lockFlag = 'updata'; // 模板状态--see查看add新增updates修改
        let Menus = JSON.parse(window.sessionStorage.childrenMenus);
        for (let i = 0; i < Menus.length; i++) {
            // if(Menus[i].systemflag == 1 && Menus[i].jspUrl == '/publicityAccount'){
            // 	lockFlag = 'add';//省级
            // }
            // if(Menus[i].systemflag == 1 && Menus[i].jspUrl == '/publicity'){
            // 	lockFlag = 'updata';//管理员
            // 	i = Menus.length;
            // }
        }
        var id = '' //  模板id 查看/修改load时候用
        var sts; //状态即权限
        var powerFlag; // 权限控制 0 未上传模板 1 开启 2关闭
        var excelId = '';
        var tempType = '0'; // 模板类型 0-年度预算  1-季度预算  2-月度预算  3-部门预算采购项目管理
        var flag = false; // 控制excel是否可以编辑
        var userId; // 用户ID
        var regionList; //用户所在地区
        var strategyId; //woNo
        var usrName; //woName(发起人)
        var userName; //当前登录人
        var countyFlag; //是否为区县
        var fillFlag; //是否为填写人
        var regionName; //区县名称
        var woName; //模板名称

        $(function () {
            userId = JSON.parse(window.top.sessionStorage.userInfo).loginNo;
            regionList = JSON.parse(window.top.sessionStorage.userInfo).cityName;
            userName = JSON.parse(window.top.sessionStorage.userInfo).loginName;
            strategyId = $('#iframeBox', parent.document).contents().prevObject[0].attributes.strategyid.nodeValue;
            usrName = $('#iframeBox', parent.document).contents().prevObject[0].attributes.usrname.nodeValue;
            sts = $('#iframeBox', parent.document).contents().prevObject[0].attributes.sts.nodeValue;
            countyFlag = $('#iframeBox', parent.document).contents().prevObject[0].attributes.countyFlag.nodeValue;
            fillFlag = $('#iframeBox', parent.document).contents().prevObject[0].attributes.fillFlag.nodeValue;

            regionName = $('#iframeBox', parent.document).contents().prevObject[0].attributes.regionName.nodeValue;
            woName = $('#iframeBox', parent.document).contents().prevObject[0].attributes.woName.nodeValue;
            var form = layui.form;
            powerFlag = (sts == 2 || sts == 3) ? '1' : '0';
            $('#powerFlag').val(powerFlag)
            // form.render();

        })
        layui.use(['laydate', 'form'], function () {
            var laydate = layui.laydate;
            var form = layui.form;

            
            form.on('select(powerFlag)', function (data) {
                powerFlag = data.value
                var url = '/market/cStrategyBic/update';
                // if(lockFlag == 'updata'){
                // 	url = '/market/cadvLedger/loadProv';
                // }
                util.ajaxJson("数据加载中", ctx + url, {
                    // "id": id ? id : '',
                    // "opMonth": "",
                    // "sts": '0',
                    // "mkStrategyBic": {
                    //     "fillName": userId
                    // },
                    // "regionList": [regionList]
                    "fillName": userName,
                    "woNo": strategyId,
                    "sts": parseInt(powerFlag)+1
                }, function (res) {
                    if (res.result == 0) {
                        sts=parseInt(powerFlag)+1;
                        window.top.$vm.$message({
                            message: '权限修改成功',
                            type: 'success'
                        })
                    //     // 查看和修改时 下拉框赋值
                    //     if (res.body[0]) {
                    //         if (res.body[0].config.authority) {
                    //             getData()
                    //         }
                    //         powerFlag = res.body[0].powerFlag
                    //         $('#powerFlag').val(res.body[0].powerFlag)
                    //         tempType = res.body[0].tempType
                    //         $('#excelPosition').val(res.body[0].colHeaderNum)
                    //         $('#tempType').val(res.body[0].tempType)
                    //         form.render();
                    //         excelId = res.body[0].id;
                    //         // res.body[0].calcChain = [];
                    //         initExcel(res.body)
                    //     } else {
                    //         //getData()
                    //     }
                    }else{
                        window.top.$vm.$message({
                            message: res.desc,
                            type: "error"
                        })
                        
                    }
                });
            })
            // 获取数据
            function getData() {
                // 先销毁excel重新加载
                if (window.luckysheet) {
                    window.luckysheet.destroy();
                }
                var reg = new RegExp("(^|&)" + name + "=([^&]*)(&|$)", "i");
                // var r = window.top.location.href.split('?')[1];
                var url = '/market/cAdvStrategy/load';
                // if(lockFlag == 'updata'){
                // 	url = '/market/cadvLedger/loadProv';
                // }

                util.ajaxJson("数据加载中", ctx + url, {
                    // "id": id ? id : '',
                    // "opMonth": "",
                    // "sts": '0',
                    // "mkStrategyBic": {
                    //     "fillName": userId
                    // },
                    // "regionList": [regionList]
                    "strategyId": strategyId,
                    "usrName": userName,
                    "countyFlag": countyFlag,
                    "regionName": regionName,
                }, function (res) {
                    if (res.result == 0) {
                        // 查看和修改时 下拉框赋值
                        if (res.body[0]) {
                            
                            // if (res.body[0].config.authority) {
                            //     getData()
                            // }
                            powerFlag = res.body[0].powerFlag

                            $('#powerFlag').val(res.body[0].powerFlag)
                            console.info("powerFlag"+powerFlag);
                            console.info("sts"+sts);
                            powerFlag = (sts == 2 || sts == 3) ? '1' : '0';
                            $('#powerFlag').val(powerFlag)
                            
                            tempType = res.body[0].tempType
                            $('#excelPosition').val(res.body[0].colHeaderNum)
                            $('#tempType').val(res.body[0].tempType)
                            form.render();
                            excelId = res.body[0].id;
                            res.body[0].calcChain = [];
                            initExcel(res.body)
                        // } else {
                        //     //getData()
                        }
                    }
                });
                initExcel()
            }
            // 表格初始化
            function initExcel(data) {
                var rowFlag = true;
                if (powerFlag == '1' && userName != usrName) {
                    flag = false
                } else {
                    flag = true
                }
                if (fillFlag == 1) {
                    rowFlag = false;
                } else {
                    rowFlag = true;

                }
                try {
                    luckysheet.create({
                        container: 'luckysheet',
                        data: data,
                        showsheetbar: false, // 底部sheet显示/隐藏
                        showstatisticBar: false, // 底部计数
                        enableAddRow:rowFlag,
                        showtoolbar: false,
                        showinfobar: true, // 顶部信息 文件名称 按钮
                        allowUpdate: false, // 是否允许操作表格后的后台更新 在线文档websocket时为true
                        allowEdit: flag, // 是否允许前台编辑
                        column: 12,
                        title: woName, // 文件名称
                        row: 10,
                        lang: 'zh',
                        showstatisticBar: false, // 底部计数
                        showstatisticBarConfig: {
                            count: false, // 计数栏
                            view: false, // 打印视图
                            zoom: false, // 缩放
                        },
                        functionButton: '<input id="imports" type="file" class="btn btn-primary" style="padding:3px 6px;font-size: 12px;margin-right: 10px;"></input><button id="saves" class="btn btn-primary btn-danger" style=" padding:3px 6px; font-size: 12px; margin-right: 10px;">保存</button><button id="exports" class="btn btn-primary" style="padding:3px 6px;font-size: 12px;margin-right: 10px;">导出</button><button id="fullScreen" class="btn btn-primary" style="padding:3px 6px;font-size: 12px;margin-right: 10px;">全屏显示</button><button id="exitFullScreen" class="btn btn-primary" style="padding:3px 6px;font-size: 12px;margin-right: 10px;display:none">退出全屏</button><button id="downloadMode" class="btn btn-primary btn-danger" style="padding:3px 6px;font-size: 12px;margin-right: 10px;">下载模板</button><button id="goBack" class="btn btn-primary" style="padding:3px 6px;font-size: 12px;margin-right: 10px;">返回</button>',
                        cellRightClickConfig: {
                            copy: false, // 复制
                            copyAs: false, // 复制为
                            paste: false, // 粘贴
                            insertRow: rowFlag, // 插入行
                            insertColumn: true, // 插入列
                            deleteRow: true, // 删除选中行
                            deleteColumn: true, // 删除选中列
                            deleteCell: false, // 删除单元格
                            hideRow: false, // 隐藏选中行和显示选中行
                            hideColumn: false, // 隐藏选中列和显示选中列
                            rowHeight: true, // 行高
                            columnWidth: true, // 列宽
                            clear: false, // 清除内容
                            matrix: false, // 矩阵操作选区
                            sort: false, // 排序选区
                            filter: false, // 筛选选区
                            chart: false, // 图表生成
                            image: false, // 插入图片
                            link: false, // 插入链接
                            data: false, // 数据验证
                            cellFormat: false, // 设置单元格格式
                            mComplete: false,
                            mCetup: false,
                            mRevoke: false
                        },
                        hook: {
                            cellMousedown: function (a, b, c) {
                                if (b.c == luckysheet.getSheet().data[b.r].length - 1) {
                                    return false
                                }
                                if (!flag) {
                                window.top.$vm.$message({
                                message: '您无权修改当前行',
                                type: 'error'
                                })
                                return false
                                }
                            }, //绑定鼠标事件
                            cellUpdateBefore: function (r, c) {
                                // c坐标 r行坐标
                                // if(lockFlag == 'updata'){
                                // 	return true
                                // }
                                //      if (c == luckysheet.getSheet().data[r].length - 1) {
                                // if(luckysheet.getSheet().data[r][c] != null ){
                                // 	return false
                                // }
                                //      }
                                if (!flag) {
                                    window.top.$vm.$message({
                                        message: '您无权修改当前行',
                                        type: 'error'
                                    })
                                    return false
                                }
                                // if(c<15){
                                // 	if(luckysheet.getSheet().data[r][c] == null){
                                // 		return true
                                // 	}
                                // 	window.top.$vm.$message({
                                // 	    message: '您无权修改当前列',
                                // 	    type: 'info'
                                // 	})
                                // 	return false
                                // }

                                // if (luckysheet.getSheet().readOnly != '') {
                                //     if (luckysheet.getSheet().data[r][luckysheet.getSheet().data[r].length - 1] != null && luckysheet.getSheet().data[r][luckysheet.getSheet().data[r].length - 1].v !== userId) {
                                //         window.top.$vm.$message({
                                //             message: '您无权修改当前行',
                                //             type: 'info'
                                //         })
                                //         return false
                                //     }
                                // } else {
                                //     if (luckysheet.getSheet().data[r][luckysheet.getSheet().data[r].length - 1] != null) {
                                //         window.top.$vm.$message({
                                //             message: '您无权修改当前行',
                                //             type: 'info'
                                //         })
                                //         return false
                                //     }
                                // }
                            },
                        },
                    })
                } catch (err) {
                    console.log(err)
                }

                if (lockFlag == 'see') { // 查看预算跳转过来
                    $('#monthSelect').hide()
                } else if (lockFlag == 'add') { // 查看预算跳转过来
                    $('#monthSelect').hide()
                }
                // let r = window.top.location.href.split('?')[1];
                if(!flag){
                    $('#imports').hide();
                    $('#saves').hide();
                    
                    // if(powerFlag == 1){
                    //     $('#saves').hide();
                    //     $('#imports').hide();
                    // }
                    // $('#monthSelect').hide();
                }
                if(fillFlag == 1){
                    $('#imports').hide();
                }
                if(userName != usrName){
                    $('#monthSelect').hide();
                }else{
                    $('#waring').hide();

                }
                if(countyFlag == '2'){
                    $('#monthSelect').hide();
                    $('#imports').hide();
                    $('#saves').hide();
                    flag = false;
                }
                // if(r == 'type=3'){
                //     $('#imports').hide();
                //     $('#monthSelect').hide();
                //     $('#saves').hide();
                // }
                initHandel()
            }

            function getTemple() {
                let param = new FormData();
                param.append("type", 'channel');
                this.$http({
                    url: '/market/cAdvStrategy/downTemple',
                    method: "post",
                    responseType: 'blob',
                    headers: {
                        "Content-Type": "application/json",
                    },
                    data: param,
                }).then((response) => {
                    if (window.navigator && window.navigator.msSaveOrOpenBlob) {
                        let blob = new Blob([response.data], {
                            type: response.data.type
                        });
                        window.navigator.msSaveOrOpenBlob(blob, '存量运营策略征集模板.xlsx');
                    } else {
                        /* 火狐谷歌的文件下载方式 */
                        var blob = new Blob([response.data])
                        var downloadElement = document.createElement('a')
                        var href = window.URL.createObjectURL(blob);
                        downloadElement.href = href;
                        downloadElement.download = '存量运营策略征集模板.xlsx';
                        document.body.appendChild(downloadElement);
                        downloadElement.click();
                        document.body.removeChild(downloadElement);
                        window.URL.revokeObjectURL(href);
                    }
                })
            }


            // 绑定按钮事件
            function initHandel() {
                $("#fullScreen").on("click", function () {
                    fullScreen();
                })
                //退出全屏
                $("#exitFullScreen").on("click", function () {
                    exitFullscreen();
                })
                //返回
                $('#goBack').off('click').click(function () {
                    window.top.$vm.$router.push('/stockOperate')
                })
                // 保存
                $('#saves').off("click").click(function () {
                    //  当前工作表名
                    var sheetName = luckysheet.getSheet().name
                    var data = luckysheet.getSheet(sheetName)
                    data.id = id ? id : excelId
                    data.fileName = luckysheet.getWorkbookName()
                    // data.powerFlag = powerFlag
                    // data.powerFlagDev = powerFlag == '0' ? '开' : '关'
                    data.tempType = tempType
                    data.colHeaderNum = 1
                    data.tempTypeDesc = ''
                    // data.countyFlag = countyFlag;
                    // var urlsave = '/market/cadvLedger/save';

                    var urlsave = '/market/cAdvStrategy/save?strategyId=' + strategyId + '&usrName=' +
                        userName + '&countyFlag=' + countyFlag;
                    var reg = new RegExp("(^|&)" + name + "=([^&]*)(&|$)", "i");
                    var r = window.top.location.href.split('?')[1];
                    // if (lockFlag == 'updata' && r == 'type=2') {
                    //     // urlsave = '/market/cadvLedger/saveProv';
                    //     urlsave = '/market/cAdvStrategy/save?strategyId='+strategyId+'&usrName='+usrName;
                    // }
                    util.ajaxJson("正在加载中", ctx + urlsave, {
                        data: data
                    }, function (data) {
                        if (data.result != 0) {
                            window.top.$vm.$message({
                                message: data.desc,
                                type: 'false'
                            });
                            getData()
                        }else{
                            // getData();
                            window.top.$vm.$message({
                                message: "保存成功",
                                type: 'true'
                            });
                            window.top.$vm.$router.push('/stockOperate');
                            // this.$router.push({
                            //     path: "/stockOperate",
                            //     query: {
                            //     }
                            // });
                            
                        }
                    });
                })
                // 导出
                $('#exports').click(function () {
                    exportExcel(luckysheet.getluckysheetfile(), woName)
                })
                // 导入
                $("#imports").change(function (evt) {
                    var files = evt.target.files;
                    if (files == null || files.length == 0) {
                        window.top.$vm.$message({
                            message: '没有文件导入',
                            type: 'info'
                        })
                        return;
                    }
                    var name = files[0].name;
                    var suffixArr = name.split("."),
                        suffix = suffixArr[suffixArr.length - 1];
                    if (suffix != "xlsx") {
                        window.top.$vm.$message({
                            message: '目前只支持xlsx文件的导入',
                            type: 'info'
                        })
                        return;
                    }
                    // 解析文件
                    LuckyExcel.transformExcelToLucky(
                        files[0],
                        function (exportJson, luckysheetfile) {
                            if (exportJson.sheets == null || exportJson.sheets.length == 0) {
                                window.top.$vm.$message({
                                    message: '无法读取excel文件的内容，当前不支持xls文件',
                                    type: 'info'
                                })
                                return;
                            }
                            // 销毁原来的excel
                            window.luckysheet.destroy();
                            // 重新加载
                            initExcel([exportJson.sheets[0]])
                            // 绑定按钮事件
                            initHandel()
                        }
                    );
                })
                $('#downloadMode').click(function () {
                    var urlDMode = "/market/cAdvStrategy/downTemple";

                    let param = new FormData();
                    
                    var xhr = new XMLHttpRequest();
                    xhr.open('POST',  ctx + urlDMode, true);
                    xhr.responseType = 'blob';
                    xhr.headers={
                        "Content-Type": "application/json",
                    };
                    xhr.setRequestHeader("agileauthtoken", util.getToken());
                    xhr.overrideMimeType('text/plain; charset=x-user-defined');
                    xhr.onload = function (e) {
                        if (this.readyState == 4 && this.status == 200) {
                                let blob = this.response;

                                var urlObject = window.URL || window.webkitURL || window;  
                                var export_blob = this.response;
                            
                                var save_link = document.createElementNS("http://www.w3.org/1999/xhtml", "a")  
                                save_link.href = urlObject.createObjectURL(export_blob);  
                                save_link.download = '存量运营策略征集模板.xlsx'; 
                                var ev = document.createEvent("MouseEvents");  
                                ev.initMouseEvent(  
                                    "click", true, false, window, 0, 0, 0, 0, 0  
                                    , false, false, false, false, 0, null  
                                    );  
                                save_link.dispatchEvent(ev); 
                        }

                    };
                    xhr.send(param);

                });
            }
            getData()
        })

    </script>
</body>

</html>