本会以外の集会詳細
get_results(“SELECT field_name,field_value FROM wp_cf7dbplugin_submits WHERE submit_time = ‘”.$_GET[‘submit_time’].”‘ and (form_name = ‘request’ or form_name = ‘request_calendar’)”);
foreach ($results as $value){
if($value->field_name == ‘from_year’){
$row_data[‘submit_time’] = date(‘Y/m/d H:i:s’,($value->submit_time + 9*3600));
$row_data[‘from_year’] = $value->field_value;
} elseif($value->field_name == ‘from_month’){
$row_data[‘from_month’] = $value->field_value;
} elseif($value->field_name == ‘from_day’){
$row_data[‘from_day’] = $value->field_value;
} elseif($value->field_name == ‘to_year’){
$row_data[‘to_year’] = $value->field_value;
} elseif($value->field_name == ‘to_month’){
$row_data[‘to_month’] = $value->field_value;
} elseif($value->field_name == ‘to_day’){
$row_data[‘to_day’] = $value->field_value;
} elseif($value->field_name == ‘venue’){
$row_data[‘venue’] = $value->field_value;
} elseif($value->field_name == ‘place’){
$row_data[‘place’] = $value->field_value;
} elseif($value->field_name == ‘from_fee’){
$row_data[‘from_fee’] = $value->field_value;
} elseif($value->field_name == ‘to_fee’){
$row_data[‘to_fee’] = $value->field_value;
} elseif($value->field_name == ‘meeting_name’){
$row_data[‘meeting_name’] = $value->field_value;
} elseif($value->field_name == ‘meeting_url’){
$row_data[‘meeting_url’] = $value->field_value;
} elseif($value->field_name == ‘meeting_outline’){
$row_data[‘meeting_outline’] = $value->field_value;
} elseif($value->field_name == ‘meeting_relation’){
$row_data[‘meeting_relation’] = $value->field_value;
} elseif($value->field_name == ‘organizer’){
$row_data[‘organizer’] = $value->field_value;
} elseif($value->field_name == ‘organizer_url’){
$row_data[‘organizer_url’] = $value->field_value;
} elseif($value->field_name == ‘request_name’){
$row_data[‘request_name’] = $value->field_value;
} elseif($value->field_name == ‘member_no’){
$row_data[‘member_no’] = $value->field_value;
} elseif($value->field_name == ‘member_address’){
$row_data[‘member_address’] = $value->field_value;
} elseif($value->field_name == ‘member_tel’){
$row_data[‘member_tel’] = $value->field_value;
} elseif($value->field_name == ‘member_email’){
$row_data[‘member_email’] = $value->field_value;
} elseif($value->field_name == ‘kyosai’){
$row_data[‘kyosai’] = $value->field_value;
}
}
print(‘
‘);
print(‘‘);
if($row_data[‘kyosai’] != “”){
print(‘| 申請種別 | ‘.$row_data[‘kyosai’].’ | ‘);
}
print(‘
‘);
print(‘‘);
print(‘| 開催日 | ‘);
if($row_data[‘to_year’] == “” && $row_data[‘to_month’] == “” && $row_data[‘to_day’] == “”){
print(‘‘.$row_data[‘from_year’].’年’.$row_data[‘from_month’].’月’.$row_data[‘from_day’].’日 | ‘);
} else {
print(‘‘.$row_data[‘from_year’].’年’.$row_data[‘from_month’].’月’.$row_data[‘from_day’].’日～’.$row_data[‘to_year’].’年’.$row_data[‘to_month’].’月’.$row_data[‘to_day’].’日 | ‘);
}
print(‘
‘);
print(‘‘);
print(‘| 開催地 | ‘.$row_data[‘venue’].’ | ‘);
print(‘
‘);
print(‘‘);
print(‘| 会場 | ‘.$row_data[‘place’].’ | ‘);
print(‘
‘);
print(‘‘);
if($row_data[‘kyosai’] != “”){
print(‘| 会費 | ‘.number_format((int)$row_data[‘from_fee’]).’円～’.number_format((int)$row_data[‘to_fee’]).’円 | ‘);
}
print(‘
‘);
print(‘‘);
print(‘| 集会名称 | ‘.$row_data[‘meeting_name’].’ | ‘);
print(‘
‘);
print(‘‘);
print(‘| URL | ‘.$row_data[‘meeting_url’].’ | ‘);
print(‘
‘);
print(‘‘);
if($row_data[‘kyosai’] != “”){
print(‘| 集会概要 | ‘);
echo nl2br($row_data[‘meeting_outline’]);
print(‘ | ‘);
}
print(‘
‘);
print(‘‘);
print(‘| 主催者団体名 | ‘.$row_data[‘organizer’].’ | ‘);
print(‘
‘);
print(‘‘);
print(‘| URL | ‘.$row_data[‘organizer_url’].’ | ‘);
print(‘
‘);
print(‘
‘);
?>
