<%
# Gruppen organisieren
my $gruppen;
require "se_mysql.pl";
my $dbh = &mysql_connect( connectMandanten() );
my $sth2 = $dbh->prepare( qq(
SELECT travel_gruppen.gid,
travel_gruppen.name,
COUNT(travel_pauschalen.gid) AS anzahl
FROM travel_gruppen
INNER JOIN travel_pauschalen_themen_mandanten
ON travel_pauschalen_themen_mandanten.id = travel_gruppen.gid
AND travel_pauschalen_themen_mandanten.mandant=?
LEFT JOIN travel_pauschalen ON travel_pauschalen.gruppen REGEXP CONCAT("[[:<:]]",travel_gruppen.gid,"[[:>:]]" )
WHERE travel_pauschalen.gruppen
GROUP BY travel_gruppen.gid
ORDER BY name
)
);
$sth2->execute( $SE{mandant} ) || &mysql_error($sth2);
my $c;
my $g = $value[49];
$g =~ s/\0/,/g;
while (my $gruppe = $sth2->fetchrow_hashref) {
my $chk = $g =~ /\b$gruppe->{gid}\b/ ? "CHECKED" : "" ;
$gruppen .= qq(