diff options
Diffstat (limited to 'srcs/phpmyadmin/js/designer/move.js')
| -rw-r--r-- | srcs/phpmyadmin/js/designer/move.js | 2214 |
1 files changed, 0 insertions, 2214 deletions
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(); -}); |