Home › Forums › MapPress Support › Mashup with date filter › Reply To: Mashup with date filter
I think you’ll need to write some PHP since you want a date range calculated based on the current date. When I need to write shortcodes, I keep them in a utility plugin so I don’t have to worry about theme changes. You can learn a lot by looking at the plugins that other people have written. See http://codex.wordpress.org/Writing_a_Plugin for some help getting started.
You might do something along the lines of the code below to filter by date:
global $my_datefrom, $my_dateto;
// Create a new filtering function that will add our where clause to the query
function my_filter_where($where = ”) {
global $my_datefrom, $my_dateto;
if ($my_datefrom) $where .= ” AND post_date >= ‘” . $my_datefrom;
if ($my_dateto) $where .= “‘ AND post_date <= ‘” . $my_dateto . “‘”; else $where .= “‘”;
return $where;
}
// [my_querymap my_datefrom=”2012-07-01″ my_dateto=”2012-12-02″ ]
function my_querymap($atts, $content = null) {
global $my_datefrom, $my_dateto;
extract( shortcode_atts( array(
‘my_datefrom’ => date(‘Y-m-d’, strtotime(‘-30 days’)),
‘my_dateto’ => date(‘Y-m-d’),
), $atts ) );
$result = “”;
// Do the query to return desired posts for my_datefrom to my_dateto:
$my_query_string = array(‘category_name’ => ‘my_categoryname’, ‘orderby’ => ‘date’, ‘order’ => ‘DESC’, ‘posts_per_page’ => ‘-1’);
// Add a filter that will add our where clause to the query
add_filter(‘posts_where’, ‘my_filter_where’);
$my_query = new WP_Query( $my_query_string );
$my_news = $my_query->get_posts();
remove_filter(‘posts_where’, ‘my_filter_where’);
… more code would go here to create the map from the query results …
I hope that helps. If not, maybe Chris can suggest an easier way to do what you want.
Brad