<?php  
$id=0;
if(isset($_GET['id']))
{
  $page_title = 'Edit Staff/Management';
  include 'header.php';
  $id = $_GET['id'];
  $sel=mysqli_query($con,"select * from staff_management where id=$id");
  while($row_staff_management=mysqli_fetch_array($sel))
  {
    ?>
    <div class="content-wrapper">
      <section class="content mt-4">
        <div class="container-fluid">
          <div class="row">
            <div class="col-md-12">
              <?php include('alert-msg.php'); ?>
              <div class="card card-primary">
                <div class="card-header">
                  <h3 class="card-title"><?php echo $page_title; ?></h3>
                </div>
                <form action="" method="POST" enctype="multipart/form-data">
                  <div class="card-body">
                    <div class="row">
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Name</label>
                          <input type="text" class="form-control" name="name" value="<?php echo $row_staff_management['name']; ?>" required />
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Department</label>
                          <input type="text" class="form-control" name="department" value="<?php echo $row_staff_management['department']; ?>" required />
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Designation</label>
                          <input type="text" class="form-control" name="designation" value="<?php echo $row_staff_management['designation']; ?>" required />
                        </div>
                      </div>
                    </div>
                    <div class="row">
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Mobile</label>
                          <input type="text" class="form-control" name="mobile_number" value="<?php echo $row_staff_management['mobile_number']; ?>" required />
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Email</label>
                          <input type="email" class="form-control" name="email" value="<?php echo $row_staff_management['email']; ?>" required />
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Qualification</label>
                          <input type="text" class="form-control" name="qualification" value="<?php echo $row_staff_management['qualification']; ?>" required />
                        </div>
                      </div>
                    </div>
                    <div class="row">
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Type</label>
                          <select class="form-control" name="staff_type">
                            <option value="Staff" <?php echo $row_staff_management['staff_type']=='Staff' ? 'selected' : ''; ?>>Staff</option>
                            <option value="Management" <?php echo $row_staff_management['staff_type']=='Management' ? 'selected' : ''; ?>>Management</option>
                            <option value="Administrator" <?php echo $row_staff_management['staff_type']=='Administrator' ? 'selected' : ''; ?>>Administrator</option>
                            <option value="Non-Teaching" <?php echo $row_staff_management['staff_type']=='Non-Teaching' ? 'selected' : ''; ?>>Non-Teaching</option>
                          </select>
                        </div>
                      </div>
                      <div class="col-md-8">
                        <div class="row">
                          <div class="col-md-8">
                            <div class="form-group">
                              <label for="exampleInputFile">Photos</label>
                              <div class="input-group">
                                <div class="custom-file">
                                  <input type="file" class="custom-file-input fileUpload_allow" name="photo" id="exampleInputFile">
                                  <label class="custom-file-label" for="exampleInputFile">Choose file</label>
                                </div>
                              </div>
                            </div>
                          </div>
                          <div class="col-md-4">
                            <img src="<?php echo $row_staff_management['photo']; ?>" style="width:150px;" />
                          </div>
                        </div>
                      </div>
                    </div>
                    <div class="row">
                      <div class="col-md-12">
                        <div class="form-group">
                          <label>Description</label>
                          <textarea class="text_editor" name="description">
                            <?php echo $row_staff_management['description']; ?>
                          </textarea>
                        </div>
                      </div>
                    </div>
                    <button type="submit" class="btn btn-primary" name="btnSubmit">Submit</button>
                  </div>
                </form>
              </div>
            </div>
          </div>
        </div>
      </section>
    </div>
    <?php
  }
  ?>
  <?php include 'footer.php'; ?>
  <?php
}
else
{
  session_start();
  $_SESSION['error_msg'] = 'Something wrong...';
  echo"<script>window.location='staff-management-list.php';</script>";
}
?>


<?php
if(isset($_POST['btnSubmit']))
{
  $name = $_POST['name'];
  $department = $_POST['department'];
  $designation = $_POST['designation'];
  $mobile_number = $_POST['mobile_number'];
  $email = $_POST['email'];
  $qualification = $_POST['qualification'];
  $staff_type = $_POST['staff_type'];
  $description = $_POST['description'];

  if($_FILES["photo"]["name"]!="")
  {
    $fileinfo=PATHINFO($_FILES["photo"]["name"]);
    $newFilename="staff_". time()."." .$fileinfo['extension'];

    $location="uploads/staff_management/" . $newFilename;
    $upd = mysqli_query($con,"UPDATE `staff_management`  SET name='$name', department='$department',  designation='$designation', mobile_number='$mobile_number', email='$email', qualification='$qualification', staff_type='$staff_type', description='$description', photo='$location' WHERE id=$id");

    if($upd)
    {
      move_uploaded_file($_FILES["photo"]["tmp_name"],$location);
      $_SESSION['success_msg'] = 'Staff/Management has been updated...';
      echo"<script>window.location='staff-management-list.php';</script>";
    }
    else
    {
      $_SESSION['error_msg'] = 'Unable to update Staff/Management...';
      echo"<script>window.location='staff-management-list.php';</script>";
    }
  }
  else
  {
    $upd = mysqli_query($con,"UPDATE `staff_management`  SET name='$name', department='$department',  designation='$designation', mobile_number='$mobile_number', email='$email', qualification='$qualification', staff_type='$staff_type', description='$description' WHERE id=$id");
    if($upd)
    {
      $_SESSION['success_msg'] = 'Staff/Management has been updated...';
      echo"<script>window.location='staff-management-list.php';</script>";
    }
    else
    {
      $_SESSION['error_msg'] = 'Unable to update Staff/Management...';
      echo"<script>window.location='staff-management-list.php';</script>";
    }
  }
}
?>