@extends('layouts.main_without_top_button')
@section('title')
    Client Trip Sales Reports
@stop
@section('navigation')
    <ul class="breadcrumb">
        <li><a href="{{route('home')}}">Dashboard</a> <span class="divider">/</span></li>
        <li><a href="">Managements Reports</a> <span class="divider">/</span></li>
        <li class="active">Client Trip Sales Reports</li>
    </ul>
@stop
@section('contentinner')
    <div class="tabbable">
        <style>
            .td_left_border {
                border-top: 1px solid #dddddd;
                border-left: 1px solid #dddddd;
                border-bottom: 0;
            }

            .td_border_right {
                border-right: 1px solid #dddddd;
            }

            .widgettitle {
                color: #000000;
            }
        </style>
        <div class="tab-content">
            <div class="tab-pane active" style="margin-top: 12px">
                <center>
                    <center style="margin-bottom: 8px">
                        <form class=" form-inline">
                            <table style="padding: 2px">
                                <tr id="cargo_type_tr">
                                    <td style="text-align: right;padding-right: 4px;margin-top: 2px"><label class="control-label" for="Category"> CARGO TYPE </label></td>
                                    <td style="text-align: left">
                                        <select name="cargo_type" style="width: 200px" class="searchable_select" id="cargo_type">
                                            <option value="">ALL</option>
                                            <option value="DRY_CARGO">DRY CARGO</option>
                                            <option value="TANKERS">TANKERS ONLY</option>
                                            <option value="CONTAINERS">CONTAINERS ONLY</option>
                                            <option value="LOOSE_CARGO">LOOSE CARGO ONLY</option>
                                        </select>
                                    </td>
                                </tr>
                                <tr>
                                    <td style="text-align: center;padding-top: 2px" colspan="2"><button type="submit" class="btn" id="re_generate_report">GENERATE</button></td>
                                </tr>
                            </table>
                        </form>
                    </center>

                    <div id="income_statement">
                        <input data-href="{{route('reports.managements_reports.loading_orders_summary_by_clients.print',['cargo_type'=>$cargo_type])}}"
                               id="turn_around_report_print" type="hidden">


                        <input data-href="{{route('reports.company-income-statements.excel',['date_from'=>$date_between[0],'date_to'=>$date_between[1]])}}"
                               id="income_statement_date" type="hidden">

                        <a id="print_generate_report" class="btn" style="" data-href="">PRINT</a>
                        <table class="table table-bordered table-striped" id="">
                            <thead>
                            <tr>
                                <th style="width: 10%;text-align: left">Month Of</th>
                                @foreach($clients as $client)
                                    <th style="writing-mode: vertical-lr">{{$client->client_code}}</th>
                                @endforeach
                            </tr>
                            </thead>
                            <tbody>
                            
                            @foreach($months as $month)
                                {{--*/ \Illuminate\Support\Facades\DB::statement('CALL clientsTripsBasedOnLoadDate("' . $month['start_date'] . '","' . $month['end_date'] . '")') /*--}}
                                <tr>
                                    <td>{{ $month['month'] }}</td>
                                    @foreach($clients as $client)
                                        {{--*/ $client_detail = \App\Model\TempoClientTotalTripByLoadingDate::whereClientId($client->client_id)->first() /*--}}
                                        <th>{{($client_detail) ? $client_detail->number_of_trips : ""}}</th>
                                    @endforeach
                                </tr>
                            @endforeach
                            </tbody>
                        </table>

                    </div>

                </center>
            </div><!--tab-pane-->
        </div><!--tabcontent-->
    </div><!--tabbable-->
    <script>
        jQuery('#re_generate_report').on('click', function (e) {
            e.preventDefault();
            jQuery.ajax({
                url: '{{route('reports.managements_reports.loading_orders_summary_by_clients.re_generation')}}',
                type: 'get',
                data: jQuery('form').serialize(),
                beforeSend: function () {
                    startSpinner();
                },
                success: function (data) {
                    jQuery('#income_statement').empty().append(data);

                },
                complete: function () {
                    stopSpinner();
                },
                error: function (xhr, textStatus, error) {
                    console.log(error);
                    console.log(textStatus);
                    stopSpinner();
                }
            });
        });

        jQuery('#print_generate_report').on('click', function (e) {
            e.preventDefault();
            var url = jQuery('#turn_around_report_print').attr("data-href");
            window.open(url, '_blank');
        });

        jQuery('#export_generate_report').on('click', function (e) {
            e.preventDefault();
            var url = jQuery('#income_statement_date').attr("data-href");
            window.open(url, '_blank');
        });

    </script>
@stop