webadmin.php

/home/mjc1/public_html/html/millennium/_mypagepoint2.php

<?php include_once("./_common2.php"); ?>
<?
    if( $_COOKIE[USERID] == "" ) {
?>

<script>
    alert("È¸¿ø ·Î±×ÀÎ ÈÄ¿¡ ÀÌ¿ë°¡´ÉÇÕ´Ï´Ù.");
    location.href = "intro.php";
</script>

<?
    }
    include("../../manage/category/common.php");
    include('../../html/include/_Head.php');





    mysql_close;
?>
<? 
if ($txtdate == "") { 
$txtdate = ($txtdate == "") ?  date("Y-m-d", strtotime("-7 Day")) : $txtdate; 
  }
if ($txtdate2 == "") { 
 $txtdate2 = ($txtdate2 == "") ? date("Y-m-d", time()) : $txtdate2; 
  }
?>
<script type="text/javascript" src="../../onlinecs/js/PopupCalendar.js"></script>



<script>
function Search(){
    
    searchFrm.submit();
    
}




function setDay(t){// ÀÏÂ÷¸¦ ÆÄ¶ó¸ÞÅÍ·Î ¹Þ´Â´Ù

 var now = new Date;

 if ((now.getMonth()+1) < 10){
  month = "0"+(now.getMonth()+1);
 }else{
  month = (now.getMonth()+1);
 }
 
 if (now.getDate() < 10){
  date = "0"+now.getDate();
 }else{
  date = now.getDate();
 }

 var today = now.getYear() + "-" + month + "-" + date;//ÇöÀç³¯Â¥
 document.searchFrm.txtdate2.value = today; 
 document.searchFrm.txtdate.value = getThatday(today,t); //ÇöÀç³¯Â¥¿Í ÀÏÂ÷¸¦ ÆÄ¶ó¹ÌÅÍ·Î º¸³»¼ °á°ú¸®ÅÏÇÑ´Ù.
}

function getThatday(today,t){ //³¯Â¥, ÀÏÂ÷¸¦ ÆÄ¶ó¸ÞÅÍ·Î ¹Þ´Â´Ù.
 var pdate=new Array(); 
 var pday=today.split("-"); //³¯Â¥¸¦ ±¸ºÐÀÚ·Î ³ª´©¾î ¹è¿·Î º¯È¯ÇÑ´Ù.
 var ptoday=new Date(pday[0],pday[1]-1,pday[2]); //µ¥ÀÌÆ®°´Ã¼ »ý¼ºÇÑ´Ù.
 var ptimestamp=ptoday.valueOf()+1000*60*60*24*t; //tÀÏÈÄÀÇ Å¸ÀÓ½ºÅÆÇÁ¸¦ ¾ò´Â´Ù. À½¼ö¶ó¸é ÀÌÀü³¯Â¥¸¦ ¾ò´Â´Ù.
 var thatday=new Date(ptimestamp); //tÀÏÈÄÀÇ ³¯Â¥°´Ã¼ »ý¼ºÇÑ´Ù.
 
 pdate[pdate.length]=thatday.getYear(); //³â
 
  if (thatday.getMonth()+1 < 10){
  pdate[pdate.length]="0"+(thatday.getMonth()+1); //¿ù
  }else{
  pdate[pdate.length]=thatday.getMonth()+1; //¿ù
  } 
 
     if (thatday.getDate() < 10){
  pdate[pdate.length]="0"+thatday.getDate(); //ÀÏ
  }else{
  pdate[pdate.length]=thatday.getDate(); //ÀÏ
  }

return pdate.join("-"); //¹è¿À» / ±¸ºÐÀÚ·Î ÇÕÃÄ ½ºÆ®¸µÀ¸·Î º¯È¯ÈÄ ¹ÝÈ¯
}
</SCRIPT> 

<script language='javascript'>
    function txtdatechange(date)
    {
    var fm = document.searchFrm;
    fm.searchFrm.value = date;
    }

    function Msg(t){
        alert(t);
    }
</script>
<!-- ÆäÀÌÂ¡ Ã³¸® ÀÛ¾÷ -->
<?    $cm_nCount    =      20;

    $cm_item_nCount     =      30;


    include("../../manage/category/subpointcommon.php");                        
                $userid = $_COOKIE[USERID]; 

                

function pageListing($cur_page, $total_page, $n, $url, $mode, $SearchMdiv ,$SearchMup,$SearchMper,$searchCode ,$searchid ,$SearchMsw1 , $cm_nCount ,$txtdate, $txtdate2 ) {

        $retValue .= "<table width=600 border=0 cellspacing=0 cellpadding=0 height=40 align=center><tr><td align=center valign=middle>";
        if ($cur_page > 1) {

            $retValue .= "<span style=font-size:9pt;><font face=Verdana><a href='" . $url . ($cur_page-1) ."&mode=".$mode."&SearchMdiv=".$SearchMdiv."&SearchMup=".$SearchMup."&SearchMper=".$SearchMper."&searchCode=".$searchCode."&searchid=".$searchid."&SearchMsw1=".$SearchMsw1."&SortCnt=".$cm_nCount."&txtdate=".$txtdate."&txtdate2=".$txtdate2."'>ÀÌÀü</a></font></span>";
        } else {
            $retValue .= "&nbsp;";
            $retValue .= "&nbsp;";
        }
        $retValue .= "&nbsp;";
        $start_page = ( ( (int)( ($cur_page - 1 ) / 10 ) ) * 10 ) + 1;
        //echo (int)(($cur_page - 1) / 10);
        $end_page = $start_page + 9;
        if ($end_page >= $total_page) $end_page = $total_page;
        if ($start_page > 1) $retValue .= " <span style=font-size:9pt;><font face=Verdana><a href='" . $url . ($start_page-1) . "&mode=".$mode."&SearchMdiv=".$SearchMdiv."&SearchMup=".$SearchMup."&SearchMper=".$SearchMper."&searchCode=".$searchCode."&searchid=".$searchid."&SearchMsw1=".$SearchMsw1."&SortCnt=".$cm_nCount."&txtdate=".$txtdate."&txtdate2=".$txtdate2."'>...</a></font></span> ";
        if ($total_page > 1)
        for ($k=$start_page;$k<=$end_page;$k++)
        if ($cur_page != $k) $retValue .= "&nbsp;<span style=font-size:9pt;><font face=Verdana><a href='$url$k&mode=".$mode."&SearchMdiv=".$SearchMdiv."&SearchMup=".$SearchMup."&SearchMper=".$SearchMper."&searchCode=".$searchCode."&searchid=".$searchid."&SearchMsw1=".$SearchMsw1."&SortCnt=".$cm_nCount."&txtdate=".$txtdate."&txtdate2=".$txtdate2."'>$k</a>&nbsp;</font></span>";
        else $retValue .= "&nbsp;<b>$k</b> ";
        if ($total_page > $end_page) $retValue .= "<span style=font-size:9pt;><font face=Verdana><a href='" . $url . ($end_page+1) . "&mode=".$mode."&SearchMdiv=".$SearchMdiv."&SearchMup=".$SearchMup."&SearchMper=".$SearchMper."&searchCode=".$searchCode."&searchid=".$searchid."&SearchMsw1=".$SearchMsw1."&SortCnt=".$cm_nCount."&txtdate=".$txtdate."&txtdate2=".$txtdate2."'>...</a></font></span> ";
        $retValue .= "&nbsp;&nbsp;";
        if ($cur_page < $total_page) {
            $retValue .= "<span style=font-size:9pt;><font face=Verdana><a href='$url" . ($cur_page+1) ."&mode=".$mode."&SearchMdiv=".$SearchMdiv."&SearchMup=".$SearchMup."&SearchMper=".$SearchMper."&searchCode=".$searchCode."&searchid=".$searchid."&SearchMsw1=".$SearchMsw1."&SortCnt=".$cm_nCount."&txtdate=".$txtdate."&txtdate2=".$txtdate2."'>´ÙÀ½</a></font></span>";

        } else {
            $retValue .= "&nbsp;";
            $retValue .= "&nbsp;";
        }
        $retValue .= "</td></tr></table>";
        return $retValue;
    }
                        $Dgubun =  " SELECT 0, f.idx, f.cust_id, f.rgst_dtm, f.price, f.addpoint, '' AS usepoint, '' AS use_type,  f.delkey, '' AS bigo, '' AS curpoint
                            FROM cash_fill AS f
                            WHERE f.rgst_dtm BETWEEN '$txtdate 00:00:00' AND '$txtdate2 23:59:59' AND cust_id = '$userid' AND delkey = '0' AND addpoint > '0'
                            UNION ALL
                            SELECT 1, f.idx, f.cust_id, f.rgst_dtm, '' AS price, '' AS addpoint, f.usepoint, f.use_type, '' AS delkey, f.bigo, f.curpoint
                            FROM cash_use AS f
                            WHERE f.rgst_dtm BETWEEN '$txtdate 00:00:00' AND '$txtdate2 23:59:59' AND cust_id = '$userid' AND usepoint > '0'";    //±âº» °Ë»öÄõ¸®

    if ( isset($mode ) && $mode == "search"){  //°Ë»öÆû

        if( isset($searchid) && $searchid !== ""){

            if($searchid !== "")  $Code =  " AND cust_id = '$searchid' ";


        }

        

            if( $searchCode == '1')  
                $Dgubun =  " SELECT 0, f.idx, f.cust_id, f.rgst_dtm, f.price, f.addpoint, '' AS usepoint, '' AS use_type,  f.delkey, '' AS bigo, '' AS curpoint
                            FROM cash_fill AS f
                            WHERE f.rgst_dtm BETWEEN '$txtdate 00:00:00' AND '$txtdate2 23:59:59' AND cust_id = '$userid' AND delkey = '0' AND addpoint > '0'
                            UNION ALL
                            SELECT 1, f.idx, f.cust_id, f.rgst_dtm, '' AS price, '' AS addpoint, f.usepoint, f.use_type, '' AS delkey, f.bigo, f.curpoint
                            FROM cash_use AS f
                            WHERE f.rgst_dtm BETWEEN '$txtdate 00:00:00' AND '$txtdate2 23:59:59' AND cust_id = '$userid' AND usepoint > '0'";



            if( $searchCode == '2')  
                $Dgubun =  " SELECT 0, f.idx, f.cust_id, f.rgst_dtm, f.price, f.addpoint, '' AS usepoint, '' AS use_type, '' AS bigo, '' AS curpoint
                            FROM cash_fill AS f
                            WHERE f.rgst_dtm BETWEEN '$txtdate 00:00:00' AND '$txtdate2 23:59:59' AND cust_id = '$userid' AND delkey = '0' AND addpoint > '0' ";

            if( $searchCode == '3')  
                $Dgubun =  "SELECT 1, f.idx, f.cust_id, f.rgst_dtm, '' AS price, '' AS addpoint, f.usepoint, f.use_type, f.bigo, f.curpoint
                            FROM cash_use AS f
                            WHERE f.rgst_dtm BETWEEN '$txtdate 00:00:00' AND '$txtdate2 23:59:59' AND cust_id = '$userid' AND usepoint > '0' ";


    }
?>

<link href="./css/style.css" rel="stylesheet" type="text/css">
<script language='javascript' src='./js/left_menu.js'></script>
<script language='javascript' src='./js/img.js'></script>


<!-- ¹Ùµð ½ÃÀÛ ---------------------------->
<body topmargin="0" marginwidth="0" marginheight="0">


<!-- ·Ñ¿À¹ö ½ºÅ¸ÀÏ -->
                <style>
                    a.rollover img { border-width:0px; display:block; }
                    a.rollover img.rollover { display:none; }
                    a.rollover:hover { position:relative; }
                    a.rollover:hover img { display:none; }
                    a.rollover:hover img.rollover { display:block; }
                </style>
                <iframe name="Joinifm" width=0 height=0></iframe>

<table width="942" border="0" cellspacing="0" cellpadding="0" align="center" >
    
    <tr>
        <td>
        <!-- »ó´Ü Å¾¸Þ´º, ÇÃ·¡½Ã ¸Þ´º --------------  ½ÃÀÛ -->
            <table width="942" border="0" cellspacing="0" cellpadding="0">

              <tr>
                <td width="224"></td>
                 <td style="padding:0 0px 5px 0;" align="right" height="30"><? include('topmenu.php'); ?></td>
              </tr>
              <tr>   
                <td colspan="2" height="70">

                    <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" width="942" height="70" id="FlashID" >
                      <param name="movie" value="../millennium/flash/mainnavi.swf" />
                      <param name="quality" value="high" />
                      <param name="wmode" value="opaque" />
                      <param name="swfversion" value="8.0.35.0" />
                      <!-- This param tag prompts users with Flash Player 6.0 r65 and higher to download the latest version of Flash Player. Delete it if you don¡¯t want users to see the prompt. -->
                      <param name="expressinstall" value="Scripts/expressInstall.swf" />
                      <!-- Next object tag is for non-IE browsers. So hide it from IE using IECC. -->
                      <!--[if !IE]>-->
                      <object type="application/x-shockwave-flash" data="../millennium/flash/mainnavi.swf" width="942" height="70">
                        <!--<![endif]-->
                        <param name="quality" value="high" />
                        <param name="wmode" value="opaque" />
                        <param name="swfversion" value="8.0.35.0" />
                        <param name="expressinstall" value="../millennium/Scripts/expressInstall.swf" />
                        <!-- The browser displays the following alternative content for users with Flash Player 6.0 and older. -->
                        <div>
                          <h4>Content on this page requires a newer version of Adobe Flash Player.</h4>
                          <p><a href="http://www.adobe.com/go/getflashplayer"><img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash player" width="112" height="33" /></a></p>
                        </div>
                        <!--[if !IE]>-->
                      </object>
                      <!--<![endif]-->
                    </object>

            </td>
            </tr>
            </table>
         <!-- »ó´Ü Å¾¸Þ´º, ÇÃ·¡½Ã ¸Þ´º -------------- Á¾·á -->
        </td>
    </tr>

        <!-- »ó´Ü ¿©¹é -->
    <tr>
        <td height="15">
        </td>
    </tr>

    <tr>
        <td>
        <!-- ¸ÞÀÎ ½ÃÀÛ --------------------------------->

            <table width="946" border="0" cellspacing="0" cellpadding="0">
                <tr>
                    <td valign="top" >
            <!-- ÁÂÃø ÇÃ·¡½Ã ¸Þ´º ½ÃÀÛ --------------------------->
                    <table valign="top">
                        <tr>
                            <td width="212" height="193">
                                <object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0" width="212" height="193" id="leftmypage" align="middle">
                                    <param name="allowScriptAccess" value="sameDomain" />
                                    <param name="allowFullScreen" value="false" />
                                    <param name="movie" value="./flash/leftmypage.swf" /><param name="quality" value="high" /><param name="bgcolor" value="#ffffff" />    <embed src="./flash/leftmypage.swf" quality="high" bgcolor="#ffffff" width="212" height="193" name="leftcomapny" align="top" allowScriptAccess="sameDomain" allowFullScreen="false" type="application/x-shockwave-flash" pluginspage="http://www.adobe.com/go/getflashplayer" />
                                    </object>
                            </td>
                        </tr>
                        <tr height="25">
                            <td>
                            </td>
                        </tr>
                        <tr>
                            <td>

                    <!-- ÁÂÃø Á¦Ç° µµ¿ò ¸Þ´º ½ÃÀÛ -->
                        <? include('../millennium/left_banner.php'); ?>
                    <!-- ÁÂÃø Á¦Ç° µµ¿ò ¸Þ´º ³¡ -->
                    </td>
                </tr>
                </td>
            </tr>
            </table>
            <!-- ÁÂÃø ÇÃ·¡½Ã ¸Þ´º ³¡ --------------------------->
                </td>

            <!-- ¸Þ´º Æø ¿©¹é --------------------------->                
                <td width="12">
                </td>

                <td valign="top">


            <!-- »ó´Ü ¿©¹é¿ë Å×ÀÌºí ½ÃÀÛ----------------->
                <table cellspacing="0" cellpadding="0" border="0">
                    <tr>
                    <td height="7"></td>
                    </tr>
                    <tr>
                    <td valign="top">
                <!-- ¸ÞÀÎ ÅÇ ½ÃÀÛ --------------------------->
                            <table background="../millennium/img/titlebar/mypageedit.gif" width="718" height="35" >
                            <tr>
                                <td width="500">
                                </td>
                                <td>

                                    <table align="right">
                                        <tr>
                                            <td>
                                                <a href=intro.php ><img src="../millennium/img/common/home.gif" border="0">
                                            </td>
                                            <td  class="txt01"><font color="999999">
                                                < ¸¶ÀÌÆäÀÌÁö < <font color="494949">Æ÷ÀÎÆ® ³»¿ª
                                            </td>
                                            <td width="10">
                                            </td>
                                        </tr>
                                    </table>


                                </td>
                                <td>
                                </td>
                            </tr>
                        </table>
                <!-- ¸ÞÀÎ ÅÇ ³¡ ------------------------->
                        </tr>
                        </td>
                <!-- ¸ÞÀÎ ÅÇ ³»¿ë »çÀÌ ¿©¹é------------->

    
                    <tr>
                        <td align="center" valign="top">
                <!-- ¸ÞÀÎ ³»¿ë ½ÃÀÛ ------------->

                        <TABLE><TR><TD height="10"></TD></TR></TABLE> <!-- ¶ç¿ì±â -->
                        <? 
                        

                        
    $result      = mysql_query($Dgubun) or die (mysql_error());
    $nTotalCount = mysql_num_rows($result);
    $nPage       = ceil($nTotalCount / $cm_nCount);
    if ($pg == "") $pg = 1;
    $nFrom = ($pg - 1) * $cm_nCount;

    $sql    = $Dgubun . "  order by rgst_dtm DESC, idx DESC limit $nFrom, $cm_nCount ";    

                        ?>
<form name='searchFrm' method=post>
          
            <table width="680" border="0" cellpadding="3" cellspacing="1" bgcolor="d9d9d9" align="center">
                <tr bgcolor="#5076a9"> 
                    <td height="2"  width="940"></td>
                </tr>
                <tr bgcolor="#ffffff"> 
                    <td class="txt03" width="940" height="30" align="left" valign="middle">
                        &nbsp;&nbsp;&nbsp;<img src="../../onlinecs/img/common/search_tab.gif" align="absmiddle">
                        &nbsp;<font color="#00000"><b>°Ë»ö±¸ºÐ:</b>
                                    <select name='searchCode'>
                                        <option value=1 <?            if( $searchCode == 1){
                                        echo "selected"; 
                                    } ;?> >ÀüÃ¼</option>
                                        <option value=2 <?            if( $searchCode == 2){
                                        echo "selected"; 
                                    } ;?>>ÃæÀü</option>
                                        <option value=3 <?            if( $searchCode == 3){
                                        echo "selected"; 
                                    } ;?>>»ç¿ë</option>
                                    </select>&nbsp;&nbsp;
                        <font color="#00000"><b> °Ë»ö±â°£:</b>                    
                        <img src="../../onlinecs/img/common/3month.gif" align="absmiddle" onclick="javascript:setDay(-90)" style="cursor:hand;">
                        <img src="../../onlinecs/img/common/month.gif" align="absmiddle" onclick="javascript:setDay(-30)" style="cursor:hand;">
                        <img src="../../onlinecs/img/common/week.gif" align="absmiddle" onclick="javascript:setDay(-7)" style="cursor:hand;">
                        <img src="../../onlinecs/img/common/today.gif" align="absmiddle" onclick="javascript:setDay(0)" style="cursor:hand;">

    
                    <input type='text' style='height:20px;' readonly name='txtdate' class="log" size=10 value='<?=$txtdate;?>'>
                    <img src="../../onlinecs/img/common/calendar.gif" style="cursor:hand;" align="absmiddle" border="0" onClick="popUpCalendar(this, txtdate, 'yyyy-mm-dd');"> ~
                    <input type='text' style='height:20px;' readonly name='txtdate2' class="log" size=10 value='<?=$txtdate2;?>'>
                    <img src="../../onlinecs/img/common/calendar.gif" style="cursor:hand;" align="absmiddle" border="0" onClick="popUpCalendar(this, txtdate2, 'yyyy-mm-dd');">
                    <a href='javascript:Search();'><img src="../../onlinecs/img/common/search_bt.gif" border="0" align="absmiddle" style="cursor:hand;"></a>
                    </td>
                </tr>
                <tr bgcolor="#ffffff"> 
                    <td height="30" class="txt03">
                    <?
                    //    $Psql = " SELECT curpoint FROM cust_cash where id = '$userid'";
                            $Psql = "SELECT 0,curpoint, '' AS sumaddpoint, '' AS sumusepoint FROM cust_cash 
                            WHERE id = '$userid' 
                            UNION ALL
                            SELECT 1,'' AS curpoint, SUM(addpoint) AS sumaddpoint, '' AS sumusepoint FROM cash_fill
                            WHERE cust_id = '$userid' AND rgst_dtm BETWEEN '$txtdate 00:00:00' AND '$txtdate2 23:59:59'
                            UNION ALL
                            SELECT 2,'' AS curpoint, '' AS sumaddpoint, SUM(usepoint) AS sumusepoint FROM cash_use
                            WHERE cust_id = '$userid' AND rgst_dtm BETWEEN '$txtdate 00:00:00' AND '$txtdate2 23:59:59'";

                        $Presult = mysql_query($Psql) or die (mysql_error());
                        while($Prow  = mysql_fetch_array($Presult)){
                            if($Prow[0] == 0){
                                $Ptotal = $Prow[curpoint];
                            }
                            if($Prow[0] == 1){
                                $Padd = $Prow[sumaddpoint];
                            }
                            if($Prow[0] == 2){
                                $Puse = $Prow[sumusepoint];
                            }
                        }
                    ?>
                        &nbsp;&nbsp;&nbsp;<img src="../../onlinecs/img/common/search_tab.gif" align="absmiddle">&nbsp; <b>º¸À¯P: <font color="#ff3300"><?=number_format($Ptotal);?>
                        <img src="../millennium/img/common/pointicon.gif" valign="absmiddle">
                        &nbsp;&nbsp;<img src="../../onlinecs/img/common/search_tab.gif" align="absmiddle">&nbsp;<font color="#000000"> °Ë»ö±â°£³» [ ÃæÀüP: <font color="#ff3300"><?=number_format($Padd)?><font color="#000000"> ]
                        &nbsp; [ »ç¿ëP: <font color="#ff3300"><?=number_format($Puse)?><font color="#000000"> ]
                    </td>
                </tr>
             <input type=hidden name='mode' value='search'>
        </table>                    
</form>
        <!-- °Ë»ö¹Ú½º -------------------------- Á¾·á -->
<table align=center border=1 cellpadding=0 style='border-collapse: collapse' cellspacing=0  bordercolor='#BDBEBD' width="680" background="../millennium/img/common/pointbg.gif">
    <tr  width="680" height="25">
        <td align=center width="7%"><p><span style=font-size:9pt;><font face=Verdana COLOR="#696969">±¸ºÐ</font></span></p></td>
        <td align=center width="15%"><p><span style=font-size:9pt;><font face=Verdana COLOR="#696969">ÀÏÀÚ</font></span></p></td>
        <td align=center width="8%"><p><span style=font-size:9pt;><font face=Verdana COLOR="#696969">ÃæÀü±Ý¾×</font></span></p></td>
        <td align=center width="7%"><p><span style=font-size:9pt;><font face=Verdana COLOR="#696969">ÃæÀüP</font></span></p></td>
        <td align=center width="7%"><p><span style=font-size:9pt;><font face=Verdana COLOR="#696969">»ç¿ëP</font></span></p></td>
        <td align=center width="7%"><p><span style=font-size:9pt;><font face=Verdana COLOR="#696969">ÀÜ¿©P</font></span></p></td>
        <td align=center width="15%"><p><span style=font-size:9pt;><font face=Verdana COLOR="#696969">»ç¿ëÁ¤º¸</font></span></p></td>
        <td align=center width="15%"><p><span style=font-size:9pt;><font face=Verdana COLOR="#696969">¼ö½ÅÀÚ</font></span></p></td>
        <td align=center width="15%"><p><span style=font-size:9pt;><font face=Verdana COLOR="#696969">ÇÚµåÆù</font></span></p></td>

    </tr>
                    <?
                    //    $Psql = " SELECT curpoint FROM cust_cash where id = '$userid'";
                            $Esql = "
                            SELECT 0,SUM(addpoint) AS sumaddpoint,SUM(price) AS sumaddprice, '' AS sumusepoint FROM cash_fill
                            WHERE cust_id = '$userid' AND rgst_dtm < '$txtdate 00:00:00'
                            UNION ALL
                            SELECT 1,'' AS sumaddpoint, '' AS sumaddprice,SUM(usepoint) AS sumusepoint FROM cash_use
                            WHERE cust_id = '$userid' AND rgst_dtm < '$txtdate 00:00:00'";

                        $Eresult = mysql_query($Esql) or die (mysql_error());
                        while($Erow  = mysql_fetch_array($Eresult)){
                            if($Erow[0] == 0){
                                $Epoint = $Erow[sumaddpoint];
                                $Eprice = $Erow[sumaddprice];
                            }
                            if($Erow[0] == 1){
                                $Eusepoint = $Erow[sumusepoint];
                            }
                        }
                    ?>

    <tr  width="680" height="25">
        <td colspan ="2" align="center"><b><font color="#dd4e00">[ÀÌ¿ù±Ý¾×]</td>
        <td align=center><font color="#dd4e00"><?=number_format($Eprice)?></td>
        <td align=center><font color="#dd4e00"><?=number_format($Epoint)?></td>
        <td align=center><font color="#dd4e00"><?=number_format($sumusepoint)?></td>
        <td colspan="4"></td>
    </tr>
<?

    $result = mysql_query($sql) or die (mysql_error());

    if($num = mysql_num_rows($result)){

        while($row  = mysql_fetch_array($result)) {


        $usecode = $row[use_type];

        $usesql = "select use_type_nam  from cash_price where use_type_cde = '$usecode'";
        $coderesult = mysql_query($usesql) or die (mysql_error());
        $coderow    = mysql_fetch_array($coderesult);

        $usedetail = $coderow[use_type_nam];

        if($row[0] == "1"){
            $bgcolor = "#f8f8f8";
            $type = "[»ç¿ë]";
        } ELSE {
            $bgcolor = "#e2f0f3";
            $type = "<b>[ÃæÀü]";
        }

?>

    <tr height="22" bgcolor="<?=$bgcolor?>">
         <td align="center">
            <?=$type;?>
        </td>
         <td align="center">
            <?=substr($row[rgst_dtm],0,16);?>
        </td>
        <td align="right" style="padding:0 5pt 0 0;">
            <? if($row[price] == ""){ } else { ?>
            <?=number_format($row[price]); } ?>&nbsp;
        </td>  
        <td align="right" style="padding:0 5pt 0 0;">
            <? if($row[addpoint] == ""){ } else { ?>
            <?=number_format($row[addpoint]); } ?>&nbsp;
        </td>
        <td align="right" style="padding:0 5pt 0 0;">
            <? if($row[usepoint] == ""){ } else { ?>
            <?=number_format($row[usepoint]); } ?>&nbsp;
        </td>
        <td align="right" style="padding:0 5pt 0 0;">
            <? if($row[usepoint] == ""){ } else { ?>
            <?=number_format($row[curpoint]); } ?>&nbsp;
        </td>
        <td align="center">
            <?=$usedetail;?>
        </td>
<? if((substr_count($row[bigo],"/")) > 0){
    $bigoexplode = explode("/",$row[bigo]);
?>
                <td>
                <div style="width:100; text-overflow:ellipsis; overflow:hidden;">
                <nobr>
                &nbsp;<?=$bigoexplode[0]?>
                </nobr>
                </div>
                    
                </td>
                <td>
                    &nbsp;<?=str_replace("SMS:","",$bigoexplode[1]);?>
                </td>
<? } else { ?>
                <td colspan="2" >
                    &nbsp;<?=$row[bigo]?>
                </td>

<? } ?>
    </tr>
    <tr>
        <td colspan="9" height="1" bgcolor="#c7c7c7">
        </td>
    </tr>
<?}

    }
    else{

?>
    <tr align="center" bgcolor="#FFFFFF">
        <td height="100" align="cener" colspan="7" width="680"><span style=font-size:9pt;><font face=Verdana>µ¥ÀÌÅ¸°¡ ¾ø½À´Ï´Ù.</font></span></td>
    </tr>
<?
    }
?>

</table>
<table>
<tr>
    <td align=center bgcolor=#ffffff colspan="13" width="680"><? echo pageListing($pg, $nPage, $cm_nCount, "mypagepoint.php?pg=" , $mode, $SearchMdiv ,$SearchMup,$SearchMper,$searchCode ,$searchid ,$SearchMsw1 , $cm_nCount, $txtdate, $txtdate2)?></td>

</tr>
</table>

                <!-- ¸ÞÀÎ ³»¿ë ³¡ ------------->
                        </td>
                    </tr>
                </table>
            <!-- »ó´Ü ¿©¹é¿ë Å×ÀÌºí ³¡----------------->




                </td>
              </tr>
            </table>
            <input type=hidden name=mode value='update'>
        <!-- ¸ÞÀÎ Á¾·á --------------------------------->







        </td>
    </tr>

    <tr>
        <td height="20">
        <!-- ÇÏ´Ü¿©¹é -->
        </td>
    </tr>





    <tr>
        <td><? include('bottom.php'); ?></td>
    </tr>
</table>

</body>