@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])

@section('content')
    @include('layouts.navbars.auth.topnav', ['title' => ''])
    <div class="container-fluid py-4">
        @if ($user_login->idroles == 'admins' || $user_login->idroles == 'admnga')
            @php
                // pengajuan aset
                $query_req = DB::table('trs_request')->where('isactive', '1');
                $req_needresp = (clone $query_req)->where('respond', '-1')->count();
                $req_ongoing = (clone $query_req)->where('respond', '1')->count();
                $req_done = (clone $query_req)->where('respond', '2')->orWhere('respond', '0')->count();

                // pengajuan mutasi
                $query_mut = DB::table('trs_mutationreq');
                $mut_needresp = (clone $query_mut)->where('respond', '-1')->count();
                $mut_ongoing = (clone $query_mut)->where('respond', '1')->count();
                $mut_done = (clone $query_mut)->where('respond', '2')->orWhere('respond', '0')->count();

                // aset
                $query_ast = DB::table('mst_asset');

                $today = date('Y-m-d');
                $next_30_days = date('Y-m-d', strtotime('+30 days'));
                
                $expdead = (clone $query_ast)->whereBetween('expired_date', [$today, $next_30_days])
                ->count();
                $warrdead = (clone $query_ast)->whereBetween('warranty_date', [$today, $next_30_days])
                ->count();
                $totalast = (clone $query_ast)->count();
            @endphp
            <div class="row">
                <div class="col-12">
                    <div class="card mb-2">
                        <div class="card-header p-3">
                            <h4 class="mb-1">Pengajuan Aset</h4>
                        </div>
                    </div>
                </div>
            </div>
            <div class="row">
                <div class="col-xl-4 col-sm-6 mb-xl-0 mb-4">
                    <div class="card" onclick="window.location.href='{{ url('rqlist') }}'" style="cursor: pointer;">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Pengajuan Aset Belum Direspon</p>
                                        <h5 class="font-weight-bolder">
                                            {{ $req_needresp }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div class="icon icon-shape bg-warning shadow-primary text-center rounded-circle">
                                        <i class="fa fa-magnifying-glass fa-bounce text-lg opacity-10" aria-hidden="true"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-xl-4 col-sm-6 mb-xl-0 mb-4">
                    <div class="card" onclick="window.location.href='{{ url('rqlist') }}'" style="cursor: pointer;">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Pengajuan Aset On Going</p>
                                        <h5 class="font-weight-bolder">
                                            {{ $req_ongoing }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div class="icon icon-shape bg-gradient-info shadow-danger text-center rounded-circle align-items-center justify-content-center">
                                        <i class="fa fa-spinner fa-pulse text-lg opacity-10" aria-hidden="true"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-xl-4 col-sm-6 mb-xl-0 mb-4">
                    <div class="card" onclick="window.location.href='{{ url('rpmuts') }}'" style="cursor: pointer;">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Pengajuan Aset Selesai</p>
                                        <h5 class="font-weight-bolder">
                                            {{ $req_done }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div class="icon icon-shape bg-gradient-success shadow-success text-center rounded-circle">
                                        <i class="fa fa-check fa-beat text-lg opacity-10" aria-hidden="true"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <div class="row mt-4">
                <div class="col-12">
                    <div class="card mb-2">
                        <div class="card-header p-3">
                            <h4 class="mb-1">Pengajuan Mutasi</h4>
                        </div>
                    </div>
                </div>
            </div>
            <div class="row">
                <div class="col-xl-4 col-sm-6 mb-xl-0 mb-4">
                    <div class="card" onclick="window.location.href='{{ url('mtlist') }}'" style="cursor: pointer;">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Pengajuan Mutasi Belum Direspon</p>
                                        <h5 class="font-weight-bolder">
                                            {{ $mut_needresp }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div class="icon icon-shape bg-warning shadow-primary text-center rounded-circle">
                                        <i class="fa fa-magnifying-glass fa-bounce text-lg opacity-10" aria-hidden="true"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-xl-4 col-sm-6 mb-xl-0 mb-4">
                    <div class="card" onclick="window.location.href='{{ url('mtlist') }}'" style="cursor: pointer;">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Pengajuan Mutasi On Going</p>
                                        <h5 class="font-weight-bolder">
                                            {{ $mut_ongoing }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div class="icon icon-shape bg-gradient-info shadow-danger text-center rounded-circle align-items-center justify-content-center">
                                        <i class="fa fa-spinner fa-pulse text-lg opacity-10" aria-hidden="true"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-xl-4 col-sm-6 mb-xl-0 mb-4">
                    <div class="card" onclick="window.location.href='{{ url('rpmuts') }}'" style="cursor: pointer;">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Pengajuan Mutasi Selesai</p>
                                        <h5 class="font-weight-bolder">
                                            {{ $mut_done }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div class="icon icon-shape bg-gradient-success shadow-success text-center rounded-circle">
                                        <i class="fa fa-check fa-beat text-lg opacity-10" aria-hidden="true"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <div class="row mt-4">
                <div class="col-12">
                    <div class="card mb-2">
                        <div class="card-header p-3">
                            <h4 class="mb-1">Aset</h4>
                        </div>
                    </div>
                </div>
            </div>
            <div class="row">
                <div class="col-xl-4 col-sm-6 mb-xl-0 mb-4">
                    <div class="card" onclick="window.location.href='{{ url('msasst') }}'" style="cursor: pointer;">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Aset Akan Expired</p>
                                        <h5 class="font-weight-bolder">
                                            {{ $expdead }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div class="icon icon-shape bg-danger shadow-primary text-center rounded-circle">
                                        <i class="fa fa-exclamation fa-shake text-lg opacity-10" aria-hidden="true"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-xl-4 col-sm-6 mb-xl-0 mb-4">
                    <div class="card" onclick="window.location.href='{{ url('msasst') }}'" style="cursor: pointer;">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Garansi Akan Habis</p>
                                        <h5 class="font-weight-bolder">
                                            {{ $warrdead }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div class="icon icon-shape bg-danger shadow-danger text-center rounded-circle">
                                        <i class="fa fa-calendar-days text-lg opacity-10" aria-hidden="true"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-xl-4 col-sm-6 mb-xl-0 mb-4">
                    <div class="card" onclick="window.location.href='{{ url('msasst') }}'" style="cursor: pointer;">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Total Aset</p>
                                        <h5 class="font-weight-bolder">
                                            {{ $totalast }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div class="icon icon-shape bg-gradient-success shadow-success text-center rounded-circle">
                                        <i class="ni ni-briefcase-24 text-lg opacity-10" aria-hidden="true"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        @elseif ($user_login->idroles == 'accntg')
            @php
                // aset
                $query_ast = DB::table('mst_asset');

                $today = date('Y-m-d');
                $next_30_days = date('Y-m-d', strtotime('+30 days'));
                
                $expdead = (clone $query_ast)->whereBetween('expired_date', [$today, $next_30_days])
                ->count();
                $warrdead = (clone $query_ast)->whereBetween('warranty_date', [$today, $next_30_days])
                ->count();
                $totalast = (clone $query_ast)->count();
            @endphp
            <div class="row mt-4">
                <div class="col-12">
                    <div class="card mb-2">
                        <div class="card-header p-3">
                            <h4 class="mb-1">Aset</h4>
                        </div>
                    </div>
                </div>
            </div>
            <div class="row">
                <div class="col-xl-4 col-sm-6 mb-xl-0 mb-4">
                    <div class="card" onclick="window.location.href='{{ url('rpasst') }}'" style="cursor: pointer;">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Aset Akan Expired</p>
                                        <h5 class="font-weight-bolder">
                                            {{ $expdead }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div class="icon icon-shape bg-danger shadow-primary text-center rounded-circle">
                                        <i class="fa fa-exclamation fa-shake text-lg opacity-10" aria-hidden="true"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-xl-4 col-sm-6 mb-xl-0 mb-4">
                    <div class="card" onclick="window.location.href='{{ url('rpasst') }}'" style="cursor: pointer;">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Garansi Akan Habis</p>
                                        <h5 class="font-weight-bolder">
                                            {{ $warrdead }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div class="icon icon-shape bg-danger shadow-danger text-center rounded-circle">
                                        <i class="fa fa-calendar-days text-lg opacity-10" aria-hidden="true"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-xl-4 col-sm-6 mb-xl-0 mb-4">
                    <div class="card" onclick="window.location.href='{{ url('rpasst') }}'" style="cursor: pointer;">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Total Aset</p>
                                        <h5 class="font-weight-bolder">
                                            {{ $totalast }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div class="icon icon-shape bg-gradient-success shadow-success text-center rounded-circle">
                                        <i class="ni ni-briefcase-24 text-lg opacity-10" aria-hidden="true"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        @else
            @php
                // pengajuan aset
                $query_req = DB::table('trs_request')->where('user_create', Session::get('username'))->where('isactive', '1');
                $req_needresp = (clone $query_req)->where('respond', '-1')->count();
                $req_ongoing = (clone $query_req)->where('respond', '1')->count();
                $req_done = (clone $query_req)->where('respond', '2')->orWhere('respond', '0')->count();

                // pengajuan mutasi
                $query_mut = DB::table('trs_mutationreq');
                $mut_needresp = (clone $query_mut)->where('respond', '-1')->where('user_create', Session::get('username'))->orWhere('spv2_name', Session::get('username'))->count();
                $mut_ongoing = (clone $query_mut)->where('respond', '1')->where('user_create', Session::get('username'))->orWhere('spv2_name', Session::get('username'))->count();
                $mut_done = (clone $query_mut)->where('respond', '2')->where('user_create', Session::get('username'))->orWhere('spv2_name', Session::get('username'))->orWhere('respond', '0')->count();
            @endphp
            <div class="row">
                <div class="col-12">
                    <div class="card mb-2">
                        <div class="card-header p-3">
                            <h4 class="mb-1">Pengajuan Aset</h4>
                        </div>
                    </div>
                </div>
            </div>
            <div class="row">
                <div class="col-xl-4 col-sm-6 mb-xl-0 mb-4">
                    <div class="card" onclick="window.location.href='{{ url('trreqs') }}'" style="cursor: pointer;">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Pengajuan Aset Belum Direspon</p>
                                        <h5 class="font-weight-bolder">
                                            {{ $req_needresp }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div class="icon icon-shape bg-warning shadow-primary text-center rounded-circle">
                                        <i class="fa fa-magnifying-glass fa-bounce text-lg opacity-10" aria-hidden="true"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-xl-4 col-sm-6 mb-xl-0 mb-4">
                    <div class="card" onclick="window.location.href='{{ url('trreqs') }}'" style="cursor: pointer;">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Pengajuan Aset On Going</p>
                                        <h5 class="font-weight-bolder">
                                            {{ $req_ongoing }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div class="icon icon-shape bg-gradient-info shadow-danger text-center rounded-circle align-items-center justify-content-center">
                                        <i class="fa fa-spinner fa-pulse text-lg opacity-10" aria-hidden="true"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-xl-4 col-sm-6 mb-xl-0 mb-4">
                    <div class="card" onclick="window.location.href='{{ url('trreqs') }}'" style="cursor: pointer;">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Pengajuan Aset Selesai</p>
                                        <h5 class="font-weight-bolder">
                                            {{ $req_done }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div class="icon icon-shape bg-gradient-success shadow-success text-center rounded-circle">
                                        <i class="fa fa-check fa-beat text-lg opacity-10" aria-hidden="true"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <div class="row mt-4">
                <div class="col-12">
                    <div class="card mb-2">
                        <div class="card-header p-3">
                            <h4 class="mb-1">Pengajuan Mutasi</h4>
                        </div>
                    </div>
                </div>
            </div>
            <div class="row">
                <div class="col-xl-4 col-sm-6 mb-xl-0 mb-4">
                    <div class="card" onclick="window.location.href='{{ url('trmuts') }}'" style="cursor: pointer;">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Pengajuan Mutasi Belum Direspon</p>
                                        <h5 class="font-weight-bolder">
                                            {{ $mut_needresp }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div class="icon icon-shape bg-warning shadow-primary text-center rounded-circle">
                                        <i class="fa fa-magnifying-glass fa-bounce text-lg opacity-10" aria-hidden="true"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-xl-4 col-sm-6 mb-xl-0 mb-4">
                    <div class="card" onclick="window.location.href='{{ url('trmuts') }}'" style="cursor: pointer;">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Pengajuan Mutasi On Going</p>
                                        <h5 class="font-weight-bolder">
                                            {{ $mut_ongoing }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div class="icon icon-shape bg-gradient-info shadow-danger text-center rounded-circle align-items-center justify-content-center">
                                        <i class="fa fa-spinner fa-pulse text-lg opacity-10" aria-hidden="true"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-xl-4 col-sm-6 mb-xl-0 mb-4">
                    <div class="card" onclick="window.location.href='{{ url('trmuts') }}'" style="cursor: pointer;">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Pengajuan Mutasi Selesai</p>
                                        <h5 class="font-weight-bolder">
                                            {{ $mut_done }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div class="icon icon-shape bg-gradient-success shadow-success text-center rounded-circle">
                                        <i class="fa fa-check fa-beat text-lg opacity-10" aria-hidden="true"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        @endif
    </div>
@endsection

@push('js')
@endpush