Exemplo n.º 1
0
 public function getBackupList($offset = null, $limit = null)
 {
     $db = PearDatabase::getInstance();
     $query = 'SELECT * FROM vtiger_backup ORDER BY endtime DESC';
     if ($offset !== null) {
         $query .= " LIMIT {$offset}, {$limit}";
     }
     $result = $db->query($query);
     $return = [];
     $moduleName = 'Settings::BackUp';
     for ($i = 0; $i < $db->num_rows($result); $i++) {
         $return[] = ['id' => $db->query_result_raw($result, $i, 'id'), 'starttime' => $db->query_result_raw($result, $i, 'starttime'), 'endtime' => $db->query_result_raw($result, $i, 'endtime') != null ? $db->query_result_raw($result, $i, 'endtime') : '', 'filename' => $db->query_result_raw($result, $i, 'filename') . '.zip', 'status' => vtranslate(self::getStatusName($db->query_result_raw($result, $i, 'status')), $moduleName), 'backuptime' => Settings_BackUp_Module_Model::formatBackupTime($db->query_result_raw($result, $i, 'backuptime'))];
     }
     return $return;
 }