Mailer project rwritten:

[mailer.git] / inc / xml-functions.php

diff --git a/inc/xml-functions.php b/inc/xml-functions.php
index 3fc94edf0630eb861796ff4483fbfd128a7ab7ca..9506a93e815489250b42c03d77a53444f54caa2d 100644 (file)
--- a/inc/xml-functions.php
+++ b/inc/xml-functions.php
@@ -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,130 @@ 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((count($tableJoinType) > 0) && (count($tableJoinName) > 0) && (count($joinOnLeftTable) > 0) && (count($joinOnCondition) > 0) && (count($joinOnRightTable) > 0));
+
+       // 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 (count($whereColumns) > 0) {
+               // 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)) && (count($conditions) > 0)) {
+                       // 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
+                               die($sql.'/'.$condition);
+                               $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 (count($orderByColumns) > 0) {
+               // 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