Skip to content

Instantly share code, notes, and snippets.

View warrendholmes's full-sized avatar

Warren Holmes warrendholmes

35 followers · 2 following
View GitHub Profile
@warrendholmes
warrendholmes / mojo-ping
Created October 30, 2015 11:24
{
"buyer_data":
{
"email": "string",
"first_name": "string",
"last_name": "string",
"order_id": "string",
"is_production": "string",
"action": "ACTION",
"products": [
@warrendholmes
warrendholmes / gist:cfcf399faf638a77c75f
Created March 16, 2015 14:39
<link rel="stylesheet" type="text/css" href="//fast.appcues.com/appcues.min.css">
</head>
<body class="page page-id-18553 page-parent page-template page-template-template-my-account page-template-template-my-account-php woocommerce-account woocommerce-page chrome feature-3">
<script src="//fast.appcues.com/1956.js"></script>
<script>
Appcues.identify('52175', {
email: 'warren@woothemes.com',
name: 'wdh',
@warrendholmes
warrendholmes / gist:3247acb399183c016745
Last active August 29, 2015 14:16
SELECT
DATE_FORMAT( date_created, '%Y-%m' ),
COUNT( * ) AS 'Licenses Created',
SUM( IF( DATE_FORMAT( date_created, '%Y-%m-%d' ) < '2013-08-01', IF( DATE_ADD( date_created, INTERVAL 2 YEAR ) > support_expiry_date, 0, 1 ), IF( DATE_ADD( date_created, INTERVAL 1 YEAR ) > support_expiry_date, 0, 1 ) ) ) as 'Licenses Renewed'
FROM license
WHERE lifetime <> 1
and product_id not in (18596,18606,18608,18656,18825,56536,56542,56546,56551,56552,56553,56556,56557,56558,56559,56560,56561,56562,56563,56564,120726,120727,120728,120730,120733,120736,120741,120744,120745,120746,120748,120749,120750,120752,120753,120754,120755,120759,124451,131599,135051,138175,142278,143158,168744,170213,176537,185343,190246,190248,196635,197567,201497,202412,204152,213827,222996,225393,226188,234845,238816,239962,244762,290592,291779,312408,312508,435830,435833,435834,474603,475304,489666,491331,493046,497916,502349,524956,536332,543228,565154)
GROUP BY DATE_FORMAT( date_created, '%Y-%m' )
ORDER BY DATE_FORMAT( date_created, '%Y
@warrendholmes
warrendholmes / gist:ea10faab9481c72c8b8b
Created February 19, 2015 14:19
<!-- Begin Inspectlet Embed Code -->
<script type="text/javascript" id="inspectletjs">
window.__insp = window.__insp || [];
__insp.push(['wid', 797319850]);
(function() {
function __ldinsp(){var insp = document.createElement('script'); insp.type = 'text/javascript'; insp.async = true; insp.id = "inspsync"; insp.src = ('https:' == document.location.protocol ? 'https' : 'http') + '://cdn.inspectlet.com/inspectlet.js'; var x = document.getElementsByTagName('script')[0]; x.parentNode.insertBefore(insp, x); }
if (window.attachEvent){
window.attachEvent('onload', __ldinsp);
}else{
window.addEventListener('load', __ldinsp, false);
@warrendholmes
warrendholmes / gist:e792706fcc01d8451529
Created February 18, 2015 20:02
//Get cohort report on WC buyers
SELECT DATE_FORMAT( o.date, '%Y-%m' ) as 'Year/Month', count(oi.id) as 'Total orders', count( DISTINCT c.id ) as 'Number of users', SUM( oi.line_item_total ) as 'Gross Revenue'
FROM order_item as oi
LEFT JOIN `order` as o on oi.order_id = o.id
left join customer as c on o.customer_id = c.id
LEFT JOIN product as p on p.id = oi.product_id
LEFT JOIN product_product_cat_rel AS rel on rel.product_id = p.id
WHERE DATE_FORMAT(c.date_registered, '%Y-%m') = '2014-01'
AND oi.line_item_total > 0
AND DATE_FORMAT(o.date, '%Y') > 2013
@warrendholmes
warrendholmes / gist:d6e57529dcf64d87c8c8
Created February 13, 2015 10:26
All revenue data by month / year
SELECT sum(oi.line_item_total), date_format( o.date, '%m-%Y' ) FROM `order_item` as oi join `order` as o on o.id = oi.order_id group by date_format( o.date, '%m-%Y' ) order by o.date asc
All revenue data by month / year and product
SELECT sum(oi.line_item_total), date_format( o.date, '%m-%Y' ), oi.product_id FROM `order_item` as oi join `order` as o on o.id = oi.order_id group by date_format( o.date, '%m-%Y' ), oi.product_id order by o.date asc
All recurring revenue data by month / year and product
SELECT sum(oi.line_item_total), date_format( o.date, '%m-%Y' ), oi.product_id FROM `order_item` as oi join `order` as o on o.id = oi.order_id where oi.recurring = 1 group by date_format( o.date, '%m-%Y' ), oi.product_id order by o.date asc
Customers added
@warrendholmes
warrendholmes / gist:0a34302144ebd1a1a83b
Created January 26, 2015 12:37
<?php
echo "This is a test.";
?>
@warrendholmes
warrendholmes / bundleana.php
Created December 11, 2014 11:32
<?php
$order_data_normalized = array();
$starter_bundle = array('27147','18618','18718','18686');
$row = 1;
if (($handle = fopen("/Users/warrenholmes/Sites/phpinfo/wp_woocommerce_downloadable_product_permissions.csv", "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
@warrendholmes
warrendholmes / alef1
Created July 16, 2014 13:28
$args = array(
‘posts_per_page’ => 1,
‘post_type’ => ‘product’,
‘post_status’ => array( ‘publish’, ‘trash’, ‘draft’, ‘pending’ ),
‘meta_query’ => array(
array(
‘key’ => ‘_spin_id’,
‘value’ => (string) trim($p->SpinId),
) )
);
@warrendholmes
warrendholmes / Flexslider Options
Created March 11, 2014 07:51
namespace: "flex-", //{NEW} String: Prefix string attached to the class of every element generated by the plugin
selector: ".slides > li", //{NEW} Selector: Must match a simple pattern. '{container} > {slide}' -- Ignore pattern at your own peril
animation: "fade", //String: Select your animation type, "fade" or "slide"
easing: "swing", //{NEW} String: Determines the easing method used in jQuery transitions. jQuery easing plugin is supported!
direction: "horizontal", //String: Select the sliding direction, "horizontal" or "vertical"
reverse: false, //{NEW} Boolean: Reverse the animation direction
animationLoop: true, //Boolean: Should the animation loop? If false, directionNav will received "disable" classes at either end
smoothHeight: false, //{NEW} Boolean: Allow height of the slider to animate smoothly in horizontal mode
startAt: 0, //Integer: The slide that the slider should start on. Array nota