<?php
include 'admin/config.php';
include 'include/include.php';
addpage('header.php',['title'=>'New Arrivals']);
?>
<section class="section my-5"> 
    <div class="container">
        <div class="text-center my-4">
            <h5>New Arrivals</h5>
            <p>
                Uttranchali's new collection features the latest ethnic fashion, particularly seasonal attire. You may select festive appropriate kurtas to suit sets from the new arrivals department both online and in-store. The new arrivals section is ideal for folks who enjoy changing up their wardrobe with each season.
            </p>
        </div>
        <div class="row">
            <div class="col-md-3 mb-2">

            </div>
            <div class="col-md-12 mb-2">
                <div class="d-flex mb-3 filter-row align-items-center justify-content-between">
                    <div class="d-inline-flex align-items-center">
                        <h6 class="m-0 me-2">VIEW AS</h6>
                        <div class="toolbar-item toolbar-viewAs clearfix" data-view-as="">
                            <span class="toolbar-icon icon-mode icon-mode-list" data-col="1" role="button" aria-label="List" tabindex="0"></span>
                            <span class="toolbar-icon icon-mode icon-mode-grid grid-2" data-col="2" role="button" aria-label="Grid 2" tabindex="0"></span>
                            <span class="toolbar-icon icon-mode icon-mode-grid grid-3 d-sm-inline-block d-none" data-col="3" role="button" aria-label="Grid 3" tabindex="0"></span>
                            <span class="toolbar-icon icon-mode icon-mode-grid grid-4 active d-sm-inline-block d-none" data-col="4" role="button" aria-label="Grid 4" tabindex="0"></span>
                        </div>
                    </div>
                    <div class="d-inline-flex align-items-center">
                        <h6 class="m-0 me-2">SORT BY</h6>
                        <select name="order" class="sort-display-data" id="sort-display-data">
                            <option value="default">Relevance</option>
                            <option value="topsell">Top Seller</option>
                            <option value="name-asc">Name A - Z</option>
                            <option value="name-desc">Name Z - A</option>
                            <option value="price-asc">Price 1 - 9</option>
                            <option value="price-desc">Price 9 - 1</option>
                        </select>
                    </div>
                </div>
                <div class="grid-list-container" style="--col:4;" id="container-shop-by-brands"> 
                    <?php
                    $where = 'ORDER BY product_id DESC';
                    $newArrivals = mysqli_query($con,"SELECT `product_id`,`product_name`,`img`,`img_gallery`,`price`,`slug`,`d_price`,`short_desc`,`inventory` FROM `products` ".$where." LIMIT 0,8");
                    if (mysqli_num_rows($newArrivals)>0) {
                        foreach ($newArrivals as $key => $value) {
                                ?>
                            <div class="" data-img="admin/product_img/<?=$value['img']?>" 
                                    data-price="<?=$value['d_price']?>" 
                                    data-name="<?=$value['product_name']?>" 
                                    data-id="<?=$value['product_id']?>" 
                                    ata-topsell="1"
                                    data-description="<?=$value['short_desc']?>" >
                                <div class="product-card product" 
                                    data-img="admin/product_img/<?=$value['img']?>" 
                                    data-price="<?=$value['d_price']?>" 
                                    data-name="<?=$value['product_name']?>" 
                                    data-id="<?=$value['product_id']?>" 
                                    data-description="<?=$value['short_desc']?>" 
                                    >
                                    <div class="product-badges">
                                        <div class="discount">
                                            <?php
                                            $principal = $value['price'];
                                            $d_price = $value['d_price'];
                                            $per_price = ($d_price * 100)/$principal;
                                            echo ceil(100 - $per_price) . '% OFF';
                                            ?>
                                        </div>
                                    </div>
                                    <div class="actionbtn">
                                        <button data-text="Add to Wishlist" class="addtowishlist">
                                            <i class="fa-solid fa-heart"></i>
                                        </button>
                                        <button data-text="Quick View" class="quickviewbtn">
                                            <i class="fa-solid fa-eye"></i>
                                        </button>
                                    </div>
                                    <a href="javascript:void(0)">
                                        <div class="imgBx ">
                                            <img src="admin/product_img/<?=$value['img']?>" class="img-fluid w-100" alt="Uttranchali">
                                            <?php
                                            if (empty($value['img_gallery'])) {
                                                
                                            }else{
                                                $s_img =  $value['img_gallery'];
                                                $img_arr = explode(',',$s_img);
                                                
                                                ?>
                                            <img src="admin/product_img_gallery/<?=$img_arr[0]?>" onerror="this.src='admin/product_img/<?=$value['img']?>'" class="img-fluid w-100" alt="Uttranchali">
                                                <?php
                                            }
                                            ?>
                                            <?php
                                            if ($value['inventory'] > 0) {
                                                ?>
                                                <button href="javascript:void(0)" class="choose-option addtocartbtn">Add to Cart</button>
                                                <?php
                                            }else{
                                                ?>
                                                <button href="javascript:void(0)" class="choose-option">Out Of Stock</button>
                                                <?php
                                            }
                                            ?>
                                        </div>
                                    </a>
                                    <div class="product-info mt-3">
                                        
                                        <h4><a href="product/<?=$value['slug']?>"><?=$value['product_name']?></a></h4>
                                        <div class="price">
                                           <span class="mrp me-2">₹ <span class="indianformat"><?=$value['price']?></span></span> 
                                           <span class="sp">₹ <span class="indianformat"><?=$value['d_price']?></span></span> 
                                        </div>
                                    </div>
                                </div>
                            </div>
                                <?php
                            }
                        }else{
                            ?>
                            <div class="col-12">
                                <h5 class="text-center">No Product Available</h5>
                            </div>
                            <?php
                        }
                            ?>
                    
                </div>
                <div class="my-3 text-center">
                    <button class="bg-transparent" id="loadmore-shop-by-brands" data-query="<?=$where?>">Load more <i class="fa-solid fa-plus"></i></button>
                </div>
            </div>
        </div>
    </div>
</section>
<?php
addpage('bulletpoints.php');
addpage('newslatter.php');
addpage('footer.php');
?>