blob: db473cb613c9165a9f1c08493392ee08c9ace47b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
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');
?>
|
