Changeset 502 for trunk/include/functions_category.inc.php

Timestamp:

Aug 29, 2004, 6:50:49 PM (20 years ago)

Author:

z0rglub

Message:

search in sub-categories option is available

File:

• trunk/include/functions_category.inc.php (modified) (1 diff)

trunk/include/functions_category.inc.php

@@ -572 +572 @@
         if (isset($search['fields']['cat']))
         {
-          $local_clause = 'category_id IN (';
-          $local_clause.= implode(',',$search['fields']['cat']['words']);
-          $local_clause.= ')';
-          array_push($clauses, $local_clause);
+          if ($search['fields']['cat']['mode'] == 'sub_inc')
+          {
+            // searching all the categories id of sub-categories
+            $search_cat_clauses = array();
+            foreach ($search['fields']['cat']['words'] as $cat_id)
+            {
+              $local_clause = 'uppercats REGEXP \'(^|,)'.$cat_id.'(,|$)\'';
+              array_push($search_cat_clauses, $local_clause);
+            }
+            array_walk($search_cat_clauses,
+                       create_function('&$s', '$s = "(".$s.")";'));
+            
+            $query = '
+SELECT DISTINCT(id) AS id
+  FROM '.CATEGORIES_TABLE.'
+  WHERE '.implode(' OR ', $search_cat_clauses).'
+;';
+            echo '<pre>'.$query.'</pre>';
+            $result = mysql_query($query);
+            $cat_ids = array();
+            while ($row = mysql_fetch_array($result))
+            {
+              array_push($cat_ids, $row['id']);
+            }
+            $local_clause = 'category_id IN (';
+            $local_clause.= implode(',',$cat_ids);
+            $local_clause.= ')';
+            array_push($clauses, $local_clause);
+          }
+          else
+          {
+            $local_clause = 'category_id IN (';
+            $local_clause.= implode(',',$search['fields']['cat']['words']);
+            $local_clause.= ')';
+            array_push($clauses, $local_clause);
+          }
         }