| Line 55... |
Line 55... |
| 55 |
# First display the list of classes for this year...
|
55 |
# First display the list of classes for this year...
|
| 56 |
my $class_list_sql = <<class_list_sql;
|
56 |
my $class_list_sql = <<class_list_sql;
|
| 57 |
select v_class_new.id, name, v_class_new.dayofweek, v_class_new.date, v_class_new.time, v_class_new.start_time, v_class_new.location, level, available from v_class_new
|
57 |
select v_class_new.id, name, v_class_new.dayofweek, v_class_new.date, v_class_new.time, v_class_new.start_time, v_class_new.location, level, available from v_class_new
|
| 58 |
left join v_shift on
|
58 |
left join v_shift on
|
| 59 |
v_class_new.date = v_shift.date and
|
59 |
v_class_new.date = v_shift.date and
|
| 60 |
v_class_new.start_time = v_shift.start_time and
|
60 |
time(v_class_new.start_time) = time(v_shift.start_time) and
|
| 61 |
v_class_new.location = v_shift.location and
|
61 |
v_class_new.location = v_shift.location and
|
| 62 |
v_shift.dept = "COA"
|
62 |
v_shift.dept = "COA"
|
| 63 |
where RCid = ? and year(v_class_new.date) = year(now())
|
63 |
where RCid = ? and year(v_class_new.date) = year(now())
|
| 64 |
order by v_class_new.date desc, v_class_new.start_time desc
|
64 |
order by v_class_new.date desc, v_class_new.start_time desc
|
| 65 |
class_list_sql
|
65 |
class_list_sql
|
| Line 92... |
Line 92... |
| 92 |
# Then get all of the prior year classes...
|
92 |
# Then get all of the prior year classes...
|
| 93 |
my $class_list_sql = <<class_list_sql;
|
93 |
my $class_list_sql = <<class_list_sql;
|
| 94 |
select v_class_new.id, name, v_class_new.dayofweek, v_class_new.date, v_class_new.time, v_class_new.location, level, stars, responses from v_class_new
|
94 |
select v_class_new.id, name, v_class_new.dayofweek, v_class_new.date, v_class_new.time, v_class_new.location, level, stars, responses from v_class_new
|
| 95 |
left join v_shift on
|
95 |
left join v_shift on
|
| 96 |
v_class_new.date = v_shift.date and
|
96 |
v_class_new.date = v_shift.date and
|
| 97 |
v_class_new.start_time = v_shift.start_time and
|
97 |
time(v_class_new.start_time) = time(v_shift.start_time) and
|
| 98 |
v_class_new.location = v_shift.location and
|
98 |
v_class_new.location = v_shift.location and
|
| 99 |
v_shift.dept = "COA"
|
99 |
v_shift.dept = "COA"
|
| 100 |
where RCid = ? and year(v_class_new.date) < year(now())
|
100 |
where RCid = ? and year(v_class_new.date) < year(now())
|
| 101 |
order by v_class_new.date desc, v_class_new.start_time desc
|
101 |
order by v_class_new.date desc, v_class_new.start_time desc
|
| 102 |
class_list_sql
|
102 |
class_list_sql
|