<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2020/7/10
 * Time: 17:32
 */

namespace app\api\controller;


use app\common\controller\Api;
use think\Cache;
use think\Db;
use think\Validate;
use think\Exception;
use think\exception\PDOException;
use app\api\model\House;
use app\api\model\HouseAdmin as HouseAdminModel;
use app\api\model\HouseBoard;
use app\api\model\UserHouse;
use app\api\model\HousePhone;
use app\api\model\Message;
use app\api\model\StoreComment;
use app\api\model\HouseComment;

 /**
 * 社区管理员
 */
class HouseAdmin extends Api
{
    protected $noNeedLogin = [''];
    protected $noNeedRight = ['*'];

    /**
     * @ApiTitle    (社区管理员-首页)
     * @ApiSummary  (社区管理员-首页)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="house_id", type="inter", required=false, description="社区ID")
     * @ApiReturn({
        "code": 1,
        "msg": "success",
        "time": "1598707632",
        "data": {
            "id": 4, //管理员ID
            "house_id": 17, //小区ID
            "is_direct": 1, //是否为主管理员 1是2否
            "nickname": "", //管理员昵称
            "avatar": "", //管理员头像
            "house": { // 小区信息
                "id": 17, //小区ID
                "name": "碧海花园小区" //小区名称
            }
        }
    })
     */
    public function index()
    {
        $user_id = $this->auth->id;
        $house_id = $this->request->param('house_id');
        if($house_id){
            $info = HouseAdminModel::get(['user_id'=>$user_id,'house_id'=>$house_id],['house']);
//            empty($info) && $this->error('您不是该小区的管理员');
            if(empty($info)) {
//                $info = HouseAdminModel::with(['house'])
//                    ->where(['user_id'=>$user_id])
//                    ->order(['is_direct'=>'asc','createtime'=>'asc'])
//                    ->field('id,house_id,is_direct,nickname,avatar')
//                    ->find();
                $house = House::get($house_id);
                $info = HouseAdminModel::get($house['admin_user_id']);
                if($info){
                    $info['house_id'] = $house_id;
                    $info['house'] = $house;
                }else{
                    $info = HouseAdminModel::with(['house'])
                        ->where(['user_id'=>$user_id])
                        ->order(['is_direct'=>'asc','createtime'=>'asc'])
                        ->field('id,house_id,is_direct,nickname,avatar')
                        ->find();
                }
            }
            $info->visible(['id','house_id','is_direct','nickname','avatar','house'])->toArray();
        }else{
            $info = HouseAdminModel::with(['house'])
            	->where(['user_id'=>$user_id])
                ->order(['is_direct'=>'asc','createtime'=>'asc'])
                ->field('id,house_id,is_direct,nickname,avatar')
                ->find();
            empty($info) && $this->error('您还不是管理员');
        }
        $info['avatar'] = cdnurl($info['avatar'],true);
        $info->house->visible(['id','name']);
        $this->success('success',$info);
    }

    /**
     * @ApiTitle    (社区管理员-选择社区)
     * @ApiSummary  (社区管理员-选择社区)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/house_admin/houseList)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="keyword", type="string", required=false, description="关键字")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "success",
        "time": "1598688508",
        "data": [{
            "id": 16, //小区ID
            "name": "兴安苑", //小区名称
        }]
    })
     */
    public function houseList()
    {
        $user = $this->auth->getUser();
        $keyword = $this->request->param('keyword');
        $where = [];
//        if(!empty($keyword)){
//            $where['h.name'] = ['like',"%$keyword%"];
//        }
//        // 查出该管理员已绑定的小区
//        $list = HouseAdminModel::alias('ha')
//            ->join('house h','h.id = ha.house_id')
//            ->where('ha.user_id',$user['id'])
//            ->where($where)
//            ->field("h.id,h.name")
//            ->order('ha.is_direct')
//            ->select();
        // 社区管理员管理多个小区
        $house_ids = [];
        $house_list = HouseAdminModel::where('user_id',$user['id'])->field('id,house_id')->select();
        if(count($house_list) > 0){
            $house_ids = array_merge($house_ids,array_column($house_list,'house_id'));
            $house_admin_ids = array_column($house_list,'id');
            if($house_admin_ids){
                $house_ids = array_merge($house_ids,House::where('admin_user_id','in',$house_admin_ids)->column('id'));
            }
        }
        $house_ids = array_filter(array_unique($house_ids));
        if ($house_ids) {
            $where['id'] = ['in',$house_ids];
        }
        // 关键字
        if(!empty($keyword)){
            $where['name'] = ['like',"%$keyword%"];
        }
        $list = House::where($where)->field('id,name')->select();
        $this->success('success',$list);
    }

    /**
     * @ApiTitle    (社区管理员-个人信息)
     * @ApiSummary  (社区管理员-个人信息)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/house_admin/profile)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="house_id", type="inter", required=false, description="社区ID")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "success",
        "time": "1598753244",
        "data": {
            "nickname": "", //昵称
            "avatar": "http://community.qiniu.brotop.cn", //头像
            "mobile": "" //手机号
        }
    })
     */
    public function profile()
    {
        $house_id = $this->request->param('house_id');
        empty($house_id) && $this->error('缺少必要参数');
        $info = HouseAdminModel::where(['user_id'=>$this->auth->id,'house_id'=>$house_id])->field('id,nickname,avatar,mobile')
            ->find();
        if(!$info){
            $admin_user_id = House::where('id',$house_id)->value('admin_user_id');
            $info = HouseAdminModel::where(['id'=>$admin_user_id,'user_id'=>$this->auth->id])->field('id,nickname,avatar,mobile')->find();
        }
        $info['avatar'] = cdnurl($info['avatar'],true);
        $this->success('success',$info);
    }

    /**
     * 社区管理员-个人信息编辑
     * @param string $house_id 社区ID
     * @param string $avatar   头像地址
     * @param string $nickname 昵称
     */
    public function profileEdit()
    {
        $house_id = $this->request->param('house_id');
        $nickname = $this->request->param('nickname');
        $avatar = $this->request->param('avatar', '', 'trim,strip_tags,htmlspecialchars');

        empty($house_id) && $this->error('缺少必要参数');
        $admin = HouseAdminModel::get(['user_id'=>$this->auth->id,'house_id'=>$house_id]);
        if(!$admin){
            $house = House::get($house_id);
            $admin = HouseAdminModel::get(['id'=>$house['admin_user_id'],'user_id'=>$this->auth->id]);
        }
        empty($admin) && $this->error('您不是该小区的管理员');

        $admin->nickname = $nickname;
        $admin->avatar = $avatar;
        $admin->save();
        $this->success();
    }

    /**
     * 社区管理员-修改手机号
     * @param string $house_id 社区ID
     * @param string $mobile   手机号
     * @param string $captcha 验证码
     */
    public function changemobile()
    {
        $house_id = $this->request->param('house_id');
        $mobile = $this->request->param('mobile');
        $captcha = $this->request->param('captcha');
        empty($house_id) && $this->error('缺少必要参数');
        empty($mobile) && $this->error('请输入手机号');
        empty($captcha) && $this->error('请输入验证码');
        if (!Validate::regex($mobile, "^1\d{10}$")) {
            $this->error('手机号格式不正确');
        }
        $admin = HouseAdminModel::get(['user_id'=>$this->auth->id,'house_id'=>$house_id]);
        if(!$admin){
            $house = House::get($house_id);
            $admin = HouseAdminModel::get(['id'=>$house['admin_user_id'],'user_id'=>$this->auth->id]);
        }
        empty($admin) && $this->error('您不是该小区的管理员');
        // 检查手机号是否存在
        $mobile_exists = HouseAdminModel::where('mobile',$mobile)
            ->where('house_id',$house_id)
            ->where('id', '<>', $admin->id)
            ->find();
        if ($mobile_exists) {
            $this->error('手机号已被占用');
        }
        $code = Cache::get($mobile);
        if ($code != $captcha) {
            $this->error('验证码不正确');
        }
        $admin->mobile = $mobile;
        $admin->save();

        Cache::rm($mobile); 
        $this->success();
    }

    /**
     * @ApiTitle    (社区管理员-公告管理)
     * @ApiSummary  (社区管理员-公告管理)
     * @ApiMethod   (POST)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="house_id", type=inter, required=true, description="社区id")
     * @ApiParams   (name="page", type="inter", required=false, description="当前页(默认1)")
     * @ApiParams   (name="pageNum", type="inter", required=false, description="每页显示数据个数（默认10）")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "success",
        "time": "1598755666",
        "data": {
            "total_num": 1, //数据总条数
            "info": [{
                "id": 1, //公告id
                "title": "周六交电费", //社区公告标题
                "content": "", //社区公告内容
                "look_num": 2, //浏览人数
                "createtime": "2020-08-19", //时间
                "images": "", //社区公告图片
                "images_arr": [ //社区公告图片数组
                    "http://community.qiniu.brotop.cn"
                ],
                "nickname": "", //管理员昵称
                "avatar": "http://community.qiniu.brotop.cn", //管理员头像
                "is_delete": 2, //是否下架:1=下架,2=未下架
                "avatar_list": [{ //用户头像
                    "avatar": "",
                    "id": 1
                }]
            }]
        }
    })
     */
    public function house_board_list()
    {
        $page = $this->request->param('page', 1, 'intval');
        $pageNum = $this->request->param('pageNum', 10, 'intval');
        $house_id = $this->request->param('house_id');
        empty($house_id) && $this->error('社区id不能为空');
        $where = ['hb.house_id'=>$house_id];
        $total_num = HouseBoard::where($where)
            ->alias('hb')
            ->join('house_admin ha','ha.id = hb.admin_user_id')
            ->count();
        $list = $this->getBoardList($where,$page,$pageNum);
        $this->success('success',compact('total_num','list'));
    }

    /**
     * @ApiTitle    (社区管理员-公告管理-详情)
     * @ApiSummary  (社区管理员-公告管理-详情)
     * @ApiMethod   (POST)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="house_board_id", type="inter", required=true, description="公告id")
     *
     *
     * @ApiReturn({
        "code": 1,
        "msg": "success",
        "time": "1598755666",
        "data": {
            "id": 1, //公告id
            "title": "周六交电费", //社区公告标题
            "content": "", //社区公告内容
            "look_num": 2, //浏览人数
            "createtime": "2020-08-19", //时间
            "images": "", //社区公告图片
            "images_arr": [ //社区公告图片数组
                "http://community.qiniu.brotop.cn"
            ],
            "nickname": "", //管理员昵称
            "avatar": "http://community.qiniu.brotop.cn", //管理员头像
            "is_delete": 2, //是否下架:1=下架,2=未下架
            "avatar_list": [{ //用户头像
                "avatar": "",
                "id": 1
            }]
        }
    })
     */
    public function house_board_detail()
    {
        $house_board_id = $this->request->param('house_board_id');
        empty($house_board_id) && $this->error('缺少必要参数');
        $data = $this->getBoardList(['hb.id'=>$house_board_id],1,1);
        empty($data) && $this->error('公告信息不存在');
        $this->success('success',$data[0]);
    }

    /**
     * 获取公告数据
     */
    private function getBoardList($where,$page,$pageNum){
        $list = HouseBoard::where($where)
            ->alias('hb')
            ->join('house_admin ha','ha.id = hb.admin_user_id')
            ->field('
                hb.id,
                hb.title,
                hb.content,
                hb.look_num,
                hb.createtime,
                hb.deletetime,
                hb.images,
                ha.nickname,
                ha.avatar
            ')
            ->order('weigh desc')
            ->page($page,$pageNum)
            ->select();
        foreach ($list as &$v){
            $v['avatar'] = cdnurl($v['avatar'],true);
            $v['createtime'] = date('Y-m-d',$v['createtime']);
            // 公告图片
            $images_arr = [];
            if(!empty($v['images'])){
                foreach (explode(',', $v['images']) as $key => $value) {
                    $images_arr[] = cdnurl($value,true);
                }
            }
            $v['images_arr'] = $images_arr;
            $v['is_delete'] = $v['deletetime'] > 0 ? 1 : 2;
            $avatar_list = Db::name('house_board_detail')
                ->alias('a')
                ->join('user b','a.user_id = b.id')
                ->where('a.house_board_id',$v['id'])
                ->field('b.avatar,b.id')
                ->limit(6)
                ->select();
            foreach ($avatar_list as &$va) {
                $va['avatar'] = cdnurl($va['avatar'],true);
            }
            $v['avatar_list'] = $avatar_list;
            unset($v['deletetime']);
        }
        return $list;
    }

    /**
     * @ApiTitle    (社区管理员-公告管理-发布-获取剩余次数)
     * @ApiSummary  (社区管理员-公告管理-发布-获取剩余次数)
     * @ApiMethod   (POST)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="house_id", type="inter", required=true, description="社区ID")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "success",
        "time": "1598771268",
        "data": {
            "times": 2 //本周剩余发布次数
        }
    })
     */
    public function house_board_times()
    {
        $house_id = $this->request->param('house_id');
        empty($house_id) && $this->error('缺少必要参数');
        $count = HouseBoard::whereTime('createtime', 'week')
            ->where('house_id',$house_id)
            ->count();
        // 社区每周可发布公告次数
        $house_board_count = config('site.house_board_count');
        $times = $count >= $house_board_count ? 0 : $house_board_count-$count;
        $this->success('success',compact('times'));
    }

    /**
     * @ApiTitle    (社区管理员-公告管理-发布)
     * @ApiSummary  (社区管理员-公告管理-发布)
     * @ApiMethod   (POST)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="house_id", type="inter", required=true, description="社区ID")
     * @ApiParams   (name="title", type="string", required=true, description="公告标题")
     * @ApiParams   (name="content", type="string", required=true, description="公告内容")
     * @ApiParams   (name="images", type="string", required=false, description="公告图片")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "success",
        "time": "1598755666"
    })
     */
    public function house_board_add()
    {
        $post = $this->request->param();
        empty($post['house_id']) && $this->error('缺少必要参数');
        empty($post['title']) && $this->error('请填写公告标题');
        empty($post['content']) && $this->error('请填写公告内容');
        $admin = HouseAdminModel::get(['user_id'=>$this->auth->id,'house_id'=>$post['house_id']]);
        if(!$admin){
            $house = House::get($post['house_id']);
            $admin = HouseAdminModel::get(['id'=>$house['admin_user_id'],'user_id'=>$this->auth->id]);
        }
        empty($admin) && $this->error('您不是该小区的管理员');
        $count = HouseBoard::whereTime('createtime', 'week')
            ->where('house_id',$post['house_id'])
            ->count();
        // 社区每周可发布公告次数
        $house_board_count = config('site.house_board_count');
        $count >= $house_board_count && $this->error('本周发布次数已用完');
        $images = $this->request->param('images/a');
        $post['images'] = implode(',',$images);
        Db::startTrans();
        try{
            (new HouseBoard)->allowField(true)->save(array_merge([
                'admin_user_id' => $admin['id']
            ],$post));
            // 该社区下的业主ID
            $user_id_arr = UserHouse::where('house_id',$post['house_id'])
                ->where('status',2)
                ->column('user_id');
            // 发送模板消息
            if(!empty($user_id_arr)){
                $house_name = House::where('id',$post['house_id'])->value('name');
                $send_data = array(
                    "first"  => '您绑定的社区【'.$house_name.'】发布了一条公告',
                    "keyword1" => $post['title'],
                    "keyword2"  => date('Y-m-d H:i:s',time()),
                    "keyword3"  => $post['content'],
                    "remark" => ['点击查看详情','#FF0000'],
                );
                $url = config('option.vue_url') . '/?house_id='.$post['house_id'];
                foreach ($user_id_arr as $user_id) {
                    $openid = Db::name('third')->where('user_id',$user_id)->value('openid');
                    (new \app\index\controller\Ajax)->wxsendmessage($openid,$send_data,config('option.template')['house_notice'],$url);
                }
            }
            Db::commit();
        } catch (PDOException $e) {
            Db::rollback();
            $this->error($e->getMessage());
        } catch (Exception $e) {
            Db::rollback();
            $this->error($e->getMessage());
        }
        $this->success('success');
    }

    /**
     * @ApiTitle    (社区管理员-公告管理-下架)
     * @ApiSummary  (社区管理员-公告管理-下架)
     * @ApiMethod   (POST)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="house_id", type="inter", required=true, description="社区ID")
     * @ApiParams   (name="house_board_id", type="inter", required=true, description="社区公告ID")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "success",
        "time": "1598755666"
    })
     */
    public function house_board_delete()
    {
        $house_id = $this->request->param('house_id');
        $house_board_id = $this->request->param('house_board_id');
        if(!$house_id || !$house_board_id){
            $this->error('缺少必要参数');
        }
        $admin = HouseAdminModel::get(['user_id'=>$this->auth->id,'house_id'=>$house_id]);
        if(!$admin){
            $house = House::get($house_id);
            $admin = HouseAdminModel::get(['id'=>$house['admin_user_id'],'user_id'=>$this->auth->id]);
        }
        empty($admin) && $this->error('您不是该小区的管理员');
        $info = HouseBoard::get(['house_id'=>$house_id,'id'=>$house_board_id]);
        empty($info) && $this->error('公告信息不存在');

        $info->deletetime = time();
        $info->save();
        $this->success('success');
    }

    /**
     * @ApiTitle    (社区管理员-管理员管理)
     * @ApiSummary  (社区管理员-管理员管理)
     * @ApiMethod   (POST)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="house_id", type="inter", required=true, description="社区ID")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "success",
        "time": "1598755666"
    })
     */
    public function adminList()
    {
        $house_id = $this->request->param('house_id');
        empty($house_id) && $this->error('缺少必要参数');
        // 所有子管理员
        $list = HouseAdminModel::where('house_id',$house_id)
            ->where('is_direct',2)
            ->field('id,nickname,user_id,mobile')
            ->select();
        $this->success('success',$list);
    }

    /**
     * @ApiTitle    (社区管理员-管理员管理-添加)
     * @ApiSummary  (社区管理员-管理员管理-添加)
     * @ApiMethod   (POST)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="house_id", type="inter", required=true, description="社区ID")
     * @ApiParams   (name="nickname", type="string", required=true, description="姓名")
     * @ApiParams   (name="id_num", type="inter", required=true, description="用户ID")
     * @ApiParams   (name="mobile", type="string", required=true, description="手机号")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "success",
        "time": "1598755666"
    })
     */
    public function adminAdd()
    {
        $post = $this->request->param();
        empty($post['house_id']) && $this->error('缺少必要参数');
        empty($post['nickname']) && $this->error('请填写姓名');
        empty($post['id_num']) && $this->error('请填写用户ID');
        empty($post['mobile']) && $this->error('请填写手机号');
        if (!Validate::regex($post['mobile'], "^1\d{10}$")) {
            $this->error(__('Mobile is incorrect'));
        }
        $user = $this->auth->getUser();
        if(!HouseAdminModel::get(['user_id'=>$user['id'],'house_id'=>$post['house_id'],'is_direct'=>1])){
            $this->error('您不是该小区的主管理员，无法添加子管理员');
        }
        if(!$admin_user = \app\api\model\User::get(['id_num'=>$post['id_num']])){
            $this->error('用户不存在');
        }
        if($admin_user['id'] == $user['id']){
            $this->error('您不能添加自己');
        }
        if(HouseAdminModel::get(['user_id'=>$admin_user['id'],'house_id'=>$post['house_id']])){
            $this->error('该用户已是当前小区的管理员，请勿重复添加');
        }

        Db::startTrans();
        if(!$houseAdminModel = HouseAdminModel::get(['user_id'=>$admin_user['id'],'house_id'=>0])){
            $houseAdminModel = new HouseAdminModel;
        }
        $result = $houseAdminModel->allowField(true)->save(array_merge([
            'user_id' => $admin_user['id'],
            'avatar' => $admin_user['avatar'],
            'is_direct' => 2
        ],$post));
        if($admin_user['identity'] == 0 && !$admin_user->save(['identity' => 2])){
            Db::rollback();
            $this->error('添加管理员失败');
        }
        if (!$result) {
            Db::rollback();
            $this->error('添加管理员失败');
        }
        Db::commit();
        $this->success('success');
    }

    /**
     * @ApiTitle    (社区管理员-管理员管理-删除)
     * @ApiSummary  (社区管理员-管理员管理-删除)
     * @ApiMethod   (POST)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="house_id", type="inter", required=true, description="社区ID")
     * @ApiParams   (name="house_admin_id", type="inter", required=true, description="社区管理员ID")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "success",
        "time": "1598755666"
    })
     */
    public function adminDelete()
    {
        $house_id = $this->request->param('house_id');
        $house_admin_id = $this->request->param('house_admin_id');
        if(!$house_id || !$house_admin_id){
            $this->error('缺少必要参数');
        }
        $admin = HouseAdminModel::get(['user_id'=>$this->auth->id,'house_id'=>$house_id,'is_direct'=>1]);
        empty($admin) && $this->error('您不是该小区的主管理员');
        $info = HouseAdminModel::get(['id'=>$house_admin_id,'is_direct'=>2]);
        empty($info) && $this->error('子管理员不存在');

        $info->delete();
        $this->success('success');
    }

    /**
     * @ApiTitle    (社区管理员-业主列表)
     * @ApiSummary  (社区管理员-业主列表)
     * @ApiMethod   (POST)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="house_id", type="inter", required=true, description="社区ID")
     * @ApiParams   (name="keyword", 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": "1598838987",
        "data": {
            "total_num": 1, //总条数
            "list": [{
                "id": 1, //业主ID
                "avatar": "http://community.qiniu.brotop.cn", //业主头像
                "name": "liujianch", //业主名称
                "remark": "" //业主备注
            }]
        }
    })
     */
    public function userList()
    {
        $page = $this->request->param('page', 1, 'intval');
        $pageNum = $this->request->param('pageNum', 10, 'intval');
        $house_id = $this->request->param('house_id');
        $keyword = $this->request->param('keyword');
        empty($house_id) && $this->error('缺少必要参数');
        $where['uh.house_id'] = $house_id;
        $where['uh.status'] = 2;
        if(!empty($keyword)){
            $where['uh.name|uh.remark'] = ['like','%'.$keyword.'%'];
        }
        $total_num = UserHouse::alias('uh')
            ->join('user u','u.id = uh.user_id')
            ->where($where)
            ->count();
        $list = UserHouse::alias('uh')
            ->join('user u','u.id = uh.user_id')
            ->where($where)
            ->field('uh.id,u.avatar,uh.name,uh.remark')
            ->order('uh.createtime desc')
            ->page($page,$pageNum)
            ->select();
        foreach($list as &$v){
            $v['avatar'] = cdnurl($v['avatar']);
        }
        $this->success('success',compact('total_num','list'));
    }

    /**
     * @ApiTitle    (社区管理员-业主列表-添加备注)
     * @ApiSummary  (社区管理员-业主列表-添加备注)
     * @ApiMethod   (POST)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="user_house_id", type="inter", required=true, description="社区业主ID")
     * @ApiParams   (name="remark", type="string", required=true, description="备注")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "success",
        "time": "1598755666"
    })
     */
    public function remarkAdd()
    {
        $user_house_id = $this->request->param('user_house_id');
        $remark = $this->request->param('remark');
        empty($user_house_id) && $this->error('缺少必要参数');
        empty($remark) && $this->error('请填写备注');
        $info = UserHouse::get($user_house_id);
        empty($info) && $this->error('业主信息不存在');

        $info->remark = $remark;
        $info->save();
        $this->success('success');
    }

    /**
     * @ApiTitle    (社区管理员-留言消息)
     * @ApiSummary  (社区管理员-留言消息)
     * @ApiMethod   (POST)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="house_id", type="inter", required=true, description="社区ID")
     * @ApiParams   (name="page", type="inter", required=false, description="当前页(默认1)")
     * @ApiParams   (name="pageNum", type="inter", required=false, description="每页显示数据个数（默认10）")
     *
     * @ApiReturn({
        'code': '1',
        'msg': '返回成功',
        "data": {
            "list": [{
                    "id": 3,
                    "user_id": 1,
                    "object_id": 1,
                    "object_user_id": 1,
                    "type": 消息类型1 = 平台2 = 商家3 = 社区,
                    "content": "文字内容",
                    "image": "图片",
                    "is_read_user": 是否已读1 = 是2 = 否,
                    "name": "平台/店铺/社区名称"
                    "createtime": "2020-08-30 10:43:55",
                },
                {
                    "id": 1,
                    "user_id": 1,
                    "object_id": 1,
                    "object_user_id": 1,
                    "type": 1,
                    "content": "123",
                    "image": "",
                    "is_read_user": 1,
                    "name": "平台消息"
                    "createtime": "2020-08-30 09:36:45",
                }
            ],
            "total_num": 总条数,
        }
    })
     */
    public function messageList()
    {
        $page = $this->request->param('page', 1, 'intval');
        $pageNum = $this->request->param('pageNum', 10, 'intval');
        $house_id = $this->request->param('house_id');
        empty($house_id) && $this->error('缺少必要参数');
        $where = ['object_user_id'=>$this->auth->id];
        $total_num = Message::where('object_id',$house_id)
            ->where($where)
            ->count();
        $list = Message::where('object_id',$house_id)
            ->where($where)
            ->page($page,$pageNum)
            ->order('createtime desc')
            ->select();
        foreach ($list as &$v){
            $v['name'] = '平台消息';
            if($v['type'] == 2) {
                $v['name'] = Db::name('store')->where('id',$v['object_id'])->value('store_name');
            }
            if($v['type'] == 3) {
                $v['name'] = Db::name('user')->where('id',$v['user_id'])->value('nickname');
            }
            $v['createtime'] = strtotime($v['updatetime']);
        }
        $this->success('success',compact('total_num','list'));
    }

    /**
     * @ApiTitle    (社区管理员-留言消息-详情)
     * @ApiSummary  (社区管理员-留言消息-详情)
     * @ApiMethod   (POST)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="message_id", type="inter", required=true, description="消息ID")
     * @ApiParams   (name="page", type="inter", required=false, description="当前页(默认1)")
     * @ApiParams   (name="pageNum", type="inter", required=false, description="每页显示数据个数（默认10）")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "success",
        "time": "1598839065",
        "data": {
            "total_num": 1, //总条数
            "list": [{
                "id": 1,
                "user_id": 1,
                "house_id": 16,
                "house_user_id": 2,
                "type": 1, //发送人1 = 用户2 = 社区 / 商家,
                "content": "你好", //文字内容
                "image": "", //图片
                "createtime": "1970-01-01 08:00:00",
                "user": {
                    "id": 1,
                    "nickname": "StTazBfCvMrqXc4UHJYn",
                    "avatar": "http://community.qiniu.brotop.cn/assets/img/avatar.png"
                }
            }]
        }
    })
     */
    public function messageDetail()
    {
        $page = $this->request->param('page', 1, 'intval');
        $pageNum = $this->request->param('pageNum', 10, 'intval');
        $message_id = $this->request->param('message_id');

        empty($message_id) && $this->error('缺少必要参数');
        $msg = Message::get($message_id);
        empty($msg) && $this->error('消息不存在');

        $msg->is_read_object = 1;
        $msg->save();
        $where = [
            'user_id' => $msg['user_id'],
            'house_id' => $msg['object_id'],
            'house_user_id' => $msg['object_user_id'],
        ];
        $total_num = HouseComment::where($where)->count();
        $list = HouseComment::where($where)->order(['createtime'=>'desc'])
            ->page($page,$pageNum)
            ->select();
        array_multisort(array_column($list,'createtime'),SORT_ASC,$list);
        // 业主头像
        $user_model = new \app\api\model\User();
        foreach ($list as &$v) {
            if($v['type'] == 1) {
                $user = $user_model->field('id,nickname,avatar')->where('id',$v['user_id'])->find();
            }else{
                $user = HouseAdminModel::where(['user_id'=>$this->auth->id,'house_id'=>$msg['object_id']])->field('id,nickname,avatar')->find();
                // 多管理员
                if(!$user){
                    $house = House::get($msg['object_id']);
                    $user = HouseAdminModel::where(['id'=>$house['admin_user_id'],'user_id'=>$this->auth->id])->field('id,nickname,avatar')->find();
                }
            }
            $user['avatar'] = cdnurl($user['avatar'],true);
            $v['user'] = $user;
        }
        $this->success('success',compact('total_num','list'));
    }

    /**
     * @ApiTitle    (社区管理员-留言消息-回复)
     * @ApiSummary  (社区管理员-留言消息-回复)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="message_id", type="integer", required=true, description="消息ID")
     * @ApiParams   (name="content", type="string", required=true, description="留言内容")
     * @ApiParams   (name="image", type="string", required=true, description="图片")
     * @ApiReturnParams   (name="code", type="integer", required=true, sample="0")
     * @ApiReturnParams   (name="msg", type="string", required=true, sample="返回成功")
     * @ApiReturn   ({
    'code':'1',
    'msg':'返回成功'
    })
     */
    public function messageReply()
    {
        $message_id = $this->request->param('message_id');
        $content = $this->request->param('content');
        $image = $this->request->param('image');
        empty($message_id) && $this->error('缺少必要参数');
        if(empty($content) && empty($image)) {
            $this->error('请填写内容或上传图片');
        }
        $msg = Message::get($message_id);
        empty($msg) && $this->error('留言消息不存在');
        Db::startTrans();
        try{
            HouseComment::create([
                'user_id' => $msg['user_id'],
                'house_id' => $msg['object_id'],
                'house_user_id' => $msg['object_user_id'],
                'type' => 2,
                'content' => $content,
                'image' => $image,
            ]);
            // 记录最新内容
            $msg = Message::get([
                'user_id' => $msg['user_id'],
                'object_id' => $msg['object_id'],
                'object_user_id' => $msg['object_user_id'],
            ]);
            $msg->content = $content;
            $msg->image = $image;
            $msg->is_read_user = 2;
            $msg->is_read_object = 1;
            $msg->type = 3;
            $msg->save();
            // 发送模板消息
            $send_data = array(
                "first"  => '您有一条新的消息',
                'keyword1' => $content ? $content : '【图片消息】',
                "keyword2"  => date('Y-m-d H:i:s',time()),
                "remark" => ['点击查看详情','#FF0000'],
            );
            $openid = Db::name('third')->where('user_id',$msg['user_id'])->value('openid');
            $url = config('option.vue_url') . '/messagelk?is_template=1&house_id='.$msg['object_id'].'&user_id='.$msg['object_user_id'];
            (new \app\index\controller\Ajax)->wxsendmessage($openid,$send_data,config('option.template')['msg'],$url);
            Db::commit();
        } catch (PDOException $e) {
            Db::rollback();
            $this->error($e->getMessage());
        } catch (Exception $e) {
            Db::rollback();
            $this->error($e->getMessage());
        }
        $this->success('回复成功');
    }

    /**
     * @ApiTitle    (社区管理员-社区信息)
     * @ApiSummary  (社区管理员-社区信息)
     * @ApiMethod   (POST)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="house_id", type="inter", required=true, description="社区ID")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "success",
        "time": "1598755666"
    })
     */
    public function phoneList()
    {
        $house_id = $this->request->param('house_id');
        empty($house_id) && $this->error('缺少必要参数');
        $list = HousePhone::where('house_id',$house_id)
            ->field('id,name,phone,weigh')
            ->order('weigh asc')
            ->select();
        $this->success('success',$list);
    }

    /**
     * @ApiTitle    (社区管理员-社区信息-添加)
     * @ApiSummary  (社区管理员-社区信息-添加)
     * @ApiMethod   (POST)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="house_id", type="inter", required=true, description="社区ID")
     * @ApiParams   (name="name", type="string", required=true, description="标题")
     * @ApiParams   (name="phone", type="string", required=true, description="手机号")
     * @ApiParams   (name="weigh", type="inter", required=true, description="排序号")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "success",
        "time": "1598755666"
    })
     */
    public function phoneAdd()
    {
        $post = $this->request->param();
        empty($post['house_id']) && $this->error('缺少必要参数');
        empty($post['name']) && $this->error('请填写标题');
        empty($post['phone']) && $this->error('请填写电话');
        empty($post['weigh']) && $this->error('请填写排序号');
        if (!Validate::regex($post['phone'], "^1\d{10}$") && !Validate::regex($post['phone'], "^([0-9]{3,4}-)?[0-9]{7,8}$")) {
            $this->error('电话格式不正确');
        }
        $admin = HouseAdminModel::get(['user_id'=>$this->auth->id,'house_id'=>$post['house_id'],'is_direct'=>1]);
        empty($admin) && $this->error('您不是该小区的主管理员');

        (new HousePhone)->allowField(true)->save($post);
        $this->success('success');
    }

    /**
     * @ApiTitle    (社区管理员-社区信息-删除)
     * @ApiSummary  (社区管理员-社区信息-删除)
     * @ApiMethod   (POST)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="house_id", type="inter", required=true, description="社区ID")
     * @ApiParams   (name="house_phone_id", type="inter", required=true, description="社区电话ID")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "success",
        "time": "1598755666"
    })
     */
    public function phoneDelete()
    {
        $house_id = $this->request->param('house_id');
        $house_phone_id = $this->request->param('house_phone_id');
        if(!$house_id || !$house_phone_id){
            $this->error('缺少必要参数');
        }
        $admin = HouseAdminModel::get(['user_id'=>$this->auth->id,'house_id'=>$house_id,'is_direct'=>1]);
        empty($admin) && $this->error('您不是该小区的主管理员');
        $info = HousePhone::get($house_phone_id);
        empty($info) && $this->error('电话信息不存在');

        $info->delete();
        $this->success('success');
    }
}