Changeset 21606

Timestamp:

2012/03/07 19:57:59 (12 years ago)

Author:

pingpong

Message:

#1437 新着情報管理にて新着情報削除をすると並び順がおかしくなる場合がある の対応

File:

• branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents.php (modified) (1 diff)

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

@@ -318 +318 @@
      */
     function computeRankForDelete($news_id,$rank) {
-        $objQuery = $objQuery =& SC_Query_Ex::getSingletonInstance();
-        $objQuery->begin();
-        $table = 'dtb_news';
-        $sqlval = array();
-        $sqlval['rank'] = $rank;
-        $sqlval['update_date'] = 'CURRENT_TIMESTAMP';
-        $where = 'del_flg = 0 AND rank > ?';
-        $arrValIn = array($rank);
-        $objQuery->update($table, $sqlval, $where, $arrValIn);
-
-        $sqlval = array();
-        $sqlval['rank'] = '0';
-        $sqlval['del_flg'] = '1';
-        $sqlval['update_date'] = 'CURRENT_TIMESTAMP';
-        $where = 'news_id = ?';
-        $arrValIn = array($news_id);
-        $objQuery->update($table, $sqlval, $where, $arrValIn);
-        $objQuery->commit();
+    SC_Helper_DB_Ex::sfDeleteRankRecord('dtb_news', 'news_id', $news_id);
     }