X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fxml-functions.php;h=0228d8f528cd5afe3af34844c55ae4a368080f39;hp=3fc94edf0630eb861796ff4483fbfd128a7ab7ca;hb=5eb7669649ebf60e74a83df70ad4f357d656b204;hpb=3082135522e6e32a26061fd2363ddb5354a1272a

diff --git a/inc/xml-functions.php b/inc/xml-functions.php
index 3fc94edf06..0228d8f528 100644
--- a/inc/xml-functions.php
+++ b/inc/xml-functions.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2013 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -61,7 +61,7 @@ function doGenericXmlTemplateCallback ($template, $content = array(), $compileCo
 	initXml();
 
 	// Generate FQFN for with special path
-	$FQFN = sprintf("%stemplates/xml/%s%s.xml",
+	$FQFN = sprintf('%stemplates/xml/%s%s.xml',
 		getPath(),
 		detectExtraTemplatePath('xml', $template),
 		$template
@@ -70,7 +70,7 @@ function doGenericXmlTemplateCallback ($template, $content = array(), $compileCo
 	// Is the file readable?
 	if (!isFileReadable($FQFN)) {
 		// No, use without extra path
-		$FQFN = sprintf("%stemplates/xml/%s.xml",
+		$FQFN = sprintf('%stemplates/xml/%s.xml',
 			getPath(),
 			$template
 		);
@@ -109,7 +109,7 @@ function doGenericXmlTemplateCallback ($template, $content = array(), $compileCo
 		addXmlSpecialElements($template);
 
 		// Call the call-back function
-		doCallXmlCallbackFunction($content);
+		doCallXmlCallbackFunction();
 	} else {
 		// Template not found
 		displayMessage('{%message,XML_TEMPLATE_404=' . $template . '%}');
@@ -256,7 +256,7 @@ function isXmlConditionValid ($condition) {
 	$condition = trim(strtolower($condition));
 
 	// Is it valid?
-	return (in_array($condition, array('equals')));
+	return (in_array($condition, array('equals', 'and')));
 }
 
 // Checks if given value is valid/verifyable
@@ -285,20 +285,38 @@ function convertXmlContion ($condition) {
 	return $GLOBALS['__XML_CONDITIONS'][$condition];
 }
 
+// "Getter" for FROM statement from given columns
+function getSqlXmlFromTable ($tableName) {
+	// Init SQL
+	$sql = ' FROM `{?_MYSQL_PREFIX?}_' . $tableName[0]['value'] . '`';
+
+	// Is alias set?
+	if (!empty($tableName[0]['alias'])) {
+		// Also add it
+		$sql .= ' AS `' . $tableName[0]['alias'] . '`';
+	} // END - if
+
+	// Return SQL
+	return $sql;
+}
+
 // "Getter" for sql part back from given array
 function getSqlPartFromXmlArray ($columns) {
 	// Init SQL
-	$SQL = '';
+	$sql = '';
 
 	// Walk through all entries
 	foreach ($columns as $columnArray) {
+		// Must be an array
+		assert(is_array($columnArray));
+
 		// Init SQL part
 		$sqlPart = '';
 
 		// Is there a table/alias
 		if (!empty($columnArray['table'])) {
 			// Pre-add it
-			$sqlPart .= $columnArray['table'] . '.';
+			$sqlPart .= '`' . $columnArray['table'] . '`.';
 		} // END - if
 
 		// Add column
@@ -311,11 +329,129 @@ function getSqlPartFromXmlArray ($columns) {
 		} // END - if
 
 		// Add finished SQL part to the query
-		$SQL .= $sqlPart . ',';
+		$sql .= $sqlPart . ',';
 	} // END - foreach
 
 	// Return it without last commata
-	return substr($SQL, 0, -1);
+	return substr($sql, 0, -1);
+}
+
+// "Getter" for JOIN statement
+function getSqlXmlJoinedTable ($tableJoinType, $tableJoinName, $joinOnLeftTable, $joinOnCondition, $joinOnRightTable) {
+	// Are all set?
+	assert((isFilledArray($tableJoinType)) && (isFilledArray($tableJoinName)) && (isFilledArray($joinOnLeftTable)) && (isFilledArray($joinOnCondition)) && (isFilledArray($joinOnRightTable)));
+
+	// Init SQL
+	$sql = '';
+
+	// "Walk" through all JOINs
+	foreach ($tableJoinType as $key => $joinType) {
+		// 1) Add JOIN type and table name with alias
+		$sql .= ' ' . $joinType . ' `{?_MYSQL_PREFIX?}_' . $tableJoinName[$key]['name'] . '`';
+
+		// Alias set?
+		if (!empty($tableJoinName[$key]['alias'])) {
+			// Add it
+			$sql .= ' AS `' . $tableJoinName[$key]['alias'] . '`';
+		} // END - if
+
+		// 2) Add left part + condition + right part with aliases
+		// 2/1) ON + left part
+		$sql .= ' ON `' . $joinOnLeftTable[$key]['name'] . '`.`' . $joinOnLeftTable[$key]['column'] . '`';
+		// 2/2) Condition
+		$sql .= $joinOnCondition[$key];
+		// 2/3) right part
+		$sql .= '`' . $joinOnRightTable[$key]['name'] . '`.`' . $joinOnRightTable[$key]['column'] . '`';
+	} // END - foreach
+
+	// Return SQL
+	return $sql;
+}
+
+// "Getter" for WHERE statement from given columns and conditions arrays
+function getSqlXmlWhereConditions ($whereColumns, $conditions) {
+	// Init SQL
+	$sql = '';
+
+	// Are there some conditions?
+	if (isFilledArray($whereColumns)) {
+		// Then add these as well
+		if (count($whereColumns) == 1) {
+			// One entry found
+			$sql .= ' WHERE ';
+
+			// Table/alias included?
+			if (!empty($whereColumns[0]['table'])) {
+				// Add it as well
+				$sql .= $whereColumns[0]['table'] . '.';
+			} // END - if
+
+			// Add the rest
+			$sql .= '`' . $whereColumns[0]['column'] . '`' . $whereColumns[0]['condition'] . chr(39) . $whereColumns[0]['look_for'] . chr(39);
+		} elseif ((count($whereColumns > 1)) && (isFilledArray($conditions))) {
+			// More than one "WHERE" + condition found
+			foreach ($whereColumns as $idx => $columnArray) {
+				// Default is WHERE
+				$condition = ' WHERE ';
+
+				// Is the condition element there?
+				if (isset($conditions[$columnArray['column']])) {
+					// Assume the condition
+					$condition = ' ' . $conditions[$columnArray['column']] . ' ';
+				} // END - if
+
+				// Add to SQL query
+				$sql .= $condition;
+
+				// Table/alias included?
+				if (!empty($whereColumns[$idx]['table'])) {
+					// Add it as well
+					$sql .= $whereColumns[$idx]['table'] . '.';
+				} // END - if
+
+				// Add the rest
+				$sql .= '`' . $whereColumns[$idx]['column'] . '`' . $whereColumns[$idx]['condition'] . chr(39) . convertDollarDataToGetElement($whereColumns[$idx]['look_for']) . chr(39);
+			} // END - foreach
+		} else {
+			// Did not set $conditions
+			reportBug(__FUNCTION__, __LINE__, 'Supplied more than "whereColumns" entries but no conditions! Please fix your XML template.');
+		}
+	} // END - if
+
+	// Return SQL
+	return $sql;
+}
+
+// "Getter" for ORDER BY statement from given columns
+function getSqlXmlOrderBy ($orderByColumns) {
+	// Init SQL
+	$sql = '';
+
+	// Are there entries from orderByColumns to add?
+	if (isFilledArray($orderByColumns)) {
+		// Add them as well
+		$sql .= ' ORDER BY ';
+		foreach ($orderByColumns as $orderByColumn => $array) {
+			// Get keys (table/alias) and values (sorting itself)
+			$table   = trim(implode('', array_keys($array)));
+			$sorting = trim(implode('', array_values($array)));
+
+			// table/alias can be omitted
+			if (!empty($table)) {
+				// table/alias is given
+				$sql .= '`' . $table . '`.';
+			} // END - if
+
+			// Add order-by column
+			$sql .= '`' . $orderByColumn . '` ' . $sorting . ',';
+		} // END - foreach
+
+		// Remove last column
+		$sql = substr($sql, 0, -1);
+	} // END - if
+
+	// Return SQL
+	return $sql;
 }
 
 // Searches in given XML array for value and returns the parent index