"; switch($getActiveWindow){ case 'wait': echo " WAITING AREA"; break; case 'in': echo " CHECK-IN"; break; case 'out': echo " CHECK-OUT"; break; case 'on': echo " ON-GOING SESSION"; break; case 'chk': echo " ARRIVAL AREA"; break; } //===================================================== if(isset($_GET['action'])){ $getID = $_GET['hid']; //mysql_query("UPDATE `patient_list` SET `status` = 'In' WHERE `patient_id`='$getID'"); mysql_query("UPDATE `patient_list` SET `status` = 'In' WHERE `patient_id`='$getID'"); $sql="INSERT INTO `in_out` (`log_id`, `patient_id`, `log_date`, `log_time`, `trans_type`, `log_by`, `branch_code`,`notes`) VALUES('','$getID','$toDate','$currentTime','In','$user','$compCode','Check-In')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); } echo "

Check-In Request has been confirmed.

Thank you!

"; } switch($getActiveWindow){ case 'chk': //============================================================================================================== echo "

"; echo ""; $searchname=$_GET['searchname']; //echo $searchname; echo ""; echo ""; echo ""; echo "

"; $qq=mysql_query("SELECT * FROM `patient_list` WHERE `status`='In' AND `branch_code`='$compCode' ORDER by `time_last_in` ASC"); echo ""; echo ""; while($row = mysql_fetch_array($qq)){ $ptID = $row['index_patient_id']; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

REC.NO	First Name	Last Name	Date IN	Time IN	Status
" . $row['patient_id'] . "	" . $row['patient_fname'] . "	" . $row['patient_lname'] . "	" . $row['date_last_in'] . "	" . $row['time_last_in']. "	" . $row['status'] . "

"; echo "

"; break; case 'in': //============================================================================================================== echo "

"; echo ""; echo ""; echo ""; echo ""; if(!empty($_GET['searchname'])){ $searchname=$_GET['searchname']; //echo $searchname; echo ""; echo ""; echo ""; } echo "

"; $q=mysql_query("SELECT * FROM `patient_list` WHERE `patient_lname` LIKE '%$searchname%' AND `status`='OUT' AND `branch_code`='$compCode'"); $row=mysql_fetch_array($q); $total=mysql_num_rows($q); $dis=20; $total_page=ceil($total/$dis); $page_cur=(isset($_GET['page']))?$_GET['page']:1; $k=($page_cur-1)*$dis; $page_cur = mysql_real_escape_string($page_cur); $qq=mysql_query("SELECT * FROM `patient_list` WHERE `patient_lname` LIKE '%$searchname%' AND `status`='OUT' AND `branch_code`='$compCode' ORDER by `patient_id` ASC"); echo ""; echo ""; while($row = mysql_fetch_array($qq)){ $ptID = $row['index_patient_id']; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

REC.NO	First Name	Middle Name	Last Name	Birth Date	Gender	Status	-
" . $row['patient_id'] . "	" . $row['patient_fname'] . "	" . $row['patient_mname'] . "	" . $row['patient_lname'] . "	" . $row['patient_bday'] . "	" . $row['patient_sex']. "	" . $row['patient_status'] . "	"; echo ""; echo "

"; echo "

"; break; case 'wait': //============================================================================================================== echo "

"; echo ""; echo ""; echo ""; echo ""; echo "

"; $q=mysql_query("SELECT * FROM `treatment_session` WHERE `session_status`='Waiting' AND `branch_code`='$compCode' ORDER by `session_lname` ASC"); $row=mysql_fetch_array($q); $total=mysql_num_rows($q); $dis=20; $total_page=ceil($total/$dis); $page_cur=(isset($_GET['page']))?$_GET['page']:1; $k=($page_cur-1)*$dis; $page_cur = mysql_real_escape_string($page_cur); $qq=mysql_query("SELECT * FROM `treatment_session` WHERE `session_status`='Waiting' AND `branch_code`='$compCode' ORDER by `session_lname` ASC"); echo ""; echo ""; while($row = mysql_fetch_array($qq)){ $ptID = $row['session_patient_id']; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

REC.NO	First Name	Middle Name	Last Name	Status
" . $row['session_patient_id'] . "	" . $row['session_fname'] . "	" . $row['session_mname'] . "	" . $row['session_lname'] . "	" . $row['session_status'] . "

"; echo "

"; break; case 'on': //============================================================================================================== echo "

"; echo ""; echo ""; echo ""; echo ""; echo "

"; $qq=mysql_query("SELECT * FROM `treatment_session` WHERE `session_status`='On-Going' AND `branch_code`='$compCode' ORDER by `session_lname` ASC"); //$qq=mysql_query("SELECT * FROM `treatment_session` WHERE `session_status`='On-Going' AND `branch_code`='$compCode' ORDER by `session_lname` ASC"); echo ""; echo ""; while($row = mysql_fetch_array($qq)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

Trans I.D	Patient I.D	First Name	Last Name	Start Date	Start Time	End Time
" . $row['session_header_id'] . "	" . $row['session_patient_id'] . "	" . $row['session_fname'] . "	" . $row['session_lname'] . "	" . $row['session_date_started'] . "	" . $row['session_time_started'] . "	" . $row['session_time_ended'] . "

"; echo "

"; break; case 'out': $searchname=$_GET['searchname']; if(isset($_GET['searchname'])){ $searchname = $_GET['searchname']; $q=mysql_query("SELECT * FROM `treatment_session` WHERE `session_status`='Cleared' AND `session_lname` LIKE '%$searchname%' AND `branch_code`='$comCode'"); $row=mysql_fetch_array($q); $total=mysql_num_rows($q); $dis=20; $total_page=ceil($total/$dis); $page_cur=(isset($_GET['page']))?$_GET['page']:1; $k=($page_cur-1)*$dis; $page_cur = mysql_real_escape_string($page_cur); $qq=mysql_query("SELECT * FROM `treatment_session` WHERE `session_status`='Cleared' AND `session_lname` LIKE '%$searchname%' AND `branch_code`='$comCode' ORDER by `session_id` ASC"); }else{ $q=mysql_query("SELECT * FROM `treatment_session` WHERE `session_status`='Cleared' AND `branch_code`='$comCode'"); $row=mysql_fetch_array($q); $total=mysql_num_rows($q); $dis=20; $total_page=ceil($total/$dis); $page_cur=(isset($_GET['page']))?$_GET['page']:1; $k=($page_cur-1)*$dis; $page_cur = mysql_real_escape_string($page_cur); $qq=mysql_query("SELECT * FROM `treatment_session` WHERE `session_status`='Cleared' || `session_status`='Cancelled' || `session_status`='Deferred' AND `branch_code`='$comCode' ORDER by `session_id` ASC"); } echo ""; echo ""; while($row = mysql_fetch_array($qq)){ $ptID = $row['session_patient_id']; $gender = mysql_result(mysql_query("SELECT `patient_sex` FROM `patient_list` WHERE `patient_id`='$ptID'"),0); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

REC.NO	Transaction Number	First Name	Last Name	Gender	Status	-
" . $row['session_id'] . "	" . $row['session_header_id'] . "	" . $row['session_fname'] . "	" . $row['session_lname'] . "	" . $gender . "	" . $row['session_status']. "	"; echo "

"; break; } ?>