webadmin.php

/home/mjc1/public_html/manage/bill.php

<?
    include("./include/ebill_include_header.php");

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

    if( $searchCode == '1') {
        $vv = preg_replace("/[^0-9]/", "", $keyword);
        $vx = substr($vv,0,3)."-".substr($vv,3,2)."-".substr($vv,5,6);
        $Code =  " and (p.companyNum like '%$vv%' or p.companyNum like '%$vx%')";
    }
    if( $searchCode == '2')  $Code =  " and p.companyName like '%$keyword%' ";
    if( $searchCode == '3')  $Code =  " and p.chiefName like '%$keyword%' ";
    if( $searchCode == '4'){
        $vv = preg_replace("/[^0-9]/", "", $keyword);
        $vx = substr($vv,0,3)."-".substr($vv,3,2)."-".substr($vv,5,6);
        $Code =  " and (m.companyNum like '%$vv%' or m.companyNum like '%$vx%')";
    }
    if( $searchCode == '5')  $Code =  " and m.companyName like '%$keyword%' ";
    if( $searchCode == '6')  $Code =  " and m.chiefName like '%$keyword%' ";

}
    
    $strWhere="";
    
    if($keydate1 <> ""){
        $strWhere="   AND concat(p.year, '-', p.MONTH, '-', p.DAY) BETWEEN '$keydate1' AND '$keydate2'  ";
    } else {
        $keydate1 = ($keydate1 == "") ? date("Y-m-d", strtotime("-1 Month")) : $keydate1; 
        $keydate2 = ($keydate2 == "") ? date("Y-m-d", time()) : $keydate2;    
        $strWhere="   AND concat(p.year, '-', p.MONTH, '-', p.DAY) BETWEEN '$keydate1' AND '$keydate2'  ";
    }
    
    if($selapp == '1'){
        $strWhere=$strWhere.
        "   AND (admission = 1 OR admission = 2 OR admission = 3)";
    } elseif($selapp == '2'){
        $strWhere=$strWhere.
        "   AND admission = 2 ";
    } elseif($selapp == '3'){
        $strWhere=$strWhere.
        "   AND admission = 1 ";
    } elseif($selapp == '4'){
        $strWhere=$strWhere.
        "   AND admission = 3 ";
    }
        
    // °øÅë Äõ¸®
      $total_sql = " SELECT p.admission, p.idx, p.year, p.MONTH, p.DAY, p.from_companynum, p.companyNum, p.companyName ".
                                 ", p.totalprice, p.chiefName, p.tax_visible, p.ismailsend, p.receive_mail ".
                   ",  m.companyName AS companyName2, m.chiefName AS chiefName2, m.send_mail AS send_mail ".
                         " FROM bill_mijin m inner join bill_publish p on m.companyNum = p.from_companynum".
                         " WHERE 1=1 $Code  ".
                         $strWhere;

    // ÇÕ°è±Ý¾× °è»êÇÏ±âÀ§ÇÑ Äõ¸®
       $sum_sql = " select SUM(p.totalprice) AS totalm ".
                             "   from bill_mijin m inner join bill_publish p on m.companyNum = p.from_companynum".
                             "   WHERE 1=1 $Code  ".
                             $strWhere;
                
    $result      = mysql_query($total_sql) or die (mysql_error());
    
  $result_sum      = mysql_query($sum_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 p.idx DESC limit $nFrom, $cm_nCount ";    //µî·Ï¼ø¼·Î Á¤·É
    //echo $sql;

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

?>

<script src="calender.js" language="javascript"></script> <!-- ¹Ì´Ï´Þ·Â ½ºÅ©¸¯Æ® -->

<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;?>";

    }
}

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=580,height=210,scrollbars=no");
}

function Search(){
    SearchFrm.submit();
}

</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">
                e¸ÞÀÏ°è»ê¼
                <span class="list_sub_ttl bgpi">¹ßÇàµÈ ¼¼±Ý°è»ê¼ ³»¿ªÀ» º¸¿©ÁÖ´Â ÆäÀÌÁöÀÔ´Ï´Ù.</span>
                <span id="idcheck"></span>
            </h3>

            <FORM METHOD=POST ACTION='bill.php' name='SearchFrm' onSubmit="if(!Search()) return false;">
                <div class="searchArea searchAreaPlus" style="height: 64px !important;">
                    <span class="searchAreaL"></span>
                    <span class="searchAreaR"></span>
                    
                    <dl class="search_tender requestSearchArea" style="width: 914px;">
                        <dt class="screen_out">e¸ÞÀÏ°è»ê¼ °Ë»ö</dt>
                        <dd class="first relative">
                            <p class="arrow"></p>
                            <select name="selapp" size="1" class="nonearrow"> 
                                <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> 
                            </select>
                        </dd>
                        <dd>
                            <em class="title bgpi">±â°£</em>
<? 
if ($keydate1 == "") { 
    $keydate1 = ($keydate1 == "") ? date("Y-m-d", strtotime("-1 Month")) : $keydate1; 
}

if ($keydate2 == "") { 
    $keydate2 = ($keydate2 == "") ? date("Y-m-d", time()) : $keydate2; 
}
?>    
                            <input type="text" name="keydate1" style="height:29px;" size="10" value='<?=$keydate1;?>' maxlength="10" onClick="check_mouse('SearchFrm.'+this.name)"><span> ~ </span><input type="text" name="keydate2" style="height:29px;" size="10" value='<?=$keydate2;?>' maxlength="10" onClick="check_mouse('SearchFrm.'+this.name)" >
                        </dd>
                        <dd class="relative">
                            <em class="title bgpi">Á¶°Ç</em>   
                            <p class="arrow"></p>
                            <select name='searchCode' style="width:150px;" class="nonearrow">
                                <option value=5  <?    if($searchCode == '5'){ echo "selected"; } ?>>°ø±ÞÀÚ È¸»ç¸í</option>
                                <option value=6  <?    if($searchCode == '6'){ echo "selected"; } ?>>°ø±ÞÀÚ ´ëÇ¥ÀÚ¸í</option>
                                <option value=4  <?    if($searchCode == '4'){ echo "selected"; } ?>>°ø±ÞÀÚ »ç¾÷ÀÚµî·Ï¹øÈ£</option>
                                <option value=2  <?    if($searchCode == '2'){ echo "selected"; } ?>>°ø±Þ¹Þ´ÂÀÚ È¸»ç¸í</option>
                                <option value=3  <?    if($searchCode == '3'){ echo "selected"; } ?>>°ø±Þ¹Þ´ÂÀÚ ´ëÇ¥ÀÚ¸í</option>
                                <option value=1  <?    if($searchCode == '1'){ echo "selected"; } ?>>°ø±Þ¹Þ´ÂÀÚ »ç¾÷ÀÚµî·Ï¹øÈ£</option>
                            </select>
                        </dd>
                        <dd>
<? 
$row  = mysql_fetch_array($result_sum)
?>

                            <input type='text' name='keyword' style="height:29px;" size=20 value='<?=$keyword;?>'>
                        </dd>
                        <dd class="searchbtnarea">
                            <a href='javascript:Search();' class="searchBtn bgpi">°Ë»ö</a>
                            <input type='hidden' name='mode' value='search'>
                        </dd>
                    </dl><!--//search_tender-->

                    <dl class="search_tender requestSearchArea mt10" style="width: 762px;">
                        <dt class="screen_out">e¸ÞÀÏ°è»ê¼ °Ë»ö</dt>
                        <dd class="first">
                            <a href='bill_insert.php?menu=7&sub=2' class="billBtn"><span class="orange">¼¼±Ý°è»ê¼ µî·Ï</span></a>
                        </dd>
                        <dd>
                            <a href='javascript:popTaxIssueCount();' class="billBtn"><span class="green">¼¼±Ý°è»ê¼ ¹ßÇà°Ç¼ö</span></a>
                        </dd>
                        <dd>
                            <a href='javascript:billBasic();' class="billBtn"><span class="blue">±âº»Á¤º¸ µî·Ï</span></a>
                        </dd>
                        <dd>
                            <a href='bill_excel.php' class="xls"><span class="green">¿¢¼¿ÀüÈ¯</span></a>
                        </dd>
                        <dd>
                            <em class="title bgpi">ÇÕ°è±Ý¾×</em>
                            <input type="text" name="totalbox" value="<?=number_format($row['totalm']);?>">
                        </dd>
                        <dd>
                        <a href="http://www.mijinsoft.co.kr/tax_mailer.php"class="billBtn"><span class="red">¹Ì¹ß¼Û ¸ÞÀÏº¸³»±â</span></a>
                        </dd>
                    <dl><!--//search_tender-->
                </div><!-- //searchBox -->
            </form>



            <form name='billFrm'>
                <input type=hidden name=all value=1>
                <input type=hidden name=exCode value=alldel>
                <input type=hidden name=expos value=allpos>
                <input type=hidden name=eximpos value=allimpos>
                <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=searchCode value=<?=$searchCode;?>>
                <input type=hidden name=keyword value=<?=$keyword;?>>
                <input type=hidden name=pg value=<?=$pg;?>>
                <div class="borderWarp" style="width:1100px; margin-left:-50px;">
                    <table class="borderTable requestarea">
                        <tr class="bgpi">
                            <th style="width:40px;"><img src="./images/common/bt_allcheck_all.gif" alt="¸ðµÎ¼±ÅÃ" style="cursor:pointer;" name="chkImg" onClick="CheckAll();"></th>
                            <th style="width:49px;">No</th>
                            <th style="width:69px;">¹ßÇàÀÏ</th>
                            <th style="width:89px; letter-spacing:-1px;">»ç¾÷ÀÚµî·Ï¹øÈ£</th>
                            <th style="width:204px;">È¸»ç¸í</th>
                            <th style="width:59px;">´ëÇ¥ÀÚ¸í</th>
                            <th style="width:69px;">±Ý¾×</th>
                            <th style="width:59px;">½ÂÀÎ»óÅÂ</th>
                            <th style="width:74px;">¹ßÇàÇã¿ë</th>
                            <th style="width:59px;">¸ÞÀÏ¹ß¼Û</th>
                            <th style="width:159px;">º¸³»´Â ¸ÞÀÏ</th>
                            <th style="width:159px;" class="last">¹Þ´Â ¸ÞÀÏ</th>
                        </tr>
<?
if($num = mysql_num_rows($result)){

    while($row  = mysql_fetch_array($result)) {
    
        if($row[admission] == "1" )                $statu =  "ºñ½ÂÀÎ";
            else if ($row[admission] == "3" ) $statu =  "<span class='red'>¹Ý¼Û</span>";
            else                                                            $statu =  "<span class='blue'>½ÂÀÎ</span>";
        
        if($row[ismailsend] == 1 )                $sSend =  "<span class='blue'>¹ß¼Û</span>";
            else                                                            $sSend =  "<span class='red'>¹Ì¹ß¼Û</span>";
?>

<?
    if($row[tax_visible] == "0" ) $visi = "Çã¿ë";
        else                          $visi = "ÁßÁö";
?>
                        <tr>
                            <td><input name="billForm[]" type="checkbox" value="<?=$row[idx];?>"></td>
                            <td class="family"><?=$row[idx];?></td>
                            <td><?=$row[year];?>-<?=$row[MONTH];?>-<?=$row[DAY];?></td>
                            
                            <td>
                                <p><?=$row[from_companynum]?></p>
                                <p><?=$row[companyNum];?></p>
                            </td>
                            <td><a href='billReg.php?menu=<?=$menu?>&sub=<?=$sub?>&idx=<?=$row[idx];?>'>
                                <p><?=$row[companyName2];?></p>
                                <p><?=$row[companyName];?></p>
                            </a></td>
                            <td>
                                <p><?=$row[chiefName2];?></p>
                                <p><?=$row[chiefName];?></p>
                            </td>
                            
                            <td><?=number_format($row['totalprice']);?></td>
                            <td><?=$statu;?></td>
                            <td><?=$visi;?></td>
                            <td><A HREF="#" onClick="ChangSend('<?=$row[idx];?>', <? if($row[ismailsend] == 1 ) {echo '0';} else {echo '1';} ?>);"><?=$sSend;?></A></td>
                            <td><?=$row[send_mail];?></td>
                            <td class="last"><?=$row[receive_mail];?></td>
                        </tr>
                            

<?
        }
    }
    else{
?>
                        <tr>
                            <td colspan="12" class="last">µ¥ÀÌÅÍ°¡ ¾ø½À´Ï´Ù.</td>
                        </tr>
<?
    }
?>
                        <tr>
                            <td colspan="2" class="bottom last">
                                <a href='javascript:allDel();' class="allDelBtn">ÀÏ°ý»èÁ¦</a>
                            </td>
                            <td colspan="6" class="bottom last"></td>
                            <td class="bottom last">
<? 
$tpos = "¹ßÇàÇã¿ë";
$timpos = "¹ßÇàÁßÁö";
?>
                                <p><input type="button" name="expos" value=<?=$tpos;?> Onclick="allpos();" style="width:70px;"></p>
                                <p><input type="button" name="eximpos" value=<?=$timpos;?> Onclick="allimpos();" style="width:70px; margin-bottom:2px;"></p>
                            </td>
                            <td colspan="3" class="bottom last"></td>
                        </tr>
                    </table><!-- //borderTable -->
                </div><!-- //borderWarp -->
            </form>
                    
            <?    echo pageListing($pg, $nPage, $cm_nCount, "bill.php?menu=7&sub=2&keydate1=$keydate1&keydate2=$keydate2&selapp=$selapp&searchCode=$searchCode&keyword=$keyword&mode=$mode&totalbox=$totalbox&pg=" , $mode, $selapp, $keydate1, $keydate2, $searchCode ,$keyword,  $menu, $sub )?>
            <?//print_r($_REQUEST)?>

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

        <p class="navi">°ü¸®ÀÚ¸ðµå > °è»ê¼°ü¸® > e¸ÞÀÏ°è»ê¼</p>

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


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

</body>
</html>