$dif_days_enrolled = intval($dif_days_enrolled / 30); $diff_date = $dif_days_enrolled; } } $sql = "SELECT media_id FROM #__guru_mediarel WHERE type='scr_m' and type_id=" . intval($step->id) . " and `layout`='12'"; $db->setQuery($sql); $result = $db->loadResult(); $quiz_id = $result; $sql = "SELECT nb_quiz_select_up FROM #__guru_quiz WHERE id=" . intval($quiz_id); $db->setQuery($sql); $nb_quiz_select_up = $db->loadColumn(); $nb_of_questions = @$nb_quiz_select_up["0"]; $quizz_fe_content = $this->getQuizCalculation($quiz_id, $step->pid, $user_id, $nb_of_questions); $completed_course = $guruModelguruOrder->courseCompleted($user->id, $step->pid); $course_certificate_term = $guruModelguruTask->getCertificateTerm($step->pid); $scores_avg_quizzes = $guruModelguruTask->getAvgScoresQ($user->id, $step->pid); $certificates[0]["avg_cert"] = $avg_certif; $sql = "select * from #__menu where `link`='index.php?option=com_guru&view=guruprograms&layout=view'"; $db->setQuery($sql); $menu = $db->loadAssocList(); if (isset($menu["0"]) && isset($menu["0"]["id"])) { $Itemid = $menu["0"]["id"]; } $stop_next = 0; if (isset($_SESSION["stop_next"])) { $stop_next = intval($_SESSION["stop_next"]); unset($_SESSION["stop_next"]); } if ($stop_next == "1") { $step->nexts = 0; }
$completiondate = ""; } $certificateid = "SELECT id FROM #__guru_mycertificates WHERE user_id = " . intval($user_id) . " AND course_id=" . intval($course_id); $db->setQuery($certificateid); $db->query(); $certificateid = $db->loadResult(); $sitename = $config->get('sitename'); $coursemsg = "SELECT certificate_course_msg FROM #__guru_program WHERE id=" . intval($course_id); $db->setQuery($coursemsg); $db->query(); $coursemsg = $db->loadResult(); $firstnamelastname = "SELECT firstname, lastname FROM #__guru_customer WHERE id=" . intval($user_id); $db->setQuery($firstnamelastname); $db->query(); $firstnamelastname = $db->loadAssocList(); $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 hasquiz from #__guru_program WHERE id=" . intval($course_id); $db->setQuery($sql); $resulthasq = $db->loadResult(); $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"); }
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; }
$limit = $config->list_limit; $_SESSION["quiz_limit"] = $limit; } } else { $_SESSION["quiz_limit"] = $limit_request; $limit = $limit_request; } $limitstart = JRequest::getVar("limitstart", 0); $row = 0; foreach ($my_quizzes as $key => $value) { $class = "odd"; if ($k % 2 != 0) { $class = "even"; } $id = $my_quizzes[$key]["id"]; $scores_avg_quizzes = $guruModelguruTask->getAvgScoresQ($user_id, @$cid[0]); $val = $my_quizzes[$key]["pid"]; $sql = "SELECT id_final_exam FROM #__guru_program WHERE id=" . intval($val); $db->setQuery($sql); $result = $db->loadResult(); $sql = "SELECT hasquiz from #__guru_program WHERE id=" . intval($val); $db->setQuery($sql); $resulthasq = $db->loadResult(); $sqlm = "SELECT max_score FROM #__guru_quiz WHERE id=" . intval($id); $db->setQuery($sqlm); $result_maxs = $db->loadResult(); $sql = "SELECT `name`, `published` from #__guru_program WHERE id =" . intval($val); $db->setQuery($sql); $db->query(); $result = $db->loadAssocList(); $coursename = $result["0"]["name"];
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; } } }