docs/include/classes/DAO/LangCodesDAO.class.php

   1 <?php
   2 /************************************************************************/
   3 /* AContent                                                             */
   4 /************************************************************************/
   5 /* Copyright (c) 2010                                                   */
   6 /* Inclusive Design Institute                                           */
   7 /*                                                                      */
   8 /* This program is free software. You can redistribute it and/or        */
   9 /* modify it under the terms of the GNU General Public License          */
  10 /* as published by the Free Software Foundation.                        */
  11 /************************************************************************/
  12
  13 /**
  14 * DAO for "lang_codes" table
  15 * @access       public
  16 * @author       Cindy Qi Li
  17 * @package      DAO
  18 */
  19
  20 if (!defined('TR_INCLUDE_PATH')) exit;
  21
  22 require_once(TR_INCLUDE_PATH. 'classes/DAO/DAO.class.php');
  23
  24 class LangCodesDAO extends DAO {
  25
  26         /**
  27         * Return all rows
  28         * @access  public
  29         * @param   none
  30         * @return  table rows
  31         * @author  Cindy Qi Li
  32         */
  33         public function GetAll()
  34         {
  35                 $sql = "SELECT * FROM ". TABLE_PREFIX ."lang_codes ORDER BY description";
  36
  37                 return $this->execute($sql);
  38         }
  39
  40         /**
  41         * Return lang code info of the given 2 letters code
  42         * @access  public
  43         * @param   $code : 2 letters code
  44         * @return  table rows
  45         * @author  Cindy Qi Li
  46         */
  47         public function GetLangCodeBy2LetterCode($code)
  48         {
  49                 $sql = "SELECT * FROM ". TABLE_PREFIX ."lang_codes
  50                                         WHERE code_2letters = '".$code ."'";
  51
  52                 return $this->execute($sql);
  53         }
  54
  55         /**
  56         * Return lang code info of the given 3 letters code
  57         * @access  public
  58         * @param   $code : 3 letters code
  59         * @return  table rows
  60         * @author  Cindy Qi Li
  61         */
  62         public function GetLangCodeBy3LetterCode($code)
  63         {
  64                 $sql = "SELECT * FROM ". TABLE_PREFIX ."lang_codes
  65                                         WHERE code_3letters = '".$code ."'";
  66
  67                 if ($rows = $this->execute($sql))
  68                 {
  69                         return $rows[0];
  70                 }
  71                 else
  72                         return false;
  73         }
  74
  75         /**
  76         * Return array of all the 2-letter & 3-letter language codes with given direction
  77         * @access  public
  78         * @param   $direction : 'rtl' or 'ltr'
  79         * @return  table rows
  80         * @author  Cindy Qi Li
  81         */
  82         public function GetLangCodeByDirection($direction)
  83         {
  84                 $rtn_array = array();
  85                 $sql = "SELECT * FROM ". TABLE_PREFIX ."lang_codes
  86                                         WHERE direction = '".$direction ."'";
  87
  88                 $rows = $this->execute($sql);
  89
  90                 if (is_array($rows))
  91                 {
  92                         foreach ($rows as $row)
  93                         {
  94                                 array_push($rtn_array, $row['code_3letters']);
  95                                 array_push($rtn_array, $row['code_2letters']);
  96                         }
  97                 }
  98                 return $rtn_array;
  99         }
 100
 101 }
 102 ?>