In Opencart Admin panel, this is an Autocomplete function for entry of product attributes. When user types in something into the text field of product attribute, a word box of defined product attributes will appear below the field to let user click that wanted to save the typing time.
However, if the user does not click the word box and type a complete word by oneself, the Opencart system will not save the product attribute data the user types. In fact, the Autocomplete function wanted to prevent user inputting undefined product attributes. In other words, the system does not record what the user types but just detects which item the user clicks in the word box. The Autocomplete function is user-unfriendly, especially there are many product attributes defined.
To simplify the entry of product attributes, I have programmed a vQmod plug-in to change the text field into drop-down list so that the user does not need to type anything.
If vQmod have been installed in your Opencart system, click the below fish and save the XML script into the directory [vqmod/xml].
<p>
<!--<br />
Make sure that you have properly installed Opencart vQmod.<br />
Copy this page of script.<br />
Save as a .xml file of utf-8 encoding without BOM into the directory [vqmod/xml].<br />
Name the file as you like.<br />
--></p>
<pre contenteditable="true">
<?xml version="1.0" encoding="utf-8"?>
<modification>
<id>Display attribute choices of products in drop-down list</id>
<version>1.1.0</version>
<author>Flexidigi Solution Ltd.</author>
<file name="admin/model/catalog/product.php">
<operation>
<search position="after"><![CDATA[class ModelCatalogProduct extends Model {]]></search>
<add><![CDATA[
public function get_all_attribute_names() {
$query = $this->db->query("SELECT attribute_group_id, attribute_id , name FROM " . DB_PREFIX . "attribute_description NATURAL JOIN " . DB_PREFIX . "attribute WHERE language_id = '" . (int)$this->config->get('config_language_id') . "' order by attribute_group_id DESC");
return $query->rows;
}
public function get_all_attribute_group_names() {
$query = $this->db->query("SELECT attribute_group_id , name FROM " . DB_PREFIX . "attribute_group_description WHERE language_id = '" . (int)$this->config->get('config_language_id') . "' order by attribute_group_id DESC");
return $query->rows;
}
]]></add>
</operation>
</file>
<file name="admin/controller/catalog/product.php">
<operation>
<search position="after"><![CDATA[private function getForm() {]]></search>
<add><![CDATA[
$this->data['attribute_names'] = array();
$results = $this->model_catalog_product->get_all_attribute_names();
foreach ($results as $result) {
$this->data['attribute_names'][] = array(
'name' => $result['name'],
'attribute_id' => $result['attribute_id'],
'attribute_group_id' => $result['attribute_group_id']);
}
$this->data['attribute_group_names'] = array();
$results = $this->model_catalog_product->get_all_attribute_group_names();
foreach ($results as $result) {
$this->data['attribute_group_names'][] = array(
'name' => $result['name'],
'attribute_group_id' => $result['attribute_group_id']);
}
]]></add>
</operation>
</file>
<file name="admin/view/template/catalog/product_form.tpl">
<!-- Show all existing Product attributes -->
<operation>
<search position="before" offset="1"><![CDATA[<div id="tab-option">]]></search>
<add><![CDATA[
<aside>
<header style="margin-right: 3em;float:left;font-size:1.5em"><?php echo $entry_attribute; ?></header>
<?php foreach ($attribute_group_names as $all_attribute_group){ ?>
<details style="border:#6FF solid thin; margin-right: 3em; padding:1em;float:left;">
<summary style="text-decoration:underline;"><?php print($all_attribute_group['name']); ?></summary>
<ul style="list-style-type:none;" title="<?php echo $all_attribute_group['name']; ?>">
<?php foreach ($attribute_names as $all_attribute){
if($all_attribute['attribute_group_id']==$all_attribute_group['attribute_group_id']) { ?>
<li><?php print($all_attribute['name']); ?></li>
<?php } } ?>
</ul>
</details>
<?php } ?>
</aside>
]]></add>
</operation>
<operation>
<search position="replace"><![CDATA[<input type="text" name="product_attribute[' + attribute_row + '][name]"]]></search>
<add><![CDATA[';
html += '<select title="Product attributes" name="product_attribute[' + attribute_row + '][name]" onchange="document.getElementsByName(\'product_attribute[' + attribute_row + '][attribute_id]\')[0].value=this.options[this.selectedIndex].value;">';
html += '<option value="" selected="selected"><?php echo $text_select; ?></option>';
<?php foreach ($attribute_group_names as $all_attribute_group){ ?>
html += '<optgroup label="<?php echo $all_attribute_group['name']; ?>">';
<?php foreach ($attribute_names as $all_attribute){
if($all_attribute['attribute_group_id']==$all_attribute_group['attribute_group_id']) { ?>
html += '<option value="<?php echo $all_attribute['attribute_id']; ?>"><?php print($all_attribute['name']); ?></option>';
<?php } } ?>
html += '</optgroup>';
<?php } ?>
html += ' </select>';
html += '<input style="visibility:hidden" list="attribute_list" type="text" name="product_attribute[' + attribute_row + '][name]"]]></add>
</operation>
</file>
</modification>
</pre>
