webadmin.php

/home/mjc1/public_html/tax_mailer-test.php

#!/usr/bin/php -q
<br>
ÀüÀÚ¼¼±Ý°è»ê¼(E-Tax) Àü¼Û °á°ú
<br>
<?

    include("./PHPMailer5/PHPMailerAutoload.php"); // phpmailer 5 ¸ðµâ ±×´©º¸µå 2.0 ¸ðµâÇÏ°í ¸î¸î ¸í·É¾î³ª ´ë¼Ò¹®ÀÚ³ª ±âÅ¸ Æ²¸²

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

    /********************************
    ¹Ì¹ß¼Û ¼¼±Ý°è»ê¼¸¸ ¹ß¼Û(½ÂÀÎ¿©ºÎ:admission = 1   ¼ö½Å¿©ºÎ:isreceive = 0  Á¦¿Ü)
    ************************************/
for($i=0;$i<1;$i++){
    $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
                    FROM bill_mijin m
                    INNER JOIN bill_publish p ON m.companyNum = p.from_companynum
                    WHERE p.idx = '422559'
                    ORDER BY idx desc
                    LIMIT 0,1";

    $result = mysql_query($query);
    echo($query);

    //exit;

    if(mysql_num_rows($result) > 0){
        While($row = mysql_fetch_assoc($result)) {

            // ¹ß¼Û¿©ºÎ ¾÷µ¥ÀÌÆ®
            $query_update =  " UPDATE bill_publish SET ismailsend = 1 WHERE idx = $row[idx]"; // °ø±Þ¹Þ´ÂÀÚ
            mysql_query($query_update); //Å×½ºÆ® ÈÄ ÇØÁ¦ÇÒ°Í

            $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";
            $send_mail = "etax@mijinsoft.co.kr";

            // º¸³»´Â ¸ÞÀÏÀ» mj@mijinsoft.co.krÀÌ ¾Æ´Ñ ´Ù¸¥ host¸¦ »ç¿ëÇÏ¸é 
            // Àü¼Û´©¶ô ¹ßÇàÇÏ¹Ç·Î ±â´É Á¦ÇÑ
            //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
    }    


.txt03 { font-family:±¼¸²,Verdana; color:#333333; font-size:9pt; text-decoration:none; line-height:17px}
</style>


<script>
function fileDown(type,name,cate2_code,category_code){
    
    location.href =   'http://www.mijinsoft.co.kr/html/fileDownLoad.php?type='+type+'&filename='+name+'&cate2_code='+cate2_code+'&category_code='+ category_code ;
    
}
</script>
<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
    }    


.txt03 { font-family:±¼¸²,Verdana; color:#333333; font-size:9pt; text-decoration:none; line-height:17px}
</style>
<META http-equiv=Content-Type content='text/html; charset=euc-kr'>

<table border='0' cellpadding='0' cellspacing='0' align='center'>
    <tr>
        <td valign='top'>
            <a href='http://www.mijinsoft.co.kr' target='_blank'><img src='http://www.mijinsoft.co.kr/html/millennium/img/mail/top_text.jpg' border='0' alt='¾÷¹«¿ë¼ÒÇÁÆ®¿þ¾î Àü¹®°³¹ß¾÷Ã¼'/></a>
        </td>
        <td align='right'>
            <a href='http://www.mijinsoft.co.kr' target='_blank'><img src='http://www.mijinsoft.co.kr/html/millennium/img/mail/top_logo.jpg' border='0' alt='¹ÌÁø¼ÒÇÁÆ® Ãµ³â°æ¿µ'/></a>
        </td>
    </tr>

    <tr>
        <td valign='top' colspan='2'>
            <table width='702' border='0' cellpadding='0' cellspacing='0' style='border:1px solid #c4c4c4;' align='center'>
                <!--»ó´Ü Å¸ÀÌÆ²-->
                <tr>
                    <td style='padding:20px 0 0 25px;'>
                        <img src='http://www.mijinsoft.co.kr/html/millennium/img/mail/top_title_e.jpg'style='padding-bottom:6px;'/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                    </td>
                    <td align='right' style='padding:15px 22px 0 0 ;'>
                        <a href='http://www.mijinsoft.co.kr/html/millennium/customeretax_01.php?KeyCode=$encode_num' target='_blank'><img src='http://www.mijinsoft.co.kr/html/millennium/img/mail/taxgo_btn.jpg' border='0' alt='¼¼±Ý°è»ê¼ ¹Ù·Î°¡±â'></a>
                    </td>
                </tr>

                <tr>
                    <td colspan='2' align='center' style='padding:10px 0;'>
                        <img src='http://www.mijinsoft.co.kr/html/millennium/img/mail/top_banner_e.jpg'>
                    </td>
                </tr>

                <tr>
                    <td colspan='2' class='txt03' style='padding-left:30px; line-height:120%;' valign='top'>
                        <font color='#000000'>
                        1. º» ¼¼±Ý°è»ê¼´Â Á¾ÀÌ°è»ê¼¸¦ e¸ÞÀÏ·Î ¹ßÇàÇÑ °è»ê¼ÀÔ´Ï´Ù.<br>
                        &nbsp;&nbsp;&nbsp;±¹¼¼Ã»¿¡ ÀÚµ¿½Å°í µÇÁö ¾ÊÀ¸´Ï <b>Ãâ·Â ÈÄ ½Å°í</b>ÇÏ½Ã±â ¹Ù¶ø´Ï´Ù.<br><br>

                        2. <font color='#0066cc'><a href='http://www.mijinsoft.co.kr/html/millennium/customeretax_01.php?KeyCode=$encode_num' target='_blank'><b>[¹Ù·Î°¡±â]</b></a></font> ¹öÆ°À» ´©¸£¸é ÀüÀÚ°è»ê¼ Ãâ·ÂÀÌ °¡´ÉÇÕ´Ï´Ù.<br><br>

                        3. ¼¼±Ý°è»ê¼¿¡ ¹®Á¦°¡ ÀÖÀ» °æ¿ì Áï½Ã ¹ßÇàÃ³¿¡ ¹®ÀÇÇÏ¼¼¿ä.<br><br>
                        <font color='#0066cc'>
                        &nbsp;&nbsp;&nbsp;¹«·á ÀüÀÚ°è»ê¼ ÇÁ·Î±×·¥ <a href='http://www.mijinsoft.co.kr/html/fileDownLoad.php?type=w_file&filename=easytaxlite_setup.exe'><b>[Áï½Ã ´Ù¿î·Îµå]</b></a><br>
                        &nbsp;&nbsp;&nbsp;<font color='#ff0000'><b>¡Ø º» ¸ÞÀÏÀÇ È¸½ÅÀº ¾Æ·¡ 'È¸½Å e¸ÞÀÏ'À» ÂüÁ¶ÇØ ÁÖ¼¼¿ä.</font>
                    <td>
                </tr>

                <!-- Å×ÀÌºí ½ÃÀÛ -->
                <tr>
                    <td colspan='2' align='center' style='padding-top:10px;'>
                        <table border='0' cellpadding='0' cellspacing='1' bgcolor='#dcdcdc'>
                            <tr><td colspan='3' height='3' bgcolor='#699fe5'></td></tr>
                            <tr>
                                <td width='170' height='30' align='center' bgcolor='#f1f1f1'>
                                    <font color='#32609c'><b>±¸ ºÐ</font>
                                </td>
                                <td width='240' align='center' bgcolor='#f1f1f1'>
                                    <font color='#32609c'><b>°ø±ÞÀÚÁ¤º¸</font>
                                </td>
                                <td width='240' align='center' bgcolor='#f1f1f1'>
                                    <font color='#32609c'><b>°ø±Þ¹Þ´ÂÀÚ Á¤º¸</font>
                                </td>
                            </tr>
                            <tr>
                                <td width='150' height='27' bgcolor='#ffffff'>
                                    <font color='#5c91d5'><b>»ó È£</b></font>
                                </td>
                                <td align='center' bgcolor='#ffffff'>
                                    $row[mCompanyName]
                                </td>
                                <td align='center' bgcolor='#ffffff'>
                                    $row[pCompanyName]
                                </td>
                            </tr>
                            <tr>
                                <td height='27' bgcolor='#ffffff'>
                                    <font color='#5c91d5'><b>»ç¾÷ÀÚµî·Ï¹øÈ£</b></font>
                                </td>
                                <td align='center' bgcolor='#ffffff'>
                                    <font color='#4c4c4c'>
                                    $row[mCompanyNum]
                                </td>
                                <td align='center' bgcolor='#ffffff'>
                                    <font color='#4c4c4c'>
                                    $row[pcompanyNum]
                                </td>
                            </tr>
                            <tr>
                                <td height='27' bgcolor='#ffffff'>
                                    <font color='#5c91d5'><b>»ç¾÷Àå ÁÖ¼Ò</b></font>
                                </td>
                                <td align='center' bgcolor='#ffffff'>
                                    <font color='#4c4c4c'>
                                    $row[mCompanyAddr]
                                </td>
                                <td align='center' bgcolor='#ffffff'>
                                    <font color='#4c4c4c'>
                                    $row[pcompanyAddr]
                                </td>
                            </tr>
                            <tr>
                                <td height='27' bgcolor='#ffffff'>
                                    <font color='#5c91d5'><b>¾÷ ÅÂ</b></font>
                                </td>
                                <td align='center' bgcolor='#ffffff'>
                                    <font color='#4c4c4c'>
                                    $row[mopt_1]
                                </td>
                                <td align='center' bgcolor='#ffffff'>
                                    <font color='#4c4c4c'>
                                    $row[popt_1]
                                </td>
                            </tr>
                            <tr>
                                <td height='27' bgcolor='#ffffff'>
                                    <font color='#5c91d5'><b>¾÷ Á¾</b></font>
                                </td>
                                <td align='center' bgcolor='#ffffff'>
                                    <font color='#4c4c4c'>
                                    $row[mopt_2]
                                </td>
                                <td align='center' bgcolor='#ffffff'>
                                    <font color='#4c4c4c'>
                                    $row[popt_2]
                                </td>
                            </tr>
                            <tr>
                                <td height='27' bgcolor='#ffffff'>
                                    <font color='#5c91d5'><b>´ã´çÀÚ ÀüÈ¹øÈ£</b></font>
                                </td>
                                <td align='center' bgcolor='#ffffff'>
                                    <font color='#4c4c4c'>
                                    $row[companytel]
                                </td>
                                <td bgcolor='#ffffff'></td>
                            </tr>
                            <tr>
                                <td height='27' bgcolor='#ffffff'>
                                    <font color='#5c91d5'><b>È¸½Å e¸ÞÀÏ</b></font>
                                </td>
                                <td bgcolor='#ffffff'>
                                    <font color='#4c4c4c'>
                                    $row[send_mail]
                                </td>
                                <td bgcolor='#ffffff'></td>
                            </tr>
                        </table>
                    </td>
                </tr>
                

                <tr>
                    <td colspan='2' align='center' style='padding:15px;'>
                        <table border='0' cellpadding='0' cellspacing='1' bgcolor='#dcdcdc'>
                            <tr><td colspan='3' height='3' bgcolor='#699fe5'></td></tr>
                            <tr>
                                <td width='170' height='30' align='center' bgcolor='#f1f1f1'>
                                    <font color='#32609c'><b>±¸ ºÐ</font>
                                </td>
                                <td width='170' height='30' align='center' bgcolor='#f1f1f1'>
                                    <font color='#32609c'><b>¼¼±Ý°è»ê¼ Á¤º¸</font>
                                </td>
                            </tr>
                            <tr>
                                <td height='27' bgcolor='#ffffff'>
                                    <font color='#5c91d5'><b>¹ßÇàÀÏÀÚ</font>
                                </td>
                                <td width='480' bgcolor='#ffffff'>
                                    <font color='#4c4c4c'>
                                    $row[year]-$row[month]-$row[day]
                                </td>
                            </tr>
                            <tr>
                                <td height='27' bgcolor='#ffffff'>
                                    <font color='#5c91d5'><b>Ç° ¸ñ</font>
                                </td>
                                <td bgcolor='#ffffff'>
                                    <font color='#4c4c4c'>
                                    $row[pitem_1]
                                </td>
                            </tr>
                            <tr>
                                <td height='27' bgcolor='#ffffff'>
                                    <font color='#5c91d5'><b>ÃÑ °ø±Þ°¡¾×</font>
                                </td>
                                <td bgcolor='#ffffff'>
                                    <font color='#4c4c4c'>
                                    $sOfferPrice ¿ø
                                </td>
                            </tr>
                            <tr>
                                <td height='27' bgcolor='#ffffff'>
                                    <font color='#5c91d5'><b>ÃÑ ¼¼¾×</font>
                                </td>
                                <td bgcolor='#ffffff'>
                                    <font color='#4c4c4c'>
                                    $sBillPrice ¿ø
                                </td>
                            </tr>
                            <tr>
                                <td height='27' bgcolor='#ffffff'>
                                    <font color='#5c91d5'><b>ÇÕ°è±Ý¾×</font>
                                </td>
                                <td bgcolor='#ffffff'>
                                    <font color='#4c4c4c'>
                                    $sTotalPrice ¿ø
                                </td>
                            </tr>
                        </table>
                    </td>
                </tr>
                <tr>
                    <td align='center' colspan='2' style='padding-top:20px;'><a href='http://www.mijinsoft.co.kr/html/millennium/customeretax_01.php?KeyCode=$encode_num' target='_blank'><img src='http://www.mijinsoft.co.kr/html/millennium/img/mail/taxgo_btn.jpg' border='0'></a></td>
                </tr>
                <tr>
                    <td align='center' colspan='2'>
                        <font color='#0066cc'><a href='http://www.mijinsoft.co.kr/html/millennium/customeretax_01.php?KeyCode=$encode_num' target='_blank'><b>[¼¼±Ý°è»ê¼ ¹Ù·Î°¡±â]</b></a></font>
                        <br><br>
                    </td>
                </tr>
            </table>
        </td>
    </tr>
    <tr><td colspan='2' height='3' bgcolor='#dcdcdc'><td><tr>
    <tr>
        <td align='center'><a href='http://www.mijinsoft.co.kr/html/millennium/productinfo.php?cate2_code=06&category_code=56'><img src='http://www.mijinsoft.co.kr/html/millennium/img/mail/ad_01.jpg' border='0'></a></td>
        <td align='center'><a href='http://www.mijinsoft.co.kr/html/millennium/millennium_main.php'><img src='http://www.mijinsoft.co.kr/html/millennium/img/mail/ad_02.jpg' border='0'></a></td>
    </tr>
    <!--ÇÏ´Ü Ä«ÇÇ¶óÀÌÆ®-->
    <tr>
        <td valign='top' colspan='2'>
            <table width='702' border='0' cellpadding='0' cellspacing='0' bgcolor='#f7f7f7' align='center'>
                <td align='left' style='padding:20pt'>
                    <img src='http://www.mijinsoft.co.kr/html/millennium/img/mail/bottom_logo.jpg'/>
                </td>
                <td style='font-size:11px; padding:10pt 5pt; line-height:110%;'>
                    <font color='a1a1a1'><b>¿¥Á¦ÀÌ¼ÒÇÁÆ®</b>&nbsp;&nbsp;´ëÇ¥ : Á¤ÀÏ¿µ<br>
                    »ç¾÷ÀÚµî·Ï¹øÈ£ : 502-18-94746&nbsp;&nbsp;Åë½ÅÆÇ¸Å¾÷½Å°í : 2011-¼¿ï¼ÛÆÄ-0758<br>
                    ¼¿ïÆ¯º°½Ã ¼ÛÆÄ±¸ Áß´ë·Î 105(°¡¶ôµ¿, ¾ÆÀÌµðÅ¸¿ö 1004È£)<br>
                    TEL : <b>(02)401-5121</b>&nbsp;FAX : <b>(02)832-3555</b><br>
                    COPYRIGHT(c)2014 MJSOFT COMPANY ALL RIGHTS RESERVED.
                    </font>
                </td>
            </table>
        </td>
    </tr>
</table>
                        
                
            ";
            //mailer($row['mCompanyName'], $send_mail, $row['receive_mail'], $row['mCompanyName']."(À¸)·ÎºÎÅÍ ¼¼±Ý°è»ê¼°¡ µµÂøÇÏ¿´½À´Ï´Ù.", $mail_content,1);

            $mail = new PHPMailer;
            $mail->CharSet = 'EUCKR';
            $mail->Debugoutput = 'html';
            $mail->SMTPDebug = 0;
            $mail->setFrom($send_mail, "¿¥Á¦ÀÌ¼ÒÇÁÆ®");
            $mail->addAddress($row['receive_mail']);
            $mail->Subject = $row['mCompanyName']."(À¸)·ÎºÎÅÍ ¼¼±Ý°è»ê¼°¡ µµÂøÇÏ¿´½À´Ï´Ù.";
            $mail->isHTML(true); 
            $mail->Body = $mail_content;
            //return;
            if (!$mail->send()) {
                echo  $row['receive_mail']." ¸ÞÀÏ Àü¼Û¿¡ ½ÇÆÐÇÏ¿´½À´Ï´Ù. <br>º¸³»´Â ¸ÞÀÏ ¼³Á¤ÀÌ³ª ¿©·¯°¡Áö¸¦ È®ÀÎÇØº¸½Ã±â ¹Ù¶ø´Ï´Ù. <br>±âº»È¯°æ¼³Á¤->¸ÞÀÏ¼³Á¤¿¡¼ ¼³Á¤À» È®ÀÎÇÏ½Ã±â ¹Ù¶ø´Ï´Ù.<br>".$mail->ErrorInfo;
            } else {
                echo  "OK";
            }
           

            echo $row['mCompanyName'];
            echo ("<br>");
            usleep(1000000); //¼¹ö°¡ timeout °É¸®Áö ¾Êµµ·Ï ¼öÄ¡¸¦ Á¶Á¤ÇÑ´Ù.(30000000->10000000)À¸·Î ¼öÁ¤ÇØÁÜ
            flush();
        }
    }
}
?>