Criteria object for data gateway finder methods. Usage:
$criteria = new TSqlCriteria();
$criteria->Parameters[':name'] = 'admin';
$criteria->Parameters[':pass'] = 'prado';
$criteria->OrdersBy['level'] = 'desc';
$criteria->OrdersBy['name'] = 'asc';
$criteria->Limit = 10;
$criteria->Offset = 20;
/** * @param TSqlCriteria $criteria * @return integer number of records. */ public function count($criteria) { if ($criteria === null) { return (int) $this->getBuilder()->createCountCommand()->queryScalar(); } $where = $criteria->getCondition(); $parameters = $criteria->getParameters()->toArray(); $ordering = $criteria->getOrdersBy(); $limit = $criteria->getLimit(); $offset = $criteria->getOffset(); $command = $this->getBuilder()->createCountCommand($where, $parameters, $ordering, $limit, $offset); $this->onCreateCommand($command, $criteria); return $this->onExecuteCommand($command, (int) $command->queryScalar()); }