summaryrefslogtreecommitdiff
path: root/libopie2
Unidiff
Diffstat (limited to 'libopie2') (more/less context) (ignore whitespace changes)
-rw-r--r--libopie2/opiepim/backend/otodoaccesssql.cpp61
-rw-r--r--libopie2/opiepim/backend/otodoaccesssql.h6
-rw-r--r--libopie2/opiepim/core/otodoaccess.h6
3 files changed, 65 insertions, 8 deletions
diff --git a/libopie2/opiepim/backend/otodoaccesssql.cpp b/libopie2/opiepim/backend/otodoaccesssql.cpp
index 209e714..25536e0 100644
--- a/libopie2/opiepim/backend/otodoaccesssql.cpp
+++ b/libopie2/opiepim/backend/otodoaccesssql.cpp
@@ -215,183 +215,240 @@ namespace {
215 215
216 return str; 216 return str;
217 } 217 }
218}; 218};
219 219
220OTodoAccessBackendSQL::OTodoAccessBackendSQL( const QString& file ) 220OTodoAccessBackendSQL::OTodoAccessBackendSQL( const QString& file )
221 : OTodoAccessBackend(), m_dict(15) 221 : OTodoAccessBackend(), m_dict(15)
222{ 222{
223 QString fi = file; 223 QString fi = file;
224 if ( fi.isEmpty() ) 224 if ( fi.isEmpty() )
225 fi = Global::applicationFileName( "todolist", "todolist.db" ); 225 fi = Global::applicationFileName( "todolist", "todolist.db" );
226 OSQLManager man; 226 OSQLManager man;
227 m_driver = man.standard(); 227 m_driver = man.standard();
228 m_driver->setUrl(fi); 228 m_driver->setUrl(fi);
229 fillDict(); 229 fillDict();
230} 230}
231 231
232OTodoAccessBackendSQL::~OTodoAccessBackendSQL(){ 232OTodoAccessBackendSQL::~OTodoAccessBackendSQL(){
233} 233}
234bool OTodoAccessBackendSQL::load(){ 234bool OTodoAccessBackendSQL::load(){
235 if (!m_driver->open() ) 235 if (!m_driver->open() )
236 return false; 236 return false;
237 237
238 CreateQuery creat; 238 CreateQuery creat;
239 OSQLResult res = m_driver->query(&creat ); 239 OSQLResult res = m_driver->query(&creat );
240 240
241 update(); 241 update();
242 qWarning("loaded %d", m_uids.count() ); 242 qWarning("loaded %d", m_uids.count() );
243 return true; 243 return true;
244} 244}
245bool OTodoAccessBackendSQL::reload(){ 245bool OTodoAccessBackendSQL::reload(){
246 return load(); 246 return load();
247} 247}
248 248
249bool OTodoAccessBackendSQL::save(){ 249bool OTodoAccessBackendSQL::save(){
250 return m_driver->close(); 250 return m_driver->close();
251} 251}
252QArray<int> OTodoAccessBackendSQL::allRecords()const { 252QArray<int> OTodoAccessBackendSQL::allRecords()const {
253 return m_uids; 253 return m_uids;
254} 254}
255QArray<int> OTodoAccessBackendSQL::queryByExample( const OTodo& , int ){ 255QArray<int> OTodoAccessBackendSQL::queryByExample( const OTodo& , int ){
256 QArray<int> ints(0); 256 QArray<int> ints(0);
257 return ints; 257 return ints;
258} 258}
259OTodo OTodoAccessBackendSQL::find(int uid ) const{ 259OTodo OTodoAccessBackendSQL::find(int uid ) const{
260 FindQuery query( uid ); 260 FindQuery query( uid );
261 return todo( m_driver->query(&query) ); 261 return todo( m_driver->query(&query) );
262 262
263} 263}
264void OTodoAccessBackendSQL::clear() { 264void OTodoAccessBackendSQL::clear() {
265 ClearQuery cle; 265 ClearQuery cle;
266 OSQLResult res = m_driver->query( &cle ); 266 OSQLResult res = m_driver->query( &cle );
267 CreateQuery qu; 267 CreateQuery qu;
268 res = m_driver->query(&qu); 268 res = m_driver->query(&qu);
269} 269}
270bool OTodoAccessBackendSQL::add( const OTodo& t) { 270bool OTodoAccessBackendSQL::add( const OTodo& t) {
271 InsertQuery ins( t ); 271 InsertQuery ins( t );
272 OSQLResult res = m_driver->query( &ins ); 272 OSQLResult res = m_driver->query( &ins );
273 273
274 if ( res.state() == OSQLResult::Failure ) 274 if ( res.state() == OSQLResult::Failure )
275 return false; 275 return false;
276 int c = m_uids.count(); 276 int c = m_uids.count();
277 m_uids.resize( c+1 ); 277 m_uids.resize( c+1 );
278 m_uids[c] = t.uid(); 278 m_uids[c] = t.uid();
279 279
280 return true; 280 return true;
281} 281}
282bool OTodoAccessBackendSQL::remove( int uid ) { 282bool OTodoAccessBackendSQL::remove( int uid ) {
283 RemoveQuery rem( uid ); 283 RemoveQuery rem( uid );
284 OSQLResult res = m_driver->query(&rem ); 284 OSQLResult res = m_driver->query(&rem );
285 285
286 if ( res.state() == OSQLResult::Failure ) 286 if ( res.state() == OSQLResult::Failure )
287 return false; 287 return false;
288 288
289 update(); 289 update();
290 return true; 290 return true;
291} 291}
292/* 292/*
293 * FIXME better set query 293 * FIXME better set query
294 * but we need the cache for that 294 * but we need the cache for that
295 * now we remove 295 * now we remove
296 */ 296 */
297bool OTodoAccessBackendSQL::replace( const OTodo& t) { 297bool OTodoAccessBackendSQL::replace( const OTodo& t) {
298 remove( t.uid() ); 298 remove( t.uid() );
299 return add(t); 299 return add(t);
300} 300}
301QArray<int> OTodoAccessBackendSQL::overDue() { 301QArray<int> OTodoAccessBackendSQL::overDue() {
302 OverDueQuery qu; 302 OverDueQuery qu;
303 return uids( m_driver->query(&qu ) ); 303 return uids( m_driver->query(&qu ) );
304} 304}
305QArray<int> OTodoAccessBackendSQL::effectiveToDos( const QDate& s, 305QArray<int> OTodoAccessBackendSQL::effectiveToDos( const QDate& s,
306 const QDate& t, 306 const QDate& t,
307 bool u) { 307 bool u) {
308 EffQuery ef(s, t, u ); 308 EffQuery ef(s, t, u );
309 return uids (m_driver->query(&ef) ); 309 return uids (m_driver->query(&ef) );
310} 310}
311/*
312 *
313 */
311QArray<int> OTodoAccessBackendSQL::sorted( bool asc, int sortOrder, 314QArray<int> OTodoAccessBackendSQL::sorted( bool asc, int sortOrder,
312 int sortFilter, int cat ) { 315 int sortFilter, int cat ) {
313 QArray<int> ints(0); 316 QString query;
314 return ints; 317 query = "select uid from todolist WHERE ";
318
319 /*
320 * Sort Filter stuff
321 * not that straight forward
322 *
323 */
324 /* Category */
325 if ( sortFilter & 1 ) {
326 query += " categories like '%" +QString::number(cat)+"%' AND";
327 }
328 /* Show only overdue */
329 if ( sortFilter & 2 ) {
330 QDate date = QDate::currentDate();
331 QString due;
332 QString base;
333 base = QString("DueDate <= '%1-%2-%3' AND WHERE completed = 0").arg( date.year() ).arg( date.month() ).arg( date.day() );
334 query += " " + base + " AND";
335 }
336 /* not show completed */
337 if ( sortFilter & 4 ) {
338 query += " completed = 0 AND";
339 }else{
340 query += " ( completed = 1 OR completed = 0) AND";
341 }
342 /* srtip the end */
343 query = query.remove( query.length()-3, 3 );
344
345
346 /*
347 * sort order stuff
348 * quite straight forward
349 */
350 query += "ORDER BY ";
351 switch( sortOrder ) {
352 /* completed */
353 case 0:
354 query += "completed";
355 break;
356 case 1:
357 query += "priority";
358 break;
359 case 2:
360 query += "description";
361 break;
362 case 3:
363 query += "DueDate";
364 break;
365 }
366 if ( !asc )
367 query += " DESC";
368
369 qWarning( query );
370 OSQLRawQuery raw(query );
371 return uids( m_driver->query(&raw) );
315} 372}
316bool OTodoAccessBackendSQL::date( QDate& da, const QString& str ) const{ 373bool OTodoAccessBackendSQL::date( QDate& da, const QString& str ) const{
317 if ( str == "0-0-0" ) 374 if ( str == "0-0-0" )
318 return false; 375 return false;
319 else{ 376 else{
320 int day, year, month; 377 int day, year, month;
321 QStringList list = QStringList::split("-", str ); 378 QStringList list = QStringList::split("-", str );
322 year = list[0].toInt(); 379 year = list[0].toInt();
323 month = list[1].toInt(); 380 month = list[1].toInt();
324 day = list[2].toInt(); 381 day = list[2].toInt();
325 da.setYMD( year, month, day ); 382 da.setYMD( year, month, day );
326 return true; 383 return true;
327 } 384 }
328} 385}
329OTodo OTodoAccessBackendSQL::todo( const OSQLResult& res) const{ 386OTodo OTodoAccessBackendSQL::todo( const OSQLResult& res) const{
330 if ( res.state() == OSQLResult::Failure ) { 387 if ( res.state() == OSQLResult::Failure ) {
331 OTodo to; 388 OTodo to;
332 return to; 389 return to;
333 } 390 }
334 391
335 OSQLResultItem::ValueList list = res.results(); 392 OSQLResultItem::ValueList list = res.results();
336 OSQLResultItem::ValueList::Iterator it = list.begin(); 393 OSQLResultItem::ValueList::Iterator it = list.begin();
337 394
338 bool has = false; QDate da = QDate::currentDate(); 395 bool has = false; QDate da = QDate::currentDate();
339 has = date( da, (*it).data("DueDate") ); 396 has = date( da, (*it).data("DueDate") );
340 QStringList cats = QStringList::split(";", (*it).data("categories") ); 397 QStringList cats = QStringList::split(";", (*it).data("categories") );
341 398
342 OTodo to( (bool)(*it).data("completed").toInt(), (*it).data("priority").toInt(), 399 OTodo to( (bool)(*it).data("completed").toInt(), (*it).data("priority").toInt(),
343 cats, (*it).data("summary"), (*it).data("description"), 400 cats, (*it).data("summary"), (*it).data("description"),
344 (*it).data("progress").toUShort(), has, da, (*it).data("uid").toInt() ); 401 (*it).data("progress").toUShort(), has, da, (*it).data("uid").toInt() );
345 return to; 402 return to;
346} 403}
347OTodo OTodoAccessBackendSQL::todo( int uid )const { 404OTodo OTodoAccessBackendSQL::todo( int uid )const {
348 FindQuery find( uid ); 405 FindQuery find( uid );
349 return todo( m_driver->query(&find) ); 406 return todo( m_driver->query(&find) );
350} 407}
351/* 408/*
352 * update the dict 409 * update the dict
353 */ 410 */
354void OTodoAccessBackendSQL::fillDict() { 411void OTodoAccessBackendSQL::fillDict() {
355 /* initialize dict */ 412 /* initialize dict */
356 /* 413 /*
357 * UPDATE dict if you change anything!!! 414 * UPDATE dict if you change anything!!!
358 */ 415 */
359 m_dict.setAutoDelete( TRUE ); 416 m_dict.setAutoDelete( TRUE );
360 m_dict.insert("Categories" , new int(OTodo::Category) ); 417 m_dict.insert("Categories" , new int(OTodo::Category) );
361 m_dict.insert("Uid" , new int(OTodo::Uid) ); 418 m_dict.insert("Uid" , new int(OTodo::Uid) );
362 m_dict.insert("HasDate" , new int(OTodo::HasDate) ); 419 m_dict.insert("HasDate" , new int(OTodo::HasDate) );
363 m_dict.insert("Completed" , new int(OTodo::Completed) ); 420 m_dict.insert("Completed" , new int(OTodo::Completed) );
364 m_dict.insert("Description" , new int(OTodo::Description) ); 421 m_dict.insert("Description" , new int(OTodo::Description) );
365 m_dict.insert("Summary" , new int(OTodo::Summary) ); 422 m_dict.insert("Summary" , new int(OTodo::Summary) );
366 m_dict.insert("Priority" , new int(OTodo::Priority) ); 423 m_dict.insert("Priority" , new int(OTodo::Priority) );
367 m_dict.insert("DateDay" , new int(OTodo::DateDay) ); 424 m_dict.insert("DateDay" , new int(OTodo::DateDay) );
368 m_dict.insert("DateMonth" , new int(OTodo::DateMonth) ); 425 m_dict.insert("DateMonth" , new int(OTodo::DateMonth) );
369 m_dict.insert("DateYear" , new int(OTodo::DateYear) ); 426 m_dict.insert("DateYear" , new int(OTodo::DateYear) );
370 m_dict.insert("Progress" , new int(OTodo::Progress) ); 427 m_dict.insert("Progress" , new int(OTodo::Progress) );
371 m_dict.insert("Completed", new int(OTodo::Completed) ); 428 m_dict.insert("Completed", new int(OTodo::Completed) );
372 m_dict.insert("CrossReference", new int(OTodo::CrossReference) ); 429 m_dict.insert("CrossReference", new int(OTodo::CrossReference) );
373 m_dict.insert("HasAlarmDateTime",new int(OTodo::HasAlarmDateTime) ); 430 m_dict.insert("HasAlarmDateTime",new int(OTodo::HasAlarmDateTime) );
374 m_dict.insert("AlarmDateTime", new int(OTodo::AlarmDateTime) ); 431 m_dict.insert("AlarmDateTime", new int(OTodo::AlarmDateTime) );
375} 432}
376void OTodoAccessBackendSQL::update() { 433void OTodoAccessBackendSQL::update() {
377 LoadQuery lo; 434 LoadQuery lo;
378 OSQLResult res = m_driver->query(&lo); 435 OSQLResult res = m_driver->query(&lo);
379 if ( res.state() != OSQLResult::Success ) 436 if ( res.state() != OSQLResult::Success )
380 return; 437 return;
381 438
382 m_uids = uids( res ); 439 m_uids = uids( res );
383} 440}
384QArray<int> OTodoAccessBackendSQL::uids( const OSQLResult& res) const{ 441QArray<int> OTodoAccessBackendSQL::uids( const OSQLResult& res) const{
385 442
386 OSQLResultItem::ValueList list = res.results(); 443 OSQLResultItem::ValueList list = res.results();
387 OSQLResultItem::ValueList::Iterator it; 444 OSQLResultItem::ValueList::Iterator it;
388 QArray<int> ints(list.count() ); 445 QArray<int> ints(list.count() );
389 446
390 int i = 0; 447 int i = 0;
391 for (it = list.begin(); it != list.end(); ++it ) { 448 for (it = list.begin(); it != list.end(); ++it ) {
392 ints[i] = (*it).data("uid").toInt(); 449 ints[i] = (*it).data("uid").toInt();
393 i++; 450 i++;
394 } 451 }
395 return ints; 452 return ints;
396} 453}
397 454
diff --git a/libopie2/opiepim/backend/otodoaccesssql.h b/libopie2/opiepim/backend/otodoaccesssql.h
index 966628d..6c5f50a 100644
--- a/libopie2/opiepim/backend/otodoaccesssql.h
+++ b/libopie2/opiepim/backend/otodoaccesssql.h
@@ -1,46 +1,46 @@
1#ifndef OPIE_PIM_ACCESS_SQL_H 1#ifndef OPIE_PIM_ACCESS_SQL_H
2#define OPIE_PIM_ACCESS_SQL_H 2#define OPIE_PIM_ACCESS_SQL_H
3 3
4#include <qasciidict.h> 4#include <qasciidict.h>
5 5
6#include "otodoaccessbackend.h" 6#include "otodoaccessbackend.h"
7 7
8class OSQLDriver; 8class OSQLDriver;
9class OSQLResult; 9class OSQLResult;
10class OTodoAccessBackendSQL : public OTodoAccessBackend { 10class OTodoAccessBackendSQL : public OTodoAccessBackend {
11public: 11public:
12 OTodoAccessBackendSQL( const QString& file ); 12 OTodoAccessBackendSQL( const QString& file );
13 ~OTodoAccessBackendSQL(); 13 ~OTodoAccessBackendSQL();
14 14
15 bool load(); 15 bool load();
16 bool reload(); 16 bool reload();
17 bool save(); 17 bool save();
18 QArray<int> allRecords()const; 18 QArray<int> allRecords()const;
19 19
20 QArray<int> queryByExample( const OTodo& t, int sort ); 20 QArray<int> queryByExample( const OTodo& t, int sort );
21 OTodo find(int uid)const; 21 OTodo find(int uid)const;
22 void clear(); 22 void clear();
23 bool add( const OTodo& t ); 23 bool add( const OTodo& t );
24 bool remove( int uid ); 24 bool remove( int uid );
25 bool replace( const OTodo& t ); 25 bool replace( const OTodo& t );
26 26
27 QArray<int> overDue(); 27 QArray<int> overDue();
28 QArray<int> effectiveToDos( const QDate& start, 28 QArray<int> effectiveToDos( const QDate& start,
29 const QDate& end, bool includeNoDates ); 29 const QDate& end, bool includeNoDates );
30 QArray<int> sorted(bool asc, int sortOrder, int sortFilter, int cat ); 30 QArray<int> sorted(bool asc, int sortOrder, int sortFilter, int cat );
31 31
32private: 32private:
33 void update(); 33 void update();
34 void fillDict(); 34 void fillDict();
35 bool date( QDate& date, const QString& )const; 35 inline bool date( QDate& date, const QString& )const;
36 OTodo todo( const OSQLResult& )const; 36 inline OTodo todo( const OSQLResult& )const;
37 QArray<int> uids( const OSQLResult& )const; 37 inline QArray<int> uids( const OSQLResult& )const;
38 OTodo todo( int uid )const; 38 OTodo todo( int uid )const;
39 39
40 QAsciiDict<int> m_dict; 40 QAsciiDict<int> m_dict;
41 OSQLDriver* m_driver; 41 OSQLDriver* m_driver;
42 QArray<int> m_uids; 42 QArray<int> m_uids;
43}; 43};
44 44
45 45
46#endif 46#endif
diff --git a/libopie2/opiepim/core/otodoaccess.h b/libopie2/opiepim/core/otodoaccess.h
index 12997aa..390ab0e 100644
--- a/libopie2/opiepim/core/otodoaccess.h
+++ b/libopie2/opiepim/core/otodoaccess.h
@@ -1,93 +1,93 @@
1#ifndef OPIE_TODO_ACCESS_H 1#ifndef OPIE_TODO_ACCESS_H
2#define OPIE_TODO_ACCESS_H 2#define OPIE_TODO_ACCESS_H
3 3
4#include <qobject.h> 4#include <qobject.h>
5#include <qvaluelist.h> 5#include <qvaluelist.h>
6 6
7#include "otodo.h" 7#include "otodo.h"
8#include "otodoaccessbackend.h" 8#include "otodoaccessbackend.h"
9#include "opimaccesstemplate.h" 9#include "opimaccesstemplate.h"
10 10
11 11
12/** 12/**
13 * OTodoAccess 13 * OTodoAccess
14 * the class to get access to 14 * the class to get access to
15 * the todolist 15 * the todolist
16 */ 16 */
17class OTodoAccess : public QObject, public OPimAccessTemplate<OTodo> { 17class OTodoAccess : public QObject, public OPimAccessTemplate<OTodo> {
18 Q_OBJECT 18 Q_OBJECT
19public: 19public:
20 enum SortOrder { Completed = 0, 20 enum SortOrder { Completed = 0,
21 Priority, 21 Priority,
22 Description, 22 Description,
23 Deadline }; 23 Deadline };
24 enum SortFilter{ ShowOverdue = 0, 24 enum SortFilter{ Category =1,
25 Category =1, 25 OnlyOverDue= 2,
26 OnlyOverDue= 2 }; 26 DoNotShowCompleted =4 };
27 /** 27 /**
28 * if you use 0l 28 * if you use 0l
29 * the default resource will be 29 * the default resource will be
30 * picked up 30 * picked up
31 */ 31 */
32 OTodoAccess( OTodoAccessBackend* = 0l); 32 OTodoAccess( OTodoAccessBackend* = 0l);
33 ~OTodoAccess(); 33 ~OTodoAccess();
34 34
35 35
36 /* our functions here */ 36 /* our functions here */
37 /** 37 /**
38 * include todos from start to end 38 * include todos from start to end
39 * includeNoDates whether or not to include 39 * includeNoDates whether or not to include
40 * events with no dates 40 * events with no dates
41 */ 41 */
42 List effectiveToDos( const QDate& start, 42 List effectiveToDos( const QDate& start,
43 const QDate& end, 43 const QDate& end,
44 bool includeNoDates = true ); 44 bool includeNoDates = true );
45 45
46 /** 46 /**
47 * start 47 * start
48 * end date taken from the currentDate() 48 * end date taken from the currentDate()
49 */ 49 */
50 List effectiveToDos( const QDate& start, 50 List effectiveToDos( const QDate& start,
51 bool includeNoDates = true ); 51 bool includeNoDates = true );
52 52
53 53
54 /** 54 /**
55 * return overdue OTodos 55 * return overdue OTodos
56 */ 56 */
57 List overDue(); 57 List overDue();
58 58
59 /** 59 /**
60 * 60 *
61 */ 61 */
62 List sorted( bool ascending, int sortOrder, int sortFilter, int cat ); 62 List sorted( bool ascending, int sortOrder, int sortFilter, int cat );
63 63
64 /** 64 /**
65 * merge a list of OTodos into 65 * merge a list of OTodos into
66 * the resource 66 * the resource
67 */ 67 */
68 void mergeWith( const QValueList<OTodo>& ); 68 void mergeWith( const QValueList<OTodo>& );
69 69
70 /** 70 /**
71 * add an Alarm to the AlarmServer 71 * add an Alarm to the AlarmServer
72 */ 72 */
73 void addAlarm( const OTodo& ); 73 void addAlarm( const OTodo& );
74 74
75 /** 75 /**
76 * delete an alarm with the uid from 76 * delete an alarm with the uid from
77 * the alarm server 77 * the alarm server
78 */ 78 */
79 void delAlarm( int uid ); 79 void delAlarm( int uid );
80 80
81signals: 81signals:
82 /** 82 /**
83 * if the OTodoAccess was changed 83 * if the OTodoAccess was changed
84 */ 84 */
85 void signalChanged( const OTodoAccess* ); 85 void signalChanged( const OTodoAccess* );
86private: 86private:
87 int m_cat; 87 int m_cat;
88 OTodoAccessBackend* m_todoBackEnd; 88 OTodoAccessBackend* m_todoBackEnd;
89 class OTodoAccessPrivate; 89 class OTodoAccessPrivate;
90 OTodoAccessPrivate* d; 90 OTodoAccessPrivate* d;
91}; 91};
92 92
93#endif 93#endif