Database.sql

mysql> select eind_datum, start_datum from leases;
+---------------------+---------------------+
| eind_datum          | start_datum         |
+---------------------+---------------------+
| 2020-11-12 00:00:00 | 2020-11-10 00:00:00 |
+---------------------+---------------------+
1 row in set (0.00 sec)

error.php

InvalidArgumentException
Data missing


Stack frames (69)
68
InvalidArgumentException 
…/vendor/nesbot/carbon/src/Carbon/Carbon.php582
67
Carbon\Carbon createFromFormat
…/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php709
66
Illuminate\Database\Eloquent\Model asDateTime
…/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php732
65
Illuminate\Database\Eloquent\Model fromDateTime
…/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php526
64
Illuminate\Database\Eloquent\Model setAttribute
…/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php234
63
Illuminate\Database\Eloquent\Model fill
…/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php462
62
Illuminate\Database\Eloquent\Model update
…/app/Http/Controllers/LeaseInfoController.php72
61
Sijot\Http\Controllers\LeaseInfoController update
…/vendor/laravel/framework/src/Illuminate/Routing/Controller.php55
60
 call_user_func_array
…/vendor/laravel/framework/src/Illuminate/Routing/Controller.php55
59
Illuminate\Routing\Controller callAction
…/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php44
58
Illuminate\Routing\ControllerDispatcher dispatch
…/vendor/laravel/framework/src/Illuminate/Routing/Route.php203
57
Illuminate\Routing\Route runController
…/vendor/laravel/framework/src/Illuminate/Routing/Route.php160
56
Illuminate\Routing\Route run
…/vendor/laravel/framework/src/Illuminate/Routing/Router.php574
55
Illuminate\Routing\Router Illuminate\Routing\{closure}
…/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php30
54
Illuminate\Routing\Pipeline Illuminate\Routing\{closure}
…/app/Http/Middleware/ForbidBannedUser.php46
53
Sijot\Http\Middleware\ForbidBannedUser handle
…/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php148
52
Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure}
…/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53
51
Illuminate\Routing\Pipeline Illuminate\Routing\{closure}
…/app/Http/Middleware/LogLastUserActivity.php26
50
Sijot\Http\Middleware\LogLastUserActivity handle
…/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php148
49
Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure}
…/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53
48
Illuminate\Routing\Pipeline Illuminate\Routing\{closure}
…/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php41
47
Illuminate\Routing\Middleware\SubstituteBindings handle
…/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php148
46
Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure}
…/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53
45
Illuminate\Routing\Pipeline Illuminate\Routing\{closure}
…/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php43
44
Illuminate\Auth\Middleware\Authenticate handle
…/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php148
43
Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure}
…/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53
42
Illuminate\Routing\Pipeline Illuminate\Routing\{closure}
…/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php65
41
Illuminate\Foundation\Http\Middleware\VerifyCsrfToken handle
…/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php148
40
Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure}
…/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53
39
Illuminate\Routing\Pipeline Illuminate\Routing\{closure}
…/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php49
38
Illuminate\View\Middleware\ShareErrorsFromSession handle
…/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php148
37
Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure}
…/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53
36
Illuminate\Routing\Pipeline Illuminate\Routing\{closure}
…/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php64
35
Illuminate\Session\Middleware\StartSession handle
…/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php148
34
Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure}
…/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53
33
Illuminate\Routing\Pipeline Illuminate\Routing\{closure}
…/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php37
32
Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse handle
…/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php148
31
Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure}
…/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53
30
Illuminate\Routing\Pipeline Illuminate\Routing\{closure}
…/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php59
29
Illuminate\Cookie\Middleware\EncryptCookies handle
…/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php148
28
Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure}
…/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53
27
Illuminate\Routing\Pipeline Illuminate\Routing\{closure}
…/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php102
26
Illuminate\Pipeline\Pipeline then
…/vendor/laravel/framework/src/Illuminate/Routing/Router.php576
25
Illuminate\Routing\Router runRouteWithinStack
…/vendor/laravel/framework/src/Illuminate/Routing/Router.php535
24
Illuminate\Routing\Router dispatchToRoute
…/vendor/laravel/framework/src/Illuminate/Routing/Router.php513
23
Illuminate\Routing\Router dispatch
…/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php176
22
Illuminate\Foundation\Http\Kernel Illuminate\Foundation\Http\{closure}
…/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php30
21
Illuminate\Routing\Pipeline Illuminate\Routing\{closure}
…/vendor/garygreen/pretty-routes/src/MainMiddleware.php29
20
PrettyRoutes\MainMiddleware handle
…/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php148
19
Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure}
…/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53
18
Illuminate\Routing\Pipeline Illuminate\Routing\{closure}
…/vendor/barryvdh/laravel-debugbar/src/Middleware/Debugbar.php51
17
Barryvdh\Debugbar\Middleware\Debugbar handle
…/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php148
16
Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure}
…/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53
15
Illuminate\Routing\Pipeline Illuminate\Routing\{closure}
…/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php30
14
Illuminate\Foundation\Http\Middleware\TransformsRequest handle
…/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php148
13
Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure}
…/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53
12
Illuminate\Routing\Pipeline Illuminate\Routing\{closure}
…/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php30
11
Illuminate\Foundation\Http\Middleware\TransformsRequest handle
…/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php148
10
Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure}
…/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53
9
Illuminate\Routing\Pipeline Illuminate\Routing\{closure}
…/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php27
8
Illuminate\Foundation\Http\Middleware\ValidatePostSize handle
…/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php148
7
Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure}
…/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53
6
Illuminate\Routing\Pipeline Illuminate\Routing\{closure}
…/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php46
5
Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode handle
…/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php148
4
Illuminate\Pipeline\Pipeline Illuminate\Pipeline\{closure}
…/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php53
3
Illuminate\Routing\Pipeline Illuminate\Routing\{closure}
…/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php102
2
Illuminate\Pipeline\Pipeline then
…/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php151
1
Illuminate\Foundation\Http\Kernel sendRequestThroughRouter
…/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php116
0
Illuminate\Foundation\Http\Kernel handle
…/public/index.php53

Model.php

<?php

namespace Sijot;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

/**
 * Class Lease
 *
 * @package App
 */
class Lease extends Model
{
    use SoftDeletes;

    /**
     * Mass-assign fields for the database table.
     *
     * @var array
     */
    protected $fillable = [
        'status_id', 'opener_id', 'afsluiter_id', 'kapoenen_lokaal', 
        'welpen_lokaal', 'jongGivers_lokaal', 'givers_lokaal', 
        'jins_lokaal', 'grote_zaal', 'toiletten', 'groeps_naam', 
        'contact_email', 'tel_nummer', 'eind_datum', 'start_datum'
    ];

    /**
     * The attributes that should be mutated to dates.
     *
     * @var array
     */
    protected $dates = ['eind_datum', 'start_datum'];

    /**
     * Format the timestamp format.
     *
     * @param  string $date The start time from the form
     * @return string
     */
    public function setStartDatumAttribute($date)
    {
        // Use with Carbon instance:
        // -------
        // Carbon::createFromFormat('H:i', $date)->format('H:i');
        return $this->attributes['start_datum'] = strtotime(str_replace('/', '-', $date));
    }

    /**
     * Format the timestamp format.
     *
     * @param  string $date The start time from the form
     * @return string
     */
    public function setEndDatumAttribute($date)
    {
        // Use with Carbon instance:
        // -------
        // Carbon::createFromFormat('H:i', $date)->format('H:i');
        return $this->attributes['eind_datum'] = strtotime(str_replace('/', '-', $date));
    }

    /**
     * Get the notitions for the given domain lease.
     *
     * @return \Illuminate\Database\Eloquent\Relations\BelongsToMany
     */
    public function notitions()
    {
        return $this->belongsToMany(Notitions::class)->withTimestamps();
    }

    /**
     * Get the 'opener' for the lease.
     *
     * @return \Illuminate\Database\Eloquent\Relations\BelongsToMany
     */
    public function opener() 
    {
        return $this->belongsTo(User::class, 'opener_id');
    }

    /**
     * Get the 'afsluiter' for the lease.
     *
     * @return \Illuminate\Database\Eloquent\Relations\BelongsToMany
     */
    public function afsluiter() 
    {
        return $this->belongsTo(User::class, 'afsluiter_id'); 
    }
}