@php $tableWidth=400; $pageTitle=''; $pageIconHtml=''; $pageIcon2Html=''; $oldColSpan=10; @endphp <%=application("baseTitle")%><%=pageTitle%>
<%=pageTitle%> <%=pageIconHtml%><%=pageIcon2Html%>

<% if session("adminAccess") then asiCountRange = 10 %>
<% newASIs = 0 rsDB.Open "SELECT COUNT(ID) AS newASIs FROM contact WHERE dateAdded >= '" & formatDate(date()-14) & "'", instConn,1,1 ' AND groupCode < 9000 if not rsDB.EOF AND not rsDB.BOF then newASIs = rsDB("newASIs") rsDB.Close updatedASIs = 0 rsDB.Open "SELECT COUNT(ID) AS updatedASIs FROM contact WHERE dateUpdated >= '" & formatDate(date()-14) & "' AND dateAdded <> dateUpdated", instConn,1,1 if not rsDB.EOF AND not rsDB.BOF then updatedASIs = rsDB("updatedASIs") rsDB.Close deletedASIs = 0 rsDB.Open "SELECT COUNT(ID) AS deletedASIs FROM contact WHERE dateAdded >= '" & formatDate(date()-14) & "' AND activeRecord=0", instConn,1,1 if not rsDB.EOF AND not rsDB.BOF then deletedASIs = rsDB("deletedASIs") rsDB.Close newASIinfo = formatS(newASIs,"new record","new records") & " added" updatedASIinfo = formatS(updatedASIs,"record","records") & " updated" deletedASIinfo = formatS(deletedASIs,"record","records") & " deleted" newASIinfoLink = "" & newASIinfo & "" updatedASIinfoLink = "" & updatedASIinfo & "" deletedASIinfoLink = "" & deletedASIinfo & "" colSpan = 3 %> <% rowFormat = "tableFont" extraField = " " Response.Write("" & chr(10)) Response.Write("" & chr(10)) Response.Write("" & chr(10)) Response.Write("" & chr(10)) call closeTable(tableWidth,colSpan)' ../ssi/asi_record_display.asp Response.Write("
") end if ' session("adminAccess") colSpan = 8 %>
14 Day ASI & OASI Inventory Activity (<%=date()-14%> to <%=date()%>)
" & newASIinfoLink & ", " & updatedASIinfoLink & ", " & deletedASIinfoLink & "" & extraField & "
<% oldColSpan = 3'colSpan oldTableWidth = tableWidth colSpan = 8 tableWidth = tableWidth - 20 ' space minus Vertical Name Column %>
Inventories
  <% call setUpRecordsSpacers(tableWidth,colSpan) ' Column spacers %>
ID
number		 L-BL
Date		 L-BL
version		 Group
code		  User name      
@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
@php //call setUpRecordsSpacers(tableWidth,colSpan) ' ../ssi/asi_record_display.asp $results = DB::table('contact') ->select('contact.*', 'demog.sex') ->join('demog', 'contact.ID', '=', 'demog.ID') ->where('groupCode', '>', 0) ->where('lblVersion', '13AR') ->orderByDesc('dateUpdated') ->orderByDesc('groupCode') ->take(20) ->get(); displaySearchData($tableWidth,$colSpan,$listCount,$results); //call hr() ' ../ssi/functions_record_display.asp @endphp
@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
@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
@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
@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
@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
@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
@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
<% ' Personal contact information remains private from their group leader Response.Write("" & chr(10)) %>
* Records are displayed on this page based on the last time a record was updated, not the original creation date.
* Names for ASI and OASI records that display in this color have requested
  that their personal contact information remain private from their group leader.
<% ' delete selected icon if session("deleteActive") then Response.Write("" & chr(10)) %>