Last commit: Sun Jan 29 00:20:21 2023 +0100	Jan Dankert	New node type "Script".


      <?php
      namespace cms\model;
      use cms\base\Configuration;
      use cms\base\DB;
      use cms\base\Startup;
      use util\ArrayUtils;
      use cms\generator\Publish;
      use cms\macros\MacroRunner;
      use \util\exception\ObjectNotFoundException;
     use logger\Logger;
     use util\exception\GeneratorException;
     use util\Request;
     use util\Text;
     use util\Html;
     use util\Http;
     use util\Transformer;
     use util\Code;
     use util\cache\FileCache;
     
     /**
      * Darstellen einer Inhaltes
      *
      * @author Jan Dankert
      */
     
     class Value extends ModelBase
     {
     	/**
     	 * ID of this value.
     	 * @type Integer
     	 */
     	public $valueid=0;
     
     	/**
     	 * Content ID.
     	 * @var int
     	 */
     	public $contentid;
     
     
     	/**
     	 * Linked object-id.
     	 * @type Integer
     	 */
     	public $linkToObjectId=0;
     
     	/**
     	 * textual value
     	 * @type String
     	 */
     	public $text='';
     	
     	/**
     	 * Number.
     	 * @type Integer
     	 */
     	public $number=0;
     
     	
     	/**
     	 * Date.
     	 *
     	 * Saved as unix-timestamp
     	 *
     	 * @type Integer
     	 */
     	public $date=0;
     
     	/**
     	 * file blob.
     	 *
     	 * @var string
     	 */
     	public $file = null;
     
     	/**
     	 * TimeStamp of last change.
     	 * @type Integer
     	 */
     	public $lastchangeTimeStamp;
     	
     	/**
     	 * user-Id of the user who created this value.
     	 *
     	 * @type Integer
     	 */
     	public $lastchangeUserId;
     
     	/**
     	 * Name of user who created this value.
     	 *
     	 * This attribute is readonly.
     	 *
     	 * @type Integer
     	 */
     	public $lastchangeUserName;
     	
     	/**
     	 * Is this content active?
    	 *
    	 * Only 1 value (mostly the latest) in a content is active.
    	 *
    	 * @type Boolean
    	 */
    	public $active;
    	
    	/**
    	 * Is this content public available?
    	 * @type boolean
    	 */
    	public $publish = false;
    
        /**
         * Format
         *
         * @var int
         */
        public $format = null;
    
        /**
    	 * Constructor.
    	 */
    	function __construct()
    	{
    	}
    
    
    
    
    	/**
    	 * Laden des aktuellen Inhaltes aus der Datenbank
    	 */
    	public function loadPublished()
    	{
    		$stmt = Db::sql( <<<SQL
                 SELECT *,{{user}}.fullname as lastchange_username
                   FROM {{value}}
    		  LEFT JOIN {{user}}
    		         ON {{user}}.id = {{value}}.lastchange_userid
            	WHERE contentid = {contentid}
            	  AND publish = 1
    SQL
    		);
    		$stmt->setInt( 'contentid' ,$this->contentid);
    
    		$this->bindRow( $stmt->getRow() );
    	}
    
    
    	private function bindRow( $row ) {
    
    		if	( $row ) // If found
    		{
    			$this->contentid      = $row['contentid' ];
    			$this->text           = $row['text'      ];
    			$this->file           = $row['file'      ];
    			$this->format         = $row['format'    ];
    			$this->valueid        = intval($row['id']          );
    			$this->linkToObjectId = intval($row['linkobjectid']);
    			$this->number         = intval($row['number'      ]);
    			$this->date           = intval($row['date'        ]);
    
    			// If the value is stored in BASE64 we must decode it now.
    			$valueIsStoredAsBase64 = DB::get()->conf['base64'];
    
    			if	( $valueIsStoredAsBase64 )
    				$this->file = base64_decode( $this->file );
    
    			$this->active         = ( $row['active' ]=='1' );
    			$this->publish        = ( $row['publish']=='1' );
    
    			$this->lastchangeTimeStamp = intval($row['lastchange_date'    ]);
    			$this->lastchangeUserId    = intval($row['lastchange_userid'  ]);
    			$this->lastchangeUserName  =        $row['lastchange_username'];
    		}
    	}
    
    
    	/**
    	 * Loading the last value from the database.
    	 */
    	public function load()
    	{
    		$stmt = Db::sql( <<<SQL
                 SELECT *,{{user}}.fullname as lastchange_username
                   FROM {{value}}
    		  LEFT JOIN {{user}}
    		         ON {{user}}.id = {{value}}.lastchange_userid
            	  WHERE contentid = {contentid}
            	    AND {{value}}.active = 1
    SQL
    		);
    		$stmt->setInt( 'contentid' ,$this->contentid);
    
    		$this->bindRow( $stmt->getRow() );
    	}
    
    
    	/**
    	 * Laden eines bestimmten Inhaltes aus der Datenbank
    	 */
    	function loadWithId( $valueid = null )
    	{
    		$stmt = Db::sql( <<<SQL
                 SELECT {{value}}.*,{{user}}.fullname as lastchange_username
                   FROM {{value}}
    		  LEFT JOIN {{user}}
    		         ON {{user}}.id = {{value}}.lastchange_userid
            	WHERE {{value}}.id = {valueid}
    SQL
    		);
    		$stmt->setInt( 'valueid'   ,$valueid  );
    
    		$this->bindRow( $stmt->getRow() );
    	}
    
    
    	/**
    	 * @see #save()
    	 */
    	protected function add()
    	{
    		// this is implemented in the save() method.
    	}
    
    
    	/**
    	 * Saving the value.
    	 * A value is always added, never overwritten. So we are doing an INSERT here.
    	 */
    	protected function save()
    	{
    		$stmt = Db::sql( <<<SQL
    			UPDATE {{value}}
    		                  SET active=0
                              WHERE contentid = {contentid}
    SQL
    		);
    		$stmt->setInt( 'contentid' ,$this->contentid );
    
    		$stmt->execute();
    
    		if	( $this->publish )
    		{
    			// Wenn Inhalt sofort veroeffentlicht werden kann, dann
    			// alle anderen Inhalte auf nicht-veroeffentlichen stellen
    			$stmt = DB::sql( <<<SQL
     					UPDATE {{value}}
    			                  SET publish=0
                                WHERE contentid = {contentid}
    SQL
    			);
    			$stmt->setInt( 'contentid' ,$this->contentid );
    
    			$stmt->execute();
    		}
    
    		// Naechste ID aus Datenbank besorgen
    		$stmt = DB::sql('SELECT MAX(id) FROM {{value}}');
    		$this->valueid = intval($stmt->getOne())+1;
    
    		$stmt = DB::sql( <<<SQL
    INSERT INTO {{value}}
                (id       ,contentid  ,linkobjectid  ,text  ,file  ,number  ,date  ,format  ,active,publish  ,lastchange_date  ,lastchange_userid  )
         VALUES ({valueid},{contentid},{linkobjectid},{text},{file},{number},{date},{format},1     ,{publish},{lastchange_date},{lastchange_userid})
    SQL
    		);
    		$stmt->setInt( 'valueid'   ,$this->valueid            );
    		$stmt->setInt( 'contentid' ,$this->contentid          );
    		$stmt->setInt( 'format'    ,$this->format             );
    
    		if	( intval($this->linkToObjectId)==0)
    			$stmt->setNull  ( 'linkobjectid' );
    		else	$stmt->setInt   ( 'linkobjectid',$this->linkToObjectId   );
    
    		if	( $this->text == '' )
    			$stmt->setNull  ( 'text' );
    		else	$stmt->setString( 'text',$this->text );
    
    		if	( intval($this->number)==0)
    			$stmt->setNull  ( 'number' );
    		else	$stmt->setInt   ( 'number',$this->number );
    
    		if	( intval($this->date)==0)
    			$stmt->setNull  ( 'date' );
    		else	$stmt->setInt   ( 'date',$this->date );
    
    
    		if	( $this->file === null )
    			$stmt->setNull  ( 'file' );
    		else {
    			$storeValueAsBase64 = DB::get()->conf['base64'];
    
    			if( $storeValueAsBase64 ) {
    				$stmt->setString( 'file'  ,base64_encode($this->file) );
    			}
    			else {
    				$stmt->setString( 'file'  ,$this->file );
    			}
    		}
    
    		$stmt->setBoolean( 'publish'          ,$this->publish );
    		$stmt->setInt    ( 'lastchange_date'  ,Startup::now()         );
    		$user = Request::getUser();
    		$stmt->setIntOrNull( 'lastchange_userid',$user?$user->userid:null ); // user may be null, if a guest is saving.
    
    		$stmt->execute();
    
    		$this->pruneVersions();
    	}
    
    
    	// Some default values for pruning content
    	const DEFAULT_PRUNE_AFTER_AGE = 10 * 365 * 24 * 60 * 60; // prune after 10 years
    	const DEFAULT_PRUNE_AFTER_VERSIONS = 100; // prune after reaching 100 versions
    
    	/**
    	 * Automatic content pruning.
    	 *
    	 * Deletes old versions.
    	 */
    	private function pruneVersions()
    	{
    		$pruneConfig = Configuration::subset(['content','prune']);
    
    		if	( ! $pruneConfig->is('enabled',true) )
    			return; // no pruning.
    
    		// First Step: Reading all value id.
    		$sql = DB::sql( <<<SQL
    		             SELECT id FROM {{value}}
                              WHERE contentid = {contentid}
    			                    AND active     = 0
    			                    AND publish    = 0
    			                   ORDER BY id
    SQL
    		);
    		$sql->setInt( 'contentid' ,$this->contentid );
    		$values = $sql->getCol();
    
    		// Now deleting all outdated content.
    		$sql = DB::sql( <<<SQL
    		DELETE FROM {{value}}
    					  WHERE contentid = {contentid}
    								AND active     = 0
    								AND publish    = 0
    								AND lastchange_date < {delete_before_date}
    								AND id              < {delete_before_id}
    SQL
    		);
    		$sql->setInt( 'contentid' ,$this->contentid );
    		$sql->setInt( 'delete_before_date'  ,time() - $pruneConfig->getSeconds('age',self::DEFAULT_PRUNE_AFTER_AGE) );
    		$sql->setInt( 'delete_before_id'    ,intval(@$values[count($values)-$pruneConfig->get('versions',self::DEFAULT_PRUNE_AFTER_VERSIONS)]) );
    		$sql->execute();
    	}
    
    
    
    	/**
    	 * Deleting (not possible).
    	 */
    	function delete()
    	{
    		// values cannot be deleted.
    		// only the whole content is able to be deleted, see class Content.
    	}
    
    
    
    	/**
    	 * Ermittelt den unbearbeiteten, "rohen" Inhalt.
    	 *
    	 * @param int $elementTypeId
    	 * @return mixed Inhalt
    	 */
    	public function getRawValue($elementTypeId)
    	{
    		switch( $elementTypeId )
    		{
    			case Element::ELEMENT_TYPE_LINK:
    				return $this->linkToObjectId;
    				
    			case Element::ELEMENT_TYPE_DATE;
    				return $this->date;
    				
    			default:
    				return $this->text;
    		}
    	}
    
    
        public function getName()
        {
            return "Value#".$this->valueid;
        }
    
    
        public function __toString()
    	{
    		return "Value: ".print_r($this,true);
    	}
    
    
    
    	public function getId()
    	{
    		return $this->valueid;
    	}
    
    
    }


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

History
Sun, 29 Jan 2023 00:20:21 +0100	Jan Dankert	New node type "Script".
Fri, 15 Apr 2022 14:51:22 +0200	dankert	Refactoring: User,Config and Database info is now stored in the Request, because so there is no session required for clients which are using Basic Authorization.
Sun, 5 Dec 2021 20:33:24 +0100	dankert	Cleanup: Removed unusable properties from class 'Value' and 'BaseObject'.
Sun, 5 Dec 2021 15:33:29 +0100	dankert	Cleanup: Removed unusable properties from class 'Value'.
Sat, 27 Nov 2021 23:31:32 +0100	Jan Dankert	Fix: Saving values for unauthenticated users.
Sat, 27 Nov 2021 18:34:26 +0100	Jan Dankert	Fix: Load contentid while value is loaded.
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 01:22:31 +0100	Jan Dankert	Fix: Creating and reading files.
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.
Tue, 23 Feb 2021 22:59:12 +0100	Jan Dankert	New: Use a default value from a linked page.
Fri, 8 Jan 2021 22:01:28 +0100	Jan Dankert	New: Implementing cache directory tag standard (CACHEDIR.TAG) and using a cleaner logic to detect the directory for temporary files.
Wed, 18 Nov 2020 01:46:36 +0100	Jan Dankert	Refactoring of model classes: New method persist() and some other cleanups.
Fri, 13 Nov 2020 23:41:58 +0100	Jan Dankert	Cleaned database statements.
Fri, 13 Nov 2020 23:24:54 +0100	Jan Dankert	Using icons for the history view, this is much cleaner.
Fri, 13 Nov 2020 00:12:44 +0100	Jan Dankert	Fixing Pagelement-History and Diff.
Sun, 1 Nov 2020 00:36:50 +0100	Jan Dankert	Refactoring: Only using the configuration object.
Fri, 2 Oct 2020 23:11:48 +0200	Jan Dankert	Cleanup: No '.inputholder' any more, notices with links to objects.
Tue, 29 Sep 2020 23:28:38 +0200	Jan Dankert	Fix: Only warn, if another (!) user has changed a edited value.
Tue, 29 Sep 2020 22:17:11 +0200	Jan Dankert	Refactoring: Do not use global constants.
Sat, 26 Sep 2020 04:26:55 +0200	Jan Dankert	Refactoring: read configuration values with a class.
Sat, 26 Sep 2020 03:03:47 +0200	Jan Dankert	Refactoring: less global functions.
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.
Wed, 23 Sep 2020 01:04:05 +0200	Jan Dankert	Cleanup of deprecated methods and deprecated class attributes.
Mon, 21 Sep 2020 23:44:23 +0200	Jan Dankert	Fixing editing of values.
Mon, 21 Sep 2020 22:48:59 +0200	Jan Dankert	Complexe refactoring: Moving all generation logic from the model (Value,Page,File) to generators classes.
Fri, 18 Sep 2020 23:04:13 +0200	Jan Dankert	Refactoring: Renaming module "cms/publish" to "cms/generator"
Sat, 29 Aug 2020 03:23:06 +0200	Jan Dankert	Refactoring: Improved Exception-Handling; New: Generating pages using a page context which considers page aliases.
Sun, 23 Feb 2020 04:49:34 +0100	Jan Dankert	Refactoring with Namespaces for the cms modules, part 2.
Sun, 23 Feb 2020 04:01:30 +0100	Jan Dankert	Refactoring with Namespaces for the cms modules, part 1: moving.