Improved query by example: Search by date is possible.. First step

for a today plugin for birthdays..

4 files changed, 226 insertions, 68 deletions

diff --git a/libopie/pim/ocontactaccess.h b/libopie/pim/ocontactaccess.h
index 961968f..32b2dcb 100644
--- a/libopie/pim/ocontactaccess.h
+++ b/libopie/pim/ocontactaccess.h
@@ -14,12 +14,16 @@
  * ToDo: Define enum for query settings
  * =====================================================================
  * Version: $Id$
  * =====================================================================
  * History:
  * $Log$
+ * Revision 1.6  2003/01/02 14:27:12  eilers
+ * Improved query by example: Search by date is possible.. First step
+ * for a today plugin for birthdays..
+ *
  * Revision 1.5  2002/11/13 14:14:51  eilers
  * Added sorted for Contacts..
  *
  * Revision 1.4  2002/11/01 15:10:42  eilers
  * Added regExp-search in database for all fields in a contact.
  *
@@ -85,13 +89,17 @@ class OContactAccess: public QObject, public OPimAccessTemplate<OContact>
 	 */
 	enum QuerySettings {
 		WildCards  = 0x0001,
 		IgnoreCase = 0x0002,
 		RegExp     = 0x0004,
 		ExactMatch = 0x0008,
-		MatchOne   = 0x0010  // Only one Entry must match
+		MatchOne   = 0x0010, // Only one Entry must match
+		DateDiff   = 0x0020, // Find all entries from today until given date
+		DateYear   = 0x0040, // The year matches
+		DateMonth  = 0x0080, // The month matches
+		DateDay    = 0x0100, // The day matches
 	};
 
 	
 	ORecordList<OContact> matchRegexp(  const QRegExp &r )const;
 
 	/** Return all Contacts in a sorted manner.
diff --git a/libopie/pim/ocontactaccessbackend_xml.h b/libopie/pim/ocontactaccessbackend_xml.h
index c765ff5..c6e6cbc 100644
--- a/libopie/pim/ocontactaccessbackend_xml.h
+++ b/libopie/pim/ocontactaccessbackend_xml.h
@@ -14,12 +14,16 @@
  *
  * =====================================================================
  * Version: $Id$
  * =====================================================================
  * History:
  * $Log$
+ * Revision 1.10  2003/01/02 14:27:12  eilers
+ * Improved query by example: Search by date is possible.. First step
+ * for a today plugin for birthdays..
+ *
  * Revision 1.9  2002/12/08 12:48:57  eilers
  * Moved journal-enum from ocontact into i the xml-backend..
  *
  * Revision 1.8  2002/11/14 17:04:24  eilers
  * Sorting will now work if fullname is identical on some entries
  *
@@ -57,12 +61,13 @@
 #include <qdatetime.h>
 #include <qfile.h>
 #include <qfileinfo.h>
 #include <qregexp.h>
 #include <qarray.h>
 #include <qmap.h>
+#include <qdatetime.h> 
 
 #include <qpe/global.h>
 
 #include <opie/xmltree.h>
 #include "ocontactaccessbackend.h"
 #include "ocontactaccess.h"
@@ -222,44 +227,95 @@ class OContactAccessBackend_XML : public OContactAccessBackend {
 		uint arraycounter = 0;
 		
 		for( it = m_contactList.begin(); it != m_contactList.end(); ++it ){
 			/* Search all fields and compare them with query object. Store them into list
 			 * if all fields matches.
 			 */
+			QDate* queryDate = 0l;
+			QDate* checkDate = 0l;
 			bool allcorrect = true;
-			for ( int i = 0; i < Qtopia::rid; i++ ) {
-				/* Just compare fields which are not empty in the query object */
-				if ( !query.field(i).isEmpty() ){
-					switch ( settings & ~OContactAccess::IgnoreCase ){
-					case OContactAccess::RegExp:{
-						QRegExp expr ( query.field(i),
-							       !(settings & OContactAccess::IgnoreCase),
-							       false );
-						if ( expr.find ( (*it).field(i), 0 ) == -1 )
-							allcorrect = false;
-					}
-						break;
-					case OContactAccess::WildCards:{
-						QRegExp expr ( query.field(i),
-							       !(settings & OContactAccess::IgnoreCase),
-							       true );
-						if ( expr.find ( (*it).field(i), 0 ) == -1 )
-							allcorrect = false;
+			for ( int i = 0; i < Qtopia::Groups; i++ ) {
+				// Birthday and anniversary are special nonstring fields and should
+				// be handled especially
+				switch ( i ){
+				case Qtopia::Birthday:
+					queryDate = new QDate( query.birthday() );
+					checkDate = new QDate( (*it).birthday() );
+				case Qtopia::Anniversary:
+					if ( queryDate == 0l ){
+						queryDate = new QDate( query.anniversary() );
+						checkDate = new QDate( (*it).anniversary() );
 					}
-						break;
-					case OContactAccess::ExactMatch:{
-						if (settings & OContactAccess::IgnoreCase){
-							if ( query.field(i).upper() !=
-							     (*it).field(i).upper() )
+					
+					if ( queryDate->isValid() ){
+						if ( settings & OContactAccess::DateYear ){
+							if ( queryDate->year() != checkDate->year() )
 								allcorrect = false;
-						}else{
-							if ( query.field(i) != (*it).field(i) )
+						} 
+						if ( settings & OContactAccess::DateMonth ){
+							if ( queryDate->month() != checkDate->month() )
 								allcorrect = false;
+						} 
+						if ( settings & OContactAccess::DateDay ){
+							if ( queryDate->day() != checkDate->day() )
+								allcorrect = false;
+						} 
+						if ( settings & OContactAccess::DateDiff ) {
+							QDate current = QDate::currentDate();
+							if ( current.daysTo( *queryDate ) > 0 ){
+								if ( !( ( *checkDate >= current ) && 
+									( *checkDate <= *queryDate ) ) )
+									allcorrect = false;
+							}
 						}
 					}
-						break;
+
+					delete queryDate;
+					queryDate = 0l;
+					delete checkDate;
+					checkDate = 0l;
+					break;
+				default:
+					/* Just compare fields which are not empty in the query object */
+					if ( !query.field(i).isEmpty() ){
+						switch ( settings & ~( OContactAccess::IgnoreCase
+								       | OContactAccess::DateDiff
+								       | OContactAccess::DateYear
+								       | OContactAccess::DateMonth
+								       | OContactAccess::DateDay
+								       | OContactAccess::MatchOne 
+								      ) ){
+
+						case OContactAccess::RegExp:{
+							QRegExp expr ( query.field(i),
+								       !(settings & OContactAccess::IgnoreCase),
+								       false );
+							if ( expr.find ( (*it).field(i), 0 ) == -1 )
+								allcorrect = false;
+						}
+							break;
+						case OContactAccess::WildCards:{
+							QRegExp expr ( query.field(i),
+								       !(settings & OContactAccess::IgnoreCase),
+								       true );
+							if ( expr.find ( (*it).field(i), 0 ) == -1 )
+								allcorrect = false;
+						}
+							break;
+						case OContactAccess::ExactMatch:{
+							if (settings & OContactAccess::IgnoreCase){
+								if ( query.field(i).upper() !=
+								     (*it).field(i).upper() )
+									allcorrect = false;
+							}else{
+								if ( query.field(i) != (*it).field(i) )
+									allcorrect = false;
+							}
+						}
+							break;
+						}
 					}
 				}
 			}
 			if ( allcorrect ){
 				m_currentQuery[arraycounter++] = (*it).uid();
 			}
@@ -288,24 +344,39 @@ class OContactAccessBackend_XML : public OContactAccessBackend {
 		return m_currentQuery;
 	}
 	
 	const uint querySettings()
 		{
 			return ( OContactAccess::WildCards
-				 & OContactAccess::IgnoreCase
-				 & OContactAccess::RegExp
-				 & OContactAccess::ExactMatch );
+				 | OContactAccess::IgnoreCase
+				 | OContactAccess::RegExp
+				 | OContactAccess::ExactMatch 
+				 | OContactAccess::DateDiff
+				 | OContactAccess::DateYear
+				 | OContactAccess::DateMonth
+				 | OContactAccess::DateDay
+				);
 		}
 	
 	bool hasQuerySettings (uint querySettings) const
 		{
-			/* OContactAccess::IgnoreCase may be added with one
-			 * of the other settings, but never used alone.
-			 * The other settings are just valid alone...
+			/* OContactAccess::IgnoreCase, DateDiff, DateYear, DateMonth, DateDay 
+			 * may be added with any of the other settings. IgnoreCase should never used alone.
+			 * Wildcards, RegExp, ExactMatch should never used at the same time...
 			 */
-			switch ( querySettings & ~OContactAccess::IgnoreCase ){
+
+			if ( querySettings == OContactAccess::IgnoreCase ) 
+				return false;
+
+			switch ( querySettings & ~( OContactAccess::IgnoreCase
+						    | OContactAccess::DateDiff
+						    | OContactAccess::DateYear
+						    | OContactAccess::DateMonth
+						    | OContactAccess::DateDay
+						  ) 
+			       ){
 			case OContactAccess::RegExp:
 				return ( true );
 			case OContactAccess::WildCards:
 				return ( true );
 			case OContactAccess::ExactMatch:
 				return ( true );
diff --git a/libopie2/opiepim/backend/ocontactaccessbackend_xml.h b/libopie2/opiepim/backend/ocontactaccessbackend_xml.h
index c765ff5..c6e6cbc 100644
--- a/libopie2/opiepim/backend/ocontactaccessbackend_xml.h
+++ b/libopie2/opiepim/backend/ocontactaccessbackend_xml.h
@@ -14,12 +14,16 @@
  *
  * =====================================================================
  * Version: $Id$
  * =====================================================================
  * History:
  * $Log$
+ * Revision 1.10  2003/01/02 14:27:12  eilers
+ * Improved query by example: Search by date is possible.. First step
+ * for a today plugin for birthdays..
+ *
  * Revision 1.9  2002/12/08 12:48:57  eilers
  * Moved journal-enum from ocontact into i the xml-backend..
  *
  * Revision 1.8  2002/11/14 17:04:24  eilers
  * Sorting will now work if fullname is identical on some entries
  *
@@ -57,12 +61,13 @@
 #include <qdatetime.h>
 #include <qfile.h>
 #include <qfileinfo.h>
 #include <qregexp.h>
 #include <qarray.h>
 #include <qmap.h>
+#include <qdatetime.h> 
 
 #include <qpe/global.h>
 
 #include <opie/xmltree.h>
 #include "ocontactaccessbackend.h"
 #include "ocontactaccess.h"
@@ -222,44 +227,95 @@ class OContactAccessBackend_XML : public OContactAccessBackend {
 		uint arraycounter = 0;
 		
 		for( it = m_contactList.begin(); it != m_contactList.end(); ++it ){
 			/* Search all fields and compare them with query object. Store them into list
 			 * if all fields matches.
 			 */
+			QDate* queryDate = 0l;
+			QDate* checkDate = 0l;
 			bool allcorrect = true;
-			for ( int i = 0; i < Qtopia::rid; i++ ) {
-				/* Just compare fields which are not empty in the query object */
-				if ( !query.field(i).isEmpty() ){
-					switch ( settings & ~OContactAccess::IgnoreCase ){
-					case OContactAccess::RegExp:{
-						QRegExp expr ( query.field(i),
-							       !(settings & OContactAccess::IgnoreCase),
-							       false );
-						if ( expr.find ( (*it).field(i), 0 ) == -1 )
-							allcorrect = false;
-					}
-						break;
-					case OContactAccess::WildCards:{
-						QRegExp expr ( query.field(i),
-							       !(settings & OContactAccess::IgnoreCase),
-							       true );
-						if ( expr.find ( (*it).field(i), 0 ) == -1 )
-							allcorrect = false;
+			for ( int i = 0; i < Qtopia::Groups; i++ ) {
+				// Birthday and anniversary are special nonstring fields and should
+				// be handled especially
+				switch ( i ){
+				case Qtopia::Birthday:
+					queryDate = new QDate( query.birthday() );
+					checkDate = new QDate( (*it).birthday() );
+				case Qtopia::Anniversary:
+					if ( queryDate == 0l ){
+						queryDate = new QDate( query.anniversary() );
+						checkDate = new QDate( (*it).anniversary() );
 					}
-						break;
-					case OContactAccess::ExactMatch:{
-						if (settings & OContactAccess::IgnoreCase){
-							if ( query.field(i).upper() !=
-							     (*it).field(i).upper() )
+					
+					if ( queryDate->isValid() ){
+						if ( settings & OContactAccess::DateYear ){
+							if ( queryDate->year() != checkDate->year() )
 								allcorrect = false;
-						}else{
-							if ( query.field(i) != (*it).field(i) )
+						} 
+						if ( settings & OContactAccess::DateMonth ){
+							if ( queryDate->month() != checkDate->month() )
 								allcorrect = false;
+						} 
+						if ( settings & OContactAccess::DateDay ){
+							if ( queryDate->day() != checkDate->day() )
+								allcorrect = false;
+						} 
+						if ( settings & OContactAccess::DateDiff ) {
+							QDate current = QDate::currentDate();
+							if ( current.daysTo( *queryDate ) > 0 ){
+								if ( !( ( *checkDate >= current ) && 
+									( *checkDate <= *queryDate ) ) )
+									allcorrect = false;
+							}
 						}
 					}
-						break;
+
+					delete queryDate;
+					queryDate = 0l;
+					delete checkDate;
+					checkDate = 0l;
+					break;
+				default:
+					/* Just compare fields which are not empty in the query object */
+					if ( !query.field(i).isEmpty() ){
+						switch ( settings & ~( OContactAccess::IgnoreCase
+								       | OContactAccess::DateDiff
+								       | OContactAccess::DateYear
+								       | OContactAccess::DateMonth
+								       | OContactAccess::DateDay
+								       | OContactAccess::MatchOne 
+								      ) ){
+
+						case OContactAccess::RegExp:{
+							QRegExp expr ( query.field(i),
+								       !(settings & OContactAccess::IgnoreCase),
+								       false );
+							if ( expr.find ( (*it).field(i), 0 ) == -1 )
+								allcorrect = false;
+						}
+							break;
+						case OContactAccess::WildCards:{
+							QRegExp expr ( query.field(i),
+								       !(settings & OContactAccess::IgnoreCase),
+								       true );
+							if ( expr.find ( (*it).field(i), 0 ) == -1 )
+								allcorrect = false;
+						}
+							break;
+						case OContactAccess::ExactMatch:{
+							if (settings & OContactAccess::IgnoreCase){
+								if ( query.field(i).upper() !=
+								     (*it).field(i).upper() )
+									allcorrect = false;
+							}else{
+								if ( query.field(i) != (*it).field(i) )
+									allcorrect = false;
+							}
+						}
+							break;
+						}
 					}
 				}
 			}
 			if ( allcorrect ){
 				m_currentQuery[arraycounter++] = (*it).uid();
 			}
@@ -288,24 +344,39 @@ class OContactAccessBackend_XML : public OContactAccessBackend {
 		return m_currentQuery;
 	}
 	
 	const uint querySettings()
 		{
 			return ( OContactAccess::WildCards
-				 & OContactAccess::IgnoreCase
-				 & OContactAccess::RegExp
-				 & OContactAccess::ExactMatch );
+				 | OContactAccess::IgnoreCase
+				 | OContactAccess::RegExp
+				 | OContactAccess::ExactMatch 
+				 | OContactAccess::DateDiff
+				 | OContactAccess::DateYear
+				 | OContactAccess::DateMonth
+				 | OContactAccess::DateDay
+				);
 		}
 	
 	bool hasQuerySettings (uint querySettings) const
 		{
-			/* OContactAccess::IgnoreCase may be added with one
-			 * of the other settings, but never used alone.
-			 * The other settings are just valid alone...
+			/* OContactAccess::IgnoreCase, DateDiff, DateYear, DateMonth, DateDay 
+			 * may be added with any of the other settings. IgnoreCase should never used alone.
+			 * Wildcards, RegExp, ExactMatch should never used at the same time...
 			 */
-			switch ( querySettings & ~OContactAccess::IgnoreCase ){
+
+			if ( querySettings == OContactAccess::IgnoreCase ) 
+				return false;
+
+			switch ( querySettings & ~( OContactAccess::IgnoreCase
+						    | OContactAccess::DateDiff
+						    | OContactAccess::DateYear
+						    | OContactAccess::DateMonth
+						    | OContactAccess::DateDay
+						  ) 
+			       ){
 			case OContactAccess::RegExp:
 				return ( true );
 			case OContactAccess::WildCards:
 				return ( true );
 			case OContactAccess::ExactMatch:
 				return ( true );
diff --git a/libopie2/opiepim/core/ocontactaccess.h b/libopie2/opiepim/core/ocontactaccess.h
index 961968f..32b2dcb 100644
--- a/libopie2/opiepim/core/ocontactaccess.h
+++ b/libopie2/opiepim/core/ocontactaccess.h
@@ -14,12 +14,16 @@
  * ToDo: Define enum for query settings
  * =====================================================================
  * Version: $Id$
  * =====================================================================
  * History:
  * $Log$
+ * Revision 1.6  2003/01/02 14:27:12  eilers
+ * Improved query by example: Search by date is possible.. First step
+ * for a today plugin for birthdays..
+ *
  * Revision 1.5  2002/11/13 14:14:51  eilers
  * Added sorted for Contacts..
  *
  * Revision 1.4  2002/11/01 15:10:42  eilers
  * Added regExp-search in database for all fields in a contact.
  *
@@ -85,13 +89,17 @@ class OContactAccess: public QObject, public OPimAccessTemplate<OContact>
 	 */
 	enum QuerySettings {
 		WildCards  = 0x0001,
 		IgnoreCase = 0x0002,
 		RegExp     = 0x0004,
 		ExactMatch = 0x0008,
-		MatchOne   = 0x0010  // Only one Entry must match
+		MatchOne   = 0x0010, // Only one Entry must match
+		DateDiff   = 0x0020, // Find all entries from today until given date
+		DateYear   = 0x0040, // The year matches
+		DateMonth  = 0x0080, // The month matches
+		DateDay    = 0x0100, // The day matches
 	};
 
 	
 	ORecordList<OContact> matchRegexp(  const QRegExp &r )const;
 
 	/** Return all Contacts in a sorted manner.