webadmin.php

/home/mjc1/public_html/html/tax_mailer_test.php

#!/usr/bin/php -q
<?
    // ¸ÞÀÏ º¸³»±â (ÆÄÀÏ ¿©·¯°³ Ã·ºÎ °¡´É)
    // type : text=0, html=1, text+html=2
    function mailer($fname, $fmail, $to, $subject, $content, $type=0, $file="", $cc="", $bcc="")
    {
        //global $config;
        //global $g4;

        // ¸ÞÀÏ¹ß¼Û »ç¿ëÀ» ÇÏÁö ¾Ê´Â´Ù¸é
        //if (!$config[cf_email_use]) return;

        $fname   = "=?euc-kr?B?" . base64_encode($fname) . "?=";
        $subject = "=?euc-kr?B?" . base64_encode($subject) . "?=";
        //$g4[charset] = ($g4[charset] != "") ? "charset=$g4[charset]" : "";

        $header  = "Return-Path: <$fmail>\n";
        $header .= "From: $fname <$fmail>\n";
        $header .= "Reply-To: <$fmail>\n";
        if ($cc)  $header .= "Cc: $cc\n";
        if ($bcc) $header .= "Bcc: $bcc\n";
        $header .= "MIME-Version: 1.0\n";
        //$header .= "X-Mailer: SIR Mailer 0.91 (sir.co.kr) : $_SERVER[SERVER_ADDR] : $_SERVER[REMOTE_ADDR] : $g4[url] : $_SERVER[PHP_SELF] : $_SERVER[HTTP_REFERER] \n";
        // UTF-8 °ü·Ã ¼öÁ¤
        $header .= "X-Mailer: SIR Mailer 0.92 (sir.co.kr) : $_SERVER[SERVER_ADDR] : $_SERVER[REMOTE_ADDR] : mijinsoft.co.kr : $_SERVER[PHP_SELF] : $_SERVER[HTTP_REFERER] \n";

        if ($file != "") {
            $boundary = uniqid("http://mijinsoft.co.kr/");

            $header .= "Content-type: MULTIPART/MIXED; BOUNDARY=\"$boundary\"\n\n";
            $header .= "--$boundary\n";
        }

        if ($type) {
            $header .= "Content-Type: TEXT/HTML; charset=euc-kr\n";
            if ($type == 2)
                $content = nl2br($content);
        } else {
            $header .= "Content-Type: TEXT/PLAIN; charset=euc-kr\n";
            $content = stripslashes($content);
        }
        $header .= "Content-Transfer-Encoding: BASE64\n\n";
        $header .= chunk_split(base64_encode($content)) . "\n";

        if ($file != "") {
            foreach ($file as $f) {
                $header .= "\n--$boundary\n";
                $header .= "Content-Type: APPLICATION/OCTET-STREAM; name=\"$f[name]\"\n";
                $header .= "Content-Transfer-Encoding: BASE64\n";
                $header .= "Content-Disposition: inline; filename=\"$f[name]\"\n";

                $header .= "\n";
                $header .= chunk_split(base64_encode($f[data]));
                $header .= "\n";
            }
            $header .= "--$boundary--\n";
        }
        @mail($to, $subject, "", $header);
    }

    include("/home/mjc1/public_html/manage/category/common.php");

    /********************************
    ¹Ì¹ß¼Û ¼¼±Ý°è»ê¼¸¸ ¹ß¼Û(½ÂÀÎ¿©ºÎ:admission = 1   ¼ö½Å¿©ºÎ:isreceive = 0  Á¦¿Ü)
    ************************************/
    $query  = " SELECT p.idx, m.companyName mCompanyName, m.companyNum mCompanyNum, m.send_mail, p.companyName pCompanyName, p.receive_mail, replace(p.companynum,'-','') companynum, p.year, p.month, p.day, m.companytel, m.companyAddr mCompanyAddr, m.opt_1 mopt_1, m.opt_2 mopt_2, p.companyNum pcompanyNum, p.companyAddr pcompanyAddr, p.opt_1 popt_1, p.opt_2 popt_2, p.item_1 pitem_1, p.offerPrice pofferPrice, p.billPrice pbillPrice, p.totalPrice ptotalPrice ";
    $query .= "   FROM bill_mijin m ";
    $query .= "        INNER JOIN bill_publish p ON m.companyNum = p.from_companynum ";
    //$query .= "  WHERE p.receive_mail <> '' AND p.ismailsend = 0 ";
    $query .= "      WHERE p.idx = 18251 ";

    $result = mysql_query($query);

    if(mysql_num_rows($result) > 0){
        While($row = mysql_fetch_array($result)) {
            $encode_num =  "@$@QTRSFQ3YHQAWR-EHEQT3Q46TEGEWFRE34--634YWGHWHWRW2222-3SGAZEHWE2---".$row[companynum];
            $encode_num =   base64_encode($encode_num);

            $encode_idx =  "@$@QTRSFQ3YHQAWR-EHEQT3Q46TEGEWFRE34--634YWGHWHWRW2222-3SGAZEHWE2---".$row[idx];
            $encode_idx =   base64_encode($encode_idx);


            $sOfferPrice    =    number_format($row[pofferPrice]);    //°ø±Þ°¡¾×
            $sBillPrice =    number_format($row[pbillPrice]);    //ºÎ°¡¼¼
            $sTotalPrice =    number_format($row[ptotalPrice]);    //ÅäÅ»±Ý¾×

            // º¸³»´Â ¸ÞÀÏ
            $send_mail = "mj@mijinsoft.co.kr";
            if($row[send_mail] != "") $send_mail = $row[send_mail];

            // º»¹®
            $mail_content  = $row[mCompanyName]."(À¸)·ÎºÎÅÍ ¼¼±Ý°è»ê¼°¡ µµÂøÇÏ¿´½À´Ï´Ù.<br> ";
            $mail_content  = "
<style>
a:link { 
            font-family:'verdana','µ¸¿ò';
            font-size:9pt;
              text-decoration:none; 
              color: #666666
    }
    a:active { 
            font-family:'verdana','µ¸¿ò';
        font-size:9pt;
              text-decoration:none; 
              color: #666666
    }

    a:hover { 
            font-family:'verdana','µ¸¿ò';
        font-size:9pt;
              text-decoration:none; 
              color: #868686
    }
    a:visited {
                font-family:'verdana','µ¸¿ò';
        font-size:9pt;
              text-decoration:none; 
              color: #868686
    }    
table { font-color;#000000;font-size:9pt }    
</style>

<TABLE align='center' width='668' height='1000' background='http://www.mijinsoft.co.kr/img/etaxbg.gif'>
    <TR>
        <TD>

            <TABLE><TR><TD height='120'></TD></TR></TABLE>

            <TABLE width='500' border='0' align='center'>
                <TR>
                    <TD height='40'><b>$row[mCompanyName]</b>¿¡¼ ±ÍÇÏ²² ¹ß¼ÛÇÑ ¼¼±Ý°è»ê¼°¡ µµÂø ÇÏ¿´½À´Ï´Ù.</TD>
                </TR>
                <TR>
                    <TD height='40'><b>[¼¼±Ý°è»ê¼ ¹Ù·Î°¡±â]</b> ¹öÆ°À» Å¬¸¯ÇÏ½Ã¸é ¼¼±Ý°è»ê¼¸¦ ¼¼¹ý¿¡ Á¤ÇÑ ¼¼±Ý°è»ê¼ ¾ç½ÄÇüÅÂ·Î ÀÎ¼âÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.</TD>
                </TR>
                <TR>
                    <TD height='40'>¼¼±Ý°è»ê¼ ³»¿ë¿¡ ¹®Á¦°¡ ÀÖÀ» °æ¿ì¿¡´Â [¹Ý¼Û]¹öÆ°À» ´©¸£½Å ÈÄ ¹ßÇàÀÚ(°Å·¡Ã³)¿¡°Ô ¿¬¶ôÇÏ¼¼¿ä.</TD>
                </TR>
                <TR>
                    <TD height='40'><B><FONT COLOR='#0066FF'>ÀüÀÚ°è»ê¼ »ç¿ë ½ÅÃ»¹®ÀÇ : 1566-8680 (¹ÌÁø¼ÒÇÁÆ®)</FONT></B></TD>
                </TR>
            </TABLE>

            <TABLE width='500' align='center'>
                <TR>
                    <TD align='right' height='50'><a href='http://www.mijinsoft.co.kr/html/community_07_02.php?KeyCode=$encode_num' target='_blank'><IMG SRC='http://www.mijinsoft.co.kr/img/etaxprintgo.gif' BORDER='0'></a></TD>
                </TR>
            </TABLE>

            <TABLE width='500' align='center'>
                <TR>
                    <TD><IMG SRC='http://www.mijinsoft.co.kr/img/gonginfo.gif' BORDER='0'></TD>
                </TR>
            </TABLE>

            <table width='500' align='center' cellpadding='5' cellspacing='1' border='0' style='color:#666666;background-color:#B1CBD6' class='txt03'>
                <tr bgcolor='#FFFFFF'>
                    <td width='150' bgcolor='#FFFFCC'> <b>»óÈ£</b></td>
                    <td width='350' align='center'>$row[mCompanyName]</td>
                </tr>
                <tr bgcolor='#FFFFFF'>
                    <td bgcolor='#FFFFCC'> <b>»ç¾÷ÀÚ µî·Ï¹øÈ£</b></td>
                    <td align='center'>$row[mCompanyNum]</td>
                </tr>
                <tr bgcolor='#FFFFFF'>
                    <td bgcolor='#FFFFCC'> <b>»ç¾÷Àå ÁÖ¼Ò</b></td>
                    <td align='center'>$row[mCompanyAddr]</td>
                </tr>
                <tr bgcolor='#FFFFFF'>
                    <td bgcolor='#FFFFCC'> <b>¾÷ÅÂ</b></td>
                    <td align='center'>$row[mopt_1]</td>
                </tr>
                <tr bgcolor='#FFFFFF'>
                    <td bgcolor='#FFFFCC'> <b>¾÷Á¾</b></td>
                    <td align='center'>$row[mopt_2]</td>
                </tr>
                <tr bgcolor='#FFFFFF'>
                    <td bgcolor='#FFFFCC'> <b>´ã´çÀÚ ÀüÈ¹øÈ£</b></td>
                    <td align='center'>$row[companytel]</td>
                </tr>
            </table>

            <br>

            <TABLE width='500' align='center'>
                <TR>
                    <TD><IMG SRC='http://www.mijinsoft.co.kr/img/batinfo.gif' BORDER='0'></TD>
                </TR>
            </TABLE>

            <table width='500' align='center' cellpadding='5' cellspacing='1' border='0' style='color:#666666;background-color:#B1CBD6' class='txt03'>
                <tr bgcolor='#FFFFFF'>
                    <td width='150' bgcolor='#FFFFCC'> <b>»óÈ£</b></td>
                    <td width='350' align='center'>$row[pCompanyName]</td>
                </tr>
                <tr bgcolor='#FFFFFF'>
                    <td bgcolor='#FFFFCC'> <b>»ç¾÷ÀÚ µî·Ï¹øÈ£</b></td>
                    <td align='center'>$row[pcompanyNum]</td>
                </tr>
                <tr bgcolor='#FFFFFF'>
                    <td bgcolor='#FFFFCC'> <b>»ç¾÷Àå ÁÖ¼Ò</b></td>
                    <td align='center'>$row[pcompanyAddr]</td>
                </tr>
                <tr bgcolor='#FFFFFF'>
                    <td bgcolor='#FFFFCC'> <b>¾÷ÅÂ</b></td>
                    <td align='center'>$row[popt_1]</td>
                </tr>
                <tr bgcolor='#FFFFFF'>
                    <td bgcolor='#FFFFCC'> <b>¾÷Á¾</b></td>
                    <td align='center'>$row[popt_2]</td>
                </tr>
            </table>

            <br>

            <TABLE width='500' align='center'>
                <TR>
                    <TD><IMG SRC='http://www.mijinsoft.co.kr/img/saninfo.gif' BORDER='0'></TD>
                </TR>
            </TABLE>

            <table width='500' align='center' cellpadding='5' cellspacing='1' border='0' style='color:#666666;background-color:#B1CBD6' class='txt03'>
                <tr bgcolor='#FFFFFF'>
                    <td width='150' bgcolor='#FFFFCC'> <b>¹ßÇàÀÏÀÚ</b></td>
                    <td width='350' align='center'>$row[year]-$row[month]-$row[day]</td>
                </tr>
                <tr bgcolor='#FFFFFF'>
                    <td bgcolor='#FFFFCC'> <b>Ç°¸ñ</b></td>
                    <td align='center'>$row[pitem_1]</td>
                </tr>
                <tr bgcolor='#FFFFFF'>
                    <td bgcolor='#FFFFCC'> <b>ÃÑ °ø±Þ°¡¾×</b></td>
                    <td align='center'>$sOfferPrice ¿ø</td>
                </tr>
                <tr bgcolor='#FFFFFF'>
                    <td bgcolor='#FFFFCC'> <b>ÃÑ ¼¼¾×</b></td>
                    <td align='center'>$sBillPrice ¿ø</td>
                </tr>
                <tr bgcolor='#FFFFFF'>
                    <td bgcolor='#FFFFCC'> <b>ÇÕ°è±Ý¾×</b></td>
                    <td align='center'>$sTotalPrice ¿ø</td>
                </tr>
            </table>

            <TABLE width='500' align='center'>
                <TR>
                    <TD align='center' height='70'><a href='http://www.mijinsoft.co.kr/html/community_07_02.php?KeyCode=$encode_num' target='_blank'><IMG SRC='http://www.mijinsoft.co.kr/img/etaxprintgo.gif' BORDER='0'></a></TD>
                </TR>
            </TABLE>

        </TD>
    </TR>
</TABLE>
            ";
            mailer($row[mCompanyName], $send_mail, $row[receive_mail], $row[mCompanyName]."(À¸)·ÎºÎÅÍ ¼¼±Ý°è»ê¼°¡ µµÂøÇÏ¿´½À´Ï´Ù.", $mail_content,1);
           
            // ¹ß¼Û¿©ºÎ ¾÷µ¥ÀÌÆ®
            $query_update =  " UPDATE bill_publish SET ismailsend = 1 WHERE idx = $row[idx]"; // °ø±Þ¹Þ´ÂÀÚ
            mysql_query($query_update); //Å×½ºÆ® ÈÄ ÇØÁ¦ÇÒ°Í
            echo $row[mCompanyName];
            usleep(3000000);
            flush();
        }
    }
?>