73 lines
2.1 KiB
PHP
Executable File
73 lines
2.1 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_mail_einstell.php");
|
|
require_once("func_rechte_vergabe.php");
|
|
require_once("func_beteiligter_status.php");
|
|
|
|
$action = $_GET['action'];
|
|
|
|
if(isset($_GET['id'])){
|
|
$_SESSION["edit_id"] = $_GET['id'];
|
|
$search_prefix = 'ausschuss_beteiligte_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 bid, vorname, nachname, date_format(frist_datum, '%d.%m.%Y') frist_tag, date_format(stellung_dat, '%d.%m.%Y (%H:%i)') stellung_dat_form, stellung_dat
|
|
FROM imt_beteiligte 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();
|
|
|
|
$beteiligter = new beteiligter();
|
|
|
|
while ($row1 = $result1->fetch_array()){
|
|
|
|
$status = $beteiligter -> beteiligter_status($row1[bid]);
|
|
$status_klartext = $beteiligter -> beteiligter_status_klartext($row1[bid], $status);
|
|
|
|
array_push($table_data1, array(
|
|
'bid' => $row1[bid],
|
|
'vorname' => $row1[vorname],
|
|
'nachname' => $row1[nachname],
|
|
'status' => $status,
|
|
'status_klartext' => $status_klartext,
|
|
'frist' => $frist,
|
|
'frist_tag' => $row1[frist_tag]
|
|
)
|
|
);
|
|
}
|
|
$smarty->assign('table_data1', $table_data1);
|
|
|
|
|
|
|
|
}
|
|
|
|
$smarty->assign('action', "$action");
|
|
$smarty->display("$template/$templatename");
|
|
|
|
?>
|