Changeset 18770 for branches/version-2_5-dev/data/class/pages/admin/system

Timestamp:

2010/08/03 14:06:25 (16 years ago)

Author:

nanasess

bzr:base-revision:

[email protected]

bzr:committer:

Kentaro Ohkouchi <[email protected]>

bzr:file-ids:

data/class/SC_Customer.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2FSC_Customer.php
data/class/helper/SC_Helper_Mobile.php 15277@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fhelper%2FSC_Helper_Mobile.php
data/class/pages/LC_Page_Sitemap.php 16385@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2FLC_Page_Sitemap.php
data/class/pages/admin/contents/LC_Page_Admin_Contents.php 15659@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fcontents%2FLC_Page_Admin_Contents.php
data/class/pages/admin/contents/LC_Page_Admin_Contents_CsvSql.php 16449@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fcontents%2FLC_Page_Admin_Contents_CsvSql.php
data/class/pages/admin/design/LC_Page_Admin_Design.php 15680@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fdesign%2FLC_Page_Admin_Design.php
data/class/pages/admin/design/LC_Page_Admin_Design_Bloc.php 15687@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fdesign%2FLC_Page_Admin_Design_Bloc.php
data/class/pages/admin/design/LC_Page_Admin_Design_MainEdit.php 15682@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fdesign%2FLC_Page_Admin_Design_MainEdit.php
data/class/pages/admin/mail/LC_Page_Admin_Mail_Sendmail.php 16321@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fmail%2FLC_Page_Admin_Mail_Sendmail.php
data/class/pages/admin/system/LC_Page_Admin_System_Rank.php 16829@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fsystem%2FLC_Page_Admin_System_Rank.php
data/class/pages/entry/LC_Page_Entry.php 15141@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fentry%2FLC_Page_Entry.php
data/class/pages/mypage/LC_Page_Mypage_Change.php 16070@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fmypage%2FLC_Page_Mypage_Change.php
data/class/pages/mypage/LC_Page_Mypage_Favorite.php 17162@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fcomu-ver2%2Fdata%2Fclass%2Fpages%2Fmypage%2FLC_Page_Mypage_Favorite.php
data/class/pages/products/LC_Page_Products_Detail.php 15154@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fproducts%2FLC_Page_Products_Detail.php

bzr:mapping-version:

v4

bzr:repository-uuid:

1e3b908f-19a9-db11-a64c-001125224ba8

bzr:revision-id:

[email protected]

bzr:revno:

2253

bzr:revprop:branch-nick:

branches/version-2_5-dev

bzr:root:

branches/version-2_5-dev

bzr:text-parents:

data/class/SC_Customer.php [email protected]
data/class/helper/SC_Helper_Mobile.php [email protected]
data/class/pages/LC_Page_Sitemap.php [email protected]
data/class/pages/admin/contents/LC_Page_Admin_Contents.php [email protected]
data/class/pages/admin/contents/LC_Page_Admin_Contents_CsvSql.php [email protected]
data/class/pages/admin/design/LC_Page_Admin_Design.php [email protected]
data/class/pages/admin/design/LC_Page_Admin_Design_Bloc.php [email protected]
data/class/pages/admin/design/LC_Page_Admin_Design_MainEdit.php [email protected]
data/class/pages/admin/mail/LC_Page_Admin_Mail_Sendmail.php [email protected]
data/class/pages/admin/system/LC_Page_Admin_System_Rank.php [email protected]
data/class/pages/entry/LC_Page_Entry.php [email protected]
data/class/pages/mypage/LC_Page_Mypage_Change.php [email protected]
data/class/pages/mypage/LC_Page_Mypage_Favorite.php [email protected]
data/class/pages/products/LC_Page_Products_Detail.php [email protected]

bzr:timestamp:

2010-08-03 14:06:21.516999960 +0900

bzr:user-agent:

bzr2.1.2+bzr-svn1.0.2

svn:original-date:

2010-08-03T05:06:21.517000Z

Message:

• SC_DbConn のインスタンスを直接使用している個所を SC_Query に変更(#565)
  • 削除予定の機能については未対応
• SC_Customer で未使用の処理を削除

File:

• branches/version-2_5-dev/data/class/pages/admin/system/LC_Page_Admin_System_Rank.php (modified) (4 diffs)

branches/version-2_5-dev/data/class/pages/admin/system/LC_Page_Admin_System_Rank.php

@@ -51 +51 @@
      */
     function process() {
-        $conn = new SC_DbConn();
+        $objQuery = new SC_Query();
 
         // ログインチェック
@@ -60 +60 @@
             // 正当な数値であった場合
             if(SC_Utils::sfIsInt($_GET['id'])){
-                $this->lfRunkUp($conn, $_GET['id']);
+                $this->lfRunkUp($objQuery, $_GET['id']);
             // エラー処理
             } else {
@@ -67 +67 @@
         } else if($_GET['move'] == 'down') {
             if(SC_Utils::sfIsInt($_GET['id'])){
-                $this->lfRunkDown($conn, $_GET['id']);
+                $this->lfRunkDown($objQuery, $_GET['id']);
             // エラー処理
             } else {
@@ -88 +88 @@
 
     // ランキングを上げる。
-    function lfRunkUp($conn, $id) {
+    function lfRunkUp($objQuery, $id) {
         // 自身のランクを取得する。
-        $rank = $conn->getOne("SELECT rank FROM dtb_member WHERE member_id = ".$id);
+        $rank = $objQuery->getOne("SELECT rank FROM dtb_member WHERE member_id = ".$id);
         // ランクの最大値を取得する。
-        $maxno = $conn->getOne("SELECT max(rank) FROM dtb_member");
+        $maxno = $objQuery->getOne("SELECT max(rank) FROM dtb_member");
         // ランクが最大値よりも小さい場合に実行する。
         if($rank < $maxno) {
             // ランクがひとつ上のIDを取得する。
             $sqlse = "SELECT member_id FROM dtb_member WHERE rank = ?";
-            $up_id = $conn->getOne($sqlse, $rank + 1);
+            $up_id = $objQuery->getOne($sqlse, $rank + 1);
             // ランク入れ替えの実行
-            $conn->query("BEGIN");
+            $objQuery->begin();
             $sqlup = "UPDATE dtb_member SET rank = ? WHERE member_id = ?";
-            $conn->query($sqlup, array($rank + 1, $id));
-            $conn->query($sqlup, array($rank, $up_id));
-            $conn->query("COMMIT");
+            $objQuery->query($sqlup, array($rank + 1, $id));
+            $objQuery->query($sqlup, array($rank, $up_id));
+            $objQuery->commit();
         }
     }
 
     // ランキングを下げる。
-    function lfRunkDown($conn, $id) {
+    function lfRunkDown($objQuery, $id) {
         // 自身のランクを取得する。
-        $rank = $conn->getOne("SELECT rank FROM dtb_member WHERE member_id = ".$id);
+        $rank = $objQuery->getOne("SELECT rank FROM dtb_member WHERE member_id = ".$id);
         // ランクの最小値を取得する。
-        $minno = $conn->getOne("SELECT min(rank) FROM dtb_member");
+        $minno = $objQuery->getOne("SELECT min(rank) FROM dtb_member");
         // ランクが最大値よりも大きい場合に実行する。
         if($rank > $minno) {
             // ランクがひとつ下のIDを取得する。
             $sqlse = "SELECT member_id FROM dtb_member WHERE rank = ?";
-            $down_id = $conn->getOne($sqlse, $rank - 1);
+            $down_id = $objQuery->getOne($sqlse, $rank - 1);
             // ランク入れ替えの実行
-            $conn->query("BEGIN");
+            $objQuery->begin();
             $sqlup = "UPDATE dtb_member SET rank = ? WHERE member_id = ?";
-            $conn->query($sqlup, array($rank - 1, $id));
-            $conn->query($sqlup, array($rank, $down_id));
-            $conn->query("COMMIT");
+            $objQuery->query($sqlup, array($rank - 1, $id));
+            $objQuery->query($sqlup, array($rank, $down_id));
+            $objQuery->query("COMMIT");
         }
     }