ajgkqsldxvkqsldkqs
azelfkqsmkqsmlkdqsmld
azmlekdqmskdmlqskd
nkldsfkqsmldkqsmdmlskd
<?php
include("init.php");
include_once("classes.php");
if(isset($_GET['id'])){
	$mcrypt = new MCrypt();
	$offers = array();
	$session = $mcrypt->decrypt($_GET['id']);
	$lat = $mcrypt->decrypt($_GET['lat']);
	$long = $mcrypt->decrypt($_GET['long']);
	/* Fetch the information */
	$con = db_connect();
	$sql = session($con,$session);
	$total = 0;
	$message = "";
	if(db_rows($con,$sql)>0){
		/* fetch userid and create session token */
		$query = mysqli_query($con,$sql);
		while($row=mysqli_fetch_array($query)){
			$userid = $row['userid'];
		}
		$sql = offers_in_country($con,$lat,$long);
		$total = db_rows($con,$sql);
		if($total==0){
			/* Fetch all offers including nearby offers */
			$sql = offers_in_country_including_nearby($con);
		}
		$total = db_rows($con,$sql);
		if($total>0){
			/* Fetch the list of companies */
			$query = mysqli_query($con,$sql);
			while($row=mysqli_fetch_array($query)){
				$title = $row['title'];
				$desc = $row['description'];
				$image = $row['image'];
				$image = offer_image_link($image);
				$fid = $row['fid'];
				$target = $row['target'];
				$status = $row['status'];
				$status_text = translate_status($status);
				$date = changeDateToDayMonthYear($row['date']);
				$id = $row['userid'];
				$name = $row['name'];
				$about = $row['about'];
				$logo = $row['picture'];
				$user_type = $row['ac_type'];
				/* if logo is empty, use default logo */
				if(empty($logo)){
					if($user_type==1){
						$logo = "no_image.png";
					}else if($user_type==2){
						$logo = "default.jpg";
					}
				}
				$logo = pic_url($logo);
				$region = region_name($con,$row['region']);
				$town = town_name($con,$row['town']);
				$phone = $row['phone'];
				$direction = $row['direction'];
				$ghana_post = $row['ghana_post'];
				$website = $row['website'];
				if(empty($website)){
					$website = " ";
				}
				$alt_phone = $row['alt_phone'];
				if(empty($alt_phone)){
					$alt_phone = " ";
				}
				$landmark = $row['landmark'];
				$latitude = $row['latitude'];
				$longitude = $row['longitude'];
				$token = $row['token'];
				$opening_hrs = company_opening_hours($con,$id);
				if(empty($opening_hrs)){
					$opening_hrs = " ";
				}
				$subscription = subscription($con,$id,$userid);
				array_push($offers,array('fid'=>$mcrypt->encrypt($fid),
						'title'=>$mcrypt->encrypt($title),
						'desc'=>$mcrypt->encrypt($desc),
						'image'=>$mcrypt->encrypt($image),
						'status_text'=>$mcrypt->encrypt($status_text), 
						'status'=>$mcrypt->encrypt($status), 
						'target'=>$mcrypt->encrypt(translate_target($target)),
						'date'=>$mcrypt->encrypt($date),
						'subscription'=>$mcrypt->encrypt($subscription),
						'user_type'=>$mcrypt->encrypt($user_type),
						'name'=>$mcrypt->encrypt($name),
						'about'=>$mcrypt->encrypt($about), 
						'logo'=>$mcrypt->encrypt($logo),
						'region'=>$mcrypt->encrypt($region), 						
						'town'=>$mcrypt->encrypt($town),
						'phone'=>$mcrypt->encrypt($phone),
						'website'=>$mcrypt->encrypt($website),
						'alt_phone'=>$mcrypt->encrypt($alt_phone),
						'landmark'=>$mcrypt->encrypt($landmark),
						'direction'=>$mcrypt->encrypt($direction),
						'ghana_post'=>$mcrypt->encrypt($ghana_post),
						'opening_hrs'=>$mcrypt->encrypt($opening_hrs),
						'latitude'=>$mcrypt->encrypt($latitude),
						'longitude'=>$mcrypt->encrypt($longitude),
						'cid'=>$mcrypt->encrypt($id),
						'id'=>$mcrypt->encrypt($token)
					)
				);
			}
		}else{
				$message = "No offer around at the moment";
		}
	}else{
		$message = "You don't have right to access this page";
	}
	echo json_encode(array("total"=>$total,"offers"=>$offers,"message"=>$mcrypt->encrypt($message)));
	db_close($con);
}