function jlms_booking_list($course_id, $option) { global $my, $JLMS_DB, $Itemid, $JLMS_SESSION, $JLMS_CONFIG, $JLMS_CONFIG; $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', $JLMS_SESSION->get('limitstart_confbook', -99))); $do_requery = false; if ($limitstart == -99) { $limitstart = 0; $do_requery = true; } $JLMS_SESSION->set('limitstart_confbook', $limitstart); $filter_stu = intval(mosGetParam($_REQUEST, 'filter_stu', $JLMS_SESSION->get('filter_stu', 0))); $filter_teach = intval(mosGetParam($_REQUEST, 'filter_teach', $JLMS_SESSION->get('filter_teach', $my->id))); $JLMS_SESSION->set('filter_stu', $filter_stu); $JLMS_SESSION->set('filter_teach', $filter_teach); //$usertype = $JLMS_CONFIG->get('current_usertype', 0); $JLMS_ACL =& JLMSFactory::getACL(); if ($course_id && $JLMS_ACL->CheckPermissions('conference', 'manage')) { if ($filter_stu) { $query = "SELECT COUNT(distinct a.p_id) FROM #__lms_conference_period as a, #__lms_conference_usr as b WHERE course_id='" . $course_id . "'" . ($filter_teach ? "\n AND a.teacher_id = {$filter_teach} " : '') . "\n AND a.p_id = b.p_id AND b.user_id = {$filter_stu}"; } else { $query = "SELECT COUNT(*) FROM #__lms_conference_period WHERE course_id='" . $course_id . "'" . ($filter_teach ? "\n AND teacher_id = {$filter_teach} " : ''); } $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); if ($filter_stu) { $query = "SELECT a.*, b.name, b.id as user_teacher_id, b.username FROM #__lms_conference_period as a LEFT JOIN #__users as b ON a.teacher_id = b.id, #__lms_conference_usr as c WHERE a.course_id='" . $course_id . "'" . ($filter_teach ? "\n AND a.teacher_id = {$filter_teach} " : '') . "\n AND a.p_id = c.p_id AND c.user_id = {$filter_stu}"; $query .= "\n ORDER BY a.from_time"; $query .= "\n LIMIT {$pageNav->limitstart}, {$pageNav->limit}"; } else { $query = "SELECT a.*, b.name, b.id as user_teacher_id, b.username FROM #__lms_conference_period as a LEFT JOIN #__users as b ON a.teacher_id = b.id WHERE a.course_id='" . $course_id . "'" . ($filter_teach ? "\n AND a.teacher_id = {$filter_teach} " : ''); $query .= "\n ORDER BY a.from_time"; $query .= "\n LIMIT {$pageNav->limitstart}, {$pageNav->limit}"; } $JLMS_DB->setQuery($query); $rows = $JLMS_DB->LoadObjectList(); if ($do_requery) { $is_found = false; foreach ($rows as $row) { if ($row->from_time >= time() + $JLMS_CONFIG->get('offset') * 60 * 60) { $is_found = true; break; } } if (!$is_found) { $do_search = true; $lim_s = $pageNav->limitstart; $lim = $pageNav->limit; if ($lim_s + $lim > $total) { $do_search = false; } while ($do_search) { $lim_s = $lim_s + $lim; if ($filter_stu) { $query = "SELECT a.*, b.name, b.id as user_teacher_id, b.username FROM #__lms_conference_period as a LEFT JOIN #__users as b ON a.teacher_id = b.id, #__lms_conference_usr as c WHERE a.course_id='" . $course_id . "'" . ($filter_teach ? "\n AND a.teacher_id = {$filter_teach} " : '') . "\n AND a.p_id = c.p_id AND c.user_id = {$filter_stu}"; $query .= "\n ORDER BY a.from_time"; $query .= "\n LIMIT {$lim_s}, {$lim}"; } else { $query = "SELECT a.*, b.name, b.id as user_teacher_id, b.username FROM #__lms_conference_period as a LEFT JOIN #__users as b ON a.teacher_id = b.id WHERE a.course_id='" . $course_id . "'" . ($filter_teach ? "\n AND a.teacher_id = {$filter_teach} " : ''); $query .= "\n ORDER BY a.from_time"; $query .= "\n LIMIT {$lim_s}, {$lim}"; } $JLMS_DB->setQuery($query); $rows1 = $JLMS_DB->loadObjectList(); if ($lim_s + $lim > $total) { $do_search = false; } foreach ($rows1 as $row_tmp) { if ($row_tmp->from_time >= time() + $JLMS_CONFIG->get('offset') * 60 * 60) { $is_found = true; $do_search = false; break; } } } if ($is_found) { $rows = $rows1; $pageNav->limitstart = $lim_s; $pageNav->limit = $lim; $JLMS_SESSION->set('limitstart_confbook', $lim_s); } } } $lists = array(); $query = "SELECT a.id as value, a.name as text FROM #__users as a, #__lms_user_courses as c" . "\n WHERE a.id = c.user_id AND c.course_id = '" . $course_id . "'" . "\n ORDER BY a.name"; $JLMS_DB->SetQuery($query); $teachers = $JLMS_DB->LoadObjectList(); $teachers_s = array(); $teachers_s[] = mosHTML::makeOption(0, ' - Select a teacher - '); $i = 1; foreach ($teachers as $teacher) { $teachers_s[] = mosHTML::makeOption($teacher->value, $teacher->text); $i++; } $javascript = 'onchange="document.adminForm.submit();"'; $lists['filter_teach'] = mosHTML::selectList($teachers_s, 'filter_teach', 'class="inputbox" size="1" ' . $javascript, 'value', 'text', $filter_teach); $query = "SELECT a.id, a.name, a.username, a.email, b.ug_name" . "\n FROM #__users as a, #__lms_users_in_groups as c LEFT JOIN #__lms_usergroups as b ON c.group_id = b.id AND b.course_id = '" . $course_id . "'" . "\n WHERE a.id = c.user_id AND c.course_id = '" . $course_id . "'" . "\n ORDER BY a.username"; $JLMS_DB->SetQuery($query); $users = $JLMS_DB->LoadObjectList(); $users_s = array(); $users_s[] = mosHTML::makeOption(0, ' - Select a student - '); $i = 1; foreach ($users as $user) { $users_s[] = mosHTML::makeOption($user->id, $user->username . ' (' . $user->name . ')'); $i++; } $javascript = 'onchange="document.adminForm.submit();"'; $lists['filter_stu'] = mosHTML::selectList($users_s, 'filter_stu', 'class="inputbox" size="1" ' . $javascript, 'value', 'text', $filter_stu); JLMS_conference_html::jlms_booking_list($course_id, $option, $rows, $pageNav, $lists); } else { jlmsRedirect(sefRelToAbs("index.php?option={$option}&Itemid={$Itemid}&task=conference&id={$course_id}")); } }
function JLMS_deleteFromFMS($cids, $course_id, $option, $from_archive = false) { global $Itemid, $my, $JLMS_DB, $JLMS_CONFIG, $JLMS_SESSION, $JLMS_LANGUAGE; JLMS_require_lang($JLMS_LANGUAGE, 'conference.lang', $JLMS_CONFIG->get('default_language')); JLMS_processLanguage($JLMS_LANGUAGE); $where = ''; if ($cids) { $where = " id IN ({$cids}) AND "; } $query = "SELECT session_name FROM `#__lms_conference_records` WHERE {$where} course_id = '" . $course_id . "'"; $JLMS_DB->setQuery($query); $files = $JLMS_DB->loadObjectList(); $i = 0; $files_list = ''; foreach ($files as $file) { $files_list .= "&arg" . $i . "=" . $file->session_name; $i++; } $query = "DELETE FROM #__lms_conference_records WHERE {$where} course_id = '" . $course_id . "' "; $JLMS_DB->SetQuery($query); $JLMS_DB->query(); if ($files_list) { $recorded_session = mosGetParam($_REQUEST, 'recorded_session', ''); $flashcomroot = $JLMS_CONFIG->get('flascommRoot'); $JLMS_CONFIG->SetPageTitle('Conference | delete records'); $master = "yes"; ?> <script type="text/javascript" src="<?php echo $JLMS_CONFIG->get('live_site'); ?> /components/com_joomla_lms/includes/js/swfobject.js"></script> <script type="text/javascript" language="javascript"> <!-- function jlms_redirect(){ <?php if ($from_archive) { ?> top.location.href = '<?php echo sefRelToAbs("index.php?option={$option}&Itemid={$Itemid}&task=conference&mode=archive&id={$course_id}"); ?> '; <?php } else { ?> top.location.href = '<?php echo sefRelToAbs("index.php?option={$option}&Itemid={$Itemid}&task=courses"); ?> '; <?php } ?> } //--> </script> <div class="contentheading"><?php echo _JLMS_CONFERENCE_DELETING; ?> </div> <div style="text-align:left " id="deleteRecord"> <?php if ($from_archive) { $JLMS_SESSION->set('joomlalms_sys_message', _JLMS_CONFERENCE_DELETING_INFO); } else { $JLMS_SESSION->set('joomlalms_sys_message', _JLMS_COURSE_DELETED); } $params = 'pseudo=' . $my->username . '&course_id=' . $course_id . '&flashcommRoot=' . $flashcomroot . '&master=' . $master . $files_list; ?> <script type="text/javascript"> // <![CDATA[ var so = new SWFObject("components/com_joomla_lms/includes/conference_playback/deleteRecord_106.swf?<?php echo $params; ?> ", "deleteRecord", "150", "80", "8", "#ffffff"); so.addVariable("allowScriptAccess", "sameDomain"); // this line is optional, but this example uses the variable and displays this text inside the flash movie so.addVariable("wmode", "transparent"); so.addVariable("flashvars", "hello there"); so.addVariable("salign", "t"); so.addVariable("menu", "false"); so.write("deleteRecord"); // ]]> </script> <?php return false; ?> </div><?php } else { if ($from_archive) { jlmsRedirect(sefRelToAbs("index.php?option={$option}&Itemid={$Itemid}&task=conference&mode=archive&id={$course_id}")); } return true; } }