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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90

<?php include_once("./_common2.php"); ?>
<?
    include("../../manage/category/common.php");
    
    if(!isset($mode)) $mode = "";

    if( isset($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;
        }
   
        if( $searchtype == "1") {
            // ¹ÌÁø ¼ÒÇÁÆ® Àü¿ë Ã³¸®
            // - ¼¼±Ý°è»ê¼­ ¹ßÇà ³»¿ª°ú ¹ßÇà ¿äû¿¡¼­ Á¶È¸

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

            $findsucc = false;

            //1. ¼¼±Ý°è»ê¼­ ¹ßÇà ³»¿ª¿¡¼­ Á¶È¸
            $Qry = "SELECT idx FROM bill_publish WHERE companyNum = '$fmtCompanyNum' AND from_companynum = '502-18-94746' LIMIT 0,1";
            $Result = mysql_query($Qry);
            if(mysql_num_rows($Result) > 0){
                $findsucc = true;
            } else {
                    //2. ¼¼±Ý°è»ê¼­ ¿äû¿¡¼­ Á¶È¸
                    $QryTax    = "SELECT uid FROM mBoard_taxrequest WHERE companyNum = '$companyNum' LIMIT 0,1";    //´ë½Ã¾øÀÌ ÀúÀåµÇ¾î ÀÖÀ¸¹Ç·Î Æ÷¸ËÆàÇÊ¿ä¾øÀ½
                    $ResultTax = mysql_query($QryTax);
                    if(mysql_num_rows($ResultTax) > 0){
                        $findsucc = true;
                    }
            }
            
            //ÀÚ·á Ã£±â ¼º°ø½Ã
            if ($findsucc == true) {
                $str = "@$@QTRSFQ3YHQAWR-EHEQT3Q46TEGEWFRE34--634YWGHWHWRW2222-3SGAZEHWE2---".$companyNum;
                $str = base64_encode($str);
                ?> <script>
                    parent.location.href = "./customeretaxMijin_01.php?KeyCode=<?=$str;?>";
                </script> <?         
            } else {
                //ã±â ½ÇÆнÃ
                ?> <script>
                    parent.Msg("ÇØ´ç µ¥ÀÌŸ°¡ ¾ø½À´Ï´Ù.´Ù½Ã È®ÀÎÇØ ÁÖ¼¼¿ä");
                </script> <?     
            }

        } else {
            //¾÷ü¿ë Ã³¸®
            //$Qry = "SELECT * FROM bill_publish WHERE REPLACE(companyNum,'-','') = '$companyNum' AND receive_mail = '$companyEmail'";
            $Qry = "SELECT idx FROM bill_publish WHERE companyNum = '$fmtCompanyNum' AND receive_mail = '$companyEmail' 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>
                    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> <?                      
        }  
    }
?>