Antoine Kociuba antoinekociuba

## start_es_docker_container.sh
docker run -d --restart=unless-stopped --name=container_name_elasticsearch -p 123456:9200 -e "discovery.type=single-node" -v /home/www/project/.es_data:/usr/share/elasticsearch/data elasticsearch:7.6.2

## search_string_in_files.sh
grep -rnw '/var/www/project/vendor/' -e 'toto.log'

## m2_clean_product_eav_values.sql
CREATE TABLE catalog_product_entity_int_old LIKE catalog_product_entity_int;
INSERT INTO catalog_product_entity_int_old SELECT * FROM catalog_product_entity_int;

DELETE FROM catalog_product_entity_int
    WHERE value_id IN
        (SELECT cpei.value_id
            FROM catalog_product_entity_int_old cpei
            WHERE cpei.attribute_id NOT IN
                (SELECT eea.attribute_id
                    FROM eav_entity_attribute eea

## delete_merged_git_branches_remotely
# Sources: https://community.atlassian.com/t5/Bitbucket-questions/Is-there-a-way-to-delete-branches-in-bulk/qaq-p/547331

# Make sure remotes are up to date (with stale remotes purged):
git fetch -p

# Initial no-op run --- do the branches to delete look correct?
# Be careful to omit 'master' from the output.
git branch --remote --merged origin/master | grep -v 'master' | cut -b 10- | xargs

# Do the bulk delete!!!  (can take a long time...)

## git_assume_unchanged
git update-index --assume-unchanged media/downloadable/.htaccess

## m2_get_products_data.sql
SELECT e.entity_id AS 'id',
       v1.value AS 'name',
       e.sku,
       d1.value AS 'price',
       si.qty AS 'qty',
       t1.value AS 'short_description',
       t2.value AS 'description',
       v2.value AS 'image',
       v3.value AS 'thumbnail',
       mg.value AS 'media_gallery',

## category_trees_per_product.php
<?php

// Get all product category IDs
$categoryIds = $product->getCategoryIds();

// Get category trees, filtered by product category IDs
$helper = Mage::helper('catalog/category');
$categoryTreeCollection = $helper->getStoreCategories('path', true, false);
$categoryTreeCollection->addAttributeToFilter('entity_id', ['in' => $categoryIds]);

## add-checkout-form-key.sh
find -L app/design/frontend -name 'shipping.phtml' -or -name 'billing.phtml' -or -name 'shipping_method.phtml' -or -name 'payment.phtml' -or -name 'addresses.phtml' \
      | xargs grep -L formkey \
      | xargs perl -i -pe 's/<\/form>/<?php echo \$this->getBlockHtml("formkey") ?>\n<\/form>/g'

find -L skin/frontend -name 'opcheckout.js' \
      | xargs grep -L form_key \
      | xargs perl -i -pe 's/if \(elements\[i\]\.name=='\''payment\[method\]'\''\) \{/if (elements[i].name=='\''payment[method]'\'' || elements[i].name == '\''form_key'\'') {/g'


find -L js -name 'payment.js' \

## .gitignore_magento
######################
# Magento .gitignore #
######################

# Magento Core unnecessary files #
##################################
/errors/local.xml
/index.php
/install.php
/mage

## define_root_folder_after_ssh.sh
#!/bin/bash
echo "cd /var/www/magento" >> /home/vagrant/.bashrc
	CREATE TABLE catalog_product_entity_int_old LIKE catalog_product_entity_int;
	INSERT INTO catalog_product_entity_int_old SELECT * FROM catalog_product_entity_int;

	DELETE FROM catalog_product_entity_int
	WHERE value_id IN
	(SELECT cpei.value_id
	FROM catalog_product_entity_int_old cpei
	WHERE cpei.attribute_id NOT IN
	(SELECT eea.attribute_id
	FROM eav_entity_attribute eea
	# Sources: https://community.atlassian.com/t5/Bitbucket-questions/Is-there-a-way-to-delete-branches-in-bulk/qaq-p/547331

	# Make sure remotes are up to date (with stale remotes purged):
	git fetch -p

	# Initial no-op run --- do the branches to delete look correct?
	# Be careful to omit 'master' from the output.
	git branch --remote --merged origin/master \| grep -v 'master' \| cut -b 10- \| xargs

	# Do the bulk delete!!! (can take a long time...)
	SELECT e.entity_id AS 'id',
	v1.value AS 'name',
	e.sku,
	d1.value AS 'price',
	si.qty AS 'qty',
	t1.value AS 'short_description',
	t2.value AS 'description',
	v2.value AS 'image',
	v3.value AS 'thumbnail',
	mg.value AS 'media_gallery',
	<?php

	// Get all product category IDs
	$categoryIds = $product->getCategoryIds();

	// Get category trees, filtered by product category IDs
	$helper = Mage::helper('catalog/category');
	$categoryTreeCollection = $helper->getStoreCategories('path', true, false);
	$categoryTreeCollection->addAttributeToFilter('entity_id', ['in' => $categoryIds]);
	find -L app/design/frontend -name 'shipping.phtml' -or -name 'billing.phtml' -or -name 'shipping_method.phtml' -or -name 'payment.phtml' -or -name 'addresses.phtml' \
	\| xargs grep -L formkey \
	\| xargs perl -i -pe 's/<\/form>/<?php echo \$this->getBlockHtml("formkey") ?>\n<\/form>/g'

	find -L skin/frontend -name 'opcheckout.js' \
	\| xargs grep -L form_key \
	\| xargs perl -i -pe 's/if \(elements\[i\]\.name=='\''payment\[method\]'\''\) \{/if (elements[i].name=='\''payment[method]'\'' \|\| elements[i].name == '\''form_key'\'') {/g'


	find -L js -name 'payment.js' \
	######################
	# Magento .gitignore #
	######################

	# Magento Core unnecessary files #
	##################################
	/errors/local.xml
	/index.php
	/install.php
	/mage
	#!/bin/bash
	echo "cd /var/www/magento" >> /home/vagrant/.bashrc