1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48

<?php include_once("./_common2.php"); ?>
<?
    include("../../manage/category/common.php");
 
  if( isset($companyNum ) && $companyNum !== ""){
        //    $Qry       =  " SELECT * FROM bill_publish WHERE REPLACE(companyNum,'-','') = '$companyNum' AND REPLACE(from_companynum,'-','') = '5021894746' ";

        //2013-04-11 S.H.Choi - Äõ¸® Æ©´×(À妽º¸¦ Å¸µµ·Ï Äõ¸® ¼öÁ¤. À̸¦ À§ÇØ À妽º¸¦ »ý¼ºÇØ µ×À½)
        //    $Qry       =  " SELECT * FROM bill_publish WHERE REPLACE(companyNum,'-','') = '$companyNum' ";

        //ÀԷ ÀμöÀÇ ±æÀ̸¦ º¸°í »ç¾÷ÀÚ¹øÈ£ÀÎÁö Áֹεî·Ï¹øÈ£ÀÎÁö ÆÇ´Ü
        $lenCompanyNum = strlen($companyNum);
        if ($lenCompanyNum == 10) {
            //»ç¾÷ÀÚ¹øÈ£ÀΠ°æ¿ì
            $fmtCompanyNum = substr($companyNum, 0, 3) . "-" . substr($companyNum, 3, 2) . "-" . substr($companyNum, 5); //5021894746 -> 502-18-94746
        } else if($lenCompanyNum == 13) {
            //Áֹεî·Ï¹øÈ£ÀΠ°æ¿ì
            $fmtCompanyNum = substr($companyNum, 0, 6) . "-" . substr($companyNum, 6); //1234567890123 -> 123456-7890123
        } else {
            //À߸ø ÀÔ·ÂÇÑ °æ¿ì
            $fmtCompanyNum = $companyNum;
        }

        $Qry = "SELECT idx FROM bill_publish WHERE companyNum = '$fmtCompanyNum' LIMIT 0,1";
        $Result = mysql_query($Qry);
        if( mysql_num_rows($Result) > 0){
            //$row   =   mysql_fetch_array($Result);
            $str   =  "@$@QTRSFQ3YHQAWR-EHEQT3Q46TEGEWFRE34--634YWGHWHWRW2222-3SGAZEHWE2---".$companyNum;
            $str   =   base64_encode($str);
            ?> <script>
                parent.location.href = "./customeretax_01.php?KeyCode=<?=$str;?>";
            </script> <?         
        } else {
            ?> <script charset="utf-8">
                parent.Msg("ÇØ´ç µ¥ÀÌÅÍ°¡ Á¶È¸µÇÁö ¾Ê½À´Ï´Ù. °ø±ÞÀÚ°¡ °è»ê¼­¸¦ Ãë¼ÒÇßÀ» ¼ö ÀÖÀ¸´Ï ´Ù½Ã È®ÀÎÇØ ÁÖ¼¼¿ä.");
            </script> <?     
        } 
    } 

  if($mode == "detail"){
        $updateQry  =  "update bill_publish set admission = '$stat' WHERE idx = '$idx'";
    mysql_query($updateQry);
        ?> <script>
            location.href =  "./customeretax_01.php?KeyCode=<?=$KeyCode;?>&mode=detail&idx=<?=$idx;?>&detail=y";
        </script> <?                      
    }  
?>