} else { echo "<li class='disabled'><a href='#'>«</a></li>"; } // pages link for ($i = 1; $i <= $pagination->total_pages(); $i++) { if ($i == $pagination->current_page) { echo '<li class="active"><a href="#">' . $i . '</a></li>'; } else { $arr = array("currentPage" => $i); echo '<li><a href="' . appendToCurrentUri($arr) . '">' . $i . '</a></li>'; } } //next link if ($pagination->has_next_page()) { $arr = array("currentPage" => $pagination->next_page()); echo '<li><a href="' . appendToCurrentUri($arr) . '">»</a></li>'; } else { echo "<li class='disabled'><a href='#'>»</a></li>"; } ?> </ul> </div> <?php // results per page selector echo "<div class='col-sm-3 pagination-info'>"; echo "<form id='paginationForm' method='post'><p><label for='res_per_page'>Max. Results per Page: <input id='res_per_page' name='res_per_page' value='" . $pagination->per_page . "'></label></p></form>"; echo "</div>"; // show feedback about how many results are there and ..... $resultStart = $pagination->offset() + 1; $resultEnd = $pagination->offset() + $pagination->per_page; if ($resultEnd > $pagination->total_count) {
public function getHtmlTable($sql, $config = array()) { // find the mySQL data $resource = $this->query($sql); // number of columns $output['numFields'] = $numfields = mysqli_num_fields($resource); // table start $output['markup'] = "<table class='table table-primary table-striped table-hover'><thead><tr>"; // headings in header row for ($i = 0; $i < $numfields; $i += 1) { $output['fields'][] = $field = mysqli_fetch_field_direct($resource, $i); $output['markup'] .= "<th>" . uc_words($field->name) . "</th>"; } // empty header cell for edit & delete button if (isset($config['page_id'])) { $output['markup'] .= "<th></th>"; } // end of thead $output['markup'] .= "</tr></thead><tbody>"; // flag to indicate if data was found $dataFound = false; // start of tbody, table rows while ($row = mysqli_fetch_assoc($resource)) { $dataFound = true; $output['markup'] .= "<tr>"; for ($i = 0; $i < $numfields; $i += 1) { $field = mysqli_fetch_field_direct($resource, $i); $output['markup'] .= "<td><span " . $this->getHtmlAttributes($field, $row) . ">" . $row[$field->name] . "</span></td>"; } if (isset($config['page_id'])) { // delete button $href = appendToCurrentUri(array('record_id' => $row['id'], 'delete' => 'true')); $delete_link = "<a href='" . $href . "' class='danger_link' data-recId='" . encrypt($field->table . "-" . $row['id']) . "'>" . icon("remove") . "</a>"; // open link $href = "recordDetail.php?classname=" . tbl2cls($field->table) . "&recordId=" . $row['id']; $openLink = "<a href='" . $href . "' target='blank'>" . icon("folder-open") . "</a>"; $output['markup'] .= "<td>{$openLink} {$delete_link}</td>"; } $output['markup'] .= "</tr>"; } // Show error if no data was found if (!$dataFound) { $colspan = isset($config['page_id']) ? $numfields + 1 : $numfields; $output['markup'] .= "<tr><td class='warning' colspan='" . $colspan . "'>No Data Found.</td></td></tr>"; } // end of table $output['markup'] .= "</tbody></table>"; return $output; }
} echo "<td class='hidden-print'>{$openLink} {$delete_link}{$addNewLink}</td>"; echo "</tr>"; $count++; // special treatment for Fee Vouchers if ($record instanceof Fee_voucher) { $details = $record->details(); if ($details) { echo "<tr><td colspan='16'>"; echo "<table width='70%' class='child-table'>"; echo "<thead>"; echo "<tr><th>Fee Category</th><th>Amount</th><th>Comments</th><th></th></tr>"; echo "</thead>"; foreach ($details as $key => $feeDetail) { // delete link $href = appendToCurrentUri(array('delete' => 'true', 'record_to_del' => $feeDetail->id->val, 'del_class' => 'Fee_voucher_datail')); $delete_link = "<a href='" . $href . "' class='danger_link' data-recId='" . encrypt($feeDetail->id->table . "-" . $feeDetail->id->val) . "'>" . icon("remove") . "</a>"; echo "\n <tr>\n <td>{$feeDetail->fee_category_id->getEditableValue()}</td>\n <td>{$feeDetail->amount->getEditableValue()}</td>\n <td>{$feeDetail->comments->getEditableValue()}</td>\n <td class='hidden-print'>{$delete_link}</td>\n </tr>"; } echo "</table>"; echo "</td></tr>"; } } // special treatment for Fee Vouchers end if ($classname == "Fee_voucher") { echo $tableEnd; } // we have a different display for vouchers } } if ($classname != "Fee_voucher") {