kailin/app/Http/Controllers/Admin/Business.php

<?php namespace App\Http\Controllers\Admin;

use App\Http\Requests\Admin\Business as Request;
use App\Models\Business as Model;
use App\Models\AdminUser;
use App\Models\City;
use App\Models\AuthRule;
use App\Models\AdminRule;
use App\Models\Company;
use App\Models\AdminHistory;
use Illuminate\Support\Carbon;
use Illuminate\Support\Facades\DB;

/**
 * 店铺管理
 *
 * @author    刘相欣
 *
 */
class Business extends Auth{
	
	protected function _initialize(){
		parent::_initialize();
		$this->assign('breadcrumb1','商家管理');
		$this->assign('breadcrumb2','店铺');
	}

	/**
	 * 列表页
	 * 
	 * */
    public function index(Model $Model,City $City,AdminUser $AdminUser){
 		// 接受参数
		$code					= request('business_code','');
		$phone					= request('phone','');
		$status					= request('status');
		$startTime				= request('start_time','');
		// 编码转ID
		$id						= $Model->codeToId($code);
		// 查询条件
		$map 					= [];
		// 编码ID
		if( $id )				$map[] = ['business.id','=',$id];
		if( $phone )			$map[] = ['business.phone','=',$phone];
		if( $startTime )		$map[] = ['business.insert_time','>=',Carbon::createFromFormat('Y-m-d',$startTime)->startOfDay()->getTimestamp()];
		if( $startTime )		$map[] = ['business.insert_time','<=',Carbon::createFromFormat('Y-m-d',$startTime)->endOfDay()->getTimestamp()];
		if( !is_null($status) )	$map[] = ['business.status','=',$status];
        if(!in_array(admin('uid'), explode(',', config('administrator')))){
            $session				= session('userRule') ? session('userRule') : ['menu_type'=>0,'company_id'=>1,'business_id'=>0];
            if ($session){
                $map[] = ['company_id','=',$session['company_id']];
                if ($session['business_id']){
                    $map[] = ['business.id','=',$session['business_id']];
                }
                if ($session['menu_type'] == 1 && $session['data_type'] == 2){
                    $map[] = ['business.leader_uid','=',$session['admin_uid']];
                }
            }
        }
		// 查询数据
		$list					= $Model->query()
                                ->join('company','company.id','=','business.company_id')
                                ->where($map)
                                ->orderByDesc('business.id')
                                ->select('business.*','company.name as company_name')
                                ->paginate(config('page_num',10));
		// 循环处理数据
		foreach ($list as $key => $value) {
            // id转编号
			$value['business_code'] = $Model->idToCode($value['id']);
            $value['username']      = $value['admin_uid'] ? (string) $AdminUser->getOne($value['admin_uid'],'username') : '';
            $value['admin_phone']   = $value['admin_uid'] ? (string) $AdminUser->getOne($value['admin_uid'],'phone') : '';
            $value['logopic']		= $value['logopic'] ? path_compat($value['logopic']) : '';
            $addHistory             = AdminHistory::query()
                                    ->join('admin','admin.uid','=','admin_history.admin_uid')
                                    ->where(['admin_history.primary_id'=>$value['id'],'admin_history.notes_type'=>1,'admin_history.table_name'=>$Model->getTable()])
                                    ->select('admin_history.insert_time','admin.username as username')
                                    ->first();
            $editHistory            = AdminHistory::query()
                                        ->join('admin','admin.uid','=','admin_history.admin_uid')
                                        ->where(['admin_history.primary_id'=>$value['id'],'admin_history.notes_type'=>2,'admin_history.table_name'=>$Model->getTable()])
                                        ->select('admin_history.update_time','admin.username as username')
                                        ->orderByDesc('id')->first();
            $value['add_history_username']  = $addHistory   ? $addHistory->username : '';
            $value['add_history_time']      = $addHistory   ? $addHistory->insert_time : 0;
            $value['edit_history_username'] = $editHistory  ? $editHistory->username : '';
            $value['edit_history_time']     = $editHistory  ? $editHistory->update_time : 0;
            $leader                         =   AdminUser::query()->where('uid',$value['leader_uid'])->first();
            $value['leader_username']        = $leader ? $leader->username : '';
			// 重组
			$list[$key]			= $value;
            if( $value['city_ids'] ) {
                // 解析数组
                $cityids			= explode(',',$value['city_ids']);
                // 获取城市
                foreach ($cityids as $kk=>$vv) 	{
                    // 获取值
                    $vv				= $City->getOne($vv,'name');
                    // 获取城市名
                    $cityids[$kk]	= $vv;
                }
                // 城市列表
                $value['city_ids']	= implode('、',$cityids);
            }
		}
		// 分配数据
		$this->assign('empty', '<tr><td colspan="20">~~暂无数据</td></tr>');
		$this->assign('list',$list);
		// 加载模板
		return 					$this->fetch();
    }

	/**
	 * 添加
	 * 
	 * */
	public function add(Request $request,Model $Model,City $City,AdminUser $AdminUser,AdminRule $AdminRule){
        // 当前用户角色
        $session				= session('userRule') ? session('userRule') : ['menu_type'=>0,'company_id'=>1,'business_id'=>0];
        // 添加
		if( request()->isMethod('post') ){
			// 验证参数
			$request->scene('add')->validate();
			// 接收数据
			$data['name']			    = request('name','');
			$data['phone']			    = request('phone','');
			$data['logopic']		    = request('logopic','');
			$data['desc']			    = request('desc','');
			$data['leader_uid']		    = request('leader_uid','');
            $data['address']		    = request('address','');
            $data['city_ids']		    = request('city_ids',[]);
            $data['city_ids']		    = implode(',',$data['city_ids']);
            // 店铺管理员
			$userData['username']		= request('custom_name','');
			$userData['phone']		    = request('phone','');
			$userData['password']		= request('custom_password','');
            $userData['password']		= md5($userData['password']);
            // 如果有公司ID
            $data['company_id']	        = empty($session['company_id'])? 1 : $session['company_id'];
            // 查询店铺管理员
            $oldAdmin                   = $AdminUser->query()->where([['username','=',$userData['username']]])->first();
            // 如果存在的话
            if( $oldAdmin )             return json_send(['code'=>'error','msg'=>'管理员账号不可重复']);
            // 开启事务
            DB::beginTransaction();
            try {
                // 写入数据表
                $id						= $Model->add($data);
                // 如果操作失败
                if( !$id )              {
                    // 回滚事务
                    DB::rollBack();
                    // 失败提示
                    return json_send(['code'=>'error','msg'=>'新增店铺失败']);
                }
                // 写入数据表
                $uid					 = $AdminUser->add($userData);
                // 如果操作失败
                if( !$uid ){
                    // 回滚事务
                    DB::rollBack();
                    // 提示
                    return              json_send(['code'=>'error','msg'=>'新增管理员失败']);
                }
                // 角色数据
                $ruleData['admin_uid']  = $uid;
                $ruleData['business_id']= $id;
                $ruleData['menu_type']  = 2;
                // 写入数据表
                $ruleUid				= $AdminRule->add($ruleData);
                // 如果操作失败
                if( !$ruleUid ){
                    // 回滚事务
                    DB::rollBack();
                    // 提示
                    return              json_send(['code'=>'error','msg'=>'新增管理员角色失败']);
                }
                // 写入数据表
                $re					    = $Model->edit($id,['admin_uid'=>$uid]);
                // 如果操作失败
                if( !$re ){
                    // 回滚事务
                    DB::rollBack();
                    // 提示
                    return              json_send(['code'=>'error','msg'=>'新增失败','data'=>'新增店铺管理员']);
                }
                // 写入数据表
                $re					    = DB::table('auth_group_access')->insert(['group_id'=>5,'user_uid'=>$uid]);
                // 如果操作失败
                if( !$re ){
                    // 回滚事务
                    DB::rollBack();
                    // 提示
                    return              json_send(['code'=>'error','msg'=>'新增失败','data'=>'新增店铺管理员']);
                }
                // 提交事务
                DB::commit();
                // 记录行为
                $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,1,[],$data);
                // 告知结果
                return					json_send(['code'=>'success','msg'=>'新增成功','action'=>'add']);
            }catch (\Exception $e){
                // 回滚事务
                DB::rollBack();
                // 告知错误
                return				json_send(['code'=>'error','msg'=>'新增失败','data'=>json_encode($e->getMessage())]);
            }
		}
        // 获取列表
        $cityList					= $City->getCityList();
        $mp                         =   [];
        if ($session){
            $mp[]                   =   ['admin_rule.company_id','=',$session['company_id']];
            if ($session['menu_type'] == 1 && $session['data_type'] == 2){
                $mp[]                   =   ['admin_rule.admin_uid','=',$session['admin_uid']];
            }else{
                $mp[]                   =   ['admin_rule.menu_type','=',1];
                $mp[]                   =   ['admin_rule.data_type','=',2];
            }
        }
        $leaderList					= $AdminRule::query()
                                    ->join('admin','admin.uid','=','admin_rule.admin_uid')
                                    ->where($mp)
                                    ->get(['admin.uid','admin.username']);
		// 分配数据
		$this->assign('crumbs','新增');
        $this->assign('cityList',$cityList);
        $this->assign('leaderList',$leaderList);
		// 加载模板
		return						$this->fetch(); 
	}

	/**
	 * 修改
	 * 
	 * */
	public function edit(Request $request,Model $Model,AdminUser $AdminUser,City $City,AdminRule $AdminRule){
		// 接收参数
		$id							= request('id',0);
		// 查询用户
		$oldData					= $Model->where(['id'=>$id])->first();
        // 当前用户角色
        $session				    = session('userRule') ? session('userRule') : ['menu_type'=>0,'company_id'=>1,'business_id'=>0];
		// 修改
		if(request()->isMethod('post')){
			// 验证参数
			$request->scene('edit')->validate();
			// 接收数据
			$data['name']			    = request('name','');
			$data['phone']			    = request('phone','');
			$data['logopic']		    = request('logopic','');
			$data['desc']			    = request('desc','');
            $data['leader_uid']		    = request('leader_uid','');
            $data['address']		    = request('address','');
            $data['city_ids']		    = request('city_ids',[]);
            $data['city_ids']		    = implode(',',$data['city_ids']);
            // 店铺管理员
			$userData['username']		= request('custom_name','');
			$userData['phone']		    = request('phone','');
            // 是否修改密码
            if( request('custom_password','') ) $userData['password'] = md5(request('custom_password',''));
            // 如果有公司ID
            $data['company_id']	        = empty($session['company_id'])? 1 : $session['company_id'];
            // 查询店铺管理员
            $oldAdmin                   = $AdminUser->query()->where([['username','=',$userData['username']]])->value('uid');
            // 如果存在的话，而且不是当前的管理员
            if( $oldAdmin && $oldAdmin != $oldData['admin_uid'] ) return json_send(['code'=>'error','msg'=>'管理员账号不可重复']);
            // 事务
            DB::beginTransaction();
            // 尝试执行
            try {
                // 修改或者新增
                $data['admin_uid']          = $oldData['admin_uid'] ? $AdminUser->edit($oldData['admin_uid'],$userData) : $AdminUser->add($userData);
                // 如果操作失败
                if( !$data['admin_uid'] )   {
                    // 回滚事务
                    DB::rollBack();
                    // 提示
                    return                  json_send(['code'=>'error','msg'=>'编辑失败']);
                }
                // 写入数据表
                $result					    = $Model->edit($id,$data);
                // 如果操作失败
                if( !$result )              {
                    // 回滚事务
                    DB::rollBack();
                    // 提示
                    return                  json_send(['code'=>'error','msg'=>'编辑失败']);
                }
                // 如果新增的话,绑定角色关系
                if( !$oldData['admin_uid'] ){
                    // 角色数据
                    $ruleData['admin_uid']  = $data['admin_uid'];
                    $ruleData['business_id']= $id;
                    $ruleData['menu_type']  = 2;
                    // 写入数据表
                    $ruleUid				= $AdminRule->add($ruleData);
                    // 如果操作失败
                    if( !$ruleUid )         {
                        // 回滚事务
                        DB::rollBack();
                        // 提示
                        return              json_send(['code'=>'error','msg'=>'新增管理员角色失败']);
                    }
                }
                // 提交事务
                DB::commit();
                // 记录行为
                $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,$data);
                // 告知结果
                return					    json_send(['code'=>'success','msg'=>'修改成功','action'=>'edit']);
            }catch (\Exception $e)  {
                DB::rollBack();
                return				    json_send(['code'=>'error','msg'=>'编辑失败','data'=>json_encode($e->getMessage())]);
            }
		}
		// 错误告知
		if( !$oldData )				return $this->error('查无数据');
        //查询管理账户信息
        $adminInfo                  = $AdminUser->getOne($oldData['admin_uid']);
        $adminInfo                  = $adminInfo ? $adminInfo : ['username'=>'','phone'=>''];
        $oldData['city_ids']		= explode(',',$oldData['city_ids']);
        // 获取列表
        $cityList					= $City->getCityList();
        $mp                         =   [];
        if ($session){
            $mp[]                   =   ['admin_rule.company_id','=',$session['company_id']];
            if ($session['menu_type'] == 1 && $session['data_type'] == 2){
                $mp[]                   =   ['admin_rule.admin_uid','=',$session['admin_uid']];
            }else{
                $mp[]                   =   ['admin_rule.menu_type','=',1];
                $mp[]                   =   ['admin_rule.data_type','=',2];
            }
        }
        $leaderList					= $AdminRule::query()
                                    ->join('admin','admin.uid','=','admin_rule.admin_uid')
                                    ->where($mp)
                                    ->get(['admin.uid','admin.username']);
		// 分配数据
		$this->assign('oldData',$oldData);
		$this->assign('adminInfo',$adminInfo);
		$this->assign('cityList',$cityList);
		$this->assign('leaderList',$leaderList);
		$this->assign('crumbs','修改');
		// 加载模板
		return						$this->fetch();
	}

	/**
	 * 修改状态
	 * 
	 * */
	public function set_status(Request $request,Model $Model){
		// 验证参数
		$request->scene('set_status')->validate();
		// 设置状态
		$id				= request('id',0);
		$status			= request('status',0);
		// 查询用户
		$oldData		= $Model->where(['id'=>$id])->first();
		// 如果用户不存在
		if( !$oldData )	return json_send(['code'=>'error','msg'=>'用户不存在']);
		// 执行修改
		$result			= $Model->edit($id,['status'=>$status]);		
		// 提示新增失败
		if( !$result )	return json_send(['code'=>'error','msg'=>'设置失败']);
		// 记录行为
		$this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,['status'=>$status]);
		// 告知结果
		return 			json_send(['code'=>'success','msg'=>'设置成功','path'=>'']);
	}

}