* Add : sort NULL or empty records as last
- ItemVirtualBean.class.php
trunk/xoonips/xoops_trust_path/modules/xoonips/class/bean/ItemVirtualBean.class.php (diff)| @@ -278,10 +278,11 @@ | ||
| 278 | 278 | private function getCriteriaStr($cri) { |
| 279 | 279 | $sql = ''; |
| 280 | 280 | if (isset($cri['order']) && isset($cri['orderdir'])) { |
| 281 | - if (isset($cri['order']) && $cri['orderdir'] == 0) { | |
| 282 | - $orders = $cri['order'] . ' ASC'; | |
| 283 | - } elseif (isset($cri['order']) && $cri['orderdir'] == 1) { | |
| 284 | - $orders = $cri['order'] . ' DESC'; | |
| 281 | + $orders = ' (CASE WHEN ' . $cri['order'] . "='' THEN 1 WHEN " . $cri['order'] . ' IS NULL THEN 2 ELSE 0 END ) '; | |
| 282 | + if ($cri['orderdir'] == 0) { | |
| 283 | + $orders .= ' , ' . $cri['order'] . ' ASC'; | |
| 284 | + } elseif ($cri['orderdir'] == 1) { | |
| 285 | + $orders .= ' , ' . $cri['order'] . ' DESC'; | |
| 285 | 286 | } |
| 286 | 287 | $sql .= " ORDER BY $orders "; |
| 287 | 288 | } |
