public function export_data()
{
require_once JPATH_COMPONENT . '/helpers/order.php';
$order_function = new order_functions();
$model = $this->getModel('order_container');
$data = $model->export_data();
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-type: text/x-csv");
header("Content-type: text/csv");
header("Content-type: application/csv");
header('Content-Disposition: attachment; filename=Order.csv');
echo "Order id,Fullname,Order Status,Order Date,Total\n\n";
for ($i = 0; $i < count($data); $i++) {
echo $data[$i]->order_id . ",";
echo $data[$i]->firstname . " " . $data[$i]->lastname . ",";
echo $order_function->getOrderStatusTitle($data[$i]->order_status) . ",";
echo date('d-m-Y H:i', $data[$i]->cdate) . ",";
echo REDCURRENCY_SYMBOL . $data[$i]->order_total . "\n";
}
exit;
}
$onclick = "onclick='window.open(\"{$print_url}\",\"mywindow\",\"scrollbars=1\",\"location=1\")'";
}
$print_tag = "<a " . $onclick . " title='" . JText::_('COM_REDSHOP_PRINT_LBL') . "'>";
$print_tag .= "<img src='" . JSYSTEM_IMAGES_PATH . "printButton.png' alt='" . JText::_('COM_REDSHOP_PRINT_LBL') . "' title='" . JText::_('COM_REDSHOP_PRINT_LBL') . "' />";
$print_tag .= "</a>";
$template_desc = str_replace("{print}", $print_tag, $template_desc);
if (strstr($template_desc, "{product_loop_start}") && strstr($template_desc, "{product_loop_end}")) {
$template_sdata = explode('{product_loop_start}', $template_desc);
$template_start = $template_sdata[0];
$template_edata = explode('{product_loop_end}', $template_sdata[1]);
$template_end = $template_edata[1];
$template_middle = $template_edata[0];
$cart_mdata = "";
for ($i = 0; $i < count($this->detail); $i++) {
$prolist = $order_function->getOrderItemDetail($this->detail[$i]->order_id);
$statusname = $order_function->getOrderStatusTitle($this->detail[$i]->order_status);
$order_item_name = array();
for ($j = 0; $j < count($prolist); $j++) {
$order_item_name[$j] = $prolist[$j]->order_item_name;
}
$orderdetailurl = JRoute::_('index.php?option=com_redshop&view=order_detail&oid=' . $this->detail[$i]->order_id);
$reorderurl = JUri::root() . 'index.php?option=com_redshop&view=order_detail&order_id=' . $this->detail[$i]->order_id . '&task=reorder&tmpl=component';
$order_number = "<div class='order_number'>" . $this->detail[$i]->order_number . "</div>";
$order_id = "<div class='order_id'>" . $this->detail[$i]->order_id . "</div>";
$order_products = "<div class='order_products'>" . implode(',<br/>', $order_item_name) . "</div>";
$order_total = "<div class='order_total'>" . $producthelper->getProductFormattedPrice($this->detail[$i]->order_total) . "</div>";
$order_date = "<div class='order_date'>" . $redconfig->convertDateFormat($this->detail[$i]->cdate) . "</div>";
$order_status = "<div class='order_status'>" . $statusname . "</div>";
$order_detail_link = "<div class='order_detail_link'><a href='" . $orderdetailurl . "'>" . JText::_('COM_REDSHOP_ORDER_DETAIL') . "</a></div>";
$reorder_link = "<div class='reorder_link'><a href='javascript:if(confirm(\"" . JText::_('COM_REDSHOP_CONFIRM_CART_EMPTY') . "\")){window.location=\"" . $reorderurl . "\";}'>" . JText::_('COM_REDSHOP_REORDER') . "</a></div>";
$cart_mdata .= $template_middle;
}
if ($arr_discount_type[0] == 'v') {
$discount_type .= JText::_('COM_REDSHOP_VOUCHER_CODE') . ' : ' . $arr_discount_type[1] . '<br>';
}
}
}
$search[] = "{discount_type_lbl}";
$replace[] = JText::_('COM_REDSHOP_CART_DISCOUNT_CODE_TBL');
if ($discount_type) {
$search[] = "{discount_type}";
$replace[] = $discount_type;
} else {
$search[] = "{discount_type}";
$replace[] = JText::_('COM_REDSHOP_NO_DISCOUNT_AVAILABLE');
}
$statustext = $order_functions->getOrderStatusTitle($OrdersDetail->order_status);
$issplit = $OrdersDetail->split_payment;
$split_amount = $OrdersDetail->order_total - $partialpayment;
$split_amounttext = "";
$payremaininglink = "";
if ($issplit && $split_amount > 0) {
$split_amounttext = "<br /><br />" . JText::_('COM_REDSHOP_RECEIPT_PARTIALLY_PAID_AMOUNT') . ": " . $producthelper->getProductFormattedPrice($split_amount);
$payremaininglink = "<br />" . JText::_('COM_REDSHOP_REMAINING_AMOUNT_TOBE_PAID_BEFORE_DEL') . ": " . $producthelper->getProductFormattedPrice($split_amount) . "<a href='" . JRoute::_('index.php?option=com_redshop&view=split_payment&oid=' . $oid . '&Itemid=' . $Itemid) . "'>" . JText::_('COM_REDSHOP_PAY_REMAINING') . "</a>";
}
$frm = '';
$reorder = '';
if ($OrdersDetail->order_status != 'C' && $OrdersDetail->order_status != 'S' && $OrdersDetail->order_status != 'PR' && $OrdersDetail->order_status != 'APP' && $print != 1 && $OrdersDetail->order_payment_status != 'Paid') {
$frm = "<form method='post'>\n\t<input type='hidden' name='order_id' value='{$oid}'>\n\t<input type='hidden' name='option' value='com_redshop'>\n\t<input type='hidden' name='view' value='order_detail'>\n\t<input type='hidden' name='task' value='payment'>\n\t<input type='submit' name='payment' value='" . JText::_("COM_REDSHOP_PAY") . "'>\n\t</form>";
} else {
$reorder = "<form method='post' name='frmreorder' id='frmreorder'>";
$reorder .= "<input type='submit' name='reorder' id='reorder' value='" . JText::_('COM_REDSHOP_REORDER') . "' onclick='return submitReorder();' />";
?>
"
title="<?php
echo JText::_('COM_REDSHOP_EDIT_ORDER');
?>
"><?php
echo $row->order_id;
?>
</a>
</td>
<td><?php
echo $config->convertDateFormat($row->mdate);
?>
</td>
<td align="center"><?php
echo $order_function->getOrderStatusTitle($row->order_status);
?>
</td>
<td align="center"><?php
echo $row->product_quantity;
?>
</td>
<td align="center"><?php
echo $row->fullname;
?>
</td>
</tr>
<?php
$k = 1 - $k;
}
?>
function display($tpl = null)
{
$config = new Redconfiguration();
$redTemplate = new Redtemplate();
$order_functions = new order_functions();
$model = $this->getModel();
$detail = $this->get('data');
$billing = $order_functions->getBillingAddress($detail->user_id);
$shipping = $order_functions->getOrderShippingUserInfo($detail->order_id);
if (!$shipping) {
$shipping = $billing;
}
$template = $redTemplate->getTemplate("shipping_pdf");
$html_template = $template[0]->template_desc;
ob_start();
$order_status = $order_functions->getOrderStatusTitle($detail->order_status);
$html_template = str_replace("{order_information_lbl}", JText::_('COM_REDSHOP_ORDER_INFORMATION'), $html_template);
$html_template = str_replace("{order_id_lbl}", JText::_('COM_REDSHOP_ORDER_ID'), $html_template);
$html_template = str_replace("{order_number_lbl}", JText::_('COM_REDSHOP_ORDER_NUMBER'), $html_template);
$html_template = str_replace("{order_date_lbl}", JText::_('COM_REDSHOP_ORDER_DATE'), $html_template);
$html_template = str_replace("{order_status_lbl}", JText::_('COM_REDSHOP_ORDER_STATUS'), $html_template);
$html_template = str_replace("{shipping_address_info_lbl}", JText::_('COM_REDSHOP_SHIPPING_ADDRESS_INFORMATION'), $html_template);
$html_template = str_replace("{shipping_firstname_lbl}", JText::_('COM_REDSHOP_FIRSTNAME'), $html_template);
$html_template = str_replace("{shipping_lastname_lbl}", JText::_('COM_REDSHOP_LASTNAME'), $html_template);
$html_template = str_replace("{shipping_address_lbl}", JText::_('COM_REDSHOP_ADDRESS'), $html_template);
$html_template = str_replace("{shipping_zip_lbl}", JText::_('COM_REDSHOP_ZIP'), $html_template);
$html_template = str_replace("{shipping_city_lbl}", JText::_('COM_REDSHOP_CITY'), $html_template);
$html_template = str_replace("{shipping_country_lbl}", JText::_('COM_REDSHOP_COUNTRY'), $html_template);
$html_template = str_replace("{shipping_state_lbl}", JText::_('COM_REDSHOP_STATE'), $html_template);
$html_template = str_replace("{shipping_phone_lbl}", JText::_('COM_REDSHOP_PHONE'), $html_template);
$html_template = str_replace("{order_id}", $detail->order_id, $html_template);
$html_template = str_replace("{order_number}", $detail->order_number, $html_template);
$html_template = str_replace("{order_date}", $config->convertDateFormat($detail->cdate), $html_template);
$html_template = str_replace("{order_status}", $order_status, $html_template);
$html_template = str_replace("{shipping_firstname}", $shipping->firstname, $html_template);
$html_template = str_replace("{shipping_lastname}", $shipping->lastname, $html_template);
$html_template = str_replace("{shipping_address}", $shipping->address, $html_template);
$html_template = str_replace("{shipping_zip}", $shipping->zipcode, $html_template);
$html_template = str_replace("{shipping_city}", $shipping->city, $html_template);
$html_template = str_replace("{shipping_country}", JTEXT::_($order_functions->getCountryName($shipping->country_code)), $html_template);
$html_template = str_replace("{shipping_state}", $order_functions->getStateName($shipping->state_code, $shipping->country_code), $html_template);
$html_template = str_replace("{shipping_phone}", $shipping->zipcode, $html_template);
// if user is company than
if ($billing->is_company && $billing->company_name != "") {
$html_template = str_replace("{company_name}", $billing->company_name, $html_template);
$html_template = str_replace("{company_name_lbl}", JText::_('COM_REDSHOP_COMPANY_NAME'), $html_template);
} else {
$html_template = str_replace("{company_name}", "", $html_template);
$html_template = str_replace("{company_name_lbl}", "", $html_template);
}
$pdfObj = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, 'A5', true, 'UTF-8', false);
$pdfObj->SetTitle("Order :" . $detail->order_id);
$pdfObj->SetAuthor('redSHOP');
$pdfObj->SetCreator('redSHOP');
$pdfObj->SetMargins(15, 15, 15);
$font = 'times';
$pdfObj->SetHeaderData('', '', '', "Order " . $detail->order_id);
$pdfObj->setHeaderFont(array($font, '', 10));
//$pdfObj->setFooterFont(array($font, '', 8));
$pdfObj->SetFont($font, "", 12);
//$pdfObj->AliasNbPages();
$pdfObj->AddPage();
$pdfObj->WriteHTML($html_template);
$pdfObj->Output("Order_" . $detail->order_id . ".pdf", "D");
exit;
}
public function export_data()
{
/**
* new order export for paid customer support
*/
$extrafile = JPATH_SITE . '/administrator/components/com_redshop/extras/order_export.php';
if (file_exists($extrafile)) {
require_once JPATH_COMPONENT_ADMINISTRATOR . '/extras/order_export.php';
$orderExport = new orderExport();
$orderExport->createOrderExport();
exit;
}
$producthelper = new producthelper();
$order_function = new order_functions();
$model = $this->getModel('order');
$product_count = array();
$db = JFactory::getDbo();
$cid = JRequest::getVar('cid', array(0), 'method', 'array');
$data = $model->export_data($cid);
$order_id = implode(',', $cid);
$where = "";
if ($order_id != 0) {
$where .= " where order_id IN (" . $order_id . ") ";
}
$sql = "SELECT order_id,count(order_item_id) as noproduct FROM `#__redshop_order_item` " . $where . " GROUP BY order_id";
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-type: text/x-csv");
header("Content-type: text/csv");
header("Content-type: application/csv");
header('Content-Disposition: attachment; filename=Order.csv');
$db->setQuery($sql);
$no_products = $db->loadObjectList();
for ($i = 0; $i < count($data); $i++) {
$product_count[] = $no_products[$i]->noproduct;
}
$no_products = max($product_count);
echo "Order id,Buyer name,Email Id, PhoneNumber,Billing Address ,Billing City,Billing State,Billing Country,BillingPostcode,\n\t\tShipping Address,Shipping City,Shipping State,Shipping Country,ShippingPostCode,Order Status,Order Date,";
for ($i = 1; $i <= $no_products; $i++) {
echo JText::_('PRODUCT_NAME') . $i . ',';
echo JText::_('PRODUCT') . ' ' . JText::_('PRODUCT_PRICE') . $i . ',';
echo JText::_('PRODUCT_ATTRIBUTE') . $i . ',';
}
echo "Shipping Cost,Order Total\n";
for ($i = 0; $i < count($data); $i++) {
$shipping_address = $order_function->getOrderShippingUserInfo($data[$i]->order_id);
echo $data[$i]->order_id . ",";
echo $data[$i]->firstname . " " . $data[$i]->lastname . ",";
echo $data[$i]->user_email . ",";
echo $data[$i]->phone . ",";
$user_address = str_replace(",", "<br/>", $data[$i]->address);
$user_address = strip_tags($user_address);
$user_shipping_address = str_replace(",", "<br/>", $shipping_address->address);
$user_shipping_address = strip_tags($user_shipping_address);
echo trim($user_address) . ",";
echo $data[$i]->city . ",";
echo $data[$i]->state_code . ",";
echo $data[$i]->country_code . ",";
echo $data[$i]->zipcode . ",";
echo trim($user_shipping_address) . ",";
echo $shipping_address->city . ",";
echo $shipping_address->state_code . ",";
echo $shipping_address->country_code . ",";
echo $shipping_address->zipcode . ",";
echo $order_function->getOrderStatusTitle($data[$i]->order_status) . ",";
echo date('d-m-Y H:i', $data[$i]->cdate) . ",";
$no_items = $order_function->getOrderItemDetail($data[$i]->order_id);
for ($it = 0; $it < count($no_items); $it++) {
echo $no_items[$it]->order_item_name . ",";
echo REDCURRENCY_SYMBOL . $no_items[$it]->product_final_price . ",";
$product_attribute = $producthelper->makeAttributeOrder($no_items[$it]->order_item_id, 0, $no_items[$it]->product_id, 0, 1);
$product_attribute = strip_tags($product_attribute->product_attribute);
echo trim($product_attribute) . ",";
}
$temp = $no_products - count($no_items);
echo str_repeat(',', $temp * 3);
if ($data[$i]->order_shipping != "") {
$shippingcost = $data[$i]->order_shipping;
} else {
$shippingcost = 0;
}
echo REDCURRENCY_SYMBOL . $shippingcost . ",";
echo REDCURRENCY_SYMBOL . $data[$i]->order_total . "\n";
}
exit;
}
public function createMultiprintInvoicePdf($oid)
{
require_once JPATH_SITE . '/components/com_redshop/helpers/tcpdf/config/lang/eng.php';
require_once JPATH_SITE . '/components/com_redshop/helpers/tcpdf/tcpdf.php';
$order_functions = new order_functions();
$shippinghelper = new shipping();
$carthelper = new rsCarthelper();
$extra_field = new extra_field();
$redconfig = new Redconfiguration();
$redTemplate = new Redtemplate();
$producthelper = new producthelper();
$message = "";
$pdfObj = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, 'A5', true, 'UTF-8', false);
$pdfObj->SetTitle('Shipped');
$pdfObj->SetAuthor('redSHOP');
$pdfObj->SetCreator('redSHOP');
$pdfObj->SetMargins(8, 8, 8);
// Changed font to support Unicode Characters - Specially Polish Characters
$font = 'freeserif';
$pdfObj->setImageScale(PDF_IMAGE_SCALE_RATIO);
$pdfObj->setHeaderFont(array($font, '', 8));
// Set font
$pdfObj->SetFont($font, "", 6);
$order_id = "";
for ($o = 0; $o < count($oid); $o++) {
$body = "";
$message = "";
$order_id = $oid[$o];
$OrderProducts = $order_functions->getOrderItemDetail($order_id);
$OrdersDetail = $order_functions->getmultiOrderDetails($order_id);
$billing = $order_functions->getOrderBillingUserInfo($OrdersDetail[0]->order_id);
$shipping = $order_functions->getOrderShippingUserInfo($OrdersDetail[0]->order_id);
$is_company = $billing->is_company;
if (!$shipping) {
$shipping = $billing;
}
$paymentmethod = $order_functions->getOrderPaymentDetail($order_id);
$paymentmethod = $paymentmethod[0];
$order_print_template = $redTemplate->getTemplate("order_print");
if (count($order_print_template) > 0 && $order_print_template[0]->template_desc != "") {
$ordersprint_template = $order_print_template[0]->template_desc;
} else {
$ordersprint_template = '<table style="width: 100%;" border="0" cellpadding="5" cellspacing="0">
<tbody><tr><td colspan="2"><table style="width: 100%;" border="0" cellpadding="2" cellspacing="0"><tbody>
<tr style="background-color: #cccccc;"><th align="left">{order_information_lbl}{print}</th></tr><tr></tr
><tr><td>{order_id_lbl} : {order_id}</td></tr><tr><td>{order_number_lbl} : {order_number}</td></tr><tr>
<td>{order_date_lbl} : {order_date}</td></tr><tr><td>{order_status_lbl} : {order_status}</td></tr><tr>
<td>{shipping_method_lbl} : {shipping_method} : {shipping_rate_name}</td></tr><tr><td>{payment_lbl} : {payment_method}</td>
</tr></tbody></table></td></tr><tr><td colspan="2"><table style="width: 100%;" border="0" cellpadding="2" cellspacing="0">
<tbody><tr style="background-color: #cccccc;"><th align="left">{billing_address_information_lbl}</th>
</tr><tr></tr><tr><td>{billing_address}</td></tr></tbody></table></td></tr><tr><td colspan="2">
<table style="width: 100%;" border="0" cellpadding="2" cellspacing="0"><tbody><tr style="background-color: #cccccc;">
<th align="left">{shipping_address_info_lbl}</th></tr><tr></tr><tr><td>{shipping_address}</td></tr></tbody>
</table></td></tr><tr><td colspan="2"><table style="width: 100%;" border="0" cellpadding="2" cellspacing="0">
<tbody><tr style="background-color: #cccccc;"><th align="left">{order_detail_lbl}</th></tr><tr></tr><tr><td>
<table style="width: 100%;" border="0" cellpadding="2" cellspacing="2"><tbody><tr><td>{product_name_lbl}</td><td>{note_lbl}</td>
<td>{price_lbl}</td><td>{quantity_lbl}</td><td align="right">Total Price</td></tr>{product_loop_start}<tr>
<td><p>{product_name}<br />{product_attribute}{product_accessory}{product_userfields}</p></td>
<td>{product_wrapper}{product_thumb_image}</td><td>{product_price}</td><td>{product_quantity}</td>
<td align="right">{product_total_price}</td></tr>{product_loop_end}</tbody></table></td></tr><tr>
<td></td></tr><tr><td><table style="width: 100%;" border="0" cellpadding="2" cellspacing="2"><tbody>
<tr align="left"><td align="left"><strong>{order_subtotal_lbl} : </strong></td><td align="right">{order_subtotal}</td>
</tr>{if vat}<tr align="left"><td align="left"><strong>{vat_lbl} : </strong></td><td align="right">{order_tax}</td>
</tr>{vat end if}{if discount}<tr align="left"><td align="left"><strong>{discount_lbl} : </strong></td>
<td align="right">{order_discount}</td></tr>{discount end if}<tr align="left"><td align="left">
<strong>{shipping_lbl} : </strong></td><td align="right">{order_shipping}</td></tr><tr align="left">
<td colspan="2" align="left"><hr /></td></tr><tr align="left"><td align="left"><strong>{total_lbl} :</strong>
</td><td align="right">{order_total}</td></tr><tr align="left"><td colspan="2" align="left"><hr /><br />
<hr /></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table>';
}
$print_tag = "<a onclick='window.print();' title='" . JText::_('COM_REDSHOP_PRINT') . "'>" . "<img src=" . JSYSTEM_IMAGES_PATH . "printButton.png alt='" . JText::_('COM_REDSHOP_PRINT') . "' title='" . JText::_('COM_REDSHOP_PRINT') . "' /></a>";
$search[] = "{print}";
$replace[] = $print_tag;
$search[] = "{order_id}";
$replace[] = $OrdersDetail[0]->order_id;
$search[] = "{order_number}";
$replace[] = $OrdersDetail[0]->order_number;
$search[] = "{order_date}";
$replace[] = $redconfig->convertDateFormat($OrdersDetail[0]->cdate);
$search[] = "{customer_note}";
$replace[] = $OrdersDetail[0]->customer_note;
// Set order paymethod name
$search[] = "{payment_lbl}";
$replace[] = JText::_('COM_REDSHOP_ORDER_PAYMENT_METHOD');
$search[] = "{payment_method}";
$replace[] = $paymentmethod->order_payment_name;
$statustext = $order_functions->getOrderStatusTitle($OrdersDetail[0]->order_status);
$issplit = $OrdersDetail[0]->split_payment;
$search[] = "{order_status}";
if (trim($OrdersDetail[0]->order_payment_status) == 'Paid') {
$orderPaymentStatus = JText::_('COM_REDSHOP_PAYMENT_STA_PAID');
} elseif (trim($OrdersDetail[0]->order_payment_status) == 'Unpaid') {
$orderPaymentStatus = JText::_('COM_REDSHOP_PAYMENT_STA_UNPAID');
} elseif (trim($OrdersDetail[0]->order_payment_status) == 'Partial Paid') {
$orderPaymentStatus = JText::_('COM_REDSHOP_PAYMENT_STA_PARTIAL_PAID');
} else {
$orderPaymentStatus = $OrdersDetail[0]->order_payment_status;
}
$replace[] = $statustext . " - " . $orderPaymentStatus;
$search[] = "{order_status_order_only}";
$replace[] = $statustext;
$search[] = "{order_status_payment_only}";
$replace[] = $orderPaymentStatus;
$search[] = "{customer_note_lbl}";
$replace[] = JText::_('COM_REDSHOP_COMMENT');
$search[] = "{customer_note}";
$replace[] = $OrdersDetail->customer_note;
$search[] = "{shipping_method_lbl}";
$replace[] = JText::_('COM_REDSHOP_SHIPPING_METHOD_LBL');
$shipping_method = '';
$shipping_rate_name = '';
if ($OrdersDetail[0]->ship_method_id != '') {
$ship_method = explode("|", $shippinghelper->decryptShipping(str_replace(" ", "+", $OrdersDetail[0]->ship_method_id)));
if (count($ship_method) <= 1) {
$ship_method = explode("|", $OrdersDetail[0]->ship_method_id);
}
$shipping_method = "";
$shipping_rate_name = "";
if (count($ship_method) > 0) {
if (array_key_exists(1, $ship_method)) {
$shipping_method = $ship_method[1];
}
if (array_key_exists(2, $ship_method)) {
$shipping_rate_name = $ship_method[2];
}
}
}
$search[] = "{shipping_method}";
$replace[] = $shipping_method;
$search[] = "{shipping}";
$replace[] = $producthelper->getProductFormattedPrice($OrdersDetail[0]->order_shipping);
$search[] = "{shipping_rate_name}";
$replace[] = $shipping_rate_name;
$ordersprint_template = $carthelper->replaceBillingAddress($ordersprint_template, $billing);
$ordersprint_template = $carthelper->replaceShippingAddress($ordersprint_template, $shipping);
$product_name = "";
$product_note = "";
$product_price = "";
$product_quantity = "";
$product_total_price = "";
$template_start = "";
$template_middle = "";
$template_end = "";
if (strstr($ordersprint_template, "{product_loop_start}")) {
$template_sdata = explode('{product_loop_start}', $ordersprint_template);
$template_start = $template_sdata[0];
$template_edata = explode('{product_loop_end}', $template_sdata[1]);
$template_end = $template_edata[1];
$template_middle = $template_edata[0];
}
$cart_tr = '';
for ($i = 0; $i < count($OrderProducts); $i++) {
$wrapper_name = "";
if ($OrderProducts[$i]->wrapper_id) {
$wrapper = $producthelper->getWrapper($OrderProducts[$i]->product_id, $OrderProducts[$i]->wrapper_id);
if (count($wrapper) > 0) {
$wrapper_name = JText::_('COM_REDSHOP_WRAPPER') . ":<br/>" . $wrapper[0]->wrapper_name . "(" . $producthelper->getProductFormattedPrice($OrderProducts[$i]->wrapper_price) . ")";
}
}
if ($OrderProducts[$i]->is_giftcard == 1) {
$product_userfields = $producthelper->getuserfield($OrderProducts[$i]->order_item_id, 13);
} else {
$product_userfields = $producthelper->getuserfield($OrderProducts[$i]->order_item_id);
}
$product_name = "<div class='product_name'>" . $OrderProducts[$i]->order_item_name . "</div>";
$product = $producthelper->getProductById($OrderProducts[$i]->product_id);
$product_number = $OrderProducts[$i]->order_item_sku;
$product_note = "<div class='product_note'>" . $wrapper_name . "</div>";
$product_total_price = "<div class='product_total_price'>" . $producthelper->getProductFormattedPrice($OrderProducts[$i]->product_final_price) . "</div>";
$product_price = "<div class='product_price'>" . $producthelper->getProductFormattedPrice($OrderProducts[$i]->product_item_price) . "</div>";
$product_quantity = '<div class="product_quantity">' . $OrderProducts[$i]->product_quantity . '</div>';
$cart_mdata = '';
$uri = JURI::getInstance();
$url = $uri->root();
if ($product->product_full_image) {
if (is_file(REDSHOP_FRONT_IMAGES_RELPATH . "product/" . $product->product_full_image)) {
$product_image_path = $product->product_full_image;
} else {
if (is_file(REDSHOP_FRONT_IMAGES_RELPATH . "product/" . PRODUCT_DEFAULT_IMAGE)) {
$product_image_path = PRODUCT_DEFAULT_IMAGE;
} else {
$product_image_path = "";
}
}
} else {
if (is_file(REDSHOP_FRONT_IMAGES_RELPATH . "product/" . PRODUCT_DEFAULT_IMAGE)) {
$product_image_path = PRODUCT_DEFAULT_IMAGE;
} else {
$product_image_path = "";
}
}
if ($product_image_path) {
$thumbUrl = RedShopHelperImages::getImagePath($product_image_path, '', 'thumb', 'product', CART_THUMB_WIDTH, CART_THUMB_HEIGHT, USE_IMAGE_SIZE_SWAPPING);
$product_image = '<div class="product_image"><img src="' . $thumbUrl . '"></div>';
} else {
$product_image = "<div class='product_image'></div>";
}
$cart_mdata = str_replace("{product_name}", $product_name, $template_middle);
$cart_mdata = str_replace("{product_thumb_image}", $product_image, $cart_mdata);
$cart_mdata = str_replace("{product_attribute}", $OrderProducts[$i]->product_attribute, $cart_mdata);
$cart_mdata = str_replace("{product_accessory}", $OrderProducts[$i]->product_accessory, $cart_mdata);
$cart_mdata = str_replace("{product_wrapper}", '', $cart_mdata);
$cart_mdata = str_replace("{product_number}", $product_number, $cart_mdata);
$cart_mdata = str_replace("{product_number_lbl}", JText::_('COM_REDSHOP_PRODUCT_NUMBER'), $cart_mdata);
$user_subscribe_detail = $producthelper->getUserProductSubscriptionDetail($OrderProducts[$i]->order_item_id);
if (count($user_subscribe_detail) > 0 && $user_subscribe_detail->subscription_id) {
$subscription_detail = $producthelper->getProductSubscriptionDetail($OrderProducts[$i]->product_id, $user_subscribe_detail->subscription_id);
$selected_subscription = $subscription_detail->subscription_period . " " . $subscription_detail->period_type;
$cart_mdata = str_replace("{product_subscription_lbl}", JText::_('COM_REDSHOP_SUBSCRIPTION'), $cart_mdata);
$cart_mdata = str_replace("{product_subscription}", $selected_subscription, $cart_mdata);
} else {
$cart_mdata = str_replace("{product_subscription_lbl}", "", $cart_mdata);
$cart_mdata = str_replace("{product_subscription}", "", $cart_mdata);
}
$cart_mdata = str_replace("{product_userfields}", $product_userfields, $cart_mdata);
$cart_mdata = str_replace("{product_wrapper}", $product_note, $cart_mdata);
$cart_mdata = str_replace("{product_price}", $product_price, $cart_mdata);
$cart_mdata = str_replace("{product_quantity}", $product_quantity, $cart_mdata);
$cart_mdata = str_replace("{product_total_price}", $product_total_price, $cart_mdata);
$cart_tr .= $cart_mdata;
}
$ordersprint_template = $template_start . $cart_tr . $template_end;
$search[] = "{order_subtotal}";
$replace[] = $producthelper->getProductFormattedPrice($OrdersDetail[0]->order_subtotal);
if ($OrdersDetail[0]->order_tax <= 0) {
$template_vat_sdata = explode('{if vat}', $ordersprint_template);
$template_vat_start = $template_vat_sdata[0];
$template_vat_edata = explode('{vat end if}', $template_vat_sdata[1]);
$template_vat_end = $template_vat_edata[1];
$template_vat_middle = $template_vat_edata[0];
$ordersprint_template = $template_vat_start . $template_vat_end;
} else {
$search[] = "{if vat}";
$replace[] = '';
$search[] = "{order_tax}";
$replace[] = $producthelper->getProductFormattedPrice($OrdersDetail[0]->order_tax);
$search[] = "{tax}";
$replace[] = $producthelper->getProductFormattedPrice($OrdersDetail[0]->order_tax);
$search[] = "{vat_lbl}";
$replace[] = JText::_('COM_REDSHOP_ORDER_TAX');
$search[] = "{vat end if}";
$replace[] = '';
}
if ($OrdersDetail[0]->payment_discount <= 0) {
if (strstr($ordersprint_template, "{if payment_discount}")) {
$template_pd_sdata = explode('{if payment_discount}', $ordersprint_template);
$template_pd_start = $template_pd_sdata[0];
$template_pd_edata = explode('{payment_discount end if}', $template_pd_sdata[1]);
$template_pd_end = $template_pd_edata[1];
$template_pd_middle = $template_pd_edata[0];
$ordersprint_template = $template_pd_start . $template_pd_end;
}
} else {
$OrdersDetail->order_discount = $OrdersDetail[0]->order_discount - $OrdersDetail[0]->payment_discount;
$search[] = "{if payment_discount}";
$replace[] = '';
$search[] = "{payment_order_discount}";
$replace[] = $producthelper->getProductFormattedPrice($OrdersDetail[0]->payment_discount);
$search[] = "{payment_discount_lbl}";
$replace[] = JText::_('COM_REDSHOP_PAYMENT_DISCOUNT_LBL');
$search[] = "{payment_discount end if}";
$replace[] = '';
}
if ($OrdersDetail->order_discount <= 0) {
if (strstr($ordersprint_template, "{if discount}")) {
$template_discount_sdata = explode('{if discount}', $ordersprint_template);
$template_discount_start = $template_discount_sdata[0];
$template_discount_edata = explode('{discount end if}', $template_discount_sdata[1]);
$template_discount_end = $template_discount_edata[1];
$template_discount_middle = $template_discount_edata[0];
$ordersprint_template = $template_discount_start . $template_discount_end;
}
} else {
$search[] = "{if discount}";
$replace[] = '';
$search[] = "{order_discount}";
$replace[] = $producthelper->getProductFormattedPrice($OrdersDetail[0]->order_discount);
$search[] = "{discount_lbl}";
$replace[] = JText::_('COM_REDSHOP_ORDER_DISCOUNT');
$search[] = "{discount end if}";
$replace[] = '';
}
$search[] = "{order_id_lbl}";
$replace[] = JText::_('COM_REDSHOP_ORDER_ID');
$search[] = "{order_number_lbl}";
$replace[] = JText::_('COM_REDSHOP_ORDER_NUMBER');
$search[] = "{order_date_lbl}";
$replace[] = JText::_('COM_REDSHOP_ORDER_DATE');
$search[] = "{order_status_lbl}";
$replace[] = JText::_('COM_REDSHOP_ORDER_STATUS');
$search[] = "{shipping_lbl}";
$replace[] = JText::_('COM_REDSHOP_ORDER_SHIPPING');
$search[] = "{order_information_lbl}";
$replace[] = JText::_('COM_REDSHOP_ORDER_INFORMATION');
$search[] = "{billing_address_information_lbl}";
$replace[] = JText::_('COM_REDSHOP_BILLING_ADDRESS_INFORMATION');
$search[] = "{shipping_address_info_lbl}";
$replace[] = JText::_('COM_REDSHOP_SHIPPING_ADDRESS_INFORMATION');
$search[] = "{order_detail_lbl}";
$replace[] = JText::_('COM_REDSHOP_ORDER_DETAILS');
$search[] = "{product_name_lbl}";
$replace[] = JText::_('COM_REDSHOP_PRODUCT_NAME');
$search[] = "{note_lbl}";
$replace[] = JText::_('COM_REDSHOP_NOTE');
$search[] = "{price_lbl}";
$replace[] = JText::_('COM_REDSHOP_PRICE');
$search[] = "{quantity_lbl}";
$replace[] = JText::_('COM_REDSHOP_QUANTITY');
$search[] = "{total_price_lbl}";
$replace[] = JText::_('COM_REDSHOP_TOTAL_PRICE');
$search[] = "{order_subtotal_lbl}";
$replace[] = JText::_('COM_REDSHOP_ORDER_SUBTOTAL');
$search[] = "{product_number_lbl}";
$replace[] = JText::_('COM_REDSHOP_PRODUCT_NUMBER');
$search[] = "{total_lbl}";
$replace[] = JText::_('COM_REDSHOP_ORDER_TOTAL');
$search[] = "{order_shipping}";
$replace[] = $producthelper->getProductFormattedPrice($OrdersDetail[0]->order_shipping);
$search[] = "{shipping}";
$replace[] = $producthelper->getProductFormattedPrice($OrdersDetail[0]->order_shipping);
$search[] = "{order_total}";
$replace[] = $producthelper->getProductFormattedPrice($OrdersDetail[0]->order_total);
$message = str_replace($search, $replace, $ordersprint_template);
$search = "";
$replace = "";
$body = $message;
$pdfObj->AddPage();
$pdfObj->WriteHTML($body, true, false, true, false, '');
}
$invoice_pdfName = "multiprintorder";
$pdfObj->Output(JPATH_SITE . '/components/com_redshop/assets/document/invoice/' . $invoice_pdfName . ".pdf", "F");
return $invoice_pdfName;
}
<th><?php
echo JText::_('COM_REDSHOP_ORDER_STATUS');
?>
</th>
<th><?php
echo JText::_('COM_REDSHOP_ORDER_DETAIL');
?>
</th>
</tr>
<?php
$order_item_name = array();
for ($j = 0; $j < count($OrderProducts); $j++) {
$order_item_name[$j] = $OrderProducts[$j]->order_item_name;
}
$itemlist = implode(',<br/>', $order_item_name);
$statusname = $order_functions->getOrderStatusTitle($order_detail->order_status);
$orderdetailurl = JRoute::_('index.php?option=com_redshop&view=order_detail&oid=' . $order_id);
?>
<tr class="rblOrderDetailItem">
<td><?php
echo $order_id;
?>
</td>
<td><?php
echo $order_detail->order_number;
?>
</td>
<td><?php
echo $itemlist;
?>
</td>
