oa/app/user/controller/Files.php

<?php
/**
+-----------------------------------------------------------------------------------------------
* GouGuOPEN [ 左手研发，右手开源，未来可期！]
+-----------------------------------------------------------------------------------------------
* @Copyright (c) 2021~2024 http://www.gouguoa.com All rights reserved.
+-----------------------------------------------------------------------------------------------
* @Licensed 勾股OA，开源且可免费使用，但并不是自由软件，未经授权许可不能去除勾股OA的相关版权信息
+-----------------------------------------------------------------------------------------------
* @Author 勾股工作室 <hdm58@qq.com>
+-----------------------------------------------------------------------------------------------
*/

declare (strict_types = 1);

namespace app\user\controller;

use app\base\BaseController;
use app\user\model\Admin as AdminList;
use think\facade\Db;
use think\facade\View;

class Files extends BaseController
{
    public function datalist()
    {
        if (request()->isAjax()) {
            $param = get_params();
            $where = array();
            $whereOr = array();
            if (!empty($param['keywords'])) {
                $where[] = ['a.id|a.username|a.name|a.nickname|a.mobile|a.desc', 'like', '%' . $param['keywords'] . '%'];
            }
			if (isset($param['status']) && $param['status']!='') {
                $where[] = ['a.status', '=', $param['status']];
            }
			else{
				$where[] = ['a.status', '=', 1];
			}
            if (!empty($param['political'])) {
                $where[] = ['a.political', '=', $param['political']];
            }
			if (!empty($param['position_name'])) {
                $where[] = ['a.position_name', '=', $param['position_name']];
            }
			if (!empty($param['position_rank'])) {
                $where[] = ['a.position_rank', '=', $param['position_rank']];
            }
            if (!empty($param['did'])) {
				$admin_array = Db::name('DepartmentAdmin')->where('department_id',$param['did'])->column('admin_id');
				$map1=[
					['a.id','in',$admin_array],
				];
				$map2=[
					['a.did', '=', $param['did']],
				];
				$whereOr =[$map1,$map2];
            }
			$where[] = ['a.id', '>', 1];
			$list = AdminList::alias('a')
				->with('departments')
				->field('a.*,p.title as position,d.title as department')
				->join('Department d', 'd.id = a.did','left')
				->join('Position p', 'p.id = a.position_id','left')
				->where($where)
				->where(function ($query) use($whereOr) {
					if (!empty($whereOr)){
						$query->whereOr($whereOr);
					}
				})
				->paginate(intval($this->pageSize))
				->order('a.id desc')
                ->each(function ($item, $key) {
					//遍历次要部门数据
					$departments = $item->departments->toArray();
					if(empty($departments)){
						$item['departments'] = '-';
					}
					else{
						$item['departments'] = split_array_field($departments,'title');
					}
					if($item['political']==1){
						$item['political_str'] = '中共党员';
					}
					else if($item['political']==2){
						$item['political_str'] = '团员';
					}
					else{
						$item['political_str'] = '-';
					}
                    $item['entry_time'] = to_date($item['entry_time'],'Y-m-d');
                    $item['birthday_str'] = to_date($item['birthday'],'Y-m-d');
					$item['last_login_time'] = to_date('Y-m-d H:i', $item->last_login_time);
                    $item['last_login_ip'] = empty($item['last_login_ip']) ? '-' : $item['last_login_ip'];
					return $item;
                });
            return table_assign(0, '', $list);
        } else {
            return view();
        }
    }

    //添加
    public function add()
    {
        $param = get_params();
		$id = isset($param['id'])?$param['id']:0;
        if (request()->isAjax()) {
			if($id == 1){
				return to_assign(1, '超级管理员信息不支持编辑');
			}
			$res = Db::name('Admin')->where(['id' => $id])->strict(false)->field(true)->update($param);
			if($res!==false){
				
				//教育经历
				$edu_start_time = isset($param['edu_start_time']) ? $param['edu_start_time'] : '';
				$edu_end_time = isset($param['edu_end_time']) ? $param['edu_end_time'] : '';
				$edu_title = isset($param['edu_title']) ? $param['edu_title'] : '';
				$edu_speciality = isset($param['edu_speciality']) ? $param['edu_speciality'] : '';
				$edu_education = isset($param['edu_education']) ? $param['edu_education'] : '';
				$edu_remark = isset($param['edu_remark']) ? $param['edu_remark'] : '';
				$edu_id = isset($param['edu_id']) ? $param['edu_id'] : 0;			

				if ($edu_start_time) {
					foreach ($edu_start_time as $key => $value) {
						if (!$value && $value !=' ') {
							continue;
						}
						$data = [];
						$data['start_time'] = $value;
						$data['end_time'] = $edu_end_time[$key];
						$data['title'] = $edu_title[$key];
						$data['speciality'] = $edu_speciality[$key];
						$data['education'] = $edu_education[$key];
						$data['remark'] = $edu_remark[$key];
						$data['admin_id'] = $id;
						$data['types'] = 1;
						if($edu_id[$key]>0){
							$data['id'] = $edu_id[$key];
							$data['update_time'] = time();
							Db::name('AdminProfiles')->strict(false)->field(true)->update($data);
						}
						else{
							$data['create_uid'] = $this->uid;
							$data['create_time'] = time();
							$data['update_time'] = time();
							$eid = Db::name('AdminProfiles')->strict(false)->field(true)->insertGetId($data);
						}						
					}
				}
			
			
				//工作经历			
				$work_start_time = isset($param['work_start_time']) ? $param['work_start_time'] : '';
				$work_end_time = isset($param['work_end_time']) ? $param['work_end_time'] : '';
				$work_title = isset($param['work_title']) ? $param['work_title'] : '';
				$work_position = isset($param['work_position']) ? $param['work_position'] : '';
				$work_remark = isset($param['work_remark']) ? $param['work_remark'] : '';
				$work_id = isset($param['work_id']) ? $param['work_id'] : 0;
			
				if ($work_start_time) {
					foreach ($work_start_time as $key => $value) {
						if (!$value && $value !=' ') {
							continue;
						}
						$data = [];
						$data['start_time'] = $value;
						$data['end_time'] = $work_end_time[$key];
						$data['title'] = $work_title[$key];
						$data['position'] = $work_position[$key];
						$data['remark'] = $work_remark[$key];
						$data['admin_id'] = $id;
						$data['types'] = 2;
						if($work_id[$key]>0){
							$data['id'] = $work_id[$key];
							$data['update_time'] = time();
							Db::name('AdminProfiles')->strict(false)->field(true)->update($data);
						}
						else{
							$data['create_uid'] = $this->uid;
							$data['create_time'] = time();
							$data['update_time'] = time();
							$eid = Db::name('AdminProfiles')->strict(false)->field(true)->insertGetId($data);
						}						
					}
				}
			
				//相关证书
				$certificate_start_time = isset($param['certificate_start_time']) ? $param['certificate_start_time'] : '';
				$certificate_title = isset($param['certificate_title']) ? $param['certificate_title'] : '';
				$certificate_authority = isset($param['certificate_authority']) ? $param['certificate_authority'] : '';
				$certificate_remark = isset($param['certificate_remark']) ? $param['certificate_remark'] : '';
				$certificate_id = isset($param['certificate_id']) ? $param['certificate_id'] : 0;

				if ($certificate_start_time) {
					foreach ($certificate_start_time as $key => $value) {
						if (!$value && $value !=' ') {
							continue;
						}
						$data = [];
						$data['start_time'] = $value;
						$data['title'] = $certificate_title[$key];
						$data['authority'] = $certificate_authority[$key];
						$data['remark'] = $certificate_remark[$key];
						$data['admin_id'] = $id;
						$data['types'] = 3;
						if($certificate_id[$key]>0){
							$data['id'] = $certificate_id[$key];
							$data['update_time'] = time();
							Db::name('AdminProfiles')->strict(false)->field(true)->update($data);
						}
						else{
							$data['create_uid'] = $this->uid;
							$data['create_time'] = time();
							$data['update_time'] = time();
							$eid = Db::name('AdminProfiles')->strict(false)->field(true)->insertGetId($data);
						}						
					}
				}
				
				//计算机技能
				$skills_title = isset($param['skills_title']) ? $param['skills_title'] : '';
				$skills_know = isset($param['skills_know']) ? $param['skills_know'] : '';
				$skills_remark = isset($param['skills_remark']) ? $param['skills_remark'] : '';
				$skills_id = isset($param['skills_id']) ? $param['skills_id'] : 0;

				if ($skills_title) {
					foreach ($skills_title as $key => $value) {
						if (!$value && $value !=' ') {
							continue;
						}
						$data = [];
						$data['title'] = $skills_title[$key];
						$data['know'] = $skills_know[$key];
						$data['remark'] = $skills_remark[$key];
						$data['admin_id'] = $id;
						$data['types'] = 4;
						if($skills_id[$key]>0){
							$data['id'] = $skills_id[$key];
							$data['update_time'] = time();
							Db::name('AdminProfiles')->strict(false)->field(true)->update($data);
						}
						else{
							$data['create_uid'] = $this->uid;
							$data['create_time'] = time();
							$data['update_time'] = time();
							$eid = Db::name('AdminProfiles')->strict(false)->field(true)->insertGetId($data);
						}						
					}
				}
				
				//语言能力
				$language_title = isset($param['language_title']) ? $param['language_title'] : '';
				$language_know = isset($param['language_know']) ? $param['language_know'] : '';
				$language_remark = isset($param['language_remark']) ? $param['language_remark'] : '';
				$language_id = isset($param['language_id']) ? $param['language_id'] : 0;

				if ($language_title) {
					foreach ($language_title as $key => $value) {
						if (!$value && $value !=' ') {
							continue;
						}
						$data = [];
						$data['title'] = $language_title[$key];
						$data['know'] = $language_know[$key];
						$data['remark'] = $language_remark[$key];
						$data['admin_id'] = $id;
						$data['types'] = 5;
						if($language_id[$key]>0){
							$data['id'] = $language_id[$key];
							$data['update_time'] = time();
							Db::name('AdminProfiles')->strict(false)->field(true)->update($data);
						}
						else{
							$data['create_uid'] = $this->uid;
							$data['create_time'] = time();
							$data['update_time'] = time();
							$eid = Db::name('AdminProfiles')->strict(false)->field(true)->insertGetId($data);
						}						
					}
				}
				
				add_log('edit', $id, $param);
				return to_assign();
			}
			else{
				return to_assign(1, '提交失败');
			}
        } else {
            $detail = get_admin($id);
			$detail['pname'] = Db::name('Admin')->where('id',$detail['pid'])->value('name');
			$detail['position'] = Db::name('Position')->where('id',$detail['position_id'])->value('title');
			$detail['department'] = Db::name('Department')->where('id',$detail['did'])->value('title');
			$department_ids = Db::name('DepartmentAdmin')->where('admin_id',$id)->column('department_id');
			$department_names = Db::name('Department')->whereIn('id',$department_ids)->column('title');
			$detail['department_names'] = implode(',',$department_names);
			
			if($detail['file_ids'] !=''){
				$file_array = Db::name('File')->where('id','in',$detail['file_ids'])->select();
				$detail['file_array'] = $file_array;
			}
			
			$edu = Db::name('AdminProfiles')->where(['types'=>1,'admin_id'=>$id,'delete_time'=>0])->select()->toArray();
			$work = Db::name('AdminProfiles')->where(['types'=>2,'admin_id'=>$id,'delete_time'=>0])->select()->toArray();
			$certificate = Db::name('AdminProfiles')->where(['types'=>3,'admin_id'=>$id,'delete_time'=>0])->select()->toArray();
			$skills = Db::name('AdminProfiles')->where(['types'=>4,'admin_id'=>$id,'delete_time'=>0])->select()->toArray();
			$language = Db::name('AdminProfiles')->where(['types'=>5,'admin_id'=>$id,'delete_time'=>0])->select()->toArray();
            View::assign('edu', $edu);
            View::assign('work', $work);
            View::assign('skills', $skills);
            View::assign('certificate', $certificate);
            View::assign('language', $language);
            View::assign('detail', $detail);
            View::assign('id', $id);
            return view();
        }
    }

    //查看
    public function view()
    {
		$param = get_params();
		$id = isset($param['id'])?$param['id']:0;
		$detail = get_admin($id);
		$detail['pname'] = Db::name('Admin')->where('id',$detail['pid'])->value('name');
		$detail['position'] = Db::name('Position')->where('id',$detail['position_id'])->value('title');
		$detail['department'] = Db::name('Department')->where('id',$detail['did'])->value('title');
		$department_ids = Db::name('DepartmentAdmin')->where('admin_id',$id)->column('department_id');
		$department_names = Db::name('Department')->whereIn('id',$department_ids)->column('title');
		$detail['department_names'] = implode(',',$department_names);
		if($detail['file_ids'] !=''){
			$file_array = Db::name('File')->where('id','in',$detail['file_ids'])->select();
			$detail['file_array'] = $file_array;
		}
		$edu = Db::name('AdminProfiles')->where(['types'=>1,'admin_id'=>$id,'delete_time'=>0])->select()->toArray();
		$work = Db::name('AdminProfiles')->where(['types'=>2,'admin_id'=>$id,'delete_time'=>0])->select()->toArray();
		$certificate = Db::name('AdminProfiles')->where(['types'=>3,'admin_id'=>$id,'delete_time'=>0])->select()->toArray();
		$skills = Db::name('AdminProfiles')->where(['types'=>4,'admin_id'=>$id,'delete_time'=>0])->select()->toArray();
		$language = Db::name('AdminProfiles')->where(['types'=>5,'admin_id'=>$id,'delete_time'=>0])->select()->toArray();
		View::assign('edu', $edu);
		View::assign('work', $work);
		View::assign('skills', $skills);
		View::assign('certificate', $certificate);
		View::assign('language', $language);
		View::assign('detail', $detail);
		View::assign('id', $id);
		return view();
    }
}