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

Timestamp:

May 17, 2010, 7:46:39 PM (14 years ago)

Author:

grum

Message:

Fix some bugs on the request builder and improve results display

File:

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

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

@@ -366 +366 @@
     if($clearAll)
     {
-      $sql="DELETE FROM ".$this->tables['result_cache'];
+      $sql="DELETE FROM ".self::$tables['result_cache'];
     }
     else
     {
-      $sql="DELETE FROM ".$this->tables['result_cache']." pgrc, ".$this->tables['request']." pgr
-            WHERE pgrc.id = pgr.id
-              AND pgr.date < '".date('Y-m-d H:i:s', strtotime("-2 hour"))."'";
+      $sql="DELETE pgrc FROM ".self::$tables['result_cache']." pgrc
+              LEFT JOIN ".self::$tables['request']." pgr
+                ON pgrc.id = pgr.id
+              WHERE pgr.date < '".date('Y-m-d H:i:s', strtotime("-2 hour"))."'";
     }
     pwg_query($sql);
@@ -386 +387 @@
   {
     global $user;
+
+    self::clearCache();
 
     $registeredPlugin=self::getRegistered();
@@ -428 +431 @@
     {
       $pluginNeeded[$val['owner']][$key]=$_REQUEST['extraData'][$key]['param'];
-      $pluginList[]=$val['owner'];
+      $pluginList[$val['owner']]=$val['owner'];
     }
 
@@ -512 +515 @@
       self::updateRequest($requestNumber, $numberItems, 0, implode(',', $pluginList));
 
+
       return("$requestNumber;".$numberItems);
     }
 
-    self::clearCache();
-
-    return($sql);
+    return("0;0");
   }
 
@@ -538 +540 @@
     }
 
-    $limitFrom=$numPerPage*($pageNumber-1)+1;
-    $limitTo=$numPerPage*$pageNumber;
+    $limitFrom=$numPerPage*($pageNumber-1);
 
     $pluginNeeded=explode(',', $request['connected_plugin']);
@@ -554 +555 @@
         'RB_PIT' => "pit.id AS imageId, pit.name AS imageName, pit.path AS imagePath", // from the piwigo's image table
         'RB_PIC' => "GROUP_CONCAT(pic.category_id SEPARATOR ',') AS imageCategoriesId",     // from the piwigo's image_category table
-        'RB_PCT' => "GROUP_CONCAT(pct.name SEPARATOR '#sep#') AS imageCategoriesNames",   //from the piwigo's categories table
+        'RB_PCT' => "GROUP_CONCAT(CASE WHEN pct.name IS NULL THEN '' ELSE pct.name END SEPARATOR '#sep#') AS imageCategoriesNames,
+                     GROUP_CONCAT(CASE WHEN pct.permalink IS NULL THEN '' ELSE pct.permalink END SEPARATOR '#sep#') AS imageCategoriesPLink,
+                     GROUP_CONCAT(CASE WHEN pct.dir IS NULL THEN 'V' ELSE 'P' END) AS imageCategoriesDir",   //from the piwigo's categories table
       ),
       'FROM' => Array(
@@ -635 +638 @@
         .' GROUP BY '.$build['GROUPBY']
         .' ORDER BY pit.id '
-        .' LIMIT '.$limitFrom.', '.$limitTo;
+        .' LIMIT '.$limitFrom.', '.$numPerPage;
 
     $result=pwg_query($sql);
@@ -647 +650 @@
         $datas['imagePath']=$row['imagePath'];
         $datas['imageName']=$row['imageName'];
+
         $datas['imageCategoriesId']=explode(',', $row['imageCategoriesId']);
         $datas['imageCategoriesNames']=explode('#sep#', $row['imageCategoriesNames']);
+        $datas['imageCategoriesPLink']=explode('#sep#', $row['imageCategoriesPLink']);
+        $datas['imageCategoriesDir']=explode(',', $row['imageCategoriesDir']);
+
+
+        $datas['imageCategories']=Array();
+        for($i=0;$i<count($datas['imageCategoriesId']);$i++)
+        {
+          $datas['imageCategories'][]=array(
+            'id' => $datas['imageCategoriesId'][$i],
+            'name' => $datas['imageCategoriesNames'][$i],
+            'dirType' => $datas['imageCategoriesDir'][$i],
+            'pLinks' => $datas['imageCategoriesPLink'][$i],
+            'link'=> make_index_url(
+                              array(
+                                'category' => array(
+                                  'id' => $datas['imageCategoriesId'][$i],
+                                  'name' => $datas['imageCategoriesNames'][$i],
+                                  'permalink' => $datas['imageCategoriesPLink'][$i])
+                              )
+                            )
+          );
+        }
 
         /* affect datas for each plugin