Language.class.php

gehe zur Dokumentation dieser Datei

<?php
// ---------------------------------------------------------------------------
// $Id$
// ---------------------------------------------------------------------------
// OpenRat Content Management System
// Copyright (C) 2002-2004 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.
// ---------------------------------------------------------------------------


class Language
{
     var $languageid = 0;
     var $error      = '';
     var $projectid;

     var $name      = '';
     var $isoCode   = '';
     var $isDefault = false;


     // Konstruktor
     function Language( $languageid='' )
     {
          global $SESS;

          if   ( is_numeric($languageid) )
               $this->languageid = $languageid;

//        $this->projectid = $SESS['projectid'];
     }

     
     
     function available( $id )
     {
          $db = db_connection();

          $sql = new Sql('SELECT 1 FROM {t_language} '.
                         ' WHERE id={id}');
          $sql->setInt('id' ,$id  );

          return intval($db->getOne($sql->query)) == 1;
     }

     

     // Lesen aller Sprachen aus der Datenbank
     function getAll()
     {
          global $SESS;
          $db = db_connection();

          $sql = new Sql( "SELECT id,name FROM {t_language} ".
                          "   WHERE projectid = {projectid} ".
                          "   ORDER BY name" );

          if   ( !empty($this->projectid) )
               $sql->setInt('projectid',$this->projectid );
          else
          {
               $project = Session::getProject();
               $sql->setInt('projectid',$project->projectid);
          }

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


     // Lesen aus der Datenbank
     function load()
     {
          $db = Session::getDatabase();

          $sql = new Sql( 'SELECT * FROM {t_language}'.
                          ' WHERE id={languageid}' );
          $sql->setInt( 'languageid',$this->languageid );

          $row = $db->getRow( $sql->query );

          $this->name      =         $row['name'     ];
          $this->isoCode   =         $row['isocode'  ];
          $this->projectid = intval( $row['projectid'] );
          
          $this->isDefault = ( $row['is_default'] == '1' );
     }


     // Speichern der Sprache in der Datenbank
     function save()
     {
          $db = db_connection();

          // Gruppe speichern      
          $sql = new Sql( 'UPDATE {t_language} '.
                          'SET name      = {name}, '.
                          '    isocode   = {isocode} '.
                          'WHERE id={languageid}' );
          $sql->setString( 'name'     ,$this->name    );
          $sql->setString( 'isocode'  ,$this->isoCode );

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

          // Datenbankabfrage ausfuehren
          $db->query( $sql->query );
     }


     function getProperties()
     {
          return Array( 'name'   =>$this->name,
                        'isocode'=>$this->isoCode );
     }


     function add( $isocode='' )
     {
          global $SESS;
          global $iso;
          $db = db_connection();

          if   ( $isocode != '' )
          {
               // Kleiner Trick, damit "no" (Norwegen) in der .ini-Datei stehen kann
               $isocode = str_replace('_','',$isocode);
               
               $this->isocode = $isocode;
               $codes = GlobalFunctions::getIsoCodes();
               $this->name    = $codes[ $isocode ];
          }

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

          // Sprache hinzuf?gen
          $sql = new Sql( 'INSERT INTO {t_language} '.
                          '(id,projectid,name,isocode,is_default) VALUES( {languageid},{projectid},{name},{isocode},0 )');
          $sql->setInt   ('languageid',$this->languageid );
          $sql->setInt   ('projectid' ,$this->projectid  );
          $sql->setString('name'      ,$this->name       );
          $sql->setString('isocode'   ,$this->isoCode    );

          // Datenbankbefehl ausfuehren
          $db->query( $sql->query );
     }


     // Diese Sprache als 'default' markieren.
     function setDefault()
     {
          global $SESS;
          $db = db_connection();

          // Zuerst alle auf nicht-Standard setzen
          $sql = new Sql( 'UPDATE {t_language} '.
                          '  SET is_default = 0 '.
                          '  WHERE projectid={projectid}' );
          $sql->setInt('projectid',$this->projectid );
          $db->query( $sql->query );
     
          // Jetzt die gew?nschte Sprachvariante auf Standard setzen
          $sql = new Sql( 'UPDATE {t_language} '.
                          '  SET is_default = 1 '.
                          '  WHERE id={languageid}' );
          $sql->setInt('languageid',$this->languageid );
          $db->query( $sql->query );
     }


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

          $sql = new Sql( 'SELECT id FROM {t_language} '.
                          '  WHERE projectid={projectid}'.
                          '   ORDER BY is_default DESC' );

          if   ( isset($this->projectid) )
               $sql->setInt('projectid',$this->projectid );
          else
          {
               $project = Session::getProject();
               $sql->setInt('projectid',$project->projectid);
          }
          
          return $db->getOne( $sql->query );
     }


     // Sprache entfernen
     function delete()
     {
          $db = db_connection();

          // Sprache l?schen
//        $sql = new Sql( 'SELECT COUNT(*) FROM {t_language} WHERE projectid={projectid}' );
//        $sql->setInt( 'projectid',$this->projectid );
//        $count = $db->getOne( $sql->query );
//        
//        // Nur l?schen, wenn es mindestens 2 Sprachen gibt
//        if   ( $count >= 2 )
//        {
               // Inhalte mit dieser Sprache l?schen
               $sql = new Sql( 'DELETE FROM {t_value} WHERE languageid={languageid}' );
               $sql->setInt( 'languageid',$this->languageid );
               $db->query( $sql->query );

               // Inhalte mit dieser Sprache l?schen
               $sql = new Sql( 'DELETE FROM {t_name} WHERE languageid={languageid}' );
               $sql->setInt( 'languageid',$this->languageid );
               $db->query( $sql->query );

               // Sprache l?schen
               $sql = new Sql( 'DELETE FROM {t_language} WHERE id={languageid}' );
               $sql->setInt( 'languageid',$this->languageid );
               $db->query( $sql->query );

               // Andere Sprache auf "Default" setzen
               $sql = new Sql( 'SELECT id FROM {t_language} WHERE projectid={projectid}' );
               $sql->setInt( 'projectid',$this->projectid );
               $new_default_languageid = $db->getOne( $sql->query );

               $sql = new Sql( 'UPDATE {t_language} SET is_default=1 WHERE id={languageid}' );
               $sql->setInt( 'languageid',$new_default_languageid );
               $db->query( $sql->query );
//        }
     }
}

?>