<?php
    public static function getEvents( $param = NULL )
    {
        $return = array();
        
        try
        {
            TTransaction::open( MkSgc_BD );
            
            $events = TblAgenda::where('AGE_EMPRESA',  '=', TSession::getValue('ClienteId'))
                               ->where('AGE_DTIMEINI', '>=', $param['start'])
                               ->where('AGE_DTIMEFIM', '<=', $param['end'])->load();
            if ( $events )
            {
                foreach ( $events as $event )
                {
                    $event_array['id']     = $event->AGE_ID;
                    $event_array['title']  = $event->AGE_TITULO;
                    $event_array['start']  = str_replace( ' ', 'T', $event->AGE_DTIMEINI );
                    $event_array['end']    = str_replace( ' ', 'T', $event->AGE_DTIMEFIM );
                    $event_array['color']  = $event->AGE_COR;
                    $event_array['obj']  = (object) [ 'TITULO' => $event->AGE_TITULO, 
                                                      'DTINI'  => TDate::date2br( $event->AGE_DTIMEINI ),
                                                      'DTFIM'  => TDate::date2br( $event->AGE_DTIMEFIM ),
                                                      'OBSERV' => $event->AGE_OBSERV ];
                    $return[] = $event_array;
                }
            }
            
            TTransaction::close();
            
            echo json_encode( $return );
        }
        catch ( Exception $e )
        {
            new TMessage( 'error', $e->getMessage());
        }
    }
?>