Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | <?php |
2 | /* | |
3 | +--------------------------------------------------------------------+ | |
39de6fd5 | 4 | | CiviCRM version 4.6 | |
6a488035 | 5 | +--------------------------------------------------------------------+ |
06b69b18 | 6 | | Copyright CiviCRM LLC (c) 2004-2014 | |
6a488035 TO |
7 | +--------------------------------------------------------------------+ |
8 | | This file is a part of CiviCRM. | | |
9 | | | | |
10 | | CiviCRM is free software; you can copy, modify, and distribute it | | |
11 | | under the terms of the GNU Affero General Public License | | |
12 | | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. | | |
13 | | | | |
14 | | CiviCRM is distributed in the hope that it will be useful, but | | |
15 | | WITHOUT ANY WARRANTY; without even the implied warranty of | | |
16 | | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. | | |
17 | | See the GNU Affero General Public License for more details. | | |
18 | | | | |
19 | | You should have received a copy of the GNU Affero General Public | | |
20 | | License and the CiviCRM Licensing Exception along | | |
21 | | with this program; if not, contact CiviCRM LLC | | |
22 | | at info[AT]civicrm[DOT]org. If you have questions about the | | |
23 | | GNU Affero General Public License or the licensing of CiviCRM, | | |
24 | | see the CiviCRM license FAQ at http://civicrm.org/licensing | | |
25 | +--------------------------------------------------------------------+ | |
26 | */ | |
27 | ||
28 | /** | |
29 | * | |
30 | * @package CRM | |
06b69b18 | 31 | * @copyright CiviCRM LLC (c) 2004-2014 |
6a488035 TO |
32 | * $Id$ |
33 | * | |
34 | */ | |
35 | class CRM_Mailing_BAO_Recipients extends CRM_Mailing_DAO_Recipients { | |
36 | ||
37 | /** | |
100fef9d | 38 | * Class constructor |
6a488035 TO |
39 | */ |
40 | function __construct() { | |
41 | parent::__construct(); | |
42 | } | |
43 | ||
e0ef6999 | 44 | /** |
100fef9d | 45 | * @param int $mailingID |
e0ef6999 EM |
46 | * |
47 | * @return null|string | |
48 | */ | |
6a488035 TO |
49 | static function mailingSize($mailingID) { |
50 | $sql = " | |
51 | SELECT count(*) as count | |
52 | FROM civicrm_mailing_recipients | |
53 | WHERE mailing_id = %1 | |
54 | "; | |
55 | $params = array(1 => array($mailingID, 'Integer')); | |
56 | return CRM_Core_DAO::singleValueQuery($sql, $params); | |
57 | } | |
58 | ||
e0ef6999 | 59 | /** |
100fef9d | 60 | * @param int $mailingID |
e0ef6999 EM |
61 | * @param null $offset |
62 | * @param null $limit | |
63 | * | |
64 | * @return Object | |
65 | */ | |
6a488035 TO |
66 | static function mailingQuery($mailingID, |
67 | $offset = NULL, $limit = NULL | |
68 | ) { | |
69 | $limitString = NULL; | |
70 | if ($limit && $offset !== NULL) { | |
bf00d1b6 | 71 | $offset = CRM_Utils_Type::escape($offset, 'Int'); |
dd3a4117 | 72 | $limit = CRM_Utils_Type::escape($limit, 'Int'); |
bf00d1b6 | 73 | |
6a488035 TO |
74 | $limitString = "LIMIT $offset, $limit"; |
75 | } | |
76 | ||
77 | $sql = " | |
78 | SELECT contact_id, email_id, phone_id | |
79 | FROM civicrm_mailing_recipients | |
80 | WHERE mailing_id = %1 | |
81 | $limitString | |
82 | "; | |
83 | $params = array(1 => array($mailingID, 'Integer')); | |
84 | ||
85 | return CRM_Core_DAO::executeQuery($sql, $params); | |
86 | } | |
ef643544 | 87 | |
0ae3d02b DK |
88 | /** |
89 | * Moves a number of randomly-chosen recipients of one Mailing to another Mailing. | |
90 | * | |
768c558c | 91 | * @param int $sourceMailingId |
0ae3d02b DK |
92 | * Source mailing ID |
93 | * @param int $newMailingID | |
94 | * Destination mailing ID | |
95 | * @param int $totalLimit | |
96 | * Number of recipients to move | |
97 | */ | |
768c558c | 98 | static function updateRandomRecipients($sourceMailingId, $newMailingID, $totalLimit = NULL) { |
ef643544 | 99 | $limitString = NULL; |
100 | if ($totalLimit) { | |
101 | $limitString = "LIMIT 0, $totalLimit"; | |
102 | } | |
768c558c | 103 | CRM_Core_DAO::executeQuery("DROP TEMPORARY TABLE IF EXISTS srcMailing_$sourceMailingId"); |
ef643544 | 104 | $sql = " |
768c558c | 105 | CREATE TEMPORARY TABLE srcMailing_$sourceMailingId |
ef643544 | 106 | (mailing_recipient_id int, id int PRIMARY KEY AUTO_INCREMENT, INDEX(mailing_recipient_id)) |
107 | ENGINE=HEAP"; | |
108 | CRM_Core_DAO::executeQuery($sql); | |
109 | $sql = " | |
768c558c | 110 | INSERT INTO srcMailing_$sourceMailingId (mailing_recipient_id) |
ef643544 | 111 | SELECT mr.id |
112 | FROM civicrm_mailing_recipients mr | |
768c558c | 113 | WHERE mr.mailing_id = $sourceMailingId |
ef643544 | 114 | ORDER BY RAND() |
115 | $limitString | |
116 | "; | |
117 | CRM_Core_DAO::executeQuery($sql); | |
118 | $sql = " | |
119 | UPDATE civicrm_mailing_recipients mr | |
768c558c | 120 | INNER JOIN srcMailing_$sourceMailingId temp_mr ON temp_mr.mailing_recipient_id = mr.id |
ef643544 | 121 | SET mr.mailing_id = $newMailingID |
122 | "; | |
123 | CRM_Core_DAO::executeQuery($sql); | |
124 | } | |
125 | ||
768c558c TO |
126 | /** |
127 | * Redistribute recipients from $sourceMailingId to a series of other mailings. | |
128 | * | |
129 | * @param int $sourceMailingId | |
130 | * @param array $to (int $targetMailingId => int $count) | |
131 | */ | |
132 | static function reassign($sourceMailingId, $to) { | |
133 | foreach ($to as $targetMailingId => $count) { | |
134 | if ($count > 0) { | |
135 | CRM_Mailing_BAO_Recipients::updateRandomRecipients($sourceMailingId, $targetMailingId, $count); | |
136 | } | |
137 | } | |
138 | } | |
139 | ||
6a488035 TO |
140 | } |
141 |