$id_price = array(); $id = array(); if (trim($order["courses"]) != "") { $temp1 = explode("|", trim($order["courses"])); if (is_array($temp1) && count($temp1) > 0) { foreach ($temp1 as $key => $value) { $temp2 = explode("-", $value); $id[] = trim($temp2["0"]); $id_price[trim($temp2["0"])]["price"] = trim($temp2["1"]); //$id_price[trim($temp2["0"])]["quantity"] = trim($temp2["2"]); } } } $courses = ""; if (isset($id) && count($id) > 0) { $courses = $guruModelguruOrder->getCourses(implode(",", $id)); } if (isset($courses) && is_array($courses) && count($courses) > 0) { $i = 0; $k = 1; foreach ($courses as $key => $value) { $price = $id_price[$value["id"]]["price"]; $total_courses_price += (double) $price; ?> <tr class="<?php echo "row" . $i; ?> "> <td><?php echo $value["name"];
// stop calculate sum for all quizes from course------------------------------------ $sql = "SELECT hasquiz FROM #__guru_program\r\n WHERE id =" . intval($id); $db->setQuery($sql); $db->query(); $nb_ofscores = $db->loadColumn(); $nb_ofscores = @$nb_ofscores[0]; if ($nb_ofscores != 0) { $scores_avg_quizzes = intval($s / $nb_ofscores); } $certterm = $my_courses[$key]["certerm"]; if (!in_array($id, $already_edited)) { $already_edited[] = $id; ?> <td class="g_cell_1"> <?php $course_details = $guruModelguruOrder->getCourses($id); $certificateid = $guruModelguruOrder->getCertificateId($user_id, $id); $author_name = "SELECT name FROM #__users WHERE id IN (SELECT author_id from #__guru_mycertificates where course_id=" . intval($id) . " and user_id=" . intval($user_id) . ") "; $db->setQuery($author_name); $author_name = $db->loadColumn(); $author_name = implode(", ", $author_name); $date_completed = "SELECT datecertificate from #__guru_mycertificates where course_id=" . intval($id) . " and user_id=" . intval($user_id); $db->setQuery($date_completed); $date_completed = $db->loadResult(); $datetype = "SELECT datetype from #__guru_config WHERE id=1"; $db->setQuery($datetype); $datetype = $db->loadResult(); $date_completed = date($datetype, strtotime($date_completed)); $sql = "SELECT id_final_exam FROM #__guru_program WHERE id=" . intval($id); $db->setQuery($sql); $result = $db->loadResult();