public static function run() { // Perform actions related to a user $action = array_key_exists('action', $_SESSION) ? $_SESSION['action'] : ""; $arguments = $_SESSION['arguments']; switch ($action) { case "new": self::newUser(); break; case "show": $users = UsersDB::getUsersBy('userId', $arguments); $_SESSION['user'] = !empty($users) ? $users[0] : null; self::show(); break; case "showall": $_SESSION['review'] = ReviewDB::getReviewsBy(); $_SESSION['reviews'] = ReviewDB::getReviewsBy(); $_SESSION['headertitle'] = "h00dFliX Reviews"; $_SESSION['footertitle'] = "<h3>The footer goes here</h3>"; ReviewsView::showall(); break; case "update": echo "Update"; self::updateUser(); break; default: } }
public static function run() { $action = array_key_exists('action', $_SESSION) ? $_SESSION['action'] : ""; $arguments = $_SESSION['arguments']; switch ($action) { case "new": if ($_SERVER["REQUEST_METHOD"] == "POST") { $reviewData = new ReviewData($_POST); if ($reviewData->getErrorCount() == 0) { $dbReviewData = ReviewDB::addReview($reviewData); HomeView::show(); } else { ReviewView::show($reviewData); } } else { ReviewView::show(null); } break; case "show": $users = UsersDB::getUsersBy('userId', $arguments); $_SESSION['user'] = !empty($users) ? $users[0] : null; self::show(); break; case "showall": $_SESSION['reviews'] = ReviewDB::getReviewsBy(); $_SESSION['headertitle'] = "h00dFliX Reviews"; $_SESSION['footertitle'] = "<h3>The footer goes here</h3>"; ReviewsView::showall(); break; case "update": echo "Update"; self::updateUser(); break; default: } }
function addSubmission($paperId, $submissionType, $filePointer, $fileMime) { try { if (is_int($paperId) or Util::validateSubmitType($submissionType)) { $submissionSql = "INSERT INTO Submission (reviewStatus, type, file, file_mime, paper_id)\n VALUES (0, :submissionType, :filee, :fileMime, :paperId);"; $paperSql = "UPDATE Paper SET status = :submissionType * 10"; $this->conn->beginTransaction(); $submissionStmt = $this->conn->prepare($submissionSql); $submissionStmt->bindValue(":submissionType", $submissionType, PDO::PARAM_INT); $submissionStmt->bindValue(":filee", $filePointer, PDO::PARAM_LOB); $submissionStmt->bindValue(":fileMime", $fileMime); $submissionStmt->bindValue(":paperId", $paperId); $submissionStmt->execute(); $submissionId = $this->conn->lastInsertId(); $paperStmt = $this->conn->prepare($paperSql); $paperStmt->bindValue(":submissionType", $submissionType, PDO::PARAM_INT); $paperStmt->execute(); $this->conn->commit(); $assignReviewJob = new ReviewDB(); $assignReviewJob->assignReviewJob($submissionId); } else { return -1; } } catch (PDOException $e) { return -1; } }
<?php include_once '../model/util/autoload.php'; error_reporting(E_ALL); ini_set('display_errors', 1); $reviewDB = new ReviewDB(); var_dump($reviewDB->getReviewJobs(1));
public static function getReviewsBy($type = null, $value = null) { // Returns Review objects whose $type field has value $value $reviewRows = ReviewDB::getReviewRowSetsBy($type, $value); return ReviewDB::getReviewsArray($reviewRows); }