public function export()
{
$sqlOrder = new sql_orderMod();
$a_id = $this->in_cookie('aid', None, 1, 'True');
$temp = $_GET['status'];
if (is_numeric($temp)) {
$status = $temp;
} else {
$status = -1;
}
$mark = $this->in_get('mark', 0, 1);
$sender = $this->in_get('sd', 0, 1);
$school = $this->in_get('sc', 0, 1);
$cid = $this->in_get('cid', 0, 1);
$brand = $this->in_get('brand', 0, 1);
$ex_d = $this->in_get('ex_d', date('Y-m-d'), 2);
$pr_d = $this->in_get('pr_d', date('Y-m-d', strtotime('+1 day')), 2);
if ($brand > 0 && $school > 0) {
$fid = $sqlOrder->get_fid_gid($brand, $school);
if ($fid) {
$res = $sqlOrder->export_order($mark, $a_id, $status, $sender, $school, $cid, $fid, $ex_d, $pr_d);
} else {
$this->alert('没有该品牌的订水情况');
$res = '';
}
} else {
$res = $sqlOrder->export_order($mark, $a_id, $status, $sender, $school, $cid, $brand, $ex_d, $pr_d);
}
if ($res) {
header("Content-Type: application/{$file_type};charset=gbk");
header("Content-Disposition: attachment; filename=1.xls");
header("Pragma: no-cache");
$title = "日期\t用户名\t手机号\t学校\t宿舍号\t品牌\t数量\t送货员\t结算方式\n";
echo "{$title}";
foreach ($res as $key => $value) {
if ($value['pay_type'] == 0) {
$pay_type = '预付+提水';
} else {
if ($value['pay_type'] == 1) {
$pay_type = '提水';
} else {
if ($value['pay_type'] == 2) {
$pay_type = '线下支付';
} else {
if ($value['pay_type'] == 3) {
$pay_type = '积分兑换';
}
}
}
}
echo $value['created'] . "\t" . $value['name'] . "\t" . $value['phone'] . "\t" . $value['s_name'] . '-' . $value['c_name'] . "\t" . $value['addr'] . "\t" . $value['g_name'] . "\t" . $value['num'] . "\t" . $value['send_name'] . "\t" . $pay_type . "\n";
}
} else {
$this->alert('没有找到相关数据');
}
}
