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

Revision 3710, 6.2 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    }
62} else {
63    $arrCol = lfGetCol();
64    $col    = sfGetCommaList($arrCol);
65    $arrRet = $objQuery->select($col, "dtb_baseinfo");
66    $objPage->arrForm = $arrRet[0];
67}
68
69$objView->assignobj($objPage);
70$objView->display(MAIN_FRAME);
71//--------------------------------------------------------------------------------------------------------------------------------------
72// ´ðËܾðÊóÍѤΥ«¥é¥à¤ò¼è¤ê½Ð¤¹¡£
73function lfGetCol() {
74    $arrCol = array(
75        "company_name",
76        "company_kana",
77        "shop_name",
78        "shop_kana",
79        "zip01",
80        "zip02",
81        "pref",
82        "addr01",
83        "addr02",
84        "tel01",
85        "tel02",
86        "tel03",
87        "fax01",
88        "fax02",
89        "fax03",
90        "business_hour",
91        "email01",
92        "email02",
93        "email03",
94        "email04",
95        "tax",
96        "tax_rule",
97        "free_rule",
98        "good_traded",
99        "message"
100       
101    );
102    return $arrCol;
103}
104
105function lfUpdateData($array) {
106    $objQuery = new SC_Query();
107    $arrCol = lfGetCol();
108    foreach($arrCol as $val) {
109        $sqlval[$val] = $array[$val];
110    }
111    $sqlval['update_date'] = 'Now()';
112    // UPDATE¤Î¼Â¹Ô
113    $ret = $objQuery->update("dtb_baseinfo", $sqlval);
114}
115
116function lfInsertData($array) {
117    $objQuery = new SC_Query();
118    $arrCol = lfGetCol();
119    foreach($arrCol as $val) {
120        $sqlval[$val] = $array[$val];
121    }   
122    $sqlval['update_date'] = 'Now()';
123    // INSERT¤Î¼Â¹Ô
124    $ret = $objQuery->insert("dtb_baseinfo", $sqlval);
125}
126
127/* ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ */
128function lfConvertParam($array) {
129    /*
130     *  ʸ»úÎó¤ÎÊÑ´¹
131     *  K :  ¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹
132     *  C :  ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹
133     *  V :  ÂùÅÀÉÕ¤­¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹ 
134     *  n :  ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)¡×¤ËÊÑ´¹
135     *  a :  Á´³Ñ±Ñ¿ô»ú¤òȾ³Ñ±Ñ¿ô»ú¤ËÊÑ´¹¤¹¤ë
136     */
137    // ¿Íʪ´ðËܾðÊó
138   
139    // ¥¹¥Ý¥Ã¥È¾¦ÉÊ
140    $arrConvList['company_name'] = "KVa";
141    $arrConvList['company_kana'] = "KVC";
142    $arrConvList['shop_name'] = "KVa";
143    $arrConvList['shop_kana'] = "KVC";
144    $arrConvList['addr01'] = "KVa";
145    $arrConvList['addr02'] = "KVa";
146    $arrConvList['zip01'] = "n";
147    $arrConvList['zip02'] = "n";
148    $arrConvList['tel01'] = "n";
149    $arrConvList['tel02'] = "n";
150    $arrConvList['tel03'] = "n";
151    $arrConvList['fax01'] = "n";
152    $arrConvList['fax02'] = "n";
153    $arrConvList['fax03'] = "n";
154    $arrConvList['email01'] = "a";
155    $arrConvList['email02'] = "a";
156    $arrConvList['email03'] = "a";
157    $arrConvList['email04'] = "a";
158    $arrConvList['tax'] = "n";
159    $arrConvList['free_rule'] = "n";
160    $arrConvList['business_hour'] = "KVa";
161    $arrConvList['good_traded'] = "";
162    $arrConvList['message'] = "";
163   
164    // ʸ»úÊÑ´¹
165    foreach ($arrConvList as $key => $val) {
166        // POST¤µ¤ì¤Æ¤­¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£
167        if(isset($array[$key])) {
168            $array[$key] = mb_convert_kana($array[$key] ,$val);
169        }
170    }
171    return $array;
172}
173
174// ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯
175function lfErrorCheck($array) {
176    $objErr = new SC_CheckError($array);
177   
178    $objErr->doFunc(array("²ñ¼Ò̾", "company_name", STEXT_LEN), array("MAX_LENGTH_CHECK"));
179    $objErr->doFunc(array("²ñ¼Ò̾(¥«¥Ê)", "company_kana", STEXT_LEN), array("KANA_CHECK","MAX_LENGTH_CHECK"));
180    $objErr->doFunc(array("Ź̾", "shop_name", STEXT_LEN), array("EXIST_CHECK","MAX_LENGTH_CHECK"));
181    $objErr->doFunc(array("Ź̾(¥«¥Ê)", "shop_kana", STEXT_LEN), array("KANA_CHECK","MAX_LENGTH_CHECK"));
182    // ͹ÊØÈÖ¹æ¥Á¥§¥Ã¥¯
183    $objErr->doFunc(array("͹ÊØÈÖ¹æ1","zip01",ZIP01_LEN ) ,array("EXIST_CHECK", "NUM_CHECK","NUM_COUNT_CHECK"));
184    $objErr->doFunc(array("͹ÊØÈÖ¹æ2","zip02",ZIP02_LEN ) ,array("EXIST_CHECK", "NUM_CHECK","NUM_COUNT_CHECK"));
185    $objErr->doFunc(array("͹ÊØÈÖ¹æ", "zip01", "zip02"), array("ALL_EXIST_CHECK"));
186    // ½»½ê¥Á¥§¥Ã¥¯
187    $objErr->doFunc(array("ÅÔÆ»Éܸ©", "pref"), array("EXIST_CHECK"));
188    $objErr->doFunc(array("½»½ê1", "addr01", STEXT_LEN), array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
189    $objErr->doFunc(array("½»½ê2", "addr02", STEXT_LEN), array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
190    // ¥á¡¼¥ë¥Á¥§¥Ã¥¯
191    $objErr->doFunc(array('¾¦ÉÊÃíʸ¼õÉե᡼¥ë¥¢¥É¥ì¥¹', "email01", STEXT_LEN) ,array("EXIST_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));
192    $objErr->doFunc(array('Ì䤤¹ç¤ï¤»¼õÉե᡼¥ë¥¢¥É¥ì¥¹', "email02", STEXT_LEN) ,array("EXIST_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));
193    $objErr->doFunc(array('¥á¡¼¥ëÁ÷¿®¸µ¥á¡¼¥ë¥¢¥É¥ì¥¹', "email03", STEXT_LEN) ,array("EXIST_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));
194    $objErr->doFunc(array('Á÷¿®¥¨¥é¡¼¼õÉե᡼¥ë¥¢¥É¥ì¥¹', "email04", STEXT_LEN) ,array("EXIST_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK","MAX_LENGTH_CHECK"));
195    // ÅÅÏÃÈÖ¹æ¥Á¥§¥Ã¥¯
196    $objErr->doFunc(array("TEL", "tel01", "tel02", "tel03", TEL_ITEM_LEN), array("TEL_CHECK"));
197    $objErr->doFunc(array("FAX", "fax01", "fax02", "fax03", TEL_ITEM_LEN), array("TEL_CHECK"));
198    // ¤½¤Î¾
199    $objErr->doFunc(array("¾ÃÈñÀÇΨ", "tax", PERCENTAGE_LEN), array("EXIST_CHECK", "NUM_CHECK", "MAX_LENGTH_CHECK"));
200    $objErr->doFunc(array("Á÷ÎÁ̵ÎÁ¾ò·ï", "free_rule", PRICE_LEN), array("NUM_CHECK", "MAX_LENGTH_CHECK"));
201    $objErr->doFunc(array("ŹÊޱĶȻþ´Ö", "business_hour", STEXT_LEN), array("MAX_LENGTH_CHECK"));
202
203    $objErr->doFunc(array("¼è°·¾¦ÉÊ", "good_traded", LLTEXT_LEN), array("MAX_LENGTH_CHECK"));
204    $objErr->doFunc(array("¥á¥Ã¥»¡¼¥¸", "message", LLTEXT_LEN), array("MAX_LENGTH_CHECK"));
205
206    return $objErr->arrErr;
207}
208
209?>
Note: See TracBrowser for help on using the repository browser.