- $mdb2 = getConnection();
-
- if (ROLE_CLIENT == $user->role && $user->client_id)
- $client_part = " and i.client_id = $user->client_id";
-
- $sql = "select i.id, i.name, i.date, i.client_id, i.status, c.name as client_name from tt_invoices i
- left join tt_clients c on (c.id = i.client_id)
- where i.status = 1 and i.team_id = $user->team_id $client_part order by i.name";
+ $mdb2 = getConnection();
+
+ if (ROLE_CLIENT == $user->role && $user->client_id)
+ $client_part = " and i.client_id = $user->client_id";
+
+ $sql = "select i.id, i.name, i.date, i.client_id, i.status, c.name as client_name from tt_invoices i
+ left join tt_clients c on (c.id = i.client_id)
+ where i.status = 1 and i.team_id = $user->team_id $client_part order by i.name";