java stack top_Java Top 100热门问答(Stackoverflow)

墨蓝 2022-11-06 09:55 33阅读 0赞

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;