/** 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 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);
}
<div class="post_info">
<span class="post_info_item post_info_posted">
<a href="<?php
echo SITE_URL . 'course/' . $courseObj->id . '/' . StringManipulator::slugify($courseObj->name) . '/';
?>
" class="post_info_date"><?php
echo $courseObj->startDate;
?>
</a>
</span>
<span class="post_info_item post_info_posted_by"> |
<a href="<?php
echo SITE_URL . 'category/' . $courseObj->category . '/' . StringManipulator::slugify(CourseCategory::getName($dbObj, $courseObj->category)) . '/';
?>
" class="post_info_author"><?php
echo CourseCategory::getName($dbObj, $courseObj->category);
?>
</a>
</span>
<span class="post_info_item post_info_counters">
<a href="<?php
echo SITE_URL . 'course/' . $courseObj->id . '/' . StringManipulator::slugify($courseObj->name) . '/';
?>
" class="post_counters_item post_counters_rating icon-star-1">
<span class="post_counters_number"><?php
echo $courseObj->currency . ' ' . number_format($courseObj->amount, 2);
?>
</span>
</a>
</span>
