public static function getNoteById($bdd, $id) { $note = $bdd->prepare('SELECT * FROM note_frais WHERE id = :id LIMIT 1'); $note->execute(array(':id' => $id)); $array = $note->fetch(); $CloneNote = new Note(); $CloneNote->setDate($array['date']); $CloneNote->setId($array['id']); $CloneNote->setName($array['name']); $CloneNote->setStatut($array['statut_id']); $CloneNote->setUser($array['user_id']); return $CloneNote; }
/** * Updates Submission Note * @param $articleId int */ function updateSubmissionNote($articleId, $request) { import('classes.file.ArticleFileManager'); $noteDao =& DAORegistry::getDAO('NoteDAO'); $user =& $request->getUser(); $journal =& $request->getJournal(); $note = new Note(); $note->setId($request->getUserVar('noteId')); $note->setAssocType(ASSOC_TYPE_ARTICLE); $note->setAssocId($articleId); $note->setUserId($user->getId()); $note->setDateModified(Core::getCurrentDate()); $note->setContextId($journal->getId()); $note->setTitle($request->getUserVar('title')); $note->setContents($request->getUserVar('note')); $note->setFileId($request->getUserVar('fileId')); if (HookRegistry::call('SectionEditorAction::updateSubmissionNote', array(&$articleId, &$note))) { return; } $articleFileManager = new ArticleFileManager($articleId); // if there is a new file being uploaded if ($articleFileManager->uploadedFileExists('upload')) { // Attach the new file to the note, overwriting existing file if necessary $fileId = $articleFileManager->uploadSubmissionNoteFile('upload', $note->getFileId(), true); $note->setFileId($fileId); } else { if ($request->getUserVar('removeUploadedFile')) { $articleFileManager = new ArticleFileManager($articleId); $articleFileManager->deleteFile($note->getFileId()); $note->setFileId(0); } } $noteDao->updateObject($note); }
/** * Updates Submission Note * @param $paperId int */ function updateSubmissionNote($paperId) { import('classes.file.PaperFileManager'); $noteDao = DAORegistry::getDAO('NoteDAO'); $user =& Request::getUser(); $conference =& Request::getConference(); $note = new Note(); $note->setId(Request::getUserVar('noteId')); $note->setAssocType(ASSOC_TYPE_PAPER); $note->setAssocId($paperId); $note->setUserId($user->getId()); $note->setDateModified(Core::getCurrentDate()); $note->setContextId($conference->getId()); $note->setTitle(Request::getUserVar('title')); $note->setContents(Request::getUserVar('note')); $note->setFileId(Request::getUserVar('fileId')); if (HookRegistry::call('SectionEditorAction::updateSubmissionNote', array(&$paperId, &$note))) { return; } $paperFileManager = new PaperFileManager($paperId); // if there is a new file being uploaded if ($paperFileManager->uploadedFileExists('upload')) { // Attach the new file to the note, overwriting existing file if necessary $fileId = $paperFileManager->uploadSubmissionNoteFile('upload', $note->getFileId(), true); $note->setFileId($fileId); } else { if (Request::getUserVar('removeUploadedFile')) { $paperFileManager = new PaperFileManager($paperId); $paperFileManager->deleteFile($note->getFileId()); $note->setFileId(0); } } $noteDao->updateObject($note); }
public function getFachNoten($schueler_id, $fach_id) { $sql = "SELECT n.note_id AS note_id, \n\t\t\t\tn.schueler_id AS schueler_id, \n\t\t\t\tn.typ AS typ, \n\t\t\t\tn.punkte AS punkte,\n\t\t\t\tu.unterrichtsstunde_id AS unterrichtsstunde_id\n\t\t\t\tFROM note n, unterrichtsstunde u\n\t\t\t\tWHERE u.unterrichtsstunde_id=n.unterrichtsstunde_id\n\t\t\t\tAND n.schueler_id=" . $schueler_id . " \n\t\t\t\tAND u.fach_id=" . $fach_id . ";"; try { $result = mysql_query($sql); if (!$result) { throw new MysqlException(); } $noten = array(); while ($row = mysql_fetch_assoc($result)) { $n = new Note(); $n->setId($row['note_id']); $n->setSchueler_id($row['schueler_id']); $n->setTyp($row['typ']); $n->setPunkte($row['punkte']); $n->setUnterrichtsstunde_id($row['unterrichtsstunde_id']); $noten[$n->getId()] = $n; } } catch (MysqlException $e) { Html::showAll($e); } return $noten; }