Subversion-Projekte lars-tiefland.inventar

<?php

        //$Id: comp.class.php 20 2008-05-15 19:12:18Z lars $
        
        /**
         * @package     Inventar Datenbank
         * @author Lars Tiefland <ltiefland@gmail.com>
         * @copyright 2008
         **/

        class comp{
                private $id;
                private $name;
                private $os_id;
                
                function __construct($id=0)
                {
                        if($id)
                        {
                                $res=$GLOBALS["db"]->query("SELECT * FROM computer WHERE id=$id");
                                $this->id=$id;
                                $row=$res->fetchRow();
                                $this->name=$row["name"];       
                                $this->os_id=$row["os_id"];
                        }
                        else
                        {
                                $this->id=0;
                                $this->name='';
                                $this->os_id=1;
                        }
                }
                static function get_computers($start=0,$limit=0)
                {
                        $sql="SELECT * FROM computer";
                        if($limit)
                        {
                                $res=$GLOBALS["db"]->limiquery($sql,$start,$limit);
                        }
                        else
                        {
                                $res=$GLOBALS["db"]->query($sql);
                        }
                        while($row=$res->fetchRow())
                        {
                                $comp[]=$row;
                        }
                        return $comp;
                }
                
                function toArray()
                {
                        $ret["name"]=$this->name;
                        $ret["id"]=$this->id;
                        $ret["os_id"]=$this->os_id;
                        $temp=new os($this->os_id);
                        $os=$temp->toArray();
                        $ret["os_name"]=$os["name"];
                        return $ret;
                }
        }

?>