<?php  
 session_start();
      //export.php  
    session_start();
   	include_once("../dbconnection.php"); 
   	require_once('../DBManager.php');
require_once('../LoginManager.php');
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
      header('Content-Type: text/csv; charset=utf-8');  
      header('Content-Disposition: attachment; filename=data.csv');  
      $output = fopen("php://output", "w");  
fputcsv($output, array('Srno','UHID','Familyid/Hospitalid','Family Mo.no','Profile Pic Link','Create for','Name','Gender','Co Name','Emailid','Mo.no','Age','Weight','Height','Blood Group','Nationality','Marital Status','Religion','Occupation','Family Income','Education Qualification','Passport No','Aadhar No','Referred To','Country','State','City','Pincode','Block Name','Insurance Name','Policy Name','','Status','','Enteredby','Createdat','Updatedat')); 

	$sql1 ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql1 = mysqli_query($con,$sql1);
	while($re = mysqli_fetch_array($qsql1))
		{
		$sql2 ="SELECT * FROM discharge WHERE hospital_id='$re[entered_by]'  AND typevisit='IPD'";
		$qsql2 = mysqli_query($con,$sql2);
		while($rs = mysqli_fetch_array($qsql2))
		{
		    $sql3 ="SELECT * FROM addaspatient WHERE  prescriptionid='$rs[prescriptionid]'";
		$qsql3 = mysqli_query($con,$sql3);
		while($rsr = mysqli_fetch_array($qsql3))
		{
		    	$sqldoctor= "SELECT * FROM site_users WHERE userno='$rsr[Admitted_Under]'";
			$qsqldoctor = mysqli_query($con,$sqldoctor);
			while($rsdoctor = mysqli_fetch_array($qsqldoctor))
			{
			    $query = "SELECT * from patient WHERE patientid='$rs[patientid]' ";  
      $result = mysqli_query($con, $query);  
      while($row = mysqli_fetch_assoc($result))  
      {  
           if(isset($_POST["export"]))  
 {  
  

           fputcsv($output, $row);  
      }  
      }  
		}
		}
		}
      fclose($output);  

 }
 ?>