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