- Timestamp:
- 2012/02/11 05:48:00 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/helper/SC_Helper_Mail.php
r21479 r21481 39 39 function SC_Helper_Mail() { 40 40 $masterData = new SC_DB_MasterData_Ex(); 41 $this->arrMAILTPLPATH = $masterData->getMasterData( "mtb_mail_tpl_path");41 $this->arrMAILTPLPATH = $masterData->getMasterData('mtb_mail_tpl_path'); 42 42 $this->arrPref = $masterData->getMasterData('mtb_pref'); 43 43 } … … 49 49 // メールテンプレート情報の取得 50 50 $where = "template_id = ?"; 51 $arrRet = $objQuery->select("subject, header, footer", "dtb_mailtemplate", $where, array($template_id));51 $arrRet = $objQuery->select("subject, header, footer", 'dtb_mailtemplate', $where, array($template_id)); 52 52 $objPage->tpl_header = $arrRet[0]['header']; 53 53 $objPage->tpl_footer = $arrRet[0]['footer']; … … 86 86 // メールテンプレート情報の取得 87 87 $where = "template_id = ?"; 88 $arrRet = $objQuery->select("subject, header, footer", "dtb_mailtemplate", $where, array($template_id));88 $arrRet = $objQuery->select("subject, header, footer", 'dtb_mailtemplate', $where, array($template_id)); 89 89 $arrTplVar->tpl_header = $arrRet[0]['header']; 90 90 $arrTplVar->tpl_footer = $arrRet[0]['footer']; … … 98 98 // 受注情報の取得 99 99 $where = "order_id = ?"; 100 $arrRet = $objQuery->select("*", "dtb_order", $where, array($order_id));100 $arrRet = $objQuery->select("*", 'dtb_order', $where, array($order_id)); 101 101 $arrOrder = $arrRet[0]; 102 102 $objQuery->setOrder('order_detail_id'); 103 $arrTplVar->arrOrderDetail = $objQuery->select("*", "dtb_order_detail", $where, array($order_id));103 $arrTplVar->arrOrderDetail = $objQuery->select("*", 'dtb_order_detail', $where, array($order_id)); 104 104 105 105 $objProduct = new SC_Product_Ex(); 106 106 $objQuery->setOrder('shipping_id'); 107 $arrRet = $objQuery->select("*", "dtb_shipping", "order_id = ?", array($order_id));107 $arrRet = $objQuery->select("*", 'dtb_shipping', "order_id = ?", array($order_id)); 108 108 foreach (array_keys($arrRet) as $key) { 109 109 $objQuery->setOrder('shipping_id'); 110 $arrItems = $objQuery->select("*", "dtb_shipment_item", "order_id = ? AND shipping_id = ?",110 $arrItems = $objQuery->select("*", 'dtb_shipment_item', "order_id = ? AND shipping_id = ?", 111 111 array($order_id, $arrRet[$key]['shipping_id'])); 112 112 foreach ($arrItems as $itemKey => $arrDetail) { … … 125 125 $customer_id = $arrOrder['customer_id']; 126 126 $objQuery->setOrder('customer_id'); 127 $arrRet = $objQuery->select('point', "dtb_customer", "customer_id = ?", array($customer_id));127 $arrRet = $objQuery->select('point', 'dtb_customer', "customer_id = ?", array($customer_id)); 128 128 $arrCustomer = isset($arrRet[0]) ? $arrRet[0] : ""; 129 129 … … 167 167 168 168 $objSendMail->setItem('', $tosubject, $body, $from, $arrInfo['shop_name'], $from, $error, $error, $bcc); 169 $objSendMail->setTo($arrOrder[ "order_email"], $arrOrder["order_name01"] . " ". $arrOrder["order_name02"] ." 様");169 $objSendMail->setTo($arrOrder['order_email'], $arrOrder['order_name01'] . " ". $arrOrder['order_name02'] ." 様"); 170 170 171 171 // 送信フラグ:trueの場合は、送信する。 … … 244 244 245 245 $objQuery = new SC_Query_Ex(); 246 $sqlval['send_id'] = $objQuery->nextVal( "dtb_mail_history_send_id");247 $objQuery->insert( "dtb_mail_history", $sqlval);246 $sqlval['send_id'] = $objQuery->nextVal('dtb_mail_history_send_id'); 247 $objQuery->insert('dtb_mail_history', $sqlval); 248 248 } 249 249 … … 251 251 function sfCheckCustomerMailMaga($email) { 252 252 $col = "email, mailmaga_flg, customer_id"; 253 $from = "dtb_customer";253 $from = 'dtb_customer'; 254 254 $where = "(email = ? OR email_mobile = ?) AND status = 2 AND del_flg = 0"; 255 255 $objQuery = new SC_Query_Ex(); … … 285 285 $objMailText = new SC_SiteView_Ex(); 286 286 $objMailText->assign('CONF', $CONF); 287 $objMailText->assign( "name01", $arrCustomerData['name01']);288 $objMailText->assign( "name02", $arrCustomerData['name02']);287 $objMailText->assign('name01', $arrCustomerData['name01']); 288 $objMailText->assign('name02', $arrCustomerData['name02']); 289 289 $objMailText->assign('uniqid', $arrCustomerData['secret_key']); 290 290 $objMailText->assignobj($arrCustomerData); … … 307 307 , $subject // サブジェクト 308 308 , $toCustomerMail // 本文 309 , $CONF[ "email03"] // 配送元アドレス310 , $CONF[ "shop_name"] // 配送元 名前311 , $CONF[ "email03"] // reply_to312 , $CONF[ "email04"] // return_path313 , $CONF[ "email04"] // Errors_to314 , $CONF[ "email01"] // Bcc309 , $CONF['email03'] // 配送元アドレス 310 , $CONF['shop_name'] // 配送元 名前 311 , $CONF['email03'] // reply_to 312 , $CONF['email04'] // return_path 313 , $CONF['email04'] // Errors_to 314 , $CONF['email01'] // Bcc 315 315 ); 316 316 // 宛先の設定 317 317 if ($is_mobile) { 318 $to_addr = $arrCustomerData[ "email_mobile"];318 $to_addr = $arrCustomerData['email_mobile']; 319 319 } else { 320 320 $to_addr = $arrCustomerData['email']; 321 321 } 322 $objMail->setTo($to_addr, $arrCustomerData[ "name01"] . $arrCustomerData["name02"] ." 様");322 $objMail->setTo($to_addr, $arrCustomerData['name01'] . $arrCustomerData['name02'] ." 様"); 323 323 324 324 $objMail->sendMail(); … … 421 421 $subjectBody, 422 422 $mailBody, 423 $objSite[ "email03"], // 送信元メールアドレス424 $objSite[ "shop_name"], // 送信元名425 $objSite[ "email03"], // reply_to426 $objSite[ "email04"], // return_path427 $objSite[ "email04"] // errors_to423 $objSite['email03'], // 送信元メールアドレス 424 $objSite['shop_name'], // 送信元名 425 $objSite['email03'], // reply_to 426 $objSite['email04'], // return_path 427 $objSite['email04'] // errors_to 428 428 ); 429 429 430 430 // テキストメール配信の場合 431 if ($arrMail[ "mail_method"] == 2) {431 if ($arrMail['mail_method'] == 2) { 432 432 $sendResut = $objMail->sendMail(); 433 433 // HTMLメール配信の場合 … … 449 449 array('send_flag'=>$sendFlag), 450 450 'send_id = ? AND customer_id = ?', 451 array($send_id,$arrDestination[ "customer_id"]));451 array($send_id,$arrDestination['customer_id'])); 452 452 } 453 453 … … 461 461 $compSubject = date("Y年m月d日H時i分") . " 下記メールの配信が完了しました。"; 462 462 // 管理者宛に変更 463 $objMail->setTo($objSite[ "email03"]);463 $objMail->setTo($objSite['email03']); 464 464 $objMail->setSubject($compSubject); 465 465 466 466 // テキストメール配信の場合 467 if ($arrMail[ "mail_method"] == 2) {467 if ($arrMail['mail_method'] == 2) { 468 468 $sendResut = $objMail->sendMail(); 469 469 // HTMLメール配信の場合
Note: See TracChangeset
for help on using the changeset viewer.
