source: temp/trunk/html/admin/basis/kiyaku.php @ 5162

<?php

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

class LC_Page {
    var $arrSession;
    function LC_Page() {
        $this->tpl_mainpage = 'basis/kiyaku.tpl';
        $this->tpl_subnavi = 'basis/subnavi.tpl';
        $this->tpl_subno = 'kiyaku';
        $this->tpl_subtitle = '²ñ°÷µ¬ÌóÅÐÏ¿';
        $this->tpl_mainno = 'basis';
    }
}

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

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

// Í×µáȽÄê
switch($_POST['mode']) {
// ÊÔ½¸½èÍý
case 'edit':
    // POSTÃͤΰú¤­·Ñ¤®
    $objPage->arrForm = $_POST;
    // ÆþÎÏʸ»ú¤ÎÊÑ´¹
    $objPage->arrForm = lfConvertParam($objPage->arrForm);
    
    // ¥¨¥é¡¼¥Á¥§¥Ã¥¯
    $objPage->arrErr = lfErrorCheck();
    if(count($objPage->arrErr) <= 0) {
        if($_POST['kiyaku_id'] == "") {
            lfInsertClass($objPage->arrForm);   // ¿·µ¬ºîÀ®
        } else {
            lfUpdateClass($objPage->arrForm);   // ´û¸ÊÔ½¸
        }
        // ºÆɽ¼¨
        sfReload();
    } else {
        // POST¥Ç¡¼¥¿¤ò°ú¤­·Ñ¤°
        $objPage->tpl_kiyaku_id = $_POST['kiyaku_id'];
    }
    break;
// ºï½ü
case 'delete':
    sfDeleteRankRecord("dtb_kiyaku", "kiyaku_id", $_POST['kiyaku_id'], "", true);
    // ºÆɽ¼¨
    sfReload();
    break;
// ÊÔ½¸Á°½èÍý
case 'pre_edit':
    // ÊÔ½¸¹àÌܤòDB¤è¤ê¼èÆÀ¤¹¤ë¡£
    $where = "kiyaku_id = ?";
    $arrRet = $objQuery->select("kiyaku_text, kiyaku_title", "dtb_kiyaku", $where, array($_POST['kiyaku_id']));
    // ÆþÎϹàÌܤ˥«¥Æ¥´¥ê̾¤òÆþÎϤ¹¤ë¡£
    $objPage->arrForm['kiyaku_title'] = $arrRet[0]['kiyaku_title'];
    $objPage->arrForm['kiyaku_text'] = $arrRet[0]['kiyaku_text'];
    // POST¥Ç¡¼¥¿¤ò°ú¤­·Ñ¤°
    $objPage->tpl_kiyaku_id = $_POST['kiyaku_id'];
break;
case 'down':
    sfRankDown("dtb_kiyaku", "kiyaku_id", $_POST['kiyaku_id']);
    // ºÆɽ¼¨
    sfReload();
    break;
case 'up':
    sfRankUp("dtb_kiyaku", "kiyaku_id", $_POST['kiyaku_id']);
    // ºÆɽ¼¨
    sfReload();
    break;
default:
    break;
}

// µ¬³Ê¤ÎÆɹþ
$where = "del_flg <> 1";
$objQuery->setorder("rank DESC");
$objPage->arrKiyaku = $objQuery->select("kiyaku_title, kiyaku_text, kiyaku_id", "dtb_kiyaku", $where);

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

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

/* DB¤Ø¤ÎÁÞÆþ */
function lfInsertClass($arrData) {
    $objQuery = new SC_Query();
    // INSERT¤¹¤ëÃͤòºîÀ®¤¹¤ë¡£
    $sqlval['kiyaku_title'] = $arrData['kiyaku_title'];
    $sqlval['kiyaku_text'] = $arrData['kiyaku_text'];
    $sqlval['creator_id'] = $_SESSION['member_id'];
    $sqlval['rank'] = $objQuery->max("dtb_kiyaku", "rank") + 1;
    $sqlval['update_date'] = "Now()";
    $sqlval['create_date'] = "Now()";
    // INSERT¤Î¼Â¹Ô
    $ret = $objQuery->insert("dtb_kiyaku", $sqlval);
    return $ret;
}

/* DB¤Ø¤Î¹¹¿· */
function lfUpdateClass($arrData) {
    $objQuery = new SC_Query();
    // UPDATE¤¹¤ëÃͤòºîÀ®¤¹¤ë¡£
    $sqlval['kiyaku_title'] = $arrData['kiyaku_title'];
    $sqlval['kiyaku_text'] = $arrData['kiyaku_text'];
    $sqlval['update_date'] = "Now()";
    $where = "kiyaku_id = ?";
    // UPDATE¤Î¼Â¹Ô
    $ret = $objQuery->update("dtb_kiyaku", $sqlval, $where, array($_POST['kiyaku_id']));
    return $ret;
}

/* ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ */
function lfConvertParam($array) {
    // ʸ»úÊÑ´¹
    $arrConvList['kiyaku_title'] = "KVa";
    $arrConvList['kiyaku_text'] = "KVa";

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

/* ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯ */
function lfErrorCheck() {
    $objErr = new SC_CheckError();
    $objErr->doFunc(array("µ¬Ì󥿥¤¥È¥ë", "kiyaku_title", SMTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
    $objErr->doFunc(array("µ¬ÌóÆâÍÆ", "kiyaku_text", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
    if(!isset($objErr->arrErr['name'])) {
        $objQuery = new SC_Query();
        $arrRet = $objQuery->select("kiyaku_id, kiyaku_title", "dtb_kiyaku", "del_flg = 0 AND kiyaku_title = ?", array($_POST['kiyaku_title']));
        // ÊÔ½¸Ãæ¤Î¥ì¥³¡¼¥É°Ê³°¤ËƱ¤¸Ì¾¾Î¤¬Â¸ºß¤¹¤ë¾ì¹ç     
        if ($arrRet[0]['kiyaku_id'] != $_POST['kiyaku_id'] && $arrRet[0]['kiyaku_title'] == $_POST['kiyaku_title']) {
            $objErr->arrErr['name'] = "¢¨ ´û¤ËƱ¤¸ÆâÍƤÎÅÐÏ¿¤¬Â¸ºß¤·¤Þ¤¹¡£<br>";
        }
    }
    return $objErr->arrErr;
}
?>