virtual void run() {
// Create a report
KDReports::Report report;
report.setWatermarkImage( QImage( ":/background.jpg" ) );
report.setWatermarkText( QString() );
KDReports::ImageElement imageElement(QImage(":/logo.png"));
report.header().addElement(imageElement);
// Add a text element for the title
KDReports::TextElement titleElement( QObject::tr( "KD Reports Hello world example" ) );
titleElement.setPointSize( 18 );
report.addElement( titleElement, Qt::AlignHCenter );
// A bit of spacing (10 mm)
report.addVerticalSpacing( 10 );
// Add another text element, demonstrating "<<" operator
KDReports::TextElement textElement;
textElement << QObject::tr( "This is a sample report produced with KD Reports." );
textElement << "\n";
textElement << QObject::tr( "Klarälvdalens Datakonsult AB, Platform-independent software solutions" );
textElement << "\n";
report.addElement( textElement );
// Create a table model, which will be used by the table element
HelloWorldTableModel tableModel;
// A bit of spacing (10 mm)
report.addVerticalSpacing( 10 );
// Add an "auto table" (a table that shows the contents of a model)
KDReports::AutoTableElement tableElement( &tableModel );
tableElement.setBorder( 1 );
report.addElement( tableElement );
// Add many paragraphs, to demonstrate page breaking
for ( int i = 1; i < 100 ; ++i ) {
report.addElement( KDReports::HtmlElement( QString::fromLatin1( "<b>Customer</b> <em>%1</em>" ).arg(i) ), Qt::AlignLeft );
report.addInlineElement( KDReports::TextElement( " - 2006" ) );
}
// Add a page break
report.addPageBreak();
report.addElement( KDReports::TextElement( "This is the last page" ) );
// To export to an image file:
//qDebug() << "Exporting to output.png";
report.exportToImage( QSize(200, 1200), "output.png", "PNG" ); // deleted by main() below
// To export to a PDF file:
//qDebug() << "Exporting to output.pdf";
report.exportToFile( "output.pdf" ); // deleted by main() below
}
int main( int argc, char** argv ) {
QApplication app( argc, argv );
KDReports::Report report;
// open a DB connection to an in-memory database
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(":memory:");
if( !db.open() ) {
QMessageBox::critical(0, QObject::tr("Cannot open database"),
QObject::tr("Cannot create connection to the requested database. Your Qt is probably lacking the QSQLITE driver. Please check your Qt installation." ), QMessageBox::Cancel );
return false;
}
// fill the DB with some test data
QSqlQuery query;
query.exec("create table airlines (id int primary key, "
"name varchar(20), homecountry varchar(2))");
query.exec("insert into airlines values(1, 'Lufthansa', 'DE')");
query.exec("insert into airlines values(2, 'SAS', 'SE')");
query.exec("insert into airlines values(3, 'United', 'US')");
query.exec("insert into airlines values(4, 'KLM', 'NL')");
query.exec("insert into airlines values(5, 'Aeroflot', 'RU')");
// Create a QSqlTableModel, connect to the previously created database, fill
// the db with some data.
QSqlTableModel tableModel( 0, db );
tableModel.setTable( "airlines" );
tableModel.select();
tableModel.removeColumn( 0 );
tableModel.setHeaderData(0, Qt::Horizontal, QObject::tr("Name"));
tableModel.setHeaderData(1, Qt::Horizontal, QObject::tr("Home country"));
QFont font = app.font();
font.setBold( true );
tableModel.setHeaderData( 0, Qt::Horizontal, font, Qt::FontRole );
tableModel.setHeaderData( 1, Qt::Horizontal, font, Qt::FontRole );
KDReports::AutoTableElement tableElement( &tableModel );
tableElement.setVerticalHeaderVisible( false );
report.addElement( tableElement );
// To export to an image file:
//qDebug() << "Exporting to output.png";
//report.exportToImage( QSize(300, 400), "output.png", "PNG" );
KDReports::PreviewDialog preview( &report );
return preview.exec();
}
bool KDReports::XmlParser::processNode( const QDomNode& node, KDReports::ReportBuilder* builder, bool inHeader, bool inFooter )
{
// Loop over elements
for ( QDomElement element = node.firstChildElement() ; !element.isNull();
element = element.nextSiblingElement() ) {
if ( testForErrorAndFillErrorDetails() )
return false;
const QString name = element.tagName();
if( name == QLatin1String( "text" ) ) {
// Handle <text> element
KDReports::TextElement textElement;
QString id;
const QString text = extractText( element, &id, m_report->d->m_currentModel, m_report->d->m_currentRow );
textElement.setText( text );
textElement.setId( id );
const QColor bgColor = KDReports::XmlHelper::readBackground( element );
if( bgColor.isValid() )
textElement.setBackground( bgColor );
if( element.hasAttribute( QLatin1String( "pointsize" ) ) ) {
const int pointSize = element.attribute( QLatin1String( "pointsize" ) ).toInt();
if( pointSize )
textElement.setPointSize( pointSize );
}
if( element.hasAttribute( QLatin1String( "color" ) ) ) {
const QString name = element.attribute( QLatin1String( "color" ) );
textElement.setTextColor( QColor( name ) );
}
if( element.hasAttribute( QLatin1String( "font" ) ) ) {
textElement.setFontFamily( element.attribute( QLatin1String( "font" ) ) );
}
if( element.hasAttribute( QLatin1String( "bold" ) ) ) {
bool bold = false;
if( element.attribute( QLatin1String( "bold" ) ) == QLatin1String( "true" ) )
bold = true;
textElement.setBold( bold );
}
if( element.hasAttribute( QLatin1String( "italic" ) ) ) {
bool italic = false;
if( element.attribute( QLatin1String( "italic" ) ) == QLatin1String( "true" ) )
italic = true;
textElement.setItalic( italic );
}
if( element.hasAttribute( QLatin1String( "strikeout" ) ) ) {
bool strikeOut = false;
if( element.attribute( QLatin1String( "strikeout" ) ) == QLatin1String( "true" ) )
strikeOut = true;
textElement.setStrikeOut( strikeOut );
}
if( element.hasAttribute( QLatin1String( "underline" ) ) ) {
bool underline = false;
if( element.attribute( QLatin1String( "underline" ) ) == QLatin1String( "true" ) )
underline = true;
textElement.setUnderline( underline );
}
const QString oldId = textElement.id();
if ( m_xmlElementHandler && !m_xmlElementHandler->textElement( textElement, element ) )
continue;
if ( textElement.id() != oldId ) {
// The handler modified the text element's id, look up the value again.
const QHash<QString, QString>::const_iterator it = m_textValues.constFind( textElement.id() );
if ( it != m_textValues.constEnd() ) {
textElement.setText( *it );
}
}
if ( !builder ) {
error( QObject::tr( "<text> is only supported in WordProcessing mode" ) );
} else {
if( element.hasAttribute( QLatin1String( "inline" ) ) ) {
builder->addInlineElementPublic( textElement );
} else {
Qt::AlignmentFlag alignment = Qt::AlignLeft;
if( element.hasAttribute( QLatin1String( "alignment" ) ) )
alignment = KDReports::XmlHelper::stringToAlignment( element.attribute( QLatin1String( "alignment" ) ) );
const QColor bgColor = KDReports::XmlHelper::readColor( element, "paragraph-background" );
builder->addBlockElementPublic( textElement, alignment, bgColor );
}
}
} else if( name == QLatin1String( "html" ) ) {
// Handle <html> element
KDReports::HtmlElement htmlElement;
QString id;
const QString text = extractText( element, &id );
htmlElement.setHtml( text );
htmlElement.setId( id );
QColor bgColor = KDReports::XmlHelper::readBackground( element );
if( bgColor.isValid() )
htmlElement.setBackground( bgColor );
const QString oldId = htmlElement.id();
if ( m_xmlElementHandler && !m_xmlElementHandler->htmlElement( htmlElement, element ) )
continue;
if ( htmlElement.id() != oldId ) {
// The handler modified the text element's id, look up the value again.
const QHash<QString, QString>::const_iterator it = m_textValues.constFind( htmlElement.id() );
if ( it != m_textValues.constEnd() ) {
htmlElement.setHtml( *it );
}
}
addElement( htmlElement, builder, element );
} else if ( name == QLatin1String( "tabs" ) ) {
if ( !builder ) {
error( QObject::tr( "<tabs> is only supported in WordProcessing mode" ) );
} else {
parseTabs( builder, element );
}
} else if ( name == QLatin1String( "paragraph-margins" ) ) {
if ( !builder ) {
error( QObject::tr( "<paragraph-margins> is only supported in WordProcessing mode" ) );
} else {
parseParagraphMargins( builder, element );
}
} else if( name == QLatin1String( "hr" ) ) {
// Handle <hr> element
KDReports::HtmlElement htmlElement;
htmlElement.setHtml( QString::fromLatin1("<hr>") );
if ( m_xmlElementHandler && !m_xmlElementHandler->htmlElement( htmlElement, element ) )
continue;
addElement( htmlElement, builder, element );
} else if( name == QLatin1String( "vspace" ) ) {
// Handle <vspace> element
if( !element.hasAttribute( QLatin1String( "size" ) ) )
continue; // size attribute is mandatory for VSpace
int size = element.attribute( QLatin1String( "size" ) ).toInt();
if ( !builder ) {
error( QObject::tr( "<vspace> is only supported in WordProcessing mode" ) );
} else {
if( builder != m_report->d->builder() ) {
error( QObject::tr("<vspace> not allowed in headers, footers, or table cells") );
return false;
}
}
XmlElementHandlerV2* v2 = dynamic_cast<XmlElementHandlerV2 *>(m_xmlElementHandler);
if (v2 && !v2->vspace(size, element))
continue;
m_report->addVerticalSpacing( size );
} else if( name == QLatin1String( "table" ) ) {
// Handle <table> element
const QString model = element.attribute( QLatin1String( "model" ) );
if ( model.isEmpty() ) {
if ( !builder ) {
error( QObject::tr( "<table> without a model is only supported in WordProcessing mode" ) );
continue;
}
KDReports::TableElement tableElement;
const int headerRowCount = element.attribute( QLatin1String( "headerRowCount" ) ).toInt(); // default 0
tableElement.setHeaderRowCount( headerRowCount );
if ( element.hasAttribute( QLatin1String( "cellpadding" ) ) )
tableElement.setPadding( element.attribute( QLatin1String( "cellpadding" ) ).toInt() );
parseCommonTableAttributes( tableElement, element );
if ( m_xmlElementHandler && !m_xmlElementHandler->startTableElement( tableElement, element ) )
continue;
if ( !parseTableContents( tableElement, element, *builder, inHeader, inFooter ) )
return false;
if ( m_xmlElementHandler && !m_xmlElementHandler->endTableElement( tableElement, element ) )
continue;
addElement( tableElement, builder, element );
} else {
KDReports::AutoTableElement tableElement( model );
if( element.attribute( QLatin1String( "verticalHeaderVisible" ) ) == QLatin1String( "false" ) )
tableElement.setVerticalHeaderVisible(false);
if( element.attribute( QLatin1String( "horizontalHeaderVisible" ) ) == QLatin1String( "false" ) )
tableElement.setHorizontalHeaderVisible(false);
QColor headerBgColor = KDReports::XmlHelper::readColor( element, "header-background" );
if ( headerBgColor.isValid() )
tableElement.setHeaderBackground( headerBgColor );
parseCommonTableAttributes( tableElement, element );
if ( m_xmlElementHandler && !m_xmlElementHandler->autoTableElement( tableElement, element ) )
continue;
if ( m_report->reportMode() == Report::SpreadSheet ) {
m_report->mainTable()->setAutoTableElement( tableElement );
} else {
addElement( tableElement, builder, element );
}
}
} else if( name == QLatin1String( "chart" ) ) {
// Handle <chart> element
KDReports::ChartElement chartElement( element.attribute( QLatin1String( "model" ) ) );
QColor bgColor = KDReports::XmlHelper::readBackground( element );
if( bgColor.isValid() )
chartElement.setBackground( bgColor );
int width = 100, height = 100;
Unit unit = Millimeters;
if( element.hasAttribute( QLatin1String( "width" ) ) ) {
QString str = element.attribute( QLatin1String( "width" ) );
if ( str.endsWith( QLatin1Char('%') ) ) {
str.chop( 1 );
unit = Percent;
}
width = str.toInt();
}
if( element.hasAttribute( QLatin1String( "height" ) ) ) {
QString str = element.attribute( QLatin1String( "height" ) );
if ( str.endsWith( QLatin1Char('%') ) ) {
str.chop( 1 );
unit = Percent;
}
height = str.toInt();
}
chartElement.setSize( width, height, unit );
if ( m_xmlElementHandler && !m_xmlElementHandler->chartElement( chartElement, element ) )
continue;
addElement( chartElement, builder, element );
} else if( name == QLatin1String( "image" ) ) {
// Handle <image> element
QString id;
QImage image = extractImage( element, &id );
KDReports::ImageElement imageElement( image );
imageElement.setId(id);
if( element.hasAttribute( QLatin1String( "width" ) ) ) {
QString widthStr = element.attribute( QLatin1String( "width" ) );
if ( widthStr.endsWith( QLatin1Char('%') ) ) {
widthStr.truncate( widthStr.length() - 1 );
imageElement.setWidth( widthStr.toInt(), KDReports::Percent );
} else {
imageElement.setWidth( widthStr.toInt() );
}
} else if( element.hasAttribute( QLatin1String( "height" ) ) ) { // mutually exclusive with "width"!
QString heightStr = element.attribute( QLatin1String( "height" ) );
if ( heightStr.endsWith( QLatin1Char('%') ) ) {
heightStr.truncate( heightStr.length() - 1 );
imageElement.setHeight( heightStr.toInt(), KDReports::Percent );
} else {
imageElement.setHeight( heightStr.toInt() );
}
} else if ( element.hasAttribute( QLatin1String( "fitToPage" ) ) ) {
imageElement.setFitToPage();
}
if ( m_xmlElementHandler && !m_xmlElementHandler->imageElement( imageElement, element ) )
continue;
addElement( imageElement, builder, element );
} else if( name == QLatin1String( "header" ) ) {
const KDReports::HeaderLocations loc = KDReports::XmlHelper::parseHeaderLocation( element.attribute( QLatin1String( "location" ) ) );
KDReports::Header& header = m_report->header( loc );
parseHeaderFooterAttribute( header, element );
if ( m_xmlElementHandler && !m_xmlElementHandler->startHeader( header, element ) )
continue;
if( !processNode( element, &header.d->m_builder, true, false ) )
return false;
if ( m_xmlElementHandler )
m_xmlElementHandler->endHeader( header, element );
} else if( name == QLatin1String( "footer" ) ) {
const KDReports::HeaderLocations loc = KDReports::XmlHelper::parseHeaderLocation( element.attribute( QLatin1String( "location" ) ) );
KDReports::Footer& footer = m_report->footer( loc );
parseHeaderFooterAttribute( footer, element );
if ( m_xmlElementHandler && !m_xmlElementHandler->startFooter( footer, element ) )
continue;
if( !processNode( element, &footer.d->m_builder, false, true ) )
return false;
if ( m_xmlElementHandler )
m_xmlElementHandler->endFooter( footer, element );
} else if( name == QLatin1String( "variable" ) ) {
if( !inHeader && !inFooter ) {
error( QObject::tr("<variable> tags only allowed in headers and footers") );
return false;
}
if( !element.hasAttribute( QLatin1String( "type" ) ) ) {
error( QObject::tr("<variable> tags must have a 'type' attribute") );
return false;
}
Q_ASSERT( builder );
if ( builder ) {
const QString type = element.attribute( QLatin1String( "type" ) );
KDReports::VariableType vt = KDReports::XmlHelper::stringToVariableType( type );
XmlElementHandlerV2* v2 = dynamic_cast<XmlElementHandlerV2 *>(m_xmlElementHandler);
if (v2 && !v2->variable(vt, element))
continue;
builder->addVariablePublic( vt );
}
} else if ( name == QLatin1String( "page-break" ) ) {
if ( m_xmlElementHandler && !m_xmlElementHandler->pageBreak( element ) )
continue;
m_report->addPageBreak();
} else if ( name == QLatin1String( "ifdef" ) ) {
if ( element.hasAttribute( QLatin1String( "id" ) ) ) {
const QString id = element.attribute( QLatin1String( "id" ) );
const bool skip = m_textValues.value( id ).isEmpty();
if( !skip ) {
if ( !processNode( element, builder, inHeader, inFooter ) )
return false;
}
}
} else if ( name == QLatin1String( "custom" ) ) {
if ( m_xmlElementHandler )
m_xmlElementHandler->customElement( element );
} else if ( name == QLatin1String( "hline" ) ) {
KDReports::HLineElement hLineElement;
if ( element.hasAttribute( QLatin1String( "thickness" ) ) ) {
const double thickness = element.attribute( QLatin1String( "thickness" ) ).toDouble();
hLineElement.setThickness( thickness );
}
if ( element.hasAttribute( QLatin1String( "color" ) ) ) {
const QColor color = KDReports::XmlHelper::readColor( element, "color" );
hLineElement.setColor( color );
}
if ( element.hasAttribute( QLatin1String( "margin" ) ) ) {
const int margin = element.attribute( QLatin1String( "margin" ) ).toInt();
hLineElement.setMargin( margin );
}
#ifdef KDREPORTS_ALLOW_BINARY_INCOMPATIBILITY
if ( m_xmlElementHandler && !m_xmlElementHandler->hLineElement( hLineElement, element ) )
continue;
#else
XmlElementHandlerV2* v2 = dynamic_cast<XmlElementHandlerV2 *>(m_xmlElementHandler);
if (v2 && !v2->hLineElement(hLineElement, element))
continue;
#endif
addElement( hLineElement, builder, element );
} else {
error( QObject::tr( "KDReports::Report::loadFromXML(): Unknown element %1" ).arg( name ) );
}
}
if ( testForErrorAndFillErrorDetails() )
return false;
return true;
}
void ReportView::generate()
{
// Check if there are rows in model. If so, generate report
if(m_tableModel->rowCount() > 0)
{
// Create report container
KDReports::Report report;
// Generate table element using the table model
KDReports::AutoTableElement tableElement(m_tableModel);
// Show vertical header
tableElement.setVerticalHeaderVisible(true);
// Title text
KDReports::TextElement title;
title.setText("Transaction Report");
// Show in bold format
title.setBold(true);
// Underline text
title.setUnderline(true);
// Set font size to 20
title.setPointSize(20);
// Add title to report
report.addElement(title);
// Insert vertical spacing for easier reading
report.addVerticalSpacing(2);
// Text to display report date
KDReports::TextElement date;
// Insert to date
date << "Date: " << m_genData.fromDate.toString();
// Check if report is not daily
if(!m_genData.daily)
// Add to date
date << " - " << m_genData.toDate.toString();
// Insert date element in to report
report.addElement(date);
// Insert 10 mm vertical spacing
report.addVerticalSpacing(10);
// Insert table element
report.addElement(tableElement);
// Insert a further 10 mm vertical spacing
report.addVerticalSpacing(10);
// Get report sums
ReportTable::Sums sums = static_cast<ReportTable*>(m_tableModel)
->GetSums(m_genData);
// Check validity of data
if(sums.cost == -1)
{
// Data invalid, notify user
QMessageBox::critical(this, "Failed to generate report.",
"Report data is invalid.",
QMessageBox::Ok);
// Exit function
return;
}
// Total revenue text
KDReports::TextElement revenueTotal;
// insert total revenue values
revenueTotal << "Total revenue: "
// convert to localized currency format
<< QLocale::system().toCurrencyString(sums.revenue);
// total cost text
KDReports::TextElement costTotal;
costTotal << "Total cost: "
// convert to localized currency format
<< QLocale::system().toCurrencyString(sums.cost);
// total profit text
KDReports::TextElement profitTotal;
profitTotal << "Total profit: "
// convert to localized currency format
<< QLocale::system().toCurrencyString(sums.profit);
// Add revenue total to report
report.addElement(revenueTotal);
// Add cost total to report
report.addElement(costTotal);
// Add profit total to report
report.addElement(profitTotal);
// Create preview dialog using report.
KDReports::PreviewDialog preview(&report);
// Show preview dialog
preview.exec();
}
else // No data in table model
{
// Notify user of error
QMessageBox::warning(this, "No report generated.",
"Please generate a report before attempting to print it.",
QMessageBox::Ok);
}
}
