community-manage/app/Repositories/Behavior/BehaviorRepository.php

<?php
namespace App\Repositories\Behavior;
use App\Models\Behavior;
use App\Models\BehaviorOperationLog;
use GuzzleHttp\Client;
use GuzzleHttp\Exception\RequestException;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Tymon\JWTAuth\Facades\JWTAuth;
use Dingo\Api\Http\Response;
use Symfony\Component\HttpKernel\Exception\HttpException;
use Illuminate\Database\QueryException;

/**
 * Created by PhpStorm.
 * User: durong
 * Date: 2019/6/10
 * Time: 上午11:11
 */

class BehaviorRepository
{
    public function __construct(Behavior $behavior,BehaviorOperationLog $behaviorOperationLog)
    {
        $this->behavior = $behavior;
        $this->behaviorOperationLog = $behaviorOperationLog;
        //初始化virus域名
        $this->client = new Client([
            'base_uri' => config('constants.VIRUS_URL'),
            'timeout' => 3
        ]);
    }

    public function lists($request)
    {
        try {
            $signKey = [
                'app' => config('constants.VIRUS_APP_ID')
            ];
            ksort($signKey);
            $signKey = urldecode(http_build_query($signKey));
            $sign = md5(config('constants.VIRUS_APP_SECRET') . $signKey);

            $response = $this->client->request('GET', 'behaviorList', [
                'headers' => [
                    'Content-Type' => 'application/json',
                    'app' => config('constants.VIRUS_APP_ID'),
                    'sign' => $sign
                ]
            ]);
            $res = json_decode($response->getBody()->getContents(), true);
            $res = $res ? $res['behaviors'] : [];
        }catch (RequestException $exception){
            $res = [
                'returnCode' => '-1',
                'errMsg' => '网络超时'.$exception->getMessage()
            ];
            Log::debug('获取virus行为列表：'.$exception->getMessage());
        }
        //已登记行为
        $registered_bahavior = $this->behavior->get();
        $registered_bahaviors = $registered_bahavior->toArray();

        foreach ($registered_bahaviors as $key=>$val){
            $registered_bahaviors[$key]['behavior_status'] = 1;//已登记
        }
        $virus_behavior_id = array_column($registered_bahaviors,'virus_behavior_id');

        $new_res = [];
        //行为列表去重
        foreach ($res as $k=>$v) {
            if (isset($v['_id']) && !empty($virus_behavior_id)){
                    $res[$k]['behavior_status'] = 0;//未登记
                if (in_array($v['_id'], $virus_behavior_id)) {
                    unset($res[$k]);
                }
                    $new_res = array_merge($res, $registered_bahaviors);

            }elseif (!isset($v['_id']) && $virus_behavior_id) {
                    $new_res = $registered_bahaviors;
            }elseif (isset($v['_id']) && empty($virus_behavior_id)){
                    $res[$k]['behavior_status'] = 0;//未登记
                    $new_res = $res;
            }
        }
        $new_re = [];
        //根据行为ID筛选
        if (isset($request['virus_behavior_id'])){
            foreach ($new_res as $k=>$v){
                if (isset($v['id']) && $v['id'] != $request['virus_behavior_id']){
                    unset($new_res[$k]);
                    $new_re = array_merge($new_res);
                }elseif (isset($v['_id']) && $v['_id'] != $request['virus_behavior_id']){
                    unset($new_res[$k]);
                    $new_re = array_merge($new_res);
                }
            }
            return $new_re;
        }
        //根据行为状态(类型)筛选
        if (isset($request['behavior_status'])){
            foreach ($new_res as $kk=>$vv){
                if (isset($vv['behavior_status']) && $vv['behavior_status'] != $request['behavior_status']){
                    unset($new_res[$kk]);
                    $new_re = array_merge($new_res);
                }
            }
            return $new_re;
        }
        //根据绑定的动作ID筛选(暂时取消)
//        if (isset($request['behavior_action_id'])){
//            foreach ($new_res as $key=>$val) {
//                if (isset($val['behavior_action_id']) && ($val['behavior_action_id'] != $request['behavior_action_id'])) {
//                    unset($new_res[$key]);
////                    $new_re = array_merge($new_res);
//                } elseif (!isset($val['behavior_action_id'])) {
//                    unset($new_res[$key]);
////                    $new_re = array_merge($new_res);
//                }
//            }
//            return $new_re;
//        }
        //根据行为名称筛选
        if (isset($request['name'])){
            foreach ($new_res as $key => $val) {
                if (isset($val['name']) && strpos($val['name'],$request['name']) !== false) {
                    $new_re[] = $new_res[$key];
                }
                if (isset($val['behavior_name']) && strpos($val['behavior_name'],$request['name']) !== false ) {
                    $new_re[] = $new_res[$key];
                }
            }
            return $new_re;
        }
        return $new_res;
    }

    public function create($request)
    {
        $behavior_name = $this->behavior->where(['name' => $request['name']])->first();
        if ($behavior_name) {
            throw new HttpException(500, '该行为已存在');
        }

        if(isset($request['allotted_quantity_rule']) && isset($request['rainbow_beans'])) {
            $rule = $request['allotted_quantity_rule'];
            $rainbow_beans = $request['rainbow_beans'];
            $count = 0;
            if (count($rule) == count($rule, 1)) {
                $count = array_sum($rule);
                if ($count > $rainbow_beans){
                    throw new HttpException(500, '唯一行为-分配总数不能大于行为生成彩虹豆总数');
                }
            } else {
                foreach ($rule as $value){
                    $count += $value['bean'];
                }
                if ($count > $rainbow_beans){
                    throw new HttpException(500, '多级行为-分配总数不能大于行为生成彩虹豆总数');
                }
            }
        }

        $data = [
            'virus_behavior_id' => $request['virus_behavior_id'],
            'name' => $request['name'],
            'behavior_level' => $request['behavior_level'],
            'behavior_cycle_type' => $request['behavior_cycle_type'],
            'is_open' => 0,
            'behavior_action_id' => isset($request['behavior_action_id']) ? $request['behavior_action_id'] : '',
            'behavior_cycle' => isset($request['behavior_cycle']) ? $request['behavior_cycle'] : '',
            'behavior_binding_users' => isset($request['behavior_binding_users']) ? $request['behavior_binding_users'] : 0,
            'physical_strength' => isset($request['physical_strength']) ? $request['physical_strength'] : '',
            'rainbow_beans' => isset($request['rainbow_beans']) ? $request['rainbow_beans'] : '',
            'grant_rainbow_beans' => isset($request['grant_rainbow_beans']) ? $request['grant_rainbow_beans'] : '',
            'remarks' => isset($request['remarks']) ? $request['remarks'] : '',
            'behavioral_cycle_start_time' => isset($request['behavioral_cycle_start_time']) ? $request['behavioral_cycle_start_time'] : null,
            'behavioral_cycle_end_time' => isset($request['behavioral_cycle_end_time']) ? $request['behavioral_cycle_end_time'] : null,
            'allotted_quantity_rule' => isset($request['allotted_quantity_rule']) ? json_encode($request['allotted_quantity_rule']) : '',
            'behavior_identification' => isset($request['behavior_identification']) ? $request['behavior_identification'] : '',
            'trigger_times' => isset($request['trigger_times']) ? $request['trigger_times'] : 0,
            'effective_trigger' => isset($request['effective_trigger']) ? $request['effective_trigger'] : 0,
            'relative_series' => isset($request['relative_series']) ? $request['relative_series'] : 0,
            'absolute_progression' => isset($request['absolute_progression']) ? $request['absolute_progression'] : 0,
        ];
        DB::beginTransaction();
        try {
            $res = $this->behavior->create($data);
            if ($res) {
                $token =  JWTAuth::decode(JWTAuth::getToken());
                $uid = $token['user']->id;
                $username = $token['user']->username;
                $cerate_bahavior_data = [
                    'operator_id' => $uid,
                    'behavior_id' => $res['id'],
                    'username' => $username,
                    'content' => '创建'.$request['name'].'行为',
                    'type' => 0,
                    'created_at' => date('Y-m-d H:i:s'),
                    'updated_at' => date('Y-m-d H:i:s')
                ];
                $result = $this->behaviorOperationLog->insert($cerate_bahavior_data);
                if (!$result) {
                    throw new HttpException(500, '操作日志记录失败');
                }
            }
            DB::commit();
            return Response::create();

        } catch (QueryException $exception) {
            DB::rollBack();
            Log::debug('注册行为：'.$exception->getMessage());
            return Response::create([
                'message' => '添加失败，请重试',
                'error' => $exception->getMessage(),
                'status_code' => 500
            ]);
        }
    }

    public function edit($request)
    {
        $behavior_id = $this->behavior->find($request['id']);
        if ($behavior_id->is_open == 1){
            throw new HttpException(500, '无法编辑已经在记录的行为');
        }
        $update_bahavior = [
            'virus_behavior_id' => $request['virus_behavior_id'],
            'name' => $request['name'],
            'behavior_level' => $request['behavior_level'],
            'behavior_cycle_type' => $request['behavior_cycle_type'],
            'is_open' => 0,
            'behavior_cycle' => isset($request['behavior_cycle']) ? $request['behavior_cycle'] : '',
            'behavior_binding_users' => isset($request['behavior_binding_users']) ? $request['behavior_binding_users'] : 0,
            'physical_strength' => isset($request['physical_strength']) ? $request['physical_strength'] : '',
            'rainbow_beans' => isset($request['rainbow_beans']) ? $request['rainbow_beans'] : '',
            'grant_rainbow_beans' => isset($request['grant_rainbow_beans']) ? $request['grant_rainbow_beans'] : '',
            'remarks' => isset($request['remarks']) ? $request['remarks'] : '',
            'behavioral_cycle_start_time' => isset($request['behavioral_cycle_start_time']) ? $request['behavioral_cycle_start_time'] : null,
            'behavioral_cycle_end_time' => isset($request['behavioral_cycle_end_time']) ? $request['behavioral_cycle_end_time'] : null,
            'allotted_quantity_rule' => isset($request['allotted_quantity_rule']) ? json_encode($request['allotted_quantity_rule']) : '',
            'behavior_identification' => isset($request['behavior_identification']) ? $request['behavior_identification'] : '',
            'trigger_times' => isset($request['trigger_times']) ? $request['trigger_times'] : 0,
            'effective_trigger' => isset($request['effective_trigger']) ? $request['effective_trigger'] : 0,
            'relative_series' => isset($request['relative_series']) ? $request['relative_series'] : 0,
            'absolute_progression' => isset($request['absolute_progression']) ? $request['absolute_progression'] : 0,
            'updated_at' => date('Y-m-d H:i:s')
            ];
        DB::beginTransaction();
        try{
            $res = $this->behavior->where('id',$request['id'])->update($update_bahavior);
                if ($res) {
                    $token =  JWTAuth::decode(JWTAuth::getToken());
                    $uid = $token['user']->id;
                    $username = $token['user']->username;
                    $cerate_bahavior_data = [
                        'operator_id' => $uid,
                        'behavior_id' => $request['id'],
                        'username' => $username,
                        'content' => json_encode($update_bahavior),
                        'type' => 1,
                        'created_at' => date('Y-m-d H:i:s'),
                        'updated_at' => date('Y-m-d H:i:s')
                    ];
                    $result = $this->behaviorOperationLog->insert($cerate_bahavior_data);
                    if (!$result) {
                        throw new HttpException(500, '操作日志记录失败');
                    }
                }
                DB::commit();
                return Response::create();

            } catch (QueryException $exception) {
                DB::rollBack();
                Log::debug('编辑行为：'.$exception->getMessage());
                return Response::create([
                    'message' => '编辑失败，请重试',
                    'error' => $exception->getMessage(),
                    'status_code' => 500
                ]);
            }
    }

    public function editStatus($request)
    {
        $behavior = $this->behavior->find($request['id']);

        $behavior_array = [
            'is_open' => $request['is_open'],
            'updated_at' => date('Y-m-d H:i:s')
        ];
        if ($request['is_open'] == 0){
            $is_open = '关闭';
        }else{
            $is_open = '开启';
        }
        $behavior_name = $behavior->name;

        DB::beginTransaction();
        try {
            $res = $behavior->where('id',$request['id'])->update($behavior_array);
            if ($res) {
                $token =  JWTAuth::decode(JWTAuth::getToken());
                $uid = $token['user']->id;
                $username = $token['user']->username;
                $cerate_bahavior_data = [
                    'operator_id' => $uid,
                    'behavior_id' => $request['id'],
                    'username' => $username,
                    'content' => $is_open.'了'.$behavior_name.'行为',
                    'type' => 2,
                    'created_at' => date('Y-m-d H:i:s'),
                    'updated_at' => date('Y-m-d H:i:s')
                ];
                $result = $this->behaviorOperationLog->insert($cerate_bahavior_data);
                if (!$result) {
                    throw new HttpException(500, '操作日志记录失败');
                }
            }
            DB::commit();
            return Response::create();

        } catch (QueryException $exception) {
            DB::rollBack();
            Log::debug('修改状态行为：' . $exception->getMessage());
            return Response::create([
                'message' => '修改状态失败，请重试',
                'error' => $exception->getMessage(),
                'status_code' => 500
            ]);
        }
    }

    public function dataList($request)
    {
        $perPage = isset($request['per_page']) ? $request['per_page'] : 20;
        $where = [];
        if(isset($request['id'])){
            $where[] = ['id',$request['id']];
        }
        if(isset($request['is_open'])){
            $where[] = ['is_open',$request['is_open']];
        }
        //行为级别唯一/多级筛选
        if(isset($request['behavior_level'])){
            $where[] = ['behavior_level',$request['behavior_level']];
        }
        if(isset($request['name'])){
            $where[] = ['name', 'like', "%{$request['name']}%"];
        }
        //触发次数由多到少-由少到多筛选
        if (isset($request['trigger_times']) && $request['trigger_times'] == 0){
            return $this->behavior->orderBy('trigger_times','desc')->paginate($perPage);
        }elseif (isset($request['trigger_times']) && $request['trigger_times'] == 1){
            return $this->behavior->orderBy('trigger_times','asc')->paginate($perPage);
        }
        //有效触发由多到少-由少到多筛选
        if (isset($request['effective_trigger']) && $request['effective_trigger'] == 0){
            return $this->behavior->orderBy('effective_trigger','desc')->paginate($perPage);
        }elseif (isset($request['effective_trigger']) && $request['effective_trigger'] == 1){
            return $this->behavior->orderBy('effective_trigger','asc')->paginate($perPage);
        }
        //绝对级数由多到少-由少到多筛选
        if (isset($request['absolute_progression']) && $request['absolute_progression'] == 0){
            return $this->behavior->orderBy('absolute_progression','desc')->paginate($perPage);
        }elseif (isset($request['absolute_progression']) && $request['absolute_progression'] == 1){
            return $this->behavior->orderBy('absolute_progression','asc')->paginate($perPage);
        }
        //耗费体力值由多到少-由少到多筛选
        if (isset($request['physical_strength']) && $request['physical_strength'] == 0){
            return $this->behavior->orderBy('physical_strength','desc')->paginate($perPage);
        }elseif (isset($request['physical_strength']) && $request['physical_strength'] == 1){
            return $this->behavior->orderBy('physical_strength','asc')->paginate($perPage);
        }
        //发放彩虹豆由多到少-由少到多筛选
        if (isset($request['grant_rainbow_beans']) && $request['grant_rainbow_beans'] == 0){
            return $this->behavior->orderBy('grant_rainbow_beans','desc')->paginate($perPage);
        }elseif (isset($request['grant_rainbow_beans']) && $request['grant_rainbow_beans'] == 1){
            return $this->behavior->orderBy('grant_rainbow_beans','asc')->paginate($perPage);
        }

        return $this->behavior->where($where)->paginate($perPage);

    }
}