Subversion-Projekte lars-tiefland.niewerth

Revision

Revision 3 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
2 lars 1 
<?php
3 lars 2 
	class Termin
3 
	{
4 
		var $an_id;
5 
		var $f_id;
6 
		var $datum;
7 
		var $t_id;
8 
		var $error;
9 
		var $msg;
10 
 
11 
		//Termindaten auslesen;
12 
		function Termin($t_id=0)
13 
		{
14 
			$this->error=false;
15 
			if($t_id)
16 
			{
17 
				$sql="SELECT * FROM termin";
18 
				$ret=$db->query($sql);
19 
				if (!PEAR::isError($ret))
20 
				{
21 
					$row=$ret->fetchRow();
22 
					$this->an_id=$row["an_id"];
23 
					$this->f_id=$row["f_id"];
24 
					$this->datum=$row["datum"];
25 
					$this->t_id=$row["t_id"];
26 
				}
27 
				else
28 
				{
29 
					$this->an_id=null;
30 
					$this->f_id=null;
31 
					$this->datum=null;
32 
					$this->t_id=null;
33 
					$this->error=true;
34 
				}
35 
 
36 
			}
37 
			else
38 
			{
39 
				$this->an_id=-1;
40 
				$this->f_id=-1;
41 
				$this->datum=date("Y-m-d");
42 
				$this->t_id=0;
43 
			}
44 
			return $this;
45 
		}
46 
 
47 
		//Termindaten aktualisieren
48 
		function update($an_id, $f_id, $datum, $t_id=0)
49 
		{
50 
			$this->an_id=$an_id;
51 
			$this->f_id=$f_id;
52 
			$this->datum=$datum;
53 
			$this->t_id=$t_id;
54 
		}
55 
 
56 
		//Termindaten speichern / löschen
57 
		function save($mode)
58 
		{
59 
			global $db;
60 
			if ($mode=="save" || $mode=="delete")
61 
			{
62 
				if ($mode=="save")
63 
				{
64 
					$sql="INSERT INTO termin (an_id, f_id, datum) VALUES ($this->an_id, $this->f_id, '$this->datum')";
65 
				}
66 
				else
67 
				{
68 
					$sql="DELETE FROM termin WHERE t_id=$this->t_id";
69 
				}
70 
				$ret=$db->query($sql);
71 
				if(PEAR::isError($ret))
72 
				{
73 
					$this->error=true;
74 
					$this->msg=$ret->getUserInfo();
75 
				}
76 
				else
77 
				{
78 
					$this->error=false;
79 
					$this->msg=null;
80 
				}
81 
			}
82 
			else
83 
			{
84 
				$this->error=true;
85 
				$this->msg="Unbekannte Operation!";
86 
			}
87 
			return $this;
88 
		}
12 lars 89 
 
90 
		function Liste($datum)
91 
		{
92 
			global $db;
93 
			$sql="SELECT * FROM termin WHERE datum='$datum'";
94 
			//echo $sql;
95 
			$res=$db->query($sql);
96 
			$id=0;
97 
			while ($row=$res->fetchRow())
98 
			{
99 
				$f=new Firma($row["f_id"]);
100 
				$an=new AN($row["an_id"]);
101 
 
102 
				$ret[$id]["firma"]=$f->name;
103 
				$ret[$id]["an"]=$an->name;
104 
				$id++;
105 
			}
106 
			return $ret;
107 
		}
3 lars 108 
	}
2 lars 109 
?>