select gb.BOX_ID,        gb.MEMBER_ID,        gb.GOODS_ID,        gb.GOODS_NAME,        gb.GOODS_AMOUNT,        gb.BEGIN_DATE,        gb.END_DATE,        gb.IS_ENABLE,        gb.GIFT_STATE,        gb.GIFT_PRICE,        gb.GIFT_POINTS,        gb.ASSIGN_TIME,        gb.USED_TIME,        gb.MULTI_TYPE,        gb.ORDER_ID,        gb.IS_SHOPCART,        g.GOODS_NO,        m.login_name,        (select PRO_IMAGE_URL from product_img pi where pi.product_id = g.product_id        and pi.image_type = 'small' and rownum = 1) proImageUrl,        pb.product_brand_name as packageStandard        from GIFT_BOX gb        left join goods g on gb.goods_id = g.goods_id        LEFT JOIN MEMBER m ON gb.member_id = m.member_id AND m.is_delete = 'N'        left join product p on g.product_id = p.product_id        left join product_brand pb on p.product_brand_id = pb.product_brand_id        where gb.is_delete = 'N'                    and gb.BOX_ID=#{boxId}                            and gb.MEMBER_ID=#{memberId}                            and gb.GOODS_ID=#{goodsId#{                            and gb.GOODS_NAME like '%${goodsName}%'                
                          and gb.IS_ENABLE=#{isEnable}                            and gb.GIFT_STATE=#{giftState}                            and gb.MULTI_TYPE=#{multiType}                            and gb.ORDER_ID=#{orderId}                            and g.GOODS_NO=#{goodsNo}                            and gb.IS_SHOPCART=#{isShopcart}                            and m.login_name=#{loginName#{                            and to_date(gb.ASSIGN_TIME,'YYYY-MM-DD HH24:mi:ss') >=            to_date(#{assignBeginTime}||' 00:00:00','YYYY-MM-DD HH24:mi:ss')                            and to_date(gb.ASSIGN_TIME,'YYYY-MM-DD HH24:mi:ss') <=            to_date(#{assignEndTime}||' 23:59:59','YYYY-MM-DD HH24:mi:ss')                            and to_date(gb.USED_TIME,'YYYY-MM-DD HH24:mi:ss') >=            to_date(#{usedBeginTime}||' 00:00:00','YYYY-MM-DD HH24:mi:ss')                            and to_date(gb.USED_TIME,'YYYY-MM-DD HH24:mi:ss') <=            to_date(#{usedEndTime}||' 23:59:59','YYYY-MM-DD HH24:mi:ss')                            and to_date(gb.END_DATE,'YYYY-MM-DD HH24:mi:ss') <=            to_date(#{overdue}||' 00:00:00','YYYY-MM-DD HH24:mi:ss')            

for (GiftBox giftBox : giftBoxList) {                    java.util.Date nowdate = new java.util.Date();                    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");                    //未过期的礼品                    if (sdf.parse(giftBox.getEndDate()).before(nowdate) == false) {                        // 查询商品                        Goods goods = getGoodsInfoByIdForShopcart(giftBox.getGoodsId());                        goods.setBoxId(giftBox.getBoxId());                        goods.setOrderAmount(giftBox.getGoodsAmount());                        goods.setPromotePhrase(null);                        goods.setFinalPrice(new BigDecimal(0.00));                        goods.setSumPrice(new BigDecimal(0.00));                        goodsList.add(goods);                    }                }