@extends('layouts.deliverymanagerapp')

@section('content')

{{-- Reports --}}

<div class="card mb-4">
      <div class="card-header">
              <div class="d-flex">
                      <div class="mr-auto p-2 align-self-center"><h4>Reports</h4></div>
              </div>       
              <form method="POST" action="{{route('searchDetailedOrderreport')}}">
              @csrf
              @method('post')
              <div class="border-top pt-3">
                      <div class="row">
                            <div class="col-lg-2 col-sm-2">
                            <label for="txtsponser" style="margin-bottom:0;">Store</lable>                            
                            <div class="form-group w-30">                               
                                              <select id="selectgrp" class="form-control @error('store_id')   @enderror" id="Store" name="store_id">
                                                     
                                                      <option value="0">--All--</option>
                                                      @php
                                                              echo App\Http\Controllers\StoreController::StoreListForCombo(0);
                                                      @endphp 
                                              </select> 
                                      </div>
                            </div>
                              <div class="col-lg-2 col-sm-2">
                              <label for="txtsponser" style="margin-bottom:0;">Status</label>                                
                                      <div class="form-group w-30">                                                                             
                                              <select id="selectgrp" class="form-control @error('status_id')   @enderror" id="cbStatus" name="status_id">
                                                  
                                                    <option value="0">--All--</option>
                                                      @php
                                                              echo App\Http\Controllers\StatusController::StatusListForCombo(0);
                                                      @endphp 
                                              </select> 
                                      </div>
                              </div>

                              <div class="col-lg-2 col-sm-2">
                              <label for="txtsponser" style="margin-bottom:0;">Sort by Day</label>                          
                                      <div class="form-group w-30">                                       
                                              <select id="selectgrp" class="form-control @error('datesort')   @enderror" id="cbDateSort" name="datesort" onchange="dmy_onchange(this.value)" >
                                                      <!-- <option value="" disabled selected>Sort by Day</option> -->
                                                      <option value="day">Day</option>
                                                      <option value="month">Month</option>
                                                      <option value="year">Year</option>
                                                      <option value="2">Between Two Dates</option>
                                              </select> 
                                      </div>
                              </div> 

                              <input type="hidden" value="0" name="print">

                              <div class="col-lg-4 form-group" id="divdmy" style="display:none;">
                                      <label for="txtSDate" id="lbltxtDate">Date</label>
                                      <input class="form-control" type="date" name="txtSDate" id="txtSDate" oninput="view()" placeholder="dsate" />
                                      <label for="txtSDate1" id="lbltxtSDate2" style="display:none;">Date2</label>
                                      <input class="form-control" type="date" style="display: none;" name="txtSDate1" id="txtSDate1" oninput="view()" placeholder="dsate" />
                                      <label id="lblnmbYear" for="nmbYear" style="display: none;">Year</label>
                                      <input type="number" name="nmbYear" oninput="view()" id="nmbYear" value="2020" class="form-control" min="1900" max="3000" style="display: none;"/>
                              </div>                   
                      </div>
              </div>
              <div class="d-flex justify-content-end font-weight-bold">
                      <button type="submit" class="btn btn-primary"><i class="fas fa-search"></i> Search</button>
              </div>
              </form>
      </div>
      <div class="card-body">
              <div class="table-responsive" >
                      <table class="table table-hover" id="search_tbl">
                              <thead>
                                      <tr>
                                              <th>SLNO.</th>
                                              <th>Order No.</th>
                                              <th>Order Date</th>
                                              <th>Delivery date</th>
                                        {{-- <th>Store</th>
                                              <th>Store Contact</th>
                                              <th>Customer</th>
                                              <th>Customer Contact</th> --}}
                                              <th>Status</th>
                                              <!-- <th>Duration</th>  -->
                                              <th colspan="">Details</th>
                                              <th></th>
                                      </tr>
                              </thead>
                              <tbody> 
                                 <!-- $Result is Order  -->
                                    @if($Results)
                                        @php $i=1; @endphp              
                                     @foreach($Results as $Result)
                                      <tr>      
                                                <td>{{$i++}}</td>
                                              <td>#{{$Result->id}}</td>
                                              @php $Orderdate = date("F j, Y, g:i a",strtotime($Result->created_at));@endphp                                            
                                              <td>{{$Orderdate}}</td>
                                             @if($Result->orderdelivery)
                                                @if($Result->orderdelivery->isCompleted == 1)
                                                @php $Deliverydate = date("F j, Y, g:i a",strtotime($Result->orderdelivery->completingperiod));@endphp
                                               <td>{{$Deliverydate}}</td>
                                                @else
                                                <td>time to complete</td> 
                                                @endif                                         
                                              @else                                          
                                                <td>Not delivered</td>                                           
                                              @endif                                        
                                              <td>{{$Result->status->status}}</td>
                                              <!-- Detailed description -->
                                                <td>
                                                    <table>
                                                        <tr>
                                                            <th><p>Store:<span> {{$Result->store->title}}</span><br>Contact:<span> {{$Result->store->user->whatsapp}}</span></th>                                                           
                                                            <th><p>Customer:<span> {{$Result->user->name}}</span><br>Contact:<span> {{$Result->user->mobile->mobile}}</span></th>                                                            
                                                        </tr>
                                                    </table>

                                                    @if($Result->orderdetails)
                                                    <table>
                                                            <tr>
                                                                <th>No.</th>
                                                                <th>product</th>
                                                                <th>price</th>
                                                                <th>qty</th>
                                                                <th>total</th>
                                                            </tr>
                                                       @php $i=1;  $total = 0; @endphp
                                                        @foreach($Result->orderdetails as $item)
                                                            <tr>
                                                                 <td>{{$i++}}</td>
                                                                <td>{{$item->product->title}}</td>
                                                                <td>{{$item->product->sales_amount}}</td>
                                                                <td>{{$item->quantity}}</td>
                                                                @php 
                                                                    $amount =$item->product->sales_amount;
                                                                    $qty = $item->quantity; 
                                                                    $total += $amount*$qty;                                                                  
                                                                      @endphp
                                                                <td>{{$amount*$qty}}</td>
                                                                                                                             
                                                            </tr>                                                           
                                                        @endforeach
                                                          <tr>
                                                          <tr>
                                                                <td></td>
                                                                <td></td>
                                                                <td></td>
                                                                <td>Grand Total</td>
                                                                <td>{{$total}}</td>
                                                          </tr>
                                                    </table>
                                                    @endif

                                                </td> 
                                                <!-- end detailed description -->                               
                                      </tr>
                                      @endforeach
                                      @endif 
                              </tbody>                              
                      </table>
              </div>
      </div>
      <div class="card-footer">
              <div class="row">
                      <div class="col-lg-6">
                              <div class="d-flex justify-content-start font-weight-bold">
                              <a href=""><button class="btn btn-danger">Save Pdf</button></a>         
                              </div>
                      </div>                      
                      <div class="col-lg-6">
                              <div class="d-flex justify-content-end font-weight-bold">
                            {{--  <div> {{ $Results->links() }}</div>   --}}
                            <form method="POST" action="{{route('searchDetailedOrderreport')}}">
                                @csrf
                                @method('post')
                                        <input type="hidden" value="{{$store_id}}" name="store_id">
                                        <input type="hidden" value="{{$status_id}}" name="status_id">
                                        <input type="hidden" value="{{$datesort}}" name="datesort">
                                        <input type="hidden" value="{{$txtSDate}}" name="txtSDate">
                                        <input type="hidden" value="{{$txtSDate1}}" name="txtSDate1">
                                        <input type="hidden" value="1" name="print">
                                        <input type="hidden" value="{{$nmbYear}}" name="nmbYear">
                                      <button type="submit" class="btn btn-primary">Print</button> 
                                </form>     
                              </div>
                      </div>
              </div>                       
      </div>
</div>

@endsection

<script>

{{--function clicks() {

var items = document.getElementById("selectgrp").value;       

$.ajax({
  url: '{{ route('selectReports') }}', 
  method: "get",
  data: {_token: '{{ csrf_token() }}',searchitems:items },
                                                  success: function (response){     

                                                      document.getElementById('search_tbl').innerHTML=response; 
                                                  
                                                                  }
                                  });   

} --}}




function dmy_onchange(dmy)
{
      //reset
      $('#divdmy').attr('style','display:block;');
      
      $('#lbltxtDate').attr('style','display:none;');
      $('#txtSDate').attr('style','display:none;');
      document.getElementById('lbltxtDate').innerHTML="Date";
      $('#txtSDate').attr('type','date');
      $('#lbltxtSDate2').attr('style','display:none;');       
      $('#txtSDate1').attr('style','display:none;');
      $('#lblnmbYear').attr('style','display:none;');
      $('#nmbYear').attr('style','display:none;');
      switch(dmy)
      {
              case '0':
                        $('#divdmy').attr('style','display:none;');
                      break;
              case 'day':
                      $('#lbltxtDate').attr('style','display:block;');
                      $('#txtSDate').attr('style','display:block;');
                      break;
              case '2':
                      $('#lbltxtDate').attr('style','display:block;');
                      $('#txtSDate').attr('style','display:block;');
                      $('#lbltxtSDate2').attr('style','display:block;');
                      document.getElementById('lbltxtDate').innerHTML="From";
                      document.getElementById('lbltxtSDate2').innerHTML="To";
                      $('#txtSDate1').attr('style','display:block;');
                      break;
              case 'month':
                      $('#lbltxtDate').attr('style','display:block;');
                      $('#txtSDate').attr('style','display:block;');
                      document.getElementById('lbltxtDate').innerHTML="Month";
                      $('#txtSDate').attr('type','month');
                      break;
              case 'year':
                      $('#lblnmbYear').attr('style','display:block;');
                      $('#nmbYear').attr('style','display:block;');
                      break;
      }
}


</script>