Change Search Query String in Magento 1.8 Backend

magento-1.8PHP

In my magento project, I have a requirement where I need to change the user entered query text to something else based on some calculations.

For example, if the user has entered "ABC" in the Global search text field, then

I need to change it to "XYZ" and show the results related to the modified query text i.e "XYZ".
and also the popular terms which are being generated based on the query text should not get modified by the new query text.

User entered text      product collection results      Popular terms/suggestions
=================      ==========================      =========================
ABC                    XYZ                             ABC

I tried to achieve the above by doing many things but didn't get success. One of my attempts is overriding prepare() function in Mage_Catalogsearch_Model_Query Class.

public function prepare()
{
    Mage::log("I am in overriden prepare function");
    if($this->getQueryText() == "ABC"){
        $this->setQueryText("XYZ");
    }
    Mage::log($this->getQueryText());
    if (!$this->getId()) {
        $this->setIsActive(0);
        $this->setIsProcessed(0);
        $this->save();
        $this->setIsActive(1);
    }
    return $this;
}

In the above function, though I am able to change the query text by using setQueryText, I am getting the result product collection based on the user entered query text instead of modified query text.

PS: the above function is just an example of how I am trying to achieve it.

EDIT:

I actually need to do some calculations based on the passed query string. To be precise, I need to look for a colon : in the query string and if there is colon then split the string. After splitting, pass the second part of the string as query string, if and only if the first part of the string is a "category name" or "show" or "some other valid strings choosed by me".

Best Answer

I have solved it!!

but I am not sure whether this is the best approach.

The string manipulation operations can be done at prepareResult function of Mage_CatalogSearch_Model_Resource_Fulltext.

public function prepareResult($object, $queryText, $query)
{
    $adapter = $this->_getWriteAdapter();
    if (!$query->getIsProcessed()) {
        //other code....
    }
}

In the above code, I just called my string manipulation function at function's start and also I commented the if statement i.e if(!$query->getIsProcessed()){ because I had many search terms which were already processed. (old database). So, the modified code is:

public function prepareResult($object, $queryText, $query)
{
    $queryText = $this->doStringManipulations($queryText);
    $adapter = $this->_getWriteAdapter();
    //if (!$query->getIsProcessed()) {
        //other code....
    //}
}

Related Solutions

Magento 1.8 – String Manipulations on Catalogsearch Result URL’s Query

I would try with explode:

list($categoryName, $productName) = explode(':', Mage::app()->getRequest()->getParam('q'));

And when you set this up in the predispatch event, you can just put your category back into $_REQUEST or $_POST, just check the code, where it gets the cat from.

I didn't find any code which reads the cat param, but I think you have tried it? :-)

Magento – how to change custom option price by query in magento

<?php

$magePath = 'app/Mage.php'; 

require_once $magePath;

Varien_Profiler::enable(); 

Mage::setIsDeveloperMode(true); 

ini_set('display_errors', 1);

umask(0);

Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);

$product_ids = array(2);
//Product Id = 2, you can use any product id
$productmodel = Mage::getModel('catalog/product');

foreach ($product_ids as $product_id) { 

/**i use this two arrays for collecte value because i uses inside setData of 
current option*/

$cos=array();
$co=array();

$product = $productmodel->load($product_id);

$options = $product->getProductOptionsCollection();

if (isset($options)) { 

foreach ($options as $o) { 

$title = $o->getTitle();

/**
this block is for changing information of specific option from collection options inside
current product
the save method for this option in end of code
*/

if ($title == "Line 1/Front") { 

$o->setProduct($product); 

$o->setTitle("Line 1/Ftont"); 

$o->setType("drop_down"); 

$o->setIsRequire(1);

$o->setSortOrder(0);


}

/**
this block for update or add information of specific value inside current option
*/

$optionType = $o->getType(); 

//test type

if ($optionType == "drop_down") { 

//getting collection of value related to current option

$values = $o->getValuesCollection(); 

$found = false; 

foreach ($values as $k => $v) { 

//test existing of value for update

if (1 == preg_match("/said$/i", $v->getTitle())) { 

//update and save

$v->setTitle("morad")

->setSku("kk")

->setPriceType("fixed")

->setSortOrder(0)

->setPrice(floatval(13.0000));

$v->setOption($o)->save();

/**
this ligne is important i collecte all value required for normalize save function 
related to current option
*/

$cos[]=$v->toArray($co);

} 
} 


/**
create new value object you can use $option->getValueInstance() for working with 
getSingleton
*/

$value = Mage::getModel('catalog/product_option_value'); 

$value->setOption($o) 

->setTitle('valueiwant') 

->setSku("nn")

->setPriceType("fixed")

->setSortOrder(1)

->setPrice(12)

/**
this ligne is important (relation forigien key) for related this new value
to specific option
*/

->setOptionId($o->getId());

$value->save();

/**
this ligne is important i collecte all value required for normalize save function   
related to current option
*/

$cos[]=$value->toArray($co);
} 


$o->setData("values",$cos)->save();

//var_dump($cos);

}


}
}

Best Answer

Related Solutions

Magento 1.8 – String Manipulations on Catalogsearch Result URL’s Query

Magento – how to change custom option price by query in magento

Related Topic