求人情報の詳細
get_results(“SELECT field_name,field_value FROM wp_cf7dbplugin_submits WHERE submit_time = ‘”.$_GET[submit_time].”‘ and form_name = ‘request_job_infomation’ or form_name = ‘request_calendar'”);
foreach ($results as $value){
  if($value->field_name == ‘company_name’){
    $row_data[‘submit_time’] = date(‘Y/m/d H:i:s’,($value->submit_time + 9*3600));
    $row_data[‘company_name’] = $value->field_value;
  } elseif($value->field_name == ‘job_category’){
    $row_data[‘job_category’] = $value->field_value;
  } elseif($value->field_name == ‘max_number’){
    $row_data[‘max_number’] = $value->field_value;
  } elseif($value->field_name == ‘business_field’){
    $row_data[‘business_field’] = $value->field_value;
  } elseif($value->field_name == ‘lisence’){
    $row_data[‘lisence’] = $value->field_value;
  } elseif($value->field_name == ‘document’){
    $row_data[‘document’] = $value->field_value;
  } elseif($value->field_name == ‘how_selection’){
    $row_data[‘how_selection’] = $value->field_value;
  } elseif($value->field_name == ‘arrived_time’){
    $row_data[‘arrived_time’] = $value->field_value;
  } elseif($value->field_name == ‘working_hours’){
    $row_data[‘working_hours’] = $value->field_value;
  } elseif($value->field_name == ‘working_form’){
    $row_data[‘working_form’] = $value->field_value;
  } elseif($value->field_name == ‘working_place’){
    $row_data[‘working_place’] = $value->field_value;
  } elseif($value->field_name == ‘treatment’){
    $row_data[‘treatment’] = $value->field_value;
  } elseif($value->field_name == ‘deadline’){
    $row_data[‘deadline’] = $value->field_value;
  } elseif($value->field_name == ‘reference_url’){
    $row_data[‘reference_url’] = $value->field_value;
  } elseif($value->field_name == ‘notices’){
    $row_data[‘notices’] = $value->field_value;
  } elseif($value->field_name == ‘zip_code’){
    $row_data[‘zip_code’] = $value->field_value;
  } elseif($value->field_name == ‘address’){
    $row_data[‘address’] = $value->field_value;
  } elseif($value->field_name == ‘section’){
    $row_data[‘section’] = $value->field_value;
  } elseif($value->field_name == ‘responsible_name’){
    $row_data[‘responsible_name’] = $value->field_value;
  } elseif($value->field_name == ‘inquiry_section’){
    $row_data[‘inquiry_section’] = $value->field_value;
  } elseif($value->field_name == ‘inquiry_responsible_name’){
    $row_data[‘inquiry_responsible_name’] = $value->field_value;
  } elseif($value->field_name == ‘inquiry_tel’){
    $row_data[‘inquiry_tel’] = $value->field_value;
  } elseif($value->field_name == ‘inquiry_fax’){
    $row_data[‘inquiry_fax’] = $value->field_value;
  } elseif($value->field_name == ‘inquiry_email’){
    $row_data[‘inquiry_email’] = $value->field_value;
  } elseif($value->field_name == ‘allow-flg’){
    $row_data[‘allow-flg’] = $value->field_value;
  } elseif($value->field_name == ‘delete-flg’){
    $row_data[‘delete-flg’] = $value->field_value;
  }
}
print(‘
‘); 
print(‘‘); 
print(‘| 団体名 または 会社名 | ‘.$row_data[‘company_name’].’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| 募集職種 | ‘.$row_data[‘job_category’].’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| 募集人数 | ‘.$row_data[‘max_number’].’ 人‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| 募集分野・業務内容 | ‘.nl2br($row_data[‘business_field’]).’‘); 
print(‘ | 
‘); print(‘‘); 
print(‘| 応募資格 | ‘.nl2br($row_data[‘lisence’]).’‘); 
print(‘ | 
‘); print(‘‘); 
print(‘| 提出書類 | ‘.nl2br($row_data[‘document’]).’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| 選考方法 | ‘.$row_data[‘how_selection’].’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| 着任時期 | ‘.$row_data[‘arrived_time’].’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| 勤務時間 | ‘.$row_data[‘working_hours’].’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| 勤務形態 | ‘.$row_data[‘working_form’].’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| 勤務地 | ‘.$row_data[‘working_place’].’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| 処遇・待遇 | ‘.$row_data[‘treatment’].’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| 応募締切日 | ‘.$row_data[‘deadline’].’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| 参考URL | ‘.$row_data[‘reference_url’].’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| 特記事項 | ‘.nl2br($row_data[‘notices’]).’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| ■書類提出先‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| 郵便番号 | ‘.$row_data[‘zip_code’].’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| 住所 | ‘.$row_data[‘address’].’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| 部署名 | ‘.$row_data[‘section’].’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| 担当者名 | ‘.$row_data[‘responsible_name’].’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| ■問い合わせ先‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| 部署名 | ‘.$row_data[‘inquiry_section’].’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| 担当者名 | ‘.$row_data[‘inquiry_responsible_name’].’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| TEL | ‘.$row_data[‘inquiry_tel’].’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| FAX | ‘.$row_data[‘inquiry_fax’].’‘); 
print(‘ | 
‘); 
print(‘‘); 
print(‘| E-mailアドレス | ‘.$row_data[‘inquiry_email’].’‘); 
print(‘ | 
‘); 
print(‘
‘); 
?>