<?php
$strTableName="Current Patients";
$strOriginalTableName="patients";
$gPageSize=100;
$gstrOrderBy="ORDER BY `Ward` ASC, `Bed` ASC";
if(strlen($gstrOrderBy) && strcasecmp(substr($gstrOrderBy,0,8),"order by"))
$gstrOrderBy="order by ".$gstrOrderBy;
$gstrSQL = "select `Primary`, `Patient Name`, `Date of Birth`, `Unit Number`, `Sex`, `Ward`, `Bed`, `Consultant`, `Code`, `Category`, `Admission Date`, `Diagnosis`, `Allergies`, `Notes`, `Nurses`, `Social Services`, `Team`, `Ward Round Notes` From `patients` WHERE `Category` = \"Inpatient\"";
// thumbnails
$thumbnail_fields = array();
// $thumbnail_fields = array("Field1","Field2");
// field names are case-sensitive!
$thumbnail_prefixes = array();
// $thumbnail_prefixes = array("Field1"=>"t1_" , "Field2"=>"t2_");
$thumbnail_maxsize = 150;
$ColumnsCount = 1;
include("include/Current_Patients_events.php");
?>