Advanced search result display (custom field)

[chadlly2003]

When someone does a search it displays the name and model number of each product.

Example:

Product Name: product example 1
Product Model Number: 123

I have a custom field in the products table called UPC.

Is there a way when someone does a search I could add the custom field to display the results below:

Product Name: product example 1
Product Model Number: 123
Product UPC: 0123456789123

I have done some research and know the files I have to edit consist of
/include/modules/pages/advanced_search_results/header_php.php
/include/modules/pages/advanced_search/header_php.php

If someone could assist me or lead me in the right direction on solving this I would greatly appreciate it.

[lat9]

Is the field in the database's products table names specifically UPC?

[chadlly2003]

Yes in the database under products it is called UPC

[chadlly2003]

Just to be more specific when you do a search the product listing page appears like this

Product Name: product example 1
Product Model Number: 123

What I need displayed is (see below)
I have a custom field under products_upc in my database)

Product Name: product example 1
Product Model Number: 123
Product UPC: 0123456789123

[DrByte]

/include/modules/pages/advanced_search_results/header_php.php

That's the file for including the field when searching the db. (EDIT: Or use the observer class idea as lat9 posted below)

To display the field's content, you'll need to edit /includes/modules/name_of_your_template/product_listing.php
and perhaps /includes/index_filters/default_filter.php
and maybe /includes/modules/pages/index/main_template_vars.php
... depending on what you're trying to accomplish.


.

[lat9]

Since you're running Zen Cart 1.5.4, you have the capability to use an "auto-loaded observer".

Create the file /includes/classes/observers/auto.search_in_upc.php, containing:

<?php
/**
 * @package plugins
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: Designed for v1.5.4  $
 */

class zcObserverSearchInUpc extends base 
{
    public function __construct() 
    {
      $this->attach ($this, array ('NOTIFY_SEARCH_WHERE_STRING'));
    }

    public function update (&$class, $eventID) 
    {
        switch ($eventID) {
            case 'NOTIFY_SEARCH_WHERE_STRING': 
                global $where_str, $keywords;
                if (isset ($keywords) && zen_not_null ($keywords)) {
                    if (zen_parse_search_string (stripslashes ($keywords), $search_keywords)) {
                        $keyword_str = " OR (p.UPC != '' AND (";
                        for ($i=0, $n = sizeof ($search_keywords); $i<$n; $i++ ) {
                            switch ($search_keywords[$i]) {
                                case '(':
                                case ')':
                                case 'and':
                                case 'or':
                                    $keyword_str .= " " . $search_keywords[$i] . " ";
                                    break;
                                default:
                                    $keyword_str .= " p.UPC LIKE '%:keywords:%' ";
                                    $keyword_str = $db->bindVars ($keyword_str, ':keywords:', $search_keywords[$i], 'noquotestring');
                                    break;
                            }
                        }
                        $keyword_str .= " ) )";
                        $where_str = str_replace ('))', $keyword_str . ' ))', $where_str);
                    }
                }
                break;
            default:
                break;
        }
    }
}

That code "intercepts" the notifier raised by /includes/modules/pages/advanced_search_result/header_php.php and adds the UPC field in the (already included) products table (aliased as p) to the list of fields to be searched.

[chadlly2003]

lat9

Thank you for the quick response.
I tried your snippet of code but it does not seem to work. When your code is implemented I get a blank page when i do a search.

[lat9]

OK, check your /logs folder. There should be a myDEBUG*.log file that identifies the source of the error. If you'll post that (using the "code" tags # in the posting header), it'll give me something to help.

[chadlly2003]

here is the error report

[05-Jun-2016 13:43:50 America/New_York] PHP Fatal error: Call to a member function bindVars() on a non-object in C:\xampp\htdocs\xxxxxx.com\includes\classes\observers\auto.search_in_upc.php on line 33

[lat9]

Here's the updated version:

<?php
/**
 * @package plugins
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: Designed for v1.5.4  $
 */

class zcObserverSearchInUpc extends base 
{
    public function __construct() 
    {
      $this->attach ($this, array ('NOTIFY_SEARCH_WHERE_STRING'));
    }

    public function update (&$class, $eventID) 
    {
        switch ($eventID) {
            case 'NOTIFY_SEARCH_WHERE_STRING': 
                global $where_str, $keywords, $db;
                if (isset ($keywords) && zen_not_null ($keywords)) {
                    if (zen_parse_search_string (stripslashes ($keywords), $search_keywords)) {
                        $keyword_str = " OR (p.UPC != '' AND (";
                        for ($i=0, $n = sizeof ($search_keywords); $i<$n; $i++ ) {
                            switch ($search_keywords[$i]) {
                                case '(':
                                case ')':
                                case 'and':
                                case 'or':
                                    $keyword_str .= " " . $search_keywords[$i] . " ";
                                    break;
                                default:
                                    $keyword_str .= " p.UPC LIKE '%:keywords:%' ";
                                    $keyword_str = $db->bindVars ($keyword_str, ':keywords:', $search_keywords[$i], 'noquotestring');
                                    break;
                            }
                        }
                        $keyword_str .= " ) )";
                        $where_str = str_replace ('))', $keyword_str . ' ))', $where_str);
                    }
                }
                break;
            default:
                break;
        }
    }
}