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

Timestamp:

2007/07/20 15:58:59 (19 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/trackback.php (modified) (15 diffs)

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

@@ -20 +20 @@
         $this->tpl_subno = 'trackback';
         $this->tpl_pager = DATA_PATH . 'Smarty/templates/admin/pager.tpl';
-        $this->tpl_subtitle = '¥È¥é¥Ã¥¯¥Ð¥Ã¥¯´ÉÍý';
+        $this->tpl_subtitle = 'トラックバック管理';
     }
 }
@@ -30 +30 @@
 $objQuery = new SC_Query();
 
-// ¾õÂÖ¤ÎÀßÄê
+// 状態の設定
 $objPage->arrTrackBackStatus = $arrTrackBackStatus;
 
-// ÅÐÏ¿¡¦¹¹¿·¸¡º÷³«»Ïǯ
+// 登録・更新検索開始年
 $objDate->setStartYear(RELEASE_YEAR);
 $objDate->setEndYear(DATE("Y"));
@@ -39 +39 @@
 $objPage->arrStartMonth = $objDate->getMonth();
 $objPage->arrStartDay = $objDate->getDay();
-// ÅÐÏ¿¡¦¹¹¿·¸¡º÷½ªÎ»Ç¯
+// 登録・更新検索終了年
 $objDate->setStartYear(RELEASE_YEAR);
 $objDate->setEndYear(DATE("Y"));
@@ -46 +46 @@
 $objPage->arrEndDay = $objDate->getDay();
 
-// ǧ¾Ú²ÄÈݤÎȽÄê
+// 認証可否の判定
 sfIsSuccess($objSess);
 
-// ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¾ðÊó¤Î¥«¥é¥à¤Î¼èÆÀ(view¤È¤Î·ë¹ç¤Î¤¿¤á¡¢¥Æ¡¼¥Ö¥ë¤òA¤ÈÄêµÁ¤·¤Æ¤ª¤¯)
+// トラックバック情報のカラムの取得(viewとの結合のため、テーブルをAと定義しておく)
 $select = "A.trackback_id, A.product_id, A.blog_name, A.title, A.url, ";
 $select .= "A.excerpt, A.status, A.create_date, A.update_date, B.name";
 $from = "dtb_trackback AS A LEFT JOIN dtb_products AS B ON A.product_id = B.product_id ";
 
-// ¸¡º÷¥ï¡¼¥É¤Î°ú¤­·Ñ¤®
+// 検索ワードの引き継ぎ
 foreach ($_POST as $key => $val) {
     if (ereg("^search_", $key)) {
@@ -61 +61 @@
 }
 
-// ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¤Îºï½ü
+// トラックバックの削除
 if ($_POST['mode'] == "delete") {
     $objQuery->exec("UPDATE dtb_trackback SET del_flg = 1, update_date = now() WHERE trackback_id = ?", array($_POST['trackback_id']));
@@ -68 +68 @@
 if ($_POST['mode'] == 'search' || $_POST['mode'] == 'csv' || $_POST['mode'] == 'delete'){
     
-    //ºï½ü¤µ¤ì¤Æ¤¤¤Ê¤¤¾¦Éʤò¸¡º÷
+    //削除されていない商品を検索
     $where="A.del_flg = 0 AND B.del_flg = 0";
     $objPage->arrForm = $_POST;
 
-    //¥¨¥é¡¼¥Á¥§¥Ã¥¯
+    //エラーチェック
     $objPage->arrErr = lfCheckError();
 
@@ -88 +88 @@
                 case 'search_blog_name':
                     $val = ereg_replace(" ", "%", $val);
-                    $val = ereg_replace("¡¡", "%", $val);
+                    $val = ereg_replace("　", "%", $val);
                     $where.= " AND A.blog_name ILIKE ? ";
                     $arrval[] = "%$val%";
@@ -95 +95 @@
                 case 'search_blog_title':
                     $val = ereg_replace(" ", "%", $val);
-                    $val = ereg_replace("¡¡", "%", $val);
+                    $val = ereg_replace("　", "%", $val);
                     $where.= " AND A.title ILIKE ? ";
                     $arrval[] = "%$val%";
@@ -102 +102 @@
                 case 'search_blog_url':
                     $val = ereg_replace(" ", "%", $val);
-                    $val = ereg_replace("¡¡", "%", $val);
+                    $val = ereg_replace("　", "%", $val);
                     $where.= " AND A.url ILIKE ? ";
                     $arrval[] = "%$val%";
@@ -116 +116 @@
                 case 'search_name':
                     $val = ereg_replace(" ", "%", $val);
-                    $val = ereg_replace("¡¡", "%", $val);
+                    $val = ereg_replace("　", "%", $val);
                     $where.= " AND B.name ILIKE ? ";
                     $arrval[] = "%$val%";
@@ -123 +123 @@
                 case 'search_product_code':
                     $val = ereg_replace(" ", "%", $val);
-                    $val = ereg_replace("¡¡", "%", $val);
+                    $val = ereg_replace("　", "%", $val);
                     $where.= " AND B.product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? )";
                     $arrval[] = "%$val%";
@@ -153 +153 @@
     $order = "A.create_date DESC";
     
-    // ¥Ú¡¼¥¸Á÷¤ê¤Î½èÍý
+    // ページ送りの処理
     if(is_numeric($_POST['search_page_max'])) { 
         $page_max = $_POST['search_page_max'];
@@ -163 +163 @@
     $objPage->tpl_linemax = $linemax;
     
-    // ¥Ú¡¼¥¸Á÷¤ê¤Î¼èÆÀ
+    // ページ送りの取得
     $objNavi = new SC_PageNavi($_POST['search_pageno'], $linemax, $page_max, "fnNaviSearchPage", NAVI_PMAX);
     $objPage->arrPagenavi = $objNavi->arrPagenavi;
@@ -170 +170 @@
     $objPage->tpl_pageno = $_POST['search_pageno'];
     
-    // ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È)
+    // 取得範囲の指定(開始行番号、行数のセット)
     $objQuery->setlimitoffset($page_max, $startno);
 
-    // ɽ¼¨½ç½ø
+    // 表示順序
     $objQuery->setorder($order);
     
-    //¸¡º÷·ë²Ì¤Î¼èÆÀ
+    //検索結果の取得
     $objPage->arrTrackback = $objQuery->select($select, $from, $where, $arrval);
     
-    //CSV¥À¥¦¥ó¥í¡¼¥É
+    //CSVダウンロード
     if ($_POST['mode'] == 'csv'){
-        // ¥ª¥×¥·¥ç¥ó¤Î»ØÄê
+        // オプションの指定
         $option = "ORDER BY A.trackback_id";
-        // CSV½ÐÎÏ¥¿¥¤¥È¥ë¹Ô¤ÎºîÀ®
+        // CSV出力タイトル行の作成
         $head = sfGetCSVList($arrTRACKBACK_CVSTITLE);
         $data = lfGetTrackbackCSV($where, '', $arrval);
-        // CSV¤òÁ÷¿®¤¹¤ë¡£
+        // CSVを送信する。
         sfCSVDownload($head.$data);
         exit;
@@ -197 +197 @@
 //-------------------------------------------------------------------------------------
 
-// ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯
+// 入力エラーチェック
 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;
     }