start QA_11

author: Marc Delisle <marc@infomarc.info> 2007-07-18 19:55:11 +0400
committer: Marc Delisle <marc@infomarc.info> 2007-07-18 19:55:11 +0400
commit: 609d38a9cdb6f0e638242b8cf44de6e96890637e (patch)
tree: 080c7ad3b71fa46f7b9f10066d12119688ac7b6c /browse_foreigners.php
parent: e2599e32c51deb6c38dfb2d40bc8eb7b8603c226 (diff)
1 files changed, 303 insertions, 0 deletions
diff --git a/browse_foreigners.php b/browse_foreigners.php
new file mode 100644
index 0000000000..9b10288f00
--- /dev/null
+++ b/browse_foreigners.php
@@ -0,0 +1,303 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * display selection for relational field values
+ *
+ * @version $Id$
+ */
+
+/**
+ * Gets a core script and starts output buffering work
+ */
+require_once './libraries/common.inc.php';
+
+PMA_checkParameters(array('db', 'table', 'field'));
+
+require_once './libraries/ob.lib.php';
+PMA_outBufferPre();
+
+require_once './libraries/header_http.inc.php';
+$field = urldecode($field);
+
+/**
+ * Displays the frame
+ */
+$per_page = 200;
+require_once './libraries/relation.lib.php'; // foreign keys
+require_once './libraries/transformations.lib.php'; // Transformations
+$cfgRelation = PMA_getRelationsParam();
+$foreigners  = ($cfgRelation['relwork'] ? PMA_getForeigners($db, $table) : FALSE);
+
+$override_total = TRUE;
+
+if (!isset($pos)) {
+    $pos = 0;
+}
+
+$foreign_limit = 'LIMIT ' . $pos . ', ' . $per_page . ' ';
+if (isset($foreign_navig) && $foreign_navig == $strShowAll) {
+    unset($foreign_limit);
+}
+
+require './libraries/get_foreign.lib.php';
+
+if (isset($pk)) {
+    $pk_uri = '&amp;pk=' . urlencode($pk);
+    ?>
+<input type="hidden" name="pk" value="<?php echo urlencode($pk); ?>" />
+    <?php
+} else {
+    $pk_uri = '';
+}
+
+$gotopage = '';
+$showall = '';
+// $the_total comes from get_foreign.lib.php
+
+if (isset($disp_row) && is_array($disp_row)) {
+
+    if ($cfg['ShowAll'] && ($the_total > $per_page)) {
+        $showall = '<input type="submit" name="foreign_navig" value="' . $strShowAll . '" />';
+    }
+
+    $session_max_rows = $per_page;
+    $pageNow = @floor($pos / $session_max_rows) + 1;
+    $nbTotalPage = @ceil($the_total / $session_max_rows);
+
+    if ($the_total > $per_page) {
+        $gotopage = PMA_pageselector(
+                      'browse_foreigners.php?field='    . urlencode($field) .
+                                       '&amp;'          . PMA_generate_common_url($db, $table)
+                                                        . $pk_uri .
+                                       '&amp;fieldkey=' . (isset($fieldkey) ? $fieldkey : '') .
+                                       '&amp;foreign_filter=' . (isset($foreign_filter) ? htmlspecialchars($foreign_filter) : '') .
+                                       '&amp;',
+                      $session_max_rows,
+                      $pageNow,
+                      $nbTotalPage,
+                      200,
+                      5,
+                      5,
+                      20,
+                      10,
+                      $GLOBALS['strPageNumber']
+                    );
+    }
+}
+?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
+    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html xmlns="http://www.w3.org/1999/xhtml"
+    xml:lang="<?php echo $available_languages[$lang][2]; ?>"
+    lang="<?php echo $available_languages[$lang][2]; ?>"
+    dir="<?php echo $text_dir; ?>">
+
+<head>
+    <title>phpMyAdmin</title>
+    <meta http-equiv="Content-Type" content="text/html; charset=<?php echo $charset; ?>" />
+    <link rel="stylesheet" type="text/css"
+        href="phpmyadmin.css.php?<?php echo PMA_generate_common_url('', ''); ?>&amp;js_frame=right&amp;nocache=<?php echo $_SESSION['PMA_Config']->getMtime(); ?>" />
+    <script src="./js/functions.js" type="text/javascript"></script>
+    <script type="text/javascript">
+    //<![CDATA[
+    self.focus();
+    function formupdate(field, key) {
+        if (opener && opener.document && opener.document.insertForm) {
+            var field = 'field_' + field;
+
+            <?php if (isset($pk)) { ?>
+            var element_name = field + '[multi_edit][<?php echo urlencode($pk); ?>][]';
+            <?php } else { ?>
+            var element_name = field + '[]';
+            <?php } ?>
+
+            <?php if (isset($fieldkey) && is_numeric($fieldkey)) { ?>
+            var element_name_alt = field + '[<?php echo $fieldkey; ?>]';
+            <?php } else { ?>
+            var element_name_alt = field + '[0]';
+            <?php } ?>
+
+            if (opener.document.insertForm.elements[element_name]) {
+                // Edit/Insert form
+                opener.document.insertForm.elements[element_name].value = key;
+                self.close();
+                return false;
+            } else if (opener.document.insertForm.elements[element_name_alt]) {
+                // Search form
+                opener.document.insertForm.elements[element_name_alt].value = key;
+                self.close();
+                return false;
+            }
+        }
+
+        alert('<?php echo PMA_jsFormat($strWindowNotFound); ?>');
+    }
+    //]]>
+    </script>
+</head>
+
+<body id="body_browse_foreigners">
+
+<form action="browse_foreigners.php" method="post">
+<fieldset>
+<?php echo PMA_generate_common_hidden_inputs($db, $table); ?>
+<input type="hidden" name="field" value="<?php echo urlencode($field); ?>" />
+<input type="hidden" name="fieldkey"
+    value="<?php echo isset($fieldkey) ? $fieldkey : ''; ?>" />
+<?php if (isset($pk)) { ?>
+<input type="hidden" name="pk" value="<?php echo urlencode($pk); ?>" />
+<?php } ?>
+<span class="formelement">
+    <label for="input_foreign_filter"><?php echo $strSearch . ':'; ?></label>
+    <input type="text" name="foreign_filter" id="input_foreign_filter"
+        value="<?php echo isset($foreign_filter) ? htmlspecialchars($foreign_filter) : ''; ?>" />
+    <input type="submit" name="submit_foreign_filter" value="<?php echo $strGo;?>" />
+</span>
+<span class="formelement">
+    <?php echo $gotopage; ?>
+</span>
+<span class="formelement">
+    <?php echo $showall; ?>
+</span>
+</fieldset>
+</form>
+
+<table width="100%">
+<?php
+if (isset($disp_row) && is_array($disp_row)) {
+    $header = '<tr>
+        <th>' . $strKeyname . '</th>
+        <th>' . $strDescription . '</th>
+        <td width="20%"></td>
+        <th>' . $strDescription . '</th>
+        <th>' . $strKeyname . '</th>
+    </tr>';
+
+    echo '<thead>' . $header . '</thead>' . "\n"
+        .'<tfoot>' . $header . '</tfoot>' . "\n"
+        .'<tbody>' . "\n";
+
+    $values = array();
+    $keys   = array();
+    foreach ($disp_row as $relrow) {
+        if ($foreign_display != FALSE) {
+            $values[] = $relrow[$foreign_display];
+        } else {
+            $values[] = '';
+        }
+
+        $keys[] = $relrow[$foreign_field];
+    }
+
+    asort($keys);
+
+    $hcount = 0;
+    $odd_row = true;
+    $val_ordered_current_row = 0;
+    $val_ordered_current_equals_data = false;
+    $key_ordered_current_equals_data = false;
+    foreach ($keys as $key_ordered_current_row => $value) {
+    //for ($i = 0; $i < $count; $i++) {
+        $hcount++;
+
+        if ($cfg['RepeatCells'] > 0 && $hcount > $cfg['RepeatCells']) {
+            echo $header;
+            $hcount = 0;
+            $odd_row = true;
+        }
+
+        $key_ordered_current_key = $keys[$key_ordered_current_row];
+        $key_ordered_current_val = $values[$key_ordered_current_row];
+
+        $val_ordered_current_key = $keys[$val_ordered_current_row];
+        $val_ordered_current_val = $values[$val_ordered_current_row];
+
+        $val_ordered_current_row++;
+
+        if (PMA_strlen($val_ordered_current_val) <= $cfg['LimitChars']) {
+            $val_ordered_current_val = htmlspecialchars($val_ordered_current_val);
+            $val_ordered_current_val_title = '';
+        } else {
+            $val_ordered_current_val_title =
+                htmlspecialchars($val_ordered_current_val);
+            $val_ordered_current_val =
+                htmlspecialchars(PMA_substr($val_ordered_current_val, 0,
+                    $cfg['LimitChars']) . '...');
+        }
+        if (PMA_strlen($key_ordered_current_val) <= $cfg['LimitChars']) {
+            $key_ordered_current_val = htmlspecialchars($key_ordered_current_val);
+            $key_ordered_current_val_title = '';
+        } else {
+            $key_ordered_current_val_title =
+                htmlspecialchars($key_ordered_current_val);
+            $key_ordered_current_val =
+                htmlspecialchars(PMA_substr($key_ordered_current_val, 0,
+                    $cfg['LimitChars']) . '...');
+        }
+
+        if (! empty($data)) {
+            $val_ordered_current_equals_data = $val_ordered_current_key == $data;
+            $key_ordered_current_equals_data = $key_ordered_current_key == $data;
+        }
+
+        ?>
+    <tr class="<?php echo $odd_row ? 'odd' : 'even'; $odd_row = ! $odd_row; ?>">
+        <td nowrap="nowrap">
+        <?php
+        echo ($key_ordered_current_equals_data ? '<b>' : '')
+            .'<a href="#" title="' . $strUseThisValue
+            . ($key_ordered_current_val_title != '' ? ': ' . $key_ordered_current_val_title : '') . '"'
+            .' onclick="formupdate(\'' . md5($field) . '\', \''
+            . htmlspecialchars($key_ordered_current_key) . '\'); return false;">'
+            .htmlspecialchars($key_ordered_current_key) . '</a>' . ($key_ordered_current_equals_data ? '</b>' : '');
+        ?></td>
+        <td>
+        <?php
+        echo ($key_ordered_current_equals_data ? '<b>' : '')
+            . '<a href="#" title="' . $strUseThisValue . ($key_ordered_current_val_title != '' ? ': '
+            . $key_ordered_current_val_title : '') . '" onclick="formupdate(\''
+            . md5($field) . '\', \'' . htmlspecialchars($key_ordered_current_key) . '\'); return false;">'
+            . $key_ordered_current_val . '</a>' . ($key_ordered_current_equals_data ? '</b>' : '');
+        ?></td>
+        <td width="20%">
+            <img src="<?php echo $GLOBALS['pmaThemeImage'] . 'spacer.png'; ?>"
+                alt="" width="1" height="1"></td>
+
+        <td>
+        <?php
+        echo ($val_ordered_current_equals_data ? '<b>' : '')
+            . '<a href="#" title="' . $strUseThisValue .  ($val_ordered_current_val_title != '' ? ': '
+            . $val_ordered_current_val_title : '') . '" onclick="formupdate(\'' . md5($field)
+            . '\', \'' . htmlspecialchars($val_ordered_current_key) . '\'); return false;">'
+            . $val_ordered_current_val . '</a>' . ($val_ordered_current_equals_data ? '</b>' : '');
+        ?></td>
+        <td nowrap="nowrap">
+        <?php
+        echo ($val_ordered_current_equals_data ? '<b>' : '') . '<a href="#" title="'
+        . $strUseThisValue .  ($val_ordered_current_val_title != '' ? ': ' . $val_ordered_current_val_title : '')
+        . '" onclick="formupdate(\'' . md5($field) . '\', \''
+        . htmlspecialchars($val_ordered_current_key) . '\'); return false;">' . htmlspecialchars($val_ordered_current_key)
+        . '</a>' . ($val_ordered_current_equals_data ? '</b>' : '');
+        ?></td>
+    </tr>
+        <?php
+    } // end while
+}
+?>
+</tbody>
+</table>
+
+</body>
+</html>
+
+<?php
+/**
+ * Close MySql connections
+ */
+if (isset($controllink) && $controllink) {
+    @PMA_DBI_close($controllink);
+}
+if (isset($userlink) && $userlink) {
+    @PMA_DBI_close($userlink);
+}
+?>
author	Marc Delisle <marc@infomarc.info>	2007-07-18 19:55:11 +0400
committer	Marc Delisle <marc@infomarc.info>	2007-07-18 19:55:11 +0400
commit	609d38a9cdb6f0e638242b8cf44de6e96890637e (patch)
tree	080c7ad3b71fa46f7b9f10066d12119688ac7b6c /browse_foreigners.php
parent	e2599e32c51deb6c38dfb2d40bc8eb7b8603c226 (diff)