source: branches/version-2_11-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Tradelaw.php @ 21185

Revision 21185, 7.3 KB checked in by shutta, 13 years ago (diff)

refs #800 (SQL標準関数を使用する)
CURRENT_TIMESTAMP を使用するように now() を置換。

  • Property svn:eol-style set to LF
  • Property svn:keywords set to Id
  • Property svn:mime-type set to text/x-httpd-php; charset=UTF-8
Line 
1<?php
2/*
3 * This file is part of EC-CUBE
4 *
5 * Copyright(c) 2000-2011 LOCKON CO.,LTD. All Rights Reserved.
6 *
7 * http://www.lockon.co.jp/
8 *
9 * This program is free software; you can redistribute it and/or
10 * modify it under the terms of the GNU General Public License
11 * as published by the Free Software Foundation; either version 2
12 * of the License, or (at your option) any later version.
13 *
14 * This program is distributed in the hope that it will be useful,
15 * but WITHOUT ANY WARRANTY; without even the implied warranty of
16 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
17 * GNU General Public License for more details.
18 *
19 * You should have received a copy of the GNU General Public License
20 * along with this program; if not, write to the Free Software
21 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
22 */
23
24// {{{ requires
25require_once CLASS_EX_REALDIR . 'page_extends/admin/LC_Page_Admin_Ex.php';
26
27/**
28 * 特定商取引法 のページクラス.
29 *
30 * @package Page
31 * @author LOCKON CO.,LTD.
32 * @version $Id$
33 */
34class LC_Page_Admin_Basis_Tradelaw extends LC_Page_Admin_Ex {
35
36    // }}}
37    // {{{ functions
38
39    /**
40     * Page を初期化する.
41     *
42     * @return void
43     */
44    function init() {
45        parent::init();
46        $this->tpl_mainpage = 'basis/tradelaw.tpl';
47        $this->tpl_subno = 'tradelaw';
48        $this->tpl_mainno = 'basis';
49        $masterData = new SC_DB_MasterData_Ex();
50        $this->arrPref = $masterData->getMasterData('mtb_pref');
51        $this->arrTAXRULE = $masterData->getMasterData("mtb_taxrule");
52        $this->tpl_maintitle = '基本情報管理';
53        $this->tpl_subtitle = '特定商取引法';
54    }
55
56    /**
57     * Page のプロセス.
58     *
59     * @return void
60     */
61    function process() {
62        $this->action();
63        $this->sendResponse();
64    }
65
66    /**
67     * Page のアクション.
68     *
69     * @return void
70     */
71    function action() {
72        $objDb = new SC_Helper_DB_Ex();
73
74        $objFormParam = new SC_FormParam_Ex();
75        $this->lfInitParam($objFormParam);
76        $objFormParam->setParam($_POST);
77
78        $cnt = $objDb->sfGetBasisCount();
79        if ($cnt > 0) {
80            $this->tpl_mode = 'update';
81        } else {
82            $this->tpl_mode = 'insert';
83        }
84
85        if(!empty($_POST)) {
86            // 入力値の変換
87            $objFormParam->convParam();
88            $this->arrErr = $this->lfCheckError($objFormParam);
89
90            if(count($this->arrErr) == 0) {
91                switch($this->getMode()) {
92                case 'update':
93                    $this->lfUpdateData($objFormParam->getHashArray()); // 既存編集
94                    break;
95                case 'insert':
96                    $this->lfInsertData($objFormParam->getHashArray()); // 新規作成
97                    break;
98                default:
99                    break;
100                }
101                // 再表示
102                //sfReload();
103                $this->tpl_onload = "window.alert('特定商取引法の登録が完了しました。');";
104            }
105        } else {
106            $arrCol = $objFormParam->getKeyList(); // キー名一覧を取得
107            $col    = SC_Utils_Ex::sfGetCommaList($arrCol);
108            $arrRet = $objDb->sfGetBasisData(true, $col);
109            $objFormParam->setParam($arrRet);
110        }
111        $this->arrForm = $objFormParam->getFormParamList();
112    }
113
114    /**
115     * デストラクタ.
116     *
117     * @return void
118     */
119    function destroy() {
120        parent::destroy();
121    }
122
123    /* パラメーター情報の初期化 */
124    function lfInitParam(&$objFormParam) {
125        $objFormParam->addParam("販売業者", "law_company", STEXT_LEN, 'KVa', array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
126        $objFormParam->addParam("運営責任者", "law_manager", STEXT_LEN, 'KVa', array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
127        $objFormParam->addParam("郵便番号1", "law_zip01", ZIP01_LEN, 'n', array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK"));
128        $objFormParam->addParam("郵便番号2", "law_zip02", ZIP02_LEN, 'n', array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK"));
129        $objFormParam->addParam("都道府県", "law_pref", INT_LEN, 'n', array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));
130        $objFormParam->addParam("住所1", "law_addr01", MTEXT_LEN, 'KVa', array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
131        $objFormParam->addParam("住所2", "law_addr02", MTEXT_LEN, 'KVa', array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
132        $objFormParam->addParam("電話番号1", "law_tel01", TEL_ITEM_LEN, 'n', array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK"));
133        $objFormParam->addParam("電話番号2", "law_tel02", TEL_ITEM_LEN, 'n', array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK"));
134        $objFormParam->addParam("電話番号3", "law_tel03", TEL_ITEM_LEN, 'n', array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK"));
135        $objFormParam->addParam("FAX番号1", "law_fax01", TEL_ITEM_LEN, 'n', array("MAX_LENGTH_CHECK" ,"NUM_CHECK"));
136        $objFormParam->addParam("FAX番号2", "law_fax02", TEL_ITEM_LEN, 'n', array("MAX_LENGTH_CHECK" ,"NUM_CHECK"));
137        $objFormParam->addParam("FAX番号3", "law_fax03", TEL_ITEM_LEN, 'n', array("MAX_LENGTH_CHECK" ,"NUM_CHECK"));
138        $objFormParam->addParam("メールアドレス", "law_email", null, 'KVa', array("EXIST_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK"));
139        $objFormParam->addParam('URL', "law_url", STEXT_LEN, 'KVa', array("EXIST_CHECK", "MAX_LENGTH_CHECK", "URL_CHECK"));
140        $objFormParam->addParam("必要料金", "law_term01", MTEXT_LEN, 'KVa', array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
141        $objFormParam->addParam("注文方法", "law_term02", MTEXT_LEN, 'KVa', array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
142        $objFormParam->addParam("支払方法", "law_term03", MTEXT_LEN, 'KVa', array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
143        $objFormParam->addParam("支払期限", "law_term04", MTEXT_LEN, 'KVa', array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
144        $objFormParam->addParam("引き渡し時期", "law_term05", MTEXT_LEN, 'KVa', array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
145        $objFormParam->addParam("返品・交換について", "law_term06", MTEXT_LEN, 'KVa', array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
146    }
147
148    function lfUpdateData($sqlval) {
149        $sqlval['update_date'] = 'CURRENT_TIMESTAMP';
150        $objQuery =& SC_Query_Ex::getSingletonInstance();
151        // UPDATEの実行
152        $ret = $objQuery->update("dtb_baseinfo", $sqlval);
153    }
154
155    function lfInsertData($sqlval) {
156        $sqlval['update_date'] = 'CURRENT_TIMESTAMP';
157        $objQuery =& SC_Query_Ex::getSingletonInstance();
158        // INSERTの実行
159        $ret = $objQuery->insert("dtb_baseinfo", $sqlval);
160    }
161
162    /* 入力内容のチェック */
163    function lfCheckError(&$objFormParam) {
164        // 入力データを渡す。
165        $arrRet =  $objFormParam->getHashArray();
166        $objErr = new SC_CheckError_Ex($arrRet);
167        $objErr->arrErr = $objFormParam->checkError();
168
169        // 電話番号チェック
170        $objErr->doFunc(array('TEL', "law_tel01", "law_tel02", "law_tel03"), array("TEL_CHECK"));
171        $objErr->doFunc(array('FAX', "law_fax01", "law_fax02", "law_fax03"), array("TEL_CHECK"));
172        $objErr->doFunc(array("郵便番号", "law_zip01", "law_zip02"), array("ALL_EXIST_CHECK"));
173
174        return $objErr->arrErr;
175    }
176}
177?>
Note: See TracBrowser for help on using the repository browser.