bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php 
    include"function.php";
    session_start();
    
    $sessionId = session_id();
    $userId = isset($_SESSION['user_id']) ? $_SESSION['user_id'] : null;
    $uniqid ='';
    // Fetch cart data
    $cartData = fetchCartData($conn, $uniqid, $sessionId, $userId);

// $totalPrice = 0; // Initialize total price
    if ($cartData !== false) {
        $cartItems = $cartData['items'];
        $totalPrice = $cartData['totalAmount'];
        $totalItems = $cartData['totalCount'];
    }
    
?>
<!DOCTYPE html>
<html lang="en">
    
<head>
        
        <title>My Account | Electro - Responsive Website Template</title>

<meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

<?php include"include/links.php";?>
</head>

<body>

<?php include"include/header.php";?>

<main id="content" role="main">
            
            <div class="bg-gray-13 bg-md-transparent">
                <div class="container">
                    
                    <div class="my-md-3">
                        <nav aria-label="breadcrumb">
                            <ol class="breadcrumb mb-3 flex-nowrap flex-xl-wrap overflow-auto overflow-xl-visble">
                                <li class="breadcrumb-item flex-shrink-0 flex-xl-shrink-1"><a href="index.php">Home</a></li>
                                <li class="breadcrumb-item flex-shrink-0 flex-xl-shrink-1 active" aria-current="page">My Account</li>
                            </ol>
                        </nav>
                    </div>
                    
                </div>
            </div>

<div class="container">
                <div class="mb-4">
                    <h1 class="text-center">Order Details</h1>
                </div>
                <div class="my-4 my-xl-12">
                    
                    <?php
                        $sno = 1;
                        
                        // die();
                        $id = $_GET['order_id'];
                        $sessid = $_GET['sessid'];
                        $sql = "select * from order_details where Unique_order_id = '$id'";
                        $query = mysqli_query($conn, $sql);
                        $fetch = mysqli_fetch_array($query);
                        $uniqid = $fetch['Unique_order_id'];
                        $seasson_id = $fetch['seasson_id'];
                        
                        $sql1 = "select * from cart where uniqid = '$uniqid'";
                        $query1 = mysqli_query($conn, $sql1);
                        
                        
                        
        
                        
                        
                        $price_total = $fetch["total_price"];
                        $sql_shipp = "SELECT * FROM shipping_changes WHERE ? BETWEEN min_price AND max_price";
                        $stmt = $conn->prepare($sql_shipp);
                        $stmt->bind_param("i", $price_total);
                        $stmt->execute();
                        $result = $stmt->get_result();
                        $rowshipp = $result->fetch_assoc();
                        if($result -> num_rows > 0){
                            $shipping_charge .= '
                                <tr>
                                    <td colspan=""></td>
                                    <td colspan=""></td>
                                                                
                                    <td style="font-weight:900;" colspan="2">Shipping Charges</td>
                                    <td style="font-weight:900; text-align:center;">$'.$rowshipp['given_price'].'</td>
                                </tr>
                            ';
                                                     
                        }
                        
                        $coupon_sql = "select * from coupon_user where session_id = '$seasson_id' ORDER BY use_id DESC LIMIT 1";
                        $coupon_query = mysqli_query($conn, $coupon_sql);
                        $coupon_data = mysqli_fetch_array($coupon_query);
                        $coupon_use_id = $coupon_data['coupon_id']; 
                        $coupon_status = $coupon_data['status'];
                        
                       
                        $coup_sql = "SELECT * FROM `coupon` WHERE coupon_id = '$coupon_use_id'";
                        $coup_query = mysqli_query($conn, $coup_sql);
                        $coup_data = mysqli_fetch_array($coup_query);
                        $coup_price = $coup_data['price'];
                        $coup_type = $coup_data['type']; 
                            
                    ?>
                    <div class="">
                        <div class=""> 
                          <div class="">
                            <div class="card">
                                <div id="printableArea" style="width:100%; max-width:800px; margin:auto; padding:25px;">
                        			<div style="display:flex; flex-wrap:wrap;">
                        				<div style="width:calc(50% - 20px); margin:10px;  text-align:left;">
                        					<div><img src="https://vintagewatcholic.com/assets/img/vintagewatcholiclogo8.png" width="100px"  height="50px";  alt=""></div>
                        					<p style="margin:0;">Gentleman Watch Co.</p>
                        					<p style="margin:0;">GSTIN : 07AVXPA7708D1ZG</p>
                        					<p style="margin:0;">C-40 DDA Colony West,<br>
                                                                    Gorakhpark Shahadara,
                                                                    <br>
                                                                    Delhi-110032</p>
                        					<p style="margin:0;">info@vintagewatcholic.com</p>
                        				</div>
                        				<div style="width:calc(50% - 20px); margin:10px;  text-align:right;">
                        					<h2 style="margin-top:0px;">INVOICE</h2>
                        					<p style="font-weight:900; margin-bottom:0;">Shipping Address</p>
                        					<p style="margin:0;"><?= $fetch["name"]?><br> <?= $fetch["address"]?> <br> <?= $fetch["state"]?> <br> <?= $fetch["zip"]?> </p>
                        					<p style="margin:0;">Mobile No : <span style="color:black;"><?= $fetch["mobile"]?></span> </p>
                        					<p style="margin:0;">Payment Type : <span style="color:black;"><?= $fetch["payment_type"]?></span> </p>
                        				</div>
                        			</div>
                        			<hr>
                        			<div style="display:flex; flex-wrap:wrap; text-align:center	;">
                        				<div style="width:33.33% ">
                        					<h5 style="color:red;">Issue Date : <span style="color:black;"><?= $fetch["order_date"]?></span></h5>
                        				</div>
                        				<div style="width:33.33% ">
                        					<h5 style="color:red;">Order No. : <span style="color:black;"><?= "VW".$fetch["invoice_no"]?></span></h5>
                        				</div>
                        				<div style="width:33.33% ">
                        					<h5 style="color:red;">Email : <span style="color:black;"><?= $fetch["email"]?></span></h5>
                        				</div>
                        				
                        			</div>
                        			<hr>
                        			<table style="width:100%;">
                        			  <thead>
                                        <tr>
                                            <th scope="col">Images</th>
                                            <th  scope="col">Product</th>
                                            <th scope="col">price</th>
                                            <th scope="col">QTY.</th>
                                            <th scope="col">TOTAL</th>
                                        </tr>
                                      </thead>
                        			  <tbody>
                        			        <?php 
                                                $total = 0; // Initialize the total variable
            
                                                while ($fetch1 = mysqli_fetch_assoc($query1)) {
                                                    $rowTotal = $fetch1['pprice'] * $fetch1['quantity'];
                                                    $total += $rowTotal; // Accumulate the total
                                                
                                                    echo '<tr>';
                                                    echo '<td colspan=""><img src="admin/images/' . $fetch1['pimages'] . '" width="100px"  height="100px";> </td>';
                                                    echo '<td colspan="">' . $fetch1['pname'] . '</td>';
                                                    echo '<td colspan="">' . $fetch1['pprice'] . '</td>';
                                                    echo '<td colspan="">' . $fetch1['quantity'] . '</td>';
                                                    echo '<td colspan="">' . $rowTotal . '</td>';
                                                    echo '</tr>';
                                                }
                                                
                                                
                                                
                                                $price_total = $total;
                                                $sql_shipp = "SELECT * FROM shipping_changes WHERE ? BETWEEN min_price AND max_price";
                                                $stmt = $conn->prepare($sql_shipp);
                                                $stmt->bind_param("i", $price_total);
                                                $stmt->execute();
                                                $result = $stmt->get_result();
                                                
                                                if($result -> num_rows > 0){
                                                   $rowshipp = $result->fetch_assoc();                          
                                                }
                                            ?>
            
                        			  </tbody>  
                                      <tfoot>
                                        <tr>
                                             <td colspan=""></td>
                                            <td colspan=""></td>
                                            <td colspan="2">
                                                
                                                <?php
                                                    if($fetch['DiscountPrice'] != ''){
                                                        if($fetch['DiscountPrice'] != ''){
                                                        ?>
                                                        Discount =   -$<?= $fetch['DiscountPrice'];?> /-
                                                        <?php
                                                            }else{
                                                        ?>
                                                        Discount    <?= $fetch['DiscountPrice'];?> %
                                                        <?php
                                                            
                                                        }
                                                    }    
                                                ?>
                                                <br>
                                                shipping Charges = Free /-<br>
                                                
                                                <?php 
                                                    if($fetch['payment_type'] ==  'COD'){
                                                ?>
                                                    <br>
                                                    Paid Amount = -500 /-<br>
                                                    <span style="font-weight:900; text-align:center;">Grand Total = &#8377;<?= $fetch["total_price"] - 500?> /- <br></span>
                                                <?php 
                                                    }else{
                                                ?>
                                                
                                                    <span style="font-weight:900; text-align:center;">Grand Total = &#8377;<?= $fetch["total_price"]?> /- <br></span>
                                                <?php 
                                                    }
                                                ?>
                                                
                                            </td>
                                        </tr>
                                      </tfoot>
                        			</table>
                        			
                        		</div>
                        		<div class="text-center">
                        		    
                        		</div>
                            </div>
                          </div>
                        </div>
                    </div></div>
                </div>
            </div>
        </main>

<?php include"include/footer.php"; ?>

<?php include"include/script.php";?>

<script>
            $(window).on('load', function () {
                // initialization of HSMegaMenu component
                $('.js-mega-menu').HSMegaMenu({
                    event: 'hover',
                    direction: 'horizontal',
                    pageContainer: $('.container'),
                    breakpoint: 767.98,
                    hideTimeOut: 0
                });
            });

$(document).on('ready', function () {
                // initialization of header
                $.HSCore.components.HSHeader.init($('#header'));

// initialization of animation
                $.HSCore.components.HSOnScrollAnimation.init('[data-animation]');

// initialization of unfold component
                $.HSCore.components.HSUnfold.init($('[data-unfold-target]'), {
                    afterOpen: function () {
                        $(this).find('input[type="search"]').focus();
                    }
                });

// initialization of HSScrollNav component
                $.HSCore.components.HSScrollNav.init($('.js-scroll-nav'), {
                  duration: 700
                });

// initialization of quantity counter
                $.HSCore.components.HSQantityCounter.init('.js-quantity');

// initialization of popups
                $.HSCore.components.HSFancyBox.init('.js-fancybox');

// initialization of countdowns
                var countdowns = $.HSCore.components.HSCountdown.init('.js-countdown', {
                    yearsElSelector: '.js-cd-years',
                    monthsElSelector: '.js-cd-months',
                    daysElSelector: '.js-cd-days',
                    hoursElSelector: '.js-cd-hours',
                    minutesElSelector: '.js-cd-minutes',
                    secondsElSelector: '.js-cd-seconds'
                });

// initialization of malihu scrollbar
                $.HSCore.components.HSMalihuScrollBar.init($('.js-scrollbar'));

// initialization of forms
                $.HSCore.components.HSFocusState.init();

// initialization of form validation
                $.HSCore.components.HSValidation.init('.js-validate', {
                    rules: {
                        confirmPassword: {
                            equalTo: '#signupPassword'
                        }
                    }
                });

// initialization of forms
                $.HSCore.components.HSRangeSlider.init('.js-range-slider');

// initialization of show animations
                $.HSCore.components.HSShowAnimation.init('.js-animation-link');

// initialization of fancybox
                $.HSCore.components.HSFancyBox.init('.js-fancybox');

// initialization of slick carousel
                $.HSCore.components.HSSlickCarousel.init('.js-slick-carousel');

// initialization of go to
                $.HSCore.components.HSGoTo.init('.js-go-to');

// initialization of hamburgers
                $.HSCore.components.HSHamburgers.init('#hamburgerTrigger');

// initialization of unfold component
                $.HSCore.components.HSUnfold.init($('[data-unfold-target]'), {
                    beforeClose: function () {
                        $('#hamburgerTrigger').removeClass('is-active');
                    },
                    afterClose: function() {
                        $('#headerSidebarList .collapse.show').collapse('hide');
                    }
                });

$('#headerSidebarList [data-toggle="collapse"]').on('click', function (e) {
                    e.preventDefault();

var target = $(this).data('target');

if($(this).attr('aria-expanded') === "true") {
                        $(target).collapse('hide');
                    } else {
                        $(target).collapse('show');
                    }
                });

// initialization of unfold component
                $.HSCore.components.HSUnfold.init($('[data-unfold-target]'));

// initialization of select picker
                $.HSCore.components.HSSelectPicker.init('.js-select');
            });
        </script>
    </body>

</html>