<?php
	include("../include/config.php");
$sql="select id,fname,lname,email,user_type,house_no,street,complex,landmark,city_id,pincode,area,state,mobile,full_address,reward_points,register_date,status from tbl_user order by id desc";
$result=$obj->query($sql);
$csvData="S.No.,User Type,Name,Email,Mobile,Address,Area,Pincode,Register Date,Status\n";
$count=1;

while($data=$obj->fetchNextObject($result))
    {
		if($data->full_address){
		$address=$data->full_address;
		}else{
		$address=$data->house_no." ".$data->street." ".$data->complex." ".$data->landmark." ".$data->city_id." ".$data->state;
		}
		$add=str_replace(',', "-", $address);
		if($data->user_type==0){
		$user_type="Registered";
		}else{
		$user_type="Guest";
		}
		if($data->status==1){
			$status="Active";
		}else{
			$status="Deactive";
		}
        $csvData.=$count.",".$user_type.",".$data->fname." ".$data->lname.",".$data->email.",".$data->mobile." ".$data->phone.",".$add.",".$data->state.",".$data->pincode.",".$data->register_date.",".$status."\n";
    $count++; 
    }
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: text/csv; charset=utf-8");
header("Content-Disposition: attachment; filename=Register".date("dMY_H:i").".csv");

echo $csvData;
exit;
?>