From 04d6d5ca99ebfd1cebb8ce06618fb3811fc1a8aa Mon Sep 17 00:00:00 2001 From: Charles Date: Thu, 9 Jan 2020 10:55:03 +0100 Subject: phpmyadmin working --- srcs/phpmyadmin/js/designer/database.js | 149 +++ srcs/phpmyadmin/js/designer/history.js | 859 ++++++++++++ srcs/phpmyadmin/js/designer/init.js | 75 ++ srcs/phpmyadmin/js/designer/move.js | 2214 +++++++++++++++++++++++++++++++ srcs/phpmyadmin/js/designer/objects.js | 17 + srcs/phpmyadmin/js/designer/page.js | 169 +++ 6 files changed, 3483 insertions(+) create mode 100644 srcs/phpmyadmin/js/designer/database.js create mode 100644 srcs/phpmyadmin/js/designer/history.js create mode 100644 srcs/phpmyadmin/js/designer/init.js create mode 100644 srcs/phpmyadmin/js/designer/move.js create mode 100644 srcs/phpmyadmin/js/designer/objects.js create mode 100644 srcs/phpmyadmin/js/designer/page.js (limited to 'srcs/phpmyadmin/js/designer') diff --git a/srcs/phpmyadmin/js/designer/database.js b/srcs/phpmyadmin/js/designer/database.js new file mode 100644 index 0000000..f8456d1 --- /dev/null +++ b/srcs/phpmyadmin/js/designer/database.js @@ -0,0 +1,149 @@ +var designerTables = [ + { + name: 'pdf_pages', + key: 'pgNr', + autoIncrement: true + }, + { + name: 'table_coords', + key: 'id', + autoIncrement: true + } +]; + +// eslint-disable-next-line no-unused-vars +var DesignerOfflineDB = (function () { + var designerDB = {}; + var datastore = null; + + designerDB.open = function (callback) { + var version = 1; + var request = window.indexedDB.open('pma_designer', version); + + request.onupgradeneeded = function (e) { + var db = e.target.result; + e.target.transaction.onerror = designerDB.onerror; + + var t; + for (t in designerTables) { + if (db.objectStoreNames.contains(designerTables[t].name)) { + db.deleteObjectStore(designerTables[t].name); + } + } + + for (t in designerTables) { + db.createObjectStore(designerTables[t].name, { + keyPath: designerTables[t].key, + autoIncrement: designerTables[t].autoIncrement + }); + } + }; + + request.onsuccess = function (e) { + datastore = e.target.result; + if (typeof callback !== 'undefined' && callback !== null) { + callback(true); + } + }; + + request.onerror = designerDB.onerror; + }; + + designerDB.loadObject = function (table, id, callback) { + var db = datastore; + var transaction = db.transaction([table], 'readwrite'); + var objStore = transaction.objectStore(table); + var cursorRequest = objStore.get(parseInt(id)); + + cursorRequest.onsuccess = function (e) { + callback(e.target.result); + }; + + cursorRequest.onerror = designerDB.onerror; + }; + + designerDB.loadAllObjects = function (table, callback) { + var db = datastore; + var transaction = db.transaction([table], 'readwrite'); + var objStore = transaction.objectStore(table); + var keyRange = IDBKeyRange.lowerBound(0); + var cursorRequest = objStore.openCursor(keyRange); + var results = []; + + transaction.oncomplete = function () { + callback(results); + }; + + cursorRequest.onsuccess = function (e) { + var result = e.target.result; + if (Boolean(result) === false) { + return; + } + results.push(result.value); + result.continue(); + }; + + cursorRequest.onerror = designerDB.onerror; + }; + + designerDB.loadFirstObject = function (table, callback) { + var db = datastore; + var transaction = db.transaction([table], 'readwrite'); + var objStore = transaction.objectStore(table); + var keyRange = IDBKeyRange.lowerBound(0); + var cursorRequest = objStore.openCursor(keyRange); + var firstResult = null; + + transaction.oncomplete = function () { + callback(firstResult); + }; + + cursorRequest.onsuccess = function (e) { + var result = e.target.result; + if (Boolean(result) === false) { + return; + } + firstResult = result.value; + }; + + cursorRequest.onerror = designerDB.onerror; + }; + + designerDB.addObject = function (table, obj, callback) { + var db = datastore; + var transaction = db.transaction([table], 'readwrite'); + var objStore = transaction.objectStore(table); + var request = objStore.put(obj); + + request.onsuccess = function (e) { + if (typeof callback !== 'undefined' && callback !== null) { + callback(e.currentTarget.result); + } + }; + + request.onerror = designerDB.onerror; + }; + + designerDB.deleteObject = function (table, id, callback) { + var db = datastore; + var transaction = db.transaction([table], 'readwrite'); + var objStore = transaction.objectStore(table); + var request = objStore.delete(parseInt(id)); + + request.onsuccess = function () { + if (typeof callback !== 'undefined' && callback !== null) { + callback(true); + } + }; + + request.onerror = designerDB.onerror; + }; + + designerDB.onerror = function (e) { + // eslint-disable-next-line no-console + console.log(e); + }; + + // Export the designerDB object. + return designerDB; +}()); diff --git a/srcs/phpmyadmin/js/designer/history.js b/srcs/phpmyadmin/js/designer/history.js new file mode 100644 index 0000000..0c30e75 --- /dev/null +++ b/srcs/phpmyadmin/js/designer/history.js @@ -0,0 +1,859 @@ +/* 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' }); +}); diff --git a/srcs/phpmyadmin/js/designer/init.js b/srcs/phpmyadmin/js/designer/init.js new file mode 100644 index 0000000..81ec1e4 --- /dev/null +++ b/srcs/phpmyadmin/js/designer/init.js @@ -0,0 +1,75 @@ +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * Initialises the data required to run Designer, then fires it up. + */ + +/* global DesignerOfflineDB */ // js/designer/database.js +/* global DesignerHistory */ // js/designer/history.js +/* global DesignerMove */ // js/designer/move.js +/* global DesignerPage */ // js/designer/page.js +/* global designerConfig */ // templates/database/designer/main.twig + +/* eslint-disable no-unused-vars */ +var jTabs; +var hTabs; +var contr; +var displayField; +var server; +var selectedPage; +/* eslint-enable no-unused-vars */ + +var db; +var designerTablesEnabled; + +AJAX.registerTeardown('designer/init.js', function () { + $('.trigger').off('click'); +}); + +AJAX.registerOnload('designer/init.js', function () { + $('.trigger').on('click', function () { + $('.panel').toggle('fast'); + $(this).toggleClass('active'); + $('#ab').accordion('refresh'); + return false; + }); + + jTabs = designerConfig.scriptTables.j_tabs; + hTabs = designerConfig.scriptTables.h_tabs; + contr = designerConfig.scriptContr; + displayField = designerConfig.scriptDisplayField; + + server = designerConfig.server; + db = designerConfig.db; + selectedPage = designerConfig.displayPage; + designerTablesEnabled = designerConfig.tablesEnabled; + + DesignerMove.main(); + + if (! designerTablesEnabled) { + DesignerOfflineDB.open(function (success) { + if (success) { + DesignerPage.showTablesInLandingPage(db); + } + }); + } + + $('#query_Aggregate_Button').on('click', function () { + document.getElementById('query_Aggregate').style.display = 'none'; + }); + + $('#query_having_button').on('click', function () { + document.getElementById('query_having').style.display = 'none'; + }); + + $('#query_rename_to_button').on('click', function () { + document.getElementById('query_rename_to').style.display = 'none'; + }); + + $('#build_query_button').on('click', function () { + DesignerHistory.buildQuery('SQL Query on Database', 0); + }); + + $('#query_where_button').on('click', function () { + document.getElementById('query_where').style.display = 'none'; + }); +}); diff --git a/srcs/phpmyadmin/js/designer/move.js b/srcs/phpmyadmin/js/designer/move.js new file mode 100644 index 0000000..513dd06 --- /dev/null +++ b/srcs/phpmyadmin/js/designer/move.js @@ -0,0 +1,2214 @@ +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * @package PhpMyAdmin-Designer + */ + +/* global DesignerObjects */ // js/designer/objects.js +/* global DesignerHistory, historyArray, selectField */ // js/designer/history.js +/* global contr, db, designerTablesEnabled, displayField, hTabs, jTabs, selectedPage:writable, server */ // js/designer/init.js +/* global DesignerPage */ // js/designer/page.js +/* global pmaThemeImage */ // js/messages.php + +var DesignerMove = {}; + +var change = 0; // variable to track any change in designer layout. +var showRelationLines = true; +var alwaysShowText = false; + +AJAX.registerTeardown('designer/move.js', function () { + $(document).off('fullscreenchange'); + $('#selflink').show(); +}); + +AJAX.registerOnload('designer/move.js', function () { + $('#page_content').css({ 'margin-left': '3px' }); + $(document).on('fullscreenchange', function () { + if (! $.fn.fullScreen()) { + $('#page_content').removeClass('content_fullscreen') + .css({ 'width': 'auto', 'height': 'auto' }); + var $img = $('#toggleFullscreen').find('img'); + var $span = $img.siblings('span'); + $span.text($span.data('enter')); + $img.attr('src', $img.data('enter')) + .attr('title', $span.data('enter')); + } + }); + + $('#selflink').hide(); +}); + +DesignerMove.markSaved = function () { + change = 0; + $('#saved_state').text(''); +}; + +DesignerMove.markUnsaved = function () { + change = 1; + $('#saved_state').text('*'); +}; + +var curClick = null; +var smS = 0; +var smAdd = 10; +var sLeft = 0; +var sRight = 0; +var onRelation = 0; +var onGrid = 0; +var onDisplayField = 0; +// relation_style: 0 - angular 1 - direct +var onAngularDirect = 1; +var clickField = 0; +var linkRelation = ''; +var canvasWidth = 0; +var canvasHeight = 0; +var osnTabWidth = 0; +var osnTabHeight = 0; +var heightField = 7; +var globX; +var globY; +var timeoutId; +var layerMenuCurClick = 0; +var fromArray = []; +var menuMoved = false; +var gridSize = 10; + +// ------------------------------------------------------------------------------ + +var isIe = document.all && !window.opera; + +if (isIe) { + window.onscroll = DesignerMove.generalScroll; + document.onselectstart = function () { + return false; + }; +} + +DesignerMove.mouseDown = function (e) { + globX = isIe ? e.clientX + document.body.scrollLeft : e.pageX; + globY = isIe ? e.clientY + document.body.scrollTop : e.pageY; + + if (e.target.tagName === 'SPAN') { + curClick = e.target.parentNode.parentNode.parentNode.parentNode; + } else if (e.target.className === 'tab_zag_2') { + curClick = e.target.parentNode.parentNode.parentNode; + } else if (e.target.className === 'icon') { + layerMenuCurClick = 1; + } else if (e.target.className === 'M_butt') { + return false; + } + + if (curClick !== null) { + document.getElementById('canvas').style.display = 'none'; + curClick.style.zIndex = 2; + } +}; + +DesignerMove.mouseMove = function (e) { + if (e.preventDefault) { + e.preventDefault(); + } + + var newDx = isIe ? e.clientX + document.body.scrollLeft : e.pageX; + var newDy = isIe ? e.clientY + document.body.scrollTop : e.pageY; + + var deltaX = globX - newDx; + var deltaY = globY - newDy; + + globX = newDx; + globY = newDy; + + if (curClick !== null) { + DesignerMove.markUnsaved(); + + var $curClick = $(curClick); + + var curX = parseFloat($curClick.attr('data-left') || $curClick.css('left')); + var curY = parseFloat($curClick.attr('data-top') || $curClick.css('top')); + + var newX = curX - deltaX; + var newY = curY - deltaY; + + $curClick.attr('data-left', newX); + $curClick.attr('data-top', newY); + + if (onGrid) { + newX = parseInt(newX / gridSize) * gridSize; + newY = parseInt(newY / gridSize) * gridSize; + } + + if (newX < 0) { + newX = 0; + } else if (newY < 0) { + newY = 0; + } + $curClick.css('left', newX + 'px'); + $curClick.css('top', newY + 'px'); + } else if (layerMenuCurClick) { + if (menuMoved) { + deltaX = -deltaX; + } + var $layerMenu = $('#layer_menu'); + var newWidth = $layerMenu.width() + deltaX; + if (newWidth < 150) { + newWidth = 150; + } + $layerMenu.width(newWidth); + } + + if (onRelation || onDisplayField) { + document.getElementById('designer_hint').style.left = (globX + 20) + 'px'; + document.getElementById('designer_hint').style.top = (globY + 20) + 'px'; + } +}; + +DesignerMove.mouseUp = function () { + if (curClick !== null) { + document.getElementById('canvas').style.display = 'inline-block'; + DesignerMove.reload(); + curClick.style.zIndex = 1; + curClick = null; + } + layerMenuCurClick = 0; +}; + +// ------------------------------------------------------------------------------ + +DesignerMove.canvasPos = function () { + canvasWidth = document.getElementById('canvas').width = osnTabWidth - 3; + canvasHeight = document.getElementById('canvas').height = osnTabHeight - 3; + + if (isIe) { + document.getElementById('canvas').style.width = ((osnTabWidth - 3) ? (osnTabWidth - 3) : 0) + 'px'; + document.getElementById('canvas').style.height = ((osnTabHeight - 3) ? (osnTabHeight - 3) : 0) + 'px'; + } +}; + +DesignerMove.osnTabPos = function () { + osnTabWidth = parseInt(document.getElementById('osn_tab').style.width, 10); + osnTabHeight = parseInt(document.getElementById('osn_tab').style.height, 10); +}; + +DesignerMove.setDefaultValuesFromSavedState = function () { + if ($('#angular_direct_button').attr('class') === 'M_butt') { + onAngularDirect = 0; + } else { + onAngularDirect = 1; + } + DesignerMove.angularDirect(); + + if ($('#grid_button').attr('class') === 'M_butt') { + onGrid = 1; + } else { + onGrid = 0; + } + DesignerMove.grid(); + + var $relLineInvert = $('#relLineInvert'); + if ($relLineInvert.attr('class') === 'M_butt') { + showRelationLines = false; + $relLineInvert.attr('class', 'M_butt'); + } else { + showRelationLines = true; + $relLineInvert.attr('class', 'M_butt_Selected_down'); + } + DesignerMove.relationLinesInvert(); + + if ($('#pin_Text').attr('class') === 'M_butt_Selected_down') { + alwaysShowText = true; + DesignerMove.showText(); + } else { + alwaysShowText = false; + } + + var $keySbAll = $('#key_SB_all'); + if ($keySbAll.attr('class') === 'M_butt_Selected_down') { + $keySbAll.trigger('click'); + $keySbAll.toggleClass('M_butt_Selected_down'); + $keySbAll.toggleClass('M_butt'); + } + + var $keyLeftRight = $('#key_Left_Right'); + if ($keyLeftRight.attr('class') === 'M_butt_Selected_down') { + $keyLeftRight.trigger('click'); + } +}; + +DesignerMove.main = function () { + // ---CROSS + + document.getElementById('layer_menu').style.top = -1000 + 'px'; // fast scroll + DesignerMove.osnTabPos(); + DesignerMove.canvasPos(); + DesignerMove.smallTabRefresh(); + DesignerMove.reload(); + DesignerMove.setDefaultValuesFromSavedState(); + if (isIe) { + DesignerMove.generalScroll(); + } +}; + +DesignerMove.resizeOsnTab = function () { + var maxX = 0; + var maxY = 0; + for (var key in jTabs) { + var kX = parseInt(document.getElementById(key).style.left, 10) + document.getElementById(key).offsetWidth; + var kY = parseInt(document.getElementById(key).style.top, 10) + document.getElementById(key).offsetHeight; + maxX = maxX < kX ? kX : maxX; + maxY = maxY < kY ? kY : maxY; + } + + osnTabWidth = maxX + 50; + osnTabHeight = maxY + 50; + DesignerMove.canvasPos(); + document.getElementById('osn_tab').style.width = osnTabWidth + 'px'; + document.getElementById('osn_tab').style.height = osnTabHeight + 'px'; +}; + +/** + * refreshes display, must be called after state changes + */ +DesignerMove.reload = function () { + DesignerMove.resizeOsnTab(); + var n; + var x1; + var x2; + var a = []; + var K; + var key; + var key2; + var key3; + DesignerMove.clear(); + for (K in contr) { + for (key in contr[K]) { + // contr name + for (key2 in contr[K][key]) { + // table name + for (key3 in contr[K][key][key2]) { + // field name + if (!document.getElementById('check_vis_' + key2).checked || + !document.getElementById('check_vis_' + contr[K][key][key2][key3][0]).checked) { + // if hide + continue; + } + var x1Left = document.getElementById(key2).offsetLeft + 1; + var x1Right = x1Left + document.getElementById(key2).offsetWidth; + var x2Left = document.getElementById(contr[K][key][key2][key3][0]).offsetLeft; + var x2Right = x2Left + document.getElementById(contr[K][key][key2][key3][0]).offsetWidth; + a[0] = Math.abs(x1Left - x2Left); + a[1] = Math.abs(x1Left - x2Right); + a[2] = Math.abs(x1Right - x2Left); + a[3] = Math.abs(x1Right - x2Right); + n = sLeft = sRight = 0; + for (var i = 1; i < 4; i++) { + if (a[n] > a[i]) { + n = i; + } + } + if (n === 1) { + x1 = x1Left - smS; + x2 = x2Right + smS; + if (x1 < x2) { + n = 0; + } + } + if (n === 2) { + x1 = x1Right + smS; + x2 = x2Left - smS; + if (x1 > x2) { + n = 0; + } + } + if (n === 3) { + x1 = x1Right + smS; + x2 = x2Right + smS; + sRight = 1; + } + if (n === 0) { + x1 = x1Left - smS; + x2 = x2Left - smS; + sLeft = 1; + } + + var rowOffsetTop = 0; + var tabHideButton = document.getElementById('id_hide_tbody_' + key2); + + if (tabHideButton.innerHTML === 'v') { + var fromColumn = document.getElementById(key2 + '.' + key3); + if (fromColumn) { + rowOffsetTop = fromColumn.offsetTop; + } else { + continue; + } + } + + var y1 = document.getElementById(key2).offsetTop + + rowOffsetTop + + heightField; + + + rowOffsetTop = 0; + tabHideButton = document.getElementById('id_hide_tbody_' + contr[K][key][key2][key3][0]); + if (tabHideButton.innerHTML === 'v') { + var toColumn = document.getElementById(contr[K][key][key2][key3][0] + + '.' + contr[K][key][key2][key3][1]); + if (toColumn) { + rowOffsetTop = toColumn.offsetTop; + } else { + continue; + } + } + + var y2 = + document.getElementById(contr[K][key][key2][key3][0]).offsetTop + + rowOffsetTop + + heightField; + + var osnTab = document.getElementById('osn_tab'); + + DesignerMove.line0( + x1 + osnTab.offsetLeft, + y1 - osnTab.offsetTop, + x2 + osnTab.offsetLeft, + y2 - osnTab.offsetTop, + DesignerMove.getColorByTarget(contr[K][key][key2][key3][0] + '.' + contr[K][key][key2][key3][1]) + ); + } + } + } + } +}; + +/** + * draws a line from x1:y1 to x2:y2 with color + */ +DesignerMove.line = function (x1, y1, x2, y2, colorLine) { + var canvas = document.getElementById('canvas'); + var ctx = canvas.getContext('2d'); + ctx.strokeStyle = colorLine; + ctx.lineWidth = 1; + ctx.beginPath(); + ctx.moveTo(x1, y1); + ctx.lineTo(x2, y2); + ctx.stroke(); +}; + +/** + * draws a relation/constraint line, whether angular or not + */ +DesignerMove.line0 = function (x1, y1, x2, y2, colorLine) { + if (! showRelationLines) { + return; + } + DesignerMove.circle(x1, y1, 3, 3, colorLine); + DesignerMove.rect(x2 - 1, y2 - 2, 4, 4, colorLine); + + if (onAngularDirect) { + DesignerMove.line2(x1, y1, x2, y2, colorLine); + } else { + DesignerMove.line3(x1, y1, x2, y2, colorLine); + } +}; + +/** + * draws a angular relation/constraint line + */ +DesignerMove.line2 = function (x1, y1, x2, y2, colorLine) { + var x1Local = x1; + var x2Local = x2; + + if (sRight) { + x1Local += smAdd; + x2Local += smAdd; + } else if (sLeft) { + x1Local -= smAdd; + x2Local -= smAdd; + } else if (x1 < x2) { + x1Local += smAdd; + x2Local -= smAdd; + } else { + x1Local -= smAdd; + x2Local += smAdd; + } + + DesignerMove.line(x1, y1, x1Local, y1, colorLine); + DesignerMove.line(x2, y2, x2Local, y2, colorLine); + DesignerMove.line(x1Local, y1, x2Local, y2, colorLine); +}; + +/** + * draws a relation/constraint line + */ +DesignerMove.line3 = function (x1, y1, x2, y2, colorLine) { + var x1Local = x1; + var x2Local = x2; + + if (sRight) { + if (x1 < x2) { + x1Local += x2 - x1 + smAdd; + x2Local += smAdd; + } else { + x2Local += x1 - x2 + smAdd; + x1Local += smAdd; + } + + DesignerMove.line(x1, y1, x1Local, y1, colorLine); + DesignerMove.line(x2, y2, x2Local, y2, colorLine); + DesignerMove.line(x1Local, y1, x2Local, y2, colorLine); + return; + } + if (sLeft) { + if (x1 < x2) { + x2Local -= x2 - x1 + smAdd; + x1Local -= smAdd; + } else { + x1Local -= x1 - x2 + smAdd; + x2Local -= smAdd; + } + + DesignerMove.line(x1, y1, x1Local, y1, colorLine); + DesignerMove.line(x2, y2, x2Local, y2, colorLine); + DesignerMove.line(x1Local, y1, x2Local, y2, colorLine); + return; + } + + var xS = (x1 + x2) / 2; + DesignerMove.line(x1, y1, xS, y1, colorLine); + DesignerMove.line(xS, y2, x2, y2, colorLine); + DesignerMove.line(xS, y1, xS, y2, colorLine); +}; + +DesignerMove.circle = function (x, y, r, w, color) { + var ctx = document.getElementById('canvas').getContext('2d'); + ctx.beginPath(); + ctx.moveTo(x, y); + ctx.lineWidth = w; + ctx.strokeStyle = color; + ctx.arc(x, y, r, 0, 2 * Math.PI, true); + ctx.stroke(); +}; + +DesignerMove.clear = function () { + var canvas = document.getElementById('canvas'); + var ctx = canvas.getContext('2d'); + ctx.clearRect(0, 0, canvasWidth, canvasHeight); +}; + +DesignerMove.rect = function (x1, y1, w, h, color) { + var ctx = document.getElementById('canvas').getContext('2d'); + ctx.fillStyle = color; + ctx.fillRect(x1, y1, w, h); +}; + +// --------------------------- FULLSCREEN ------------------------------------- +DesignerMove.toggleFullscreen = function () { + var valueSent = ''; + var $img = $('#toggleFullscreen').find('img'); + var $span = $img.siblings('span'); + var $content = $('#page_content'); + if (! $content.fullScreen()) { + $img.attr('src', $img.data('exit')) + .attr('title', $span.data('exit')); + $span.text($span.data('exit')); + $content + .addClass('content_fullscreen') + .css({ 'width': screen.width - 5, 'height': screen.height - 5 }); + valueSent = 'on'; + $content.fullScreen(true); + } else { + $img.attr('src', $img.data('enter')) + .attr('title', $span.data('enter')); + $span.text($span.data('enter')); + $content.fullScreen(false); + valueSent = 'off'; + } + DesignerMove.saveValueInConfig('full_screen', valueSent); +}; + +DesignerMove.addTableToTablesList = function (index, tableDom) { + var db = $(tableDom).find('.small_tab_pref').attr('db'); + var table = $(tableDom).find('.small_tab_pref').attr('table_name'); + var dbEncoded = $(tableDom).find('.small_tab_pref').attr('db_url'); + var tableEncoded = $(tableDom).find('.small_tab_pref').attr('table_name_url'); + var $newTableLine = $('' + + ' ' + + ' ' + + ' ' + + ' ' + + ' ' + + ' ' + + ' ' + $('
').text(db + '.' + table).html() + '' + + ''); + $('#id_scroll_tab table').first().append($newTableLine); + $($newTableLine).find('.scroll_tab_struct').click(function () { + DesignerMove.startTabUpd(db, table); + }); + $($newTableLine).on('click', '.designer_Tabs2,.designer_Tabs', function () { + DesignerMove.selectTab($(this).attr('designer_url_table_name')); + }); + $($newTableLine).find('.scroll_tab_checkbox').click(function () { + DesignerMove.visibleTab(this,$(this).val()); + }); + var $tablesCounter = $('#tables_counter'); + $tablesCounter.text(parseInt($tablesCounter.text(), 10) + 1); +}; + +DesignerMove.addOtherDbTables = function () { + var buttonOptions = {}; + buttonOptions[Messages.strGo] = function () { + var db = $('#add_table_from').val(); + var table = $('#add_table').val(); + + // Check if table already imported or not. + var $table = $('[id="' + encodeURIComponent(db) + '.' + encodeURIComponent(table) + '"]'); + if ($table.length !== 0) { + Functions.ajaxShowMessage( + Functions.sprintf(Messages.strTableAlreadyExists, db + '.' + table), + undefined, + 'error' + ); + return; + } + + $.post('db_designer.php', { + 'ajax_request' : true, + 'dialog' : 'add_table', + 'db' : db, + 'table' : table, + 'server': CommonParams.get('server') + }, function (data) { + var $newTableDom = $(data.message); + $newTableDom.find('a').first().remove(); + + var dbEncoded = $($newTableDom).find('.small_tab_pref').attr('db_url'); + var tableEncoded = $($newTableDom).find('.small_tab_pref').attr('table_name_url'); + + if (typeof dbEncoded === 'string' && typeof tableEncoded === 'string') { // Do not try to add if attr not found ! + $('#container-form').append($newTableDom); + DesignerMove.enableTableEvents(null, $newTableDom); + DesignerMove.addTableToTablesList(null, $newTableDom); + jTabs[dbEncoded + '.' + tableEncoded] = 1; + DesignerMove.markUnsaved(); + } + }); + $(this).dialog('close'); + }; + buttonOptions[Messages.strCancel] = function () { + $(this).dialog('close'); + }; + + var $selectDb = $(''); + $selectDb.append(''); + + var $selectTable = $(''); + $selectTable.append(''); + + $.post('sql.php', { + 'ajax_request' : true, + 'sql_query' : 'SHOW databases;', + 'server': CommonParams.get('server') + }, function (data) { + $(data.message).find('table.table_results.data.ajax').find('td.data').each(function () { + var val = $(this)[0].innerText; + $selectDb.append($('').val(val).text(val)); + }); + }); + + var $form = $('
') + .append($selectDb).append($selectTable); + $('
') + .append($form) + .dialog({ + appendTo: '#page_content', + title: Messages.strAddTables, + width: 500, + modal: true, + buttons: buttonOptions, + close: function () { + $(this).remove(); + } + }); + + $('#add_table_from').on('change', function () { + if ($(this).val()) { + var dbName = $(this).val(); + var sqlQuery = 'SHOW tables;'; + $.post('sql.php', { + 'ajax_request' : true, + 'sql_query': sqlQuery, + 'db' : dbName, + 'server': CommonParams.get('server') + }, function (data) { + $selectTable.html(''); + var rows = $(data.message).find('table.table_results.data.ajax').find('td.data'); + if (rows.length === 0) { + $selectTable.append(''); + } + rows.each(function () { + var val = $(this)[0].innerText; + $selectTable.append($('').val(val).text(val)); + }); + }); + } + }); +}; + +// ------------------------------ NEW ------------------------------------------ +DesignerMove.new = function () { + DesignerMove.promptToSaveCurrentPage(function () { + DesignerMove.loadPage(-1); + }); +}; + +// ------------------------------ SAVE ------------------------------------------ +// (del?) no for pdf +DesignerMove.save = function (url) { + for (var key in jTabs) { + document.getElementById('t_x_' + key + '_').value = parseInt(document.getElementById(key).style.left, 10); + document.getElementById('t_y_' + key + '_').value = parseInt(document.getElementById(key).style.top, 10); + document.getElementById('t_v_' + key + '_').value = document.getElementById('id_tbody_' + key).style.display === 'none' ? 0 : 1; + document.getElementById('t_h_' + key + '_').value = document.getElementById('check_vis_' + key).checked ? 1 : 0; + } + document.getElementById('container-form').action = url; + $('#container-form').submit(); +}; + +DesignerMove.getUrlPos = function (forceString) { + var key; + if (designerTablesEnabled || forceString) { + var poststr = ''; + var argsep = CommonParams.get('arg_separator'); + var i = 1; + for (key in jTabs) { + poststr += argsep + 't_x[' + i + ']=' + parseInt(document.getElementById(key).style.left, 10); + poststr += argsep + 't_y[' + i + ']=' + parseInt(document.getElementById(key).style.top, 10); + poststr += argsep + 't_v[' + i + ']=' + (document.getElementById('id_tbody_' + key).style.display === 'none' ? 0 : 1); + poststr += argsep + 't_h[' + i + ']=' + (document.getElementById('check_vis_' + key).checked ? 1 : 0); + poststr += argsep + 't_db[' + i + ']=' + $(document.getElementById(key)).attr('db_url'); + poststr += argsep + 't_tbl[' + i + ']=' + $(document.getElementById(key)).attr('table_name_url'); + i++; + } + return poststr; + } else { + var coords = []; + for (key in jTabs) { + if (document.getElementById('check_vis_' + key).checked) { + var x = parseInt(document.getElementById(key).style.left, 10); + var y = parseInt(document.getElementById(key).style.top, 10); + var tbCoords = new DesignerObjects.TableCoordinate( + $(document.getElementById(key)).attr('db_url'), + $(document.getElementById(key)).attr('table_name_url'), + -1, x, y); + coords.push(tbCoords); + } + } + return coords; + } +}; + +DesignerMove.save2 = function (callback) { + if (designerTablesEnabled) { + var argsep = CommonParams.get('arg_separator'); + var poststr = 'operation=savePage' + argsep + 'save_page=same' + argsep + 'ajax_request=true'; + poststr += argsep + 'server=' + server + argsep + 'db=' + encodeURIComponent(db) + argsep + 'selected_page=' + selectedPage; + poststr += DesignerMove.getUrlPos(); + + var $msgbox = Functions.ajaxShowMessage(Messages.strProcessingRequest); +