/**
 * 導(dǎo)出節(jié)目單
 */
public function programExport_ExcelAction($data,$catid)
{
    require_once dirname(__FILE__) . '/PHPExcel.class.php';
    $sheetname = 'sheet1';
    $catname = $this->category_cache[$catid]['catname'];
    $savefile = $catname . "節(jié)目單";
    //設(shè)置表格頭部
    $title = array('ID', '標(biāo)題', '推薦','資源狀態(tài)','欄目','版權(quán)上線時(shí)間','版權(quán)下線時(shí)間','版權(quán)到期時(shí)間','審核狀態(tài)','發(fā)布人','更新時(shí)間'); //設(shè)置要導(dǎo)出excel的表頭
    $objPHPExcel = new PHPExcel();
    //設(shè)置列頭標(biāo)題
    for ($i = 0; $i < count($title); $i  ) {
        $alpha = chr(65   $i);
        $objPHPExcel->getActiveSheet()->setCellValue($alpha.'1', $title[$i]);
        $objPHPExcel->getActiveSheet()->getColumnDimension($alpha)->setWidth(20);//設(shè)置列寬
        $objPHPExcel->getActiveSheet()->getStyle($alpha)->getAlignment()->setWrapText(true); //單元寬度自適應(yīng)
        $objPHPExcel->getActiveSheet()->getStyle($alpha . '1')->getFont()->setName("Candara");  //設(shè)置字體
        $objPHPExcel->getActiveSheet()->getStyle($alpha . '1')->getFont()->setSize(12);  //設(shè)置大小
        $objPHPExcel->getActiveSheet()->getStyle($alpha . '1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK); //設(shè)置顏色
        $objPHPExcel->getActiveSheet()->getStyle($alpha . '1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); //水平居中
        $objPHPExcel->getActiveSheet()->getStyle($alpha . '1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); //垂直居中
        $objPHPExcel->getActiveSheet()->getStyle($alpha . '1')->getFont()->setBold(true); //加粗
        $objPHPExcel->getActiveSheet()->getStyle($alpha.'1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);//設(shè)置顏色
        $objPHPExcel->getActiveSheet()->getStyle($alpha.'1')->getFill()->getStartColor()->setARGB('FF97BAE5');
        $objPHPExcel->getActiveSheet()->getStyle($alpha)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); //水平居中
        $objPHPExcel->getActiveSheet()->getStyle($alpha)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); //垂直居中
    }
    for($j = 0;$j<count($data);$j  ){
        $z = $j   2;
        $objPHPExcel->getActiveSheet()->setCellValue('A'.$z, $data[$j]['id']);
        $objPHPExcel->getActiveSheet()->setCellValue('B'.$z, $data[$j]['title']);
        //推薦
        $content_model = get_cache('content_model');
        $content_model = $content_model[$this->category_cache[$catid]['modelid']][fields];
        $tuijianarr = $content_model['shouyetuijian'][setting];//地區(qū)的設(shè)置
        $tuijianarr = string2array($tuijianarr);//把文本專為數(shù)組
        $tuijianarr = explode(chr(13), $tuijianarr[content]);//分割數(shù)組 分割條件是一行一個(gè)
        //分解數(shù)組
        $tuijian = string2array($data[$j]['shouyetuijian']);
        $shouyetuijian = '';
        foreach ($tuijianarr as $qt) {
            list($select_name, $select_value) = explode('|', $qt);
            if (in_array($select_value, $tuijian) && $select_value != -1) {
                $shouyetuijian .= ' '.$select_name;
            }
        }
        $objPHPExcel->getActiveSheet()->setCellValue('C'.$z,$shouyetuijian );
        //資源狀態(tài)
        if($data[$j]['isonline'] == '0'){
            $isonline = '已上架';
        }else if($data[$j]['isonline'] == '1'){
            $isonline = '已下架';
        }else if($data[$j]['isonline'] == '3'){
            $isonline = '';
        }
        $objPHPExcel->getActiveSheet()->setCellValue('D'.$z, $isonline);
        $objPHPExcel->getActiveSheet()->setCellValue('E'.$z, $catname);
        //版權(quán)上線時(shí)間
        if($data[$j]['uponlinetime']){
            $uponlinetime = date('Y-m-d', $data[$j]['uponlinetime']);
        }else{
            $uponlinetime = '無(wú)';
        }
        $objPHPExcel->getActiveSheet()->setCellValue('F'.$z, $uponlinetime);
        //版權(quán)下線時(shí)間
        if($data[$j]['downonlinetime']){
            $downonlinetime = date('Y-m-d', $data[$j]['downonlinetime']);
        }else{
            $downonlinetime = '無(wú)';
        }
        $objPHPExcel->getActiveSheet()->setCellValue('G'.$z, $downonlinetime);
        //版權(quán)到期時(shí)間
        if($data[$j]['timeoff']){
            $timeoff = $data[$j]['timeoff'];
        }else{
            $timeoff = '無(wú)';
        }
        $objPHPExcel->getActiveSheet()->setCellValue('H'.$z, $timeoff);
        //審核狀態(tài)
        if(!$data[$j]['aduitstate']){
            $aduitstate = '未審核';
        }else if($data[$j]['aduitstate'] == '1'){
            $aduitstate = '審核成功';
        }else if($data[$j]['aduitstate'] == '2'){
            $aduitstate = '待修改';
        }
        $objPHPExcel->getActiveSheet()->setCellValue('I'.$z, $aduitstate);
        $objPHPExcel->getActiveSheet()->setCellValue('J'.$z, $data[$j]['username']);
        $objPHPExcel->getActiveSheet()->setCellValue('K'.$z, date('Y-m-d', $data[$j]['time']));
    }

    $objPHPExcel->getActiveSheet()->setTitle($sheetname); //題目
    $objPHPExcel->setActiveSheetIndex(0); //設(shè)置當(dāng)前的sheet
    header('Content-Type: application/vnd.ms-excel');
    header('Content-Disposition: attachment;filename="' . $savefile . '.xls"');//文件名稱
    header('Cache-Control: max-age=0');
    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); //Excel5
    $objWriter->save('php://output');
}