human_admin/application/api/controller/Users.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use app\common\library\Ems;
use app\common\library\Sms;
use fast\Random;
use think\Db;
use think\Validate;

/**
 * 会员接口
 */
class Users extends Api
{
    protected $noNeedLogin = '*';
    protected $noNeedRight = '*';

    public function _initialize()
    {
        parent::_initialize();
    }
    /**
     * 单位树下用户信息显示接口
     * t_id (单位树id)
     */
    public function usersShow()
    {
        $t_id = $this->request->post('t_id');
        if (!isset($t_id)) {
            return $this->result('未获取t_id', [], 100);
        }
        // 查出用户基本信息
        $data = Db::name('users u')
            ->where('user_type',$t_id)
            ->select();
        foreach ($data as &$v) {
           $v['user_image'] = config('site.url').$v['user_image'];
           $v['user_year_time'] = date('Y/m/d',$v['user_year_time']);
        }
        if ($data) {
            return $this->result('', $data,200);
        } else {
            return $this->result('暂无人员',[],100);
        }
    }
    /**
     * 用户详细信息 user_id (包括简历和社会关系)
     */
    public function userInfo()
    {
        $user_id =$this->request->post('user_id');
        if(!isset($user_id)) {
            return $this->result('未获取user_id',[] ,100);
        }
        $data = Db::name('users')
            ->where('user_id',$user_id)
            ->find();
        if ($data) {
            // 用户先例
            $data['resume'] = Db::name('resume')
                ->where('user_id',$user_id)
                ->find();
            // 关联用户社会关系
            $data['sociogram'] = Db::name('sociogram')
                ->where('user_id',$user_id)
                ->select();
            $data['user_image'] = config('site.url').$data['user_image'];
            $data['user_party_time'] = date('Y/m/d',$data['user_party_time']);
            $data['user_join_job_time'] = date('Y/m/d',$data['user_join_job_time']);
            return $this->result('',$data,200);
        } else {
            return $this->result('信息获取错误',[],100);
        }
    }
    /**
     * 单位树显示
     */
    public function type()
    {
        $data = Db::name('type')
            ->where('f_id',0)
            ->select();
        if ($data) {
            foreach ($data as &$v) {
                // 循环查出子单位
                $v['ztype'] = Db::name('type')->where('f_id',$v['t_id'])->select();
            }
            return $this->result('',$data,200);
        } else {
            return $this->result('暂无数据',[],100);
        }
    }
    /**
     * 用户搜索
     */
    public function usersSearch()
    {
        $params = $this->request->post();
        $where = array();
        if (isset($params['user_name'])) {
            $where['user_name'] = ['like','%' . $params['user_name'] . '%'];
        }
        if (isset($params['user_sex'])) {
            $where['user_sex'] = $params['user_sex'];
        }
        // 行政级别
        if (isset($params['user_administrative_level'])) {
            $where['user_administrative_level'] = $params['user_administrative_level'];
        }
        // 民族
        if (isset($params['user_nation'])) {
            if ($params['user_nation'] == '汉族') {
                $where['user_nation'] = $params['user_nation'];
            } else {
                $where['user_nation'] = ['neq','汉族'];
            }
        }
        // 政治面貌
        if (isset($params['user_politics'])) {
            if ($params['user_politics'] == '中共党员') {
                $where['user_politics'] = $params['user_politics'];
            } else {
                $where['user_politics'] = ['neq','中共党员'];
            }

        }
        // 籍贯
        if (isset($params['user_native'])) {
            $where['user_native'] = ['like', '%' . $params['user_native'] . '%'];
        }
        // 在职教育学历
        if (isset($params['user_degree_b'])) {
            $where['user_degree_b'] = ['like', '%' . $params['user_degree_b'] . '%'];
        }
        // 全日制教育学历
        if (isset($params['user_education_full'])) {
            $where['user_education_full'] = ['like', '%' . $params['user_education_full'] . '%'];
        }
        // 年龄
        if (isset($params['user_age'])) {
            $where['user_age'] = ['between', $params['user_age'][0].','.$params["user_age"][1]];
        }
        $data = Db::name('users')
            ->where($where)
            ->select();
        if ($data) {
            foreach($data as &$v) {
                $v['user_image'] = config('site.url').$v['user_image'];
                $v['user_year_time'] = date('Y/m/d',$v['user_year_time']);
            }
            return $this->result('',$data,200);
        } else {
            return $this->result('未检测到数据',[],100);
        }
    }
    /**
     * 性别比例统计图
     * t_id
     */
    public function sexStatistics()
    {
        $t_id = $this->request->post('t_id');
        if (!isset($t_id)) {
            return $this->result('单位树id未接收到',[],100);
        }
        // 查出用户总人数
        $peopel_count = Db::name('users')
            ->where('user_type',$t_id)
            ->count();
        if ($peopel_count) {
            /**
             * 性别比例
             */
            // 查出女生总人数
            $woman_count = Db::name('users')
                ->where('user_sex','女')
                ->where('user_type',$t_id)
                ->count();
            // 查出男生总人数
            $man_count  = Db::name('users')
                ->where('user_sex','男')
                ->where('user_type',$t_id)
                ->count();
            // 求出饼图的男女比例
            $data['sex']['bing']['woman_bili'] = round($woman_count/$peopel_count,2);
            $data['sex']['bing']['man_bili'] = round($man_count/$peopel_count,2);
            // 求出柱图数据
            $data['sex']['zhu']['woman_count'] = $woman_count;
            $data['sex']['zhu']['man_count']   = $man_count;
            // 求出折现数据
            $data['sex']['zhe']['woman_count'] = $woman_count;
            $data['sex']['zhe']['man_count']   = $man_count;
            /**
             * 年龄比例
             */
            // 设置年龄区间
            $age = array(
                '20' => 25,
                '25' => 30,
                '30' => 35,
                '35' => 40,
                '40' => 50,
            );
            foreach ($age as $key => $value) {
                // 求出各个年龄区间的人数
                $age_count = Db::name('users')
                    ->where('user_age','between',$key . ',' . $value)
                    ->where('user_type',$t_id)
                    ->count();
                // 求出所占饼状的比例
                $data['age']['bing'][$key.'-'.$value] = round($age_count/$peopel_count,2);
                // 各个年龄区间柱状人数
                $data['age']['zhu'][$key.'-'.$value] = $age_count;
                $data['age']['zhe'][$key.'-'.$value] = $age_count;
            }
            /**
             * 职务比例
             */
            // 管理岗位人数
            $guanli_count = Db::name('users')
                ->where('user_major','管理岗位')
                ->where('user_type',$t_id)
                ->count();
            // 专业技术岗位
            $jishu_count = Db::name('users')
                ->where('user_major','专业技术岗位')
                ->where('user_type',$t_id)
                ->count();
            // 工勤技能岗位
            $jineng_coung = Db::name('users')
                ->where('user_major','工勤技能岗位')
                ->where('user_type',$t_id)
                ->count();
            // 管理岗位饼状
            $data['zhiwu']['bing']['guanli'] = round($guanli_count/$peopel_count,2);
            // 专业技术饼状
            $data['zhiwu']['bing']['jishu'] = round($jishu_count/$peopel_count,2);
            // 工勤技能饼状
            $data['zhiwu']['bing']['jineng'] = round($jineng_coung/$peopel_count,2);
            // 管理岗位柱状+折现
            $data['zhiwu']['zhuZhe']['guanli'] = $guanli_count;
            // 专业技术柱状+折现
            $data['zhiwu']['zhuZhe']['jishu'] = $jishu_count;
            // 工期技能柱状+折现
            $data['zhiwu']['zhuZhe']['jineng'] = $jineng_coung;
            /**
             * 学历比例
             */
            // 初中学历人数
            $chuzhong = Db::name('users')
                ->where('user_education_full','初中')
                ->where('user_type',$t_id)
                ->count();
            // 高中学历人数
            $gaozhong = Db::name('users')
                ->where('user_education_full','高中')
                ->where('user_type',$t_id)
                ->count();
            // 中专学历人数
            $zhongzhuan = Db::name('users')
                ->where('user_education_full','中专')
                ->where('user_type',$t_id)
                ->count();
            // 大专学历人数
            $dazhuan = Db::name('users')
                ->where('user_education_full','大专')
                ->where('user_type',$t_id)
                ->count();
            // 本科学历人数
            $benke = Db::name('users')
                ->where('user_education_full','本科')
                ->where('user_type',$t_id)
                ->count();
            // 研究生学历人数
            $yjs = Db::name('users')
                ->where('user_education_full','研究生')
                ->where('user_type',$t_id)
                ->count();
            // 党校大专学历人数
            $dxdz = Db::name('users')
                ->where('user_education_full','党校大专')
                ->where('user_type',$t_id)
                ->count();
            // 党校本科学历人数
            $dxbk = Db::name('users')
                ->where('user_education_full','党校本科')
                ->where('user_type',$t_id)
                ->count();
            // 党校研究生学历人数
            $dxyjs = Db::name('users')
                ->where('user_education_full','党校研究生')
                ->where('user_type',$t_id)
                ->count();
            // 其他学历人数
            $qita = Db::name('users')
                ->where('user_education_full','其他')
                ->where('user_type',$t_id)
                ->count();
            // 无学历人数
            $wu = Db::name('users')
                ->where('user_education_full','无')
                ->where('user_type',$t_id)
                ->count();
            // 初中学历饼状
            $data['xueli']['bing']['chuzhong'] = round($chuzhong/$peopel_count,2);
            // 高中学历饼状
            $data['xueli']['bing']['gaozhong'] = round($gaozhong/$peopel_count,2);
            // 中专学历饼状
            $data['xueli']['bing']['zhongzhuan'] = round($zhongzhuan/$peopel_count,2);
            // 大专学历饼状
            $data['xueli']['bing']['dazhuan'] = round($dazhuan/$peopel_count,2);
            // 本科学历饼状
            $data['xueli']['bing']['benke'] = round($benke/$peopel_count,2);
            // 研究生学历饼状
            $data['xueli']['bing']['yjs'] = round($yjs/$peopel_count,2);
            // 党校大专学历饼状
            $data['xueli']['bing']['dxdz'] = round($dxdz/$peopel_count,2);
            // 党校本科学历饼状
            $data['xueli']['bing']['dxbk'] = round($dxbk/$peopel_count,2);
            // 党校研究生学历饼状
            $data['xueli']['bing']['dxyjs'] = round($dxyjs/$peopel_count,2);
            // 其他学历饼状
            $data['xueli']['bing']['qita'] = round($qita/$peopel_count,2);
            // 无学历饼状
            $data['xueli']['bing']['wu'] = round($wu/$peopel_count,2);
            // 初中学历柱状加折现
            $data['xueli']['zhuZhe']['chuzhong'] = $chuzhong;
            // 初中学历柱状加折现
            $data['xueli']['zhuZhe']['gaozhong'] = $gaozhong;
            // 初中学历柱状加折现
            $data['xueli']['zhuZhe']['zhongzhuan'] = $zhongzhuan;
            // 初中学历柱状加折现
            $data['xueli']['zhuZhe']['dazhuan'] = $dazhuan;
            // 初中学历柱状加折现
            $data['xueli']['zhuZhe']['benke'] = $benke;
            // 初中学历柱状加折现
            $data['xueli']['zhuZhe']['yjs'] = $yjs;
            // 初中学历柱状加折现
            $data['xueli']['zhuZhe']['dxdz'] = $dxdz;
            // 初中学历柱状加折现
            $data['xueli']['zhuZhe']['dxbk'] = $dxbk;
            // 初中学历柱状加折现
            $data['xueli']['zhuZhe']['dxyjs'] = $dxyjs;
            // 初中学历柱状加折现
            $data['xueli']['zhuZhe']['qita'] = $qita;
            // 初中学历柱状加折现
            $data['xueli']['zhuZhe']['wu'] = $wu;
            return $this->result('',$data,200);
        } else {
            return $this->result('该单位下暂无用户',[],100);
        }


    }
}