// This source file is part of the eZ publish (tm) Open Source Content
// Management System.
//
// ## 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";
}
$userDeleteEmail = $db->arrayQuery("SELECT count(email) as emailcount\n\t\t\t\t\t \t FROM ezsubscription\n\t\t\t\t\t\t WHERE email= '{$userEmail}'\n\t\t\t\t\t\t GROUP BY email");
if (count($userDeleteEmail > 0)) {
$count = $userDeleteEmail[0];
}
if ((int) $count > $emailCount) {
} else {
$userDeleteSubscription = $db->query("DELETE FROM ezsubscriptionuserdata\n\t\t\t\t\t\t\t\tWHERE email = '{$userEmail}'");
$userDeleteUserData = $db->query("DELETE FROM ezsubscription\n\t\t\t\t\t\t\t\tWHERE email = '{$userEmail}'");
}
}
}
}
if ($http->hasPostVariable('RemoveSingleSubscriptionButton')) {
foreach ($http->postVariable('SubscriptionIDArray') as $subscriptionID) {
eZSubscription::removeAll($subscriptionID);
}
}
/*
$userParameters = $Params['UserParameters'];
$statusFilter = isset( $userParameters['statusFilter'] ) ? explode( ',', $userParameters['statusFilter'] ) : array( -1 );
//$vipFilter = isset( $userParameters['vipFilter'] ) ? explode( ',', $userParameters['vipFilter'] ) : array( -1 );
$offset = isset( $userParameters['offset'] ) ? $userParameters['offset'] : 0;
$limitKey = isset( $userParameters['limit'] ) ? $userParameters['limit'] : '1';
$limitList = array ( '1' => 10,
'2' => 25,
'3' => 50 );
$limit = $limitList[(string)$limitKey];
$viewParameters = array( 'offset' => $offset,
