~ubuntu-branches/ubuntu/maverick/datakiosk/maverick

« back to all changes in this revision

Viewing changes to src/src/reportwizardbaseimpl.cpp

Committer: Bazaar Package Importer
Author(s): Jonathan Riddell
Date: 2005-06-27 22:48:06 UTC
Revision ID: james.westby@ubuntu.com-20050627224806-8farkci1dc2onhbs

Tags: upstream-0.7

Import upstream version 0.7

files added:

Makefile.am

Makefile.am.in

Makefile.in

README

acinclude.m4

aclocal.m4

admin

admin/Doxyfile.am

admin/Doxyfile.global

admin/Makefile.common

admin/acinclude.m4.in

admin/am_edit

admin/bcheck.pl

admin/compile

admin/conf.change.pl

admin/config.guess

admin/config.pl

admin/config.sub

admin/configure.in.bot.end

admin/configure.in.min

admin/cvs.sh

admin/debianrules

admin/depcomp

admin/deps.am

admin/detect-autoconf.sh

admin/install-sh

admin/libtool.m4.in

admin/ltmain.sh

admin/missing

admin/mkinstalldirs

admin/nmcheck

admin/oldinclude.m4.in

admin/pkg.m4.in

admin/ylwrap

config.h.in

configure

configure.files

configure.in

configure.in.bot

configure.in.in

src/HACKING

src/Makefile.am

src/Makefile.in

src/NEWS

src/configure.in.in

src/datakiosk

src/datakiosk.kdevelop

src/datakiosk/AUTHORS

src/datakiosk/COPYING

src/datakiosk/ChangeLog

src/datakiosk/HACKING

src/datakiosk/INSTALL

src/datakiosk/Makefile.am

src/datakiosk/Makefile.in

src/datakiosk/NEWS

src/datakiosk/README

src/datakiosk/TODO

src/datakiosk/configure.in.in

src/datakiosk/datakiosk.kdevelop

src/datakiosk/icons

src/datakiosk/icons/Makefile.am

src/datakiosk/icons/Makefile.in

src/datakiosk/icons/cr128-action-table.png

src/datakiosk/icons/cr16-action-change_row.png

src/datakiosk/icons/cr16-action-child.png

src/datakiosk/icons/cr16-action-delete_row.png

src/datakiosk/icons/cr16-action-insert_row.png

src/datakiosk/icons/cr16-action-table.png

src/datakiosk/icons/cr22-action-child.png

src/datakiosk/icons/cr22-action-table.png

src/datakiosk/icons/cr32-action-child.png

src/datakiosk/icons/cr32-action-table.png

src/datakiosk/icons/cr48-action-child.png

src/datakiosk/icons/cr48-action-table.png

src/datakiosk/icons/cr64-action-table.png

src/datakiosk/icons/hi128-app-datakiosk.png

src/datakiosk/icons/hi16-app-datakiosk.png

src/datakiosk/icons/hi22-app-datakiosk.png

src/datakiosk/icons/hi32-app-datakiosk.png

src/datakiosk/icons/hi48-app-datakiosk.png

src/datakiosk/icons/hi64-app-datakiosk.png

src/datakiosk/pics

src/datakiosk/pics/Makefile.am

src/datakiosk/pics/Makefile.in

src/datakiosk/pics/child.png

src/datakiosk/pics/datakiosk-splash.png

src/datakiosk/pics/down.png

src/datakiosk/pics/foreignkey.png

src/datakiosk/pics/hidden.png

src/datakiosk/pics/left.png

src/datakiosk/pics/primarykey.png

src/datakiosk/pics/re-sort.png

src/datakiosk/pics/right.png

src/datakiosk/pics/table.png

src/datakiosk/pics/up.png

src/datakiosk/pics/visible.png

src/datakiosk/pics/wizard_menu_1.png

src/datakiosk/pics/wizard_menu_2.png

src/datakiosk/pics/wizard_menu_3.png

src/datakiosk/pics/wizard_table_1.png

src/datakiosk/pics/wizard_table_2.png

src/datakiosk/pics/wizard_table_3.png

src/datakiosk/pics/wizard_table_4.png

src/datakiosk/po

src/datakiosk/po/Makefile.am

src/datakiosk/po/Makefile.in

src/datakiosk/samples

src/datakiosk/samples/README

src/datakiosk/samples/city.png

src/datakiosk/samples/country.png

src/datakiosk/samples/language.png

src/datakiosk/samples/world-mysql.kut

src/datakiosk/samples/world-mysql.pro

src/datakiosk/samples/world-postgresql.kut

src/datakiosk/samples/world-postgresql.pro

src/datakiosk/samples/world.mysql

src/datakiosk/samples/world.postgresql

src/datakiosk/src

src/datakiosk/src/Makefile.am

src/datakiosk/src/Makefile.in

src/datakiosk/src/actioncollection.cpp

src/datakiosk/src/actioncollection.h

src/datakiosk/src/advancedsearchdialog.cpp

src/datakiosk/src/advancedsearchdialog.h

src/datakiosk/src/asciivalidator.cpp

src/datakiosk/src/asciivalidator.h

src/datakiosk/src/connectioneditordialog.ui

src/datakiosk/src/connectioneditordialogimpl.cpp

src/datakiosk/src/connectioneditordialogimpl.h

src/datakiosk/src/databaseconnection.cpp

src/datakiosk/src/databaseconnection.h

src/datakiosk/src/dataclip.cpp

src/datakiosk/src/dataclip.h

src/datakiosk/src/datafield.cpp

src/datakiosk/src/datafield.h

src/datakiosk/src/datakiosk.cpp

src/datakiosk/src/datakiosk.desktop

src/datakiosk/src/datakiosk.h

src/datakiosk/src/datakioskui.rc

src/datakiosk/src/datareport.cpp

src/datakiosk/src/datareport.h

src/datakiosk/src/datasearchpopup.cpp

src/datakiosk/src/datasearchpopup.h

src/datakiosk/src/datatable.cpp

src/datakiosk/src/datatable.h

src/datakiosk/src/datatablebox.cpp

src/datakiosk/src/datatablebox.h

src/datakiosk/src/datatableedit.cpp

src/datakiosk/src/datatableedit.h

src/datakiosk/src/datatableeditorfactory.cpp

src/datakiosk/src/datatableeditorfactory.h

src/datakiosk/src/datatableinterface.cpp

src/datakiosk/src/datatableinterface.h

src/datakiosk/src/datatablesearch.cpp

src/datakiosk/src/datatablesearch.h

src/datakiosk/src/datatablesplitter.cpp

src/datakiosk/src/datatablesplitter.h

src/datakiosk/src/datatableview.cpp

src/datakiosk/src/datatableview.h

src/datakiosk/src/dateedit.cpp

src/datakiosk/src/dateedit.h

src/datakiosk/src/fieldeditordialog.ui

src/datakiosk/src/fieldeditordialogimpl.cpp

src/datakiosk/src/fieldeditordialogimpl.h

src/datakiosk/src/formlayout.cpp

src/datakiosk/src/formlayout.h

src/datakiosk/src/kcombotable.cpp

src/datakiosk/src/kcombotable.h

src/datakiosk/src/kcompletiontable.cpp

src/datakiosk/src/kcompletiontable.h

src/datakiosk/src/ktableedit.cpp

src/datakiosk/src/ktableedit.h

src/datakiosk/src/main.cpp

src/datakiosk/src/project.cpp

src/datakiosk/src/project.h

src/datakiosk/src/relationeditordialog.ui

src/datakiosk/src/relationeditordialogimpl.cpp

src/datakiosk/src/relationeditordialogimpl.h

src/datakiosk/src/reportwizard.ui

src/datakiosk/src/reportwizardbaseimpl.cpp

src/datakiosk/src/reportwizardbaseimpl.h

src/datakiosk/src/searchwidget.cpp

src/datakiosk/src/searchwidget.h

src/datakiosk/src/sortedstringlist.cpp

src/datakiosk/src/sortedstringlist.h

src/datakiosk/src/sqlformwizard.ui

src/datakiosk/src/sqlformwizardimpl.cpp

src/datakiosk/src/sqlformwizardimpl.h

src/datakiosk/src/statuslabel.cpp

src/datakiosk/src/statuslabel.h

src/datakiosk/src/timeedit.cpp

src/datakiosk/src/timeedit.h

src/datakiosk/src/viewmode.cpp

src/datakiosk/src/viewmode.h

src/datakiosk/svg

src/datakiosk/svg/child.svg

src/datakiosk/svg/datakiosk-splash.xcf

src/datakiosk/svg/table.svg

src/datakiosk/templates

src/datakiosk/templates/cpp

src/datakiosk/templates/h

src/icons

src/icons/Makefile.am

src/icons/Makefile.in

src/icons/cr128-action-table.png

src/icons/cr16-action-change_row.png

src/icons/cr16-action-child.png

src/icons/cr16-action-delete_row.png

src/icons/cr16-action-insert_row.png

src/icons/cr16-action-table.png

src/icons/cr22-action-child.png

src/icons/cr22-action-table.png

src/icons/cr32-action-child.png

src/icons/cr32-action-table.png

src/icons/cr48-action-child.png

src/icons/cr48-action-table.png

src/icons/cr64-action-table.png

src/icons/hi128-app-datakiosk.png

src/icons/hi16-app-datakiosk.png

src/icons/hi22-app-datakiosk.png

src/icons/hi32-app-datakiosk.png

src/icons/hi48-app-datakiosk.png

src/icons/hi64-app-datakiosk.png

src/pics

src/pics/Makefile.am

src/pics/Makefile.in

src/pics/child.png

src/pics/datakiosk-splash.png

src/pics/down.png

src/pics/foreignkey.png

src/pics/hidden.png

src/pics/left.png

src/pics/primarykey.png

src/pics/re-sort.png

src/pics/right.png

src/pics/table.png

src/pics/up.png

src/pics/visible.png

src/pics/wizard_menu_1.png

src/pics/wizard_menu_2.png

src/pics/wizard_menu_3.png

src/pics/wizard_table_1.png

src/pics/wizard_table_2.png

src/pics/wizard_table_3.png

src/pics/wizard_table_4.png

src/po

src/po/Makefile.am

src/po/Makefile.in

src/samples

src/samples/README

src/samples/city.png

src/samples/country.png

src/samples/language.png

src/samples/world-mysql.kut

src/samples/world-mysql.pro

src/samples/world-postgresql.kut

src/samples/world-postgresql.pro

src/samples/world.mysql

src/samples/world.postgresql

src/src

src/src/Makefile.am

src/src/Makefile.in

src/src/actioncollection.cpp

src/src/actioncollection.h

src/src/advancedsearchdialog.cpp

src/src/advancedsearchdialog.h

src/src/asciivalidator.cpp

src/src/asciivalidator.h

src/src/connectioneditordialog.ui

src/src/connectioneditordialogimpl.cpp

src/src/connectioneditordialogimpl.h

src/src/databaseconnection.cpp

src/src/databaseconnection.h

src/src/dataclip.cpp

src/src/dataclip.h

src/src/datafield.cpp

src/src/datafield.h

src/src/datakiosk.cpp

src/src/datakiosk.desktop

src/src/datakiosk.h

src/src/datakioskui.rc

src/src/datareport.cpp

src/src/datareport.h

src/src/datasearchpopup.cpp

src/src/datasearchpopup.h

src/src/datatable.cpp

src/src/datatable.h

src/src/datatablebox.cpp

src/src/datatablebox.h

src/src/datatableedit.cpp

src/src/datatableedit.h

src/src/datatableeditorfactory.cpp

src/src/datatableeditorfactory.h

src/src/datatableinterface.cpp

src/src/datatableinterface.h

src/src/datatablesearch.cpp

src/src/datatablesearch.h

src/src/datatablesplitter.cpp

src/src/datatablesplitter.h

src/src/datatableview.cpp

src/src/datatableview.h

src/src/dateedit.cpp

src/src/dateedit.h

src/src/fieldeditordialog.ui

src/src/fieldeditordialogimpl.cpp

src/src/fieldeditordialogimpl.h

src/src/formlayout.cpp

src/src/formlayout.h

src/src/kcombotable.cpp

src/src/kcombotable.h

src/src/kcompletiontable.cpp

src/src/kcompletiontable.h

src/src/ktableedit.cpp

src/src/ktableedit.h

src/src/main.cpp

src/src/project.cpp

src/src/project.h

src/src/relationeditordialog.ui

src/src/relationeditordialogimpl.cpp

src/src/relationeditordialogimpl.h

src/src/reportwizard.ui

src/src/reportwizardbaseimpl.cpp

src/src/reportwizardbaseimpl.h

src/src/searchwidget.cpp

src/src/searchwidget.h

src/src/sortedstringlist.cpp

src/src/sortedstringlist.h

src/src/sqlformwizard.ui

src/src/sqlformwizardimpl.cpp

src/src/sqlformwizardimpl.h

src/src/statuslabel.cpp

src/src/statuslabel.h

src/src/timeedit.cpp

src/src/timeedit.h

src/src/viewmode.cpp

src/src/viewmode.h

src/svg

src/svg/child.svg

src/svg/datakiosk-splash.xcf

src/svg/table.svg

src/templates

src/templates/cpp

src/templates/h

stamp-h.in

subdirs

Show diffs side-by-side

added added

removed removed

src/src/reportwizardbaseimpl.cpp

/***************************************************************************

* treat@kde.org *

* *

* This program is free software; you can redistribute it and/or modify *

* it under the terms of the GNU General Public License as published by *

* the Free Software Foundation; either version 2 of the License, or *

* (at your option) any later version. *

* *

***************************************************************************/

#include "reportwizardbaseimpl.h"

#include "project.h"

#include "datareport.h"

#include "datatable.h"

#include "asciivalidator.h"

#include "databaseconnection.h"

#include <kconfig.h>

#include <kmessagebox.h>

#include <kurldrag.h>

#include <kiconloader.h>

#include <klineedit.h>

#include <kaction.h>

#include <kpopupmenu.h>

#include <klocale.h>

#include <kdebug.h>

#include <kinputdialog.h>

#include <kicondialog.h>

#include <kurlrequester.h>

#include <qlistbox.h>

#include <qwidget.h>

#include <qcheckbox.h>

#include <qlineedit.h>

#include <qlabel.h>

#include <qgroupbox.h>

#include <qlayout.h>

#include <qregexp.h>

#include <qpushbutton.h>

#include <qmultilineedit.h>

#include <qlistview.h>

#include <qfeatures.h>

#include <qradiobutton.h>

#include <qspinbox.h>

#include <qcombobox.h>

#include <limits.h>

#include <qdatatable.h>

#include <qdatabrowser.h>

#include <qdataview.h>

#include <qsqleditorfactory.h>

#include <qsqlindex.h>

#include <qsqlcursor.h>

#include <qsqldatabase.h>

ReportWizard::ReportWizard( Project *project, DataReport *report, DataTable *parentTable, bool configure )

: ReportWizardBase( report ),

m_project( project ),

m_report( report ),

m_parentTable( parentTable ),

m_configure( configure )

{

setMinimumSize( 800, 600 );

setCaption( i18n("Report Wizard") );

setFinishEnabled( sortPage, true );

wizard1->setPixmap( UserIcon( "wizard_table_1" ) );

wizard2->setPixmap( UserIcon( "wizard_table_2" ) );

buttonIcon->setPixmap( SmallIcon( "kugar", 32 ) );

buttonAddSortField->setPixmap( UserIcon( "right" ) );

buttonRemoveSortField->setPixmap( UserIcon( "left" ) );

buttonUpSortField->setPixmap( UserIcon( "up" ) );

buttonDownSortField->setPixmap( UserIcon( "down" ) );

buttonReSortField->setPixmap( UserIcon( "re-sort" ) );

listBoxTables->setSelectionMode( QListBox::Multi );

connect( nextButton(), SIGNAL( clicked() ), SLOT( nextPageClicked() ) );

setupFirstPage();

}

ReportWizard::~ReportWizard()

{}

/****************reportPage methods****************/

void ReportWizard::reportTemplateChanged( const QString &temp )

{

m_report->setTemplateURL( temp );

}

void ReportWizard::reportLabelChanged( const QString &label )

{

m_report->setName( m_project->uniqueDataTableName( label ) );

100

}

101

102

void ReportWizard::reportIconChanged()

103

{

104

QString iconName = KIconDialog::getIcon( KIcon::NoGroup, KIcon::Any, false, 32, true, this, i18n("Select Icon for This Report") );

105

buttonIcon->setPixmap( SmallIcon( iconName, 32 ) );

106

m_report->setIconName( iconName );

107

}

108

109

void ReportWizard::enableAllReportPage( bool b )

110

{

111

listBoxTables->setEnabled( b );

112

kURLRequesterTemplate->setEnabled( b );

113

editReport->setEnabled( b );

114

buttonIcon->setEnabled( b );

115

}

116

117

/****************sortPage methods****************/

118

void ReportWizard::addSortField()

119

{

120

int i = listBoxSortField->currentItem();

121

if ( i == -1 )

122

return ;

123

QString f = listBoxSortField->currentText();

124

if ( !f.isEmpty() )

125

listBoxSortedField->insertItem( f + " ASC" );

126

}

127

128

void ReportWizard::reSortSortField()

129

{

130

int i = listBoxSortedField->currentItem();

131

if ( i != -1 )

132

{

133

QString text = listBoxSortedField->currentText();

134

if ( text.mid( text.length() - 3 ) == "ASC" )

135

text = text.mid( 0, text.length() - 3 ) + "DESC";

136

else if ( text.mid( text.length() - 4 ) == "DESC" )

137

text = text.mid( 0, text.length() - 4 ) + "ASC";

138

listBoxSortedField->removeItem( i );

139

listBoxSortedField->insertItem( text, i );

140

listBoxSortedField->setCurrentItem( i );

141

}

142

}

143

144

void ReportWizard::removeSortField()

145

{

146

int i = listBoxSortedField->currentItem();

147

if ( i != -1 )

148

{

149

listBoxSortedField->removeItem( i );

150

}

151

}

152

153

void ReportWizard::sortFieldUp()

154

{

155

if ( listBoxSortedField->currentItem() <= 0 ||

156

listBoxSortedField->count() < 2 )

157

return ;

158

int index = listBoxSortedField->currentItem() - 1;

159

QListBoxItem *i = listBoxSortedField->item( listBoxSortedField->currentItem() );

160

listBoxSortedField->takeItem( i );

161

listBoxSortedField->insertItem( i, index );

162

listBoxSortedField->setCurrentItem( i );

163

}

164

165

void ReportWizard::sortFieldDown()

166

{

167

if ( listBoxSortedField->currentItem() == -1 ||

168

listBoxSortedField->currentItem() == ( int ) listBoxSortedField->count() - 1 ||

169

listBoxSortedField->count() < 2 )

170

return ;

171

int index = listBoxSortedField->currentItem() + 1;

172

QListBoxItem *i = listBoxSortedField->item( listBoxSortedField->currentItem() );

173

listBoxSortedField->takeItem( i );

174

listBoxSortedField->insertItem( i, index );

175

listBoxSortedField->setCurrentItem( i );

176

}

177

178

void ReportWizard::enableAllSortPage( bool b )

179

{

180

listBoxSortField->setEnabled( b );

181

listBoxSortedField->setEnabled( b );

182

buttonAddSortField->setEnabled( b );

183

buttonRemoveSortField->setEnabled( b );

184

buttonUpSortField->setEnabled( b );

185

buttonDownSortField->setEnabled( b );

186

buttonReSortField->setEnabled( b );

187

}

188

189

void ReportWizard::nextPageClicked()

190

{

191

if ( currentPage() == reportPage )

192

{

193

setupReportPage();

194

enableAllReportPage( true );

195

}

196

else if ( currentPage() == sortPage )

197

{

198

setupSortPage();

199

enableAllSortPage( true );

200

}

201

}

202

203

void ReportWizard::setupFirstPage()

204

{

205

setNextEnabled( reportPage, true );

206

setupReportPage();

207

enableAllReportPage( true );

208

}

209

210

void ReportWizard::setupReportPage()

211

{

212

listBoxTables->clear();

213

214

QStringList str;

215

DataTableList list = m_project->dataTablesInDataTableTree( m_parentTable );

216

DataTableList::Iterator it = list.begin();

217

for ( ; it != list.end(); ++it )

218

{

219

str.append( ( *it ) ->name() );

220

}

221

222

listBoxTables->insertStringList( str );

223

224

editReport->blockSignals( true );

225

editReport->setText( m_report->name() );

226

editReport->blockSignals( false );

227

228

comboSearch->insertItem( i18n("<Default Search>") );

229

DataSearchList searchList = m_project->searchList();

230

DataSearchList::Iterator it2 = searchList.begin();

231

for ( ; it2 != searchList.end(); ++it2 )

232

{

233

comboSearch->insertItem( ( *it2 ).name() );

234

}

235

236

if ( m_configure )

237

{

238

kURLRequesterTemplate->setURL( m_report->templateURL() );

239

buttonIcon->setPixmap( SmallIcon( m_report->iconName(), 32 ) );

240

241

QStringList tables = m_report->tables();

242

QStringList::Iterator names = tables.begin();

243

for ( ; names != tables.end(); ++names )

244

{

245

QListBoxItem *item = listBoxTables->findItem( ( *names ) );

246

listBoxTables->setSelected( item, true );

247

}

248

249

if ( m_report->dataSearch().isEmpty() )

250

comboSearch->setCurrentText( i18n("<Default Search>") );

251

else

252

comboSearch->setCurrentText( m_report->dataSearch() );

253

}

254

}

255

256

void ReportWizard::setupSortPage()

257

{

258

listBoxSortField->clear();

259

listBoxSortedField->clear();

260

261

DataTableList list = m_project->dataTablesInDataTableTree( m_parentTable );

262

DataTableList::Iterator it = list.begin();

263

for ( ; it != list.end(); ++it )

264

{

265

QListBoxItem *item = listBoxTables->findItem( ( *it ) ->name() );

266

if ( item->isSelected() )

267

{

268

DataFieldList fields = ( *it ) ->fieldList();

269

DataFieldList::Iterator it2 = fields.begin();

270

for ( ; it2 != fields.end(); ++it2 )

271

{

272

if ( !( *it2 ) ->hidden() && !( *it2 ) ->isVirtual() )

273

listBoxSortField->insertItem( ( *it )->alias() + "." + ( *it2 ) ->name() );

274

}

275

}

276

}

277

278

if ( m_configure )

279

{

280

listBoxSortedField->insertStringList( m_report->sort() );

281

}

282

}

283

284

void ReportWizard::accept()

285

{

286

m_report->clearTables();

287

DataTableList list = m_project->dataTablesInDataTableTree( m_parentTable );

288

DataTableList::Iterator it = list.begin();

289

for ( ; it != list.end(); ++it )

290

{

291

QListBoxItem *item = listBoxTables->findItem( ( *it ) ->name() );

292

if ( item->isSelected() )

293

m_report->addTable( ( *it ) ->name() );

294

}

295

296

QStringList sort;

297

QListBoxItem *item = listBoxSortedField->item( 0 );

298

while ( item )

299

{

300

sort.append( item->text() );

301

item = item->next();

302

}

303

m_report->setSort( sort );

304

305

if ( comboSearch->currentText() == i18n("<Default Search>") )

306

m_report->setDataSearch( QString::null );

307

else

308

m_report->setDataSearch( comboSearch->currentText() );

309

310

if ( !m_configure )

311

{

312

m_report->initialize();

313

m_project->addDataReport( m_report );

314

}

315

else

316

m_report->refreshReport();

317

318

ReportWizardBase::accept();

319

}

320

321

#include "reportwizardbaseimpl.moc"

Older »