<?php
ob_start();
session_start();
/******************INCLUDES**********************/
include('connection/connection.php');
include_once('index.fns.php');
include_once('lib/class.user.php');
include_once('lib/class.report_handler.php');
include_once('lib/class.validate.php');
include_once 'admin_end/config.php';
include_once 'admin_end/includes/mysql.inc.php';
$_SESSION['link'] = $_SERVER['QUERY_STRING'];
$frontEnd= new frontEnd;
$user= new user;
/************************************************/

$action = isset($_POST['action'])?$_POST['action']:NULL;
$id = $_REQUEST['id'];
$level= $_REQUEST['level'];
$parent= $_REQUEST['parent'];
$category_id= $_REQUEST['category_id'];

// Number of entries per page
$numentries=18;

// Get form data
if(!isset($_GET['page'])) {
	$page=0;
} else {
	$page=$_GET['page'];
}
if(!isset($_GET['sort'])) {
	$sort='cat_name';
} else {
	$sort=$_GET['sort'];
}
if(!isset($_GET['order'])) {
	$order='ASC';
} else {
	$order=$_GET['order'];
}

// Set up vars, all default order ASC
$orderAddress='ASC';
$orderName='ASC';
$orderPhone='ASC';
$orderFax='ASC';
$orderLocation='ASC';
$orderLsent='ASC';
$orderList='ASC';

// Change current sorted group order
switch($sort) {
	case 'name':
		if($order=='ASC') {
			$orderName='DESC';
		} else {
			$orderName='ASC';
		}
		break;
	case 'price':
		if($order=='ASC') {
			$orderPrice='DESC';
		} else {
			$orderPrice='ASC';
		}
		break;
	case 'description':
		if($order=='ASC') {
			$orderDescription='DESC';
		} else {
			$orderDescription='ASC';
		}
		break;
}

		  $query='SELECT * FROM categories WHERE company_id='.$id.' ORDER BY cat_name';
		  $result=mysqli_query($db, $query) or die('Unable to retreive subscribers');
		  
		  $query_comp='SELECT * FROM companies WHERE company_id='.$id.'';
		  $result_comp=mysqli_query($db, $query_comp) or die('Unable to retreive subscribers');
			
		$cat='';
		while($val=mysqli_fetch_object($result)){
			$cat.=$val->cat_name.', ';
		}
		
		$cmp='';
		while($comp=mysqli_fetch_object($result_comp)){
			$cmp.=$comp->name.', ';
		}
?>
<!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=utf-8" />
<meta name="Description" content="Kuwait Commercials <?=isset($cmp)?$cmp:''?> <?=isset($cat)?$cat:''?>"/>
<meta name="Keywords" content="Kuwait Commercials <?=isset($cmp)?$cmp:''?> <?=isset($cat)?$cat:''?>"/>
<link href="css/style.css" type="text/css" rel="stylesheet" />
<link href="css/menu1.css" type="text/css" rel="stylesheet" />
<title>Kuwait Commercials <?=isset($cmp)?$cmp:''?> <?=isset($cat)?$cat:''?> </title>
<!--<script type="text/javascript" src="js/jquery.min.js"></script>
<script type="text/javascript" src="js/ddaccordion.js"></script>
<script src="Scripts/scriptaculous/prototype.js" type="text/javascript"></script>
<script src="Scripts/scriptaculous/scriptaculous.js" type="text/javascript"></script>
<script type="text/javascript" src="js/dropdown.js"></script>-->
<?php
				include("includes/jquery.php");
			?>
</head>
<body>
<div id="main_wrap">
  <div id="main_container">
     <?php
				include("includes/index_header.php");
			?>
    <div class="blue_line"> <?php
				include("includes/menu.php");
			?></div>
    <div class="top_content">

       <?php

				include("includes/top_bar.php");

		?>

    </div>

	
    <div id="inner_content">
      <div class="left_side_content">
        <div class="search_box_content">
          <?php
			include("includes/search.php");
		?>
        </div>
        <div class="left_content">
          <?
		 if(is_object($user) && $user->getErr()){ 
		echo "<div class=\"error_msg\"><ul>".$user->getErr()."</ul></div>";
         } 
		?>
   <?

// Navigation menu
$d=0;
$f=0;
$g=1+$d/$numentries;
$num_rows=mysqli_num_rows($result);
$currentpage=($page/$numentries)+1;
$prev=$page-$numentries;
$next=$page+$numentries;
$nav='';
if($page>=$numentries) {
	$nav.='<a href="' . $self . '?page=' . $prev . '&sort=' . $sort . '&order=' . $order . '&id='.$id.'&level='.$level.'&company_id='.$id.'"><<</a>&nbsp;';
} else {
	$nav.='<<&nbsp;';
}
while($row=mysqli_fetch_array($result)) {
	if($f>=$page-3*$numentries && $f<=$page+7*$numentries) {
		if($f%$numentries==0 && $currentpage != $g) {
			$nav.='<a href="' . $self . '?page=' . $d . '&sort=' . $sort . '&order=' . $order . '&id='.$id.'&level='.$level.'&company_id='.$id.'">' . $g . '</a> ';
		}
		else if($currentpage==$g) {
			$nav.=$currentpage . ' ';
		}
	}
	$d=$d+1;
	$g=1+$d/$numentries;
	$f++;
}  
if($page<=$num_rows-$numentries) {
	$nav.='<a href="' . $self . '?page=' . $next . '&sort=' . $sort . '&order=' . $order . '&id='.$id.'&level='.$level.'&company_id='.$id.'">>></a>&nbsp;';
} else {
	$nav.='>>&nbsp;';
}

$query='SELECT * FROM categories WHERE company_id='.$id.' ORDER BY ' . $sort . ' ' . $order . ' limit ' . $page . ', ' . $numentries;

$result=mysqli_query($db, $query) or die('Could not get subscribers');
$table = "level".$level."_categories";

//$qz1 = mysql_query("select * from  $table WHERE id=".$category_id);
//$row1=mysql_fetch_array($qz1);

$qz2 = mysql_query("select * from  companies WHERE company_id=".$id);
$row2=mysql_fetch_array($qz2);

echo '<p>&nbsp;</p><p><h2><a href="detailA.php?company_id='.$id.'&cat_id='.$category_id.'&level='.$level.'&parent='.$parent.'" style="font-size:17px;">'.$row2['name']. '</a></h2></p><br><p><b><span style="color:#000000"><div style="background-color:#FFFF2D; width:290px; height:19px;">&nbsp;Click the image to select items in category</div></span></b></p>'; 



echo '<form id="form1" name="form1" method="post" action="cart.php"><input type="hidden" name="act" value="add" /><table width="100%" border="0" cellpadding="0" cellspacing="0" style="font-size:11px;"><tr><td>';
$j=0;
while($row=mysqli_fetch_array($result)) {

	echo '<div class="cat_images">';
	if($row['cat_image'] != '') 
	echo '<a href="products.php?cat='.$row['cat_id'].'&id='.$id.'&level='.$level.'&category_id='.$cat_id.'&parent='.$parent.'"><img src="images/companyImages/categories/'.$row['cat_image'].'" width="100" height="100" class="img" border="0"></a>';
	else 
	echo '<a href="products.php?cat='.$row['cat_id'].'&id='.$id.'&level='.$level.'&category_id='.$cat_id.'&parent='.$parent.'"><img src="images/companyImages/categories/noImage.gif" width="100" height="100"  class="img" border="0"></a>';
	echo '<br><a href="products.php?cat='.$row['cat_id'].'&id='.$id.'&level='.$level.'&category_id='.$cat_id.'&parent='.$parent.'">'.$row['cat_name'].'</a>';
	
	if($row['arabic_name']!=''){
	echo '<br/><br/><a href="products.php?cat='.$row['cat_id'].'&id='.$id.'&level='.$level.'&category_id='.$cat_id.'&parent='.$parent.'">'.$row['arabic_name'].'</a>';
	}
	echo '</div>';
	if($j%5==4) echo '</td></tr><tr><td>';
	
}
echo '<tr><td colspan="5" align="right"><br /><div>' . $nav . '</div><div>&nbsp;</div></td></tr></table></form>';
/*echo '<br /><div>NOTE: Refresh page after confirming subscribers - <a href="javascript:window.location.reload(true);">Refresh</a></div>';*/

	
	
		  
		  ?>
		  <p>&nbsp;</p>
          
        </div>
      </div>
      <div class="right_sidebar">
        <? $frontEnd->showCategories($id,$level,$parent);?>
      </div>
    </div>
	<div id="useful_links">

     <?

		echo $frontEnd->getUsefulLinks();

	 ?>

    </div>

    <div class="footer">
       <?php include("static/footer_statistics.php"); ?>
    </div>
  </div>
</div>
</body>
</html>
