File: /home/awaldron/public_html/archive/demo/admin/feature_employee.php
<?php
session_start();
include("../_functions.php");
dbconnect();
if (!is_logged()) auto_login();
echo "<html>\n";
echo "<head>\n";
echo "<title>".COMPANY_NAME." : Feature Employee</title>\n";
echo "</head>\n";
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../default.css\">\n";
echo "<body style=\"margin:15px;\">\n";
if (!admin_panel($_SESSION["auth_user"])) {
echo "<br><br><br><br>".error("You must be logged in to access the administration panel!");
} else {
echo "<P><img src=\"/gui/icons/cog.gif\" align=\"left\">\n";
echo "<div class=\"headline\">Set Feature Employee</div>\n";
echo "<P>This panel displays each user that has enough information in their profile to qualify them for the Intranet's Feature Employee.\n";
if (isset($_GET["set"])) {
quickUPDATE("UPDATE tbl_variables SET var_value='".$_GET["set"]."' WHERE var_name='feat_emp'");
quickUPDATE("UPDATE tbl_employees SET eotw=1 WHERE username='".$_GET["set"]."'");
update_constants();
}
$current = FEAT_EMP;
$sql = "SELECT * FROM tbl_employees WHERE my_job <> '' AND is_employee=1 AND eotw=0 AND emp_type_id < 4 AND (my_career <> '' OR my_family <> '' OR my_interests <> '') OR username='".$current."' ORDER BY eotw DESC, lname ASC";
$result = mysql_query($sql);
//echo "<br><br><br><br><b>The current featured employee is <a href=\"/profile.php?u=".."\" target=\"new\">".get_user(FEAT_EMP,"fullname")."</a></b>\n";
echo "<br><br><br><br><table border=0 cellspacing=0 cellpadding=3>\n";
echo "<tr class=\"header\"><td colspan=2>Employee Name</td><td align=center>Job</td><td align=center>Career</td><td align=center>Family</td><td align=center>Interests</td><td></td></tr>\n";
$ctr = 0;
for ($i=0; $i < mysql_num_rows($result); $i++) {
$row = mysql_fetch_array($result);
$has_photo = TRUE;
$photo = "../gui/photos/".$row["username"].".jpg";
if (!file_exists($photo)) {
$has_photo = FALSE;
$photo = "../gui/photos/th_nophoto.jpg";
}
if ($has_photo) {
if ($i==0) echo "<tr bgcolor=#FDED63>\n";
else echo "<tr".($ctr%2==0?" bgcolor=#FFFFFF":" bgcolor=#EEEEEE").">\n";
echo " <td><a href=\"/profile.php?u=".$row["username"]."\" target=\"new\"><img src=\"/image.php?u=".$row["username"]."&s=1\" border=1 width=34 height=43></a></td>\n";
echo " <td><a href=\"/profile.php?u=".$row["username"]."\" target=\"new\">".$row["lname"].", ".$row["fname"]."</a></td>\n";
echo " <td align=center> <img src=\"../gui/".(strlen($row["my_job"])>5?"check":"x").".gif\"> </td>\n";
echo " <td align=center> <img src=\"../gui/".(strlen($row["my_career"])>5?"check":"x").".gif\"> </td>\n";
echo " <td align=center> <img src=\"../gui/".(strlen($row["my_family"])>5?"check":"x").".gif\"> </td>\n";
echo " <td align=center> <img src=\"../gui/".(strlen($row["my_interests"])>5?"check":"x").".gif\"> </td>\n";
if ($i==0) echo " <td> <b>Current Feature Employee</b> </td>\n";
else echo " <td> <a href=\"feature_employee.php?set=".$row["username"]."\">Set '".$row["username"]."' as Feature Employee</a> </td>\n";
echo "</tr>\n";
$ctr++;
}
}
echo "</table>\n";
echo "<P><b>".($ctr-1)." eligible users.</b>\n";
echo "<br><br><br><br>\n";
echo "<center>Powered by <a href=\"http://www.intrabreeze.com\">IntraBreeze</a> © 2005 IntraBreeze, LLC</center>\n";
}
echo "</body>\n</html>\n";
?>