diff options
Diffstat (limited to 'dash/jobs.php')
| -rw-r--r-- | dash/jobs.php | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/dash/jobs.php b/dash/jobs.php new file mode 100644 index 0000000..db473cb --- /dev/null +++ b/dash/jobs.php @@ -0,0 +1,24 @@ +<?php +define('HEIRARCHY', 1); +require('dash_common.php'); + +$title = 'Rate / Bulletin'; +$extra_head = '<link rel="stylesheet" type="text/css" href="css/jobs.css" />'; +require('header.php'); +if ($b_user['type'] == 'EMPLOYER') { + $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 = responses.uid LEFT JOIN ratings ON ratings.rated = users.id WHERE ads.uid = '.$b_user['id'].' GROUP BY responses.id ORDER BY rated ASC') 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'].' GROUP BY responses.id ORDER BY rated ASC') 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()) { + $review = $db->query('SELECT ratings.stars, ratings.comment FROM ratings WHERE ratings.rated = '.$row['uid'].' AND ratings.job = '.$row['adid'].' AND ratings.rater = '.$b_user['id'].' LIMIT 1'); + draw_rate($row, $review->fetch_assoc()); + $review->free(); +} +$result->free(); +require('footer.php'); +?> |