This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
echo "hell world"; | |
?> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
add_filter( 'template_include', 'woocommerce_add_template_loader_product_category' ); | |
function woocommerce_add_template_loader_product_category(){ | |
global $product; | |
foreach ( get_the_terms( $product->id, 'product_cat' ) as $key => $value) { | |
locate_template( 'single-product-' . $value->slug . '.php' ,true, $require_once = true) ; | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<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', |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!-- 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); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
echo "This is a test."; | |
?> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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) { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$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), | |
) ) | |
); |
NewerOlder