<?php

namespace App\Typeahead;

use App\Models\User;
use Auth;

class ArtistTypeahead extends TypeaheadBuilder
{
    public function get($total = 10)
    {
        $query = User::where('type_id', 2)
            ->where('artist_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 = DB::table('artist_venue_connections')->where('venue_id', $user->id)->pluck('artist_id');
            } elseif ($user->isBand()) {
                $preliminary_user_member_connections = DB::table('fan_fan_connections')->select('artist1_id', 'artist2_id')->where('artist1_id', $user->id)->orWhere('artist2_id', $user->id)->get();

                $user_member_connections = [];

                foreach ($preliminary_user_member_connections as $key => $connection) {
                    if ($connection->artist1_id == $user->id) {
                        $user_member_connections[] = $connection->artist2_id;
                    } elseif ($connection->artist2_id == $user->id) {
                        $user_member_connections[] = $connection->artist1_id;
                    }
                }
            } elseif ($user->isFan()) {
                $user_member_connections = DB::table('fan_artist_connections')->where('fan_id', $user->id)->pluck('artist_id');
            } elseif ($user->isPromoter()) {
                $user_member_connections = DB::table('promoter_artist_connections')->where('promoter_id', $user->id)->pluck('artist_id');
            } else {
                $user_member_connections = [];
            }

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

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

        return $this->output();
    }
}