Template.class.php

gehe zur Dokumentation dieser Datei

<?php
// ---------------------------------------------------------------------------
// $Id$
// ---------------------------------------------------------------------------
// OpenRat Content Management System
// Copyright (C) 2002 Jan Dankert, jandankert@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.
// ---------------------------------------------------------------------------
// $Log$
// Revision 1.16  2009-04-20 23:24:36  dankert
// Überflüssiges load() in mimeType() entfernt.
//
// Revision 1.15  2007-11-24 14:18:12  dankert
// MimeType in Template ermitteln.
//
// Revision 1.14  2007-11-07 23:29:05  dankert
// Wenn Seite direkt aufgerufen wird, dann sofort Seitenelement anzeigen.
//
// Revision 1.13  2007-10-10 19:08:55  dankert
// Beim Hinzuf?gen von Vorlagen das Kopieren einer anderen Vorlage erlauben. Korrektur beim L?schen von Vorlagen.
//
// Revision 1.12  2006-01-29 17:27:27  dankert
// Methode addElement() mit 2 weiteren Parametern
//
// Revision 1.11  2004/12/30 23:31:52  dankert
// Werte vorbelegen
//
// Revision 1.10  2004/12/30 23:23:21  dankert
// Werte vorbelegen
//
// Revision 1.9  2004/12/27 23:34:20  dankert
// Korrektur add()
//
// Revision 1.8  2004/12/26 01:06:31  dankert
// Perfomanceverbesserung Seite/Elemente
//
// Revision 1.7  2004/12/19 15:23:56  dankert
// Anpassung Session-Funktionen
//
// Revision 1.6  2004/12/18 00:37:50  dankert
// Projekt aus Session lesen
//
// Revision 1.5  2004/12/15 23:16:26  dankert
// Anpassung an Session-Funktionen
//
// Revision 1.4  2004/09/30 20:20:54  dankert
// Beim Speichern Sicherstellen, dass ein Name vorhanden ist
//
// Revision 1.3  2004/05/02 14:41:31  dankert
// Einf?gen package-name (@package)
//
// Revision 1.2  2004/04/25 17:31:46  dankert
// Bei L?schen auch Elemente entfernen
//
// Revision 1.1  2004/04/24 15:15:12  dankert
// Initiale Version
//
// ---------------------------------------------------------------------------


class Template
{
     var $templateid = 0;

     var $projectid = 0;

     var $name = 'unnamed';
     
     var $modelid = 0;

     var $extension='';

     var $src='';
     
     // Konstruktor
     function Template( $templateid='' )
     {
          $model   = Session::getProjectModel();
          $project = Session::getProject();
          $this->modelid   = $model->modelid;
          $this->projectid = $project->projectid;

          if   ( is_numeric($templateid) )
               $this->templateid = $templateid;
     }


     function getAll()
     {
          global $SESS;
          $db = db_connection();

          $sql = new Sql( 'SELECT id,name FROM {t_template}'.
                          ' WHERE projectid={projectid}'.
                          ' ORDER BY name ASC '  );
          if   ( isset($this->projectid) )
               $sql->setInt( 'projectid',$this->projectid   );
          else
          {
               $project = Session::getProject();
               $sql->setInt( 'projectid',$project->projectid );
          }

          return $db->getAssoc( $sql->query );
     }


     function load()
     {
          global $SESS;
          $db = db_connection();

          $sql = new Sql( 'SELECT * FROM {t_template}'.
                          ' WHERE id={templateid}' );
          $sql->setInt( 'templateid',$this->templateid );
          $row = $db->getRow( $sql->query );

          $this->name      = $row['name'     ];
          $this->projectid = $row['projectid'];

          $sql = new Sql( 'SELECT * FROM {t_templatemodel}'.
                          ' WHERE templateid={templateid}'.
                          '   AND projectmodelid={modelid}' );
          $sql->setInt( 'templateid',$this->templateid );
          $sql->setInt( 'modelid'   ,$this->modelid    );
          $row = $db->getRow( $sql->query );

          if   ( isset($row['extension']) )
          {
               $this->extension = $row['extension'];
               $this->src       = $row['text'];
          }
          
     }


     function save()
     {
          if   ( $this->name == "" )
               $this->name = lang('GLOBAL_TEMPLATE').' #'.$this->templateid;

          $db = db_connection();

          $sql = new Sql( 'UPDATE {t_template}'.
                          '  SET name={name}'.
                          '  WHERE id={templateid}' );
          $sql->setString( 'name'      ,$this->name       );
          $sql->setInt   ( 'templateid',$this->templateid );
          $db->query( $sql->query );

          $sql = new Sql( 'SELECT COUNT(*) FROM {t_templatemodel}'.
                          ' WHERE templateid={templateid}'.
                          '   AND projectmodelid={modelid}' );
          $sql->setInt   ( 'templateid'    ,$this->templateid     );
          $sql->setInt   ( 'modelid'       ,$this->modelid );

          if   ( intval($db->getOne($sql->query)) > 0 )
          {         
               $sql = new Sql( 'UPDATE {t_templatemodel}'.
                               '  SET extension={extension},'.
                               '      text={src} '.
                               ' WHERE templateid={templateid}'.
                               '   AND projectmodelid={modelid}' );
          }
          else
          {
               $sql = new Sql('SELECT MAX(id) FROM {t_templatemodel}');
               $nextid = intval($db->getOne($sql->query))+1;
               $sql = new Sql( 'INSERT INTO {t_templatemodel}'.
                               '        (id,templateid,projectmodelid,extension,text) '.
                               ' VALUES ({id},{templateid},{modelid},{extension},{src}) ');
               $sql->setInt   ( 'id',$nextid         );
          }

          $sql->setString( 'extension'     ,$this->extension      );
          $sql->setString( 'src'           ,$this->src            );
          $sql->setInt   ( 'templateid'    ,$this->templateid     );
          $sql->setInt   ( 'modelid'       ,$this->modelid        );
          
          $db->query( $sql->query );
     }


     function getTemplateIdsByValue( $text )
     {
          $db = db_connection();

          $sql = new Sql( 'SELECT templateid FROM {t_templatemodel}'.
                          ' WHERE text LIKE {text} '.
                          '   AND projectmodelid={modelid}' );

          $sql->setInt   ( 'modelid',$this->modelid );
          $sql->setString( 'text'   ,'%'.$text.'%'  );
          
          return $db->getCol( $sql->query );
     }


     function getElementIds()
     {
          $db = db_connection();

          $sql = new Sql( 'SELECT id FROM {t_element}'.
                          '  WHERE templateid={templateid}'.
                          '  ORDER BY name ASC' );
          $sql->setInt( 'templateid',$this->templateid );
          return $db->getCol( $sql->query );
     }



     function getElements()
     {
          $list = array();
          $db = db_connection();

          $sql = new Sql( 'SELECT * FROM {t_element}'.
                          '  WHERE templateid={templateid}'.
                          '  ORDER BY name ASC' );
          $sql->setInt( 'templateid',$this->templateid );
          foreach( $db->getAll( $sql->query ) as $row )
          {
               $e = new Element( $row['id'] );
               $e->setDatabaseRow( $row );
               
               $list[$e->elementid] = $e;
               unset($e);
          }
          return $list;
     }



     function getWritableElements()
     {
          $list = array();
          $db = db_connection();

          $sql = new Sql( <<<SQL
SELECT * FROM {t_element}
  WHERE templateid={templateid}
    AND writable=1
    AND type NOT IN ({readonlyList})
  ORDER BY name ASC
SQL
);
          $sql->setInt       ( 'templateid'  ,$this->templateid        );
          $e = new Element();
          $sql->setStringList( 'readonlyList',$e->readonlyElementNames );
          foreach( $db->getAll( $sql->query ) as $row )
          {
               $e = new Element( $row['id'] );
               $e->setDatabaseRow( $row );
               
               $list[$e->elementid] = $e;
               unset($e);
          }
          return $list;
     }



     function getElementNames()
     {
          $db = db_connection();

          $sql = new Sql( 'SELECT id,name FROM {t_element}'.
                          '  WHERE templateid={templateid}'.
                          '  ORDER BY name ASC' );
          $sql->setInt( 'templateid',$this->templateid );

          return $db->getAssoc( $sql->query );
     }


     function addElement( $name,$description='',$type='text' )
     {
          $element = new Element();
          $element->name       = $name;
          $element->desc       = $description;
          $element->type       = $type;
          $element->templateid = $this->templateid;
          $element->wiki       = true;
          $element->writable   = true;
          $element->add();
     }


     function add( $name='' )
     {
          if   ( !empty($name) )
               $this->name = $name;

          $db = db_connection();

          $sql = new Sql('SELECT MAX(id) FROM {t_template}');
          $this->templateid = intval($db->getOne($sql->query))+1;

          $sql = new Sql( 'INSERT INTO {t_template}'.
                          ' (id,name,projectid)'.
                          ' VALUES({templateid},{name},{projectid})' );
          $sql->setInt   ('templateid',$this->templateid   );
          $sql->setString('name'      ,$name               );

          // Wenn Projektid nicht vorhanden, dann aus Session lesen
          if   ( !isset($this->projectid) || intval($this->projectid) == 0 )
          {
               $project = Session::getProject();
               $this->projectid = $project->projectid;
          }

          $sql->setInt   ('projectid' ,$this->projectid );

          $db->query( $sql->query );
     }


     function getDependentObjectIds()
     {
          $db = db_connection();

          $sql = new Sql( 'SELECT objectid FROM {t_page}'.
                          '  WHERE templateid={templateid}' );
          $sql->setInt( 'templateid',$this->templateid );

          return $db->getCol( $sql->query );
     }


     function delete()
     {
          $db = db_connection();
          
          foreach( $this->getElementIds() as $elementid )
          {
               $element = new Element( $elementid );
               $element->delete();
          }

          $sql = new Sql( 'DELETE FROM {t_templatemodel}'.
                          ' WHERE templateid={templateid}' );
          $sql->setInt( 'templateid',$this->templateid );
          $db->query( $sql->query );

          $sql = new Sql( 'DELETE FROM {t_template}'.
                          ' WHERE id={templateid}' );
          $sql->setInt( 'templateid',$this->templateid );
          $db->query( $sql->query );
     }
     
     
     function mimeType()
     {
          global $conf;
          $mime_types = $conf['mime-types'];

          $extension = strtolower($this->extension);

          if   ( !empty($mime_types[$extension]) )
               $this->mime_type = $mime_types[$extension];
          else
               // Wenn kein Mime-Type gefunden, dann Standartwert setzen
               $this->mime_type = 'application/octet-stream';
               
          return( $this->mime_type );
     }
     
}

?>