Ext.define('DataSourceDataModel', {
    extend: 'Ext.data.Model',
    fields:[
        'databasetype','datasourceid','username','password','serveraddress','databasename','databasealias','port','createuserid','createdate'
    ],
    idProperty: 'datasourceid'
});

var ZYMLZiYuanStore = new Ext.data.Store({
    autoDestroy: true,
    pageSize: 10,
    model: 'DataSourceDataModel',
    proxy: {
        type: 'ajax',
        url: '/res/manage/datasource/getlist',
        reader: {
            root: 'topics',
            totalProperty: 'totalCount'
        },
        simpleSortMode: true
    },
    remoteSort: true
});

var formdata = {};
Ext.onReady(function () {
    Ext.state.Manager.setProvider(new Ext.state.CookieProvider());
    Ext.tip.QuickTipManager.init();
    Ext.Ajax.timeout = 900000;
    Ext.require([
        'Ext.ux.PagingToolbar'
    ]);

    Ext.create('Ext.grid.Panel', {
        id: 'gridexample',
        renderTo: 'grid',
        // height: 500,
        layout: 'fit',
        autoScroll: false,
        store: ZYMLZiYuanStore,
        stateful: false,
        stateId: 'ZYMLZiYuan-Grid',
        viewConfig: {
            forceFit: true,
            enableTextSelection: true //列表数据可复制
        },
        columns: [
            { xtype: 'rownumberer', text: "序号", width: '5%', align: 'center' },
            { text: "数据库名称", dataIndex: 'databasename', width: '22%', sortable: false, align: 'center', filter: { type: 'string' },
                renderer: function (value, p, record) {
                    var datasourceid = record.getData()["datasourceid"];
                    return Ext.String.format(
                        '<span style="text-decoration: underline;cursor:pointer;" onclick="ZiYuanEdit(\'{0}\')" >{1}</span>',
                        datasourceid, value
                    );
                }
            },
            { text: "数据库别名", dataIndex: 'databasealias', width: '23%', sortable: false, align: 'center', filter: { type: 'string' } },
            { text: "数据库类型", dataIndex: 'databasetype', width: '12%', sortable: false, align: 'center', filter: { type: 'string' } },
            { text: "数据库地址", dataIndex: 'serveraddress', width: '13%', sortable: false, align: 'center', filter: { type: 'string' } },
            { text: "创建人", dataIndex: 'createuserid', width: '10%', sortable: false, align: 'center', filter: { type: 'string' } },
            { text: "创建时间", dataIndex: 'createdate', width: '15%', sortable: false, align: 'center', filter: { type: 'string' } }
        ],
        bbar: Ext.create('Ext.ux.PagingToolbar', {
            id: "Page",
            name: "Page",
            store: ZYMLZiYuanStore,
            displayInfo: true,
            firstText: "首页",
            prevText: "上一页",
            nextText: "下一页",
            lastText: "尾页",
            refreshText: '刷新',
            beforePageText: '第',
            afterPageText: '页，共 {0} 页',
            displayMsg: '显示 {0} - {1} 条，共 {2} 条',
            emptyMsg: "没有数据显示",
            items: [
                {
                    xtype: 'label',
                    text: ''
                }
            ]
        })
    });

    ZYMLZiYuanStore.on('beforeload', function () {
        GetSearchWhere("SearchForm");
        ZYMLZiYuanStore.proxy.extraParams = [];
        Ext.apply(ZYMLZiYuanStore.proxy.extraParams, formdata);
    });
    ZYMLZiYuanStore.on('load', function (store, records, successful, eOpts) {
        var totalCount = store.totalCount;
        if (totalCount == "") totalCount = "0";
    });
    ZYMLZiYuanStore.load();

    //添加resize监听防止切换tab或者收起左栏导致grid不自适应宽度
    $(window).resize(function () {
        Ext.getCmp('gridexample').doLayout();//panel重新布局
    });
});

//获取查询条件
function GetSearchWhere(formId) {
    var form = document.forms[formId];
    for (var i = 0; i < form.elements.length; i++) {
        var strID = form.elements[i].id;
        var value = form.elements[i].value;
        if (form.elements[i].type == "checkbox") {
            if (form.elements[i].checked == true)
                value = "on";
            else
                value = "";
        }
        if (form.elements[i].type == "radio") {
            if (form.elements[i].checked == true) {
                strID = form.elements[i].name;
                value = form.elements[i].value;
            }
        }
        formdata[strID] = (value == "全部" || value == "None" ? "" : value + "");
    }
}

//添加
function queding() {
    //获取那个被选中
    var valid=$('input:radio[name="selectName"]:checked').val();
    var valname=$('input:radio[name="selectName"]:checked').attr("getname");
    var valtype=$('input:radio[name="selectName"]:checked').attr("getype");
    if(valid==null){
        alert("选择数据库");
    }else {
        var index = parent.layer.getFrameIndex(window.name); //获取窗口索引
        parent.$('#datasourceid').val(valid);
        parent.$('#databasename').val(valname).change();
        parent.$('#databasetype').val(valtype);
        window.parent.spaceShowOrHide();
        parent.layer.close(index);
    }
}

function Clear() {
    document.getElementById("SearchForm").reset();
}

function Search() {
    Ext.getCmp('gridexample').dockedItems.items[1].store.currentPage = 1;
    ZYMLZiYuanStore.load();
}