$(function () {
    spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"), {sheetCount: 1});
    initSpread();
    initStatusBar(spread);
    initStatusBarEvents(spread);
});
//保洁耗材 rootA02  办公用品 rootA03  工程耗材 rootA01  保安耗材 rootA10 会务耗材 rootA08
// 工作服 gzf 代采购 dcg
// 低值易耗 R003  固定资产 rootA04

function initSpread() {
    spread.suspendPaint();
    var sheet ;
    if (dbJson) {//数据库
        spread.fromJSON(dbJson);
        sheet=spread.getActiveSheet();
        var sheetTag = sheet.tag();
        if(sheetTag){
            sheetVar = sheetTag.sheetVar;
        }
    } else {
        var headerJson ;
        if(ordersKindType=='m') headerJson=tempsheet_orders_m_header;
        if(ordersKindType=='gzf') headerJson=tempsheet_orders_gzf_header;
        if(ordersKindType=='dcg') headerJson=tempsheet_orders_dcg_header;
        if(ordersKindType=='dizhi') headerJson=tempsheet_orders_dizhi_header;
        spread.fromJSON(headerJson);
        sheet=spread.getActiveSheet();
        sheet.clearSelection();

        var title = sheet.getValue(0,0);
        title= title.replace(/\$year/g,periodYear);
        title= title.replace(/\$kindName/g,ordersKindTxt);
        sheet.setValue(0,0,title);

        if(ordersKindType=='m') {
            var refYearCellColArray =[5,9,12,15,18,21,24];
            for(var i=0;i<refYearCellColArray.length;i++){
                var cellValue = sheet.getValue(4,refYearCellColArray[i]);
                cellValue= cellValue.replace(/\$refYear/g,refYear);
                sheet.setValue(4,refYearCellColArray[i],cellValue);
            }
            sheetVar.headerCount=6;
        }else if(ordersKindType=='dizhi'){
            sheetVar.headerCount=7;
        }else if(ordersKindType=='gzf'){
            sheetVar.headerCount=7;
        }else if(ordersKindType=='dcg'){
            sheetVar.headerCount=7;
        }
        //多加一列隐藏列
        var columnColumn = sheet.getColumnCount();
        sheet.addColumns(columnColumn,1);
        sheetVar.categoryCodeCol=columnColumn;
        sheetVar.categoryTotalStartCol=columnColumn+1;
        sheet.getRange(-1, columnColumn).visible(false);//放分类code
        if(ordersKindType=='dizhi'){//低值和固定资产多加一列 一列放cagegorycode 一列放propertytype
            sheet.addColumns(columnColumn+1,1);
            sheet.getRange(-1, columnColumn+1).visible(false);
        }
        addSheetTagValue(sheet,{sheetVar:sheetVar});

        sheet.showColumn(0, GC.Spread.Sheets.HorizontalPosition.left);
    }
    
    spread.options.newTabVisible = false;//取消新增sheet按钮
    spread.options.allowExtendPasteRange = true;//扩展粘贴区域
    bindEvent(spread);


    var stag = sheet.tag();
    if (stag) {
        for (var i in stag) {
            if (i.indexOf('c_') == 0) {
                $('#' + i.substr(2)).val(stag[i]);
            }
        }
        if(stag.periodDetailInfo){
            $('#periodDetialName').val(stag.periodDetailInfo.periodDetailName);
        }
        if(typeof stag.includeTax !="undefined"){
            $('#includeTax'+stag.includeTax).attr('checked','checked');
        }
        if(typeof stag.expect !="undefined"){
            $('#expect'+stag.expect).attr('checked','checked');
        }
    }
    if(!stag.periodDetailInfo){
        $('#periodDetialName').val(defaultPeriodDetailInfo.periodDetailName);
        addSheetTagValue(sheet,{periodDetailInfo:defaultPeriodDetailInfo});
    }
    setDefaultLock(sheet);
    spread.resumePaint();
}

function bindEvent(spread) {

}

function setDefaultLock(sheet) {
    var option = {
        allowSelectLockedCells: true,
        allowSelectUnlockedCells: true,
        allowFilter: true,
        allowSort: false,
        allowResizeRows: true,
        allowResizeColumns: true,
        allowEditObjects: false,
        allowDragInsertRows: false,
        allowDragInsertColumns: false,
        allowInsertRows: false,
        allowInsertColumns: false,
        allowDeleteRows: false,
        allowDeleteColumns: false
    };
    sheet.options.protectionOptions = option;
    sheet.options.isProtected = true;
    var defaultStyle = sheet.getDefaultStyle() //默认的样式，
    defaultStyle.locked = true;
    sheet.setDefaultStyle(defaultStyle);
}


function save(afterSaveFunction) {

    var sheet = spread.getActiveSheet();
    var allBind =true;
     $('#bindMeasureDiv input').each(function(){
         var $t = $(this);
         if($t.val()==''){
             allBind =false;
             return false;
         }
     });
     if(!allBind) {
         $.messager.alert("信息", '请绑定全部维度');
         return;
     }
     var tag = sheet.tag();
    if(typeof tag.includeTax=="undefined"){
        $.messager.alert("信息", '请选择含税维度');
        return;
    }
    if(typeof tag.expect =="undefined"){
        $.messager.alert("信息", '请选择预实维度');
        return;
    }
    var json = spread.toJSON();
    var jsonString = JSON.stringify(json);
    _commonSave({type:'orders'},afterSaveFunction);
}

function _openDialog(url, title, okCallback, width, height) {
    if (!width) {
        width = '500px';
    }
    if (!height) {
        height = '350px';
    }
    if (width == "100%") {
        width = window.top.document.body.offsetWidth;
    }
    if (height == "100%") {
        height = window.top.document.body.offsetHeight - 100;
    }
    var _selectDialog = $.dialog({
        content: 'url:' + url
        , zIndex: getzIndex()
        , title: title, lock: true, width: width, height: height, opacity: 0.4, button: [
            {
                name: '确定', callback: function () {
                    var iframe = _selectDialog.iframe.contentWindow;
                    if (okCallback) {
                        var b = okCallback(iframe);
                        return b;
                    }
                }
                , focus: true
            },
            {
                name: '取消', callback: function () {
                }
            }
        ]
    }).zindex();
    return _selectDialog;
}