From 15b2a4bb43e8c39f7ece285b528f9207d3effb29 Mon Sep 17 00:00:00 2001 From: Anthony Talarico Date: Tue, 2 May 2017 09:24:25 -0400 Subject: [PATCH] adding static array in the ajax header search php file to test the speed of the ajax queries removing the sql queries temporarily and adding a static array to test the speed issues of the ajax header search functions when selecting categories --- js/app.js | 12 +++---- js/custom/headerSearch.js | 2 +- lib/ajax-search.php | 66 +++++++++++++++++++-------------------- 3 files changed, 40 insertions(+), 40 deletions(-) diff --git a/js/app.js b/js/app.js index 87eba00..3fa69a9 100644 --- a/js/app.js +++ b/js/app.js @@ -46,7 +46,7 @@ $(document).ready(function () { action: "trailmaps", county: county, }, - complete: console.log("done"), + success:function(data){ var county_data = data; @@ -79,7 +79,7 @@ $(document).ready(function () { action: "trailmaps", region: region, }, - complete: console.log("done"), + success:function(data){ var region_data = data; @@ -123,7 +123,7 @@ $(document).ready(function () { others: {'destination' : $('#destination-search option:selected').val(), 'park' : $('#park-search option:selected').val()} }, - complete: console.log("done"), + success:function(data){ var activity_data = data; @@ -171,7 +171,7 @@ $(document).ready(function () { park: park, others: {'destination' : $('#destination-search option:selected').val(), 'activity' : $('#activity-search option:selected').val()} }, - complete: console.log("done"), + success:function(data){ var park_data = data; option = {}; @@ -218,9 +218,9 @@ $(document).ready(function () { destination: destination, others: {'activity' : $('#activity-search option:selected').val(), 'park' : $('#park-search option:selected').val()} }, - complete: console.log("done"), + success:function(data){ - console.log("SUCCESS"); + console.log(data.categories); var destination_data = data; option = {}; $('#activity-search option').not(':eq(0), :selected').remove(); diff --git a/js/custom/headerSearch.js b/js/custom/headerSearch.js index 03bcd78..ccef579 100644 --- a/js/custom/headerSearch.js +++ b/js/custom/headerSearch.js @@ -211,7 +211,7 @@ $(document).ready(function () { }, success:function(data){ - + console.log(data.categories); var destination_data = data; option = {}; $('#activity-search option').not(':eq(0), :selected').remove(); diff --git a/lib/ajax-search.php b/lib/ajax-search.php index afd4478..1457fbd 100644 --- a/lib/ajax-search.php +++ b/lib/ajax-search.php @@ -248,39 +248,39 @@ var ajaxurl = ''; }else if( isset($_REQUEST['destination']) ){ - $destination_id = isset($_REQUEST['destination'] )? filter_var($_REQUEST['destination'],FILTER_SANITIZE_STRING) : ''; - - $activity_id = $_REQUEST['others']['activity'] !== '' ? filter_var($_REQUEST['others']['activity'],FILTER_SANITIZE_STRING) : ''; - $park_id = $_REQUEST['others']['park'] !== '' ? filter_var($_REQUEST['others']['park'],FILTER_SANITIZE_STRING) : ''; - - if($destination_id !== 'false'){ - $sql = " SELECT CM.category, CAT.name, CAT.parent - FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX."member_info MI, - ".GLM_MEMBERS_PLUGIN_DB_PREFIX."category_member_info CM, - ".GLM_MEMBERS_PLUGIN_DB_PREFIX."categories CAT"; - - $where = " WHERE CM.member_info IN (SELECT member_info FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX."category_member_info WHERE category = $destination_id) AND MI.status = 10 AND CM.category = CAT.id"; - - if($activity_id !== ''){ - $where .= " AND CM.member_info IN (SELECT member_info FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX."category_member_info WHERE category = $activity_id) AND MI.status = 10 AND CM.category = CAT.id"; - } - if($park_id !== ''){ - $where .= " AND CM.member_info IN (SELECT member_info FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX."category_member_info WHERE category = $park_id) AND MI.status = 10 AND CM.category = CAT.id"; - } - $group_by = ' GROUP BY CM.category'; - - $query = $sql . $where . $group_by; - - } - - $results = $wpdb->get_results($query, ARRAY_A); - foreach($results as $key=>$value){ - $parent = $value['parent']; - $sql = "SELECT name FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX."categories WHERE id = $parent;"; - $parent_name = $wpdb->get_var($sql); - $categories[$parent_name][] = $value; - } - +// $destination_id = isset($_REQUEST['destination'] )? filter_var($_REQUEST['destination'],FILTER_SANITIZE_STRING) : ''; +// +// $activity_id = $_REQUEST['others']['activity'] !== '' ? filter_var($_REQUEST['others']['activity'],FILTER_SANITIZE_STRING) : ''; +// $park_id = $_REQUEST['others']['park'] !== '' ? filter_var($_REQUEST['others']['park'],FILTER_SANITIZE_STRING) : ''; +// +// if($destination_id !== 'false'){ +// $sql = " SELECT CM.category, CAT.name, CAT.parent +// FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX."member_info MI, +// ".GLM_MEMBERS_PLUGIN_DB_PREFIX."category_member_info CM, +// ".GLM_MEMBERS_PLUGIN_DB_PREFIX."categories CAT"; +// +// $where = " WHERE CM.member_info IN (SELECT member_info FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX."category_member_info WHERE category = $destination_id) AND MI.status = 10 AND CM.category = CAT.id"; +// +// if($activity_id !== ''){ +// $where .= " AND CM.member_info IN (SELECT member_info FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX."category_member_info WHERE category = $activity_id) AND MI.status = 10 AND CM.category = CAT.id"; +// } +// if($park_id !== ''){ +// $where .= " AND CM.member_info IN (SELECT member_info FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX."category_member_info WHERE category = $park_id) AND MI.status = 10 AND CM.category = CAT.id"; +// } +// $group_by = ' GROUP BY CM.category'; +// +// $query = $sql . $where . $group_by; +// +// } +// +// $results = $wpdb->get_results($query, ARRAY_A); +// foreach($results as $key=>$value){ +// $parent = $value['parent']; +// $sql = "SELECT name FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX."categories WHERE id = $parent;"; +// $parent_name = $wpdb->get_var($sql); +// $categories[$parent_name][] = $value; +// } + $categories = array('Activities'=>array('category'=>8,'parent'=>5,'name'=>'eeee'),'Parks'=>array('category'=>8,'parent'=>5,'name'=>'eeee')); $trail_data = array( 'categories' => $categories, -- 2.17.1