source: branches/comu-euc/html/admin/basis/mail_edit.php @ 16803

<?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_edit.tpl";
        $this->tpl_subnavi = "basis/subnavi.tpl";
        $this->tpl_mainno = "basis";
        $this->tpl_subno = "mail";
        $this->tpl_subtitle = "¥á¡¼¥ëÀßÄê";
    }
}

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

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

$objPage->arrMailTEMPLATE = $arrMAILTEMPLATE;
$objPage->arrSendType = $arrMailType;

// ÊÔ½¸/¿·µ¬
if ($_POST['mode'] == "edit") {
    if (sfCheckNumLength($_POST['template_id']) === true) {
        $result = $objQuery->select("*", "dtb_mailtemplate", "template_id = ?", array($_POST['template_id']));
        if ($result) {
            $objPage->arrForm = $result[0];
        } else {
            $objPage->arrForm['template_id'] = $_POST['template_id'];
        }
    } else {
        $objPage->arrForm['template_id'] = 0;
    }

// ÅÐÏ¿
} elseif ($_POST['mode'] == "regist" && sfCheckNumLength($_POST['template_id']) === true) {
    // POST¥Ç¡¼¥¿¤Î°ú¤­·Ñ¤®
    $objPage->arrForm = lfConvertParam($_POST);
    $objPage->arrErr = fnErrorCheck($objPage->arrForm);
    // ¥¨¥é¡¼
    if ($objPage->arrErr) {
        $objPage->tpl_msg = "¥¨¥é¡¼¤¬È¯À¸¤·¤Þ¤·¤¿";
    // Àµ¾ï
    } else {
        lfRegist($objQuery, $objPage->arrForm, $_POST['template_id']);
        sfReload("mode=complete");
    }

// ´°Î»
} elseif ($_GET['mode'] == 'complete') {
    $objPage->tpl_mainpage = "basis/mail_complete.tpl";
}

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

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

function lfRegist($objQuery, $arrVal, $id) {
    $sqlval['template_name'] = $arrVal['template_name'];
    $sqlval['subject'] = $arrVal['subject'];
    $sqlval['creator_id'] = $_SESSION['member_id'];
    $sqlval['body'] = $arrVal['body'];
    $sqlval['send_type'] = $arrVal['send_type'];
    $sqlval['update_date'] = "now()";
    
    $result = $objQuery->count("dtb_mailtemplate", "template_id=?", array($id));
    if ($result > 0) {
        $objQuery->update("dtb_mailtemplate", $sqlval, "template_id=?", array($id));
    } else {
        $sqlval['create_date'] = "now()";
        $objQuery->insert("dtb_mailtemplate", $sqlval);
    }
}

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

/* ÆþÎÏ¥¨¥é¡¼¤Î¥Á¥§¥Ã¥¯ */
function fnErrorCheck($array) {
    $objErr = new SC_CheckError($array);
    $objErr->doFunc(array("¥á¡¼¥ë¤Î¼ïÎà",'send_type'), array("EXIST_CHECK"));
    $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("¥á¡¼¥ë¤ÎÆâÍÆ",'body',LTEXT_LEN,"BIG"), array("MAX_LENGTH_CHECK","EXIST_CHECK"));
    
    return $objErr->arrErr;
}

?>