<?php 
session_start();
// if(!isset($_SESSION['id'])){
//     header('location:index.php');
// }

include('header.php');
include('connect.php');
$user_id=$_SESSION['id'];

$sql="SELECT * FROM settings WHERE  variable='system_timezone'";
$res_time = mysqli_query($con,$sql);
if(!empty($res_time)){
    foreach ($res_time as $row){
        $id = $row['id'];
        $data = json_decode($row['value'], true);
    }
}

$user_data=mysqli_query($con,"SELECT * FROM users WHERE id='$user_id'");
$user=mysqli_fetch_array($user_data);

?>

<?php
$sub_total=0;
if (isset($_SESSION['id'])) {
    $login_url = 'checkout.php';
    $quer=$con->query("SELECT * FROM order_items Where user_id='$user_id' and active_status=''");
    $total_item = mysqli_num_rows($quer);
    while($products=mysqli_fetch_array($quer)){
        $pr_vr_id=$products['product_variant_id'];
        $join="SELECT *,products.id as product_id FROM products INNER JOIN product_variant ON products.id = product_variant.product_id WHERE product_variant.id='$pr_vr_id'";
        $res_join=mysqli_query($con,$join);
        $row_join=mysqli_fetch_array($res_join);
        $sub_total+=$row_join['discounted_price']*$products['quantity'];
    }
}else{
    $login_url = 'login.php';
    foreach ($_SESSION['cart'] as $pr_id => $cart_item) { 
        $pr_vr_id=$pr_id;
        $join="SELECT *,products.id as product_id FROM products INNER JOIN product_variant ON products.id = product_variant.product_id WHERE product_variant.id='$pr_vr_id'";
        $res_join=mysqli_query($con,$join);
        $row_join=mysqli_fetch_array($res_join);
        $sub_total+=$row_join['discounted_price']*$cart_item['quantity'];
    }
}

if($sub_total>=$data['min_amount']){ 
    $delivery_charge = '0'; 
} else{
    $delivery_charge = $data['delivery_charge']; 
}
$total_amount = $sub_total+$delivery_charge;
?>

<section id="load" class="checkout-section py-lg-4 py-3">
    <div class="container-fluid">
        <div class="row">
            <div class="col-md-8">
                <?php
                $query=mysqli_query($con,"SELECT * FROM user_location   WHERE user_id='".$_SESSION['id']."' LIMIT 1");
                $location=mysqli_fetch_array($query);
                ?>

                <div class="card">
                    <div class="card-body">
                        <input class="mnamnt" type="hidden" name="" value="<?php   echo $data['min_amount']; ?>">
                        <input type="hidden" name="" class="dlvset" value="<?php  echo $data['delivery_charge']; ?>">
                        <h5>Deliver Address <a href="<?=$login_url?>" class="btn btn-theme float-right">CHANGE</a></h5>
                        <p><b><?=$user['name'];?></b> <?php if(!empty($location['address'])){ echo $location['address'];?>, <?=$location['city'];?>, <?=$location['state'];?> - <b><?=$location['pincode']; }?></b></p>
                    </div>
                </div>
                <div class="card mt-3" id="card_items">
                    <div class="card-header">
                        <div class="card-title">Order Summary</div>
                    </div>
                    <?php
                    if (isset($_SESSION['id'])) {
                        $query=$con->query("SELECT order_items.*,colors.color_name FROM order_items LEFT JOIN colors ON order_items.color = colors.id Where user_id='$user_id' and active_status=''");
                        while($product=mysqli_fetch_array($query)){
                            $pr_vr_id=$product['product_variant_id'];
                            $join="SELECT *,products.id as product_id FROM products INNER JOIN product_variant ON products.id = product_variant.product_id WHERE product_variant.id='$pr_vr_id'";
                            $res_join=mysqli_query($con,$join);
                            $row_join=mysqli_fetch_array($res_join);
                            $or_id=$or_id.','.$row_join['id'];
                            $img=$row_join['image'];
                            $dis=intval($row_join['price'])-intval($row_join['discounted_price']);
                            if($dis>0){ $ds= floor($dis*100/$row_join['price']);} else{$ds= '0';}

                            $product_id = $row_join['product_id'];
                            $color_id = $product['color'];

                            $product_color_variant_query=$con->query("SELECT * FROM product_color_variant WHERE color_id='$color_id' AND product_id='$product_id'");
                            if ($product_color_variant_query->num_rows>0) {
                                $product_color_variant = $product_color_variant_query->fetch_assoc();
                                $img = $product_color_variant['image'];
                            }
                            ?>
                            <div class="card-body">
                                <div class="row">
                                    <div class="col-lg-4 col-5">
                                        <div class="product-img text-center">
                                            <img src="admin/<?=$img;?>">
                                            <div class="input-group mb-3">
                                                <span class="input-group-btn itm-minu mr-lg-2">
                                                    <button type="button" class="quantity-left-minus btn"  data-type="minus" data-field="" onclick="redpro(<?php  echo $product['id']; ?>,<?php echo $row_join['discounted_price'];?>)">
                                                        <i class="fa fa-minus"></i>
                                                    </button>
                                                </span>
                                                <input type="text" id="quantity" value="<?php echo $product['quantity']; ?>" name="quantity" class="quantity<?php echo $product['id']; ?> input-number" min="1" max="100" readonly style="color: #000!important;">
                                                <span class="input-group-btn itm-add ml-lg-2">
                                                    <button type="button" class="quantity-right-plus btn " data-type="plus" data-field="" onclick="pluspro(<?php  echo $product['id']; ?>,<?php echo $row_join['discounted_price'];?>)">
                                                        <i class="fa fa-plus"></i>
                                                    </button>
                                                </span>

                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-lg-8 col-7">
                                        <div class="product-details">
                                            <h5><?php echo $row_join['name'];?></h5>
                                            <?php if($row_join['assured']==1){ ?><span class="badge badge-primary"><img src="images/assured.png" style="width: 20px;height: 20px"> Assured</span><?php } ?>

                                            <div class="price-part">
                                                <del><span>₹<?php echo $row_join['price'];?> </span></del> <span class="product-price">₹<?php echo $row_join['discounted_price'];?> </span> <span class="discount"><?=$ds; ?>% off</span>
                                                <p class="mb-0">Color: <?=$product['color_name'];?> </p>
                                                <p class="mb-0 mt-2 mt-lg-0">Size: <?=$row_join['measurement'];?>  <a href="javascript:void[0]" type="button" onclick="remove_item(<?=$product['id'];?>)" class="font-weight-bold remove-item pl-lg-5">REMOVE</a></p>
                                            </div>

                                        </div>
                                    </div>
                                </div>
                            </div>
                            <?php 
                        } 
                    }
                    else
                    { 
                     foreach ($_SESSION['cart'] as $pr_id => $cart_item) { 
                        $pr_id = $cart_item['pr_id'];
                        $join="SELECT *,products.id as product_id FROM products INNER JOIN product_variant ON products.id = product_variant.product_id WHERE product_variant.id='$pr_id'";
                        $res_join=mysqli_query($con,$join);
                        $row_join=mysqli_fetch_array($res_join);
                        $product['id'] = intval($pr_id);
                        $or_id=$or_id.','.$row_join['id'];
                        $img=$row_join['image'];
                        $dis=intval($row_join['price'])-intval($row_join['discounted_price']);
                        if($dis>0){ $ds= floor($dis*100/$row_join['price']);} else{$ds= '0';}

                        $product_id = $row_join['product_id'];
                        $color_id = $cart_item['color'];
                        $colours=$con->query("SELECT colors.color_name FROM colors Where id='$color_id'");
                        $coloursdata = $colours->fetch_assoc();

                        $product_color_variant_query=$con->query("SELECT * FROM product_color_variant WHERE color_id='$color_id' AND product_id='$product_id'");
                        if ($product_color_variant_query->num_rows>0) {
                            $product_color_variant = $product_color_variant_query->fetch_assoc();
                            $img = $product_color_variant['image'];
                        }
                        ?>
                        <div class="card-body">
                            <div class="row">
                                <div class="col-lg-4">
                                    <div class="product-img text-center">
                                        <img src="admin/<?=$img;?>">
                                        <div class="input-group mb-3">
                                            <span class="input-group-btn itm-minu mr-2">
                                                <button type="button" class="quantity-left-minus btn"  data-type="minus" data-field="" onclick="redpro('<?=$product['id'].'-'.$color_id;?>',<?php echo $row_join['discounted_price'];?>)">
                                                    <i class="fa fa-minus"></i>
                                                </button>
                                            </span>
                                            <input type="text" id="quantity" value="<?php echo $cart_item['quantity']; ?>" name="quantity" class="quantity<?=$product['id'].'-'.$color_id;?> input-number"  min="1" max="100" readonly style="color: #000!important;">
                                            <span class="input-group-btn itm-add ml-2">
                                                <button type="button" class="quantity-right-plus btn " data-type="plus" data-field="" onclick="pluspro('<?=$product['id'].'-'.$color_id;?>',<?php echo $row_join['discounted_price'];?>)">
                                                    <i class="fa fa-plus"></i>
                                                </button>
                                            </span>

                                        </div>
                                    </div>
                                </div>
                                <div class="col-lg-8">
                                    <div class="product-details">
                                        <h5><?php echo $row_join['name'];?></h5>
                                        <?php if($row_join['assured']==1){ ?><span class="badge badge-primary"><img src="images/assured.png" style="width: 20px;height: 20px"> Assured</span><?php } ?>

                                        <div class="price-part">
                                            <del><span>₹<?php echo $row_join['price'];?> </span></del> <span class="product-price">₹<?php echo $row_join['discounted_price'];?> </span> <span class="discount"><?=$ds; ?>% off</span>
                                            <p class="mb-0">Color: <?=$coloursdata['color_name'];?> </p>
                                            <p class="mb-0 mt-2 mt-lg-0">Size: <?=$row_join['measurement'];?>  <a href="javascript:void[0]" type="button" onclick="remove_item('<?=$product['id'].'-'.$color_id;?>')" class="font-weight-bold remove-item pl-5">REMOVE</a></p>
                                        </div>

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

                    <?php } } ?>

                </div>
                <?php if ($total_cart_items!=0) { ?>
                    <div class="card mt-3">
                        <div class="card-body">

                            <div class="row align-items-center">
                                <div class="col-lg-8">

                                </div> 
                                <div class="col-lg-4">
                                    <a href="<?=$login_url?>" class="btn btn-theme float-right">Place Order</a>
                                </div>
                            </div>
                        </div>
                    </div>
                <?php } ?>
            </div>

            <div class="col-md-4">
                <div class="card price-details">
                    <div class="card-header">
                        <div class="card-title">
                            Price Details
                        </div>
                    </div>
                    <div class="card-body">

                        <?php
                        if (isset($_SESSION['id'])) {
                            $x=1;
                            $query=$con->query("SELECT * FROM order_items Where user_id='$user_id' and active_status=''");
                            while($product=mysqli_fetch_array($query)){
                                $pr_vr_id=$product['product_variant_id'];
                                $join="SELECT *,products.id as product_id FROM products INNER JOIN product_variant ON products.id = product_variant.product_id WHERE product_variant.id='$pr_vr_id'";
                                $res_join=mysqli_query($con,$join);
                                $row_join=mysqli_fetch_array($res_join);

                                ?>
                                <div class="title">Price (item <?=$x++;?>) <span>₹<span><?php echo $row_join['discounted_price']*$product['quantity'];?></span></span></div>

                                <?php 
                            } 
                        }
                        else
                        { 
                            $x=1;
                            foreach ($_SESSION['cart'] as $pr_id => $cart_item) { 
                                $pr_id = $cart_item['pr_id'];
                                $join="SELECT *,products.id as product_id FROM products INNER JOIN product_variant ON products.id = product_variant.product_id WHERE product_variant.id='$pr_id'";
                                $res_join=mysqli_query($con,$join);
                                $row_join=mysqli_fetch_array($res_join);
                                ?>
                                <div class="title">Price (item <?=$x++;?>) <span>₹<span><?php echo $row_join['discounted_price']*$cart_item['quantity'];?></span></span></div>
                            <?php } } ?>


                            <div class="title">Sub Total <span>₹<span class="sub_total"><?=$sub_total;?></span></span></div>
                            <div class="title">Delivery Charge <span>₹<span class="delivery-charge"><?=$delivery_charge;?></span></span></div>
                            <div class="total-payable">
                                <div class="title">Total Payable <span>₹<span class="final_total"><?=$total_amount;?></span></span></div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>

    <?php include('footer.php'); ?>
    <script>

        function redpro(id,price){
            var price=price;
            var quantity = parseInt($('.quantity'+id).val());
            if (quantity!=1) {
                var new_price=parseInt(price)*(quantity-1);
                new_quantity=quantity-1;

                var sub_total=$('.sub_total').text();
                var ttl=$('.final_total').text();
                var new_ttl=parseInt(ttl)-parseInt(price);
                var new_sub_total=parseInt(sub_total)-parseInt(price);
                $('.sub_total').text(new_sub_total);
                $('.final_total').text(new_ttl);

                var min_amount=$('.mnamnt').val();
                var dlivery=$('.delivery-charge').text();
                var setdliver=$('.dlvset').val();

                if(quantity>0){
                    if(new_sub_total>=min_amount){

                        var new_ttl=new_sub_total;
                        $('.delivery-charge').text('0');
                    }
                    else{
                        var new_ttl=parseInt(new_sub_total)+parseInt(setdliver);
                        $('.delivery-charge').text(setdliver);
                    }
                    $('.quantity'+id).val(quantity - 1);
                    $.ajax({
                        url:'add_to_cart.php',
                        method:'POST',
                        data:{upd:'subs',id:id},
                        success:function(data){
                         alertify.set('notifier','position', 'top-right');
                         alertify.success('Cart Item Quantity Update');
                         <?php unset($_SESSION['success_message']); ?>
                     }
                 })
                }
            }

        }
        function pluspro(id,price){
            var price=price;
            var quantity = parseInt($('.quantity'+id).val());
            var new_price=parseInt(price)*(quantity+1);
            var sub_total=$('.sub_total').text();
            var ttl=$('.final_total').text();
            var new_ttl=parseInt(ttl)+parseInt(price);
            var new_sub_total=parseInt(sub_total)+parseInt(price);
            $('.sub_total').text(new_sub_total);
            $('.final_total').text(new_ttl);

            var min_amount=$('.mnamnt').val();
            var dlivery=$('.delivery-charge').text();
            var setdliver=$('.dlvset').val();

            if(new_sub_total>=min_amount){

                var new_ttl=new_sub_total;
                $('.delivery-charge').text('0');
            }
            else{
                var new_ttl=parseInt(new_sub_total)+parseInt(setdliver);
                $('.delivery-charge').text(setdliver);
            }


            var new_quantity=quantity+1;
            $('.quantity'+id).val(quantity +1);
            $.ajax({
                url:'add_to_cart.php',
                method:'POST',
                data:{upd:'add',id:id},
                success:function(data){
                    console.log(data);
                    alertify.set('notifier','position', 'top-right');
                    alertify.success('Cart Item Quantity Update');
                    <?php unset($_SESSION['success_message']); ?>
                }
            })      
        }


        function remove_item(id){
            $.ajax({
              url:'add_to_cart.php',
              method:'POST',
              data:{remove:'remove',id:id},
              success:function(data){
                location.reload();
            }
        })
        }
    </script>