PHP二维数据排序，二维数据模糊查询

一、因为项目中的一个报表需要合并三个表的数据，所以分表查询再合并数据，利用PHP数组函数进行排序，搜索。三表合并后的数组结构如下：

1Array
2(
3    [0] => Array
4        (
5            [history_id] => 12
6            [sla_group_id] => 1
7            [sla_id] => -1
8            [create_time] => 1513057695
9            [tasklog_id] => 12
10            [tasklog_time] => 2017-12-12 13:48:15
11            [tasklog_name] => window_2008
12            [tasklog_type] => 分组立即调度
13            [tasklog_user] => admin
14            [tasklog_status] => 3
15        )
16
17    [1] => Array
18        (
19            [history_id] => 11
20            [sla_group_id] => 1
21            [sla_id] => 1
22            [create_time] => 1513057563
23            [tasklog_id] => 11
24            [tasklog_time] => 2017-12-12 13:46:03
25            [tasklog_name] => centos7_USHARK
26            [tasklog_type] => 一小时备份频率
27            [tasklog_user] => 系统自动
28            [tasklog_status] => 3
29        )
30
31    [2] => Array
32        (
33            [history_id] => 19
34            [sla_group_id] => 1
35            [sla_id] => 98
36            [create_time] => 1513059714
37            [tasklog_id] => 19
38            [tasklog_time] => 2017-12-12 14:21:54
39            [tasklog_name] => huawei_fusion_backup
40            [tasklog_type] => 华为虚拟化备份
41            [tasklog_user] => ushark.net
42            [tasklog_status] => 2
43        )
44
45    [3] => Array
46        (
47            [history_id] => 41
48            [sla_group_id] => 0
49            [sla_id] => -1
50            [create_time] => 1513069534
51            [status] => 2
52            [tasklog_id] => 41
53            [tasklog_time] => 2017-12-12 17:05:34
54            [tasklog_name] => centos7-11自增非整数测试
55            [tasklog_user] => admin
56            [tasklog_type] => 立即调度
57            [tasklog_status] => 2
58        )
59
60    [4] => Array
61        (
62            [history_id] => 40
63            [sla_group_id] => 0
64            [sla_id] => -1
65            [create_time] => 1513067574
66            [status] => 2
67            [tasklog_id] => 40
68            [tasklog_time] => 2017-12-12 16:32:54
69            [tasklog_name] => win2008安装MySQL
70            [tasklog_user] => impp.cc
71            [tasklog_type] => 策略备份
72            [tasklog_status] => 2
73        )
74
75    [5] => Array
76        (
77            [history_id] => 39
78            [sla_group_id] => 0
79            [sla_id] => -1
80            [create_time] => 1513067399
81            [status] => 2
82            [tasklog_id] => 39
83            [tasklog_time] => 2017-12-12 16:29:59
84            [tasklog_name] => Linux下文件
85            [tasklog_user] => ppstorm.com
86            [tasklog_type] => 立即调度
87            [tasklog_status] => 2
88        )
89)

二、二维数组排序、搜索

1// HTTP GET values
2$length  = (int) $this->input->get('length', true);
3$start   = (int) $this->input->get('start', true);
4$order   = trim($this->input->get('order', true));
5$sort    = trim($this->input->get('dir', true));
6$search  = trim($this->input->get('search', true));
7
8// 三表数据
9$vm_group = $this->safe->vm_group_task();
10$vm_tasklog = $this->safe->vm_tasklog();
11$vm_mounts_log = $this->safe->vm_mounts_log();
12
13// 合并数据
14$tasklog = array_merge($vm_group, $vm_tasklog, $vm_mounts_log);
15
16// !!! 二维数据搜索 !!!
17if (!empty($search)) {
18    foreach ($tasklog as $sk => $sv) {
19        if (mb_stripos($sv['tasklog_name'], $search) === false
20            && mb_stripos($sv['tasklog_type'], $search) === false
21            && mb_stripos($sv['tasklog_user'], $search) === false
22        ) {
23            unset($tasklog[$sk]);
24            continue;
25        }
26    }
27}
28
29// 总记录
30$total_record = count($tasklog);
31
32// 排序
33switch ($order) {
34    case 1:
35        $sort_key = 'tasklog_name';
36        break;
37    case 2:
38        $sort_key = 'tasklog_type';
39        break;
40    case 3:
41        $sort_key = 'tasklog_user';
42        break;
43    case 4:
44        $sort_key = 'tasklog_time';
45        break;
46    case 5:
47        $sort_key = 'tasklog_status';
48        break;
49    default:
50        $sort_key = 'tasklog_id';
51        break;
52}
53$sort_arr = array_column($tasklog, $sort_key);
54$desc_asc = $sort === 'desc' ? SORT_DESC : SORT_ASC;
55array_multisort($sort_arr, $desc_asc, $tasklog); // !!! 二维数据排序 !!!
56
57// 取指定长度
58$output_arr = array_slice($tasklog, $start, $length);