Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Comma seperated list of whatever you want - That's what its for.
<div class="checkbox">
<label class="checkbox-inline">
{% if sub_category %}
<input type="checkbox" name="sub_category" value="1" checked="checked" />
{% else %}
<input type="checkbox" name="sub_category" value="1" />
{% endif %}
{{ text_sub_category }}</label>
</div>
<div class="checkbox">
<label class="checkbox-inline">
{% if description %}
<input type="checkbox" name="description" value="1" id="description" checked="checked" />
{% else %}
<input type="checkbox" name="description" value="1" id="description" />
{% endif %}
{{ entry_description }}</label>
</div>
In order to have as searching criteria the description and the model, i would like to replace the sub_category but i don't understand if there is a variable for the model and which. Could you provide any suggestions?
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Code: Select all
if (!empty($data['filter_name'])) {
$sql .= " OR LCASE(p.model) = '" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "'";
$sql .= " OR LCASE(p.sku) = '" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "'";
$sql .= " OR LCASE(p.upc) = '" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "'";
$sql .= " OR LCASE(p.ean) = '" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "'";
$sql .= " OR LCASE(p.jan) = '" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "'";
$sql .= " OR LCASE(p.isbn) = '" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "'";
$sql .= " OR LCASE(p.mpn) = '" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "'";
}
DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
https://www.youtube.com/watch?v=zXIxDoCRc84
Now that the issue has been solved, please add: [SOLVED] at the beginning of the subject line on your first post.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Users browsing this forum: Amazon [Bot], Bing [Bot], jrr, Majestic-12 [Bot] and 27 guests