/** * Load Facet sidebar for both assets tab and instantations tab. * * @return view */ function load_facet_columns() { if (isAjax()) { $is_all_facet = $this->input->post('issearch'); $index = $this->input->post('index'); $this->load->library('sphnixrt'); if ($is_all_facet > 0 || $this->is_station_user) { $states = $this->sphinx->facet_index('state', $index); $data['org_states'] = sortByOneKey($states['records'], 'state'); unset($states); $stations = $this->sphinx->facet_index('organization', $index); $data['stations'] = sortByOneKey($stations['records'], 'organization'); unset($stations); $nomination = $this->sphinx->facet_index('status', $index); $data['nomination_status'] = sortByOneKey($nomination['records'], 'status'); unset($nomination); $media_type = $this->sphinx->facet_index('media_type', $index); $media_type = $this->make_facet($media_type, 'media_type', 'media_type'); $data['media_types'] = sortByOneKey($media_type, 'media_type', TRUE); unset($media_type); $p_format = $this->sphinx->facet_index('physical_format_name', $index, 'physical'); $p_format = $this->make_facet($p_format, 'physical_format_name', 'physical_format'); $data['physical_formats'] = sortByOneKey($p_format, 'physical_format_name', TRUE); unset($p_format); $d_format = $this->sphinx->facet_index('digital_format_name', $index, 'digital'); $d_format = $this->make_facet($d_format, 'digital_format_name', 'digital_format'); $data['digital_formats'] = sortByOneKey($d_format, 'digital_format_name', TRUE); unset($d_format); $generation = $this->sphinx->facet_index('facet_generation', $index); $generation = $this->make_facet($generation, 'facet_generation', 'generation'); $data['generations'] = sortByOneKey($generation, 'facet_generation', TRUE); unset($generation); $digitized = $this->sphinx->facet_index('digitized', $index, 'digitized'); $data['digitized'] = $digitized['records']; $migration = $this->sphinx->facet_index('migration', $index, 'migration'); $data['migration'] = $migration['records']; } else { if ($index == 'assets_list') { $key_name = 'asset'; } else { $key_name = 'ins'; } $data['org_states'] = json_decode($this->memcached_library->get($key_name . '_state'), TRUE); $data['stations'] = json_decode($this->memcached_library->get($key_name . '_stations'), TRUE); $data['nomination_status'] = json_decode($this->memcached_library->get($key_name . '_status'), TRUE); $data['media_types'] = json_decode($this->memcached_library->get($key_name . '_media_type'), TRUE); $data['physical_formats'] = json_decode($this->memcached_library->get($key_name . '_physical'), TRUE); $data['digital_formats'] = json_decode($this->memcached_library->get($key_name . '_digital'), TRUE); $data['generations'] = json_decode($this->memcached_library->get($key_name . '_generations'), TRUE); $data['digitized'] = json_decode($this->memcached_library->get($key_name . '_digitized'), TRUE); $data['migration'] = json_decode($this->memcached_library->get($key_name . '_migration'), TRUE); } echo $this->load->view('instantiations/_facet_columns', $data, TRUE); exit_function(); } show_404(); }
private function formatMatchenAsHTML($matchen, $cid, $tid) { function sortByOneKey(array $array, $key, $asc = true) { $result = array(); $values = array(); foreach ($array as $id => $value) { $values[$id] = isset($value[$key]) ? $value[$key] : ''; } if ($asc) { asort($values); } else { arsort($values); } foreach ($values as $key => $value) { $result[$key] = $array[$key]; } return $result; } $matchen = sortByOneKey($matchen, 'ts'); $html = ''; $html .= '<table class="cid-' . $cid . '">'; $html .= '<th>Datum</th>'; $html .= '<th class="center">Thuis</th>'; $html .= '<th class="center">Uit</th>'; $html .= '<th class="center breed">Score</th>'; $even_oneven = 'odd'; foreach ($matchen as $match) { $t_status = $this->getWinnerStatus($match['thuisscore']); $u_status = $this->getWinnerStatus($match['uitscore']); $html .= '<tr style="cursor:pointer;" onclick="window.location=\'../../ontmoetingoverzicht/' . $cid . '/' . $match["mid"] . '\'" class="' . $even_oneven . '"><td class="datum">'; $html .= $this->formatTsAsDate($match['ts']); $html .= '</td><td class="teamnaam right ' . $t_status . ' tid-' . $match['tid_t'] . '">'; $html .= $match['thuis'] . '<span class="smallscreens"><br/>[' . $match['thuisscore'] . ']</span>'; $html .= '</td><td class="teamnaam left ' . $u_status . ' tid-' . $match['tid_u'] . '">'; $html .= $match['uit'] . '<span class="smallscreens"><br/>[' . $match['uitscore'] . ']</span>'; $html .= '</td><td class="score center breed">'; $html .= $match['thuisscore'] . '-' . $match['uitscore']; $html .= '</td></tr>'; $even_oneven = $even_oneven == 'odd' ? 'even' : 'odd'; } $html .= '</table>'; $html .= '<div class="matchen-spacer"></div>'; return $html; }
function pull_ALL_events($lat, $lon, $offset) { //could be dirty /* $offset = preg_replace("#[^0-9]#", "", $offset); $rows_per_page = 7; if($GLOBALS['include_YQL'] == false) $rows_per_page = 10; */ // date searching $d = DATE_TO_SEARCH_FROM; $d2 = DATE_TO_SEARCH_TO; // DO YQL SECTION FIRST $cxn = $GLOBALS['cxn']; $main_array = array(); // create an emptry array if ($GLOBALS['include_YQL'] == true) { $qry = "SELECT * FROM YQL_event_address\n\t\t\t\tWHERE \n\t\t\t\t'{$d}' <= (SELECT end_date FROM YQL_events \n\t\t\t\tWHERE event_id = YQL_event_address.event_id)\n\t\t\t\t"; //LIMIT $offset, $rows_per_page $res = mysqli_query($cxn, $qry) or die("couldn't do the db loc thing..."); while ($row = mysqli_fetch_assoc($res)) { extract($row); $d_total = distance($lat, $lon, $x_coord, $y_coord, "m"); // the sub array $event = array("origin" => "YQL", "id" => $event_id, "distance" => $d_total, "address_DB" => 0, "lat" => $x_coord, "lon" => $y_coord); //$distances[$event_id] = $d_total; array_push($main_array, $event); } //end compare and extract loc data while. } // END YQL // DO USER SECTION NEXT $qry = "SELECT * FROM event_address\n\t\t\tWHERE\n\t\t\t'{$d}' <= (SELECT end_date FROM user_events \n\t\t\tWHERE event_id = event_address.event_id)"; //LIMIT $offset, $rows_per_page $res = mysqli_query($cxn, $qry) or die("couldn't do the db loc thing..."); while ($row = mysqli_fetch_assoc($res)) { extract($row); $d_total = distance($lat, $lon, $x_coord, $y_coord, "m"); // the sub array $event = array("origin" => "user", "id" => $event_id, "distance" => $d_total, "address_DB" => $address_text, "lat" => $x_coord, "lon" => $y_coord); //$distances[$event_id] = $d_total; array_push($main_array, $event); } //end compare and extract loc data while. // NOW SORT THIS multidimen array $main_array = sortByOneKey($main_array, "distance"); // MAIN LOOP $search_output = ""; // you have to do the limit down here haha $offset = preg_replace("#[^0-9]#", "", $offset); $rows_per_page = 9; if ($GLOBALS['include_YQL'] == false) { $rows_per_page = 9; } $i = 0; foreach ($main_array as $event_array) { // offset = if ($i > $offset + $rows_per_page) { //echo "break tripped: i=$i and Offset=$offset, rows/page=$rows_per_page"; break; } if (!($i < $offset)) { //echo "continue tripped: i=$i and offset=$offset"; /* echo "<pre>"; print_r($event_array); echo "</pre>"; */ // THIS PULLS EVENT INFO VIA ID //print_r($event_array); extract($event_array); if ($origin == "YQL") { $event_row = get_all_event_list_YQL($id); if ($event_row != null) { extract($event_row); } $all_vars = array("event_id" => $event_id, "user_id" => 0, "event_description" => $event_description, "event_title" => $event_title, "start_date" => $start_date, "country_name" => $country_name, "venue_name" => $venue_name, "venue_zip" => $venue_zip, "venue_state" => $venue_state, "lat" => $lat, "lon" => $lon, "distance" => $distance, "search_output" => $search_output); $search_output = search_output_func_YQL($all_vars); //see search_functions.php } else { if ($origin == "user") { // do user stuff here $event_row = get_all_event_list_users($id); if ($event_row != null) { extract($event_row); } $all_vars = array("event_id" => $event_id, "user_id" => $user_id, "event_description" => $event_description, "event_title" => $event_title, "start_date" => $start_date, "end_date" => $end_date, "venue_address" => $address_DB, "lat" => $lat, "lon" => $lon, "distance" => $distance, "search_output" => $search_output, "isContactInfo" => $is_contactable, "contactInfo" => $contact_info, "contactType" => $contact_type); $search_output = search_output_func_users($all_vars); //see search_functions.php } } } // end inner else $i++; } //end loop for location search FOREACH return $search_output; }
} $groups_KEY = $_REQUEST['groups_KEY']; if (!$_REQUEST['groups_KEY']) { echo '<form method="get"> <label>Select Group</label> <select name="groups_KEY">'; include 'partials/options/_lists.php'; echo ' </select> <input type="submit"> </form> '; } else { $supporters = get_contact_list_array($_REQUEST['groups_KEY']); $g = get_group($_REQUEST['groups_KEY']); if ($_REQUEST['order']) { $supporters = sortByOneKey($supporters, $_REQUEST['order'], $asc = true); } ?> <script> function add_supporters_to_form(){ var $form = $(this); var html = ''; $(".person-checkbox:checked").each(function(){ var supporter_groups_key = $(this).data('supporter_groups_key'); html += '<input type="hidden" name="supporter_groups[]" value="'+supporter_groups_key+'" />'; }); $form.prepend(html); }
/** * Save Facet Search Values into memcahed. * * @return */ function auto_memcached_facets() { $this->load->library('memcached_library'); $this->load->model('sphinx_model', 'sphinx'); $memcached = new StdClass(); $memcached->ins = 'instantiations_list'; $memcached->asset = 'assets_list'; $search_facet = new stdClass(); $search_facet->state = 'state'; $search_facet->stations = 'organization'; $search_facet->status = 'status'; $search_facet->media_type = 'media_type'; $search_facet->physical = 'physical_format_name'; $search_facet->digital = 'digital_format_name'; $search_facet->generations = 'facet_generation'; $search_facet->digitized = 'digitized'; $search_facet->migration = 'migration'; foreach ($memcached as $index => $index_name) { foreach ($search_facet as $columns => $facet) { $result = $this->sphinx->facet_index($facet, $index_name, $columns); if (in_array($facet, array('media_type', 'physical_format_name', 'digital_format_name', 'facet_generation'))) { $make_facet = array(); foreach ($result['records'] as $_row) { $exploded_facet = explode('___', $_row[$facet]); foreach ($exploded_facet as $single_value) { if (isset($make_facet[trim($single_value)])) { $make_facet[trim($single_value)] = $make_facet[trim($single_value)] + $_row['@count']; } else { $make_facet[trim($single_value)] = $_row['@count']; } } } $final_facet = array(); foreach ($make_facet as $_index => $_single_facet) { if ($_index != '(**)' && $_index != '') { $final_facet[] = array($facet => $_index, '@count' => $_single_facet); } } $this->memcached_library->set($index . '_' . $columns, json_encode(sortByOneKey($final_facet, $facet, TRUE)), 36000); } else { if (in_array($columns, array('digitized', 'migration'))) { $this->memcached_library->set($index . '_' . $columns, json_encode(sortByOneKey($result['records'], $facet, FALSE)), 36000); } else { if ($columns == 'stations') { $result = $this->sphinx->facet_index($facet, $index_name); $this->memcached_library->set($index . '_' . $columns, json_encode(sortByOneKey($result['records'], $facet)), 36000); } else { $result = $this->sphinx->facet_index($facet, $index_name); $this->memcached_library->set($index . '_' . $columns, json_encode(sortByOneKey($result['records'], $facet, FALSE)), 36000); } } } } myLog("Succussfully Updated {$index_name} Facet Search"); } exit; }