Just to share what we have done to allow teachers to view students' grades. We basically replicated the mygrades view, the only file changed was view.html.php.
Code:
<?php
/**
* @package Joomdle
* @copyright Qontori Pte Ltd
* @license http://www.gnu.org/licenses/gpl-3.0.html GNU/GPL
*/
// no direct access
defined('_JEXEC') or die('Restricted access');
jimport( 'joomla.application.component.view');
require_once(JPATH_SITE.'/components/com_joomdle/helpers/content.php');
/**
* HTML View class for the Joomdle component
*/
class JoomdleViewStudentgrades extends JViewLegacy {
function display($tpl = null) {
global $mainframe;
$app = JFactory::getApplication();
$params = $app->getParams();
$this->assignRef('params', $params);
$user = JFactory::getUser();
$id = $user->id;
$student = $_GET['student'];
$username = $student;
$db = JFactory::getDbo();
$query3 = $db->getQuery(true);
$query3->select('cb_usertype');
$query3->from($db->quoteName('#__comprofiler'));
$query3->where($db->quoteName('id')." = " . $id);
$db->setQuery($query3);
$usertype = $db->loadResult();
if ( !in_array($usertype, ['teacher','admin'], true ) ) {
throw new Exception(JText::_('Restricted Access'), 701);
};
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('id');
$query->from($db->quoteName('#__users'));
$query->where($db->quoteName('username'). " = '" . $student . "'");
$db->setQuery($query);
$studentid = $db->loadResult();
if (!array_key_exists('8', $user->groups)) {
$db = JFactory::getDbo();
$query2 = $db->getQuery(true);
$query2->select('cb_school');
$query2->from($db->quoteName('#__comprofiler'));
$query2->where($db->quoteName('id')." = " . $id, 'OR')
->where($db->quoteName('id')." = " . $studentid);
$db->setQuery($query2);
$column= $db->loadColumn();
if ($column[0] !== $column[1]) {
throw new Exception(JText::_('Restricted Access'), 801);
};
};
$layout = $params->get('layout');
if ($layout == 'basic')
{
$this->tasks = JoomdleHelperContent::call_method ("get_my_grades", $username);
}
else
{
$this->tasks = JoomdleHelperContent::call_method ("get_my_grade_user_report", $username);
$tpl = 'cats';
}
$this->pageclass_sfx = htmlspecialchars($params->get('pageclass_sfx'));
$this->_prepareDocument();
parent::display($tpl);
}
protected function _prepareDocument()
{
$app = JFactory::getApplication();
$menus = $app->getMenu();
$title = null;
// Because the application sets a default page title,
// we need to get it from the menu item itself
$menu = $menus->getActive();
if ($menu)
{
$this->params->def('page_heading', $this->params->get('page_title', $menu->title));
} else {
$this->params->def('page_heading', JText::_('COM_JOOMDLE_MY_GRADES'));
}
}
}
?>
We added a link to view the studentgrades from their joomla profile. As the URL for joomla profile contains their username, we retrieved the last part of the URL to be input as part of the link, hence the $_GET bit at the start.
Topic Author
