<?php //Objeto READ $read = new Read(); //VISITAS DO SITE $read->FullRead(null, "SELECT SUM(siteviews_views) AS views FROM ws_siteviews"); $Views = $read->getResult()[0]->views; //USUÁRIOS $read->FullRead(null, "SELECT SUM(siteviews_users) AS users FROM ws_siteviews"); $Users = $read->getResult()[0]->users; //MÉDIA DE PAGEVIEWS $read->FullRead(null, "SELECT SUM(siteviews_pages) AS pages FROM ws_siteviews"); $ResPages = $read->getResult()[0]->pages; $Pages = substr($ResPages / ($Users == 0 ? 1 : $Users), 0, 5); //POSTS $read->setTable("ws_posts"); $read->findAll(); $Posts = $read->getRowCount(); //EMPRESAS $read->setTable("app_empresas"); $read->findAll(); $Empresas = $read->getRowCount(); ?> <ul> <li class="view"><span><?php echo $Views; ?> </span> visitas</li> <li class="user"><span><?php echo $Users;
</li> <?php } ?> </ul> <div class="clear"></div> </section> <?php } ?> </div> <!--RELACIONADOS--> <?php $readMode = new Read(); $readMode->setTable("ws_posts"); $readMode->Query("WHERE post_status = 1 AND post_id != :post_id AND #post_category# ORDER BY rand() LIMIT 2", "post_id={$post_id}&post_category={$post_category}"); if ($readMode->getResult()) { $View = new View(); $tpl_m = $View->Load('article_m'); ?> <footer> <nav> <h3>Veja também:</h3> <?php foreach ($readMode->getResult() as $more) { $more->datetime = date('Y-m-d', strtotime($more->post_date)); $more->pubdate = date('d/m/Y H:i', strtotime($more->post_date)); $more->post_content = Check::Words($more->post_content, 20); $View->Show((array) $more, $tpl_m); }
$View = new View(); $tpl_g = $View->Load('article_g'); $tpl_m = $View->Load('article_m'); $tpl_p = $View->Load('article_p'); $tpl_empresa = $View->Load('empresa_p'); ?> <!--HOME SLIDER--> <section class="main-slider"> <h3>Últimas Atualizações:</h3> <div class="container"> <div class="slidecount"> <?php $cat = Check::CatByName('noticias'); $post = new Read(); $post->setTable('ws_posts'); $post->Query("WHERE post_status = 1 AND (post_cat_parent = :cat OR post_category = :cat) ORDER BY post_date DESC LIMIT :limit OFFSET :offset", "cat={$cat}&limit=3&offset=0"); if (!$post->getResult()) { WSErro('Desculpe, ainda não existem notícias cadastradas. Favor volte mais tarde!', WS_INFOR); } else { foreach ($post->getResult() as $slide) { $slide->post_title = Check::Words($slide->post_title, 12); $slide->post_content = Check::Words($slide->post_content, 38); $slide->datetime = date('Y-m-d', strtotime($slide->post_date)); $slide->pubdate = date('d/m/Y H:i', strtotime($slide->post_date)); $View->Show((array) $slide, $tpl_g); } } ?> </div>
<article class="ads"> <header> <h1>Anúncio Patrocinado:</h1> <a href="http://www.upinside.com.br/campus" title="Campus UpInside - Treinamentos em TI 100% em Vídeo aulas"> <img src="<?php echo INCLUDE_PATH; ?> /_tmp/banner_large.png" alt="UPINSIDE TEINAMENTOS" title="UPINSIDE TEINAMENTOS" /> </a> </header> </article> <section class="widget art-list last-publish"> <h2 class="line_title"><span class="oliva">Últimas Atualizações:</span></h2> <?php $side->setTable('ws_posts'); $side->Query("WHERE post_status = 1 AND post_id != :side ORDER BY post_date DESC LIMIT 3", "side={$post_id}"); if ($side->getResult()) { foreach ($side->getResult() as $last) { $last->datetime = date('Y-m-d', strtotime($last->post_date)); $last->pubdate = date('d/m/Y H:i', strtotime($last->post_date)); $View->Show((array) $last, $tpl_p); } } ?> </section> <section class="widget art-list most-view"> <h2 class="line_title"><span class="vermelho">Destaques:</span></h2> <?php $side->setTable('ws_posts');