<?php include "includes/header.php";?>

<?php include "includes/navbar.php";?>

  <div id="wrapper">

    <!-- Sidebar -->
   <?php include "includes/sidebar.php";?>

    <div id="content-wrapper">

      <div class="container-fluid">

        <!-- Breadcrumbs-->
        <ol class="breadcrumb">
          <li class="breadcrumb-item">
            <a href="#">Ola</a>
          </li>
          <li class="breadcrumb-item active"><?php echo $_SESSION['nome'];?></li>
        </ol>

        <!-- Icon Cards-->
        <div class="row">
		      <div class="container">
             
             <!-- Button trigger modal -->
<button type="button" class="btn btn-danger btn-sm" data-toggle="modal" data-target="#exampleModal">
  <i class="fas fa-fw fa-plus"></i> Demissões
</button>

<!-- Modal -->
<div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLabel">Funcionarios</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">
          <div class="container">
              <div class="col-sm-10">
                  
             
          <form action="" method="post" enctype="multipart/form-data">
		    <?php $demitir->Demitir();?>
			<div class="form-group">
			  <label for="nome_cliente">Nome complecto</label>
              <select required name="nome" class="form-control">
                <option></option>
                <?php $funcionario->takeFunc();?>
              </select>
            </div>
			 
			 <div class="form-group">
			  <label for="motivo">Motivo de demissão</label>
              <textarea name="motivo" class="form-control" row="14px" col="24px"></textarea>
            </div>
			
			
		
			 <div class="form-group">
			  <label for="bi">Data da demissão</label>
			  <input type="date" name="data_demissao" class="form-control" autocomplete="off" required/>
			 </div>

             <div class="form-group">
			  <label for="bi">Valor da indeminização</label>
			  <input type="number" name="valor" class="form-control" autocomplete="off" required/>
			 </div>
			
			 <div class="form-group">
			  <input type="submit" name="demitir" class="btn btn-primary btn-block" value="Enviar"/>
			 </div>
	
		   </form>
         </div>
          </div>
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Fechar</button>
      </div>
    </div>
  </div>
</div>

 <br> <br>
 <div class="container-fluid">

<!-- Breadcrumbs-->

<!-- DataTables Example -->
<div class="card mb-3">
  <div class="card-header">
    <i class="fas fa-table"></i>
    <b>Lista de demissoes</b></div>
  <div class="card-body">
    <div class="table-responsive">
      <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
        <thead>
          <tr>
            <th>Item</th>
            <th>Nome</th>
            <th>Data de ingresso</th>
            <th>Data de demissão</th>
              <th>CV</th>
              <th>Historico</th>
          </tr>
        </thead>
       
        <tbody>
            
          <?php 
          $item =1;
          $functionarios = $database->query("SELECT * FROM demissoes");
          while($row = $database->fetch_assoc($functionarios)){
            
            $exFuncionario = $row['nome'];
            $data_demissao = $row['data_demissao'];

            $db = $database->query("SELECT * FROM funcionarios WHERE nome='$exFuncionario'");
            $assoc = $database->fetch_assoc($db);

            $data_de_ingresso = $assoc['data_contracto'];
            $cv = $assoc['cv'];
            $id = $assoc['id'];

           


            ?>
           <tr>   
            <td><?php echo $item++;?></td>
            <td><?php echo $row['nome'];?></td>
            <td><?php echo $data_de_ingresso;?></td>
            <td><?php echo $row['data_demissao'];?></td>
   
            <td><a href="download_file2.php?file=<?php echo $cv;?>">Download</a></td>
          
            <td><button type="button" class="btn btn-success btn-sm" data-toggle="modal" data-target="#exampleModalLong123<?php echo $id;?>">
  <span>Ver</span>
</button></td>

<!-- Modal -->
<div class="modal fade" id="exampleModalLong123<?php echo $id;?>" tabindex="-1" role="dialog" aria-labelledby="exampleModalLongTitle" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLongTitle"><font color="red"><?php echo $row['nome'];?></font></h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">
        <p>
          <img src="img/<?php echo $assoc['foto'];?>" width="120px" height="120px"/><br>
        <b>Motivo</b>: <?php echo $row['motivo'];?><br>
           <b>Valor indeminizado</b>: <?php echo number_format($row['valor'],2,",",".");?> <br>
           <b>Data do contracto</b>: <?php echo $data_de_ingresso;?> <br>
           <b>Data demissao</b>: <?php echo $data_demissao;?> <br>
           <b>Salario Auferido</b>: <?php echo number_format($assoc['salario'],2,",",".");?> <br>
           <b>Contactos</b>: <?php echo $assoc['contacto'];?> - <?php echo $assoc['contacto_2'];?> <br>
           <b>Estado</b>: <?php echo $assoc['status'];?> <br>

           
      
      </p>
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary btn-sm" data-dismiss="modal">Cancelar</button>
      </div>
    </div>
  </div>
</div>
 
          




        </tr>
        
        <?php }
          
          ?>  

         
      
   
               </tbody>
      </table>
    </div>
  </div>
  <div class="card-footer small text-muted">Jonas Dinis Chambela</div>
</div>



</div>

        </div>
      </div>
      <!-- /.container-fluid -->
		  </div>

		 </div>
        
        
        </div>

     
        

      <!-- /.container-fluid -->

      <!-- Sticky Footer -->
      <?php include "includes/footer.php";?>

    </div>
    <!-- /.content-wrapper -->

  </div>
  <!-- /#wrapper -->

  <!-- Scroll to Top Button-->
  <a class="scroll-to-top rounded" href="#page-top">
    <i class="fas fa-angle-up"></i>
  </a>

  <!-- Logout Modal-->
 <?php include "includes/logout_modal.php";?>
 <?php include "includes/sweatscripFooter.php";?>

