webadmin.php

/home/mjc1/public_html/manage/easybill.php

<? include("./include/etax_include_header.php"); ?>

<?

if(isset($_SESSION['ADMINID']) && ($_SESSION['ADMINID'] == "lys")){ 
    echo "
        <script>
            alert('Á¢±ÙÇÒ ¼ö ÀÖ´Â ±ÇÇÑÀÌ ¾ø½À´Ï´Ù.');
            history.go(-1);
        </script>";
}

    $cm_nCount    =      30; //È¸é¿¡ »Ñ·ÁÁÖ´Â °¹¼ö
    $cm_item_nCount     =      30;

    function pageListing($cur_page, $total_page, $n, $url, $mode, $SearchMdiv ,$SearchMup,$SearchMper,$searchCode ,$keyword ,$SearchMsw1 , $cm_nCount, $menu, $sub  ) {

        $retValue = "<div class='paging'>";
        if ($cur_page > 1) {

            $retValue .= "<a href='" . $url . ($cur_page-1) ."' class='page'><span class='next'>ÀÌÀü</span></a>";
        } else {
            $retValue .= "";
            $retValue .= "";
        }

        $retValue .= "";

        $start_page = ( ( (int)( ($cur_page - 1 ) / 10 ) ) * 10 ) + 1;

        $end_page = $start_page + 9;
        if ($end_page >= $total_page) $end_page = $total_page;
            if ($start_page > 1) $retValue .= "<a href='" . $url . ($start_page-1) . "' class='page'><span class='next10'>ÀÌÀü 10°³</span></a>";

                if ($total_page > 1)
                    for ($k=$start_page;$k<=$end_page;$k++)
                if ($cur_page != $k) $retValue .= "<a href='$url$k'>$k</a>";
                    else $retValue .= "<a href='$url$k' class='on'>$k</a>";

        if ($total_page > $end_page) $retValue .= "<a href='" . $url . ($end_page+1) . "' class='page'><span class='pro10'>´ÙÀ½ 10°³</span></a>";

        $retValue .= "";

        if ($cur_page < $total_page) {
            $retValue .= "<a href='$url" . ($cur_page+1) ."' class='page'><span class='pro'>´ÙÀ½</span></a>";

        } else {
            $retValue .= "";
            $retValue .= "";
        }

    $retValue .= "</div>";
    return $retValue;
}
    
    include_once $_SERVER['DOCUMENT_ROOT']."/inc/js_include.php"; //´Þ·Â

        if( $searchCode == '0'){
            $cd = "a.DMDER_BUSNID_ID";
            $Code =  "";
        }
        if( $searchCode == '1'){    //°ø±Þ¹Þ´ÂÀÚ
            $Code = "AND  t1.BUSNID = '$keyword' "; 
            $cd = "a.DMDER_BUSNID_ID";
        }
        if( $searchCode == '2'){  
            $Code =  " and encode(b2.TRADE_NM,'12345678') like '%$keyword%' ";
            $cd = "a.DMDER_BUSNID_ID";
        }
        if( $searchCode == '3'){
            $Code =  " and encode(b2.MAIN_TX_OFFCR_NM,'12345678') like '%$keyword%' ";
            $cd = "a.DMDER_BUSNID_ID";
        }
        if( $searchCode == '4'){    //°ø±ÞÀÚ
            $Code =  "AND  t1.BUSNID = '$keyword' "; 
            $cd = "a.SUPLER_BUSNID_ID";
        }
        if( $searchCode == '5'){
            $Code =  " and b2.TRADE_NM like '%$keyword%' ";
            $cd = "a.SUPLER_BUSNID_ID";
        }
        if( $searchCode == '6'){
            $Code =  " and b2.MAIN_TX_OFFCR_NM like '%$keyword%' ";
            $cd = "a.SUPLER_BUSNID_ID";
        }

        $strWhere="";
        $newdate1 = date("Ymd", strtotime("-1 Week"))."000000";
        $newdate2 = date("Ymd")."235959";
        $newkeydate1 = $keydate1."000000";
        $newkeydate2 = $keydate2."235959";
        
        if($keydate1 <> ""){
            $strWhere="   a.ISU_DATE BETWEEN '$newkeydate1' AND '$newkeydate2'  ";
        } else {
            $keydate1 = ($keydate1 == "") ? date("Ymd", strtotime("-1 Week")) : $keydate1; 
            $keydate2 = ($keydate2 == "") ? date("Ymd", time()) : $keydate2;  
                $strWhere="   a.ISU_DATE BETWEEN '$newkeydate1' AND '$newkeydate2'  ";
        }

    if($selapp == '0'){
      $strWhere=$strWhere.
                "   AND a.EMAIL_CHECK = 0 ";
    } elseif($selapp == '1'){
      $strWhere=$strWhere.
                "   AND a.EMAIL_CHECK = 1 ";
    } elseif($selapp == '2'){
      $strWhere=$strWhere.
                "   AND a.EMAIL_CHECK = 2 ";
    } elseif($selapp == '3'){
      $strWhere=$strWhere.
                "   AND a.EMAIL_CHECK = 3 ";
    } elseif($selapp == '4'){
      $strWhere=$strWhere.
                "   AND a.EMAIL_CHECK = 4 ";
    } elseif($selapp == '5'){
      $strWhere=$strWhere.
                "   AND a.EMAIL_CHECK = 5 ";
    } elseif($selapp == '6'){
      $strWhere=$strWhere.
                "";
    }

    if($prog == "0"){
        $wprog = "";
    } else if($prog == "1"){
        $wprog = "AND a.FRST_RGSTER_ID != 'ETAX' ";
    } else if($prog == "2"){
        $wprog = "AND a.FRST_RGSTER_ID = 'ETAX' ";;
    }
    // °øÅë Äõ¸®
    if($mode == "search"){
    $total_sql = "SELECT a.ETAXBIL_APPV_NO, a.WRITE_DT, a.ISU_DATE, a.SND_DT, DECODE(b.BUSNID,'12345678') AS BUSNID
                , DECODE(b.TRADE_NM,'12345678') AS TRADE_NM, DECODE(b.CHIEF_NM,'12345678') AS CHIEF_NM, DECODE(a.TOT_AMT,'12345678') AS TOT_AMT
                , a.SND_STATUS_CD, a.EMAIL_SND_YN, a.EMAIL_CHECK, a.ETAXBIL_CL_CD
                , b.MAIN_TX_OFFCR_EMAIL_ADDR, b.BUSN_KND_CD, s.RESULT_CD

                FROM tn_eaaa AS a 
                INNER JOIN tn_aaaa AS t1 ON $cd = t1.BUSNID_ID
                INNER JOIN tn_eaab AS b ON a.ETAXBIL_APPV_NO = b.ETAXBIL_APPV_NO
                LEFT JOIN tn_baab as s ON a.ETAXBIL_APPV_NO = s.ETAXBIL_APPV_NO AND a.SUBMIT_ID = s.SUBMIT_ID
                
                
                WHERE  $strWhere $Code 
                $wprog

                ";
        
    } else {
      $total_sql = " SELECT a.ETAXBIL_APPV_NO, a.WRITE_DT, a.ISU_DATE, a.SND_DT, decode(b.BUSNID,'12345678') AS BUSNID
                , decode(b.TRADE_NM,'12345678') AS TRADE_NM, DECODE(b.CHIEF_NM,'12345678') AS CHIEF_NM, decode(a.TOT_AMT,'12345678') AS TOT_AMT
                , a.SND_STATUS_CD, a.EMAIL_SND_YN, a.EMAIL_CHECK, a.ETAXBIL_CL_CD, s.RESULT_CD
                , b.MAIN_TX_OFFCR_EMAIL_ADDR, b.BUSN_KND_CD

                FROM tn_eaaa AS a LEFT JOIN tn_eaab AS b ON a.ETAXBIL_APPV_NO = b.ETAXBIL_APPV_NO
                LEFT JOIN tn_baab as s ON a.ETAXBIL_APPV_NO = s.ETAXBIL_APPV_NO AND a.SUBMIT_ID = s.SUBMIT_ID
                WHERE a.ISU_DATE BETWEEN '$newdate1' AND '$newdate2'
                ";           
    }
                
    $result      = mysql_query($total_sql) or die (mysql_error());
    
    
    
    $nTotalCount = mysql_num_rows($result);
    $nPage       = ceil($nTotalCount / $cm_nCount);
    if ($pg == "") $pg = 1;
    $nFrom = ($pg - 1) * $cm_nCount;

    //$sql    = $total_sql . "  order by p.year DESC , p.MONTH DESC , p.DAY DESC limit $nFrom, $cm_nCount ";    //°è»ê¼ ³¯Â¥º°·Î Á¤·Ä
    $sql    = $total_sql . "  order by a.ETAXBIL_APPV_NO DESC limit $nFrom, $cm_nCount ";    //µî·Ï¼ø¼·Î Á¤·É
    //echo $sql;

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

?>

<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) {  //reloads the window if Nav4 resized
    if (init==true) with (navigator) {
        if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
            document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage;
        }
    }
    else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->

//Àç¹ß¼ÛÀÇ ÆíÀÇ¸¦ À§ÇØ¼ ¹ß¼ÛµÈ°ÇÀ» ¹Ì¹ß¼ÛÀ¸·Î º¯°æÇÏ´Â ±â´É
function ChangSend(idx,val){

    if(confirm("¹ß¼Û¿©ºÎ¸¦ º¯°æÇÏ½Ã°Ú½À´Ï±î?")){

       document.location.href = "billProcess.php?exCode=ChangSend&idx=" + idx + "&val=" + val +"&pg=<?=$pg;?>&mode=search&searchCode=<?=$searchCode;?>&SearchMsw1=<?=$SearchMsw1;?>&keyword=<?=$keyword;?>&prog=<?=$prog;?>";

    }
}

function CheckAll() {

    if( document.billFrm.all.value == 1){
        document.chkImg.src = "bt_allcheck_not.gif";

        for (var i=0;i<document.billFrm.elements.length;i++){
            if (document.billFrm.elements[i].name == 'billForm[]'){
                document.billFrm.elements[i].checked = true;
            }
        }
        
        document.billFrm.all.value = '0';
        
    } else {
        document.chkImg.src = "bt_allcheck.gif";

        for (var i=0;i<document.billFrm.elements.length;i++){
            if (document.billFrm.elements[i].name == 'billForm[]'){

                document.billFrm.elements[i].checked = false;
            }
        }

        document.billFrm.all.value = '1';
    }
}


function allDel(){
    var cnt=0;
    for (var i=0;i<document.billFrm.elements.length;i++){
        if (document.billFrm.elements[i].name == 'billForm[]'){

            if( document.billFrm.elements[i].checked == true ) cnt++;
        }
    }

    if(cnt>0){

        if(confirm("¼±ÅÃÇÏ½Å "+ cnt +" °³ÀÇ °Ô½Ã¹°À» »èÁ¦ÇÏ½Ã°Ú½À´Ï±î?") ){
            document.billFrm.action = "billProcess.php" ;
            document.billFrm.submit();
        }
    } else {
        alert("»èÁ¦ÇÒ Ç×¸ñÀ» ¼±ÅÃÇÏ¼¼¿ä.")
        return;
    }
}

<!-- "¹ßÇàÇã¿ë" ½ºÅ©¸³Æ® -->
function allpos(){
  
    var cnt=0;
    for (var i=0;i<document.billFrm.elements.length;i++){
        if (document.billFrm.elements[i].name == 'billForm[]'){

            if( document.billFrm.elements[i].checked == true ) cnt++;
        }
    }

    if(cnt>0){

        if(confirm("¼±ÅÃÇÏ½Å "+ cnt +" °³ÀÇ °Ô½Ã¹°À» '¹ßÇàÇã¿ë' ÇÏ½Ã°Ú½À´Ï±î?") ){
            document.billFrm.action = "bill_allpos.php" ;
            document.billFrm.submit();
        }
    } else {
        alert("¹ßÇàÇã¿ë ÇÒ °è»ê¼¸¦ ¼±ÅÃÇÏ¼¼¿ä.")
        return;
    }
}

<!-- "¹ßÇàÁßÁö" ½ºÅ©¸³Æ® -->
function allimpos(){

    var cnt=0;
    for (var i=0;i<document.billFrm.elements.length;i++){
        if (document.billFrm.elements[i].name == 'billForm[]'){
            if( document.billFrm.elements[i].checked == true ) cnt++;
        }
    }

    if(cnt>0){

        if(confirm("¼±ÅÃÇÏ½Å "+ cnt +" °³ÀÇ °Ô½Ã¹°À» '¹ßÇàÁßÁö' ÇÏ½Ã°Ú½À´Ï±î?") ){
            document.billFrm.action = "bill_allimpos.php" ;
            document.billFrm.submit();
        }
    } else {
        alert("¹ßÇàÁßÁö ÇÒ °è»ê¼¸¦ ¼±ÅÃÇÏ¼¼¿ä.")
        return;
    }
}


function popBillUseList(companyNum){
    window.open("popbilluselist.php?from_companynum="+companyNum,"popBillUseList","width=200px,height=400px,scrollbars=yes");
}

function popTaxIssueCount(){
    window.open("popTaxIssueCount.php","popTaxIssueCount","width=400px,height=600px,scrollbars=yes");
}

function billBasic(){
    window.open("billBasic.php","","width=600,height=200,scrollbars=yes");
}

</script>
<link rel='stylesheet' type='text/css' href='./css/new.css'>

        <div class="container">
            <div class="border_contents">

                <div class="admin_table">
                    <h3 class="list_ttl">
                        ÀÌÁöºô°è»ê¼
                        <span class="list_sub_ttl bgpi">¹ßÇàµÈ ¼¼±Ý°è»ê¼ ³»¿ªÀ» º¸¿©ÁÖ´Â ÆäÀÌÁöÀÔ´Ï´Ù.</span>
                    </h3>
                    

                    <FORM METHOD=POST ACTION='?' name='SearchFrm' onSubmit="">
                    <input type="hidden" name="menu" value="<?=$menu?>">
                    <input type="hidden" name="sub" value="<?=$sub?>">
                        <div class="searchArea searchAreaPlus">
                            <span class="searchAreaL"></span>
                            <span class="searchAreaR"></span>
                            <dl class="search_tender requestSearchArea" style="width:930px !important;">
                                <dt class="screen_out">ÀÌÁöºô °è»ê¼ Á¶È¸</dt>
                                <dd class="first relative">
                                    <p class="arrow"></p>
                                    <select name="prog" size="1" class="nonearrow"> 
                                        <option value=0 <? if($prog == '0'){ echo "selected"; } ?>>ÀüÃ¼ ÀÛ¼ºÇÁ·Î±×·¥</option> 
                                        <option value=1 <? if($prog == '1'){ echo "selected"; } ?>>ÀÌÁö°è»ê¼</option> 
                                        <option value=2 <? if($prog == '2'){ echo "selected"; } ?>>ÀÌÁöºôÀ¥</option> 
                                    </select>
                                </dd>
                                <dd>
<? 
    if ($keydate1 == "") { 
        $keydate1 = ($keydate1 == "") ? date("Ymd", strtotime("-1 Week")) : $keydate1; 
    }
    if ($keydate2 == "") { 
        $keydate2 = ($keydate2 == "") ? date("Ymd", time()) : $keydate2; 
    }
?>
                                    <em class="title mr10 bgpi">¹ßÇà±â°£</em>
<input type="text" name="keydate1" id="keydate1" size="10" value='<?=$keydate1;?>' maxlength="10" style="width:70px;height:29px;"><span> ~ </span><input type="text" name="keydate2" id="keydate2" size="10" value='<?=$keydate2;?>' maxlength="10" style="width:70px;height:29px;"><!--/inc/js_include.php-->
                                </dd>
                                <dd class="relative">
                                    <p class="arrow"></p>
                                    <select name="selapp" size="1" class="nonearrow" style="width:118px;"> 
                                        <option value=6 <? if($selapp == '6'){ echo "selected"; } ?>>ÀüÃ¼ ½ÂÀÎ»óÅÂ</option> 
                                        <option value=0 <? if($selapp == '0'){ echo "selected"; } ?>>´ë±â</option> 
                                        <option value=1 <? if($selapp == '1'){ echo "selected"; } ?>>¼ö½Å</option> 
                                        <option value=2 <? if($selapp == '2'){ echo "selected"; } ?>>¿¶÷</option> 
                                        <option value=3 <? if($selapp == '3'){ echo "selected"; } ?>>½ÂÀÎ</option> 
                                        <option value=4 <? if($selapp == '4'){ echo "selected"; } ?>>¹Ý¼Û</option> 
                                        <option value=5 <? if($selapp == '5'){ echo "selected"; } ?>>¹Ý¼ÛÈ®ÀÎ</option> 
                                    </select>
                
<script>
    $(function(){
        $( "#keydate1" ).datepicker({
            showOn: "button",
            buttonImage: "./images/common/calendar.png",
            buttonImageOnly: true,
            buttonText: "Select date",
            dateFormat: "yymmdd",
            changeMonth: true,
            changeYear: true,
            monthNames: ['1¿ù','2¿ù','3¿ù','4¿ù','5¿ù','6¿ù','7¿ù','8¿ù','9¿ù','10¿ù','11¿ù','12¿ù'],
            monthNamesShort: ['1¿ù','2¿ù','3¿ù','4¿ù','5¿ù','6¿ù','7¿ù','8¿ù','9¿ù','10¿ù','11¿ù','12¿ù'],
            dayNames: ['ÀÏ','¿ù','È','¼ö','¸ñ','±Ý','Åä'],
            dayNamesShort: ['ÀÏ','¿ù','È','¼ö','¸ñ','±Ý','Åä'],
            dayNamesMin: ['ÀÏ','¿ù','È','¼ö','¸ñ','±Ý','Åä'],
            showMonthAfterYear: true,
            yearSuffix: '³â'
        });

        $( "#keydate2" ).datepicker({
            showOn: "button",
            buttonImage: "./images/common/calendar.png",
            buttonImageOnly: true,
            buttonText: "Select date",
            dateFormat: "yymmdd",
            changeMonth: true,
            changeYear: true,
            monthNames: ['1¿ù','2¿ù','3¿ù','4¿ù','5¿ù','6¿ù','7¿ù','8¿ù','9¿ù','10¿ù','11¿ù','12¿ù'],
            monthNamesShort: ['1¿ù','2¿ù','3¿ù','4¿ù','5¿ù','6¿ù','7¿ù','8¿ù','9¿ù','10¿ù','11¿ù','12¿ù'],
            dayNames: ['ÀÏ','¿ù','È','¼ö','¸ñ','±Ý','Åä'],
            dayNamesShort: ['ÀÏ','¿ù','È','¼ö','¸ñ','±Ý','Åä'],
            dayNamesMin: ['ÀÏ','¿ù','È','¼ö','¸ñ','±Ý','Åä'],
            showMonthAfterYear: true,
            yearSuffix: '³â'
        });
    });
</script>
                                </dd>
                                <dd class="relative">
                                    <p class="arrow"></p>
                                    <select name='searchCode' class="nonearrow">
                                        <option value=0  <?    if($searchCode == '0'){ echo "selected"; } ?>>ÀüÃ¼ Á¶°Ç</option>
                                        <option value=4  <?    if($searchCode == '4'){ echo "selected"; } ?>>°ø±ÞÀÚ »ç¾÷ÀÚ¹øÈ£</option> 
                                        <option value=1  <?    if($searchCode == '1'){ echo "selected"; } ?>>°ø±Þ¹Þ´ÂÀÚ »ç¾÷ÀÚ¹øÈ£</option>
                                    </select>
                                </dd>
                                <dd><input type='text' name='keyword' size=20 value='<?=$keyword;?>' style="height:29px;" placeholder="»ç¾÷ÀÚ¹øÈ£¸¦ ÀÔ·ÂÇÏ¼¼¿ä."></dd>
                                <dd>
                                    <!--a href='javascript:Search();' class="searchBtn">°Ë»ö</a-->
                                    <input type="image" src="./images/common/btn_save.png" style="position:relative;top:5px;">
                                    <input type="hidden" name='mode' value='search'>
                                </dd>
                            </dl><!--search_tender-->
                        </div><!-- //searchArea1-->
                    </form>
                    <!-- //°Ë»ö¹Ú½º -->


                    <FORM name='billFrm'>
                    <input type="hidden" name="all" value=1>
                    <input type="hidden" name="exCode" value="alldel">
                    <input type="hidden" name="keydate1" value=<?=$keydate1;?>>
                    <input type="hidden" name="keydate2" value=<?=$keydate2;?>>
                    <input type="hidden" name="selapp" value=<?=$selapp;?>>
                    <input type="hidden" name="prog" value=<?=$prog;?>>
                    <input type="hidden" name="searchCode" value=<?=$searchCode;?>>
                    <input type="hidden" name="keyword" value=<?=$keyword;?>>
                    <input type="hidden" name="pg" value=<?=$pg;?>>
                    <input type="hidden" name="menu" value="<?=$menu?>">
                    <input type="hidden" name="sub" value="<?=$sub?>">
                        <div class="taxWarp">
                        <table class="taxTable requestarea">
                            <tr class="bgpi">
                                <th class="first">No</th>
                                <th>ÀÛ¼ºÀÏÀÚ</th>
                                <th>¹ßÇàÀÏÀÚ</th>
                                <th>Àü¼ÛÀÏÀÚ</th>
                                <th>»ç¾÷ÀÚ¹øÈ£</th>
                                <th>È¸»ç¸í</th>
                                <th>´ëÇ¥ÀÚ¸í</th>
                                <th>±Ý¾×</th>
                                <th>±¹¼¼Ã»</th>
                                <th>¸ÞÀÏ</th>
                                <th>¼ö½Å</th>
                                <th class="last">¸ÞÀÏÁÖ¼Ò</th>
                            </tr>

<?
    $i=1;
    if($num = mysql_num_rows($result)){

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

            if($row['admission'] == "1" )                $statu =  "ºñ½ÂÀÎ";
            else if ($row['admission'] == "3" ) $statu =  "<FONT COLOR='#FF0000'>¹Ý¼Û</FONT>";
            else                                                            $statu =  "<FONT COLOR='#0066FF'>½ÂÀÎ</FONT>";

            if($row['ismailsend'] == 1 )                $sSend =  "<FONT COLOR='#0033CC'>¹ß¼Û</FONT>";
            else                                                            $sSend =  "<FONT COLOR='#FF3333'>¹Ì¹ß¼Û</FONT>";
            

?>

<?
    if($row['SND_STATUS_CD'] == "E"){
    $sndstate = "[Àü¼Û]";
    }    if($row['SND_STATUS_CD'] == "I"){
    $sndstate = "[¹ÌÀü¼Û]";
    }    if($row['SND_STATUS_CD'] == "D"){
    $sndstate = "[Àü¼ÛÃë¼Ò]";
    }


        if($row['EMAIL_CHECK'] == "0"){
    $mailcheck = "[´ë±â]";
    }    if($row['EMAIL_CHECK'] == "1"){
    $mailcheck = "[¼ö½Å]";
    }    if($row['EMAIL_CHECK'] == "2"){
    $mailcheck = "[¿¶÷]";
    }    if($row['EMAIL_CHECK'] == "3"){
    $mailcheck = "[½ÂÀÎ]";
    } if($row['EMAIL_CHECK'] == "4"){
    $mailcheck = "[¹Ý¼Û]";
    } if($row['EMAIL_CHECK']== "5"){
    $mailcheck = "[¹Ý¼ÛÈ®ÀÎ]";
     }     
?>
                            <tr>
    <? if($row['BUSN_KND_CD'] =="01"){ ?>
                                <td rowspan="2" class="first"><? if($row['BUSN_KND_CD'] =="01"){ echo $i; } ?></td>
                                <td><?=$row['WRITE_DT']?></td><!--class="family"-->
                                <td><?=substr($row['ISU_DATE'],0,8)?></td><!--class="family"-->
                                <td><?=$row['SND_DT']?></td><!--class="family"-->
    <? } ?>
    <? if($row['BUSN_KND_CD'] =="02"){ ?>
                                <td colspan="3"><b>½ÂÀÎ¹øÈ£ : </b><?=$row['ETAXBIL_APPV_NO']; ?></td><!--span class="family"-->
    <? } ?>

                                <td><?=$row['BUSNID']?></td><!--class="family"-->

                                <td><?=$row['TRADE_NM'];?></a></td>
                                <td><?=$row['CHIEF_NM'];?></td>
    <? if($row['BUSN_KND_CD'] =="01"){ ?>
                                <td rowspan="2" class="cost"><?=number_format($row['TOT_AMT']);?></td><!--class="family"-->
                                <td><?=$sndstate;?></td>
                                <td><?=$row['EMAIL_SND_YN'];?></td>
                                <td><?=$mailcheck;?></A></td>
                                <td class="mail"><?=$row['MAIN_TX_OFFCR_EMAIL_ADDR'];?></td><!--class="family"-->
    <? } ?>
    
    <? if($row['BUSN_KND_CD'] =="02"){ ?>
    <? if($row['RESULT_CD'] == "SUC001"){ 
            $RESULT_CD = "[Àü¼Û¼º°ø]"; 
        } else if($row['RESULT_CD'] == ""){
            $RESULT_CD = ""; 
        } else {
            $RESULT_CD = "<span class='red'>[Àü¼Û¿¡·¯:".$row['RESULT_CD']."]</span>"; 
        }
    ?>
                                <td colspan="3"><?=$RESULT_CD?> <? if($row['ETAXBIL_CL_CD'] == "03") echo "<span class='blue'>[¸é¼¼]</span>"; ?></td>
                                <td class="mail"><?=$row['MAIN_TX_OFFCR_EMAIL_ADDR'];?></td><!--class="family"-->
    <? } ?>        
                            </tr>

<?    if($row['BUSN_KND_CD'] == "02"){

    $i++;
    ?>
    
    <tr><td colspan="12" class="LineB"></td></tr>
    
<? } ?>

<?    
        }
    }
    else{

?>
                            <tr>
                                <td class="LineB last" colspan="12">µ¥ÀÌÅÍ°¡ ¾ø½À´Ï´Ù.</td>
                            </tr>
<?
    }
?>

                        </table><!-- //memberTable -->
                        </div><!-- //memberWarp -->
                    </form>
                    
                    <? echo pageListing($pg, $nPage, $cm_nCount, "?menu=7&sub=1&prog=$prog&keydate1=$keydate1&keydate2=$keydate2&selapp=$selapp&searchCode=$searchCode&keyword=$keyword&mode=$mode&x=$x&y=$y&pg=" , $mode, $selapp, $keydate1, $keydate2, $searchCode ,$keyword, $prog, $menu, $sub )?>
                    <?//print_r($_REQUEST)?>

                </div><!-- //admin_table -->

                <p class="navi">°ü¸®ÀÚ¸ðµå > °è»ê¼°ü¸® > ÀÌÁöºô°è»ê¼</p>

                <div class="footer">
                    <?    include("./include/admin_include_footer.php"); ?>
                </div><!-- //footer -->


            </div><!-- //border_contents -->
        </div><!-- //container -->
    </div><!-- //wrap -->



</body>
</html>