Ejemplo n.º 1
0
 }
 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")) . ")";
Ejemplo n.º 2
0
    $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)) {