X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/7410339cd9812d0eb37bf94b51dab13158e77c0e..3e7b58457f94c49a154b2f108f0188682a114aa2:/WEB-INF/lib/ttExpenseHelper.class.php diff --git a/WEB-INF/lib/ttExpenseHelper.class.php b/WEB-INF/lib/ttExpenseHelper.class.php index c41a1416..ff7879c3 100644 --- a/WEB-INF/lib/ttExpenseHelper.class.php +++ b/WEB-INF/lib/ttExpenseHelper.class.php @@ -56,6 +56,7 @@ class ttExpenseHelper { // update - updates a record in tt_expense_items table. static function update($fields) { + global $user; $mdb2 = getConnection(); $id = (int) $fields['id']; @@ -67,9 +68,14 @@ class ttExpenseHelper { $cost = str_replace(',', '.', $fields['cost']); $invoice_id = $fields['invoice_id']; + $paid_part = ''; + if ($user->canManageTeam() && $user->isPluginEnabled('ps')) { + $paid_part = $fields['paid'] ? ', paid = 1' : ', paid = 0'; + } + $sql = "UPDATE tt_expense_items set date = ".$mdb2->quote($date).", user_id = $user_id, client_id = ".$mdb2->quote($client_id). ", project_id = ".$mdb2->quote($project_id).", name = ".$mdb2->quote($name). - ", cost = ".$mdb2->quote($cost).", invoice_id = ".$mdb2->quote($invoice_id). + ", cost = ".$mdb2->quote($cost)."$paid_part, invoice_id = ".$mdb2->quote($invoice_id). " WHERE id = $id"; $affected = $mdb2->exec($sql); @@ -122,7 +128,7 @@ class ttExpenseHelper { if ($user->isPluginEnabled('cl')) $left_joins .= " left join tt_clients c on (ei.client_id = c.id)"; - $sql = "select ei.id, ei.date, ei.client_id, ei.project_id, ei.name, ei.cost, ei.invoice_id $client_field, p.name as project_name + $sql = "select ei.id, ei.date, ei.client_id, ei.project_id, ei.name, ei.cost, ei.invoice_id, ei.paid $client_field, p.name as project_name from tt_expense_items ei $left_joins where ei.id = $id and ei.user_id = $user_id and ei.status = 1";