/**
* 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;
}
/**
* Gets user roles by User ID.
*
* @access public
* @param integer $userId User ID
*
* @return array Result
*/
public function getUserRoles($userId)
{
$roles = array();
try {
$query = '
SELECT
`pr_roles`.`name` as `role`
FROM
`pr_users`
INNER JOIN
`pr_roles`
ON `pr_users`.`role_id` = `pr_roles`.`id`
WHERE
`pr_users`.`id` = :user_id
';
$statement = $this->db->prepare($query);
$statement->bindValue('user_id', $userId, \PDO::PARAM_INT);
$statement->execute();
$result = $statement->fetchAll(\PDO::FETCH_ASSOC);
if ($result && count($result)) {
$result = current($result);
$roles[] = $result['role'];
}
return $roles;
} catch (\PDOException $e) {
return $roles;
}
}
/**
* Gets user roles by User ID.
*
* @access public
* @param integer $userId User ID
*
* @return array Result
*/
public function getUserRoles($userId)
{
$roles = array();
try {
$query = '
SELECT
roles.name as role
FROM
users
INNER JOIN
roles
ON
users.id_role = roles.id
WHERE
users.id = :user_id
';
$statement = $this->db->prepare($query);
$statement->bindValue('user_id', $userId, \PDO::PARAM_INT);
$statement->execute();
$result = $statement->fetchAll(\PDO::FETCH_ASSOC);
if ($result && count($result)) {
$result = current($result);
$roles[] = $result['role'];
}
return $roles;
} catch (\PDOException $e) {
return $roles;
}
}
/**
* Get photos in HOME.
*
* @access public
* @return array Result
*/
public function getMainGallery()
{
$query = 'SELECT id, name FROM pr_gallery WHERE main = 1';
$statement = $this->db->prepare($query);
$statement->execute();
$result = $statement->fetchAll(\PDO::FETCH_ASSOC);
return !$result ? array() : $result;
}
/**
* Gets all albums.
*
* @access public
* @return array Result
*/
public function getAll()
{
$query = '
SELECT
comments.id, comments.comment, comments.user_id, users.login
FROM
comments
INNER JOIN
users
ON
comments.user_id=users.id
ORDER BY
comments.data DESC;
';
$result = $this->db->fetchAll($query);
return !$result ? array() : $result;
}
/**
* Checks if filename is unique.
*
* @access protected
* @param string $name Name
* @return bool Result
*/
protected function isUniqueName($name)
{
try {
$query = '
SELECT
COUNT(*) AS files_count
FROM
files
WHERE
name = :name
';
$statement = $this->db->prepare($query);
$statement->bindValue('name', $name, \PDO::PARAM_STR);
$statement->execute();
$result = $statement->fetchAll(\PDO::FETCH_ASSOC);
$result = current($result);
return !$result['files_count'];
} catch (\PDOException $e) {
throw $e;
}
}
/**
* Delete photo
*
* @access public
* @param integer $id Record Id
* @retun mixed Result
*/
public function deletePhoto($id)
{
$id = $id;
$sql = 'DELETE FROM kla_photos WHERE id = ?';
$this->db->executeQuery($sql, array((int) $id));
}
/**
* Delete photo.
*
* @access public
* @param integer $id Photo id
* @retun mixed Result
*/
public function delete($id)
{
return $this->db->delete('pr_gallery', array('id' => $id));
}
/**
* Delete reservation.
*
* @access public
* @param integer $id Reservation id
* @retun mixed Result
*/
public function delete($id)
{
if (isset($id) && $id != '' && ctype_digit((string) $id)) {
return $this->db->delete('pr_reservations', array('id' => $id));
}
}
/**
* Add worker.
*
* @access public
* @param Silex\Application $app Silex application
* @param array $data Worker data
* @retun mixed Result
*/
public function add($app, $data)
{
$data['role_id'] = 2;
$data['password'] = $app['security.encoder.digest']->encodePassword($data['password'], '');
return $this->db->insert('pr_users', $data);
}
/**
* Delete customer.
*
* @access public
* @param integer $id Customer id
* @retun mixed Result
*/
public function delete($id)
{
$this->db->delete('pr_reservations', array('customer_id' => $id));
$this->db->delete('pr_customers', array('id' => $id));
return true;
}
