Index: /branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_Review.php
===================================================================
--- /branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_Review.php	(revision 20262)
+++ /branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_Review.php	(revision 20309)
@@ -56,5 +56,5 @@
         $this->arrRECOMMEND = $masterData->getMasterData("mtb_recommend");
         $this->arrSex = $masterData->getMasterData("mtb_sex");
-        
+
         $objDate = new SC_Date();
         // 登録・更新検索開始年
@@ -89,7 +89,4 @@
     function action() {
         $objSess = new SC_Session();
-
-        $objQuery =& SC_Query::getSingletonInstance();
-
         // 認証可否の判定
         SC_Utils_Ex::sfIsSuccess($objSess);
@@ -99,4 +96,8 @@
         $this->lfInitParam($objFormParam);
         $objFormParam->setParam($_POST);
+        $objFormParam->convParam();
+        // URLを小文字に変換
+        $objFormParam->toLower('search_reviewer_url');
+
         $this->arrForm = $objFormParam->getHashArray();
         $this->arrHidden = $this->lfSetHidden($this->arrForm);
@@ -137,5 +138,10 @@
     }
 
-    // 入力エラーチェック
+    /**
+     * 入力内容のチェックを行う.
+     *
+     * @param SC_FormParam $objFormParam SC_FormParam インスタンス
+     * @return void
+     */
     function lfCheckError(&$objFormParam) {
         // 入力データを渡す。
@@ -161,5 +167,10 @@
     }
 
-    //レビューの削除
+    /**
+     * 商品レビューの削除
+     *
+     * @param integer $review_id 商品レビューのID
+     * @return void
+     */
     function lfDeleteReview($review_id) {
         $objQuery =& SC_Query::getSingletonInstance();
@@ -168,5 +179,10 @@
     }
 
-    // 検索ワードの引き継ぎ
+    /**
+     * hidden情報の作成
+     *
+     * @param array $arrForm フォームデータ
+     * @return array hidden情報
+     */
     function lfSetHidden($arrForm) {
         $arrHidden = array();
@@ -189,10 +205,15 @@
     }
 
-    /* パラメータ情報の初期化 */
+    /**
+     * パラメータ情報の初期化を行う.
+     *
+     * @param SC_FormParam $objFormParam SC_FormParam インスタンス
+     * @return void
+     */
     function lfInitParam(&$objFormParam) {
-        $objFormParam->addParam("投稿者名", "search_reviewer_name", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK"),"",false);
-        $objFormParam->addParam("投稿者URL", "search_reviewer_url", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK"),"",false);
-        $objFormParam->addParam("商品名", "search_name", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK"),"",false);
-        $objFormParam->addParam("商品コード", "search_product_code", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK"),"",false);
+        $objFormParam->addParam("投稿者名", "search_reviewer_name", STEXT_LEN, "KVas", array("MAX_LENGTH_CHECK"),"",false);
+        $objFormParam->addParam("投稿者URL", "search_reviewer_url", STEXT_LEN, "KVas", array("MAX_LENGTH_CHECK"),"",false);
+        $objFormParam->addParam("商品名", "search_name", STEXT_LEN, "KVas", array("MAX_LENGTH_CHECK"),"",false);
+        $objFormParam->addParam("商品コード", "search_product_code", STEXT_LEN, "KVas", array("MAX_LENGTH_CHECK"),"",false);
         $objFormParam->addParam("性別", "search_sex", INT_LEN, "n", array("MAX_LENGTH_CHECK"),"",false);
         $objFormParam->addParam("おすすめレベル", "search_recommend_level", INT_LEN, "n", array("MAX_LENGTH_CHECK"),"",false);
@@ -208,5 +229,11 @@
     }
 
-    // CSV ファイル出力実行
+    /**
+     * CSV ファイル出力実行
+     *
+     * @param string $where WHERE文
+     * @param array $arrval WHERE文の判定値
+     * @return void
+     */
     function lfCsv($where, $arrval) {
         $objCSV = new SC_Helper_CSV_Ex();
@@ -220,5 +247,10 @@
 
 
-    // 検索条件の取得
+    /**
+     * WHERE文の作成
+     *
+     * @param array $arrForm フォームデータ
+     * @return array WHERE文、判定値
+     */
     function lfGetWhere($arrForm) {
         //削除されていない商品を検索
@@ -230,28 +262,24 @@
             switch ($key){
             case 'search_reviewer_name':
-                $val = mb_convert_kana($val, 's');
                 $val = preg_replace("/ /", "%", $val);
-                $where.= " AND reviewer_name ILIKE ? ";
+                $where.= " AND reviewer_name LIKE ? ";
                 $arrval[] = "%$val%";
                 break;
 
             case 'search_reviewer_url':
-                $val = mb_convert_kana($val, 's');
                 $val = preg_replace("/ /", "%", $val);
-                $where.= " AND reviewer_url ILIKE ? ";
+                $where.= " AND reviewer_url LIKE ? ";
                 $arrval[] = "%$val%";
                 break;
 
             case 'search_name':
-                $val = mb_convert_kana($val, 's');
                 $val = preg_replace("/ /", "%", $val);
-                $where.= " AND name ILIKE ? ";
+                $where.= " AND name LIKE ? ";
                 $arrval[] = "%$val%";
                 break;
 
             case 'search_product_code':
-                $val = mb_convert_kana($val, 's');
                 $val = preg_replace("/ /", "%", $val);
-                $where.= " AND A.product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? )";
+                $where.= " AND A.product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code LIKE ? )";
                 $arrval[] = "%$val%";
                 break;
@@ -305,6 +333,11 @@
     }
 
-    /*
-     * レビューの検索結果取得
+    /**
+     * レビュー検索結果の取得
+     *
+     * @param array $arrForm フォームデータ
+     * @param string $where WHERE文
+     * @param array $arrval WHERE文の判定値
+     * @return array レビュー一覧
      */
     function lfGetReview($arrForm, $where, $arrval) {
Index: /branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ReviewEdit.php
===================================================================
--- /branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ReviewEdit.php	(revision 20262)
+++ /branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ReviewEdit.php	(revision 20309)
@@ -74,5 +74,4 @@
     function action() {
         $objSess = new SC_Session();
-        $this->objQuery =& SC_Query::getSingletonInstance();
         // 認証可否の判定
         SC_Utils_Ex::sfIsSuccess($objSess);
@@ -85,6 +84,6 @@
         // 検索ワードの引き継ぎ
         $this->arrSearchHidden = $objFormParam->getSearchArray();
-        $this->arrReview = $objFormParam->getHashArray();
-                
+        $this->arrForm = $objFormParam->getHashArray();
+
         switch ($this->getMode()) {
             // 登録
@@ -94,7 +93,7 @@
                 if (!$this->arrErr) {
                     // レビュー情報の更新
-                    $this->lfRegistReviewData($objFormParam);
+                    $this->lfRegistReviewData($this->arrForm['review_id'], $objFormParam);
                     // レビュー情報のDB取得
-                    $this->arrReview = $this->lfGetReviewData($this->arrReview['review_id']);
+                    $this->arrForm = $this->lfGetReviewData($this->arrForm['review_id']);
                     $this->tpl_onload = "alert('登録が完了しました。');";
                 }
@@ -102,5 +101,5 @@
             default:
                 // レビュー情報のDB取得
-                $this->arrReview = $this->lfGetReviewData($this->arrReview['review_id']);
+                $this->arrForm = $this->lfGetReviewData($this->arrForm['review_id']);
                 break;
         }
@@ -123,21 +122,21 @@
      */
     function lfInitParam(&$objFormParam) {
-    	// 検索条件のパラメータを初期化
+        // 検索条件のパラメータを初期化
         parent::lfInitParam($objFormParam);
-    	$objFormParam->addParam("レビューID", "review_id");
-    	$objFormParam->addParam("商品名", "name", "", "", array(), "", false);
-    	$objFormParam->addParam("投稿日", "create_date", "", "", array(), "", false);
-        
-    	// 登録情報
+        $objFormParam->addParam("レビューID", "review_id", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+        $objFormParam->addParam("商品名", "name", "", "", array(), "", false);
+        $objFormParam->addParam("投稿日", "create_date", "", "", array(), "", false);
+
+        // 登録情報
         $objFormParam->addParam("レビュー表示", "status", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
         $objFormParam->addParam("投稿者名", "reviewer_name", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
         $objFormParam->addParam("投稿者URL", "reviewer_url", URL_LEN, "KVCa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK"));
-		$objFormParam->addParam("性別", "sex", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
-		$objFormParam->addParam("おすすめレベル", "recommend_level", INT_LEN, "n", array("SELECT_CHECK"));
-	    $objFormParam->addParam("タイトル", "title", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
+        $objFormParam->addParam("性別", "sex", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
+        $objFormParam->addParam("おすすめレベル", "recommend_level", INT_LEN, "n", array("SELECT_CHECK"));
+        $objFormParam->addParam("タイトル", "title", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
         $objFormParam->addParam("コメント", "comment", LTEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
-	}    
+    }
 
-	/**
+    /**
      * フォーム入力パラメーターエラーチェック
      *
@@ -146,5 +145,5 @@
      */
     function lfCheckError(&$objFormParam) {
-		$arrErr = $objFormParam->checkError();
+        $arrErr = $objFormParam->checkError();
         if (!SC_Utils_Ex::isBlank($arrErr)) {
             return $arrErr;
@@ -155,11 +154,14 @@
      * レビュー情報のDB取得
      *
+     * @param integer $review_id レビューID
+     * @return array レビュー情報
      */
     function lfGetReviewData($review_id){
+        $objQuery =& SC_Query::getSingletonInstance();
         $select="review_id, A.product_id, reviewer_name, sex, recommend_level, ";
         $select.="reviewer_url, title, comment, A.status, A.create_date, A.update_date, name";
         $from = "dtb_review AS A LEFT JOIN dtb_products AS B ON A.product_id = B.product_id ";
         $where = "A.del_flg = 0 AND B.del_flg = 0 AND review_id = ? ";
-        $arrReview = $this->objQuery->select($select, $from, $where, array($review_id));
+        $arrReview = $objQuery->select($select, $from, $where, array($review_id));
         if (empty($arrReview)) {
             SC_Utils_Ex::sfDispError("");
@@ -171,9 +173,13 @@
      * レビュー情報の更新
      *
+     * @param integer $review_id レビューID
+     * @param SC_FormParam $objFormParam SC_FormParam インスタンス
+     * @return void
      */
-    function lfRegistReviewData(&$objFormParam){
-    	$arrValues = $objFormParam->getDbArray();
+    function lfRegistReviewData($review_id, &$objFormParam){
+        $objQuery =& SC_Query::getSingletonInstance();
+        $arrValues = $objFormParam->getDbArray();
         $arrValues['update_date'] = 'now()';
-        $this->objQuery->update("dtb_review", $arrValues, "review_id = ?", array($arrValues['review_id']));
+        $objQuery->update("dtb_review", $arrValues, "review_id = ?", array($review_id));
     }
 }
Index: /branches/version-2_5-dev/data/Smarty/templates/admin/products/review_edit.tpl
===================================================================
--- /branches/version-2_5-dev/data/Smarty/templates/admin/products/review_edit.tpl	(revision 20262)
+++ /branches/version-2_5-dev/data/Smarty/templates/admin/products/review_edit.tpl	(revision 20309)
@@ -24,5 +24,5 @@
 <form name="form1" id="form1" method="post" action="?">
     <input type="hidden" name="mode" value="complete" />
-    <input type="hidden" name="review_id" value="<!--{$arrReview.review_id|h}-->" />
+    <input type="hidden" name="review_id" value="<!--{$arrForm.review_id|h}-->" />
     <!--{foreach key=key item=item from=$arrSearchHidden}-->
         <input type="hidden" name="<!--{$key}-->" value="<!--{$item|h}-->" />
@@ -35,12 +35,12 @@
             <tr>
                 <th>商品名</th>
-                <td><!--{$arrReview.name|h}-->
-                <input type="hidden" name="name" value="<!--{$arrReview.name}-->">
+                <td><!--{$arrForm.name|h}-->
+                <input type="hidden" name="name" value="<!--{$arrForm.name|h}-->">
                 </td>
             </tr>
             <tr>
                 <th>投稿日</th>
-                <td><!--{$arrReview.create_date|sfDispDBDate}-->
-                <input type="hidden" name="create_date" value="<!--{$arrReview.create_date}-->">
+                <td><!--{$arrForm.create_date|sfDispDBDate}-->
+                <input type="hidden" name="create_date" value="<!--{$arrForm.create_date|h}-->">
                 </td>
             </tr>
@@ -49,5 +49,5 @@
                 <td>
                     <!--{if $arrErr.status}--><span class="attention"><!--{$arrErr.status}--></span><!--{/if}-->
-                    <input type="radio" name="status" value="2" <!--{if $arrReview.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}-->
+                    <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}-->
                 </td>
             </tr>
@@ -56,5 +56,5 @@
                 <td>
                     <!--{if $arrErr.reviewer_name}--><span class="attention"><!--{$arrErr.reviewer_name}--></span><!--{/if}-->
-                    <input type="text" class="box60" name="reviewer_name" value="<!--{$arrReview.reviewer_name|h}-->" style="<!--{$arrErr.reviewer_name|sfGetErrorColor}-->" size=30>
+                    <input type="text" class="box60" name="reviewer_name" value="<!--{$arrForm.reviewer_name|h}-->" style="<!--{$arrErr.reviewer_name|sfGetErrorColor}-->" size=30>
                 </td>
             </tr>
@@ -63,10 +63,10 @@
                 <td>
                     <!--{if $arrErr.reviewer_url}--><span class="attention"><!--{$arrErr.reviewer_url}--></span><!--{/if}-->
-                    <input type="text" class="box60" name="reviewer_url" maxlength="<!--{$smarty.const.URL_LEN}-->" value="<!--{$arrReview.reviewer_url|h}-->" style="<!--{$arrErr.reviewer_url|sfGetErrorColor}-->" size=30>
+                    <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>
                 </td>
             </tr>
             <tr>
                 <th>性別</th>
-                <td><!--{html_radios_ex name="sex" options=$arrSex selected=$arrReview.sex}--></td>
+                <td><!--{html_radios_ex name="sex" options=$arrSex selected=$arrForm.sex}--></td>
             </tr>
             <tr>
@@ -79,5 +79,5 @@
                     <select name="<!--{$key}-->" style="<!--{$arrErr[$key]|sfGetErrorColor}-->" >
                     <option value="" selected="selected">選択してください</option>
-                    <!--{html_options options=$arrRECOMMEND selected=$arrReview[$key]}-->
+                    <!--{html_options options=$arrRECOMMEND selected=$arrForm[$key]}-->
                     </select>
                 </td>
@@ -87,5 +87,5 @@
                 <td>
                     <!--{if $arrErr.title}--><span class="attention"><!--{$arrErr.title}--></span><!--{/if}-->
-                    <input type="text" class="box60" name="title" value="<!--{$arrReview.title|h}-->" style="<!--{$arrErr.title|sfGetErrorColor}-->" size=30><span class="attention">
+                    <input type="text" class="box60" name="title" value="<!--{$arrForm.title|h}-->" style="<!--{$arrErr.title|sfGetErrorColor}-->" size=30><span class="attention">
                 </td>
             </tr>
@@ -94,5 +94,5 @@
                 <td>
                     <!--{if $arrErr.comment}--><span class="attention"><!--{$arrErr.comment}--></span><!--{/if}-->
-                    <textarea name="comment" rows="20" cols="60" class="area60" wrap="soft" style="<!--{$arrErr.comment|sfGetErrorColor}-->" ><!--{$arrReview.comment|h}--></textarea>
+                    <textarea name="comment" rows="20" cols="60" class="area60" wrap="soft" style="<!--{$arrErr.comment|sfGetErrorColor}-->" ><!--{$arrForm.comment|h}--></textarea>
                 </td>
             </tr>