Untitled

<!-- ###########################################################################
                  VERIFICACAO DA SESSION                                    -->
<?php session_start();
if (!isset ($_SESSION['uid']))
  header('location: login.php'); ?>
<?php require_once '../style/navigation.php';  ?>

<?php
include '../scripts/checkTop.php';
include '../dataBase/countKeywords.php';
include '../dataBase/bdConnection.php';
include '../dataBase/allCandidato.php'
?>
<!DOCTYPE html>
<html lang="en" dir="ltr">
  <head>
    <meta charset="utf-8">
    <title>Resulta da Pesquisa</title>
  </head>
    <?php
/* ###########################################################################
                  VERIFICACAO DOS PARES DE INFORMAÇÃO VÁLIDOS                 */
      if(isset($_POST['kw'],$_POST['vl'])){
        $kw = $_POST['kw'];
        $vl = $_POST['vl'];
        $struct= array();
        $parametros = array();
        for ($i=0; $i < count($kw) ; $i++) { // VERIFICACAO DOS CAMPOS
          if ((!empty($kw[$i] and $vl[$i])) and is_numeric($vl[$i])) {
            array_push($parametros,strtolower($kw[$i]));
            array_push($parametros,$vl[$i]);
          }
        }

/* ###########################################################################
                CRIAÇÃO DO QUERY COM OS PARAMETROS VÁLIDOS                    */

        for ($i=0; $i < count($parametros) ; $i+=2) {
          array_push($struct,"(LENGTH(Content) - LENGTH(REPLACE (Content, ' $parametros[$i] ', '')))/LENGTH(' $parametros[$i] ') as $parametros[$i]");
        }
/* ###########################################################################
                QUERY PARA IS BUCACAR O TABELA CANDIDATO                      */
        $listaDeCandidatos = allCandidato();
        $struct = implode(",",$struct);
        if (count($parametros)<2) {
          header('location: definirParametros.php');

        }else{
          $listaDeOcorrencias = countKeywords ($struct);

        }


        for ($i=0; $i <count($listaDeOcorrencias) ; $i++) {
          echo $listaDeCandidatos[$i]['CandidatoID']." = ";
          for ($k=0; $k <count($parametros) ; $k+=2) {

            echo $listaDeOcorrencias[$i][$parametros[$k]]." - ";
          }
          echo "<br>";
        }
/* ###########################################################################
                        CALCULO DO SCORE VÁLIDOS                              */
        $listaDeScore = array();
        for ($i=0; $i <count($listaDeOcorrencias) ; $i++) {
          $temp=0;
          for ($k=0; $k <count($parametros) ; $k+=2) {
            $temp += $listaDeOcorrencias[$i][$parametros[$k]]*$parametros[$k+1];
          }
          $listaDeScore[$listaDeCandidatos[$i]['CandidatoID']]=$temp;
        }
/* ###########################################################################
                  ORDENAÇÃO DO SCORE POR ORDEM DECRESCENTE                    */
        arsort($listaDeScore);
      }
?>
  <body>
    <!--
        <div class='col' style='margin-top:2rem;' >
          <div class='row text-center'style='min-width:75rem!important;'>
                <div class='col defCabeca'style='margin-left:0.95rem;'>
                  <th>ID</th>
                </div>
                <div class='col defCabeca'>
                  <th>Nome</th>
                </div>
                <div class='col defCabeca'>
                  <th>Apelido</th>
                </div>
                <div class='col defCabeca'>

                </div>
                <div class='col defCabeca'>
                </div>
                <div class='col defCabeca'>
                  <th>Email</th>
                </div>
                <div class='col defCabeca'>
                </div>
                <div class='col defCabeca'>
                  <th>Score</th>
                </div>
                <div class='col defCabeca'>
                  <th>Editar</th>
                </div>
                <div class='col defCabeca'>
                  <th>Download</th>
                </div>
                <div class='col defCabeca'style='margin-right:4.7rem;'>
                </div>
          </div>
 -->

          <?php
          $limit = 2;
          $query = "SELECT * FROM Candidato";

          $s = $conn->prepare($query);
          $s->execute();
          $total_results = $s->rowCount();
          $total_pages = ceil($total_results/$limit);

          if (!isset($_GET['page'])) {
              $page = 1;
          } else{
              $page = $_GET['page'];
          }


          $starting_limit = ($page-1)*$limit;
          $show  = "SELECT * FROM Candidato ORDER BY CandidatoID DESC LIMIT $starting_limit, $limit";

          $r = $conn->prepare($show);
          $r->execute();
          $lista = array();
          $lista[39] = "CV 39";
          $lista[38] = "CV 38";

          $i=0;?>
    <div class="container">
      <div class="row">
        <div class="col">

        </div>
        <div class='col' style='margin-top:2rem;' >
          <div class='row text-center'style='min-width:75rem!important;'>
            <div class='col defCabeca'style='margin-left:0.95rem;'>
              <th>ID</th>
            </div>
            <div class='col defCabeca'>
              <th>Nome</th>
            </div>
            <div class='col defCabeca'>
              <th>Apelido</th>
            </div>
            <div class='col defCabeca'>
              <th>Email</th>
            </div>
            <div class='col defCabeca'>
              <th>Score</th>
            </div>
            <div class='col defCabeca'>
              <th>Editar</th>
            </div>
            <div class='col defCabeca'>
              <th>Download</th>
            </div>
            <div class='col defCabeca'style='margin-right:4.7rem;'>
            </div>
          </div>
        <div class="container addScrollAreaGestao" style="padding-right:0!important;padding-left:0!important;">
        <table class='table table-hover table-striped table-bordered'>
        <?php
        while($res = $r->fetch(PDO::FETCH_ASSOC)):

        echo '<tr>';
        echo"<td>".$res['CandidatoID']."</td>";
        echo"<td>".$res['FirstName']."</td>";
        echo"<td>".$res['LastName']."</td>";
        echo"<td>".$res['Email']."</td>";

        echo"<td>".$res['CandidatoID']."</td>";

        if ($res['Automatic']== 1) {
          echo "<td><a href='editCandidato.php?id=".$res['CandidatoID']."' id='valor' class='btn btn-info'>Editar</a></td>";

        }else {
          echo "<td> - </td>";
        }
        echo "<td><a href='../scripts/download.php?ic=".$res['CandidatoID']."' id='valor' class='btn btn-info'>Download</a></td>";
        echo"</tr>";

        endwhile;
        ?>

        </table>
        </div>
          <div class="container text-center">
            <div class="row">
              <?php
                for ($page=1; $page <= $total_pages ; $page++):

                echo "<a href=?page=".$page." class='links'>". $page."</a>";

                endfor;
              ?>

            </div>
          </div>
        </div>
        <div class="col">
        </div>
      </div>
    </div>
  </body>
</html>