index.php

Go to the documentation of this file.

<?php

// This file is part of the web-based "Application Form for New Users" 
// of University Library Braunschweig, Germany
//
// Copyright (C) 2004 University Library Braunschweig, Germany


require_once('config.php');
require_once('../util.php');
require_once('../text.php');
require_once('../fields.php');

session_start();

// select language

$lang = (isset($_GET['lang'])) ? $_GET['lang'] : $lang_default;

if (!isset($text_multi[$lang]))
        $l = $lang_default;

$text    = $text_multi[$lang];
$buttons = $buttons_multi[$lang];
$months =  $months_multi[$lang];



$valid_params = array(
        "sort" => "/^(last_name|first_name|birthday|sex|entry_date)$/",
        "order"=> "/^(up|down)$/",
        "status" => "/^(new|old)$/",
        "button" => "/^(" . $buttons['delete_all'] . "|" .  $buttons['ok'] . "|" .
                            $buttons['cancel'] . "|)$/",
        "action"=> "/^(delete_all|)$/",
        "lang" => "/^(de|en)$/"
);


$default_params = array (
        'sort' => "last_name",
        'order' => "up",
        'status' => "new",
        'lang' => $lang_default
);

foreach ($default_params as  $k => $v) {
        if (!isset($_SESSION[$k]))
                $_SESSION[$k] = $v;
}

foreach ($_GET as  $k => $v) {
        if (param_ok($valid_params, $k, $v)) 
                $_SESSION[$k] = $v;
}


// \brief default sort order

$default_sortkeys = array( 'last_name', 'first_name', 'birthday');

// \brief which columns are to appear in the index

$sort = $_SESSION['sort'];

print_header( array("@notabene@" => "", "@bodyattr@" => "",
              "@url-de@" => "index.php?lang=de", "@url-en@" => "index.php?lang=en" ));

print   '<table border=0>
         <tr> 
         <td><strong>' . $text['status'] . ': </strong></td>
         <td>';

  link_maybe($text['status_new'],
             "index.php?lang=$lang&status=new&sort=$sort&order=" . $_SESSION["order"] ,
             $_SESSION["status"] != "new") ;
  print " / ";
  link_maybe($text['status_old'],
             "index.php?lang=$lang&status=old&sort=$sort&order=" . $_SESSION["order"],
             $_SESSION["status"] != "old");

print   '</td></tr> 
         <tr> 
                <td> <strong>' . $text['order'] . ': </strong> </td>
         <td>';



link_maybe($text['order_asc'],
            "index.php?lang=$lang&order=up&sort=$sort&status=" . $_SESSION["status"],
            $_SESSION["order"] != "up") ;
print " / ";
link_maybe($text['order_desc'],
            "index.php?lang=$lang&order=down&sort=$sort&status=" . $_SESSION["status"],
            $_SESSION["order"] != "down");

print   ' </td> </tr> </table> <br>';

($link = mysql_pconnect($dbhost, $dbuser, $dbpass)) or db_error_mysql();
mysql_select_db($dbname,$link) or db_error_mysql();

fields_init($link, $lang);


$table_columns = array(
                  'last_name' =>  $fields['last_name']['label'],
                  'first_name' => $fields['first_name']['label'],
                  'birthday' =>   $fields['birthday']['label'],
                  'entry_date' => $fields['entry_date']['label']
        );

// delete obsolete data sets

if (($_SESSION['action'] == 'delete_all') and $_SESSION['button'] == $buttons['ok']) {

        $q  =   "DELETE addresses FROM persons, addresses ";
        $q  .=  "WHERE persons.status='old' and persons.id = addresses.person_id";
        db_query_mysql($link,$q, array()); 

        $q  =   "DELETE FROM persons WHERE persons.status='old'";
        db_query_mysql($link, $q, array()); 

        $_SESSION["button"] = "";

        unset($_SESSION['action']);
}
// query db


$sortkeys = $_SESSION["sort"];

if ($_SESSION["order"] == "down") 
        $sortkeys .= " DESC";

foreach ($default_sortkeys as $s) {
        if ($s != $_SESSION["sort"])
                $sortkeys .= ", $s" ;
}

$q  =  "SELECT id FROM persons WHERE status = ";
$q .= "'" . $_SESSION["status"] . "' ";

$q .= "ORDER BY $sortkeys";


// print $q;

$res = db_query_mysql($link,$q, array()); 


if (empty($res)) {
        print $text['db_empty']; 
} else {
        print "<table border=0 cellpadding=5 >";

        // table header
        print "<tr>\n";
        foreach ($table_columns as $k => $v ) {
                $order=$_SESSION['order'];
                print "<th align=\"left\" >";
                link_maybe(htmlentities($v), "index.php?lang=$lang&status=$status&order=$order&sort=$k", 
                           $_SESSION["sort"] != $k); 
                print "</th>\n";
        }
        print "<th> &nbsp; </th>";

        print "</tr>\n";

        // table body
        foreach ($res as $row) {
                print "<tr>\n";

                foreach ($table_columns as $f => $dummy ) {

                        // query database

                        $q = $fields[$f]["view_query"];
                        // print $q;

                        $r = db_query_mysql($link,$q,
                                array('@id@' => $row["id"]));

                        $v = (isset($r[1][0])) ? $r[1][0] : "";

                        print "<td>" . htmlentities($v) . "&nbsp; </td>\n";

                }

                print "<td>";

                $id = $row["id"];
                print "<a href=\"action.php?&lang=$lang&action=show&id=" . $id . "\">";
                print $text['details'];
                print "</td>\n";
                print "</tr>\n";
        }
        print "</table>";

if ($_SESSION["status"] == "old")  {
        print '<form method="GET">';


        if ($_SESSION['button'] == $buttons['delete_all']) {
                print '<br><strong>' . $text['confirm_delete_all'] . '</strong>&nbsp;&nbsp;';
                print '<input type="hidden" value="' . $lang . '" name="lang">';
                print '<input type="hidden" value="delete_all" name="action">';
                print '<input type="submit" name="button" value="' . $buttons['ok'] . '">&nbsp;'; 
                print '<input type="submit" name="button" value="' . $buttons['cancel'] . '">'; 
        } else {
                print '<input type="hidden" value="' . $lang . '" name="lang">';
                print '<br><br><input type="submit" name="button" value="' . 
                       $buttons['delete_all'] . '">';
        }

        print "</form>";
}

}

mysql_close($link);
print_footer(array());

?>

---