Archive for April 2016

Magento2 Json Controller Example

<?php   namespace Imran\Test\Controller\Index;   use \Magento\Framework\App\Action\Action;   class Index extends Action { /** @var \Magento\Framework\View\Result\Page */ protected $resultPageFactory; /** * @param \Magento\Framework\App\Action\Context $context */ public function __construct(\Magento\Framework\App\Action\Context $context, \Magento\Framework\Controller\Result\JsonFactory $resultJsonFactory) { parent::__construct($context); $this->resultJsonFactory = $resultJsonFactory; }   /** * Blog Index, shows a list of recent blog posts. * * @return \Magento\Framework\View\Result\JsonFactory */ public […]

Magento2 Select from Database

<?php … $subscribe = $this->_objectManager->create(’Imran\Test\Model\Subscriber’);   // Get by ID $item = $subscribe->load(19); echo $item->getName();   // Get by Email $subs = $subscribe->getCollection()->addFieldToFilter(’email’, ‘aa@bb.com’);   foreach ($subs as $sub) { var_dump($sub->getData()); } …

Magento2 Select Single Record From Db

<?php … $subscribe = $this->_objectManager->create(’Imran\Test\Model\Subscriber’);   // Method 1 $subs = $subscribe->getCollection()->addFieldToFilter(’email’, ‘aa@bb.com’); var_dump($subs->getFirstItem()->getData());   // Method 2 $subs = $subscribe->getCollection() ->setPageSize(1) ->addFieldToFilter(’email’, ‘aa@bb.com’);   foreach ($subs as $sub) { var_dump($sub->getData()); } …

Magento2 Design Customize

Design customizations kept under: app/design/Vendor/theme/Vendor_Modulename/web/css app/design/Vendor/theme/Vendor_Modulename/layout app/design/Vendor/theme/Vendor_Modulename/templates

Magento2 disable WYSIWYG Cms Editor

Go to Stores -> Configuration -> Content Management -> Enable WYSIWYG Editor: Disabled by Default / Disabled Completely

Magento2 db schema upgrade

1. change setup_version in app/code/Vendor/Module/etc/module.xml 2. run bin/magento setup:db-schema:upgrade

Magento 2 Select from Db in a template

<?php … $om = \Magento\Framework\App\ObjectManager::getInstance();   $connection = $om->create(’\Magento\Framework\App\ResourceConnection’)->getConnection(\Magento\Framework\App\ResourceConnection::DEFAULT_CONNECTION);   $tblSalesOrder = $connection->getTableName(’pinamondo_seotext’); $results = $connection->fetchAll(’SELECT name FROM `’.$tblSalesOrder.’`’);   var_dump($results); …

Remove magento cache

rm $MAGENTO_FOLDER/var/cache/*

Select simple products of configurable product

<?php   $product = Mage::getModel(’catalog/product’)->load(127); $confProduct = Mage::getModel(’catalog/product_type_configurable’)->setProduct($product); $simpleProductsCollection = $confProduct->getUsedProductCollection() ->addAttributeToSelect(’*’) ->addFilterByRequiredOptions(); foreach($simpleProductsCollection as $simpleProduct) { var_dump($simpleProduct->getId()); }