Commit | Line | Data |
---|---|---|
756271d6 | 1 | <?PHP |
f628bd2d | 2 | include_once('../slack.php'); |
756271d6 | 3 | include_once('security.php'); |
f628bd2d PM |
4 | if ($_COOKIE['level'] == 'user'){ |
5 | slack_general('ADMIN: Redirect User Home ('.$_COOKIE['name'].') ('.$_COOKIE['level'].')','md-petition'); | |
50f53cd0 | 6 | header('Location: user_home.php'); |
f628bd2d PM |
7 | } |
8 | if ($_COOKIE['level'] == 'manager'){ | |
9 | slack_general('ADMIN: Redirect Manager Home ('.$_COOKIE['name'].') ('.$_COOKIE['level'].')','md-petition'); | |
50f53cd0 | 10 | header('Location: manager_home.php'); |
f628bd2d | 11 | } |
756271d6 | 12 | include_once('header.php'); |
65583de7 PM |
13 | if ($_POST['name']){ |
14 | $name = $petition->real_escape_string($_POST['name']); | |
15 | $email = $petition->real_escape_string($_POST['email']); | |
16 | $sec_level = $petition->real_escape_string($_POST['sec_level']); | |
17 | $group_id = $petition->real_escape_string($_POST['group_id']); | |
18 | $petition_id = $petition->real_escape_string($_POST['petition_id']); | |
19 | $q = "insert into users (name, email, sec_level, group_id, petition_id) values ('$name','$email','$sec_level','$group_id','$petition_id') "; | |
20 | $petition->query($q); | |
21 | slack_general_admin('SQL: '.$q,'md-petition'); | |
22 | } | |
3e0665a6 PM |
23 | if(isset($_GET['approve'])){ |
24 | $id = $_GET['approve']; | |
25 | $petition->query("update petitions set admin_status = 'approved' where petition_id = '$id' "); | |
26 | } | |
56d09719 | 27 | slack_general('ADMIN: Home Page Loaded ('.$_COOKIE['name'].') ('.$_COOKIE['level'].')','md-petition'); |
756271d6 PM |
28 | ?> |
29 | ||
2f29676b | 30 | <h1>Admin Home</h1> |
d5f7c1e8 | 31 | <div id="chartContainer1" style="height: 400px; width: 100%; margin: 0px auto;"></div> |
ccb1ab4b | 32 | <h1>Users</h1> |
0f0f2090 PM |
33 | <form method='post'> |
34 | <table> | |
35 | <tr><td>Name</td><td><input name='name' required></td></tr> | |
36 | <tr><td>E-Mail</td><td><input name='email' required></td></tr> | |
37 | <tr><td>Security Level</td><td><input name='sec_level' required></td></tr> | |
38 | <tr><td>Group ID</td><td><input name='group_id' required></td></tr> | |
39 | <tr><td>Petition ID</td><td><input name='petition_id' required></td></tr> | |
40 | <tr><td></td><td><input type='submit' value='New User'></td></tr> | |
41 | </table> | |
42 | </form> | |
f628bd2d PM |
43 | <?PHP |
44 | $q="SELECT * FROM users"; | |
45 | $r = $petition->query($q); | |
46 | while($d = mysqli_fetch_array($r)){ | |
7240cd63 PM |
47 | $alert=''; |
48 | if ($d[pass] == ''){ | |
49 | $alert='NEEDS PASSWORD RESET'; | |
50 | } | |
0f0f2090 | 51 | echo "<li>ID $d[id] EM $d[email] NM $d[name] GI $d[group_id] PI $d[petition_id] SL $d[sec_level] $alert</li>"; |
f628bd2d PM |
52 | } |
53 | ?> | |
ccb1ab4b | 54 | |
3e0665a6 | 55 | <h1>New Petitions</h1> |
ccb1ab4b | 56 | <?PHP |
3e0665a6 | 57 | $q="SELECT * FROM petitions where admin_status='new'"; |
ccb1ab4b PM |
58 | $r = $petition->query($q); |
59 | while($d = mysqli_fetch_array($r)){ | |
3e0665a6 | 60 | 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>"; |
ccb1ab4b PM |
61 | } |
62 | ?> | |
63 | ||
3e0665a6 PM |
64 | |
65 | <h1>Approved Petitions</h1> | |
ccb1ab4b | 66 | <?PHP |
3e0665a6 | 67 | $q="SELECT * FROM petitions where admin_status = 'approved'"; |
ccb1ab4b PM |
68 | $r = $petition->query($q); |
69 | while($d = mysqli_fetch_array($r)){ | |
70 | 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>"; | |
71 | } | |
72 | ?> | |
73 | ||
74 | ||
3e0665a6 PM |
75 | <h1>Groups</h1> |
76 | <?PHP | |
77 | $q="SELECT * FROM groups"; | |
78 | $r = $petition->query($q); | |
79 | while($d = mysqli_fetch_array($r)){ | |
80 | echo "<li>$d[id] $d[name]</li>"; | |
81 | } | |
82 | ?> | |
83 | ||
84 | ||
85 | ||
86 | ||
ccb1ab4b PM |
87 | <h1>Website</h1> |
88 | <?PHP | |
89 | $q="SELECT * FROM website_text"; | |
90 | $r = $petition->query($q); | |
91 | while($d = mysqli_fetch_array($r)){ | |
92 | echo "<li>$d[id] $d[text_title]</li>"; | |
93 | } | |
94 | ?> | |
756271d6 | 95 | |
d5f7c1e8 PM |
96 | <?PHP |
97 | $pID = 1; | |
98 | //echo "<div id=\"chartContainer$pID\" style=\"height: 400px; width: 100%; margin: 0px auto;\"></div>"; | |
99 | $chart=''; | |
100 | $chart2=''; | |
101 | $chart3=''; | |
102 | $q3 = "SELECT just_date FROM signatures where just_date <> '0000-00-00' group by just_date"; | |
103 | //echo "<li>$q3</li>"; | |
104 | $r3 = $petition->query($q3); | |
105 | $total=0; | |
106 | $goal = $d['signature_goal']; | |
107 | if ($goal == 0){ | |
108 | $goal = 10000; | |
109 | } | |
110 | while ($d3 = mysqli_fetch_array($r3)){ | |
111 | $just_date = $d3['just_date']; | |
112 | $q2 = "SELECT * FROM signatures where just_date = '$just_date' and signature_status = 'verified' "; | |
113 | //echo "<li>$q2</li>"; | |
114 | $r2 = $petition->query($q2); | |
115 | $count = mysqli_num_rows($r2); | |
116 | $chart .= '{ label: "'.$just_date.'", y: '.intval($count).' }, '; | |
117 | $total = $total + intval($count); | |
118 | $chart2 .= '{ label: "'.$just_date.'", y: '.intval($total).' }, '; | |
119 | $goal = $goal - intval($count); | |
120 | $chart3 .= '{ label: "'.$just_date.'", y: '.intval($goal).' }, '; | |
121 | } | |
122 | $chart = rtrim(trim($chart), ","); | |
123 | $chart2 = rtrim(trim($chart2), ","); | |
124 | $chart3 = rtrim(trim($chart3), ","); | |
125 | ||
126 | ob_start(); ?> | |
127 | ||
128 | var chart<?PHP echo $pID;?> = new CanvasJS.Chart("chartContainer<?PHP echo $pID;?>", { | |
129 | theme:"light2", | |
130 | animationEnabled: true, | |
131 | exportEnabled: true, | |
132 | title:{ | |
133 | text: "MD-Petition.com Signature Tracker" | |
134 | }, | |
135 | axisY :{ | |
136 | includeZero: false, | |
137 | title: "Number of Signatures", | |
138 | suffix: "", | |
139 | scaleBreaks: { | |
140 | autoCalculate: true | |
141 | } | |
142 | }, | |
143 | toolTip: { | |
144 | shared: "true" | |
145 | }, | |
146 | legend:{ | |
147 | cursor:"pointer", | |
148 | itemclick : toggleDataSeries | |
149 | }, | |
150 | data: [{ | |
151 | type: "line", | |
152 | visible: true, | |
153 | showInLegend: true, | |
154 | yValueFormatString: "#####", | |
155 | name: "Total Signatures Count", | |
156 | dataPoints: [ | |
157 | <?PHP echo $chart2; ?> | |
158 | ] | |
159 | },{ | |
160 | type: "column", | |
161 | visible: true, | |
162 | showInLegend: true, | |
163 | yValueFormatString: "#####", | |
164 | name: "New Daily Signatures", | |
165 | dataPoints: [ | |
166 | <?PHP echo $chart; ?> | |
167 | ] | |
168 | }] | |
169 | } | |
170 | ||
171 | ||
172 | ); | |
173 | chart<?PHP echo $pID;?>.render(); | |
174 | ||
175 | <?PHP $javascript .= ob_get_clean(); ?> | |
176 | ||
177 | ||
178 | ||
3d1d8f71 PM |
179 | <script> |
180 | window.onload = function () { | |
181 | ||
182 | <?PHP echo $javascript;?> | |
183 | ||
184 | function toggleDataSeries(e) { | |
185 | if (typeof(e.dataSeries.visible) === "undefined" || e.dataSeries.visible ){ | |
186 | e.dataSeries.visible = false; | |
187 | } else { | |
188 | e.dataSeries.visible = true; | |
189 | } | |
190 | chart.render(); | |
191 | } | |
192 | ||
193 | } | |
194 | </script> | |
28ac92e6 | 195 | <script src="../files/canvasjs.min.js"></script> |
756271d6 | 196 | <?PHP |
3d1d8f71 | 197 | |
d5f7c1e8 | 198 | |
756271d6 PM |
199 | include_once('footer.php'); |
200 | ?> |