求人情報の詳細
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(‘
‘); 
?>