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){
 		// 接受参数
		$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];
        $session                = session('userRule');
        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')
            ->join('admin','admin.uid','=','business.admin_uid')
            ->where($map)
            ->orderByDesc('business.id')
            ->select('business.*','company.name as company_name', 'admin.username as username','admin.phone as admin_phone')
            ->paginate(config('page_num',10));
		// 循环处理数据
		foreach ($list as $key => $value) {
			// id转编号
			$value['business_code'] = $Model->idToCode($value['id']);
            $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){
		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','');
            if ($data['city_ids']){
                $data['city_ids']		= implode(',',$data['city_ids']);
            }
			$custom_name		    = request('custom_name','');
			$phone		            = request('phone','');
			$custom_password		= request('custom_password','');
            $session                = session('userRule');
            if ($session['company_id']){
                $data['company_id']	        = $session['company_id'];
                $ruleData['company_id']     = $session['company_id'];
            }
            $userData['username']		= $custom_name;
            $userData['phone']			= $phone;
            $userData['password']		= md5($custom_password);
            // 开启事务
            DB::beginTransaction();
            try {
                // 写入数据表
                $id						= $Model->add($data);
                // 如果操作失败
                if( !$id ){
                    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'=>'新增店铺管理员']);
                }
            }catch (\Exception $e){
                // 回滚事务
                DB::rollBack();
                // 告知错误
                return				json_send(['code'=>'error','msg'=>'新增失败','data'=>json_encode($e->getMessage())]);
            }
            // 提交事务
            DB::commit();
			// 记录行为
			$this->addAdminHistory(admin('uid'),$Model->getTable(),$id,1,[],$data);
			// 告知结果
			return					json_send(['code'=>'success','msg'=>'新增成功','action'=>'add']);
		}
        // 获取列表
        $cityList					= $City->getCityList();
        $session                    = session('userRule');
        $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();
		// 修改
		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','');
            $custom_name		    = request('custom_name','');
            $phone		            = request('phone','');
            $custom_password		= request('custom_password','');
            if ($data['city_ids']){
                $data['city_ids']		= implode(',',$data['city_ids']);
            }
			// 写入数据表
			$result					= $Model->edit($id,$data);
			// 如果操作失败
			if( !$result ) 			return json_send(['code'=>'error','msg'=>'新增失败']);
            $userData['username']	= $custom_name;
            $userData['phone']		= $phone;
            if ($custom_password){
                $userData['password']	= md5($custom_password);
            }
            //获取店铺信息
            $info                   = $Model->getOne($id);
            // 写入数据表
            $result					= $AdminUser->edit($info['admin_uid'],$userData);
            // 如果操作失败
            if( !$result ) 			return json_send(['code'=>'error','msg'=>'新增失败']);
            //var_dump($data);exit();
			// 记录行为
			$this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,$data);
			// 告知结果
			return					json_send(['code'=>'success','msg'=>'修改成功','action'=>'edit']);
		}
		// 错误告知
		if( !$oldData )				return $this->error('查无数据');
        //查询管理账户信息
        $adminInfo                  = $AdminUser->getOne($oldData['admin_uid']);
        // 错误告知
        if( !$adminInfo )			return $this->error('查无管理员账户数据');
        $oldData['city_ids']			= explode(',',$oldData['city_ids']);
        // 获取列表
        $cityList					= $City->getCityList();
        $session                    = session('userRule');
        $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'=>'']);
	}

}