/**
* List all owners ...
* @param $page The page number
* @param $count The number of count
* @param $detailed - Detailed view
*/
public function listAll($page, $count, $detailed = false)
{
$select = $this->getAdapter()->select();
$sql = $select->from($this->_name, array(new Zend_Db_Expr("SQL_CALC_FOUND_ROWS owner_id"), "first_name", "last_name", "website", "company", "email", "username", "activated", "credits", "owner_type", "timezone_id", "mobile", "approved", "deleted", "fullname_webmaster", "email_webmaster", "phone_webmaster", "date_created", "date_updated"))->joinInner(array("no" => "number_of_hits"), "no.id = owners.number_of_hit_id", array("no.name AS number_hits"))->order("date_created DESC");
if ($page != null && $count != null) {
$sql = $sql->limitPage($page, $count);
} else {
$sql = $sql->limitPage(1, 50);
}
$result = $this->getAdapter()->fetchAll($sql);
$appTimezone = new App_Timezone();
foreach ($result as $key => $value) {
if ($detailed) {
try {
$result[$key]["timezone"] = $appTimezone->find($value["timezone_id"])->getRow(0)->toArray();
} catch (Exception $e) {
$result[$key]["timezone"] = null;
}
}
if ($result[$key]["approved"] == "Y") {
$result[$key]["approved"] = 1;
} else {
$result[$key]["approved"] = 0;
}
}
return $result;
}
public function getAllTimezonesGrouped()
{
/**
* @var Zend_Db_Table_Rowset
*/
$timezoneGroups = $this->fetchAll();
$timezoneGroups = $timezoneGroups->toArray();
$timezone = new App_Timezone();
foreach ($timezoneGroups as $key => $timezoneGroup) {
$timezoneGroups[$key]["timezones"] = $timezone->fetchByTimezoneGroup($timezoneGroup["id"])->toArray();
}
return $timezoneGroups;
}
