source: branches/dev/html/admin/basis/template_input.php @ 13716

<?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 $site_info;
    var $objDate;
    var $arrForm;
    var $mode;
    var $arrMagazineType;
    var $title;
    
    function LC_Page() {
        $this->tpl_mainpage = 'basis/mail.tpl';
        $this->tpl_mainno = 'basis';
        $this->tpl_subnavi = 'basis/subnavi.tpl';
        $this->tpl_subno = "template";
    }
}

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

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

$objPage->arrSendType = array("¥Ñ¥½¥³¥ó","·ÈÂÓ");
$objPage->mode = "regist";

// id¤¬»ØÄꤵ¤ì¤Æ¤¤¤ë¤È¤­¤Ï¡ÖÊÔ½¸¡×ɽ¼¨
if ( $_REQUEST['template_id'] ){
    $objPage->title = "ÊÔ½¸";
} else {
    $objPage->title = "¿·µ¬ÅÐÏ¿";
}

// ¥â¡¼¥É¤Ë¤è¤ë½èÍýʬ´ô
if ( $_GET['mode'] == 'edit' && sfCheckNumLength($_GET['template_id'])===true ){
    
    // ÊÔ½¸
    $sql = "SELECT * FROM dtb_templates WHERE template_id = ? AND delete_flag = 0";
    $result = $conn->getAll($sql, array($_GET['template_id']));
    $objPage->arrForm = $result[0];
    
    //print_r($result[0]);exit;
    
        
} elseif ( $_POST['mode'] == 'regist' ) {
    
    // ¿·µ¬ÅÐÏ¿
    $objPage->arrForm = lfConvData( $_POST );
    $objPage->arrErr = lfErrorCheck($objPage->arrForm);
    
    if ( ! $objPage->arrErr ){
        // ¥¨¥é¡¼¤¬Ìµ¤¤¤È¤­¤ÏÅÐÏ¿¡¦ÊÔ½¸
        lfRegistData( $objPage->arrForm, $_POST['template_id']);    
        sfReload("mode=complete");  // ¼«Ê¬¤òºÆÆɹþ¤·¤Æ¡¢´°Î»²èÌ̤ØÁ«°Ü
    }
    
} elseif ( $_GET['mode'] == 'complete' ) {      
    
    // ´°Î»²èÌÌɽ¼¨
    $objPage->tpl_mainpage = 'basis/template_complete.tpl';
    
} 






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


function lfRegistData( $arrVal, $id = null ){
    
    $query = new SC_Query();
    
    $sqlval['template_name'] = $arrVal['template_name'];
    $sqlval['subject'] = $arrVal['subject'];
    $sqlval['mail_method'] = $arrVal['mail_method'];
    $sqlval['creator_id'] = $_SESSION['member_id'];
    $sqlval['header'] = $arrVal['header'];
    $sqlval['footer'] = $arrVal['footer'];
    $sqlval['update_date'] = "now()";

    if ( $id ){
        $query->update("dtb_mailtemplate", $sqlval, "template_id=".$id );
    } else {
        $sqlval['create_date'] = "now()";
        $query->insert("dtb_mailtemplate", $sqlval);
    }
}

function lfConvData( $data ){
    
     // ʸ»úÎó¤ÎÊÑ´¹¡Êmb_convert_kana¤ÎÊÑ´¹¥ª¥×¥·¥ç¥ó¡Ë                         
    $arrFlag = array(
                      "template_name" => "KV"
                     ,"subject" => "KV"
                     ,"body" => "KV"
                    );
        
    if ( is_array($data) ){
        foreach ($arrFlag as $key=>$line) {
            $data[$key] = mb_convert_kana($data[$key], $line);
        }
    }

    return $data;
}

// ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯
function lfErrorCheck() {
    $objErr = new SC_CheckError();
    
    $objErr->doFunc(array("¥á¡¼¥ë·Á¼°", "send_type"), array("EXIST_CHECK", "ALNUM_CHECK"));
    $objErr->doFunc(array("¥Æ¥ó¥×¥ì¡¼¥È", "template_name"), array("EXIST_CHECK", "ALNUM_CHECK"));
    $objErr->doFunc(array("Subject", "subject", STEXT_LEN), array("EXIST_CHECK","MAX_LENGTH_CHECK"));
    $objErr->doFunc(array("¥Ø¥Ã¥À¡¼", 'header', LLTEXT_LEN), array("EXIST_CHECK","MAX_LENGTH_CHECK"));
    $objErr->doFunc(array("¥Õ¥Ã¥¿¡¼", 'header', LLTEXT_LEN), array("EXIST_CHECK","MAX_LENGTH_CHECK"));

    return $objErr->arrErr;
}



?>