function sfRegistTmpMailData($mail_flag, $email) { $objQuery = new SC_Query(); $objConn = new SC_DBConn(); $objPage = new LC_Page(); $random_id = sfGetUniqRandomId(); $arrRegistMailMagazine["mail_flag"] = $mail_flag; $arrRegistMailMagazine["email"] = $email; $arrRegistMailMagazine["temp_id"] = $random_id; $arrRegistMailMagazine["end_flag"] = '0'; $arrRegistMailMagazine["update_date"] = 'now()'; //メルマガ仮登録用フラグ $flag = $objQuery->count("dtb_customer_mail_temp", "email=?", array($email)); $objConn->query("BEGIN"); switch ($flag) { case '0': $objConn->autoExecute("dtb_customer_mail_temp", $arrRegistMailMagazine); break; case '1': $objConn->autoExecute("dtb_customer_mail_temp", $arrRegistMailMagazine, "email = " . SC_Utils::sfQuoteSmart($email)); break; } $objConn->query("COMMIT"); $subject = sfMakeSubject('メルマガ仮登録が完了しました。'); $objPage->tpl_url = SSL_URL . "mailmagazine/regist.php?temp_id=" . $arrRegistMailMagazine['temp_id']; switch ($mail_flag) { case '1': $objPage->tpl_name = "登録"; $objPage->tpl_kindname = "HTML"; break; case '2': $objPage->tpl_name = "登録"; $objPage->tpl_kindname = "テキスト"; break; case '3': $objPage->tpl_name = "解除"; break; } $objPage->tpl_email = $email; sfSendTplMail($email, $subject, 'mail_templates/mailmagazine_temp.tpl', $objPage); }