/**
* 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;
}
