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