【Begin】 2021-01-24 15:30:53 192.168.109.11
TwiAjaxHelper.GetResult开始调用...
【Info】 2021-01-24 15:30:53 192.168.109.11
请求信息:
mn:TKT
cn:_RecordNumber
mn2:AddRecordNumber
对应参数:
data:
0129001
天池山大门
成人
100
2021-01-24 00:00:00
TCSSP001
TCSSP001
【Debugger】 2021-01-24 15:30:53 192.168.109.11
SQL语句:insert into TKT_RECORDNUMBER(fid, PARKCODE, PARKFULLNAME,recorddate,totalcount,clienttypename,remark,create_optorcode,create_optorname,modified_optorcode,modified_optorname,create_time,modified_time)
values('12AFFD944C8D46F4BA6FFA7C054C757D','0129001','天池山大门',to_date('2021/1/24 0:00:00','yyyy-MM-dd hh24:mi:ss'),'100','成人','','TCSSP001','TCSSP001','TCSSP001','TCSSP001',SYSDATE,SYSDATE)
SQL语句参数:
【Info】 2021-01-24 15:30:53 192.168.109.11
返回结果:
true
录入成功!
【End】 2021-01-24 15:30:53 192.168.109.11
TwiAjaxHelper.GetResult执行完成!
=================================================================
【Begin】 2021-01-24 15:56:18 192.168.109.11
TwiAjaxHelper.GetResult开始调用...
【Info】 2021-01-24 15:56:18 192.168.109.11
请求信息:
mn:TKT
cn:PageCommon
mn2:GetXmlBySimpleCondition
对应参数:
data:{"Version":"Base_GetSettle_C","TableName":"TKT_OPTORBALANCE","SelectFields":"FID, CREATE_OPTORCODE AS OPTORCODE,BALANCEDATE,CREATE_OPTORNAME AS OPTORNAME,PARKCODE","Condition":{"CREATE_OPTORCODE":"TCSSP001"},"SimpleCondition":{"Field":"BALANCEDATE","Value":"2021-01-24","COperator":"Equals","DataType":6}}
【Debugger】 2021-01-24 15:56:18 192.168.109.11
SQL语句:select * from WEB_TKT_TABLEMAPPING
SQL语句参数:无。
【Debugger】 2021-01-24 15:56:18 192.168.109.11
SQL语句:select FID, CREATE_OPTORCODE AS OPTORCODE,BALANCEDATE,CREATE_OPTORNAME AS OPTORNAME,PARKCODE from TKT_OPTORBALANCE where CREATE_OPTORCODE=:CREATE_OPTORCODE and BALANCEDATE = :BALANCEDATE
SQL语句参数(共2个):
{"ParameterName:"CREATE_OPTORCODE","Value":"TCSSP001","DbType":"String"},
{"ParameterName:"BALANCEDATE","Value":"2021/1/24 0:00:00","DbType":"DateTime"}
【Info】 2021-01-24 15:56:18 192.168.109.11
返回结果TwiReturn对象,序列化后为:
{"id":null,"code":null,"success":true,"hasRight":true,"rightName":null,"knowError":100,"errors":null,"message":"操作成功!","data":{"FirstAttribute":null,"HasAttributes":false,"HasElements":false,"IsEmpty":true,"LastAttribute":null,"Name":{"LocalName":"ItemList","Namespace":{"NamespaceName":""},"NamespaceName":""},"NodeType":1,"Value":"","FirstNode":null,"LastNode":null,"NextNode":null,"PreviousNode":null,"BaseUri":"","Document":null,"Parent":null},"totalCount":0,"affRows":0,"stamp":null,"list":[]}
【End】 2021-01-24 15:56:18 192.168.109.11
TwiAjaxHelper.GetResult执行完成!
=================================================================
【Begin】 2021-01-24 15:56:18 192.168.109.11
TwiAjaxHelper.GetResult开始调用...
【Info】 2021-01-24 15:56:18 192.168.109.11
请求信息:
mn:TKT
cn:OptorDateRD
mn2:Base_GetCanSettle
对应参数:
data:- 2021-01-24T15:56:22.3496998+08:00
【Debugger】 2021-01-24 15:56:18 192.168.109.11
SQL语句:select ParamValue from sys_param where PARAMCODE='5007'
SQL语句参数:
【Info】 2021-01-24 15:56:18 192.168.109.11
返回结果TwiReturn对象,序列化后为:
{"id":null,"code":null,"success":true,"hasRight":true,"rightName":null,"knowError":100,"errors":null,"message":"操作成功!","data":"序列化类型为“System.Xml.Linq.XElement”的对象时检测到循环引用。","totalCount":0,"affRows":0,"stamp":null,"list":[]}
【End】 2021-01-24 15:56:18 192.168.109.11
TwiAjaxHelper.GetResult执行完成!
=================================================================
【Begin】 2021-01-24 15:56:18 192.168.109.11
TwiAjaxHelper.GetResult开始调用...
【Info】 2021-01-24 15:56:18 192.168.109.11
请求信息:
mn:TKT
cn:PageCommon
mn2:GetXMLBySQLMap
对应参数:
data:{"Code":"Base_GetRDMData_C_cmd_02401","SQLMapFile":"CmdSQLMap.config","Parameters":{"OPTORCODE":"TCSSP001","BALANCEFLAG":0}}
【Debugger】 2021-01-24 15:56:18 192.168.109.11
SQL语句:
select case when T.TradeType ='01'then'正常售票'when T.TradeType='02'then'退票' when T.TradeType='04'then'预售票' else'其它'end as TRADETYPENAME,
case when T.ClientType='01' and T.salemodel !='03' then'散客' when T.ClientType='01' and T.salemodel='03' then'电商' when T.ClientType='02'then'团队' when T.ClientType='03'then'政府部门'when T.ClientType='04'then'企事业单位'else''end as CLIENTTYPENAME,
T.payTypeName,V.TICKETMODELGROUPNAME,K.TICKETMODELKINDNAME,V.TICKETMODELNAME||'('||V.BARCODETYPE||')' as TICKETMODELNAME,T.TICKETCOUNT,T.TICKETNOCOUNT,T.TICKETMODELPRICE,T.differenceprice,T.PAYSUM
from(
select A.ClientType,A.paytypeCode,A.payTypeName,A.salemodel,B.TicketModelCode,B.TicketModelKind, B.TradeType,
B.TicketModelPrice,b.differenceprice,sum(TicketCount)as TicketCount,sum(ticketnocount) as ticketnocount,sum(PaySum)as PaySum
from
(select TradeID,ClientType,balanceflag,paytypeCode,payTypeName,salemodel from tkt_trademain
where tradetype <>'04' and tradetype<>'07' and tradedate'04' and c.tradetype<>'07' and c.tradedateMAX(BARCODE) THEN MIN(BARCODE)||'-'||MAX(BARCODE) ELSE MIN(BARCODE) END AS BARCODES
,Count(barcode) as BARCODECOUNT,flag,barcodetype,FCOUNT,
Count(barcode)*FLAG*FCOUNT as SELLCOUNT,case flag when 1 then '销售条码' when -1 then '退票条码' when 0 then '销售后退票条码' else '其它' end as FLAGNAME
FROM (
SELECT D.BARCODE,d.FCOUNT,flag,barcodetype
--,REGEXP_SUBSTR(D.BARCODE,'[0-9]+') - ROW_NUMBER() OVER(ORDER BY D.flag,d.barcodetype,d.FCOUNT,D.BARCODE)+1 AS GROUPNO
FROM (
select d.barcode,barcodetype,d.flag,d.FCOUNT from (
select barcode,ticketmodel,FLAG,count(1) FCOUNT from (
select ftradeid as tradeid,barcode,fticketmodelcode as ticketmodel,1 as FLAG from tkt_tradebarcode d1
where exists(select 1 from tkt_trademain m where m.tradetype <>'04' and m.tradetype<>'07' and m.tradedate'02'
and m.balanceflag=:BALANCEFLAG and m.CREATE_OPTORCODE=:OPTORCODE
and m.tradeid = d1.ftradeid)
group by d1.ftradeid,d1.barcode,d1.fticketmodelcode
) group by barcode,ticketmodel,FLAG
union all
select barcode,ticketmodel,FLAG,count(1) FCOUNT from (
select ftradeid as tradeid,barcode,fticketmodelcode as ticketmodel,case max(fuseflag) when 1 then -1 else 1 end as FLAG from tkt_tradebarcode d2
where exists(select 1 from tkt_trademain m where m.tradetype ='02'
and m.balanceflag=:BALANCEFLAG and m.CREATE_OPTORCODE=:OPTORCODE
and m.tradeid = d2.fretradeid)
group by d2.ftradeid,d2.barcode,d2.fticketmodelcode
) group by barcode,ticketmodel,FLAG
)D
left join sys_ticketmodel s on d.ticketmodel=s.ticketmodelcode
GROUP BY BARCODE,barcodetype,flag,FCOUNT
)D order by flag,BARCODE
)A GROUP BY barcodetype,flag,FCOUNT--,GROUPNO
)D
left join sto_tickettype t on d.barcodetype=t.barcodetype
order by -d.flag,d.barcodetype,barcodes
SQL语句参数(共4个):
{"ParameterName:"BALANCEFLAG","Value":"0","DbType":"Int32"},
{"ParameterName:"OPTORCODE","Value":"TCSSP001","DbType":"String"},
{"ParameterName:"BALANCEFLAG","Value":"0","DbType":"Int32"},
{"ParameterName:"OPTORCODE","Value":"TCSSP001","DbType":"String"}
【Info】 2021-01-24 15:56:20 192.168.109.11
返回结果TwiReturn对象,序列化后为:
{"id":null,"code":null,"success":true,"hasRight":true,"rightName":null,"knowError":100,"errors":null,"message":"操作成功!","data":"序列化类型为“System.Xml.Linq.XElement”的对象时检测到循环引用。","totalCount":0,"affRows":0,"stamp":null,"list":[]}
【End】 2021-01-24 15:56:20 192.168.109.11
TwiAjaxHelper.GetResult执行完成!
=================================================================
【Begin】 2021-01-24 15:56:20 192.168.109.11
TwiAjaxHelper.GetResult开始调用...
【Info】 2021-01-24 15:56:20 192.168.109.11
请求信息:
mn:TKT
cn:PageCommon
mn2:GetXMLBySQLMap
对应参数:
data:{"Code":"Base_GetRDMData_C_cmd_03201","SQLMapFile":"CmdSQLMap.config","Parameters":{"OPTORCODE":"TCSSP001","BALANCEFLAG":0}}
【Debugger】 2021-01-24 15:56:20 192.168.109.11
SQL语句:
SELECT D.*,t.tickettypename FROM(
SELECT CASE WHEN MIN(BARCODE)<>MAX(BARCODE) THEN MIN(BARCODE)||'-'||MAX(BARCODE) ELSE MIN(BARCODE) END AS BARCODES
,Count(barcode) as BARCODECOUNT,flag,barcodetype,FCOUNT,
Count(barcode)*FLAG*FCOUNT as SELLCOUNT,case flag when 1 then '销售条码' when -1 then '退票条码' when 0 then '销售后退票条码' else '其它' end as FLAGNAME
FROM (
SELECT D.BARCODE,d.FCOUNT,flag,barcodetype
--,REGEXP_SUBSTR(D.BARCODE,'[0-9]+') - ROW_NUMBER() OVER(ORDER BY D.flag,d.barcodetype,d.FCOUNT,D.BARCODE)+1 AS GROUPNO
FROM (
select d.barcode,barcodetype,d.flag,d.FCOUNT from (
select barcode,ticketmodel,FCOUNT,case when FCOUNT<=0 then -1 else 1 end as FLag from
(
select barcode,ticketmodel,sum(FLAG*FCOUNT) as FCOUNT,tradetype from
(
select barcode,ticketmodel,FLAG,count(1) FCOUNT,tradetype from (
select ftradeid as tradeid,barcode,fticketmodelcode as ticketmodel,1 as FLAG,tradetype from tkt_tradebarcode d1
where exists(select 1 from tkt_trademain m where m.tradetype <>'04' and m.tradetype<>'07' and m.tradedate'02'
and m.balanceflag=:BALANCEFLAG and m.CREATE_OPTORCODE=:OPTORCODE
and m.tradeid = d1.ftradeid)
group by ftradeid,barcode,fticketmodelcode,tradetype
) group by barcode,ticketmodel,FLAG,tradetype
union all
select barcode,ticketmodel,FLAG,count(1) FCOUNT,tradetype from (
select ftradeid as tradeid,barcode,fticketmodelcode as ticketmodel,case max(fuseflag) when 1 then -1 else 1 end as FLAG,tradetype from tkt_tradebarcode d2
where exists(select 1 from tkt_trademain m where m.tradetype ='02'
and m.balanceflag=:BALANCEFLAG and m.CREATE_OPTORCODE=:OPTORCODE
and m.tradeid = d2.fretradeid)
group by ftradeid,barcode,fticketmodelcode,tradetype
) group by barcode,ticketmodel,FLAG,tradetype
)group by barcode,ticketmodel,tradetype
) --where FCOUNT!=0
)D
left join sys_ticketmodel s on d.ticketmodel=s.ticketmodelcode
GROUP BY BARCODE,barcodetype,flag,FCOUNT
)D order by flag,BARCODE
)A GROUP BY barcodetype,flag,FCOUNT--,GROUPNO
)D
left join sto_tickettype t on d.barcodetype=t.barcodetype
order by -d.flag,d.barcodetype,barcodes
SQL语句参数(共4个):
{"ParameterName:"BALANCEFLAG","Value":"0","DbType":"Int32"},
{"ParameterName:"OPTORCODE","Value":"TCSSP001","DbType":"String"},
{"ParameterName:"BALANCEFLAG","Value":"0","DbType":"Int32"},
{"ParameterName:"OPTORCODE","Value":"TCSSP001","DbType":"String"}
【Info】 2021-01-24 15:56:22 192.168.109.11
返回结果TwiReturn对象,序列化后为:
{"id":null,"code":null,"success":true,"hasRight":true,"rightName":null,"knowError":100,"errors":null,"message":"操作成功!","data":"序列化类型为“System.Xml.Linq.XElement”的对象时检测到循环引用。","totalCount":0,"affRows":0,"stamp":null,"list":[]}
【End】 2021-01-24 15:56:22 192.168.109.11
TwiAjaxHelper.GetResult执行完成!
=================================================================
【Begin】 2021-01-24 15:56:22 192.168.109.11
TwiAjaxHelper.GetResult开始调用...
【Info】 2021-01-24 15:56:22 192.168.109.11
请求信息:
mn:TKT
cn:PageCommon
mn2:GetXMLBySQLMap
对应参数:
data:{"Code":"Base_GetRDMData_CS_cmd2_011","SQLMapFile":"CmdSQLMap2.config","Parameters":{"OPTORCODE":"TCSSP001"}}
【Debugger】 2021-01-24 15:56:22 192.168.109.11
SQL语句:
with lastsettledate as(
select nvl(max(t.audittime),to_date('2014-08-11','yyyy-mm-dd')) as settledate from tkt_optorbalance t where t.CREATE_OPTORCODE=:OPTORCODE
)
select t.tickettypecode,t.tickettypename,t.barcodetype,:OPTORCODE as optorcode
,nvl(lastdaycount,0)lastdaycount,nvl(t.TodayGet,0) TodayGetCount,nvl(t.TodaySale,0) TodaySaleCount,
nvl(invalidCount,0) invalidCount,
nvl(todayleftcount,0) todayleftcount
from (
select t.tickettypecode,t.tickettypename,t.barcodetype
,(select sum(case when billtype='03' then -ticketamount else ticketamount end) ticketamount from
(
select * from sto_billmain bm where bm.ftostorage=:OPTORCODE and bm.billtype='02' and bm.fbalanceflag=0
union all
select * from sto_billmain bm where bm.ffromstorage=:OPTORCODE and bm.billtype='03' and bm.fbalanceflag=0
) bm where t.tickettypecode=bm.tickettypecode) as TodayGet
,(select count(distinct tc.barcode) from tkt_tradebarcode tc left join tkt_tradedetail td
on tc.ftradeid=td.tradeid and tc.fticketmodelcode=td.ticketmodelcode
left join tkt_trademain m on td.tradeid=m.tradeid
left join sys_ticketmodel tm on tm.ticketmodelcode = td.ticketmodelcode
where tm.barcodetype = t.barcodetype and m.tradetype<>'04' and m.tradetype<>'07' and tc.useflag=0 and td.create_optorcode=:OPTORCODE and m.balanceflag=0) as TodaySale
,(select todayleftcount from rdm_stocksettle_optor so
where so.Fid =(select max(Fid) from rdm_stocksettle_optor so1 where so1.tickettypecode = t.tickettypecode and so1.CREATE_OPTORCODE = :OPTORCODE and trunc(so1.settledate)=trunc((select settledate from lastsettledate)))) as lastdaycount
,(select sum(y.ticketcount) from sto_invalidticket y left join sto_tickettype x on y.tickettypecode=x.tickettypecode where x.barcodetype=t.barcodetype and y.create_optorcode=:OPTORCODE and y.balanceflag <> '1' ) invalidCount
,(select sum(Leftcount) from sto_stockcount bd where bd.tickettypecode = t.tickettypecode and bd.objectcode=:OPTORCODE) todayleftcount
from sto_tickettype t
where t.useflag=0
)t
where (lastdaycount>0 or TodayGet>0 or TodaySale>0 or todayleftcount>0 or invalidCount>0)
SQL语句参数(共8个):
{"ParameterName:"OPTORCODE","Value":"TCSSP001","DbType":"String"},
{"ParameterName:"OPTORCODE","Value":"TCSSP001","DbType":"String"},
{"ParameterName:"OPTORCODE","Value":"TCSSP001","DbType":"String"},
{"ParameterName:"OPTORCODE","Value":"TCSSP001","DbType":"String"},
{"ParameterName:"OPTORCODE","Value":"TCSSP001","DbType":"String"},
{"ParameterName:"OPTORCODE","Value":"TCSSP001","DbType":"String"},
{"ParameterName:"OPTORCODE","Value":"TCSSP001","DbType":"String"},
{"ParameterName:"OPTORCODE","Value":"TCSSP001","DbType":"String"}
【Info】 2021-01-24 15:56:23 192.168.109.11
返回结果TwiReturn对象,序列化后为:
{"id":null,"code":null,"success":true,"hasRight":true,"rightName":null,"knowError":100,"errors":null,"message":"操作成功!","data":"序列化类型为“System.Xml.Linq.XElement”的对象时检测到循环引用。","totalCount":0,"affRows":0,"stamp":null,"list":[]}
【End】 2021-01-24 15:56:23 192.168.109.11
TwiAjaxHelper.GetResult执行完成!
=================================================================
【Begin】 2021-01-24 15:56:51 192.168.109.11
TwiAjaxHelper.GetResult开始调用...
【Info】 2021-01-24 15:56:51 192.168.109.11
请求信息:
mn:TKT
cn:_RecordNumber
mn2:AddRecordNumber
对应参数:
data:
0129001
天池山大门
成人
30
2021-01-24 00:00:00
TCSSP001
TCSSP001
【Debugger】 2021-01-24 15:56:51 192.168.109.11
SQL语句:insert into TKT_RECORDNUMBER(fid, PARKCODE, PARKFULLNAME,recorddate,totalcount,clienttypename,remark,create_optorcode,create_optorname,modified_optorcode,modified_optorname,create_time,modified_time)
values('6E4B5CE51FA645A2AEC4985CB0CFA763','0129001','天池山大门',to_date('2021/1/24 0:00:00','yyyy-MM-dd hh24:mi:ss'),'30','成人','','TCSSP001','TCSSP001','TCSSP001','TCSSP001',SYSDATE,SYSDATE)
SQL语句参数:
【Info】 2021-01-24 15:56:51 192.168.109.11
返回结果:
true
录入成功!
【End】 2021-01-24 15:56:51 192.168.109.11
TwiAjaxHelper.GetResult执行完成!
=================================================================
【Begin】 2021-01-24 16:02:35 192.168.109.11
TwiAjaxHelper.GetResult开始调用...
【Info】 2021-01-24 16:02:35 192.168.109.11
请求信息:
mn:TKT
cn:_RecordNumber
mn2:AddRecordNumber
对应参数:
data:
0129001
天池山大门
成人
50
2021-01-24 00:00:00
TCSSP001
TCSSP001
【Debugger】 2021-01-24 16:02:35 192.168.109.11
SQL语句:insert into TKT_RECORDNUMBER(fid, PARKCODE, PARKFULLNAME,recorddate,totalcount,clienttypename,remark,create_optorcode,create_optorname,modified_optorcode,modified_optorname,create_time,modified_time)
values('9885CA45963445869DDA113562727DDC','0129001','天池山大门',to_date('2021/1/24 0:00:00','yyyy-MM-dd hh24:mi:ss'),'50','成人','','TCSSP001','TCSSP001','TCSSP001','TCSSP001',SYSDATE,SYSDATE)
SQL语句参数:
【Info】 2021-01-24 16:02:35 192.168.109.11
返回结果:
true
录入成功!
【End】 2021-01-24 16:02:35 192.168.109.11
TwiAjaxHelper.GetResult执行完成!
=================================================================
【Begin】 2021-01-24 16:22:02 192.168.109.11
TwiAjaxHelper.GetResult开始调用...
【Info】 2021-01-24 16:22:02 192.168.109.11
请求信息:
mn:TKT
cn:_RecordNumber
mn2:AddRecordNumber
对应参数:
data:
0129001
天池山大门
成人
20
2021-01-24 00:00:00
TCSSP001
TCSSP001
【Debugger】 2021-01-24 16:22:02 192.168.109.11
SQL语句:insert into TKT_RECORDNUMBER(fid, PARKCODE, PARKFULLNAME,recorddate,totalcount,clienttypename,remark,create_optorcode,create_optorname,modified_optorcode,modified_optorname,create_time,modified_time)
values('08DF92FA05FC44F6B7A160C56F79B193','0129001','天池山大门',to_date('2021/1/24 0:00:00','yyyy-MM-dd hh24:mi:ss'),'20','成人','','TCSSP001','TCSSP001','TCSSP001','TCSSP001',SYSDATE,SYSDATE)
SQL语句参数:
【Info】 2021-01-24 16:22:02 192.168.109.11
返回结果:
true
录入成功!
【End】 2021-01-24 16:22:02 192.168.109.11
TwiAjaxHelper.GetResult执行完成!
=================================================================
【Begin】 2021-01-24 16:25:43 192.168.109.11
TwiAjaxHelper.GetResult开始调用...
【Info】 2021-01-24 16:25:43 192.168.109.11
请求信息:
mn:TKT
cn:PageCommon
mn2:SimpleNew
对应参数:
data:{"TableName":"SYS008","IDField":"FID","Fields":{"Version":"Base_LogoutLog_C","FID":"A6A9784791B741B083194D4C4B8A9ACE","OPERATORCODE":"TCSSP001","OPERATORNAME":"TCSSP001","LASTLOGINIP":"192.168.109.11","FTYPE":"2","FMAC":"44-8A-5B-C9-4C-11"},"MaxCodeFields":"FID"}
【Debugger】 2021-01-24 16:25:43 192.168.109.11
SQL语句:select * from WEB_TKT_TABLEMAPPING
SQL语句参数:无。
【Debugger】 2021-01-24 16:25:43 192.168.109.11
SQL语句:insert into WEB_SYS_OPERATORLOGIN (Version,OPERATORCODE,OPERATORNAME,LASTLOGINIP,FTYPE,FMAC,FID) values (:Version,:OPERATORCODE,:OPERATORNAME,:LASTLOGINIP,:FTYPE,:FMAC,'0')
SQL语句参数(共6个):
{"ParameterName:"Version","Value":"Base_LogoutLog_C","DbType":"String"},
{"ParameterName:"OPERATORCODE","Value":"TCSSP001","DbType":"String"},
{"ParameterName:"OPERATORNAME","Value":"TCSSP001","DbType":"String"},
{"ParameterName:"LASTLOGINIP","Value":"192.168.109.11","DbType":"String"},
{"ParameterName:"FTYPE","Value":"2","DbType":"String"},
{"ParameterName:"FMAC","Value":"44-8A-5B-C9-4C-11","DbType":"String"}
【Info】 2021-01-24 16:25:43 192.168.109.11
返回结果TwiReturn对象,序列化后为:
{"id":null,"code":null,"success":false,"hasRight":true,"rightName":null,"knowError":100,"errors":"ORA-00904: \"VERSION\": 标识符无效","message":"系统发生异常:ORA-00904: \"VERSION\": 标识符无效","data":null,"totalCount":0,"affRows":0,"stamp":null,"list":[]}
【End】 2021-01-24 16:25:43 192.168.109.11
TwiAjaxHelper.GetResult执行完成!
=================================================================