<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2019/12/25
 * Time: 18:22
 */

namespace app\api\controller;




use app\common\controller\Api;
use think\Db;

/**
 * 农场列表
 */
class Farm extends Api
{
    /**
     * @ApiTitle    (地区列表)
     * @ApiSummary  (地区列表)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/farm/index)
     *
     * @ApiReturn({
        "code": 1,
        "msg": "SUCCESS",
        "time": "1553839125",
        "data": {

        }
    })
     */
    public function index()
    {
        $province_arr = array(
            '北京市',
            '天津市',
            '上海市',
            '重庆市',
            '河北省',
            '山西省',
            '台湾省',
            '辽宁省',
            '吉林省',
            '黑龙江省',
            '江苏省',
            '浙江省',
            '安徽省',
            '福建省',
            '江西省',
            '山东省',
            '河南省',
            '湖北省',
            '湖南省',
            '广东省',
            '甘肃省',
            '四川省',
            '贵州省',
            '海南省',
            '云南省',
            '青海省',
            '陕西省',
            '广西壮族自治区',
            '西藏自治区',
            '宁夏回族自治区',
            '新疆维吾尔自治区',
            '内蒙古自治区',
            '澳门特别行政区',
            '香港特别行政区'
        );
        $this->success('success',$province_arr);
    }

    /**
     * @ApiTitle    (农场列表)
     * @ApiSummary  (农场列表)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/farm/get_all)
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     *
     * @ApiParams   (name="page", type="inter", required=false, description="当前页(默认1)")
     * @ApiParams   (name="pageNum", type="inter", required=false, description="每页显示数据个数（默认10）")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "SUCCESS",
        "time": "1553839125",
        "data": {
            "id":"id",//农场id
            "name"://农场名称
            "avatar"://用户头像
            "score"://工分
            "content"://农场简介
            "fun_num"://粉丝数量
            "good_num":"good_num",//点赞量
            "province"://省份信息
            "status"://是否授权（1授权过2未授权）
            "is_guan"://是否关注(1是2否)
            "is_ren"://是否认证过(0未认证1已认证2未通过)
        }
    })
     */
    public function get_all()
    {
        $token = $this->request->header('token');
        $page = $this->request->param('page',1,'intval');
        $pageNum = $this->request->param('pageNum',10,'intval');
        if($token){
            $user_id = $this->getUserId();
            $data = Db::name('farm')
                ->alias('a')
                ->join('user b','a.user_id = b.id')
                ->field('a.id,a.user_id,a.name,a.content,a.province,a.fun_num,b.avatar,b.score')
                ->order('a.createtime desc')
                ->page($page,$pageNum)
                ->select();
            foreach ($data as &$v){
                $is_ren = Db::name('attestation')
                    ->where('farm_id',$v['id'])
                    ->field('user_id,status')
                    ->find();
                if($is_ren){
                    if($is_ren['status'] == 1){
                        $v['is_ren'] = 1;
                    }else{
                        $v['is_ren'] = 2;
                    }
                }else{
                    $v['is_ren'] = 0;
                }
                $v['status'] = 1;
                $guan = Db::name('guanzhu')
                    ->where('farm_id',$v['id'])
                    ->where('user_id',$user_id)
                    ->find();
                if(empty($guan)){
                    $v['is_guan'] = 2;
                }else{
                    $v['is_guan'] = 1;
                }
            }
            $this->success('success',$data);
        }else{

            $data = Db::name('farm')
                ->alias('a')
                ->join('user b','a.user_id = b.id')
                ->field('a.id,a.user_id,a.name,a.content,a.province,a.fun_num,b.avatar,b.score')
                ->order('a.createtime desc')
                ->page($page,$pageNum)
                ->select();
            foreach ($data as &$v){
                $is_ren = Db::name('attestation')
                    ->where('farm_id',$v['id'])
                    ->field('user_id,status')
                    ->find();
                if($is_ren){
                    if($is_ren['status'] == 1){
                        $v['is_ren'] = 1;
                    }else{
                        $v['is_ren'] = 2;
                    }
                }else{
                    $v['is_ren'] = 0;
                }
                $v['status'] = 2;
            }
           $this->success('success',$data);
        }

    }

    /**
     * @ApiTitle    (农场搜索)
     * @ApiSummary  (农场搜索)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/farm/sou)
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     *
     * @ApiParams   (name="keyword", type="string", required=false, description="关键字")
     * @ApiParams   (name="area", type="string", required=false, description="地区")
     * @ApiParams   (name="page", type="inter", required=false, description="当前页(默认1)")
     * @ApiParams   (name="pageNum", type="inter", required=false, description="每页显示数据个数（默认10）")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "SUCCESS",
        "time": "1553839125",
        "data": {
            "id":"id",//农场id
            "name"://农场名称
            "avatar"://用户头像
            "score"://工分
            "content"://农场简介
            "fun_num"://粉丝数量
            "good_num":"good_num",//点赞量
            "province"://省份信息
            "status"://是否授权（1授权过2未授权）
            "is_guan"://是否关注(1是2否)
            "is_ren"://是否认证过(0未认证1已认证2未通过)
    }
    })
     */
    public function sou()
    {
        $token = $this->request->header('token');
        if(empty($token)){
            $page = $this->request->param('page',1,'intval');
            $pageNum = $this->request->param('pageNum',10,'intval');
            $param = $this->request->param();
            if(empty($param['keyword']) && empty($param['area'])){
                $this->error('请输入搜索关键字');
            }
            if(empty($param['keyword'])){
                $data = Db::name('farm')
                    ->alias('a')
                    ->join('user b','a.user_id = b.id')
                    ->field('a.id,a.user_id,a.name,a.content,a.province,a.fun_num,b.avatar,b.score')
                    ->whereLike('a.province',"%$param[area]%")
                    ->order('a.createtime desc')
                    ->page($page,$pageNum)
                    ->select();
                foreach ($data as &$v){
                    $is_ren = Db::name('attestation')
                        ->where('farm_id',$v['id'])
                        ->field('user_id,status')
                        ->find();
                    if($is_ren){
                        if($is_ren['status'] == 1){
                            $v['is_ren'] = 1;
                        }else{
                            $v['is_ren'] = 2;
                        }
                    }else{
                        $v['is_ren'] = 0;
                    }

                    $v['status'] = 1;
                    $v['is_guan'] = 2;
                }
                $this->success('success',$data);
            }elseif (empty($param['area'])){
                $data = Db::name('farm')
                    ->alias('a')
                    ->join('user b','a.user_id = b.id')
                    ->field('a.id,a.user_id,a.name,a.content,a.province,a.fun_num,b.avatar,b.score')
                    ->whereLike('a.name',"%$param[keyword]%")
                    ->order('a.createtime desc')
                    ->page($page,$pageNum)
                    ->select();
                foreach ($data as &$v){
                    $is_ren = Db::name('attestation')
                        ->where('farm_id',$v['id'])
                        ->field('user_id,status')
                        ->find();
                    if($is_ren){
                        if($is_ren['status'] == 1){
                            $v['is_ren'] = 1;
                        }else{
                            $v['is_ren'] = 2;
                        }
                    }else{
                        $v['is_ren'] = 0;
                    }

                    $v['status'] = 1;
                    $v['is_guan'] = 2;

                }
                $this->success('success',$data);
            }else{
                $data = Db::name('farm')
                    ->alias('a')
                    ->join('user b','a.user_id = b.id')
                    ->field('a.id,a.user_id,a.name,a.content,a.province,a.fun_num,b.avatar,b.score')
                    ->whereLike('a.name',"%$param[keyword]%")
                    ->whereLike('a.province',"%$param[area]%")
                    ->order('a.createtime desc')
                    ->page($page,$pageNum)
                    ->select();
                foreach ($data as &$v){
                    $is_ren = Db::name('attestation')
                        ->where('farm_id',$v['id'])
                        ->field('user_id,status')
                        ->find();
                    if($is_ren){
                        if($is_ren['status'] == 1){
                            $v['is_ren'] = 1;
                        }else{
                            $v['is_ren'] = 2;
                        }
                    }else{
                        $v['is_ren'] = 0;
                    }


                    $v['status'] = 1;
                    $v['is_guan'] = 2;

                }
                $this->success('success',$data);
            }
        }
        $user_id = $this->getUserId();
        $page = $this->request->param('page',1,'intval');
        $pageNum = $this->request->param('pageNum',10,'intval');
        $param = $this->request->param();
        if(empty($param['keyword']) && empty($param['area'])){
            $this->error('请输入搜索关键字');
        }
        if(empty($param['keyword'])){
            $data = Db::name('farm')
                ->alias('a')
                ->join('user b','a.user_id = b.id')
                ->field('a.id,a.user_id,a.name,a.content,a.province,a.fun_num,b.avatar,b.score')
                ->whereLike('a.province',"%$param[area]%")
                ->order('a.createtime desc')
                ->page($page,$pageNum)
                ->select();
            foreach ($data as &$v){
                $is_ren = Db::name('attestation')
                    ->where('farm_id',$v['id'])
                    ->field('user_id,status')
                    ->find();
                if($is_ren){
                    if($is_ren['status'] == 1){
                        $v['is_ren'] = 1;
                    }else{
                        $v['is_ren'] = 2;
                    }
                }else{
                    $v['is_ren'] = 0;
                }

                $v['status'] = 1;
                $guan = Db::name('guanzhu')
                    ->where('farm_id',$v['id'])
                    ->where('user_id',$user_id)
                    ->find();
                if(empty($guan)){
                    $v['is_guan'] = 2;
                }else{
                    $v['is_guan'] = 1;
                }
            }
            $this->success('success',$data);
        }elseif (empty($param['area'])){
            $data = Db::name('farm')
                ->alias('a')
                ->join('user b','a.user_id = b.id')
                ->field('a.id,a.user_id,a.name,a.content,a.province,a.fun_num,b.avatar,b.score')
                ->whereLike('a.name',"%$param[keyword]%")
                ->order('a.createtime desc')
                ->page($page,$pageNum)
                ->select();
            foreach ($data as &$v){
                $is_ren = Db::name('attestation')
                    ->where('farm_id',$v['id'])
                    ->field('user_id,status')
                    ->find();
                if($is_ren){
                    if($is_ren['status'] == 1){
                        $v['is_ren'] = 1;
                    }else{
                        $v['is_ren'] = 2;
                    }
                }else{
                    $v['is_ren'] = 0;
                }

                $v['status'] = 1;
                $guan = Db::name('guanzhu')
                    ->where('farm_id',$v['id'])
                    ->where('user_id',$user_id)
                    ->find();
                if(empty($guan)){
                    $v['is_guan'] = 2;
                }else{
                    $v['is_guan'] = 1;
                }
            }
            $res['user_id'] = $user_id;
            $res['keyword'] = $param['keyword'];
            $res['createtime'] = time();
            Db::name('history')
                ->insertGetId($res);
            $this->success('success',$data);
        }else{
            $data = Db::name('farm')
                ->alias('a')
                ->join('user b','a.user_id = b.id')
                ->field('a.id,a.user_id,a.name,a.content,a.province,a.fun_num,b.avatar,b.score')
                ->whereLike('a.name',"%$param[keyword]%")
                ->whereLike('a.province',"%$param[area]%")
                ->order('a.createtime desc')
                ->page($page,$pageNum)
                ->select();
            foreach ($data as &$v){
                $is_ren = Db::name('attestation')
                    ->where('farm_id',$v['id'])
                    ->field('user_id,status')
                    ->find();
                if($is_ren){
                    if($is_ren['status'] == 1){
                        $v['is_ren'] = 1;
                    }else{
                        $v['is_ren'] = 2;
                    }
                }else{
                    $v['is_ren'] = 0;
                }


                $v['status'] = 1;
                $guan = Db::name('guanzhu')
                    ->where('farm_id',$v['id'])
                    ->where('user_id',$user_id)
                    ->find();
                if(empty($guan)){
                    $v['is_guan'] = 2;
                }else{
                    $v['is_guan'] = 1;
                }
            }
            $res['user_id'] = $user_id;
            $res['keyword'] = $param['keyword'];
            $res['createtime'] = time();
            Db::name('history')
                ->insertGetId($res);
            $this->success('success',$data);
        }
    }

    /**
     * @ApiTitle    (历史记录)
     * @ApiSummary  (历史记录)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/farm/history)
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "成功",
        "time": "1571492001",
        "data": {
        "id": 4,//记录id,
        "keyword"://搜索的内容
        }
        })
     */
    public function history()
    {
        $user_id = $this->getUserId();
        $data = Db::name('history')
            ->where('user_id',$user_id)
            ->order('id desc')
            ->column('keyword');
        $res = array_unique($data);
        $res = array_slice($res,0,10);
        $this->success('SUCCESS',$res);
    }

    /**
     * @ApiTitle    (清空历史记录)
     * @ApiSummary  (清空历史记录)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/farm/nohistory)
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "成功",
        "time": "1571492001",
        "data": {

        }
        })
     */
    public function nohistory()
    {
        $user_id = $this->getUserId();
        $data = Db::name('history')
            ->where('user_id',$user_id)
            ->delete();
        if(empty($data)){
            $this->error('sql执行失败');
        }else{
            $this->success('success');
        }
    }


    /**
     * @ApiTitle    (用户农场信息)
     * @ApiSummary  (用户农场信息)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/farm/other)
     *
     * @ApiParams   (name="farm_id", type="int", required=false, description="农场id")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "SUCCESS",
        "time": "1553839125",
        "data": {
        "id":"id",//农场id
        "name"://农场名称
        "avatar"://用户头像
        }
        })
     */
    public function other()
    {
        $farm_id = $this->request->param('farm_id');
        if(empty($farm_id)){
            $this->error('缺少必要参数');
        }
        $data = Db::name('farm')
            ->alias('a')
            ->join('user b','a.user_id = b.id')
            ->field('a.id,a.name,b.avatar')
            ->where('a.id',$farm_id)
            ->find();
        $this->success('success',$data);
    }


}