<?php
include_once('./_common.php');
function column_char($i) { return chr( 65 + $i ); }
include_once(G5_LIB_PATH.'/PHPExcel.php');
// $bo_table = $_GET["bo_table"];
$bo_table = "voice";
// $wr_id = $_GET["wr_id"];
$headers = array('wr_id','작성일시','이름', 'ID', '정책제안','추천수','추천인');
$widths  = array(10,30,30,30,100,10,100);
$header_bgcolor = 'FFABCDEF';
$last_char = column_char(count($headers) - 1);
$sql = "select * from g5_write_{$bo_table}  where wr_is_comment = 0 order by wr_id desc";
$result = sql_query($sql);
for($i=1; $row=sql_fetch_array($result); $i++) {
    $sql1 = "select mb_id from g5_board_good where bo_table = '{$bo_table}' and wr_id = '{$row[wr_id]}' and bg_flag = 'good'";
    $result1 = sql_query($sql1);
    while($row1 = sql_fetch_array($result1)) {
        $r_id[] = $row1['mb_id'];
    }
 
    $r_list = implode(",", $r_id); 
    $rows[] =
    array(
        $row['wr_id'],
        $row['wr_datetime'],
        $row['wr_name'],
        $row['mb_id'],
        $row['wr_subject'],
        $row['wr_good'],$r_list
        );
}
$data = array_merge(array($headers), $rows);
$excel = new PHPExcel();
$excel->setActiveSheetIndex(0)->getStyle( "A1:${last_char}1" )->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB($header_bgcolor);
$excel->setActiveSheetIndex(0)->getStyle( "A:$last_char" )->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER)->setWrapText(true);
foreach($widths as $i => $w) $excel->setActiveSheetIndex(0)->getColumnDimension( column_char($i) )->setWidth($w);
$excel->getActiveSheet()->fromArray($data,NULL,'A1');
header("Content-Type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"voice_good-".date("ymd", time()).".xls\"");
header("Cache-Control: max-age=0");
$writer = PHPExcel_IOFactory::createWriter($excel, 'Excel5');
$writer->save('php://output');
?>