<?php

class CategoryBoard{
   
    function alias( $category_alias="", $geo_alias="" ){

       if( $geo_alias ){
           return _link($geo_alias."/".$category_alias);
       }else{
           if($_SESSION["geo"]["alias"]){
              return _link($_SESSION["geo"]["alias"]."/".$category_alias);
           }else{
              return _link($category_alias); 
           }
       }
 
    }

    function allMain(){

       $ULang = new ULang();
       
       $getCategories = $this->getCategories("where category_board_visible=1");

       if($getCategories["category_board_id_parent"][0]){
           foreach ($getCategories["category_board_id_parent"][0] as $key => $value) {
              $out[] = $ULang->t($value["category_board_name"] , [ "table" => "uni_category_board", "field" => "category_board_name" ] );
           }
         return implode(",", $out);
       }

    }

    function getCategories($query = ""){
        global $settings;
        
        $array = array();

        $Cache = new Cache();

        if( $Cache->get( [ "table" => "uni_category_board", "key" => $query ] ) ){
           
           return $Cache->get( [ "table" => "uni_category_board", "key" => $query ] );

        }else{
           
           $get = getAll("SELECT * FROM uni_category_board $query ORDER By category_board_id_position ASC");
           if (count($get)) { 
          
                foreach($get AS $result){

                    if($result['category_board_id_parent']){
                      $result['category_board_chain'] = $this->aliasBuild($result['category_board_id']);
                    }else{
                      $result['category_board_chain'] = $result['category_board_alias'];
                    }
                    
                    $array['category_board_chain'][$result['category_board_chain']] = $result;
                    $array['category_board_id_parent'][$result['category_board_id_parent']][$result['category_board_id']] =  $result;
                    $array['category_board_id'][$result['category_board_id']]['category_board_id_parent'] =  $result['category_board_id_parent'];
                    $array['category_board_id'][$result['category_board_id']]['category_board_name'] =  $result['category_board_name'];
                    $array['category_board_id'][$result['category_board_id']]['category_board_title'] =  $result['category_board_title'];
                    $array['category_board_id'][$result['category_board_id']]['category_board_description'] =  $result['category_board_description'];
                    $array['category_board_id'][$result['category_board_id']]['category_board_image'] =  $result['category_board_image'];
                    $array['category_board_id'][$result['category_board_id']]['category_board_text'] =  $result['category_board_text'];
                    $array['category_board_id'][$result['category_board_id']]['category_board_alias'] =  $result['category_board_alias'];
                    $array['category_board_id'][$result['category_board_id']]['category_board_id'] =  $result['category_board_id'];  
                    $array['category_board_id'][$result['category_board_id']]['category_board_chain'] =  $result['category_board_chain'];  
                    $array['category_board_id'][$result['category_board_id']]['category_board_price'] =  $result['category_board_price'];
                    $array['category_board_id'][$result['category_board_id']]['category_board_count_free'] =  $result['category_board_count_free'];          
                    $array['category_board_id'][$result['category_board_id']]['category_board_status_paid'] =  $result['category_board_status_paid'];          
                    $array['category_board_id'][$result['category_board_id']]['category_board_display_price'] =  $result['category_board_display_price'];
                    $array['category_board_id'][$result['category_board_id']]['category_board_variant_price'] =  $result['category_board_variant_price'];
                    $array['category_board_id'][$result['category_board_id']]['category_board_measure_price'] =  $result['category_board_measure_price'];

                    if($settings["functionality"]["secure"]){
                       $array['category_board_id'][$result['category_board_id']]['category_board_secure'] =  $result['category_board_secure'];
                    }else{
                       $array['category_board_id'][$result['category_board_id']]['category_board_secure'] =  0;
                    }

                    if($settings["functionality"]["auction"]){
                       $array['category_board_id'][$result['category_board_id']]['category_board_auction'] =  $result['category_board_auction'];
                    }else{
                       $array['category_board_id'][$result['category_board_id']]['category_board_auction'] =  0;
                    }

                                            
                }  

                $Cache->set( [ "table" => "uni_category_board", "key" => $query, "data" => $array ] );

           }            

           return $array;

        }
      
    }

    function aliasBuild($id = 0){

      $get = getOne("SELECT * FROM uni_category_board where category_board_id=?", array($id));
      
        if($get['category_board_id_parent']!=0){ 
            $out .= $this->aliasBuild($get['category_board_id_parent'])."/";            
        }
        $out .= $get['category_board_alias'];

        return $out; 
               
    }

    function outParent( $getCategories = [], $param = [] ){
      global $config;

      $Ads = new Ads();
      $ULang = new ULang();

      if( $Ads->queryGeo() ){
         $queryGeo = " and " . $Ads->queryGeo();
      }

      if($param["category"]["category_board_id"]){

        if (isset($getCategories["category_board_id_parent"][$param["category"]["category_board_id"]])) {
            foreach ($getCategories["category_board_id_parent"][$param["category"]["category_board_id"]] as $parent_value) {

			$parent[] = replace(array(
				"{PARENT_LINK}",
				"{PARENT_IMAGE}",
				"{PARENT_NAME}",
				"{COUNT_AD}"
			),
			array(
				$this->alias($parent_value["category_board_chain"]),
				Exists($config["media"]["other"],
				$parent_value["category_board_image"],
				$config["media"]["no_image"]),
				$ULang->t(
					$parent_value["category_board_name"],
					[ 
						"table" => "uni_category_board",
						"field" => "category_board_name"
					]),
				$countAd
			),
			$param["tpl_parent"]
			);

               $return .=  replace(array("{PARENT_CATEGORY}"),array(implode($param["sep"],$parent)),$param["tpl"]);
               $parent = array();

            }
        }else{

          $id_parent = $getCategories["category_board_id"][$param["category"]["category_board_id_parent"]];

          if(isset($getCategories["category_board_id_parent"][$id_parent["category_board_id"]])){
            foreach ($getCategories["category_board_id_parent"][$id_parent["category_board_id"]] as $parent_value) {

              if($parent_value["category_board_id"] == $param["category"]["category_board_id"]){
                $active = 'class="active"';
              }else{
                $active = '';
              }

              
               $parent[] = replace(array(
				   "{PARENT_LINK}",
				   "{PARENT_IMAGE}",
				   "{PARENT_NAME}",
				   "{ACTIVE}",
				   "{COUNT_AD}
			   "),
			   array(
				$this->alias($parent_value["category_board_chain"]),
				Exists($config["media"]["other"],$parent_value["category_board_image"],$config["media"]["no_image"]),
				$ULang->t(
					$parent_value["category_board_name"],
					[
						"table" => "uni_category_board",
						"field" => "category_board_name"
					] ),
				$active,
				$countAd
				),
			   $param["tpl_parent"]);

               $return .=  replace(array("{PARENT_CATEGORY}"),array(implode($param["sep"],$parent)),$param["tpl"]);
               $parent = array();

            }
          }
        }                 
       return $return;

      }

    }

    function outMainCategory($tpl, $tpl_parent = "", $sep = ""){

      $getCategories = (new CategoryBoard())->getCategories("where category_board_visible=1");  
      $Ads = new Ads(); 
      $ULang = new ULang();

      $return = "";
      $parent = array();
        if (isset($getCategories["category_board_id_parent"][0])) {
            foreach ($getCategories["category_board_id_parent"][0] as $value) {
              
               if($getCategories["category_board_id_parent"][$value["category_board_id"]] && $tpl_parent){
                 foreach (array_slice($getCategories["category_board_id_parent"][$value["category_board_id"]], 0, 6) as $parent_value) {
					$parent[] = replace(
						array(
							"{PARENT_LINK}",
							"{PARENT_IMAGE}",
							"{PARENT_NAME}",
							"{COUNT_AD_MAIN}",
							"{COUNT_AD_PARENT}"
						),
						array(
							$this->alias($parent_value["category_board_chain"]),
							Exists(
								$image_category,
								$value["category_board_id"],
								$parent_value["category_board_image"],
								$no_image
							),
							$ULang->t(
								$parent_value["category_board_name"],
								[
									"table" => "uni_category_board",
									"field" => "category_board_name"
								],
							)
						),
						$tpl_parent
					);
                 }
               }
           
            $return .=  replace(
			array(
				"{LINK}",
				"{IMAGE}",
				"{NAME}",
				"{COUNT_AD_MAIN}",
				"{PARENT_CATEGORY}",
				"{COUNT_AD_PARENT}"
			),
			array(
				$this->alias($value["category_board_alias"]),
				Exists(
					$image_category,
					$value["category_board_image"],
					$no_image
				),
				$ULang->t(
					$value["category_board_name"],
					[
						"table" => "uni_category_board",
						"field" => "category_board_name"
					]
				),
				implode($sep,$parent)
			),
			$tpl
			);
            $parent = array();
            }
        }                 
      return $return;
    }

    function idsBuild($parent_id=0, $categories = []){
        
        if(isset($categories['category_board_id_parent'][$parent_id])){

              foreach($categories['category_board_id_parent'][$parent_id] as $cat){
                       
                $ids[] = $cat['category_board_id'];
                
                if( $categories['category_board_id_parent'][$cat['category_board_id']] ){
                  $ids[] = $this->idsBuild($cat['category_board_id'],$categories);
                }
                                            
              }

        }
        
        return implode(",", $ids);

    }
    

   function viewCategory($id=0){
    if(detectRobots($_SERVER['HTTP_USER_AGENT']) == false){
      if($id){    
          if(!isset($_SESSION["view-category-ads"][$id])){
            update("UPDATE uni_category_board SET category_board_count_view=category_board_count_view+1,category_board_datetime_view=? WHERE category_board_id=?", array(date("Y-m-d H:i:s"),$id)); 
            $_SESSION["view-category-ads"][$id] = 1;
          }  
      } 
    }   
   }

    function breadcrumb($getCategories=array(),$id=0,$tpl="",$sep=""){

      $ULang = new ULang();

      if($getCategories){

        if($getCategories["category_board_id"][$id]['category_board_id_parent']!=0){
            $return[] = $this->breadcrumb($getCategories,$getCategories["category_board_id"][$id]['category_board_id_parent'],$tpl,$sep);  
        }

        $return[] = replace(array("{LINK}", "{NAME}"),array($this->alias($getCategories["category_board_id"][$id]["category_board_chain"]),$ULang->t($getCategories["category_board_id"][$id]['category_board_name'] , [ "table" => "uni_category_board", "field" => "category_board_name" ] )),$tpl);

        return implode($sep,$return);

      } 
               
    }
    
    
}


?>