<?php
  class clPropelPagerI18n extends sfPropelPager {
    protected $culture = null;
    
    public function __construct($class, $maxPerPage = 10, $culture){
      $original_culture = sfPropel::getDefaultCulture();
      $this->culture = $culture;
      sfPropel::setDefaultCulture($culture);
      
      parent::__construct($class, $maxPerPage);
      $this->setPeerMethod('doSelectWithI18n');
      
      sfPropel::setDefaultCulture($original_culture);
    }
    
    public function getResults(){
      $original_culture = sfPropel::getDefaultCulture();
      sfPropel::setDefaultCulture($this->culture);
      $result_set = parent::getResults();
      sfPropel::setDefaultCulture($original_culture);
      return $result_set;
    }
  }    

  public static function retrievePropelPagerBySystem($system, $culture, $page_number, $objects_per_page=6)
  {
    $c = new Criteria();
    $c->addJoin(clCoreNewsPeer::NEWS_ID, clCoreNewsCoreGenericdataSystemPeer::CORE_GENERICDATA_SYSTEM_ID, Criteria::LEFT_JOIN);
    $c->add(clCoreNewsCoreGenericdataSystemPeer::CORE_GENERICDATA_SYSTEM_ID, $system, Criteria::EQUAL);
    $c->add(clCoreNewsPeer::NEWS_PUBLISH_AT, date('Y-m-d'), Criteria::LESS_EQUAL);
    $c->add(clCoreNewsPeer::NEWS_UNPUBLISH_AT, date('Y-m-d'), Criteria::GREATER_EQUAL);
    $c->add(clCoreNewsPeer::NEWS_STATUS, 1, Criteria::EQUAL);
    
    $pager = new clPropelPagerI18n('clCoreNews', $objects_per_page, $culture);
    $pager->setCriteria($c);
    $pager->setPage($page_number);
    $pager->init();
    
    return $pager;
  }

$c = new Criteria();
$culture_for_query=sfContext::getInstance()->getUser()->getCulture();
$c->add(NewsI18nPeer::CULTURE, $culture_for_query);
$max_per_page = 2;
$c->addJoin(NewsPeer::ID, NewsI18nPeer::ID);
$pager = new sfPropelPager('News', $max_per_page);
$pager->setCriteria($c);
$pager->setPage(sfContext::getInstance()->getRequest()->getParameter('page', 1));
$pager->init();