File manager

File manager - Edit - /home/autoph/public_html/portal/includes/lab/update_doctor_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); $myDoctor=mysql_result(mysql_query("SELECT `assigned_doctor` FROM `patient_list` WHERE `patient_id`='$pID'"),0); $myDoctorsLName = mysql_result(mysql_query("SELECT `doc_lname` FROM `doctors_profile` WHERE `doc_id`='$myDoctor'"),0); $myDoctorsFName = mysql_result(mysql_query("SELECT `doc_Fname` FROM `doctors_profile` WHERE `doc_id`='$myDoctor'"),0); $myDoctorsSal = mysql_result(mysql_query("SELECT `suffix` FROM `doctors_profile` WHERE `doc_id`='$myDoctor'"),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['assigneddoctor']; $extractDoc = explode("---",$docTor); $docID = $extractDoc[1]; $notes = $_POST['notes']; $notes = mysql_real_escape_string($notes); mysql_query("UPDATE `patient_list` SET `assigned_doctor`='$docID' 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;z-index:10'>"; echo "<h3>DOCTOR ASSIGNMENT SAVE:</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&search=".$_GET['search']."&view=plist&pID=".$_GET['pID']."&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:9'> <?php echo "<h3 style='padding-left:5px;padding-top:2px'>UPDATE DOCTOR</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;?></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 Doctor:</td> <td valign="TOP" align="left" style='width:80%;background:white;border:1px solid white;font-size:12px;font-weight:bold'><?php echo $myDoctorSal ." ". $myDoctorsLName. ", ". $myDoctorsFName;?></td> </tr> <tr> <td valign="TOP" align="right" style='width:20%;background:white;border:1px solid white;font-size:12px;font-weight:normal'>Select Doctor:</td> <td valign="TOP" align="left" style='width:80%;background:white;border:1px solid white;font-size:12px;font-weight:normal'> <select name="assigneddoctor" style="width:65%;font-size:12px;color:blue;border;1px solid lightgry;border:1px solid lightgray;background:white"> <option><?php echo $ldoctor;?> <?php echo $fdoctor;?>---<?php echo $docid;?></option> <?php $getdoctor = mysql_query("SELECT * FROM `doctors_profile` WHERE `doc_status`= '1'"); while($myMT = mysql_fetch_array($getdoctor)){ ?> <option id = "<?php echo $myMT['doc_id'];?>" style="font-size:12px;color:gray;"> <?php echo $myMT['doc_lname'];?>, <?php echo $myMT['doc_fname'];?>---<?php echo $myMT['doc_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 doctor of <b style='font-size:14px;color:red;'>".$lname. "," .$fname. "</b> <br> <i style='font-size:12px'>If you continue, all transactions moving forward will be credited to new doctor. " ;?> <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&search=".$_GET['search']."&view=plist&pID=".$_GET['pID']."&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&search=".$_GET['search']."&view=plist&pID=".$_GET['pID']."&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