Depart.php 9.5 KB
<?php

namespace app\admin\controller\inspection;

use app\common\controller\Backend;
use fast\Tree;
use think\Db;

/**
 * 部门管理
 *
 * @icon fa fa-circle-o
 */
class Depart extends Backend
{
    
    /**
     * Depart模型对象
     * @var \app\admin\model\inspection\Depart
     */
    protected $model = null;
    protected $noNeedRight = ['tree'];
    public function _initialize()
    {
        parent::_initialize();
        $this->model = new \app\admin\model\inspection\Depart();

        $tree = Tree::instance();
        $tree->init(collection($this->model->order('weigh asc,id asc')->select())->toArray(), 'pid');
        $this->categorylist = $tree->getTreeList($tree->getTreeArray(0), 'depart_name');
        $categorydata = [0 => ['depart_name' => __('None')]];
        foreach ($this->categorylist as $k => $v) {
            $categorydata[$v['id']] = $v;
        }

        $this->view->assign("parentList", $categorydata);
    }

    public function tree(){
        $id = $this->request->get('id');
        $departModel = new \app\admin\model\inspection\Depart();
        $departList = $departModel->where(['pid'=>($id=='#'?0:$id)])->select();

        $chanelList = [];
        if($id=='#'){
            $text = "全部";
            $chanelList[-1] = ['id'=>-1,'type'=>'total','text'=>$text,'parent'=>"#"];
        }

        foreach($departList as $k=>$v){
            $departModel =  new \app\admin\model\inspection\Depart();
            if($departModel->where(['pid'=>$v->id])->find()){
                $children = true;
            }else{
                $children = false;
            }

            $chanelList[$v->id] = ['id'=>$v->id,'text'=>$v->depart_name,'type'=>"folder",'children'=>$children,'parent'=>empty($v->pid)?"#":$v->pid,'state'=>['opened'=>false]];
        }

        $chanelList = array_values($chanelList);

        return json($chanelList);
    }


    /**
     * 查看
     */
    public function index()
    {
        //设置过滤方法
        $this->request->filter(['strip_tags']);
        if ($this->request->isAjax()) {
            $search = $this->request->request("search");
            $type = $this->request->request("type");

            //构造父类select列表选项数据
            $list = [];

            foreach ($this->categorylist as $k => $v) {
                if ($search) {
                    if ($v['type'] == $type && stripos($v['name'], $search) !== false || stripos($v['nickname'], $search) !== false) {
                        if ($type == "all" || $type == null) {
                            $list = $this->categorylist;
                        } else {
                            $list[] = $v;
                        }
                    }
                } else {
                    if ($type == "all" || $type == null) {
                        $list = $this->categorylist;
                    } elseif ($v['type'] == $type) {
                        $list[] = $v;
                    }
                }
            }

            $total = count($list);
            $result = array("total" => $total, "rows" => $list);

            return json($result);
        }
        return $this->view->fetch();
    }


    /**
     * 编辑
     */
    public function edit($ids = null)
    {
        $row = $this->model->get($ids);
        if (!$row) {
            $this->error(__('No Results were found'));
        }
        $adminIds = $this->getDataLimitAdminIds();
        if (is_array($adminIds)) {
            if (!in_array($row[$this->dataLimitField], $adminIds)) {
                $this->error(__('You have no permission'));
            }
        }
        if ($this->request->isPost()) {
            $this->token();
            $params = $this->request->post("row/a");
            if ($params) {
                $params = $this->preExcludeFields($params);

                if ($params['pid'] != $row['pid']) {
                    $childrenIds = Tree::instance()->init(collection( \app\admin\model\inspection\Depart::select())->toArray())->getChildrenIds($row['id'], true);
                    if (in_array($params['pid'], $childrenIds)) {
                        $this->error(__('上级部门不能是它的子部门或它自己'));
                    }
                }

                try {
                    //是否采用模型验证
                    if ($this->modelValidate) {
                        $name = str_replace("\\model\\", "\\validate\\", get_class($this->model));
                        $validate = is_bool($this->modelValidate) ? ($this->modelSceneValidate ? $name . '.edit' : $name) : $this->modelValidate;
                        $row->validate($validate);
                    }
                    $result = $row->allowField(true)->save($params);
                    if ($result !== false) {
                        $this->success();
                    } else {
                        $this->error($row->getError());
                    }
                } catch (\think\exception\PDOException $e) {
                    $this->error($e->getMessage());
                } catch (\think\Exception $e) {
                    $this->error($e->getMessage());
                }
            }
            $this->error(__('Parameter %s can not be empty', ''));
        }
        $this->view->assign("row", $row);
        return $this->view->fetch();
    }



    /**
     * 同步钉钉部门
     */
    public function sync_depart(){
//        $appkey = config("site.appkey");
//        $appsecret = config("site.appsecret");
//
//        try {
//            $dingTalkApi = DingTalkApi::instance($appkey,$appsecret);
//            $departs = $dingTalkApi->get_department_list();
//        }catch (Exception $e){
//            $this->error($e->getMessage());
//        }
//
//        $departModel = new \app\admin\model\Depart();
//        $departModel->where("id","gt",0)->delete();
//        foreach($departs as $k=>$v){
//            if($departModel->where(['id'=>$v->id])->find()){
//                $departModel->where(['id'=>$v->id])->update(['depart_name'=>$v->name]);
//            }else{
//                $departModel->insert(['id'=>$v->id,'pid'=>empty($v->parentid)?0:$v->parentid,'depart_name'=>$v->name]);
//            }
//        }
//
//        $this->success("请求成功");
    }
    
    public function sendmessage(){
        if($this->request->isPost()){
            $list = explode(',',input('post.depart'));
            $ids = $this->get_all_child(8);
            $arrs = [];
            foreach ($list as $v){
                $arrs = array_merge($arrs,$this->get_all_child($v));
            }
            $arrs = array_unique($arrs);
            $userids = Db::name('inspection_staff')->alias('s')->join('inspection_depart d','s.depart_id = d.id')->join('user u','u.id = s.user_id')->where('s.depart_id','in',$arrs)->field('u.openid,s.staff_name,s.id')->select();
            $list = [];
            foreach ($userids as $k => $v){
                $code = md5($v['openid'].time());
                $res = $this->send($v['openid'],$v['staff_name'],$code);
                if($res){
                    if($res['errcode'] === 0){
                       $list[] = ['staff_id'=>$v['id'],'status'=>'0','openid'=>$v['openid'],'template'=>1,'message'=>$res['errmsg'],'createtime'=>time(),'code'=>$code];  
                    }
                    else{
                      $list[] = ['staff_id'=>$v['id'],'status'=>'9','openid'=>$v['openid'],'template'=>1,'message'=>$res['errmsg'],'createtime'=>time(),'code'=>$code];  
                    }
                }
                else{
                    $list[] = ['staff_id'=>$v['id'],'status'=>'9','openid'=>$v['openid'],'template'=>1,'message'=>'发送失败','createtime'=>time(),'code'=>$code];
                }
            }
            Db::name('inspection_wxtemplatelog')->insertAll($list);
            $this->success('成功');
        }
        return $this->view->fetch();
    }
    
    //根据部门id获取所有子部门
    public function getDepartIdById($id = 6){
    $array = Db::name('inspection_depart')->select();
    //第一步 构造数据
    $items = array();
    foreach($array as $value){
        $items[$value['id']] = $value;
    }
    //第二部 遍历数据 生成树状结构
    $tree = array();
    foreach($items as $key => $value){
        if(isset($items[$value['pid']])){
            $items[$value['pid']]['son'][] = &$items[$key];
        }else{
            $tree[] = &$items[$key];
        }
    }
    return $tree;
    }
    
    
//递归获取所有的子分类的ID
function get_all_child($id = 6,$array = []){
    
    $arr = array();
    if(!$array){
    $array = Db::name('inspection_depart')->select();
    $arr[] = (int)$id;
    }

    

    foreach($array as $v){
        if($v['pid'] == $id){
            $arr[] = $v['id'];
            $arr = array_merge($arr,$this->get_all_child($v['id'],$array));
        };
    };
    return $arr;
}

public function send($openid,$name,$code){
        $data = [
            'first'=> ['value'=>'水库警告','color'=>'#000000'],
            'keyword1'=>['value'=>$name,'color'=>'#000000'],
            'keyword2'=>['value'=>date('Y-m-d H:i',time()),'color'=>'#000000'],
            'keyword3'=>['value'=>'水位超过预警!','color'=>'#000000'],
            'remark'=>['value'=>'设备监测到水位超过预警值,请及时处理','color'=>'#000000'],
        ];
        $template_id = '001';
        $uri='https://www.ynzhsk.cn/index/index/updateWxtemplate?code='.$code.'&openid='.$openid;
        $text =  \addons\weixin\library\WechatTemplateService::sendTemplateOrApp($openid,$template_id,$data,$uri);
        return $text;
}

    

}