Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /**
- * Content::getApparecchi()
- *
- * @return
- */
- public function getApparecchi()
- {
- $sort = sanitize(get('sort'));
- $access = '';
- $order = '';
- if (Registry::get("Users")->userlevel == 5) {
- $extra = ($sort) ? "AND" : "WHERE";
- $access = "$extra app.staff_id='" . Registry::get("Users")->uid . "'";
- $counter = countEntries("permissions", "staff_id", Registry::get("Users")->uid);
- } else {
- $counter = countEntries("apparecchi");
- }
- $pager = Paginator::instance();
- $pager->items_total = $counter;
- $pager->default_ipp = Registry::get("Core")->perpage;
- $pager->paginate();
- ($sort) ? $order = "WHERE app.client_id = '" . (int)$sort . "'" : null;
- $sql = "SELECT app.id as appid, u.id as uid, app.tipo_apparecchio, app.modello, app.seriale, app.marca_app,"
- . "\n CONCAT(u.fname,' ',u.lname) as clientname"
- . "\n FROM apparecchi as app"
- . "\n LEFT JOIN users as u ON u.id = app.client_id"
- . $pager->limit;
- $row = self::$db->fetch_all($sql);
- return ($row) ? $row : 0;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement