TFullCalendar não carrega os eventos do banco de dados

TFullCalendar não carrega os eventos do banco de dados Pessoal, alguém já está utilizando o novo componete TFullCalendar? Estou tentando utiliza-lo, porém, quando tento carregar os eventos do banco, seguindo o exemplo do tutor, utilizando a função setReloadAction, não consigo ter os eventos carregados. Fuçando o exemplo do tutor, percebi que se faço uma chamada à função var_dump, por exemplo, dentro da função setReloadAction, o TFullC...

Romero Rolim 17/01/2017 (há 7 anos)

Pessoal, alguém já está utilizando o novo componete TFullCalendar?
Estou tentando utiliza-lo, porém, quando tento carregar os eventos do banco, seguindo o exemplo do tutor, utilizando a função setReloadAction, não consigo ter os eventos carregados.
Fuçando o exemplo do tutor, percebi que se faço uma chamada à função var_dump, por exemplo, dentro da função setReloadAction, o TFullCalendar deixa de carregar os eventos.
No meu caso, estou criando uma tela de marcação de consultas onde o usuário seleciona um médico e paciente de um TSeek e abaixo o TFullCalendar deverá carregar os eventos(consultas) para o dia em questão.
Alguém poderia me dar uma força ?
Desde já, grato.

Curso completo Meu Negócio Pronto

Use para si, ou transforme em um negócio: Inclui aulas e códigos-fontes
Gestor de conteúdo (SITE) + Loja Virtual (E-Commerce) + Emissor de Notas para infoprodutos

Meu negócio pronto Quero me inscrever agora!

Comentários (5)

Nataniel Rabaioli 18/01/2017 (há 7 anos)

Romero, se conseguir postar o código fica mais fácil para analisarmos.

Romero Rolim - AUTOR DO POST 18/01/2017 (há 7 anos)

Ok Nataniel!

Segue o código da página que utiliza o TFullCalendar:

<?php
class Marcacao extends TPage
{
private $fc;
private $form;
public function __construct()
{
parent::__construct();
$this->form = new TQuickForm('marcacao');
$this->form->class = 'tform';
$medico_id = new ">TDBSeekButton('medico_id', 'cmr', 'marcacao', 'Medico', 'nome', 'medico_id', 'medico_nome');
$medicoExitAction = new TAction(array($this, 'onMedicoExitAction'));
$medico_id->setExitAction($medicoExitAction);
$medico_nome = new TEntry('medico_nome');
$paciente_id = new ">TDBSeekButton('paciente_id', 'cmr', 'marcacao', 'Paciente', 'nome', 'paciente_id', 'paciente_nome');
$pacienteExitAction = new TAction(array($this, 'onPacienteExitAction'));
$paciente_id->setExitAction($pacienteExitAction);
$paciente_nome = new TEntry('paciente_nome');
$medico_id->setSize(50);
$medico_nome->setEditable(FALSE);
$paciente_id->setSize(50);
$paciente_nome->setEditable(FALSE);
$this->form->addQuickFields('Médico', array($medico_id, $medico_nome));
$this->form->addQuickFields('Paciente', array($paciente_id, $paciente_nome));
$this->fc = new TFullCalendar(date('Y-m-d'), 'month');
//$this->fc->setTimeRange( '08:00:00', '17:00:00' );
$return = array();
try
{
TTransaction::open('cmr');
$events = Agenda::where('medico_id', '=', 1)->load(); //$param['medico_id'])->load();
if ($events)
{
//print_r($events);
foreach ($events as $event)
{
$event_array = $event->toArray();
$event_array['start'] = str_replace( ' ', 'T', $event_array['start_time']);
$event_array['end'] = str_replace( ' ', 'T', $event_array['end_time']);
$this->fc->addEvent($event_array['medico_id'], $event_array['title'], $event_array['start'], $event_array['end'], null, $event_array['color']);
$return[] = $event_array;
}
}
TTransaction::close();
//echo json_encode($return);
}
catch (Exception $e)
{
new TMessage('error', $e->getMessage());
}
$before_yesterday = (new DateTime(date('Y-m-d')))->sub(new DateInterval("P2D"))->format('Y-m-d');
$this->fc->addEvent(10, 'Event 1', $before_yesterday.'T08:30:00', $before_yesterday.'T12:30:00', null, '#C04747');
//$this->fc->setReloadAction(new TAction(array($this, 'getEvents')));
$this->fc->setDayClickAction(new TAction(array('AgendaForm', 'onStartEdit')));
$this->fc->setEventClickAction(new TAction(array('AgendaForm', 'onEdit')));
$this->fc->setEventUpdateAction(new TAction(array('AgendaForm', 'onUpdateEvent')));
$vbox = new TVBox;
$vbox->add(new TXMLBreadCrumb('menu.xml', __CLASS__));
$vbox->add($this->form);
$vbox->add($this->fc);
parent::add( $vbox );
}
public static function onMedicoExitAction( $param )
{
Marcacao::getEvents($param);
//$param['view'] = 'month';
//TApplication::executeMethod('Marcacao', 'onReload', $param);
}
public static function onPacienteExitAction( $param )
{
TSession::setValue('medicoId', $param['medico_id']);
TSession::setValue('medicoNome', $param['medico_nome']);
TSession::setValue('pacienteId', $param['paciente_id']);
TSession::setValue('pacienteNome', $param['paciente_nome']);
}
/**
* Output events as an json
*/
public static function getEvents($param=NULL)
{
$return = array();
try
{
TTransaction::open('cmr');
$events = Agenda::where('medico_id', '=', $param['medico_id'])->load();
if ($events)
{
foreach ($events as $event)
{
$event_array = $event->toArray();
$event_array['start'] = str_replace( ' ', 'T', $event_array['start_time']);
$event_array['end'] = str_replace( ' ', 'T', $event_array['end_time']);
$return[] = $event_array;
}
}
TTransaction::close();
echo json_encode($return);
}
catch (Exception $e)
{
new TMessage('error', $e->getMessage());
}
}
/**
* Reconfigure the callendar
*/
public function onReload($param = null)
{
if (isset($param['view']))
{
$this->fc->setCurrentView($param['view']);
}
if (isset($param['date']))
{
$this->fc->setCurrentDate($param['date']);
}
}
}
?>

Romero Rolim - AUTOR DO POST 18/01/2017 (há 7 anos)

Este é o código do AgendaForm(tentando seguir o exemplo do Tutor):

<?php
class AgendaForm extends TWindow
{
protected $form; // form
/**
* Class constructor
* Creates the page and the registration form
*/
public function __construct()
{
parent::__construct();
parent::setSize(640, null);
parent::setTitle('Agenda');
// creates the form
$this->form = new TForm('form_event');
$this->form->class = 'tform'; // CSS class
$this->form->style = 'width: 600px';
// add a table inside form
$table = new TTable;
$table-> width = '100%';
$this->form->add($table);
// add a row for the form title
$row = $table->addRow();
$row->class = 'tformtitle'; // CSS class
$row->addCell( new TLabel('Nova Consulta') )->colspan = 2;
$hours = array();
$minutes = array();
for ($n=0; $n<24; $n++)
{
$hours[$n] = str_pad($n, 2, '0', STR_PAD_LEFT);
}
for ($n=0; $n<=55; $n+=5)
{
$minutes[$n] = str_pad($n, 2, '0', STR_PAD_LEFT);
}
// create the form fields
$view = new THidden('view');
$id = new TEntry('id');
$medico_id = new THidden('medico_id');
$medico_nome = new TEntry('medico_nome');
$paciente_id = new THidden('paciente_id');
$color = new TColor('color');
$start_date = new TDate('start_date');
$start_hour = new TCombo('start_hour');
$start_minute = new TCombo('start_minute');
$end_date = new TDate('end_date');
$end_hour = new TCombo('end_hour');
$end_minute = new TCombo('end_minute');
$title = new TEntry('title');
$description = new TText('description');
$color->setValue('#3a87ad');
$start_hour->addItems($hours);
$start_minute->addItems($minutes);
$end_hour->addItems($hours);
$end_minute->addItems($minutes);
$id->setEditable(FALSE);
// define the sizes
$id->setSize(40);
$medico_nome->setSize(400);
$medico_nome->setEditable(FALSE);
$title->setSize(400);
$title->setEditable(FALSE);
$color->setSize(100);
$start_date->setSize(100);
$end_date->setSize(100);
$start_hour->setSize(50);
$end_hour->setSize(50);
$start_minute->setSize(50);
$end_minute->setSize(50);
$description->setSize(400, 50);
$start_hour->setChangeAction(new TAction(array($this, 'onChangeStartHour')));
$end_hour->setChangeAction(new TAction(array($this, 'onChangeEndHour')));
$start_date->setExitAction(new TAction(array($this, 'onChangeStartDate')));
$end_date->setExitAction(new TAction(array($this, 'onChangeEndDate')));
// add one row for each form field
$table->addRowSet( $view );
$table->addRowSet( new TLabel('ID:'), $id );
$table->addRowSet( new TLabel('Médico'), $medico_nome);
$table->addRowSet( new TLabel('Paciente:'), $title );
$table->addRowSet( new TLabel('Color:'), $color );
$table->addRowSet( new TLabel('Start time:'), array($start_date, $start_hour, ':', $start_minute) );
$table->addRowSet( new TLabel('End time:'), array($end_date, $end_hour, ':', $end_minute));
$table->addRowSet( new TLabel('Observação:'), $description );
// create an action button (save)
$save_button=new TButton('save');
$save_button->setAction(new TAction(array($this, 'onSave')), _t('Save'));
$save_button->setImage('fa:save green');
// create an new button (edit with no parameters)
$new_button=new TButton('new');
$new_button->setAction(new TAction(array($this, 'onEdit')), _t('Clear'));
$new_button->setImage('fa:eraser orange');
// create an del button (edit with no parameters)
$del_button=new TButton('del');
$del_button->setAction(new TAction(array($this, 'onDelete')), _t('Delete'));
$del_button->setImage('fa:trash-o red');
$this->form->setFields(array($id, $medico_id, $medico_nome, $paciente_id, $view, $color, $title, $description, $start_date, $start_hour, $start_minute, $end_date, $end_hour, $end_minute, $save_button,$new_button,$del_button));
$buttons_box = new THBox;
$buttons_box->add($save_button);
$buttons_box->add($new_button);
$buttons_box->add($del_button);
// add a row for the form action
$row = $table->addRow();
$row->class = 'tformaction'; // CSS class
$row->addCell($buttons_box)->colspan = 2;
parent::add($this->form);
}
/**
* Executed when user leaves start hour field
*/
public static function onChangeStartHour($param=NULL)
{
$obj = new stdClass;
if (empty($param['start_minute']))
{
$obj->start_minute = '0';
TForm::sendData('form_event', $obj);
}
if (empty($param['end_hour']) AND empty($param['end_minute']))
{
$obj->end_hour = $param['start_hour'] +1;
$obj->end_minute = '0';
TForm::sendData('form_event', $obj);
}
}
/**
* Executed when user leaves end hour field
*/
public static function onChangeEndHour($param=NULL)
{
if (empty($param['end_minute']))
{
$obj = new stdClass;
$obj->end_minute = '0';
TForm::sendData('form_event', $obj);
}
}
/**
* Executed when user leaves start date field
*/
public static function onChangeStartDate($param=NULL)
{
if (empty($param['end_date']) AND !empty($param['start_date']))
{
$obj = new stdClass;
$obj->end_date = $param['start_date'];
TForm::sendData('form_event', $obj);
}
}
/**
* Executed when user leaves end date field
*/
public static function onChangeEndDate($param=NULL)
{
if (empty($param['end_hour']) AND empty($param['end_minute']) AND !empty($param['start_hour']))
{
$obj = new stdClass;
$obj->end_hour = min($param['start_hour'],22) +1;
$obj->end_minute = '0';
TForm::sendData('form_event', $obj);
}
}
/**
* method onSave()
* Executed whenever the user clicks at the save button
*/
public function onSave()
{
$medicoId = TSession::getValue('medicoId');
$medicoNome = TSession::getValue('medicoNome');
$pacienteId = TSession::getValue('pacienteId');
$pacienteNome = TSession::getValue('pacienteNome');
try
{
// open a transaction with database 'samples'
TTransaction::open('cmr');
$this->form->validate(); // form validation
// get the form data into an active record Entry
$data = $this->form->getData();
$data->medico_id = $medicoId;
$data->medico_nome = $medicoNome;
$data->paciente_id = $pacienteId;
$data->title = $pacienteNome;
$object = new Agenda;
$object->id = $data->id;
$object->medico_id = $data->medico_id;
$object->paciente_id = $data->paciente_id;
$object->title = $data->title;
$object->color = $data->color;
$object->nota = $data->description;
$object->start_time = $data->start_date . ' ' . str_pad($data->start_hour, 2, '0', STR_PAD_LEFT) . ':' . str_pad($data->start_minute, 2, '0', STR_PAD_LEFT) . ':00';
$object->end_time = $data->end_date . ' ' . str_pad($data->end_hour, 2, '0', STR_PAD_LEFT) . ':' . str_pad($data->end_minute, 2, '0', STR_PAD_LEFT) . ':00';
$object->store(); // stores the object
$data->id = $object->id;
$this->form->setData($data); // keep form data
TTransaction::close(); // close the transaction
$posAction = new TAction(array('Marcacao', 'onReload'));
$posAction->setParameter('view', $data->view);
$posAction->setParameter('date', $data->start_date);
// shows the success message
new TMessage('info', TAdiantiCoreTranslator::translate('Record saved'), $posAction);
}
catch (Exception $e) // in case of exception
{
// shows the exception error message
new TMessage('error', $e->getMessage());
$this->form->setData( $this->form->getData() ); // keep form data
// undo all pending operations
TTransaction::rollback();
}
}
/**
* method onEdit()
* Executed whenever the user clicks at the edit button da datagrid
*/
public function onEdit($param)
{
try
{
if (isset($param['key']))
{
// get the parameter $key
$key=$param['key'];
// open a transaction with database 'samples'
TTransaction::open('cmr');
// instantiates object CalendarEvent
$object = new Agenda($key);
$data = new stdClass;
$data->id = $object->id;
$data->medico_id = $object->medico_id;
$data->paciente_id = $object->paciente_id;
$data->title = $object->title;
$data->color = $object->color;
$data->description = $object->nota;
$data->start_date = substr($object->start_time,0,10);
$data->start_hour = substr($object->start_time,11,2);
$data->start_minute = substr($object->start_time,14,2);
$data->end_date = substr($object->end_time,0,10);
$data->end_hour = substr($object->end_time,11,2);
$data->end_minute = substr($object->end_time,14,2);
$data->view = $param['view'];
// fill the form with the active record data
$this->form->setData($data);
// close the transaction
TTransaction::close();
}
else
{
$this->form->clear();
}
}
catch (Exception $e) // in case of exception
{
// shows the exception error message
new TMessage('error', $e->getMessage());
// undo all pending operations
TTransaction::rollback();
}
}
/**
* Delete event
*/
public static function onDelete($param)
{
// define the delete action
$action = new TAction(array('AgendaForm', 'Delete'));
$action->setParameters($param); // pass the key parameter ahead
// shows a dialog to the user
new TQuestion(AdiantiCoreTranslator::translate('Do you really want to delete ?'), $action);
}
/**
* Delete a record
*/
public static function Delete($param)
{
try
{
// get the parameter $key
$key = $param['id'];
// open a transaction with database
TTransaction::open('cmr');
// instantiates object
$object = new CalendarEvent($key, FALSE);
// deletes the object from the database
$object->delete();
// close the transaction
TTransaction::close();
$posAction = new TAction(array('Marcacao', 'onReload'));
$posAction->setParameter('view', $param['view']);
$posAction->setParameter('date', $param['start_date']);
// shows the success message
new TMessage('info', AdiantiCoreTranslator::translate('Record deleted'), $posAction);
}
catch (Exception $e) // in case of exception
{
// shows the exception error message
new TMessage('error', $e->getMessage());
// undo all pending operations
TTransaction::rollback();
}
}
/**
* Fill form from the user selected time
*/
public function onStartEdit($param)
{
$medicoId = TSession::getValue('medicoId');
$medicoNome = TSession::getValue('medicoNome');
$pacienteId = TSession::getValue('pacienteId');
$pacienteNome = TSession::getValue('pacienteNome');
if (!empty($medicoId) && !empty($pacienteId))
{
$this->form->clear();
$data = new stdClass;
$data->view = $param['view']; // calendar view
$data->color = '#3a87ad';
$data->medico_id = $medicoId;
$data->medico_nome = $medicoNome;
$data->paciente_id = $pacienteId;
$data->title = $pacienteNome;
if ($param['date'])
{
if (strlen($param['date']) == 10)
{
$data->start_date = $param['date'];
$data->end_date = $param['date'];
}
if (strlen($param['date']) == 19)
{
$data->start_date = substr($param['date'],0,10);
$data->start_hour = substr($param['date'],11,2);
$data->start_minute = substr($param['date'],14,2);
$data->end_date = substr($param['date'],0,10);
$data->end_hour = substr($param['date'],11,2) +1;
$data->end_minute = substr($param['date'],14,2);
}
}
$this->form->setData( $data );
}
}
/**
* Update event. Result of the drag and drop or resize.
*/
public static function onUpdateEvent($param)
{
$medicoId = TSession::getValue('medicoId');
$medicoNome = TSession::getValue('medicoNome');
$pacienteId = TSession::getValue('pacienteId');
$pacienteNome = TSession::getValue('pacienteNome');
try
{
if (isset($param['id']))
{
// get the parameter $key
$key=$param['id'];
// open a transaction with database 'samples'
TTransaction::open('cmr');
// instantiates object CalendarEvent
$object = new Agenda($key);
$object->start_time = str_replace('T', ' ', $param['start_time']);
$object->end_time = str_replace('T', ' ', $param['end_time']);
$object->store();
// close the transaction
TTransaction::close();
}
}
catch (Exception $e) // in case of exception
{
new TMessage('error', '<b>Error</b> ' . $e->getMessage());
TTransaction::rollback();
}
}
}
?>

Romero Rolim - AUTOR DO POST 18/01/2017 (há 7 anos)

E, finalmente, o código do Modelo Agenda:

<?php
/**
* Agenda Active Record
* @author <your-name-here>
*/
class Agenda extends TRecord
{
const TABLENAME = 'public.agenda';
const PRIMARYKEY= 'id';
const IDPOLICY = 'serial'; // {max, serial}
/**
* Constructor method
*/
public function __construct($id = NULL, $callObjectLoad = TRUE)
{
parent::__construct($id, $callObjectLoad);
parent::addAttribute('medico_id');
parent::addAttribute('paciente_id');
parent::addAttribute('start_time');
parent::addAttribute('end_time');
parent::addAttribute('title');
parent::addAttribute('nota');
parent::addAttribute('color');
}
}
?>

Nataniel Rabaioli 19/01/2017 (há 7 anos)

Por exemplo, se quiser atualizar o calendário após a escolha do médico:

<?php
public static function onMedicoExitAction( $param )
{
TApplication::postData('marcacao',__CLASS__,'onReload');
}
// necessario preencher o form na funcao onReload
public function onReload($param = null)
{
$this->form->setData($this->form->getData());
...
}
?>

Novo Comentário