File manager

File manager - Edit - /home/autoph/public_html/portal/includes/lab/transient.php

Back
<?php $compCode = $user_data['company_assignment']; $user = $user_data['u_name']; $pid = $_GET['id']; $fname=mysql_result(mysql_query("SELECT `patient_fname` FROM `patient_list` WHERE `patient_id`='$pid'"),0); $lname=mysql_result(mysql_query("SELECT `patient_lname` FROM `patient_list` WHERE `patient_id`='$pid'"),0); $patient_dateencoded=mysql_result(mysql_query("SELECT `patient_dateencoded` FROM `patient_list` WHERE `patient_id`='$pid'"),0); $expiredDate=mysql_result(mysql_query("SELECT `expired_date` FROM `patient_list` WHERE `patient_id`='$pid'"),0); $homeaddress=mysql_result(mysql_query("SELECT `patient_paddress` FROM `patient_list` WHERE `patient_id`='$pid'"),0); $patientStatus=mysql_result(mysql_query("SELECT `nephro_status` FROM `patient_list` WHERE `patient_id`='$pid'"),0); $newLocation=mysql_result(mysql_query("SELECT `new_location` FROM `expired_patient` WHERE `pid`='$pid'"),0); if(isset($_POST['submitOFF'])){ $regCity = $_POST['regCity']; $pID = $_POST['pID']; $xDate = $_POST['expiredDate']; $notes = "DeActivated-".$_POST['notes']; $notes = mysql_real_escape_string($notes); mysql_query("UPDATE `pindex_hdr` SET `index_hdr_status`='Closed' WHERE `index_patient_id`='$pID' AND `branch_code`='$compCode'"); mysql_query("UPDATE `patient_list` SET `isActive`='0',`nephro_status`='Transient',`expired_date`='$xDate',`expired_by`='$user' WHERE `patient_id`='$pID' AND `branch_code`='$compCode'"); $sql="INSERT INTO `expired_patient` (`exp_id`,`pid`,`date_expired`,`time_expired`,`date_tagged`,`time_tagged`,`tagged_by`,`reasons`,`branch_code`,`new_location`) VALUES('','$pID','$xDate','$currentTime','$toDate','$currentTime','$user','$notes','$compCode','$regCity')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else { echo "<center><div style='position:absolute;width:300px;height:140px;left:260px;top:200px;border:2px solid red;border-radius:5px;background:#FFF'>"; echo "<h3>PROFILE DEACTIVATED:</h3>"; echo "<br><br><b style='font-size:18px;font-weight:bold'><center>Update Complete</b>"; echo "<br><br><a href='laboratory_index.php?search=".$_GET['search']."&view=plist&id=".$_GET['id']."&subView=xient'><input type='button' value='Close' style='width:80px;height:30px;border-radius:3px;border:1px solid gray'></a></center>"; echo "</div></center>"; } } if(isset($_POST['submitON'])){ $regCity = $_POST['regCity']; $pID = $_POST['pID']; $xDate = $_POST['expiredDate']; $notes ="Activated-". $_POST['notes']; $notes = mysql_real_escape_string($notes); mysql_query("UPDATE `pindex_hdr` SET `index_hdr_status`='Open' WHERE `index_patient_id`='$pID' AND `branch_code`='$compCode'"); mysql_query("UPDATE `patient_list` SET `isActive`='1',`nephro_status`='Active',`expired_date`='$xDate',`expired_by`='$user' WHERE `patient_id`='$pID' AND `branch_code`='$compCode'"); $sql="INSERT INTO `expired_patient` (`exp_id`,`pid`,`date_expired`,`time_expired`,`date_tagged`,`time_tagged`,`tagged_by`,`reasons`,`branch_code`,`new_location`) VALUES('','$pID','$xDate','$currentTime','$toDate','$currentTime','$user','$notes','$compCode','$regCity')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else { echo "<center><div style='position:absolute;width:300px;height:140px;left:260px;top:200px;border:2px solid red;border-radius:5px;background:#FFF'>"; echo "<h3>PROFILE ACTIVATED:</h3>"; echo "<br><br><b style='font-size:18px;font-weight:bold'><center>Update Complete</b>"; echo "<br><br><a href='laboratory_index.php?search=".$_GET['search']."&view=plist&id=".$_GET['id']."&subView=xient'><input type='button' value='Close' style='width:80px;height:30px;border-radius:3px;border:1px solid gray'></a></center>"; echo "</div></center>"; } } ?> <script type="text/javascript"> function addDateSeparator(e, control, format){ this.Format = format; var keycode = (e.which) ? e.which : event.keyCode if (keycode > 31 && (keycode < 48 \|\| keycode > 57)){ return false; }else{ var DateFormatPattern = /^dd\/mm\/yyyy$\|^mm\/dd\/yyyy$\|^mm\/dd\/yyyy$\|^yyyy\/mm\/dd$/; if ( DateFormatPattern.test(this.Format) ){ var SplitFormat = this.Format.split("/"); if ( control.value.length >= this.Format.length ){ if ( keycode !=8){ return false; } } if ( control.value.length == SplitFormat[0].length ){ if ( keycode !=8){ control.value += '/'; } } if ( control.value.length == (SplitFormat[1].length + SplitFormat[0].length +1) ){ if ( keycode !=8){ control.value += '/'; } } }else{ alert("Supplied date format parameter is incorrect."); } } }</script> <h3 style='background:lightgray;padding-left:10px;border:1px solid lightgray;border-right:1px solid white'> TRANSIENT PATIENT</h3> <div STYLE='height:435px; width: 99.75%; font-size: 12px; overflow: auto;border:1px solid lightgray'> <center><table style ="width:70%;height:200px;border:1px solid white;background:white"> <form action="" method="POST"> <input type="hidden" name ="pID" value="<?php echo $pid;?>"> <tr> <td valign="TOP" align="right" style='width:20%;background:white;border:1px solid white;font-size:12px;font-weight:normal'>Name of Patient:</td> <td valign="TOP" align="left" style='width:80%;background:white;border:1px solid white;font-size:12px;font-weight:bold'><?php echo $fname ." ". $lname;?></td> </tr> <tr> <td valign="TOP" align="right" style='width:20%;background:white;border:1px solid white;font-size:12px;font-weight:normal'>Status:</td> <td valign="TOP" align="left" style='width:80%;background:white;border:1px solid white;font-size:12px;font-weight:bold;color:red'><?php echo $patientStatus ." <i style='font-size:12px;color:blue'>( ".$newLocation." )</i>";?></td> </tr> <?php if($patientStatus==='Expired' \|\| $patientStatus==='Cured'){ $expirdeDateEnabed='Disabled'; ?> <tr> <td valign="TOP" align="right" style='width:20%;background:white;border:1px solid white;font-size:12px;font-weight:normal'>Date Expired:</td> <td valign="TOP" align="left" style='width:80%;background:white;border:1px solid white;font-size:12px;font-weight:bold'><?php echo $expiredDate;?></td> </tr> <?php }else { $expirdeDateEnabed='Enable'; ?> <tr> <td valign="TOP" align="right" style='width:20%;background:white;border:1px solid white;font-size:12px;font-weight:normal'>Date Admitted:</td> <td valign="TOP" align="left" style='width:80%;background:white;border:1px solid white;font-size:12px;font-weight:bold'><?php echo $patient_dateencoded;?></td> </tr> <?php } ?> <tr> <td valign="TOP" align="right" style='width:20%;background:white;border:1px solid white;font-size:12px;font-weight:normal'>Home Address:</td> <td valign="TOP" align="left" style='width:80%;background:white;border:1px solid white;font-size:12px;font-weight:bold'><?php echo $homeaddress;?></td> </tr> <tr> <td valign="TOP" align="right" style='width:20%;background:white;border:1px solid white;font-size:12px;font-weight:normal'>Date:</td> <td valign="TOP" align="left" style='width:80%;background:white;border:1px solid white;font-size:12px;font-weight:normal'> <input id='datepicker' <?php echo $expirdeDateEnabed;?> type="text" name="expiredDate" value ="<?php echo $toDate;?>" style="font-size:14px;font-weight:normal;color:blue;width:100px;height:20px;border:1px solid lightgray;text-align:left;background:white" onkeyup="addDateSeparator(event,this,'dd/mm/yyyy')" placeholder="mm/dd/yyyy" required> From Location: <select name="regCity" <?php echo $expirdeDateEnabed;?> style="width:40%;font-size:12px;color:blue;border;1px solid lightgry;border:1px solid lightgray;background:white" required> <option> <?php echo $regCity;?> </option> <?php $getreg = mysql_query("SELECT * FROM `region` WHERE `reg_status`= '1' ORDER by `reg_city` ASC"); while($myReg = mysql_fetch_array($getreg)){ ?> <option style="font-size:12px;color:gray;"><?php echo $myReg['reg_city'];?></option> <?php } ?> </select> </td> </tr> <tr> <td valign="TOP" align="right" <?php echo $expirdeDateEnabed;?> style='width:20%;background:white;border:1px solid white;font-size:12px;font-weight:normal'>Name of Center:</td> <td valign="TOP" align="left" style='width:80%;background:white;border:1px solid white;font-size:12px;font-weight:normal'> <input type='text' name='transTo' <?php echo $expirdeDateEnabed;?> style="font-size:14px;font-weight:normal;color:blue;width:100%;height:20px;border:1px solid lightgray;text-align:left;background:white" placeholder="Optional"> <br> </td> </tr> <tr> <td valign="TOP" align="right" style='width:20%;background:white;border:1px solid white;font-size:12px;font-weight:normal'>Reasons:</td> <td valign="TOP" align="left" style='width:80%;background:white;border:1px solid white;font-size:12px;font-weight:normal'> <textarea name='notes' <?php echo $expirdeDateEnabed;?> style='width:100%;border:1px solid lightgray;background:white'></textarea> </td> </tr> <tr> <td colspan='2' valign="TOP" align="center" style='background:white;white;border:1px solid white;border-bottom:1px solid lightgray;font-size:16px;font-weight:normal'><br> <?php if($patientStatus==='Expired' \|\| $patientStatus ==='Cured'){ echo "<p style='font-size:14px;color:red'>Patient Already ".$patientStatus." <br> </p>" ; }else{ echo "Please confirm status of <b style='font-size:14px;color:red;'>".$lname. "," .$fname. "</b>. <br> <i style='font-size:12px'>If you continue, patient will consider as inactive..." ; }?> </td> </tr> <tr> <td colspan='2' valign="TOP" align="center" style='background:white;white;border:1px solid white;font-size:16px;font-weight:normal'><br> <?php if($patientStatus ==='Transient'){ echo "<input type='submit' name='submitON' value='Activate' style='width:100px;border:1px solid gray;border-radius:3px;height:40px;font-size:16px;font-weight:bold'>"; echo "<a href='laboratory_index.php?search=".$_GET['search']."&view=plist&id=".$_GET['id']."'><input type='button' name='cancel' value='Close' style='width:100px;border:1px solid gray;border-radius:3px;height:40px;font-size:16px;font-weight:bold'></a>"; } if($patientStatus ==='Active'){ echo "<input type='submit' name='submitOFF' value='DeActivate' style='width:100px;border:1px solid gray;border-radius:3px;height:40px;font-size:16px;font-weight:bold' >"; echo "<a href='laboratory_index.php?search=".$_GET['search']."&view=plist&id=".$_GET['id']."'><input type='button' name='cancel' value='Close' style='width:100px;border:1px solid gray;border-radius:3px;height:40px;font-size:16px;font-weight:bold'></a>"; }?> </form> </td> </tr> </table></center> </div>

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