In the module's config.xml:

    <global>
        <resources>
            <tpa_setup>
                <setup>
                    <module>Vendor_Tpa</module>
                </setup>
            </tpa_setup>
            <bot_db>
                <connection>
                    <host><![CDATA[subdomain.rds.aws.com]]></host>
                    <username><![CDATA[some_name]]></username>
                    <password><![CDATA[some_pw]]></password>
                    <dbname><![CDATA[some_db_name]]></dbname>
                    <model>mysql4</model>
                    <type>pdo_mysql</type>
                    <active>1</active>
                </connection>
            </bot_db>
        </resources>
        <!-- ... -->
     </global>

To access:

        /** @var Varien_Db_Adapter_Pdo_Mysql $connection */
        $connection = Mage::getSingleton('core/resource')->getConnection('bot_db');
        $select = $connection->select()
            ->from(
                'table_name',
                [
                    'code' => 'drug_id',
                    'name' => 'description',
                    'unit_price' => 'unit_price',
                    'max_qty' => 'max_quantity',
                    'updated_at' => 'updated_at'
                ]
            )
            ->where('drug_id IN (?)', array_column($items, 'code'));
        $rows = $connection->fetchAssoc($select);

magento.stackexchange.com

kiatng

Say thanks

Last edit

12 months ago

kiatng

validation.js

/*
* Really easy field validation with Prototype
* http://tetlaw.id.au/view/javascript/really-easy-field-validation
* Andrew Tetlaw
* Version 1.5.4.1 (2007-01-05)
*
* Copyright (c) 2007 Andrew Tetlaw
* Permission is hereby granted, free of c...

How to use cache in OpenMage / Magento 1.x to speed things up

Mechanism: cache in model

First, save the cache

// app\code\core\Mage\Core\Model\App.php Mage_Core_Model_App
/**
 * Saving cache data
 *
 * @param   mixed $data
 * @param   string $id
 * @param   array $tags
 * @param null|false|int ...

Form Field

A sample of different options to add field in Mage_Adminhtml_Block_Widget_Form

Ref Varien_Data_Form_Element_Abstract lib\Varien\Data\Form\Element\Abstract.php

Add Suffix to Element Names

$form = new Varien_Data_Form(['field_name_...

Add Custom API

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>
          ...

Add new input type in product custom options

custom module productcoption
config.xml

<config>
    <modules>
        <Somemod_ProductCoption>
            <version>0.0.1</version>
        </Somemod_ProductCoption>
    </modules>
    <global> 
        <resources>
            <productcopti...

How to Add Guzzle Package Using Composer.

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 automa...

Adminhtml JSON Response Body

HTML

public function visibleProductsAction()
{
    $this->getResponse()->setBody(
        $this->getLayout()->createBlock('module/adminhtml_block_type')->toHtml()
    );
}

Generic Block:

$block = $this->getLayout()->createBloc...

Programmaticaly add attributes to attribute group

/**
 * Add attributes to attibute_group 'CAUTION!!! System Config'.
 */
if ($attrs) {
    $resource = Mage::getResourceSingleton('eav/entity_attribute');
    foreach ($customerGroupIds as $groupCode => $groupId) {
        /** @var Scx_Exten...

Posted by kiatng to OpenMage (2023-05-22 01:46)

How to add a new DB connection

Related cards:

Mechanism: cache in model

First, save the cache

Add Suffix to Element Names

Column Types

HTML