Changeset 23377
- Timestamp:
- 2014/04/29 16:57:38 (9 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_13-dev/data/class/pages/admin/total/LC_Page_Admin_Total.php
r23295 r23377 555 555 $from = 'dtb_order_detail JOIN dtb_order ON dtb_order_detail.order_id = dtb_order.order_id'; 556 556 557 /* 558 if ($mode != 'csv') { 559 $sql.= 'LIMIT ' . PRODUCTS_TOTAL_MAX; 560 }*/ 561 562 // 要index 557 // FIXME グループを副問い合わせにして無駄な処理を減らす 563 558 $objQuery->setGroupBy('product_id, product_name, product_code, price'); 564 //$objQuery->setGroupBy('product_id');565 559 $objQuery->setOrder('total DESC'); 566 560 $arrTotalResults = $objQuery->select($col, $from, $where, $arrWhereVal);
Note: See TracChangeset
for help on using the changeset viewer.