* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with eCamp. If not, see <http://www.gnu.org/licenses/>.
*/
$event_list = array();
$event_date = new c_date();
$event_time = new c_time();
$query = "\tSELECT\n\t\t\t\t\tevent.id as event_id,\n\t\t\t\t\tevent.name,\n\t\t\t\t\tcategory.id as category_id,\n\t\t\t\t\tcategory.short_name,\n\t\t\t\t\tcategory.form_type,\n\t\t\t\t\tcategory.color,\n\t\t\t\t\tevent_instance.id,\n\t\t\t\t\tevent_instance.starttime,\n\t\t\t\t\tevent_instance.length,\n\t\t\t\t\t(subcamp.start + day.day_offset) as event_date,\n\t\t\t\t\tevent.progress,\n\t\t\t\t\tday.id as day_id,\n\t\t\t\t\t(day.day_offset + 1) as daynr,\n\t\t\t\t\t(\t\n\t\t\t\t\t\tSELECT\n\t\t\t\t\t\t\tcount(event_instance_down.id)\n\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\tevent_instance as event_instance_up,\n\t\t\t\t\t\t\tevent_instance as event_instance_down,\n\t\t\t\t\t\t\tevent,\n\t\t\t\t\t\t\tcategory\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\tevent_instance_up.id = event_instance.id AND\n\t\t\t\t\t\t\tevent_instance_up.day_id = event_instance_down.day_id AND\n\t\t\t\t\t\t\tevent_instance_down.event_id = event.id AND\n\t\t\t\t\t\t\tevent.category_id = category.id AND\n\t\t\t\t\t\t\tcategory.form_type > 0 AND\n\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\tevent_instance_down.starttime < event_instance_up.starttime OR\n\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\tevent_instance_down.starttime = event_instance_up.starttime AND\n\t\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\t\tevent_instance_down.dleft < event_instance_up.dleft OR\n\t\t\t\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t\t\t\tevent_instance_down.dleft = event_instance_up.dleft AND\n\t\t\t\t\t\t\t\t\t\t\tevent_instance_down.id <= event_instance_up.id\n\t\t\t\t\t\t\t)\t)\t)\t)\n\t\t\t\t\t) as eventnr\n\t\t\t\tFROM\n\t\t\t\t\tevent,\n\t\t\t\t\tevent_instance,\n\t\t\t\t\tcategory,\n\t\t\t\t\tday,\n\t\t\t\t\tsubcamp\n\t\t\t\tWHERE\n\t\t\t\t\tsubcamp.camp_id = {$_camp->id} AND\n\t\t\t\t\tday.id = {$day_id} AND\n\t\t\t\t\tday.subcamp_id = subcamp.id AND\n\t\t\t\t\tevent_instance.day_id = day.id AND\n\t\t\t\t\t\n\t\t\t\t\tevent.camp_id = {$_camp->id} AND\n\t\t\t\t\tevent.category_id = category.id AND\n\t\t\t\t\t\n\t\t\t\t\tevent.id = event_instance.event_id\n\t\t\t\tORDER BY\n\t\t\t\t\tevent_instance.starttime, eventnr";
$query = "\tSELECT\n\t\t\t\t\tevent.id as event_id,\n\t\t\t\t\tevent.name,\n\t\t\t\t\tcategory.id as category_id,\n\t\t\t\t\tcategory.short_name,\n\t\t\t\t\tcategory.form_type,\n\t\t\t\t\tcategory.color,\n\t\t\t\t\tevent_instance.id,\n\t\t\t\t\tevent_instance.starttime,\n\t\t\t\t\tevent_instance.length,\n\t\t\t\t\t(subcamp.start + day.day_offset) as event_date,\n\t\t\t\t\tevent.progress,\n\t\t\t\t\tday.id as day_id,\n\t\t\t\t\tv_event_nr.day_nr as daynr,\n\t\t\t\t\tv_event_nr.event_nr as eventnr\n\t\t\t\tFROM\n\t\t\t\t\tv_event_nr,\n\t\t\t\t\tevent,\n\t\t\t\t\tevent_instance,\n\t\t\t\t\tcategory,\n\t\t\t\t\tday,\n\t\t\t\t\tsubcamp\n\t\t\t\tWHERE\n\t\t\t\t\tv_event_nr.event_instance_id = event_instance.id AND\n\t\t\t\t\tsubcamp.camp_id = {$_camp->id} AND\n\t\t\t\t\tday.id = {$day_id} AND\n\t\t\t\t\tday.subcamp_id = subcamp.id AND\n\t\t\t\t\tevent_instance.day_id = day.id AND\n\t\t\t\t\t\n\t\t\t\t\tevent.camp_id = {$_camp->id} AND\n\t\t\t\t\tevent.category_id = category.id AND\n\t\t\t\t\t\n\t\t\t\t\tevent.id = event_instance.event_id\n\t\t\t\tORDER BY\n\t\t\t\t\tevent_instance.starttime, eventnr";
$result = mysql_query($query);
while ($event_instance = mysql_fetch_assoc($result)) {
$event_instance['event_date_str'] = $event_date->setDay2000($event_instance['event_date'])->getString('d.m.Y');
$event_instance['starttime_str'] = $event_time->setValue($event_instance['starttime'])->getString('H:i');
$event_instance['endtime'] = $event_instance['starttime'] + $event_instance['length'];
$event_instance['endtime_str'] = $event_time->setValue($event_instance['endtime'])->getString('H:i');
if ($event_instance['length_str'] = $event_time->setValue($event_instance['length'])->getMin()) {
$event_instance['length_str'] = $event_time->setValue($event_instance['length'])->getString('G\\h i\\m\\i\\n');
} else {
$event_instance['length_str'] = $event_time->setValue($event_instance['length'])->getString('G\\h');
}
if ($event_instance['short_name']) {
$event_instance['short_name_str'] = $event_instance['short_name'] . ":";
} else {
$event_instance['short_name_str'] = "";
}
$event_instance['color_str'] = "background-color: #" . $event_instance['color'];
if ($event_instance['form_type']) {
$event_instance['progress'] .= "%";
$query = "SELECT * FROM course_checklist WHERE pid=" . $this_level1[id] . " ORDER BY short_2";
$result2 = mysql_query($query);
$level2 = array();
while ($this_level2 = @mysql_fetch_assoc($result2)) {
// Events suchen, die die Checkliste erfüllen
$events = array();
$query = "SELECT \r\n\t\t\t\t\t\t\t i.id\r\n\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t event_checklist ch,\r\n\t\t\t\t\t\t\t event e,\r\n\t\t\t\t\t\t\t event_instance i\r\n\t\t\t\t\t\t\tWHERE \r\n\t\t\t\t\t\t\t ch.checklist_id = {$this_level2['id']}\r\n\t\t\t\t\t\t\tAND e.camp_id={$_camp->id}\r\n\t\t\t\t\t\t\tAND e.id = ch.event_id\r\n\t\t\t\t\t\t\tAND i.event_id = e.id\r\n\t\t\t\t\t\t\tORDER BY i.day_id, i.starttime";
$result3 = mysql_query($query);
$no_events = true;
while ($this_level3_instance = @mysql_fetch_assoc($result3)) {
$this_level3 = $campevents[$this_level3_instance["id"]];
$no_events = false;
$start = new c_time();
$start->setValue($this_level3[start]);
$end = new c_time();
$end->setValue($this_level3[end]);
$date = new c_date();
$date->setDay2000($this_level3[day]);
$this_level3[date] = $GLOBALS[en_to_de][$date->getString("D")] . ", " . $date->getString("j.n.") . " " . $start->getString("G:i") . "-" . $end->getString("G:i");
//"Fr, 5.10. 17:15-18:00";
if ($this_level3['short_name']) {
$this_level3['short_name'] .= ": ";
}
$events[] = $this_level3;
}
$level2[] = array("short" => $this_level2[short], "name" => $this_level2[name], "no_events" => $no_events, "events" => $events);
}
$list[$i][] = array("level2" => $level2, "short" => $this_level1[short], "name" => $this_level1[name]);
}
}
// PHPTAL Variablen setzen
function event_list($pdf, $day)
{
// Tabellenkopf:
// ===============
$pdf->SetFont('', 'B', 8);
$pdf->SetXY(12, $this->y);
$pdf->drawTextBox('Zeit:', 38, 4, 'L', 'T', 0);
$pdf->SetXY(52, $this->y);
$pdf->drawTextBox('Blockbezeichnung:', 68, 4, 'L', 'T', 0);
$pdf->SetXY(132, $this->y);
$pdf->drawTextBox('Verantwortliche/r', 68, 4, 'L', 'T', 0);
$this->y += 4;
$pdf->Line(10, $this->y, 190, $this->y);
$this->y += 2;
// Tablleninhalt:
// ================
$s_time = new c_time();
$e_time = new c_time();
$day->gen_event_nr();
foreach ($day->get_sorted_event_instance() as $event_instance) {
if ($event_instance->event->category->form_type) {
$pdf->SetFont('', 'B', 8);
} else {
$pdf->SetFont('', '', 8);
}
$s_time->setValue($event_instance->starttime);
$e_time->setValue($event_instance->starttime + $event_instance->length);
$time = $s_time->getString('H:i') . " - " . $e_time->getString('H:i');
$name = "";
if ($event_instance->event->category->form_type) {
$name .= "(" . $day->day_nr . "." . $event_instance->event_nr . ") ";
}
if ($event_instance->event->category->short_name != "") {
$name .= $event_instance->event->category->short_name . ": ";
}
$name .= $event_instance->event->name;
$resp = "";
foreach ($event_instance->event->event_responsible as $event_responsible) {
$resp .= $event_responsible->scoutname . ", ";
}
$resp = substr($resp, 0, -2);
$pdf->SetXY(12, $this->y);
$pdf->Cell(38, 4, $time, 0, 0, 'L', 0, $event_instance->get_linker($pdf));
//$pdf->drawTextBox( $time, 38, 4, 'L', 'T', 0 );
$pdf->SetXY(52, $this->y);
$pdf->Cell(68, 4, $name, 0, 0, 'L', 0, $event_instance->get_linker($pdf));
//$pdf->drawTextBox( $name, 68, 4, 'L', 'T', 0 );
$pdf->SetXY(132, $this->y);
$pdf->Cell(68, 4, $resp, 0, 0, 'L', 0, $event_instance->get_linker($pdf));
//$pdf->drawTextBox( $resp, 68, 4, 'L', 'T', 0 );
$this->y += 4;
}
$this->y += 10;
}
$result2 = mysql_query($query);
$aim_str = "";
while ($this_aim = mysql_fetch_assoc($result2)) {
$aim_str = $aim_str . "- " . $this_aim[aim] . "\n";
}
///////////////////////
// format output
///////////////////////
// name
$worksheet->write($row, 0, $this_event[name] . " " . $checklist_str, $format_content);
//echo $this_event[name]." ".$checklist_str." ";
// date
$start = new c_time();
$start->setValue($this_event[start]);
$end = new c_time();
$end->setValue($this_event[end]);
$date = new c_date();
$date->setDay2000($this_event[day]);
$this_date = $GLOBALS[en_to_de][$date->getString("D")] . ", " . $date->getString("j.n.") . ", " . $start->getString("G:i") . "-" . $end->getString("G:i");
//"Fr, 5.10., 17:15-18:00";
$worksheet->write($row, 1, $this_date, $format_content);
//echo $this_date." ";
// aim
$worksheet->write($row, 2, $aim_str, $format_content);
//echo $aim_str." ";
// event-aim
$worksheet->write($row, 3, $this_event[aim], $format_content);
//echo $this_event[aim]." ";
// topics
$worksheet->write($row, 4, $this_event[topics], $format_content);
//echo $this_event[topics]." ";
array_push($dp_header['users'], $row[scoutname]);
} else {
array_push($dp_header['users'], $row[firstname] . " " . $row[surname]);
}
}
$dp_header['place'] = array("value" => $event_place, "event_id" => $event_id, "script" => "action_change_place");
$query = "\tSELECT\n\t\t\t\t\tevent_instance.starttime,\n\t\t\t\t\tevent_instance.length,\n\t\t\t\t\tday.day_offset + subcamp.start as startdate\n\t\t\t\tFROM\n\t\t\t\t\tevent_instance,\n\t\t\t\t\tday,\n\t\t\t\t\tsubcamp\n\t\t\t\tWHERE\n\t\t\t\t\tevent_instance.event_id = {$event_id} AND\n\t\t\t\t\tevent_instance.day_id = day.id AND\n\t\t\t\t\tday.subcamp_id = subcamp.id";
$result = mysql_query($query);
$date = new c_date();
$start = new c_time();
$end = new c_time();
$dp_header['event_instance'] = array();
while ($row = mysql_fetch_assoc($result)) {
$date->setDay2000($row['startdate']);
$start->setValue($row['starttime']);
$end->setValue($row['starttime'] + $row['length']);
$dp_header['event_instance'][] = array('startdate' => date("d.m.Y", $date->getUnix()), 'starttime' => $start->getString("H:i") . " - " . $end->getString("H:i"));
}
$_page->html->set('dp_header', $dp_header);
// HEAD:
// =======
$dp_head_show = array();
$query = "\tSELECT\n\t\t\t\t\tdropdown.value as form,\n\t\t\t\t\t(dropdown.value = category.form_type) as show_form\n\t\t\t\tFROM\n\t\t\t\t\tevent,\n\t\t\t\t\tcategory,\n\t\t\t\t\tdropdown\n\t\t\t\tWHERE\n\t\t\t\t\tevent.id = {$event_id} AND\n\t\t\t\t\tevent.category_id = category.id AND\n\t\t\t\t\tdropdown.list = 'form'";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
$dp_head_show[$row[form]] = $row[show_form];
}
$_page->html->set('dp_head_show', $dp_head_show);
$query = "\tSELECT\n\t\t\t\t\tevent.aim as aim,\n\t\t\t\t\tevent.story as story,\n\t\t\t\t\tevent.method as method,\n\t\t\t\t\t'true' as visible\n\t\t\t\tFROM\n\t\t\t\t\tevent\n\t\t\t\tWHERE\n\t\t\t\t\tevent.id = {$event_id}";
$result = mysql_query($query);
$replace = mysql_fetch_assoc($result);
function EventInstance($event_instance_id)
{
$Data = EventInstanceData($event_instance_id);
// Reicht der Platz aus, um den Block zu drucken...
$y = $this->GetY();
$head = $Data[head];
$this->pdf->SetFillColor(hexdec(substr($head[color], 0, 2)), hexdec(substr($head[color], 2, 2)), hexdec(substr($head[color], 4, 2)));
$this->pdf->RoundedRect(10, $y, 190, 18, $this->R, 'DF', '1234');
$display = "(" . $head[day_nr] . "." . $head[event_nr] . ") " . $head[short_name] . ": " . $head[name];
$this->pdf->setFontSize(20);
$this->pdf->SetFontStyle('B');
$this->SetXY(15, $y);
$this->pdf->Cell(120, 18, $display, 0, 1, 'L', 0);
$this->pdf->setFontSize(10);
$this->pdf->SetFontStyle('B');
$this->SetXY(140, $y + 1);
$this->pdf->Write(5, "Datum:");
$this->SetXY(140, $y + 6.5);
$this->pdf->Write(5, "Zeit:");
$this->SetXY(140, $y + 12);
$this->pdf->Write(5, "Ort:");
$start_date = new c_date();
$start_date->setDay2000($head[start]);
$this->SetXY(160, $y + 1);
$this->pdf->Write(5, strtr($start_date->getString("D d.m.Y"), $GLOBALS[en_to_de]));
$start_time = new c_time();
$start_time->setValue($head[starttime]);
$end_time = new c_time();
$end_time->setValue($head[starttime] + $head[length]);
$this->SetXY(160, $y + 6.5);
$this->pdf->Write(5, $start_time->getString("H:i") . " - " . $end_time->getString("H:i"));
$this->SetXY(160, $y + 12);
$this->pdf->Write(5, $head[place]);
$this->SetXY(10, $y + 18);
$this->Space(4);
$this->LabeldTable(190, $Data[info]);
$this->Space(4);
$this->LabeldCols(190, $Data[detail]);
}
