izdiwho / mybibd

Laravel Web App that interacts with BIBD's Mobile API. Also, first OSS project, let's see where this goes.

Iz

mybibd's Issues

SQL Query exception when generated bcrypt internet_pin or mobile_pin too long

When running: php artisan migrate:fresh --seed

Output:

Dropped all tables successfully.
Migration table created successfully.
Migrating: 2014_10_12_000000_create_users_table
Migrated:  2014_10_12_000000_create_users_table


   Illuminate\Database\QueryException  : SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'mobile_pin' at row 1 (SQL: insert into `users` (`name`, `username`, `password`, `internet_pin`, `mobile_pin`, `updated_at`, `created_at`) ... 

[Remove sensitive info]

PDOException::("SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'mobile_pin' at row 1")

Seems like the string set in the migration for user found in 2014_10_12_000000_create_users_table.php in line 21 and 22:

            $table->string('internet_pin')->nullable();
            $table->string('mobile_pin')->nullable();

Isn't set to how long should be the string.

To fix this, need to create a new migration and modify those two columns to have set to 255 string length. (Without specifying them the length would default to 191, which bcrypt would produce text longer than that.)

Thus:

            $table->string('internet_pin', 255)->nullable();
            $table->string('mobile_pin', 255)->nullable();

Ideally this should've been char(60) or binary(60) stackoverflow

Logging out is not quite working

The logout doesn't quite log out from BIBD.

Pressing the log out button returns 419 error (page expires)

The account is still persistent and logged in.

Also, when going directly (refreshing) mybibd.test/logout returns:

Symfony\Component\HttpKernel\Exception\MethodNotAllowedHttpException thrown with message "The GET method is not supported for this route. Supported methods: POST."

Stacktrace:
#27 Symfony\Component\HttpKernel\Exception\MethodNotAllowedHttpException in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Routing/RouteCollection.php:256
#26 Illuminate\Routing\RouteCollection:methodNotAllowed in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Routing/RouteCollection.php:242
#25 Illuminate\Routing\RouteCollection:getRouteForMethods in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Routing/RouteCollection.php:176
#24 Illuminate\Routing\RouteCollection:match in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Routing/Router.php:634
#23 Illuminate\Routing\Router:findRoute in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Routing/Router.php:623
#22 Illuminate\Routing\Router:dispatchToRoute in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Routing/Router.php:612
#21 Illuminate\Routing\Router:dispatch in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176
#20 Illuminate\Foundation\Http\Kernel:Illuminate\Foundation\Http\{closure} in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
#19 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /Users/bahit/Projects/mybibd/vendor/fideloper/proxy/src/TrustProxies.php:57
#18 Fideloper\Proxy\TrustProxies:handle in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#17 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#16 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
#15 Illuminate\Foundation\Http\Middleware\TransformsRequest:handle in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#14 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#13 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
#12 Illuminate\Foundation\Http\Middleware\TransformsRequest:handle in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#11 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#10 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
#9 Illuminate\Foundation\Http\Middleware\ValidatePostSize:handle in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#8 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#7 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:62
#6 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode:handle in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#5 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#4 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104
#3 Illuminate\Pipeline\Pipeline:then in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:151
#2 Illuminate\Foundation\Http\Kernel:sendRequestThroughRouter in /Users/bahit/Projects/mybibd/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:116
#1 Illuminate\Foundation\Http\Kernel:handle in /Users/bahit/Projects/mybibd/public/index.php:55
#0 require in /Users/bahit/.composer/vendor/laravel/valet/server.php:151

Getting dashboard welcome data

When logging into BIBD app, on the dashboard. The welcome screen contains 2 information:

• Logged in user's name (perhaps this is based from user's registered name)
• Date and time logged in

Any idea, where we can retrieve this via the API?