Server IP : 85.214.239.14 / Your IP : 18.117.10.207 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /var/www/wordpress/phpMyAdmin/js/designer/ |
Upload File : |
/* 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 () { var $content = $('#page_content'); var $img = $('#toggleFullscreen').find('img'); var $span = $img.siblings('span'); $content.css({ 'margin-left': '3px' }); $(document).on('fullscreenchange', function () { if (!$.fn.fullScreen() || !$content.fullScreen()) { $content.removeClass('content_fullscreen') .css({ 'width': 'auto', 'height': 'auto' }); $('#osn_tab').css({ 'width': 'auto', 'height': 'auto' }); $img.attr('src', $img.data('enter')) .attr('title', $span.data('enter')); $span.text($span.data('enter')); // Saving the fullscreen state in config when // designer exists fullscreen mode via ESC key var valueSent = 'off'; DesignerMove.saveValueInConfig('full_screen', valueSent); } }); $('#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.id === 'layer_menu_sizer_btn') { 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(); }; /** * 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 }); $('#osn_tab').css({ 'width': screen.width + 'px', 'height': screen.height }); valueSent = 'on'; $content.fullScreen(true); } else { $img.attr('src', $img.data('enter')) .attr('title', $span.data('enter')); $span.text($span.data('enter')); $content.removeClass('content_fullscreen') .css({ 'width': 'auto', 'height': 'auto' }); $('#osn_tab').css({ 'width': 'auto', 'height': 'auto' }); $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 tableIsChecked = $(tableDom).css('display') === 'block' ? 'checked' : ''; var checkboxStatus = (tableIsChecked === 'checked') ? Messages.strHide : Messages.strShow; 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="' + checkboxStatus + '"' + ' id="check_vis_' + dbEncoded + '.' + tableEncoded + '"' + ' style="margin:0;"' + ' type="checkbox"' + ' value="' + dbEncoded + '.' + tableEncoded + '"' + tableIsChecked + ' />' + ' </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 () { $(this).attr('title', function (i, currentvalue) { return currentvalue === Messages.strHide ? Messages.strShow : Messages.strHide; }); 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(); DesignerMove.markUnsaved(); }; // 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 moveMenuIcon = $(idThis.getElementsByTagName('img')[0]); var resizeIcon = $('#layer_menu_sizer > img') .toggleClass('floatleft') .toggleClass('floatright'); var srcResizeIcon = resizeIcon.attr('src'); resizeIcon.attr('src', resizeIcon.attr('data-right')); resizeIcon.attr('data-right', srcResizeIcon); var srcMoveIcon = moveMenuIcon.attr('src'); moveMenuIcon.attr('src', moveMenuIcon.attr('data-right')); moveMenuIcon.attr('data-right', srcMoveIcon); 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(); });