Phil Kurth mishterk

## acf-export-group_63799935b6476.json
[
    {
        "key": "group_63799935b6476",
        "title": "Calculated Fields",
        "fields": [
            {
                "key": "field_637999367d114",
                "label": "Number 1",
                "name": "number_1",
                "aria-label": "",

## count-new-members-between-two-dates.sql
SELECT count(DISTINCT txns.user_id)
FROM (
       SELECT
         user_id,
         min(created_at) AS first_txn_created_at
       FROM wp_mepr_transactions
       WHERE status IN ('complete', 'confirmed')
       GROUP BY user_id
     ) AS first_txns
  INNER JOIN wp_mepr_transactions AS txns

## filter-acf-relationship-field-post-titles.php
<?php

add_filter( 'acf/fields/relationship/result/name=related_posts', function ( $title, WP_Post $post, $field_arr ) {

	$posted_at = get_post_time( 'U', false, $post->ID );
	$now = current_time( 'timestamp' );
	$diff = human_time_diff( $posted_at, $now );

	return $title . sprintf( ' (%s ago)', $diff );
}, 10, 3 );

## 0-woocommerce-snippets.md

      
              6 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                mishterk
                / 0-woocommerce-snippets.md
            
            
              Last active Sep 6, 2022
            
          
      View 0-woocommerce-snippets.md
  
      
    WooCommerce Snippets
Just a handy collection of small snippets for customising WooCommerce.

  
## acf-field-group-php-to-json.php
<?php
// Get all the local field groups and loop through them for processing.
$field_groups = acf_get_local_field_groups();
foreach ( $field_groups as $group ) {

	// If the field group has fields, load them into the 'fields' key.
	if ( acf_have_local_fields( $group['key'] ) ) {
		$group['fields'] = acf_get_local_fields( $group['key'] );
	}

## load-images-from-production.php
<?php
/**
 * Plugin Name: Load Images From Production (for staging/dev)
 * Description: Hooks into WP's media URL generation and replaces the domain with the production domain.
 * Author:      Phil Kurth
 * Author URI:  https://hookturn.io
 */

// If this file is called directly, abort.
defined( 'WPINC' ) or die();

## replace-images-with-kittens.php
<?php

add_filter( 'wp_get_attachment_image_src', function ( $image ) {
	$image[0] = "https://placekitten.com/$image[1]/$image[2]";
	return $image;
}, 10 );

## LocalValetDriver.php
<?php

/**
 * Class LocalValetDriver
 *
 * This class demonstrates how we might go about proxying any missing local images to a remote host. i.e; the production
 * site. This has been created with WordPress in mind but could be adjusted to work with any other system.
 */
class LocalValetDriver extends WordPressValetDriver {

## register-custom-admin-columns.php
<?php

$post_type = 'my_post_type';

// Register the columns.
add_filter( "manage_{$post_type}_posts_columns", function ( $defaults ) {

	$defaults['custom-one'] = 'Custom One';
	$defaults['custom-two'] = 'Custom Two';

## how-to-update-acf-google-map-field.php
<?php

// The field accepts a value with this structure
$value = [
	'address' => '123 Example St, Townsville XYZ 1234, Country',
	'lat' => - 38.1486228,
	'lng' => 144.360414,
	'zoom' => 14,
	'place_id' => 'Ei0xMjMgTW9vcmFib29sIFN0LCBHZWVsb25nIFZJQyAzMjIwLCBBdXN0cmFsaWEiMBIuChQKEgmX0JaIHBTUahFyH_LC9sYD8hB7KhQKEglDz-DYDxTUahECZY8QisCjzg',
	'street_number' => 123,
	[
	{
	"key": "group_63799935b6476",
	"title": "Calculated Fields",
	"fields": [
	{
	"key": "field_637999367d114",
	"label": "Number 1",
	"name": "number_1",
	"aria-label": "",
	SELECT count(DISTINCT txns.user_id)
	FROM (
	SELECT
	user_id,
	min(created_at) AS first_txn_created_at
	FROM wp_mepr_transactions
	WHERE status IN ('complete', 'confirmed')
	GROUP BY user_id
	) AS first_txns
	INNER JOIN wp_mepr_transactions AS txns
	<?php

	add_filter( 'acf/fields/relationship/result/name=related_posts', function ( $title, WP_Post $post, $field_arr ) {

	$posted_at = get_post_time( 'U', false, $post->ID );
	$now = current_time( 'timestamp' );
	$diff = human_time_diff( $posted_at, $now );

	return $title . sprintf( ' (%s ago)', $diff );
	}, 10, 3 );
	<?php
	// Get all the local field groups and loop through them for processing.
	$field_groups = acf_get_local_field_groups();
	foreach ( $field_groups as $group ) {

	// If the field group has fields, load them into the 'fields' key.
	if ( acf_have_local_fields( $group['key'] ) ) {
	$group['fields'] = acf_get_local_fields( $group['key'] );
	}
	<?php
	/**
	* Plugin Name: Load Images From Production (for staging/dev)
	* Description: Hooks into WP's media URL generation and replaces the domain with the production domain.
	* Author: Phil Kurth
	* Author URI: https://hookturn.io
	*/

	// If this file is called directly, abort.
	defined( 'WPINC' ) or die();
	<?php

	/**
	* Class LocalValetDriver
	*
	* This class demonstrates how we might go about proxying any missing local images to a remote host. i.e; the production
	* site. This has been created with WordPress in mind but could be adjusted to work with any other system.
	*/
	class LocalValetDriver extends WordPressValetDriver {
	<?php

	$post_type = 'my_post_type';

	// Register the columns.
	add_filter( "manage_{$post_type}_posts_columns", function ( $defaults ) {

	$defaults['custom-one'] = 'Custom One';
	$defaults['custom-two'] = 'Custom Two';
	<?php

	// The field accepts a value with this structure
	$value = [
	'address' => '123 Example St, Townsville XYZ 1234, Country',
	'lat' => - 38.1486228,
	'lng' => 144.360414,
	'zoom' => 14,
	'place_id' => 'Ei0xMjMgTW9vcmFib29sIFN0LCBHZWVsb25nIFZJQyAzMjIwLCBBdXN0cmFsaWEiMBIuChQKEgmX0JaIHBTUahFyH_LC9sYD8hB7KhQKEglDz-DYDxTUahECZY8QisCjzg',
	'street_number' => 123,