Location: PHPKode > projects > Clinical Handover Database > output/include/Ward_Round_Sheet_variables.php
<?php

$strTableName="Ward Round Sheet";

$strOriginalTableName="consultants";
$gPageSize=100;

$gstrOrderBy="ORDER BY `Consultant` 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/Ward_Round_Sheet_events.php");
?>
Return current item: Clinical Handover Database