{{--{!! $extraCssHtml !!}--}}
{{ $basePageTitle . $pageTitle }} {!! $pageIconHtml !!}
{!! $groupStatusText !!}
blade
@if ($msgText) @endif @if (request()->query('type') !== 'print') @endif
@include('partials.displayMsgV2', ['msgText' => $msgText])
 
{!! $groupInfo !!}
 
{!! $emailSummaryHtml !!}
@php $totalRecordCount = 0; $htmlTableSpacers = "" . PHP_EOL; $htmlTableSpacers .= " " . PHP_EOL; // ID $htmlTableSpacers .= " " . PHP_EOL; // date $htmlTableSpacers .= " " . PHP_EOL; // sex / age $htmlTableSpacers .= " " . PHP_EOL; // education $htmlTableSpacers .= " " . PHP_EOL; // name $htmlTableSpacers .= " " . PHP_EOL; // CM for ($c = 1; $c <= 9; $c++) { // 9 scores 22 * 9 = 198px $htmlTableSpacers .= " " . PHP_EOL; } $htmlTableSpacers .= " " . PHP_EOL; // graph $htmlTableSpacers .= " " . PHP_EOL; // print $htmlTableSpacers .= " " . PHP_EOL; // delete box $htmlTableSpacers .= "" . PHP_EOL; // Two table spacings needed, one with the extra colored column $htmlTableSpacers1 = str_replace("", "", $htmlTableSpacers); $htmlTableSpacers2 = str_replace("", "", $htmlTableSpacers); @endphp
{!! $htmlTableSpacers2 !!}
@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 @if ($asiCount > 0) {{-- ASI Composites info --}} @php $totalRecordCount += $asiCount; @endphp {{-- Display composite rows --}} {!! showCompositeRow("13G", $groupCode, $asiCount) !!} {{-- Assuming showCompositeRow is a custom function --}} {!! showCompositeRow("13M", $groupCode, $asiCount) !!} {!! showCompositeRow("13F", $groupCode, $asiCount) !!}

  @endif @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 @if ($aspAsiCount > 0) {{-- A-ASI Composites info --}} @php $totalRecordCount += $aspAsiCount; @endphp {{-- Display composite rows --}} {!! showCompositeRow("13AG", $groupCode, $aspAsiCount) !!} {{-- Assuming showCompositeRow is a custom function --}} {!! showCompositeRow("13AM", $groupCode, $aspAsiCount) !!} {!! showCompositeRow("13AF", $groupCode, $aspAsiCount) !!}
  @endif @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 @if ($oasiCount > 0) {{-- OASI Composite info --}} @php $totalRecordCount += $oasiCount; @endphp {{-- Display composite rows --}} {!! showCompositeRow("13GO", $groupCode, $oasiCount) !!} {{-- Assuming showCompositeRow is a custom function --}} {!! showCompositeRow("13MO", $groupCode, $oasiCount) !!} {!! showCompositeRow("13FO", $groupCode, $oasiCount) !!}
  @endif @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 @if ($aspOasiCount > 0) {{-- A-OASI Composite info --}} {{-- Display composite rows --}} {!! showCompositeRow("13AGO", $groupCode, $aspOasiCount) !!} {{-- Assuming showCompositeRow is a custom function --}} {!! showCompositeRow("13AMO", $groupCode, $aspOasiCount) !!} {!! showCompositeRow("13AFO", $groupCode, $aspOasiCount) !!}
  @endif @php $selectSQL = "SELECT contact.lblVersion, contact.ID, contact.activeRecord, contact.personalPrivacy, contact.firstName, contact.lastName, contact.lblDate, contact.assetTitle, 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 = '13O' AND activeRecord=1"; $records = DB::select($selectSQL . ' ' . $fromSQL . ' ' . $whereSQL); $assetCount = count( $records) == 0 ?0 :displayRecordData($tableWidth, $colSpan, $totalRecordCount, $records,$groupCode); // Assuming displayRecordData is a custom function @endphp @if ($assetCount > 0) {{-- Display and count records --}} @php $totalRecordCount += $assetCount; @endphp
  @endif @php $selectSQL = "SELECT contact.lblVersion, contact.ID, contact.activeRecord, contact.personalPrivacy, contact.firstName, contact.lastName, contact.lblDate, contact.assetTitle, 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 @if ($assetTaskCount > 0) {{-- Display and count records --}} @php $totalRecordCount += $assetTaskCount; @endphp
  @endif @php $selectSQL = "SELECT contact.lblVersion, contact.ID, contact.activeRecord, contact.personalPrivacy, contact.firstName, contact.lastName, contact.lblDate, contact.assetTitle, 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 @if ($assetPosCount > 0) {{-- Display and count records --}} @php $totalRecordCount += $assetPosCount; @endphp
  @endif @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 @if ($comCount > 0) {{-- Display and count records --}} @php $totalRecordCount += $comCount; @endphp
  @endif @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 @if ($focusCount > 0) {{-- Display and count records --}} @php $totalRecordCount += $focusCount; @endphp {{-- Display composite rows --}} {!! showCompositeRow("13EG", $groupCode, $focusCount) !!} {!! showCompositeRow("13EM", $groupCode, $focusCount) !!} {!! showCompositeRow("13EF", $groupCode, $focusCount) !!}
  @endif @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 @if ($focusCount > 0) {{-- Display and count records --}} @php $totalRecordCount += $focusCount; @endphp {{-- Display composite rows --}} {!! showCompositeRow("13EG", $groupCode, $focusCount) !!} {!! showCompositeRow("13EM", $groupCode, $focusCount) !!} {!! showCompositeRow("13EF", $groupCode, $focusCount) !!}
  @endif * Names for ASI and OASI records that display in this color have requested
  that their personal contact information remain private from their group leader.  
** Group, Male, and Female Composites only display if more than one record is available to create the composite. For example,
    if there is a group with 8 records in it and there is only one male in the group, a male group composite cannot be created. @php // has an asset comparison been run if (!is_null($prevCompGroupCode) && $prevCompGroupCode !== "") { switch ($prevCompLblVer) { case "13R": $lblInitials = "ASI's"; break; case "13O": $lblInitials = "OASI's"; break; case "13AR": $lblInitials = "A-ASI's"; break; case "13AO": $lblInitials = "A-OASI's"; break; } $assetCompLink = "Group " . $prevCompGroupCode . " " . $lblInitials . " have been ranked against ASSET ID# " . $prevCompAssetID . ".  View the ranking
 
"; } @endphp @if (strlen($emailList) !== 0) @php $emailList = substr($emailList, 0, -1); @endphp @endif
@if ($totalRecordCount > 0) @if (request()->query('type') !== 'print') @endif @else {!! getBlockHtmlOpenTable($tableWidth, "fontMed") !!} {!! getBlockHtmlCloseTable() !!} @endif
{{ $assetCompLink }} Create a new Sub-Group Composite 
 
  Email the group 
 
{{ $editGroupHtml }}    {{ $editLeaderHtml }}
  {{ $viewSummaryHtml }}    {{ $emailSummaryHtml }}
{{ $emailAutoEmailsHtml }}
 

There are no records for this group on file.
@csrf
@if (request()->query('type') !== 'print')

Printer-friendly version
(page will open in a new window)

@endif
@csrf