Changeset 7181 for extensions/GrumPluginClasses/classes/GPCRequestBuilder.class.inc.php

Timestamp:

Oct 14, 2010, 4:16:32 PM (14 years ago)

Author:

grum

Message:

Fix bug on the categorySelector (multiselect mode) ; add property 'name'
Fix bug on the requestBuilder (add DISTINCT keyword on request...)

File:

• extensions/GrumPluginClasses/classes/GPCRequestBuilder.class.inc.php (modified) (3 diffs)

extensions/GrumPluginClasses/classes/GPCRequestBuilder.class.inc.php

@@ -721 +721 @@
     $sql="INSERT INTO ".self::$tables['result_cache']." (SELECT DISTINCT $requestNumber, ".$build['SELECT']." $sql)";
 
-//echo $sql;
 
     $returned="0;0";
@@ -1184 +1183 @@
           if($val['mode']=='item')
           {
-            $returnedS.="(SELECT ".call_user_func(Array('RBCallBack'.$val['plugin'], 'getImageId'))." AS imageId
+            $returnedS.="(SELECT DISTINCT ".call_user_func(Array('RBCallBack'.$val['plugin'], 'getImageId'))." AS imageId
                           FROM ".call_user_func(Array('RBCallBack'.$val['plugin'], 'getFrom'))."
                           WHERE ".$val['value'].") t".self::$tGlobalId." ";
@@ -1207 +1206 @@
           if($val['mode']=='item')
           {
-            $returnedS.="SELECT '$requestNumber', t".self::$tGlobalId.".imageId
+            $returnedS.="SELECT DISTINCT '$requestNumber', t".self::$tGlobalId.".imageId
                           FROM (SELECT ".call_user_func(Array('RBCallBack'.$val['plugin'], 'getImageId'))." AS imageId
                                 FROM ".call_user_func(Array('RBCallBack'.$val['plugin'], 'getFrom'))."