File manager

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

Back
<?php $compCode = $user_data['company_assignment']; $user = $user_data['u_name']; $pID = $_GET['pID']; $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); $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['submit'])){ $regCity = $_POST['regCity']; $pID = $_POST['pID']; $xDate = $_POST['expiredDate']; $notes = $_POST['notes']; $notes = mysql_real_escape_string($notes); mysql_query("UPDATE `pindex_hdr` SET `index_hdr_status`='Transferred' WHERE `index_patient_id`='$pID' AND `branch_code`='$compCode'"); mysql_query("UPDATE `patient_list` SET `nephro_status`='Transferred',`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:500px;height:220px;left:260px;top:200px;border:2px solid red;border-radius:5px;background:#FFF'>"; echo "<h3>CHANGE PATIENT STATUS:</h3>"; echo "<br><br><b style='font-size:18px;font-weight:bold'><center>Update Complete</b>"; echo "<br><br><a href='main_new.php?view=100&sview=1024&sid=M1&action=plist&tab=0#id-0'><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> <div id='dragme' STYLE='background:white;height:435px; width:800px;position:absolute; font-size: 12px; overflow: auto;border:1px solid black;z-index:99999'> <?php echo "<h3 style='padding-left:5px;padding-top:2px'>UPDATE TRANSFERREd PATIENT</h3>"; echo "<div style='top:2px;left:97.5%;position:absolute;z-index:3'> <a href='main_new.php?view=100&sview=".$_GET['sview']."&sid=".$_GET['sid']."&action=&tab=0#id-0' style='display:block;width:17px;height:17px;border:1px solid gray;background:lightgray;border-radius:2px'> <center>X</center> </a> </div>";?> <center><table style ="width:100%;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> <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> <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'>Transferred 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' 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> Transferred Location: <select name="regCity" 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 DISTINCT(`reg_city`) 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" 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' 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' 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 echo "Please confirm status of <b style='font-size:14px;color:red;'>".$lname. "," .$fname. "</b> from Active to Transferred. <br> <i style='font-size:12px'>If you continue, patient will consider as inactive..." ;?> <br><br> </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 !='Active'){ echo "<input type='submit' name='submit' title='Patient is no longer active: Current Status: ".$patientStatus."' value='Update' style='width:100px;border:1px solid gray;border-radius:3px;height:40px;font-size:12px;font-weight:normal' disabled class='lightGradient'>"; echo " <a href='main_new.php?view=100&sview=1024&sid=M1&action=&tab=0#id-0'><input type='button' name='cancel' value='Close' style='width:100px;border:1px solid gray;border-radius:3px;height:40px;font-size:12px;font-weight:normal' class='lightGradient'></a>"; }else{ echo " <input type='submit' name='submit' value='Update' style='width:100px;border:1px solid gray;border-radius:3px;height:40px;font-size:12px;font-weight:normal' class='lightGradient'>"; echo " <a href='main_new.php?view=100&sview=1024&sid=M1&action=&tab=0#id-0'><input type='button' name='cancel' value='Close' style='width:100px;border:1px solid gray;border-radius:3px;height:40px;font-size:12px;font-weight:normal' class='lightGradient'></a>"; }?> </form> </td> </tr> </table></center> </div>

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