$sContent .= ' </tr>' . "\n"; $sContent .= ' <tr>' . "\n"; $sContent .= ' <td>' . i18n("Sort order", $plugin_name) . '</td>' . "\n"; $sContent .= ' <td>' . $oSelSortOrder->render() . '</td>' . "\n"; $sContent .= ' </tr>' . "\n"; $sContent .= ' <tr>' . "\n"; $sContent .= ' <td>' . i18n("Search for", $plugin_name) . '</td>' . "\n"; $sContent .= ' <td>' . $oTxtFilter->render() . '</td>' . "\n"; $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');
$sContent .= ' </tr>' . chr(10); $sContent .= ' <tr>' . chr(10); $sContent .= ' <td>' . i18n("Sort order", $plugin_name) . '</td>' . chr(10); $sContent .= ' <td>' . $oSelSortOrder->render() . '</td>' . chr(10); $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 = "";