403WebShell

403Webshell
Server IP : 185.124.137.164 / Your IP : 216.73.216.116
Web Server : LiteSpeed
System : Linux id-dci-web1411.main-hosting.eu 5.14.0-503.34.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Mar 27 06:00:50 EDT 2025 x86_64
User : u993272038 ( 993272038)
PHP Version : 8.1.31
Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail
MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF
Directory : /home/u993272038/domains/verandah.shop/public_html/
Upload File :
[ Back ]
Current File : /home/u993272038/domains/verandah.shop/public_html//checkout_backup.php
<?php 
include('header.php'); 

ini_set('display_errors', 1);
error_reporting(E_ALL);

if(isset($_COOKIE['usd'])){ 
$CuurrncyIcon ='$';
}
else { 
$CuurrncyIcon ='€';

} 



use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\SMTP;
use PHPMailer\PHPMailer\Exception;


require 'PHPMailer/src/Exception.php';
require 'PHPMailer/src/PHPMailer.php';
require 'PHPMailer/src/SMTP.php';


if(!isset($_SESSION['cart']) || empty($_SESSION['cart'])){
echo"<script>window.location='".$base_url."';</script>";
}



//------------------------- If User is alreday login Start  ------------------------//

if(isset($_SESSION['user_id'])){
$UserData=mysqli_fetch_assoc(mysqli_query($conn,"SELECT * FROM `users_tbl` WHERE  id='".$_SESSION['user_id']."'"));

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

$total_discount= $_POST['discount_amount'];
$total_shipping= $_POST['shipping_amount'];
$currency_type= $_POST['currency'];
$GrandtotalAmount= $_POST['total_amount']; 

$fname = $_POST['fname'];
$fname=str_replace("'", "\'", $fname);

$lname = $_POST['lname'];
$lname=str_replace("'", "\'", $lname);

$email = $_POST['email'];
$email=str_replace("'", "\'", $email);

$phone = $_POST['phone'];
$phone=str_replace("'", "\'", $phone);

$apt = $_POST['apt'];
$apt=str_replace("'", "\'", $apt);

$country = $_POST['country'];
$country=str_replace("'", "\'", $country);

$state = $_POST['state'];
$state=str_replace("'", "\'", $state);

$city = $_POST['city'];
$city=str_replace("'", "\'", $city);

$zip = $_POST['zip'];
$zip=str_replace("'", "\'", $zip);

$address = $_POST['address'];
$address=str_replace("'", "\'", $address);

/*$shipping=10;*/

// Check if the email already exists in the database
$ChkQry=mysqli_query($conn,"SELECT * FROM `users_tbl` WHERE  email='$email' AND id!='".$_SESSION['user_id']."' AND user_type=1") or die(mysqli_error($conn));
if(mysqli_num_rows($ChkQry)>0){
echo '<p style="color:#dc3545;">Email already exists. Please choose another email</p>';
}


else{
 $editQry=mysqli_query($conn,"UPDATE `users_tbl` SET 
`fname`='$fname', 
`lname`='$lname', 
`email`='$email',
`phone`='$phone', 
`apt`='$apt', 
`country`='$country',
`state`='$state', 
`city`='$city', 
`zip`='$zip',
`address`='$address'  
WHERE id='".$_SESSION['user_id']."'")or die(mysqli_error($conn)); 


//Update Qry Start
if($editQry){
$Ordsql="INSERT `order_tbl` SET 
`user_id`='".$UserData['id']."',
`user_name`='".$UserData['fname']."' ,
`user_email`='".$UserData['email']."' ,
`user_phone`='".$UserData['phone']."' ,
`total_discount`='".$total_discount."',
`total_shipping`='".$total_shipping."',
`total_amount`='".$GrandtotalAmount."',
`currency`='".$currency_type."',
`order_date`='".date('Y-m-d')."',
`status`=0";
mysqli_query($conn,$Ordsql)or die(mysqli_error($conn));
$orderid=mysqli_insert_id($conn);
$Ordertbl=mysqli_fetch_assoc(mysqli_query($conn,"SELECT * FROM order_tbl WHERE id='$orderid'"));
$formatted=sprintf("%04d", $Ordertbl['id']);
$invoice_id='ORD'.$formatted;

mysqli_query($conn,"UPDATE `order_tbl` SET 
`invoice_id`='$invoice_id' WHERE id='".$Ordertbl['id']."'");
/*die('fnffdgfuygdfydgyfgyfggfn');*/
//foreach Qry Start
foreach ($_SESSION['cart'] as $productId => $quantity) {
echo "SELECT * FROM product_tbl WHERE id='$productId'";
$fetch_row=mysqli_fetch_assoc(mysqli_query($conn,"SELECT * FROM product_tbl WHERE id='$productId'"));

if(isset($_COOKIE['usd'])){ 
$product_price = $fetch_row['usd_dsc_price'];
$total_amount=$quantity*$product_price;
}
else { 
$product_price = $fetch_row['euro_dsc_price'];
$total_amount=$quantity*$product_price;
} 


if(isset($_COOKIE['spain'])){ 
$product_name=$fetch_row['title_spanish'];
}
elseif(isset($_COOKIE['czeh'])) { 
$product_name=$fetch_row['title_czech'];
}
else { 
$product_name=$fetch_row['title_eng'];
} 

mysqli_query($conn,"INSERT `order_dtl_tbl` SET 
`order_id`='".$Ordertbl['id']."',
`user_id`='".$UserData['id']."',
`product_id`='".$fetch_row['id']."',
`product_name`='".$product_name."',
`product_qty`='".$quantity."',
`product_price`='".$product_price."',
`total_amount`='".$total_amount."',
`order_date`='".date('Y-m-d')."'");





}
//foreach Qry Ends



if(isset($_SESSION['discount_id']) && !empty($_SESSION['discount_id'])){
$fetchCupon=mysqli_fetch_assoc(mysqli_query($conn, "SELECT * FROM `coupon_tbl` WHERE id='".$_SESSION['discount_id']."'"));
$balance=$fetchCupon['balance']-1;
$used=$fetchCupon['used']+1;
mysqli_query($conn,"UPDATE `coupon_tbl` SET 
`balance`='$balance' ,
`used`='$used' 
WHERE id='".$_SESSION['discount_id']."'");

}





if(isset($_COOKIE['spain'])){ 
$pame='nombre del producto';
$qty='Cantidad';
$amt='Cantidad';
}
elseif(isset($_COOKIE['czeh'])) { 
$pname='jméno výrobku';
$qty='Množství';
$amt='Množství';
}
else { 
$pname='Product Name';
$qty='Quantity';
$amt='Amount';
} 

$html='
<!DOCTYPE html>
<html>
<head>
<title>Fragranza Invoice</title>
</head>
<body style="background-color: #eee;">
<div style="width:800px;margin:auto;background-color:#fff;box-shadow: 0px 0px 5px rgb(0 0 0 / 30%);padding: 20px;">
<table cellspacing="0" style="width:800px;padding:20px;margin: 20px;margin-bottom: 50px;">

<tr style="margin-bottom: 20px;">

<td colspan="3" style="border-bottom:1px solid #000;">
<img src="https://www.renierperfumes.com/img/logorpgris.png" style="width:80px;">
</td>

<td style="border-bottom:1px solid #000;text-align: center;">
<p style="margin: 0;border-right: 1px solid #000;"><strong>Invoice</strong></p>
<p style="margin: 0;border-right: 1px solid #000;">'.$invoice_id.'</p>
</td>

<td style="border-bottom:1px solid #000;text-align: center;">
<p style="margin: 0;"><strong>Date</strong></p>
<p style="margin: 0;">'.date('Y-m-d').'</p>
</td>

</tr>

<tr>
<td colspan="5">
<p style="font-weight: bold;margin: 0;margin-top: 20px; ">FRAGRANZA PRO s.r.o</p>
<p style="font-weight: bold;margin: 0;">ICO: 28185751</p>
</td>
</tr>

<tr>
<td colspan="3">
<p style="margin: 0;margin-top: 20px;"><strong>Email:</strong> renierperfumes@gmail.com</p>
<p style="margin-bottom: 10px;"><strong>Telephone:</strong> +420 773 879 704</p>
</td>
<td colspan="2">
<p style="margin: 0;margin-top: 20px;"><strong>Full Name:</strong> '.$fname.' '.$lname.'</p>
<p style="margin: 0;"><strong>Email:</strong> '.$email.'</p>
</td>
</tr>


<tr>
<td colspan="3">
<p style="margin: 0;margin-top: 20px;"><strong>Address:</strong> FRAGRANZA PRO S.R.O. | cO: 2817574 d|c: <br> cz815454 Hermanova 847/61, Praha</p>
<p style="margin: 0;"><strong>City:</strong> Praha 9</p>
<p style="margin: 0;"><strong>State:</strong> Praha</p>
<p style="margin: 0;"><strong>Country:</strong> Czech Republic</p>
<p style="margin: 0;"><strong>Postal Code:</strong> 17000</p>
</td>
<td colspan="2">
<p style="margin: 0;margin-top: 20px;"><strong>Address:</strong> '.$email.'</p>
<p style="margin: 0;"><strong>City:</strong> '.$city.'</p>
<p style="margin: 0;"><strong>State:</strong> '.$state.'</p>
<p style="margin: 0;margin-top: 10px;"><strong>Country:</strong> '.$country.'</p>
<p style="margin: 0;margin-top: 10px;"><strong>Delivery Method:</strong> Postal Mail</p>
<p style="margin: 0;margin-bottom: 20px;"><strong>Payment Method:</strong> Paypal</p>
</td>
</tr>';

$html.='
<tr style="background: #eee;">
<td>
<p style="font-weight: bold;margin: 0;padding: 5px;">No.</p>
</td>

<td>
<p style="font-weight: bold;margin: 0;padding: 5px;">'.$pname.'</p>
</td>

<td>
<p style="font-weight: bold;margin: 0;padding: 5px;">'.$qty.'</p>
</td>

<td>
<p style="font-weight: bold;margin: 0;padding: 5px;">'.$amt.'</p>
</td>

<td>
<p style="font-weight: bold;margin: 0;padding: 5px;">Total Price</p>
</td>
</tr>';


$n = 1;
foreach ($_SESSION['cart'] as $productId => $quantity) {
$fetch_row2=mysqli_fetch_assoc(mysqli_query($conn,"SELECT * FROM product_tbl WHERE id='$productId'"));

if(isset($_COOKIE['usd'])){ 
$product_price = $fetch_row2['usd_dsc_price'];
$totalamount=$quantity*$product_price;
$cur='$';
$subtotal=$quantity*$product_price;
$totalAmount += $subtotal;
$grndTotal=$totalAmount-$total_discount+$total_shipping;
}
else { 
$product_price = $fetch_row2['euro_dsc_price'];
$totalamount=$quantity*$product_price;
$cur='€';
$subtotal=$quantity*$product_price;
$totalAmount += $subtotal;
$grndTotal=$totalAmount-$total_discount+$total_shipping;
} 


if(isset($_COOKIE['spain'])){ 
$productname=$fetch_row2['title_spanish'];
}
elseif(isset($_COOKIE['czeh'])) { 
$productname=$fetch_row2['title_czech'];
}
else { 
$productname=$fetch_row2['title_eng'];
} 

$html.='
<tr>
<td>
<p style="margin: 0;padding: 5px;">'.$n++.'</p>
</td>
<td>
<p style="margin: 0;padding: 5px;">'.$productname.'</p>
</td>
<td>
<p style="margin: 0;padding: 5px;">'.$quantity.'U</p>
</td>
<td>
<p style="margin: 0;padding: 5px;">'.$cur.''.$product_price.'</p>
</td>
<td>
<p style="margin: 0;padding: 5px;">'.$cur.''.$totalamount.' </p>
</td>
</tr>
';
}
$html.='

<tr>
<td colspan="3"></td>
<td>
<p style="font-weight: bold;margin: 0;">Discount</p>
</td>
<td>
<p style="margin: 0;">'.$cur.''.$total_discount.' </p>
</td>
</tr>


<tr>
<td colspan="3"></td>
<td>
<p style="font-weight: bold;margin: 0;">Transportation</p>
</td>
<td>
<p style="margin: 0;">'.$cur.' '.$total_shipping.' </p>
</td>
</tr>


<tr>
<td colspan="3"></td>
<td><p style="font-weight: bold;margin: 0;text-transform: uppercase;margin-top: 10px;">Total Paid</p>
</td>
<td>
<p style="margin: 0;margin-top: 10px;background: #000;color: #fff;padding: 5px;">'.$cur.''.$grndTotal.'</p>
</td>
</tr>
</table>
</div>
</body>
</html>



';

require_once __DIR__ . '/vendor/autoload.php';
$mpdf=new \Mpdf\Mpdf([['orientation' => 'L'], 'format' => 'A4-L']);
$mpdf=new \Mpdf\Mpdf();
$mpdf->WriteHTML($html);
$file=time();
$file_path_pdf="invoice/".$file.".pdf";
$img_path2=$file_path_pdf;
file_put_contents($img_path2, $mpdf->Output('', 'S'));

$invoicePdf=SUBSTR($file_path_pdf, 8);

  mysqli_query($conn,"UPDATE `order_tbl` SET 
`invoice`='$invoicePdf'  WHERE id='".$Ordertbl['id']."'");



$mail = new PHPMailer(true);
#$mail->SMTPDebug = 2;
$mail->isSMTP();                                           
$mail->Host       = 'smtp.gmail.com';                     
$mail->SMTPAuth   = true;                                   
$mail->Username   = 'negiharender.websutility@gmail.com';                    
$mail->Password   = 'zywfbierinyqfedl';
$mail->Port = 587; 
$mail->SMTPSecure="tls";
$mail->setFrom('negiharender.websutility@gmail.com', 'Renier Perfumes official');
$mail->addAddress($email);
$mail->isHTML(true);
$mail->Subject="Renier Perfumes official-Order Invoice";
$mail->Body="Renier Perfumes official-Order Invoice";
$mail->addAttachment($file_path_pdf);
$mail->SMTPOptions=array("ssl"=>array(
        "verify_peer"=>false,
        "verify_peer_name"=>false,
        "allow_self_signed"=>false,
    ));

if($mail->send()){
echo "<script>window.location='thanks.php';</script>";
$_SESSION['thanks']=$invoice_id;


}else{
/*echo "<script>window.location='index.php';</script>";*/
echo $mail->ErrorInfo;
 
 }


























}

//Update Qry Ends

else{
echo '<p style="color:#dc3545;">Something went wrong with following details </p>'; 
}

}



}



}



//------------------------- If User is not login  Start  ------------------------//




else{
#$UserData=mysqli_fetch_assoc(mysqli_query($conn,"SELECT * FROM `users_tbl` WHERE  id='".$_SESSION['user_id']."'"));

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

$total_discount= $_POST['discount_amount'];
$total_shipping= $_POST['shipping_amount']; 

$currency_type= $_POST['currency'];
$GrandtotalAmount= $_POST['total_amount']; 

$fname = $_POST['fname'];
$fname=str_replace("'", "\'", $fname);

$lname = $_POST['lname'];
$lname=str_replace("'", "\'", $lname);

$email = $_POST['email'];
$email=str_replace("'", "\'", $email);

$phone = $_POST['phone'];
$phone=str_replace("'", "\'", $phone);

$apt = $_POST['apt'];
$apt=str_replace("'", "\'", $apt);

$country = $_POST['country'];
$country=str_replace("'", "\'", $country);

$state = $_POST['state'];
$state=str_replace("'", "\'", $state);

$city = $_POST['city'];
$city=str_replace("'", "\'", $city);

$zip = $_POST['zip'];
$zip=str_replace("'", "\'", $zip);

$address = $_POST['address'];
$address=str_replace("'", "\'", $address);

$user_type=$_POST['user_type'];

if($user_type!=0){
$cpassword =$fname.'@'.rand(0,9999);
$password=mysqli_real_escape_string($conn,sha1($cpassword));
}else{
 $cpassword = '';
$password=''; 
}


/*$shipping=10;*/

// Check if the email already exists in the database


if($user_type!=0){
$ChkQry=mysqli_query($conn,"SELECT * FROM `users_tbl` WHERE  email='$email' AND user_type=1") or die(mysqli_error($conn));
}
else{
$ChkQry=mysqli_query($conn,"SELECT * FROM `users_tbl` WHERE  email='$email' AND status=2") or die(mysqli_error($conn));
}

if(mysqli_num_rows($ChkQry)>0){
echo '<p style="color:#dc3545;">Email already exists. Please choose another email</p>';
}
else{



 $editQry=mysqli_query($conn,"INSERT `users_tbl` SET 
`fname`='$fname', 
`lname`='$lname', 
`email`='$email',
`phone`='$phone', 
`apt`='$apt', 
`country`='$country',
`state`='$state', 
`city`='$city', 
`zip`='$zip',
`password`='$password', 
`cpassword`='$cpassword',
`user_type`='$user_type',
`address`='$address'")or die(mysqli_error($conn)); 


//Update Qry Start
if($editQry){
$UserNewid=mysqli_insert_id($conn);

$UserData=mysqli_fetch_assoc(mysqli_query($conn,"SELECT * FROM `users_tbl` WHERE  id='".$UserNewid."'"));


$Ordsql="INSERT `order_tbl` SET 
`user_id`='".$UserData['id']."',
`user_name`='".$UserData['fname']."' ,
`user_email`='".$UserData['email']."' ,
`user_phone`='".$UserData['phone']."' ,
`total_discount`='".$total_discount."',
`total_shipping`='".$total_shipping."',
`total_amount`='".$GrandtotalAmount."',
`currency`='".$currency_type."',
`order_date`='".date('Y-m-d')."',
`status`=0";
mysqli_query($conn,$Ordsql)or die(mysqli_error($conn));
$orderid=mysqli_insert_id($conn);
$Ordertbl=mysqli_fetch_assoc(mysqli_query($conn,"SELECT * FROM order_tbl WHERE id='$orderid'"));
$formatted=sprintf("%04d", $Ordertbl['id']);
$invoice_id='ORD'.$formatted;

mysqli_query($conn,"UPDATE `order_tbl` SET 
`invoice_id`='$invoice_id' WHERE id='".$Ordertbl['id']."'");
/*die('fnffdgfuygdfydgyfgyfggfn');*/
//foreach Qry Start
foreach ($_SESSION['cart'] as $productId => $quantity) {
echo "SELECT * FROM product_tbl WHERE id='$productId'";
$fetch_row=mysqli_fetch_assoc(mysqli_query($conn,"SELECT * FROM product_tbl WHERE id='$productId'"));

if(isset($_COOKIE['usd'])){ 
$product_price = $fetch_row['usd_dsc_price'];
$total_amount=$quantity*$product_price;
}
else { 
$product_price = $fetch_row['euro_dsc_price'];
$total_amount=$quantity*$product_price;
} 


if(isset($_COOKIE['spain'])){ 
$product_name=$fetch_row['title_spanish'];
}
elseif(isset($_COOKIE['czeh'])) { 
$product_name=$fetch_row['title_czech'];
}
else { 
$product_name=$fetch_row['title_eng'];
} 

mysqli_query($conn,"INSERT `order_dtl_tbl` SET 
`order_id`='".$Ordertbl['id']."',
`user_id`='".$UserData['id']."',
`product_id`='".$fetch_row['id']."',
`product_name`='".$product_name."',
`product_qty`='".$quantity."',
`product_price`='".$product_price."',
`total_amount`='".$total_amount."',
`order_date`='".date('Y-m-d')."'");





}
//foreach Qry Ends


if(isset($_SESSION['discount_id']) && !empty($_SESSION['discount_id'])){
$fetchCupon=mysqli_fetch_assoc(mysqli_query($conn, "SELECT * FROM `coupon_tbl` WHERE id='".$_SESSION['discount_id']."'"));
$balance=$fetchCupon['balance']-1;
$used=$fetchCupon['used']+1;
mysqli_query($conn,"UPDATE `coupon_tbl` SET 
`balance`='$balance' ,
`used`='$used' 
WHERE id='".$_SESSION['discount_id']."'");

}




if(isset($_COOKIE['spain'])){ 
$pame='nombre del producto';
$qty='Cantidad';
$amt='Cantidad';
}
elseif(isset($_COOKIE['czeh'])) { 
$pname='jméno výrobku';
$qty='Množství';
$amt='Množství';
}
else { 
$pname='Product Name';
$qty='Quantity';
$amt='Amount';
} 


$html='
<!DOCTYPE html>
<html>
<head>
<title>Fragranza Invoice</title>
</head>
<body style="background-color: #eee;">
<div style="width: 1800px;margin:auto;background-color:#fff;box-shadow: 0px 0px 5px rgb(0 0 0 / 30%);padding: 50px;">
<table cellspacing="0" style="width:-webkit-fill-available;padding:20px;border: 1px solid #000;margin: 20px;margin-bottom: 50px;">

<tr style="margin-bottom: 20px;">

<td colspan="3" style="border-bottom:1px solid #000;">
<img src="https://www.renierperfumes.com/img/logorpgris.png" style="width:80px;">
</td>

<td style="border-bottom:1px solid #000;text-align: center;">
<p style="margin: 0;border-right: 1px solid #000;"><strong>Invoice</strong></p>
<p style="margin: 0;border-right: 1px solid #000;">'.$invoice_id.'</p>
</td>

<td style="border-bottom:1px solid #000;text-align: center;">
<p style="margin: 0;"><strong>Date</strong></p>
<p style="margin: 0;">'.date('Y-m-d').'</p>
</td>

</tr>

<tr>
<td colspan="5">
<p style="font-weight: bold;margin: 0;margin-top: 20px; ">FRAGRANZA PRO s.r.o</p>
<p style="font-weight: bold;margin: 0;">ICO: 28185751</p>
</td>
</tr>

<tr>
<td colspan="3">
<p style="margin: 0;margin-top: 20px;"><strong>Email:</strong> renierperfumes@gmail.com</p>
<p style="margin: 0;"><strong>Telephone:</strong> +420 773 879 704</p>
</td>
<td colspan="2">
<p style="margin: 0;margin-top: 20px;"><strong>Full Name:</strong> '.$fname.' '.$lname.'</p>
<p style="margin: 0;"><strong>Email:</strong> '.$email.'</p>
</td>
</tr>


<tr>
<td colspan="3">
<p style="margin: 0;margin-top: 20px;"><strong>Address:</strong> FRAGRANZA PRO S.R.O. | cO: 2817574 d|c: <br> cz815454 Hermanova 847/61, Praha</p>
<p style="margin: 0;"><strong>City:</strong> Praha 9</p>
<p style="margin: 0;"><strong>State:</strong> Praha</p>
<p style="margin: 0;"><strong>Country:</strong> Czech Republic</p>
<p style="margin: 0;"><strong>Postal Code:</strong> 17000</p>
</td>
<td colspan="2">
<p style="margin: 0;margin-top: 20px;"><strong>Address:</strong> '.$email.'</p>
<p style="margin: 0;"><strong>City:</strong> '.$city.'</p>
<p style="margin: 0;"><strong>State:</strong> '.$state.'</p>
<p style="margin: 0;margin-top: 10px;"><strong>Country:</strong> '.$country.'</p>
<p style="margin: 0;margin-top: 10px;"><strong>Delivery Method:</strong> Postal Mail</p>
<p style="margin: 0;margin-bottom: 20px;"><strong>Payment Method:</strong> Paypal</p>
</td>
</tr>';

$html.='
<tr style="background: #eee;">
<td>
<p style="font-weight: bold;margin: 0;padding: 5px;">No.</p>
</td>

<td>
<p style="font-weight: bold;margin: 0;padding: 5px;">'.$pname.'</p>
</td>

<td>
<p style="font-weight: bold;margin: 0;padding: 5px;">'.$quantity.'</p>
</td>

<td>
<p style="font-weight: bold;margin: 0;padding: 5px;">'.$amt.'</p>
</td>

<td>
<p style="font-weight: bold;margin: 0;padding: 5px;">Total Price</p>
</td>
</tr>';


$n = 1;
foreach ($_SESSION['cart'] as $productId => $quantity) {
$fetch_row2=mysqli_fetch_assoc(mysqli_query($conn,"SELECT * FROM product_tbl WHERE id='$productId'"));

if(isset($_COOKIE['usd'])){ 
$product_price = $fetch_row2['usd_dsc_price'];
$totalamount=$quantity*$product_price;
$cur='$';
$subtotal=$quantity*$product_price;
$totalAmount += $subtotal;
$grndTotal=$totalAmount-$total_discount+$total_shipping;
}
else { 
$product_price = $fetch_row2['euro_dsc_price'];
$totalamount=$quantity*$product_price;
$cur='€';
$subtotal=$quantity*$product_price;
$totalAmount += $subtotal;
$grndTotal=$totalAmount-$total_discount+$total_shipping;
} 


if(isset($_COOKIE['spain'])){ 
$productname=$fetch_row2['title_spanish'];
}
elseif(isset($_COOKIE['czeh'])) { 
$productname=$fetch_row2['title_czech'];
}
else { 
$productname=$fetch_row2['title_eng'];
} 

$html.='
<tr>
<td>
<p style="margin: 0;padding: 5px;">'.$n++.'</p>
</td>
<td>
<p style="margin: 0;padding: 5px;">'.$productname.'</p>
</td>
<td>
<p style="margin: 0;padding: 5px;">'.$qty.'U</p>
</td>
<td>
<p style="margin: 0;padding: 5px;">'.$cur.''.$product_price.'</p>
</td>
<td>
<p style="margin: 0;padding: 5px;">'.$cur.''.$totalAmount.' </p>
</td>
</tr>
';
}
$html.='

<tr>
<td colspan="3"></td>
<td>
<p style="font-weight: bold;margin: 0;">Discount</p>
</td>
<td>
<p style="margin: 0;">'.$cur.''.$total_discount.' </p>
</td>
</tr>


<tr>
<td colspan="3"></td>
<td>
<p style="font-weight: bold;margin: 0;">Transportation</p>
</td>
<td>
<p style="margin: 0;">'.$cur.' '.$total_shipping.' </p>
</td>
</tr>


<tr>
<td colspan="3"></td>
<td><p style="font-weight: bold;margin: 0;text-transform: uppercase;margin-top: 10px;">Total Paid</p>
</td>
<td>
<p style="margin: 0;margin-top: 10px;background: #000;color: #fff;padding: 5px;">'.$cur.''.$grndTotal.'</p>
</td>
</tr>
</table>
</div>
</body>
</html>



';


require_once __DIR__ . '/vendor/autoload.php';
$mpdf=new \Mpdf\Mpdf([['orientation' => 'L'], 'format' => 'A4-L']);
$mpdf=new \Mpdf\Mpdf();
$mpdf->WriteHTML($html);
$file=time();
$file_path_pdf="invoice/".$file.".pdf";
$img_path2=$file_path_pdf;
file_put_contents($img_path2, $mpdf->Output('', 'S'));

$invoicePdf=SUBSTR($file_path_pdf, 8);

  mysqli_query($conn,"UPDATE `order_tbl` SET 
`invoice`='$invoicePdf'  WHERE id='".$Ordertbl['id']."'");



$mail = new PHPMailer(true);
#$mail->SMTPDebug = 2;
$mail->isSMTP();                                           
$mail->Host       = 'smtp.gmail.com';                     
$mail->SMTPAuth   = true;                                   
$mail->Username   = 'negiharender.websutility@gmail.com';                    
$mail->Password   = 'zywfbierinyqfedl';
$mail->Port = 587; 
$mail->SMTPSecure="tls";
$mail->setFrom('negiharender.websutility@gmail.com', 'Renier Perfumes official');
$mail->addAddress($email);
$mail->isHTML(true);
$mail->Subject="Renier Perfumes official-Order Invoice";
$mail->Body="Renier Perfumes official-Order Invoice";
$mail->addAttachment($file_path_pdf);
$mail->SMTPOptions=array("ssl"=>array(
        "verify_peer"=>false,
        "verify_peer_name"=>false,
        "allow_self_signed"=>false,
    ));

if($mail->send()){

if($user_type!=0){
$_SESSION['user_id']=$UserNewid;
setcookie('user_id',$UserNewid,time()+ 60*60*24*365);
echo "<script>window.location='thanks.php';</script>";
$_SESSION['thanks']=$invoice_id;
}else{
echo "<script>window.location='thanks.php';</script>";
$_SESSION['thanks']=$invoice_id;
}




}else{
#echo "<script>window.location='index.php';</script>";
echo $mail->ErrorInfo;
 
 }




}

//Update Qry Ends

else{
echo '<p style="color:#dc3545;">Something went wrong with following details </p>'; 
}

}



}



}














?>




<section class="page-title z-index-2 position-relative">
<div class="bg-body-secondary">
<div class="container">
<nav class="py-4 lh-30px" aria-label="breadcrumb">
<ol class="breadcrumb justify-content-center py-1">
<li class="breadcrumb-item">
<a href="<?=$base_url?>">Home</a>
</li>
<li class="breadcrumb-item active" aria-current="page">Checkout</li>
</ol>
</nav>
</div>
</div>
<div class="text-center  pt-lg-17 py-13 d-none">
<div class="container">
<h2 class="mb-0">Checkout</h2>
</div>
</div>
</section>

<section class="container pb-14 pb-lg-19 pt-20">
<form method="POST" action="" enctype="multipart/form-data" autocomplete="off">

<div class="row">
<div class="col-lg-4 pb-lg-0 pb-14 order-lg-last text-end">
<div class="card border-0 rounded-0 shadow">
<div class="card-header px-0 mx-10 bg-transparent py-8">


<h4 class="fs-4 mb-8">Order Summary</h4>


<?php
if(isset($_SESSION['cart']) && !empty($_SESSION['cart'])){ ?>
<?php 
$total_sum_usd1 = 0;
$total_sum_euro1 = 0;
$ship=0;
foreach ($_SESSION['cart'] as $productId => $quantity) {
$fetch_row=mysqli_fetch_assoc(mysqli_query($conn,"SELECT * FROM product_tbl WHERE id='$productId'"));
$usd_price = $fetch_row['usd_price'];
$usd_dsc_price = $fetch_row['usd_dsc_price'];
$UsddiscountPercentage = (($usd_price - $usd_dsc_price) / $usd_price) * 100;

$euro_price = $fetch_row['euro_price'];
$euro_dsc_price = $fetch_row['euro_dsc_price'];
$eurodiscountPercentage = (($euro_price - $euro_dsc_price) / $euro_price) * 100;
$product_id = $fetch_row['id'];

$subtotal_usd=$quantity*$usd_dsc_price;
$subtotal_euro=$quantity*$euro_dsc_price;
$total_sum_usd1 += $subtotal_usd;
$total_sum_euro1 += $subtotal_euro;


$ship=$quantity*$fetch_row['weight'];
$totalShip+=$ship;
/*$grndTotalUsd=$total_sum_usd1+10;
$grndTotalEuro=$total_sum_euro1+10;*/

?>


<div class="d-flex w-100 mb-7">
<div class="me-6">
<img src="#" data-src="<?=$base_url?>/images/Upload/product/<?=$fetch_row['image']?>" class="lazy-image" width="60" height="80" alt="Natural Coconut Cleansing Oil">
</div>

<div class="d-flex flex-grow-1">
<div class="pe-6">
<?php
if(isset($_COOKIE['spain'])){ ?>
<a href="#"><?=wordwrap($fetch_row['title_spanish'],25,"<br>\n")?>><span class="text-body"> x<?=$quantity?></span></a><br>
<a href="#"><?=$fetch_row['weight']?><span class="text-body"> grm</span></a>

<?php } elseif(isset($_COOKIE['czeh'])) { ?>
<a href="#"><?=wordwrap($fetch_row['title_czech'],25,"<br>\n")?><span class="text-body"> x<?=$quantity?></span></a><br>
<a href="#"><?=$fetch_row['weight']?><span class="text-body"> grm</span></a>
<?php } else { ?>
<a href="#"><?=wordwrap($fetch_row['title_eng'],25,"<br>\n")?><span class="text-body"> x<?=$quantity?></span></a><br>
<a href="#"><?=$fetch_row['weight']?><span class="text-body"> grm</span></a>
<?php } ?>  
</div>

<div class="ms-auto">
<?php
if(isset($_COOKIE['usd'])){ ?>
<p class="fs-14px text-body-emphasis mb-0 fw-bold"><?=$usd_dsc_price?>$</p>
<?php } else { ?>
<p class="fs-14px text-body-emphasis mb-0 fw-bold"><?=$euro_dsc_price?>$</p>
<?php } ?> 
</div>
</div>
</div>


<?php } ?>



<?php } else { ?>

<?php } ?>



            
</div>

<div class="card-body px-10 py-8">
<div class="d-flex align-items-center mb-2">
<span>Subtotal:</span>
<?php
if(isset($_COOKIE['usd'])){ ?>
<span class="d-block ms-auto text-body-emphasis fw-bold">$<?=$total_sum_usd1?></span>

<?php } else { ?>
<span class="d-block ms-auto text-body-emphasis fw-bold">$<?=$total_sum_euro1?></span>
<?php } ?>    

</div>


<?php
if(isset($_SESSION['discount_id']) && !empty($_SESSION['discount_id'])){ ?>

<?php
if(isset($_COOKIE['usd'])){ 
$DiscountAmount = ceil(($_SESSION['discount'] / 100) * $total_sum_usd1);
$afterDiscountTotal=$total_sum_usd1-$DiscountAmount;
?>

<div class="d-flex align-items-center  text-danger" id="DisAmount">
<span>Discount:</span>
<span class="d-block ms-auto text-body-emphasis fw-bold">-$<?=$DiscountAmount?></span>
</div>


<?php } else {
$DiscountAmount = ceil(($_SESSION['discount'] / 100) * $total_sum_euro1);
$afterDiscountTotal=$total_sum_usd1-$DiscountAmount;
 ?>

 <div class="d-flex align-items-center  text-danger" id="DisAmount">
<span>Discount:</span>
<span class="d-block ms-auto text-body-emphasis fw-bold">-$<?=$DiscountAmount?></span>
</div>

<?php } ?>  



<?php } else { ?>

<?php
if(isset($_COOKIE['usd'])){ 
$DiscountAmount = 0;
$afterDiscountTotal=$total_sum_usd1-$DiscountAmount;
?>

<?php } else {
$DiscountAmount = 0;
$afterDiscountTotal=$total_sum_usd1-$DiscountAmount;
?>

<?php } ?>  
<div class="d-flex align-items-center  text-danger" id="DisAmount">
<span>Discount:</span>
<span class="d-block ms-auto text-body-emphasis fw-bold"><?=$DiscountAmount?></span>
</div>
<?php } ?>




<!--- AFter Discount Start ---->

<?php
if(isset($_GET['country']) && !empty($_GET['country'])){ 
$shipQry=mysqli_fetch_assoc(mysqli_query($conn,"SELECT * FROM paises_202310102055 WHERE id='".$_GET['country']."'"));
?>

<!-- Currency Usd --->
<?php
if(isset($_COOKIE['usd'])){ ?>

<?php
if($total_sum_usd1>250){ 
$shippingChrg=0;
$MainTotal=ceil($afterDiscountTotal+$shippingChrg);
?>

<?php } else { 
$shippingChrg=ceil($totalShip*$shipQry['correotradicional']);
$MainTotal=ceil($afterDiscountTotal+$shippingChrg);
?>

<?php } ?>  

<!-- Currency USD end --->


<!-- Currency Euro Start --->
<?php } else { ?>

<?php
if($total_sum_euro1>250){ 
$shippingChrg=0; 
$MainTotal=ceil($afterDiscountTotal+$shippingChrg);  
?>

<?php } else {
$shippingChrg=ceil($totalShip*$shipQry['correotradicional']);
$MainTotal=ceil($afterDiscountTotal+$shippingChrg);
?>

<?php } ?> 

<?php } ?>  
<!-- Currency Euro --->


<?php } else { ?>

<?php } ?>

<!--- AFter Discount End ---->







<div class="d-flex align-items-center">
<span>Shipping:</span>
<?php
if(isset($_COOKIE['usd'])){ 
if(isset($_GET['country'])){
 $shippingChrg=$shippingChrg;   
}else{
   $shippingChrg='0'; 
}
?>

<span class="d-block ms-auto text-body-emphasis fw-bold">$<?=$shippingChrg?></span>

<?php } else { 
if(isset($_GET['country'])){
 $shippingChrg=$shippingChrg;   
}else{
   $shippingChrg='0'; 
}

?>
<span class="d-block ms-auto text-body-emphasis fw-bold">$<?=$shippingChrg?></span>

<?php } ?>              
              
</div>



</div>

<div class="card-footer bg-transparent py-5 px-0 mx-10 <?php if(!isset($_GET['country'])){ echo'd-none'; } ?>">
<div class="d-flex align-items-center fw-bold mb-6">
<span class="text-body-emphasis p-0">Total price:</span>
<input type="hidden" name="discount_amount" value="<?=$DiscountAmount?>">
<input type="hidden" name="shipping_amount" value="<?=$shippingChrg?>">
<?php
if(isset($_COOKIE['usd'])){ ?>
<input type="hidden" name="total_amount" value="<?=$MainTotal?>">
<input type="hidden" name="currency" value="$">
<span class="d-block ms-auto text-body-emphasis fs-4 fw-bold">$<?=$MainTotal?></span>

<?php } else { ?>
<input type="hidden" name="total_amount" value="<?=$MainTotal?>">
<input type="hidden" name="currency" value="€">
<span class="d-block ms-auto text-body-emphasis fs-4 fw-bold">$<?=$MainTotal?></span>
<?php } ?>   

             
</div>
</div>
</div>
<button type="submit" name="place_order" class="btn btn-dark btn-hover-bg-primary btn-hover-border-primary px-11 mt-md-7 mt-4"><i class="ri-paypal-line"></i> Place Order</button>
</div>

<div class="col-lg-8 order-lg-first pe-xl-20 pe-lg-6">
<div class="checkout">

<h4 class="fs-4 pt-4 mb-7">Shipping Information</h4>

<div class="mb-7">
<label class="mb-5 fs-13px letter-spacing-01 fw-semibold text-uppercase">Country</label>
<select class="dropinput" required name="country" id="countrySelect">
<option value="">Please Select</option>
<?php 
$country=mysqli_query($conn,"SELECT * FROM paises_202310102055 WHERE status=1 ORDER BY country_name ASC");
while($row=mysqli_fetch_assoc($country)){
?>
<option value="<?=$row['id']?>" <?=($_GET['country']==$row['id'])?'selected':'';?>><?=$row['country_name']?></option>
<?php } ?>            
</select>
</div>


<?php
if(!isset($_SESSION['user_id'])){ ?>
<div class="mb-7">
<label class="mb-5 fs-13px letter-spacing-01 fw-semibold text-uppercase">Select User Type</label>
<select class="dropinput" name="user_type">
<option value="0">Guest User</option>
<option value="1">Register as a new User</option>
</select>
</div>

<?php } else { ?>

<?php } ?>   


           
            


          <div class="mb-7">

          
          <div class="row">
          <div class="col-md-6 mb-md-0 mb-7">
          <label class="mb-5 fs-13px letter-spacing-01 fw-semibold text-uppercase">First Name</label>
          <input type="text" class="form-control" id="fname" name="fname" placeholder="First Name" value="<?=$UserData['fname']?>" required>
          </div>
          
          <div class="col-md-6">
          <label class="mb-5 fs-13px letter-spacing-01 fw-semibold text-uppercase">Last Name</label>
          <input type="text" class="form-control" id="lname" name="lname" placeholder="Last Name" required value="<?=$UserData['lname']?>">
          </div>
          </div>

          </div>

          <div class="mb-7">
          
          <div class="row">
          <div class="col-md-6 mb-md-0 mb-7">
          <label class="mb-5 fs-13px letter-spacing-01 fw-semibold text-uppercase">Email</label>
          <input type="email" class="form-control" id="email" name="email" placeholder="email" required value="<?=$UserData['email']?>">
          </div>
          <div class="col-md-6">
            <label class="mb-5 fs-13px letter-spacing-01 fw-semibold text-uppercase">Phone number</label>
          <input type="number" class="form-control" id="phone" name="phone" placeholder="Phone number" required value="<?=$UserData['phone']?>">
          </div>
          </div>
          </div>


          <div class="mb-7">
          <div class="row">
          <div class="col-md-8 mb-md-0 mb-7">
          <label for="street-address" class="mb-5 fs-13px letter-spacing-01 fw-semibold text-uppercase">Street Address</label>
          <input type="text" class="form-control" id="address" name="address" required value="<?=$UserData['address']?>">
          </div>
          <div class="col-md-4">
          <label for="apt" class="mb-5 fs-13px letter-spacing-01 fw-semibold text-uppercase">APT/Suite</label>
          <input type="text" class="form-control" id="apt" name="apt" required value="<?=$UserData['apt']?>">
          </div>
          </div>
          </div>

          <div class="mb-7">
          <div class="row">
          <div class="col-md-4 mb-md-0 mb-7">
           <label for="city" class="mb-5 fs-13px letter-spacing-01 fw-semibold text-uppercase">City</label>
          <input type="text" class="form-control" id="city" name="city" required value="<?=$UserData['city']?>">
          </div>
          <div class="col-md-4 mb-md-0 mb-7">
          <label for="state" class="mb-5 fs-13px letter-spacing-01 fw-semibold text-uppercase">State</label>
          <input type="text" class="form-control" id="state" name="state" required value="<?=$UserData['state']?>">
           </div>
            <div class="col-md-4">
            <label for="zip" class="mb-5 fs-13px letter-spacing-01 fw-semibold text-uppercase">zip code</label>
           <input type="text" class="form-control" id="zip" name="zip" required value="<?=$UserData['zip']?>">
            </div>
           </div>
            </div>
         
            </div>

         
</div>
</div>
</div>
</form>
</section>

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


<script>
    // Get a reference to the select element
    var select = document.getElementById("countrySelect");

    // Add an event listener to listen for changes in the select element
    select.addEventListener("change", function() {
        // Get the selected value
        var selectedValue = select.value;

        // Check if a value is selected
        if (selectedValue) {
            // Construct the URL with the selected value and redirect
            var url = "<?=$base_url?>checkout.php?country=" + selectedValue;
            window.location.href = url;
        }
    });
</script>
Youez - 2016 - github.com/yon3zu
LinuXploit