<?php
session_start();
///Construtoras listar
include "../phpconfig/config.php";
include "../phpconfig/valida_login.php";
include "../phpconfig/funcoes.php";
include "../includes/topo.php"; 

$sql = mysql_query("SELECT * FROM empresas ORDER BY id DESC");
$num = mysql_num_rows($sql);


$sql2 = mysql_query("SELECT * FROM empresas ORDER BY id DESC limit 10");



?>
<script src="//ajax.googleapis.com/ajax/libs/jqueryui/1.9.1/jquery-ui.min.js"></script>
<script type="text/javascript">
  // When the document is ready set up our sortable with it's inherant function(s)
  $(document).ready(function() {
    $("#test-list").sortable({
      handle : '.handle',
      update : function () {
      var order = $('#test-list').sortable('serialize');
      $("#info").load("process-sortable.php?"+order);  
   

      }
    });
}); 

</script>

        <ul class="breadcrumb">
          <li><a href="<?php echo sti('adm');  ?>">Home</a></li>
          <li class="active">200 últimas de <?php echo $num;    ?> empresas</li>
        </ul>


        <table class="table table-bordered">

        <thead>

          <tr>
   

             <th>ID</th>
            <th>Nome</th>

            
             

             <th>Telefone</th>
             <th>slug</th>
             <th>Endereço</th>
             <th>Cidade / UF</th>
             
              <th>uf</th>
              <th>Bairro</th>
             <th></th>
             <th></th>
          </tr>
        </thead>
        <tbody id='test-list'>

          <div id="info"></div>
          <?php  

          while($lin = mysql_fetch_assoc($sql2)){  ?>
          <tr id="listItem_<?php echo $lin['id']; ?>">

            <?php

            $cidade = retorna($lin['id_cidade'], 'l_cidades');
            $estado = retorna($lin['id_uf'], 'l_estados');
            $bairro = retorna($lin['id_bairro'], 'l_bairros');

            ?>

            <td><?php echo $lin['id'];  ?></td>
            <td><?php echo $lin['empresa'];  ?></td>
            <td><?php echo $lin['telefone'];  ?></td>
            <td><?php echo $lin['slug'];  ?></td>
            <td><?php echo $lin['endereco'];  ?></td>
            <td><?php echo $cidade['cidade'];  ?> - <?php echo strtoupper($estado['uf']);  ?></td>
            <td><?php echo ($estado['uf']);  ?></td>
            <td><?php echo $bairro['bairro'];  ?></td>
           
              <td>
              <a href="edit.php?id=<?php echo $lin['id'];  ?>" class="btn btn-default" ><span class="glyphicon glyphicon-pencil"></span></a>
              <a href="del.php?id=<?php echo $lin['id'];  ?>" onclick="return confirma('Deseja deletar este cliente?');" class="btn btn-default" ><span class="glyphicon glyphicon-trash"></span></a>
            </td>

            <td>
              <a href="../completo/edit.php?id=<?php echo $lin['id'];  ?>" class="btn btn-warning" ><span class="glyphicon glyphicon-list"></span></a>
            
            </td>
          </tr>
          <?php  } if($num==0){echo "<tr><td  colspan='9'>Não há cadastro de empresas</td></tr>";} ?>


        </tbody>
      </table>

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