$timeframe = intval(i($QUERY, 'timeframe', '0')); $view = i($QUERY, 'view', 'top'); $action = i($QUERY, 'action', ''); $vertical_id = i($QUERY, 'vertical_id', 0); $QUERY['no_cache'] = 1; if ($view_level != 'vertical') { $vertical_id = 0; } setlocale(LC_MONETARY, 'en_IN'); $mem = new Memcached(); $mem->addServer("127.0.0.1", 11211); $year = 2015; $cache_expire = 60 * 60; $top_count = 30; //Ignoring verticals that are not being used anymore $all_verticals = $sql_madapp->getById("SELECT id,name FROM Vertical WHERE id <> 1 AND id <> 2 AND id <> 10 AND id <> 11 AND id <> 12 AND id <> 13 AND id <> 14 AND id <> 15 ORDER BY name"); $all_view_levels = array('national' => "National", 'vertical' => "Vertical"); // , 'coach' => "Coach" $all_timeframes = array('1' => 'Day', '7' => 'Week', '0' => 'Overall'); $checks = array('is_deleted' => 'users.is_deleted=0'); if ($vertical_id and $view_level == 'vertical') { $checks['vertical_id'] = "G.vertical_id={$vertical_id}"; } if ($timeframe) { $checks['timeframe'] = "D.created_at > DATE_SUB(NOW(), INTERVAL {$timeframe} DAY)"; } $user_checks = $checks; unset($user_checks['timeframe']); $filter = "WHERE {$city_checks}"; if ($checks) { $filter .= " AND " . implode(" AND ", array_values($checks));
$sql_donut = new Sql($config_data['db_host'], $config_data['db_user'], $config_data['db_password'], "makeadiff_cfrapp"); $sql_madapp = new Sql($config_data['db_host'], $config_data['db_user'], $config_data['db_password'], "makeadiff_madapp"); } else { $sql_donut = new Sql("Project_Donut"); $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') {