application/index/controller/NeedList.php

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?php

namespace app\index\controller;
use app\index\model\NeedSpace;
use app\index\model\NeedTypeSpace;
class NeedList extends Base {

    public function index() {

        $key_word = request()->param('key_word');
        $num = intval(session('ses_need_page_num', '', 'index'));
        $sort = session('ses_need_sort', '', 'index');
        $ses_need_sc = session('ses_need_sc', '', 'index');
        if (!$num) {
            $num = 12;
        }
        if (!$sort) {
            $sort = "update_time";
        }
        if (!$ses_need_sc) {
            $ses_need_sc = "desc";
        }
        $need_type = request()->param('need_type');
        $need_type2 = request()->param('need_type2');
        $need_type3 = request()->param('need_type3');

        $typelist = NeedTypeSpace::all();
        //生成一个以need_type 数据表id为索引，名称为数值的关联数组。方便下方直接根据type_id引用数值
        foreach ($typelist as $value) {
            $new_typelist[$value['id']] = $value['type_name'];
        }

        // 查询状态为1的用户数据 并且每页显示10条数据
        if ($need_type) {
            $need_type_name = $new_typelist[$need_type];
            $NeedSpace_old = NeedSpace::where('need_status', '>', 0)->where(['need_type' => $need_type])->order($sort, $ses_need_sc)->paginate($num);
        }
        if ($need_type2) {

            $need_type2_space = NeedTypeSpace::where(['id' => $need_type2])->find();

            $need_type2_name = $new_typelist[$need_type2];
            $need_type = $need_type2_space['pid'];
            $need_type_name = $new_typelist[$need_type];
            $NeedSpace_old = NeedSpace::where('need_status', '>', 0)->where(['need_type2' => $need_type2])->order($sort, $ses_need_sc)->paginate($num);
        }
        if ($need_type3) {
            $need_type3_space = NeedTypeSpace::where(['id' => $need_type3])->find();
            $need_type2_space = NeedTypeSpace::where(['id' => $need_type3_space['pid']])->find();

            $need_type3_name = $new_typelist[$need_type3];
            $need_type2 = $need_type3_space['pid'];
            $need_type2_name = $new_typelist[$need_type2];
            $need_type = $need_type2_space['pid'];
            $need_type_name = $new_typelist[$need_type];

            $NeedSpace_old = NeedSpace::where('need_status', '>', 0)->where(['need_type3' => $need_type3])->order($sort, $ses_need_sc)->paginate($num);
        }
        if (!$need_type && !$need_type2 && !$need_type3) {
            $NeedSpace_old = NeedSpace::where('need_status', '>', 0)->where(['need_name' => ['like', '%' . $key_word . '%']])->order($sort, $ses_need_sc)->paginate($num);