2014年7月7日 星期一

PHP write/mail file

#!/usr/bin/php

<?php
    $cnt = 0;
    function getData() {
        require "setEnv.php";

        //MySQL Connect
        $con = mysql_connect("$hostMySQL","$usernameMySQL","$passwordMySQL");
        if (!$con)
          {
            die('Could not connect: ' . mysql_error());
          }
        mysql_select_db("$databaseMySQL", $con);
        mysql_query("SET NAMES 'utf8'");

        $result = mysql_query("
select ima01,ima127,ima128,ima262_01,ima262_02 from mobile.IMA_FILE
 where ima262_01+ima262_02 > 0
   and ima127 = 0 and ima128 = 0
");

        $fp = fopen('/tmp/MailNoPrice.csv', 'w');
        fwrite($fp, iconv("UTF-8","big5","料號").",".iconv("UTF-8","big5","可出量")."\n");
        while($row = mysql_fetch_assoc($result))
        {
          fwrite($fp, $row['ima01']);
          fwrite($fp, ",");
          fwrite($fp, $row['ima262_01'] + $row['ima262_02']);
          fwrite($fp, "\n");
          $GLOBALS['cnt'] += 1;
        }
        fclose($fp);

        mysql_close($con);
    }

    function sendMail() {
        require_once('sysmail.inc.php');
        require_once('class.phpmailer.php');

        $phpmail = new PHPMailer();
        $phpmail->IsSMTP(true);
        $phpmail->Host = $SysMail['SMTPhost'];
        $phpmail->CharSet = "utf-8";
        $phpmail->From = 'tyruan@echochem.com.tw';
        $phpmail->FromName = 'MIS';
        $phpmail->Subject = '有庫存,沒訂價 料號列表 (影響外網訂價)';

        $html = "共計:" . $GLOBALS['cnt'] . "筆,請儘速修正。謝謝";
        $phpmail->MsgHTML($html);
        $phpmail->AddAttachment( "/tmp/MailNoPrice.csv" , 'MailNoPrice.csv' );

        $phpmail->AddAddress( "tyruan@echochem.com.tw",'MIS' );
        $phpmail->AddCC( "tyruan@echochem.com.tw",'MIS');
        $phpmail->Send();
    }

    function main() {
        getData();
        if ($GLOBALS['cnt'] > 0) {
            sendMail();
        }
    }

    main();
?>

沒有留言:

張貼留言