maurobonfietti / api-rest-slimphp

     * @return array

     * @throws \Exception

     */

    public function searchTasks($tasksName)

    {

        $repository = new TaskRepository;

        $query = $repository->searchTasksQuery();

        $statement = $this->database->prepare($query);

        $query = '%' . $tasksName . '%';

        $statement->bindParam('query', $query);

        $statement->execute();

        $tasks = $statement->fetchAll();

        if (!$tasks) {

            throw new \Exception(MessageService::TASK_NOT_FOUND, 404);

        }

        return $tasks;

    }

    /**

     * Create a task.

     * @return array

     * @throws \Exception

     */

    public function searchUsers($str)

    {

        $repo = new UserRepository;

        $stmt = $this->database->prepare($repo->searchUsersQuery());

        $name = '%' . $str . '%';

        $stmt->bindParam('name', $name);

        $stmt->execute();

        $users = $stmt->fetchAll();

        if (!$users) {

            throw new \Exception(MessageService::USER_NAME_NOT_FOUND, 404);

        }

        return $users;

    }

    /**

     * Create a user.