@extends('admin.master')

@section('title', 'Dashboard')
@section('style_links')
    <style>
      .scroll {
        height: 300px;
        overflow: scroll;
      }
      /* width */
      .scroll::-webkit-scrollbar {
        width: 3px;
      }
      /* Track */
      .scroll::-webkit-scrollbar-track {
        background: #f1f1f1;
      }
      /* Handle */
      .scroll::-webkit-scrollbar-thumb {
        background: #888;
      }
      /* Handle on hover */
      .scroll::-webkit-scrollbar-thumb:hover {
        background: #555;
      }
    </style>
@endsection
@section('contents')
  <!-- Info boxes -->
  <div class="col-md-12">
    <h4 style="display: block;">Dashboard :: Latest Records</h4>
  </div>
  <div class="row">
    <div class="col-md-12">
      <div class="card card-widget widget-user">
        <!-- Add the bg color to the header using any of the bg-* classes -->
        <div class="widget-user-header bg-white" style="height:auto !important;">
          <h4 class="widget-user-username"><a href="{{ url('/stock') }}" class="text-dark">Summary: Stock</a></h4>
        </div>
        <div class="overlay" style="display: none;">
          <i class="fas fa-2x fa-sync-alt"></i>
        </div>
        <div class="card-footer" style="padding-top: 0;padding-bottom: 0;">
          <div class="row">
            <div class="col-sm-3 border-right bg-success">
              <div class="description-block">
                <h5 id="show_total_products" class="description-header" style="font-size: 30px;">{{ $summary->stockins ?: 0 }}</h5>
                <span class="description-text">TOTAL STOCKIN QTY</span>
              </div>
              <!-- /.description-block -->
            </div>
            <!-- /.col -->
            <div class="col-sm-3 border-right bg-warning">
              <div class="description-block">
                <h5 id="show_total_tax" class="description-header" style="font-size: 30px;">{{ $summary->sold ?: 0 }}</h5>
                <span class="description-text">TOTAL SOLD QTY</span>
              </div>
              <!-- /.description-block -->
            </div>
            <!-- /.col -->
            <div class="col-sm-3 border-right bg-success">
              <div class="description-block">
                <h5 id="show_total_tax" class="description-header" style="font-size: 30px;">{{ $summary->available ?: 0 }}</h5>
                <span class="description-text">TOTAL AVAILABLE QTY</span>
              </div>
              <!-- /.description-block -->
            </div>
            <!-- /.col -->
            <div class="col-sm-3 bg-cyan">
              <div class="description-block">
                <h5 id="show_total_amount" class="description-header" style="font-size: 30px;">{{ number_format(($summary->stock_value ?: 0),2) }}</h5>
                <span class="description-text">TOTAL STOCK VALUE ({{$settings->currency_symbol}})</span>
              </div>
              <!-- /.description-block -->
            </div>
            <!-- /.col -->
          </div>
          <!-- /.row -->
        </div>
      </div>
    </div>
    <div class="col-md-6">
      <div class="card card-outline card-primary">
        <div class="card-header">
          <h3 class="card-title"><a href="{{ url('/reports/stockin_vs_stockout') }}" class="text-dark">StockIn vs StockOut</a></h3>

          <div class="card-tools">
            <select name="days" id="days" class="form-control">
              <option value="today">Today</option>
              <option value="week" selected>Last 7 Days</option>
              <option value="month">Last 30 Days</option>
              <option value="all">All time</option>
            </select>
          </div>
          <!-- /.card-tools -->
        </div>
        <!-- /.card-header -->
        <div class="card-body table-responsive scroll">
          <table id="stockIn_stockOut" class="table table-sm table-striped table-bordered table-hover dataTable" role="grid" aria-describedby="products">
            <thead>
            <tr class="bg-secondary">
              <th style="width: 150px;">Emp. Name</th>
              <th style="width: 140px;">Design.</th>
              <th>T. S.In Qty</th>
              <th>T. S.Out Qty</th>
              <th>T. Purchased({{$settings->currency_symbol}})</th>
              <th>T. Sold({{$settings->currency_symbol}})</th>
            </tr>
            </thead>
            <tbody id="load_records">

            </tbody>
          </table>
        </div>
        <div class="stockin_stockout_overlay overlay" style="display: none;">
          <i class="fas fa-2x fa-sync-alt"></i>
        </div>
        <!-- /.card-body -->
      </div>
      <!-- /.card -->
      <div class="card card-outline card-primary">
        <div class="card-header">
          <h3 class="card-title"><a href="{{ url('/reports/salesInvoices') }}" class="text-dark">Latest Sales Invoices</a></h3>

          <div class="card-tools">
            <button type="button" class="btn btn-tool" data-card-widget="collapse"><i class="fas fa-minus"></i>
            </button>
          </div>
          <!-- /.card-tools -->
        </div>
        <!-- /.card-header -->
        <div class="card-body table-responsive scroll">
          <table id="products" class="table table-sm table-striped table-bordered table-hover dataTable" role="grid" aria-describedby="products">
            <thead>
            <tr class="bg-secondary">
              <th style="width: 68px;">Date</th>
              <th>Inv No</th>
              <th style="width: 170px;">Ship to</th>
              <th>T. Qty</th>
              <th>T. Amount({{$settings->currency_symbol}})</th>
              <th>Sold By</th>
            </tr>
            </thead>
            <tbody>
              @if(count($sales_invoices))
                @foreach($sales_invoices as $sales_invoice)
                <tr>
                  <td>{{ $sales_invoice->sales_date }}</td>
                  <td>{{ $sales_invoice->inv_no }}</td>
                  <td>{{ $sales_invoice->ship_to }}</td>
                  <td>{{ $sales_invoice->total_qty }}</td>
                  <td>{{ number_format($sales_invoice->totalAmount,2) }}</td>
                  <td>{{ $sales_invoice->sold_by }}</td>
                </tr>
                @endforeach
                @else
                <tr>
                  <td colspan="6" class="text-center">No data found!!</td>
                </tr>
                @endif
            </tbody>
          </table>
        </div>
        <!-- /.card-body -->
      </div>
      <!-- /.card -->
      <div class="card card-outline card-primary">
        <div class="card-header">
          <h3 class="card-title"><a href="{{ url('/reports/localInvoices') }}" class="text-dark">Latest Local Invoices</a></h3>

          <div class="card-tools">
            <button type="button" class="btn btn-tool" data-card-widget="collapse"><i class="fas fa-minus"></i>
            </button>
          </div>
          <!-- /.card-tools -->
        </div>
        <!-- /.card-header -->
        <div class="card-body table-responsive scroll">
          <table id="products" class="table table-sm table-striped table-bordered table-hover dataTable" role="grid" aria-describedby="products">
            <thead>
            <tr class="bg-secondary">
              <th style="width: 68px;">Date</th>
              <th>Inv No</th>
              <th style="width: 170px;">Customer Details</th>
              <th>T. Qty</th>
              <th>T. Amount({{$settings->currency_symbol}})</th>
              <th>Sold By</th>
            </tr>
            </thead>
            <tbody>
            @if(count($local_invoices))
              @foreach($local_invoices as $local_invoice)
                <tr>
                  <td>{{ $local_invoice->sales_date }}</td>
                  <td>{{ $local_invoice->inv_no }}</td>
                  <td>{{ $local_invoice->ship_to }}</td>
                  <td>{{ $local_invoice->total_qty }}</td>
                  <td>{{ number_format($local_invoice->totalAmount,2) }}</td>
                  <td>{{ $local_invoice->sold_by }}</td>
                </tr>
              @endforeach
            @else
              <tr>
                <td colspan="6" class="text-center">No data found!!</td>
              </tr>
            @endif
            </tbody>
          </table>
        </div>
        <!-- /.card-body -->
      </div>
      <!-- /.card -->
      <div class="card card-outline card-primary">
        <div class="card-header">
          <h3 class="card-title"><a href="{{ url('/reports/statements') }}" class="text-dark">Latest Statements</a></h3>

          <div class="card-tools">
            <button type="button" class="btn btn-tool" data-card-widget="collapse"><i class="fas fa-minus"></i>
            </button>
          </div>
          <!-- /.card-tools -->
        </div>
        <!-- /.card-header -->
        <div class="card-body table-responsive scroll">
          <table id="products" class="table table-sm table-striped table-bordered table-hover dataTable" role="grid" aria-describedby="products">
            <thead>
            <tr class="bg-secondary">
              <th style="width: 68px;">Date</th>
              <th>Title</th>
              <th style="width: 170px;">Ref. File</th>
              <th>Amount({{$settings->currency_symbol}})</th>
              <th>Action By</th>
            </tr>
            </thead>
            <tbody>
            @if(count($statements))
              @foreach($statements as $statement)
                <tr>
                  <td>{{ $statement->s_date }}</td>
                  <td>{{ $statement->title }}</td>
                  <td><a href="{{ asset('/') }}{{ $statement->ref_file }}" target="_blank"><i class="fas fa-download"></i> Download file</a></td>
                  <td>{{ number_format($statement->amount,2) }}</td>
                  <td>{{ $statement->action_by }}</td>
                </tr>
              @endforeach
            @else
              <tr>
                <td colspan="6" class="text-center">No data found!!</td>
              </tr>
            @endif
            </tbody>
          </table>
        </div>
        <!-- /.card-body -->
      </div>
      <!-- /.card -->
    </div>
    <div class="col-md-6">
      <div class="card card-outline card-warning">
        <div class="card-header">
          <h3 class="card-title"><a href="{{ url('/reports/soldProducts') }}" class="text-dark">Latest Sold Products</a></h3>

          <div class="card-tools">
            <button type="button" class="btn btn-tool" data-card-widget="collapse"><i class="fas fa-minus"></i>
            </button>
          </div>
          <!-- /.card-tools -->
        </div>
        <!-- /.card-header -->
        <div class="card-body table-responsive scroll">
          <table id="products" class="table table-sm table-striped table-bordered table-hover dataTable" role="grid" aria-describedby="products">
            <thead>
            <tr class="bg-secondary">
              <th style="width: 68px;">Date</th>
              <th>Name</th>
              <th>Type</th>
              <th>T. Qty</th>
              <th>T. Amount({{$settings->currency_symbol}})</th>
              <th>Sold By</th>
            </tr>
            </thead>
            <tbody>
            @if(count($sold_products))
              @foreach($sold_products as $sold_product)
                <tr>
                  <td>{{ $sold_product->sales_date }}</td>
                  <td>{{ $sold_product->item_name }}</td>
                  <td>@if($sold_product->type == "Cars") <span class='right badge badge-success'>{{ $sold_product->type }}</span> @else <span class='right badge badge-info'>{{ $sold_product->type }}</span> @endif</td>
                  <td>{{ $sold_product->qty }}</td>
                  <td>{{ number_format($sold_product->total,2) }}</td>
                  <td>{{ $sold_product->sold_by }}</td>
                </tr>
              @endforeach
            @else
              <tr>
                <td colspan="6" class="text-center">No data found!!</td>
              </tr>
            @endif
            </tbody>
          </table>
        </div>
        <!-- /.card-body -->
      </div>
      <!-- /.card -->

      <div class="card card-outline card-danger">
        <div class="card-header">
          <h3 class="card-title"><a href="{{ url('/reports/stockins') }}" class="text-dark">Latest Stock-ins</a></h3>
          <div class="card-tools">
            <button type="button" class="btn btn-tool" data-card-widget="collapse"><i class="fas fa-minus"></i>
            </button>
          </div>
        </div>
        <div class="card-body table-responsive scroll">
          <table id="products" class="table table-sm table-striped table-bordered table-hover dataTable" role="grid" aria-describedby="products">
            <thead>
            <tr class="bg-secondary">
              <th style="width: 68px;">Date</th>
              <th>Name</th>
              <th>Type</th>
              <th>T. Qty</th>
              <th>T. Amount({{$settings->currency_symbol}})</th>
              <th>Stockin By</th>
            </tr>
            </thead>
            <tbody>
            @if(count($stockins))
              @foreach($stockins as $stockin)
                <tr>
                  <td>{{ $stockin->stockin_date }}</td>
                  <td>{{ $stockin->item_name }}</td>
                  <td>@if($stockin->type == "Cars") <span class='right badge badge-success'>{{ $stockin->type }}</span> @else <span class='right badge badge-info'>{{ $stockin->type }}</span> @endif</td>
                  <td>{{ $stockin->qty }}</td>
                  <td>{{ number_format($stockin->total,2) }}</td>
                  <td>{{ $stockin->stockin_by }}</td>
                </tr>
              @endforeach
            @else
              <tr>
                <td colspan="6" class="text-center">No data found!!</td>
              </tr>
            @endif
            </tbody>
          </table>
        </div>
        <!-- /.card-body -->
      </div>
      <!-- /.card -->
      <div class="card card-outline card-primary">
        <div class="card-header">
          <h3 class="card-title"><a href="{{ url('/employees') }}" class="text-dark">All Employees</a></h3>

          <div class="card-tools">
            <button type="button" class="btn btn-tool" data-card-widget="collapse"><i class="fas fa-minus"></i>
            </button>
          </div>
          <!-- /.card-tools -->
        </div>
        <!-- /.card-header -->
        <div class="card-body table-responsive scroll">
          <table id="products" class="table table-sm table-striped table-bordered table-hover dataTable" role="grid" aria-describedby="products">
            <thead>
            <tr class="bg-secondary">
              <th>Name</th>
              <th>Designation</th>
              <th>Phone</th>
              <th>Email</th>
              <th>Address</th>
            </tr>
            </thead>
            <tbody>
            @if(count($employees))
              @foreach($employees as $employee)
                <tr>
                  <td>{{ $employee->emp_name }}</td>
                  <td>{{ $employee->emp_designation }}</td>
                  <td>{{ $employee->emp_phone }}</td>
                  <td>{{ $employee->emp_email }}</td>
                  <td>{{ $employee->emp_address }}</td>
                </tr>
              @endforeach
            @else
              <tr>
                <td colspan="6" class="text-center">No data found!!</td>
              </tr>
            @endif
            </tbody>
          </table>
        </div>
        <!-- /.card-body -->
      </div>
      <!-- /.card -->
    </div>
    <!-- /.col -->
  </div>
  <!-- /.row -->
  <!-- Main row -->

  <!-- /.row -->
@endsection

@section('script_links')
  <script>
    $(function () {
      // active left-menu
      // for tree addClass .menu-open
      // for submenu addClass .active
      $('#sub_dashboard').addClass('active');

      // stockin_vs_stockout summary table
      var days = $("#days").val();
      load_stockin_stockout(days);

      $("#days").change(function () {
        var days = $(this).val();
        load_stockin_stockout(days);
      });

      function load_stockin_stockout(days){
        $.ajax({
          method: "POST",
          url: "{{ url('/get_stockin_stockout_records') }}",
          data: { _token: "{{ csrf_token() }}", days :days },
          beforeSend: function() {
            $(".stockin_stockout_overlay").show();
          },
          complete: function(){
            $(".stockin_stockout_overlay").hide();
          },
          success: function(data) {
            $("#load_records").html(data);
          }
        })
      }
    });
  </script>
@endsection