コード例 #1
0
ファイル: view.php プロジェクト: JozefAB/neoacu
}
$user = JFactory::getUser();
$diff_date = 0;
$db = JFactory::getDBO();
$sql = "select open_target, lesson_window_size from #__guru_config";
$db->setQuery($sql);
$db->query();
$result = $db->loadAssocList();
$target = intval($result["0"]["open_target"]);
$lesson_size = $result["0"]["lesson_window_size"];
$lesson_size = explode("x", $lesson_size);
$lesson_height = $lesson_size["0"];
$lesson_width = $lesson_size["1"];
$document = JFactory::getDocument();
$document->addScript("components/com_guru/js/programs.js");
$guruModelguruTask = new guruModelguruTask();
$guruModelguruOrder = new guruModelguruOrder();
$configs = $guruModelguruTask->getConfig();
if (isset($step) && $step != false) {
    $skip_modules_course = $guruModelguruTask->getSkipAction($step->pid);
} else {
}
$module_pozition = "0";
$certificates = $guruModelguruTask->getCertificate();
$is_final = $guruModelguruTask->getIsFinal($step->id);
if ($is_final == "") {
    $is_final = 0;
}
$db = JFactory::getDBO();
$sql = "select avg_certc from #__guru_program where id=" . $step->pid;
$db->setQuery($sql);
コード例 #2
0
ファイル: guruauthor.php プロジェクト: JozefAB/neoacu
    function parse_media($id, $layout_id)
    {
        $db = JFactory::getDBO();
        $sql = "SELECT * FROM #__guru_config LIMIT 1";
        $db->setQuery($sql);
        if (!$db->query()) {
            $this->setError($db->getErrorMsg());
            return false;
        }
        $configs = $db->loadObject();
        if (!isset($media)) {
            $media = "";
        }
        $default_size = $configs->default_video_size;
        $default_width = "";
        $default_height = "";
        if (trim($default_size) != "") {
            $default_size = explode("x", $default_size);
            $default_width = $default_size["1"];
            $default_height = $default_size["0"];
        }
        if ($layout_id != 15) {
            $sql = "SELECT * FROM #__guru_media WHERE id = " . $id;
            $db->setQuery($sql);
            $db->query();
            $the_media = $db->loadObject();
            @($the_media->code = stripslashes($the_media->code));
        } else {
            $sql = "SELECT * FROM #__guru_quiz\r\n\t\t\t\t\t\tWHERE id = " . $id;
            $db->setQuery($sql);
            $db->query();
            $the_media = $db->loadObject();
            $the_media->type = "quiz";
            $the_media->code = "";
        }
        $no_plugin_for_code = 0;
        $aheight = 0;
        $awidth = 0;
        $vheight = 0;
        $vwidth = 0;
        if (@$the_media->type == 'video') {
            if ($the_media->source == 'url' || $the_media->source == 'local') {
                if (($the_media->width == 0 || $the_media->height == 0) && $the_media->option_video_size == 1) {
                    $vheight = 300;
                    $vwidth = 400;
                } elseif ($the_media->width != 0 && $the_media->height != 0 && $the_media->option_video_size == 1) {
                    $vheight = $the_media->height;
                    $vwidth = $the_media->width;
                } elseif ($the_media->option_video_size == 0) {
                    $vheight = $default_height;
                    $vwidth = $default_width;
                }
            } elseif ($the_media->source == 'code') {
                if (($the_media->width == 0 || $the_media->height == 0) && $the_media->option_video_size == 1) {
                    $begin_tag = strpos($the_media->code, 'width="');
                    if ($begin_tag !== false) {
                        $remaining_code = substr($the_media->code, $begin_tag + 7, strlen($the_media->code));
                        $end_tag = strpos($remaining_code, '"');
                        $vwidth = substr($remaining_code, 0, $end_tag);
                        $begin_tag = strpos($the_media->code, 'height="');
                        if ($begin_tag !== false) {
                            $remaining_code = substr($the_media->code, $begin_tag + 8, strlen($the_media->code));
                            $end_tag = strpos($remaining_code, '"');
                            $vheight = substr($remaining_code, 0, $end_tag);
                            $no_plugin_for_code = 1;
                        } else {
                            $vheight = 300;
                            $vwidth = 400;
                        }
                    } else {
                        $vheight = 300;
                        $vwidth = 400;
                    }
                } elseif (($the_media->width != 0 || $the_media->height != 0) && $the_media->option_video_size == 1) {
                    $replace_with = 'width="' . $the_media->width . '"';
                    $the_media->code = preg_replace('#width="[0-9]+"#', $replace_with, $the_media->code);
                    $replace_with = 'height="' . $the_media->height . '"';
                    $the_media->code = preg_replace('#height="[0-9]+"#', $replace_with, $the_media->code);
                    $replace_with = 'name="width" value="' . $the_media->width . '"';
                    $the_media->code = preg_replace('#name="width" value="[0-9]+"#', $replace_with, $the_media->code);
                    $replace_with = 'name="height" value="' . $the_media->height . '"';
                    $the_media->code = preg_replace('#name="height" value="[0-9]+"#', $replace_with, $the_media->code);
                    $vheight = $the_media->height;
                    $vwidth = $the_media->width;
                } elseif ($the_media->option_video_size == 0) {
                    $replace_with = 'width="' . $default_width . '"';
                    $the_media->code = preg_replace('#width="[0-9]+"#', $replace_with, $the_media->code);
                    $replace_with = 'height="' . $default_height . '"';
                    $the_media->code = preg_replace('#height="[0-9]+"#', $replace_with, $the_media->code);
                    $replace_with = 'name="width" value="' . $default_width . '"';
                    $the_media->code = preg_replace('#value="[0-9]+" name="width"#', $replace_with, $the_media->code);
                    $replace_with = 'name="height" value="' . $default_height . '"';
                    $the_media->code = preg_replace('#value="[0-9]+" name="height"#', $replace_with, $the_media->code);
                    $replace_with = 'name="width" value="' . $default_width . '"';
                    $the_media->code = preg_replace('/name="width" value="[0-9]+"/', $replace_with, $the_media->code);
                    $replace_with = 'name="height" value="' . $default_height . '"';
                    $the_media->code = preg_replace('/name="height" value="[0-9]+"/', $replace_with, $the_media->code);
                    $vheight = $default_height;
                    $vwidth = $default_width;
                }
            }
        } elseif (@$the_media->type == 'audio') {
            if ($the_media->source == 'url' || $the_media->source == 'local') {
                if ($the_media->width == 0 || $the_media->height == 0) {
                    $aheight = 20;
                    $awidth = 300;
                } else {
                    $aheight = $the_media->height;
                    $awidth = $the_media->width;
                }
            } elseif ($the_media->source == 'code') {
                if ($the_media->width == 0 || $the_media->height == 0) {
                    $begin_tag = strpos($the_media->code, 'width="');
                    if ($begin_tag !== false) {
                        $remaining_code = substr($the_media->code, $begin_tag + 7, strlen($the_media->code));
                        $end_tag = strpos($remaining_code, '"');
                        $awidth = substr($remaining_code, 0, $end_tag);
                        $begin_tag = strpos($the_media->code, 'height="');
                        if ($begin_tag !== false) {
                            $remaining_code = substr($the_media->code, $begin_tag + 8, strlen($the_media->code));
                            $end_tag = strpos($remaining_code, '"');
                            $aheight = substr($remaining_code, 0, $end_tag);
                            $no_plugin_for_code = 1;
                        } else {
                            $aheight = 20;
                            $awidth = 300;
                        }
                    } else {
                        $aheight = 20;
                        $awidth = 300;
                    }
                } else {
                    $replace_with = 'width="' . $the_media->width . '"';
                    $the_media->code = preg_replace('#width="[0-9]+"#', $replace_with, $the_media->code);
                    $replace_with = 'height="' . $the_media->height . '"';
                    $the_media->code = preg_replace('#height="[0-9]+"#', $replace_with, $the_media->code);
                    $aheight = $the_media->height;
                    $awidth = $the_media->width;
                }
            }
        }
        $parts = explode(".", @$the_media->local);
        $extension = strtolower($parts[count($parts) - 1]);
        if (@$the_media->type == 'video' || @$the_media->type == 'audio') {
            if ($the_media->type == 'video' && $extension == "avi") {
                $media = '<object width="' . $vwidth . '" height="' . $vheight . '" type="application/x-oleobject" codebase="http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=5,1,52,701" classid="CLSID:22d6f312-b0f6-11d0-94ab-0080c74c7e95" id="MediaPlayer1">
<param value="' . JURI::root() . $configs->videoin . "/" . $the_media->local . '" name="fileName">
<param value="true" name="animationatStart">
<param value="true" name="transparentatStart">
<param value="true" name="autoStart">
<param value="true" name="showControls">
<param value="10" name="Volume">
<param value="false" name="autoplay">
<embed width="' . $vwidth . '" height="' . $vheight . '" type="video/x-msvideo" src="' . JURI::root() . $configs->videoin . "/" . $the_media->local . '" name="plugin">
</object>';
            } elseif ($no_plugin_for_code == 0) {
                $helper = new guruHelper();
                $media = $helper->create_media_using_plugin($the_media, $configs, $awidth, $aheight, $vwidth, $vheight);
            }
        }
        if (@$the_media->type == 'docs') {
            $the_base_link = JURI::root();
            $media = JText::_('GURU_NO_PREVIEW');
            //$media = JText::_("GURU_TASKS");
            if ($the_media->source == 'local' && (substr($the_media->local, strlen($the_media->local) - 3, 3) == 'txt' || substr($the_media->local, strlen($the_media->local) - 3, 3) == 'pdf') && $the_media->width > 1) {
                $media = '<div class="contentpane">
							<iframe id="blockrandom"
								name="iframe"
								src="' . $the_base_link . '/' . $configs->docsin . '/' . $the_media->local . '"
								width="' . $the_media->width . '"
								height="' . $the_media->height . '"
								scrolling="auto"
								align="top"
								frameborder="2"
								class="wrapper">
								This option will not work correctly. Unfortunately, your browser does not support inline frames.</iframe>
							</div>';
                return stripslashes($media . '<div  style="text-align:center"><i>' . $the_media->instructions . '</i></div>');
            } elseif (@$the_media->source == 'url' && (substr($the_media->url, strlen($the_media->url) - 3, 3) == 'txt' || substr($the_media->url, strlen($the_media->url) - 3, 3) == 'pdf') && $the_media->width > 1) {
                $media = '<div class="contentpane">
							<iframe id="blockrandom"
								name="iframe"
								src="' . $the_media->url . '"
								width="' . $the_media->width . '"
								height="' . $the_media->height . '"
								scrolling="auto"
								align="top"
								frameborder="2"
								class="wrapper">
								This option will not work correctly. Unfortunately, your browser does not support inline frames.</iframe>
							</div>';
                return stripslashes($media . '<div  style="text-align:center"><i>' . $the_media->instructions . '</i></div>');
            }
            if (@$the_media->source == 'local' && $the_media->width == 1) {
                $media = '<br /><a href="' . $the_base_link . $configs->docsin . '/' . $the_media->local . '" target="_blank">' . $the_media->name . '</a>';
                return stripslashes($media . '<div  style="text-align:center"><i>' . $the_media->instructions . '</i></div>');
            }
            if ($the_media->source == 'url' && $the_media->width == 0) {
                $media = '<div class="contentpane">
							<iframe id="blockrandom"
								name="iframe"
								src="' . $the_media->url . '"
								width="100%"
								height="600"
								scrolling="auto"
								align="top"
								frameborder="2"
								class="wrapper">
								This option will not work correctly. Unfortunately, your browser does not support inline frames.</iframe>
							</div>';
            }
            if (@$the_media->source == 'url' && $the_media->width == 1) {
                $media = '<a href="' . $the_media->url . '" target="_blank">' . $the_media->name . '</a>';
            }
        }
        if (@$the_media->type == 'url') {
            $src = $the_media->url;
            $media = '<a href="' . $src . '" target="_blank">' . $src . '</a>';
        }
        if (@$the_media->type == 'Article') {
            $media = self::getArticleById($the_media->code);
        }
        if (@$the_media->type == 'image') {
            $img_size = @getimagesize(JPATH_SITE . DS . $configs->imagesin . DS . 'media' . DS . 'thumbs' . $the_media->local);
            //echo "~~~~".var_dump($img_size)."~~~~";
            $img_width = $img_size[0];
            $img_height = $img_size[1];
            if ($img_width > 0 && $img_height > 0) {
                $thumb_width = 0;
                $thumb_height = 0;
                if ($the_media->width > 0) {
                    $thumb_width = $the_media->width;
                    $thumb_height = $img_height / ($img_width / $the_media->width);
                } elseif ($the_media->height > 0) {
                    $thumb_height = $the_media->height;
                    $thumb_width = $img_width / ($img_height / $the_media->height);
                } else {
                    $thumb_height = 200;
                    $thumb_width = $img_width / ($img_height / 200);
                }
                $media = '<img width="' . $thumb_width . '" height="' . $thumb_height . '" src="' . JURI::root() . DS . $configs->imagesin . '/media/thumbs' . $the_media->local . '" />';
            }
            if (!isset($media)) {
                $media = NULL;
            }
        }
        if (@$the_media->type == 'quiz') {
            $document = JFactory::getDocument();
            $document->addStyleSheet(JURI::root() . "components/com_guru/css/quiz.css");
            include_once JPATH_SITE . DS . "components" . DS . "com_guru" . DS . "models" . DS . "gurutask.php";
            $quiz_content = guruModelguruTask::parse_media(intval($the_media->id), 12);
            $media = $quiz_content;
        }
        if (@$the_media->type == "file") {
            $media = '<a target="_blank" href="' . JURI::ROOT() . $configs->filesin . '/' . $the_media->local . '">' . $the_media->name . '</a><br/><br/>' . $the_media->instructions;
        }
        return stripslashes($media);
    }
コード例 #3
0
ファイル: loginform.php プロジェクト: JozefAB/neoacu
# Websites: http://www.ijoomla.com

# Technical Support:  Forum - http://www.ijoomla.com.com/forum/index/

-------------------------------------------------------------------------*/
defined('_JEXEC') or die('Restricted access');
$document = JFactory::getDocument();
include JPATH_SITE . DS . 'components' . DS . 'com_guru' . DS . 'models' . DS . 'gurutask.php';
global $Itemid;
?>
<script type="text/javascript" language="javascript">
	document.body.className = document.body.className.replace("modal", "");
</script>
<?php 
$guruModelguruTask = new guruModelguruTask();
$db = JFactory::getDBO();
$my = JFactory::getUser();
$user_id = $my->id;
$course_id = intval(JRequest::getVar("course_id", ""));
$chb_free_courses = $guruModelguruTask->getDataChbAccessCourses($course_id);
$step_access_courses = $guruModelguruTask->getDataStepAccessCourses($course_id);
$tmpl = JRequest::getVar("tmpl", "");
if ($tmpl == "component") {
    echo '<link rel="stylesheet" href="' . JURI::root() . "components/com_guru/css/uikit.almost-flat.min.css" . '"/>';
}
if ($user_id == 0) {
    // if you are logout
    //desktop view
    ?>
コード例 #4
0
ファイル: guruTasks.php プロジェクト: JozefAB/qk
 function showCertificateFr()
 {
     $db = JFactory::getDBO();
     $user = JFactory::getUser();
     $user_id = $user->id;
     $pid = JRequest::getVar("course_id");
     $lesson_id = JRequest::getVar("lesson_id");
     $scores_avg_quizzes = guruModelguruTask::getAvgScoresQ($user_id, $pid);
     $sql = "SELECT `completed` from #__guru_viewed_lesson WHERE `user_id` =" . intval($user_id) . " and pid=" . intval($pid);
     $db->setQuery($sql);
     $db->query();
     $completed_course = $db->loadResult();
     $sql = "SELECT certificate_term  FROM #__guru_program\r\n\t\t\t\tWHERE id =" . intval($pid);
     $db->setQuery($sql);
     $db->query();
     $course_certificate_term = $db->loadResult();
     $sql = "select avg_certc from #__guru_program where id=" . $pid;
     $db->setQuery($sql);
     $db->query();
     $avg_certif = $db->loadResult();
     $sql = "SELECT media_id FROM #__guru_mediarel WHERE type='scr_m' and type_id=" . intval($lesson_id);
     $db->setQuery($sql);
     $result = $db->loadResult();
     $sql = "SELECT max_score FROM #__guru_quiz WHERE id=" . intval($result);
     $db->setQuery($sql);
     $result_maxs = $db->loadResult();
     $sql = "SELECT id, score_quiz, time_quiz_taken_per_user  FROM #__guru_quiz_taken WHERE user_id=" . intval($user_id) . " and quiz_id=" . intval($result) . " and pid=" . $pid . " ORDER BY id DESC LIMIT 0,1";
     $db->setQuery($sql);
     $result_q = $db->loadObject();
     $first = explode("|", @$result_q->score_quiz);
     @($res = intval($first[0] / $first[1] * 100));
     if ($course_certificate_term == 2 && ($completed_course == true || $completed_course == 1)) {
         $this->InsertMyCertificateDetails2($pid);
         echo "yes";
     } elseif ($course_certificate_term == 3 && isset($result_maxs) && $res >= intval($result_maxs)) {
         $this->InsertMyCertificateDetails2($pid);
         echo "yes";
     } elseif ($course_certificate_term == 4 && $scores_avg_quizzes >= intval($avg_certif)) {
         $this->InsertMyCertificateDetails2($pid);
         echo "yes";
     } elseif ($course_certificate_term == 5 && ($completed_course == true || $completed_course == 1) && isset($result_maxs) && $res >= intval($result_maxs)) {
         $this->InsertMyCertificateDetails2($pid);
         echo "yes";
     } elseif ($course_certificate_term == 6 && ($completed_course == true || $completed_course == 1) && isset($scores_avg_quizzes) && $scores_avg_quizzes >= intval($avg_certif)) {
         $this->InsertMyCertificateDetails2($pid);
         echo "yes";
     } else {
         echo "no";
     }
     die;
 }
コード例 #5
0
ファイル: certificatefront.php プロジェクト: JozefAB/neoacu
# author    iJoomla
# copyright Copyright (C) 2013 ijoomla.com. All Rights Reserved.
# @license - http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL
# Websites: http://www.ijoomla.com
# Technical Support:  Forum - http://www.ijoomla.com.com/forum/index/
-------------------------------------------------------------------------*/
defined('_JEXEC') or die('Restricted access');
JHTML::_('behavior.modal', 'a.modal');
$document = JFactory::getDocument();
$document->setTitle(JText::_("GURU_MYCERTIFICATES"));
$db = JFactory::getDBO();
$config = JFactory::getConfig();
$course_id = JRequest::getVar("ci");
$user = JFactory::getUser();
$user_id = $user->id;
$guruModelguruTask = new guruModelguruTask();
$sql = "SELECT `name` from #__guru_program WHERE `id` =" . intval($course_id);
$db->setQuery($sql);
$db->query();
$result = $db->loadResult();
$imagename = "SELECT * FROM #__guru_certificates WHERE id=1";
$db->setQuery($imagename);
$db->query();
$imagename = $db->loadAssocList();
$authorname = "SELECT name from #__users where id IN (SELECT author_id FROM #__guru_mycertificates WHERE user_id = " . intval($user_id) . " AND course_id =" . intval($course_id) . " )";
$db->setQuery($authorname);
$db->query();
$authorname = $db->loadColumn();
$authorname = implode(", ", $authorname);
$background_color = "";
if ($imagename[0]["design_background"] != "") {
コード例 #6
0
ファイル: ajaxAddMedia.php プロジェクト: JozefAB/neoacu
function parse_quiz($id, $type)
{
    $database = JFactory::getDBO();
    $q = "SELECT * FROM #__guru_config WHERE id = '1' ";
    $database->setQuery($q);
    $configs = $database->loadObject();
    if ($type == "quiz") {
        $q = "SELECT * FROM #__guru_quiz WHERE id = " . $id;
        $database->setQuery($q);
        $result = $database->loadObject();
        $the_media = $result;
        $the_media->type = "quiz";
    } else {
        $q = "SELECT * FROM #__guru_media WHERE id = " . $id;
        $database->setQuery($q);
        $result = $database->loadObject();
        $the_media = $result;
    }
    if ($the_media->type == 'text') {
        $media = $the_media->code;
    }
    if ($the_media->type == 'Article') {
        $media = $the_media->code;
    }
    if ($the_media->type == 'docs') {
        $the_base_link = JURI::root();
        $media = 'The selected element is a text file that can\'t have a preview';
        if ($the_media->source == 'local' && (substr($the_media->local, strlen($the_media->local) - 3, 3) == 'txt' || substr($the_media->local, strlen($the_media->local) - 3, 3) == 'pdf') && $the_media->width > 1) {
            $media = '<div class="contentpane">
					<iframe id="blockrandom"
						name="iframe"
						src="' . $the_base_link . '/' . $configs->docsin . '/' . $the_media->local . '"
						width="100%"
						height="' . $the_media->height . '"
						scrolling="auto"
						align="top"
						frameborder="2"
						class="wrapper">
						This option will not work correctly. Unfortunately, your browser does not support inline frames.</iframe>
					</div>';
        } elseif ($the_media->source == 'url' && (substr($the_media->url, strlen($the_media->url) - 3, 3) == 'txt' || substr($the_media->url, strlen($the_media->url) - 3, 3) == 'pdf') && $the_media->width > 1) {
            $media = '<div class="contentpane">
					<iframe id="blockrandom"
						name="iframe"
						src="' . $the_media->url . '"
						width="100%"
						height="' . $the_media->height . '"
						scrolling="auto"
						align="top"
						frameborder="2"
						class="wrapper">
						This option will not work correctly. Unfortunately, your browser does not support inline frames.</iframe>
					</div>';
        }
        if ($the_media->source == 'local' && $the_media->width == 1) {
            $media = '<br /><a href="' . $the_base_link . '/' . $configs->docsin . '/' . $the_media->local . '" target="_blank">' . $the_media->name . '</a>';
        }
        if ($the_media->source == 'url' && $the_media->width == 0) {
            $media = '<div class="contentpane">
						<iframe id="blockrandom"
						name="iframe"
						src="' . $the_media->url . '"
						width="100%"
						height="600"
						scrolling="auto"
						align="top"
						frameborder="2"
						class="wrapper">
						This option will not work correctly. Unfortunately, your browser does not support inline frames.</iframe>
					</div>';
        }
        if ($the_media->source == 'url' && $the_media->width == 1) {
            $media = '<a href="' . $the_media->url . '" target="_blank">' . $the_media->name . '</a>';
        }
    }
    if ($the_media->type == 'quiz') {
        $the_media->source = $the_media->id;
        include_once JPATH_SITE . DS . "components" . DS . "com_guru" . DS . "models" . DS . "gurutask.php";
        $quiz_content = guruModelguruTask::parse_media(intval($the_media->id), 12);
        $media = $quiz_content;
    }
    return $media;
}
コード例 #7
0
ファイル: tabs.php プロジェクト: JozefAB/qk
function tab1($program, $author, $program_content, $exercise, $requirements, $course, $config, $course_config)
{
    $prev_id = 0;
    $st_psgpage = json_decode($config->st_psgpage);
    $psgpage = json_decode($config->psgpage);
    $course_level = $psgpage->course_level;
    $buy_class = $st_psgpage->course_other_button;
    $buy_background = $st_psgpage->course_other_background;
    $my = JFactory::getUser();
    $course_id = intval(JRequest::getVar("cid", 0));
    $show_buy_button = $course_config->course_buy_button;
    $buy_button_location = $course_config->course_buy_button_location;
    $user_id = $my->id;
    $user->id = $my->id;
    $lesson_size = $config->lesson_window_size;
    $lesson_size = explode("x", $lesson_size);
    $lesson_height = $lesson_size["0"];
    $lesson_width = $lesson_size["1"];
    $style_grayout = "color:#999999;";
    $db = JFactory::getDBO();
    $sql = "select name, alias from #__guru_program where id=" . intval($course_id);
    $db->setQuery($sql);
    $db->query();
    $result = $db->loadAssocList();
    $alias = $result["0"]["alias"] == "" ? JFilterOutput::stringURLSafe($result["0"]["name"]) : $result["0"]["alias"];
    $sql = "SELECT  count(*) FROM `#__guru_buy_courses` where `order_id` >='0' and `userid`=" . intval($user_id) . " and course_id=" . intval($course_id);
    $db->setQuery($sql);
    $db->query();
    $result = $db->loadResult();
    if ($result > 0) {
        $not_show = true;
    } else {
        $not_show = false;
    }
    $sql = "SELECT chb_free_courses, step_access_courses, selected_course  FROM `#__guru_program` where id = " . intval($course_id);
    $db->setQuery($sql);
    $db->query();
    $result = $db->loadAssocList();
    $chb_free_courses = $result["0"]["chb_free_courses"];
    $step_access_courses = $result["0"]["step_access_courses"];
    $selected_course = $result["0"]["selected_course"];
    if (buySelectedCourse($selected_course)) {
        $hascourse = true;
    }
    $coursetype_details = guruModelguruProgram::getCourseTypeDetails($course_id);
    if ($course_level == 1) {
        $display_levelimg = "none";
    } else {
        $display_levelimg = "inherit-inline";
    }
    ?>
    
<div><!-- start main div-->
    <div class="tab_active_cont course_view_tablecontents">
            <?php 
    if ($deviceType != "phone") {
        // if computer /tablet
        if ($show_buy_button == "0" && ($buy_button_location == "0" || $buy_button_location == "2")) {
            ?>
        <div class="call_2_action buy_now">
            <div>
               <?php 
            $button = createButton($buy_background, $course_id, $buy_class, $program, $program_content);
            // display message like "Get access to all the tutorials in the course now! and Buy Now button"
            if (is_array($button)) {
                echo $button["0"];
            } else {
                echo $button;
            }
            ?>
            </div>
        </div>
            <?php 
        }
        ?>
    <div class="col_titles t_row">
        <div><!-- start td for show/close all button-->
            <?php 
        $show_all_cloase_all = isset($course_config->show_all_cloase_all) ? $course_config->show_all_cloase_all : "0";
        if ($user_id > 0) {
            $col_width = 9;
        } else {
            $col_width = 8;
        }
        if ($user_id > 0 && $coursetype_details[0]["course_type"] != 0 && $coursetype_details[0]["lessons_show"] == 1 && $coursetype_details[0]["lesson_release"] > 0 && $not_show === TRUE) {
            $col_width = 7;
        }
        ?>
            <div class="col_title g_cell span<?php 
        echo $col_width;
        ?>
">
            <?php 
        if ($show_all_cloase_all != 1) {
            ?>
                    <input type="button" class="btn btn-primary show_sub" value="+ <?php 
            echo JText::_("GURU_SHOW_ALL_BUTTON");
            ?>
"/><!--show all button -->
                    <input type="button" class="btn btn-primary close_sub" value="- <?php 
            echo JText::_("GURU_CLOSE_ALL_BUTTON");
            ?>
"/><!--close all button -->
                <?php 
        } else {
            echo '&nbsp;';
        }
        ?>
            </div>
            
            <div class="col_title g_cell span2">
                <?php 
        echo JText::_("GURU_VIEWED");
        ?>
            </div>
            <div class="col_title g_cell span1">
                    <?php 
        if ($course_level == 0) {
            echo JText::_("GURU_LEVEL");
        }
        ?>
<!--Level -->
            </div>
            <?php 
        if ($user_id > 0 && $coursetype_details[0]["course_type"] != 0 && $coursetype_details[0]["lessons_show"] == 1 && $coursetype_details[0]["lesson_release"] > 0 && $not_show === TRUE) {
            ?>
                <div class="col_title g_cell span2">
                    <?php 
            echo JText::_("GURU_AVAILABILITY");
            ?>
                </div>
                <?php 
        }
        ?>
        </div><!-- end td for show/close all button-->
    </div>
        <?php 
        // start calculation for one lesson per (option in admin)
        if ($user_id > 0) {
            $db = JFactory::getDBO();
            $sql = "select DATE_FORMAT(buy_date,'%Y-%m-%d %H:%i:%s') from #__guru_buy_courses where course_id=" . intval($course_id) . " and userid =" . $user_id;
            $db->setQuery($sql);
            $db->query();
            $date_enrolled = $db->loadResult();
            $date_enrolled = strtotime($date_enrolled);
        }
        if (isset($date_enrolled)) {
            $start_relaese_date1 = $coursetype_details[0]["start_release"];
            $start_relaese_date = strtotime($start_relaese_date1);
            $start_date = $date_enrolled;
            $jnow = JFactory::getDate();
            $date9 = $jnow->toSQL();
            $date_9 = date("Y-m-d", strtotime($date9));
            $date9 = strtotime($date9);
            //$interval = $start_relaese_date->diff($date9);
            $interval = abs($date9 - $start_date);
            $dif_days = floor($interval / (60 * 60 * 24));
            $dif_week = floor($interval / (60 * 60 * 24 * 7));
            $dif_month = floor($interval / (60 * 60 * 24 * 30));
            if ($coursetype_details[0]["course_type"] == 1) {
                if ($coursetype_details[0]["lesson_release"] == 1) {
                    $diff_start = $dif_days + 1;
                    $diff_date = $dif_days + 1;
                } elseif ($coursetype_details[0]["lesson_release"] == 2) {
                    $dif_days_enrolled = $dif_days_enrolled / 7;
                    $diff_start = $dif_week + 1;
                    $diff_date = $dif_week + 1;
                } elseif ($coursetype_details[0]["lesson_release"] == 3) {
                    $dif_days_enrolled = $dif_days_enrolled / 30;
                    $diff_start = $dif_month + 1;
                    $diff_date = $dif_month + 1;
                }
            }
        }
        $step_less = $diff_start;
        // end calculation for one lesson per (option in admin)
        foreach ($program_content as $key => $array) {
            $subcat = guruModelguruProgram::getSubCategory($array['id']);
            ?>
        <div class="chapter_wrap t_row">
        <div>
            <div>
                <div class="chapter_title clearfix"><!-- start module name-->
        
                    <div>
        
                        <div class="day clearfix span12" onClick="javascript:show_hidde('<?php 
            echo $array['id'];
            ?>
','<?php 
            echo JUri::root() . "components/com_guru/images/";
            ?>
')">
        
                            <img id='img_<?php 
            echo $array['id'];
            ?>
' src='<?php 
            echo JUri::root() . "components/com_guru/images/arrow-right.gif";
            ?>
' />
        
                            <?php 
            echo $array['title'];
            ?>
        
        
                        </div>
        
                    </div>
        
                </div><!-- end module name-->
            <?php 
            if (count($subcat) > 0) {
                ?>
                            <div class="lessons_wrap">                          
                                <div id='td_<?php 
                echo $array['id'];
                ?>
'>
                                    <div id='table_<?php 
                echo $array['id'];
                ?>
' class="subcat">
                                        <ul class="thumb">
                     <?php 
            }
            foreach ($subcat as $poz => $sub_cat) {
                switch ($sub_cat['difficultylevel']) {
                    case "easy":
                        $imgLevel = "beginner_level.png";
                        break;
                    case "medium":
                        $imgLevel = "intermediate_level.png";
                        break;
                    case "hard":
                        $imgLevel = "advanced_level.png";
                        break;
                }
                if ($user->id > 0 && $sub_cat['step_access'] != 2 || $sub_cat['step_access'] == 2) {
                    $style = " class='s_underline' ";
                    $gray_style = " class='s_underline' ";
                } else {
                    $style = " class='s_no_underline'";
                    $gray_style = " class= 's_no_underline' ";
                }
                if ($sub_cat['chb_free_courses'] == 1) {
                    if (isset($sub_cat['step_access_courses']) && $sub_cat['step_access_courses'] == 2) {
                        $style = " class='s_underline' ";
                        $gray_style = " class='s_underline'";
                    }
                    if ($user->id <= 0) {
                        if (isset($sub_cat['step_access_courses']) && $sub_cat['step_access_courses'] == 1) {
                            $style = " class='s_no_underline'";
                            $gray_style = " class='s_no_underline'  ";
                        }
                        if (isset($sub_cat['step_access_courses']) && $sub_cat['step_access_courses'] == 0 && $sub_cat['selected_course'] == -1) {
                            $style = " class='s_no_underline'";
                            $gray_style = " class='s_no_underline' ";
                        }
                        if (isset($sub_cat['step_access_courses']) && $sub_cat['step_access_courses'] == 0 && $sub_cat['selected_course'] != -1) {
                            $style = " class='s_no_underline'";
                            $gray_style = " class='s_no_underline' ";
                        }
                    } else {
                        if (isset($sub_cat['step_access_courses']) && $sub_cat['step_access_courses'] == 0 && $sub_cat['selected_course'] == -1 && $not_show == FALSE) {
                            $style = " class='s_no_underline'";
                            $gray_style = " class='s_no_underline' ";
                        }
                        if (isset($sub_cat['step_access_courses']) && $sub_cat['step_access_courses'] == 0 && $sub_cat['selected_course'] != -1 && $not_show == FALSE) {
                            $style = " class='s_no_underline'";
                            $gray_style = " class='s_no_underline' ";
                        }
                        if (isset($sub_cat['step_access_courses']) && $sub_cat['step_access_courses'] == 1 && $not_show == FALSE) {
                            $style = " class='s_no_underline'";
                            $gray_style = " class='s_no_underline' ";
                        }
                    }
                }
                if ($user_id == 0 && $sub_cat["chb_free_courses"] == 1 && $sub_cat["step_access_courses"] == 1) {
                    ?>
                    <li class="g_row">
                      <div class="col_title g_cell span9 lesson_name"><a href="<?php 
                    echo JURI::root();
                    ?>
index.php?option=com_guru&view=guruProfile&task=loginform&course_id=<?php 
                    echo intval($course_id);
                    ?>
-<?php 
                    echo $alias . $action;
                    ?>
&returnpage=guruprograms&graybox=true&tmpl=component" onclick="openMyModal('<?php 
                    echo $lesson_height;
                    ?>
','<?php 
                    echo $lesson_width;
                    ?>
','<?php 
                    echo JURI::root();
                    ?>
index.php?option=com_guru&view=guruProfile&task=loginform&course_id=<?php 
                    echo intval($course_id);
                    ?>
-<?php 
                    echo $alias . $action;
                    ?>
&returnpage=guruprograms&graybox=true&tmpl=component'); return false;"><?php 
                    echo $sub_cat['name'];
                    ?>
</a></div>
                    <?php 
                    $user_id = $my->id;
                    $display = "hidden";
                    if ($user_id > 0) {
                        $lesson_viewed = guruModelguruTask::getViewLesson($sub_cat['id']);
                        if ($coursetype_details[0]["lessons_show"] == '2' && $diff_date > $diff_start) {
                            $display = "hidden";
                        } else {
                            if (isset($lesson_viewed) && $lesson_viewed === TRUE) {
                                $display = "inherit";
                            }
                        }
                    }
                    ?>
                    <div id="viewed-<?php 
                    echo $sub_cat['id'];
                    ?>
" style="visibility:<?php 
                    echo $display;
                    ?>
" class="g_cell span2 viewed">
                        <i class="fa fa-eye"></i>
                    </div>
                    <?php 
                    if ($course_level == 0) {
                        ?>
                        <div class="g_cell span1 level">
                            <img style="background-color:transparent;" src="<?php 
                        echo JURI::root() . "components/com_guru/images/" . $imgLevel;
                        ?>
" />
                        </div>
                        <?php 
                    }
                    ?>
                </li>
                <?php 
                } elseif ($sub_cat["chb_free_courses"] == 0 && $user_id == 0 && accessToLesson($sub_cat) && $config->open_target == 0) {
                    ?>
                 <li class="g_row">
                     
                    <div class="col_title g_cell span8 lesson_name">
                        <a href="<?php 
                    echo JRoute::_("index.php?option=com_guru&view=gurutasks&catid=" . $program->catid . "&module=" . $array['id'] . "-" . $array['alias'] . "&cid=" . $sub_cat['id'] . "-" . $sub_cat['alias']);
                    ?>
"><span <?php 
                    echo $style;
                    ?>
 ><?php 
                    echo $sub_cat['name'];
                    ?>
</span></a></div>
                    <?php 
                    $user_id = $my->id;
                    $display = "hidden";
                    if ($user_id > 0) {
                        $lesson_viewed = guruModelguruTask::getViewLesson($sub_cat['id']);
                        if ($coursetype_details[0]["lessons_show"] == '2' && $diff_date > $diff_start) {
                            $display = "hidden";
                        } else {
                            if (isset($lesson_viewed) && $lesson_viewed === TRUE) {
                                $display = "inherit";
                            }
                        }
                    }
                    ?>
                    <div style="visibility:<?php 
                    echo $display;
                    ?>
;" class="g_cell pull-left span2 viewed">
                            
                                                    <i class="icon-eye-open"></i>
                            
                                    </div>
                    <?php 
                    if ($course_level == 0) {
                        ?>
                        <div class="g_cell pull-left span1 level">
                            <img style="background-color:transparent;" src="<?php 
                        echo JURI::root() . "components/com_guru/images/" . $imgLevel;
                        ?>
" />
                       </div>
                        <?php 
                    }
                    ?>
                </li>       
                <?php 
                } elseif ($user_id != 0 && isCustomer() && $config->open_target == 0 && ($coursetype_details[0]["course_type"] == 1 && $diff_date > 0 || $coursetype_details[0]["course_type"] == 0 || $coursetype_details[0]["course_type"] == 1 && $coursetype_details[0]["lesson_release"] == 0) || $sub_cat["chb_free_courses"] == 1 && $sub_cat["step_access_courses"] == 2) {
                    $diff_date--;
                    ?>
                 <li class="g_row">
                    <?php 
                    $span = "span9";
                    if ($diff_start > 0) {
                        $span = "span7";
                    }
                    $preview_viewd = FALSE;
                    if ($prev_id == 0) {
                        $prev_id = $sub_cat["id"];
                        $preview_viewd = TRUE;
                    } else {
                        $lesson_viewed = guruModelguruTask::getViewLesson($prev_id);
                        $prev_id = $sub_cat["id"];
                        if ($lesson_viewed) {
                            $preview_viewd = TRUE;
                        }
                    }
                    if ($coursetype_details[0]["course_type"] == 0) {
                        // non sequential
                        $preview_viewd = TRUE;
                    }
                    ?>
                    <div class="col_title g_cell <?php 
                    echo $span;
                    ?>
 lesson_name">
                        <?php 
                    if ($preview_viewd) {
                        if ($config->open_target == 0) {
                            ?>
                                    <a href="<?php 
                            echo JRoute::_("index.php?option=com_guru&view=gurutasks&catid=" . $program->catid . "&module=" . $array['id'] . "-" . $array['alias'] . "&cid=" . $sub_cat['id'] . "-" . $sub_cat['alias']);
                            ?>
">
                                        <span <?php 
                            echo $style;
                            ?>
 ><?php 
                            echo $sub_cat['name'];
                            ?>
</span>
                                    </a>
						<?php 
                        } else {
                            ?>
                                
                                    <a onclick="openMyModal('<?php 
                            echo $lesson_height;
                            ?>
','<?php 
                            echo $lesson_width;
                            ?>
','<?php 
                            echo JUri::root();
                            ?>
index.php?option=com_guru&view=gurutasks&catid=<?php 
                            echo $program->catid;
                            ?>
&module=<?php 
                            echo $array["id"];
                            ?>
-<?php 
                            echo $array["alias"];
                            ?>
&cid=<?php 
                            echo $sub_cat['id'];
                            ?>
-<?php 
                            echo $sub_cat["alias"];
                            ?>
&tmpl=component&Itemid=<?php 
                            echo $itemid;
                            ?>
'); return false; javascript:setViewed('viewed-<?php 
                            echo $sub_cat['id'];
                            ?>
', '<?php 
                            echo JUri::root() . "components/com_guru/images/icons/viewed.gif";
                            ?>
')" href="<?php 
                            echo JUri::root();
                            ?>
index.php?option=com_guru&view=gurutasks&catid=<?php 
                            echo $program->catid;
                            ?>
&module=<?php 
                            echo $array["id"];
                            ?>
-<?php 
                            echo $array["alias"];
                            ?>
&cid=<?php 
                            echo $sub_cat['id'];
                            ?>
-<?php 
                            echo $sub_cat["alias"];
                            ?>
&tmpl=component&Itemid=<?php 
                            echo $itemid;
                            ?>
&format=raw">
                                        <?php 
                            echo $sub_cat['name'];
                            ?>
                                    </a>
                        <?php 
                        }
                    } else {
                        ?>
                                <span <?php 
                        echo $style;
                        ?>
 ><?php 
                        echo $sub_cat['name'];
                        ?>
</span>
                        <?php 
                    }
                    ?>
                    </div>
                    <?php 
                    $user_id = $my->id;
                    $display = "hidden";
                    if ($user_id > 0) {
                        $lesson_viewed = guruModelguruTask::getViewLesson($sub_cat['id']);
                        if ($coursetype_details[0]["lessons_show"] == '2' && $diff_date > $diff_start) {
                            $display = "hidden";
                        } else {
                            if (isset($lesson_viewed) && $lesson_viewed === TRUE) {
                                $display = "inherit";
                            }
                        }
                    }
                    ?>
                    <div id="viewed-<?php 
                    echo $sub_cat['id'];
                    ?>
" style="visibility:<?php 
                    echo $display;
                    ?>
" class="g_cell span2 viewed">
                        <i class="fa fa-eye"></i>
                    </div>
                    <?php 
                    if ($course_level == 0) {
                        ?>
                        <div class="g_cell span1 level">
                            <img style="background-color:transparent;" src="<?php 
                        echo JURI::root() . "components/com_guru/images/" . $imgLevel;
                        ?>
" />
                       </div>
                        <?php 
                    }
                    if ($diff_start > 0) {
                        ?>
                        <div class="available_lesson g_cell span2 available"><?php 
                        echo JText::_("GURU_AVAILABLE");
                        ?>
</div>
                    <?php 
                    }
                    ?>
                </li>
                <?php 
                } elseif ($user_id != 0 && $sub_cat["chb_free_courses"] == 1 && $sub_cat["step_access_courses"] == 1 && $not_show === FALSE && ($coursetype_details[0]["course_type"] == 1 && $diff_date > 0 || $coursetype_details[0]["course_type"] == 0 || $coursetype_details[0]["course_type"] == 1 && $coursetype_details[0]["lesson_release"] == 0)) {
                    $diff_date--;
                    ?>
                <li class="g_row">
                     <div class="col_title g_cell span9 lesson_name"><a href="<?php 
                    echo JURI::root();
                    ?>
index.php?option=com_guru&view=guruProfile&task=loginform&course_id=<?php 
                    echo intval($course_id);
                    ?>
-<?php 
                    echo $alias . $action;
                    ?>
&returnpage=guruprograms&graybox=true&tmpl=component" onclick="openMyModal('<?php 
                    echo $lesson_height;
                    ?>
','<?php 
                    echo $lesson_width;
                    ?>
','<?php 
                    echo JURI::root();
                    ?>
index.php?option=com_guru&view=guruProfile&task=loginform&course_id=<?php 
                    echo intval($course_id);
                    ?>
-<?php 
                    echo $alias . $action;
                    ?>
&returnpage=guruprograms&graybox=true&tmpl=component'); return false;"><?php 
                    echo $sub_cat['name'];
                    ?>
</a></div>
                    <?php 
                    $user_id = $my->id;
                    $display = "hidden";
                    if ($user_id > 0) {
                        $lesson_viewed = guruModelguruTask::getViewLesson($sub_cat['id']);
                        if ($coursetype_details[0]["lessons_show"] == '2' && $diff_date > $diff_start) {
                            $display = "hidden";
                        } else {
                            if (isset($lesson_viewed) && $lesson_viewed === TRUE) {
                                $display = "inherit";
                            }
                        }
                    }
                    ?>
                    <div id="viewed-<?php 
                    echo $sub_cat['id'];
                    ?>
" style="visibility:<?php 
                    echo $display;
                    ?>
" class="g_cell span2 viewed">
                        <i class="fa fa-eye"></i>
                    </div>
                    <?php 
                    if ($course_level == 0) {
                        ?>
                        <div class="g_cell span1 level">
                            <img style="background-color:transparent;" src="<?php 
                        echo JURI::root() . "components/com_guru/images/" . $imgLevel;
                        ?>
" />
                       </div>
                        <?php 
                    }
                    ?>
                </li>
                    <?php 
                } elseif ($user_id != 0 && inCustomerTable() && $sub_cat["chb_free_courses"] == 1 && $sub_cat["step_access_courses"] == 0 && $sub_cat["selected_course"] == -1 && $not_show === FALSE && hasAtLeastOneCourse() && ($coursetype_details[0]["course_type"] == 1 && $diff_date > 0 || $coursetype_details[0]["course_type"] == 0 || $coursetype_details[0]["course_type"] == 1 && $coursetype_details[0]["lesson_release"] == 0)) {
                    $diff_date--;
                    ?>
                    <li class="g_row">
                     <div class="col_title g_cell span6 lesson_name"><a href="<?php 
                    echo JURI::root();
                    ?>
index.php?option=com_guru&view=guruProfile&task=loginform&course_id=<?php 
                    echo intval($course_id);
                    ?>
-<?php 
                    echo $alias . $action;
                    ?>
&returnpage=guruprograms&graybox=true&tmpl=component" onclick="openMyModal('<?php 
                    echo $lesson_height;
                    ?>
','<?php 
                    echo $lesson_width;
                    ?>
','<?php 
                    echo JURI::root();
                    ?>
index.php?option=com_guru&view=guruProfile&task=loginform&course_id=<?php 
                    echo intval($course_id);
                    ?>
-<?php 
                    echo $alias . $action;
                    ?>
&returnpage=guruprograms&graybox=true&tmpl=component'); return false;"><?php 
                    echo $sub_cat['name'];
                    ?>
</a></div>
                    <?php 
                    $user_id = $my->id;
                    $display = "hidden";
                    if ($user_id > 0) {
                        $lesson_viewed = guruModelguruTask::getViewLesson($sub_cat['id']);
                        if ($coursetype_details[0]["lessons_show"] == '2' && $diff_date > $diff_start) {
                            $display = "hidden";
                        } else {
                            if (isset($lesson_viewed) && $lesson_viewed === TRUE) {
                                $display = "inherit";
                            }
                        }
                    }
                    ?>
                    <div id="viewed-<?php 
                    echo $sub_cat['id'];
                    ?>
" style="visibility:<?php 
                    echo $display;
                    ?>
" class="g_cell span2 viewed">
                        <i class="fa fa-eye"></i>
                    </div>
                    <?php 
                    if ($course_level == 0) {
                        ?>
                        <div class="g_cell span2 level">
                            <img style="background-color:transparent;" src="<?php 
                        echo JURI::root() . "components/com_guru/images/" . $imgLevel;
                        ?>
" />
                       </div>
                        <?php 
                    }
                    ?>
                </li>
                <?php 
                } elseif ($user_id != 0 && isCustomer() && $sub_cat["chb_free_courses"] == 1 && $sub_cat["step_access_courses"] == 0 && $not_show === FALSE && $hascourse == TRUE && ($coursetype_details[0]["course_type"] == 1 && $diff_date > 0 || $coursetype_details[0]["course_type"] == 0 || $coursetype_details[0]["course_type"] == 1 && $coursetype_details[0]["lesson_release"] == 0)) {
                    $diff_date--;
                    ?>
                    <li class="g_row">
                     <div class="col_title g_cell span6 lesson_name"><a href="<?php 
                    echo JURI::root();
                    ?>
index.php?option=com_guru&view=guruProfile&task=loginform&course_id=<?php 
                    echo intval($course_id);
                    ?>
-<?php 
                    echo $alias . $action;
                    ?>
&returnpage=guruprograms&graybox=true&tmpl=component" onclick="openMyModal('<?php 
                    echo $lesson_height;
                    ?>
','<?php 
                    echo $lesson_width;
                    ?>
','<?php 
                    echo JURI::root();
                    ?>
index.php?option=com_guru&view=guruProfile&task=loginform&course_id=<?php 
                    echo intval($course_id);
                    ?>
-<?php 
                    echo $alias . $action;
                    ?>
&returnpage=guruprograms&graybox=true&tmpl=component'); return false;"><?php 
                    echo $sub_cat['name'];
                    ?>
</a></div>
                    <?php 
                    $user_id = $my->id;
                    $display = "hidden";
                    if ($user_id > 0) {
                        $lesson_viewed = guruModelguruTask::getViewLesson($sub_cat['id']);
                        if ($coursetype_details[0]["lessons_show"] == '2' && $diff_date > $diff_start) {
                            $display = "hidden";
                        } else {
                            if (isset($lesson_viewed) && $lesson_viewed === TRUE) {
                                $display = "inherit";
                            }
                        }
                    }
                    ?>
                    <div id="viewed-<?php 
                    echo $sub_cat['id'];
                    ?>
" style="visibility:<?php 
                    echo $display;
                    ?>
" class="g_cell span2 viewed">
                        <i class="fa fa-eye"></i>
                    </div>
                    <?php 
                    if ($course_level == 0) {
                        ?>
                        <div class="g_cell span2 level">
                            <img style="background-color:transparent;" src="<?php 
                        echo JURI::root() . "components/com_guru/images/" . $imgLevel;
                        ?>
" />
                       </div>
                        <?php 
                    }
                    ?>
                </li>
                <?php 
                } elseif (!accessToLesson($sub_cat) && ($coursetype_details[0]["course_type"] == 1 && $diff_date > 0 || $coursetype_details[0]["course_type"] == 0 || $coursetype_details[0]["course_type"] == 1 && $coursetype_details[0]["lesson_release"] == 0)) {
                    $diff_date--;
                    //$lesson_height = ($lesson_height/2)+100;
                    //$lesson_width = ($lesson_width/2)+100;
                    ?>
                   <li class="g_row">
                      <div class="col_title g_cell span9 lesson_name"><a style="<?php 
                    echo $style_grayout;
                    ?>
" href="<?php 
                    echo JURI::root();
                    ?>
index.php?option=com_guru&view=guruEditplans&course_id=<?php 
                    echo intval($course_id);
                    ?>
-<?php 
                    echo $alias . $action;
                    ?>
&tmpl=component" onclick="openMyModal('<?php 
                    echo $lesson_height;
                    ?>
','<?php 
                    echo $lesson_width;
                    ?>
','<?php 
                    echo JURI::root();
                    ?>
index.php?option=com_guru&view=guruEditplans&course_id=<?php 
                    echo intval($course_id);
                    ?>
-<?php 
                    echo $alias . $action;
                    ?>
&tmpl=component'); return false;"><?php 
                    echo $sub_cat['name'];
                    ?>
</a></div>
                    <?php 
                    $user_id = $my->id;
                    $display = "hidden";
                    if ($user_id > 0) {
                        $lesson_viewed = guruModelguruTask::getViewLesson($sub_cat['id']);
                        if ($coursetype_details[0]["lessons_show"] == '2' && $diff_date > $diff_start) {
                            $display = "hidden";
                        } else {
                            if (isset($lesson_viewed) && $lesson_viewed === TRUE) {
                                $display = "inherit";
                            }
                        }
                    }
                    ?>
                    <div id="viewed-<?php 
                    echo $sub_cat['id'];
                    ?>
" style="visibility:<?php 
                    echo $display;
                    ?>
" class="g_cell span2 viewed">
                        <i class="fa fa-eye"></i>
                    </div>
                    <?php 
                    if ($course_level == 0) {
                        ?>
                        <div class="g_cell span1 level">
                            <img style="background-color:transparent;" src="<?php 
                        echo JURI::root() . "components/com_guru/images/" . $imgLevel;
                        ?>
" />
                       </div>
                        <?php 
                    }
                    if ($user_id > 0 && $coursetype_details[0]["course_type"] != 0 && $coursetype_details[0]["lessons_show"] == 1 && $coursetype_details[0]["lesson_release"] > 0 && $not_show === TRUE) {
                        if ($coursetype_details[0]["course_type"] == 1) {
                            if ($coursetype_details[0]["lesson_release"] == 1) {
                                $date_to_display = strtotime('+' . $step_less++ . ' day', $start_date);
                            } elseif ($coursetype_details[0]["lesson_release"] == 2) {
                                $date_to_display = strtotime('+' . $step_less++ . ' week', $start_date);
                            } elseif ($coursetype_details[0]["lesson_release"] == 3) {
                                $date_to_display = strtotime('+' . $step_less++ . ' month', $start_date);
                            }
                        }
                        if ($diff_start > 0) {
                            ?>
                            <div class="available_lesson g_cell span2 available"><?php 
                            echo JText::_("GURU_AVAILABLE");
                            ?>
</div>
                            <?php 
                        } else {
                            ?>
                            <div class="g_cell span2 date_available"><?php 
                            echo date('m-d-Y', $date_to_display);
                            ?>
</div>
                            <?php 
                        }
                    }
                    ?>
                </li>
                <?php 
                } elseif ($config->open_target == 0 && isCustomer() && ($coursetype_details[0]["course_type"] == 1 && $diff_date > 0 || $coursetype_details[0]["course_type"] == 0 || $coursetype_details[0]["course_type"] == 1 && $coursetype_details[0]["lesson_release"] == 0)) {
                    ?>
                 <li class="g_row">
                    <div class="col_title g_cell span9 lesson_name"><a onclick="openMyModal('<?php 
                    echo $lesson_height;
                    ?>
','<?php 
                    echo $lesson_width;
                    ?>
','<?php 
                    echo JUri::root();
                    ?>
index.php?option=com_guru&view=gurutasks&catid=<?php 
                    echo $program->catid;
                    ?>
&module=<?php 
                    echo $array["id"];
                    ?>
-<?php 
                    echo $array["alias"];
                    ?>
&cid=<?php 
                    echo $sub_cat['id'];
                    ?>
-<?php 
                    echo $sub_cat["alias"];
                    ?>
&tmpl=component&Itemid=<?php 
                    echo $itemid;
                    ?>
'); return false; javascript:setViewed('viewed-<?php 
                    echo $sub_cat['id'];
                    ?>
', '<?php 
                    echo JUri::root() . "components/com_guru/images/icons/viewed.gif";
                    ?>
')" href="<?php 
                    echo JUri::root();
                    ?>
index.php?option=com_guru&view=gurutasks&catid=<?php 
                    echo $program->catid;
                    ?>
&module=<?php 
                    echo $array["id"];
                    ?>
-<?php 
                    echo $array["alias"];
                    ?>
&cid=<?php 
                    echo $sub_cat['id'];
                    ?>
-<?php 
                    echo $sub_cat["alias"];
                    ?>
&tmpl=component&Itemid=<?php 
                    echo $itemid;
                    ?>
&format=raw"><?php 
                    echo $sub_cat['name'];
                    ?>
</a></div>
                    <?php 
                    $user_id = $my->id;
                    $display = "hidden";
                    if ($user_id > 0) {
                        $lesson_viewed = guruModelguruTask::getViewLesson($sub_cat['id']);
                        if ($coursetype_details[0]["lessons_show"] == '2' && $diff_date > $diff_start) {
                            $display = "hidden";
                        } else {
                            if (isset($lesson_viewed) && $lesson_viewed === TRUE) {
                                $display = "inherit";
                            }
                        }
                    }
                    ?>
                    <div style="visibility:<?php 
                    echo $display;
                    ?>
;" class="g_cell pull-left span2 viewed">
                            
                                                    <i class="icon-eye-open"></i>
                            
                                    </div>
                    <?php 
                    if ($course_level == 0) {
                        ?>
                        <div class="g_cell span1 pull-left level">
                            <img style="background-color:transparent;" src="<?php 
                        echo JURI::root() . "components/com_guru/images/" . $imgLevel;
                        ?>
" />
                       </div>
                        <?php 
                    }
                    ?>
                </li>       
                <?php 
                } elseif ($config->open_target == 0 && !isCustomer() && ($coursetype_details[0]["course_type"] == 1 && $diff_date > 0 || $coursetype_details[0]["course_type"] == 0 || $coursetype_details[0]["course_type"] == 1 && $coursetype_details[0]["lesson_release"] == 0)) {
                    ?>
                 <li class="g_row">
                    <div class="col_title g_cell span9 lesson_name"><a href="<?php 
                    echo JURI::root();
                    ?>
index.php?option=com_guru&view=guruEditplans&course_id=<?php 
                    echo intval($course_id);
                    ?>
-<?php 
                    echo $alias . $action;
                    ?>
&tmpl=component" onclick="openMyModal('<?php 
                    echo $lesson_height;
                    ?>
','<?php 
                    echo $lesson_width;
                    ?>
','<?php 
                    echo JURI::root();
                    ?>
index.php?option=com_guru&view=guruEditplans&course_id=<?php 
                    echo intval($course_id);
                    ?>
-<?php 
                    echo $alias . $action;
                    ?>
&tmpl=component'); return false;"><?php 
                    echo $sub_cat['name'];
                    ?>
</a></div>
                    <?php 
                    $user_id = $my->id;
                    $display = "hidden";
                    if ($user_id > 0) {
                        $lesson_viewed = guruModelguruTask::getViewLesson($sub_cat['id']);
                        if ($coursetype_details[0]["lessons_show"] == '2' && $diff_date > $diff_start) {
                            $display = "hidden";
                        } else {
                            if (isset($lesson_viewed) && $lesson_viewed === TRUE) {
                                $display = "inherit";
                            }
                        }
                    }
                    ?>
                    <div style="visibility:<?php 
                    echo $display;
                    ?>
;" class="g_cell pull-left span2 viewed">
                            
                                                    <i class="icon-eye-open"></i>
                            
                                    </div>
                    <?php 
                    if ($course_level == 0) {
                        ?>
                        <div class="g_cell span1 pull-left level">
                            <img style="background-color:transparent;" src="<?php 
                        echo JURI::root() . "components/com_guru/images/" . $imgLevel;
                        ?>
" />
                       </div>
                        <?php 
                    }
                    ?>
                </li>       
                <?php 
                } elseif ($config->open_target == 1 && ($coursetype_details[0]["course_type"] == 1 && $diff_date > 0 || $coursetype_details[0]["course_type"] == 0 || $coursetype_details[0]["course_type"] == 1 && $coursetype_details[0]["lesson_release"] == 0)) {
                    $diff_date--;
                    if ($user_id == 0) {
                        $span_lesson = 'span8';
                    } else {
                        $span_lesson = 'span9';
                    }
                    if ($diff_start > 0) {
                        $span_lesson = 'span7';
                    }
                    $preview_viewd = FALSE;
                    if ($prev_id == 0) {
                        $prev_id = $sub_cat["id"];
                        $preview_viewd = TRUE;
                    } else {
                        $lesson_viewed = guruModelguruTask::getViewLesson($prev_id);
                        $prev_id = $sub_cat["id"];
                        if ($lesson_viewed) {
                            $preview_viewd = TRUE;
                        }
                    }
                    if ($coursetype_details[0]["course_type"] == 0) {
                        // non sequential
                        $preview_viewd = TRUE;
                    }
                    ?>
                <li class="g_row">
                   <div class="col_title g_cell <?php 
                    echo $span_lesson;
                    ?>
 lesson_name">
                        <?php 
                    if ($preview_viewd) {
                        ?>
                                <a onclick="openMyModal('<?php 
                        echo $lesson_height;
                        ?>
','<?php 
                        echo $lesson_width;
                        ?>
','<?php 
                        echo JUri::root();
                        ?>
index.php?option=com_guru&view=gurutasks&catid=<?php 
                        echo $program->catid;
                        ?>
&module=<?php 
                        echo $array["id"];
                        ?>
-<?php 
                        echo $array["alias"];
                        ?>
&cid=<?php 
                        echo $sub_cat['id'];
                        ?>
-<?php 
                        echo $sub_cat["alias"];
                        ?>
&tmpl=component&Itemid=<?php 
                        echo $itemid;
                        ?>
'); return false; javascript:setViewed('viewed-<?php 
                        echo $sub_cat['id'];
                        ?>
', '<?php 
                        echo JUri::root() . "components/com_guru/images/icons/viewed.gif";
                        ?>
')" href="<?php 
                        echo JUri::root();
                        ?>
index.php?option=com_guru&view=gurutasks&catid=<?php 
                        echo $program->catid;
                        ?>
&module=<?php 
                        echo $array["id"];
                        ?>
-<?php 
                        echo $array["alias"];
                        ?>
&cid=<?php 
                        echo $sub_cat['id'];
                        ?>
-<?php 
                        echo $sub_cat["alias"];
                        ?>
&tmpl=component&Itemid=<?php 
                        echo $itemid;
                        ?>
&format=raw">
                                    <?php 
                        echo $sub_cat['name'];
                        ?>
                                </a>
                        <?php 
                    } else {
                        ?>
                                <?php 
                        echo $sub_cat['name'];
                        ?>
                        <?php 
                    }
                    ?>
                    </div>
                <?php 
                    $user_id = $my->id;
                    $display = "hidden";
                    if ($user_id > 0) {
                        $lesson_viewed = guruModelguruTask::getViewLesson($sub_cat['id']);
                        if ($coursetype_details[0]["lessons_show"] == '2' && $diff_date > $diff_start) {
                            $display = "hidden";
                        } else {
                            if (isset($lesson_viewed) && $lesson_viewed === TRUE) {
                                $display = "visible";
                            }
                        }
                    }
                    $viewed_span = "span1";
                    if ($diff_start > 0) {
                        $viewed_span = "span2";
                    }
                    ?>
                        
                    <div id="viewed-<?php 
                    echo $sub_cat['id'];
                    ?>
" style="visibility:<?php 
                    echo $display;
                    ?>
" class="g_cell <?php 
                    echo $viewed_span;
                    ?>
 viewed">
                        <i class="fa fa-eye"></i>
                    </div>
                    <?php 
                    if ($course_level == 0) {
                        ?>
                        <div class="g_cell span1 level">
                            <img style="background-color:transparent;" src="<?php 
                        echo JURI::root() . "components/com_guru/images/" . $imgLevel;
                        ?>
" />
                        </div>
                        <?php 
                    }
                    ?>
                    <?php 
                    if ($user_id > 0 && $coursetype_details[0]["course_type"] != 0 && $coursetype_details[0]["lessons_show"] == 1 && $coursetype_details[0]["lesson_release"] > 0 && $not_show === TRUE) {
                        /*if($coursetype_details[0]["course_type"] == 1){
                                                    if($coursetype_details[0]["lesson_release"] == 1){
                                                        $date_to_display = strtotime ( '+'.$step_less++.' day' , $start_date) ;
                                                    }
                                                    elseif($coursetype_details[0]["lesson_release"] == 2){
                                                        $date_to_display = strtotime ( '+'.$step_less++.' week' , $start_date) ;
                                                    }
                        
                                                    elseif($coursetype_details[0]["lesson_release"] == 3){
                                                        $date_to_display = strtotime ( '+'.$step_less++.' month' , $start_date) ;
                                                    }
                                                }*/
                        if ($diff_start > 0) {
                            ?>
                            <div class="available_lesson g_cell span2 available"><?php 
                            echo JText::_("GURU_AVAILABLE");
                            ?>
</div>
                            <?php 
                        }
                    }
                    ?>
                </li>
                    <?php 
                } elseif ($sub_cat["chb_free_courses"] == 0 && $user_id == 0) {
                    //$lesson_height = ($lesson_height/2)+100;
                    //$lesson_width = ($lesson_width/2)+100;
                    ?>
                <li class="g_row">
                   <div class="col_title g_cell span9 lesson_name"><a href="<?php 
                    echo JURI::root();
                    ?>
index.php?option=com_guru&view=guruEditplans&course_id=<?php 
                    echo intval($course_id);
                    ?>
-<?php 
                    echo $alias . $action;
                    ?>
&tmpl=component" onclick="openMyModal('<?php 
                    echo $lesson_height;
                    ?>
','<?php 
                    echo $lesson_width;
                    ?>
','<?php 
                    echo JURI::root();
                    ?>
index.php?option=com_guru&view=guruEditplans&course_id=<?php 
                    echo intval($course_id);
                    ?>
-<?php 
                    echo $alias . $action;
                    ?>
&tmpl=component'); return false;"><?php 
                    echo $sub_cat['name'];
                    ?>
</a></div>
                    <?php 
                    $user_id = $my->id;
                    $display = "none";
                    if ($user_id > 0) {
                        $lesson_viewed = guruModelguruTask::getViewLesson($sub_cat['id']);
                        if ($coursetype_details[0]["lessons_show"] == '2' && $diff_date > $diff_start) {
                            $display = "none";
                        } else {
                            if (isset($lesson_viewed) && $lesson_viewed === TRUE) {
                                $display = "inherit";
                            }
                        }
                    }
                    ?>
                    <div id="viewed-<?php 
                    echo $sub_cat['id'];
                    ?>
" style="display:<?php 
                    echo $display;
                    ?>
" class="g_cell span2 viewed">
                        <i class="fa fa-eye"></i>
                    </div>
                    <?php 
                    if ($course_level == 0) {
                        ?>
                        <div class="g_cell span1 level">
                            <img style="background-color:transparent;" src="<?php 
                        echo JURI::root() . "components/com_guru/images/" . $imgLevel;
                        ?>
" />
                        </div>
                        <?php 
                    }
                    ?>
                </li>
                    <?php 
                } else {
                    if ($coursetype_details[0]["course_type"] == 1) {
                        if ($coursetype_details[0]["lesson_release"] == 1) {
                            $date_to_display = strtotime('+' . $step_less++ . ' day', $start_date);
                        } elseif ($coursetype_details[0]["lesson_release"] == 2) {
                            $date_to_display = strtotime('+' . $step_less++ . ' week', $start_date);
                        } elseif ($coursetype_details[0]["lesson_release"] == 3) {
                            $date_to_display = strtotime('+' . $step_less++ . ' month', $start_date);
                        }
                    }
                    $style = "style='color:#999999;'";
                    $gray_style = " class=\\'s_no_underline\\' ";
                    if ($coursetype_details[0]["lessons_show"] == '1') {
                        $span_lesson = "span9";
                        $available_div = "";
                        if ($diff_start > 0) {
                            $date_to_display = date($config->datetype, $date_to_display);
                            $span_lesson = 'span7';
                            $available_div = '<div class="available_lesson g_cell span2 available">' . $date_to_display . '</div>';
                        }
                        ?>
                    <li <?php 
                        echo $style;
                        ?>
 class="g_row" >
                        <div class="col_title g_cell <?php 
                        echo $span_lesson;
                        ?>
 lesson_name">
                            <?php 
                        echo $sub_cat['name'];
                        ?>
                        </div>
                        
                        <div class="g_cell span2 viewed" style="visibility:visible" id="viewed-726">
                            &nbsp;
                        </div>
                        
                        <div class="g_cell span1 level">
                            <img style="background-color:transparent;" src="<?php 
                        echo JURI::root() . "components/com_guru/images/" . $imgLevel;
                        ?>
" />
                        </div>
                        <?php 
                        echo $available_div;
                        ?>
                    </li>
                    <?php 
                    } else {
                        ?>
                    <li>&nbsp;</li>
                        <?php 
                    }
                }
                ?>
                <?php 
                if ($config->open_target == 0) {
                    ?>
                    <?php 
                } else {
                    $my = JFactory::getUser();
                    $user_id = $my->id;
                    $display = "none";
                    if ($user_id > 0) {
                        $lesson_viewed = guruModelguruTask::getViewLesson($sub_cat['id']);
                        if ($coursetype_details[0]["lessons_show"] == '2' && $diff_date > $diff_start) {
                            $display = "none";
                        } else {
                            if (isset($lesson_viewed) && $lesson_viewed === TRUE) {
                                $display = "block";
                            }
                        }
                    }
                    ?>
                    <?php 
                }
                if ($coursetype_details[0]["course_type"] == 0 || $coursetype_details[0]["course_type"] == 1 && $coursetype_details[0]["lesson_release"] == 0 || $coursetype_details[0]["course_type"] == 1 && $user_id <= 0 || $coursetype_details[0]["lessons_show"] == '2' || $user_id > 0 && $not_show === FALSE) {
                } else {
                }
                ?>
                <?php 
                if ($deviceType != "phone") {
                    ?>
                    <?php 
                }
            }
            if (count($subcat) > 0) {
                ?>
                                                    </ul>
                                                </div>
                                            </div>
                                        </div>
                                    <?php 
            }
            ?>
        </div>
        </div>
        </div>
            <?php 
        }
        if ($show_buy_button == "0" && ($buy_button_location == "1" || $buy_button_location == "2")) {
            $button = createButton($buy_background, $course_id, $buy_class, $program, $program_content);
            if (!is_array($button)) {
                ?>
            <div class="call_2_action buy_now">
                <div>
                    <?php 
                if (!is_array($button)) {
                    echo $button;
                }
                ?>
                </div>
            </div>
                <?php 
            }
        }
        ?>
        </div>
</div><!-- end main div-->
    <?php 
    }
}
コード例 #8
0
ファイル: tabs.php プロジェクト: JozefAB/neoacu
function tab1($program, $author, $program_content, $exercise, $requirements, $course, $config, $course_config, $device)
{
    $prev_id = 0;
    $diff_start = "";
    $diff_date = "";
    $start_date = "";
    $itemid = "";
    $action = "";
    $lesson_width = "";
    $lesson_height = "";
    $st_psgpage = json_decode($config->st_psgpage);
    $psgpage = json_decode($config->psgpage);
    $course_level = $psgpage->course_level;
    $buy_class = $st_psgpage->course_other_button;
    $buy_background = $st_psgpage->course_other_background;
    $my = JFactory::getUser();
    $course_id = intval(JRequest::getVar("cid", 0));
    $show_buy_button = $course_config->course_buy_button;
    $buy_button_location = $course_config->course_buy_button_location;
    $user_id = $my->id;
    @($user->id = $my->id);
    $lesson_size = $config->lesson_window_size;
    $lesson_size = explode("x", $lesson_size);
    $lesson_height = $lesson_size["0"];
    $lesson_width = $lesson_size["1"];
    $style_grayout = "color:#999999;";
    $db = JFactory::getDBO();
    $sql = "select name, alias from #__guru_program where id=" . intval($course_id);
    $db->setQuery($sql);
    $db->query();
    $result = $db->loadAssocList();
    $alias = $result["0"]["alias"] == "" ? JFilterOutput::stringURLSafe($result["0"]["name"]) : $result["0"]["alias"];
    $sql = "SELECT  count(*) FROM `#__guru_buy_courses` where `order_id` >='0' and `userid`=" . intval($user_id) . " and course_id=" . intval($course_id);
    $db->setQuery($sql);
    $db->query();
    $result = $db->loadResult();
    if ($result > 0) {
        $not_show = true;
    } else {
        $not_show = false;
    }
    $sql = "SELECT chb_free_courses, step_access_courses, selected_course  FROM `#__guru_program` where id = " . intval($course_id);
    $db->setQuery($sql);
    $db->query();
    $result = $db->loadAssocList();
    $chb_free_courses = $result["0"]["chb_free_courses"];
    $step_access_courses = $result["0"]["step_access_courses"];
    $selected_course = $result["0"]["selected_course"];
    $hascourse = false;
    if (buySelectedCourse($selected_course)) {
        $hascourse = true;
    }
    $coursetype_details = guruModelguruProgram::getCourseTypeDetails($course_id);
    if ($course_level == 1) {
        $display_levelimg = "none";
    } else {
        $display_levelimg = "inherit-inline";
    }
    $detect = new Mobile_Detect();
    $deviceType = $detect->isMobile() ? $detect->isTablet() ? 'tablet' : 'phone' : 'computer';
    $authors = $program->author;
    $authors = explode("|", $authors);
    $authors = array_filter($authors);
    $itemid = JRequest::getVar("Itemid", "0");
    ?>
    
<div><!-- start main div-->
    <div class="table-of-contents">
            <?php 
    if ($show_buy_button == "0" && ($buy_button_location == "0" || $buy_button_location == "2")) {
        ?>
        <div class="uk-alert uk-hidden-small hidden-phone">
		   <?php 
        $button = createButton($buy_background, $course_id, $buy_class, $program, $program_content);
        // display message like "Get access to all the tutorials in the course now! and Buy Now button"
        if (is_array($button)) {
            echo $button["0"];
        } else {
            echo $button;
        }
        ?>
        </div>
            <?php 
    }
    ?>
    <div class="uk-grid">
            <?php 
    $show_all_cloase_all = isset($course_config->show_all_cloase_all) ? $course_config->show_all_cloase_all : "0";
    if ($user_id > 0) {
        $col_width = 9;
    } else {
        $col_width = 8;
    }
    $model = new guruModelguruProgram();
    $expired_license = $model->getExpiredLicense($program);
    if ($user_id > 0 && $coursetype_details[0]["course_type"] != 0 && $coursetype_details[0]["lessons_show"] == 1 && $coursetype_details[0]["lesson_release"] > 0 && $not_show === TRUE && !in_array($user_id, $authors) && !$expired_license) {
        $col_width = 7;
    }
    if (isset($course_config->duration) && $course_config->duration == 0) {
        $col_width = $col_width - 2;
    }
    if (isset($course_config->quiz_status) && $course_config->quiz_status == 0) {
        $col_width = $col_width - 2;
    }
    ?>
            <div class="col_title uk-width-large-1-2 uk-width-medium-1-2 uk-width-small-1-1">
				<?php 
    if ($show_all_cloase_all != 1) {
        ?>
                        <input type="button" class="uk-button uk-button-primary show_sub" value="+ <?php 
        echo JText::_("GURU_SHOW_ALL_BUTTON");
        ?>
"/><!--show all button -->
                        <input type="button" class="uk-button uk-button-primary close_sub" value="- <?php 
        echo JText::_("GURU_CLOSE_ALL_BUTTON");
        ?>
"/><!--close all button -->
                    <?php 
    } else {
        echo '&nbsp;';
    }
    ?>
			</div>
            
			<div class="uk-width-1-2 uk-hidden-small hidden-phone">
				<?php 
    $nr_columns = 1;
    if (isset($course_config->duration) && $course_config->duration == 0) {
        $nr_columns++;
    }
    if (isset($course_config->quiz_status) && $course_config->quiz_status == 0) {
        $nr_columns++;
    }
    if ($course_level == 0) {
        $nr_columns++;
    }
    if ($user_id > 0 && $coursetype_details[0]["course_type"] != 0 && $coursetype_details[0]["lessons_show"] == 1 && $coursetype_details[0]["lesson_release"] > 0 && $not_show === TRUE && !in_array($user_id, $authors) && !$expired_license) {
        $nr_columns++;
    }
    ?>
                
                <?php 
    if (isset($course_config->quiz_status) && $course_config->quiz_status == 0 && $device == "d") {
        ?>
                        <div class="col_title pull-left uk-width-1-<?php 
        echo intval($nr_columns);
        ?>
 uk-text-right">
                            <?php 
        echo JText::_("GURU_QUIZ_STATUS");
        ?>
                        </div>
                <?php 
    }
    ?>
                
                <div class="col_title pull-left uk-width-1-<?php 
    echo intval($nr_columns);
    ?>
 uk-text-right">
                    <?php 
    echo JText::_("GURU_VIEWED");
    ?>
                </div>
            
				<?php 
    if (isset($course_config->duration) && $course_config->duration == 0 && $device == "d") {
        ?>
                        <div class="col_title pull-left uk-width-1-<?php 
        echo intval($nr_columns);
        ?>
 uk-text-right">
                            <?php 
        echo JText::_("GURU_DURATION");
        ?>
                            <br />
                            <span id="total-duration-2"></span>
                        </div>
                <?php 
    }
    ?>

            
                <div class="col_title pull-left uk-width-1-<?php 
    echo intval($nr_columns);
    ?>
 uk-text-right">
                        <?php 
    if ($course_level == 0) {
        echo JText::_("GURU_LEVEL");
    }
    ?>
<!--Level -->
                </div>
				<?php 
    if ($user_id > 0 && $coursetype_details[0]["course_type"] != 0 && $coursetype_details[0]["lessons_show"] == 1 && $coursetype_details[0]["lesson_release"] > 0 && $not_show === TRUE && !in_array($user_id, $authors) && !$expired_license) {
        ?>
                    <div class="col_title pull-left uk-width-1-<?php 
        echo intval($nr_columns);
        ?>
 uk-text-right">
                        <?php 
        echo JText::_("GURU_AVAILABILITY");
        ?>
                    </div>
                    <?php 
    }
    ?>
			</div>
    </div>
    
        <?php 
    // start calculation for one lesson per (option in admin)
    if ($user_id > 0) {
        $db = JFactory::getDBO();
        $sql = "select DATE_FORMAT(buy_date,'%Y-%m-%d %H:%i:%s') from #__guru_buy_courses where course_id=" . intval($course_id) . " and userid =" . $user_id;
        $db->setQuery($sql);
        $db->query();
        $date_enrolled = $db->loadResult();
        $date_enrolled = strtotime($date_enrolled);
    }
    if (isset($date_enrolled) && $date_enrolled !== FALSE && !is_null($date_enrolled)) {
        $start_relaese_date1 = $coursetype_details[0]["start_release"];
        $start_relaese_date = strtotime($start_relaese_date1);
        $start_date = $date_enrolled;
        $jnow = JFactory::getDate();
        $date9 = $jnow->toSQL();
        $date_9 = date("Y-m-d", strtotime($date9));
        $date9 = strtotime($date9);
        $interval = abs($date9 - $start_date);
        $dif_days = floor($interval / (60 * 60 * 24));
        $dif_week = floor($interval / (60 * 60 * 24 * 7));
        $dif_month = floor($interval / (60 * 60 * 24 * 30));
        if ($coursetype_details[0]["course_type"] == 1) {
            if ($coursetype_details[0]["lesson_release"] == 1) {
                $diff_start = $dif_days + 1;
                $diff_date = $dif_days + 1;
            } elseif ($coursetype_details[0]["lesson_release"] == 2) {
                $diff_start = $dif_week + 1;
                $diff_date = $dif_week + 1;
            } elseif ($coursetype_details[0]["lesson_release"] == 3) {
                $diff_start = $dif_month + 1;
                $diff_date = $dif_month + 1;
            }
        }
    }
    $guruModelguruTask = new guruModelguruTask();
    $step_less = @$diff_start;
    $guruModelguruProgram = new guruModelguruProgram();
    $total_hours = 0;
    $total_minutes = 0;
    $total_seconds = 0;
    foreach ($program_content as $key => $module) {
        $lessons = $guruModelguruProgram->getSubCategory($module['id']);
        ?>
        	<div class="chapter_wrap t_row">
            	<div>
                	<div>
                    	<!-- start module -->
                        <div class="chapter_title clearfix">
							<div>
								<div class="day clearfix" onClick="javascript:show_hidde('<?php 
        echo $module['id'];
        ?>
','<?php 
        echo JUri::root() . "components/com_guru/images/";
        ?>
')">
                                	<img id='img_<?php 
        echo $device . "_" . $module['id'];
        ?>
' src='<?php 
        echo JUri::root() . "components/com_guru/images/arrow-right.gif";
        ?>
' />
                            		<?php 
        echo $module['title'];
        ?>
                        		</div>
                    		</div>
                		</div>
                        <!-- stop module -->
                        <?php 
        // start lessons
        $lesson_details_for_quiz = array();
        if (isset($lessons) && count($lessons) > 0) {
            ?>
                        		<div class="lessons_wrap">                          
                                	<div id='td_<?php 
            echo $device . "_" . $module['id'];
            ?>
'>
                                    	<div id='table_<?php 
            echo $device . "_" . $module['id'];
            ?>
' class="subcat">
                                        	<ul>
												<?php 
            $model = new guruModelguruProgram();
            foreach ($lessons as $poz => $lesson) {
                $nr_columns = 2;
                if ($course_level == 0) {
                    // show level icon
                    $nr_columns = 3;
                }
                $lesson = $model->checkLessonQuiz($lesson, $program);
                $lesson_details_for_quiz[] = $lesson;
                $lesson = $model->getLessonDetails($program, $author, $lesson, $diff_date, $diff_start, $step_less, $start_date, $config, $lesson_details_for_quiz, $poz);
                if (isset($lesson["not_show_lesson"]) && trim($lesson["not_show_lesson"]) == "1") {
                    continue;
                }
                $minutes = 0;
                $seconds = 0;
                if (isset($lesson['duration']) && trim($lesson['duration']) != "") {
                    $temp_duration = explode("x", trim($lesson['duration']));
                    $total_minutes += $temp_duration["0"];
                    $total_seconds += $temp_duration["1"];
                    $minutes = $temp_duration["0"];
                    $seconds = $temp_duration["1"];
                }
                $imgLevel = "";
                switch ($lesson['difficultylevel']) {
                    case "easy":
                        $imgLevel = "beginner_level.png";
                        break;
                    case "medium":
                        $imgLevel = "intermediate_level.png";
                        break;
                    case "hard":
                        $imgLevel = "advanced_level.png";
                        break;
                }
                $link = "";
                $onclick = "";
                $lesson_span = "span9";
                $available_date = "";
                $style = "";
                $inactive_lesson_class = "";
                if ($lesson["can_open_lesson"] == "1") {
                    // access to this lesson
                    if ($config->open_target == 0) {
                        // same window
                        $link = "index.php?option=com_guru&view=gurutasks&catid=" . $program->catid . "&module=" . $module["id"] . "-" . $module["alias"] . "&cid=" . $lesson['id'] . "-" . $lesson["alias"] . "&Itemid=" . $itemid;
                        $onclick = "javascript:setViewed('viewed-" . $lesson['id'] . "', '" . JURI::root() . "components/com_guru/images/icons/viewed.gif')";
                    } elseif ($config->open_target == 1) {
                        // modal window
                        $link = "#";
                        $onclick = "openMyModal('0', '0', '" . JURI::root() . "index.php?option=com_guru&view=gurutasks&catid=" . $program->catid . "&module=" . $module["id"] . "-" . $module["alias"] . "&cid=" . $lesson['id'] . "-" . $lesson["alias"] . "&tmpl=component&Itemid=" . $itemid . "'); return false; javascript:setViewed('viewed-" . $lesson['id'] . "', '" . JURI::root() . "components/com_guru/images/icons/viewed.gif" . "')";
                    }
                    if (isset($course_config->duration) && $course_config->duration == 0) {
                        $nr_columns++;
                    }
                    if (isset($course_config->quiz_status) && $course_config->quiz_status == 0) {
                        $nr_columns++;
                    }
                    if (isset($lesson["available_div"]) && trim($lesson["available_div"]) != "") {
                        // add AVAILABLE language var
                        $available_date = trim($lesson["available_div"]);
                        $nr_columns++;
                    }
                } elseif ($lesson["can_open_lesson"] == "0") {
                    // no access to this lesson
                    $inactive_lesson_class = "inactive-lesson";
                    if (isset($lesson["finish_required_courses"]) && $lesson["finish_required_courses"] == 1) {
                        // start open alert modal with required courses message
                        $link = "#";
                        $onclick = "openMyModal('0','0','" . JURI::root() . "index.php?option=com_guru&view=guruProfile&task=required_courses_message&graybox=true&tmpl=component'); return false;";
                        // stop open alert modal with required courses message
                    } elseif (isset($lesson["lesson_quiz_student_go_on"]) && $lesson["lesson_quiz_student_go_on"] == '0') {
                        // start exist quizzes that are not completed
                        $link = "#";
                        $onclick = "alert('" . JText::_("GURU_NO_FINISHED_QUIZZES_BEFORE_LESSON") . "')";
                        // stop exist quizzes that are not completed
                    } elseif (isset($lesson["enroll_to_course"]) && $lesson["enroll_to_course"] == 1) {
                        // start open enroll modal
                        $link = "#";
                        $onclick = "openMyModal('0','0','" . JURI::root() . "index.php?option=com_guru&view=guruProfile&task=loginform&course_id=" . intval($course_id) . "-" . $alias . $action . "&returnpage=guruprograms&graybox=true&tmpl=component'); return false;";
                        // stop open enroll modal
                    } elseif (isset($lesson["available_div"]) && trim($lesson["available_div"]) != "") {
                        // do nothing, the lesson is not available
                        $link = "#";
                        $onclick = "return false";
                        $available_date = trim($lesson["available_div"]);
                        $style = "style='color:#999999;'";
                        $step_less++;
                        $nr_columns++;
                    } elseif (isset($lesson["need_enroll"]) && $lesson["need_enroll"] == "1") {
                        $link = "#";
                        $onclick = "openMyModal('0', '0', '" . JURI::root() . "index.php?option=com_guru&view=guruProfile&task=loginform&course_id=" . $program->id . "&tmpl=component&Itemid=" . $itemid . "'); return false;";
                    } elseif (isset($lesson["need_registration"]) && $lesson["need_registration"] == "1") {
                        $link = "index.php?option=com_guru&view=guruLogin&Itemid=" . $itemid;
                        $onclick = "";
                    } else {
                        if (isset($lesson["available_div"]) && trim($lesson["available_div"]) != "") {
                            // add AVAILABLE language var
                            $nr_columns++;
                            $available_date = trim($lesson["available_div"]);
                        }
                        // start open course plans for buy
                        $itemid = JRequest::getVar("Itemid", "0");
                        $link = "#";
                        $onclick = "openMyModal('0','0','" . JURI::root() . "index.php?option=com_guru&view=guruEditplans&course_id=" . intval($course_id) . "-" . $alias . @$action . "&tmpl=component&Itemid=" . intval($itemid) . "'); return false;";
                        // stop open course plans for buy
                    }
                    if (isset($course_config->duration) && $course_config->duration == 0) {
                        $nr_columns++;
                    }
                    if (isset($course_config->quiz_status) && $course_config->quiz_status == 0) {
                        $nr_columns++;
                    }
                }
                if (isset($config->indicate_quiz) && intval($config->indicate_quiz) == 1) {
                    $count = $guruModelguruProgram->getCount($module["id"], $lesson['id']);
                    if ($count > 0) {
                        $lesson['name'] .= ' [' . JText::_("GURU_QUIZ") . ']';
                    }
                }
                if ($diff_date != "") {
                    @$diff_date--;
                }
                ?>
                                                		<li class="uk-grid" <?php 
                echo $style;
                ?>
>
															<div class="uk-width-1-2 lesson_name">
                                                                <a onclick="<?php 
                echo $onclick;
                ?>
" href="<?php 
                echo $link;
                ?>
" <?php 
                echo $style;
                ?>
 class="<?php 
                echo $inactive_lesson_class;
                ?>
">
                                                                    <?php 
                echo $lesson['name'];
                ?>
                                                                </a>
                                                        	</div>
                                                            <?php 
                $user_id = $my->id;
                $display = "hidden";
                if ($user_id > 0) {
                    $lesson_viewed = $guruModelguruTask->getViewLesson($lesson['id']);
                    if (isset($lesson_viewed) && $lesson_viewed === TRUE) {
                        $display = "inherit";
                    }
                }
                ?>
                                                            <div class="uk-width-1-2">
                                                            	<?php 
                if (isset($course_config->quiz_status) && $course_config->quiz_status == 0) {
                    ?>
                                                            		<div class="uk-width-1-<?php 
                    echo $nr_columns - 1;
                    ?>
 pull-left uk-text-right">
                                                                        <?php 
                    if (isset($lesson["quiz_passed"]) && $lesson["quiz_passed"] == -1) {
                        // pending
                        echo '<span class="lesson-quizz-pending">' . JText::_("GURU_PENDING") . '</span>';
                    } elseif (isset($lesson["quiz_passed"]) && $lesson["quiz_passed"] == 0) {
                        // failed
                        echo '<span class="lesson-quizz-failed">' . JText::_("GURU_QUIZ_FAILED_STATUS") . '</span>';
                    } elseif (isset($lesson["quiz_passed"]) && $lesson["quiz_passed"] == 1) {
                        // passed
                        echo '<span class="lesson-quizz-passed">' . JText::_("GURU_QUIZ_PASSED_STATUS") . '</span>';
                    } else {
                        echo '&nbsp;';
                    }
                    ?>
                                                                    </div>
                                                            <?php 
                }
                ?>
                                                            
                                                                <div style="visibility:<?php 
                echo $display;
                ?>
;" class="uk-width-1-<?php 
                echo $nr_columns - 1;
                ?>
 viewed pull-left uk-text-right">
                                                                    <i class="fa fa-eye"></i>
                                                                </div>
                                                            
                                                            <?php 
                if (isset($course_config->duration) && $course_config->duration == 0) {
                    ?>
                                                            		<div class="uk-width-1-<?php 
                    echo $nr_columns - 1;
                    ?>
 pull-left uk-text-right">
                                                                        <?php 
                    if (intval($minutes) != 0) {
                        echo intval($minutes) . "m ";
                    }
                    if (intval($seconds) != 0) {
                        echo intval($seconds) . "s ";
                    }
                    if (intval($minutes) == 0 && intval($seconds) == 0) {
                        echo '&nbsp;';
                    }
                    ?>
                                                                    </div>
                                                            <?php 
                }
                ?>
                                                            
                                                                <div class="uk-width-1-<?php 
                echo $nr_columns - 1;
                ?>
 pull-left uk-text-right">
                                                                <?php 
                if ($course_level == 0) {
                    // show course level
                    ?>
                                                                        <img style="background-color:transparent;" src="<?php 
                    echo JURI::root() . "components/com_guru/images/" . $imgLevel;
                    ?>
" />
                                                                <?php 
                }
                ?>
                                                                </div>
                                                                <?php 
                $available_date = str_replace("replace_class", 'uk-width-1-' . ($nr_columns - 1) . ' uk-text-right', $available_date);
                echo $available_date;
                ?>
															</div>
														</li>
                                                <?php 
            }
            ?>
                                            </ul>
										</div>
									</div>
								</div>
                        <?php 
        }
        // stop lessons
        ?>
                    </div>
                </div>
            </div>
		<?php 
    }
    $total_minutes += floor($total_seconds / 60);
    $total_seconds = $total_seconds % 60;
    if (intval($total_minutes) >= 60) {
        $total_hours = floor($total_minutes / 60);
        $total_minutes = $total_minutes % 60;
    }
    $display_duration_1 = array();
    $display_duration_2 = array();
    if (intval($total_hours) > 0) {
        if (intval($total_hours) > 1) {
            $display_duration_1[] = $total_hours . " " . JText::_("GURU_PROGRAM_DETAILS_HOURS");
        } else {
            $display_duration_1[] = $total_hours . " " . JText::_("GURU_PROGRAM_DETAILS_HOUR");
        }
        $display_duration_2[] = $total_hours . "h";
    }
    if (intval($total_minutes) > 0) {
        if (intval($total_minutes) > 1) {
            $display_duration_1[] = $total_minutes . " " . JText::_("GURU_PROGRAM_DETAILS_MINUTES");
        } else {
            $display_duration_1[] = $total_minutes . " " . JText::_("GURU_PROGRAM_DETAILS_MINUTE");
        }
        $display_duration_2[] = $total_minutes . "m";
    }
    if (intval($total_seconds) > 0) {
        if (intval($total_minutes) > 1) {
            $display_duration_1[] = $total_seconds . " " . JText::_("GURU_PROGRAM_DETAILS_SECONDS");
        } else {
            $display_duration_1[] = $total_seconds . " " . JText::_("GURU_PROGRAM_DETAILS_SECOND");
        }
        $display_duration_2[] = $total_seconds . "s";
    }
    if (isset($course_config->duration) && $course_config->duration == 0) {
        ?>
			<script type="text/javascript" language="javascript">
				document.getElementById("total-duration-1").innerHTML = "<?php 
        echo implode(", ", $display_duration_1);
        ?>
";
				document.getElementById("total-duration-2").innerHTML = "<?php 
        echo implode(" ", $display_duration_2);
        ?>
";
			</script>
		<?php 
    }
    if ($show_buy_button == "0" && ($buy_button_location == "1" || $buy_button_location == "2")) {
        $button = createButton($buy_background, $course_id, $buy_class, $program, $program_content);
        if (!is_array($button)) {
            ?>
            <div class="uk-alert">
				<?php 
            if (!is_array($button)) {
                echo $button;
            }
            ?>
            </div>
                <?php 
        }
    }
    ?>
        </div>
</div><!-- end main div-->
    <?php 
}
コード例 #9
0
ファイル: loginform.php プロジェクト: JozefAB/qk
# Websites: http://www.ijoomla.com

# Technical Support:  Forum - http://www.ijoomla.com.com/forum/index/

-------------------------------------------------------------------------*/
defined('_JEXEC') or die('Restricted access');
$document = JFactory::getDocument();
include JPATH_SITE . DS . 'components' . DS . 'com_guru' . DS . 'models' . DS . 'gurutask.php';
global $Itemid;
$db = JFactory::getDBO();
$my = JFactory::getUser();
$user_id = $my->id;
$course_id = intval(JRequest::getVar("course_id", ""));
$chb_free_courses = guruModelguruTask::getDataChbAccessCourses($course_id);
$step_access_courses = guruModelguruTask::getDataStepAccessCourses($course_id);
if ($user_id == 0) {
    // if you are logout
    //desktop view
    ?>

            <div class="g_padding_wrap clearfix">

                <div class="guru_modal_login_page page_title g_cell span7">

					<h2><?php 
    echo JText::_('GURU_FREE_MEMBERS_LOGIN_FORM');
    ?>
</h2>

                </div> 
コード例 #10
0
ファイル: myquizandfexam.php プロジェクト: JozefAB/qk
$document->addScript("components/com_guru/js/programs.js");
$document->setMetaData('viewport', 'width=device-width, initial-scale=1.0');
require_once JPATH_BASE . "/components/com_guru/helpers/Mobile_Detect.php";
JHtml::_('bootstrap.tooltip');
//JHtml::_('behavior.multiselect');
JHtml::_('dropdown.init');
//JHtml::_('formbehavior.chosen', 'select');
$db = JFactory::getDBO();
$user = JFactory::getUser();
$user_id = $user->id;
$Itemid = JRequest::getVar("Itemid", "0");
$search = JRequest::getVar("search_course", "");
$config = $this->getConfigSettings();
$cid = array();
$guruModelguruOrder = new guruModelguruOrder();
$guruModelguruTask = new guruModelguruTask();
$certcourseidlist = $guruModelguruOrder->getCourseidsList($user_id);
$certificates_general = $guruModelguruOrder->getCertificate();
$document->setTitle(trim(JText::_('GURU_QUIZZ_FINAL_EXAM')));
$detect = new Mobile_Detect();
$deviceType = $detect->isMobile() ? $detect->isTablet() ? 'tablet' : 'phone' : 'computer';
if ($deviceType == "phone") {
    $styledisplay = 'display:inline-block !important;';
    $class_title = 'class="guruml20"';
} else {
    $styledisplay = '';
    $class_title = 'class="guruml20"';
}
$return_url = base64_encode("index.php?option=com_guru&view=guruorders&layout=myquizandfexam&Itemid=" . intval(@$itemid));
if ($config->gurujomsocialprofilestudent == 1) {
    $link = "index.php?option=com_community&view=profile&task=edit&Itemid=" . $Itemid;
コード例 #11
0
ファイル: quizdetails.php プロジェクト: JozefAB/neoacu
         }
     }
 } elseif ($quiz_questions[$i]->type == "multiple") {
     if (isset($question_answers) && count($question_answers) > 0) {
         foreach ($question_answers as $question_answer) {
             $media_associated_answers = json_decode($question_answer->media_ids);
             $media_content = "";
             $result_media_answers = array();
             if (isset($media_associated_answers) && count($media_associated_answers) > 0) {
                 foreach ($media_associated_answers as $media_key => $answer_media_id) {
                     $media_that_needs_to_be_sent = guruModelguruTask::getMediaFromId($answer_media_id);
                     if (isset($media_that_needs_to_be_sent) && count($media_that_needs_to_be_sent) > 0) {
                         if ($media_that_needs_to_be_sent["0"]->type == "text") {
                             $result_media_answers[] = guruModelguruTask::parse_txt($media_that_needs_to_be_sent["0"]->id);
                         } else {
                             $result_media_answers[] = guruModelguruTask::parse_media($media_that_needs_to_be_sent["0"]->id, 0);
                         }
                     }
                 }
             }
             $multiple_ans_given = explode(",", @$answer_given_by_user[$question_answer->question_id]["answers_given"]);
             $checked = '';
             if (in_array($question_answer->id, $multiple_ans_given)) {
                 $checked = 'checked="checked"';
             }
             $option_value = '<input type="checkbox" ' . $checked . ' disabled name="multiple_ans[' . intval($quiz_questions[$i]->id) . '][]" value="' . $question_answer->id . '"/>&nbsp;' . $question_answer->answer_content_text . '<br/>' . implode("", $result_media_answers) . "<br/>";
             $quiz_form_content .= $option_value;
         }
     }
 } elseif ($quiz_questions[$i]->type == "essay") {
     $essay_exists = TRUE;
コード例 #12
-1
ファイル: guruOrders.php プロジェクト: JozefAB/neoacu
 function savepdfcertificate()
 {
     $datac = JRequest::get('post', JREQUEST_ALLOWRAW);
     include JPATH_SITE . DS . 'components' . DS . 'com_guru' . DS . 'models' . DS . 'gurutask.php';
     $background_color = "";
     $op = JRequest::getVar("op", "");
     if ($op == 9) {
         $db = JFactory::getDBO();
         $user = JFactory::getUser();
         $config = JFactory::getConfig();
         $imagename = "SELECT * FROM #__guru_certificates WHERE id=1";
         $db->setQuery($imagename);
         $db->query();
         $imagename = $db->loadAssocList();
         if ($imagename[0]["design_background"] != "") {
             $image_theme = explode("/", $imagename[0]["design_background"]);
             if (trim($image_theme[4]) == 'thumbs') {
                 $image_theme = $image_theme[5];
             } else {
                 $image_theme = $image_theme[4];
             }
         } else {
             $background_color = "background-color:" . "#" . $imagename[0]["design_background_color"];
         }
         $site_url = JURI::root();
         $coursename = JRequest::getVar('cn', '', 'get');
         $authorname = JRequest::getVar('an', '', 'get');
         $certificateid = JRequest::getVar('id', '', 'get');
         $completiondate = JRequest::getVar('cd', '', 'get');
         $course_id = JRequest::getVar('ci', '', 'get');
         $sitename = $config->get('sitename');
         $user_id = $user->id;
         $scores_avg_quizzes = @guruModelguruTask::getAvgScoresQ($user_id, $course_id);
         $avg_quizzes_cert = "SELECT avg_certc FROM #__guru_program WHERE id=" . intval($course_id);
         $db->setQuery($avg_quizzes_cert);
         $db->query();
         $avg_quizzes_cert = $db->loadResult();
         $sql = "SELECT id_final_exam FROM #__guru_program WHERE id=" . intval($course_id);
         $db->setQuery($sql);
         $result = $db->loadResult();
         $sql = "SELECT hasquiz from #__guru_program WHERE id=" . intval($course_id);
         $db->setQuery($sql);
         $resulthasq = $db->loadResult();
         $sql = "SELECT max_score FROM #__guru_quiz WHERE id=" . intval($result);
         $db->setQuery($sql);
         $result_maxs = $db->loadResult();
         // final quiz --------------------------------------------------
         $sql = "SELECT id, score_quiz FROM #__guru_quiz_question_taken_v3 WHERE user_id=" . intval($user_id) . " and quiz_id=" . intval($result) . " and pid=" . intval($course_id) . " ORDER BY id DESC LIMIT 0,1";
         $db->setQuery($sql);
         $result_q = $db->loadObject();
         $first = explode("|", @$result_q->score_quiz);
         @($res = intval($first[0] / $first[1] * 100));
         if ($resulthasq == 0 && $scores_avg_quizzes == "") {
             $avg_certc = "N/A";
         } elseif ($resulthasq != 0 && $scores_avg_quizzes == "") {
             $avg_certc = "N/A";
         } elseif ($resulthasq != 0 && isset($scores_avg_quizzes)) {
             if ($scores_avg_quizzes >= intval($avg_quizzes_cert)) {
                 $avg_certc = $scores_avg_quizzes . '%';
             } else {
                 $avg_certc = $scores_avg_quizzes . '%';
             }
         }
         // final quiz --------------------------------------------------
         // regular ----------------------------------------------
         $s = 0;
         $sql = "select mr.`media_id` from #__guru_mediarel mr, #__guru_days d where mr.`type`='dtask' and mr.`type_id`=d.`id` and d.`pid`=" . intval($course_id);
         $db->setQuery($sql);
         $db->query();
         $lessons = $db->loadColumn();
         if (!isset($lessons) || count($lessons) == 0) {
             $lessons = array("0");
         }
         $sql = "select mr.`media_id` from #__guru_mediarel mr where mr.`layout`='12' and mr.`type`='scr_m' and mr.`type_id` in (" . implode(", ", $lessons) . ")";
         $db->setQuery($sql);
         $db->query();
         $all_quizzes = $db->loadColumn();
         if (isset($all_quizzes) && count($all_quizzes) > 0) {
             foreach ($all_quizzes as $key_quiz => $quiz_id) {
                 $sql = "SELECT score_quiz FROM #__guru_quiz_question_taken_v3 WHERE user_id=" . intval($user_id) . " and quiz_id=" . intval($quiz_id) . " and pid=" . intval($course_id) . " ORDER BY id DESC LIMIT 0,1";
                 $db->setQuery($sql);
                 $db->query();
                 $result_q = $db->loadColumn();
                 $res = @$result_q["0"];
                 $s += $res;
             }
             $avg_certc1 = "N/A";
             if ($s > 0) {
                 $avg_certc1 = $s / count($all_quizzes) . "%";
             }
         }
         // regular ----------------------------------------------
         /*$sql = "SELECT id, score_quiz, time_quiz_taken_per_user  FROM #__guru_quiz_taken_v3 WHERE user_id=".intval($user_id)." and quiz_id=".intval($result)." and pid=".intval($course_id )." ORDER BY id DESC LIMIT 0,1";
         			$db->setQuery($sql);
         			$result_q = $db->loadObject();
         	
         			$first= explode("|", @$result_q->score_quiz);
         	
         			@$res = intval(($first[0]/$first[1])*100);
         	
         			if($resulthasq == 0 && $scores_avg_quizzes == ""){
         				$avg_certc1 = "N/A";
         			}
         			elseif($resulthasq != 0 && $scores_avg_quizzes == ""){
         				$avg_certc1 = "N/A";
         			}
         			elseif($resulthasq != 0 && isset($scores_avg_quizzes)){
         				if($scores_avg_quizzes >= intval($avg_quizzes_cert)){
         					$avg_certc1 =  $scores_avg_quizzes.'%'; 
         				}
         				else{
         					$avg_certc1 = $scores_avg_quizzes.'%';
         				}
         			}*/
         /*if($result !=0 && $res !="" ){
         			if( $res >= $result_maxs){
         				$avg_certc = $res.'%';
         			}
         			elseif($res < $result_maxs){
         				$avg_certc = $res.'%';
         			}
         		}
         		elseif(($result !=0 && $result !="")){
         			$avg_certc = "N/A";
         		}
         		elseif($result ==0 || $result ==""){
         			$avg_certc = "N/A";
         		}*/
         $firstnamelastname = "SELECT firstname, lastname FROM #__guru_customer WHERE id=" . intval($user_id);
         $db->setQuery($firstnamelastname);
         $db->query();
         $firstnamelastname = $db->loadAssocList();
         $coursemsg = "SELECT certificate_course_msg FROM #__guru_program WHERE id=" . intval($course_id);
         $db->setQuery($coursemsg);
         $db->query();
         $coursemsg = $db->loadResult();
         $certificate_url = JUri::base() . "index.php?option=com_guru&view=guruOrders&task=printcertificate&opt=" . $certificateid . "&cn=" . $coursename . "&an=" . $authorname . "&cd=" . $completiondate . "&id=" . $certificateid;
         $certificate_url = str_replace(" ", "%20", $certificate_url);
         $imagename[0]["templates1"] = str_replace("[SITENAME]", $sitename, $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[STUDENT_FIRST_NAME]", $firstnamelastname[0]["firstname"], $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[STUDENT_LAST_NAME]", $firstnamelastname[0]["lastname"], $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[SITEURL]", $site_url, $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[CERTIFICATE_ID]", $certificateid, $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[COMPLETION_DATE]", $completiondate, $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[COURSE_NAME]", $coursename, $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[AUTHOR_NAME]", $authorname, $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[CERT_URL]", $certificate_url, $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[COURSE_MSG]", $coursemsg, $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[COURSE_AVG_SCORE]", $avg_certc1, $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[COURSE_FINAL_SCORE]", $avg_certc, $imagename[0]["templates1"]);
         while (ob_get_level()) {
             ob_end_clean();
         }
         header("Content-Encoding: None", true);
         if (strlen($imagename[0]["design_text_color"]) == 3) {
             $r = hexdec(substr($imagename[0]["design_text_color"], 0, 1) . substr($imagename[0]["design_text_color"], 0, 1));
             $g = hexdec(substr($imagename[0]["design_text_color"], 1, 1) . substr($imagename[0]["design_text_color"], 1, 1));
             $b = hexdec(substr($imagename[0]["design_text_color"], 2, 1) . substr($imagename[0]["design_text_color"], 2, 1));
         } else {
             $r = hexdec(substr($imagename[0]["design_text_color"], 0, 2));
             $g = hexdec(substr($imagename[0]["design_text_color"], 2, 2));
             $b = hexdec(substr($imagename[0]["design_text_color"], 4, 2));
         }
         $background_color = explode(":", $background_color);
         @($background_color[1] = str_replace("#", "", $background_color[1]));
         if (strlen($background_color[1]) == 3) {
             $rg = hexdec(substr($background_color[1], 0, 1) . substr($background_color[1], 0, 1));
             $gg = hexdec(substr($background_color[1], 1, 1) . substr($background_color, 1, 1));
             $bg = hexdec(substr($background_color[1], 2, 1) . substr($background_color[1], 2, 1));
         } else {
             $rg = hexdec(substr($background_color[1], 0, 2));
             $gg = hexdec(substr($background_color[1], 2, 2));
             $bg = hexdec(substr($background_color[1], 4, 2));
         }
         if ($imagename[0]["library_pdf"] == 0) {
             require_once JPATH_SITE . DS . "components" . DS . "com_guru" . DS . "helpers" . DS . "fpdf.php";
             $pdf = new PDF('L', 'mm', 'A5');
             $pdf->SetFont($imagename[0]["font_certificate"], '', 12);
             $pdf->SetTextColor($r, $g, $b);
             //set up a page
             $pdf->AddPage();
             if ($image_theme != "") {
                 $pdf->Image(JUri::base() . "images/stories/guru/certificates/" . $image_theme, -4, -1, 210, 150);
                 //$pdf->Cell(0,75,JText::_("GURU_CERTIFICATE_OF_COMPLETION"),0,1,'C');
             } else {
                 $pdf->SetFillColor($rg, $gg, $bg);
                 //$pdf->Cell(0,115,JText::_("GURU_CERTIFICATE_OF_COMPLETION"),0,1,'C',true);
             }
             $pdf->Ln(20);
             $pdf->SetXY(100, 50);
             $pdf->WriteHTML(iconv('UTF-8', 'ISO-8859-1', $imagename[0]["templates1"]), true);
             $pdf->Output('certificate' . $certificateid . '.pdf', 'D');
         } else {
             require JPATH_SITE . DS . "components" . DS . "com_guru" . DS . "helpers" . DS . "MPDF" . DS . "mpdf.php";
             $pdf = new mPDF('utf-8', 'A4-L');
             $pdf = new mPDF('utf-8', 'A4-L', 0, strtolower($imagename[0]["font_certificate"]));
             $imagename[0]["templates1"] = '<style> body { font-family:"' . strtolower($imagename[0]["font_certificate"]) . '" ; color: rgb(' . $r . ', ' . $g . ', ' . $b . '); }</style>' . $imagename[0]["templates1"];
             //set up a page
             $pdf->AddPage('L');
             if ($image_theme != "") {
                 $pdf->Image(JPATH_BASE . "/images/stories/guru/certificates/" . $image_theme, 0, 0, 298, 210, 'jpg', '', true, false);
                 //$pdf->Cell(0,75,JText::_("GURU_CERTIFICATE_OF_COMPLETION"),0,1,'C');
             } else {
                 $pdf->SetFillColor($rg, $gg, $bg);
                 //$pdf->Cell(0,115,JText::_("GURU_CERTIFICATE_OF_COMPLETION"),0,1,'C',true);
             }
             //$pdf->Ln(20);
             $pdf->SetXY(100, 50);
             $pdf->SetDisplayMode('fullpage');
             $pdf->WriteHTML($imagename[0]["templates1"]);
             $pdf->Output('certificate' . $certificateid . '.pdf', 'D');
             exit;
         }
     } else {
         $db = JFactory::getDBO();
         $user = JFactory::getUser();
         $config = JFactory::getConfig();
         $imagename = "SELECT * FROM #__guru_certificates WHERE id=1";
         $db->setQuery($imagename);
         $db->query();
         $imagename = $db->loadAssocList();
         if ($imagename[0]["design_background"] != "") {
             $image_theme = explode("/", $imagename[0]["design_background"]);
             if (trim($image_theme[4]) == 'thumbs') {
                 $image_theme = $image_theme[5];
             } else {
                 $image_theme = $image_theme[4];
             }
         } else {
             $background_color = "background-color:" . "#" . $imagename[0]["design_background_color"];
         }
         $site_url = JURI::root();
         $coursename = $datac['cn'];
         $authorname = $datac['an'];
         $certificateid = $datac['id'];
         $completiondate = $datac['cd'];
         $course_id = $datac['ci'];
         $sitename = $config->get('config.sitename');
         $user_id = $user->id;
         $scores_avg_quizzes = guruModelguruTask::getAvgScoresQ($user_id, $course_id);
         $avg_quizzes_cert = "SELECT avg_certc FROM #__guru_program WHERE id=" . intval($course_id);
         $db->setQuery($avg_quizzes_cert);
         $db->query();
         $avg_quizzes_cert = $db->loadResult();
         $sql = "SELECT id_final_exam FROM #__guru_program WHERE id=" . intval($course_id);
         $db->setQuery($sql);
         $result = $db->loadResult();
         $sql = "SELECT hasquiz from #__guru_program WHERE id=" . intval($course_id);
         $db->setQuery($sql);
         $resulthasq = $db->loadResult();
         $sql = "SELECT max_score FROM #__guru_quiz WHERE id=" . intval($result);
         $db->setQuery($sql);
         $result_maxs = $db->loadResult();
         $sql = "SELECT id, score_quiz, time_quiz_taken_per_user  FROM #__guru_quiz_taken_v3 WHERE user_id=" . intval($user_id) . " and quiz_id=" . intval($result) . " and pid=" . intval($course_id) . " ORDER BY id DESC LIMIT 0,1";
         $db->setQuery($sql);
         $result_q = $db->loadObject();
         $first = explode("|", @$result_q->score_quiz);
         @($res = intval($first[0] / $first[1] * 100));
         if ($resulthasq == 0 && $scores_avg_quizzes == "") {
             $avg_certc1 = "N/A";
         } elseif ($resulthasq != 0 && $scores_avg_quizzes == "") {
             $avg_certc1 = "N/A";
         } elseif ($resulthasq != 0 && isset($scores_avg_quizzes)) {
             if ($scores_avg_quizzes >= intval($avg_quizzes_cert)) {
                 $avg_certc1 = $scores_avg_quizzes . '%';
             } else {
                 $avg_certc1 = $scores_avg_quizzes . '%';
             }
         }
         if ($result != 0 && $res != "") {
             if ($res >= $result_maxs) {
                 $avg_certc = $res . '%';
             } elseif ($res < $result_maxs) {
                 $avg_certc = $res . '%';
             }
         } elseif ($result != 0 && $result != "") {
             $avg_certc = "N/A";
         } elseif ($result == 0 || $result == "") {
             $avg_certc = "N/A";
         }
         $firstnamelastname = "SELECT firstname, lastname FROM #__guru_customer WHERE id=" . intval($user_id);
         $db->setQuery($firstnamelastname);
         $db->query();
         $firstnamelastname = $db->loadAssocList();
         $coursemsg = "SELECT certificate_course_msg FROM #__guru_program WHERE id=" . intval($course_id);
         $db->setQuery($coursemsg);
         $db->query();
         $coursemsg = $db->loadResult();
         $certificate_url = JUri::base() . "index.php?option=com_guru&view=guruOrders&task=printcertificate&opt=" . $certificateid . "&cn=" . $coursename . "&an=" . $authorname . "&cd=" . $completiondate . "&id=" . $certificateid;
         $certificate_url = str_replace(" ", "%20", $certificate_url);
         $imagename[0]["templates1"] = str_replace("[SITENAME]", $sitename, $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[STUDENT_FIRST_NAME]", $firstnamelastname[0]["firstname"], $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[STUDENT_LAST_NAME]", $firstnamelastname[0]["lastname"], $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[SITEURL]", $site_url, $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[CERTIFICATE_ID]", $certificateid, $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[COMPLETION_DATE]", $completiondate, $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[COURSE_NAME]", $coursename, $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[AUTHOR_NAME]", $authorname, $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[CERT_URL]", $certificate_url, $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[COURSE_MSG]", $coursemsg, $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[COURSE_AVG_SCORE]", $avg_certc1, $imagename[0]["templates1"]);
         $imagename[0]["templates1"] = str_replace("[COURSE_FINAL_SCORE]", $avg_certc, $imagename[0]["templates1"]);
         while (ob_get_level()) {
             ob_end_clean();
         }
         header("Content-Encoding: None", true);
         if (strlen($imagename[0]["design_text_color"]) == 3) {
             $r = hexdec(substr($imagename[0]["design_text_color"], 0, 1) . substr($imagename[0]["design_text_color"], 0, 1));
             $g = hexdec(substr($imagename[0]["design_text_color"], 1, 1) . substr($imagename[0]["design_text_color"], 1, 1));
             $b = hexdec(substr($imagename[0]["design_text_color"], 2, 1) . substr($imagename[0]["design_text_color"], 2, 1));
         } else {
             $r = hexdec(substr($imagename[0]["design_text_color"], 0, 2));
             $g = hexdec(substr($imagename[0]["design_text_color"], 2, 2));
             $b = hexdec(substr($imagename[0]["design_text_color"], 4, 2));
         }
         $background_color = explode(":", $background_color);
         $background_color[1] = str_replace("#", "", $background_color[1]);
         if (strlen($background_color[1]) == 3) {
             $rg = hexdec(substr($background_color[1], 0, 1) . substr($background_color[1], 0, 1));
             $gg = hexdec(substr($background_color[1], 1, 1) . substr($background_color, 1, 1));
             $bg = hexdec(substr($background_color[1], 2, 1) . substr($background_color[1], 2, 1));
         } else {
             $rg = hexdec(substr($background_color[1], 0, 2));
             $gg = hexdec(substr($background_color[1], 2, 2));
             $bg = hexdec(substr($background_color[1], 4, 2));
         }
         if ($imagename[0]["library_pdf"] == 0) {
             require JPATH_SITE . DS . "components" . DS . "com_guru" . DS . "helpers" . DS . "fpdf.php";
             $pdf = new PDF('L', 'mm', 'A5');
             $pdf->SetFont($imagename[0]["font_certificate"], '', 12);
             $pdf->SetTextColor($r, $g, $b);
             //set up a page
             $pdf->AddPage();
             if ($image_theme != "") {
                 $pdf->Image(JUri::base() . "images/stories/guru/certificates/" . $image_theme, -4, -1, 210, 150);
                 //$pdf->Cell(0,75,JText::_("GURU_CERTIFICATE_OF_COMPLETION"),0,1,'C');
             } else {
                 $pdf->SetFillColor($rg, $gg, $bg);
                 //$pdf->Cell(0,115,JText::_("GURU_CERTIFICATE_OF_COMPLETION"),0,1,'C',true);
             }
             $pdf->Ln(20);
             $pdf->SetXY(100, 50);
             $pdf->WriteHTML(iconv('UTF-8', 'ISO-8859-1', $imagename[0]["templates1"]), true);
             $pdf->Output('certificate' . $certificateid . '.pdf', 'D');
         } else {
             require JPATH_SITE . DS . "components" . DS . "com_guru" . DS . "helpers" . DS . "MPDF" . DS . "mpdf.php";
             $pdf = new mPDF('utf-8', 'A4-L');
             $imagename[0]["templates1"] = '<style> body { font-family:"' . strtolower($imagename[0]["font_certificate"]) . '" ; color: rgb(' . $r . ', ' . $g . ', ' . $b . '); }</style>' . $imagename[0]["templates1"];
             //set up a page
             $pdf->AddPage('L');
             if ($image_theme != "") {
                 $pdf->Image(JPATH_BASE . "/images/stories/guru/certificates/" . $image_theme, 0, 0, 298, 210, 'jpg', '', true, false);
                 //$pdf->Cell(0,75,JText::_("GURU_CERTIFICATE_OF_COMPLETION"),0,1,'C');
             } else {
                 $pdf->SetFillColor($rg, $gg, $bg);
                 //$pdf->Cell(0,115,JText::_("GURU_CERTIFICATE_OF_COMPLETION"),0,1,'C',true);
             }
             //$pdf->Ln(20);
             $pdf->SetXY(100, 50);
             $pdf->SetDisplayMode('fullpage');
             $pdf->WriteHTML($imagename[0]["templates1"]);
             $pdf->Output('certificate' . $certificateid . '.pdf', 'D');
             exit;
         }
     }
 }