// TODO This should probably be "get order by status"
@Override
public List<Order> getAllOrderedPaidOrders() {
StatusDAO sdao = new StatusDAOJpaImpl();
Status s = sdao.getStatusById(3);
@SuppressWarnings("unchecked")
List<Order> results = em
.createQuery(
"SELECT o FROM Order o INNER JOIN o.status s WHERE s.status != ?1")
.setParameter(1, s.getStatus()).getResultList();
// LazyLoading error workaround
for (Order o : results) {
o.getCustomer();
o.getOrderLines().size();