- $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";
+ $sql = "select ei.id, ei.date, ei.client_id, ei.project_id, ei.name, ei.cost, ei.invoice_id, ei.approved,".
+ " ei.paid $client_field, p.name as project_name".
+ " from tt_expense_items ei $left_joins".
+ " where ei.id = $id and ei.group_id = $group_id and ei.org_id = $org_id and ei.user_id = $user_id and ei.status = 1";