@extends('layouts/billing_layout')
@section('title', '| Product Agreement')
@section('content')
    @include('successMsg')
    <style type="text/css">
        .select2-results__option[aria-selected=true] {
            display: none;
        }

        .select2-container--default .select2-selection--multiple .select2-selection__rendered {
            height: auto !important;
        }
    </style>
    {{-- <script src="https://cdn.ckeditor.com/ckeditor5/36.0.1/classic/ckeditor.js"></script> --}}
    <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('billing/billingAddProductAssaign/') }}"
                                    class="btn btn-info pull-right addViewBtn"><i
                                        class="glyphicon glyphicon-plus-sign addIcon"></i>Add Product Agreement</a>
                            </div>
                            <h1 align="center" style="font-family: Antiqua;letter-spacing: 2px">
                                <font color="white">Product Agreement 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>Cancel Date </th>
                                        <th>Action</th>
                                    </tr>
                                    {{ csrf_field() }}
                                </thead>
                                <tbody>
                                                                        @foreach ($billingProductAssaigns as $billingProductAssaign)
                                        <tr class="item{{ $billingProductAssaign->id }}">
                                            <td class="text-center slNo">{{ ++$no }}</td>
                                            <td style="padding-left: 25px; text-align: left;">
                                                {{ DB::table('billing_client')->where('id', $billingProductAssaign->clientcompanyId)->value('clientCompanyName') }}
                                            </td>
                                            <td style="padding-left: 25px; text-align: left;">
                                                {{ DB::table('billing_product')->where('id', $billingProductAssaign->productId)->value('name') }}
                                            </td>
                                            <td>
                                                @php
                                                    $productPackageIds = DB::table('billing_product')
                                                        ->where('id', $billingProductAssaign->productId)
                                                        ->value('productPackge');
                                                    if ($productPackageIds != null) {
                                                        $productStr = str_replace(
                                                            ['"', '[', ']'],
                                                            '',
                                                            $productPackageIds,
                                                        );
                                                        $productArr = array_map('intval', explode(',', $productStr));
                                                        $productName = '';

                                                        foreach ($productArr as $key => $prodcutId) {
                                                            $temp = DB::table('billing_product')
                                                                ->where('id', $prodcutId)
                                                                ->value('name');
                                                            if ($key == 0) {
                                                                $productName = $temp;
                                                            } else {
                                                                $productName = $productName . ', ' . $temp;
                                                            }
                                                        }
                                                    } else {
                                                        $productName = '';
                                                    }
                                                @endphp
                                                {{ $productName }}
                                            </td>
                                            <td>
                                                @if ($billingProductAssaign->cancelDate == '0000-00-00')
                                                    {{ '-' }}
                                                @else
                                                    {{ $billingProductAssaign->cancelDate }}
                                                @endif
                                            </td>
                                            <td class="text-center" width="80">
                                                <a id="viewIcone" href="javascript:;" class="view-modal"
                                                    productAssignId="{{ $billingProductAssaign->agreementBill }}">
                                                    <span class="fa fa-eye"></span>
                                                </a> &nbsp;
                                                <a id="editIcone" href="javascript:;" class="edit-modal"
                                                    productAssignId="{{ $billingProductAssaign->id }}">
                                                    <span class="glyphicon glyphicon-edit"></span>
                                                </a> &nbsp;
                                                <a id="deleteIcone" href="javascript:;" class="delete-modal"
                                                    productAssignId="{{ $billingProductAssaign->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%;" data-keyboard="false" data-backdrop="static">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h4 class="modal-title"></h4>
                </div>
                <div class="modal-body">
                    {!! Form::open(['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('billNo', 'Agreement Bill No:', ['class' => 'col-sm-3 control-label']) !!}
                                <div class="col-sm-8">
                                    @php
                                        //$maxSales = PosProductAssaign::max('id')+1;
                                        $maxSalesNumber = 'AG' . str_pad(6, '0', STR_PAD_LEFT);
                                    @endphp

                                    {!! Form::text('billNo', null, [
                                        'class' => 'form-control',
                                        'id' => 'billNo',
                                        'readonly',
                                        'type' => 'text',
                                        'autocomplete' => 'off',
                                    ]) !!}
                                    <p id='billNoe' style="max-height:3px;"></p>
                                </div>
                            </div>
                        </div>
                        <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/demo_bk/resources/views/billing/productAssaign/viewProductAssing.blade.php:160
Stack trace:
#0 {main}
  thrown in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/billing/productAssaign/viewProductAssing.blade.php</b> on line <b>160</b><br />