function xmlexport()
{
$eu = JRequest::getVar('export_eu_csv');
if (!empty($eu)) {
$this->runEucsv();
return;
}
$tid = JRequest::getInt('selected_tid');
if (empty($tid)) {
return;
}
$startdate = JRequest::getVar('startdateo');
$enddate = JRequest::getVar('enddateo');
$startid = JRequest::getVar('startid');
$endid = JRequest::getVar('endid');
if (!empty($startdate)) {
$startdate = strtotime($startdate) == -1 ? '' : strtotime($startdate);
}
if (!empty($enddate)) {
$enddate = strtotime($enddate) == -1 ? '' : strtotime($enddate);
}
$startdate = date("Y-m-d H:i:s", $startdate);
if (!empty($startdate)) {
$where = ' where o.created_on >= "' . $startdate . '" ';
}
if (!empty($enddate)) {
$enddate = $enddate + 60 * 60 * 24 - 1;
$enddate = date("Y-m-d H:i:s", $enddate);
if (!empty($where)) {
$where .= ' and ';
} else {
$where = ' where ';
}
$where .= ' o.created_on <= "' . $enddate . '" ';
}
$startid = JRequest::getVar('startid', '');
$endid = JRequest::getVar('endid', '');
if (!empty($startid)) {
$where = ' where o.virtuemart_order_id >= ' . $startid . ' ';
}
if (!empty($endid)) {
if (!empty($where)) {
$where .= ' and ';
} else {
$where = ' where ';
}
$where .= ' o.virtuemart_order_id <= "' . $endid . '" ';
}
require_once JPATH_ROOT . DS . 'administrator' . DS . 'components' . DS . 'com_onepage' . DS . 'assets' . DS . 'export_helper.php';
$ehelper = new OnepageTemplateHelper();
$tt = $ehelper->getTemplate($tid);
$q = 'select `virtuemart_order_id` from #__virtuemart_orders as o ' . $where;
$db = JFactory::getDBO();
$db->setQuery($q);
ob_start();
$arr = $db->loadAssocList();
$e = $db->getErrorMsg();
echo $e;
/*
var_dump($q);
var_dump($arr); die();
*/
foreach ($arr as $k => $order_data) {
$v = $order_data['virtuemart_order_id'];
$ra = $ehelper->getOrderDataEx($tid, $v);
$localid = $v;
$ehelper->processTxtTemplate($tid, $v, $ra);
}
$msg = ob_get_clean();
$option = JRequest::getVar('option');
$mainframe = JFactory::getApplication();
$limit = $mainframe->getUserStateFromRequest("{$option}.limit", 'limit', 50, 'int');
$limitstart = $mainframe->getUserStateFromRequest("{$option}.limitstart", 'limitstart', 0, 'int');
//var_dump($limit); var_dump($limitstart); die();
$link = 'index.php?option=com_onepage&view=orders&limitstart=' . $limitstart . '&limit=' . $limit;
$this->setRedirect($link);
$this->setRedirect($link, $msg);
}
function sendXmlMulti()
{
//echo 'Sending Multi Order Request... <br />';
$tid = JRequest::getVar('tid');
if (!is_numeric($tid)) {
die;
}
$data = JRequest::get('post');
$enum = 0;
require_once JPATH_COMPONENT . DS . 'assets' . DS . 'export_helper.php';
$ehelper = new OnepageTemplateHelper();
$tt = $ehelper->getTemplate($tid);
$ra = array();
$localid = '';
if ($tt['tid_type'] == 'ORDERS') {
foreach ($data as $k => $v) {
//echo '<br />'.$k.' '.$v;
if (strpos($k, 'selectedorder') !== false) {
//echo 'Order: '.$v.'<br />';
$ra[] = $ehelper->getOrderDataEx($tid, $v, null, $enum);
$enum++;
//$ra = array_merge($ra, $arr);
if (!empty($localid)) {
$localid .= '_' . $v;
} else {
$localid .= $v;
}
}
}
$oa = array();
foreach ($ra as $va) {
foreach ($va as $key => $val) {
$oa[$key] = $val;
}
}
$ehelper->setStatus($tid, $localid, 'PROCESSING');
$xml = $ehelper->getXml($tid, $localid, $oa);
$hash = $ehelper->getFileHash($tid);
$XPost = '&xml=' . urlencode((string) $xml);
$ehelper->sendData($XPost);
//file_put_contents(JPATH_ROOT.DS.'temp.xml', $xml);
} else {
if ($tt['tid_type'] == 'ORDER_DATA') {
foreach ($data as $k => $v) {
//echo '<br />'.$k.' '.$v;
if (strpos($k, 'selectedorder') !== false) {
//echo 'Order: '.$v.'<br />';
$ra[] = $ehelper->getOrderDataEx($tid, $v);
$localid = $v;
$ehelper->setStatus($tid, $localid, 'PROCESSING');
$xml = $ehelper->getXml($tid, $localid);
$hash = $ehelper->getFileHash($tid);
$XPost = '&xml=' . urlencode((string) $xml);
$ehelper->sendData($XPost);
//file_put_contents(JPATH_ROOT.DS.'temp.xml', $xml);
}
}
} else {
if ($tt['tid_type'] == 'ORDER_DATA_TXT') {
foreach ($data as $k => $v) {
//echo '<br />'.$k.' '.$v;
if (strpos($k, 'selectedorder') !== false) {
var_dump($v);
echo '<br />';
//echo 'Order: '.$v.'<br />';
$ra = $ehelper->getOrderDataEx($tid, $v);
$localid = $v;
$ehelper->processTxtTemplate($tid, $v, $ra);
//echo 'som tu';
}
}
}
}
}
echo $tt['tid_type'];
$mainframe = JFactory::getApplication();
$mainframe->close();
}
