Example #1
0
        }
    }
}
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') . '">';
Example #2
0
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;
    }
}