public ArrayList shoppingCartt() {

        ArrayList al = new ArrayList();
        Query n = em.createQuery("SELECT t from SHSMember t");
        System.out.println(username);
        for (Object o : n.getResultList()) {
            SHSMemberEntity s = (SHSMemberEntity) o;
            System.out.println("test: " + s.getPersonId());
            if (s.getPersonId().equals(null)) {

            } else if (s.getPersonId().equals(username)) {
                System.out.println("succeed");

                Collection<BookingEntity> temp2 = s.getBooking();
                System.out.println(temp2.size());
                Iterator itr = temp2.iterator();

                while (itr.hasNext()) {
                    BookingEntity element = (BookingEntity) itr.next();
                    if (element.getStatus().equals("unpaid")) {

                        Collection<RoomEntity> temp3 = element.getRooms();

                        Iterator itr2 = temp3.iterator();

                        while (itr2.hasNext()) {
                            RoomEntity element2 = (RoomEntity) itr2.next();
                            al.add(element2.getRoomNumber());
                        }

                    }
                    //System.out.println("display temp: " + temp + " " + element.getRoomNumber());
                }
                
            }
        }
        System.out.println(al);
        return al;
    }