<?php
/*
Plugin Name: 3-tier Hierarchy
Plugin URI: rathercurious.net
Description: Akismet checks your comments against the Akismet web service to see if they look like spam or not. You need a <a href="http://wordpress.com/api-keys/">WordPress.com API key</a> to use it. You can review the spam it catches under "Comments." To show off your Akismet stats just put <code><?php akismet_counter(); ?></code> in your template. See also: <a href="http://wordpress.org/extend/plugins/stats/">WP Stats plugin</a>.
Version: 0.0.1
Author: Justin Adie
Author URI: rathercurious.net
*/
class crlHierarchy{
private $flush = false; //set to true to flush the cache
/**
* constructor method to set variables and start the data gathering
*
* @return
*/
public function __construct(){
$this->url = $url = get_bloginfo('url');
$dir = sys_get_temp_dir();
$this->cache = realpath($dir . "/WP_FTP_CACHE.txt");
}
/**
* method to gather the data and display the hierarchy as a multi LI tree
* @return
*/
public function displayTree(){
$this->getOutput();
echo $this->output;
}
/**
* method to check the cache status and grab the output either from the cache or the internal methods
* @return
*/
private function getOutput(){
global $wpdb;
if (file_exists($this->cache)){
if ($this->flush){
unlink ($this->cache);
$this->getData();
$this->generateOutput();
unset($this->rawResults);
$this->cacheResults();
} else {
clearstatcache();
$lastMod = fileatime($this->cache);
//now get latest post mod time
$query = "Select max(post_modified_gmt) from $wpdb->posts";
$postLastMod = $wpdb->get_col($query);
//convert to unix
$postLastMod = strtotime($postLastMod . " GMT");
//compare the two values
if ($lastMod >= $postLastMod){
$this->output = file_get_contents($this->cache);
} else {
$this->getData();
$this->generateOutput();
unset($this->rawResults);
$this->cacheResults();
}
}
} else {
$this->getData();
$this->generateOutput();
unset($this->rawResults);
$this->cacheResults();
}
}
/**
* method to cache the html of the tree in the filesystem
* @return
*/
private function cacheResults(){
file_put_contents($this->cache, $this->output);
}
/**
* method to transform arguments into a clickable link that can be used with the existing search facility back end
* @return
* @param string $text
* @param string $country
* @param string $region[optional]
* @param string $location[optional]
*/
private function makeLink($text, $country, $region=null, $location=null){
if (is_null($region)){
$country = urlencode($country);
return "<a href=\"{$this->url}?metaFilterKey=country&s=$country\">$text</a>";
} else if (is_null($location)) {
$region = urlencode($region);
return "<a href=\"{$this->url}?metaFilterKey=region&s=$region\">$text</a>";
} else {
$location = urlencode($location);
return "<a href=\"{$this->url}?metaFilterKey=location&s=$location\">$text</a>";
}
}
/**
* method to create a temporary table, write data to it and then retrieve the data hierarchically
*
* @return
*/
private function generateOutput(){
global $wpdb;
$query = <<<SQL
CREATE TABLE `tmpLoc` (
`country` VARCHAR( 255 ) NOT NULL ,
`region` VARCHAR( 255 ) NULL ,
`location` VARCHAR( 255 ) NULL
) CHARACTER SET {$wpdb->charset} COLLATE {$wpdb->charset};
SQL;
$wpdb->query($query);
/*
$query = <<<SQL
create UNIQUE index
conjunction
on
tmpLoc
(country, region, location)
SQL;
$wpdb->query($query); */
$_q = ';
foreach ($this->rawResults as $data){
$country = (empty($data['country']) ? 'null' : $wpdb->prepare("%s", $data['country']));
$region = (empty($data['region']) ? 'null' : $wpdb->prepare("%s", $data['region']));
$location = (empty($data['location']) ? 'null' : $wpdb->prepare("%s", $data['location']));
$_q[] = "($country, $region, $location)";
}
$query = "insert into tmpLoc (country, region, location) values " . implode (',', $_q);
$wpdb->query($query);
//manage output now
//get countries
$countries = $wpdb->get_col("select country from tmpLoc group by country order by country asc");
$output = <<<HTML
<ul class="countries">
HTML;
foreach ($countries as $country){
$_country = trim($country) ==' ? "No country specified" : trim($country);
$output .= <<<HTML
<li class="country">
{$this->makeLink($_country, $_country)}
HTML;
//get regions for this country
$query = $wpdb->prepare("select region from tmpLoc where country=%s group by region order by region asc", $country);
$regions = $wpdb->get_col($query);
if (empty($regions)){
$output .= <<<HTML
</li><!--end of country li-->
HTML;
} else {
//iterate the regions
/********* REGIONS *********/
$output .= <<<HTML
<ul class="regions">
HTML;
foreach ($regions as $region){
$output .= <<<HTML
<li class="region">
{$this->makeLink($region, $_country, $region)}
HTML;
/********* LOCATIONS *********/
$query = $wpdb->prepare("select location from tmpLoc where country=%s and region=%s group by location order by region asc", $country, $region);
$locations = $wpdb->get_col($query);
if (empty($locations)){
$output .= <<<HTML
</li> <!-- end of region li -->
HTML;
} else {
$output .= <<<HTML
<ul class="locations">
HTML;
foreach ($locations as $location){
$output .= <<<HTML
<li class="location">
{$this->makeLink($location, $_country, $region, $location)}
</li>
HTML;
}
$output .= <<<HTML
</ul><!-- close locations ul -->
HTML;
}
/********* END LOCATIONS *********/
$output .= <<<HTML
</li><!--end region li-->
HTML;
}
$output .= <<<HTML
</ul>
HTML;
/********* END REGIONS *********/
}
$output .= <<<HTML
</li><!--end country li -->
HTML;
}
$output .= <<<HTML
</ul>
HTML;
$this->output = $output;
}
/**
* method to query the postmeta table and return all the necessary data in an multidimensional array
* @return
*/
private function getData(){
global $wpdb;
$query = <<<SQL
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE LOWER( meta_key )
IN (
'country', 'region', 'location'
)
ORDER BY LOWER( meta_key ) ASC , LOWER( meta_value ) ASC
SQL;
$results = $wpdb->get_results($query, 'ARRAY_A');
foreach ($results as $result){
$type = strtolower($result['meta_key']);
$this->rawResults[$result['post_id']][$type] = $result['meta_value'];
}
}
}
$crlHierarchy = new crlHierarchy();
?>
Talk To Other Members
Read More Threads Like This One