| Line 118... |
Line 118... |
| 118 |
push @sysadmins, $h->li ($h->a ({ href=>"/schedule/settings.pl" }, "System Settings"));
|
118 |
push @sysadmins, $h->li ($h->a ({ href=>"/schedule/settings.pl" }, "System Settings"));
|
| 119 |
push @sysadmins, $h->li ($h->a ({ href=>"/schedule/volhours_report.pl?limit=All" }, "YEAR END VOLUNTEER HOURS REPORT"));
|
119 |
push @sysadmins, $h->li ($h->a ({ href=>"/schedule/volhours_report.pl?limit=All" }, "YEAR END VOLUNTEER HOURS REPORT"));
|
| Line 120... |
Line 120... |
| 120 |
|
120 |
|
| 121 |
my ($signupcount) = $dbh->selectrow_array ("select sum(count) from v_class where year(date) = year(now())");
|
121 |
my ($signupcount) = $dbh->selectrow_array ("select sum(count) from v_class where year(date) = year(now())");
|
| - |
|
122 |
my ($mvpcount) = $dbh->selectrow_array ("select count(*) from v_official where isnull(MVPid) = false");
|
| Line 122... |
Line 123... |
| 122 |
my ($mvpcount) = $dbh->selectrow_array ("select count(*) from v_official where isnull(MVPid) = false");
|
123 |
my ($total_class_count) = $dbh->selectrow_array ("select sum(capacity) from v_class");
|
| Line 123... |
Line 124... |
| 123 |
|
124 |
|
| - |
|
125 |
$mvpcount = 1 unless $mvpcount;
|
| Line 124... |
Line 126... |
| 124 |
$mvpcount = 1 unless $mvpcount;
|
126 |
|
| 125 |
|
127 |
push @sysadmins, $h->li ($mvpcount." MVP Passholders have signed up for ".$signupcount." spots (".sprintf("%.2f", ($signupcount / ($mvpcount*getSetting("MAX_CLASS_SIGNUP"))) * 100)."\% of allowable signups).");
|
| 126 |
push @sysadmins, $h->li ($mvpcount." MVP Passholders have signed up for ".$signupcount." spots (".sprintf("%.2f", ($signupcount / ($mvpcount*6)) * 100)."\%).");
|
128 |
push @sysadmins, $h->li (sprintf("%.2f", ($signupcount / $total_class_count) * 100)."\% of total class spaces are filled.");
|
| 127 |
|
129 |
|