src/search.php

   1 <?php
   2
   3 /**
   4  * search.php
   5  *
   6  * IMAP search page
   7  *
   8  * Subfolder search idea from Patch #806075 by Thomas Pohl xraven at users.sourceforge.net. Thanks Thomas!
   9  *
  10  * @author Alex Lemaresquier - Brainstorm <alex at brainstorm.fr>
  11  * @copyright &copy; 1999-2007 The SquirrelMail Project Team
  12  * @license http://opensource.org/licenses/gpl-license.php GNU Public License
  13  * @version $Id$
  14  * @package squirrelmail
  15  * @subpackage search
  16  * @link http://www.ietf.org/rfc/rfc3501.txt
  17  * @todo explain why references are used in function calls
  18  */
  19
  20 /** This is the search page */
  21 define('PAGE_NAME', 'search');
  22
  23 /**
  24  * Include the SquirrelMail initialization file.
  25  */
  26 require('../include/init.php');
  27
  28 /** SquirrelMail required files.
  29  */
  30 require_once(SM_PATH . 'functions/imap_asearch.php');
  31 require_once(SM_PATH . 'functions/imap_messages.php');
  32 require_once(SM_PATH . 'functions/imap_general.php');
  33 require_once(SM_PATH . 'functions/mime.php');
  34 require_once(SM_PATH . 'functions/mailbox_display.php'); //sqm_api_mailbox_select
  35 require_once(SM_PATH . 'functions/forms.php');
  36 require_once(SM_PATH . 'functions/date.php');
  37 require_once(SM_PATH . 'functions/compose.php');
  38
  39 /** Prefs array ordinals. Must match $recent_prefkeys and $saved_prefkeys
  40  */
  41 define('ASEARCH_WHERE', 0);
  42 define('ASEARCH_MAILBOX', 1);
  43 define('ASEARCH_WHAT', 2);
  44 define('ASEARCH_UNOP', 3);
  45 define('ASEARCH_BIOP', 4);
  46 define('ASEARCH_EXCLUDE', 5);
  47 define('ASEARCH_SUB', 6);
  48 define('ASEARCH_MAX', 7);
  49
  50 /** Name of session var
  51  */
  52 define('ASEARCH_CRITERIA', 'criteria');
  53
  54
  55 /**
  56  * Array sort callback used to sort $imap_asearch_options
  57  * @param string $a
  58  * @param string $b
  59  * @return bool strcoll()-like result
  60  * @since 1.5.0
  61  * @private
  62  */
  63 function asearch_unhtml_strcoll($a, $b)
  64 {
  65     // FIXME: Translation policy says "no html entities in translations"
  66     return strcoll(asearch_unhtmlentities($a), asearch_unhtmlentities($b));
  67 }
  68
  69 /**
  70  * @param string $mailbox mailbox name or special case 'All Folders'
  71  * @return string mailbox name ready to display (utf7 decoded or localized 'All Folders')
  72  * @since 1.5.0
  73  * @private
  74  */
  75 function asearch_get_mailbox_display($mailbox)
  76 {
  77     if ($mailbox == 'All Folders') {
  78         return _("All Folders");
  79     } elseif (strtoupper($mailbox) == 'INBOX') {
  80         return _("INBOX");
  81     }
  82     return imap_utf7_decode_local($mailbox);
  83 }
  84
  85 /**
  86  * @param array $input_array array to serialize
  87  * @return string a string containing a byte-stream representation of value that can be stored anywhere
  88  * @since 1.5.0
  89  * @private
  90  */
  91 function asearch_serialize(&$input_array)
  92 {
  93     global $search_advanced;
  94     if ($search_advanced)
  95         return serialize($input_array);
  96     return $input_array[0];
  97 }
  98
  99 /**
 100  * @param string $input_string string to unserialize
 101  * @return array
 102  * @since 1.5.0
 103  * @private
 104  */
 105 function asearch_unserialize($input_string)
 106 {
 107     global $search_advanced;
 108     if ($search_advanced)
 109         return unserialize($input_string);
 110     return array($input_string);
 111 }
 112
 113 /**
 114  * Gets user's advanced search preferences
 115  *
 116  * Arguments are different in 1.5.0.
 117  * @param string $key the pref key
 118  * @param integer $index the pref key index
 119  * @param string $default default value
 120  * @return string pref value
 121  * @since 1.5.0
 122  * @private
 123  */
 124 function asearch_getPref(&$key, $index, $default = '')
 125 {
 126     global $data_dir, $username, $search_advanced;
 127     return getPref($data_dir, $username, $key . ($index + !$search_advanced), $default);
 128 }
 129
 130 /**
 131  * Sets user's advanced search preferences
 132  *
 133  * Arguments are different in 1.5.0.
 134  * @param string $key the pref key
 135  * @param integer $index the pref key index
 136  * @param string $value pref value to set
 137  * @return bool status
 138  * @since 1.5.0
 139  * @private
 140  */
 141 function asearch_setPref(&$key, $index, $value)
 142 {
 143     global $data_dir, $username, $search_advanced;
 144     return setPref($data_dir, $username, $key . ($index + !$search_advanced), $value);
 145 }
 146
 147 /**
 148  * Deletes user's advanced search preferences
 149  *
 150  * Arguments are different in 1.5.0.
 151  * @param string $key the pref key
 152  * @param integer $index the pref key index
 153  * @return bool status
 154  * @since 1.5.0
 155  * @private
 156  */
 157 function asearch_removePref(&$key, $index)
 158 {
 159     global $data_dir, $username, $search_advanced;
 160     return removePref($data_dir, $username, $key . ($index + !$search_advanced));
 161 }
 162
 163 /**
 164  * Sanity checks, done before running the imap command and before calling push_recent
 165  * @param array $where_array search location data
 166  * @param array $what_array search criteria data
 167  * @param array $exclude_array excluded criteria data
 168  * @return string error message or empty string
 169  * @since 1.5.0
 170  * @private
 171  */
 172 function asearch_check_query(&$where_array, &$what_array, &$exclude_array)
 173 {
 174     global $imap_asearch_opcodes;
 175
 176     if (empty($where_array))
 177         return _("Please enter something to search for");
 178     if (count($exclude_array) == count($where_array))
 179         return _("There must be at least one criteria to search for");
 180     for ($crit_num = 0; $crit_num < count($where_array); $crit_num++) {
 181         $where = $where_array[$crit_num];
 182         $what = $what_array[$crit_num];
 183         if (!(($what == '') ^ ($imap_asearch_opcodes[$where] != '')))
 184             return _("Error in criteria argument");
 185     }
 186     return '';
 187 }
 188
 189 /**
 190  * Read the recent searches from the prefs
 191  *
 192  * Function arguments are different in 1.5.0
 193  * @return array recent searches
 194  * @since 1.5.0
 195  * @private
 196  */
 197 function asearch_read_recent()
 198 {
 199     global $recent_prefkeys, $search_memory;
 200
 201     $recent_array = array();
 202     $recent_num = 0;
 203     for ($pref_num = 0; $pref_num < $search_memory; $pref_num++) {
 204         foreach ($recent_prefkeys as $prefkey) {
 205             $pref = asearch_getPref($prefkey, $pref_num);
 206 /*            if (!empty($pref))*/
 207                 $recent_array[$prefkey][$recent_num] = $pref;
 208         }
 209         if (empty($recent_array[$recent_prefkeys[0]][$recent_num])) {
 210             foreach ($recent_prefkeys as $key) {
 211                 array_pop($recent_array[$key]);
 212             }
 213 //            break; //Disabled to support old search code broken prefs
 214         }
 215         else
 216             $recent_num++;
 217     }
 218     return $recent_array;
 219 }
 220
 221 /**
 222  * Read the saved searches from the prefs
 223  *
 224  * Function arguments are different in 1.5.0
 225  * @return array saved searches
 226  * @since 1.5.0
 227  * @private
 228  */
 229 function asearch_read_saved()
 230 {
 231     global $saved_prefkeys;
 232
 233     $saved_array = array();
 234     $saved_key = $saved_prefkeys[0];
 235     for ($saved_count = 0; ; $saved_count++) {
 236         $pref = asearch_getPref($saved_key, $saved_count);
 237         if (empty($pref))
 238             break;
 239     }
 240     for ($saved_num = 0; $saved_num < $saved_count; $saved_num++) {
 241         foreach ($saved_prefkeys as $key) {
 242             $saved_array[$key][$saved_num] = asearch_getPref($key, $saved_num);
 243         }
 244     }
 245     return $saved_array;
 246 }
 247
 248 /**
 249  * Save a recent search to the prefs
 250  *
 251  * Function arguments are different in 1.5.0
 252  * @param integer $recent_index
 253  * @since 1.5.0
 254  * @private
 255  */
 256 function asearch_save_recent($recent_index)
 257 {
 258     global $recent_prefkeys, $saved_prefkeys;
 259
 260     $saved_array = asearch_read_saved();
 261     if (isset($saved_array[$saved_prefkeys[0]])) {
 262         $saved_index = count($saved_array[$saved_prefkeys[0]]);
 263     } else {
 264         $saved_index = 0;
 265     }
 266     $recent_array = asearch_read_recent();
 267     $n = 0;
 268     foreach ($recent_prefkeys as $key) {
 269         $recent_slice = array_slice($recent_array[$key], $recent_index, 1);
 270         if (!empty($recent_slice[0]))
 271             asearch_setPref($saved_prefkeys[$n], $saved_index, $recent_slice[0]);
 272         else
 273             asearch_removePref($saved_prefkeys[$n], $saved_index);
 274         $n++;
 275     }
 276 }
 277
 278 /**
 279  * Write a recent search to prefs
 280  *
 281  * Function arguments are different in 1.5.0
 282  * @param array $recent_array
 283  * @since 1.5.0
 284  * @private
 285  */
 286 function asearch_write_recent(&$recent_array)
 287 {
 288     global $recent_prefkeys, $search_memory;
 289
 290     $recent_count = min($search_memory, count($recent_array[$recent_prefkeys[0]]));
 291     for ($recent_num = 0; $recent_num < $recent_count; $recent_num++) {
 292         foreach ($recent_prefkeys as $key) {
 293             asearch_setPref($key, $recent_num, $recent_array[$key][$recent_num]);
 294         }
 295     }
 296     for (; $recent_num < $search_memory; $recent_num++) {
 297         foreach ($recent_prefkeys as $key) {
 298             asearch_removePref($key, $recent_num);
 299         }
 300     }
 301 }
 302
 303 /**
 304  * Remove a recent search from prefs
 305  *
 306  * Function arguments are different in 1.5.0
 307  * @param integer $forget_index removed search number
 308  * @since 1.5.0
 309  * @private
 310  */
 311 function asearch_forget_recent($forget_index)
 312 {
 313     global $recent_prefkeys;
 314
 315     $recent_array = asearch_read_recent();
 316     foreach ($recent_prefkeys as $key) {
 317         array_splice($recent_array[$key], $forget_index, 1);
 318     }
 319     asearch_write_recent($recent_array);
 320 }
 321
 322 /**
 323  * Find a recent search in the prefs (used to avoid saving duplicates)
 324  * @param array $recent_array
 325  * @param array $mailbox_array
 326  * @param array $biop_array
 327  * @param array $unop_array
 328  * @param array $where_array
 329  * @param array $what_array
 330  * @param array $exclude_array
 331  * @param array $sub_array
 332  * @return integer
 333  * @since 1.5.0
 334  * @private
 335  */
 336 function asearch_find_recent(&$recent_array, &$mailbox_array, &$biop_array, &$unop_array, &$where_array, &$what_array, &$exclude_array, &$sub_array)
 337 {
 338     global $recent_prefkeys, $search_advanced;
 339
 340     $where_string = asearch_serialize($where_array);
 341     $mailbox_string = asearch_serialize($mailbox_array);
 342     $what_string = asearch_serialize($what_array);
 343     $unop_string = asearch_serialize($unop_array);
 344     if ($search_advanced) {
 345         $biop_string = asearch_serialize($biop_array);
 346         $exclude_string = asearch_serialize($exclude_array);
 347         $sub_string = asearch_serialize($sub_array);
 348     }
 349     $recent_count = count($recent_array[$recent_prefkeys[ASEARCH_WHERE]]);
 350     for ($recent_num = 0; $recent_num < $recent_count; $recent_num++) {
 351         if (isset($recent_array[$recent_prefkeys[ASEARCH_WHERE]][$recent_num])) {
 352             if (
 353                     $where_string == $recent_array[$recent_prefkeys[ASEARCH_WHERE]][$recent_num] &&
 354                     $mailbox_string == $recent_array[$recent_prefkeys[ASEARCH_MAILBOX]][$recent_num] &&
 355                     $what_string == $recent_array[$recent_prefkeys[ASEARCH_WHAT]][$recent_num] &&
 356                     $unop_string == $recent_array[$recent_prefkeys[ASEARCH_UNOP]][$recent_num] &&
 357                     ((!$search_advanced) ||
 358                         ($biop_string == $recent_array[$recent_prefkeys[ASEARCH_BIOP]][$recent_num] &&
 359                         $exclude_string == $recent_array[$recent_prefkeys[ASEARCH_EXCLUDE]][$recent_num] &&
 360                         $sub_string == $recent_array[$recent_prefkeys[ASEARCH_SUB]][$recent_num]))
 361                     )
 362                 return $recent_num;
 363         }
 364     }
 365     return -1;
 366 }
 367
 368 /**
 369  * Push a recent search into the prefs
 370  * @param array $recent_array
 371  * @param array $mailbox_array
 372  * @param array $biop_array
 373  * @param array $unop_array
 374  * @param array $where_array
 375  * @param array $what_array
 376  * @param array $exclude_array
 377  * @param array $sub_array
 378  * @since 1.5.0
 379  * @private
 380  */
 381 function asearch_push_recent(&$mailbox_array, &$biop_array, &$unop_array, &$where_array, &$what_array, &$exclude_array, &$sub_array)
 382 {
 383     global $recent_prefkeys, $search_memory;
 384     //global $what; // Hack to access issued search from read_body.php
 385     $what = 1;
 386     /**
 387      * Update search history and store it in the session so we can retrieve the
 388      * issued search when returning from an external page like read_body.php
 389      */
 390     $criteria[$what] = array($mailbox_array, $biop_array, $unop_array, $where_array, $what_array, $exclude_array, $sub_array);
 391     sqsession_register($criteria, ASEARCH_CRITERIA);
 392     if ($search_memory > 0) {
 393         $recent_array = asearch_read_recent();
 394         $recent_found = asearch_find_recent($recent_array, $mailbox_array, $biop_array, $unop_array, $where_array, $what_array, $exclude_array, $sub_array);
 395         if ($recent_found >= 0) { // Remove identical recent
 396             foreach ($recent_prefkeys as $key) {
 397                 array_splice($recent_array[$key], $recent_found, 1);
 398             }
 399         }
 400         $input = array($where_array, $mailbox_array, $what_array, $unop_array, $biop_array, $exclude_array, $sub_array);
 401         $i = 0;
 402         foreach ($recent_prefkeys as $key) {
 403             array_unshift($recent_array[$key], asearch_serialize($input[$i]));
 404             $i++;
 405         }
 406         asearch_write_recent($recent_array);
 407     }
 408 }
 409
 410 /**
 411  * Edit a recent search
 412  *
 413  * Function arguments are different in 1.5.0
 414  * @global array mailbox_array searched mailboxes
 415  * @param mixed $index
 416  * @since 1.5.0
 417  * @private
 418  */
 419 function asearch_edit_recent($index)
 420 {
 421     global $recent_prefkeys, $search_advanced;
 422     global $where_array, $mailbox_array, $what_array, $unop_array;
 423     global $biop_array, $exclude_array, $sub_array;
 424
 425     $where_array = asearch_unserialize(asearch_getPref($recent_prefkeys[ASEARCH_WHERE], $index));
 426     $mailbox_array = asearch_unserialize(asearch_getPref($recent_prefkeys[ASEARCH_MAILBOX], $index));
 427     $what_array = asearch_unserialize(asearch_getPref($recent_prefkeys[ASEARCH_WHAT], $index));
 428     $unop_array = asearch_unserialize(asearch_getPref($recent_prefkeys[ASEARCH_UNOP], $index));
 429     if ($search_advanced) {
 430         $biop_array = asearch_unserialize(asearch_getPref($recent_prefkeys[ASEARCH_BIOP], $index));
 431         $exclude_array = asearch_unserialize(asearch_getPref($recent_prefkeys[ASEARCH_EXCLUDE], $index));
 432         $sub_array = asearch_unserialize(asearch_getPref($recent_prefkeys[ASEARCH_SUB], $index));
 433     }
 434 }
 435
 436 /**
 437  * Get last search criteria from session or prefs
 438  *
 439  * Function arguments are different in 1.5.0
 440  * FIXME, try to avoid globals
 441  * @param mixed $index
 442  * @since 1.5.0
 443  * @private
 444  */
 445 function asearch_edit_last($index) {
 446     if (sqGetGlobalVar(ASEARCH_CRITERIA, $criteria, SQ_SESSION)) {
 447         global $where_array, $mailbox_array, $what_array, $unop_array;
 448         global $biop_array, $exclude_array, $sub_array;
 449         $mailbox_array = $criteria[$index][0];
 450         $biop_array = $criteria[$index][1];
 451         $unop_array = $criteria[$index][2];
 452         $where_array = $criteria[$index][3];
 453         $what_array = $criteria[$index][4];
 454         $exclude_array = $criteria[$index][5];
 455         $sub_array = $criteria[$index][6];
 456         unset($criteria[$index]);
 457         //sqsession_unregister(ASEARCH_CRITERIA);
 458     } else {
 459         global $search_memory;
 460         if ($search_memory > 0) {
 461             asearch_edit_recent(0);
 462         }
 463     }
 464 }
 465
 466 /**
 467  * Edit a saved search
 468  *
 469  * Function arguments are different in 1.5.0
 470  * @param mixed $index
 471  * @since 1.5.0
 472  * @private
 473  */
 474 function asearch_edit_saved($index)
 475 {
 476     global $saved_prefkeys, $search_advanced;
 477     global $where_array, $mailbox_array, $what_array, $unop_array;
 478     global $biop_array, $exclude_array, $sub_array;
 479
 480     $where_array = asearch_unserialize(asearch_getPref($saved_prefkeys[ASEARCH_WHERE], $index));
 481     $mailbox_array = asearch_unserialize(asearch_getPref($saved_prefkeys[ASEARCH_MAILBOX], $index));
 482     $what_array = asearch_unserialize(asearch_getPref($saved_prefkeys[ASEARCH_WHAT], $index));
 483     $unop_array = asearch_unserialize(asearch_getPref($saved_prefkeys[ASEARCH_UNOP], $index));
 484     if ($search_advanced) {
 485         $biop_array = asearch_unserialize(asearch_getPref($saved_prefkeys[ASEARCH_BIOP], $index));
 486         $exclude_array = asearch_unserialize(asearch_getPref($saved_prefkeys[ASEARCH_EXCLUDE], $index));
 487         $sub_array = asearch_unserialize(asearch_getPref($saved_prefkeys[ASEARCH_SUB], $index));
 488     }
 489 }
 490
 491 /**
 492  * Write a saved search to the prefs
 493  *
 494  * Function arguments are different in 1.5.0
 495  * @param array $saved_array
 496  * @since 1.5.0
 497  * @private
 498  */
 499 function asearch_write_saved(&$saved_array)
 500 {
 501     global $saved_prefkeys;
 502
 503     $saved_count = count($saved_array[$saved_prefkeys[0]]);
 504     for ($saved_num=0; $saved_num < $saved_count; $saved_num++) {
 505         foreach ($saved_prefkeys as $key) {
 506             asearch_setPref($key, $saved_num, $saved_array[$key][$saved_num]);
 507         }
 508     }
 509     foreach ($saved_prefkeys as $key) {
 510         asearch_removePref($key, $saved_count);
 511     }
 512 }
 513
 514 /**
 515  * Delete a saved search from the prefs
 516  *
 517  * Function arguments are different in 1.5.0
 518  * @param integer $saved_index
 519  * @since 1.5.0
 520  * @private
 521  */
 522 function asearch_delete_saved($saved_index)
 523 {
 524     global $saved_prefkeys;
 525
 526     $saved_array = asearch_read_saved();
 527     $asearch_keys = $saved_prefkeys;
 528     foreach ($asearch_keys as $key) {
 529         array_splice($saved_array[$key], $saved_index, 1);
 530     }
 531     asearch_write_saved($saved_array);
 532 }
 533
 534 /** Translate the input date to imap date to local date display,
 535  * so the user can know if the date is wrong or illegal
 536  * @param string $what date string
 537  * @return string locally formatted date or error text
 538  * @since 1.5.0
 539  * @private
 540  */
 541 function asearch_get_date_display(&$what)
 542 {
 543     $what_parts = sqimap_asearch_parse_date($what);
 544     if (count($what_parts) == 4) {
 545         if (checkdate($what_parts[2], $what_parts[1], $what_parts[3]))
 546             return date_intl(_("M j, Y"), mktime(0,0,0,$what_parts[2],$what_parts[1],$what_parts[3]));
 547             //return $what_parts[1] . ' ' . getMonthName($what_parts[2]) . ' ' . $what_parts[3];
 548         return _("(Illegal date)");
 549     }
 550     return _("(Wrong date)");
 551 }
 552
 553 /**
 554  * Translate the query to rough natural display
 555  * @param array $color
 556  * @param array $mailbox_array
 557  * @param array $biop_array
 558  * @param array $unop_array
 559  * @param array $where_array
 560  * @param array $what_array
 561  * @param array $exclude_array
 562  * @param array $sub_array
 563  * @return string rough natural query ready to display
 564  * @since 1.5.0
 565  * @private
 566  */
 567 function asearch_get_query_display(&$color, &$mailbox_array, &$biop_array, &$unop_array, &$where_array, &$what_array, &$exclude_array, &$sub_array)
 568 {
 569     global $imap_asearch_biops_in, $imap_asearch_biops, $imap_asearch_unops, $imap_asearch_options;
 570     global $imap_asearch_opcodes;
 571
 572     $last_mailbox = $mailbox_array[0];
 573     if (empty($last_mailbox))
 574         $last_mailbox = 'INBOX';
 575     $query_display = '';
 576     for ($crit_num=0; $crit_num < count($where_array); $crit_num++) {
 577         if ((!isset($exclude_array[$crit_num])) || (!$exclude_array[$crit_num])) {
 578             $cur_mailbox = $mailbox_array[$crit_num];
 579             if (empty($cur_mailbox))
 580                 $cur_mailbox = 'INBOX';
 581             $biop = asearch_nz($biop_array[$crit_num]);
 582             if (($query_display == '') || ($cur_mailbox != $last_mailbox)) {
 583                 $mailbox_display = ' <span class="mailbox">' . htmlspecialchars(asearch_get_mailbox_display($cur_mailbox)) . '</span>';
 584                 if ($query_display == '')
 585                     $biop_display = _("In");
 586                 else
 587                     $biop_display = $imap_asearch_biops_in[$biop];
 588                 $last_mailbox = $cur_mailbox;
 589             }
 590             else {
 591                 $mailbox_display = '';
 592                 $biop_display = $imap_asearch_biops[$biop];
 593             }
 594             $unop = $unop_array[$crit_num];
 595             $unop_display = $imap_asearch_unops[$unop];
 596             if ($unop_display != '')
 597                 $unop_display .= ' ';
 598             $where = $where_array[$crit_num];
 599             $where_display = $unop_display . asearch_nz($imap_asearch_options[$where], $where);
 600             $what_type = $imap_asearch_opcodes[$where];
 601             $what = $what_array[$crit_num];
 602             if ($what_type) { /* Check opcode parameter */
 603                 if ($what == '')
 604                     $what_display = ' <span class="error">' . _("(Missing argument)") .'</span>';
 605                 else {
 606                     if ($what_type == 'adate')
 607                         $what_display = asearch_get_date_display($what);
 608                     else
 609                         $what_display = htmlspecialchars($what);
 610                     $what_display = ' <span class="value">' . $what_display . '</span>';
 611                 }
 612             }
 613             else {
 614                 if ($what)
 615                     $what_display = ' <span class="error">' . _("(Spurious argument)") .'</span>';
 616                 else
 617                     $what_display = '';
 618             }
 619             if ($mailbox_display != '')
 620                 $query_display .= ' <span class="operator">' . $biop_display . '</span>' . $mailbox_display . ' <span class="conditions">' . $where_display . '</span>' . $what_display;
 621             else
 622                 $query_display .= ' <span class="operator">' . $biop_display . '</span> <span class="conditions">' . $where_display . '</span>' . $what_display;
 623         }
 624     }
 625     return $query_display;
 626 }
 627
 628 /**
 629  * Print a whole query array, recent or saved
 630  *
 631  * Function arguments are different in 1.5.0
 632  * @param array $boxes (unused)
 633  * @param array $query_array
 634  * @param mixed $query_keys
 635  * @param array $action_array
 636  * @param mixed $title
 637  * @param string $show_pref
 638  * @since 1.5.0
 639  * @private
 640  */
 641 function asearch_print_query_array(&$boxes, &$query_array, &$query_keys, &$action_array, $title, $show_pref)
 642 {
 643     global $data_dir, $username;
 644     global $icon_theme_path;
 645     global $oTemplate;
 646
 647     $show_flag = getPref($data_dir, $username, $show_pref, 0) & 1;
 648     $a = array();
 649     $main_key = $query_keys[ASEARCH_WHERE];
 650     $query_count = count($query_array[$main_key]);
 651     for ($query_num = 0, $row_num = 0; $query_num < $query_count; $query_num++) {
 652         if (!empty($query_array[$main_key][$query_num])) {
 653             unset($search_array);
 654             foreach ($query_keys as $query_key) {
 655                 $search_array[] = asearch_unserialize($query_array[$query_key][$query_num]);
 656             }
 657
 658             $where_array = $search_array[ASEARCH_WHERE];
 659             $mailbox_array = $search_array[ASEARCH_MAILBOX];
 660             $what_array = $search_array[ASEARCH_WHAT];
 661             $unop_array = $search_array[ASEARCH_UNOP];
 662             $biop_array = asearch_nz($search_array[ASEARCH_BIOP], array());
 663             $exclude_array = asearch_nz($search_array[ASEARCH_EXCLUDE], array());
 664             $sub_array = asearch_nz($search_array[ASEARCH_SUB], array());
 665             $query_display = asearch_get_query_display($color, $mailbox_array, $biop_array, $unop_array, $where_array, $what_array, $exclude_array, $sub_array);
 666
 667             $a[$query_num] = $query_display;
 668         }
 669     }
 670
 671     $oTemplate->assign('list_title', $title);
 672     $oTemplate->assign('show_list', $show_flag==1);
 673     $oTemplate->assign('is_recent_list', $title==_("Recent Searches"));
 674     $oTemplate->assign('expand_collapse_toggle', '../src/search.php?'.$show_pref.'='.($show_flag==1 ? 0 : 1));
 675     $oTemplate->assign('query_list', $a);
 676
 677     $oTemplate->assign('save_recent', '../src/search.php?submit=save_recent&rownum=');
 678     $oTemplate->assign('do_recent', '../src/search.php?submit=search_recent&rownum=');
 679     $oTemplate->assign('forget_recent', '../src/search.php?submit=forget_recent&rownum=');
 680
 681     $oTemplate->assign('edit_saved', '../src/search.php?submit=edit_saved&rownum=');
 682     $oTemplate->assign('do_saved', '../src/search.php?submit=search_saved&rownum=');
 683     $oTemplate->assign('delete_saved', '../src/search.php?submit=delete_saved&rownum=');
 684
 685     $oTemplate->display('search_list.tpl');
 686 }
 687
 688 /** Print the saved array
 689  *
 690  * Function arguments are different in 1.5.0
 691  * @param array $boxes (unused, see asearch_print_query_array())
 692  * @since 1.5.0
 693  * @private
 694  */
 695 function asearch_print_saved(&$boxes)
 696 {
 697     global $saved_prefkeys;
 698
 699     $saved_array = asearch_read_saved();
 700     if (isset($saved_array[$saved_prefkeys[0]])) {
 701         $saved_count = count($saved_array[$saved_prefkeys[0]]);
 702         if ($saved_count > 0) {
 703             $saved_actions = array('edit_saved' => _("Edit"), 'search_saved' => _("Search"), 'delete_saved' => _("Delete"));
 704             asearch_print_query_array($boxes, $saved_array, $saved_prefkeys, $saved_actions, _("Saved Searches"), 'search_show_saved');
 705         }
 706     }
 707 }
 708
 709 /**
 710  * Print the recent array
 711  *
 712  * Function arguments are different in 1.5.0
 713  * @param array $boxes (unused, see asearch_print_query_array())
 714  * @since 1.5.0
 715  * @private
 716  */
 717 function asearch_print_recent(&$boxes)
 718 {
 719     global $recent_prefkeys, $search_memory;
 720
 721     $recent_array = asearch_read_recent();
 722     if (isset($recent_array[$recent_prefkeys[0]])) {
 723         $recent_count = count($recent_array[$recent_prefkeys[0]]);
 724         if (min($recent_count, $search_memory) > 0) {
 725             $recent_actions = array('save_recent' => _("save"), 'search_recent' => _("search"), 'forget_recent' => _("forget"));
 726             asearch_print_query_array($boxes, $recent_array, $recent_prefkeys, $recent_actions, _("Recent Searches"), 'search_show_recent');
 727         }
 728     }
 729 }
 730
 731 /** Verify that a mailbox exists
 732  * @param string $mailbox
 733  * @param array $boxes
 734  * @return bool mailbox exists
 735  * @deprecated FIXME use standard functions
 736  * @since 1.5.0
 737  * @private
 738  */
 739 function asearch_mailbox_exists($mailbox, &$boxes)
 740 {
 741     foreach ($boxes as $box) {
 742         if ($box['unformatted'] == $mailbox)
 743             return TRUE;
 744     }
 745     return FALSE;
 746 }
 747
 748 /** Print the advanced search form
 749  * @param stream $imapConnection
 750  * @param array $boxes
 751  * @param array $mailbox_array
 752  * @param array $biop_array
 753  * @param array $unop_array
 754  * @param array $where_array
 755  * @param array $what_array
 756  * @param array $exclude_array
 757  * @param array $sub_array
 758  * @since 1.5.0
 759  * @private
 760  */
 761 function asearch_print_form($imapConnection, &$boxes, $mailbox_array, $biop_array, $unop_array, $where_array, $what_array, $exclude_array, $sub_array)
 762 {
 763     global $oTemplate, $allow_advanced_search, $search_advanced,
 764            $imap_asearch_unops, $imap_asearch_biops_in, $imap_asearch_options;
 765
 766     # Build the criteria array
 767     $c = array();
 768     for ($row_num = 0; $row_num < count($where_array); $row_num++) {
 769         $mailbox = asearch_nz($mailbox_array[$row_num]);
 770         $a = array();
 771         $a['MailboxSel'] = asearch_nz($mailbox_array[$row_num]);
 772         $a['LogicSel'] = strip_tags(asearch_nz($biop_array[$row_num]));
 773         $a['UnarySel'] = strip_tags(asearch_nz($unop_array[$row_num]));
 774         $a['WhereSel'] = strip_tags(asearch_nz($where_array[$row_num]));
 775         $a['What'] = asearch_nz($what_array[$row_num]);
 776         $a['Exclude'] = strip_tags(asearch_nz($exclude_array[$row_num])) == 'on';
 777         $a['IncludeSubfolders'] = strip_tags(asearch_nz($sub_array[$row_num])) == 'on';
 778
 779         $c[$row_num] = $a;
 780     }
 781
 782     # Build the mailbox array
 783     $a = array();
 784     if (($mailbox != 'All Folders') && (!asearch_mailbox_exists($mailbox, $boxes))) {
 785         $a[$mailbox] = '[' . _("Missing") . '] ' . htmlspecialchars(asearch_get_mailbox_display($mailbox));
 786     }
 787     $a['All Folders'] = '[' . asearch_get_mailbox_display('All Folders') . ']';
 788     $a = array_merge($a, sqimap_mailbox_option_array($imapConnection, 0, $boxes, NULL));
 789
 790     if ($allow_advanced_search > 1) {
 791         $link = '../src/search.php?advanced='.($search_advanced ? 0 : 1);
 792         $txt = $search_advanced ? _("Standard Search") : _("Advanced search");
 793     } else {
 794         $link = NULL;
 795         $txt = NULL;
 796     }
 797
 798     $oTemplate->assign('allow_advanced_search', $allow_advanced_search > 1);
 799     $oTemplate->assign('adv_toggle_text', $txt);
 800     $oTemplate->assign('adv_toggle_link', $link);
 801
 802     $oTemplate->assign('mailbox_options', $a);
 803     $oTemplate->assign('logical_options', $imap_asearch_biops_in);
 804     $oTemplate->assign('unary_options', $imap_asearch_unops);
 805     $oTemplate->assign('where_options', $imap_asearch_options);
 806
 807     $oTemplate->assign('criteria', $c);
 808
 809     echo '<form action="../src/search.php" name="form_asearch">' . "\n";
 810     $oTemplate->display('search_advanced.tpl');
 811     echo "</form>\n";
 812 }
 813
 814 /** Print the basic search form
 815  * @param stream $imapConnection
 816  * @param array $boxes
 817  * @param array $mailbox_array
 818  * @param array $biop_array
 819  * @param array $unop_array
 820  * @param array $where_array
 821  * @param array $what_array
 822  * @param array $exclude_array
 823  * @param array $sub_array
 824  * @since 1.5.1
 825  * @private
 826  */
 827 function asearch_print_form_basic($imapConnection, &$boxes, $mailbox_array, $biop_array, $unop_array, $where_array, $what_array, $exclude_array, $sub_array)
 828 {
 829     global $allow_advanced_search, $search_advanced, $oTemplate, $imap_asearch_unops, $imap_asearch_options;
 830
 831     $row_num = 0;
 832     $mailbox = asearch_nz($mailbox_array[$row_num]);
 833     $biop = strip_tags(asearch_nz($biop_array[$row_num]));
 834     $unop = strip_tags(asearch_nz($unop_array[$row_num]));
 835     $where = strip_tags(asearch_nz($where_array[$row_num]));
 836     $what = asearch_nz($what_array[$row_num]);
 837     $exclude = strip_tags(asearch_nz($exclude_array[$row_num]));
 838     $sub = strip_tags(asearch_nz($sub_array[$row_num]));
 839
 840     # Build the mailbox array
 841     $a = array();
 842     if (($mailbox != 'All Folders') && (!asearch_mailbox_exists($mailbox, $boxes))) {
 843         $a[$mailbox] = '[' . _("Missing") . '] ' . htmlspecialchars(asearch_get_mailbox_display($mailbox));
 844     }
 845     $a['All Folders'] = '[' . asearch_get_mailbox_display('All Folders') . ']';
 846     $a = array_merge($a, sqimap_mailbox_option_array($imapConnection, 0, $boxes, NULL));
 847
 848     if ($allow_advanced_search > 1) {
 849         $link = '../src/search.php?advanced='.($search_advanced ? 0 : 1);
 850         $txt = $search_advanced ? _("Standard Search") : _("Advanced search");
 851     } else {
 852         $link = NULL;
 853         $txt = NULL;
 854     }
 855
 856     $oTemplate->assign('allow_advanced_search', $allow_advanced_search > 1);
 857     $oTemplate->assign('adv_toggle_text', $txt);
 858     $oTemplate->assign('adv_toggle_link', $link);
 859
 860     $oTemplate->assign('mailbox_options', $a);
 861     $oTemplate->assign('unary_options', $imap_asearch_unops);
 862     $oTemplate->assign('where_options', $imap_asearch_options);
 863
 864     $oTemplate->assign('mailbox_sel', strtolower(htmlspecialchars($mailbox)));
 865     $oTemplate->assign('unary_sel', $unop);
 866     $oTemplate->assign('where_sel', $where);
 867     $oTemplate->assign('what_val', $what);
 868
 869     echo '<form action="../src/search.php" name="form_asearch">' . "\n";
 870     $oTemplate->display('search.tpl');
 871     echo "</form>\n";
 872 }
 873
 874
 875 /**
 876  * @param array $boxes mailboxes array (reference)
 877  * @return array selectable unformatted mailboxes names
 878  * @since 1.5.0
 879  * @private
 880  */
 881 function sqimap_asearch_get_selectable_unformatted_mailboxes(&$boxes)
 882 {
 883     $mboxes_array = array();
 884     $boxcount = count($boxes);
 885     for ($boxnum = 0; $boxnum < $boxcount; $boxnum++) {
 886         if (!in_array('noselect', $boxes[$boxnum]['flags']))
 887             $mboxes_array[] = $boxes[$boxnum]['unformatted'];
 888     }
 889     return $mboxes_array;
 890 }
 891
 892 /* ------------------------ main ------------------------ */
 893 /* get globals we will need */
 894 sqgetGlobalVar('delimiter', $delimiter, SQ_SESSION);
 895
 896 if ( sqgetGlobalVar('checkall', $temp, SQ_GET) ) {
 897     $checkall = (int) $temp;
 898 }
 899
 900 /**
 901  * Retrieve the mailbox cache from the session.
 902  */
 903 sqgetGlobalVar('mailbox_cache',$mailbox_cache,SQ_SESSION);
 904
 905 $search_button_html = _("Search");
 906 $search_button_text = asearch_unhtmlentities($search_button_html);
 907 $add_criteria_button_html = _("Add New Criteria");
 908 $add_criteria_button_text = asearch_unhtmlentities($add_criteria_button_html);
 909 $del_excluded_button_html = _("Remove Excluded Criteria");
 910 $del_excluded_button_text = asearch_unhtmlentities($del_excluded_button_html);
 911 $del_all_button_html = _("Remove All Criteria");
 912 $del_all_button_text = asearch_unhtmlentities($del_all_button_html);
 913
 914 /** Maximum number of recent searches to handle
 915  * Default 0
 916  * @global integer $search_memory
 917  */
 918 $search_memory = getPref($data_dir, $username, 'search_memory', 0);
 919
 920 /** Advanced search control
 921  * - 0 => allow basic interface only
 922  * - 1 => allow advanced interface only
 923  * - 2 => allow both
 924  * Default 2
 925  */
 926 $allow_advanced_search = asearch_nz($allow_advanced_search, 2);
 927
 928 /**
 929  * Toggle advanced/basic search
 930  */
 931 if (sqgetGlobalVar('advanced', $search_advanced, SQ_GET)) {
 932     setPref($data_dir, $username, 'search_advanced', $search_advanced & 1);
 933 }
 934 /** If 1, show advanced search interface
 935  * Default from allow_advanced_search pref
 936  * @global integer $search_advanced
 937  */
 938 if ($allow_advanced_search > 1) {
 939     $search_advanced = getPref($data_dir, $username, 'search_advanced', 0);
 940 } else {
 941     $search_advanced = $allow_advanced_search;
 942 }
 943 if ($search_advanced) {
 944 /** Set recent prefkeys according to $search_advanced
 945  * @global array $recent_prefkeys
 946  */
 947     $recent_prefkeys = array('asearch_recent_where', 'asearch_recent_mailbox', 'asearch_recent_what', 'asearch_recent_unop', 'asearch_recent_biop', 'asearch_recent_exclude', 'asearch_recent_sub');
 948
 949 /** Set saved prefkeys according to $search_advanced
 950  * @global array $saved_prefkeys
 951  */
 952     $saved_prefkeys = array('asearch_saved_where', 'asearch_saved_mailbox', 'asearch_saved_what', 'asearch_saved_unop', 'asearch_saved_biop', 'asearch_saved_exclude', 'asearch_saved_sub');
 953
 954 /*$asearch_prefkeys = array('where', 'mailbox', 'what', 'biop', 'unop', 'exclude', 'sub');*/
 955 } else {
 956     $recent_prefkeys = array('search_where', 'search_folder', 'search_what', 'search_unop');
 957     $saved_prefkeys = array('saved_where', 'saved_folder', 'saved_what', 'saved_unop');
 958 }
 959
 960 /** How we did enter the form
 961  * - unset : Enter key, or called from outside (eg read_body)
 962  * - $search_button_text : Search button
 963  * - 'Search_no_update' : Search but don't update recent
 964  * - 'Search_last' : Same as no_update but reload and search last
 965  * - 'Search_silent' : Same as no_update but only display results
 966  * - $add_criteria_button_text : Add New Criteria button
 967  * - $del_excluded_button_text : Remove Excluded Criteria button
 968  * - $del_all_button_text : Remove All Criteria button
 969  * - 'save_recent'
 970  * - 'search_recent'
 971  * - 'forget_recent'
 972  * - 'edit_saved'
 973  * - 'search_saved'
 974  * - 'delete_saved'
 975  * @global string $submit
 976  */
 977 $searchpressed = false;
 978 //FIXME: Why is there so much access to $_GET in this file?  What's wrong with sqGetGlobalVar?
 979 if (isset($_GET['submit'])) {
 980     $submit = strip_tags($_GET['submit']);
 981 }
 982
 983 /** Searched mailboxes
 984  * @global array $mailbox_array
 985  */
 986 /* when using compact paginator, mailbox might be indicated in $startMessage, so look for it now ($startMessage is then processed farther below) */
 987 $mailbox = '';
 988 $startMessage = '';
 989 if (sqGetGlobalVarMultiple('startMessage', $temp, 'paginator_submit', SQ_FORM)) {
 990     if (strstr($temp, '_')) list($startMessage, $mailbox) = explode('_', $temp);
 991     else $startMessage = $temp;
 992 }
 993 if (empty($mailbox)) sqGetGlobalVar('mailbox', $mailbox, SQ_GET, '');
 994 if (!empty($mailbox)) {
 995     $mailbox_array = $mailbox;
 996     $targetmailbox = $mailbox;
 997     if (!is_array($mailbox_array)) {
 998         $mailbox_array = array($mailbox_array);
 999     }
1000 } else {
1001     $mailbox_array = array();
1002     $targetmailbox = array();
1003 }
1004 $aMailboxGlobalPref = array(
1005                        MBX_PREF_SORT         => 0,
1006                        MBX_PREF_LIMIT        => (int)  $show_num,
1007                        MBX_PREF_AUTO_EXPUNGE => (bool) $auto_expunge,
1008                        MBX_PREF_INTERNALDATE => (bool) getPref($data_dir, $username, 'internal_date_sort')
1009                     // MBX_PREF_FUTURE       => (var)  $future
1010                      );
1011
1012 /**
1013  * system wide admin settings and incoming vars.
1014  */
1015 $aConfig = array(
1016 //                'allow_thread_sort' => $allow_thread_sort,
1017 //                'allow_server_sort' => $allow_server_sort,
1018                 'user'              => $username,
1019                 'setindex'          => 1
1020                 );
1021
1022 /** Binary operators
1023  * @global array $biop_array
1024  */
1025 //FIXME: Why is there so much access to $_GET in this file?  What's wrong with sqGetGlobalVar?
1026 if (isset($_GET['biop'])) {
1027     $biop_array = $_GET['biop'];
1028     if (!is_array($biop_array))
1029         $biop_array = array($biop_array);
1030 } else {
1031     $biop_array = array();
1032 }
1033 /** Unary operators
1034  * @global array $unop_array
1035  */
1036 //FIXME: Why is there so much access to $_GET in this file?  What's wrong with sqGetGlobalVar?
1037 if (isset($_GET['unop'])) {
1038     $unop_array = $_GET['unop'];
1039     if (!is_array($unop_array))
1040         $unop_array = array($unop_array);
1041 } else {
1042     $unop_array = array();
1043 }
1044 /** Where to search
1045  * @global array $where_array
1046  */
1047 //FIXME: Why is there so much access to $_GET in this file?  What's wrong with sqGetGlobalVar?
1048 if (isset($_GET['where'])) {
1049     $where_array = $_GET['where'];
1050     if (!is_array($where_array)) {
1051         $where_array = array($where_array);
1052     }
1053 } else {
1054     $where_array = array();
1055 }
1056 /** What to search
1057  * @global array $what_array
1058  */
1059 //FIXME: Why is there so much access to $_GET in this file?  What's wrong with sqGetGlobalVar?
1060 if (isset($_GET['what'])) {
1061     $what_array = $_GET['what'];
1062     if (!is_array($what_array)) {
1063         $what_array = array($what_array);
1064     }
1065 } else {
1066     $what_array = array();
1067 }
1068 /** Whether to exclude this criteria from search
1069  * @global array $exclude_array
1070  */
1071 //FIXME: Why is there so much access to $_GET in this file?  What's wrong with sqGetGlobalVar?
1072 if (isset($_GET['exclude'])) {
1073     $exclude_array = $_GET['exclude'];
1074 } else {
1075     $exclude_array = array();
1076 }
1077 /** Search within subfolders
1078  * @global array $sub_array
1079  */
1080 //FIXME: Why is there so much access to $_GET in this file?  What's wrong with sqGetGlobalVar?
1081 if (isset($_GET['sub'])) {
1082     $sub_array = $_GET['sub'];
1083 } else {
1084     $sub_array = array();
1085 }
1086 /** Row number used by recent and saved stuff
1087  */
1088 //FIXME: Why is there so much access to $_GET in this file?  What's wrong with sqGetGlobalVar?
1089 if (isset($_GET['rownum'])) {
1090     $submit_rownum = strip_tags($_GET['rownum']);
1091 }
1092 /** Change global sort
1093  */
1094 if (sqgetGlobalVar('srt', $temp, SQ_GET)) {
1095     $srt = (int) $temp;
1096     asearch_edit_last(1);
1097 //    asearch_push_recent($mailbox_array, $biop_array, $unop_array, $where_array, $what_array, $exclude_array, $sub_array);
1098 }
1099 /* already retrieved startMessage above */
1100 if (!empty($startMessage)) {
1101     $startMessage = (int) $startMessage;
1102     asearch_edit_last(1);
1103 //    asearch_push_recent($mailbox_array, $biop_array, $unop_array, $where_array, $what_array, $exclude_array, $sub_array);
1104 }
1105
1106 if ( sqgetGlobalVar('showall', $temp, SQ_GET) ) {
1107     $showall = (int) $temp;
1108     asearch_edit_last(1);
1109 //    asearch_push_recent($mailbox_array, $biop_array, $unop_array, $where_array, $what_array, $exclude_array, $sub_array);
1110 }
1111
1112 if ( sqgetGlobalVar('account', $temp,  SQ_GET) ) {
1113     $iAccount = (int) $temp;
1114 } else {
1115     $iAccount = 0;
1116 }
1117
1118 /**
1119  * Incoming submit buttons from the message list with search results
1120  */
1121 if (sqgetGlobalVar('moveButton',      $moveButton,      SQ_POST) ||
1122     sqgetGlobalVar('expungeButton',   $expungeButton,   SQ_POST) ||
1123     sqgetGlobalVar('delete',          $markDelete,      SQ_POST) ||
1124     sqgetGlobalVar('undeleteButton',  $undeleteButton,  SQ_POST) ||
1125     sqgetGlobalVar('markRead',        $markRead,        SQ_POST) ||
1126     sqgetGlobalVar('markUnread',      $markUnread,      SQ_POST) ||
1127     sqgetGlobalVar('markFlagged',     $markFlagged,     SQ_POST) ||
1128     sqgetGlobalVar('markUnflagged',   $markUnflagged,   SQ_POST) ||
1129     sqgetGlobalVar('attache',         $attache,         SQ_POST)) {
1130     asearch_edit_last(1);
1131     $submit = '';
1132     asearch_push_recent($mailbox_array, $biop_array, $unop_array, $where_array, $what_array, $exclude_array, $sub_array);
1133 }
1134
1135
1136
1137 /** Toggle show/hide saved searches
1138  */
1139 if (sqgetGlobalVar('search_show_saved', $search_show_saved, SQ_GET)) {
1140     setPref($data_dir, $username, 'search_show_saved', $search_show_saved & 1);
1141 }
1142 /** Toggle show/hide recent searches
1143  */
1144 if (sqgetGlobalVar('search_show_recent', $search_show_recent, SQ_GET)) {
1145     setPref($data_dir, $username, 'search_show_recent', $search_show_recent & 1);
1146 }
1147 // end of get globals
1148
1149 /** If TRUE, do not show search interface
1150  * Default FALSE
1151  * @global bool $search_silent
1152  */
1153 $search_silent = FALSE;
1154
1155 /*  See how the page was called and fire off correct function  */
1156 if ((empty($submit)) && (!empty($where_array))) {
1157     /* This happens when the Enter key is used or called from outside */
1158     $submit = $search_button_text;
1159     /* Hack needed to handle coming back from read_body et als */
1160     if (count($where_array) != count($unop_array)) {
1161         /**
1162          * Hack to use already existen where and what vars.
1163          * where now contains the initiator page of the messagelist
1164          * and in this case 'search'. what contains an index to access
1165          * the search history
1166          */
1167
1168         sqgetGlobalVar('what',$what,SQ_GET);
1169         asearch_edit_last($what);
1170     }
1171 }
1172
1173 if (!isset($submit)) {
1174     $submit = '';
1175 } else {
1176     switch ($submit) {
1177       case $search_button_text:
1178         if (asearch_check_query($where_array, $what_array, $exclude_array) == '') {
1179             asearch_push_recent($mailbox_array, $biop_array, $unop_array, $where_array, $what_array, $exclude_array, $sub_array);
1180         }
1181         break;
1182       case 'Search_silent':
1183         $search_silent = TRUE;
1184         /*nobreak;*/
1185       case 'Search_no_update':
1186         $submit = $search_button_text;
1187         break;
1188       case $del_excluded_button_text:
1189         $delarray = array_keys($exclude_array);
1190         while (!empty($delarray)) {
1191             $delrow = array_pop($delarray);
1192             array_splice($mailbox_array, $delrow, 1);
1193             array_splice($biop_array, $delrow, 1);
1194             array_splice($unop_array, $delrow, 1);
1195             array_splice($where_array, $delrow, 1);
1196             array_splice($what_array, $delrow, 1);
1197             /* array_splice($exclude_array, $delrow, 1);*/ /* There is still some php magic that eludes me */
1198             array_splice($sub_array, $delrow, 1);
1199         }
1200         $exclude_array = array();
1201         break;
1202       case $del_all_button_text:
1203         $mailbox_array = array();
1204         $biop_array = array();
1205         $unop_array = array();
1206         $where_array = array();
1207         $what_array = array();
1208         $exclude_array = array();
1209         $sub_array = array();
1210         break;
1211       case 'save_recent':
1212         asearch_save_recent($submit_rownum);
1213         break;
1214       case 'search_recent':
1215         $submit = $search_button_text;
1216         asearch_edit_recent($submit_rownum);
1217         asearch_push_recent($mailbox_array, $biop_array, $unop_array, $where_array, $what_array, $exclude_array, $sub_array);
1218         break;
1219       case 'edit_recent': /* no link to do this, yet */
1220         asearch_edit_recent($submit_rownum);
1221         break;
1222       case 'forget_recent':
1223         asearch_forget_recent($submit_rownum);
1224         break;
1225       case 'search_saved':
1226         $submit = $search_button_text;
1227         asearch_edit_saved($submit_rownum);
1228         asearch_push_recent($mailbox_array, $biop_array, $unop_array, $where_array, $what_array, $exclude_array, $sub_array);
1229         break;
1230       case 'edit_saved':
1231         asearch_edit_saved($submit_rownum);
1232         break;
1233       case 'delete_saved':
1234         asearch_delete_saved($submit_rownum);
1235         break;
1236     }
1237 }
1238
1239 //Texts in both basic and advanced form
1240 $imap_asearch_unops = array(
1241     '' => '',
1242     'NOT' => _("Not")
1243 );
1244
1245 if ($search_advanced) {
1246     //Texts in advanced form only
1247     $imap_asearch_options = array(
1248         //<message set>,
1249         //'ALL' is binary operator
1250         'ANSWERED' => _("Answered"),
1251         'BCC' => _("Bcc"),
1252         'BEFORE' => _("Before"),
1253         'BODY' => _("Message Body"),
1254         'CC' => _("Cc"),
1255         'DELETED' => _("Deleted"),
1256         'DRAFT' => _("Draft"),
1257         'FLAGGED' => _("Flagged"),
1258         'FROM' => _("Sent By"),
1259         'HEADER' => _("Header Field"),
1260         'KEYWORD' => _("Keyword"),
1261         'LARGER' => _("Larger Than"),
1262         'NEW' => _("New"),
1263         //'NOT' is unary operator
1264         'OLD' => _("Old"),
1265         'ON' => _("On"),
1266         //'OR' is binary operator
1267         'RECENT' => _("Recent"),
1268         'SEEN' => _("Seen"),
1269         'SENTBEFORE' => _("Sent Before"),
1270         'SENTON' => _("Sent On"),
1271         'SENTSINCE' => _("Sent Since"),
1272         'SINCE' => _("Since"),
1273         'SMALLER' => _("Smaller Than"),
1274         'SUBJECT' => _("Subject Contains"),
1275         'TEXT' => _("Header and Body"),
1276         'TO' => _("Sent To"),
1277         //'UID' => 'anum',
1278 /*        'UNANSWERED' => '',
1279         'UNDELETED' => '',
1280         'UNDRAFT' => '',
1281         'UNFLAGGED' => '',
1282         'UNKEYWORD' => _("Unkeyword"),
1283         'UNSEEN' => _("Unseen"),*/
1284     );
1285
1286     $imap_asearch_biops_in = array(
1287         'ALL' => _("And In"),
1288         'OR' => _("Or In")
1289     );
1290
1291     $imap_asearch_biops = array(
1292         'ALL' => _("And"),
1293         'OR' => _("Or")
1294     );
1295 } else {
1296     //Texts in basic form only
1297     $imap_asearch_options = array(
1298         'BCC' => _("Bcc"),
1299         'BODY' => _("Body"),
1300         'CC' => _("Cc"),
1301         'FROM' => _("From"),
1302         'SUBJECT' => _("Subject"),
1303         'TEXT' => _("Everywhere"),
1304         'TO' => _("To"),
1305     );
1306 }
1307
1308 uasort($imap_asearch_options, 'asearch_unhtml_strcoll');
1309
1310 /* open IMAP connection */
1311 $imapConnection = sqimap_login($username, false, $imapServerAddress, $imapPort, 0);
1312
1313
1314 /* get mailboxes once here */
1315 $boxes = sqimap_mailbox_list($imapConnection);
1316 /* ensure we have a valid default mailbox name */
1317 $mailbox = asearch_nz($mailbox_array[0]);
1318 if ($mailbox == '')
1319     $mailbox = $boxes[0]['unformatted']; //Usually INBOX ;)
1320
1321
1322 /**
1323 * Handle form actions like flag / unflag, seen / unseen, delete
1324 */
1325 if (sqgetGlobalVar('mailbox',$postMailbox,SQ_POST)) {
1326     if ($postMailbox) {
1327         /**
1328         * system wide admin settings and incoming vars.
1329         */
1330         $aConfig = array(
1331                         'user'              => $username,
1332                         );
1333         $aConfig['setindex'] = 1; // $what $where = 'search'
1334         /**
1335          * Set the max cache size to the number of mailboxes to avoid cache cleanups
1336          * when searching all mailboxes
1337          */
1338         $aConfig['max_cache_size'] = count($boxes) +1;
1339
1340         $aMailbox = sqm_api_mailbox_select($imapConnection, $iAccount, $postMailbox,$aConfig,array());
1341         $sError = handleMessageListForm($imapConnection,$aMailbox);
1342         /* add the mailbox to the cache */
1343         $mailbox_cache[$iAccount.'_'.$aMailbox['NAME']] = $aMailbox;
1344
1345         if ($sError) {
1346             $note = $sError;
1347         }
1348     }
1349 }
1350
1351 if (isset($aMailbox['FORWARD_SESSION'])) {
1352     /* add the mailbox to the cache */
1353     $mailbox_cache[$iAccount.'_'.$aMailbox['NAME']] = $aMailbox;
1354     sqsession_register($mailbox_cache,'mailbox_cache');
1355
1356     if ($compose_new_win) {
1357         // write the session in order to make sure that the compose window has
1358         // access to the composemessages array which is stored in the session
1359         session_write_close();
1360         // restart the session. Do not use sqsession_is_active because the session_id
1361         // isn't empty after a session_write_close
1362         sqsession_start();
1363
1364         if (!preg_match("/^[0-9]{3,4}$/", $compose_width)) {
1365             $compose_width = '640';
1366         }
1367         if (!preg_match("/^[0-9]{3,4}$/", $compose_height)) {
1368             $compose_height = '550';
1369         }
1370         // do not use &amp;, it will break the query string and $session will not be detected!!!
1371         $comp_uri = SM_PATH . 'src/compose.php?mailbox='. urlencode($mailbox).
1372                     '&session='.$aMailbox['FORWARD_SESSION'];
1373         displayPageHeader($color, $mailbox, "comp_in_new('$comp_uri', $compose_width, $compose_height);", false);
1374     } else {
1375         // save mailboxstate
1376         sqsession_register($aMailbox,'aLastSelectedMailbox');
1377         session_write_close();
1378         // we have to redirect to the compose page
1379         $location = SM_PATH . 'src/compose.php?mailbox='. urlencode($mailbox).
1380                     '&session='.$aMailbox['FORWARD_SESSION'];
1381         header("Location: $location");
1382         exit;
1383     }
1384 } else {
1385     displayPageHeader($color, $mailbox);
1386 //    $compose_uri = $base_uri.'src/compose.php?newmessage=1';
1387 }
1388
1389 if (isset($note)) {
1390     $oTemplate->assign('note', $note);
1391     $oTemplate->display('note.tpl');
1392 }
1393
1394 do_hook('search_before_form', $null);
1395
1396 if (!$search_silent) {
1397     asearch_print_saved($boxes);
1398     asearch_print_recent($boxes);
1399     if (empty($where_array)) {
1400         global $sent_folder;
1401
1402         $mailbox_array[0] = $mailbox;
1403         $biop_array[0] = '';
1404         $unop_array[0] = '';
1405         if ($mailbox == $sent_folder) {
1406             $where_array[0] = 'TO';
1407         } else {
1408             $where_array[0] = 'FROM';
1409         }
1410         $what_array[0] = '';
1411         $exclude_array[0] = '';
1412         $sub_array[0] = '';
1413     }
1414     //Display advanced or basic form
1415     if ($search_advanced) {
1416         if ($submit == $add_criteria_button_text) {
1417             $last_index = max(count($where_array) - 1, 0);
1418             $mailbox_array[] = asearch_nz($mailbox_array[$last_index]);
1419             $biop_array[] = asearch_nz($biop_array[$last_index]);
1420             $unop_array[] = asearch_nz($unop_array[$last_index]);
1421             $where_array[] = asearch_nz($where_array[$last_index]);
1422             $what_array[] = asearch_nz($what_array[$last_index]);
1423             $exclude_array[] = asearch_nz($exclude_array[$last_index]);
1424             $sub_array[] = asearch_nz($sub_array[$last_index]);
1425         }
1426         asearch_print_form($imapConnection, $boxes, $mailbox_array, $biop_array, $unop_array, $where_array, $what_array, $exclude_array, $sub_array);
1427     } else {
1428         asearch_print_form_basic($imapConnection, $boxes, $mailbox_array, $biop_array, $unop_array, $where_array, $what_array, $exclude_array, $sub_array);
1429     }
1430 }
1431
1432 do_hook('search_after_form', $null);
1433
1434 if ($submit == $search_button_text) {
1435     $msgsfound = false;
1436
1437     $err = asearch_check_query($where_array, $what_array, $exclude_array);
1438
1439     $oTemplate->assign('query_has_error', $err!='');
1440     $oTemplate->assign('query_error', $err=='' ? NULL : $err);
1441     $oTemplate->assign('query', asearch_get_query_display($color, $mailbox_array, $biop_array, $unop_array, $where_array, $what_array, $exclude_array, $sub_array));
1442
1443     $oTemplate->display('search_result_top.tpl');
1444
1445     flush();
1446     $iMsgCnt = 0;
1447     if ($err == '') {
1448         $mboxes_array = sqimap_asearch_get_selectable_unformatted_mailboxes($boxes);
1449         /**
1450          * Retrieve the search queries
1451          */
1452         $mboxes_mailbox = sqimap_asearch($imapConnection, $mailbox_array, $biop_array, $unop_array, $where_array, $what_array, $exclude_array, $sub_array, $mboxes_array);
1453         foreach($mboxes_mailbox as $mbx => $search) {
1454
1455             /**
1456             * until there is no per mailbox option screen to set prefs we override
1457             * the mailboxprefs by the default ones
1458             */
1459
1460             $aMailboxPrefSer=getPref($data_dir, $username,'pref_'.$iAccount.'_'.$mbx);
1461             if ($aMailboxPrefSer) {
1462                 $aMailboxPref = unserialize($aMailboxPrefSer);
1463                 $aMailboxPref[MBX_PREF_COLUMNS] = $index_order;
1464             } else {
1465                 setUserPref($username,'pref_'.$iAccount.'_'.$mbx,serialize($default_mailbox_pref));
1466                 $aMailboxPref = $default_mailbox_pref;
1467             }
1468             if (isset($srt) && $targetmailbox == $mbx) {
1469                 $aMailboxPref[MBX_PREF_SORT] = (int) $srt;
1470             }
1471
1472             $trash_folder = (isset($trash_folder)) ? $trash_folder : false;
1473             $sent_folder = (isset($sent_folder)) ? $sent_folder : false;
1474             $draft_folder = (isset($draft_folder)) ? $draft_folder : false;
1475
1476
1477             /**
1478             * until there is no per mailbox option screen to set prefs we override
1479             * the mailboxprefs by the default ones
1480             */
1481             $aMailboxPref[MBX_PREF_LIMIT] = (int)  $show_num;
1482             $aMailboxPref[MBX_PREF_AUTO_EXPUNGE] = (bool) $auto_expunge;
1483             $aMailboxPref[MBX_PREF_INTERNALDATE] = (bool) getPref($data_dir, $username, 'internal_date_sort');
1484             $aMailboxPref[MBX_PREF_COLUMNS] = $index_order;
1485
1486             /**
1487             * Replace From => To  in case it concerns a draft or sent folder
1488             */
1489             if (($mbx == $sent_folder || $mbx == $draft_folder) &&
1490                 !in_array(SQM_COL_TO,$aMailboxPref[MBX_PREF_COLUMNS])) {
1491                 $aNewOrder = array(); // nice var name ;)
1492                 foreach($aMailboxPref[MBX_PREF_COLUMNS] as $iCol) {
1493                     if ($iCol == SQM_COL_FROM) {
1494                         $iCol = SQM_COL_TO;
1495                     }
1496                     $aNewOrder[] = $iCol;
1497                 }
1498                 $aMailboxPref[MBX_PREF_COLUMNS] = $aNewOrder;
1499                 setUserPref($username,'pref_'.$iAccount.'_'.$mbx,serialize($aMailboxPref));
1500             }
1501
1502             $aConfig['search'] = $search['search'];
1503             $aConfig['charset'] = $search['charset'];
1504
1505             /**
1506              * Set the max cache size to the number of mailboxes to avoid cache cleanups
1507              * when searching all mailboxes
1508              */
1509             $aConfig['max_cache_size'] = count($mboxes_mailbox) +1;
1510             if (isset($startMessage) && $targetmailbox == $mbx) {
1511                 $aConfig['offset'] = $startMessage;
1512             } else {
1513                 $aConfig['offset'] = 0;
1514             }
1515             if (isset($showall) && $targetmailbox == $mbx) {
1516                 $aConfig['showall'] = $showall;
1517             } else {
1518                 if (isset($aConfig['showall'])) {
1519                     unset($aConfig['showall']);
1520                 }
1521                 $showall = false;
1522             }
1523
1524             /**
1525             * Set the config options for the messages list
1526             */
1527             $aColumns = array();
1528             foreach ($aMailboxPref[MBX_PREF_COLUMNS] as $iCol) {
1529                 $aColumns[$iCol] = array();
1530                 switch ($iCol) {
1531                     case SQM_COL_SUBJ:
1532                         if ($truncate_subject) {
1533                             $aColumns[$iCol]['truncate'] = $truncate_subject;
1534                         }
1535                         break;
1536                     case SQM_COL_FROM:
1537                     case SQM_COL_TO:
1538                     case SQM_COL_CC:
1539                     case SQM_COL_BCC:
1540                         if ($truncate_sender) {
1541                             $aColumns[$iCol]['truncate'] = $truncate_sender;
1542                         }
1543                         break;
1544                 }
1545             }
1546
1547
1548             $aProps = array(
1549                 'columns' => $aColumns,
1550                 'config'  => array('alt_index_colors'      => $alt_index_colors,
1551                                     'highlight_list'        => $message_highlight_list,
1552                                     'fancy_index_highlite'  => $fancy_index_highlite,
1553                                     'show_flag_buttons'     => (isset($show_flag_buttons)) ? $show_flag_buttons : true,
1554                                     'lastTargetMailbox'     => (isset($lastTargetMailbox)) ? $lastTargetMailbox : '',
1555                                     'trash_folder'          => $trash_folder,
1556                                     'sent_folder'           => $sent_folder,
1557                                     'draft_folder'          => $draft_folder,
1558                                     'enablesort'            => true,
1559                                     'color'                 => $color
1560                             ),
1561                 'mailbox' => $mbx,
1562                 'account' => (isset($iAccount)) ? $iAccount : 0,
1563                 'module' => 'read_body',
1564                 'email'  => false);
1565
1566
1567             $aMailbox = sqm_api_mailbox_select($imapConnection, $iAccount, $mbx,$aConfig,$aMailboxPref);
1568
1569             $iError = 0;
1570             $aTemplate = showMessagesForMailbox($imapConnection, $aMailbox,$aProps, $iError);
1571
1572             // in th future we can make use of multiple message sets, now set it to 1 for search.
1573             $iSetIndex = 1;
1574             if (isset($aMailbox['UIDSET'][$iSetIndex])) {
1575                 $iMsgCnt += count($aMailbox['UIDSET'][$iSetIndex]);
1576             }
1577             if ($iError) {
1578                 // error handling
1579             } else {
1580                 /**
1581                 * In the future, move this the the initialisation area
1582                 */
1583                 sqgetGlobalVar('align',$align,SQ_SESSION);
1584
1585                 /**
1586                  * TODO: Clean up handling of message list once the template is cleaned up.
1587                  */
1588                 if ($aMailbox['EXISTS'] > 0) {
1589                     if ($iError) {
1590                        // TODO
1591                        echo "ERROR occured, errorhandler will be implemented very soon";
1592                     } else {
1593                         foreach ($aTemplate as $k => $v) {
1594                             $oTemplate->assign($k, $v);
1595                         }
1596
1597                         $mailbox_display = asearch_get_mailbox_display($aMailbox['NAME']);
1598                         if (strtoupper($mbx) == 'INBOX') {
1599                             $mailbox_display = _("INBOX");
1600                         } else {
1601                             $mailbox_display = imap_utf7_decode_local($mbx);
1602                         }
1603
1604                         $oTemplate->assign('mailbox_name', htmlspecialchars($mailbox_display));
1605                         $oTemplate->display('search_result_mailbox.tpl');
1606
1607                         $oTemplate->assign('page_selector',  $page_selector);
1608                         $oTemplate->assign('page_selector_max', $page_selector_max);
1609                         $oTemplate->assign('compact_paginator', $compact_paginator);
1610                         $oTemplate->assign('javascript_on', checkForJavascript());
1611                         $oTemplate->assign('base_uri', sqm_baseuri());
1612                         $oTemplate->assign('enablesort', (isset($aProps['config']['enablesort'])) ? $aProps['config']['enablesort'] : false);
1613                         $oTemplate->assign('icon_theme_path', $icon_theme_path);
1614                         $oTemplate->assign('use_icons', (isset($use_icons)) ? $use_icons : false);
1615                         $oTemplate->assign('aOrder', array_keys($aColumns));
1616                         $oTemplate->assign('alt_index_colors', isset($alt_index_colors) ? $alt_index_colors: false);
1617                         $oTemplate->assign('color', $color);
1618                         $oTemplate->assign('align', $align);
1619
1620                         $oTemplate->display('message_list.tpl');
1621                     }
1622                 }
1623             }
1624
1625             /* add the mailbox to the cache */
1626             $mailbox_cache[$iAccount.'_'.$aMailbox['NAME']] = $aMailbox;
1627
1628         }
1629     }
1630     if(!$iMsgCnt) {
1631         $oTemplate->display('search_result_empty.tpl');
1632     }
1633 }
1634
1635 do_hook('search_bottom', $null);
1636 sqimap_logout($imapConnection);
1637
1638 $oTemplate->display('footer.tpl');
1639 sqsession_register($mailbox_cache,'mailbox_cache');