From ca71122b9a343bacd6c0b2933ddf295ebcff4f07 Mon Sep 17 00:00:00 2001 From: Carson Fleming Date: Thu, 16 Mar 2017 21:28:51 -0700 Subject: Final candidate for alpha version, moving to beta soon --- dash/rate.php | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 dash/rate.php (limited to 'dash/rate.php') diff --git a/dash/rate.php b/dash/rate.php new file mode 100644 index 0000000..767d4ba --- /dev/null +++ b/dash/rate.php @@ -0,0 +1,24 @@ +query('SELECT users.id AS uid, users.name, ads.id AS adid, ads.title, ads.time, SUM(ratings.stars) / COUNT(ratings.stars) AS rating FROM ads INNER JOIN responses ON responses.adid = ads.id AND responses.matched = 1 INNER JOIN users ON users.id = responses.uid LEFT JOIN ratings ON ratings.rated = users.id WHERE ads.uid = '.$b_user['id'].' AND NOT EXISTS (SELECT ratings.id FROM ratings WHERE ratings.rated = responses.uid AND ratings.job = ads.id AND ratings.rater = '.$b_user['id'].') GROUP BY responses.id') or dash_fatal($db->error); + if ($result->num_rows < 1) draw_norate_p(); +} else if ($b_user['type'] == 'EMPLOYEE') { + $result = $db->query('SELECT users.id AS uid, users.name, ads.id AS adid, ads.title, ads.time, SUM(ratings.stars) / COUNT(ratings.stars) AS rating FROM ads INNER JOIN responses ON responses.adid = ads.id AND responses.matched = 1 INNER JOIN users ON users.id = ads.uid LEFT JOIN ratings ON ratings.rated = users.id WHERE responses.uid = '.$b_user['id'].' AND NOT EXISTS (SELECT ratings.id FROM ratings WHERE ratings.rated = ads.uid AND ratings.job = ads.id AND ratings.rater = '.$b_user['id'].') GROUP BY responses.id') or dash_fatal($db->error); + if ($result->num_rows < 1) draw_norate_s(); +} +else dash_fatal('Only job seekers and job providers can rate one another.'); + +while ($row = $result->fetch_assoc()) { + draw_rate($row); +} +$result->free(); +?> + + -- cgit v1.2.3