From 394300a522192fb40629c966ce7ac2c6d4b7d322 Mon Sep 17 00:00:00 2001 From: Rafal Michalski <michalski.raf@xxxxxxxxx> Date: Tue, 28 Sep 2010 11:06:47 +0200 Subject: [PATCH 5/6] Binding cch call log with phonebook After incoming/missed/outgoing call is done by/to number from phonebook then combined call history will be shown with data about caller - downloaded in vCard structure. --- plugins/phonebook-tracker.c | 67 ++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 66 insertions(+), 1 deletions(-) diff --git a/plugins/phonebook-tracker.c b/plugins/phonebook-tracker.c index 5752536..ab874e5 100644 --- a/plugins/phonebook-tracker.c +++ b/plugins/phonebook-tracker.c @@ -337,18 +337,83 @@ "nmo:isSent(?call) nmo:isAnswered(?call) ?x " \ "WHERE { " \ "{ " \ + "{ " \ + "?x a nco:Contact . " \ + "?x nco:hasPhoneNumber ?h . " \ + "?call a nmo:Call ; " \ + "nmo:to ?x ; " \ + "nmo:isSent true . " \ + "?c a nco:PersonContact . " \ + "?c nco:hasPhoneNumber ?h . " \ + "OPTIONAL { ?c nco:hasEmailAddress ?e . } " \ + "OPTIONAL { ?c nco:hasPostalAddress ?p . } " \ + "OPTIONAL { " \ + "?c nco:hasAffiliation ?a . " \ + "OPTIONAL { ?a nco:hasEmailAddress ?ew . } " \ + "OPTIONAL { ?a nco:hasPostalAddress ?pw . } " \ + "OPTIONAL { ?a nco:org ?o . } " \ + "} " \ + "} UNION { " \ + "?x a nco:Contact . " \ + "?x nco:hasPhoneNumber ?w . " \ + "?call a nmo:Call ; " \ + "nmo:to ?x ; " \ + "nmo:isSent true . " \ + "?c a nco:PersonContact . " \ + "OPTIONAL { ?c nco:hasEmailAddress ?e . } " \ + "OPTIONAL { ?c nco:hasPostalAddress ?p . } " \ + "?c nco:hasAffiliation ?a . " \ + "?a nco:hasPhoneNumber ?w . " \ + "OPTIONAL { ?a nco:hasEmailAddress ?ew . } " \ + "OPTIONAL { ?a nco:hasPostalAddress ?pw . } " \ + "OPTIONAL { ?a nco:org ?o . } " \ + "} UNION { " \ "?x a nco:Contact . " \ "?x nco:hasPhoneNumber ?t . " \ "?call a nmo:Call ; " \ "nmo:to ?x ; " \ "nmo:isSent true . " \ + "} " \ "} UNION { " \ + "{ " \ + "?x a nco:Contact . " \ + "?x nco:hasPhoneNumber ?h . " \ + "?call a nmo:Call ; " \ + "nmo:from ?x ; " \ + "nmo:isSent false . " \ + "?c a nco:PersonContact . " \ + "?c nco:hasPhoneNumber ?h . " \ + "OPTIONAL { ?c nco:hasEmailAddress ?e . } " \ + "OPTIONAL { ?c nco:hasPostalAddress ?p . } " \ + "OPTIONAL { " \ + "?c nco:hasAffiliation ?a . " \ + "OPTIONAL { ?a nco:hasEmailAddress ?ew . } " \ + "OPTIONAL { ?a nco:hasPostalAddress ?pw . } " \ + "OPTIONAL { ?a nco:org ?o . } " \ + "} " \ + "} UNION { " \ + "?x a nco:Contact . " \ + "?x nco:hasPhoneNumber ?w . " \ + "?call a nmo:Call ; " \ + "nmo:from ?x ; " \ + "nmo:isSent false . " \ + "?c a nco:PersonContact . " \ + "OPTIONAL { ?c nco:hasEmailAddress ?e . } " \ + "OPTIONAL { ?c nco:hasPostalAddress ?p . } " \ + "?c nco:hasAffiliation ?a . " \ + "?a nco:hasPhoneNumber ?w . " \ + "OPTIONAL { ?a nco:hasEmailAddress ?ew . } " \ + "OPTIONAL { ?a nco:hasPostalAddress ?pw . } " \ + "OPTIONAL { ?a nco:org ?o . } " \ + "} UNION { " \ "?x a nco:Contact . " \ "?x nco:hasPhoneNumber ?t . " \ "?call a nmo:Call ; " \ "nmo:from ?x ; " \ "nmo:isSent false . " \ - "} } ORDER BY DESC(nmo:receivedDate(?call))" + "} " \ + "} " \ + "} ORDER BY DESC(nmo:receivedDate(?call)) " #define COMBINED_CALLS_LIST \ "SELECT ?c nco:nameFamily(?c) nco:nameGiven(?c) " \ -- 1.6.3.3