PODS CMS pods double where clause


/ Published in: PHP
Save to your folder(s)



Copy this code and paste it in your HTML
  1. <?php
  2. /*
  3. Template Name: Month Page Template
  4. */
  5. ?>
  6. <?php
  7. $found_month = false;
  8.  
  9. global $pods;
  10. $month_slug = pods_url_variable(-1);
  11. $month = new Pod('month', $month_slug);
  12.  
  13. if( !empty( $month->data ) )
  14. {
  15. $found_month = true;
  16. $month_name = $month->get_field('name');
  17. }
  18. ?>
  19. <?php get_header(); ?>
  20.  
  21. <div id="content_frame">
  22. <h2><?php echo $month_name ?></h2>
  23. <script type="text/javascript" language="javascript">
  24. var name = $("#content_frame h2").html();
  25. //alert(name);
  26. $("#" + name).addClass("selected");
  27. </script>
  28.  
  29. <?php
  30.  
  31. $events = new Pod('event');
  32.  
  33. //$team->findRecords('date ASC');
  34. $pagetitle = get_page_title();
  35.  
  36. $where_clause = "DATE(t.date) >= CURDATE() && month.name = '$month_name'";
  37. $events->findRecords('date ASC', 25, $where_clause);
  38. //get_page_title()
  39. $total_members = $events->getTotalRows();
  40. ?>
  41.  
  42.  
  43. <?php if( $total_members>0 ) : ?>
  44. <?php while ( $events->fetchRecord() ) : ?>
  45. <?php
  46. // set our variables
  47. $event_name = $events->get_field('name');
  48. $event_photo = $events->get_field('poster');
  49. $slug = $events->get_field('slug');
  50. $date = $events->get_field('date');
  51. $excerpt = $events->get_field('excerpt');
  52. $with_bands = $events->get_field('with_bands');
  53. $promo_link = $events->get_field('link');
  54. $ticket_info = $events->get_field('ticket_info');
  55. $featured_event = $events->get_field('featured_event.name');
  56.  
  57.  
  58. // data cleanup
  59. //$event_photo = $event_photo[0]['guid'];
  60. $event_photo = wp_get_attachment_thumb_url($event_photo[0]['ID']);
  61. $date = date("l jS", strtotime($date));
  62. ?>
  63. <div class="listing">
  64. <div class="poster">
  65. <?php if( !empty( $event_photo ) ) : ?>
  66. <img src="<?php echo $event_photo; ?>" alt="Photo of <?php echo $event_name; ?>" />
  67. <?php endif ?>
  68. </div>
  69. <div class="info">
  70. <h5><?php echo $event_name; ?></h5>
  71.  
  72.  
  73. <p class="gig_date"><?php echo $date; ?> - <?php echo $with_bands; ?></p>
  74. <p><?php echo $excerpt; ?></p>
  75. <p><?php echo $ticket_info; ?>
  76. <?php if( $featured_event == 'yes' ) : ?>
  77. &nbsp;||&nbsp;<a href="<?php bloginfo("home"); ?>/gig/<?php echo $slug ?>">Click here for more info</a>
  78. <?php endif ?>
  79. </p>
  80.  
  81.  
  82. </div>
  83. </div>
  84. <div class="hline"></div>
  85. <?php endwhile ?>
  86. <?php endif ?>
  87.  
  88. </div><!-- #content_frame -->
  89. </div><!-- #right -->
  90. </div><!-- #top_content -->
  91.  
  92. <?php get_footer(); ?>

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.