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 |
|
---|
3 | class 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.