source: branches/comu/html/admin/products/classcategory.php @ 2

<?php
/*
 * Copyright(c) 2000-2006 LOCKON CO.,LTD. All Rights Reserved.
 *
 * http://www.lockon.co.jp/
 */
require_once("../require.php");

class LC_Page {
    var $arrSession;
    var $arrHidden;
    var $arrForm;
    var $tpl_class_name;
    var $arrClassCat;
    function LC_Page() {
        $this->tpl_mainpage = 'products/classcategory.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();
$objQuery = new SC_Query();

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

$get_check = false;

// µ¬³ÊID¤Î¥Á¥§¥Ã¥¯
if(sfIsInt($_GET['class_id'])) {
    // µ¬³Ê̾¤Î¼èÆÀ
    $objPage->tpl_class_name = $objQuery->get("dtb_class", "name", "class_id = ?", array($_GET['class_id']));
    if($objPage->tpl_class_name != "") {
        // µ¬³ÊID¤Î°ú¤­·Ñ¤®
        $objPage->arrHidden['class_id'] = $_GET['class_id'];
        $get_check = true;
    }
}

if(!$get_check) {
    // µ¬³ÊÅÐÏ¿¥Ú¡¼¥¸¤ËÈô¤Ð¤¹¡£
    header("Location: " . URL_CLASS_REGIST);
    exit;
}

// ¿·µ¬ºîÀ® or ÊÔ½¸
switch($_POST['mode']) {
// ÅÐÏ¿¥Ü¥¿¥ó²¡²¼
case 'edit':
    // POSTÃͤΰú¤­·Ñ¤®
    $objPage->arrForm = $_POST;
    // ÆþÎÏʸ»ú¤ÎÊÑ´¹
    $_POST = lfConvertParam($_POST);
    // ¥¨¥é¡¼¥Á¥§¥Ã¥¯
    $objPage->arrErr = lfErrorCheck();
    if(count($objPage->arrErr) <= 0) {
        if($_POST['classcategory_id'] == "") {
            lfInsertClass();    // DB¤Ø¤Î½ñ¤­¹þ¤ß
        } else {
            lfUpdateClass();    // DB¤Ø¤Î½ñ¤­¹þ¤ß
        }
        // ºÆɽ¼¨
        sfReload("class_id=" . $_GET['class_id']);
    } else {
        // POST¥Ç¡¼¥¿¤ò°ú¤­·Ñ¤°
        $objPage->tpl_classcategory_id = $_POST['classcategory_id'];
    }
    break;
// ºï½ü
case 'delete':
    // ¥é¥ó¥¯ÉÕ¤­¥ì¥³¡¼¥É¤Îºï½ü
    $where = "class_id = " . addslashes($_POST['class_id']);
    sfDeleteRankRecord("dtb_classcategory", "classcategory_id", $_POST['classcategory_id'], $where, true);
    break;
// ÊÔ½¸Á°½èÍý
case 'pre_edit':
    // ÊÔ½¸¹àÌܤòDB¤è¤ê¼èÆÀ¤¹¤ë¡£
    $where = "classcategory_id = ?";
    $name = $objQuery->get("dtb_classcategory", "name", $where, array($_POST['classcategory_id']));
    // ÆþÎϹàÌܤ˥«¥Æ¥´¥ê̾¤òÆþÎϤ¹¤ë¡£
    $objPage->arrForm['name'] = $name;
    // POST¥Ç¡¼¥¿¤ò°ú¤­·Ñ¤°
    $objPage->tpl_classcategory_id = $_POST['classcategory_id'];
    break;
case 'down':
    $where = "class_id = " . addslashes($_POST['class_id']);
    sfRankDown("dtb_classcategory", "classcategory_id", $_POST['classcategory_id'], $where);
    break;
case 'up':
    $where = "class_id = " . addslashes($_POST['class_id']);
    sfRankUp("dtb_classcategory", "classcategory_id", $_POST['classcategory_id'], $where);
    break;
default:
    break;
}

// µ¬³ÊʬÎà¤ÎÆɹþ
$where = "del_flg <> 1 AND class_id = ?";
$objQuery->setorder("rank DESC");
$objPage->arrClassCat = $objQuery->select("name, classcategory_id", "dtb_classcategory", $where, array($_GET['class_id']));

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

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

/* DB¤Ø¤ÎÁÞÆþ */
function lfInsertClass() {
    $objQuery = new SC_Query();
    $objQuery->begin();
    // ¿Æµ¬³ÊID¤Î¸ºß¥Á¥§¥Ã¥¯
    $where = "del_flg <> 1 AND class_id = ?";
    $ret =  $objQuery->get("dtb_class", "class_id", $where, array($_POST['class_id']));
    if($ret != "") {    
        // INSERT¤¹¤ëÃͤòºîÀ®¤¹¤ë¡£
        $sqlval['name'] = $_POST['name'];
        $sqlval['class_id'] = $_POST['class_id'];
        $sqlval['creator_id'] = $_SESSION['member_id'];
        $sqlval['rank'] = $objQuery->max("dtb_classcategory", "rank", $where, array($_POST['class_id'])) + 1;
        $sqlval['create_date'] = "now()";
        $sqlval['update_date'] = "now()";
        // INSERT¤Î¼Â¹Ô
        $ret = $objQuery->insert("dtb_classcategory", $sqlval);
    }
    $objQuery->commit();
    return $ret;
}

/* DB¤Ø¤Î¹¹¿· */
function lfUpdateClass() {
    $objQuery = new SC_Query();
    // UPDATE¤¹¤ëÃͤòºîÀ®¤¹¤ë¡£
    $sqlval['name'] = $_POST['name'];
    $sqlval['update_date'] = "Now()";
    $where = "classcategory_id = ?";
    // UPDATE¤Î¼Â¹Ô
    $ret = $objQuery->update("dtb_classcategory", $sqlval, $where, array($_POST['classcategory_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","MAX_LENGTH_CHECK"));
    if(!isset($objErr->arrErr['name'])) {
        $objQuery = new SC_Query();
        $where = "class_id = ? AND name = ?";
        $arrRet = $objQuery->select("classcategory_id, name", "dtb_classcategory", $where, array($_GET['class_id'], $_POST['name']));
        // ÊÔ½¸Ãæ¤Î¥ì¥³¡¼¥É°Ê³°¤ËƱ¤¸Ì¾¾Î¤¬Â¸ºß¤¹¤ë¾ì¹ç
        if ($arrRet[0]['classcategory_id'] != $_POST['classcategory_id'] && $arrRet[0]['name'] == $_POST['name']) {
            $objErr->arrErr['name'] = "¢¨ ´û¤ËƱ¤¸ÆâÍƤÎÅÐÏ¿¤¬Â¸ºß¤·¤Þ¤¹¡£<br>";
        }
    }
    return $objErr->arrErr;
}
?>