{% extends "@Admin/Layout/adminlayout.html.twig" %}
{% block content %}
    <section class="content-header">
        <!-------- PAGE TITLE --------------->
        <h1>
           Month-wise Revenue report
        </h1>
        <!------- BREADCUMB --------------------->
        <ol class="breadcrumb">
            <li><a href="{{path('admin_dashboard_index',{'domain':app.session.get('domain')})}}"><i class="fa fa-dashboard"></i> Dashboard</a></li>
        </ol>
    </section>
    <section class="content">
        {% for flashMessage in app.session.flashbag.get('success_msg') %}
            <div class="alert alert-success alert-dismissable">
                <button aria-hidden="true" data-dismiss="alert" class="close" type="button">×</button>
                <h4><i class="icon fa fa-check"></i> Alert!</h4>{{ flashMessage }}
            </div>
        {% endfor %}
        {% for flashMessage in app.session.flashbag.get('error_msg') %}
            <div class="alert alert-danger alert-dismissable">
                <button aria-hidden="true" data-dismiss="alert" class="close" type="button">×</button>
                <h4><i class="icon fa fa-check"></i> Alert!</h4>{{ flashMessage }}
            </div>
        {% endfor %}

        <div class="row">
           
                <section class="col-lg-12 ">
                    <div class="box box-success">
                        <div class="box-body">
                            <div class="row">
                                <div class="col-md-2"><label>Selected Month</label></div>
                                <div class="col-md-2">
                                    {{month}} , {{selected_year}}
                                </div>
                                <div class="col-md-4">
                                    <label>Total Revenue : </label> {{total_sales_cost}}
                                </div>
                               
                               
                            </div>
                        </div>
                    </div>
                </section>
            
        </div>
        
        <div class="form-group">
            <div class="table table-responsive">
                <table class="table example">
                    <thead>
                        <th>No</th>
                        <th>Customer</th>
                        <th>Mobile</th>
                        <th>Package</th>
                        <th>Package Date Range</th>
                        {#<th>Month Active Days</th>#}
                        <th>Package Amt</th>
                        <th>Purchase Amt</th>
                        {#<th>Revenue</th>#}
                        <th>Purchased at</th>
                        <th>Coupon Code</th>
                        
                    </thead>
                    <tbody>
                        {%if result_array is defined and result_array is not empty %}
                            {%for result_array in result_array %}
                                <tr>
                                <td>{{loop.index ? loop.index : ''}}</td>
                                <td>{{result_array.user_name}}</td>
                                <td>{{result_array.user_mobile}}</td>
                                <td>{{result_array.package_name}}</td>
                                <td>{{result_array.package_start_date}} to {{result_array.package_end_date}}</td>
                                {#<td>{{result_array.active_days}}</td>#}
                                <td>{{result_array.package_value}}</td>
                                <td>{{result_array.payment_amount}}</td>
                                {#<td>{{result_array.sales_cost}}</td>#}
                                <td>{{result_array.created_at}}</td>
                                <td>{{result_array.coupon_code}}</td>
                                </tr>
                            {%endfor%}
                        {%else%}
                            <tr><td colspan="8" class="text-center">No Records Found </td></tr>
                        {%endif%}
                        
                    </tbody>
                    <tfooter>
                        <th>No</th>
                        <th>Customer</th>
                        <th>Mobile</th>
                        <th>Package</th>
                        <th>Package Date Range</th>
                        {#<th>Month Active Days</th>#}
                        <th>Package Amt</th>
                        <th>Purchase Amt</th>
                        {#<th>Revenue</th>#}
                        <th>Purchased at</th>
                    </tfooter>
                </table>
            </div>
        </div>


    </section>
    <!----------- PAGE HEADER : END ----------------------------------------------------------->
    <!----------- Main content : START ----------------------------------------------------------->

{% endblock %}

{% block js %}
    <script src="{{asset('bundles/design/plugins/')}}ckeditor/ckeditor.js"></script>

    <script>
   
    $(document).ready(function() {
        $('.datepicker').datepicker({  format: 'yyyy-mm-dd' });
        {%if result_array is defined and result_array is not empty %}
        $('.example').DataTable( {
            dom: 'Bfrtip',
            buttons: [
                'copy', 'excel', 'pdf'
            ],
        } );
        {%endif%}
    });
    </script>	
{% endblock %}