function show_all($f3)
{
$orm = new DB\SQL\Mapper($f3->get('DB'), 'INGREDIENT_OVERVIEW');
$page = $f3->get('PARAMS.page');
$record_count = $orm->count();
$result_number = 20;
$page_count = ceil($record_count / $result_number);
if (!isset($page) || $page <= 0) {
$f3->reroute("/ainesosa/listaa/sivu/1");
} else {
if ($page > $page_count) {
$f3->reroute("/ainesosa/listaa/sivu/" . $page_count);
}
}
$page--;
$result = $orm->find(array(), array('limit' => $result_number, 'offset' => $page * $result_number));
$allergy_arr = array();
foreach ($result as $ingredient) {
$id = $ingredient->id;
$string_allergies = $ingredient->allergies;
$allergy_arr[$id] = array_filter(explode(',', trim($string_allergies)));
}
$f3->set('allergies', Allergy::map_to_id($f3));
$f3->set('result', $result);
$f3->set('page_count', $page_count);
$f3->set('cur_page', $page + 1);
$f3->set('allergy_arr', $allergy_arr);
$f3->set("content", "ingredient_list.htm");
$f3->set("title", "Ainesosat");
echo Template::instance()->render("layout.htm");
}
public function deleteShout($id)
{
$delete = new \DB\SQL\Mapper($this->db, $this->prefix . 'shoutbox');
if ($delete->count(["id = ?", $id]) == 0) {
return FALSE;
}
$delete->erase(["id = ?", $id]);
return TRUE;
}
$table->addColumn('crdate')->type_datetime();
$table->addColumn('lifetime')->type_datetime();
$table->addColumn('uuid')->type_varchar(30)->index(true);
$table->build();
echo "installed";
} else {
echo "already installed";
}
});
// stats and cleanup
$f3->route(array('GET @stats: /stats', 'GET @cleanup: /cleanup'), function (Base $f3, $params) {
$mapper = new \DB\SQL\Mapper($f3->get('DB'), $f3->get('db_table'));
if ($f3->get('ALIAS') == 'cleanup') {
$f3->set('cleanup', $mapper->erase(array('lifetime < ?', date('Y-m-d H:i:s'))));
}
$f3->set('all', $mapper->count());
$f3->set('old', $mapper->count(array('lifetime < ?', date('Y-m-d H:i:s'))));
$f3->set('sub_tmpl', 'stats.html');
echo \Template::instance()->render('layout.html');
});
// error handler
$f3->set('ONERROR', function (Base $f3) {
$error = $f3->get('ERROR');
while (ob_get_level()) {
ob_end_clean();
}
if ($f3->get('AJAX')) {
echo json_encode($error);
exit;
}
$f3->set('sub_tmpl', 'error.html');
