<p style="margin:0in;font-size:11.0pt"><span style="font-family:Calibri" lang="en-US"> </span><span style="font-family:"Microsoft YaHei"" lang="zh-CN">充值</span><span style="font-family:Calibri" lang="en-US">-</span><span style="font-family:"Microsoft YaHei"" lang="en-US">提现</span><span style="font-family:Calibri" lang="en-US">-</span><span style="font-family:"Microsoft YaHei"" lang="en-US">消费</span><span style="font-family:Calibri" lang="en-US">+</span><span style="font-family:"Microsoft YaHei"" lang="en-US">退款</span><!--EndFragment--></p>
<br><br><br><br><br><br><!--StartFragment--><br><br><p style="margin:0in;font-family:Calibri;font-size:11.0pt">select<br>sum(ast_amount) from `balance_asset_transactions` where ast_type =<br>"recharge" </p><br><br><p style="margin:0in;font-family:Calibri;font-size:11.0pt" lang="en-US">select<br>sum(ast_amount) from `balance_asset_transactions` where ast_type =<br>"withdrawal" and ast_status = "settled"</p><br><br><p style="margin:0in;font-family:Calibri;font-size:11.0pt" lang="en-US">select<br>sum(ast_amount) from `balance_asset_transactions` where ast_type =<br>"payment" and ast_status = "settled"</p><br><br><p style="margin:0in;font-family:Calibri;font-size:11.0pt" lang="en-US">select<br>sum(ast_amount) from `balance_asset_transactions` where ast_type =<br>"payment_refund" and ast_status = "settled"</p><br><br><!--EndFragment-->
总金额＝历史金额＋当天金额
当天之前的总金额
当天之前的总金额由统计表balance_asset_statistics得出
缓存在redis中，key的过期时间为1个小时
<p style="margin:0in;font-family:Calibri;font-size:11.0pt" lang="en-US">"balance:live:app_LibTW1n1SOq9Pin1:history"<!--EndFragment--></p>
缓存一个小时，会导致00:00-01:00之间看不到前一天的记录
＃1556
当天的金额
缓存在redis中
<p style="margin:0in;font-family:Calibri;font-size:11.0pt" lang="en-US">"balance:live:app_LibTW1n1SOq9Pin1:20160906"<!--EndFragment--></p>
当天的金额实时显示
