<?php
include_once("include/main.inc.php");
$homepage = mysqli_query($dbconn, "select * from static_pages where pageID='3' and status='Y'");
$home_res = mysqli_fetch_array($homepage);
@extract($_REQUEST);
$ca_nam1 = $_REQUEST['cid'];
$ca_nam1 = ucwords(str_replace("-", " ", $cid));

$page_metatitle = $home_res['page_metatitle'];
$page_metakey = $home_res['page_keyword'];
$page_metadesc = $home_res['page_metadesc'];
$query = "Select catID, catName, pageTitle, displayName,catImage,catDesc from category_tbl where parentID='1' and status='Y' ORDER BY catOrder";
$sqlTab = mysqli_query($dbconn, $query);

$query_sql = "Select catID, catName, pageTitle, displayName,catImage,catDesc from category_tbl where parentID='2' and status='Y' ORDER BY catOrder limit 0,6";
$sqlTab_res = mysqli_query($dbconn, $query_sql);

$hover = 'home';
$blog = mysqli_query($dbconn, "select * from blog_tbl  limit 0,3");

$sql_locas = mysqli_query($dbconn, "select * from location_tbl where locationName='$ca_nam1'");
if (mysqli_num_rows($sql_locas) > 0) {
} else {
    header("Location: " . site_url);
    exit;
}

?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title><?php echo str_replace('{location}', $ca_nam1, $home_res['page_metatitle']); ?></title>
    <meta name="description" content="<?php echo str_replace('{location}', $ca_nam1, $home_res['page_metadesc']); ?>">
    <meta name="keywords" content="<?php echo str_replace('{location}', $ca_nam1, $home_res['page_keyword']); ?>">
    <?php include "app_top.php"; ?>
    <style>
        .introduce_images{margin-right: 25px;}
    </style>
</head>

<body>
    <?php include "app_header_sub.php"; ?>
    <div class="clearfix"></div>
    <div class="home_slider">
        <div class="container">
            <div class="inner-bg-overlay"></div>
            <div class="row">
                <div class="sliderDetail col-xxl-6 col-xl-6 col-lg-6 col-md-6 col-sm-12 col-12 text-left wow fadeInLeft" data-wow-delay=".8s">
                    <?php

                    $sql_banner = mysqli_query($dbconn, "Select personName,bannerImage,bannerUrl,Decs from banner_tbl where status='Y' order by bannerorder Asc");
                    while ($res_banner = mysqli_fetch_array($sql_banner)) {
                    ?>
                        <div class="infoSlide">
                            <div class="sliderContent">
                                <div class="sliderTitle"><?php echo $res_banner['personName']; ?></div>
                                <p><?php echo $res_banner['Decs']; ?></p>
                                <a href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?php echo $res_banner['bannerUrl']; ?>.htm" class="read_more_1" title="Read More">Read More <span></span><span></span><span></span><span></span></a>
                            </div>
                        </div>
                    <?php } ?>

                </div>
                <div class="sliderImage col-xxl-6 col-xl-6 col-lg-6 col-md-6 col-sm-12  col-12 wow fadeInRight" data-wow-delay=".8s" data-depth="0.1">
                    <?php

                    $sql_banner1 = mysqli_query($dbconn, "Select personName,bannerImage from banner_tbl where status='Y' order by bannerorder Asc");
                    while ($res_banner1 = mysqli_fetch_array($sql_banner1)) {
                    ?>
                        <div class="imgSlide">
                            <img src="<?= site_url; ?>/uploaded-files/banner-image/<?= $res_banner1['bannerImage']; ?>" alt="<?php echo $res_banner1['personName']; ?> Manufacturers in <?= $ca_nam1; ?>" title="<?php echo $res_banner1['personName']; ?> Manufacturers in <?= $ca_nam1; ?>">
                        </div>
                    <?php } ?>
                </div>
            </div>

            <div class="sliderArrows">
                <a href="javascript:void(0);" class="sliderUp"><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                        <path fill-rule="evenodd" d="M8 15a.5.5 0 0 0 .5-.5V2.707l3.146 3.147a.5.5 0 0 0 .708-.708l-4-4a.5.5 0 0 0-.708 0l-4 4a.5.5 0 1 0 .708.708L7.5 2.707V14.5a.5.5 0 0 0 .5.5z" />
                    </svg></a>
                <a href="javascript:void(0);" class="sliderDown"><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                        <path fill-rule="evenodd" d="M8 1a.5.5 0 0 1 .5.5v11.793l3.146-3.147a.5.5 0 0 1 .708.708l-4 4a.5.5 0 0 1-.708 0l-4-4a.5.5 0 0 1 .708-.708L7.5 13.293V1.5A.5.5 0 0 1 8 1z" />
                    </svg></a>
            </div>
        </div>
    </div>

<div class="clearfix"></div>

    <section class="wps_introduce">
        <div class="container">
            <div class="row">
                <div class="col-xxl-12 col-xl-12 col-lg-12 col-md-12 col-sm-12  col-12">
                    <div class="introduce_content introduce_content_style_2">
                        <div class="introduce_images wow fadeInLeft" data-wow-delay=".1s">
                            <img src="<?= site_url; ?>/uploaded-files/page-images/<?= $home_res['pageImage']; ?>" alt="<?= $admin_res['companyName']; ?>" title="<?= $admin_res['companyName']; ?>">
                        </div>
                        <?php echo html_entity_decode(str_replace('{location}', $ca_nam1, $home_res['pageDesc'])); ?>
                        <a href="<?= site_url; ?>/about.htm" class="read_more_1 bg_btn_1" title="Read More">Read More <span></span><span></span><span></span><span></span></a>
                        <div class="clearfix"></div>
                         <div class="introduce_services">
                            <ul>
                                <li>
                                    <div class="background_color_1 wow zoomIn" data-wow-delay=".1s">
                                        <div class="icon"><img src="<?= theme_url; ?>/images/Top-Grade.png" alt="Top Grade Products" title="Top Grade Products"></div>
                                        <span>Top Grade Products</span>
                                    </div>
                                </li>
                                <li>
                                    <div class="background_color_2 wow zoomIn" data-wow-delay=".2s">
                                        <div class="icon"><img src="<?= theme_url; ?>/images/Skilled-Team.png" alt="Skilled Team" title="Skilled team"></div>
                                        <span>Skilled Team</span>
                                    </div>
                                </li>
                            
                                <li>
                                    <div class="background_color_3 wow zoomIn" data-wow-delay=".4s">
                                        <div class="icon"><img src="<?= theme_url; ?>/images/On-Time-Delivery.png" alt="On-Time Delivery" title="On-Time Delivery"></div>
                                        <span>On-time Delivery</span>
                                    </div>
                                </li>
                                <li>
                                    <div class="background_color_4 wow zoomIn" data-wow-delay=".3s">
                                        <div class="icon"><img src="<?= theme_url; ?>/images/Competitive-Price.png" alt="Competitive Pricing" title="Competitive Pricing"></div>
                                        <span>Competitive Pricing</span>
                                    </div>
                                </li>
                            </ul>
                        </div>
                    </div>

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

    <section class="webpulse_home_product">
        <div class="container">
            <h2 class="h2_title wow fadeInLeft" data-wow-delay=".1s">Top Kitchen Sinks Manufacturers in <?= $ca_nam1 ?></h2>

            <div class="row">
                <div class="col-xxl-12 col-xl-12 col-lg-12 col-md-12 col-sm-12  col-12">
                    <div class="home_service">
                        <?php while ($res_cat = mysqli_fetch_array($sqlTab)) { ?>
                            <div class="services_block wow fadeInDown" data-wow-delay=".2s">
                                <div class="services_margin">
                                    <figure><a href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= getValidFileName($res_cat['catName']); ?>.htm" title="<?php echo $res_cat['displayName']; ?> Manufacturers in <?= $ca_nam1; ?>">
                                            <div class="image"><img src="<?=site_url."/uploaded-files/category/images/".$res_cat['catImage']; ?>" alt="<?php echo $res_cat['displayName']; ?> Manufacturers in <?= $ca_nam1; ?>" title="<?php echo $res_cat['displayName']; ?> Manufacturers in <?= $ca_nam1; ?>"></div>
                                        </a>
                                        <figcaption><a href="<?= site_url; ?>/<?= getValidFileName($res_cat['catName']); ?>.htm" title="<?php echo $res_cat['displayName']; ?> Manufacturers in <?= $ca_nam1; ?>"><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                                                    <path d="M4.715 6.542 3.343 7.914a3 3 0 1 0 4.243 4.243l1.828-1.829A3 3 0 0 0 8.586 5.5L8 6.086a1.002 1.002 0 0 0-.154.199 2 2 0 0 1 .861 3.337L6.88 11.45a2 2 0 1 1-2.83-2.83l.793-.792a4.018 4.018 0 0 1-.128-1.287z" />
                                                    <path d="M6.586 4.672A3 3 0 0 0 7.414 9.5l.775-.776a2 2 0 0 1-.896-3.346L9.12 3.55a2 2 0 1 1 2.83 2.83l-.793.792c.112.42.155.855.128 1.287l1.372-1.372a3 3 0 1 0-4.243-4.243L6.586 4.672z" />
                                                </svg></a></figcaption>
                                    </figure>
                                    <div class="service_info">
                                        <h3 class="h3_title"><a href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= getValidFileName($res_cat['catName']); ?>.htm" title="<?php echo $res_cat['displayName']; ?> Manufacturers in <?= $ca_nam1; ?>"><?php echo $res_cat['displayName']; ?></a></h3>

                                        <div><?php
                                            $catIdss = $res_cat['catID'];

                                            $sql_content = mysqli_query($dbconn, "select * from location_content_tbl where category_id ='$catIdss'");
                                            $res_content = mysqli_fetch_array($sql_content);

                                            $subcontent_descc = $res_content['short_description'];
                                            $subcontent_desccc = str_replace('{location}', $ca_nam1, $subcontent_descc);
                                            $subcontent_descccc = str_replace('catname', $res_cat['catName'], $subcontent_desccc);
                                            echo html_entity_decode(substr($subcontent_descccc, 0, 150));
                                            ?>
                                            </div>
                                        <a href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= getValidFileName($res_cat['catName']); ?>.htm" class="read_more_1 bg_btn_1" title="Read More">Read More <span></span><span></span><span></span><span></span></a>
                                        <ul class="music-artist-network music-bgcolor">
                                            <li><a href="<?= site_url; ?>/<?= getValidFileName($res_cat['catName']); ?>.htm" title="Sinks">Sinks</a></li>
                                        </ul>
                                    </div>
                                </div>
                            </div>

                        <?php } ?>

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

    <div class="home_why_choose">
        <div class="row g-0">
            <div class="col-xxl-5 col-xl-5 col-lg-5 col-md-5 d-none d-xl-block wow fadeInLeft" data-wow-delay=".1s">
                <div class="whychooseus3-carousel h-100">
                    <img src="<?= theme_url; ?>/images/stainless-steel-ewc-with-s-s-cistern.jpg" alt="Stainless Steel ewc with s-s cistern Manufacturers in <?=$ca_nam1;?>" title="Stainless Steel ewc with s-s cistern Manufacturers in <?=$ca_nam1;?>">
                </div>
            </div>
            <div class="col-xxl-7 col-xl-7 col-lg-7 col-md-7 wow fadeInDown" data-wow-delay=".2s">
                <div class="whychooseus3" style="background-image: url(<?= theme_url; ?>/images/bg-06.jpg);">
                    <div class="row">
                        <div class="col-xl-10 col-xxl-9 col-lg-9 padding_50">
                            <div class="title_style2">
                                <span>Why Choose Us</span>
                                <h4 class="h2_title_2">Infrastructure & Facilities</h4>
                            </div>
                            <div>
                                <p>As a Manufacturer, Bluestar Sanitary Industries Private Limited is dedicated to providing better service to present and prospective clients through professional business communications, the best product solutions, and consistent quality to assure on-time product delivery at all times.</p>
                                <ul class="list-unstyled">
                                    <li><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                                            <path d="M3 14.5A1.5 1.5 0 0 1 1.5 13V3A1.5 1.5 0 0 1 3 1.5h8a.5.5 0 0 1 0 1H3a.5.5 0 0 0-.5.5v10a.5.5 0 0 0 .5.5h10a.5.5 0 0 0 .5-.5V8a.5.5 0 0 1 1 0v5a1.5 1.5 0 0 1-1.5 1.5H3z" />
                                            <path d="m8.354 10.354 7-7a.5.5 0 0 0-.708-.708L8 9.293 5.354 6.646a.5.5 0 1 0-.708.708l3 3a.5.5 0 0 0 .708 0z" />
                                        </svg> 10+ Years of Experience</li>
                                    <li><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                                            <path d="M3 14.5A1.5 1.5 0 0 1 1.5 13V3A1.5 1.5 0 0 1 3 1.5h8a.5.5 0 0 1 0 1H3a.5.5 0 0 0-.5.5v10a.5.5 0 0 0 .5.5h10a.5.5 0 0 0 .5-.5V8a.5.5 0 0 1 1 0v5a1.5 1.5 0 0 1-1.5 1.5H3z" />
                                            <path d="m8.354 10.354 7-7a.5.5 0 0 0-.708-.708L8 9.293 5.354 6.646a.5.5 0 1 0-.708.708l3 3a.5.5 0 0 0 .708 0z" />
                                        </svg> Effective Services</li>
                                    <li><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                                            <path d="M3 14.5A1.5 1.5 0 0 1 1.5 13V3A1.5 1.5 0 0 1 3 1.5h8a.5.5 0 0 1 0 1H3a.5.5 0 0 0-.5.5v10a.5.5 0 0 0 .5.5h10a.5.5 0 0 0 .5-.5V8a.5.5 0 0 1 1 0v5a1.5 1.5 0 0 1-1.5 1.5H3z" />
                                            <path d="m8.354 10.354 7-7a.5.5 0 0 0-.708-.708L8 9.293 5.354 6.646a.5.5 0 1 0-.708.708l3 3a.5.5 0 0 0 .708 0z" />
                                        </svg> Advanced Equipment</li>
                                    <li><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                                            <path d="M3 14.5A1.5 1.5 0 0 1 1.5 13V3A1.5 1.5 0 0 1 3 1.5h8a.5.5 0 0 1 0 1H3a.5.5 0 0 0-.5.5v10a.5.5 0 0 0 .5.5h10a.5.5 0 0 0 .5-.5V8a.5.5 0 0 1 1 0v5a1.5 1.5 0 0 1-1.5 1.5H3z" />
                                            <path d="m8.354 10.354 7-7a.5.5 0 0 0-.708-.708L8 9.293 5.354 6.646a.5.5 0 1 0-.708.708l3 3a.5.5 0 0 0 .708 0z" />
                                        </svg> Latest Technology</li>
                                    <li><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                                            <path d="M3 14.5A1.5 1.5 0 0 1 1.5 13V3A1.5 1.5 0 0 1 3 1.5h8a.5.5 0 0 1 0 1H3a.5.5 0 0 0-.5.5v10a.5.5 0 0 0 .5.5h10a.5.5 0 0 0 .5-.5V8a.5.5 0 0 1 1 0v5a1.5 1.5 0 0 1-1.5 1.5H3z" />
                                            <path d="m8.354 10.354 7-7a.5.5 0 0 0-.708-.708L8 9.293 5.354 6.646a.5.5 0 1 0-.708.708l3 3a.5.5 0 0 0 .708 0z" />
                                        </svg> Dedicated Teamwork</li>
                                    <li><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                                            <path d="M3 14.5A1.5 1.5 0 0 1 1.5 13V3A1.5 1.5 0 0 1 3 1.5h8a.5.5 0 0 1 0 1H3a.5.5 0 0 0-.5.5v10a.5.5 0 0 0 .5.5h10a.5.5 0 0 0 .5-.5V8a.5.5 0 0 1 1 0v5a1.5 1.5 0 0 1-1.5 1.5H3z" />
                                            <path d="m8.354 10.354 7-7a.5.5 0 0 0-.708-.708L8 9.293 5.354 6.646a.5.5 0 1 0-.708.708l3 3a.5.5 0 0 0 .708 0z" />
                                        </svg> Genuine Prices</li>
                                    <li><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                                            <path d="M3 14.5A1.5 1.5 0 0 1 1.5 13V3A1.5 1.5 0 0 1 3 1.5h8a.5.5 0 0 1 0 1H3a.5.5 0 0 0-.5.5v10a.5.5 0 0 0 .5.5h10a.5.5 0 0 0 .5-.5V8a.5.5 0 0 1 1 0v5a1.5 1.5 0 0 1-1.5 1.5H3z" />
                                            <path d="m8.354 10.354 7-7a.5.5 0 0 0-.708-.708L8 9.293 5.354 6.646a.5.5 0 1 0-.708.708l3 3a.5.5 0 0 0 .708 0z" />
                                        </svg> Quality Assurance</li>
                                </ul>
                                <a href="<?= site_url; ?>/about.htm" class="read_more_1 bg_btn_1" tabindex="0" title="Read More">Read More <span></span><span></span><span></span><span></span></a>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>





    <section class="home_serice_all">
        <div class="container">
            <h4 class="h2_title wow fadeInRight" data-wow-delay=".1s">Bathroom Fitting & Accessories</h4>
            <div class="row">
                <?php while ($res_sql = mysqli_fetch_array($sqlTab_res)) { ?>
                    <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-4 col-12 ">
                        <div class="service_inner_box wow zoomIn" data-wow-delay=".2s">
                            <div class="image">
                            <div class="imgCenter">
                                <img src="<?= getImage($res_sql['catImage'], 376, 376, $res_sql['catName'], "/uploaded-files/category/images/"); ?>" alt="<?php echo $res_sql['displayName']; ?> Manufacturers in <?= $ca_nam1; ?>" title="<?php echo $res_sql['displayName']; ?> Manufacturers in <?= $ca_nam1; ?>">

                            </div>
                             <div class="overlay-box">
                                    <div class="overlay-inner">
                                        <div class="content">
                                            <div class="text"><?php
                                                                $catIdss = $res_sql['catID'];

                                                                $sql_content = mysqli_query($dbconn, "select * from location_content_tbl where category_id ='$catIdss'");
                                                                $res_content = mysqli_fetch_array($sql_content);

                                                                $subcontent_descc = $res_content['short_description'];
                                                                $subcontent_desccc = str_replace('{location}', $ca_nam1, $subcontent_descc);
                                                                $subcontent_descccc = str_replace('catname', $res_cat['catName'], $subcontent_desccc);
                                                                echo html_entity_decode(substr($subcontent_descccc, 0, 100));
                                                                ?></div>
                                            <a href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= getValidFileName($res_sql['catName']); ?>.htm" class="read_more_1 bg_btn_1" tabindex="0" title="Read More">Read More <span></span><span></span><span></span><span></span></a>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="lower-box">
                                <div class="box-inner">
                                    <h4><a href="<?= site_url; ?>/<?= getValidFileName($ca_nam1); ?>/<?= getValidFileName($res_sql['catName']); ?>.htm" title="<?php echo $res_sql['displayName']; ?> Manufacturers in <?= $ca_nam1; ?>"><?php echo $res_sql['displayName']; ?></a></h4>
                                </div>
                            </div>
                        </div>
                    </div>
                <?php } ?>

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

    <!-- <?php include "app_testimonials.php"; ?> -->
    <!-- <?php include "app_clients.php"; ?> -->
    <!-- <?php include "app_faq.php"; ?> -->

    <!-- <section class="home_blog">
        <div class="container">
            <h3 class="h2_title wow fadeInDown" data-wow-delay=".1s">Latest News</h3>
            <div class="row">
                <?php while ($blog_res = mysqli_fetch_array($blog)) { ?>
                    <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-6 col-sm-6 col-12">
                        <div class="single-post2 wow fadeInLeft" data-wow-delay=".3s">
                            <div class="blog-thumb2">
                                <a href="<?= site_url; ?>/blog/<?= getValidFileName($blog_res['catName']); ?>.htm" title="<?php echo $blog_res['blogDname']; ?>"><img src="<?= getImage($blog_res['catImage'], 416, 416, $blog_res['catName'], "/uploaded-files/blog/images/"); ?>" alt="<?php echo $blog_res['blogDname']; ?>" title="<?php echo $blog_res['blogDname']; ?>"></a>
                            </div>
                            <div class="blog-content2">
                                
                                <h4 class="title_h5"><a href="<?= site_url; ?>/blog/<?= getValidFileName($blog_res['catName']); ?>.htm" title="<?php echo $blog_res['blogDname']; ?>"><span><?php echo $blog_res['blogDname']; ?></span></a></h4>
                               <?php echo html_entity_decode(substr($blog_res['catDesc1'], 0, 80)); ?>

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


    <?php include "app_footer_sub.php"; ?>
    <?php include "app_bottom.php"; ?>
</body>

</html>