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

$sql = mysql_query("SELECT * FROM banners ORDER BY ordem ASC");
$num = mysql_num_rows($sql);

?>
<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"><?php echo $num;    ?> Banners</li>
        </ul>


        <table class="table table-bordered">

        <thead>
          <tr>
            <th  colspan='6'> 

              <a href="add.php" class="btn btn-success" >Adicionar novo <span class="glyphicon glyphicon-plus"></span></a>
              
            </th>

          </tr>
          <tr>
            <th>MOVER</th>
            <th>Imagem</th>
            <th>Título</th>
            <th>link</th>
             <th>Ação</th>
          </tr>
        </thead>
        <tbody id='test-list'>

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

          while($lin = mysql_fetch_assoc($sql)){  ?>
          <tr id="listItem_<?php echo $lin['id']; ?>">
            <td> <div class="box_img handle" style="cursor:move;display:block">
            <div class="mover"><span class='glyphicon glyphicon-move'></span></div></td>
            <td style='width:400px'><img width='400' src="<?php echo  sti('down').'banners/'.$lin['imagem'];  ?>" /></td>
            <td><?php echo $lin['titulo_pt'];  ?></td>
            <td><?php echo $lin['link'];  ?></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 banner?');" class="btn btn-default" ><span class="glyphicon glyphicon-trash"></span></a>
            </td>
          </tr>
          <?php  } if($num==0){echo "<tr><td  colspan='6'>Não há cadastro de banners</td></tr>";} ?>


        </tbody>
      </table>

<!--div class="pagination">
  <ul>
    <li><a href="#">Prev</a></li>
    <li><a href="#">1</a></li>
    <li><a href="#">2</a></li>
    <li><a href="#">3</a></li>
    <li><a href="#">4</a></li>
    <li><a href="#">Next</a></li>
  </ul>
</div-->

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