20190419 修复一个上一页下一页在指定排序时的错误。

admin

1. //下一页
   
2.                 $next_page = $this->db->get_one("`catid` = '$catid' AND `id`<'$id' AND `status`=99",'*','listorder DESC, id DESC');
   
3. 
   
4.                 // 上一页下一页新的写法  开始2019 0419
   
5. 
   
6.         //超找附近的数据
   
7. 
   
8.         $around_data_1 =$this->db->select("`catid`= '$catid' AND `listorder`>'$listorder' and id!='$id'   AND `status`=99",'*',1,'listorder ASC,id ASC');
   
9.         $around_data_2 = $this->db->select("`catid`= '$catid' AND `listorder`<'$listorder'   AND `status`=99",'*',1,'listorder DESC, id DESC');
   
10.         $around_data_3 = $this->db->select("`catid`= '$catid' AND `id`>='$id' AND `listorder`>='$listorder' AND `status`=99",'*',2, 'listorder ASC,id ASC');
    
11.         $around_data_4 = $this->db->select("`catid`= '$catid' AND `id`<'$id' AND `listorder`<='$listorder'   AND `status`=99",'*',1, 'listorder DESC, id DESC');
    
12. 
    
13.         $around_data_a = array_merge((array)$around_data_1,(array)$around_data_2);
    
14.         $around_data_b = array_merge((array)$around_data_3,(array)$around_data_4);
    
15.         $around_data = array_merge($around_data_a,$around_data_b);
    
16.         //将数组 按照先listorder  后 ID  降序排
    
17.         foreach ($around_data as $key => $row) {
    
18.             $around_data_volume[$key]  = $row['listorder'];
    
19.             $around_data_edition[$key] = $row['id'];
    
20.          }
    
21. 
    
22.          array_multisort($around_data_volume, SORT_DESC, $around_data_edition, SORT_DESC, $around_data);
    
23.          // print_r($around_data);
    
24. 
    
25.          $current_pos = array_search($id, array_column($around_data, 'id'));
    
26. 
    
27.          $previous_page = $around_data[$current_pos-1];
    
28. 
    
29.          $next_page =     $around_data[$current_pos+1];
    
30. 
    
31.          //上一页下一页新的写法  结束  2019 0419

复制代码

phpcms\modules\content\index.php

1. //内容页
   
2.         public function show() {

复制代码

admin

新增按发布时间的上一页下一页

1. // 上一页下一页新的写法  开始2019 0419
   
2. 
   
3.         //超找附近的数据
   
4. 
   
5.         $around_data_1 =$this->db->select("`catid`= '$catid' AND `listorder`>'$listorder' and id!='$id'   AND `status`=99",'*',1,'listorder ASC,inputtime ASC');
   
6.         $around_data_2 = $this->db->select("`catid`= '$catid' AND `listorder`<'$listorder'   AND `status`=99",'*',1,'listorder DESC, inputtime DESC');
   
7.         $around_data_3 = $this->db->select("`catid`= '$catid' AND `inputtime`>='".strtotime($inputtime)."' AND `listorder`>='$listorder' AND `status`=99",'*',2, 'listorder ASC,inputtime ASC');
   
8.         $around_data_4 = $this->db->select("`catid`= '$catid' AND `inputtime`<'".strtotime($inputtime)."' AND `listorder`<='$listorder'   AND `status`=99",'*',1, 'listorder DESC, inputtime DESC');
   
9. 
   
10.         $around_data_a = array_merge((array)$around_data_1,(array)$around_data_2);
    
11.         $around_data_b = array_merge((array)$around_data_3,(array)$around_data_4);
    
12.         $around_data = array_merge($around_data_a,$around_data_b);
    
13.         //将数组 按照先listorder  后 ID  降序排
    
14.         foreach ($around_data as $key => $row) {
    
15.             $around_data_volume[$key]  = $row['listorder'];
    
16.             $around_data_edition[$key] = $row['inputtime'];
    
17.          }
    
18. 
    
19.          array_multisort($around_data_volume, SORT_DESC, $around_data_edition, SORT_DESC, $around_data);
    
20.           //print_r($around_data);
    
21. 
    
22.          $current_pos = array_search(strtotime($inputtime), i_array_column($around_data, 'inputtime'));
    
23. 
    
24.          $previous_page = $around_data[$current_pos-1];
    
25. 
    
26.          $next_page =     $around_data[$current_pos+1];
    
27. 
    
28.          //上一页下一页新的写法  结束  2019 0419

复制代码