<?php

/*
LabStoRe
Version: 1.6.3
Date: 6 September 2014
Copyright: Santosh Patnaik, MD, PhD
License: GPL 3+
URL: www.bioinformatics.org/phplabware
*/

// Page numbering

if($total_pages > 1) {
  echo '<tr valign="top" style="background-color:', $heading_color, ';"><td colspan="', $column_nos, '" style="align:middle;"><span style="color:#808080;">Page ', $page, ' of ', $total_pages, '<br />';
  // For 'previous'
  if($page > 1) {
    $prev = ($page - 1);
    echo "<a href=\"", htmlspecialchars($_SERVER['PHP_SELF']), "?&amp;smenu_1=", rawurlencode($smenu_1), "&amp;sterm_1=" . rawurlencode($sterm_1), "&amp;smenu_2=", rawurlencode($smenu_2), "&amp;sterm_2=", rawurlencode($sterm_2), "&amp;order_1=" . rawurlencode($order_1), "&amp;order_2=", rawurlencode($order_2), "&amp;sort_1=", rawurlencode($sort_1), "&amp;sort_2=", rawurlencode($sort_2), "&amp;sbool=", rawurlencode($sbool), "&amp;page=", $prev, "\">&laquo;Previous</a>&nbsp;";
  }
  // For rest of pages
  for($i = 1;$i <= $total_pages;$i++) {
    if($i == $page) {
      echo $i, "&nbsp;";
    }
    else {
      if(abs($i - $page) < 10) {
        echo "<a href=\"", htmlspecialchars($_SERVER['PHP_SELF']), "?&amp;smenu_1=", rawurlencode($smenu_1), "&amp;sterm_1=" . rawurlencode($sterm_1), "&amp;smenu_2=", rawurlencode($smenu_2), "&amp;sterm_2=", rawurlencode($sterm_2), "&amp;order_1=" . rawurlencode($order_1), "&amp;order_2=", rawurlencode($order_2), "&amp;sort_1=", rawurlencode($sort_1), "&amp;sort_2=" . rawurlencode($sort_2), "&amp;sbool=", rawurlencode($sbool), "&amp;page=", $i, "\">", $i, "</a>&nbsp;";
      }
    }
  }
  // For 'next'
  if($page < $total_pages) {
    $next = ($page + 1);
    echo "<a href=\"", htmlspecialchars($_SERVER['PHP_SELF']), "?&amp;smenu_1=", rawurlencode($smenu_1), "&amp;sterm_1=", rawurlencode($sterm_1), "&amp;smenu_2=", rawurlencode($smenu_2), "&amp;sterm_2=", rawurlencode($sterm_2), "&amp;order_1=", rawurlencode($order_1), "&amp;order_2=", rawurlencode($order_2), "&amp;sort_1=", rawurlencode($sort_1), "&amp;sort_2=", rawurlencode($sort_2), "&amp;sbool=", rawurlencode($sbool), "&amp;page=", $next, "\">Next&raquo;</a></span>";
  }
  echo('</td></tr>');
}
echo('</table>');

// Build lower table

if($num_tot != 0) {
  echo('<table width="750" summary="export" style="background-color:#dcdcdc; border:0;" cellpadding="5" cellspacing="1"><tr><td>');
  // Excel export options - ordering maintained
  echo '<form action="../export.php" method="post"><p>
 <select single="single" name="parameter" id="parameter">
 <option value="Excel">Export the ', $num_sat, ' entries in Excel format, or...</option>
 <option value="CSV">the ', $num_sat, ' entries in CVS format</option>';
  echo('</select>');
  // Hidden values to pass the mysql query and table name
  echo '<input type="hidden" name="order_1" value="', htmlspecialchars($order_1), '" /><input type="hidden" name="order_2" value="', htmlspecialchars($order_2), '" /><input type="hidden" name="sort_1" value="', htmlspecialchars($sort_1), '" /><input type="hidden" name="sort_2" value="', htmlspecialchars($sort_2), '" /><input type="hidden" name="sterm_1" value="', htmlspecialchars($sterm_1), '" /><input type="hidden" name="sterm_2" value="', htmlspecialchars($sterm_2), '" /><input type="hidden" name="smenu_1" value="', htmlspecialchars($smenu_1), '" /><input type="hidden" name="smenu_2" value="', htmlspecialchars($smenu_2), '" /><input type="hidden" name="sbool" value="', htmlspecialchars($sbool), '" /><input type="hidden" name="table" id="table" value="', htmlspecialchars($table), '" />
<input type="submit" name="export" id="export" value="Export" /><a href="../help/help.htm#export" onclick="return popitup(\'../help/help.htm#export\')">?</a>
 </p></form>';
  echo $extra_bottom, '</td></tr></table>';
}