function JLMS_edit_event($option, $id)
{
global $JLMS_DB, $Itemid, $my, $JLMS_CONFIG;
$id = $JLMS_CONFIG->get('course_id');
$agenda_id = intval(mosGetParam($_REQUEST, 'agenda_id', 0));
$JLMS_ACL =& JLMSFactory::getACL();
$assigned_groups_only = $JLMS_ACL->CheckPermissions('advanced', 'assigned_groups_only');
$AND_ST = "";
if (false !== ($enroll_period = JLMS_getEnrolPeriod($my->id, $id))) {
$AND_ST = " AND IF(is_time_related, (show_period < '" . $enroll_period . "' ), 1) ";
}
$do_redirect = false;
$query = "SELECT is_limited, owner_id FROM `#__lms_agenda` WHERE agenda_id = {$agenda_id} AND course_id = {$id}" . $AND_ST;
$JLMS_DB->setQuery($query);
$row = $JLMS_DB->loadObject();
if (is_object($row) && isset($row->is_limited)) {
$flag = 0;
if ($row->is_limited == 0 && $row->owner_id != $my->id) {
$flag = 1;
}
} else {
$do_redirect = true;
}
if ($id && $JLMS_ACL->CheckPermissions('announce', 'manage') && !$flag) {
$where = '';
if ($assigned_groups_only && $row->is_limited) {
$groups_where_admin_manager = JLMS_ACL_HELPER::GetAssignedGroups($my->id, $id);
$groups_where_isset_user = JLMS_ACL_HELPER::GetUserGlobalGroup($my->id, $id);
$groups_where_admin_manager = array_merge($groups_where_admin_manager, $groups_where_isset_user);
if (count($groups_where_admin_manager)) {
$where .= "\n AND is_limited = 1 AND ( `groups` LIKE '%|{$groups_where_admin_manager['0']}|%'";
for ($i = 1; $i < count($groups_where_admin_manager); $i++) {
$where .= "\n OR `groups` like '%|{$groups_where_admin_manager[$i]}|%'";
}
$where .= "\n OR owner_id = '" . $my->id . "')";
} else {
$where .= "\n AND (owner_id = '" . $my->id . "' OR agenda_id = 0) AND groups = ''";
}
}
$query = "SELECT * FROM `#__lms_agenda` WHERE agenda_id = {$agenda_id} AND course_id = {$id}" . $where;
$JLMS_DB->setQuery($query);
$agenda_item = $JLMS_DB->loadObject();
if (is_object($agenda_item) && isset($agenda_item->agenda_id)) {
if ($JLMS_ACL->CheckPermissions('announce', 'only_own') && $agenda_item->owner_id != $my->id) {
$do_redirect = true;
} elseif ($JLMS_ACL->CheckPermissions('announce', 'only_own_role') && $JLMS_ACL->GetRole() != $JLMS_ACL->UserSystemRole($JLMS_DB, $agenda_item->owner_id)) {
$do_redirect = true;
} else {
$groups_arr = array();
if ($agenda_item->groups) {
$groups = substr($agenda_item->groups, 1, strlen($agenda_item->groups) - 2);
$groups_arr = explode('|', $groups);
}
if ($assigned_groups_only) {
$lists['is_limited'] = mosHTML::yesnoRadioList('is_limited', 'disabled="disabled" class="inputbox" ', $agenda_item->is_limited);
} else {
$lists['is_limited'] = mosHTML::yesnoRadioList('is_limited', 'class="inputbox" ', $agenda_item->is_limited);
}
$lists['groups'] = JLMSmultiselect($groups_arr, true, $id);
JLMS_agenda_html::show_add_event($id, $option, $agenda_item, $lists);
}
} else {
$do_redirect = true;
}
} else {
$do_redirect = true;
}
if ($do_redirect) {
JLMSRedirect(sefRelToAbs("index.php?option={$option}&Itemid={$Itemid}&task=agenda&id={$id}"));
}
}
function my_homeworks($course_id, $hp_items, $user_id)
{
global $JLMS_DB;
if (!$course_id) {
return array();
}
$my_hw = array();
$JLMS_ACL =& JLMSFactory::getACL();
$assigned_groups_only = $JLMS_ACL->CheckPermissions('advanced', 'assigned_groups_only');
$members = "'0'";
$where = '';
if ($JLMS_ACL->_role_type == 2 || $JLMS_ACL->_role_type == 3 || $JLMS_ACL->_role_type == 4) {
if ($assigned_groups_only) {
$groups_where_admin_manager = JLMS_ACL_HELPER::GetAssignedGroups($user_id);
$groups_where_isset_user = JLMS_ACL_HELPER::GetUserGlobalGroup($user_id);
$groups_where_admin_manager = array_merge($groups_where_admin_manager, $groups_where_isset_user);
if (count($groups_where_admin_manager)) {
$where .= "\n AND (is_limited = 0 OR `groups` LIKE '%|{$groups_where_admin_manager['0']}|%'";
for ($i = 1; $i < count($groups_where_admin_manager); $i++) {
$where .= "\n OR `groups` like '%|{$groups_where_admin_manager[$i]}|%'";
}
$where .= "\n OR a.owner_id = '" . $user_id . "')";
} else {
$where .= "\n AND (is_limited = 0 OR a.owner_id = '" . $user_id . "' OR a.id = 0) AND groups = ''";
}
}
} else {
if ($JLMS_ACL->_role_type < 2) {
$query = "select a.group_id FROM #__lms_users_in_global_groups as a WHERE a.user_id = '" . $user_id . "' AND a.subgroup1_id = 0 AND a.group_id > 0";
$JLMS_DB->setQuery($query);
$temp1 = $JLMS_DB->loadResultArray();
$query = "select subgroup1_id FROM #__lms_users_in_global_groups WHERE user_id = '" . $user_id . "' AND subgroup1_id > 0";
$JLMS_DB->setQuery($query);
$temp2 = $JLMS_DB->loadResultArray();
$group_where_isset_user = array_merge($temp1, $temp2);
$where .= "\n AND (a.is_limited = 0";
if (isset($group_where_isset_user) && count($group_where_isset_user)) {
$where .= "\n OR (a.is_limited = 1" . "\n AND (a.groups LIKE '%|{$group_where_isset_user['0']}|%'";
for ($i = 1; $i < count($group_where_isset_user); $i++) {
$where .= "\n OR a.groups like '%|{$group_where_isset_user[$i]}|%'";
}
$where .= "\n )))";
} else {
$where .= "\n )";
}
}
}
$query = "SELECT a.*, d.hw_status, c.user_id as stu_id, e.user_id as teach_id" . "\n FROM (#__lms_homework as a, #__lms_courses as b)" . "\n LEFT JOIN #__lms_users_in_groups as c ON c.user_id = '" . $user_id . "' AND c.course_id = b.id" . "\n LEFT JOIN #__lms_homework_results as d ON d.course_id = b.id AND d.user_id = " . $user_id . " AND d.hw_id = a.id" . "\n LEFT JOIN #__lms_user_courses as e ON e.course_id = b.id AND e.user_id = '" . $user_id . "'" . "\n WHERE (ISNULL(d.hw_status) OR d.hw_status = 0)" . "\n AND a.course_id IN ({$course_id})" . "\n AND a.course_id = b.id AND a.end_date >= '" . date('Y-m-d', time()) . "'" . $where . "\n LIMIT 0, {$hp_items}";
$JLMS_DB->SetQuery($query);
$my_hw = $JLMS_DB->LoadObjectList();
if ($JLMS_ACL->_role_type < 2) {
$my_hw = filterByShowPeriod($my_hw);
}
return $my_hw;
}
function JLMS_showHomeWork($id, $option)
{
global $my, $JLMS_DB, $Itemid, $JLMS_SESSION, $JLMS_CONFIG;
$course_id = JRequest::getInt('course_id');
$id = $course_id ? $course_id : $id;
$usertype = JLMS_GetUserType($my->id, $id);
$JLMS_ACL =& JLMSFactory::getACL();
$assigned_groups_only = $JLMS_ACL->CheckPermissions('advanced', 'assigned_groups_only');
$limit = intval(mosGetParam($_GET, 'limit', $JLMS_SESSION->get('list_limit', $JLMS_CONFIG->get('list_limit'))));
$JLMS_SESSION->set('list_limit', $limit);
$limitstart = intval(mosGetParam($_GET, 'limitstart', 0));
$where = '';
// if ($id && ($usertype == 1 || $usertype == 6)) {
// if ($id && ($JLMS_ACL->CheckPermissions('homework', 'manage') || $usertype == 6)) {
if ($id && ($JLMS_ACL->CheckPermissions('homework', 'manage') || $JLMS_ACL->CheckPermissions('homework', 'view_stats'))) {
$members = "'0'";
$AND_ST = "";
$fields = ',0 AS checkedout';
if ($JLMS_ACL->_role_type == 2 || $JLMS_ACL->_role_type == 3 || $JLMS_ACL->_role_type == 4) {
if ($assigned_groups_only) {
$fields = ",IF(a.owner_id != '" . $my->id . "',1 ,0) AS checkedout";
$groups_where_admin_manager = JLMS_ACL_HELPER::GetAssignedGroups($my->id, $id);
$groups_where_isset_user = JLMS_ACL_HELPER::GetUserGlobalGroup($my->id, $id);
$groups_where_admin_manager = array_merge($groups_where_admin_manager, $groups_where_isset_user);
if (count($groups_where_admin_manager)) {
$where .= "\n AND (a.is_limited = 0 OR a.groups LIKE '%|{$groups_where_admin_manager['0']}|%'";
for ($i = 1; $i < count($groups_where_admin_manager); $i++) {
$where .= "\n OR a.groups like '%|{$groups_where_admin_manager[$i]}|%'";
}
$where .= "\n OR a.owner_id = '" . $my->id . "')";
} else {
$where .= "\n AND (a.is_limited = 0 OR a.owner_id = '" . $my->id . "' OR a.id = 0) AND a.groups = ''";
}
}
} else {
if ($JLMS_ACL->_role_type < 2) {
$query = "select a.group_id FROM #__lms_users_in_global_groups as a WHERE a.user_id = '" . $my->id . "' AND a.subgroup1_id = 0 AND a.group_id > 0";
$JLMS_DB->setQuery($query);
$temp1 = $JLMS_DB->loadResultArray();
$query = "select subgroup1_id FROM #__lms_users_in_global_groups WHERE user_id = '" . $my->id . "' AND subgroup1_id > 0";
$JLMS_DB->setQuery($query);
$temp2 = $JLMS_DB->loadResultArray();
$group_where_isset_user = array_merge($temp1, $temp2);
if (count($group_where_isset_user)) {
$where .= "\n AND (( a.groups <> '' AND a.groups IS NOT NULL AND (groups LIKE '%|{$group_where_isset_user['0']}|%'";
for ($i = 1; $i < count($group_where_isset_user); $i++) {
$where .= "\n OR groups like '%|{$group_where_isset_user[$i]}|%'";
}
$where .= "\n )) OR (a.is_limited = 0 AND (a.groups = '' OR a.groups IS NULL)))";
}
if (false !== ($enroll_period = JLMS_getEnrolPeriod($my->id, $id))) {
$AND_ST = " AND IF(a.is_time_related, (a.show_period < '" . $enroll_period . "' ), 1) ";
}
}
}
$query = "SELECT count(*) FROM #__lms_homework AS a" . "\n WHERE a.course_id = '" . $id . "'" . $AND_ST . ($JLMS_ACL->CheckPermissions('homework', 'view_all') ? '' : "\n AND a.published = 1") . $where;
$JLMS_DB->SetQuery($query);
$total = $JLMS_DB->LoadResult();
require_once _JOOMLMS_FRONT_HOME . DS . "includes" . DS . "classes" . DS . "lms.pagination.php";
$pageNav = new JLMSPageNav($total, $limitstart, $limit);
$query = "SELECT a.*" . $fields . "\n FROM #__lms_homework as a" . "\n WHERE a.course_id = '" . $id . "'" . $AND_ST . ($JLMS_ACL->CheckPermissions('homework', 'view_all') ? '' : "\n AND a.published = 1") . $where . "\n ORDER BY a.post_date DESC, a.hw_name" . "\n LIMIT {$pageNav->limitstart}, {$pageNav->limit}";
$JLMS_DB->SetQuery($query);
$rows = $JLMS_DB->LoadObjectList();
$lms_titles_cache =& JLMSFactory::getTitles();
$lms_titles_cache->setArray('homework', $rows, 'id', 'hw_name');
JLMS_homework_html::showHomeWorks($id, $option, $rows, $pageNav, $usertype);
} elseif ($id && $JLMS_ACL->CheckPermissions('homework', 'view')) {
$filt_hw = intval(mosGetParam($_GET, 'filt_hw', $JLMS_SESSION->get('filt_hw', 0)));
$JLMS_SESSION->set('filt_hw', $filt_hw);
$query = "select a.group_id FROM #__lms_users_in_global_groups as a WHERE a.user_id = '" . $my->id . "' AND a.subgroup1_id = 0 AND a.group_id > 0";
$JLMS_DB->setQuery($query);
$temp1 = $JLMS_DB->loadResultArray();
$query = "select subgroup1_id FROM #__lms_users_in_global_groups WHERE user_id = '" . $my->id . "' AND subgroup1_id > 0";
$JLMS_DB->setQuery($query);
$temp2 = $JLMS_DB->loadResultArray();
$group_where_isset_user = array_merge($temp1, $temp2);
$AND_ST = "";
if (false !== ($enroll_period = JLMS_getEnrolPeriod($my->id, $id))) {
$AND_ST = " AND IF(a.is_time_related, (a.show_period < '" . $enroll_period . "' ), 1) ";
}
$query = "SELECT count(*) FROM #__lms_homework as a" . ($filt_hw ? "\n LEFT JOIN #__lms_homework_results as b ON a.id = b.hw_id AND b.user_id = '" . $my->id . "' AND b.course_id = '" . $id . "'" : '') . "\n WHERE a.course_id = '" . $id . "'" . $AND_ST . ($JLMS_ACL->CheckPermissions('homework', 'view_all') ? '' : "\n AND a.published = 1") . ($filt_hw ? $filt_hw == 2 ? "\n AND b.hw_status = 1" : ($filt_hw == 1 ? " AND (b.hw_status IS NULL OR b.hw_status <> 1)" : "") : '');
$query .= "\n AND a.is_limited = 0";
if (isset($group_where_isset_user) && count($group_where_isset_user)) {
$query .= "\n OR (a.is_limited = 1" . "\n AND (a.groups LIKE '%|{$group_where_isset_user['0']}|%'";
for ($i = 1; $i < count($group_where_isset_user); $i++) {
$query .= "\n OR a.groups like '%|{$group_where_isset_user[$i]}|%'";
}
$query .= "\n ))";
}
$JLMS_DB->SetQuery($query);
$total = $JLMS_DB->LoadResult();
require_once _JOOMLMS_FRONT_HOME . DS . "includes" . DS . "classes" . DS . "lms.pagination.php";
$pageNav = new JLMSPageNav($total, $limitstart, $limit);
$query = "SELECT a.*, b.id as result_id, b.hw_status, b.hw_date, b.grade" . "\n FROM #__lms_homework as a LEFT JOIN #__lms_homework_results as b ON a.id = b.hw_id AND b.user_id = '" . $my->id . "' AND b.course_id = '" . $id . "'" . "\n WHERE a.course_id = '" . $id . "'" . $AND_ST . ($filt_hw ? $filt_hw == 2 ? "\n AND b.hw_status = 1" : ($filt_hw == 1 ? " AND (b.hw_status IS NULL OR b.hw_status <> 1)" : "") : '') . ($JLMS_ACL->CheckPermissions('homework', 'view_all') ? '' : "\n AND a.published = 1");
$query .= "\n AND (a.is_limited = 0";
if (isset($group_where_isset_user) && count($group_where_isset_user)) {
$query .= "\n OR (a.is_limited = 1" . "\n AND (a.groups LIKE '%|{$group_where_isset_user['0']}|%'";
for ($i = 1; $i < count($group_where_isset_user); $i++) {
$query .= "\n OR a.groups like '%|{$group_where_isset_user[$i]}|%'";
}
$query .= "\n )))";
} else {
$query .= "\n )";
}
$query .= "\n ORDER BY a.post_date DESC, a.hw_name" . "\n LIMIT {$pageNav->limitstart}, {$pageNav->limit}";
$JLMS_DB->SetQuery($query);
$rows = $JLMS_DB->LoadObjectList();
$lists = array();
$f_items = array();
$f_items[] = mosHTML::makeOption(0, _JLMS_HW_FILTER_ALL_RESULTS);
$f_items[] = mosHTML::makeOption(2, _JLMS_HW_STATUS_COMPLETED);
$f_items[] = mosHTML::makeOption(1, _JLMS_HW_STATUS_INCOMPLETE);
$link = "index.php?option={$option}&Itemid={$Itemid}&task=homework&id={$id}";
$link = $link . "&filt_hw='+this.options[selectedIndex].value+'";
$link = sefRelToAbs($link);
$link = str_replace('%5C%27', "'", $link);
$link = str_replace('%5B', "[", $link);
$link = str_replace('%5D', "]", $link);
$link = str_replace('%20', "+", $link);
$link = str_replace("\\\\\\", "", $link);
$link = str_replace('%27', "'", $link);
$lists['filter'] = mosHTML::selectList($f_items, 'filt_hw', 'class="inputbox" size="1" onchange="document.location.href=\'' . $link . '\';"', 'value', 'text', $filt_hw);
$lists['used_filter'] = $filt_hw;
$lms_titles_cache =& JLMSFactory::getTitles();
$lms_titles_cache->setArray('homework', $rows, 'id', 'hw_name');
JLMS_homework_html::showHomeWorks_stu($id, $option, $rows, $pageNav, $lists);
} else {
JLMSRedirect(sefRelToAbs("index.php?option={$option}&Itemid={$Itemid}"));
}
}
