Subversion-Projekte lars-tiefland.niewerth

Revision

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