PLTWEB.git - Gitblit

/**
 * 数据库链接页面
 * @author weidy
 * @date 2021-11-29
 */
layui.define(['layer','element','form','table','dynamicCondition' ],function(exports){
        var webUtil = $webUtil;
    var Class = function(){
        this.MODELNAME = "platform/objectService/VciDataBaseConnect";
        this.moduleKey = "VciDataBaseConnect";
        this.backPath =  configData.compatibility?path:configData.adminServicePath;
        this.url = {
            controller:'vciDataBaseConnectController/',
            dataGrid:'gridVciDataBaseConnect',
            addSave:'addSave',
            editSave:'editSave',
            deleteUrl:'deleteData',
            getObjectByOid:'getObjectByOid',
            testConnect:'testConnect'
        };
        this.getContent=function(){
            var that = this;
            var html = "";
            html = [
                '<div class="layui-layout" style="display:block;overflow-y: hidden">',
                    '<div class="layui-layout-border" style="display:block;margin-top:0px; " id="border_',that.id,'">',
                        '<div class="layui-center" style="overflow-y:auto;">',
                            that.getToolbarHtml(),
                            '<table id="table_', that.id , '" lay-filter="',that.id , '" style="overflow-x:auto;"></table>',
                        '</div>',
                    '</div>',
                '</div>'
            ].join("");
            return html;
        };
        this.getToolbarHtml =function(){
            var that = this;
            var html = [
                '<div layui-filter="toolbar_',that.id,'" class="layui-btn-container layui-buttons">',
                    '<button class="layui-btn layui-btn-sm" layui-filter="toolbar_',that.id,'_ADD"><i class="layui-icon layui-icon-add-1"></i>添加</button>',
                    '<button class="layui-btn layui-btn-sm" layui-filter="toolbar_',that.id,'_ADVQUERY"><i class="layui-icon layui-icon-search"></i>查询</button>',
                    '<button class="layui-btn layui-btn-sm" layui-filter="toolbar_',that.id,'_refresh"><i class="layui-icon layui-icon-refresh"></i>刷新</button>',
                    '<button class="layui-btn layui-btn-sm" layui-filter="toolbar_',that.id,'_EDIT"><i class="layui-icon layui-icon-edit"></i>修改</button>',
                    '<button class="layui-btn layui-btn-sm" layui-filter="toolbar_',that.id,'_DEL"><i class="layui-icon layui-icon-delete"></i>删除</button>',
                '</div>'
            ].join("");
            return html;
        };
        this.createSearchHtml = function () {
            var that = this;
            webUtil.bindDefultButtonLisenter(that, that.id);
            webUtil.createSearchHtml({id:"编号",name:"名称"} ,$("[layui-filter='toolbar_" + that.id + "']"), "table_" + that.id);
        };
        this.init = function(){
            var that = this;
            webUtil.copyConfig(that,that.moduleKey);
            that.initMainTable();
            that.createSearchHtml();
        };
        this.initMainTable = function (parentFieldName) {
            var that = this;
            var table = layui.table;
            that.checkColumns();
            var tableWidth = $("#border_" + that.id).width()-225;
            var options = {
                elem: '#table_' + that.id,
                id: 'table_' + that.id,
                backPath:that.backPath,
                url: that.url.controller + that.url.dataGrid,
                page: {
                    limit: 20,
                    page: 1
                },
                width:tableWidth,
                selectMode:table.selectMode.muti,
                cols: [that.columns],
                done:function(res,cur,total){
                    if(!that.fristMainLoad ){
                        table.on('tool(' + that.id + ')',function(obj){
                            var data = obj.data;//当前选择行的数据
                            var layEvent = obj.event;//点的是什么按钮
                            if(layEvent == 'EDIT'){
                                that.addOrEdit(false,data.oid);
                            }
                            if(layEvent == 'TESTCONNECT'){
                                that.testConnect(data.oid);
                            }
                        });
                    }else{
                        if(total>0) {
                            table.selectRecord('table_' + that.id, {index:0});
                        }
                    }
                    that.fristMainLoad = true;
                }
            };
            if(parentFieldName){
                options.treeConfig = {
                    treepid:parentFieldName,
                    treeid:'id',
                    showField:'name'
                };
            }
            table.render(options);
        };
        this.checkColumns = function(){
            var that = this;
            var table = layui.table;
            if(that.columns==null || that.columns.length==0){
                that.columns = [table.getIndexColumn(),table.getCheckColumn(), {
                    title: '编号',
                    field: 'id',
                    sort:true,
                    width: 80
                },
                    {
                        title: '名称',
                        field: 'name',
                        sort:true,
                        width: 150
                    },
                    {
                        title: '数据库的类型',
                        field: 'databaseType',
                        sort:true,
                        width: 80
                    },
                    {
                        title: '连接路径',
                        field: 'dbLinkUrl',
                        sort:true,
                        width: 350
                    },
                    {
                        title: '密码',
                        field: 'dbPassword',
                        sort:true,
                        width: 80
                    },
                    {
                        title: '用户名',
                        field: 'dbUserName',
                        sort:true,
                        width: 90
                    },
                    {
                        title: '描述',
                        field: 'description',
                        sort:true,
                        width: 150
                    },
                    {
                        title: '驱动的类',
                        field: 'driverClass',
                        sort:true,
                        width: 150
                    },
 
                    {
                        field:'options',
                        title:'操作',
                        width:180,
                        templet:function(d){
                            return '<a class="layui-btn layui-btn-intable" lay-event="EDIT">编辑</a>' + '<a class="layui-btn layui-btn-intable" lay-event="TESTCONNECT">测试链接</a>';
                        }
                    }];
            }
        };
 
        this.getFormItems = function(onlyShow) {
            var that = this;
            var table = layui.table;
            return [
                                   {
                    field: 'id',
                    title: '编号',
                    type: 'text',
                     required: true,
                    readOnly:onlyShow
                } ,                {
                    field: 'name',
                    title: '名称',
                    type: 'text',
                    required: true,
                    readOnly:onlyShow
                },
                {
                    field: 'databaseType',
                    title: '数据库的类型',
                    required: true,
                    type: 'combox',
                    readOnly:onlyShow,
                    comboxKey:'databaseType',
                    defaultValue:'oracle',
                    data:[{key:"oracle",value:"oracle"},{key:"mysql",value: "mysql"}]
                } ,          {
                    field: 'driverClass',
                    title: '驱动的类',
                    required: true,
                    type: 'text',
                    inputWidth:500,
                    useAllWidth:true,
                    readOnly:onlyShow
                } ,                {
                    field: 'dbLinkUrl',
                    title: '连接路径',
                    required: true,
                    type: 'text',
                    inputWidth:500,
                    useAllWidth:true,
                    readOnly:onlyShow
                } ,                {
                    field: 'dbUserName',
                    title: '用户名',
                    type: 'text',
                    readOnly:onlyShow
                }  ,                {
                    field: 'dbPassword',
                    title: '密码',
                    type: 'text',
                    readOnly:onlyShow
                },                {
                    field: 'description',
                    title: '描述',
                    type: 'text',
                    readOnly:onlyShow
                }  ];
        };
        this.ADD = function () {
            var that = this;
            that.addOrEdit(true);
        };
        this.EDIT = function(){
            var that = this;
            var oid = webUtil.getOidFromGrid("table_" + that.id,true,true);
            if(!oid){
                return false;
            }
            that.addOrEdit(false,oid);
        };
        this.addOrEdit = function(add,oid) {
            var that = this;
            var form = layui.form;
            var filter ="form_" + that.id;
            var addSaveIndex =webUtil.dialog({
                title:add?'添加数据库链接':'修改数据库链接',
                btn:['保存','取消'],
                skin:'layui-layer-lan',
                content:'<form id="form_' + filter + '" lay-filter="' + filter + '" class="layui-form" style="margin-top:5px" ></form>',
                resizing:function(layero){
                    form.doResize(filter);
                },
                success:function(layero) {
                    form.addItems(filter,that.getFormItems(false),
                        function () {
                            if(!add){
                                form.load(filter,{
                                    backPath:that.backPath,
                                    url:that.url.controller + that.url.getObjectByOid,
                                    method:'get',
                                    params:{
                                        oid:oid
                                    }
                                });
                            }else{
                                var defaultValues = {};
                                //可以手动在此处添加默认值
                                form.setValues(defaultValues,filter);
                            }
                        }, {}, {defaultColumnOneRow: 2});
                },
                yes:function(layero){
                    if(form.validata(filter)){
                        var values = form.getValues(filter,true);
                        var url = that.url.controller + (add?that.url.addSave:that.url.editSave);
                        webUtil.ajax(add?'post':'put',url,values,function(result){
                            if(result.success){
                                webUtil.showMsgFromResult(result,(add ? "添加成功" : "修改成功"));
                                layer.close(addSaveIndex);
                                that.refresh();
                            }else{
                                webUtil.showErrorMsg(result.msg);
                            }
                        },function(xhr,err){
                            webUtil.showErrorMsg("请求服务出现了错误，可能服务器未开启");
                        },that.backPath);
                    }
                },
                btn2:function(layero){
                    layer.close(addSaveIndex);
                }
            });
        };
        this.DEL = function(){
            var that = this;
            var oid = webUtil.getOidFromGrid("table_" +that.id,true,true);
            if(!oid){
                return false;
            }
            var ts= webUtil.getOidFromGrid("table_" +that.id,false,false,"ts");
            webUtil.showConfirmMsg("是否删除这条数据？如果被引用将不能被删除!",function () {
                webUtil.deleteRequest(that.url.controller + that.url.deleteUrl,{oid:oid,ts:ts},function(result){
                    if(result.success){
                        webUtil.showMsgFromResult(result,"删除成功");
                        that.refresh();
                    }else{
                        webUtil.showErrorMsg(result.msg);
                    }
                },function(xhr,err){
                    webUtil.showErrorMsg("请求服务出现了错误，可能服务器未开启");
                },that.backPath);
            });
        };
        this.refresh = function () {
            var that = this;
            var that = this;
            layui.table.reload("table_" + that.id);
        };
 
        this.ADVQUERY = function () {
            var that = this;
            if(!that.serinorQueryInstance) {
                var dynamicCondition = layui.dynamicCondition;
                $('[layui-filter="toolbar_' + that.id + '"]').append('<div  id="toolbar' + that.id + '" class="layui-inline"></div>');
                that.checkColumns();
                var dataFields = [];
                for(var i = 0 ; i < that.columns.length ; i ++){
                    dataFields[i] = that.columns[i];
                }
                that.serinorQueryInstance = dynamicCondition.create({
                    fields: dataFields//查询字段
                    , tableId: "table_" + that.id//需要查询的表格
                    , type: "complex"  //type:"simple"/"complex"  查询的方法  暂时写死为 complex
                    , queryCallBack: function (requestData) {//查询之后的callback
 
                    }
                });
            }
            that.serinorQueryInstance.open();
        };
        this.testConnect = function (oid){
            var that = this;
            $webUtil.post(that.url.controller + that.url.testConnect,{oid:oid},function (result){
                if(result.success){
                    $webUtil.showMsgFromResult(result,"链接成功");
                }else{
                    $webUtil.showErrorMsg(result.msg);
                }
            },function (error,xhr){
                $webUtil.showErrorMsg("链接服务出现了错误");
            },that.backPath);
        }
    };
    var cs = new Class();
    exports(cs.MODELNAME,cs);
});