public function showTimeRequestsByDate($hiddenInputs, $showCustomDates = true, $showPayPeriods = true, $showDivisions = true)
{
echo "<form name='timeRequests' method='post'>";
echo '<h2>Submitted Requests By Division and By Date</h2>';
$requests = new request_class();
if ($showCustomDates) {
$this->showCustomDateRange();
}
if ($showPayPeriods) {
$this->getCurrentPayPeriods();
}
if ($showDivisions) {
$this->showDivisionDropDown();
}
$this->filters .= getTimeRequestFiltersBetweenDates($this->config, $this->startDate, $this->endDate);
//$filters .= " AND (STATUS='APPROVED' OR STATUS='DENIED')";
$hiddenInputs .= $this->setHiddenPostInputs();
$requests->debug = false;
$requests->showTimeRequestTable($this->config, $this->filters, $orderBy = "ORDER BY REFER DESC", $hiddenInputs);
}
function hrPayrolReportByEmployee($config)
{
// Get Post Vars
$viewBtn = false;
$showAllStatus = isset($_POST['showAllStatus']) ? true : false;
$hrReportTotalRows = isset($_POST['hrReportTotalRows']) ? $_POST['hrReportTotalRows'] : 0;
if ($hrReportTotalRows > 0) {
for ($i = 0; $i <= $hrReportTotalRows; $i++) {
if (isset($_POST['viewDetailsBtn' . $i])) {
$empID = $_POST['empID' . $i];
$viewBtn = true;
break;
}
}
}
if (isset($_POST['backBtn'])) {
$viewBtn = false;
}
$requests = new request_class();
$timeReport = new request_reports($config);
$timeReport->showTimeRequestFilterOptions($showCustomDates = true, $showPayPeriods = true, $showDivisions = true);
if ($viewBtn) {
$hiddenInputs = '<input type="hidden" name="hrReportTotalRows" value="1" />
<input type="hidden" name="viewDetailsBtn0" value="true" />
<input type="hidden" name="empID0" value="' . $empID . '" />';
echo $hiddenInputs;
echo '<div align="center">';
if ($showAllStatus) {
echo '<input type="submit" name="showNormalStatus" value="Remove Pending Status" />';
} else {
$timeReport->filters .= " AND (STATUS = 'APPROVED' OR STATUS = 'DENIED')";
echo '<input type="submit" name="showAllStatus" value="Include Pending Status" />';
}
//echo '<div align="center"><a href="'.$_SERVER['REQUEST_URI'].'">Back</a></div>';
// echo '<form method="POST">';
echo ' <input type="submit" name="backBtn" value="Back To Employee Counts" /></div><Br/>';
$hiddenInputs .= '<input type="hidden" name="viewDetailsBtn" value="true" />';
$timeReport->filters .= $timeReport->db->getTimeRequestFiltersByEmpID($empID);
$requests->showTimeRequestTable($config, $timeReport->filters, $orderBy = "ORDER BY REFER DESC", $hiddenInputs);
//empTimeReportByPay($config, $startDate, $endDate, $empID);
} else {
$timeReport->filters .= " AND (STATUS = 'APPROVED' OR STATUS = 'DENIED')";
$filters = $timeReport->filters;
$filters .= $timeReport->db->getFilterHRStatus('0');
$timeReport->db->filters = $filters;
$result = $timeReport->db->getHRTimeRequestCountsByEmp();
$theTable = array(array());
$x = 0;
$theTable[$x][0] = "View";
$theTable[$x][1] = "Munis #";
$theTable[$x][2] = "Employee";
$theTable[$x][3] = "Number of Requests";
$lastUser = '';
$lastUserRow = 0;
$rowCount = 0;
while ($row = $result->fetch_assoc()) {
$x++;
$recordCounter = 1;
$lastUser = $row['Name'];
$theTable[$x][0] = '<input type="submit" name="viewDetailsBtn' . $rowCount . '" value="View" />
<input type="hidden" name="empID' . $rowCount . '" value="' . $row['EMP_ID'] . '" />
';
$theTable[$x][1] = $row['Munis'];
$theTable[$x][2] = $lastUser;
$theTable[$x][3] = $row['ReqNumbers'];
$rowCount++;
}
//end While loop
echo '<h3>Pending HR Approval</h3>';
showSortableTable($theTable, 2, "hrPending");
$filters = $timeReport->filters;
$filters .= $timeReport->db->getFilterHRStatus('1');
$timeReport->db->filters = $filters;
$result = $timeReport->db->getHRTimeRequestCountsByEmp();
$theTable = array(array());
$x = 0;
$theTable[$x][0] = "View";
$theTable[$x][1] = "Munis #";
$theTable[$x][2] = "Employee";
$theTable[$x][3] = "Number of Requests";
$lastUser = '';
$lastUserRow = 0;
$recordCounter = 0;
while ($row = $result->fetch_assoc()) {
$x++;
$recordCounter = 1;
$lastUser = $row['Name'];
$theTable[$x][0] = '<input type="submit" name="viewDetailsBtn' . $rowCount . '" value="View" />
<input type="hidden" name="empID' . $rowCount . '" value="' . $row['EMP_ID'] . '" />
';
$theTable[$x][1] = $row['Munis'];
$theTable[$x][2] = $lastUser;
$theTable[$x][3] = $row['ReqNumbers'];
$rowCount++;
}
//end While loop
//echo 'number of rows: '.$x;
echo '<h3>HR Approvals</h3>';
showSortableTable($theTable, 2, "hrApprove");
echo '<input type="hidden" name="hrReportTotalRows" value="' . $rowCount . '" />';
}
//show a print button. printed look defined by print.css
// echo '<a href="javascript:window.print()">Print</a>';
}
function searchPOSTActions($config, $searchInput)
{
$useAction = false;
if ($config->adminLvl >= 25) {
if (!isset($_POST['BackBtn'])) {
if (isset($_POST['searchRows'])) {
$totalRows = $_POST['searchRows'];
for ($i = 0; $i <= $totalRows; $i++) {
if (isset($_POST['viewRequestBtn' . $i])) {
echo '<h3>Showing Requests for ' . $_POST['foundUserLNAME' . $i] . ', ' . $_POST['foundUserFNAME' . $i] . ' </h3>';
echo ' <div align="center"><input type="submit" name="BackBtn" value="Back to Search" /></div>';
$hiddenInputs = '<input type="hidden" name="searchInput" value="' . $searchInput . '" />
<input type="hidden" name="foundUserLNAME' . $i . '" value="' . $_POST['foundUserLNAME' . $i] . '" />
<input type="hidden" name="foundUserFNAME' . $i . '" value="' . $_POST['foundUserFNAME' . $i] . '" />';
$filters = "";
$filters .= getTimeRequestFiltersByEmpID($config, $_POST['foundUserID' . $i]);
$hiddenInputs .= '<input type="hidden" name="searchRows" value="2" />';
$hiddenInputs .= '<input type="hidden" name="viewRequestBtn1" value="true" />';
$hiddenInputs .= '<input type="hidden" name="foundUserID1" value="' . $config->mysqli->real_escape_string($_POST['foundUserID' . $i]) . '" />';
echo $hiddenInputs;
$requests = new request_class();
$requests->showTimeRequestTable($config, $filters, $orderBy = "ORDER BY REFER DESC", $hiddenInputs);
$useAction = true;
break;
}
}
}
} else {
//Back Button Pressed
//clearGoToAnchor();
}
}
return $useAction;
}
function displayContent($wts_content, $config)
{
if ($wts_content->isHome) {
?>
<div class="post"><?php
displayWelcome($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
displayAnnounce($config);
}
if ($wts_content->isWelcome()) {
?>
<div class="post"><?php
displayWelcome($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isAbout) {
?>
<div class="post"><?php
displayAbout($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if (isValidUser($config)) {
if ($wts_content->isAnounceAdmin) {
?>
<div class="post"><?php
displayAdminAnnounce($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isLeaveForm) {
?>
<div class="post"><?php
displayLeaveForm($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isTimeRequestForm) {
?>
<div class="post"><?php
displayNewTimeRequestForm($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isSubmittedRequests) {
?>
<div class="post"><?php
displaySubmittedRequests($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isSubmittedRequestsNEW) {
?>
<div class="post"><?php
displaySubmittedRequestsNEW($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isLeaveApproval) {
?>
<div class="post"><?php
displayLeaveApprovalNEW($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isUserMenu) {
?>
<div class="post"><?php
displayUserMenu($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isLogout()) {
logoutUser($config, "You have logged out");
}
if ($wts_content->isSearching) {
?>
<div class="post"><?php
searchPage($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isUpdateProfile) {
?>
<div class="post"><?php
displayUpdateProfile($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isLookup) {
?>
<div class="post"><?php
displayRequestLookup($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isUseReport) {
?>
<div class="post"><?php
displayTimeUseReport($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isPhpMyEdit) {
?>
<div class="post"><?php
displayPhpMyEditMenu();
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isMUNIS) {
?>
<div class="post"><?php
MUNISreport($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isSecLog) {
?>
<div class="post"><?php
displaySecondaryLog($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isUserLookup) {
?>
<div class="post"><?php
displayUserLookup($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isSecApprove) {
?>
<div class="post"><?php
displaySecondaryLog($config, $approve = true);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isResManage) {
?>
<div class="post"><?php
displayReserves($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isUserVerify) {
?>
<div class="post"><?php
displayUserVerify($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isMySubmitReq) {
?>
<div class="post"><?php
displayMySubmittedRequestsNEW($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isReports) {
?>
<div class="post"><?php
displayReportMenu($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isApprovedUseReport) {
?>
<div class="post"><?php
approvedTimeUseReport($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->subReqCal) {
?>
<div class="post"><?php
reportsCal($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->hrEmpRep) {
?>
<div class="post"><?php
hrPayrolReportByEmployee($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isSickRep) {
?>
<div class="post"><?php
sickReport($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isEventLogs) {
?>
<div class="post"><?php
displayLogs($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isOTRep) {
?>
<div class="post"><?php
overtimeReport($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isRadioLog) {
?>
<div class="post"><?php
displayRadioLog($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isMyInv) {
?>
<div class="post"><?php
showMyInventory($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isSecLogRep) {
?>
<div class="post"><?php
displaySecLogReport($config);
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
if ($wts_content->isPrintRequestNo) {
?>
<div class="post"><?php
$requests = new request_class();
$requests->config = $config;
$requests->showPrintFriendlyRequest();
?>
<div class="clear"></div></div><div class="divider"></div>
<?php
}
$reqURI = dirname($_SERVER['REQUEST_URI']);
if ($reqURI != "/") {
$reqURI = $reqURI . "/";
}
//popupmessage(str_replace($reqURI, "", $_SERVER['PHP_SELF']).' URI '.$reqURI.' self '.$_SERVER['PHP_SELF'].' showPrintFriendly:'.$config->showPrinterFriendly);
if (str_replace($reqURI, "", $_SERVER['PHP_SELF']) != "printFriendly.php" && $config->showPrinterFriendly) {
echo '<a target="_blank" href="printFriendly.php?' . str_replace($_SERVER['PHP_SELF'] . "?", "", $_SERVER['REQUEST_URI']) . '"> Print Tables</a>';
}
myAlerts($config, $wts_content);
} else {
if ($wts_content->isSearching) {
?>
<div class="post"><h3>Search Results</h3>Must Login First<div class="clear"></div></div><div class="divider"></div>
<?php
}
}
}
