source: branches/rel/html/admin/basis/index.php @ 12157

Revision 12157, 6.3 KB checked in by uehara, 19 years ago (diff)
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    var $tpl_mode;
12    function LC_Page() {
13        $this->tpl_mainpage = 'basis/index.tpl';
14        $this->tpl_subnavi = 'basis/subnavi.tpl';
15        $this->tpl_subno = 'index';
16        $this->tpl_mainno = 'basis';
17        global $arrPref;
18        $this->arrPref = $arrPref;
19        global $arrTAXRULE;
20        $this->arrTAXRULE = $arrTAXRULE;
21        $this->tpl_subtitle = 'SHOP¥Þ¥¹¥¿';
22    }
23}
24
25
26$conn = new SC_DBConn();
27$objPage = new LC_Page();
28$objView = new SC_AdminView();
29$objSess = new SC_Session();
30$objQuery = new SC_Query();
31
32// ǧ¾Ú²ÄÈݤÎȽÄê
33sfIsSuccess($objSess);
34
35$cnt = $objQuery->count("dtb_baseinfo");
36
37if ($cnt > 0) {
38    $objPage->tpl_mode = "update";
39} else {
40    $objPage->tpl_mode = "insert";
41}
42
43if($_POST['mode'] != "") {
44    // POST¥Ç¡¼¥¿¤Î°ú¤­·Ñ¤®
45    $objPage->arrForm = $_POST;
46   
47    // ÆþÎϥǡ¼¥¿¤ÎÊÑ´¹
48    $objPage->arrForm = lfConvertParam($objPage->arrForm);
49    // ÆþÎϥǡ¼¥¿¤Î¥¨¥é¡¼¥Á¥§¥Ã¥¯
50    $objPage->arrErr = lfErrorCheck($objPage->arrForm);
51   
52    if(count($objPage->arrErr) == 0) {
53        switch($_POST['mode']) {
54        case 'update':
55            lfUpdateData($objPage->arrForm);    // ´û¸ÊÔ½¸
56            break;
57        case 'insert':
58            lfInsertData($objPage->arrForm);    // ¿·µ¬ºîÀ®
59            break;
60        default:
61            break;
62        }
63        // ºÆɽ¼¨
64        sfReload();
65    }
66} else {
67    $arrCol = lfGetCol();
68    $col    = sfGetCommaList($arrCol);
69    $arrRet = $objQuery->select($col, "dtb_baseinfo");
70    $objPage->arrForm = $arrRet[0];
71}
72
73$objView->assignobj($objPage);
74$objView->display(MAIN_FRAME);
75//--------------------------------------------------------------------------------------------------------------------------------------
76// ´ðËܾðÊóÍѤΥ«¥é¥à¤ò¼è¤ê½Ð¤¹¡£
77function lfGetCol() {
78    $arrCol = array(
79        "company_name",
80        "company_kana",
81        "shop_name",
82        "shop_kana",
83        "zip01",
84        "zip02",
85        "pref",
86        "addr01",
87        "addr02",
88        "tel01",
89        "tel02",
90        "tel03",
91        "fax01",
92        "fax02",
93        "fax03",
94        "business_hour",
95        "email01",
96        "email02",
97        "email03",
98        "email04",
99        "tax",
100        "tax_rule",
101        "free_rule",
102        "good_traded",
103        "message"
104       
105    );
106    return $arrCol;
107}
108
109function lfUpdateData($array) {
110    $objQuery = new SC_Query();
111    $arrCol = lfGetCol();
112    foreach($arrCol as $val) {
113        $sqlval[$val] = $array[$val];
114    }
115    $sqlval['update_date'] = 'Now()';
116    // UPDATE¤Î¼Â¹Ô
117    $ret = $objQuery->update("dtb_baseinfo", $sqlval);
118}
119
120function lfInsertData($array) {
121    $objQuery = new SC_Query();
122    $arrCol = lfGetCol();
123    foreach($arrCol as $val) {
124        $sqlval[$val] = $array[$val];
125    }   
126    $sqlval['update_date'] = 'Now()';
127    // INSERT¤Î¼Â¹Ô
128    $ret = $objQuery->insert("dtb_baseinfo", $sqlval);
129}
130
131/* ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ */
132function lfConvertParam($array) {
133    /*
134     *  ʸ»úÎó¤ÎÊÑ´¹
135     *  K :  ¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹
136     *  C :  ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹
137     *  V :  ÂùÅÀÉÕ¤­¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹ 
138     *  n :  ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)¡×¤ËÊÑ´¹
139     *  a :  Á´³Ñ±Ñ¿ô»ú¤òȾ³Ñ±Ñ¿ô»ú¤ËÊÑ´¹¤¹¤ë
140     */
141    // ¿Íʪ´ðËܾðÊó
142   
143    // ¥¹¥Ý¥Ã¥È¾¦ÉÊ
144    $arrConvList['company_name'] = "KVa";
145    $arrConvList['company_kana'] = "KVC";
146    $arrConvList['shop_name'] = "KVa";
147    $arrConvList['shop_kana'] = "KVC";
148    $arrConvList['addr01'] = "KVa";
149    $arrConvList['addr02'] = "KVa";
150    $arrConvList['zip01'] = "n";
151    $arrConvList['zip02'] = "n";
152    $arrConvList['tel01'] = "n";
153    $arrConvList['tel02'] = "n";
154    $arrConvList['tel03'] = "n";
155    $arrConvList['fax01'] = "n";
156    $arrConvList['fax02'] = "n";
157    $arrConvList['fax03'] = "n";
158    $arrConvList['email01'] = "a";
159    $arrConvList['email02'] = "a";
160    $arrConvList['email03'] = "a";
161    $arrConvList['email04'] = "a";
162    $arrConvList['tax'] = "n";
163    $arrConvList['free_rule'] = "n";
164    $arrConvList['business_hour'] = "KVa";
165    $arrConvList['good_traded'] = "";
166    $arrConvList['message'] = "";
167   
168    // ʸ»úÊÑ´¹
169    foreach ($arrConvList as $key => $val) {
170        // POST¤µ¤ì¤Æ¤­¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£
171        if(isset($array[$key])) {
172            $array[$key] = mb_convert_kana($array[$key] ,$val);
173        }
174    }
175    return $array;
176}
177
178// ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯
179function lfErrorCheck($array) {
180    $objErr = new SC_CheckError($array);
181   
182    $objErr->doFunc(array("²ñ¼Ò̾", "company_name", STEXT_LEN), array("MAX_LENGTH_CHECK"));
183    $objErr->doFunc(array("²ñ¼Ò̾(¥«¥Ê)", "company_kana", STEXT_LEN), array("KANA_CHECK","MAX_LENGTH_CHECK"));
184    $objErr->doFunc(array("Ź̾", "shop_name", STEXT_LEN), array("EXIST_CHECK","MAX_LENGTH_CHECK"));
185    $objErr->doFunc(array("Ź̾(¥«¥Ê)", "shop_kana", STEXT_LEN), array("KANA_CHECK","MAX_LENGTH_CHECK"));
186    // ͹ÊØÈÖ¹æ¥Á¥§¥Ã¥¯
187    $objErr->doFunc(array("͹ÊØÈÖ¹æ1","zip01",ZIP01_LEN ) ,array("EXIST_CHECK", "NUM_CHECK","NUM_COUNT_CHECK"));
188    $objErr->doFunc(array("͹ÊØÈÖ¹æ2","zip02",ZIP02_LEN ) ,array("EXIST_CHECK", "NUM_CHECK","NUM_COUNT_CHECK"));
189    $objErr->doFunc(array("͹ÊØÈÖ¹æ", "zip01", "zip02"), array("ALL_EXIST_CHECK"));
190    // ½»½ê¥Á¥§¥Ã¥¯
191    $objErr->doFunc(array("ÅÔÆ»Éܸ©", "pref"), array("EXIST_CHECK"));
192    $objErr->doFunc(array("½»½ê1", "addr01", STEXT_LEN), array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
193    $objErr->doFunc(array("½»½ê2", "addr02", STEXT_LEN), array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
194    // ¥á¡¼¥ë¥Á¥§¥Ã¥¯
195    $objErr->doFunc(array('¾¦ÉÊÃíʸ¼õÉե᡼¥ë¥¢¥É¥ì¥¹', "email01", STEXT_LEN) ,array("EXIST_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));
196    $objErr->doFunc(array('Ì䤤¹ç¤ï¤»¼õÉե᡼¥ë¥¢¥É¥ì¥¹', "email02", STEXT_LEN) ,array("EXIST_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));
197    $objErr->doFunc(array('¥á¡¼¥ëÁ÷¿®¸µ¥á¡¼¥ë¥¢¥É¥ì¥¹', "email03", STEXT_LEN) ,array("EXIST_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));
198    $objErr->doFunc(array('Á÷¿®¥¨¥é¡¼¼õÉե᡼¥ë¥¢¥É¥ì¥¹', "email04", STEXT_LEN) ,array("EXIST_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK","MAX_LENGTH_CHECK"));
199    // ÅÅÏÃÈÖ¹æ¥Á¥§¥Ã¥¯
200    $objErr->doFunc(array("TEL", "tel01", "tel02", "tel03", TEL_ITEM_LEN), array("TEL_CHECK"));
201    $objErr->doFunc(array("FAX", "fax01", "fax02", "fax03", TEL_ITEM_LEN), array("TEL_CHECK"));
202    // ¤½¤Î¾
203    $objErr->doFunc(array("¾ÃÈñÀÇΨ", "tax", PERCENTAGE_LEN), array("EXIST_CHECK", "NUM_CHECK", "MAX_LENGTH_CHECK"));
204    $objErr->doFunc(array("Á÷ÎÁ̵ÎÁ¾ò·ï", "free_rule", PRICE_LEN), array("NUM_CHECK", "MAX_LENGTH_CHECK"));
205    $objErr->doFunc(array("ŹÊޱĶȻþ´Ö", "business_hour", STEXT_LEN), array("MAX_LENGTH_CHECK"));
206
207    $objErr->doFunc(array("¼è°·¾¦ÉÊ", "good_traded", LLTEXT_LEN), array("MAX_LENGTH_CHECK"));
208    $objErr->doFunc(array("¥á¥Ã¥»¡¼¥¸", "message", LLTEXT_LEN), array("MAX_LENGTH_CHECK"));
209
210    return $objErr->arrErr;
211}
212
213?>
Note: See TracBrowser for help on using the repository browser.