locate();
$userCountry = $geoplugin->countryName;
function getcountry($id)
{
$objdb = new DatabaseNew();
$conditon="idcountry=$id";
$cname=$objdb->getTableValuesArray(" country",$conditon);
return $cname;
//print_r($cname['countryName']);
}
//jobs
$objJobs = new JobsNew();
$db = new DatabaseNew();
$limit =100;
$table ="jobs";
$cond =" AND jobs.active = 1 AND jobs.dateExpiry >= CURDATE() ";
$sortquery =" ORDER BY sort_order ASC, dateAdded DESC";
//$directPage="jobs.php";
$directPage="JobsAll";
$fields=" * ";
$listing_jobs=$objJobs->listDetails($limit, $page, $table, $directPage, $fields, $cond, $sortquery,$qry);
// end jobs
// Internship
$table ="tefl_internships";
$cond =" AND tefl_internships.active = 1 ";
$sortquery =" ORDER BY dateAdded DESC";
//$directPage="jobs.php";
$directPage="TEFL Internship";
$fields=" * ";
$listing_internships=$objJobs->listDetails($limit, $page, $table, $directPage, $fields, $cond, $sortquery,$qry);
// end Internship
// Courselisting
function getcourseListing($type){
$objCourse = new CourseNew();
$objJobs = new JobsNew();
$objStud = new StudentNew();
$objCur = new CurrencyNew();
$objDb = new DatabaseNew();
$limit=100;
$userCurrDetails = $objStud->getCurrencyFromCountry($userCountry);
$courseDetails = $objDb->getTableValuesArray("course_type","idcourse_type ='".$type."'");
$courseTypeName = trim($courseDetails['courseTypeName']);
if ( $courseDetails['courseTypeName'] == "CELTA Courses") {
$courseTypeName = "Classroom courses";
}
if ($_SERVER['HTTP_HOST']=="teflexpressinternational.com" || $_SERVER['HTTP_HOST']=="www.teflexpressinternational.com") { // Mantis edit 5732
$without_oxcel_course = " AND idcourses != '117' AND idcourses != '118' AND idcourses != '119' AND idcourses != '120' AND idcourses != '121' AND idcourses != '122' AND idcourses != '123' AND idcourses != '124' AND idcourses != '125' /*AND idcourses != '126'*/";
}
if ($_SERVER['HTTP_HOST']=="tesolexpressonline.com" || $_SERVER['HTTP_HOST']=="www.tesolexpressonline.com") { // Mantis edit 5687
$without_tesol_specified_course = " AND idcourses != '110'";
}
/*if ($_SERVER['HTTP_HOST']=="teflexpress.co.uk" || $_SERVER['HTTP_HOST']=="www.teflexpress.co.uk") { // Mantis edit 5732
$without_oxcel_course = " AND idcourses != '129' AND idcourses != '128' AND idcourses != '127'";
}*/
$table ="courses,course_hours";
$cond =" courses.course_type_idcourse_type = '$type'
AND active='1'
AND idcourses != '55'
AND idcourses != '56'
AND idcourses != '75'
AND idcourses != '77'
AND idcourses != '78'
AND idcourses != '79'
AND idcourses != '80'
AND idcourses != '81'
AND idcourses != '82'
AND idcourses != '83'
AND idcourses != '87'
AND idcourses != '88'
AND idcourses != '89'
AND idcourses != '96'
AND idcourses != '98'
AND idcourses != '108'
AND idcourses != '109'
AND idcourses != '60'
AND idcourses != '112'
AND idcourses != '107'
AND idcourses != '108'
AND idcourses != '113'
AND idcourses != '114'
$without_oxcel_course
$without_tesol_specified_course
AND course_hours.idcourse_hours = courses.course_hours_idcourse_hours
AND ( country_idcountry = 0 || country_idcountry = ".$userCurrDetails['idcountry']." )";
$sortquery =" ORDER BY courses.listing_order ASC , course_hours.hours DESC ";
//$sortquery =" ORDER BY course_hours.hours DESC ";
$fields=" * ";
//$qry ="&type=$type";
$cond .=" AND is_course_show_in_frontend = 'Yes'";
$listing=$objCourse->listDetailsWithPaging($limit, $page, $table, $directPage, $fields, $cond, $sortquery,$qry); ////function for list jobs
return $listing;
}
//end courselisting
//========Start of List Items===================================
$objItem = new ItemNew();
$table ="items";
$cond1 =" AND display='Yes' AND FIND_IN_SET('Shop', product_category)";
$cond ="AND `stockCount` >'0' AND active='1'".$cond1;
$sortquery ="ORDER BY `itemName` ASC";
$directPage="Shop";
$fields=" * ";
$listing_shopitems=$objItem->listDetails($limit, $page, $table, $directPage, $fields, $cond, $sortquery,$qry); ////function for list Items
?>