<?php 
include_once 'includes/header.inc.php'; 

if(!$session->getRole() == 1 or !$session->getRole() == 2){
    header("location: login.php");
}

$id = $database->escape($_GET['id']);

if(isset($_POST['submit'])){
    $firstname = $database->escape($_POST['firstname']);
    $lastname = $database->escape($_POST['lastname']);
    $email = $database->escape($_POST['email']);
    $phone_home = $database->escape($_POST['phone_home']);
    $phone_cell = $database->escape($_POST['phone_cell']);
    $address = $database->escape($_POST['address']);
    $zipcode = $database->escape($_POST['zipcode']);
    $city = $database->escape($_POST['city']);
    $birthday = $database->escape($_POST['birthday']);
    
    if($firstname == ""){
        ?>
            <div class="alert alert-error">
                You need to enter the firstname
            </div>
        <?php
    } else {
        $database->query("UPDATE `cal_contacts` SET `firstname`='$firstname',`lastname`='$lastname',`email`='$email',`phone_home`='$phone_home',`phone_cell`='$phone_cell',`address`='$address',`zipcode`='$zipcode',`city`='$city',`birthday`= STR_TO_DATE('$birthday','%d-%m-%Y') WHERE `id` = '$id'");
        ?>
            <div class="alert alert-success">
                The data was saved successfully
            </div>
        <?php
    }
}

$query = $database->query("SELECT `cal_contacts`.*, DATE_FORMAT(`cal_contacts`.`birthday`, '%d-%m-%Y') as `date_trans` FROM `cal_contacts` WHERE `id` = '$id'");
while($row = mysql_fetch_assoc($query)){
    $firstname = $row['firstname'];
    $lastname = $row['lastname'];
    $email = $row['email'];
    $phone_home = $row['phone_home'];
    $phone_cell = $row['phone_cell'];
    $address = $row['address'];
    $zipcode = $row['zipcode'];
    $city = $row['city'];
    $birthday = $row['date_trans'];
}

?>
<form class="form-horizontal" method="post" action="">
  <fieldset>
    <legend>Contactpersoon toevoegen</legend>
    <div class="control-group">
      <label class="control-label" for="firstname">Voornaam</label>
      <div class="controls">
        <input type="text" class="input-xlarge" id="firstname" name="firstname" value="<?php echo $firstname; ?>">
      </div>
    </div>
    <div class="control-group">
      <label class="control-label" for="lastname">Lastname</label>
      <div class="controls">
        <input type="text" class="input-xlarge" id="lastname" name="lastname" value="<?php echo $lastname; ?>">
      </div>
    </div>
    <div class="control-group">
      <label class="control-label" for="email">Emailadres</label>
      <div class="controls">
        <input type="text" class="input-xlarge" id="email" name="email"  value="<?php echo $email; ?>">
      </div>
    </div>
    <div class="control-group">
      <label class="control-label" for="phone_home">Telefoon (thuis)</label>
      <div class="controls">
        <input type="text" class="input-xlarge" id="phone_home" name="phone_home"  value="<?php echo $phone_home; ?>">
      </div>
    </div>
    <div class="control-group">
      <label class="control-label" for="phone_cell">Telefoon (mobiel)</label>
      <div class="controls">
        <input type="text" class="input-xlarge" id="phone_cell" name="phone_cell"  value="<?php echo $phone_cell; ?>">
      </div>
    </div>
    <div class="control-group">
      <label class="control-label" for="address">Straat</label>
      <div class="controls">
        <input type="text" class="input-xlarge" id="address" name="address"  value="<?php echo $address; ?>">
      </div>
    </div>
    <div class="control-group">
      <label class="control-label" for="zipcode">Postcode</label>
      <div class="controls">
        <input type="text" class="input-xlarge" id="zipcode" name="zipcode" value="<?php echo $zipcode; ?>">
      </div>
    </div>
    <div class="control-group">
      <label class="control-label" for="city">Stad</label>
      <div class="controls">
        <input type="text" class="input-xlarge" id="city" name="city" value="<?php echo $city; ?>">
      </div>
    </div>
    <div class="control-group">
      <label class="control-label" for="datepicker">Geboortedatum</label>
      <div class="controls">
        <input type="text" class="input-xlarge" id="datepicker" placeholder="dd-mm-yyyy" name="birthday" value="<?php echo $birthday; ?>"> 
      </div>
    </div>
    <div class="control-group">
      <div class="controls">
            <button type="submit" class="btn btn-primary" name="submit">Save changes</button>
      </div>
    </div>
  </fieldset>
</form>
<?php include_once 'includes/footer.inc.php'; ?>