@extends('library.admin.layouts.admin_design')

@section('title')
    <title>View Report - School Library</title>
@endsection

@section('content')

    <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
            <h1>
                Reports
            </h1>

        </section>

        <!-- Main content -->
        <section class="content">
            <div class="row">
                <div class="col-12">
                        <div class="col-12 col-lg-12">
                                <div class="box box-default">
                                  <div class="box-header with-border">
                                    <h4 class="box-title">Report Detail</h4>
                                      <div class="float-right">
                                          <a href="{{route('library.report.expense')}}" style="color: white;" class="btn btn-cyan btn-xs">
                                              Monthly Report
                                          </a>
                                        </div>

                                  </div>
                                  <!-- /.box-header -->
                                  <div class="box-body">
                                      <!-- Nav tabs -->
                                      <ul class="nav nav-tabs" role="tablist">
                                          <li class="nav-item"> <a class="nav-link active" data-toggle="tab" href="#home" role="tab"><span class="hidden-sm-up"><i class="ion-home"></i></span> <span class="hidden-xs-down">Expenses</span></a> </li>
                                          <li class="nav-item"> <a class="nav-link" data-toggle="tab" href="#profile" role="tab"><span class="hidden-sm-up"><i class="ion-person"></i></span> <span class="hidden-xs-down">Income</span></a> </li>

                                          <li class="nav-item"> <a class="nav-link" data-toggle="tab" href="#messages" role="tab"><span class="hidden-sm-up"><i class="ion-email"></i></span> <span class="hidden-xs-down">Other Reports</span></a> </li>

                                      </ul>


                                      <!-- Tab panes -->
                                      <div class="tab-content tabcontent-border">
                                          <div class="tab-pane active" style="padding:5px;" id="home" role="tabpanel">
                                                <div class="float-right">
                                                        <a href="{{route('library.report.create')}}" style="color: white;" class="btn btn-cyan">
                                                            Add Expense
                                                        </a>

                                                    </div>
                                                <div class="table-responsive">
                                                        <table id="example" class="table table-bordered table-hover display nowrap margin-top-10 w-p100">
                                                            <thead>
                                                            <tr>
                                                                <th>#</th>
                                                                <th>Particulars</th>
                                                                <th>Published Date</th>
                                                                <th>Rate</th>
                                                                <th>Quantity</th>
                                                                <th>Expenses</th>
                                                            </tr>
                                                            </thead>
                                                            <tbody>
                                                                @foreach($report as $rpt)
                                                                <tr>
                                                                    <td>{{$loop->index + 1}}</td>
                                                                    <td>{{$rpt->particulars}}</td>
                                                                    <td>{{$rpt->created_at->format('j F Y')}}</td>
                                                                    <td>{{$rpt->rate}}</td>
                                                                    <td>{{$rpt->quantity}}</td>
                                                                    <td>{{$rpt->expenses}}</td>

                                                                </tr>
                                                                @endforeach

                                                            </tbody>
                                                            <tbody style="background-color:lightgrey;color:black;">

                                                                    <tr>
                                                                        <td colspan="2"></td>
                                                                        <td class="text-center">Grand Total</td>
                                                                        <td></td>
                                                                        <td></td>
                                                                        <td>{{$report->sum('expenses')}}</td>

                                                                    </tr>


                                                                </tbody>

                                                        </table>
                                                    </div>
                                          </div>
                                          <div class="tab-pane pad" id="profile" role="tabpanel">
                                                <div class="float-right">
                                                        <a href="{{route('library.createIncomeReport')}}" style="color: white;" class="btn btn-cyan">
                                                            Add Income
                                                        </a>

                                                    </div>
                                                <div class="table-responsive">
                                                        <table id="example1" class="table table-bordered table-hover display nowrap margin-top-10 w-p100">
                                                            <thead>
                                                            <tr>
                                                                <th>#</th>
                                                                <th>Particulars</th>
                                                                <th>Published Date</th>
                                                                <th>Rate</th>
                                                                <th>Quantity</th>
                                                                <th>Discount Received</th>
                                                                <th>Income</th>
                                                            </tr>
                                                            </thead>
                                                            <tbody>
                                                                @foreach($incomereport as $rpt)
                                                                <tr class="text-center">
                                                                    <td>{{$loop->index + 1}}</td>
                                                                    <td>{{$rpt->particulars}}</td>
                                                                    <td>{{$rpt->created_at->format('j F Y')}}</td>
                                                                    <td>{{$rpt->rate}}</td>
                                                                    <td>{{$rpt->quantity}}</td>
                                                                    <td>{{abs($rpt->discount)}}</td>
                                                                    <td>{{$rpt->income}}</td>

                                                                </tr>
                                                                @endforeach

                                                            </tbody>
                                                            <tbody style="background-color:lightgrey;color:black;">

                                                                    <tr>
                                                                        <td colspan="3"></td>
                                                                        <td class="text-center">Grand Total</td>
                                                                        <td></td>
                                                                        <td></td>
                                                                        <td>{{$incomereport->sum('income')}}</td>

                                                                    </tr>


                                                                </tbody>

                                                        </table>
                                                    </div>


                                          </div>
                                          <div class="tab-pane pad" id="messages" role="tabpanel">
                                            <div class="row">
                                                <div class="col-12">
                                                    <div class="box box-solid box-primary">
                                                        <div class="box-header with-border">
                                                            <h4 class="box-title">Books That has been Lost</h4>

                                                        </div>

                                                        <!-- /.box-header -->
                                                        <div class="box-body">
                                                            <div class="table-responsive">
                                                                <table id="example" class="table table-bordered table-hover display nowrap margin-top-10 w-p100">
                                                                    <thead>
                                                                    <tr>
                                                                        <th>#</th>
                                                                        <th>Book Title</th>
                                                                        <th>Isbn</th>
                                                                        <th>Status</th>

                                                                    </tr>
                                                                    </thead>
                                                                    <tbody>
                                                                    @foreach($totalLost as $cat)
                                                                        <tr>
                                                                            <td>{{$loop->index + 1}}</td>
                                                                        <td><a href="{{route('library.book.viewIsbn',$cat->book_id)}}" >{{$cat->book->title}}</a></td>
                                                                        <td><a href="{{route('library.book_details',$cat->isbn)}}" >{{$cat->isbn}}</a></td>
                                                                        <td style="color:red;">{{$cat->status}}</td>
                                                                        </tr>
                                                                        @endforeach
                                                                    </tbody>

                                                                </table>
                                                            </div>
                                                        </div>
                                                        <!-- /.box-body -->
                                                    </div>
                                                    <!-- /.box -->
                                                </div>
                                                <div class="col-12">



                                                    <div class="box box-solid box-primary">
                                                        <div class="box-header with-border">
                                                            <h4 class="box-title">Books That has been Damaged</h4>

                                                        </div>

                                                        <!-- /.box-header -->
                                                        <div class="box-body">
                                                            <div class="table-responsive">
                                                                <table id="example" class="table table-bordered table-hover display nowrap margin-top-10 w-p100">
                                                                    <thead>
                                                                    <tr>
                                                                        <th>#</th>
                                                                        <th>Book Title</th>
                                                                        <th>Isbn</th>
                                                                        <th>Status</th>

                                                                    </tr>
                                                                    </thead>
                                                                    <tbody>
                                                                    @foreach($totalDamaged as $cat)
                                                                        <tr>
                                                                            <td>{{$loop->index + 1}}</td>
                                                                        <td>{{$cat->book->title}}</td>
                                                                        <td><a href="{{route('library.book_details',$cat->isbn)}}" >{{$cat->isbn}}</a></td>
                                                                        <td style="color:red;">{{$cat->status}}</td>
                                                                        </tr>
                                                                        @endforeach
                                                                    </tbody>

                                                                </table>
                                                            </div>
                                                        </div>
                                                        <!-- /.box-body -->
                                                    </div>
                                                    <!-- /.box -->
                                                </div>
                                                <!-- /.col -->
                                            </div>

                                          </div>
                                      </div>
                                  </div>
                                  <!-- /.box-body -->
                                </div>
                                <!-- /.box -->
                              </div>
                    </div>
                <!-- /.col -->
            </div>
            <!-- /.row -->
        </section>
        <!-- /.content -->
    </div>
@endsection

@section('scripts')
    <script type="text/javascript">
        @if(session('flash_message'))
        swal("Success!", "{!! session('flash_message') !!}", "success")
        @endif
    </script>
    <script src="{{asset('adminpanel/assets/vendor_components/datatable/datatables.min.js')}}"></script>
    <script src="{{asset('adminpanel/js/pages/data-table.js')}}"></script>
    <script type="text/javascript">
        $(document).ready(function() {
         $('#example1').DataTable();
       } );
        </script>
@endsection