| Line 71... |
Line 71... |
| 71 |
push @managers, $h->li ($h->a ({ href=>"/schedule/manage_shifts.pl" }, "Update your department shift schedule"));
|
71 |
push @managers, $h->li ($h->a ({ href=>"/schedule/manage_shifts.pl" }, "Update your department shift schedule"));
|
| 72 |
push @managers, $h->li ($h->a ({ href=>"/schedule/log.pl" }, "Activity Log"));
|
72 |
push @managers, $h->li ($h->a ({ href=>"/schedule/log.pl" }, "Activity Log"));
|
| 73 |
# Shift Report: select dayofweek, count(RCid) as filled_shifts, count(*) - count(RCid) as open_shifts, count(*) as total_shifts from v_shift group by date order by date
|
73 |
# Shift Report: select dayofweek, count(RCid) as filled_shifts, count(*) - count(RCid) as open_shifts, count(*) as total_shifts from v_shift group by date order by date
|
| 74 |
}
|
74 |
}
|
| Line -... |
Line 75... |
| - |
|
75 |
|
| - |
|
76 |
my @sysadmins;
|
| - |
|
77 |
if ($LVL >= 5) {
|
| - |
|
78 |
push @sysadmins, $h->li ($h->a ({ href=>"/schedule/bulk_upload.pl" }, "Upload a CSV of Department Shifts"));
|
| - |
|
79 |
}
|
| 75 |
|
80 |
|
| 76 |
my @activity_log;
|
81 |
my @activity_log;
|
| 77 |
my $alog = $dbh->prepare("select timestamp, event from v_log where RCid = ? limit 10");
|
82 |
my $alog = $dbh->prepare("select timestamp, event from v_log where RCid = ? limit 10");
|
| 78 |
$alog->execute($user->{RCid});
|
83 |
$alog->execute($user->{RCid});
|
| 79 |
while (my @logs = $alog->fetchrow_array) {
|
84 |
while (my @logs = $alog->fetchrow_array) {
|
| Line 94... |
Line 99... |
| 94 |
|
99 |
|
| Line 95... |
Line 100... |
| 95 |
print $h->div ({ class=>"index" }, [$h->p ({ class=>"heading" }, "Things you can do:"), $h->ul ([ @everyone ]) ]);
|
100 |
print $h->div ({ class=>"index" }, [$h->p ({ class=>"heading" }, "Things you can do:"), $h->ul ([ @everyone ]) ]);
|
| Line 96... |
Line 101... |
| 96 |
|
101 |
|
| - |
|
102 |
print $h->div ({ class=>"index" }, [$h->p ({ class=>"heading" }, "Things you can do as a Lead:"), $h->ul ([ @leads ]) ]) if ($LVL > 1);
|
| - |
|
103 |
|
| Line 97... |
Line 104... |
| 97 |
print $h->div ({ class=>"index" }, [$h->p ({ class=>"heading" }, "Things you can do as a Lead:"), $h->ul ([ @leads ]) ]) if ($LVL > 1);
|
104 |
print $h->div ({ class=>"index" }, [$h->p ({ class=>"heading" }, "Things you can do as a Manager:"), $h->ul ([ @managers ]) ]) if ($LVL > 2);
|
| Line 98... |
Line 105... |
| 98 |
|
105 |
|