Changeset 11730 for branches/comu/html/admin/customer/index.php
- Timestamp:
- 2007/03/11 06:27:25 (19 years ago)
- File:
-
- 1 edited
-
branches/comu/html/admin/customer/index.php (modified) (19 diffs)
Legend:
- Unmodified
- Added
- Removed
-
branches/comu/html/admin/customer/index.php
r11729 r11730 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.
