belongsTo(\App\Contact::class, 'contact_id'); } public function table() { return $this->belongsTo(\App\Restaurant\ResTable::class, 'table_id'); } public function correspondent() { return $this->belongsTo(\App\User::class, 'correspondent_id'); } public function waiter() { return $this->belongsTo(\App\User::class, 'waiter_id'); } public function location() { return $this->belongsTo(\App\BusinessLocation::class, 'location_id'); } public function business() { return $this->belongsTo(\App\Business::class, 'business_id'); } public static function createBooking($input) { $data = [ 'contact_id' => $input['contact_id'], 'waiter_id' => isset($input['res_waiter_id']) ? $input['res_waiter_id'] : null, 'table_id' => isset($input['res_table_id']) ? $input['res_table_id'] : null, 'business_id' => $input['business_id'], 'location_id' => $input['location_id'], 'correspondent_id' => isset($input['correspondent']) ? $input['correspondent'] : null, 'booking_start' => $input['booking_start'], 'booking_end' => $input['booking_end'], 'created_by' => $input['created_by'], 'booking_status' => isset($input['booking_status']) ? $input['booking_status'] : 'booked', 'booking_note' => $input['booking_note'], ]; $booking = Booking::create($data); return $booking; } }