umgsai:select|@| account.accountid,|@| m.partnerid,|@| p.shopid,|@| shop.shop_name,|@| shop.branch_name,|@| plan.amount,|@| plan.actualdeductamount,|@| plan.actualpayamount,|@| bankaccount.BankName,|@| concat(bankaccount.BankAccountName),|@| bankaccount.BankBranch,|@| bankaccount.province,|@| bankaccount.city,|@| concat("银行卡号:",|@| bankaccount.BankAccountNumber),|@| plan.payabledate,|@| plan.settlebegintime,|@| plan.settleendtime,|@| (CASE |@| WHEN plan.status=5 THEN '已打款' |@| ELSE '未打款' |@| END) |@|from|@| dpods_ts_accountmapping m |@|join|@| dpods_ts_account account |@| on(|@| account.accountid = m.accountid |@| ) |@|join|@| dpods_ts_partner p |@| on(|@| p.partnerid = m.partnerid |@| ) |@|join|@| dpods_ts_payplan plan |@| on(|@| plan.accountid = account.accountid |@| ) |@|join|@| dpdim_dp_shop shop |@| on(|@| shop.shop_id = p.shopid |@| ) |@|join|@| dpods_ts_deductandwithdrawmapping deductandwithdrawmapping |@| on(|@| plan.ID = deductandwithdrawmapping.PayPlanID |@| ) |@|join|@| dpods_ts_withdraw withdraw |@| on(|@| withdraw.WithdrawID= deductandwithdrawmapping.WithdrawID |@| ) |@|join|@| dpods_mr_customerbankaccount customerbankaccount |@| on(|@| withdraw.BankAccountID = customerbankaccount.accountid |@| ) |@|join|@| dpods_mr_bankaccount bankaccount |@| on(|@| bankaccount.id = customerbankaccount.MBAId |@| ) |@|where|@| account.accountid in(|@| '210001162313' |@| ) |@| and plan.actualpayamount > 0.0 |@| and plan.payabledate >= '2016-05-01 00:00:00' |@| and account.hp_statdate = "2016-07-11" |@| and m.hp_statdate = "2016-07-11" |@| and p.hp_statdate = "2016-07-11" |@| and plan.hp_statdate = "2016-07-11" |@| and shop.hp_valid_end_dt = '3000-12-31' |@| and withdraw.hp_statdate = "2016-07-11" |@| and deductandwithdrawmapping.hp_statdate = "2016-07-11" |@| and deductandwithdrawmapping.Deleted=0;
flex java webservice_Flex调用java webservice
最新推荐文章于 2024-03-21 23:55:03 发布