select Row_number() over(order by CreateTime desc ) as id, (Cast(ProjectId as varchar(250)) +'\n'+ Cast(projectname as varchar(250))) as ProjectIdname,BidderName,contactuser,contactuserphone,case when PayerType=1 then '报名收费' when PayerType=2 then '中标收费' when PayerType=3 then '保证金' else '' end as PayerTypeStr,payamount,case when PayStatus=1 then '已支付' else '未支付' end as PayStatusStr,recommendusername,CreateTime from (select a.ProjectId,c.projectname,a.BidderName,contactuser,contactuserphone,payertype,payamount,paystatus,recommendusername,a.createtime from (select ProjectId,BidderId,BidderName,paystatus,payamount,createtime from Product_FeeBidder)a left join User_BiddingSubInfo b on a.BidderId=b.BiddingSubInfoidleft join Product_FeeProject c on a.ProjectId=c.ProjectIdUNION all select projectid,projectname,biddername,contactuser, contactuserphone, payertype, TradeMoney, paystatus,recommendusername,CreateTime from (SELECT bidderid,biddername ,InSubAcc,3 as payertype,TradeMoney,1 as paystatus,CreateTime FROM Product_FNTDInAccRecord where bidderid is not null )a inner join (SELECT ProjectId,Projectname,SubAcc FROM Product_FNTDProjectSubAcc)b on a.InSubAcc=b.SubAccleft join (SELECT BiddingSubInfoid,subname,contactuser,contactuserphone,recommenduserid,recommendusername from User_BiddingSubInfo where BiddingSubInfoid in (SELECT distinct bidderid FROM Product_FNTDInAccRecord))con a.bidderid=c.BiddingSubInfoid )data1 where 1=1 ${if(len(payertypestr) == 0,"","and payertypestr = '" + payertypestr + "'")} ${if(len(paystatusstr) == 0,"","and paystatusstr = '" + paystatusstr + "'")} ${if(len(BidderName) == 0,"","and biddername like'%" + BidderName + "%'")} ${if(len(recommendusername) == 0,"","and recommendusername like'%"+recommendusername+"%'")} ${if(len(创建时间)=0,""," and CreateTime>='"+创建时间+"'")} ${if(len(至)=0,""," and CreateTime<'"+至+"'")}
