Last commit: Sat Jun 25 14:26:33 2022 +0200	Jan Dankert	New: Many Enhancements for the internal script language: More access to the data structure of pages, folders, templates, ...


      <?php
      namespace cms\model;
      // OpenRat Content Management System
      // Copyright (C) 2002-2012 Jan Dankert, cms@jandankert.de
      //
      // This program is free software; you can redistribute it and/or
      // modify it under the terms of the GNU General Public License
      // as published by the Free Software Foundation; either version 2
      // of the License, or (at your option) any later version.
     //
     // This program is distributed in the hope that it will be useful,
     // but WITHOUT ANY WARRANTY; without even the implied warranty of
     // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
     // GNU General Public License for more details.
     //
     // You should have received a copy of the GNU General Public License
     // along with this program; if not, write to the Free Software
     // Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
     
     
     
     /**
      * Diese Klasse stellt ein Projektmodell dar. Ein Projektmodell ist eine Darstellungsart
      * der Inhalte. Zu jedem Projektmodell gibt es einen anderen Templatequelltext.
      * Beispiel: Neben HTML gibt es ein Projektmodell fuer WML oder XML. Die Inhalte sind gleich,
      * aber die Art der Ausgabe ist jeweils anders.
      *
      * @package openrat.objects
      * @author $Author$
      * @version $Rev: $
      */
     class Model extends ModelBase
     {
     	var $modelid = 0;
     	var $error      = '';
     	var $projectid;
     
     	var $name      = '';
     	var $isDefault = false;
     
     
     	/**
     	 * Konstruktor
     	 */
     	function __construct( $modelid='' )
     	{
     		if   ( is_numeric($modelid) )
     			$this->modelid = $modelid;
     	}
     
     	
     	/**
     	 * Stellt fest, ob die angegebene Id existiert.
     	 */
     	function available( $id )
     	{
     		$db = \cms\base\DB::get();
     
     		$sql = $db->sql('SELECT 1 FROM {{projectmodel}} '.
     		               ' WHERE id={id}');
     		$sql->setInt('id' ,$id  );
     
     		return intval($sql->getOne()) == 1;
     	}
     	
     
     	
     
     	/**
     	 * Lesen aus der Datenbank
     	 */
     	function load()
     	{
     		$db = \cms\base\DB::get();
     
     		$sql = $db->sql( 'SELECT * FROM {{projectmodel}}'.
     		                ' WHERE id={modelid}' );
     		$sql->setInt( 'modelid',$this->modelid );
     
     		$row = $sql->getRow();
     
     		$this->name      = $row['name'     ];
     		$this->projectid = $row['projectid'];
     	
     		if	( $row['is_default'] == '1' )
     			$this->isDefault = true;
     		else $this->isDefault = false;
     
     		return $this;
     	}
     
     
     	/**
     	 * Speichern des Projektmodells
     	 */
     	function save()
     	{
     		$db = \cms\base\DB::get();
     
    		// Gruppe speichern		
    		$sql = $db->sql( 'UPDATE {{projectmodel}} '.
    		                '  SET name      = {name} '.
    		                '  WHERE id={modelid}' );
    		$sql->setString( 'name'     ,$this->name    );
    
    		$sql->setInt( 'modelid',$this->modelid );
    
    		// Datenbankabfrage ausfuehren
    		$sql->execute();
    	}
    
    
    	/**
    	 * Alle notwendigen Eigenschaften dieses Projektmodells
    	 * werden als Array zurueckgegeben
    	 *
    	 * @return array
    	 */
    	function getProperties()
    	{
    		return Array( 'modelid'  =>$this->modelid,
    		              'projectid'=>$this->projectid,
    		              'isDefault'=>$this->isDefault,
    		              'name'     =>$this->name );
    	}
    
    
    	/**
    	 * Modell hinzufuegen
    	 * @param String Name des Modells (optional)
    	 */
    	function add( $name = '' )
    	{
    		if	( $name != '' )
    			$this->name = $name;
    		
    		$db = \cms\base\DB::get();
    
    		$sql = $db->sql('SELECT MAX(id) FROM {{projectmodel}}');
    		$this->modelid = intval($sql->getOne())+1;
    
    		// Modell hinzuf?gen
    		$sql = $db->sql( 'INSERT INTO {{projectmodel}} '.
    		                "(id,projectid,name,extension,is_default) VALUES( {modelid},{projectid},{name},'',0 )");
    
    		$sql->setInt   ('modelid'  ,$this->modelid   );
    		$sql->setInt   ('projectid',$this->projectid );
    		$sql->setString('name'     ,$this->name      );
    
    		// Datenbankbefehl ausfuehren
    		$sql->execute();
    	}
    
    
    
    	// Diese Sprache als 'default' markieren.
    	function setDefault()
    	{
    		$db = \cms\base\DB::get();
    
    		// Zuerst alle auf nicht-Standard setzen
    		$sql = $db->sql( 'UPDATE {{projectmodel}} '.
    		                '  SET is_default = 0 '.
    		                '  WHERE projectid={projectid}' );
    		$sql->setInt('projectid',$this->projectid );
    		$sql->execute();
    	
    		// Jetzt die gew?nschte Sprachvariante auf Standard setzen
    		$sql = $db->sql( 'UPDATE {{projectmodel}} '.
    		                '  SET is_default = 1 '.
    		                '  WHERE id={modelid}' );
    		$sql->setInt('modelid',$this->modelid );
    		$sql->execute();
    	}
    
    
    	/**
    	 * Entfernen des Projektmodells aus der Datenbank
    	 * Es wird dabei nicht geprueft, ob noch ein anders Projektmodell
    	 * vorhanden ist.
    	 */
    	function delete()
    	{
    		$db = \cms\base\DB::get();
    
    		// Vorlagen zu dieseem Modell loeschen
    		$sql = $db->sql( <<<SQL
    	DELETE FROM {{templatemodel}}
    	 WHERE projectmodelid = {modelid}
    SQL
    );
    		$sql->setInt( 'modelid',$this->modelid );
    		$sql->execute();
    		
    		// Dieses Modell löschen
    		$sql = $db->sql( <<<SQL
    	DELETE FROM {{projectmodel}}
    	 WHERE id={modelid}
    SQL
    );
    		$sql->setInt( 'modelid',$this->modelid );
    		$sql->execute();
    
    		// Anderes Modell auf "Default" setzen (sofern vorhanden)
    		if	( $this->isDefault )
    		{
    			$sql = $db->sql( 'SELECT id FROM {{projectmodel}} WHERE projectid={projectid}' );
    			$sql->setInt( 'projectid',$this->projectid );
    			$new_default_modelid = $sql->getOne();
    	
    			$sql = $db->sql( 'UPDATE {{projectmodel}} SET is_default=1 WHERE id={modelid}' );
    			$sql->setInt( 'modelid',$new_default_modelid );
    			$sql->execute();
    		}
    	}
    
        public function getName()
        {
            return $this->name;
        }
    
    
    	public function getId()
    	{
    		return $this->modelid;
    	}
    
    
    }


Download modules/cms/model/Model.class.php

History
Sat, 25 Jun 2022 14:26:33 +0200	Jan Dankert	New: Many Enhancements for the internal script language: More access to the data structure of pages, folders, templates, ...
Sun, 7 Mar 2021 00:10:20 +0100	Jan Dankert	Refactoring: Hopefully more performance while accessing the database resultsets.
Wed, 18 Nov 2020 01:46:36 +0100	Jan Dankert	Refactoring of model classes: New method persist() and some other cleanups.
Fri, 2 Oct 2020 23:11:48 +0200	Jan Dankert	Cleanup: No '.inputholder' any more, notices with links to objects.
Sat, 26 Sep 2020 12:20:43 +0200	Jan Dankert	Refactoring: No global variables like $SESS  any more. All constants are capsulated by classes.
Sat, 26 Sep 2020 02:26:39 +0200	Jan Dankert	Refactoring: No global functions any more, the database object is read from the Db class.
Sun, 23 Feb 2020 04:01:30 +0100	Jan Dankert	Refactoring with Namespaces for the cms modules, part 1: moving.