File manager

File manager - Edit - /home/autoph/public_html/portal/includes/lab/update_dial.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); $myDialyzer=mysql_result(mysql_query("SELECT `dialyzer` FROM `patient_list` WHERE `patient_id`='$pid'"),0); $dialyzerDesc = mysql_result(mysql_query("SELECT `medicine_desc` FROM `medicines` WHERE `medicine_id`='$myDialyzer'"),0); $patientStatus=mysql_result(mysql_query("SELECT `nephro_status` FROM `patient_list` WHERE `patient_id`='$pid'"),0); if(isset($_POST['submit'])){ $pID = $_POST['pID']; $docTor = $_POST['assignedDialyzer']; $extractDoc = explode("---",$docTor); $medID = $extractDoc[1]; $notes = $_POST['notes']; $notes = mysql_real_escape_string($notes); mysql_query("UPDATE `patient_list` SET `dialyzer`='$medID' WHERE `patient_id`='$pID' AND `branch_code`='$compCode'"); //mysql_query("UPDATE `pindex_hdr` SET `patient_status`='Expired' WHERE `index_patient_id`='$pID' AND `branch_code`='$compCode'"); 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>RECORD SAVED:</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=dial'><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'> UPDATE DIALYZER </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;?></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'>Current Assigned Dialyzer:</td> <td valign="TOP" align="left" style='width:80%;background:white;border:1px solid white;font-size:12px;font-weight:bold'><?php echo $dialyzerDesc;?></td> </tr> <tr> <td valign="TOP" align="right" style='width:20%;background:white;border:1px solid white;font-size:12px;font-weight:normal'>Assigned Dialyzer:</td> <td valign="TOP" align="left" style='width:80%;background:white;border:1px solid white;font-size:12px;font-weight:normal'> <select name="assignedDialyzer" style="width:65%;font-size:12px;color:blue;border;1px solid lightgry;border:1px solid lightgray;background:white"> <option><?php echo $dialyzerDesc;?>---<?php echo $myDialyzer;?></option> <?php $getdoctor = mysql_query("SELECT * FROM `medicines` WHERE `type`= 'dialyzer'"); while($myMT = mysql_fetch_array($getdoctor)){ ?> <option id = "<?php echo $myMT['medicine_id'];?>" style="font-size:12px;color:gray;"> <?php echo $myMT['medicine_desc'];?>---<?php echo $myMT['medicine_id'];?></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'>Remarks:</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:90%;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 "You are about to replace existing assigned dialyzer of <b style='font-size:14px;color:red;'>".$lname. "," .$fname. "</b> <br> <i style='font-size:12px'>If you continue, you cannot process other dialyzer to patient other than the selected item. " ;?> <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:16px;font-weight:bold' disabled>"; 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>"; }else{ echo "<input type='submit' name='submit' value='Update' 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