Valerii Vasyliev ValeriiVasyliev

Woocommerce Javascript events
Woocommerce Checkout JS events

$( document.body ).trigger( 'init_checkout' );
$( document.body ).trigger( 'payment_method_selected' );
$( document.body ).trigger( 'update_checkout' );
$( document.body ).trigger( 'updated_checkout' );
$( document.body ).trigger( 'checkout_error' );
$( document.body ).trigger( 'applied_coupon_in_checkout' );

MySQL script to get all WooCommerce orders including metadata

SET @date_start = '2021-02-12' ;
SELECT
    p.ID as order_id,
    MAX( CASE WHEN pm.meta_key = '_billing_first_name' and p.ID = pm.post_id THEN pm.meta_value END ) as name,
    MAX( CASE WHEN pm.meta_key = '_billing_last_name' and p.ID = pm.post_id THEN pm.meta_value END ) as lastname,
    MAX( CASE WHEN pm.meta_key = '_billing_email' and p.ID = pm.post_id THEN pm.meta_value END ) as email,
    MAX( CASE WHEN pm.meta_key = '_billing_phone' and p.ID = pm.post_id THEN pm.meta_value END ) as phone,

Create a new repository, or reuse an existing one.

Generate a new SSH key:

ssh-keygen -t rsa -C "[email protected]"

Copy the contents of the file ~/.ssh/id_rsa.pub to your SSH keys in your GitHub account settings (https://github.com/settings/keys).

Test SSH key:

Install software-properties-common

sudo apt-get install software-properties-common

Add Repo

sudo add-apt-repository ppa:olipo186/git-auto-deploy

	/**
	* Each of these samples can be used - note that you should pick one rather than add them all.
	*
	* How to use WC notices: https://github.com/woothemes/woocommerce/blob/master/includes/wc-notice-functions.php#L96
	* Tutorial: http://www.skyverge.com/blog/edit-woocommerce-templates/
	**/

	/**
	* Add a content block after all notices, such as the login and coupon notices.
	*

	# This is a template .gitignore file for git-managed WordPress projects.
	#
	# Fact: you don't want WordPress core files, or your server-specific
	# configuration files etc., in your project's repository. You just don't.
	#
	# Solution: stick this file up your repository root (which it assumes is
	# also the WordPress root directory) and add exceptions for any plugins,
	# themes, and other directories that should be under version control.
	#
	# See the comments below for more info on how to add exceptions for your

	<?php

	/*
	Important!
	Make sure to replace {my_} with your theme's unique prefix.
	All future functions you write should use that same prefix.
	Example: mrwnten_parent_theme_enqueue_styles()
	*/

	add_action( 'wp_enqueue_scripts', '{my_}parent_theme_enqueue_styles' );

	<?php
	/**
	* Enqueue scripts and styles.
	*
	* @since 1.0.0
	*/
	function ja_global_enqueues() {

	wp_enqueue_style(
	'jquery-auto-complete',

	add_filter( 'terms_clauses', 'filter_terms_clauses', 10, 3 );
	/**
	* Filter WP_Term_Query meta query
	*
	* @param object $query WP_Term_Query
	* @return object
	*/
	function filter_terms_clauses( $pieces, $taxonomies, $args ) {

	global $pagenow, $wpdb;

	<?php if (($wp_query->current_post +1) == ($wp_query->post_count)) {
	echo 'This is the last post';
	} ?>

	<?php if (($wp_query->current_post +1) != ($wp_query->post_count)) {
	echo 'This is the not the last post';
	} ?>