2 /* vim: set expandtab sw=4 ts=4 sts=4: */
4 * display selection for relational field values
9 require_once 'libraries/common.inc.php';
10 require_once 'libraries/transformations.lib.php';
13 * Sets globals from $_REQUEST
15 $request_params = array(
23 foreach ($request_params as $one_request_param) {
24 if (isset($_REQUEST[$one_request_param])) {
25 $GLOBALS[$one_request_param] = $_REQUEST[$one_request_param];
29 PMA_Util
::checkParameters(array('db', 'table', 'field'));
31 $response = PMA_Response
::getInstance();
32 $response->getFooter()->setMinimal();
33 $header = $response->getHeader();
34 $header->disableMenu();
35 $header->setBodyId('body_browse_foreigners');
41 $cfgRelation = PMA_getRelationsParam();
42 $foreigners = ($cfgRelation['relwork'] ?
PMA_getForeigners($db, $table) : false);
44 $override_total = true;
50 $foreign_limit = 'LIMIT ' . $pos . ', ' . $GLOBALS['cfg']['MaxRows'] . ' ';
51 if (isset($foreign_navig) && $foreign_navig == __('Show all')) {
52 unset($foreign_limit);
55 $foreignData = PMA_getForeignData(
56 $foreigners, $field, $override_total,
57 isset($foreign_filter) ?
$foreign_filter : '', $foreign_limit
60 if (isset($rownumber)) {
61 $rownumber_param = '&rownumber=' . urlencode($rownumber);
63 $rownumber_param = '';
69 if (is_array($foreignData['disp_row'])) {
72 && ($foreignData['the_total'] > $GLOBALS['cfg']['MaxRows'])
74 $showall = '<input type="submit" name="foreign_navig" value="'
75 . __('Show all') . '" />';
78 $session_max_rows = $GLOBALS['cfg']['MaxRows'];
79 $pageNow = @floor
($pos / $session_max_rows) +
1;
80 $nbTotalPage = @ceil
($foreignData['the_total'] / $session_max_rows);
82 if ($foreignData['the_total'] > $GLOBALS['cfg']['MaxRows']) {
83 $gotopage = PMA_Util
::pageselector(
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";
103 // In insert/edit, input fields are named "fields"
104 $element_name = " var field = 'fields';\n";
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";
113 $element_name .= "var element_name = field + '[]'";
115 $error = PMA_jsFormat(
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.'
125 if (! isset($fieldkey) ||
! is_numeric($fieldkey)) {
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')
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);
146 if (opener && opener.document && opener.document.insertForm) {
147 var field = 'fields';
148 var field_null = 'fields_null';
152 var element_name_alt = field + '[$fieldkey]';
154 if (opener.document.insertForm.elements[element_name]) {
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;
162 } else if (opener.document.insertForm.elements[element_name_alt]) {
164 opener.document.insertForm.elements[element_name_alt].value = key;
174 $header->getScripts()->addCode($code);
177 $output = '<form action="browse_foreigners.php" method="post">'
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) : '') . '" />';
184 if (isset($rownumber)) {
185 $output .= '<input type="hidden" name="rownumber" value="'
186 . htmlspecialchars($rownumber) . '" />';
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="'
195 . '<span class="formelement">' . $gotopage . '</span>'
196 . '<span class="formelement">' . $showall . '</span>'
200 $output .= '<table width="100%">';
202 if (is_array($foreignData['disp_row'])) {
204 <th>' . __('Keyname') . '</th>
205 <th>' . __('Description') . '</th>
206 <td width="20%"></td>
207 <th>' . __('Description') . '</th>
208 <th>' . __('Keyname') . '</th>
211 $output .= '<thead>' . $header . '</thead>' . "\n"
212 . '<tfoot>' . $header . '</tfoot>' . "\n"
217 foreach ($foreignData['disp_row'] as $relrow) {
218 if ($foreignData['foreign_display'] != false) {
219 $values[] = $relrow[$foreignData['foreign_display']];
224 $keys[] = $relrow[$foreignData['foreign_field']];
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) {
237 if ($cfg['RepeatCells'] > 0 && $hcount > $cfg['RepeatCells']) {
243 $key_ordered_current_key = $keys[$key_ordered_current_row];
244 $key_ordered_current_val = $values[$key_ordered_current_row];
246 $val_ordered_current_key = $keys[$val_ordered_current_row];
247 $val_ordered_current_val = $values[$val_ordered_current_row];
249 $val_ordered_current_row++
;
251 if (PMA_strlen($val_ordered_current_val) <= $cfg['LimitChars']) {
252 $val_ordered_current_val = htmlspecialchars(
253 $val_ordered_current_val
255 $val_ordered_current_val_title = '';
257 $val_ordered_current_val_title = htmlspecialchars(
258 $val_ordered_current_val
260 $val_ordered_current_val = htmlspecialchars(
261 PMA_substr($val_ordered_current_val, 0, $cfg['LimitChars'])
265 if (PMA_strlen($key_ordered_current_val) <= $cfg['LimitChars']) {
266 $key_ordered_current_val = htmlspecialchars(
267 $key_ordered_current_val
269 $key_ordered_current_val_title = '';
271 $key_ordered_current_val_title = htmlspecialchars(
272 $key_ordered_current_val
274 $key_ordered_current_val = htmlspecialchars(
276 $key_ordered_current_val, 0, $cfg['LimitChars']
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;
286 $output .= '<tr class="noclick ' . ($odd_row ?
'odd' : 'even') . '">';
287 $odd_row = ! $odd_row;
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
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>' : '')
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>' : '')
313 $output .= '<td width="20%">'
314 . '<img src="' . $GLOBALS['pmaThemeImage'] . 'spacer.png" alt=""'
315 . ' width="1" height="1" /></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>' : '')
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>' : '')
343 $output .= '</tbody>'
346 $response->addHtml($output);