X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=WEB-INF%2Flib%2FttPredefinedExpenseHelper.class.php;h=556bc42f6b1f5c833b359dee940aba91d4e2cc19;hb=73bd55c5aaa9459806ef9fa899cc5a24513727bc;hp=4c33c42731f77fe23922a3c32f277126f7a3cbc3;hpb=2df0ec3f98d0fa23102dc8362c4272ddebecf157;p=timetracker.git diff --git a/WEB-INF/lib/ttPredefinedExpenseHelper.class.php b/WEB-INF/lib/ttPredefinedExpenseHelper.class.php index 4c33c427..556bc42f 100644 --- a/WEB-INF/lib/ttPredefinedExpenseHelper.class.php +++ b/WEB-INF/lib/ttPredefinedExpenseHelper.class.php @@ -34,6 +34,7 @@ class ttPredefinedExpenseHelper { static function get($id) { global $user; + $replaceDecimalMark = ('.' != $user->decimal_mark); $mdb2 = getConnection(); @@ -42,8 +43,11 @@ class ttPredefinedExpenseHelper { $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { $val = $res->fetchRow(); - if ($val && $val['id']) + if ($val && $val['id']) { + if ($replaceDecimalMark) + $val['cost'] = str_replace('.', $user->decimal_mark, $val['cost']); return $val; + } } return false; } @@ -65,11 +69,15 @@ class ttPredefinedExpenseHelper { // insert function inserts a new predefined expense into database. static function insert($fields) { + global $user; + $mdb2 = getConnection(); $team_id = (int) $fields['team_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).")"; @@ -83,12 +91,16 @@ class ttPredefinedExpenseHelper { // update function - updates a predefined expense in database. static function update($fields) { + global $user; + $mdb2 = getConnection(); $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";