Changeset 21832 for branches/version-2_12-dev/data/class/pages/admin/system/LC_Page_Admin_System.php

Timestamp:

2012/05/14 02:38:11 (12 years ago)

Author:

nanasess

bzr:base-revision:

nanasess@fsm.ne.jp-20120513161702-kk78khnxu1sfsw5s

bzr:committer:

Kentaro Ohkouchi <nanasess@fsm.ne.jp>

bzr:file-ids:

data/class/SC_Query.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2FSC_Query.php
data/class/SC_SelectSql.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2FSC_SelectSql.php
data/class/helper/SC_Helper_Customer.php 19864@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fversion-2_5-dev%2Fdata%2Fclass%2Fhelper%2FSC_Helper_Customer.php
data/class/pages/admin/system/LC_Page_Admin_System.php 15585@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fsystem%2FLC_Page_Admin_System.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:merge:

nanasess@fsm.ne.jp-20120513173417-27p8tawv1k1wnthe

bzr:repository-uuid:

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

bzr:revision-id:

nanasess@fsm.ne.jp-20120513173804-r2alhhlv9wbg9pzn

bzr:revno:

4500

bzr:revprop:branch-nick:

branches/version-2_12-dev

bzr:root:

branches/version-2_12-dev

bzr:testament:

bazaar-ng testament short form 2.1
revision-id: nanasess@fsm.ne.jp-20120513173804-r2alhhlv9wbg9pzn
sha1: 30955b6741e635d275aa0244123a27bbdc87996f

bzr:timestamp:

2012-05-14 02:38:04.782999992 +0900

bzr:user-agent:

bzr2.4.2+bzr-svn1.1.2

Message:

#1752 (LIMIT, OFFSET をベタ書きしない)

• SC_Query::setLimitOffset() は MDB2::setLimit() のラッパーに修正
• SC_SelectSql::setLimitOffset() は SC_Query::setLimitOffset() を使用するよう修正

File:

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

branches/version-2_12-dev/data/class/pages/admin/system/LC_Page_Admin_System.php

@@ -128 +128 @@
      */
     function getMemberData($startno) {
-        $objSql = new SC_SelectSql_Ex();
-        $objSql->setSelect('SELECT member_id,name,department,login_id,authority,rank,work FROM dtb_member');
-        $objSql->setOrder('rank DESC');
-        $objSql->setWhere('del_flg <> 1 AND member_id <> '. ADMIN_ID);
-        $objSql->setLimitOffset(MEMBER_PMAX, $startno);
-
+        $col = 'member_id,name,department,login_id,authority,rank,work';
+        $from = 'dtb_member';
+        $where = 'del_flg <> 1 AND member_id <> ?';
         $objQuery =& SC_Query_Ex::getSingletonInstance();
-        $arrMemberData = $objQuery->getAll($objSql->getSql());
-
+        $objQuery->setOrder('rank DESC');
+        $objQuery->setLimitOffset(MEMBER_PMAX, $startno);
+        $arrMemberData = $objQuery->select($col, $from, $where, array(ADMIN_ID));
         return $arrMemberData;
     }