<? 
require_once "include/application.php"; 
require_once "include/paginator.php";
require_once "include/paginator_html.php";
require_once "include/function.php";


?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" type="text/css" href="sddm.css" >
<script src="include/validation.js" type="text/javascript"></script>
<title><? echo TITLE?></title>
</head>
<body>

<table width="1024" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#f1efd8">
  <tr>
    <td colspan="2" align="center"><? require_once "include/header.php"; ?></td>
  </tr>

  <tr>
    <td width="185" valign="top" bgcolor="e6f3f9">
	
<? require_once "include/columnLeft.php";

if(array_search("Rooms",$menulist)==false)
		print("<script type='text/javascript'>location.href='index.php'</script>");

 ?>	</td>
    <td width="834" valign="top">
	<form name="form" method="post" action="<?=$PHP_SELF ?>" >
<br />
<table width="810" border="0" align="center" cellpadding="0" cellspacing="0">
      
      <tr>
        <td valign="top" ><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td width="100%" height="30" class="TitleH3">Products</td>
          </tr>
          <tr>
            <td height="1"></td>
          </tr>
          

        </table>
          <table border="0" cellpadding="1" width="100%" cellspacing="2" class="small">
            <tr>
              <td height="7" colspan="10" class="text12"><span class="TextH1">
                <select name="sType" id="sType">
                  <option value="Code">Product Code</option>
                  <option value="Name">Product Name</option>
                    </select>
                <input name="sReferral" type="text" id="sReferral" value="<? echo $sReferral ?>" />
                <? stayfocus("form","sType",$sType) ?>
                <input name="btnSearch" type="submit" class="btn" id="btnSearch" value="Search"/>
              </span></td>
            </tr>
            

            <tr>
              <td height="35" colspan="10" class="text12"><input type="button" name="btnAdd" value="Add" class="btn" onclick="location.href='addProducts.php'"/></td>
            </tr>
            <tr class="menuHeader">
              <td width="98" height="23" class="TextH1"><div align="center">Product Code </div></td>
              <td width="177" class="TextH1"><div align="center">Product Name </div></td>
              <td width="145" class="TextH1"><div align="center">Prices (RM) </div></td>
              <td width="81" class="TextH1"><div align="center">Program Tenure (Years) </div></td>
              <td width="100" class="TextH1"><div align="center">Annual Entitlement (Nights) </div></td>
              <td width="135" class="TextH1"><div align="center">Room</div></td>
              <td width="34">&nbsp;</td>
            </tr>
            <?
	
	$sql="select * from ivc_products left join ivc_rooms on ip_room=ir_id where 1 ";
	if($sReferral){
		if($sType=="Code")$sql.=" and ip_code like '%$sReferral%'";			
		else if($sType=="Name")$sql.=" and ip_name like '%$sReferral%'";				
	}	
	
	$result=mysql_query($sql);
	$num_rows=mysql_num_rows($result);
	
	$pass="so=1";
    $a =& new Paginator_html($_GET['page'],$num_rows,$pass);	$a->set_Limit(15); $a->set_Links(10);  	
	$limit1 = $a->getRange1();  
	$limit2 = $a->getRange2();  
	$sql.=" order by ip_code limit $limit1,$limit2 ";	
	$result=mysql_query($sql) or die(mysql_error());
	
	while($myrow=MySQL_fetch_array($result,MYSQL_ASSOC))
	{
		echo "<tr bgcolor='#ffffff' class='TextH1'>"; 
		$id=$myrow["ip_id"];
	    echo "<td height='20' align='center' class='text12'>".$myrow["ip_code"]."</td>";	  				
	    echo "<td height='20' align='center' class='text12'>".$myrow["ip_name"]."</td>";	  				
		echo "<td align='center' class='text12'>".$myrow["ip_price"]."</td>";	  			
		echo "<td align='center' class='text12'>".$myrow["ip_program"]."</td>";	  	
		echo "<td align='center' class='text12'>".$myrow["ip_night"]."</td>";	  	
		echo "<td align='center' class='text12'>".$myrow["ir_type"]."</td>";	  	
	    echo "<td align='center' class='text12'><a href='editProducts.php?id=$id'><img src='images/view.png' border='0'></a>";
		echo "</td>";	  								
		echo "</tr>";

	}

?>
            <tr>
              <td colspan="10" class="TextH2"><? echo "Total Record :[".$num_rows."] "; if($num_rows)$a->previousNext();?></td>
            </tr>
          </table></td>
        </tr>
    </table>
	  <br />
	</form>	</td>
  </tr>
  <tr>
    <td colspan="2" bgcolor="#333333"><div align="center"><span class="Footer">
      <br />
      <? require_once "footer.php"; ?>
    </span></div></td>
  </tr>
</table>
</body>
</html>
