if ($form->isSubmitted() && $form->validate()) { $cloneTemplate = eF_getTableData("certificate_templates", "certificate_xml", "id=" . $tid); $formValues = $form->exportValues(); $dbFields = array("certificate_name" => $formValues['certificate_name'], "certificate_xml" => $cloneTemplate[0]['certificate_xml'], "certificate_type" => "course", "users_LOGIN" => $GLOBALS['currentUser']->user['login']); if ($cloned = eF_insertTableData("certificate_templates", $dbFields)) { $message = _SUCCESSFULLYCLONECERTIFICATETEMPLATE; $message_type = 'success'; } else { $message = _PROBLEMCLONECERTIFICATETEMPLATE; $message_type = 'failure'; } $redirectUrl = "" . basename($_SERVER['PHP_SELF']) . "?" . $baseUrl . "&op=format_certificate&message=" . urlencode($message); $redirectUrl .= "&message_type=" . $message_type . "&reset_popup=1&tid=" . $cloned; $smarty->assign('T_CLONE_CERTIFICATE_TEMPLATE_REDIRECT', $redirectUrl); } $renderer = prepareFormRenderer($form); $smarty->assign('T_CLONE_CERTIFICATE_TEMPLATE_FORM', $renderer->toArray()); } #cpp#endif } else { if ($_GET['op'] == 'delete_certificate_template') { if (G_VERSIONTYPE != 'community') { #cpp#ifndef COMMUNITY if ($_SESSION['s_type'] != 'administrator') { $templates = eF_getTableData("certificate_templates", "id, certificate_name, certificate_type", "certificate_type='main' OR id='" . $currentCourse->options['certificate_tpl_id'] . "' OR users_LOGIN='******'currentUser']->user['login'] . "'", "certificate_name"); } else { $templates = eF_getTableData("certificate_templates", "id, certificate_name, certificate_type", "", "certificate_name"); } foreach ($templates as $key => $value) { $userTemplates[$value['id']] = $value['id']; }
/** * The main functionality * * (non-PHPdoc) * @see libraries/EfrontModule#getModule() */ public function getModule() { $smarty = $this->getSmartyVar(); $smarty->assign("T_MODULE_BASEDIR", $this->moduleBaseDir); $smarty->assign("T_MODULE_BASELINK", $this->moduleBaseLink); $smarty->assign("T_MODULE_BASEURL", $this->moduleBaseUrl); $smarty->assign("T_TABLE_OPTIONS", array(array('image' => $this->moduleBaseLink . 'img/order.png', 'text' => _MODULE_SECURITY_RECHECKLOCALFILES, 'href' => $this->moduleBaseUrl . '&delete_local_list=1'), array('image' => $this->moduleBaseLink . 'img/refresh.png', 'text' => _MODULE_SECURITY_RECHECKSERVERFILES, 'href' => $this->moduleBaseUrl . '&delete_remote_list=1'), array('image' => $this->moduleBaseLink . 'img/rules.png', 'text' => _MODULE_SECURITY_RESETIGNORELIST, 'href' => $this->moduleBaseUrl . '&delete_ignore_list=1'))); if (isset($_GET['download_ignore_list'])) { try { $file = new EfrontFile($this->getIgnoreListName()); $file->sendFile(true); } catch (Exception $e) { $this->setMessageVar('The list is empty', 'failure'); } } else { if ($_GET['delete_remote_list']) { $file = new EfrontFile($this->getCachedRemoteListName()); $file->delete(); } else { if ($_GET['delete_local_list']) { $file = new EfrontFile($this->getLocalListName()); $file->delete(); } else { if ($_GET['delete_ignore_list']) { try { $file = new EfrontFile($this->getIgnoreListName()); $file->delete(); } catch (Exception $e) { } } } } } if (isset($_GET['download'])) { $_GET['download'] = base64_decode($_GET['download']); } $form = new HTML_QuickForm("demo_form", "post", $this->moduleBaseUrl . "&type=" . $_GET['type'], "", null, true); switch ($_GET['type']) { case 'install': $form->addElement('submit', 'submit_delete_install', _MODULE_SECURITY_DELETEINSTALLDIRECTORY, 'class = "flatButton"'); break; case 'magic_quotes_gpc': break; case 'default_accounts': $form->addElement('submit', 'submit_deactivate', _MODULE_SECURITY_DEACTIVATEDEFAULTACCOUNTS, 'class = "flatButton" title = "Click this to deactivate these accounts"'); break; case 'changed_files': list($changed_files, $new_files) = $this->checksumCheck(); $smarty->assign("T_CHANGED_FILES", $changed_files); if (isset($_GET['download']) && in_array($_GET['download'], array_keys($changed_files)) && $_GET['download'] != 'libraries/configuration.php') { try { $file = new EfrontFile(G_ROOTPATH . $_GET['download']); $file->sendFile(true); exit; } catch (Exception $e) { $this->setMessageVar(_MODULE_SECURITY_FILECOULDNOTBEDELETED, 'failure'); } } else { if (isset($_GET['ignore']) && in_array($_GET['ignore'], array_keys($changed_files))) { $this->addToIgnoreList($_GET['ignore']); echo json_encode(array('success' => true)); exit; } } $form->addElement('submit', 'submit_recheck', _MODULE_SECURITY_RECHECKFILES, 'class = "flatButton" '); $form->addElement('submit', 'reset_ignore_list', _MODULE_SECURITY_RESETIGNORELIST, 'class = "flatButton" '); $form->addElement('submit', 'ignore_changed_all', _MODULE_SECURITY_IGNOREALL, 'class = "flatButton" '); break; case 'new_files': list($changed_files, $new_files) = $this->checksumCheck(); if (isset($_GET['download']) && in_array($_GET['download'], array_keys($new_files)) && $_GET['download'] != 'libraries/configuration.php') { try { $file = new EfrontFile(G_ROOTPATH . $_GET['download']); $file->sendFile(true); exit; } catch (Exception $e) { $this->setMessageVar(_MODULE_SECURITY_FILECOULDNOTBEDELETED, 'failure'); } } else { if (isset($_GET['ignore']) && in_array($_GET['ignore'], array_keys($new_files))) { $this->addToIgnoreList($_GET['ignore']); } else { if (isset($_GET['delete']) && in_array($_GET['delete'], array_keys($new_files))) { try { $file = new EfrontFile(G_ROOTPATH . $_GET['delete']); $file->delete(); } catch (Exception $e) { } $file = new EfrontFile($this->getLocalListName()); $file->delete(); list($changed_files, $new_files) = $this->checksumCheck(); } } } $smarty->assign("T_NEW_FILES", $new_files); $form->addElement('submit', 'submit_recheck', _MODULE_SECURITY_RECHECKFILES, 'class = "flatButton" '); $form->addElement('submit', 'reset_ignore_list', _MODULE_SECURITY_RESETIGNORELIST, 'class = "flatButton" '); $form->addElement('submit', 'ignore_new_all', _MODULE_SECURITY_IGNOREALL, 'class = "flatButton" '); break; default: $smarty->assign("T_SECURITY_FEEDS", $this->getRssFeeds()); try { $smarty->assign("T_LOCAL_ISSUES", $this->checkLocalIssues()); } catch (Exception $e) { $this->setMessageVar($e->getMessage(), 'failure'); } break; } if ($form->isSubmitted() && $form->validate()) { try { $values = $form->exportValues(); if ($values['submit_recheck']) { $file = new EfrontFile($this->getLocalListName()); $file->delete(); eF_redirect($this->moduleBaseUrl . '&type=' . $_GET['type'] . '&message=' . urlencode(_OPERATIONCOMPLETEDSUCCESSFULLY) . '&message_type=success'); } else { if ($values['submit_delete_install']) { file_get_contents(G_SERVERNAME . 'index.php?delete_install=1'); eF_redirect($this->moduleBaseUrl . '&type=' . $_GET['type'] . '&message=' . urlencode(_OPERATIONCOMPLETEDSUCCESSFULLY) . '&message_type=success'); } else { if ($values['submit_deactivate']) { $result = eF_updateTableData("users", array('active' => 0), "(login = '******' and password = '******') or (login = '******' and password = '******')"); eF_redirect($this->moduleBaseUrl . '&message=' . urlencode(_OPERATIONCOMPLETEDSUCCESSFULLY) . '&message_type=success'); } else { if ($values['reset_ignore_list']) { try { $file = new EfrontFile($this->getIgnoreListName()); $file->delete(); eF_redirect($this->moduleBaseUrl . '&type=' . $_GET['type'] . '&message=' . urlencode(_OPERATIONCOMPLETEDSUCCESSFULLY) . '&message_type=success'); } catch (Exception $e) { $this->setMessageVar(_MODULE_SECURITY_THELISTISEMTPY, 'failure'); } } else { if ($values['ignore_new_all']) { list($changed_files, $new_files) = $this->checksumCheck(); foreach ($new_files as $key => $value) { $this->addToIgnoreList($key); } eF_redirect($this->moduleBaseUrl . '&type=new_files&message=' . urlencode(_OPERATIONCOMPLETEDSUCCESSFULLY) . '&message_type=success'); } else { if ($values['ignore_changed_all']) { list($changed_files, $new_files) = $this->checksumCheck(); foreach ($changed_files as $key => $value) { $this->addToIgnoreList($key); } eF_redirect($this->moduleBaseUrl . '&type=changed_files&message=' . urlencode(_OPERATIONCOMPLETEDSUCCESSFULLY) . '&message_type=success'); } } } } } } } catch (Exception $e) { $smarty->assign("T_EXCEPTION_TRACE", $e->getTraceAsString()); $message = $e->getMessage() . ' (' . $e->getCode() . ') <a href = "javascript:void(0)" onclick = "eF_js_showDivPopup(event, \'' . _ERRORDETAILS . '\', 2, \'error_details\')">' . _MOREINFO . '</a>'; $this->setMessageVar($message, 'failure'); } } $renderer = prepareFormRenderer($form); $smarty->assign('T_SECURITY_FORM', $renderer->toArray()); //$feeds = $this->getRssFeeds(true, false); //$smarty->assign("T_SECURITY_FEEDS", $feeds); return true; }
public function getSmartyTpl() { $smarty = $this->getSmartyVar(); /////////////////////////////////////////////////////////////////////////////////////////////////////////////////// // Module rates $heartbeatForm = new HTML_QuickForm('module_chat_heartbeat_form', "post", $this->moduleBaseUrl, "", null, true); $heartbeatForm->addElement('text', 'engine_rate', _CHAT_ENGINE_RATE, 'class="inputText" style="width:100px;"'); $heartbeatForm->addRule('engine_rate', _THEFIELD . ' ' . _CHAT_ENGINE_RATE . ' ' . _ISMANDATORY, 'required', null, 'client'); $heartbeatForm->addRule('engine_rate', _THEFIELD . ' ' . _CHAT_ENGINE_RATE . ' ' . _CHAT_MUST_BE_NUMERIC_VALUE, 'numeric', null, 'client'); $heartbeatForm->addRule('engine_rate', _THEFIELD . ' ' . _CHAT_ENGINE_RATE . ' ' . _CHAT_MUST_BE_GREATER_THAN_ONE, 'callback', create_function('$a', '$res = ($a >= 1) ? true : false; return $res;')); $heartbeatForm->addElement('text', 'refresh_rate', _CHAT_USERLIST_REFRESH_RATE, 'class="inputText" style="width:100px;"'); $heartbeatForm->addRule('refresh_rate', _THEFIELD . ' ' . _CHAT_USERLIST_REFRESH_RATE . ' ' . _ISMANDATORY, 'required', null, 'client'); $heartbeatForm->addRule('refresh_rate', _THEFIELD . ' ' . _CHAT_USERLIST_REFRESH_RATE . ' ' . _CHAT_MUST_BE_NUMERIC_VALUE, 'numeric', null, 'client'); $heartbeatForm->addRule('refresh_rate', _THEFIELD . ' ' . _CHAT_ENGINE_RATE . ' ' . _CHAT_MUST_BE_GREATER_THAN_ONE, 'callback', create_function('$a', '$res = ($a >= 1) ? true : false; return $res;')); $heartbeatForm->addElement('submit', 'submit', _SUBMIT, 'class="flatButton"'); $heartbeatForm->setDefaults(array('engine_rate' => $this->getChatHeartbeat() / 1000, 'refresh_rate' => $this->getRefreshRate() / 1000)); $renderer = prepareFormRenderer($heartbeatForm); $smarty->assign("T_CHAT_CHATHEARTBEAT_FORM", $renderer->toArray()); if ($heartbeatForm->isSubmitted() && $heartbeatForm->validate()) { $values = $heartbeatForm->exportValues(); $this->setChatHeartbeat($values['engine_rate'] * 1000); $this->setRefreshRate($values['refresh_rate'] * 1000); eF_redirect($this->moduleBaseUrl . '&message_type=success&message=' . urlencode(_CHAT_VALUES_UPDATED_SUCCESSFULLY)); } /////////////////////////////////////////////////////////////////////////////////////////////////////////////////// // Create Log file $logForm = new HTML_QuickForm("module_chat_createlog_form", "post", $this->moduleBaseUrl . "&createLog=1", "", null, true); $logForm->addElement('hidden', 'hidden_lesson_id', '', 'id = "hidden_lesson_id"'); $logForm->addElement('text', 'lesson_title', _CHAT_LESSON_TITLE, 'maxlength="100" size="100" class="autoCompleteTextBox" id="autocomplete"'); $logForm->addRule('lesson_title', _THEFIELD . ' ' . _CHAT_LESSON_TITLE . ' ' . _ISMANDATORY, 'required', null, 'client'); $logForm->addElement('date', 'from', _CHAT_FROM_DATE, array('format' => 'dMY', 'minYear' => 2010, 'maxYear' => date('Y'))); $logForm->addElement('date', 'until', _CHAT_UNTIL_DATE, array('format' => 'dMY', 'minYear' => 2010, 'maxYear' => date('Y'))); $logForm->addElement('submit', 'submit', _SUBMIT, 'class="flatButton"'); $week_ago = $this->subtractDaysFromToday(7); $logForm->setDefaults(array('until' => array('d' => date('d'), 'M' => date('m'), 'Y' => date('Y')), 'from' => $week_ago)); $renderer = prepareFormRenderer($logForm); $smarty->assign("T_CHAT_CREATE_LOG_FORM", $renderer->toArray()); if (isset($_GET['createLog'])) { $log = $this->createLessonHistory($_POST['hidden_lesson_id'], $_POST['from']['Y'] . '-' . $_POST['from']['M'] . '-' . $_POST['from']['d'] . ' ' . "00:00:00", $_POST['until']['Y'] . '-' . $_POST['until']['M'] . '-' . $_POST['until']['d'] . ' ' . "23:59:59"); $smarty->assign('T_LOG', $log); $smarty->assign('T_CHAT_LESSON_TITLE', $l2); } if ($_POST['exportAdminChat']) { $this->adminLogsExportToExcel($_POST['logTitle'], $_POST['data']); exit; } /////////////////////////////////////////////////////////////////////////////////////////////////////////////////// // Clear chat logs return $this->moduleBaseDir . "control_panel.tpl"; }
//Get the form from the entity itself $entityForm = $entity->getForm($entityForm); //try/catch here in order to keep displaying the form in case of an error try { //Assign the form to the entity to handle it accordingly if ($entityForm->isSubmitted() && $entityForm->validate()) { //if $values is set, then the parent file may have done some processing itself if (isset($values) && $values) { $entity->handleForm($entityForm, array_merge($entityForm->exportValues(), $values)); } else { $entity->handleForm($entityForm); } $message = _OPERATIONCOMPLETEDSUCCESSFULLY; $message_type = 'success'; $processedForm = true; //This can be used outside to signify that the form processing is complete (to allow, for example, for redirecting) } } catch (Exception $e) { handleNormalFlowExceptions($e); } $renderer = prepareFormRenderer($entityForm); $entityForm->accept($renderer); $smarty->assign('T_ENTITY_FORM', $renderer->toArray()); $smarty->assign('T_ENTITY_FORM_ARRAY', $entityForm->toArray()); } catch (Exception $e) { handleNormalFlowExceptions($e); } } } } }
public function getSmartyTpl() { $currentUser = $this->getCurrentUser(); $smarty = $this->getSmartyVar(); $ranges = $this->getRanges(); $smarty->assign("T_GRADEBOOK_BASEURL", $this->moduleBaseUrl); $smarty->assign("T_GRADEBOOK_BASELINK", $this->moduleBaseLink); if ($currentUser->getRole($this->getCurrentLesson()) == 'professor') { $currentLesson = $this->getCurrentLesson(); $currentLessonID = $currentLesson->lesson['id']; $lessonUsers = $currentLesson->getUsers('student'); // get all students that have this lesson $lessonColumns = $this->getLessonColumns($currentLessonID); $allUsers = $this->getLessonUsers($currentLessonID, $lessonColumns); $gradeBookLessons = $this->getGradebookLessons($currentUser->getLessons(false, 'professor'), $currentLessonID); } else { if ($currentUser->getRole($this->getCurrentLesson()) == 'student') { $currentLesson = $this->getCurrentLesson(); $currentLessonID = $currentLesson->lesson['id']; } } if (isset($_GET['import_grades']) && eF_checkParameter($_GET['import_grades'], 'id') && in_array($_GET['import_grades'], array_keys($lessonColumns))) { $object = eF_getTableData("module_gradebook_objects", "creator", "id=" . $_GET['import_grades']); //if($object[0]['creator'] != $_SESSION['s_login']){ if ($currentUser->getRole($this->getCurrentLesson()) != 'professor') { eF_redirect($this->moduleBaseUrl . "&message=" . urlencode(_GRADEBOOK_NOACCESS)); exit; } $result = eF_getTableData("module_gradebook_objects", "refers_to_type, refers_to_id", "id=" . $_GET['import_grades']); $type = $result[0]['refers_to_type']; $id = $result[0]['refers_to_id']; $oid = $_GET['import_grades']; foreach ($lessonUsers as $userLogin => $value) { $this->importGrades($type, $id, $oid, $userLogin); } } else { if (isset($_GET['delete_column']) && eF_checkParameter($_GET['delete_column'], 'id') && in_array($_GET['delete_column'], array_keys($lessonColumns))) { $object = eF_getTableData("module_gradebook_objects", "creator", "id=" . $_GET['delete_column']); //if($object[0]['creator'] != $_SESSION['s_login']){ if ($currentUser->getRole($this->getCurrentLesson()) != 'professor') { eF_redirect($this->moduleBaseUrl . "&message=" . urlencode(_GRADEBOOK_NOACCESS)); exit; } eF_deleteTableData("module_gradebook_objects", "id=" . $_GET['delete_column']); eF_deleteTableData("module_gradebook_grades", "oid=" . $_GET['delete_column']); } else { if (isset($_GET['compute_score_grade']) && $_GET['compute_score_grade'] == '1') { foreach ($allUsers as $uid => $student) { $this->computeScoreGrade($lessonColumns, $ranges, $student['users_LOGIN'], $uid); } } else { if (isset($_GET['export_excel']) && ($_GET['export_excel'] == 'one' || $_GET['export_excel'] == 'all')) { require_once 'Spreadsheet/Excel/Writer.php'; $workBook = new Spreadsheet_Excel_Writer(); $workBook->setTempDir(G_UPLOADPATH); $workBook->setVersion(8); $workBook->send('GradeBook.xls'); if ($_GET['export_excel'] == 'one') { $workSheet =& $workBook->addWorksheet($currentLesson->lesson['name']); $this->professorLessonToExcel($currentLessonID, $currentLesson->lesson['name'], $workBook, $workSheet); } else { if ($_GET['export_excel'] == 'all') { $professorLessons = $currentUser->getLessons(false, 'professor'); foreach ($professorLessons as $key => $value) { $subLesson = new EfrontLesson($key); $subLessonUsers = $subLesson->getUsers('student'); // get all students that have this lesson $result = eF_getTableData("module_gradebook_users", "count(uid) as total_users", "lessons_ID=" . $key); if ($result[0]['total_users'] != 0) { // module installed for this lesson $workSheet =& $workBook->addWorksheet($subLesson->lesson['name']); $this->professorLessonToExcel($key, $subLesson->lesson['name'], $workBook, $workSheet); } } } } $workBook->close(); exit; } else { if (isset($_GET['export_student_excel']) && ($_GET['export_student_excel'] == 'current' || $_GET['export_student_excel'] == 'all')) { require_once 'Spreadsheet/Excel/Writer.php'; $workBook = new Spreadsheet_Excel_Writer(); $workBook->setTempDir(G_UPLOADPATH); $workBook->setVersion(8); $workBook->send('GradeBook.xls'); if ($_GET['export_student_excel'] == 'current') { $workSheet =& $workBook->addWorksheet($currentLesson->lesson['name']); $this->studentLessonToExcel($currentLessonID, $currentLesson->lesson['name'], $currentUser, $workBook, $workSheet); } else { if ($_GET['export_student_excel'] == 'all') { $studentLessons = $currentUser->getLessons(false, 'student'); foreach ($studentLessons as $key => $value) { // Is GradeBook installed for this lesson ? $installed = eF_getTableData("module_gradebook_users", "*", "lessons_ID=" . $key . " and users_LOGIN='******'login'] . "'"); if (sizeof($installed) != 0) { $subLesson = new EfrontLesson($key); $workSheet =& $workBook->addWorksheet($subLesson->lesson['name']); $this->studentLessonToExcel($key, $subLesson->lesson['name'], $currentUser, $workBook, $workSheet); } } } } $workBook->close(); exit; } else { if (isset($_GET['switch_lesson']) && eF_checkParameter($_GET['switch_lesson'], 'id') && in_array($_GET['switch_lesson'], array_keys($gradeBookLessons))) { $lessonID = $_GET['switch_lesson']; eF_redirect("location:" . $this->moduleBaseUrl . "&lessons_ID=" . $lessonID); } } } } } } if (isset($_GET['delete_range']) && eF_checkParameter($_GET['delete_range'], 'id') && in_array($_GET['delete_range'], array_keys($ranges))) { try { eF_deleteTableData("module_gradebook_ranges", "id=" . $_GET['delete_range']); } catch (Exception $e) { handleAjaxExceptions($e); } exit; } else { if (isset($_GET['add_range']) || isset($_GET['edit_range']) && eF_checkParameter($_GET['edit_range'], 'id') && in_array($_GET['edit_range'], array_keys($ranges))) { $grades = array(); for ($i = 0; $i <= 100; $i++) { $grades[$i] = $i; } isset($_GET['add_range']) ? $postTarget = "&add_range=1" : ($postTarget = "&edit_range=" . $_GET['edit_range']); $form = new HTML_QuickForm("add_range_form", "post", $this->moduleBaseUrl . $postTarget, "", null, true); $form->registerRule('checkParameter', 'callback', 'eF_checkParameter'); // XXX $form->addElement('select', 'range_from', _GRADEBOOK_RANGE_FROM, $grades); $form->addElement('select', 'range_to', _GRADEBOOK_RANGE_TO, $grades); $form->addElement('text', 'grade', _GRADEBOOK_GRADE, 'class = "inputText"'); $form->addRule('grade', _THEFIELD . ' "' . _GRADEBOOK_GRADE . '" ' . _ISMANDATORY, 'required', null, 'client'); $form->addRule('grade', _INVALIDFIELDDATA, 'checkParameter', 'text'); // XXX $form->addElement('submit', 'submit', _SUBMIT, 'class = "flatButton"'); if (isset($_GET['edit_range'])) { $editRange = $ranges[$_GET['edit_range']]; $form->setDefaults($editRange); } if ($form->isSubmitted() && $form->validate()) { $error = $invalid_range = false; $values = $form->exportValues(); $fields = array("range_from" => $values['range_from'], "range_to" => $values['range_to'], "grade" => $values['grade']); if (isset($_GET['edit_range'])) { // do not check it below ... unset($ranges[$_GET['edit_range']]); } foreach ($ranges as $range) { if ($range['grade'] == $fields['grade']) { $message = _GRADEBOOK_GRADE . " '" . $fields['grade'] . "' " . _GRADEBOOK_ALREADY_EXISTS; $message_type = 'failure'; $error = true; break; } if ($fields['range_from'] >= $range['range_from'] && $fields['range_to'] <= $range['range_to']) { $invalid_range = true; } if ($fields['range_from'] >= $range['range_from'] && $fields['range_from'] < $range['range_to'] && $fields['range_to'] >= $range['range_to']) { $invalid_range = true; } if ($fields['range_to'] > $range['range_from'] && $fields['range_to'] <= $range['range_to']) { $invalid_range = true; } if ($fields['range_from'] <= $range['range_from'] && $fields['range_to'] >= $range['range_to']) { $invalid_range = true; } if ($invalid_range) { $message = _GRADEBOOK_INVALID_RANGE . ". " . _GRADEBOOK_RANGE; $message .= " [" . $range['range_from'] . ", " . $range['range_to'] . "]" . " " . _GRADEBOOK_ALREADY_EXISTS; $message_type = 'failure'; $error = true; break; } } if ($fields['range_from'] > $fields['range_to']) { $message = _GRADEBOOK_RANGE_FROM . ' ' . _GRADEBOOK_GRATER_THAN . ' ' . _GRADEBOOK_RANGE_TO; $message_type = 'failure'; $error = true; } if ($error == false) { if (isset($_GET['add_range'])) { if (eF_insertTableData("module_gradebook_ranges", $fields)) { $smarty->assign("T_GRADEBOOK_MESSAGE", _GRADEBOOK_RANGE_SUCCESSFULLY_ADDED); } else { $message = _GRADEBOOK_RANGE_ADD_PROBLEM; $message_type = 'failure'; } } else { if (eF_updateTableData("module_gradebook_ranges", $fields, "id=" . $_GET['edit_range'])) { $smarty->assign("T_GRADEBOOK_MESSAGE", _GRADEBOOK_RANGE_SUCCESSFULLY_EDITED); } else { $message = _GRADEBOOK_RANGE_EDIT_PROBLEM; $message_type = 'failure'; } } } } $renderer = prepareFormRenderer($form); $form->accept($renderer); $smarty->assign('T_GRADEBOOK_ADD_EDIT_RANGE_FORM', $renderer->toArray()); } else { if (isset($_GET['add_column'])) { $tests = $currentLesson->getTests(true, true); $scormTests = $currentLesson->getScormTests(); $projects = $currentLesson->getProjects(false); $weights = array(); $refersTo = array("real_world" => _GRADEBOOK_REAL_WORLD_OBJECT, "progress" => _LESSONPROGRESS); for ($i = 1; $i <= 10; $i++) { $weights[$i] = $i; } if ($currentLesson->options['tests'] == 1) { foreach ($tests as $key => $test) { $refersTo['test_' . $key] = _TEST . ': ' . $test->test['name']; } } if ($currentLesson->options['scorm'] == 1) { foreach ($scormTests as $key => $scormTest) { $scorm = eF_getTableData("content", "name", "id=" . $scormTest); $refersTo['scormtest_' . $scormTest] = _SCORM . ' ' . _TEST . ': ' . $scorm[0]['name']; } } if ($currentLesson->options['projects'] == 1) { foreach ($projects as $key => $project) { $refersTo['project_' . $key] = _PROJECT . ': ' . $project['title']; } } $form = new HTML_QuickForm("add_column_form", "post", $this->moduleBaseUrl . "&add_column=1", "", null, true); $form->addElement('text', 'column_name', _GRADEBOOK_COLUMN_NAME, 'class = "inputText"'); $form->addElement('select', 'column_weight', _GRADEBOOK_COLUMN_WEIGHT, $weights); $form->addElement('select', 'column_refers_to', _GRADEBOOK_COLUMN_REFERS_TO, $refersTo); $form->addRule('column_name', _THEFIELD . ' "' . _GRADEBOOK_COLUMN_NAME . '" ' . _ISMANDATORY, 'required', null, 'client'); $form->addElement('submit', 'submit', _SUBMIT, 'class = "flatButton"'); if ($form->isSubmitted() && $form->validate()) { $values = $form->exportValues(); $fields = array("name" => $values['column_name'], "weight" => $values['column_weight'], "lessons_ID" => $currentLessonID, "creator" => $_SESSION['s_login']); if ($values['column_refers_to'] == "real_world") { $fields['refers_to_type'] = 'real_world'; $fields['refers_to_id'] = -1; } else { if ($values['column_refers_to'] == "progress") { $fields['refers_to_type'] = 'progress'; $fields['refers_to_id'] = $currentLessonID; } else { $type = explode('_', $values['column_refers_to']); $fields['refers_to_type'] = $type[0]; $fields['refers_to_id'] = $type[1]; } } if ($objectID = eF_insertTableData("module_gradebook_objects", $fields)) { $smarty->assign("T_GRADEBOOK_MESSAGE", _GRADEBOOK_COLUMN_SUCCESSFULLY_ADDED); foreach ($lessonUsers as $userLogin => $value) { $fieldsGrades = array("oid" => $objectID, "grade" => -1, "users_LOGIN" => $userLogin); if (eF_insertTableData("module_gradebook_grades", $fieldsGrades)) { $smarty->assign("T_GRADEBOOK_MESSAGE", _GRADEBOOK_COLUMN_SUCCESSFULLY_ADDED); } else { $message = _GRADEBOOK_COLUMN_ADD_PROBLEM; $message_type = 'failure'; } } } else { $message = _GRADEBOOK_COLUMN_ADD_PROBLEM; $message_type = 'failure'; } } $renderer = prepareFormRenderer($form); $form->accept($renderer); $smarty->assign('T_GRADEBOOK_ADD_COLUMN_FORM', $renderer->toArray()); } else { if (isset($_GET['edit_publish']) && isset($_GET['uid']) && isset($_GET['publish']) && eF_checkParameter($_GET['uid'], 'id') && in_array($_GET['uid'], array_keys($allUsers))) { try { $publish = !$allUsers[$_GET['uid']]['publish']; eF_updateTableData("module_gradebook_users", array("publish" => $publish), "uid=" . $_GET['uid']); echo json_encode(array('publish' => $publish)); } catch (Exception $e) { handleAjaxExceptions($e); } exit; } else { if (isset($_GET['complete_lesson']) && isset($_GET['uid']) && eF_checkParameter($_GET['uid'], 'id') && in_array($_GET['uid'], array_keys($allUsers))) { try { $user = $allUsers[$_GET['uid']]; eF_updateTableData("users_to_lessons", array("completed" => 1, 'score' => $user['score']), "lessons_ID= " . $user['lessons_ID'] . " and users_LOGIN='******'users_LOGIN'] . "'"); echo json_encode(array('completed' => 1)); } catch (Exception $e) { handleAjaxExceptions($e); } exit; } else { if (isset($_GET['change_grade']) && isset($_GET['grade']) && eF_checkParameter($_GET['change_grade'], 'id')) { $newGrade = $_GET['grade']; try { if ($newGrade != '') { if (!is_numeric($newGrade) || $newGrade > 100) { throw new EfrontContentException(_GRADEBOOK_INVALID_GRADE . ': "' . $newGrade . '". ' . _GRADEBOOK_VALID_GRADE_SPECS, EfrontContentException::INVALID_SCORE); } } else { $newGrade = -1; } $newGrade = str_replace(',', '.', $newGrade); eF_updateTableData("module_gradebook_grades", array("grade" => $newGrade), "gid=" . $_GET['change_grade']); } catch (Exception $e) { header("HTTP/1.0 500"); echo rawurlencode($e->getMessage()); } exit; } else { $smarty->assign("T_GRADEBOOK_RANGES", $ranges); if ($currentUser->getRole($this->getCurrentLesson()) == 'professor') { /* Add new students to GradeBook related tables */ $result = eF_getTableData("module_gradebook_users", "users_LOGIN", "lessons_ID=" . $currentLessonID); $allLogins = array(); foreach ($result as $user) { array_push($allLogins, $user['users_LOGIN']); } if (sizeof($result) != sizeof($lessonUsers)) { // FIXME $lessonColumns = $this->getLessonColumns($currentLessonID); foreach ($lessonUsers as $userLogin => $value) { if (!in_array($userLogin, $allLogins)) { $userFields = array("users_LOGIN" => $userLogin, "lessons_ID" => $currentLessonID, "score" => -1, "grade" => '-1'); $uid = eF_insertTableData("module_gradebook_users", $userFields); foreach ($lessonColumns as $key => $column) { $fieldsGrades = array("oid" => $key, "grade" => -1, "users_LOGIN" => $userLogin); $type = $column['refers_to_type']; $id = $column['refers_to_id']; eF_insertTableData("module_gradebook_grades", $fieldsGrades); if ($type != 'real_world') { $this->importGrades($type, $id, $key, $userLogin); } } $this->computeScoreGrade($lessonColumns, $ranges, $userLogin, $uid); } } } /* End */ $lessonColumns = $this->getLessonColumns($currentLessonID); //$allUsers = $this->getLessonUsers($currentLessonID, $lessonColumns); //we got this earlier $gradeBookLessons = $this->getGradebookLessons($currentUser->getLessons(false, 'professor'), $currentLessonID); $smarty->assign("T_GRADEBOOK_LESSON_COLUMNS", $lessonColumns); $smarty->assign("T_GRADEBOOK_GRADEBOOK_LESSONS", $gradeBookLessons); //Added by makriria because of #4613 foreach ($allUsers as $key => $value) { if (!isset($lessonUsers[$value['users_LOGIN']])) { unset($allUsers[$key]); } } if ($_GET['ajax'] == 'usersTable') { list($tableSize, $allUsers) = filterSortPage($allUsers); $smarty->assign("T_SORTED_TABLE", $_GET['ajax']); $smarty->assign("T_TABLE_SIZE", $tableSize); $smarty->assign("T_DATA_SOURCE", $allUsers); } //$smarty->assign("T_DATA_SOURCE", $allUsers); } else { if ($currentUser->getRole($this->getCurrentLesson()) == 'student') { $lessonColumns = $this->getLessonColumns($currentLessonID); $studentGrades = $this->getStudentGrades($currentUser, $currentLessonID, $lessonColumns); $smarty->assign("T_GRADEBOOK_LESSON_COLUMNS", $lessonColumns); $smarty->assign("T_GRADEBOOK_STUDENT_GRADES", $studentGrades); $smarty->assign("T_GRADEBOOK_CURRENT_LESSON_NAME", $currentLesson->lesson['name']); // Show all my lessons $studentLessons = $currentUser->getLessons(false, 'student'); $studentLessonsNames = array(); $studentLessonsColumns = array(); $studentLessonsGrades = array(); foreach ($studentLessons as $key => $value) { // Is GradeBook installed for this lesson ? $installed = eF_getTableData("module_gradebook_users", "*", "lessons_ID=" . $key . " and users_LOGIN='******'login'] . "'"); if (sizeof($installed) != 0) { $lesson = new EfrontLesson($key); $columns = $this->getLessonColumns($key); $grades = $this->getStudentGrades($currentUser, $key, $columns); array_push($studentLessonsNames, $lesson->lesson['name']); $studentLessonsColumns[$lesson->lesson['name']] = $columns; $studentLessonsGrades[$lesson->lesson['name']] = $grades; } } $smarty->assign("T_GRADEBOOK_STUDENT_LESSON_NAMES", $studentLessonsNames); $smarty->assign("T_GRADEBOOK_STUDENT_LESSON_COLUMNS", $studentLessonsColumns); $smarty->assign("T_GRADEBOOK_STUDENT_LESSON_GRADES", $studentLessonsGrades); } } } } } } } } if ($message) { $this->setMessageVar($message, $message_type); } if ($currentUser->getType() == 'administrator') { return $this->moduleBaseDir . "module_gradebook_admin.tpl"; } else { if ($currentUser->getRole($this->getCurrentLesson()) == 'professor') { return $this->moduleBaseDir . "module_gradebook_professor.tpl"; } else { if ($currentUser->getRole($this->getCurrentLesson()) == 'student') { return $this->moduleBaseDir . "module_gradebook_student.tpl"; } } } }