票务系统微信小程序后端（五）

jinduo 的个人博客 / 0 / 0 / 创建于 2年前 / 更新于 2年前

1.票务表的增删改查tickets
先修改下app/models/Ticket模型文件，新增一个fillable

class Ticket extends Model
{
    use HasFactory;

    protected $fillable = [
        'id',
        'title',
        'pic',
        'user_id',
        'tel',
        'time_at',
        'time_end',
        'unit_price',
        'quantity',
        'explain',
        'address',
        'location',
        'remark',
        'is_hidden',
        'created_at',
        'updated_at',
    ];
}

在app/Http/TicketController.php文件中新增路由中的增删改查方法

    public function index(Request $request){
        return Ticket::paginate(14);
    }
    public function show($id){
        return Ticket::find($id);
    }
    public function store(Request $request,Ticket $ticket){
        $user = Auth::guard('api')->user();
        $ticket->fill($request->all());
        $ticket['user_id']=$user->id;
        $success = $ticket->save();
        if ($success) {
            return response()->json([
                'msg' => '创建成功',
                'data'=> $ticket
            ]);
        } else {
            return response()->json([
                'msg' => '创建失败',
                'data'=> $ticket
            ],201);
        }
    }
    public function update(Request $request){
        $user = Auth::guard('api')->user();
        $ticket=Ticket::updateOrCreate(['id'=>$request['id']],[
            'title'=>$request['title'],
            'pic'=>$request['pic'],
            'user_id'=>$user->id,
            'tel'=>$request['tel'],
            'time_at'=>$request['time_at'],
            'time_end'=>$request['time_end'],
            'unit_price'=>$request['unit_price'],
            'quantity'=>$request['quantity'],
            'explain'=>$request['explain'],
            'address'=>$request['address'],
            'location'=>$request['location'],
            'remark'=>$request['remark'],
            'is_hidden'=>$request['is_hidden'],
            'updated_at'=>now(),
        ]);
        return response()->json([
            'msg' => '修改成功',
            'data'=> $ticket
        ]);
    }
    public function destroy($id){
        $user = Auth::guard('api')->user();
        $ticket=Ticket::find($id);
        $attributes['is_hidden'] = 'T';
        $attributes['updated_at'] = now();
        $ticket->update($attributes);
        return response()->json([
            'msg'=>'删除成功',
        ]);
    }