aboutsummaryrefslogtreecommitdiff
path: root/srcs/phpmyadmin/js/designer
diff options
context:
space:
mode:
authorCharles Cabergs <me@cacharle.xyz>2020-07-27 10:05:23 +0200
committerCharles Cabergs <me@cacharle.xyz>2020-07-27 10:05:23 +0200
commit5bf66662a9bdd62c5bccab15e607cd95cfb8fcab (patch)
tree39a1a4629749056191c05dfd899f931701b7acf3 /srcs/phpmyadmin/js/designer
parent5afd237bbd22028b85532b8c0b3fcead49a00764 (diff)
downloadft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.tar.gz
ft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.tar.bz2
ft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.zip
Removed wordpress and phpmyadmin, my server doesn't handle it well and it brings shame on my famillyHEADmaster
Diffstat (limited to 'srcs/phpmyadmin/js/designer')
-rw-r--r--srcs/phpmyadmin/js/designer/database.js149
-rw-r--r--srcs/phpmyadmin/js/designer/history.js859
-rw-r--r--srcs/phpmyadmin/js/designer/init.js75
-rw-r--r--srcs/phpmyadmin/js/designer/move.js2214
-rw-r--r--srcs/phpmyadmin/js/designer/objects.js17
-rw-r--r--srcs/phpmyadmin/js/designer/page.js169
6 files changed, 0 insertions, 3483 deletions
diff --git a/srcs/phpmyadmin/js/designer/database.js b/srcs/phpmyadmin/js/designer/database.js
deleted file mode 100644
index f8456d1..0000000
--- a/srcs/phpmyadmin/js/designer/database.js
+++ /dev/null
@@ -1,149 +0,0 @@
-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
deleted file mode 100644
index 0c30e75..0000000
--- a/srcs/phpmyadmin/js/designer/history.js
+++ /dev/null
@@ -1,859 +0,0 @@
-/* vim: set expandtab sw=4 ts=4 sts=4: */
-/**
- * @fileoverview function used in this file builds history tab and generates query.
- *
- * @requires jQuery
- * @requires move.js
- * @version $Id$
- */
-
-/* global contr */ // js/designer/init.js
-/* global fromArray:writable */ // js/designer/move.js
-/* global pmaThemeImage */ // js/messages.php
-
-var DesignerHistory = {};
-
-var historyArray = []; // Global array to store history objects
-var selectField = []; // Global array to store information for columns which are used in select clause
-var gIndex;
-var vqbEditor = null;
-
-/**
- * To display details of objects(where,rename,Having,aggregate,groupby,orderby,having)
- *
- * @param index index of historyArray where change is to be made
- *
-**/
-
-DesignerHistory.detail = function (index) {
- var type = historyArray[index].getType();
- var str;
- if (type === 'Where') {
- str = 'Where ' + historyArray[index].getColumnName() + historyArray[index].getObj().getRelationOperator() + historyArray[index].getObj().getQuery();
- }
- if (type === 'Rename') {
- str = 'Rename ' + historyArray[index].getColumnName() + ' To ' + historyArray[index].getObj().getRenameTo();
- }
- if (type === 'Aggregate') {
- str = 'Select ' + historyArray[index].getObj().getOperator() + '( ' + historyArray[index].getColumnName() + ' )';
- }
- if (type === 'GroupBy') {
- str = 'GroupBy ' + historyArray[index].getColumnName();
- }
- if (type === 'OrderBy') {
- str = 'OrderBy ' + historyArray[index].getColumnName() + ' ' + historyArray[index].getObj().getOrder();
- }
- if (type === 'Having') {
- str = 'Having ';
- if (historyArray[index].getObj().getOperator() !== 'None') {
- str += historyArray[index].getObj().getOperator() + '( ' + historyArray[index].getColumnName() + ' )';
- str += historyArray[index].getObj().getRelationOperator() + historyArray[index].getObj().getQuery();
- } else {
- str = 'Having ' + historyArray[index].getColumnName() + historyArray[index].getObj().getRelationOperator() + historyArray[index].getObj().getQuery();
- }
- }
- return str;
-};
-
-/**
- * Sorts historyArray[] first,using table name as the key and then generates the HTML code for history tab,
- * clubbing all objects of same tables together
- * This function is called whenever changes are made in historyArray[]
- *
- *
- * @param {int} init starting index of unsorted array
- * @param {int} finit last index of unsorted array
- *
-**/
-
-DesignerHistory.display = function (init, finit) {
- var str;
- var i;
- var j;
- var k;
- var sto;
- var temp;
- // this part sorts the history array based on table name,this is needed for clubbing all object of same name together.
- for (i = init; i < finit; i++) {
- sto = historyArray[i];
- temp = historyArray[i].getTab();// + '.' + historyArray[i].getObjNo(); for Self JOINS
- for (j = 0; j < i; j++) {
- if (temp > (historyArray[j].getTab())) {// + '.' + historyArray[j].getObjNo())) { //for Self JOINS
- for (k = i; k > j; k--) {
- historyArray[k] = historyArray[k - 1];
- }
- historyArray[j] = sto;
- break;
- }
- }
- }
- // this part generates HTML code for history tab.adds delete,edit,and/or and detail features with objects.
- str = ''; // string to store Html code for history tab
- for (i = 0; i < historyArray.length; i++) {
- temp = historyArray[i].getTab(); // + '.' + historyArray[i].getObjNo(); for Self JOIN
- str += '<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
deleted file mode 100644
index 81ec1e4..0000000
--- a/srcs/phpmyadmin/js/designer/init.js
+++ /dev/null
@@ -1,75 +0,0 @@
-/* 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
deleted file mode 100644
index 513dd06..0000000
--- a/srcs/phpmyadmin/js/designer/move.js
+++ /dev/null
@@ -1,2214 +0,0 @@
-/* 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
deleted file mode 100644
index 6bb4037..0000000
--- a/srcs/phpmyadmin/js/designer/objects.js
+++ /dev/null
@@ -1,17 +0,0 @@
-// 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
deleted file mode 100644
index 633fb50..0000000
--- a/srcs/phpmyadmin/js/designer/page.js
+++ /dev/null
@@ -1,169 +0,0 @@
-/* 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);
-};