<?php
$xctr_menu = 30;
			$xctr = 0;
			$xarr_column = array();
			$xarr_column_excess = array();
			$xquery = "SELECT mencap,menprg,menidx FROM menus WHERE mencol=1";
			$xstmt_menu = $link_id->prepare($xquery);
			$xstmt_menu->execute(array($xcolumn));
			while($xrs=$xstmt_menu->fetch())
			{
						if($_SESSION[$xg_appkey]['usrlvl'] == 'User')
						{
									$xquery2 = "SELECT mencap,menprg FROM user_menus WHERE mencap=? AND usrcde=?";
									$xstmt_menu2 = $link_id->prepare($xquery2);
									$xstmt_menu2->execute(array($xrs['mencap'] , $_SESSION[$xg_appkey]['usrcde']));
									if($xrs_menus=$xstmt_menu2->fetch())
									{
												
												if($xctr > $xctr_menu)
												{
															$xarr_column_excess[$xrs_menus['mencap']] = trim($xrs_menus['menprg']);
												}
												else
												{
															
															$xarr_column[$xrs_menus['mencap']] = trim($xrs_menus['menprg']);
												}
												$xctr++;
									}
						}
						else
						{
									
									if($xctr > $xctr_menu)
									{
												$xarr_column_excess[$xrs['mencap']] = trim($xrs['menprg']);
									}
									else
									{
												
												$xarr_column[$xrs['mencap']] = trim($xrs['menprg']);
									}
									$xctr++;
						}
						
			}
			
			$xctr = 0;
			$xarr_column2 = array();
			$xarr_column_excess2 = array();
			$xquery = "SELECT mencap,menprg,menidx FROM menus WHERE mencol=2";
			$xstmt_menu = $link_id->prepare($xquery);
			$xstmt_menu->execute(array($xcolumn));
			while($xrs=$xstmt_menu->fetch())
			{
						if($_SESSION[$xg_appkey]['usrlvl'] == 'User')
						{
									$xquery2 = "SELECT mencap,menprg FROM user_menus WHERE mencap=? AND usrcde=?";
									$xstmt_menu2 = $link_id->prepare($xquery2);
									$xstmt_menu2->execute(array($xrs['mencap'] , $_SESSION[$xg_appkey]['usrcde']));
									if($xrs_menus=$xstmt_menu2->fetch())
									{
												
												if($xctr > $xctr_menu)
												{
															$xarr_column_excess2[$xrs_menus['mencap']] = trim($xrs_menus['menprg']);
												}
												else
												{
															
															$xarr_column2[$xrs_menus['mencap']] = trim($xrs_menus['menprg']);
												}
												$xctr++;
									}
						}
						else
						{
									if($xctr > $xctr_menu)
									{
												$xarr_column_excess2[$xrs['mencap']] = trim($xrs['menprg']);
									}
									else
									{
												
												$xarr_column2[$xrs['mencap']] = trim($xrs['menprg']);
									}
									$xctr++;
						}
						
			}
			
			$xctr = 0;
			$xarr_column3 = array();
			$xarr_column_excess3 = array();
			$xquery = "SELECT mencap,menprg,menidx FROM menus WHERE mencol=3";
			$xstmt_menu = $link_id->prepare($xquery);
			$xstmt_menu->execute(array($xcolumn));
			while($xrs=$xstmt_menu->fetch())
			{
						if($_SESSION[$xg_appkey]['usrlvl'] == 'User')
						{
									$xquery3 = "SELECT mencap,menprg FROM user_menus WHERE mencap=? AND usrcde=?";
									$xstmt_menu3 = $link_id->prepare($xquery3);
									$xstmt_menu3->execute(array($xrs['mencap'] , $_SESSION[$xg_appkey]['usrcde']));
									if($xrs_menus=$xstmt_menu3->fetch())
									{
												
												if($xctr > $xctr_menu)
												{
															$xarr_column_excess3[$xrs_menus['mencap']] = trim($xrs_menus['menprg']);
												}
												else
												{
															
															$xarr_column3[$xrs_menus['mencap']] = trim($xrs_menus['menprg']);
												}
												$xctr++;
									}
						}
						else
						{
									if($xctr > $xctr_menu)
									{
												$xarr_column_excess3[$xrs['mencap']] = trim($xrs['menprg']);
									}
									else
									{
												
												$xarr_column3[$xrs['mencap']] = trim($xrs['menprg']);
									}
									$xctr++;
						}
						
			}
			
			$xctr = 0;
			$xarr_column4 = array();
			$xarr_column_excess4 = array();
			$xquery = "SELECT mencap,menprg,menidx FROM menus WHERE mencol=4";
			$xstmt_menu = $link_id->prepare($xquery);
			$xstmt_menu->execute(array($xcolumn));
			while($xrs=$xstmt_menu->fetch())
			{
						if($_SESSION[$xg_appkey]['usrlvl'] == 'User')
						{
									$xquery4 = "SELECT mencap,menprg FROM user_menus WHERE mencap=? AND usrcde=?";
									$xstmt_menu4 = $link_id->prepare($xquery3);
									$xstmt_menu4->execute(array($xrs['mencap'] , $_SESSION[$xg_appkey]['usrcde']));
									if($xrs_menus=$xstmt_menu4->fetch())
									{
												
												if($xctr > $xctr_menu)
												{
															$xarr_column_excess4[$xrs_menus['mencap']] = trim($xrs_menus['menprg']);
												}
												else
												{
															
															$xarr_column4[$xrs_menus['mencap']] = trim($xrs_menus['menprg']);
												}
												$xctr++;
									}
						}
						else
						{
									if($xctr > $xctr_menu)
									{
												$xarr_column_excess4[$xrs['mencap']] = trim($xrs['menprg']);
									}
									else
									{
												
												$xarr_column4[$xrs['mencap']] = trim($xrs['menprg']);
									}
									$xctr++;
						}
						
			}
			
			$xctr = 0;
			$xarr_column5 = array();
			$xarr_column_excess5 = array();
			$xquery = "SELECT mencap,menprg,menidx FROM menus WHERE mencol=5";
			$xstmt_menu = $link_id->prepare($xquery);
			$xstmt_menu->execute(array($xcolumn));
			while($xrs=$xstmt_menu->fetch())
			{
						if($_SESSION[$xg_appkey]['usrlvl'] == 'User')
						{
									$xquery4 = "SELECT mencap,menprg FROM user_menus WHERE mencap=? AND usrcde=?";
									$xstmt_menu4 = $link_id->prepare($xquery3);
									$xstmt_menu4->execute(array($xrs['mencap'] , $_SESSION[$xg_appkey]['usrcde']));
									if($xrs_menus=$xstmt_menu4->fetch())
									{
												
												if($xctr > $xctr_menu)
												{
															$xarr_column_excess5[$xrs_menus['mencap']] = trim($xrs_menus['menprg']);
												}
												else
												{
															
															$xarr_column5[$xrs_menus['mencap']] = trim($xrs_menus['menprg']);
												}
												$xctr++;
									}
						}
						else
						{
									if($xctr > $xctr_menu)
									{
												$xarr_column_excess5[$xrs['mencap']] = trim($xrs['menprg']);
									}
									else
									{
												
												$xarr_column5[$xrs['mencap']] = trim($xrs['menprg']);
									}
									$xctr++;
						}
						
			}
?>

<script>
			function load_page(xurl,cap)
			{
				
				document.forms.myform.action = xurl;
				document.forms.myform.submit();
			}
			
			function li_more_click()
			{
						if (jQuery('#a_more').text() == "SHOW MORE..")
						{
									jQuery('#menu1').find('.li_excess').attr("style", "display:inherit");
									if(window.screen.availHeight > 768)
									{
										jQuery('#menu_panel').height('120%');		
									}
									else
									{
										jQuery('#menu_panel').height('175%');		
									}
									
									jQuery('#a_more').text('HIDE OTHERS..');		
						}
						else
						{
									jQuery('#menu_panel').height('90%');
									jQuery('#menu1').find('.li_excess').attr("style", "display:none");
									jQuery('#a_more').text('SHOW MORE..');
						}
			}
			
</script>
			<div id="menu_panel">
			<div style="float: left; width: 20%;">
						<ul id='menu1' style="list-style-type: none;">
									<span style='font-size: 20px;'>Master File</span>
									<?php
									
									foreach(array_keys($xarr_column) as $keyval)
									{
											echo "<li><a href='".$xarr_column[$keyval]."'  style=' color: black; word-wrap: break-word;'>" . $keyval . "</a></li>";
									}
									
									foreach(array_keys($xarr_column_excess) as $keyval2)
									{
											echo "<li class='li_excess' style='display: none; word-wrap: break-word;'><a href='".$xarr_column_excess[$keyval2]."' style=' color: black;'>" . $keyval2 . "</a></li>";
									}
									
									if(count($xarr_column_excess) > 1)
									{
											echo "<a id='a_more' href=# onclick='li_more_click();'>SHOW MORE..</a>";	
									}
									?>
						</ul>
			</div>
			<div style="float: left; width: 20%;">
						<ul id='menu1' style="list-style-type: none;">
									<span style='font-size: 20px;'>Transaction</span>
									<?php
									
									foreach(array_keys($xarr_column2) as $keyval)
									{
											echo "<li><a href='".$xarr_column2[$keyval]."'  style=' color: black; word-wrap: break-word;'>" . $keyval . "</a></li>";
									}
									
									foreach(array_keys($xarr_column_excess2) as $keyval2)
									{
											echo "<li class='li_excess' style='display: none; word-wrap: break-word;'><a href='".$xarr_column_excess2[$keyval2]."' style=' color: black;'>" . $keyval2 . "</a></li>";
									}
									
									if(count($xarr_column_excess2) > 1)
									{
											echo "<a id='a_more' href=# onclick='li_more_click();'>SHOW MORE..</a>";	
									}
									?>
						</ul>
			</div>
			<div style="float: left; width: 20%;">
						<ul id='menu1' style="list-style-type: none;">
									<span style='font-size: 20px;'>Reports</span>
									<?php
									
									foreach(array_keys($xarr_column3) as $keyval)
									{
											echo "<li><a href='".$xarr_column3[$keyval]."'  style=' color: black; word-wrap: break-word;'>" . $keyval . "</a></li>";
									}
									
									foreach(array_keys($xarr_column_excess3) as $keyval2)
									{
											echo "<li class='li_excess' style='display: none; word-wrap: break-word;'><a href='".$xarr_column_excess3[$keyval2]."' style=' color: black;'>" . $keyval2 . "</a></li>";
									}
									
									if(count($xarr_column_excess3) > 1)
									{
											echo "<a id='a_more' href=# onclick='li_more_click();'>SHOW MORE..</a>";	
									}
									?>
						</ul>
			</div>
			<div style="float: left; width: 20%;">
						<ul id='menu1' style="list-style-type: none;">
									<span style='font-size: 20px;'>Utilities</span>
									<?php
									
									foreach(array_keys($xarr_column4) as $keyval)
									{
											echo "<li><a href='".$xarr_column4[$keyval]."'  style=' color: black; word-wrap: break-word;'>" . $keyval . "</a></li>";
									}
									
									foreach(array_keys($xarr_column_excess4) as $keyval2)
									{
											echo "<li class='li_excess' style='display: none; word-wrap: break-word;'><a href='".$xarr_column_excess4[$keyval2]."' style=' color: black;'>" . $keyval2 . "</a></li>";
									}
									
									if(count($xarr_column_excess4) > 1)
									{
											echo "<a id='a_more' href=# onclick='li_more_click();'>SHOW MORE..</a>";	
									}
									?>
						</ul>
			</div>
			<div style="float: left; width: 20%;">
						<ul id='menu1' style="list-style-type: none;">
									<span style='font-size: 20px;'>Others</span>
									<?php
									
									foreach(array_keys($xarr_column5) as $keyval)
									{
											echo "<li><a href='".$xarr_column5[$keyval]."'  style=' color: black; word-wrap: break-word;'>" . $keyval . "</a></li>";
									}
									
									foreach(array_keys($xarr_column_excess5) as $keyval2)
									{
											echo "<li class='li_excess' style='display: none; word-wrap: break-word;'><a href='".$xarr_column_excess5[$keyval2]."' style=' color: black;'>" . $keyval2 . "</a></li>";
									}
									
									if(count($xarr_column_excess5) > 1)
									{
											echo "<a id='a_more' href=# onclick='li_more_click();'>SHOW MORE..</a>";	
									}
									?>
						</ul>
			</div>
			
			
</div>
