One Hat Cyber Team

Edit File: navBar.php

<?php
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
date_default_timezone_set('Asia/Manila');
$st = $pdo->prepare("select * from tblrequests where requestedBy = ? AND status = 'Incomplete'");
$st->bindParam(1, $_SESSION['user']);
$st->execute();
$pending = $st->rowCount();
$st = $pdo->prepare("select * from tblrequests where status = 'Incomplete' AND v1Date IS NULL AND receiveDate IS NOT NULL order by tblrequests.request_id ASC;");
$st->execute();
$v1Pending = $st->rowCount();
$st = $pdo->prepare("select * from tblrequests where status = 'Incomplete' AND v2Date IS NULL AND receiveDate IS NOT NULL order by tblrequests.request_id ASC;");
$st->execute();
$v2Pending = $st->rowCount();
$st = $pdo->prepare("select * from tblrequests where status = 'Incomplete' AND v3Date IS NULL AND receiveDate IS NOT NULL order by tblrequests.request_id ASC;");
$st->execute();
$v3Pending = $st->rowCount();
$st = $pdo->prepare("select * from tblrequests where status = 'Incomplete' AND investigationType != 'None' and v4Date IS NULL AND receiveDate IS NOT NULL or v4Result = 'For Schedule' order by tblrequests.request_id ASC");
$st->execute();
$v4Pending = $st->rowCount();
$st = $pdo->prepare("select * from tblrequests where receiveDate IS NULL order by tblrequests.request_id ASC");
$st->execute();
$receivePending = $st->rowCount();
$consolidated = 0;
if($_SESSION['v1'] == "1"){
$consolidated = $consolidated + $v1Pending;
}
if($_SESSION['v2'] == "1"){
$consolidated = $consolidated + $v2Pending;
}
if($_SESSION['v3'] == "1"){
$consolidated = $consolidated + $v3Pending;
}
if($_SESSION['v4'] == "1"){
$consolidated = $consolidated + $v4Pending;
}
/*$st = $pdo->prepare("select * from tbltextpool where status = 'Pending'");
$st->execute();
$pendingTexts = $st->rowCount();
$st = $pdo->prepare("select * from tblrequests where status = 'For Encode'");
$st->execute();
$forEncode = $st->rowCount();
$st = $pdo->prepare("select * from tblrequests where status = 'For Transfer'");
$st->execute();
$forTransfer = $st->rowCount();
$consolidated = $forEncode + $forTransfer;*/
?>
<nav class="navbar sticky-top navbar-expand-lg navbar-dark bg-dark">
  <div class="container-fluid">
    <b><a class="navbar-brand mb-1" href="#" style="color: #FFD552;">VERIFICATION+</a></b>
    <button class="navbar-toggler mb-2" type="button" data-bs-toggle="collapse" data-bs-target="#navbarToggler" aria-controls="navbarTogglerDemo03" aria-expanded="false" aria-label="Toggle navigation">
      <span class="navbar-toggler-icon"></span>
    </button>
    <div class="collapse navbar-collapse" id="navbarToggler">
      <ul class="navbar-nav me-auto mb-2 mb-lg-0">
        <li class="nav-item">
          <a class="nav-link text-white" href="#">Home</a>
        </li>
        <?php
        if($_SESSION['position'] == "4"){
        ?>
        <li class="nav-item dropdown">
          <a class="nav-link dropdown-toggle text-white" href="#" id="navbarDropdown" role="button" data-bs-toggle="dropdown" aria-expanded="false">
            Monitoring 
            <?php
            if($pending>0){
              echo '<span class="badge rounded-pill badge-notification bg-danger">' . $pending . '</span>';
            }
            ?>
          </a>
          <ul class="dropdown-menu" aria-labelledby="navbarDropdown">
            <li><h6 class="dropdown-header">Requests</h6></li>
            <li><a class="dropdown-item" href="myRequests.php">My Requests 
            <?php
            if($pending >0){
              echo '<span class="badge rounded-pill badge-notification bg-danger">' . $pending . '</span>';
            }
            ?></a></li>
            <li><a class="dropdown-item" href="salesOfficeMonitoring.php">Sales Office Monitoring</a></li> 
          </ul>
        </li>
        <?php
        }
        if($_SESSION['position'] == "2" || $_SESSION['position'] == "3"){
        ?>
        <li class="nav-item dropdown">
          <a class="nav-link dropdown-toggle text-white" href="#" id="navbarDropdown" role="button" data-bs-toggle="dropdown" aria-expanded="false">
            HQ Operations
            <?php
            if($consolidated>0){
              echo '<span class="badge rounded-pill badge-notification bg-danger">' . $consolidated . '</span>';
            }
            ?>
          </a>
          <ul class="dropdown-menu" aria-labelledby="navbarDropdown">
            <?php if($_SESSION['position'] == "2"){?>
            <li><a class="dropdown-item" href="verificationPool.php">Verification Pool
            <?php  
            if($receivePending>0){
              echo '<span class="badge rounded-pill badge-notification bg-danger">' . $receivePending . '</span>';
            }
            ?>
            </a></li>
            <li><hr class="dropdown-divider"></li>
          <?php } ?>
            <li><h6 class="dropdown-header">Pending Verification</h6></li>
            <?php
            if($_SESSION['v1'] == "1"){
            ?>
            <li><a class="dropdown-item" href="v1Pending.php">Matrix Verification - V1
            <?php  
            if($v1Pending>0){
              echo '<span class="badge rounded-pill badge-notification bg-danger">' . $v1Pending . '</span>';
            }
            ?>
            </a></li>
            <?php
            }
            ?>
            <?php
            if($_SESSION['v2'] == "1"){
            ?>
            <li><a class="dropdown-item" href="v2Pending.php">SSS Verification - V2
            <?php  
            if($v2Pending>0){
              echo '<span class="badge rounded-pill badge-notification bg-danger">' . $v2Pending . '</span>';
            }
            ?>
            </a></li>
            <?php
            }
            ?>
            <?php
            if($_SESSION['v3'] == "1"){
            ?>
            <li><a class="dropdown-item" href="v3Pending.php">Other Lending Verification - V3
            <?php  
            if($v3Pending>0){
              echo '<span class="badge rounded-pill badge-notification bg-danger">' . $v3Pending . '</span>';
            }
            ?>
            </a></li>
            <?php
            }
            ?>
            <?php
            if($_SESSION['v4'] == "1"){
            ?>
            <li><a class="dropdown-item" href="v4Pending.php">Batman Verification - V4
            <?php  
            if($v4Pending>0){
              echo '<span class="badge rounded-pill badge-notification bg-danger">' . $v4Pending . '</span>';
            }
            ?>
            </a></li>
            <?php
            }
            ?>
            <li><hr class="dropdown-divider"></li>
            <li><a class="dropdown-item" href="myVerifications.php">My Encoded Verifications</a></li>
            <?php
            if($_SESSION['position'] == "2"){
            ?>
            <li><hr class="dropdown-divider"></li>
            <li><h6 class="dropdown-header">Reports</h6></li>
            <li><a class="dropdown-item" href="verificationMonitoring.php">Verification Monitoring</a></li>
            <?php
            }
            ?>
          </ul>
        </li>
        <?php
        }
        ?>
      </ul>
     
      <ul class="navbar-nav ms-auto">
        <?php
          if($_SESSION['position'] == "2" || $_SESSION['position'] == "3" || $_SESSION['position'] == "4"){
        ?>
        <form class="row" method="POST" action="overview.php">
          <div class="col-sm-12 col-md-8 col-lg-8 mb-1">
            <input type="text" class="form-control w-100" placeholder="Pensioner Name" name="txtSearch">
          </div>
          <div class="col-sm-12 col-md-4 col-lg-4 mb-1">
            <button type="submit" class="btn btn-outline-warning fw-bold" name="btnSearch">
              <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-search" viewBox="0 0 16 16">
                <path d="M11.742 10.344a6.5 6.5 0 1 0-1.397 1.398h-.001c.03.04.062.078.098.115l3.85 3.85a1 1 0 0 0 1.415-1.414l-3.85-3.85a1.007 1.007 0 0 0-.115-.1zM12 6.5a5.5 5.5 0 1 1-11 0 5.5 5.5 0 0 1 11 0z"/>
              </svg>
            </button>
          </div>
        </form>
        <?php
          }
        ?>
        <li class="nav-item">
          <br/>
        </li>
        <li class="nav-item dropdown">
          <a class="nav-link dropdown-toggle text-white" href="#" id="navbarDropdown2" role="button" data-bs-toggle="dropdown" aria-expanded="false">
            <svg xmlns="http://www.w3.org/2000/svg" width="27" height="27" fill="currentColor" class="bi bi-person-circle" viewBox="0 0 16 16">
              <path d="M11 6a3 3 0 1 1-6 0 3 3 0 0 1 6 0z"/>
              <path fill-rule="evenodd" d="M0 8a8 8 0 1 1 16 0A8 8 0 0 1 0 8zm8-7a7 7 0 0 0-5.468 11.37C3.242 11.226 4.805 10 8 10s4.757 1.225 5.468 2.37A7 7 0 0 0 8 1z"/>
            </svg>
          </a>
          <ul class="dropdown-menu dropdown-menu-end" aria-labelledby="navbarDropdown2">
            <li>
              
                <?php echo $_SESSION['user'];?>
              
            </li>
            <a class="nav-link text-danger" href="logout.php">
            <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-arrow-right-square" viewBox="0 0 16 16">
              <path fill-rule="evenodd" d="M15 2a1 1 0 0 0-1-1H2a1 1 0 0 0-1 1v12a1 1 0 0 0 1 1h12a1 1 0 0 0 1-1V2zM0 2a2 2 0 0 1 2-2h12a2 2 0 0 1 2 2v12a2 2 0 0 1-2 2H2a2 2 0 0 1-2-2V2zm4.5 5.5a.5.5 0 0 0 0 1h5.793l-2.147 2.146a.5.5 0 0 0 .708.708l3-3a.5.5 0 0 0 0-.708l-3-3a.5.5 0 1 0-.708.708L10.293 7.5H4.5z"/>
            </svg>
            Logout
          </a>
          </ul>
        </li>
      </ul>
    </div>
  </div>
</nav>

  <div class="modal fade requestModal" id="changePassword" role="dialog">
    <div class="modal-dialog modal-centered modal-xs" >
      <div class="modal-content text-black">
        <div class="modal-header">
          <h5 class="modal-title" id="exampleModalLabel">Change Password</h5>
          <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
        </div>
        <form method="POST" action="changePassword.php">
          <div class="modal-body">
            <div class="row">
              <div class="col-lg-12 mb-2">
                <div class="form-floating">
                  <input type="password" class="form-control" name="modalChangePassword" placeholder="" required> 
                  <label for="modalClientNumber">New Password</label>
                </div>
              </div>
            </div>
            <div class="row">
              <div class="col-lg-12">
                <button type="submit" class="btn btn-success" name="btnChangePassword" style="width: 100%;">Change Password</button>
              </div>
            </div>
          </div>
        </form>
      </div>
    </div>
  </div>