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 registerUpdateLog($arrLog, $objRet)
{
$objQuery = new SC_Query_Ex();
$arrInsert = array('log_id' => $objQuery->nextVal('dtb_module_update_logs_log_id'), 'module_id' => $objRet->product_id, 'buckup_path' => $arrLog['buckup_path'], 'error_flg' => count($arrLog['err']), 'error' => implode("\n", $arrLog['err']), 'ok' => implode("\n", $arrLog['ok']), 'update_date' => 'CURRENT_TIMESTAMP', 'create_date' => 'CURRENT_TIMESTAMP');
$objQuery->insert('dtb_module_update_logs', $arrInsert);
}
/**
* 空メール管理テーブルに新規エントリーを登録し、トークンを返す。
*
* @param string $next_url 空メール受け付け後に遷移させるページ (モバイルサイトトップからの相対URL)
* @param string $session_id セッションID (省略した場合は現在のセッションID)
* @return string|false トークンを返す。エラーが発生した場合はfalseを返す。
*/
function gfPrepareKaraMail($next_url, $session_id = null)
{
if (!isset($session_id)) {
$session_id = session_id();
}
$objQuery = new SC_Query_Ex();
// GC
$time = date('Y-m-d H:i:s', time() - MOBILE_SESSION_LIFETIME);
$objQuery->delete('dtb_mobile_kara_mail', 'email IS NULL AND create_date < ?', array($time));
$objQuery->delete('dtb_mobile_kara_mail', 'session_id = ?', array($session_id));
$arrValues = array('session_id' => $session_id, 'next_url' => $next_url);
$try = 10;
while ($try > 0) {
$arrValues['token'] = $token = $this->lfGenerateKaraMailToken();
$arrValues['kara_mail_id'] = $objQuery->nextVal('dtb_mobile_kara_mail_kara_mail_id');
$objQuery->insert('dtb_mobile_kara_mail', $arrValues);
$count = $objQuery->count('dtb_mobile_kara_mail', 'token = ?', array($token));
if ($count == 1) {
break;
}
$objQuery->delete('dtb_mobile_kara_mail', 'session_id = ?', array($session_id));
$token = false;
--$try;
}
return $token;
}
/**
* 規格を設定していない商品を商品規格テーブルに登録
*
* @param array $arrList
* @return void
*/
function lfInsertDummyProductClass($arrList)
{
$objQuery = new SC_Query_Ex();
$objDb = new SC_Helper_DB_Ex();
$product_id = $arrList['product_id'];
// 配列の添字を定義
$checkArray = array('product_class_id', 'product_id', 'product_code', 'stock', 'stock_unlimited', 'price01', 'price02', 'sale_limit', 'deliv_fee', 'point_rate', 'product_type_id', 'down_filename', 'down_realfilename');
$sqlval = SC_Utils_Ex::sfArrayIntersectKeys($arrList, $checkArray);
$sqlval = SC_Utils_Ex::arrayDefineIndexes($sqlval, $checkArray);
$sqlval['stock_unlimited'] = $sqlval['stock_unlimited'] ? UNLIMITED_FLG_UNLIMITED : UNLIMITED_FLG_LIMITED;
$sqlval['creator_id'] = strlen($_SESSION['member_id']) >= 1 ? $_SESSION['member_id'] : '0';
if (strlen($sqlval['product_class_id']) == 0) {
$sqlval['product_class_id'] = $objQuery->nextVal('dtb_products_class_product_class_id');
$sqlval['create_date'] = 'CURRENT_TIMESTAMP';
$sqlval['update_date'] = 'CURRENT_TIMESTAMP';
// INSERTの実行
$objQuery->insert('dtb_products_class', $sqlval);
} else {
$sqlval['update_date'] = 'CURRENT_TIMESTAMP';
// UPDATEの実行
$objQuery->update('dtb_products_class', $sqlval, "product_class_id = ?", array($sqlval['product_class_id']));
}
}
