Changeset 15078 for branches/feature-module-update/html/admin/products/review.php

Timestamp:

2007/07/20 15:58:59 (17 years ago)

Author:

nanasess

Message:

r15064 から svn cp
とりあえず暫定コミット.

• UTF-8 に変更
• slib.php, glib.php のクラス化
• LC_Page の抽象化（一部）

Location:

branches/feature-module-update

Files:

• . (copied) (copied from branches/rel) (1 prop)
• html (copied) (copied from branches/rel/html)
• html/admin/products/review.php (modified) (16 diffs)

branches/feature-module-update/html/admin/products/review.php

@@ -24 +24 @@
         $this->tpl_subno = 'review';
         $this->tpl_pager = DATA_PATH . 'Smarty/templates/admin/pager.tpl';
-        $this->tpl_subtitle = '¥ì¥Ó¥å¡¼´ÉÍý';
+        $this->tpl_subtitle = 'レビュー管理';
     }
 }
@@ -34 +34 @@
 $objQuery = new SC_Query();
 
-// ÅÐÏ¿¡¦¹¹¿·¸¡º÷³«»Ïǯ
+// 登録・更新検索開始年
 $objDate->setStartYear(RELEASE_YEAR);
 $objDate->setEndYear(DATE("Y"));
@@ -40 +40 @@
 $objPage->arrStartMonth = $objDate->getMonth();
 $objPage->arrStartDay = $objDate->getDay();
-// ÅÐÏ¿¡¦¹¹¿·¸¡º÷½ªÎ»Ç¯
+// 登録・更新検索終了年
 $objDate->setStartYear(RELEASE_YEAR);
 $objDate->setEndYear(DATE("Y"));
@@ -47 +47 @@
 $objPage->arrEndDay = $objDate->getDay();
 
-// ǧ¾Ú²ÄÈݤÎȽÄê
+// 認証可否の判定
 sfIsSuccess($objSess);
 
-//¥ì¥Ó¥å¡¼¾ðÊó¤Î¥«¥é¥à¤Î¼èÆÀ
+//レビュー情報のカラムの取得
 $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 ";
 
-    // ¸¡º÷¥ï¡¼¥É¤Î°ú¤­·Ñ¤®
+    // 検索ワードの引き継ぎ
     foreach ($_POST as $key => $val) {
         if (ereg("^search_", $key)) {
@@ -74 +74 @@
 
 if ($_POST['mode'] == "delete"){
-    //¥ì¥Ó¥å¡¼¤Îºï½ü
+    //レビューの削除
     $objQuery->exec("UPDATE dtb_review SET del_flg=1 WHERE review_id=?", array($_POST['review_id']));
 }
@@ -80 +80 @@
 if ($_POST['mode'] == 'search' || $_POST['mode'] == 'csv' || $_POST['mode'] == 'delete'){
     
-    //ºï½ü¤µ¤ì¤Æ¤¤¤Ê¤¤¾¦Éʤò¸¡º÷
+    //削除されていない商品を検索
     $where="A.del_flg = 0 AND B.del_flg = 0";
     $objPage->arrForm = $_POST;
@@ -86 +86 @@
         $objPage->arrForm['search_sex'] = split("-", $_POST['search_sex']);
     }
-    //¥¨¥é¡¼¥Á¥§¥Ã¥¯
+    //エラーチェック
     $objPage->arrErr = lfCheckError();
 
@@ -101 +101 @@
             case 'search_reviewer_name':
                 $val = ereg_replace(" ", "%", $val);
-                $val = ereg_replace("¡¡", "%", $val);
+                $val = ereg_replace("　", "%", $val);
                 $where.= " AND reviewer_name ILIKE ? ";
                 $arrval[] = "%$val%";
@@ -108 +108 @@
             case 'search_reviewer_url':
                 $val = ereg_replace(" ", "%", $val);
-                $val = ereg_replace("¡¡", "%", $val);
+                $val = ereg_replace("　", "%", $val);
                 $where.= " AND reviewer_url ILIKE ? ";
                 $arrval[] = "%$val%";
@@ -115 +115 @@
             case 'search_name':
                 $val = ereg_replace(" ", "%", $val);
-                $val = ereg_replace("¡¡", "%", $val);
+                $val = ereg_replace("　", "%", $val);
                 $where.= " AND name ILIKE ? ";
                 $arrval[] = "%$val%";
@@ -122 +122 @@
             case 'search_product_code':
                 $val = ereg_replace(" ", "%", $val);
-                $val = ereg_replace("¡¡", "%", $val);
+                $val = ereg_replace("　", "%", $val);
                 $where.= " AND A.product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? )";
                 $arrval[] = "%$val%";
@@ -129 +129 @@
             case 'search_sex':
                 $tmp_where = "";
-                //$val=ÇÛÎó¤ÎÃæ¿È,$element=³Æ¥­¡¼¤ÎÃÍ(1,2)
+                //$val=配列の中身,$element=各キーの値(1,2)
                 if (is_array($val)){
                     foreach($val as $element) {
@@ -179 +179 @@
     $order = "A.create_date DESC";
     
-    // ¥Ú¡¼¥¸Á÷¤ê¤Î½èÍý
+    // ページ送りの処理
     if(is_numeric($_POST['search_page_max'])) { 
         $page_max = $_POST['search_page_max'];
@@ -189 +189 @@
     $objPage->tpl_linemax = $linemax;
     
-    // ¥Ú¡¼¥¸Á÷¤ê¤Î¼èÆÀ
+    // ページ送りの取得
     $objNavi = new SC_PageNavi($_POST['search_pageno'], $linemax, $page_max, "fnNaviSearchPage", NAVI_PMAX);
     $objPage->arrPagenavi = $objNavi->arrPagenavi;
@@ -196 +196 @@
     $objPage->tpl_pageno = $_POST['search_pageno'];
     
-    // ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È)
+    // 取得範囲の指定(開始行番号、行数のセット)
     $objQuery->setlimitoffset($page_max, $startno);
 
-    // ɽ¼¨½ç½ø
+    // 表示順序
     $objQuery->setorder($order);
     
-    //¸¡º÷·ë²Ì¤Î¼èÆÀ
+    //検索結果の取得
     $objPage->arrReview = $objQuery->select($select, $from, $where, $arrval);
     
-    //CSV¥À¥¦¥ó¥í¡¼¥É
+    //CSVダウンロード
     if ($_POST['mode'] == 'csv'){
-        // ¥ª¥×¥·¥ç¥ó¤Î»ØÄê
+        // オプションの指定
         $option = "ORDER BY review_id";
-        // CSV½ÐÎÏ¥¿¥¤¥È¥ë¹Ô¤ÎºîÀ®
+        // CSV出力タイトル行の作成
         $head = sfGetCSVList($arrREVIEW_CVSTITLE);
         $data = lfGetReviewCSV($where, '', $arrval);
-        // CSV¤òÁ÷¿®¤¹¤ë¡£
+        // CSVを送信する。
         sfCSVDownload($head.$data);
         exit;
@@ -223 +223 @@
 //-------------------------------------------------------------------------------------
 
-// ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯
+// 入力エラーチェック
 function lfCheckError() {
     $objErr = new SC_CheckError();
     switch ($_POST['mode']){
         case 'search':
-        $objErr->doFunc(array("Åê¹Æ¼Ô", "search_startyear", "search_startmonth", "search_startday"), array("CHECK_DATE"));
-        $objErr->doFunc(array("³«»ÏÆü", "search_startyear", "search_startmonth", "search_startday"), array("CHECK_DATE"));
-        $objErr->doFunc(array("½ªÎ»Æü", "search_endyear", "search_endmonth", "search_endday"), array("CHECK_DATE"));
-        $objErr->doFunc(array("³«»ÏÆü", "½ªÎ»Æü", "search_startyear", "search_startmonth", "search_startday", "search_endyear", "search_endmonth", "search_endday"), array("CHECK_SET_TERM"));
+        $objErr->doFunc(array("投稿者", "search_startyear", "search_startmonth", "search_startday"), array("CHECK_DATE"));
+        $objErr->doFunc(array("開始日", "search_startyear", "search_startmonth", "search_startday"), array("CHECK_DATE"));
+        $objErr->doFunc(array("終了日", "search_endyear", "search_endmonth", "search_endday"), array("CHECK_DATE"));
+        $objErr->doFunc(array("開始日", "終了日", "search_startyear", "search_startmonth", "search_startday", "search_endyear", "search_endmonth", "search_endday"), array("CHECK_SET_TERM"));
         break;
         
         case 'complete':
-        $objErr->doFunc(array("¤ª¤¹¤¹¤á¥ì¥Ù¥ë", "recommend_level"), array("SELECT_CHECK"));
-        $objErr->doFunc(array("¥¿¥¤¥È¥ë", "title", STEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
-        $objErr->doFunc(array("¥³¥á¥ó¥È", "comment", LTEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
+        $objErr->doFunc(array("おすすめレベル", "recommend_level"), array("SELECT_CHECK"));
+        $objErr->doFunc(array("タイトル", "title", STEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
+        $objErr->doFunc(array("コメント", "comment", LTEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
         break;
     }