crm/app/client/controller/Building.php

<?php

namespace app\client\controller;

use app\event\FootPrints;
use app\event\Msg;
use app\model\Building as BuildingModel;
use app\model\BuildingConstruction;
use app\model\BuildingHousetype;
use app\model\BuildingMaterialCase;
use app\model\BuildingProgress;
use app\model\BuildingUrge;
use app\model\Construction as ConstructionModel;
use app\model\ConstructionRecord;
use app\model\ConstructionStep;
use app\model\User;
use app\model\Company;
use xiaohongwu\Vr;
use app\model\BuildingDevelopCase;
use app\model\Decostyle;
use app\model\BuildingSpecialEmp;
use app\model\Community;
use app\model\MaterialCase;
use app\model\VrGroup;
class Building extends Base
{
    /**
     * vr楼书列表
     */
    public function index(){
        $order_input = input('order', 'new', 'trim');
        $order = 'update_time desc';
        if ($order_input == 'new') {
            $order = 'update_time desc';
        } elseif ($order_input == 'hot'){
            $order = 'share_log_count desc';
        }
        $model = BuildingModel::with(['share_log'])->withCount(['share_log'=> function ($query) {
            $query->where([['type', '=', 'Building']]);
        }]);

        $root_id = $this->request->token['root_org'];
        $where[] = ['root_id', '=', $root_id];

        $name = input('name', '', 'trim');
        if ($name) {
            $condition = [
                ['root_id', '=', $root_id],
                ['type', '=', 0],
                ['name', 'like', '%' . $name . '%']
            ];
            $community_id = Community::where($condition)->column('id');
            /**
             * 查询楼盘地址是否有匹配
             */
            $whereor1[] = ['community_id', 'in', $community_id];
            $whereor1[] = ['address','like','%'.$name.'%'];
            $adrids = BuildingModel::where($where)->where(function($query) use ($whereor1){
                $query->whereOr($whereor1);
            })->column('id');
            $where[] = ['id','in',$adrids];
        }
        $page = input('page', 1, 'intval');
        $token = $this->request->token;
        //查询设置可见人信息
        $special=BuildingSpecialEmp::where('root_id',$this->request->token['root_org'])->value('assign_employee');
        $assign_employee = !empty($special)? explode(',', $special):[];
        if ($token['isEmployee'] && !empty($token['employee_id']) && !in_array($token['employee_id'],$assign_employee)){
            $employee_id = $token['employee_id'];
            $model = $model->where($where)->where(function ($query) use ($employee_id){
                $query->whereRaw("FIND_IN_SET(" . $employee_id . " , assign_employee)")
                    ->whereOr('assign_employee', '=', NULL)
                    ->whereOr('assign_employee', '=', '');
            })->where(function ($query) use ($employee_id) {
                $query->whereRaw("`from` = 0 or (`from` =1 and `org_id` =" . $this->request->token['org_id'] . ") or ( `from` = 1 and (FIND_IN_SET(" . $employee_id . " , assign_employee)))");
            });
        } elseif (!$token['isEmployee'] && !empty($token['share_employee']) && !in_array($token['share_employee'],$assign_employee)) {
            $employee_id = $token['share_employee'];
            $org_id = $token['share_org'];
            $model = $model->where($where)->where(function ($query) use ($employee_id){
                $query->whereRaw("FIND_IN_SET(" . $employee_id . " , assign_employee)")
                    ->whereOr('assign_employee', '=', NULL)
                    ->whereOr('assign_employee', '=', '');
            })->where(function ($query) use ($employee_id,$org_id) {
                $query->whereRaw("`from` = 0 or (`from` =1 and `org_id` =" . $org_id . ") or ( `from` = 1 and (FIND_IN_SET(" . $employee_id . " , assign_employee)))");
            });
        } else {
            $model = $model->where($where);
        }
        $list = $model->page($page, 10)->order($order)->select()->each(function ($item){
            $area_list = BuildingHousetype::where('building_id', '=', $item['id'])->order('area asc')->column('area');
            $item->area_list = array_values(array_unique(array_filter($area_list)));
        })->toArray();

        return json(['code'=> self::success, 'data'=> $list]);
    }

    /**
     * 详情
     */
    public function view(){
        $id = input('id', '', 'intval');
        $share = input('share', '', 'trim');

        $info = BuildingModel::find($id);
        if (empty($info)){
            return json(['code'=> self::error_msg, 'msg'=> '数据不存在']);
        }
        $area_list = BuildingHousetype::where('building_id', '=', $id)->order('area asc')->column('area');
        $info['area_list'] = array_values(array_unique(array_filter($area_list)));
        $company = Company::where('root_id', '=', $info['root_id'])->field(['company_name', 'logo'])->find();
        $info['company_name'] = $company['company_name'];
        $info['company_logo'] = $company['logo'];
        $info['company_address'] = $company['company_address'];

        //小区户型
        $housetype = BuildingHousetype::with(['devcase'=>function($query){
            $query->field('housetype_id,id,name,type,vr_link,content,cover,decostyles_id');
        }])->where('building_id', '=', $id)->withCount(['materialCase'])->select();
        //vr作品处理
        $show_url = config('app.vr_show_domain');
        foreach ($housetype as $key => $value) {
            $sid = VrGroup::where('id',$value['vr_group_ids'])->value('sid');
            $housetype[$key]['vr_link'] = $sid ? $show_url.$sid : '';
        }
        $xin = null;
        $vrObj = new Vr();
        if(!empty($housetype->toArray())){
            $houselist=$housetype->toArray();
            foreach($houselist as $key=>$val){
                if(empty($val['house_img']) && !empty($val['vr_link'])){
                    $houselist[$key]['house_img'][] = $vrObj->getFirstImg($val['vr_link']);
                }
                if(empty($val['devcase'])) continue;
                foreach($val['devcase'] as $k=>$v){
                    $houselist[$key]['devcase'][$k]['decostyles_name']=Decostyle::where('id',$v['decostyles_id'])->value('name');
                    $houselist[$key]['devcase'][$k]['area']=$val['area'];
                    $houselist[$key]['devcase'][$k]['room']=$val['room'];
                    $houselist[$key]['devcase'][$k]['hall']=$val['hall'];
                    $houselist[$key]['devcase'][$k]['bathroom']=$val['bathroom'];
                    if($v['type']==1){
                        $houselist[$key]['devcase'][$k]['cover'] = $vrObj->getFirstImg($v['vr_link']);
                }
                }
            }
            foreach($houselist as $key => $val){
                $xin[$val['room']][] = $val;
            }
            $xin[0] = $houselist;
        }
        $info['vr_link_cover']='';
        if(!empty($info['vr_link'])){
            $info['vr_link_cover']=$vrObj->getFirstImg($info['vr_link']);
        }elseif($info['vr_group_ids']){
            $vrgroup = VrGroup::where('id',$info['vr_group_ids'])->field('id,pic_path,sid')->findOrEmpty();
            if (!$vrgroup->isEmpty()) {
                $info['vr_link'] = $show_url.$vrgroup->sid;
                $info['vr_link_cover'] = $vrgroup->pic_path;
            }
        }
        $info['housetype'] = $xin;
        $info['housetype_count'] = $housetype->count();
        //增加进度图片视频VR数量查询 
        $prtype_list = BuildingProgress::where([['building_id', '=', $id]])->field('count(*) as count,type')->group('type')->select()->toArray();
        $info['prtype_list']=!empty($prtype_list)?$prtype_list:null;
        // 添加足迹
        $token = request()->token;
        if (!empty($token['uid']) && !$token['isEmployee'] && empty($share)) {
            event(new FootPrints($token['uid'], $token['share_employee'] ?? 0, $token['share_org'] ?? 0, $info, 'building'));
        }
        if (empty($share) && !$token['isEmployee']){
            BuildingModel::where('id', '=', $id)->inc('view_times')->update();
        }

        return json(['code'=> self::success, 'data'=> $info]);
    }
    //楼盘进度详情
    public function progress_detail()
    {
        $id = input('id', '', 'intval');
        $share = input('share', '', 'trim');
        $where[] = ['id', '=', $id];
        $data = BuildingProgress::where($where)->find();
        $vrObj = new Vr();
        if ($data['type'] == 'vr') {
            $vrUrlList = explode(',', $data['vr']);
            $vrData = [];
            foreach ($vrUrlList as $url) {
                $vrData[] = [
                    'vrUrl' => $url,
                    'vrfirstImg' => $vrObj->getFirstImg($url)
                ];
            }
            $data['vr'] = $vrData;
        }
        $token = request()->token;
        if (!empty($token['uid']) && !$token['isEmployee'] && empty($share)) {
            event(new FootPrints($token['uid'], $token['share_employee'] ?? 0, $token['share_org'] ?? 0, $data, 'progressDetail'));
        }
        //查询当前进度关联的楼盘名称
        $building_data=BuildingModel::where('id',$data['building_id'])->find();//->value('name');
        $data['building_name']=$building_data['name'];
        return json(['code' => self::success, 'data' => $data]);
    }

    /**
     * 楼盘进度
     */
    public function progress(){
        $id = input('id', '', 'intval');
        $type = input('type','','trim');
        $labelId = input('label_id');
        $where[]=['building_id', '=', $id];
        if(!empty($type)){
            $where[]=['type', '=', $type];
        }
        if($labelId)
            $where[]=['label_id','=',$labelId];
        $page = input('page',1);
        $limit = input('limit',3);
        $list = BuildingProgress::with(['label'=>function($query){
            $query->withField(['id','name']);
        }])->where($where)->order('addtime desc')->page($page,$limit)->select();
        if (empty($list)) $list = [];
        else $list = $list->toArray();
        $vrObj = new Vr();
        //vr作品处理
        $sids = VrGroup::where([['id','in',array_column($list,'vr_group_ids')]])->column('sid','id');
        $show_url = config('app.vr_show_domain');

        foreach ($list as &$item) {
            $vrData = [];

            if (!empty($item['vr'])) {
                $vrUrlList = explode(',', $item['vr']);
                foreach ($vrUrlList as $url) {
                    $vrData[] = [
                        'vrUrl' => $url,
                        'vrfirstImg' => $vrObj->getFirstImg($url)
                    ];
                }

            }elseif (!empty($item['vr_group_ids'])) {
                $vrgroup = VrGroup::where('id',$item['vr_group_ids'])->field('id,pic_path,sid')->findOrEmpty();
                $item['show_url'] = '';
                $item['show_img'] = '';
                if (!$vrgroup->isEmpty()) {
                    $item['show_url'] = $show_url.$vrgroup->sid;
                    $item['show_img'] = $vrgroup->pic_path;
                }

            }

            $item['vr'] = $vrData;

        }
        

        return json(['code' => self::success, 'data' => $list]);
    }
    //研发案例列表
    public function dev_case_list()
    {
        $id = input('id', '', 'intval');
        if(empty($id)) return json(['code'=>1,'msg'=>'参数错误']);
        $list= BuildingDevelopCase::with(['decostyles'])->where('housetype_id',$id)
        ->field('id,name,type,housetype_id,decostyles_id')
        ->select();
        return json(['code' => self::success, 'data' => $list]);
    }
    //研发案例详情
    public function dev_case_detail()
    {
        $id = input('id', '', 'intval');
        if(empty($id)) return json(['code'=>1,'msg'=>'参数错误']);
        $data=BuildingDevelopCase::with(['decostyles'])->where('id',$id)->find();
        $token = $this->request->token;
        if (!empty($token['uid']) && !$token['isEmployee']) {
            event(new FootPrints($token['uid'], $token['share_employee'] ?? 0, $token['share_org'] ?? 0, $data, 'devcase'));
        }
        return json(['code' => self::success, 'data' => $data]);
    }

    /**
     * 户型关联案例
     */
    public function material_case(){
        $housetype_id = input('housetype_id',0);
        $token = $this->request->token;
        $page = input('page',1);
        $limit = input('limit',10);
        $case_ids = BuildingMaterialCase::where([['housetype_id','=',$housetype_id],['root_id','=',$token['root_org']]])->column('material_case_id');
        if(empty($case_ids)) return json(['code' => 0, 'data' => [], 'msg' => '获取成功']);
        $where[] = ['id', 'in', $case_ids];
        $list = MaterialCase::with(['designer' => function ($query) {
            $query->field('id,name, headimgurl,addtime');
        }, 'community' => function ($query) {
            $query->field('id,name');
        }, 'decostyle' => function ($query) {
            $query->field('id,name');
        }])->page($page,$limit)->where($where)->select();

        $data = ['list'=> $list];
        $count = MaterialCase::where($where)->count();
        return json(['code' => 0, 'data' => $data,'count'=>$count, 'msg' => '获取成功']);

    }

    /**
     * 催更
     */
    public function urge(){
        $token = $this->request->token;
        $employee_id = input('employee_id', '', 'intval');
        $uid = $token['uid'] ?? 0;
        $building_id = input('building_id', '', 'intval');

        $data['building_id'] = $building_id;
        $data['urge_uid'] = $uid;
        $data['employee_id'] = $employee_id;
        $data['root_id'] = $token['root_org'];

        $result = BuildingUrge::create($data);
        if ($result) {
            $user = User::find($uid);
            $user_name = '客户';
            if (!empty($user)){
                $user_name = $user['nickname'];
            }
            $building = BuildingModel::find($building_id);
            if (!empty($building)) {
                $mdata=json_encode(['building_id'=>$building_id,'uid'=>$uid?$uid:0]);
                event(new Msg($employee_id, $user_name . '于' . date('Y-m-d H:i:s') . ' 催更' . $building['name'] . '施工进展。', 'building', $mdata));
                if (!empty($uid)) {
                    event(new FootPrints($uid, $employee_id,  $token['root_org'], $building, 'building_urge'));
                }
            }

            return json(['code'=> self::success, 'msg'=> '催更成功']);
        } else {
            return json(['code'=> self::error_msg, 'msg'=> '操作失败']);
        }
    }

    public function construction(){
        //$building_id = input('building_id', '', 'intval');
        //$construction_id = BuildingConstruction::where('building_id', '=', $building_id)->column('construction_id');
        //$where[] = ['id', 'in', $construction_id];
        $housetype_id = input('housetype_id', '', 'intval');
        $construction_str = BuildingHousetype::where('id',$housetype_id)->value('constructionid');
        $construction_id = !empty($construction_str) ? explode(',',$construction_str) : [];

        // $building_id = input('building_id', '', 'intval');
        // $construction_id = BuildingConstruction::where('building_id', '=', $building_id)->column('construction_id');
        $where[] = ['id', 'in', $construction_id];
        
        $page = input('page', 1, 'intval');
        $limit = input('limit', 10, 'intval');
        $root_id = $this->request->token['root_org'];
        $where[] = ['root_id', '=', $root_id];

        // $community_id = input('community_id', '', 'intval');
        // if ($community_id) {
        //     $where[] = ['community_id', '=', $community_id];
        // }

        $step_list = ConstructionStep::where('root_id', '=', $root_id)->order('order asc')->select()->toArray();

        $order_input = input('order', 'new', 'trim');
        $order = 'id desc';
        $model = ConstructionModel::with(['style', 'designer', 'housetype', 'community'])->withCount(['share_log'=> function ($query) {
            $query->where([['type', '=', 'construction']]);
        }]);
        if ($order_input == 'new'){
            $order = 'update_time desc';
        } else if ($order_input = 'hot') {
            $order = 'share_log_count desc';
        }

        $list = $model->where($where)->page($page, $limit)->order($order)->select()->each(function ($item) use ($step_list) {
            $record_list = ConstructionRecord::where([['construction_id', '=', $item['id']]])->order('update_time desc')->select();
            $step_now = 0; //进行到哪一步了
            foreach ($step_list as $k => $v) {
                foreach ($record_list as $kk => $vv) {
                    if ($v['id'] == $vv['step_id'] && $v['order'] > $step_now) {
                        $step_now = $v['order'];
                    }
                }
            }
            foreach ($step_list as $k => $v) {
                $step_list[$k]['upload'] = 0; // 判断是否上传
                $step_list[$k]['need_upload'] = 0; // 判断节点是否变色(已过此节点，但是没上传)
                $have = false; //是否有上传  true有
                $need_have = false; //没上传，但是后面的节点上传了 true是
                foreach ($record_list as $kk => $vv) {
                    if ($v['id'] == $vv['step_id']) {
                        $have = true;
                    }
                }
                if ($have == false && $v['order'] < $step_now) {
                    $need_have = true;
                }

                if ($have) {
                    $step_list[$k]['upload'] = 1;
                } elseif ($need_have) {
                    $step_list[$k]['need_upload'] = 1;
                }
            }
            $item->step_list = $step_list;
        });

        return json(['code' => self::success, 'data' => $list->toArray(), 'count' => $list->count()]);
    }
    //户型详情
    public function housetype_detail()
    {
        $id = input('id', '', 'intval');
        if(empty($id)) return json(['code'=> 1,'msg'=> '参数错误']);
        $data = BuildingHousetype::find($id);
        $data['new_orientation'] = $data->getData('orientation');
        $data['vr_link_img'] = '';
        if (!empty($data['vr_link'])) {
            $vrObj = new Vr();
            $data['vr_link_img'] = $vrObj->getFirstImg($data['vr_link']);
        }elseif($data['vr_group_ids']){
            $show_url = config('app.vr_show_domain');
            $vrgroup = VrGroup::where('id',$data['vr_group_ids'])->field('id,pic_path,sid')->findOrEmpty();
            if (!$vrgroup->isEmpty()) {
                $data['vr_link'] = $show_url.$vrgroup->sid;
                $data['vr_link_img'] = $vrgroup->pic_path;
            }
        }

        //查询楼盘地址和小区
        $build = BuildingModel::where('id',$data->building_id)->field('community_id,address')->findOrEmpty();
        if (!$build->isEmpty()){
            $build->community = $build->community_id ? Community::where('id',$build->community_id)->value('name') : '';
        } 
        // 添加足迹
        $token = request()->token;
        if (!empty($token['uid']) && !$token['isEmployee']) {
            event(new FootPrints($token['uid'], $token['share_employee'] ?? 0, $token['share_org'] ?? 0, $data, 'buildingHousetype'));
        }
        return json(['code'=> 0, 'data'=> $data, 'msg'=> '获取成功','build'=>$build]);
    }
}