Tomasz-Silpion

SELECT 
o.grand_total AS 'Order Total',
o.created_at AS 'Payment Day',
p.method AS 'Payment Method',
CONCAT_WS(' ', o.customer_firstname, o.customer_lastname) AS 'Customer Name',
o.increment_id AS 'Order Number'

FROM sales_flat_order o
LEFT JOIN sales_flat_order_payment p ON p.entity_id = o.entity_id
WHERE (o.created_at BETWEEN '2016-01-01' AND '2016-12-31')

Tomasz-Silpion

<?php

require_once('app/Mage.php');
umask(0);
Mage::app();

$emails = array();
$orders = Mage::getModel('sales/order')->getCollection();
foreach ($orders as $order) {
    $emails[] = $order->getCustomerEmail();

Tomasz-Silpion

    $$('.validate-email').each(function(input){
        input.observe('change', function(e){
            this.value = this.value.replace(/^\s+|\s+$/g,"");
        });
    });

Tomasz-Silpion

for d in */ ; do
     (cd $d && git stash)
done

Tomasz-Silpion

if (isset($_COOKIE)) {
    foreach ($_COOKIE as $name => $value) {
        setcookie($name, $value, time() + 60);
    }
}

Tomasz-Silpion

# Database credentials
 DB_USER=""
 DB_PASS=""
 DB_HOST=""
 DB_NAME=""

# Database dump
mysqldump --user=$DB_USER --password=$DB_PASS --host=$DB_HOST $DB_NAME > $(date +"%d-%m-%Y").sql

# Files backup

Tomasz-Silpion

# Script for parsing Google PageSpeed optimized content MANIFEST
# Copyright (C) 2016 Tomasz Silpion Gregorczyk - All Rights Reserved

file="MANIFEST"
while IFS= read line
do    

#strip file paths
IFS=':' read -r src protocol url <<EOF
$line

Tomasz-Silpion

<?php

define('WP_USE_THEMES', false);
require('./wp-load.php');

$args = array('post_type' => 'product', 'posts_per_page' => -1);

$loop = new WP_Query($args);

while ($loop->have_posts()) : $loop->the_post();

Tomasz-Silpion

<?php

require('./wp-load.php');

$wpo_wcpdf = WPO_WCPDF();
$pdf = $wpo_wcpdf->export->get_pdf('invoice', array($order_id));

header("Content-type:application/pdf");
echo $pdf;

Tomasz-Silpion

# Magento2 shell script shorthand for redeployment 

php bin/magento setup:upgrade
cd tools && gulp clean && cd ..
php bin/magento setup:di:compile
php bin/magento setup:static-content:deploy
cd tools && gulp styles && cd ..
chmod -R 775 var
chmod -R 775 pub/static