index.php File Reference

display the entry page (overview of document collections) More...

Go to the source code of this file.

Functions
	cmp_coll ($a, $b)
	callback function for usort()
	show_index ()

---

Detailed Description

display the entry page (overview of document collections)

Definition in file index.php.

---

Function Documentation

show_index

(

)

Definition at line 82 of file index.php.

References $actions_info, $validation_info, check_input(), do_template(), expire(), smarty_init(), sql_exit(), sql_init(), and sql_query().

                      {


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

}

Here is the call graph for this function:

---