define('dataSetPanel', ['components/common', 'dataModel', 'modal'], function (common) {
    var template = '\
<div class="dataset-panel">\
    <div class="ds-left">\
        <ul>\
        </ul>\
    </div>\
    <div class="ds-main">\
        <div class="ds-key-search"> <input class="form-control no-outline" placeholder="' + SystemEnv.getHtmlNoteName(4748) /* 请输入检索项 */ + '" /> </div>\
        <div class="ds-key-container">\
            <div class="noresult-tip">' + SystemEnv.getHtmlNoteName(4752) /* 未找到结果 */ + '</div>\
        </div>\
    </div>\
</div>';

    var cssText = '\
    .dataset-panel { margin: 3px 0; width: 280px;vertical-align: top; position: fixed; border-radius: 0 0 3px 3px; box-shadow: 0px 2px 5px 3px rgba(0,0,0,0.1); background: #fff; top:0; left:-999px; display: block; overflow: hidden; height: 240px; z-index: 110; box-sizing: content-box; }\
    .dataset-panel.pos-top {margin-top: -5px;}\
    .dataset-panel .btn, .dataset-panel .form-control { margin-top: 10px; }\
    .dataset-panel .area-control, .dataset-panel .form-control { margin-top: 7px; }\
    .dataset-panel .area-control { height: 180px; }\
    .dataset-panel .ds-key-search { padding: 0 8px 5px 8px; }\
    .dataset-panel:after { content: " "; display: table; clear: both; }\
    .dataset-panel ul { padding: 0; margin: 0; }\
    .dataset-panel ul li { cursor: pointer; padding: 8px 0; font-size: 13px; text-align: center; color: #333; border-bottom: 1px solid #e1e1e1; }\
    .dataset-panel ul li:hover { background: #f1f1f1; color: #555;}\
    .dataset-panel ul li.active { color: #5897fb; font-weight: bold; background: #fff; box-shadow: inset 4px 0 0 #5897fb; }\
    .dataset-panel .ds-left { width: 90px; overflow-y: auto; float: left; height: 100%; background: #eee; }\
    .dataset-panel .ds-left::-webkit-scrollbar-thumb {border-radius: 10px; background: rgba(0,0,0,0.1);}\
    .dataset-panel .ds-left::-webkit-scrollbar {width: 2px;}\
    .dataset-panel .ds-main { width: 190px; border: 0px solid; outline: none; height: 100%; float: left; }\
    .dataset-panel .ds-main .custom, .dataset-panel .ds-main .jscode { padding: 5px 10px 0 10px; } \
    .dataset-panel .ds-key-container { position: relative; overflow-y: auto; overflow-x: hidden; height: calc(100% - 41px); } \
    .dataset-panel .ds-key-container .noresult-tip { display: none; font-size: 12px; padding: 10px; }\
    .dataset-panel .ds-key-container.noresult .noresult-tip { display: block; }\
    .dataset-panel .ds-key-container > div span { display: block; font-size: 13px; color: #666; padding: 5px 0 5px 10px; border: 0; cursor: pointer; text-align: left;}\
    .dataset-panel .ds-key-container > div span.selected.over { background: #f1f1f1; color: #444; }\
    .dataset-panel .ds-key-container > div span:hover, .dataset-panel .ds-key-container > div span.selected.over:hover, .dataset-panel .ds-key-container > div span.selected { background: #5897fb; color: #fff; }\
    .dataset-panel .ds-key-container > div span.hidden-id { display: none; }\
    .dataset-panel .ds-key-container span.browser-span > div {width: 20px; height: 24px; display: inline-block; float: right; margin-right: 6px; }\
    .dataset-panel .ds-key-container span.browser-span > div:before { content: "\\e78e"; font-family: iconfont; }\
    .dataset-panel .ds-key-container span.browser-span.reverse > div:before { content: "\\e66c"; }\
';

    common.importCssText('datasetPanel', cssText);

    var dataSetPanel = function(settings) {
        if (dataSetPanel.instance) return dataSetPanel.instance; // 单例
        settings = settings || {}
        this.$el = null; // 数据集面板元素
        this.target = null; // 触发打开事件的目标元素
        this.afterClose = settings.afterClose || function(el) { // 关闭dspanel的回调
            el.removeClass("sbToggle-btc-reverse");
        };

        dataSetPanel.instance = this;
    }

    dataSetPanel.pt = dataSetPanel.prototype;

    dataSetPanel.getDataSets = function() {
        var dataSets = [];
        var $mecContainer = $("#MEC_Design_Container");
        var $dataSets = $("abbr[m_type='DataSet']", $mecContainer);
        if($dataSets.length != 0){
            $dataSets.each(function(){
                var that = $(this);
                var dsMecId = that.attr("id");
                var mecHandler = MECHandlerPool.getHandler(dsMecId);
                dataSets.push($.extend(mecHandler.mecJson, {id: dsMecId}));
            });
        }
        return dataSets;
    };

    dataSetPanel.renderDataSet = function() {
        var datasets = dataSetPanel.getDataSets(),
            dsTemplate = '<li data-id={{id}} data-name={{name}}>{{name}}</li>',
            $dsList = $('.ds-left>ul');

        $dsList.empty();

        if(datasets.length == 0 ){
            $dsList.append('<span style="display: inline-block; padding-top: 6px; width: 100%; font-size: 13px; text-align: center; color: #333;">' + SystemEnv.getHtmlNoteName(4394) + '</span>');//请添加数据集
            return;
        }
        datasets.forEach(function(item){
            $dsList.append(common.tempEngine(dsTemplate, item));
        });
    };

    dataSetPanel.renderDataSetKey = function(dsId, callback) {
        var mecHandler = MECHandlerPool.getHandler(dsId);
        if(!mecHandler){
            return;
        }
        var mecJson = mecHandler.mecJson;
        var $dsContainer = $('.ds-key-container div[data-ds="'+mecJson.name+'"');
        $('.ds-key-container div[data-ds]').hide();
        $('.ds-key-container').removeClass('noresult');
        if($dsContainer.length > 0){
            $dsContainer.show();
            return;
        }
        if(mecJson.sourceType == '0'){ //表单
            var billid = mecJson.tableid;
            require("utils").api("designer/plugin", {
                action: "getFieldsByBillid",
                data: {
                    billid: billid
                },
            }, function (result) {
                var data = result.data;
                if(data.length > 0){
                    var $dsContainer = $('<div data-ds="'+mecJson.name+'" data-sourceType="'+mecJson.sourceType+'"></div>');
                    data.forEach(function(item){
                        var dsKeySpan = '<span data-name="' + mecJson.name + '" data-key="' + item.fieldname + '">' + item.labelName + '</span>',
                            $dsKeySpan = $(dsKeySpan);
                        if(item.fieldhtmltype == '3' && item.type != '2' && item.type != '19' && item.type != '290'){
                            dsKeySpan += '<span class="hidden-id" data-name="'+mecJson.name+'" data-key="'+item.fieldname+'[id]">'+item.labelName+SystemEnv.getHtmlNoteName(6125)+'id</span>'; //fieldname的id
                            $dsKeySpan = $(dsKeySpan);
                            var $browserSpan = $dsKeySpan.eq(0);
                            $browserSpan.addClass('browser-span');
                            $browserSpan.append('<div></div>');
                        } else if(item.fieldhtmltype == '4' || item.fieldhtmltype == '5'){
                            dsKeySpan += '<span class="hidden-id" data-name="'+mecJson.name+'" data-key="'+item.fieldname+'[id]">'+item.labelName+SystemEnv.getHtmlNoteName(6125)+'value</span>'; //fieldname的id
                            $dsKeySpan = $(dsKeySpan);
                            var $browserSpan = $dsKeySpan.eq(0);
                            $browserSpan.addClass('browser-span');
                            $browserSpan.append('<div></div>');
                        }
                        $dsContainer.append($dsKeySpan);
                    });
                    $('.ds-key-container').append($dsContainer).perfectScrollbar();
                    typeof(callback) == 'function' && callback();
                } else {
                    $('.ds-key-container').addClass('noresult');
                }
            });
        } else if(mecJson.sourceType == '1'){ //sql
            var sql = mecJson["sql"];
            var wherePattern = /(.*)where/gi;
            if(!wherePattern.test(sql)){
                sql += "where 1=1";
            }
            var tablesArray = [];
            var fieldsArray = [];
            //获取字段
            var allFieldPattern = /select(\s+.*\s+)from(.*)where/gi;
            var matches = allFieldPattern.exec(sql);

            if(matches != null && matches.length > 0){
                var fieldsString = matches[1];
                var tableString = matches[2];

                //直接从sql中提取字段
                var fieldsArrayTemp = fieldsString.split(",");
                for(var i = 0; i < fieldsArrayTemp.length; i++){
                    var field = "";
                    var fieldTemp = fieldsArrayTemp[i];

                    var asteriskPattern = /(\w+)?(\.|\s+)?(\*)/;
                    var asteriskMatches = asteriskPattern.exec(fieldTemp);
                    //包含*，需要查数据库
                    //获取数据库表名
                    if(asteriskMatches != null){
                        var tablesArrayTemp = [];
                        tablesArrayTemp = tableString.split(",");
                        //包含*的查询字段是否包含表别名
                        var tableAlias = asteriskMatches[1];
                        //匹配表名

                        //不包含表别名，则获取sql中所有表名
                        if(tableAlias == undefined){
                            fieldsArray = [];
                            tablesArray = [];
                            for(var j = 0; j < tablesArrayTemp.length; j++){
                                var tablePattern = /(\w+)((\s+(as\s+)?)(\w+))?\s*((\w+\s+)?join\s+(\w+)(\s+(as\s+)?)(\w+))?/gi;
                                var tableTemp = tablesArrayTemp[j];
                                var tableMatches = tablePattern.exec(tableTemp);
                                if(tableMatches == null){
                                    continue;
                                }
                                if(tableMatches[1] != undefined){
                                    tablesArray.push(tableMatches[1]);
                                }
                                if(tableMatches[8] != undefined){
                                    tablesArray.push(tableMatches[8]);
                                }
                            }
                            break;
                        }else{//包含表别名，则获取别名指向的数据库表
                            for(var j = 0; j < tablesArrayTemp.length; j++){
                                var tablePattern = /(\w+)((\s+(as\s+)?)(\w+))?\s*((\w+\s+)?join\s+(\w+)(\s+(as\s+)?)(\w+))?/gi;
                                var tableTemp = tablesArrayTemp[j];
                                var tableMatches = tablePattern.exec(tableTemp);
                                if(tableMatches == null){
                                    continue;
                                }
                                if(tableMatches[1] != undefined && tableMatches[5] == tableAlias){
                                    tablesArray.push(tableMatches[1]);
                                }
                                if(tableMatches[8] != undefined && tableMatches[11] == tableAlias){
                                    tablesArray.push(tableMatches[8]);
                                }
                            }
                            continue;
                        }
                    }
                    //查询字段是否包含别名
                    var aliasPattern = /(\(.*\)|\w+\.?\w+)(\s+as\s+|\s+)(\w+)/gi;
                    var aliasMatches = aliasPattern.exec(fieldTemp);
                    if(aliasMatches != null){
                        field = aliasMatches[3];
                        fieldsArray.push(field);
                        continue;
                    }
                    //是否包含点
                    var dotPattern = /\w+\.(\w+)/;
                    var dotMatches = dotPattern.exec(fieldTemp);
                    if(dotMatches != null){
                        field = dotMatches[1];
                        fieldsArray.push(field);
                        continue;
                    }
                    field = fieldTemp.trim();
                    fieldsArray.push(field);
                }
            }
            var $dsContainer = $('<div data-ds="'+mecJson.name+'" data-sourceType="'+mecJson.sourceType+'"></div>');
            var done = $.Deferred();
            if(fieldsArray.length > 0){
                fieldsArray.forEach(function(item){
                    var $dsSpan = $('<span>'+item+'</span>').attr('data-name', mecJson.name).attr('data-key', item);
                    $dsContainer.append($dsSpan);
                });
            }

            if(tablesArray.length > 0){
                var datasource = mecJson["datasource"] || '$ECOLOGY_SYS_LOCAL_POOLNAME';

                require("utils").api("designer/plugin", {
                    action: "getFieldsByTableArray",
                    data: {
                        datasource: datasource,
                        tablenames: tablesArray.toString()
                    }
                }, function (result) {
                    var data = result.data;
                    if(data.length > 0){
                        data.forEach(function(item){
                            var $dsSpan = $('<span>'+item.column_name+'</span>').attr('data-name', mecJson.name).attr('data-key', item.column_name);
                            $dsContainer.append($dsSpan);
                        });
                    }
                    done.resolve();
                });
            } else {
                done.resolve();
            }

            done.then(function(){
                if($dsContainer.find('span').length == 0){
                    $('.ds-key-container').addClass('noresult');
                    return;
                }
                $('.ds-key-container').append($dsContainer).perfectScrollbar();
            });
            typeof(callback) == 'function' && done.then(callback);
        } else if(mecJson.sourceType == '2'){ //url
            $('.ds-key-container').addClass('noresult');
        } else if(mecJson.sourceType == '3'){ //api接口
            var apiConfig = mecJson.apiConfig;
            var apiId = apiConfig && apiConfig.api.id || "";
            var outFormat = mecJson.outFormat;
            require("utils").api("api", {
                action: "info",
                data: {
                    id: apiId
                },
            }, function (result) {
                var resultDefine = result.data.resultDefine || [];
                var data = [], resultKey = outFormat.DATAS;
                if(resultKey){
                    resultDefine.forEach(function(ele) {
                        var pname = ele.name;
                        if(pname !== resultKey && pname.substring(resultKey.length).indexOf(".") === 0){
                            data.push({
                                name: pname.substring(resultKey.length+1),
                                remark: ele.remark,
                                type: ele.type
                            });
                        }
                    });
                }else{
                    resultDefine.forEach(function(ele) {
                        data.push({
                            name: ele.name,
                            remark: ele.remark,
                            type: ele.type
                        });
                    });
                }

                var arrayResult = [], arrayResultClone, deep = 0;
                data.forEach(function(ele) {
                    if(ele.type === "ARRAY"){
                        arrayResult.push(ele.name);
                        deep = ele.name.split(".").length - 1;
                    }
                });
                //将["a", "a.b", "a.b.c"]转成["a", "a[0].b", "a[0].b[0].c"]
                if(deep > 0){
                    arrayResultClone = arrayResult.slice();
                    for(var i = 0; i < deep; i++){
                        arrayResult.forEach(function(akey) {
                            arrayResultClone.forEach(function(bkey, index) {
                                if(bkey.indexOf(akey+".") === 0){
                                    arrayResultClone[index] = bkey.replace(akey+".", akey+"[0].")
                                }
                            });
                        });
                        arrayResult = arrayResultClone.slice();
                    }
                }

                arrayResult.forEach(function(name, index) {
                    data.forEach(function(ele) {
                        if(ele.name.indexOf(name + ".") === 0){
                            ele.name = ele.name.replace(name + ".", name + "[0].")
                        }
                    });
                });

                var lang = top.require('i18n/lang');
                if(data.length > 0 ){
                    var $dsContainer = $('<div data-ds="'+mecJson.name+'" data-sourceType="'+mecJson.sourceType+'"></div>')
                    for(var i = 0; i < data.length; i++){
                        var labelName = lang.parse(data[i].remark);
                        var $dsKeySpan = $('<span>'+labelName+'</span>').attr('data-name', mecJson.name).attr('data-key', data[i].name);
                        $dsContainer.append($dsKeySpan);
                    }
                    $('.ds-key-container').append($dsContainer).perfectScrollbar();
                    typeof(callback) == 'function' && callback();
                } else {
                    $('.ds-key-container').addClass('noresult');
                }
            });
        }
    };

    dataSetPanel.pt.render = function() {
        var dp = this;

        dp.$el && dp.destory();
        
        dp.create().events().customEvents().position();

        dataSetPanel.renderDataSet();
        var dsName = dp.target.data('ds') && dp.target.data('ds').dsName || '';
        var dsId = dsName && $('li[data-name="'+dsName+'"]', dp.$el).eq(0).data('id');
        if(!dsName || !dsId){
            var $li1 = $('li[data-name]').eq(0);
            if($li1.length > 0){
                $li1.trigger('click');
            }
            return;
        }

        dsId && dataSetPanel.renderDataSetKey(dsId, function(){
            dp.$el.trigger('selected:ds');
        });
    };

    dataSetPanel.pt.create = function() {
        this.$el = $(template);
        $('body').append(this.$el);
        return this;
    };

    dataSetPanel.pt.events = function() {
        var dp = this,
            $el = dp.$el;
        var selectDskname = function(newDsKey) {
            dp.target.data('ds', newDsKey);
            $('textarea', dp.target).val('{'+newDsKey.dsName+'.'+newDsKey.dsKey+'}').trigger('change');
            dp.close();
        }

        $el.find('ul').on('click.ds', 'li', function() { // dstab
            var $dsLi = $(this);
            var dsId = $dsLi.data('id');

            $dsLi.addClass('active').siblings().removeClass('active');
            setTimeout(function() { // 切换dstab 自动focus searchinput
                var $dsKeyContainer = $('.ds-main');
                return function() {
                    if ($dsKeyContainer.find('input').length > 0) {
                        return $dsKeyContainer.find('input').focus();
                    }
                };
            }());
            dataSetPanel.renderDataSetKey(dsId);
            $('.dataset-panel .ds-key-container').scrollTop(0);
        });

        $el.find('.ds-main .ds-key-container').on('click', 'span', function() { // select ds
            var dsKey = $(this);
            var sourceType = dsKey.closest('div[data-ds]').data('sourcetype');
            var entryName = sourceType == '0' || sourceType == '3' ? dsKey.text() : '';
            var entry = {
                dsName: dsKey.data('name'),
                dsKey: dsKey.data('key'),
                entryName: entryName
            };

            selectDskname(entry);
        }).on('click', 'span.browser-span>div', function(e){
            var $browserSpan = $(this).parent();
            if(!$browserSpan.hasClass('reverse')){
                $browserSpan.next().css('display', 'block');
                $browserSpan.addClass('reverse');
            } else {
                $browserSpan.next().hide();
                $browserSpan.removeClass('reverse');
            }
            e.stopPropagation();
        });

        $el.find('.ds-main').on('input', '.ds-key-search input', function() { // search ds
            var inputEl = $(this),
                val = common.toLowerCase(inputEl.val()),
                dsKeyContainer = inputEl.parent().next(),
                keyEls = dsKeyContainer.find('div[data-ds]:visible span:not(.hidden-id)'),
                hasresult = false, // 是否存在搜索结果
                ismatch = false; // 是否匹配搜索项

            if (keyEls.length == 0) return;

            keyEls.each(function(index, keyEl) {
                keyEl = $(keyEl);
                ismatch = common.toLowerCase(keyEl.text()).indexOf(val) != -1;
                hasresult = ismatch || hasresult;

                keyEl.toggle(ismatch);
            });

            dsKeyContainer.toggleClass('noresult', !hasresult);
        }).on('mouseover', 'span', function() { // hover 背景色改变
            var selectedDsk = $(this).parent().find('.selected')

            if (!selectedDsk.hasClass('over')) selectedDsk.addClass('over');
        });

        $el.off('mousedown').on('mousedown', function(e) { // 禁止冒泡关闭
            e.stopPropagation();
        });

        $('body').one('mousedown.dsPanel', function() { // 全局关闭
            dp.close();
        });

        return dp;
    };

    dataSetPanel.pt.customEvents = function() {
        var dp = this,
            $el = dp.$el;

        $el.on('selected:ds', function() {
            var dsKeyEl, dsTabEl, dsParent;

            var dsName = dp.target.data('ds').dsName || '';
            var dsKey = dp.target.data('ds').dsKey || '';

            if(dsName == '' && dsKey == ''){
                if($('li[data-id]', $el).length > 0){
                    dsTabEl = $('li[data-id]').eq(0);
                }
            } else {
                dsTabEl = $('li[data-id][data-name="' + dsName + '"]');
                dsKeyEl = $('.ds-key-container > div[data-ds="'+dsName+'"] span[data-key="'+dsKey+'"]').eq(0).addClass('selected');
                dsParent = dsKeyEl.parents('.ds-key-container');
                setTimeout(function(){
                    dsKeyEl.length > 0 && dsParent.scrollTop(dsKeyEl.offset().top - dsParent.offset().top - dsParent.scrollTop());
                });
            }
            dsTabEl.trigger('click');
        });

        return this;
    };

    dataSetPanel.pt.position = function() {
        var position = common.position(this.target, this.$el);
        
        this.$el.toggleClass('pos-top', !!position);

        return this;
    };

    dataSetPanel.pt.destory = function() {
        this.$el.remove();
    }

    dataSetPanel.pt.close = function() {
        var dp = this;

        dp.destory();
        dp.afterClose(dp.target);
    };

    return {
        run: function(settings) {
            return new dataSetPanel(settings);
        },
        show: function(target, settings) {
            var panel = new dataSetPanel(settings||{});

            panel.target = $(target);
            panel.render();
        },
        close: function() {
            var panel = new dataSetPanel();

            panel.close();
        },
        setDataSet: function(el, ds) {
            var $el = $(el);
            $el.data('ds', ds);
        },
        loadDataSetItems: function(callback) {
            callback();
        }
    };
});