/pager/citizenship_page.php
PHP | 187 lines | 147 code | 21 blank | 19 comment | 40 complexity | ad55b9734a0ebe2c526be2bc8daa6e56 MD5 | raw file
- <?php
- $page = isset($page) ? $page : ''; //2008.05.13
- $orderkey = isset($orderkey) ? $orderkey : '';
- $varcolor = isset($varcolor) ? $varcolor : '';
- $ascdesc1 = isset($ascdesc1) ? $ascdesc1 : '';
- if ($ascdesc1=='') {
- $ascdesc1=$is_desc;
- } else {
- $is_desc=$ascdesc1;
- }
- require 'setup/setting.php';
- $max_resultsr = $thIntPageLimit;
- $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 ($is_desc=='DESC') {
- $is_desc='ASC';
- } else {
- $is_desc='DESC';
- }
- if ($pagemulti=='') {
- $pagemulti=1;
- }
- //echo $is_desc."VooDoo";
- if ($orderkey=="") {
- $orderkey = "cit_desc";
- }
- $nresult = new EBPLSCitizenship($dbLink,'false');
- $nresult->pagesearch($fromr, $max_resultsr, $orderkey, $is_desc);
- $fetarray = $nresult->rcount;
- //echo $fetarray."VooDoo";
- //echo $total_resultsr."Robert<br>";
- $total_sr = @mysql_fetch_row($fetarray);
- $total_resultsr = $total_sr[0];
- //echo $fetarray[0]."VooDoo";
- $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><br />";
- if($pager > 1){
- $prevr = ($pager - 1);
- echo "<a href='index.php?part=4&class_type=Preference&selMode=$selMode&action_=8&itemEvent=1&data_item=0&page=1&orderkey=$orderkey&ascdesc1=$ascdesc1'><<</a> ";
- echo "<a href='index.php?part=4&class_type=Preference&selMode=$selMode&action_=8&itemEvent=1&data_item=0&page=$prevr&orderkey=$orderkey&ascdesc1=$ascdesc1'>Prev</a> ";
- }
-
- if ($pager >=7) {
- for($i = $pager-5; $i < $pager; $i++){
- echo "<a href='index.php?part=4&class_type=Preference&selMode=$selMode&action_=8&itemEvent=1&data_item=0&page=$i&orderkey=$orderkey&ascdesc1=$ascdesc1'>$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=$selMode&action_=8&itemEvent=1&data_item=0&page=$i&orderkey=$orderkey&ascdesc1=$ascdesc1'>$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=$selMode&action_=8&itemEvent=1&data_item=0&page=$i&orderkey=$orderkey&ascdesc1=$ascdesc1'>$i</a> ";
- }
- }
- }
- }
-
- // Build Next Link
-
- if($pager < $total_pagesr){
- $nextr = ($pager + 1);
- echo "<a href='index.php?part=4&class_type=Preference&selMode=$selMode&action_=8&itemEvent=1&data_item=0&page=$nextr&orderkey=$orderkey&ascdesc1=$ascdesc1'>Next</a> ";
- echo "<a href='index.php?part=4&class_type=Preference&selMode=$selMode&action_=8&itemEvent=1&data_item=0&page=$total_pagesr&orderkey=$orderkey&ascdesc1=$ascdesc1'>>></a>";
- }
-
-
- echo "</td></tr></table>";
-
-
- ?>
- <table align=center border=0 cellspacing=0 cellpadding=0 width=100%>
-
- <tr>
- <td class='hdr'> No.</td>
-
- <td align=center class='hdr'>
-
- <a href='index.php?part=4&class_type=Preference&selMode=<?php echo $selMode;?>&action_=8&itemEvent=1&data_item=0&orderkey=cit_desc&is_desc=<?php echo $is_desc;?>'>
- Citizenship</a>
- </td>
- <td align=center class='hdr'> 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 EBPLSCitizenship($dbLink,'false');
- $norow=($pagemulti*$max_resultsr)-$max_resultsr;
- while($get_infor = mysql_fetch_assoc($fetchrecord))
- {
- $norow++;
- //include'tablecolor-inc.php';
- print "<tr bgcolor='$varcolor'>\n";
- print "<td width=5%> $norow </td>\n";
- print "<td width=10%> $get_infor[cit_desc] </td>\n";
- print "<td align=center width=24%> <a href='index.php?part=4&class_type=Preference&selMode=$selMode&action_=8&itemEvent=1&data_item=0&com=edit&bbo=$get_infor[cit_id]' class='subnavwhite'>Edit</a> | ";
-
- ?>
- <a class='subnavwhite' href='#' onClick="javascript: confdel('<?php echo $get_infor[CIT_ID]; ?>');">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=$selMode&action_=8&itemEvent=1&data_item=0&page=1&orderkey=$orderkey&ascdesc1=$ascdesc1'><<</a> ";
- echo "<a href='index.php?part=4&class_type=Preference&selMode=$selMode&action_=8&itemEvent=1&data_item=0&page=$prevr&orderkey=$orderkey&ascdesc1=$ascdesc1'>Prev</a> ";
- }
-
- if ($pager >=7) {
- for($i = $pager-5; $i < $pager; $i++){
- echo "<a href='index.php?part=4&class_type=Preference&selMode=$selMode&action_=8&itemEvent=1&data_item=0&page=$i&orderkey=$orderkey&ascdesc1=$ascdesc1'>$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=$selMode&action_=8&itemEvent=1&data_item=0&page=$i&orderkey=$orderkey&ascdesc1=$ascdesc1'>$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=$selMode&action_=8&itemEvent=1&data_item=0&page=$i&orderkey=$orderkey&ascdesc1=$ascdesc1'>$i</a> ";
- }
- }
- }
- }
-
- // Build Next Link
-
- if($pager < $total_pagesr){
- $nextr = ($pager + 1);
- echo "<a href='index.php?part=4&class_type=Preference&selMode=$selMode&action_=8&itemEvent=1&data_item=0&page=$nextr&orderkey=$orderkey&ascdesc1=$ascdesc1'>Next</a> ";
- echo "<a href='index.php?part=4&class_type=Preference&selMode=$selMode&action_=8&itemEvent=1&data_item=0&page=$total_pagesr&orderkey=$orderkey&ascdesc1=$ascdesc1'>>></a>";
- }
- echo "</td></tr></table>";
-
- ?>
- </form>