Subversion-Projekte lars-tiefland.niewerth

<?php
        class Termin
        {
                var $an_id;
                var $f_id;
                var $datum;
                var $t_id;
                var $error;
                var $msg;
                
                //Termindaten auslesen;
                function Termin($t_id=0)
                {
                        global $db;
                        $this->error=false;
                        if($t_id)
                        {
                                $sql="SELECT * FROM termin WHERE t_id=$t_id";
                                $ret=$db->query($sql);
                                if (!PEAR::isError($ret))
                                {
                                        $row=$ret->fetchRow();
                                        $this->an_id=$row["an_id"];
                                        $this->f_id=$row["f_id"];
                                        $this->datum=$row["datum"];
                                        $this->t_id=$row["t_id"];
                                }
                                else
                                {
                                        $this->an_id=null;
                                        $this->f_id=null;
                                        $this->datum=null;
                                        $this->t_id=null;
                                        $this->error=true;
                                }
                                
                        }
                        else
                        {
                                $this->an_id=-1;
                                $this->f_id=-1;
                                $this->datum=date("Y-m-d");
                                $this->t_id=0;
                        }
                        return $this;
                }
                
                //Termindaten aktualisieren
                function update($an_id, $f_id, $datum, $t_id=0)
                {
                        $this->an_id=$an_id;
                        $this->f_id=$f_id;
                        $this->datum=$datum;
                        $this->t_id=$t_id;
                }
                
                //Termindaten speichern / löschen
                function save($mode)
                {
                        global $db;
                        if ($mode=="save" || $mode=="delete")
                        {
                                if ($mode=="save")
                                {
                                        $sql="INSERT INTO termin (an_id, f_id, datum) VALUES ($this->an_id, $this->f_id, '$this->datum')";
                                }
                                else
                                {
                                        $sql="DELETE FROM termin WHERE t_id=$this->t_id";
                                }
                                $ret=$db->query($sql);
                                if(PEAR::isError($ret))
                                {
                                        $this->error=true;
                                        $this->msg=$ret->getUserInfo();
                                }
                                else
                                {
                                        $this->error=false;
                                        $this->msg=null;
                                }
                        }
                        else
                        {
                                $this->error=true;
                                $this->msg="Unbekannte Operation!";
                        }
                        return $this;
                }
                
                function Liste($datum)
                {
                        global $db;
                        $sql="SELECT * FROM termin WHERE datum='$datum'";
                        //echo $sql;
                        $res=$db->query($sql);
                        $id=0;
                        while ($row=$res->fetchRow())
                        {
                                $f=new Firma($row["f_id"]);
                                $an=new AN($row["an_id"]);
                                
                                $ret[$id]["firma"]=$f->name;
                                $ret[$id]["an"]=$an->name;
                                $ret[$id]["t_id"]=$row["t_id"];
                                $id++;
                        }
                        return $ret;
                }
        }
?>