private function getFindSql(FocSearchCriteria $search = null)
{
$sql = 'SELECT username, email FROM Users';
$orderBy = 'username, email';
if ($search !== null) {
if ($search->getStatus() !== null) {
$sql .= 'AND status = ' . $this->getDb()->quote($search->getStatus());
// switch ($search->getStatus()) {
// case Users::STATUS_PENDING:
// $orderBy = 'username, email';
// break;
// case Users::STATUS_DONE:
// case Users::STATUS_VOIDED:
// $orderBy = 'username DESC, email';
// break;
// default:
// throw new Exception('No user for status: ' . $search->getStatus());
// }
}
}
$sql .= ' ORDER BY ' . $orderBy;
return $sql;
}
