function ticket_excel()
{
//代金券excel表存放地址
$ticket_id = IFilter::act(IReq::get('id'));
if ($ticket_id) {
$excelStr = '<table><tr><th>名称</th><th>卡号</th><th>密码</th><th>面值</th>
<th>已被使用</th><th>是否关闭</th><th>是否发送</th><th>开始时间</th><th>结束时间</th></tr>';
$propObj = new IModel('prop');
$where = 'type = 0';
$ticket_id_array = is_array($ticket_id) ? $ticket_id : array($ticket_id);
//当代金券数量没有时不允许备份excel
foreach ($ticket_id_array as $key => $tid) {
if (statistics::getTicketCount($tid) == 0) {
unset($ticket_id_array[$key]);
}
}
if ($ticket_id_array) {
$id_num_str = join('","', $ticket_id_array);
} else {
$this->redirect('ticket_list', false);
Util::showMessage('实体代金券数量为0张，无法备份');
exit;
}
$where .= ' and `condition` in("' . $id_num_str . '")';
$propList = $propObj->query($where, '*', '`condition`', 'asc', '10000');
foreach ($propList as $key => $val) {
$is_userd = $val['is_userd'] == '1' ? '是' : '否';
$is_close = $val['is_close'] == '1' ? '是' : '否';
$is_send = $val['is_send'] == '1' ? '是' : '否';
$excelStr .= '<tr>';
$excelStr .= '<td>' . $val['name'] . '</td>';
$excelStr .= '<td>' . $val['card_name'] . '</td>';
$excelStr .= '<td>' . $val['card_pwd'] . '</td>';
$excelStr .= '<td>' . $val['value'] . ' 元</td>';
$excelStr .= '<td>' . $is_userd . '</td>';
$excelStr .= '<td>' . $is_close . '</td>';
$excelStr .= '<td>' . $is_send . '</td>';
$excelStr .= '<td>' . $val['start_time'] . '</td>';
$excelStr .= '<td>' . $val['end_time'] . '</td>';
$excelStr .= '</tr>';
}
$excelStr .= '</table>';
$ticketFile = "ticket_" . join("_", $ticket_id_array);
$reportObj = new report($ticketFile);
$reportObj->toDownload($excelStr);
} else {
$this->redirect('ticket_list', false);
Util::showMessage('请选择要操作的文件');
}
}
