query("select * from $tbl_order where id=".$_REQUEST['order_id']); $result=$obj->fetchNextObject($sql); $prosub=array(); if($result->sub_id){ $subArr=explode(",",$result->sub_id); if(count($subArr)>0){ foreach($subArr as $value){ $sqlsubs=$obj->query("SELECT b.product_id,b.subscription_type FROM user_subscription as a left join user_subscription_order_details as b on a.sub_id=b.subs_id WHERE a.userid='" . $result->user_id . "' and a.sub_id=$value"); $Subresult = $obj->fetchNextObject($sqlsubs); $prosub[$Subresult->product_id]=$Subresult->subscription_type; } } } } $moment_id = 0; $momentMixOrder = false; //Non moment or mix moment order flag $itmesQry = $obj->query("select * from $tbl_order_itmes where order_id='".$result->id."'"); $totalsku=$obj->numRows($itmesQry); while($resultItem = $obj->fetchNextObject($itmesQry)){ if(!empty($resultItem->moment_id)){ $moment_id = $resultItem->moment_id; } if($resultItem->section != 'moments') { $momentMixOrder = true; } } $moment_address = ''; if($moment_id != 0) { $momentQuery = $obj->query("SELECT fname, lname, email, phone, full_address, zipcode FROM tbl_moments WHERE id=$moment_id"); $momentData = $obj->fetchNextObject($momentQuery); // Moment Recipent Address $moment_address .= '

Moment Recipient Address:

Name: '.stripslashes($momentData->fname).' '.stripslashes($momentData->lname).' Phone: '.stripslashes($momentData->phone).'
Address: '.stripslashes($momentData->full_address).' Pincode: '.stripslashes($momentData->zipcode).'
Email: '.stripslashes($momentData->email).'
'; } ?> <?php echo SITE_TITLE; ?>
Order Details
0 && $momentMixOrder == false){ $deliveryInfo = 'Billing Information'; } else if($moment_id > 0 && $momentMixOrder == true){ $deliveryInfo = 'Delivery/Billing Information'; } ?> coupon_code!=''){ ?>
Order Date: order_date); if($added_date[0]!='0000'){ echo date("d M Y H:i",strtotime($result->order_date)); }?> Order ID: id); ?>
User ID: user_id);?> Email: ship_email);?>

First Name: ship_fname);?> Last Name: ship_lname);?>
House Number: ship_house_no);?> Street: ship_street);?>
Complex: ship_complex);?> Landmark: ship_landmark);?>
City: ship_city_id);?> Area: area;?>
Pincode: ship_pincode);?>    
Mobile: ship_mobile);?> Phone: ship_phone);?>
 

Discount Information
Coupoun Code Used: coupon_code);?>    

Payment Information
Payment Method: payment_method);?>    

Delivery Notes (if any)
delivery_note;?>      
 

Ordered Products ( Total Ordered SKUs: )
"; $itmesArr=$obj->query("select * from $tbl_order_itmes where order_id='".$result->id."'"); while($resultItem=$obj->fetchNextObject($itmesArr)){ $bg_color = ''; $sf_product = ''; if($result->ship_state == 'NY') { $store_front_quantity = check_storefront_stock($resultItem->productid); if($store_front_quantity > 0){ $bg_color = 'class="prod-color"'; $sf_product = ' - QGo'; } } $custumdate='2021-07-08 00:00:00'; $substype=''; if($result->order_date > $custumdate){ if($resultItem->subscription_type=='Weekly' || $resultItem->subscription_type=='Bi Weekly' || $resultItem->subscription_type=='Monthly'){ $substype=" ($resultItem->subscription_type Subscription)"; } } else { $substype=$prosub[$resultItem->product_id]; if($substype=='Weekly' || $substype=='Bi Weekly' || $substype=='Monthly'){ $substype=" ($substype Subscription)"; } } $enq_message.=""; } $enq_message.=" "; if($result->special_discount!=''){ $enq_message.=""; } if($result->other_discount>0){ $enq_message.=""; } $enq_message.=" "; if($result->expres_amt>0){ $enq_message.=""; }else{ $enq_message.=""; } $enq_message.=""; $enq_message.=""; if($result->saving>0){ $enq_message.=""; } $enq_message.="

Product Purchased

Qty

Unit Price($website_currency_symbol)

Price ($website_currency_symbol)
         
".$resultItem->product_name.$resultItem->size_type.$substype.$sf_product." ".$resultItem->user_replacement_option." ".$resultItem->qty." ".number_format($resultItem->price,2)." $website_currency_symbol ".number_format($resultItem->price*$resultItem->qty,2)."
    Billed Amount $website_currency_symbol ".number_format($result->amount,2)."
    Tax $website_currency_symbol ".number_format($result->tax_value,2)."
    Special Discount $website_currency_symbol ".number_format($result->special_discount,2)."
    ".$result->other_discount_via." Discount $website_currency_symbol".number_format($result->other_discount,2)."
    Discounts $website_currency_symbol ".number_format($result->discount,2)."
    Express Delivery $website_currency_symbol ".number_format($result->expres_amt,2)."
    Delivery Charges $website_currency_symbol ".number_format($result->shipping_amount,2)."
    Minimum Order Charge $website_currency_symbol ".number_format($result->min_order_charge,2)."
    Tip $website_currency_symbol ".number_format($result->drivertip,2)."
    Saving $website_currency_symbol ".number_format($result->saving,2)."
    Total Amount: $website_currency_symbol ".number_format($result->total_amount,2)."
"; echo $enq_message;?>