선생님들 부탁드려요! [ 포인트 조회에서 검색창을 달 수 있나요? ] 정보
선생님들 부탁드려요! [ 포인트 조회에서 검색창을 달 수 있나요? ]본문
<?
include_once("./_common.php");
include_once("$g4[path]/lib/outlogin.lib.php");
include_once("$g4[path]/head.sub.php");
include_once("$g4[path]/lib/visit.lib.php");
include_once("$g4[path]/lib/connect.lib.php");
include_once("$g4[path]/lib/latest.lib.php");
include_once("$g4[path]/include/soho_top.php");//상단
include_once("$g4[path]/include/member_left.php");//좌측
if ($config[cf_home_member09] >= 2)
{
if (!$member[mb_id]){
goto_url("$g4[bbs_path]/login.php");
}
else if($member[mb_level] < $home_member09) {
alert($cf_member_msg);
}
} else {
if($member[mb_level] < $home_member09 ){
alert($cf_member_msg);
}}
$list = array();
$sql_common = " from $g4[point_table] where mb_id = '$member[mb_id]' ";
$sql_order = " order by po_id desc ";
$sql = " select count(*) as cnt $sql_common ";
$row = sql_fetch($sql);
$total_count = $row[cnt];
$rows = $config[cf_page_rows];
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if (!$page) { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
?>
<table width='<?=$home_page_width?>' cellpadding=0 cellspacing=0>
<tr><td bgcolor=#B8B7B7><img src='<?=$g4[bbs_img_path]?>/title_point2.gif'></td></tr>
</table>
<p>
<table width='99%' align=center cellpadding=1 cellspacing=0 bgcolor=#CCCCCC>
<tr>
<td>
<table width='100%' cellpadding=0 cellspacing=0 bgcolor=#F9F9F9>
<tr>
<td width='100%' height=40 align=left> <img src='<?=$g4[bbs_img_path]?>/icon_02.gif'> 보유 포인트 : <B><?=number_format($member[mb_point])?>(총 건수 : <?=number_format($total_count)?>)</B>
<?
$sql = " select count(mb_id) as cnt from $g4[member_table]
where mb_point >= '$member[mb_point]' order by mb_point desc ";
$row = sql_fetch($sql);
$sql2 = " select count(mb_id) as cnt from $g4[member_table]";
$row2 = sql_fetch($sql2);
$total_cnt = $row2[cnt];
echo " <img src='$g4[bbs_img_path]/icon_02.gif'> 랭킹은 <b>".$total_cnt."</b> 명중 <B><font color=red>".number_format($row[cnt])." 위</font></B> 입니다.";?>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<table width='99%' align=center cellpadding=3 cellspacing=0 border=1 bordercolordark=#F0F0F0>
<colgroup width=130></colgroup>
<colgroup width=''></colgroup>
<colgroup width=70></colgroup>
<colgroup width=70></colgroup>
<tr height=25 bgcolor=#F9F9F9 align=center>
<td>일시</td>
<td>내용</td>
<td>지급포인트</td>
<td>사용포인트</td>
</tr>
<?
$sum_point1 = $sum_point2 = 0;
$sql = " select *
$sql_common
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) {
$point1 = $point2 = 0;
if ($row[po_point] > 0) {
$point1 = "+" . number_format($row[po_point]);
$sum_point1 += $row[po_point];
} else {
$point2 = number_format($row[po_point]);
$sum_point2 += $row[po_point];
}
echo "
<tr height=25>
<td align=center>$row[po_datetime]</td>
<td title='$row[po_content]'><nobr style='display:block; overflow:hidden; width:200px;'> $row[po_content]</a></td>
<td align=right>$point1 </td>
<td align=right>$point2 </td>
</tr>
";
}
if ($i == 0)
echo "<tr><td colspan=4 align=center height=100>자료가 없습니다.</td></tr>";
?>
</table>
<table width='100%' cellpadding=3 cellspacing=0>
<tr><td height=45 align=center><?=get_paging($config[cf_write_pages], $page, $total_page, "$_SERVER[PHP_SELF]?$qstr&page=");?></td></tr>
</table>
</td>
</tr></table>
<!-- 하단공간 -->
<table border="0" cellpadding="0" cellspacing="0" width="<?=$home_width01?>">
<tr><td height="<?=$home_margin2?>" bgcolor="ffffff"></td></tr></table>
<?
include_once("$g4[path]/include/speedmap.php");
include_once("$g4[path]/_tail.php");
?>
소스인데요 여기에 월별로 포인트를 검색하는 기능을 넣을수는 없나요?
기존에 있는 스킨을보니 회원별 랭킹스킨 하단에 검색창이 있어서 응용해보기도하고
나름 삽질을 해봤는데 도저희 안되겠습니다. ㅠㅠ
저좀 살려주세요~
추가.
검색창이 아니여도 되구요 그냥 날짜별로 클릭하면 해당 월만 나오게 하면됩니다.
2013년 1월 클릭시 2013년 1월만 나오게요
부탁드립니다!!
댓글 전체
기존 그누보드 소스(bbs/point.php) 에 월별검새기능을 추가 했습니다...
[월별검색]이라고 주석 단 부분을 보세요~
이소스에 년도를 추가하면 되겠네요!!
//======소스=========
<?
include_once("./_common.php");
if (!$member[mb_id])
alert_close("회원만 조회하실 수 있습니다.");
$g4[title] = $member[mb_nick] . "님의 포인트 내역";
include_once("$g4[path]/head.sub.php");
$list = array();
$sql_common = " from $g4[point_table] where mb_id = '".mysql_real_escape_string($member[mb_id])."' ";
/********************************************************/
/* [월별검색] 월이 지정되어 있으면 월별 검색추가 */
/*******************************************************/
if($month>0) $sql_common .= " and month(po_datetime)= $month ";
$sql_order = " order by po_id desc ";
$sql = " select count(*) as cnt $sql_common ";
$row = sql_fetch($sql);
$total_count = $row[cnt];
$rows = $config[cf_page_rows];
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if (!$page) { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
?>
<table width="600" height="50" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle" bgcolor="#EBEBEB"><table width="590" height="40" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="25" align="center" bgcolor="#FFFFFF" ><img src="<?=$g4[bbs_img_path]?>/icon_01.gif" width="5" height="5"></td>
<td width="" align="left" bgcolor="#FFFFFF" ><font color="#666666"><b><?=$g4[title]?></b></font></td>
</tr>
</table></td>
</tr>
</table>
<table width="600" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="200" align="center" valign="top"><table width="540" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="20"></td>
</tr>
<tr>
<td height="2" bgcolor="#808080"></td>
</tr>
<!--
/********************************************************/
/* [월별검색] 월 선택옵션 */
/*******************************************************/
-->
<tr>
<select name="sel_mon" onchange="select_mon();">
<option selected>전체</option>
<option>01</option>
<option>02</option>
<option>03</option>
<option>04</option>
<option>05</option>
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
<option>12</option>
<select/>월
</tr>
<tr>
<td width="540" bgcolor="#FFFFFF">
<table width=100% cellpadding=1 cellspacing=1 border=0>
<tr bgcolor=#E1E1E1 align=center>
<td width="130" height="24"><b>일시</b></td>
<td width=""><b>내용</b></td>
<td width="70"><b>지급포인트</b></td>
<td width="70"><b>사용포인트</b></td>
</tr>
<?
$sum_point1 = $sum_point2 = 0;
$sql = " select *
$sql_common
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) {
$point1 = $point2 = 0;
if ($row[po_point] > 0) {
$point1 = "+" . number_format($row[po_point]);
$sum_point1 += $row[po_point];
} else {
$point2 = number_format($row[po_point]);
$sum_point2 += $row[po_point];
}
echo <<<HEREDOC
<tr height=25 bgcolor="#F6F6F6" align="center">
<td height="24">$row[po_datetime]</td>
<td align="left" title='$row[po_content]'><nobr style='display:block; overflow:hidden; width:250px;'> $row[po_content]</a></td>
<td align=right>{$point1} </td>
<td align=right>{$point2} </td>
</tr>
HEREDOC;
}
if ($i == 0)
echo "<tr><td colspan=5 align=center height=100>자료가 없습니다.</td></tr>";
else {
if ($sum_point1 > 0)
$sum_point1 = "+" . number_format($sum_point1);
$sum_point2 = number_format($sum_point2);
echo <<<HEREDOC
<tr height=25 bgcolor="#E1E1E1" align="center">
<td height="24" colspan=2 align=center>소계</td>
<td align=right>{$sum_point1} </td>
<td align=right>{$sum_point2} </td>
</tr>
HEREDOC;
}
?>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="30" align="center"><?=get_paging($config[cf_write_pages], $page, $total_page, "$_SERVER[PHP_SELF]?$qstr&page=");?></td>
</tr>
<tr>
<td height="30" align="center" bgcolor="#F6F6F6">
<img src='<?=$g4[bbs_img_path]?>/icon_02.gif'> 보유 포인트 : <B><?=number_format($member[mb_point])?> 점</B></td>
</tr>
<tr>
<td height="2" align="center" valign="top" bgcolor="#D5D5D5"></td>
</tr>
<tr>
<td height="2" align="center" valign="top" bgcolor="#E6E6E6"></td>
</tr>
<tr>
<td height="40" align="center" valign="bottom"><a href="javascript:window.close();"><img src="<?=$g4[bbs_img_path]?>/close.gif" width="66" height="20" border="0"></a></td>
</tr>
</table>
<br>
<?/*?>
<table width='100%' cellpadding=0 cellspacing=0>
<tr><td bgcolor=#B8B7B7><img src='<?=$g4[bbs_img_path]?>/title_point.gif'></td></tr>
</table>
<br>
<table width='99%' align=center cellpadding=3 cellspacing=0 border=1 bordercolordark=#F0F0F0>
<colgroup width=130></colgroup>
<colgroup width=''></colgroup>
<colgroup width=70></colgroup>
<colgroup width=70></colgroup>
<tr height=25 bgcolor=#F9F9F9 align=center>
<td>일시</td>
<td>내용</td>
<td>지급포인트</td>
<td>사용포인트</td>
</tr>
<?
$sql = " select *
$sql_common
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) {
$point1 = $point2 = "";
if ($row[po_point] >= 0) {
$point1 = "+" . number_format($row[po_point]);
} else {
$point2 = number_format($row[po_point]);
}
echo "
<tr height=25>
<td align=center>$row[po_datetime]</td>
<td title='$row[po_content]'><nobr style='display:block; overflow:hidden; width:200px;'> $row[po_content]</a></td>
<td align=right>$point1 </td>
<td align=right>$point2 </td>
</tr>
";
}
if ($i == 0)
echo "<tr><td colspan=4 align=center height=100>자료가 없습니다.</td></tr>";
?>
</table>
<table width='100%' cellpadding=3 cellspacing=0>
<tr><td height=45 align=center><?=get_paging($config[cf_write_pages], $page, $total_page, "$_SERVER[PHP_SELF]?$qstr&page=");?></td></tr>
</table>
<table width='99%' align=center cellpadding=1 cellspacing=0 bgcolor=#CCCCCC>
<tr>
<td>
<table width='100%' cellpadding=0 cellspacing=0 bgcolor=#F9F9F9>
<tr>
<td height=50> <B>내 포인트 </B></td>
<td><img src='<?=$g4[bbs_img_path]?>/icon_02.gif'> 보유 포인트 : <B><?=number_format($member[mb_point])?></B></td>
</tr>
</table>
</td>
</tr>
</table>
<table width='100%' cellpadding=3 cellspacing=0>
<tr><td colspan=2 height=45 align=center><a href='javascript:window.close();'><img src='<?=$g4[bbs_img_path]?>/btn_close.gif' border=0></a></td></tr>
</table>
<?*/?>
<?
include_once("$g4[path]/tail.sub.php");
?>
<script>
/********************************************************/
/* [월별검색] 월이 선택되면 페이지 리로드 */
/*******************************************************/
function select_mon(val)
{
alert(sel_mon.selectedIndex);
//기존 변수제거
var str = location.href;
var n=str.indexOf("?");
str=str.substring(0,n);
location.href=str+"?month="+sel_mon.selectedIndex;
}
</script>
[월별검색]이라고 주석 단 부분을 보세요~
이소스에 년도를 추가하면 되겠네요!!
//======소스=========
<?
include_once("./_common.php");
if (!$member[mb_id])
alert_close("회원만 조회하실 수 있습니다.");
$g4[title] = $member[mb_nick] . "님의 포인트 내역";
include_once("$g4[path]/head.sub.php");
$list = array();
$sql_common = " from $g4[point_table] where mb_id = '".mysql_real_escape_string($member[mb_id])."' ";
/********************************************************/
/* [월별검색] 월이 지정되어 있으면 월별 검색추가 */
/*******************************************************/
if($month>0) $sql_common .= " and month(po_datetime)= $month ";
$sql_order = " order by po_id desc ";
$sql = " select count(*) as cnt $sql_common ";
$row = sql_fetch($sql);
$total_count = $row[cnt];
$rows = $config[cf_page_rows];
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if (!$page) { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
?>
<table width="600" height="50" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle" bgcolor="#EBEBEB"><table width="590" height="40" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="25" align="center" bgcolor="#FFFFFF" ><img src="<?=$g4[bbs_img_path]?>/icon_01.gif" width="5" height="5"></td>
<td width="" align="left" bgcolor="#FFFFFF" ><font color="#666666"><b><?=$g4[title]?></b></font></td>
</tr>
</table></td>
</tr>
</table>
<table width="600" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="200" align="center" valign="top"><table width="540" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="20"></td>
</tr>
<tr>
<td height="2" bgcolor="#808080"></td>
</tr>
<!--
/********************************************************/
/* [월별검색] 월 선택옵션 */
/*******************************************************/
-->
<tr>
<select name="sel_mon" onchange="select_mon();">
<option selected>전체</option>
<option>01</option>
<option>02</option>
<option>03</option>
<option>04</option>
<option>05</option>
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
<option>12</option>
<select/>월
</tr>
<tr>
<td width="540" bgcolor="#FFFFFF">
<table width=100% cellpadding=1 cellspacing=1 border=0>
<tr bgcolor=#E1E1E1 align=center>
<td width="130" height="24"><b>일시</b></td>
<td width=""><b>내용</b></td>
<td width="70"><b>지급포인트</b></td>
<td width="70"><b>사용포인트</b></td>
</tr>
<?
$sum_point1 = $sum_point2 = 0;
$sql = " select *
$sql_common
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) {
$point1 = $point2 = 0;
if ($row[po_point] > 0) {
$point1 = "+" . number_format($row[po_point]);
$sum_point1 += $row[po_point];
} else {
$point2 = number_format($row[po_point]);
$sum_point2 += $row[po_point];
}
echo <<<HEREDOC
<tr height=25 bgcolor="#F6F6F6" align="center">
<td height="24">$row[po_datetime]</td>
<td align="left" title='$row[po_content]'><nobr style='display:block; overflow:hidden; width:250px;'> $row[po_content]</a></td>
<td align=right>{$point1} </td>
<td align=right>{$point2} </td>
</tr>
HEREDOC;
}
if ($i == 0)
echo "<tr><td colspan=5 align=center height=100>자료가 없습니다.</td></tr>";
else {
if ($sum_point1 > 0)
$sum_point1 = "+" . number_format($sum_point1);
$sum_point2 = number_format($sum_point2);
echo <<<HEREDOC
<tr height=25 bgcolor="#E1E1E1" align="center">
<td height="24" colspan=2 align=center>소계</td>
<td align=right>{$sum_point1} </td>
<td align=right>{$sum_point2} </td>
</tr>
HEREDOC;
}
?>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="30" align="center"><?=get_paging($config[cf_write_pages], $page, $total_page, "$_SERVER[PHP_SELF]?$qstr&page=");?></td>
</tr>
<tr>
<td height="30" align="center" bgcolor="#F6F6F6">
<img src='<?=$g4[bbs_img_path]?>/icon_02.gif'> 보유 포인트 : <B><?=number_format($member[mb_point])?> 점</B></td>
</tr>
<tr>
<td height="2" align="center" valign="top" bgcolor="#D5D5D5"></td>
</tr>
<tr>
<td height="2" align="center" valign="top" bgcolor="#E6E6E6"></td>
</tr>
<tr>
<td height="40" align="center" valign="bottom"><a href="javascript:window.close();"><img src="<?=$g4[bbs_img_path]?>/close.gif" width="66" height="20" border="0"></a></td>
</tr>
</table>
<br>
<?/*?>
<table width='100%' cellpadding=0 cellspacing=0>
<tr><td bgcolor=#B8B7B7><img src='<?=$g4[bbs_img_path]?>/title_point.gif'></td></tr>
</table>
<br>
<table width='99%' align=center cellpadding=3 cellspacing=0 border=1 bordercolordark=#F0F0F0>
<colgroup width=130></colgroup>
<colgroup width=''></colgroup>
<colgroup width=70></colgroup>
<colgroup width=70></colgroup>
<tr height=25 bgcolor=#F9F9F9 align=center>
<td>일시</td>
<td>내용</td>
<td>지급포인트</td>
<td>사용포인트</td>
</tr>
<?
$sql = " select *
$sql_common
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) {
$point1 = $point2 = "";
if ($row[po_point] >= 0) {
$point1 = "+" . number_format($row[po_point]);
} else {
$point2 = number_format($row[po_point]);
}
echo "
<tr height=25>
<td align=center>$row[po_datetime]</td>
<td title='$row[po_content]'><nobr style='display:block; overflow:hidden; width:200px;'> $row[po_content]</a></td>
<td align=right>$point1 </td>
<td align=right>$point2 </td>
</tr>
";
}
if ($i == 0)
echo "<tr><td colspan=4 align=center height=100>자료가 없습니다.</td></tr>";
?>
</table>
<table width='100%' cellpadding=3 cellspacing=0>
<tr><td height=45 align=center><?=get_paging($config[cf_write_pages], $page, $total_page, "$_SERVER[PHP_SELF]?$qstr&page=");?></td></tr>
</table>
<table width='99%' align=center cellpadding=1 cellspacing=0 bgcolor=#CCCCCC>
<tr>
<td>
<table width='100%' cellpadding=0 cellspacing=0 bgcolor=#F9F9F9>
<tr>
<td height=50> <B>내 포인트 </B></td>
<td><img src='<?=$g4[bbs_img_path]?>/icon_02.gif'> 보유 포인트 : <B><?=number_format($member[mb_point])?></B></td>
</tr>
</table>
</td>
</tr>
</table>
<table width='100%' cellpadding=3 cellspacing=0>
<tr><td colspan=2 height=45 align=center><a href='javascript:window.close();'><img src='<?=$g4[bbs_img_path]?>/btn_close.gif' border=0></a></td></tr>
</table>
<?*/?>
<?
include_once("$g4[path]/tail.sub.php");
?>
<script>
/********************************************************/
/* [월별검색] 월이 선택되면 페이지 리로드 */
/*******************************************************/
function select_mon(val)
{
alert(sel_mon.selectedIndex);
//기존 변수제거
var str = location.href;
var n=str.indexOf("?");
str=str.substring(0,n);
location.href=str+"?month="+sel_mon.selectedIndex;
}
</script>
역시 그누엔 능력자분들이 많으시네요 정말 감사합니다!
복 많이 받으실거에요*^__^*
복 많이 받으실거에요*^__^*
자바스크립트를 쓰면 역시 좀 복잡해지는군요..
그냥 form을 이용해서 다시 작성해 보았습니다
//======소스=========
<?
include_once("./_common.php");
if (!$member[mb_id])
alert_close("회원만 조회하실 수 있습니다.");
$g4[title] = $member[mb_nick] . "님의 포인트 내역";
include_once("$g4[path]/head.sub.php");
$list = array();
$sql_common = " from $g4[point_table] where mb_id = '".mysql_real_escape_string($member[mb_id])."' ";
/********************************************************/
/* [월별검색] 월이 지정되어 있으면 월별 검색추가 */
/*******************************************************/
if($month>0) $sql_common .= " and month(po_datetime)= $month ";
echo $sql_common;//잘나오는지 디버깅
$sql_order = " order by po_id desc ";
$sql = " select count(*) as cnt $sql_common ";
$row = sql_fetch($sql);
$total_count = $row[cnt];
$rows = $config[cf_page_rows];
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if (!$page) { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
?>
<table width="600" height="50" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle" bgcolor="#EBEBEB"><table width="590" height="40" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="25" align="center" bgcolor="#FFFFFF" ><img src="<?=$g4[bbs_img_path]?>/icon_01.gif" width="5" height="5"></td>
<td width="" align="left" bgcolor="#FFFFFF" ><font color="#666666"><b><?=$g4[title]?></b></font></td>
</tr>
</table></td>
</tr>
</table>
<table width="600" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="200" align="center" valign="top"><table width="540" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="20"></td>
</tr>
<tr>
<td height="2" bgcolor="#808080"></td>
</tr>
<!--
/********************************************************/
/* [월별검색] 월 선택옵션 */
/*******************************************************/
-->
<form name=fsearch method=get>
<tr>
<select name="month">
<option value='0' selected>전체</option>
<option value='1' >01</option>
<option value='2' >02</option>
<option value='3'>03</option>
<option value='4'>04</option>
<option value='5'>05</option>
<option value='6'>06</option>
<option value='7'>07</option>
<option value='8'>08</option>
<option value='9'>09</option>
<option value='10'>10</option>
<option value='11'>11</option>
<option value='12'>12</option>
<select/>월
<input type=image src='<?=$g4[admin_path]?>/img/btn_search.gif' align=absmiddle></td>
</tr>
</form>
<tr>
<td width="540" bgcolor="#FFFFFF">
<table width=100% cellpadding=1 cellspacing=1 border=0>
<tr bgcolor=#E1E1E1 align=center>
<td width="130" height="24"><b>일시</b></td>
<td width=""><b>내용</b></td>
<td width="70"><b>지급포인트</b></td>
<td width="70"><b>사용포인트</b></td>
</tr>
<?
$sum_point1 = $sum_point2 = 0;
$sql = " select *
$sql_common
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) {
$point1 = $point2 = 0;
if ($row[po_point] > 0) {
$point1 = "+" . number_format($row[po_point]);
$sum_point1 += $row[po_point];
} else {
$point2 = number_format($row[po_point]);
$sum_point2 += $row[po_point];
}
echo <<<HEREDOC
<tr height=25 bgcolor="#F6F6F6" align="center">
<td height="24">$row[po_datetime]</td>
<td align="left" title='$row[po_content]'><nobr style='display:block; overflow:hidden; width:250px;'> $row[po_content]</a></td>
<td align=right>{$point1} </td>
<td align=right>{$point2} </td>
</tr>
HEREDOC;
}
if ($i == 0)
echo "<tr><td colspan=5 align=center height=100>자료가 없습니다.</td></tr>";
else {
if ($sum_point1 > 0)
$sum_point1 = "+" . number_format($sum_point1);
$sum_point2 = number_format($sum_point2);
echo <<<HEREDOC
<tr height=25 bgcolor="#E1E1E1" align="center">
<td height="24" colspan=2 align=center>소계</td>
<td align=right>{$sum_point1} </td>
<td align=right>{$sum_point2} </td>
</tr>
HEREDOC;
}
?>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="30" align="center"><?=get_paging($config[cf_write_pages], $page, $total_page, "$_SERVER[PHP_SELF]?$qstr&page=");?></td>
</tr>
<tr>
<td height="30" align="center" bgcolor="#F6F6F6">
<img src='<?=$g4[bbs_img_path]?>/icon_02.gif'> 보유 포인트 : <B><?=number_format($member[mb_point])?> 점</B></td>
</tr>
<tr>
<td height="2" align="center" valign="top" bgcolor="#D5D5D5"></td>
</tr>
<tr>
<td height="2" align="center" valign="top" bgcolor="#E6E6E6"></td>
</tr>
<tr>
<td height="40" align="center" valign="bottom"><a href="javascript:window.close();"><img src="<?=$g4[bbs_img_path]?>/close.gif" width="66" height="20" border="0"></a></td>
</tr>
</table>
<br>
<?/*?>
<table width='100%' cellpadding=0 cellspacing=0>
<tr><td bgcolor=#B8B7B7><img src='<?=$g4[bbs_img_path]?>/title_point.gif'></td></tr>
</table>
<br>
<table width='99%' align=center cellpadding=3 cellspacing=0 border=1 bordercolordark=#F0F0F0>
<colgroup width=130></colgroup>
<colgroup width=''></colgroup>
<colgroup width=70></colgroup>
<colgroup width=70></colgroup>
<tr height=25 bgcolor=#F9F9F9 align=center>
<td>일시</td>
<td>내용</td>
<td>지급포인트</td>
<td>사용포인트</td>
</tr>
<?
$sql = " select *
$sql_common
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) {
$point1 = $point2 = "";
if ($row[po_point] >= 0) {
$point1 = "+" . number_format($row[po_point]);
} else {
$point2 = number_format($row[po_point]);
}
echo "
<tr height=25>
<td align=center>$row[po_datetime]</td>
<td title='$row[po_content]'><nobr style='display:block; overflow:hidden; width:200px;'> $row[po_content]</a></td>
<td align=right>$point1 </td>
<td align=right>$point2 </td>
</tr>
";
}
if ($i == 0)
echo "<tr><td colspan=4 align=center height=100>자료가 없습니다.</td></tr>";
?>
</table>
<table width='100%' cellpadding=3 cellspacing=0>
<tr><td height=45 align=center><?=get_paging($config[cf_write_pages], $page, $total_page, "$_SERVER[PHP_SELF]?$qstr&page=");?></td></tr>
</table>
<table width='99%' align=center cellpadding=1 cellspacing=0 bgcolor=#CCCCCC>
<tr>
<td>
<table width='100%' cellpadding=0 cellspacing=0 bgcolor=#F9F9F9>
<tr>
<td height=50> <B>내 포인트 </B></td>
<td><img src='<?=$g4[bbs_img_path]?>/icon_02.gif'> 보유 포인트 : <B><?=number_format($member[mb_point])?></B></td>
</tr>
</table>
</td>
</tr>
</table>
<table width='100%' cellpadding=3 cellspacing=0>
<tr><td colspan=2 height=45 align=center><a href='javascript:window.close();'><img src='<?=$g4[bbs_img_path]?>/btn_close.gif' border=0></a></td></tr>
</table>
<?*/?>
<?
include_once("$g4[path]/tail.sub.php");
?>
그냥 form을 이용해서 다시 작성해 보았습니다
//======소스=========
<?
include_once("./_common.php");
if (!$member[mb_id])
alert_close("회원만 조회하실 수 있습니다.");
$g4[title] = $member[mb_nick] . "님의 포인트 내역";
include_once("$g4[path]/head.sub.php");
$list = array();
$sql_common = " from $g4[point_table] where mb_id = '".mysql_real_escape_string($member[mb_id])."' ";
/********************************************************/
/* [월별검색] 월이 지정되어 있으면 월별 검색추가 */
/*******************************************************/
if($month>0) $sql_common .= " and month(po_datetime)= $month ";
echo $sql_common;//잘나오는지 디버깅
$sql_order = " order by po_id desc ";
$sql = " select count(*) as cnt $sql_common ";
$row = sql_fetch($sql);
$total_count = $row[cnt];
$rows = $config[cf_page_rows];
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if (!$page) { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
?>
<table width="600" height="50" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle" bgcolor="#EBEBEB"><table width="590" height="40" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="25" align="center" bgcolor="#FFFFFF" ><img src="<?=$g4[bbs_img_path]?>/icon_01.gif" width="5" height="5"></td>
<td width="" align="left" bgcolor="#FFFFFF" ><font color="#666666"><b><?=$g4[title]?></b></font></td>
</tr>
</table></td>
</tr>
</table>
<table width="600" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="200" align="center" valign="top"><table width="540" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="20"></td>
</tr>
<tr>
<td height="2" bgcolor="#808080"></td>
</tr>
<!--
/********************************************************/
/* [월별검색] 월 선택옵션 */
/*******************************************************/
-->
<form name=fsearch method=get>
<tr>
<select name="month">
<option value='0' selected>전체</option>
<option value='1' >01</option>
<option value='2' >02</option>
<option value='3'>03</option>
<option value='4'>04</option>
<option value='5'>05</option>
<option value='6'>06</option>
<option value='7'>07</option>
<option value='8'>08</option>
<option value='9'>09</option>
<option value='10'>10</option>
<option value='11'>11</option>
<option value='12'>12</option>
<select/>월
<input type=image src='<?=$g4[admin_path]?>/img/btn_search.gif' align=absmiddle></td>
</tr>
</form>
<tr>
<td width="540" bgcolor="#FFFFFF">
<table width=100% cellpadding=1 cellspacing=1 border=0>
<tr bgcolor=#E1E1E1 align=center>
<td width="130" height="24"><b>일시</b></td>
<td width=""><b>내용</b></td>
<td width="70"><b>지급포인트</b></td>
<td width="70"><b>사용포인트</b></td>
</tr>
<?
$sum_point1 = $sum_point2 = 0;
$sql = " select *
$sql_common
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) {
$point1 = $point2 = 0;
if ($row[po_point] > 0) {
$point1 = "+" . number_format($row[po_point]);
$sum_point1 += $row[po_point];
} else {
$point2 = number_format($row[po_point]);
$sum_point2 += $row[po_point];
}
echo <<<HEREDOC
<tr height=25 bgcolor="#F6F6F6" align="center">
<td height="24">$row[po_datetime]</td>
<td align="left" title='$row[po_content]'><nobr style='display:block; overflow:hidden; width:250px;'> $row[po_content]</a></td>
<td align=right>{$point1} </td>
<td align=right>{$point2} </td>
</tr>
HEREDOC;
}
if ($i == 0)
echo "<tr><td colspan=5 align=center height=100>자료가 없습니다.</td></tr>";
else {
if ($sum_point1 > 0)
$sum_point1 = "+" . number_format($sum_point1);
$sum_point2 = number_format($sum_point2);
echo <<<HEREDOC
<tr height=25 bgcolor="#E1E1E1" align="center">
<td height="24" colspan=2 align=center>소계</td>
<td align=right>{$sum_point1} </td>
<td align=right>{$sum_point2} </td>
</tr>
HEREDOC;
}
?>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="30" align="center"><?=get_paging($config[cf_write_pages], $page, $total_page, "$_SERVER[PHP_SELF]?$qstr&page=");?></td>
</tr>
<tr>
<td height="30" align="center" bgcolor="#F6F6F6">
<img src='<?=$g4[bbs_img_path]?>/icon_02.gif'> 보유 포인트 : <B><?=number_format($member[mb_point])?> 점</B></td>
</tr>
<tr>
<td height="2" align="center" valign="top" bgcolor="#D5D5D5"></td>
</tr>
<tr>
<td height="2" align="center" valign="top" bgcolor="#E6E6E6"></td>
</tr>
<tr>
<td height="40" align="center" valign="bottom"><a href="javascript:window.close();"><img src="<?=$g4[bbs_img_path]?>/close.gif" width="66" height="20" border="0"></a></td>
</tr>
</table>
<br>
<?/*?>
<table width='100%' cellpadding=0 cellspacing=0>
<tr><td bgcolor=#B8B7B7><img src='<?=$g4[bbs_img_path]?>/title_point.gif'></td></tr>
</table>
<br>
<table width='99%' align=center cellpadding=3 cellspacing=0 border=1 bordercolordark=#F0F0F0>
<colgroup width=130></colgroup>
<colgroup width=''></colgroup>
<colgroup width=70></colgroup>
<colgroup width=70></colgroup>
<tr height=25 bgcolor=#F9F9F9 align=center>
<td>일시</td>
<td>내용</td>
<td>지급포인트</td>
<td>사용포인트</td>
</tr>
<?
$sql = " select *
$sql_common
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) {
$point1 = $point2 = "";
if ($row[po_point] >= 0) {
$point1 = "+" . number_format($row[po_point]);
} else {
$point2 = number_format($row[po_point]);
}
echo "
<tr height=25>
<td align=center>$row[po_datetime]</td>
<td title='$row[po_content]'><nobr style='display:block; overflow:hidden; width:200px;'> $row[po_content]</a></td>
<td align=right>$point1 </td>
<td align=right>$point2 </td>
</tr>
";
}
if ($i == 0)
echo "<tr><td colspan=4 align=center height=100>자료가 없습니다.</td></tr>";
?>
</table>
<table width='100%' cellpadding=3 cellspacing=0>
<tr><td height=45 align=center><?=get_paging($config[cf_write_pages], $page, $total_page, "$_SERVER[PHP_SELF]?$qstr&page=");?></td></tr>
</table>
<table width='99%' align=center cellpadding=1 cellspacing=0 bgcolor=#CCCCCC>
<tr>
<td>
<table width='100%' cellpadding=0 cellspacing=0 bgcolor=#F9F9F9>
<tr>
<td height=50> <B>내 포인트 </B></td>
<td><img src='<?=$g4[bbs_img_path]?>/icon_02.gif'> 보유 포인트 : <B><?=number_format($member[mb_point])?></B></td>
</tr>
</table>
</td>
</tr>
</table>
<table width='100%' cellpadding=3 cellspacing=0>
<tr><td colspan=2 height=45 align=center><a href='javascript:window.close();'><img src='<?=$g4[bbs_img_path]?>/btn_close.gif' border=0></a></td></tr>
</table>
<?*/?>
<?
include_once("$g4[path]/tail.sub.php");
?>
선생님 큰일났어요.. 앞에 연도가 들어가야 될것 같아요 ㅠㅠ
쪽지 확인 부탁드립니다 ㅠㅠ
쪽지 확인 부탁드립니다 ㅠㅠ