Create printer.php

[clinton/MarylandElectronicPetitionSignature.git] / admin / index.php

diff --git a/admin/index.php b/admin/index.php
index 0c40257..ced06c3 100644 (file)
--- a/admin/index.php
+++ b/admin/index.php
@@ -11,7 +11,10 @@ if ($_COOKIE['level'] == 'manager'){
 }
 
 include_once('header.php');
-
+if(isset($_GET['approve'])){
+  $id = $_GET['approve'];
+  $petition->query("update petitions set admin_status = 'approved' where petition_id = '$id' ");
+}
 slack_general('ADMIN: Home Page Loaded ('.$_COOKIE['name'].') ('.$_COOKIE['level'].')','md-petition');
 ?>
 
@@ -26,18 +29,19 @@ while($d = mysqli_fetch_array($r)){
 }
 ?>
 
-<h1>Groups</h1>
+<h1>New Petitions</h1>
 <?PHP
-$q="SELECT * FROM groups";
+$q="SELECT * FROM petitions where admin_status='new'";
 $r = $petition->query($q);
 while($d = mysqli_fetch_array($r)){
- echo "<li>$d[id] $d[name]</li>"; 
+ echo "<li><a href='?approve=$d[petition_id]'>$d[petition_id] $d[web_short_name] $d[web_color] $d[group_id] $d[petition_name] $d[eligibleVoterListField] $d[eligibleVoterListEquals] $d[eligibleVoterListEnforce]</a></li>"; 
 }
 ?>
 
-<h1>Petitions</h1>
+
+<h1>Approved Petitions</h1>
 <?PHP
-$q="SELECT * FROM petitions";
+$q="SELECT * FROM petitions where admin_status = 'approved'";
 $r = $petition->query($q);
 while($d = mysqli_fetch_array($r)){
  echo "<li>$d[petition_id] $d[web_short_name] $d[web_color] $d[group_id] $d[petition_name] $d[eligibleVoterListField] $d[eligibleVoterListEquals] $d[eligibleVoterListEnforce]</li>"; 
@@ -45,6 +49,18 @@ while($d = mysqli_fetch_array($r)){
 ?>
 
 
+<h1>Groups</h1>
+<?PHP
+$q="SELECT * FROM groups";
+$r = $petition->query($q);
+while($d = mysqli_fetch_array($r)){
+ echo "<li>$d[id] $d[name]</li>"; 
+}
+?>
+
+
+
+
 <h1>Website</h1>
 <?PHP
 $q="SELECT * FROM website_text";