<?php
require("./include/JSON.php");
require('appconfig.php');
$_SESSION[$xg_appkey]['menu']=$_POST['mensub'];
$xret.="<br><center><table border=0 width='95%'>
	<tr>";
	
	
		$xret.="<td valign='top' width='33%'>
				<p style='margin-left:5px;border-bottom:1px solid black'>CODE DEFINITION</p>
				<table border=0  style='font-size:14px' cellspacing='3' cellpadding='3' style='width:100%'>";
					
					$xqrycd="SELECT * FROM menus WHERE mengrp = ? AND mensub<>'' ";
					$xstmtcd=$link_id->prepare($xqrycd);
					$xstmtcd->execute(array($_POST['mensub']));
					$xrscd=$xstmtcd->fetch();
					//~ var_dump($xrscd['mensub']);

					$xqrycount="SELECT count(*) as xbilang FROM menus WHERE menheader = ? and mengrp = ? and menidx<>'x' ";
               $xstmtcount=$link_id->prepare($xqrycount);
					$xstmtcount->execute(array('Code Definition',$xrscd['mensub']));
					$xrscount=$xstmtcount->fetch();
					//~ var_dump($xrscount['xbilang']);
               $xbilang=$xrscount['xbilang'];
               
               $xqry="SELECT * FROM menus WHERE menheader = ? and mengrp = ? and menidx<>'x' ORDER BY menidx ";
               $xstmt=$link_id->prepare($xqry);
					$xstmt->execute(array('Code Definition',$xrscd['mensub']));
					$x=0;
					while($xrs=$xstmt->fetch())
					{
                  if($xbilang>20)
                  {
							//~ echo"<tr>";
							$xret.="<td><a onclick=\"load_page('".$xrs['menprg']."')\">".$xrs['mencap']."</a></td>";
							
							if($x%2)
							{
									//~ var_dump($x);
									$xret.="</tr>";
							}
						}
						else
						{
							$xret.="<tr>";
							$xret.="<td><a onclick=\"load_page('".$xrs['menprg']."')\">".$xrs['mencap']."</a></td>";
							$xret.="</tr>";
						}
					$x++;
					}
					
				$xret.="</table>
		</td>";
		$xret.="<td width='5%'></td>
		<td  valign='top' width='33%'>
			<p style='margin-left:5px;border-bottom:1px solid black'>TRANSACTION</p>
		     <table style='font-size:14px'  cellspacing='3' cellpadding='3'  style='width:100%'>";
 							$xqry="SELECT * FROM menus WHERE menheader = ? and mengrp = ? and menidx<>'x' ";
							$xstmt=$link_id->prepare($xqry);
							$xstmt->execute(array('Transaction',$_POST['mensub']));
							$x=0;
							while($xrs=$xstmt->fetch())
							{
									$xret.="<tr>";
									$xret.="<td><a onclick=\"load_page('".$xrs['menprg']."')\">".$xrs['mencap']."</a></td>";
									$xret.="</tr>";
							}
						
				$xret.="</table>
				<table style='font-size:14px'   cellspacing='3' cellpadding='3'  style='width:100%'>
						<p style='margin-left:5px;border-bottom:1px solid black'>SETUP</p>";
 							$xqry="SELECT * FROM menus WHERE menheader = ? and mengrp = ? and menidx<>'x' ";
							$xstmt=$link_id->prepare($xqry);
							$xstmt->execute(array('Setup',$_POST['mensub']));
							$x=0;
							while($xrs=$xstmt->fetch())
							{
									$xret.="<tr>";
									$xret.="<td><a onclick=\"load_page('".$xrs['menprg']."')\">".$xrs['mencap']."</a></td>";
									$xret.="</tr>";
							}
					
				$xret.="</table>
		</td>
		<td width='5%'></td>
		<td  valign='top' width='33%'>
				<table style='font-size:14px'  cellspacing='3' cellpadding='3'  style='width:100%'>
					<p style='margin-left:5px;border-bottom:1px solid black'>REPORT</p>";
 							$xqry="SELECT * FROM menus WHERE menheader = ? and mengrp = ? and menidx<>'x' ";
							$xstmt=$link_id->prepare($xqry);
							$xstmt->execute(array('Reports',$_POST['mensub']));
							$x=0;
							while($xrs=$xstmt->fetch())
							{
									$xret.="<tr>";
									$xret.="<td><a onclick=\"load_page('".$xrs['menprg']."')\">".$xrs['mencap']."</a></td>";
									$xret.="</tr>";
							}
							
				$xret.="</table>
		</td>
	</tr>
</table>";

$xretobj=$xret;
$json = new Services_JSON();
echo $json->encode($xretobj);

?>
