@extends('layouts.report')
@section('styles')
<link href="{{ asset('/assets/vendors/css/extensions/datedropper.min.css')}}" rel="stylesheet" type="text/css" />
<link href="{{ asset('/assets/vendors/css/forms/selects/selectize.css')}}" rel="stylesheet" type="text/css" />
<link href="{{ asset('/assets/vendors/css/forms/selects/selectize.default.css')}}" rel="stylesheet" type="text/css" />
<link href="{{ asset('assets/css/plugins/forms/selectize/selectize.css')}}" rel="stylesheet" type="text/css" />
<link href="{{ asset('/assets/vendors/css/typeahead/typeahead.css')}}" rel="stylesheet" type="text/css" />

<style type="text/css" media="print">
    @page{
        size: auto; /* auto is the initial value */
        margin: 5mm 5mm 5mm 10mm; /* this affects the margin in the printer settings */
    }
</style>
@endsection
 
@section('content') 
<div class="content-wrapper">
    <div class="content-body">
        <section class="horizontal-grid" id="horizontal-grid">
            <div class="row" id="serching_area"  >
                <div class="col-md-12">
                    <div class="card">
                        <div class="card-head ">
                            <div class="card-header">
                                <div class="text-center"><h3>Member Subscription Report</h3></div>
                            </div>
                        </div>  `
                        <div class="card-content collapse show">
                            <div class="card-body">
                                <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" >
                                    <tr>
                                        <td align="center" valign="top">
                                            <form name="frm_report" id="frm_report" action="{{route('report/member-subscription')}}" method="post">
                                                <input type="hidden" name="show_back" value="Y">
                                                <input type="hidden" name="show_export" value="N">
                                                <input type="hidden" name="show_print" value="Y">
                                                <input type="hidden" name="show_pdf" value="N">
                                                <input type="hidden" name="_token" value="{{csrf_token()}}">
                                                <input type="hidden" name="member_id" id="member_id" value="{{ isset($post['member_id']) ?  $post['member_id'] :''}}">
                                                <input type="hidden" name="display" id="display" value="HTML">
                                            <table width="98%" border="0" align="center" cellpadding="5" cellspacing="5" class="">   
                                                <tr>
                                                    <td width="20%" align="center" class="bmatter-big">&nbsp;</td>
                                                    <td width="80%" align="left" class="bmatter-big" valign="top">
                                                        <div class="form-body">   
                                                             <div class="form-group row mx-auto showTop">
                                                                <label class="col-md-2 label-control">Admission From Date </label>
                                                                <div class="col-md-3"> 
                                                                    <input class="form-control" placeholder="From Date" type="text" id="from_date" name="from_date" value="{{(isset($post['from_date']) ? date('d-m-Y',strtotime($post['from_date'])) : '')}}">
                                                                </div>
                                                                <button type="button" value="Close" onclick="return report_reset_date_filter('from_date');" id="reset" name="reset" class="btn btn-warning">
                                                                    <i class="ft-x"></i>
                                                                </button>
                                                                <label class="col-md-1  label-control">Admission To Date </label>
                                                                <div class="col-md-3"> 
                                                                    <input class="form-control" placeholder="To Date" type="text" id="to_date" name="to_date" value="{{(isset($post['to_date']) ? date('d-m-Y',strtotime($post['to_date'])) :'')}}">
                                                                </div>
                                                                <button type="button" value="Close" onclick="return report_reset_date_filter('to_date');" id="reset" name="reset" class="btn btn-warning">
                                                                    <i class="ft-x"></i>
                                                                </button>
                                                            </div>
                                                        </div>
                                                        <div class="form-body">   
                                                             <div class="form-group row mx-auto showTop">
                                                                <label class="col-md-2 label-control">Entry From Date </label>
                                                                <div class="col-md-3"> 
                                                                    <input class="form-control" placeholder="From Date" type="text" id="entry_from_date" name="entry_from_date" value="{{(isset($post['entry_from_date']) ? date('d-m-Y',strtotime($post['entry_from_date'])) : '')}}">
                                                                </div>
                                                                <button type="button" value="Close" onclick="return report_reset_date_filter('entry_from_date');" id="reset" name="reset" class="btn btn-warning">
                                                                    <i class="ft-x"></i>
                                                                </button>
                                                                <label class="col-md-1  label-control">Entry To Date </label>
                                                                <div class="col-md-3"> 
                                                                    <input class="form-control" placeholder="To Date" type="text" id="entry_to_date" name="entry_to_date" value="{{(isset($post['entry_to_date']) ? date('d-m-Y',strtotime($post['entry_to_date'])) :'')}}">
                                                                </div>
                                                                <button type="button" value="Close" onclick="return report_reset_date_filter('entry_to_date');" id="reset" name="reset" class="btn btn-warning">
                                                                    <i class="ft-x"></i>
                                                                </button>
                                                            </div>
                                                        </div>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td width="20%" align="center" class="bmatter-big">&nbsp;</td>
                                                    <td width="80%" align="left" class="bmatter-big" valign="top">
                                                        <div class="form-body">   
                                                             <div class="form-group row mx-auto showTop">
                                                                <label class="col-md-2 label-control">Course</label>
                                                                <div class="col-md-7"> 
                                                                     <select name="course_id" id="course_id" class="selectize-select">
                                                                     <option value="">Select Course</option> 
                                                                     @if(!empty($course))
                                                                        @foreach ($course as $ckey => $cval)
                                                                            <option value="{{ $cval['id'] }}"  {{ (isset($post['course_id']) && $post['course_id'] == $cval['id'] ? "selected" : "") }}  >{{ $cval['course_full_name']}}  </option>
                                                                        @endforeach
                                                                     @endif  
                                                                    </select>
                                                                </div>
                                                            </div>
                                                        </div>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td width="20%" align="center" class="bmatter-big">&nbsp;</td>
                                                    <td width="80%" align="left" class="bmatter-big" valign="top">
                                                        <div class="form-body">   
                                                             <div class="form-group row mx-auto showTop">
                                                                <label class="col-md-2 label-control">Plan</label>
                                                                <div class="col-md-7"> 
                                                                     <select name="plan_id" id="plan_id" class="selectize-select">
                                                                     <option value="">Select Plan</option> 
                                                                     @if(!empty($plan_data))
                                                                        @foreach ($plan_data as $pkey => $pval)
                                                                            <option value="{{ $pval['id'] }}"  {{ (isset($post['plan_id']) && $post['plan_id'] == $pval['id'] ? "selected" : "") }}  >{{ $pval['title']}}  </option>
                                                                        @endforeach
                                                                     @endif  
                                                                    </select>
                                                                </div>
                                                            </div>
                                                        </div>
                                                    </td>
                                                </tr>
                                                
                                                
                                                <tr>
                                                    <td width="20%" align="center" class="bmatter-big">&nbsp;</td>
                                                    <td width="80%" align="left" class="bmatter-big" valign="top">
                                                        <div class="form-body">   
                                                             <div class="form-group row mx-auto showTop">
                                                                <label class="col-md-2 label-control">Admission Status</label>
                                                                <div class="col-md-7"> 
                                                                     <select name="plan_status" id="plan_status" class="selectize-select">
                                                                     <option value="">Select Status</option> 
                                                                     @if(!empty($plan_staus_arr))
                                                                        @foreach ($plan_staus_arr as $pskey => $psval)
                                                                            <option value="{{ $pskey }}"  {{ (isset($post['plan_status']) && $post['plan_status'] == $pskey ? "selected" : "") }}  >{{ $psval }}  </option>
                                                                        @endforeach
                                                                     @endif  
                                                                    </select>
                                                                </div>
                                                            </div>
                                                        </div>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td width="20%" align="center" class="bmatter-big">&nbsp;</td>
                                                    <td width="80%" align="left" class="bmatter-big" valign="top">
                                                        <div class="form-body">   
                                                             <div class="form-group row mx-auto showTop">
                                                                <label class="col-md-2 label-control">Admission Id</label>
                                                                <div class="col-md-3"> 
                                                                    <input class="form-control" placeholder="Admission Id" type="text" id="admission_id" name="admission_id" value="{{(isset($post['admission_id']) ?  $post['admission_id'] : '')}}">
                                                                </div>
                                                                <label class="col-md-1  label-control">Member Name </label>
                                                                <div class="col-md-3"> 
                                                                    <input class="form-control" placeholder="Member Name" type="text" id="member_name" name="member_name" value="{{(isset($post['member_name']) ?  $post['member_name'] :'')}}">
                                                                </div>
                                                            </div>
                                                        </div>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td width="20%" align="center" class="bmatter-big">&nbsp;</td>
                                                    <td width="80%" align="center" class="bmatter-big" valign="top">
                                                        <div class="form-body">   
                                                             <div class="form-group row mx-auto showTop">
                                                                <label class="col-md-2 label-control"></label>
                                                                <div class="col-md-6">
                                                                    <button type="button" onclick="submitForm()" value="Show" id="btnShow"  name="btnShow" class="btn mr-1">
                                                                    <i class="la la-check-square-o"></i> Show
                                                                    </button>
                                                                    <button type="button" value="Close" onclick="window.close();" id="btnSave" name="btnSave" class="btn btn-success">
                                                                    <i class="ft-x"></i> Close
                                                                    </button>
                                                                    <button type="button" value="Close" onclick="return report_reset_filter();" id="reset" name="reset" class="btn btn-warning">
                                                                    <i class="ft-x"></i> Reset
                                                                    </button>
                                                                </div>
                                                            </div>
                                                        </div>
                                                    </td>
                                                </tr>
                                            </table>
                                            </form>
                                        </td>
                                    </tr>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>

    </div>
</div>
@if(!empty($post))
<div id="searched_result">
    <div class="row">
        <div class="col-md-12">
            <div class="card pdfdata">
                <div class="card-head ">
                    <div class="card-header">
                        @include('admin/includes/top_report')
                            <div class="text-center"><h3>Member Subscription Report</h3></div>
                        @if(isset($post['from_date']) && $post['from_date']!='' && isset($post['to_date']) && $post['to_date']!='')
                            <div class="text-center"><h5>From {{date('d-m-Y',strtotime($post['from_date']))}} To {{date('d-m-Y',strtotime($post['to_date']))}}</h5></div>
                        @endif
                    </div>
                </div>
                <div class="card-content collapse show">
                    <div class="card-body">
                        <table width="100%" style="border-collapse: inherit; border: 0;" border="1" class="listing-table" align="left" cellpadding="5" cellspacing="0">
                            <tr class="rawheader">
                                <th width="3%" class="brd-bottom mid">#</th>
                                <th width="2%" class="brd-bottom mid">Admission <br/>Id</th>
                                <th width="20%" class="brd-bottom left">Member Name </th>
                                <th width="20%" class="brd-bottom left"> Plan Name</th> 
                                <th width="5%" class="brd-bottom right"> Amount </th>
                                <th width="5%" class="brd-bottom right"> Tax</th>
                                <th width="5%" class="brd-bottom right"> Total</th>
                                <th width="10%" class="brd-bottom mid"> Status</th>
                                <th width="15%" class="brd-bottom mid"> Admission Date</th>
                                <th width="15%" class="brd-bottom mid"> Entry Date</th>
                            </tr>
                            @if (!empty($data))
                                @php $cnt = count($data); @endphp 
                                <input type="hidden" name="recordsCount" id="recordsCount" value="{{$cnt}}">
                                @for($i = 0; $i < $cnt; $i++)
                                    @if($data[$i]['plan_name'] !='')
                                    <tr class="{{($i%2==0)?'evenrowbg':'oddrowbg'}}">
                                        <td width="3%" valign="top" class="bmatter mid">{{$i+1}}</td>
                                        <td width="2%" valign="top" class="bmatter mid">{{isset($data[$i]['admission_id']) ? $data[$i]['admission_id'] : '1--' }}</td>
                                       
                                        <td width="20%" class="brd-bottom left">{{ isset($data[$i]['fullname']) ? $data[$i]['fullname'].'('.$data[$i]['mobile_number'].')' : '---' }} </td>
                                        <td width="20%" class="brd-bottom left"> {{ isset($data[$i]['plan_name']) ? $data[$i]['plan_name'] : '---' }} </td>
                                        <td width="5%" class="brd-bottom right">{{ isset($data[$i]['fees']) ? number_format((float)$data[$i]['fees'], 2, '.', '') : '0' }} </td>
                                        <td width="5%" class="brd-bottom right"> {{ isset($data[$i]['tax_amount']) ? number_format((float)$data[$i]['tax_amount'], 2, '.', '') : '0' }}</td>
                                        <td width="5%" class="brd-bottom right">{{ isset($data[$i]['total_fees']) ? number_format((float)$data[$i]['total_fees'], 2, '.', ''): '0' }}</td>
                                        <td width="10%" class="brd-bottom mid">
                                        @php  $status = ''; @endphp
                                        @if(isset($data[$i]['plan_status']))
                                            @if ($data[$i]['plan_status'] == '1')
                                               @php $status = 'Pending'; @endphp
                                            @elseif ($data[$i]['plan_status'] == '2')
                                               @php $status = 'Success'; @endphp
                                            @elseif ($data[$i]['plan_status'] == '3')
                                               @php $status = 'Progress'; @endphp
                                            @elseif ($data[$i]['plan_status'] == '4')
                                               @php $status = 'Failed'; @endphp
                                            @endif
                                         @endif
                                        {{ $status }}</td>
                                        <td  width="15%" class="brd-bottom mid">{{ isset($data[$i]['admission_date']) ? date_getDateTimeAll($data[$i]['admission_date']) : '---' }} </td>
                                        <td  width="15%" class="brd-bottom mid">{{ isset($data[$i]['created_at']) ? date_getDateTimeAll($data[$i]['created_at']) : '---' }} </td>
                                    </tr>
                                    @else
                                        <input type="hidden" name="recordsCount" id="recordsCount" value="0">
                                        <tr class="evenrowbg">
                                            <td colspan="10" class="bmatter mid">No Record Found!!</td>
                                        </tr>
                                    @endif
                                @endfor
                            @else
                                <input type="hidden" name="recordsCount" id="recordsCount" value="0">
                                <tr class="evenrowbg">
                                    <td colspan="14" class="bmatter mid">No Record Found!!</td>
                                </tr>
                            @endif
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endif
<button type="button" class="btn btn-outline-info block btn-lg d-none" id="popup_box" data-toggle="modal" data-target="#add_ip">Launch Modal</button>
<div class="modal fade text-left" id="add_ip" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true" data-focus-on="input:first" data-backdrop="static" data-keyboard="false">
    <div class="modal-dialog modal-xl" role="document">
        <div class="modal-content">
            <div class="modal-header bg-success white">
                <h3 class="modal-title white" id="myModalLabel"><span id="mode_title"></span> </h3>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
            </div>
            <div class="modal-body">
                <table width="100%" style="border-collapse: inherit; border: 0;" border="1" class="listing-table" align="left" cellpadding="5" cellspacing="0">
                    <thead>
                        <tr class="rawheader">
                            <th colspan="7" style="background: white; border: 0;" width="10%" class="brd-bottom mid"> </th>
                            <th colspan="3" width="10%" class="brd-bottom mid">Test</th>
                        </tr>
                        <tr class="rawheader">
                            <th width="1%">#</th>
                            <th width="3%" class="brd-bottom mid"> Module Name </th>
                            <th width="20%" class="brd-bottom mid"> Chapter Number </th>
                            <th width="15%" class="brd-bottom mid"> Topic Name </th>
                            <th width="15%" class="brd-bottom mid"> View Unique </th>
                            <th width="15%" class="brd-bottom mid"> View Total </th>
                            <th width="15%" class="brd-bottom mid"> Percentage video </th>
                            <th width="15%" class="brd-bottom mid">Attended Test</th>
                            <th width="15%" class="brd-bottom mid"> Result </th>
                            <th width="15%" class="brd-bottom mid"> Percentage </th>
                        </tr>
                    </thead>
                    <tbody class="member_list_body" id="member_list_body"></tbody>
                </table>
            </div>
            <div class="modal-footer">
                <button type="button" id="btn_close_modal" class="btn grey btn-outline-secondary" data-dismiss="modal">Close</button>
            </div>
        </div>
    </div>
</div>
@endsection
@section('scripts')
 
<!-- BEGIN typeahead -->
<script src="{{ asset('/assets/vendors/js/typeahead/handlebars.min.js')}}" type="text/javascript"></script>
<script src="{{ asset('/assets/vendors/js/typeahead/typeahead.bundle.min.js')}}" type="text/javascript"></script>
<!--  END typeahead -->
<script src="{{ asset('/assets/vendors/js/extensions/datedropper.min.js') }}" type="text/javascript"></script>
<script src="{{ asset('/assets/vendors/js/forms/select/selectize.min.js') }}" type="text/javascript"></script>
<script src="{{ asset('/assets/pages/scripts/admin/report/member_subscription.js?ver=1.2')}}" type="text/javascript"></script>
@endsection