collection.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 'redirect.php';
require_once 'util.php';
require_once 'mod_item.php';
require_once 'upload.php';



function show_collection() {

global $_GET, $_POST, $_SESSION, $actions_info, $validation_info;

$smarty =& smarty_init();

## parameters accepted by this php script

$defaults = array (
        "id" => "",
        "state" => "active",
        "sort_crit" => "relevance desc",
        "mode" => "view",
        "type" => "",
        "item" => "collection",
);      

## check user input 

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

if (isset($_SESSION['mode']) and ($INPUT['mode'] != "print")) {
        $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);

if (isset($INPUT['lecture_no'])) {
        $INPUT['collection_no'] = $INPUT['lecture_no'];
}

if (isset($INPUT['collection_no'])) {

        $n = intval($INPUT['collection_no']);

        $p = array( "cond" => "collection_no = $n",
                "tables" => "collection", "cols" => "id");

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

        if (!empty($ans)) {
                $url= "collection.php?id=" . $ans[0]['id'];
                redirect($url);
        } else  {
                redirect('index.php');
        }

        exit(0);
}


if ($INPUT['id'] == "") {

        $collection = array ();

} else {

        $sql_param = array ( 
                "tables" => "collection,user,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, 
                degree.description AS degree_description", 
                        "cond" => "

                        degree.id = 
                        IF(user.use_alias,user.alias_degree_id,user.degree_id) 
                        AND user.id = collection.user_id 
                        AND collection.id = " . $INPUT['id'], 
        );

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

        if (empty($ans)) {
                redirect("index.php");
                exit(0);
        }

        $collection = $ans[0];
} 

# construct sql query

$sql_param = array ( 
        "tables" => "document,user,collection,state,doc_type,url_type,location,degree", 
         "cond" => "
        IF(user.use_alias,user.alias_degree_id,user.degree_id) = degree.id AND
        user.id = collection.user_id AND 
        collection.id = document.collection_id AND 
        state.id = document.state_id AND 
        document.doc_type_id = doc_type.id AND 
        document.url_type_id = url_type.id AND 
        location.id = collection.location_id",
         "columns" => "document.*,
        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, 
        degree.description AS degree_description,
        collection.title AS collection_title, 
        count(email.id) AS num_email, state.name AS state_name, 
        state.description AS state_description, 
        state.color AS state_color, 
        doc_type.name AS type, 
        url_type.description AS url_type_description, 
        location.description AS location_description",
         "order" => "document.@sort_crit@, document.title ASC, document.author ASC",
         "group_by" => "GROUP BY document.id",
         "join" => "LEFT JOIN email ON email.document_id = document.id"
);

if ($INPUT['id'] != "") {
        $sql_param['cond'] .= " AND document.collection_id = '@id@' "; 
}
if ($INPUT['state'] == "processing" ) {
        $sql_param['cond'] .= " AND document.state_id = state.id AND ( state.name = 'new' or state.name='obsolete' )  "; 
} else if ($INPUT['state'] != "" ) {
        $sql_param['cond'] .= " AND document.state_id = state.id AND state.name = '@state@' "; 
}

if ($INPUT['type'] != "" ) {
        $sql_param['cond'] .= " AND document.doc_type_id = doc_type.id AND doc_type.name = '@type@' "; 
}

if (isset($INPUT['user_id'])) {
        $sql_param['cond'] .= " AND document.user_id = @user_id@ ";
}

foreach ($INPUT as $k => $v) {
        $kw = array( '@' . $k . '@' => $v);
        $sql_param['cond'] = strtr($sql_param['cond'], $kw);
        $sql_param['order'] = strtr($sql_param['order'], $kw);
}

# execute sql query

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

# display results

$tpl_vars = $INPUT;

# how many files attached?

foreach ($ans as $k => $v) {
        $ans[$k]['num_files'] = count( list_files( $v['type'], $v['id']) );
}

$tpl_vars['document_info']   = $ans;

$tpl_vars['collection_info'] = $collection;



$t = array ("doc_type", "state"); 

$tpl_vars['html_options'] = get_html_options($t, $db, "name", 
                "description", "id", array("" => "alles", "processing" => "offen") ); 

$tpl_vars['html_options']['item'] = $tpl_vars['html_options']['doc_type'];

unset($tpl_vars['html_options']['item'][""]);
unset($tpl_vars['html_options']['item']['processing']);
unset($tpl_vars['html_options']['doc_type']['processing']);


$tpl_vars['html_options']['sort_crit'] = array (
        "relevance desc" => "Relevanz",
        "title asc" => "Titel",
        "author asc" => "Autor",
        "signature asc" => "Signatur",
);


$tpl_vars['actions_info'] = $actions_info;

do_template($smarty, 'collection.tpl', $tpl_vars, ($INPUT['mode'] != 'print'));

sql_exit($db);

}

show_collection(); 
?>

---