+ function getBugru() {
+ global $dbP;
+ if (!$dbP) return;
+ $sql ="select BG.id as bugru,(T.rate * 100) as rate,TK.startdate from buchungsgruppen BG ";
+ $sql.="left join chart C on BG.income_accno_id_0=C.id left join taxkeys TK ";
+ $sql.="on TK.chart_id=C.id left join tax T on T.id=TK.tax_id where ";
+ $sql.="TK.startdate <= now() order by BG.id, TK.startdate";
+ $rs=$dbP->getAll($sql,DB_FETCHMODE_ASSOC);
+ if ($rs) foreach ($rs as $row) {
+ $bugru[$row["bugru"]]=$row["rate"];
+ }
+ return $bugru;
+ }