source: branches/comu/html/admin/basis/kiyaku.php @ 12197

Revision 12197, 4.2 KB checked in by adati, 17 years ago (diff)

1.3.0正式版のマージ

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 = 'basis/kiyaku.tpl';
13        $this->tpl_subnavi = 'basis/subnavi.tpl';
14        $this->tpl_subno = 'kiyaku';
15        $this->tpl_subtitle = '²ñ°÷µ¬ÌóÅÐÏ¿';
16        $this->tpl_mainno = 'basis';
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    // ¥¨¥é¡¼¥Á¥§¥Ã¥¯
39    $objPage->arrErr = lfErrorCheck();
40    if(count($objPage->arrErr) <= 0) {
41        if($_POST['kiyaku_id'] == "") {
42            lfInsertClass($objPage->arrForm);   // ¿·µ¬ºîÀ®
43        } else {
44            lfUpdateClass($objPage->arrForm);   // ´û¸ÊÔ½¸
45        }
46        // ºÆɽ¼¨
47        sfReload();
48    } else {
49        // POST¥Ç¡¼¥¿¤ò°ú¤­·Ñ¤°
50        $objPage->tpl_kiyaku_id = $_POST['kiyaku_id'];
51    }
52    break;
53// ºï½ü
54case 'delete':
55    sfDeleteRankRecord("dtb_kiyaku", "kiyaku_id", $_POST['kiyaku_id'], "", true);
56    // ºÆɽ¼¨
57    sfReload();
58    break;
59// ÊÔ½¸Á°½èÍý
60case 'pre_edit':
61    // ÊÔ½¸¹àÌܤòDB¤è¤ê¼èÆÀ¤¹¤ë¡£
62    $where = "kiyaku_id = ?";
63    $arrRet = $objQuery->select("kiyaku_text, kiyaku_title", "dtb_kiyaku", $where, array($_POST['kiyaku_id']));
64    // ÆþÎϹàÌܤ˥«¥Æ¥´¥ê̾¤òÆþÎϤ¹¤ë¡£
65    $objPage->arrForm['kiyaku_title'] = $arrRet[0]['kiyaku_title'];
66    $objPage->arrForm['kiyaku_text'] = $arrRet[0]['kiyaku_text'];
67    // POST¥Ç¡¼¥¿¤ò°ú¤­·Ñ¤°
68    $objPage->tpl_kiyaku_id = $_POST['kiyaku_id'];
69break;
70case 'down':
71    sfRankDown("dtb_kiyaku", "kiyaku_id", $_POST['kiyaku_id']);
72    // ºÆɽ¼¨
73    sfReload();
74    break;
75case 'up':
76    sfRankUp("dtb_kiyaku", "kiyaku_id", $_POST['kiyaku_id']);
77    // ºÆɽ¼¨
78    sfReload();
79    break;
80default:
81    break;
82}
83
84// µ¬³Ê¤ÎÆɹþ
85$where = "del_flg <> 1";
86$objQuery->setorder("rank DESC");
87$objPage->arrKiyaku = $objQuery->select("kiyaku_title, kiyaku_text, kiyaku_id", "dtb_kiyaku", $where);
88
89$objView->assignobj($objPage);
90$objView->display(MAIN_FRAME);
91
92//--------------------------------------------------------------------------------------------------------------------------------
93
94/* DB¤Ø¤ÎÁÞÆþ */
95function lfInsertClass($arrData) {
96    $objQuery = new SC_Query();
97    // INSERT¤¹¤ëÃͤòºîÀ®¤¹¤ë¡£
98    $sqlval['kiyaku_title'] = $arrData['kiyaku_title'];
99    $sqlval['kiyaku_text'] = $arrData['kiyaku_text'];
100    $sqlval['creator_id'] = $_SESSION['member_id'];
101    $sqlval['rank'] = $objQuery->max("dtb_kiyaku", "rank") + 1;
102    $sqlval['update_date'] = "Now()";
103    $sqlval['create_date'] = "Now()";
104    // INSERT¤Î¼Â¹Ô
105    $ret = $objQuery->insert("dtb_kiyaku", $sqlval);
106    return $ret;
107}
108
109/* DB¤Ø¤Î¹¹¿· */
110function lfUpdateClass($arrData) {
111    $objQuery = new SC_Query();
112    // UPDATE¤¹¤ëÃͤòºîÀ®¤¹¤ë¡£
113    $sqlval['kiyaku_title'] = $arrData['kiyaku_title'];
114    $sqlval['kiyaku_text'] = $arrData['kiyaku_text'];
115    $sqlval['update_date'] = "Now()";
116    $where = "kiyaku_id = ?";
117    // UPDATE¤Î¼Â¹Ô
118    $ret = $objQuery->update("dtb_kiyaku", $sqlval, $where, array($_POST['kiyaku_id']));
119    return $ret;
120}
121
122/* ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ */
123function lfConvertParam($array) {
124    // ʸ»úÊÑ´¹
125    $arrConvList['kiyaku_title'] = "KVa";
126    $arrConvList['kiyaku_text'] = "KVa";
127
128    foreach ($arrConvList as $key => $val) {
129        // POST¤µ¤ì¤Æ¤­¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£
130        if(isset($array[$key])) {
131            $array[$key] = mb_convert_kana($array[$key] ,$val);
132        }
133    }
134    return $array;
135}
136
137/* ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯ */
138function lfErrorCheck() {
139    $objErr = new SC_CheckError();
140    $objErr->doFunc(array("µ¬Ì󥿥¤¥È¥ë", "kiyaku_title", SMTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
141    $objErr->doFunc(array("µ¬ÌóÆâÍÆ", "kiyaku_text", MLTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
142    if(!isset($objErr->arrErr['name'])) {
143        $objQuery = new SC_Query();
144        $arrRet = $objQuery->select("kiyaku_id, kiyaku_title", "dtb_kiyaku", "del_flg = 0 AND kiyaku_title = ?", array($_POST['kiyaku_title']));
145        // ÊÔ½¸Ãæ¤Î¥ì¥³¡¼¥É°Ê³°¤ËƱ¤¸Ì¾¾Î¤¬Â¸ºß¤¹¤ë¾ì¹ç     
146        if ($arrRet[0]['kiyaku_id'] != $_POST['kiyaku_id'] && $arrRet[0]['kiyaku_title'] == $_POST['kiyaku_title']) {
147            $objErr->arrErr['name'] = "¢¨ ´û¤ËƱ¤¸ÆâÍƤÎÅÐÏ¿¤¬Â¸ºß¤·¤Þ¤¹¡£<br>";
148        }
149    }
150    return $objErr->arrErr;
151}
152?>
Note: See TracBrowser for help on using the repository browser.