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;
}
}
