public function executeImportNewTwo(sfWebRequest $request)
{
if (!$request->isMethod(sfWebRequest::POST) || !$request->hasParameter("critique_year") || !$request->hasParameter("critique_term")) {
$this->forward404("not enough parameters");
}
$this->repeat = AutoCourseRatingPeer::isYearPresent($request->getParameter("critique_year") . $request->getParameter("critique_term"));
$this->data = ImportMappingPeer::getAll();
$c = new Criteria();
$c->addAscendingOrderByColumn(EnumItemPeer::ID);
$this->mappingTypes = EnumItemPeer::getAllForParentNodeId(EnumItemPeer::MAPPING_ITEMS_NODE_ID, null, $c);
}
public function executeRatingfields(sfWebRequest $request)
{
if (helperFunctions::isLoggedIn($request)) {
$this->buildSubmenu();
$this->form = new skuleForm("frm", "maintenance/ratingfields", $request);
$conn = Propel::getConnection();
$this->ratingTypeList = array();
$ratingTypeList = EnumItemPeer::getAllForParentNodeId(EnumItemPeer::RATING_TYPES_NODE_ID, $conn);
foreach ($ratingTypeList as $enumObj) {
$this->ratingTypeList[$enumObj->getId()] = $enumObj->getDescr();
//TODO
$this->selectedRatingType = $enumObj->getId();
}
} else {
// redirect to log in page
$this->buildSubmenu();
}
}
private function getMenuStud()
{
$conn = Propel::getConnection();
$arr = EnumItemPeer::getAllForParentNodeId(EnumItemPeer::EXAM_TYPES_NODE_ID);
$str = "<div class='grayout_dialog' id='submitExam'>\n <script type='text/javascript'>\n \tfunction securityFrameOnLoad(){\n \t\tif (hidSecurityFrame.document.getElementById('status')) {\n \t\t\tvar status = hidSecurityFrame.document.getElementById('status').value; \n \t\t\tif (status == 'Success'){\n \t\t\t\tdocument.getElementById('inputButtons').style.display = 'none';\n \t\t\t\tdocument.getElementById('successButtons').style.display = 'block';\n \t\t\t\tdispStatus('Submission Successful');\n \t\t\t} else if (status == 'Security'){\n \t\t\t\tdispStatus('Security string does not match.');\n \t\t\t} else {\n \t\t\t\tdispStatus('An error occurred. Please try again later.');\n \t\t\t}\n \t\t}\n \t}\n \t\n \tfunction submitExamOnSubmit(){\n \t\t// check that everything has been filled in before submission\n \t\tvar year = trim(document.exam_submission.year.value);\n \t\tif (year == ''){\n \t\t\tdispStatus('You must specify a year.');\n \t\t\treturn false;\n \t\t}\n \t\tif (isNaN(year) || year < 1990 || year > 2020){\n \t\t\tdispStatus('Year must be bigger than 1990 and smaller than 2020.');\n \t\t\treturn false;\n \t\t}\n \t\tif (trim(document.exam_submission.security.value) == ''){\n \t\t\tdispStatus('You must type in the security string.');\n \t\t\treturn false;\n \t\t}\n \t\tif (trim(document.exam_submission.descr.value) == ''){\n \t\t\tdispStatus('You must type in the display title.');\n \t\t\treturn false;\n \t\t}\n \t\tvar fileName = trim(document.exam_submission.file.value);\n \t\tif (fileName == ''){\n \t\t\tdispStatus('No file has been selected.');\n \t\t\treturn false;\n \t\t}\n \t\tif (fileName.lastIndexOf('pdf')==-1 && fileName.lastIndexOf('PDF')==-1){\n \t\t\tdispStatus('Only a PDF file can be submitted.');\n \t\t\treturn false;\n \t\t}\n\n \t\treturn true;\n \t}\n \t\n \tfunction dispStatus(msg){\n \t\tdocument.getElementById('statusSpan').style.display = 'block';\n \t\tdocument.getElementById('statusSpan').innerHTML = msg;\n \t}\n \t\n \tfunction cancelAction(){\n \t\tgrayout('submitExam');\n \t\tdocument.getElementById('statusSpan').style.display = 'none';\n \t\tdocument.getElementById('inputButtons').style.display = 'block';\n \t\tdocument.getElementById('successButtons').style.display = 'none';\n \t\tdocument.exam_submission.security.value='';\n \t}\n </script>\n <h3>Submit Exam</h3>\n <form name='exam_submission' method='post' enctype='multipart/form-data' action='" . url_for("invisible/submitExam") . "' target='hidSecurityFrame'>\n\t <table>\n\t\t <tr><td width='100'>Course:</td><td align='left'>{$this->_courseId}\n\t\t <input type='hidden' name='course' value='{$this->_courseId}'/></td></tr>\n\t\t <tr><td>Type:</td><td align='left'><select name='type' style='width:100px'>";
foreach ($arr as $enum) {
$str .= "<option value='{$enum->getId()}'>{$enum->getDescr()}</option>";
}
$str .= "</select></td></tr>\n\t\t <tr><td>Year:</td><td align='left'><input type='text' name='year' style='width:100px'/></td></tr>\n\t\t <tr><td>Term:</td><td>\n\t\t \t<input type='radio' name='term' id='radioFall' value='9' CHECKED><label for='radioFall'>Fall</label>\n\t\t \t<input type='radio' name='term' id='radioSummer' value='5'><label for='radioSummer'>Summer</label>\n\t\t \t<input type='radio' name='term' id='radioWinter' value='1'><label for='radioWinter'>Winter</label>\n\t\t </td></tr>\n\t\t <tr><td>Display Title:</td><td align='left'><input type='text' name='descr' /></td></tr>\n\t\t <tr><td>File:</td><td align='left'><input type='file' name='file' /></td></tr>\n\t\t <tr><td> </td></tr>\n\t\t <tr><td></td><td align='left'><img src='" . url_for('invisible/securityImage') . "'/></td></tr>\n\t\t <tr><td>Security String:</td><td><input type='text' name='security' /></td></tr>\n\t </table><br/>\n \t<div id='inputButtons'><input type='submit' onclick='return submitExamOnSubmit();' value='Submit'/><input type='button' onclick='cancelAction()' value='Cancel'/></div>\n \t<div id='successButtons' style='display:none'><input type='button' onclick='cancelAction()' value='Close'/></div>\n </form>\n <iframe name='hidSecurityFrame' style='display:none' onload='securityFrameOnLoad()';></iframe>\n <br/><span style='display:none' id='statusSpan'>Please wait...</span>\n </div>";
if ($this->_menuOption == subMenuOptions::SEARCH) {
$str .= "<dl><dt>Search</dt></dl>";
} else {
$str .= "<dl><dt>" . link_to("Search", "search/index") . "</dt></dl>";
}
return $str;
}
<?php
$conn = Propel::getConnection();
$arr = EnumItemPeer::getAllForParentNodeId(EnumItemPeer::EXAM_TYPES_NODE_ID, $conn);
?>
<div class='grayout_dialog' id='submitExam'>
<script type='text/javascript'>
function securityFrameOnLoad(){
if (hidSecurityFrame.document.getElementById('status')) {
var status = hidSecurityFrame.document.getElementById('status').value;
if (status == 'Success'){
document.getElementById('inputButtons').style.display = 'none';
document.getElementById('successButtons').style.display = 'block';
dispStatus('Submission Successful');
} else if (status == 'Security'){
dispStatus('Security string does not match.');
} else {
dispStatus('An error occurred. Please try again later.');
}
}
}
function submitExamOnSubmit(){
// check that everything has been filled in before submission
var year = trim(document.exam_submission.year.value);
if (year == ''){
dispStatus('You must specify a year.');
return false;
}
if (isNaN(year) || year < 1990 || year > 2020){
public function executeSearchByProgram(sfWebRequest $request)
{
$conn = Propel::getConnection();
$today = getdate();
$this->searchType = searchActions::SEARCH_BY_PROGRAM;
$rawProgList = EnumItemPeer::getAllForParentNodeId(EnumItemPeer::DISCIPLINES_NODE_ID, $conn);
$this->programList = array();
foreach ($rawProgList as $obj) {
$this->programList[$obj->getId()] = $obj->getDescr();
}
$this->yearList = array("0" => "All", "1" => "First Year", "2" => "Second Year", "3" => "Third Year", "4" => "Fourth Year");
if ($request->hasParameter("year") && $request->hasParameter("program")) {
$this->programId = $request->getParameter("program");
if (helperFunctions::isMaliciousString($this->programId)) {
$this->forward404();
}
$this->year = $request->getParameter("year");
if (helperFunctions::isMaliciousString($this->year)) {
$this->forward404();
}
// get result set
$enum = EnumItemPeer::retrieveByPK($this->programId, $conn);
$this->resultTitle = "Results for " . $enum->getDescr();
$this->results = CoursePeer::findCoursesByDisciplineIdAndYear($this->programId, $this->year, $conn);
} else {
$this->programId = $rawProgList[0]->getId();
$this->year = 1;
}
}
