mes-sdai-server-api/application/api/controller/Staff.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use \think\Request;
use \think\Db;
/**
 * 员工资料接口
 */
class Staff extends Api
{
    protected $noNeedLogin = ['*'];
    protected $noNeedRight = ['*'];

    /**
     * 首页
     *
     */
    public function index()
    {
        $this->success('请求成功');
    }
    /**
     * 获取员工列表信息
     *
     * @ApiMethod (GET)
     * @param string department_code
     * @param string mes_online
     * @param string u8_online
     * @param string limit
     * @param string page
     *
    */
    public function getStaffList(){
        if (Request::instance()->isGet() == false){
            $this->error('非法请求');
        }
        $params = Request::instance()->param();
        $where = [];
        $where['在职状态'] = '在职';
        if (isset($params['mes_online'])){
            $where['在职状态'] = $params['mes_online'] > 1 ? '离职':'在职';
        }
        $where['U8在职'] = '在职';
        if (isset($params['u8_online'])){
            $where['U8在职'] = $params['u8_online'] > 1 ? '离职':'在职';
        }
        $where['员工编号|员工姓名'] = array('like','%'.$params['search'].'%');
        $limit = $params['limit'];
        if (empty($limit)){
            $limit = 15;
        }
        $pages = $params['page'];
        if (empty($pages)){
            $pages = 1;
        }

        $field = '员工编号,rtrim(员工姓名) as 员工姓名,性别,聘用日期,转正日期,rtrim(所在部门) as 所在部门,rtrim(部门编码) as 部门编码,rtrim(职称职务) as 职称职务,rtrim(身份证号) as 身份证号,出生日期,
        rtrim(人员性质) as 人员性质,rtrim(人员类别) as 人员类别,班次类型,工资表类别,薪酬核算分组,rtrim(在职状态) as 在职状态,rtrim(U8在职) as U8在职,U8离职日期,rtrim(sys_id) as sys_id,sys_rq,mod_rq';
        if (strlen($params['department_code']) > 1){
            $list = db('人事_基本资料')->where($where)->where('部门编码',$params['department_code'])->field($field)->page($pages)->limit($limit)->order('UniqID asc')->select();
            $total = db('人事_基本资料')->where($where)->where('部门编码',$params['department_code'])->count();
        }else if (strlen($params['department_code']) == 1){
            $list = db('人事_基本资料')->where($where)->where('LEFT(部门编码,1)='.$params['department_code'])->field($field)->page($pages)->limit($limit)->order('UniqID asc')->select();
            $total = db('人事_基本资料')->where($where)->where('LEFT(部门编码,1)='.$params['department_code'])->count();
        }else{
            $list = db('人事_基本资料')->where($where)->field($field)->page($pages)->limit($limit)->order('UniqID asc')->select();
            $total = db('人事_基本资料')->where($where)->count();
        }
        $data['list'] = $list;
        $data['total'] = $total;
        $this->success('请求成功',$data);
    }
    /**
     * 获取部门列表
     *
     * @ApiMethod (GET)
     *
    */
    public function getDepartment(){
        if (Request::instance()->isGet() == false){
            $this->error('非法请求');
        }
        $sql = "select rtrim(编号) as 编号,rtrim(名称) as 名称 from 人事_组织结构 where  状态 = ''    ";
        $list = Db::query($sql);
        $data = [];
        foreach ($list as $key => $value){
            $number = $value['编号'];
            if (strlen($number) ==  1 ){//一级菜单
                $sql = "select count(*) as total from 人事_基本资料 where SUBSTRING(部门编码,1,1)='{$number}' and 在职状态 = '在职' and U8在职 = '在职'";
                $res = Db::query($sql);
                $value['num'] = $res[0]['total'];
                $list[$key] = $value;
                $data[$number] = $value;
            }else { //二级菜单
                $sql = "select count(*) as total from 人事_基本资料 where 部门编码='{$number}' and 在职状态 = '在职' and U8在职 = '在职'";
                $res = Db::query($sql);
                $value['num'] = $res[0]['total'];
                $list[$key] = $value;
            }
        }
        $six = db('人事_基本资料')->where('在职状态','在职')->where('U8在职','离职')->count();
        $sixArr['编号'] = '';
        $sixArr['名称'] = '离职工资结算中';
        $sixArr['total'] = $six;
        $sev = db('人事_基本资料')->where('在职状态','离职')->where('U8在职','离职')->count();
        $sevArr['编号'] = '';
        $sevArr['名称'] = '离职清单';
        $sevArr['total'] = $sev;
        array_push($data,$sixArr,$sevArr);
        foreach ($data as $k=>$v){
            $i = 0;
            $data[$k]['children'] = [];
            foreach ($list as $item){
                $num = $item['编号'];
                if (strlen($num) >= 3 && substr($num,0,1) == $k){
                    if ($item['num'] > 0){
                        $data[$k]['children'][$i] = $item;
                        $i++;
                    }
                }
            }
        }
        $data = array_values($data);
        $this->success('请求成功',$data);
    }
    /**
     * 获取员工资料
     * @ApiMethod GET
     * @params string code
    */
    public function getStaffInfo(){
        if (Request::instance()->isGet() == false){
            $this->error('非法请求');
        }
        $params = Request::instance()->param();
        $where = [];
        if (isset($params['code'])){
            $where['员工编号'] = $params['code'] ;
        }
        $field = '员工编号,rtrim(员工姓名) as 员工姓名,性别,聘用日期,转正日期,rtrim(所在部门) as 所在部门,rtrim(部门编码) as 部门编码,rtrim(职称职务) as 职称职务,rtrim(身份证号) as 身份证号,出生日期,
        rtrim(人员性质) as 人员性质,rtrim(人员类别) as 人员类别,班次类型,工资表类别,薪酬核算分组,rtrim(在职状态) as 在职状态,rtrim(U8在职) as U8在职,U8离职日期,rtrim(sys_id) as sys_id,sys_rq,mod_rq';
        $data = db('人事_基本资料')->where($where)->field($field)->find();
        $this->success('请求成功',$data);
    }
    /**
     * 修改员工资料
     *
     * @ApiMethod POST
     *
    */
    public function edit(){
        if (Request::instance()->isPost() == false){
            $this->error('非法请求');
        }
        $params = Request::instance()->param();
        if (empty($params['员工编号'])){
            $this->error('参数不能为空');
        }
        $staffCode = $params['员工编号'];
        unset($params['员工编号']);
        $sql = db('人事_基本资料')->where('员工编号',$staffCode)->fetchSql(true)->update($params);
        $res = Db::query($sql);
        if ($res !== false){
            $this->success('更新成功');
        }else{
            $this->error('更新失败');
        }
    }
}