/** 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>