if (is_array($active_camp_sort)) {
array_multisort($active_camp_sort, SORT_DESC, $active_camp_list);
}
$query = "SELECT camp.*,\r\n\t\t\tuser.mail,\r\n\t\t\tuser.scoutname,\r\n\t\t\tuser.surname,\r\n\t\t\tuser.firstname,\r\n\t\t\tuser_camp.id AS user_camp_id\r\n\t\tFROM\r\n\t\t\tcamp,\r\n\t\t\tuser_camp\r\n\t\t\tLEFT JOIN user ON user.id=user_camp.invitation_id\r\n\t\tWHERE\r\n\t\t\tuser_camp.user_id = '{$_user->id}' AND\r\n\t\t\tuser_camp.camp_id = camp.id AND\r\n\t\t\tuser_camp.active = 0";
$result = mysql_query($query);
$request_camp_show = mysql_num_rows($result) > 0;
while ($camp_detail = mysql_fetch_assoc($result)) {
$subquery = "SELECT \r\n\t\t\t\t\t\tMIN( subcamp.start ) AS start , \r\n\t\t\t\t\t\tMAX( subcamp.start + subcamp.length ) AS end\r\n\t\t\t\t\tFROM \r\n\t\t\t\t\t\tcamp, \r\n\t\t\t\t\t\tsubcamp \r\n\t\t\t\t\tWHERE \r\n\t\t\t\t\t\tsubcamp.camp_id = camp.id AND\r\n\t\t\t\t\t\tcamp.id = {$camp_detail['id']}";
$subresult = mysql_query($subquery);
$camp_time = mysql_fetch_assoc($subresult);
$c_start = new c_date();
$c_end = new c_date();
$c_start->setDay2000($camp_time['start']);
$c_end->setDay2000($camp_time['end']);
$camp_detail['start'] = date("d.m.Y", $c_start->getUnix());
$camp_detail['end'] = date("d.m.Y", $c_end->getUnix());
$camp_detail[scout] = $camp_detail[scout];
$camp_detail[name] = $camp_detail[name];
$camp_detail[slogan] = $camp_detail[slogan];
if ($camp_detail[mail] == "") {
$camp_detail[from] = "<unbekannt>";
} else {
$camp_detail[from] = $camp_detail[scoutname] . " / " . $camp_detail[firstname] . " " . $camp_detail[surname];
}
$request_camp_list[] = $camp_detail;
}
$show_list = $_REQUEST['show_list'] == 1 ? true : false;
$_page->html->set('show_list', $show_list);
$_page->html->set('active_camp_list', $active_camp_list);
$_page->html->set('request_camp_list', $request_camp_list);
$_page->html->set('request_camp_show', $request_camp_show);
$camp_info[input] = false;
$camp_info[readonly] = true;
} else {
$_SESSION[camp_id] = "";
header("Location: index.php");
die;
}
$start = new c_date();
$end = new c_date();
$subcamps = array();
$query = "SELECT * FROM subcamp WHERE camp_id = '{$_camp->id}' ORDER BY start ASC ";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
$start->m_days = $row['start'];
$end->m_days = $row['start'] + $row['length'] - 1;
$subcamps[] = array("start" => gmdate("d.m.Y", $start->getUnix()), "end" => gmdate("d.m.Y", $end->getUnix()), "id" => $row[id]);
}
// �berpr�fen, ob ein Lager gew�hlt wurde und Lagerdaten einlesen
$query = "\tSELECT \r\n \t\t\t\tcamp.*,\r\n \t\t\t\tgroups.name as groups_name,\r\n \t\t\t\tgroups.short_prefix as groups_short_prefix\r\n \t\t\tFROM\r\n \t\t\t\tcamp\r\n \t\t\tLEFT JOIN\r\n \t\t\t\tgroups\r\n \t\t\tON\r\n \t\t\t\tcamp.group_id = groups.id\r\n \t\t\tWHERE\r\n \t\t\t\tcamp.id = '{$_camp->id}'";
$result = mysql_query($query);
if (mysql_num_rows($result) == 0) {
die("Kein Lager gewählt");
}
$camp_data = mysql_fetch_assoc($result);
// Lager-Detaildaten herausfiltern
$num1 = strpos($camp_data['ca_coor'], ".");
$num2 = strpos($camp_data['ca_coor'], "/");
$num3 = strrpos($camp_data['ca_coor'], ".");
if ($num1 != "" && $num2 != "" && $num3 != "" && $num1 != $num3) {
$camp_data['ca_coor1'] = substr($camp_data['ca_coor'], 0, $num1);
$camp_data['ca_coor2'] = substr($camp_data['ca_coor'], $num1 + 1, $num2 - $num1 - 1);
}
$dp_header['place'] = array("value" => $event_place, "event_id" => $event_id, "script" => "action_change_place");
$query = "\tSELECT\r\n\t\t\t\t\tevent_instance.starttime,\r\n\t\t\t\t\tevent_instance.length,\r\n\t\t\t\t\tday.day_offset + subcamp.start as startdate,\r\n\t\t\t\t\t(\tSELECT\r\n\t\t\t\t\t\t\tcount(event_instance_down.id)\r\n\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\tevent_instance as event_instance_up,\r\n\t\t\t\t\t\t\tevent_instance as event_instance_down,\r\n\t\t\t\t\t\t\tevent,\r\n\t\t\t\t\t\t\tcategory\r\n\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\tevent_instance_up.id = event_instance.id AND\r\n\t\t\t\t\t\t\tevent_instance_up.day_id = event_instance_down.day_id AND\r\n\t\t\t\t\t\t\tevent_instance_down.event_id = event.id AND\r\n\t\t\t\t\t\t\tevent.category_id = category.id AND\r\n\t\t\t\t\t\t\tcategory.form_type > 0 AND\r\n\t\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\t\tevent_instance_down.starttime < event_instance_up.starttime OR\r\n\t\t\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\t\t\tevent_instance_down.starttime = event_instance_up.starttime AND\r\n\t\t\t\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\t\t\t\tevent_instance_down.dleft < event_instance_up.dleft OR\r\n\t\t\t\t\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\t\t\t\t\tevent_instance_down.dleft = event_instance_up.dleft AND\r\n\t\t\t\t\t\t\t\t\t\t\tevent_instance_down.id <= event_instance_up.id\r\n\t\t\t\t\t\t\t)\t)\t)\t)\r\n\t\t\t\t\t) as event_nr,\r\n\t\t\t\t\tday.day_offset + 1 as day_nr\r\n\t\t\t\tFROM\r\n\t\t\t\t\tevent_instance,\r\n\t\t\t\t\tday,\r\n\t\t\t\t\tsubcamp\r\n\t\t\t\tWHERE\r\n\t\t\t\t\tevent_instance.event_id = {$event_id} AND\r\n\t\t\t\t\tevent_instance.day_id = day.id AND\r\n\t\t\t\t\tday.subcamp_id = subcamp.id\r\n\t\t\t\tORDER BY\r\n\t\t\t\t\tstartdate, event_nr";
$query = "\tSELECT\r\n\t\t\t\t\tevent_instance.starttime,\r\n\t\t\t\t\tevent_instance.length,\r\n\t\t\t\t\tday.day_offset + subcamp.start as startdate,\r\n\t\t\t\t\tv_event_nr.event_nr,\r\n\t\t\t\t\tv_event_nr.day_nr\r\n\t\t\t\tFROM\r\n\t\t\t\t\tv_event_nr,\r\n\t\t\t\t\tevent_instance,\r\n\t\t\t\t\tday,\r\n\t\t\t\t\tsubcamp\r\n\t\t\t\tWHERE\r\n\t\t\t\t\tv_event_nr.event_instance_id = event_instance.id AND\r\n\t\t\t\t\tevent_instance.event_id = {$event_id} AND\r\n\t\t\t\t\tevent_instance.day_id = day.id AND\r\n\t\t\t\t\tday.subcamp_id = subcamp.id\r\n\t\t\t\tORDER BY\r\n\t\t\t\t\tstartdate, event_nr";
$result = mysql_query($query);
$date = new c_date();
$start = new c_time();
$end = new c_time();
$dp_header['event_instance'] = array();
$row = mysql_fetch_assoc($result);
$_page->html->set('event_nr', "(" . $row['day_nr'] . "." . $row['event_nr'] . ")");
do {
$date->setDay2000($row['startdate']);
$start->setValue($row['starttime']);
$end->setValue($row['starttime'] + $row['length']);
$dp_header['event_instance'][] = array('event_nr' => "(" . $row['day_nr'] . "." . $row['event_nr'] . ")", 'startdate' => date("d.m.Y", $date->getUnix()), 'starttime' => $start->getString("H:i") . " - " . $end->getString("H:i"));
} while ($row = mysql_fetch_assoc($result));
$_page->html->set('dp_header', $dp_header);
//echo "dp_header=>";
//print_r( $dp_header );
// HEAD:
// =======
$dp_head_show = array();
$query = "\tSELECT\r\n\t\t\t\t\tdropdown.value as form,\r\n\t\t\t\t\t(dropdown.value = category.form_type) as show_form\r\n\t\t\t\tFROM\r\n\t\t\t\t\tevent,\r\n\t\t\t\t\tcategory,\r\n\t\t\t\t\tdropdown\r\n\t\t\t\tWHERE\r\n\t\t\t\t\tevent.id = {$event_id} AND\r\n\t\t\t\t\tevent.category_id = category.id AND\r\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\r\n\t\t\t\t\tevent.aim as aim,\r\n\t\t\t\t\tevent.story as story,\r\n\t\t\t\t\tevent.method as method,\r\n\t\t\t\t\tevent.topics as topics,\r\n\t\t\t\t\t'true' as visible\r\n\t\t\t\tFROM\r\n\t\t\t\t\tevent\r\n\t\t\t\tWHERE\r\n\t\t\t\t\tevent.id = {$event_id}";
$result = mysql_query($query);
} 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);
$dp_head = array();
$end = $date->getString('d.m.Y');
$date->setDay2000($subcamp['start']);
$start = $date->getString('d.m.Y');
$todo_list[$date->getString('Ym')]['name'] = strtr($date->getString("F Y"), $GLOBALS[en_to_de]);
$todo_list[$date->getString('Ym')]['todos'][$date->getString('d')][] = array("date" => $start, "camptime" => true, "entry" => false, "today" => false, "short" => $start . " - " . $end);
ksort($todo_list[$date->getString("Ym")]['todos']);
}
// TODAY:
// ========
$todo_list[date("Ym")]['name'] = strtr(date("F Y"), $GLOBALS[en_to_de]);
$todo_list[date("Ym")]['todos'][date("d")][] = array("date" => strtr(date("D d. M"), $GLOBALS[en_to_de]), "camptime" => false, "entry" => false, "today" => true);
ksort($todo_list[date("Ym")]['todos']);
$query = "\tSELECT\r\n\t\t\t\t\ttodo.*\r\n\t\t\t\tFROM\r\n\t\t\t\t\ttodo\r\n\t\t\t\tWHERE\r\n\t\t\t\t\ttodo.camp_id = {$_camp->id}\r\n\t\t\t\tORDER BY\r\n\t\t\t\t\ttodo.date";
$result = mysql_query($query);
while ($todo = mysql_fetch_assoc($result)) {
if ($date->getUnix() < time()) {
$date->setDay2000($todo['date']);
if ($date->getUnix() > time()) {
//$todo_list[date("Ym")]['name'] = strtr( date("F Y"), $GLOBALS[en_to_de] );
//$todo_list[date("Ym")]['todos'][] = array( "date" => strtr( date("D d. M"), $GLOBALS[en_to_de] ), "camptime" => false, "entry" => false, "today" => true );
}
}
$date->setDay2000($todo['date']);
$todo['camptime'] = false;
$todo['today'] = false;
$todo['entry'] = true;
$todo['resp'] = array();
$todo['date'] = strtr($date->getString("D d. M"), $GLOBALS[en_to_de]);
$todo['date_value'] = $date->getString("d.m.Y");
$todo['disabled'] = $todo['done'] ? 'disabled' : '';
$subquery = "\tSELECT\r\n\t\t\t\t\t\t\tuser.id,\r\n\t\t\t\t\t\t\tuser.scoutname,\r\n\t\t\t\t\t\t\tuser.firstname,\r\n\t\t\t\t\t\t\tuser.surname,\r\n\t\t\t\t\t\t\tIF( ISNULL( todo_user_camp.todo_id ), 0, 1) as resp\r\n\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\tdropdown,\r\n\t\t\t\t\t\t\tuser,\r\n\t\t\t\t\t\t\tuser_camp\r\n\t\t\t\t\t\tLEFT JOIN\r\n\t\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\t\tSELECT\r\n\t\t\t\t\t\t\t\t\ttodo_user_camp.todo_id,\r\n\t\t\t\t\t\t\t\t\ttodo_user_camp.user_camp_id\r\n\t\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t\t\ttodo_user_camp\r\n\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\ttodo_user_camp.todo_id = {$todo['id']}\r\n\t\t\t\t\t\t\t) as todo_user_camp\r\n\t\t\t\t\t\tON\r\n\t\t\t\t\t\t\ttodo_user_camp.user_camp_id = user_camp.id\r\n\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\tuser_camp.function_id = dropdown.id AND\r\n\t\t\t\t\t\t\tdropdown.entry != 'Support' AND\r\n\t\t\t\t\t\t\tuser.id = user_camp.user_id AND\r\n\t\t\t\t\t\t\tuser_camp.camp_id = {$_camp->id}";
