function get_content() { global $CFG, $USER, $COURSE; if (!empty($this->content)) { return $this->content; } $this->content = new stdClass(); $this->content->footer = ''; $this->content->text = ''; if (!($att = array_pop(get_all_instances_in_course('attforblock', $COURSE, NULL, true)))) { $this->content->text = get_string('needactivity', 'block_attendance'); return $this->content; } $cmid = $att->coursemodule; require_once $CFG->dirroot . '/mod/attforblock/locallib.php'; if (!($context = get_context_instance(CONTEXT_MODULE, $cmid))) { print_error('badcontext'); } // link to attendance if (has_capability('mod/attforblock:takeattendances', $context) or has_capability('mod/attforblock:changeattendances', $context)) { $this->content->text .= '<a href="' . $CFG->wwwroot . '/mod/attforblock/manage.php?id=' . $cmid . '&from=block">' . get_string('takeattendance', 'attforblock') . '</a><br />'; } if (has_capability('mod/attforblock:manageattendances', $context)) { $this->content->text .= '<a href="' . $CFG->wwwroot . '/mod/attforblock/sessions.php?id=' . $cmid . '&action=add">' . get_string('add', 'attforblock') . '</a><br />'; } if (has_capability('mod/attforblock:viewreports', $context)) { $this->content->text .= '<a href="' . $CFG->wwwroot . '/mod/attforblock/report.php?id=' . $cmid . '&view=weeks">' . get_string('report', 'attforblock') . '</a><br />'; } if (has_capability('mod/attforblock:export', $context)) { $this->content->text .= '<a href="' . $CFG->wwwroot . '/mod/attforblock/export.php?id=' . $cmid . '">' . get_string('export', 'quiz') . '</a><br />'; } if (has_capability('mod/attforblock:changepreferences', $context)) { $this->content->text .= '<a href="' . $CFG->wwwroot . '/mod/attforblock/attsettings.php?id=' . $cmid . '">' . get_string('settings', 'attforblock') . '</a><br />'; } $context2 = get_context_instance(CONTEXT_COURSE, $COURSE->id); if (has_capability('moodle/course:view', $context) && has_capability('mod/attforblock:view', $context)) { $complete = get_attendance($USER->id, $COURSE); if ($complete == 0) { //attendance not generated yet $this->content->text .= get_string('attendancenotstarted', 'attforblock'); } else { //attendance taken $statuses = get_statuses($COURSE->id); foreach ($statuses as $st) { $this->content->text .= $st->description . ': ' . get_attendance($USER->id, $COURSE, $st->id) . '<br />'; } $percent = get_percent($USER->id, $COURSE); $grade = get_grade($USER->id, $COURSE); $this->content->text .= get_string('attendancepercent', 'attforblock') . ': ' . $percent . ' %<br />'; $this->content->text .= get_string('attendancegrade', 'attforblock') . ": {$grade}<br />"; $this->content->text .= '<a href="' . $CFG->wwwroot . '/mod/attforblock/view.php?id=' . $cmid . '">' . get_string('indetail', 'attforblock') . '</a>'; } } return $this->content; }
static function getTransferStatusAjax() { @(include dirname(__FILE__) . '/config.php'); if (!$stage and $spectrum_server and $filemanager_sid) { $stage = 'start_active_mode'; } list($stage, $postinst_url) = explode(' ', $stage); if ($app_hashid) { $postinst_url = 'https://cp-spectrum.jino.ru/joomla/' . $app_hashid . '/settings/'; } if (!in_process($stage)) { self::updateCPBlockAjax($stage); } $percent = get_percent($stage, $stage_since); if ($percent) { $percent = $percent . '%'; } $mode = $filemanager_sid ? 'active' : 'passive'; return array('stage' => $stage, 'percent' => $percent, 'postinst_url' => $postinst_url, 'mode' => $mode); }
function get_subtasks($parent, $level = 1, $type = "", $where = "", $orderby = "", $bg = "", $preview = false) { //echo "$orderby<br />"; global $db, $slave, $priorities, $parent_task_id, $expand_collapse, $target_path, $total_tasks; if ($orderby != "") { $parent = null; } //if (!is_null($parent)) echo "parent is $parent"; $expand_collapse = array("expand", "collapse"); $creator_id = $_SESSION['user_id']; if ($_SESSION['project_user_id']) { $creator_id = $_SESSION['project_user_id']; } if (($_GET['today'] or $_GET['user_id'] or $_GET['week']) and ($_GET['action'] != "complete" and $_GET['action'] != "log")) { $where2 = "LEFT OUTER JOIN Task_Acknowledgement as A ON T.Task_ID=A.Task_ID WHERE (A.Accepted=1 OR T.Creator_ID=" . $creator_id . ") AND "; } else { $where2 = "LEFT OUTER JOIN Task_Acknowledgement as A ON T.Task_ID=A.Task_ID WHERE "; } //$where2="WHERE "; if (!is_null($parent)) { if (strlen($where) == 4) { $where = ""; } if ($parent === 0) { if ($_GET['assign']) { $where2 = $where2 . "(Parent_Task_ID={$parent} OR Parent_Task_ID NOT IN (SELECT Task_ID FROM Tasks as T2 LEFT OUTER JOIN User_Departments as D2 ON T2.Department_ID=D2.Department_ID LEFT OUTER JOIN Users as L2 ON D2.User_ID=L2.User_ID WHERE " . str_replace(".", "2.", substr($where, 4)) . ")) {$where}"; } else { $where2 = $where2 . "(Parent_Task_ID={$parent} OR Parent_Task_ID NOT IN (SELECT Task_ID FROM Tasks as T2 LEFT OUTER JOIN User_Departments as D2 ON T2.Department_ID=D2.Department_ID LEFT OUTER JOIN Users as U2 ON D2.User_ID=U2.User_ID WHERE " . str_replace(".", "2.", substr($where, 4)) . ")) {$where}"; } } else { $where2 = $where2 . "Parent_Task_ID={$parent} {$where}"; } } else { $where2 = $where2 . substr($where, 4); } //$where2=$where2."T.Task_ID NOT IN (SELECT Parent_Task_ID FROM Tasks) $where"; //if (is_null($parent) AND $subtasks[$t]['Parent_Task_ID']>0) if ($type == "complete" and $orderby == "") { $orderby = "Log_date DESC, Task_Name"; } //else if ($orderby=="" and $parent==0) $orderby="Task_Name"; //else if ($orderby!="") $orderby=$orderby." Task_Name"; if ($orderby and !strstr($orderby, "Task_Name")) { $orderby = "ORDER BY " . $orderby . " Task_Name"; } if ($orderby and !strstr($orderby, "ORDER BY")) { $orderby = "ORDER BY " . $orderby; } if (!$orderby and $parent == 0) { $orderby2 = "ORDER BY Finish_Date IS NULL, Finish_Date"; } if (!strstr($where, "L.User_ID")) { $log = "AND L.Log_Progress=100"; } if (strstr($orderby, "Request_Username")) { $orderby = str_replace("Request_Username", "RL.Username", $orderby); $query = "SELECT T.*, Project_Name, Log_Date, AD.Department_Name as Affected_Department_Name, RL.Username FROM Login as RL, Users as U, Tasks as T LEFT OUTER JOIN Departments as AD ON T.Affected_Department=AD.Department_ID LEFT OUTER JOIN Projects as P ON T.Project_ID=P.Project_ID LEFT OUTER JOIN Task_Logs as L ON T.Task_ID=L.Task_ID {$log} LEFT OUTER JOIN User_Departments as D ON T.Department_ID=D.Department_ID LEFT OUTER JOIN Departments as M ON D.Department_ID=M.Department_ID LEFT OUTER JOIN Login as G ON T.User_ID=G.User_ID {$where2} AND U.User_ID=T.Request_User_ID AND U.User_ID=RL.User_ID GROUP BY T.Task_ID {$orderby} {$orderby2}"; //echo $query; } elseif (strstr($orderby, "Username")) { $query = "SELECT T.*, Project_Name, Log_Date, AD.Department_Name as Affected_Department_Name FROM Tasks as T LEFT OUTER JOIN Departments as AD ON T.Affected_Department=AD.Department_ID LEFT OUTER JOIN Projects as P ON T.Project_ID=P.Project_ID LEFT OUTER JOIN Task_Logs as L ON T.Task_ID=L.Task_ID {$log} LEFT OUTER JOIN User_Departments as D ON T.Department_ID=D.Department_ID LEFT OUTER JOIN Departments as M ON D.Department_ID=M.Department_ID LEFT OUTER JOIN Users as U ON D.User_ID=U.User_ID LEFT OUTER JOIN Login as G ON T.User_ID=G.User_ID {$where2} GROUP BY T.Task_ID {$orderby} {$orderby2}"; } else { $query = "SELECT T.*, Project_Name, Log_Date, AD.Department_Name as Affected_Department_Name FROM Tasks as T LEFT OUTER JOIN Departments as AD ON T.Affected_Department=AD.Department_ID LEFT OUTER JOIN Projects as P ON T.Project_ID=P.Project_ID LEFT OUTER JOIN Task_Logs as L ON T.Task_ID=L.Task_ID {$log} LEFT OUTER JOIN User_Departments as D ON T.Department_ID=D.Department_ID LEFT OUTER JOIN Users as U ON D.User_ID=U.User_ID {$where2} GROUP BY T.Task_ID {$orderby} {$orderby2}"; } //echo $query; //exit; $subtasks = $slave->select($query); //where parents are not assigned to user if (is_null($parent)) { $query = "SELECT T.*, Project_Name, Log_Date, AD.Department_Name as Affected_Department_Name FROM Tasks as T LEFT OUTER JOIN Departments as AD ON T.Affected_Department=AD.Department_ID LEFT OUTER JOIN Projects as P ON T.Project_ID=P.Project_ID LEFT OUTER JOIN Task_Logs as L ON T.Task_ID=L.Task_ID {$log} LEFT OUTER JOIN User_Departments as D ON T.Department_ID=D.Department_ID LEFT OUTER JOIN Users as U ON D.User_ID=U.User_ID {$where2} GROUP BY T.Task_ID {$orderby} {$orderby2}"; } /* $query="SELECT T.*, Project_Name, Log_Date FROM Tasks as T LEFT OUTER JOIN Projects as P ON T.Project_ID=P.Project_ID LEFT OUTER JOIN Task_Logs as L ON T.Task_ID=L.Task_ID $log LEFT OUTER JOIN User_Departments as D ON T.Department_ID=D.Department_ID LEFT OUTER JOIN Users as U ON D.User_ID=U.User_ID $where2 AND Finish_Date IS NULL GROUP BY T.Task_ID ORDER BY $orderby Task_Name"; $subtasks2 = $slave->select($query); if ($subtasks2) { if ($subtasks) $subtasks=array_merge($subtasks,$subtasks2); else $subtasks=$subtasks2; } */ //if ($_SESSION['user_id']==6) print_r($subtasks); $expand = true; if ($level == 0 and $type != "option") { if ($type == "date") { echo "<form action=\"tasks.php\" method=\"GET\" onSubmit=\"this.today.value=this.today.value.replace(/(\\d\\d)\\/(\\d\\d)\\/(\\d\\d\\d\\d)/, '\$3-\$1-\$2')\">\n"; echo "View Date <input name=\"today\" type=\"text\" value=\"" . display_date($_GET['today']) . "\" onfocus=\"this.select();lcs(this)\" onclick=\"event.cancelBubble=true;this.select();lcs(this)\"/>"; echo "<input type=\"submit\" value=\"Go\">"; echo "</form>\n"; } if ($type != "complete") { echo "<div id=\"expand\">"; $expand = false; if ($_SESSION['expand']['all'] == 1) { echo "<a href=\"" . clean_url($expand_collapse) . "expand=none\"><img src=\"" . CDN . "img/collapse.png\" alt=\"Collapse\" /></a>"; } else { echo "<a href=\"" . clean_url($expand_collapse) . "expand=all\"><img src=\"" . CDN . "img/expand.png\" alt=\"Expand\" /></a>"; } echo " all</div>\n"; } } if ($subtasks) { if ($level == 0 and $type != "option") { echo "<table><tr>"; //if ($type!="complete") echo "<th><a href=".get_order_url('T.Progress',$dir).">Work</a></th>"; echo "<th> </th>"; echo "<th><a href=" . get_order_url('T.Priority', $dir) . ">Severity</a></th>"; echo "<th><a href=" . get_order_url('T.Task_ID', $dir) . ">ID</a></th>"; echo "<th><a href=" . get_order_url('Task_Name', $dir) . ">Task</a></th>"; echo "<th><a href=" . get_order_url('Project_Name', $dir) . ">Project</a></th>"; echo "<th><a href=" . get_order_url('Affected_Department_Name', $dir) . ">Department</a></th>"; echo "<th>File</th>"; echo "<th><a href=" . get_order_url('Username', $dir) . ">Assigned</a></th>"; echo "<th>Last</th>"; echo "<th><a href=" . get_order_url('Request_Username', $dir) . ">Request</a></th>"; echo "<th nowrap><a href=" . get_order_url('T.Request_Date', $dir) . ">Req Date</a></th>"; if ($type == "complete") { echo "<th><a href=" . get_order_url('L.Log_Date', $dir) . ">Completed</a></th>"; } else { echo "<th><a href=" . get_order_url('T.Finish_Date', $dir) . ">Due</a></th>"; } if ($type != "complete") { echo "<th>Days</th>"; } echo "</tr>\n"; } $space = str_repeat(' ', $level); $ptid = 0; for ($t = 0; $t < count($subtasks); $t++) { $total_tasks[$priorities[$subtasks[$t]['Priority']]['Name']]++; if ($type != "option" and $type != "complete" and (is_null($parent) or $parent === 0) and $subtasks[$t]['Parent_Task_ID'] > 0 and $subtasks[$t]['Parent_Task_ID'] != $ptid) { $ptid = $subtasks[$t]['Parent_Task_ID']; echo "<tr {$bg} class=\"gray\">"; echo "<td> </td>"; echo "<td> </td>"; echo "<td> </td>"; echo "<td colspan=\"10\"><small>"; get_parent($ptid, true); echo "</small></td>"; echo "</tr>\n"; } else { $ptid = $subtasks[$t]['Parent_Task_ID']; } $small_img = $use_file = ""; $expand = false; if ($preview == true or !$_SESSION['expand'] or $_SESSION['expand']['all'] == 1 and (!isset($_SESSION['expand'][$subtasks[$t]['Task_ID']]) or $_SESSION['expand'][$subtasks[$t]['Task_ID']] != 0) or $_SESSION['expand']['all'] == 0 and $_SESSION['expand'][$subtasks[$t]['Task_ID']] == 1) { $expand = true; } if ($type == "option") { echo "<option value=\"" . $subtasks[$t]['Task_ID'] . "\""; if ($subtasks[$t]['Task_ID'] == $parent_task_id) { echo " selected"; } echo ">" . $space . $subtasks[$t]['Task_Name'] . "</option>\n"; } else { $num_sub = 0; $percent_sub = $subtasks[$t]['Progress']; if ($type == "complete") { $finish_date = $subtasks[$t]['Log_Date']; } else { $finish_date = $subtasks[$t]['Finish_Date']; } //if (!is_null($parent)) list($num_sub, $percent_sub, $finish_date) = get_percent($subtasks[$t]['Task_ID'], $num_sub, $percent_sub, $finish_date); //$finish_date=$subtasks[$t]['Finish_Date']; //if ($subtasks[$t]['Log_Date']) $finish_date=$subtasks[$t]['Log_Date']; //if ($level==0) { // if ($t%2==0) $bg="class=\"highlight\""; // else $bg=""; //} //$haschildren=$slave->select("SELECT * FROM Tasks WHERE Parent_Task_ID=".$subtasks[$t]['Task_ID']); //$users=$slave->select("SELECT IF (UD.User_ID IS NOT NULL, UD.User_ID, U.User_ID) AS User_ID, Username, U.First_Name, U.Last_Name, Department_Name FROM Task_Users as T LEFT OUTER JOIN User_Departments as UD ON T.Department_ID=UD.Department_ID AND UD.User_ID=6 LEFT OUTER JOIN Departments as D ON UD.Department_ID=D.Department_ID LEFT OUTER JOIN Users as U ON T.User_ID=U.User_ID AND U.User_ID=6 LEFT OUTER JOIN Login as L ON U.User_ID=L.User_ID WHERE Task_ID=".$subtasks[$t]['Task_ID']." ORDER BY IF (Department_Name IS NOT NULL, Department_Name, Username)"); //if ((!$haschildren AND $user) OR ($haschildren)) { echo "<tr {$bg}>"; //if ($type!="complete") { echo "<td align='right' nowrap>"; if (!$preview and $num_sub > 0) { //echo number_format($percent_sub/$num_sub,1)."% "; if ($expand == true) { echo "<a href=\"" . clean_url($expand_collapse) . "collapse=" . $subtasks[$t]['Task_ID'] . "\" class=\"expand\"><img src=\"" . CDN . "img/collapse.png\" alt=\"Collapse\" /></a>"; } else { echo "<a href=\"" . clean_url($expand_collapse) . "expand=" . $subtasks[$t]['Task_ID'] . "\" class=\"expand\"><img src=\"" . CDN . "img/expand.png\" alt=\"Expand\" /></a>"; } } //else if ($type=="complete") echo $percent_sub."%"; //else echo $percent_sub."%"; //if ($percent_sub<100) echo " | <a href=\"tasks.php?work=".$subtasks[$t]['Task_ID']."\">Add</a>"; echo "</td>"; //} if ($preview) { echo "<td></td><td></td>\n"; } else { echo "<td nowrap><small>"; if ($subtasks[$t]['High_Priority']) { echo "<img src=\"" . CDN . "img/fire.png\" alt=\"High Priority\" />\n"; } echo $subtasks[$t]['Priority'] . " " . $priorities[$subtasks[$t]['Priority']]['Name'] . "</small></td>"; echo "<td><small>" . $subtasks[$t]['Task_ID'] . "</small></td>"; } echo "<td>"; if ($preview) { echo "<small>"; } if ($type != "complete" and $level > 0) { echo "{$space} - "; } elseif (is_null($parent) and $subtasks[$t]['Parent_Task_ID'] > 0) { echo "{$space} - "; //echo "…"; } echo "<a href=\"tasks.php?task_id=" . $subtasks[$t]['Task_ID'] . "\""; if ($subtasks[$t]['Parent_Task_ID'] > 0) { $pname = $slave->select("SELECT Task_Name FROM Tasks WHERE Task_ID=" . $subtasks[$t]['Parent_Task_ID']); echo "title=\"" . $pname[0]['Task_Name'] . "\""; } if ($subtasks[$t]['Progress'] == 100) { echo "><strike>" . $subtasks[$t]['Task_Name'] . "</strike></a>"; } else { echo ">" . $subtasks[$t]['Task_Name'] . "</a>"; } //get_child($subtasks[$t]['Task_ID'],true); if ($preview) { echo "</small>"; } echo "</td>"; echo "<td nowrap>"; if ($subtasks[$t]['Project_ID']) { echo "<small><a href=\"projects.php?project_id=" . $subtasks[$t]['Project_ID'] . "\">" . $subtasks[$t]['Project_Name'] . "</a></small></td>"; } else { echo "<small>Non Project Ticket</small>"; } echo "</td>"; echo "<td nowrap><small>"; if ($subtasks[$t]['Affected_Department'] > 0) { //$afdep=$slave->select("SELECT Department_Name FROM Departments WHERE Department_ID=".$subtasks[$t]['Affected_Department']); echo $subtasks[$t]['Affected_Department_Name']; } else { echo "No Department"; } echo "</small></td>"; echo "<td align=\"center\">"; /* if ($handle = opendir($target_path)) { while (false !== ($file = readdir($handle))) { if (preg_match('/^'.$subtasks[$t]['Task_ID'].'.+/',$file)) { if (strstr($file,'_sm.jpg')) $small_img=$file; else $use_file=$file; } } closedir($handle); } else echo "could not open"; if ($small_img) echo "<a href=\"${target_path}$use_file\" target=\"_blank\"><img src=\"".CDN."img/icons/111.png\" border=0 /></a>"; else if ($use_file) echo "<a href=\"${target_path}$use_file\" target=\"_blank\"><img src=\"".CDN."img/icons/3.png\" border=0 /></a>"; */ $files = $slave->select("SELECT * FROM Files as F, File_Types as T WHERE F.File_Type_ID=T.File_Type_ID AND Task_ID=" . $subtasks[$t]['Task_ID'] . " ORDER BY Image"); if ($files) { $img = $multi = ""; foreach ($files as $f) { if ($img != $f['Image'] or $img == 0) { $img = $f['Image']; if ($f['Image'] == 1) { $icon = "111.png"; echo "<a href=\"" . CDN . "img.php?id=" . $subtasks[$t]['Task_ID'] . "\" alt=\"\" target=\"_blank\"><img src=\"" . CDN . "img/icons/{$icon}\" border=0 /></a>"; } else { $icon = "3.png"; echo "<a href=\"{$target_path}" . $f['File_ID'] . "." . $f['Extention'] . "\" alt=\"\" target=\"_blank\"><img src=\"" . CDN . "img/icons/{$icon}\" border=0 /></a>"; } } elseif ($img == 1) { $mult = "+"; } } echo $mult; } echo "</td>"; echo "<td><small>"; $users = $slave->select("SELECT IF (UD.User_ID IS NOT NULL, UD.User_ID, U.User_ID) AS User_ID, Username, U.First_Name, U.Last_Name, Department_Name FROM Tasks as T LEFT OUTER JOIN User_Departments as UD ON T.Department_ID=UD.Department_ID LEFT OUTER JOIN Departments as D ON UD.Department_ID=D.Department_ID LEFT OUTER JOIN Users as U ON T.User_ID=U.User_ID LEFT OUTER JOIN Login as L ON U.User_ID=L.User_ID WHERE Task_ID=" . $subtasks[$t]['Task_ID'] . " ORDER BY IF (Department_Name IS NOT NULL, Department_Name, Username)"); if ($users) { $dep = ""; for ($u = 0; $u < count($users); $u++) { if ($u > 0 && ($users[$u]['Department_Name'] == "" or $users[$u]['Department_Name'] != $dep)) { echo ", "; } if ($users[$u]['Department_Name']) { if ($users[$u]['Department_Name'] != $dep) { $dep = $users[$u]['Department_Name']; echo $users[$u]['Department_Name']; } } else { echo $users[$u]['Username']; } } } else { echo "none"; } echo "</small></td>"; echo "<td><small>"; $users = $slave->select("SELECT U.User_ID, Username, U.First_Name, U.Last_Name FROM Tasks as T, Task_Logs as L, Users as U, Login as O WHERE T.Task_ID=L.Task_ID AND L.User_ID=U.User_ID AND O.User_ID=U.User_ID AND T.Task_ID=" . $subtasks[$t]['Task_ID'] . " ORDER BY Log_ID DESC LIMIT 1"); if (!$users) { $users = $slave->select("SELECT U.User_ID, Username, U.First_Name, U.Last_Name FROM Tasks as T, Users as U, Login as O WHERE T.Creator_ID=U.User_ID AND O.User_ID=U.User_ID AND T.Task_ID=" . $subtasks[$t]['Task_ID']); } if ($users) { echo $users[0]['Username']; } else { echo "none"; } echo "</small></td>"; echo "<td><small>"; $users = $slave->select("SELECT U.User_ID, Username, U.First_Name, U.Last_Name FROM Tasks as T, Users as U, Login as L WHERE U.User_ID=L.User_ID AND T.Request_User_ID=U.User_ID AND Task_ID=" . $subtasks[$t]['Task_ID']); if ($users) { echo $users[0]['Username']; } else { echo "none"; } echo "</small></td>"; if (display_date($subtasks[$t]['Request_Date']) == "00/00/0000" or display_date($subtasks[$t]['Request_Date']) == "NULL") { echo "<td>Not Set</td>"; } else { echo "<td><small>" . display_date($subtasks[$t]['Request_Date']) . "</small></td>"; } //echo "<td>".$subtasks[$t]['Durration']."</td>"; //$isparent=$slave->select("SELECT Task_ID FROM Tasks WHERE Parent_Task_ID=".$subtasks[$t]['Task_ID']); //if ($isparent) { // echo "<td> </td>"; //} else if (display_date($finish_date) == "NULL") { echo "<td><small>Not Set</small></td>"; if ($type != "complete") { echo "<td>-</td>"; } } else { echo "<td><small>" . display_date($finish_date) . "</small></td>"; if ($type != "complete" and $subtasks[$t]['Progress'] < 100) { echo "<td><small>" . dateDiff(date("Y-m-d"), $finish_date) . "</small></td>"; } } echo "</tr>\n"; if ($expand == true and ($_GET['today'] or $_GET['week']) and !isset($parent_task_id)) { get_subtasks($subtasks[$t]['Task_ID'], $level + 1, "", "AND T.Progress<100", "", "class=\"gray\"", true); } if ($expand == true and $parent === 0) { get_subtasks($subtasks[$t]['Task_ID'], $level + 1, "", "AND T.Progress<100 AND NOT (T.User_ID=" . $_SESSION['user_id'] . " OR U.User_ID=" . $_SESSION['user_id'] . ")", "", "class=\"gray\"", true); } //} } if ($expand === true and !is_null($parent) and !$preview) { get_subtasks($subtasks[$t]['Task_ID'], $level + 1, $type, $where, $orderby, $bg); } //if ($add=="no") //$space=str_replace('/ $/','',$space); } if ($level == 0 and $type != "option") { echo "</table>"; echo "<p>"; $totaltt = 0; foreach ($total_tasks as $tk => $tv) { echo "Total {$tk} Tasks: {$tv}<br />"; $totaltt = $totaltt + $tv; } echo "Grand Total: {$totaltt}"; echo "</p>\n"; } } else { if ($level == 0 and $type != "option") { echo "<h2 align=\"center\">No Tasks</h2>"; } return false; } }
} function isCoordinator($student, $session) { if ($session['coordinator'] == "1" && $session['year_pass'] == $student['year_pass']) { return true; } else { return false; } } $output = array(); //print_r($students_search); foreach ($students_search as $student) { $enc_usr = $this->encrypt->encode($student["username"] . "@#\$"); //print_r($marks_search); $cgpa = get_cgpa($student["regno"], $marks_search); $percent = get_percent($student["regno"], $marks_search); $arrier = get_arrier($student["regno"], $marks_search); //echo "perc:".$percent; if (!($percent >= $this->input->post('percent_min') && $percent <= $this->input->post('percent_max'))) { // echo "here"; continue; } if (!($cgpa >= $this->input->post('cgpa_min') && $cgpa <= $this->input->post('cgpa_max'))) { // echo "here"; continue; } if (!($arrier >= $this->input->post('arrier_min') && $arrier <= $this->input->post('arrier_max'))) { // echo "here1"; continue; } $privacy_settings = array("privacy_profile_pic" => $student["privacy_profile_pic"], "privacy_personal" => $student["privacy_personal"], "privacy_academic" => $student["privacy_academic"], "privacy_resume" => $student["privacy_resume"]);
<div class="container"> <input id="year_pass" name="year_pass" type="hidden" value="<?php echo $session["year_pass"]; ?> "> <div class="row about"> <div class="col-md-12"> <div id="container_id" class="home_steps well text-justify noborder"> <h2>Marks</h2> <br> <br> <?php if (isset($marks_details[0])) { ?> <h4 class="text-center">Percentage : <?php echo get_percent($marks_details[0]['regno'], $marks_details); ?> %</h4> <h4 class="text-center">CGPA : <?php echo get_cgpa($marks_details[0]['regno'], $marks_details); ?> </h4> <h4 class="text-center">Arriers : <?php echo get_arriers($marks_details[0]['regno'], $marks_details); ?> </h4> <br> <br> <?php } ?>
/** * Return grade for given user or all users. * * @param int $attforblockid id of attforblock * @param int $userid optional user id, 0 means all users * @return array array of grades, false if none */ function attforblock_get_user_grades($attforblock, $userid = 0) { global $CFG; require_once 'locallib.php'; if (!($course = get_record('course', 'id', $attforblock->course))) { error("Course is misconfigured"); } $result = false; if ($userid) { $result = array(); $result[$userid]->userid = $userid; $result[$userid]->rawgrade = $attforblock->grade * get_percent($userid, $course) / 100; } else { if ($students = get_course_students($course->id)) { $result = array(); foreach ($students as $student) { $result[$student->id]->userid = $student->id; $result[$student->id]->rawgrade = $attforblock->grade * get_percent($student->id, $course) / 100; } } } return $result; }
function print_attendance_table($user, $course) { $complete = get_attendance($user->id, $course); $percent = get_percent($user->id, $course) . ' %'; $grade = get_grade($user->id, $course); echo '<table border="0" cellpadding="0" cellspacing="0" class="list">'; attendance_print_row(get_string('sessionscompleted', 'attforblock') . ':', "<strong>{$complete}</strong>"); $statuses = get_statuses($course->id); foreach ($statuses as $st) { attendance_print_row($st->description . ': ', '<strong>' . get_attendance($user->id, $course, $st->id) . '</strong>'); } attendance_print_row(get_string('attendancepercent', 'attforblock') . ':', "<strong>{$percent}</strong>"); attendance_print_row(get_string('attendancegrade', 'attforblock') . ':', "<strong>{$grade}</strong> / " . get_maxgrade($user->id, $course)); attendance_print_row(' ', ' '); echo '</table>'; }
$table->data[$student->id][] = print_user_picture($student->id, $course->id, $student->picture, 20, true, true); $table->data[$student->id][] = "<a href=\"view.php?id={$id}&student={$student->id}\">" . fullname($student) . '</a>'; foreach ($course_sess as $sessdata) { if ($att = get_record('attendance_log', 'sessionid', $sessdata->id, 'studentid', $student->id)) { if (isset($statuses[$att->statusid])) { $table->data[$student->id][] = $statuses[$att->statusid]->acronym; } else { $table->data[$student->id][] = '<font color="red"><b>' . $allstatuses[$att->statusid]->acronym . '</b></font>'; } } else { $table->data[$student->id][] = '-'; } } foreach ($statuses as $st) { $table->data[$student->id][] = get_attendance($student->id, $course, $st->id); } $table->data[$student->id][] = get_grade($student->id, $course) . ' / ' . get_maxgrade($student->id, $course); $table->data[$student->id][] = get_percent($student->id, $course) . '%'; } echo '<br />'; print_table($table); } else { print_heading(get_string('nothingtodisplay'), 'center'); } echo get_string('status', 'attforblock') . ':<br />'; foreach ($statuses as $st) { echo $st->acronym . ' - ' . $st->description . '<br />'; } } print_footer($course); exit;
if (isset($fromform->ident['id'])) { $data->table[$i][] = $student->id; } if (isset($fromform->ident['uname'])) { $data->table[$i][] = $student->username; } $data->table[$i][] = $student->lastname; $data->table[$i][] = $student->firstname; foreach ($sessions as $sess) { if ($rec = $DB->get_record('attendance_log', array('sessionid' => $sess->id, 'studentid' => $student->id))) { $data->table[$i][] = $statuses[$rec->statusid]->acronym; } else { $data->table[$i][] = '-'; } } $data->table[$i][] = get_percent($student->id, $course) . '%'; $i++; } if ($fromform->format === 'text') { ExportToCSV($data, $filename); } else { ExportToTableEd($data, $filename, $fromform->format); } exit; } else { print_error('Students not found!', 'report.php?id=' . $id); } } else { /// Print headers $navlinks[] = array('name' => $attforblock->name, 'link' => "view.php?id={$id}", 'type' => 'activity'); $navlinks[] = array('name' => get_string('export', 'quiz'), 'link' => null, 'type' => 'activityinstance');
function print_query_table($field_title, $db_field, $contrib_hash) { global $total_hash; print "<table border=\"1\" width=100%\n"; print "<tr>\n"; print "<th align=center bgcolor='" . THCOLOR . "'>\n"; print $field_title . "\n"; print "</th>\n"; print "<th align=center colspan=2 bgcolor='" . LYELLOW . "'>\n"; print "MPI Installs\n"; print "</th>\n"; print "<th align=center colspan=2 bgcolor='" . LGREEN . "'>\n"; print "Test Builds\n"; print "</th>\n"; print "<th align=center colspan=2 bgcolor='" . LRED . "'>\n"; print "Test Runs\n"; print "</th>\n"; print "<th align=center colspan=2 bgcolor='" . LBLUE . "'>\n"; print "Performance Runs\n"; print "</th>\n"; print "<tr>\n"; print "<th align=center bgcolor='" . THCOLOR . "'>\n"; print " \n"; print "</th>\n"; for ($i = 0; $i < 4; ++$i) { print "<th align=center bgcolor='" . THCOLOR . "'>\n"; print "# Tests\n"; print "</th>\n"; print "<th align=center bgcolor='" . THCOLOR . "'>\n"; print "% Contrib\n"; print "</th>\n"; } print "</tr>\n"; for ($i = 0; $i < sizeof($contrib_hash); ++$i) { print "<tr>\n"; print "<td align=right>\n"; if (0 < strlen($contrib_hash[$i][$db_field])) { print $contrib_hash[$i][$db_field] . "\n"; } else { print "Unknown\n"; } print "</td>\n"; print "<td align=right bgcolor='" . LYELLOW . "'>\n"; print pretty_print_big_num($contrib_hash[$i]["mpi_install"]) . "\n"; print "</td>\n"; print "<td align=right bgcolor='" . LYELLOW . "'>\n"; printf("%4.1f %s\n", get_percent($contrib_hash[$i]["mpi_install"], $total_hash[0]["mpi_install"]), "%"); print "</td>\n"; print "<td align=right bgcolor='" . LGREEN . "'>\n"; print pretty_print_big_num($contrib_hash[$i]["test_build"]) . "\n"; print "</td>\n"; print "<td align=right bgcolor='" . LGREEN . "'>\n"; printf("%4.1f %s\n", get_percent($contrib_hash[$i]["test_build"], $total_hash[0]["test_build"]), "%"); print "</td>\n"; print "<td align=right bgcolor='" . LRED . "'>\n"; print pretty_print_big_num($contrib_hash[$i]["test_run"]) . "\n"; print "</td>\n"; print "<td align=right bgcolor='" . LRED . "'>\n"; printf("%4.1f %s\n", get_percent($contrib_hash[$i]["test_run"], $total_hash[0]["test_run"]), "%"); print "</td>\n"; print "<td align=right bgcolor='" . LBLUE . "'>\n"; print pretty_print_big_num($contrib_hash[$i]["perf"]) . "\n"; print "</td>\n"; print "<td align=right bgcolor='" . LBLUE . "'>\n"; printf("%4.1f %s\n", get_percent($contrib_hash[$i]["perf"], $total_hash[0]["perf"]), "%"); print "</td>\n"; print "</tr>\n"; } print "<tr><b>\n"; print "<th align=right>\n"; print "Total\n"; print "</th>\n"; print "<th align=right>\n"; print pretty_print_big_num($total_hash[0]["mpi_install"]) . "\n"; print "</th>\n"; print "<th align=right>\n"; print "100.0 %\n"; print "</th>\n"; print "<th align=right>\n"; print pretty_print_big_num($total_hash[0]["test_build"]) . "\n"; print "</th>\n"; print "<th align=right>\n"; print "100.0 %\n"; print "</th>\n"; print "<th align=right>\n"; print pretty_print_big_num($total_hash[0]["test_run"]) . "\n"; print "</th>\n"; print "<th align=right>\n"; print "100.0 %\n"; print "</th>\n"; print "<th align=right>\n"; print pretty_print_big_num($total_hash[0]["perf"]) . "\n"; print "</th>\n"; print "<th align=right>\n"; print "100.0 %\n"; print "</th>\n"; print "</tr>\n"; print "</table>\n"; }
foreach ($statuses as $st) { echo '<th>' . $st->description . '</th>'; } echo '<th>' . get_string('grade') . '</th>'; echo '<th>%</th></tr><tr><td></td>'; echo '</tr></thead>'; echo '<tbody><tr>'; echo '<td id="tshowstudent" name="tshowstudent">'; echo "<a href=\"view.php?id={$id}&student={$student->id}\">" . fullname($student); echo '</a></td><td id="tshowcourse" name="tshowcourse">'; echo "<a href=\"{$CFG->wwwroot}/course/view.php?id={$course->id}\">" . $course->fullname . '</a></td>'; foreach ($statuses as $st) { echo '<td>' . get_attendance($student->id, $course, $st->id) . '</td>'; } echo '<td>' . get_grade($studentselected, $course) . ' / ' . get_maxgrade($student->id, $course) . '</td>'; echo '<td>' . get_percent($studentselected, $course) . '%' . '</td>'; echo '</tr></tbody></table>'; } if ($reportselected === 'all' or $reportselected === 'detailed') { echo '<h3>' . "<a href=\"{$CFG->wwwroot}/course/view.php?id={$course->id}\">" . $course->fullname . '</a></h3>'; print_detailed_report($studentselected, $cm, $course->id); } } } } } if ($reportselected === 'detailed') { echo '</table>'; } } print_footer($course);
/** * Return grade for given user or all users. * * @param int $attforblockid id of attforblock * @param int $userid optional user id, 0 means all users * @return array array of grades, false if none */ function attforblock_get_user_grades($attforblock, $userid = 0) { global $CFG, $DB; require_once 'locallib.php'; if (!($course = $DB->get_record('course', array('id' => $attforblock->course)))) { error("Course is misconfigured"); } $result = false; if ($userid) { $result = array(); $result[$userid]->userid = $userid; $result[$userid]->rawgrade = $attforblock->grade * get_percent($userid, $course) / 100; } else { $sql = "SELECT u.id\n FROM {user} u \n INNER JOIN {role_assignments} ra on u.id=ra.userid \n INNER JOIN {role_capabilities} rc ON ra.roleid=rc.roleid \n INNER JOIN {context} c ON c.id=ra.contextid \n LEFT OUTER JOIN {user_lastaccess} ul on ul.userid=ra.userid\n WHERE rc.contextid = ?"; //if ($students = get_course_students($course->id)) { if ($students = $DB->get_records_sql($sql, array($course->id))) { $result = array(); foreach ($students as $student) { $result[$student->id]->userid = $student->id; $result[$student->id]->rawgrade = $attforblock->grade * get_percent($student->id, $course) / 100; } } } return $result; }
function print_attendance_line($student, $course) { echo '<table class="generaltable"><thead><tr>'; foreach ($statuses as $st) { echo '<th>' . $st->description . '</th>'; } echo '<th>' . get_string('grade') . '</th>'; echo '<th>%</th></tr><tr><td></td>'; echo '</tr></thead><tbody><tr>'; foreach ($statuses as $st) { echo '<td>' . get_attendance($student->id, $course, $st->id) . '</td>'; } echo '<td>' . get_grade($student, $course) . ' / ' . get_maxgrade($student->id, $course) . '</td>'; echo '<td>' . get_percent($student, $course) . '%' . '</td>'; echo '</tr></tbody></table>'; }
function get_post_viewed_coverage($view_type = 'normal', $time_span = 'total', $output_type = 'content', $direction = '+', $percent = '') { global $wpdb; $post_count = $wpdb->get_var($wpdb->prepare("SELECT count(ID) FROM " . WP_POST_TABLE . " where post_date < '" . current_time('mysql') . "' AND post_status = 'publish' AND post_password = ''", APP_POST_TYPE)); $need_count = get_post_viewed_count($view_type, $time_span, $output_type); if ($direction == '+') { if ($percent == '%') { return get_percent($need_count / $post_count); } else { if ($percent == '100') { return ceil($need_count / $post_count * 100); } else { return number_format($need_count / $post_count, 2, '.', ''); } } } else { if ($percent == '%') { return get_percent(1 - $need_count / $post_count); } else { if ($percent == '100') { return ceil((1 - $need_count / $post_count) * 100); } else { return number_format(1 - $need_count / $post_count, 2, '.', ''); } } } }