browse_foreigners.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * display selection for relational field values
   5  *
   6  * @package PhpMyAdmin
   7  */
   8
   9 require_once 'libraries/common.inc.php';
  10 require_once 'libraries/transformations.lib.php';
  11
  12 /**
  13  * Sets globals from $_REQUEST
  14  */
  15 $request_params = array(
  16     'field',
  17     'fieldkey',
  18     'foreign_filter',
  19     'pos',
  20     'rownumber'
  21 );
  22
  23 foreach ($request_params as $one_request_param) {
  24     if (isset($_REQUEST[$one_request_param])) {
  25         $GLOBALS[$one_request_param] = $_REQUEST[$one_request_param];
  26     }
  27 }
  28
  29 PMA_Util::checkParameters(array('db', 'table', 'field'));
  30
  31 $response = PMA_Response::getInstance();
  32 $response->getFooter()->setMinimal();
  33 $header = $response->getHeader();
  34 $header->disableMenu();
  35 $header->setBodyId('body_browse_foreigners');
  36
  37 /**
  38  * Displays the frame
  39  */
  40
  41 $cfgRelation = PMA_getRelationsParam();
  42 $foreigners  = ($cfgRelation['relwork'] ? PMA_getForeigners($db, $table) : false);
  43
  44 $override_total = true;
  45
  46 if (! isset($pos)) {
  47     $pos = 0;
  48 }
  49
  50 $foreign_limit = 'LIMIT ' . $pos . ', ' . $GLOBALS['cfg']['MaxRows'] . ' ';
  51 if (isset($foreign_navig) && $foreign_navig == __('Show all')) {
  52     unset($foreign_limit);
  53 }
  54
  55 $foreignData = PMA_getForeignData(
  56     $foreigners, $field, $override_total,
  57     isset($foreign_filter) ? $foreign_filter : '', $foreign_limit
  58 );
  59
  60 if (isset($rownumber)) {
  61     $rownumber_param = '&amp;rownumber=' . urlencode($rownumber);
  62 } else {
  63     $rownumber_param = '';
  64 }
  65
  66 $gotopage = '';
  67 $showall = '';
  68
  69 if (is_array($foreignData['disp_row'])) {
  70
  71     if ($cfg['ShowAll']
  72         && ($foreignData['the_total'] > $GLOBALS['cfg']['MaxRows'])
  73     ) {
  74         $showall = '<input type="submit" name="foreign_navig" value="'
  75                  . __('Show all') . '" />';
  76     }
  77
  78     $session_max_rows = $GLOBALS['cfg']['MaxRows'];
  79     $pageNow = @floor($pos / $session_max_rows) + 1;
  80     $nbTotalPage = @ceil($foreignData['the_total'] / $session_max_rows);
  81
  82     if ($foreignData['the_total'] > $GLOBALS['cfg']['MaxRows']) {
  83         $gotopage = PMA_Util::pageselector(
  84             'pos',
  85             $session_max_rows,
  86             $pageNow,
  87             $nbTotalPage,
  88             200,
  89             5,
  90             5,
  91             20,
  92             10,
  93             __('Page number:')
  94         );
  95     }
  96 }
  97
  98 // When coming from Table/Zoom search
  99 if (isset($_REQUEST['fromsearch'])) {
 100     // In table or zoom search, input fields are named "criteriaValues"
 101     $element_name = " var field = 'criteriaValues';\n";
 102 } else {
 103     // In insert/edit, input fields are named "fields"
 104     $element_name = " var field = 'fields';\n";
 105 }
 106
 107 if (isset($rownumber)) {
 108     $element_name  .= "        var element_name = field + '[multi_edit]["
 109         . htmlspecialchars($rownumber) . "][' + fieldmd5 + ']';\n"
 110         . "        var null_name = field_null + '[multi_edit]["
 111         . htmlspecialchars($rownumber) . "][' + fieldmd5 + ']';\n";
 112 } else {
 113     $element_name .= "var element_name = field + '[]'";
 114 }
 115 $error = PMA_jsFormat(
 116     __(
 117         'The target browser window could not be updated. '
 118         . 'Maybe you have closed the parent window, or '
 119         . 'your browser\'s security settings are '
 120         . 'configured to block cross-window updates.'
 121     )
 122 );
 123
 124
 125 if (! isset($fieldkey) || ! is_numeric($fieldkey)) {
 126     $fieldkey = 0;
 127 }
 128
 129 $code = <<<EOC
 130 self.focus();
 131 function formupdate(fieldmd5, key) {
 132     var \$inline = window.opener.jQuery('.browse_foreign_clicked');
 133     if (\$inline.length != 0) {
 134         \$inline.removeClass('browse_foreign_clicked')
 135             // for grid editing,
 136             // puts new value in the previous element which is
 137             // a span with class curr_value, and trigger .change()
 138             .prev('.curr_value').text(key).change();
 139         // for zoom-search editing, puts new value in the previous
 140         // element which is an input field
 141         \$inline.prev('input[type=text]').val(key);
 142         self.close();
 143         return false;
 144     }
 145
 146     if (opener && opener.document && opener.document.insertForm) {
 147         var field = 'fields';
 148         var field_null = 'fields_null';
 149
 150         $element_name
 151
 152         var element_name_alt = field + '[$fieldkey]';
 153
 154         if (opener.document.insertForm.elements[element_name]) {
 155             // Edit/Insert form
 156             opener.document.insertForm.elements[element_name].value = key;
 157             if (opener.document.insertForm.elements[null_name]) {
 158                 opener.document.insertForm.elements[null_name].checked = false;
 159             }
 160             self.close();
 161             return false;
 162         } else if (opener.document.insertForm.elements[element_name_alt]) {
 163             // Search form
 164             opener.document.insertForm.elements[element_name_alt].value = key;
 165             self.close();
 166             return false;
 167         }
 168     }
 169
 170     alert('$error');
 171 }
 172 EOC;
 173
 174 $header->getScripts()->addCode($code);
 175
 176 // HTML output
 177 $output = '<form action="browse_foreigners.php" method="post">'
 178     . '<fieldset>'
 179     . PMA_generate_common_hidden_inputs($db, $table)
 180     . '<input type="hidden" name="field" value="' . htmlspecialchars($field) . '" />'
 181     . '<input type="hidden" name="fieldkey" value="'
 182     . (isset($fieldkey) ? htmlspecialchars($fieldkey) : '') . '" />';
 183
 184 if (isset($rownumber)) {
 185     $output .= '<input type="hidden" name="rownumber" value="'
 186         . htmlspecialchars($rownumber) . '" />';
 187 }
 188 $output .= '<span class="formelement">'
 189     . '<label for="input_foreign_filter">' . __('Search') . ':' . '</label>'
 190     . '<input type="text" name="foreign_filter" id="input_foreign_filter" value="'
 191     . (isset($foreign_filter) ? htmlspecialchars($foreign_filter) : '') . '" />'
 192     . '<input type="submit" name="submit_foreign_filter" value="'
 193     .  __('Go') . '" />'
 194     . '</span>'
 195     . '<span class="formelement">' . $gotopage . '</span>'
 196     . '<span class="formelement">' . $showall . '</span>'
 197     . '</fieldset>'
 198     . '</form>';
 199
 200 $output .= '<table width="100%">';
 201
 202 if (is_array($foreignData['disp_row'])) {
 203     $header = '<tr>
 204         <th>' . __('Keyname') . '</th>
 205         <th>' . __('Description') . '</th>
 206         <td width="20%"></td>
 207         <th>' . __('Description') . '</th>
 208         <th>' . __('Keyname') . '</th>
 209     </tr>';
 210
 211     $output .= '<thead>' . $header . '</thead>' . "\n"
 212         . '<tfoot>' . $header . '</tfoot>' . "\n"
 213         . '<tbody>' . "\n";
 214
 215     $values = array();
 216     $keys   = array();
 217     foreach ($foreignData['disp_row'] as $relrow) {
 218         if ($foreignData['foreign_display'] != false) {
 219             $values[] = $relrow[$foreignData['foreign_display']];
 220         } else {
 221             $values[] = '';
 222         }
 223
 224         $keys[] = $relrow[$foreignData['foreign_field']];
 225     }
 226
 227     asort($keys);
 228
 229     $hcount = 0;
 230     $odd_row = true;
 231     $val_ordered_current_row = 0;
 232     $val_ordered_current_equals_data = false;
 233     $key_ordered_current_equals_data = false;
 234     foreach ($keys as $key_ordered_current_row => $value) {
 235         $hcount++;
 236
 237         if ($cfg['RepeatCells'] > 0 && $hcount > $cfg['RepeatCells']) {
 238             $output .= $header;
 239             $hcount = 0;
 240             $odd_row = true;
 241         }
 242
 243         $key_ordered_current_key = $keys[$key_ordered_current_row];
 244         $key_ordered_current_val = $values[$key_ordered_current_row];
 245
 246         $val_ordered_current_key = $keys[$val_ordered_current_row];
 247         $val_ordered_current_val = $values[$val_ordered_current_row];
 248
 249         $val_ordered_current_row++;
 250
 251         if (PMA_strlen($val_ordered_current_val) <= $cfg['LimitChars']) {
 252             $val_ordered_current_val = htmlspecialchars(
 253                 $val_ordered_current_val
 254             );
 255             $val_ordered_current_val_title = '';
 256         } else {
 257             $val_ordered_current_val_title = htmlspecialchars(
 258                 $val_ordered_current_val
 259             );
 260             $val_ordered_current_val = htmlspecialchars(
 261                 PMA_substr($val_ordered_current_val, 0, $cfg['LimitChars'])
 262                 . '...'
 263             );
 264         }
 265         if (PMA_strlen($key_ordered_current_val) <= $cfg['LimitChars']) {
 266             $key_ordered_current_val = htmlspecialchars(
 267                 $key_ordered_current_val
 268             );
 269             $key_ordered_current_val_title = '';
 270         } else {
 271             $key_ordered_current_val_title = htmlspecialchars(
 272                 $key_ordered_current_val
 273             );
 274             $key_ordered_current_val = htmlspecialchars(
 275                 PMA_substr(
 276                     $key_ordered_current_val, 0, $cfg['LimitChars']
 277                 ) . '...'
 278             );
 279         }
 280
 281         if (! empty($data)) {
 282             $val_ordered_current_equals_data = $val_ordered_current_key == $data;
 283             $key_ordered_current_equals_data = $key_ordered_current_key == $data;
 284         }
 285
 286         $output .= '<tr class="noclick ' . ($odd_row ? 'odd' : 'even') . '">';
 287         $odd_row = ! $odd_row;
 288
 289         $output .= '<td class="nowrap">'
 290             . ($key_ordered_current_equals_data ? '<strong>' : '')
 291             . '<a href="#" title="' . __('Use this value')
 292             . ($key_ordered_current_val_title != ''
 293                 ? ': ' . $key_ordered_current_val_title
 294                 : '') . '"'
 295             . ' onclick="formupdate(\'' . md5($field) . '\', \''
 296             . PMA_jsFormat($key_ordered_current_key, false) . '\'); return false;">'
 297             . htmlspecialchars($key_ordered_current_key)
 298             . '</a>' . ($key_ordered_current_equals_data ? '</strong>' : '')
 299             . '</td>';
 300
 301         $output .= '<td>'
 302             . ($key_ordered_current_equals_data ? '<strong>' : '')
 303             . '<a href="#" title="' . __('Use this value')
 304             . ($key_ordered_current_val_title != '' ? ': '
 305             . $key_ordered_current_val_title : '') . '" onclick="formupdate(\''
 306             . md5($field) . '\', \''
 307             . PMA_jsFormat($key_ordered_current_key, false)
 308             . '\'); return false;">'
 309             . $key_ordered_current_val . '</a>'
 310             . ($key_ordered_current_equals_data ? '</strong>' : '')
 311             . '</td>';
 312
 313         $output .= '<td width="20%">'
 314             . '<img src="' . $GLOBALS['pmaThemeImage'] . 'spacer.png" alt=""'
 315             . ' width="1" height="1" /></td>';
 316
 317         $output .= '<td>'
 318             . ($val_ordered_current_equals_data ? '<strong>' : '')
 319             . '<a href="#" title="' . __('Use this value')
 320             .  ($val_ordered_current_val_title != '' ? ': '
 321             . $val_ordered_current_val_title : '') . '" onclick="formupdate(\''
 322             . md5($field) . '\', \''
 323             . PMA_jsFormat($val_ordered_current_key, false)
 324             . '\'); return false;">'
 325             . $val_ordered_current_val . '</a>'
 326             . ($val_ordered_current_equals_data ? '</strong>' : '')
 327             . '</td>';
 328
 329         $output .= '<td class="nowrap">'
 330             . ($val_ordered_current_equals_data ? '<strong>' : '')
 331             . '<a href="#" title="' . __('Use this value')
 332             . ($val_ordered_current_val_title != ''
 333                 ? ': ' . $val_ordered_current_val_title : '')
 334             . '" onclick="formupdate(\'' . md5($field) . '\', \''
 335             . PMA_jsFormat($val_ordered_current_key, false) . '\'); return false;">'
 336             . htmlspecialchars($val_ordered_current_key)
 337             . '</a>' . ($val_ordered_current_equals_data ? '</strong>' : '')
 338             . '</td>';
 339         $output .= '</tr>';
 340     } // end while
 341 }
 342
 343 $output .= '</tbody>'
 344     . '</table>';
 345
 346 $response->addHtml($output);
 347 ?>