@include('./admin/util/header')

<div class="row" style="margin-top: 100px;">
                        <!-- <h4 class="card-title">Leaders Info</h4> -->
                        <div class="row">
                            <div class="col-12">
                                <div class="card">
                                    <div class="card-header d-flex justify-content-between align-items-center">
                                        <h4 class="card-title mb-0">Recent Activity</h4>
                                        <a href='/admin/leader-edit?ID=0' class='btn btn-primary'> 
                                            Create New Leader
                                        </a>
                                    </div>
                                    <div class="card-body">
        
                                        <table id="datatable" class="table table-bordered dt-responsive  nowrap w-100">
                                            <thead>
                                            <tr>
                                                <!-- <th>Date<br>added</th>
                                                <th>Edit </th>
                                                <th>Name</th>
                                                <th>Company Name</th>
                                                <th>Leader Icon</th>
                                                <th>Date</th>
                                                <th>Info</th>
                                                <th>Date</th> -->
                                                <th>#</th>
                                                <td><a href="javascript:sortColumn('dateAdded')" class='tableHeadingLink'>Date<br>added</a></td>
                                                <td><a href="javascript:sortColumn('firstName')" class='tableHeadingLink'>First</a> / <a href="javascript:sortColumn('lastName')" class='tableHeadingLink'>last name</a></td>
                                                <td><a href="javascript:sortColumn('state')" class='tableHeadingLink'>State</a> / <a href="javascript:sortColumn('companyName')" class='tableHeadingLink'>Company Name</a></td>
                                                <td><a href="javascript:sortColumn('phoneNum')" class='tableHeadingLink'>Phone #</a></td>
                                                <td><a href="javascript:sortColumn('groups')" class='tableHeadingLink'>Groups</a><br><a href="javascript:sortColumn('assmnts')" class='tableHeadingLink'>[assmnts.]</a></td>
                                                <td>Email</td>
                                                <!-- <td></td> -->
                                                <td>Edit</td><!-- help icon -->

                                            </tr>
                                            </thead>
        
        
                                            <tbody>
                                            @php 
                                                $i =0;
                                            @endphp     
                                            @foreach ($rsDB as $row)
                                                @php

                                                    $i++;
                                                    $ID = $row->ID;
                                                    $IDLink = "<a href='admin/leader-edit?ID=" . $ID . "' class='tableLink'>" . $ID . "</a>";

                                                    $dateAdded = date('m/d/Y', strtotime($row->dateAdded));
                                                    
                                                   // $addOrderIconLink = "<a href='order-edit?orderID=0&ID=" . $ID . "'><img src='../images/system/icon_system_orders_new.gif' width='18' height='18' border='0' alt='Add a new order'></a>";
                                                    $editRecordIconLink = "<a href='leader-edit?ID=" . $ID . "'><img src='../images/system/icon_system_leaders_edit.gif' width='18' height='18' border='0' alt='Edit leader'></a>";

                                                    $firstName = $row->firstName;
                                                    $lastName = $row->lastName;
                                                    if (is_null($firstName) && is_null($lastName)) {
                                                        $firstName = "No name on file";
                                                    }
                                                    
                                                    $fullName = $firstName . "&nbsp;" . $lastName;
                                                    if ($sortBy == "lastName") {
                                                        $fullName = $lastName . ", " . $firstName;
                                                    }
                                                    $sortName = $fullName;
                                                    if (strlen($fullName) > 38) {
                                                        $fullName = substr($fullName, 0, 37) . "..";
                                                    }
                                                    
                                                    if ($row->activeRecord == 0) {
                                                        $fullName = "<strike>" . $fullName . "</strike>";
                                                    }
                                                    $fullNameLink = "<a href='leader-edit?ID=" . $ID . "' class='tableLink'>" . $fullName . "</a>";

                                                    $billCity = $row->billCity;
                                                    $cityState = $billCity;
                                                    $billState = $row->billState;
                                                    if (!is_null($billState)) {
                                                        $cityState = $billCity . ", " . substr($billState, 0, 2);
                                                    }

                                                    
                                                    $col3html = $cityState;
                                                    if (!isNull($billState)) {
                                                        $col3html = $billState . ", ";
                                                    }

                                                    
                                                    $col3html .= $row->companyName;
                                                    $col3htmlLink = "<a class='tableLink'>" . $col3html . "</a>";

                                                

                                                    $phoneNum = $row->phoneNum; // ../ssi/functions_record_display - &nbsp;

                                                    $emailLinkIcon = $row->email; // ../ssi/functions_record_display - &nbsp;
                                                    if ($emailLinkIcon !== "&nbsp;") {
                                                        $emailLinkIcon = "<a href='mailto:" . $emailLinkIcon . "?subject=" . config('app.companyName') . "'><img src='../images/system/icon_envelope.gif' border='0' alt='Email " . $firstName . " " . $lastName . "'></a>";
                                                    }

                                                    // Find the number of log entries assigned to this leader (group count)
                                                    $logCount = DB::table('info')
                                                        ->where('ID', $ID)
                                                        ->count();

                                                    $logCountHtml = "<a href='asp?search=yes&searchField=ID&searchText=" . $ID . "' class='tableLink'>" . $logCount . "</a>";

                                                    if ($logCount === 0) {
                                                        $logCountHtml = "<font color='#990000'>" . $logCount . "</font>";
                                                    }

                                                    // Get assessment count
                                                    $totSQL = "select sum(IFNULL(asicount,0)) as asicnttot, sum(IFNULL(oasicount,0)) as oasicnttot, sum(IFNULL(asi360count,0)) as asi360cnttot, sum(IFNULL(aspasicount,0)) as aspasicnttot, sum(IFNULL(aspoasicount,0)) as aspoasicnttot, sum(IFNULL(aspasi360count,0)) as aspasi360cnttot, sum(IFNULL(assetcount,0)) as assetcnttot, sum(IFNULL(assettaskcount,0)) as assettaskcnttot, sum(IFNULL(assetposcount,0)) as assetposcnttot FROM info i INNER JOIN infoinfo ii on i.logid=ii.logid where id = " . $ID;
                                                    $rTotAssess = 0;
                                                    $rsDBTot = DB::select($totSQL);
                                                    if (count($rsDBTot) > 0) {
                                                        $rTotAssess = $rsDBTot[0]->asicnttot + $rsDBTot[0]->oasicnttot + $rsDBTot[0]->asi360cnttot + $rsDBTot[0]->aspasicnttot + $rsDBTot[0]->aspoasicnttot + $rsDBTot[0]->aspasi360cnttot + $rsDBTot[0]->assetcnttot + $rsDBTot[0]->assettaskcnttot + $rsDBTot[0]->assetposcnttot;
                                                    }

                                                    if ($rTotAssess === 0) {
                                                        $rTotAssessHtml = "<font color='#990000'>" . $rTotAssess . "</font>";
                                                    } else {
                                                        $rTotAssessHtml = $rTotAssess;
                                                        if ($logCount > 0) {
                                                            $rTotAssessHtml = "<a href='asp?search=yes&searchField=ID&searchText=" . $ID . "' class='tableLink'>" . $rTotAssess . "</a>";
                                                        }
                                                    }

                                                    $delLink = "<a href='javascript:addDel(" . $ID . ")' onMouseOver='delHov(" . $ID . ")' onMouseOut='delOut(" . $ID . ")'><img src='../images/system/icon_delete.gif' name='del" . $ID . "' width='20' height='20' border='0' alt='Select this " . $pageSingle . " to be deleted'></a>";
                                                    if (!session("adminAccess")) {
                                                        $delLink = "&nbsp;";
                                                    }
                                                    if (!$row->activeRecord) {
                                                        $delLink = "&nbsp;";
                                                    }

                                                    // Initialize variables
                                                $glRow = "";
                                                $rowFormat = "tableFont"; // Assuming this is initialized somewhere
                                                $glRowLen = 0;
                                                $glRowArray = [];

                                                // Build group leader row
                                                $glRow .= "<tr class='" . $rowFormat . "'>" . PHP_EOL;
                                                
                                                $glRow .= "<td height='18' align='right'>" . $i . "&nbsp;</td>" . PHP_EOL;
                                                $glRow .= "<td height='18' align='right'>" . $dateAdded . "&nbsp;</td>" . PHP_EOL;
                                                $glRow .= "<td>" . $fullNameLink . "</td>" . PHP_EOL;
                                                $glRow .= "<td>" . $col3htmlLink . "</td>" . PHP_EOL;
                                                $glRow .= "<td align='right' width='100'>" . $phoneNum . "&nbsp;&nbsp;</td>" . PHP_EOL;
                                                $glRow .= "<td align='right'>" . $logCountHtml . " [" . $rTotAssessHtml . "]</td>" . PHP_EOL;

                                                $glRow .= "<td>" . $emailLinkIcon . "</td>" . PHP_EOL;
                                                $glRow .= "<td>" . $editRecordIconLink . "</td>" . PHP_EOL;
                                                // $glRow .= "<td><input type='hidden' name='box" . $ID . "' value='false'>" . $delLink . "</td>";
                                                $glRow .= "</tr>" . PHP_EOL;

                                                // Build group leader row sort array, which contains sort criteria and glRow
                                                $glRowLen++;
                                                $glRowArray[$glRowLen][0] = $logCount;
                                                $glRowArray[$glRowLen][1] = $rTotAssess;
                                                $glRowArray[$glRowLen][2] = $sortName;
                                                $glRowArray[$glRowLen][3] = $glRow;

                                                if ($rowFormat == "tableFont") {
                                                    $rowFormat = "tableFont2";
                                                } else {
                                                    $rowFormat = "tableFont";
                                                }
                                                // Determine the range of rows to display based on pagination
                                                if ($sortBy === "assmnts" || $sortBy === "groups") {
                                                    $glBegRow = $glRowPageLen;
                                                    $glEndRow = session("recordsPerPage") + $glRowPageLen - 1;
                                                }

                                                // Sort the rows based on the chosen criteria
                                                switch ($sortBy) {
                                                    case "groups":
                                                        $glRowOutput = Sort3Way($glRowArray, 0, 1, 2, !$lowHigh, $glRowLen);
                                                        break;
                                                    case "assmnts":
                                                        $glRowOutput = Sort3Way($glRowArray, 1, 0, 2, !$lowHigh, $glRowLen);
                                                        break;
                                                    default:
                                                        $glRowOutput = $glRowArray;
                                                }

                                                // Display the sorted rows within the specified range
                                                if ($sortBy === "assmnts" || $sortBy === "groups") {
                                                    for ($glr = $glBegRow; $glr <= $glEndRow; $glr++) {
                                                        echo $glRowOutput[$glr][3]; // Output each group leader table row
                                                    }
                                                } else {
                                                    foreach ($glRowOutput as $row) {
                                                        echo $row[3]; // Output each group leader table row
                                                    }
                                                }
                                                @endphp

                                                <!-- Output other HTML code using the converted variables -->
                                            @endforeach
                                        
                                            </tbody>
                                        </table>
        
                                    </div>
                                </div>
                            </div> <!-- end col -->
                        </div> <!-- end row -->




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