Changeset 22581 for branches

Timestamp:

2013/02/22 20:22:51 (11 years ago)

Author:

pineray

Message:

#2160 pageクラスからdtb_newsテーブルを直接指定している箇所をなくす
新着情報管理のページクラス内の処理を他と統一する

Location:

branches/version-2_12-dev/data

Files:

• Smarty/templates/admin/contents/index.tpl (modified) (9 diffs)
• class/helper/SC_Helper_DB.php (modified) (1 diff)
• class/helper/SC_Helper_News.php (added)
• class/pages/admin/contents/LC_Page_Admin_Contents.php (modified) (4 diffs)
• class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_News.php (modified) (7 diffs)
• class/pages/rss/LC_Page_Rss.php (modified) (3 diffs)
• class_extends/helper_extends/SC_Helper_News_Ex.php (added)

branches/version-2_12-dev/data/Smarty/templates/admin/contents/index.tpl

@@ -23 +23 @@
 *}-->
 
-<script type="text/javascript">
-<!--
-
-function func_regist(url) {
-    res = confirm('この内容で<!--{if $edit_mode eq "on"}-->編集<!--{else}-->登録<!--{/if}-->しても宜しいですか？');
-    if(res == true) {
-        document.form1.mode.value = 'regist';
-        document.form1.submit();
-        return false;
-    }
-    return false;
-}
-
-function func_edit(news_id) {
-    document.form1.mode.value = "search";
-    document.form1.news_id.value = news_id;
-    document.form1.submit();
-    return false;
-}
-
-function func_del(news_id) {
-    res = confirm('この新着情報を削除しても宜しいですか？');
-    if(res == true) {
-        document.form1.mode.value = "delete";
-        document.form1.news_id.value = news_id;
-        document.form1.submit();
-    }
-    return false;
-}
-
-function func_rankMove(term,news_id) {
-    document.form1.mode.value = "move";
-    document.form1.news_id.value = news_id;
-    document.form1.term.value = term;
-    document.form1.submit();
-    return false;
-}
-
--->
-</script>
-
-
 <div id="admin-contents" class="contents-main">
 <form name="form1" id="form1" method="post" action="?">
 <input type="hidden" name="<!--{$smarty.const.TRANSACTION_ID_NAME}-->" value="<!--{$transactionid}-->" />
 <input type="hidden" name="mode" value="" />
-<input type="hidden" name="news_id" value="<!--{$arrForm.news_id|h}-->" />
-<input type="hidden" name="term" value="" />
+<input type="hidden" name="news_id" value="<!--{$arrForm.news_id.value|h}-->" />
     <!--{* ▼登録テーブルここから *}-->
     <table>
@@ -79 +36 @@
                 <select name="year" <!--{if $arrErr.year || $arrErr.month || $arrErr.day }-->style="background-color:<!--{$smarty.const.ERR_COLOR|h}-->"<!--{/if}-->>
                     <option value="" selected="selected">----</option>
-                    <!--{html_options options=$arrYear selected=$arrForm.year}-->
+                    <!--{html_options options=$arrYear selected=$arrForm.year.value}-->
                 </select>年
                 <select name="month" <!--{if $arrErr.year || $arrErr.month || $arrErr.day}-->style="background-color:<!--{$smarty.const.ERR_COLOR|h}-->"<!--{/if}-->>
                     <option value="" selected="selected">--</option>
-                    <!--{html_options options=$arrMonth selected=$arrForm.month}-->
+                    <!--{html_options options=$arrMonth selected=$arrForm.month.value}-->
                 </select>月
                 <select name="day" <!--{if $arrErr.year || $arrErr.month || $arrErr.day}-->style="background-color:<!--{$smarty.const.ERR_COLOR|h}-->"<!--{/if}-->>
                     <option value="" selected="selected">--</option>
-                    <!--{html_options options=$arrDay selected=$arrForm.day}-->
+                    <!--{html_options options=$arrDay selected=$arrForm.day.value}-->
                 </select>日
             </td>
@@ -95 +52 @@
             <td>
                 <!--{if $arrErr.news_title}--><span class="attention"><!--{$arrErr.news_title}--></span><!--{/if}-->
-                <textarea name="news_title" cols="60" rows="8" class="area60" maxlength="<!--{$smarty.const.MTEXT_LEN}-->" <!--{if $arrErr.news_title}-->style="background-color:<!--{$smarty.const.ERR_COLOR|h}-->"<!--{/if}-->><!--{"\n"}--><!--{$arrForm.news_title|h}--></textarea><br />
+                <textarea name="news_title" cols="60" rows="8" class="area60" maxlength="<!--{$smarty.const.MTEXT_LEN}-->" <!--{if $arrErr.news_title}-->style="background-color:<!--{$smarty.const.ERR_COLOR|h}-->"<!--{/if}-->><!--{"\n"}--><!--{$arrForm.news_title.value|h}--></textarea><br />
                 <span class="attention"> (上限<!--{$smarty.const.MTEXT_LEN}-->文字)</span>
             </td>
@@ -103 +60 @@
             <td>
                 <span class="attention"><!--{$arrErr.news_url}--></span>
-                <input type="text" name="news_url" size="60" class="box60"    value="<!--{$arrForm.news_url|h}-->" <!--{if $arrErr.news_url}-->style="background-color:<!--{$smarty.const.ERR_COLOR|h}-->"<!--{/if}--> maxlength="<!--{$smarty.const.URL_LEN}-->" />
+                <input type="text" name="news_url" size="60" class="box60"    value="<!--{$arrForm.news_url.value|h}-->" <!--{if $arrErr.news_url}-->style="background-color:<!--{$smarty.const.ERR_COLOR|h}-->"<!--{/if}--> maxlength="<!--{$smarty.const.URL_LEN}-->" />
                 <span class="attention"> (上限<!--{$smarty.const.URL_LEN}-->文字)</span>
             </td>
@@ -109 +66 @@
         <tr>
             <th>リンク</th>
-            <td><label><input type="checkbox" name="link_method" value="2" <!--{if $arrForm.link_method eq 2}--> checked <!--{/if}--> /> 別ウィンドウで開く</label></td>
+            <td><label><input type="checkbox" name="link_method" value="2" <!--{if $arrForm.link_method.value eq 2}--> checked <!--{/if}--> /> 別ウィンドウで開く</label></td>
         </tr>
         <tr>
@@ -115 +72 @@
             <td>
                 <!--{if $arrErr.news_comment}--><span class="attention"><!--{$arrErr.news_comment}--></span><!--{/if}-->
-                <textarea name="news_comment" cols="60" rows="8" wrap="soft" class="area60" maxlength="<!--{$smarty.const.LTEXT_LEN}-->" style="background-color:<!--{if $arrErr.news_comment}--><!--{$smarty.const.ERR_COLOR|h}--><!--{/if}-->"><!--{"\n"}--><!--{$arrForm.news_comment|h}--></textarea><br />
+                <textarea name="news_comment" cols="60" rows="8" wrap="soft" class="area60" maxlength="<!--{$smarty.const.LTEXT_LEN}-->" style="background-color:<!--{if $arrErr.news_comment}--><!--{$smarty.const.ERR_COLOR|h}--><!--{/if}-->"><!--{"\n"}--><!--{$arrForm.news_comment.value|h}--></textarea><br />
                 <span class="attention"> (上限3000文字)</span>
             </td>
@@ -124 +81 @@
     <div class="btn-area">
         <ul>
-            <li><a class="btn-action" href="javascript:;" onclick="return func_regist();"><span class="btn-next">この内容で登録する</span></a></li>
+            <li><a class="btn-action" href="javascript:;" onclick="fnFormModeSubmit('form1', 'edit', '', ''); return false;"><span class="btn-next">この内容で登録する</span></a></li>
         </ul>
     </div>
@@ -137 +94 @@
     <input type="hidden" name="<!--{$smarty.const.TRANSACTION_ID_NAME}-->" value="<!--{$transactionid}-->" />
     <input type="hidden" name="mode" value="moveRankSet" />
-    <input type="hidden" name="term" value="setposition" />
     <input type="hidden" name="news_id" value="" />
     <input type="hidden" name="moveposition" value="" />
@@ -170 +126 @@
             <td>
                 <!--{if $arrNews[data].news_id != $tpl_news_id}-->
-                <a href="#" onclick="return func_edit('<!--{$arrNews[data].news_id|h}-->');">編集</a>
+                <a href="#" onclick="fnFormModeSubmit('move','pre_edit','news_id','<!--{$arrNews[data].news_id|h}-->'); return false;">編集</a>
                 <!--{else}-->
                 編集中
                 <!--{/if}-->
             </td>
-            <td><a href="#" onclick="return func_del('<!--{$arrNews[data].news_id|h}-->');">削除</a></td>
+            <td><a href="#" onclick="fnFormModeSubmit('move','delete','news_id','<!--{$arrNews[data].news_id|h}-->'); return false;">削除</a></td>
             <td>
-            <!--{if count($arrNews) != 1}-->
-            <input type="text" name="pos-<!--{$arrNews[data].news_id|h}-->" size="3" class="box3" />番目へ<a href="?" onclick="fnFormModeSubmit('move', 'moveRankSet','news_id', '<!--{$arrNews[data].news_id|h}-->'); return false;">移動</a><br />
-            <!--{/if}-->
-            <!--{if $arrNews[data].rank ne $max_rank}--><a href="#" onclick="return func_rankMove('up', '<!--{$arrNews[data].news_id|h}-->', '<!--{$max_rank|h}-->');">上へ</a><!--{/if}-->　<!--{if $arrNews[data].rank ne 1}--><a href="#" onclick="return func_rankMove('down', '<!--{$arrNews[data].news_id|h}-->', '<!--{$max_rank|h}-->');">下へ</a><!--{/if}-->
+                <!--{if count($arrNews) != 1}-->
+                <input type="text" name="pos-<!--{$arrNews[data].news_id|h}-->" size="3" class="box3" />番目へ<a href="?" onclick="fnFormModeSubmit('move', 'moveRankSet','news_id', '<!--{$arrNews[data].news_id|h}-->'); return false;">移動</a><br />
+                <!--{/if}-->
+                <!--{if $smarty.section.data.iteration != 1}-->
+                <a href="?" onclick="fnFormModeSubmit('move','up','news_id','<!--{$arrNews[data].news_id|h}-->'); return false;">上へ</a>
+                <!--{/if}-->
+                <!--{if !$smarty.section.data.last}-->
+                <a href="?" onclick="fnFormModeSubmit('move','down','news_id','<!--{$arrNews[data].news_id|h}-->'); return false;">下へ</a>
+                <!--{/if}-->
             </td>
         </tr>

branches/version-2_12-dev/data/class/helper/SC_Helper_DB.php

@@ -1610 +1610 @@
         }
     }
+
+    /**
+     * レコード件数を計算.
+     * 
+     * @param string $table
+     * @param string $where
+     * @param array $arrval
+     * @return integer レコード件数
+     */
+    public function countRecords($table, $where = '', $arrval = array())
+    {
+        $objQuery =& SC_Query_Ex::getSingletonInstance();
+        $col = 'COUNT(*)';
+        return $objQuery->get($col, $table, $where, $arrval);
+    }
 }

branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents.php

@@ -82 +82 @@
     {
 
-        $objDb = new SC_Helper_DB_Ex();
+        $objNews = new SC_Helper_News_Ex();
+
         $objFormParam = new SC_FormParam_Ex();
         $this->lfInitParam($objFormParam);
         $objFormParam->setParam($_POST);
         $objFormParam->convParam();
+
         $news_id = $objFormParam->getValue('news_id');
 
         //---- 新規登録/編集登録
         switch ($this->getMode()) {
-            case 'regist':
-                $arrPost = $objFormParam->getHashArray();
+            case 'edit':
                 $this->arrErr = $this->lfCheckError($objFormParam);
-                if (SC_Utils_Ex::isBlank($this->arrErr)) {
-                    // ニュースIDの値がPOSTされて来た場合は既存データの編集とみなし、
-                    // 更新メソッドを呼び出す。
-                    // ニュースIDが存在しない場合は新規登録を行う。
-                    $arrPost['link_method'] = $this->checkLinkMethod($arrPost['link_method']);
-                    $arrPost['news_date'] = $this->getRegistDate($arrPost);
-                    $member_id = $_SESSION['member_id'];
-                    if (strlen($news_id) > 0 && is_numeric($news_id)) {
-                        $this->lfNewsUpdate($arrPost,$member_id);
-                    } else {
-                        $this->lfNewsInsert($arrPost,$member_id);
+                if (!SC_Utils_Ex::isBlank($this->arrErr['news_id'])) {
+                    trigger_error('', E_USER_ERROR);
+                    return;
+                }
+
+                if (count($this->arrErr) <= 0) {
+                    // POST値の引き継ぎ
+                    $arrParam = $objFormParam->getHashArray();
+                    // 登録実行
+                    $res_news_id = $this->doRegist($news_id, $arrParam, $objNews);
+                    if ($res_news_id !== FALSE) {
+                        // 完了メッセージ
+                        $news_id = $res_news_id;
+                        $this->tpl_onload = "alert('登録が完了しました。');";
                     }
-                    $news_id = '';
-                    $this->tpl_onload = "window.alert('編集が完了しました');";
-                } else {
-                    $this->arrForm = $arrPost;
                 }
-                break;
-            case 'search':
-                if (is_numeric($news_id)) {
-                    list($this->arrForm) = $this->getNews($news_id);
-                    list($this->arrForm['year'],$this->arrForm['month'],$this->arrForm['day']) = $this->splitNewsDate($this->arrForm['cast_news_date']);
-                    $this->edit_mode = 'on';
-                }
-                break;
+                // POSTデータを引き継ぐ
+                $this->tpl_news_id = $news_id;
+                break;
+
+            case 'pre_edit':
+                $news = $objNews->get($news_id);
+                list($news['year'],$news['month'],$news['day']) = $this->splitNewsDate($news['cast_news_date']);
+                $objFormParam->setParam($news);
+
+                // POSTデータを引き継ぐ
+                $this->tpl_news_id = $news_id;
+                break;
+
             case 'delete':
             //----　データ削除
-                if (is_numeric($news_id)) {
-                    $pre_rank = $this->getRankByNewsId($news_id);
-                    $this->computeRankForDelete($news_id,$pre_rank);
-
-                    SC_Response_Ex::reload();             //自分にリダイレクト（再読込による誤動作防止）
-                }
-                break;
-            case 'move':
+                $objNews->delete($news_id);
+                //自分にリダイレクト（再読込による誤動作防止）
+                SC_Response_Ex::reload();
+                break;
+
             //----　表示順位移動
-                if (strlen($news_id) > 0 && is_numeric($news_id) == true) {
-                    $term = $objFormParam->getValue('term');
-                    if ($term == 'up') {
-                        $objDb->sfRankUp('dtb_news', 'news_id', $news_id);
-                    } else if ($term == 'down') {
-                        $objDb->sfRankDown('dtb_news', 'news_id', $news_id);
-                    }
-
-                    $this->objDisplay->reload();
-                }
-                break;
+            case 'up':
+                $objNews->rankUp($news_id);
+
+                // リロード
+                SC_Response_Ex::reload();
+                break;
+
+            case 'down':
+                $objNews->rankDown($news_id);
+
+                // リロード
+                SC_Response_Ex::reload();
+                break;
+
             case 'moveRankSet':
             //----　指定表示順位移動
                 $input_pos = $this->getPostRank($news_id);
                 if (SC_Utils_Ex::sfIsInt($input_pos)) {
-                    $objDb->sfMoveRank('dtb_news', 'news_id', $news_id, $input_pos);
+                    $objNews->moveRank($news_id, $input_pos);
                 }
-                $this->objDisplay->reload();
-                break;
+                SC_Response_Ex::reload();
+                break;
+
             default:
                 break;
         }
 
-        $this->arrNews = $this->getNews();
-        $this->tpl_news_id = $news_id;
+        $this->arrNews = $objNews->getList();
         $this->line_max = count($this->arrNews);
-        $this->max_rank = $this->getRankMax();
-
+
+        $this->arrForm = $objFormParam->getFormParamList();
     }
 
@@ -197 +202 @@
         $objFormParam->addParam('本文', 'news_comment', LTEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK'));
         $objFormParam->addParam('別ウィンドウで開く', 'link_method', INT_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'));
-        $objFormParam->addParam('ランク移動', 'term', INT_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'));
-    }
-
-    /**
-     * 新着記事のデータの登録を行う
-     * @param Array $arrPost POSTデータの配列
-     * @param Integer $member_id 登録した管理者のID
-     */
-    function lfNewsInsert($arrPost,$member_id)
-    {
-        $objQuery = $objQuery =& SC_Query_Ex::getSingletonInstance();
-
-        // rankの最大+1を取得する
-        $rank_max = $this->getRankMax();
-        $rank_max = $rank_max + 1;
-
-        $table = 'dtb_news';
-        $sqlval = array();
-        $news_id = $objQuery->nextVal('dtb_news_news_id');
+    }
+
+    /**
+     * 登録処理を実行.
+     * 
+     * @param integer $news_id
+     * @param array $sqlval
+     * @param object $objNews
+     * @return multiple
+     */
+    function doRegist($news_id, $sqlval, SC_Helper_News_Ex $objNews)
+    {
         $sqlval['news_id'] = $news_id;
-        $sqlval['news_date'] = $arrPost['news_date'];
-        $sqlval['news_title'] = $arrPost['news_title'];
-        $sqlval['creator_id'] = $member_id;
-        $sqlval['news_url'] = $arrPost['news_url'];
-        $sqlval['link_method'] = $arrPost['link_method'];
-        $sqlval['news_comment'] = $arrPost['news_comment'];
-        $sqlval['rank'] = $rank_max;
-        $sqlval['create_date'] = 'CURRENT_TIMESTAMP';
-        $sqlval['update_date'] = 'CURRENT_TIMESTAMP';
-        $objQuery->insert($table, $sqlval);
-    }
-
-    function lfNewsUpdate($arrPost,$member_id)
-    {
-        $objQuery = $objQuery =& SC_Query_Ex::getSingletonInstance();
-
-        $table = 'dtb_news';
-        $sqlval = array();
-        $sqlval['news_date'] = $arrPost['news_date'];
-        $sqlval['news_title'] = $arrPost['news_title'];
-        $sqlval['creator_id'] = $member_id;
-        $sqlval['news_url'] = $arrPost['news_url'];
-        $sqlval['news_comment'] = $arrPost['news_comment'];
-        $sqlval['link_method'] = $arrPost['link_method'];
-        $sqlval['update_date'] = 'CURRENT_TIMESTAMP';
-        $where = 'news_id = ?';
-        $arrValIn = array($arrPost['news_id']);
-        $objQuery->update($table, $sqlval, $where, $arrValIn);
+        $sqlval['creator_id'] = $_SESSION['member_id'];
+        $sqlval['link_method'] = $this->checkLinkMethod($sqlval['link_method']);
+        $sqlval['news_date'] = $this->getRegistDate($sqlval);
+        unset($sqlval['year'], $sqlval['month'], $sqlval['day']);
+        return $objNews->save($sqlval);
     }
 
@@ -272 +247 @@
 
     /**
-     * ニュース記事を取得する。
-     * @param Integer news_id ニュースID
-     */
-    function getNews($news_id = '')
-    {
-        $objQuery = $objQuery =& SC_Query_Ex::getSingletonInstance();
-        $col = '*, cast(news_date as date) as cast_news_date';
-        $table = 'dtb_news';
-        $order = 'rank DESC';
-        if (strlen($news_id) == 0) {
-            $where = 'del_flg = 0';
-            $arrWhereVal = array();
-        } else {
-            $where = 'del_flg = 0 AND news_id = ?';
-            $arrWhereVal = array($news_id);
-        }
-        $objQuery->setOrder($order);
-        return $objQuery->select($col, $table, $where, $arrWhereVal);
-    }
-
-    /**
-     * 指定されたニュースのランクの値を取得する。
-     * @param Integer $news_id
-     */
-    function getRankByNewsId($news_id)
-    {
-        $objQuery = $objQuery =& SC_Query_Ex::getSingletonInstance();
-        $col = 'rank';
-        $table = 'dtb_news';
-        $where = 'del_flg = 0 AND news_id = ?';
-        $arrWhereVal = array($news_id);
-        list($rank) = $objQuery->select($col, $table, $where, $arrWhereVal);
-        return $rank['rank'];
-    }
-
-    /**
-     * 削除する新着情報以降のrankを1つ繰り上げる。
-     * @param Integer $news_id
-     * @param Integer $rank
-     */
-    function computeRankForDelete($news_id,$rank)
-    {
-        SC_Helper_DB_Ex::sfDeleteRankRecord('dtb_news', 'news_id', $news_id);
-    }
-
-    /**
      * ニュースの日付の値をフロントでの表示形式に合わせるために分割
      * @param String $news_date
@@ -324 +253 @@
     {
         return explode('-', $news_date);
-    }
-
-    /**
-     * ランクの最大値の値を返す。
-     * @return Intger $max ランクの最大値の値
-     */
-    function getRankMax()
-    {
-        $objQuery =& SC_Query_Ex::getSingletonInstance();
-        $col = 'MAX(rank) as max';
-        $table = 'dtb_news';
-        $where = 'del_flg = 0';
-        list($result) = $objQuery->select($col, $table, $where);
-        return $result['max'];
     }
 

branches/version-2_12-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_News.php

@@ -67 +67 @@
     {
 
+        $objNews = new SC_Helper_News_Ex();
         $objFormParam = new SC_FormParam_Ex();
         switch ($this->getMode()) {
@@ -75 +76 @@
                 $this->arrErr = $objFormParam->checkError(false);
                 if (empty($this->arrErr)) {
-
-                    $json = $this->lfGetNewsForJson($objFormParam);
+                    $arrData = $objFormParam->getHashArray();
+                    $json = $this->lfGetNewsForJson($arrData, $objNews);
                     echo $json;
                     SC_Response_Ex::actionExit();
@@ -90 +91 @@
                 $this->arrErr = $objFormParam->checkError(false);
                 if (empty($this->arrErr)) {
-
-                    $json = $this->lfGetNewsDetailForJson($objFormParam);
+                    $arrData = $objFormParam->getHashArray();
+                    $json = $this->lfGetNewsDetailForJson($arrData, $objNews);
                     echo $json;
                     SC_Response_Ex::actionExit();
@@ -100 +101 @@
                 break;
             default:
-                $this->newsCount = $this->lfGetNewsCount();
-                $this->arrNews = $this->lfGetNews(SC_Query_Ex::getSingletonInstance());
+                $this->arrNews = $objNews->getList();
+                $this->newsCount = $objNews->getCount();
                 break;
         }
@@ -135 +136 @@
      * @return array $arrNewsList 新着情報の配列を返す
      */
-    function lfGetNews(&$objQuery)
-    {
-        $objQuery->setOrder('rank DESC ');
-        $arrNewsList = $objQuery->select('* , cast(news_date as date) as news_date_disp', 'dtb_news' ,'del_flg = 0');
+    function lfGetNews($dispNumber, $pageNo, SC_Helper_News_Ex $objNews)
+    {
+        $arrNewsList = $objNews->getList($dispNumber, $pageNo);
 
         // モバイルサイトのセッション保持 (#797)
@@ -159 +159 @@
      * (ページと表示件数を指定)
      *
-     * @param array $objFormParam フォームパラメータークラス
+     * @param array $arrData フォーム入力値
+     * @param object $objNews
      * @return String $json 新着情報のJSONを返す
      */
-    function lfGetNewsForJson(&$objFormParam)
-    {
-
-        $objQuery =& SC_Query_Ex::getSingletonInstance();
-        $arrData = $objFormParam->getHashArray();
+    function lfGetNewsForJson($arrData, SC_Helper_News_Ex $objNews)
+    {
 
         $dispNumber = $arrData['disp_number'];
         $pageNo = $arrData['pageno'];
-        if (!empty($dispNumber) && !empty($pageNo)) {
-            $objQuery->setLimitOffset($dispNumber, (($pageNo - 1) * $dispNumber));
-        }
-
-        $arrNewsList = $this->lfGetNews($objQuery);
+        $arrNewsList = $this->lfGetNews($dispNumber, $pageNo, $objNews);
 
         //新着情報の最大ページ数をセット
-        $newsCount = $this->lfGetNewsCount();
+        $newsCount = $objNews->getCount();
         $arrNewsList['news_page_count'] = ceil($newsCount / 3);
 
@@ -189 +183 @@
      * (news_idを指定)
      *
-     * @param array $objFormParam フォームパラメータークラス
+     * @param array $arrData フォーム入力値
+     * @param object $objNews
      * @return String $json 新着情報1件分のJSONを返す
      */
-    function lfGetNewsDetailForJson(&$objFormParam)
-    {
-
-        $objQuery = SC_Query_Ex::getSingletonInstance();
-        $arrData = $objFormParam->getHashArray();
-        $newsId = $arrData['news_id'];
-        $arrNewsList = $objQuery->select(' * , cast(news_date as date) as news_date_disp ',' dtb_news '," del_flg = '0' AND news_id = ? ", array($newsId));
-
+    function lfGetNewsDetailForJson($arrData, SC_Helper_News_Ex $objNews)
+    {
+
+        $arrNewsList = $objNews->get($arrData['news_id']);
         $json =  SC_Utils_Ex::jsonEncode($arrNewsList);    //JSON形式
 
         return $json;
-    }
-
-    /**
-     * 新着情報の件数を取得する
-     *
-     * @return Integer $count 新着情報の件数を返す
-     */
-    function lfGetNewsCount()
-    {
-
-        $count = 0;
-
-        $objQuery = SC_Query_Ex::getSingletonInstance();
-        $count = $objQuery->count('dtb_news', "del_flg = '0'");
-
-        return $count;
     }
 

branches/version-2_12-dev/data/class/pages/rss/LC_Page_Rss.php

@@ -59 +59 @@
     {
 
-        $objQuery = SC_Query_Ex::getSingletonInstance();
         $objView = new SC_SiteView_Ex(false);
 
         //新着情報を取得
-        $arrNews = $this->lfGetNews($objQuery);
+        $arrNews = $this->lfGetNews();
 
         //キャッシュしない(念のため)
@@ -101 +100 @@
      * 新着情報を取得する
      *
-     * @param SC_Query $objQuery DB操作クラス
      * @return array $arrNews 取得結果を配列で返す
      */
-    function lfGetNews(&$objQuery)
+    function lfGetNews()
     {
-        $col = '';
-        $col .= 'news_id ';        // 新着情報ID
-        $col .= ',news_title ';    // 新着情報タイトル
-        $col .= ',news_comment ';  // 新着情報本文
-        $col .= ',news_date ';     // 日付
-        $col .= ',news_url ';      // 新着情報URL
-        $col .= ',news_select ';   // 新着情報の区分(1:URL、2:本文)
-        $col .= ',(SELECT shop_name FROM dtb_baseinfo limit 1) AS shop_name  ';    // 店名
-        $col .= ',(SELECT email04 FROM dtb_baseinfo limit 1) AS email ';           // 代表Emailアドレス
-        $from = 'dtb_news';
-        $where = "del_flg = '0'";
-        $order = 'rank DESC';
-        $objQuery->setOrder($order);
-        $arrNews = $objQuery->select($col,$from,$where);
+        $objNews = new SC_Helper_News_Ex();
+        $arrNews = $objNews->getList();
+
+        $objDb = new SC_Helper_DB_Ex();
+        $arrInfo = $objDb->sfGetBasisData(FALSE, 'shop_name, email04');
 
         // RSS用に変換
@@ -126 +115 @@
 
             $row =& $arrNews[$key];
+            $row['shop_name'] = $arrInfo['shop_name'];
+            $row['email'] = $arrInfo['email04'];
             // 日付
             $row['news_date'] = date('r', strtotime($row['news_date']));