CI导出
$contentSql = $this->db->where('sale_id >', 0)->order_by('order_time desc')->get('1_order');
header('Content-Type: text/csv; charset=GB2312');
header("Content-Disposition: attachment; filename=\"导出.csv\"");
$f = fopen('php://output', 'w');
fputcsv($f, [
'订单编号',
'购买者',
'销售',
'购买类型',
'金额',
'佣金',
'是否结单',
'时间'
]);
while ($row = $contentSql->unbuffered_row()) {
$row = json_decode(json_encode($row), true);
$item = $this->models('module/order')->transfer($row, 1);
fputcsv($f, [
$item['sn'],
$item['buy_uid']['name'],
dr_member_info($item['sale_id'])['name'],
$item['server_id'] . $item['server_cid'],
$item['order_price'],
$item['money'],
$item['pay_status'] == 3 ? '是' : '否',
$item['order_time']
]);
}
fclose($f);
