Changeset 15392 for trunk/modules

Timestamp:

07/27/11 23:05:15 (10 months ago)

Author:

Alexander Trofimov

Message:

Ticket #2572

Location:

trunk/modules/boonex/store/classes

Files:

• BxStoreDb.php (modified) (2 diffs)
• BxStoreModule.php (modified) (1 diff)

trunk/modules/boonex/store/classes/BxStoreDb.php

@@ -45 +45 @@
         $this->_sFieldFeatured = 'featured';
         $this->_sFieldCreated = 'created';
+        $this->_sTableFans = '';
+        $this->_sTableAdmins = '';
         $this->_sFieldAllowViewTo = 'allow_view_product_to';
     }
@@ -146 +148 @@
     }
 
-   function getBroadcastRecipients ($iProductId) {
+    function removeCustomersFromAllEntries ($iProfileId) {
+        $iProfileId = (int)$iProfileId;
+        if (!$iProfileId)
+            return false;
+
+        return $this->query ("DELETE FROM `" . $this->_sPrefix . "customers` WHERE `client_id` = " . $iProfileId);
+    }
+    
+    function getBroadcastRecipients ($iProductId) {
         return $this->getAll ("SELECT DISTINCT `p`.`ID`, `p`.`Email` FROM `" . $this->_sPrefix . "customers` AS `tc` INNER JOIN `" . $this->_sPrefix . $this->_sTableMediaPrefix . "files` AS `tf` ON (`tf`.`id` = `tc`.`file_id` AND `tf`.`entry_id` = '$iProductId') INNER JOIN `Profiles` as `p` ON (`p`.`ID` = `tc`.`client_id` AND `p`.`Status` = 'Active')");
     }

trunk/modules/boonex/store/classes/BxStoreModule.php

@@ -409 +409 @@
     function serviceUnregisterCartItem($iClientId, $iSellerId, $iItemId, $iItemCount, $sOrderId) {
         return $this->_oDb->unregisterCustomer ($iClientId, $iItemId, $sOrderId);
+    }
+
+    function serviceDeleteProfileData ($iProfileId) {
+        parent::serviceDeleteProfileData($iProfileId);
+        
+        // delete from list of customers
+        $this->_oDb->removeCustomersFromAllEntries ($iProfileId);
     }