123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266 |
- <?php
- define('SORT_DATE', 3);
- define('SORT_IMAGE', 4);
- class TableSort {
-
- public function sort_table($data, $column = 0, $direction = SORT_ASC, $type = SORT_REGULAR) {
- if (!is_array($data) || empty($data)) {
- return array();
- }
- if ($column != strval(intval($column))) {
-
- return $data;
- }
- if (!in_array($direction, array(SORT_ASC, SORT_DESC))) {
-
- return $data;
- }
- if ($type == SORT_REGULAR) {
- if (TableSort::is_image_column($data, $column)) {
- $type = SORT_IMAGE;
- } elseif (TableSort::is_date_column($data, $column)) {
- $type = SORT_DATE;
- } elseif (TableSort::is_numeric_column($data, $column)) {
- $type = SORT_NUMERIC;
- } else {
- $type = SORT_STRING;
- }
- }
- $compare_operator = $direction == SORT_ASC ? '>' : '<=';
- switch ($type) {
- case SORT_NUMERIC:
- $compare_function = 'return strip_tags($a['.$column.']) '.$compare_operator.' strip_tags($b['.$column.']);';
- break;
- case SORT_IMAGE:
- $compare_function = 'return api_strnatcmp(api_strtolower(strip_tags($a['.$column.'], "<img>")), api_strtolower(strip_tags($b['.$column.'], "<img>"))) '.$compare_operator.' 0;';
- break;
- case SORT_DATE:
- $compare_function = 'return strtotime(strip_tags($a['.$column.'])) '.$compare_operator.' strtotime(strip_tags($b['.$column.']));';
- break;
- case SORT_STRING:
- default:
- $compare_function = 'return api_strnatcmp(api_strtolower(strip_tags($a['.$column.'])), api_strtolower(strip_tags($b['.$column.']))) '.$compare_operator.' 0;';
- break;
- }
-
- usort($data, create_function('$a, $b', $compare_function));
- return $data;
- }
-
- public function sort_table_config($data, $column = 0, $direction = SORT_ASC, $column_show = null, $column_order = null, $type = SORT_REGULAR, $doc_filter = false) {
- if (!is_array($data) || empty($data)) {
- return array();
- }
- if ($column != strval(intval($column))) {
-
- return $data;
- }
- if (!in_array($direction, array(SORT_ASC, SORT_DESC))) {
-
- return $data;
- }
-
-
- if (is_array($column_order)) {
- $column = isset($column_order[$column]) ? $column_order[$column] : $column;
- }
- if ($type == SORT_REGULAR) {
- if (TableSort::is_image_column($data, $column)) {
- $type = SORT_IMAGE;
- } elseif (TableSort::is_date_column($data, $column)) {
- $type = SORT_DATE;
- } elseif (TableSort::is_numeric_column($data, $column)) {
- $type = SORT_NUMERIC;
- } else {
- $type = SORT_STRING;
- }
- }
-
-
- if ($doc_filter && in_array($type, array(SORT_STRING))) {
- $data_to_sort = $folder_to_sort = array();
- $new_data = array();
- if (!empty($data)) {
- foreach ($data as $document) {
- if ($document['type'] == 'folder') {
- $docs_to_sort[$document['id']] = api_strtolower($document['name']);
- } else {
- $folder_to_sort[$document['id']] = api_strtolower($document['name']);
- }
- $new_data[$document['id']] = $document;
- }
- if ($direction == SORT_ASC) {
- if (!empty($docs_to_sort)) {
- api_natrsort($docs_to_sort);
- }
- if (!empty($folder_to_sort)) {
- api_natrsort($folder_to_sort);
- }
- } else {
- if (!empty($docs_to_sort)) {
- api_natsort($docs_to_sort);
- }
- if (!empty($folder_to_sort)) {
- api_natsort($folder_to_sort);
- }
- }
- $new_data_order = array();
- if (!empty($docs_to_sort)) {
- foreach($docs_to_sort as $id => $document) {
- $new_data_order[] = $new_data[$id];
- }
- }
- if (!empty($folder_to_sort)) {
- foreach($folder_to_sort as $id => $document) {
- $new_data_order[] = $new_data[$id];
- }
- }
- $data = $new_data_order;
- }
- } else {
- $compare_operator = $direction == SORT_ASC ? '>' : '<=';
- switch ($type) {
- case SORT_NUMERIC:
- $compare_function = 'return strip_tags($a['.$column.']) '.$compare_operator.' strip_tags($b['.$column.']);';
- break;
- case SORT_IMAGE:
- $compare_function = 'return api_strnatcmp(api_strtolower(strip_tags($a['.$column.'], "<img>")), api_strtolower(strip_tags($b['.$column.'], "<img>"))) '.$compare_operator.' 0;';
- break;
- case SORT_DATE:
- $compare_function = 'return strtotime(strip_tags($a['.$column.'])) '.$compare_operator.' strtotime(strip_tags($b['.$column.']));';
- break;
- case SORT_STRING:
- default:
- $compare_function = 'return api_strnatcmp(api_strtolower(strip_tags($a['.$column.'])), api_strtolower(strip_tags($b['.$column.']))) '.$compare_operator.' 0;';
- break;
- }
-
- usort($data, create_function('$a, $b', $compare_function));
- }
- if (is_array($column_show)) {
-
- $new_order_data = array();
- $count_data = count($data);
- $count_column_show = count($column_show);
- for ($j = 0; $j < $count_data; $j++) {
- $k = 0;
- for ($i = 0; $i < $count_column_show; $i++) {
- if ($column_show[$i]) {
- $new_order_data[$j][$k] = $data[$j][$i];
- }
- $k++;
- }
- }
-
- $data = $new_order_data;
- }
- return $data;
- }
-
- private function is_numeric_column(& $data, $column) {
- $is_numeric = true;
- foreach ($data as $index => & $row) {
- $is_numeric &= is_numeric(strip_tags($row[$column]));
- if (!$is_numeric) {
- break;
- }
- }
- return $is_numeric;
- }
-
- private function is_date_column(& $data, $column) {
- $is_date = true;
- foreach ($data as $index => & $row) {
- if (strlen(strip_tags($row[$column])) != 0) {
- $check_date = strtotime(strip_tags($row[$column]));
-
-
- $is_date &= ($check_date != -1 && $check_date);
- } else {
- $is_date &= false;
- }
- if (!$is_date) {
- break;
- }
- }
- return $is_date;
- }
-
- private function is_image_column(& $data, $column) {
- $is_image = true;
- foreach ($data as $index => & $row) {
- $is_image &= strlen(trim(strip_tags($row[$column], '<img>'))) > 0;
- $is_image &= strlen(trim(strip_tags($row[$column]))) == 0;
- if (!$is_image) {
- break;
- }
- }
- return $is_image;
- }
- }
|