@extends('layouts.app')

@section('header')
<div class="card borderless-card">
  <div class="card-block primary-breadcrumb">
    <div class="breadcrumb-header">
      <h5>Report</h5>
    </div>
    <div class="page-header-breadcrumb">
      <ul class="breadcrumb-title">
        <li class="breadcrumb-item">
          <a href="{{ \URL::to('/')}}">
            <i class="fas fa-home"></i>
          </a>
        </li>
        <li class="breadcrumb-item"><a href="/report/generate"><i class="fa fa-line-chart"></i> Generate Report</a></li>
        <li class="breadcrumb-item"><a href="#">Report</a>
        </li>
      </ul>
    </div>
  </div>
</div>

@endsection


@section('content')

<style type="text/css">
  th,td {
      text-align: center;
  }
</style>



<div class="card">
  <div class="card-block">

    <form class="form-horizontal generate_report_inline" role="form" method="GET" action="{{ url('/report/view_report') }}">
      <div class="row">
      <div class="col-md-4">
        <div class="form-group">
          <label>Report Type</label>
            <select class="form-control inline_report_type" name="report_type">
              <option selected="" disabled="" value="">- Select -</option>
              <option value="1" @if($data['report_type'] == 1) selected="" @endif>Quotation</option>
              <option value="2" @if($data['report_type'] == 2) selected="" @endif>Quotation List</option>
              <option value="3" @if($data['report_type'] == 3) selected="" @endif>Sales</option>
              <option value="4" @if($data['report_type'] == 4) selected="" @endif>Sales List</option>
              <option value="5" @if($data['report_type'] == 5) selected="" @endif>Purchase Order</option>
              <option value="6" @if($data['report_type'] == 6) selected="" @endif>Purchase Order List</option>
              <option value="7" @if($data['report_type'] == 7) selected="" @endif>Tax Invoice</option>
              <option value="8" @if($data['report_type'] == 8) selected="" @endif>Tax Invoice List</option>
              <option value="9" @if($data['report_type'] == 9) selected="" @endif>Delivery Notes</option>
              <option value="10" @if($data['report_type'] == 10) selected="" @endif>Delivery Notes List</option>
              <option value="11" @if($data['report_type'] == 11) selected="" @endif>Advance Delivery Notes</option>
              <option value="12" @if($data['report_type'] == 12) selected="" @endif>Advance Delivery Notes List</option>
              <option value="13" @if($data['report_type'] == 13) selected="" @endif>Outstanding Report</option>
              <option value="14" @if($data['report_type'] == 14) selected="" @endif>Payable Report</option>
            </select>
        </div>      
      </div>

      <div class="col-md-4">
        <div class="form-group">
          <label>From</label>
          <div class="input-group date">
            <div class="input-group-addon">
              <i class="fa fa-calendar"></i>
            </div>
            <input type="text" class="form-control pull-right inline_datepicker_from from" name="from" value="{{ date('d-m-Y',strtotime($data['from']))  }}" autocomplete="off">
          </div>
        </div>
      </div>

      <div class="col-md-4">
        <div class="form-group">
          <label>To</label><br>
          <div class="input-group date">
            <div class="input-group-addon">
              <i class="fa fa-calendar"></i>
            </div>
            <input type="text" class="form-control pull-right inline_datepicker_to to" name="to" value="{{ $data['to']  }}" autocomplete="off">
          </div>
        </div>
      </div>
      </div>
    </form>

    <section class="invoice">
    <!-- title row -->
    <div class="row">
      <div class="col-xs-12">
        <h2 class="page-header">

          @php
            $headerTitle = ''; 

            if($data['report_type'] == 1)
              $headerTitle = 'Quotation ('. date("jS F Y", strtotime($data['from'])) .' to '. date("jS F Y", strtotime($data['to'])) .') '; 
            elseif($data['report_type'] == 2)
              $headerTitle = 'Quotation List ('. date("jS F Y", strtotime($data['from'])) .' to '. date("jS F Y", strtotime($data['to'])) .') '; 
            elseif($data['report_type'] == 3)
              $headerTitle = 'Sales Report ('. date("jS F Y", strtotime($data['from'])) .' to '. date("jS F Y", strtotime($data['to'])) .') '; 
            elseif($data['report_type'] == 4)
              $headerTitle = 'Sales Report List ('. date("jS F Y", strtotime($data['from'])) .' to '. date("jS F Y", strtotime($data['to'])) .') '; 
            elseif($data['report_type'] == 5)
              $headerTitle = 'Purchase Order Report ('. date("jS F Y", strtotime($data['from'])) .' to '. date("jS F Y", strtotime($data['to'])) .') '; 
            elseif($data['report_type'] == 6)
              $headerTitle = 'Purchase Order Report List ('. date("jS F Y", strtotime($data['from'])) .' to '. date("jS F Y", strtotime($data['to'])) .') '; 
            elseif($data['report_type'] == 7)
              $headerTitle = 'Tax Invoice Report ('. date("jS F Y", strtotime($data['from'])) .' to '. date("jS F Y", strtotime($data['to'])) .') '; 
            elseif($data['report_type'] == 8)
              $headerTitle = 'Tax Invoice Report List ('. date("jS F Y", strtotime($data['from'])) .' to '. date("jS F Y", strtotime($data['to'])) .') '; 
            elseif($data['report_type'] == 9)
              $headerTitle = 'Delivery Notes Report ('. date("jS F Y", strtotime($data['from'])) .' to '. date("jS F Y", strtotime($data['to'])) .') ';
            elseif($data['report_type'] == 10)
              $headerTitle = 'Delivery Notes Report List ('. date("jS F Y", strtotime($data['from'])) .' to '. date("jS F Y", strtotime($data['to'])) .') ';
            elseif($data['report_type'] == 11)
              $headerTitle = 'Advance Delivery Notes Report ('. date("jS F Y", strtotime($data['from'])) .' to '. date("jS F Y", strtotime($data['to'])) .') ';
            elseif($data['report_type'] == 12)
              $headerTitle = 'Advance Delivery Notes Report List ('. date("jS F Y", strtotime($data['from'])) .' to '. date("jS F Y", strtotime($data['to'])) .') ';
            elseif($data['report_type'] == 13)
              $headerTitle = 'Outstanding Report ('. date("jS F Y", strtotime($data['from'])) .' to '. date("jS F Y", strtotime($data['to'])) .') ';
            elseif($data['report_type'] == 14)
              $headerTitle = 'Payable Report ('. date("jS F Y", strtotime($data['from'])) .' to '. date("jS F Y", strtotime($data['to'])) .') ';
          @endphp

          
        </h2>
      </div>
      <!-- /.col -->
    </div>
    

    <!-- Table row -->
    <div class="row">
      <div class="table-responsive" style="width:99%;margin-left:5px">
        <table id="dt-purchase_report"  class="table table-striped">
          <thead>
            <tr><th  colspan={{ count($params) }}> {{ $headerTitle }} </th></tr>
          <tr>
            @foreach($params as $key => $param)
              <th>
                  {{ $param }}
              </th>
            @endforeach
          </tr>
          </thead>
          <tbody>
            @foreach($transaction as $atransaction)
              <tr>
                <td>{{ $loop->iteration }} </td>
                @foreach($atransaction as $key => $atransactionvalue)
                  @if(strpos($key, 'date') !== false)
                      <td>{{ date('d-m-Y', strtotime($atransactionvalue)) }} </td>
                    @else
                      <td>{{ $atransactionvalue }} </td>
                  @endif

                  
                @endforeach
              </tr>
            @endforeach
          </tbody>
        </table>
      </div>
      <!-- /.col -->
    </div>
    <!-- /.row -->
  </section>
</div>
</div>
@endsection

@section('scripts')
@include('layouts.datatables_only_files')

<script type="text/javascript">

$(document).ready(function() {

  var headerTitle = "{!! addcslashes($headerTitle, '"') !!}";


    var dt = $('#dt-purchase_report').DataTable( {
        dom: 'Bfrtip',
        paging:   false,
        ordering: false,
        info:     false,
        buttons: [{
          extend: 'excel',
          header: true,
          messageTop: function () {
              return headerTitle;
          }
        },{
          extend: 'pdf',
          header: true,
          messageTop: function () {
              return headerTitle;
          }
        },{
          extend: 'print',
          header: true,
          messageTop: function () {
              return headerTitle;
          }
        }]
    });
});


</script>
@endsection