Changeset 20326
- Timestamp:
- 2011/02/22 15:57:30 (13 years ago)
- Location:
- branches/version-2_5-dev/data/class/pages/admin/basis
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php
r20323 r20326 84 84 $this->lfInitParam($mode, $objFormParam); 85 85 $objFormParam->setParam($_POST); 86 $objFormParam->convParam(); 86 87 87 88 $this->arrErr = $this->lfCheckError($mode, $objFormParam); … … 90 91 return; 91 92 } 93 94 $post = $objFormParam->getHashArray(); 92 95 } 93 96 … … 97 100 case 'edit': 98 101 // POST値の引き継ぎ 99 $this->arrForm = $ _POST;102 $this->arrForm = $this->arrForm = $_POST; 100 103 101 104 if(count($this->arrErr) <= 0) { 102 if($ _POST['holiday_id'] == "") {105 if($post['holiday_id'] == "") { 103 106 $this->lfInsertClass($this->arrForm, $_SESSION['member_id']); // 新規作成 104 107 } else { 105 $this->lfUpdateClass($this->arrForm, $ _POST['holiday_id']); // 既存編集108 $this->lfUpdateClass($this->arrForm, $post['holiday_id']); // 既存編集 106 109 } 107 110 // 再表示 … … 109 112 } else { 110 113 // POSTデータを引き継ぐ 111 $this->tpl_holiday_id = $ _POST['holiday_id'];114 $this->tpl_holiday_id = $post['holiday_id']; 112 115 } 113 116 break; 114 117 // 削除 115 118 case 'delete': 116 $objDb->sfDeleteRankRecord("dtb_holiday", "holiday_id", $ _POST['holiday_id'], "", true);119 $objDb->sfDeleteRankRecord("dtb_holiday", "holiday_id", $post['holiday_id'], "", true); 117 120 // 再表示 118 121 $this->objDisplay->reload(); … … 121 124 case 'pre_edit': 122 125 // 編集項目を取得する。 123 $arrHolidayData = $this->lfGetHolidayDataByHolidayID($ _POST['holiday_id']);126 $arrHolidayData = $this->lfGetHolidayDataByHolidayID($post['holiday_id']); 124 127 125 128 // 入力項目にカテゴリ名を入力する。 … … 128 131 $this->arrForm['day'] = $arrHolidayData[0]['day']; 129 132 // POSTデータを引き継ぐ 130 $this->tpl_holiday_id = $ _POST['holiday_id'];133 $this->tpl_holiday_id = $post['holiday_id']; 131 134 break; 132 135 case 'down': 133 $objDb->sfRankDown("dtb_holiday", "holiday_id", $ _POST['holiday_id']);136 $objDb->sfRankDown("dtb_holiday", "holiday_id", $post['holiday_id']); 134 137 // 再表示 135 138 $this->objDisplay->reload(); 136 139 break; 137 140 case 'up': 138 $objDb->sfRankUp("dtb_holiday", "holiday_id", $ _POST['holiday_id']);141 $objDb->sfRankUp("dtb_holiday", "holiday_id", $post['holiday_id']); 139 142 // 再表示 140 143 $this->objDisplay->reload(); … … 189 192 190 193 /* DBへの更新 */ 191 function lfUpdateClass($arrData , $holiday_id) {194 function lfUpdateClass($arrData) { 192 195 $objQuery =& SC_Query::getSingletonInstance(); 193 196 // UPDATEする値を作成する。 … … 198 201 $where = "holiday_id = ?"; 199 202 // UPDATEの実行 200 $ret = $objQuery->update("dtb_holiday", $sqlval, $where, array($ holiday_id));203 $ret = $objQuery->update("dtb_holiday", $sqlval, $where, array($arrData['holiday_id'])); 201 204 return $ret; 202 205 } -
branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Kiyaku.php
r20297 r20326 76 76 77 77 if (!empty($_POST)) { 78 $this->arrErr = $this->lfCheckError($mode, $_POST); 78 $objFormParam = new SC_FormParam(); 79 $this->lfInitParam($mode, $objFormParam); 80 $objFormParam->setParam($_POST); 81 $objFormParam->convParam(); 82 83 $this->arrErr = $this->lfCheckError($mode, $objFormParam); 79 84 if (!empty($this->arrErr['kiyaku_id'])) { 80 85 SC_Utils_Ex::sfDispException(); 81 86 return; 82 87 } 88 $post = $objFormParam->getHashArray(); 83 89 } 84 90 … … 91 97 92 98 if(count($this->arrErr) <= 0) { 93 if($ _POST['kiyaku_id'] == "") {99 if($post['kiyaku_id'] == "") { 94 100 $this->lfInsertClass($this->arrForm, $_SESSION['member_id']); // 新規作成 95 101 } else { 96 $this->lfUpdateClass($this->arrForm, $ _POST['kiyaku_id']); // 既存編集102 $this->lfUpdateClass($this->arrForm, $post['kiyaku_id']); // 既存編集 97 103 } 98 104 // 再表示 … … 100 106 } else { 101 107 // POSTデータを引き継ぐ 102 $this->tpl_kiyaku_id = $ _POST['kiyaku_id'];108 $this->tpl_kiyaku_id = $post['kiyaku_id']; 103 109 } 104 110 break; 105 111 // 削除 106 112 case 'delete': 107 $objDb->sfDeleteRankRecord("dtb_kiyaku", "kiyaku_id", $ _POST['kiyaku_id'], "", true);113 $objDb->sfDeleteRankRecord("dtb_kiyaku", "kiyaku_id", $post['kiyaku_id'], "", true); 108 114 // 再表示 109 115 $this->objDisplay->reload(); … … 112 118 case 'pre_edit': 113 119 // 編集項目を取得する。 114 $arrKiyakuData = $this->lfGetKiyakuDataByKiyakuID($ _POST['kiyaku_id']);120 $arrKiyakuData = $this->lfGetKiyakuDataByKiyakuID($post['kiyaku_id']); 115 121 116 122 // 入力項目にカテゴリ名を入力する。 … … 118 124 $this->arrForm['kiyaku_text'] = $arrKiyakuData[0]['kiyaku_text']; 119 125 // POSTデータを引き継ぐ 120 $this->tpl_kiyaku_id = $ _POST['kiyaku_id'];126 $this->tpl_kiyaku_id = $post['kiyaku_id']; 121 127 break; 122 128 case 'down': 123 $objDb->sfRankDown("dtb_kiyaku", "kiyaku_id", $ _POST['kiyaku_id']);129 $objDb->sfRankDown("dtb_kiyaku", "kiyaku_id", $post['kiyaku_id']); 124 130 // 再表示 125 131 $this->objDisplay->reload(); 126 132 break; 127 133 case 'up': 128 $objDb->sfRankUp("dtb_kiyaku", "kiyaku_id", $ _POST['kiyaku_id']);134 $objDb->sfRankUp("dtb_kiyaku", "kiyaku_id", $post['kiyaku_id']); 129 135 // 再表示 130 136 $this->objDisplay->reload(); … … 190 196 } 191 197 192 /* 取得文字列の変換 */ 193 function lfConvertParam($array) { 194 // 文字変換 195 $arrConvList['kiyaku_title'] = "KVa"; 196 $arrConvList['kiyaku_text'] = "KVa"; 197 198 foreach ($arrConvList as $key => $val) { 199 // POSTされてきた値のみ変換する。 200 if(isset($array[$key])) { 201 $array[$key] = mb_convert_kana($array[$key] ,$val); 202 } 203 } 204 return $array; 205 } 206 207 /** 208 * 入力エラーチェック 209 * 210 * @param string $mode 211 * @return array 212 */ 213 function lfCheckError($mode, $post) { 214 $arrErr = array(); 215 198 function lfInitParam($mode, &$objFormParam) { 216 199 switch ($mode) { 217 200 case 'edit': 218 $_POST = $this->lfConvertParam($post); 219 220 $objErr = new SC_CheckError(); 221 $objErr->doFunc(array("規約タイトル", "kiyaku_title", SMTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); 222 $objErr->doFunc(array("規約内容", "kiyaku_text", MLTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); 223 if(!isset($objErr->arrErr['name'])) { 224 $objQuery =& SC_Query::getSingletonInstance(); 225 $arrRet = $objQuery->select("kiyaku_id, kiyaku_title", "dtb_kiyaku", "del_flg = 0 AND kiyaku_title = ?", array($post['kiyaku_title'])); 226 // 編集中のレコード以外に同じ名称が存在する場合 227 if ($arrRet[0]['kiyaku_id'] != $post['kiyaku_id'] && $arrRet[0]['kiyaku_title'] == $post['kiyaku_title']) { 228 $objErr->arrErr['name'] = "※ 既に同じ内容の登録が存在します。<br>"; 229 } 230 } 201 $objFormParam->addParam('規約タイトル', 'kiyaku_title', SMTEXT_LEN, 'KVa', array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); 202 $objFormParam->addParam('規約内容', 'kiyaku_text', MLTEXT_LEN, 'KVa', array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); 231 203 case 'delete': 232 204 case 'pre_edit': 233 205 case 'down': 234 206 case 'up': 235 $this->objFormParam = new SC_FormParam(); 236 $this->objFormParam->addParam('規約ID', 'kiyaku_id', INT_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK')); 237 $this->objFormParam->setParam($post); 238 $this->objFormParam->convParam(); 239 $arrErr = $this->objFormParam->checkError(); 240 207 $objFormParam->addParam('規約ID', 'kiyaku_id', INT_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK')); 241 208 break; 242 209 default: 243 210 break; 244 211 } 245 return array_merge((array)$objErr->arrErr, (array)$arrErr); 212 } 213 214 /** 215 * 入力エラーチェック 216 * 217 * @param string $mode 218 * @return array 219 */ 220 function lfCheckError($mode, $objFormParam) { 221 $arrErr = $objFormParam->checkError(); 222 if(!isset($arrErr['name']) && $mode == 'edit') { 223 $post = $objFormParam->getHashArray(); 224 $objQuery =& SC_Query::getSingletonInstance(); 225 $arrRet = $objQuery->select("kiyaku_id, kiyaku_title", "dtb_kiyaku", "del_flg = 0 AND kiyaku_title = ?", array($post['kiyaku_title'])); 226 // 編集中のレコード以外に同じ名称が存在する場合 227 if ($arrRet[0]['kiyaku_id'] != $post['kiyaku_id'] && $arrRet[0]['kiyaku_title'] == $post['kiyaku_title']) { 228 $arrErr['name'] = "※ 既に同じ内容の登録が存在します。<br>"; 229 } 230 } 231 return $arrErr; 246 232 } 247 233 } -
branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Mail.php
r20297 r20326 74 74 SC_Utils_Ex::sfIsSuccess($objSess); 75 75 76 $mode = $this->getMode(); 77 78 if (!empty($_POST)) { 79 $objFormParam = new SC_FormParam(); 80 $this->lfInitParam($mode, $objFormParam); 81 $objFormParam->setParam($_POST); 82 $objFormParam->convParam(); 83 84 $this->arrErr = $objFormParam->checkError(); 85 if (!empty($this->arrErr['template_id'])) { 86 SC_Utils_Ex::sfDispException(); 87 return; 88 } 89 $post = $objFormParam->getHashArray(); 90 } 91 76 92 $this->arrMailTEMPLATE = $masterData->getMasterData("mtb_mail_template"); 77 switch ($this->getMode()) { 93 94 switch ($mode) { 78 95 case 'id_set': 79 // テンプレートプルダウン変更時 80 81 if ( SC_Utils_Ex::sfIsInt( $_POST['template_id']) ){ 82 $result = $this->lfGetMailTemplateByTemplateID($_POST['template_id']); 83 if ( $result ){ 96 $result = $this->lfGetMailTemplateByTemplateID($post['template_id']); 97 if ($result){ 84 98 $this->arrForm = $result[0]; 85 99 } else { 86 $this->arrForm['template_id'] = $ _POST['template_id'];100 $this->arrForm['template_id'] = $post['template_id']; 87 101 } 88 }89 102 break; 90 103 case 'regist': 91 if (SC_Utils_Ex::sfIsInt( $_POST['template_id']) ){92 104 93 // POSTデータの引き継ぎ 94 $this->arrForm = $this->lfConvertParam($_POST); 95 $this->arrErr = $this->fnErrorCheck($this->arrForm); 96 97 if ( $this->arrErr ){ 105 $this->arrForm = $post; 106 if ($this->arrErr){ 98 107 // エラーメッセージ 99 108 $this->tpl_msg = "エラーが発生しました"; … … 101 110 } else { 102 111 // 正常 103 $this->lfRegist ($this->arrForm, $_POST['template_id'], $_SESSION['member_id']);112 $this->lfRegistMailTemplate($this->arrForm, $_SESSION['member_id']); 104 113 105 114 // 完了メッセージ … … 107 116 unset($this->arrForm); 108 117 } 109 }110 118 break; 111 119 default: … … 130 138 } 131 139 132 function lfRegist ($data, $template_id, $member_id){140 function lfRegistMailTemplate($post, $member_id){ 133 141 $objQuery =& SC_Query::getSingletonInstance(); 134 142 135 $ data['creator_id'] = $member_id;143 $post['creator_id'] = $member_id; 136 144 137 145 $sql = "SELECT * FROM dtb_mailtemplate WHERE template_id = ?"; 138 $ result = $objQuery->getAll($sql, array($template_id));139 if ( $result){146 $template_data = $objQuery->getAll($sql, array($post['template_id'])); 147 if ($template_data){ 140 148 $sql_where = "template_id = ?"; 141 $objQuery->update("dtb_mailtemplate", $ data, $sql_where, array(addslashes($template_id)));149 $objQuery->update("dtb_mailtemplate", $post, $sql_where, array(addslashes($post['template_id']))); 142 150 }else{ 143 $objQuery->insert("dtb_mailtemplate", $ data);151 $objQuery->insert("dtb_mailtemplate", $post); 144 152 } 145 153 146 154 } 147 155 148 149 function lfConvertParam($array) { 150 151 $new_array["template_id"] = $array["template_id"]; 152 $new_array["subject"] = mb_convert_kana($array["subject"] ,"KV"); 153 $new_array["header"] = mb_convert_kana($array["header"] ,"KV"); 154 $new_array["footer"] = mb_convert_kana($array["footer"] ,"KV"); 155 156 return $new_array; 157 } 158 159 /* 入力エラーのチェック */ 160 function fnErrorCheck($array) { 161 162 $objErr = new SC_CheckError($array); 163 164 $objErr->doFunc(array("テンプレート",'template_id'), array("EXIST_CHECK")); 165 $objErr->doFunc(array("メールタイトル",'subject',MTEXT_LEN,"BIG"), array("EXIST_CHECK", "MAX_LENGTH_CHECK")); 166 $objErr->doFunc(array("ヘッダー",'header',LTEXT_LEN,"BIG"), array("MAX_LENGTH_CHECK")); 167 $objErr->doFunc(array("フッター",'footer',LTEXT_LEN,"BIG"), array("MAX_LENGTH_CHECK")); 168 169 return $objErr->arrErr; 156 function lfInitParam($mode, &$objFormParam) { 157 switch ($mode) { 158 case 'regist': 159 $objFormParam->addParam('メールタイトル', 'subject', MTEXT_LEN, 'KVa', array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); 160 $objFormParam->addParam('ヘッダー', 'header', LTEXT_LEN, 'KVa', array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); 161 $objFormParam->addParam('フッター', 'footer', LTEXT_LEN, 'KVa', array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); 162 case 'id_set': 163 $objFormParam->addParam('テンプレート', 'template_id', INT_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK')); 164 break; 165 default: 166 break; 167 } 170 168 } 171 169 }
Note: See TracChangeset
for help on using the changeset viewer.