<?php

namespace App\Typeahead;

use App\Models\User;
use Auth;
use DB;

class VenueTypeahead extends TypeaheadBuilder
{
    public function get($total = 10)
    {
        $query = User::where('type_id', 1)
            ->where('venue_name', 'LIKE', '%' . $this->search_string . '%');

        if ($this->exclude) {
            $query = $query->whereNotIn('id', $this->exclude);
        }

        $user = Auth::user();

        if ($this->connected_only == true) {
            if ($user->isVenue()) {
                $user_member_connections = [];
            } elseif ($user->isBand()) {
                $user_member_connections = DB::table('artist_venue_connections')->where('artist_id', $user->id)->pluck('venue_id');
            } elseif ($user->isFan()) {
                $user_member_connections = DB::table('fan_venue_connections')->where('fan_id', $user->id)->pluck('venue_id');
            } elseif ($user->isPromoter()) {
                $user_member_connections = DB::table('promoter_venue_connections')->where('promoter_id', $user->id)->pluck('venue_id');
            } else {
                $user_member_connections = [];
            }

            $query = $query->whereIn('id', $user_member_connections);
        }

        $this->data = $query->take($total)
            ->pluck('venue_name', 'id');

        return $this->output();
    }
}