wpfunnels / admin / modules / category / class-wpfnl-category.php

class-wpfnl-category.php in WPFunnels – Funnel Builder for WooCommerce with Checkout & One Click Upsell 2.8.16, at admin/modules/category/class-wpfnl-category.php

96 lines 2.3 KB

Raw Download Zip

1	<?php
2	/**
3	* Category module
4	*
5	* @package
6	*/
7	namespace WPFunnels\Modules\Admin\Category;
8
9	use WPFunnels\Admin\Module\Wpfnl_Admin_Module;
10	use WPFunnels\Traits\SingletonTrait;
11	use WPFunnels\Wpfnl_functions;
12	class Module extends Wpfnl_Admin_Module
13	{
14	use SingletonTrait;
15
16	public function init_ajax()
17	{
18	add_action('wp_ajax_wpfnl_category_search', [ $this, 'fetch_categories' ]);
19	add_action('wp_ajax_wpfnl_tag_search', [ $this, 'fetch_tags' ]);
20	}
21
22	public function get_name()
23	{
24	return 'category';
25
26	}
27
28	public function get_view()
29	{
30
31	}
32
33
34	/**
35	* Category search by name
36	*/
37	public function fetch_categories(){
38	check_ajax_referer('wpfnl-admin', 'security');
39	if (isset($_GET['term'])) {
40	$cat_name = (string) esc_attr( wp_unslash($_GET['term']) );
41	}
42	if (empty($cat_name)) {
43	wp_die();
44	}
45	global $wpdb;
46	$cat_Args= "SELECT * FROM $wpdb->terms as t INNER JOIN $wpdb->term_taxonomy as tx ON t.term_id = tx.term_id WHERE tx.taxonomy = 'product_cat' AND t.name LIKE '%".$cat_name."%' ";
47	$category = $wpdb->get_results($cat_Args, OBJECT);
48	if(empty($category)){
49	$data = [
50	'status' => 'success',
51	'data' => 'Category not found',
52	];
53	}else{
54	$data = [
55	'status' => 'success',
56	'data' => $category,
57	];
58	}
59	wp_send_json($data);
60
61	}
62
63
64	/**
65	* Tag search by name for GBF enter condition
66	*
67	* @since 2.5.2
68	* @return Json
69	*/
70	public function fetch_tags(){
71	check_ajax_referer('wpfnl-admin', 'security');
72	if (isset($_GET['term'])) {
73	$tag_name = (string) esc_attr( wp_unslash($_GET['term']) );
74	}
75	if (empty($tag_name)) {
76	wp_die();
77	}
78	global $wpdb;
79	$tag_Args= "SELECT * FROM $wpdb->terms as t INNER JOIN $wpdb->term_taxonomy as tx ON t.term_id = tx.term_id WHERE tx.taxonomy = 'product_tag' AND t.name LIKE '%".$tag_name."%' ";
80	$tags = $wpdb->get_results($tag_Args, OBJECT);
81	if(empty($tags)){
82	$data = [
83	'status' => 'success',
84	'data' => 'Tag not found',
85	];
86	}else{
87	$data = [
88	'status' => 'success',
89	'data' => $tags,
90	];
91	}
92	wp_send_json($data);
93
94	}
95	}
96