<?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 = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? "https" : "http") . "://{$_SERVER['HTTP_HOST']}{$_SERVER['REQUEST_URI']}";


$ee = explode('/', $actual_link);

$mm = $ee[3];

$ss = explode('.', $mm);

$cc = $ss[0];

$cat_url = $cc;

$cat = str_replace("-", " ", $cc);

$cats = ucfirst($cat);

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

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


$num = mysqli_num_rows($cat_q);

$cat_r = mysqli_fetch_array($cat_q);

$category_id = $cat_r['catID'];

$hover = 'category';

$catn = $cat_r['catName'];

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

$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'];

$pdes = $cat_res['catDesc'];

$page_desc = $cat_res['catDesc1'];

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

$page_desc1 = $cat_res['catDesc2'];

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

$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'];

$multi_image = explode(',', $cat_res['multi_image']);







// if ($cat_res['catImage'] != '') {

//     $imglink = getImage($cat_res[catImage], 420, 420, $cat_res[catName], "/uploaded-files/category/images/");
// } else {

//     $imglink = getImage("noimage.jpg", 420, 420, "noimages", "/uploaded-files/category/images/");
// }

if ($cat_res['catImage'] != '') {
  $img_file = $cat_res['catImage'];
  $img_path = SITE_DIR_PATH . "/uploaded-files/category/images/" . $img_file;
  $version = file_exists($img_path) ? filemtime($img_path) : time();

  $imglink = getImage($img_file, 420, 420, $cat_res['catName'], "/uploaded-files/category/images/") . '?v=' . $version;
} else {
  $imglink = getImage("noimage.jpg", 420, 420, "noimages", "/uploaded-files/category/images/");
}


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

  // echo "3";

  // exit;

  $m_title = "hotkeyword1 Suppliers in state, hotkeyword2 Distributors Franchise in country";

  $page_metatitle = str_replace('hotkeyword1', $cat_res['keyword1'], str_replace('hotkeyword2', $cat_res['keyword2'],  str_replace('state', $admin_res[targetlocation], str_replace('country', $admin_res[country], $m_title))));

  $m_keyword = "hotkeyword1, hotkeyword2, hotkeyword1 Suppliers, hotkeyword2 Distributors, hotkeyword2 Franchise, hotkeyword1 Distributors, hotkeyword1 Suppliers in state, hotkeyword2 Suppliers in country, hotkeyword2 Suppliers in state";

  $page_metakey = str_replace('hotkeyword1', $cat_res['keyword1'], str_replace('hotkeyword2', $cat_res['keyword2'], str_replace('hotkeyword3', $cat_res['keyword3'], str_replace('state', $admin_res[targetlocation], $m_keyword))));

  $m_desc = "companyName leading hotkeyword1 Suppliers in state, Since 2014. Premium Quality hotkeyword2 Distributors, Franchise in country, Get latest factory price for hotkeyword1. ✓Fast Delivery ✓Good Price";

  $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('hotkeyword3', $cat_res['keyword3'], str_replace('state', $admin_res[targetlocation], str_replace('country', $admin_res[country], $m_desc)))))));
} else if ($cat_res['keyword1'] != '' && $cat_res['keyword2'] != '') {

  // echo "2";

  // exit;

  $m_title = "hotkeyword1 Suppliers in state, hotkeyword2 Distributors Franchise in country";

  $page_metatitle = str_replace('hotkeyword1', $cat_res['keyword1'], str_replace('hotkeyword2', $cat_res['keyword2'],  str_replace('state', $admin_res[targetlocation], str_replace('country', $admin_res[country], $m_title))));

  $m_keyword = "hotkeyword1, hotkeyword2, hotkeyword1 Suppliers, hotkeyword2 Distributors, hotkeyword2 Franchise, hotkeyword1 Distributors, hotkeyword1 Suppliers in state, hotkeyword2 Suppliers in country, hotkeyword2 Suppliers in state";

  $page_metakey = str_replace('hotkeyword1', $cat_res['keyword1'], str_replace('hotkeyword2', $cat_res['keyword2'],  str_replace('state', $admin_res[targetlocation], str_replace('country', $admin_res[country], $m_keyword))));

  $m_desc = "companyName leading hotkeyword1 Suppliers in state, Since 2014. Premium Quality hotkeyword2 Distributors, Franchise in country, Get latest factory price for hotkeyword1. ✓Fast Delivery ✓Good Price";

  $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('state', $admin_res[targetlocation], str_replace('country', $admin_res[country], $m_desc))))));
} else if ($cat_res['keyword1'] != '') {

  // echo "1";

  // exit;

  $m_title = "hotkeyword1 Suppliers in state, Suppliers, Distributors Franchise in country";

  $page_metatitle = str_replace('hotkeyword1', $cat_res['keyword1'], str_replace('state', $admin_res[targetlocation], str_replace('country', $admin_res[country], $m_title)));

  $m_keyword = "hotkeyword1 in state, hotkeyword1 Suppliers in state, hotkeyword1 Suppliers in country, hotkeyword1 Distributors in country, hotkeyword1 in country";

  $page_metakey = str_replace('hotkeyword1', $cat_res['keyword1'], str_replace('state', $admin_res[targetlocation], $m_keyword));

  $m_desc = "companyName leading hotkeyword1 Suppliers in state, Since 2014. Premium Quality hotkeyword1 Suppliers, Distributors in country, Get latest factory price for hotkeyword1. ✓Fast Delivery ✓Good Price";

  $page_metadesc = str_replace('hotkeyword1', $cat_res['keyword1'], str_replace('companyName', $admin_res[companyName], str_replace('phone', $admin_res[mobile_meta], str_replace('state', $admin_res[targetlocation], str_replace('country', $admin_res[country], $m_desc)))));
} else {

  // echo "0";

  // exit;

  $page_metatitle = $cat_res['pageTitle'];

  $page_metakey = $cat_res['pageKeywords'];

  $page_metadesc = $cat_res['pageDescription'];
}


if ($cat_res['catHeading1'] != '') {

  $heading1 = $cat_res['catHeading1'] . ' Suppliers ';
} else {

  $heading1 = $disTitles . ' Suppliers ';
}


if ($cat_res['catHeading2'] != '') {

  $heading2 = $cat_res['catHeading2'] . '<span> Suppliers in ' . $admin_res['targetlocation'] . '</span>';
} else {

  $heading2 = $disTitles . '<span> Suppliers in ' . $admin_res['targetlocation'] . '</span>';
}



if ($cat_res['alt'] != '') {

  $alttag = $cat_res['alt'] . ' Suppliers in ' . $admin_res['targetlocation'];
} else {

  $alttag = $disTitles . ' Suppliers in ' . $admin_res['targetlocation'];
}
if (mysqli_num_rows($cat_q) > 0) { ?>

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

<head>

    <?php include 'app_top.php'; ?>
</head>

<body>
    <?php include 'app_header.php'; ?>
    <div class="breadcum-sec" style="background-image: url(<?= site_url; ?>/designer/images/category-banner.jpg);">
        <div class="container">
            <h1 class="main-tt"><?= $heading1; ?></h1>
            <ul>
                <li><a href="<?= site_url; ?>" title="Home">Home</a></li>
                <?php if ($num4 > 0) { ?>
                <li><a href="<?= site_url; ?>/<?= getValidFileName($cat_res4['catName']); ?>.htm"
                        title="<?php echo $cat_res4['catName']; ?> "><?php echo $cat_res4['catName']; ?></a>
                </li>
                <?php } ?>
                <?php if ($num3 > 0) { ?>
                <li><a href="<?= site_url; ?>/<?= getValidFileName($cat_res3['catName']); ?>.htm"
                        title="<?php echo $cat_res3['catName']; ?>"><?php echo $cat_res3['catName']; ?></a>
                </li>
                <?php } ?>
                <?php if ($num2 > 0) { ?>
                <li>
                    <?php if ($cat_res2['catID'] == '1') { ?>
                    <a href="javascript:void(0);"
                        title="<?php echo $cat_res2['catName']; ?>"><?php echo $cat_res2['catName']; ?></a>
                    <?php } else {  ?>
                    <a href="<?= site_url; ?>/<?= getValidFileName($cat_res2['catName']); ?>.htm"
                        title="<?php echo $cat_res2['catName']; ?>"><?php echo $cat_res2['catName']; ?></a>
                    <?php } ?>
                </li>
                <?php  }  ?>
                <li><?php echo $cat_res['catName']; ?></li>
            </ul>
        </div>
    </div>
    <div class="category-page bg-light">
        <div class="container">
            <div class="cate-img">
                <a href="#productEnquiry" data-bs-toggle="modal" data-bs-target="#productEnquiry"
                    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="Enquire Now">
                    <img src="<?= $imglink; ?>" alt="<?= $alttag; ?>" title="<?= $alttag; ?>">
                </a>
                <div class="btn-bx mt-4 d-flex gap-2 justify-content-center">
                    <button class="main-btn" type="button" data-bs-toggle="modal" data-bs-target="#productEnquiry"
                        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="Get A Quote"><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16"
                            fill="currentColor" class="bi bi-envelope" viewBox="0 0 16 16">
                            <path
                                d="M0 4a2 2 0 0 1 2-2h12a2 2 0 0 1 2 2v8a2 2 0 0 1-2 2H2a2 2 0 0 1-2-2zm2-1a1 1 0 0 0-1 1v.217l7 4.2 7-4.2V4a1 1 0 0 0-1-1zm13 2.383-4.708 2.825L15 11.105zm-.034 6.876-5.64-3.471L8 9.583l-1.326-.795-5.64 3.47A1 1 0 0 0 2 13h12a1 1 0 0 0 .966-.741M1 11.105l4.708-2.897L1 5.383z" />
                        </svg> Get a Quote</button>
                    <button class="w-btn" type="button" data-bs-toggle="modal" data-bs-target="#whatsappEnquiry"
                        title="Chat With Us">
                        <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor"
                            viewBox="0 0 16 16">
                            <path
                                d="M13.601 2.326A7.854 7.854 0 0 0 7.994 0C3.627 0 .068 3.558.064 7.926c0 1.399.366 2.76 1.057 3.965L0 16l4.204-1.102a7.933 7.933 0 0 0 3.79.965h.004c4.368 0 7.926-3.558 7.93-7.93A7.898 7.898 0 0 0 13.6 2.326zM7.994 14.521a6.573 6.573 0 0 1-3.356-.92l-.24-.144-2.494.654.666-2.433-.156-.251a6.56 6.56 0 0 1-1.007-3.505c0-3.626 2.957-6.584 6.591-6.584a6.56 6.56 0 0 1 4.66 1.931 6.557 6.557 0 0 1 1.928 4.66c-.004 3.639-2.961 6.592-6.592 6.592zm3.615-4.934c-.197-.099-1.17-.578-1.353-.646-.182-.065-.315-.099-.445.099-.133.197-.513.646-.627.775-.114.133-.232.148-.43.05-.197-.1-.836-.308-1.592-.985-.59-.525-.985-1.175-1.103-1.372-.114-.198-.011-.304.088-.403.087-.088.197-.232.296-.346.1-.114.133-.198.198-.33.065-.134.034-.248-.015-.347-.05-.099-.445-1.076-.612-1.47-.16-.389-.323-.335-.445-.34-.114-.007-.247-.007-.38-.007a.729.729 0 0 0-.529.247c-.182.198-.691.677-.691 1.654 0 .977.71 1.916.81 2.049.098.133 1.394 2.132 3.383 2.992.47.205.84.326 1.129.418.475.152.904.129 1.246.08.38-.058 1.171-.48 1.338-.943.164-.464.164-.86.114-.943-.049-.084-.182-.133-.38-.232z">
                            </path>
                        </svg>
                        Chat with us</button>
                </div>
            </div>
            <div class="cate-tx">
                <h2 class="main-tt">Looking for <?= $heading2; ?>?</h2>
                <div class="scrollbar-width">
                    <?php echo html_entity_decode($page_desc); ?>
                </div>
            </div>
            <div class="clearfix"></div>
            <div class="head-sec">
                <div class="tt">Most Popular Latest Videos from <span>Our Youtube Channel</span></div>
                <p>Subscribe to our youtube channel for the best Supplements & Reviews</p>
            </div>
            <div class="row g-3 row-cols-1 row-cols-md-2 row-cols-lg-3 pb-4">

                <?php
                  $video_sql = mysqli_query($GLOBALS['dbconn'], "select slink_title, slink_url from video_tbl");
                  while ($video_res = mysqli_fetch_array($video_sql)) { ?>
                        <div class="col">
                    <div class="vidBx">
                        <a href="https://www.youtube.com/watch?v=<?= $video_res['slink_url']; ?>"
                            title="<?= $video_res['slink_title']; ?>" data-fancybox="" class="imgBx">
                            <img src="https://img.youtube.com/vi/<?= $video_res['slink_url']; ?>/sddefault.jpg"
                                alt="<?= $video_res['slink_title']; ?>" title="<?= $video_res['slink_title']; ?>">
                            <span class="video-play-icon">
                                <svg version="1.1" viewBox="0 0 68 48" width="60">
                                    <path class="ytp-large-play-button-bg"
                                        d="M66.52,7.74c-0.78-2.93-2.49-5.41-5.42-6.19C55.79,.13,34,0,34,0S12.21,.13,6.9,1.55 C3.97,2.33,2.27,4.81,1.48,7.74C0.06,13.05,0,24,0,24s0.06,10.95,1.48,16.26c0.78,2.93,2.49,5.41,5.42,6.19 C12.21,47.87,34,48,34,48s21.79-0.13,27.1-1.55c2.93-0.78,4.64-3.26,5.42-6.19C67.94,34.95,68,24,68,24S67.94,13.05,66.52,7.74z"
                                        fill="#f00"></path>
                                    <path d="M 45,24 27,14 27,34" fill="#fff"></path>
                                </svg>
                            </span>
                        </a>
                        <div class="txBx"><?= $video_res['slink_title']; ?></div>
                    </div>
                </div>
                <?php } ?>

            </div>
            <?php
        $whr = ' FIND_IN_SET(' . $cat_res['catID'] . ', product_cat)';
        // $totalcount = mysqli_num_rows(mysqli_query($GLOBALS['dbconn'], "select product_id from product_tbl where   " . $whr . "  order by product_id desc"));
        $totalcount = mysqli_num_rows(mysqli_query($GLOBALS['dbconn'], "SELECT product_id FROM product_tbl WHERE product_status='1' AND " . $whr . " ORDER BY product_id DESC"));
        $product_s = mysqli_query($GLOBALS['dbconn'], "select product_image,product_title,catalog,product_id,product_status,product_video,product_specfi from product_tbl WHERE product_status='1' AND " . $whr . " order by product_id desc limit 6");
        $num = mysqli_num_rows($product_s);
        if ($num > 0) {    ?>
            <div class="you_may mt-4 mb-3">Products Related To <?= $disTitles; ?></div>
            <div class="row g-3 product-container">

                <?php $i = 1;
            while ($product_r = mysqli_fetch_array($product_s)) {
              $pro_image =  explode(',', $product_r['product_image']);
              $probig_img = $pro_image[0];
              $imgname = explode('.', $pro_image[0]);
              $prod_img = getImage($probig_img, 500, 500, $product_r['product_title'] . $imgname[0], "/uploaded-files/product-images/");
              $prod_imgsmall = getImage($probig_img, 50, 50, $product_r['product_title'], "/uploaded-files/product-images/");
            ?>
                <div class="col-12 pr_view productlist">
                    <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="#productEnquiry" data-bs-toggle="modal"
                                        data-bs-target="#productEnquiry"
                                        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']; ?> Suppliers, Distributors, Franchise in <?= $admin_res['targetlocation']; ?>'); $('.catImg').attr('title','<?= $product_r['product_title']; ?> Suppliers, Distributors, Franchise in <?= $admin_res['targetlocation']; ?>');"
                                        title="<?= $product_r['product_title']; ?> Suppliers, Distributors, Franchise in <?= $admin_res['targetlocation']; ?>">
                                        <img id="mainImage<?= $product_r['product_id']; ?>" src="<?= $prod_img; ?>"
                                            class="clickable-image"
                                            alt="<?= $product_r['product_title']; ?> Suppliers, Distributors, Franchise in <?= $admin_res['targetlocation']; ?>"
                                            title="<?= $product_r['product_title']; ?> Suppliers, Distributors, Franchise in <?= $admin_res['targetlocation']; ?>">
                                    </a>
                                    <?php
                        if (!empty($pro_image[1]) || !empty($product_r['product_video'])) {
                        ?>
                                    <div class="multi-imgs">
                                        <?php
                            if (!empty($pro_image[1])) {
                              $snn = 1;
                              foreach ($pro_image as $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, 150, 150, $product_r['product_title'] . $product_r['product_id'] . $snn, '/uploaded-files/product-images/'); ?>"
                                                alt="<?= $product_r['product_title']; ?> Suppliers, Distributors, Franchise in <?= $admin_res['targetlocation']; ?>"
                                                title="<?= $product_r['product_title']; ?> Suppliers, Distributors, Franchise in <?= $admin_res['targetlocation']; ?>">
                                        </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']; ?></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="d-flex gap-2 align-items-center">
                                        <button class="main-btn" data-bs-toggle="modal" data-bs-target="#productEnquiry"
                                            onclick="$('.catID').val('<?php echo $product_r['product_id']; ?>');$('.catName').html('<?php echo $product_r['product_title']; ?>');  $('.catImg').attr('src','<?= site_url; ?>/uploaded-files/product-images/<?= $probig_img; ?>'); $('.catImg').attr('alt','<?= $product_r['product_title']; ?> Suppliers, Distributors, Franchise in <?= $admin_res['targetlocation']; ?>'); $('.catImg').attr('title','<?= $product_r['product_title']; ?> Suppliers, Distributors, Franchise in <?= $admin_res['targetlocation']; ?>');"
                                            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>
                                        <button class="w-btn" type="button" data-bs-toggle="modal"
                                            data-bs-target="#whatsappEnquiry" title="Chat With Us">
                                            <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16"
                                                fill="currentColor" viewBox="0 0 16 16">
                                                <path
                                                    d="M13.601 2.326A7.854 7.854 0 0 0 7.994 0C3.627 0 .068 3.558.064 7.926c0 1.399.366 2.76 1.057 3.965L0 16l4.204-1.102a7.933 7.933 0 0 0 3.79.965h.004c4.368 0 7.926-3.558 7.93-7.93A7.898 7.898 0 0 0 13.6 2.326zM7.994 14.521a6.573 6.573 0 0 1-3.356-.92l-.24-.144-2.494.654.666-2.433-.156-.251a6.56 6.56 0 0 1-1.007-3.505c0-3.626 2.957-6.584 6.591-6.584a6.56 6.56 0 0 1 4.66 1.931 6.557 6.557 0 0 1 1.928 4.66c-.004 3.639-2.961 6.592-6.592 6.592zm3.615-4.934c-.197-.099-1.17-.578-1.353-.646-.182-.065-.315-.099-.445.099-.133.197-.513.646-.627.775-.114.133-.232.148-.43.05-.197-.1-.836-.308-1.592-.985-.59-.525-.985-1.175-1.103-1.372-.114-.198-.011-.304.088-.403.087-.088.197-.232.296-.346.1-.114.133-.198.198-.33.065-.134.034-.248-.015-.347-.05-.099-.445-1.076-.612-1.47-.16-.389-.323-.335-.445-.34-.114-.007-.247-.007-.38-.007a.729.729 0 0 0-.529.247c-.182.198-.691.677-.691 1.654 0 .977.71 1.916.81 2.049.098.133 1.394 2.132 3.383 2.992.47.205.84.326 1.129.418.475.152.904.129 1.246.08.38-.058 1.171-.48 1.338-.943.164-.464.164-.86.114-.943-.049-.084-.182-.133-.38-.232z">
                                                </path>
                                            </svg>
                                            Chat with us</button>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <script>
                $('#small<?= $i; ?> .item').click(function() {
                    $('#bigImage<?= $i; ?> img').attr('src', $(this).attr('src').replace('thumb',
                        'large'));
                    if ($(this).hasClass("active")) {
                        $("#small<?= $i; ?> .item").removeClass("active");
                    } else {
                        $("#small<?= $i; ?> .item").removeClass("active");
                        $(this).addClass("active");
                    }
                });
                </script>
                <?php $i++;
            } ?>
            </div>
            <?php if ($totalcount > $num) { ?>
            <?php echo '<div class="mt-2 text-center" id="loadmore" data-id="' . $whr . '"><i class="fa fa-spinner fa-spin"></i> Loading...</div>';
          } ?>
            <?php } ?>


            <div class="you_may mt-4 mb-3">All Category Range</div>
            <div class="row g-3">
                <!-- loop starts -->
                <?php
          if (mysqli_num_rows($cat_qry) > 0) {

            $subcat_sql = $cat_qry;
          } else {

            $sqlsub2 = mysqli_query($GLOBALS['dbconn'], "select catImage, catName, displayName, catDesc, catID, catDesc1, parentID from category_tbl where parentID ='$parent' and status='1' and catID!='$category_id' order by catOrder Asc");

            if (mysqli_num_rows($sqlsub2) > 1) {



              $subcat_sql = $sqlsub2;
            } else {



              $subcat_sql = mysqli_query($GLOBALS['dbconn'], "select catImage, catName, displayName, catDesc, catID, catDesc1, parentID from category_tbl  where parentID ='0' and status='1' 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], 400, 400, $sub_res[catName], "/uploaded-files/category/images/");

            //     $img_link1 = getImage($sub_res[catImage], 400, 400, $sub_res[catName], "/uploaded-files/category/images/");
            // } else {

            //     $img_link = getImage("noimage.jpg",  400, 400, "noimages", "/uploaded-files/category/images/");

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

              $img_file = $sub_res['catImage'];
              $img_path = SITE_DIR_PATH . "/uploaded-files/category/images/" . $img_file;
              $version = file_exists($img_path) ? filemtime($img_path) : time();

              $img_link = getImage($sub_res['catImage'], 400, 400, $sub_res['catName'], "/uploaded-files/category/images/") . '?v=' . $version;
              $img_link1 = getImage($sub_res['catImage'], 400, 400, $sub_res['catName'], "/uploaded-files/category/images/") . '?v=' . $version;
            } else {

              $img_link = getImage("noimage.jpg", 400, 400, "noimages", "/uploaded-files/category/images/");
              $img_link1 = getImage("noimage.jpg", 400, 400, "noimages", "/uploaded-files/category/images/");
            }


            $caturls1 = !empty($sub_res['catUrl']) ? $sub_res['catUrl'] : $sub_res['catName'];
            $sub_desc = $sub_res['catDesc'];

            $sub_desc = str_ireplace('{companyName}', $admin_res['companyName'], $sub_desc);
          ?>
                <div class="col-3 pr_view">
                    <div class="pr-li">
                        <div class="row g-0">
                            <div class="col-lg-12 col-12 g_col">
                                <div class="img_bx">
                                    <a class="main-img" href="<?= site_url; ?>/<?= getValidFileName($caturls1); ?>.htm"
                                        title="<?= $sub_res['displayName']; ?> Suppliers in <?= $admin_res['targetlocation']; ?>">
                                        <img src="<?= $img_link; ?>"
                                            alt="<?= $sub_res['displayName']; ?> Suppliers in <?= $admin_res['targetlocation']; ?>"
                                            title="<?= $sub_res['displayName']; ?> Suppliers in <?= $admin_res['targetlocation']; ?>">
                                    </a>
                                </div>
                            </div>
                            <div class="col-lg-12 col-12 g_col">
                                <div class="tx-bx p-3">
                                    <h4 class="title"
                                        title="<?= $sub_res['displayName']; ?> Suppliers in <?= $admin_res['targetlocation']; ?>">
                                        <a
                                            href="<?= site_url; ?>/<?= getValidFileName($caturls1); ?>.htm"><?= $sub_res['displayName']; ?></a>
                                    </h4>
                                    <div class="info">
                                        <p><?= $sub_desc; ?>
                                        </p>
                                    </div>
                                    <div class="d-flex gap-2 align-items-center">
                                        <a href="<?= site_url; ?>/<?= getValidFileName($caturls1); ?>.htm"
                                            class="main-btn" title="Read More">Read More</a>
                                        <button class="main-btn light dark" data-bs-toggle="modal"
                                            data-bs-target="#productEnquiry"
                                            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']; ?> Suppliers in <?= $admin_res['targetlocation']; ?>'); $('.catImg').attr('title','<?= $sub_res['displayName']; ?> Suppliers in <?= $admin_res['targetlocation']; ?>');"
                                            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 } ?>
                <!-- loop ends -->






            </div>


        </div>
    </div>

    <!-- <div class="section bg-sec">
        <div class="container">
            <div class="head-sec">
                <div class="tt">Most Popular Latest Videos from <span>Our Youtube Channel</span></div>
                <p>Subscribe to our youtube channel for the best Supplements & Reviews</p>
            </div>
            <div class="row g-3 row-cols-1 row-cols-md-2 row-cols-lg-3">

                <?php
          $video_sql = mysqli_query($GLOBALS['dbconn'], "select slink_title, slink_url from video_tbl");
          while ($video_res = mysqli_fetch_array($video_sql)) { ?>
                <div class="col">
                    <div class="vidBx">
                        <a href="https://www.youtube.com/watch?v=<?= $video_res['slink_url']; ?>"
                            title="<?= $video_res['slink_title']; ?>" data-fancybox="" class="imgBx">
                            <img src="https://img.youtube.com/vi/<?= $video_res['slink_url']; ?>/sddefault.jpg"
                                alt="<?= $video_res['slink_title']; ?>" title="<?= $video_res['slink_title']; ?>">
                            <span class="video-play-icon">
                                <svg version="1.1" viewBox="0 0 68 48" width="60">
                                    <path class="ytp-large-play-button-bg"
                                        d="M66.52,7.74c-0.78-2.93-2.49-5.41-5.42-6.19C55.79,.13,34,0,34,0S12.21,.13,6.9,1.55 C3.97,2.33,2.27,4.81,1.48,7.74C0.06,13.05,0,24,0,24s0.06,10.95,1.48,16.26c0.78,2.93,2.49,5.41,5.42,6.19 C12.21,47.87,34,48,34,48s21.79-0.13,27.1-1.55c2.93-0.78,4.64-3.26,5.42-6.19C67.94,34.95,68,24,68,24S67.94,13.05,66.52,7.74z"
                                        fill="#f00"></path>
                                    <path d="M 45,24 27,14 27,34" fill="#fff"></path>
                                </svg>
                            </span>
                        </a>
                        <div class="txBx"><?= $video_res['slink_title']; ?></div>
                    </div>
                </div>
                <?php } ?>

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

    <?php include 'app_footer.php'; ?>
    <?php include 'app_bottom.php'; ?>
    <script>
    var loading = false;
    $(window).scroll(function() {
        var offset = $("#loadmore").offset().top;
        if ($(window).scrollTop() >= offset - 500) {
            let whr = $("#loadmore").data('id');
            let start = $('.productlist').length;
            if (loading === false) {
                loading = true;
                $.ajax({
                    url: '<?= site_url ?>/ajaxloadcategory.php',
                    data: {
                        whr: whr,
                        start: start,
                        loadmores: '<?= $admin_res['targetlocation']; ?>'
                    },
                    type: 'post',
                    success: function(r) {
                        $('.product-container').append(r);
                        if (r.length > 5) {
                            loading = false;
                        } else {
                            $("#loadmore").remove();
                        }

                        if (start == <?= $totalcount; ?>) {
                            $("#loadmore").remove();
                        }
                    }
                });
            }
        }
    })
    </script>
    <script>
    function imgMulti(id, url, elm) {
        document.getElementById(`mainImage${id}`).src = url;
        $(elm).addClass('active').siblings().removeClass('active');
    }
    </script>
</body>

</html>
<?php
} else {
  header("Location: " . site_url);
  exit;
}
?>