$sContent .= ' </tr>' . "\n"; $sContent .= ' <tr>' . "\n"; $sContent .= ' <td>' . i18n("Search in", $plugin_name) . '</td>' . "\n"; $sContent .= ' <td>' . $oSelSearchIn->render() . '</td>' . "\n"; $sContent .= ' </tr>' . "\n"; $sContent .= ' <tr>' . "\n"; $sContent .= ' <td> </td>' . "\n"; $sContent .= ' <td>' . $oBtnApply->render() . '</td>' . "\n"; $sContent .= ' </tr>' . "\n"; $sContent .= ' </table>' . "\n"; $sContent .= '</form>' . "\n"; $sContent .= '</div>' . "\n"; // To template $sLink = "listoptionsgroup"; $oListOptionsRow = new cFoldingRow("79efc1fc-111d-11dc-8314-0800200c9a66", i18n("List options", $plugin_name), $sLink, false); $oListOptionsRow->setContentData($sContent); $oTpl->set('s', 'LISTOPTIONLINKGROUP', $sLink); ###################################### # 4.3 Recipient groups: Paging ###################################### $oPagerLink = new cHTMLLink(); $oPagerLink->setLink("main.php"); $oPagerLink->setTargetFrame('left_bottom'); $oPagerLink->setCustom("elemperpage", $iItemsPerPage); $oPagerLink->setCustom("filter", ""); $oPagerLink->setCustom("sortby", "name"); $oPagerLink->setCustom("sortorder", "ASC"); $oPagerLink->setCustom("searchin", "--all--"); $oPagerLink->setCustom("frame", "2"); $oPagerLink->setCustom("area", "recipientgroups"); $oPagerLink->enableAutomaticParameterAppend();
$sContent .= ' </tr>' . chr(10); $sContent .= ' <tr>' . chr(10); $sContent .= ' <td>' . i18n("Search for", $plugin_name) . '</td>' . chr(10); $sContent .= ' <td>' . $oTxtFilter->render() . '</td>' . chr(10); $sContent .= ' </tr>' . chr(10); $sContent .= ' <tr>' . chr(10); $sContent .= ' <td>' . i18n("Search in", $plugin_name) . '</td>' . chr(10); $sContent .= ' <td>' . $oSelSearchIn->render() . '</td>' . chr(10); $sContent .= ' </tr>' . chr(10); $sContent .= ' <tr>' . chr(10); $sContent .= ' <td> </td>' . chr(10); $sContent .= ' <td>' . $oSubmit->render() . '</td>' . chr(10); $sContent .= ' </tr>' . chr(10); $sContent .= ' </table>' . chr(10); $sContent .= '</div>' . chr(10); $oOutsiderListOptionRow->setContentData($sContent); // TODO: Try to enhance genericdb to get this working with the usual objects... $oOutsiders = new RecipientCollection(); # This requires mySQL V4.1, at least... # TODO: Add mySQL server version switch #$sSQL = "idclient = '".$client."' AND idlang = '".$lang."' AND ". # "idnewsrcp NOT IN (SELECT idnewsrcp FROM ".$cfg["tab"]["news_groupmembers"]." WHERE idnewsgroup = '".$_REQUEST["idrecipientgroup"]."')"; // TODO: This works with every mySQL version but may be problematic, if a group // contains a lot of members (e.g. Oracle can't handle more than 1000 items in the brackets) $sSQL = "idclient = '" . $client . "' AND idlang = '" . $lang . "' AND " . "idnewsrcp NOT IN ('" . implode("','", $aInsiders) . "')"; if ($_REQUEST["outsider_filter"] != "") { $sSQLSearchIn = ""; if ($_REQUEST["outsider_searchin"] == "--all--" || $_REQUEST["outsider_searchin"] == "") { foreach ($aFields as $sKey => $aData) { if (strpos($aData["type"], "search") !== false) { if ($sSQLSearchIn !== "") {