Changeset 11729 for branches/comu/html/admin/customer/index.php
- Timestamp:
- 2007/03/10 21:35:02 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/comu/html/admin/customer/index.php
r248 r11729 8 8 require_once(DATA_PATH . "include/csv_output.inc"); 9 9 10 //---- ¥Ú¡¼¥¸É½¼¨ÍÑ¥¯¥é¥¹10 //---- ページ表示用クラス 11 11 class LC_Page { 12 12 var $arrSession; … … 34 34 $this->tpl_subno = 'index'; 35 35 $this->tpl_pager = DATA_PATH . 'Smarty/templates/admin/pager.tpl'; 36 $this->tpl_subtitle = ' ¸ÜµÒ¥Þ¥¹¥¿';36 $this->tpl_subtitle = '顧客マスタ'; 37 37 38 38 global $arrPref; 39 39 $this->arrPref = $arrPref; 40 40 global $arrJob; 41 $arrJob[" ÉÔÌÀ"] = "ÉÔÌÀ";41 $arrJob["不明"] = "不明"; 42 42 $this->arrJob = $arrJob; 43 43 global $arrSex; … … 48 48 global $arrMAILMAGATYPE; 49 49 $this->arrMAILMAGATYPE = $arrMAILMAGATYPE; 50 $this->arrHtmlmail[''] = " ¤¹¤Ù¤Æ";50 $this->arrHtmlmail[''] = "すべて"; 51 51 $this->arrHtmlmail[1] = $arrMAILMAGATYPE[1]; 52 52 $this->arrHtmlmail[2] = $arrMAILMAGATYPE[2]; … … 54 54 } 55 55 56 //---- ¡¡CSV¥À¥¦¥ó¥í¡¼¥ÉÍÑ56 //---- CSVダウンロード用 57 57 $arrColumnCSV= array( 58 0 => array("sql" => "customer_id", "csv" => "customer_id", "header" => " ¸ÜµÒID"),59 1 => array("sql" => "name01", "csv" => "name01", "header" => " ̾Á°1"),60 2 => array("sql" => "name02", "csv" => "name02", "header" => " ̾Á°2"),61 3 => array("sql" => "kana01", "csv" => "kana01", "header" => " ¥Õ¥ê¥¬¥Ê1"),62 4 => array("sql" => "kana02", "csv" => "kana02", "header" => " ¥Õ¥ê¥¬¥Ê2"),63 5 => array("sql" => "zip01", "csv" => "zip01", "header" => " ͹ÊØÈÖ¹æ1"),64 6 => array("sql" => "zip02", "csv" => "zip02", "header" => " ͹ÊØÈÖ¹æ2"),65 7 => array("sql" => "pref", "csv" => "pref", "header" => " ÅÔÆ»Éܸ©"),66 8 => array("sql" => "addr01", "csv" => "addr01", "header" => " ½»½ê1"),67 9 => array("sql" => "addr02", "csv" => "addr02", "header" => " ½»½ê2"),58 0 => array("sql" => "customer_id", "csv" => "customer_id", "header" => "顧客ID"), 59 1 => array("sql" => "name01", "csv" => "name01", "header" => "名前1"), 60 2 => array("sql" => "name02", "csv" => "name02", "header" => "名前2"), 61 3 => array("sql" => "kana01", "csv" => "kana01", "header" => "フリガナ1"), 62 4 => array("sql" => "kana02", "csv" => "kana02", "header" => "フリガナ2"), 63 5 => array("sql" => "zip01", "csv" => "zip01", "header" => "郵便番号1"), 64 6 => array("sql" => "zip02", "csv" => "zip02", "header" => "郵便番号2"), 65 7 => array("sql" => "pref", "csv" => "pref", "header" => "都道府県"), 66 8 => array("sql" => "addr01", "csv" => "addr01", "header" => "住所1"), 67 9 => array("sql" => "addr02", "csv" => "addr02", "header" => "住所2"), 68 68 10 => array("sql" => "email", "csv" => "email", "header" => "E-MAIL"), 69 69 11 => array("sql" => "tel01", "csv" => "tel01", "header" => "TEL1"), … … 73 73 15 => array("sql" => "fax02", "csv" => "fax02", "header" => "FAX2"), 74 74 16 => array("sql" => "fax03", "csv" => "fax03", "header" => "FAX3"), 75 17 => array("sql" => "CASE WHEN sex = 1 THEN ' ÃËÀ' ELSE '½÷À' END AS sex", "csv" => "sex", "header" => "ÀÊÌ"),76 18 => array("sql" => "job", "csv" => "job", "header" => " ¿¦¶È"),77 19 => array("sql" => "cast(birth as date) AS birth", "csv" => "birth", "header" => " ÃÂÀ¸Æü"),78 20 => array("sql" => "cast(first_buy_date as date) AS first_buy_date", "csv" => "first_buy_date", "header" => " ½é²ó¹ØÆþÆü"),79 21 => array("sql" => "cast(last_buy_date as date) AS last_buy_date", "csv" => "last_buy_date", "header" => " ºÇ½ª¹ØÆþÆü"),80 22 => array("sql" => "buy_times", "csv" => "buy_times", "header" => " ¹ØÆþ²ó¿ô"),81 23 => array("sql" => "point", "csv" => "point", "header" => " ¥Ý¥¤¥ó¥È»Ä¹â"),82 24 => array("sql" => "note", "csv" => "note", "header" => " È÷¹Í"),83 25 => array("sql" => "cast(create_date as date) AS create_date", "csv" => "create_date", "header" => " ÅÐÏ¿Æü"),84 26 => array("sql" => "cast(update_date as date) AS update_date", "csv" => "update_date", "header" => " ¹¹¿·Æü")75 17 => array("sql" => "CASE WHEN sex = 1 THEN '男性' ELSE '女性' END AS sex", "csv" => "sex", "header" => "性別"), 76 18 => array("sql" => "job", "csv" => "job", "header" => "職業"), 77 19 => array("sql" => "cast(birth as date) AS birth", "csv" => "birth", "header" => "誕生日"), 78 20 => array("sql" => "cast(first_buy_date as date) AS first_buy_date", "csv" => "first_buy_date", "header" => "初回購入日"), 79 21 => array("sql" => "cast(last_buy_date as date) AS last_buy_date", "csv" => "last_buy_date", "header" => "最終購入日"), 80 22 => array("sql" => "buy_times", "csv" => "buy_times", "header" => "購入回数"), 81 23 => array("sql" => "point", "csv" => "point", "header" => "ポイント残高"), 82 24 => array("sql" => "note", "csv" => "note", "header" => "備考"), 83 25 => array("sql" => "cast(create_date as date) AS create_date", "csv" => "create_date", "header" => "登録日"), 84 26 => array("sql" => "cast(update_date as date) AS update_date", "csv" => "update_date", "header" => "更新日") 85 85 ); 86 86 87 //---- ¥Ú¡¼¥¸½é´üÀßÄê87 //---- ページ初期設定 88 88 $objConn = new SC_DBConn(); 89 89 $objPage = new LC_Page(); 90 90 $objView = new SC_AdminView(); 91 91 $objDate = new SC_Date(1901); 92 $objPage->arrYear = $objDate->getYear(); // ¡¡ÆüÉÕ¥×¥ë¥À¥¦¥óÀßÄê92 $objPage->arrYear = $objDate->getYear(); // 日付プルダウン設定 93 93 $objPage->arrMonth = $objDate->getMonth(); 94 94 $objPage->arrDay = $objDate->getDay(); 95 95 $objPage->objDate = $objDate; 96 96 97 // ǧ¾Ú²ÄÈݤÎȽÄê97 // 認証可否の判定 98 98 $objSess = new SC_Session(); 99 99 sfIsSuccess($objSess); 100 100 101 // POST Ãͤΰú¤·Ñ¤®101 // POST値の引き継ぎ 102 102 $objPage->arrForm = $_POST; 103 103 104 // ¥Ú¡¼¥¸Á÷¤êÍÑ104 // ページ送り用 105 105 $objPage->arrHidden['search_pageno'] = $_POST['search_pageno']; 106 106 107 // ¸¡º÷¥ï¡¼¥É¤Î°ú¤·Ñ¤®107 // 検索ワードの引き継ぎ 108 108 foreach ($_POST as $key => $val) { 109 109 switch($key) { … … 120 120 } 121 121 122 // ¸ÜµÒºï½ü122 // 顧客削除 123 123 if ($_POST['mode'] == "delete") { 124 124 $sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND del_flg = 0"; 125 125 $result_customer = $objConn->getAll($sql, array($_POST["edit_customer_id"])); 126 126 127 if ($result_customer[0]["status"] == 2) { // Ëܲñ°÷ºï½ü127 if ($result_customer[0]["status"] == 2) { //本会員削除 128 128 $arrDel = array("del_flg" => 1, "update_date" => "NOW()"); 129 129 $objConn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["edit_customer_id"]) ); 130 } elseif ($result_customer[0]["status"] == 1) { // ²¾²ñ°÷ºï½ü130 } elseif ($result_customer[0]["status"] == 1) { //仮会員削除 131 131 $sql = "DELETE FROM dtb_customer WHERE customer_id = ?"; 132 132 $objConn->query($sql, array($_POST["edit_customer_id"])); … … 136 136 } 137 137 if ($_POST['mode'] == "search" || $_POST['mode'] == "csv" || $_POST['mode'] == "delete" || $_POST['mode'] == "delete_all") { 138 // ÆþÎÏʸ»ú¤Î¶¯À©ÊÑ´¹138 // 入力文字の強制変換 139 139 lfConvertParam(); 140 // ¥¨¥é¡¼¥Á¥§¥Ã¥¯140 // エラーチェック 141 141 $objPage->arrErr = lfCheckError($objPage->arrForm); 142 142 143 143 $where = "del_flg = 0"; 144 144 145 /* ÆþÎÏ¥¨¥é¡¼¤Ê¤·*/145 /* 入力エラーなし */ 146 146 if (count($objPage->arrErr) == 0) { 147 147 148 //-- ¸¡º÷¥Ç¡¼¥¿¼èÆÀ148 //-- 検索データ取得 149 149 $objSelect = new SC_CustomerList($objPage->arrForm, "customer"); 150 150 151 // ɽ¼¨·ï¿ôÀßÄê151 // 表示件数設定 152 152 $page_rows = $objPage->arrForm['page_rows']; 153 153 if(is_numeric($page_rows)) { … … 177 177 $header = ""; 178 178 179 // CSV ¥«¥é¥à¼èÆÀ179 // CSVカラム取得 180 180 $arrCsvOutput = (sfgetCsvOutput(2, " WHERE csv_id = 2 AND status = 1")); 181 181 … … 190 190 $header .= "\n"; 191 191 192 //- ¡¡ÅÔÆ»Éܸ©/¿¦¶È¤ÎÊÑ´¹192 //- 都道府県/職業の変換 193 193 for($i = 0; $i < count($objPage->search_data); $i ++) { 194 194 $objPage->search_data[$i]["pref"] = $arrPref[ $objPage->search_data[$i]["pref"] ]; … … 196 196 } 197 197 198 //- ¡¡CSV½ÐÎÏ198 //- CSV出力 199 199 $data = lfGetCSVData($objPage->search_data, $arrColumn); 200 200 … … 203 203 break; 204 204 case 'delete_all': 205 // ¸¡º÷·ë²Ì¤ò¤¹¤Ù¤Æºï½ü205 // 検索結果をすべて削除 206 206 $where = "product_id IN (SELECT product_id FROM vw_products_nonclass AS noncls WHERE $where)"; 207 207 $sqlval['del_flg'] = 1; … … 211 211 $result_customer = $objConn->getAll($sql, array($_POST["del_customer_id"])); 212 212 213 if ($result_customer[0]["status"] == 2) { // Ëܲñ°÷ºï½ü213 if ($result_customer[0]["status"] == 2) { //本会員削除 214 214 $arrDel = array("del_flg" => 1, "update_date" => "NOW()"); 215 215 $objConn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["del_customer_id"]) ); 216 } elseif ($result_customer[0]["status"] == 1) { // ²¾²ñ°÷ºï½ü216 } elseif ($result_customer[0]["status"] == 1) { //仮会員削除 217 217 $sql = "DELETE FROM dtb_customer WHERE customer_id = ?"; 218 218 $objConn->query($sql, array($_POST["del_customer_id"])); … … 224 224 default: 225 225 226 // ¹Ô¿ô¤Î¼èÆÀ226 // 行数の取得 227 227 $linemax = $objConn->getOne( $objSelect->getListCount(), $objSelect->arrVal); 228 $objPage->tpl_linemax = $linemax; // ²¿·ï¤¬³ºÅö¤·¤Þ¤·¤¿¡£É½¼¨ÍÑ229 230 // ¥Ú¡¼¥¸Á÷¤ê¤Î¼èÆÀ228 $objPage->tpl_linemax = $linemax; // 何件が該当しました。表示用 229 230 // ページ送りの取得 231 231 $objNavi = new SC_PageNavi($_POST['search_pageno'], $linemax, $page_max, "fnCustomerPage", NAVI_PMAX); 232 232 $startno = $objNavi->start_row; … … 238 238 $objPage->arrCatList = sfGetCategoryList(); 239 239 240 //---- ¡¡¥Ú¡¼¥¸É½¼¨240 //---- ページ表示 241 241 $objView->assignobj($objPage); 242 242 $objView->display(MAIN_FRAME); … … 245 245 //-------------------------------------------------------------------------------------------------------------------------------------- 246 246 247 //---- ¡¡¼èÆÀʸ»úÎó¤ÎÊÑ´¹247 //---- 取得文字列の変換 248 248 function lfConvertParam() { 249 249 global $objPage; 250 250 251 251 /* 252 * ʸ»úÎó¤ÎÊÑ´¹253 * K : ¡ÖȾ³Ñ(Êݶ¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹254 * C : ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹255 * V : ÂùÅÀÉÕ¤¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹256 * n : ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(Êݶ¸)¡×¤ËÊÑ´¹257 * a : Á´³Ñ±Ñ¿ô»ú¤òȾ³Ñ±Ñ¿ô»ú¤ËÊÑ´¹¤¹¤ë252 * 文字列の変換 253 * K : 「半角(ハンカク)片仮名」を「全角片仮名」に変換 254 * C : 「全角ひら仮名」を「全角かた仮名」に変換 255 * V : 濁点付きの文字を一文字に変換。"K","H"と共に使用します 256 * n : 「全角」数字を「半角(ハンカク)」に変換 257 * a : 全角英数字を半角英数字に変換する 258 258 */ 259 // ¥«¥é¥à̾¤È¥³¥ó¥Ð¡¼¥È¾ðÊó259 // カラム名とコンバート情報 260 260 $arrConvList['customer_id'] = "n" ; 261 261 $arrConvList['name'] = "aKV" ; … … 282 282 $arrConvList['end_day'] = "n" ; 283 283 $arrConvList['page_rows'] = "n" ; 284 $arrConvList['buy_start_year'] = "n" ; // ¡¡ºÇ½ª¹ØÆþÆü START ǯ285 $arrConvList['buy_start_month'] = "n" ; // ¡¡ºÇ½ª¹ØÆþÆü START ·î286 $arrConvList['buy_start_day'] = "n" ; // ¡¡ºÇ½ª¹ØÆþÆü START Æü287 $arrConvList['buy_end_year'] = "n" ; // ¡¡ºÇ½ª¹ØÆþÆü END ǯ288 $arrConvList['buy_end_month'] = "n" ; // ¡¡ºÇ½ª¹ØÆþÆü END ·î289 $arrConvList['buy_end_day'] = "n" ; // ¡¡ºÇ½ª¹ØÆþÆü END Æü290 $arrConvList['buy_product_name'] = "aKV" ; // ¡¡¹ØÆþ¾¦ÉÊ̾291 $arrConvList['buy_product_code'] = "aKV" ; // ¡¡¹ØÆþ¾¦ÉÊ¥³¡¼¥É292 $arrConvList['category_id'] = "" ; // ¡¡¥«¥Æ¥´¥ê293 294 // ʸ»úÊÑ´¹284 $arrConvList['buy_start_year'] = "n" ; // 最終購入日 START 年 285 $arrConvList['buy_start_month'] = "n" ; // 最終購入日 START 月 286 $arrConvList['buy_start_day'] = "n" ; // 最終購入日 START 日 287 $arrConvList['buy_end_year'] = "n" ; // 最終購入日 END 年 288 $arrConvList['buy_end_month'] = "n" ; // 最終購入日 END 月 289 $arrConvList['buy_end_day'] = "n" ; // 最終購入日 END 日 290 $arrConvList['buy_product_name'] = "aKV" ; // 購入商品名 291 $arrConvList['buy_product_code'] = "aKV" ; // 購入商品コード 292 $arrConvList['category_id'] = "" ; // カテゴリ 293 294 // 文字変換 295 295 foreach ($arrConvList as $key => $val) { 296 // POST ¤µ¤ì¤Æ¤¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£296 // POSTされてきた値のみ変換する。 297 297 if(isset($objPage->arrForm[$key])) { 298 298 $objPage->arrForm[$key] = mb_convert_kana($objPage->arrForm[$key] ,$val); … … 302 302 303 303 304 //---- ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯304 //---- 入力エラーチェック 305 305 function lfCheckError($array) { 306 306 307 307 $objErr = new SC_CheckError($array); 308 308 309 $objErr->doFunc(array(" ¸ÜµÒ¥³¡¼¥É", "customer_id", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));310 $objErr->doFunc(array(" ÅÔÆ»Éܸ©", "pref", 2), array("NUM_CHECK","MAX_LENGTH_CHECK"));311 $objErr->doFunc(array(" ¸ÜµÒ̾", "name", STEXT_LEN), array("MAX_LENGTH_CHECK"));312 $objErr->doFunc(array(" ¸ÜµÒ̾(¥«¥Ê)", "kana", STEXT_LEN), array("KANA_CHECK", "MAX_LENGTH_CHECK"));313 $objErr->doFunc(array(" ÃÂÀ¸Æü(³«»ÏÆü)", "b_start_year", "b_start_month", "b_start_day"), array("CHECK_DATE"));314 $objErr->doFunc(array(" ÃÂÀ¸Æü(½ªÎ»Æü)", "b_end_year", "b_end_month", "b_end_day"), array("CHECK_DATE"));315 $objErr->doFunc(array(" ÃÂÀ¸Æü(³«»ÏÆü)","ÃÂÀ¸Æü(½ªÎ»Æü)", "b_start_year", "b_start_month", "b_start_day", "b_end_year", "b_end_month", "b_end_day"), array("CHECK_SET_TERM"));316 $objErr->doFunc(array(" ÃÂÀ¸·î", "birth_month", 2), array("NUM_CHECK","MAX_LENGTH_CHECK"));317 $objErr->doFunc(array(' ¥á¡¼¥ë¥¢¥É¥ì¥¹', "email", STEXT_LEN) ,array("EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));318 $objErr->doFunc(array(" ÅÅÏÃÈÖ¹æ", "tel", TEL_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));319 $objErr->doFunc(array(" ¹ØÆþ¶â³Û(³«»Ï)", "buy_total_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));320 $objErr->doFunc(array(" ¹ØÆþ¶â³Û(½ªÎ»)", "buy_total_to", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));321 if ( (is_numeric($array["buy_total_from"]) && is_numeric($array["buy_total_to"]) ) && ($array["buy_total_from"] > $array["buy_total_to"]) ) $objErr->arrErr["buy_total_from"] .= " ¢¨ ¹ØÆþ¶â³Û¤Î»ØÄêÈϰϤ¬ÉÔÀµ¤Ç¤¹¡£";322 $objErr->doFunc(array(" ¹ØÆþ²ó¿ô(³«»Ï)", "buy_times_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));323 $objErr->doFunc(array(" ¹ØÆþ²ó¿ô(½ªÎ»)", "buy_times_to", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));324 if ( (is_numeric($array["buy_times_from"]) && is_numeric($array["buy_times_to"]) ) && ($array["buy_times_from"] > $array["buy_times_to"]) ) $objErr->arrErr["buy_times_from"] .= " ¢¨ ¹ØÆþ²ó¿ô¤Î»ØÄêÈϰϤ¬ÉÔÀµ¤Ç¤¹¡£";325 $objErr->doFunc(array(" ÅÐÏ¿¡¦¹¹¿·Æü(³«»ÏÆü)", "start_year", "start_month", "start_day",), array("CHECK_DATE"));326 $objErr->doFunc(array(" ÅÐÏ¿¡¦¹¹¿·Æü(½ªÎ»Æü)", "end_year", "end_month", "end_day"), array("CHECK_DATE"));327 $objErr->doFunc(array(" ÅÐÏ¿¡¦¹¹¿·Æü(³«»ÏÆü)","ÅÐÏ¿¡¦¹¹¿·Æü(½ªÎ»Æü)", "start_year", "start_month", "start_day", "end_year", "end_month", "end_day"), array("CHECK_SET_TERM"));328 $objErr->doFunc(array(" ɽ¼¨·ï¿ô", "page_rows", 3), array("NUM_CHECK","MAX_LENGTH_CHECK"));329 $objErr->doFunc(array(" ºÇ½ª¹ØÆþÆü(³«»ÏÆü)", "buy_start_year", "buy_start_month", "buy_start_day",), array("CHECK_DATE")); //ºÇ½ª¹ØÆþÆü(³«»ÏÆü)330 $objErr->doFunc(array(" ºÇ½ª¹ØÆþ(½ªÎ»Æü)", "buy_end_year", "buy_end_month", "buy_end_day"), array("CHECK_DATE")); //ºÇ½ª¹ØÆþÆü(½ªÎ»Æü)331 // ¹ØÆþ¶â³Û(from) ¡ä ¹ØÆþ¶â³Û(to) ¤Î¾ì¹ç¤Ï¥¨¥é¡¼¤È¤¹¤ë332 $objErr->doFunc(array(" ºÇ½ª¹ØÆþÆü(³«»ÏÆü)","ÅÐÏ¿¡¦¹¹¿·Æü(½ªÎ»Æü)", "buy_start_year", "buy_start_month", "buy_start_day", "buy_end_year", "buy_end_month", "buy_end_day"), array("CHECK_SET_TERM"));333 $objErr->doFunc(array(" ¹ØÆþ¾¦ÉÊ¥³¡¼¥É", "buy_product_code", STEXT_LEN), array("MAX_LENGTH_CHECK")); //¹ØÆþ¾¦ÉÊ¥³¡¼¥É334 $objErr->doFunc(array(" ¹ØÆþ¾¦ÉÊ̾", "buy_product_name", STEXT_LEN), array("MAX_LENGTH_CHECK")); //¹ØÆþ¾¦ÉÊ̾¾Î309 $objErr->doFunc(array("顧客コード", "customer_id", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); 310 $objErr->doFunc(array("都道府県", "pref", 2), array("NUM_CHECK","MAX_LENGTH_CHECK")); 311 $objErr->doFunc(array("顧客名", "name", STEXT_LEN), array("MAX_LENGTH_CHECK")); 312 $objErr->doFunc(array("顧客名(カナ)", "kana", STEXT_LEN), array("KANA_CHECK", "MAX_LENGTH_CHECK")); 313 $objErr->doFunc(array("誕生日(開始日)", "b_start_year", "b_start_month", "b_start_day"), array("CHECK_DATE")); 314 $objErr->doFunc(array("誕生日(終了日)", "b_end_year", "b_end_month", "b_end_day"), array("CHECK_DATE")); 315 $objErr->doFunc(array("誕生日(開始日)","誕生日(終了日)", "b_start_year", "b_start_month", "b_start_day", "b_end_year", "b_end_month", "b_end_day"), array("CHECK_SET_TERM")); 316 $objErr->doFunc(array("誕生月", "birth_month", 2), array("NUM_CHECK","MAX_LENGTH_CHECK")); 317 $objErr->doFunc(array('メールアドレス', "email", STEXT_LEN) ,array("EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK")); 318 $objErr->doFunc(array("電話番号", "tel", TEL_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); 319 $objErr->doFunc(array("購入金額(開始)", "buy_total_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); 320 $objErr->doFunc(array("購入金額(終了)", "buy_total_to", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); 321 if ( (is_numeric($array["buy_total_from"]) && is_numeric($array["buy_total_to"]) ) && ($array["buy_total_from"] > $array["buy_total_to"]) ) $objErr->arrErr["buy_total_from"] .= "※ 購入金額の指定範囲が不正です。"; 322 $objErr->doFunc(array("購入回数(開始)", "buy_times_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); 323 $objErr->doFunc(array("購入回数(終了)", "buy_times_to", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); 324 if ( (is_numeric($array["buy_times_from"]) && is_numeric($array["buy_times_to"]) ) && ($array["buy_times_from"] > $array["buy_times_to"]) ) $objErr->arrErr["buy_times_from"] .= "※ 購入回数の指定範囲が不正です。"; 325 $objErr->doFunc(array("登録・更新日(開始日)", "start_year", "start_month", "start_day",), array("CHECK_DATE")); 326 $objErr->doFunc(array("登録・更新日(終了日)", "end_year", "end_month", "end_day"), array("CHECK_DATE")); 327 $objErr->doFunc(array("登録・更新日(開始日)","登録・更新日(終了日)", "start_year", "start_month", "start_day", "end_year", "end_month", "end_day"), array("CHECK_SET_TERM")); 328 $objErr->doFunc(array("表示件数", "page_rows", 3), array("NUM_CHECK","MAX_LENGTH_CHECK")); 329 $objErr->doFunc(array("最終購入日(開始日)", "buy_start_year", "buy_start_month", "buy_start_day",), array("CHECK_DATE")); //最終購入日(開始日) 330 $objErr->doFunc(array("最終購入(終了日)", "buy_end_year", "buy_end_month", "buy_end_day"), array("CHECK_DATE")); //最終購入日(終了日) 331 //購入金額(from) > 購入金額(to) の場合はエラーとする 332 $objErr->doFunc(array("最終購入日(開始日)","登録・更新日(終了日)", "buy_start_year", "buy_start_month", "buy_start_day", "buy_end_year", "buy_end_month", "buy_end_day"), array("CHECK_SET_TERM")); 333 $objErr->doFunc(array("購入商品コード", "buy_product_code", STEXT_LEN), array("MAX_LENGTH_CHECK")); //購入商品コード 334 $objErr->doFunc(array("購入商品名", "buy_product_name", STEXT_LEN), array("MAX_LENGTH_CHECK")); //購入商品名称 335 335 336 336 return $objErr->arrErr; … … 409 409 } 410 410 411 //---- CSV ½ÐÎÏÍѥǡ¼¥¿¼èÆÀ411 //---- CSV出力用データ取得 412 412 function lfGetCSVData( $array, $arrayIndex){ 413 413 … … 418 418 $return .= "\""; 419 419 if ( $arrayIndex ){ 420 $return .= mb_ereg_replace("<"," ¡ã",mb_ereg_replace( "\"","\"\"",$array[$i][$arrayIndex[$j]] )) ."\"";420 $return .= mb_ereg_replace("<","<",mb_ereg_replace( "\"","\"\"",$array[$i][$arrayIndex[$j]] )) ."\""; 421 421 } else { 422 $return .= mb_ereg_replace("<"," ¡ã",mb_ereg_replace( "\"","\"\"",$array[$i][$j] )) ."\"";422 $return .= mb_ereg_replace("<","<",mb_ereg_replace( "\"","\"\"",$array[$i][$j] )) ."\""; 423 423 } 424 424 }
Note: See TracChangeset
for help on using the changeset viewer.