/**
* Returns a new CitaQuery object.
*
* @param string $modelAlias The alias of a model in the query
* @param CitaQuery|Criteria $criteria Optional Criteria to build the query from
*
* @return CitaQuery
*/
public static function create($modelAlias = null, $criteria = null)
{
if ($criteria instanceof CitaQuery) {
return $criteria;
}
$query = new CitaQuery(null, null, $modelAlias);
if ($criteria instanceof Criteria) {
$query->mergeWith($criteria);
}
return $query;
}
public function nuevoAction()
{
$request = $this->getRequest();
if ($request->isPost()) {
$post_data = $request->getPost();
$cita_hora = date("H:i", strtotime($post_data['cita_hora']));
$cita = new \Cita();
$cita->setIdpaciente($post_data['idpaciente'])->setCitaFecha($post_data['cita_fecha_submit'])->setCitaHora($cita_hora)->setCitaDescripcion($post_data['cita_descripcion']);
if (!empty($post_data['idmedico'])) {
$cita->setIdmedico($post_data['idmedico']);
$citasCollection = \CitaQuery::create()->filterByIdmedico($post_data['idmedico'])->filterByCitaFecha($post_data['cita_fecha_submit'])->find();
$disponibilidad = true;
foreach ($citasCollection as $citaEntity) {
$time = strtotime($citaEntity->getCitaHora());
$endTime = date("H:i", strtotime('+10 minutes', $time));
if (strtotime($cita_hora) >= $time && strtotime($cita_hora) <= strtotime('+10 minutes', $time)) {
$disponibilidad = false;
}
}
if (!$disponibilidad) {
//Agregamos un mensaje
$medico = \MedicoQuery::create()->findPk($post_data['idmedico']);
$this->flashMessenger()->addMessage('Los sentimos, pero el medico ' . $medico->getMedicoNombre() . ' ' . $medico->getMedicoApellidopaterno() . ' ' . $medico->getMedicoApellidomaterno() . ' no tiene disponibilidad para la fecha y hora seleccionada');
return $this->redirect()->toUrl('/pacientes/agendarcita/nuevo/' . $post_data['idpaciente']);
} else {
$cita->save();
//Agregamos un mensaje
$this->flashMessenger()->addMessage('Cita Agendada exitosamente!');
//Redireccionamos a nuestro list
return $this->redirect()->toRoute('citas');
}
} else {
$cita->save();
//Agregamos un mensaje
$this->flashMessenger()->addMessage('Cita Agendada exitosamente!');
//Redireccionamos a nuestro list
return $this->redirect()->toRoute('citas');
}
}
//Cachamos el valor desde nuestro params
$id = (int) $this->params()->fromRoute('id');
$paciente = \PacienteQuery::create()->findPk($id)->toArray(\BasePeer::TYPE_FIELDNAME);
$medicos = \MedicoQuery::create()->find();
$medicos_array = array();
if (!empty($medicos)) {
foreach ($medicos as $medico) {
$idmedico = $medico->getIdmedico();
$medicos_array[$idmedico] = $medico->getMedicoNombre() . ' ' . $medico->getMedicoApellidopaterno() . ' ' . $medico->getMedicoApellidomaterno();
}
}
//Instanciamos nuestro fomrulario
$form = new CitasForm($medicos_array);
$form->get('idpaciente')->setValue($id);
$collection = \PacienteQuery::create()->find()->toArray(null, false, \BasePeer::TYPE_FIELDNAME);
return new ViewModel(array('paciente' => $paciente, 'form' => $form, 'flashMessages' => $this->flashMessenger()->getMessages()));
}
/**
* If this collection has already been initialized with
* an identical criteria, it returns the collection.
* Otherwise if this Paciente is new, it will return
* an empty collection; or if this Paciente has previously
* been saved, it will retrieve related Citas from storage.
*
* This method is protected by default in order to keep the public
* api reasonable. You can provide public methods for those you
* actually need in Paciente.
*
* @param Criteria $criteria optional Criteria object to narrow the query
* @param PropelPDO $con optional connection object
* @param string $join_behavior optional join type to use (defaults to Criteria::LEFT_JOIN)
* @return PropelObjectCollection|Cita[] List of Cita objects
*/
public function getCitasJoinMedico($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN)
{
$query = CitaQuery::create(null, $criteria);
$query->joinWith('Medico', $join_behavior);
return $this->getCitas($query, $con);
}
/**
* Removes this object from datastore and sets delete attribute.
*
* @param PropelPDO $con
* @return void
* @throws PropelException
* @throws Exception
* @see BaseObject::setDeleted()
* @see BaseObject::isDeleted()
*/
public function delete(PropelPDO $con = null)
{
if ($this->isDeleted()) {
throw new PropelException("This object has already been deleted.");
}
if ($con === null) {
$con = Propel::getConnection(CitaPeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
}
$con->beginTransaction();
try {
$deleteQuery = CitaQuery::create()->filterByPrimaryKey($this->getPrimaryKey());
$ret = $this->preDelete($con);
if ($ret) {
$deleteQuery->delete($con);
$this->postDelete($con);
$con->commit();
$this->setDeleted(true);
} else {
$con->commit();
}
} catch (Exception $e) {
$con->rollBack();
throw $e;
}
}
public function eliminarAction()
{
$request = $this->getRequest();
//Cachamos el valor desde nuestro params
$id = (int) $this->params()->fromRoute('id');
//Verificamos que el Id lugar que se quiere modificar exista
if (!\CitaQuery::create()->filterByIdcita($id)->exists()) {
$id = 0;
}
//Instanciamos nuestro lugar
$entity = \CitaQuery::create()->findPk($id);
$entity->delete();
//Agregamos un mensaje
$this->flashMessenger()->addMessage('Cita eliminada exitosamente!');
//Redireccionamos a nuestro list
return $this->redirect()->toRoute('citas');
}
