Algo-Web / POData

services/NorthWind/NorthWindDSExpressionProvider.php

Switch Indentation +91 added lines, -91 removed lines

@@ -294,103 +294,103 @@
     public function onFunctionCallExpression($functionDescription, $params)
     {
         switch ($functionDescription->functionName) {
-        case ODataConstants::STRFUN_COMPARE:
-            return "STRCMP($params[0]; $params[1])";
-            break;
-        case ODataConstants::STRFUN_ENDSWITH:
-          return "(($params[1]) = RIGHT(($params[0]), LEN($params[1])))";
-            break;
-        case ODataConstants::STRFUN_INDEXOF:
-          // In SQLServer the index of string starts from 1, but in OData
-          // the string start with index 0, so the below subtraction of 1
-          return "(CHARINDEX($params[1], $params[0]) - 1)";
-            break;
-        case ODataConstants::STRFUN_REPLACE:
-          return "REPLACE($params[0], $params[1], $params[2])";
-            break;
-        case ODataConstants::STRFUN_STARTSWITH:
-          return "(($params[1]) = LEFT(($params[0]), LEN($params[1])))";
-            break;
-        case ODataConstants::STRFUN_TOLOWER:
-          return "LOWER($params[0])";
-            break;
-        case ODataConstants::STRFUN_TOUPPER:
-          return "UPPER($params[0])";
-            break;
-        case ODataConstants::STRFUN_TRIM:
-          // OData supports trim function
-          // We don't have the same function SQL Server, so use SQL functions LTRIM and RTRIM together
-          // to achieve TRIM functionality.
-          return "RTRIM(LTRIM($params[0]))";
-            break;
-        case ODataConstants::STRFUN_SUBSTRING:
-          if (count($params) == 3) {
-                // 3 Param version of OData substring
-                return "SUBSTRING($params[0], $params[1] + 1, $params[2])";
-            } else {
-                // 2 Params version of OData substring
-            // We don't have the same function for SQL Server, we have only:
+            case ODataConstants::STRFUN_COMPARE:
+                return "STRCMP($params[0]; $params[1])";
+                break;
+            case ODataConstants::STRFUN_ENDSWITH:
+              return "(($params[1]) = RIGHT(($params[0]), LEN($params[1])))";
+                break;
+            case ODataConstants::STRFUN_INDEXOF:
+              // In SQLServer the index of string starts from 1, but in OData
+              // the string start with index 0, so the below subtraction of 1
+              return "(CHARINDEX($params[1], $params[0]) - 1)";
+                break;
+            case ODataConstants::STRFUN_REPLACE:
+              return "REPLACE($params[0], $params[1], $params[2])";
+                break;
+            case ODataConstants::STRFUN_STARTSWITH:
+              return "(($params[1]) = LEFT(($params[0]), LEN($params[1])))";
+                break;
+            case ODataConstants::STRFUN_TOLOWER:
+              return "LOWER($params[0])";
+                break;
+            case ODataConstants::STRFUN_TOUPPER:
+              return "UPPER($params[0])";
+                break;
+            case ODataConstants::STRFUN_TRIM:
+              // OData supports trim function
+              // We don't have the same function SQL Server, so use SQL functions LTRIM and RTRIM together
+              // to achieve TRIM functionality.
+              return "RTRIM(LTRIM($params[0]))";
+                break;
+            case ODataConstants::STRFUN_SUBSTRING:
+              if (count($params) == 3) {
+                    // 3 Param version of OData substring
+                    return "SUBSTRING($params[0], $params[1] + 1, $params[2])";
+                } else {
+                    // 2 Params version of OData substring
+                // We don't have the same function for SQL Server, we have only:
 
-            // SUBSTRING ( value_expression , start_expression , length_expression )
-            // http://msdn.microsoft.com/en-us/library/ms187748.aspx
+                // SUBSTRING ( value_expression , start_expression , length_expression )
+                // http://msdn.microsoft.com/en-us/library/ms187748.aspx
 
-            // If the sum of start_expression and length_expression is greater than the number of characters
-            // in value_expression, the whole value expression beginning at start_expression is returned
-            // In OData substring function the index start from 0, in SQL Server its from 1
-            return "SUBSTRING($params[0], $params[1] + 1, LEN($params[0]))";
-            }
-            break;
-        case ODataConstants::STRFUN_SUBSTRINGOF:
-          return "(CHARINDEX($params[0], $params[1]) != 0)";
-            break;
-        case ODataConstants::STRFUN_CONCAT:
-            return "$params[0] + $params[1]";
-            break;
-        case ODataConstants::STRFUN_LENGTH:
-            return "LEN($params[0])";
-            break;
-        case ODataConstants::GUIDFUN_EQUAL:
-            return "($params[0] = $params[1])";
-            break;
-        case ODataConstants::DATETIME_COMPARE:
-            return "DATETIMECMP($params[0]; $params[1])";
-            break;
-        case ODataConstants::DATETIME_YEAR:
-            return "YEAR($params[0])";
-            break;
-        case ODataConstants::DATETIME_MONTH:
-            return "MONTH($params[0])";
-            break;
-        case ODataConstants::DATETIME_DAY:
-            return "DAY($params[0])";
-            break;
-        case ODataConstants::DATETIME_HOUR:
-            return "DATENAME(HOUR, $params[0])";
-            break;
-        case ODataConstants::DATETIME_MINUTE:
-            return "DATENAME(MINUTE, $params[0])";
-            break;
-        case ODataConstants::DATETIME_SECOND:
-            return "DATENAME(SECOND, $params[0])";
-            break;
-        case ODataConstants::MATHFUN_ROUND:
-            return "ROUND($params[0], $this->_default_round)";
-            break;
-        case ODataConstants::MATHFUN_CEILING:
-            return "CEILING($params[0])";
-            break;
-        case ODataConstants::MATHFUN_FLOOR:
-            return "FLOOR($params[0])";
-            break;
-        case ODataConstants::BINFUL_EQUAL:
-            return "($params[0] = $params[1])";
-            break;
+                // If the sum of start_expression and length_expression is greater than the number of characters
+                // in value_expression, the whole value expression beginning at start_expression is returned
+                // In OData substring function the index start from 0, in SQL Server its from 1
+                return "SUBSTRING($params[0], $params[1] + 1, LEN($params[0]))";
+                }
+                break;
+            case ODataConstants::STRFUN_SUBSTRINGOF:
+              return "(CHARINDEX($params[0], $params[1]) != 0)";
+                break;
+            case ODataConstants::STRFUN_CONCAT:
+                return "$params[0] + $params[1]";
+                break;
+            case ODataConstants::STRFUN_LENGTH:
+                return "LEN($params[0])";
+                break;
+            case ODataConstants::GUIDFUN_EQUAL:
+                return "($params[0] = $params[1])";
+                break;
+            case ODataConstants::DATETIME_COMPARE:
+                return "DATETIMECMP($params[0]; $params[1])";
+                break;
+            case ODataConstants::DATETIME_YEAR:
+                return "YEAR($params[0])";
+                break;
+            case ODataConstants::DATETIME_MONTH:
+                return "MONTH($params[0])";
+                break;
+            case ODataConstants::DATETIME_DAY:
+                return "DAY($params[0])";
+                break;
+            case ODataConstants::DATETIME_HOUR:
+                return "DATENAME(HOUR, $params[0])";
+                break;
+            case ODataConstants::DATETIME_MINUTE:
+                return "DATENAME(MINUTE, $params[0])";
+                break;
+            case ODataConstants::DATETIME_SECOND:
+                return "DATENAME(SECOND, $params[0])";
+                break;
+            case ODataConstants::MATHFUN_ROUND:
+                return "ROUND($params[0], $this->_default_round)";
+                break;
+            case ODataConstants::MATHFUN_CEILING:
+                return "CEILING($params[0])";
+                break;
+            case ODataConstants::MATHFUN_FLOOR:
+                return "FLOOR($params[0])";
+                break;
+            case ODataConstants::BINFUL_EQUAL:
+                return "($params[0] = $params[1])";
+                break;
             case 'is_null':
             return "is_null($params[0])";
             break;
 
-        default:
-            throw new \InvalidArgumentException('onFunctionCallExpression');
+            default:
+                throw new \InvalidArgumentException('onFunctionCallExpression');
         }
     }
 

services/WordPress/WordPressDSExpressionProvider.php

Spacing +6 added lines, -6 removed lines

@@ -285,22 +285,22 @@
                 return "DATETIMECMP($params[0]; $params[1])";
                 break;
             case ODataConstants::DATETIME_YEAR:
-                return 'EXTRACT(YEAR from '.$params[0].')';
+                return 'EXTRACT(YEAR from ' . $params[0] . ')';
                 break;
             case ODataConstants::DATETIME_MONTH:
-                return 'EXTRACT(MONTH from '.$params[0].')';
+                return 'EXTRACT(MONTH from ' . $params[0] . ')';
                 break;
             case ODataConstants::DATETIME_DAY:
-                return 'EXTRACT(DAY from '.$params[0].')';
+                return 'EXTRACT(DAY from ' . $params[0] . ')';
                 break;
             case ODataConstants::DATETIME_HOUR:
-                return 'EXTRACT(HOUR from '.$params[0].')';
+                return 'EXTRACT(HOUR from ' . $params[0] . ')';
                 break;
             case ODataConstants::DATETIME_MINUTE:
-                return 'EXTRACT(MINUTE from '.$params[0].')';
+                return 'EXTRACT(MINUTE from ' . $params[0] . ')';
                 break;
             case ODataConstants::DATETIME_SECOND:
-                return 'EXTRACT(SECOND from '.$params[0].')';
+                return 'EXTRACT(SECOND from ' . $params[0] . ')';
                 break;
             case ODataConstants::MATHFUN_ROUND:
                 return "ROUND($params[0])";

services/WordPress/WordPressQueryProvider.php

Spacing +24 added lines, -24 removed lines

@@ -189,7 +189,7 @@ 
                 $query = 'SELECT * FROM `wp_posts` WHERE'
                         ." wp_posts.post_type = 'post'"
                         ." AND wp_posts.post_status = 'publish'"
-                        .' AND wp_posts.ID = '.$namedKeyValues['PostID'][0];
+                        .' AND wp_posts.ID = ' . $namedKeyValues['PostID'][0];
                 $stmt = mysql_query($query);
 
                 //If resource not found return null to the library
@@ -205,7 +205,7 @@ 
                         .' FROM `wp_terms` AS t INNER JOIN `wp_term_taxonomy` as tt'
                         .' ON tt.term_id = t.term_id'
                         ." WHERE tt.taxonomy = 'post_tag'"
-                        .' AND t.term_id = '.$namedKeyValues['TagID'][0];
+                        .' AND t.term_id = ' . $namedKeyValues['TagID'][0];
                 $stmt = mysql_query($query);
 
                 //If resource not found return null to the library
@@ -221,7 +221,7 @@ 
                         .' FROM `wp_terms` AS t INNER JOIN `wp_term_taxonomy` as tt'
                         .' ON tt.term_id = t.term_id'
                         ." WHERE tt.taxonomy = 'category'"
-                        .' AND t.term_id = '.$namedKeyValues['CategoryID'][0];
+                        .' AND t.term_id = ' . $namedKeyValues['CategoryID'][0];
                 $stmt = mysql_query($query);
 
                 //If resource not found return null to the library
@@ -235,7 +235,7 @@ 
             case 'Comments':
                 $query = 'SELECT * FROM `wp_comments`'
                         .' WHERE comment_approved = 1'
-                        .' AND comment_ID = '.$namedKeyValues['CommentID'][0];
+                        .' AND comment_ID = ' . $namedKeyValues['CommentID'][0];
                 $stmt = mysql_query($query);
 
                 //If resource not found return null to the library
@@ -247,7 +247,7 @@ 
                 $result = $this->_serializeComment($data);
                 break;
             case 'Users':
-                $query = 'SELECT * FROM `wp_users` WHERE ID = '.$namedKeyValues['UserID'][0];
+                $query = 'SELECT * FROM `wp_users` WHERE ID = ' . $namedKeyValues['UserID'][0];
                 $stmt = mysql_query($query);
 
                 //If resource not found return null to the library
@@ -344,7 +344,7 @@ 
 
                     $result = $this->_serializeComments($stmt);
                 } else {
-                    die('Post does not have navigation porperty with name: '.$navigationPropName);
+                    die('Post does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
 
@@ -369,7 +369,7 @@ 
 
                     $result = $this->_serializePosts($stmt);
                 } else {
-                    die('Tag does not have navigation porperty with name: '.$navigationPropName);
+                    die('Tag does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
 
@@ -394,12 +394,12 @@ 
 
                     $result = $this->_serializePosts($stmt);
                 } else {
-                    die('Category does not have navigation porperty with name: '.$navigationPropName);
+                    die('Category does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
 
             case $srcClass == 'Comment':
-                die('Comment does not have navigation porperty with name: '.$navigationPropName);
+                die('Comment does not have navigation porperty with name: ' . $navigationPropName);
                 break;
 
             case $srcClass == 'User':
@@ -431,7 +431,7 @@ 
 
                     $result = $this->_serializeComments($stmt);
                 } else {
-                    die('User does not have navigation porperty with name: '.$navigationPropName);
+                    die('User does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
         }
@@ -484,7 +484,7 @@ 
                             .' ON tr.term_taxonomy_id = tt.term_taxonomy_id'
                             ." WHERE tt.taxonomy IN ('post_tag')"
                             ." AND tr.object_id IN ($sourceEntityInstance->PostID)"
-                            .' AND tt.term_id = '.$namedKeyValues['TagID'][0];
+                            .' AND tt.term_id = ' . $namedKeyValues['TagID'][0];
                     $stmt = mysql_query($query);
                     $result = $this->_serializeTags($stmt);
                 } elseif ($navigationPropName == 'Categories') {
@@ -496,18 +496,18 @@ 
                             .' ON tr.term_taxonomy_id = tt.term_taxonomy_id'
                             ." WHERE tt.taxonomy IN ('category')"
                             ." AND tr.object_id IN ($sourceEntityInstance->PostID)"
-                            .' AND tt.term_id = '.$namedKeyValues['CategoryID'][0];
+                            .' AND tt.term_id = ' . $namedKeyValues['CategoryID'][0];
                     $stmt = mysql_query($query);
                     $result = $this->_serializeCategories($stmt);
                 } elseif ($navigationPropName == 'Comments') {
                     $query = 'SELECT * FROM `wp_comments`'
                             .' WHERE comment_approved = 1'
                             ." AND comment_post_ID = $sourceEntityInstance->PostID"
-                            .' AND comment_ID = '.$namedKeyValues['CommentID'][0];
+                            .' AND comment_ID = ' . $namedKeyValues['CommentID'][0];
                     $stmt = mysql_query($query);
                     $result = $this->_serializeComments($stmt);
                 } else {
-                    die('Post does not have navigation porperty with name: '.$navigationPropName);
+                    die('Post does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
 
@@ -522,11 +522,11 @@ 
                                 ." WHERE tt.term_id = $sourceEntityInstance->TagID"
                                 ." AND p.post_type = 'post'"
                                 ." AND p.post_status = 'publish'"
-                                .' AND p.ID = '.$namedKeyValues['PostID'][0];
+                                .' AND p.ID = ' . $namedKeyValues['PostID'][0];
                     $stmt = mysql_query($query);
                     $result = $this->_serializePosts($stmt);
                 } else {
-                    die('Tag does not have navigation porperty with name: '.$navigationPropName);
+                    die('Tag does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
 
@@ -541,16 +541,16 @@ 
                                 ." WHERE tt.term_id = $sourceEntityInstance->CategoryID"
                                 ." AND p.post_type = 'post'"
                                 ." AND p.post_status = 'publish'"
-                                .' AND p.ID = '.$namedKeyValues['PostID'][0];
+                                .' AND p.ID = ' . $namedKeyValues['PostID'][0];
                     $stmt = mysql_query($query);
                     $result = $this->_serializePosts($stmt);
                 } else {
-                    die('Category does not have navigation porperty with name: '.$navigationPropName);
+                    die('Category does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
 
             case $srcClass == 'Comment':
-                die('Comment does not have navigation porperty with name: '.$navigationPropName);
+                die('Comment does not have navigation porperty with name: ' . $navigationPropName);
                 break;
 
             case $srcClass == 'User':
@@ -559,18 +559,18 @@ 
                             ." wp_posts.post_type = 'post'"
                             ." AND wp_posts.post_status = 'publish'"
                             ." AND wp_posts.post_author = $sourceEntityInstance->UserID"
-                            .' AND wp_posts.ID = '.$namedKeyValues['PostID'][0];
+                            .' AND wp_posts.ID = ' . $namedKeyValues['PostID'][0];
                     $stmt = mysql_query($query);
                     $result = $this->_serializePosts($stmt);
                 } elseif ($navigationPropName == 'Comments') {
                     $query = 'SELECT * FROM `wp_comments`'
                             .' WHERE comment_approved = 1'
                             ." AND wp_comments.user_id = $sourceEntityInstance->UserID"
-                            .' AND wp_comments.comment_ID = '.$namedKeyValues['CommentID'][0];
+                            .' AND wp_comments.comment_ID = ' . $namedKeyValues['CommentID'][0];
                     $stmt = mysql_query($query);
                     $result = $this->_serializeComments($stmt);
                 } else {
-                    die('User does not have navigation porperty with name: '.$navigationPropName);
+                    die('User does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
         }
@@ -616,7 +616,7 @@ 
                         $result = null;
                     }
                 } else {
-                    die('Post does not have navigation porperty with name: '.$navigationPropName);
+                    die('Post does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
 
@@ -651,7 +651,7 @@ 
                     $data = mysql_fetch_assoc($stmt);
                     $result = $this->_serializePost($data);
                 } else {
-                    die('Comment does not have navigation porperty with name: '.$navigationPropName);
+                    die('Comment does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
         }

src/POData/UriProcessor/UriProcessor.php

Spacing +1 added lines, -1 removed lines

@@ -172,7 +172,7 @@
      */
     protected function executePut()
     {
-        return $this->executeBase(function ($uriProcessor, $segment) {
+        return $this->executeBase(function($uriProcessor, $segment) {
             $requestMethod = $uriProcessor->getService()->getOperationContext()->incomingRequest()->getMethod();
             $resourceSet = $segment->getTargetResourceSetWrapper();
             $keyDescriptor = $segment->getKeyDescriptor();

src/POData/UriProcessor/XML2Array.php

Spacing +3 added lines, -3 removed lines

@@ -38,7 +38,7 @@ 
             $xml = self::$xml = $input_xml;
         }
         $array[$xml->documentElement->tagName] = self::convert($xml->documentElement);
-        self::$xml = null;    // clear the xml node in the class for 2nd time use.
+        self::$xml = null; // clear the xml node in the class for 2nd time use.
         return $array;
     }
     /**
@@ -58,7 +58,7 @@ 
                 break;
             case XML_ELEMENT_NODE:
                 // for each child node, call the covert function recursively
-                for ($i=0, $m=$node->childNodes->length; $i<$m; $i++) {
+                for ($i = 0, $m = $node->childNodes->length; $i < $m; $i++) {
                     $child = $node->childNodes->item($i);
                     $v = self::convert($child);
                     if (isset($child->tagName)) {
@@ -78,7 +78,7 @@ 
                 if (is_array($output)) {
                     // if only one node of its kind, assign it directly instead if array($value);
                     foreach ($output as $t => $v) {
-                        if (is_array($v) && count($v)==1) {
+                        if (is_array($v) && count($v) == 1) {
                             $output[$t] = $v[0];
                         }
                     }