#!/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();
?>
沒有留言:
張貼留言