Backend > Catalog > Manage Categories

We can do the following:

1. Create new root categories and subcategories. You can organize the categories by drag-and-drop.
2. For multi-stores setup, different stores can have difference sets of root category. After a root category is set up, you can associate it to a store in System > Manage Stores.
3. You can show the categories in the menu. Only active categories are shown. You can show the category page with products or without, the contents can be set to a static block. You can set this on the _...

With system config:
+

If that's not what you want, we can do event-observer:

    /**
     * Event 'checkout_cart_product_add_before'
     * @see Mage_Checkout_Model_Cart ::addProduct()
     *
     * @param Varien_Event_Observer $observer
     * @return void
     */
    public function beforeAddToCart(Varien_Event_Observer $observer)
    {
        if (Mage::getSingleton('customer/session')->isLoggedIn()) {
            return;
        }

        /** @var Mage_Catalog_Model_Product $product *...

This whole class Mage_Core_Controller_Varien_Exception has only one reference in the core, see search result.

In the catch, there is a way to redirect or forward or call another action. So how do we make this works? Here's an example:

class Sxxx_Mohe_Model_Observer_Catalog
{
    /**
     * Event 'catalog_controller_category_init_after'
     * @see Mage_Catalog_CategoryController:: _initCategory()
     *
     * Redirect ca...

In backend > Catalog > Manage Categories, we can configure a category page and put it on the main menu. The page contents are rendered in

app\design\frontend\base\default\template\catalog\category\view.phtml

If we want to render an HTML table in which its data are taken from the database, we would follow these steps:

1. Create a custom block mymodule/mytable with template mymodule/mytable.phtml.
2. Whitelist our block for rendering in the frontend: backend > System > Permissions > Blocks
3. Create a CMS static block: backend > CM...

The addition of head elements for Vue are dependent on the helper method which returns a bool.

See app\code\core\Mage\Page\Block\Html\Head.php

<layout>
     <default>
        <reference name="head">
            <action method="addItem">
                <type>js</type>
                <name>lib/vue2611dev.js</name>
                <params />
                <if helper="adminpanel/noVue" />
            </action>
            <action method="addItem">
                <type>skin_css</type>
                <name>css/vue.css</name>
    ...

/**
 * Add attributes to attibute_group 'CAUTION!!! System Config'.
 */
if ($attrs) {
    $resource = Mage::getResourceSingleton('eav/entity_attribute');
    foreach ($customerGroupIds as $groupCode => $groupId) {
        /** @var Scx_ExtendedCustomer_Model_Attribute_Set $set */
        $set = Mage::getModel('extendedcustomer/attribute_set');
        $set->load($groupId, 'apply_to');
        if (!$set->getId()) {
            continue;
        }
        $agId = Mage::getResourceModel('eav/entity_attribute_group_collection')
           ...

Backend > System > Index Management > reindex

1. Product Flat Data (optional)
2. Category Products

Alter the columns:

SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
ALTER TABLE `sales_flat_order_item` CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL COMMENT 'Created At'; 
ALTER TABLE `sales_flat_order_item` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL COMMENT 'Updated At'; 

    public function setOrderByVaccDates($boxId, $direction = self::SORT_ORDER_DESC)
    {
        $case = 'CASE WHEN box_id = ' . $boxId . ' THEN vacc_date ELSE vacc_second_date END';
        $this->setOrder($case, $direction);
        return $this;
    }

ORDER BY 
  CASE 
    WHEN box_id = 376 THEN vacc_date ELSE vacc_second_date 
  END 
  DESC

Add Foreign Key

/** @var Mage_Core_Model_Resource_Setup $installer */
$installer = $this;
$installer->startSetup();
/** @var Varien_Db_Adapter_Pdo_Mysql $connection */
$connection = $installer->getConnection();

$table = $installer->getTable('simple/box');
$column = 'clinic_id';

if (!$connection->tableColumnExists($table, $column)) {
    $connection->addColumn($table, $column, [
        'type'      => Varien_Db_Ddl_Table::TYPE_INTEGER,
        'unsigned'  => true,
        'nullable'  => true,
        'comment'   => 'Clinic Id',
  ...

When there are input elements for search criteria in frontend grid with pagination block 'page/html_pager', the search params will be lost when the user click on page n. This is because the URL links in the pager do not contain the search params. There are 3 solutions:

Do not Use POST in form

<form class="form-list" id="search_form">

Simple JS Solution

This can be fixed easily with js URLSearchParams.append() by appending the search params to t...

To install, just issue the following PowerShell command at the root of OpenMage:

PS D:\Work\project> composer require guzzlehttp/guzzle:^7.0

**Following is deprecated in the latest OpenMage, which will autoload the vendor folder automatically. **

First, take a look at app\Mage.php autoload at lines 54-56:

/* Support additional includes, such as composer's vendor/autoload.php files */
foreach (glob(BP . DS . 'app' . DS . 'etc' . DS . 'includes' . DS . '*.php') as $path) {
    include_once $path;
}

So, we can add a ...

    final public function call($method, $args = [])
    {
        try {
            return $this->_apiCall($method, $args);
        } catch (Custom_Exception $e) {
            throw $e;
        } catch (Throwable $e) {
            throw new Custom_Exception('Unexpected error: '.$e->getMessage(), $e->getCode(), $e);
        }
    }

Define the API in the custom module app\code\local\{vendor}\{module}\etc\api.xml:

<config>
    <api>
        <resources>
            <member translate="title" module="benefit">
                <model>benefit/api_member</model>
                <title>Member API</title>
                <acl>benefit/member</acl>
                <methods>
                    <!-- Element name must be in lower case, see note 1. -->
                    <check_in translate="title" module="benefit">
                        <title>Check-In</title>
         ...

OpenMage

Install the packages in vendor directory in the root by execute shell command: composer update

For wins:

PHP is not recognized as an internal or external command in command prompt

1. Search: Edit the system environment variables
2. Environment Variables ...
3. System variables > Path > Edit ...
4. New
5. Then add D:\Work\wamp64\bin\php\php8.2.5

For Magento 1.9 (Not required for OpenMage)

Create dir vendor in the root and then modify Mage.php:

// in app\Mage.php
// Insert this line or make use of line 57...

There are 2 column types:

// lib\Varien\Db\Ddl\Table.php
    const TYPE_TIMESTAMP        = 'timestamp'; // Capable to support date-time from 1970 + auto-triggers in some RDBMS
    const TYPE_DATETIME         = 'datetime'; // Capable to support long date-time before 1970

All columns are of type Varien_Db_Ddl_Table::TYPE_TIMESTAMP in OpenMage, except for customer_dob and columns in eav datetime tables, which are of type Varien_Db_Ddl_Table::TYPE_DATETIME.

MySQL converts TIMESTAMP values from the current time zone to UTC f...