Skip to content

Instantly share code, notes, and snippets.


Maksim Soldatjonok Maksold

  • Latvia, Daugavpils
View GitHub Profile
Maksold / main.sql
Last active Oct 25, 2018
#magento get average #order, discount, item count, and order amount #report by month and year with direct #SQL
View main.sql
SELECT sub_query.month_ordered,
AVG(sub_query.base_subtotal) AS average_base_subtotal,
AVG(sub_query.discount_amount) AS average_discount_amt,
AVG(sub_query.order_qty) AS average_total_item_count,
COUNT(sub_query.entity_id) AS total_orders
(SELECT so.entity_id,
MONTH(so.created_at) AS month_ordered,
YEAR(so.created_at) AS year_ordered,
Maksold / magento-nginx.conf
Last active Oct 25, 2018 — forked from gwillem/magento-nginx.conf
Battle-tested #nginx configuration for #magento (source:
View magento-nginx.conf
# This is an annotated subset of the Nginx configuration from our Magento production platform @
# See
# !!!! If you are a Hypernode customer, do not use this config as it will result in duplicate statements. !!!!!
user app;
worker_processes 4;
pid /var/run/;
events {
Maksold / gist:3873543
Last active Oct 25, 2018
#magento - block caching
View gist:3873543
protected function _construct()
'cache_lifetime' => 86400,
'cache_tags' => array(Mage_Catalog_Model_Product::CACHE_TAG),
Maksold / list.phtml
Last active Oct 25, 2018
#magento - remove product_list_toolbar
View list.phtml
<?php if (!$this->getHideToolbar()): ?>
<?php echo $this->getToolbarHtml() ?>
<?php endif ?>
Maksold / Navigation.php
Last active Oct 25, 2018
#magento - get previous/next #category
View Navigation.php
* Additional Methods for Mage Core Navigation
* @category Scandi
* @package Scandi_Extends
class Scandi_Extends_Block_Catalog_Navigation extends Mage_Catalog_Block_Navigation
private function getCategoryByPositionOffset($offset)
Maksold / mysql4-install-1.0.6.php
Last active Oct 25, 2018
#magento - Interakting slider fix bug with installation
View mysql4-install-1.0.6.php
* Interakting Slider
* This source file is subject to the Open Software License (OSL 3.0)
* that is bundled with this package in the file LICENSE.txt.
* It is also available through the world-wide-web at this URL:
Maksold / data-install-0.0.1.php
Last active Oct 25, 2018
#magento - Create Transactional Email in #migration script
View data-install-0.0.1.php
/** @var $installer Scandi_Migrations_Model_Resource_Setup */
$installer = $this;
$templates = array(
"name" => "New Invoice",
"code" => "sales_email_invoice_template",
"config" => "sales_email/invoice/template",
Maksold / local.xml
Last active May 28, 2021
#magento #xml - local.xml boilerplate
View local.xml
<?xml version="1.0"?>
<!--Root/Default Layouts-->
<reference name="root">
<!--Appending Block-->
<block type="page/html_breadcrumbs" name="breadcrumbs" as="breadcrumbs"/>
<!--CSS and JS Files-->