protected function getCSV($startTime,$endTime,$status, $where_type)
{
$join = "ss_member on ss_member.id = ss_earncash.uid";
$where = "ss_earncash.time>={$startTime} and ss_earncash.time <={$endTime} and {$status} and {$where_type}";
$field = "ss_earncash.id id, ss_earncash.uid uid, ss_member.username username, ss_earncash.cash cash, ss_member.alipayname alipayname, ss_earncash.wexinOrderNo wexinOrderNo,ss_earncash.selfOrderNo selfOrderNo,ss_earncash.status status, ss_earncash.type type ";
$data = M('earncash')->join($join)->where($where)->field($field)->select();
// echo M('earncash')->_sql();
// exit;
$csv = iconv('UTF-8', 'GB2312', '"序号","用户ID","用户名","金额","支付宝账号","微信支付订单号", "微信商户订单号","状态","提现类型"'."\r\n");
$id = 1;
foreach($data as $val) {
$val['id'] = $id++;
switch ($val['type']) {
case '1':
$val['type'] = "支付宝提现";
break;
case '2':
$val['type'] = "微信提现";
break;
default:
$val['type'] = "默认";
break;
}
$csv .= iconv('UTF-8', 'GB2312', implode(",", $val)."\r\n");
}
$csv = substr($csv, 0, -2);
return $csv;
}
