1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
public class CallDao extends HibernateDaoSupport implements ICallDao{
public List getInformationAboutClient(Long rntAgrNbr, String regNbr, Date date ,String dvrSrnm){
if ((date==null)||(regNbr==null&&rntAgrNbr==null)){
throw new IllegalArgumentException(" Date is mandatory ,regNbr and rntAgrNbr must not both null .");
}
else {
return (List) super.getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(org.hibernate.Session session)
throws HibernateException, SQLException {
return session.createSQLQuery(
"select rn.rnt_agr_nbr,v.reg_nbr,vm.co_tmsp,vm.CI_TMSP,vm.sta_stn_id_chk_in,vm.STA_STN_ID_CHK_OUT,rn.RNT_AGR_STAT,dr.DVR_FRST_NAME||''||dr.DVR_SRNM,ad.ADDR_LN1,ad.ADDR_LN2,ad.ADDR_LN3,ad.ADDR_LN4,ad.ADDR_LN4,ad.CIT,ad.POST_CD,ad.ST_CTY_PROV,dv.DVR_DT_OF_BRTH,dl.LIC_NBR,bs.ACCT_ID,bs.ACCT_NAME,tel.NBR, cn.CNTCT_FRST_NAME,rra.INT_INS_TYP_ID||''||ins.INS_TYP_DESC,mo.MOD_ID,mo.CRY_MOD_LONG_DESC " +
"FROM vhcls v,vhcl_mvs vm,rnt_agrs rn,dvr_rras dr,dvrs dv,dvg_lics dl,bus_acnts bs,addrs ad,appr_pnts ap,tel_nbrs tel,cntcts cn,vhcl_cry_mods mo,rra_ins rra,ins_typs ins"+
"where tel.APP_APP_APPROACH_SEQUENCE=ap.APP_APPROACH_SEQUENCE "+
"and ad.ADDR_NBR=ap.APP_ADDR_NBR"+
"and ap.APP_DVR_ID=dv.DVR_ID"+
"and dl.DRV_DVR_ID=dv.DVR_ID" +
"and bs.DRV_DVR_ID_HLDR=dv.DVR_ID" +
"and dv.DVR_ID=dr.DRV_DVR_ID" +
"and dr.RDY_RNT_AGR_NBR=rn.RNT_AGR_NBR" +
"and v.VMO_MOD_ID=mo.MOD_ID" +
"and vm.VHCL_VHCL_UNIT_NBR=v.VHCL_UNIT_NBR" +
"and vm.MV_SEQ_NBR=v.VHM_MV_SEQ_NBR"+
"and rn.RNT_AGR_NBR=vm.RDY_RNT_AGR_NBR " +
"and rra.RDY_RNT_AGR_NBR=rn.RNT_AGR_NBR " +
"and ins.CRY_ARIMP_CRY_CD=rra.INT_CRY_ARIMP_CRY_CD " +
"and ins.INS_TYP_ID=rra.INT_INS_TYP_ID "+
"and dr.MAIN_DVR_FLG in ('MR','M')"+
"and dv.DVR_SRNM='JASTRZEBSKI'"+
"and rn.RNT_AGR_NBR='1049355520'"+
"and v.REG_NBR='HH-CT7575'"+
"and TO_DATE('06/02/2008', 'DD/MM/YYYY') between vm.CO_TMSP and vm.CI_TMSP" +
"and vm.REV_NBR=0").list();
}
});
}
}
} |
