<?php
include_once("include/main.inc.php");
$homepage = mysqli_query($dbconn, "select * from static_pages where pageID='1'");
$home_res = mysqli_fetch_array($homepage);
@extract($_REQUEST);
$admin_res = getAdminDetails();
$pg = "home";
$ca_nam1 = $_REQUEST['cid'];
$ca_nam1 = ucwords(str_replace("-", " ", $cid));
$loc_sql = mysqli_query($dbconn, "SELECT * FROM location_tbl where locationName='$ca_nam1'");
$location = mysqli_fetch_array($loc_sql);
$location_id = $location['parentID'];
$home_sub_specific = mysqli_query($dbconn, "select * from location_content_tbl where category_id='0' AND location_id='0'");
$home_sub_general = mysqli_query($dbconn, "select * from location_content_tbl where category_id='0' AND location_id='0'");
$content_count = mysqli_num_rows($home_sub_specific);
if ($content_count > 0) {
    $homesubdomain = mysqli_fetch_array($home_sub_specific);
    
$page_metatitle = str_replace('hotkeyword1',$homesubdomain[keyword1],str_replace('hotkeyword2', $homesubdomain[keyword2], str_replace('location', $ca_nam1, $homesubdomain['meta_title'])));

$page_metakey = str_replace('hotkeyword1',$homesubdomain[keyword1],str_replace('hotkeyword2', $homesubdomain[keyword2], str_replace('location', $ca_nam1, $homesubdomain['meta_keyword'])));

$page_metadesc = str_replace('hotkeyword1',$homesubdomain[keyword1],str_replace('hotkeyword2', $homesubdomain[keyword2],str_replace('companyname', $admin_res[companyName], str_replace('phone', $admin_res[phone], str_replace('location', $ca_nam1, $homesubdomain['meta_description'])))));

    //    content
    $page_contentdesc = $homesubdomain['description'];
    $page_short_desc = $homesubdomain['short_description'];

    //    specific location content
} else {
    $homesubdomain = mysql_fetch_array($home_sub_general);
    $page_metatitle = $homesubdomain['meta_title'];
    $page_metakey = $homesubdomain['meta_keyword'];
    $page_metadesc = $homesubdomain['meta_description'];
    $page_contentdesc = $homesubdomain['description'];
    $page_short_desc = $homesubdomain['short_description'];
    //    general content
}
$page_desc = str_replace('{location}', $ca_nam1, $page_contentdesc);
$page_short_desc = str_replace('{location}', $ca_nam1, $page_short_desc);
if (mysqli_num_rows($loc_sql) > 0) {
} else {
    header("Location: http://www.aarnasystems.in");
    exit;
}

$headingh1=explode(',',$page_metatitle);
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title><?php echo $page_metatitle; ?></title>
    <meta name="description" content="<?php echo $page_metadesc; ?>">
    <meta name="keywords" content="<?php echo $page_metakey; ?>">
    <?php include 'components/top_header.php';?>
</head>

<body>
    <div class="webpulse-main-wrapper">
        <?php include 'components/header_sub.php';?>

        <!-- Banner -->
        <div class="webpulse-home-slider slider">
            <div class="slick-slider-init">
                <?php $sql_banner=mysqli_query($dbconn,"Select * from banner_tbl where status='Y' ORDER BY bannerorder");
        while($result_banner=mysqli_fetch_array($sql_banner)){ 
             $link =  $result_banner['bannerUrl']!=null ? site_url."/".$result_banner['bannerUrl'] : "#" ;
            ?>
                <div>
                    <a href="<?=$link?>"
                        title="<?=$result_banner['personName'];?> Manufacturers in <?= $ca_nam1 ?>"><img
                            fetchpriority="high"
                            src="<?=site_url();?>/uploaded-files/banner-image/<?=$result_banner['bannerImage'];?>"
                            alt="<?=$result_banner['personName'];?> Manufacturers in <?= $ca_nam1 ?>"
                            title="<?=$result_banner['personName'];?> Manufacturers in <?= $ca_nam1 ?>">
                    </a>
                </div>
                <?php } ?>
            </div>
        </div>


        <div class="our-mission">
            <div class="container">
                <div class="mission-bg">
                    <div class="default-title center wow fadeInDown animated" data-wow-delay="300ms">
                        <span class="sec-head">We have been offering unparalled expertise to all our clients and
                            their<br>
                            <span>utmost satisfaction</span> is our <span>ultimate goal</span>.
                        </span>
                    </div>
                    <div class="content">
                        <div class="column center wow fadeInLeft animated" data-wow-delay="300ms">
                            <div class="icon-box">
                                <img src="<?=theme_url?>images/home/choose/3.png" alt="Latest Collection"
                                    title="Latest Collection">
                            </div>
                            <span class="fact-title">Latest Collection</span>
                            <p>Our modern range of densitometers such as ultrasound bone densitometer, Dexa Bone
                                Densitometer, and portable bone densitometer are widely used in the medical industry.
                            </p>
                        </div>

                        <div class="column center wow fadeInDown animated" data-wow-delay="300ms">
                            <div class="icon-box">
                                <img src="<?=theme_url?>images/home/choose/1.png" alt="Dedicated Customer Service"
                                    title="Dedicated Customer Service">
                            </div>
                            <span class="fact-title">Dedicated Customer Service</span>
                            <p>We are dedicated to providing the best customer support in order to achieve maximum
                                client satisfaction. </p>
                        </div>


                        <div class="column center wow fadeInDown animated" data-wow-delay="300ms">
                            <div class="icon-box">
                                <img src="<?=theme_url?>images/home/choose/2.png" alt="Experienced Professionals"
                                    title="Experienced Professionals">
                            </div>
                            <span class="fact-title">Experienced Professionals</span>
                            <p>We have a team of highly skilled professionals ensuring to deliver modern technology and
                                high durable products to our clients.</p>
                        </div>
                        <div class="column center wow fadeInRight animated" data-wow-delay="300ms">
                            <div class="icon-box">
                                <img src="<?=theme_url?>images/home/choose/11.png" alt="Cost effective Price"
                                    title="Cost effective Price">
                            </div>
                            <span class="fact-title">Cost effective Price</span>
                            <p>We provide our medical equipment like oxygen concentrators and Face Recognition
                                Temperature Measurement System at competitive market price. </p>
                        </div>
                    </div>
                </div>
            </div>
        </div>



        <section class="about-section">
            <div class="container">
                <div class="row">

                    <div class="col-lg-12">
                        <div class="about_img wow fadeInRight animated" data-wow-delay=".3s"
                            style="visibility: visible; animation-delay: 0.3s; animation-name: fadeInRight;">
                            <div class="img">
                                <img src="<?=theme_url?>images/about.jpg"
                                    alt="Portable Bone Density Scanner in <?= $ca_nam1 ?>"
                                    title="Portable Bone Density Scanner in <?= $ca_nam1 ?>">
                                <a class="play-btn" data-fancybox="" data-small-btn="true"
                                    href="https://www.youtube.com/watch?v=<?=$admin_res['company_video']?>"
                                    title="Portable Bone Density Scanner in <?= $ca_nam1 ?>">
                                    <i class="fa fa-play-circle" aria-hidden="true"></i>
                                </a>
                            </div>
                        </div>
                        <div class="sec-title">
                            <h1 class="about-title"><span>Portable Bone Density Scanner in <?= $ca_nam1 ?></span></h1>
                        </div>
                        <div class="text wow fadeInUp animated" data-wow-delay="300ms">
                            <?=$page_desc;?>
                        </div>

                        <div class="link-btn wow fadeInUp animated" data-wow-delay="600ms"><a
                                href="<?=site_url?>/about.htm" class="theme-btn btn-style-two"
                                title="More About Us"><span>More About Us</span></a></div>
                    </div>
                </div>
            </div>
        </section>

        <?php $popular = mysqli_query($dbconn,"select * from category_tbl where parentID!='0' and status='Y' limit 3" ); 
    if(mysqli_num_rows($popular)){?>
        <!--Project Section-->
        <section class="project-section">
            <div class="container">
                <div class="title center text-center wow fadeInDown animated" data-wow-delay="300ms">
                    <div class="sec-head">Purchase India's <span>First CDSCO Approved Ultrasound Bone Densitometer
                            CM-300</span>
                    </div>
                    <div class="separator separatorss"><span><i></i></span></div>
                </div>

                <div class="row clearfix">
                    <?php  while($popular_res=mysqli_fetch_array($popular)) { 
        $popular_image =  getImage($popular_res[catImage], 546, 548, $popular_res[catName],"/uploaded-files/category/images/")
    ?>
                    <div class="project-block col-md-4 col-sm-6 col-xs-12 wow fadeInLeft animated"
                        data-wow-delay="300ms">
                        <div class="inner-box">
                            <div class="image">
                                <img src="<?=$popular_image?>"
                                    alt="<?=$popular_res['displayName']?> Manufacturers in <?= $ca_nam1 ?>"
                                    title="<?=$popular_res['displayName']?> Manufacturers in <?= $ca_nam1 ?>">
                            </div>
                            <div class="overlay-box">
                                <div class="content">
                                    <h4 class="title-head"><?=$popular_res['displayName']?></h4>
                                    <a href="<?=site_url;?>/<?= getValidFileName($ca_nam1); ?>/<?=getValidFileName($popular_res['catName']);?>.htm"
                                        class="link-box" title="View More">View More <span
                                            class="fa fa-long-arrow-right"></span></a>
                                </div>
                            </div>
                        </div>
                    </div>
                    <?php } ?>
                </div>

            </div>
        </section>
        <?php  } ?>
        <div class="fact-counter style-1 sec-padd">
            <div class="container">
                <div class="title center wow fadeInDown animated" data-wow-delay="300ms">
                    <div class="sec-head">Company <span>Factsheet</span></div>
                    <p>Aarna specialises in modern technology offerings that match the growing needs of orthopaedic, and
                        pharmaceutical companies for the diagnostic medical imaging segment.</p>
                </div>
                <div class="clearfix"></div>
                <div class="counter-outer row">

                    <div class="column counter-column col-lg-4 col-md-6 col-sm-4 col-12 wow fadeInLeft animated"
                        data-wow-delay="300ms">
                        <div class="item">
                            <div class="count-outer">Nature of Business</div>
                            <span class="counter-title">Manufacturers, Suppliers, Exporters,<br> Importers,
                                Retailers, Service Provider</span>
                        </div>
                    </div>

                    <div class="column counter-column col-lg-4 col-md-6 col-sm-4 col-12 wow fadeInDown animated"
                        data-wow-delay="300ms">
                        <div class="item">
                            <div class="count-outer">Year of Establishment</div>
                            <span class="counter-title">2009</span>
                        </div>
                    </div>

                    <div class="column counter-column col-lg-4 col-md-6 col-sm-4 col-12 wow fadeInRight animated"
                        data-wow-delay="300ms">
                        <div class="item">
                            <div class="count-outer">Total Number of Employees</div>
                            <span class="counter-title">5 to 10 People</span>
                        </div>
                    </div>

                    <div class="column counter-column col-lg-4 col-md-6 col-sm-4 col-12 wow fadeInLeft animated"
                        data-wow-delay="300ms">
                        <div class="item">
                            <div class="count-outer">Legal Status of Firm</div>
                            <span class="counter-title">Limited Company (Ltd./Pvt.Ltd.)</span>
                        </div>
                    </div>

                    <div class="column counter-column col-lg-4 col-md-6 col-sm-4 col-12 wow fadeInUp animated"
                        data-wow-delay="300ms">
                        <div class="item">
                            <div class="count-outer">Annual Turnover</div>
                            <span class="counter-title">Rs. 5 - 10 Crore</span>
                        </div>
                    </div>

                    <div class="column counter-column col-lg-4 col-md-6 col-sm-4 col-12 wow fadeInRight animated"
                        data-wow-delay="300ms">
                        <div class="item">
                            <div class="count-outer">GST Number</div>
                            <span class="counter-title">08AAOCA8087C1ZD</span>
                        </div>
                    </div>

                </div>
                <div class="clearfix"></div>
            </div>
        </div>
        <div class="clearfix"></div>
        <?php $popular1 = mysqli_query($dbconn,"select * from category_tbl where parentID!='0' and status='Y' limit 4" ); 
    if(mysqli_num_rows($popular1)){?>
        <section class="webpulse_home_featured">
            <div class="container">
                <div class="row">
                    <div class="col-lg-12">
                        <div class="products_heading wow fadeInDown animated animated" data-wow-delay=".1s"
                            style="visibility: visible; animation-delay: 0.1s; animation-name: fadeInDown;">
                            <div class="sec-head">Featured Products</div>
                            <div class="separator separatorss"><span><i></i></span></div>
                        </div>
                    </div>
                </div>
                <div class="clearfix"></div>

                <div class="row">
                    <?php  while($popular1_res=mysqli_fetch_array($popular1)) { 
                                    $popular1_image =  getImage($popular1_res[catImage], 255, 330, $popular1_res[catName],"/uploaded-files/category/images/")
                                ?>
                    <div class="col-lg-3 col-md-6 wow fadeInDown animated animated" data-wow-delay=".2s"
                        style="visibility: visible; animation-delay: 0.2s; animation-name: fadeInDown;">
                        <div class="single-project-item">
                            <div class="img-holder">
                                <img src="<?=$popular1_image?>"
                                    title="<?=$popular1_res['displayName']?> Manufacturers in <?= $ca_nam1 ?>"
                                    alt="<?=$popular1_res['displayName']?> Manufacturers in <?= $ca_nam1 ?>">
                                <div class="inner-content">
                                    <span class="product-title"><a
                                            href="<?=site_url;?>/<?= getValidFileName($ca_nam1); ?>/<?=getValidFileName($popular1_res['catName']);?>.htm"
                                            title="<?=$popular1_res['displayName']?> Manufacturers in <?= $ca_nam1 ?>"><?=$popular1_res['displayName']?></a></span>
                                </div>
                                <div class="overlay-style-one">
                                    <div class="box">
                                        <div class="content">
                                            <h4 class="title-head"><a
                                                    href="<?=site_url;?>/<?= getValidFileName($ca_nam1); ?>/<?=getValidFileName($popular1_res['catName']);?>.htm"
                                                    title="<?=$popular1_res['displayName']?> Manufacturers in <?= $ca_nam1 ?>"><?=$popular1_res['displayName']?></a>
                                            </h4>
                                            <div class="bottom-text">
                                                <!-- <p><?=substr($popular1_res['catDesc1'],0,150);?>...</p> -->
                                                <a href="<?=site_url;?>/<?= getValidFileName($ca_nam1); ?>/<?=getValidFileName($popular1_res['catName']);?>.htm"
                                                    class="btn btn-style" title="View More">View More <span
                                                        class="fa fa-long-arrow-right ml-2"></span></a>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <?php  } ?>
                </div>

            </div>
        </section>
        <?php  } ?>
        <div class="clearfix"></div>
        <?php 
$sql_blog=mysqli_query($dbconn,"select * from blog_tbl limit 2"); 
if(mysqli_num_rows($sql_blog)>0)   {                 
    ?>
        <section class="home_blog bg-grey ptb-50">
            <div class="container">
                <div class="products_heading wow fadeInDown animated" data-wow-delay=".1s">
                    <div class="sec-head">Latest News</div>
                    <div class="separator separatorss"><span><i></i></span></div>
                </div>
                <div class="clearfix"></div>

                <div class="row">
                    <?php 
            while($res_blog=mysqli_fetch_array($sql_blog)) { 
    $blogimg = getImage($res_blog[catImage], 546, 411, $res_blog[catName],"/uploaded-files/blog/images/")
    ?> <div class="col-xxl-6 col-xl-6 col-lg-6 col-md-6 col-12 col-xs-12">
                        <div class="single-post2 wow fadeInLeft animated" data-wow-delay=".3s"
                            style="visibility: visible; animation-delay: 0.3s; animation-name: fadeInLeft;">
                            <div class="blog-thumb2">
                                <a href="<?=site_url;?>/blog/<?=getValidFileName($res_blog['catName']);?>.htm"><img
                                        src="<?=$blogimg?>" class="w-100" alt="<?=$res_blog['blogDname'];?>"
                                        title="<?=$res_blog['blogDname'];?>"></a>
                            </div>
                            <div class="blog-content2">
                                <div class="b-meta">
                                    <div class="meta-info">
                                        <ul>
                                            <li><i
                                                    class="fa fa-calendar"></i><?=date('d M Y',strtotime($res_blog['blogDate']))?>
                                            </li>

                                        </ul>
                                    </div>
                                </div>
                                <h5 class="blog-title"><a
                                        href="<?=site_url;?>/blog/<?=getValidFileName($res_blog['catName']);?>.htm"
                                        title="<?=$res_blog['blogDname'];?>"><span>
                                            <?=$res_blog['blogDname'];?></span></a></h5>
                                <p></p>
                                <a href="<?=site_url;?>/blog/<?=getValidFileName($res_blog['catName']);?>.htm"
                                    class="read-more-link" title="View More">View More</a>

                            </div>
                        </div>
                    </div>
                    <?php } ?>

                </div>
            </div>
        </section>
        <?php  } ?>





        <!-- Footer -->
        <?php include 'components/app_testi_client.php';?>
        <?php include 'components/footer_sub.php';?>
    </div>
    <?php include 'components/bottom_footer.php';?>
</body>

</html>