<?php
include("header.php");
include("dbconnection.php");
if(isset($_POST[submit]))
{
	if(isset($_GET[editid]))
	{
		$sql ="UPDATE prescription SET treatment_records_id='$_POST[treatmentid]',doctorid='$_POST[select2]',patientid='$_POST[patientid]',prescriptiondate='$_POST[date]',status='$_POST[select]' WHERE prescription_id='$_GET[editid]'";
		if($qsql = mysqli_query($con,$sql))
		{
			echo "<script>alert('prescription record updated successfully...');</script>";
		}
		else
		{
			echo mysqli_error($con);
		}	
	}
	else
	{
		$sql ="INSERT INTO pgbasic(doctorid,patientid,patientname,gender,Age,Address,mobileno,doctorname,AdmissionDate,DischargeDate) values('$_POST[select2]','$_POST[patientid]','$_POST[patientname]','$_POST[gender]','$_POST[Age]','$_POST[Address]','$_POST[mobileno]','$_POST[doctorname]','$_POST[AdmissionDate]','$_POST[DischargeDate]')";
		if($qsql = mysqli_query($con,$sql))
		{
			$insid= mysqli_insert_id($con);
			$prescriptionid= $insid;
			$prescriptiondate= $_POST[date];
			$billtype="Prescription charge";
			$billamt=0;
			include("insertbillingrecord.php");	
			echo "<script>alert(' record inserted successfully...');</script>";
			echo "<script>window.location='Diagnosis.php?prescriptionid=" . $insid . "&patientid=$_GET[patientid]&appid=$_GET[appid]';</script>";
			
		}
		else
		{
			echo mysqli_error($con);
		}
	}
}
if(isset($_GET[editid]))
{
	$sql="SELECT * FROM prescription WHERE prescriptionid='$_GET[editid]' ";
	$qsql = mysqli_query($con,$sql);
	$rsedit = mysqli_fetch_array($qsql);
	
}
?>
<?php
	include("menu.php");
	?>
	<style>
    form{
        margin: 20px 0;
    }
    form input, button{
        padding: 5px;
    }
    table{
        width: 100%;
        margin-bottom: 20px;
		border-collapse: collapse;
    }
    table, th, td{
        border: 1px solid #cdcdcd;
    }
    table th, table td{
        padding: 10px;
        text-align: left;
    }
	<style>
           
			table{
    border: solid 1px gray;
    width: 100%;
  }
  input{ width: 100%;}
        </style>
</style>
<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
	

     <h1>Basic Info</h1>
      <form method="post" name="frmpres" onSubmit="return validateform()">
     <input type="hidden" name="patientid" value="<?php echo $_GET[patientid]; ?>"  />
     <input type="hidden" name="treatmentid" value="<?php echo $_GET[treatmentid]; ?>"  />
     <input type="hidden" name="appid" value="<?php echo $_GET[appid]; ?>"  />
    <table class="center" border="1"> 
      <tbody>
      

            <?php
		  	$sqlpatient= "SELECT * FROM patient WHERE status='Active' AND patientid='$_GET[patientid]'";
			$qsqlpatient = mysqli_query($con,$sqlpatient);
			while($rspatient=mysqli_fetch_array($qsqlpatient))
			{
                echo "<tr><td>U.H.I.D NO</td><td><input type='text'  name='patientid' id='patientid' value='$rspatient[patientid]'></td></tr>
                <tr><td>Patient’s Name</td><td><input type='text'  name='patientname' id='patientname' value='$rspatient[patientname]'></td></tr>
                <tr><td>Sex </td><td><input type='text'  name='gender' id='gender' value='$rspatient[gender]'></td></tr>
                <tr><td>Age </td><td><input type='text'  name='Age' id='Age' value='$rspatient[Age]'></td></tr>
                <tr><td>Address </td><td><input type='text'  name='Age' id='Age' value='$rspatient[Country],$rspatient[State],$rspatient[city],$rspatient[pincode]'></td></tr>
                <tr><td>Tel . No</td><td><input type='text'  name='mobileno' id='mobileno' value='$rspatient[mobileno]'></td></tr>
                ";
			}
		  ?>
        
  <?php
		if(isset($_SESSION[adminid]))
		{
		?>
        <tr>
          <td>Healthcare Provider</td>
		  <?php
				$sqldoctor= "SELECT * FROM doctor INNER JOIN department ON department.departmentid=doctor.departmentid WHERE doctor.status='Active' AND doctor.doctorid='$_SESSION[doctorid]'";
				$qsqldoctor = mysqli_query($con,$sqldoctor);
				while($rsdoctor = mysqli_fetch_array($qsqldoctor))
				{
					echo "<input type='text' name='doctorname' id='doctorname' value='$rsdoctor[doctorname],( $rsdoctor[departmentname]'> )";
				}
				?>
                <input type="hidden" name="select2" value="<?php echo $_SESSION[doctorid]; ?>"  />
          </td>
        <?php
		}
		else
		{
		?>        
        <tr>
          <td width="34%">Hospital Name  </td>
          <td width="66%"><select name="select2" id="select2">
          <option value="">Select</option>
            <?php
          	$sqldoctor= "SELECT * FROM doctor WHERE status='Active'";
			$qsqldoctor = mysqli_query($con,$sqldoctor);
			while($rsdoctor = mysqli_fetch_array($qsqldoctor))
			{
				if($rsdoctor[doctorid] == $rsedit[doctorid])
				{
				echo "<option value='$rsdoctor[doctorid]' selected>$rsdoctor[doctorid]-$rsdoctor[doctorname]</option>";
				}
				else
				{
				echo "<option value='$rsdoctor[doctorid]'>$rsdoctor[doctorid]-$rsdoctor[doctorname]</option>";				
				}
			}
		  ?>
          </select></td>
        </tr>
          </select></td>
        </tr>
        <?php
		}
		?>
		 <tr>
          <td>Admission Date </td>
          <td><input type="date" name="AdmissionDate" id="AdmissionDate" value="<?php echo $rsedit[AdmissionDate]; ?>" /></td>
        </tr>
		<tr>
        <tr>
          <td>Discharge Date</td>
          <td><input type="date" name="DischargeDate" id="DischargeDate" value="<?php echo $rsedit[DischargeDate]; ?>" /></td>
        </tr>
       
        <tr>
          <td colspan="2" align="center"><input onClick="redirect()" type="submit" name="submit" id="submit" value="Save & Next" /></td>
        </tr>
      </tbody>
    </table>
    <p>&nbsp;</p>
</div>
 <div class="clear"></div>
  </div>
</div>
<?php
include("footer.php");
?>
<script type="application/javascript">
function validateform()
{
	if(document.frmpres.select2.value == "")
	{
		alert("Doctor name should not be empty..");
		document.frmpres.select2.focus();
		return false;
	}
	
	else if(document.frmpres.select3.value == "")
	{
		alert("Patient name should not be empty..");
		document.frmpres.select3.focus();
		return false;
	}
	else if(document.frmpres.date.value == "")
	{
		alert("Prescription date should not be empty..");
		document.frmpres.date.focus();
		return false;
	}
	else if(document.frmpres.select.value == "" )
	{
		alert("Kindly select the status..");
		document.frmpres.select.focus();
		return false;
	}
	else
	{
		return true;
	}
}
</script>