redis展示 删除 详情

  //添加展示页面
    public function add(){
       return view('show.add');
    }

    //添加执行页
    public function added(Request $request){
        $data['name']=$request['name'];
        $data['type']=$request['type'];
        $data['sort']=$request['sort'];

        $res = RedisModel::insert($data);
        if($res){
            return '成功';
        }
            return '失败';

    }



    //展示页面
    public function show(){
        //连接REDIS
        $redis = new \Redis();
        $redis->connect('127.0.0.1',6379);
        $redis->select(1);
        //查询数据库数据
        $res = RedisModel::orderBy('sort',"desc")->withTrashed()->get();
        //数据库数据转换
        $ress = json_decode(json_encode($res),true);


       // 判断 如果已经缓存就读取  否则就写入
        if(!$redis->exists('1')){
            //写入REDIS
           $redis->hSet(1,'goods',json_encode($ress));

        }else{
            //获取REDIS
            $data = json_decode( $redis->hget(1,'goods'),true);


            return view('show.show',['res'=>$data]);
        }

    }


    //搜索
    public function sou(Request $request)
    {
        $name = $request->input('phone');
        $redis = new \Redis();
        $redis->connect('127.0.0.1', 6379);
        $redis->select(1);
        $data = json_decode($redis->hGet(1, 'goods'), true);

        foreach ($data as $k => $v) {
            if ($v['name'] == $name) {

                return view('my.xiangqing', ['res' => $v]);
            }


        }
    }


        //详情页
        public function xiangqing(Request $request)
        {
            $id = $request->input('id');
            $redis = new \Redis();
            $redis->connect('127.0.0.1', 6379);
            $redis->select(1);
            $data = json_decode($redis->hGet(1, 'goods'), true);
            foreach ($data as $k => $v) {
                if ($v['id'] == $id) {
                    return view('my.xiangqing', ['res' => $v]);
                }
            }
        }

    //删除
    public function del(Request $request){
        $id = $request->input('id');
        RedisModel::find($id)->delete();
        //forceDelete  真删除
        return ['status'=>0,'msg'=>'删除成功'];
    }


    //还原
    public function huan(Request $request){
        $id = $request->input('id');
        RedisModel::onlyTrashed()->where('id',$id)->restore();
        return ['status'=>0,'msg'=>'还原成功'];
    }

    //导出
    public function exel(){
        header("content-type:text/html;charset=utf-8");
        //获取数据库中数据表所有数据
        $dataa = RedisModel::get();
        $data = json_decode(json_encode($dataa),true);//转为json数组


        $str="ID\t手机名\t型号t\t排序\t时间"."\n";
        foreach($data as $key=>$v){
            $str.=implode("\t",$v)."\n";
        }

        header("content-type:application/vnd.ms-excel");
        header("content-disposition:attachment;filename=show.xls");
        echo $str;
    }