X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/b50c69326fc036816418d39d04ff58062421644d..c13d7023d283bda30121b8c9be56f982feeed89c:/WEB-INF/lib/ttGroupExportHelper.class.php diff --git a/WEB-INF/lib/ttGroupExportHelper.class.php b/WEB-INF/lib/ttGroupExportHelper.class.php index 4e6daad2..0e4777a2 100644 --- a/WEB-INF/lib/ttGroupExportHelper.class.php +++ b/WEB-INF/lib/ttGroupExportHelper.class.php @@ -174,6 +174,24 @@ class ttGroupExportHelper { return false; } + // getPredefinedExpenses - obtains all predefined expenses for group. + function getPredefinedExpenses() { + global $user; + $mdb2 = getConnection(); + + $result = array(); + $sql = "select * from tt_predefined_expenses where group_id = $this->group_id"; // TODO: add " and org_id = $user->org_id" when possible. + $res = $mdb2->query($sql); + $result = array(); + if (!is_a($res, 'PEAR_Error')) { + while ($val = $res->fetchRow()) { + $result[] = $val; + } + return $result; + } + return false; + } + // writeData writes group data into file. function writeData() { @@ -467,6 +485,19 @@ class ttGroupExportHelper { unset($expense_items); unset($expense_item_part); + // Write predefined expenses. + $predefined_expenses = $this->getPredefinedExpenses(); + fwrite($this->file, $this->indentation." \n"); + foreach ($predefined_expenses as $predefined_expense) { + $predefined_expense_part = $this->indentation.' '."file, $predefined_expense_part); + } + fwrite($this->file, $this->indentation." \n"); + unset($predefined_expenses); + unset($predefined_expense_part); + // Write monthly quotas. $quotas = ttTeamHelper::getMonthlyQuotas($this->group_id); fwrite($this->file, $this->indentation." \n");