fannie/modules/plugins2.0/WfcHoursTracking/disabled/WfcHtEmpWeekly.php
<?php
class WfcHtEmpWeekly {}
/**
No longer in use; not cleaned up to be plugin-safe.
Kept for reference.
include(dirname(__FILE__).'/../../../config.php');
require(__DIR__ . '/../../../auth/login.php');
if (!validateUserQuiet('view_all_hours')){
header("Location: {$FANNIE_URL}auth/ui/loginform.php?redirect={$_SERVER['PHP_SELF']}");
return;
}
require(dirname(__FILE__).'/db.php');
$sql = hours_dbconnect();
$empID = -1;
if (isset($_GET["empID"])) $empID = $_GET["empID"];
if (isset($_POST["empID"])){
$empID = $_POST["empID"];
$notes = str_replace("'","''",$_POST["notes"]);
$checkP = $sql->prepare("SELECT empID FROM EmpWeeklyNotes WHERE empID=?");
$checkR = $sql->execute($checkP, array($empID));
if ($sql->num_rows($checkR) == 0){
$ins = $sql->prepare("INSERT INTO EmpWeeklyNotes VALUES (?,?)");
$sql->execute($ins, array($empID, $notes));
}
else{
$up = $sql->prepare("UPDATE EmpWeeklyNotes SET notes=? WHERE empID=?");
$sql->execute($up, array($notes, $empID));
}
}
$limitQ = "SELECT weekStart FROM weeklyHours GROUP BY weekStart ORDER BY weekStart DESC";
$limitR = $sql->query($limitQ);
$limitDay = "";
$limit2 = "";
$weekHeaders = array();
$i = 0;
while($limitW = $sql->fetch_row($limitR)){
array_unshift($weekHeaders,$limitW[0]);
if($i==0) $limit2 = $limitW[0];
if($i==12) $limitDay = $limitW[0];
$i++;
}
if (isset($_GET["start"])) $limitDay = $_GET["start"];
if (isset($_POST["start"])) $limitDay = $_POST["start"];
if (isset($_GET["end"])) $limit2 = $_GET["end"];
if (isset($_POST["end"])) $limit2 = $_POST["end"];
$query = "SELECT e.name,e.adpID,d.name,n.notes,
w.hours,w.weekStart,w.weekEnd
FROM employees as e LEFT JOIN Departments
AS d ON e.department = d.deptID LEFT JOIN
EmpWeeklyNotes AS n on e.empID = n.empID
LEFT JOIN weeklyHours AS w ON e.empID=w.empID
WHERE datediff(w.weekStart,?) >= 0
AND datediff(w.weekStart,?) <= 0
AND e.empID=?
ORDER BY w.weekStart";
$prep = $sql->prepare($query);
$result = $sql->execute($prep, array($limitDay, $limit2, $empID));
$name = "";
$adpID = "";
$dept = "";
$notes = "";
$hours = array();
$labels = array();
while($row = $sql->fetch_row($result)){
$name = $row[0];
$adpID = $row[1];
$dept = $row[2];
$notes = $row[3];
array_push($hours,$row[4]);
$d1 = explode("-",$row[5]);
$d2 = explode("-",$row[6]);
$dstr = $d1[1]."/".$d1[2]."/".$d1[0];
$dstr .= " - ";
$dstr .= $d2[1]."/".$d2[2]."/".$d2[0];
array_push($labels,$dstr);
}
?>
<html>
<head>
<title>Weekly Hours Report</title>
</head>
<style type=text/css>
#adpID {
float: left;
width: 350px;
font-size: 120%;
font-weight: bold;
margin-bottom: 10px;
}
#name {
float: left;
font-size: 120%;
font-weight: bold;
margin-bottom: 10px;
}
#notes {
float: left;
width: 350px;
border: solid 1px #ffffff;
}
#history {
float: left;
}
#dept {
float: left;
width: 350px;
font-size: 110%;
margin-top: 10px;
}
#avg {
float: left;
margin-top: 10px;
font-size: 110%;
}
.one {
background: #ffffcc;
}
.two {
background: #ffffff;
}
.hourslabel {
padding: 3px;
padding-right: 30px;
padding-left: 5px;
}
.hoursdata {
padding-right: 5px;
}
a {
color: blue;
}
</style>
<body>
<form method=post action=empWeekly.php>
<?php
echo "<input type=hidden name=empID value=$empID />";
echo "<div id=adpID>$adpID</div>";
echo "<div id=name>$name</div>";
echo "<div style=\"clear:left;\"></div>";
echo "<div id=notes>
<b>Notes</b><p />
<textarea rows=15 cols=30 name=notes>$notes</textarea>
<p />
<input type=submit value=\"Save Notes\" />
</div>";
echo "<div id=history>";
echo "Starting from: <select name=start
onchange=\"top.location='empWeekly.php?empID=$empID&end=$limit2&start='+this.value;\"
>";
foreach($weekHeaders as $w){
$temp = explode("-",$w);
$dstr = $temp[1]."/".$temp[2]."/".substr($temp[0],2);
if ($w == $limitDay)
echo "<option selected value=$w>$dstr</option>";
else
echo "<option value=$w>$dstr</option>";
}
echo "</select><p />";
echo "Ending on: <select name=end
onchange=\"top.location='empWeekly.php?empID=$empID&start=$limitDay&end='+this.value;\"
>";
foreach($weekHeaders as $w){
$temp = explode("-",$w);
$dstr = $temp[1]."/".$temp[2]."/".substr($temp[0],2);
if ($w == $limit2)
echo "<option selected value=$w>$dstr</option>";
else
echo "<option value=$w>$dstr</option>";
}
echo "</select><p />";
for($i = 0; $i < count($hours); $i++){
echo "<div class=\"".(($i%2==0)?"one":"two")."\">";
echo "<span class=hourslabel>".$labels[$i]."</span>";
printf("<span class=hoursdata>%.2f</span>",$hours[$i]);
echo "</div>";
}
echo "</div>";
echo "<div style=\"clear:left;\"></div>";
echo "<div id=dept>Primary Department: $dept</div>";
printf("<div id=avg>Average hours: %.2f</div>",array_sum($hours)/count($hours));
echo "<div style=\"clear:left;\"></div>";
echo "<a href=weeklyReport.php>Back to Full Listing</a>";
?>
</form>
</body>
</html>
<?php
*/