/**
* Get Billing Addresses
*
* @return array
*/
public function billingaddresses()
{
$app = JFactory::getApplication();
$order_functions = new order_functions();
$user = JFactory::getUser();
$session = JFactory::getSession();
$auth = $session->get('auth');
$list = array();
if ($user->id) {
$list = $order_functions->getBillingAddress($user->id);
} elseif ($auth['users_info_id']) {
$uid = -$auth['users_info_id'];
$list = $order_functions->getBillingAddress($uid);
}
return $list;
}
public function getuseraccountinfo($uid)
{
$order_functions = new order_functions();
$user = JFactory::getUser();
$session = JFactory::getSession();
$auth = $session->get('auth');
$list = array();
if ($user->id) {
$list = $order_functions->getBillingAddress($user->id);
} elseif ($auth['users_info_id']) {
$uid = -$auth['users_info_id'];
$list = $order_functions->getBillingAddress($uid);
}
if (!empty($list)) {
$list->email = $list->user_email;
}
return $list;
}
public function display($tpl = null)
{
$option = JRequest::getVar('option');
$extra_field = new extra_field();
$order_functions = new order_functions();
$document = JFactory::getDocument();
$document->setTitle(JText::_('COM_REDSHOP_QUOTATION_MANAGEMENT'));
$document->addScript('components/' . $option . '/assets/js/json.js');
$document->addScript('components/' . $option . '/assets/js/validation.js');
$document->addScript('components/' . $option . '/assets/js/order.js');
$document->addScript('components/' . $option . '/assets/js/common.js');
$document->addScript('components/' . $option . '/assets/js/select_sort.js');
$document->addStyleSheet('components/' . $option . '/assets/css/search.css');
$document->addScript('components/' . $option . '/assets/js/search.js');
$session = JFactory::getSession();
$uri = JFactory::getURI();
$lists = array();
$model = $this->getModel();
$detail = $this->get('Data');
$Redconfiguration = new Redconfiguration();
$user_id = JRequest::getVar('user_id', 0);
if ($user_id != 0) {
$billing = $order_functions->getBillingAddress($user_id);
} else {
$billing = $model->setBilling();
}
if (!is_object($detail)) {
$detail = new stdClass();
}
$detail->user_id = $user_id;
$session->set('offlineuser_id', $user_id);
$userop = array();
$userop[0] = new stdClass();
$userop[0]->user_id = 0;
$userop[0]->text = JText::_('COM_REDSHOP_SELECT');
$userlists = $model->getUserData(0, "BT");
$userlist = array_merge($userop, $userlists);
$lists['userlist'] = JHTML::_('select.genericlist', $userlist, 'user_id', 'class="inputbox" onchange="showquotationUserDetail();" ', 'user_id', 'text');
JToolBarHelper::title(JText::_('COM_REDSHOP_QUOTATION_MANAGEMENT') . ': <small><small>[ ' . JText::_('COM_REDSHOP_NEW') . ' ]</small></small>', 'redshop_order48');
JToolBarHelper::save();
JToolBarHelper::custom('send', 'send.png', 'send.png', JText::_('COM_REDSHOP_SEND'), false);
JToolBarHelper::cancel();
// PRODUCT/ATTRIBUTE STOCK ROOM QUANTITY CHECKING IS IMPLEMENTED
$countryarray = $Redconfiguration->getCountryList((array) $billing);
$billing->country_code = $countryarray['country_code'];
$lists['country_code'] = $countryarray['country_dropdown'];
$statearray = $Redconfiguration->getStateList((array) $billing);
$lists['state_code'] = $statearray['state_dropdown'];
$lists['quotation_extrafield'] = $extra_field->list_all_field(16, $billing->users_info_id);
$this->lists = $lists;
$this->detail = $detail;
$this->billing = $billing;
$this->userlist = $userlists;
$this->request_url = $uri->toString();
parent::display($tpl);
}
public function _loadData()
{
$order_functions = new order_functions();
$user = JFactory::getUser();
if ($user->id) {
$this->_data = $order_functions->getBillingAddress($user->id);
$this->_data->user_info_id = $this->_data->users_info_id;
return true;
}
return false;
}
/**
* Method to edit billing Address
*
* @return boolean True if the ID is in the edit list.
*/
public function edit()
{
$user = JFactory::getUser();
$order_functions = new order_functions();
$billingaddresses = $order_functions->getBillingAddress($user->id);
$GLOBALS['billingaddresses'] = $billingaddresses;
$task = JRequest::getVar('submit', 'post');
if ($task == 'Cancel') {
$this->registerTask('save', 'cancel');
}
parent::display();
}
public function _initData()
{
if (empty($GLOBALS['billingaddresses'])) {
$session = JFactory::getSession();
$auth = $session->get('auth');
if (isset($auth['users_info_id']) && $auth['users_info_id']) {
$order_functions = new order_functions();
$detail = $order_functions->getBillingAddress(-$auth['users_info_id']);
if (!isset($detail->user_id)) {
$detail->user_id = -$auth['users_info_id'];
}
} else {
// Toggler settings
$is_company = DEFAULT_CUSTOMER_REGISTER_TYPE == 2 ? 1 : 0;
// Allow registration type settings
if (ALLOW_CUSTOMER_REGISTER_TYPE == 1) {
$is_company = 0;
} elseif (ALLOW_CUSTOMER_REGISTER_TYPE == 2) {
$is_company = 1;
}
$user = JFactory::getUser();
$detail = new stdClass();
$detail->users_info_id = 0;
$detail->user_id = $user->id;
$detail->id = $user->id;
$detail->name = $user->name;
$detail->username = $user->username;
$detail->email = $user->email;
$detail->user_email = $user->email;
$detail->password = null;
$detail->is_company = $is_company;
$detail->firstname = null;
$detail->lastname = null;
$detail->address_type = 'BT';
$detail->company_name = null;
$detail->vat_number = null;
$detail->tax_exempt = 0;
$detail->country_code = null;
$detail->state_code = null;
$detail->shopper_group_id = null;
$detail->published = 1;
$detail->address = null;
$detail->city = null;
$detail->zipcode = null;
$detail->phone = null;
$detail->requesting_tax_exempt = 0;
$detail->tax_exempt_approved = 0;
$detail->approved = 1;
}
return $detail;
}
}
public function display($tpl = null)
{
$app = JFactory::getApplication();
$order_functions = new order_functions();
// Extra_field;
$extra_field = new extraField();
$task = JRequest::getCmd('task');
$user = JFactory::getUser();
$uri = JFactory::getURI();
// Preform security checks
$session = JFactory::getSession();
$auth = $session->get('auth');
$params = $app->getParams('com_redshop');
$lists = array();
if ($user->id) {
$billingaddresses = $order_functions->getBillingAddress($user->id);
} elseif (isset($auth['users_info_id']) && $auth['users_info_id']) {
$model = $this->getModel('account_shipto');
$billingaddresses = $model->_loadData($auth['users_info_id']);
} else {
$app->Redirect('index.php?option=com_redshop&view=login&Itemid=' . JRequest::getInt('Itemid'));
exit;
}
if ($task == 'addshipping') {
JHTML::Script('jquery-1.4.2.min.js', 'components/com_redshop/assets/js/', false);
JHTML::Script('jquery.validate.js', 'components/com_redshop/assets/js/', false);
JHTML::Script('common.js', 'components/com_redshop/assets/js/', false);
JHTML::Script('registration.js', 'components/com_redshop/assets/js/', false);
JHTML::Stylesheet('validation.css', 'components/com_redshop/assets/css/');
$shippingaddresses = $this->get('Data');
if ($shippingaddresses->users_info_id > 0 && $shippingaddresses->user_id != $billingaddresses->user_id) {
echo JText::_('COM_REDSHOP_ALERTNOTAUTH');
return;
}
$lists['shipping_customer_field'] = $extra_field->list_all_field(14, $shippingaddresses->users_info_id);
$lists['shipping_company_field'] = $extra_field->list_all_field(15, $shippingaddresses->users_info_id);
$this->setLayout('form');
} else {
$shippingaddresses = $order_functions->getShippingAddress($user->id);
}
$this->lists = $lists;
$this->shippingaddresses = $shippingaddresses;
$this->billingaddresses = $billingaddresses;
$this->request_url = $uri->toString();
$this->params = $params;
parent::display($tpl);
}
$order = $order_functions->getOrderDetails($order_id);
$orderitem = $order_functions->getOrderItemDetail($order_id);
if ($order->order_total > 0 && !USE_AS_CATALOG) {
$paymentmethod = $order_functions->getOrderPaymentDetail($order_id);
$paymentmethod = $order_functions->getPaymentMethodInfo($paymentmethod[0]->payment_method_class);
$paymentmethod = $paymentmethod[0];
$paymentpath = JPATH_SITE . '/plugins/redshop_payment/' . $paymentmethod->element . '/' . $paymentmethod->element . '.xml';
$paymentparams = new JRegistry($paymentmethod->params);
echo '<div>';
$is_creditcard = $paymentparams->get('is_creditcard', '');
$is_redirected = $paymentparams->get('is_redirected', 0);
if (!$is_creditcard || $is_redirected == 1) {
$adminpath = JPATH_ADMINISTRATOR . '/components/com_redshop';
$invalid_elements = $paymentparams->get('invalid_elements', '');
// Send the order_id and orderpayment_id to the payment plugin so it knows which DB record to update upon successful payment
$billingaddresses = $order_functions->getBillingAddress($order->user_id);
if (isset($billingaddresses)) {
if (isset($billingaddresses->country_code)) {
$billingaddresses->country_2_code = $configobj->getCountryCode2($billingaddresses->country_code);
}
if (isset($billingaddresses->state_code)) {
$billingaddresses->state_2_code = $billingaddresses->state_code;
}
}
$shippingaddresses = $order_functions->getOrderShippingUserInfo($order->order_id);
if (isset($shippingaddresses)) {
if (isset($shippingaddresses->country_code)) {
$shippingaddresses->country_2_code = $configobj->getCountryCode2($shippingaddresses->country_code);
}
if (isset($shippingaddresses->state_code)) {
$shippingaddresses->state_2_code = $shippingaddresses->state_code;
public function store($postdata)
{
$redshopMail = new redshopMail();
$order_functions = new order_functions();
$helper = new redhelper();
$producthelper = new producthelper();
$rsCarthelper = new rsCarthelper();
$shippinghelper = new shipping();
$adminproducthelper = new adminproducthelper();
$stockroomhelper = new rsstockroomhelper();
// For barcode generation
$barcode_code = $order_functions->barcode_randon_number(12, 0);
$postdata['barcode'] = $barcode_code;
$row = $this->getTable('order_detail');
if (!$row->bind($postdata)) {
$this->setError($this->_db->getErrorMsg());
return false;
}
if (!$row->store()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
$iscrm = $helper->isredCRM();
if ($iscrm) {
$postdata['order_id'] = $row->order_id;
$postdata['debitor_id'] = $postdata['user_info_id'];
JTable::addIncludePath(REDCRM_ADMIN . '/tables');
$crmorder =& $this->getTable('crm_order');
if (!$crmorder->bind($postdata)) {
$this->setError($this->_db->getErrorMsg());
return false;
}
if (!$crmorder->store()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
// Update rma table entry
if (ENABLE_RMA && isset($postdata['rmanotes'])) {
$rmaInfo = $this->getTable('rma_orders');
$rmaInfo->rma_number = $postdata['rma_number'];
$rmaInfo->original_order_id = $postdata['main_order_id'];
$rmaInfo->credit_note_order_id = $row->order_id;
$rmaInfo->rma_note = $postdata['rmanotes'];
$rmaInfo->store();
}
JTable::addIncludePath(REDSHOP_ADMIN . '/tables');
}
$order_shipping = explode("|", $shippinghelper->decryptShipping(str_replace(" ", "+", $row->ship_method_id)));
$rowOrderStatus =& $this->getTable('order_status_log');
$rowOrderStatus->order_id = $row->order_id;
$rowOrderStatus->order_status = $row->order_status;
$rowOrderStatus->date_changed = time();
$rowOrderStatus->customer_note = $row->customer_note;
$rowOrderStatus->store();
$billingaddresses = $order_functions->getBillingAddress($row->user_id);
if (isset($postdata['billisship']) && $postdata['billisship'] == 1) {
$shippingaddresses = $billingaddresses;
} else {
$key = 0;
$shippingaddresses = $order_functions->getShippingAddress($row->user_id);
$shipp_users_info_id = isset($postdata['shipp_users_info_id']) && $postdata['shipp_users_info_id'] != 0 ? $postdata['shipp_users_info_id'] : 0;
if ($shipp_users_info_id != 0) {
for ($o = 0; $o < count($shippingaddresses); $o++) {
if ($shippingaddresses[$o]->users_info_id == $shipp_users_info_id) {
$key = $o;
break;
}
}
}
$shippingaddresses = $shippingaddresses[$key];
}
// ORDER DELIVERY TIME IS REMAINING
$user_id = $row->user_id;
$item = $postdata['order_item'];
for ($i = 0; $i < count($item); $i++) {
$product_id = $item[$i]->product_id;
$quantity = $item[$i]->quantity;
$product_excl_price = $item[$i]->prdexclprice;
$product_price = $item[$i]->productprice;
// Attribute price added
$generateAttributeCart = $rsCarthelper->generateAttributeArray((array) $item[$i], $user_id);
$retAttArr = $producthelper->makeAttributeCart($generateAttributeCart, $product_id, $user_id, 0, $quantity);
$product_attribute = $retAttArr[0];
// Accessory price
$generateAccessoryCart = $rsCarthelper->generateAccessoryArray((array) $item[$i], $user_id);
$retAccArr = $producthelper->makeAccessoryCart($generateAccessoryCart, $product_id, $user_id);
$product_accessory = $retAccArr[0];
$accessory_total_price = $retAccArr[1];
$accessory_vat_price = $retAccArr[2];
$wrapper_price = 0;
$wrapper_vat = 0;
if ($item[$i]->wrapper_data != 0 && $item[$i]->wrapper_data != '') {
$wrapper = $producthelper->getWrapper($product_id, $item[$i]->wrapper_data);
if (count($wrapper) > 0) {
if ($wrapper[0]->wrapper_price > 0) {
$wrapper_vat = $producthelper->getProducttax($product_id, $wrapper[0]->wrapper_price, $user_id);
}
$wrapper_price = $wrapper[0]->wrapper_price + $wrapper_vat;
}
}
$product = $producthelper->getProductById($product_id);
$rowitem =& $this->getTable('order_item_detail');
if (!$rowitem->bind($postdata)) {
$this->setError($this->_db->getErrorMsg());
return false;
}
// STOCKROOM update
$updatestock = $stockroomhelper->updateStockroomQuantity($product_id, $quantity);
$stockroom_id_list = $updatestock['stockroom_list'];
$stockroom_quantity_list = $updatestock['stockroom_quantity_list'];
$rowitem->stockroom_id = $stockroom_id_list;
$rowitem->stockroom_quantity = $stockroom_quantity_list;
$rowitem->order_item_id = 0;
$rowitem->order_id = $row->order_id;
$rowitem->user_info_id = $row->user_info_id;
$rowitem->supplier_id = $product->manufacturer_id;
$rowitem->product_id = $product_id;
$rowitem->order_item_sku = $product->product_number;
$rowitem->order_item_name = $product->product_name;
$rowitem->product_quantity = $quantity;
$rowitem->product_item_price = $product_price;
$rowitem->product_item_price_excl_vat = $product_excl_price;
$rowitem->product_final_price = $product_price * $quantity;
$rowitem->order_item_currency = REDCURRENCY_SYMBOL;
$rowitem->order_status = $row->order_status;
$rowitem->cdate = $row->cdate;
$rowitem->mdate = $row->cdate;
$rowitem->product_attribute = $product_attribute;
$rowitem->product_accessory = $product_accessory;
$rowitem->wrapper_id = $item[$i]->wrapper_data;
$rowitem->wrapper_price = $wrapper_price;
$rowitem->is_giftcard = 0;
// RedCRM product purchase price
if ($iscrm) {
$crmProductHelper = new crmProductHelper();
$crmproduct = $crmProductHelper->getProductById($product_id);
$rowitem->product_purchase_price = $crmproduct->product_purchase_price > 0 ? $crmproduct->product_purchase_price : $crmproduct->product_price;
}
if ($producthelper->checkProductDownload($product_id)) {
$medianame = $producthelper->getProductMediaName($product_id);
for ($j = 0; $j < count($medianame); $j++) {
$product_serial_number = $producthelper->getProdcutSerialNumber($product_id);
$producthelper->insertProductDownload($product_id, $user_id, $rowitem->order_id, $medianame[$j]->media_name, $product_serial_number->serial_number);
}
}
if (!$rowitem->store()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
/** my accessory save in table start */
if (count($generateAccessoryCart) > 0) {
$attArr = $generateAccessoryCart;
for ($a = 0; $a < count($attArr); $a++) {
$accessory_vat_price = 0;
$accessory_attribute = "";
$accessory_id = $attArr[$a]['accessory_id'];
$accessory_name = $attArr[$a]['accessory_name'];
$accessory_price = $attArr[$a]['accessory_price'];
$accessory_org_price = $accessory_price;
if ($accessory_price > 0) {
$accessory_vat_price = $producthelper->getProductTax($product_id, $accessory_price, $user_id);
}
$attchildArr = $attArr[$a]['accessory_childs'];
for ($j = 0; $j < count($attchildArr); $j++) {
$attribute_id = $attchildArr[$j]['attribute_id'];
$accessory_attribute .= urldecode($attchildArr[$j]['attribute_name']) . ":<br/>";
$rowattitem =& $this->getTable('order_attribute_item');
$rowattitem->order_att_item_id = 0;
$rowattitem->order_item_id = $rowitem->order_item_id;
$rowattitem->section_id = $attribute_id;
$rowattitem->section = "attribute";
$rowattitem->parent_section_id = $accessory_id;
$rowattitem->section_name = $attchildArr[$j]['attribute_name'];
$rowattitem->is_accessory_att = 1;
if ($attribute_id > 0) {
if (!$rowattitem->store()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
}
$propArr = $attchildArr[$j]['attribute_childs'];
for ($k = 0; $k < count($propArr); $k++) {
$section_vat = 0;
if ($propArr[$k]['property_price'] > 0) {
$section_vat = $producthelper->getProducttax($product_id, $propArr[$k]['property_price'], $user_id);
}
$property_id = $propArr[$k]['property_id'];
$accessory_attribute .= urldecode($propArr[$k]['property_name']) . " (" . $propArr[$k]['property_oprand'] . $producthelper->getProductFormattedPrice($propArr[$k]['property_price'] + $section_vat) . ")<br/>";
$subpropArr = $propArr[$k]['property_childs'];
$rowattitem =& $this->getTable('order_attribute_item');
$rowattitem->order_att_item_id = 0;
$rowattitem->order_item_id = $rowitem->order_item_id;
$rowattitem->section_id = $property_id;
$rowattitem->section = "property";
$rowattitem->parent_section_id = $attribute_id;
$rowattitem->section_name = $propArr[$k]['property_name'];
$rowattitem->section_price = $propArr[$k]['property_price'];
$rowattitem->section_vat = $section_vat;
$rowattitem->section_oprand = $propArr[$k]['property_oprand'];
$rowattitem->is_accessory_att = 1;
if ($property_id > 0) {
if (!$rowattitem->store()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
}
for ($l = 0; $l < count($subpropArr); $l++) {
$section_vat = 0;
if ($subpropArr[$l]['subproperty_price'] > 0) {
$section_vat = $producthelper->getProducttax($rowitem->product_id, $subpropArr[$l]['subproperty_price'], $user_id);
}
$subproperty_id = $subpropArr[$l]['subproperty_id'];
$accessory_attribute .= urldecode($subpropArr[$l]['subproperty_name']) . " (" . $subpropArr[$l]['subproperty_oprand'] . $producthelper->getProductFormattedPrice($subpropArr[$l]['subproperty_price'] + $section_vat) . ")<br/>";
$rowattitem =& $this->getTable('order_attribute_item');
$rowattitem->order_att_item_id = 0;
$rowattitem->order_item_id = $rowitem->order_item_id;
$rowattitem->section_id = $subproperty_id;
$rowattitem->section = "subproperty";
$rowattitem->parent_section_id = $property_id;
$rowattitem->section_name = $subpropArr[$l]['subproperty_name'];
$rowattitem->section_price = $subpropArr[$l]['subproperty_price'];
$rowattitem->section_vat = $section_vat;
$rowattitem->section_oprand = $subpropArr[$l]['subproperty_oprand'];
$rowattitem->is_accessory_att = 1;
if ($subproperty_id > 0) {
if (!$rowattitem->store()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
}
}
}
}
$accdata =& $this->getTable('accessory_detail');
if ($accessory_id > 0) {
$accdata->load($accessory_id);
}
$accProductinfo = $producthelper->getProductById($accdata->child_product_id);
$rowaccitem =& $this->getTable('order_acc_item');
$rowaccitem->order_item_acc_id = 0;
$rowaccitem->order_item_id = $rowitem->order_item_id;
$rowaccitem->product_id = $accessory_id;
$rowaccitem->order_acc_item_sku = $accProductinfo->product_number;
$rowaccitem->order_acc_item_name = $accessory_name;
$rowaccitem->order_acc_price = $accessory_org_price;
$rowaccitem->order_acc_vat = $accessory_vat_price;
$rowaccitem->product_quantity = $quantity;
$rowaccitem->product_acc_item_price = $accessory_price;
$rowaccitem->product_acc_final_price = $accessory_price * $quantity;
$rowaccitem->product_attribute = $accessory_attribute;
if ($accessory_id > 0) {
if (!$rowaccitem->store()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
}
}
}
/** my attribute save in table start */
if (count($generateAttributeCart) > 0) {
$attArr = $generateAttributeCart;
for ($j = 0; $j < count($attArr); $j++) {
$attribute_id = $attArr[$j]['attribute_id'];
$rowattitem =& $this->getTable('order_attribute_item');
$rowattitem->order_att_item_id = 0;
$rowattitem->order_item_id = $rowitem->order_item_id;
$rowattitem->section_id = $attribute_id;
$rowattitem->section = "attribute";
$rowattitem->parent_section_id = $rowitem->product_id;
$rowattitem->section_name = $attArr[$j]['attribute_name'];
$rowattitem->is_accessory_att = 0;
if ($attribute_id > 0) {
if (!$rowattitem->store()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
}
$propArr = $attArr[$j]['attribute_childs'];
for ($k = 0; $k < count($propArr); $k++) {
$section_vat = 0;
if ($propArr[$k]['property_price'] > 0) {
$section_vat = $producthelper->getProducttax($rowitem->product_id, $propArr[$k]['property_price'], $user_id);
}
$property_id = $propArr[$k]['property_id'];
/** product property STOCKROOM update start */
$updatestock = $stockroomhelper->updateStockroomQuantity($property_id, $quantity, "property");
$rowattitem =& $this->getTable('order_attribute_item');
$rowattitem->order_att_item_id = 0;
$rowattitem->order_item_id = $rowitem->order_item_id;
$rowattitem->section_id = $property_id;
$rowattitem->section = "property";
$rowattitem->parent_section_id = $attribute_id;
$rowattitem->section_name = $propArr[$k]['property_name'];
$rowattitem->section_price = $propArr[$k]['property_price'];
$rowattitem->section_vat = $section_vat;
$rowattitem->section_oprand = $propArr[$k]['property_oprand'];
$rowattitem->is_accessory_att = 0;
if ($property_id > 0) {
if (!$rowattitem->store()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
}
$subpropArr = $propArr[$k]['property_childs'];
for ($l = 0; $l < count($subpropArr); $l++) {
$section_vat = 0;
if ($subpropArr[$l]['subproperty_price'] > 0) {
$section_vat = $producthelper->getProducttax($product_id, $subpropArr[$l]['subproperty_price'], $user_id);
}
$subproperty_id = $subpropArr[$l]['subproperty_id'];
/** product subproperty STOCKROOM update start */
$updatestock = $stockroomhelper->updateStockroomQuantity($subproperty_id, $quantity, "subproperty");
$rowattitem =& $this->getTable('order_attribute_item');
$rowattitem->order_att_item_id = 0;
$rowattitem->order_item_id = $rowitem->order_item_id;
$rowattitem->section_id = $subproperty_id;
$rowattitem->section = "subproperty";
$rowattitem->parent_section_id = $property_id;
$rowattitem->section_name = $subpropArr[$l]['subproperty_name'];
$rowattitem->section_price = $subpropArr[$l]['subproperty_price'];
$rowattitem->section_vat = $section_vat;
$rowattitem->section_oprand = $subpropArr[$l]['subproperty_oprand'];
$rowattitem->is_accessory_att = 0;
if ($subproperty_id > 0) {
if (!$rowattitem->store()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
}
}
}
}
}
// $producthelper->insertProdcutUserfield($i,$item,$rowitem->order_item_id,12);
if (USE_CONTAINER) {
$producthelper->updateContainerStock($product_id, $quantity, $rowitem->container_id);
}
// Store userfields
$userfields = $item[$i]->extrafieldname;
$userfields_id = $item[$i]->extrafieldId;
for ($ui = 0; $ui < count($userfields); $ui++) {
$adminproducthelper->admin_insertProdcutUserfield($userfields_id[$ui], $rowitem->order_item_id, 12, $userfields[$ui]);
}
// redCRM RMA Transaction Entry
if ($iscrm) {
if (ENABLE_RMA && $rowitem->product_final_price < 0) {
// RMA transation log
if (isset($item[$i]->reason)) {
$rmaTrans =& $this->getTable('rma_transaction');
$rmaTrans->rma_transaction_id = 0;
$rmaTrans->rma_number = $postdata['rma_number'];
$rmaTrans->order_item_return_id = $rowitem->order_item_id;
$rmaTrans->order_item_return_reason = $item[$i]->reason;
$rmaTrans->order_item_return_status = $item[$i]->deposition;
$rmaTrans->order_item_return_action = $item[$i]->action;
$rmaTrans->cdate = time();
$rmaTrans->store();
if (ENABLE_ITEM_TRACKING_SYSTEM) {
// Manage supplier order stock
$crmSupplierOrderHelper = new crmSupplierOrderHelper();
$senddata['main_order_number'] = $postdata['main_order_number'];
$senddata['order_status'] = $row->order_status;
$senddata['product_id'] = $rowitem->product_id;
$senddata['property_id'] = $property_id;
$senddata['subproperty_id'] = $subproperty_id;
$senddata['deposition'] = $item[$i]->deposition;
$itemqty = $rowitem->product_quantity;
for ($r = 0; $r < $itemqty; $r++) {
$crmSupplierOrderHelper->manageStockAffectedRMA($senddata);
}
}
}
}
}
}
$rowpayment =& $this->getTable('order_payment');
if (!$rowpayment->bind($postdata)) {
$this->setError($this->_db->getErrorMsg());
return false;
}
$rowpayment->order_id = $row->order_id;
$rowpayment->payment_method_id = $postdata['payment_method_class'];
$rowpayment->order_payment_amount = $row->order_total;
$rowpayment->order_payment_name = $postdata['order_payment_name'];
$rowpayment->payment_method_class = $postdata['payment_method_class'];
if (!$rowpayment->store()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
// Add billing Info
$userrow =& $this->getTable('user_detail');
$userrow->load($billingaddresses->users_info_id);
$orderuserrow =& $this->getTable('order_user_detail');
if (!$orderuserrow->bind($userrow)) {
$this->setError($this->_db->getErrorMsg());
return false;
}
$orderuserrow->order_id = $row->order_id;
$orderuserrow->address_type = 'BT';
if (!$orderuserrow->store()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
// Add shipping Info
$userrow =& $this->getTable('user_detail');
if (isset($shippingaddresses->users_info_id)) {
$userrow->load($shippingaddresses->users_info_id);
}
$orderuserrow =& $this->getTable('order_user_detail');
if (!$orderuserrow->bind($userrow)) {
$this->setError($this->_db->getErrorMsg());
return false;
}
$orderuserrow->order_id = $row->order_id;
$orderuserrow->address_type = 'ST';
if (!$orderuserrow->store()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
if ($row->order_status == CLICKATELL_ORDER_STATUS) {
$helper->clickatellSMS($row->order_id);
}
// Maintan supplier order stck when item tracking system is enabled
if ($helper->isredCRM()) {
if (ENABLE_ITEM_TRACKING_SYSTEM) {
// Supplier order helper object
$crmSupplierOrderHelper = new crmSupplierOrderHelper();
$getStatus = array();
$getStatus['orderstatus'] = $row->order_status;
$getStatus['paymentstatus'] = $row->order_payment_status;
$crmSupplierOrderHelper->redSHOPOrderUpdate($row->order_id, $getStatus);
unset($getStatus);
}
}
$checkOrderStatus = 1;
if ($postdata['payment_method_class'] == "rs_payment_banktransfer" || $postdata['payment_method_class'] == "rs_payment_banktransfer_discount" || $postdata['payment_method_class'] == "rs_payment_banktransfer2" || $postdata['payment_method_class'] == "rs_payment_banktransfer3" || $postdata['payment_method_class'] == "rs_payment_banktransfer4" || $postdata['payment_method_class'] == "rs_payment_banktransfer5") {
$checkOrderStatus = 0;
}
// Economic Integration start for invoice generate and book current invoice
if (ECONOMIC_INTEGRATION == 1 && ECONOMIC_INVOICE_DRAFT != 2) {
$issplit = 0;
$economic = new economic();
if (isset($postdata['issplit']) && $postdata['issplit'] == 1) {
$issplit = 1;
}
$economicdata['split_payment'] = $issplit;
$economicdata['economic_payment_terms_id'] = $postdata['economic_payment_terms_id'];
$economicdata['economic_design_layout'] = $postdata['economic_design_layout'];
$economicdata['economic_is_creditcard'] = $postdata['economic_is_creditcard'];
$payment_name = $postdata['payment_method_class'];
$paymentArr = explode("rs_payment_", $postdata['payment_method_class']);
if (count($paymentArr) > 0) {
$payment_name = $paymentArr[1];
}
$economicdata['economic_payment_method'] = $payment_name;
$invoiceHandle = $economic->createInvoiceInEconomic($row->order_id, $economicdata);
if (ECONOMIC_INVOICE_DRAFT == 0) {
$bookinvoicepdf = $economic->bookInvoiceInEconomic($row->order_id, $checkOrderStatus);
if (is_file($bookinvoicepdf)) {
$ret = $redshopMail->sendEconomicBookInvoiceMail($row->order_id, $bookinvoicepdf);
}
}
}
// ORDER MAIL SEND
if ($postdata['task'] != "save_without_sendmail") {
$redshopMail->sendOrderMail($row->order_id);
}
return $row;
}
public function display($tpl = null)
{
$option = JRequest::getVar('option');
$extra_field = new extra_field();
$order_functions = new order_functions();
$Redconfiguration = new Redconfiguration();
$document = JFactory::getDocument();
$document->setTitle(JText::_('COM_REDSHOP_ORDER'));
$document->addScript('components/' . $option . '/assets/js/select_sort.js');
$document->addStyleSheet('components/' . $option . '/assets/css/search.css');
$document->addScript('components/' . $option . '/assets/js/search.js');
$document->addScript('components/' . $option . '/assets/js/json.js');
$document->addScript('components/' . $option . '/assets/js/validation.js');
$document->addScript('components/' . $option . '/assets/js/order.js');
$document->addScript('components/' . $option . '/assets/js/common.js');
$uri = JFactory::getURI();
$lists = array();
$billing = array();
$shippinginfo = array();
$model = $this->getModel();
$detail = $this->get('data');
$redhelper = new redhelper();
$payment_lang_list = $redhelper->getPlugins("redshop_payment");
$language = JFactory::getLanguage();
$base_dir = JPATH_ADMINISTRATOR;
$language_tag = $language->getTag();
for ($l = 0; $l < count($payment_lang_list); $l++) {
$extension = 'plg_redshop_payment_' . $payment_lang_list[$l]->element;
$language->load($extension, $base_dir, $language_tag, true);
}
$err = JRequest::getVar('err', '');
$shipping_rate_id = JRequest::getVar('shipping_rate_id');
$user_id = JRequest::getVar('user_id', 0);
if ($user_id != 0) {
$billing = $order_functions->getBillingAddress($user_id);
$shippinginfo = $order_functions->getShippingAddress($user_id);
} else {
$billing = $model->setBilling();
}
$shipping_country = 0;
$shipping_state = 0;
$key = 0;
$shippingop = array();
$shippingop[0] = new stdClass();
$shippingop[0]->users_info_id = 0;
$shippingop[0]->text = JText::_('COM_REDSHOP_SELECT');
if (count($shippinginfo) > 0) {
$shipping_users_info_id = JRequest::getVar('shipping_users_info_id', 0);
if ($shipping_users_info_id != 0) {
for ($o = 0; $o < count($shippinginfo); $o++) {
if ($shippinginfo[$o]->users_info_id == $shipping_users_info_id) {
$key = $o;
break;
}
}
$shipping_country = $shippinginfo[$key]->country_code;
$shipping_state = $shippinginfo[$key]->state_code;
}
$shippingop = array_merge($shippingop, $shippinginfo);
$billisship = $shippinginfo[$key]->billisship = $shipping_users_info_id ? 0 : 1;
} else {
$shippinginfo[0] = $model->setShipping();
$shipping_users_info_id = $shippinginfo[0]->users_info_id = 0;
$billisship = $shippinginfo[0]->billisship;
}
$shdisable = $billisship ? "disabled" : "";
$detail->user_id = $user_id;
$lists['shippinginfo_list'] = JHTML::_('select.genericlist', $shippingop, 'shipp_users_info_id', 'class="inputbox" ' . $shdisable . ' onchange="getShippinginfo(this.value, ' . $billing->is_company . ');" ', 'users_info_id', 'text', $shipping_users_info_id);
$payment_detail = $this->get('payment');
JToolBarHelper::title(JText::_('COM_REDSHOP_ORDER') . ': <small><small>[ ' . JText::_('COM_REDSHOP_NEW') . ' ]</small></small>', 'redshop_order48');
if ($err == "" && array_key_exists("users_info_id", $billing) && $billing->users_info_id) {
JToolBarHelper::custom('savepay', 'save.png', 'save_f2.png', 'Save + Pay', false);
JToolBarHelper::custom('save_without_sendmail', 'save.png', 'save_f2.png', JText::_('COM_REDSHOP_SAVE_WITHOUT_SEND_ORDERMAIL_LBL'), false);
JToolBarHelper::save();
}
JToolBarHelper::cancel();
$countryarray = $Redconfiguration->getCountryList((array) $billing, "country_code", "BT");
$billing->country_code = $countryarray['country_code'];
$lists['country_code'] = $countryarray['country_dropdown'];
$statearray = $Redconfiguration->getStateList((array) $billing, "state_code", "country_code", "BT", 1);
$lists['state_code'] = $statearray['state_dropdown'];
$shipping['country_code_ST'] = $shippinginfo[$key]->country_code;
$countryarray = $Redconfiguration->getCountryList((array) $shipping, "country_code_ST", "ST");
$shipping['country_code_ST'] = $shippinginfo[$key]->country_code = $countryarray['country_code_ST'];
$lists['country_code_ST'] = $countryarray['country_dropdown'];
$statearray = $Redconfiguration->getStateList((array) $shipping, "state_code_ST", "country_code_ST", "ST", 1);
$lists['state_code_ST'] = $statearray['state_dropdown'];
$lists['is_company'] = JHTML::_('select.booleanlist', 'is_company', 'class="inputbox" onchange="showOfflineCompanyOrCustomer(this.value);" ', $billing->is_company, JText::_('COM_REDSHOP_USER_COMPANY'), JText::_('COM_REDSHOP_USER_CUSTOMER'));
$lists['customer_field'] = $extra_field->list_all_field(7, $billing->users_info_id);
$lists['company_field'] = $extra_field->list_all_field(8, $billing->users_info_id);
$lists['shipping_customer_field'] = $extra_field->list_all_field(14, $shippinginfo[0]->users_info_id);
$lists['shipping_company_field'] = $extra_field->list_all_field(15, $shippinginfo[0]->users_info_id);
$this->lists = $lists;
$this->detail = $detail;
$this->billing = $billing;
$this->shipping = $shippinginfo[$key];
$this->shipping_users_info_id = $shipping_users_info_id;
$this->payment_detail = $payment_detail;
$this->shipping_rate_id = $shipping_rate_id;
$this->request_url = $uri->toString();
parent::display($tpl);
}
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;
}
/**
* function ******** To get Shipping rate for cart
*/
public function getDefaultShipping($d)
{
$userhelper = new rsUserhelper();
$session = JFactory::getSession();
$order_subtotal = $d['order_subtotal'];
$user = JFactory::getUser();
$user_id = $user->id;
$db = JFactory::getDbo();
$totaldimention = $this->getCartItemDimention();
$weighttotal = $totaldimention['totalweight'];
$volume = $totaldimention['totalvolume'];
$order_functions = new order_functions();
$userInfo = $order_functions->getBillingAddress($user_id);
$country = '';
$state = '';
$is_company = '';
$newpwhere = '';
$newcwhere = '';
$wherestate = '';
$whereshopper = '';
if ($userInfo) {
$country = $userInfo->country_code;
$is_company = $userInfo->is_company;
$user_id = $userInfo->user_id;
$state = $userInfo->state_code;
}
$shoppergroup = $userhelper->getShoppergroupData($user_id);
if (count($shoppergroup) > 0) {
$shopper_group_id = $shoppergroup->shopper_group_id;
$whereshopper = ' AND (FIND_IN_SET(' . (int) $shopper_group_id . ', shipping_rate_on_shopper_group ) OR shipping_rate_on_shopper_group="") ';
}
if ($country) {
$wherecountry = '(FIND_IN_SET(' . $db->quote($country) . ', shipping_rate_country ) OR shipping_rate_country="0" OR shipping_rate_country="")';
} else {
$wherecountry = '(FIND_IN_SET(' . $db->quote(DEFAULT_SHIPPING_COUNTRY) . ', shipping_rate_country ) OR shipping_rate_country="0"
OR shipping_rate_country="")';
}
if ($state) {
$wherestate = ' AND (FIND_IN_SET(' . $db->quote($state) . ', shipping_rate_state ) OR shipping_rate_state="0" OR shipping_rate_state="")';
}
if (!$is_company) {
$iswhere = " AND ( company_only = 2 or company_only = 0) ";
} else {
$iswhere = " AND ( company_only = 1 or company_only = 0) ";
}
$shippingArr = $this->getShopperGroupDefaultShipping();
$shopper_shipping = 0;
if (empty($shippingArr)) {
$cart = $session->get('cart');
$idx = (int) $cart['idx'];
$totalVolume = 0;
$shippingrate = array();
if ($idx) {
$pwhere = 'AND ( ';
for ($i = 0; $i < $idx; $i++) {
$product_id = $cart[$i]['product_id'];
$pwhere .= 'FIND_IN_SET(' . (int) $product_id . ', shipping_rate_on_product)';
if ($i != $idx - 1) {
$pwhere .= " or ";
}
}
$pwhere .= ")";
$newpwhere = str_replace("AND (", "OR (", $pwhere);
$sql = "SELECT * FROM " . $this->_table_prefix . "shipping_rate as sr " . "LEFT JOIN #__extensions AS s ON sr.shipping_class = s.element\n\t\t \t \t\t\t\t WHERE s.folder='redshop_shipping' and s.enabled =1 and {$wherecountry}\n\t\t\t\t\t\t\t\t {$iswhere}\n\t\t\t\t\t\t\t\t AND ((shipping_rate_volume_start <= " . $db->quote($volume) . " AND shipping_rate_volume_end >= " . $db->quote($volume) . ") OR (shipping_rate_volume_end = 0) )\n\t\t\t\t\t\t\t\t AND ((shipping_rate_ordertotal_start <= " . $db->quote($order_subtotal) . " AND shipping_rate_ordertotal_end >= " . $db->quote($order_subtotal) . ") OR (shipping_rate_ordertotal_end = 0))\n\t\t\t\t\t\t\t\t AND ((shipping_rate_weight_start <= " . $db->quote($weighttotal) . " AND shipping_rate_weight_end >= " . $db->quote($weighttotal) . ") OR (shipping_rate_weight_end = 0))\n\t\t\t\t\t\t\t\t {$pwhere} {$wherestate} {$whereshopper}\n\t\t\t\t\t\t\t\t ORDER BY s.ordering, sr.shipping_rate_priority LIMIT 0,1";
$db->setQuery($sql);
$shippingrate = $db->loadObject();
}
if (!$shippingrate) {
for ($i = 0; $i < $idx; $i++) {
$product_id = $cart[$i]['product_id'];
$sel = 'SELECT category_id FROM ' . $this->_table_prefix . 'product_category_xref WHERE product_id = ' . (int) $product_id;
$db->setQuery($sel);
$categorydata = $db->loadObjectList();
$where = ' ';
if ($categorydata) {
$where = 'AND ( ';
for ($c = 0; $c < count($categorydata); $c++) {
$where .= " FIND_IN_SET(" . (int) $categorydata[$c]->category_id . ", shipping_rate_on_category) ";
if ($c != count($categorydata) - 1) {
$where .= " or ";
}
}
$where .= ")";
$newcwhere = str_replace("AND (", "OR (", $where);
$sql = "SELECT * FROM " . $this->_table_prefix . "shipping_rate as sr\n\t\t\t\t\t\t\t\t\t LEFT JOIN #__extensions AS s\n\t\t\t\t\t\t\t\t\t ON\n\t\t\t\t\t\t\t\t\t sr.shipping_class = s.element\n\t\t\t \t \t\t\t\t WHERE s.folder='redshop_shipping' and s.enabled =1 and {$wherecountry} {$whereshopper}\n\t\t\t\t\t\t\t\t\t {$iswhere}\n\t\t\t\t\t\t\t\t\t AND ((shipping_rate_volume_start <= " . $db->quote($volume) . " AND shipping_rate_volume_end >= " . $db->quote($volume) . ") OR (shipping_rate_volume_end = 0) )\n\t\t\t\t\t\t\t\t\t AND ((shipping_rate_ordertotal_start <= " . $db->quote($order_subtotal) . " AND shipping_rate_ordertotal_end >= " . $db->quote($order_subtotal) . ") OR (shipping_rate_ordertotal_end = 0))\n\t\t\t\t\t\t\t\t\t AND ((shipping_rate_weight_start <= " . $db->quote($weighttotal) . " AND shipping_rate_weight_end >= " . $db->quote($weighttotal) . ") OR (shipping_rate_weight_end = 0))\n\t\t\t\t\t\t\t\t\t {$where} {$wherestate}\n\t\t\t\t\t\t\t\t\tORDER BY s.ordering, sr.shipping_rate_priority LIMIT 0,1";
$db->setQuery($sql);
$shippingrate = $db->loadObject();
}
}
}
if (!$shippingrate) {
$sql = "SELECT * FROM " . $this->_table_prefix . "shipping_rate as sr\n\t\t\t\t\t\t\t\t LEFT JOIN #__extensions AS s\n\t\t\t\t\t\t\t\t ON\n\t\t\t\t\t\t\t\t sr.shipping_class = s.element\n\t\t \t \t\tWHERE s.folder='redshop_shipping' and s.enabled =1 and {$wherecountry} {$whereshopper}\n\t\t\t\t\t\t{$iswhere} {$wherestate}\n\t\t\t\t\t\tAND ((shipping_rate_volume_start <= " . $db->quote($volume) . " AND shipping_rate_volume_end >= " . $db->quote($volume) . ") OR (shipping_rate_volume_end = 0) )\n\t\t\t\t\t\tAND ((shipping_rate_ordertotal_start <= " . $db->quote($order_subtotal) . " AND shipping_rate_ordertotal_end >= " . $db->quote($order_subtotal) . ") OR (shipping_rate_ordertotal_end = 0))\n\t\t\t\t\t\tAND ((shipping_rate_weight_start <= " . $db->quote($weighttotal) . " AND shipping_rate_weight_end >= " . $db->quote($weighttotal) . ") OR (shipping_rate_weight_end = 0))\n\t\t\t\t\t\tAND (shipping_rate_on_product = '' {$newpwhere}) AND (shipping_rate_on_category = '' {$newcwhere} )\n\t\t\t\t\t\tORDER BY s.ordering, sr.shipping_rate_priority LIMIT 0,1";
$db->setQuery($sql);
$shippingrate = $db->loadObject();
}
$total = 0;
$shipping_vat = 0;
if ($shippingrate) {
$total = $shippingrate->shipping_rate_value;
if ($shippingrate->apply_vat == 1) {
$result = $this->getShippingVatRates($shippingrate->shipping_tax_group_id, $user_id);
$chk = $this->producthelper->taxexempt_addtocart($user_id);
if (!empty($result) && !empty($chk)) {
if ($result->tax_rate > 0) {
$shipping_vat = $total * $result->tax_rate;
$total = $shipping_vat + $total;
}
}
}
}
$shipArr['shipping_rate'] = $total;
$shipArr['shipping_vat'] = $shipping_vat;
return $shipArr;
} else {
return $shippingArr;
}
}
public function customerInformation()
{
$order_functions = new order_functions();
$query = "SELECT vmui.* , vmsvx.shopper_group_id FROM `#__vm_user_info` AS vmui " . "LEFT JOIN #__vm_shopper_vendor_xref AS vmsvx ON vmui.user_id = vmsvx.user_id ";
$this->_db->setQuery($query);
$data = $this->_db->loadObjectList();
$k = 0;
for ($i = 0; $i < count($data); $i++) {
if ($data[$i]->address_type == "BT") {
$redshopUser = $order_functions->getBillingAddress($data[$i]->user_id);
if (count($redshopUser) > 0) {
$redUserId = $redshopUser->users_info_id;
$row = $this->getTable('user_detail');
$row->load($redUserId);
$row->user_email = $data[$i]->user_email;
$row->shopper_group_id = $data[$i]->shopper_group_id;
$row->firstname = $data[$i]->first_name;
$row->lastname = $data[$i]->last_name;
$row->company_name = $data[$i]->company;
$row->address = $data[$i]->address_1;
$row->city = $data[$i]->city;
$row->country_code = $data[$i]->country;
$row->state_code = $data[$i]->state;
$row->zipcode = $data[$i]->zip;
$row->phone = $data[$i]->phone_1;
if ($row->store()) {
$k++;
}
} else {
$rows = $this->getTable('user_detail');
$rows->load();
$rows->user_id = $data[$i]->user_id;
$rows->user_email = $data[$i]->user_email;
$rows->shopper_group_id = $data[$i]->shopper_group_id;
$rows->firstname = $data[$i]->first_name;
$rows->address_type = $data[$i]->address_type;
$rows->lastname = $data[$i]->last_name;
$rows->company_name = $data[$i]->company;
$rows->address = $data[$i]->address_1;
$rows->city = $data[$i]->city;
$rows->country_code = $data[$i]->country;
$rows->state_code = $data[$i]->state;
$rows->zipcode = $data[$i]->zip;
$rows->phone = $data[$i]->phone_1;
if ($rows->store()) {
$k++;
}
}
} else {
$rows = $this->getTable('user_detail');
$rows->load();
$rows->user_id = $data[$i]->user_id;
$rows->user_email = $data[$i]->user_email;
$rows->shopper_group_id = $data[$i]->shopper_group_id;
$rows->firstname = $data[$i]->first_name;
$rows->address_type = $data[$i]->address_type;
$rows->lastname = $data[$i]->last_name;
$rows->company_name = $data[$i]->company;
$rows->address = $data[$i]->address_1;
$rows->city = $data[$i]->city;
$rows->country_code = $data[$i]->country;
$rows->state_code = $data[$i]->state;
$rows->zipcode = $data[$i]->zip;
$rows->phone = $data[$i]->phone_1;
if ($rows->store()) {
$k++;
}
}
}
return $k;
}
