miao/server/app/Http/Controllers/Admin/User/InfoController.php

<?php
/**
 *  用户表
 *  @author  system
 *  @version    1.0
 *  @date 2017-05-30 12:16:56
 *
 */
namespace App\Http\Controllers\Admin\User;
use App\Http\Controllers\Admin\Controller;
use App\Models\BaseAttachmentModel;
use App\Models\MeetInfoModel;
use App\Models\SearchInfoModel;
use App\Models\Suggest;
use App\Models\SupportDreamModel;
use App\Models\SystemInfoModel;
use App\Models\UserBanksModel;
use App\Models\UserCareDream;
use App\Models\UserCashOut;
use App\Models\UserInfoModel;
use Illuminate\Http\Request;
use App\Repositories\Base\Criteria\OrderBy;
use App\Repositories\User\Criteria\MultiWhere;
use App\Repositories\User\InfoRepository;

class InfoController extends Controller
{
    private $repository;

    public function __construct(InfoRepository $repository) {
        if(!$this->repository) $this->repository = $repository;
    }

    function index(Request $reqeust) {
        $search['keyword'] = $reqeust->input('keyword');
        $query = $this->repository->pushCriteria(new MultiWhere($search));
        $request = $reqeust->all();
        if(isset($request['sort_field']) && $request['sort_field'] && isset($request['sort_field_by'])) {
        $query = $query->pushCriteria(new OrderBy($request['sort_field'],$request['sort_field_by']));
        }
        $list = $query->paginate();
        foreach ($list as $item) {
            $dream_number = count($item->dreams);
            $score_array = SupportDreamModel::where('user_id',$item->id)->select('score')->get()->toArray();
            $coin_array = $item->dreams->toArray();
            if (count($coin_array) > 0) {
                $coin_list = array_column($coin_array,'get_coin');
                $get_coin = array_sum($coin_list);
            }else{
                $get_coin = 0;
            }
            if (count($score_array) > 0) {
              $score_list = array_column($score_array,'score');
                $sup_score = array_sum($score_list);
            }else{
                $sup_score = 0;
            }
            $item->dream_number = $dream_number;        //梦想数量
            $item->sup_score = $sup_score;              //捐赠分数
            $item->get_coin = $get_coin;                //收到的梦想币
        }
        return view('admin.user.info.index',compact('list'));
    }

    function check(Request $reqeust) {
        $request = $reqeust->all();
        $search['keyword'] = $reqeust->input('keyword');
        $orderby = array();
        if(isset($request['sort_field']) && $request['sort_field'] && isset($request['sort_field_by'])) {
            $orderby[$request['sort_field']] = $request['sort_field_by'];
        }
        $list = $this->repository->search($search,$orderby);
        return view('admin.user.info.check',compact('list'));
    }


    /**
     * 添加
     * 
     */
    public function create(Request $reqeust)
    {
        if($reqeust->method() == 'POST') {
            $validator = \Validator::make($reqeust->all(),
                [
                    'data.address'  => 'required',
                    'data.phone'  => 'required|unique:user_info,phone',
                    'data.sex'  => 'required',
                    'data.emotion'  => 'required',
//                    'avatar' => 'dimensions:width=100,height=100'
                ],
                [
                    'data.address.required'  => '请选择省市区地址',
                    'data.sex.required'  => '请选择性别',
                    'data.phone.unique'  => '电话号码唯一',
                    'data.emotion.required'  => '请选择情感状态',
                ]
            );
            if($validator->fails()){
                $url[] = array('url'=>U( 'User/Info/index'),'title'=>'返回列表');
                return $this->showWarning($validator->messages()->all(),$url);
            }

            $avatar =  request('avatar');
            $data = (array) request('data');
            $data['avatar'] = getenv('APP_URL').$avatar;
            $id = $this->repository->create($data);
            if($id) {
                $url[] = array('url'=>U( 'User/Info/index'),'title'=>'返回列表');
                $url[] = array('url'=>U( 'User/Info/create'),'title'=>'继续添加');
                $this->showMessage('添加成功',$url);
            }else{
                $url[] = array('url'=>U( 'User/Info/index'),'title'=>'返回列表');
                return $this->showWarning('添加失败',$url);
            }

        }
        return view('admin.user.info.edit');
    }

    /**
     * 保存修改
     */
    private function _createSave(){
        $avatar =  request('avatar');
        $data = (array) request('data');
        $data['avatar'] = getenv('APP_URL').$avatar;
        $id = $this->repository->create($data);
        if($id) {
            $url[] = array('url'=>U( 'User/Info/index'),'title'=>'返回列表');
            $url[] = array('url'=>U( 'User/Info/create'),'title'=>'继续添加');
            $this->showMessage('添加成功',$url);
        }else{
            $url[] = array('url'=>U( 'User/Info/index'),'title'=>'返回列表');
            return $this->showWarning('添加失败',$url);
        }
    }
    
    /**
     * 
     * 修改
     * 
     * 
     */
    public function update(Request $reqeust) {
        if($reqeust->method() == 'POST') {
            return $this->_updateSave();
        }
        $data = $this->repository->find($reqeust->get('id'));
        return view('admin.user.info.edit',compact('data'));
    }

    /**
     * 保存修改
     */
    private function _updateSave() {
        $old_avatar = $this->repository->find(request('id'))->avatar;
        $data = (array) request('data');
        if (!empty(request('avatar'))) {
            if (is_file('.'.str_replace(getenv('APP_URL'),'',$old_avatar))) {
                unlink('.'.str_replace(getenv('APP_URL'),'',$old_avatar));
            }
            BaseAttachmentModel::where('url',$old_avatar)->delete();
            $data['avatar'] = getenv('APP_URL').request('avatar');
        }
        $ok = $this->repository->update(request('id'),$data);
        if($ok) {
            $url[] = array('url'=>U( 'User/Info/index'),'title'=>'返回列表');
            return $this->showMessage('操作成功',urldecode(request('_referer')));
        }else{
            $url[] = array('url'=>U( 'User/Info/index'),'title'=>'返回列表');
            return $this->showWarning('操作失败',$url);
        }
    }

    public function view(Request $reqeust) {
        $data = $this->repository->find(request('id'));
        return view('admin.user.info.view',compact('data'));
    }


    /**
     *
     * 状态改变
     *
     */
    public function status(Request $reqeust) {
        $ok = $this->repository->updateStatus(request('id'),request('status'));
        if($ok) {
            return $this->showMessage('操作成功');
        }else{
            return $this->showWarning('操作失败');
        }
    }
    
    /**
     * 删除
     */
    public function destroy(Request $reqeust) {
        $user_id = $reqeust->get('id');
        $user = UserInfoModel::find($user_id);
        $allImgs = $user->allImgs();
        if(count($allImgs) > 0) $allImgs->delete();
        $allInteraction = $user->allInteraction();
        if(count($allInteraction) > 0) $allInteraction->delete();
        $dreams = $user->dreams();
        if(count($dreams) > 0) $dreams->delete();
        $bool = $this->repository->destroy($reqeust->get('id'));
        if($bool) {
//            删除用户后跟用户相关的数据全部删除
            UserCashOut::where('user_id',$user_id)->delete();
            UserCareDream::where('user_id',$user_id)->delete();
            UserBanksModel::where('user_id',$user_id)->delete();
            SystemInfoModel::where('user_id',$user_id)->delete();
            SupportDreamModel::where('user_id',$user_id)->delete();
            Suggest::where('user_id',$user_id)->delete();
            SearchInfoModel::where('user_id',$user_id)->delete();
            MeetInfoModel::where('user_id',$user_id)->delete();
            return  $this->showMessage('操作成功');
        }else{
            return  $this->showWarning("操作失败");
        }
    }
}