Last commit: Sat Jan 28 19:10:47 2023 +0100	Jan Dankert	New: Templates may be rendered as Mustache, Script and Script template.


      <?php
      namespace cms\model;
      
      
      use cms\base\DB;
      
      /**
       * Templatemodel.
       *
      * Contains mainly the source code.
      * For every model exists a template model.
      *
      * @author: Jan Dankert
      */
     class TemplateModel extends ModelBase
     {
     	const FORMAT_MUSTACHE_TEMPLATE = 1;
     	const FORMAT_RATSCRIPT = 2;
     	const FORMAT_RATSCRIPT_TEMPLATE = 3;
     
     
         /**
          * Primary Key.
          * @var
          */
         public $templatemodelid;
     
     
         /**
     	 * Dateierweiterung dieses Templates (abh?ngig von der Projektvariante)
     	 * @type String
     	 */
     	public $extension='';
     
     	/**
     	 * Inhalt des Templates (abh?ngig von der Projektvariante)
     	 * @type String
     	 */
     	public $src      ='';
     
         public $modelid;
         public $templateid;
     
     	/**
     	 * @var int
     	 */
         private $contentid;
     
         public $public;
     
     	/**
     	 * The format of the template, f.e. mustache, etc.
     	 * See the FORMAT_*-constants in this class.
     	 * @var int
     	 */
     	public $format;
     
     	/**
          * TemplateModel constructor.
          * @param $templateid
          * @param $modelid
          */
     	function __construct( $templateid,$modelid )
     	{
     	    $this->templateid = $templateid;
     	    $this->modelid    = $modelid;
     	}
     
     
     	/**
      	 * Laden des Templatemodells aus der Datenbank und füllen der Objekteigenschaften.
      	 */
     	function load()
     	{
     		$db = \cms\base\DB::get();
     
     		$stmt = $db->sql( <<<SQL
     			SELECT {{templatemodel}}.*,{{value}}.text,{{value}}.publish,{{value}}.format FROM {{templatemodel}}
                     LEFT JOIN {{value}}
                            ON {{value}}.contentid = {{templatemodel}}.contentid AND {{value}}.active = 1 
     		            WHERE templateid     = {templateid}
     		              AND projectmodelid = {modelid}
     SQL
     );
     		$stmt->setInt( 'templateid',$this->templateid );
     		$stmt->setInt( 'modelid'   ,$this->modelid    );
     		$row = $stmt->getRow();
     
     		if	( $row )
     		{
     			$this->templatemodelid = $row['id'       ];
     			$this->extension       = $row['extension'];
     			$this->src             = $row['text'     ];
     			$this->contentid       = $row['contentid'];
     			$this->public          = $row['publish'  ];
     			$this->format          = $row['format'   ];
     		}
     		else
     		{
    			$this->extension = null;
    			$this->src       = null;
    			$this->format    = null;
    		}
    	}
    
    
    
    	public function loadForPublic() {
    		$this->load();
    
    		$value = new Value();
    		$value->contentid = $this->contentid;
    		$value->loadPublished();
    		$this->src    = $value->text;
    		$this->format = $value->format;
    	}
    
    
    	public function isPersistent()
        {
    	    return intval( $this->templatemodelid ) > 0;
        }
    
    
    
        /**
     	 * Abspeichern des Templates in der Datenbank
     	 */
    	public function save()
    	{
            // Vorlagen-Quelltext existiert für diese Varianten schon.
            $stmt = Db::sql( <<<SQL
    			UPDATE {{templatemodel}}
                   SET extension={extension}
    			 WHERE id={id}
    SQL
    		);
    
            $stmt->setInt   ( 'id'       ,$this->templatemodelid );
            $stmt->setString( 'extension',$this->extension       );
    
    		$stmt->execute();
    
    		$value = new Value();
    		$value->contentid = $this->contentid;
    		$value->text   = $this->src;
    		$value->format = $this->format;
    		$value->publish = $this->public;
    
    		$value->persist();
    	}
    
    
    	/**
     	 * Abspeichern des Templates in der Datenbank
     	 */
    	protected function add()
    	{
            // Vorlagen-Quelltext wird neu angelegt.
            $stmt = Db::sql('SELECT MAX(id) FROM {{templatemodel}}');
            $nextid = intval($stmt->getOne())+1;
    
            $content = new Content();
            $content->persist();
            $this->contentid = $content->getId();
    
            $stmt = Db::sql( 'INSERT INTO {{templatemodel}}'.
                            '        (id,contentid,templateid,projectmodelid,extension) '.
                            ' VALUES ({id},{contentid},{templateid},{modelid},{extension}) ');
            $stmt->setInt   ( 'id',$nextid         );
    
    		$stmt->setString( 'extension'     ,$this->extension      );
    		$stmt->setInt   ( 'contentid'     ,$this->contentid      );
    		$stmt->setInt   ( 'templateid'    ,$this->templateid     );
    		$stmt->setInt   ( 'modelid'       ,$this->modelid        );
    
    		$stmt->execute();
    
            $this->templatemodelid = $nextid;
        }
    
    
    	/**
     	 * Loeschen des Templates
     	 *
     	 * Entfernen alle Templateinhalte und des Templates selber
     	 */
    	public function delete()
    	{
    		$db = \cms\base\DB::get();
    
    		$content = new Content( $this->contentid );
    		$content->delete();
    
    		$stmt = $db->sql(<<<SQL
    			DELETE FROM {{templatemodel}}
    			 WHERE id={id}
    SQL
    		);
    		$stmt->setInt( 'id',$this->templatemodelid );
    		$stmt->execute();
    	}
    	
    	
    	/**
    	 * Ermittelt den Mime-Type zu diesem Templatemodell.
    	 * 
    	 * Es wird die Extension des Templates betrachtet und dann mit Hilfe der
    	 * Konfigurationsdatei 'mime-types.ini' der Mime-Type bestimmt. 
    	 *
    	 * @return String Mime-Type  
    	 */
    	public function mimeType()
    	{
    		// Nur den letzten Teil der Extension auswerten:
    		// Aus 'mobile.html' wird nur 'html' verwendet.
    		$parts = explode('.',$this->extension);
    		$extension = strtolower(array_pop($parts));
    
    		$this->mime_type = File::getMimeType($extension);
    
    		return( $this->mime_type );
    	}
    
    
        public function getName()
        {
            return '';
        }
    
    
    	public function getId()
    	{
    		return $this->templatemodelid;
    	}
    
    
    	/**
    	 * @return int
    	 */
    	public function getContentid()
    	{
    		return $this->contentid;
    	}
    
    
    	/**
    	 * @return int
    	 */
    	public function getFormat()
    	{
    		if   ( $this->format )
    			return $this->format;
    		else
    			return self::FORMAT_MUSTACHE_TEMPLATE;
    	}
    
    
    	/**
    	 * @return string
    	 */
    	public function getSource()
    	{
    		return $this->src;
    	}
    }
    


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

History
Sat, 28 Jan 2023 19:10:47 +0100	Jan Dankert	New: Templates may be rendered as Mustache, Script and Script template.
Sat, 27 Nov 2021 04:38:28 +0100	Jan Dankert	New: Option to explicitly release a new template source.
Sat, 27 Nov 2021 00:11:56 +0100	Jan Dankert	New: History for files and templates.
Tue, 9 Nov 2021 23:52:56 +0100	Jan Dankert	Some fixes for reading content from the new content table.
Tue, 9 Nov 2021 00:35:42 +0100	Jan Dankert	Fixes: Reading and writing template sources with the new content table.
Mon, 8 Nov 2021 01:05:19 +0100	Jan Dankert	Refactoring: Reading values from the new content table.
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, 23 Oct 2020 23:09:52 +0200	Jan Dankert	Refactoring: Using the new config classes.
Fri, 2 Oct 2020 23:11:48 +0200	Jan Dankert	Cleanup: No '.inputholder' any more, notices with links to objects.
Sat, 26 Sep 2020 10:32:02 +0200	Jan Dankert	Refactoring: No global $conf array any more.
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.
Fri, 25 Sep 2020 01:01:41 +0200	Jan Dankert	Fix: The templatemodel source must be not null.
Wed, 23 Sep 2020 01:04:05 +0200	Jan Dankert	Cleanup of deprecated methods and deprecated class attributes.
Sun, 23 Feb 2020 04:01:30 +0100	Jan Dankert	Refactoring with Namespaces for the cms modules, part 1: moving.