Changeset 23420
- Timestamp:
- 2014/05/15 12:03:00 (10 years ago)
- Location:
- branches/version-2_13_2/data/class
- Files:
-
- 5 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_13_2/data/class/SC_Product.php
r23378 r23420 83 83 $o_order = $this->arrOrderData['order']; 84 84 $objQuery->setOrder("T2.$o_col $o_order"); 85 $ objQuery->setLimit(1);86 $sub_sql = $objQuery-> getSqlWithLimitOffset($o_col, "$o_table AS T2", 'T2.product_id = alldtl.product_id');85 $sub_sql = $objQuery->getSql($o_col, "$o_table AS T2", 'T2.product_id = alldtl.product_id'); 86 $sub_sql = $objQuery->dbFactory->addLimitOffset($sub_sql, 1); 87 87 88 88 $objQuery->setOrder("($sub_sql) $o_order, product_id"); -
branches/version-2_13_2/data/class/SC_Query.php
r23378 r23420 1216 1216 } 1217 1217 } 1218 1219 /**1220 * 構築した SELECT 文を LIMIT OFFSET も含め取得する.1221 *1222 * @param string SELECT 文に含めるカラム名1223 * @param string SELECT 文に含めるテーブル名1224 * @param string SELECT 文に含める WHERE 句1225 * @return string 構築済みの SELECT 文1226 */1227 function getSqlWithLimitOffset($cols, $from = '', $where = '')1228 {1229 $sql = $this->getSql($cols, $from, $where);1230 $offset = $this->conn->offset;1231 $limit = $this->conn->limit;1232 $this->setLimitOffset(0, 0);1233 1234 return $this->dbFactory->addLimitOffset($sql, $limit, $offset);1235 }1236 1218 } -
branches/version-2_13_2/data/class/api/operations/ItemSearch.php
r23378 r23420 152 152 $where = 'T2.product_id = alldtl.product_id'; 153 153 $objQuery->setOrder('T3.rank DESC, T2.rank DESC'); 154 $ objQuery->setLimit(1);155 $sub_sql = $objQuery-> getSqlWithLimitOffset($col, $from, $where);154 $sub_sql = $objQuery->getSql($col, $from, $where); 155 $sub_sql = $objQuery->dbFactory->addLimitOffset($sub_sql, 1); 156 156 157 157 $objQuery->setOrder("($sub_sql) DESC ,product_id DESC"); -
branches/version-2_13_2/data/class/pages/admin/LC_Page_Admin_Home.php
r23378 r23420 252 252 253 253 $objQuery->setOrder('order_detail_id'); 254 $ objQuery->setLimit(1);255 $sql_product_name = $objQuery-> getSqlWithLimitOffset('product_name', 'dtb_order_detail', 'order_id = dtb_order.order_id');254 $sql_product_name = $objQuery->getSql('product_name', 'dtb_order_detail', 'order_id = dtb_order.order_id'); 255 $sql_product_name = $objQuery->dbFactory->addLimitOffset($sql_product_name, 1); 256 256 257 257 $cols = <<< __EOS__ -
branches/version-2_13_2/data/class/pages/products/LC_Page_Products_List.php
r23378 r23420 240 240 $where = 'T2.product_id = alldtl.product_id'; 241 241 $objQuery->setOrder('T3.rank DESC, T2.rank DESC'); 242 $ objQuery->setLimit(1);243 $sub_sql = $objQuery-> getSqlWithLimitOffset($col, $from, $where);242 $sub_sql = $objQuery->getSql($col, $from, $where); 243 $sub_sql = $objQuery->dbFactory->addLimitOffset($sub_sql, 1); 244 244 245 245 $objQuery->setOrder("($sub_sql) DESC ,product_id DESC");
Note: See TracChangeset
for help on using the changeset viewer.