/** * process export * @name process_export * @param Filterstatement to select orders * @param db-object * @return bool true/false */ function process_export(&$db) { global $mosConfig_absolute_path, $database; $xmldoc = new DOMIT_Document(); $xmldoc->appendEntityTranslationTable(get_html_translation_table(HTML_SPECIALCHARS, ENT_QUOTES)); //damit sollte htmlspecialchars nicht mehr notwendig sein $xmldoc->expandEmptyElementTags(false); $xmldoc->appendChild($xmldoc->createProcessingInstruction("xml", "version=\"1.0\" encoding=\"IS0-8859-1\"")); $xmldoc->setDocumentElement($xmldoc->createElement('OLOrders')); $xmldoc->documentElement->appendChild($xmldoc->createElement('Version1.1')); $order_status = vmGet($_REQUEST, 'status', ''); $order_from = vmGet($_REQUEST, 'from', ''); $order_since = vmGet($_REQUEST, 'since', ''); $order_since = vmGet($_REQUEST, 'since', ''); $order_to = vmGet($_REQUEST, 'to', ''); $order_id = vmGet($_REQUEST, 'order_id', ''); $where = array(); if (!$order_status && !$order_from && !$order_since && !$order_to && !$order_id) { $order_status = 'P'; } if ($order_status) { $where[] = "order_status = '" . $db->getEscaped($order_status) . "'"; } if ($order_from) { $where[] = "order_id >= '" . $db->getEscaped($order_from) . "'"; } elseif ($order_since) { $where[] = "order_id > '" . $db->getEscaped($order_since) . "'"; } elseif ($order_id) { $where[] = "order_id = '" . $db->getEscaped($order_id) . "'"; } if ($order_to && !$order_id) { $where[] = "order_id <= '" . $db->getEscaped($order_to) . "'"; } //select the orders to export $q = 'SELECT * FROM #__{vm}_orders WHERE vendor_id=\'' . $db->f('vendor_id') . '\' AND '; $q .= implode($where); $db->setQuery($q); $orders = $db->loadAssocList(); for ($i = 0; $i < count($orders); $i++) { //get billing and shipping address $q = "SELECT * FROM #__{vm}_order_user_info WHERE order_id='" . $orders[$i]['order_id'] . "'"; $db->setQuery($q); $orders[$i]['user_info'] = $db->loadAssocList(); //get shipping address $q = "SELECT * FROM #__{vm}_order_item WHERE order_id='" . $orders[$i]['order_id'] . "'"; $db->setQuery($q); $orders[$i]['item'] = $db->loadAssocList(); //get payment info $q = "SELECT * FROM #__{vm}_order_payment WHERE order_id='" . $orders[$i]['order_id'] . "'"; $db->setQuery($q); $orders[$i]['payment'] = $db->loadAssocList(); } foreach ($orders as $order) { //print_r($order); $OLWebOrder['OLWebOrder']['TransactionHeader']['TransactionID'] = $order['order_id']; $OLWebOrder['OLWebOrder']['OrderHeader']['ProcessingOptions']['OrderDate'] = date('d.m.Y H:i:s', $order['cdate']); $OLWebOrder['OLWebOrder']['OrderHeader']['HeaderText'] = $order['customer_note']; $OLWebOrder['OLWebOrder']['OrderHeader']['ProcessingOptions']['RefNo'] = str_pad($order['order_id'], 8, 0, STR_PAD_LEFT); for ($i = 0; $i < count($order['user_info']); $i++) { switch ($order['user_info'][$i]['address_type']) { case 'BT': default: if ($order['company']) { $OLWebOrder['OLWebOrder']['OrderHeader']['Address']['Name1'] = $order['user_info'][$i]['company']; $OLWebOrder['OLWebOrder']['OrderHeader']['Address']['Name2'] = $order['user_info'][$i]['first_name'] . ($order['user_info'][$i]['middle_name'] ? ' ' . $order['user_info'][$i]['middle_name'] . ' ' : ' ') . $order['user_info'][$i]['last_name']; $OLWebOrder['OLWebOrder']['OrderHeader']['Address']['Matchcode'] = $order['user_info'][$i]['company'] . ', ' . $order['user_info'][$i]['customers_city']; } else { $OLWebOrder['OLWebOrder']['OrderHeader']['Address']['Name1'] = $order['user_info'][$i]['last_name']; $OLWebOrder['OLWebOrder']['OrderHeader']['Address']['Name2'] = $order['user_info'][$i]['first_name'] . ($order['user_info'][$i]['middle_name'] ? ' ' . $order['user_info'][$i]['middle_name'] : ''); $OLWebOrder['OLWebOrder']['OrderHeader']['Address']['Matchcode'] = $order['user_info'][$i]['last_name'] . ', ' . $order['user_info'][$i]['city']; } $OLWebOrder['OLWebOrder']['OrderHeader']['Address']['Title'] = $order['user_info'][$i]['title']; $OLWebOrder['OLWebOrder']['OrderHeader']['Address']['Street'] = $order['user_info'][$i]['address_1'] . ($order['user_info'][$i]['address_2'] ? ', ' . $order['user_info'][$i]['address_2'] : ''); $OLWebOrder['OLWebOrder']['OrderHeader']['Address']['ZIPCode'] = $order['user_info'][$i]['zip']; $OLWebOrder['OLWebOrder']['OrderHeader']['Address']['City'] = $order['user_info'][$i]['city']; $OLWebOrder['OLWebOrder']['OrderHeader']['Address']['State'] = $order['user_info'][$i]['state']; $OLWebOrder['OLWebOrder']['OrderHeader']['Address']['Country'] = $this->getISOCode2($order['user_info'][$i]['country']); $OLWebOrder['OLWebOrder']['OrderHeader']['Address']['EMail'] = $order['user_info'][$i]['user_email']; $OLWebOrder['OLWebOrder']['OrderHeader']['Address']['AddrTelefon'] = $order['user_info'][$i]['phone_1']; $OLWebOrder['OLWebOrder']['OrderHeader']['Address']['AddrFax'] = $order['user_info'][$i]['fax']; break; case 'ST': if ($order['company']) { $OLWebOrder['OLWebOrder']['OrderHeader']['DeliveryAddress']['DAName1'] = $order['user_info'][$i]['company']; $OLWebOrder['OLWebOrder']['OrderHeader']['DeliveryAddress']['DAName2'] = $order['user_info'][$i]['first_name'] . ($order['user_info'][$i]['middle_name'] ? ' ' . $order['user_info'][$i]['middle_name'] . ' ' : ' ') . $order['user_info'][$i]['last_name']; } else { $OLWebOrder['OLWebOrder']['OrderHeader']['DeliveryAddress']['DAName1'] = $order['user_info'][$i]['last_name']; $OLWebOrder['OLWebOrder']['OrderHeader']['DeliveryAddress']['DAName2'] = $order['user_info'][$i]['first_name'] . ($order['user_info'][$i]['middle_name'] ? ' ' . $order['user_info'][$i]['middle_name'] : ''); } $OLWebOrder['OLWebOrder']['OrderHeader']['DeliveryAddress']['DATitle'] = $order['user_info'][$i]['title']; $OLWebOrder['OLWebOrder']['OrderHeader']['DeliveryAddress']['DAStreet'] = $order['user_info'][$i]['address_1'] . ($order['user_info'][$i]['address_2'] ? ', ' . $order['user_info'][$i]['address_2'] : ''); $OLWebOrder['OLWebOrder']['OrderHeader']['DeliveryAddress']['DAZIPCode'] = $order['user_info'][$i]['zip']; $OLWebOrder['OLWebOrder']['OrderHeader']['DeliveryAddress']['DACity'] = $order['user_info'][$i]['city']; $OLWebOrder['OLWebOrder']['OrderHeader']['DeliveryAddress']['DAState'] = $order['user_info'][$i]['state']; $OLWebOrder['OLWebOrder']['OrderHeader']['DeliveryAddress']['DACountry'] = $this->getISOCode2($order['user_info'][$i]['country']); break; } } $OLWebOrder['OLWebOrder']['OrderHeader']['ProcessingOptions']['CarrierCode'] = $this->getCarrierCode($order[$i]['ship_method_id']); $OLWebOrder['OLWebOrder']['OrderHeader']['ProcessingOptions']['DeliveryPriceGross'] = 0; $OLWebOrder['OLWebOrder']['OrderHeader']['Payment']['Currency'] = $order['order_currency']; $OLWebOrder['OLWebOrder']['OrderHeader']['Payment']['BelOLPayCond'] = $this->getPaymentCode($order['payment'][0]['payment_method_id']); $this->OLWebOrder[] = $OLWebOrder; $OLWebOrder = array(); } $this->xmldoc =& $xmldoc; return true; }
/** * (re)write the web.config file to prevent browser access to the log file */ function handleWebConfig() { global $setup_site_log_dir; global $setup_site_log_file; require_once 'include/domit/xml_domit_include.php'; $prefix = $setup_site_log_dir . empty($setup_site_log_dir) ? '' : '/'; $config_array = array(array('1' => $prefix . str_replace('.', '\\.', $setup_site_log_file) . '\\.*', '2' => 'log_file_restricted.html'), array('1' => $prefix . 'install.log', '2' => 'log_file_restricted.html'), array('1' => $prefix . 'upgradeWizard.log', '2' => 'log_file_restricted.html'), array('1' => $prefix . 'emailman.log', '2' => 'log_file_restricted.html'), array('1' => 'not_imported_.*.txt', '2' => 'log_file_restricted.html'), array('1' => 'XTemplate/(.*)/(.*).php', '2' => 'index.php'), array('1' => 'data/(.*).php', '2' => 'index.php'), array('1' => 'examples/(.*).php', '2' => 'index.php'), array('1' => 'include/(.*).php', '2' => 'index.php'), array('1' => 'include/(.*)/(.*).php', '2' => 'index.php'), array('1' => 'log4php/(.*).php', '2' => 'index.php'), array('1' => 'log4php/(.*)/(.*)', '2' => 'index.php'), array('1' => 'metadata/(.*)/(.*).php', '2' => 'index.php'), array('1' => 'modules/(.*)/(.*).php', '2' => 'index.php'), array('1' => 'soap/(.*).php', '2' => 'index.php'), array('1' => 'emailmandelivery.php', '2' => 'index.php'), array('1' => 'cron.php', '2' => 'index.php')); $xmldoc = new DOMIT_Document(); //create XML declaration $xmlDecl = $xmldoc->createProcessingInstruction('xml', 'version="1.0" encoding="UTF-8"'); $xmldoc->appendChild($xmlDecl); $rootElement = $xmldoc->createElement('configuration'); $xmldoc->appendChild($rootElement); $system_webserver = $xmldoc->createElement('system.webServer'); $rewrite = $xmldoc->createElement('rewrite'); $rules = $xmldoc->createElement('rules'); for ($i = 0; $i < count($config_array); $i++) { $rule[$i] = $xmldoc->createElement('rule'); $rule[$i]->setAttribute('name', $i); $rule[$i]->setAttribute('stopProcessing', 'true'); $match[$i] = $xmldoc->createElement('match'); $match[$i]->setAttribute('url', $config_array[$i]['1']); $rule[$i]->appendChild($match[$i]); $action[$i] = $xmldoc->createElement('action'); $action[$i]->setAttribute('type', 'Redirect'); $action[$i]->setAttribute('url', $config_array[$i]['2']); $rule[$i]->appendChild($action[$i]); $rules->appendChild($rule[$i]); } $rewrite->appendChild($rules); $system_webserver->appendChild($rewrite); $rootElement->appendChild($system_webserver); // echo $xmldoc->documentElement->toNormalizedString(true); $xmldoc->saveXML('web.config', true); }
global $sugar_config; $setup_site_log_dir = isset($_SESSION['setup_site_custom_log_dir']) ? $_SESSION['setup_site_log_dir'] : '.'; $setup_site_log_file = 'sugarcrm.log'; // may be an option later require_once 'include/domit/xml_domit_include.php'; $uploadDir = ''; $uploadHta = ''; if (empty($GLOBALS['sugar_config']['upload_dir'])) { $GLOBALS['sugar_config']['upload_dir'] = 'cache/upload/'; } $prefix = $setup_site_log_dir . empty($setup_site_log_dir) ? '' : '/'; $config_array = array(array('1' => $prefix . str_replace('.', '\\.', $setup_site_log_file) . '\\.*', '2' => 'log_file_restricted.html'), array('1' => $prefix . 'install.log', '2' => 'log_file_restricted.html'), array('1' => $prefix . 'upgradeWizard.log', '2' => 'log_file_restricted.html'), array('1' => $prefix . 'emailman.log', '2' => 'log_file_restricted.html'), array('1' => 'not_imported_.*.txt', '2' => 'log_file_restricted.html'), array('1' => 'XTemplate/(.*)/(.*).php', '2' => 'index.php'), array('1' => 'data/(.*).php', '2' => 'index.php'), array('1' => 'examples/(.*).php', '2' => 'index.php'), array('1' => 'include/(.*).php', '2' => 'index.php'), array('1' => 'include/(.*)/(.*).php', '2' => 'index.php'), array('1' => 'log4php/(.*).php', '2' => 'index.php'), array('1' => 'log4php/(.*)/(.*)', '2' => 'index.php'), array('1' => 'metadata/(.*)/(.*).php', '2' => 'index.php'), array('1' => 'modules/(.*)/(.*).php', '2' => 'index.php'), array('1' => 'soap/(.*).php', '2' => 'index.php'), array('1' => 'emailmandelivery.php', '2' => 'index.php'), array('1' => 'cron.php', '2' => 'index.php'), array('1' => $sugar_config['upload_dir'] . '.*', '2' => 'index.php')); $xmldoc = new DOMIT_Document(); //var_dump($config_array); //create XML declaration $xmlDecl = $xmldoc->createProcessingInstruction('xml', 'version="1.0" encoding="UTF-8"'); $xmldoc->appendChild($xmlDecl); $rootElement = $xmldoc->createElement('configuration'); $xmldoc->appendChild($rootElement); $system_webserver = $xmldoc->createElement('system.webServer'); $rewrite = $xmldoc->createElement('rewrite'); $rules = $xmldoc->createElement('rules'); $rule = array(); $match = array(); $rule_action = array(); for ($i = 0; $i < count($config_array); $i++) { $rule[$i] = $xmldoc->createElement('rule'); $rule[$i]->setAttribute('name', $i); $rule[$i]->setAttribute('stopProcessing', 'true'); $match[$i] = $xmldoc->createElement('match'); $match[$i]->setAttribute('url', $config_array[$i]['1']);