<?php

namespace YHMPassport\SqlMap\Withdraw;

class Withdraw {
	
	const SET_WITHDRAW = "insert into `withdraw_log`(`uid`,`withdraw_amount`,`create_time`,`is_payment`) values(:uid,:withdraw_amount,UNIX_TIMESTAMP(),'N')";
	
	const GET_LIST_BY_UID = 'select * from `withdraw_log` where `uid`=:uid limit :offset,:size';
	
	const GET_WITHDREW_BY_UID = "select sum(`withdraw_amount`) from `withdraw_log` where `uid`=:uid and `is_payment`='Y'";
	
	
}