$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");