public function calendarioAction()
{
//Conectamos con BBDD
$sid = new Container('base');
$db_name = $sid->offsetGet('dbNombre');
$this->dbAdapter = $this->getServiceLocator()->get($db_name);
//Instancias
$part = new PartidaMantTable($this->dbAdapter);
//Consultamos Partidas
$partidas = $part->getPartidas();
//Retornamos a la vista
$this->layout('layout/comite');
$result = new ViewModel(array('partidas' => $partidas));
//$result->setTerminal(true);
return $result;
}
public function resumenfinAction()
{
//Conectamos con BBDD
$sid = new Container('base');
$db_name = $sid->offsetGet('dbNombre');
$this->dbAdapter = $this->getServiceLocator()->get($db_name);
//Abrimos Instancias
$fon = new FondosTable($this->dbAdapter);
$mor = new MorososTable($this->dbAdapter);
$ing = new IngresoTable($this->dbAdapter);
$egr = new EgresoTable($this->dbAdapter);
$cic = new CicloAdminTable($this->dbAdapter);
$pmt = new PartidaMantTable($this->dbAdapter);
//Obtenemos dia de cierre y calculamos restantes
$cierre = $cic->getCiclo();
if (date('j') > $cierre[0]['dia']) {
$dias_mes = cal_days_in_month(CAL_GREGORIAN, date('n'), date('Y'));
$dif = $dias_mes - date('j') + $cierre[0]['dia'];
$mes_cierre = date('F', strtotime('+1 month'));
} else {
$dif = $cierre[0]['dia'] - date('j');
$mes_cierre = date('F');
}
//Obtenemos datos
$fondo = $fon->getFondoOper();
$fondores = $fon->getFondoRes();
$cchica = $fon->getCajaChica();
$morosos = $mor->getTotal($this->dbAdapter);
$egresos = $egr->getEgresosPeriodo($this->dbAdapter);
$egrpend = $egr->getEgresosPendiente($this->dbAdapter);
$ingresos = $ing->getIngresosPeriodo($this->dbAdapter);
$mant = $pmt->getPartidasMes(date('M'));
//Armamos Array para la vista
$datos = array('fondo' => $fondo[0]['saldo'], 'fondores' => $fondores[0]['saldo'], 'cajachica' => $cchica[0]['saldo'], 'morosos' => $morosos[0]['total'], 'egresos' => $egresos, 'ingresos' => $ingresos, 'dias_restantes' => $dif, 'pagos_pendientes' => $egrpend[0]['pagos'], 'mant_periodo' => count($mant));
$result = new ViewModel($datos);
$result->setTerminal(true);
return $result;
}
public function guardarpartidaAction()
{
//Conectamos con BBDD
$sid = new Container('base');
$db_name = $sid->offsetGet('dbNombre');
$this->dbAdapter = $this->getServiceLocator()->get($db_name);
//Instancias
$part = new PartidaMantTable($this->dbAdapter);
//Obtenemos datos POST
$lista = $this->request->getPost();
//Validamos post
if (isset($lista['categoria'])) {
//Retornamos formulario a la vista
$result = new ViewModel(array('categoria' => $categoria, 'rsptaOK' => SysFnc::rspOK()));
$result->setTerminal(true);
return $result;
} else {
//Guardamos partida
$partida = $part->guardarPartida($lista);
}
//Retornamos a la vista
$descripcion = "Cambios guardados exitosamente...";
$result = new JsonModel(array('status' => 'ok', 'descripcion' => $descripcion));
return $result;
}