Changeset 20309
- Timestamp:
- 2011/02/21 20:46:15 (13 years ago)
- Location:
- branches/version-2_5-dev/data
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/data/Smarty/templates/admin/products/review_edit.tpl
r20262 r20309 24 24 <form name="form1" id="form1" method="post" action="?"> 25 25 <input type="hidden" name="mode" value="complete" /> 26 <input type="hidden" name="review_id" value="<!--{$arr Review.review_id|h}-->" />26 <input type="hidden" name="review_id" value="<!--{$arrForm.review_id|h}-->" /> 27 27 <!--{foreach key=key item=item from=$arrSearchHidden}--> 28 28 <input type="hidden" name="<!--{$key}-->" value="<!--{$item|h}-->" /> … … 35 35 <tr> 36 36 <th>商品名</th> 37 <td><!--{$arr Review.name|h}-->38 <input type="hidden" name="name" value="<!--{$arr Review.name}-->">37 <td><!--{$arrForm.name|h}--> 38 <input type="hidden" name="name" value="<!--{$arrForm.name|h}-->"> 39 39 </td> 40 40 </tr> 41 41 <tr> 42 42 <th>投稿日</th> 43 <td><!--{$arr Review.create_date|sfDispDBDate}-->44 <input type="hidden" name="create_date" value="<!--{$arr Review.create_date}-->">43 <td><!--{$arrForm.create_date|sfDispDBDate}--> 44 <input type="hidden" name="create_date" value="<!--{$arrForm.create_date|h}-->"> 45 45 </td> 46 46 </tr> … … 49 49 <td> 50 50 <!--{if $arrErr.status}--><span class="attention"><!--{$arrErr.status}--></span><!--{/if}--> 51 <input type="radio" name="status" value="2" <!--{if $arr Review.status eq 2}-->checked<!--{/if}-->>非表示<!--{if $arrReview.status eq 2 && !$tpl_status_change}--><!--{else}--><input type="radio" name="status" value="1" <!--{if $arrReview.status eq 1}-->checked<!--{/if}-->>表示<!--{/if}-->51 <input type="radio" name="status" value="2" <!--{if $arrForm.status eq 2}-->checked<!--{/if}-->>非表示<!--{if $arrForm.status eq 2 && !$tpl_status_change}--><!--{else}--><input type="radio" name="status" value="1" <!--{if $arrForm.status eq 1}-->checked<!--{/if}-->>表示<!--{/if}--> 52 52 </td> 53 53 </tr> … … 56 56 <td> 57 57 <!--{if $arrErr.reviewer_name}--><span class="attention"><!--{$arrErr.reviewer_name}--></span><!--{/if}--> 58 <input type="text" class="box60" name="reviewer_name" value="<!--{$arr Review.reviewer_name|h}-->" style="<!--{$arrErr.reviewer_name|sfGetErrorColor}-->" size=30>58 <input type="text" class="box60" name="reviewer_name" value="<!--{$arrForm.reviewer_name|h}-->" style="<!--{$arrErr.reviewer_name|sfGetErrorColor}-->" size=30> 59 59 </td> 60 60 </tr> … … 63 63 <td> 64 64 <!--{if $arrErr.reviewer_url}--><span class="attention"><!--{$arrErr.reviewer_url}--></span><!--{/if}--> 65 <input type="text" class="box60" name="reviewer_url" maxlength="<!--{$smarty.const.URL_LEN}-->" value="<!--{$arr Review.reviewer_url|h}-->" style="<!--{$arrErr.reviewer_url|sfGetErrorColor}-->" size=30>65 <input type="text" class="box60" name="reviewer_url" maxlength="<!--{$smarty.const.URL_LEN}-->" value="<!--{$arrForm.reviewer_url|h}-->" style="<!--{$arrErr.reviewer_url|sfGetErrorColor}-->" size=30> 66 66 </td> 67 67 </tr> 68 68 <tr> 69 69 <th>性別</th> 70 <td><!--{html_radios_ex name="sex" options=$arrSex selected=$arr Review.sex}--></td>70 <td><!--{html_radios_ex name="sex" options=$arrSex selected=$arrForm.sex}--></td> 71 71 </tr> 72 72 <tr> … … 79 79 <select name="<!--{$key}-->" style="<!--{$arrErr[$key]|sfGetErrorColor}-->" > 80 80 <option value="" selected="selected">選択してください</option> 81 <!--{html_options options=$arrRECOMMEND selected=$arr Review[$key]}-->81 <!--{html_options options=$arrRECOMMEND selected=$arrForm[$key]}--> 82 82 </select> 83 83 </td> … … 87 87 <td> 88 88 <!--{if $arrErr.title}--><span class="attention"><!--{$arrErr.title}--></span><!--{/if}--> 89 <input type="text" class="box60" name="title" value="<!--{$arr Review.title|h}-->" style="<!--{$arrErr.title|sfGetErrorColor}-->" size=30><span class="attention">89 <input type="text" class="box60" name="title" value="<!--{$arrForm.title|h}-->" style="<!--{$arrErr.title|sfGetErrorColor}-->" size=30><span class="attention"> 90 90 </td> 91 91 </tr> … … 94 94 <td> 95 95 <!--{if $arrErr.comment}--><span class="attention"><!--{$arrErr.comment}--></span><!--{/if}--> 96 <textarea name="comment" rows="20" cols="60" class="area60" wrap="soft" style="<!--{$arrErr.comment|sfGetErrorColor}-->" ><!--{$arr Review.comment|h}--></textarea>96 <textarea name="comment" rows="20" cols="60" class="area60" wrap="soft" style="<!--{$arrErr.comment|sfGetErrorColor}-->" ><!--{$arrForm.comment|h}--></textarea> 97 97 </td> 98 98 </tr> -
branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_Review.php
r20262 r20309 56 56 $this->arrRECOMMEND = $masterData->getMasterData("mtb_recommend"); 57 57 $this->arrSex = $masterData->getMasterData("mtb_sex"); 58 58 59 59 $objDate = new SC_Date(); 60 60 // 登録・更新検索開始年 … … 89 89 function action() { 90 90 $objSess = new SC_Session(); 91 92 $objQuery =& SC_Query::getSingletonInstance();93 94 91 // 認証可否の判定 95 92 SC_Utils_Ex::sfIsSuccess($objSess); … … 99 96 $this->lfInitParam($objFormParam); 100 97 $objFormParam->setParam($_POST); 98 $objFormParam->convParam(); 99 // URLを小文字に変換 100 $objFormParam->toLower('search_reviewer_url'); 101 101 102 $this->arrForm = $objFormParam->getHashArray(); 102 103 $this->arrHidden = $this->lfSetHidden($this->arrForm); … … 137 138 } 138 139 139 // 入力エラーチェック 140 /** 141 * 入力内容のチェックを行う. 142 * 143 * @param SC_FormParam $objFormParam SC_FormParam インスタンス 144 * @return void 145 */ 140 146 function lfCheckError(&$objFormParam) { 141 147 // 入力データを渡す。 … … 161 167 } 162 168 163 //レビューの削除 169 /** 170 * 商品レビューの削除 171 * 172 * @param integer $review_id 商品レビューのID 173 * @return void 174 */ 164 175 function lfDeleteReview($review_id) { 165 176 $objQuery =& SC_Query::getSingletonInstance(); … … 168 179 } 169 180 170 // 検索ワードの引き継ぎ 181 /** 182 * hidden情報の作成 183 * 184 * @param array $arrForm フォームデータ 185 * @return array hidden情報 186 */ 171 187 function lfSetHidden($arrForm) { 172 188 $arrHidden = array(); … … 189 205 } 190 206 191 /* パラメータ情報の初期化 */ 207 /** 208 * パラメータ情報の初期化を行う. 209 * 210 * @param SC_FormParam $objFormParam SC_FormParam インスタンス 211 * @return void 212 */ 192 213 function lfInitParam(&$objFormParam) { 193 $objFormParam->addParam("投稿者名", "search_reviewer_name", STEXT_LEN, "KVa ", array("MAX_LENGTH_CHECK"),"",false);194 $objFormParam->addParam("投稿者URL", "search_reviewer_url", STEXT_LEN, "KVa ", array("MAX_LENGTH_CHECK"),"",false);195 $objFormParam->addParam("商品名", "search_name", STEXT_LEN, "KVa ", array("MAX_LENGTH_CHECK"),"",false);196 $objFormParam->addParam("商品コード", "search_product_code", STEXT_LEN, "KVa ", array("MAX_LENGTH_CHECK"),"",false);214 $objFormParam->addParam("投稿者名", "search_reviewer_name", STEXT_LEN, "KVas", array("MAX_LENGTH_CHECK"),"",false); 215 $objFormParam->addParam("投稿者URL", "search_reviewer_url", STEXT_LEN, "KVas", array("MAX_LENGTH_CHECK"),"",false); 216 $objFormParam->addParam("商品名", "search_name", STEXT_LEN, "KVas", array("MAX_LENGTH_CHECK"),"",false); 217 $objFormParam->addParam("商品コード", "search_product_code", STEXT_LEN, "KVas", array("MAX_LENGTH_CHECK"),"",false); 197 218 $objFormParam->addParam("性別", "search_sex", INT_LEN, "n", array("MAX_LENGTH_CHECK"),"",false); 198 219 $objFormParam->addParam("おすすめレベル", "search_recommend_level", INT_LEN, "n", array("MAX_LENGTH_CHECK"),"",false); … … 208 229 } 209 230 210 // CSV ファイル出力実行 231 /** 232 * CSV ファイル出力実行 233 * 234 * @param string $where WHERE文 235 * @param array $arrval WHERE文の判定値 236 * @return void 237 */ 211 238 function lfCsv($where, $arrval) { 212 239 $objCSV = new SC_Helper_CSV_Ex(); … … 220 247 221 248 222 // 検索条件の取得 249 /** 250 * WHERE文の作成 251 * 252 * @param array $arrForm フォームデータ 253 * @return array WHERE文、判定値 254 */ 223 255 function lfGetWhere($arrForm) { 224 256 //削除されていない商品を検索 … … 230 262 switch ($key){ 231 263 case 'search_reviewer_name': 232 $val = mb_convert_kana($val, 's');233 264 $val = preg_replace("/ /", "%", $val); 234 $where.= " AND reviewer_name ILIKE ? ";265 $where.= " AND reviewer_name LIKE ? "; 235 266 $arrval[] = "%$val%"; 236 267 break; 237 268 238 269 case 'search_reviewer_url': 239 $val = mb_convert_kana($val, 's');240 270 $val = preg_replace("/ /", "%", $val); 241 $where.= " AND reviewer_url ILIKE ? ";271 $where.= " AND reviewer_url LIKE ? "; 242 272 $arrval[] = "%$val%"; 243 273 break; 244 274 245 275 case 'search_name': 246 $val = mb_convert_kana($val, 's');247 276 $val = preg_replace("/ /", "%", $val); 248 $where.= " AND name ILIKE ? ";277 $where.= " AND name LIKE ? "; 249 278 $arrval[] = "%$val%"; 250 279 break; 251 280 252 281 case 'search_product_code': 253 $val = mb_convert_kana($val, 's');254 282 $val = preg_replace("/ /", "%", $val); 255 $where.= " AND A.product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? )";283 $where.= " AND A.product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code LIKE ? )"; 256 284 $arrval[] = "%$val%"; 257 285 break; … … 305 333 } 306 334 307 /* 308 * レビューの検索結果取得 335 /** 336 * レビュー検索結果の取得 337 * 338 * @param array $arrForm フォームデータ 339 * @param string $where WHERE文 340 * @param array $arrval WHERE文の判定値 341 * @return array レビュー一覧 309 342 */ 310 343 function lfGetReview($arrForm, $where, $arrval) { -
branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ReviewEdit.php
r20262 r20309 74 74 function action() { 75 75 $objSess = new SC_Session(); 76 $this->objQuery =& SC_Query::getSingletonInstance();77 76 // 認証可否の判定 78 77 SC_Utils_Ex::sfIsSuccess($objSess); … … 85 84 // 検索ワードの引き継ぎ 86 85 $this->arrSearchHidden = $objFormParam->getSearchArray(); 87 $this->arr Review= $objFormParam->getHashArray();88 86 $this->arrForm = $objFormParam->getHashArray(); 87 89 88 switch ($this->getMode()) { 90 89 // 登録 … … 94 93 if (!$this->arrErr) { 95 94 // レビュー情報の更新 96 $this->lfRegistReviewData($ objFormParam);95 $this->lfRegistReviewData($this->arrForm['review_id'], $objFormParam); 97 96 // レビュー情報のDB取得 98 $this->arr Review = $this->lfGetReviewData($this->arrReview['review_id']);97 $this->arrForm = $this->lfGetReviewData($this->arrForm['review_id']); 99 98 $this->tpl_onload = "alert('登録が完了しました。');"; 100 99 } … … 102 101 default: 103 102 // レビュー情報のDB取得 104 $this->arr Review = $this->lfGetReviewData($this->arrReview['review_id']);103 $this->arrForm = $this->lfGetReviewData($this->arrForm['review_id']); 105 104 break; 106 105 } … … 123 122 */ 124 123 function lfInitParam(&$objFormParam) { 125 124 // 検索条件のパラメータを初期化 126 125 parent::lfInitParam($objFormParam); 127 $objFormParam->addParam("レビューID", "review_id");128 129 130 131 126 $objFormParam->addParam("レビューID", "review_id", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 127 $objFormParam->addParam("商品名", "name", "", "", array(), "", false); 128 $objFormParam->addParam("投稿日", "create_date", "", "", array(), "", false); 129 130 // 登録情報 132 131 $objFormParam->addParam("レビュー表示", "status", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 133 132 $objFormParam->addParam("投稿者名", "reviewer_name", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); 134 133 $objFormParam->addParam("投稿者URL", "reviewer_url", URL_LEN, "KVCa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); 135 136 137 134 $objFormParam->addParam("性別", "sex", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 135 $objFormParam->addParam("おすすめレベル", "recommend_level", INT_LEN, "n", array("SELECT_CHECK")); 136 $objFormParam->addParam("タイトル", "title", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); 138 137 $objFormParam->addParam("コメント", "comment", LTEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); 139 } 138 } 140 139 141 140 /** 142 141 * フォーム入力パラメーターエラーチェック 143 142 * … … 146 145 */ 147 146 function lfCheckError(&$objFormParam) { 148 147 $arrErr = $objFormParam->checkError(); 149 148 if (!SC_Utils_Ex::isBlank($arrErr)) { 150 149 return $arrErr; … … 155 154 * レビュー情報のDB取得 156 155 * 156 * @param integer $review_id レビューID 157 * @return array レビュー情報 157 158 */ 158 159 function lfGetReviewData($review_id){ 160 $objQuery =& SC_Query::getSingletonInstance(); 159 161 $select="review_id, A.product_id, reviewer_name, sex, recommend_level, "; 160 162 $select.="reviewer_url, title, comment, A.status, A.create_date, A.update_date, name"; 161 163 $from = "dtb_review AS A LEFT JOIN dtb_products AS B ON A.product_id = B.product_id "; 162 164 $where = "A.del_flg = 0 AND B.del_flg = 0 AND review_id = ? "; 163 $arrReview = $ this->objQuery->select($select, $from, $where, array($review_id));165 $arrReview = $objQuery->select($select, $from, $where, array($review_id)); 164 166 if (empty($arrReview)) { 165 167 SC_Utils_Ex::sfDispError(""); … … 171 173 * レビュー情報の更新 172 174 * 175 * @param integer $review_id レビューID 176 * @param SC_FormParam $objFormParam SC_FormParam インスタンス 177 * @return void 173 178 */ 174 function lfRegistReviewData(&$objFormParam){ 175 $arrValues = $objFormParam->getDbArray(); 179 function lfRegistReviewData($review_id, &$objFormParam){ 180 $objQuery =& SC_Query::getSingletonInstance(); 181 $arrValues = $objFormParam->getDbArray(); 176 182 $arrValues['update_date'] = 'now()'; 177 $ this->objQuery->update("dtb_review", $arrValues, "review_id = ?", array($arrValues['review_id']));183 $objQuery->update("dtb_review", $arrValues, "review_id = ?", array($review_id)); 178 184 } 179 185 }
Note: See TracChangeset
for help on using the changeset viewer.