<?php
// Dieses Script ist auf Grund der DOT.Lan Bestimmungen nicht kommerziell nutzbar und somit nicht erlaubt zu Verkaufen
// Es unterliegt den GPL-Nutzungsbedingungen! http://www.gnu.org/copyleft/gpl.html
// Copyright Tobias Müller, 2005 vorstand@lanverein.de

class kasse
{
  var $error;
  var $amount;

  function kasse()
  {

  }

  function showAmount($event = 0)
  {
    if($event != 0)
    {
      $this -> readHLP($event);
      $action = mysql_query("SELECT COUNT(*) AS anzahl FROM event_teilnehmer WHERE zahl_typ = '2' AND event_id = '".$event."'");
      $row = mysql_fetch_assoc($action);

      $action = mysql_query("SELECT amount FROM ".TABLE_HLP." WHERE event_id = '".$event."'");
      $row2 = mysql_fetch_array($action);

      $this -> amount = $row['anzahl'] * $row2['amount'];

      $action = mysql_query("SELECT amount, type FROM ".TABLE." WHERE event_id = '".$event."'");
      while($row = mysql_fetch_array($action))
      {
        if($row['type'] == "+")
        {
          $this -> amount += $row['amount'];
        }
        else
        {
          $this -> amount -= $row['amount'];
        }
      }
      $this -> amount -= (($this -> teilnehmer * $this -> leistung * $this -> dauer) / 1000) * $this -> stromkosten;
      $this -> amount -= $this -> rabattuser * $this -> rabattamount;
      return $this -> amount;
    }
    return 0;
  }

  function showPaid($event = 0)
  {
    if($event != 0)
    {
      $action = mysql_query("SELECT COUNT(*) AS anzahl FROM event_teilnehmer WHERE zahl_typ = '2' AND event_id = '".$event."'");
      $row = mysql_fetch_assoc($action);

      $action = mysql_query("SELECT amount FROM ".TABLE_HLP." WHERE event_id = '".$event."'");
      $row2 = mysql_fetch_array($action);

      $this -> amount = $row['anzahl'] * $row2['amount'];

      return $this -> amount;
    }
    return 0;
  }

  function getLANs()
  {
    $action = mysql_query("SELECT events.name AS name, kasse.event_id AS id FROM ".TABLE_HLP." AS kasse, events WHERE events.id = kasse.event_id") or die(mysql_error());
    while($row = mysql_fetch_assoc($action))
    {
      $lans .= '<option value="'.$row['id'].'">'.$row['name'].'</option>';
    }
    return $lans;
  }

  function getSystemLANs()
  {
    $action = mysql_query("SELECT name, id FROM events");
    while($row = mysql_fetch_assoc($action))
    {
      $lans .= '<option value="'.$row['id'].'">'.$row['name'].'</option>';
    }
    return $lans;
  }

  function newLAN()
  {
    if(!empty($_POST['kosten']))
    {
      mysql_query("INSERT INTO ".TABLE_HLP." SET event_id = '".$_POST['party']."', amount = '".$_POST['kosten']."'") or die(mysql_error());
      return TRUE;
    }
    else
    {
      $this -> error = "Du musst den Preis angeben";
      return FALSE;
    }

  }

  function getList($event, $order = 'ASC')
  {
    $action = mysql_query("SELECT id, amount, comment, type FROM ".TABLE." WHERE event_id = '".$event."' ORDER BY type, amount ".$order) or die(mysql_error());
    while($row = mysql_fetch_assoc($action))
    {
      $data[] = $row;
    }

    if(mysql_num_rows($action) == 0)
    {
      $data[] = array(comment => "Kein Eintrag vorhanden");
    }
    return $data;
  }

  function newRow($event)
  {
    if(empty($_POST['amount']) OR empty($_POST['comment']) OR empty($_POST['type']))
    {
      $this -> error = "Du musst alle Felder ausfüllen";
      return FALSE;
    }
    $amount = str_replace("+", "", $_POST['amount']);
    $amount = str_replace("-", "", $_POST['amount']);
    $amount = str_replace(",", ".", $_POST['amount']);
    $action = mysql_query("INSERT INTO ".TABLE." SET event_id = '".$event."',
                                                 amount = '".$amount."',
                                                 comment = '".$_POST['comment']."',
                                                 type = '".$_POST['type']."'");
    if($action == 1)
    {
      return TRUE;
    }
    else
    {
      $this -> error = mysql_error();
      return FALSE;
    }
  }

  function setRabatt($event)
  {
    if(empty($_POST['user']) OR empty($_POST['rabatt']))
    {
      $this -> error = "Du musst alle Felder ausfüllen";
      return FALSE;
    }

    $action = mysql_query("UPDATE ".TABLE_HLP." SET rabattuser = '".$_POST['user']."', rabattamount = '".str_replace(",", ".", $_POST['rabatt'])."' WHERE event_id = '".$event."'");

    if($action == 1)
    {
      return TRUE;
    }
    else
    {
      $this -> error = mysql_error();
      return FALSE;
    }
  }

  function setStrom($event)
  {
    if(empty($_POST['kosten']) OR empty($_POST['leistung']) OR empty($_POST['stunden']))
    {
      $this -> error = "Du musst alle Felder ausfüllen";
      return FALSE;
    }

    $action = mysql_query("UPDATE ".TABLE_HLP." SET stromkosten = '".str_replace(",", ".", $_POST['kosten'])."', leistung = '".$_POST['leistung']."', dauer = '".$_POST['stunden']."' WHERE event_id = '".$event."'");

    if($action == 1)
    {
      return TRUE;
    }
    else
    {
      $this -> error = mysql_error();
      return FALSE;
    }
  }

  function readHLP($event)
  {
    $action = mysql_query("SELECT stromkosten, dauer, leistung, rabattamount, rabattuser FROM ".TABLE_HLP." WHERE event_id = '".$event."'");
    $row = mysql_fetch_assoc($action);
    $this -> stromkosten = $row['stromkosten'];
    $this -> dauer = $row['dauer'];
    $this -> leistung = $row['leistung'];
    $this -> rabattuser = $row['rabattuser'];
    $this -> rabattamount = $row['rabattamount'];

    $action = mysql_query("SELECT COUNT(*) AS anzahl FROM event_teilnehmer WHERE zahl_typ = '2' AND event_id = '".$event."'");
    $row = mysql_fetch_assoc($action);
    $this -> teilnehmer = $row['anzahl'];
  }
}

?>