Index: branches/version-2_5-dev/data/class_extends/page_extends/admin/customer/LC_Page_Admin_Customer_Customer_Ex.php =================================================================== --- branches/version-2_5-dev/data/class_extends/page_extends/admin/customer/LC_Page_Admin_Customer_Customer_Ex.php (revision 19829) +++ branches/version-2_5-dev/data/class_extends/page_extends/admin/customer/LC_Page_Admin_Customer_Customer_Ex.php (revision 19829) @@ -0,0 +1,68 @@ + Index: branches/version-2_5-dev/data/class/pages/admin/customer/LC_Page_Admin_Customer_Customer.php =================================================================== --- branches/version-2_5-dev/data/class/pages/admin/customer/LC_Page_Admin_Customer_Customer.php (revision 19829) +++ branches/version-2_5-dev/data/class/pages/admin/customer/LC_Page_Admin_Customer_Customer.php (revision 19829) @@ -0,0 +1,300 @@ +tpl_mainpage = 'customer/customer.tpl'; + $this->tpl_mainno = 'customer'; + $this->tpl_subnavi = 'customer/subnavi.tpl'; + $this->tpl_subno = 'index'; + $this->tpl_pager = TEMPLATE_REALDIR . 'admin/pager.tpl'; + $this->tpl_subtitle = '顧客登録'; + + $masterData = new SC_DB_MasterData_Ex(); + $this->arrPref = $masterData->getMasterData('mtb_pref'); + $this->arrJob = $masterData->getMasterData("mtb_job"); + $this->arrSex = $masterData->getMasterData("mtb_sex"); + $this->arrReminder = $masterData->getMasterData("mtb_reminder"); + } + + /** + * Page のプロセス. + * + * @return void + */ + function process() { + $this->action(); + $this->sendResponse(); + } + + /** + * Page のアクション. + * + * @return void + */ + function action() { + // 認証可否の判定 + $objSess = new SC_Session(); + SC_Utils_Ex::sfIsSuccess($objSess); + + $this->objQuery = new SC_Query(); + $objDate = new SC_Date(1901); + $this->arrYear = $objDate->getYear(); //　日付プルダウン設定 + $this->arrMonth = $objDate->getMonth(); + $this->arrDay = $objDate->getDay(); + + //---- 登録用カラム配列 + $arrRegistColumn = array( + array( "column" => "name01", "convert" => "aKV" ), + array( "column" => "name02", "convert" => "aKV" ), + array( "column" => "kana01", "convert" => "CKV" ), + array( "column" => "kana02", "convert" => "CKV" ), + array( "column" => "zip01", "convert" => "n" ), + array( "column" => "zip02", "convert" => "n" ), + array( "column" => "pref", "convert" => "n" ), + array( "column" => "addr01", "convert" => "aKV" ), + array( "column" => "addr02", "convert" => "aKV" ), + array( "column" => "email", "convert" => "a" ), + array( "column" => "email_mobile", "convert" => "a" ), + array( "column" => "tel01", "convert" => "n" ), + array( "column" => "tel02", "convert" => "n" ), + array( "column" => "tel03", "convert" => "n" ), + array( "column" => "fax01", "convert" => "n" ), + array( "column" => "fax02", "convert" => "n" ), + array( "column" => "fax03", "convert" => "n" ), + array( "column" => "sex", "convert" => "n" ), + array( "column" => "job", "convert" => "n" ), + array( "column" => "birth", "convert" => "n" ), + array( "column" => "password", "convert" => "a" ), + array( "column" => "reminder", "convert" => "n" ), + array( "column" => "reminder_answer", "convert" => "aKV" ), + array( "column" => "mailmaga_flg", "convert" => "n" ), + array( "column" => "note", "convert" => "aKV" ), + array( "column" => "point", "convert" => "n" ), + array( "column" => "status", "convert" => "n" ) + ); + + //---- 登録除外用カラム配列 + $arrRejectRegistColumn = array("year", "month", "day"); + + //----　顧客情報編集 + if ($_POST["mode"] == "confirm" || $_POST["mode"] == "complete" || $_POST["mode"] == "return") { + + //-- POSTデータの引き継ぎ + $this->arrForm = $_POST; + $this->arrForm['email'] = strtolower($this->arrForm['email']); // emailはすべて小文字で処理 + + //-- 入力データの変換 + $this->arrForm = $this->lfConvertParam($this->arrForm, $arrRegistColumn); + //-- 入力チェック + $this->arrErr = $this->lfErrorCheck($this->arrForm); + + //-- 入力エラー発生 or リターン時 + if ($this->arrErr || $_POST["mode"] == "return") { + foreach($this->arrForm as $key => $val) { + $this->list_data[ $key ] = $val; + } + + } else { + //-- 確認 + if ($_POST["mode"] == "confirm") { + $this->tpl_mainpage = 'customer/customer_confirm.tpl'; + $passlen = strlen($this->arrForm['password']); + $this->passlen = $this->lfPassLen($passlen); + + } + //--　登録 + if($_POST["mode"] == "complete") { + $this->tpl_mainpage = 'customer/customer_complete.tpl'; + + // シークレット№も登録する。 + $secret = SC_Utils_Ex::sfGetUniqRandomId("r"); + $this->arrForm['secret_key'] = $secret; + array_push($arrRegistColumn, array('column' => 'secret_key', 'convert' => 'n')); + + //-- 登録 + $this->lfRegisData($this->arrForm, $arrRegistColumn); + } + } + } + } + + /** + * デストラクタ. + * + * @return void + */ + function destroy() { + parent::destroy(); + } + + // 編集登録 + function lfRegisData($array, $arrRegistColumn) { + + foreach ($arrRegistColumn as $data) { + if($array[$data["column"]] != "") { + $arrRegist[$data["column"]] = $array[$data["column"]]; + } else { + $arrRegist[$data["column"]] = NULL; + } + } + if (strlen($array["year"]) > 0) { + $arrRegist["birth"] = $array["year"] ."/". $array["month"] ."/". $array["day"] ." 00:00:00"; + } + + //-- パスワードの更新がある場合は暗号化。（更新がない場合はUPDATE文を構成しない） + if ($array["password"] != DEFAULT_PASSWORD) { + $arrRegist["password"] = sha1($array["password"] . ":" . AUTH_MAGIC); + } else { + unset($arrRegist['password']); + } + + $arrRegist["update_date"] = "Now()"; + + //-- 編集登録実行 + $this->objQuery->begin(); + $arrRegist['customer_id'] = $this->objQuery->nextVal('dtb_customer_customer_id'); + $this->objQuery->Insert("dtb_customer", $arrRegist); + $this->objQuery->commit(); + } + + + //----　取得文字列の変換 + function lfConvertParam($array, $arrRegistColumn) { + /* + * 文字列の変換 + * K : 「半角(ﾊﾝｶｸ)片仮名」を「全角片仮名」に変換 + * C : 「全角ひら仮名」を「全角かた仮名」に変換 + * V : 濁点付きの文字を一文字に変換。"K","H"と共に使用します + * n : 「全角」数字を「半角(ﾊﾝｶｸ)」に変換 + * a : 全角英数字を半角英数字に変換する + */ + // カラム名とコンバート情報 + foreach ($arrRegistColumn as $data) { + $arrConvList[ $data["column"] ] = $data["convert"]; + } + // 文字変換 + foreach ($arrConvList as $key => $val) { + // POSTされてきた値のみ変換する。 + if(strlen(($array[$key])) > 0) { + $array[$key] = mb_convert_kana($array[$key] ,$val); + } + } + return $array; + } + + //---- 入力エラーチェック + function lfErrorCheck($array) { + + $objErr = new SC_CheckError($array); + + $objErr->doFunc(array("会員状態", 'status'), array("EXIST_CHECK")); + $objErr->doFunc(array("お名前(姓)", 'name01', STEXT_LEN), array("EXIST_CHECK", "MAX_LENGTH_CHECK")); + $objErr->doFunc(array("お名前(名)", 'name02', STEXT_LEN), array("EXIST_CHECK", "MAX_LENGTH_CHECK")); + $objErr->doFunc(array("お名前(フリガナ・姓)", 'kana01', STEXT_LEN), array("EXIST_CHECK", "MAX_LENGTH_CHECK", "KANA_CHECK")); + $objErr->doFunc(array("お名前(フリガナ・名)", 'kana02', STEXT_LEN), array("EXIST_CHECK", "MAX_LENGTH_CHECK", "KANA_CHECK")); + $objErr->doFunc(array("郵便番号1", "zip01", ZIP01_LEN ) ,array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); + $objErr->doFunc(array("郵便番号2", "zip02", ZIP02_LEN ) ,array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); + $objErr->doFunc(array("郵便番号", "zip01", "zip02"), array("ALL_EXIST_CHECK")); + $objErr->doFunc(array("都道府県", 'pref'), array("SELECT_CHECK","NUM_CHECK")); + $objErr->doFunc(array("住所（1）", "addr01", MTEXT_LEN), array("EXIST_CHECK","MAX_LENGTH_CHECK")); + $objErr->doFunc(array("住所（2）", "addr02", MTEXT_LEN), array("EXIST_CHECK","MAX_LENGTH_CHECK")); + $objErr->doFunc(array('メールアドレス', "email", MTEXT_LEN) ,array("EXIST_CHECK", "NO_SPTAB", "EMAIL_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK")); + + //現会員の判定 →　現会員もしくは仮登録中は、メアド一意が前提になってるので同じメアドで登録不可 + if (strlen($array["email"]) > 0) { + $array['email'] = strtolower($array['email']); + $sql = "SELECT customer_id FROM dtb_customer WHERE (email ILIKE ? escape '#' OR email_mobile ILIKE ? escape '#') AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?"; + $checkMail = ereg_replace( "_", "#_", $array["email"]); + $result = $this->objQuery->getAll($sql, array($checkMail, $checkMail, $array["customer_id"])); + if (count($result) > 0) { + $objErr->arrErr["email"] .= "※ すでに登録されているメールアドレスです。
"; + } + } + + $objErr->doFunc(array('メールアドレス(モバイル)', "email_mobile", MTEXT_LEN) ,array("EMAIL_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK")); + //現会員の判定 →　現会員もしくは仮登録中は、メアド一意が前提になってるので同じメアドで登録不可 + if (strlen($array["email_mobile"]) > 0) { + $array['email_mobile'] = strtolower($array['email_mobile']); + $sql = "SELECT customer_id FROM dtb_customer WHERE (email ILIKE ? escape '#' OR email_mobile ILIKE ? escape '#') AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?"; + $checkMail = ereg_replace( "_", "#_", $array["email_mobile"]); + $result = $this->objQuery->getAll($sql, array($checkMail, $checkMail, $array["customer_id"])); + if (count($result) > 0) { + $objErr->arrErr["email_mobile"] .= "※ すでに登録されているメールアドレス(モバイル)です。
"; + } + } + + + $objErr->doFunc(array("お電話番号1", 'tel01'), array("EXIST_CHECK")); + $objErr->doFunc(array("お電話番号2", 'tel02'), array("EXIST_CHECK")); + $objErr->doFunc(array("お電話番号3", 'tel03'), array("EXIST_CHECK")); + $objErr->doFunc(array("お電話番号", "tel01", "tel02", "tel03") ,array("TEL_CHECK")); + $objErr->doFunc(array("FAX番号", "fax01", "fax02", "fax03") ,array("TEL_CHECK")); + $objErr->doFunc(array("ご性別", "sex") ,array("SELECT_CHECK", "NUM_CHECK")); + $objErr->doFunc(array("ご職業", "job") ,array("NUM_CHECK")); + if ($array["password"] != DEFAULT_PASSWORD) { + $objErr->doFunc(array("パスワード", 'password', PASSWORD_LEN1, PASSWORD_LEN2), array("EXIST_CHECK", "ALNUM_CHECK", "NUM_RANGE_CHECK")); + } + $objErr->doFunc(array("パスワードを忘れたときのヒント 質問", "reminder") ,array("SELECT_CHECK", "NUM_CHECK")); + $objErr->doFunc(array("パスワードを忘れたときのヒント 答え", "reminder_answer", STEXT_LEN) ,array("EXIST_CHECK", "MAX_LENGTH_CHECK")); + $objErr->doFunc(array("メールマガジン", "mailmaga_flg") ,array("SELECT_CHECK", "NUM_CHECK")); + $objErr->doFunc(array("生年月日", "year", "month", "day"), array("CHECK_DATE")); + $objErr->doFunc(array("SHOP用メモ", 'note', LTEXT_LEN), array("MAX_LENGTH_CHECK")); + $objErr->doFunc(array("所持ポイント", "point", TEL_LEN) ,array("MAX_LENGTH_CHECK", "NUM_CHECK")); + return $objErr->arrErr; + + } + + + //確認ページ用パスワード表示用 + function lfPassLen($passlen){ + $ret = ""; + for ($i=0;$i<$passlen;true){ + $ret.="*"; + $i++; + } + return $ret; + } + +} +?> Index: branches/version-2_5-dev/data/Smarty/templates/admin/customer/customer_confirm.tpl =================================================================== --- branches/version-2_5-dev/data/Smarty/templates/admin/customer/customer_confirm.tpl (revision 19829) +++ branches/version-2_5-dev/data/Smarty/templates/admin/customer/customer_confirm.tpl (revision 19829) @@ -0,0 +1,133 @@ + + + + +
+ + + + + + + + + + + + /> + + + /> + +
+

顧客編集

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
会員状態 *仮会員本会員
お名前 *　様
お名前(フリガナ) *　様
郵便番号 *〒 -
住所 * +
メールアドレス *
携帯メールアドレス
お電話番号 * - -
FAX - - 未登録
ご性別 *
ご職業
生年月日年月日未登録
パスワード *
パスワードを忘れたときのヒント * + 質問：
+ 答え： +
メールマガジン *HTMLテキスト希望しない
SHOP用メモ
所持ポイント + pt
+
+ 編集画面に戻る + この内容で登録する +
+
+
Index: branches/version-2_5-dev/data/Smarty/templates/admin/customer/customer.tpl =================================================================== --- branches/version-2_5-dev/data/Smarty/templates/admin/customer/customer.tpl (revision 19829) +++ branches/version-2_5-dev/data/Smarty/templates/admin/customer/customer.tpl (revision 19829) @@ -0,0 +1,187 @@ + +
+ +
+

顧客登録

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
会員状態 * + + checked="checked" disabled> + checked="checked" > +
お名前 * + + />   /> +
お名前(フリガナ) * + + />   /> +
郵便番号 * + + 〒 /> - /> + 住所入力 +
住所 * + + + />
+
+ />
+ +
メールアドレス * + + /> +
携帯メールアドレス + + /> +
電話番号 * + + /> - /> - /> +
FAX + + /> - /> - /> +
ご性別 * + + > + + +
ご職業 + + +
生年月日 + + 年 + 月 + 日 +
パスワード * + + />　半角英数小文字～文字（記号不可） +
パスワードを忘れたときのヒント * + + 質問： +
+ 答え： + /> +
メールマガジン * + + checked />HTML　 + checked />テキスト　 + checked />希望しない +
SHOP用メモ + + +
所持ポイント + + size="6" class="box6" /> pt +
+ +
+ 確認ページへ +
+
+
Index: branches/version-2_5-dev/data/Smarty/templates/admin/customer/subnavi.tpl =================================================================== --- branches/version-2_5-dev/data/Smarty/templates/admin/customer/subnavi.tpl (revision 19802) +++ branches/version-2_5-dev/data/Smarty/templates/admin/customer/subnavi.tpl (revision 19829) @@ -24,3 +24,4 @@ Index: branches/version-2_5-dev/data/Smarty/templates/admin/customer/customer_complete.tpl =================================================================== --- branches/version-2_5-dev/data/Smarty/templates/admin/customer/customer_complete.tpl (revision 19829) +++ branches/version-2_5-dev/data/Smarty/templates/admin/customer/customer_complete.tpl (revision 19829) @@ -0,0 +1,35 @@ + +
+ + + + + + +
+

顧客登録

+
登録が完了致しました。
+
+