论坛 › 《上古卷轴5：天际重制版》MOD区 › 【3DM创意工坊】+新怪物模組+ JackGa Monster SE ver 1.01 (安全模組)

diea0000 发表于 2019-5-8 10:38

111111111111

sstey 发表于 2019-5-9 12:30

6666666666666

fc790 发表于 2019-5-10 12:25

传奇版就在用

LOVEEXO-K 发表于 2019-5-11 19:55

666666666666666

黄伟健 发表于 2019-5-12 23:10

111111111111111111111111111111111

游荡小枪 发表于 2019-6-5 00:30

666666666666

abof 发表于 2019-6-10 19:37

感谢分享

tufei1110 发表于 2019-7-3 14:34

感谢分享，支持支持

omega9999 发表于 2019-7-3 16:02

GOOD.........

jefftiee 发表于 2019-7-6 17:14

thank you very much

强袭号令 发表于 2019-7-6 17:40

EMMMMMMMMMM

wc5200803 发表于 2019-7-13 22:03

666666666666666

From_Past_to_Pr 发表于 2019-7-22 03:40

的顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶

p03l2 发表于 2019-7-25 10:04

怪物模组相関+1

zxcvvc 发表于 2019-7-25 17:38

666666666666

小探飞云 发表于 2019-8-3 19:22

谢谢分享

brodee 发表于 2019-8-5 15:59

666666666

260248556 发表于 2019-8-5 18:50

bmnxvhmbxv

神經大条 发表于 2019-8-5 19:45

fgfcgsd fg dsgd

給卟起了ゞ就敷 发表于 2019-8-5 21:17

支持支持！！！！！！

Heartattack_ 发表于 2019-8-5 21:17

6666666666

冲开水 发表于 2019-8-13 20:12

ipt, 只是發揮遊戲本體的script, 安全模組 (姐相信...)

開始新遊戲會較容易碰見新怪物

后蜉蝣子 发表于 2019-8-27 11:23

感谢分享哟

fengkewei01200 发表于 2019-8-29 09:09

让他今天衣裤架

疯狂的逆天小伙 发表于 2019-8-30 08:09

666666666666666

wzsgdsg 发表于 2019-9-29 20:36

gaimimasiquanjiagaimimasiquanjia

尛ǒ花貓 发表于 2019-10-13 23:37

6666666666666666666666

a1693353865 发表于 2019-10-15 12:51

6666666666

tieshao79 发表于 2019-10-25 12:51

感谢分享 大佬6666

idave 发表于 2019-10-25 13:49

select城市, saName, Homerid,count(*)
from
(

select s.calluuid as 话务标记，s.ani as 主叫, s.dnis as 被叫, b.city as 城市, s.arrived_time as 拨打时间,

s.answer_time as 接通时间，s.release_time as 挂断时间,

EXTRACT(SECOND FROM(s.release_time-s.arrived_time)) as TTT,

s.t_handle 通话时间, s.release_code as 挂断方 ,
s.ud_1 as idLeadEmp,s.ud_2 as idLead,s.ud_3 as homerId,s.ud_4 as saName,
s.ud_5 as leadStatus,s.ud_6 as posCode,s.ud_7 as productType,s.ud_8 as customerName,s.ud_9 as customerPhoneNumber,s.ud_10 as loanLimit
from SIP_RECORD s join qqzeng b on substr(s.DNIS,0,7)=b.phone

where release_code='3 Unknown' and arrived_time > to_date('2019-10-1 00:00:00','yyyy-mm-dd hh24:mi:ss') and EXTRACT(SECOND FROM(release_time-arrived_time))>1

) group by HOMERID,saName,城市 order by 1,4 desc
select城市, saName, Homerid,count(*)
from
(

select s.calluuid as 话务标记，s.ani as 主叫, s.dnis as 被叫, b.city as 城市, s.arrived_time as 拨打时间,

s.answer_time as 接通时间，s.release_time as 挂断时间,

EXTRACT(SECOND FROM(s.release_time-s.arrived_time)) as TTT,

s.t_handle 通话时间, s.release_code as 挂断方 ,
s.ud_1 as idLeadEmp,s.ud_2 as idLead,s.ud_3 as homerId,s.ud_4 as saName,
s.ud_5 as leadStatus,s.ud_6 as posCode,s.ud_7 as productType,s.ud_8 as customerName,s.ud_9 as customerPhoneNumber,s.ud_10 as loanLimit
from SIP_RECORD s join qqzeng b on substr(s.DNIS,0,7)=b.phone

where release_code='3 Unknown' and arrived_time > to_date('2019-10-1 00:00:00','yyyy-mm-dd hh24:mi:ss') and EXTRACT(SECOND FROM(release_time-arrived_time))>1

) group by HOMERID,saName,城市 order by 1,4 desc
select城市, saName, Homerid,count(*)
from
(

select s.calluuid as 话务标记，s.ani as 主叫, s.dnis as 被叫, b.city as 城市, s.arrived_time as 拨打时间,

s.answer_time as 接通时间，s.release_time as 挂断时间,

EXTRACT(SECOND FROM(s.release_time-s.arrived_time)) as TTT,

s.t_handle 通话时间, s.release_code as 挂断方 ,
s.ud_1 as idLeadEmp,s.ud_2 as idLead,s.ud_3 as homerId,s.ud_4 as saName,
s.ud_5 as leadStatus,s.ud_6 as posCode,s.ud_7 as productType,s.ud_8 as customerName,s.ud_9 as customerPhoneNumber,s.ud_10 as loanLimit
from SIP_RECORD s join qqzeng b on substr(s.DNIS,0,7)=b.phone

where release_code='3 Unknown' and arrived_time > to_date('2019-10-1 00:00:00','yyyy-mm-dd hh24:mi:ss') and EXTRACT(SECOND FROM(release_time-arrived_time))>1

) group by HOMERID,saName,城市 order by 1,4 desc
select城市, saName, Homerid,count(*)
from
(

select s.calluuid as 话务标记，s.ani as 主叫, s.dnis as 被叫, b.city as 城市, s.arrived_time as 拨打时间,

s.answer_time as 接通时间，s.release_time as 挂断时间,

EXTRACT(SECOND FROM(s.release_time-s.arrived_time)) as TTT,

s.t_handle 通话时间, s.release_code as 挂断方 ,
s.ud_1 as idLeadEmp,s.ud_2 as idLead,s.ud_3 as homerId,s.ud_4 as saName,
s.ud_5 as leadStatus,s.ud_6 as posCode,s.ud_7 as productType,s.ud_8 as customerName,s.ud_9 as customerPhoneNumber,s.ud_10 as loanLimit
from SIP_RECORD s join qqzeng b on substr(s.DNIS,0,7)=b.phone

where release_code='3 Unknown' and arrived_time > to_date('2019-10-1 00:00:00','yyyy-mm-dd hh24:mi:ss') and EXTRACT(SECOND FROM(release_time-arrived_time))>1

) group by HOMERID,saName,城市 order by 1,4 desc

查看完整版本: 【3DM创意工坊】+新怪物模組+ JackGa Monster SE ver 1.01 (安全模組)