HG_REPOSITORIES/LPP/INSTRUMENTATION/USERS/JEANDET/qtcharts Files · example/gdpbarchart/widget.cpp

Added chart printing to pdf

Marek Rosa - - Load All Authors

File last commit:

r244:615e346403e5


                r244:615e346403e5

Download file

             widget.cpp
        
                    175 lines
            
             | 5.6 KiB
            
                | text/x-c
            
             |
                CppLexer
            
             / example / gdpbarchart / widget.cpp
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

        Marek Rosa
    
Corrected the path to SQlite data

              r219
            
      /*!

          \class Widget

          \brief Ui for the application.

      */

        Marek Rosa
    
Initial commit for gdpBarChart example.

              r205
            
      #include "widget.h"

      #include <QGridLayout>

      #include <QPushButton>

      #include <QLabel>

      #include <QSqlQuery>

      #include <qscatterseries.h>

      #include <qchartview.h>

      #include <qchartaxis.h>

        sauimone
    
Common naming convention for barcharts

              r216
            
      #include <qbarchartseries.h>

        Marek Rosa
    
Initial commit for gdpBarChart example.

              r205
            
      #include <qbarcategory.h>

      #include <qbarset.h>

      #include <QListWidget>

        Marek Rosa
    
Added chart printing to pdf

              r244
            
      #include <QPrinter>

      #include <QPrintDialog>

        Marek Rosa
    
Initial commit for gdpBarChart example.

              r205
            
      QTCOMMERCIALCHART_USE_NAMESPACE

      Widget::Widget(QWidget *parent)

          : QWidget(parent)

        Michal Klocek
    
Compilation fix

              r232
            
      {

        Marek Rosa
    
Copy database to bin directory

              r242
            
          setGeometry(100, 100, 1000, 600);

        Marek Rosa
    
Initial commit for gdpBarChart example.

              r205
            
          // right panel layout

          countrieslist = new QListWidget;

          countrieslist->setSelectionMode(QAbstractItemView::MultiSelection);

          yearslist = new QListWidget;

          yearslist->setSelectionMode(QAbstractItemView::ExtendedSelection);

          for (int i = 1990; i < 2011; i++)

              yearslist->addItem(QString("%1").arg(i));

          QPushButton* refreshButton = new QPushButton(tr("Refresh"));

          connect(refreshButton, SIGNAL(clicked()), this, SLOT(refreshChart()));

        Marek Rosa
    
Added chart printing to pdf

              r244
            
          QPushButton* printButton = new QPushButton(tr("Print chart"));

          connect(printButton, SIGNAL(clicked()), this, SLOT(printChart()));

        Marek Rosa
    
Initial commit for gdpBarChart example.

              r205
            
          QVBoxLayout* rightPanelLayout = new QVBoxLayout;

          rightPanelLayout->addWidget(countrieslist);

          rightPanelLayout->addWidget(yearslist);

          rightPanelLayout->addWidget(refreshButton);

        Marek Rosa
    
Added chart printing to pdf

              r244
            
          rightPanelLayout->addWidget(printButton);

        Marek Rosa
    
Initial commit for gdpBarChart example.

              r205
            
          rightPanelLayout->setStretch(0, 1);

          rightPanelLayout->setStretch(1, 0);

          // main layout

          chartArea = new QChartView(this);

          chartArea->setChartTitle("GDP by country");

          QGridLayout* mainLayout = new QGridLayout;

          mainLayout->addWidget(chartArea, 0, 0);

          mainLayout->addLayout(rightPanelLayout, 0, 1);

          mainLayout->setColumnStretch(0,1);

          setLayout(mainLayout);

          // connect to the database

          db = QSqlDatabase::addDatabase("QSQLITE");

        Marek Rosa
    
Copy database to bin directory

              r242
            
          db.setDatabaseName("gdpData");

        Marek Rosa
    
Initial commit for gdpBarChart example.

              r205
            
          if(!db.open())

          {

              qDebug() << "could not open database. SQLite db file missing (?)";

              return;

          }

          // get the list of all countires and regions.

          QSqlQuery query;

          query.exec("SELECT DISTINCT country FROM gdp2");

          // add the countries to the country filter

          while (query.next()) {

              countrieslist->addItem(query.value(0).toString());

          }

          // hide axis X labels

        Michal Klocek
    
Compilation fix

              r232
            
          QChartAxis* axis = chartArea->axisX();

          axis->setLabelsVisible(false);

        Marek Rosa
    
Added chart printing to pdf

              r244
            
          //    newAxis.setLabelsOrientation(QChartAxis::LabelsOrientationSlide);

        Michal Klocek
    
Compilation fix

              r232
            
        Marek Rosa
    
Initial commit for gdpBarChart example.

              r205
            
      }

      Widget::~Widget()

      {

          //

          db.close();

      }

        Marek Rosa
    
Corrected the path to SQlite data

              r219
            
      /*!

          refreshes the chart

      */

        Marek Rosa
    
Initial commit for gdpBarChart example.

              r205
            
      void Widget::refreshChart()

      {

        Marek Rosa
    
Added chart printing to pdf

              r244
            
          //    chartArea->

        Marek Rosa
    
Initial commit for gdpBarChart example.

              r205
            
          // selected countries items list is not sorted. copy the values to QStringlist and sort them.

          QStringList selectedCountriesStrings;

          QList<QListWidgetItem*> selectedCountriesItems = countrieslist->selectedItems();

          for (int i = 0; i < selectedCountriesItems.size(); i++)

              selectedCountriesStrings.append(selectedCountriesItems[i]->text());

          selectedCountriesStrings.sort();

          // use the sorted selected coutries list to initialize BarCategory

          QBarCategory* category = new QBarCategory;

          for (int i = 0; i < selectedCountriesStrings.size(); i++)

              *category << selectedCountriesStrings[i];

        sauimone
    
Common naming convention for barcharts

              r216
            
          QBarChartSeries* series0 = new QBarChartSeries(category);

        Marek Rosa
    
Initial commit for gdpBarChart example.

              r205
            
          // prepare the selected counries SQL query

          QString countriesQuery = "country IN (";

          for (int i = 0; i < selectedCountriesStrings.size(); i++)

          {

              countriesQuery.append("'" + selectedCountriesStrings[i] + "'");

              if ( i < selectedCountriesStrings.size() - 1)

                  countriesQuery.append(",");

              else

                  countriesQuery.append(")");

          }

          QSqlQuery query;

          // selected years items list is not sorted. copy the values to QList<Integer> and sort them.

          QList<int> selectedYearsInts;

          QList<QListWidgetItem*> selectedYearsItems = yearslist->selectedItems();

          for (int i = 0; i < selectedYearsItems.size(); i++)

              selectedYearsInts.append(selectedYearsItems[i]->text().toInt());

          qSort(selectedYearsInts);

          // perform a query for each selected year

          for (int i = 0; i < selectedYearsInts.size(); i++)

          {

              query.exec("SELECT country,gdpvalue FROM gdp2 where year=" + QString("%1").arg(selectedYearsInts[i]) + " AND " + countriesQuery);

              QBarSet* barSet = new QBarSet;

        Marek Rosa
    
Added chart printing to pdf

              r244
            
              //        while (query.next()) {

              //            qDebug() << query.value(0).toString() << " : " << query.value(1).toString();

              //        }

        Marek Rosa
    
Initial commit for gdpBarChart example.

              r205
            
              query.first();

              // the data for some of the coutries for some years might be missing.

              // QBarChart needs bars to have same size

              for (int k = 0; k < selectedCountriesStrings.size(); k++)

              {

                  if (selectedCountriesStrings[k] == query.value(0).toString())

                  {

                      *barSet << query.value(1).toReal();

                      qDebug() << query.value(0).toString() << query.value(1).toReal() << " : " << QString("%1").arg(selectedYearsInts[i]);

                      query.next();

                  }

                  else

                  {

                      // data missing, put 0

                      *barSet << 0.0f;

                      qDebug() << "Putting 0 for Bosnia" << " : " << QString("%1").arg(selectedYearsInts[i]);

                  }

              }

              series0->addBarSet(barSet);

          }

          // add the serie to the chart

          chartArea->addSeries(series0);

      }

        Marek Rosa
    
Added chart printing to pdf

              r244
            
      void Widget::printChart()

      {

          QPrinter printer;

      //    QPrinter printer(QPrinter::HighResolution);

          printer.setOutputFormat(QPrinter::PdfFormat);

          printer.setOrientation(QPrinter::Landscape);

          printer.setOutputFileName("print.pdf");

          QPainter painter;

          painter.begin(&printer);

          chartArea->render(&painter);

      }

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

Marek Rosa Corrected the path to SQlite data	r219	/*!
		\class Widget
		\brief Ui for the application.
		*/

Marek Rosa Initial commit for gdpBarChart example.	r205	#include "widget.h"
		#include <QGridLayout>
		#include <QPushButton>
		#include <QLabel>

		#include <QSqlQuery>
		#include <qscatterseries.h>
		#include <qchartview.h>
		#include <qchartaxis.h>
sauimone Common naming convention for barcharts	r216	#include <qbarchartseries.h>
Marek Rosa Initial commit for gdpBarChart example.	r205	#include <qbarcategory.h>
		#include <qbarset.h>
		#include <QListWidget>
Marek Rosa Added chart printing to pdf	r244	#include <QPrinter>
		#include <QPrintDialog>
Marek Rosa Initial commit for gdpBarChart example.	r205
		QTCOMMERCIALCHART_USE_NAMESPACE

		Widget::Widget(QWidget *parent)
		: QWidget(parent)
Michal Klocek Compilation fix	r232	{
Marek Rosa Copy database to bin directory	r242	setGeometry(100, 100, 1000, 600);
Marek Rosa Initial commit for gdpBarChart example.	r205
		// right panel layout
		countrieslist = new QListWidget;
		countrieslist->setSelectionMode(QAbstractItemView::MultiSelection);

		yearslist = new QListWidget;
		yearslist->setSelectionMode(QAbstractItemView::ExtendedSelection);
		for (int i = 1990; i < 2011; i++)
		yearslist->addItem(QString("%1").arg(i));

		QPushButton* refreshButton = new QPushButton(tr("Refresh"));
		connect(refreshButton, SIGNAL(clicked()), this, SLOT(refreshChart()));

Marek Rosa Added chart printing to pdf	r244	QPushButton* printButton = new QPushButton(tr("Print chart"));
		connect(printButton, SIGNAL(clicked()), this, SLOT(printChart()));

Marek Rosa Initial commit for gdpBarChart example.	r205	QVBoxLayout* rightPanelLayout = new QVBoxLayout;
		rightPanelLayout->addWidget(countrieslist);
		rightPanelLayout->addWidget(yearslist);
		rightPanelLayout->addWidget(refreshButton);
Marek Rosa Added chart printing to pdf	r244	rightPanelLayout->addWidget(printButton);
Marek Rosa Initial commit for gdpBarChart example.	r205	rightPanelLayout->setStretch(0, 1);
		rightPanelLayout->setStretch(1, 0);

		// main layout
		chartArea = new QChartView(this);
		chartArea->setChartTitle("GDP by country");
		QGridLayout* mainLayout = new QGridLayout;
		mainLayout->addWidget(chartArea, 0, 0);
		mainLayout->addLayout(rightPanelLayout, 0, 1);
		mainLayout->setColumnStretch(0,1);
		setLayout(mainLayout);

		// connect to the database
		db = QSqlDatabase::addDatabase("QSQLITE");
Marek Rosa Copy database to bin directory	r242	db.setDatabaseName("gdpData");
Marek Rosa Initial commit for gdpBarChart example.	r205	if(!db.open())
		{
		qDebug() << "could not open database. SQLite db file missing (?)";
		return;
		}

		// get the list of all countires and regions.
		QSqlQuery query;
		query.exec("SELECT DISTINCT country FROM gdp2");

		// add the countries to the country filter
		while (query.next()) {
		countrieslist->addItem(query.value(0).toString());
		}

		// hide axis X labels
Michal Klocek Compilation fix	r232	QChartAxis* axis = chartArea->axisX();
		axis->setLabelsVisible(false);
Marek Rosa Added chart printing to pdf	r244	// newAxis.setLabelsOrientation(QChartAxis::LabelsOrientationSlide);
Michal Klocek Compilation fix	r232
Marek Rosa Initial commit for gdpBarChart example.	r205	}

		Widget::~Widget()
		{
		//
		db.close();
		}

Marek Rosa Corrected the path to SQlite data	r219	/*!
		refreshes the chart
		*/
Marek Rosa Initial commit for gdpBarChart example.	r205	void Widget::refreshChart()
		{
Marek Rosa Added chart printing to pdf	r244	// chartArea->
Marek Rosa Initial commit for gdpBarChart example.	r205	// selected countries items list is not sorted. copy the values to QStringlist and sort them.
		QStringList selectedCountriesStrings;
		QList<QListWidgetItem*> selectedCountriesItems = countrieslist->selectedItems();
		for (int i = 0; i < selectedCountriesItems.size(); i++)
		selectedCountriesStrings.append(selectedCountriesItems[i]->text());
		selectedCountriesStrings.sort();

		// use the sorted selected coutries list to initialize BarCategory
		QBarCategory* category = new QBarCategory;
		for (int i = 0; i < selectedCountriesStrings.size(); i++)
		*category << selectedCountriesStrings[i];
sauimone Common naming convention for barcharts	r216	QBarChartSeries* series0 = new QBarChartSeries(category);
Marek Rosa Initial commit for gdpBarChart example.	r205
		// prepare the selected counries SQL query
		QString countriesQuery = "country IN (";
		for (int i = 0; i < selectedCountriesStrings.size(); i++)
		{
		countriesQuery.append("'" + selectedCountriesStrings[i] + "'");
		if ( i < selectedCountriesStrings.size() - 1)
		countriesQuery.append(",");
		else
		countriesQuery.append(")");
		}

		QSqlQuery query;
		// selected years items list is not sorted. copy the values to QList<Integer> and sort them.
		QList<int> selectedYearsInts;
		QList<QListWidgetItem*> selectedYearsItems = yearslist->selectedItems();
		for (int i = 0; i < selectedYearsItems.size(); i++)
		selectedYearsInts.append(selectedYearsItems[i]->text().toInt());
		qSort(selectedYearsInts);

		// perform a query for each selected year
		for (int i = 0; i < selectedYearsInts.size(); i++)
		{
		query.exec("SELECT country,gdpvalue FROM gdp2 where year=" + QString("%1").arg(selectedYearsInts[i]) + " AND " + countriesQuery);
		QBarSet* barSet = new QBarSet;
Marek Rosa Added chart printing to pdf	r244	// while (query.next()) {
		// qDebug() << query.value(0).toString() << " : " << query.value(1).toString();
		// }
Marek Rosa Initial commit for gdpBarChart example.	r205	query.first();

		// the data for some of the coutries for some years might be missing.
		// QBarChart needs bars to have same size
		for (int k = 0; k < selectedCountriesStrings.size(); k++)
		{
		if (selectedCountriesStrings[k] == query.value(0).toString())
		{
		*barSet << query.value(1).toReal();
		qDebug() << query.value(0).toString() << query.value(1).toReal() << " : " << QString("%1").arg(selectedYearsInts[i]);
		query.next();
		}
		else
		{
		// data missing, put 0
		*barSet << 0.0f;
		qDebug() << "Putting 0 for Bosnia" << " : " << QString("%1").arg(selectedYearsInts[i]);
		}
		}
		series0->addBarSet(barSet);
		}

		// add the serie to the chart
		chartArea->addSeries(series0);
		}
Marek Rosa Added chart printing to pdf	r244
		void Widget::printChart()
		{
		QPrinter printer;
		// QPrinter printer(QPrinter::HighResolution);
		printer.setOutputFormat(QPrinter::PdfFormat);
		printer.setOrientation(QPrinter::Landscape);
		printer.setOutputFileName("print.pdf");

		QPainter painter;
		painter.begin(&printer);
		chartArea->render(&painter);
		}