Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 111 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 111 Revision 114
Zeile 1... Zeile 1...
1 
<?
 1 
<?
2 
	class Ort
 2 
    class Ort
3 
	{
 3 
    {
4 
		var $o_id;
 4 
        var $o_id;
5 
		var $o_name;
 5 
        var $o_name;
6 
		var $o_name2;
 6 
        var $o_name2;
7
7 
 
8 
		function __construct($o_id)
 8 
        function __construct( $o_id )
9 
		{
 9 
        {
10 
			global $db, $db_meld, $error, $meld;
 10 
            global $db, $db_meld, $error, $meld;
11 
			$o_id=intval($o_id);
 11 
            $o_id = intval( $o_id );
12 
			$sql="SELECT * FROM locations WHERE l_id=$o_id";
 12 
            $sql = "SELECT * FROM locations WHERE l_id=$o_id";
13 
			$res=$db->query($sql);
 13 
            $res = $db->query( $sql );
14 
			if (true == DB::isError($res))
 14 
            if ( true == DB::isError($res) )
15 
			{
 15 
            {
16 
				$error="true";
 16 
                $error = "true";
17 
				$meld="Ein Fehler ist aufgetreten!";
 17 
                $meld = "Ein Fehler ist aufgetreten!";
18 
				$db_meld=$res->getUserInfo();
 18 
                $db_meld = $res->getUserInfo();
19 
				return $error;
 19 
                return $error;
20 
			}
 20 
            }
21 
			else
 21 
            else
22 
			{
 22 
            {
23 
				$row=$res->fetchRow();
 23 
                $row = $res->fetchRow();
24 
				$this->o_id=$o_id;
 24 
                $this->o_id = $o_id;
25 
				$this->o_name=$row["l_name"];
 25 
                $this->o_name = $row["l_name"];
26 
				$this->o_name2=$row["l_name2"];
 26 
                $this->o_name2 = $row["l_name2"];
27 
				return $this;
 27 
                return $this;
28 
			}
 28 
            }
29 
		}
 29 
        }
30
30 
 
31 
		function update($l_name, $l_name2)
 31 
        function update( $l_name, $l_name2 )
32 
		{
 32 
        {
33 
			$this->o_name=$l_name;
 33 
            $this->o_name = $l_name;
34 
			$this->o_name2=$l_name2;
 34 
            $this->o_name2 = $l_name2;
35 
		}
 35 
        }
36
36 
 
37 
		function save($op)
 37 
        function save( $op )
38 
		{
 38 
        {
39 
			global $db;
 39 
            global $db;
40 
			switch($op)
 40 
            switch ( $op )
41 
			{
 41 
            {
42 
				case "save":
 42 
                case "save":
43 
					$sql="INSERT INTO locations (l_name, l_name2)
 43 
                    $sql = "INSERT INTO locations (l_name, l_name2)
44 
						VALUES ('$this->o_name', '$this->o_name2')";
 44 
						VALUES ('$this->o_name', '$this->o_name2')";
45 
					break;
 45 
                    break;
46 
				case "update":
 46 
                case "update":
47 
					$sql="UPDATE locations SET l_name='$this->o_name', l_name2='$this->o_name2' WHERE l_id=$this->o_id";
 47 
                    $sql = "UPDATE locations SET l_name='$this->o_name', l_name2='$this->o_name2' WHERE l_id=$this->o_id";
48 
					break;
 48 
                    break;
49 
				case "del":
 49 
                case "del":
50 
					$sql="DELETE FROM locations WHERE l_id=$this->o_id";
 50 
                    $sql = "DELETE FROM locations WHERE l_id=$this->o_id";
51 
					break;
 51 
                    break;
52 
			}
 52 
            }
53 
			return $db->query($sql);
 53 
            return $db->query( $sql );
54 
		}
 54 
        }
55
55 
 
56 
		function listeOrt($limit, $start=0)
 56 
        function listeOrt( $limit, $start = 0 )
57 
		{
 57 
        {
58 
			global $db, $db_meld, $error, $meld, $user;
 58 
            global $db, $db_meld, $error, $meld, $user;
59 
			$sql="SELECT * FROM locations";
 59 
            $sql = "SELECT * FROM locations";
60 
			if ($db->provides('limit') && $limit > 0)
 60 
            if ( $db->provides('limit') && $limit > 0 )
61 
			{
 61 
            {
62 
				$res=$db->limitquery($sql, $start, $limit);
 62 
                $res = $db->limitquery( $sql, $start, $limit );
63 
			}
 63 
            }
64 
			else
 64 
            else
65 
			{
 65 
            {
66 
				$res=$db->query($sql);
 66 
                $res = $db->query( $sql );
67 
			}
 67 
            }
68 
			if (true == DB::isError($res))
 68 
            if ( true == DB::isError($res) )
69 
			{
 69 
            {
70 
				$error=true;
 70 
                $error = true;
71 
				$meld="Ein Fehler ist aufgetreten!";
 71 
                $meld = "Ein Fehler ist aufgetreten!";
72 
				$db_meld=$res->getUserInfo();
 72 
                $db_meld = $res->getUserInfo();
73 
			}
 73 
            }
74 
			return $res;
 74 
            return $res;
75 
		}
 75 
        }
76 
	}
 76 
    }
77 
?>
 77 
?>