zhijiayun/app/Models/Manager/Personnel/Employee.php

<?php

namespace App\Models\Manager\Personnel;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;
use App\Models\Manager\Personnel\EmployeeArea as EmployeeAreaModel;

/**
 * 员工模型
 * @author 唐远望
 * @version 1.0
 * @date 2025-12-04
 */
class Employee extends Model
{
    use HasFactory;
    // 与模型关联的表名
    protected $table = 'personnel_employee';
    // 是否主动维护时间戳
    public $timestamps = false;
    // 定义时间戳字段名
    // const CREATED_AT = 'insert_time';
    // const UPDATED_AT = 'update_time';


    /**
     * 添加
     * @author 唐远望
     * @version 1.0
     * @date 2025-12-04
     */
    public function addEmployee_content($data)
    {
        $insert_data = [
            'name' => $data['name'],
            'mobile'    => $data['mobile'],
            'password'  => md5($data['password']),
            'role_id'     => $data['role_id'],
            'province_ids'    => isset($data['province_ids'])? $data['province_ids'] : '',
            'city_ids'    => isset($data['city_ids'])? ','.$data['city_ids'].',' : '',
            'department_id' => $data['department_id'],
            'open_notice' => $data['open_notice'],
            'duty_type' => isset($data['duty_type'])? $data['duty_type'] :'',
            'insert_time' => time(),
        ];
        $Employee_id = $this->insertGetId($insert_data);
        if($Employee_id){
            $this->where('id', $Employee_id)->update(['employee_code' => $this->employee_idToCode($Employee_id)]);
        }
        return $Employee_id;
    }

    /**
     * id转编码
     * @author 唐远望
     * @version 1.0
     * @date 2025-12-04
     * @param  int  $id 编码
     * 
     */
    public function employee_idToCode($id)
    {
        return 'RH' . str_pad($id, 9, '0', STR_PAD_LEFT);
    }

    /**
     * 编码转id
     * @author 唐远望
     * @version 1.0
     * @date 2025-12-04
     * @param  string $code 编码
     * 
     */
    public function employee_codeToId($code)
    {
        return intval(str_ireplace('RH', '', $code));
    }


    /**
     * 写入数据
     * @author 唐远望
     * @version 1.0
     * @date 2025-12-04
     * @param $data
     * @return bool
     */
    public function addEmployee($data)
    {
        DB::beginTransaction();
        try {
            $EmployeeAreaModel = new EmployeeAreaModel();
            $insert_data = [
                'name' => $data['name'],
                'mobile'    => $data['mobile'],
                'password'  => md5($data['password']),
                'role_id'     => $data['role_id'],
                'province_ids'    => isset($data['province_ids']) ? $data['province_ids'] : '',
                'city_ids'    => isset($data['city_ids']) ? ',' . $data['city_ids'] . ',' : '',
                'department_id' => $data['department_id'],
                'open_notice' => $data['open_notice'],
                'duty_type' => isset($data['duty_type']) ? $data['duty_type'] : '',
                'insert_time' => time(),
            ];
            $Employee_id = $this->insertGetId($insert_data);
            if ($Employee_id) {
                $this->where('id', $Employee_id)->update(['employee_code' => $this->employee_idToCode($Employee_id)]);
            }
            if ($data['city_ids']) {
                $insert_city_data = [];
                $city_ids = explode(',', $data['city_ids']);
                foreach ($city_ids as $city_id) {
                    $insert_city_data[] = [
                        'employee_id' => $Employee_id,
                        'city_id' => $city_id,
                    ];
                }
                $EmployeeAreaModel->insert($insert_city_data);
            }
            DB::commit();
            return true;
            // 成功处理...
        } catch (\Exception $e) {
            DB::rollBack();
            // 错误处理...
            return false;
        }
    }


    /**
     * 编辑内容
     * @author 唐远望
     * @version 1.0
     * @date 2025-12-04
     * @param $data
     * @return bool
     */
    public function editEmployee_content($where, $data)
    {
        $Employee = $this->where($where)->first();
        if (!$Employee) {
            return false;
        }
        DB::beginTransaction();
        try {
            $EmployeeAreaModel = new EmployeeAreaModel();

            $Employee->name = $data['name'];
            $Employee->mobile = $data['mobile'];
            if (isset($data['password']) && $data['password'] != '') $Employee->password = md5($data['password']);
            $Employee->role_id = $data['role_id'];
            $Employee->city_ids = isset($data['city_ids']) ? ',' . $data['city_ids'] . ',' : '';
            $Employee->department_id = $data['department_id'];
            $Employee->open_notice = $data['open_notice'];
            $Employee->duty_type = isset($data['duty_type']) ? $data['duty_type'] : '';
            $Employee->update_time = time();
            $Employee->save();

            $EmployeeAreaModel->where('employee_id', $Employee->id)->delete();
            if ($data['city_ids']) {
                $insert_city_data = [];
                $city_ids = explode(',', $data['city_ids']);
                foreach ($city_ids as $city_id) {
                    $insert_city_data[] = [
                        'employee_id' => $Employee->id,
                        'city_id' => $city_id,
                    ];
                }
                $EmployeeAreaModel->insert($insert_city_data);
            }
            DB::commit();
            return true;
            // 成功处理...
        } catch (\Exception $e) {
            DB::rollBack();
            
            // 错误处理...
            return false;
        }
    }



    /**
     * 更新数据
     * @author 唐远望
     * @version 1.0
     * @date 2025-12-04
     * @param $data
     * @return bool
     */
    public function updateEmployee($where, $data)
    {
        DB::beginTransaction();
        try {
            $this->editEmployee_content($where, $data);
            DB::commit();
            return true;
            // 成功处理...
        } catch (\Exception $e) {
            DB::rollBack();
            // 错误处理...
            return false;
        }
    }

    /**
     * 修改状态
     * @author 唐远望
     * @version 1.0
     * @date 2025-12-04
     * @param $id
     * @param $status
     * @return bool
     */
    public function changeStatus($where, $status)
    {
        $Employee = $this->where($where)->first();
        if (!$Employee) {
            return false;
        }
        $Employee->status = $status;
        $Employee->update_time = time();
        $Employee->save();
        return true;
    }

    /**
     * 删除数据
     * @author 唐远望
     * @version 1.0
     * @date 2025-12-04
     * @param $id
     * @return bool
     */
    public function deleteEmployee($where)
    {
        $Employee = $this->where($where)->first();
        if (!$Employee) {
            return false;
        }
        $Employee->delete();
        return true;
    }
}