webadmin.php

/home/mjc1/public_html/manage/admin_etax02.php

<? @session_start();?>
<!DOCTYPE html>
<?
   Header("P3P: CP='NOI DSP COR IVAa OUR BUS IND UNI COM NAV INT'"); 

  if($_SESSION[ADMINID] == ""){

?>

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

      include("./category/common.php");
?>


<?

     //º¹È£È
    $strArr  = explode( "---",base64_decode($KeyCode) );

    $Qry      =  " select * from bill_publish WHERE replace(companyNum,'-','') = '$strArr[1]' ";
    $Result   =   mysql_query($Qry);


   $cm_nCount          =      20;
   $cm_item_nCount     =      30;          
   
   function pageListing($cur_page, $total_page, $n, $url, $KeyCode ) {

  $retValue .= "<table border=0 cellspacing=0 cellpadding=0 height=19 align=center><tr>";
  if ($cur_page > 1) {

      $retValue .= "<td width=80 align=left><a href='" . $url . ($cur_page-1) ."&KeyCode=".$KeyCode."'><img src=../html/millennium/img/customer/prev_bt.gif border=0 valign=bottom></a></td>";
  } 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 .= "<td width=80 align=left> <a href='" . $url . ($start_page-1) . "&KeyCode=".$KeyCode."'><img src=../html/millennium/img/customer/prev10_bt.gif border=0 valign=bottom></a></font></span></td> ";
  if ($total_page > 1)
    for ($k=$start_page;$k<=$end_page;$k++)
      if ($cur_page != $k) $retValue .= "<td>&nbsp;<span style=font-size:9pt;><font face=Verdana><a href='$url$k&KeyCode=".$KeyCode."'>$k</a>&nbsp;</font></span></td>";
      else $retValue .= "<td width=0 valign=top><span style=font-size:9pt;><font face=Verdana color=f6822f>&nbsp;[$k]</font></span></td> ";
  if ($total_page > $end_page) $retValue .= "<td width=80 align=right><a href='" . $url . ($end_page+1) . "&KeyCode=".$mode."'><img src=../html/millennium/img/customer/next10_bt.gif border=0 valign=bottom></a></td> ";
  $retValue .= "&nbsp;&nbsp;";
  if ($cur_page < $total_page) {
    $retValue .= "<td width=80 align=right><a href='$url" . ($cur_page+1) ."&KeyCode=".$KeyCode."'><img src=../html/millennium/img/customer/next_bt.gif border=0 valign=bottom></a></td>";

  } else {
    $retValue .= "&nbsp;";
    $retValue .= "&nbsp;";
  }
  $retValue .= "</td></tr></table>";
  return $retValue;
}



    if( mysql_num_rows($Result) > 0){
        $billpublishRow    =   mysql_fetch_array($Result);
    }
    else{
  
?>
<script>
    location.href  =  "./admin_etax.php";
</script>
<?
    }
?>

<head>
    <meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
    <title>°ü¸®ÀÚ ÆäÀÌÁö</title> 
    <link rel='stylesheet' type='text/css' href='./css/reset.css'>
    <link rel='stylesheet' type='text/css' href='./css/base.css'>
</head>


<body>
    <div class="wrap">
        <div class="header">
            <?     include("./include/gnb_menu.php"); ?>
        </div><!-- //header -->
        
        <div class="container">
            <?     include("admin_include_aside.php"); ?>
            <div class="contents">

                <div class="info_menu">
                    <h3>¼¼±Ý°è»ê¼ ¹ßÇà ³»¿ª</h3>


<!-- ¼¼±Ý°è»ê¼ »ó¼¼-->
<script>
function admissionChk1(idx,stat){

    if(!confirm("½ÂÀÎ ÇÏ½Ã°Ú½À´Ï±î?")){
        return
    }
        else
            exCodeFrm.stat.value =  stat ;
            exCodeFrm.submit();

}

function admissionChk2(idx,stat){

    if(!confirm("¹Ý¼Û ÇÏ½Ã°Ú½À´Ï±î?")){
        return
    } 
    else
        exCodeFrm.stat.value =  stat ;
        exCodeFrm.submit();
}

function printChk( num ,code){
    window.open("billPrint.php?num=" +num + "&code=" + code,"","width=700,height=675,scrollbars=yes" );
}
</script>

<?
    if( isset($detail) && $detail == "y" ) {
    
        $queryTax = " SELECT  volume, pageName, serialNum,
        m.companyNum sCompanyNum, m.companyName sCompanyName, m.chiefName sChiefName, m.CompanyAddr sCompanyAddr,
        m.opt_1 sUptae, m.opt_2 sJongmok,
        p.companyNum rCompanyNum, p.companyName rCompanyName, p.chiefName rChiefName, p.CompanyAddr rCompanyAddr,
        p.opt_1 rUptae, p.opt_2 rJongmok,
        year, MONTH, DAY, blankNum, offerPrice, billPrice,
        
        month_1, day_1, item_1, standard_1, cnt_1, unitPrice_1, offerPrice_1, billPrice_1,
        month_2, day_2, item_2, standard_2, cnt_2, unitPrice_2, offerPrice_2, billPrice_2,
        month_3, day_3, item_3, standard_3, cnt_3, unitPrice_3, offerPrice_3, billPrice_3,
        
        totalPrice, cash, checkPrice, bill, onCredit, irecved,
        
        admission, bigo
        FROM bill_mijin m
        INNER JOIN bill_publish p ON m.companyNum = p.from_companynum
        WHERE p.idx = $idx ";
        
        $resultTax = mysql_query($queryTax);
        $rowTax    = mysql_fetch_array($resultTax);
?>





                    <form name="exCodeFrm" method=post target='' action='admin_billProcess.php'>
                        <input type=hidden name='mode' value='detail'>
                        <input type=hidden name='detail' value='y'>
                        <input type=hidden name='idx' value='<?=$idx;?>'>
                        <input type=hidden name='KeyCode' value='<?=$KeyCode;?>'>
                        <input type=hidden name='stat'>
                    </form>
                    <table>
                        <tr>
                            <td>
<?
        if($rowTax[admission] == "1"){
?>
                                <img src="../html/millennium/img/customer/approve_bt.gif"  name='admission_img' onclick="admissionChk1('<?=$idx;?>','2');" style="cursor:pointer;" alt="½ÂÀÎ¹öÆ°">
                                <img src="../html/millennium/img/customer/return_bt.gif" name='admission_img2' onclick="admissionChk2('<?=$idx;?>','3');" style="cursor:pointer;" alt="¹Ý¼Û¹öÆ°">
<?
        } else {
?>
                                <img src="../html/millennium/img/customer/approve_bt_off.gif"  name='admission_img' style="cursor:pointer;" onclick="alert('ÀÌ¹Ì Ã³¸®µÈ ³»¿ªÀº ½ÂÀÎ ºÒ°¡ÇÕ´Ï´Ù.')" alt="½ÂÀÎ¹öÆ°">
                                <img src=../html/millennium/img/customer/return_bt_off.gif style="cursor:pointer;" name='admission_img2' onclick="alert('ÀÌ¹Ì Ã³¸®µÈ ³»¿ªÀº ¹Ý¼Û ºÒ°¡ÇÕ´Ï´Ù.')" alt="¹Ý¼Û¹öÆ°">
<?
        }
?>
                            </td>
                        </tr>

                        <tr>
                            <td>
                                <div style="text-align:center; margin:0 auto;">
                                    <? include("inc.tax.php"); ?>
                                </div>
                            </td>
                        </tr>
                        <tr>
                            <td>
<? if($rowTax[admission] == "2"){ ?>
                             º» ¼¼±Ý°è»ê¼´Â ºÎ°¡°¡Ä¡¼¼¹ý ½ÃÇà·É Á¦ 53Á¶¿¡ ÀÇ°ÅÇÏ¿©, Á¾ÀÌ¼¼±Ý°è»ê¼¸¦ ´ëÃ¼ÇÏ´Â ¼¼±Ý°è»ê¼ÀÔ´Ï´Ù.
                            </td>
                        </tr>
                            <tr>
                                <td>
                                    <img src="../html/millennium/img/customer/taxsend_bt.gif" onClick="printChk('<?=$KeyCode;?>','<?=$idx;?>');" style="cursor:pointer;">
                                </td>                                        
<?
    }
}
?>
                            </table>
                            <!-- ¼¼±Ý°è»ê¼ »ó¼¼ ³¡-->
                            
                            
                               <div class="memberWarp" style="min-width:650px; border-bottom:0 none; ">
                            <table class="memberTable">
                                <tr>
                                    <th>¹ßÇàÀÏÀÚ</th>
                                    <th>¹ßÇàÃ³</th>
                                    <th>»ç¾÷ÀÚ¹øÈ£</th>
                                    <th>´ëÇ¥ÀÚ</th>
                                    <th>±Ý¾×</th>
                                    <th>½ÂÀÎ»óÅÂ</th>
                                    <th class="last">ÀÚ¼¼È÷ º¸±â</th>
                                </tr>
<?
    $tableQry      =  " select p.admission, p.idx, p.year, p.MONTH, p.DAY, p.from_companynum, p.totalprice, p.tax_visible, m.companyName, m.chiefName from bill_publish p inner join bill_mijin m on m.companyNum = p.from_companynum WHERE replace(p.companyNum,'-','') = '$strArr[1]'"; 

    $result      = mysql_query($tableQry) or die (mysql_error());
    $nTotalCount = mysql_num_rows($result);
    $nPage       = ceil($nTotalCount / $cm_nCount);
    if ($pg == "") $pg = 1;
    $nFrom = ($pg - 1) * $cm_nCount;
    
    $sql    = $tableQry . "  order by p.idx desc limit $nFrom, $cm_nCount ";
    
    $result = mysql_query($sql) or die (mysql_error());
    
    if( mysql_num_rows($result) > 0 ){ 
        while ($tableRow =  mysql_fetch_array($result)){ 

        $regdate     =  $tableRow[year]."-" .$tableRow[MONTH]."-". $tableRow[DAY];

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

        if($idx == $tableRow[idx]) $bgcolor = "lightyellow";
            else                                                                    $bgcolor = "#ffffff";
?>
                        <tr bgcolor=<?=$bgcolor?>>
                            <td class="family"><?=$regdate;?> <!-- ¹ßÇàÀÏÀÚ -->
                            <td><?=$tableRow['companyName'];?><!-- ¹ßÇàÃ³ -->
                            <td class="family"><?=$tableRow['from_companynum'];?> <!-- »ç¾÷ÀÚ¹øÈ£ -->
                            <td><?=$tableRow['chiefName'];?>     <!-- ´ëÇ¥ÀÚ -->
                            <td class="family"><?=number_format($tableRow['totalprice']);?> <!-- ±Ý¾× -->
                            <td><?=$statu;?></td> <!-- ½ÂÀÎ»óÅÂ -->
                            <!--                                            <td align=center><?=$tableRow['idx'];?></td>   --> <!-- °íÀ¯¹øÈ£ -->
                            <? if($tableRow['tax_visible'] == "0") { ?>
                            <td class="last"><a href="admin_etax02.php?pg=<?=$pg;?>&KeyCode=<?=$KeyCode;?>&detail=y&idx=<?=$tableRow[idx];?>"><FONT COLOR="#0066FF">³»¿ëº¸±â</FONT></a></td> <!-- ÀÚ¼¼È÷ º¸±â -->
                            <? } else { ?>
                            <td class="last">Ãâ·Â ±â°£ ¸¶°¨</a></td> <!-- ÀÚ¼¼È÷ º¸±â -->
                            <?  } ?>
                        </tr>
                                    
<?
        }
    }
?>
                    </table>
                       </div><!-- //memberWarp -->
                    
                    <?=pageListing($pg, $nPage, $cm_nCount, "admin_etax02.php?pg=" , $KeyCode )?>
                    
                    <iframe name='billifm' width=0 height=0></iframe>
                    <iframe name="Joinifm" width=0 height=0></iframe>

                </div><!-- //info_menu-->

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

            </div><!-- //contents -->
        </div><!-- //container -->

    </div><!-- //wrap -->

</body>
</html>