From 5bf66662a9bdd62c5bccab15e607cd95cfb8fcab Mon Sep 17 00:00:00 2001 From: Charles Cabergs Date: Mon, 27 Jul 2020 10:05:23 +0200 Subject: Removed wordpress and phpmyadmin, my server doesn't handle it well and it brings shame on my familly --- srcs/phpmyadmin/js/designer/history.js | 859 --------------------------------- 1 file changed, 859 deletions(-) delete mode 100644 srcs/phpmyadmin/js/designer/history.js (limited to 'srcs/phpmyadmin/js/designer/history.js') diff --git a/srcs/phpmyadmin/js/designer/history.js b/srcs/phpmyadmin/js/designer/history.js deleted file mode 100644 index 0c30e75..0000000 --- a/srcs/phpmyadmin/js/designer/history.js +++ /dev/null @@ -1,859 +0,0 @@ -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * @fileoverview function used in this file builds history tab and generates query. - * - * @requires jQuery - * @requires move.js - * @version $Id$ - */ - -/* global contr */ // js/designer/init.js -/* global fromArray:writable */ // js/designer/move.js -/* global pmaThemeImage */ // js/messages.php - -var DesignerHistory = {}; - -var historyArray = []; // Global array to store history objects -var selectField = []; // Global array to store information for columns which are used in select clause -var gIndex; -var vqbEditor = null; - -/** - * To display details of objects(where,rename,Having,aggregate,groupby,orderby,having) - * - * @param index index of historyArray where change is to be made - * -**/ - -DesignerHistory.detail = function (index) { - var type = historyArray[index].getType(); - var str; - if (type === 'Where') { - str = 'Where ' + historyArray[index].getColumnName() + historyArray[index].getObj().getRelationOperator() + historyArray[index].getObj().getQuery(); - } - if (type === 'Rename') { - str = 'Rename ' + historyArray[index].getColumnName() + ' To ' + historyArray[index].getObj().getRenameTo(); - } - if (type === 'Aggregate') { - str = 'Select ' + historyArray[index].getObj().getOperator() + '( ' + historyArray[index].getColumnName() + ' )'; - } - if (type === 'GroupBy') { - str = 'GroupBy ' + historyArray[index].getColumnName(); - } - if (type === 'OrderBy') { - str = 'OrderBy ' + historyArray[index].getColumnName() + ' ' + historyArray[index].getObj().getOrder(); - } - if (type === 'Having') { - str = 'Having '; - if (historyArray[index].getObj().getOperator() !== 'None') { - str += historyArray[index].getObj().getOperator() + '( ' + historyArray[index].getColumnName() + ' )'; - str += historyArray[index].getObj().getRelationOperator() + historyArray[index].getObj().getQuery(); - } else { - str = 'Having ' + historyArray[index].getColumnName() + historyArray[index].getObj().getRelationOperator() + historyArray[index].getObj().getQuery(); - } - } - return str; -}; - -/** - * Sorts historyArray[] first,using table name as the key and then generates the HTML code for history tab, - * clubbing all objects of same tables together - * This function is called whenever changes are made in historyArray[] - * - * - * @param {int} init starting index of unsorted array - * @param {int} finit last index of unsorted array - * -**/ - -DesignerHistory.display = function (init, finit) { - var str; - var i; - var j; - var k; - var sto; - var temp; - // this part sorts the history array based on table name,this is needed for clubbing all object of same name together. - for (i = init; i < finit; i++) { - sto = historyArray[i]; - temp = historyArray[i].getTab();// + '.' + historyArray[i].getObjNo(); for Self JOINS - for (j = 0; j < i; j++) { - if (temp > (historyArray[j].getTab())) {// + '.' + historyArray[j].getObjNo())) { //for Self JOINS - for (k = i; k > j; k--) { - historyArray[k] = historyArray[k - 1]; - } - historyArray[j] = sto; - break; - } - } - } - // this part generates HTML code for history tab.adds delete,edit,and/or and detail features with objects. - str = ''; // string to store Html code for history tab - for (i = 0; i < historyArray.length; i++) { - temp = historyArray[i].getTab(); // + '.' + historyArray[i].getObjNo(); for Self JOIN - str += '

' + temp + '

'; - str += '
\n'; - while ((historyArray[i].getTab()) === temp) { // + '.' + historyArray[i].getObjNo()) === temp) { - str += '
'; - str += ''; - } else { - str += ''; - } - str += '' + - '' + - '' + - ''; - } else { - var detailDesc = $('
').text(DesignerHistory.detail(i)).html(); - str += '
' + - '' + - '' + - ''; - } - str += ''; - i++; - if (i >= historyArray.length) { - break; - } - str += '
'; - if (historyArray[i].getAndOr()) { - str += '' + Functions.getImage('b_sbrowse', Messages.strColumnName) + '' + $('
').text(historyArray[i].getColumnName()).html() + '
'; - if (historyArray[i].getType() === 'GroupBy' || historyArray[i].getType() === 'OrderBy') { - var detailDescGroupBy = $('
').text(DesignerHistory.detail(i)).html(); - str += '
' + Functions.getImage('s_info', DesignerHistory.detail(i)) + '' + historyArray[i].getType() + '' + Functions.getImage('b_drop', Messages.strDelete) + '' + Functions.getImage('s_info', DesignerHistory.detail(i)) + '' + historyArray[i].getType() + '' + Functions.getImage('b_edit', Messages.strEdit) + '' + Functions.getImage('b_drop', Messages.strDelete) + '
'; - } - i--; - str += '
'; - } - return str; -}; - -/** - * To change And/Or relation in history tab - * - * - * @param {int} index of historyArray where change is to be made - * -**/ - -DesignerHistory.andOr = function (index) { - if (historyArray[index].getAndOr()) { - historyArray[index].setAndOr(0); - } else { - historyArray[index].setAndOr(1); - } - var existingDiv = document.getElementById('ab'); - existingDiv.innerHTML = DesignerHistory.display(0, 0); - $('#ab').accordion('refresh'); -}; - -/** - * Deletes entry in historyArray - * - * @param index index of historyArray[] which is to be deleted - * -**/ - -DesignerHistory.historyDelete = function (index) { - for (var k = 0; k < fromArray.length; k++) { - if (fromArray[k] === historyArray[index].getTab()) { - fromArray.splice(k, 1); - break; - } - } - historyArray.splice(index, 1); - var existingDiv = document.getElementById('ab'); - existingDiv.innerHTML = DesignerHistory.display(0, 0); - $('#ab').accordion('refresh'); -}; - -/** - * To show where,rename,aggregate,having forms to edit a object - * - * @param{int} index index of historyArray where change is to be made - * -**/ - -DesignerHistory.historyEdit = function (index) { - gIndex = index; - var type = historyArray[index].getType(); - if (type === 'Where') { - document.getElementById('eQuery').value = historyArray[index].getObj().getQuery(); - document.getElementById('erel_opt').value = historyArray[index].getObj().getRelationOperator(); - document.getElementById('query_where').style.left = '530px'; - document.getElementById('query_where').style.top = '130px'; - document.getElementById('query_where').style.position = 'absolute'; - document.getElementById('query_where').style.zIndex = '103'; - document.getElementById('query_where').style.visibility = 'visible'; - document.getElementById('query_where').style.display = 'block'; - } - if (type === 'Having') { - document.getElementById('hQuery').value = historyArray[index].getObj().getQuery(); - document.getElementById('hrel_opt').value = historyArray[index].getObj().getRelationOperator(); - document.getElementById('hoperator').value = historyArray[index].getObj().getOperator(); - document.getElementById('query_having').style.left = '530px'; - document.getElementById('query_having').style.top = '130px'; - document.getElementById('query_having').style.position = 'absolute'; - document.getElementById('query_having').style.zIndex = '103'; - document.getElementById('query_having').style.visibility = 'visible'; - document.getElementById('query_having').style.display = 'block'; - } - if (type === 'Rename') { - document.getElementById('e_rename').value = historyArray[index].getObj().getRenameTo(); - document.getElementById('query_rename_to').style.left = '530px'; - document.getElementById('query_rename_to').style.top = '130px'; - document.getElementById('query_rename_to').style.position = 'absolute'; - document.getElementById('query_rename_to').style.zIndex = '103'; - document.getElementById('query_rename_to').style.visibility = 'visible'; - document.getElementById('query_rename_to').style.display = 'block'; - } - if (type === 'Aggregate') { - document.getElementById('e_operator').value = historyArray[index].getObj().getOperator(); - document.getElementById('query_Aggregate').style.left = '530px'; - document.getElementById('query_Aggregate').style.top = '130px'; - document.getElementById('query_Aggregate').style.position = 'absolute'; - document.getElementById('query_Aggregate').style.zIndex = '103'; - document.getElementById('query_Aggregate').style.visibility = 'visible'; - document.getElementById('query_Aggregate').style.display = 'block'; - } -}; - -/** - * Make changes in historyArray when Edit button is clicked - * checks for the type of object and then sets the new value - * - * @param index index of historyArray where change is to be made -**/ - -DesignerHistory.edit = function (type) { - if (type === 'Rename') { - if (document.getElementById('e_rename').value !== '') { - historyArray[gIndex].getObj().setRenameTo(document.getElementById('e_rename').value); - document.getElementById('e_rename').value = ''; - } - document.getElementById('query_rename_to').style.visibility = 'hidden'; - } - if (type === 'Aggregate') { - if (document.getElementById('e_operator').value !== '---') { - historyArray[gIndex].getObj().setOperator(document.getElementById('e_operator').value); - document.getElementById('e_operator').value = '---'; - } - document.getElementById('query_Aggregate').style.visibility = 'hidden'; - } - if (type === 'Where') { - if (document.getElementById('erel_opt').value !== '--' && document.getElementById('eQuery').value !== '') { - historyArray[gIndex].getObj().setQuery(document.getElementById('eQuery').value); - historyArray[gIndex].getObj().setRelationOperator(document.getElementById('erel_opt').value); - } - document.getElementById('query_where').style.visibility = 'hidden'; - } - if (type === 'Having') { - if (document.getElementById('hrel_opt').value !== '--' && document.getElementById('hQuery').value !== '') { - historyArray[gIndex].getObj().setQuery(document.getElementById('hQuery').value); - historyArray[gIndex].getObj().setRelationOperator(document.getElementById('hrel_opt').value); - historyArray[gIndex].getObj().setOperator(document.getElementById('hoperator').value); - } - document.getElementById('query_having').style.visibility = 'hidden'; - } - var existingDiv = document.getElementById('ab'); - existingDiv.innerHTML = DesignerHistory.display(0, 0); - $('#ab').accordion('refresh'); -}; - -/** - * history object closure - * - * @param nColumnName name of the column on which conditions are put - * @param nObj object details(where,rename,orderby,groupby,aggregate) - * @param nTab table name of the column on which conditions are applied - * @param nObjNo object no used for inner join - * @param nType type of object - * -**/ - -DesignerHistory.HistoryObj = function (nColumnName, nObj, nTab, nObjNo, nType) { - var andOr; - var obj; - var tab; - var columnName; - var objNo; - var type; - this.setColumnName = function (nColumnName) { - columnName = nColumnName; - }; - this.getColumnName = function () { - return columnName; - }; - this.setAndOr = function (nAndOr) { - andOr = nAndOr; - }; - this.getAndOr = function () { - return andOr; - }; - this.getRelation = function () { - return andOr; - }; - this.setObj = function (nObj) { - obj = nObj; - }; - this.getObj = function () { - return obj; - }; - this.setTab = function (nTab) { - tab = nTab; - }; - this.getTab = function () { - return tab; - }; - this.setObjNo = function (nObjNo) { - objNo = nObjNo; - }; - this.getObjNo = function () { - return objNo; - }; - this.setType = function (nType) { - type = nType; - }; - this.getType = function () { - return type; - }; - this.setObjNo(nObjNo); - this.setTab(nTab); - this.setAndOr(0); - this.setObj(nObj); - this.setColumnName(nColumnName); - this.setType(nType); -}; - -/** - * where object closure, makes an object with all information of where - * - * @param nRelationOperator type of relation operator to be applied - * @param nQuery stores value of value/sub-query - * -**/ - - -DesignerHistory.Where = function (nRelationOperator, nQuery) { - var relationOperator; - var query; - this.setRelationOperator = function (nRelationOperator) { - relationOperator = nRelationOperator; - }; - this.setQuery = function (nQuery) { - query = nQuery; - }; - this.getQuery = function () { - return query; - }; - this.getRelationOperator = function () { - return relationOperator; - }; - this.setQuery(nQuery); - this.setRelationOperator(nRelationOperator); -}; - -/** - * Orderby object closure - * - * @param nOrder order, ASC or DESC - */ -DesignerHistory.OrderBy = function (nOrder) { - var order; - this.setOrder = function (nOrder) { - order = nOrder; - }; - this.getOrder = function () { - return order; - }; - this.setOrder(nOrder); -}; - -/** - * Having object closure, makes an object with all information of where - * - * @param nRelationOperator type of relation operator to be applied - * @param nQuery stores value of value/sub-query - * @param nOperator operator -**/ - -DesignerHistory.Having = function (nRelationOperator, nQuery, nOperator) { - var relationOperator; - var query; - var operator; - this.setOperator = function (nOperator) { - operator = nOperator; - }; - this.setRelationOperator = function (nRelationOperator) { - relationOperator = nRelationOperator; - }; - this.setQuery = function (nQuery) { - query = nQuery; - }; - this.getQuery = function () { - return query; - }; - this.getRelationOperator = function () { - return relationOperator; - }; - this.getOperator = function () { - return operator; - }; - this.setQuery(nQuery); - this.setRelationOperator(nRelationOperator); - this.setOperator(nOperator); -}; - -/** - * rename object closure,makes an object with all information of rename - * - * @param nRenameTo new name information - * -**/ - -DesignerHistory.Rename = function (nRenameTo) { - var renameTo; - this.setRenameTo = function (nRenameTo) { - renameTo = nRenameTo; - }; - this.getRenameTo = function () { - return renameTo; - }; - this.setRenameTo(nRenameTo); -}; - -/** - * aggregate object closure - * - * @param nOperator aggregte operator - * -**/ - -DesignerHistory.Aggregate = function (nOperator) { - var operator; - this.setOperator = function (nOperator) { - operator = nOperator; - }; - this.getOperator = function () { - return operator; - }; - this.setOperator(nOperator); -}; - -/** - * This function returns unique element from an array - * - * @param arrayName array from which duplicate elem are to be removed. - * @return unique array - */ - -DesignerHistory.unique = function (arrayName) { - var newArray = []; - uniquetop: - for (var i = 0; i < arrayName.length; i++) { - for (var j = 0; j < newArray.length; j++) { - if (newArray[j] === arrayName[i]) { - continue uniquetop; - } - } - newArray[newArray.length] = arrayName[i]; - } - return newArray; -}; - -/** - * This function takes in array and a value as input and returns 1 if values is present in array - * else returns -1 - * - * @param arrayName array - * @param value value which is to be searched in the array - */ - -DesignerHistory.found = function (arrayName, value) { - for (var i = 0; i < arrayName.length; i++) { - if (arrayName[i] === value) { - return 1; - } - } - return -1; -}; - -/** - * This function concatenates two array - * - * @params add array elements of which are pushed in - * @params arr array in which elements are added - */ -DesignerHistory.addArray = function (add, arr) { - for (var i = 0; i < add.length; i++) { - arr.push(add[i]); - } - return arr; -}; - -/** - * This function removes all elements present in one array from the other. - * - * @params rem array from which each element is removed from other array. - * @params arr array from which elements are removed. - * - */ -DesignerHistory.removeArray = function (rem, arr) { - for (var i = 0; i < rem.length; i++) { - for (var j = 0; j < arr.length; j++) { - if (rem[i] === arr[j]) { - arr.splice(j, 1); - } - } - } - return arr; -}; - -/** - * This function builds the groupby clause from history object - * - */ - -DesignerHistory.queryGroupBy = function () { - var i; - var str = ''; - for (i = 0; i < historyArray.length; i++) { - if (historyArray[i].getType() === 'GroupBy') { - str += '`' + historyArray[i].getColumnName() + '`, '; - } - } - str = str.substr(0, str.length - 2); - return str; -}; - -/** - * This function builds the Having clause from the history object. - * - */ - -DesignerHistory.queryHaving = function () { - var i; - var and = '('; - for (i = 0; i < historyArray.length; i++) { - if (historyArray[i].getType() === 'Having') { - if (historyArray[i].getObj().getOperator() !== 'None') { - and += historyArray[i].getObj().getOperator() + '(`' + historyArray[i].getColumnName() + '`) ' + historyArray[i].getObj().getRelationOperator(); - and += ' ' + historyArray[i].getObj().getQuery() + ', '; - } else { - and += '`' + historyArray[i].getColumnName() + '` ' + historyArray[i].getObj().getRelationOperator() + ' ' + historyArray[i].getObj().getQuery() + ', '; - } - } - } - if (and === '(') { - and = ''; - } else { - and = and.substr(0, and.length - 2) + ')'; - } - return and; -}; - - -/** - * This function builds the orderby clause from the history object. - * - */ - -DesignerHistory.queryOrderBy = function () { - var i; - var str = ''; - for (i = 0; i < historyArray.length; i++) { - if (historyArray[i].getType() === 'OrderBy') { - str += '`' + historyArray[i].getColumnName() + '` ' + - historyArray[i].getObj().getOrder() + ', '; - } - } - str = str.substr(0, str.length - 2); - return str; -}; - - -/** - * This function builds the Where clause from the history object. - * - */ - -DesignerHistory.queryWhere = function () { - var i; - var and = '('; - var or = '('; - for (i = 0; i < historyArray.length; i++) { - if (historyArray[i].getType() === 'Where') { - if (historyArray[i].getAndOr() === 0) { - and += '( `' + historyArray[i].getColumnName() + '` ' + historyArray[i].getObj().getRelationOperator() + ' ' + historyArray[i].getObj().getQuery() + ')'; - and += ' AND '; - } else { - or += '( `' + historyArray[i].getColumnName() + '` ' + historyArray[i].getObj().getRelationOperator() + ' ' + historyArray[i].getObj().getQuery() + ')'; - or += ' OR '; - } - } - } - if (or !== '(') { - or = or.substring(0, (or.length - 4)) + ')'; - } else { - or = ''; - } - if (and !== '(') { - and = and.substring(0, (and.length - 5)) + ')'; - } else { - and = ''; - } - if (or !== '') { - and = and + ' OR ' + or + ' )'; - } - return and; -}; - -DesignerHistory.checkAggregate = function (idThis) { - var i; - for (i = 0; i < historyArray.length; i++) { - var temp = '`' + historyArray[i].getTab() + '`.`' + historyArray[i].getColumnName() + '`'; - if (temp === idThis && historyArray[i].getType() === 'Aggregate') { - return historyArray[i].getObj().getOperator() + '(' + idThis + ')'; - } - } - return ''; -}; - -DesignerHistory.checkRename = function (idThis) { - var i; - for (i = 0; i < historyArray.length; i++) { - var temp = '`' + historyArray[i].getTab() + '`.`' + historyArray[i].getColumnName() + '`'; - if (temp === idThis && historyArray[i].getType() === 'Rename') { - return ' AS `' + historyArray[i].getObj().getRenameTo() + '`'; - } - } - return ''; -}; - -/** - * This function builds from clause of query - * makes automatic joins. - * - * - */ -DesignerHistory.queryFrom = function () { - var i; - var tabLeft = []; - var tabUsed = []; - var tTabLeft = []; - var temp; - var query = ''; - var quer = ''; - var parts = []; - var tArray = []; - tArray = fromArray; - var K = 0; - var k; - var key; - var key2; - var key3; - var parts1; - - // the constraints that have been used in the LEFT JOIN - var constraintsAdded = []; - - for (i = 0; i < historyArray.length; i++) { - fromArray.push(historyArray[i].getTab()); - } - fromArray = DesignerHistory.unique(fromArray); - tabLeft = fromArray; - temp = tabLeft.shift(); - quer = '`' + temp + '`'; - tabUsed.push(temp); - - // if master table (key2) matches with tab used get all keys and check if tab_left matches - // after this check if master table (key2) matches with tab left then check if any foreign matches with master . - for (i = 0; i < 2; i++) { - for (K in contr) { - for (key in contr[K]) {// contr name - for (key2 in contr[K][key]) {// table name - parts = key2.split('.'); - if (DesignerHistory.found(tabUsed, parts[1]) > 0) { - for (key3 in contr[K][key][key2]) { - parts1 = contr[K][key][key2][key3][0].split('.'); - if (DesignerHistory.found(tabLeft, parts1[1]) > 0) { - if (DesignerHistory.found(constraintsAdded, key) > 0) { - query += ' AND ' + '`' + parts[1] + '`.`' + key3 + '` = '; - query += '`' + parts1[1] + '`.`' + contr[K][key][key2][key3][1] + '` '; - } else { - query += '\n' + 'LEFT JOIN '; - query += '`' + parts[1] + '` ON '; - query += '`' + parts1[1] + '`.`' + contr[K][key][key2][key3][1] + '` = '; - query += '`' + parts[1] + '`.`' + key3 + '` '; - - constraintsAdded.push(key); - } - tTabLeft.push(parts[1]); - } - } - } - } - } - } - K = 0; - tTabLeft = DesignerHistory.unique(tTabLeft); - tabUsed = DesignerHistory.addArray(tTabLeft, tabUsed); - tabLeft = DesignerHistory.removeArray(tTabLeft, tabLeft); - tTabLeft = []; - for (K in contr) { - for (key in contr[K]) { - for (key2 in contr[K][key]) {// table name - parts = key2.split('.'); - if (DesignerHistory.found(tabLeft, parts[1]) > 0) { - for (key3 in contr[K][key][key2]) { - parts1 = contr[K][key][key2][key3][0].split('.'); - if (DesignerHistory.found(tabUsed, parts1[1]) > 0) { - if (DesignerHistory.found(constraintsAdded, key) > 0) { - query += ' AND ' + '`' + parts[1] + '`.`' + key3 + '` = '; - query += '`' + parts1[1] + '`.`' + contr[K][key][key2][key3][1] + '` '; - } else { - query += '\n' + 'LEFT JOIN '; - query += '`' + parts[1] + '` ON '; - query += '`' + parts1[1] + '`.`' + contr[K][key][key2][key3][1] + '` = '; - query += '`' + parts[1] + '`.`' + key3 + '` '; - - constraintsAdded.push(key); - } - tTabLeft.push(parts[1]); - } - } - } - } - } - } - tTabLeft = DesignerHistory.unique(tTabLeft); - tabUsed = DesignerHistory.addArray(tTabLeft, tabUsed); - tabLeft = DesignerHistory.removeArray(tTabLeft, tabLeft); - tTabLeft = []; - } - for (k in tabLeft) { - quer += ' , `' + tabLeft[k] + '`'; - } - query = quer + query; - fromArray = tArray; - return query; -}; - -/** - * This function is the main function for query building. - * uses history object details for this. - * - * @uses DesignerHistory.queryWhere() - * @uses DesignerHistory.queryGroupBy() - * @uses DesignerHistory.queryHaving() - * @uses DesignerHistory.queryOrderBy() - */ -DesignerHistory.buildQuery = function () { - var qSelect = 'SELECT '; - var temp; - if (selectField.length > 0) { - for (var i = 0; i < selectField.length; i++) { - temp = DesignerHistory.checkAggregate(selectField[i]); - if (temp !== '') { - qSelect += temp; - temp = DesignerHistory.checkRename(selectField[i]); - qSelect += temp + ', '; - } else { - temp = DesignerHistory.checkRename(selectField[i]); - qSelect += selectField[i] + temp + ', '; - } - } - qSelect = qSelect.substring(0, qSelect.length - 2); - } else { - qSelect += '* '; - } - - qSelect += '\nFROM ' + DesignerHistory.queryFrom(); - - var qWhere = DesignerHistory.queryWhere(); - if (qWhere !== '') { - qSelect += '\nWHERE ' + qWhere; - } - - var qGroupBy = DesignerHistory.queryGroupBy(); - if (qGroupBy !== '') { - qSelect += '\nGROUP BY ' + qGroupBy; - } - - var qHaving = DesignerHistory.queryHaving(); - if (qHaving !== '') { - qSelect += '\nHAVING ' + qHaving; - } - - var qOrderBy = DesignerHistory.queryOrderBy(); - if (qOrderBy !== '') { - qSelect += '\nORDER BY ' + qOrderBy; - } - - /** - * @var button_options Object containing options - * for jQueryUI dialog buttons - */ - var buttonOptions = {}; - buttonOptions[Messages.strClose] = function () { - $(this).dialog('close'); - }; - buttonOptions[Messages.strSubmit] = function () { - if (vqbEditor) { - var $elm = $ajaxDialog.find('textarea'); - vqbEditor.save(); - $elm.val(vqbEditor.getValue()); - } - $('#vqb_form').trigger('submit'); - }; - - var $ajaxDialog = $('#box').dialog({ - appendTo: '#page_content', - width: 500, - buttons: buttonOptions, - modal: true, - title: 'SELECT' - }); - // Attach syntax highlighted editor to query dialog - /** - * @var $elm jQuery object containing the reference - * to the query textarea. - */ - var $elm = $ajaxDialog.find('textarea'); - if (! vqbEditor) { - vqbEditor = Functions.getSqlEditor($elm); - } - if (vqbEditor) { - vqbEditor.setValue(qSelect); - vqbEditor.focus(); - } else { - $elm.val(qSelect); - $elm.trigger('focus'); - } -}; - -AJAX.registerTeardown('designer/history.js', function () { - vqbEditor = null; - historyArray = []; - selectField = []; - $('#ok_edit_rename').off('click'); - $('#ok_edit_having').off('click'); - $('#ok_edit_Aggr').off('click'); - $('#ok_edit_where').off('click'); -}); - -AJAX.registerOnload('designer/history.js', function () { - $('#ok_edit_rename').on('click', function () { - DesignerHistory.edit('Rename'); - }); - $('#ok_edit_having').on('click', function () { - DesignerHistory.edit('Having'); - }); - $('#ok_edit_Aggr').on('click', function () { - DesignerHistory.edit('Aggregate'); - }); - $('#ok_edit_where').on('click', function () { - DesignerHistory.edit('Where'); - }); - $('#ab').accordion({ collapsible : true, active : 'none' }); -}); -- cgit