source: trunk/search_rules.php @ 28548

Last change on this file since 28548 was 26825, checked in by plg, 11 years ago

bug 3020 and bug 3021 fixed: additionnal checks in search inputs

  • Property svn:eol-style set to LF
File size: 7.3 KB
RevLine 
[1015]1<?php
2// +-----------------------------------------------------------------------+
[8728]3// | Piwigo - a PHP based photo gallery                                    |
[2297]4// +-----------------------------------------------------------------------+
[26461]5// | Copyright(C) 2008-2014 Piwigo Team                  http://piwigo.org |
[2297]6// | Copyright(C) 2003-2008 PhpWebGallery Team    http://phpwebgallery.net |
7// | Copyright(C) 2002-2003 Pierrick LE GALL   http://le-gall.net/pierrick |
8// +-----------------------------------------------------------------------+
9// | This program is free software; you can redistribute it and/or modify  |
10// | it under the terms of the GNU General Public License as published by  |
11// | the Free Software Foundation                                          |
12// |                                                                       |
13// | This program is distributed in the hope that it will be useful, but   |
14// | WITHOUT ANY WARRANTY; without even the implied warranty of            |
15// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU      |
16// | General Public License for more details.                              |
17// |                                                                       |
18// | You should have received a copy of the GNU General Public License     |
19// | along with this program; if not, write to the Free Software           |
20// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
21// | USA.                                                                  |
22// +-----------------------------------------------------------------------+
[1015]23
24/**
25 * returns language value 'included' or 'excluded' depending on boolean
26 * value. This function is useful only to make duplicate code shorter
27 *
28 * @param bool is_included
29 * @return string
30 */
31function inc_exc_str($is_included)
32{
[5310]33  return $is_included ? l10n('included') : l10n('excluded');
[1015]34}
35
36// +-----------------------------------------------------------------------+
37// |                           initialization                              |
38// +-----------------------------------------------------------------------+
39
40define('PHPWG_ROOT_PATH','./');
41include_once( PHPWG_ROOT_PATH.'include/common.inc.php' );
[2325]42check_status(ACCESS_FREE);
[1113]43include_once( PHPWG_ROOT_PATH.'include/functions_search.inc.php' );
[1015]44
45$page['body_id'] = 'thePopuphelpPage';
[2342]46$title = l10n('Piwigo Help');
[7823]47$page['page_banner'] = '';
[2138]48$page['meta_robots']=array('noindex'=>1, 'nofollow'=>1);
[1015]49include(PHPWG_ROOT_PATH.'include/page_header.php');
50
51$template->set_filenames(array('search_rules' => 'search_rules.tpl'));
52
53// +-----------------------------------------------------------------------+
54// |                        Textual rules creation                         |
55// +-----------------------------------------------------------------------+
56
57// Rules are stored in database, serialized in an array. This array must be
58// transformed into a list of textual rules.
59
60$search = get_search_array($_GET['search_id']);
61
[1537]62if (isset($search['q']))
63{
[2223]64  $template->append( 'search_words', $search['q'] );
[1537]65}
66else
67{
[2223]68  $template->assign(
[1537]69    array(
70      'INTRODUCTION'
71        => 'OR' == $search['mode']
72        ? l10n('At least one listed rule must be satisfied.')
73        : l10n('Each listed rule must be satisfied.'),
74      )
75    );
76}
[1015]77
78if (isset($search['fields']['allwords']))
79{
[25005]80  $template->append(
81      'search_words',
82      l10n(
83        'searched words : %s',
[1015]84        join(', ', $search['fields']['allwords']['words'])
85        )
[2223]86      );
[1015]87}
88
[1119]89if (isset($search['fields']['tags']))
90{
[2223]91  $template->assign('SEARCH_TAGS_MODE', $search['fields']['tags']['mode']);
92 
[1119]93  $query = '
94SELECT name
95  FROM '.TAGS_TABLE.'
96  WHERE id IN ('.implode(',', $search['fields']['tags']['words']).')
97;';
[2223]98  $template->assign(
99      'search_tags',
100      array_from_query($query, 'name')
101    );
[1119]102}
103
[1015]104if (isset($search['fields']['author']))
105{
[2223]106  $template->append(
[25005]107      'search_words',
108      l10n(
109        'author(s) : %s',
[26825]110        join(', ', array_map('strip_tags', $search['fields']['author']['words']))
[1015]111        )
[2223]112      );
[1015]113}
114
115if (isset($search['fields']['cat']))
116{
117  if ($search['fields']['cat']['sub_inc'])
118  {
119    // searching all the categories id of sub-categories
120    $cat_ids = get_subcat_ids($search['fields']['cat']['words']);
121  }
122  else
123  {
124    $cat_ids = $search['fields']['cat']['words'];
125  }
126
127  $query = '
128SELECT id, uppercats, global_rank
129  FROM '.CATEGORIES_TABLE.'
130  WHERE id IN ('.
131    implode(',', $cat_ids).
132    ')
133;';
134  $result = pwg_query($query);
135
136  $categories = array();
137  if (!empty($result))
138  {
[4325]139    while ($row = pwg_db_fetch_assoc($result))
[1015]140    {
[25018]141      $categories[] = $row;
[1015]142    }
143  }
144  usort($categories, 'global_rank_compare');
145
146  foreach ($categories as $category)
147  {
[2223]148    $template->append(
149      'search_categories',
150      get_cat_display_name_cache(
[1015]151          $category['uppercats'],
[25425]152          null                      // no url on category names
[1015]153          )
154      );
155  }
156}
157
158foreach (array('date_available', 'date_creation') as $datefield)
159{
160  if ('date_available' == $datefield)
161  {
162    $lang_items = array(
[5311]163      'date'   => l10n('posted on %s'),
164      'period' => l10n('posted between %s (%s) and %s (%s)'),
165      'after'  => l10n('posted after %s (%s)'),
166      'before' => l10n('posted before %s (%s)'),
[1015]167      );
168  }
169  elseif ('date_creation' == $datefield)
170  {
171    $lang_items = array(
[5310]172      'date'   => l10n('created on %s'),
173      'period' => l10n('created between %s (%s) and %s (%s)'),
174      'after'  => l10n('created after %s (%s)'),
175      'before' => l10n('created before %s (%s)'),
[1015]176      );
177  }
178
179  $keys = array(
180    'date'   => $datefield,
181    'after'  => $datefield.'-after',
182    'before' => $datefield.'-before',
183    );
184
185  if (isset($search['fields'][ $keys['date'] ]))
186  {
[2223]187    $template->assign(
188      strtoupper($datefield),
189      sprintf(
[5310]190          $lang_items['date'],
[1015]191          format_date($search['fields'][ $keys['date'] ])
[2223]192          )
[1015]193      );
194  }
195  elseif (isset($search['fields'][ $keys['before'] ])
196          and isset($search['fields'][ $keys['after'] ]))
197  {
[2223]198    $template->assign(
199      strtoupper($datefield),
200      sprintf(
[5310]201          $lang_items['period'],
[1071]202
[1015]203          format_date($search['fields'][ $keys['after'] ]['date']),
204          inc_exc_str($search['fields'][ $keys['after'] ]['inc']),
205
206          format_date($search['fields'][ $keys['before'] ]['date']),
207          inc_exc_str($search['fields'][ $keys['before'] ]['inc'])
[2223]208          )
[1015]209      );
210  }
211  elseif (isset($search['fields'][ $keys['before'] ]))
212  {
[2223]213    $template->assign(
214      strtoupper($datefield),
215      sprintf(
[5310]216          $lang_items['before'],
[1071]217
[1015]218          format_date($search['fields'][ $keys['before'] ]['date']),
219          inc_exc_str($search['fields'][ $keys['before'] ]['inc'])
[2223]220          )
[1015]221      );
222  }
223  elseif (isset($search['fields'][ $keys['after'] ]))
224  {
[2223]225    $template->assign(
226      strtoupper($datefield),
227      sprintf(
[5310]228          $lang_items['after'],
[1071]229
[1015]230          format_date($search['fields'][ $keys['after'] ]['date']),
231          inc_exc_str($search['fields'][ $keys['after'] ]['inc'])
232          )
233      );
234  }
235}
236
237// +-----------------------------------------------------------------------+
238// |                           html code display                           |
239// +-----------------------------------------------------------------------+
240
[2223]241$template->pparse('search_rules');
[1015]242include(PHPWG_ROOT_PATH.'include/page_tail.php');
243?>
Note: See TracBrowser for help on using the repository browser.