Subversion-Projekte lars-tiefland.niewerth

<?php
        class Firma
        {
                var $name;
                var $id;
                
                function Firma($f_id)
                {
                        global $db;
                        if ($f_id)
                        {
                                $sql="SELECT f_id, CONCAT(f_name, CONCAT(\" - \", f_ort)) AS f_name FROM firma WHERE f_id=$f_id";
                                $f_ret=$db->query($sql);
                                if (!PEAR::isError($f_ret))
                                {
                                        $f_row=$f_ret->fetchRow();
                                        $this->id=$f_row["f_id"];
                                        $this->name=$f_row["f_name"];
                                }
                        }
                        else
                        {
                                $this->name=null;
                                $this->id=-1;
                        }
                        return $this;
                }
                
                function Liste()
                {
                        global $db, $smarty;
                        //Alle Arbeitnehmer auslesen und zurückgeben
                        $sql="SELECT f_id, CONCAT(f_name, CONCAT(\" - \", f_ort)) AS f_name FROM firma";
                        $f_ret=$db->query($sql);
                        if (false===MDB2::isError($f_ret))
                        {
                                $firma_arr[-1]="Bitte wählen!";
                                while($f_row=$f_ret->fetchRow())
                                {
                                        $f_id=$f_row["f_id"];
                                        $f_name=$f_row["f_name"];
                                        $firma_arr["$f_id"]=$f_name;
                                }
                        }
                        else
                        {
                        }
                        return $firma_arr;              
                }
        }
?>