$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();
