X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=WEB-INF%2Flib%2FttOrgHelper.class.php;h=c69fc7a7a0deabf963f9706d11de5a8b68461861;hb=3fe430d82ad416d1766b9f0cd558e2e1f26900a9;hp=81bfbcf7010416214e960393e0e8c3b0cf9a6e9b;hpb=871d0e2a62747b03609afc04e0ed84cfb0b1d776;p=timetracker.git 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);