@include('./admin/util/header')
@php
    $tableWidth=400;  
    $pageTitle='';  
    $pageIconHtml='';
    $pageIcon2Html='';
    $oldColSpan=10;

    $totalRecordCount = 0;
@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">
                                       <h2 class="card-title">Assessments: Group {{ $groupCode }} Details </h2>  <!-- -->
                                       </br>
                                       @if(isset($dateClosed))
                                            <div style='background-color:#bbbbbb;padding:3px;'>
                                                This group is closed. It was first opened on <strong>{{ $dateAdded }}</strong> by {{ $fullNameAdminWhoOpened }}.
                                            </div>
                                            <div style='background-color:#eee;color:#333;padding:3px;font-weight:normal;'>
                                                Start date: <strong>{{ $dateCollected }}</strong> / close date: <strong>{{ $dateClosedText }}</strong>
                                            </div>
                                        @endif


                                        @if($dateClosedText === "N/A" && $activeRecord)
                                            @php $dateClosedText = "<font color='#009900'>Group open</font>"; @endphp
                                        @endif
                                        
                                        @php
                                           // dd($groupStatusText);
                                        @endphp
                                        @if(!$activeRecord)
                                            <tr>
                                                <td style='background-color:#900; padding:3px; font-weight:normal; color:#eeeeee;' colspan='{{ $emailColSpan }}'>This group was first opened on <strong>{{ $dateAdded }}</strong> by {{ $fullNameAdminWhoOpened }} and DEACTIVATED on <strong>{{ $dateDeleted }}</strong>.</td>
                                            </tr>
                                        @endif
                                        
                                        @if($activeRecord)
                                            <div style='background-color:#009900;color:#ffffff;padding:3px;font-weight:normal;'>
                                                This group is currently <strong>OPEN</strong>. Start date: <b>{{ $dateCollected }}</b> / Close date: <b>{{ $dateEndText }}</b>
                                            </div>

                                            <div style='background-color:#eee;color:#333;padding:3px;font-weight:normal;'>
                                                Group originally opened on {{ $dateAdded }} by {{ $fullNameAdminWhoOpened }}.
                                            </div>
                                        @endif

                                        </br>
                                        <h5 class="card-title">Group Name: {{ $groupName }} </h5>
                                        </br>
                                        <h5 class="card-title">Group Leader: {{ $leaderName }} </h5> 
                                        </br>
                                        <!-- <h5 class="card-title">Note: {{ $notes }} </h5>  -->
                                        <!-- @if($leaderEmail !== "")
                                                                                    @endif -->
                                                                                                                        

                                        
                                        
                                        @php
                                            echo $groupInfo;
                                        @endphp

                                    </div>
                                    <div class="card-body">
        
                                        <table id="datatable" class="table table-bordered dt-responsive  nowrap w-100">
                                            <thead>
                                                <!-- <tr> </tr> -->
                       
                                                <td >ID</td>
                                                <td >Date </br> Collected</td>
                                                <td >Sex<br>Age</td>
                                                <td >Edu</td>
                                                <td >Name</td>
                                                <td >CM</td>
                                                <td >Intrinsic</td>
                                                <td >Competitive</td>
                                                <td >Power</td>
                                                <td >Personal</td>
                                                <td >Social</td>
                                                <td >Entrusting</td>
                                                <td >Collaborative</td>
                                                <td >Contributory</td>
                                                <td >Vicarious</td>
                                                <td >Graph</td>
                                                <!-- <td >Print</td> -->
                                                <td >Delete</td>
                                               
                                            </thead>
        
                                            <tbody>
                                                @php
                                                        $selectSQL = "SELECT contact.lblVersion, contact.ID, contact.activeRecord, contact.personalPrivacy, contact.firstName, contact.lastName, contact.lblDate, contact.email, demog.sex, demog.age, demog.completed_education, userinfo.style1, userinfo.style2, userinfo.style3, userinfo.style4, userinfo.style5, userinfo.style6, userinfo.style7, userinfo.style8, userinfo.style9, userinfo.cMean";
                                                        $fromSQL = "FROM contact INNER JOIN demog ON contact.ID = demog.ID INNER JOIN userinfo ON contact.ID = userinfo.ID";
                                                        $whereSQL = "WHERE contact.groupCode=" . $groupCode . " AND lblVersion = '13R' AND activeRecord=1";

                                                        $records = DB::select($selectSQL . ' ' . $fromSQL . ' ' . $whereSQL . ' ' . $orderBy);
                                                        
              
                                                      
                                                        $asiCount = displayRecordData($tableWidth, $colSpan, $totalRecordCount, $records,$groupCode); // Assuming displayRecordData is a custom function
                                                        $totalRecordCount += $asiCount;
                                                        
                                                    @endphp
                                                    @php
                                                        $selectSQL = "SELECT contact.lblVersion, contact.ID, contact.activeRecord, contact.personalPrivacy, contact.firstName, contact.lastName, contact.lblDate, contact.email, demog.sex, demog.age, demog.completed_education, userinfo.style1, userinfo.style2, userinfo.style3, userinfo.style4, userinfo.style5, userinfo.style6, userinfo.style7, userinfo.style8, userinfo.style9, userinfo.cMean";
                                                        $fromSQL = "FROM (contact INNER JOIN demog ON contact.ID = demog.ID) INNER JOIN userinfo ON contact.ID = userinfo.ID";
                                                        $whereSQL = "WHERE contact.groupCode=" . $groupCode . " AND lblVersion = '13O' AND activeRecord=1";

                                                        $records = DB::select($selectSQL . ' ' . $fromSQL . ' ' . $whereSQL . ' ' . $orderBy);
                                                        
                                                        $oasiCount = displayRecordData($tableWidth, $colSpan, $totalRecordCount, $records,$groupCode); // Assuming displayRecordData is a custom function


                                                    @endphp                                     
                                                    <!-- ASI records -->
                                                    @php
                                                            $selectSQL = "SELECT contact.lblVersion, contact.ID, contact.activeRecord, contact.personalPrivacy, contact.firstName, contact.lastName, contact.lblDate, contact.email, demog.sex, demog.age, demog.completed_education, userinfo.style1, userinfo.style2, userinfo.style3, userinfo.style4, userinfo.style5, userinfo.style6, userinfo.style7, userinfo.style8, userinfo.style9, userinfo.cMean";
                                                            $fromSQL = "FROM contact INNER JOIN demog ON contact.ID = demog.ID INNER JOIN userinfo ON contact.ID = userinfo.ID";
                                                            $whereSQL = "WHERE contact.groupCode=" . $groupCode . " AND lblVersion = '13AR' AND activeRecord=1";

                                                            $records = DB::select($selectSQL . ' ' . $fromSQL . ' ' . $whereSQL . ' ' . $orderBy);
                                                            $aspAsiCount = displayRecordData($tableWidth, $colSpan, $totalRecordCount, $records,$groupCode); // Assuming displayRecordData is a custom function

                                                    @endphp
                                                    @php
                                                        $totalRecordCount += $aspAsiCount;
                                                    @endphp
                                                    @php
                                                        $selectSQL = "SELECT contact.lblVersion, contact.ID, contact.activeRecord, contact.personalPrivacy, contact.firstName, contact.lastName, contact.lblDate, contact.email, demog.sex, demog.age, demog.completed_education, userinfo.style1, userinfo.style2, userinfo.style3, userinfo.style4, userinfo.style5, userinfo.style6, userinfo.style7, userinfo.style8, userinfo.style9, userinfo.cMean";
                                                        $fromSQL = "FROM (contact INNER JOIN demog ON contact.ID = demog.ID) INNER JOIN userinfo ON contact.ID = userinfo.ID";
                                                        $whereSQL = "WHERE contact.groupCode=" . $groupCode . " AND lblVersion = '13AO' AND activeRecord=1";

                                                        $records = DB::select($selectSQL . ' ' . $fromSQL . ' ' . $whereSQL . ' ' . $orderBy);
                                                        $aspOasiCount = displayRecordData($tableWidth, $colSpan, $totalRecordCount, $records,$groupCode); // Assuming displayRecordData is a custom function
                                                        $totalRecordCount += $aspOasiCount;
                                                    @endphp
                                 
                                                    @php
                                                    $selectSQL = "SELECT contact.lblVersion, contact.ID, contact.activeRecord, contact.personalPrivacy, contact.firstName, contact.lastName, contact.lblDate, contact.email, userinfo.style1, userinfo.style2, userinfo.style3, userinfo.style4, userinfo.style5, userinfo.style6, userinfo.style7, userinfo.style8, userinfo.style9, userinfo.cMean";
                                                    $fromSQL = "FROM contact INNER JOIN userinfo ON contact.ID = userinfo.ID";
                                                    $whereSQL = "WHERE contact.groupCode=" . $groupCode . " AND lblVersion = '13TA' AND activeRecord=1";

                                                    $records = DB::select($selectSQL . ' ' . $fromSQL . ' ' . $whereSQL);
                                                    $assetTaskCount = displayRecordData($tableWidth, $colSpan, $totalRecordCount, $records,$groupCode); // Assuming displayRecordData is a custom function
                                                    $totalRecordCount += $assetTaskCount;
                                                @endphp
                                                @php
                                                    $selectSQL = "SELECT contact.lblVersion, contact.ID, contact.activeRecord, contact.personalPrivacy, contact.firstName, contact.lastName, contact.lblDate, contact.email, userinfo.style1, userinfo.style2, userinfo.style3, userinfo.style4, userinfo.style5, userinfo.style6, userinfo.style7, userinfo.style8, userinfo.style9, userinfo.cMean";
                                                    $fromSQL = "FROM contact INNER JOIN userinfo ON contact.ID = userinfo.ID";
                                                    $whereSQL = "WHERE contact.groupCode=" . $groupCode . " AND lblVersion = '13PA' AND activeRecord=1";

                                                    $records = DB::select($selectSQL . ' ' . $fromSQL . ' ' . $whereSQL);
                                                    $assetPosCount = displayRecordData($tableWidth, $colSpan, $totalRecordCount, $records,$groupCode); // Assuming displayRecordData is a custom function
                                                    $totalRecordCount += $assetPosCount;
                                                @endphp

                                                @php
                                                    $selectSQL = "SELECT composites.lblVersion, composites.activeRecord, composites.compositeID, composites.title, composites.dateAdded, composites.style1, composites.style2, composites.style3, composites.style4, composites.style5, composites.style6, composites.style7, composites.style8, composites.style9, composites.cMean";
                                                    $fromSQL = "FROM composites";
                                                    $whereSQL = "WHERE composites.groupCode=" . $groupCode . " AND lblVersion = '13C' AND activeRecord=1";

                                                    $records = DB::select($selectSQL . ' ' . $fromSQL . ' ' . $whereSQL);
                                                    $comCount = displayRecordData($tableWidth, $colSpan, $totalRecordCount, $records,$groupCode); // Assuming displayRecordData is a custom function
                                                    $totalRecordCount += $comCount;
                                                @endphp

                                                @php
                                                    $selectSQL = "SELECT contact.lblVersion, contact.ID, contact.activeRecord, contact.personalPrivacy, contact.firstName, contact.lastName, contact.lblDate, contact.email, demog.sex, demog.age, demog.completed_education, userinfo.style1, userinfo.style2, userinfo.style3, userinfo.style4, userinfo.style5, userinfo.style6, userinfo.style7, userinfo.style8, userinfo.style9, userinfo.cMean";
                                                    $fromSQL = "FROM (contact INNER JOIN demog ON contact.ID = demog.ID) INNER JOIN userinfo ON contact.ID = userinfo.ID";
                                                    $whereSQL = "WHERE contact.groupCode=" . $groupCode . " AND (lblVersion = '13EM' OR lblVersion = '13EF') AND activeRecord=1";

                                                    $records = DB::select($selectSQL . ' ' . $fromSQL . ' ' . $whereSQL . ' ' . $orderBy);
                                                    $focusCount = displayRecordData($tableWidth, $colSpan, $totalRecordCount, $records,$groupCode); // Assuming displayRecordData is a custom function
                                                    $totalRecordCount += $focusCount;
                                                @endphp

                                                @php
                                                    $selectSQL = "SELECT contact.lblVersion, contact.ID, contact.activeRecord, contact.personalPrivacy, contact.firstName, contact.lastName, contact.lblDate, contact.email, demog.sex, demog.age, demog.completed_education, userinfo.style1, userinfo.style2, userinfo.style3, userinfo.style4, userinfo.style5, userinfo.style6, userinfo.style7, userinfo.style8, userinfo.style9, userinfo.cMean";
                                                    $fromSQL = "FROM (contact INNER JOIN demog ON contact.ID = demog.ID) INNER JOIN userinfo ON contact.ID = userinfo.ID";
                                                    $whereSQL = "WHERE contact.groupCode=" . $groupCode . " AND (lblVersion = '13EM' OR lblVersion = '13EF') AND activeRecord=1";

                                                    $records = DB::select($selectSQL . ' ' . $fromSQL . ' ' . $whereSQL . ' ' . $orderBy);
                                                    $focusCount = displayRecordData($tableWidth, $colSpan, $totalRecordCount, $records,$groupCode); // Assuming displayRecordData is a custom function
                                                    $totalRecordCount += $focusCount;
                                                @endphp
                                            </tbody>
                                        </table>
        
                                    </div>
                                </div>
                            </div> <!-- end col -->
                        </div> <!-- end row -->
@include('../util/footer')