@extends('layouts.app')
@push('styles')
    <link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.css" />
@endpush
@push('scripts')
    <script type="text/javascript" src="https://cdn.jsdelivr.net/momentjs/latest/moment.min.js"></script>
    <script type="text/javascript" src="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.min.js"></script>
    <script>
        $(function() {
            $('#daterange').daterangepicker({
                opens: 'right',
                locale: {
                    format: 'DD/MM/YYYY'
                },
                showCustomRangeLabel: true,
                alwaysShowCalendars: true,
                ranges: {
                    'Hari Ini': [moment(), moment()],
                    'Kemarin': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
                    '7 Hari Terakhir': [moment().subtract(6, 'days'), moment()],
                    '1 Bulan Terakhir': [moment().subtract(29, 'days'), moment()],
                    'Bulan Ini': [moment().startOf('month'), moment().endOf('month')],
                    'Bulan Terakhir': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1,
                        'month').endOf('month')],
                    'Semua Waktu': [moment().subtract(10, 'year'), moment().add(10, 'year')]
                }
            }, function(start, end, label) {

                console.log("A new date selection was made: " + start.format('YYYY-MM-DD') + ' to ' + end
                    .format('YYYY-MM-DD'));
                var delayInMilliseconds = 500; //1 second

                setTimeout(function() {
                    $("#filter-form").submit();
                }, delayInMilliseconds);

            });
        });
    </script>
@endpush
@section('content')
    @php
        use Carbon\Carbon;
    @endphp
    <div class="container-fluid">
        <div class="block-header">
            <h2>Laporan Service Refund</h2>
        </div>

        <div class="row clearfix">
            <!-- Task Info -->
            <div class="col-xs-12 col-sm-12 col-md-12">
                <div class="card">
                    <div class="header">
                        <a href="{{ route('laporan') }}" class="btn btn-warning">Kembali</a>
                       
                    </div>
                    <div class="body">
                        
                        <div class="row clearfix">
                            <div class="col-lg-3 col-md-3 col-sm-6 col-xs-12">
                                <div class="info-box hover-zoom-effect">
                                    <div class="icon bg-purple">
                                        <i class="material-icons">build</i>
                                    </div>
                                    <div class="content">
                                        <div class="text">Total Transaksi Service</div>
                                        <div class="number">

                                            {{ $total_transaksi }}

                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="col-lg-3 col-md-3 col-sm-6 col-xs-12">
                                <div class="info-box hover-zoom-effect">
                                    <div class="icon bg-cyan">
                                        <i class="material-icons">view_module</i>
                                    </div>
                                    <div class="content">
                                        <div class="text">Total Sparepart Yang Terjual</div>
                                        <div class="number">

                                            {{ $total_barang_terjual }}

                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <hr>
                        <form action="" id="filter-form">
                            <div class="row">
                                <div class="col-lg-2 col-md-3">
                                    <div class="input-group">
                                        <span class="input-group-addon">
                                            <i class="material-icons">date_range</i>
                                        </span>
                                        <div class="form-line">

                                            <input type="text" class="form-control" name="periode" id="daterange" value="{{ request()->periode }}">
                                        </div>
                                    </div>
                                </div>

                                <div class="col-lg-2 col-md-3">
                                    <div class="input-group">
                                        <span class="input-group-addon">
                                            <i class="material-icons">search</i>
                                        </span>
                                        <div class="form-line">
                                            <input class="form-control" placeholder="No Service/Nama Pelanggan/No Telp" value="{{ request()->search }}" name="search">
                                        </div>
                                    </div>
                                </div>


                            </div>

                            <div class="row">
                                <div class="col-lg-2 col-md-5">
                                    <div class="input-group">
                                        <span class="input-group-addon">
                                            <i class="material-icons">attach_money</i>
                                        </span>
                                        <div class="form-line focused">
                                            <select name="pengguna_id" class="form-control">
                                                <option value="">Semua Kasir In</option>
                                                @foreach ($pengguna as $p)
                                                    <option value="{{ $p->id }}" @selected(request()->pengguna_id == $p->id)>
                                                        {{ $p->nama_pengguna }} 
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                </div>

                                <div class="col-lg-2 col-md-5">
                                    <div class="input-group">
                                        <span class="input-group-addon">
                                            <i class="material-icons">person</i>
                                        </span>
                                        <div class="form-line focused">
                                            <select name="sale_id" class="form-control">
                                                <option value="">Semua Sales In</option>
                                                @foreach ($pengguna as $p)
                                                    <option value="{{ $p->id }}"  @selected(request()->sale_id == $p->id)>
                                                        {{ $p->nama_pengguna }}
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-lg-2 col-md-5">
                                    <div class="input-group">
                                        <span class="input-group-addon">
                                            <i class="material-icons">card_membership</i>
                                        </span>
                                        <div class="form-line focused">
                                            <select name="teknisi_id" class="form-control">
                                                <option value=""> Semua Teknisi </option>
                                                @foreach ($pengguna as $t)
                                                    <option value="{{ $t->id }}"  @selected(request()->teknisi_id == $t->id)>
                                                        {{ $t->nama_pengguna }} 
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-lg-2 col-md-5">
                                    <div class="input-group">
                                        <span class="input-group-addon">
                                            <i class="material-icons">person</i>
                                        </span>
                                        <div class="form-line focused">
                                            <select name="sales_out" class="form-control">
                                                <option value="">Semua Sales Out</option>
                                                @foreach ($pengguna as $p)
                                                    <option value="{{ $p->nama_pengguna }}"  @selected(request()->sales_out == $p->id)>
                                                        {{ $p->nama_pengguna }} 
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-lg-2 col-md-5">
                                    <div class="input-group">
                                        <span class="input-group-addon">
                                            <i class="material-icons">person</i>
                                        </span>
                                        <div class="form-line focused">
                                            <select name="kasir_out" class="form-control">
                                                <option value="">Semua Kasir Out</option>
                                                @foreach ($pengguna as $p)
                                                    <option value="{{ $p->nama_pengguna }}"  @selected(request()->kasir_out == $p->id)>
                                                        {{ $p->nama_pengguna }} 
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-lg-2 col-md-5">
                                    <div class="input-group">
                                        <span class="input-group-addon">
                                            <i class="material-icons">card_membership</i>
                                        </span>
                                        <div class="form-line focused">
                                            <select name="jenis_id" class="form-control">
                                                <option value="">Semua jenis Sparepart</option>
                                                @foreach ($jenis as $j)
                                                    <option value="{{ $j->id }}"  @selected(request()->jenis_id == $j->id)>
                                                        {{ $j->nama_jenis }} 
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-lg-2 col-md-3">
                                    <div class="input-group">
                                        <button class="btn btn-primary">Filter</button>
                                    </div>
                                </div>
                            </div>

                    </div>



                    </form>




                    @if (\Helper::hakAkses('cetak_laporan', 'laporan_service_refund'))
                        <div class="body">

                            <form action="{{ route('laporan.serviceGaransi.print') }}" target="_blank"
                                class="row flex-column-reverse">
                                <div class="col-md-6">
                                    <input type="hidden" class="form-control" name="periode" id="daterange" value="{{ request()->periode }}">

                                    <input type="hidden" name="status" value="{{ $request->status }}">
                                    <input type="hidden" name="nama_pelanggan" value="{{ $request->nama_pelanggan }}">
                                    <input type="hidden" name="teknisi_id" value="{{ $request->teknisi_id }}">
                                    <input type="hidden" name="pengguna_id" value="{{ $request->pengguna_id }}">
                                    <input type="hidden" name="jenis_id" value="{{ $request->jenis_id }}">
                                    <input type="hidden" name="sale_id" value="{{ $request->sale_id }}">
                                    <input type="hidden" name="sales_out" value="{{ $request->sales_out }}">
                                    <input type="hidden" name="kasir_out" value="{{ $request->kasir_out }}">
                                    <input type="hidden" name="excel" value="0">
                                </div>
                                <div class="col-md-6 text-right">
                                    <button type="submit" class="btn bg-light-green waves-effect">
                                        <i class="material-icons">print</i>
                                        <span>Cetak</span>
                                    </button>

                                </div>

                            </form>
                            <form action="{{ route('laporan.serviceGaransi.print') }}" target="_blank"
                                class="row flex-column-reverse">
                                <div class="col-md-6">
                                    <input type="hidden" class="form-control" name="periode" id="daterange"
                                        value="{{ request()->periode }}">

                                    <input type="hidden" name="status" value="{{ $request->status }}">
                                    <input type="hidden" name="nama_pelanggan" value="{{ $request->nama_pelanggan }}">
                                    <input type="hidden" name="teknisi_id" value="{{ $request->teknisi_id }}">
                                    <input type="hidden" name="pengguna_id" value="{{ $request->pengguna_id }}">
                                    <input type="hidden" name="jenis_id" value="{{ $request->jenis_id }}">
                                    <input type="hidden" name="sale_id" value="{{ $request->sale_id }}">
                                    <input type="hidden" name="sales_out" value="{{ $request->sales_out }}">
                                    <input type="hidden" name="kasir_out" value="{{ $request->kasir_out }}">
                                    <input type="hidden" name="excel" value="1">
                                </div>
                                <div class="col-md-6 text-right">
                                    <button type="submit" class="btn bg-green waves-effect">
                                        <i class="material-icons">print</i>
                                        <span>Cetak Excel</span>
                                    </button>

                                </div>

                            </form>
                        </div>
                    @endif



                    <div class="table-responsive">
                        <table class="table table-hover dashboard-task-infos">
                            <thead>
                                <tr>
                                    <th style="min-width: 100px;">
                                        <a style="color:#555555;"
                                            href="{{ request()->fullUrlWithQuery(['order' => 'no_service', 'sorting_order' => $sorting_order]) }}">No.
                                            Service</a></th>
                                    <th style="min-width: 150px;"><a style="color:#555555;"
                                            href="{{ request()->fullUrlWithQuery(['order' => 'tanggal_selesai', 'sorting_order' => $sorting_order]) }}">Tanggal
                                            Pelunasan</a>
                                    </th>
                                    <th><a style="color:#555555;"
                                            href="{{ request()->fullUrlWithQuery(['order' => 'nama_pelanggan', 'sorting_order' => $sorting_order]) }}">Nama
                                            Pelanggan</a></th>


                                    <th style="min-width: 150px;"><a style="color:#555555;"
                                            href="{{ request()->fullUrlWithQuery(['order' => 'merk', 'sorting_order' => $sorting_order]) }}">Merek
                                            & type</a>
                                    </th>
                                    <th style="min-width: 200px;"><a style="color:#555555;"
                                            href="{{ request()->fullUrlWithQuery(['order' => 'deskripsi', 'sorting_order' => $sorting_order]) }}">Kerusakan</a>
                                    </th>
                                    <th style="min-width: 200px;">
                                        <a style="color:#555555;"
                                            href="{{ request()->fullUrlWithQuery(['order' => 'deskripsi', 'sorting_order' => $sorting_order]) }}">Sparepart</a>
                                    </th>
                                    <th style="min-width: 150px;">
                                        <a style="color:#555555;"
                                            href="{{ request()->fullUrlWithQuery(['order' => 'deskripsi', 'sorting_order' => $sorting_order]) }}">Jenis
                                            Sparepart</a>
                                    </th>

                                    <th><a style="color:#555555;"
                                            href="{{ request()->fullUrlWithQuery(['order' => 'teknisi_id', 'sorting_order' => $sorting_order]) }}">Nama
                                            Teknisi</a></th>
                                    <th><a style="color:#555555;"
                                            href="{{ request()->fullUrlWithQuery(['order' => 'pengguna_id', 'sorting_order' => $sorting_order]) }}">
                                            Kasir In</a></th>
                                    <th><a style="color:#555555;"
                                            href="{{ request()->fullUrlWithQuery(['order' => 'sale_id', 'sorting_order' => $sorting_order]) }}">
                                            Sales In</a></th>
                                    <th><a style="color:#555555;"
                                            href="{{ request()->fullUrlWithQuery(['order' => 'pengguna_id', 'sorting_order' => $sorting_order]) }}">
                                            Kasir Out</a></th>
                                    <th><a style="color:#555555;"
                                            href="{{ request()->fullUrlWithQuery(['order' => 'sale_id', 'sorting_order' => $sorting_order]) }}">
                                            Sales Out</a></th>

                                    <th><a style="color:#555555;"
                                            href="{{ request()->fullUrlWithQuery(['order' => 'uang_bayar', 'sorting_order' => $sorting_order]) }}">Dp</a>
                                    </th>
                                    <th><a style="color:#555555;"
                                            href="{{ request()->fullUrlWithQuery(['order' => 'biaya', 'sorting_order' => $sorting_order]) }}">
                                            Total Biaya</a></th>
                                    <th><a style="color:#555555;">
                                            Jasa</a>
                                    </th>
                                    <th><a style="color:#555555;">Jual
                                            Sparepart Luar</a>
                                    </th>
                                    <th><a style="color:#555555;">Modal
                                            Sparepart Luar</a>
                                    </th>
                                    <th><a style="color:#555555;"
                                            href="{{ request()->fullUrlWithQuery(['order' => 'biaya', 'sorting_order' => $sorting_order]) }}">Jual
                                            Sparepart
                                        </a>
                                    </th>
                                    <th><a style="color:#555555;"
                                            href="{{ request()->fullUrlWithQuery(['order' => 'biaya', 'sorting_order' => $sorting_order]) }}">Modal
                                            Sparepart
                                        </a>
                                    </th>
                                    <th><a style="color:#555555;"
                                            href="{{ request()->fullUrlWithQuery(['order' => 'biaya', 'sorting_order' => $sorting_order]) }}">
                                            Total Laba/Rugi
                                        </a>
                                    </th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($datas as $data)
                                    <tr>
                                        <td>{{ $data->no_service }}
                                            @if ($data->garansi == 1)
                                                <span class="label label-info">Garansi</span>
                                            @endif
                                            @if ($data->status_pembayaran == 'refund')
                                                <span class="label bg-indigo">refund</span>
                                            @endif

                                        </td>
                                        <td>{{ $data->tanggal_selesai }}

                                            @php
                                                $jam_selesai = Carbon::parse($data->jam_selesai)->format('H:i');
                                            @endphp
                                            <br>({{ $jam_selesai }})
                                        </td>
                                        <td>{{ $data->pelanggan->nama_pelanggan }}
                                            ({{ $data->pelanggan->telp_pelanggan }})
                                        </td>

                                        <td>{{ $data->merk }} <br>
                                            ({{ $data->tipe }})
                                        </td>
                                        <td>{{ $data->deskripsi }}</td>
                                        <td style="max-width: 300px;">
                                            @foreach ($data->detail as $detail)
                                                {!! $detail->nama_item . ',' . '<br>' !!}
                                            @endforeach
                                            @if ($data->sparepart_luar->count() > 0)
                                                @foreach ($data->sparepart_luar as $sl)
                                                    {!! $sl->nama_SL . ',' . '<br>' !!}
                                                @endforeach
                                            @endif
                                        </td>
                                        <td style="max-width: 300px;">
                                            @if (isset($data->detail))
                                                @foreach ($data->detail as $item)
                                                    @if (isset($item->sparepart))
                                                        {!! $item->sparepart->jenis_item->nama_jenis . ',' . '<br>' !!}
                                                    @endif
                                                @endforeach
                                            @endif
                                            @if ($data->sparepart_luar->count() > 0)
                                                Sparepart Luar
                                            @endif

                                        </td>

                                        <td>{{ $data->teknisi->nama_pengguna }}</td>
                                        <td>{{ $data->pengguna->nama_pengguna }}</td>
                                        <td>{{ $data->sales->nama_pengguna }}</td>
                                        <td>{{ $data->kasir_out }}</td>
                                        <td>{{ $data->sales_out }}</td>


                                        {{-- // --}}
                                        <td>Rp.{{ number_format($data->uang_bayar) }}
                                            @if ($data->uang_bayar != 0)
                                                <br>({{ $data->metode_bayar }})
                                            @endif
                                        </td>

                                        <td>Rp.{{ number_format($data->grand_total) }}
                                            <br>
                                            @if (isset($data->pembayaran_service))
                                                @php
                                                    $pembayaran = $data->pembayaran_service->first();

                                                @endphp
                                                @if (isset($pembayaran))
                                                    ({{ $pembayaran->metode_bayar }})
                                                @else
                                                    -
                                                @endif
                                            @else
                                                -
                                            @endif
                                        </td>
                                        <td>Rp.{{ number_format($data->biaya) }}</td>
                                        <td>Rp.{{ number_format($data->total_jual_sparepart_luar) }}</td>
                                        <td>Rp.{{ number_format($data->total_modal_sparepart_luar) }}</td>
                                        <td>Rp.{{ number_format($data->total_jual_sparepart_dalam) }}</td>
                                        <td>Rp.{{ number_format($data->total_modal_sparepart) }}</td>
                                        <td>
                                            @php

                                                $total_laba =
                                                    $data->biaya +
                                                    $data->total_jual_sparepart_luar -
                                                    $data->total_modal_sparepart_luar +
                                                    $data->total_jual_sparepart_dalam -
                                                    $data->total_modal_sparepart;
                                            @endphp



                                            Rp.{{ number_format($total_laba) }}
                                        </td>


                                    </tr>
                                @endforeach
                            </tbody>
                            <tfoot>
                                @include('layouts.includes.pagination')
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>
        </div>
        <!-- #END# Task Info -->
    </div>
    </div>
@endsection