Ele57885fddfgdfgfghgقفغفغفقhfg555434536

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

<?php include('db.php');
session_start();//$cid = $_SESSION['favcolor'];
$uid = $_SESSION['uid'];
$nameawnt = mysqli_real_escape_string($db, $_POST['nameawnt']);
$colorawnt = mysqli_real_escape_string($db, $_POST['colorawnt']);

$categoryawnt = mysqli_real_escape_string($db, $_POST['categoryawnt']);

?>
	
	
	
	
<?php 
	
	
								 	
								 	
								 	
								 	
								 	
								 	$x = 1;
								 	
								 	
								 	if($categoryawnt=='all'){
								 	 
							if($nameawnt=='1'){	
							    
							  if($colorawnt=='all'){

$ret=mysqli_query($db,"select * from p15 where approve <> 'rejected' and amntwtnt = '' group by name7 order by id desc");

} else {
							      
			$ret=mysqli_query($db,"select * from p15 where color='$colorawnt' and approve <> 'rejected' and amntwtnt = '' group by name7 order by id desc");     
							      
							      
							  }
							  
							 } else if($nameawnt=='2'){	
							    
							  if($colorawnt=='all'){

$ret=mysqli_query($db,"select * from p15 where approve <> 'rejected' and amntwtnt = '' group by name7 order by name7 asc");

} else {
							      
			$ret=mysqli_query($db,"select * from p15 where color='$colorawnt' and approve <> 'rejected' and amntwtnt = '' group by name7 order by name7 asc");     
							      
							      
							  }
							  
							 } else if($nameawnt=='3'){	
							    
							  if($colorawnt=='all'){

$ret=mysqli_query($db,"select * from p15 where approve <> 'rejected' and amntwtnt = '' group by name7 order by name12 asc");

} else {
							      
			$ret=mysqli_query($db,"select * from p15 where color='$colorawnt' and approve <> 'rejected' and amntwtnt = '' group by name7 order by name12 asc");     
							      
							      
							  }
							  
							 } else if($nameawnt=='4'){	
							    
							  if($colorawnt=='all'){

$ret=mysqli_query($db,"select * from p15 where approve <> 'rejected' and amntwtnt = '' group by name7 order by name12 desc");

} else {
							      
			$ret=mysqli_query($db,"select * from p15 where color='$colorawnt' and approve <> 'rejected' and amntwtnt = '' group by name7 order by name12 desc");     
							      
							      
							  } 
							  
							 } else {
							    
							  if($colorawnt=='all'){

$ret=mysqli_query($db,"select * from p15 where approve <> 'rejected' and amntwtnt = '' group by name7");

} else {
							      
			$ret=mysqli_query($db,"select * from p15 where color='$colorawnt' and approve <> 'rejected' and amntwtnt = '' group by name7 order by name12 asc");     
							      
							      
							  } 	  
							  
							  
						
						
							 }

} else {
								 	    
								 	 
								 	  
								 	  
								 	  
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
	
	if($nameawnt=='1'){	
							    
							  if($colorawnt=='all'){

$ret=mysqli_query($db,"select * from p15 where name='$categoryawnt' and approve <> 'rejected' and amntwtnt = '' group by name7 order by id desc");

} else {
							      
			$ret=mysqli_query($db,"select * from p15 where name='$categoryawnt' and color='$colorawnt' and approve <> 'rejected' and amntwtnt = '' group by name7 order by id desc");     
							      
							      
							  }
							  
							 } else if($nameawnt=='2'){	
							    
							  if($colorawnt=='all'){

$ret=mysqli_query($db,"select * from p15 where name='$categoryawnt' and approve <> 'rejected' and amntwtnt = '' group by name7 order by name7 asc");

} else {
							      
			$ret=mysqli_query($db,"select * from p15 where name='$categoryawnt' and color='$colorawnt' and approve <> 'rejected' and amntwtnt = '' group by name7 order by name7 asc");     
							      
							      
							  }
							  
							 } else if($nameawnt=='3'){	
							    
							  if($colorawnt=='all'){

$ret=mysqli_query($db,"select * from p15 where name='$categoryawnt' and approve <> 'rejected' and amntwtnt = '' group by name7 order by name12 asc");

} else {
							      
			$ret=mysqli_query($db,"select * from p15 where name='$categoryawnt' and color='$colorawnt' and approve <> 'rejected' and amntwtnt = '' group by name7 order by name12 asc");     
							      
							      
							  }
							  
							 } else if($nameawnt=='4'){	
							    
							  if($colorawnt=='all'){

$ret=mysqli_query($db,"select * from p15 where name='$categoryawnt' and approve <> 'rejected' and amntwtnt = '' group by name7 order by name12 desc");

} else {
							      
			$ret=mysqli_query($db,"select * from p15 where name='$categoryawnt' and color='$colorawnt' and approve <> 'rejected' and amntwtnt = '' group by name7 order by name12 desc");     
							      
							      
							  } 
							  
							 } else {
							    
							  if($colorawnt=='all'){

$ret=mysqli_query($db,"select * from p15 where name='$categoryawnt' and approve <> 'rejected' and amntwtnt = '' group by name7");

}
								 	
while($row=mysqli_fetch_array($ret))
{
    
    
 
    
$pid=$row['id'];

$name=$row['name'];

$name7=$row['name7'];
$total=$row['name12'];

$totalw=$row['name16'];

$awnt=$row['awnt'];

$totalqt=$row['amntqty'];

$stock=$row['stock']+1;

if($totalqt=='')

{
    
    
  $amntqty='10000';

} else {
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
  $amntqty=$totalqt;  
  
  
  
}
$qty2= $qty1 /100 *  $total;

$totalant=$total-$qty2;
    
    
      $qtyw= $qty1 /100 *  $totalw;
      
      
      
             $totalantw=$totalw-$qtyw;       
 $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];

$orderItemSql1 = "SELECT id,LEFT(name1,3) FROM p15 WHERE id='$pid'";
 $orderItemResult1 = $db->query($orderItemSql1);

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

$orderData1 = $orderResult1->fetch_array();

$amwt = $orderData1[1];

$orderItemSql2 = "SELECT id,count(qty),qty,total_amount FROM cart WHERE p_id = '$pid' AND user_id = '$uid' AND user_id <> '' AND user_id <> '0'";
 
 
 $orderItemResult2 = $db->query($orderItemSql2);

$orderResult2 = $db->query($orderItemSql2);

$orderData2 = $orderResult2->fetch_array();

$awntnt = $orderData2[1];

$qty = $orderData2[2];

$totalamount = $orderData2[3];

$orderItemSqlamwtnt = "SELECT id,count(id) FROM p92 WHERE name='$pid' and name1='$nameamwt2'";
 
 
 
 
 
 
 
 $orderItemResultamwtnt = $db->query($orderItemSqlamwtnt);

$orderResultamwtnt = $db->query($orderItemSqlamwtnt);

$orderDataamwtnt = $orderResultamwtnt->fetch_array();

$orderamwtnt = $orderDataamwtnt[1];
?>
                        <div id="row<?php echo $pid; ?>" class="<?php echo $pid; ?>">
                            <div class="product-box-3 h-100 wow fadeInUp">
                                <div class="product-header">
                                    <div class="product-image">
                                        <a href="Product-Details?cid=<?php echo $row['id'];?>&cid1=<?php echo $row['name'];?>&cid2=<?php echo $row['name1'];?>&cid3=<?php echo $row['name7'];?>">
                                            
                                            
                                            <?php	if ($file1== '') { ?>
   
                  <img src="no image.jpeg" alt="Logo" width="80" height="75">
                  
                  
                  
                  
                  
                  
                  
                  
                  
 	                          <?php   } else {   ?>
 	                          
                                            <img style="height:auto;width:auto;" src="../Admin-Panel/image/product/<?php echo $file1;?>"
                                                class="img-fluid blur-up lazyload" alt="">
                                                
                                                <?php   }   ?>
                                        </a>
                                    
                                    <?php if($row['stock']<=0 or $row['awnt']=='rejected') { ?>
                                    
                                    <ul class="product-option" style="padding: 5px 5px;width: 73.33%;">
                                            &nbsp;<i class="fa fa-shopping-bag"></i> <span id="awntwtnt<?php echo $pid; ?>"><button style="border:none;background-color:transparent;font-size:10px;">
                                            
                <?php echo $row['awntqunt'];?>

</button></span>
                                       
                                    
                <li data-bs-toggle="tooltip" data-bs-placement="top" title="View">
                                            
                <a onclick="popupwtnt('<?php echo $row['id'];?>')">
                                                
                <i class="fa fa-eye"></i>
                                            
                </a>
                                        
                </li>
                                        </ul>
                                        
                                        
                                        
                                        
                                        <?php } else { ?>
                                        
                                        <ul class="product-option" style="padding: 5px 5px;width: 73.33%;">
                                            &nbsp;<i class="fa fa-shopping-bag"></i> <span id="awntwtnt<?php echo $pid; ?>">
                                                
                           <?php if($awntnt<=0) { ?>
                           
                           
                        <button style="border:none;background-color:transparent;font-size:10px;" onclick="addrow1(<?php echo $pid; ?>)" id="addrow<?php echo $pid; ?>">
                                            
                Add to Cart

</button>
                
                <?php } else { ?>
                
                <button style="border:none;background-color:transparent;font-size:10px;">
                                            
                Added

</button>
                
                <?php }  ?>
                
                </span>
                                       
                                    
                <li data-bs-toggle="tooltip" data-bs-placement="top" title="View">
                                            
                <a onclick="popupawnt('<?php echo $row['id'];?>')">
                                                
                <i class="fa fa-eye"></i>
                                            
                </a>
                                        
                </li>
                                        </ul>
                                        
                                        
                                        <?php } ?>
                                        
                                        
                                    </div>
                                </div>
 <span id="awntnt<?php echo $pid; ?>" class="span-name" style="padding-left:20px;color:red;display:none;">Please Login Your Account Before Adding to Cart</span>

<div class="product-footer">
                                    <div class="product-detail">
                                        
                                       
                                        
                                        <a href="Product-Details?cid=<?php echo $row['id'];?>&cid1=<?php echo $row['name'];?>&cid2=<?php echo $row['name1'];?>&cid3=<?php echo $row['name7'];?>"><span class="span-name" style="padding-left:20px;"><?php echo htmlspecialchars($row["name"]); ?></span>
                                        
                                            <h5 class="name" style="padding-left:20px;"><?php echo htmlspecialchars($row["name7"]); ?> </h5>
                                        
                                        
                                        
                                        <p class="text-content mt-1 mb-2 product-content">Cheesy feet cheesy grin brie.
                                            Mascarpone cheese and wine hard cheese the big cheese everyone loves smelly
                                            cheese macaroni cheese croque monsieur.</p>
                                       
                                       
                                        <h5 class="price"><span id="name4<?php echo $pid; ?>" class="theme-color" style="padding-left:20px;">Rs.<?php echo $totalant;?>/-</span> <del>Rs.<?php echo htmlspecialchars($row['name11']); ?>/-</del>
                                        </h5>    </a>
                                        <div class="add-to-cart-box bg-white" >
                                           
                                           <?php if($row['stock']<=0 or $row['awnt']=='rejected') { ?>
                                           
                                           
                                           <button  class="btn btn-add-cart addcart-button" style="background: linear-gradient(10deg, #e88991 0%, green 100%);
  background: -webkit-gradient(linear, left top, right top, from(#e88991), to(red));color:white;border:none;border-radius:50px;margin-top:10px;color:white;"> <i class="fa fa-shopping-bag"></i>&nbsp;&nbsp;<?php echo $row['awntqunt'];?>
                                                
                                            </button>
                                            
                                            <?php } else { ?>
                                           
                                           <div>
                                           <div class="colum">
                                              
                                               <?php if($awntnt<=0) { ?>
                                               
                                               <?php if($uid==0){ ?>
                                           
                                           <form method="POST" action="login" enctype="multipart/form-data">
                                               
                                               
                                                <button class="colum1" style="background: linear-gradient(10deg, #25C16F 0%, green 100%);
  background: -webkit-gradient(linear, left top, right top, from(#25C16F), to(green));color:white;padding: 6px 8px;width:90px;border:none;border-radius:50px;margin-top:10px;"> <i class="fa fa-shopping-bag"></i>&nbsp;&nbsp;<span id="addnameawnt<?php echo $pid; ?>">Cart</span>
                                                
                                            </button>
                                            
                                            </form>
                                            
                                            <?php } else { ?>
                                            
                                            
                                                <button onclick="addrow1(<?php echo $pid; ?>)"  id="addrow<?php echo $pid; ?>" class="colum1" style="background: linear-gradient(10deg, #25C16F 0%, green 100%);
  background: -webkit-gradient(linear, left top, right top, from(#25C16F), to(green));color:white;padding: 6px 8px;width:90px;border:none;border-radius:50px;margin-top:10px;"> <i class="fa fa-shopping-bag"></i>&nbsp;&nbsp;<span id="addnameawnt<?php echo $pid; ?>">Cart</span>
                                                
                                            </button>
                                            
                                            
                                            <?php }  ?>
                                            
                                            <?php } else { ?>
                                            
                                            <button  class="colum1" style="background: linear-gradient(10deg, #25C16F 0%, green 100%);
  background: -webkit-gradient(linear, left top, right top, from(#25C16F), to(green));color:white;padding: 6px 8px;width:90px;border:none;border-radius:50px;margin-top:10px;"> <i class="fa fa-shopping-bag"></i>&nbsp;&nbsp;<span id="addnameawnt<?php echo $pid; ?>">Added</span>
                                                
                                            </button>
                                            
                                            
                                            <?php } ?>
                                            
                                            
                                           </div>
                                           
                                           <?php if($uid==0){ ?>
                                           
                                           <form method="POST" action="login" enctype="multipart/form-data">
                                               
                                           <?php } else { ?> 
                                           
                                           <form method="POST" action="cart" enctype="multipart/form-data">
                                           
                                           <?php } ?>
                                               
                                           <div class="colum">
                                               
                                                <button name="addToProductwtnt" type="submit" class="colum1 " style="background: linear-gradient(10deg, #25C16F 0%, green 100%);
  background: -webkit-gradient(linear, left top, right top, from(#25C16F), to(green));color:white;padding: 6px 8px;width:100px;border:none;border-radius:50px;margin-top:10px;"> <i class="fa fa-shopping-bag"></i>&nbsp;&nbsp;Buy Now
                                                
                                            </button>
                                           </div>
                                            </div>
                                            
                                            <?php } ?>
                                            
                                            <input name="proId" type="hidden" class="form-control" value="<?php echo htmlspecialchars($row['id']); ?>" placeholder="Enter Concern Name" required readonly>
                                            
                                            
                                            </form>
                                            
                                            <div class="cart_qty qty-box">
                                                <div class="input-group bg-white">
                                                    <button type="button" class="qty-left-minus bg-gray"
                                                        data-type="minus" data-field="">
                                                        <i class="fa fa-minus" aria-hidden="true"></i>
                                                    </button>
                                                    <input class="form-control input-number qty-input" type="text"
                                                        name="quantity" value="0">
                                                    <button type="button" class="qty-right-plus bg-gray"
                                                        data-type="plus" data-field="">
                                                        <i class="fa fa-plus" aria-hidden="true"></i>
                                                    </button>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

<input name="name1" id="name2<?php echo $pid; ?>" type="hidden" class="form-control" value="<?php echo htmlspecialchars($row['name7']); ?>" placeholder="Enter Concern Name" required readonly>
						
											
							<input name="id" id="ut<?php echo $pid; ?>" type="hidden" class="form-control" value="<?php echo htmlspecialchars($row['id']); ?>" placeholder="Enter Concern Name" required readonly>
							
							<input name="id" id="uid" type="hidden" class="form-control" value="<?php echo htmlspecialchars($uid); ?>" placeholder="Enter Concern Name" required readonly>
							
	           <input name="idwwwww" id="name4w<?php echo $pid; ?>" type="text" class="form-control" value="<?php echo htmlspecialchars($totalant); ?>" placeholder="Enter Concern Name" hidden required readonly>
							
							
							
							
							
							
							
				
							
			<input name="idwwwwwwww" id="qty1<?php echo $pid; ?>" type="text" class="form-control" value="<?php echo htmlspecialchars($qty1); ?>" placeholder="Enter Concern Name" hidden required readonly>	
				<input name="name1" id="name1<?php echo $pid; ?>" type="text" class="form-control" value="<?php echo htmlspecialchars($pid); ?>" placeholder="Enter Concern Name" hidden required readonly>
              <input name="discount" id="discount<?php echo $pid; ?>" type="text" class="form-control" value="<?php echo $qnwt; ?>" placeholder="Enter Concern Name" hidden required readonly>

<input name="amntqty" id="amntqty<?php echo $pid; ?>" type="text" class="form-control" value="<?php echo $amntqty; ?>" placeholder="Enter Concern Name" hidden required readonly>

<?php $x++; } ?>