78 lines
2.3 KiB
PHP
Executable File
78 lines
2.3 KiB
PHP
Executable File
<?php
|
|
include_once 'classes/TestProjektSmarty.class.php';
|
|
require_once("config.inc.php");
|
|
$templatename = substr(basename($_SERVER['PHP_SELF']),0,-3)."html";
|
|
$smarty = new Smarty();
|
|
require_once "language/german.inc.php";
|
|
|
|
require_once "validation/func_validEmail.php";
|
|
require_once "func_genUser.php";
|
|
require_once("func_verlauf.php");
|
|
require_once("func_gutachter_entscheid.php");
|
|
require_once("func_gutachter_status.php");
|
|
require_once("func_mail_einstell.php");
|
|
require_once("func_rechte_vergabe.php");
|
|
|
|
$action = $_GET['action'];
|
|
|
|
if(isset($_GET['id'])){
|
|
$_SESSION["edit_id"] = $_GET['id'];
|
|
$search_prefix = 'ausschuss_gutachter_uberblick_';
|
|
$search_len = strlen($search_prefix);
|
|
foreach( $_SESSION as $key => $value){
|
|
if ( substr( $key, 0, $search_len) == $search_prefix) {
|
|
unset( $_SESSION[$key]);
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
|
|
if($action == ''){
|
|
|
|
$id = $_SESSION["edit_id"];
|
|
|
|
$query1 = "SELECT a.gid, vorname, nachname, date_format(frist_datum, '%d.%m.%Y') frist_tag, date_format(frist_datum_abgabe, '%d.%m.%Y') frist_datum_abgabe
|
|
FROM imt_gutachter a, imt_user b
|
|
WHERE a.imtuid=b.imtuid
|
|
AND a.vid='$id'
|
|
ORDER BY nachname ASC";
|
|
|
|
$result1 = $db->query ($query1)
|
|
or die ("Cannot execute query");
|
|
|
|
$table_data1 = array();
|
|
|
|
$gutachter = new gutachter();
|
|
|
|
while ($row1 = $result1->fetch_array()){
|
|
|
|
gutachter_entscheid($uid, $row1[gid], $id);
|
|
$status = $gutachter -> gutachter_status($row1[gid]);
|
|
$status_klartext = $gutachter -> gutachter_status_klartext($row1[gid], $status);
|
|
|
|
if($row1[frist_datum_abgabe] == '00.00.0000'){
|
|
$abgabefrist = "Gutachter noch nicht angeschrieben";
|
|
}else{
|
|
$abgabefrist = $row1[frist_datum_abgabe];
|
|
}
|
|
|
|
array_push($table_data1, array(
|
|
'gid' => $row1[gid],
|
|
'vorname' => $row1[vorname],
|
|
'nachname' => $row1[nachname],
|
|
'status' => $status,
|
|
'status_klartext' => $status_klartext,
|
|
'frist_tag' => $row1[frist_tag],
|
|
'frist_datum_abgabe' => $abgabefrist
|
|
)
|
|
);
|
|
}
|
|
$smarty->assign('table_data1', $table_data1);
|
|
|
|
}
|
|
|
|
$smarty->assign('action', "$action");
|
|
$smarty->display("$template/$templatename");
|
|
|
|
?>
|