<?php
session_start(); 
// if(!isset($_SESSION['id'])){
// 	header("location:login.php");
// }
require_once __DIR__ .'/vendor/autoload.php';
include('connect.php');
if(isset($_POST['prd_id'])){
	$new_quantity=$_POST['quantity'];
	$uid=$_SESSION['id'];
	$pr_id=$_POST['prd_id'];
	$color=$_POST['color'];
	$exc_pr_id=$_POST['prd_id_exc'];
	$classes=$_POST['classes'];
	$page=$_POST['page'];

	if (isset($uid)) {
		$queryin="SELECT * from order_items where user_id='$uid' and product_variant_id='$pr_id' and color='$color' and active_status=''";
		$resin=mysqli_query($con,$queryin);
		$row=mysqli_fetch_array($resin);
	//print_r($row);
		$count=mysqli_num_rows($resin);
		if($count>=1)
		{ 
			$new_quantity=$_POST['quantity'];
			$quantity=intval($row['quantity'])+intval($new_quantity);

			$queryqu="UPDATE order_items set quantity='$quantity' where user_id='$uid' and product_variant_id='$pr_id' and color='$color'";
			$resqu=mysqli_query($con,$queryqu);
			$msg="Item updated In Cart Successfully";


		}elseif($count==0)
		{


			$quer_join="SELECT * FROM  product_variant WHERE id='$pr_id'";
			$res_join=mysqli_query($con,$quer_join);
			$row_join=mysqli_fetch_assoc($res_join);


			$product_id=$pr_id;
			$product_quantity=$new_quantity;
			$product_price=$row_join['price'];
			$discounted_price=$row_join['discounted_price'];
			$psub_total=$product_quantity*$product_price;
			$product_userid=$uid;
			$queryc="INSERT into order_items(product_id,product_variant_id,quantity,price,discounted_price,sub_total,user_id,color,class)values('$exc_pr_id','$product_id','$product_quantity','$product_price','$discounted_price','$psub_total','$product_userid','$color','$classes')";
			$resc=mysqli_query($con,$queryc);
			$msg="Item added In Cart Successfully";
			$_SESSION['success_message']='Item added in cart';
		}
	}else{

	// User is not logged in, add to session cart
		if (!isset($_SESSION['cart'])) {
			$_SESSION['cart'] = [];
		}

		$composite_key = $pr_id . '-' . $color;

		if (isset($_SESSION['cart'][$composite_key])) {
			$_SESSION['cart'][$composite_key]['quantity'] += $new_quantity;
		} else {
    
			$_SESSION['cart'][$composite_key] = [
				'pr_id' => $pr_id,
				'quantity' => $new_quantity,
				'color' => $color,
				'exc_pr_id' => $exc_pr_id,
				'classes' => $classes
			];
		}

		$_SESSION['success_message'] = 'Item added in cart';
		$msg = "Item added In Cart Successfully";
		if ($_POST['btncarts']=='Buy Now') {
			header("location:login.php?page=checkout");
			exit;
		}

	}

	if ($page!='') {
		header("location:$page");
		exit;
	}else{
		$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'];
                                // echo $id;
				$data = json_decode($row['value'], true);
			}
                            // print_r($data);
		}

		echo $data['delivery_charge'];
	}


}

if(isset($_POST['btncart']))
{

	$id=$_POST['page_id'];
	if(!empty($_SESSION['userid']))
	{
		$pr_vr_id=$_POST['product_variant'];
		$quantity=$_POST['quantity'];
		$pr_id=$_POST['product_variant'];
                      // if($pr_id!=$pr_vr_id and $pr_vr_id!=''){
                      // 	echo $pr_id=$pr_vr_id;
                      // }
		$uid=$_SESSION['userid'];
		$queryin="SELECT * from order_items where user_id='$uid' and product_variant_id='$pr_id' and active_status=''";
		$resin=mysqli_query($con,$queryin);
		$row=mysqli_fetch_array($resin);
				//print_r($row);
		$count=mysqli_num_rows($resin);
		if($count>=1)
		{ 

			$quantity=intval($row['quantity'])+intval($quantity);

			$queryqu="UPDATE order_items set quantity='$quantity' where user_id='$uid' and product_variant_id='$pr_id'";
			$resqu=mysqli_query($con,$queryqu);
			$msg="Item updated In Cart Successfully";
			$_SESSION['success_message']='Item added in cart';

		}elseif($count==0)
		{


			$quer_join="SELECT * FROM  product_variant WHERE id='$pr_id'";
			$res_join=mysqli_query($con,$quer_join);
			$row_join=mysqli_fetch_assoc($res_join);


			$product_id=$pr_id;
			$product_quantity=$quantity;
			$product_price=$row_join['price'];
			$psub_total=$product_quantity*$product_price;
			$product_userid=$uid;
			$queryc="INSERT into order_items(product_variant_id,quantity,price,sub_total,user_id)values('$product_id','$product_quantity','$product_price','$psub_total','$product_userid')";
			$resc=mysqli_query($con,$queryc);
			$msg="Item added In Cart Successfully";
			$_SESSION['success_message']='Item added in cart';
		}
	}
	else
	{
		header("location:login.php");
	}
	header("location:/productsby_category.php?id=$id");
}
if(isset($_POST['chk_out'])){
	if ($_POST['payment_method']=='Online') {
		
	}
	$user_id=$_SESSION['id'];
	$amount=$_POST['amount'];
	$delivery_charge=$_POST['delivery_charge'];
	$addr=$_POST['addr'];
	$payment_method=$_POST['payment_method'];
	$promo_code=$_POST['promo_code'];
	$promo_discount=$_POST['promo_discount'];
	// $twn=$_POST['twn'];
	// $zip=$_POST['zip'];
	$num=$_POST['num'];
	$dlvtime=$_POST['dlvtime'];

	$or_id=$_POST['or_id'];
	$or_id=explode(',', $or_id);
	$dlvday=$_POST['dlvday'];
	$dlv=$dlvday.'-'.$dlvtime;
	$full_addr=$addr;
	$res=mysqli_query($con,"SELECT * FROM users WHERE id='$user_id'");
	$row=mysqli_fetch_array($res);
	$user_name=$row['name'];
	$mobile=$row['mobile'];
	$email=$row['email'];
	if($mobile==''){
		$mobile=$num;
		mysqli_query($con,"UPDATE users SET mobile='$mobile',street='$full_addr' WHERE id='$user_id'");
	}
	$sql="INSERT INTO orders (user_id,mobile,total,delivery_charge,discount,final_total,payment_method,wallet_balance,status,active_status,date_added,address,delivery_time,promo_code,promo_discount) VALUES ('$user_id','$mobile','$amount','$delivery_charge','0','$amount','$payment_method','0','received','received',now(),'$full_addr','$dlv','$promo_code','$promo_discount')";
	mysqli_query($con,$sql);
	$last_id = mysqli_insert_id($con);
	echo $mobile;
	$status[] = array('received',date("d-m-Y h:i:sa") );
	for($i=0;$i<=count($or_id);$i++){
		$or_new_id=$or_id[$i];
		$new_sql="UPDATE order_items SET order_id='$last_id',status='$status',active_status='received' WHERE user_id='$user_id' and product_variant_id='$or_new_id'";

		$res=mysqli_query($con,$new_sql);
	}

 // invoice send to mail
	$url="https://uniformindia.co.in/invoice.php?id=".$last_id;
	if (ini_get('allow_url_fopen')) {
		$html=file_get_contents($url);

	} else {
		$ch=curl_init($url);
		curl_setopt($ch, CURLOPT_HEADER, );
		curl_setopt ( $ch , CURLOPT_RETURNTRANSFER , 1 );
		$html=curl_exec($ch);
		curl_close($ch);
	}
	$mpdf=new \Mpdf\Mpdf();
	$mpdf->SetDisplayMode('fullwidth');
	$mpdf->SetDisplayPreferences('FullScreen');
	$mpdf->CSSselectMedia='mpdf';
	$mpdf->setBasePath($url);
	$mpdf->WriteHTML($html);
	$pdf = $mpdf->Output("invoice/invoice".$last_id.".pdf",'F');
	$invoice = "invoice/invoice".$last_id.".pdf";

	include('smtp/PHPMailerAutoload.php');

	$mail=new PHPMailer();
	$mail->isSMTP();
	$mail->Host='smtp.hostinger.com';
	$mail->Port=465;
	$mail->SMTPSecure="ssl";
	$mail->SMTPAuth=true;
	$mail->Username="info@creativedigitalinfotech.com";
	$mail->Password="Creative@2023";
	$mail->setFrom("info@creativedigitalinfotech.com");
	$mail->addAddress($email);
	$mail->isHTML(true);
	$mail->Subject="Invoice";
	$mail->Body="Invoice";
	$mail->addAttachment($invoice);
	$mail->send();


// $res=mysqli_query($con,$sql);
// while($row)

	// $sql=mysqli_query($con,"DELETE FROM order_items WHERE user_id='$user_id'");
	if($sql){
		echo 'inserted';
	}
	else{
		'not';
	}
}
if(isset($_POST['remove'])){
	$id=$_POST['id'];
	if (isset($_SESSION['id'])) {
		mysqli_query($con,"DELETE FROM order_items WHERE id='$id'");
	}else{

		if (isset($_SESSION['cart'][$id])) {
			unset($_SESSION['cart'][$id]);
		}

	}
	$_SESSION['success_message']='Cart Item Deletd';
	echo 'deleted';
}

// remove quantity
if(isset($_POST['update_qty'])){
	$id=$_POST['id'];
	$qty=$_POST['update_qty'];
	mysqli_query($con,"UPDATE order_items SET quantity='$qty' WHERE id='$id'");
	echo 'updated';
	$_SESSION['success_message']='Cart Item Quantity Update';
}


if(isset($_POST['upd'])){
	$upd=$_POST['upd'];
	$id=$_POST['id'];
	if($upd=='add'){
		if (isset($_SESSION['id'])) {
			
			$res=mysqli_query($con,"SELECT * FROM order_items WHERE id='$id'");
			$row=mysqli_fetch_array($res);
			$old_qnt=$row['quantity'];
			$new_quantity=intval($old_qnt)+1;
			mysqli_query($con,"UPDATE order_items SET quantity='$new_quantity' WHERE id='$id'");
		}else{

			if (isset($_SESSION['cart'][$id])) {
				$_SESSION['cart'][$id]['quantity'] += 1;
			}
		}
		echo 'updated';
		$_SESSION['success_message']='Cart Item Quantity Update';

	}
	if($upd=='subs'){
		if (isset($_SESSION['id'])) {
			$res=mysqli_query($con,"SELECT * FROM order_items WHERE id='$id'");
			$row=mysqli_fetch_array($res);
			$old_qnt=$row['quantity'];
			$new_quantity=intval($old_qnt)-1;
			mysqli_query($con,"UPDATE order_items SET quantity='$new_quantity' WHERE id='$id'");
		}else{
			if (isset($_SESSION['cart'][$id])) {
				$_SESSION['cart'][$id]['quantity'] -= 1;
			}
		}
		echo 'updated';
		$_SESSION['success_message']='Cart Item Quantity Update';

	}
}
if($_POST['cncl']){
	$id=$_POST['id'];
	$query=$con->query("UPDATE orders SET active_status='cancelled' WHERE id='$id'");
	if($query){
		$query=$con->query("UPDATE order_items SET active_status='cancelled' WHERE order_id='$id'");
		echo 'cancelled';
		$_SESSION['success_message']='Cancelled';
	}
	else{
		echo 'Something wrong ';
		$_SESSION['error_message']='Somethig Wrong';
	}
}
?>