<?php
include 'admin/config.php';
include 'include/include.php';
addpage('header.php',[
    'title'=>'Herbs Ayur'
]);
?>
    <!-- Banner -->
    <div class="owl-carousel home-banner">
        <?php
        $banner = mysqli_query($con,"SELECT `image` FROM `banner` WHERE `status`=1");
        if (mysqli_num_rows($banner)>0) {
            foreach ($banner as $j) {
                ?>
        <div class="item text-white">
            <img src="admin/upload/<?=$j['image']?>" alt="Ayur Herbs" onerror="this.src='assets/img/banner.jpg'">
        </div>
                <?php
            }
        }
        ?>
    </div>


    <!-- Category Section -->
    <section class="section py-3 category-section">
        <div class="section-heading">
            <h2 class="text-center">Find Your Ideal Health Products!</h2>
        </div>
        <div class="container-xl p-3">
            <div class="category-grid">
                <?php
                $allcategory = mysqli_query($con,"SELECT `category_id`,`category_name`,`description`,`slug`,`img` FROM categories");
                if (mysqli_num_rows($allcategory)>0) {
                    foreach ($allcategory as $key => $value) {
                        ?>
                <div class="category-grid-box w-100" style="--box-bg:url(../../admin/subcategory_img/<?=$value['img']?>);">
                    <h4><?=$value['category_name']?></h4>
                    <p><?=$value['description']?></p>
                    <a href="category/<?=$value['category_id']?>/<?=$value['slug']?>">view more</a>
                </div>
                        <?php
                    }
                }
                ?>
            </div>
        </div>
    </section>


    <!-- Category Section -->
    <section class="section py-3 category-section">
        <div class="section-heading">
            <h2 class="text-center">Best Selling Product</h2>
        </div>
        <div class="container-xl py-4">
            <div class="row">
                <?php
                $bestSellingProduct = mysqli_query($con,"SELECT 
                p.product_id,
                p.product_name,
                p.img,
                p.price,
                p.d_price,
                p.slug,
                p.inventory,
                c.category_name
                 FROM products p, categories c WHERE p.top_sellar = 1 AND c.category_id = p.category_id LIMIT 4");
                if (mysqli_num_rows($bestSellingProduct)>0) {
                    foreach ($bestSellingProduct as $key => $value) {
                        ?>
<div class="col-lg-3 col-md-4 col-6 mb-4">
    <div class="product-card product"
        data-id="<?=$value['product_id']?>"
        data-name="<?=$value['product_name']?>"
        data-img="admin/product_img/<?=$value['img']?>"
        data-price="<?=$value['d_price']?>"
    >
        <div class="card">
            <div class="imgBx">
                <a href="product/<?=$value['slug']?>">
                    <img src="admin/product_img/<?=$value['img']?>" alt="" class="img-fluid">
                </a>
            </div>
            <div class="data">
                <p class="cat-name"><?=$value['category_name']?></p>
                
                <h4 class="product-name"><a href="product/<?=$value['slug']?>"><?=$value['product_name']?></a></h4>
                <div class="strars text-center">
                    <i class="fa-solid fa-star text-warning"></i>
                    <i class="fa-solid fa-star text-warning"></i>
                    <i class="fa-solid fa-star text-warning"></i>
                    <i class="fa-solid fa-star text-warning"></i>
                    <i class="fa-solid fa-star text-warning"></i>
                </div>
                <div class="price">
                    <span class="mrp">₹<span class="indianformat"><?=$value['price']?></span></span>
                    <span class="sp">₹<span class="indianformat"><?=$value['d_price']?></span></span>
                </div>
                <?php
                if ($value['inventory'] > 10) {
                    ?>
                <button class="addtocart addtocartbtn">ADD TO CART</button>
                    <?php
                }else{
                    ?>
                <button class="addtocart">Out of Stock</button>
                    <?php
                }
                ?>
                <div class="fixed-btns">
                    <button class="addtowishlist"><i class="fa-solid fa-heart"></i></button>
                    <button class="quickviewbtn"><i class="fa-solid fa-eye"></i></button>
                </div>
            </div>
        </div>
    </div>
</div>
    <?php   
                    }
                    
                }
                ?>
            </div>
        </div>
    </section>
    
    <!-- Feture Products -->
    <section class="section py feture-section">
        <div class="section-heading">
            <h2 class="text-center">Fetured Products</h2>
        </div>
        <div class="container-xl py-4">
            <div class="row align-items-centers">
                <div class="col-md-3 col-sm-6 mx-auto mb-3 text-center">
                    <img src="assets/img/testostrone baner.jpg" class="img-fluid" alt="">
                </div>
                <div class="col-md-9">
                    <div class="curated-slider owl-carousel">
                        <?php
                        $featuredProduct = mysqli_query($con,"SELECT 
                        p.product_id,
                        p.product_name,
                        p.img,
                        p.price,
                        p.d_price,
                        p.slug,
                        p.inventory,
                        c.category_name
                         FROM products p, categories c WHERE p.is_featured = 1 AND c.category_id = p.category_id LIMIT 4");
                if (mysqli_num_rows($featuredProduct)>0) {
                    foreach ($featuredProduct as $key => $value) {
                        ?>

    <div class="product-card product"
        data-id="<?=$value['product_id']?>"
        data-name="<?=$value['product_name']?>"
        data-img="admin/product_img/<?=$value['img']?>"
        data-price="<?=$value['d_price']?>"
    >
        <div class="card">
            <div class="imgBx">
                <a href="product/<?=$value['slug']?>">
                    <img src="admin/product_img/<?=$value['img']?>" alt="" class="img-fluid">
                </a>
            </div>
            <div class="data">
                <p class="cat-name"><?=$value['category_name']?></p>
                
                <h4 class="product-name"><a href="product/<?=$value['slug']?>"><?=$value['product_name']?></a></h4>
                <div class="strars text-center">
                    <i class="fa-solid fa-star text-warning"></i>
                    <i class="fa-solid fa-star text-warning"></i>
                    <i class="fa-solid fa-star text-warning"></i>
                    <i class="fa-solid fa-star text-warning"></i>
                    <i class="fa-solid fa-star text-warning"></i>
                </div>
                <div class="price">
                    <span class="mrp">₹<span class="indianformat"><?=$value['price']?></span></span>
                    <span class="sp">₹<span class="indianformat"><?=$value['d_price']?></span></span>
                </div>
                <?php
                if ($value['inventory'] > 10) {
                    ?>
                <button class="addtocart addtocartbtn">ADD TO CART</button>
                    <?php
                }else{
                    ?>
                <button class="addtocart">Out of Stock</button>
                    <?php
                }
                ?>
                <div class="fixed-btns">
                    <button class="addtowishlist"><i class="fa-solid fa-heart"></i></button>
                    <button class="quickviewbtn"><i class="fa-solid fa-eye"></i></button>
                </div>
            </div>
        </div>
    </div>

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

    <!-- Feture Products -->
    <section class="section py feture-section shop-by-category">
        <div class="section-heading">
            <h2 class="text-center">Shop By Categories</h2>
        </div>
        <div class="container-xl shop-by-category-btns py-4 text-center">
            <?php
                $categories = mysqli_query($con,"SELECT `category_name`,`slug`,`category_id`,`img2` FROM categories WHERE active_to_home = 1");
                if (mysqli_num_rows($categories)>0) {
                    foreach ($categories as $key => $value) {
                        ?>
                        <a href="#category-<?=$value['slug']?>"><?=$value['category_name']?></a>
                        <?php
                    }
                }
            ?>
        </div>
        <?php
        if (mysqli_num_rows($categories)>0) {
            foreach ($categories as $key => $value) {
                $category_id = $value['category_id'];
                $categoryProduct = mysqli_query($con,"SELECT 
                    p.product_id,
                    p.product_name,
                    p.img,
                    p.price,
                    p.d_price,
                    p.slug,
                    p.inventory,
                    c.category_name
                        FROM products p, categories c WHERE p.category_id = $category_id AND c.category_id = p.category_id LIMIT 8");
                if (mysqli_num_rows($categoryProduct)>0) {
                    ?>
        <div class="container-xl py-1" id="category-<?=$value['slug']?>">
            <h3><?=$value['category_name']?></h3>
            <div class="row align-items-centers">
                <div class="col-md-3 col-sm-6 mx-auto mb-3 text-center">
                    <img src="admin/subcategory_img/<?=$value['img2']?>" class="img-fluid" alt="">
                </div>
                <div class="col-md-9">
                    <div class="curated-slider owl-carousel">
                        <?php
                foreach ($categoryProduct as $key => $value) {
                    
                    ?>
                    <div class="product-card buy-now product"
        data-id="<?=$value['product_id']?>"
        data-name="<?=$value['product_name']?>"
        data-img="admin/product_img/<?=$value['img']?>"
        data-price="<?=$value['d_price']?>"
    >
        <div class="card">
            <div class="imgBx">
                <a href="product/<?=$value['slug']?>">
                    <img src="admin/product_img/<?=$value['img']?>" alt="" class="img-fluid">
                </a>
            </div>
            <div class="data">
                <p class="cat-name"><?=$value['category_name']?></p>
                
                <h4 class="product-name"><a href="product/<?=$value['slug']?>"><?=$value['product_name']?></a></h4>
                <div class="strars text-center">
                    <i class="fa-solid fa-star text-warning"></i>
                    <i class="fa-solid fa-star text-warning"></i>
                    <i class="fa-solid fa-star text-warning"></i>
                    <i class="fa-solid fa-star text-warning"></i>
                    <i class="fa-solid fa-star text-warning"></i>
                </div>
                <div class="price">
                    <span class="mrp">₹<span class="indianformat"><?=$value['price']?></span></span>
                    <span class="sp">₹<span class="indianformat"><?=$value['d_price']?></span></span>
                </div>
                <?php
                if ($value['inventory'] > 10) {
                    ?>
                <button class="addtocart addtocartbtn">ADD TO CART</button>
                    <?php
                }else{
                    ?>
                <button class="addtocart">Out of Stock</button>
                    <?php
                }
                ?>
                <div class="fixed-btns">
                    <button class="addtowishlist"><i class="fa-solid fa-heart"></i></button>
                    <button class="quickviewbtn"><i class="fa-solid fa-eye"></i></button>
                </div>
            </div>
        </div>
    </div>
                    <?php
                }
                ?>
                    </div>
                </div>
            </div>
                    <?php
                }
            }
        }
        ?>
        
    </section>

    <?php addpage('testimonials.php') ?>
    <?php addpage('technical-section.php') ?>
    <?php addpage('certificate.php') ?>

    
    
    <section class="section py-4 faq-section">
        <div class="section-heading mb-3">
            <h1>FAQs</h1>
        </div>
        <div class="container-xl">
            <ul class="faq-list">
                <li class="active">
                    <input type="checkbox" id="faq-1" checked>
                    <label for="faq-1" class="question-box">
                        <h6>What are Ayur Herbs Medicines?</h6>
                    </label>
                    <div class="answer-box">
                        <p>
                            Ayur Herbs Medicines are herbal formulations based on ancient Ayurvedic principles. They are made using natural ingredients to promote health and well-being without synthetic chemicals or additives.
                        </p>
                    </div>
                </li>
                <li>
                    <input type="checkbox" id="faq-2">
                    <label for="faq-2" class="question-box">
                        <h6>Are Ayur Herbs Medicines safe to use?</h6>
                    </label>
                    <div class="answer-box">
                        <p>
                            Yes, Ayur Herbs Medicines are made with natural ingredients and are generally safe when used as directed. However, we recommend consulting with a healthcare professional, especially if you are pregnant, nursing, or taking other medications.
                        </p>
                    </div>
                </li>
                <li>
                    <input type="checkbox" id="faq-3">
                    <label for="faq-3" class="question-box">
                        <h6>Do Ayur Herbs Medicines have any side effects?</h6>
                    </label>
                    
                    <div class="answer-box">
                        <p>
                            Herbal medicines are typically well-tolerated, but some individuals may experience mild reactions such as allergies to specific ingredients. It is always advised to read the product label and consult a doctor if you have any concerns.
                        </p>
                    </div>
                </li>
                <li>
                    <input type="checkbox" id="faq-4">
                    <label for="faq-4" class="question-box">
                        <h6>How do I know which product is right for me?</h6>
                    </label>
                    
                    <div class="answer-box">
                        <p>
                            You can check the product descriptions and benefits listed on our website or contact our support team for personalized guidance. You may also consult with an Ayurvedic practitioner for recommendations.
                        </p>
                    </div>
                </li>
            </ul>
        </div>
    </section>

    <section class="section most-view-section py-3" hidden>
        <div class="section-heading noline">
            <h2 class="text-white mb-3">Most Viewed</h2>
        </div>
        <div class="container-xl">
            <div class="row">
                <div class="col-md-4 mb-3">
                    <div class="product-card list-card product"
                        data-id="1"
                        data-name="Garcinia Cambogia"
                        data-img="assets/img/demo-img.png"
                        data-price="2190"
                    >
                        <div class="card">
                            <div class="imgBx">
                                <a href="">
                                    <img src="assets/img/demo-img.png" alt="" class="img-fluid">
                                </a>
                            </div>
                            <div class="data text-start w-100">
                                <h4 class="product-name"><a href="">Garcinia Cambogia</a></h4>
                                <div class="strars text-start">
                                    <i class="fa-solid fa-star text-warning"></i>
                                    <i class="fa-solid fa-star text-warning"></i>
                                    <i class="fa-solid fa-star text-warning"></i>
                                    <i class="fa-solid fa-star text-warning"></i>
                                    <i class="fa-solid fa-star text-warning"></i>
                                </div>
                                <div class="price">
                                    <span class="mrp">₹<span class="indianformat">2490</span></span>
                                    <span class="sp">₹<span class="indianformat">2190</span></span>
                                </div>
                                <button class="addtocart buynowbtn">Buy now</button>
                                <div class="fixed-btns">
                                    <button class="addtowishlist"><i class="fa-solid fa-heart"></i></button>
                                    <button class="quickviewbtn"><i class="fa-solid fa-eye"></i></button>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-md-4 mb-3">
                    <div class="product-card list-card product"
                        data-id="1"
                        data-name="Garcinia Cambogia"
                        data-img="assets/img/demo-img.png"
                        data-price="2190"
                    >
                        <div class="card">
                            <div class="imgBx">
                                <a href="">
                                    <img src="assets/img/demo-img.png" alt="" class="img-fluid">
                                </a>
                            </div>
                            <div class="data text-start w-100">
                                <h4 class="product-name"><a href="">Garcinia Cambogia</a></h4>
                                <div class="strars text-start">
                                    <i class="fa-solid fa-star text-warning"></i>
                                    <i class="fa-solid fa-star text-warning"></i>
                                    <i class="fa-solid fa-star text-warning"></i>
                                    <i class="fa-solid fa-star text-warning"></i>
                                    <i class="fa-solid fa-star text-warning"></i>
                                </div>
                                <div class="price">
                                    <span class="mrp">₹<span class="indianformat">2490</span></span>
                                    <span class="sp">₹<span class="indianformat">2190</span></span>
                                </div>
                                <button class="addtocart buynowbtn">Buy now</button>
                                <div class="fixed-btns">
                                    <button class="addtowishlist"><i class="fa-solid fa-heart"></i></button>
                                    <button class="quickviewbtn"><i class="fa-solid fa-eye"></i></button>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-md-4 mb-3">
                    <div class="product-card list-card product"
                        data-id="1"
                        data-name="Garcinia Cambogia"
                        data-img="assets/img/demo-img.png"
                        data-price="2190"
                    >
                        <div class="card">
                            <div class="imgBx">
                                <a href="">
                                    <img src="assets/img/demo-img.png" alt="" class="img-fluid">
                                </a>
                            </div>
                            <div class="data text-start w-100">
                                <h4 class="product-name"><a href="">Garcinia Cambogia</a></h4>
                                <div class="strars text-start">
                                    <i class="fa-solid fa-star text-warning"></i>
                                    <i class="fa-solid fa-star text-warning"></i>
                                    <i class="fa-solid fa-star text-warning"></i>
                                    <i class="fa-solid fa-star text-warning"></i>
                                    <i class="fa-solid fa-star text-warning"></i>
                                </div>
                                <div class="price">
                                    <span class="mrp">₹<span class="indianformat">2490</span></span>
                                    <span class="sp">₹<span class="indianformat">2190</span></span>
                                </div>
                                <button class="addtocart buynowbtn">Buy now</button>
                                <div class="fixed-btns">
                                    <button class="addtowishlist"><i class="fa-solid fa-heart"></i></button>
                                    <button class="quickviewbtn"><i class="fa-solid fa-eye"></i></button>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
<?php
addpage('footer.php');
?>