File: /home/awaldron/public_html/archive/demo/admin/employee_categories.php
<?php
session_start();
include("../_functions.php");
dbconnect();
if (!is_logged()) auto_login();
echo "<html>\n";
echo "<head>\n";
echo "<title>".COMPANY_NAME." : Employee Categories</title>\n";
echo "<script language=\"JavaScript\" type=\"text/javascript\">\n";
echo "<!--\n";
echo "function openWindow(theURL,winName,features) { //v2.0\n";
echo " window.open(theURL,winName,features);\n";
echo "}\n";
echo "function confirm_delete(id) {\n";
echo " input_box=confirm(\"Are you sure you want to delete this Employee Category?\");\n";
echo " if (input_box==true) {\n";
echo " self.location=\"employee_categories.php?del=\"+id;\n";
echo " }\n";
echo "}\n";
echo "-->\n";
echo "</script>\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 {
if (isset($_GET["del"])) {
quickUPDATE("UPDATE tbl_employees SET emp_type_id=0 WHERE emp_type_id=".$_GET["del"]);
quickUPDATE("DELETE FROM tbl_emp_types WHERE emp_type_id=".$_GET["del"]);
}
if (isset($_POST["newcatgo"])) {
quickUPDATE("INSERT INTO tbl_emp_types (emp_type) VALUES ('".$_POST["newcat"]."')");
}
echo "<P><img src=\"/gui/icons/cog.gif\" align=\"left\">\n";
echo "<div class=\"headline\">Employee Categories</div>\n";
echo "<P>From this control panel, you have the ability to add/remove employee categories.\n";
echo "<br><br><br><div class=\"headline\">Employee Categories</div>\n";
echo "<p><table class=\"textdn\" border=0 cellspacing=1 cellpadding=3 width=60% bgcolor=\"#".COLOR_TBAR."\">\n";
echo "<tr class=\"header\"><td><b>Employee Category</b></td><td align=\"center\"><b># Employees</b></td><td><b>Actions</b></td></tr>\n";
$sql = "SELECT * FROM tbl_emp_types ORDER BY emp_type_id ASC";
$res = mysql_query($sql);
for ($i=0; $i < mysql_num_rows($res); $i++) {
$row = mysql_fetch_array($res);
echo "<tr".($i%2==0?" bgcolor=#FFFFFF":" bgcolor=#EEEEEE").">\n";
echo "<td>".$row["emp_type"]."</td>\n";
echo "<td align=\"center\">".quickSQL("SELECT COUNT(eid) FROM tbl_employees WHERE is_employee=1 AND emp_type_id=".$row["emp_type_id"])."</td>\n";
echo "<td><a href=\"employee_list.php?tab=".($row["emp_type_id"]==1?"a":"all")."&id=".$row["emp_type_id"]."\">View List</a> | <a href=\"#\" onClick=\"openWindow('quick_change.php?a=rename_cat&id=".$row["emp_type_id"]."','','resizable=yes,width=350,height=235')\">Rename</a> | <a href=\"#\" onClick=\"openWindow('quick_change.php?a=move_cat&from=".$row["emp_type_id"]."','','resizable=yes,width=350,height=235')\">Move Employees</a> | <a href=\"JavaScript:confirm_delete(".$row["emp_type_id"].")\">Delete</a></td>\n";
echo "</tr>\n"; $j=$i;
}
$j++;
echo "<tr".($j%2==0?" bgcolor=#FFFFFF":" bgcolor=#EEEEEE").">\n";
echo "<td>Deleted Employees</td>\n";
echo "<td align=\"center\">".quickSQL("SELECT COUNT(eid) FROM tbl_employees WHERE is_employee=0")."</td>\n";
echo "<td><a href=\"employee_list.php?tab=all&id=x\">View List</a></td>\n";
echo "</tr>\n";
echo "</table>\n";
echo "<br><br><br><div class=\"headline\">Add a New Category</div>\n";
echo "<form action=\"employee_categories.php\" method=\"POST\">\n";
echo "<P><b>New Category Name: <input type=\"text\" name=\"newcat\"> <input type=\"submit\" value=\"Go\" name=\"newcatgo\">\n";
echo "</form>\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";
?>