<?php
include_once("include/main.inc.php");
@extract($_REQUEST);
if (preg_match('webpulse\.co$/', $_SERVER['HTTP_HOST'], $match)) {
  $match1 = $match[1];
  $vanity_url = 'http://' . $_SERVER['HTTP_HOST'];
}
$actual_link = "http://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";

$ee = explode('/', $actual_link);
$loc_url = $ee[3];
$cat_url = $_REQUEST['pid'];
$cats = ucwords(str_replace("-", " ", $_REQUEST['pid']));

$cat_s = "select catName, catID from category_tbl where catName='$cats' or catUrl='$cat_url'";

$cat_q = mysqli_query($GLOBALS['dbconn'], $cat_s);

if (mysqli_num_rows($cat_q) > 0) {
} else {
  header("Location: " . site_url);
  exit;
}

$num = mysqli_num_rows($cat_q);
$cat_r = mysqli_fetch_array($cat_q);
$category_id = $cat_r['catID'];
$hover = $category_id;
$catn = $cat_r['catName'];

$cat_sql = "select catImage, catName, displayName, catDesc, catID, catDesc1, parentID, catUrl from category_tbl where parentID='$category_id' and status='Y'";

$cat_qry = mysqli_query($GLOBALS['dbconn'], $cat_sql);
$cccnum = mysqli_num_rows($cat_qry);

$cat_sql1 = "select catName, displayName, catID, parentID,catImage,catDesc1,catBanner,keyword1,keyword2,keyword3,catHeading1, catHeading2,alt,pageTitle,pageKeywords,pageDescription,multi_image,catDesc2 from category_tbl where catID='$category_id'";

$cat_qry1 = mysqli_query($GLOBALS['dbconn'], $cat_sql1);
$cat_res = mysqli_fetch_array($cat_qry1);
$pageTitles = $cat_res['catName'];
$disTitles = $cat_res['displayName'];



$parent = $cat_res['parentID'];
$cat_sql2 = "select catName, displayName, catID, parentID from category_tbl where catID='$parent'";
$cat_qry2 = mysqli_query($GLOBALS['dbconn'], $cat_sql2);
$num2 = mysqli_num_rows($cat_qry2);
$cat_res2 = mysqli_fetch_array($cat_qry2);
$mparent = $cat_res2['parentID'];
$cat_sql3 = "select catName, displayName, catID, parentID from category_tbl where catID='$mparent'";
$cat_qry3 = mysqli_query($GLOBALS['dbconn'], $cat_sql3);
$num3 = mysqli_num_rows($cat_qry3);
$cat_res3 = mysqli_fetch_array($cat_qry3);
$mmparent = $cat_res3['parentID'];
$cat_sql4 = "select catName, displayName, catID, parentID from category_tbl where catID='$mmparent'";
$cat_qry4 = mysqli_query($GLOBALS['dbconn'], $cat_sql4);
$num4 = mysqli_num_rows($cat_qry4);
$cat_res4 = mysqli_fetch_array($cat_qry4);
$mobile = $admin_res['mobile'];
$city = $admin_res['city'];
$state = $admin_res['state'];
$country = $admin_res['country'];
$companyName = $admin_res['companyName'];
$address = $admin_res['address'];

if ($cat_res['catImage'] != '') {
  $imglink = getImage($cat_res[catImage], 500, 500, $cat_res[catName], "/uploaded-files/category/images/");
} else {
  $imglink = getImage("noimage.jpg", 500, 500, "noimages", "/uploaded-files/category/images/");
}

$loc_sql = mysqli_query($GLOBALS['dbconn'], "select locationID,locationName,loc_url from location_tbl where loc_url='$loc_url' and status='Y'");

$location = mysqli_fetch_array($loc_sql);

$locationName = $location['locationName'];

$location_id = $location['locationID'];

$category_sub_general = mysqli_query($dbconn, "select location_ids,meta_title,meta_keyword,meta_description,description,short_description,subheadingtwo,description2 from location_content_tbl where category_id='$category_id' AND location_id='0'");

$content_count = mysqli_num_rows($category_sub_general);

if ($content_count > 0) {

  while ($categorysubdomain = mysqli_fetch_array($category_sub_general)) {

    $locati = explode(",", $categorysubdomain['location_ids']);

    if (in_array($location_id, $locati)) {

      if ($categorysubdomain['meta_title'] != '') {

        $page_metatitle = $categorysubdomain['meta_title'];
      }

      if ($categorysubdomain['meta_keyword'] != '') {

        $page_metakey = $categorysubdomain['meta_keyword'];
      }

      if ($categorysubdomain['meta_description']) {

        $page_metadesc = $categorysubdomain['meta_description'];
      }

      $page_desc = $categorysubdomain['description'];

      $page_desc2 = $categorysubdomain['description2'];
    }
  }

  //    specific location content

}

if ($cat_res['keyword1'] != '' && $cat_res['keyword2'] != '' && $cat_res['keyword3'] != '') {

  $m_title = "hotkeyword1 Manufacturers in location, hotkeyword2 Suppliers Exporters in location";

  $page_metatitle = str_replace('hotkeyword1', $cat_res[keyword1], str_replace('hotkeyword2', $cat_res[keyword2], str_replace('location', $locationName, $m_title)));

  $m_keyword = "hotkeyword1 in location, hotkeyword2 in location, hotkeyword1 Manufacturers in location, hotkeyword2 Manufacturers in location, hotkeyword1 Suppliers in location, hotkeyword2 Suppliers in location, hotkeyword1 Exporters in location, hotkeyword2 Exporters in location";

  $page_metakey = str_replace('hotkeyword1', $cat_res[keyword1], str_replace('hotkeyword2', $cat_res[keyword2], str_replace('hotkeyword3', $cat_res[keyword3], str_replace('location', $locationName, $m_keyword))));

  $meta_des = "companyName leading hotkeyword1 Manufacturers in location, Since 2011. Premium Quality hotkeyword2 Suppliers Exporters in location, Get latest factory price for hotkeyword3. Call phone, ✓Fast Delivery ✓Good Price ✓Premium Quality";

  $page_metadesc = str_replace('hotkeyword1', $cat_res[keyword1], str_replace('hotkeyword2', $cat_res[keyword2], str_replace('hotkeyword3', $cat_res[keyword3], str_replace('companyName', $admin_res['companyName'], str_replace('phone', $admin_res['mobile_meta'], str_replace('location', $locationName, $meta_des))))));
} else if ($cat_res['keyword1'] != '' && $cat_res['keyword2'] != '') {

  $m_title = "hotkeyword1 Manufacturers in location, hotkeyword2 Suppliers in location";

  $page_metatitle = str_replace('hotkeyword1', $cat_res[keyword1], str_replace('hotkeyword2', $cat_res[keyword2], str_replace('location', $locationName, $m_title)));

  $m_keyword = "hotkeyword1 in location, hotkeyword1 Manufacturers in location, hotkeyword1 Suppliers in location, hotkeyword2 in location, hotkeyword2 Manufacturers in location, hotkeyword2 Suppliers in location";

  $page_metakey = str_replace('hotkeyword1', $cat_res[keyword1], str_replace('hotkeyword2', $cat_res[keyword2], str_replace('location', $locationName, $m_keyword)));

  $meta_des = "hotkeyword1 Manufacturers in location, since 2011. Premium Quality hotkeyword2 Suppliers in location, Get latest factory price for hotkeyword1. ✓Fast Delivery ✓Good Price ✓Premium Quality";

  $page_metadesc = str_replace('hotkeyword1', $cat_res[keyword1], str_replace('hotkeyword2', $cat_res[keyword2], str_replace('companyName', $admin_res[companyName], str_replace('phone', $admin_res['mobile_meta'], str_replace('location', $locationName, $meta_des)))));
} else if ($cat_res['keyword1'] != '') {

  $m_title = "hotkeyword1 Manufacturers in location, hotkeyword1 Suppliers Exporters in location";

  $page_metatitle = str_replace('hotkeyword1', $cat_res[keyword1], str_replace('location', $locationName, $m_title));

  $m_keyword = "hotkeyword1 in location, hotkeyword1 Manufacturers in location, hotkeyword1 Suppliers in location, hotkeyword1 Exporters in location";

  $page_metakey = str_replace('hotkeyword1', $cat_res[keyword1], str_replace('location', $locationName, $m_keyword));

  $meta_des = "companyName leading hotkeyword1 Manufacturers in location, Since 2011. Premium Quality hotkeyword1 Suppliers Exporters in locationh, Get latest factory price for hotkeyword1. Call phone, ✓Fast Delivery ✓Good Price ✓Premium Quality";

  $page_metadesc = str_replace('hotkeyword1', $cat_res[keyword1], str_replace('companyName', $admin_res[companyName], str_replace('phone', $admin_res['mobile_meta'], str_replace('location', $locationName, $meta_des))));
} else {

  $page_metatitle = $page_metatitle1;

  $page_metakey = $page_metakey1;

  $page_metadesc = $page_metadesc1;
}

$page_desc = str_replace('countryname', $locationName, $page_desc);

$page_desc = str_replace('catname', $pid, $page_desc);

$page_desc = str_replace('{location}', $locationName, $page_desc);

$page_desc = str_ireplace('{companyName}', $admin_res['companyName'], $page_desc);

// for second description 

$page_desc2 = str_replace('countryname', $locationName, $page_desc2);

$page_desc2 = str_replace('catname', $pid, $page_desc2);

$page_desc2 = str_replace('{location}', $locationName, $page_desc2);

$page_desc2 = str_ireplace('{companyName}', $admin_res['companyName'], $page_desc2);

// meta keywords 

$page_metatitle = str_replace('countryname', $locationName, $page_metatitle);

$page_metatitle = str_replace('catname', $pid, $page_metatitle);

$page_metatitle = str_replace('{location}', $locationName, $page_metatitle);

$page_metakey = str_replace('countryname', $locationName, $page_metakey);

$page_metakey = str_replace('catname', $pid, $page_metakey);

$page_metakey = str_replace('{location}', $locationName, $page_metakey);

$page_metadesc = str_replace('countryname', $locationName, $page_metadesc);

$page_metadesc = str_replace('catname', $pid, $page_metadesc);

$page_metadesc = str_replace('{location}', $locationName, $page_metadesc);

// if location not checked in admin 

$category_sub_uncheck_loc = mysqli_query($GLOBALS['dbconn'], "select description,subheadingtwo,short_description,description2 from location_content_tbl where category_id='$category_id' AND location_id='0'");

$category_sub_uncheck_res = mysqli_fetch_array($category_sub_uncheck_loc);

// For description 1 (uncheck location)

$page_descUncheck = $category_sub_uncheck_res['description'];

$page_descUncheck = str_replace('{location}', $locationName,  $page_descUncheck);

$page_descUncheck = str_ireplace('{companyName}', $admin_res['companyName'], $page_descUncheck);

// For description 2 (uncheck location)

$page_desc2Uncheck = $category_sub_uncheck_res['description'];

$page_desc2Uncheck = str_replace('{location}', $locationName,  $page_desc2Uncheck);

$page_desc2Uncheck = str_ireplace('{companyName}', $admin_res['companyName'], $page_desc2Uncheck);

$page_desc = $page_desc != '' ? $page_desc : $page_descUncheck;

$page_desc2 = $page_desc2 != '' ? $page_desc2 : $page_desc2Uncheck;

if ($cat_res['catHeading1'] != '') {
  $heading1 = $cat_res['catHeading1'] . ' Manufacturers in ' . $locationName;
} else {
  $heading1 = $disTitles . ' Manufacturers in ' . $locationName;
}

if ($cat_res['catHeading2'] != '') {
  $heading2 = $cat_res['catHeading2'] . ' in ' . $locationName;
} else {
  $heading2 = $disTitles . ' in ' . $locationName;
}

if ($cat_res['alt'] != '') {
  $alttag = $cat_res['alt'] . ' Manufacturers in ' . $locationName;
} else {
  $alttag = $disTitles . ' Manufacturers in ' . $locationName;
}


if (strpos($_SERVER['REQUEST_URI'], "?") !== false) {
  $uri_parts = explode('?', $_SERVER['REQUEST_URI']);
  $linksLoc = $uri_parts[0];
  header("Location: ".site_url.$linksLoc);
  exit;
  
}


if (mysqli_num_rows($loc_sql) > 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">
  <?php include "app_top.php"; ?>
</head>

<body>
  <?php include "app_header_sub.php"; ?>
  <section class="heading_banner" style="background-image: url(<?= site_url; ?>/designer/images/about-banner.jpg)">
    <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 text-center">
          <h1 class="cat_title"><?= $heading1; ?></h1>
          <div class="clearfix"></div>
        </div>
      </div>
    </div>
  </section>

  <div class="inner_breadcrumb hidden_xs">
    <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">
          <ul class="breadcrumb">
            <li><a href="<?= site_url; ?>" title="Home">Home</a></li>
            <?php if ($num4 > 0) { ?>
              <li>
                <a href="<?= site_url; ?>/<?= getValidFileName($loc_url); ?>/<?= getValidFileName($cat_res4['catName']); ?>.htm" title="<?php echo $cat_res4['catName']; ?> "><?php echo $cat_res4['catName']; ?></a>
              </li>
              <?php } ?><?php if (mysqli_num_rows($cat_qry3) > 0) { ?>
              <li>
                <a href="<?= site_url; ?>/<?= getValidFileName($loc_url); ?>/<?= getValidFileName($cat_res3['catName']); ?>.htm" title="<?php echo $cat_res3['catName']; ?>"><?php echo $cat_res3['catName']; ?></a>
              </li>
              <?php } ?><?php if (mysqli_num_rows($cat_qry2) > 0) { ?>
              <li>
                <a href="<?= site_url; ?>/<?= getValidFileName($loc_url); ?>/<?= getValidFileName($cat_res2['catName']); ?>.htm" title="<?php echo $cat_res2['catName']; ?>"><?php echo $cat_res2['catName']; ?></a>
              </li>
            <?php  } ?>
            <li class="active"><?php echo $cat_res['catName']; ?></li>
          </ul>
        </div>
      </div>
    </div>
  </div>

  <section class="category_page">
    <div class="container">
      <!-- <h2 class="title_2"><?= $heading2; ?></h2>
      <div class="clearfix"></div> -->
      <div class="wps_right">
        <div class="product_right_image">
          <a href="#productID" data-bs-toggle="modal" onclick="$('.catID').val('<?php echo $cat_res['catID']; ?>');  $('.catName').html('<?php echo $cat_res['catName']; ?>'); $('.catImg').attr('src','<?= $imglink; ?>');  $('.catImg').attr('alt','<?= $alttag; ?>'); $('.catImg').attr('title','<?= $alttag; ?>');" title="<?= $alttag; ?>">
            <div class="detail_image">
              <img class="img-responsive" src="<?= $imglink; ?>" alt="<?= $alttag; ?>" title="<?= $alttag; ?>">
            </div>
            <span class="read_more_btn"><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                <path d="M.05 3.555A2 2 0 0 1 2 2h12a2 2 0 0 1 1.95 1.555L8 8.414.05 3.555ZM0 4.697v7.104l5.803-3.558L0 4.697ZM6.761 8.83l-6.57 4.027A2 2 0 0 0 2 14h12a2 2 0 0 0 1.808-1.144l-6.57-4.027L8 9.586l-1.239-.757Zm3.436-.586L16 11.801V4.697l-5.803 3.546Z"></path>
              </svg> Get Best Quote</span>
          </a>
        </div>
        <?php echo html_entity_decode($page_desc); ?>
        <div class="clearfix"></div>
        <?php
        $product_s = mysqli_query($GLOBALS['dbconn'], "SELECT product_image, product_title, catalog, product_id, product_video, product_specfi FROM product_tbl WHERE FIND_IN_SET('" . $cat_res['catID'] . "', product_cat)");
        $num = mysqli_num_rows($product_s);
        if ($num > 0) { ?>
          <div class="you_may p-0">Products Related to <?= $disTitles; ?></div>
          <div class="row g-3">
            <?php $i = 1;
            while ($product_r = mysqli_fetch_array($product_s)) {
              $pro_image = explode(',', $product_r['product_image']);
              $probig_img = $pro_image[0];
              $prod_img = getImage($probig_img, 500, 500, $product_r['product_title'], "/uploaded-files/product-images/");
              $prod_imgsmall = getImage($probig_img, 400, 400, $product_r['product_title'], "/uploaded-files/product-images/");
            ?>
              <div class="col-12 pr_view">
                <div class="pr-li">
                  <div class="row g-0">
                    <div class="col-lg-4 col-md-5 col-12 g_col">
                      <div class="img_bx">
                        <a class="main-img" id="bigImage<?= $i; ?>" href="javascript:void(0);"
                          data-bs-toggle="modal" data-bs-target="#productID"
                          onclick="var src = $(this).find('img.clickable-image').attr('src');$('.catID').val('<?php echo $product_r['product_id']; ?>');$('.catName').html('<?php echo $product_r['product_title']; ?>');$('.catImg').attr('src', src);$('.catImg').attr('alt','<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $locationName; ?>');$('.catImg').attr('title','<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $locationName; ?>');" title="<?= $product_r['product_title']; ?> Manufacturers in <?= $locationName; ?>">

                          <img id="mainImage<?= $product_r['product_id']; ?>"
                            src="<?= $prod_img; ?>" class="clickable-image"
                            alt="<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $locationName; ?>"
                            title="<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $locationName; ?>">
                        </a>

                        <!-- Show multi images only if there are more than 1 image -->
                        <?php if (count($pro_image) > 1) { ?>
                          <div class="multi-imgs">
                            <?php
                            $snn = 1;
                            foreach ($pro_image as $pro_imag_vals) {
                              if (!empty($pro_imag_vals)) { ?>
                                <div class="imgs <?= $snn == 1 ? 'active' : ''; ?>"
                                  onclick="imgMulti(<?= $product_r['product_id']; ?>, '<?= getImage($pro_imag_vals, 600, 600, $product_r['product_title'] . $product_r['product_id'] . $snn, '/uploaded-files/product-images/'); ?>', this)">
                                  <img src="<?= getImage($pro_imag_vals, 100, 100, $product_r['product_title'] . $product_r['product_id'] . $snn, '/uploaded-files/product-images/'); ?>"
                                    alt="<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $locationName; ?>"
                                    title="<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $locationName; ?>">
                                </div>
                            <?php $snn++;
                              }
                            }
                            ?>
                            <?php if ($product_r['product_video'] != '') { ?>
                              <div class="imgs youTube">
                                <a data-fancybox="" href="https://www.youtube.com/watch?v=<?= $product_r['product_video']; ?>">
                                  <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                                    <path d="m11.596 8.697-6.363 3.692c-.54.313-1.233-.066-1.233-.697V4.308c0-.63.692-1.01 1.233-.696l6.363 3.692a.802.802 0 0 1 0 1.393z"></path>
                                  </svg>
                                </a>
                              </div>
                            <?php } ?>
                          </div>
                        <?php } ?>
                      </div>
                    </div>

                    <div class="col-lg-8 col-md-7 col-12 g_col">
                      <div class="tx-bx">
                        <h4 class="title"><?= $product_r['product_title']; ?> in <?= $locationName; ?></h4>
                        <?php if ($product_r['catalog'] != '') { ?>
                          <div class="bt_bx mb-2">
                            <div class="productBrochureandvideo">
                              <a href="<?= site_url; ?>/uploaded-files/pdf/<?= $product_r['catalog']; ?>" title="Product Brochure" target="_blank">
                                <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-filetype-pdf" viewBox="0 0 16 16">
                                  <path fill-rule="evenodd" d="M14 4.5V14a2 2 0 0 1-2 2h-1v-1h1a1 1 0 0 0 1-1V4.5h-2A1.5 1.5 0 0 1 9.5 3V1H4a1 1 0 0 0-1 1v9H2V2a2 2 0 0 1 2-2h5.5L14 4.5ZM1.6 11.85H0v3.999h.791v-1.342h.803c.287 0 .531-.057.732-.173.203-.117.358-.275.463-.474a1.42 1.42 0 0 0 .161-.677c0-.25-.053-.476-.158-.677a1.176 1.176 0 0 0-.46-.477c-.2-.12-.443-.179-.732-.179Zm.545 1.333a.795.795 0 0 1-.085.38.574.574 0 0 1-.238.241.794.794 0 0 1-.375.082H.788V12.48h.66c.218 0 .389.06.512.181.123.122.185.296.185.522Zm1.217-1.333v3.999h1.46c.401 0 .734-.08.998-.237a1.45 1.45 0 0 0 .595-.689c.13-.3.196-.662.196-1.084 0-.42-.065-.778-.196-1.075a1.426 1.426 0 0 0-.589-.68c-.264-.156-.599-.234-1.005-.234H3.362Zm.791.645h.563c.248 0 .45.05.609.152a.89.89 0 0 1 .354.454c.079.201.118.452.118.753a2.3 2.3 0 0 1-.068.592 1.14 1.14 0 0 1-.196.422.8.8 0 0 1-.334.252 1.298 1.298 0 0 1-.483.082h-.563v-2.707Zm3.743 1.763v1.591h-.79V11.85h2.548v.653H7.896v1.117h1.606v.638H7.896Z"></path>
                                </svg>
                                <span>Product Brochure</span>
                              </a>
                            </div>
                          </div>
                        <?php } ?>

                        <div class="info">
                          <?= html_entity_decode($product_r['product_specfi']); ?>
                        </div>

                        <div class="">
                          <a class="read_more_btn mb-1" href="#productID" data-bs-toggle="modal" onclick="$('.catID').val('<?php echo $product_r['product_id']; ?>');$('.catName').html('<?php echo $product_r['product_title']; ?>');$('.catImg').attr('src','<?= $prod_img; ?>');$('.catImg').attr('alt','<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $locationName; ?>');$('.catImg').attr('title','<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $locationName; ?>');" title="Get Best Quote"><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                              <path d="M.05 3.555A2 2 0 0 1 2 2h12a2 2 0 0 1 1.95 1.555L8 8.414.05 3.555ZM0 4.697v7.104l5.803-3.558L0 4.697ZM6.761 8.83l-6.57 4.027A2 2 0 0 0 2 14h12a2 2 0 0 0 1.808-1.144l-6.57-4.027L8 9.586l-1.239-.757Zm3.436-.586L16 11.801V4.697l-5.803 3.546Z"></path>
                            </svg> Get Best Quote</a>

                          <a href="#callback" data-bs-toggle="modal" class="read_more_btn callback" onclick="$('.catID').val('<?php echo $product_r['product_id']; ?>');$('.catName').html('<?php echo $product_r['product_title']; ?>');$('.catImg').attr('src','<?= $prod_imgsmall; ?>');$('.catImg').attr('alt','<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $locationName; ?>');$('.catImg').attr('title','<?= $product_r['product_title']; ?> Manufacturers, Suppliers in <?= $locationName; ?>');" title="Request A Callback">
                            <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-telephone" viewBox="0 0 16 16">
                              <path d="M3.654 1.328a.678.678 0 0 0-1.015-.063L1.605 2.3c-.483.484-.661 1.169-.45 1.77a17.6 17.6 0 0 0 4.168 6.608 17.6 17.6 0 0 0 6.608 4.168c.601.211 1.286.033 1.77-.45l1.034-1.034a.678.678 0 0 0-.063-1.015l-2.307-1.794a.68.68 0 0 0-.58-.122l-2.19.547a1.75 1.75 0 0 1-1.657-.459L5.482 8.062a1.75 1.75 0 0 1-.46-1.657l.548-2.19a.68.68 0 0 0-.122-.58zM1.884.511a1.745 1.745 0 0 1 2.612.163L6.29 2.98c.329.423.445.974.315 1.494l-.547 2.19a.68.68 0 0 0 .178.643l2.457 2.457a.68.68 0 0 0 .644.178l2.189-.547a1.75 1.75 0 0 1 1.494.315l2.306 1.794c.829.645.905 1.87.163 2.611l-1.034 1.034c-.74.74-1.846 1.065-2.877.702a18.6 18.6 0 0 1-7.01-4.42 18.6 18.6 0 0 1-4.42-7.009c-.362-1.03-.037-2.137.703-2.877z" />
                            </svg> Request A Callback</a>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
              </div>

            <?php $i++;
            } ?>
          </div>
          <div class="clearfix"></div>
        <?php } ?>
        <div class="you_may p-0 mt-4">All Category Range</div>
        <div class="allListing">
          <div class="row g-3">
            <?php
            if (mysqli_num_rows($cat_qry) > 1) {
              $subcat_sql = $cat_qry;
            } else {

              $subcat_sql = mysqli_query($GLOBALS['dbconn'], "select catImage, catName, displayName, catDesc, catID, catDesc1, parentID from category_tbl where parentID ='$parent' and status='Y' and catID!='$category_id' order by catOrder Asc");
            }
            if (mysqli_num_rows($subcat_sql) < 2) {
              $subcat_sql = mysqli_query($GLOBALS['dbconn'], "select catImage, catName, displayName, catDesc, catID, catDesc1, parentID from category_tbl where parentID ='0' and status='Y' and catID!='$category_id' order by catOrder Asc");
            }
            while ($sub_res = mysqli_fetch_array($subcat_sql)) {

              if ($sub_res['catImage'] != '') {
                $img_link = getImage($sub_res[catImage], 500, 500, $sub_res[catName], "/uploaded-files/category/images/");
                $img_link1 = getImage($sub_res[catImage], 437, 437, $sub_res[catName], "/uploaded-files/category/images/");
              } else {
                $img_link = getImage("noimage.jpg",  500, 500, "noimages", "/uploaded-files/category/images/");
                $img_link1 = getImage("noimage.jpg", 437, 437, "noimages", "/uploaded-files/category/images/");
              }

              // echo $sub_res['catDesc'];
              $sub_desc = $sub_res['catDesc'];
              $sub_desc = str_ireplace('{companyName}', $admin_res['companyName'], $sub_desc);
            ?>
              <div class="col-12 pr_view">
                <div class="pr-li">
                  <div class="row g-0">
                    <div class="col-lg-4 col-md-5 col-12 g_col">
                      <div class="img_bx">
                        <a class="main-img" href="<?= site_url; ?>/<?= getValidFileName($loc_url); ?>/<?= getValidFileName($sub_res['catName']); ?>.htm"
                          data-bs-toggle="modal" data-bs-target="#productID"
                          onclick="$('.catID').val('<?php echo $sub_res['catID']; ?>');
                                                 $('.catName').html('<?php echo $sub_res['catName']; ?>');
                                                 $('.catImg').attr('src','<?= $img_link1; ?>'); 
                                                 $('.catImg').attr('alt','<?= $sub_res['displayName']; ?> Manufacturers in <?= $locationName; ?>'); 
                                                 $('.catImg').attr('title','<?= $sub_res['displayName']; ?> Manufacturers in <?= $locationName; ?>');"
                          title="<?= $sub_res['displayName']; ?> Manufacturers in <?= $locationName; ?>">

                          <img src="<?= $img_link; ?>"
                            alt="<?= $sub_res['displayName']; ?> Manufacturers in <?= $locationName; ?>"
                            title="<?= $sub_res['displayName']; ?> Manufacturers in <?= $locationName; ?>">
                        </a>
                      </div>
                    </div>

                    <div class="col-lg-8 col-md-7 col-12 g_col">

                      <div class="tx-bx">
                        <div class="title"><a href="<?= site_url; ?>/<?= getValidFileName($loc_url); ?>/<?= getValidFileName($sub_res['catName']); ?>.htm" title="<?= $sub_res['displayName']; ?> Manufacturers in <?= $locationName; ?>"><?= $sub_res['displayName']; ?> in <?= $locationName; ?></a></div>
                        <div class="info">
                          <p><?= substr($sub_desc, 0, 3000); ?></p>
                        </div>

                        <div>
                          <a class="read_more_btn mb-1" href="<?= site_url; ?>/<?= getValidFileName($loc_url); ?>/<?= getValidFileName($sub_res['catName']); ?>.htm"
                            title="Read More">Read More</a>
                          <button class="read_more_btn" data-bs-toggle="modal" data-bs-target="#productID"
                            onclick="$('.catID').val('<?php echo $sub_res['catID']; ?>');
                                                     $('.catName').html('<?php echo $sub_res['catName']; ?>');
                                                     $('.catImg').attr('src','<?= $img_link1; ?>'); 
                                                     $('.catImg').attr('alt','<?= $sub_res['displayName']; ?> Manufacturers in <?= $locationName; ?>'); 
                                                     $('.catImg').attr('title','<?= $sub_res['displayName']; ?> Manufacturers in <?= $locationName; ?>');"
                            title="Get Best Quote">

                            <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                              <path d="M.05 3.555A2 2 0 0 1 2 2h12a2 2 0 0 1 1.95 1.555L8 8.414.05 3.555ZM0 4.697v7.104l5.803-3.558L0 4.697ZM6.761 8.83l-6.57 4.027A2 2 0 0 0 2 14h12a2 2 0 0 0 1.808-1.144l-6.57-4.027L8 9.586l-1.239-.757Zm3.436-.586L16 11.801V4.697l-5.803 3.546Z">
                              </path>
                            </svg> Get Best Quote</button>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
              </div>
            <?php } ?>
          </div>
        </div>
      </div>
    </div>
  </section>
  <?php include "app_award.php"; ?>
  <?php include "app_projects.php"; ?>
  <?php include "app_footer_sub.php"; ?>
  <?php include "app_bottom.php"; ?>

  <script>
    function imgMulti(id, url, elm) {
      document.getElementById(`mainImage${id}`).src = url;
      $(elm).addClass('active').siblings().removeClass('active');
    }
  </script>

</body>

</html>