/** * Gets news * * @access public * @return array Result */ public function getPost($id) { $query = 'SELECT kla_posts.id, title, content, date, author, name as photo, post_id, description FROM kla_posts LEFT JOIN kla_photos ON kla_posts.id = kla_photos.post_id WHERE kla_posts.id = ?'; $result = $this->db->fetchAssoc($query, array((int) $id)); return !$result ? array() : $result; }
/** * Gets event * * @access public * @return array Result */ public function getEvent($id) { $query = 'SELECT kla_events.id, kla_events.name, info, date, kla_types.name as type, kla_places.name as place FROM kla_events LEFT JOIN kla_types ON kla_events.type_id = kla_types.id LEFT JOIN kla_places On kla_events.place = kla_places.id WHERE kla_events.id = ?'; $result = $this->db->fetchAssoc($query, array((int) $id)); return !$result ? array() : $result; }
/** * Counts room pages. * * @access public * @param integer $limit Number of records on single page * @return integer Result */ public function countRoomsPages($limit) { $pagesCount = 0; $sql = 'SELECT COUNT(*) as pages_count FROM pr_rooms'; $result = $this->db->fetchAssoc($sql); if ($result) { $pagesCount = ceil($result['pages_count'] / $limit); } return $pagesCount; }
/** * Counts worker pages. * * @access public * @param integer $limit Number of records on single page * @return integer Result */ public function countWorkersPages($limit) { $pagesCount = 0; $sql = 'SELECT COUNT(*) as pages_count FROM pr_users WHERE role_id = 2'; $result = $this->db->fetchAssoc($sql); if ($result) { $pagesCount = ceil($result['pages_count'] / $limit); } return $pagesCount; }