source: branches/dev/html/admin/basis/mail.php @ 13699

<?php
/*
 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
 *
 * http://www.lockon.co.jp/
 */
require_once("../require.php");

class LC_Page {
    var $arrSession;
    var $tpl_mode;
    function LC_Page() {
        $this->tpl_mainpage = 'basis/mail.tpl';
        $this->tpl_subnavi = 'basis/subnavi.tpl';
        $this->tpl_mainno = 'basis';
        $this->tpl_subno = 'mail';
        $this->tpl_subtitle = '¥á¡¼¥ëÀßÄê';
    }
}

$conn = new SC_DBConn();
$objQuery = new SC_Query();
$objPage = new LC_Page();
$objView = new SC_AdminView();
$objSess = new SC_Session();

//ǧ¾Ú²ÄÈݤÎȽÄê
sfIsSuccess($objSess);

$objPage->arrMailTEMPLATE = $arrMAILTEMPLATE;




if ( $_GET['mode'] == 'edit' && sfCheckNumLength($_GET['template_id'])===true ){
    
    if ( sfCheckNumLength( $_GET['template_id']) ){
        $sql = "SELECT * FROM dtb_mailtemplate WHERE template_id = ?";
        $result = $conn->getAll($sql, array($_GET['template_id']) );
        print_r($result);
        if ( $result ){
            $objPage->arrForm = $result[0];
        } else {
            $objPage->arrForm['template_id'] = $_GET['template_id'];
        }
    }
    
} elseif ( $_GET['mode'] == 'regist' && sfCheckNumLength( $_GET['template_id']) ){

    // POST¥Ç¡¼¥¿¤Î°ú¤­·Ñ¤®
    $objPage->arrForm = lfConvertParam($_GET);
    $objPage->arrErr = fnErrorCheck($objPage->arrForm);
    
    if ( $objPage->arrErr ){
        // ¥¨¥é¡¼¥á¥Ã¥»¡¼¥¸
        $objPage->tpl_msg = "¥¨¥é¡¼¤¬È¯À¸¤·¤Þ¤·¤¿";
        
    } else {
        // Àµ¾ï
        lfRegist($conn, $objPage->arrForm);
        
        // ´°Î»¥á¥Ã¥»¡¼¥¸
        $objPage->tpl_onload = "window.alert('¥á¡¼¥ëÀßÄ꤬´°Î»¤·¤Þ¤·¤¿¡£¥Æ¥ó¥×¥ì¡¼¥È¤òÁªÂò¤·¤ÆÆâÍƤò¤´³Îǧ¤¯¤À¤µ¤¤¡£');";
        unset($objPage->arrForm);
    }
}

$objView->assignobj($objPage);
$objView->display(MAIN_FRAME);

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

function lfRegist( $conn, $data ){
    
    $data['creator_id'] = $_SESSION['member_id'];
    
    $sql = "SELECT * FROM dtb_mailtemplate WHERE template_id = ?";
    $result = $conn->getAll($sql, array($_POST['template_id']) );
    if ( $result ){
        $sql_where = "template_id = ". addslashes($_POST['template_id']);
        $conn->query("UPDATE dtb_mailtemplate SET template_id = ?, template_name = ?,subject = ?,header = ?, footer = ?,creator_id = ?, update_date = now() WHERE ".$sql_where, $data);
    }else{
        $conn->query("INSERT INTO dtb_mailtemplate (template_id,template_name,subject,header,footer,creator_id,update_date,create_date) values ( ?,?,?,?,?,?,now(),now() )", $data);
    }

}


function lfConvertParam($array) {
    
    $new_array["template_id"] = $array["template_id"];
    $new_array["template_name"] = $array["template_name"];
    $new_array["subject"] = mb_convert_kana($array["subject"] ,"KV");
    $new_array["header"] = mb_convert_kana($array["header"] ,"KV");
    $new_array["footer"] = mb_convert_kana($array["footer"] ,"KV");
    
    return $new_array;
}

/* ÆþÎÏ¥¨¥é¡¼¤Î¥Á¥§¥Ã¥¯ */
function fnErrorCheck($array) {
    
    $objErr = new SC_CheckError($array);
    
    $objErr->doFunc(array("¥Æ¥ó¥×¥ì¡¼¥È",'template_id'), array("EXIST_CHECK"));
    $objErr->doFunc(array("¥Æ¥ó¥×¥ì¡¼¥È",'template_name'), array("EXIST_CHECK"));
    $objErr->doFunc(array("¥á¡¼¥ë¥¿¥¤¥È¥ë",'subject',MTEXT_LEN,"BIG"), array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
    $objErr->doFunc(array("¥Ø¥Ã¥À¡¼",'header',LTEXT_LEN,"BIG"), array("MAX_LENGTH_CHECK"));
    $objErr->doFunc(array("¥Õ¥Ã¥¿¡¼",'footer',LTEXT_LEN,"BIG"), array("MAX_LENGTH_CHECK"));

    return $objErr->arrErr;
}

?>