$columns[] = $k; } } } if (count($columns) == 0) { message(lang('no_data_columns_selected')); redirect('admin/' . thisdoc()); } else { $query = "SELECT count(*) as num_matches, " . implode(', ', $columns) . "\n FROM " . table('participants') . "\n GROUP BY " . implode(', ', $columns) . "\n HAVING num_matches>1\n ORDER BY num_matches DESC"; $result = or_query($query); $dupvals = array(); while ($line = pdo_fetch_assoc($result)) { $dupvals[] = $line; } if (check_allow('participants_edit')) { echo javascript__edit_popup(); } $part_statuses = participant_status__get_statuses(); $cols = participant__get_result_table_columns('result_table_search_duplicates'); echo '<TABLE class="or_listtable"><thead>'; echo '<TR style="background: ' . $color['list_header_background'] . '; color: ' . $color['list_header_textcolor'] . ';">'; echo '<TD> </TD>'; echo participant__get_result_table_headcells($cols, false); echo '</TR></thead> <tbody>'; $num_cols = count($cols) + 1; foreach ($dupvals as $dv) { $mvals = array(); $pars = array(); $qclause = array(); foreach ($columns as $c) {
function query_show_query_result($query_arr, $type = "participants_search_active", $allow_sort = true) { global $lang, $color, $settings; $allow_edit = check_allow('participants_edit'); // prepare edit popup if (($type == 'participants_search_active' || $type == 'participants_search_all' || $type == 'participants_unconfirmed') && $allow_edit) { echo javascript__edit_popup(); } $result = or_query($query_arr['query'], $query_arr['pars']); $count_results = pdo_num_rows($result); echo '<B>' . $count_results . ' ' . lang('xxx_participants_in_result_set') . '</B>'; if ($type == 'assign') { echo '<BR>' . lang('only_ny_assigned_part_showed'); } elseif ($type == 'deassign') { echo '<BR>' . lang('only_assigned_part_ny_reg_shownup_part_showed'); } echo '<BR><BR>'; if ($type == 'participants_search_active' || $type == 'participants_search_all') { query__resulthead_participantsearch(); } elseif ($type == 'assign' || $type == 'deassign') { query__resulthead_assign($type); } if ($type == 'participants_search_active') { $cols = participant__get_result_table_columns('result_table_search_active'); } elseif ($type == 'participants_search_all') { $cols = participant__get_result_table_columns('result_table_search_all'); } elseif ($type == 'participants_unconfirmed') { $cols = participant__get_result_table_columns('result_table_search_unconfirmed'); } else { $cols = participant__get_result_table_columns('result_table_assign'); } echo '<table class="or_listtable" style="width: 95%;">'; echo '<thead>'; echo '<TR style="background: ' . $color['list_header_background'] . '; color: ' . $color['list_header_textcolor'] . ';">'; echo participant__get_result_table_headcells($cols, $allow_sort); echo '</TR>'; echo '</thead><tbody>'; $shade = false; $assign_ids = array(); while ($p = pdo_fetch_assoc($result)) { if ($type == 'participants_unconfirmed') { $assign_ids[] = $p['email']; } else { $assign_ids[] = $p['participant_id']; } echo '<tr class="small"'; if ($shade) { echo ' bgcolor="' . $color['list_shade1'] . '"'; } else { echo 'bgcolor="' . $color['list_shade2'] . '"'; } echo '>'; echo participant__get_result_table_row($cols, $p); echo '</tr>'; if ($shade) { $shade = false; } else { $shade = true; } } echo '</tbody></table>'; return $assign_ids; }