function prepareHunterProfile($dbh, $username) { // for the hunter profile page, we need // 1) the username // 2) the email // 3) the path to the profile picture // 4) all the reports this user has ever submitted // (paid and non-paid) (all info including bountyID) $args[':username'] = $username; $template_array['user'] = getHunterFromUsername($dbh, $args); $template_array['submittedReports'] = getReportsFromUsername($dbh, $args); $template_array['user']['numReportsFiled'] = sizeof($template_array['submittedReports']['result']); $template_array['reportsApproved'] = getNumberReportsApproved($dbh, $args); $template_array['user']['numReportsApproved'] = sizeof($template_array['reportsApproved']['result']); $template_array['pastBounties'] = getBountiesFromUsername($dbh, $args); return $template_array; }
$result = updateReport($dbh, $args, $changeCode); $result['post'] = $_POST; echo json_encode($result); }); /* Ryan Edson getReportsFromUsername Returns all reports a username has submitted Error Codes: Returns complete */ $app->get('/api/getReportsFromUsername/:username', function ($username) use($dbh) { $args[':username'] = $username; echo json_encode(getReportsFromUsername($dbh, $args)); }); $app->get('/api/getReportFromReportID/:reportID', function ($reportID) use($dbh) { $args[':reportID'] = $reportID; $functionArray = array(); $statement = $dbh->prepare("SELECT Report.*, DATE(Report.datePaid) as datePaid, BountyPool.bountyName FROM Report\n WHERE reportID = :reportID\n AND BountyPool.poolID = Report.bountyID"); if ($statement->execute($args)) { $functionArray['result'] = array(); while ($row = $statement->fetch(PDO::FETCH_ASSOC)) { array_push($functionArray['result'], $row); } $functionArray['error'] = '0'; $functionArray['message'] = 'success'; } else { $functionArray['error'] = '1'; $functionArray['messageDB'] = $sth->errorInfo();