<?php
Class Articles{
 private $db;
 private $lang;

 function __construct($lang){
  $this->db = sdb::getInstance();
  $this->lang = $lang;
 }
 

 public function getNews($param = array()){
  $search = array();
  $sql = "select *,title_{$this->lang} as title,text_{$this->lang} as text from articles where 1=1 ";
  if(count($search))$sql .= "AND " . implode(" AND ",$search)." ";
  $sql .= "order by date desc";
  $pagerOptions = Array(
    'mode' => 'Sliding',
    'delta' => 6,
    'perPage' => 10,
    'spacesBeforeSeparator' => 1,
    'spacesAfterSeparator' => 1
  );
  return Pager_Wrapper_DB($this->db, $sql, $pagerOptions, false, DB_FETCHMODE_ASSOC, array());
 }
 
 public function getLastNews($limit = 3){
  $sql = "select *,title_{$this->lang} as title,text_{$this->lang} as text from articles order by date desc limit $limit";
  return $this->db->getAll($sql,array(),DB_FETCHMODE_ASSOC);
 }
 
 public function view($id){
  $sql = "select *,title_{$this->lang} as title,meta_title_{$this->lang} as meta_title,meta_description_{$this->lang} as meta_description,meta_keywords_{$this->lang} as meta_keywords,meta_about_{$this->lang} as meta_about,text_{$this->lang} as text from articles where id=? limit 1";
  return $this->db->getRow($sql,array($id),DB_FETCHMODE_ASSOC);
 }
 
}
?>