// If elemperpage is something else than "all", get item count based on filters if ($_REQUEST["member_elemperpage"] > 0) { $oInsiders->query(); $iMembers = $oInsiders->count(); // Getting item count without limit (for page function) - better idea anybody (performance)? $oInsiders->setLimit($_REQUEST["member_elemperpage"] * ($_REQUEST["member_page"] - 1), $_REQUEST["member_elemperpage"]); } else { $iMembers = 0; } // Get data $sSortSQL = "recipientcollection." . $_REQUEST["member_sortby"] . " " . $_REQUEST["member_sortorder"]; if ($_REQUEST["member_sortby"] == "name") { // Name field may be empty, add email as sort criteria $sSortSQL .= ", email " . $_REQUEST["member_sortorder"]; } $oInsiders->setOrder($sSortSQL); $oInsiders->query(); $iItems = $oInsiders->count(); if ($iItems == 0 && $_REQUEST["member_filter"] == "" && ($_REQUEST["member_elemperpage"] == 0 || $iMembers == 0)) { $oAddedRecipientList->setCell(1, 1, i18n("No recipients are added to this group yet", $plugin_name)); $oAddedRecipientList->setCell(1, 2, ' '); } else { if ($iItems == 0) { $oAddedRecipientList->setCell(1, 1, i18n("No recipients found", $plugin_name)); $oAddedRecipientList->setCell(1, 2, ' '); } else { while ($oRcp = $oInsiders->next()) { $iID = $oRcp->get("idnewsrcp"); $sName = $oRcp->get("name"); $sEMail = $oRcp->get("email"); if (empty($sName)) {
unset($oUser); unset($oClient); ################################## # Get data ################################## $oRecipients = new RecipientCollection(); // Updating keys, if activated; all recipients of all clients! $sMsg = ""; if (getSystemProperty("newsletter", "updatekeys")) { $iUpdatedRecipients = $oRecipients->updateKeys(); $sMsg = $notification->returnNotification("info", sprintf(i18n("%d recipients, with no or incompatible key has been updated. Deactivate update function.", $plugin_name), $iUpdatedRecipients)); } $oRecipients->setWhere("recipientcollection.idclient", $client); $oRecipients->setWhere("recipientcollection.idlang", $lang); // sort by and sort order $oRecipients->setOrder("recipientcollection." . $_REQUEST["sortby"] . " " . $_REQUEST["sortorder"]); // Show group if ($_REQUEST["restrictgroup"] != "--all--") { $oRecipients->link("RecipientGroupMemberCollection"); $oRecipients->setWhere("RecipientGroupMemberCollection.idnewsgroup", $_REQUEST["restrictgroup"]); } // Search for if ($_REQUEST["filter"] != "") { if ($_REQUEST["searchin"] == "--all--" || $_REQUEST["searchin"] == "") { foreach ($aFields as $sKey => $aData) { if (strpos($aData["type"], "search") !== false) { $oRecipients->setWhereGroup("filter", "recipientcollection." . $aData["field"], $_REQUEST["filter"], "LIKE"); } } $oRecipients->setInnerGroupCondition("filter", "OR"); } else {