dingding/application/common/service/ApproveInfoService.php

<?php

namespace app\common\service;

use app\common\constant\CommonConstant;
use app\common\model\Approve;
use app\common\model\ApproveCopy;
use app\common\model\ApproveEvectionPeerUser;
use app\common\model\ApproveInfo;
use app\common\model\Department;
use app\common\model\User;
use think\Db;
use think\Exception;

/**
 * 审批申请服务类
 */
class ApproveInfoService
{

    /**
     * 申请/重新发起
     *
     * @param integer $id 申请ID
     * @param integer $module 模块类型
     * @param array $params
     * @param mixed $user 用户信息
     **/
    public static function create($id, $module, $params, $user)
    {

        $userid = $user['userid'];
        // 编辑
        if ($id > 0) {
            $info = ApproveInfo::field('user_id,is_deleted', true)
                ->where('user_id', $userid)
                ->where('is_deleted', CommonConstant::IS_DELETED_0)
                ->with(['moduleInfo'])
                ->find($id);
            if (!$info) {
                throw new Exception('申请记录不存在或已删除');
            }
            if (!$info->module_info) {
                throw new Exception(CommonConstant::get_module_list()[$module] . '记录不存在或已删除');
            }
            if ($info->status != CommonConstant::STATUS_4) {
                throw new Exception('非审批驳回状态无法操作');
            }
        }

        $order_no = get_order_sn($user['id']);
        $approve_user = explode(',', $params['approve_user']);
        $copy_user = explode(',', $params['copy_user']);
        $approve_num = count($approve_user);
        $data = [
            'module' => $module,
            'user_id' => $userid,
            'department' => $user['department'],
            'status' => CommonConstant::STATUS_2,
            'approve_num' => $approve_num,
            'cur_num' => 0,
            'order_no' => $order_no,
            'apply_date' => date("Y-m-d"),
            'reason' => $params['reason'],
            'type' => $params['type'],
            'desc' => $params['desc'],
            'start_time' => $params['start_time'],
            'end_time' => $params['end_time'],
        ];
        if ($id > 0) {
            // 编辑审批申请
            $save_data = [
                'create_at' => date('Y-m-d H:i:s'),
            ];
            $data = array_merge($data, $save_data);
            $info->save($data);

            // 编辑对应模块
            self::create_module($id, $module, $params, $info, 'update');

            // 编辑审批抄送
            self::create_approve($id, $approve_user, $copy_user, 'update');
        } else {
            // 添加审批申请
            $info = ApproveInfo::create($data);
            $info_id = $info->id;

            // 添加对应模块
            $module_data = self::create_module($info_id, $module, $params, [], 'create');
            $info->save(['module_id' => $module_data->id]);

            // 添加审批抄送
            self::create_approve($info_id, $approve_user, $copy_user, 'create');
        }
    }

    // 添加对应模块
    public static function create_module($info_id, $module, $params, $info, $type)
    {
        $data = [];
        switch ($module) {
            case CommonConstant::MODULE_1:
                $data['info_id'] = $info_id;
                $data['reason'] = $params['reason'];
                $data['type'] = $params['type'];
                $data['total_amount'] = $params['total_amount'];
                $data['apply_date'] = $params['apply_date'];
                $data['document'] = $params['document'];
                $data['images'] = $params['images'];
                $data['pay_type'] = $params['pay_type'];
                break;
            case CommonConstant::MODULE_2:
                $data['info_id'] = $info_id;
                $data['type'] = $params['type'];
                $data['word_size'] = $params['word_size'];
                $data['desc'] = $params['desc'];
                $data['number'] = $params['number'];
                $data['reason'] = $params['reason'];
                $data['remark'] = $params['remark'];
                $data['document'] = $params['document'];
                break;
            case CommonConstant::MODULE_3:
                $data['info_id'] = $info_id;
                $data['document'] = $params['document'];
                $data['images'] = $params['images'];
                $data['remark'] = $params['remark'];
                break;
            case CommonConstant::MODULE_4:
                $data['info_id'] = $info_id;
                $data['reason'] = $params['reason'];
                $data['document'] = $params['document'];
                $data['remark'] = $params['remark'];
                break;
            case CommonConstant::MODULE_5:
                $data['info_id'] = $info_id;
                $data['reason'] = $params['reason'];
                $data['start_time'] = $params['start_time'];
                $data['end_time'] = $params['end_time'];
                $data['document'] = $params['document'];
                $data['images'] = $params['images'];
                $data['type'] = $params['type'];
                $data['is_who'] = $params['is_who'];
                $data['remark'] = $params['remark'];
                break;
            case CommonConstant::MODULE_6:
                $data['info_id'] = $info_id;
                $data['type'] = $params['type'];
                $data['start_time'] = $params['start_time'];
                $data['end_time'] = $params['end_time'];
                $data['start_am'] = $params['start_am'];
                $data['end_am'] = $params['end_am'];
                $data['time'] = $params['time'];
                $data['reason'] = $params['reason'];
                $data['document'] = $params['document'];
                $data['remark'] = $params['remark'];
                break;
            case CommonConstant::MODULE_7:
                $data['info_id'] = $info_id;
                $data['reason'] = $params['reason'];
                $data['start_time'] = $params['start_time'];
                $data['reach_address'] = $params['reach_address'];
                $data['end_time'] = $params['end_time'];
                $data['end_address'] = $params['end_address'];
                $data['document'] = $params['document'];
                $data['images'] = $params['images'];
                break;
            case CommonConstant::MODULE_8:
                $data['info_id'] = $info_id;
                $data['type'] = $params['type'];
                $data['reason'] = $params['reason'];
                $data['desc'] = $params['desc'];
                $data['images'] = $params['images'];
                break;
            case CommonConstant::MODULE_9:
                $data['info_id'] = $info_id;
                $data['type'] = $params['type'];
                $data['reason'] = $params['reason'];
                $data['desc'] = $params['desc'];
                $data['number'] = $params['number'];
                $data['scope'] = $params['scope'];
                $data['legal_opinion'] = $params['legal_opinion'];
                $data['document'] = $params['document'];
                $data['remark'] = $params['remark'];
                break;
            case CommonConstant::MODULE_10:
                $data['info_id'] = $info_id;
                $data['founder'] = $params['founder'];
                $data['desc'] = $params['desc'];
                $data['serial_number'] = $params['serial_number'];
                $data['reason'] = $params['reason'];
                $data['apply_date'] = $params['apply_date'];
                $data['remark'] = $params['remark'];
                $data['degree'] = $params['degree'];
                $data['document'] = $params['document'];
                break;
            case CommonConstant::MODULE_11:
                $data['info_id'] = $info_id;
                $data['department'] = $params['department'];
                $data['reason'] = $params['reason'];
                $data['department_sign'] = $params['department_sign'];
                $data['remark'] = $params['remark'];
                $data['document'] = $params['document'];
                $data['desc'] = $params['desc'];
                $data['apply_date'] = $params['apply_date'];
                $data['serial_number'] = $params['serial_number'];
                break;
        }
        if ($type == 'update') {
            $module_result = $info->module_info->save($data);
        } else {
            $models = CommonConstant::get_module_model_list();
            $model = $models[$module];
            $module_result = $model::create($data);
        }

        switch ($module) {
            case CommonConstant::MODULE_5:
                self::create_peer_user($info_id, $params['peer_user'], $type);
                break;
        }

        return $module_result;
    }

    // 添加同行人员
    public static function create_peer_user($info_id, $params, $type)
    {
        if ($type == 'update') {
            ApproveEvectionPeerUser::where('info_id', $info_id)->delete();
        }

        if (!$params) {
            return true;
        }

        $data = [];
        foreach ($params as $value) {
            $data[] = [
                'info_id' => $info_id,
                'is_who' => $value['is_who'],
                'user_id' => isset($value['user_id']) ? $value['user_id'] : '',
                'name' => $value['name'],
                'desc' => isset($value['desc']) ? $value['desc'] : '',
            ];
        }
        ApproveEvectionPeerUser::insertAll($data);
    }

    // 添加审批抄送
    public static function create_approve($info_id, $approve_user, $copy_user, $type)
    {
        if ($type == 'update') {
            Approve::where('info_id', $info_id)->delete();
            ApproveCopy::where('info_id', $info_id)->delete();
        }

        $data = [];
        $copy_data = [];
        $flow_num = 0;
        $copy_num = 0;
        $create_at = date('Y-m-d H:i:s');

        // 审批人
        foreach ($approve_user as $key => $value) {
            $flow_num++;
            $data[] = [
                'info_id' => $info_id,
                'create_at' => $create_at,
                'status' => $flow_num == 1 ? CommonConstant::STATUS_2 : CommonConstant::STATUS_1,
                'approve_flow' => $flow_num,
                'approve_user' => $value,
                'approve_time' => $create_at,
            ];
        }
        // 抄送人
        foreach ($copy_user as $key => $value) {
            $copy_num++;
            $copy_data[] = [
                'info_id' => $info_id,
                'create_at' => $create_at,
                'approve_flow' => $copy_num,
                'approve_user' => $value,
            ];
        }

        if ($data) {
            Approve::insertAll($data);
        }
        if ($copy_data) {
            ApproveCopy::insertAll($copy_data);
        }
    }

    /**
     * 我的申请记录
     *
     * @param integer $module 模块类型
     * @param integer $status 审批状态
     * @param string $search 搜索
     * @param integer $offset 起始位置
     * @param integer $length 查询数量
     * @param mixed $user 用户信息
     **/
    public static function get_list($module, $status, $search, $offset, $length, $user)
    {
        if (!array_key_exists($module, CommonConstant::get_module_list())) {
            return [];
        }
        if (!array_key_exists($status, CommonConstant::get_status_list())) {
            return [];
        }

        $userid = $user['userid'];
        $list = ApproveInfo::field('module,module_id,user_id,is_deleted', true)
            ->where('module', $module)
            ->where('user_id', $userid)
            ->where('status', $status)
            ->where('is_deleted', CommonConstant::IS_DELETED_0)
            ->when($search, function ($query) use ($search) {
                $query->where('order_no|reason', 'like', '%' . $search . '%');
            });
        $list = self::get_with($list, $module, $status);
        $list = $list->limit($offset, $length)
            ->order('id desc')
            ->select();
        return $list;
    }

    /**
     * 详情/信息
     *
     * @param integer $id 申请ID
     * @param mixed $user 用户信息 有数据=审批申请详情,没有数据=审批详情
     * @param string $type 类型:detail=详情,info=信息
     **/
    public static function get_detail($id, $user, $type)
    {
        $where = $user ? ['user_id' => $user['userid']] : [];
        $info = ApproveInfo::field('is_deleted', true)
            ->where($where)
            ->where('is_deleted', CommonConstant::IS_DELETED_0);
        if ($type == 'detail') {
            $info->with([
                'moduleInfo',
                'approve' => function ($query) {
                    $query->field('is_deleted,create_at', true)
                        ->with(['user' => function ($query) {
                            $query->field('userid,headimg,name');
                        }]);
                },
                'approveCopy' => function ($query) {
                    $query->field('is_deleted,create_at', true)
                        ->with(['user' => function ($query) {
                            $query->field('userid,headimg,name');
                        }]);
                }
            ]);
            $info = $info->find($id);
            if ($info) {
                if (!$user) {
                    // 审批申请人信息
                    $approve_info_user = User::field('userid,name')->where('userid', $info['user_id'])->find();
                    $info['approve_info_user'] = $approve_info_user;
                }
                $department_data = Department::field('dept_id,name')->where('dept_id', 'in', $info['department'])->select();
                $info['department_data'] = $department_data;
            }
        } else {
            $info->with(['moduleInfo']);
            $info = $info->find($id);
        }
        $info = self::get_item($info, $type);
        return $info;
    }

    public static function get_with($list, $module, $status)
    {
        switch ($module) {
            case CommonConstant::MODULE_1:
            case CommonConstant::MODULE_2:
            case CommonConstant::MODULE_3:
            case CommonConstant::MODULE_4:
                if (in_array($status, [CommonConstant::STATUS_2, CommonConstant::STATUS_4])) {
                    // 审批中或审批驳回 才关联 审批人信息
                    $list = $list->with([
                        'approveOne' => function ($query) use ($status) {
                            $query->field('id,info_id,status,approve_user')
                                ->where('status', $status)
                                ->with(['user' => function ($query) {
                                    $query->field('userid,name');
                                }]);
                        }
                    ]);
                }
                break;
            case CommonConstant::MODULE_5:
                if (in_array($status, [CommonConstant::STATUS_2, CommonConstant::STATUS_4])) {
                    // 审批中或审批驳回 才关联 审批人信息
                    $list = $list->with([
                        'peer_user' => function ($query) {
                            $query->field('id,info_id,name');
                        },
                        'approveOne' => function ($query) use ($status) {
                            $query->field('id,info_id,status,approve_user')
                                ->where('status', $status)
                                ->with(['user' => function ($query) {
                                    $query->field('userid,name');
                                }]);
                        }
                    ]);
                } else {
                    $list = $list->with([
                        'peer_user' => function ($query) {
                            $query->field('id,info_id,name');
                        },
                    ]);
                }
                break;
            case CommonConstant::MODULE_6:
            case CommonConstant::MODULE_7:
            case CommonConstant::MODULE_8:
            case CommonConstant::MODULE_9:
            case CommonConstant::MODULE_10:
            case CommonConstant::MODULE_11:
                if (in_array($status, [CommonConstant::STATUS_2, CommonConstant::STATUS_4])) {
                    // 审批中或审批驳回 才关联 审批人信息
                    $list = $list->with([
                        'approveOne' => function ($query) use ($status) {
                            $query->field('id,info_id,status,approve_user')
                                ->where('status', $status)
                                ->with(['user' => function ($query) {
                                    $query->field('userid,name');
                                }]);
                        }
                    ]);
                }
                break;
        }
        return $list;
    }

    public static function get_item($info, $type)
    {
        $module = $info['module'];
        switch ($module) {
            case CommonConstant::MODULE_5:
                if ($type == 'detail') {
                    $info['peer_user'] = $info->peerUser()->field('id,info_id,name')->select();
                } else {
                    $info->peerUser;
                }
                break;
        }
        return $info;
    }

    /**
     * 操作方法
     *
     * @param integer $id 申请ID
     * @param mixed $user 用户信息
     * @param string $type 类型:urging=催办,cancel=撤销
     */
    public static function make($id, $user, $type)
    {
        $userid = $user['userid'];
        $info = ApproveInfo::field('id,module,status')
            ->where('user_id', $userid)
            ->where('is_deleted', CommonConstant::IS_DELETED_0)
            ->find($id);
        if (!$info) {
            throw new Exception(CommonConstant::get_module_list()[$info->module] . '记录不存在或已删除');
        }

        switch ($type) {
            case 'urging':
                if ($info->status != CommonConstant::STATUS_2) {
                    throw new Exception('其他人已操作');
                }

                // 钉钉接口 TODO
                break;
            case 'cancel':
                if ($info->status != CommonConstant::STATUS_4) {
                    throw new Exception('非审批驳回状态无法操作');
                }

                $info->status = CommonConstant::STATUS_5;
                $info->save();
                break;
        }
    }

}