mod_item.php

Go to the documentation of this file.

<?php
require_once 'Smarty.class.php';
require_once 'sql.php';
require_once 'error.php';
require_once 'util.php';
require_once 'redirect.php';



function extend_loan($coll_id, $db) {

        # $param = array (
        #       "tables" => "collection",
        #       "cond" => "expiry_date <= NOW() AND id = " . $coll_id
        # );
        # 
        # $ans = sql_query('select', $param, $db);
        #
        # # not expired? --> do nothing
        #
        # if (empty($ans)) { 
        #       return;
        # }

        # set a new expiry date

        $param = array (
                "tables" => "collection",
                "id" => $coll_id,
                "data" => array ("expiry_date" => get_new_expiry_date()) 
        );

        sql_query('update', $param, $db);

}



function coll_set_state($smarty, $collection_id,  $states, $db) {

        # set state of documents in collection
        $param = array ( 

                 "tables" => "document,state,doc_type",
                 "columns" => "document.*, state.name AS state_name, doc_type.name as doc_type_name",
                 "cond" => "document.collection_id = " . $collection_id . 
                           " AND document.state_id = state.id AND document.doc_type_id = doc_type.id",

                );
        

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

        $param = array ( "table" => "document");

        foreach ($docs as $d) {

                $param['id'] = $d['id'];

                $cur_state   = $d['state_name']; 
                $cur_doctype = $d['doc_type_name']; 

                $keys = array(  
                        $cur_doctype . '-' . $cur_state,
                        $cur_state,
                        'DEFAULT'
                );

                # print_r($keys);

                unset($param['state']);

                foreach ($keys as $k) {
                        if  (isset($states[$k])) {
                                $param['state'] = $states[$k];
                                break;
                        }
                }

                # print_r($param);
                if (isset($param['state'])) {
                        sql_query('set_state', $param, $db);
                }
        }

}



function set_item_state($smarty, $INPUT, $db) {

global $_SESSION, $validation_info;

$default = array(
);

## check user input 

# $INPUT = array_merge($default, $_GET, $_POST);

$INPUT = array_merge($default, $INPUT);

# $errors = check_input($INPUT, $validation_info); 


#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); 
#}

$item_tables = array(
        "DEFAULT" => "document", 
        "collection" => "collection", 
        "user"    => "user", 
);


$action = $INPUT['item'] . "-" . $INPUT['state'];

## special cases

switch($action) {

        case "collection-inactive": 

                $new_states = array(
                        "DEFAULT"       => "inactive",
                        "open"          => "obsolete",
                        "active"        => "obsolete",
                        "obsolete"      => "obsolete",
                        "file-active"    => "inactive",
                        "url-active"    => "inactive",
                );

                coll_set_state($smarty, $INPUT['id'], $new_states, $db);

        break;

        case "collection-active": 

                # $new_states = array (
                #       "file-inactive"    => "active",
                #       "url-inactive"    => "active",
                # );

                coll_set_state($smarty, $INPUT['id'], $new_states, $db);
                extend_loan($INPUT['id'], $db); 

        break;


        case "user-open":

                # create random password and mail it to the user
         
                $passwd = set_random_pw($INPUT['id'], $db);

                $user = get_item_owner("user", $INPUT['id'], $db);
                        
                $email_to = $user['degree_name'] . " ";
                $email_to .= $user['forename'] . " ";
                $email_to .= $user['surname'] . " ";
                $email_to .= "<" . $user['email'] . ">";

                $tpl_vars = array();
                $tpl_vars['user_info'] = $user; 
                $tpl_vars['user_info']['password'] = $passwd;   

                send_email($smarty,'msg_new_account.tpl',$tpl_vars,
                        $email_to);

                # set state to active
                $INPUT['state'] = "active";

        break;
}

$tbl = $item_tables['DEFAULT'];

if (isset($item_tables[$INPUT['item']])) {
        $tbl = $item_tables[$INPUT['item']];
}

$param = array ( "table" => $tbl,
                 "state" => $INPUT['state'],
                 "id" => $INPUT['id'],
);

sql_query('set_state', $param, $db);

if ($action == "collection-active") {
        # show message for user

        $tpl_vars = array (
                "expiry_date" => get_new_expiry_date() ,
                "id" => $INPUT['id']
        );

        do_template($smarty,'extend_loan.tpl', $tpl_vars);
        exit(0);
}

}



function expire($smarty, $db) {

        $param = array (
                "tables" => "collection as c,state as s" ,
                "columns" => "c.id" ,
                 cond => "c.state_id = s.id AND 
                          s.name = 'active' AND 
                          c.expiry_date <= NOW()",
        );

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

        $input = array ("item" => "collection", "state" => "obsolete" );

        foreach ($colls as $c) {
                $input['id'] = $c['id']; 
                set_item_state($smarty, $input, $db);
        }


        $param = array (
                "tables" => "collection AS c,state AS s" ,
                "columns" => "c.id AS id",  
                 cond => "(c.state_id = s.id) AND 
                          (s.name = 'obsolete') AND 
                          DATE_ADD(c.expiry_date, INTERVAL 14 DAY) <= NOW()"
        );

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

        $input = array ("item" => "collection", "state" => "inactive" );

        foreach ($colls as $c) {
                $input['id'] = $c['id']; 
                set_item_state($smarty, $input, $db);
        }
}

?>

---