Changeset 681

Timestamp:

12/15/09 15:51:52 (2 years ago)

Author:

nate

Message:

• Added initial implementation of a manual mailchimp sync.
• Fixed error causing unsubscribeInvalid function to not get more than one batch size.

Location:

trunk/phpbms

Files:

• common/stylesheet/mozilla/pages/mailchimp (added)
• common/stylesheet/mozilla/pages/mailchimp/manual_sync.css (added)
• modules/mailchimp/include/list_sync.php (modified) (6 diffs)
• modules/mailchimp/javascript/manual_list_sync.js (added)
• modules/mailchimp/manual_list_sync_ajax.php (added)
• modules/mailchimp/maunal_list_sync.php (added)
• modules/mailchimp/scheduler_list_sync.php (modified) (1 diff)

trunk/phpbms/modules/mailchimp/include/list_sync.php

@@ -261 +261 @@
         
         /**
+          *   Get rid of the temorary table.
+          */
+        $dropTableStatement = "
+            DROP TABLE IF EXISTS
+                `tempEmail`
+        ";
+        $this->db->query($dropTableStatement);
+        
+        /**
           *  Create a temporary table 
           */
@@ -275 +284 @@
           *  pull all the subscribed 
           */
-        $i = 0;
+        $start = 0;
         do{    
             $valuesClause = "";
-            
-            $members = $this->api->listMembers($this->listId, 'subscribed', NULL, $i*$this->batchLimit, $this->batchLimit*($i+1));
+                        
+            $members = $this->api->listMembers($this->listId, 'subscribed', NULL, $start, $this->batchLimit);
 
             if($this->api->errorCode){
@@ -290 +299 @@
             
             $valuesClause = substr($valuesClause, 1);
+            
             
             /**
@@ -305 +315 @@
             }//end if
             
-            $i++;
+            $start++;
         }while(count($members) == $this->batchLimit);
 
@@ -332 +342 @@
         while($therecord = $this->db->fetchArray($selectresult))
             $unsubscribeList[] = $therecord["email"];
-            
-        
-        /**
-          *  If there are records to unsubscribe, do so. 
+        
+        /**
+          *  If there are records to unsubscribe (deleted), do so. 
           */
         if(count($unsubscribeList)){
@@ -353 +362 @@
           */
         $dropTableStatement = "
-            DROP TABLE
+            DROP TABLE IF EXISTS
                 `tempEmail`
         ";

trunk/phpbms/modules/mailchimp/scheduler_list_sync.php

@@ -18 +18 @@
 $response = $listSync->process();
 var_dump($response);
-echo "<br/><br/>";
 exit;
+
 if(isset($response["type"])){