source: trunk/prototype/rest/news/NewsLastResource.php @ 6528

Revision 6528, 1.3 KB checked in by gustavo, 12 years ago (diff)

Ticket #2766 - Merge do branch das novas funcionalidaes para o trunk

  • Property svn:executable set to *
Line 
1<?php
2
3class NewsLastResource extends Resource{
4   
5    /**
6    * Busca os últimos 10 boletins em que o usuário tem acesso
7    *
8    * @license    http://www.gnu.org/copyleft/gpl.html GPL
9    * @author     Consórcio Expresso Livre - 4Linux (www.4linux.com.br) e Prognus Software Livre (www.prognus.com.br)
10    * @sponsor    Caixa EconÃŽmica Federal
11    * @author     Adriano Coutinho da Silva
12    * @return     Lista dos ultimos 10 boletins do usuário
13    * @access     public
14    **/
15    function GET($request){
16        $this->secured();
17
18        $news = Controller::service('PostgreSQL')->execResultSql( 'SELECT news_subject  as "subject" ,
19            news_content as "content" ,
20            news_date as "startTime",
21            news_end as "endTime",
22            news_id as "id"
23            FROM phpgw_news WHERE news_cat IN (1) AND news_begin <= '.time().' AND
24            news_end >= '.time().' ORDER BY news_date DESC limit 10');
25
26        if(isset($news) && count($news) > 0)
27            foreach($news as $key => &$value)
28                $value['subject'] = utf8_encode($value['subject']);
29
30        $response = new Response($request);
31        $response->code = Response::OK;
32        $response->addHeader('Content-type', 'aplication/json');
33
34        $response->body = json_encode(( is_array($news) && $news) ? $news : array());
35        return $response;
36    }
37}
38
39?>
Note: See TracBrowser for help on using the repository browser.