/**
* 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;
}
/**
* Get all rooms.
*
* @access public
* @retun array Result
*/
public function getRooms()
{
$query = 'SELECT id as room_id, number
FROM pr_rooms';
$statement = $this->db->prepare($query);
$statement->execute();
$result = $statement->fetchAll(\PDO::FETCH_ASSOC);
return !$result ? array() : $result;
}
/**
* Checks if customer exists and if is not in usage
*
* @access public
* @param integer $id Customer id
* @retun integer Result
*/
public function security($id)
{
$query = 'SELECT id
FROM pr_customers
WHERE id = :id';
$statement = $this->db->prepare($query);
$statement->bindValue('id', $id, \PDO::PARAM_INT);
$statement->execute();
$result = $statement->fetchAll(\PDO::FETCH_ASSOC);
return !$result ? 0 : 1;
}
/**
* 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;
}
}
