//可以將下面的代碼放到一個(gè)class中冯丙，然后調(diào)用
xxx(Model new Goods())
$goodsModel = new Goods();
        $fillables = $goodsModel->getFillable();
        foreach( $fillables as $fillable ) {
            if( in_array($fillable , request()->all()) ) {
                $map[$fillable] = request($fillable);
            }
        }
        $goods = Goods::where($map)->select(['id' , 'name' , 'img' , 'sell_price' , 'market_price']);
        //?sortby=name&order=asc
        if( request('sortby') && request('order') ) {
            $sort = request('sortby');
            $order = request('order');
            $goods = $goods->orderBy($sort , $order);
        }
        //?limit=10&page=0
        if( request('limit') && request('page',0)>-1 ) {
            $skip = (int)request('limit') * (int)request('page');
            $take = (int)request('limit');
            $goods = $goods->skip($skip)->take($take);
        }
        $goods = $goods->get();
        return $goods;

$fills = $order->getFillable();//判斷是否設(shè)置了fillable
        $update = request()->all();
        foreach( $update as $k => $v ) {
            if( empty($fills) ) {
                if( isset($order->$k) ) {
                    $order->$k = $v;
                }
            }else{
                $order->$k = $v;
            }
        }
        $result = $order->save();
        if( !$result ) {
            return response()->json(Result::toArray([] , 1 , '操作未完成'));
        }
        return response()->json(Result::toArray($order));

<?php

namespace App\Http\Controllers\xc\api;

use App\Classes\Result;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Http\Request;

/**
 * Trait CommonCRUD
 * @package App\Http\Controllers\xc\api
 */
trait CommonCRUD
{
    protected $with = [];
    protected $orderBy = '';
    protected $select = ['*'];

    public function commonIndex(Request $request , Model $model)
    {
        $sortBy = request('sortBy');
        $order = request('order');
        $limit = request('limit',10);
        $page = request('page',0);

        try {
            $map = request()->all() ? request()->all() : [];
            $model = $model->where($map);
            if( !empty($this->with) ) {
                $model = $model->with($this->with);
            }
            if( !empty($this->orderBy) ) {
                $model = $model->orderBy($this->orderBy[0] ?: $model->primaryKey , $this->orderBy[1] ?: 'asc');
            }
            if( $sortBy && $order ) {
                $model = $model->orderBy($sortBy , $order);
            }
            if( $limit && $page ) {
                $model = $model->skip($limit * $page)->take($limit);
            }
            $model = $model->select($this->select);
            $result = $model->get();
            return response()->json(Result::toArray($result));
        } catch( \Exception $e ) {
            return response()->json(Result::toArray([] , 1 , $e->getMessage()));
        }
    }

    public function commonUpdate(Request $request , Model $model)
    {
        $fills = $model->getFillable();
        $update = request()->all();
        foreach( $update as $k => $v ) {
            if( empty($fills) ) {
                if( isset($model->$k) ) {
                    $model->$k = $v;
                }
            }
            else {
                $model->$k = $v;
            }
        }
        $result = $model->save();
        if( !$result ) {
            return response()->json(Result::toArray([] , 1 , '操作未完成'));
        }
        return response()->json(Result::toArray($model));
    }

    public function commonStore(Request $request , Model $model)
    {
        $data = [];
        $fills = $model->getFillable();
        foreach( $model->getFillable() as $key ) {
            if( empty($fills) ) {
                $data[$key] = $request->$key;
            }
            else {
                if( $request->has($key) ) {
                    $data[$key] = $request->$key;
                }
            }
        }
        if( !$model::create($data) ) {
            return response()->json(Result::toArray([]));
        }
        else {
            return response()->json(Result::toArray([] , 1 , 'error'));
        }
    }

    public function commonDestroy(Request $request , Model $model)
    {
        try {
            $model->delete();
            return response()->json(Result::toArray([]));
        } catch( \Exception $e ) {
            return response()->json(Result::toArray([] , 1 , $e->getMessage()));
        }
    }
}
//調(diào)用

use CommonCRUD;
public function index(Request $request)
    {
        $this->with = ['user'];
        $this->orderBy = ['id','desc'];
        $this->select = ['id','water','user_id'];
        return $this->commonIndex($request , new WashOrder());
}