【Begin】 2023-08-09 11:42:17 114217
	TwiAjaxHelper.GetResult开始调用...

【Info】 2023-08-09 11:42:17 114217
	请求信息：
	mn:TKT
	cn:QueryTicketManage
	mn2:getTicketDetailsForGroup

	对应参数：
	data:{"BARCODE":"ET23080513590700118991","OPTORID":"6554A8F0428D498797E2D4D7588B66AC","OPTORCODE":"TCSSP002"}

【Debugger】 2023-08-09 11:42:17 114217
	SQL语句：select fid from web_sys_plug where plugcode = 'TKT0202'
	SQL语句参数：无。

【Debugger】 2023-08-09 11:42:17 114217
	SQL语句：select dataauthority,orgid from 
                    (
                    select ro.operatorid,ro.roleid,rp.plugid,rp.dataauthority
                      ,case when rp.dataauthority = 1 then (select wm_concat(rpe.fdeptid) from web_sys_roleplugext rpe where rpe.roleplugid = rp.fid) else '0' end as orgid
                    from web_sys_roleoperator ro
                    left join web_sys_roleplug rp on rp.roleid = ro.roleid
                    )
                    where operatorid = '6554A8F0428D498797E2D4D7588B66AC' and plugid = '4C8865713D244DDB959CF129133D8296'
	SQL语句参数：无。

【Debugger】 2023-08-09 11:42:17 114217
	SQL语句： with tt as  (select  case when c.fitemtype <> 1 then '000' else to_char(c.fitemCODE) end as fitemCODE  ,case when c.fitemtype = 1 then(select b.parkfullname from sys_park b where c.fitemcode = b.parkcode)  when c.fitemtype = 3 then to_char((select s.fname from SYS_LINE s where s.fcode = c.fitemcode)) else '' end as ITEMNAME  ,decode(c.fitemType, 1, '检票景点', 3, '线路', 4, '分组', '') as ItemType  ,a.fticketmodelcode ,a.ftradeid ,a.barcode ,a.fuseFlag ,a.fbegbarcode ,a.fendbarcode  ,case when d.printtempmodel=0 then  a.fticketCount else d.fusercount end as fusercount  ,case when d.printtempmodel=1 then 1 else a.fticketCount end as ticketCount  from  ( select*from ( select * from tkt_tradebarcode where barcode='ET23080513590700118991'  and  create_optorcode = 'TCSSP002'     order by create_time desc)where  rownum=1) a  left join tkt_tradedetail d on d.tradeid = a.ftradeid and d.ticketmodelcode = a.fticketmodelcode  left join sys_ticketmodelcitem c on c.fticketmodelcode = a.fticketmodelCode  where  c.fitemtype <> 2 /*and d.tradeType = '01'*/  )   select tt.fitemcode,tt.itemName  ,tt.itemType  ,to_char(cc.usetime, 'yyyy-MM-dd hh24:mi:ss') as useTime  , case when cc.barCode is null then '未检' else '已检' end as TYPE  ,case when cc.barCode is null then 0  else sum(cc.checkcount) end as checkCount  ,case when cc.barcode is not null or tt.fuseFlag=1 then 0 else sum(fuserCount) end AS userCount  ,CASE WHEN cc.barCode IS not NULL or tt.fuseFlag=1 THEN 0  ELSE  (tt.ticketCount * fuserCount)  END AS leftCount  from tt  left join tkt_checkdetail cc on cc.barcode =tt.barcode and cc.tradeId = tt.ftradeid and cc.parkcode = tt.fitemCode  group by tt.fitemcode ,tt.itemName,tt.itemType ,cc.usetime ,cc.barcode ,fuserCount,ticketCount,fuseFlag 
	SQL语句参数：无。

【Debugger】 2023-08-09 11:42:17 114217
	SQL语句：select fid from web_sys_plug where plugcode = 'TKT0202'
	SQL语句参数：无。

【Debugger】 2023-08-09 11:42:17 114217
	SQL语句：select dataauthority,orgid from 
                    (
                    select ro.operatorid,ro.roleid,rp.plugid,rp.dataauthority
                      ,case when rp.dataauthority = 1 then (select wm_concat(rpe.fdeptid) from web_sys_roleplugext rpe where rpe.roleplugid = rp.fid) else '0' end as orgid
                    from web_sys_roleoperator ro
                    left join web_sys_roleplug rp on rp.roleid = ro.roleid
                    )
                    where operatorid = '6554A8F0428D498797E2D4D7588B66AC' and plugid = '4C8865713D244DDB959CF129133D8296'
	SQL语句参数：无。

【Debugger】 2023-08-09 11:42:17 114217
	SQL语句：with BarCodeTicketModelCode as ( select rownum as rownumFlag,t.* from( select a.fuseFlag as useflag  , a.BARCODE  , a.ftradeid as tradeId , case when c.checkcount is null then d.fusercount else (d.fusercount - sum(c.checkcount)) end as Leftcount , d.fusercount as usercount , to_char(wm_concat(nvl(k.parkfullname, l.fname))) as parks , a.constractpricecode  , a.fticketCount as TICKETCOUNT  , a.fticketmodelcode,a.fbeginDate as beginDate , max(r.invaliDate) as INVALIDATE from ( select * from TKT_tradebarcode where barcode='ET23080513590700118991'  and  create_optorcode = 'TCSSP002'  ) a  left join tkt_tradeDetail d on d.tradeid = a.ftradeid  left join TKT_CHECKDETAIL c on a.ftradeid = c.tradeid and c.barcode =a.barcode  left join sys_ticketmodelcitem p on p.fticketmodelcode = a.fticketmodelcode  left join sys_park k on p.fitemCode = k.parkcode and p.fitemtype = 1  left join sys_line l on p.fitemcode = l.fcode and p.fitemtype = 3  left join view_ticket_validdate_range r on r.tradeId=a.ftradeId and a.barcode=r.barcode  where(a.fisenabled = 1 or a.fisenabled = 0)  group by a.BARCODE ,a.fbegindate, a.ftradeid , a.fuseFlag, a.fticketmodelcode , d.fusercount , C.checkCount, fticketCount , a.constractpricecode  )t  ),  filmInfo as (  select  fs.fid as FIID,'第' || fp.SceneID || '场,时间:' || fp.PerformTime as FIText,fp.SceneID as FIValue,fp.PerformCode as FIPerformCode,  fp.performname as FIperformname,to_char(fp.performdate, 'yyyy-mm-dd') as FIperformdate,fp.performtime as FIperformtime,fp.timelong as FItimelong,fp.beforechecktime as FIbeforechecktime,fp.SceneID as FISceneID,  fs.tradeid as FItradeid,fs.barcode as FIbarcode,fs.areacode as FIareacode  ,fs.areaname as FIareaname,fs.srow as FIsrow,fs.scol as FIscol,fs.srow + 1 as FINsrow  ,fs.seatid as fiseatid,fs.seatname as fiseatname  from film_seatselldetail fs  left join film_performplan fp  on fs.performcode = fp.performcode  where fs.barcode ='ET23080513590700118991'  order by fs.srow,fs.scol  )  select a.rownumFlag,b.differenceprice* a.TICKETCOUNT as ticketpayprice,b.differenceprice  ,case when a.leftcount != a.usercount  then '已检票' when a.useflag = 1  then '已退票'  /* when m.tradetype='01' and a.Fteamretcount=0 then '正常售票'  when m.tradetype='01' and a.Fteamretcount!=0 then '部分退票' */  when m.tradetype = '04' then '预售票' else '其它' end as TRADETYPEName2,  case m.tradetype when '01' then '正常售票' when '02' then '退票' when '04' then '预售票' else '其它' end as TRADETYPEName,  case m.ClientType when '01' then '散客' when '02' then '团队' else '其它' end CLIENTTYPEName,  m.tradedate , m.tradetype ,m.billtype,t.TICKETTYPEFLAG,D.regcert,t.tickettypecode,case T.TICKETTYPEFLAG when 0 then '现场打印'when 1 then '预印刷/明信片' when 2 then 'IC卡门票' else '其它' end as TICKETTYPEFLAGNAME,t.isprint,  a.TRADEID,a.fticketmodelcode as TICKETMODEL,b.FTICKETMODELNAME as TICKETMODELNAME,a.BARCODE,b.FTICKETMODELKINDNAME as TICKETKINDNAME  ,b.TICKETMODELPRICE,a.USERCOUNT* a.TICKETCOUNT as FUSERCOUNT,a.USERCOUNT  ,m.create_optorcode as OPTORCODE  ,m.create_optorname as foptor  ,a.LEFTCOUNT,  m.saleModel  ,case a.USEFLAG when 0 then '正常' when 1 then '退票' else '其它' end as USEFLAGNAME,a.USEFLAG, b.printtempname,b.printtempmodel  ,to_char(a.BEGINDATE, 'yyyy-mm-dd') as BEGINDATE  ,to_char(a.INVALIDATE, 'yyyy-mm-dd') as INVALIDATE  ,a.TICKETCOUNT  ,b.TICKETMODELPRICE* a.TICKETCOUNT as PAYSUM  ,ct.clientfullname as CLIENTNAME,m.clienttype,m.paysum as MpaySUM,  a.parks || ',' || (select to_char(wm_concat(k.parkfullname)) as printonlyParks from sys_ticketmodelcitem cm  left  join sys_park k on cm.fitemcode = k.parkcode  where cm.fitemtype = 1 and cm.fprintonly = 1 and cm.fticketmodelcode = b.ticketmodelcode) as parkcodes  ,pk.parkfullname as PARKFULLNAME,d.rebateprice as ticketPrice  ,(select to_char(wm_concat(e.PaytypeName || ':' || e.paysum || ':' || e.remark)) as TR from tkt_tradepaytype e where e.tradeid = b.tradeid) as PAYTYPENAMEANDPAYSUM  ,SH.FSHIPNAME as SIFSHIPNAME ,SH.FSTARTTIME as SIFSTARTTIME,(SH.FSHIPNAME || ':' ||to_char(SH.FSTARTTIME, 'yyyy-mm-dd hh24:mi:ss') ) as SHIPREMARK,f.*,m.billno,nvl(ct.clientfullname,wb.clientname) as sourceName from BarCodeTicketModelCode a  left join tkt_tradedetail b on a.tradeid = b.tradeid and a.fticketmodelcode = b.ticketmodelcode  and NVL(a.constractpricecode, '0')= NVL(b.constractpricecode, '0')  left join  filmInfo f on a.tradeid = f.fitradeid and a.barcode = f.fibarcode  left join tkt_trademain m on a.tradeid = m.tradeid  LEFT JOIN atp_plan SH ON b.fshipplanid=SH.Fid  left join sys_ticketmodel d on a.fticketmodelcode = d.ticketmodelcode  left join Sto_TicketType t on t.barcodetype = d.barcodetype  left join clt_clientinfo ct on ct.clientcode = m.clientcode   left join web_billmain wb on wb.billno=m.billno  left join sys_park pk  on pk.parkcode = m.locationcode  order by f.FIsrow,f.FIscol 
	SQL语句参数：无。

【Debugger】 2023-08-09 11:42:17 114217
	SQL语句：select fid from web_sys_plug where plugcode = 'TKT0202'
	SQL语句参数：无。

【Debugger】 2023-08-09 11:42:17 114217
	SQL语句：select dataauthority,orgid from 
                    (
                    select ro.operatorid,ro.roleid,rp.plugid,rp.dataauthority
                      ,case when rp.dataauthority = 1 then (select wm_concat(rpe.fdeptid) from web_sys_roleplugext rpe where rpe.roleplugid = rp.fid) else '0' end as orgid
                    from web_sys_roleoperator ro
                    left join web_sys_roleplug rp on rp.roleid = ro.roleid
                    )
                    where operatorid = '6554A8F0428D498797E2D4D7588B66AC' and plugid = '4C8865713D244DDB959CF129133D8296'
	SQL语句参数：无。

【Debugger】 2023-08-09 11:42:17 114217
	SQL语句：   select* from (       select billdate, billtypeName, operatorcode, operatorname, typeRemark,billno,sourceName from     (        select m.billdate, case when  m.billtype = '00' then '初始入库' when m.billtype = '01' then '转仓(总仓到分仓、分仓到分仓)' when m.billtype = '04' then '总仓退库' when m.billtype = '02' then '调拨(售票员领用)' when m.billtype = '03' then '调拨(售票员退库)' else '其它' end as billtypeName, m.create_optorcode as operatorcode, m.create_optorname as operatorname,  case when  m.billtype = '00' then sg1.storagename when m.billtype = '01'  then sg.storagename || '_调到_' || sg1.storagename when m.billtype = '04' then sg.storagename || '_调到_' || sg1.storagename when m.billtype = '02' then sg.storagename || '_调到_' || so1.operatorname when m.billtype = '03' then so.operatorname || '_调到_' || sg1.storagename else '其它' end as typeRemark,   '' as billno,    '' as sourceName from( select m.*, m.barcodetype || m.beginticketcode as newbgcode, m.barcodetype || m.endticketcode as newendcode from sto_billmain m )m left join  sto_storage sg on m.ffromstorage = sg.storagecode  left join  sto_storage sg1 on m.ftostorage = sg1.storagecode  left join  sys_operator so on m.storagecode = so.operatorcode left join  sys_operator so1 on m.ftostorage = so1.operatorcode      where m.newbgcode <='ET23080513590700118991' and m.newendcode>='ET23080513590700118991'          )        union       select m.tradedate,'售票' as typeName       ,m.create_optorCode as optorcode       ,(m.create_optorname) as foptor,        k.parkfullname || ' 有效期:' || to_char(max(c.fbegindate), 'yyyy-mm-dd') || '_' || to_char(max(c.fenddate), 'yyyy-mm-dd') as typeRemark,m.billno,nvl(clt.clientfullname, wb.clientname) as sourceName         from tkt_tradeBarcode c       left join tkt_trademain m on c.ftradeid = m.tradeid       left join sys_park k on m.locationcode = k.parkcode       left join clt_clientinfo clt on clt.clientcode = m.clientcode left join web_billmain wb on wb.billno = m.billno  where c.ftradeid in(select (ftradeId) from tkt_tradeBarcode where barcode='ET23080513590700118991'   and  create_optorcode = 'TCSSP002' ) and c.FISENABLED=0         group by m.tradedate,m.create_optorCode,m.create_optorName,k.parkfullname, m.billno,clt.clientfullname,wb.clientname       union       select c.retTime       , '退票' as typeName       ,m.create_optorcode       ,to_char(m.create_optorName),        k.parkfullname || ' 有效期:' || to_char(max(g.begindate), 'yyyy-mm-dd') || '_' || to_char(max(g.invalidate), 'yyyy-mm-dd') as typeRemark , '' as billno,''as  sourceName        from tkt_tradebarcode c       left join view_ticket_validDate_range g on g.tradeId = c.ftradeid and g.fticketModelCode = c.fTicketmodelCode       left join tkt_trademain m on c.ftradeId = m.tradeid       left join sys_park k on m.locationcode = k.parkcode       where(c.useflag = 0) and  c.freTradeId is not null  and c.barcode='ET23080513590700118991'         and c.fretradeid in (select (bb.freTradeId) from tkt_tradeBarcode bb       where  bb.barcode='ET23080513590700118991'  and  create_optorcode = 'TCSSP002'  )          group by c.retTime,k.parkfullname,g.fretradeid,m.create_optorcode,m.create_optorName       union       select c.usetime,'检票' as typeName,c.parkcode,k.parkfullname,         '检票口:' || c.gateno || ',IP:' || c.gateip as typeremark, '' as billno,''as  sourceName        from (select*from tkt_checkdetail where 1=1  and  create_optorcode = 'TCSSP002' ) c         left join sys_park k on c.parkcode = k.parkcode       where c.barcode = 'ET23080513590700118991'         union       select s.regdate,'废票登记', s.create_optorcode,o.operatorname,s.remark , '' as billno,''as  sourceName from (select*from sto_invalidticket where 1=1  and  create_optorcode = 'TCSSP002' ) s          left join sys_operator o  on s.create_optorcode = o.operatorcode       where s.barcode = 'ET23080513590700118991'         )  order by billdate desc
	SQL语句参数：无。

【Info】 2023-08-09 11:42:17 114217
	返回结果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】 2023-08-09 11:42:17 114217
	TwiAjaxHelper.GetResult执行完成！
=================================================================