Categorías y Subcategorías en el TOP de OpenCart

<modification>
    <id>vQmod - vqmod_all_category_on_top</id>
    <version>1.0</version>
    <vqmver>2.4.1</vqmver>
    <author>jroridriguez</author>

    <file name="catalog/controller/common/header.php">
        <operation>
            <search position="replace" index="1">
                <![CDATA[
                    $categories = $this->model_catalog_category->getCategories(0);
                ]]>
            </search>
            <add>
                <![CDATA[
                    $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "category c LEFT JOIN " . DB_PREFIX . "category_description cd ON (c.category_id = cd.category_id) LEFT JOIN " . DB_PREFIX . "category_to_store c2s ON (c.category_id = c2s.category_id) WHERE  cd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND c2s.store_id = '" . (int)$this->config->get('config_store_id') . "'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)");
                    
                    $categories = $query->rows;
                ]]>
            </add>
        </operation>
    </file>
</modification>