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');