require $_SERVER['DOCUMENT_ROOT'].'/lib/global.php';
if($memberInfo['m_idx'] == '1147') msg('', 'mac3.siso');
auth_limit($thisConnAuth != '' ? $thisConnAuth : 'root');
//print_r($_GET);
//$_WHERE = " WHERE 1 ";
$type=$_GET["type"];
if ($type=="" || $type=="member")
{
$kk_idx = $_GET["kk_idx"];
$kk_ip = $_GET["kk_ip"];
$kk_id = $_GET["kk_id"];
//$_WHERE = " WHERE ke_kkid='".$kk_id."' and ke_kkip='".$kk_ip."'";
$_WHERE = " WHERE m_idx!='1'";
if($_REQUEST['pc_type'] != ''){
$_WHERE .= " AND PS.pc_type='".$_REQUEST['pc_type']."' ";
}
if($_REQUEST['pcidx'] != ''){
$_WHERE .= " AND PS.pc_idx='".$_REQUEST['pcidx']."' ";
}
$_SELECT = '*';
//$_TABLE = '_POINT_SAVE PS join _MEMBER M on PS.m_idx=M.m_idx';
$_TABLE = '_MEMBER';
$_TABLE1 = '_MEMBER';
$_ORDER = ' ORDER BY m_idx ASC';
$_TAGS = '';
}else if ($type=="banner")
{
$_SELECT = '*';
$_TABLE = '_BANNER';
$_TABLE1 = '_BANNER';
$_ORDER = ' ORDER BY m_idx ASC';
}else{
$kk_ip = "";
$kk_id = "";
$_WHERE = " ";
$_SELECT = "*";
$_TABLE = "";
$_TABLE1 = "";
$_ORDER = "";
$_TAGS = '';
}
$onePageCount = 200000;
$pagenum = $_REQUEST['pagenum'] ? $_REQUEST['pagenum'] : 1;
$offset = ($pagenum-1) * $onePageCount;
//$total = getValue($_TABLE1, $_WHERE, 'CNT', 'COUNT(*) AS CNT');
$total = getValue($_TABLE, $_WHERE, 'CNT', 'COUNT(*) AS CNT');
$no = $total - ($pagenum-1) * $onePageCount;
//$useCnt = getValue('_IP_LIST', " where ip_ing_tr_pc = 'N' ", 'cnt', 'count(*) as cnt');
//$sql = "select ".$_SELECT." FROM ".$_TABLE." ".$_GROUP." ".$_ORDER." limit ".$offset.", ".$onePageCount;
$sql = "select ".$_SELECT." FROM ".$_TABLE." ".$_WHERE." ".$_ORDER." limit ".$offset.", ".$onePageCount;
//echo $sql;
//echo $sql;exit;
$rs = query($sql);
if(rows() > 0){
for($i=0; $row = assoc($rs); $i++){
$row['num'] = $no--;
$list[] = $row;
}
}else{
echo "";
exit;
}
if($total > 0)
$toalPageCn = ceil($total/$onePageCount);
else
$toalPageCn = 1;
$paging = disPgCount($toalPageCn, $pagenum, $_TAGS, 1);
//print_r($list);
header("Content-type: application/vnd.ms-excel");
header("Content-type: application/vnd.ms-excel; charset=utf-8");
header("Content-Disposition: attachment; filename=회원현황_".date("YmdHi").".xls");
header("Content-Description: PHP4 Generated Data");
if ($type=="member")
{
//테이블 상단 만들기
$EXCEL_STR = "
번호 |
고유값 |
핸드폰번호 |
가입일 |
최종로그인 |
";
for($i=0;count($list)>$i;$i++)
{
$EXCEL_STR .= "
".$list[$i]["num"]." |
".$list[$i]["m_uniq"]." |
".$list[$i]["m_hp"]." |
".$list[$i]["regdate"]." |
".$list[$i]["m_lastlogindate"]." |
";
}
}else if ($type=="banner"){
$EXCEL_STR = "
번호 |
배너제목 |
시작일 |
종료일 |
상태 |
등록일 |
";
for($i=0;count($list)>$i;$i++)
{
$EXCEL_STR .= "
".$list[$i]["num"]." |
".$list[$i]["b_name"]." |
".$list[$i]["b_startdate"]." |
".$list[$i]["b_enddate"]." |
".$list[$i]["b_status"]." |
".$list[$i]["b_regdate"]." |
";
}
}
$EXCEL_STR .= "
";
echo " ";
echo $EXCEL_STR;
?>