0,0 → 1,212 |
<?php |
require_once('version.inc'); |
require_once('dbaccess.inc'); |
require_once('language.inc'); |
require_once('header.inc'); |
require_once('crypt.inc'); |
require_once('settings.inc'); |
require_once('helper.inc'); |
|
$drm = array(true, false, false, false, true, true, true, true); |
$headline = 33; |
|
require_once('menu.inc'); |
|
function ShowEJournal() { |
global $rstufe; |
global $menu; |
global $headline; |
|
if ($rstufe != 0 && $rstufe != 1) { |
Error("Berechtigungsfehler!"); |
return; |
} |
|
$nav = "mitarbeiter='+document.journal.mitarbeiter.value+'&aktion='+document.journal.aktion.value+'&von='+document.journal.von.value+'&bis='+document.journal.bis.value+'&menu=$menu&headline=$headline"; |
|
$mitarbeiter = $_REQUEST['mitarbeiter']; |
$aktion = $_REQUEST['aktion']; |
$von = $_REQUEST['von']; |
$bis = $_REQUEST['bis']; |
|
if (!isset($von) || !isset($bis)) { |
$zeite = time(); |
$zeits = $zeite - 30 * 86400; |
$day = gmdate("j", $zeits); |
$mon = gmdate("n", $zeits); |
$year = gmdate("Y", $zeits); |
$dvon = gmmktime(0, 0, 0, $mon, $day, $year); |
$von = "$day.$mon.$year"; |
$day = gmdate("j", $zeite); |
$mon = gmdate("n", $zeite); |
$year = gmdate("Y", $zeite); |
$dbis = gmmktime(23, 59, 59, $mon, $day, $year); |
$bis = "$day.$mon.$year"; |
} else { |
$ds = explode(".", $von); |
$de = explode(".", $bis); |
$dvon = gmmktime(0, 0, 0, $ds[1], $ds[0], $ds[2]); |
$dbis = gmmktime(23, 59, 59, $de[1], $de[0], $de[2]); |
} |
|
$db = OpenDB(); |
?> |
<form name="journal" action="ejournal.php" method="post"> |
<input type="hidden" name="menu" value="<? echo "$menu"; ?>"> |
<input type="hidden" name="headline" value="<? echo "$headline"; ?>"> |
<table class="input"> |
<tr> |
<td>Mitarbeiter:</td> |
<td><select name="mitarbeiter" onChange="javascript:MoveTo('ejournal.php','<? echo "$nav"; ?>')"> |
<option value="0">Alle</option> |
<? |
$query = "select distinct ej_uid, mi_nname, mi_vname from ejournal, mitarbeiter where "; |
$query .= "mi_num = ej_uid order by mi_nname, mi_vname"; |
|
if (!($result = QueryDB($db, $query))) { |
closeDB($db); |
return; |
} |
|
$anz = numrowsDB($result); |
$i = 0; |
$flag = false; |
|
while ($i < $anz) { |
$data = fetchDB($result, $i); |
$ej_uid = $data[0]; |
$mi_nname = $data[1]; |
$mi_vname = $data[2]; |
|
if (isset($mitarbeiter) && $mitarbeiter == $ej_uid) { |
echo " <option value=\"$ej_uid\" selected>$mi_nname $mi_vname</option>\n"; |
$flag = true; |
} else |
echo " <option value=\"$ej_uid\">$mi_nname $mi_vname</option>\n"; |
|
$i++; |
} |
|
if (!$flag) |
$mitarbeiter = 0; |
?> |
</select> |
</td> |
</tr> |
<tr> |
<td>Aktion:</td> |
<td><select name="aktion" onChange="javascript:MoveTo('ejournal.php','<? echo "$nav"; ?>')"> |
<option value="0">Alle</option> |
<? |
$query = "select distinct kj_num, kj_text from ejournal, key_jtype where "; |
$query .= "kj_num = ej_type and ej_date between $dvon and $dbis "; |
|
if (isset($mitarbeiter) && $mitarbeiter > 0) |
$query .= "and ej_uid = $mitarbeiter "; |
|
$query .= "order by kj_num"; |
|
if (!($result = QueryDB($db, $query))) { |
closeDB($db); |
return; |
} |
|
$anz = numrowsDB($result); |
$i = 0; |
$flag = false; |
|
while ($i < $anz) { |
$data = fetchDB($result, $i); |
$kj_num = $data[0]; |
$kj_text = $data[1]; |
|
if (isset($aktion) && $aktion == $kj_num) { |
echo " <option value=\"$kj_num\" selected>$kj_text</option>\n"; |
$flag = true; |
} else |
echo " <option value=\"$kj_num\">$kj_text</option>\n"; |
|
$i++; |
} |
|
if (!$flag) |
$aktion = 0; |
?> |
</select> |
</td> |
</tr> |
<tr> |
<td>Zeitraum von:</td> |
<td><input type="text" name="von" value="<? echo "$von"; ?>" onChange="javascript:CheckDate(this, false)" size=10 maxlength=10></td> |
</tr> |
<tr> |
<td>Zeitraum bis:</td> |
<td><input type="text" name="bis" value="<? echo "$bis"; ?>" onChange="javascript:CheckDate(this, false)" size=10 maxlength=10></td> |
</tr> |
<tr> |
<td colspan=2> |
<? |
Button("Zeitraum setzen", "journal"); |
?> |
</td> |
</tr> |
</table> |
</form> |
<? |
$query = "select ej_num, ej_date, ej_text, kj_text, mi_nname, mi_vname from "; |
$query .= "ejournal, key_jtype, mitarbeiter where kj_num = ej_type and "; |
$query .= "mi_num = ej_uid and ej_date between $dvon and $dbis "; |
|
if (isset($mitarbeiter) && $mitarbeiter > 0) |
$query .= "and ej_uid = $mitarbeiter "; |
|
if (isset($aktion) && $aktion > 0) |
$query .= "and ej_type = $aktion "; |
|
$query .= "order by ej_date desc, mi_nname, mi_vname"; |
|
if (!($result = QueryDB($db, $query))) { |
closeDB($db); |
return; |
} |
|
$anz = numrowsDB($result); |
|
if ($anz <= 0) |
return; |
|
$i = 0; |
?> |
<br> |
<table class="sel"> |
<tr> |
<th class="sel">Datum</th> |
<th class="sel">Ausgeführt von</th> |
<th class="sel">Aktion</th> |
<th class="sel">Anmerkung</th> |
</tr> |
<? |
while ($i < $anz) { |
$data = fetchDB($result, $i); |
$ej_num = $data[0]; |
$ej_date = $data[1]; |
$ej_text = $data[2]; |
$kj_text = $data[3]; |
$mi_nname = $data[4]; |
$mi_vname = $data[5]; |
|
echo "<tr><td class=\"sel\">" . date("d.m.Y H:i:s", $ej_date) . "</td>\n"; |
echo "<td class=\"sel\">$mi_nname $mi_vname</td>\n"; |
echo "<td class=\"sel\">$kj_text</td>\n"; |
echo "<td class=\"sel\">$ej_text</td></tr>\n"; |
$i++; |
} |
|
echo "</table>\n"; |
closeDB($db); |
} |
|
ShowEJournal(); |
|
require_once('footer.inc'); |
?> |