public static function getAll($limit = 30, $offset = 0)
{
if (BaseAPI::isAuthorized() && BaseAPI::isValidRequestMethod('GET')) {
// redefine
$limit = (int) $limit;
$offset = (int) $offset;
// validate
if ($limit > 10000) {
return BaseAPI::output(BaseAPI::ERROR, array('message' => 'Limit can\'t be larger than 10000.'));
}
$forms = (array) BackendModel::getContainer()->get('database')->getRecords('SELECT i.id, i.language, i.name, i.method,
UNIX_TIMESTAMP(i.created_on) AS created_on,
UNIX_TIMESTAMP(i.edited_on) AS edited_on
FROM forms AS i
ORDER BY i.created_on DESC
LIMIT ?, ?', array($offset, $limit));
$return = array('forms' => null);
foreach ($forms as $row) {
$item['form'] = array();
// set attributes
$item['form']['@attributes']['id'] = $row['id'];
$item['form']['@attributes']['created_on'] = date('c', $row['created_on']);
$item['form']['@attributes']['language'] = $row['language'];
// set content
$item['form']['name'] = $row['name'];
$item['form']['method'] = $row['method'];
$return['forms'][] = $item;
}
return $return;
}
}