$result = array();
$mdb2 = getConnection();
- $sql = "select id, name, description, rank, rights from tt_roles where group_id = $user->group_id and org_id = $user->org_id and rank < $user->rank and status = 1 order by rank";
+ $group_id = $user->getActiveGroup();
+ $org_id = $user->org_id;
+
+ $sql = "select id, name, description, rank, rights from tt_roles where group_id = $group_id and org_id = $org_id and rank < $user->rank and status = 1 order by rank";
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$result = array();
$mdb2 = getConnection();
- $sql = "select id, name, description, rank, rights from tt_roles where group_id = $user->group_id and org_id = $user->org_id and rank < $user->rank and status = 0 order by rank";
+ $group_id = $user->getActiveGroup();
+ $org_id = $user->org_id;
+
+ $sql = "select id, name, description, rank, rights from tt_roles where group_id = $group_id and org_id = $org_id and rank < $user->rank and status = 0 order by rank";
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
+ // Delete cron entries.
+ $sql = "delete from tt_cron where group_id = $group_id";
+ $affected = $mdb2->exec($sql);
+ if (is_a($affected, 'PEAR_Error')) return false;
+
+ // Delete predefined expenses.
+ $sql = "delete from tt_predefined_expenses where group_id = $group_id";
+ $affected = $mdb2->exec($sql);
+ if (is_a($affected, 'PEAR_Error')) return false;
+
// Delete monthly quotas.
$sql = "delete from tt_monthly_quotas where group_id = $group_id";
$affected = $mdb2->exec($sql);