if ($e['type'] == 'radio') {
$pat[] = false;
} else {
$pat[] = true;
}
$opt_pat[] = 0;
$th .= '<th rowspan="2">' . $e['caption'] . '</th>';
$id_pat[] = intval($e['fieldid']);
}
}
if (admin()) {
$th .= '<th rowspan="2">#</th>';
}
$th .= '</tr>' . "\n" . $th2 . '</tr>' . "\n";
while ($e = sql('SELECT `recordid`,`fieldid`,`value` FROM `pool` WHERE `eventid`="' . $eventid . '" ORDER BY `recordid` DESC')) {
$e['value'] = condom($e['value']);
if ($checkbox[$e['fieldid']]) {
$e['value'] = linebreak($e['value']);
}
$data[$e['recordid']][$e['fieldid']] = $e['value'];
}
$i = 0;
echo $th;
while ($e = sql('SELECT `recordid` FROM `records` WHERE `eventid`="' . $eventid . '" ORDER BY `recordid` DESC')) {
++$i;
if ($i % 30 == 0) {
echo $th;
}
echo '<tr style="background:#' . ($i % 2 == 0 ? 'fff' : 'eee') . ';">';
foreach ($id_pat as $idx => $fid) {
if ($pat[$idx] === true) {
function delRow(obj){
getelm('signup').deleteRow(obj.parentNode.parentNode.rowIndex);
}
function preload(){<?php
if (!empty($_GET['eventid'])) {
$tpl = '';
} elseif (!empty($_GET['tpl_eventid'])) {
$tpl = 'tpl_';
}
$preload[$tpl . 'eventid'] = $_GET[$tpl . 'eventid'];
if ($e = sql('SELECT * FROM `' . $tpl . 'events` WHERE `eventid`="' . $preload[$tpl . 'eventid'] . '"')) {
$preload['title'] = condom($e['title']);
$preload['expose'] = $e['expose'] == 0 ? '' : ' checked="checked"';
$preload['desc'] = condom($e['desc']);
if (empty($tpl)) {
$preload['beg_y'] = substr($e['beg_date'], 0, 4);
$preload['beg_m'] = substr($e['beg_date'], 4, 2);
$preload['beg_d'] = substr($e['beg_date'], 6, 2);
$preload['end_y'] = substr($e['end_date'], 0, 4);
$preload['end_m'] = substr($e['end_date'], 4, 2);
$preload['end_d'] = substr($e['end_date'], 6, 2);
}
}
if (!empty($preload[$tpl . 'eventid'])) {
while ($e = sql('SELECT * FROM `' . $tpl . 'fields` WHERE `eventid`="' . $preload[$tpl . 'eventid'] . '" ORDER BY `order` ASC')) {
$opt = array();
while ($e2 = sql('SELECT `caption` FROM `' . $tpl . 'options` WHERE `eventid`="' . $preload[$tpl . 'eventid'] . '" AND `fieldid`="' . $e['fieldid'] . '" ORDER BY `optionid` ASC')) {
$opt[] = $e2['caption'];
}
function mk_checkbox($eid, $f)
{
global $not;
$fid = $f['fieldid'];
if (isset($_SESSION['cache']['f' . $fid])) {
if (!is_array($_SESSION['cache']['f' . $fid])) {
$_SESSION['cache']['f' . $fid] = array();
}
$defval = $_SESSION['cache']['f' . $fid];
} else {
$defval = linebreak($f['default']);
}
$options = array();
while ($e = sql('SELECT `optionid`,`caption` FROM `options` WHERE `eventid`="' . $eid . '" AND `fieldid`="' . $fid . '" ORDER BY `optionid`')) {
$options[] = $e;
}
if (count($options) == 1) {
echo '<input type="checkbox" name="f' . $fid . '[]" id="f' . $fid . '-' . $e['optionid'] . '" value="' . condom($e['caption']) . '"' . (in_array($e['caption'], $defval) ? ' checked="checked"' : '') . $not . ' />';
} else {
foreach ($options as $e) {
echo '<span style="float:leftl"><input type="checkbox" name="f' . $fid . '[]" id="f' . $fid . '-' . $e['optionid'] . '" value="' . condom($e['caption']) . '"' . (in_array($e['caption'], $defval) ? ' checked="checked"' : '') . $not . ' /><label for="f' . $fid . '-' . $e['optionid'] . '">' . condom($e['caption']) . '</label></span>' . "\n";
}
}
}
<?php
include 'config.php';
$eventid = $_GET['eventid'];
if ($e = sql('SELECT * FROM `events` WHERE `eventid`="' . $eventid . '"')) {
$title = condom($e['title']);
} else {
redirect('events.php');
}
$opt_pat = $id_pat = $pat = $data = $options = $checkbox = $fields = array();
while ($e = sql('SELECT `optionid`,`fieldid`,`caption` FROM `options` WHERE `eventid`="' . $eventid . '" ORDER BY `optionid` ASC')) {
$options[$e['fieldid']][$e['optionid']] = condom($e['caption']);
}
while ($e = sql('SELECT * FROM `fields` WHERE `eventid`="' . $eventid . '"' . (admin() ? '' : ' AND public="1"') . ' ORDER BY `order` ASC')) {
$e['title'] = condom($e['title']);
$fields[$e['fieldid']] = $e;
}
if ($_GET['mode'] == 'fakexls') {
include 'list.fakexls.php';
} else {
include 'list.web.php';
}
include 'config.php';
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="/jscss/bg.css">
<style type="text/css">
th{text-align:center; background-color:#ccc;}
</style>
</head>
<body>
<?php
if (admin()) {
echo '<a href="event.php">新增報名表</a>';
}
?>
<table>
<tr><th>#</th><th>活動名稱</th><th>報名開始</th><th>報名截止</th><th>#</th></tr>
<?php
$i = 0;
while ($e = sql('SELECT * FROM `events`' . (admin() ? '' : ' WHERE `expose`="1"') . ' ORDER BY `eventid` DESC')) {
echo '<tr style="background:#' . ($i % 2 == 0 ? 'eee' : 'fff') . ';"><td>' . $e['eventid'] . '</td><td><a href="event.php?eventid=' . $e['eventid'] . '">' . ($e['title'] == '' ? ' ' : condom($e['title'])) . '</a></td><td>' . $e['beg_date'] . '</td><td>' . $e['end_date'] . '</td><td><a href="list.php?eventid=' . $e['eventid'] . '">報名清單</a></td></tr>';
++$i;
}
if ($i == 0) {
echo '<tr><td colspan="5" align="center">目前沒有活動</td></tr>';
}
?>
</table>
</body>
</html>
