src/search.php

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