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>'; }