@include('./admin/util/header')
@php
    $tableWidth=400;  
    $pageTitle='';  
    $pageIconHtml='';
    $pageIcon2Html='';
    $oldColSpan=10;
@endphp
<div class="row">
                        <h4 class="card-title">Recent Inventory Activity</h4>
                        <div class="row">
                            <div class="col-12">
                                <div class="card">
                                    <div class="card-header">
                                        <!-- <h4 class="card-title">Recent Activity</h4> -->

                                    </div>
                                    <div class="card-body">
        
                                        <table id="datatable" class="table table-bordered dt-responsive  nowrap w-100">
                                        <tr class='tableHeading2'>
                                              <td align='center' valign='bottom'>#</td>
                                              <td align='center' valign='bottom'>ID<br>number</td>
                                              <td align='center' valign='bottom'>L-BL<br>Date</td>
                                              <td align='center' valign='bottom'>L-BL<br>version</td>
                                              <td align='center' valign='bottom'>Group<br>code</td>
                                              <td align='left' valign='bottom'>&nbsp;User name</td>
                                              <td align='center' valign='bottom'>&nbsp;</td>
                                              <td align='center' valign='bottom'>&nbsp;</td>
                                 
                                            </tr>

                                            </thead>
        
        
                                            <tbody>
                                                
                                            <tr>
                                                <td width="20" bgcolor="#0165ff" align="center" valign="middle">
                                                    <a href="inventory.search">
                                                        <img src="{{ asset('images/text_asi.png') }}" border="0" width="18" height="80">
                                                    </a>
                                                </td><!-- Vertical Name column -->


                                                <!-- Need to start from here -->
                                                <td colspan="{{ $oldColSpan - 1 }}"> <!-- ASI records -->
                                                    <table border="0" class="tableFont" width="100%" cellpadding="0" cellspacing="0">
                                                        @php
                                                            // Replace the SQL query with Laravel's query builder
                                                            $records = DB::table('contact')
                                                                ->join('demog', 'contact.ID', '=', 'demog.ID')
                                                                ->where('lblVersion', '=', '13R')
                                                                ->orderByDesc('dateUpdated')
                                                                ->orderByDesc('groupCode')
                                                                ->take(20)
                                                                ->get();
                                                      $colSpan=5;
                                                      $listCount=4;
                                                            displaySearchData($tableWidth,$colSpan,$listCount,$records);
                                                        @endphp
                                                    
                                                    </table>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td width="20" bgcolor="#0165ff" align="center" valign="middle">
                                                    <a href="inventory.search">
                                                        <img src="{{ asset('images/text_asp_asi.png') }}" border="0" width="18" height="80">
                                                    </a>
                                                </td><!-- Vertical Name column -->


                                                <!-- Need to start from here -->
                                                <td colspan="{{ $oldColSpan - 1 }}"> <!-- ASI records -->
                                                    <table border="0" class="tableFont" width="100%" cellpadding="0" cellspacing="0">
                                                        @php
                                                            // Replace the SQL query with Laravel's query builder
                                                            $records = DB::table('contact')
                                                                ->join('demog', 'contact.ID', '=', 'demog.ID')
                                                                ->where('lblVersion', '=', '13AR')
                                                                ->orderByDesc('dateUpdated')
                                                                ->orderByDesc('groupCode')
                                                                ->take(20)
                                                                ->get();
                                                      $colSpan=5;
                                                      $listCount=4;
                                                            displaySearchData($tableWidth,$colSpan,$listCount,$records);
                                                        @endphp
                                                    
                                                    </table>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td width="20" bgcolor="#0165ff" align="center" valign="middle">
                                                    <a href="inventory.search">
                                                        <img src="{{ asset('images/text_oasi.png') }}" border="0" width="18" height="80">
                                                    </a>
                                                </td><!-- Vertical Name column -->


                                                <!-- Need to start from here -->
                                                <td colspan="{{ $oldColSpan - 1 }}"> <!-- ASI records -->
                                                    <table border="0" class="tableFont" width="100%" cellpadding="0" cellspacing="0">
                                                        @php
                                                            // Replace the SQL query with Laravel's query builder
                                                            $records = DB::table('contact')
                                                                ->join('demog', 'contact.ID', '=', 'demog.ID')
                                                                ->where('lblVersion', '=', '13O')
                                                                ->orderByDesc('dateUpdated')
                                                                ->orderByDesc('groupCode')
                                                                ->take(20)
                                                                ->get();
                                                      $colSpan=5;
                                                      $listCount=4;
                                                            displaySearchData($tableWidth,$colSpan,$listCount,$records);
                                                        @endphp
                                                    
                                                    </table>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td width="20" bgcolor="#0165ff" align="center" valign="middle">
                                                    <a href="inventory.search">
                                                        <img src="{{ asset('images/text_asp_oasi.png') }}" border="0" width="18" height="80">
                                                    </a>
                                                </td><!-- Vertical Name column -->


                                                <!-- Need to start from here -->
                                                <td colspan="{{ $oldColSpan - 1 }}"> <!-- ASI records -->
                                                    <table border="0" class="tableFont" width="100%" cellpadding="0" cellspacing="0">
                                                        @php
                                                            // Replace the SQL query with Laravel's query builder
                                                            $records = DB::table('contact')
                                                                ->join('demog', 'contact.ID', '=', 'demog.ID')
                                                                ->where('lblVersion', '=', '13AO')
                                                                ->orderByDesc('dateUpdated')
                                                                ->orderByDesc('groupCode')
                                                                ->take(20)
                                                                ->get();
                                                      $colSpan=5;
                                                      $listCount=4;
                                                            displaySearchData($tableWidth,$colSpan,$listCount,$records);
                                                        @endphp
                                                    
                                                    </table>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td width="20" bgcolor="#0165ff" align="center" valign="middle">
                                                    <a href="inventory.search">
                                                        <img src="{{ asset('images/text_evaluator.png') }}" border="0" width="18" height="80">
                                                    </a>
                                                </td><!-- Vertical Name column -->


                                                <!-- Need to start from here -->
                                                <td colspan="{{ $oldColSpan - 1 }}"> <!-- ASI records -->
                                                    <table border="0" class="tableFont" width="100%" cellpadding="0" cellspacing="0">
                                                        @php
                                                            // Replace the SQL query with Laravel's query builder
                                                            $records = DB::table('contact')
                                                                ->join('demog', 'contact.ID', '=', 'demog.ID')
                                                                ->where('lblVersion', '=', 'EM')
                                                                ->orderByDesc('dateUpdated')
                                                                ->orderByDesc('groupCode')
                                                                ->take(20)
                                                                ->get();
                                                      $colSpan=5;
                                                      $listCount=4;
                                                            displaySearchData($tableWidth,$colSpan,$listCount,$records);
                                                        @endphp
                                                    
                                                    </table>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td width="20" bgcolor="#0165ff" align="center" valign="middle">
                                                    <a href="inventory.search">
                                                        <img src="{{ asset('images/text_asp_evaluator.png') }}" border="0" width="18" height="80">
                                                    </a>
                                                </td><!-- Vertical Name column -->


                                                <!-- Need to start from here -->
                                                <td colspan="{{ $oldColSpan - 1 }}"> <!-- ASI records -->
                                                    <table border="0" class="tableFont" width="100%" cellpadding="0" cellspacing="0">
                                                        @php
                                                            // Replace the SQL query with Laravel's query builder
                                                            $records = DB::table('contact')
                                                                ->join('demog', 'contact.ID', '=', 'demog.ID')
                                                                ->where('lblVersion', '=', 'AEM')
                                                                ->orderByDesc('dateUpdated')
                                                                ->orderByDesc('groupCode')
                                                                ->take(20)
                                                                ->get();
                                                      $colSpan=5;
                                                      $listCount=4;
                                                            displaySearchData($tableWidth,$colSpan,$listCount,$records);
                                                        @endphp
                                                    
                                                    </table>
                                                </td>
                                            </tr>

                                            <tr>
                                                <td width="20" bgcolor="#0165ff" align="center" valign="middle">
                                                    <a href="inventory.search">
                                                        <img src="{{ asset('images/text_asset.png') }}" border="0" width="18" height="80">
                                                    </a>
                                                </td><!-- Vertical Name column -->


                                                <!-- Need to start from here -->
                                                <td colspan="{{ $oldColSpan - 1 }}"> <!-- ASI records -->
                                                    <table border="0" class="tableFont" width="100%" cellpadding="0" cellspacing="0">
                                                        @php
                                                            // Replace the SQL query with Laravel's query builder
                                                            $records = DB::table('contact')
                                                                ->join('demog', 'contact.ID', '=', 'demog.ID')
                                                                ->where('lblVersion', '=', '13A')
                                                                ->orderByDesc('dateUpdated')
                                                                ->orderByDesc('groupCode')
                                                                ->take(20)
                                                                ->get();
                                                      $colSpan=5;
                                                      $listCount=4;
                                                            displaySearchData($tableWidth,$colSpan,$listCount,$records);
                                                        @endphp
                                                    
                                                    </table>
                                                </td>
                                            </tr>

                                            <tr>
                                                <td width="20" bgcolor="#0165ff" align="center" valign="middle">
                                                    <a href="inventory.search">
                                                        <img src="{{ asset('images/text_asset_p.png') }}" border="0" width="18" height="80">
                                                    </a>
                                                </td><!-- Vertical Name column -->


                                                <!-- Need to start from here -->
                                                <td colspan="{{ $oldColSpan - 1 }}"> <!-- ASI records -->
                                                    <table border="0" class="tableFont" width="100%" cellpadding="0" cellspacing="0">
                                                        @php
                                                            // Replace the SQL query with Laravel's query builder
                                                            $records = DB::table('contact')
                                                                ->join('demog', 'contact.ID', '=', 'demog.ID')
                                                                ->where('lblVersion', '=', '13PA')
                                                                ->orderByDesc('dateUpdated')
                                                                ->orderByDesc('groupCode')
                                                                ->take(20)
                                                                ->get();
                                                      $colSpan=5;
                                                      $listCount=4;
                                                            displaySearchData($tableWidth,$colSpan,$listCount,$records);
                                                        @endphp
                                                    
                                                    </table>
                                                </td>
                                            </tr>

                                            <tr>
                                                <td width="20" bgcolor="#0165ff" align="center" valign="middle">
                                                    <a href="inventory.search">
                                                        <img src="{{ asset('images/text_asset_t.png') }}" border="0" width="18" height="80">
                                                    </a>
                                                </td><!-- Vertical Name column -->


                                                <!-- Need to start from here -->
                                                <td colspan="{{ $oldColSpan - 1 }}"> <!-- ASI records -->
                                                    <table border="0" class="tableFont" width="100%" cellpadding="0" cellspacing="0">
                                                        @php
                                                            // Replace the SQL query with Laravel's query builder
                                                            $records = DB::table('contact')
                                                                ->join('demog', 'contact.ID', '=', 'demog.ID')
                                                                ->where('lblVersion', '=', '13TA')
                                                                ->orderByDesc('dateUpdated')
                                                                ->orderByDesc('groupCode')
                                                                ->take(20)
                                                                ->get();
                                                      $colSpan=5;
                                                      $listCount=4;
                                                            displaySearchData($tableWidth,$colSpan,$listCount,$records);
                                                        @endphp
                                                    
                                                    </table>
                                                </td>
                                            </tr>
                                            </tbody>
                                        </table>
        
                                    </div>
                                </div>
                            </div> <!-- end col -->
                        </div> <!-- end row -->




@include('../util/footer')