포인트 보기에서 기간별로 검색이 필요한데요... > 그누4 질문답변

그누4 질문답변

그누보드4 관련 질문은 QA 로 이전됩니다. QA 그누보드4 바로가기
기존 게시물은 열람만 가능합니다.

포인트 보기에서 기간별로 검색이 필요한데요... 정보

포인트 보기에서 기간별로 검색이 필요한데요...

본문

포인트 보기에서 기간별로 검색이 필요해서 천상재회 님의 소스를 붙여 보았는데
계속 아래와 같은 에러만 납니다.  어떻게 해야 하나요?

아래는 에러 메세지와 천상재회님의 point.php 소스입니다.
여백이 문제라고 하는데 잘 모르겠네요.
-----------------------------------------------------------------------------

Parse error: parse error, unexpected T_SL, expecting ',' or ';' in /home/hosting_users/hmbc_hmbc2/www/hboard3/bbs/point_cp.php on line 142

=============================================================================



<?
include_once("./_common.php");

if (!$member[mb_id])
    alert_close("회원만 조회하실 수 있습니다.");

if (empty($fr_date)) {
$chk_time = time() - (86400*7);
$fr_date = date("Y-m-d", $chk_time);
}
if (empty($to_date)) $to_date = $g4[time_ymd];

$g4[title] = $member[mb_nick] . "님의 포인트 내역";
include_once("$g4[path]/head.sub.php");

$list = array();

$sql_common = " from $g4[point_table] ";

$sql_search = " where (1) ";
if ($stx) {
    $sql_search .= " and ( ";
    switch ($sfl) {
        case "mb_id" :
            $sql_search .= " ($sfl = '$stx') ";
            break;
        default :
            $sql_search .= " ($sfl like '%$stx%') ";
            break;
    }
    $sql_search .= " ) ";
}

$sql_common = " from $g4[point_table] where mb_id = '$member[mb_id]' ";

if($area) {
        switch ($area) {
        case "+" :
            $sql_common .= " and po_point > '0' ";
            break;
        case "-" :
            $sql_common .= " and po_point < '0' ";
break;
default :
            $sql_common .= " ";
            break;
}
}

$sql_common .= " and po_datetime between '$fr_date' and '$to_date' ";

if ($stx) {
$sfl = "po_content";
    $sql_common .= " and ( ";
$sql_common .= " ($sfl like '%$stx%') ";   
    $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; // 시작 열을 구함
$listall = "<a href='$_SERVER[PHP_SELF]'>처음</a>";
?>

<table width="600" height="40" 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="590" height="30" border="0" cellpadding="0" cellspacing="0" align='center'>
<form name=fsearch method=get>
<tr>
    <td width=20% align=left style='padding-left:10px;'>
        <?=$listall?> (건수 : <?=number_format($total_count)?>)               
    </td>
    <td width=80% align=right>
    기간 :
        <input type='text' name='fr_date' size=10 maxlength=10 value='<?=$fr_date?>' class=ed>
        -
        <input type='text' name='to_date' size=10 maxlength=10 value='<?=$to_date?>' class=ed>
    <select name=area class=select>
<option value="">구분</option>
        <option value="+">지급포인트</option>
        <option value="-">사용포인트</option>       
        </select>
<script language="JavaScript">document.getElementById("area").value = "<?=$area?>";</script>
        <input type=text name=stx itemname='검색어' value='<?=$stx?>'>
        <input type=image src='<?=$g4[admin_path]?>/img/btn_search.gif' align=absmiddle></td>
</tr>
</form>
</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="5"></td>
        </tr>
        <tr>
            <td height="2" bgcolor="#808080"></td>
        </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;'>&nbsp;$row[po_content]</a></td>
                        <td align=right>{$point1}&nbsp;</td>
                        <td align=right>{$point2}&nbsp;</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}&nbsp;</td>
                        <td align=right>{$sum_point2}&nbsp;</td>
                    </tr>
HEREDOC;
                }
                ?>
                </table></td>
        </tr>
        </table></td>
</tr>
<tr>
    <td height="25" align="center"><?=get_paging($config[cf_write_pages], $page, $total_page, "$_SERVER[PHP_SELF]?$qstr&page=");?></td>
</tr>
<tr>
    <td height="25" 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="30" 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;'>&nbsp;$row[po_content]</a></td>
        <td align=right>$point1&nbsp;</td>
        <td align=right>$point2&nbsp;</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>&nbsp;&nbsp;&nbsp;<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");
?>
  • 복사

댓글 전체

© SIRSOFT
현재 페이지 제일 처음으로