$array_template = array('title' => '', 'data' => array(), 'show_in' => array());
$all_levels = array('vertical' => $array_template, 'nt' => $array_template, 'fellow' => $array_template, 'coach' => $array_template);
$all_levels['vertical']['show_in'] = array('national');
$all_levels['nt']['show_in'] = array('national', 'vertical');
$all_levels['fellow']['show_in'] = array('national', 'vertical');
$all_levels['coach']['show_in'] = array('national', 'vertical');
/*$all_levels['volunteer']['show_in'] = array('national', 'vertical');*/
foreach ($all_levels as $key => $level_info) {
if (in_array($view_level, $level_info['show_in'])) {
$name = ucfirst($key);
if ($name == 'Nt') {
$name = 'National Team';
}
$title = 'Top ' . $name;
if ($vertical_id) {
$vertical_name = $sql_madapp->getOne("SELECT name FROM Vertical WHERE id={$vertical_id}");
$title .= " in {$vertical_name}";
$children_sponsored_title = " by " . $vertical_name;
} else {
$children_sponsored_title = "Nationally";
}
if ($timeframe == '1') {
$title .= " on " . date("jS M");
} elseif ($timeframe == '7') {
$title .= " for last week(" . date("jS M", strtotime("last week")) . ")";
}
$all_levels[$key]['title'] = $title;
$all_levels[$key]['area'] = $all_levels[$key]['data'] = getData($key);
$all_levels['children_sponsored_title'] = $children_sponsored_title;
}
}
foreach ($all_levels as $key => $level_info) {
if (in_array($view_level, $level_info['show_in'])) {
$name = ucfirst($key);
if ($name == 'User') {
$name = 'Fundraiser';
}
if ($name == 'Group') {
$name = 'Center';
}
$title = 'Top ' . $name;
if ($group_id) {
$city_name = $sql->getOne("SELECT name FROM cities WHERE id={$city_id}");
$title .= " in {$city_name}";
$group_name = $sql->getOne("SELECT name FROM groups WHERE id={$group_id}");
$children_sponsored_title = " by " . $group_name;
$children_count = $sql_madapp->getOne("SELECT COUNT(*) FROM Student\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN Center\n\t\t\t\t\t\t\t\t\t\t\tON Center.id = Student.center_id\n\t\t\t\t\t\t\t\t\t\t\tWHERE Student.status = 1 AND Center.name = '{$group_name}'");
} elseif ($city_id) {
$city_name = $sql->getOne("SELECT name FROM cities WHERE id={$city_id}");
$title .= " in {$city_name}";
$children_sponsored_title = " by " . $city_name;
$madapp_city_id = city_transilation_donut_to_madapp($city_id);
$children_count = $sql_madapp->getOne("SELECT COUNT(*) FROM Student\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN Center\n\t\t\t\t\t\t\t\t\t\t\tON Center.id = Student.center_id\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN City\n\t\t\t\t\t\t\t\t\t\t\tON City.id = Center.city_id\n\t\t\t\t\t\t\t\t\t\t\tWHERE Student.status = 1 AND Center.status = 1 AND City.id = {$madapp_city_id}");
} elseif ($state_id) {
$state_name = $sql->getOne("SELECT name FROM states WHERE id={$state_id}");
$title .= " in {$state_name}";
$children_sponsored_title = " by " . $state_name;
$madapp_region_id = state_transilation_donut_to_madapp($state_id);
$children_count = $sql_madapp->getOne("SELECT COUNT(*) FROM Student\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN Center\n\t\t\t\t\t\t\t\t\t\t\tON Center.id = Student.center_id\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN City\n\t\t\t\t\t\t\t\t\t\t\tON City.id = Center.city_id\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN Region\n\t\t\t\t\t\t\t\t\t\t\tON Region.id = City.region_id\n\t\t\t\t\t\t\t\t\t\t\tWHERE Student.status = 1 AND Center.status = 1 AND Region.id = {$madapp_region_id}");
} else {
$children_sponsored_title = "Nationally";
$children_count = $sql_madapp->getOne("SELECT COUNT(*) FROM Student\n\t\t\t\t\t\t\t\t\t\t\tINNER JOIN Center\n\t\t\t\t\t\t\t\t\t\t\tON Center.id = Student.center_id\n\t\t\t\t\t\t\t\t\t\t\tWHERE Student.status = 1 AND Center.status = 1");
