function displayRadioLog($config, $isApprovePage = false)
{
if ($config->adminLvl >= 0) {
$mysqli = $config->mysqli;
if ($isApprovePage) {
echo '<h2>Daily Inventory Checkout Log Approval</h2>';
} else {
echo '<h2>Daily Inventory Checkout Log</h2>
';
}
echo '<form name="radioLog" method="POST">
<input type="hidden" name="formName" value="radioLog" />';
//Get variables
$dateSelect = isset($_POST['dateSelect']) ? $_POST['dateSelect'] : false;
$changeDateBtn = isset($_POST['changeDate']) ? True : false;
$editSelect = isset($_POST['editRows']) ? $_POST['editRows'] : false;
$addBtn = isset($_POST['addBtn']) ? True : false;
$checkoutKeyBtn = isset($_POST['checkoutKeyBtn']) ? True : false;
$editBtn = isset($_POST['editBtn']) ? True : false;
$radioLogID = isset($_POST['radioLogID']) ? $_POST['radioLogID'] : false;
$keyLogID = isset($_POST['keyLogID']) ? $_POST['keyLogID'] : false;
$finalRows = isset($_POST['finalRows']) ? $_POST['finalRows'] : false;
$checkInKey = isset($_POST['checkInKey']) ? true : false;
$updateRadioLog = isset($_POST['updateRadioLog']) ? true : false;
$updateKeyLog = isset($_POST['updateKeyLog']) ? true : false;
$showAll = isset($_POST['showAllPerm']) ? true : false;
$showAll = isset($_POST['showAllLoaner']) ? true : $showAll;
$showAll = isset($_POST['showAllShift']) ? true : $showAll;
$showNormal = isset($_POST['showNormal']) ? true : false;
$goBtn = isset($_POST['goBtn']) ? true : false;
$isApprovePage = isset($_GET['secApprove']) ? true : $isApprovePage;
$totalRows = isset($_POST['totalRows']) ? $_POST['totalRows'] : 0;
$radioLogID = isset($_POST['backToApprove']) ? false : $radioLogID;
$exchangeLogID = isset($_POST['exchangeLogID']) ? $_POST['exchangeLogID'] : false;
$itemLogType = '';
$filters = '';
$cancelBtn = isset($_POST['cancelBtn']) ? true : false;
$divID = isset($_POST['divisionID']) ? $_POST['divisionID'] : false;
$counter = 0;
if ($checkoutKeyBtn) {
$addBtn = false;
}
if ($checkoutKeyBtn && $goBtn) {
$checkoutKeyBtn = FALSE;
}
if ($showAll || $showNormal) {
$goBtn = true;
}
if ($changeDateBtn) {
$dateSelect = false;
$editSelect = false;
$goBtn = false;
$addBtn = false;
}
if ($cancelBtn) {
$goBtn = true;
$exchangeLogID = '';
}
$exchangeBtnINV = false;
for ($i = 1; $i <= $totalRows; $i++) {
if (isset($_POST['exchangeBtnINV' . $i])) {
$exchangeLogID = $_POST['refNum' . $i];
$finalRows = 0;
$checkoutKeyBtn = false;
$exchangeBtnINV = true;
$_POST['num_deputies'] = 0;
break;
}
if (isset($_POST['carDetails' . $i])) {
showItemDetails($config, $_POST['itemID' . $i]);
if (isset($keyLogID) && !empty($keyLogID)) {
$editBtn = true;
$radioLogID = $keyLogID;
}
break;
}
}
if (!$isApprovePage && (!isset($_POST['exchangeLogID']) || !$exchangeBtnINV)) {
if (!$changeDateBtn && !$dateSelect) {
//default to today's date
$dateSelect = date('m/d/Y');
$goBtn = true;
}
if (!$dateSelect) {
echo 'Select Date: ';
displayDateSelect("dateSelect", "dateSel", false, false, true, true);
echo '<input id="goBtn" type=submit name="goBtn" value="Go" /><br />';
} else {
echo '<h3>Date: ' . $dateSelect . '';
echo '<input type="hidden" name="dateSelect" value="' . $dateSelect . '" />
<input type="submit" name="changeDate" value="Change Date" />
<input type="submit" name="checkoutKeyBtn" value="Checkout Items" /></h3>';
if (!$checkoutKeyBtn) {
$goBtn = true;
}
}
} else {
echo '<input type="hidden" name="dateSelect" value="' . $dateSelect . '" />';
}
if (isset($_POST['exchangeLogID'])) {
$addBtn = false;
}
if ($addBtn) {
//showRadioLogDetails($config, $radioLogID);
}
if ($checkoutKeyBtn || $addBtn) {
showKeyLogDetails($config, $keyLogID, false, false, $divID);
$goBtn = false;
}
if ($exchangeLogID) {
showItemExchange($config, $exchangeLogID);
$editBtn = false;
$goBtn = false;
}
//get group update or logout
if ($finalRows > 0) {
$approveBtn = array();
$foundEditBtn = false;
for ($i = 1; $i <= $finalRows; $i++) {
if (isset($_POST['radioLogEditBtn' . $i])) {
$radioLogID = $_POST['radioLogID' . $i];
$itemLogType = $_POST['itemLogType' . $i];
$foundEditBtn = true;
$goBtn = false;
}
if (isset($_POST['logoutRadioLog' . $i]) || isset($_POST['logoutRadioLogAll']) || isset($_POST['checkInRadio' . $i])) {
$radioLogID = $_POST['radioLogID' . $i];
$hiddenInputs = '<input type="hidden" name="checkInRadio' . $i . '" value="' . $_POST['checkInRadio' . $i] . '" />
<input type="hidden" name="radioLogID' . $i . '" value="' . $_POST['radioLogID' . $i] . '" />
<input type="hidden" name="finalRows" value="' . $finalRows . '" />
<input type="hidden" name="divisionID" value="' . $_POST['divisionID'] . '" />';
checkInRadioLog($config, $radioLogID, $noLog = false, $hiddenInputs);
$filters = showSelectDivision($config, $divID);
showQuickSearch();
$counter += showRadioLog($config, $dateSelect, $counter, "LOANER", false, $filters);
$counter += showRadioLog($config, $dateSelect, $counter, "SHIFT", false, $filters);
$counter += showRadioLog($config, $dateSelect, $counter, "PERM", false, $filters);
$goBtn = false;
} else {
if (isset($_POST['updateRadioLog' . $i]) || isset($_POST['updateRadioLogAll'])) {
//get posted values
$radioLogID = $_POST['radioLogID' . $i];
$radioCallNum = isset($_POST['radioCallNum' . $i]) ? $mysqli->real_escape_string($_POST['radioCallNum' . $i]) : '';
$checkOutType = isset($_POST['checkOutType']) ? $mysqli->real_escape_string($_POST['checkOutType']) : '';
updateRadioLog($config, $radioLogID, $radioCallNum, $checkOutType);
$editBtn = true;
$goBtn = false;
} else {
if (isset($_POST['exchangeBtn' . $i])) {
//checkin equipment and start checking back out
$radioLogID = $_POST['radioLogID' . $i];
showItemExchange($config, $radioLogID);
$goBtn = false;
}
}
}
if (isset($_POST['viewDeputyInv' . $i])) {
$radioLogID = $_POST['radioLogID' . $i];
showInventoryGroups($config, $radioLogID);
$goBtn = false;
}
$approveBtn[$i] = isset($_POST['radioLogApproved' . $i]) ? true : false;
if ($approveBtn[$i]) {
$radioLogID = $_POST['radioLogID' . $i];
//get group ID from selected approval
$groupIDQ = "SELECT GPNUM FROM WTS_RADIOLOG WHERE REFNUM = " . $radioLogID;
$result = $mysqli->query($groupIDQ);
SQLerrorCatch($mysqli, $result);
$row = $result->fetch_assoc();
if ($row['GPNUM'] != "0") {
//Group Approval required
//get all group memebers references
$myq = "SELECT REFNUM \r\n FROM WTS_RADIOLOG\r\n WHERE GPNUM = " . $row['GPNUM'] . ";";
$result = $mysqli->query($myq);
SQLerrorCatch($mysqli, $result);
while ($row = $result->fetch_assoc()) {
//approve each member of group
$updateQ = "UPDATE WTS_RADIOLOG\r\n SET SUP_ID = '" . $_SESSION['userIDnum'] . "',\r\n SUP_TS = NOW(),\r\n SUP_IP = INET_ATON('" . $_SERVER['REMOTE_ADDR'] . "') \r\n WHERE WTS_RADIOLOG.REFNUM = " . $row['REFNUM'];
$resultUpdate = $mysqli->query($updateQ);
SQLerrorCatch($mysqli, $resultUpdate);
addLog($config, 'Radio Checkout Log #' . $row['REFNUM'] . ' approved');
echo 'Radio Checkout Log #' . $radioLogID . ' approved.<br />';
}
} else {
//approve non group secLog
$updateQ = "UPDATE WTS_RADIOLOG \r\n SET SUP_ID = '" . $_SESSION['userIDnum'] . "',\r\n SUP_TS = NOW(),\r\n SUP_IP = INET_ATON('" . $_SERVER['REMOTE_ADDR'] . "') \r\n WHERE WTS_RADIOLOG.REFNUM = " . $radioLogID;
$resultUpdate = $mysqli->query($updateQ);
SQLerrorCatch($mysqli, $resultUpdate);
addLog($config, 'Radio Checkout Log #' . $radioLogID . ' approved');
echo 'Radio Checkout Log #' . $radioLogID . ' approved.<br />';
}
$filters = showSelectDivision($config, $divID);
showQuickSearch();
$counter += showRadioLog($config, $dateSelect, $counter, "LOANER", false, $filters, $isApprovePage = true);
$counter += showRadioLog($config, $dateSelect, $counter, "SHIFT", false, $filters);
$counter += showRadioLog($config, $dateSelect, $counter, "PERM", false, $filters);
$goBtn = false;
}
}
if ($foundEditBtn) {
// if($itemLogType == "RADIO")
// showRadioLogDetails($config, $radioLogID, true, $isApprovePage);
// if($itemLogType == "KEY")
showKeyLogDetails($config, $radioLogID, true, $isApprovePage, $divID);
$goBtn = false;
} else {
if (!$addBtn && !$showAll && !$showNormal && !$changeDateBtn && !$isApprovePage && $totalRows < 0) {
echo 'Error getting Reference Number!<br />';
echo '<input type="submit" name="goBtn" value="Back To Logs" />';
$goBtn = false;
}
}
}
if ($isApprovePage && empty($radioLogID)) {
showQuickSearch();
$counter += showRadioLog($config, $dateSelect, $counter, "LOANER", false, $filters, $isApprovePage);
$counter += showRadioLog($config, $dateSelect, $counter, "SHIFT", false, $filters);
$counter += showRadioLog($config, $dateSelect, $counter, "PERM", false, $filters);
}
if ($editBtn || $updateRadioLog || $checkInKey || $updateKeyLog) {
if ($config->adminLvl <= 25) {
//Non supervisor Log details
//$filters = showSelectDivision($config, $divID);
showKeyLogDetails($config, $radioLogID, true, $isApprovePage, $divID);
$goBtn = false;
} else {
//Supervisor Log Details
//$filters = showSelectDivision($config, $divID);
showKeyLogDetails($config, $radioLogID, true, false, $divID);
$goBtn = false;
}
}
if ($goBtn) {
$filters = showSelectDivision($config, $divID);
showQuickSearch();
if ($config->adminLvl < 25) {
//non supervisor logs
$counter += showRadioLog($config, $dateSelect, $counter, "LOANER", false, $filters);
} else {
//supervisor logs
$counter += showRadioLog($config, $dateSelect, $counter, "LOANER", true, $filters);
}
$counter += showRadioLog($config, $dateSelect, $counter, "SHIFT", false, $filters);
$counter += showRadioLog($config, $dateSelect, $counter, "PERM", false, $filters);
}
echo '<input type="hidden" name="finalRows" value="' . $counter . '" />';
echo '
<br />
<br />';
} else {
echo '<h2>Daily Radio Checkout Log</h2>Access Denied';
}
}
function showMyInventory($config)
{
$totalRows = isset($_POST['totalRows']) ? $_POST['totalRows'] : 0;
for ($i = 1; $i <= $totalRows; $i++) {
if (isset($_POST['carDetails' . $i])) {
showItemDetails($config, $_POST['itemID' . $i]);
break;
}
}
$mysqli = $config->mysqli;
$myq = "SELECT R.REFNUM, R.GPNUM 'gpID', CONCAT_WS(', ', LNAME, FNAME) 'DEPUTYNAME', R.RADIO_CALLNUM, \r\n R.RADIOID, R.TYPE, DATE_FORMAT (AUDIT_IN_TS, '%m/%d/%y %H%i') 'inTime'\r\n FROM WTS_RADIOLOG R\r\n JOIN EMPLOYEE AS SEC ON SEC.IDNUM=R.DEPUTYID\r\n WHERE R.DEPUTYID = '" . $_SESSION['userIDnum'] . "'\r\n AND CHECKEDOUT=1 \r\n AND IS_RESERVE=0\r\n UNION\r\n SELECT R.REFNUM, R.GPNUM 'gpID', CONCAT_WS(', ', LNAME, FNAME) 'DEPUTYNAME', R.RADIO_CALLNUM, \r\n R.RADIOID, R.TYPE, DATE_FORMAT (AUDIT_IN_TS, '%m/%d/%y %H%i') 'inTime'\r\n FROM WTS_RADIOLOG R\r\n JOIN RESERVE AS SEC ON SEC.IDNUM=R.DEPUTYID\r\n WHERE R.DEPUTYID = '" . $_SESSION['userIDnum'] . "'\r\n AND CHECKEDOUT=1 \r\n AND IS_RESERVE=1\r\n ";
$result = $mysqli->query($myq);
SQLerrorCatch($mysqli, $result, $myq);
//get all users
$selectedRows = array();
$sRows = 0;
echo '<form method=POST>';
while ($newRow = $result->fetch_assoc()) {
if ($sRows == 0) {
echo '<br/><br/><div align="center"><h3>Items Currently Checked Out By:</h3></div>Deputy:
' . $newRow['DEPUTYNAME'];
echo '; Radio Call#: ' . $newRow['RADIO_CALLNUM'];
echo '<br/><br/>';
}
//echo '<option value="'.$selectedValue.'" SELECTED>'.$row['SERIAL_NUM'].$itemDesc.'</option>';
$selectedRows[$sRows] = $newRow['REFNUM'];
$sRows++;
}
selectInventory($config, $selectedRows, $filters = '', true, $invView = true, $height = 400);
echo '</form>';
}
