<?
require_once("_lib/lib.php");
$_pageCurrent="category";
$_pageSection="category";


$productCharObject = new ProductChars($db);


$catID=null;
$categoryTitle="";
$encodedCat="";
$encodedS="";
$topsection="";
$toplevelUrl="";
$sortstr="";
$parentCategoryID="0";
$parentCategoryTitle="";
$titleUrlGet="";
 $selectedTitle="";
 $varsGet="";
//instantiate object
$flasgDisplayCategories=false;//to display categories or products


$rArray=array();
$rString = $_SERVER['REQUEST_URI'];
$rArray=explode("/",$rString);

//printArray($rArray);
//$encodedS=$rArray[2];

if(isset($rArray[2]) && $rArray[2]!=""){// the s is on the second place of the array
	
	$encodedS=cleanpost($rArray[2]);
        $titleUrlGet ="";
        $varsGet ="";
        $pos = strpos($rArray[3], "?");
        if ($pos === false) {
    $titleUrlGet=cleanpost($rArray[3]);
} else {
  list($titleUrlGet,$varsGet)=explode("?",$rArray[3]);
}
        
       // list($titleUrlGet,$varsGet)=explode("?",$rArray[3]);
	//$titleUrlGet=cleanpost($rArray[3]);
}else{
	header("Location: ".HOME_PAGE);exit();
}
	
	$catIDtemp=SaveSingleVar::restoreurl($encodedS);
	list($leftc,$catID)=explode("=",$catIDtemp);
	//var_dump($catIDtemp);
	//var_dump($catID);die();
	if(!ctype_digit($catID)  ){
		header("Location: ".HOME_PAGE);exit();
	}
	

if(isset($_POST["f_all"]) && $_POST["f_all"]=="1"){
   header("Location: /category/$encodedS/$titleUrlGet");exit();
}


//Find out if this category has subcategories ***************************** START	


if($productCategoryObject->loadObject("id",$catID)){

	$categoryTitle=($_lang==LANGUAGE_ENGLISH?$productCategoryObject->titleen:$productCategoryObject->title);
	$categoryBody=($_lang==LANGUAGE_ENGLISH?$productCategoryObject->bodyen:$productCategoryObject->body);
	$encodedCat=SaveSingleVar::storeurl("c=".$catID);
	$topsection=$productCategoryObject->toplevel;
	$parentCategoryID = $productCategoryObject->getCategoryParent($catID);
	$parentCategoryTitle = $productCategoryObject->getCategoryTitle($parentCategoryID);
}else{
	header("Location: /home");exit();
}
$categoryTitleUrlEN=fix_cat_name_for_url($productCategoryObject->titleen);


$countSubs =0;
$countSubs=$productCategoryObject->getsubs($catID);
if($countSubs ==0){


$wherestr=" categoryid='$catID' AND active='1' ";
$wherestrFilter=" p.categoryid='$catID' AND p.active='1' ";
$wherestrCount=" categoryid='$catID' AND active='1' ";
$sortstr="sortorder ASC";
$sortstrFilter="p.sortorder ASC";
$sortEnabled=false;
//print $_SERVER['REQUEST_URI'];
//var_dump($pos);
//printArray($_REQUEST);

/*if (isset($_REQUEST["f_sort"]) && $_REQUEST["f_sort"]=="1" ) {
	$sot="";
	$sortstr=" $titleFinal ASC";
	$sortstrFilter="p.$titleFinal ASC";
        $selectedTitle =$_string[$_lang]["ALPHAASCENDING"].", ";
}*/

if (isset($_REQUEST["orderprice"]) && $_REQUEST["orderprice"]!="" ) {
	switch($_REQUEST["orderprice"]){
		case "f_asc":
    $sot="ASC";
	$sortstr="price ASC";
	$sortstrFilter="p.price ASC";
        $selectedTitle =$_string[$_lang]["PRICEASCENDING"].", ";
		break;
		case "f_desc":
		    $sot="DESC";
	$sortstr="price DESC";
	$sortstrFilter="p.price DESC";
    $selectedTitle =$_string[$_lang]["PRICEDESCENDING"].", ";
		break;
	default:
	$sot="ASC";
	$sortstr="price ASC";
	$sortstrFilter="p.price ASC";
    $selectedTitle =$_string[$_lang]["PRICEASCENDING"].", ";
	break;	
	}
}


//get page if paging is enabled
if(isset($_GET["page"]) && $_GET["page"]!="" && ctype_digit($_GET["page"])){
	$pageNum =cleanpost($_GET["page"]);
}else{
	$pageNum="1";
}

	$rowsPerPage =PAGING_ROWSPERPAGE;
	//$rowsPerPage =2;


//echo $pageNum;
$dataProducts=array();
$dataProductsFilters=array();
$countDataProducts=0;
$countDataProducts= $productObject->get_count_all($wherestrCount);
if($countDataProducts > 0){
//get default rows per page
//$rowsPerPage=PAGING_ROWSPERPAGE;
//$rowsPerPage=2;
//$rowsPerPage=3;
// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;
 // how many pages we have when using paging?
$maxPage = ceil($countDataProducts/$rowsPerPage);
//get data
//$dataProductsFilters =& $productObject->getAllProductsFilters("p.productid,c.idchar",$wherestrFilter,"","","",$sortstrFilter);//get these for filters only
$dataProductsFilters =& $productObject->getAllProductsFilters("p.productid,c.idchar",$wherestrFilter,"","","","");//get these for filters only

if(!isset($_REQUEST["f_all"]) || $_REQUEST["f_all"]!="1"){
if(isset($_REQUEST["filterSubmit"]) && $_REQUEST["filterSubmit"]==PRIVATE_PAGE){
	
//printArray($_POST);
//printArray($dataProductsFilters);


  	//get all filters from list
      $countdataProductsFilter = count($dataProductsFilters);
      	$strIDS="";
      	$debugStr="";
      	$counterPostedFilters=0;
      	for($pp=0;$pp < $countdataProductsFilter;$pp++){ 
      		$encodedRequestedFilterID=SaveSingleVar::storeurl($dataProductsFilters[$pp]["idchar"]);
      		//print "f_".$encodedRequestedFilterID."<br>";
      		if(isset($_REQUEST["f_".$encodedRequestedFilterID]) && $_REQUEST["f_".$encodedRequestedFilterID]=="1"){
         		$strIDS.=$dataProductsFilters[$pp]["productid"].",";
         		$counterPostedFilters++;
                        $debugStr .="f_".$encodedRequestedFilterID."=".$_REQUEST["f_".$encodedRequestedFilterID]."\n";
      		}
                
      	}
      	//print "str=".$strIDS."---------";
      	if($strIDS!=""){
      	$strIDS=substr($strIDS,0,-1);
      	}

      	if($counterPostedFilters >0){
      		$wherestr .=" AND productid IN ($strIDS)";
      		$wherestrCount .=" AND productid IN ($strIDS)";
      	}
}
}
      	
$offset = ($pageNum - 1) * $rowsPerPage;
$dataProducts =& $productObject->getAllProducts("productid,categoryid,title,titleen,$teaserFinal,$subtitleFinal,topsection,image1,price,priceen,discount,stock,code,brand,$charsFinal",$wherestr,"$offset",$rowsPerPage,"",$sortstr);
$countDataProducts= $productObject->get_count_all($wherestrCount);
 // how many pages we have when using paging?
$maxPage = ceil($countDataProducts/$rowsPerPage);
//print "<!--".$countDataProducts."-->";
//print "<!--".$wherestr."-->";
//print "<!--".$maxPage."-->";
//print "<!--".$debugStr."-->";
//print "<!--".printArray($dataProducts)."-->";
}//end if $countDataProducts


//Find out if this category has subcategories ***************************** END	

}else{ // we do have subcategories from this category, show subs
	
//get subs
$dataCategories=array();
$dataCategories=$productCategoryObject->get_all("*","active='1' AND parent='$catID'","","","","sortorder ASC");	
$flasgDisplayCategories=true;

}

$pathStringCats="";
$pathCats=$productCategoryObject->_getCategoriesPath("category",$catID);
$pathCats=array_reversed($pathCats); //reverse the arrays
//printArray($pathCats);
$pathStringCats=implode(" &gt;",$pathCats);
//printArray($dataProducts);


?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>
-
</title>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
<? include_once("_css/css.php");?>
<? include_once("_inc/meta.php");?>
<? include_once("_js/js.php");?>
</head>
<body>
<div class="body_inside">
  <div id="header">
    <? include_once("_inc/login.php");?>
    <div class="head_ad">
      <? include_once("_inc/adheader.php");?>
    </div>
    <div id="navigation">
      <? include_once("_inc/navigation.php");?>
    </div>
    <!--end of navigation-->
  </div>
  <!--end of header-->
  <div id="content">
    <div class="content_inside">
      <div class="sidebar">
        <? include_once("_inc/sidebar.php");?>
      </div>
      <!--end of sidebar-->
      <div class="main_content">
        <? if($flasgDisplayCategories){ ?>
        <div class="breadcrumb"><a href="/home">
                    </a> &gt;           
          </div>
          
        <div class="cate_holder">
          <?  if(is_array($dataCategories) && count($dataCategories)>0){
                    	$countedCategories=count($dataCategories);
                    	for($cc=0;$cc < $countedCategories;$cc++){
                    		$urlCatTitleEnUrl=fix_cat_name_for_url($dataCategories[$cc]["titleen"]);
                    		$encodedCategoryIDList=SaveSingleVar::storeurl("c=".$dataCategories[$cc]["id"]);
                    		$titleList=stripslashes($dataCategories[$cc][$titleFinal]);
                    		$imageCategory="/_images/nophotolist.gif";
                    		if(isset($dataCategories[$cc]["filename"]) && @file_exists(UPLOAD_DIR."tnsc_".$dataCategories[$cc]["filename"])){
                    			$imageCategory=UPLOAD_DIR_SHOW."tnsc_".$dataCategories[$cc]["filename"];
                    		}
                    		$countItemProducts=$productObject->get_count_all("categoryid='".$dataCategories[$cc]["id"]."'");
                                $itemSubCategories =$productCategoryObject->get_count_all("active='1' AND parent='".$dataCategories[$cc]["id"]."'");
            	?>
          <div class="single_cate">
            <div class="cate_img"><a href="/category//"><img src="" alt="" border="0" /></a></div>
            <div class="cate_txt">
              <div class="cate_title">
                <a href="/category//"></a>
                <? if($itemSubCategories ==0){ ?><!--<span>()</span>--><? } ?></div>
              <p>
                              </p>
            </div>
               </div>
            <?  } 
                    
                    }?>
       
          <!--end of cate_holder-->
        </div>
      </div>
      <?  }else{
      	
      	   $pagingParams="";
      	   
      	   if(isset($_REQUEST["f_all"]) && $_REQUEST["f_all"]=="1"){$pagingParams.="f_all=1&";}
      	   //if(isset($_REQUEST["f_sort"]) && $_REQUEST["f_sort"]=="1"){$pagingParams.="f_sort=1&";}
		   if(isset($_REQUEST["orderprice"]) && $_REQUEST["orderprice"]!="1"){
                       $pagingParams.="orderprice=".cleanpost($_REQUEST["orderprice"])."&";}
                        	
      	   
      	$pathString="";
      /*	if($parentCategoryID!="0"){
      		$parentCategoryTitleUrl=fix_cat_name_for_url($parentCategoryTitle);
      		$encodedCategoryIDParent=SaveSingleVar::storeurl("c=".$parentCategoryID);
      		$pathString="&gt; <a href=\"/category/$encodedCategoryIDParent/$parentCategoryTitleUrl\">$parentCategoryTitle</a>";
      	}*/
      	
       
      	//get all filters from list
      $countdataProductsFilter = count($dataProductsFilters);
      	$strIDS="";
      	for($pp=0;$pp < $countdataProductsFilter;$pp++){ 
         		$strIDS.=$dataProductsFilters[$pp]["idchar"].",";
      	}
      	//print $strIDS."---------";
      	$strIDS=substr($strIDS,0,-1);
      	
      	$dataFilters=array();
      	$dataFilters=$productCharObject->get_all("*","id IN ($strIDS)");
      	
      	?>
      <div class="breadcrumb"><a href="/home">
                </a>
        &gt;           
        </div>
      <? if($categoryBody!=""){ ?>
          <p></p> <br />
          <? } ?>
      <? $countdataProducts = count($dataProducts);
      if($countdataProducts >0 ){
      ?>
        <form id="filterform" name="filterform" action="/category/T9XOHg/Power-Line-Cables?page=1" method="post">
      <div class="filter_box">
        <div class="filter_title">
                    :</div>
        <div class="filter">
          <input type="checkbox" id="f_all" name="f_all" value="1" />
          <label for="f_all">
                    </label>
        </div>
       <!-- <div class="filter">
          <input type="checkbox"  id="f_sort" name="f_sort" value="1"/>
          <label for="f_sort">
                    </label>
        </div>-->
        <div class="filter">
        <select name="orderprice" id="orderprice">
        <option value="f_desc" ></option>
        <option value="f_asc" ></option>        
        </select>          
        </div><div style="clear:both"></div>       
        <?    
     
        for($f=0;$f < count($dataFilters);$f++){
                        	$titleFilter=stripslashes($dataFilters[$f][$charsFinal]);
                        	$encodedFilterFieldID=SaveSingleVar::storeurl($dataFilters[$f]["id"]);
                        	if(isset($_REQUEST["f_".$encodedFilterFieldID]) && $_REQUEST["f_".$encodedFilterFieldID]=="1"){
                        		$selectedTitle .="$titleFilter, ";
                        		$pagingParams.="f_".$encodedFilterFieldID."=1&";
                        	}
                        	?>
        <div class="filter">
          <input type="checkbox" id="f_" name="f_" value="1"  onclick="javascript:$('input#f_all').attr('checked', false);"/>
          <label for="f_">
                    </label>
        </div>
        <?  }
       if(isset($_REQUEST["filterSubmit"]) && $_REQUEST["filterSubmit"]==PRIVATE_PAGE){
           $pagingParams .="filterSubmit=".PRIVATE_PAGE."&";
       }
       $pagingParams=substr($pagingParams,0,-1);
        ?>
        <div style="clear:both"></div> <br />
<br />
 <div style="text-align:center"><input name="submitFilter" id="submitFilter" type="submit" value="" /></div>
      </div><input type="hidden" id="filterSubmit" name="filterSubmit" value="