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
*
|
Rev | Line | |
---|
[6351] | 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.