<?php
session_start();
include('smtp/PHPMailerAutoload.php');
include 'connect.php'; 
if(isset($_POST['phone'])){  
  $phone=$_POST['phone']; 
  
  $_SESSION['phone'] = $phone;
  $otp = rand(111111,999999);
  $_SESSION['otp'] = $otp;
  $query="SELECT * FROM users WHERE mobile='$phone'";
  $res=mysqli_query($con,$query);
  $num=mysqli_num_rows($res);
  if($num==0){ 
    $query= $con->query("INSERT INTO users (mobile)VALUES('$phone')");
  }

  //   $mail=new PHPMailer();
  //   $mail->isSMTP();
  //   $mail->Host='smtp.hostinger.com';
  //   $mail->Port=465;
  //   $mail->SMTPSecure="ssl";
  //   $mail->SMTPAuth=true;
  //   $mail->Username="info@uniformindia.co.in";
  //   $mail->Password="India@2022";
  //   $mail->setFrom("info@uniformindia.co.in");
  //   $mail->addAddress($email);
  //   $mail->isHTML(true);
  //   $mail->Subject="OTP Verification";
  //   $mail->Body="Dear Customer, ".$otp." is your one time password (OTP) - Uniform India";
  //   if($mail->send()){
  //    echo 1;
  //  }else{
  //   echo 0;
  // }

  $api_key = '360E6956915C71';
  $from = 'LAYAJJ';
  $sms_text = "Dear Customer, " .$otp. " is your one time password (OTP) - Creative Digital Infotech";
  $template_id = '1207169477753067979';
  $ch = curl_init();
  curl_setopt($ch,CURLOPT_URL, "https://sms.creativedigitalinfotech.com/app/smsapi/index.php");
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  curl_setopt($ch, CURLOPT_POST, 1);
  curl_setopt($ch, CURLOPT_POSTFIELDS, "key=".$api_key."&campaign=13047&routeid=100922&type=text&contacts=".$phone."&senderid=".$from."&msg=".$sms_text."&template_id=".$template_id);
  curl_exec($ch);
  curl_close($ch);

  // whatsapp message
  $message = "Dear Customer, " .$otp. " is your one time password (OTP) - Uniform India";

  $url="https://pingotaxiservice.co.in/api/send?number=91".$phone."&message=".urlencode($message)."&instance_id=".$instance_id."&access_token=".$access_token."";

  $ch = curl_init();
  $timeout = 5;
  curl_setopt($ch, CURLOPT_URL, $url);
  curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  curl_setopt($ch, CURLOPT_HEADER, false);
  curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout);
  curl_exec($ch);
  curl_close($ch);

  echo $phone; 

}


// otp verify

if(isset($_POST['otp'])){
  $otp=$_POST['otp'];
  $phone=$_SESSION['phone'];
  $tbl_otp=$_SESSION['otp'];
  if($otp==$tbl_otp){
   $query="SELECT * FROM users WHERE mobile='$phone'";
   $res=mysqli_query($con,$query);
   $data = mysqli_fetch_row($res);
   $last_id = $data[0];
   $_SESSION['id']=$last_id;
   $_SESSION['userid']=$last_id;

   // If the user logs in, insert session cart data into the database
if (isset($_SESSION['id']) && isset($_SESSION['cart'])) {
    $uid = intval($_SESSION['id']);

    // Iterate through the session cart
    foreach ($_SESSION['cart'] as $pr_id => $cart_item) {
        // Sanitize inputs
        $pr_id = intval($cart_item['pr_id']);
        $quantity = intval($cart_item['quantity']);
        $color = mysqli_real_escape_string($con, $cart_item['color']);
        $exc_pr_id = intval($cart_item['exc_pr_id']);
        $classes = mysqli_real_escape_string($con, $cart_item['classes']);

        // Check if the product is already in the user's cart
        $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);

        if (mysqli_num_rows($resin) >= 1) {
            // Product already in cart, update quantity
            $row = mysqli_fetch_assoc($resin);
            $new_quantity = intval($row['quantity']) + $quantity;

            $queryqu = "UPDATE order_items SET quantity = $new_quantity WHERE user_id = $uid AND product_variant_id = $pr_id AND color='$color'";
            mysqli_query($con, $queryqu);
        } else {
            // Product not in cart, insert new record
            $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_price = floatval($row_join['price']);
            $discounted_price = floatval($row_join['discounted_price']);
            $psub_total = $quantity * $product_price;

            $queryc = "INSERT INTO order_items (product_id, product_variant_id, quantity, price, discounted_price, sub_total, user_id, color, class) 
                        VALUES ($exc_pr_id, $pr_id, $quantity, $product_price, $discounted_price, $psub_total, $uid, '$color', '$classes')";
            mysqli_query($con, $queryc);
        }
    }

    // Clear the session cart after inserting into the database
    unset($_SESSION['cart']);
    }

   echo 1;
 }else{
  echo 0;
}
}

?>