- 1 create or replace procedure bb_quxzbmjdqzxfqk_ces(kssj in date, 2 jssj 3 wtsd2 varchar2,128);"> 4 tjjg out sys_refcursor) as
- 5
- 6 begin
- 7 delete from A_TJBB_quxzbmjdqzxfqk;
- 8 commit;
- 9 insert into A_TJBB_quxzbmjdqzxfqk
- 10 select jj.iidd,jj.isedit,jj.djjgbh,jj.cfxfjbz,jj.lmbz,jj.xfrs,jj.xfxs from visit_xfj jj,128);">11 hr_organization n where n.jglb='1200' and n.region_dm=wtsd2 and n.bh=jj.djjgbh and jj.djsj between kssj and jssj;
- 12 13 open tjjg for
- 14
- 15
- 16 select l.mc as mc,128);">17 count(1) as jianci,128);">18 sum(case when xf.xfxs100' then 1 else
- 19 200then xf.xfrs 20 when xf.xfxs in (300',303') 1
- 21 else 0 end end) as rci,128);">22 and xf.lmbz0'and xf.cfxfjbzend)as grlx,128);">23 1as lmx,128);">24 as cfgrlx,128);">25 as cflmx,128);">26 as xiaojie,128);">27 and xf.xfrs<=4 as c1lfcjjc,128);">28 as c1lfcjrc,128);">29 and( xf.xfrs>=5 49) as c5lfcjjc,128);">30 as c5lfcjrc,128);">31 50 499) as c50lfcjjc,128);">32 then xf.xfrs as c50lfcjrc,128);">33 500 as c500lfcjjc,128);">34 as c500lfcjrc,128);">35 as cf1lfcjjc,128);">36 as cf1lfcjrc,128);">37 as cf5lfcjjc,128);">38 as cf5lfcjrc,128);">39 as cf50lfcjjc,128);">40 as cf50lfcjrc,128);">41 as cf500lfcjjc,128);">42 as cf500lfcjrc,128);">43 as lxxiaojjc,128);">44 as lxxiaojrc,128);">45 in(') as grts,128);">46 as lmts,128);">47
- 48 as cfgrts,128);">49
- 50 as cflmts,128);">51 as xiaoji
- 52
- 53 from hr_organization l,A_TJBB_quxzbmjdqzxfqk xf where l.jglband l.region_dm500101and l.bh=xf.djjgbh group by l.mc;
- 54
- 55 end bb_quxzbmjdqzxfqk_ces;
————————————————————————————————————————————————————————————————————
- 4 isquxian 5 tjjg out GLOBALPKG.RCT1) 6
- 7 8 v_kssj1 :=kssj;
- 9 v_jssj1 :=jssj;
- 10 11
- 12
- 13 14 15 16 18 19 20 21 44
- 46
- 47 50 where l.region_dmand ((v_kssj1 is not null and j.adddatetime between v_kssj1 and v_jssj1)
- 51 or (v_kssj1 not nulll and 1=1)) and((isquxian and ion.dm = isquxian ) or (isquxian is 1 = 1)) and l.jglband
- 53 l.bhend bb_quxzbmjdqzxfqk_ces;
