@extends('layouts.appori')

@section('title', ' - Reports')

@section('content')
  @php
    $startdate = request()->startdate;
    $enddate = request()->enddate;
    $manager_id = request()->manager_id;
  @endphp

 <div class="container">

  <div class="card">

    <div class="card-header text-center font-weight-bold">
      <h5 class="card-title"> N.L.M Myawaddy Logisitcs Co.,Ltd </h5>
      <h5 class="card-title">Kaw Thaung Office </h5>
      <h5 class="card-title">Export List </h5>
      @if($startdate=="")
        <h5 class="card-title">({{ \Carbon\Carbon::now()->format('M, Y') }} )</h5>
      @endif
      @if($startdate<>"")
        <h5 class="card-title">({{ "From ". \Carbon\Carbon::parse($startdate)->format('d-m-Y')  ." To ". \Carbon\Carbon::parse($enddate)->format('d-m-Y') }} ) </h5>
      @endif
      
    </div>
    
    <div class="card-body">
      <form action="{{ url('/reports/view/ktfilter')}}">
        @csrf
        <div class="row">
          <div class="col-3">
            <div class="form-gorup">
              <label for="name">From :</label>
                <div class="input-group">
                  <input type="date" name="startdate" class="form-control" value="{{ $startdate }}" required>
                </div>               
            </div>
          </div>

          <div class="col-3">
            <div class="form-gorup">
              <label for="name">To :</label>
                <div class="input-group">
                  <input type="date" name="enddate" class="form-control" value="{{ $enddate }}" required>
                </div>           
            </div>
          </div>
          
          <div class="col-3">
            <div class="form-gorup">
              <label for="name">Manager</label>
                <div class="input-group">
                  <select name="manager_id" class="form-control">
                    <option value="0" @if($manager_id==0)
                      {{"Selected"}}
                    @endif>All</option>
                    @foreach ($managers as $manager)
                      <option value="{{$manager->id}}" @if($manager_id==$manager->id)
                        {{"Selected"}}
                      @endif>{{ $manager->name }}</option>
                    @endforeach
                  </select>
                </div>           
            </div>
          </div>

          <div class="col-3">
            <div class="form-gorup">
              <label for="name"><i class="fas fa-search"></i></label>
                <div class="input-group">
                  <input type="submit" class="btn btn-primary" value="View">
                </div>              
            </div>
          </div>
        </div>

      </form>
    </div>

    <div class="card-body">
      <div class="table-responsive">
        <table class="table table-bordered table-striped" id="tblReport">
          <thead class="table-primary">
            <tr align="center" hidden>
              <td colspan="11">Myawaddy Logisitcs Co.,Ltd </td>
            </tr>
            <tr align="center" hidden>
              <td colspan="11">Kaw Thaung Office </td>
            </tr>
            <tr align="center" hidden>
              <td>
              @if($startdate=="")
                <h5 class="card-title">({{ \Carbon\Carbon::now()->format('M, Y') }} )</h5>
              @endif
              @if($startdate<>"")
                <h5 class="card-title">({{ "From ". \Carbon\Carbon::parse($startdate)->format('d-m-Y')  ." To ". \Carbon\Carbon::parse($enddate)->format('d-m-Y') }} ) </h5>
              @endif
              </td>
            </tr>
            
            <tr align="center">
            <td>Sr</td>
            <td>Manager</td>
            <td>Date</td>
            <td>Invoice</td>
            <td>Export Licence</td>
            <td>ED</td>
            {{-- ===== <td>Total Weight</td> ==== --}}
            <td>Values(USD)</td>
            <td>FE Rate</td>
            <td>Values(THB)</td>
            <td>Selling Rate</td>
            <td>Selling Value (THB)</td>
            </tr>
          </thead>
          <tbody class="table-group-divider">
            @php 
              $totusd=0;
              $totthbamt=0;
              $totthb=0;
            @endphp
            
            @foreach ($exports as $exp)
            
              <tr>
                <td align="center">{{ $i }}</td>
                <td align="left">{{ $exp->manager->name }}</td>
                <td align="center">{{ \Carbon\Carbon::parse($exp->eddate)->format('d-m-Y') }} </td>       
                <td align="left">{{ $exp->invno }}</td>
                <td align="left">{{ $exp->elno }}</td>
                <td align="left">{{ $exp->edno }}</td>
                {{-- <td align="right">{{ $exp->weight }}</td> --}}
                <td align="right">{{ number_format($usd = $exp->value,2) }}</td>
                <td align="center"> {{ $exp->thbrate }} </td>
                <td align="right">{{ number_format($thbamt = $exp->value * $exp->thbrate,2) }}</td>
                <td align="center">{{ $exp->sellingrate . " %" }}</td>
                <td align="right">{{ number_format($thb = ($exp->sellingrate * $thbamt)/100,2) }}</td>
              </tr>

              @php
                $i++;
                $totusd += $usd;
                $totthbamt += $thbamt;
                $totthb += $thb;
              @endphp
            @endforeach
              
          </tbody>

          <tfoot class="table-group-divider">
            <tr class="table-primary">
                <td align="center"></td>
                <td align="left">TOTAL</td>
                <td align="center"> </td>       
                <td align="left"></td>
                <td align="left"></td>
                <td align="left"></td>
                {{-- <td align="right">{{ $exp->weight }}</td> --}}
                <td align="right">{{ number_format($totusd,2) }}</td>
                <td align="center"> </td>
                <td align="right">{{ number_format($totthbamt,2) }}</td>
                <td align="center"></td>
                <td align="right">{{ number_format($totthb,2) }}</td>
            </tr>
          </tfoot>

        </table>
      </div>     
    </div>

    <div class="card-footer">
      <button onclick="exportTableToExcel('tblReport', 'Export')" class="btn btn-success ml-2">Export To Excel File</button>
    </div>

  </div>

  
 </div>
@endsection