Hola a todos. Encontre en la carpeta API de Canaima Report, unos ejemplos de como exportar por medio de php los reportes que haga en Agata report.
mi codigo es el siguiente:
Código PHP:
<?
#+-----------------------------------------------------------------+
#| AGATA Report API |
#| Copyleft (l) 2004 Solis - Lajeado - RS - Brasil |
#| Licensed under GPL: |
#+-----------------------------------------------------------------+
#| Started in 2001, August, 10 |
#| Author: Pablo Dall'Oglio ([email protected]) |
#+-----------------------------------------------------------------+
#| Agata Report: A Database reporting tool written in PHP-GTK |
#| This file shows how to use AgataAPI to generate simple reports |
#+-----------------------------------------------------------------+
# Include AgataAPI class
include_once '/var/www/vhosts/tallerlacuchilla.com/httpdocs/AGATA/classes/core/AgataAPI.class';
# Instantiate AgataAPI
$api = new AgataAPI;
$api->setLanguage('es'); //'en', 'pt', 'es', 'de', 'fr', 'it', 'se'
$api->setReportPath('/var/www/vhosts/tallerlacuchilla.com/httpdocs/AGATA/reports/samples/customers.agt');
$api->setProject('samples');
$api->setFormat('pdf'); // 'pdf', 'txt', 'xml', 'html', 'csv', 'sxw'
$api->setOutputPath('/tmp/test.pdf');
$api->setLayout('default-PDF');
#var_dump($api->GetParameters());
#How to set parameters, if they exist
#$api->setParameter('$personCode', 4);
#$api->setParameter('$personName', "'mary'");
$ok = $api->generateReport();
if (!$ok)
{
echo $api->getError();
}
else
{
// opens file dialog
$api->fileDialog();
}
?> Mas que nada quiero hacer una prueba en el servidor donde voy a manejar los reportes... pero al momento de accesar a la pagina me aparece esto:
Código PHP:
Notice: Undefined property: AgataAPI::$Report in /var/www/vhosts/tallerlacuchilla.com/docs/AGATA/classes/core/AgataAPI.class on line 106
Notice: Undefined property: AgataAPI::$parameters in /var/www/vhosts/tallerlacuchilla.com/httpdocs/AGATA/classes/core/AgataAPI.class on line 329
Notice: Undefined property: AgataAPI::$parameters in /var/www/vhosts/tallerlacuchilla.com/httpdocs/AGATA/classes/core/AgataAPI.class on line 350
Notice: Undefined index: GroupBy in /var/www/vhosts/tallerlacuchilla.com/httpdocs/AGATA/classes/core/CoreReport.class on line 145
Notice: Undefined index: Distinct in /var/www/vhosts/tallerlacuchilla.com/httpdocs/AGATA/classes/core/CoreReport.class on line 134
Notice: Undefined variable: labels in /var/www/vhosts/tallerlacuchilla.com/httpdocs/AGATA/classes/util/MemoArea.class on line 53
Notice: Undefined variable: labels in /var/www/vhosts/tallerlacuchilla.com/httpdocs/AGATA/classes/util/MemoArea.class on line 59
Mensaje:
Error de la consulta: Select customer.code as "Customer Code", customer.name as "Customer Name", customer.phone as "Customer Phone", customer.address as "Customer Address", customer.age as "Customer Age", customer.photo as "Customer Photo", customer.ref_city as "Customer City Code", city.description as "City Description", state.code as "State Code", state.description as "State Description" From customer, city, state Where city.ref_state = state.code and customer.ref_city = city.code and city.code =$city Order by customer.name asc;
Error de Consulta...? me parece bien extranio por que esos son los reportes de prueba (y subi una base de datos de prueba y eso) y me hace ese problema con cualquier reporte que ponga.
Que puede ser :(? Estoy usando php 5.2.6, y es el Canaima Report, una version actualizada del agata report que segun esto puede manejarse ya con versiones mas actuales de PHP
Muchas gracias.