diff options
Diffstat (limited to 'srcs/phpmyadmin/js/designer')
| -rw-r--r-- | srcs/phpmyadmin/js/designer/database.js | 149 | ||||
| -rw-r--r-- | srcs/phpmyadmin/js/designer/history.js | 859 | ||||
| -rw-r--r-- | srcs/phpmyadmin/js/designer/init.js | 75 | ||||
| -rw-r--r-- | srcs/phpmyadmin/js/designer/move.js | 2214 | ||||
| -rw-r--r-- | srcs/phpmyadmin/js/designer/objects.js | 17 | ||||
| -rw-r--r-- | srcs/phpmyadmin/js/designer/page.js | 169 |
6 files changed, 3483 insertions, 0 deletions
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 += '<h3 class="tiger"><a href="#">' + temp + '</a></h3>'; + str += '<div class="toggle_container">\n'; + while ((historyArray[i].getTab()) === temp) { // + '.' + historyArray[i].getObjNo()) === temp) { + str += '<div class="block"> <table width ="250">'; + str += '<thead><tr><td>'; + if (historyArray[i].getAndOr()) { + str += '<img src="' + pmaThemeImage + 'designer/or_icon.png" onclick="DesignerHistory.andOr(' + i + ')" title="OR"></td>'; + } else { + str += '<img src="' + pmaThemeImage + 'designer/and_icon.png" onclick="DesignerHistory.andOr(' + i + ')" title="AND"></td>'; + } + str += '<td style="padding-left: 5px;" class="right">' + Functions.getImage('b_sbrowse', Messages.strColumnName) + '</td>' + + '<td width="175" style="padding-left: 5px">' + $('<div/>').text(historyArray[i].getColumnName()).html() + '<td>'; + if (historyArray[i].getType() === 'GroupBy' || historyArray[i].getType() === 'OrderBy') { + var detailDescGroupBy = $('<div/>').text(DesignerHistory.detail(i)).html(); + str += '<td class="center">' + Functions.getImage('s_info', DesignerHistory.detail(i)) + '</td>' + + '<td title="' + detailDescGroupBy + '">' + historyArray[i].getType() + '</td>' + + '<td onclick=DesignerHistory.historyDelete(' + i + ')>' + Functions.getImage('b_drop', Messages.strDelete) + '</td>'; + } else { + var detailDesc = $('<div/>').text(DesignerHistory.detail(i)).html(); + str += '<td class="center">' + Functions.getImage('s_info', DesignerHistory.detail(i)) + '</td>' + + '<td title="' + detailDesc + '">' + historyArray[i].getType() + '</td>' + + '<td onclick=DesignerHistory.historyEdit(' + i + ')>' + Functions.getImage('b_edit', Messages.strEdit) + '</td>' + + '<td onclick=DesignerHistory.historyDelete(' + i + ')>' + Functions.getImage('b_drop', Messages.strDelete) + '</td>'; + } + str += '</tr></thead>'; + i++; + if (i >= historyArray.length) { + break; + } + str += '</table></div>'; + } + i--; + str += '</div>'; + } + 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 = $('<tr>' + + ' <td title="' + Messages.strStructure + '"' + + ' width="1px"' + + ' class="L_butt2_1">' + + ' <img alt=""' + + ' db="' + dbEncoded + '"' + + ' table_name="' + tableEncoded + '"' + + ' class="scroll_tab_struct"' + + ' src="' + pmaThemeImage + 'designer/exec.png"/>' + + ' </td>' + + ' <td width="1px">' + + ' <input class="scroll_tab_checkbox"' + + ' title="' + Messages.strHide + '"' + + ' id="check_vis_' + dbEncoded + '.' + tableEncoded + '"' + + ' style="margin:0;"' + + ' type="checkbox"' + + ' value="' + dbEncoded + '.' + tableEncoded + '"' + + ' checked="checked"' + + ' />' + + ' </td>' + + ' <td class="designer_Tabs"' + + ' designer_url_table_name="' + dbEncoded + '.' + tableEncoded + '">' + $('<div/>').text(db + '.' + table).html() + '</td>' + + '</tr>'); + $('#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 = $('<select id="add_table_from"></select>'); + $selectDb.append('<option value="">' + Messages.strNone + '</option>'); + + var $selectTable = $('<select id="add_table"></select>'); + $selectTable.append('<option value="">' + Messages.strNone + '</option>'); + + $.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($('<option></option>').val(val).text(val)); + }); + }); + + var $form = $('<form action="" class="ajax"></form>') + .append($selectDb).append($selectTable); + $('<div id="page_add_tables_dialog"></div>') + .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('<option value="">' + Messages.strNone + '</option>'); + } + rows.each(function () { + var val = $(this)[0].innerText; + $selectTable.append($('<option></option>').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); + $.post('db_designer.php', poststr, function (data) { + if (data.success === false) { + Functions.ajaxShowMessage(data.error, false); + } else { + Functions.ajaxRemoveMessage($msgbox); + Functions.ajaxShowMessage(Messages.strModificationSaved); + DesignerMove.markSaved(); + if (typeof callback !== 'undefined') { + callback(); + } + } + }); + } else { + var name = $('#page_name').html().trim(); + DesignerPage.saveToSelectedPage(db, selectedPage, name, DesignerMove.getUrlPos(), function () { + DesignerMove.markSaved(); + if (typeof callback !== 'undefined') { + callback(); + } + }); + } +}; + +DesignerMove.submitSaveDialogAndClose = function (callback) { + var $form = $('#save_page'); + var name = $form.find('input[name="selected_value"]').val().trim(); + if (name === '') { + Functions.ajaxShowMessage(Messages.strEnterValidPageName, false); + return; + } + $('#page_save_dialog').dialog('close'); + + if (designerTablesEnabled) { + var $msgbox = Functions.ajaxShowMessage(Messages.strProcessingRequest); + Functions.prepareForAjaxRequest($form); + $.post($form.attr('action'), $form.serialize() + DesignerMove.getUrlPos(), function (data) { + if (data.success === false) { + Functions.ajaxShowMessage(data.error, false); + } else { + Functions.ajaxRemoveMessage($msgbox); + DesignerMove.markSaved(); + if (data.id) { + selectedPage = data.id; + } + $('#page_name').text(name); + if (typeof callback !== 'undefined') { + callback(); + } + } + }); + } else { + DesignerPage.saveToNewPage(db, name, DesignerMove.getUrlPos(), function (page) { + DesignerMove.markSaved(); + if (page.pgNr) { + selectedPage = page.pgNr; + } + $('#page_name').text(page.pageDescr); + if (typeof callback !== 'undefined') { + callback(); + } + }); + } +}; + +DesignerMove.save3 = function (callback) { + if (selectedPage !== -1) { + DesignerMove.save2(callback); + } else { + var buttonOptions = {}; + buttonOptions[Messages.strGo] = function () { + var $form = $('#save_page'); + $form.trigger('submit'); + }; + buttonOptions[Messages.strCancel] = function () { + $(this).dialog('close'); + }; + + var $form = $('<form action="db_designer.php" method="post" name="save_page" id="save_page" class="ajax"></form>') + .append('<input type="hidden" name="server" value="' + server + '">') + .append($('<input type="hidden" name="db" />').val(db)) + .append('<input type="hidden" name="operation" value="savePage">') + .append('<input type="hidden" name="save_page" value="new">') + .append('<label for="selected_value">' + Messages.strPageName + + '</label>:<input type="text" name="selected_value">'); + $form.on('submit', function (e) { + e.preventDefault(); + DesignerMove.submitSaveDialogAndClose(callback); + }); + $('<div id="page_save_dialog"></div>') + .append($form) + .dialog({ + appendTo: '#page_content', + title: Messages.strSavePage, + width: 300, + modal: true, + buttons: buttonOptions, + close: function () { + $(this).remove(); + } + }); + } +}; + +// ------------------------------ EDIT PAGES ------------------------------------------ +DesignerMove.editPages = function () { + DesignerMove.promptToSaveCurrentPage(function () { + var buttonOptions = {}; + buttonOptions[Messages.strGo] = function () { + var $form = $('#edit_delete_pages'); + var selected = $form.find('select[name="selected_page"]').val(); + if (selected === '0') { + Functions.ajaxShowMessage(Messages.strSelectPage, 2000); + return; + } + $(this).dialog('close'); + DesignerMove.loadPage(selected); + }; + buttonOptions[Messages.strCancel] = function () { + $(this).dialog('close'); + }; + + var $msgbox = Functions.ajaxShowMessage(); + $.post('db_designer.php', { + 'ajax_request': true, + 'server': server, + 'db': db, + 'dialog': 'edit' + }, function (data) { + if (data.success === false) { + Functions.ajaxShowMessage(data.error, false); + } else { + Functions.ajaxRemoveMessage($msgbox); + + if (! designerTablesEnabled) { + DesignerPage.createPageList(db, function (options) { + $('#selected_page').append(options); + }); + } + $('<div id="page_edit_dialog"></div>') + .append(data.message) + .dialog({ + appendTo: '#page_content', + title: Messages.strOpenPage, + width: 350, + modal: true, + buttons: buttonOptions, + close: function () { + $(this).remove(); + } + }); + } + }); // end $.post() + }); +}; + +// ----------------------------- DELETE PAGES --------------------------------------- +DesignerMove.deletePages = function () { + var buttonOptions = {}; + buttonOptions[Messages.strGo] = function () { + var $form = $('#edit_delete_pages'); + var selected = $form.find('select[name="selected_page"]').val(); + if (selected === '0') { + Functions.ajaxShowMessage(Messages.strSelectPage, 2000); + return; + } + + var $messageBox = Functions.ajaxShowMessage(Messages.strProcessingRequest); + var deletingCurrentPage = selected === selectedPage; + Functions.prepareForAjaxRequest($form); + + if (designerTablesEnabled) { + $.post($form.attr('action'), $form.serialize(), function (data) { + if (data.success === false) { + Functions.ajaxShowMessage(data.error, false); + } else { + Functions.ajaxRemoveMessage($messageBox); + if (deletingCurrentPage) { + DesignerMove.loadPage(null); + } else { + Functions.ajaxShowMessage(Messages.strSuccessfulPageDelete); + } + } + }); // end $.post() + } else { + DesignerPage.deletePage(selected, function (success) { + if (! success) { + Functions.ajaxShowMessage('Error', false); + } else { + Functions.ajaxRemoveMessage($messageBox); + if (deletingCurrentPage) { + DesignerMove.loadPage(null); + } else { + Functions.ajaxShowMessage(Messages.strSuccessfulPageDelete); + } + } + }); + } + + $(this).dialog('close'); + }; + buttonOptions[Messages.strCancel] = function () { + $(this).dialog('close'); + }; + + var $msgbox = Functions.ajaxShowMessage(); + $.post('db_designer.php', { + 'ajax_request': true, + 'server': server, + 'db': db, + 'dialog': 'delete' + }, function (data) { + if (data.success === false) { + Functions.ajaxShowMessage(data.error, false); + } else { + Functions.ajaxRemoveMessage($msgbox); + + if (! designerTablesEnabled) { + DesignerPage.createPageList(db, function (options) { + $('#selected_page').append(options); + }); + } + + $('<div id="page_delete_dialog"></div>') + .append(data.message) + .dialog({ + appendTo: '#page_content', + title: Messages.strDeletePage, + width: 350, + modal: true, + buttons: buttonOptions, + close: function () { + $(this).remove(); + } + }); + } + }); // end $.post() +}; + +// ------------------------------ SAVE AS PAGES --------------------------------------- +DesignerMove.saveAs = function () { + var buttonOptions = {}; + buttonOptions[Messages.strGo] = function () { + var $form = $('#save_as_pages'); + var selectedValue = $form.find('input[name="selected_value"]').val().trim(); + var $selectedPage = $form.find('select[name="selected_page"]'); + var choice = $form.find('input[name="save_page"]:checked').val(); + var name = ''; + + if (choice === 'same') { + if ($selectedPage.val() === '0') { + Functions.ajaxShowMessage(Messages.strSelectPage, 2000); + return; + } + name = $selectedPage.find('option:selected').text(); + } else if (choice === 'new') { + if (selectedValue === '') { + Functions.ajaxShowMessage(Messages.strEnterValidPageName, 2000); + return; + } + name = selectedValue; + } + + var $msgbox = Functions.ajaxShowMessage(Messages.strProcessingRequest); + if (designerTablesEnabled) { + Functions.prepareForAjaxRequest($form); + $.post($form.attr('action'), $form.serialize() + DesignerMove.getUrlPos(), function (data) { + if (data.success === false) { + Functions.ajaxShowMessage(data.error, false); + } else { + Functions.ajaxRemoveMessage($msgbox); + DesignerMove.markSaved(); + if (data.id) { + selectedPage = data.id; + } + DesignerMove.loadPage(selectedPage); + } + }); // end $.post() + } else { + if (choice === 'same') { + var selectedPageId = $selectedPage.find('option:selected').val(); + DesignerPage.saveToSelectedPage(db, selectedPageId, name, DesignerMove.getUrlPos(), function (page) { + Functions.ajaxRemoveMessage($msgbox); + DesignerMove.markSaved(); + if (page.pgNr) { + selectedPage = page.pgNr; + } + DesignerMove.loadPage(selectedPage); + }); + } else if (choice === 'new') { + DesignerPage.saveToNewPage(db, name, DesignerMove.getUrlPos(), function (page) { + Functions.ajaxRemoveMessage($msgbox); + DesignerMove.markSaved(); + if (page.pgNr) { + selectedPage = page.pgNr; + } + DesignerMove.loadPage(selectedPage); + }); + } + } + + $(this).dialog('close'); + }; + buttonOptions[Messages.strCancel] = function () { + $(this).dialog('close'); + }; + + var $msgbox = Functions.ajaxShowMessage(); + $.post('db_designer.php', { + 'ajax_request': true, + 'server': server, + 'db': db, + 'dialog': 'save_as' + }, function (data) { + if (data.success === false) { + Functions.ajaxShowMessage(data.error, false); + } else { + Functions.ajaxRemoveMessage($msgbox); + + if (! designerTablesEnabled) { + DesignerPage.createPageList(db, function (options) { + $('#selected_page').append(options); + }); + } + + $('<div id="page_save_as_dialog"></div>') + .append(data.message) + .dialog({ + appendTo: '#page_content', + title: Messages.strSavePageAs, + width: 450, + modal: true, + buttons: buttonOptions, + close: function () { + $(this).remove(); + } + }); + // select current page by default + if (selectedPage !== -1) { + $('select[name="selected_page"]').val(selectedPage); + } + } + }); // end $.post() +}; + +DesignerMove.promptToSaveCurrentPage = function (callback) { + if (change === 1 || selectedPage === -1) { + var buttonOptions = {}; + buttonOptions[Messages.strYes] = function () { + $(this).dialog('close'); + DesignerMove.save3(callback); + }; + buttonOptions[Messages.strNo] = function () { + $(this).dialog('close'); + callback(); + }; + buttonOptions[Messages.strCancel] = function () { + $(this).dialog('close'); + }; + $('<div id="prompt_save_dialog"></div>') + .append('<div>' + Messages.strLeavingPage + '</div>') + .dialog({ + appendTo: '#page_content', + title: Messages.strSavePage, + width: 300, + modal: true, + buttons: buttonOptions, + close: function () { + $(this).remove(); + } + }); + } else { + callback(); + } +}; + +// ------------------------------ EXPORT PAGES --------------------------------------- +DesignerMove.exportPages = function () { + var buttonOptions = {}; + buttonOptions[Messages.strGo] = function () { + $('#id_export_pages').trigger('submit'); + $(this).dialog('close'); + }; + buttonOptions[Messages.strCancel] = function () { + $(this).dialog('close'); + }; + var $msgbox = Functions.ajaxShowMessage(); + var argsep = CommonParams.get('arg_separator'); + + $.post('db_designer.php', { + 'ajax_request': true, + 'server': server, + 'db': db, + 'dialog': 'export', + 'selected_page': selectedPage + }, function (data) { + if (data.success === false) { + Functions.ajaxShowMessage(data.error, false); + } else { + Functions.ajaxRemoveMessage($msgbox); + + var $form = $(data.message); + if (!designerTablesEnabled) { + $form.append('<input type="hidden" name="offline_export" value="true">'); + } + $.each(DesignerMove.getUrlPos(true).substring(1).split(argsep), function () { + var pair = this.split('='); + var input = $('<input type="hidden">'); + input.attr('name', pair[0]); + input.attr('value', pair[1]); + $form.append(input); + }); + var $formatDropDown = $form.find('#plugins'); + $formatDropDown.on('change', function () { + var format = $formatDropDown.val(); + $form.find('.format_specific_options').hide(); + $form.find('#' + format + '_options').show(); + }).trigger('change'); + + $('<div id="page_export_dialog"></div>') + .append($form) + .dialog({ + appendTo: '#page_content', + title: Messages.strExportRelationalSchema, + width: 550, + modal: true, + buttons: buttonOptions, + close: function () { + $(this).remove(); + } + }); + } + }); // end $.post() +}; + +DesignerMove.loadPage = function (page) { + if (designerTablesEnabled) { + var paramPage = ''; + var argsep = CommonParams.get('arg_separator'); + if (page !== null) { + paramPage = argsep + 'page=' + page; + } + $('<a href="db_designer.php?server=' + server + argsep + 'db=' + encodeURIComponent(db) + paramPage + '"></a>') + .appendTo($('#page_content')) + .trigger('click'); + } else { + if (page === null) { + DesignerPage.showTablesInLandingPage(db); + } else if (page > -1) { + DesignerPage.loadHtmlForPage(page); + } else if (page === -1) { + DesignerPage.showNewPageTables(true); + } + } + DesignerMove.markSaved(); +}; + +DesignerMove.grid = function () { + var valueSent = ''; + if (!onGrid) { + onGrid = 1; + valueSent = 'on'; + document.getElementById('grid_button').className = 'M_butt_Selected_down'; + } else { + document.getElementById('grid_button').className = 'M_butt'; + onGrid = 0; + valueSent = 'off'; + } + DesignerMove.saveValueInConfig('snap_to_grid', valueSent); +}; + +DesignerMove.angularDirect = function () { + var valueSent = ''; + if (onAngularDirect) { + onAngularDirect = 0; + valueSent = 'angular'; + document.getElementById('angular_direct_button').className = 'M_butt_Selected_down'; + } else { + onAngularDirect = 1; + valueSent = 'direct'; + document.getElementById('angular_direct_button').className = 'M_butt'; + } + DesignerMove.saveValueInConfig('angular_direct', valueSent); + DesignerMove.reload(); +}; + +DesignerMove.saveValueInConfig = function (indexSent, valueSent) { + $.post('db_designer.php', + { + 'operation': 'save_setting_value', + 'index': indexSent, + 'ajax_request': true, + 'server': server, + 'value': valueSent + }, + function (data) { + if (data.success === false) { + Functions.ajaxShowMessage(data.error, false); + } + }); +}; + +// ++++++++++++++++++++++++++++++ RELATION ++++++++++++++++++++++++++++++++++++++ +DesignerMove.startRelation = function () { + if (onDisplayField) { + return; + } + + if (!onRelation) { + document.getElementById('foreign_relation').style.display = ''; + onRelation = 1; + document.getElementById('designer_hint').innerHTML = Messages.strSelectReferencedKey; + document.getElementById('designer_hint').style.display = 'block'; + document.getElementById('rel_button').className = 'M_butt_Selected_down'; + } else { + document.getElementById('designer_hint').innerHTML = ''; + document.getElementById('designer_hint').style.display = 'none'; + document.getElementById('rel_button').className = 'M_butt'; + clickField = 0; + onRelation = 0; + } +}; + +// table field +DesignerMove.clickField = function (db, T, f, pk) { + var pkLocal = parseInt(pk); + var argsep = CommonParams.get('arg_separator'); + if (onRelation) { + if (!clickField) { + // .style.display=='none' .style.display = 'none' + if (!pkLocal) { + alert(Messages.strPleaseSelectPrimaryOrUniqueKey); + return;// 0; + }// PK + if (jTabs[db + '.' + T] !== 1) { + document.getElementById('foreign_relation').style.display = 'none'; + } + clickField = 1; + linkRelation = 'DB1=' + db + argsep + 'T1=' + T + argsep + 'F1=' + f; + document.getElementById('designer_hint').innerHTML = Messages.strSelectForeignKey; + } else { + DesignerMove.startRelation(); // hidden hint... + if (jTabs[db + '.' + T] !== 1 || !pkLocal) { + document.getElementById('foreign_relation').style.display = 'none'; + } + var left = globX - (document.getElementById('layer_new_relation').offsetWidth >> 1); + document.getElementById('layer_new_relation').style.left = left + 'px'; + var top = globY - document.getElementById('layer_new_relation').offsetHeight; + document.getElementById('layer_new_relation').style.top = top + 'px'; + document.getElementById('layer_new_relation').style.display = 'block'; + linkRelation += argsep + 'DB2=' + db + argsep + 'T2=' + T + argsep + 'F2=' + f; + } + } + + if (onDisplayField) { + var fieldNameToSend = decodeURIComponent(f); + var newDisplayFieldClass = 'tab_field'; + var oldTabField = document.getElementById('id_tr_' + T + '.' + displayField[T]); + // if is display field + if (displayField[T] === f) {// The display field is already the one defined, user wants to remove it + newDisplayFieldClass = 'tab_field'; + delete displayField[T]; + if (oldTabField) {// Clear the style + // Set display field class on old item + oldTabField.className = 'tab_field'; + } + fieldNameToSend = ''; + } else { + newDisplayFieldClass = 'tab_field_3'; + if (displayField[T]) { // Had a previous one, clear it + if (oldTabField) { + // Set display field class on old item + oldTabField.className = 'tab_field'; + } + delete displayField[T]; + } + displayField[T] = f; + + var tabField = document.getElementById('id_tr_' + T + '.' + displayField[T]); + if (tabField) { + // Set new display field class + tabField.className = newDisplayFieldClass; + } + } + onDisplayField = 0; + document.getElementById('designer_hint').innerHTML = ''; + document.getElementById('designer_hint').style.display = 'none'; + document.getElementById('display_field_button').className = 'M_butt'; + + var $msgbox = Functions.ajaxShowMessage(Messages.strProcessingRequest); + $.post('db_designer.php', + { + 'operation': 'setDisplayField', + 'ajax_request': true, + 'server': server, + 'db': db, + 'table': T, + 'field': fieldNameToSend + }, + function (data) { + if (data.success === false) { + Functions.ajaxShowMessage(data.error, false); + } else { + Functions.ajaxRemoveMessage($msgbox); + Functions.ajaxShowMessage(Messages.strModificationSaved); + } + }); + } +}; + +DesignerMove.newRelation = function () { + document.getElementById('layer_new_relation').style.display = 'none'; + var argsep = CommonParams.get('arg_separator'); + linkRelation += argsep + 'server=' + server + argsep + 'db=' + db + argsep + 'db2=p'; + linkRelation += argsep + 'on_delete=' + document.getElementById('on_delete').value + argsep + 'on_update=' + document.getElementById('on_update').value; + linkRelation += argsep + 'operation=addNewRelation' + argsep + 'ajax_request=true'; + + var $msgbox = Functions.ajaxShowMessage(Messages.strProcessingRequest); + $.post('db_designer.php', linkRelation, function (data) { + if (data.success === false) { + Functions.ajaxShowMessage(data.error, false); + } else { + Functions.ajaxRemoveMessage($msgbox); + DesignerMove.loadPage(selectedPage); + } + }); // end $.post() +}; + +// -------------------------- create tables ------------------------------------- +DesignerMove.startTableNew = function () { + CommonParams.set('table', ''); + CommonActions.refreshMain('tbl_create.php'); +}; + +DesignerMove.startTabUpd = function (db, table) { + CommonParams.set('db', db); + CommonParams.set('table', table); + CommonActions.refreshMain('tbl_structure.php'); +}; + +// --------------------------- hide tables -------------------------------------- +// max/min all tables +DesignerMove.smallTabAll = function (idThis) { + var icon = idThis.children[0]; + var valueSent = ''; + + if (icon.alt === 'v') { + $('.designer_tab .small_tab,.small_tab2').each(function (index, element) { + if ($(element).text() === 'v') { + DesignerMove.smallTab($(element).attr('table_name'), 0); + } + }); + icon.alt = '>'; + icon.src = icon.dataset.right; + valueSent = 'v'; + } else { + $('.designer_tab .small_tab,.small_tab2').each(function (index, element) { + if ($(element).text() !== 'v') { + DesignerMove.smallTab($(element).attr('table_name'), 0); + } + }); + icon.alt = 'v'; + icon.src = icon.dataset.down; + valueSent = '>'; + } + DesignerMove.saveValueInConfig('small_big_all', valueSent); + $('#key_SB_all').toggleClass('M_butt_Selected_down'); + $('#key_SB_all').toggleClass('M_butt'); + DesignerMove.reload(); +}; + +// invert max/min all tables +DesignerMove.smallTabInvert = function () { + for (var key in jTabs) { + DesignerMove.smallTab(key, 0); + } + DesignerMove.reload(); +}; + +DesignerMove.relationLinesInvert = function () { + showRelationLines = ! showRelationLines; + DesignerMove.saveValueInConfig('relation_lines', showRelationLines); + $('#relLineInvert').toggleClass('M_butt_Selected_down'); + $('#relLineInvert').toggleClass('M_butt'); + DesignerMove.reload(); +}; + +DesignerMove.smallTabRefresh = function () { + for (var key in jTabs) { + if (document.getElementById('id_hide_tbody_' + key).innerHTML !== 'v') { + DesignerMove.smallTab(key, 0); + } + } +}; + +DesignerMove.smallTab = function (t, reload) { + var id = document.getElementById('id_tbody_' + t); + var idThis = document.getElementById('id_hide_tbody_' + t); + if (idThis.innerHTML === 'v') { + // ---CROSS + id.style.display = 'none'; + idThis.innerHTML = '>'; + } else { + id.style.display = ''; + idThis.innerHTML = 'v'; + } + if (reload) { + DesignerMove.reload(); + } +}; + +DesignerMove.selectTab = function (t) { + var idZag = document.getElementById('id_zag_' + t); + if (idZag.className !== 'tab_zag_3') { + document.getElementById('id_zag_' + t).className = 'tab_zag_2'; + } else { + document.getElementById('id_zag_' + t).className = 'tab_zag'; + } + // ---------- + var idT = document.getElementById(t); + window.scrollTo(parseInt(idT.style.left, 10) - 300, parseInt(idT.style.top, 10) - 300); + setTimeout( + function () { + document.getElementById('id_zag_' + t).className = 'tab_zag'; + }, + 800 + ); +}; + +DesignerMove.canvasClick = function (id, event) { + var n = 0; + var selected = 0; + var a = []; + var Key0; + var Key1; + var Key2; + var Key3; + var Key; + var x1; + var x2; + var K; + var key; + var key2; + var key3; + var localX = isIe ? event.clientX + document.body.scrollLeft : event.pageX; + var localY = isIe ? event.clientY + document.body.scrollTop : event.pageY; + localX -= $('#osn_tab').offset().left; + localY -= $('#osn_tab').offset().top; + DesignerMove.clear(); + for (K in contr) { + for (key in contr[K]) { + for (key2 in contr[K][key]) { + for (key3 in contr[K][key][key2]) { + if (! document.getElementById('check_vis_' + key2).checked || + ! document.getElementById('check_vis_' + contr[K][key][key2][key3][0]).checked) { + continue; // if hide + } + var x1Left = document.getElementById(key2).offsetLeft + 1;// document.getElementById(key2+"."+key3).offsetLeft; + var x1Right = x1Left + document.getElementById(key2).offsetWidth; + var x2Left = document.getElementById(contr[K][key][key2][key3][0]).offsetLeft;// +document.getElementById(contr[K][key2][key3][0]+"."+contr[K][key2][key3][1]).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 y1 = document.getElementById(key2).offsetTop + document.getElementById(key2 + '.' + key3).offsetTop + heightField; + var y2 = document.getElementById(contr[K][key][key2][key3][0]).offsetTop + + document.getElementById(contr[K][key][key2][key3][0] + '.' + contr[K][key][key2][key3][1]).offsetTop + heightField; + + var osnTab = document.getElementById('osn_tab'); + if (!selected && localX > x1 - 10 && localX < x1 + 10 && localY > y1 - 7 && localY < y1 + 7) { + DesignerMove.line0( + x1 + osnTab.offsetLeft, + y1 - osnTab.offsetTop, + x2 + osnTab.offsetLeft, + y2 - osnTab.offsetTop, + 'rgba(255,0,0,1)'); + + selected = 1; + Key0 = contr[K][key][key2][key3][0]; + Key1 = contr[K][key][key2][key3][1]; + Key2 = key2; + Key3 = key3; + Key = K; + } else { + 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]) + ); + } + } + } + } + } + if (selected) { + // select relations + var left = globX - (document.getElementById('layer_upd_relation').offsetWidth >> 1); + document.getElementById('layer_upd_relation').style.left = left + 'px'; + var top = globY - document.getElementById('layer_upd_relation').offsetHeight - 10; + document.getElementById('layer_upd_relation').style.top = top + 'px'; + document.getElementById('layer_upd_relation').style.display = 'block'; + var argsep = CommonParams.get('arg_separator'); + linkRelation = 'T1=' + Key0 + argsep + 'F1=' + Key1 + argsep + 'T2=' + Key2 + argsep + 'F2=' + Key3 + argsep + 'K=' + Key; + } +}; + +DesignerMove.updRelation = function () { + document.getElementById('layer_upd_relation').style.display = 'none'; + var argsep = CommonParams.get('arg_separator'); + linkRelation += argsep + 'server=' + server + argsep + 'db=' + db; + linkRelation += argsep + 'operation=removeRelation' + argsep + 'ajax_request=true'; + + var $msgbox = Functions.ajaxShowMessage(Messages.strProcessingRequest); + $.post('db_designer.php', linkRelation, function (data) { + if (data.success === false) { + Functions.ajaxShowMessage(data.error, false); + } else { + Functions.ajaxRemoveMessage($msgbox); + DesignerMove.loadPage(selectedPage); + } + }); // end $.post() +}; + +DesignerMove.visibleTab = function (id, tN) { + if (id.checked) { + document.getElementById(tN).style.display = 'block'; + } else { + document.getElementById(tN).style.display = 'none'; + } + DesignerMove.reload(); +}; + +// max/min all tables +DesignerMove.hideTabAll = function (idThis) { + if (idThis.alt === 'v') { + idThis.alt = '>'; + idThis.src = idThis.dataset.right; + } else { + idThis.alt = 'v'; + idThis.src = idThis.dataset.down; + } + var E = document.getElementById('container-form'); + for (var i = 0; i < E.elements.length; i++) { + if (E.elements[i].type === 'checkbox' && E.elements[i].id.substring(0, 10) === 'check_vis_') { + if (idThis.alt === 'v') { + E.elements[i].checked = true; + document.getElementById(E.elements[i].value).style.display = ''; + } else { + E.elements[i].checked = false; + document.getElementById(E.elements[i].value).style.display = 'none'; + } + } + } + DesignerMove.reload(); +}; + +DesignerMove.inArrayK = function (x, m) { + var b = 0; + for (var u in m) { + if (x === u) { + b = 1; + break; + } + } + return b; +}; + +DesignerMove.noHaveConstr = function (idThis) { + var a = []; + var K; + var key; + var key2; + var key3; + 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 + a[key2] = a[contr[K][key][key2][key3][0]] = 1; // exist constr + } + } + } + } + + if (idThis.alt === 'v') { + idThis.alt = '>'; + idThis.src = idThis.dataset.right; + } else { + idThis.alt = 'v'; + idThis.src = idThis.dataset.down; + } + var E = document.getElementById('container-form'); + for (var i = 0; i < E.elements.length; i++) { + if (E.elements[i].type === 'checkbox' && E.elements[i].id.substring(0, 10) === 'check_vis_') { + if (!DesignerMove.inArrayK(E.elements[i].value, a)) { + if (idThis.alt === 'v') { + E.elements[i].checked = true; + document.getElementById(E.elements[i].value).style.display = ''; + } else { + E.elements[i].checked = false; + document.getElementById(E.elements[i].value).style.display = 'none'; + } + } + } + } +}; + +DesignerMove.generalScroll = function () { + // if (timeoutId) + clearTimeout(timeoutId); + timeoutId = setTimeout( + function () { + document.getElementById('top_menu').style.left = document.body.scrollLeft + 'px'; + document.getElementById('top_menu').style.top = document.body.scrollTop + 'px'; + }, + 200 + ); +}; + +// max/min all tables +DesignerMove.showLeftMenu = function (idThis) { + var icon = idThis.children[0]; + $('#key_Show_left_menu').toggleClass('M_butt_Selected_down'); + if (icon.alt === 'v') { + document.getElementById('layer_menu').style.top = '0px'; + document.getElementById('layer_menu').style.display = 'block'; + icon.alt = '>'; + icon.src = icon.dataset.up; + if (isIe) { + DesignerMove.generalScroll(); + } + } else { + document.getElementById('layer_menu').style.top = -1000 + 'px'; // fast scroll + document.getElementById('layer_menu').style.display = 'none'; + icon.alt = 'v'; + icon.src = icon.dataset.down; + } +}; + +DesignerMove.sideMenuRight = function (idThis) { + $('#side_menu').toggleClass('right'); + $('#layer_menu').toggleClass('left'); + var icon = $(idThis.childNodes[0]); + var current = icon.attr('src'); + icon.attr('src', icon.attr('data-right')).attr('data-right', current); + + icon = $(document.getElementById('layer_menu_sizer').childNodes[0]) + .toggleClass('floatleft') + .toggleClass('floatright') + .children(); + current = icon.attr('src'); + icon.attr('src', icon.attr('data-right')); + icon.attr('data-right', current); + menuMoved = !menuMoved; + DesignerMove.saveValueInConfig('side_menu', $('#side_menu').hasClass('right')); + $('#key_Left_Right').toggleClass('M_butt_Selected_down'); + $('#key_Left_Right').toggleClass('M_butt'); +}; + +DesignerMove.showText = function () { + $('#side_menu').find('.hidable').show(); +}; + +DesignerMove.hideText = function () { + if (!alwaysShowText) { + $('#side_menu').find('.hidable').hide(); + } +}; + +DesignerMove.pinText = function () { + alwaysShowText = !alwaysShowText; + $('#pin_Text').toggleClass('M_butt_Selected_down'); + $('#pin_Text').toggleClass('M_butt'); + DesignerMove.saveValueInConfig('pin_text', alwaysShowText); +}; + +DesignerMove.startDisplayField = function () { + if (onRelation) { + return; + } + if (!onDisplayField) { + onDisplayField = 1; + document.getElementById('designer_hint').innerHTML = Messages.strChangeDisplay; + document.getElementById('designer_hint').style.display = 'block'; + document.getElementById('display_field_button').className = 'M_butt_Selected_down';// '#FFEE99';gray #AAAAAA + + if (isIe) { // correct for IE + document.getElementById('display_field_button').className = 'M_butt_Selected_down_IE'; + } + } else { + document.getElementById('designer_hint').innerHTML = ''; + document.getElementById('designer_hint').style.display = 'none'; + document.getElementById('display_field_button').className = 'M_butt'; + onDisplayField = 0; + } +}; + +var TargetColors = []; + +DesignerMove.getColorByTarget = function (target) { + var color = ''; // "rgba(0,100,150,1)"; + + for (var targetColor in TargetColors) { + if (TargetColors[targetColor][0] === target) { + color = TargetColors[targetColor][1]; + break; + } + } + + if (color.length === 0) { + var i = TargetColors.length + 1; + var d = i % 6; + var j = (i - d) / 6; + j = j % 4; + j++; + var colorCase = [ + [1, 0, 0], + [0, 1, 0], + [0, 0, 1], + [1, 1, 0], + [1, 0, 1], + [0, 1, 1] + ]; + var a = colorCase[d][0]; + var b = colorCase[d][1]; + var c = colorCase[d][2]; + var e = (1 - (j - 1) / 6); + + var r = Math.round(a * 200 * e); + var g = Math.round(b * 200 * e); + b = Math.round(c * 200 * e); + color = 'rgba(' + r + ',' + g + ',' + b + ',1)'; + + TargetColors.push([target, color]); + } + + return color; +}; + +DesignerMove.clickOption = function (dbName, tableName, columnName, tableDbNameUrl, optionColNameString) { + var designerOptions = document.getElementById('designer_optionse'); + var left = globX - (designerOptions.offsetWidth >> 1); + designerOptions.style.left = left + 'px'; + // var top = Glob_Y - designerOptions.offsetHeight - 10; + designerOptions.style.top = (screen.height / 4) + 'px'; + designerOptions.style.display = 'block'; + document.getElementById('ok_add_object_db_and_table_name_url').value = tableDbNameUrl; + document.getElementById('ok_add_object_db_name').value = dbName; + document.getElementById('ok_add_object_table_name').value = tableName; + document.getElementById('ok_add_object_col_name').value = columnName; + document.getElementById('option_col_name').innerHTML = optionColNameString; +}; + +DesignerMove.closeOption = function () { + document.getElementById('designer_optionse').style.display = 'none'; + document.getElementById('rel_opt').value = '--'; + document.getElementById('Query').value = ''; + document.getElementById('new_name').value = ''; + document.getElementById('operator').value = '---'; + document.getElementById('groupby').checked = false; + document.getElementById('h_rel_opt').value = '--'; + document.getElementById('h_operator').value = '---'; + document.getElementById('having').value = ''; + document.getElementById('orderby').value = '---'; +}; + +DesignerMove.selectAll = function (tableName, dbName, idSelectAll) { + var parentIsChecked = $('#' + idSelectAll).is(':checked'); + var checkboxAll = $('#container-form input[id_check_all=\'' + idSelectAll + '\']:checkbox'); + + checkboxAll.each(function () { + // already checked and then check parent + if (parentIsChecked === true && this.checked) { + // was checked, removing column from selected fields + // trigger unchecked event + this.click(); + } + this.checked = parentIsChecked; + this.disabled = parentIsChecked; + }); + if (parentIsChecked) { + selectField.push('`' + tableName + '`.*'); + fromArray.push(tableName); + } else { + var i; + for (i = 0; i < selectField.length; i++) { + if (selectField[i] === ('`' + tableName + '`.*')) { + selectField.splice(i, 1); + } + } + var k; + for (k = 0; k < fromArray.length; k++) { + if (fromArray[k] === tableName) { + fromArray.splice(k, 1); + break; + } + } + } + DesignerMove.reload(); +}; + +DesignerMove.tableOnOver = function (idThis, val, buil) { + var builLocal = parseInt(buil); + if (!val) { + document.getElementById('id_zag_' + idThis).className = 'tab_zag_2'; + if (builLocal) { + document.getElementById('id_zag_' + idThis + '_2').className = 'tab_zag_2'; + } + } else { + document.getElementById('id_zag_' + idThis).className = 'tab_zag'; + if (builLocal) { + document.getElementById('id_zag_' + idThis + '_2').className = 'tab_zag'; + } + } +}; + +/** + * This function stores selected column information in selectField[] + * In case column is checked it add else it deletes + */ +DesignerMove.storeColumn = function (tableName, colName, checkboxId) { + var i; + var k; + var selectKeyField = '`' + tableName + '`.`' + colName + '`'; + if (document.getElementById(checkboxId).checked === true) { + selectField.push(selectKeyField); + fromArray.push(tableName); + } else { + for (i = 0; i < selectField.length; i++) { + if (selectField[i] === selectKeyField) { + selectField.splice(i, 1); + break; + } + } + for (k = 0; k < fromArray.length; k++) { + if (fromArray[k] === tableName) { + fromArray.splice(k, 1); + break; + } + } + } +}; + +/** + * This function builds object and adds them to historyArray + * first it does a few checks on each object, then makes an object(where,rename,groupby,aggregate,orderby) + * then a new history object is made and finally all these history objects are added to historyArray[] + */ +DesignerMove.addObject = function (dbName, tableName, colName, dbTableNameUrl) { + var p; + var whereObj; + var rel = document.getElementById('rel_opt'); + var sum = 0; + var init = historyArray.length; + if (rel.value !== '--') { + if (document.getElementById('Query').value === '') { + Functions.ajaxShowMessage(Functions.sprintf(Messages.strQueryEmpty)); + return; + } + p = document.getElementById('Query'); + whereObj = new DesignerHistory.Where(rel.value, p.value);// make where object + historyArray.push(new DesignerHistory.HistoryObj(colName, whereObj, tableName, hTabs[dbTableNameUrl], 'Where')); + sum = sum + 1; + } + if (document.getElementById('new_name').value !== '') { + var renameObj = new DesignerHistory.Rename(document.getElementById('new_name').value);// make Rename object + historyArray.push(new DesignerHistory.HistoryObj(colName, renameObj, tableName, hTabs[dbTableNameUrl], 'Rename')); + sum = sum + 1; + } + if (document.getElementById('operator').value !== '---') { + var aggregateObj = new DesignerHistory.Aggregate(document.getElementById('operator').value); + historyArray.push(new DesignerHistory.HistoryObj(colName, aggregateObj, tableName, hTabs[dbTableNameUrl], 'Aggregate')); + sum = sum + 1; + // make aggregate operator + } + if (document.getElementById('groupby').checked === true) { + historyArray.push(new DesignerHistory.HistoryObj(colName, 'GroupBy', tableName, hTabs[dbTableNameUrl], 'GroupBy')); + sum = sum + 1; + // make groupby + } + if (document.getElementById('h_rel_opt').value !== '--') { + if (document.getElementById('having').value === '') { + return; + } + whereObj = new DesignerHistory.Having( + document.getElementById('h_rel_opt').value, + document.getElementById('having').value, + document.getElementById('h_operator').value + );// make where object + historyArray.push(new DesignerHistory.HistoryObj(colName, whereObj, tableName, hTabs[dbTableNameUrl], 'Having')); + sum = sum + 1; + // make having + } + if (document.getElementById('orderby').value !== '---') { + var orderByObj = new DesignerHistory.OrderBy(document.getElementById('orderby').value); + historyArray.push(new DesignerHistory.HistoryObj(colName, orderByObj, tableName, hTabs[dbTableNameUrl], 'OrderBy')); + sum = sum + 1; + // make orderby + } + Functions.ajaxShowMessage(Functions.sprintf(Messages.strObjectsCreated, sum)); + // output sum new objects created + var existingDiv = document.getElementById('ab'); + existingDiv.innerHTML = DesignerHistory.display(init, historyArray.length); + DesignerMove.closeOption(); + $('#ab').accordion('refresh'); +}; + +DesignerMove.enablePageContentEvents = function () { + $('#page_content').off('mousedown'); + $('#page_content').off('mouseup'); + $('#page_content').off('mousemove'); + $('#page_content').on('mousedown', function (e) { + DesignerMove.mouseDown(e); + }); + $('#page_content').on('mouseup', function (e) { + DesignerMove.mouseUp(e); + }); + $('#page_content').on('mousemove', function (e) { + DesignerMove.mouseMove(e); + }); +}; + +/** + * This function enables the events on table items. + * It helps to enable them on page loading and when a table is added on the fly. + */ +DesignerMove.enableTableEvents = function (index, element) { + $(element).on('click', '.select_all_1', function () { + DesignerMove.selectAll($(this).attr('table_name'), $(this).attr('db_name'), $(this).attr('id')); + }); + $(element).on('click', '.small_tab,.small_tab2', function () { + DesignerMove.smallTab($(this).attr('table_name'), 1); + }); + $(element).on('click', '.small_tab_pref_1', function () { + DesignerMove.startTabUpd($(this).attr('db_url'), $(this).attr('table_name_url')); + }); + $(element).on('click', '.select_all_store_col', function () { + DesignerMove.storeColumn($(this).attr('table_name'), $(this).attr('col_name'), $(this).attr('id')); + }); + $(element).on('click', '.small_tab_pref_click_opt', function () { + DesignerMove.clickOption( + $(this).attr('db_name'), + $(this).attr('table_name'), + $(this).attr('col_name'), + $(this).attr('db_table_name_url'), + $(this).attr('option_col_name_modal') + ); + }); + $(element).on('click', '.tab_field_2,.tab_field_3,.tab_field', function () { + var params = ($(this).attr('click_field_param')).split(','); + DesignerMove.clickField(params[3], params[0], params[1], params[2]); + }); + + $(element).find('.tab_zag_noquery').mouseover(function () { + DesignerMove.tableOnOver($(this).attr('table_name'),0, $(this).attr('query_set')); + }); + $(element).find('.tab_zag_noquery').mouseout(function () { + DesignerMove.tableOnOver($(this).attr('table_name'),1, $(this).attr('query_set')); + }); + $(element).find('.tab_zag_query').mouseover(function () { + DesignerMove.tableOnOver($(this).attr('table_name'),0, 1); + }); + $(element).find('.tab_zag_query').mouseout(function () { + DesignerMove.tableOnOver($(this).attr('table_name'),1, 1); + }); + + DesignerMove.enablePageContentEvents(); +}; + +AJAX.registerTeardown('designer/move.js', function () { + $('#side_menu').off('mouseenter mouseleave'); + $('#key_Show_left_menu').off('click'); + $('#toggleFullscreen').off('click'); + $('#newPage').off('click'); + $('#editPage').off('click'); + $('#savePos').off('click'); + $('#SaveAs').off('click'); + $('#delPages').off('click'); + $('#StartTableNew').off('click'); + $('#rel_button').off('click'); + $('#StartTableNew').off('click'); + $('#display_field_button').off('click'); + $('#reloadPage').off('click'); + $('#angular_direct_button').off('click'); + $('#grid_button').off('click'); + $('#key_SB_all').off('click'); + $('#SmallTabInvert').off('click'); + $('#relLineInvert').off('click'); + $('#exportPages').off('click'); + $('#query_builder').off('click'); + $('#key_Left_Right').off('click'); + $('#pin_Text').off('click'); + $('#canvas').off('click'); + $('#key_HS_all').off('click'); + $('#key_HS').off('click'); + $('.scroll_tab_struct').off('click'); + $('.scroll_tab_checkbox').off('click'); + $('#id_scroll_tab').find('tr').off('click', '.designer_Tabs2,.designer_Tabs'); + $('.designer_tab').off('click', '.select_all_1'); + $('.designer_tab').off('click', '.small_tab,.small_tab2'); + $('.designer_tab').off('click', '.small_tab_pref_1'); + $('.tab_zag_noquery').off('mouseover'); + $('.tab_zag_noquery').off('mouseout'); + $('.tab_zag_query').off('mouseover'); + $('.tab_zag_query').off('mouseout'); + $('.designer_tab').off('click','.tab_field_2,.tab_field_3,.tab_field'); + $('.designer_tab').off('click', '.select_all_store_col'); + $('.designer_tab').off('click', '.small_tab_pref_click_opt'); + $('#del_button').off('click'); + $('#cancel_button').off('click'); + $('#ok_add_object').off('click'); + $('#cancel_close_option').off('click'); + $('#ok_new_rel_panel').off('click'); + $('#cancel_new_rel_panel').off('click'); + $('#page_content').off('mouseup'); + $('#page_content').off('mousedown'); + $('#page_content').off('mousemove'); +}); + +AJAX.registerOnload('designer/move.js', function () { + $('#key_Show_left_menu').on('click', function () { + DesignerMove.showLeftMenu(this); + return false; + }); + $('#toggleFullscreen').on('click', function () { + DesignerMove.toggleFullscreen(); + return false; + }); + $('#addOtherDbTables').on('click', function () { + DesignerMove.addOtherDbTables(); + return false; + }); + $('#newPage').on('click', function () { + DesignerMove.new(); + return false; + }); + $('#editPage').on('click', function () { + DesignerMove.editPages(); + return false; + }); + $('#savePos').on('click', function () { + DesignerMove.save3(); + return false; + }); + $('#SaveAs').on('click', function () { + DesignerMove.saveAs(); + return false; + }); + $('#delPages').on('click', function () { + DesignerMove.deletePages(); + return false; + }); + $('#StartTableNew').on('click', function () { + DesignerMove.startTableNew(); + return false; + }); + $('#rel_button').on('click', function () { + DesignerMove.startRelation(); + return false; + }); + $('#display_field_button').on('click', function () { + DesignerMove.startDisplayField(); + return false; + }); + $('#reloadPage').on('click', function () { + DesignerMove.loadPage(selectedPage); + }); + $('#angular_direct_button').on('click', function () { + DesignerMove.angularDirect(); + return false; + }); + $('#grid_button').on('click', function () { + DesignerMove.grid(); + return false; + }); + $('#key_SB_all').on('click', function () { + DesignerMove.smallTabAll(this); + return false; + }); + $('#SmallTabInvert').on('click', function () { + DesignerMove.smallTabInvert(); + return false; + }); + $('#relLineInvert').on('click', function () { + DesignerMove.relationLinesInvert(); + return false; + }); + $('#exportPages').on('click', function () { + DesignerMove.exportPages(); + return false; + }); + $('#query_builder').on('click', function () { + DesignerHistory.buildQuery('SQL Query on Database', 0); + }); + $('#key_Left_Right').on('click', function () { + DesignerMove.sideMenuRight(this); + return false; + }); + $('#side_menu').hover(function () { + DesignerMove.showText(); + return false; + }, function () { + DesignerMove.hideText(); + return false; + }); + $('#pin_Text').on('click', function () { + DesignerMove.pinText(this); + return false; + }); + $('#canvas').on('click', function (event) { + DesignerMove.canvasClick(this, event); + }); + $('#key_HS_all').on('click', function () { + DesignerMove.hideTabAll(this); + return false; + }); + $('#key_HS').on('click', function () { + DesignerMove.noHaveConstr(this); + return false; + }); + + $('.designer_tab').each(DesignerMove.enableTableEvents); + $('.designer_tab').each(DesignerMove.addTableToTablesList); + + $('input#del_button').click(function () { + DesignerMove.updRelation(); + }); + $('input#cancel_button').on('click', function () { + document.getElementById('layer_upd_relation').style.display = 'none'; + DesignerMove.reload(); + }); + $('input#ok_add_object').on('click', function () { + DesignerMove.addObject( + $('#ok_add_object_db_name').val(), + $('#ok_add_object_table_name').val(), + $('#ok_add_object_col_name').val(), + $('#ok_add_object_db_and_table_name_url').val() + ); + }); + $('input#cancel_close_option').on('click', function () { + DesignerMove.closeOption(); + }); + $('input#ok_new_rel_panel').on('click', function () { + DesignerMove.newRelation(); + }); + $('input#cancel_new_rel_panel').on('click', function () { + document.getElementById('layer_new_relation').style.display = 'none'; + }); + DesignerMove.enablePageContentEvents(); +}); diff --git a/srcs/phpmyadmin/js/designer/objects.js b/srcs/phpmyadmin/js/designer/objects.js new file mode 100644 index 0000000..6bb4037 --- /dev/null +++ b/srcs/phpmyadmin/js/designer/objects.js @@ -0,0 +1,17 @@ +// eslint-disable-next-line no-unused-vars +var DesignerObjects = { + PdfPage: function (dbName, pageDescr, tblCords) { + // eslint-disable-next-line no-unused-vars + var pgNr; + this.dbName = dbName; + this.pageDescr = pageDescr; + this.tblCords = tblCords; + }, + TableCoordinate: function (dbName, tableName, pdfPgNr, x, y) { + this.dbName = dbName; + this.tableName = tableName; + this.pdfPgNr = pdfPgNr; + this.x = x; + this.y = y; + } +}; diff --git a/srcs/phpmyadmin/js/designer/page.js b/srcs/phpmyadmin/js/designer/page.js new file mode 100644 index 0000000..633fb50 --- /dev/null +++ b/srcs/phpmyadmin/js/designer/page.js @@ -0,0 +1,169 @@ +/* global DesignerOfflineDB */ // js/designer/database.js +// eslint-disable-next-line no-unused-vars +/* global db, selectedPage:writable */ // js/designer/init.js +/* global DesignerMove */ // js/designer/move.js +/* global DesignerObjects */ // js/designer/objects.js + +var DesignerPage = {}; + +DesignerPage.showTablesInLandingPage = function (db) { + DesignerPage.loadFirstPage(db, function (page) { + if (page) { + DesignerPage.loadHtmlForPage(page.pgNr); + selectedPage = page.pgNr; + } else { + DesignerPage.showNewPageTables(true); + } + }); +}; + +DesignerPage.saveToNewPage = function (db, pageName, tablePositions, callback) { + DesignerPage.createNewPage(db, pageName, function (page) { + if (page) { + var tblCords = []; + var saveCallback = function (id) { + tblCords.push(id); + if (tablePositions.length === tblCords.length) { + page.tblCords = tblCords; + DesignerOfflineDB.addObject('pdf_pages', page); + } + }; + for (var pos = 0; pos < tablePositions.length; pos++) { + tablePositions[pos].pdfPgNr = page.pgNr; + DesignerPage.saveTablePositions(tablePositions[pos], saveCallback); + } + if (typeof callback !== 'undefined') { + callback(page); + } + } + }); +}; + +DesignerPage.saveToSelectedPage = function (db, pageId, pageName, tablePositions, callback) { + DesignerPage.deletePage(pageId); + DesignerPage.saveToNewPage(db, pageName, tablePositions, function (page) { + if (typeof callback !== 'undefined') { + callback(page); + } + selectedPage = page.pgNr; + }); +}; + +DesignerPage.createNewPage = function (db, pageName, callback) { + var newPage = new DesignerObjects.PdfPage(db, pageName); + DesignerOfflineDB.addObject('pdf_pages', newPage, function (pgNr) { + newPage.pgNr = pgNr; + if (typeof callback !== 'undefined') { + callback(newPage); + } + }); +}; + +DesignerPage.saveTablePositions = function (positions, callback) { + DesignerOfflineDB.addObject('table_coords', positions, callback); +}; + +DesignerPage.createPageList = function (db, callback) { + DesignerOfflineDB.loadAllObjects('pdf_pages', function (pages) { + var html = ''; + for (var p = 0; p < pages.length; p++) { + var page = pages[p]; + if (page.dbName === db) { + html += '<option value="' + page.pgNr + '">'; + html += Functions.escapeHtml(page.pageDescr) + '</option>'; + } + } + if (typeof callback !== 'undefined') { + callback(html); + } + }); +}; + +DesignerPage.deletePage = function (pageId, callback) { + DesignerOfflineDB.loadObject('pdf_pages', pageId, function (page) { + if (page) { + for (var i = 0; i < page.tblCords.length; i++) { + DesignerOfflineDB.deleteObject('table_coords', page.tblCords[i]); + } + DesignerOfflineDB.deleteObject('pdf_pages', pageId, callback); + } + }); +}; + +DesignerPage.loadFirstPage = function (db, callback) { + DesignerOfflineDB.loadAllObjects('pdf_pages', function (pages) { + var firstPage = null; + for (var i = 0; i < pages.length; i++) { + var page = pages[i]; + if (page.dbName === db) { + // give preference to a page having same name as the db + if (page.pageDescr === db) { + callback(page); + return; + } + if (firstPage === null) { + firstPage = page; + } + } + } + callback(firstPage); + }); +}; + +DesignerPage.showNewPageTables = function (check) { + var allTables = $('#id_scroll_tab').find('td input:checkbox'); + allTables.prop('checked', check); + for (var tab = 0; tab < allTables.length; tab++) { + var input = allTables[tab]; + if (input.value) { + var element = document.getElementById(input.value); + element.style.top = DesignerPage.getRandom(550, 20) + 'px'; + element.style.left = DesignerPage.getRandom(700, 20) + 'px'; + DesignerMove.visibleTab(input, input.value); + } + } + selectedPage = -1; + $('#page_name').text(Messages.strUntitled); + DesignerMove.markUnsaved(); +}; + +DesignerPage.loadHtmlForPage = function (pageId) { + DesignerPage.showNewPageTables(false); + DesignerPage.loadPageObjects(pageId, function (page, tblCords) { + $('#name-panel').find('#page_name').text(page.pageDescr); + DesignerMove.markSaved(); + for (var t = 0; t < tblCords.length; t++) { + var tbId = db + '.' + tblCords[t].tableName; + var table = document.getElementById(tbId); + table.style.top = tblCords[t].y + 'px'; + table.style.left = tblCords[t].x + 'px'; + + var checkbox = document.getElementById('check_vis_' + tbId); + checkbox.checked = true; + DesignerMove.visibleTab(checkbox, checkbox.value); + } + selectedPage = page.pgNr; + }); +}; + +DesignerPage.loadPageObjects = function (pageId, callback) { + DesignerOfflineDB.loadObject('pdf_pages', pageId, function (page) { + var tblCords = []; + var count = page.tblCords.length; + for (var i = 0; i < count; i++) { + DesignerOfflineDB.loadObject('table_coords', page.tblCords[i], function (tblCord) { + tblCords.push(tblCord); + if (tblCords.length === count) { + if (typeof callback !== 'undefined') { + callback(page, tblCords); + } + } + }); + } + }); +}; + +DesignerPage.getRandom = function (max, min) { + var val = Math.random() * (max - min) + min; + return Math.floor(val); +}; |