/pager/lgu_page.php
PHP | 188 lines | 154 code | 17 blank | 17 comment | 40 complexity | a6f3ff410df206a174868c0f61b13ab6 MD5 | raw file
- <?php
- require 'setup/setting.php';
- //2008.05.12 RJC Set undefined constant to string and define undefined variables
- $max_resultsr = $thIntPageLimit;
- $page = isset($page) ? $page : 1;
- $pagemulti = $page;
- if(!isset($_GET['page'])){
- $pager = 1;
- } else {
- $pager = $_GET['page'];
- }
- // Define the number of results per page
- $fromr = abs((($pager * $max_resultsr) - $max_resultsr));
- if (!isset($is_desc) or $is_desc == "") {
- $is_desc = 'DESC';
- }
- if ($is_desc=='DESC') { // Flip direction
- $is_desc='ASC';
- } else {
- $is_desc='DESC';
- }
- $is_asc = $is_desc; // set ascending or descending sequence
- // echo "Sequence is ".$is_asc."\n";
- if ($pagemulti=='') {
- $pagemulti=1;
- }
- //echo $is_desc."VooDoo";
- if (!isset($orderkey) or $orderkey=="") {
- $orderkey = "city_municipality_code";
- }
- $nresult = new EBPLSLGU($dbLink,'false');
- $nresult->pagesearch($fromr, $max_resultsr, $orderkey, $is_desc);
- $fetarray = $nresult->rcount;
- $total_sr = @mysql_fetch_row($fetarray);
- $total_resultsr = $total_sr[0];
- $fetchrecord = $nresult->out;
- // Figure out the total number of pages. Always round up using ceil()
- $total_pagesr = ceil($total_resultsr / $max_resultsr);
- //echo $total_resultsr."VooDoo";
- echo "<table border=0 width=100%><tr><td align=left>";
- if($pager > 1){
- $prevr = ($pager - 1);
- echo "<a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&page=1&orderkey=$orderkey&is_asc=$is_asc'><< ";
- echo "<a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&page=$prevr&orderkey=$orderkey&is_asc=$is_asc'>Prev ";
- }
- if ($pager >=7) {
- for($i = $pager-5; $i < $pager; $i++){
- echo "<a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&page=$i&orderkey=$orderkey&is_asc=$is_asc'>$i</a> ";
- }
- echo "$pager ";
- if ($total_pagesr > ($pager + 5)) {
- $tot_page = $pager + 5;
- } else {
- $tot_page = $total_pagesr;
- }
- for($i = $pager+1; $i <= $tot_page; $i++){
- echo "<a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&page=$i&orderkey=$orderkey&is_asc=$is_asc'>$i</a> ";
- }
- } else {
- if ($total_pagesr > 11) {
- $tot_page = 11;
- } else {
- $tot_page = $total_pagesr;
- }
- for($i = 1; $i <= $tot_page; $i++){
- if ($tot_page != '1') {
- if(($pager) == $i){
- echo "$i ";
- } else {
- echo "<a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&page=$i&orderkey=$orderkey&is_asc=$is_asc'>$i</a> ";
- }
- }
- }
- }
-
-
- // Build Next Link
-
- if($pager < $total_pagesr){
- $nextr = ($pager + 1);
- echo "<a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&page=$nextr&orderkey=$orderkey&is_asc=$is_asc'>Next </a>";
- echo "<a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&page=$total_pagesr&orderkey=$orderkey&is_asc=$is_asc'>>></a>";
- }
-
-
- echo "</td></tr></table>";
- ?>
- <table align=center border=0 cellspacing=0 cellpadding=0 width=100%>
- <tr>
- <td class='hdr' width="5%"> No.</td>
- <td align=center class='hdr' width="10%">
- <a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&is_desc=<?php echo $is_desc;?>&orderkey=city_municipality_code'> LGU Code</a>
- </td>
- <td align=center class='hdr' width="35%">
- <a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&is_desc=<?php echo $is_desc;?>&orderkey=city_municipality_desc'> Name of LGU</a>
- </td>
- <td align=center class='hdr' width="35%">
- <a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&is_desc=<?php echo $is_desc;?>&orderkey=upper'> Province</a>
- </td>
- <td align=center class='hdr' width="15%"> Action</td>
- </tr><br>
- <tr width=90%>
- <?php
- /*
- $where = "where fund_id > 0 order by $prefd";
- $nFund = new Funds;
- $nFund->SelectDataWhere($preft, $where);
- $nResult = $nFund->outselect;
- $nFund->NumRows($nResult);
- if ($nFund->outnumrow==0) {
- print "<br><font color=red><div align= center>  No record found </div></font>\n";
- }*/
- $nresult = new EBPLSLGU($dbLink,'false');
- $norow=($pagemulti*$max_resultsr)-$max_resultsr;
- while($get_infor = @mysql_fetch_assoc($fetchrecord))
- {
- $norow++;
- $sql = "Select * from ebpls_province where province_code = $get_infor[upper]";
- $province = @mysql_query($sql);
- $get_province = @mysql_fetch_assoc($province);
- include'tablecolor-inc.php';
- print "<tr bgcolor='$varcolor'>\n";
- print "<td width=5%> $norow </td>\n";
- print "<td width=10%> $get_infor[city_municipality_code] </td>\n";
- print "<td width=35%> $get_infor[city_municipality_desc] </td>\n";
- print "<td width=35%> $get_province[province_desc] </td>\n";
- print "<td align=center width=15%> <a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&com=edit&bbo=$get_infor[city_municipality_code]&orderkey=$orderkey&is_asc=$is_asc&page=$pager' class='subnavwhite'>Edit</a> | ";
-
- ?>
- <a class='subnavwhite' href='#' onClick="javascript: confdel('<?php echo $get_infor['city_municipality_code']; ?>');">Delete</a>
- </td>
- <?php
-
- }
- echo "<table border=0 width=100%><tr><td align=left><br />";
- if($pager > 1){
- $prevr = ($pager - 1);
- echo "<a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&page=1&orderkey=$orderkey&is_asc=$is_asc'><< ";
- echo "<a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&page=$prevr&orderkey=$orderkey&is_asc=$is_asc'>Prev ";
- }
- if ($pager >=7) {
- for($i = $pager-5; $i < $pager; $i++){
- echo "<a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&page=$i&orderkey=$orderkey&is_asc=$is_asc'>$i</a> ";
- }
- echo "$pager ";
- if ($total_pagesr > ($pager + 5)) {
- $tot_page = $pager + 5;
- } else {
- $tot_page = $total_pagesr;
- }
- for($i = $pager+1; $i <= $tot_page; $i++){
- echo "<a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&page=$i&orderkey=$orderkey&is_asc=$is_asc'>$i</a> ";
- }
- } else {
- if ($total_pagesr > 11) {
- $tot_page = 11;
- } else {
- $tot_page = $total_pagesr;
- }
- for($i = 1; $i <= $tot_page; $i++){
- if ($tot_page != '1') {
- if(($pager) == $i){
- echo "$i ";
- } else {
- echo "<a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&page=$i&orderkey=$orderkey&is_asc=$is_asc'>$i</a> ";
- }
- }
- }
- }
- // Build Next Link
- if($pager < $total_pagesr){
- $nextr = ($pager + 1);
- echo "<a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&page=$nextr&orderkey=$orderkey&is_asc=$is_asc'>Next </a>";
- echo "<a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&page=$total_pagesr&orderkey=$orderkey&is_asc=$is_asc'>>></a>";
- }
-
- echo "</td></tr></table>";
- ?>
- </form>