source: closed/dev/html/admin/products/class.php @ 17

<?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;
    function LC_Page() {
        $this->tpl_mainpage = 'products/class.tpl';
        $this->tpl_subnavi = 'products/subnavi.tpl';
        $this->tpl_subno = 'class';
        $this->tpl_subtitle = 'µ¬³ÊÅÐÏ¿';
        $this->tpl_mainno = 'products';
    }
}

$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['class_id'] == "") {
            lfInsertClass($objPage->arrForm);   // ¿·µ¬ºîÀ®
        } else {
            lfUpdateClass($objPage->arrForm);   // ´û¸ÊÔ½¸
        }
        // ºÆɽ¼¨
        sfReload();
    } else {
        // POST¥Ç¡¼¥¿¤ò°ú¤­·Ñ¤°
        $objPage->tpl_class_id = $_POST['class_id'];
    }
    break;
// ºï½ü
case 'delete':
    sfDeleteRankRecord("dtb_class", "class_id", $_POST['class_id'], "", true);
    $objQuery = new SC_Query();
    $objQuery->delete("dtb_classcategory", "class_id = ?", $_POST['class_id']);
    // ºÆɽ¼¨
    sfReload();
    break;
// ÊÔ½¸Á°½èÍý
case 'pre_edit':
    // ÊÔ½¸¹àÌܤòDB¤è¤ê¼èÆÀ¤¹¤ë¡£
    $where = "class_id = ?";
    $class_name = $objQuery->get("dtb_class", "name", $where, array($_POST['class_id']));
    // ÆþÎϹàÌܤ˥«¥Æ¥´¥ê̾¤òÆþÎϤ¹¤ë¡£
    $objPage->arrForm['name'] = $class_name;
    // POST¥Ç¡¼¥¿¤ò°ú¤­·Ñ¤°
    $objPage->tpl_class_id = $_POST['class_id'];
break;
case 'down':
    sfRankDown("dtb_class", "class_id", $_POST['class_id']);
    // ºÆɽ¼¨
    sfReload();
    break;
case 'up':
    sfRankUp("dtb_class", "class_id", $_POST['class_id']);
    // ºÆɽ¼¨
    sfReload();
    break;
default:
    break;
}

// µ¬³Ê¤ÎÆɹþ
$where = "del_flg <> 1";
$objQuery->setorder("rank DESC");
$objPage->arrClass = $objQuery->select("name, class_id", "dtb_class", $where);
$objPage->arrClassCatCount = sfGetClassCatCount();

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

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

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

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

/* ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ */
function lfConvertParam($array) {
    // ʸ»úÊÑ´¹
    $arrConvList['name'] = "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("µ¬³Ê̾", "name", STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
    
    if(!isset($objErr->arrErr['name'])) {
        $objQuery = new SC_Query();
        $arrRet = $objQuery->select("class_id, name", "dtb_class", "del_flg = 0 AND name = ?", array($_POST['name']));
        // ÊÔ½¸Ãæ¤Î¥ì¥³¡¼¥É°Ê³°¤ËƱ¤¸Ì¾¾Î¤¬Â¸ºß¤¹¤ë¾ì¹ç     
        if ($arrRet[0]['class_id'] != $_POST['class_id'] && $arrRet[0]['name'] == $_POST['name']) {
            $objErr->arrErr['name'] = "¢¨ ´û¤ËƱ¤¸ÆâÍƤÎÅÐÏ¿¤¬Â¸ºß¤·¤Þ¤¹¡£<br>";
        }
    }
    return $objErr->arrErr;
}
?>