[guadec-web] New report for lunch

[Alexandre Franke <afranke src gnome org>]

commit a9afd65953adda5c04da81ba01da969d3469765c
Author: Alexandre Franke <alexandre franke gmail com>
Date:   Fri Jul 25 01:05:43 2014 +0200

    New report for lunch

 guadec/access-register.php |   28 ++++++++++++++++++++++++++++
 1 files changed, 28 insertions(+), 0 deletions(-)
---
diff --git a/guadec/access-register.php b/guadec/access-register.php
index f25f0a5..8361305 100644
--- a/guadec/access-register.php
+++ b/guadec/access-register.php
@@ -177,6 +177,29 @@ function display_accommodation($result){
        echo "</table></div>";
 }
 
+function display_lunch($result){
+       echo "<div>";
+       echo "<table class='regtable'><thead><tr><th>ID</th><th>Name</th>
+                               <th>Lunch days</th>
+                               <th>Dietary requirements</th>
+                               <th>Payment Status</th>
+                               </tr></thead>";
+       echo"<tbody>";
+       foreach($result as $results){
+               echo "<tr>";
+               echo "<td>"; echo $results['id']; echo "</td>";
+               echo "<td>"; echo $results['name']; echo "</td>";
+               echo "<td>"; echo $results['lunchdays']; echo "</td>";
+               echo "<td>FIXME</td>";
+               echo "<td>"; echo $results['payment']; echo "</td>";
+               echo "</tr>";
+       }
+       echo"</tbody>";
+       echo "<tfoot><tr><td>Total</td><td colspan='4'>"; echo count($result); echo " people with meals</td>
+                               </tr></tfoot>";
+       echo "</table></div>";
+}
+
 require_once("header.php");
  if( !(current_user_can( 'administrator' ) )){
        echo "You are not authorised to view this page.";
@@ -242,6 +265,10 @@ else{
                        $result = $wpdb->get_results("SELECT * FROM wp_guadec2014_registrations WHERE accom = 
'YES' AND payment != 'Dupe'", ARRAY_A);
                        echo display_accommodation($result);
                        break;
+               case 'showaccommodation' :
+                       $result = $wpdb->get_results("SELECT * FROM wp_guadec2014_registrations WHERE 
lunchfee != '0' AND payment != 'Dupe'", ARRAY_A);
+                       echo display_lunch($result);
+                       break;
                    default :
                        $result = 'Error';
                break;
@@ -257,6 +284,7 @@ else{
        <option value='showcomplete'>Only Completed Registration</option>
        <option value='showtotals'>Totals For Completed And OnSite Registrations</option>
        <option value='showaccommodation'>Accommodation</option>
+       <option value='showlunch'>Lunch</option>
                </select></div>
                <input type='submit' value='Go' />
                </form>";