source: temp/trunk/html/admin/basis/seo.php @ 1975

<?php

require_once("../../require.php");
require_once(ROOT_DIR."data/include/page_layout.inc");

class LC_Page {
    var $arrSession;
    var $tpl_mode;
    function LC_Page() {
        $this->tpl_mainpage = 'basis/seo.tpl';
        $this->tpl_subnavi = 'basis/subnavi.tpl';
        $this->tpl_subno = 'seo';
        $this->tpl_mainno = 'basis';
        $this->tpl_subtitle = 'SEO´ÉÍý';
        global $arrPref;
        $this->arrPref = $arrPref;
        global $arrTAXRULE;
        $this->arrTAXRULE = $arrTAXRULE;
        
    }
}


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

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

// ¥Ç¡¼¥¿¤Î¼èÆÀ
$arrPageData = lfgetPageData(" edit_flg = 2 ");
$objPage->arrPageData = $arrPageData;

$page_id = $_POST['page_id'];

if($_POST['mode'] == "confirm") {
    
    $arrPOST = lfConvertParam($_POST);
    
    sfprintr($arrPOST);
    
    // ¥¨¥é¡¼¥Á¥§¥Ã¥¯
    $objPage->arrErr[$page_id] = lfErrorCheck($arrPOST['meta'][$page_id]);
    
    // ¥¨¥é¡¼¤¬¤Ê¤±¤ì¤Ð¥Ç¡¼¥¿¤ò¹¹¿·
    if(count($objPage->arrErr[$page_id]) == 0) {
        // ¹¹¿·¥Ç¡¼¥¿ÇÛÎóÀ¸À®
        $arrUpdData = array($arrPOST['meta'][$page_id]['author'], $arrPOST['meta'][$page_id]['description'], $arrPOST['meta'][$page_id]['keyword'], $page_id);
        // ¥Ç¡¼¥¿¹¹¿·
        lfUpdPageData($arrUpdData);
    }else{  
        // POST¤Î¥Ç¡¼¥¿¤òºÆɽ¼¨
        $arrPageData = lfSetData($arrPageData, $arrPOST['meta']);
        $objPage->arrPageData = $arrPageData;
    }
}

// ¥¨¥é¡¼¤¬¤Ê¤±¤ì¤Ð¥Ç¡¼¥¿¤Î¼èÆÀ
if(count($objPage->arrErr[$page_id]) == 0) {
    // ¥Ç¡¼¥¿¤Î¼èÆÀ
    $arrPageData = lfgetPageData(" edit_flg = 2 ");
    $objPage->arrPageData = $arrPageData;
}

// ɽ¼¨Ž¥Èóɽ¼¨ÀÚ¤êÂؤ¨
$arrDisp_flg = array();
foreach($arrPageData as $key => $val){
    $arrDisp_flg[$val['page_id']] = $_POST['disp_flg'.$val['page_id']];
}

$objPage->disp_flg = $arrDisp_flg;

$objView->assignobj($objPage);
$objView->display(MAIN_FRAME);
//--------------------------------------------------------------------------------------------------------------------------------------
/**************************************************************************************************************
 * ´Ø¿ô̾   ¡§lfUpdPageData
 * ½èÍýÆâÍÆ ¡§¥Ú¡¼¥¸¥ì¥¤¥¢¥¦¥È¥Æ¡¼¥Ö¥ë¤Ë¥Ç¡¼¥¿¹¹¿·¤ò¹Ô¤¦
 * °ú¿ô     ¡§¹¹¿·¥Ç¡¼¥¿
 * Ìá¤êÃÍ   ¡§¹¹¿··ë²Ì
 **************************************************************************************************************/
function lfUpdPageData($arrUpdData = array()){
    $objQuery = new SC_Query();
    $sql = "";

    // SQLÀ¸À®
    $sql .= " UPDATE ";
    $sql .= "     dtb_pagelayout ";
    $sql .= " SET ";
    $sql .= "     author = ? , ";
    $sql .= "     description = ? , ";
    $sql .= "     keyword = ? ";
    $sql .= " WHERE ";
    $sql .= "     page_id = ? ";
    $sql .= " ";

    // SQL¼Â¹Ô
    $ret = $objQuery->query($sql, $arrUpdData);
    
    return $ret;    
}

/**************************************************************************************************************
 * ´Ø¿ô̾   ¡§lfErrorCheck
 * ½èÍýÆâÍÆ ¡§ÆþÎϹàÌܤΥ¨¥é¡¼¥Á¥§¥Ã¥¯¤ò¹Ô¤¦
 * °ú¿ô     ¡§¥¨¥é¡¼¥Á¥§¥Ã¥¯Âоݥǡ¼¥¿
 * Ìá¤êÃÍ   ¡§¥¨¥é¡¼ÆâÍÆ
 **************************************************************************************************************/
function lfErrorCheck($array) {
    $objErr = new SC_CheckError($array);
    
    $objErr->doFunc(array("¥á¥¿¥¿¥°:Author", "author", STEXT_LEN), array("MAX_LENGTH_CHECK"));
    $objErr->doFunc(array("¥á¥¿¥¿¥°:Description", "description", STEXT_LEN), array("MAX_LENGTH_CHECK"));
    $objErr->doFunc(array("¥á¥¿¥¿¥°:Keywords", "keyword", STEXT_LEN), array("MAX_LENGTH_CHECK"));

    return $objErr->arrErr;
}

/**************************************************************************************************************
 * ´Ø¿ô̾   ¡§lfSetData
 * ½èÍýÆâÍÆ ¡§¥Æ¥ó¥×¥ì¡¼¥Èɽ¼¨¥Ç¡¼¥¿¤ËÃͤò¥»¥Ã¥È¤¹¤ë
 * °ú¿ô1    ¡§É½¼¨¸µ¥Ç¡¼¥¿
 * °ú¿ô2    ¡§É½¼¨¥Ç¡¼¥¿
 * Ìá¤êÃÍ   ¡§É½¼¨¥Ç¡¼¥¿
 **************************************************************************************************************/
function lfSetData($arrPageData, $arrDispData){
    
    foreach($arrPageData as $key => $val){
        $page_id = $val['page_id'];
        $arrPageData[$key]['author'] = $arrDispData[$page_id]['author'];
        $arrPageData[$key]['description'] = $arrDispData[$page_id]['description'];
        $arrPageData[$key]['keyword'] = $arrDispData[$page_id]['keyword'];
    }
    
    return $arrPageData;
}

/* ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ */
function lfConvertParam($array) {
    /*
     *  ʸ»úÎó¤ÎÊÑ´¹
     *  K :  ¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹
     *  C :  ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹
     *  V :  ÂùÅÀÉÕ¤­¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹  
     *  n :  ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)¡×¤ËÊÑ´¹
     *  a :  Á´³Ñ±Ñ¿ô»ú¤òȾ³Ñ±Ñ¿ô»ú¤ËÊÑ´¹¤¹¤ë
     */
    // ¿Íʪ´ðËܾðÊó
    
    // ¥¹¥Ý¥Ã¥È¾¦ÉÊ
    $arrConvList['author'] = "KVa";
    $arrConvList['description'] = "KVa";
    $arrConvList['keyword'] = "KVa";

    // ʸ»úÊÑ´¹
    foreach ($arrConvList as $key => $val) {
        // POST¤µ¤ì¤Æ¤­¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£
        if(isset($array[$key])) {
            $array[$key] = mb_convert_kana($array[$key] ,$val);
        }
    }
    return $array;
}


?>