diff options
Diffstat (limited to 'hugo/pmd_general.php')
| -rw-r--r-- | hugo/pmd_general.php | 879 |
1 files changed, 879 insertions, 0 deletions
diff --git a/hugo/pmd_general.php b/hugo/pmd_general.php new file mode 100644 index 0000000..f392694 --- /dev/null +++ b/hugo/pmd_general.php @@ -0,0 +1,879 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * phpMyAdmin designer general code + * + * @package PhpMyAdmin-Designer + */ + +/** + * + */ +require_once 'libraries/common.inc.php'; +require_once 'libraries/pmd_common.php'; + +/** + * Sets globals from $_GET + */ +$get_params = array( + 'db', + 'table', + 'token' +); +foreach ($get_params as $one_get_param) { + if (isset($_GET[$one_get_param])) { + $GLOBALS[$one_get_param] = $_GET[$one_get_param]; + } +} + +$script_display_field = get_tables_info(); +$tab_column = get_columns_info(); +$script_tables = get_script_tabs(); +$script_contr = get_script_contr(); +$tab_pos = get_tab_pos(); +$tables_pk_or_unique_keys = get_pk_or_unique_keys(); +$tables_all_keys = get_all_keys(); + +$params = array('lang' => $GLOBALS['lang']); +if (isset($GLOBALS['db'])) { + $params['db'] = $GLOBALS['db']; +} + +$response = PMA_Response::getInstance(); +$response->getFooter()->setMinimal(); +$header = $response->getHeader(); +$header->setBodyId('pmd_body'); +$scripts = $header->getScripts(); +$scripts->addFile('pmd/ajax.js'); +$scripts->addFile('pmd/history.js'); +$scripts->addFile('pmd/move.js'); +$scripts->addFile('pmd/iecanvas.js', true); +$scripts->addFile('pmd/init.js'); +$scripts->addFile('jquery/jquery.fullscreen.js'); + +require 'libraries/db_common.inc.php'; +require 'libraries/db_info.inc.php'; + +// Embed some data into HTML, later it will be read +// by pmd/init.js and converted to JS variables. +echo '<div id="script_server" class="hide">'; +echo htmlspecialchars($GLOBALS['server']); +echo '</div>'; +echo '<div id="script_db" class="hide">'; +echo htmlspecialchars($GLOBALS['db']); +echo '</div>'; +echo '<div id="script_token" class="hide">'; +echo htmlspecialchars($GLOBALS['token']); +echo '</div>'; +echo '<div id="script_tables" class="hide">'; +echo htmlspecialchars(json_encode($script_tables)); +echo '</div>'; +echo '<div id="script_contr" class="hide">'; +echo htmlspecialchars(json_encode($script_contr)); +echo '</div>'; +echo '<div id="script_display_field" class="hide">'; +echo htmlspecialchars(json_encode($script_display_field)); +echo '</div>'; + +?> +<div class="pmd_header" id="top_menu"> + <a href="#" onclick="Show_left_menu(document.getElementById('key_Show_left_menu')); return false" + class="M_butt first" target="_self"> + <img id='key_Show_left_menu' title="<?php echo __('Show/Hide left menu'); ?>" alt="v" + src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/downarrow2_m.png'); ?>" /> + </a> + <a href="#" id="enterFullscreen" onclick="Enter_fullscreen(); return false" class="M_butt" target="_self"> + <img title="<?php echo __('View in fullscreen') ?>" alt="" + src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/viewInFullscreen.png'); ?>" /> + </a> + <a href="#" id="exitFullscreen" onclick="Exit_fullscreen(); return false" class="M_butt hide" target="_self"> + <img title="<?php echo __('Exit fullscreen') ?>" alt="" + src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/exitFullscreen.png'); ?>" /> + </a> + <img class="M_bord" src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/bord.png'); ?>" alt="" /> + <a href="#" onclick="Save2(); return false" class="M_butt" target="_self"> + <img title="<?php echo __('Save position') ?>" alt="" + src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/save.png'); ?>" /> + </a> + <a href="#" onclick="Start_table_new(); return false" + class="M_butt" target="_self"> + <img title="<?php echo __('Create table')?>" alt="" + src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/table.png'); ?>" /> + </a> + <a href="#" onclick="Start_relation(); return false" class="M_butt" id="rel_button" target="_self"> + <img title="<?php echo __('Create relation') ?>" alt="" + src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/relation.png'); ?>" /> + </a> + <a href="#" onclick="Start_display_field(); return false" + class="M_butt" id="display_field_button" target="_self"> + <img title="<?php echo __('Choose column to display') ?>" alt="" + src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/display_field.png'); ?>" /> + </a> + <a href="#" onclick="location.reload(); return false" class="M_butt" target="_self"> + <img title="<?php echo __('Reload'); ?>" alt="" + src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/reload.png'); ?>" /> + </a> + <a href="<?php echo PMA_Util::getDocuLink('faq', 'faq6-31') ?>" target="documentation" class="M_butt" target="_self"> + <img title="<?php echo __('Help'); ?>" alt="" + src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/help.png'); ?>" /> + </a> + <img class="M_bord" src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/bord.png'); ?>" alt="" /> + <a href="#" onclick="Angular_direct(); return false" + class="M_butt" id="angular_direct_button" target="_self"> + <img title="<?php echo __('Angular links') . ' / ' . __('Direct links'); ?>" alt="" + src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/ang_direct.png'); ?>" /> + </a> + <a href="#" onclick="Grid(); return false" class="M_butt" id="grid_button" target="_self"> + <img title="<?php echo __('Snap to grid') ?>" + src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/grid.png'); ?>" alt="" /> + </a> + <img class="M_bord" src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/bord.png'); ?>" alt="" /> + <a href="#" onclick="Small_tab_all(document.getElementById('key_SB_all')); return false" + class="M_butt" target="_self"> + <img id='key_SB_all' title="<?php echo __('Small/Big All'); ?>" alt="v" + src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/downarrow1.png'); ?>" /> + </a> + <a href="#" onclick="Small_tab_invert(); return false" class="M_butt" target="_self" > + <img title="<?php echo __('Toggle small/big'); ?>" alt="key" + src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/bottom.png'); ?>" /> + </a> + <a href="#" onclick="Relation_lines_invert(); return false" class="M_butt" target="_self" > + <img title="<?php echo __('Toggle relation lines'); ?>" alt="key" + src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/toggle_lines.png'); ?>" /> + </a> + <img class="M_bord" src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/bord.png'); ?>" alt="" /> + <a href="#" onclick="PDF_save(); return false" class="M_butt ajax"> + <img src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/pdf.png'); ?>" alt="key" + width="20" height="20" title="<?php echo __('Import/Export coordinates for PDF schema'); ?>" /> + </a> +<?php +if (isset($_REQUEST['query'])) { + echo '<a href="#" onclick="build_query(\'SQL Query on Database\', 0)" onmousedown="return false;" + class="M_butt" target="_self">'; + echo '<img src="'. $_SESSION['PMA_Theme']->getImgPath('pmd/query_builder.png') . '" alt="key" width="20" height="20" title="'; + echo __('Build Query'); + echo '"/></a>'; +} +?> + <a href="#" onclick="Top_menu_right(document.getElementById('key_Left_Right')); return false" + class="M_butt last" target="_self"> + <img src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/2rightarrow_m.png'); ?>" + id="key_Left_Right" alt=">" title="<?php echo __('Move Menu'); ?>" /> + </a> +</div> + +<div id="canvas_outer"> +<form action="" method="post" name="form1"> +<div id="osn_tab"> + <canvas class="pmd" id="canvas" width="100" height="100" onclick="Canvas_click(this)"></canvas> +</div> +<div id="layer_menu" style="display:none;"> +<div class="center" style="padding-top:5px;"> + <a href="#" + onclick="Hide_tab_all(document.getElementById('key_HS_all')); return false" class="M_butt" target="_self"> + <img title="<?php echo __('Hide/Show all'); ?>" alt="v" + src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/downarrow1.png'); ?>" id='key_HS_all' /></a> + <a href="#" + onclick="No_have_constr(document.getElementById('key_HS')); return false" class="M_butt" target="_self"> + <img title="<?php echo __('Hide/Show Tables with no relation'); ?>" alt="v" + src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/downarrow2.png'); ?>" id='key_HS' /></a> +</div> + +<div id="id_scroll_tab" class="scroll_tab"> + <table width="100%" style="padding-left: 3px;"> +<?php +$name_cnt = count($GLOBALS['PMD']['TABLE_NAME']); +for ($i = 0; $i < $name_cnt; $i++) { + + echo '<tr><td title="' . __('Structure') . '" width="1px" ' + . 'onmouseover="this.className=\'L_butt2_2\'" ' + . 'onmouseout="this.className=\'L_butt2_1\'" class="L_butt2_1">'; + echo '<img ' + . 'onclick="Start_tab_upd(\'' . $GLOBALS['PMD_URL']["TABLE_NAME_SMALL"][$i] . '\');" ' + . 'src="' . $_SESSION['PMA_Theme']->getImgPath('pmd/exec.png') . '" alt="" />'; + echo '</td>'; + echo '<td width="1px">'; + echo '<input onclick="VisibleTab(this,\'' . $GLOBALS['PMD_URL']["TABLE_NAME"][$i] . '\')" ' + . 'title="' . __('Hide') . '" ' + . 'id="check_vis_' . $GLOBALS['PMD_URL']["TABLE_NAME"][$i] . '" ' + . 'style="margin:0px;" type="checkbox" ' + . 'value="' . $GLOBALS['PMD_URL']["TABLE_NAME"][$i] . '"'; + if (isset($tab_pos[$GLOBALS['PMD']["TABLE_NAME"][$i]])) { + echo $tab_pos[$GLOBALS['PMD']["TABLE_NAME"][$i]]["H"] ? 'checked="checked"' : ''; + } else { + echo 'checked="checked"'; + } + echo '/></td>'; + echo '<td class="pmd_Tabs" onmouseover="this.className=\'pmd_Tabs2\'" ' + . 'onmouseout="this.className=\'pmd_Tabs\'" ' + . 'onclick="Select_tab(\'' . $GLOBALS['PMD_URL']["TABLE_NAME"][$i] . '\');">'; + echo $GLOBALS['PMD_OUT']["TABLE_NAME"][$i]; + echo '</td>'; + echo '</tr>'; +} +echo '</table>'; +echo '</div>'; + +echo '<div class="center">'; +echo __('Number of tables') . ': ' . $name_cnt; +echo '</div>'; +echo '<div class="floatright">'; +echo '<div id="layer_menu_sizer" onmousedown="layer_menu_cur_click=1">'; +echo '</div>'; +echo '</div>'; +echo '</div>'; + +for ($i = 0; $i < count($GLOBALS['PMD']["TABLE_NAME"]); $i++) { + $t_n = $GLOBALS['PMD']["TABLE_NAME"][$i]; + $t_n_url = $GLOBALS['PMD_URL']["TABLE_NAME"][$i]; + + ?> +<input name="t_x[<?php echo $t_n_url ?>]" type="hidden" id="t_x_<?php echo $t_n_url ?>_" /> +<input name="t_y[<?php echo $t_n_url ?>]" type="hidden" id="t_y_<?php echo $t_n_url ?>_" /> +<input name="t_v[<?php echo $t_n_url ?>]" type="hidden" id="t_v_<?php echo $t_n_url ?>_" /> +<input name="t_h[<?php echo $t_n_url ?>]" type="hidden" id="t_h_<?php echo $t_n_url ?>_" /> + +<table id="<?php echo $t_n_url ?>" cellpadding="0" cellspacing="0" class="pmd_tab" + style="position: absolute; + left: <?php + echo isset($tab_pos[$t_n]) ? $tab_pos[$t_n]["X"] : rand(20, 700); ?>px; + top: <?php + echo isset($tab_pos[$t_n]) ? $tab_pos[$t_n]["Y"] : rand(20, 550); ?>px; + visibility: <?php + echo ! isset($tab_pos[$t_n]) || $tab_pos[$t_n]["H"] + ? "visible" + : "hidden"; ?>; + z-index: 1;"> +<thead> +<tr> + <?php + if (isset($_REQUEST['query'])) { + echo '<td class="select_all">'; + echo '<input type="checkbox" value="select_all_'.htmlspecialchars($t_n_url).'" style="margin: 0px;" '; + echo 'id="select_all_'.htmlspecialchars($t_n_url).'" title="select all" '; + echo 'onclick="Select_all(\''. htmlspecialchars($t_n_url) .'\',\''.htmlspecialchars($GLOBALS['PMD_OUT']["OWNER"][$i]).'\')"></td>'; + } + ?> + <td class="small_tab" onmouseover="this.className='small_tab2';" + onmouseout="this.className='small_tab';" + id="id_hide_tbody_<?php echo $t_n_url ?>" + onclick="Small_tab('<?php echo $t_n_url ?>', 1)"><?php + // no space alloawd here, between tags and content !!! + // JavaScript function does require this + if (! isset($tab_pos[$t_n]) || ! empty($tab_pos[$t_n]["V"])) { + echo 'v'; + } else { + echo '>'; + } + ?></td> + <td class="small_tab_pref" onmouseover="this.className='small_tab_pref2';" + onmouseout="this.className='small_tab_pref';" + onclick="Start_tab_upd('<?php echo $GLOBALS['PMD_URL']["TABLE_NAME_SMALL"][$i]; ?>');"> + <img src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/exec_small.png'); ?>" alt="" /></td> + <td id="id_zag_<?php echo $t_n_url ?>" class="tab_zag nowrap" + onmousedown="cur_click=document.getElementById('<?php echo $t_n_url ?>');"/ + onmouseover="Table_onover('<?php echo $t_n_url ?>',0,<?php echo (isset($_REQUEST['query'])? 1 : 0 )?> )" + onmouseout="Table_onover('<?php echo $t_n_url ?>',1,<?php echo (isset($_REQUEST['query']) ? 1 : 0 )?>)"> + <span class='owner'> + <?php + echo $GLOBALS['PMD_OUT']["OWNER"][$i]; + echo '.</span>'; + echo $GLOBALS['PMD_OUT']["TABLE_NAME_SMALL"][$i]; + ?></td> + <?php + if (isset($_REQUEST['query'])) { + echo '<td class="tab_zag" onmouseover="Table_onover(\''.htmlspecialchars($t_n_url).'\',0,1)" id="id_zag_'.htmlspecialchars($t_n_url).'_2"'; + echo 'onmousedown="cur_click=document.getElementById(\''.htmlspecialchars($t_n_url).'\');"'; + echo 'onmouseout="Table_onover(\''.htmlspecialchars($t_n_url).'\',1,1)">'; + } + ?> +</tr> +</thead> +<tbody id="id_tbody_<?php echo $t_n_url ?>" + <?php + if (isset($tab_pos[$t_n]) && empty($tab_pos[$t_n]["V"])) { + echo 'style="display: none;"'; + } + echo '>'; + $display_field = PMA_getDisplayField($db, $GLOBALS['PMD']["TABLE_NAME_SMALL"][$i]); + for ($j = 0, $id_cnt = count($tab_column[$t_n]["COLUMN_ID"]); $j < $id_cnt; $j++) { + ?> +<tr id="id_tr_<?php + echo $GLOBALS['PMD_URL']["TABLE_NAME_SMALL"][$i] . '.' + . urlencode($tab_column[$t_n]["COLUMN_NAME"][$j]) ?>" + <?php + if ($display_field == $tab_column[$t_n]["COLUMN_NAME"][$j]) { + echo ' class="tab_field_3" '; + } else { + echo ' class="tab_field" '; + } + ?> + onmouseover="old_class = this.className; this.className = 'tab_field_2';" + onmouseout="this.className = old_class;" + onmousedown="Click_field('<?php + echo $GLOBALS['PMD_URL']["TABLE_NAME_SMALL"][$i]."','".urlencode($tab_column[$t_n]["COLUMN_NAME"][$j])."',"; + if (!PMA_Util::isForeignKeySupported($GLOBALS['PMD']['TABLE_TYPE'][$i])) { + echo (isset($tables_pk_or_unique_keys[$t_n . "." . $tab_column[$t_n]["COLUMN_NAME"][$j]]) ? 1 : 0); + } else { + // if foreign keys are supported, it's not necessary that the + // index is a primary key + echo (isset($tables_all_keys[$t_n.".".$tab_column[$t_n]["COLUMN_NAME"][$j]]) ? 1 : 0); + } + ?>)"> + <?php + if (isset($_REQUEST['query'])) { + echo '<td class="select_all">'; + echo '<input value="'.htmlspecialchars($t_n_url).urlencode($tab_column[$t_n]["COLUMN_NAME"][$j]).'"'; + echo 'type="checkbox" id="select_'.htmlspecialchars($t_n_url).'._'.urlencode($tab_column[$t_n]["COLUMN_NAME"][$j]).'" '; + echo 'style="margin: 0px;" title="select_'.urlencode($tab_column[$t_n]["COLUMN_NAME"][$j]).'" '; + echo 'onclick="store_column(\''.urlencode($GLOBALS['PMD_OUT']["TABLE_NAME_SMALL"][$i]).'\',\''.htmlspecialchars($GLOBALS['PMD_OUT']["OWNER"][$i]).'\',\''.urlencode($tab_column[$t_n]["COLUMN_NAME"][$j]).'\')"></td>'; + }?> + <td width="10px" colspan="3" + id="<?php echo $t_n_url.".".urlencode($tab_column[$t_n]["COLUMN_NAME"][$j]) ?>"> + <div class="nowrap"> + <?php + if (isset($tables_pk_or_unique_keys[$t_n.".".$tab_column[$t_n]["COLUMN_NAME"][$j]])) { + ?> + <img src="<?php echo $_SESSION['PMA_Theme']->getImgPath(); ?>pmd/FieldKey_small.png" + alt="*" /> + <?php + } else { + ?> + <img src="<?php echo $_SESSION['PMA_Theme']->getImgPath(); ?>pmd/Field_small<?php + if (strstr($tab_column[$t_n]["TYPE"][$j], 'char') + || strstr($tab_column[$t_n]["TYPE"][$j], 'text') + ) { + echo '_char'; + } elseif (strstr($tab_column[$t_n]["TYPE"][$j], 'int') + || strstr($tab_column[$t_n]["TYPE"][$j], 'float') + || strstr($tab_column[$t_n]["TYPE"][$j], 'double') + || strstr($tab_column[$t_n]["TYPE"][$j], 'decimal') + ) { + echo '_int'; + } elseif (strstr($tab_column[$t_n]["TYPE"][$j], 'date') + || strstr($tab_column[$t_n]["TYPE"][$j], 'time') + || strstr($tab_column[$t_n]["TYPE"][$j], 'year') + ) { + echo '_date'; + } + ?>.png" alt="*" /> + <?php + } + echo htmlspecialchars( + $tab_column[$t_n]["COLUMN_NAME"][$j] . " : " . $tab_column[$t_n]["TYPE"][$j], + ENT_QUOTES + ); + echo "</div>\n</td>\n"; + if (isset($_REQUEST['query'])) { + //$temp = $GLOBALS['PMD_OUT']["OWNER"][$i].'.'.$GLOBALS['PMD_OUT']["TABLE_NAME_SMALL"][$i]; + echo '<td class="small_tab_pref" onmouseover="this.className=\'small_tab_pref2\';"'; + echo 'onmouseout="this.className=\'small_tab_pref\';"'; + echo 'onclick="Click_option(\'pmd_optionse\',\'' + . urlencode($tab_column[$t_n]["COLUMN_NAME"][$j]) . '\',\'' + . $GLOBALS['PMD_OUT']["TABLE_NAME_SMALL"][$i].'\')" >'; + echo '<img src="' + . $_SESSION['PMA_Theme']->getImgPath('pmd/exec_small.png') + . '" title="options" alt="" /></td> '; + } + echo "</tr>\n"; + } + echo "</tbody>\n</table>\n"; +} +?> +</form> +</div> +<div id="pmd_hint"></div> + +<table id="layer_new_relation" style="display:none;" + width="5%" cellpadding="0" cellspacing="0"> +<tbody> +<tr> + <td class="frams1" width="10px"></td> + <td class="frams5" width="99%" ></td> + <td class="frams2" width="10px"><div class="bor"></div></td> +</tr> +<tr> + <td class="frams8"></td> + <td class="input_tab"> + <table width="168" class="center" cellpadding="2" cellspacing="0"> + <thead> + <tr> + <td colspan="2" class="center nowrap"><strong><?php echo __('Create relation'); ?></strong></td> + </tr> + </thead> + <tbody id="foreign_relation"> + <tr> + <td colspan="2" class="center nowrap"><strong>FOREIGN KEY</strong></td> + </tr> + <tr> + <td width="58" class="nowrap">on delete</td> + <td width="102"><select name="on_delete" id="on_delete"> + <option value="nix" selected="selected">--</option> + <option value="CASCADE">CASCADE</option> + <option value="SET NULL">SET NULL</option> + <option value="NO ACTION">NO ACTION</option> + <option value="RESTRICT">RESTRICT</option> + </select> + </td> + </tr> + <tr> + <td class="nowrap">on update</td> + <td><select name="on_update" id="on_update"> + <option value="nix" selected="selected">--</option> + <option value="CASCADE">CASCADE</option> + <option value="SET NULL">SET NULL</option> + <option value="NO ACTION">NO ACTION</option> + <option value="RESTRICT">RESTRICT</option> + </select> + </td> + </tr> + </tbody> + <tbody> + <tr> + <td colspan="2" class="center nowrap"> + <input type="button" class="butt" name="Button" + value="<?php echo __('OK'); ?>" onclick="New_relation()" /> + <input type="button" class="butt" name="Button" + value="<?php echo __('Cancel'); ?>" + onclick="document.getElementById('layer_new_relation').style.display = 'none';" /> + </td> + </tr> + </tbody> + </table> + </td> + <td class="frams6"></td> +</tr> +<tr> + <td class="frams4"><div class="bor"></div></td> + <td class="frams7"></td> + <td class="frams3"></td> +</tr> +</tbody> +</table> + +<table id="layer_upd_relation" style="display:none;" + width="5%" cellpadding="0" cellspacing="0"> +<tbody> +<tr> + <td class="frams1" width="10px"></td> + <td class="frams5" width="99%"></td> + <td class="frams2" width="10px"><div class="bor"></div></td> +</tr> +<tr> + <td class="frams8"></td> + <td class="input_tab"> + <table width="100%" class="center" cellpadding="2" cellspacing="0"> + <tr> + <td colspan="3" class="center nowrap"><strong><?php echo __('Delete relation'); ?></strong></td> + </tr> + <tr> + <td colspan="3" class="center nowrap"> + <input name="Button" type="button" class="butt" + onclick="Upd_relation()" value="<?php echo __('Delete'); ?>" /> + <input type="button" class="butt" name="Button" + value="<?php echo __('Cancel'); ?>" + onclick="document.getElementById('layer_upd_relation').style.display = 'none'; Re_load();" /> + </td> + </tr> + </table></td> + <td class="frams6"></td> +</tr> +<tr> + <td class="frams4"><div class="bor"></div></td> + <td class="frams7"></td> + <td class="frams3"></td> +</tr> +</tbody> +</table> + +<table id="pmd_optionse" style="display:none;" + width="5%" cellpadding="0" cellspacing="0"> +<tbody> +<tr> + <td class="frams1" width="10px"></td> + <td class="frams5" width="99%" ></td> + <td class="frams2" width="10px"><div class="bor"></div></td> +</tr> +<tr> + <td class="frams8"></td> + <td class="input_tab"> + <table width="168" class="center" cellpadding="2" cellspacing="0"> + <thead> + <tr> + <td colspan="2" rowspan="2" id="option_col_name" class="center nowrap"></td> + </tr> + </thead> + <tbody id="where"> + <tr><td class="center nowrap"><b>WHERE</b></td></tr> + <tr> + <td width="58" class="nowrap"><?php echo __('Relation operator'); ?></td> + <td width="102"><select name="rel_opt" id="rel_opt"> + <option value="--" selected="selected"> -- </option> + <option value="="> = </option> + <option value=">"> > </option> + <option value="<"> < </option> + <option value=">="> >= </option> + <option value="<="> <= </option> + <option value="NOT"> NOT </option> + <option value="IN"> IN </option> + <option value="EXCEPT"> <?php echo __('Except'); ?> </option> + <option value="NOT IN"> NOT IN </option> + </select> + </td> + </tr> + <tr> + <td class="nowrap"><?php echo __('Value'); ?>/<br /><?php echo __('subquery'); ?></td> + <td><textarea id="Query" value="" cols="18"></textarea> + </td> + </tr> + <tr><td class="center nowrap"><b><?php echo __('Rename to'); ?></b></td></tr> + <tr> + <td width="58" class="nowrap"><?php echo __('New name'); ?></td> + <td width="102"><input type="text" value="" id="new_name"/></td> + </tr> + <tr><td class="center nowrap"><b><?php echo __('Aggregate'); ?></b></td></tr> + <tr> + <td width="58" class="nowrap"><?php echo __('Operator'); ?></td> + <td width="102"><select name="operator" id="operator"> + <option value="---" selected="selected">---</option> + <option value="sum" > SUM </option> + <option value="min"> MIN </option> + <option value="max"> MAX </option> + <option value="avg"> AVG </option> + <option value="count"> COUNT </option> + </select> + </td></tr> + <tr> + <td width="58" class="center nowrap"><b>GROUP BY</b></td> + <td><input type="checkbox" value="groupby" id="groupby"/></td> + </tr> + <tr> + <td width="58" class="center nowrap"><b>ORDER BY</b></td> + <td><input type="checkbox" value="orderby" id="orderby"/></td> + </tr> + <tr><td class="center nowrap"><b>HAVING</b></td></tr> + <tr> + <td width="58" class="nowrap"><?php echo __('Operator'); ?></td> + <td width="102"><select name="h_operator" id="h_operator"> + <option value="---" selected="selected">---</option> + <option value="None" > <?php echo __('None'); ?> </option> + <option value="sum" > SUM </option> + <option value="min"> MIN </option> + <option value="max"> MAX </option> + <option value="avg"> AVG </option> + <option value="count"> COUNT </option> + </select> + </td></tr> + <tr> + <td width="58" class="nowrap"><?php echo __('Relation operator'); ?></td> + <td width="102"><select name="h_rel_opt" id="h_rel_opt"> + <option value="--" selected="selected"> -- </option> + <option value="="> = </option> + <option value=">"> > </option> + <option value="<"> < </option> + <option value=">="> >= </option> + <option value="<="> <= </option> + <option value="NOT"> NOT </option> + <option value="IN"> IN </option> + <option value="EXCEPT"> <?php echo __('Except'); ?> </option> + <option value="NOT IN"> NOT IN </option> + </select> + </td> + </tr> + <tr> + <td width="58" class="nowrap"><?php echo __('Value'); ?>/<br/><?php echo __('subquery'); ?></td> + <td width="102"><textarea id="having" value="" cols="18"></textarea></td> + </tr> + </tbody> + <tbody> + <tr> + <td colspan="2" class="center nowrap"> + <input type="button" class="butt" name="Button" + value="<?php echo __('OK'); ?>" onclick="add_object()" /> + <input type="button" class="butt" name="Button" + value="<?php echo __('Cancel'); ?>" + onclick="Close_option()" /> + </td> + </tr> + </tbody> + </table> + </td> + <td class="frams6"></td> +</tr> +<tr> + <td class="frams4"><div class="bor"></div></td> + <td class="frams7"></td> + <td class="frams3"></td> +</tr> +</tbody> +</table> + +<table id="query_rename_to" style="display:none;" + width="5%" cellpadding="0" cellspacing="0"> +<tbody> +<tr> + <td class="frams1" width="10px"></td> + <td class="frams5" width="99%" ></td> + <td class="frams2" width="10px"><div class="bor"></div></td> +</tr> +<tr> + <td class="frams8"></td> + <td class="input_tab"> + <table width="168" class="center" cellpadding="2" cellspacing="0"> + <thead> + <tr> + <td colspan="2" class="center nowrap"><strong><?php echo __('Rename to'); ?></strong></td> + </tr> + </thead> + <tbody id="rename_to"> + <tr> + <td width="58" class="nowrap"><?php echo __('New name'); ?></td> + <td width="102"> + <input type="text" value="" id="e_rename"/> + </td> + </tr> + </tbody> + <tbody> + <tr> + <td colspan="2" class="center nowrap"> + <input type="button" class="butt" name="Button" + value="<?php echo __('OK'); ?>" onclick="edit('Rename')" /> + <input type="button" class="butt" name="Button" + value="<?php echo __('Cancel'); ?>" + onclick="document.getElementById('query_rename_to').style.display = 'none';" /> + </td> + </tr> + </tbody> + </table> + </td> + <td class="frams6"></td> +</tr> +<tr> + <td class="frams4"><div class="bor"></div></td> + <td class="frams7"></td> + <td class="frams3"></td> +</tr> +</tbody> +</table> + +<table id="query_having" style="display:none;" + width="5%" cellpadding="0" cellspacing="0"> +<tbody> + <tr> + <td class="frams1" width="10px"></td> + <td class="frams5" width="99%" ></td> + <td class="frams2" width="10px"><div class="bor"></div></td> + </tr> +<tr> + <td class="frams8"></td> + <td class="input_tab"> + <table width="168" class="center" cellpadding="2" cellspacing="0"> + <thead> + <tr> + <td colspan="2" class="center nowrap"><strong>HAVING</strong></td> + </tr> + </thead> + <tbody id="rename_to"> + <tr> + <td width="58" class="nowrap"><?php echo __('Operator'); ?></td> + <td width="102"><select name="hoperator" id="hoperator"> + <option value="---" selected="selected">---</option> + <option value="None" > None </option> + <option value="sum" > SUM </option> + <option value="min"> MIN </option> + <option value="max"> MAX </option> + <option value="avg"> AVG </option> + <option value="count"> COUNT </option> + </select> + </td></tr> + <tr> + <tr> + <td width="58" class="nowrap"><?php echo __('Operator'); ?></td> + <td width="102"><select name="hrel_opt" id="hrel_opt"> + <option value="--" selected="selected"> -- </option> + <option value="="> = </option> + <option value=">"> > </option> + <option value="<"> < </option> + <option value=">="> >= </option> + <option value="<="> <= </option> + <option value="NOT"> NOT </option> + <option value="IN"> IN </option> + <option value="EXCEPT"> <?php echo __('Except'); ?> </option> + <option value="NOT IN"> NOT IN </option> + </select> + </td> + </tr> + <tr> + <td class="nowrap"><?php echo __('Value'); ?>/<br /><?php echo __('subquery'); ?></td> + <td><textarea id="hQuery" value="" cols="18"></textarea> + </td> + </tr> + </tbody> + <tbody> + <tr> + <td colspan="2" class="center nowrap"> + <input type="button" class="butt" name="Button" + value="<?php echo __('OK'); ?>" onclick="edit('Having')" /> + <input type="button" class="butt" name="Button" + value="<?php echo __('Cancel'); ?>" + onclick="document.getElementById('query_having').style.display = 'none';" /> + </td> + </tr> + </tbody> + </table> + </td> + <td class="frams6"></td> +</tr> +<tr> + <td class="frams4"><div class="bor"></div></td> + <td class="frams7"></td> + <td class="frams3"></td> +</tr> +</tbody> +</table> + +<table id="query_Aggregate" style="display:none;" + width="5%" cellpadding="0" cellspacing="0"> +<tbody> +<tr> + <td class="frams1" width="10px"></td> + <td class="frams5" width="99%" ></td> + <td class="frams2" width="10px"><div class="bor"></div></td> +</tr> +<tr> + <td class="frams8"></td> + <td class="input_tab"> + <table width="168" class="center" cellpadding="2" cellspacing="0"> + <thead> + <tr> + <td colspan="2" class="center nowrap"><strong><?php echo __('Aggregate'); ?></strong></td> + </tr> + </thead> + <tbody> + <tr> + <td width="58" class="nowrap"><?php echo __('Operator'); ?></td> + <td width="102"> + <select name="operator" id="e_operator"> + <option value="---" selected="selected">---</option> + <option value="sum" > SUM </option> + <option value="min"> MIN </option> + <option value="max"> MAX </option> + <option value="avg"> AVG </option> + <option value="avg"> COUNT </option> + </select> + </td></tr> + </tbody> + <tbody> + <tr> + <td colspan="2" class="center nowrap"> + <input type="button" class="butt" name="Button" + value="<?php echo __('OK'); ?>" onclick="edit('Aggregate')" /> + <input type="button" class="butt" name="Button" + value="<?php echo __('Cancel'); ?>" + onclick="document.getElementById('query_Aggregate').style.display = 'none';" /> + </td> + </tr> + </tbody> + </table> + </td> + <td class="frams6"></td> +</tr> +<tr> + <td class="frams4"><div class="bor"></div></td> + <td class="frams7"></td> + <td class="frams3"></td> +</tr> +</tbody> +</table> + +<table id="query_where" style="display:none;" + width="5%" cellpadding="0" cellspacing="0"> +<tbody> + <tr> + <td class="frams1" width="10px"></td> + <td class="frams5" width="99%" ></td> + <td class="frams2" width="10px"><div class="bor"></div></td> + </tr> +<tr> + <td class="frams8"></td> + <td class="input_tab"> + <table width="168" class="center" cellpadding="2" cellspacing="0"> + <thead> + <tr> + <td colspan="2" class="center nowrap"><strong>WHERE</strong></td> + </tr> + </thead> + <tbody id="rename_to"> + <tr> + <td width="58" class="nowrap"><?php echo __('Operator'); ?></td> + <td width="102"><select name="erel_opt" id="erel_opt"> + <option value="--" selected="selected"> -- </option> + <option value="=" > = </option> + <option value=">"> > </option> + <option value="<"> < </option> + <option value=">="> >= </option> + <option value="<="> <= </option> + <option value="NOT"> NOT </option> + <option value="IN"> IN </option> + <option value="EXCEPT"> <?php echo __('Except'); ?> </option> + <option value="NOT IN"> NOT IN </option> + </select> + </td> + </tr> + <tr> + <td class="nowrap"><?php echo __('Value'); ?>/<br /><?php echo __('subquery'); ?></td> + <td><textarea id="eQuery" value="" cols="18"></textarea> + </td> + </tr> + </tbody> + <tbody> + <tr> + <td colspan="2" class="center nowrap"> + <input type="button" class="butt" name="Button" + value="<?php echo __('OK'); ?>" onclick="edit('Where')" /> + <input type="button" class="butt" name="Button" + value="<?php echo __('Cancel'); ?>" + onclick="document.getElementById('query_where').style.display = 'none';" /> + </td> + </tr> + </tbody> + </table> + </td> + <td class="frams6"></td> +</tr> +<tr> + <td class="frams4"><div class="bor"></div></td> + <td class="frams7"></td> + <td class="frams3"></td> +</tr> +</tbody> +</table> + +<?php +if (! empty($_REQUEST['query'])) { + echo '<div class="panel">'; + echo '<div style="clear:both;"></div>'; + echo '<div id="ab"></div>'; + echo '<div style="clear:both;"></div>'; + echo '</div>'; + echo '<a class="trigger" href="#">' . __('Active options') . '</a>'; + echo '<div id="filter"></div>'; + echo '<div id="box">'; + echo '<span id="boxtitle"></span>'; + echo '<form method="post" action="db_qbe.php">'; + echo '<textarea cols="80" name="sql_query" id="textSqlquery" rows="15"></textarea><div id="tblfooter">'; + echo ' <input type="submit" name="submit_sql" class="btn" />'; + echo ' <input type="button" name="cancel" value="' . __('Cancel') . '" onclick="closebox()" class="btn" />'; + echo PMA_generate_common_hidden_inputs($GLOBALS['db']); + echo '</div></p>'; + echo '</form></div>'; + +} ?> + + +<!-- cache images --> +<img src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/2leftarrow_m.png'); ?>" width="0" height="0" alt="" /> +<img src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/rightarrow1.png'); ?>" width="0" height="0" alt="" /> +<img src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/rightarrow2.png'); ?>" width="0" height="0" alt="" /> +<img src="<?php echo $_SESSION['PMA_Theme']->getImgPath('pmd/uparrow2_m.png'); ?>" width="0" height="0" alt="" /> +<div id="PMA_disable_floating_menubar"></div> |