private function getBackupsList($time = '')
{
$data = array();
$time = $time == '' ? time() : strtotime($time);
$query = "\n SELECT b.id AS backupId, b.farm_id AS farmId, b.service AS serviceName, b.dtcreated AS time, f.name AS farmName\n FROM `services_db_backups` b\n LEFT JOIN `farms` f ON b.farm_id = f.id\n WHERE b.status = ? AND b.env_id = ?\n AND DATE_FORMAT(CONVERT_TZ(b.dtcreated, 'SYSTEM', ?), '%Y-%m') = ?\n ";
$userTimezone = $this->user->getSetting(Scalr_Account_User::SETTING_UI_TIMEZONE);
if (empty($userTimezone)) {
$userTimezone = 'SYSTEM';
}
$args = array(Scalr_Db_Backup::STATUS_AVAILABLE, $this->getEnvironmentId(), $userTimezone, date('Y-m', $time));
if ($this->getParam('farmId')) {
$query .= ' AND b.farm_id = ?';
$args[] = $this->getParam('farmId');
}
if (!$this->request->isAllowed(Acl::RESOURCE_FARMS, Acl::PERM_FARMS_NOT_OWNED_FARMS)) {
$query .= " AND f.created_by_id = ?";
$args[] = $this->user->getId();
}
$dbBackupResult = $this->db->GetAll($query, $args);
foreach ($dbBackupResult as $row) {
$dt = new DateTime($row['time']);
Scalr_Util_DateTime::convertTimeZone($dt, $this->user->getSetting(Scalr_Account_User::SETTING_UI_TIMEZONE));
$row['time'] = $dt->format('h:ia');
if (empty($row['farmName'])) {
$row['farmName'] = '*removed farm*';
}
$data[$dt->format('j M')][] = $row;
}
return $data;
}