Install the OpenSSL on Debian based systems
sudo apt-get install openssl| 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) { |
| /** | |
| * 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', |
| 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); |
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