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