Projekt

Allgemein

Profil

Statistiken
| Revision:

keywords2categories / api / autocomplete / autocomplete.php @ 5

Historie | Anzeigen | Annotieren | Download (5,4 KB)

1 1 root
<?php
2
/* -----------------------------------------------------------------------------------------
3
   $Id: autocomplete.php 13450 2021-03-05 16:29:46Z GTB $
4

5
   modified eCommerce Shopsoftware
6
   http://www.modified-shop.org
7

8
   Copyright (c) 2009 - 2013 [www.modified-shop.org]
9
   -----------------------------------------------------------------------------------------
10
   Released under the GNU General Public License
11
   ---------------------------------------------------------------------------------------*/
12
13
  chdir('../../');
14
  include('includes/application_top.php');
15
16
17
  // include needed functions
18
  require_once (DIR_FS_INC.'xtc_parse_search_string.inc.php');
19
20
  $module_smarty = new Smarty;
21
  $module_smarty->assign('language', $_SESSION['language']);
22
23 3 root
  if (isset($_POST['queryString'])) {
24 1 root
    $from_str = $where_str = '';
25
26
    $queryString = stripslashes(trim(decode_utf8(urldecode($_POST['queryString']))));
27
    $categories_id = !empty($_POST['categories_id']) ? (int)$_POST['categories_id'] : false;
28
    $inc_subcat = !empty($_POST['inc_subcat']) ? (int)$_POST['inc_subcat'] : null;
29
30
    // create $search_keywords array
31
    $keywordcheck = xtc_parse_search_string($queryString, $search_keywords);
32 3 root
33 1 root
    if ($keywordcheck === true && mb_strlen($queryString, $_SESSION['language_charset']) >= SEARCH_AC_MIN_LENGTH) {
34
35
      $from_str .= SEARCH_IN_ATTR == 'true' ? " LEFT OUTER JOIN ".TABLE_PRODUCTS_ATTRIBUTES." AS pa ON (p.products_id = pa.products_id)
36
                                                LEFT OUTER JOIN ".TABLE_PRODUCTS_OPTIONS_VALUES." AS pov ON (pa.options_values_id = pov.products_options_values_id) " : "";
37
      $from_str .= SEARCH_IN_MANU == 'true' ? " LEFT OUTER JOIN ".TABLE_MANUFACTURERS." AS m ON (p.manufacturers_id = m.manufacturers_id) " : "";
38
39
      if (SEARCH_IN_FILTER == 'true') {
40
        $from_str .= "LEFT JOIN ".TABLE_PRODUCTS_TAGS." pt ON (pt.products_id = p.products_id)
41
                      LEFT JOIN ".TABLE_PRODUCTS_TAGS_VALUES." ptv ON (ptv.options_id = pt.options_id AND ptv.values_id = pt.values_id AND ptv.status = '1' AND ptv.languages_id = '".(int)$_SESSION['languages_id']."') ";
42
      }
43
44
      //include subcategories if needed
45
      if ($categories_id !== false) {
46
        if ($inc_subcat == '1') {
47
          $subcategories_array = array();
48
          xtc_get_subcategories($subcategories_array, $categories_id);
49
          $from_str .= " LEFT OUTER JOIN ".TABLE_PRODUCTS_TO_CATEGORIES." AS p2c ON (p.products_id = p2c.products_id) ";
50
          $where_str .= " AND p2c.categories_id IN ('".$categories_id."' ";
51
          foreach ($subcategories_array AS $scat) {
52
            $where_str .= ", '".$scat."'";
53
          }
54
          $where_str .= ") ";
55
        } else {
56
          $from_str .= " LEFT OUTER JOIN ".TABLE_PRODUCTS_TO_CATEGORIES." AS p2c ON (p.products_id = p2c.products_id) ";
57
          $where_str .= " AND p2c.categories_id = '".$categories_id."' ";
58
        }
59
      }
60
61
      include(DIR_WS_INCLUDES.'build_search_query.php');
62
63
      $where_str .= " ) ";
64
65
      $autocomplete_search_query = "SELECT ".$product->default_select."
66
                                      FROM ".TABLE_PRODUCTS." p
67
                                      JOIN ".TABLE_PRODUCTS_DESCRIPTION." pd
68
                                           ON p.products_id = pd.products_id
69
                                              AND pd.language_id = '".(int)$_SESSION['languages_id']."'
70
                                              AND trim(pd.products_name) != ''
71
                                           ".$from_str."
72
                                     WHERE p.products_status = '1'
73
                                            ".$where_str."
74
                                            ".PRODUCTS_CONDITIONS_P."
75
                                   GROUP BY p.products_id
76
                                   ORDER BY p.products_id ASC
77
                                      LIMIT ".MAX_DISPLAY_ADVANCED_SEARCH_RESULTS;
78 3 root
79
      # Modul Kategorie-Keywords: Erg?nzung relevanter Artikel IDs
80
      if(defined('MODULE_CATEGORY_KEYWORDS_STATUS')
81
         && MODULE_CATEGORY_KEYWORDS_STATUS == 'True'){
82
           require_once (DIR_WS_INCLUDES.'extra/default/listing_sql/category_keywords.php');
83
           # Erg?nzung relevanter Artikel IDs
84
           if(isset($arr_included_products)){
85
              $autocomplete_search_query = str_replace("AND (  (", "AND (  ( p.products_id IN (".join($arr_included_products, ",") . ") OR ", $autocomplete_search_query);
86
           }
87
           # Erg?nzung relevanter Kategorien
88
           if(count($categories_keyword_content) > 0) {
89
                  $module_smarty->assign('categories_content', $categories_keyword_content);
90
           }
91
      }
92 1 root
      $autocomplete_search_query = xtc_db_query($autocomplete_search_query);
93
      if (xtc_db_num_rows($autocomplete_search_query) > 0) {
94
        $module_content = array();
95
        while ($autocomplete_search = xtc_db_fetch_array($autocomplete_search_query)) {
96
          $module_content[] = $product->buildDataArray($autocomplete_search);
97
        }
98
        $module_smarty->assign('module_content', $module_content);
99
      } else {
100
        $module_smarty->assign('error', 'true');
101
      }
102
      $module_smarty->caching = 0;
103
      $module_smarty->display(CURRENT_TEMPLATE.'/module/autocomplete.html');
104
    }
105
  }
106
?>