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('请选择要操作的文件'); } }