function mult_time_to_sesstime($line, $pre)
{
return helpers__pad_number($line[$pre . 'year'], 4) . helpers__pad_number($line[$pre . 'month'], 2) . helpers__pad_number($line[$pre . 'day'], 2) . helpers__pad_number($line[$pre . 'hour'], 2) . helpers__pad_number($line[$pre . 'minute'], 2);
}
function participant__select_numbers($ptablevarname, $formfieldvarname, $prevalue, $begin, $end, $fillzeros = 2, $steps = 1, $reverse = false, $incnone = false, $existing = false, $where = '', $show_count = false)
{
$out = '';
$out .= '<select name="' . $formfieldvarname . '">';
if ($incnone) {
$out .= '<option value="">-</option>';
}
if (!$existing) {
if ($begin < $end) {
$lb = $begin;
$ub = $end;
} else {
$lb = $end;
$ub = $begin;
}
if ($reverse) {
$i = $ub;
} else {
$i = $lb;
}
if ($steps < 1) {
$steps = 1;
}
while ($reverse == false && $i <= $ub || $reverse == true && $i >= $lb) {
$out .= '<option value="' . $i . '"';
if ($i == (int) $prevalue) {
$out .= ' SELECTED';
}
$out .= '>';
$out .= helpers__pad_number($i, $fillzeros);
$out .= '</option>';
if ($reverse) {
$i = $i - $steps;
} else {
$i = $i + $steps;
}
}
} else {
$query = "SELECT count(*) as tf_count, " . $ptablevarname . " as tf_value\n FROM " . table('participants') . "\n WHERE " . table('participants') . ".participant_id IS NOT NULL ";
if ($where) {
$query .= " AND " . $where . " ";
}
$query .= " GROUP BY " . $ptablevarname . "\n ORDER BY " . $ptablevarname;
if ($reverse) {
$query .= " DESC ";
}
$result = or_query($query);
$listitems = array();
while ($line = pdo_fetch_assoc($result)) {
if (!isset($listitems[$line['tf_value']])) {
$listitems[$line['tf_value']] = $line;
} else {
$listitems[$line['tf_value']]['tf_count'] = $listitems[$line['tf_value']]['tf_count'] + $line['tf_count'];
}
}
foreach ($listitems as $line) {
$out .= '<option value="' . $line['tf_value'] . '"';
if ($line['tf_value'] == (int) $prevalue) {
$out .= ' SELECTED';
}
$out .= '>';
if ($line['tf_value'] != '') {
$out .= helpers__pad_number($line['tf_value'], $fillzeros);
} else {
$out .= '-';
}
if ($show_count) {
$out .= ' (' . $line['tf_count'] . ')';
}
$out .= '</option>';
}
while ($line = pdo_fetch_assoc($result)) {
$out .= '<option value="' . $line['tf_value'] . '"';
if ($line['tf_value'] == (int) $prevalue) {
$out .= ' SELECTED';
}
$out .= '>';
$out .= helpers__pad_number($line['tf_value'], $fillzeros);
if ($show_count) {
$out .= ' (' . $line['tf_count'] . ')';
}
$out .= '</option>';
}
}
$out .= '</select>';
return $out;
}
function ortime__array_ampm_time_to_array_mil_time($a)
{
// unused?
$r = array();
$p = strtolower($a['a']);
$h = $a['h'] == 12 ? 0 : $a['h'];
$r['h'] = $p == 'pm' ? $h + 12 : $h;
$r['h'] = helpers__pad_number($r['h'], 2);
$r['i'] = $a['i'];
return $r;
}
function helpers__select_hour($name, $prevalue, $begin, $end, $steps = 1, $military = true)
{
$out = '';
$i = $begin;
$out .= '<select name="' . $name . '" id="' . $name . '">';
while ($i <= $end) {
$out .= '<option value="' . $i . '"';
if ($i == (int) $prevalue) {
$out .= ' SELECTED';
}
$out .= '>';
if ($military) {
$out .= helpers__pad_number($i, 2);
} else {
$ampm = $i < 12 ? 'am' : 'pm';
if ($i == 0) {
$display = 12;
} elseif ($ampm == 'pm' && $i > 12) {
$display = $i - 12;
} else {
$display = $i;
}
$out .= $display . $ampm;
}
$out .= '</option>
';
$i = $i + $steps;
}
$out .= '</select>';
return $out;
}
