source: temp/branches/mobile/html/mobile/magazine/confirm.php @ 11418

<?php
/**
 * ¥á¥ë¥Þ¥¬³Îǧ
 */

require_once('../require.php');

class LC_Page {
    function LC_Page() {
        /** ɬ¤ºÊѹ¹¤¹¤ë **/
        $this->tpl_mainpage = 'magazine/confirm.tpl';
        $this->tpl_title .= '¥á¥ë¥Þ¥¬³Îǧ';
    }
}

$objPage = new LC_Page();
$objConn = new SC_DbConn();
$objPage->arrForm = $_POST;

// ÅÐÏ¿
if (isset($_REQUEST['btnRegist'])) {
    $objPage->arrErr = lfMailErrorCheck($objPage->arrForm, "regist");

    // ¥¨¥é¡¼¤¬¤Ê¤±¤ì¤Ð
    if (count($objPage->arrErr) == 0) {
        // ³Îǧ
        $objPage->arrForm['kind'] = '¥á¥ë¥Þ¥¬ÅÐÏ¿';
        $objPage->arrForm['type'] = 'regist';
        $objPage->arrForm['mail'] = $objPage->arrForm['regist'];
    } else {
        $objPage->tpl_mainpage = 'magazine/index.tpl';
        $objPage->tpl_title = '¥á¥ë¥Þ¥¬ÅÐÏ¿¡¦²ò½ü';
    }
// ²ò½ü
} elseif (isset($_REQUEST['btnCancel'])) {
    $objPage->arrErr = lfMailErrorCheck($objPage->arrForm, "cancel");

    // ¥¨¥é¡¼¤¬¤Ê¤±¤ì¤Ð
    if (count($objPage->arrErr) == 0) {
        // ³Îǧ
        $objPage->arrForm['kind'] = '¥á¥ë¥Þ¥¬²ò½ü';
        $objPage->arrForm['type'] = 'cancel';
        $objPage->arrForm['mail'] = $objPage->arrForm['cancel'];
    } else {
        $objPage->tpl_mainpage = 'magazine/index.tpl';
        $objPage->tpl_title = '¥á¥ë¥Þ¥¬ÅÐÏ¿¡¦²ò½ü';
    }
// ´°Î»
} elseif ($_REQUEST['mode'] == 'regist' or $_REQUEST['mode'] == 'cancel') {

    //¡¡ÅÐÏ¿
    if ($_REQUEST['mode'] == 'regist') {
        $uniqId = lfRegistData($_POST["email"]);
        $subject = sfMakesubject('¥á¥ë¥Þ¥¬ÅÐÏ¿¤Î¤´³Îǧ');
    //¡¡²ò½ü
    } elseif ($_REQUEST['mode'] == 'cancel') {
        $uniqId = lfGetSecretKey($_POST["email"]);
        $subject = sfMakesubject('¥á¥ë¥Þ¥¬²ò½ü¤Î¤´³Îǧ');
    }
    $CONF = sf_getBasisData();
    $objPage->CONF = $CONF;
    $objPage->tpl_url = gfAddSessionId(SSL_URL . "magazine/" . $_REQUEST['mode'] . ".php?id=" . $uniqId);
    
    $objMailText = new SC_SiteView();
    $objMailText->assignobj($objPage);
    $toCustomerMail = $objMailText->fetch("mail_templates/mailmagazine_" . $_REQUEST['mode'] . ".tpl");
    $objMail = new GC_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
                                                        );
    // °¸Àè¤ÎÀßÄê
    $objMail->setTo($_POST["email"], $_POST["email"]);
    $objMail->sendMail();

    // ´°Î»¥Ú¡¼¥¸¤Ë°ÜÆ°¤µ¤»¤ë¡£
    header("Location:" . gfAddSessionId("./complete.php"));
    exit;
} else {
    sfDispSiteError(CUSTOMER_ERROR);
}

// ¥ì¥¤¥¢¥¦¥È¥Ç¥¶¥¤¥ó¤ò¼èÆÀ
$objPage = sfGetPageLayout($objPage, false, DEF_LAYOUT);

$objView = new SC_SiteView();
$objView->assignobj($objPage);
$objView->display(SITE_FRAME);

//-----------------------------------------------------------------------------------------------------------------------------------


//---- ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯
function lfMailErrorCheck($array, $dataName) {
    $objErr = new SC_CheckError($array);
    $objErr->doFunc(
                array('¥á¡¼¥ë¥¢¥É¥ì¥¹', $dataName, MTEXT_LEN) ,
                array("NO_SPTAB", "EXIST_CHECK", "EMAIL_CHECK", 
                    "SPTAB_CHECK" ,"EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK", "MOBILE_EMAIL_CHECK"));

    // ÆþÎÏ¥¨¥é¡¼¤¬¤Ê¤±¤ì¤Ð
    if (count($objErr->arrErr) == 0) {
        // ¥á¥ë¥Þ¥¬¤ÎÅÐϿ̵ͭ
        $flg = lfIsRegistData($array[$dataName]);

        // ÅÐÏ¿¤Î»þ
        if ($dataName == 'regist' and $flg == true) {
            $objErr->arrErr[$dataName] = "´û¤ËÅÐÏ¿¤µ¤ì¤Æ¤¤¤Þ¤¹¡£<br>";
        // ²ò½ü¤Î»þ
        } elseif ($dataName == 'cancel' and $flg == false) {
            $objErr->arrErr[$dataName] = "¥á¥ë¥Þ¥¬ÅÐÏ¿¤¬¤µ¤ì¤Æ¤¤¤Þ¤»¤ó¡£<br>";
        }
    }

    return $objErr->arrErr;
}


//---- ¥á¥ë¥Þ¥¬ÅÐÏ¿
function lfRegistData ($email) {
    global $objConn;

    $count = 1;
    while ($count != 0) {
        $uniqid = sfGetUniqRandomId("t");
        $count = $objConn->getOne("SELECT COUNT(*) FROM dtb_customer_mail WHERE secret_key = ?", array($uniqid));
    }
    
    $arrRegist["email"] = $email;           // ¥á¡¼¥ë¥¢¥É¥ì¥¹
    $arrRegist["mail_flag"] = 5;            // ÅÐÏ¿¾õÂÖ
    $arrRegist["secret_key"] = $uniqid;     // IDȯ¹Ô
    $arrRegist["create_date"] = "now()";    // ºîÀ®Æü
    $arrRegist["update_date"] = "now()";    // ¹¹¿·Æü

    //-- ²¾ÅÐÏ¿¼Â¹Ô
    $objConn->query("BEGIN");

    $objQuery = new SC_Query();
    $objQuery->insert("dtb_customer_mail", $arrRegist);

    //--¡¡´û¤Ë¥á¥ë¥Þ¥¬ÅÐÏ¿¤·¤Æ¤¤¤ë¤«¤ÎȽÄê
    $sql = "SELECT count(*) FROM dtb_customer_mail WHERE email = ?";
    $mailResult = $objConn->getOne($sql, array($arrRegist["email"]));

    if ($mailResult == 1) {     
        $objQuery->update("dtb_customer_mail", $arrRegist, "email = '" .addslashes($arrRegist["email"]). "'");          
    } else {
        $objQuery->insert("dtb_customer_mail", $arrRegist);     
    }
    $objConn->query("COMMIT");

    return $uniqid;
}

// ÅÐÏ¿¤µ¤ì¤Æ¤¤¤ë¥­¡¼¤Î¼èÆÀ
function lfGetSecretKey ($email) {
    global $objConn;

    $sql = "SELECT secret_key FROM dtb_customer_mail WHERE email = ?";
    return $objConn->getOne($sql, array($email));
}

// ´û¤ËÅÐÏ¿¤µ¤ì¤Æ¤¤¤ë¤«¤É¤¦¤«
function lfIsRegistData ($email) {
    global $objConn;

    $sql = "SELECT email, mail_flag FROM dtb_customer_mail WHERE email = ?";
    $mailResult = $objConn->getRow($sql, array($email));

    // NULL¤â¹ØÆɤȤߤʤ¹
    if (count($mailResult) == 0 or ($mailResult[1] != null and $mailResult[1] <= 2 )) {
        return false;
    } else {
        return true;
    }
}


?>