From 1a7fa60f6cb2ee26843ca19e37bb4ff44104ad55 Mon Sep 17 00:00:00 2001
From: Bulletin <bulletin@bulletinalpha.tk>
Date: Thu, 29 Dec 2016 16:42:32 -0500
Subject: Added existing progress

---
 dash/dash_employee.php | 28 ++++++++++++++++++++++++++++
 1 file changed, 28 insertions(+)
 create mode 100644 dash/dash_employee.php

(limited to 'dash/dash_employee.php')

diff --git a/dash/dash_employee.php b/dash/dash_employee.php
new file mode 100644
index 0000000..476ff1f
--- /dev/null
+++ b/dash/dash_employee.php
@@ -0,0 +1,28 @@
+<?php
+if (!defined('HEIRARCHY')) die;
+$title = 'Dashboard / Bulletin';
+require('header.php');
+$page = 1;
+if (!empty($_GET['p'])) $page = max(1, intval($_GET['p']));
+$result = $db->query('SELECT ads.*, categories.cat_name, SUM(ratings.stars) / COUNT(ratings.stars) AS rating FROM ads LEFT JOIN categories ON ads.cat = categories.id LEFT JOIN ratings ON ads.uid = ratings.rated GROUP BY ads.id LIMIT ' . 10*($page-1) . ', 10') or fatal($db->error);
+while ($row = $result->fetch_assoc()) {
+?>
+      <div class="job">
+        <a href="#" class="jobxbtn"></a>
+        <p class="jobtitle"><a href="ads.php?id=<?=$row['id'];?>"><?=htmlentities($row['title']);?></a></p>
+        <p class="joblocation"><?=htmlentities($row['location']);?></p>
+<?php
+  if (is_null($row['rating']))
+    echo '        <p class="jobstars">Employer Not Rated</p>'.PHP_EOL;
+  else
+    echo '        <p class="jobstars">'.$row['rating'].' Star Employer</p>'.PHP_EOL;
+?>
+        <p class="jobpay">Pays $<?=number_format($row['pay'], 2);?></p>
+        <p class="jobblurb"><?=htmlentities(substr($row['description'], 0, min(strlen($row['description']), 160)));?> <a href="ads.php?id=<?=$row['id'];?>">[...]</a></p>
+        </p>
+      </div>
+<?php
+}
+$result->free();
+require('footer.php');
+?>
-- 
cgit v1.2.3