@php
 use App\Models\SongToPerformer;
 use App\Models\Songsubmission;
@endphp

@extends('layouts.front-layout')

@section('content')
    
    <section class="breadcrumb-panel">
        <ul class="breadcrumb">
            {!! $breadCrumb !!}
        </ul>
    </section>

    <section class="page-title">
        <h1>{{$title}}</h1>
    </section>

    <div class="content">

        <div clas="row">
            <div class="col-md-12">
                <form action="{{ route('artists') }}" method="get">
                        <div class="row">
                            <div class="col-md-3"></div>
                            <div class="col-md-6 form-group">
                                <select class="form-control custom-select" name="artist_id">
                                <option value="">Select Artist</option>
                                @foreach($artists as $artist)
                                    <option value="{{$artist->id}}" {{(request()->artist_id && request()->artist_id == $artist->id)?'selected="selected"':''}}>{{$artist->name}}</option>
                                @endforeach
                                </select>    
                            </div>
                            
                            <div class="col-md-3 form-group">
                                <input type="submit" class="btn search-btn" value="Search">
                                <input type="button" class="btn search-btn" value="Clear" onclick="window.location='{{url('/Artists')}}'">
                            </div>
                        </div>
                    </form>
            </div> 
        </div>

        <div class="row pt-5">

           <div class="col-md-12 suchi_patra_area">
           <ul class="p-0">
            @foreach($data as $data_index => $single_data)    
            @php
                $total_count_data = Songsubmission::join('songsubmission_to_performer as stp','stp.songsubmissionID','=','songsubmission.id')->join('performer as pf','pf.id','=','stp.performerID')->join('topic as t','songsubmission.topicID','=','t.id')->join('book as b','b.id','=','t.bookID')->where('stp.performerID',$single_data->id)->where('songsubmission.active','Y')->select('t.*')->orderBy('t.name','asc')->get();
            @endphp

            @if(count($total_count_data) > 0)
            <li>
                <a href="{{url('Artists/'.$single_data->id.'/?rd=0')}}">
                    {{$single_data->name}} ({{count($total_count_data)}})
                </a>
            </li>
            @endif
            
            @endforeach
            </ul>
            </div> 
        </div>
    </div>

@endsection