Yamini yamini

Magento Snippets

Download extension manually using pear/mage

Pear for 1.4, mage for 1.5. File downloaded into /downloader/.cache/community/

./pear download magento-community/Shipping_Agent
./mage download community Shipping_Agent

Clear cache/reindex

Data visualization in one of three most important steps in data mining (https://github.com/entaroadun/hnpickup#readme). Often times, it's impossible to understand data without proper visualization. I went looking for great tools to do that.

Two website list recent JS visualization frameworks:

Most of them are available on Github. My three favorite:

https://github.com/DmitryBaranovskiy/g.raphael

Magento Code Snippets

Download extension manually using mage

./mage config-set preferred_state stable
./mage clear-cache
./mage sync
./mage download community Module_Name

This is a list of the SublimeText 2 addons I use for my development environment.

	SET @entityid = '3';

	SELECT ea.attribute_id, ea.attribute_code, eav.value AS 'value', 'varchar' AS 'type'
	FROM catalog_category_entity e
	JOIN catalog_category_entity_varchar eav
	ON e.entity_id = eav.entity_id
	JOIN eav_attribute ea
	ON eav.attribute_id = ea.attribute_id
	WHERE e.entity_id = @entityid
	UNION

	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="utf-8" />
	<title>XXX</title>

	<!-- CSS -->
	<link rel="stylesheet" href="http://code.jquery.com/mobile/1.0a3/jquery.mobile-1.0a3.min.css" />
	<link rel="apple-touch-icon" href="images/XXX.png"/>
	<link rel="apple-touch-startup-image" href="images/XXX-home-screen.png" />

	function hideAddressBar()
	{
	if(!window.location.hash)
	{
	if(document.height < window.outerHeight)
	{
	document.body.style.height = (window.outerHeight + 50) + 'px';
	}

	setTimeout( function(){ window.scrollTo(0, 1); }, 50 );

	<!doctype html>

	<!-- http://taylor.fausak.me/2015/01/27/ios-8-web-apps/ -->

	<html>
	<head>
	<title>iOS 8 web app</title>

	<!-- CONFIGURATION -->

	SELECT b.email, c.value AS name, a.updated_at, d.added_at, d.product_id, e.name, SUM(g.qty_ordered) AS purchased
	FROM `wishlist` AS a
	INNER JOIN customer_entity AS b ON a.customer_id = b.entity_id
	INNER JOIN customer_entity_varchar AS c ON a.customer_id = c.entity_id AND c.attribute_id = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'firstname' AND entity_type_id = b.entity_type_id)
	INNER JOIN wishlist_item AS d ON a.wishlist_id = d.wishlist_id
	INNER JOIN catalog_product_flat_1 AS e ON d.product_id = e.entity_id
	LEFT JOIN sales_flat_order AS f ON f.customer_email = b.email
	LEFT JOIN sales_flat_order_item AS g ON (f.entity_id = g.order_id AND g.sku LIKE CONCAT(e.sku,'%') AND g.product_type = 'simple')
	GROUP BY b.email, c.value, a.updated_at, d.added_at, d.product_id, e.name

	{
	"AWSTemplateFormatVersion": "2010-09-09",

	"Description": "CloudFormation Sample Template for Node.js application. WARNING This template creates an Amazon EC2 instance. You will be billed for the AWS resources used if you create a stack from this template.",

	"Parameters": {
	"InstanceType": {
	"Description": "EC2 instance type",
	"Type": "String",
	"Default": "t1.micro",