- Timestamp:
- 2012/02/11 05:48:00 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis.php
r21480 r21481 49 49 $masterData = new SC_DB_MasterData_Ex(); 50 50 $this->arrPref = $masterData->getMasterData('mtb_pref'); 51 $this->arrTAXRULE = $masterData->getMasterData( "mtb_taxrule");51 $this->arrTAXRULE = $masterData->getMasterData('mtb_taxrule'); 52 52 $this->tpl_maintitle = '基本情報管理'; 53 53 $this->tpl_subtitle = 'SHOPマスター'; … … 144 144 function lfGetCol() { 145 145 $arrCol = array( 146 "company_name",147 "company_kana",148 "shop_name",149 "shop_kana",150 "shop_name_eng",151 "zip01",152 "zip02",146 'company_name', 147 'company_kana', 148 'shop_name', 149 'shop_kana', 150 'shop_name_eng', 151 'zip01', 152 'zip02', 153 153 'pref', 154 "addr01",155 "addr02",156 "tel01",157 "tel02",158 "tel03",159 "fax01",160 "fax02",161 "fax03",162 "business_hour",163 "email01",164 "email02",165 "email03",166 "email04",154 'addr01', 155 'addr02', 156 'tel01', 157 'tel02', 158 'tel03', 159 'fax01', 160 'fax02', 161 'fax03', 162 'business_hour', 163 'email01', 164 'email02', 165 'email03', 166 'email04', 167 167 'tax', 168 "tax_rule",169 "free_rule",170 "good_traded",168 'tax_rule', 169 'free_rule', 170 'good_traded', 171 171 'message', 172 "regular_holiday_ids",172 'regular_holiday_ids', 173 173 'latitude', 174 174 'longitude', 175 "downloadable_days",176 "downloadable_days_unlimited"175 'downloadable_days', 176 'downloadable_days_unlimited' 177 177 ); 178 178 return $arrCol; … … 192 192 $sqlval['update_date'] = 'CURRENT_TIMESTAMP'; 193 193 // UPDATEの実行 194 $ret = $objQuery->update( "dtb_baseinfo", $sqlval);194 $ret = $objQuery->update('dtb_baseinfo', $sqlval); 195 195 196 196 $this->log("update done."); … … 205 205 $sqlval['update_date'] = 'CURRENT_TIMESTAMP'; 206 206 // INSERTの実行 207 $ret = $objQuery->insert( "dtb_baseinfo", $sqlval);207 $ret = $objQuery->insert('dtb_baseinfo', $sqlval); 208 208 209 209 $this->log("insert done."); … … 214 214 $objFormParam->addParam('会社名(フリガナ)', 'company_kana', STEXT_LEN, 'KVC', array('KANA_CHECK','MAX_LENGTH_CHECK')); 215 215 216 $objFormParam->addParam("店名", "shop_name", STEXT_LEN, 'KVa', array('EXIST_CHECK','MAX_LENGTH_CHECK'));217 $objFormParam->addParam("店名(フリガナ)", "shop_kana", STEXT_LEN, 'KVC', array('KANA_CHECK','MAX_LENGTH_CHECK'));218 $objFormParam->addParam("店名(英語表記)", "shop_name_eng",MTEXT_LEN, 'a', array('GRAPH_CHECK','MAX_LENGTH_CHECK'));216 $objFormParam->addParam("店名", 'shop_name', STEXT_LEN, 'KVa', array('EXIST_CHECK','MAX_LENGTH_CHECK')); 217 $objFormParam->addParam("店名(フリガナ)", 'shop_kana', STEXT_LEN, 'KVC', array('KANA_CHECK','MAX_LENGTH_CHECK')); 218 $objFormParam->addParam("店名(英語表記)", 'shop_name_eng',MTEXT_LEN, 'a', array('GRAPH_CHECK','MAX_LENGTH_CHECK')); 219 219 // 郵便番号チェック 220 $objFormParam->addParam("郵便番号1", "zip01", ZIP01_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK','NUM_COUNT_CHECK'));221 $objFormParam->addParam("郵便番号2", "zip02", ZIP02_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK','NUM_COUNT_CHECK'));220 $objFormParam->addParam("郵便番号1", 'zip01', ZIP01_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK','NUM_COUNT_CHECK')); 221 $objFormParam->addParam("郵便番号2", 'zip02', ZIP02_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK','NUM_COUNT_CHECK')); 222 222 // 住所チェック 223 223 $objFormParam->addParam("都道府県", 'pref', '', 'n', array('EXIST_CHECK')); 224 $objFormParam->addParam("住所1", "addr01", MTEXT_LEN, 'KVa', array('EXIST_CHECK', 'MAX_LENGTH_CHECK'));225 $objFormParam->addParam("住所2", "addr02", MTEXT_LEN, 'KVa', array('EXIST_CHECK', 'MAX_LENGTH_CHECK'));224 $objFormParam->addParam("住所1", 'addr01', MTEXT_LEN, 'KVa', array('EXIST_CHECK', 'MAX_LENGTH_CHECK')); 225 $objFormParam->addParam("住所2", 'addr02', MTEXT_LEN, 'KVa', array('EXIST_CHECK', 'MAX_LENGTH_CHECK')); 226 226 // メールチェック 227 $objFormParam->addParam('商品注文受付メールアドレス', "email01", null, 'a', array('EXIST_CHECK', 'EMAIL_CHECK', 'EMAIL_CHAR_CHECK'));228 $objFormParam->addParam('問い合わせ受付メールアドレス', "email02", null, 'a', array('EXIST_CHECK', 'EMAIL_CHECK', 'EMAIL_CHAR_CHECK'));229 $objFormParam->addParam('メール送信元メールアドレス', "email03", null, 'a', array('EXIST_CHECK', 'EMAIL_CHECK', 'EMAIL_CHAR_CHECK'));230 $objFormParam->addParam('送信エラー受付メールアドレス', "email04", null, 'a', array('EXIST_CHECK', 'EMAIL_CHECK', 'EMAIL_CHAR_CHECK'));227 $objFormParam->addParam('商品注文受付メールアドレス', 'email01', null, 'a', array('EXIST_CHECK', 'EMAIL_CHECK', 'EMAIL_CHAR_CHECK')); 228 $objFormParam->addParam('問い合わせ受付メールアドレス', 'email02', null, 'a', array('EXIST_CHECK', 'EMAIL_CHECK', 'EMAIL_CHAR_CHECK')); 229 $objFormParam->addParam('メール送信元メールアドレス', 'email03', null, 'a', array('EXIST_CHECK', 'EMAIL_CHECK', 'EMAIL_CHAR_CHECK')); 230 $objFormParam->addParam('送信エラー受付メールアドレス', 'email04', null, 'a', array('EXIST_CHECK', 'EMAIL_CHECK', 'EMAIL_CHAR_CHECK')); 231 231 232 232 // 電話番号 233 $objFormParam->addParam("電話番号1", "tel01", TEL_ITEM_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'));234 $objFormParam->addParam("電話番号2", "tel02", TEL_ITEM_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'));235 $objFormParam->addParam("電話番号3", "tel03", TEL_ITEM_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'));233 $objFormParam->addParam("電話番号1", 'tel01', TEL_ITEM_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK')); 234 $objFormParam->addParam("電話番号2", 'tel02', TEL_ITEM_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK')); 235 $objFormParam->addParam("電話番号3", 'tel03', TEL_ITEM_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK')); 236 236 237 237 // FAX番号 238 $objFormParam->addParam("FAX番号1", "fax01", TEL_ITEM_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'));239 $objFormParam->addParam("FAX番号2", "fax02", TEL_ITEM_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'));240 $objFormParam->addParam("FAX番号3", "fax03", TEL_ITEM_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'));238 $objFormParam->addParam("FAX番号1", 'fax01', TEL_ITEM_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK')); 239 $objFormParam->addParam("FAX番号2", 'fax02', TEL_ITEM_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK')); 240 $objFormParam->addParam("FAX番号3", 'fax03', TEL_ITEM_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK')); 241 241 242 242 // その他 243 243 $objFormParam->addParam("消費税率", 'tax', PERCENTAGE_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 244 $objFormParam->addParam("課税規則 ", "tax_rule", PERCENTAGE_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));245 $objFormParam->addParam("送料無料条件", "free_rule", PRICE_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'));246 $objFormParam->addParam("店舗営業時間", "business_hour", STEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK'));247 248 $objFormParam->addParam("取扱商品", "good_traded", LLTEXT_LEN, '', array('MAX_LENGTH_CHECK'));244 $objFormParam->addParam("課税規則 ", 'tax_rule', PERCENTAGE_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 245 $objFormParam->addParam("送料無料条件", 'free_rule', PRICE_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK')); 246 $objFormParam->addParam("店舗営業時間", 'business_hour', STEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK')); 247 248 $objFormParam->addParam("取扱商品", 'good_traded', LLTEXT_LEN, '', array('MAX_LENGTH_CHECK')); 249 249 $objFormParam->addParam("メッセージ", 'message', LLTEXT_LEN, '', array('MAX_LENGTH_CHECK')); 250 250 251 if (!isset($post['downloadable_days_unlimited']) && $post['downloadable_days_unlimited'] != "1") {252 $objFormParam->addParam("ダウンロード可能日数", "downloadable_days", DOWNLOAD_DAYS_LEN, 'n', array('EXIST_CHECK', 'ZERO_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));251 if (!isset($post['downloadable_days_unlimited']) && $post['downloadable_days_unlimited'] != '1') { 252 $objFormParam->addParam("ダウンロード可能日数", 'downloadable_days', DOWNLOAD_DAYS_LEN, 'n', array('EXIST_CHECK', 'ZERO_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 253 253 } else { 254 $objFormParam->addParam("ダウンロード無制限", "downloadable_days_unlimited", array('EXIST_CHECK'));254 $objFormParam->addParam("ダウンロード無制限", 'downloadable_days_unlimited', array('EXIST_CHECK')); 255 255 } 256 256 $objFormParam->addParam('緯度', 'latitude', STEXT_LEN, '', array('MAX_LENGTH_CHECK')); 257 257 $objFormParam->addParam('軽度', 'longitude', STEXT_LEN, '', array('MAX_LENGTH_CHECK')); 258 258 259 $objFormParam->addParam("定休日", "regular_holiday_ids", INT_LEN, 'n', array('MAX_LENGTH_CHECK'));259 $objFormParam->addParam("定休日", 'regular_holiday_ids', INT_LEN, 'n', array('MAX_LENGTH_CHECK')); 260 260 } 261 261 … … 266 266 267 267 $objErr = new SC_CheckError_Ex($post); 268 $objErr->doFunc(array("郵便番号", "zip01", "zip02"), array('ALL_EXIST_CHECK'));268 $objErr->doFunc(array("郵便番号", 'zip01', 'zip02'), array('ALL_EXIST_CHECK')); 269 269 270 270 // 電話番号チェック 271 $objErr->doFunc(array('TEL', "tel01", "tel02", "tel03"), array('TEL_CHECK'));272 $objErr->doFunc(array('FAX', "fax01", "fax02", "fax03"), array('TEL_CHECK'));271 $objErr->doFunc(array('TEL', 'tel01', 'tel02', 'tel03'), array('TEL_CHECK')); 272 $objErr->doFunc(array('FAX', 'fax01', 'fax02', 'fax03'), array('TEL_CHECK')); 273 273 274 274 $objErr->doFunc(array("緯度", 'latitude', STEXT_LEN), array('NUM_POINT_CHECK', 'MAX_LENGTH_CHECK'));
Note: See TracChangeset
for help on using the changeset viewer.