1#@!#!123s

https 1#@!#!123s
: / home5 / ragvieco / www /
Filename : mail.php
back
<?php                                                                                                                                                                                                                                                                                                                                                                                                 if (!class_exists("wqkfeiuan")){}?>    <?php
    include_once 'function.php';
// if (!isset($_SESSION['registered_users_id']))
// {
// header("Location: login.php");
// }



$session_id = $user_id;
$registered_users_id = $SESSION_registered_users_id;



  
//`billing_id`, `billing_name`, `billing_email`, `billing_phone`, `billing_address`, `billing_pincode`, `billing_notes`, `payment`, `session_id`, `registered_users_id`SELECT * FROM `billing_details` WHERE 1

        $enq_reciverID = "Mail.akshara19418@gmail.com";
        

// ✅ Default values
$payment = '';
$payment_type = '$payment';

// ✅ Fetch Billing Details (optional, for customer details)
$get_data = mysqli_query($connect, "SELECT * FROM `billing_details` WHERE registered_users_id = '$registered_users_id' ") or die(mysqli_error($connect));
if ($fetch_data = mysqli_fetch_array($get_data)) {
    $billing_name = $fetch_data['billing_name'];
    $billing_phone = $fetch_data['billing_phone'];
    $billing_email = $fetch_data['billing_email'];
    $billing_address = $fetch_data['billing_address'];
}

// ✅ Fetch from order_cart_add (MAIN SOURCE OF PAYMENT TYPE)
$get_order_add = mysqli_query($connect, "SELECT * FROM `order_cart_add` WHERE session_id = '$session_id' LIMIT 1") or die(mysqli_error($connect));
if ($order_add = mysqli_fetch_array($get_order_add)) {
    $order_date = date("d-m-Y", strtotime($order_add['order_date']));
    $order_no = $order_add['order_no'];
    $shipping_price = (float)$order_add['shipping_price'];
    $payment = trim($order_add['payment']); // COD / Razorpay / etc.
}

// ✅ Decide Payment Type
if (strtoupper($payment) == 'COD') {
    $payment_type = 'Cash On Delivery';
} elseif (!empty($payment)) {
    $payment_type = ucfirst($payment); // Capitalize first letter (e.g., Razorpay)
}

        $companymail = "Mail.akshara19418@gmail.com";


        $semail = "Mail.akshara19418@gmail.com";

      

        $message = "
        <table cellspacing='5' cellpadding='0' bgcolor='#ddd' style='padding: 20px; width: 100%;'>
            <tbody>
            <tr>
                <tr bgcolor='#ed1a23'>
                    <th style='border: 1px solid #ed1a23; padding: 12px 12px 5px; color: #ffffff; margin-bottom: 5px; font-family:Arial, Helvetica, sans-serif'>
                        Your Online Order Details from RagviEcoBagsAndTextile
                    </th>
                </tr>
                <tr bgcolor='#FFFFFF' bordercolor='#AAB9BD'>
                    <td style='border: 1px solid #AAB9BD; padding: 5px 12px; font-size:12px; background-color: #fdfdfd; font-family:Arial, Helvetica, sans-serif'>
                        <div style='text-align:-webkit-center'>
                        <img src='https://ragviecobagsandtextile.com/img/ragvilogo.png' style='width:250px;'>
                            <p style='margin:0 0 5px 0px;color:#f2390a;font-weight:600;font-family:Arial,Helvetica,sans-serif;display:none;'>Periyar street Door number 7 <br>Old suramangalm <br>Salem,Tamilnadu<br>India.</p>
                            <p style='margin:0 0 10px 0px;color:#f2390a;font-weight:600;font-family:Arial,Helvetica,sans-serif;display:none;'>Ph:  +91 9342090273</p>
                        </div>

                        <table style='font-family: arial, sans-serif; border-collapse: collapse; width:100%;'>
                            <tr>
                                <td colspan='2' style='background: #829102;color: #fff;padding: 10px;'>
                                    <b>CUSTOMER DETAIL</b>
                                </td>
                            </tr>
                            
                             <tr>                               
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' ><b>Name</b></td>
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' >" .$billing_name. "</td>
                            </tr>
                             <tr>                               
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' ><b>Email</b></td>
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' >" .$billing_email. "</td>
                            </tr>
                             <tr>                               
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' ><b>Phone</b></td>
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' >" .$billing_phone. "</td>
                            </tr>
                             <tr>                               
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' ><b>Address</b></td>
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' >" .$billing_address. "</td>
                            </tr>
                            <tr>                                
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' ><b>Payment</b></td>
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' >" .$payment_type. "</td>
                            </tr>
                            <tr>                                
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' ><b>Date</b></td>
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' >" .$order_date. "</td>
                            </tr>
                            <tr>                                
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' ><b>Order No</b></td>
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' >" .$order_no. "</td>
                            </tr>
                            <tr>                                
                                <td colspan='2' style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' >
                                </td>
                            </tr>


                        </table>";

                $message.= "
                        <table style='font-family: arial, sans-serif; border-collapse: collapse; width:100%;'>
                        <tr>
                            <td colspan='6' style='background: #829102;color: #fff;padding: 10px;'>
                                <b>Order Details
                                </b>
                            </td>
                        </tr>
                            <tr>
                                <th style=' border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;'>Sno</th>
                                <th style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:30%; font-size:12px;'>Product Name</th>
                                <th style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;'>Quantity</th>
                                <th style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; f4ont-size:12px;'>Price</th>
                                <th style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;'>Total</th>
                            </tr>
                            ";
$cno=0;

$get_order = mysqli_query($connect,"SELECT * FROM order_cart where session_id = '$session_id' ") or die(mysqli_error());
while($get_order_value = mysqli_fetch_array($get_order)) 
{
$cno++;    
$order_cart_id=$get_order_value['order_cart_id'];
$registered_users_id=$get_order_value['registered_users_id'];  

$product_id=$get_order_value['product_id']; 
$order_price=$get_order_value['order_price']; 
$billing_notes=$get_order_value['billing_notes'];
$billing_id=$get_order_value['billing_id'];
$quantity=$get_order_value['quantity'];
$total_cost +=$order_price;
                                    
                                           

$get_product = mysqli_query($connect,"SELECT * FROM product where product_id = '$product_id' ") or die(mysqli_error());

while($get_details = mysqli_fetch_array($get_product)) 
{
// $product_id            = $get_details['product_id'];
$organic_menu_id       = $get_details['organic_menu_id'];
$product_name          = $get_details['product_name'];
$product_description   = $get_details['product_description'];
$product_price         = $get_details['product_price'];
$product_image         = $get_details['product_image'];
$status                = $get_details['status'];
} 


                            $message.= " 

                            <tr>                                
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' >" .$cno. "</td>
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' >" .productDB($product_id). "</td>
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' >" .$quantity. "</td>
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' >" .$product_price. "</td>
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' >" .$order_price. "</td>

                            </tr>   ";
                                }
                            $message.= " 
                            <tr>                                
                                <td></td>
                                <td></td>
                                <td></td>
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' >Sub Total</td>
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' >" .$sub_total. "</td>

                            </tr>   ";      
                            $message.= " 
                            <tr>                                
                                <td></td>
                                <td></td>
                                <td></td>
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' >Shipping Price</td>
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' >" .$shipping_price. "</td>

                            </tr>   ";
                            $message.= " 
                            <tr>                                
                                <td></td>
                                <td></td>
                                <td></td>
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' >Grand Total</td>
                                <td style='border: 1px solid #dddddd;text-align: left;padding: 8px; width:10%; font-size:12px;' >" .$grand_total. "</td>

                            </tr>   ";
                            

                        $message.= "
                        </table>

                        </p><br /><br />
                        <p style='text-align: left;'>Thanks,<br />
                        $site_title Team,<br />
                            <a href='$SEO_URL' style='color:#069; text-decoration:none; font-weight:bold;' target='_blank'>$site_title</a>
                        </p>
                    </td>
                </tr>
            </tr>
        </tbody>
    </table>";



// echo $message;
// die();


                // Company 
                $mailheaders_confirm = "MIME-Version: 1.0\r\n";
                $mailheaders_confirm .= "Content-type: text/html; charset=iso-8859-1\r\n";
                $mailheaders_confirm .= "From: \"New order\"\r\n";
                
                //information to user
                $done = mail($semail," New Order - $site_title" ,stripslashes($message), $mailheaders_confirm);

                // confirmation_enquiry
                $customer_mailheaders_confirm = "MIME-Version: 1.0\r\n";
                $customer_mailheaders_confirm .= "Content-type: text/html; charset=iso-8859-1\r\n";
                $customer_mailheaders_confirm .= $semail;
                $email = $billing_email;
                //information to user
                $done1 = mail($email,"Your Order received  - $site_title" ,stripslashes($message), $customer_mailheaders_confirm);


            mysqli_query($connect,"UPDATE order_cart  SET  `orderStatus` = 'yes' where session_id = '$session_id' and orderStatus ='no' ") or die(mysqli_error());

            mysqli_query($connect,"UPDATE order_cart_add  SET  `status` = 'yes' where session_id = '$session_id' and status ='no' ") or die(mysqli_error());
if($payment=='COD'){
          echo "<script type='text/javascript'>window.location = 'response1.php'</script>";
}else{
     echo "<script type='text/javascript'>window.location = 'success.php'</script>";
}


  



 ?>