<?php

namespace App\Http\Controllers\Admin;

use App\Model\Article;
use App\Model\Column;
use Illuminate\Support\Facades\DB;
use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use Carbon\Carbon;

class ArticleController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $table=new Article();
        $data=$table->show();
//        dd($data);
        foreach ($data as $k=>$v){
            $d=DB::table('columns')->where('id','=',$v->colid)->select('name')->get();
//            $d=$d->toArray();
            $data[$k]['colname']=$d[0]->name;
        }
//        dd($data->toArray());
//        $data=DB::table('articles')->select()->get();
        return view('admin.article.index',compact('data'));
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        //
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //
    }

    /**
     * Display the specified resource.
     *
     * @param  \App\Article  $article
     * @return \Illuminate\Http\Response
     */
    public function show(Request $request)
    {
        $table=new Article();
        $re=$table->show($request->id);
        $data=$re->toArray();
//        $re=$article->show();
//        dd($re);
        return view('admin.article.show',compact('data'));
    }

    public function addshow(Request $request)
    {
        $table=new Article();
        $data=$table->show(1);
        return view('admin.article.add',compact('data'));
    }
    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Article  $article
     * @return \Illuminate\Http\Response
     */
    public function edit(Request $request,Article $articles)
    {
        $table=new Article();
        $data=$request->except('_token');
        $re=$table->updates($data['id'],$data);
        if (!empty($re)){
//            return dd($request->all());
            return response()->json(['msg'=>'修改成功']);
        }else{
            return response()->json(['msg'=>'请求错误，请重新发送']);
        }

    }

    public function editshow(Request $request){
        $table=new Article();
        $re=$table->show($request->id);
        $data=$re->toArray();
        return view('admin.article.edit',compact('data'));
    }
    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Article  $article
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, Article $article)
    {

    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Article  $article
     * @return \Illuminate\Http\Response
     */
    public function destroy(Request $request)
    {
        $table =new Article();
        $re=$table->del($request->id);
        if ($re){
            return response()->json(['msg'=>'删除成功','status'=>0]);
        }else{
            return response()->json(['msg'=>'请求出错','status'=>1]);
        }
    }

    public function showsel(Request $request){
        $re=$this->tree();
        $re=json_encode($re);
//        dd($re);
        return  $re;
    }

    public function add(Request $request){
        $table=new Article();
        $data=$request->except('_token');
        $re=$table->inserts($data);
        if ($re){
            return response()->json(['msg'=>'添加成功','status'=>0]);
        }else{
            return response()->json(['msg'=>'请求出错','status'=>1]);
        }
    }

    public function tree($parentid=0)
    {
        $rows = Column::where('parentid','=', $parentid)->orderBy('order','ASC')->select('name','id')->get();
        $arr = [];
        if (sizeof($rows) != 0){
            foreach ($rows as $key => $val){
                $val['open']='true';
                $val['children'] = $this->tree($val['id']);
                $arr[] = $val->toArray();
            }
            return $arr;
        }
        return ;
    }

    public function tree2($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){
                $a=DB::table('articles')->where('colid','=',$val['id'])->get();
                $val['article']=$a->toArray();
                $val['children'] = $this->tree2($val['id']);
                $arr[] = $val->toArray();
            }
            return $arr;
        }
        return [];
    }

    public function showeach(){
        $data=$this->tree2();
        return view('admin.test.test3',compact('data'));
    }

    public function showroute($name){
        $data=DB::table('columns')->where([['keys','=',$name],['status','=','0']])->select('id','type')->get();
        $data=$data->toArray();
//        dd($data);
        $re=DB::table('articles')->where([['colid','=',$data[0]->id],['status','=','0']])->get();
        return view('admin.test.detail',compact('re','data'));
    }

    public function coldemo(){
//        $data=DB::table('columns')->where([['parentid','=','0'],['columnid','=','1']])->get();
//        $data=$data->toArray();
//        foreach ($data as $k=>$v){
//            $re=DB::table('articles')->where('colid','=',$v->id)->get();
//            if ($re){
//                $re=$re->toArray();
//                $data[$k]->article=$re;
//            }
//        }
        $data=$this->tree2();
//        $data=$this->haha($data);
        $data=array_column($data, 'children');
        echo array_sum($data);
        dd($data);
        return  view('admin.test.demo',compact('data'));
    }


    public function haha($data){
//        $d=$data;
        $arr=[];
        foreach ($data as $k=>$v){
            if ($v['children']){
                $this->haha($v['children']);
            }
            if ($v['article']){
                foreach ($v['article'] as $key=>$value){
//                    $arr[$key][]=[];
                    $arr[]=$value->title;
                }
                return $arr;
            }

        }
        return;
    }
    public function ardemo($id){
        $re=DB::table('articles')->where('id','=',$id)->get();
//        dd($re);
        return view('admin.test.demo1',compact('re'));
    }

    public function showlist($id){
        $re=DB::table('articles')->where([['id','=',$id],['status','=','0']])->get();
        return view('admin.test.list-detail',compact('re'));
    }
}