Changeset 28707

Timestamp:

Jun 16, 2014, 3:53:16 PM (10 years ago)

Author:

plg

Message:

feature 3091: search.php (advanced search), display a list of known authors instead of a text field.

Location:

trunk

Files:

• search.php (modified) (2 diffs)
• themes/default/template/search.tpl (modified) (2 diffs)
• themes/default/theme.css (modified) (1 diff)

trunk/search.php

@@ -84 +84 @@
   }
 
-  if ($_POST['search_author'])
-  {
+  if (isset($_POST['authors']) and is_array($_POST['authors']) and count($_POST['authors']) > 0)
+  {
+    $authors = array();
+
+    foreach ($_POST['authors'] as $author)
+    {
+      $authors[] = strip_tags($author);
+    }
+    
     $search['fields']['author'] = array(
-      'words' => preg_split(
-        '/\s+/',
-        strip_tags($_POST['search_author'])
-        ),
+      'words' => $authors,
       'mode' => 'OR',
       );
@@ -210 +214 @@
     );
 }
+
+// authors
+$query = '
+SELECT
+    author,
+    COUNT(*) AS counter
+  FROM '.IMAGES_TABLE.' AS i
+    JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON ic.image_id = i.id
+  '.get_sql_condition_FandF(
+    array(
+      'forbidden_categories' => 'category_id',
+      'visible_categories' => 'category_id',
+      'visible_images' => 'ic.image_id'
+      ),
+    ' WHERE '
+    ).'
+    AND author IS NOT NULL
+  GROUP BY author
+  ORDER BY author
+;';
+$authors = query2array($query);
+
+$template->assign('AUTHORS', $authors);
 
 //------------------------------------------------------------- categories form

trunk/themes/default/template/search.tpl

@@ -3 +3 @@
 {include file='include/resize.inc.tpl'}
 *}
+
+{combine_script id='jquery.selectize' load='footer' path='themes/default/js/plugins/selectize.min.js'}
+{combine_css id='jquery.selectize' path="themes/default/js/plugins/selectize.dark.css"}
+
+{footer_script}
+jQuery(document).ready(function() {
+  jQuery("#authors").selectize({
+    plugins: ['remove_button']
+  });
+});
+{/footer_script}
 
 {if isset($MENUBAR)}{$MENUBAR}{/if}
@@ -34 +45 @@
   </ul>
   <label>{'Search for Author'|@translate}
-    <input type="text" name="search_author" size="35">
+    <select id="authors" placeholder="{'Type in a search term'|translate}" name="authors[]" multiple style="width:500px;">
+{foreach from=$AUTHORS item=author}
+      <option value="{$author.author|strip_tags:false|escape:html}">{$author.author|strip_tags:false} ({'%d photos'|translate:$author.counter})</option>
+{/foreach}
+    </select>
   </label>
 </fieldset>

trunk/themes/default/theme.css

@@ -508 +508 @@
         padding: 1em;
         margin: 1em;
-        overflow: hidden; /* <- makes Opera happy */
 }