xrm/app/admin/logic/enterprise/ApplyLogic.php

<?php
/**
 * Created by Administrator.
 * User: 向往那片天空
 * Date: 2022\5\21 0021
 * Time: 15:11
 * 格言: 抓住中心，宁精勿杂，宁专勿多
 * QQ/微信: 250023777
 * 描述: 无
 */

namespace app\admin\logic\enterprise;


use app\admin\logic\BaseLogic;
use app\admin\model\user\User;
use crmeb\services\JsonService;
use crmeb\traits\ModelTrait;

class ApplyLogic extends BaseLogic
{
    use ModelTrait;

    protected $pk = 'id';
    protected $name = 'user_apply_enterprise_record';

    public function getPageList($where)
    {
        $model = self::where('t1.is_delete', '0');
        if ($where['audit_status'] != -1) {
            $model = $model->where('t1.audit_status', $where['audit_status']);
        }
        if (!empty($where['mer_id'])) {
            $model = $model->where('t1.mer_id', $where['mer_id']);
        }
        if (!empty($where['apply_user_name'])) {
            $model = $model->where('t1.apply_user_name', 'like', '%' . $where['apply_user_name'] . '%');
        }

        $list = $model->field('t1.*,t2.job_name,t3.name as companyName')->alias('t1')->leftJoin('job t2', 't1.apply_job_id=t2.id')->join('enterprise_user t3', 't1.mer_id=t3.id')->page($where['page'], $where['limit'])->order('t1.add_time desc')->select()->toArray();

        $count = count($list);
        // 通过行业Id获取行业名
        foreach ($list as &$v) {
            $v['add_time'] = date('Y-m-d H:i:s', $v['add_time']);
        }
        return JsonService::successlayui(['count' => $count, 'data' => $list]);
    }

    public function audit($data)
    {
        $find = self::get($data['id']);

        if (empty($find)) {
            return JsonService::fail('找不到记录');
        }

        if ($find['audit_status'] !== 0) {
            return JsonService::fail('已经审核过');
        }


        $user = User::get($find['apply_user_id']);
        if (empty($user)) {
            return JsonService::fail('找不到申请用户');
        }
        if (!empty($user['mer_id'])) {
            return JsonService::fail('用户已经加入过企业');
        }

        $id = $data['id'];
        unset($data['id']);
        $data['audit_admin_id'] = $this->adminInfo['id'];
        $data['audit_time'] = time();
        $data['audit_status'] = intval($data['audit_status']);
        if ($data['audit_status'] == 1) {
            $data['pass_text'] = $data['text'];
        } else if ($data['audit_status'] == 2) {
            $data['fail_text'] = $data['text'];
        } else {
            return JsonService::fail('非法操作');
        }

        if (!self::edit($data, $id)) {
            return JsonService::fail('审核失败');
        }

        //更新用户
        if ($data['audit_status'] == 1) {
            $updateUser = [];
            $updateUser['mer_id'] = $find['mer_id'];

            if (!User::edit($updateUser, $find['apply_user_id'])) {
                return JsonService::fail('关联用户失败');
            }
        }

        return JsonService::successful('审核成功');
    }

    /**
     * 用户是否有正在审核的记录
     * @param $userId 用户
     * @return bool true-有,false-无
     */
    public function hasApllying($userId)
    {
        $query = [];
        $query['apply_user_id'] = $userId;
        $query['is_delete'] = '0';
        $query['audit_status'] = 0;

        return self::be($query);
    }

    public function getEmployeeList($where)
    {
        $model = self::where('t1.is_delete', '0');
        if ($where['audit_status'] != -1) {
            $model = $model->where('t1.audit_status', $where['audit_status']);
        }
        if (!empty($where['mer_id'])) {
            $model = $model->where('t4.mer_id', $where['mer_id']);
        }
        if (!empty($where['apply_user_name'])) {
            $model = $model->where('t1.apply_user_name', 'like', '%' . $where['apply_user_name'] . '%');
        }

        $list = $model->field('t1.*,t2.job_name,t3.name as companyName')->alias('t1')->leftJoin('job t2', 't1.apply_job_id=t2.id')->join('enterprise_user t3', 't1.mer_id=t3.id')->join('user t4', 't1.apply_user_id=t4.uid')->page($where['page'], $where['limit'])->order('t1.add_time desc')->select()->toArray();

        $count = count($list);
        // 通过行业Id获取行业名
        foreach ($list as &$v) {
            $v['add_time'] = date('Y-m-d H:i:s', $v['add_time']);
        }
        return JsonService::successlayui(['count' => $count, 'data' => $list]);
    }
}