</ul> </div> <?php $db = connectDb(); $sql2 = "select * from document_actions"; $rs2 = $db->query($sql2); $nm2 = $rs2->num_rows; for ($k = 0; $k < $nm2; $k++) { $row2 = $rs2->fetch_assoc(); $action[$k]["id"] = $row2['action_code']; $action[$k]["name"] = $row2['action_description']; } $db = connectDb(); if (isset($_POST['active_documents'])) { $department = getDepartment($db, $_POST['active_documents']); $rs = topActiveDocumentsDivision($db, $_POST['active_documents']); } else { $rs = topActiveDocuments($db); } $nm = $rs->num_rows; ?> <div class="wrapper"> <div class="row"> <div class="col-sm-12"> <section class="panel"> <header class="panel-heading"> Most Active Documents <?php if (isset($_POST['active_documents'])) { echo "for " . $department; }
for ($i = 0; $i < $nm; $i++) { $row = $rs->fetch_assoc(); echo "<option value='" . $row['department_code'] . "'>" . $row['department_name'] . "</option>"; } echo "</select>"; echo "</td>"; echo "<td><input class='btn btn-success' type=submit value='Get Most Active' /></td>"; echo "</tr>"; echo "</table>"; ?> </form> <?php if (isset($_POST['divisionActive'])) { $department = getDepartment($db, $_POST['divisionActive']); $db = retrieveRecordsDb(); $rs = topActiveDocumentsDivision($db, $_POST['divisionActive']); $nm = $rs->num_rows; if ($nm > 0) { ?> <table style='font-size:13px;' class='table table-striped table-bordered' width=100%> <thead> <tr> <th colspan=8><h3>Active Documents for <?php echo $department; ?> </h3></th> </tr> <tr> <th>Office Code</th> <th>Document Date</th>