Subversion-Projekte lars-tiefland.niewerth

<?php
        class AN
        {
                var $name;
                var $id;
                
                function AN($an_id)
                {
                        global $db;
                        if ($an_id)
                        {
                                $sql="SELECT an_id, CONCAT(an_vname, CONCAT(\" \", an_name)) AS an_name FROM arbeitnehmer WHERE an_id=$an_id";
                                $an_ret=$db->query($sql);
                                if (!PEAR::isError($an_ret))
                                {
                                        $an_row=$an_ret->fetchRow();
                                        $this->id=$an_row["an_id"];
                                        $this->name=$an_row["an_name"];
                                }
                        }
                        else
                        {
                                $this->an_name=null;
                                $this->an_id=-1;
                        }
                        return $this;
                }
                function Liste()
                {
                        global $db, $smarty;
                        //Alle Arbeitnehmer auslesen und zurückgeben
                        $sql="SELECT an_id, CONCAT(an_vname, CONCAT(\" \", an_name)) AS an_name FROM arbeitnehmer";
                        $an_ret=$db->query($sql);
                        if (!PEAR::isError($an_ret))
                        {
                                $an_arr[-1]="Bitte wählen!";
                                while($an_row=$an_ret->fetchRow())
                                {
                                        $an_id=$an_row["an_id"];
                                        $an_name=$an_row["an_name"];
                                        $an_arr["$an_id"]=$an_name;
                                }
                        }
                        else
                        {
                        }
                        return $an_arr;         
                }
        }
?>