cms/app/Http/Controllers/Admin/ColumnController.php

<?php

namespace App\Http\Controllers\Admin;
use  App\Model\Column;
use  App\Model\Colconfig;
use App\Http\Controllers\Controller;
use http\Env\Response;
use Illuminate\Http\Request;
use App\Http\Requests;
use Illuminate\Support\Facades\DB;
use Illuminate\Pagination\LengthAwarePaginator;
use Illuminate\Support\Facades\Storage;

class ColumnController extends Controller{

    public function index(){
        $table=new Colconfig();
        $table1=new Column;
        $sel=$table->colshow();
//        $data=$table1->colshows($sel[0]['columnid']);
        $data= $this->tree();
        return  view('admin.column.col-config',compact('sel','data'));
    }

    public function colselect(Request $request){
//        $input=$request->all();
        $table=new Column();
        $re=$table->rankshow($request->id,$request->colid);
        if ($re){
            return response()->json($re);
        }else{
            return ['msg'=>'查询出错'];
        }
    }

    public function colsave1(Request $request){
        $table=new Column();
        $data = $request->except(['_token']);
        $re=$table->colsave($data);
        if ($re){
            return response()->json(['msg'=>'创建成功']);
        }else{
            return response()->json(['msg'=>'数据出错']);
        }
    }

    public function colshowall(Request $request){
        $table=new Colconfig();
        $re=$table->colshow();
//        dd($re);
        if ($re){
            return response()->json($re);
        }else{
            return  json(['msg'=>'数据出错']);
        }
    }

    public function colconshow(Request $request){
        $table=new Column();
        $data=$table->colshows($request->id);
        if ($data){
            return response()->json($data);
        }
    }


    public function tree($parentid=0,$columnid=1)
    {
        $rows = Column::where([['parentid','=',$parentid],['columnid','=',$columnid]])->orderBy('order','ASC')->get();
        $arr = [];

        if (sizeof($rows) != 0){
            foreach ($rows as $key => $val){
                $val['child'] = $this->tree($val['id']);
                $arr[] = $val->toArray();
            }
            return $arr;
        }
        return [];
    }

    public function coldel1(Request $request){
        $res=DB::table('columns')->where('parentid','=',$request->id)->get();
        if ($res){
            return response()->json(['msg'=>'请先删除子级标题','status'=>'2']);
        }else{
            $re=DB::table('columns')->delete($request->id);
            if ($re){
                return response()->json(['msg'=>'删除成功','status'=>'0']);
            }else{
                return response()->json(['msg'=>'删除失败','status'=>'1']);
            }
        }

    }

    public function coledit(Request $request){
        $re=DB::table('columns')->where('id','=',$request->id)->select(
            'id','name','keys','url','rank','parentid',
            'class','status','order','created_at','updated_at'
        )->get()->toArray();
//        dd($re);
        return view('admin.column.coledit',compact('re'));
    }

    public function coledita(Request $request){
        $tabel=new Column();
        $input=$request->except(['_token']);
//        dd($input);
        $re=$tabel->updates($request->id,$input);
//        dd($re);
        if ($re==null||$re==0){
            return redirect()->route('col-config');
        }
    }

    public function colsave(Request $request){
        $in=$request->except('_token');
//        return dd($request->all());
//        return dd($in['data']);
        $re=$this->saveall($in['data']);
        return $re;
    }

    /**
     * @param $data
     * @param int $pa
     * @return array
     */
    public function saveall($data, $pa=0,$rank=1){
        $t=new  Column();
        foreach ($data as $k=>$v){
            $da=['order'=>$k+1,'parentid'=>$pa,'rank'=>$rank];
            $re[]=$t->updates($v['id'],$da);
            if (!empty($v['children'])){
                $rank++;
                $this->saveall($v['children'],$v['id'],$rank);
                }
        }
        return $re;
    }

}