X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/871d0e2a62747b03609afc04e0ed84cfb0b1d776..e8612865ad9644fad85cd0d6fef32ea07c8acdf9:/WEB-INF/lib/ttOrgHelper.class.php diff --git a/WEB-INF/lib/ttOrgHelper.class.php b/WEB-INF/lib/ttOrgHelper.class.php index 81bfbcf7..c69fc7a7 100644 --- a/WEB-INF/lib/ttOrgHelper.class.php +++ b/WEB-INF/lib/ttOrgHelper.class.php @@ -90,6 +90,16 @@ class ttOrgHelper { // However, at this time not all tables have org_id. // So, we need to add the field as we write code here. + // Delete expense items. + $sql = "delete from tt_expense_items where org_id = $org_id"; + $affected = $mdb2->exec($sql); + if (is_a($affected, 'PEAR_Error')) return false; + + // Delete predefined expenses. + $sql = "delete from tt_predefined_expenses where org_id = $org_id"; + $affected = $mdb2->exec($sql); + if (is_a($affected, 'PEAR_Error')) return false; + // Delete monthly quotas. $sql = "delete from tt_monthly_quotas where org_id = $org_id"; $affected = $mdb2->exec($sql);