<?php include_once 'site-header.php';?>

<style>
    .sub-cat-style{
        font-family:arial !important;
    }
    
</style>
<?php
$cat_url=$_REQUEST['cat_url'];
if($cat_url=="")
{
    
   
   header("location: ". str_replace(".html","",$full_url));
}


$id=db_scalar("select category_id from tbl_category where category_url='$cat_url' ");
$res=mysqli_fetch_array(db_query("select * from  tbl_category where category_id='$id' "));




?>

      
      <div class="clearfix"></div>
      <!-- BREAADCRUMB SECTION -->
      <section class="my-breadcrumb parallex">
         <div class="container page-banner">
            <div class="row">
               <div class="col-sm-6 col-md-6">
                  <h1><?=str_replace("LOCATION",$locationName,$res['category_display_name'])?></h1>
               </div>
               <div class="col-sm-6 col-md-6">
                  <ol class="breadcrumb pull-right">
                     <li><a href="<?=$site_url?>">Home</a></li>
<?php
$p_id=db_scalar("select category_parent_id from tbl_category where category_id='$res[category_parent_id]' ");
if($p_id!=0)
{?>
<?php
if($loca_id!="")
{?>
<li><a href="<?=$site_url?>/<?=$loca_url?>/<?=db_scalar("select category_url from tbl_category where category_id='$p_id' ")?>.html"><?=db_scalar("select category_name from tbl_category where category_id='$p_id' ")?></a></li>
<?}else{?>
<li><a href="<?=$site_url?>/<?=db_scalar("select category_url from tbl_category where category_id='$p_id' ")?>.html"><?=db_scalar("select category_name from tbl_category where category_id='$p_id' ")?></a></li>
<?}?>
<?}?>

<?php
if($res['category_parent_id']!=0)
{?>
<?php
if($loca_id!="")
{?>
<li><a href="<?=$site_url?>/<?=$loca_url?>/<?=db_scalar("select category_url from tbl_category where category_id='$res[category_parent_id]' ")?>.html"><?=db_scalar("select category_name from tbl_category where category_id='$res[category_parent_id]' ")?></a></li>
<?}else{?>
<li><a href="<?=$site_url?>/<?=db_scalar("select category_url from tbl_category where category_id='$res[category_parent_id]' ")?>.html"><?=db_scalar("select category_name from tbl_category where category_id='$res[category_parent_id]' ")?></a></li>
<?}?>
<?}?>
                      
                     
                     
                     
                     
                     <li class="active"><?=$res['category_name']?></li>
                     
                  </ol>
               </div>
            </div>
         </div>
      </section>
      <section class="">
         <div class="container">
            <div class="row">
            <div class="heading-2 col-md-12">
            <h2><?=$res['category_name']?></h2>
            </div>
               <div class="col-md-12 col-sm-12 col-xs-12">
                   
<div class="col-md-5 col-sm-6 hidden-sm" style="float:right !important;">
<img src="<?=$site_url?>/uploaded_files/<?=$res['category_image_name']?>" class="wdt-img" alt="<?=$res['category_name']?>">
</div>  
              <? //=$res['category_description']?>
              <p style="font-family: Verdana,Geneva,sans-serif;"><?=str_replace("LOCATION",$locationName,$res['category_short_description'])?></p>
              <?=str_replace("LOCATION",$locationName,$res['category_description'])?>

<?php
$cat_sql1=db_query("select * from  tbl_category where category_status='Active' and category_parent_id='$res[category_id]' order by category_order_by asc");
$sub_cat_count=mysqli_num_rows($cat_sql1);

$half=ceil($sub_cat_count/2);

if($sub_cat_count>0)
{
?>
       <hr>
<h2><?=$res['category_name']?> Services</h2>

<table width="100%">
   <tr>
      <td>
<ul>
<?php

$cat_sql=db_query("select * from  tbl_category where category_status='Active' and category_parent_id='$res[category_id]' order by category_order_by asc limit 0, $half");

while($cat_res=mysqli_fetch_array($cat_sql))
{?>
<?php
if($loca_id!="")
{?>
<li><a class="sub-cat-style" href="<?=$site_url?>/<?=$loca_url?>/<?=$cat_res['category_url']?>.html" title="<?=$cat_res['category_name']?>"><i class="fa fa-angle-right"></i> <?=$cat_res['category_name']?></a></li>
<?}else{?>
<li><a class="sub-cat-style" href="<?=$site_url?>/<?=$cat_res['category_url']?>.html" title="<?=$cat_res['category_name']?>"><i class="fa fa-angle-right"></i> <?=$cat_res['category_name']?></a></li>
<?}?>

<?}?>

</ul>
</td>

<td>
<ul>
<?php

$cat_sql=db_query("select * from  tbl_category where category_status='Active' and category_parent_id='$res[category_id]' order by category_order_by asc limit $half, 999999");

while($cat_res=mysqli_fetch_array($cat_sql))
{?>
<?php
if($loca_id!="")
{?>
<li><a class="sub-cat-style" href="<?=$site_url?>/<?=$loca_url?>/<?=$cat_res['category_url']?>.html" title="<?=$cat_res['category_name']?>"><i class="fa fa-angle-right"></i> <?=$cat_res['category_name']?></a></li>
<?}else{?>
<li><a class="sub-cat-style" href="<?=$site_url?>/<?=$cat_res['category_url']?>.html" title="<?=$cat_res['category_name']?>"><i class="fa fa-angle-right"></i> <?=$cat_res['category_name']?></a></li>
<?}?>

<?}?>

</ul>
</td>


</tr>
</table>
<?}?>


</div>






<!--  <div class="col-md-5 col-sm-6 hidden-sm">
<img src="<?=$site_url?>/uploaded_files/<?=$res['category_image_name']?>" class="wdt-img" alt="<?=$res['category_name']?>">
</div>-->
            </div>
            
            
<?php
$loca_sql=db_query("select * from tbl_location where location_parent_id=0 and location_status='Active' order by location_id asc");
$count=mysqli_num_rows($loca_sql);
$count1=ceil($count/2);
$count2=ceil($count/2);

if($count>0)
{
?>       
<div class="row">
<hr>
<h2 style="font-weight:bold;"><?=$res['category_name']?> Services by Location</h2>    
<hr>
<div  class="col-md-6 col-sm-6 ">
    
    

      <ul class="list-group">
<?php
$loca_sql1=db_query("select * from tbl_location where location_parent_id=0 and location_status='Active' order by location_id asc limit 0, $count1");
while($loca_res1=mysqli_fetch_array($loca_sql1))
{?>

        <li class="list-group-item">
          <h3 >
            <a href="<?=$site_url?>/<?=$loca_res1['location_url']?>/<?=$res['category_url']?>.html"><b><?=$loca_res1['location_name']?></b></a>
          </h3>

          <ul class="list-group">
            <?php
$sub_loca_sql1=db_query("select * from tbl_location where location_parent_id='$loca_res1[location_id]' and location_status='Active' order by location_id asc ");
while($sub_loca_res1=mysqli_fetch_array($sub_loca_sql1))
{?>
            <li class="list-group-item">
              <h4>
                  <a href="<?=$site_url?>/<?=$sub_loca_res1['location_url']?>/<?=$res['category_url']?>.html">
              <?=$sub_loca_res1['location_name']?>
              </a>
              </h4>
            </li>
            <?}?>
            
          </ul>
        </li>
<?}?>
        
          
        
        
      </ul>
    
</div>


<div  class="col-md-6 col-sm-6 ">


      <ul class="list-group">
<?php
$loca_sql2=db_query("select * from tbl_location where location_parent_id=0 and location_status='Active' order by location_id asc limit $count1, $count2");
while($loca_res2=mysqli_fetch_array($loca_sql2))
{?>
    
    
        <li class="list-group-item">
          <h3>
            <a href="<?=$site_url?>/<?=$loca_res2['location_url']?>/<?=$res['category_url']?>.html"><b><?=$loca_res2['location_name']?></b></a>
          </h3>

          <ul class="list-group">
                                <?php
$sub_loca_sql2=db_query("select * from tbl_location where location_parent_id='$loca_res2[location_id]' and location_status='Active' order by location_id asc ");
while($sub_loca_res2=mysqli_fetch_array($sub_loca_sql2))
{?>

            <li class="list-group-item">
              <h4>
              <a href="<?=$site_url?>/<?=$sub_loca_res2['location_url']?>/<?=$res['category_url']?>.html"> <?=$sub_loca_res2['location_name']?></a>
              </h4>
            </li>
<?}?>
          </ul>
        </li>
<?}?>       

      </ul>
    
</div>


    
</div>
<?}?>

            
         </div>
      </section>


   
      
<?php include_once 'site-footer.php';?>