Skip to content

Instantly share code, notes, and snippets.

a:8:{s:12:"attribute_id";a:14:{s:11:"SCHEMA_NAME";N;s:10:"TABLE_NAME";s:22:"customer_eav_attribute";s:11:"COLUMN_NAME";s:12:"attribute_id";s:15:"COLUMN_POSITION";i:1;s:9:"DATA_TYPE";s:8:"smallint";s:7:"DEFAULT";N;s:8:"NULLABLE";b:0;s:6:"LENGTH";N;s:5:"SCALE";N;s:9:"PRECISION";N;s:8:"UNSIGNED";b:1;s:7:"PRIMARY";b:1;s:16:"PRIMARY_POSITION";i:1;s:8:"IDENTITY";b:0;}s:10:"is_visible";a:14:{s:11:"SCHEMA_NAME";N;s:10:"TABLE_NAME";s:22:"customer_eav_attribute";s:11:"COLUMN_NAME";s:10:"is_visible";s:15:"COLUMN_POSITION";i:2;s:9:"DATA_TYPE";s:8:"smallint";s:7:"DEFAULT";s:1:"1";s:8:"NULLABLE";b:0;s:6:"LENGTH";N;s:5:"SCALE";N;s:9:"PRECISION";N;s:8:"UNSIGNED";b:1;s:7:"PRIMARY";b:0;s:16:"PRIMARY_POSITION";N;s:8:"IDENTITY";b:0;}s:12:"input_filter";a:14:{s:11:"SCHEMA_NAME";N;s:10:"TABLE_NAME";s:22:"customer_eav_attribute";s:11:"COLUMN_NAME";s:12:"input_filter";s:15:"COLUMN_POSITION";i:3;s:9:"DATA_TYPE";s:7:"varchar";s:7:"DEFAULT";N;s:8:"NULLABLE";b:1;s:6:"LENGTH";s:3:"255";s:5:"SCALE";N;s:9:"PRECISION";N;s:8:"UNSIGNED";N;s:7
<?php
/* CMS Tabs */
$menuIdentifiers = Mage::getModel('core/variable')
->setStoreId(Mage::app()->getStore()->getId())
->loadByCode('top_cms_menu')->getValue('text');
$menuIdentifiersArray = explode(',', $menuIdentifiers);
$currentPageIdentifier = Mage::getBlockSingleton('cms/page')->getPage()->getIdentifier();
$collection = Mage::getModel('cms/page')->getCollection();
@ceckoslab
ceckoslab / gist:3491491
Created August 27, 2012 19:20
Adding order statement
$collection = Mage::getModel('cms/page')->getCollection();
$collection->addFieldToFilter('identifier', array('in' => $menuIdentifiersArray));
$collection->addFieldToFilter('is_active', 1);
//Add this line
$collection->getSelect()->order("find_in_set(identifier,'".implode(',',$menuIdentifiersArray)."')");
//Replace
$menuIdentifiers = Mage::getModel('core/variable')->loadByCode('top_cms_menu')->getValue('text');
//With
$menuIdentifiers = Mage::getModel('core/variable')
->setStoreId(Mage::app()->getStore()->getId())
->loadByCode('top_cms_menu')->getValue('text');
@ceckoslab
ceckoslab / gist:3359512
Created August 15, 2012 11:59
Well formatted script for showing subcategories images in Magento
<?php $_maincategorylisting=$this->getCurrentCategory()?>
<?php $_categories=$this->getCurrentChildCategories()?>
<?php if($_categories->count()):?>
<?php foreach ($_categories as $_category):?>
<?php if($_category->getIsActive()):
$cur_category=Mage::getModel('catalog/category')->load($_category->getId());
$layer = Mage::getSingleton('catalog/layer');
$layer->setCurrentCategory($cur_category);
$catName = $this->getCurrentCategory()->getName();
// Test if the current category has an image assigned to it or not