Ele57885fddfgdfgfghgقفغفغفقhfg555434536

kohjhjhصثقصثقصثقgdfgdg Ele57885fddfgdfgfghgقفغفغفقhfg555434536

<?php  
session_start();//$cid = $_SESSION['favcolor'];
$uid = $_SESSION["uid"];

$mob = $_SESSION["name"];
 include 'db.php';

$cid=strval($_GET['cid']);
$cid1=strval($_GET['cid1']);
$cid2=strval($_GET['cid2']);

$orderItemSql1 = "SELECT id,count(order_id),uid FROM cust WHERE phonenumr='$mob' and status='Credit'";
 
 
 $orderItemResult1 = $db->query($orderItemSql1);

$orderResult1 = $db->query($orderItemSql1);

$orderData1 = $orderResult1->fetch_array();

$order_id = $orderData1[1]+1;

if ($order_id <= 5) {  
$qnwt=50;

//  } elseif ($order_id <= 6) {

//$qnwt=50;

} else  { 
       
       
       
       
       $qnwt=30;
       
  }

$insert = $db->query("update p12 set amnt='$qnwt' where id = '$uid'");

$datncwt = date("d-m-Y");

//$amwt=LEFT('Veg',3);
if(isset($_POST['submit']))
    {
                	$empid=$_POST['idww'];
                 
                 $pid = "p13w ".$empid. "";
                 
                 
                 
                 
                 
                 
                 
                 
                 $sql = "SELECT * FROM cart WHERE p_id = '$pid' AND user_id = '$uid'";

$run_query=mysqli_query($db,$sql);

$count=mysqli_num_rows($run_query);
            if($count>0)
            {
                echo "<div class='alert alert-danger' role='alert'>
                    <button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>&times;</span></button>
                    <strong>Success!</strong> Already added!
                </div>";
                echo "<script>window.location='cart.php';</script>";
            }
            else
            {
                $sql = "SELECT * FROM p13 WHERE id = '$empid'";
                $run_query = mysqli_query($db,$sql);
                $row = mysqli_fetch_array($run_query);
                $id = $row["id"];
                $pro_title = $row["name"];
                $pro_image = $row["file1"];
                $pro_price = $row["name2"];
                
                 $unit = $row["name1"];

$sql="INSERT INTO cart(p_id,cid,user_id,product_title,product_image,qty,price,total_amount,unit) VALUES('$pid','$empid','$uid','$pro_title','$pro_image','1','$pro_price','$pro_price','$unit')";
                
                
                
                
                
                $run_query = mysqli_query($db,$sql);

echo "<script>window.location='cart.php';</script>";
           } 
           
        }

$amnt=strval($_GET['cid']);
         $orderItemSql = "SELECT id,amnt FROM p12 WHERE id='$uid'";
 $orderItemResult = $db->query($orderItemSql);

$orderResult = $db->query($orderItemSql);
$orderData = $orderResult->fetch_array();

$amct = $orderData[1];

if ($amct=='a') {
			     $orderItemSql = "SELECT id,name1 FROM p24 WHERE name = '$amnt' and approve <> 'rejected' order by id ASC LIMIT 1";
 $orderItemResult = $db->query($orderItemSql);

$orderResult = $db->query($orderItemSql);

$orderData = $orderResult->fetch_array();

$qty1= $orderData[1];
			   
			    
			    
			    
			} elseif ($amct=='b') {
			    
			    $orderItemSql = "SELECT id,name2 FROM p24  WHERE name = '$amnt' and approve <> 'rejected' order by id ASC LIMIT 1";
 $orderItemResult = $db->query($orderItemSql);

$orderResult = $db->query($orderItemSql);

$orderData = $orderResult->fetch_array();

$qty1= $orderData[1];
			    
			    
			
			    
			} elseif ($amct=='c') {
			    
			   
			   
			   
			   
			   
			   $orderItemSql = "SELECT id,name3 FROM p24  WHERE name = '$amnt' and approve <> 'rejected' order by id ASC LIMIT 1";
 $orderItemResult = $db->query($orderItemSql);

$orderResult = $db->query($orderItemSql);

$orderData = $orderResult->fetch_array();

$qty1= $orderData[1];
			    
			    
			 
			    
		
			    
			  
			  
			  
			  
			  
			  
			  
			  
			  
			
			
			
			    
			    
			} else {
$qty1= 0;
			 
			}
            
            
            
            // $qty2= $qty1 /100 *  $total;
            // $totalant=$total-$qty2;

$orderItemSqlamnt = "SELECT id,count(id) FROM p293 WHERE approve <> 'rejected'  group by awntprdt";
 
 
 $orderItemResultamnt = $db->query($orderItemSqlamnt);

$orderResultamnt = $db->query($orderItemSqlamnt);

$orderDataamnt = $orderResultamnt->fetch_array();

$amntwtnt = $orderDataamnt[1];

$amntwtntwtntwtnt = $orderDataamnt[1]+1;

$sqlQuery = "SELECT * FROM p293 where name <> 'Saree Pre-Pleating And Box Folding' and approve <> 'rejected' group by awntprdt";
            $result = mysqli_query($db, $sqlQuery);
            $total_count = mysqli_num_rows($result);
            
            
            
            
            
            
?>

<!DOCTYPE html>
<html class="no-js" lang="en">

<head>
    <meta charset="utf-8">
    <title>Products</title>
    <meta http-equiv="x-ua-compatible" content="ie=edge">
    <meta name="description" content="SOL ET LUNA is an E-Commerce website. Our team delivered packages of any product at an affordable and lowest price.">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta property="og:title" content="About Us">
    <meta property="og:type" content="Website">
    <meta property="og:url" content="https://thesoletluna.com/about.php">
     <meta property="og:image" content="Logo/SINCE%20MMXXIII.png">
    <meta property="og:image:secure_url" content="Logo/SINCE%20MMXXIII.png">
    
    <link rel="image src" href="Logo/SINCE%20MMXXIII.png">
    
    <link rel="shortcut icon" type="image/x-icon" href="Logo/favicon.png">
    
    <link rel="stylesheet" href="assets/css/main.css?v=3.3">
    
    
      
    <style>
        .notification {
  
 
  position: relative;
  display: inline-block;
  
}

.notification .badge {
  position: absolute;
  top: 20px;
  left: 10px;
  padding: 5px 10px;
 /* border-radius: 50%;  */
  background-color: #bf0808;
  color: white;
}
    </style>
    
</head>

<body>
    
   <?php include('include/header.php'); ?>
   
    <main class="main">
        <div class="page-header breadcrumb-wrap">
            <div class="container">
                <div class="breadcrumb">
                    <a href="index.php" rel="nofollow" style="color:#bf0808">Home</a>
                    <span>Our Products</span>
                    
                </div>
            </div>
        </div>
       <section class="section-padding" style="margin:10px;">
            <div class="container pt-25">
                
                <div class="row">
                    
                <p style="margin-bottom:20px;"> We found <strong class="text-brand"><font color="#bf0808"><?php echo $total_count;?> <?php echo $cid;?></font></strong> items for you!</p>
                <?php 
                        	$x = 1;
$ret=mysqli_query($db,"select * from p293 where approve <> 'rejected' and amntwtnt = '' group by awntprdt");
while($row=mysqli_fetch_array($ret))
{
$pid=$row['nameprdt'];
$name=$row['name'];
$name7=$row['name7'];
$total=$row['name12'];
$totalw=$row['name16'];
$awnt=$row['awnt'];
$totalqt=$row['amntqty'];
$stock=$row['name8'];
if($totalqt=='')
{
$amntqty='10000';
} else {
$amntqty=$totalqt;  
}
$orderItemSqlawntqnty = "SELECT id,name1 FROM p282 where id=1";
 
 
 $orderItemResultawntqnty = $db->query($orderItemSqlawntqnty);

$orderResultawntqnty = $db->query($orderItemSqlawntqnty);

$orderDataawntqnty = $orderResultawntqnty->fetch_array();

$qnty = $orderDataawntqnty[1];

$qty= $qnty /100 *  $total;
             $totalant=$total;
$qtyw= $qty1 /100 *  $totalw;
$totalantw=$totalw-$qtyw;  
$fileawnt=$row['file1'];
if($fileawnt==""){
$orderItemSqlqnty = "SELECT id,file1 FROM p370 WHERE name7='$pid' and approve <> 'rejected'";
$orderItemResultqnty = $db->query($orderItemSqlqnty);
$orderResultqnty = $db->query($orderItemSqlqnty);
$orderDataqnty = $orderResultqnty->fetch_array();
$file1 = $orderDataqnty[1];
} else {
$file1=$row['file1'];
}

?>
<div class="col-lg-3 split">
    <span  class="notification"> <span class="badge"><?php echo (100-(round($totalant*100/ $row["name11"],2))); ?> % Off</span></span>  
    <?php if ($row['name1']=='Fashion Accessory' || $row['name1']=='Kids Accessory' || $row['name1']=='Toys') { ?>
                                        
                                       
                                        
                                        <a href="Product-Details-unit.php?cid=<?php echo $row['id'];?>&cid1=<?php echo $row['name'];?>&cid2=<?php echo $row['name1'];?>&cid3=<?php echo urlencode($row['name7']);?>">
                                            
                                            
                                    
                                    
                                            
                                    <?php } else { ?>
                                    
                                     <a href="Product-Details-color-size.php?cid=<?php echo $row['id'];?>&cid1=<?php echo $row['name'];?>&cid2=<?php echo $row['name1'];?>&cid3=<?php echo urlencode($row['name7']);?>">
                                        
                                        
                                    <?php } ?>
                 
 	                          
                                <img loading="lazy" style="height:auto;border-radius:5px;" class="default-img hover-img" src="Admin-Panel/image/product/<?php echo $file1;?>" alt=""> </a>
                 
                 
                                        
                     
                    
                    <span>
                    
                   <?php if ($row['name1']=='Fashion Accessory' || $row['name1']=='Kids Accessory' || $row['name1']=='Toys') { ?>
                                        
                                       
                                        
                                        <a href="Product-Details-unit.php?cid=<?php echo $row['id'];?>&cid1=<?php echo $row['name'];?>&cid2=<?php echo $row['name1'];?>&cid3=<?php echo urlencode($row['name7']);?>">
                                            
                                            
                                    
                                    
                                            
                                    <?php } else { ?>
                                    
                                     <a href="Product-Details-color-size.php?cid=<?php echo $row['id'];?>&cid1=<?php echo $row['name'];?>&cid2=<?php echo $row['name1'];?>&cid3=<?php echo urlencode($row['name7']);?>">
                                        
                                        
                                    <?php } ?>
                                    
                        <?php echo htmlspecialchars($row["name"]); ?></a></span>                         
                   <h5><?php echo implode(' ', array_slice(explode(' ', $row["name7"]), 0, 3))."\n";?>...</h5>
                                       
                        <div class="product-price" style="margin-bottom:20px;">
                            
                            
                        <span id="name4<?php echo $pid; ?>" color="#3d4095">Rs. <?php echo htmlspecialchars($totalant); ?> /- </span>&nbsp;&nbsp;
                            
                        <span><del><?php echo htmlspecialchars($row["name11"]); ?> /-</del></span>
                            
                        </div>
                                      
                    </div>
                    
                  <?php $x++; } ?>       
                      
                </div>
            </div>
        </section>
        
    </main>
   
    <?php include('include/footer.php'); ?>
    
    <script src="assets/js/vendor/modernizr-3.6.0.min.js"></script>
    <script src="assets/js/vendor/jquery-3.6.0.min.js"></script>
    <script src="assets/js/vendor/jquery-migrate-3.3.0.min.js"></script>
    <script src="assets/js/vendor/bootstrap.bundle.min.js"></script>
    <script src="assets/js/plugins/slick.js"></script>
    <script src="assets/js/plugins/jquery.syotimer.min.js"></script>
    <script src="assets/js/plugins/wow.js"></script>
    <script src="assets/js/plugins/jquery-ui.js"></script>
    <script src="assets/js/plugins/perfect-scrollbar.js"></script>
    <script src="assets/js/plugins/magnific-popup.js"></script>
    <script src="assets/js/plugins/select2.min.js"></script>
    <script src="assets/js/plugins/waypoints.js"></script>
    <script src="assets/js/plugins/counterup.js"></script>
    <script src="assets/js/plugins/jquery.countdown.min.js"></script>
    <script src="assets/js/plugins/images-loaded.js"></script>
    <script src="assets/js/plugins/isotope.js"></script>
    <script src="assets/js/plugins/scrollup.js"></script>
    <script src="assets/js/plugins/jquery.vticker-min.js"></script>
    <script src="assets/js/plugins/jquery.theia.sticky.js"></script>
    <script src="assets/js/plugins/jquery.elevatezoom.js"></script>
    
    <script src="./assets/js/main.js?v=3.3"></script>
    <script src="./assets/js/shop.js?v=3.3"></script>
    
    
    
    
    
    
    
    <script type="text/javascript">
$(document).ready(function(){
          $('body').on('touchmove', onScroll);
        windowOnScroll();
        
});
function windowOnScroll() {
       $(window).on("scroll", function(e){
if($(window).scrollTop() > $(document).height() - $(window).height()-1000) {
            //if($(".awnt").length < $("#total_count").val()) {
                lastId = $(".awnt:last").attr("id");
                getMoreData(lastId);
            }
        //}
    });
}

//$(document).on('touchmove', onScroll); // for mobile

function onScroll(){

if($(window).scrollTop() > $(document).height() - $(window).height()-500) {
      lastId = $(".awnt:last").attr("id");
                getMoreData(lastId);
   }
}

</script>

function addrow1(row) {
   
  
  
  
    var name1 = $("#name1"+row).val();
    
    
    
    
    
    
    
      
      
    
    
    var discount = $("#discount"+row).val();

var name4w = $("#name4w"+row).val();
     
     
    var qty1 = $("#qty1"+row).val();
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
     var amntqty = $("#amntqty"+row).val();
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
      $.ajax({
        url: 'action.php',
        type: 'post',
        data: {addToProduct:1,proId:name1,rate:name4w,discount:discount,amntqty:amntqty},
       
       
        success:function(data) {
         
         
          
         
          
          
          
          
          
          
          
          $("#name7"+row).show();
          
          
          
          
          
          
          $("#number1"+row).show();
          
          
          
          
          
          
          
          
          
            $("#name7"+row).html('<input type="button" style="background-color: #3d4095;text-align: center;height:30px;width:30px;border: none;color: white;padding-left: 4px;" onclick="decrementValue('+name1+','+name4w+','+row+','+amntqty+')"  value="-" /><input type="text" style="background-color: #3d4095;text-align: center;height:33px;width:33px;border: none;color: white;padding-left: 4px;" name="quantity" value="1" maxlength="20000" max="100000" size="2" id="numberorder'+name1+'" readonly/><input type="button" style="background-color: #3d4095;text-align: center;height:30px;width:30px;border: none;color: white;padding-left: 7px;" onclick="incrementValue('+name1+','+name4w+','+row+','+amntqty+')" size="2" value="+" />');
                cart_count();
                cart_count1();
                
                
                
                 $("#number1"+row).html('<font color="red">Total: Rs.  <i class="fa fa-rupee" aria-hidden="true"></i>  '+name4w+' /-</font>');
                
                $("#addrow"+row).hide();
                
                
                
                 // $("#addrow"+row).css("background-color", "white");
                
                
                $("#name4ww"+row).html("Total:"+txtResult*qt);

$('body').animate({scrollTop:0},500);
         
        } 
      }); 
    }

</script>

function sum2(row,qt,row1,valueamnt) {
     
            var txtResult =  Number($("#numberorder"+row1).val());
            
             	if(txtResult==0)
			{
             
             
             
             
             
             $.ajax({
        url: 'action.php',
        type: 'post',
        data: {addToProductww:1,proId:row,quantity4:txtResult},
       
        success:function(data) {
         
          
          
           
          
                cart_count();

$("#addrow"+row1).show();

cart_count1();
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                
                	
                	
               
                	
                	 $("#name7"+row1).hide();
                	
               
                
                 $("#number1"+row1).hide();
                
                
                	
                
                
                	
                //$('body').animate({scrollTop:0},500);
          //location.reload();
        } 
        
      }); 
      
      
			}
			else
			
			
			
			
			
			{
              $.ajax({
        url: 'action.php',
        type: 'post',
        data: {addToProductw:1,proId:row,quantity4:txtResult},
       
        success:function(data) {
         
          
         
            $("#numberorder"+row1).val(valueamnt);
          
                cart_count();

cart_count1();
                
                
                
                 
                
                
                
                
                
                
                
                
                
                
                
                	
                	
                	
                	
                	
                	
                	
                	
                	
                	
                //$('body').animate({scrollTop:0},500);
           
          
          
          
          
          
          
        } 
        
      });  
               
               
               
               
               
               
               
               
               
			}         
                
           
        }
        
        
        
</script>
    
    
    
    <script type="text/javascript">
     
      cart_count();

function cart_count(){
        $.ajax({
            url: 'action.php',
            method: 'POST',
            data: {cartcount:1},
            success: function(data){
                $('.badge1').html(data);
                //$('.badge1').fadeIn(100).fadeOut(100).fadeIn(100).fadeOut(100).fadeIn(100);
            }
        })
    }

cart_count1();

function cart_count1(){
        $.ajax({
            url: 'action.php',
            method: 'POST',
            data: {cartcount1:1},
            success: function(data){
                $('.badge2').html(data);
                //$('.badge2').fadeIn(100).fadeOut(100).fadeIn(100).fadeOut(100).fadeIn(100);
            }
            
        })
     
     
     
     
     
     
     
     
     
    }
    
    
    </script>

function getProductDatas(row = null) {
   
   if(row) { 
    var name1 = $("#name1"+row).val();
    
    
    
    
    
    
    
      var name2 = $("#name2"+row).val();  
      var qty1 = $("#qty1"+row).val();
    if(name1 == "") {
      $("#ut+row").val("");

} else {
      $.ajax({
        url: 'fetchcust.php',
        type: 'post',
        data: {name1 : name1,name2 : name2},
        dataType: 'json',
        success:function(response) {
         
          
          $("#ut"+row).val(response.id);

$("#addrow"+row).show();
               
               $("#name7"+row).hide();

$("#number1"+row).hide();

var total = response.name12 -(response.name12* qty1/100);
					total = total.toFixed(2);
			var totalw = response.name16 -(response.name16* qty1/100);
			
					totalw = totalw.toFixed(2);		
					
					
					
					
          $("#name4"+row).text(total);
          $("#name3"+row).text(totalw);
          
          
          
          $("#name4w"+row).val(total);
          
        } 
      }); 
    }
        
   } else {
		alert('no row! please refresh the page');
	}
	
	
	
	
	
}

</script>

</html>