Subversion Repositories public

<?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&uuml;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');
?>