openrat-cms

Link.class.php (2549B)

---

 <?php
 namespace cms\model;
 
 
 use cms\base\DB as Db;
 
 /**
  * Darstellen einer Verkn�pfung. Eine Verkn�pfung kann auf eine Objekt oder auf
  * eine beliebige Url zeigen
  *
  * @version $Revision$
  * @author $Author$
  * @package openrat.objects
  */
 class Link extends BaseObject
 {
 	var $linkid;
 	var $linkedObjectId = 0;
 	var $url            = '';
 
 	public function __construct( $objectid='' )
 	{
 		parent::__construct( $objectid );
 		$this->isLink = true;
 		$this->typeid = BaseObject::TYPEID_LINK;
 	}
 
 
 
     /**
      * Lesen der Verknuepfung aus der Datenbank
      * @throws \util\exception\ObjectNotFoundException
      */
     public function load()
 	{
 		$db = \cms\base\DB::get();
 
 		$sql = $db->sql( 'SELECT *'.
 		                ' FROM {{link}}'.
 		                ' WHERE objectid={objectid}' );
 		$sql->setInt( 'objectid',$this->objectid );
 		$row = $sql->getRow();
 
 		if	( count($row ) != 0 )
 		{
 			$this->linkedObjectId = $row['link_objectid'];
 		}
 
 		$this->objectLoad();
 	}
 
 
     /**
      *
      */
     public function delete()
 	{
 		$db = \cms\base\DB::get();
 
 		// Verkn�pfung l�schen
 		$sql = $db->sql( 'DELETE FROM {{link}} '.
 		                ' WHERE objectid={objectid}' );
 		$sql->setInt( 'objectid',$this->objectid );
 
 		$sql->execute();
 
 		parent::delete();
 	}
 
 
     /**
      *
      */
     public function save()
 	{
 		$db = DB::get();
 		
 		$sql = $db->sql( <<<SQL
  		UPDATE {{link}}
  		   SET link_objectid = {linkobjectid}
 		 WHERE objectid={objectid}
 SQL
 );
 		$sql->setInt   ('objectid'    ,$this->objectid );
 
 		if ( ! $this->linkedObjectId )
 			$sql->setNull('linkobjectid');
 		else
 			$sql->setInt ('linkobjectid',$this->linkedObjectId );
 
 		$sql->execute();
 
 		parent::save();
 	}
 
 
 	public function getProperties()
 	{
 		return array_merge( parent::getProperties(),
 		                    array( 'objectid'       =>$this->objectid,
 		                           'linkobjectid'   =>$this->linkedObjectId
                             ));
 	}
 
 
 	public function getType()
 	{
 		return 'link';
 	}
 
 
     /**
      * Add a new link.
      */
     public function add()
 	{
 		parent::add();
 
 		$stmt = Db::sql('SELECT MAX(id) FROM {{link}}');
 		$this->linkid = intval($stmt->getOne())+1;
 
 		$stmt = Db::sql('INSERT INTO {{link}}'.
 		               ' (id,objectid,link_objectid)'.
 		               ' VALUES( {linkid},{objectid},{linkobjectid} )' );
 		$stmt->setInt   ('linkid'      ,$this->linkid         );
 		$stmt->setInt   ('objectid'    ,$this->objectid       );
         $stmt->setNull  ('linkobjectid');
 
 		$stmt->execute();
 	}	
 }