package com.ld.igds.m.service;

import com.bstek.bdf2.core.orm.hibernate.HibernateDao;
import com.ld.igds.models.Grain;
import com.ld.igds.util.ContextUtil;
import com.ld.igds.util.DateUtil;
import org.springframework.stereotype.Component;

import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * @author chen
 */
@Component
public class HGrainSupportService extends HibernateDao {


    public List<Grain> listGrain(String depotId,Date start,Date end){
        String hql = " from " + Grain.class.getName()
                + " where companyId =:companyId";

        Map<String,Object> args = new HashMap<String,Object>();
        args.put("companyId",ContextUtil.getCompanyId());

        hql += " and depotId like:depotId";
        args.put("depotId", depotId);

        hql += " and receiveDate >=:start";
        args.put("start", DateUtil.getCurZero(start));

        hql += " and receiveDate <=:end";
        args.put("end", DateUtil.getNextZero(end));

        hql += " order by receiveDate desc";

        return this.query(hql, args);
    }
}