Order Tags

This code adds new field “Order tags” to >Setup Fields>Others and new filter at top of the form

// Filter by order tags + export field "Order tags" 
class Woe_Order_Tags {
	function __construct() {
		//add settings
		add_action("woe_settings_form_view_top", array($this,"draw_options") );
		// start filtering 
		add_filter("woe_settings_validate_defaults", function($settings) {
			$settings[ 'order_tags' ] = array_filter($settings[ 'order_tags' ]);
			if( !empty($settings[ 'order_tags' ]) ) 
				$this->set_filter($settings[ 'order_tags' ]);
			return $settings;
		});
		
		//add field to export 
		add_filter('woe_get_order_fields', function ($fields) {
			$fields['wcot_order_tags'] = array( 'label' => 'Order Tags', 'colname' => 'Order Tags', 'checked' => 1 );
			return $fields;
		});		
		//set field value 
		add_filter('woe_get_order_value_wcot_order_tags', function ($value,$order, $field) {
			$order_tags = wcot_order_tags_get_order_tags( $order->get_id() );
			$value= join(",", wp_list_pluck($order_tags,"name"));
			return $value;
		}, 10, 3);
	}

	function draw_options($settings){
		if( empty($settings[ 'order_tags' ]) )
			$settings[ 'order_tags' ] = array();
		echo "<strong>Order tags:</strong>";
		$terms = get_terms([
			'taxonomy' => 'wcot_order_tag',
			'hide_empty' => false,
		]);
		echo "<input type='hidden' name='settings[order_tags][]' value='0' />";
		foreach($terms as $term) {
		$checked  = in_array($term->term_id,$settings[ 'order_tags' ]) ? 'checked': '';
				echo "<input type='checkbox' $checked name='settings[order_tags][]' value='{$term->term_id}' /> {$term->name} ";
		}
		echo "<hr><br>";
	}

	function set_filter($tags){
		global $wpdb;
		$terms = join(",", $tags);
		$sql = "SELECT object_id 
			FROM {$wpdb->prefix}term_relationships AS TR 
				INNER JOIN {$wpdb->prefix}term_taxonomy AS TT ON TR.term_taxonomy_id = TT.term_taxonomy_id
				INNER JOIN {$wpdb->prefix}terms AS T ON TT.term_id = T.term_id
			WHERE TT.taxonomy = 'wcot_order_tag' AND T.term_id IN($terms)";
		$orders = $wpdb->get_col($sql);
		add_action( 'woe_sql_get_order_ids_where', function ($where, $settings) use ($orders) {
			if(!$orders) $orders[] = "0"; // we don't have any matched orders, so export must be EMPTY!
			$orders = join(",", $orders);
			$where[] = "orders.ID IN ($orders)";
			return $where;
		}, 10, 2);
	}
}
new Woe_Order_Tags();

// Filter by order tags + export field "Order tags"

class Woe_Order_Tags {

function __construct() {

//add settings

add_action("woe_settings_form_view_top", array($this,"draw_options") );

// start filtering

add_filter("woe_settings_validate_defaults", function($settings) {

$settings[ 'order_tags' ] = array_filter($settings[ 'order_tags' ]);

if( !empty($settings[ 'order_tags' ]) )

$this->set_filter($settings[ 'order_tags' ]);

return $settings;

});

//add field to export

add_filter('woe_get_order_fields', function ($fields) {

$fields['wcot_order_tags'] = array( 'label' => 'Order Tags', 'colname' => 'Order Tags', 'checked' => 1 );

return $fields;

});

//set field value

add_filter('woe_get_order_value_wcot_order_tags', function ($value,$order, $field) {

$order_tags = wcot_order_tags_get_order_tags( $order->get_id() );

$value= join(",", wp_list_pluck($order_tags,"name"));

return $value;

}, 10, 3);

}

function draw_options($settings){

if( empty($settings[ 'order_tags' ]) )

$settings[ 'order_tags' ] = array();

echo "<strong>Order tags:</strong>";

$terms = get_terms([

'taxonomy' => 'wcot_order_tag',

'hide_empty' => false,

]);

echo "<input type='hidden' name='settings[order_tags][]' value='0' />";

foreach($terms as $term) {

$checked = in_array($term->term_id,$settings[ 'order_tags' ]) ? 'checked': '';

echo "<input type='checkbox' $checked name='settings[order_tags][]' value='{$term->term_id}' /> {$term->name} ";

}

echo "<hr><br>";

}

function set_filter($tags){

global $wpdb;

$terms = join(",", $tags);

$sql = "SELECT object_id

FROM {$wpdb->prefix}term_relationships AS TR

INNER JOIN {$wpdb->prefix}term_taxonomy AS TT ON TR.term_taxonomy_id = TT.term_taxonomy_id

INNER JOIN {$wpdb->prefix}terms AS T ON TT.term_id = T.term_id

WHERE TT.taxonomy = 'wcot_order_tag' AND T.term_id IN($terms)";

$orders = $wpdb->get_col($sql);

add_action( 'woe_sql_get_order_ids_where', function ($where, $settings) use ($orders) {

if(!$orders) $orders[] = "0"; // we don't have any matched orders, so export must be EMPTY!

$orders = join(",", $orders);

$where[] = "orders.ID IN ($orders)";

return $where;

}, 10, 2);

}

new Woe_Order_Tags();

Advanced Order Export for WooCommerce

Order Tags