source: temp/branches/mobile/html/mobile/forgot/index.php @ 11411

<?php
/**
 * ¥â¥Ð¥¤¥ë¥µ¥¤¥È/¥Ñ¥¹¥ï¡¼¥É¤ò˺¤ì¤¿Êý
 */

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

class LC_Page {
    var $errmsg;
    var $arrReminder;
    var $temp_password;

    function LC_Page() {
        $this->tpl_mainpage = 'forgot/index.tpl';
        $this->tpl_title = '¥Ñ¥¹¥ï¡¼¥É¤ò˺¤ì¤¿Êý';
        $this->tpl_mainno = '';
    }
}

$conn = new SC_DBConn();
$objPage = new LC_Page();
$objPage = sfGetPageLayout($objPage, false, DEF_LAYOUT);
$objView = new SC_SiteView();
$objSess = new SC_Session();
$CONF = sf_getBasisData();                  // ŹÊÞ´ðËܾðÊó
// ¥¯¥Ã¥­¡¼´ÉÍý¥¯¥é¥¹
$objCookie = new SC_Cookie(COOKIE_EXPIRE);

if (isset($_SESSION['mobile']['kara_mail_from'])) {
    if (!isset($_POST['mode'])) {
        $_POST['mode'] = 'mail_check';
    }
    $_POST['email'] = $_SESSION['mobile']['kara_mail_from'];
}

if ( $_POST['mode'] == 'mail_check' ){
    //¥á¥¢¥ÉÆþÎÏ»þ
    $_POST['email'] = strtolower($_POST['email']);
    $sql = "SELECT * FROM dtb_customer WHERE (email ILIKE ? OR email_mobile ILIKE ?) AND status = 2 AND del_flg = 0";
    $result = $conn->getAll($sql, array($_POST['email'], $_POST['email']) );
    
    if ( $result[0]['reminder'] ){      // Ëܲñ°÷ÅÐÏ¿ºÑ¤ß¤Î¾ì¹ç
        // ÆþÎÏemail¤¬Â¸ºß¤¹¤ë      
        $_SESSION['forgot']['email'] = $_POST['email'];
        $_SESSION['forgot']['reminder'] = $result[0]['reminder'];
        // ¥Ò¥ß¥Ä¤ÎÅú¤¨ÆþÎϲèÌÌ
        $objPage->Reminder = $arrReminder[$_SESSION['forgot']['reminder']];
        $objPage->tpl_mainpage = 'forgot/secret.tpl';
    } else {
        $sql = "SELECT customer_id FROM dtb_customer WHERE email ILIKE ? AND status = 1 AND del_flg = 0";   //²¾ÅÐÏ¿Ãæ¤Î³Îǧ
        $result = $conn->getAll($sql, array($_POST['email']) );
        if ($result) {
            $objPage->errmsg = "¤´ÆþÎϤÎemail¥¢¥É¥ì¥¹¤Ï¸½ºß²¾ÅÐÏ¿Ãæ¤Ç¤¹¡£<br>ÅÐÏ¿¤ÎºÝ¤Ë¤ªÁ÷¤ê¤·¤¿¥á¡¼¥ë¤ÎURL¤Ë¥¢¥¯¥»¥¹¤·¡¢<br>Ëܲñ°÷ÅÐÏ¿¤ò¤ª´ê¤¤¤·¤Þ¤¹¡£";
        } else {        //¡¡ÅÐÏ¿¤·¤Æ¤¤¤Ê¤¤¾ì¹ç
            $objPage->errmsg = "¤´ÆþÎϤÎemail¥¢¥É¥ì¥¹¤ÏÅÐÏ¿¤µ¤ì¤Æ¤¤¤Þ¤»¤ó";
        }
    }
    
} elseif( $_POST['mode'] == 'secret_check' ){
    //¥Ò¥ß¥Ä¤ÎÅú¤¨ÆþÎÏ»þ
    
    if ( $_SESSION['forgot']['email'] ) {
        // ¥Ò¥ß¥Ä¤ÎÅú¤¨¤Î²óÅú¤¬Àµ¤·¤¤¤«¥Á¥§¥Ã¥¯
        
        $sql = "SELECT * FROM dtb_customer WHERE (email ILIKE ? OR email_mobile ILIKE ?) AND del_flg = 0";
        $result = $conn->getAll($sql, array($_SESSION['forgot']['email'], $_SESSION['forgot']['email']) );
        $data = $result[0];
        
        if ( $data['reminder_answer'] === $_POST['input_reminder'] ){
            // ¥Ò¥ß¥Ä¤ÎÅú¤¨¤¬Àµ¤·¤¤
                        
            // ¿·¤·¤¤¥Ñ¥¹¥ï¡¼¥É¤òÀßÄꤹ¤ë
            $objPage->temp_password = gfMakePassword(8);
                        
            if(FORGOT_MAIL == 1) {
                // ¥á¡¼¥ë¤ÇÊѹ¹ÄÌÃΤò¤¹¤ë
                lfSendMail($CONF, $_SESSION['forgot']['email'], $data['name01'], $objPage->temp_password);
            }
            
            // DB¤ò½ñ¤­´¹¤¨¤ë
            $sql = "UPDATE dtb_customer SET password = ?, update_date = now() WHERE customer_id = ?";
            $conn->query( $sql, array( sha1($objPage->temp_password . ":" . AUTH_MAGIC) ,$data['customer_id']) );
            
            // ´°Î»²èÌ̤Îɽ¼¨
            $objPage->tpl_mainpage = 'forgot/complete.tpl';
            
            // ¥»¥Ã¥·¥ç¥óÊÑ¿ô¤Î²òÊü
            $_SESSION['forgot'] = array();
            unset($_SESSION['forgot']);
            
        } else {
            // ¥Ò¥ß¥Ä¤ÎÅú¤¨¤¬Àµ¤·¤¯¤Ê¤¤
            
            $objPage->Reminder = $arrReminder[$_SESSION['forgot']['reminder']];
            $objPage->errmsg = "¥Ñ¥¹¥ï¡¼¥É¤ò˺¤ì¤¿¤È¤­¤Î¼ÁÌä¤ËÂФ¹¤ë²óÅú¤¬Àµ¤·¤¯¤¢¤ê¤Þ¤»¤ó";
            $objPage->tpl_mainpage = 'forgot/secret.tpl';

        }
    
        
    } else {
        // ¥¢¥¯¥»¥¹¸µ¤¬ÉÔÀµ¤Þ¤¿¤Ï¡¢¥»¥Ã¥·¥ç¥óÊÝ»ý´ü´Ö¤¬ÀÚ¤ì¤Æ¤¤¤ë
        $objPage->errmsg = "email¥¢¥É¥ì¥¹¤òºÆÅÙÅÐÏ¿¤·¤Æ¤¯¤À¤µ¤¤¡£<br />Á°²ó¤ÎÆþÎϤ«¤é»þ´Ö¤¬·Ð¤Ã¤Æ¤¤¤Þ¤¹¤È¡¢ËÜ¥á¥Ã¥»¡¼¥¸¤¬É½¼¨¤µ¤ì¤ë²ÄǽÀ­¤¬¤¢¤ê¤Þ¤¹¡£";
    }
}

// ¥Ç¥Õ¥©¥ë¥ÈÆþÎÏ
if($_POST['email'] != "") {
    // POSTÃͤòÆþÎÏ
    $objPage->tpl_login_email = $_POST['email'];
} else {
    // ¥¯¥Ã¥­¡¼ÃͤòÆþÎÏ
    $objPage->tpl_login_email = $objCookie->getCookie('login_email');
}

// ¶õ¥á¡¼¥ëÍѤΥȡ¼¥¯¥ó¤òºîÀ®¡£
if (MOBILE_USE_KARA_MAIL) {
    $token = gfPrepareKaraMail('forgot/index.php');
    if ($token !== false) {
        $objPage->tpl_kara_mail_to = MOBILE_KARA_MAIL_ADDRESS_USER . MOBILE_KARA_MAIL_ADDRESS_DELIMITER . 'forgot_' . $token . '@' . MOBILE_KARA_MAIL_ADDRESS_DOMAIN;
    }
}

//----¡¡¥Ú¡¼¥¸É½¼¨
$objView->assignobj($objPage);
$objView->display(SITE_FRAME);

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

function lfSendMail($CONF, $email, $customer_name, $temp_password){
    //¡¡¥Ñ¥¹¥ï¡¼¥ÉÊѹ¹¤ªÃΤ餻¥á¡¼¥ëÁ÷¿®
    
    $objPage = new LC_Page();
    $objPage->customer_name = $customer_name;
    $objPage->temp_password = $temp_password;
    $objMailText = new SC_SiteView();
    $objMailText->assignobj($objPage);
    
    $toCustomerMail = $objMailText->fetch("mail_templates/forgot_mail.tpl");
    $objMail = new GC_SendMail();
    
    $objMail->setItem(
                          ''                                //¡¡°¸Àè
                        , "¥Ñ¥¹¥ï¡¼¥É¤¬Êѹ¹¤µ¤ì¤Þ¤·¤¿" ."¡Ú" .$CONF["shop_name"]. "¡Û"      //¡¡¥µ¥Ö¥¸¥§¥¯¥È
                        , $toCustomerMail                   //¡¡ËÜʸ
                        , $CONF["email03"]                  //¡¡ÇÛÁ÷¸µ¥¢¥É¥ì¥¹
                        , $CONF["shop_name"]                //¡¡ÇÛÁ÷¸µ¡¡Ì¾Á°
                        , $CONF["email03"]                  //¡¡reply_to
                        , $CONF["email04"]                  //¡¡return_path
                        , $CONF["email04"]                  //  Errors_to

                                                        );
    $objMail->setTo($email, $customer_name ." ÍÍ");
    $objMail->sendMail();   
    
}


?>