<?php

// Old version
$this->pager = new sfDoctrinePager('OrderItem', 20);
$this->addSortCriteria($this->pager->getQuery());
$this->addFiltersCriteria(
	$this->pager->getQuery()
		->from('OrderItem')
		->leftJoin('Member')
		->leftJoin('SubProgram')
		->leftJoin('P2MReseller')
		->where('reseller  = ?', 2)
);


// New version

$currentPage = 20;

$this->pager = new Doctrine_Pager(
	Doctrine_Query::create()
		->from('OrderItem')
		->leftJoin('Member')
		->leftJoin('SubProgram')
		->leftJoin('P2MReseller')
		->where('reseller = ?', 2)
	$currentPage
);

?>