<!DOCTYPE html>
<html lang="jp">
<!DOCTYPE html>
<html lang="ja">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>求人検索フォーム</title>
    <link rel="stylesheet" href="style.css" type="text/css">
</head>
<body>
    <div class="container">
        <h1>下関商業求人検索</h1>
        <p>条件を選択して「この条件で検索する」をクリックしてください</p>
        <form action="index.php" method="post">
            <div class="form-group">
                <label for="area">勤務地</label>
                <div class="select-wrapper">
                    <select id="area" name="area">
                        <option value="">選択してください</option>
                        <option value="下関市">下関市内</option>
                        <option value="県内">山口県内（下関市内を除く）</option>
                        <option value="福岡">福岡県内</option>
                        <option value="広島">広島県内</option>
                        <option value="県外">それ以外</option>
                    </select>
                </div>
            </div>
            
            <div class="form-group">
                <label for="occupation">職　種</label>
                <div class="radio-group">
                    <label><input type="radio" name="occupation" value="営業" id="data1"> 営業</label>
                    <label><input type="radio" name="occupation" value="事務" id="data2"> 事務</label>
                    <label><input type="radio" name="occupation" value="製造" id="data3"> 製造</label>
                </div>
            </div>
            
            <div class="form-group">
                <label for="commitment">こだわり条件</label>
                <div class="commitment-group">
                    <label><input type="checkbox" name="commitment[]" value="年間休日120日以上" id="data1"> 年間休日120日以上</label>
                    <label><input type="checkbox" name="commitment[]" value="本校枠あり" id="data2"> 本校枠あり</label>
                    <label><input type="checkbox" name="commitment[]" value="賞与あり" id="data3"> 賞与あり</label>
                    <label><input type="checkbox" name="commitment[]" value="面接のみ" id="data4"> 面接のみ</label>
                    <label><input type="checkbox" name="commitment[]" value="面接・適性検査のみ" id="data5"> 面接・適性検査のみ</label>
                    <label><input type="checkbox" name="commitment[]" value="学科あり" id="data6"> 学科あり</label>
                </div>
            </div>
            
            <input type="submit" value="この条件で検索する">
        </form>
    </div>

<?php

require ('../prologin.php');

if (isset($_POST['namae'])){
    $name = $_POST['namae'];
}else {
    $name = '';
}

if (isset($_POST['area'])){
    $area = $_POST['area'];
}else {
    $area = '';
}

if (isset($_POST['occupation'])) {
    $occupation = $_POST['occupation'];
} else {
    $occupation = [];
}

if (isset($_POST['salary'])){
    $salary = $_POST['salary'];
}else {
    $salary = '';
}

if (isset($_POST['commitment'])) {
    $commitment = $_POST['commitment'];
} else {
    $commitment = '';
}

// データを取得するSQL文
$sql = "SELECT * FROM joboffer_table WHERE 1=1";

if (!empty($area)) {
    $sql .= " AND location = '$area'";
}

if (!empty($occupation)) {
    if ($occupation == '営業') {
        $occupation_condition = "(job LIKE '%営業%')";
    } elseif ($occupation == '製造') {
        $occupation_condition = "(job LIKE '%製造%')";
    } elseif ($occupation == '事務') {
        $occupation_condition = "(job LIKE '%事務%')";
    }
    $sql .= " AND ($occupation_condition)";
}

if (!empty($commitment)) {
    $commitment_list = [];
    foreach ($commitment as $selected_commitment) {
        if ($selected_commitment == '年間休日120日以上') {
            $commitment_list[] = "(holiday >= 120)";
        }elseif($selected_commitment == '本校枠あり') {
            $commitment_list[] = "(quota >= 1)";
        }elseif($selected_commitment == '賞与あり'){
            $commitment_list[] = "(bonus >= 1)";
        }elseif($selected_commitment == '面接のみ'){
            $commitment_list[] = "(selection = '面接')";
        }elseif($selected_commitment == '面接・適性検査のみ'){
            $commitment_list[] = "(selection = '面接・適性検査')";
        }elseif($selected_commitment == '学科あり'){
            $commitment_list[] = "(selection LIKE '%学科%' OR selection LIKE '%一般常識%')";
        }
    }
    $commitment_list = implode(" OR ",$commitment_list);
    $sql .= " AND ($commitment_list)";
}

$result = mysqli_query($db, $sql);

// クエリの実行が失敗した場合
if (!$result) {
    die("クエリ実行エラー: " . mysqli_error($db));
}

//取り出したデータの行数
$rowcnt = mysqli_num_rows($result);

if ($rowcnt > 0) {
    // 検索条件の表示
    echo '<p class="search-summary">';
    if (!empty($area)) {
        echo "<span><strong>勤務地:</strong> $area</span>";
    }else{
        echo "<span><strong>勤務地:</strong> 未指定</span>";
    }
    if (!empty($occupation)) {
        echo "<span><strong>職種:</strong> $occupation</span>";
    }else{
        echo "<span><strong>職種:</strong> 未指定</span>";
    }
    $commitlist = implode(", ", $commitment);
    if (!empty($commitlist)) {
        echo "<span><strong>こだわり条件（OR検索）:</strong> $commitlist</span>";
    }else{
        echo "<span><strong>こだわり条件（OR検索）:</strong> 未指定</span>";
    }
    echo "で検索しました！</p>";

    // 検索結果一覧
    echo '<h2>検索結果一覧</h2>';
    echo '<p class="results">検索結果は<strong>'.$rowcnt.'</strong>件です</p>';
    echo '<table class="result-table">';
    echo '<thead>';
    echo '<tr>';
    echo '<th>受付番号</th>';
    echo '<th>事業所名</th>';
    echo '<th>所在地</th>';
    echo '<th>勤務地</th>';
    echo '<th>業種</th>';
    echo '<th>職種</th>';
    echo '<th>従業員数</th>';
    echo '<th>休日</th>';
    echo '<th>給料</th>';
    echo '<th>賞与</th>';
    echo '<th>求人数</th>';
    echo '<th>本校枠</th>';
    echo '<th>選考方法</th>';
    echo '</tr>';
    echo '</thead>';
    echo '<tbody>';
    for ($i = 0; $i < $rowcnt; $i++) {
        $row = mysqli_fetch_array($result);
        echo '<tr>';
        for ($j = 0; $j <= 12; $j++) {
            echo '<td>' . $row[$j] . '</td>';
        }
        echo '</tr>';
    }
    echo '</tbody>';
    echo '</table>';
} else {
    echo '<p class="results">検索条件に合致する求人情報はありません。</p>';
}
?>

</body>
</html>