Ansyori's Blog – Indonesian Magento Developer

Published May 9, 2024

My Android Games

My games no longer listed on Google Playstore 😢😭, but you can find on other platform 🥳😁, please take a look at this link https://apkpure.com/id/developer/Zaidan%20Lab

Continue reading My Android Games

Comments closed

Published December 7, 2023

Magento 2 : Disable ElasticSearch, Switch Search Engine to MySql (legacy)

End of year 2023 composer config repositories.mysqlsengine git https://github.com/swissup/module-search-mysql-legacy.git composer require swissup/module-search-mysql-legacy –prefer-source –ignore-platform-reqs php bin/magento setup:upgrade –safe-mode=1 php bin/magento setup:di:compile php bin/magento cache:flush php…

Continue reading Magento 2 : Disable ElasticSearch, Switch Search Engine to MySql (legacy)

Comments closed

Published December 19, 2022

[Magento 2] Get Salable Qty By SKU

publicfunction __construct( \Magento\Store\Model\StoreManagerInterface $storeManager, \Magento\CatalogInventory\Api\StockStateInterface $stockState, \Magento\CatalogInventory\Api\StockRegistryInterface $stockRegistry ){ $this->storeManager = $storeManager; $this->stockState = $stockState; $this->stockRegistry = $stockRegistry; } public function getSalableQtyByPID($product) $websiteId = $this->storeManager->getStore()->getWebsiteId();…

Continue reading [Magento 2] Get Salable Qty By SKU

Comments closed

Published March 2, 2022

Ignore git file(s) without .gitignore (local only)

This is affects on local only git update-index –assume-unchanged /path/to/file or git update-index –assume-unchanged /path/to/files/* or register files path into .git/info/exclude

Continue reading Ignore git file(s) without .gitignore (local only)

Comments closed

Published January 7, 2021

Magento 2 : Controller Return XML or JSON

here’s example M2 controller serve XML or JSON public function __construct( \Magento\Framework\App\Action\Context $context, \Magento\Framework\Controller\Result\RawFactory $resultPageFactory ) { $this->resultPageFactory = $resultPageFactory; parent::__construct($context); } public function execute()…

Continue reading Magento 2 : Controller Return XML or JSON

Comments closed

Published August 12, 2020

[Linux] Connect to Mysql through SSH Tunnel

let’s say you’re going to connect to mysql database server but the database not open to public (security reason), there is workaround to perform this…

Continue reading [Linux] Connect to Mysql through SSH Tunnel

Comments closed

Published July 8, 2020

[PHP] Debug Print Call Stack

Let’s say you lost in the middle of a method and difficult to trace which other methods call the current method, you can debug or back trace…

Continue reading [PHP] Debug Print Call Stack

Comments closed

Published January 21, 2020

[Ubuntu] Setup https on localhost

install required library apt install libnss3-tools -y download, give permission & copy/move to bin folder: wget https://github.com/FiloSottile/mkcert/releases/download/v1.1.2/mkcert-v1.1.2-linux-amd64chmod +x mkcert-v1.1.2-linux-amd64cp mkcert-v1.1.2-linux-amd64 /usr/local/bin/mkcert Generate local CA sudo…

Continue reading [Ubuntu] Setup https on localhost

Comments closed

Published September 10, 2019

Magento 2 : Admin Ajax Upload File

Here’s steps how to create custom ajax upload file in admin page create controller file

Continue reading Magento 2 : Admin Ajax Upload File

Comments closed

Published May 30, 2019

Magento2 : Create Custom Cache to Reduce Server Load

Intro from wikipedia: A web cache (or HTTP cache) is an information technology for the temporary storage (caching) of Web documents, such as web pages, images, and other types of Web multimedia, to reduce server lag.…

Continue reading Magento2 : Create Custom Cache to Reduce Server Load

Comments closed

Published February 20, 2019

M2 : Override/Intercept REST API POST params

ok then in your di.xml <?xml version=”1.0″ ?> <config xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xsi:noNamespaceSchemaLocation=”urn:magento:framework:ObjectManager/etc/config.xsd”> <type name=”Magento\Webapi\Controller\Rest\Router”> <plugin disabled=”false” name=”YourModule_ModuleName_Plugin_Magento_Webapi_Controller_Rest_Router” sortOrder=”10″ type=”YourModule\ModuleName\Plugin\Magento\Webapi\Controller\Rest\Router”/> </type> </config> and then finally, use plugin …

Continue reading M2 : Override/Intercept REST API POST params

Comments closed

Published December 25, 2018

Magento : Add WYSIWYG Editor in Custom Module

step-1 Go to following path and open Edit.php app\code\local\Namespace\Modulename\Block\Adminhtml\Modulename\Edit.php and Add this Function protected function _prepareLayout() { // Load Wysiwyg on demand and Prepare layout…

Continue reading Magento : Add WYSIWYG Editor in Custom Module

[Linux]Change PHP Cli Version

just an example, upgrade php cli version to php 7.1, make sure you have sudo right sudo rm /usr/bin/php sudo ln -s /opt/plesk/php/7.1/bin/php /usr/bin/php or…

Continue reading [Linux]Change PHP Cli Version

Comments closed

Published November 12, 2018

Knockoutjs: populate json url data to select options

Today this thing got me frustrated, let’s straight to the main problem, before I forget create js function to load from an URL contains json…

Continue reading Knockoutjs: populate json url data to select options

Comments closed

Published August 13, 2018

[Linux/Nginx]Block unwated bot

first to view current number of connection, use this command ss -p | grep nginx | grep -i estab | wc -l if the number…

Continue reading [Linux/Nginx]Block unwated bot

Comments closed

Published August 6, 2018

[Magento 2]Install via Composer out of memory

php -d memory_limit=-1 `which composer` require msp/recaptcha:2.0.0 or php -d memory_limit=-1 /usr/local/bin/composer require msp/recaptcha:2.0.0 simple af

Continue reading [Magento 2]Install via Composer out of memory

Comments closed

Published August 2, 2018

[Linux] How to list IP who successful & failed login into server by ssh

for failed login attempt, use this awk ‘/Failed/ {x[$(NF-3)]++} END {for (i in x){printf “%3d %s\n”, x[i], i}}’ /var/log/auth.log | sort -nr and then for…

Continue reading [Linux] How to list IP who successful & failed login into server by ssh

Comments closed

Published July 25, 2018

[Magento 2] Developer mode but static page not linked with modules/theme

when your magento on developer mode, but you still have to deploy static content each time you made some changes on static files such as…

Continue reading [Magento 2] Developer mode but static page not linked with modules/theme

Comments closed

Published July 25, 2018

Fixed Varnish Issue, not listen on port 80 (Ubuntu)

you already modified /etc/default/varnish, but still not working? then you have to edit following file nano /lib/systemd/system/varnish.service change : ExecStart=/usr/sbin/varnishd -j unix,user=vcache -F -a :80…

Continue reading Fixed Varnish Issue, not listen on port 80 (Ubuntu)

Comments closed

Published June 28, 2018

[Magento 2] Add Multiple Products Programatically

protected $formKey; protected $cart; protected $product; protected $session; public function __construct(MagentoFrameworkSessionSessionManagerInterface $session, MagentoFrameworkAppActionContext $context, MagentoFrameworkDataFormFormKey $formKey, MagentoCheckoutModelCart $cart, MagentoCatalogModelProduct $product, array $data = []) {…

Continue reading [Magento 2] Add Multiple Products Programatically

Comments closed

Published May 27, 2018

Ubuntu : SSH Login with pem file

ssh -i yourkey.pem serverusername@server-ip filezilla : Edit (Preferences) > Settings > Connection > SFTP, Click “Add key file” that’s it

Continue reading Ubuntu : SSH Login with pem file

Comments closed

Published May 7, 2018

My First React Native App

my first app build use React Native, https://play.google.com/store/apps/details?id=com.ansyori.todoappv2 horray

Continue reading My First React Native App

Comments closed

Published February 18, 2018

Magento2 : Custom Sql Directive

$objectManager = \Magento\Framework\App\ObjectManager::getInstance(); // Instance of object manager $resource = $objectManager->get(‘Magento\Framework\App\ResourceConnection’); $connection = $resource->getConnection(); $tableName = $resource->getTableName(‘your_table_name’); //Select Data from table $sql = “Select *…

Continue reading Magento2 : Custom Sql Directive

Comments closed

Published January 8, 2018

Magento2 : Sql query to get product attribute value

select a.*, mapping_id.value as attribute_value from catalog_product_entity as a, catalog_product_entity_varchar as attribute_table where attribute_table.entity_id = a.entity_id and attribute_table.attribute_id = (select attribute_id from eav_attribute where attribute_code…

Continue reading Magento2 : Sql query to get product attribute value

Comments closed

Published May 24, 2017

[Magento]Delete Log Files Programatically

$dir = Mage::getBaseDir(‘var’) ; unlink($dir.’/log/exception.log’); unlink($dir.’/log/system.log’); be careful, you can also delete other files :p

Continue reading [Magento]Delete Log Files Programatically

Comments closed

Published May 8, 2017

[Magento 2] Run PHP code externally

here example to load sales order data externally in magento 2, for example you’re going to use this url http://yourmagento2url/test.php <?php use Magento\Framework\App\Bootstrap; require __DIR__…

Continue reading [Magento 2] Run PHP code externally

Comments closed

Published April 28, 2017

[Magento 2] Dirty Way to Create Own Log File

Yes, it’s dirty…not a Magento 2 standard… so it just for who love ‘shortcut’ way to create own log file, let’s get started <?php namespace…

Continue reading [Magento 2] Dirty Way to Create Own Log File

Comments closed

Published April 13, 2017

How to Apply Your Website Theme Color in Android Chrome

Have you ever try open some website from chrome mobile like facebook, instagram or other websites.. (actually i forgot ..haha..sorry) then you notice, the color…

Continue reading How to Apply Your Website Theme Color in Android Chrome

Comments closed

Published March 24, 2017

[Magento] Update category attributes programmatically

here you go $resource = Mage::getResourceModel(‘catalog/category’); $collection = Mage::getModel(‘catalog/category’)->getCollection(); foreach($collection as $category) { $category->setStoreId(0); // 0 for default scope (All Store Views) $category->setData(‘page_layout’, ‘two_columns_left’); $resource->saveAttribute($category,…

Continue reading [Magento] Update category attributes programmatically

Comments closed

Published February 27, 2017

Magento : SQL Directive to Get Products with attributes

here the sql… select entity_id, sku, ( select value from catalog_product_entity_int as y where attribute_id = (select attribute_id from eav_attribute where attribute_code = ‘status’ and…

Continue reading Magento : SQL Directive to Get Products with attributes

Comments closed

Published February 3, 2017

Magento 2 : Create Admin User From Shell

use SSH to perform this action, from your Magento root, use this command php bin/magento admin:user:create –admin-firstname=”Admin Fistname” –admin-lastname=”Admin Lastname” –admin-user=”admin_username” –admin-password=”admin_pass” –admin-email=”[email protected]”

Continue reading Magento 2 : Create Admin User From Shell

Comments closed

Published January 31, 2017

Magento 2 : Update EAV Attribute

for example, we want to change ‘label’ and ‘sort order’ attribute ‘postcode’ from ‘customer_address’ attribute type, here upgrade data script <?php namespace MyCompany\MyModule\Setup; use Magento\Customer\Setup\CustomerSetupFactory; use…

Continue reading Magento 2 : Update EAV Attribute

Comments closed

Published January 31, 2017

Magento 2 : Override HTML Template from Module

let’s say you want override this html template from your custom module (not from your custom theme) vendor\magento\module-checkout\view\frontend\web\template\shipping.html first, create a module, for example module…

Continue reading Magento 2 : Override HTML Template from Module

Comments closed

Published January 30, 2017

Magento 2 : Add Customer Address Attribute

in your ‘Company/Modulename/setup/InstallData.php’ here example code <?php namespace Company\Modulename\Setup; use Magento\Framework\Setup\InstallDataInterface; use Magento\Framework\Setup\ModuleContextInterface; use Magento\Framework\Setup\ModuleDataSetupInterface; use Magento\Customer\Model\Customer; use Magento\Customer\Setup\CustomerSetupFactory; class InstallData implements InstallDataInterface { private…

Continue reading Magento 2 : Add Customer Address Attribute

Comments closed

Published December 5, 2016

Magento : Add external JS & CSS from layout

here example layout script how to add external JS & CSS link use Magento way 😉 <reference name=”head”> <block type=”core/text” name=”your_external_url”> <action method=”setText”> <text><![CDATA[ <!–…

Continue reading Magento : Add external JS & CSS from layout

Comments closed

Published October 18, 2016

Magento : Disable Logging & Report

i found a nice tips to improve db performance & save some db space, by disabling Magento logs & report here the local.xml settings …

Continue reading Magento : Disable Logging & Report

Comments closed

Published September 21, 2016

Magento : Filter product collection by multiple categories

this is an interesting post i found on StackExchange, how to filter product collection by multiple categories, here the code $productCollection = Mage::getModel(‘catalog/product’) ->getCollection()…

Continue reading Magento : Filter product collection by multiple categories

Comments closed

Published August 10, 2016

Magento : Quick debug for template path hint & block

As a Magento Developer I think this is the best feature on magento to locate template file path & block type. Now I will show…

Continue reading Magento : Quick debug for template path hint & block

Comments closed

Published April 23, 2016

Magento : Add New Attribute & Attribute Set Programatically

Here short script to add new attributes & attributes set <?php require_once(‘app/Mage.php’); //Path to Magento umask(0); Mage::app(); function validateAttr($attr_name) { $attributeInfo = Mage::getResourceModel(‘eav/entity_attribute_collection’) ->setCodeFilter($attr_name)…

Continue reading Magento : Add New Attribute & Attribute Set Programatically

Comments closed

Published March 1, 2016

CSS: Disable CSS Animations

below css code, to disable any related to css animation /*CSS transitions*/ -o-transition-property: none !important; -moz-transition-property: none !important; -ms-transition-property: none !important; -webkit-transition-property: none !important; transition-property: none…

Continue reading CSS: Disable CSS Animations

Comments closed

Published February 29, 2016

CSS: Styling Scroll Bar

let say you want to styling overflow div bar, here example css .yourdiv::-webkit-scrollbar { background:red; width:5px; } .yourdiv::-webkit-scrollbar-track { background-color: #eaeaea; border-left: 1px solid #ccc;…

Continue reading CSS: Styling Scroll Bar

Comments closed

Published January 29, 2016

Magento : Change Shipping Price After Save Shipping Method

it took couple days to figure this ‘shit’ out i assume you already understand how to create custom shipping method extension, for example on your…

Continue reading Magento : Change Shipping Price After Save Shipping Method

Comments closed

Published January 21, 2016

Simple PHP Script to List & Kill Current Mysql Process

here we go <?php @mysql_connect(“you-db-host”,”username”,”password”); if(isset($_GET[‘kill’])): mysql_unbuffered_query(‘kill ‘.$_GET[‘kill’]); echo ‘<h1>Process Id : ‘.$_GET[‘kill’].’ has been terminated</h1>’; endif; $sql = ‘show full processlist’; echo ‘ <style>…

Continue reading Simple PHP Script to List & Kill Current Mysql Process

Comments closed

Published January 12, 2016

Magento : Get product collection has tier price only

here my script get product collection who has tier price only!!!!!!!!!!!!!!!!!! of course also in stock :p $prefix = Mage::getConfig()->getTablePrefix(); $sql = ‘select distinct entity_id…

Continue reading Magento : Get product collection has tier price only

Comments closed

Published January 12, 2016

Filter Payment & Shipping Method on Checkout Page

To filter Payment Method Options we can use observer, i assume you have knowledge of Magento module development, anyway let’s begin on config.xml, register an event…

Continue reading Filter Payment & Shipping Method on Checkout Page

Comments closed

Published December 16, 2015

Create Magento 2 Module (Controller) Part II

here step how to working with controller, i will create 2 controllers file, my objective is, to run following url http://127.0.0.1/magento21/index.php/hellomagentoworld/index/index and http://127.0.0.1/magento21/index.php/hellomagentoworld/index/test create file app\code\Ansyori\HelloWorld\etc\frontend\routes.xml…

Continue reading Create Magento 2 Module (Controller) Part II

Comments closed

Published December 16, 2015

Create Magento 2 Module (Basic) Part I

here my first step to understanding magento 2 module development by create hello world extension, haha: create file app/code/Ansyori/HelloWorld/etc/module.xml here module.xml file content <?xml version=”1.0″?> <config…

Continue reading Create Magento 2 Module (Basic) Part I

Comments closed

Published November 18, 2015

Magento : Create Fake POST

$array_post = array( ‘var1’=>’content1’, ‘var2’=>’content2’, ); $array_post = http_build_query($array_post); $opts = array(‘http’ => array( ‘method’ => ‘POST’, ‘header’ => ‘Content-type: application/x-www-form-urlencoded’, ‘content’ => $array_post )…

Continue reading Magento : Create Fake POST

Comments closed

Published November 18, 2015