<?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); }