fix: initialize $where
[squirrelmail.git] / src / search.php
CommitLineData
c61bb006 1<?php
245a6892 2
35586184 3/**
a5ee5ac2 4 * search.php
35586184 5 *
15e6162e 6 * Copyright (c) 1999-2002 The SquirrelMail Project Team
35586184 7 * Licensed under the GNU GPL. For full terms see the file COPYING.
8 *
9 * $Id$
10 */
2d367c68 11
35586184 12require_once('../src/validate.php');
13require_once('../functions/imap.php');
14require_once('../functions/imap_search.php');
15require_once('../functions/array.php');
46d38f78 16require_once('../functions/strings.php');
c61bb006 17
e92eab8b 18global $allow_thread_sort;
56e0b3b7 19
23a9084b 20/* here are some functions, could go in imap_search.php
56e0b3b7 21
23a9084b 22 this was here, pretty handy */
29eb5486 23function s_opt( $val, $sel, $tit ) {
24 echo " <option value=\"$val\"";
0d672ac0 25 if ( $sel == $val ) {
bd9bbfef 26 echo ' selected';
99d2a184 27 }
29eb5486 28 echo ">$tit</option>\n";
29}
99d2a184 30
bebf762c 31/* function to get the recent searches and put them in the attributes array */
32function get_recent($username, $data_dir) {
33 $attributes = array();
34 $types = array('search_what', 'search_where', 'search_folder');
56e0b3b7 35 $recent_count = getPref($data_dir, $username, 'search_memory', 0);
56e0b3b7 36 for ($x=1;$x<=$recent_count;$x++) {
bebf762c 37 reset($types);
38 foreach ($types as $key) {
39 $attributes[$key][$x] = getPref($data_dir, $username, $key.$x, "");
40 }
56e0b3b7 41 }
bebf762c 42 return $attributes;
56e0b3b7 43}
44
bebf762c 45/* function to get the saved searches and put them in the saved_attributes array */
46function get_saved($username, $data_dir) {
47 $saved_attributes = array();
48 $types = array('saved_what', 'saved_where', 'saved_folder');
49 foreach ($types as $key) {
50 for ($x=1;;$x++) {
51 $saved_attributes[$key][$x] = getPref($data_dir, $username, $key."$x", "");
52 if ($saved_attributes[$key][$x] == "") {
53 array_pop($saved_attributes[$key]);
54 break;
55 }
56 }
56e0b3b7 57 }
bebf762c 58 return $saved_attributes;
56e0b3b7 59}
60
23a9084b 61/* function to update recent pref arrays */
62function update_recent($what, $where, $mailbox, $username, $data_dir) {
bebf762c 63 $attributes = array();
64 $types = array('search_what', 'search_where', 'search_folder');
65 $input = array($what, $where, $mailbox);
66 $attributes = get_recent( $username, $data_dir);
67 reset($types);
70c4fd84 68 $dupe = 'no';
bebf762c 69 for ($i=1;$i<=count($attributes['search_what']);$i++) {
70 if (isset($attributes['search_what'][$i])) {
71 if ($what == $attributes['search_what'][$i] &&
72 $where == $attributes['search_where'][$i] &&
73 $mailbox == $attributes['search_folder'][$i]) {
74 $dupe = 'yes';
75 }
23a9084b 76 }
77 }
70c4fd84 78 if ($dupe == 'no') {
bebf762c 79 $i = 0;
80 foreach ($types as $key) {
81 array_push ($attributes[$key], $input[$i]);
82 array_shift ($attributes[$key]);
83 $i++;
84 }
85 $recent_count = getPref($data_dir, $username, 'search_memory', 0);
86 $n=0;
87 for ($i=1;$i<=$recent_count;$i++) {
88 reset($types);
89 foreach ($types as $key) {
90 setPref($data_dir, $username, $key.$i, $attributes[$key][$n]);
91 }
92 $n++;
93 }
56e0b3b7 94 }
95}
96
23a9084b 97/* function to forget a recent search */
56e0b3b7 98function forget_recent($forget_index, $username, $data_dir) {
bebf762c 99 $attributes = array();
100 $types = array('search_what', 'search_where', 'search_folder');
101 $attributes = get_recent( $username, $data_dir);
102 reset($types);
103 foreach ($types as $key) {
104 array_splice($attributes[$key], $forget_index, 1);
105 array_unshift($attributes[$key], '');
106 }
107 reset($types);
56e0b3b7 108 $recent_count = getPref($data_dir, $username, 'search_memory', 0);
109 $n=0;
110 for ($i=1;$i<=$recent_count;$i++) {
bebf762c 111 reset($types);
112 foreach ($types as $key) {
113 setPref($data_dir, $username, $key.$i, $attributes[$key][$n]);
114 }
23a9084b 115 $n++;
56e0b3b7 116 }
117}
23a9084b 118
119/* function to delete a saved search */
56e0b3b7 120function delete_saved($delete_index, $username, $data_dir) {
bebf762c 121 $types = array('saved_what', 'saved_where', 'saved_folder');
122 $attributes = get_saved($username, $data_dir);
123 foreach ($types as $key) {
124 array_splice($attributes[$key], $delete_index, 1);
125 }
126 reset($types);
56e0b3b7 127 $n=0;
bebf762c 128 $saved_count = count($attributes['saved_what']);
56e0b3b7 129 $last_element = $saved_count + 1;
56e0b3b7 130 for ($i=1;$i<=$saved_count;$i++) {
bebf762c 131 reset($types);
132 foreach ($types as $key) {
133 setPref($data_dir, $username, $key.$i, $attributes[$key][$n]);
134 }
23a9084b 135 $n++;
56e0b3b7 136 }
bebf762c 137 reset($types);
138 foreach($types as $key) {
139 removePref($data_dir, $username, $key.$last_element);
56e0b3b7 140 }
70c4fd84 141}
6c8388a9 142
23a9084b 143/* function to save a search from recent to saved */
56e0b3b7 144function save_recent($save_index, $username, $data_dir) {
bebf762c 145 $attributes = array();
146 $types = array('search_what', 'search_where', 'search_folder');
147 $saved_types = array(0 => 'saved_what', 1 => 'saved_where', 2 => 'saved_folder');
148 $saved_array = get_saved($username, $data_dir);
149 $save_index = $save_index -1;
150 $saved_count = (count($saved_array['saved_what']) + 1);
151 $attributes = get_recent ($username, $data_dir);
152 $n = 0;
153 foreach ($types as $key) {
154 $slice = array_slice($attributes[$key], $save_index, 1);
155 $name = $saved_types[$n];
156 setPref($data_dir, $username, $name.$saved_count, $slice[0]);
157 $n++;
158 }
56e0b3b7 159}
160
0d672ac0 161/* ------------------------ main ------------------------ */
162
23a9084b 163/* reset these arrays on each page load just in case */
bebf762c 164$attributes = array ();
165$saved_attributes = array ();
70c4fd84 166$search_all = 'none';
23a9084b 167$perbox_count = array ();
56e0b3b7 168
23a9084b 169/* get mailbox names */
29eb5486 170$imapConnection = sqimap_login($username, $key, $imapServerAddress, $imapPort, 0);
c1cb7ba4 171$boxes = sqimap_mailbox_list($imapConnection);
172
23a9084b 173/* set current mailbox to INBOX if none was selected or if page
174 was called to search all folders. */
14c62c12 175if ( !isset($mailbox) || $mailbox == 'None' || $mailbox == '' ) {
56e0b3b7 176 $mailbox = $boxes[0]['unformatted'];
177}
3b7d68e6 178if ($mailbox == 'All Folders') {
70c4fd84 179 $search_all = 'all';
c1cb7ba4 180}
181
182displayPageHeader($color, $mailbox);
c61bb006 183
23a9084b 184/* See how the page was called and fire off correct function */
d4144adf 185if ((!isset($submit) || empty($submit)) && !empty($what)) {
70c4fd84 186 $submit = _("Search");
d4144adf 187}
70c4fd84 188if ( !isset( $submit ) ) {
70c4fd84 189 $submit = '';
190} else if ($submit == _("Search") && !empty($what)) {
191 update_recent($what, $where, $mailbox, $username, $data_dir);
56e0b3b7 192}
88cb1b4d 193elseif ($submit == 'forget') {
56e0b3b7 194 forget_recent($count, $username, $data_dir);
195}
88cb1b4d 196elseif ($submit == 'save') {
56e0b3b7 197 save_recent($count, $username, $data_dir);
198}
88cb1b4d 199elseif ($submit == 'delete') {
56e0b3b7 200 delete_saved($count, $username, $data_dir);
201}
23a9084b 202
29eb5486 203do_hook('search_before_form');
56e0b3b7 204
205echo "<BR>\n".
88cb1b4d 206 "<table width=\"100%\">\n".
207 "<TR><td bgcolor=\"$color[0]\">\n".
208 "<CENTER><B>" . _("Search") . "</B></CENTER>\n".
209 "</TD></TR>\n".
210 "</TABLE>\n";
c61bb006 211
23a9084b 212/* update the recent and saved searches from the pref files */
bebf762c 213$attributes = get_recent($username, $data_dir);
56e0b3b7 214$recent_count = getPref($data_dir, $username, 'search_memory', 0);
bebf762c 215$saved_attributes = get_saved($username, $data_dir);
216$saved_count = count($saved_attributes['saved_what']);
91954f9e 217$count_all = 0;
a7d0eaf6 218
184ef883 219/* Saved Search Table */
56e0b3b7 220if ($saved_count > 0) {
184ef883 221 echo "<BR>\n"
88cb1b4d 222 . "<TABLE WIDTH=\"95%\" BGCOLOR=\"$color[9]\" ALIGN=\"CENTER\" CELLPADDING=1 CELLSPACING=1>"
223 . '<TR><TD align=center><B>Saved Searches</B></TD></TR><TR><TD>'
224 . '<TABLE WIDTH="100%" ALIGN="CENTER" CELLPADDING=0 CELLSPACING=0>';
184ef883 225 for ($i=0; $i < $saved_count; ++$i) {
88cb1b4d 226 if ($i % 2) {
227 echo "<TR BGCOLOR=\"$color[0]\">";
228 } else {
184ef883 229 echo "<TR BGCOLOR=\"$color[4]\">";
230 }
bebf762c 231 echo "<TD WIDTH=\"35%\">".$saved_attributes['saved_folder'][$i]."</TD>"
232 . "<TD ALIGN=LEFT>".$saved_attributes['saved_what'][$i]."</TD>"
233 . "<TD ALIGN=CENTER>".$saved_attributes['saved_where'][$i]."</TD>"
88cb1b4d 234 . '<TD ALIGN=RIGHT>'
235 . '<A HREF=search.php'
bebf762c 236 . '?mailbox=' . urlencode($saved_attributes['saved_folder'][$i])
237 . '&amp;what=' . urlencode($saved_attributes['saved_what'][$i])
238 . '&amp;where=' . urlencode($saved_attributes['saved_where'][$i])
88cb1b4d 239 . '>' . _("edit") . '</A>'
240 . '&nbsp;|&nbsp;'
241 . '<A HREF=search.php'
bebf762c 242 . '?mailbox=' . urlencode($saved_attributes['saved_folder'][$i])
243 . '&amp;what=' . urlencode($saved_attributes['saved_what'][$i])
244 . '&amp;where=' . urlencode($saved_attributes['saved_where'][$i])
5e9e90fd 245 . '&amp;submit=Search_no_update'
88cb1b4d 246 . '>' . _("search") . '</A>'
247 . '&nbsp;|&nbsp;'
5e9e90fd 248 . "<A HREF=search.php?count=$i&amp;submit=delete>"
88cb1b4d 249 . _("delete")
250 . '</A>'
251 . '</TD></TR>';
56e0b3b7 252 }
184ef883 253 echo "</TABLE></TD></TR></TABLE>\n";
a7d0eaf6 254}
255
184ef883 256/* Recent Search Table */
56e0b3b7 257if ($recent_count > 0) {
184ef883 258 echo "<BR>\n"
259 . "<TABLE WIDTH=\"95%\" BGCOLOR=\"$color[9]\" ALIGN=\"CENTER\" CELLPADDING=1 CELLSPACING=1>\n"
962c725d 260 . '<TR><TD ALIGN=CENTER><B>' . _("Recent Searches") . '</B></TD></TR><TR><TD>'
184ef883 261 . '<TABLE WIDTH="100%" ALIGN="CENTER" CELLPADDING=0 CELLSPACING=0>';
bebf762c 262 for ($i=1; $i <= $recent_count; ++$i) {
263 if (isset($attributes['search_folder'][$i])) {
264 if ($attributes['search_folder'][$i] == "") {
265 $attributes['search_folder'][$i] = "INBOX";
266 }
184ef883 267 }
268 if ($i % 2) {
269 echo "<TR BGCOLOR=\"$color[0]\">";
270 } else {
271 echo "<TR BGCOLOR=\"$color[4]\">";
272 }
bebf762c 273 if (isset($attributes['search_what'][$i]) &&
274 !empty($attributes['search_what'][$i])) {
275 echo "<TD WIDTH=35%>".$attributes['search_folder'][$i]."</TD>"
276 . "<TD ALIGN=LEFT>".$attributes['search_what'][$i]."</TD>"
277 . "<TD ALIGN=CENTER>".$attributes['search_where'][$i]."</TD>"
184ef883 278 . '<TD ALIGN=RIGHT>'
5e9e90fd 279 . "<A HREF=search.php?count=$i&amp;submit=save>"
184ef883 280 . _("save")
281 . '</A>'
282 . '&nbsp;|&nbsp;'
283 . '<A HREF=search.php'
bebf762c 284 . '?mailbox=' . urlencode($attributes['search_folder'][$i])
285 . '&amp;what=' . urlencode($attributes['search_what'][$i])
286 . '&amp;where=' . urlencode($attributes['search_where'][$i])
5e9e90fd 287 . '&amp;submit=Search_no_update'
184ef883 288 . '>' . _("search") . '</A>'
289 . '&nbsp;|&nbsp;'
5e9e90fd 290 . "<A HREF=search.php?count=$i&amp;submit=forget>"
184ef883 291 . _("forget")
292 . '</A>'
293 . '</TD></TR>';
0d672ac0 294 }
bebf762c 295 }
184ef883 296 echo '</TABLE></TD></TR></TABLE><BR>';
56e0b3b7 297}
184ef883 298
299/* Search Form */
3b7d68e6 300echo '<B>' . _("Current Search") . '</B>'
f1c7f8bb 301 . '<FORM ACTION="search.php" NAME=s>'
184ef883 302 . ' <TABLE WIDTH="95%" CELLPADDING=0 CELLSPACING=0>'
303 . ' <TR>'
304 . ' <TD><SELECT NAME="mailbox">';
56e0b3b7 305for ($i = 0; $i < count($boxes); $i++) {
306 if (!in_array('noselect', $boxes[$i]['flags'])) {
307 $box = $boxes[$i]['unformatted'];
308 $box2 = str_replace(' ', '&nbsp;', $boxes[$i]['unformatted-disp']);
3b7d68e6 309 if( $box2 == 'INBOX' ) {
310 $box2 = _("INBOX");
70c4fd84 311 }
56e0b3b7 312 if ($mailbox == $box) {
313 echo " <OPTION VALUE=\"$box\" SELECTED>$box2</OPTION>\n";
0d672ac0 314 }
56e0b3b7 315 else {
316 echo " <OPTION VALUE=\"$box\">$box2</OPTION>\n";
88cb1b4d 317 }
56e0b3b7 318 }
319}
6c8388a9 320 echo "<OPTION VALUE=\"All Folders\"";
321 if ($mailbox == "All Folders") {
56e0b3b7 322 echo "SELECTED";
0d672ac0 323 }
56e0b3b7 324 echo ">All folders</OPTION>\n";
325echo ' </SELECT>'.
326 " </TD>\n".
327 " <TD ALIGN=\"CENTER\">\n";
88cb1b4d 328if ( !isset( $what ) ) {
329 $what = '';
330}
e970aa41 331if ( !isset( $where ) ) {
332 $where = '';
333}
334
335
56e0b3b7 336$what_disp = str_replace(',', ' ', $what);
337$what_disp = str_replace('\\\\', '\\', $what_disp);
338$what_disp = str_replace('\\"', '"', $what_disp);
339$what_disp = str_replace('"', '&quot;', $what_disp);
340echo " <INPUT TYPE=\"TEXT\" SIZE=\"35\" NAME=\"what\" VALUE=\"$what_disp\">\n".
341 " </TD>\n".
342 "<TD ALIGN=\"RIGHT\">\n".
343 "<SELECT NAME=\"where\">";
344s_opt( 'BODY', $where, _("Body") );
345s_opt( 'TEXT', $where, _("Everywhere") );
346s_opt( 'SUBJECT', $where, _("Subject") );
347s_opt( 'FROM', $where, _("From") );
348s_opt( 'CC', $where, _("Cc") );
349s_opt( 'TO', $where, _("To") );
350echo " </SELECT>\n" .
351 " </TD>\n".
352 " <TD COLSPAN=\"3\" ALIGN=\"CENTER\">\n".
70c4fd84 353 " <INPUT TYPE=\"submit\" NAME=\"submit\" VALUE=\"" . _("Search") . "\">\n".
56e0b3b7 354 " </TD>\n".
355 " </TR>\n".
356 "</FORM>\n".
357 " </TABLE>\n".
358 "</TD></TR></TABLE>\n";
359
360
88cb1b4d 361do_hook('search_after_form');
56e0b3b7 362
88cb1b4d 363/*
364 search all folders option still in the works. returns a table for each
70c4fd84 365 folder it finds a match in.
88cb1b4d 366*/
56e0b3b7 367
e92eab8b 368$old_value = 0;
369if ($allow_thread_sort == true) {
370 $old_value = $allow_thread_sort;
371 $allow_thread_sort = false;
372}
373
88cb1b4d 374if ($search_all == 'all') {
375 $mailbox == '';
56e0b3b7 376 $boxcount = count($boxes);
88cb1b4d 377 echo '<BR><CENTER><B>' .
378 _("Search Results") .
379 "</B><CENTER><BR>\n";
56e0b3b7 380 for ($x=0;$x<$boxcount;$x++) {
381 if (!in_array('noselect', $boxes[$x]['flags'])) {
88cb1b4d 382 $mailbox = $boxes[$x]['unformatted'];
383 }
70c4fd84 384 if (($submit == _("Search") || $submit == 'Search_no_update') && !empty($what)) {
56e0b3b7 385 sqimap_mailbox_select($imapConnection, $mailbox);
88cb1b4d 386 $count_all = sqimap_search($imapConnection, $where, $what, $mailbox, $color, 0, $search_all, $count_all);
23a9084b 387 array_push($perbox_count, $count_all);
388 }
389 }
390 for ($i=0;$i<count($perbox_count);$i++) {
391 if ($perbox_count[$i] != "") {
392 break;
88cb1b4d 393 }
23a9084b 394 $count_all = "none";
88cb1b4d 395 }
23a9084b 396 if ($count_all == "none") {
88cb1b4d 397 echo '<br><b>' .
398 _("No Messages found") .
399 '</b><br>';
56e0b3b7 400 }
0d672ac0 401}
0d672ac0 402
23a9084b 403/* search one folder option */
56e0b3b7 404else {
70c4fd84 405 if (($submit == _("Search") || $submit == 'Search_no_update') && !empty($what)) {
88cb1b4d 406 echo '<BR><CENTER><B>' .
407 _("Search Results") .
408 "</B></CENTER>\n";
56e0b3b7 409 sqimap_mailbox_select($imapConnection, $mailbox);
88cb1b4d 410 sqimap_search($imapConnection, $where, $what, $mailbox, $color, 0, $search_all, $count_all);
56e0b3b7 411 }
29eb5486 412}
56e0b3b7 413
23a9084b 414/* must have search terms to search */
70c4fd84 415if ($submit == _("Search") && empty($what)) {
56e0b3b7 416 echo "<BR><CENTER><B>Please enter something to search for</B></CENTER>\n";
417}
418
e92eab8b 419$allow_thread_sort = $old_value;
420
70c4fd84 421do_hook('search_bottom');
56e0b3b7 422sqimap_logout ($imapConnection);
29eb5486 423echo '</body></html>';
99d2a184 424
91954f9e 425?>