@extends('layouts.backend')

@section('extraCss')
<style>
       .table thead > tr > th, .table tbody > tr > th, .table tfoot > tr > th, .table thead > tr > td, .table tbody > tr > td, .table tfoot > tr > td {
    padding: 14px;
    font-size: 14px;
}
</style>
@endsection

@section('mainContentArea')

<div class="card card-default">
    <div class="card-header">
        <h4>Barcode Tracking</h4>
    </div>

    <div class="alert alert-default">

        <form  method="get" action="{{ route('barcode-tracking') }}">
        @csrf
            <p>Enter Barcodes line by line:</p>
            <p><textarea name="barcode" class="form-control" id="barcode" cols="10" rows="2" style="width: 100%;" required></textarea></p>
           
            <button type="submit">Submit</button>
        </form>
                  
</div>
</div>

<div class="card card-default">
    <div class="card-header">
        <h4>Barcode Tracking Details</h4>
    </div>
    <div class="alert alert-default">
       
       <table class="table table-bordered data-table">
            <thead>
                <tr>
                    <th>#</th>
                    <th>Source</th>
                    <th>barcode</th>
                    <th>Article</th>
                    <th>Color</th>
                    <th>Size</th>
                    <th>Mrp</th>
                    <th>From_type</th>
                    <th>From</th>
                    <th>TO</th>
                    <th>Date</th>
                    <th>REF</th>
                </tr>
            </thead>
            <tbody>
             @php             
              ini_set('memory_limit', '-1');
                    function date_compare($element1, $element2) {
                        $datetime1 = strtotime($element1['date']);
                        $datetime2 = strtotime($element2['date']);
                        return $datetime1 - $datetime2;
                    } 
                 @endphp
                            @foreach($barcodeHistory as $barcodeh)
               @php
               usort($barcodeh, 'date_compare');
               @endphp
                @foreach($barcodeh as $bar=>$bar_value)                
                @php 
                //dump($bar_value);
                    $wpro=\DB::table('oc_warehouse_product')
                    ->select([
                            'oc_warehouse_product.barcode',
                            'oc_warehouse_product.article',
                            'oc_warehouse_product.color',
                            'oc_warehouse_product.size',
                            'oc_warehouse_product.mrp',            
                            ])                                 
                    ->where('oc_warehouse_product.barcode','=',$bar_value['barcode'])
                    ->first();
                @endphp               
                    @if($role_id == 3  || $role_id == 7 ||  in_array($role_id,array(20,21,27,57,56,52)))                                                          
                <tr>
                    <td>{{ $counter++ }} </td>
                    <td>{{ $bar_value['source'] }}</td>
                    <td>{{ $bar_value['barcode'] }}</td>
                    <td>{{  $wpro->article  }}</td>
                    <td>{{  $wpro->color  }}</td>
                    <td>{{  $wpro->size }}</td>
                    <td>{{  $wpro->mrp  }}</td>                

                    <td>{{ $bar_value['from_type'] }}</td>
                    <td> @php                           
                      if($bar_value['from_type'] == "GR party" || $bar_value['from_type'] == "Supplier to Warehouse" || $bar_value['from_type'] == "Warehouse to Party"){
                          if($bar_value['from'] ==1 || $bar_value['from'] ==2){
                                  $sql=\DB::table('oc_warehouses')->where('id',$bar_value['from'])->first();                                      
                                  $name = !empty($sql) ? $sql->name : $bar_value['from']; 
                                  print_r($name);
                                   
                          } else{
                              $sql=\DB::table('oc_wh_suppliers')->where('id',$bar_value['from'])->first();
                              $name = !empty($sql) ? $sql->company_name : $bar_value['from']; 
                                  print_r($name);                                   
                          }  
                        
                      }else{
                          $sql=\DB::table('oc_warehouses')->where('id',$bar_value['from'])->first(); 
                            $name = !empty($sql) ? $sql->name : $bar_value['from']; 
                            print_r($name);                                    
                          
                      }
                        @endphp    
                </td>
                <td>@php                       
                  if($bar_value['from_type'] == "GR party" || $bar_value['from_type'] == "Supplier to Warehouse" || $bar_value['from_type'] == "Warehouse to Party"){
                          if($bar_value['to'] ==1 || $bar_value['to'] ==2){
                                  $sql=\DB::table('oc_warehouses')->where('id',$bar_value['to'])->first();                                      
                                  $name = !empty($sql) ? $sql->name : $bar_value['to']; 
                                  print_r($name);
                                   
                          } else{
                              $sql=\DB::table('oc_wh_suppliers')->where('id',$bar_value['to'])->first();
                              $name = !empty($sql) ? $sql->company_name : $bar_value['to']; 
                                  print_r($name);                                   
                          }  
                        
                      }else{
                          $sql=\DB::table('oc_warehouses')->where('id',$bar_value['to'])->first(); 
                            $name = !empty($sql) ? $sql->name : $bar_value['to']; 
                            print_r($name);                                    
                          
                      }
                        @endphp
                </td>
                    <td>{{ $bar_value['date'] }}</td>
                    <td>{{ $bar_value['ref'] }}</td>                   
                </tr> 
                
                @elseif($pos_id == $bar_value['from'] || $pos_id ==$bar_value['to'] ||  $role_id == 1 ||  in_array($role_id,array(20,21,27,57,56,52))  )              
                                 <tr>
                    <td>{{ $counter++ }} </td>
                    <td>{{ $bar_value['source'] }}</td>
                    <td>{{ $bar_value['barcode'] }}</td>
                    <td>{{  $wpro->article  }}</td>
                    <td>{{  $wpro->color  }}</td>
                    <td>{{  $wpro->size }}</td>
                    <td>{{  $wpro->mrp  }}</td>                

                    <td>{{ $bar_value['from_type'] }}</td>
                    <td> @php                           
                          if($bar_value['from_type'] == "GR party" || $bar_value['from_type'] == "Supplier to Warehouse" || $bar_value['from_type'] == "Warehouse to Party"){
                              if($bar_value['from'] ==1 || $bar_value['from'] ==2){
                                      $sql=\DB::table('oc_warehouses')->where('id',$bar_value['from'])->first();                                      
                                      $name = !empty($sql) ? $sql->name : $bar_value['from']; 
                                      print_r($name);
                                       
                              } else{
                                  $sql=\DB::table('oc_wh_suppliers')->where('id',$bar_value['from'])->first();
                                  $name = !empty($sql) ? $sql->company_name : $bar_value['from']; 
                                      print_r($name);                                   
                              }  
                            
                          }else{
                              $sql=\DB::table('oc_warehouses')->where('id',$bar_value['from'])->first(); 
                                $name = !empty($sql) ? $sql->name : $bar_value['from']; 
                                print_r($name);                                    
                              
                          }
                            @endphp    
                    </td>
                    <td>@php                       
                      if($bar_value['from_type'] == "GR party" || $bar_value['from_type'] == "Supplier to Warehouse" || $bar_value['from_type'] == "Warehouse to Party"){
                              if($bar_value['to'] ==1 || $bar_value['to'] ==2){
                                      $sql=\DB::table('oc_warehouses')->where('id',$bar_value['to'])->first();                                      
                                      $name = !empty($sql) ? $sql->name : $bar_value['to']; 
                                      print_r($name);
                                       
                              } else{
                                  $sql=\DB::table('oc_wh_suppliers')->where('id',$bar_value['to'])->first();
                                  $name = !empty($sql) ? $sql->company_name : $bar_value['to']; 
                                      print_r($name);                                   
                              }  
                            
                          }else{
                              $sql=\DB::table('oc_warehouses')->where('id',$bar_value['to'])->first(); 
                                $name = !empty($sql) ? $sql->name : $bar_value['to']; 
                                print_r($name);                                    
                              
                          }
                            @endphp
                    </td>
                    <td>{{ $bar_value['date'] }}</td>
                    <td>{{ $bar_value['ref'] }}</td>                   
                </tr> 
            

                @endif
                @endforeach
            @endforeach
                
        </tbody>
        </table>



    </div>
</div>



@endsection

@section('extraJs')

@endsection