CiviCRM Community Forums (archive)

We did some proof of concept integration with it and see if anyone in the community would be interested. Your post has been the first response we've gotten on it (since release, past 8 months or so?). Its a bit surprising but the community has not shown much/any interest in sunlight / citizen speak / direct advocacy type tools. There has been a fair amount of interest in a generic "Petition" component.

We did not go beyond the proof of concept due to lack of interest. At this stage it does not make a lot of sense for us to push it forward internally. You should be able to resurrect the code and move it along if interested Contact us on IRC and we can point you in the right direction.

lobo

During the CiviCRM bootcamp back in March, I worked with some of the folks over at DharmaTech to develop this functionality. We'd run into some significant speed problems that they were planning on following up on.  I don't know where it got left after that.

Aaron

For those of you not interested in logging in to view attachments...

Index: CRM/Contact/Page/View/Sunlight.php
===================================================================
--- CRM/Contact/Page/View/Sunlight.php   (revision 85)
+++ CRM/Contact/Page/View/Sunlight.php   (working copy)
@@ -44,15 +44,16 @@
      * @access public
      */
     function browse( ) {
-        // get the primary city, state and zip for the contact
         require_once 'CRM/Contact/BAO/Contact.php';
         $ids = array( $this->_contactId );
         $locations = CRM_Contact_BAO_Contact::getMapInfo( $ids );
-       
+
         require_once 'CRM/Utils/Sunlight.php';
-        $rows =& CRM_Utils_Sunlight::getInfo( $locations[0]['city'],
-                                              $locations[0]['state'],
-                                              $locations[0]['postal_code'] );
+
+        $rows =& CRM_Utils_Sunlight::getInfo( $locations[0]['lat'],
+                                              $locations[0]['lng'],
+                                              $locations[0]['state'] );
+
         $this->assign( 'rowCount', count( $rows ) );
         $this->assign_by_ref( 'rows', $rows );
     }
@@ -66,12 +67,9 @@
      */
     function run( ) {
         $this->preProcess( );
-
         $this->browse( );
-
         return parent::run( );
     }
-
 }
 
 ?>
Index: CRM/Utils/Sunlight.php
===================================================================
--- CRM/Utils/Sunlight.php   (revision 85)
+++ CRM/Utils/Sunlight.php   (working copy)
@@ -47,6 +47,12 @@
         if ( PEAR::isError( $result ) ) {
             CRM_Core_Error::fatal( $result->getMessage( ) );
         }
+
+/*
+        echo "Start: $uri: " . time( ) . "<p>";         
+        flush( );
+*/
+
         if ( $request->getResponseCode( ) != 200 ) {
             CRM_Core_Error::fatal( ts( 'Invalid response code received from Sunlight servers: %1',
                                        array(1 => $request->getResponseCode())) );
@@ -94,25 +100,45 @@
 
     static function getPeopleInfo( $uri ) {
         $xml = self::makeAPICall( $uri );
+        /*
+        CRM_Core_Error::debug("getPeopleInfo()", $xml);
+        exit();
+        */
         
-        $result = array( );
-        foreach ( $xml->entity_id_list->entity_id as $key => $value ) {
-            $result[] = self::getDetailedInfo( $value );
+        if (isset($xml->entity_id_list)){
+            $result = array( );
+            foreach ( $xml->entity_id_list->entity_id as $key => $value ) {
+                $result[] = self::getDetailedInfo( $value );
+            }
         }
+        else {
+            $result = array( );
+            $result[] = self::getDetailedInfo( $xml->entity_id );
+        }
         return $result;
     }
 
-    static function getRepresentativeInfo( $city, $state ) {
-        if ( ! $city ||
-             ! $state ) {
-            return null;
-        }
+    static function getRepresentativeInfo( $lat, $long, $state ) {
         $key  = self::$_apiKey;
         $city = urlencode( $city );
-        $uri  = "people.reps.getRepsFromCityState.php?city={$city}&state={$state}&apikey={$key}&output=xml";
+        $district = self::getDistrictByLatLong($lat, $long);
+
+        $uri  = "people.reps.getRepFromDistrict.php?state={$state}&district={$district}&output=xml";
         return self::getPeopleInfo( $uri );
     }
 
+
+    static function getDistrictByLatLong( $lat, $long ) {
+        $key  = self::$_apiKey;
+        $uri  = "places.getDistrictFromLatLong?latitude={$lat}&longitude={$long}&output=xml";
+        $xml = self::makeAPICall( $uri );       
+        $district = $xml->districts->district;
+
+        // ugh, converts "01" to "1"
+        return $district+0;
+    }
+
+
     static function getSenatorInfo( $state ) {
         if ( ! $state ) {
             return null;
@@ -123,12 +149,8 @@
         return self::getPeopleInfo( $uri );
     }
 
-    static function getInfo( $city, $state, $zipcode = null ) {
-        if ( $zipcode ) {
-            list( $city, $state ) = self::getCityState( $zipcode );
-        }
-
-        $reps = self::getRepresentativeInfo( $city, $state );
+    static function getInfo( $lat, $long, $state ) {
+        $reps = self::getRepresentativeInfo( $lat, $long, $state );
         $sens = self::getSenatorInfo( $state );
 
         $result = array( );

Was searching for citizenspeak functionality for civicrm and came across this post.  I feel like this would be a great addon for civicrm.  With the proliferation of online advocacy groups, this letter sending/petition signing function is a small gap in the civicrm toolset.

Sunlight Foundation is doing amazing work as is the civicrm team.  The big push right now with Health Care Reform, Net neutrality &  Climate legislation advocacy campaigns is tipping more people off to the importance and power of online advocacy.

I'd support re-opening this topic and potentially putting some financial resources together to build out the online petition/letter sending toolset.

Please count me in to support this effort.  I'm on the board of a 501(c)(4) and this functionality would really benefit our organization.  I don't have the time to lead this, but I would support it any way I could.