"; echo "

PROFILE DEACTIVATED:

"; echo "

Update Complete"; echo "

"; echo "
"; } } 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 "
"; echo "

PROFILE ACTIVATED:

"; echo "

Update Complete"; echo "

"; echo "
"; } } ?>

TRANSIENT PATIENT

Name of Patient:
Status: ( ".$newLocation." )";?>
Date Expired:
Date Admitted:
Home Address:
Date: type="text" name="expiredDate" value ="" 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:
style='width:20%;background:white;border:1px solid white;font-size:12px;font-weight:normal'>Name of Center: style="font-size:14px;font-weight:normal;color:blue;width:100%;height:20px;border:1px solid lightgray;text-align:left;background:white" placeholder="Optional">
Reasons:

Patient Already ".$patientStatus."

" ; }else{ echo "Please confirm status of ".$lname. "," .$fname. ".
If you continue, patient will consider as inactive..." ; }?>

"; echo ""; } if($patientStatus ==='Active'){ echo ""; echo ""; }?>