index.php

Go to the documentation of this file.

<?php

// This file is part of the "Electronic Semester Apparatus"
// of University Library Braunschweig, Germany.
// Copyright (C) 2005 University Library Braunschweig, Germany.
//
// Author: Martin Butkus <mb@biblio.tu-bs.de>



set_include_path( '../php' . PATH_SEPARATOR . get_include_path());
set_include_path( '../smarty/libs' . PATH_SEPARATOR . get_include_path());

if (session_id() == "") { session_start(); }

require_once 'Smarty.class.php';
require_once 'sql.php';
require_once 'error.php';
require_once 'util.php';
require_once 'const.php';
require_once 'config.php';
require_once 'mod_item.php';


function cmp_coll($a, $b) {
        $key_a = $a['title'] . $a['collection_no'];
        $key_b = $b['title'] . $b['collection_no'];

        return strcmp($key_a, $key_b);
}

function show_index() {


global $_GET, $_POST, $validation_info, $actions_info;
$smarty = smarty_init();

## parameters accepted by this php script

$default = array(
        "mode" => "view",
);

## check user input 

$INPUT = array_merge($default, $_GET, $_POST  );
$errors = check_input($INPUT, $validation_info); 

if (isset($_SESSION['mode'])) {
        $INPUT['mode'] = $_SESSION['mode'];
}

if ($debug_level > 10) {
         print "<hr><pre>Input: ";
        print_r($INPUT);
        print "</pre><hr>";
}

if (!empty($errors)) {
        user_error("Missing or malformed input parameter(s): " . join($errors, ", "),
                E_USER_ERROR); 
}

# init mysql connection
$db = sql_init();

expire($smarty,$db);

$param = array ( "tables" => "user,role,state,degree", 
                 "cond" => "user.state_id = state.id  AND 
                            user.role_id = role.id and 
                            role.name = 'edit' and 
                            IF(user.use_alias,user.alias_degree_id,user.degree_id) = degree.id ", 
                "columns" => "user.*, 
        IF(user.use_alias,user.alias_forename,user.forename) AS forename, 
        IF(user.use_alias,user.alias_surname,user.surname) AS surname, 
        user.forename as real_forename,
        user.surname as real_surname,
        IF(user.use_alias,user.alias_sex,user.sex) AS sex, 
        IF(user.use_alias,user.alias_degree_id,user.degree_id) AS degree_id, 
        degree.description AS degree_description 
        ",
                 "order" => "surname,forename,degree_description,sex,real_surname,real_forename" 
                );

if ($INPUT['mode'] == "edit" and isset($_SESSION['user'])) {
        $param['cond'] .= " AND user.id=" . $_SESSION['user']['id'];
}

if ($INPUT['mode'] == "view") {
        $param['cond'] .= " AND state.name = 'active'";
} else {
        $param['cond'] .= " AND state.name != 'new'";
}

$user = sql_query('select', $param, $db);

$tpl_var = $INPUT;
$tpl_var['collection'] = array();

foreach ($user as $u) {
        $k = $u['id'];
        $v = $u['degree_description'] . " ". $u['forename'] . " " . $u['surname'];
        if ($u['use_alias']) {
        $v .= " (" . $u['real_forename'] . " " . $u['real_surname'] . ")";
        }
        $tpl_var['html_options']['user'][$k] = $v;
}


foreach ($user as $u) {

        $param = array ( "tables" => "collection,user,state,degree", 
        "columns" => "collection.*,
        IF(user.use_alias,user.alias_forename,user.forename) AS forename, 
        IF(user.use_alias,user.alias_surname,user.surname) AS surname, 
        IF(user.use_alias,user.alias_sex,user.sex) AS sex, 
        IF(user.use_alias,user.alias_degree_id,user.degree_id) AS degree_id, 
        degree.description AS degree_description,
        state.name AS state_name",
        "cond" => "degree.id = IF(user.use_alias,user.alias_degree_id,
                                user.degree_id) AND 
                   state.id = collection.state_id AND
                   user.id = collection.user_id AND 
                   user.id=" . $u['id']. " ",
        "order" => "collection.title,collection.collection_no",
        );

        if ($INPUT['mode'] == "view") {
                $param['cond'] .= "AND state.name = 'active'";
        }

        $ans = sql_query('select', $param, $db);

        $key  = trim($u['surname']);
        $key .= trim($u['forename']);
        $key .= trim($u['degree_description']);
        $key .= trim($u['sex']);

        if (!empty($ans)) {
                $tpl_var['collection'][$key] = array_merge($tpl_var['collection'][$key],  $ans);
        }

#       if (!empty($ans)) {
#               $tpl_var['collection'][] = $ans;
#       }

}

# sort collections

foreach ($tpl_var['collection'] as $k => $v) {

        usort($v, "cmp_coll");
        $tpl_var['collection'][$k] = $v;
        #print_r($v);
}
#exit(0);


$tpl_var['actions_info'] = $actions_info;

#echo '<pre>';
#print_r($tpl_var);
#echo '</pre>';
#exit(0);

do_template( $smarty, 'index.tpl', $tpl_var, TRUE );

sql_exit($db);

}

show_index(); // execute this function
?>

---