<?php $thisPage->title = StringManipulator::trimStringToFullWord(62, stripslashes(strip_tags(WebPage::getSingleByName($dbObj, 'title', CURRENT_PAGE))) . ' - ' . WEBSITE_AUTHOR); $thisPage->description = StringManipulator::trimStringToFullWord(150, trim(stripslashes(strip_tags(WebPage::getSingleByName($dbObj, 'description', CURRENT_PAGE))))); $thisPage->keywords = WebPage::getSingleByName($dbObj, 'keywords', CURRENT_PAGE); $thisPage->author = WEBSITE_AUTHOR;
</a>
</h4>
<div class="post_info">
<span class="post_info_item post_info_posted">No of Courses:
<a title="View Courses" href="<?php
echo SITE_URL . 'courses/category/' . $categoryObj->id . '/' . StringManipulator::slugify($categoryObj->name) . '/';
?>
" class="post_info_date"><?php
echo number_format(Course::getSingleCategoryCount($dbObj, $categoryObj->id));
?>
</a>
</span>
</div>
<div class="post_descr">
<p class="text-justify"><?php
echo StringManipulator::trimStringToFullWord(160, strip_tags($categoryObj->description));
?>
</p>
<a title="View Courses" href="<?php
echo SITE_URL . 'courses/category/' . $categoryObj->id . '/' . StringManipulator::slugify($categoryObj->name) . '/';
?>
" class="sc_button sc_button_square sc_button_style_filled sc_button_bg_link sc_button_size_small">VIEW COURSES</a>
</div>
</div> <!-- /.post_content -->
</article> <!-- /.post_item -->
</div> <!-- /.isotope_item -->
<?php
}
?>
</div> <!-- /.isotope_wrap -->
</div> <!-- /div class="content" -->
/** Method that fetches courses from database for JQuery Data Table
* @param string $column Column name of the data to be fetched
* @param string $condition Additional condition e.g category_id > 9
* @param string $sort column name to be used as sort parameter
* @return JSON JSON encoded course details
*/
public function fetchForJQDT($draw, $totalData, $totalFiltered, $customSql = "", $column = "*", $condition = "", $sort = "id")
{
$sql = "SELECT {$column} FROM course ORDER BY {$sort}";
if (!empty($condition)) {
$sql = "SELECT {$column} FROM course WHERE {$condition} ORDER BY {$sort}";
}
if ($customSql != "") {
$sql = $customSql;
}
$data = $this->dbObj->fetchAssoc($sql);
$result = array();
$fetCourseStat = 'icon-check-empty';
$fetCourseRolCol = 'btn-warning';
$fetCourseRolTit = "Activate Course";
if (count($data) > 0) {
foreach ($data as $r) {
$courseMediaLink = '';
$fetCourseStat = 'icon-check-empty';
$fetCourseRolCol = 'btn-warning';
$fetCourseRolTit = "Activate Course";
$fetCourseFeat = 'icon-eye-close';
$fetCourseFeatCol = 'btn-warning';
$fetCourseFeatTit = "Make Featured Course";
if ($r['status'] == 1) {
$fetCourseStat = 'icon-check';
$fetCourseRolCol = 'btn-success';
$fetCourseRolTit = "De-activate Course";
}
if ($r['featured'] == 1) {
$fetCourseFeat = 'icon-eye-open';
$fetCourseFeatCol = 'btn-success';
$fetCourseFeatTit = "Remove Course as Featured";
}
if ($r['media'] != '') {
$courseMediaLink = '<a href="' . SITE_URL . 'media/course/' . $r['media'] . '">View Media</a>';
}
$result[] = array($r['id'], utf8_encode($r['name']), utf8_encode($r['short_name']), CourseCategory::getName($this->dbObj, $r['category']), utf8_encode($r['start_date']), utf8_encode($r['end_date']), utf8_encode($r['code']), StringManipulator::trimStringToFullWord(60, utf8_encode(stripcslashes(strip_tags($r['description'])))), utf8_encode($courseMediaLink), utf8_encode($r['currency'] . ' ' . number_format($r['amount'])), utf8_encode('<img src="../media/course-image/' . utf8_encode($r['image']) . '" width="60" height="50" style="width:60px; height:50px;" alt="Pix">'), utf8_encode($r['date_registered']), utf8_encode(' <button data-id="' . $r['id'] . '" data-name="' . $r['name'] . '" data-currency="' . $r['currency'] . '" data-short-name="' . $r['short_name'] . '" data-category="' . $r['category'] . '" data-start-date="' . $r['start_date'] . '" data-end-date="' . $r['end_date'] . '" data-code="' . $r['code'] . '" data-description ="" data-media="' . $r['media'] . '" data-image="' . $r['image'] . '" data-amount="' . $r['amount'] . '" data-date-registered="' . $r['date_registered'] . '" class="btn btn-info btn-sm edit-course" title="Edit"><i class="btn-icon-only icon-pencil"> </i> <span class="hidden" id="JQDTdescriptionholder">' . $r['description'] . '</span> </button> <button data-id="' . $r['id'] . '" data-name="' . $r['name'] . '" data-currency="' . $r['currency'] . '" data-status="' . $r['status'] . '" class="btn ' . $fetCourseRolCol . ' btn-sm activate-course" title="' . $fetCourseRolTit . '"><i class="btn-icon-only ' . $fetCourseStat . '"> </i></button> <button data-id="' . $r['id'] . '" data-media="' . $r['media'] . '" data-image="' . $r['image'] . '" data-name="' . $r['name'] . '" class="btn btn-danger btn-sm delete-course" title="Delete"><i class="btn-icon-only icon-trash"> </i></button> <button data-id="' . $r['id'] . '" data-name="' . $r['name'] . '" data-currency="' . $r['currency'] . '" data-featured="' . $r['featured'] . '" class="btn ' . $fetCourseFeatCol . ' btn-sm make-featured-course" title="' . $fetCourseFeatTit . '"><i class="btn-icon-only ' . $fetCourseFeat . '"> </i></button>'));
//
}
$json = array("status" => 1, "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $result);
} else {
$json = array("status" => 2, "msg" => "Necessary parameters not set. Or empty result. " . mysqli_error($this->dbObj->connection), "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => false);
}
$this->dbObj->close();
//header('Content-type: application/json');
return json_encode($json);
}
</a>
</div>
<h4 class="ev-title">
<a href="<?php
echo SITE_URL;
?>
event/<?php
echo $otherEventObj->id . "/" . StringManipulator::slugify($otherEventObj->name);
?>
/" class="related-ev-title main-color-1-hover"><?php
echo $otherEventObj->name;
?>
</a>
</h4>
<div class="ev-start small-text" style="text-transform: none;text-align: justify"><?php
echo StringManipulator::trimStringToFullWord(160, trim(stripcslashes(strip_tags($otherEventObj->description))));
?>
</div>
<br/>
<div class="ev-start small-text"><i class="fa fa-calendar"></i> <?php
echo explode(' ', $otherEventObj->dateTime)[0];
?>
</div>
<div class="ev-start small-text"><i class="fa fa-clock-o"></i> <?php
echo explode(' ', $otherEventObj->dateTime)[1];
?>
</div>
<div class="ev-start small-text"><i class="fa fa-map-marker"></i> <?php
echo $otherEventObj->location;
?>
</div>
<div id="body">
<div class="container">
<div class="content-pad-3x">
<div class="row">
<div id="content" class="col-md-9">
<article class="row single-event-content">
<div class="col-md-4 col-sm-5">
<div class="content-pad single-event-meta">
<div class="item-thumbnail">
<img width="263" height="263" src="<?php
echo $courseObj->image;
?>
" class="attachment-thumb_263x263 wp-post-image" alt="FraudDetectPrevent" />
</div><!--/item-thumbnail-->
<div class="event-description"> <?php
echo StringManipulator::trimStringToFullWord(300, trim(stripcslashes(strip_tags($courseObj->description))));
?>
..</div>
<div class="event-action"><button id="book-now" class="btn btn-primary text-default">Book Now!!!</button></div>
</div>
</div>
<div class="col-md-8 col-sm-7">
<div class="content-pad single-event-detail">
<div class="event-detail">
<div class="event-speaker"></div><!--/event-speaker-->
<div class="event-info row content-pad">
<div class="col-md-6 col-sm-6">
<h4 class="small-text"><i class="fa fa-calendar"></i> Start Date:</h4>
<p><?php
echo $courseObj->startDate;
?>
<div class="item-content">
<h3 class="item-title"><a href="<?php
echo SITE_URL;
?>
category/<?php
echo $category['id'] . "/" . StringManipulator::slugify($category['name']);
?>
/" title="<?php
echo $category['name'];
?>
" class="main-color-1-hover"><?php
echo $category['name'];
?>
</a></h3>
<div class="shortcode-blog-excerpt"><?php
echo StringManipulator::trimStringToFullWord(250, trim(stripcslashes(strip_tags($category['description']))));
?>
</div>
<div class="item-meta">
<a class="btn btn-default btn-lighter" href="<?php
echo SITE_URL;
?>
category/<?php
echo $category['id'] . "/" . StringManipulator::slugify($category['name']);
?>
/" title="<?php
echo $category['name'];
?>
">DETAILS <i class="fa fa-angle-right"></i></a>
<a href="category?id=<?php
echo $category['id'];
foreach ($memberObj->fetchRaw("*", " id = {$thisMemberId} ") as $member) {
$memberData = array('id' => 'id', 'name' => 'name', 'picture' => 'picture', 'bio' => 'bio', 'website' => 'website', 'qualification' => 'qualification', 'field' => 'field', 'email' => 'email');
foreach ($memberData as $key => $value) {
switch ($key) {
case 'picture':
$memberObj->{$key} = MEDIA_FILES_PATH1 . 'tutor/' . $member[$value];
break;
default:
$memberObj->{$key} = $member[$value];
break;
}
}
}
//Override page-properties
$thisPage->title = StringManipulator::trimStringToFullWord(62, stripslashes(strip_tags($memberObj->name . " Profile - " . WEBSITE_AUTHOR)));
$thisPage->description = StringManipulator::trimStringToFullWord(150, trim(stripslashes(strip_tags($memberObj->bio))));
?>
<!DOCTYPE html>
<html lang="en-US">
<head>
<?php
include 'includes/meta-tags.php';
?>
<script type="text/javascript"> window._wpemojiSettings = { "baseUrl":"http:\/\/s.w.org\/images\/core\/emoji\/72x72\/","ext":".png","source":{"concatemoji":"http:\/\/tsigroups.com\/tsi-new1\/wp-includes\/js\/wp-emoji-release.min.js?ver=4.3.1"}}; !function(a,b,c){function d(a){var c=b.createElement("canvas"),d=c.getContext&&c.getContext("2d");return d&&d.fillText?(d.textBaseline="top",d.font="600 32px Arial","flag"===a?(d.fillText(String.fromCharCode(55356,56812,55356,56807),0,0),c.toDataURL().length>3e3):(d.fillText(String.fromCharCode(55357,56835),0,0),0!==d.getImageData(16,16,1,1).data[0])):!1}function e(a){var c=b.createElement("script");c.src=a,c.type="text/javascript",b.getElementsByTagName("head")[0].appendChild(c)}var f,g;c.supports={simple:d("simple"),flag:d("flag")},c.DOMReady=!1,c.readyCallback=function(){c.DOMReady=!0},c.supports.simple&&c.supports.flag||(g=function(){c.readyCallback()},b.addEventListener?(b.addEventListener("DOMContentLoaded",g,!1),a.addEventListener("load",g,!1)):(a.attachEvent("onload",g),b.attachEvent("onreadystatechange",function(){"complete"===b.readyState&&c.readyCallback()})),f=c.source||{},f.concatemoji?e(f.concatemoji):f.wpemoji&&f.twemoji&&(e(f.twemoji),e(f.wpemoji)))}(window,document,window._wpemojiSettings);</script>
<style type="text/css"> img.wp-smiley, img.emoji { display: inline !important; border: none !important; box-shadow: none !important; height: 1em !important; width: 1em !important; margin: 0 .07em !important; vertical-align: -0.1em !important; background: none !important; padding: 0 !important; } </style>
<link rel='stylesheet' id='rs-plugin-settings-css' href='plugins/revslider/public/assets/css/settings5bca.css?ver=5.0.4.1' type='text/css' media='all' />
<style id='rs-plugin-settings-inline-css' type='text/css'>.tp-caption a{color:#ff7302;text-shadow:none;-webkit-transition:all 0.2s ease-out;-moz-transition:all 0.2s ease-out;-o-transition:all 0.2s ease-out;-ms-transition:all 0.2s ease-out}.tp-caption a:hover{color:#ffa902}</style>
<link rel='stylesheet' id='wp-pagenavi-css' href='<?php
echo SITE_URL;
?>
plugins/wp-pagenavi/pagenavi-css44fd.css?ver=2.70' type='text/css' media='all' />
/** Method that fetches events from database for JQuery Data Table
* @param string $column Column name of the data to be fetched
* @param string $condition Additional condition e.g event_id > 9
* @param string $sort column name to be used as sort parameter
* @return JSON JSON encoded event details
*/
public function fetchForJQDT($draw, $totalData, $totalFiltered, $customSql = "", $column = "*", $condition = "", $sort = "id")
{
$sql = "SELECT {$column} FROM event ORDER BY {$sort}";
if (!empty($condition)) {
$sql = "SELECT {$column} FROM event WHERE {$condition} ORDER BY {$sort}";
}
if ($customSql != "") {
$sql = $customSql;
}
$data = $this->dbObj->fetchAssoc($sql);
$result = array();
$fetEventStat = 'icon-check-empty';
$fetEventRolCol = 'btn-warning';
$fetEventRolTit = "Activate Event";
if (count($data) > 0) {
foreach ($data as $r) {
$fetEventStat = 'icon-check-empty';
$fetEventRolCol = 'btn-warning';
$fetEventRolTit = "Activate Event";
if ($r['status'] == 1) {
$fetEventStat = 'icon-check';
$fetEventRolCol = 'btn-success';
$fetEventRolTit = "De-activate Event";
}
$result[] = array($r['id'], utf8_encode('<div style="white-space:nowrap"><button data-id="' . $r['id'] . '" data-image="' . $r['image'] . '" data-name="' . $r['name'] . '" data-location="' . $r['location'] . '" class="btn btn-danger btn-sm delete-event" title="Delete"><i class="btn-icon-only icon-trash"> </i></button> <button data-id="' . $r['id'] . '" data-image="' . $r['image'] . '" data-name="' . $r['name'] . '" data-location="' . $r['location'] . '" data-date-time="' . $r['date_time'] . '" class="btn btn-info btn-sm edit-event" title="Edit"><i class="btn-icon-only icon-pencil"> </i> <span class="hidden" id="JQDTdescriptionholder">' . utf8_encode($r['description']) . '</span> </button> <button data-id="' . $r['id'] . '" data-name="' . $r['name'] . '" data-status="' . $r['status'] . '" class="btn ' . $fetEventRolCol . ' btn-sm activate-event" title="' . $fetEventRolTit . '"><i class="btn-icon-only ' . $fetEventStat . '"> </i></button></div>'), utf8_encode($r['name']), utf8_encode('<img src="../media/event/' . utf8_encode($r['image']) . '" width="40" height="30" alt="Pix">'), StringManipulator::trimStringToFullWord(90, strip_tags(utf8_encode($r['description']))), utf8_encode($r['date_time']), utf8_encode($r['location']), utf8_encode($r['date_added']));
//
}
$json = array("status" => 1, "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $result);
} else {
$json = array("status" => 2, "msg" => "Necessary parameters not set. Or empty result. " . mysqli_error($this->dbObj->connection), "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => false);
}
$this->dbObj->close();
//header('Content-type: application/json');
return json_encode($json);
}
/** Method that fetches sponsors from database for JQuery Data Table
* @param string $column Column name of the data to be fetched
* @param string $condition Additional condition e.g sponsor_id > 9
* @param string $sort column name to be used as sort parameter
* @return JSON JSON encoded course sponsor details
*/
public function fetchForJQDT($draw, $totalData, $totalFiltered, $customSql = "", $column = "*", $condition = "", $sort = "id")
{
$sql = "SELECT {$column} FROM sponsor ORDER BY {$sort}";
if (!empty($condition)) {
$sql = "SELECT {$column} FROM sponsor WHERE {$condition} ORDER BY {$sort}";
}
if ($customSql != "") {
$sql = $customSql;
}
$data = $this->dbObj->fetchAssoc($sql);
$result = array();
$fetSponsorStat = 'icon-check-empty';
$fetSponsorRolCol = 'btn-warning';
$fetSponsorRolTit = "Activate Sponsor";
if (count($data) > 0) {
foreach ($data as $r) {
$fetSponsorStat = 'icon-check-empty';
$fetSponsorRolCol = 'btn-warning';
$fetSponsorRolTit = "Activate Sponsor";
$multiActionBox = '<input type="checkbox" class="multi-action-box" data-id="' . $r['id'] . '" data-image="' . $r['image'] . '" data-logo="' . $r['logo'] . '" data-name="' . $r['name'] . '" data-status="' . $r['status'] . '"/>';
if ($r['status'] == 1) {
$fetSponsorStat = 'icon-check';
$fetSponsorRolCol = 'btn-success';
$fetSponsorRolTit = "De-activate Sponsor";
}
$result[] = array(utf8_encode($multiActionBox), $r['id'], utf8_encode(' <button data-id="' . $r['id'] . '" data-logo="' . $r['logo'] . '" data-image="' . $r['image'] . '" data-name="' . $r['name'] . '" data-website="' . $r['website'] . '" class="btn btn-danger btn-sm delete-sponsor" title="Delete"><i class="btn-icon-only icon-trash"> </i></button> <button data-id="' . $r['id'] . '" data-image="' . $r['image'] . '" data-logo="' . $r['logo'] . '" data-name="' . $r['name'] . '" data-product="' . $r['product'] . '" data-website="' . $r['website'] . '" class="btn btn-info btn-sm edit-sponsor" title="Edit"><i class="btn-icon-only icon-pencil"> </i> <span class="hidden" id="JQDTdescriptionholder">' . utf8_encode($r['description']) . '</span> </button> <button data-id="' . $r['id'] . '" data-name="' . $r['name'] . '" data-status="' . $r['status'] . '" class="btn ' . $fetSponsorRolCol . ' btn-sm activate-sponsor" title="' . $fetSponsorRolTit . '"><i class="btn-icon-only ' . $fetSponsorStat . '"> </i></button>'), utf8_encode($r['name']), utf8_encode('<img src="../media/sponsor/' . utf8_encode($r['logo']) . '" width="40" height="30" alt="Pix">'), utf8_encode('<a href="' . $r['website'] . '" target="_blank">Visit Website</a>'), utf8_encode($r['date_added']), utf8_encode($r['product']), StringManipulator::trimStringToFullWord(60, strip_tags(utf8_encode($r['description']))), utf8_encode('<img src="../media/sponsor-image/' . utf8_encode($r['image']) . '" width="40" height="30" alt="Pix">'));
//
}
$json = array("status" => 1, "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $result);
} else {
$json = array("status" => 2, "msg" => "Necessary parameters not set. Or empty result. " . mysqli_error($this->dbObj->connection), "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => false);
}
$this->dbObj->close();
//header('Content-type: application/json');
return json_encode($json);
}
?>
themes/education/skins/education/images/bg_over.png); background-repeat: repeat-x; background-position: center top; background-color:#1eaace;">
<div class="content_wrap">
<div class="breadcrumbs">
<a class="breadcrumbs_item home" href="<?php
echo SITE_URL;
?>
">Home</a><span class="breadcrumbs_delimiter"></span>
<?php
if ($refName != 'home') {
?>
<a class="breadcrumbs_item home" href="<?php
echo $referer;
?>
"><?php
echo strip_tags(WebPage::getSingleByName($dbObj, 'title', $refName));
?>
</a><span class="breadcrumbs_delimiter"></span><?php
}
?>
<span class="breadcrumbs_item current"><?php
echo StringManipulator::trimStringToFullWord(20, explode(" - ", $thisPage->title)[0]);
?>
</span>
</div>
<h2 class="page_title"><?php
echo explode(" - ", $thisPage->title)[0];
?>
</h2>
</div>
</div> <!-- /.page_top_breadcrumbs -->
echo SITE_URL . 'member/' . $memberObj->id . '/' . StringManipulator::slugify($memberObj->name);
?>
/" title="title" class="main-color-1-hover"><?php
echo $memberObj->name;
?>
</a></h3>
<div class="text-info" style="display:block;line-height:1.3;font-size:9px;text-transform:none; margin-bottom:6px">(<?php
echo $memberObj->qualification;
?>
)</div>
<h4 class="small-text text-success"><?php
echo $memberObj->field;
?>
</h4>
<p style="text-align:justify"><?php
echo StringManipulator::trimStringToFullWord(160, trim(stripcslashes(strip_tags($memberObj->bio))));
?>
</p>
<ul class="list-inline social-light text-center">
<li><a class="btn btn-default social-icon" href="mailto:<?php
echo $memberObj->email;
?>
"><i class="fa fa-envelope"></i></a></li>
<li><a class="btn btn-default social-icon" href="<?php
echo $memberObj->website;
?>
"><i class="fa fa-globe"></i></a></li>
</ul>
</div>
</div>
</div>
}
?>
<div class="col-md-3 col-sm-6 hero-feature">
<div class="thumbnail">
<img src="<?php
echo $contestObj->header;
?>
" alt="">
<div class="caption">
<h3><?php
echo $contestObj->title;
?>
</h3>
<p><?php
echo StringManipulator::trimStringToFullWord(100, $contestObj->description);
?>
</p>
<p><strong>Start Date:</strong> <?php
echo str_replace("-", "@", $contestObj->startDate);
?>
</p>
<p><strong>End Date:</strong> <?php
echo str_replace("-", "@", $contestObj->endDate);
?>
</p>
<p>
<a href="<?php
echo SITE_URL . "contest/{$contestObj->id}/" . StringManipulator::slugify($contestObj->title) . "/";
?>
" class="btn btn-primary">Enter Now!</a> <a href="<?php
</a>
</div>
<h4 class="ev-title">
<a href="<?php
echo SITE_URL;
?>
category/<?php
echo $relatedCategoryObj->id . "/" . StringManipulator::slugify($relatedCategoryObj->name);
?>
/" class="related-ev-title main-color-1-hover"><?php
echo $relatedCategoryObj->name;
?>
</a>
</h4>
<div class="ev-start small-text" style="text-transform: none"><?php
echo StringManipulator::trimStringToFullWord(160, trim(stripcslashes(strip_tags($relatedCategoryObj->description))));
?>
</div>
<div class="clear"></div>
</div>
<?php
}
?>
</div>
</div>
</div>
</div><!--/event-content-->
</div><!--/single-event-detail-->
</div>
<h5 class="sc_accordion_title">
<span class="sc_accordion_icon sc_accordion_icon_closed icon-plus-2"></span><span class="sc_accordion_icon sc_accordion_icon_opened icon-minus-2"></span><img class="wp-post-image" width="40" height="40" alt="<?php
echo $courseObj->name;
?>
" src="<?php
echo $courseObj->image;
?>
"> <?php
echo $courseObj->name;
?>
</h5>
<div class="sc_accordion_content">
<div class="wpb_text_column wpb_content_element ">
<div class="wpb_wrapper">
<p><?php
echo StringManipulator::trimStringToFullWord(200, strip_tags($courseObj->description));
?>
..</p>
<p>Date: <?php
echo $courseObj->endDate;
?>
</p>
<p><a href="<?php
echo SITE_URL . 'course/' . $courseObj->id . '/' . StringManipulator::slugify($courseObj->name) . '/';
?>
">View Full Details</a></p>
</div>
</div>
</div>
</div>
<?php
$monthVal = $dateParam1[2] . ' ' . $dateObj1->format('F') . ' - ' . $dateParam2[2] . ' ' . $dateObj2->format('F');
$courseObj->{$key} = $monthVal . ', ' . $dateParam1[0];
}
} else {
$courseObj->{$key} = $dateParam1[2] . ' ' . $dateObj1->format('F') . ', ' . $dateParam1[0] . ' - ' . $dateParam2[2] . ' ' . $dateObj2->format('F') . ', ' . $dateParam2[0];
}
break;
default:
$courseObj->{$key} = $course[$value];
break;
}
}
}
//Override page-properties
$thisPage->title = StringManipulator::trimStringToFullWord(62, stripslashes(strip_tags($courseObj->name . " Course - " . WEBSITE_AUTHOR)));
$thisPage->description = StringManipulator::trimStringToFullWord(150, trim(stripslashes(strip_tags($courseObj->description))));
?>
<!DOCTYPE html>
<html lang="en-US">
<head>
<?php
include 'includes/meta-tags.php';
?>
<style type="text/css">img.wp-smiley,img.emoji {display: inline !important;border: none !important;box-shadow: none !important;height: 1em !important;width: 1em !important;margin: 0 .07em !important;vertical-align: -0.1em !important;background: none !important;padding: 0 !important; }</style>
<link rel='stylesheet' id='rs-plugin-settings-css' href='<?php
echo SITE_URL;
?>
plugins/revslider/rs-plugin/css/settings1dc6.css?ver=4.6.5' type='text/css' media='all' />
<link rel='stylesheet' id='themerex-prettyphoto-style-css' href='<?php
echo SITE_URL;
?>
/** Method that fetches tutors from database for JQuery Data Table
* @param string $column Column name of the data to be fetched
* @param string $condition Additional condition e.g tutor_id > 9
* @param string $sort column name to be used as sort parameter
* @return JSON JSON encoded tutor details
*/
public function fetchForJQDT($draw, $totalData, $totalFiltered, $customSql = "", $column = "*", $condition = "", $sort = "id")
{
$sql = "SELECT {$column} FROM {$this->tableName} ORDER BY {$sort}";
if (!empty($condition)) {
$sql = "SELECT {$column} FROM {$this->tableName} WHERE {$condition} ORDER BY {$sort}";
}
if ($customSql != "") {
$sql = $customSql;
}
$data = $this->dbObj->fetchAssoc($sql);
$result = array();
$fetTutorStat = 'icon-check-empty';
$fetTutorRolCol = 'btn-warning';
$fetTutorRolTit = "Activate Tutor";
if (count($data) > 0) {
foreach ($data as $r) {
$fetTutorStat = 'icon-check-empty';
$fetTutorRolCol = 'btn-warning';
$fetTutorRolTit = "Activate Tutor";
if ($r['visible'] == 1) {
$fetTutorStat = 'icon-check';
$fetTutorRolCol = 'btn-success';
$fetTutorRolTit = "De-activate Tutor";
}
$result[] = array($r['id'], utf8_encode(' <button data-id="' . $r['id'] . '" data-picture="' . $r['picture'] . '" data-name="' . $r['name'] . '" class="btn btn-danger btn-small delete-tutor" title="Delete"><i class="btn-icon-only icon-trash"> </i></button> <button data-id="' . $r['id'] . '" data-name="' . $r['name'] . '" data-qualification="' . $r['qualification'] . '" data-field="' . $r['field'] . '" data-email="' . $r['email'] . '" data-website="' . $r['website'] . '" data-picture="' . $r['picture'] . '" class="btn btn-info btn-small edit-tutor" title="Edit"><i class="btn-icon-only icon-pencil"> </i> <span id="JQDTbioholder" data-bio ="" class="hidden">' . $r['bio'] . '</span> </button> <button data-id="' . $r['id'] . '" data-name="' . $r['name'] . '" data-visible="' . $r['visible'] . '" class="btn ' . $fetTutorRolCol . ' btn-small activate-tutor" title="' . $fetTutorRolTit . '"><i class="btn-icon-only ' . $fetTutorStat . '"> </i></button>'), utf8_encode('<img src="../media/tutor/' . utf8_encode($r['picture']) . '" style="width:60px; height:50px;" alt="Pix">'), utf8_encode($r['name']), StringManipulator::trimStringToFullWord(40, utf8_encode(stripslashes(strip_tags($r['qualification'])))), StringManipulator::trimStringToFullWord(40, utf8_encode(stripslashes(strip_tags($r['field'])))), StringManipulator::trimStringToFullWord(62, utf8_encode(stripslashes(strip_tags($r['bio'])))), utf8_encode($r['email']), utf8_encode($r['website']));
//
}
$json = array("status" => 1, "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $result);
} else {
$json = array("status" => 2, "msg" => "Necessary parameters not set. Or empty result. " . mysqli_error($this->dbObj->connection), "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => false);
}
$this->dbObj->close();
//header('Content-type: application/json');
return json_encode($json);
}
/** Method that fetches courses from database
* @param string $column Column name of the data to be fetched
* @param string $condition Additional condition e.g category_id > 9
* @param string $sort column name to be used as sort parameter
* @return JSON JSON encoded course details
*/
public function fetch($column = "*", $condition = "", $sort = "id")
{
$sql = "SELECT {$column} FROM course ORDER BY {$sort}";
if (!empty($condition)) {
$sql = "SELECT {$column} FROM course WHERE {$condition} ORDER BY {$sort}";
}
$data = $this->dbObj->fetchAssoc($sql);
$result = array();
if (count($data) > 0) {
foreach ($data as $r) {
$result[] = array("id" => $r['id'], "name" => utf8_encode($r['name']), "image" => utf8_encode($r['image']), 'shortName' => utf8_encode($r['short_name']), 'category' => utf8_encode($r['category']), 'startDate' => utf8_encode($r['start_date']), 'endDate' => utf8_encode($r['end_date']), 'code' => utf8_encode($r['code']), 'description' => utf8_encode(StringManipulator::trimStringToFullWord(200, stripcslashes(strip_tags($r['description'])))), 'media' => utf8_encode($r['media']), 'currency' => utf8_encode($r['currency']), 'amount' => utf8_encode($r['amount']), 'cost' => utf8_encode($r['currency'] . number_format($r['amount'], 2)), 'status' => utf8_encode($r['status']), 'dateRegistered' => utf8_encode($r['date_registered']), 'categoryName' => utf8_encode(CourseCategory::getName($this->dbObj, $r['category'])));
}
$json = array("status" => 1, "info" => $result);
} else {
$json = array("status" => 2, "msg" => "Necessary parameters not set. Or empty result. " . mysqli_error($this->dbObj->connection));
}
$this->dbObj->close();
header('Content-type: application/json');
return json_encode($json);
}
/** Method that fetches settings from database for JQuery Data Table
* @param string $column Column value of the data to be fetched
* @param string $condition Additional condition e.g setting_name > 9
* @param string $sort column value to be used as sort parameter
* @return JSON JSON encoded course setting details
*/
public function fetchForJQDT($draw, $totalData, $totalFiltered, $customSql = "", $column = "*", $condition = "", $sort = "name")
{
$sql = "SELECT {$column} FROM " . self::$tableName . " ORDER BY {$sort}";
if (!empty($condition)) {
$sql = "SELECT {$column} FROM " . self::$tableName . " WHERE {$condition} ORDER BY {$sort}";
}
if ($customSql != "") {
$sql = $customSql;
}
$data = self::$dbObj->fetchAssoc($sql);
$result = array();
if (count($data) > 0) {
foreach ($data as $r) {
$deleteActionLink = '<button data-name="' . $r['name'] . '" class="btn btn-danger btn-sm delete-setting" title="Delete"><i class="btn-icon-only icon-trash"> </i> <span name="JQDTvalueholder" class="hidden">' . $r['value'] . '</span></button>';
$multiActionBox = '<input type="checkbox" class="multi-action-box" data-name="' . $r['name'] . '" />';
if ($r['name'] == "MAIN_ADMIN_EMAIL") {
$deleteActionLink = '';
$multiActionBox = '';
}
$result[] = array(utf8_encode($multiActionBox), utf8_encode($r['name']), utf8_encode(StringManipulator::trimStringToFullWord(90, stripcslashes(strip_tags($r['value'])))), utf8_encode(' <button data-name="' . $r['name'] . '" class="btn btn-info btn-sm edit-setting" title="Edit"><i class="btn-icon-only icon-pencil"> </i> <span id="JQDTvalueholder" class="hidden">' . $r['value'] . '</span> </button> ' . $deleteActionLink));
}
$json = array("status" => 1, "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $result);
} else {
$json = array("status" => 2, "msg" => "Empty result. " . mysqli_error(self::$dbObj->connection), "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => false);
}
self::$dbObj->close();
header('Content-type: application/json');
return json_encode($json);
}
/** Method that fetches contests from database for JQuery Data Table
* @param string $column Column name of the data to be fetched
* @param string $condition Additional condition e.g category_id > 9
* @param string $sort column name to be used as sort parameter
* @return JSON JSON encoded contest details
*/
public function fetchForJQDT($draw, $totalData, $totalFiltered, $customSql = "", $column = "*", $condition = "", $sort = "id")
{
$sql = "SELECT {$column} FROM " . self::$tableName . " ORDER BY {$sort}";
if (!empty($condition)) {
$sql = "SELECT {$column} FROM " . self::$tableName . " WHERE {$condition} ORDER BY {$sort}";
}
if ($customSql != "") {
$sql = $customSql;
}
$data = self::$dbObj->fetchAssoc($sql);
$result = array();
$fetContestStat = 'icon-check-empty';
$fetContestRolCol = 'btn-warning';
$fetContestRolTit = "Activate Contest";
if (count($data) > 0) {
foreach ($data as $r) {
$multiActionBox = '<input type="checkbox" class="multi-action-box" data-id="' . $r['id'] . '" data-status="' . $r['status'] . '" data-header="' . $r['header'] . '" data-logo="' . $r['logo'] . '" />';
$fetContestStat = 'icon-check-empty';
$fetContestRolCol = 'btn-warning';
$fetContestRolTit = "Activate Contest";
if ($r['status'] == 1) {
$fetContestStat = 'icon-check';
$fetContestRolCol = 'btn-success';
$fetContestRolTit = "De-activate Contest";
}
//$result[] = array(utf8_encode($multiActionBox), $r['id'], utf8_encode($r['title']), utf8_encode($r['intro']), StringManipulator::trimStringToFullWord(60, utf8_encode(stripcslashes(strip_tags($r['description'])))), utf8_encode('<img src="../media/contest-header/'.utf8_encode($r['header']).'" width="60" height="50" style="width:60px; height:50px;" alt="Pix">'), utf8_encode('<img src="../media/contest-logo/'.utf8_encode($r['logo']).'" width="60" height="50" style="width:60px; height:50px;" alt="Pix">'), utf8_encode($r['start_date']), utf8_encode($r['end_date']), utf8_encode($r['announcement_date']), utf8_encode($r['winners']), utf8_encode($r['question']), utf8_encode($r['answer']), utf8_encode($r['point']), utf8_encode($r['bonus_point']), StringManipulator::trimStringToFullWord(60, utf8_encode(stripcslashes(strip_tags($r['rules'])))), StringManipulator::trimStringToFullWord(60, utf8_encode(stripcslashes(strip_tags($r['prize'])))), StringManipulator::trimStringToFullWord(60, utf8_encode(stripcslashes(strip_tags($r['message'])))), StringManipulator::trimStringToFullWord(60, utf8_encode(stripcslashes(strip_tags($r['css'])))), utf8_encode($r['date_added']), utf8_encode($r['announce_winner']), utf8_encode($r['restart']), utf8_encode($r['restart_interval']), utf8_encode(' <button data-id="'.$r['id'].'" data-title="'.$r['title'].'" data-intro="'.$r['intro'].'" data-header="'.$r['header'].'" data-logo="'.$r['logo'].'" data-start-date="'.$r['start_date'].'" data-end-date="'.$r['end_date'].'" data-announcement-date="'.$r['announcement_date'].'" data-winners ="'.$r['winners'].'" data-question="'.$r['question'].'" data-answer="'.$r['answer'].'" data-point="'.$r['point'].'" data-bonus-point="'.$r['bonus_point'].'" data-prize ="'.$r['prize'].'" data-message ="'.$r['message'].'" data-css ="'.$r['css'].'" data-date-added="'.$r['date_added'].'" class="btn btn-info btn-sm edit-contest" title="Edit"><i class="btn-icon-only icon-pencil"> </i> <span class="hidden" id="JQDTrulesholder">'.$r['rules'].'</span> </button> <button data-id="'.$r['id'].'" data-title="'.$r['title'].'" data-status="'.$r['status'].'" class="btn '.$fetContestRolCol.' btn-sm activate-contest" title="'.$fetContestRolTit.'"><i class="btn-icon-only '.$fetContestStat.'"> </i></button> <button data-id="'.$r['id'].'" data-header="'.$r['header'].'" data-logo="'.$r['logo'].'" data-title="'.$r['title'].'" class="btn btn-danger btn-sm delete-contest" title="Delete"><i class="btn-icon-only icon-trash"> </i></button>'));//
$result[] = array(utf8_encode($multiActionBox), utf8_encode('<div style="white-space:nowrap"> <button data-id="' . $r['id'] . '" data-title="' . $r['title'] . '" data-intro="' . $r['intro'] . '" data-header="' . $r['header'] . '" data-logo="' . $r['logo'] . '" data-start-date="' . $r['start_date'] . '" data-end-date="' . $r['end_date'] . '" data-announcement-date="' . $r['announcement_date'] . '" data-winners ="' . $r['winners'] . '" data-question="' . $r['question'] . '" data-answer="' . $r['answer'] . '" data-point="' . $r['point'] . '" data-bonus-point="' . $r['bonus_point'] . '" data-prize ="' . $r['prize'] . '" data-message ="' . $r['message'] . '" data-css ="' . $r['css'] . '" data-date-added="' . $r['date_added'] . '" class="btn btn-info btn-sm edit-contest" title="Edit"><i class="btn-icon-only icon-pencil"> </i> <span class="hidden" id="JQDTrulesholder">' . $r['rules'] . '</span> </button> <button data-id="' . $r['id'] . '" data-title="' . $r['title'] . '" data-status="' . $r['status'] . '" class="btn ' . $fetContestRolCol . ' btn-sm activate-contest" title="' . $fetContestRolTit . '"><i class="btn-icon-only ' . $fetContestStat . '"> </i></button> <button data-id="' . $r['id'] . '" data-header="' . $r['header'] . '" data-logo="' . $r['logo'] . '" data-title="' . $r['title'] . '" class="btn btn-danger btn-sm delete-contest" title="Delete"><i class="btn-icon-only icon-trash"> </i></button></div>'), $r['id'], utf8_encode($r['title']), utf8_encode($r['intro']), StringManipulator::trimStringToFullWord(60, utf8_encode(stripcslashes(strip_tags($r['description'])))), utf8_encode('<img src="../media/contest-header/' . utf8_encode($r['header']) . '" width="60" height="50" style="width:60px; height:50px;" alt="Pix">'), utf8_encode('<img src="../media/contest-logo/' . utf8_encode($r['logo']) . '" width="60" height="50" style="width:60px; height:50px;" alt="Pix">'), utf8_encode($r['start_date']), utf8_encode($r['end_date']), utf8_encode($r['announcement_date']), utf8_encode($r['winners']), utf8_encode($r['question']), utf8_encode($r['answer']), utf8_encode($r['point']), utf8_encode($r['bonus_point']), StringManipulator::trimStringToFullWord(60, utf8_encode(stripcslashes(strip_tags($r['rules'])))), StringManipulator::trimStringToFullWord(60, utf8_encode(stripcslashes(strip_tags($r['prize'])))), StringManipulator::trimStringToFullWord(60, utf8_encode(stripcslashes(strip_tags($r['message'])))), StringManipulator::trimStringToFullWord(60, utf8_encode(stripcslashes(strip_tags($r['css'])))), utf8_encode($r['date_added']), utf8_encode($r['announce_winner']), utf8_encode($r['restart']), utf8_encode($r['restart_interval']), utf8_encode($r['cut_off_point']), utf8_encode($r['theme']));
}
$json = array("status" => 1, "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $result);
} else {
$json = array("status" => 2, "msg" => "Necessary parameters not set. Or empty result. " . mysqli_error(self::$dbObj->connection), "draw" => intval($draw), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => false);
}
self::$dbObj->close();
//header('Content-type: application/json');
return json_encode($json);
}
