source: temp/trunk/html/admin/basis/index.php @ 1328

Revision 1328, 6.3 KB checked in by naka, 20 years ago (diff)

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