<?php
include('include/main.inc.php');
$actual_links = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? "https" : "http") . "://{$_SERVER['HTTP_HOST']}{$_SERVER['REQUEST_URI']}";
$ex_cat = explode("/", $actual_links);
$loc_url = $ex_cat[3];
$locat = str_ireplace("-", " ", $loc_url);
$location_name = ucwords($locat);
$sel_loca_query = "Select * from location_tbl where locationName = '$location_name'";
$res_loca = $dbconn->query($sel_loca_query);
if ($res_loca->num_rows == 0) {
    header('location:' . site_url);
}
$locatios = $res_loca->fetch_assoc();
$location_id = $locatios['locationID'];

$description = '';
$short_description = '';
$sel_homesub_query = "select * from location_content_tbl where category_id = 0";
$res_homesub = $dbconn->query($sel_homesub_query);
if ($res_homesub->num_rows > 0) {
    while ($homesub_details = $res_homesub->fetch_assoc()) {
        $locat = explode(",", $homesub_details['location_ids']);
        if (in_array($location_id, $locat)) {
            if ($homesub_details['meta_title'] != '') {
                $page_metatitle = $homesub_details['meta_title'];
            }
            if ($homesub_details['meta_keyword'] != '') {
                $page_metakey = $homesub_details['meta_keyword'];
            }
            if ($homesub_details['meta_description'] != '') {
                $page_metadesc = $homesub_details['meta_description'];
            }
            $description = $homesub_details['description'];
        }
    }
}

$sel_home_query = "select * from static_pages where pageID ='1'";
$res_home = $dbconn->query($sel_home_query);
$home_details = $res_home->fetch_assoc();

$sel_about_query = "select * from static_pages where pageID ='2'";
$res_about = $dbconn->query($sel_about_query);
$about_details = $res_about->fetch_assoc();

$sel_about1_query = "select * from static_pages where pageID ='3'";
$res_about1 = $dbconn->query($sel_about1_query);
$about1_details = $res_about1->fetch_assoc();

$sel_about2_query = "select * from static_pages where pageID ='4'";
$res_about2 = $dbconn->query($sel_about2_query);
$about2_details = $res_about2->fetch_assoc();

$page_metatitle = str_ireplace("{location}", $location_name, $page_metatitle);
$page_metadesc = str_ireplace("{location}", $location_name, $page_metadesc);
$page_metakey = str_ireplace("{location}", $location_name, $page_metakey);
$description = str_ireplace("{location}", $location_name, $description);

$page_metatitle = ($page_metatitle) ? $page_metatitle : $web_details['companyName'];
$page_metadesc = ($page_metadesc) ? $page_metadesc : $web_details['companyName'];
$page_metakey = ($page_metakey) ? $page_metakey : $web_details['companyName'];

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

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title><?= $page_metatitle ?></title>
    <meta name="description" content="<?= $page_metadesc ?>">
    <meta name="keywords" content="<?= $page_metakey ?>">
    <?php include 'app_top.php'; ?>
</head>

<body>
    <?php include 'app_header_sub.php'; ?>
    <div class="home_slider">
        <div class="homeSlider">
            <div class="swiper-wrapper">
                <?php
                $sel_ban_query = "Select * from banner_tbl order by bannerorder asc";
                $res_ban = $dbconn->query($sel_ban_query);
                if ($res_ban->num_rows > 0) {
                    $sno = 0;
                    while ($banners = $res_ban->fetch_assoc()) {
                        $sno++;
                ?>
                        <div class="swiper-slide">
                            <div class="slide"><img
                                    src="<?= site_url; ?>/uploaded-files/banner-image/<?= $banners['bannerImage']; ?>"
                                    alt="<?= $banners['personName']; ?> Manufacturers in <?= $location_name; ?>"
                                    title="<?= $banners['personName']; ?> Manufacturers in <?= $location_name; ?>"></div>
                        </div>
                <?php }
                } ?>
            </div>
            <div class="swiper-pagination"></div>
            <div class="swiper-button-prev"></div>
            <div class="swiper-button-next"></div>
        </div>
    </div>

    <div class="free-consulting">
        <div class="container">
            <div class="free-consultaiton-main">
                <div class="consultant-text">
                    <p>Scaffolding Accessories Manufacturer, Supplier, Wholeseller</p>
                </div>
                <div class="icon">
                    <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor"
                        viewBox="0 0 16 16">
                        <path fill-rule="evenodd"
                            d="M1 8a7 7 0 1 0 14 0A7 7 0 0 0 1 8zm15 0A8 8 0 1 1 0 8a8 8 0 0 1 16 0zM4.5 7.5a.5.5 0 0 0 0 1h5.793l-2.147 2.146a.5.5 0 0 0 .708.708l3-3a.5.5 0 0 0 0-.708l-3-3a.5.5 0 1 0-.708.708L10.293 7.5h-.5z" />
                    </svg>
                </div>
            </div>
        </div>
    </div>


    <div class="webpulse_home_service">
        <div class="container">
            <div class="row">
                <div class="col-xxl-3 col-xl-3 col-lg-3 col-md-3 col-sm-6 col-6">
                    <div class="service_1_shadow">
                        <div class="service_1_icon">
                            <img src="<?= site_url; ?>/designer/images/quality.png" alt="Highly Reliable Products"
                                title="Highly Reliable Products">
                        </div>
                        <div class="featureTitle">Highly Reliable Products</div>
                    </div>
                </div>

                <div class="col-xxl-3 col-xl-3 col-lg-3 col-md-3 col-sm-6 col-6">
                    <div class="service_1_shadow">
                        <div class="service_1_icon">
                            <img src="<?= site_url; ?>/designer/images/team.png" alt="Competitive Price"
                                title="Competitive Price">
                        </div>
                        <div class="featureTitle">Competitive Price</div>
                    </div>
                </div>


                <div class="col-xxl-3 col-xl-3 col-lg-3 col-md-3 col-sm-6 col-6">
                    <div class="service_1_shadow">
                        <div class="service_1_icon">
                            <img src="<?= site_url; ?>/designer/images/innovation.png" alt="Focus On Innovation"
                                title="Focus On Innovation">
                        </div>
                        <div class="featureTitle">Focus On Innovation</div>
                    </div>
                </div>

                <div class="col-xxl-3 col-xl-3 col-lg-3 col-md-3 col-sm-6 col-6">
                    <div class="service_1_shadow">
                        <div class="service_1_icon">
                            <img src="<?= site_url; ?>/designer/images/delivery.png" alt="Ready to Dispatch"
                                title="Ready to Dispatch">
                        </div>
                        <div class="featureTitle">Ready to Dispatch</div>
                    </div>
                </div>

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

    <div class="home_solar_2">
        <div class="discover_overlay"></div>
        <div class="sw_banner_bottom_shap_img_wrapper">
            <img src="<?= site_url; ?>/designer/images/image11.png" alt="shape" title="shape">
        </div>
        <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="sw_disc_txt_wrapper">

                        <div class="sw_left_heading_wraper sw_dark_heading_wraper">

                            <div class="sw_right_img_wrapper">
                                <div class="sw_disc_img_overlay"></div>
                                <img src="<?= site_url; ?>/uploaded-files/page-images/<?= $home_details['pageImage']; ?>"
                                    alt="Scaffolding Accessories Manufacturers in <?= $location_name; ?>"
                                    title="Scaffolding Accessories Manufacturers in <?= $location_name; ?>"
                                    class="img-responsive sw_right_img_div">

                                <div class="sw_disc_img_btm">
                                    <img src="<?= site_url; ?>/uploaded-files/page-images/<?= $home_details['pageImage']; ?>"
                                        alt="Scaffolding Accessories Manufacturers in <?= $location_name; ?>"
                                        title="Scaffolding Accessories Manufacturers in <?= $location_name; ?>"
                                        class="img-responsive">
                                </div>
                            </div>

                            <h1 class="title1">Top Scaffolding Accessories Manufacturers in <?= $location_name; ?></h1>
                            <img src="<?= site_url; ?>/designer/images/hd_line_dark.png"
                                alt="Scaffolding Accessories and Formwork System Manufacturers in <?= $location_name; ?>"
                                title="Scaffolding Accessories and Formwork System Manufacturers in <?= $location_name; ?>">
                            <div>
                                <?= $description; ?>
                            </div>
                            <a class="read_more_btn" href="<?= site_url; ?>/about.htm" title="Read More">Read More</a>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="sw_banner_bottom_shap_img_wrapper">
            <img src="<?= site_url; ?>/designer/images/image.png" alt="shape" title="shape">
        </div>
    </div>

    <div class="services-style1-area">
        <div class="container">
            <div class="sec-title with-text text-center">
                <div class="title">Our Product</div>
                <div class="border-box center"></div>
                <span>We are dedicated to offering the best scaffolding accessories and formworks that are made
                    utilizing high-quality raw materials and the latest technology. Our products are of the highest
                    standards and are available at the most competitive prices.</span>
            </div>
            <div class="clearfix"></div>
            <div class="row">
                <?php
                $sel_cat_query = "select * from category_tbl where parentID = '1' order by catOrder asc limit 8";
                $res_cat = $dbconn->query($sel_cat_query);
                if ($res_cat->num_rows > 0) {
                    while ($categories = $res_cat->fetch_assoc()) {
                        $cate_href = str_ireplace(" ", "-", $categories['catName']);
                        $cat_desc = '';
                        if ($categories['catImage']) {
                            $sel_subd_cat = "select * from location_content_tbl where category_id = '" . $categories['catID'] . "'";
                            $res_subd = $dbconn->query($sel_subd_cat);
                            while ($category_det = $res_subd->fetch_assoc()) {
                                $locati = explode(",", $category_det['location_ids']);
                                if (in_array($location_id, $locati)) {
                                    $cat_desc = substr_replace(str_ireplace("{location}", $location_name, $category_det['short_description']), '...', 100);
                                }
                            }
                ?>

                            <div class="col-xxl-3 col-xl-3 col-lg-3 col-md-3 col-sm-4 col-12">
                                <div class="single-service-style1">
                                    <a href="<?= site_url . '/' . $location . '/' . strtolower($cate_href); ?>.htm"
                                        title="<?= $categories['displayName']; ?> in <?= $location_name; ?>">
                                        <div class="img-holder">
                                            <img src="<?= site_url; ?>/uploaded-files/category/images/<?= $categories['catImage']; ?>"
                                                alt="<?= $categories['displayName']; ?> in <?= $location_name; ?>"
                                                title="<?= $categories['displayName']; ?> in <?= $location_name; ?>">
                                            <div class="overlay-style-two"></div>
                                            <div class="overlay-content-box">
                                                <div class="icon">
                                                    <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16"
                                                        fill="currentColor" viewBox="0 0 16 16">
                                                        <path
                                                            d="M8 4.754a3.246 3.246 0 1 0 0 6.492 3.246 3.246 0 0 0 0-6.492zM5.754 8a2.246 2.246 0 1 1 4.492 0 2.246 2.246 0 0 1-4.492 0z" />
                                                        <path
                                                            d="M9.796 1.343c-.527-1.79-3.065-1.79-3.592 0l-.094.319a.873.873 0 0 1-1.255.52l-.292-.16c-1.64-.892-3.433.902-2.54 2.541l.159.292a.873.873 0 0 1-.52 1.255l-.319.094c-1.79.527-1.79 3.065 0 3.592l.319.094a.873.873 0 0 1 .52 1.255l-.16.292c-.892 1.64.901 3.434 2.541 2.54l.292-.159a.873.873 0 0 1 1.255.52l.094.319c.527 1.79 3.065 1.79 3.592 0l.094-.319a.873.873 0 0 1 1.255-.52l.292.16c1.64.893 3.434-.902 2.54-2.541l-.159-.292a.873.873 0 0 1 .52-1.255l.319-.094c1.79-.527 1.79-3.065 0-3.592l-.319-.094a.873.873 0 0 1-.52-1.255l.16-.292c.893-1.64-.902-3.433-2.541-2.54l-.292.159a.873.873 0 0 1-1.255-.52l-.094-.319zm-2.633.283c.246-.835 1.428-.835 1.674 0l.094.319a1.873 1.873 0 0 0 2.693 1.115l.291-.16c.764-.415 1.6.42 1.184 1.185l-.159.292a1.873 1.873 0 0 0 1.116 2.692l.318.094c.835.246.835 1.428 0 1.674l-.319.094a1.873 1.873 0 0 0-1.115 2.693l.16.291c.415.764-.42 1.6-1.185 1.184l-.291-.159a1.873 1.873 0 0 0-2.693 1.116l-.094.318c-.246.835-1.428.835-1.674 0l-.094-.319a1.873 1.873 0 0 0-2.692-1.115l-.292.16c-.764.415-1.6-.42-1.184-1.185l.159-.291A1.873 1.873 0 0 0 1.945 8.93l-.319-.094c-.835-.246-.835-1.428 0-1.674l.319-.094A1.873 1.873 0 0 0 3.06 4.377l-.16-.292c-.415-.764.42-1.6 1.185-1.184l.292.159a1.873 1.873 0 0 0 2.692-1.115l.094-.319z" />
                                                    </svg>
                                                </div>
                                                <div class="title">
                                                    <div class="title2"><?= $categories['displayName']; ?></div>
                                                </div>
                                            </div>
                                        </div>
                                    </a>
                                    <!-- <div class="text-holder">
                                        <p><?php echo $cat_desc; ?></p>
                                        <div class="button">
                                            <a href="<?= site_url . '/' . $location . '/' . strtolower($cate_href); ?>.htm"
                                                title="Read More">Read More <span class="icon-null"></span></a>
                                        </div>
                                    </div> -->
                                </div>
                            </div>

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


        </div>

    </div>
    <div class="has-overlay tabbed-funfact-wrapper">
        <div class="container">
            <ul class="nav nav-tabs tab-title clearfix" role="tablist">
                <li class="nav-item">
                    <a class="nav-link active" href="#online" role="tab" data-bs-toggle="tab"
                        title="About Kayson Steelcast LLP">
                        <div class="tabTitle">About Kayson Steelcast LLP</div>
                        <p>Go through</p>
                    </a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" href="#time" role="tab" data-bs-toggle="tab" title="Our Infrastructure">
                        <div class="tabTitle">Our Infrastructure</div>
                        <p>Go through</p>
                    </a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" href="#invision" role="tab" data-bs-toggle="tab" title="Why Us?">
                        <div class="tabTitle">Why Us?</div>
                        <p>Go through</p>
                    </a>
                </li>
            </ul>

            <div class="tab-content">
                <div role="tabpanel" class="tab-pane active show fadeInUp" id="online">
                    <div class="single-tab-wrapper">
                        <div class="row">
                            <div class="col-xxl-6 col-xl-6 col-lg-6 col-md-6 col-sm-6 col-12">
                                <img src="<?= site_url; ?>/designer/images/tab1.jpg" alt="About Kayson Steelcast LLP"
                                    title="About Kayson Steelcast LLP">
                            </div>
                            <div class="col-xxl-6 col-xl-6 col-lg-6 col-md-6 col-sm-6 col-12">
                                <div class="single-tab-content">
                                    <div class="top-box">
                                        <div class="text-block">
                                            <div class="titlediv">About Kayson Steelcast LLP</div>
                                        </div>
                                    </div>
                                    <div class="content-box">
                                        <?= $about_details['pageDesc']; ?>
                                        <a class="read_more_btn" href="<?= site_url; ?>/about.htm"
                                            title="Read More">Read More</a>
                                    </div>

                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div role="tabpanel" class="tab-pane fadeInUp" id="time">
                    <div class="single-tab-wrapper">
                        <div class="row">
                            <div class="col-xxl-6 col-xl-6 col-lg-6 col-md-6 col-sm-6 col-12">
                                <img src="<?= site_url; ?>/designer/images/tab2.jpg" alt="Our Infrastructure"
                                    title="Our Infrastructure">
                            </div>
                            <div class="col-xxl-6 col-xl-6 col-lg-6 col-md-6 col-sm-6 col-12">
                                <div class="single-tab-content">
                                    <div class="top-box">
                                        <div class="text-block">
                                            <div class="titlediv">Our Infrastructure</div>
                                        </div>
                                    </div>
                                    <div class="content-box">
                                        <?= $about2_details['pageDesc']; ?>
                                        <a class="read_more_btn" href="<?= site_url; ?>/about.htm"
                                            title="Read More">Read More</a>
                                    </div>

                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div role="tabpanel" class="tab-pane fadeInUp" id="invision">
                    <div class="single-tab-wrapper">
                        <div class="row">
                            <div class="col-xxl-6 col-xl-6 col-lg-6 col-md-6 col-sm-6 col-12">
                                <img src="<?= site_url; ?>/designer/images/tab3.jpg" alt="Why Us?" title="Why Us?">
                            </div>
                            <div class="col-xxl-6 col-xl-6 col-lg-6 col-md-6 col-sm-6 col-12">
                                <div class="single-tab-content">
                                    <div class="top-box">
                                        <div class="text-block">
                                            <div class="titlediv">Why Us?</div>
                                        </div>
                                    </div>
                                    <div class="content-box">
                                        <?= $about1_details['pageDesc']; ?>
                                        <a class="read_more_btn" href="<?= site_url; ?>/about.htm"
                                            title="Read More">Read More</a>
                                    </div>

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

    <?php include "app_testimonials.php"; ?>

    <div class="home_solar_2 home_solar_3">
        <div class="discover_overlay"></div>
        <div class="sw_banner_bottom_shap_img_wrapper">
            <img src="<?= site_url; ?>/designer/images/image9.png" alt="shape" title="shape">
        </div>

        <div class="container">
            <div class="sec-title with-text clrwhite text-center">
                <p>Working Process</p>
                <div class="title">How to Get Better Results</div>
                <div class="border-box center bgblue"></div>
            </div>

            <div class="row">
                <div class="col-xxl-12 col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12">
                    <div class="stepSlider">
                        <div class="swiper-wrapper">
                            <div class="swiper-slide">
                                <div class="single-working-process text-center">
                                    <div class="top-box">
                                        <div class="number">Step<br> 01</div>
                                    </div>
                                    <div class="processTitle">Consult<br> Our Expert Team</div>
                                    <p>Get in touch with or experienced professionals to receive expert guidance.
                                    </p>

                                </div>


                            </div>

                            <div class="swiper-slide">
                                <div class="single-working-process text-center">
                                    <div class="top-box">
                                        <div class="number">Step<br> 02</div>
                                    </div>
                                    <div class="processTitle">Ordering<br> Your Equipments</div>
                                    <p>Choose from our high-quality scaffolding solutions and place your order with confidence.</p>

                                </div>
                            </div>

                            <div class="swiper-slide">
                                <div class="single-working-process text-center">
                                    <div class="top-box">
                                        <div class="number">Step<br> 03</div>
                                    </div>
                                    <div class="processTitle">Scaffolding <br> Product Delivery</div>
                                    <p>We ensure prompt and reliable delivery of your scaffolding materials to your location.</p>

                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="sw_banner_bottom_shap_img_wrapper">
            <img src="<?= site_url; ?>/designer/images/image10.png" alt="shape" title="shape">
        </div>
    </div>

    <div class="home_solar_2 home_blog">
        <div class="discover_overlay"></div>
        <?php
        $sel_blog_query = "select * from blog_tbl order by catID desc limit 3";
        $res_blog = $dbconn->query($sel_blog_query);
        if ($res_blog->num_rows > 0) {
        ?>
            <div class="container">
                <div class="sec-title with-text text-center">
                    <div class="title">Latest News</div>
                    <div class="border-box center bgblue"></div>
                </div>

                <div class="row">
                    <?php
                    $sno = 1;
                    while ($blogs = $res_blog->fetch_assoc()) {
                        $blog_href = str_ireplace(" ", "-", $blogs['catName']);
                        $sno++;
                    ?>
                        <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-4 col-sm-4 col-12">
                            <div class="btc_blog_indx_box_wrapper">
                                <a href="<?= site_url; ?>/blog/<?= strtolower($blog_href); ?>.htm"
                                    title="<?= $blogs['blogDname']; ?>">
                                    <div class="btc_blog_indx_img_wrapper">
                                        <img src="<?= site_url; ?>/uploaded-files/blog/images/<?= $blogs['catImage']; ?>"
                                            alt="<?= $blogs['blogDname']; ?>" title="<?= $blogs['blogDname']; ?>">
                                        <div class="btc_blog_indx_date_wrapper">
                                            <span><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16"
                                                    fill="currentColor" viewBox="0 0 16 16">
                                                    <path fill-rule="evenodd"
                                                        d="M1 8a.5.5 0 0 1 .5-.5h11.793l-3.147-3.146a.5.5 0 0 1 .708-.708l4 4a.5.5 0 0 1 0 .708l-4 4a.5.5 0 0 1-.708-.708L13.293 8.5H1.5A.5.5 0 0 1 1 8z" />
                                                </svg></span>
                                        </div>
                                    </div>
                                    <div class="btc_blog_indx_cont_wrapper">
                                        <p><?= date('M d Y', strtotime($blogs['blogDate'])); ?></p>
                                        <div class="blogTitle"><?= $blogs['blogDname']; ?></div>
                                    </div>
                                </a>
                            </div>
                        </div>
                    <?php } ?>
                </div>
            </div>
        <?php } ?>
    </div>
    <?php include 'app_factory.php'; ?>

    <?php include 'app_clients.php'; ?>
    <?php include 'app_footer_sub.php'; ?>
    <?php include 'app_bottom.php'; ?>

</body>

</html>