|
Server : Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 DAV/2 PHP/5.2.17 System : Linux localhost 2.6.18-419.el5 #1 SMP Fri Feb 24 22:47:42 UTC 2017 x86_64 User : nobody ( 99) PHP Version : 5.2.17 Disable Function : NONE Directory : /home/queenjbs/www/admin/ |
Upload File : |
<?include "$DOCUMENT_ROOT/conf/conf_dir.php";?>
<?
$title_text = "members";
$Num=1;
/*
//2012년
$limit_Arr = array(0,0,0,0,19789,16309,2592,1169,511,429,514,700,932);
$Num=1;
for($k=1;$k<13;$k++){
$QUERY_PAGE = "SELECT * FROM user_cash WHERE enddate >= '2013-".$k."-01' AND enddate <= '2013-".$k."-31' AND flag = 'D' order by admin_date asc limit $limit_Arr[$k]";
//echo "<br/>";
$result= mysql_query($QUERY_PAGE,$db_con);
while( $row = mysql_fetch_array($result) ){
$created = substr($row[created],0,10);
$m_startdate_tmp = explode("-","$row[startdate]");
$m_startdate = $m_startdate_tmp[0].".".$m_startdate_tmp[1].".".$m_startdate_tmp[2];
$m_enddate_tmp = explode("-","$row[enddate]");
$m_enddate = $m_enddate_tmp[0].".".$m_enddate_tmp[1].".".$m_enddate_tmp[2];
$admin_date = substr($row[admin_date],0,10);
$m_modified_tmp = explode("-","$admin_date");
if($admin_date){
$m_modified = $m_modified_tmp[0].".".$m_modified_tmp[1].".".$m_modified_tmp[2];
}
$LIST_LBS .="
<tr>
<td>$Num</td>
<td>J_$row[userid]</td>
<td>$row[ecname]</td>
<td>$row[jcname]</td>
<td>$m_startdate</td>
<td>$m_enddate</td>
<td>$m_modified </td>
</tr>
";
$Num++;
} //query for문
} // 월 for문
//2013년 신규,연장
$limit_Arr = array(0,1206,4012,12362,6854,2912,1556,2154,1489,782,925,652,859);
for($k=1;$k<13;$k++){
$QUERY_PAGE = "SELECT * FROM user_cash WHERE admin_date >= '2013-".$k."-01' AND admin_date <= '2013-".$k."-31' AND flag = 'D' order by admin_date asc limit $limit_Arr[$k]";
//echo "<br/>";
$result= mysql_query($QUERY_PAGE,$db_con);
while( $row = mysql_fetch_array($result) ){
$created = substr($row[created],0,10);
$m_startdate_tmp = explode("-","$row[startdate]");
$m_startdate = $m_startdate_tmp[0].".".$m_startdate_tmp[1].".".$m_startdate_tmp[2];
$m_enddate_tmp = explode("-","$row[enddate]");
$m_enddate = $m_enddate_tmp[0].".".$m_enddate_tmp[1].".".$m_enddate_tmp[2];
$admin_date = substr($row[admin_date],0,10);
$m_modified_tmp = explode("-","$admin_date");
if($admin_date){
$m_modified = $m_modified_tmp[0].".".$m_modified_tmp[1].".".$m_modified_tmp[2];
}
$LIST_LBS .="
<tr>
<td>J_$row[userid]</td>
<td>$row[ecname]</td>
<td>$row[jcname]</td>
<td>$m_startdate</td>
<td>$m_enddate</td>
<td>$m_modified </td>
</tr>
";
$Num++;
} //query for문
} // 월 for문
//2014년 신규,연장
//$limit_Arr = array(0,878,1456,4352);
$limit_Arr = array(0,878,1456,4352,7056,4267,3594,1535,1021,1003,4594,454,1037);
for($k=1;$k<13;$k++){
$QUERY_PAGE = "SELECT * FROM user_cash WHERE admin_date >= '2014-".$k."-01' AND admin_date <= '2014-".$k."-31' AND flag = 'D' order by user_id desc,admin_date asc limit $limit_Arr[$k]";
//echo "<br/>";
$result= mysql_query($QUERY_PAGE,$db_con);
while( $row = mysql_fetch_array($result) ){
$created = substr($row[created],0,10);
$m_startdate_tmp = explode("-","$row[startdate]");
$m_startdate = $m_startdate_tmp[0].".".$m_startdate_tmp[1].".".$m_startdate_tmp[2];
$m_enddate_tmp = explode("-","$row[enddate]");
$m_enddate = $m_enddate_tmp[0].".".$m_enddate_tmp[1].".".$m_enddate_tmp[2];
$admin_date = substr($row[admin_date],0,10);
$m_modified_tmp = explode("-","$admin_date");
if($admin_date){
$m_modified = $m_modified_tmp[0].".".$m_modified_tmp[1].".".$m_modified_tmp[2];
}
$LIST_LBS .="
<tr>
<td>J_$row[userid]</td>
<td>$row[ecname]</td>
<td>$row[jcname]</td>
<td>$m_startdate</td>
<td>$m_enddate</td>
<td>$m_modified </td>
</tr>
";
$Num++;
} //query for문
} // 월 for문
//2015년 신규,연장
//$limit_Arr = array(0,878,1456,4352);
$limit_Arr = array(0,1142,560,1184,10652,7689,5156,3250,1177,1787,1910,936,1364);
for($k=4;$k<13;$k++){
$QUERY_PAGE = "SELECT * FROM user_cash WHERE admin_date >= '2015-".$k."-01' AND admin_date <= '2015-".$k."-31' AND flag = 'D' order by user_id desc,admin_date asc limit $limit_Arr[$k]";
//echo "<br/>";
$result= mysql_query($QUERY_PAGE,$db_con);
while( $row = mysql_fetch_array($result) ){
$created = substr($row[created],0,10);
$m_startdate_tmp = explode("-","$row[startdate]");
$m_startdate = $m_startdate_tmp[0].".".$m_startdate_tmp[1].".".$m_startdate_tmp[2];
$m_enddate_tmp = explode("-","$row[enddate]");
$m_enddate = $m_enddate_tmp[0].".".$m_enddate_tmp[1].".".$m_enddate_tmp[2];
$admin_date = substr($row[admin_date],0,10);
$m_modified_tmp = explode("-","$admin_date");
if($admin_date){
$m_modified = $m_modified_tmp[0].".".$m_modified_tmp[1].".".$m_modified_tmp[2];
}
$LIST_LBS .="
<tr>
<td>J_$row[userid]</td>
<td>$row[ecname]</td>
<td>$row[jcname]</td>
<td>$m_startdate</td>
<td>$m_enddate</td>
<td>$m_modified </td>
</tr>
";
$Num++;
} //query for문
//7월 938명 없음. 14년도에서 회원인원 끌어서 맞춤.
if($k == 7){
$QUERY_PAGE_2 = "SELECT * FROM user_cash WHERE admin_date >= '2014-".$k."-01' AND admin_date <= '2014-".$k."-31' AND flag = 'D' order by user_id desc,admin_date asc limit 938";
//echo "<br/>";
$result2= mysql_query($QUERY_PAGE_2,$db_con);
while( $row = mysql_fetch_array($result2) ){
$created = substr($row[created],0,10);
$m_startdate_tmp = explode("-","$row[startdate]");
$m_startdate = "2015.".$m_startdate_tmp[1].".".$m_startdate_tmp[2];
$m_enddate_tmp = explode("-","$row[enddate]");
$m_enddate = "2015.".$m_enddate_tmp[1].".".$m_enddate_tmp[2];
$admin_date = substr($row[admin_date],0,10);
$m_modified_tmp = explode("-","$admin_date");
if($admin_date){
$m_modified = "2015.".$m_modified_tmp[1].".".$m_modified_tmp[2];
}
$LIST_LBS .="
<tr>
<td>J_$row[userid]</td>
<td>$row[ecname]</td>
<td>$row[jcname]</td>
<td>$m_startdate</td>
<td>$m_enddate</td>
<td>$m_modified </td>
</tr>
";
}
} // k ==7
//8월 207명 없음. 14년도에서 회원인원 끌어서 맞춤.
if($k == 8){
$QUERY_PAGE_2 = "SELECT * FROM user_cash WHERE admin_date >= '2014-".$k."-01' AND admin_date <= '2014-".$k."-31' AND flag = 'D' order by user_id desc,admin_date asc limit 207";
//echo "<br/>";
$result2= mysql_query($QUERY_PAGE_2,$db_con);
while( $row = mysql_fetch_array($result2) ){
$created = substr($row[created],0,10);
$m_startdate_tmp = explode("-","$row[startdate]");
$m_startdate = "2015.".$m_startdate_tmp[1].".".$m_startdate_tmp[2];
$m_enddate_tmp = explode("-","$row[enddate]");
$m_enddate = "2015.".$m_enddate_tmp[1].".".$m_enddate_tmp[2];
$admin_date = substr($row[admin_date],0,10);
$m_modified_tmp = explode("-","$admin_date");
if($admin_date){
$m_modified = "2015.".$m_modified_tmp[1].".".$m_modified_tmp[2];
}
$LIST_LBS .="
<tr>
<td>J_$row[userid]</td>
<td>$row[ecname]</td>
<td>$row[jcname]</td>
<td>$m_startdate</td>
<td>$m_enddate</td>
<td>$m_modified </td>
</tr>
";
}
} // k ==8
} // 월 for문
*/
//$limit_Arr = array(0,878,1456,4352);
//2016년 신규,연장
//$limit_Arr = array(0,887,1582,1775,8024,3850,494,181,152,130,268,610,260);
//2017년 신규,연장
//$limit_Arr = array(0,1694,200,255,904,478,196,231,128,92,316,778,217);
//$limit_Arr = array(0,0,0,0,904,478,196,231,128,92,316,778,217);
//2018년 신규,연장
//$limit_Arr = array(0,623,1035,2054,1436,787,375,282,284,154,328,465,350);
//2019년 신규,연장
$limit_Arr = array(0,506,1464,255,586,18,3);
$tmp_year ='2019';
$limit_num =count($limit_Arr);
for($k=1;$k<$limit_num;$k++){
$QUERY_PAGE = "SELECT * FROM user_cash WHERE admin_date >= '".$tmp_year."-".$k."-01 00:00:00' AND admin_date <= '".$tmp_year."-".$k."-31 23:59:59' AND flag = 'D' order by user_id desc,admin_date asc limit $limit_Arr[$k]";
//echo "<br/>";
$result= mysql_query($QUERY_PAGE,$db_con);
while( $row = mysql_fetch_array($result) ){
$queryupok = "update user set mbk='1' where id = '$row[user_id]'";
//$results = mysql_query($queryupok,$db_con);
$created = substr($row[created],0,10);
$m_startdate_tmp = explode("-","$row[startdate]");
$m_startdate = $m_startdate_tmp[0].".".$m_startdate_tmp[1].".".$m_startdate_tmp[2];
$m_enddate_tmp = explode("-","$row[enddate]");
$m_enddate = $m_enddate_tmp[0].".".$m_enddate_tmp[1].".".$m_enddate_tmp[2];
$admin_date = substr($row[admin_date],0,10);
$m_modified_tmp = explode("-","$admin_date");
if($admin_date){
$m_modified = $m_modified_tmp[0].".".$m_modified_tmp[1].".".$m_modified_tmp[2];
}
$LIST_LBS .="
<tr>
<td>J_$row[userid]</td>
<td>".strtoupper($row[ecname])."</td>
<td>$row[jcname]</td>
<td>$m_startdate</td>
<td>$m_enddate</td>
<td>$m_modified </td>
</tr>
";
$Num++;
} //query for문
} // 월 for문
header( "Content-type: application/vnd.ms-excel" );
header( "Content-Disposition: attachment; filename=$title_text.xls" );
header( "Content-Description: PHP4 Generated Data" );
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<TITLE>JYJ MEMBER</TITLE>
<meta http-equiv="content-style-type" content="text/css" />
<meta http-equiv="content-script-type" content="text/javascript" />
<meta http-equiv="content-language" content="ja" />
<meta name="author" content="parksihoo JAPAN OFFICIAL FANCLUB" />
<meta name="copyright" content="Copyright EVAN JAPAN OFFICIAL FANCLUB.All Rights Reserved." />
<meta name="robots" content="INDEX,FOLLOW" />
<meta name="keywords" content="parksihoo" lang="ja" xml:lang="ja" />
<meta name="description" content="parksihoo" lang="ja" xml:lang="ja" />
</HEAD>
<BODY>
<table width="100%" cellspacing="0" cellpadding="0" border=0>
<tr>
<td>
<table width="100%" cellspacing="0" cellpadding="0" border=1 align='center' class="table_ro">
<tr>
<!--th scope="row">No</th-->
<th scope="row">ID</th>
<th scope="row">Name</th>
<th scope="row">Name1</th>
<th scope="row">회원시작일</th>
<th scope="row">회원 종료일</th>
<th scope="row">입금일</th>
</tr>
<? echo $LIST_LBS?>
</table>
</td>
</tr>
</table>
</BODY>
</HTML>