<?php include("site-header.php"); ?>
<?php

$cat_url=$_REQUEST['cat_url'];
if($cat_url=="")
{
   
   header("location: $site/error.html");
}


$cat_url=$_REQUEST['cat_url'];
$cat_stmt=my_prepared("select category_id from tbl_category where category_url=? ");
mysqli_stmt_bind_param($cat_stmt, 's', $cat_url);
mysqli_stmt_execute($cat_stmt);
$cat_stmt_res=mysqli_stmt_get_result($cat_stmt);
$CAT_DATA=mysqli_fetch_array($cat_stmt_res);
$cat_id=$CAT_DATA['category_id'];

//$cat_id=db_scalar("select category_id from tbl_category where category_url='$cat_url' ");
$cat_res=mysqli_fetch_array(db_query("select * from tbl_category where category_id='$cat_id' "));


?>

            <section>
                <div class="w-100 pt-60 position-relative">
                    <div class="fixed-bg" style="background-image: url(<?=$site_url?>/assets/images/bg10.jpg);"></div>
                    <div class="container">
                        <div class="page-title-wrap text-center w-100 d-inline-block">
                            <div class="page-title-inner d-inline-block">
                                <h2 class="mb-0 text-color7"><?=str_replace("LOCATION",$locationName,$cat_res['category_display_name'])?></h2>
                            </div>
                            <div class="breadcrumbs-wrap w-100">
                                <ul class="breadcrumbs mb-0 list-unstyled d-inline-flex">
                                    <li><a href="<?=$site_url?>" title="Home">Home</a></li>
                                    <li><a href="<?=$site_url?>/services.html" title="Services">Services</a></li>
                                    <li class="active"><?=$cat_res['category_name']?></li>
                                </ul><!-- Breadcrumbs -->
                            </div>
                        </div><!-- Page Title Wrap -->
                    </div>
                </div>
            </section>
            <section>
                <div class="w-100 pt-100">
                    <div class="container">
                        <div class="prod-detail-wrap w-100 d-flex flex-wrap align-items-center">
                            <div class="prod-detail-img brd-rd20 overflow-hidden">
                                <img class="img-fluid w-100" src="<?=$site_url?>/uploaded_files/<?=$cat_res['category_image_name']?>" alt="<?=str_replace("LOCATION",$locationName,$cat_res['category_image_alt_title'])?>" title="<?=str_replace("LOCATION",$locationName,$cat_res['category_image_alt_title'])?>">
                            </div>
                            <div class="prod-detail-info">
                                <h2 class="mb-0"><?=str_replace("LOCATION",$locationName,$cat_res['category_display_name'])?></h2>
                              
                                <p class="mb-0"><?//=$cat_res['category_short_description']?>
                                 <?=str_replace("LOCATION",$locationName,$cat_res['category_short_description'])?>
                                </p>
                                
                            </div>
                        </div>
                        <div class="prod-detail-tabs mt-20 w-100">
                            <ul class="nav nav-tabs">
                                <li class="nav-item"><a class="nav-link active" data-toggle="tab" href="#description">Description</a></li>
                            </ul>
                            <div class="tab-content bg-gray">
                                <div class="tab-pane fade show active" id="description">
                                 <?//=$cat_res['category_description']?>
                                 
                                 <?=str_replace("LOCATION",$locationName,$cat_res['category_description'])?>
                                </div>
                                
                            </div>
                        </div>
                        
                    </div>
                </div>
            </section>

<?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)
{


?>

 <section>
                <div class="w-100 pb-90 bg-color10">
                    <div class="container-fluid">
                        <hr class="devider mb-90 w-100">
                        <div class="container">
                            <div class="row">
                               <div class="service-wrap8 position-relative w-100">
                            <h2 class="mb-0"><?=$cat_res['category_name']?> Services by Location</h2>
                            <br>
                            <br>
                            
                        </div>
     <div class="col-md-12 col-sm-12 col-lg-6">
                                    <div class="content-wrap w-100">
                                        <div class="toggle2 w-100 " id="toggle2">


<?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))
{?>
                           
                                          
                                            <div class="toggle-item2 w-100" style="display: none;">
                                                <h4 class="mb-0"><i class="metaicon-add"></i> </h4>                                                
                                            </div>


                                            <div class="toggle-item2 w-100">
                                                <h4 class="mb-0"><i class="metaicon-add"></i> <?=$loca_res1['location_name']?></h4>
                                                <div class="toggle-content2 w-100">
                                                      <div class="service-wrap8 position-relative w-100">
                            <div class="service-inner w-100">
                                <div class="row">
                                    
<div class="col-md-12 col-sm-12 col-lg-12">
<div class="service-box8 mt-10 overflow-hidden">
<a class="d-block" href="<?=$site_url?>/<?=$loca_res1['location_url']?>/<?=$cat_res['category_url']?>.html" title="<?=$loca_res1['location_name']?>"><?=$loca_res1['location_name']?></a>
</div>
</div>

<?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))
{
?>

                                    <div class="col-md-12 col-sm-12 col-lg-12">
                                        <div class="service-box8 mt-10 overflow-hidden">
                                            <a class="d-block" href="<?=$site_url?>/<?=$sub_loca_res1['location_url']?>/<?=$cat_res['category_url']?>.html" title="<?=$sub_loca_res1['location_name']?>"><?=$sub_loca_res1['location_name']?></a>
                                        </div>
                                    </div>
                                    
                                    
<?}?>


                                    
                                </div>
                            </div>
                        </div><!-- Service Wrap 8 -->
                     </div>
               </div>




 

<?}?>

                                        </div>
                                    </div>
                                </div>



       <div class="col-md-12 col-sm-12 col-lg-6">
                                    <div class="content-wrap w-100">
                                        <div class="toggle2 w-100" id="toggle2">


<?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))
{?>
                         

                                          
                                            <div class="toggle-item2 w-100" style="display: none;">
                                                <h4 class="mb-0"><i class="metaicon-add"></i> </h4>                                                
                                            </div>


                                            <div class="toggle-item2 w-100">
                                                <h4 class="mb-0"><i class="metaicon-add"></i> <?=$loca_res2['location_name']?></h4>
                                                <div class="toggle-content2 w-100">
                                                      <div class="service-wrap8 position-relative w-100">
                            <div class="service-inner w-100">
                                <div class="row">
                                    
<div class="col-md-12 col-sm-12 col-lg-12">
<div class="service-box8 mt-10 overflow-hidden">
<a class="d-block" href="<?=$site_url?>/<?=$loca_res2['location_url']?>/<?=$cat_res['category_url']?>.html" title="<?=$loca_res2['location_name']?>"><?=$loca_res2['location_name']?></a>
</div>
</div>

                                   <?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))
{
?>

                                    <div class="col-md-12 col-sm-12 col-lg-12">
                                        <div class="service-box8 mt-10 overflow-hidden">
                                            <a class="d-block" href="<?=$site_url?>/<?=$sub_loca_res2['location_url']?>/<?=$cat_res['category_url']?>.html" title="<?=$sub_loca_res2['location_name']?>"><?=$sub_loca_res2['location_name']?></a>
                                        </div>
                                    </div>
<?}?>

                                    
                                </div>
                            </div>
                        </div><!-- Service Wrap 8 -->
                     </div>
               </div>


<?}?>

 
                                        </div>
                                    </div>
                                </div>





                              
                                 





                                
                            </div>
                        </div>
                    </div>
                </div>
            </section>

<?}?>


  <?php

$sub_sql=db_query("select * from tbl_category where category_status='Active' and category_parent_id='$cat_id'  ");
if(mysqli_num_rows($sub_sql)>0)
    { ?>

            <section>
                <div class="pt-60 pb-100 w-100 ">
                    <div class="container">
                        <div class="related-wrap w-100">
                            <h2 class="mb-0"><?=$cat_res['category_name']?> Services</h2>
                            <div class="related-inner w-100">
                                <div class="row">

<?php
while($sub_res=mysqli_fetch_array($sub_sql))
    {?>
                                   
                                    <div class="col-md-4 col-sm-6 col-lg-3">
                                        <div class="prod-box mt-45 text-center w-100">
                                            <div class="prod-img brd-rd20 w-100 overflow-hidden position-relative">
                                               
                                                <img class="img-fluid w-100" src="<?=$site_url?>/uploaded_files/<?=$sub_res['category_image_name']?>" alt="<?=str_replace("LOCATION",$locationName,$sub_res['category_image_alt_title'])?>" title="<?=str_replace("LOCATION",$locationName,$sub_res['category_image_alt_title'])?>">
                                     
                                            </div>
                                            <div class="prod-info w-100">
                                                <h3 class="mb-0"><a href="<?=$site_url?>/<?=$sub_res['category_url']?>.html" title="<?=str_replace("LOCATION",$locationName,$sub_res['category_image_alt_title'])?>"><?=$sub_res['category_name']?></a></h3>
                                            </div>
                                        </div>
                                    </div>
<?}?>



                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </section>

<?php }?>

           <?php include("site-footer.php"); ?>