OpenMage

Running Unit Test in DDEV There are 3 ways to run a unit test with composer: 1. Basic Composer PHPUnit...

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

magento.stackexchange.com

Add a Custom Column in sales_flat_order_grid by Layout Update skus SKUs skus status Join a Column in...

There are 3 machines: Local Computer Windows OS Development Server Production Server There are 3 repositories upstream, a fork of...

OpenMage
manual.zfdes.com

For read and write adapters, fetchOne(), fetchAll(), fetchAssoc(), fetchRow(), fetchCol(), fetchPairs(), see lib\Zend\Db\Adapter\Abstract.php Also, standalone class...

Alter the columns: SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE...

OpenMage

Add Foreign Key /** @var Mage_Core_Model_Resource_Setup $installer */ $installer = $this; $installer->startSetup(); /** @var Varien_Db_Adapter_Pdo_Mysql...

OpenMage
github.com

nginx URL rewrite stackoverflow PHP lib M1 Extension and the blog, version 2. API Implementation Doc Client based on ZF1...

OpenMage

There are 2 column types: // lib\Varien\Db\Ddl\Table.php const TYPE_TIMESTAMP = 'timestamp'; // Capable to support date-time from...

This doesn't work: ->addColumn('name', Varien_Db_Ddl_Table::TYPE_TEXT, 200, array( 'nullable' => false, 'collate' => 'utf8mb4_unicode_ci...

OpenMage

Change Text Length /** @var Mage_Core_Model_Resource_Setup $installer */ $installer = $this; $installer->startSetup(); /** @var Varien_Db_Adapter_Pdo_Mysql...

OpenMage
framework.zend.com

OM uses Zend Version 1.12.16. Adding Another Table to the Query with JOIN Many useful queries involve using a JOIN...

OpenMage

DO NOT use inline translation. The inline translations are stored in the table core_translate. Backup the table, convert all...

OpenMage
github.com

See production grade nginx and docker config here. Some notes on this: the PCI work was trial and error, we...

stackoverflow.com

Get the last entry of each applicant in history table: $installer = $this; $db = $installer->getConnection(); $table = $installer->getTable('table/name');

If the custom options of a product are the same across stores, but somehow there are not defaulted to store...

When a block directive, double curly brackets: {{block type="module/block"}} is called in the static block, it is necessary to...

custom module productcoption config.xml 0.0.1 Somemod_ProductCoption Somemod_ProductCoption_Block Somemod_ProductCoption_Block_Adminhtml_ProductEditTabOptions_Option Somemod_ProductCoption_Block_Adminhtml...

OpenMage

How to update a column in main table from another table's column. Reference: Varien_Db_Adapter_Pdo_Mysql::updateFromSeelct...

OpenMage

$collection->addFieldToFilter('field_name', [ ['eq' => 'value1'], ['eq' => 'value2'] ] ); // same as $collection->addFieldToFilter('field_name', ['value1', 'value2']);

OpenMage

condA AND (cond1 OR cond2 OR cond3) $cincId = $session->getCustomerId(); $attributes = array( array('attribute'=>'mc_by', 'eq'=>$clinicId), array('attribute...

Best results in other decks

Performing COUNT(*) on large tables is slow. Sometimes you don’t need the exact number once results exceed a certain...

Search in all decks