$mdb2 = getConnection();
$sql = "select id, name, cost from tt_predefined_expenses
- where id = $id and team_id = $user->team_id";
+ where id = $id and group_id = ".$user->getGroup();
$res = $mdb2->query($sql);
if (!is_a($res, 'PEAR_Error')) {
$val = $res->fetchRow();
$mdb2 = getConnection();
- $sql = "delete from tt_predefined_expenses where id = $id and team_id = $user->team_id";
+ $sql = "delete from tt_predefined_expenses where id = $id and group_id = ".$user->getGroup();
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error'))
return false;
$mdb2 = getConnection();
- $team_id = (int) $fields['team_id'];
+ $group_id = $user->getGroup();
+ $org_id = $user->org_id;
$name = $fields['name'];
$cost = $fields['cost'];
if ('.' != $user->decimal_mark)
$cost = str_replace($user->decimal_mark, '.', $cost);
- $sql = "insert into tt_predefined_expenses (team_id, name, cost)
- values ($team_id, ".$mdb2->quote($name).", ".$mdb2->quote($cost).")";
+ $sql = "insert into tt_predefined_expenses (group_id, org_id, name, cost)".
+ " values ($group_id, $org_id, ".$mdb2->quote($name).", ".$mdb2->quote($cost).")";
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error'))
return false;
$mdb2 = getConnection();
+ $group_id = $user->getGroup();
+ $org_id = $user->org_id;
$predefined_expense_id = (int) $fields['id'];
- $team_id = (int) $fields['team_id'];
$name = $fields['name'];
$cost = $fields['cost'];
if ('.' != $user->decimal_mark)
$cost = str_replace($user->decimal_mark, '.', $cost);
$sql = "update tt_predefined_expenses set name = ".$mdb2->quote($name).", cost = ".$mdb2->quote($cost).
- " where id = $predefined_expense_id and team_id = $team_id";
+ " where id = $predefined_expense_id and group_id = $group_id and org_id = $org_id";
$affected = $mdb2->exec($sql);
return (!is_a($affected, 'PEAR_Error'));
}