<?php
// Include config file
require_once "config.php";

// Define variables and initialize with empty values
$first_name = $middle_name = $last_name = $pnumber = $nation = $mail = $country = $city = $area = $idno = $tscno = $curr = $gender = $subjects = $ppic = "";
$first_name_err = $middle_name_err = $last_name_err = $pnumber_err = $nation_err = $mail_err = $country_err = $city_err = $area_err = $idno_err = $tscno_err = $curr_err = $gender_err = $subjects_err = $ppic_err = "";

// Processing form data when form is submitted
if($_SERVER["REQUEST_METHOD"] == "POST"){

  // Validate First Name
  if(empty(trim($_POST["firstname"]))){
      $first_name_err = "Please input First Name.";
  } else{
      $first_name = trim($_POST["firstname"]);
  }

  // Validate Midlle Name
  if(empty(trim($_POST["middlename"]))){
      $middle_name_err = "Please input Middle Name.";
  } else{
      $middle_name = trim($_POST["middlename"]);
  }

  // Validate Last Name
  if(empty(trim($_POST["lastname"]))){
      $last_name_err = "Please input Last Name.";
  } else{
      $last_name = trim($_POST["lastname"]);
  }

  // Validate Phone Number
  if(empty(trim($_POST["pnumber"]))){
      $pnumber_err = "Please input your phone number.";
  }
 else{
    // Prepare a select statement
    $sql = "SELECT id FROM teachers WHERE pnumber = ?";

    if($stmt = mysqli_prepare($link, $sql)){
        // Bind variables to the prepared statement as parameters
        mysqli_stmt_bind_param($stmt, "i", $param_pnumber);

        // Set parameters
        $param_pnumber = trim($_POST["pnumber"]);

        // Attempt to execute the prepared statement
        if(mysqli_stmt_execute($stmt)){
            /* store result */
            mysqli_stmt_store_result($stmt);

            if(mysqli_stmt_num_rows($stmt) == 1){
                $pnumber_err = "The phone number is already taken. Please choose another.";
            } else{
                $pnumber = trim($_POST["pnumber"]);
            }
        } else{
            echo "Oops! Something went wrong. Please try again later.";
        }
    }

    // Close statement
    mysqli_stmt_close($stmt);
}

  // Validate Nationality
  if(empty(trim($_POST["nation"]))){
      $nation_err = "Please input your nationality.";
  } else{
      $nation = trim($_POST["nation"]);
  }

  // Validate email address
  if(empty(trim($_POST["mail"]))){
      $mail_err = "Please input email address.";
    }
    else{
        $mail = trim($_POST["mail"]);
    }

  // Validate country
  if(empty(trim($_POST["country"]))){
      $country_err = "Your country of residence.";
  } else{
      $country = trim($_POST["country"]);
  }

  // Validate city
  if(empty(trim($_POST["city"]))){
      $city_err = "Your city of residence.";
  } else{
      $city = trim($_POST["city"]);
  }

  // Validate Area
  if(empty(trim($_POST["area"]))){
      $area_err = "Your area of residence.";
  } else{
      $area = trim($_POST["area"]);
  }

  // Validate ID no
  if(empty(trim($_POST["idno"]))){
      $idno_err = "Please input your ID no.";
  }
  else{
     // Prepare a select statement
     $sql = "SELECT id FROM teachers WHERE idno = ?";

     if($stmt = mysqli_prepare($link, $sql)){
         // Bind variables to the prepared statement as parameters
         mysqli_stmt_bind_param($stmt, "i", $param_idno);

         // Set parameters
         $param_idno = trim($_POST["idno"]);

         // Attempt to execute the prepared statement
         if(mysqli_stmt_execute($stmt)){
             /* store result */
             mysqli_stmt_store_result($stmt);

             if(mysqli_stmt_num_rows($stmt) == 1){
                 $idno_err = "The ID number is already taken. Please choose another.";
             } else{
                 $idno = trim($_POST["idno"]);
             }
         } else{
             echo "Oops! Something went wrong. Please try again later.";
         }
     }

     // Close statement
     mysqli_stmt_close($stmt);
 }

  // Validate TSC no
  if(empty(trim($_POST["tscno"]))){
      $tscno_err = "Please input your TSC no.";
    }
    else{
       // Prepare a select statement
       $sql = "SELECT id FROM teachers WHERE tscno = ?";

       if($stmt = mysqli_prepare($link, $sql)){
           // Bind variables to the prepared statement as parameters
           mysqli_stmt_bind_param($stmt, "i", $param_tscno);

           // Set parameters
           $param_tscno = trim($_POST["tscno"]);

           // Attempt to execute the prepared statement
           if(mysqli_stmt_execute($stmt)){
               /* store result */
               mysqli_stmt_store_result($stmt);

               if(mysqli_stmt_num_rows($stmt) == 1){
                   $tscno_err = "The TSC number is already taken. Please choose another.";
               } else{
                   $tscno = trim($_POST["tscno"]);
               }
           } else{
               echo "Oops! Something went wrong. Please try again later.";
           }
       }

       // Close statement
       mysqli_stmt_close($stmt);
   }

  /* Validate DoB
  if(empty(trim($_POST["dob"]))){
      $dob_err = "Please select date of birth.";
  } else{
      $dob = trim($_POST["dob"]);
  }*/


  // Validate Curriculum
  if(empty(trim($_POST["curr"]))){
      $curr_err = "Please select your preferred curriculum.";
  } else{
      $curr = trim($_POST["curr"]);
  }

  // Validate Gender
  if(empty(trim($_POST["gender"]))){
      $gender_err = "Please select gender.";
  } else{
      $gender = trim($_POST["gender"]);
  }

  if(empty(trim($_POST["gender"]))){
      $gender_err = "Please select gender.";
  } else{
      $gender = trim($_POST["gender"]);
  }

/*$subjects = trim($_POST["subjects"]);*/
$chkbox=$_POST['subjects'];
foreach($chkbox as $chkboxresult)
{
  $subjects.=$chkboxresult.","." ";
}

// PROFILE PICTURE
    // Check if file was uploaded without errors
    // Initialize message variable

    // If upload button is clicked ...

    	// Get image name
    	$image = $_FILES['ppic']['tmp_name'];
      $img = @file_get_contents($image);
      if ($img === false) {
      $ppic_err = "Please upload picture";
   }


    // Check input errors before inserting in database
if(empty($first_name_err) && empty($middle_name_err) && empty($last_name_err) && empty($pnumber_err) && empty($nation_err) && empty($mail_err) && empty($country_err) && empty($city_err) && empty($area_err) && empty($idno_err) && empty($tscno_err) && empty($curr_err)
 && empty($gender_err) && empty($ppic_err)){

        // Prepare an insert statement
        $sql = "INSERT INTO teachers (firstname, middlename, lastname, pnumber, nation, mail, country, city, area, idno, tscno, curr, gender, subjects, ppic) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

        if($stmt = mysqli_prepare($link, $sql)){
            // Bind variables to the prepared statement as parameters
            mysqli_stmt_bind_param($stmt, "sssisssssiissss", $param_first_name, $param_middle_name, $param_last_name, $param_pnumber, $param_nation, $param_mail, $param_country, $param_city, $param_area, $param_idno, $param_tscno, $param_curr, $param_gender, $param_subjects, $img);

            // Set parameters
            $param_first_name = strtolower($first_name);
            $param_middle_name = strtolower($middle_name);
            $param_last_name =  strtolower($last_name);
            $param_pnumber = $pnumber;
            $param_nation = strtolower($nation);
            $param_mail = strtolower($mail);
            $param_country = strtolower($country);
            $param_city = strtolower($city);
            $param_area = strtolower($area);
            $param_idno = $idno;
            $param_tscno = $tscno;
            $param_subjects = $subjects;
            $param_curr = $curr;
            $param_gender = $gender;
            $param_subjects = $subjects;
            $param_ppic = $ppic;


            // Attempt to execute the prepared statement
            if(mysqli_stmt_execute($stmt)){
                // Redirect to login page
                header("location:thankyou");

            } else{
                echo "something went wrong bro!!" . mysqli_error($link);
            }
        }

        // Close statement
        mysqli_stmt_close($stmt);
    }

    // Close connection
    mysqli_close($link);
}
?>
<!doctype html>
<?php include("header.php") ?>
        <!-- mobile-menu-area end -->
        <!-- End of header area -->
        <section class="breadcrumbs-area bg-sign ptb-110 bg-opacity bg-relative">
            <div class="container">
                <div class="row">
                    <div class="col-md-12 text-center">
                        <div class="breadcrumbs">
                            <h2 class="page-title">Teacher's Registration Form</h2>
                            <ul>
                                <li>
                                    <a class="active" href="index">Home</a>
                                </li>
                                <li>Sign Up</li>
                            </ul>
                        </div>
                    </div>
                </div>
            </div>
        </section>
        <!-- Start page content -->
              <section class="about-area ptb-50 gray-bg">
                <div class="container">
                <div class="row white-bg sign-up-all">
                  <!--Sign up form-->
                    <div class="col-md-12">
                      <h4 class="text-center">This section is to be filled by the teachers who wish to register with Homeschool <span><a href="staff/login">Africa</a></span></h4><br><br>
                        <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post" enctype="multipart/form-data">
                          <div class="col-md-7">
                            <div class="row ptb-10">
                              <div class="col-md-12">
                                <div class="col-md-4 ">
                                  <div class="form-input form-group <?php echo (!empty($first_name_err)) ? 'has-error' : ''; ?>">
                                    <label>First name</label>
                                      <input type="text" name="firstname" placeholder="eg:John*"class="form-control" value="<?php echo $first_name; ?>">
                                      <span class="help-block"><?php echo $first_name_err; ?></span>
                                  </div>
                                </div>
                                <div class="col-md-4 ">
                                  <div class="form-input form-group <?php echo (!empty($middle_name_err)) ? 'has-error' : ''; ?>">
                                    <label>Middle name name</label>
                                      <input type="text" name="middlename" placeholder="eg:Hendrix*" class="form-control" value="<?php echo $middle_name; ?>">
                                      <span class="help-block"><?php echo $middle_name_err; ?></span>
                                  </div>
                                </div>
                                <div class="col-md-4">
                                  <div class="form-input form-group <?php echo (!empty($last_name_err)) ? 'has-error' : ''; ?>">
                                    <label>Last name</label>
                                      <input type="text" name="lastname" placeholder="eg:Brown*" class="form-control" value="<?php echo $last_name; ?>">
                                      <span class="help-block"><?php echo $last_name_err; ?></span>
                                  </div>
                                </div>
                              </div>
                            </div>
                            <div class="row ptb-10">
                                  <div class="col-md-6">
                                      <div class="form-input mrg-eml input-group <?php echo (!empty($gender_err)) ? 'has-error' : ''; ?>">
                                          <label class="label pb-10">Gender</label>
                                          <div class="col-md-6 col-sm-12">
                                                  <label class="radio-container mr-40">Male
                                                      <input type="radio" name="gender" checked="checked" <?php if (isset($gender) && $gender=="male") echo "checked";?> value="male">
                                                      <span class="checkmark"></span>
                                                  </label>
                                                </div>
                                                <div class="col-md-6 col-sm-12">
                                                  <label class="radio-container">Female
                                                      <input type="radio" name="gender" <?php if (isset($gender) && $gender=="female") echo "checked";?> value="female">
                                                      <span class="checkmark"></span>
                                                  </label>
                                                </div>
                                              <span class="help-block"><?php echo $gender_err; ?></span>
                                          </div>
                                    </div>
                                    <div class="col-md-6">
                                      <div class="form-input form-group <?php echo (!empty($ppic_err)) ? 'has-error' : ''; ?>">
                                             <label for="fileSelect">Profile Picture</label>
                                             <input type="file" name="ppic" class="form-control" style="padding-bottom:30px;"  value="<?php echo $ppic; ?>">
                                             <p style="color:#595959;"><strong>Note:</strong> Only .jpg, .jpeg, .gif, .png formats allowed to a max size of 2 MB.</p>
                                             <span class="help-block"><?php echo $ppic_err; ?></span>
                                      </div>
                                    </div>
                                  </div>
                              <div class="row ptb-10">
                                <div class="col-md-12">
                                  <div class="col-md-4">
                                      <div class="form-input form-group <?php echo (!empty($nation_err)) ? 'has-error' : ''; ?>">
                                        <label>Nationality</label>
                                          <input name="nation" placeholder="eg:kenyan*" type="text" class="form-control" value="<?php echo $nation; ?>">
                                          <span class="help-block"><?php echo $nation_err; ?></span>
                                      </div>
                                  </div>
                                  <div class="col-md-5">
                                    <div class="form-input form-group <?php echo (!empty($mail_err)) ? 'has-error' : ''; ?>">
                                        <label>Email</label>
                                        <input type="text" name="mail" placeholder="eg:Johnbrown@example.com" class="form-control" value="<?php echo $mail; ?>">
                                        <span class="help-block"><?php echo $mail_err; ?></span>
                                    </div>
                                  </div>
                                  <div class="col-md-3">
                                    <div class="form-input form-group <?php echo (!empty($pnumber_err)) ? 'has-error' : ''; ?>">
                                        <label>Phone no.</label>
                                        <input type="text" name="pnumber" placeholder="eg:0700000000" class="form-control" value="<?php echo $pnumber; ?>">
                                        <span class="help-block"><?php echo $pnumber_err; ?></span>
                                    </div>
                                  </div>
                                </div>
                              </div>
                              <div class="row ptb-10">
                                <div class="col-md-12">
                                  <div class="col-md-4">
                                    <div class="form-input form-group <?php echo (!empty($country_err)) ? 'has-error' : ''; ?>">
                                        <label>Country of origin</label>
                                        <input type="text" name="country" placeholder="eg:kenya" class="form-control" value="<?php echo $country; ?>">
                                        <span class="help-block"><?php echo $country_err; ?></span>
                                    </div>
                                  </div>
                                  <div class="col-md-4">
                                    <div class="form-input form-group <?php echo (!empty($city_err)) ? 'has-error' : ''; ?>">
                                        <label>Residing city</label>
                                        <input type="text" name="city" placeholder="eg:Nairobi"class="form-control" value="<?php echo $city; ?>">
                                        <span class="help-block"><?php echo $city_err; ?></span>
                                    </div>
                                  </div>
                                  <div class="col-md-4">
                                    <div class="form-input form-group <?php echo (!empty($area_err)) ? 'has-error' : ''; ?>">
                                        <label>Residing Area</label>
                                        <input type="text" name="area" placeholder="eg:Lavington" class="form-control" value="<?php echo $area; ?>">
                                        <span class="help-block"><?php echo $area_err; ?></span>
                                    </div>
                                  </div>
                                </div>
                              </div>
                          </div>
                          <div class="col-md-5">
                            <h4> Mandatory Requirements</h4>
                            <div class=" gray-bg" style="  box-shadow: 0 10px 20px rgba(20, 61, 107, 0.3); border-radius: 10px;">
                            <div class="row pt-20">
                              <div class="col-md-12">
                                <div class="col-md-6">
                                  <div class="form-input form-group <?php echo (!empty($idno_err)) ? 'has-error' : ''; ?>">
                                      <label>ID number</label>
                                      <input type="tel" name="idno" placeholder="eg:11111111" class="form-control" value="<?php echo $idno; ?>">
                                      <span class="help-block"><?php echo $idno_err; ?></span>
                                  </div>
                                </div>
                                <div class="col-md-6">
                                  <div class="form-input form-group <?php echo (!empty($tscno_err)) ? 'has-error' : ''; ?>">
                                      <label>TSC Number</label>
                                      <input type="tel" name="tscno" placeholder="eg:333555" class="form-control" value="<?php echo $tscno; ?>">
                                      <span class="help-block"><?php echo $tscno_err; ?></span>
                                  </div>
                                </div>
                              </div>
                              <div class="col-md-12">
                                <div class="col-md-6">
                                  <div class="form-group <?php echo (!empty($curr_err)) ? 'has-error' : ''; ?>">
                                          <label >Curriculum select</label>
                                          <select type="text" class="form-control form-control-sm short-input select" name="curr" value="<?php echo $curr; ?>">
                                            <option selected="selected">Choose option</option>
                                            <option value="2663 only">2-6-6-3 only</option>
                                            <option value="igcse only">I.G.C.S.E only</option>
                                            <option value="ib only">I.B only</option>
                                            <option value="2663 & igcse">2-6-6-3 & I.G.C.S.E</option>
                                            <option value="igcse & ib">I.G.C.S.E & I.B</option>
                                            <option value="2663 & ib">2-6-6-3 & I.B</option>
                                            <option value="2663 & igcse & ib">2-6-6-3 & I.G.C.S.E & I.B</option>
                                          </select>
                                          <span class="help-block"><?php echo $curr_err; ?></span>
                                        </div>
                                </div>
                              </div>
                              <div class="col-md-12">
                                <div class="col-md-12">
                                <div class="form-group">
                                  <label class="pb-10">Please select subjects you wish to teach</label>
                                      <div class="form-input mrg-eml input-group pb-10" style="border:1px solid #9999ff; border-radius: 2%;">
                                          <div class="col-md-4 col-sm-4 pb-20">
                                                  <label class=" radio-container fsize10">Mathematics
                                                      <input type="checkbox" name="subjects[]" checked="checked" value="math">
                                                      <span class="checkmark"></span>
                                                  </label><br>
                                                  <label class=" radio-container fsize10">Physics
                                                      <input type="checkbox" name="subjects[]" value="physics">
                                                      <span class="checkmark"></span>
                                                  </label><br>
                                                  <label class=" radio-container fsize10">Comp studies
                                                      <input type="checkbox" name="subjects[]" value="comp_studies">
                                                      <span class="checkmark"></span>
                                                  </label><br>
                                                  <label class=" radio-container fsize10">Biology
                                                      <input type="checkbox" name="subjects[]" value="biology">
                                                      <span class="checkmark"></span>
                                                  </label><br>
                                                  <label class=" radio-container fsize10">Chemistry
                                                      <input type="checkbox" name="subjects[]" value="chemistry">
                                                      <span class="checkmark"></span>
                                                  </label><br>
                                                  <label class=" radio-container fsize10">Geography
                                                      <input type="checkbox" name="subjects[]" value="geography">
                                                      <span class="checkmark"></span>
                                                  </label>
                                                </div>
                                                <div class="col-md-4 col-sm-4 pb-20">
                                                        <label class=" radio-container fsize10 fsize10">Home Sci.
                                                            <input type="checkbox" name="subjects[]" value="home_sci" >
                                                            <span class="checkmark"></span>
                                                        </label><br>
                                                        <label class=" radio-container fsize10 ">Agriculture
                                                            <input type="checkbox" name="subjects[]" value="agriculture">
                                                            <span class="checkmark"></span>
                                                        </label><br>
                                                        <label class=" radio-container fsize10 mr-40 ">Business
                                                            <input type="checkbox" name="subjects[]" value="business">
                                                            <span class="checkmark"></span>
                                                        </label><br>
                                                        <label class=" radio-container fsize10">History
                                                            <input type="checkbox" name="subjects[]" value="history">
                                                            <span class="checkmark"></span>
                                                        </label><br>
                                                        <label class=" radio-container fsize10">IRE
                                                            <input type="checkbox" name="subjects[]" value="ire">
                                                            <span class="checkmark"></span>
                                                        </label><br>
                                                        <label class=" radio-container fsize10">CRE
                                                            <input type="checkbox" name="subjects[]" value="cre">
                                                            <span class="checkmark"></span>
                                                        </label>
                                                      </div>
                                                      <div class="col-md-4 col-sm-4 pb-20">
                                                        <label class=" radio-container fsize10">English
                                                            <input type="checkbox" name="subjects[]" value="english">
                                                            <span class="checkmark"></span>
                                                        </label><br>
                                                        <label class=" radio-container fsize10">Literature
                                                            <input type="checkbox" name="subjects[]" value="literature">
                                                            <span class="checkmark"></span>
                                                        </label><br>
                                                              <label class=" radio-container fsize10">French
                                                                  <input type="checkbox" name="subjects[]" value="french">
                                                                  <span class="checkmark"></span>
                                                              </label><br>
                                                              <label class=" radio-container fsize10 mr-40 ">Kiswahili
                                                                  <input type="checkbox" name="subjects[]" value="kiswahili">
                                                                  <span class="checkmark"></span>
                                                              </label><br>
                                                              <label class=" radio-container fsize10 mr-40 ">Spanish
                                                                  <input type="checkbox" name="subjects[]" value="spanish">
                                                                  <span class="checkmark"></span>
                                                              </label><br>
                                                              <label class=" radio-container fsize10">Arabic
                                                                  <input type="checkbox" name="subjects[]" value="arabic">
                                                                  <span class="checkmark"></span>
                                                              </label><br>
                                                              <label class=" radio-container fsize10">German
                                                                  <input type="checkbox" name="subjects[]" value="german">
                                                                  <span class="checkmark"></span>
                                                              </label><br>
                                                              <label class=" radio-container fsize10">Mandarin
                                                                  <input type="checkbox" name="subjects[]" value="mandarin">
                                                                  <span class="checkmark"></span>
                                                              </label><br>
                                                            </div>
                                              <span class="help-block"></span>
                                          </div>
                                </div>
                              </div>
                              </div>
                            </div>
                          </div>
                        </div>
                          <div class="row">
                            <div class="col-md-12 mt-20 col-xs-12">
                                <div class="text-leave2">
                                  <div class="col-md-6 col-xs-12 col-2 mb-20">
                                  <button type="submit" class="submit" value="Submit">Submit</button>
                                </div>
                                <div class="col-md-6 col-xs-12 ">
                                  <button type="reset" class="clear" value="Reset">Reset</button>
                                </div>
                              </div>
                            </div>
                        </div>
                        </form>
                      </div>
                </div>
              </div>
              </section>
        <!-- End page content -->