/**
* @param array $ticket
* @return string
*/
public function serialize($ticket)
{
$this->buffer->writeRaw('<?xml version="1.0" encoding="utf-8"?>');
$this->buffer->startElement('ticket');
$this->generateTicket($ticket);
$this->buffer->endElement();
return $this->buffer->outputMemory();
}
function GetProjectDetail($projId)
{
//Return metadata about the columns in each table for a given database (table_schema)
$qry = "SELECT id, p_name, p_details FROM tb_projects where id = " . $projId;
date_default_timezone_set('Australia/Sydney');
error_log("In project_get_detail.php...\n" . $qry);
$dbConn = opendatabase();
$result = mysqli_query($dbConn, $qry);
date_default_timezone_set('Australia/Sydney');
error_log("Records in Projects: " . mysqli_num_rows($result));
if (!$result || mysqli_num_rows($result) <= 0) {
echo "Could not obtain metadata information.";
return false;
}
/*****************************************************************/
$xml = new XMLWriter();
//$projXml = new DOMDocument();
//$xml->openURI("php://output");
$xml->openMemory();
$xml->startDocument();
$xml->setIndent(true);
$xml->startElement("projects");
while ($row = mysqli_fetch_assoc($result)) {
$xml->startElement("project");
$xml->writeAttribute('id', $projId);
$xml->writeRaw($row['p_name']);
$xml->endElement();
$xml->startElement("project_details");
$xml->startCData("details");
$xml->writeRaw($row['p_details']);
$xml->endCData();
$xml->endElement();
}
$xml->endElement();
$xml->endDocument();
$dbConn->close();
header('Content-type: text/xml');
$strXML = $xml->outputMemory(TRUE);
$xml->flush();
date_default_timezone_set('Australia/Sydney');
error_log("String XML:\n " . $strXML);
//$projXml->loadXML($strXML);
echo $strXML;
/*****************************************************************
$options = array();
while ($row = mysqli_fetch_assoc($result)){
$options['object_row'][] = $row;
}
echo json_encode($options);
*****************************************************************/
}
public function to_html($parent)
{
$w = new XMLWriter();
$w->openMemory();
$w->startElement('div');
$w->writeAttribute('class', 'season');
$w->startElement('div');
$w->writeAttribute('class', 'season_name');
$w->text("Saison " . $this->get_num());
$w->endElement();
$w->startElement('div');
$w->writeAttribute('class', 'episode_container');
$str = "";
usort($this->episodes, 'wssub_cmp_num');
foreach ($this->episodes as $ep) {
if (!$ep->get_num()) {
$this->log("Bad ep with no number: " . $ep->to_string(), 'warn');
continue;
}
$str .= $ep->to_html($parent);
}
$w->writeRaw($str);
$w->endElement();
$w->endElement();
return $w->flush();
}
/**
* Fallback method for writeRaw, introduced in PHP 5.2
*
* @param string $text
* @return string
*/
public function writeRaw($text)
{
if (isset($this->_xmlWriter) && is_object($this->_xmlWriter) && method_exists($this->_xmlWriter, 'writeRaw')) {
return $this->_xmlWriter->writeRaw($text);
}
return $this->text($text);
}
/**
* Method for parsing of elements
*
* @param string $node - node name
* @param string $item - node content
* @param bool $wrap - should be wrapped in array for singularization
*
* @return void
*
* @since 1.0
*/
protected function handleElement($node, $item, $wrap = true)
{
if ($this->dispatcher->listensTo($node)) {
$this->dispatcher->trigger($node, array($this->writer, $node, $item));
} else {
if ($node === self::COMMENT) {
if (!is_array($item)) {
$item = array($item);
}
foreach ($item as $comment) {
$this->writer->writeComment($comment);
}
} elseif ($node === self::CDATA) {
$this->writer->writeCdata($item);
} else {
if ($wrap === true) {
if ($this->assertElementName($node)) {
if ($this->config->nil_on_null === true && is_null($item)) {
$this->writer->startElement($node);
$this->writer->writeAttribute('xsi:nil', 'true');
$this->writer->writeRaw($item);
$this->writer->endElement();
} else {
$this->writer->writeElement($node, $item);
}
}
} else {
$this->writer->writeRaw($item);
}
}
}
}
protected function _genResponse()
{
$writer = new \XMLWriter();
$writer->setIndent(4);
$writer->openMemory();
$writer->startElement('Response');
foreach ($this->getMessages() as $message) {
$writer->startElement('Sms');
$writer->writeRaw((string) $message);
$writer->endElement();
}
if ($redirect = $this->getRedirect()) {
$writer->startElement('Redirect');
$writer->writeRaw($redirect);
$writer->endElement();
}
$writer->endElement();
return $writer->outputMemory(true);
}
public function write(\XMLWriter $writer, \DateTimeZone $timezone, $stringTag)
{
$xml = $this->value->asXML();
// Not all combinations of PHP/libxml support stripping
// the XML declaration. So, we do it ourselves here.
if (strlen($xml) >= 6 && !strncmp($xml, '<?xml', 5) && strpos(" \t\r\n", $xml[5]) !== false) {
$xml = (string) substr($xml, strpos($xml, '?>') + 2);
}
$writer->startElementNS('ex', 'dom', 'http://ws.apache.org/xmlrpc/namespaces/extensions');
$writer->writeRaw($xml);
$writer->fullEndElement();
}
public function to_html($parent)
{
$w = new XMLWriter();
$w->openMemory();
$w->startElement('div');
$w->writeAttribute('class', 'log_message');
$w->startElement('div');
$w->writeAttribute('class', 'log_message_' . $this->type);
$w->writeRaw('<div class="log_class">' . $this->class . '</div>::<div class="log_msg">' . $this->msg . '</div>');
$w->endElement();
$w->endElement();
return $w->flush();
}
/**
* Generates the export
*
* @param integer $categoryId Category Id
* @param boolean $downwards If true, downwards, otherwise upward ordering
* @param string $language Language
*
* @return string
*/
public function generate($categoryId = 0, $downwards = true, $language = '')
{
global $PMF_LANG;
// Initialize categories
$this->category->transform($categoryId);
$faqdata = $this->faq->get(FAQ_QUERY_TYPE_EXPORT_XHTML, $categoryId, $downwards, $language);
$version = PMF_Configuration::getInstance()->get('main.currentVersion');
$comment = sprintf('XHTML output by phpMyFAQ %s | Date: %s', $version, PMF_Date::createIsoDate(date("YmdHis")));
$this->xml->startDocument('1.0', 'utf-8');
$this->xml->writeDtd('html', '-//W3C//DTD XHTML 1.0 Transitional//EN', 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd');
$this->xml->startElement('html');
$this->xml->writeAttribute('xmlns', 'http://www.w3.org/1999/xhtml');
$this->xml->writeAttribute('xml:lang', $language);
$this->xml->writeComment($comment);
$this->xml->startElement('head');
$this->xml->writeElement('title', PMF_Configuration::getInstance()->get('main.titleFAQ'));
$this->xml->startElement('meta');
$this->xml->writeAttribute('http-equiv', 'Content-Type');
$this->xml->writeAttribute('content', 'application/xhtml+xml; charset=utf-8');
$this->xml->endElement();
$this->xml->endElement();
// </head>
$this->xml->startElement('body');
$this->xml->writeAttribute('dir', $PMF_LANG['dir']);
if (count($faqdata)) {
$lastCategory = 0;
foreach ($faqdata as $data) {
if ($data['category_id'] != $lastCategory) {
$this->xml->writeElement('h1', $this->category->getPath($data['category_id'], ' >> '));
}
$this->xml->writeElement('h2', strip_tags($data['topic']));
$this->xml->startElement('p');
$this->xml->writeRaw(html_entity_decode($data['content'], ENT_QUOTES, 'UTF-8'));
$this->xml->endElement();
$this->xml->writeElement('p', $PMF_LANG['msgAuthor'] . ': ' . $data['author_email']);
$this->xml->writeElement('p', $PMF_LANG['msgLastUpdateArticle'] . PMF_Date::createIsoDate($data['lastmodified']));
$lastCategory = $data['category_id'];
}
}
$this->xml->endElement();
// </body>
$this->xml->endElement();
// </html>
header('Content-type: text/html');
return $this->xml->outputMemory();
}
private function addToken(array $token)
{
if ($this->lastLine < $token['line']) {
$this->writer->endElement();
for ($t = $this->lastLine + 1; $t < $token['line']; $t++) {
$this->writer->startElement('line');
$this->writer->writeAttribute('no', $t);
$this->writer->endElement();
}
$this->writer->startElement('line');
$this->writer->writeAttribute('no', $token['line']);
$this->lastLine = $token['line'];
}
if ($token['value'] != '') {
$this->writer->startElement('token');
$this->writer->writeAttribute('name', $token['name']);
$this->writer->writeRaw($this->encodeString($token['value']));
$this->writer->endElement();
}
}
private function addToken(array $token)
{
if ($this->lastLine < $token['line']) {
$this->writer->endElement();
for ($t = $this->lastLine + 1; $t < $token['line']; $t++) {
$this->writer->startElement('line');
$this->writer->writeAttribute('no', $t);
$this->writer->endElement();
}
$this->writer->startElement('line');
$this->writer->writeAttribute('no', $token['line']);
$this->lastLine = $token['line'];
}
if ($token['value'] != '') {
$this->writer->startElement('token');
$this->writer->writeAttribute('name', $token['name']);
$this->writer->writeRaw(htmlspecialchars($token['value'], ENT_NOQUOTES | ENT_DISALLOWED | ENT_XML1));
$this->writer->endElement();
}
}
public function asXML()
{
$w = new \XMLWriter();
$w->openMemory();
$w->startDocument();
$w->startElement('xml');
foreach ($this->data as $one) {
if ($one[2]) {
$w->startElement($one[0]);
$w->writeRaw($one[1]);
$w->endElement();
} else {
$w->writeElement($one[0], $one[1]);
}
}
$w->endElement();
$w->endDocument();
$this->data = [];
// 清空, 以备下次使用
return $w->outputMemory();
}
<?php
include_once "config.php";
$sql = "select * from posts";
$res = $con->query($sql) or die("Error Json Api 1");
$xml = new XMLWriter();
$xml->openURI("php://output");
$xml->startDocument();
$xml->setIndent(true);
$xml->startElement('Posts');
while ($row = $res->fetch_assoc()) {
$xml->startElement("Post");
$xml->startElement("title");
$xml->writeRaw($row['title']);
$xml->endElement();
$xml->startElement("description");
$xml->writeRaw($row['description']);
$xml->endElement();
$xml->startElement("user_id");
$xml->writeRaw($row['user_id']);
$xml->endElement();
$xml->endElement();
}
$xml->endElement();
header('Content-type: text/xml');
$xml->flush();
$con->close();
public function export($v92ec19ffde05e15769b1bb3ee05ad745)
{
set_time_limit(0);
if (!count($v92ec19ffde05e15769b1bb3ee05ad745)) {
$v8be74552df93e31bbdd6b36ed74bdb6a = new selector('pages');
$v8be74552df93e31bbdd6b36ed74bdb6a->where('hierarchy')->page(0)->childs(0);
$v92ec19ffde05e15769b1bb3ee05ad745 = $v8be74552df93e31bbdd6b36ed74bdb6a->result;
}
$v857a5246dff0c3c79e476b004684f6d3 = CURRENT_WORKING_DIR . "/sys-temp/export/";
$vb80bb7740288fda1f201890375a60c8f = getRequest('param0');
$v97fd815a3803a0588876bdd862014fed = $v857a5246dff0c3c79e476b004684f6d3 . $vb80bb7740288fda1f201890375a60c8f . "." . parent::getFileExt();
if (getRequest('as_file') === '0') {
$ved780287e302ec3b9fd3c5e78771919f = new xmlExporter($this->getSourceName());
$ved780287e302ec3b9fd3c5e78771919f->addBranches($v92ec19ffde05e15769b1bb3ee05ad745);
$result = $ved780287e302ec3b9fd3c5e78771919f->execute();
return $result->saveXML();
}
if (file_exists($v97fd815a3803a0588876bdd862014fed) && !file_exists(CURRENT_WORKING_DIR . '/sys-temp/runtime-cache/' . md5($this->getSourceName()))) {
unlink($v97fd815a3803a0588876bdd862014fed);
}
$v71b70dd1e455c477220693d84ccd5682 = $v97fd815a3803a0588876bdd862014fed . '.tmp';
$v480d1b61a0432d1319f7504a3d7318dd = (int) mainConfiguration::getInstance()->get("modules", "exchange.export.limit");
if ($v480d1b61a0432d1319f7504a3d7318dd <= 0) {
$v480d1b61a0432d1319f7504a3d7318dd = 25;
}
$ved780287e302ec3b9fd3c5e78771919f = new xmlExporter($this->getSourceName(), $v480d1b61a0432d1319f7504a3d7318dd);
$ved780287e302ec3b9fd3c5e78771919f->addBranches($v92ec19ffde05e15769b1bb3ee05ad745);
$vdd988cfd769c9f7fbd795a0f5da8e751 = $ved780287e302ec3b9fd3c5e78771919f->execute();
if (file_exists($v97fd815a3803a0588876bdd862014fed)) {
$v1de9b0a30075ae8c303eb420c103c320 = new XMLReader();
$va82feee3cc1af8bcabda979e8775ef0f = new XMLWriter();
$v1de9b0a30075ae8c303eb420c103c320->open($v97fd815a3803a0588876bdd862014fed);
$va82feee3cc1af8bcabda979e8775ef0f->openURI($v71b70dd1e455c477220693d84ccd5682);
$va82feee3cc1af8bcabda979e8775ef0f->startDocument('1.0', 'utf-8');
$va82feee3cc1af8bcabda979e8775ef0f->startElement('umidump');
$va82feee3cc1af8bcabda979e8775ef0f->writeAttribute('version', '2.0');
$va82feee3cc1af8bcabda979e8775ef0f->writeAttribute('xmlns:xlink', 'http://www.w3.org/TR/xlink');
$v7aa28ed115707345d0274032757e8991 = $v1de9b0a30075ae8c303eb420c103c320->read();
while ($v7aa28ed115707345d0274032757e8991) {
if ($v1de9b0a30075ae8c303eb420c103c320->nodeType == XMLReader::ELEMENT) {
$ve24455211a964330063a18670d943835 = $v1de9b0a30075ae8c303eb420c103c320->name;
if ($ve24455211a964330063a18670d943835 != 'umidump') {
$va82feee3cc1af8bcabda979e8775ef0f->startElement($ve24455211a964330063a18670d943835);
if ($ve24455211a964330063a18670d943835 != 'meta') {
if (!$v1de9b0a30075ae8c303eb420c103c320->isEmptyElement) {
$v7852ddca47412c0d947ebf27eb83ed3a = $v1de9b0a30075ae8c303eb420c103c320->read();
while ($v7852ddca47412c0d947ebf27eb83ed3a) {
if ($v1de9b0a30075ae8c303eb420c103c320->nodeType == XMLReader::ELEMENT) {
$vcf7f5c76225a101e6320a96c02f92fc1 = $v1de9b0a30075ae8c303eb420c103c320->name;
$va82feee3cc1af8bcabda979e8775ef0f->writeRaw($v1de9b0a30075ae8c303eb420c103c320->readOuterXML());
$v7852ddca47412c0d947ebf27eb83ed3a = $v1de9b0a30075ae8c303eb420c103c320->next();
} elseif ($v1de9b0a30075ae8c303eb420c103c320->nodeType == XMLReader::END_ELEMENT && $v1de9b0a30075ae8c303eb420c103c320->name == $ve24455211a964330063a18670d943835) {
$v7852ddca47412c0d947ebf27eb83ed3a = false;
} else {
$v7852ddca47412c0d947ebf27eb83ed3a = $v1de9b0a30075ae8c303eb420c103c320->next();
}
}
}
if ($vdd988cfd769c9f7fbd795a0f5da8e751->getElementsByTagName($ve24455211a964330063a18670d943835)->item(0)->hasChildNodes()) {
$v268184c12df027f536154d099d497b31 = $vdd988cfd769c9f7fbd795a0f5da8e751->getElementsByTagName($ve24455211a964330063a18670d943835)->item(0)->childNodes;
foreach ($v268184c12df027f536154d099d497b31 as $v1b7d5726533ab525a8760351e9b5e415) {
$va5e171f642af8e3bd24c50cdc4d66fe3 = new DOMDocument();
$va5e171f642af8e3bd24c50cdc4d66fe3->formatOutput = true;
$v36c4536996ca5615dcf9911f068786dc = $va5e171f642af8e3bd24c50cdc4d66fe3->importNode($v1b7d5726533ab525a8760351e9b5e415, true);
$va5e171f642af8e3bd24c50cdc4d66fe3->appendChild($v36c4536996ca5615dcf9911f068786dc);
$va82feee3cc1af8bcabda979e8775ef0f->writeRaw($va5e171f642af8e3bd24c50cdc4d66fe3->saveXML($v36c4536996ca5615dcf9911f068786dc, LIBXML_NOXMLDECL));
}
}
} elseif ($ve24455211a964330063a18670d943835 == 'meta') {
$va82feee3cc1af8bcabda979e8775ef0f->writeRaw($v1de9b0a30075ae8c303eb420c103c320->readInnerXML());
$v92ec19ffde05e15769b1bb3ee05ad745 = $vdd988cfd769c9f7fbd795a0f5da8e751->getElementsByTagName('branches');
if ($v92ec19ffde05e15769b1bb3ee05ad745->item(0)) {
$va82feee3cc1af8bcabda979e8775ef0f->writeRaw($vdd988cfd769c9f7fbd795a0f5da8e751->saveXML($v92ec19ffde05e15769b1bb3ee05ad745->item(0), LIBXML_NOXMLDECL));
}
}
$va82feee3cc1af8bcabda979e8775ef0f->fullEndElement();
$v7aa28ed115707345d0274032757e8991 = $v1de9b0a30075ae8c303eb420c103c320->next();
continue;
}
}
$v7aa28ed115707345d0274032757e8991 = $v1de9b0a30075ae8c303eb420c103c320->read();
}
$va82feee3cc1af8bcabda979e8775ef0f->fullEndElement();
$v1de9b0a30075ae8c303eb420c103c320->close();
$va82feee3cc1af8bcabda979e8775ef0f->endDocument();
$va82feee3cc1af8bcabda979e8775ef0f->flush();
unlink($v97fd815a3803a0588876bdd862014fed);
rename($v71b70dd1e455c477220693d84ccd5682, $v97fd815a3803a0588876bdd862014fed);
} else {
file_put_contents($v97fd815a3803a0588876bdd862014fed, $vdd988cfd769c9f7fbd795a0f5da8e751->saveXML());
}
$this->completed = $ved780287e302ec3b9fd3c5e78771919f->isCompleted();
return false;
}
/**
* Generates a XML file with table/query rows encoding with the database
* charset.
* @param array $table Result of table or query fetching.
* @param string $tableElement Represents the entire set of data.
* @param string $rowElement Represents each row data set.
* @return string The XML file.
*/
private function generateXML($table, $tableElement, $rowElement)
{
$comment = sprintf('File generated by DB2XML, %s', date('M d Y'));
$xml = new \XMLWriter();
$xml->openMemory();
$xml->startDocument('1.0', $this->charset);
$xml->writeComment($comment);
$xml->setIndent(true);
$xml->startElement($tableElement);
foreach ($table as $row) {
$xml->startElement($rowElement);
foreach ($row as $column => $value) {
$xml->startElement($column);
$repValue = str_replace('&', '&', $value);
$xml->writeRaw($repValue);
$xml->endElement();
}
$xml->endElement();
}
$xml->endElement();
return $xml->flush();
}
/**
* @param $texts
* @param $source
* @param $target
* @return string
*/
private function getTranslateArrayXmlRequest($texts, $source, $target)
{
$xml = new \XMLWriter();
$xml->openMemory();
$xml->startElement('TranslateArrayRequest');
$xml->startElement('AppId');
$xml->endElement();
//AppId
$xml->writeElement('From', $source);
$xml->startElement('Options');
$xml->startElement('ContentType');
$xml->writeAttribute('xmlns', 'http://schemas.datacontract.org/2004/07/Microsoft.MT.Web.Service.V2');
$xml->writeRaw('text/plain');
$xml->endElement();
//ContentType
$xml->endElement();
//Options
$xml->startElement('Texts');
foreach ($texts as $text) {
$xml->startElement('string');
$xml->writeAttribute('xmlns', 'http://schemas.microsoft.com/2003/10/Serialization/Arrays');
$xml->writeCdata($text);
$xml->endElement();
//string
}
$xml->endElement();
//Texts
$xml->writeElement('To', $target);
$xml->endElement();
//TranslateArrayRequest
return $xml->flush();
}
foreach ($shop->currencies as $currency) {
$writer->startElement('currency');
$writer->writeAttribute('id', Html::encode($currency['id']));
$writer->writeAttribute('rate', Html::encode($currency['rate']));
$writer->endElement();
}
$writer->endElement();
// <categories>
$writer->startElement('categories');
foreach ($shop->categories as $category) {
$writer->startElement('category');
$writer->writeAttribute('id', Html::encode($category['id']));
if ($category['parentId']) {
$writer->writeAttribute('parentId', Html::encode($category['parentId']));
}
$writer->writeRaw(Html::encode($category['name']));
$writer->endElement();
}
$writer->endElement();
// <offers>
$writer->startElement('offers');
foreach ($shop->offers as $offer) {
/** @var $offer \corpsepk\yml\models\Offer */
$writer->startElement('offer');
foreach ($offer->offerElementAttributes as $attribute) {
if (!empty($offer->{$attribute})) {
$writer->writeAttribute($attribute, Html::encode($offer->{$attribute}));
}
}
foreach ($offer->getOfferElements() as $attribute) {
if (empty($offer->{$attribute})) {
/**
* @param bool $root
* @return string
*/
public function pack($root = false)
{
$writer = new XMLWriter();
$writer->openMemory();
if ($root) {
$writer->startDocument();
}
$writer->startElement('order');
if (isset($this->printCustomerInvoice)) {
$writer->writeElement('print_customer_invoice', $this->printCustomerInvoice);
}
if (isset($this->tsCreated)) {
$writer->writeElement('ts_created', $this->tsCreated->format(DateTime::RFC3339));
}
if (isset($this->deliveryDate)) {
$writer->writeElement('delivery_date', $this->deliveryDate->format(DateTime::RFC3339));
}
if (isset($this->priority)) {
$writer->writeElement('priority', $this->priority);
}
if (isset($this->shippingFee)) {
$writer->writeElement('shipping_fee', $this->shippingFee);
}
if (isset($this->productDiscounts)) {
$writer->writeElement('product_discounts', $this->productDiscounts);
}
if (isset($this->shippingDiscounts)) {
$writer->writeElement('shipping_discounts', $this->shippingDiscounts);
}
if (isset($this->vendorId)) {
$writer->writeElement('vendor_id', $this->vendorId);
}
if (isset($this->contact)) {
$writer->writeRaw($this->contact->pack());
}
if (isset($this->shipType)) {
$writer->writeRaw($this->shipType->pack());
}
if (isset($this->requester)) {
$writer->writeRaw($this->requester->pack());
}
if (isset($this->shipAddress)) {
$writer->writeRaw($this->shipAddress->pack());
}
if (isset($this->shipReturnAddress)) {
$writer->writeRaw($this->shipReturnAddress->pack());
}
InkRouter_Utils_OrderProcessor::transform($this);
$writer->startElement('order_items');
foreach ($this->orderItems as $orderItem) {
$writer->writeRaw($orderItem->pack());
}
$writer->endElement();
$writer->endElement();
return $writer->outputMemory();
}
private function packAttributes()
{
$writer = new XMLWriter();
$writer->openMemory();
$writer->startElement('attributes');
foreach ($this->attributes as $attribute) {
$writer->writeRaw($attribute->pack());
}
$writer->endElement();
return $writer->outputMemory();
}
<?php
mysql_connect('db.dcs.aber.ac.uk', 'csgpadm_13', 'RXL7Hmm0');
mysql_select_db('database');
$sql = "SELECT * FROM users ORDER BY userID";
$res = mysql_query($sql);
$xml = new XMLWriter();
$xml->openURI("php://output");
$xml->startDocument();
$xml->setIndent(true);
$xml->startElement('users');
while ($row = mysql_fetch_assoc($res)) {
$xml->startElement("user");
$xml->writeAttribute('userID', $row['useriD']);
$xml->writeRaw($row['user']);
$xml->endElement();
}
$xml->endElement();
header('Content-type: text/xml');
$xml->flush();
function GetProjectRubrics($projId)
{
//Return metadata about the columns in each table for a given database (table_schema)
$qry = "SELECT r_level, r_text, task_id, tb_tasks.task_text FROM tb_rubrics " . "INNER JOIN tb_tasks ON tb_rubrics.task_id = tb_tasks.id " . "WHERE tb_tasks.project_id = " . $projId . " ORDER BY tb_tasks.id, tb_rubrics.r_level;";
date_default_timezone_set('Australia/Sydney');
error_log("In get_project_rubrics.php...\n" . $qry);
$dbConn = opendatabase();
$result = mysqli_query($dbConn, $qry);
date_default_timezone_set('Australia/Sydney');
error_log("Records in Projects: " . mysqli_num_rows($result));
$row_cnt = mysqli_num_rows($result);
$field_cnt = $result->field_count;
error_log("Fields: " . $field_cnt);
if (!$result || mysqli_num_rows($result) <= 0) {
//echo("Could not obtain metadata information.");
return false;
}
/*****************************************************************/
$xml = new XMLWriter();
$xml->openMemory();
$xml->startDocument();
$xml->setIndent(true);
$xml->startElement("task_rubrics");
/* fetch associative array */
/*
$row = mysqli_fetch_row($result);
for($i = 0; $i < $field_cnt; $i++){
error_log("Row[". $i . "] = " . $row[$i]);
error_log("Row[". $i . "] = " . $row[$i].name);
}
*/
/*
$finfo = $result->fetch_fields();
foreach ($finfo as $val) {
error_log("Name: " . $val->name);
error_log("Table: " . $val->table);
error_log("Max. Len: " . $val->max_length);
error_log("Length: " . $val->length);
error_log("charsetnr: " . $val->charsetnr);
error_log("Flags: " . $val->flags);
error_log("Type: " . $val->type);
}
$result->free();
*/
while ($row = mysqli_fetch_assoc($result)) {
$xml->startElement("task");
$xml->writeAttribute('id', $row['task_id']);
$xml->writeRaw($row['task_text']);
$xml->startElement("rubric_details");
$xml->writeAttribute('r_level', $row['r_level']);
$xml->startCData("details");
$xml->writeRaw($row['r_text']);
$xml->endCData();
$xml->endElement();
$xml->endElement();
}
$xml->endElement();
$xml->endDocument();
$dbConn->close();
header('Content-type: text/xml');
$strXML = $xml->outputMemory(TRUE);
$xml->flush();
date_default_timezone_set('Australia/Sydney');
//error_log("String XML:\n " . $strXML);
$projXml = new DOMDocument();
$projXml->loadXML($strXML);
error_log("loading xsl document...");
$xsl = new DOMDocument();
$xsl->load('xsl/proj_rub_html.xsl');
// Configure the transformer
$proc = new XSLTProcessor();
$proc->importStyleSheet($xsl);
// attach the xsl rules
$projRubs = $proc->transformToXML($projXml);
//error_log("XML Transform result\n" . $projRubs);
echo $proc->transformToXML($projXml);
}
/**
* @param \XMLWriter $writer
* @param mixed $origin
* @param Definition $definition
*/
protected function writeScalar(\XMLWriter $writer, $origin, Definition $definition)
{
$content = $definition->extract($origin);
if (strpbrk($content, '></&![]\\') === false) {
$writer->writeRaw($content);
} else {
$writer->writeCdata($content);
}
}
/**
* arrays passed to this method should have a single root element
* with an array as its value
* @param array $array the array of data
* @return var XML string
*/
private function createRequestBody($array, $headerline, $footerline)
{
$writer = new \XMLWriter();
$writer->openMemory();
$writer->setIndent(true);
$writer->setIndentString(' ');
$writer->startDocument('1.0', 'UTF-8');
// header
$header = '<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
' . $headerline . '
';
$writer->writeRaw($header);
if (sizeof($array) == 1) {
// The request is inside of an envelope (objparameters, vparameter)
// get the root element name
$keys = array_keys($array);
$rootElementName = $keys[0];
// open the root element
$writer->startElement($rootElementName);
// create the body
$this->createElements($writer, $array[$rootElementName], $rootElementName);
// close the root element and document
$writer->endElement();
} else {
// There is no envelope, the array that we have is all of the data elements
$this->createElements($writer, $array);
}
// footer
$footer = $footerline . '
</soap:Body>
</soap:Envelope>';
$writer->writeRaw($footer);
$writer->endDocument();
// send the output as string
return $writer->outputMemory();
}
mysql_connect('10.0.0.30', 'monitor', 'raspberry');
mysql_select_db('Monitor');
$sql = "SELECT * FROM Monitor.server;";
$res = mysql_query($sql);
$xml = new XMLWriter();
$xml->openURI("php://output");
$xml->startDocument();
$xml->setIndent(true);
$xml->startElement('data');
$xml->startElement('servers');
while ($row = mysql_fetch_assoc($res)) {
$xml->startElement("server");
$xml->writeAttribute('name', $row['Name']);
$xml->startElement("sID");
$xml->writeRaw($row['sID']);
$xml->endElement();
$xml->startElement("IPAdres");
$xml->writeRaw($row['IPAdres']);
$xml->endElement();
$xml->startElement("IPPort");
$xml->writeRaw($row['IPPort']);
$xml->endElement();
$xml->endElement();
}
$xml->endElement();
$xml->startElement('database');
$xml->startElement("dbIPAdres");
$xml->writeRaw('10.0.0.30');
$xml->endElement();
$xml->startElement("dbUser");
public function to_html($parent)
{
$w = new XMLWriter();
$w->openMemory();
$w->startElement('div');
$w->writeAttribute('class', 'show');
$w->startElement('a');
$w->writeAttribute('class', 'name');
$w->writeAttribute('href', $parent->get_prefix_url() . $this->get_href());
$w->text($this->get_name());
$w->endElement();
$img = null;
if ($img = $this->get_img()) {
$w->startElement('img');
$w->writeAttribute('src', $parent->get_prefix_url() . $img);
$w->writeAttribute('alt', $this->get_name());
$w->endElement();
}
$str = "";
$w->startElement('div');
$w->writeAttribute('class', 'season_container');
usort($this->seasons, 'wssub_cmp_num');
foreach ($this->get_seasons() as $season) {
if (!$season) {
$this->log('to_html: "empty season', 'warn');
}
$str .= $season->to_html($parent);
}
$w->writeRaw($str);
$w->endElement();
$w->endElement();
return $w->flush();
}
/**
* Write an element with namespace if used
*
* @param \XMLWriter $xmlWriter XML writer resource
* @param string $prefix Namespace prefix if any
* @param string $name Element name
* @param string $namespace The uri of the namespace
* @param string $value The element content
*/
protected function writeElement(\XMLWriter $xmlWriter, $prefix, $name, $namespace, $value)
{
$xmlWriter->startElementNS($prefix, $name, $namespace);
if (strpbrk($value, '<>&')) {
$xmlWriter->writeCData($value);
} else {
$xmlWriter->writeRaw($value);
}
$xmlWriter->endElement();
}
public function export($v92ec19ffde05e15769b1bb3ee05ad745)
{
set_time_limit(0);
if (!count($v92ec19ffde05e15769b1bb3ee05ad745)) {
$v8be74552df93e31bbdd6b36ed74bdb6a = new selector('pages');
$v8be74552df93e31bbdd6b36ed74bdb6a->where('hierarchy')->page(0)->childs(0);
$v92ec19ffde05e15769b1bb3ee05ad745 = $v8be74552df93e31bbdd6b36ed74bdb6a->result;
}
if (getRequest('as_file') === '0') {
$ved780287e302ec3b9fd3c5e78771919f = new xmlExporter($this->getSourceName());
$ved780287e302ec3b9fd3c5e78771919f->addBranches($v92ec19ffde05e15769b1bb3ee05ad745);
$result = $ved780287e302ec3b9fd3c5e78771919f->execute();
return $result->saveXML();
}
$v857a5246dff0c3c79e476b004684f6d3 = "./sys-temp/export/";
$vb80bb7740288fda1f201890375a60c8f = getRequest('param0');
$v97fd815a3803a0588876bdd862014fed = $v857a5246dff0c3c79e476b004684f6d3 . $vb80bb7740288fda1f201890375a60c8f . "." . parent::getFileExt();
$v6990a54322d9232390a784c5c9247dd6 = $v857a5246dff0c3c79e476b004684f6d3 . $vb80bb7740288fda1f201890375a60c8f;
if (!is_dir($v6990a54322d9232390a784c5c9247dd6)) {
mkdir($v6990a54322d9232390a784c5c9247dd6, 0777, true);
}
if (file_exists($v97fd815a3803a0588876bdd862014fed) && !file_exists(CURRENT_WORKING_DIR . '/sys-temp/runtime-cache/' . md5($this->getSourceName()))) {
unlink($v97fd815a3803a0588876bdd862014fed);
}
if ($v92ec19ffde05e15769b1bb3ee05ad745) {
$v33030abc929f083da5f6c3f755b46034 = array('./tpls/', './xsltTpls/', './css/', './js/', './usels/', './umaps/', './templates/');
foreach ($v33030abc929f083da5f6c3f755b46034 as $v100664c6e2c0333b19a729f2f3ddb7dd) {
if (is_dir($v100664c6e2c0333b19a729f2f3ddb7dd)) {
$v736007832d2167baaae763fd3a3f3cf1 = new umiDirectory($v100664c6e2c0333b19a729f2f3ddb7dd);
$v45b963397aa40d4a0063e0d85e4fe7a1 = $v736007832d2167baaae763fd3a3f3cf1->getAllFiles(1);
foreach ($v45b963397aa40d4a0063e0d85e4fe7a1 as $vd6fe1d0be6347b8ef2427fa629c04485 => $vb068931cc450442b63f5b3d276ea4297) {
$v8c7dd922ad47494fc02c388e12c00eac = new umiFile($vd6fe1d0be6347b8ef2427fa629c04485);
if (!is_dir($v6990a54322d9232390a784c5c9247dd6 . ltrim($v8c7dd922ad47494fc02c388e12c00eac->getDirName(), '.'))) {
mkdir($v6990a54322d9232390a784c5c9247dd6 . ltrim($v8c7dd922ad47494fc02c388e12c00eac->getDirName(), '.'), 0777, true);
}
copy($v8c7dd922ad47494fc02c388e12c00eac->getFilePath(), $v6990a54322d9232390a784c5c9247dd6 . $v8c7dd922ad47494fc02c388e12c00eac->getFilePath(true));
}
}
}
}
$v71b70dd1e455c477220693d84ccd5682 = $v97fd815a3803a0588876bdd862014fed . '.tmp';
$v480d1b61a0432d1319f7504a3d7318dd = (int) mainConfiguration::getInstance()->get("modules", "exchange.export.limit");
if ($v480d1b61a0432d1319f7504a3d7318dd <= 0) {
$v480d1b61a0432d1319f7504a3d7318dd = 25;
}
$ved780287e302ec3b9fd3c5e78771919f = new xmlExporter($this->getSourceName(), $v480d1b61a0432d1319f7504a3d7318dd);
$ved780287e302ec3b9fd3c5e78771919f->addBranches($v92ec19ffde05e15769b1bb3ee05ad745);
$vdd988cfd769c9f7fbd795a0f5da8e751 = $ved780287e302ec3b9fd3c5e78771919f->execute();
if (file_exists($v97fd815a3803a0588876bdd862014fed)) {
$v1de9b0a30075ae8c303eb420c103c320 = new XMLReader();
$va82feee3cc1af8bcabda979e8775ef0f = new XMLWriter();
$v1de9b0a30075ae8c303eb420c103c320->open($v97fd815a3803a0588876bdd862014fed);
$va82feee3cc1af8bcabda979e8775ef0f->openURI($v71b70dd1e455c477220693d84ccd5682);
$va82feee3cc1af8bcabda979e8775ef0f->startDocument('1.0', 'utf-8');
$va82feee3cc1af8bcabda979e8775ef0f->startElement('umidump');
$va82feee3cc1af8bcabda979e8775ef0f->writeAttribute('version', '2.0');
$va82feee3cc1af8bcabda979e8775ef0f->writeAttribute('xmlns:xlink', 'http://www.w3.org/TR/xlink');
$v7aa28ed115707345d0274032757e8991 = $v1de9b0a30075ae8c303eb420c103c320->read();
while ($v7aa28ed115707345d0274032757e8991) {
if ($v1de9b0a30075ae8c303eb420c103c320->nodeType == XMLReader::ELEMENT) {
$ve24455211a964330063a18670d943835 = $v1de9b0a30075ae8c303eb420c103c320->name;
if ($ve24455211a964330063a18670d943835 != 'umidump') {
$va82feee3cc1af8bcabda979e8775ef0f->startElement($ve24455211a964330063a18670d943835);
if ($ve24455211a964330063a18670d943835 != 'meta') {
if (!$v1de9b0a30075ae8c303eb420c103c320->isEmptyElement) {
$v7852ddca47412c0d947ebf27eb83ed3a = $v1de9b0a30075ae8c303eb420c103c320->read();
while ($v7852ddca47412c0d947ebf27eb83ed3a) {
if ($v1de9b0a30075ae8c303eb420c103c320->nodeType == XMLReader::ELEMENT) {
$vcf7f5c76225a101e6320a96c02f92fc1 = $v1de9b0a30075ae8c303eb420c103c320->name;
$va82feee3cc1af8bcabda979e8775ef0f->writeRaw($v1de9b0a30075ae8c303eb420c103c320->readOuterXML());
$v7852ddca47412c0d947ebf27eb83ed3a = $v1de9b0a30075ae8c303eb420c103c320->next();
} elseif ($v1de9b0a30075ae8c303eb420c103c320->nodeType == XMLReader::END_ELEMENT && $v1de9b0a30075ae8c303eb420c103c320->name == $ve24455211a964330063a18670d943835) {
$v7852ddca47412c0d947ebf27eb83ed3a = false;
} else {
$v7852ddca47412c0d947ebf27eb83ed3a = $v1de9b0a30075ae8c303eb420c103c320->next();
}
}
}
if ($vdd988cfd769c9f7fbd795a0f5da8e751->getElementsByTagName($ve24455211a964330063a18670d943835)->item(0)->hasChildNodes()) {
$v268184c12df027f536154d099d497b31 = $vdd988cfd769c9f7fbd795a0f5da8e751->getElementsByTagName($ve24455211a964330063a18670d943835)->item(0)->childNodes;
foreach ($v268184c12df027f536154d099d497b31 as $v1b7d5726533ab525a8760351e9b5e415) {
$va5e171f642af8e3bd24c50cdc4d66fe3 = new DOMDocument();
$va5e171f642af8e3bd24c50cdc4d66fe3->formatOutput = true;
$v36c4536996ca5615dcf9911f068786dc = $va5e171f642af8e3bd24c50cdc4d66fe3->importNode($v1b7d5726533ab525a8760351e9b5e415, true);
$va5e171f642af8e3bd24c50cdc4d66fe3->appendChild($v36c4536996ca5615dcf9911f068786dc);
$va82feee3cc1af8bcabda979e8775ef0f->writeRaw($va5e171f642af8e3bd24c50cdc4d66fe3->saveXML($v36c4536996ca5615dcf9911f068786dc, LIBXML_NOXMLDECL));
}
}
} elseif ($ve24455211a964330063a18670d943835 == 'meta') {
$va82feee3cc1af8bcabda979e8775ef0f->writeRaw($v1de9b0a30075ae8c303eb420c103c320->readInnerXML());
$v92ec19ffde05e15769b1bb3ee05ad745 = $vdd988cfd769c9f7fbd795a0f5da8e751->getElementsByTagName('branches');
if ($v92ec19ffde05e15769b1bb3ee05ad745->item(0)) {
$va82feee3cc1af8bcabda979e8775ef0f->writeRaw($vdd988cfd769c9f7fbd795a0f5da8e751->saveXML($v92ec19ffde05e15769b1bb3ee05ad745->item(0), LIBXML_NOXMLDECL));
}
}
$va82feee3cc1af8bcabda979e8775ef0f->fullEndElement();
$v7aa28ed115707345d0274032757e8991 = $v1de9b0a30075ae8c303eb420c103c320->next();
continue;
}
}
$v7aa28ed115707345d0274032757e8991 = $v1de9b0a30075ae8c303eb420c103c320->read();
}
$va82feee3cc1af8bcabda979e8775ef0f->fullEndElement();
$v1de9b0a30075ae8c303eb420c103c320->close();
$va82feee3cc1af8bcabda979e8775ef0f->endDocument();
$va82feee3cc1af8bcabda979e8775ef0f->flush();
unlink($v97fd815a3803a0588876bdd862014fed);
rename($v71b70dd1e455c477220693d84ccd5682, $v97fd815a3803a0588876bdd862014fed);
} else {
file_put_contents($v97fd815a3803a0588876bdd862014fed, $vdd988cfd769c9f7fbd795a0f5da8e751->saveXML());
}
$this->completed = $ved780287e302ec3b9fd3c5e78771919f->isCompleted();
return false;
}
/**
* @param bool $root
* @return string
*/
public function pack($root = false)
{
$writer = new XMLWriter();
$writer->openMemory();
if ($root) {
$writer->startDocument();
}
$writer->startElement('order_info');
if (isset($this->headerInfo)) {
$writer->writeRaw($this->headerInfo->pack());
}
if (isset($this->poInfo)) {
$writer->writeRaw($this->poInfo->pack());
}
if (isset($this->order)) {
$writer->writeRaw($this->order->pack());
}
if (isset($this->printCustomerId)) {
$writer->writeElement('print_customer_id', $this->printCustomerId);
}
$writer->endElement();
return $writer->outputMemory();
}
/**
* @return string
*/
private function packPrintAssets()
{
$writer = new XMLWriter();
$writer->openMemory();
$writer->startElement('print_assets');
foreach ($this->printAssets as $printAsset) {
$writer->writeRaw($printAsset->pack());
}
$writer->endElement();
return $writer->outputMemory();
}
public static function Encode($requestObject)
{
$soap = "";
try {
$writer = new XMLWriter();
$writer->openMemory();
$writer->startDocument();
$writer->setIndent(4);
$writer->startElement("soap:Envelope");
$writer->writeAttribute("xmlns:xsi", "http://www.w3.org/2001/XMLSchema-instance");
$writer->writeAttribute("xmlns:xsd", "http://www.w3.org/2001/XMLSchema");
$writer->writeAttribute("xmlns:soap", "http://schemas.xmlsoap.org/soap/envelope/");
$writer->startElement("soap:Body");
$options = array(XML_SERIALIZER_OPTION_INDENT => ' ', XML_SERIALIZER_OPTION_LINEBREAKS => "\n", XML_SERIALIZER_OPTION_DEFAULT_TAG => '', XML_SERIALIZER_OPTION_TYPEHINTS => false, XML_SERIALIZER_OPTION_IGNORE_NULL => true, XML_SERIALIZER_OPTION_CLASSNAME_AS_TAGNAME => true);
$serializer = new XML_Serializer($options);
$result = $serializer->serialize($requestObject);
if ($result === true) {
$xml = $serializer->getSerializedData();
$xml = str_replace('<>', '', $xml);
$xml = str_replace('</>', '', $xml);
}
$writer->writeRaw($xml);
$writer->endElement();
$writer->endElement();
$writer->endDocument();
$soap = $writer->flush();
$soap = str_replace("<?xml version=\"1.0\"?>", "", $soap);
} catch (Exception $ex) {
throw new Exception("Error occurred while Soap encoding");
}
return $soap;
}
