File Source for SC_Helper

<?php
/*
* This file is part of EC-CUBE
*
* Copyright(c) 2000-2011 LOCKON CO.,LTD. All Rights Reserved.
*
* http://www.lockon.co.jp/
*
* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU General Public License
* as published by the Free Software Foundation; either version 2
* of the License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
*/
/**
* メール関連のヘルパークラス.
*
* @package Helper
* @author LOCKON CO.,LTD.
* @version $Id: SC_Helper_Mail.php 21302 2011-10-28 09:58:18Z shutta $
*/
class SC_Helper_Mail {
/** メールテンプレートのパス */
var $arrMAILTPLPATH;
/**
* コンストラクタ.
*/
function SC_Helper_Mail() {
$masterData = new SC_DB_MasterData_Ex();
$this->arrMAILTPLPATH = $masterData->getMasterData("mtb_mail_tpl_path");
$this->arrPref = $masterData->getMasterData('mtb_pref');
}
/* DBに登録されたテンプレートメールの送信 */
function sfSendTemplateMail($to, $to_name, $template_id, &$objPage, $from_address = "", $from_name = "", $reply_to = "", $bcc = '') {
$objQuery = new SC_Query_Ex();
// メールテンプレート情報の取得
$where = "template_id = ?";
$arrRet = $objQuery->select("subject, header, footer", "dtb_mailtemplate", $where, array($template_id));
$objPage->tpl_header = $arrRet[0]['header'];
$objPage->tpl_footer = $arrRet[0]['footer'];
$tmp_subject = $arrRet[0]['subject'];
$arrInfo = SC_Helper_DB_Ex::sfGetBasisData();
$objMailView = new SC_SiteView_Ex();
// メール本文の取得
$objMailView->assignobj($objPage);
$body = $objMailView->fetch($this->arrMAILTPLPATH[$template_id]);
// メール送信処理
$objSendMail = new SC_SendMail_Ex();
if ($from_address == "") $from_address = $arrInfo['email03'];
if ($from_name == "") $from_name = $arrInfo['shop_name'];
if ($reply_to == "") $reply_to = $arrInfo['email03'];
$error = $arrInfo['email04'];
$tosubject = $this->sfMakeSubject($tmp_subject, $objMailView);
$objSendMail->setItem('', $tosubject, $body, $from_address, $from_name, $reply_to, $error, $error, $bcc);
$objSendMail->setTo($to, $to_name);
$objSendMail->sendMail(); // メール送信
}
/* 受注完了メール送信 */
function sfSendOrderMail($order_id, $template_id, $subject = "", $header = "", $footer = "", $send = true) {
$arrTplVar = new stdClass();
$arrInfo = SC_Helper_DB_Ex::sfGetBasisData();
$arrTplVar->arrInfo = $arrInfo;
$objQuery = new SC_Query_Ex();
if($subject == "" && $header == "" && $footer == "") {
// メールテンプレート情報の取得
$where = "template_id = ?";
$arrRet = $objQuery->select("subject, header, footer", "dtb_mailtemplate", $where, array($template_id));
$arrTplVar->tpl_header = $arrRet[0]['header'];
$arrTplVar->tpl_footer = $arrRet[0]['footer'];
$tmp_subject = $arrRet[0]['subject'];
} else {
$arrTplVar->tpl_header = $header;
$arrTplVar->tpl_footer = $footer;
$tmp_subject = $subject;
}
// 受注情報の取得
$where = "order_id = ?";
$arrRet = $objQuery->select("*", "dtb_order", $where, array($order_id));
$arrOrder = $arrRet[0];
$objQuery->setOrder('order_detail_id');
$arrTplVar->arrOrderDetail = $objQuery->select("*", "dtb_order_detail", $where, array($order_id));
$objProduct = new SC_Product_Ex();
$objQuery->setOrder('shipping_id');
$arrRet = $objQuery->select("*", "dtb_shipping", "order_id = ?", array($order_id));
foreach (array_keys($arrRet) as $key) {
$objQuery->setOrder('shipping_id');
$arrItems = $objQuery->select("*", "dtb_shipment_item", "order_id = ? AND shipping_id = ?",
array($order_id, $arrRet[$key]['shipping_id']));
foreach ($arrItems as $itemKey => $arrDetail) {
foreach ($arrDetail as $detailKey => $detailVal) {
$arrRet[$key]['shipment_item'][$arrDetail['product_class_id']][$detailKey] = $detailVal;
}
$arrRet[$key]['shipment_item'][$arrDetail['product_class_id']]['productsClass'] =& $objProduct->getDetailAndProductsClass($arrDetail['product_class_id']);
}
}
$arrTplVar->arrShipping = $arrRet;
$arrTplVar->Message_tmp = $arrOrder['message'];
// 会員情報の取得
$customer_id = $arrOrder['customer_id'];
$objQuery->setOrder('customer_id');
$arrRet = $objQuery->select('point', "dtb_customer", "customer_id = ?", array($customer_id));
$arrCustomer = isset($arrRet[0]) ? $arrRet[0] : "";
$arrTplVar->arrCustomer = $arrCustomer;
$arrTplVar->arrOrder = $arrOrder;
//その他決済情報
if($arrOrder['memo02'] != "") {
$arrOther = unserialize($arrOrder['memo02']);
foreach($arrOther as $other_key => $other_val){
if(SC_Utils_Ex::sfTrim($other_val['value']) == ""){
$arrOther[$other_key]['value'] = "";
}
}
$arrTplVar->arrOther = $arrOther;
}
// 都道府県変換
$arrTplVar->arrPref = $this->arrPref;
$objCustomer = new SC_Customer_Ex();
$arrTplVar->tpl_user_point = $objCustomer->getValue('point');
if (SC_Display_Ex::detectDevice() == DEVICE_TYPE_MOBILE) {
$objMailView = new SC_MobileView_Ex();
} else {
$objMailView = new SC_SiteView_Ex();
}
// メール本文の取得
$objMailView->assignobj($arrTplVar);
$body = $objMailView->fetch($this->arrMAILTPLPATH[$template_id]);
// メール送信処理
$objSendMail = new SC_SendMail_Ex();
$bcc = $arrInfo['email01'];
$from = $arrInfo['email03'];
$error = $arrInfo['email04'];
$tosubject = $this->sfMakeSubject($tmp_subject, $objMailView);
$objSendMail->setItem('', $tosubject, $body, $from, $arrInfo['shop_name'], $from, $error, $error, $bcc);
$objSendMail->setTo($arrOrder["order_email"], $arrOrder["order_name01"] . " ". $arrOrder["order_name02"] ." 様");
// 送信フラグ:trueの場合は、送信する。
if($send) {
if ($objSendMail->sendMail()) {
$this->sfSaveMailHistory($order_id, $template_id, $tosubject, $body);
}
}
return $objSendMail;
}
// テンプレートを使用したメールの送信
function sfSendTplMail($to, $tmp_subject, $tplpath, &$objPage) {
$objMailView = new SC_SiteView_Ex();
$arrInfo = SC_Helper_DB_Ex::sfGetBasisData();
// メール本文の取得
$objPage->tpl_shopname=$arrInfo['shop_name'];
$objPage->tpl_infoemail = $arrInfo['email02'];
$objMailView->assignobj($objPage);
$body = $objMailView->fetch($tplpath);
// メール送信処理
$objSendMail = new SC_SendMail_Ex();
$bcc = $arrInfo['email01'];
$from = $arrInfo['email03'];
$error = $arrInfo['email04'];
$tosubject = $this->sfMakeSubject($tmp_subject, $objMailView);
$objSendMail->setItem($to, $tosubject, $body, $from, $arrInfo['shop_name'], $from, $error, $error, $bcc);
$objSendMail->sendMail();
}
// 通常のメール送信
function sfSendMail($to, $tmp_subject, $body) {
$arrInfo = SC_Helper_DB_Ex::sfGetBasisData();
// メール送信処理
$objSendMail = new SC_SendMail_Ex();
$bcc = $arrInfo['email01'];
$from = $arrInfo['email03'];
$error = $arrInfo['email04'];
$tosubject = $this->sfMakeSubject($tmp_subject);
$objSendMail->setItem($to, $tosubject, $body, $from, $arrInfo['shop_name'], $from, $error, $error, $bcc);
$objSendMail->sendMail();
}
//件名にテンプレートを用いる
function sfMakeSubject($subject, &$objMailView) {
if (empty($objMailView)) {
$objMailView = new SC_SiteView_Ex();
}
$objTplAssign = new stdClass;
$arrInfo = SC_Helper_DB_Ex::sfGetBasisData();
$objTplAssign->tpl_shopname=$arrInfo['shop_name'];
$objTplAssign->tpl_infoemail=$subject; // 従来互換
$objTplAssign->tpl_mailtitle=$subject;
$objMailView->assignobj($objTplAssign);
$subject = $objMailView->fetch('mail_templates/mail_title.tpl');
return $subject;
}
// メール配信履歴への登録
function sfSaveMailHistory($order_id, $template_id, $subject, $body) {
$sqlval['subject'] = $subject;
$sqlval['order_id'] = $order_id;
$sqlval['template_id'] = $template_id;
$sqlval['send_date'] = 'CURRENT_TIMESTAMP';
if (!isset($_SESSION['member_id'])) $_SESSION['member_id'] = "";
if($_SESSION['member_id'] != "") {
$sqlval['creator_id'] = $_SESSION['member_id'];
} else {
$sqlval['creator_id'] = '0';
}
$sqlval['mail_body'] = $body;
$objQuery = new SC_Query_Ex();
$sqlval['send_id'] = $objQuery->nextVal("dtb_mail_history_send_id");
$objQuery->insert("dtb_mail_history", $sqlval);
}
/* 会員登録があるかどうかのチェック(仮会員を含まない) */
function sfCheckCustomerMailMaga($email) {
$col = "email, mailmaga_flg, customer_id";
$from = "dtb_customer";
$where = "(email = ? OR email_mobile = ?) AND status = 2 AND del_flg = 0";
$objQuery = new SC_Query_Ex();
$arrRet = $objQuery->select($col, $from, $where, array($email));
// 会員のメールアドレスが登録されている
if(!empty($arrRet[0]['customer_id'])) {
return true;
}
return false;
}
/**
* 登録メールを送信する。
*
* @param string $secret_key 会員固有キー
* @param integer $customer_id 顧客ID
* @param boolean $is_mobile false(default):PCアドレスにメールを送る true:携帯アドレスにメールを送る
* @return boolean true:成功 false:失敗
*/
function sfSendRegistMail($secret_key, $customer_id = '', $is_mobile = false) {
// 会員データの取得
if(SC_Utils_Ex::sfIsInt($customer_id)) {
$arrCustomerData = SC_Helper_Customer_Ex::sfGetCustomerDataFromId($customer_id);
}else{
$arrCustomerData = SC_Helper_Customer_Ex::sfGetCustomerDataFromId('', "secret_key = ?", array($secret_key));
}
if(SC_Utils_Ex::isBlank($arrCustomerData)) {
return false;
}
$CONF = SC_Helper_DB_Ex::sfGetBasisData();
$objMailText = new SC_SiteView_Ex();
$objMailText->assign('CONF', $CONF);
$objMailText->assign("name01", $arrCustomerData['name01']);
$objMailText->assign("name02", $arrCustomerData['name02']);
$objMailText->assign('uniqid', $arrCustomerData['secret_key']);
$objMailText->assignobj($arrCustomerData);
$objMailText->assignobj($this);
$objHelperMail = new SC_Helper_Mail_Ex();
// 仮会員が有効の場合
if(CUSTOMER_CONFIRM_MAIL == true and $arrCustomerData['status'] == 1) {
$subject = $objHelperMail->sfMakeSubject('会員登録のご確認', $objMailText);
$toCustomerMail = $objMailText->fetch("mail_templates/customer_mail.tpl");
} else {
$subject = $objHelperMail->sfMakeSubject('会員登録のご完了', $objMailText);
$toCustomerMail = $objMailText->fetch("mail_templates/customer_regist_mail.tpl");
}
$objMail = new SC_SendMail();
$objMail->setItem(
'' // 宛先
, $subject // サブジェクト
, $toCustomerMail // 本文
, $CONF["email03"] // 配送元アドレス
, $CONF["shop_name"] // 配送元名前
, $CONF["email03"] // reply_to
, $CONF["email04"] // return_path
, $CONF["email04"] // Errors_to
, $CONF["email01"] // Bcc
);
// 宛先の設定
if($is_mobile) {
$to_addr = $arrCustomerData["email_mobile"];
}else{
$to_addr = $arrCustomerData['email'];
}
$objMail->setTo($to_addr, $arrCustomerData["name01"] . $arrCustomerData["name02"] ." 様");
$objMail->sendMail();
return true;
}
/**
* 保存されているメルマガテンプレートの取得
* @param integer 特定IDのテンプレートを取り出したい時はtemplate_idを指定。未指定時は全件取得
* @return　array メールテンプレート情報を格納した配列
* @todo 表示順も引数で変更できるように
*/
function sfGetMailmagaTemplate($template_id = null){
// 初期化
$where = '';
$objQuery =& SC_Query_Ex::getSingletonInstance();
// 条件文
$where = 'del_flg = ?';
$arrValues[] = 0;
//template_id指定時
if (SC_Utils_Ex::sfIsInt($template_id) === true) {
$where .= ' AND template_id = ?';
$arrValues[] = $template_id;
}
// 表示順
$objQuery->setOrder("create_date DESC");
$arrResults = $objQuery->select('*', 'dtb_mailmaga_template', $where, $arrValues);
return $arrResults;
}
/**
* 保存されているメルマガ送信履歴の取得
* @param integer 特定の送信履歴を取り出したい時はsend_idを指定。未指定時は全件取得
* @return　array 送信履歴情報を格納した配列
*/
function sfGetSendHistory($send_id = null){
// 初期化
$where = '';
$objQuery =& SC_Query_Ex::getSingletonInstance();
// 条件文
$where = 'del_flg = ?';
$arrValues[] = 0;
//send_id指定時
if (SC_Utils_Ex::sfIsInt($send_id) === true) {
$where .= ' AND send_id = ?';
$arrValues[] = $send_id;
}
// 表示順
$objQuery->setOrder("create_date DESC");
$arrResults = $objQuery->select('*', 'dtb_send_history', $where, $arrValues);
return $arrResults;
}
/**
* 指定したIDのメルマガ配送を行う
*
* @param integer $send_id dtb_send_history の情報
* @return　void
*/
function sfSendMailmagazine($send_id) {
$objQuery =& SC_Query_Ex::getSingletonInstance();
$objDb = new SC_Helper_DB_Ex();
$objSite = $objDb->sfGetBasisData();
$objMail = new SC_SendMail_Ex();
$where = 'del_flg = 0 AND send_id = ?';
$arrMail = $objQuery->getRow('*', 'dtb_send_history', $where, array($send_id));
// 対象となる$send_idが見つからない
if (SC_Utils_Ex::isBlank($arrMail)) return;
// 送信先リストの取得
$arrDestinationList = $objQuery->select(
'*',
'dtb_send_customer',
'send_id = ? AND (send_flag = 2 OR send_flag IS NULL)',
array($send_id)
);
// 現在の配信数
$complete_count = $arrMail['complete_count'];
if(SC_Utils_Ex::isBlank($arrMail)) $complete_count = 0;
foreach ($arrDestinationList as $arrDestination) {
// お名前の変換
$customerName = trim($arrDestination['name']);
$subjectBody = preg_replace("/{name}/", $customerName, $arrMail['subject']);
$mailBody = preg_replace("/{name}/", $customerName, $arrMail['body']);
$objMail->setItem(
$arrDestination['email'],
$subjectBody,
$mailBody,
$objSite["email03"], // 送信元メールアドレス
$objSite["shop_name"], // 送信元名
$objSite["email03"], // reply_to
$objSite["email04"], // return_path
$objSite["email04"] // errors_to
);
// テキストメール配信の場合
if ($arrMail["mail_method"] == 2) {
$sendResut = $objMail->sendMail();
// HTMLメール配信の場合
} else {
$sendResut = $objMail->sendHtmlMail();
}
// 送信完了なら1、失敗なら2をメール送信結果フラグとしてDBに挿入
if (!$sendResut) {
$sendFlag = '2';
} else {
// 完了を 1 増やす
$sendFlag = '1';
$complete_count++;
}
// 送信結果情報を更新
$objQuery->update('dtb_send_customer',
array('send_flag'=>$sendFlag),
'send_id = ? AND customer_id = ?',
array($send_id,$arrDestination["customer_id"]));
}
// メール全件送信完了後の処理
$objQuery->update('dtb_send_history',
array('end_date'=>'CURRENT_TIMESTAMP', 'complete_count'=>$complete_count),
'send_id = ?',
array($send_id));
// 送信完了　報告メール
$compSubject = date("Y年m月d日H時i分") . " 下記メールの配信が完了しました。";
// 管理者宛に変更
$objMail->setTo($objSite["email03"]);
$objMail->setSubject($compSubject);
// テキストメール配信の場合
if ($arrMail["mail_method"] == 2 ) {
$sendResut = $objMail->sendMail();
// HTMLメール配信の場合
} else {
$sendResut = $objMail->sendHtmlMail();
}
return;
}
}
?>

Source for file SC_Helper_Mail.php