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