Skip to content

Instantly share code, notes, and snippets.

View vdubyna's full-sized avatar

Volodymyr Dubyna vdubyna

View GitHub Profile
@vdubyna
vdubyna / gist:30fe07b4c236cdd29b00
Last active December 15, 2015 11:20
magento2-composer-keys.sh
composer.phar global config http-basic.repo.magento.com <public_key> <private_key>
composer config --global repositories.magento composer http://repo.magento.com/
select soi.*, GROUP_CONCAT(soi.item_status) from (select
CONCAT(ssfoi.item_id, '->', if(
(ssfoi.invoiced = false and ssfoi.shipped = false AND ssfoi.refunded = false AND ssfoi.canceled = false AND ifnull(ssfoi.backordered, 0.0000) = false),
'Pending',
if(
ssfoi.shipped AND ssfoi.invoiced AND (ssfoi.actuallyOrdered = ssfoi.shipped),
'Shipped',
if(ssfoi.invoiced AND ssfoi.shipped AND (ssfoi.actuallyOrdered = ssfoi.invoiced),
'Invoiced',
if(ssfoi.backordered AND (ssfoi.actuallyOrdered = ssfoi.backordered),
var execute = function () {
var field = [
[{a: 1}, {a: 2}, {a: 3}, {a: 4}],
[{b: 1}, {b: 2}, {b: 3}, {b: 4}],
[{c: 1}, {c: 2}, {c: 3}, {c: 4}],
[{d: 1}, {d: 2}, {d: 3}, {d: 4}]
];
var directions = {
var r = '123456789'.split("").reverse().reduce(function(pre, current){
pre = (pre.constructor == Array) ? pre : [pre];
return ["", "+", "-"].map(function(op) {
return pre.reduce(function(carry, item) {
return carry.concat(
("-" + current + op + item).replace(/[-,+][-,+]/g, "-"),
(current + op + item).replace(/[-,+][-,+]/g, "-")
);
},[]);
}).reduce(function(p, c) {
<?php
$s = 3;
$t = [
"((()))",
"()()()",
"(())()",
"()(())",
"(()())"
];
@vdubyna
vdubyna / Refresh.php
Created November 1, 2016 13:46
Fixed catalog_category_product indexer EE 1.14
/**
* Retrieve select for reindex products of non anchor categories
*
* @param Mage_Core_Model_Store $store
* @return Varien_Db_Select
*/
protected function _getAnchorCategoriesSelect(Mage_Core_Model_Store $store)
{
if (!isset($this->_anchorCategoriesSelect[$store->getId()])) {
/** @var $eavConfig Mage_Eav_Model_Config */
$k = [
'a/b/c/j',
'a/b/c',
'a/b/d/q',
'a/b/d',
'a/b/e',
'a/b/c/j',
'a/b/c',
'a/b/d/q',
'a/b/d',
@vdubyna
vdubyna / multiply-in-column.php
Created February 28, 2017 10:27
Multiply 2 numbers
function multiplyInColumn($a, $b) {
$bArr = array_reverse(str_split($b));
$aArr = array_reverse(str_split($a));
$result = array_map(function ($step, $bItem) use ($aArr) {
$rest = 0;
$result = array_fill(0, $step, 0);
@vdubyna
vdubyna / openssl_commands.md
Created December 18, 2017 12:58 — forked from p3t3r67x0/openssl_commands.md
Some list of openssl commands for check and verify your keys

openssl

Install

Install the OpenSSL on Debian based systems

sudo apt-get install openssl
@vdubyna
vdubyna / MacOSXSierra:Brew+Apache+Mysql+PHPSwitcher+DNSMasq+SSL.md
Created January 2, 2018 17:14 — forked from andrewstobbe/MacOSXSierra:Brew+Apache+Mysql+PHPSwitcher+DNSMasq+SSL.md
Mac OSX Sierra : Brew Apache + Mysql + PHP Switcher + DNSMasq + SSL

Mac OSX Sierra : Brew Apache + Mysql + PHP Switcher + DNSMasq + SSL 👍

Things I had to do using Homebrew to get my local web dev environment back up and running after migration to OSX Sierra + Xcode 8.1.

Note: I used brew reinstall because I had already installed most of this previously under Yosemite. Probably better ways to do this, but this is what worked for me.

brew doctor

brew tap homebrew/dupes
brew tap homebrew/versions