package com.foshanshop.ejb3.impl;

import java.util.Date;
import java.util.List;

import javax.ejb.Remote;
import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;

import com.foshanshop.ejb3.OrderDAO;
import com.foshanshop.ejb3.bean.Order;
import com.foshanshop.ejb3.bean.OrderItem;

@Stateless
@Remote ({OrderDAO.class})
public class OrderDAOBean implements OrderDAO {
    @PersistenceContext
    protected EntityManager em;
    
    public void insertOrder(){
        Order order = new Order();
        order.setCreatedate(new Date());
        order.addOrderItem(new OrderItem("筆記本電腦", new Float(13200.5)));
        order.addOrderItem(new OrderItem("U盤", new Float(620)));
        order.setAmount(new Float(13200.5+620));
        em.persist(order);
    }

    public Order getOrderByID(Integer orderid) {
       Order order =  em.find(Order.class, orderid);        
       order.getOrderItems().size();
       //因為是延遲加載，通過執行size()這種方式獲取訂單下的所有訂單項
       return order;
    }

    public List getAllOrder() {
        Query query = em.createQuery("select o from Order o inner join fetch o.orderItems order by o.orderid");
        List result = query.getResultList();
        return result;
    }

}