PHP Classes

File: app/views/news.php

Recommend this page to a friend!
  Classes of Laudir Bispo   PHP Real Estate Website   app/views/news.php   Download  
File: app/views/news.php
Role: Example script
Content type: text/plain
Description: Example script
Class: PHP Real Estate Website
Manage the properties of a real estate business
Author: By
Last change:
Date: 3 years ago
Size: 13,133 bytes
 

Contents

Class file image Download
<?php use config\connect_db; use app\controls\errors; use app\controls\perms; require_once ($_SERVER['DOCUMENT_ROOT'].'/config/public_functions.php'); require_once ($_SERVER['DOCUMENT_ROOT'].'/app/controls/adminFunctions.php'); $errors = new errors(); $user_perms = new perms(); if( ($_SESSION['user_master_perms'] !== 'administrador') ) { if( $_SESSION['news_read'] !== '1' ) { die ('<script>location.href="/app/admin.php?page=access_denied";</script>'); } } ?> <SECTION CLASS="content-header border-bottom"> <H1 CLASS="text-danger"><STRONG>Notícias</STRONG></H1> <OL CLASS="breadcrumb"> <LI><a href="admin.php?page=home"><I CLASS="fa fa-home" ARIA-HIDDEN="true"></I></a></LI> <LI><a href="admin.php?page=noticias"><I CLASS="fa fa-newspaper-o" ARIA-HIDDEN="true"></I> Notícias</a></LI> </OL> </SECTION> <DIV CLASS="space30"></DIV> <SECTION CLASS="row"> <DIV CLASS="container"> <NAV CLASS="navbar"> <DIV CLASS="container-fluid"> <!-- Brand and toggle get grouped for better mobile display --> <DIV CLASS="navbar-header"> <button type="button" class="navbar-toggle collapsed" DATA-TOGGLE="collapse" DATA-TARGET="#bs-example-navbar-collapse-1" aria-expanded="false"> <SPAN CLASS="sr-only">Toggle navigation</SPAN> <SPAN CLASS="icon-bar"></SPAN> <SPAN CLASS="icon-bar"></SPAN> <SPAN CLASS="icon-bar"></SPAN> </button> </DIV> <!-- Collect the nav links, forms, and other content for toggling --> <DIV CLASS="collapse navbar-collapse" ID="bs-example-navbar-collapse-1"> <UL CLASS="nav navbar-nav"> <LI CLASS="dropdown"> <a href="#" class="dropdown-toggle" DATA-TOGGLE="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Ordernar Por: <SPAN CLASS="caret"></SPAN></a> <UL CLASS="dropdown-menu"> <LI><a href="?page=noticias&order=date-desc"><I CLASS="fa fa-sort-numeric-desc" ARIA-HIDDEN="true"></I> Data mais recente</a></LI> <LI><a href="?page=noticias&order=date-asc"><I CLASS="fa fa-sort-numeric-asc" ARIA-HIDDEN="true"></I> Data mais antiga</a></LI> <LI><a href="?page=noticias&order=views-desc"><I CLASS="fa fa-sort-amount-desc" ARIA-HIDDEN="true"></I> Mais acessadas</a></LI> <LI><a href="?page=noticias&order=views-asc"><I CLASS="fa fa-sort-amount-asc" ARIA-HIDDEN="true"></I> Menos acessadas</a></LI> <LI><a href="?page=noticias&order=favorite"><I CLASS="fa fa-star" ARIA-HIDDEN="true"></I> Marcadas como favoritas</a></LI> <LI><a href="?page=noticias&order=clear"><I CLASS="fa fa-bars" ARIA-HIDDEN="true"></I> Padrão</a></LI> </UL> </LI> <LI CLASS="dropdown"> <a href="#" class="dropdown-toggle" DATA-TOGGLE="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Número de Registros: <SPAN CLASS="caret"></SPAN></a> <UL CLASS="dropdown-menu"> <LI><a href="?page=noticias&limite=25" title="Valor Recomendado!">25</a></LI> <LI><a href="?page=noticias&limite=50">50</a></LI> <LI><a href="?page=noticias&limite=100">100</a></LI> <LI><a href="?page=noticias&limite=250">250</a></LI> <LI><a href="?page=noticias&limite=all" title="O sistema pode ficar lento!">Todas</a></LI> </UL> </LI> </UL> <form class="navbar-form navbar-right" role="search"> <DIV CLASS="form-group"> <input type="text" class="form-control" id="filter-table" DATA-TABLE="table-noticias" placeholder="Buscar registros" style="width:400px"> </DIV> </form> </DIV> <!-- /.navbar-collapse --> </DIV> <!-- /.container-fluid --> </NAV> <DIV> <TABLE CLASS="table table-striped table-responsive" ID="table-noticias"> <THEAD> <TR CLASS="bg-primary"> <TH STYLE="width:5% !important;"><input type="checkbox" name="del-all" id="del-all"></TH> <TH STYLE="width:10% !important;">ID</TH> <TH STYLE="width:13% !important;">DATA POST</TH> <TH STYLE="width:50% !important;">TÍTULO</TH> <TH STYLE="width:2% !important;"><I CLASS="fa fa-star" ARIA-HIDDEN="true" TITLE="Favoritar"></I></TH> <TH STYLE="width:10% !important;">VIEWS</TH> <TH STYLE="width:10% !important;">AÇÕES</TH> </TR> </THEAD> <?php $con_db = new config\connect_db(); $con = $con_db->connect(); $pag = ( empty($_GET['pag']) or !isset($_GET['pag']) ) ? 0 : $_GET['pag'] ; if(empty($_GET['order']) == true or !isset($_GET['order'])) { $order = (!isset($_SESSION['order-noticias']) ) ? "ORDER BY `id` DESC " : $_SESSION['order-noticias'] ; } else { if($_GET['order'] == 'date-asc') { $order = "ORDER BY `date_post` ASC" ; } else if($_GET['order'] == 'date-desc') { $order = "ORDER BY `date_post` DESC" ; } else if($_GET['order'] == 'views-desc') { $order = "ORDER BY `views` DESC" ; } else if($_GET['order'] == 'views-asc') { $order = "ORDER BY `views` ASC" ; } else if($_GET['order'] == 'favorite') { $order = "ORDER BY `favorite` DESC" ; } else if($_GET['order'] == 'clear') { $order = "ORDER BY `id` DESC" ; } else { $order = "ORDER BY `id` DESC" ; } $_SESSION['order-noticias'] = $order; } if(empty($_GET['limite']) == true or !isset($_GET['limite'])) { $limite = (!isset($_SESSION['limite-noticia']) ) ? '25' : $_SESSION['limite-noticia'] ; } else if ($_GET['limite'] == 'all') { $inicio = 0; $limite = 99999; } else { $limite = filter_var($_GET['limite'], FILTER_SANITIZE_NUMBER_INT); $_SESSION['limite-noticia'] = $limite; } if ($pag and $pag != '') { $inicio = ($pag - 1) * $limite; } else { $inicio = 0; } $noticias = $con->query("SELECT * FROM `noticias` $order LIMIT $inicio,$limite"); $total_reg = $noticias->num_rows; $print_noticias = '<TBODY>'; while($reg = $noticias->fetch_array()) { $favorite = ($reg['favorite'] == '1') ? 'favorite' : '' ; $strong = ($reg['favorite'] == '1') ? 'class="strong"' : '' ; $print_noticias .= '<TR '.$strong.'>'; $print_noticias .= ' <TD><input type="checkbox" name="del[]" value="'.$reg['id'].'" class="del" form="form-noticias"></TD>'; $print_noticias .= ' <TD>'.$reg['id'].'</TD> '; $print_noticias .= ' <TD>'.inverteData(substr($reg['date_post'], 0, 10)).'</TD>'; $print_noticias .= ' <TD>'.$reg['titulo'].'</TD>'; $print_noticias .= ' <TD><I CLASS="fa fa-star star-marked '.$favorite.'" ARIA-HIDDEN="true" TITLE="Favoritar" DATA-STAR-ID="'.$reg['id'].'"></I></TD>'; $print_noticias .= ' <TD>'.$reg['views'].'</TD>'; $print_noticias .= ' <TD><a href="?page=editar_noticia&id='.base64_encode($reg['id']).'" title="Editar"><I CLASS="fa fa-edit color-verde"></I></a><I CLASS="fa fa-trash-o color-red delete" data-id="'.$reg['id'].'" data-table="noticias"></I></TD>'; $print_noticias .= '</TR>'; } $print_noticias .= '</TBODY>'; if( $noticias and $total_reg > 0 ) { echo $print_noticias; } else if( $total_reg <= 0 ) { echo '<div class="alert alert-danger" role="alert">Não encontramos nenhum registro!</strong>'; } else if( !$noticias ) { echo '<div class="alert alert-danger" role="alert">O servidor não está respondendo!</div>'; } // paginação---------- $busca_total = $con->query("SELECT COUNT(*) as `id` FROM `noticias` "); $total = $busca_total->fetch_array(); $total = $total['id']; $prox = $pag + 1; $ant = $pag - 1; $ultima_pag = ceil($total / $limite); $penultima = $ultima_pag - 1; @$adjacentes = 2; if( $pag>1 ) { $paginacao = '<li><a href="?page=noticias&pag='.$ant.'"><i class="fa fa-arrow-left"></i></a>'; } if( $ultima_pag <= 5 ) { for ($i=1; $i< $ultima_pag+1; $i++) { if( $i == $pag ) { @$paginacao .= '<li><a class="atual" href="?page=noticias&pag='.$i.'">'.$i.'</a>'; } else { @$paginacao .= '<li><a href="?page=noticias&pag='.$i.'">'.$i.'</a>'; } } } if( $ultima_pag > 5 ) { if( $pag < 1 + (2 * $adjacentes) ) { for ($i=1; $i< 2 + (2 * $adjacentes); $i++) { if( $i == $pag ) { @$paginacao .= '<li><a class="atual" href="?page=noticias&pag='.$i.'">'.$i.'</a>'; } else { @$paginacao .= '<li><a href="?page=noticias&pag='.$i.'">'.$i.'</a>'; } } $paginacao .= '<li><a href="javascript:;">...</a></li>'; $paginacao .= '<li><a href="?page=noticias&pag='.$penultima.'">'.$penultima.'</a></li>'; $paginacao .= '<li><a href="?page=noticias&pag='.$ultima_pag.'">'.$ultima_pag.'</a></li>'; } elseif( $pag > (2 * $adjacentes) && $pag < $ultima_pag - 3 ) { $paginacao .= '<li><a href="?page=noticias&pag=1">1</a></li>'; $paginacao .= '<li><a href="javascript:;">...</a></li>'; for ($i = $pag-$adjacentes; $i<= $pag + $adjacentes; $i++) { if ($i == $pag) { $paginacao .= '<li><a class="atual" href="?page=noticias&pag='.$i.'">'.$i.'</a></li>'; } else { $paginacao .= '<li><a href="?page=noticias&pag='.$i.'">'.$i.'</a></li>'; } } $paginacao .= '<li><a href="javascript:;">...</a></li>'; $paginacao .= '<li><a href="?page=noticias&pag='.$penultima.'">'.$penultima.'</a></li>'; $paginacao .= '<li><a href="?page=noticias&pag='.$ultima_pag.'">'.$ultima_pag.'</a></li>'; } else { $paginacao .= '<li><a href="?page=noticias&pag=1">1</a></li>'; $paginacao .= '<li><a href="?page=noticias&pag=1">2</a></li>'; for ($i = $ultima_pag - (2 + (2 * $adjacentes)); $i <= $ultima_pag; $i++) { if ($i == $pag) { $paginacao .= '<li><a class="atual" href="?page=noticias&pag='.$i.'">'.$i.'</a></li>'; } else { $paginacao .= '<li><a href="?page=noticias&pag='.$i.'">'.$i.'</a></li>'; } } } } if( $prox <= $ultima_pag && $ultima_pag > 2 ) { $paginacao .= '<li><a href="?page=noticias&pag='.$prox.'"><i class="fa fa-arrow-right"></i></a></li>'; } ?> </TABLE> <DIV CLASS="tfoot nav navbar-nav"> <form action="/app/modules/news/delete_news.php" id="form-noticias" name="FORM-NOTICIAS" DATA-ACTION="delete-all"> <button class="btn btn-flat btn-danger navbar-left" id="submit-del-all" DISABLED type="submit"><I CLASS="fa fa-trash-o"></I> Excluir Ítens Selecionados</button> </form> </DIV> </DIV> <!--//.table-noticias--> <NAV> <UL CLASS="pagination"> <?php echo @$paginacao ?> </UL> </NAV> <!--//.pagination--> </DIV> </SECTION>