@extends('layouts/pos_layout')
@section('title', '| Product Assign')
@section('content')
@include('successMsg')
<style type="text/css">
    .select2-results__option[aria-selected=true] {
    display: none;
}
</style>
<div class="row">
    <div class="col-md-12">
        <div class="" style="">
            <div class="">
                <div class="panel panel-default" style="background-color:#708090;">
                    <div class="panel-heading" style="padding-bottom:0px">
                      <div class="panel-options">
                          <a href="{{url('pos/posAddProductAssaign/')}}" class="btn btn-info pull-right addViewBtn"><i class="glyphicon glyphicon-plus-sign addIcon"></i>Add Product Assign</a>
                      </div>
                      <h1 align="center" style="font-family: Antiqua;letter-spacing: 2px"><font color="white">Product Assign LIST</font></h1>
                    </div>
                    <div class="panel-body panelBodyView"> 
                      <div>
                        <script type="text/javascript">
                        jQuery(document).ready(function($)
                        {
                          $("#ProCategoryView").dataTable().yadcf([
                  
                          ]);
                        });
                        </script>
                    </div>
                    <table class="table table-striped table-bordered" id="ProCategoryView" style="color:black;">
                          <thead>
                            <tr>
                              <th width="30">SL#</th>
                              <th>Company Name</th>
                              <th>Product Name</th>
                              <th>Product Package</th>
                              <th>Action</th>
                            </tr>
                            {{ csrf_field() }}
                          </thead>
                            <tbody>
                                                                @foreach($PosProductAssaigns as $PosProductAssaign)
                                  <tr class="item{{$PosProductAssaign->id}}">
                                    <td class="text-center slNo">{{++$no}}</td>
                                    <td style="padding-left: 25px; text-align: left;">
                                        {{DB::table('pos_client')->where('id',$PosProductAssaign->clientcompanyId)->value('clientCompanyName')}}
                                    </td>
                                    <td style="padding-left: 25px; text-align: left;">
                                        {{DB::table('pos_product')->where('id',$PosProductAssaign->productId)->value('name')}}
                                    </td>
                                    <td>
                                        @php
                                            $productPackageIds =  DB::table('pos_product')->where('id',$PosProductAssaign->productId)->value('productPackge');
                                            if($productPackageIds!=null){
                                            $productStr =  str_replace(array('"', '[', ']'),'', $productPackageIds);
                                            $productArr = array_map('intval', explode(',', $productStr));
                                            $productName='';
                                            
                                            foreach ($productArr as $key => $prodcutId) {
                                                $temp = DB::table('pos_product')->where('id',$prodcutId)->value('name');
                                                if ($key==0) {
                                                    $productName=$temp;
                                                }else{
                                                    $productName=$productName.', '.$temp;
                                                }
                                            }
                                        } else {
                                            $productName='';
                                        } 
                                        @endphp
                                        {{$productName}}
                                    </td>
                                    <td  class="text-center" width="80">
                                      <a id="viewIcone" href="javascript:;" class="view-modal" productAssignId="{{$PosProductAssaign->id}}">
                                        <span class="fa fa-eye"></span>
                                      </a> &nbsp;
                                      <a id="editIcone" href="javascript:;" class="edit-modal" productAssignId="{{$PosProductAssaign->id}}">
                                        <span class="glyphicon glyphicon-edit"></span>
                                      </a> &nbsp;
                                      <a id="deleteIcone" href="javascript:;" class="delete-modal" productAssignId="{{$PosProductAssaign->id}}">
                                        <span class="glyphicon glyphicon-trash"></span>
                                      </a>
                                  </td>
                                </tr>
                              @endforeach
                           </tbody>
                        </table>
                    </div>
                </div>
             </div>
         </div>
    </div>
</div>
<!-- Edit Modal Start -->
<div id="editModal" class="modal fade" style="margin-top:3%;">
  <div class="modal-dialog">
   <div class="modal-content">
      <div class="modal-header">
        <h4 class="modal-title"></h4>
      </div>
      <div class="modal-body">
       {!! Form::open(array('url' => '','id'=>'entryForm', 'role' => 'form', 'class'=>'form-horizontal form-groups')) !!}
        <input id="EMproductAssignId" type="hidden"  value="" />
                <div class="row">
                    <div class="col-md-12">
                        <div class="form-group">
                              {!! Form::label('clientCompanyId', 'Company Name:', ['class' => 'col-sm-3 control-label']) !!}
                              <div class="col-sm-9">
                                      <br />
<b>Fatal error</b>:  Uncaught Error: Class &quot;DB&quot; not found in /home/shikkhaplus/public_html/resources/views/pos/productAssaign/viewProductAssing.blade.php:113
Stack trace:
#0 {main}
  thrown in <b>/home/shikkhaplus/public_html/resources/views/pos/productAssaign/viewProductAssing.blade.php</b> on line <b>113</b><br />