File manager - Edit - /home/autoph/public_html/portal/includes/lab/laboratory_data_new.php
Back
<?php $compCode = $user_data['company_assignment']; $pID = $_GET['pID']; $fname=mysql_result(mysql_query("SELECT `patient_fname` FROM `patient_list` WHERE `patient_id`='$pID'"),0); $docID=mysql_result(mysql_query("SELECT `assigned_doctor` 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); $assignedDialyzerID=mysql_result(mysql_query("SELECT `dialyzer` FROM `patient_list` WHERE `patient_id`='$pID'"),0); $assignedDialyzer = mysql_result(mysql_query("SELECT `medicine_desc` FROM `medicines` WHERE `medicine_id`='$assignedDialyzerID'"),0); $assignedEPO=mysql_result(mysql_query("SELECT `epo` FROM `patient_list` WHERE `patient_id`='$pID'"),0); $myEpoID = mysql_result(mysql_query("SELECT `epo` FROM `patient_list` WHERE `patient_id`='$pID'"),0); $myEpoName=mysql_result(mysql_query("SELECT `medicine_desc` FROM `medicines` WHERE `medicine_id`='$myEpoID'"),0); $txCount=mysql_result(mysql_query("SELECT `tx_frequency` FROM `patient_list` WHERE `patient_id`='$pID'"),0); $can_add_lab= $user_data['can_add_lab']; //echo "cOUNT".$txCount; ?> <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> <?php if(isset($_POST['SAVEEDITLAB'])){ echo "SAVING RECORD..."; $recID=$_POST['recID']; $BFR=$_POST['bfr']; $docID = $_POST['docID']; $Creatinine=$_POST['creatinine']; $bunPre=$_POST['bunPre']; $bunPost=$_POST['bunPost']; $URR=$_POST['URR']; $KTv=$_POST['KTv']; $Calcium=$_POST['Calcium']; $Albumin=$_POST['Albumin']; $Phosphorus=$_POST['Phosphorus']; $Potassium=$_POST['Potassium']; $hb=$_POST['hb']; $txCount=$_POST['freqHD']; $ironRoute=$_POST['ironRoute']; $ironDose=$_POST['ironDose']; $Sevelamer=$_POST['Sevelamer']; $dialyzerUsage=$_POST['dialyzerUsage']; $recESADose =$_POST['recESADose']; $actualESAUsed=$_POST['actualESAUsed']; $notes=$_POST['notes']; $myEpoID=$_POST['myEpoID']; $assignedDialyzerID=$_POST['assignedDialyzerID']; $notes = mysql_real_escape_string($notes); mysql_query("UPDATE `laboratory_info` SET `bfr`='$BFR',`creatinine`='$Creatinine',`bun_pre`='$bunPre',`bun_post`='$bunPost',`urr`='$URR',`ktv`='$KTv',`calcium`='$Calcium',`potassium`='$Potassium',`albumin`='$Albumin',`phosphorus`='$Phosphorus',`hemoglobin`='$hb',`iron_route`='$ironRoute',`iron_dose`='$ironDose',`sevelamer_freq`='$Sevelamer',`remarks`='$notes',`dialyzer_usage`='$dialyzerUsage',`reco_epo`='$recESADose',`actual_epo`='$actualESAUsed',`tx_count`='$txCount' WHERE `lab_id`='$recID'"); //NOTIFICATION echo "<div id='dragme' style='position:absolute;top:200px;left:250px;height:120px;width:300px;border:1px solid lightgray; border-radius:5px;background:white;z-index:1000'> <table style='background:white;height:100%;width:100%'> <tr> <td align='center' width='500px'> <br> <font size = '12px' color='red'> Update has been saved. Thank you!</font> <br> <br> <a href='main_new.php?view=700&sview=1024&sid=M1&action=lab&search=&view=plist&pID=".$_GET['pID']."&tab=0#id-0'><input style='background-color:#E5E4E2;border:1px black solid;border-radius:1px;width:120px;height:20px;color:black;font-size:12px;font-weight:normal;'type ='button' name ='closex' value = 'Close'> </a> <br><br> </td> </tr> </table></div>"; } if(isset($_POST['AddLab'])){ $pID=$_POST['pID']; $BFR=$_POST['bfr']; $docID = $_POST['docID']; $Creatinine=$_POST['creatinine']; $bunPre=$_POST['bunPre']; $bunPost=$_POST['bunPost']; $URR=$_POST['URR']; $KTv=$_POST['KTv']; $Calcium=$_POST['Calcium']; $Albumin=$_POST['Albumin']; $Phosphorus=$_POST['Phosphorus']; $Potassium=$_POST['Potassium']; $hb=$_POST['hb']; $txCount=$_POST['freqHD']; $ironRoute=$_POST['ironRoute']; $ironDose=$_POST['ironDose']; $Sevelamer=$_POST['Sevelamer']; $dialyzerUsage=$_POST['dialyzerUsage']; $recESADose =$_POST['recESADose']; $actualESAUsed=$_POST['actualESAUsed']; $notes=$_POST['notes']; $myEpoID=$_POST['myEpoID']; $assignedDialyzerID=$_POST['assignedDialyzerID']; $notes = mysql_real_escape_string($notes); $sql="INSERT INTO `laboratory_info` (`lab_id`,`pID`,`branch_id`,`lab_date`,`lab_time`,`encoded_by`,`lab_center_id`,`bfr`,`creatinine`,`bun_pre`, `bun_post`,`urr`,`ktv`,`calcium`,`potassium`,`albumin`,`phosphorus`,`hemoglobin`,`iron_route`,`iron_dose`,`sevelamer_freq`,`remarks`,`dialyzer_usage`,`reco_epo`,`actual_epo`,`tx_count`,`issued_dialyzer`,`issued_epo`,`doc_id`,`year`) VALUES('','$pID','$compCode','$toDate','$currentTime','$u_id','','$BFR','$Creatinine','$bunPre','$bunPost','$URR','$KTv','$Calcium','$Potassium','$Albumin','$Phosphorus','$hb','$ironRoute','$ironDose','$Sevelamer','$notes','$dialyzerUsage','$recESADose','$actualESAUsed','$txCount','$assignedDialyzerID','$myEpoID','$docID','$mycYear')"; 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;z-index:10'>"; echo "<h3>UPDATE COMPLETE</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>"; } } if(isset($_GET['addlab'])){ ?> <div STYLE='height:435px; width: 80%%; position:absolute;top:100px;left:100px;font-size: 12px; overflow: auto;border-radius:5px;border:3px solid #2E9AFE;background:#f4f4f4; z-index:10'> <div style='position:relative'> <table style='width:100%;border-collapse:collapse'> <tr> <td align='left' style='width:97%'><h3 style='font-size:18px;font-weight:normal;height:25px;border-bottom:1px solid #0080FF;padding-left:10px;background:#58D3F7'><?php if(isset($_GET['sum'])){echo "General Information";}else{echo "LABORATORY RESULT ENTRY - ";}?><?php echo "<b style='font-size:18px'>" . $_GET['search'] ."</b>";?> </h3></td> <td align='center' style='width:3%;background:#58D3F7'> <a href='main_new.php?view=100&sview=1024&sid=M1&action=plist&tab=0#id-0'><input type='button' name='close' value='X' style='width:25px;font-size:16;font-weight:bold;height:25px'></a></td> </tr> </table> </div> <form action='' method='POST'> <center> <input type='hidden' name='pID' value='<?php echo $_GET['pID'];?>'> <input type='hidden' name='docID' value='<?php echo $docID;?>'> <input type='hidden' name='assignedDialyzerID' value='<?php echo $assignedDialyzerID;?>'> <input type='hidden' name='myEpoID' value='<?php echo $myEpoID;?>'> <br><table style='background:white;width:98%;border-collapse:collapse;bordre:none'> <tr> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>BFR</td> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Creatinine</td> <td align='center' colspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;font-weight:bold;border-right:1px solid gray'>BUN</td> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>URR</td> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Kt/V</td> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Calcium (Ca)</td> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Potassium(K)</td> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Albumin</td> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Phosphorus</td> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>HB</td> <td align='center' colspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;font-weight:bold;border-right:1px solid gray'>IRON</td> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;font-weight:bold;border-right:1px solid gray'>Sevelamer Freq.</td> </tr> <tr> <td align='center' style='background:lightgray;width:40px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Pre</td> <td align='center' style='background:lightgray;width:40px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Post</td> <td align='center' style='background:lightgray;width:40px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Route</td> <td align='center' style='background:lightgray;width:40px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Dose</td> </tr> <tr style='height:50px'> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <input type='text' title='BFR' name='bfr' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <input type='text' title='Creatinine' name='creatinine' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;font-weight:bold;border-right:1px solid white'> <input type='text' title='BUN Post' name='bunPre' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <input type='text' title='BUN Pre' name='bunPost' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder='''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <input type='text' title='URR' name='URR' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <input type='text' title='Kt/V' name='KTv' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <input type='text' title='Calcium' name='Calcium' style='width:95%;height:28px; background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <input type='text' title='Potassium' name='Potassium' style='width:95%;height:28px; background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <input type='text' title='Albumin' name='Albumin' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <input type='text' title='Phosphorus' name='Phosphorus' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;font-weight:bold;border-right:1px solid white'> <input type='text' title='Hemoglobin' name='hb' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;font-weight:bold;border-right:1px solid white'> <select type='text' title='Iron Route' name='ironRoute' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''> <option>NONE</option> <option>PO</option> </select></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;font-weight:bold;border-right:1px solid white'> <select type='text' title='Iron Dose' name='ironDose' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''> <option>NONE</option> <option>OD</option> <option>TID</option> <option>BID</option> </select> </td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;font-weight:bold;border-right:1px solid white'> <select type='text' title='Sevelamer Frequency' name='Sevelamer' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''> <option>NONE</option> <option>OD</option> <option>TID</option> <option>BID</option> </select> </td> </tr> <tr> <td align='left' colspan='3' style='width:70px;font-size:12px;border:1px solid white;height:28px;border-right:1px solid white'>Assigned Dialyzer:</td> <td align='left' colspan='4' style='background:white;width:70px;font-size:12px;border:1px solid white;font-weight:normal;border-right:1px solid white'> <b style='font-size:12px;color:blue'><?php echo $assignedDialyzer;?></b> </td> <td align='left' valign='top' colspan='7' rowspan='5' style='font-size:13px;border:1px solid white;height:20px;border-right:1px solid white;background:white'> Remarks:<br><textarea rows='4' name='notes' title='Remarks/Commend Box' style='padding:5px;width:90%;;background:#fff;border-radius:3px' placeholder='Remarks Field'></textarea> </td> </tr> <tr> <td align='left' colspan='3' style='background:white;width:70px;font-size:12px;border:1px solid white;font-weight:normal;border-right:1px solid white'> Current Dialyzer Usage:<br> </td> <td align='left' colspan='4' style='background:white;width:70px;font-size:10px;border:1px solid white;font-weight:bold;border-right:1px solid white'> <select type='text' title='Dialyzer Utilization' name='dialyzerUsage' style='width:120px;height:28px;background:#fff;font-size:10px;color:black;font-weight:bold;text-align:center' required placeholder=''> <option></option> <option>1X</option> <option>2X</option> <option>3X</option> <option>4X</option> <option>5X</option> <option>6X</option> <option>7X</option> <option>8X</option> <option>9X</option> <option>10X</option> </select> </td> </tr> <tr> <td align='left' colspan='3' style='width:70px;font-size:12px;border:1px solid white;height:20px;border-right:1px solid white'>Assigned EPO:</td> <td align='left' colspan='4' style='background:white;width:70px;font-size:12px;border:1px solid white;font-weight:normal;border-right:1px solid white'> <b style='font-size:12px;color:blue'><?php echo $myEpoName;?></b> </td> </tr> <tr> <td align='left' colspan='3' style='background:white;width:70px;font-size:12px;border:1px solid white;font-weight:normal;border-right:1px solid white'> Recommended ESA Dose:<br> </td> <td align='left' colspan='4' style='background:white;width:70px;font-size:10px;border:1px solid white;font-weight:bold;border-right:1px solid white'> <input type='text' title='Recommended ESA Dose(per month)' name='recESADose' style='width:120px;height:28px; background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''> </td> </tr> <tr> <td align='left' colspan='3' style='background:white;width:70px;font-size:12px;border:1px solid white;font-weight:normal;border-right:1px solid white'> Total Units Given for the Month:<br> </td> <td align='left' colspan='4' style='background:white;width:70px;font-size:10px;border:1px solid white;font-weight:bold;border-right:1px solid white'> <input type='text' title='Total Units Given for the Month (per month)' name='actualESAUsed' style='width:120px;height:28px ;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''> </td> </tr> <tr> <td align='left' colspan='3' style='background:white;width:70px;font-size:12px;border:1px solid white;font-weight:normal;border-right:1px solid white'> Frequency of HD / Week:<br> </td> <td align='left' colspan='4' style='background:white;width:70px;font-size:10px;border:1px solid white;font-weight:bold;border-right:1px solid white'> <select type='text' title='Frequency of HD' name='freqHD' style='width:120px;height:28px;background:#fff;font-size:10px;color:black;font-weight:bold;text-align:center' required placeholder=''> <option><?php echo $txCount; ?></option> <option>1X</option> <option>2X</option> <option>2X|3x</option> <option>3X</option> </select> </td> </tr> <tr style='background:white'> <td align='center' colspan='14' style='width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> </td> </tr> <tr style='background:white'> <td align='center' colspan='14' style='width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <br><input type='submit' name='AddLab' value='Add Entry' style='border-radius:3px;height:50px;width:100px'> <a href='main_new.php?view=100&sview=1024&sid=M1&action=lab&search=<?php echo $_GET['search'];?>&view=plist&pID=<?php echo $_GET['pID'];?>&tab=0#id-0'><input type='button' name='Cancel' value='Close' style='border-radius:3px;height:50px;width:100px'><br><br> </td> </tr> </table> </center> </form> </div> <?php } //main_new.php?view=700&sview=1024&sid=M1&action=lab&search=&view=plist&pID=370&tab=0#id-0 //main_new.php?view=700&sview=1024&sid=M1&action=lab&search=&view=plist&pID=370&editlab&tab=0#id-0 //main_new.php?view=100&sview=1024&sid=M1&action=lab&search=&view=plist&pID=370&addlab&tab=0#id-0 /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// if(isset($_GET['editlab'])){ $recordID = $_GET['recID']; $myBFR = mysql_result(mysql_query("SELECT `bfr` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myCREATININE = mysql_result(mysql_query("SELECT `creatinine` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myPREBUN = mysql_result(mysql_query("SELECT `bun_pre` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myPREPOST = mysql_result(mysql_query("SELECT `bun_post` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myURR = mysql_result(mysql_query("SELECT `urr` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myKTV = mysql_result(mysql_query("SELECT `ktv` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myCALCIUM = mysql_result(mysql_query("SELECT `calcium` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myPHOSPHORUS= mysql_result(mysql_query("SELECT `phosphorus` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myALBUMIN= mysql_result(mysql_query("SELECT `albumin` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myPOTASSIUM= mysql_result(mysql_query("SELECT `potassium` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myHEMOGLOBIN= mysql_result(mysql_query("SELECT `hemoglobin` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myIRONROUTE= mysql_result(mysql_query("SELECT `iron_route` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myIRONDOSE= mysql_result(mysql_query("SELECT `iron_dose` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $mySEVELAMERFREQ= mysql_result(mysql_query("SELECT `sevelamer_freq` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myREMARKS= mysql_result(mysql_query("SELECT `remarks` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myDIALYZERUSAGE= mysql_result(mysql_query("SELECT `dialyzer_usage` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myRECOEPO= mysql_result(mysql_query("SELECT `reco_epo` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myACTUALEPO= mysql_result(mysql_query("SELECT `actual_epo` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myTXCOUNT= mysql_result(mysql_query("SELECT `tx_count` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myDIALYZER= mysql_result(mysql_query("SELECT `issued_dialyzer` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myDIALYZERNAME = mysql_result(mysql_query("SELECT `medicine_desc` FROM `medicines` WHERE `medicine_id`='$myDIALYZER'"),0); $myEPO= mysql_result(mysql_query("SELECT `issued_epo` FROM `laboratory_info` WHERE `lab_id`='$recordID'"),0); $myEPONAME = mysql_result(mysql_query("SELECT `medicine_desc` FROM `medicines` WHERE `medicine_id`='$myEPO'"),0); ?> <div STYLE='height:435px; width: 80%%; position:absolute;top:100px;left:100px;font-size: 12px; overflow: auto;border-radius:5px;border:3px solid red;background:#FA8258; z-index:11'> <div style='position:relative'> <table style='width:100%;border-collapse:collapse'> <tr> <td align='left' style='width:97%'><h3 style='font-size:18px;font-weight:normal;height:25px;border-bottom:1px solid #0080FF;padding-left:10px;background:yellow'><?php if(isset($_GET['sum'])){echo "General Information";}else{echo "LABORATORY RESULT ENTRY - ";}?><?php echo "<b style='font-size:18px'>" . $_GET['search'] ."</b>";?> </h3></td> <td align='center' style='width:3%;background:#58D3F7'> <a href='main_new.php?view=700&sview=1024&sid=M1&action=lab&search=&view=plist&pID=<?php echo $_GET['pID'];?>&tab=0#id-0'><input type='button' name='close' value='X' style='width:25px;font-size:16;font-weight:bold;height:25px'></a></td> </tr> </table> </div> <form action='' method='POST'> <center> <input type='hidden' name='recID' value='<?php echo $_GET['recID'];?>'> <br><table style='background:white;width:98%;border-collapse:collapse;bordre:none'> <tr> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>BFR</td> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Creatinine</td> <td align='center' colspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;font-weight:bold;border-right:1px solid gray'>BUN</td> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>URR</td> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Kt/V</td> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Calcium (Ca)</td> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Potassium(K)</td> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Albumin</td> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Phosphorus</td> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>HB</td> <td align='center' colspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;font-weight:bold;border-right:1px solid gray'>IRON</td> <td align='center' rowspan='2' style='background:lightgray;width:70px;font-size:10px;border:none;font-weight:bold;border-right:1px solid gray'>Sevelamer Freq.</td> </tr> <tr> <td align='center' style='background:lightgray;width:40px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Pre</td> <td align='center' style='background:lightgray;width:40px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Post</td> <td align='center' style='background:lightgray;width:40px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Route</td> <td align='center' style='background:lightgray;width:40px;font-size:10px;border:none;height:20px;border-right:1px solid gray'>Dose</td> </tr> <tr style='height:50px'> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <input type='text' title='BFR' name='bfr' value='<?php echo $myBFR;?>' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <input type='text' title='Creatinine' name='creatinine' value='<?php echo $myCREATININE;?>' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;font-weight:bold;border-right:1px solid white'> <input type='text' title='BUN Post' name='bunPre' value='<?php echo $myPREBUN;?>' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <input type='text' title='BUN Pre' name='bunPost'value='<?php echo $myPREPOST;?>' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder='''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <input type='text' title='URR' name='URR' value='<?php echo $myURR;?>' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <input type='text' title='Kt/V' name='KTv' value='<?php echo $myKTV;?>' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <input type='text' title='Calcium' name='Calcium' value='<?php echo $myCALCIUM;?>' style='width:95%;height:28px; background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <input type='text' title='Potassium' name='Potassium' value='<?php echo $myPOTASSIUM;?>' style='width:95%;height:28px; background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <input type='text' title='Albumin' name='Albumin' value='<?php echo $myALBUMIN;?>' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <input type='text' title='Phosphorus' name='Phosphorus' value='<?php echo $myPHOSPHORUS;?>' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;font-weight:bold;border-right:1px solid white'> <input type='text' title='Hemoglobin' name='hb' value='<?php echo $myHEMOGLOBIN;?>' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;font-weight:bold;border-right:1px solid white'> <select type='text' title='Iron Route' name='ironRoute' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''> <option><?php echo $myIRONROUTE;?></option> <option>NONE</option> <option>PO</option> </select></td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;font-weight:bold;border-right:1px solid white'> <select type='text' title='Iron Dose' name='ironDose' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''> <option><?php echo $myIRONDOSE;?></option> <option>NONE</option> <option>OD</option> <option>TID</option> <option>BID</option> </select> </td> <td align='center' style='background:white;width:70px;font-size:10px;border:1px solid white;font-weight:bold;border-right:1px solid white'> <select type='text' title='Sevelamer Frequency' name='Sevelamer' style='width:95%;height:28px;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''> <option><?php echo $mySEVELAMERFREQ;?></option> <option>NONE</option> <option>OD</option> <option>TID</option> <option>BID</option> </select> </td> </tr> <tr> <td align='left' colspan='3' style='width:70px;font-size:12px;border:1px solid white;height:28px;border-right:1px solid white'>Assigned Dialyzer:</td> <td align='left' colspan='4' style='background:white;width:70px;font-size:12px;border:1px solid white;font-weight:normal;border-right:1px solid white'> <b style='font-size:12px;color:blue'><?php echo $myDIALYZERNAME;?></b> </td> <td align='left' valign='top' colspan='7' rowspan='5' style='font-size:13px;border:1px solid white;height:20px;border-right:1px solid white;background:white'> Remarks:<br><textarea rows='4' name='notes' title='Remarks/Commend Box' style='padding:5px;width:90%;;background:#fff;border-radius:3px' placeholder='Remarks Field'><?php echo $myREMARKS;?></textarea> </td> </tr> <tr> <td align='left' colspan='3' style='background:white;width:70px;font-size:12px;border:1px solid white;font-weight:normal;border-right:1px solid white'> Current Dialyzer Usage:<br> </td> <td align='left' colspan='4' style='background:white;width:70px;font-size:10px;border:1px solid white;font-weight:bold;border-right:1px solid white'> <select type='text' title='Dialyzer Utilization' name='dialyzerUsage' style='width:120px;height:28px;background:#fff;font-size:10px;color:black;font-weight:bold;text-align:center' required placeholder=''> <option><?php echo $myDIALYZERUSAGE;?></option> <option>1X</option> <option>2X</option> <option>3X</option> <option>4X</option> <option>5X</option> <option>6X</option> <option>7X</option> <option>8X</option> <option>9X</option> <option>10X</option> </select> </td> </tr> <tr> <td align='left' colspan='3' style='width:70px;font-size:12px;border:1px solid white;height:20px;border-right:1px solid white'>Assigned EPO:</td> <td align='left' colspan='4' style='background:white;width:70px;font-size:12px;border:1px solid white;font-weight:normal;border-right:1px solid white'> <b style='font-size:12px;color:blue'><?php echo $myEPONAME;?></b> </td> </tr> <tr> <td align='left' colspan='3' style='background:white;width:70px;font-size:12px;border:1px solid white;font-weight:normal;border-right:1px solid white'> Recommended ESA Dose:<br> </td> <td align='left' colspan='4' style='background:white;width:70px;font-size:10px;border:1px solid white;font-weight:bold;border-right:1px solid white'> <input type='text' title='Recommended ESA Dose(per month)' name='recESADose' value='<?php echo $myRECOEPO;?>' style='width:120px;height:28px; background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''> </td> </tr> <tr> <td align='left' colspan='3' style='background:white;width:70px;font-size:12px;border:1px solid white;font-weight:normal;border-right:1px solid white'> Total Units Given for the Month:<br> </td> <td align='left' colspan='4' style='background:white;width:70px;font-size:10px;border:1px solid white;font-weight:bold;border-right:1px solid white'> <input type='text' title='Total Units Given for the Month (per month)' name='actualESAUsed' value='<?php echo $myACTUALEPO;?>'style='width:120px;height:28px ;background:#fff;font-size:12px;color:black;font-weight:bold;text-align:center' required placeholder=''> </td> </tr> <tr> <td align='left' colspan='3' style='background:white;width:70px;font-size:12px;border:1px solid white;font-weight:normal;border-right:1px solid white'> Frequency of HD / Week:<br> </td> <td align='left' colspan='4' style='background:white;width:70px;font-size:10px;border:1px solid white;font-weight:bold;border-right:1px solid white'> <select type='text' title='Frequency of HD' name='freqHD' style='width:120px;height:28px;background:#fff;font-size:10px;color:black;font-weight:bold;text-align:center' required placeholder=''> <option><?php echo $myTXCOUNT; ?></option> <option>1X</option> <option>2X</option> <option>2X|3x</option> <option>3X</option> </select> </td> </tr> <tr style='background:white'> <td align='center' colspan='14' style='width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> </td> </tr> <tr style='background:white'> <td align='center' colspan='14' style='width:70px;font-size:10px;border:1px solid white;height:20px;border-right:1px solid white'> <br><input type='submit' name='SAVEEDITLAB' value='UPDATE' style='font-size:14px;border-radius:3px;height:50px;width:120px'> <a href='main_new.php?view=700&sview=1024&sid=M1&action=lab&search=&view=plist&pID=<?php echo $_GET['pID'];?>&tab=0#id-0'><input type='button' name='Cancel' value='EXIT' style='font-size:14px;border-radius:3px;height:50px;width:100px'><br><br> </td> </tr> </table> </center> </form> </div> <?php } /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// if($can_add_lab!=1){ $disablebutton='Disabled'; }else { $disablebutton='Enabled'; } ?> <div id='dragme' STYLE='background:white;position:absolute;top:80px;left:100px;height:500px; width: 1000px; font-size: 12px;border:1px solid gray;border-radius:0px'> <div style='position:relative'> <table style='width:100%;border-collapse:collapse'> <tr> <td colspan='2' class="lightGradient" style="border:1px solid lightgray;height:28px;font-size:14px;font-weight:normal;color:gray;border-right:1px solid #f2f2f2"> <img src="images/bullet.gif" width="10px" height="10px"> </img> <b style="font-size:14px;color:red"> <?php if(($_GET['subView'])==='home'){echo "DASHBOARD";}else{echo "LABORATORY DATA - ";}?><?php echo "<b style='font-size:18px'>" . $lname.", ". $fname ."</b>";?> </b> </td> <td align='center' class="lightGradient" style='width:3%;background:#F2F2F2;border:1px solid lightgray'> <a href='main_new.php?view=100&sview=1024&sid=M1&action=plist&tab=0#id-0'> <input type='button' name='close' value='X' style='width:25px;font-size:16;font-weight:bold;height:25px'></a> </td> </tr> </table> </div> <center> <div STYLE='background:white;position:relative;top:0px;left:0px;height:470px; width: 999px; font-size: 12px; overflow: auto;border:1px solid gray;border-radius:0px;z-index:9'> <table style='height:100%;width:100%;border:0px solid gray;border-collapse:collapse'> <tr> <td colspan='2' valign='top' style='background:white;padding-left:10px;border:1px solid white;border-right:1px solid white;width;100%;font-size:14px;'> <a href='main_new.php?view=100&sview=1024&sid=M1&action=lab&search=&view=plist&pID=<?php echo $_GET['pID'];?>&addlab&tab=0#id-0'> <input type='button' name='addnew' value='Add New' style='font-size:14px; font-weight:bold;height:25px;width:80px;border-radius:3px' <?php echo $disablebutton;?>></a> </td> </tr> <tr style='background:white'> <td colspan='2' valign='top' style='height:75%;width;100%;border:1px solid white'> <div STYLE='overflow:auto;height:435px; width: 150%; font-size: 12px; overflow: auto;border:1px solid white'> <table style='width:100%;border-collapse:collapse'> <?php $id =$_GET['id']; //echo "My Company Code:". $compCode; $qq=mysql_query("SELECT * FROM `laboratory_info` WHERE `branch_id`='$compCode' AND `pID`='$pID'"); echo "<tr style='background:white'> <th class='Gradient' align='center' style='text-align:center;width:20px;background:lightgray;border:1px solid gray;font-size:10px'>-</th> <th class='Gradient' style='text-align:center;width:40px;background:white;border:1px solid gray;font-size:11px;height:25px'>NO</th> <th class='Gradient' style='text-align:center;width:40px;background:white;border:1px solid gray;font-size:11px;height:25px'>DATE</th> <th class='Gradient' align='left' style='width:40px;background:white;border:1px solid gray;font-size:11px'>TIME</th> <th class='Gradient' align='center' style='text-align:center;width:40px;background:white;border:1px solid gray;font-size:11px'>BFR</th> <th class='Gradient' align='center' style='text-align:center;width:40px;background:white;border:1px solid gray;font-size:11px'>CREATININE</th> <th class='Gradient' align='center' style='text-align:center;width:50px;background:white;border:1px solid gray;font-size:10px'>BUN(Pre)</th> <th class='Gradient' align='center' style='text-align:center;width:50px;background:white;border:1px solid gray;font-size:10px'>BUN(Post)</th> <th class='Gradient' align='center' style='text-align:center;width:50px;background:white;border:1px solid gray;font-size:10px'>URR</th> <th class='Gradient' align='center' style='text-align:center;width:50px;background:white;border:1px solid gray;font-size:10px'>KT/V</th> <th class='Gradient' align='center' style='text-align:center;width:50px;background:white;border:1px solid gray;font-size:10px'>CALCIUM</th> <th class='Gradient' align='center' style='text-align:center;width:50px;background:white;border:1px solid gray;font-size:10px'>POTASSIUM</th> <th class='Gradient' align='center' style='text-align:center;width:50px;background:white;border:1px solid gray;font-size:10px'>PHOSPHORUS</th> <th class='Gradient' align='center' style='text-align:center;width:50px;background:white;border:1px solid gray;font-size:10px'>HEMOGLOBIN</th> <th class='Gradient' align='center' style='text-align:center;width:50px;background:white;border:1px solid gray;font-size:10px'>IRON(Route)</th> <th class='Gradient' align='center' style='text-align:center;width:50px;background:white;border:1px solid gray;font-size:10px'>IRON(Dose)</th> <th class='Gradient' align='center' style='text-align:center;width:50px;background:white;border:1px solid gray;font-size:10px'>ALBUMIN</th> <th class='Gradient' align='center' style='text-align:center;width:50px;background:white;border:1px solid gray;font-size:10px'>SEVELAMER</th> <th class='Gradient' align='center' style='text-align:center;width:50px;background:white;border:1px solid gray;font-size:10px'>REC.ESA</th> <th class='Gradient' align='center' style='text-align:center;width:50px;background:white;border:1px solid gray;font-size:10px'>ACTUAL</th> </tr>"; while($row = mysql_fetch_array($qq)){ echo "<tr>"; $count=$count + 1; echo "<td align='center' style='font-size10px;background:#CEE3F6'> <a href='main_new.php?recID=".$row['lab_id']."&view=700&sview=1024&sid=M1&action=lab&search=&view=plist&pID=".$row['pid']."&editlab&tab=0#id-0' style='font-size:11px;color:red;font-weight:normal'>Edit</a></td>"; echo "<td align='center' style='font-size:10px'>".$count."</td>"; echo "<td align='center' style='font-size:10px'>".$row['lab_date']."</td>"; echo "<td align='center' style='font-size:10px'>".$row['lab_time']."</td>"; echo "<td align='center' style='font-size:10px'>".$row['bfr']."</td>"; echo "<td align='center' style='font-size:10px'>".$row['creatinine']."</td>"; echo "<td align='center' style='font-size:10px'>".$row['bun_pre']."</td>"; echo "<td align='center' style='font-size:10px'>".$row['bun_post']."</td>"; echo "<td align='center' style='font-size:10px'>".$row['urr']."</td>"; echo "<td align='center' style='font-size:10px'>".$row['ktv']."</td>"; echo "<td align='center' style='font-size:10px'>".$row['calcium']."</td>"; echo "<td align='center' style='font-size:10px'>".$row['potassium']."</td>"; echo "<td align='center' style='font-size:10px'>".$row['phosphorus']."</td>"; echo "<td align='center' style='font-size:10px'>".$row['hemoglobin']."</td>"; echo "<td align='center' style='font-size:10px'>".$row['iron_route']."</td>"; echo "<td align='center' style='font-size:10px'>".$row['iron_dose']."</td>"; echo "<td align='center' style='font-size:10px'>".$row['albumin']."</td>"; echo "<td align='center' style='font-size:10px'>".$row['sevelamer_freq']."</td>"; echo "<td align='center' style='font-size:10px'>".$row['reco_epo']."</td>"; echo "<td align='center' style='font-size:10px'>".$row['actual_epo']."</td>"; } ?> </table> </div> </td> </tr> </table> </div> </center> </div>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0.04 |
proxy
|
phpinfo
|
Settings