<?php
require_once(dirname(__FILE__)."/config.php");
if($action == 'allexport') {
    //批量获取文章id
    if (!empty($aid) && empty($qstr)) $qstr = $aid;
    
    if($qstr==''){
        ShowMsg('参数无效！',$ENV_GOBACK_URL);
        exit();
    }
    
    $qstrs = explode('`',$qstr);
    $idstrs = implode(',', $qstrs);
    
    include_once (dirname(__FILE__).'/Classes/PHPExcel.php');
    
    $objPHPExcel = new PHPExcel();
    $objActSheet = $objPHPExcel->getActiveSheet();
    
    // Set document properties
    $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")->setLastModifiedBy("Maarten Balliauw")->setTitle("Office 2007 XLSX Test Document")->setSubject("Office 2007 XLSX Test Document")->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")->setKeywords("office 2007 openxml php")->setCategory("Test result file");
    
    $objPHPExcel->setActiveSheetIndex(0)
              ->setCellValue('A1', 'id')
              ->setCellValue('B1', '标题')
              ->setCellValue('C1', '发布时间')
              ->setCellValue('D1', '会员id')
              ->setCellValue('E1', '栏目id');
              
    $query = "Select * From `dede_archives` where id in($idstrs) ";
    $dsql->SetQuery($query);
    $dsql->Execute();
    $index = 1;
    
    while($row = $dsql->GetArray()) {
        $index++;
        $objPHPExcel->setActiveSheetIndex(0)
                  ->setCellValue('A'.$index, $row['id'])
                  ->setCellValue('B'.$index, $row['title'])
                  ->setCellValue('C'.$index, date("Y-m-d",$row['senddate']))
                  ->setCellValue('D'.$index, $row['mid'])
                  ->setCellValue('E'.$index, $row['typeid']);
    }
    
    // Rename worksheet
    $objPHPExcel->getActiveSheet()->setTitle('Simple');
    
    // Set active sheet index to the first sheet, so Excel opens this as the first sheet
    $objPHPExcel->setActiveSheetIndex(0);
    
    // Redirect output to a client’s web browser (Excel5)
    header('Content-Type: application/vnd.ms-excel');
    header('Content-Disposition: attachment;filename="list.xls"');
    header('Cache-Control: max-age=0');
    
    $objWriter = PHPExcel_IOFactory :: createWriter($objPHPExcel, 'Excel5');
    $objWriter->save('php://output');
    exit;
}
?>
    

function eportArc(aid){
    var qstr=getCheckboxItem();
    if(aid==0) aid = getOneItem();
    if(qstr==''){
        alert('必须选择一个或多个文档！');
        return;
    }
    location="download_excel.php?aid="+aid+"&action=allexport&qstr="+qstr;
}