} 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"); } if ($timeframe == '1') { $title .= " on " . date("jS M"); } elseif ($timeframe == '7') { $title .= " for last week(" . date("jS M", strtotime("last week")) . ")";
$sql_madapp = new Sql("Project_Madapp"); } // Argument Parsing. $madapp_city_id = i($QUERY, 'madapp_city_id', 10); $donut_city_id = $city_transilation[$madapp_city_id]; $group_id = i($QUERY, 'group_id', 13); $action = i($QUERY, 'action', ''); $year = 2015; $group_name = ''; $madapp_users_in_current_group = array(); // if(!$city_id) die("No city specified"); $all_cities = $sql_madapp->getById("SELECT id,name FROM City"); $all_groups = $sql_donut->getById("SELECT id,name,city_id AS donut_city_id FROM groups"); $all_verticals = $sql_madapp->getById("SELECT id,name FROM Vertical"); foreach ($all_groups as $this_group_id => $group) { $all_groups[$this_group_id]['city_id'] = city_transilation_donut_to_madapp($group['donut_city_id']); } if ($action == 'Save Group') { $selected_users = $QUERY['donut_group_users']; $group_id = $QUERY['group_id']; $donut_users_ids = $sql_donut->getById("SELECT madapp_user_id, id FROM users WHERE madapp_user_id IN (" . implode(',', $selected_users) . ")"); foreach ($donut_users_ids as $madapp_id => $user_id) { $sql_donut->execQuery("UPDATE users SET group_id={$group_id} WHERE id={$user_id} "); } $action = 'Fetch'; } if ($action == 'Fetch') { $group_name = mysql_escape_string($all_groups[$group_id]['name']); $all_city_users = $sql_madapp->getById("SELECT U.id,U.name FROM User U \n\t\t\t\tWHERE U.city_id={$madapp_city_id} AND U.status='1' AND U.user_type='volunteer'\n\t\t\t\tORDER BY U.name"); $donut_users_in_current_group = $sql_donut->getById("SELECT id, CONCAT(first_name, ' ', last_name) AS name FROM users\n\t\t\t\tWHERE group_id={$group_id}\n\t\t\t\tORDER BY name"); if (in_array($group_name, $all_verticals)) {