JoshvaR88 / Category.sql

Last active August 29, 2015 14:24 — forked from ticean/Category.sql

	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

JoshvaR88 / Category.sql

Last active August 29, 2015 14:24 — forked from ticean/Category.sql

	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

JoshvaR88 / gist:5c5ad39775cc0346f27e

Last active August 29, 2015 14:25 — forked from phillro/gist:1193227

Elasticsearch autocomplete example with cross origin resource sharing

	<html>
	<head>
	<link rel="stylesheet" href="/examples/stylesheets/ui-lightness/jquery-ui-1.8.16.custom.css" type="css">
	<script type="text/javascript" src="/examples/javascripts/jquery.min.js"></script>
	<script type="text/javascript" src="/examples/javascripts/jquery.base64.min.js"></script>
	<script type="text/javascript" src="/examples/javascripts/jquery-ui-1.8.16.custom.min.js"></script>
	<script type="text/javascript" src="/examples/javascripts/jquery.tmpl.min.js"></script>
	</head>

	<body>

JoshvaR88 / ElasticSearch.sh

Last active August 29, 2015 14:27 — forked from ricardo-rossi/ElasticSearch.sh

Installing ElasticSearch on Ubuntu 14.04

	### USAGE
	###
	### ./ElasticSearch.sh 1.5.0 will install Elasticsearch 1.5.0
	### ./ElasticSearch.sh 1.4.4 will install Elasticsearch 1.4.4
	### ./ElasticSearch.sh will fail because no version was specified (exit code 1)
	###
	### CLI options Contributed by @janpieper
	### Check http://www.elasticsearch.org/download/ for latest version of ElasticSearch

	### ElasticSearch version

JoshvaR88 / es.sh

Last active August 29, 2015 14:27 — forked from Globegitter/es.sh

Easy install for elasticsearch on Ubuntu 14.04

	cd ~
	##If you want to install OpenJDK
	#sudo apt-get update
	#sudo apt-get install openjdk-8-jre-headless -y

	###Or if you want to install Oracle JDK, which seems to have slightly better performance
	sudo add-apt-repository ppa:webupd8team/java
	sudo apt-get update
	sudo apt-get install oracle-java8-installer

JoshvaR88 / style.scss

Last active August 29, 2015 14:27 — forked from daz/style.scss

Bootstrap styling for jQuery UI autocomplete

	.ui-autocomplete {
	position: absolute;
	top: 100%;
	left: 0;
	z-index: 1000;
	float: left;
	display: none;
	min-width: 160px;
	_width: 160px;
	padding: 4px 0;

JoshvaR88 / spree-postgres

Last active August 29, 2015 14:27

Setting up a new Spree app with Postgres

	create new rails app:

	$ rails new store_name -d postgresql

	in postgres:

	$ psql -U postgres
	$ create role store_name login createdb;

	create databases:

JoshvaR88 / nginx-403-forbidden-error-hosting-in-user-home-directory.md

Created October 6, 2015 07:08 — forked from jhjguxin/nginx-403-forbidden-error-hosting-in-user-home-directory.md

nginx 403 forbidden error when server static file under user home directory

nginx 403 Forbidden Error hosting in User Home Directory

resources

runtime environment

JoshvaR88 / add_sorting_to_your_taxon_page_in_spree.md

Created October 27, 2015 09:21 — forked from Whelton/add_sorting_to_your_taxon_page_in_spree.md

Add sorting to your taxon page in Spree (based off: http://berk.es/2015/05/09/add-sorting-to-your-product-page-in-spree/)

Add sorting to your product taxon page in Spree

So in following @berkes 'Add sorting to your product page in Spree' guide, I tried to repeat with my taxons controller. However there was no difference in order, despite the scopes being applied.

Another commenter Adam shared my frustration: 'How would I make this work for taxons as well? Everything I try doesn't work'.

After a little bit of research, I figured it out.

TL;DR

JoshvaR88 / Spree: Filter by brand.md

Created October 27, 2015 09:21 — forked from maxivak/Spree: Filter by brand.md

Spree: Filter Products by properties

Fix 'scoped' error for Rails 4

error: undefined method 'scoped' solution:

# config/initializers/scoped.rb
class ActiveRecord::Base
  # do things the modern way and silence Rails 4 deprecation warnings
 def self.scoped(options=nil)

options ? where(nil).apply_finder_options(options, true) : where(nil)