{% extends '@App/base.html.twig' %}
{% block title %}
    Technicians
{% endblock %}
{% block body %}
    <div class="row">
        <div class="col-xs-12">
            <div class="widget">
                <div class="row">
                    <div class="col-xs-12">
                        {% include 'AppBundle:iService//Reporting:dateForm.html.twig' %}
                        <table id="table_reporting" class="table table-hover table-striped table-bordered text-center">
                            <thead>
                            <tr>
                                <th>TECHNICIAN</th>
                                <th># OF JOBS</th>
                                <th>ORIGINAL RO AMOUNTS</th>
                                <th>FINAL RO AMOUNTS</th>
                                <th>UPSELL AMOUNTS</th>
                                <th>UPSELL PERCENTAGE</th>
                                <th>TOTAL VIDEOS</th>
                                <th>GROSS/JOB w/VIDEO</th>
                                <th>GROSS/JOB w/o VIDEO</th>
                                <th>NO VIDEO JOBS</th>
                            </tr>
                            </thead>
                            <tfoot class="hidden">
                            <tr>
                                <th>technician</th>
                                <th># OF JOBS</th>
                                <th>ORIGINAL RO AMOUNTS</th>
                                <th>FINAL RO AMOUNTS</th>
                                <th>UPSELL AMOUNTS</th>
                                <th>UPSELL PERCENTAGE</th>
                                <th>TOTAL VIDEOS</th>
                                <th>GROSS/JOB w/VIDEO</th>
                                <th>GROSS/JOB w/o VIDEO</th>
                                <th>NO VIDEO JOBS</th>
                            </tr>
                            </tfoot>
                            <tbody id="jobsVideosTable">
                            {% for technician in technicians %}
                                <tr>
                                    <td>
                                        {% if technician['name'] == 'Any Technician' %}
                                            NO VIDEO
                                            {% if technician['videoless_repair_orders'] >= 1 %}
                                            <div class="btn-group">
                                                <div class="dropdown-menu"
                                                     style="width: 500px !important; max-height: 400px !important; overflow: scroll; ">
                                                    <table class="dropdown-item display" id="noVideoTable">
                                                        <thead>
                                                        <tr>
                                                            <th><b>Repair Order </b></th>
                                                            <th><b>Closed Date </b></th>
                                                        </tr>
                                                        </thead>
                                                        <tbody>
                                                        {% for noVideo in technician.noVideo %}
                                                            <tr>
                                                                <td>{{ noVideo.RepairOrder }}</td>
                                                                <td>{{ noVideo.closedDate|date('m/d/Y') }}</td>
                                                            </tr>
                                                        {% endfor %}
                                                        </tbody>
                                                    </table>
                                                </div>
                                                <button type="button" class="btn btn-info btn-raised dropdown-toggle"
                                                        data-toggle="dropdown" aria-haspopup="true"
                                                        aria-expanded="false">
                                                    <b>VIEW Repair Orders</b>
                                                    <div class="ripple-container"></div>
                                                    <div class="ripple-container"></div>
                                                </button>
                                            </div>
                                            {% endif %}
                                        {% else %}
                                            {{ technician['name'] }}
                                        {% endif %}
                                    </td>
                                    <td>{{ technician['total_repair_orders'] }}</td>
                                    <td>${{ technician['original_value'] }}</td>
                                    <td>${{ technician['final_value'] }}</td>
                                    <td>${{ technician['upsell_value'] }}</td>
                                    <td>{{ technician['upsell_percentage']|round(2, 'ceil') }}%</td>
                                    <td>{{ technician['total_videos'] }}</td>
                                    <td>{{ technician['gross_per_job_w_video'] | round(2, 'ceil') }}</td>
                                    <td>{{ technician['gross_per_job_wo_video'] | round(2, 'ceil') }}</td>
                                    <td>{{ technician['videoless_repair_orders'] }}</td>
                                </tr>
                            {% endfor %}
                            </tbody>
                        </table>
                        <br/><br/>
                        <div class="row text-center">
                            <div class="col-md-2">
                                <p><b>Total Number Jobs:</b></p>
                                <h3>{{ cumulative_repair_orders }}</h3>
                            </div>
                            <div class="col-md-2">
                                <p><b>Total Initial RO Value:</b></p>
                                <h3>${{ cumulative_original_value }}</h3>
                            </div>
                            <div class="col-md-2">
                                <p><b>Total Final RO Value:</b></p>
                                <h3>${{ cumulative_final_value }}</h3>
                            </div>
                            <div class="col-md-2">
                                <p><b>Total Upsell Amount:</b></p>
                                <h3>${{ cumulative_upsell_value }}</h3>
                            </div>
                            <div class="col-md-2">
                                <p><b>Total Upsell Percentage:</b></p>
                                <h3>{{ cumulative_upsell_percentage|round(2, 'ceil') }}%</h3>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <script type="text/javascript">
        $(document).ready( function () {
            $('#noVideoTable').DataTable(
                {
                    dom: 'Bfrtip',
                    buttons: [
                        'copy', 'csv', 'excel', 'pdf', 'print'
                    ],
                    paging:false,
                    searching:false,
                }
            );
        } );
    </script>
{% endblock %}