//查询某一用户在当日提现的所有记录
SELECT * FROM shop_cash_log
where
(pdr_type='提现' or pdr_type='提现手续费')
and FROM_UNIXTIME(pdr_payment_time /1000, '%Y%m%d') = date_format(now(),'%Y%m%d')
and pdr_member_id='289';
SELECT * FROM shop_cash_log
where
(pdr_type='提现' or pdr_type='提现手续费')
and FROM_UNIXTIME(pdr_payment_time /1000, '%Y%m%d') = date_format(now(),'%Y%m%d')
and pdr_member_id='289';