@include('links.header')
        <b>Entries Report</b>
        @if (Session::has('error'))
       <div class="alert alert-warning" role="alert">
           {{Session::get('error')}}
       </div>
  @endif
        <form method='post' action="{{ url('reports/entries_report') }}">
        @csrf
        <div class="row clearfix">
                <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                
                        <div class="panel-body">
                           
                            <div class="row clearfix cform">
                                <div class=" col-md-6 col-sm-6">
                                    <label class="form-label">You want to view report by Status : </label>
                                    <div class="form-group form-float">
                                        <div class="form-line">
                                            <select name="status" class="form-control" data-live-search='true'  required=''>
                                                <option value="0" >Select Status</option>
                                                <option value="1" >Drafted</option>
                                                <option value="2" >Submitted</option>
                                            </select>
                                        </div>
                                    </div>
                                </div>
                                <div class=" col-md-6 col-sm-6">
                                    <label class="form-label">You want to view question with answer : </label>
                                    <div class="form-group form-float">
                                        <div class="form-line">
                                            <select name="show_que_with_marks" class="form-control" data-live-search='true'  required=''>
                                                <option value="0" >Select response</option>
                                                <option value="1" >Yes</option>
                                                <option value="0" >No</option>
                                            </select>
                                        </div>
                                    </div>
                                </div>
                                
                                <div class=" col-md-4 col-sm-4">
                                    <div class="form-group form-float">
                                        <input type="submit" value="Generate Report" class="btn btn-primary"/>
                                    </div>
                                </div>
                            </div>
                            
                        </div>
                </div>
        </div>
        </form>
        <div class="table-responsive">
            <table class="table table-bordered table-striped table-hover" id="report_entry">
                <thead>
                    <tr>
                        <th>ID</th>
                        <th>Status</th>
                        <th>Creation Time</th>
                        <th>Entry Category</th>
                        <th>Entry Title</th>
                        <th>Entrant Company</th>
                        <th>Entrant Representative</th>
                        <th>Entrant Mobile</th>
                        <th>Entrant Email</th>
                        <th>Client Company</th>
                        <th>Client Representative</th>
                        <th>Endorser Email</th>
                        <th>Client Mobile</th>
                        <th>Brand</th>
                        <th>Campaign Period</th>
                        <th>Name of Nominee</th>
                        <th>Designation of Nominee</th>
                        <th>Organisation of Nominee</th>
                        <th>Email of Nominee</th>
                        <th>Mobile of Nominee</th>
                        <th>Name of Nominee 2</th>
                        <th>Designation of Nominee 2</th>
                        <th>Organisation of Nominee 2</th>
                        <th>Email of Nominee 2</th>
                        <th>Mobile of Nominee 2</th>
                        <th>Question-Answer</th>
                        <th>Microsite URL</th>
                        <th>Uploaded Files</th>                       
                        <th>Entrant Job Title</th>                        
                        <th>Entrant Address</th>
                        <th>Entrant Address - Country</th>
                        <th>Entrant Company Type</th>
                        <th>Endorsement Status</th>
                        <th>Order Id</th>
                        <th>Order Status</th>
                        <th>Order Payment Status</th>
                        <th>Order Payment Method</th>
                        <th>Entry Price</th>
                        <th>Order Creation Time</th>                        
                        <th>Order Internal Remark</th> 

                    </tr>
                </thead>
                <tbody>
                    @if(isset($entry_detail)>0)
                        @if(count($entry_detail) > 0)
                            @foreach($entry_detail as $entry)
                                <tr>

                                    <td>{{ $entry->entry_id  }}</td>
                                    <td>{{ $entry->status }}</td>
                                    <td>{{ $entry->created_at }}</td>
                                    <td>{{ $entry->category }}</td>
                                    <td>{{ $entry->title }}</td>
                                    <td>{{ $entry->entrant_company }}</td>
                                    <td>{{ $entry->entrant_representative }}</td>
                                    <td>{{ $entry->entrant_mobile }}</td>
                                    <td>{{ $entry->entrant_email }}</td>
                                    <td>{{ $entry->client_name }}</td>
                                    <td>{{ $entry->client_representative }}</td>
                                    <td>{{ $entry->client_email }}</td>
                                    <td>{{ $entry->client_mobile }}</td>
                                    <td>{{ $entry->brand }}</td>
                                    <td>{{ $entry->campaign_date }}</td>
                                    <td>{{ $entry->nominee_name_1 }}</td>
                                    <td>{{ $entry->nominee_title_1 }}</td>
                                    <td>{{ $entry->nominee_company_name_1 }}</td>
                                    <td>{{ $entry->nominee_email_1 }}</td>
                                    <td>{{ $entry->nominee_contact_1 }}</td>
                                    <td>{{ $entry->nominee_name_2 }}</td>
                                    <td>{{ $entry->nominee_title_2 }}</td>
                                    <td>{{ $entry->nominee_company_name_2 }}</td>
                                    <td>{{ $entry->nominee_email_2 }}</td>
                                    <td>{{ $entry->nominee_contact_2 }}</td>
                                    <td>@php if(!empty($entry->eventcategory_question)){$t=0;
                                    foreach($entry->eventcategory_question AS $question){ @endphp
                                    <strong>{{ $question }}</strong><br>
                                    {{ $entry->user_answer[$t]}}<br>
                                    @php $t++;} }
                                    @endphp </td>
                                    <td>@if(!empty($entry->microsite_weblink))
                                    @foreach($entry->microsite_weblink AS $weblink)
                                    <a href="{{ $weblink}}" target="_blank">{{ $weblink}}</a>
                                    @endforeach
                                    @endif
                                    </td>
                                    <td> 
                                    @if(!empty($entry->user_filename))
                                        @foreach($entry->user_filename as $val)
                                            @if(file_exists(storage_path('app/public/upload_entries/event_'.session('top_menu_event_id').'/entries_'.session('top_menu_event_id').'/'.$val->user_filename)))
                                                <a  href="{{ url('storage/upload_entries/event_'.session('top_menu_event_id').'/entries_'.session('top_menu_event_id').'/'.$val->user_filename) }}" target="_blank">View</a>
                                                <br>
                                            @endif
                                        @endforeach
                                    @endif
                                    </td>
                                    <td> {{ $entry->entrant_job_title }} </td>
                                    <td> {{ $entry->entrant_address}}</td>
                                    <td> {{ $entry->entrant_country}}</td>
                                    <td> {{ $entry->entrant_company_type}}</td>
                                    <td> {{ $entry->endorsement_status}}</td>
                                    <td> {{ $entry->order_id}}</td>
                                    <td> {{ $entry->order_status}}</td>
                                    <td> {{ $entry->payment_status}}</td>
                                    <td> {{ $entry->payment_method}}</td>
                                    <td> {{ $entry->entry_price}}</td>
                                    <td> {{ $entry->order_creation_time}}</td>
                                    <td> {{ $entry->remark_against_payment }}</td>
                                    
                                </tr>
                            @endforeach
                        @endif
                    @endif
                
                </tbody>
            </table>
        </div>
        <script>
            $(document).ready(function() {
                // $('#report_entrant').dataTable();
                $('#report_entry').DataTable({
                    dom: 'Bfrtip',
                    buttons: [
                         'excel', 'pdf', 'print'
                    ]
                });
            } );
        </script>
        
        @include('links.footer')