//
// ## END COPYRIGHT, LICENSE AND WARRANTY NOTICE ##
//
/*! \file edit_subscription.php
*/
$Module = $Params['Module'];
$http = eZHTTPTool::instance();
if ($http->hasPostVariable('RemoveSubscriptionButton')) {
if (is_array($http->postVariable('SubscriptionIDArray'))) {
foreach ($http->postVariable('SubscriptionIDArray') as $subscriptionID) {
$userData = eZUserSubscriptionData::fetchById($subscriptionID);
$subscriptionList = eZSubscription::fetchListByEmail($userData->attribute('email'), eZSubscription::VersionStatusPublished, array(array(eZSubscription::StatusPending, eZSubscription::StatusApproved, eZSubscription::StatusConfirmed, eZSubscription::StatusRemovedSelf, eZSubscription::StatusRemovedAdmin)));
foreach ($subscriptionList as $subscription) {
eZSubscription::removeAll($subscription->Attribute('id'));
}
eZUserSubscriptionData::removeAll($subscriptionID);
}
}
}
if ($http->hasPostVariable('searchString') && trim($http->postVariable('searchString')) != "") {
$search = trim(strtolower($http->postVariable('searchString')));
$db = eZDB::instance();
$searchSQL = "SELECT email FROM ezsubscriptionuserdata WHERE LOWER(firstname) LIKE '%" . $db->escapeString($search) . "%' or LOWER(name) LIKE '%" . $db->escapeString($search) . "%' or LOWER(email) LIKE '%" . $db->escapeString($search) . "%' group by email LIMIT 50";
$searchResult = $db->arrayQuery($searchSQL);
$subscriberList = array();
foreach ($searchResult as $email) {
$subscriberList[] = eZUserSubscriptionData::fetch($email['email']);
}
$countSQL = "SELECT id FROM ezsubscriptionuserdata WHERE LOWER(firstname) LIKE '%" . $db->escapeString($search) . "%' or LOWER(name) LIKE '%" . $db->escapeString($search) . "%' or LOWER(email) LIKE '%" . $db->escapeString($search) . "%' group by email";
$countResult = $db->arrayQuery($countSQL);
$subscriberCount = count($countResult);
