File manager

File manager - Edit - /home/autoph/public_html/portal/nurse-station.php

Back
<?php include 'core/init.php'; $compCode =$user_data['company_assignment']; $deferred_session=$user_data['deferred_session']; $lab_check_out=$user_data['lab_check_out']; $nurse_access_only = $user_data['nurse_access_only']; $user = $user_data['u_name']; $page = $_SERVER['PHP_SELF']; $searchname = $_GET['searchname']; $getActiveWindow=$_GET['view']; $sec = "60"; header("Refresh: $sec; url=$page?view=$getActiveWindow&searchname=$searchname"); echo "<a href='nurse-station.php?view=wait'><input type='button' name='WaitingArea' value='Waiting Area' style='width:100px;height:30px;font-size:14px;font-weight:bold;color:blue'></a> <a href='nurse-station.php?view=on'><input type='button' name='OnGoing' value='Active Session' style='width:130px;height:30px;font-size:14px;font-weight:bold;color:blue'></a> <a href='nurse-station.php?view=in'><input type='button' name='viewin' value='Arrival Area' style='width:130px;height:30px;font-size:14px;font-weight:bold;color:blue'></a> <a href='logout.php'><input type='button' name='logout' value='Logout' style='width:100px;height:30px;font-size:14px;font-weight:bold;color:red'></a>"; switch($getActiveWindow){ case 'wait': echo "          <b style='font-size:18px;color:red'>WAITING AREA</b>"; break; case 'in': echo "          <b style='font-size:18px;color:red'>CHECK-IN</b>"; break; case 'out': echo "          <b style='font-size:18px;color:red'>CHECK-OUT</b>"; break; case 'on': echo "          <b style='font-size:18px;color:red'>ON-GOING SESSION</b>"; break; } switch($getActiveWindow){ //========================================================================================================================== //========================================================================================================================== case 'wait': //============================================================================================================== echo "<div style='width:100%;height:100%;border:2px solid lightgray;border-radius:5px;background:#fff;'>"; echo "<table style='width:100%;border-collapse:collapse:height:100%;background:white'>"; echo "<tr>"; echo "<td valign='TOP' style='border:1px solid white;font-size:14px;weight:bold;color:gray;background:white'>"; $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_id` ASC"); echo "<table style='width:100%; height:95% border:1px solid white; border-collapse:collapse;'>"; echo "<tr> <th class='Gradient' style='text-align:center;width:40px;background:lightgray;border:1px solid gray;font-size:13px;height:25px'>REC.NO</th> <th class='Gradient' align='center' style='width:150px;background:lightgray;border:1px solid gray;font-size:13px'>First Name</th> <th class='Gradient' align='center' style='width:100px;background:lightgray;border:1px solid gray;font-size:13px'>Middle Name</th> <th class='Gradient' align='center' style='width:150px;background:lightgray;border:1px solid gray;font-size:13px'>Last Name</th> <th class='Gradient' align='center' style='width:100px;background:lightgray;border:1px solid gray;font-size:13px'>Birth Date</th> <th class='Gradient' align='center' style='width:50px;background:lightgray;border:1px solid gray;font-size:13px'>Gender</th> <th class='Gradient' align='center' style='width:50px;background:lightgray;border:1px solid gray;font-size:13px'>Status</th> <th class='Gradient' align='center' style='width:50px;background:lightgray;border:1px solid gray;font-size:13px'> - </th> </tr>"; while($row = mysql_fetch_array($qq)){ $ptID = $row['index_patient_id']; echo "<tr>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;width:40px;height:25px'>" . $row['patient_id'] . "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:left;width:100px;height:25px'>" . $row['patient_fname'] . "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:left;width:150px;height:25px'>" . $row['patient_mname'] . "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:left;width:150px;height:25px'>" . $row['patient_lname'] . "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;width:150px;height:25px'>" . $row['patient_bday'] . "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;width:100px;height:25px'>" . $row['patient_sex']. "</td>"; echo "<td style='font-size:12px;color:red;border:1px solid lightgray;text-align:center;width:150px;height:25px'>" . $row['patient_status'] . "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;width:100px;height:30px'> "; echo "<a href='mainindex.php?view=checkin&start=check&hid=".$row['patient_id']."'><input type='button' name='gocheckin' value='Check-In' style='background:#A9F5A9;width:80px;height:25px;border:1px solid gray;font-size:14px;border-radius:5px'></a>"; echo "</td>"; echo "</tr>"; } echo "</table>"; echo "</td>"; echo "</tr>"; echo "</table>"; echo "</div>"; break; //========================================================================================================================== //========================================================================================================================== case 'in': //============================================================================================================== echo "<div style='width:100%;height:100%;border:2px solid lightgray;border-radius:5px;background:#fff;'>"; $q=mysql_query("SELECT * FROM `patient_list` WHERE `status`='In' 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 `status`='In' AND `branch_code`='$compCode' ORDER by `time_last_in` ASC"); echo "<table style='background:white;width:100%; height:95% border:1px solid white; border-collapse:collapse;'>"; echo "<tr> <th class='Gradient' style='text-align:center;width:100px;background:lightgray;border:1px solid gray;font-size:13px;height:25px'>Patient I.D</th> <th class='Gradient' align='left' style='width:200px;background:lightgray;border:1px solid gray;font-size:13px'>First Name</th> <th class='Gradient' align='left' style='width:150px;background:lightgray;border:1px solid gray;font-size:13px'>Middle Name</th> <th class='Gradient' align='left' style='width:200px;background:lightgray;border:1px solid gray;font-size:13px'>Last Name</th> <th class='Gradient' align='center' style='width:80px;background:lightgray;border:1px solid gray;font-size:13px'>Date In</th> <th class='Gradient' align='center' style='width:80px;background:lightgray;border:1px solid gray;font-size:13px'>Time In</th> <th class='Gradient' align='center' style='width:50px;background:lightgray;border:1px solid gray;font-size:13px'>Gender</th> <th class='Gradient' align='center' style='width:50px;background:lightgray;border:1px solid gray;font-size:13px'>Check-In Status</th> <th class='Gradient' align='center' style='width:50px;background:lightgray;border:1px solid gray;font-size:13px'>Treatment Status</th> <th class='Gradient' align='center' style='width:50px;background:lightgray;border:1px solid gray;font-size:13px'>-</th> </tr>"; while($row = mysql_fetch_array($qq)){ echo "<tr>"; $MyPatientID =$row['patient_id']; $myStatus = mysql_result(mysql_query("SELECT COUNT('session_id') FROM `treatment_session` WHERE `session_patient_id` ='$MyPatientID' AND `session_status` ='Pending' "),0); $sessionID = mysql_result(mysql_query("SELECT `session_id` FROM `treatment_session` WHERE `session_patient_id` ='$MyPatientID' AND `session_status` ='Pending' "),0); $sessionStatus = mysql_result(mysql_query("SELECT `session_status` FROM `treatment_session` WHERE `session_patient_id` ='$MyPatientID' AND `session_status`!='Closed'"),0); $checkOpenTX = mysql_result(mysql_query("SELECT `hold-tx` FROM `patient_list` WHERE `patient_id`='$MyPatientID'"),0); if($checkOpenTX ==='0'){ $bgColor = 'white'; }else { $bgColor = '#F5A9BC'; } if($myStatus >0) { $pStatus = 'Deferred'; }else { $pStatus = 'New Session'; } echo "<td style='background:$bgColor;font-size:13px;border:1px solid lightgray;text-align:center;width:40px;height:25px;text-align:center'>" . $row['patient_id'] . "</td>"; echo "<td style='background:$bgColor;font-size:13px;border:1px solid lightgray;text-align:left;width:100px;height:25px'>" . $row['patient_fname'] . "</td>"; echo "<td style='background:$bgColor;font-size:13px;border:1px solid lightgray;text-align:left;width:100px;height:25px'>" . $row['patient_mname'] . "</td>"; echo "<td style='background:$bgColor;font-size:13px;border:1px solid lightgray;text-align:left;width:150px;height:25px'>" . $row['patient_lname'] . "</td>"; echo "<td style='background:$bgColor;font-size:13px;border:1px solid lightgray;text-align:left;width:100px;height:25px;text-align:center'>" . $row['date_last_in'] . "</td>"; echo "<td style='background:$bgColor;font-size:13px;border:1px solid lightgray;text-align:left;width:100px;height:25px;text-align:center'>" . $row['time_last_in'] . "</td>"; echo "<td style='background:$bgColor;font-size:13px;border:1px solid lightgray;text-align:left;width:60px;height:25px;text-align:center'>" . $row['patient_sex'] . "</td>"; if($myStatus >0) { echo "<td style='background:$bgColor;font-size:13px;font-weight:normal;color:red;border:1px solid lightgray;text-align:left;width:150px;height:25px;text-align:center;background:#F8E0E6'>" . $pStatus . "</td>"; echo "<td style='background:$bgColor;font-size:13px;font-weight:bold;color:red;border:1px solid lightgray;text-align:left;width:150px;height:25px;text-align:center;background:#F8E0E6'>" . $sessionStatus . "</td>"; echo "<td style='background:$bgColor;font-size:13px;border:1px solid lightgray;text-align:left;width:150px;height:25px;text-align:center'><a href='mainindex.php?view=checkin-patient&status=Waiting&ID=".$sessionID."'>Resume</a></td>"; }else { echo "<td style='background:$bgColor;font-size:13px;font-weight:normal;color:green;border:1px solid lightgray;text-align:left;width:150px;height:25px;text-align:center;background:#D8F6CE'>" . $pStatus . "</td>"; echo "<td style='background:$bgColor;font-size:13px;font-weight:bold;color:red;border:1px solid lightgray;text-align:left;width:150px;height:25px;text-align:center;background:#F8E0E6'>" . $sessionStatus . "</td>"; if(empty($sessionStatus)){ if($checkOpenTX ==='1'){ echo "<td style='background:$bgColor;font-size:13px;border:1px solid lightgray;text-align:left;width:150px;height:25px;text-align:center'>- START -</td>"; }else { echo "<td style='background:$bgColor;font-size:13px;border:1px solid lightgray;text-align:left;width:150px;height:25px;text-align:center'>- <a href='nurse-station.php?view=in&searchname=&id=".$row['patient_id']."&searchname=".$row['patient_lname']."&tx-open=true'>START</a> -</td>"; } }else{ echo "<td style='background:$bgColor;font-size:13px;border:1px solid lightgray;text-align:left;width:150px;height:25px;text-align:center'>-</td>"; } } echo "</tr>"; } echo "</table>"; echo "</div>"; break; //========================================================================================================================== //========================================================================================================================== case 'on': //============================================================================================================== echo "<div style='width:100%;height:100%;border:2px solid lightgray;border-radius:5px;background:#fff;'>"; echo "<table style='width:100%;border-collapse:collapse:height:100%;background:white'>"; echo "<tr>"; echo "<td valign='TOP' style='border:1px solid white;font-size:14px;weight:bold;color:gray;background:white'>"; $q=mysql_query("SELECT * FROM `pindex_hdr` WHERE `index_hdr_status`='On-Going' AND `branch_code`='$compCode'"); $row=mysql_fetch_array($q); $total=mysql_num_rows($q); $dis=30; $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`='On-Going' AND `branch_code`='$compCode' ORDER by `session_lname` ASC"); echo "<table style='width:100%; height:95% border:1px solid white; border-collapse:collapse;'>"; echo "<tr> <th class='Gradient' style='text-align:center;width:80px;background:#f5f5f5;border:1px solid gray;font-size:13px;height:25px'>Trans I.D</th> <th class='Gradient' style='text-align:center;width:80px;background:#f5f5f5;border:1px solid gray;font-size:13px;height:25px'>Patient I.D</th> <th class='Gradient' align='left' style='width:200px;background:#f5f5f5;border:1px solid gray;font-size:13px'>First Name</th> <th class='Gradient' align='left' style='width:200px;background:#f5f5f5;border:1px solid gray;font-size:13px'>Last Name</th> <th class='Gradient' align='center' style='width:50px;background:#f5f5f5;border:1px solid gray;font-size:13px'>Start Date</th> <th class='Gradient' align='center' style='width:50px;background:#f5f5f5;border:1px solid gray;font-size:13px'>Start Time</th> <th class='Gradient' align='center' style='width:50px;background:#f5f5f5;border:1px solid gray;font-size:13px'>-</th> <th class='Gradient' align='center' style='width:50px;background:#f5f5f5;border:1px solid gray;font-size:13px'>-</th> <th class='Gradient' align='center' style='width:50px;background:#f5f5f5;border:1px solid gray;font-size:13px'>-</th> </tr>"; while($row = mysql_fetch_array($qq)){ echo "<tr>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;width:40px;height:25px'>" . $row['session_header_id'] . "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;width:40px;height:25px'>" . $row['session_patient_id'] . "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:left;width:150px;height:25px'>" . $row['session_fname'] . "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:left;width:150px;height:25px'>" . $row['session_lname'] . "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;width:50px;height:25px'>" . $row['session_date_started'] . "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;width:80px;height:25px'>" . $row['session_time_started'] . "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;width:100px;height:25px'> <abbr title='Update Record'><a href='nurse-station.php?ID=".$row['session_id']."&view=updateindex&pID=".$row['session_patient_id']."&hID=".$row['session_header_id']."'><img src='images/refresh.png' width='20px' height='20x'><br>Update</img> </a></abbr></td>"; echo "<td style='font-size:10px;border:1px solid lightgray;text-align:center;width:80px;height:25px'> <abbr title='Deferred Session'><a href='nurse-station.php?view=on&deferred=check&ID=".$row['session_id']."&hID=".$row['session_header_id']."&pID=".$row['session_patient_id']."&fname=".$row['session_fname']."&lname=".$row['session_lname']."'><img src='images/defferred.png' width='20px' height='20x'><br>Deferred</img></a></abbr> </td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;width:100px;height:25px'> <abbr title='Completed Treatment Session'><a href='nurse-station.php?ID=".$row['session_id']."&view=on&action=labcheckout&pID=".$row['session_patient_id']."&hID=".$row['session_header_id']."&fname=".$row['session_fname']."&lname=".$row['session_lname']."'><img src='images/stop.png' width='20px' height='20x'><br>Lab Check-Out</img> </a></abbr></td>"; echo "</tr>"; } echo "<tr>"; echo "<td align ='center' colspan='9' style='border:1px solid white;background-color:#fff'> <br>"; if($page_cur>1){ echo '<a href="nurse-station.php?page='.($page_cur-1).'&view=on"> style="cursor:pointer;color:lightgray;" > <input style="cursor:pointer;background-color:lightgray;border:1px lightgray solid;border-radius:5px;width:100px;height:35px;color:green;font-size:16px;font-weight:bold;" type="button" value=" Previous "></a>'; }else { echo '<input style="background-color:lightgray;border:1px lightgray solid;border-radius:35px 0px 0px 35px;width:100px;height:35px;color:blue;font-size:16px;font-weight:bold;" type="button" value=" Previous ">'; } echo '<font color = "red"> <b>[ ' . $page_cur . ' of ' . $total_page . ' ] </font> </b> '; for($i=1;$i<=$total_page;$i++) { //if($page_cur==$i) //{ // echo ' <input style="background-color:lightgray;border:1px red solid;border-radius:1px;width:30px;height:20px;color:red;font-size:12px;font-weight:normal;" type="button" value="'.$i.'"> '; //} //else //{ //echo '<a href="mydocuments.php?page='.$i.'"> <input style="cursor:pointer;background-color:lightgray;border:1px black solid;border-radius:1px;width:30px;height:20px;color:green;font-size:12px;font-weight:normal;" type="button" value="'.$i.'"> </a>'; //} } if($page_cur<$total_page) { echo '<a href="nurse-station.php?page='.($page_cur-1).'&view=on"> <input style="cursor:pointer;background-color:lightgray;border:1px lightgray solid;border-radius:1px;width:100px;height:35px;color:green;font-size:16px;font-weight:bold;" type="button" value=" Next "></a>'; } else { echo '<input style="background-color:lightgray;border:1px lightgray solid;border-radius:0px 35px 35px 0px;width:100px;height:35px;color:blue;font-size:16px;font-weight:bold;" type="button" value=" Next ">'; } echo "<br><br></td>"; echo "</tr>"; echo "</table>"; echo "</td>"; echo "</tr>"; echo "</table>"; echo "</div>"; break; } //========================================================================================== //========================================================================================== if(isset($_GET['deferred'])){ $deferred=$_GET['deferred']; if($deferred==='check'){ $fname =$_GET['fname']; $lname =$_GET['lname']; $pID =$_GET['pID']; $hID =$_GET['hID']; $ID =$_GET['ID']; echo " <center> <div style='float:left;position:absolute;width:550px;height:200px;left:250px;top:100px;border:5px solid red;border-radius:5px;background:#EFFBFB'> <table> <tr> <td align='center' style='height:180px;font-size:14px;font-weight:bold;color:red;width:500px;background:#EFFBFB;border:1px solid white'><br> Are you sure want to deferred treatment session of <b style='font-size:18px;color:blue'>".$fname." ".$lname."?</b></font> <br><br><br><br> <a href='nurse-station.php?&fname=".$fname."&lname=".$lname."&view=on&pID=".$pID."&hID=".$hID."&action=&deferred=true&ID=".$ID."&window=fullview&tab=as'><input style='background-color:#E5E4E2;border:1px black solid;border-radius:5px;width:120px;height:30px;color:black;font-size:16px;font-weight:bold;'type ='button' name ='exit' value = 'Yes'> </a>    <a href='nurse-station.php?view=on'><input style='background-color:#E5E4E2;border:1px black solid;border-radius:5px;width:120px;height:30px;color:black;font-size:16px;font-weight:bold;'type ='button' name ='exit' value = 'No'> </a> <br><br> </td> </tr> </table> </div></center>"; } } if(isset($_GET['deferred'])){ $deferred=$_GET['deferred']; if($deferred==='true'){ $ID = $_GET['ID']; $pID = $_GET['pID']; //mysql_query("UPDATE `patient_list` SET `status` = 'Out' WHERE `patient_id`='$pID'"); mysql_query("UPDATE `treatment_session` SET `session_status` = 'Deferred' WHERE `session_id`='$ID'"); } } //lab checkout confirmation if($_GET['action']==='labcheckout'){ $fname =$_GET['fname']; $lname =$_GET['lname']; $pID =$_GET['pID']; $hID =$_GET['hID']; $ID =$_GET['ID']; echo "Action"; echo " <center> <div style='position:absolute;width:550px;height:200px;left:250px;top:100px;border:5px solid red;border-radius:5px;background:#EFFBFB'> <table> <tr> <td align='center' style='height:180px;font-size:14px;font-weight:bold;color:red;width:500px;background:#EFFBFB;border:1px solid white'><br> Treatment Session completed. Confirm Laboratory Check-out<br><br>Name of Patient: <b style='font-size:18px;color:blue'>".$fname." ".$lname."</b></font> <br><br><br><br> <a href='nurse-station.php?&fname=".$name."&lname=".$lname."&view=on&pID=".$pID."&hID=".$hID."&action=pout&ID=".$ID."&window=fullview&tab=as'><input style='background-color:#E5E4E2;border:1px black solid;border-radius:5px;width:120px;height:30px;color:black;font-size:16px;font-weight:bold;'type ='button' name ='exit' value = 'Check-Out'> </a>    <a href='nurse-station.php?view=on'><input style='background-color:#E5E4E2;border:1px black solid;border-radius:5px;width:120px;height:30px;color:black;font-size:16px;font-weight:bold;'type ='button' name ='exit' value = 'Cancel'> </a> <br><br> </td> </tr> </table> </div>"; } if($_GET['action']==='pout'){ $fname =$_GET['fname']; $lname =$_GET['lname']; $pID =$_GET['pID']; $hID =$_GET['hID']; $ID =$_GET['ID']; mysql_query("UPDATE `treatment_session` SET `session_status`='Billing',`session_date_ended`='$toDate', `session_time_ended` = '$currentTime' WHERE `session_id`='$ID' AND `branch_code`='$compCode'"); echo " <center> <div style='float:left;position:absolute;width:550px;height:200px;left:250px;top:100px;border:5px solid red;border-radius:5px;background:#EFFBFB'> <table> <tr> <td align='center' style='height:180px;font-size:14px;font-weight:bold;color:red;width:500px;background:#EFFBFB;border:1px solid white'><br> Check-Out Request has been Confirmed...<br><br></font> <br><br><br><br> <a href='nurse-station.php?view=on'><input style='background-color:#E5E4E2;border:1px black solid;border-radius:5px;width:120px;height:30px;color:black;font-size:16px;font-weight:bold;'type ='button' name ='exit' value = 'Close'> </a> <br><br> </td> </tr> </table> </div>"; } //============================================================================================ if(isset($_GET['start'])){ if($start==='check'){ $fname =$_GET['fname']; $lname =$_GET['lname']; $pID =$_GET['pID']; $hID =$_GET['hID']; $ID =$_GET['ID']; echo " <center> <div style='float:left;position:absolute;width:550px;height:200px;left:250px;top:100px;border:5px solid red;border-radius:5px;background:#EFFBFB'> <table> <tr> <td align='center' style='height:180px;font-size:14px;font-weight:bold;color:red;width:500px;background:#EFFBFB;border:1px solid white'><br> Are you sure want to deferred treatment session of <b style='font-size:18px;color:blue'>".$fname." ".$lname."?</b></font> <br><br><br><br> <a href='nurse-station.php?&fname=".$fname."&lname=".$lname."&view=on&pID=".$pID."&hID=".$hID."&action=&deferred=true&ID=".$ID."&window=fullview&tab=as'><input style='background-color:#E5E4E2;border:1px black solid;border-radius:5px;width:120px;height:30px;color:black;font-size:16px;font-weight:bold;'type ='button' name ='exit' value = 'Yes'> </a>    <a href='nurse-station.php?view=wait&start=true'><input style='background-color:#E5E4E2;border:1px black solid;border-radius:5px;width:120px;height:30px;color:black;font-size:16px;font-weight:bold;'type ='button' name ='exit' value = 'No'> </a> <br><br> </td> </tr> </table> </div></center>"; } } if(isset($_GET['tx-open'])){ $pID = $_GET['id']; mysql_query("UPDATE `patient_list` SET `hold-tx`='1',`date_last_in`='$toDate', `time_last_in` = '$currentTime' WHERE `patient_id`='$pID' AND `branch_code`='$compCode'"); //update logs for session started without payment $sql="INSERT INTO `unpaid_active_session` (`rec_id`, `patient_id`, `date`, `time`, by`, `branch_code`) VALUES('','$pID','$toDate','$currentTime','$user','$compCode')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); } } if(isset($_GET['start'])){ $start=$_GET['start']; if($start==='true'){ $transID = $_GET['hID']; $patientID = $_GET['pID']; $ID = $_GET['ID']; mysql_query("UPDATE `treatment_session` SET `session_status`='On-Going',`session_date_started`='$toDate', `session_time_started` = '$currentTime' WHERE `session_id`='$ID' AND `branch_code`='$compCode'"); echo "<div class='divMSG'> <table> <tr> <td align='center' style='font-size:14px;font-weight:bold;color:red;width:500px;height:140px;background:white;border:1px solid white'><br> Treatment Session has been started. <br><br>Thank you!.<br><br><br> <a href='mainindex.php?view=waiting&window=fullview&tab=wa'><input type='button' value='Close' style='width:80px;height:30px;border:1px solid gray;border-radius:3px;font-size:16px;font-weight:bold'></a> </td> </tr> </table> </div>"; } }//========================================================================================== //========================================================================================== ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings