} } } if ($proceed) { $pars = array(':item_type' => $list); $query = "SELECT *\n FROM " . table('objects') . "\n WHERE item_type= :item_type\n ORDER BY order_number"; $result = or_query($query, $pars); $rows = array(); while ($line = pdo_fetch_assoc($result)) { $rows[$line['item_name']] = $line; } if (in_array($list, $result_lists)) { $listrows = options__ordered_lists_get_current($cols, $rows, true); $headers = '<TD></TD><TD align="center">' . str_replace(" ", "<BR>", lang('sort_table_by')) . '</TD>'; } else { $listrows = options__ordered_lists_get_current($cols, $rows, false); $headers = ''; } echo '<center>'; echo '<form action="" method="POST">'; echo '<TABLE class="or_formtable"> <TR><TD> <TABLE width="100%" border=0 class="or_panel_title"><TR> <TD style="background: ' . $color['panel_title_background'] . '; color: ' . $color['panel_title_textcolor'] . '" align="center"> ' . $header . ' </TD> </TR></TABLE> </TD></TR>'; echo '<TR><TD align="center">'; echo formhelpers__orderlist("ordered_list", "item_order", $listrows, false, lang('add'), $headers); echo '<input class="button" style="display: block;" name="save_order" type="submit" value="' . lang('save_order') . '">';
function participant__get_result_table_columns($list) { // $list can be: result_table_search_active, result_table_search_all, // result_table_assign, result_table_search_duplicates, session_list,session_list_pdf global $preloaded_result_table_columns; if (isset($preloaded_result_table_columns[$list]) && is_array($preloaded_result_table_columns[$list])) { return $preloaded_result_table_columns[$list]; } else { $allcols = participant__get_possible_participant_columns($list); $pars = array(':item_type' => $list); $query = "SELECT *\n FROM " . table('objects') . "\n WHERE item_type= :item_type\n ORDER BY order_number"; $result = or_query($query, $pars); $saved_cols = array(); while ($line = pdo_fetch_assoc($result)) { $saved_cols[$line['item_name']] = $line; } $listcols = options__ordered_lists_get_current($allcols, $saved_cols); foreach ($listcols as $k => $arr) { if (!isset($arr['on_list']) || !$arr['on_list']) { unset($listcols[$k]); } } $preloaded_result_table_columns[$list] = $listcols; return $listcols; } }