public function getList($entidad, $Filtro = "")
{
if ($Filtro != "") {
$Filtro = " WHERE " . $Filtro;
}
$recordset = parent::queryArray("Select * from {$entidad} {$Filtro}");
return $recordset;
}
public function listAll($Filter = "")
{
if ($Filter != "") {
$Filter = " WHERE " . $Filtro;
}
$recordset = parent::queryArray("SELECT * FROM paquete {$Filter}");
return $recordset;
}
public function listPagosDelMes($iniDate, $finDate)
{
$SQLCommand = "\n SELECT \n o.idpago, o.idpersona, o.idpaquete, o.fecha, o.monto,\n e.nombre, e.apaterno, e.amaterno, e.fechainscripcion, e.montoinscripcion\n FROM pago\to\n INNER JOIN persona e ON (o.idpersona = e.idpersona)\n WHERE o.fecha >= '{$iniDate}'\n AND o.fecha <= '{$finDate}'\n ORDER BY o.fecha DESC";
$recordset = parent::queryArray($SQLCommand);
return $recordset;
}
public function listInscritosEnMes($iniDate, $finDate)
{
$SQLCommand = "\n SELECT\n idpersona, nombre, apaterno, amaterno, direccion, telefono, email, contacto, \n contactotelefono, fecharegistro, fechainscripcion, montoinscripcion, \n inscrito, activo\n FROM persona\n WHERE fechainscripcion >= '{$iniDate}'\n AND fechainscripcion <= '{$finDate}'\n ORDER BY fechainscripcion DESC";
$recordset = parent::queryArray($SQLCommand);
return $recordset;
}