- 03 Jan 2018, 14:14
#76603
amigos,
gostaria de tirar uma dúvida, a busca procura nas tags? No meu Opencart só busca nos tútulos.
estou usando esse mod xml
-----
<modification>
<id>A More Robust Search Field</id>
<version>1.5.x</version>
<vqmver>0.0.2</vqmver>
<author>wishmedia.ca</author>
<file name="catalog/model/catalog/product.php">
<operation error="abort" info="Add Manufacturer to the Query">
<search position="replace"><![CDATA[$sql .= " LEFT JOIN " . DB_PREFIX . "product_description pd]]></search>
<add><![CDATA[$sql .= " LEFT JOIN " . DB_PREFIX . "manufacturer m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN " . DB_PREFIX . "product_description pd]]></add>
</operation>
<operation error="abort" info="">
<search position="replace"><![CDATA[$implode[] = "pd.name LIKE '%" . $this->db->escape($word) . "%'";]]></search>
<add><![CDATA[
if(strlen($word) > 3 && strpos($word,'s') !== false){
$implode[] = "pd.name LIKE '%" . $this->db->escape(rtrim($word,'s')) . "%'";
$implode[] = "m.name LIKE '%" . $this->db->escape($word) . "%'";
}else{
$implode[] = "pd.name LIKE '%" . $this->db->escape($word) . "%'";
$implode[] = "m.name LIKE '%" . $this->db->escape($word) . "%'";
}
]]></add>
</operation>
<operation error="abort" info="">
<search position="replace"><![CDATA[$sql .= " " . implode(" OR ", $implode) . "";]]></search>
<add><![CDATA[
$sql .= " " . implode(" AND ", $implode) . "";
]]></add>
</operation>
</file>
</modification>
____
gostaria de tirar uma dúvida, a busca procura nas tags? No meu Opencart só busca nos tútulos.
estou usando esse mod xml
-----
<modification>
<id>A More Robust Search Field</id>
<version>1.5.x</version>
<vqmver>0.0.2</vqmver>
<author>wishmedia.ca</author>
<file name="catalog/model/catalog/product.php">
<operation error="abort" info="Add Manufacturer to the Query">
<search position="replace"><![CDATA[$sql .= " LEFT JOIN " . DB_PREFIX . "product_description pd]]></search>
<add><![CDATA[$sql .= " LEFT JOIN " . DB_PREFIX . "manufacturer m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN " . DB_PREFIX . "product_description pd]]></add>
</operation>
<operation error="abort" info="">
<search position="replace"><![CDATA[$implode[] = "pd.name LIKE '%" . $this->db->escape($word) . "%'";]]></search>
<add><![CDATA[
if(strlen($word) > 3 && strpos($word,'s') !== false){
$implode[] = "pd.name LIKE '%" . $this->db->escape(rtrim($word,'s')) . "%'";
$implode[] = "m.name LIKE '%" . $this->db->escape($word) . "%'";
}else{
$implode[] = "pd.name LIKE '%" . $this->db->escape($word) . "%'";
$implode[] = "m.name LIKE '%" . $this->db->escape($word) . "%'";
}
]]></add>
</operation>
<operation error="abort" info="">
<search position="replace"><![CDATA[$sql .= " " . implode(" OR ", $implode) . "";]]></search>
<add><![CDATA[
$sql .= " " . implode(" AND ", $implode) . "";
]]></add>
</operation>
</file>
</modification>
____