Ejemplo n.º 1
0
function alert_after($str)
{
    echo "<script>\r\n    parent.document.getElementById('upload_button').style.display = 'inline';\r\n    parent.document.getElementById('uploading').style.display = 'none';\r\n    parent.document.getElementById('register').style.display = 'none';\r\n    parent.document.getElementById('upload_info').style.display = 'none';\r\n    </script>";
    alert_just($str);
}
    alert_just('다운로드 할 휴대폰번호 그룹을 선택해주세요.');
}
if ($bg_no == 'all') {
    $sql_bg = "";
} else {
    $sql_bg = "and bg_no='{$bg_no}'";
}
if ($no_hp) {
    $sql_hp = "";
} else {
    $sql_hp = "and bk_hp<>''";
}
$sql = "select count(*) as cnt from {$g5['sms5_book_table']} where 1 {$sql_bg} {$sql_hp} order by bk_name";
$total = sql_fetch($sql);
if (!$total['cnt']) {
    alert_just('데이터가 없습니다.');
}
$qry = sql_query("select * from {$g5['sms5_book_table']} where 1 {$sql_bg} {$sql_hp} order by bk_name");
/*================================================================================
php_writeexcel http://www.bettina-attack.de/jonny/view.php/projects/php_writeexcel/
=================================================================================*/
include_once G5_LIB_PATH . '/Excel/php_writeexcel/class.writeexcel_workbook.inc.php';
include_once G5_LIB_PATH . '/Excel/php_writeexcel/class.writeexcel_worksheet.inc.php';
$fname = tempnam(G5_DATA_PATH, "tmp.xls");
$workbook = new writeexcel_workbook($fname);
$worksheet = $workbook->addworksheet();
$num2_format =& $workbook->addformat(array(num_format => '\\0#'));
// Put Excel data
$data = array('이름', '전화번호');
$data = array_map('iconv_euckr', $data);
$col = 0;