<?php
$keywords=$_GET['keywords'];
$location=$_GET['location'];
$district=$_GET['dist'];
$listings_per_page = '10';
$page = $_GET['page'];
$offset=0;
if($page>1) {
        $offset = $page * 10;
    }

$DBHOST='localhost';
$DBUSER='9b0684d711aa';
$DBPASS='36ec9448d376176a';
$DBNAME='jobatschool';

//create PDO connection
$db = new PDO("mysql:host=".$DBHOST.";port='';dbname=".$DBNAME, $DBUSER, $DBPASS);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$stmt=$db->query('SELECT * FROM listings WHERE keywords LIKE "%'.$keywords.'%" AND Location LIKE "%'.$location.'%" AND Location_State="'.$district.'" AND  listing_type_sid="6" LIMIT '.$offset.',10');
if($district=='00') {
	$stmt=$db->query('SELECT * FROM listings WHERE keywords LIKE "%'.$keywords.'%" AND Location LIKE "%'.$location.'%"  listing_type_sid="6" LIMIT '.$offset.',10');
}
$jobs=$stmt->fetchAll();


if($jobs!=TRUE)
 {
        $data=array(
            'function_result'=>'failed'

        );
		$login=json_encode($data);
        echo $login;


 }

 else{
foreach($jobs as $job)
{
    $jcstmt=$db->query('SELECT country_name FROM countries WHERE sid="'.$job['Location_Country'].'" LIMIT 1');
    $jcountry=$jcstmt->fetchColumn();
    $jsstmt=$db->query('SELECT state_name FROM states WHERE sid="'.$job['Location_State'].'" LIMIT 1');
    $jstate=$jsstmt->fetchColumn();
   $ustmt=$db->query('SELECT * FROM users WHERE sid="'.$job['user_sid'].'" and user_group_sid="41" LIMIT 1');
   $company=$ustmt->fetch(PDO::FETCH_ASSOC);
   $logo=$company['Logo'];
   $lstmt=$db->query('SELECT file_name FROM uploaded_files WHERE id="'.$logo.'" LIMIT 1');
   $logoname=$lstmt->fetchColumn();
   if($logoname==FALSE)
   {
	   $logoname='';
   }
    $cstmt=$db->query('SELECT country_name FROM countries WHERE sid="'.$company['Location_Country'].'" LIMIT 1');
    $country=$cstmt->fetchColumn();
    $sstmt=$db->query('SELECT state_name FROM states WHERE sid="'.$company['Location_State'].'" LIMIT 1');
    $state=$sstmt->fetchColumn();
   //echo $company['email'];
   $lstmt=$db->query('SELECT * FROM locations WHERE city="'.$company['Location_City'].'" LIMIT 1');
   $cords= $lstmt->fetch(PDO::FETCH_ASSOC);
    //echo $cords['latitude']; */
$rowdate=explode(' ',$job['activation_date']);
$dates=$rowdate[0];
  //echo $dates;
        //echo $job['email'];

        $dat[]=array('job'=>array(
                'Location'=>array(
                    'State'=>$jstate,
                    'City'=>$job['Location_City'],
                    'Country'=>'Aroor',
                    'ZipCode'=>$job['Location_ZipCode'],
                    'Address'=>$job['Location']
                ),
                'Company'=>array(
                    'CompanyName'=>$company['CompanyName'],
                    'ContactName'=>$company['ContactName'],
                    'PhoneNumber'=>$company['PhoneNumber'],
                    'email'=>$company['email'],
                    'Website'=>$company['WebSite'],
                    'Location'=>array(
                        'State'=>$state,
                        'City'=>$company['Location_City'],
                        'Country'=>'Aroor',
                        'ZipCode'=>$company['Location_ZipCode'],
                        'Address'=>$company['Location_Address']
                    ),
                    'geoLocation'=>array(
                        'Latitude'=>$cords['latitude'],
                        'Longitude'=>$cords['longitude']
                    ),
                    'Logo'=>array(
                        'file_url'=>$company['Logo'],
                        'thumb_file_url'=> $logoname
                    )
                ),
            'id'=>$job['sid'],
            'Title'=>$job['Title'],
            'JobDescription'=>$job['JobDescription'],
            'JobCategory'=>$job['JobCategory'],
            'Salary'=>$job['Salary'],
            'SalaryType'=>$job['SalaryType'],
            'JobRequirements'=>$job['JobRequirements'],
            'Occupations'=>$job['Occupations'],

            'activation_date'=>$dates,
            'EmploymentType'=>$job['EmploymentType'],
            ));

}
		$data=$dat;


	//print_r($data);
       $login=json_encode($data);
        echo $login;
     //echo "<pre>"; print_r($data); echo "</pre>";
        // $da=json_decode($dat);
        //echo $da->function_result->User->FirstName;

 }