Daniel Espinoza growdev

## canceled-subscriptions.sql
# Basic queries to analyse canceled subscriptions using EDD Recurring Payments pre EDD 3.0
# Use EXPLAIN if you have large stores since the "notes" column is not indexed and queries can take some time
# Some of these reports might be worth storing as Views and look at the graphs PHPMyAdmin can also create from them

# List subscription cancelation with creation and cancelation date, as well as the user who canceled
# good as a basis for further queries

SELECT ID,
  created,
  REGEXP_SUBSTR( REGEXP_SUBSTR( notes, '.* Status changed from active to cancelled .*' ), '^[a-z]+ [0-9]+, [0-9]+' ) AS 'date',

## setup-phpunit.sh
#!/usr/bin/env bash

# ===============================================================================
# Script to install PHPUnit in the Local by Flywheel Mac app
# These packages are installed
#
#     PHPUnit, curl wget, rsync, git, subversion and composer.
#
# WordPress is installed in the `/tmp/wordpress` directory for use by PHPUnit.
# The WordPress test suite is installed in the `/tmp/wordpress-tests-lib` directory.

## use-email-for-login-woocommerce.php
<?php

add_filter( 'woocommerce_new_customer_data', function( $data ) {
	$data['user_login'] = $data['user_email'];

	return $data;
} );

## gist:146c6f90bc8194c7dba1
<?php

/**
 * Filters get_post_meta() to ensure old commission status checks don't fail
 *
 * The status for commission records used to be stored in postmeta, now it's stored in a taxonomy
 *
 * @access      private
 * @since       2.8
 * @return      mixed

## gist:1604009
/**
 * Add the field to the checkout
 **/
add_action('woocommerce_after_order_notes', 'my_custom_checkout_field');

function my_custom_checkout_field( $checkout ) {

	echo '<div id="my_custom_checkout_field"><h3>'.__('My Field').'</h3>';

	/**

## template-print-processing-orders.php
<?php
/*
Template Name: Print Processing Orders :)
*/
if (!is_user_logged_in() || !current_user_can('manage_options')) wp_die('This page is private.');
?>
<!DOCTYPE HTML>
<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
	# Basic queries to analyse canceled subscriptions using EDD Recurring Payments pre EDD 3.0
	# Use EXPLAIN if you have large stores since the "notes" column is not indexed and queries can take some time
	# Some of these reports might be worth storing as Views and look at the graphs PHPMyAdmin can also create from them

	# List subscription cancelation with creation and cancelation date, as well as the user who canceled
	# good as a basis for further queries

	SELECT ID,
	created,
	REGEXP_SUBSTR( REGEXP_SUBSTR( notes, '.* Status changed from active to cancelled .*' ), '^[a-z]+ [0-9]+, [0-9]+' ) AS 'date',
	#!/usr/bin/env bash

	# ===============================================================================
	# Script to install PHPUnit in the Local by Flywheel Mac app
	# These packages are installed
	#
	# PHPUnit, curl wget, rsync, git, subversion and composer.
	#
	# WordPress is installed in the `/tmp/wordpress` directory for use by PHPUnit.
	# The WordPress test suite is installed in the `/tmp/wordpress-tests-lib` directory.
	<?php

	add_filter( 'woocommerce_new_customer_data', function( $data ) {
	$data['user_login'] = $data['user_email'];

	return $data;
	} );
	<?php

	/**
	* Filters get_post_meta() to ensure old commission status checks don't fail
	*
	* The status for commission records used to be stored in postmeta, now it's stored in a taxonomy
	*
	* @access private
	* @since 2.8
	* @return mixed
	/**
	* Add the field to the checkout
	**/
	add_action('woocommerce_after_order_notes', 'my_custom_checkout_field');

	function my_custom_checkout_field( $checkout ) {

	echo '<div id="my_custom_checkout_field"><h3>'.__('My Field').'</h3>';

	/**
	<?php
	/*
	Template Name: Print Processing Orders :)
	*/
	if (!is_user_logged_in() \|\| !current_user_can('manage_options')) wp_die('This page is private.');
	?>
	<!DOCTYPE HTML>
	<html>
	<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />