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;
}
