source: branches/comu/html/admin/products/class.php @ 11730

Revision 11730, 3.9 KB checked in by nanasess, 17 years ago (diff)

r11729 の変更を取消

Line 
1<?php
2/*
3 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
4 *
5 * http://www.lockon.co.jp/
6 */
7require_once("../require.php");
8
9class LC_Page {
10    var $arrSession;
11    function LC_Page() {
12        $this->tpl_mainpage = 'products/class.tpl';
13        $this->tpl_subnavi = 'products/subnavi.tpl';
14        $this->tpl_subno = 'class';
15        $this->tpl_subtitle = 'µ¬³ÊÅÐÏ¿';
16        $this->tpl_mainno = 'products';
17    }
18}
19
20$conn = new SC_DBConn();
21$objPage = new LC_Page();
22$objView = new SC_AdminView();
23$objSess = new SC_Session();
24$objQuery = new SC_Query();
25
26// ǧ¾Ú²ÄÈݤÎȽÄê
27sfIsSuccess($objSess);
28
29// Í×µáȽÄê
30switch($_POST['mode']) {
31// ÊÔ½¸½èÍý
32case 'edit':
33    // POSTÃͤΰú¤­·Ñ¤®
34    $objPage->arrForm = $_POST;
35    // ÆþÎÏʸ»ú¤ÎÊÑ´¹
36    $objPage->arrForm = lfConvertParam($objPage->arrForm);
37    // ¥¨¥é¡¼¥Á¥§¥Ã¥¯
38    $objPage->arrErr = lfErrorCheck();
39    if(count($objPage->arrErr) <= 0) {
40        if($_POST['class_id'] == "") {
41            lfInsertClass($objPage->arrForm);   // ¿·µ¬ºîÀ®
42        } else {
43            lfUpdateClass($objPage->arrForm);   // ´û¸ÊÔ½¸
44        }
45        // ºÆɽ¼¨
46        sfReload();
47    } else {
48        // POST¥Ç¡¼¥¿¤ò°ú¤­·Ñ¤°
49        $objPage->tpl_class_id = $_POST['class_id'];
50    }
51    break;
52// ºï½ü
53case 'delete':
54    sfDeleteRankRecord("dtb_class", "class_id", $_POST['class_id'], "", true);
55    $objQuery = new SC_Query();
56    $objQuery->delete("dtb_classcategory", "class_id = ?", $_POST['class_id']);
57    // ºÆɽ¼¨
58    sfReload();
59    break;
60// ÊÔ½¸Á°½èÍý
61case 'pre_edit':
62    // ÊÔ½¸¹àÌܤòDB¤è¤ê¼èÆÀ¤¹¤ë¡£
63    $where = "class_id = ?";
64    $class_name = $objQuery->get("dtb_class", "name", $where, array($_POST['class_id']));
65    // ÆþÎϹàÌܤ˥«¥Æ¥´¥ê̾¤òÆþÎϤ¹¤ë¡£
66    $objPage->arrForm['name'] = $class_name;
67    // POST¥Ç¡¼¥¿¤ò°ú¤­·Ñ¤°
68    $objPage->tpl_class_id = $_POST['class_id'];
69break;
70case 'down':
71    sfRankDown("dtb_class", "class_id", $_POST['class_id']);
72    // ºÆɽ¼¨
73    sfReload();
74    break;
75case 'up':
76    sfRankUp("dtb_class", "class_id", $_POST['class_id']);
77    // ºÆɽ¼¨
78    sfReload();
79    break;
80default:
81    break;
82}
83
84// µ¬³Ê¤ÎÆɹþ
85$where = "del_flg <> 1";
86$objQuery->setorder("rank DESC");
87$objPage->arrClass = $objQuery->select("name, class_id", "dtb_class", $where);
88$objPage->arrClassCatCount = sfGetClassCatCount();
89
90$objView->assignobj($objPage);
91$objView->display(MAIN_FRAME);
92
93//--------------------------------------------------------------------------------------------------------------------------------
94
95/* DB¤Ø¤ÎÁÞÆþ */
96function lfInsertClass($arrData) {
97    $objQuery = new SC_Query();
98    // INSERT¤¹¤ëÃͤòºîÀ®¤¹¤ë¡£
99    $sqlval['name'] = $arrData['name'];
100    $sqlval['creator_id'] = $_SESSION['member_id'];
101    $sqlval['rank'] = $objQuery->max("dtb_class", "rank") + 1;
102    $sqlval['create_date'] = "now()";
103    $sqlval['update_date'] = "now()";
104    // INSERT¤Î¼Â¹Ô
105    $ret = $objQuery->insert("dtb_class", $sqlval);
106   
107    return $ret;
108}
109
110/* DB¤Ø¤Î¹¹¿· */
111function lfUpdateClass($arrData) {
112    $objQuery = new SC_Query();
113    // UPDATE¤¹¤ëÃͤòºîÀ®¤¹¤ë¡£
114    $sqlval['name'] = $arrData['name'];
115    $sqlval['update_date'] = "Now()";
116    $where = "class_id = ?";
117    // UPDATE¤Î¼Â¹Ô
118    $ret = $objQuery->update("dtb_class", $sqlval, $where, array($arrData['class_id']));
119    return $ret;
120}
121
122/* ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ */
123function lfConvertParam($array) {
124    // ʸ»úÊÑ´¹
125    $arrConvList['name'] = "KVa";
126
127    foreach ($arrConvList as $key => $val) {
128        // POST¤µ¤ì¤Æ¤­¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£
129        if(isset($array[$key])) {
130            $array[$key] = mb_convert_kana($array[$key] ,$val);
131        }
132    }
133    return $array;
134}
135
136/* ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯ */
137function lfErrorCheck() {
138    $objErr = new SC_CheckError();
139    $objErr->doFunc(array("µ¬³Ê̾", "name", STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
140   
141    if(!isset($objErr->arrErr['name'])) {
142        $objQuery = new SC_Query();
143        $arrRet = $objQuery->select("class_id, name", "dtb_class", "del_flg = 0 AND name = ?", array($_POST['name']));
144        // ÊÔ½¸Ãæ¤Î¥ì¥³¡¼¥É°Ê³°¤ËƱ¤¸Ì¾¾Î¤¬Â¸ºß¤¹¤ë¾ì¹ç     
145        if ($arrRet[0]['class_id'] != $_POST['class_id'] && $arrRet[0]['name'] == $_POST['name']) {
146            $objErr->arrErr['name'] = "¢¨ ´û¤ËƱ¤¸ÆâÍƤÎÅÐÏ¿¤¬Â¸ºß¤·¤Þ¤¹¡£<br>";
147        }
148    }
149    return $objErr->arrErr;
150}
151?>
Note: See TracBrowser for help on using the repository browser.