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