function getOrderData($localid, $ind = 0)
{
require_once JPATH_SITE . DS . 'components' . DS . 'com_onepage' . DS . 'helpers' . DS . 'opctracking.php';
$order_arr = array();
$order_obj = new stdClass();
OPCtrackingHelper::getOrderVars($localid, $order_arr, $order_obj);
$order_data = array();
$ind = '_' . $ind;
foreach ($order_arr as $k => $d) {
$order_data[$k . $ind] = $d;
}
$total = $order_arr['bt_order_total'];
$order_data['order_total_floor' . $ind] = floor($total);
$order_data['order_total_floortxt' . $ind] = $this->number2text(floor($total));
$cents = round(($total - floor($total)) * 100);
$order_data['order_total_cents' . $ind] = $cents;
return $order_data;
$this->number2text(555);
$dbj = JFactory::getDBO();
$order_id = $dbj->getEscaped($localid);
//ernest get data
$order_data = array();
$fieldsOnly = false;
if (!empty($localid)) {
$q = "SELECT * FROM #__virtuemart_orders WHERE virtuemart_order_id='" . $order_id . "' LIMIT 0,1";
} else {
$fieldsOnly = true;
$q = "SELECT * FROM #__virtuemart_orders WHERE 1 LIMIT 0,1";
}
$dbj->setQuery($q);
// basic order data:
$arr1 = $dbj->loadAssoc();
if (!empty($arr1)) {
$arr1['order_id'] = $arr1['virtuemart_order_id'];
$arr1['user_id'] = $arr1['virtuemart_user_id'];
foreach ($arr1 as $k => $d) {
$order_data[$k . $ind] = $d;
}
}
$total = $order_data['order_total' . $ind];
$order_data['order_total_floor' . $ind] = floor($total);
$order_data['order_total_floortxt' . $ind] = $this->number2text(floor($total));
$cents = round(($total - floor($total)) * 100);
$order_data['order_total_cents' . $ind] = $cents;
$msg = $dbj->getErrorMsg();
if (!empty($msg)) {
echo $msg;
die;
}
$order_id = $arr1['order_id'];
$user_id = $arr1['user_id'];
$qt = "SELECT * from #__virtuemart_order_userinfos WHERE virtuemart_user_id='{$user_id}' AND virtuemart_order_id='{$order_id}' AND address_type = 'BT' LIMIT 0,1";
$dbj->setQuery($qt);
// basic user data from order_info
$bta = $dbj->loadAssoc();
$msg = $dbj->getErrorMsg();
if (!empty($msg)) {
echo $msg;
die;
}
if (!empty($bta)) {
foreach ($bta as $key => $value) {
$order_data['bt_' . $key . $ind] = $value;
}
}
$qt = "SELECT * from #__virtuemart_order_userinfos WHERE virtuemart_user_id='{$user_id}' AND virtuemart_order_id='{$order_id}' AND address_type = 'ST' LIMIT 0,1";
$dbj->setQuery($qt);
$sta = $dbj->loadAssoc();
$msg = $dbj->getErrorMsg();
if (!empty($msg)) {
echo $msg;
die;
}
if (!empty($sta)) {
//$arr1['ship_to_address'] = $sta;
foreach ($sta as $key => $value) {
//if (!$fieldsOnly)
$order_data['st_' . $key . $ind] = $value;
//else $order_data['st_'.$key.$ind] = $order_data['bt_'.$key.$ind];
}
} else {
if (!empty($bta)) {
foreach ($bta as $key => $value) {
//if (!$fieldsOnly)
$order_data['st_' . $key . $ind] = $value;
// else $order_data['st_'.$key.$ind] = 'EMPTY';
}
}
}
// ziskami polozky objednavky
$qt = "SELECT * FROM `#__virtuemart_order_items` WHERE virtuemart_order_id='{$order_id}' ";
$dbj->setQuery($qt);
$prods = $dbj->loadAssocList();
$msg = $dbj->getErrorMsg();
if (!empty($msg)) {
echo $msg;
die;
}
if (!empty($prods)) {
foreach ($prods as $ind2 => $prod) {
foreach ($prod as $key => $value) {
// polozka bude vyzarat napr takto: ar1['order_item_name_0_0'] = 'nazov produktu'
if ($key != 'order_id') {
$order_data[$key . $ind . '_' . $ind2] = $value;
}
}
}
}
// ok, lets get payment information
$q = "select * from `#__virtuemart_order_histories` where virtuemart_order_id = '" . $order_id . "' order by virtuemart_order_history_id desc ";
$dbj->setQuery($q);
$r = $dbj->loadAssocList();
foreach ($r as $ind2 => $historyitem) {
foreach ($historyitem as $key => $value) {
// payment date here is in variable (last change):
// date_added_0_0
$order_data[$key . $ind . '_' . $ind2] = $value;
}
}
$payment_id = $arr1['virtuemart_paymentmethod_id'];
if (!empty($payment) || $payment === '0') {
$order_data['payment_method_id_' . $ind2] = $payment;
$q = "select * from #__virtuemart_paymentmethods where virtuemart_paymentmethod_id = '" . $payment . "' ";
$dbj->setQuery($q);
$r = $dbj->loadAssoc();
if (!empty($r)) {
foreach ($r as $key => $data) {
$order_data[$key . $ind] = $data;
}
}
}
if (!empty($order_data['vendor_id_0_0'])) {
$this->getVendorInfo($order_data, $order_data['vendor_id_0_0'], $ind);
} else {
getVendorInfo($order_data, $ind);
}
return $order_data;
}
function runEucsv()
{
$x = @ob_get_clean();
$x = @ob_get_clean();
$x = @ob_get_clean();
$x = @ob_get_clean();
$x = @ob_get_clean();
$x = @ob_get_clean();
$x = @ob_get_clean();
$x = @ob_get_clean();
header('Content-Type: text/csv; charset=utf-8');
header("Content-Disposition: attachment; filename=\"output.csv\";");
$eu = array('AT', 'BE', 'BG', 'CY', 'CZ', 'DE', 'DK', 'EE', 'ES', 'FI', 'FR', 'GB', 'GR', 'HU', 'IE', 'IT', 'LT', 'LU', 'LV', 'MT', 'NL', 'PL', 'PT', 'RO', 'SE', 'SI', 'SK');
require_once JPATH_SITE . DS . 'components' . DS . 'com_onepage' . DS . 'helpers' . DS . 'opctracking.php';
$array = array();
$order = new stdClass();
$db = JFactory::getDBO();
// all orders:
$q = 'select virtuemart_order_id from #__virtuemart_orders where 1 limit 999999';
$db->setQuery($q);
$res = $db->loadAssocList();
$header = false;
$ha = array();
foreach ($res as $row) {
$order_id = $row['virtuemart_order_id'];
$array = array();
$order = new stdClass();
//OPCtrackingHelper::getOrderVars(11, $array, $order);
//var_dump($array); die();
OPCtrackingHelper::getOrderVars($order_id, $array, $order);
if (!$header) {
foreach ($array as $k2 => $c2) {
echo '"' . $k2 . '",';
$ha[$k2] = '';
}
echo '"is_eu",';
echo "\r\n";
$ha['is_eu'] = '';
$header = true;
}
//var_dump($ha); die();
$ha2 = $ha;
foreach ($array as $k => $c) {
//echo '"'.$c.'",'; //country_2_code
if (array_key_exists($k, $ha)) {
$ha2[$k] = '"' . $c . '",';
}
if ($k == 'st_country_2_code') {
if (in_array($c, $eu)) {
$ha2['is_eu'] = '"X",';
} else {
$ha2['is_eu'] = ',';
}
}
}
foreach ($ha2 as $val) {
echo $val;
}
echo "\r\n";
}
die;
}
public static function updateHtml($html, &$order, $afterrender = false)
{
require_once JPATH_SITE . DS . 'components' . DS . 'com_onepage' . DS . 'helpers' . DS . 'config.php';
$ty_page = OPCconfig::getValue('ty_page', 'ty_page', 0, array());
if (empty($ty_page)) {
return;
}
if (empty($order)) {
return;
}
if (is_array($order)) {
if (isset($order['details'])) {
$order = $order['details']['BT'];
}
}
//we must reload order here in case any plugin had changed it in meantime:
$id = $order->virtuemart_order_id;
if (!empty($id)) {
require_once JPATH_ROOT . DS . 'components' . DS . 'com_onepage' . DS . 'helpers' . DS . 'mini.php';
$orderModel = OPCmini::getModel('orders');
$order_full = $orderModel->getOrder($id);
if (empty($order_full)) {
return;
}
$order = $order_full['details']['BT'];
}
$status = $order->order_status;
if (!is_object($order)) {
return;
}
$payment_id = $order->virtuemart_paymentmethod_id;
if (empty($order->order_language)) {
$jlang = JFactory::getLanguage();
$cl = $jlang->getTag();
$cl = strtolower(str_replace('-', '_', $cl));
} else {
$cl = $order->order_language;
}
// check conditions:
$orightml = $html;
$todo = array();
foreach ($ty_page as $k => $ty) {
if (!is_object($ty)) {
continue;
}
if ($ty->payment_id != $payment_id) {
continue;
}
if (!empty($ty->language)) {
if ($ty->language != $cl) {
continue;
}
}
if ($ty->order_status != $status) {
continue;
}
$todo[] = $ty;
}
if (empty($todo)) {
return;
}
/*
COM_ONEPAGE_TY_MODE_0="Prepend to payment generated html"
COM_ONEPAGE_TY_MODE_1="Append to payment generated html"
COM_ONEPAGE_TY_MODE_2="Replace payment generated html"
*/
require_once JPATH_SITE . DS . 'components' . DS . 'com_onepage' . DS . 'helpers' . DS . 'loader.php';
require_once JPATH_SITE . DS . 'components' . DS . 'com_onepage' . DS . 'helpers' . DS . 'opctracking.php';
$repvals = array();
$order_object = new stdClass();
OPCtrackingHelper::getOrderVars($id, $repvals, $order_object, false);
foreach ($todo as $ty2) {
$htmla = OPCloader::getArticle($ty2->article_id, $repvals);
if (empty($ty2->mode)) {
$html = $htmla . '<br />' . $html;
} else {
if ($ty2->mode == 1) {
$html = $html . '<br />' . $htmla;
} else {
if ($ty->mode == 2) {
$html = $htmla;
}
}
}
}
if (defined('TYMODDONE')) {
return $html;
} else {
define('TYMODDONE', true);
}
if ($orightml != $html) {
if (!$afterrender) {
JRequest::setVar('html', $html);
} else {
$buffer = JResponse::getBody();
$buffer = str_replace($orightml, $html, $buffer);
JResponse::setBody($buffer);
}
}
return $html;
}
function getOrderVars(&$named)
{
require_once JPATH_SITE . DS . 'components' . DS . 'com_onepage' . DS . 'helpers' . DS . 'opctracking.php';
$array = array();
$object = new stdClass();
$named = array();
OPCtrackingHelper::getOrderVars(0, $array, $object, false, $named);
return $array;
}
