function listTasksByUser($inuserid)
{
$tasks = array();
$dbhandle = db_connect();
$query = "SELECT TaskID FROM Tasks WHERE Lister={$inuserid}";
$result = $dbhandle->query($query);
while ($row = $result->fetch_array()) {
$newtask = new task();
$newtask->getFromDB($row['TaskID']);
if ($newtask->active == 0) {
continue;
}
array_push($tasks, $newtask);
}
$dbhandle->close();
return $tasks;
}
<?php
require_once 'db_connect.php';
require_once 'task_class.php';
//Is run by the server periodically to check if a task has ended.
$dbhandle = db_connect();
$stmt = $dbhandle->stmt_init();
$stmt->prepare("SELECT TaskID, (EndDateTime - ?) AS TimeRemaining FROM Tasks WHERE Active=1 HAVING TimeRemaining<=0");
$stmt->bind_param("i", time());
$stmt->execute();
$stmt->store_result();
$stmt->bind_result($taskID, $tmptime);
while ($stmt->fetch()) {
$task = new task();
$task->getFromDB($taskID);
$task->endTask();
unset($task);
}
$stmt->close();
$dbhandle->close();
session_start();
}
//get the id of the task to be reviewed, blank page if none
$intaskid;
if (isset($_GET['id'])) {
$intaskid = $_GET['id'];
} else {
die;
}
if (!isset($_SESSION['userid'])) {
die;
}
$error = array();
//get the task info
$task = new task();
$error = $task->getFromDB($intaskid);
if ($error != NULL) {
die;
}
//review form was submitted
if (isset($_POST['submit'])) {
//prepare review info to be sent to POST
$_POST['taskid'] = $intaskid;
$review = new review();
$error = $review->getFromPOST($_POST);
if (count($error) == 0) {
$_SESSION['msg_reviewed'] = "Review placed";
header("Location: /ViewTask.php?id=" . $intaskid);
die;
} else {
die;
public function initialize($info)
{
$error = array();
//check if task exists
$task = new task();
if (isset($info['taskid']) && $task->checkExistence($info['taskid'])) {
$this->taskid = $info['taskid'];
} else {
$error['taskid'] = true;
}
//check if task is already rated
//strip tags from comment before adding
if (isset($info['comment'])) {
$this->comment = strip_tags($info['comment']);
} else {
$error['comment'] = true;
}
//check if rating is a number between 0 and 5 inclusive
if (isset($info['rating']) && is_numeric($info['rating']) && $info['rating'] >= 0 && $info['rating'] <= 5) {
$this->rating = $info['rating'];
} else {
$error['rating'] = true;
}
//1 if a Doer rating, 0 if a Lister rating
//determine if Lister or Doer
$task->getFromDB($this->taskid);
$bidwinner = $task->getBidLeaderID();
//Must be logged in
if (!isset($_SESSION['userid'])) {
$error['login'] = true;
} else {
//If you're the winner, you are leaving a review for the Lister
if ($_SESSION['userid'] == $bidwinner) {
$this->reviewee_uid = $task->userid;
$this->listerOrDoer = false;
} else {
if ($_SESSION['userid'] == $task->userid) {
$this->reviewee_uid = $bidwinner;
$this->listerOrDoer = true;
} else {
$error['notinvolved'] = true;
}
}
}
$this->timestamp = time();
return $error;
}
<?php
require_once 'task_class.php';
if (isset($_POST['taskid'])) {
$task = new task();
$task->getFromDB($_POST['taskid']);
} else {
$error['invalidtaskid'] = true;
echo json_encode($error);
return;
}
if (isset($_POST['bidderid']) && isset($_POST['bidamt'])) {
$error = $task->addBid($_POST['bidderid'], $_POST['bidamt']);
if ($error == null) {
$error['Success'] = true;
}
echo json_encode($error);
} else {
$error['invalidbidderidorbidamt'] = true;
echo json_encode($error);
}
