function lfRegistData($array, $arrRegistColumn, &$objCustomer)
{
$objConn = new SC_DBConn();
foreach ($arrRegistColumn as $data) {
if (strlen($array[$data["column"]]) > 0) {
$arrRegist[$data["column"]] = $array[$data["column"]];
}
}
$arrRegist['customer_id'] = $objCustomer->getvalue('customer_id');
//-- 編集登録実行
$objConn->query("BEGIN");
if ($array['other_deliv_id'] != "") {
$objConn->autoExecute("dtb_other_deliv", $arrRegist, "other_deliv_id = " . SC_Utils_Ex::sfQuoteSmart($array["other_deliv_id"]));
} else {
$objConn->autoExecute("dtb_other_deliv", $arrRegist);
}
$objConn->query("COMMIT");
}
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);
}
