DEV Community: Alfa Riza

Creating a car rental admin using Laravel 9 part 1: Setup database, model, migration, seeder.

Alfa Riza — Sun, 28 Aug 2022 08:20:15 +0000

Hello everyone, in this article we will create a car rental application using Laravel and bootstrap 5.

Database

for the database architecture I’ve made it on dbdiagram

we have a users table, user_details to store user data, cars table to store car data and transactions table to store transaction data. In the .env file, don’t forget to set the database

DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=rental_mobil DB_USERNAME=root DB_PASSWORD=

Instalation

the next step we will install laravel 9, here i use composer for installation. Run the following command:

composer create-project laravel/laravel rental-mobil cd rental-mobil php artisan serve

then, the initial appearance of our application as follows:

Migration

Our next step will be setting migration according to the database architecture that we created earlier. In the migration create table user change it to like this

Schema::create('users', function (Blueprint $table) { $table->id(); $table->string('name'); $table->string('email')->unique(); $table->timestamp('email_verified_at')->nullable(); $table->string('password'); $table->string('image')->nullable(); $table->boolean('is_admin')->default(0); $table->rememberToken(); $table->timestamps(); });

Next we create a migration for the cars table by running the command

php artisan make:migration create_cars_table

Next on the migration cars file, change it to

Schema::create('cars', function (Blueprint $table) { $table->id(); $table->string('name'); $table->string('plat'); $table->text('description'); $table->boolean('status')->default(1); $table->double('price'); $table->timestamps(); });

Next we create a user details table that will be directly related to the users table. Run the following command to create a user_details migration.

php artisan make:migration create_user_details_table

In user_details migration, change to

Schema::create('user_details', function (Blueprint $table) { $table->id(); $table->foreignId('user_id')->references('id')->on('users')->onDelete('cascade'); $table->string('nik')->nullable(); $table->string('ktp')->nullable(); //image $table->text('alamat')->nullable(); $table->timestamps(); });

Next we create a migration for table transactions, run the following command:

php artisan make:migration create_transactions_table

Pada table transactions ubah menjadi berikut :

Schema::create('transactions', function (Blueprint $table) { $table->id(); $table->foreignId('user_id')->references('id')->on('users')->onDelete('cascade'); $table->foreignId('car_id')->references('id')->on('cars')->onDelete('cascade'); $table->date('date_start'); $table->date('date_end'); $table->date('date_due'); $table->string('status'); $table->double('total'); $table->text('note'); $table->timestamps(); });

Model

Every migration that we have made, we will also create a model so that we can use Eloquent ORM. The model we will create is User, UserDetail, Car, Transaction. Create a model by running the following command:

php artisan make:model Car php artisan make:model UserDetail php artisan make:model Transaction

In User model add fillable image and is_admin, and function

public function detail(){ return $this->hasOne(UserDetail::class); } public function transactions(){ return $this->hasMany(Transaction::class); }

In the UserDetail model, add the following code:

protected $guarded = []; public function user(){ return $this->belongsTo(User::class); }

in the Transaction model add code like this:

protected $guarded = []; public function user(){ return $this->belongsTo(User::class); } public function car(){ return $this->belongsTo(User::class); }

on the Car model add the following code:

protected $guarded = []; public function transactions(){ return $this->hasMany(Transaction::class); }

Seeder

We will create 1 user for admin by creating a seeder, run the following command:

php artisan make:seeder UserSeeder

In the UserSeeder add code like this:

$user = User::create([ 'name' => 'admin', 'email' => 'admin@admin.com', 'password' => Hash::make('12345678'), 'is_admin' => 1, ]); UserDetail::create([ 'user_id' => $user->id, ]);

Don’t forget to call UserSeeder on DatabaseSeeder

$this->call([ UserSeeder::class ]);

And run the migrate command

php artisan migrate --seed

In the next article, we will create auth for our application, thank you :)

Complete List in Python

Alfa Riza — Sun, 29 Aug 2021 23:34:28 +0000

Assalamualaikum warahmatullahi wabarakatuh. Hello everyone, on this occasion we will discuss about lists in python.
List is a data type in python for storing variable items. In the list we can store several types of variables at once. This list is sorted from index 0 and can be changed, added, deleted.

Make a List

How to make a list, by creating open and closed brackets and to separate one variable from another with a comma.

angka = [1,2,3,4]
list1 = ["satu", 2, True]

Reading List

We can read the list by accessing its index. For example, we have a list like this:

list1 = ["Dosen", "Mahasiswa", "Satpam", "Driver"]

to be able to print Students, we can access list1 with index 1.

print(list1[1])

If we want to print all the data in the list, we can use loops.

for l in list1:
   print(l)

Changing List

We can change the value in the list by:

list1 = ["Python", "PHP", "Ruby"]
list1[1] = "Golang"

In the code above, we change PHP to Golang

Add List

We can also add to the list we have with the append() and insert() functions, both of which have differences.
In the append() function, the data we enter will automatically be added to the last index.

list1 = ["Python", "PHP", "Ruby"]
list1.append("Golang")

The code above adds “Golang” to list1, where “Golang” will be added to the end. So that

list1 = ["Python", "PHP", "Ruby", "Golang"]

Whereas in the insert() function, we need 1 more parameter, where this parameter is a specific index that we want to put. For example

list1 = ["Python", "PHP", "Ruby"]
list1.insert(1, "Golang")

The code above, adds "Golang" to list1 with index to 1. So that list1 becomes

list1 = ["Python", "Golang", "PHP", "Ruby"]

Delete List

To delete a list, we can delete one or all data. We will discuss how to delete a single data first, to remove specific data, we can use the remove() function

list1 = ["Python", "PHP", "Ruby"]
list1.remove("Python")

The above code will delete list1 which has "Python" data, so list1

list1 = ["PHP", "Ruby"]

In addition to specific data, we can also delete specific indexes using the pop() function and the del keyword. the pop() function has an index parameter which we will remove.

list1 = ["Python", "PHP", "Ruby"]
list1.pop(1)

The above code removes list1 with index 1, so list1.

list1 = ["Python", "Ruby"]

If the pop() function does not have an index parameter, then the data to be deleted is the last data.

list1 = ["Python", "PHP", "Ruby"]
list1.pop()
list1 = ["Python", "PHP"]

As for the del keyword how to use it as follows:

list1 = ["Python", "PHP", "Ruby"]
del list1[0]
list1 = ["PHP", "Ruby"]

Deleting all data lists we can also use the del keyword and the clear() function. How to use the del keyword, namely:

list1 = ["Python", "PHP", "Ruby"]
del list1
list1 = []

while the use of the clear() function

list1 = ["Python", "PHP", "Ruby"]
list1.clear()
list1 = []

Sort List

If we have a list whose data is not sorted, we can sort it with the sort() function. This function can be used as a string or number data type. The sort function will automatically sort from small to large or ascending.

list2 = [1,9,4,28,17]
list2.sort()
list2 = [1,4,9,17,28]

If we want to sort from largest to smallest or descending, we can add the reverse = True parameter.

list2 = [1,9,4,28,17]
list2.sort(reverse = True)
list2 = [28,17,9,4,1]

Copy List

If we want to copy list then we can't use code

list2 = list1

Because list2 will reference list1, if list1 changes, list2 will automatically change as well. To overcome this, we can use the copy() and list() functions.

list1 = ["Python", "PHP", "Ruby"]
list2 = list1.copy()
list2 = ["Python", "PHP", "Ruby"]

Or we can add list()

list1 = ["Python", "PHP", "Ruby"]
list2 = list(list1)
list2 = ["Python", "PHP", "Ruby"]

Merge List

If we have 2 lists, then we want to combine them. Then the simplest way is to use the + operator.

list1 = ["Python", "PHP", "Ruby"]
list2 = ["Golang", "Vue", "React"]
list3 = list1 + list2
list3 = ["Python", "PHP", "Ruby", "Golang", "Vue", "React"]

Or we can also use the extend() function.

list1 = ["Python", "PHP", "Ruby"]
list2 = ["Golang", "Vue", "React"]
list1.extends(list2)
list1 = ["Python", "PHP", "Ruby", "Golang", "Vue", "React"]

That's enough for us to discuss the list, thank you :)

How to install python 3.9 on windows

Alfa Riza — Sun, 29 Aug 2021 07:18:55 +0000

Assalamualaikum warahmatullahi wabarakatuh, hello everyone, on this occasion, we will learn together how to install python 3.9 on windows 10.

First, we visit python.org, we will download python through this website, because the official python site. The initial appearance of python.org is as follows:

Click downloads, it will be directed to the download page.

Select the python 3.9.6 download button, because it is the latest version of python.

Click double click, it will appear

make sure you check add python to path, this is useful so you can use python in cmd. While installing the launcher for all users is free, you want to check it or not, but my advice is to just tick it so that all users on the computer can use python. After that, click install now.
Wait until the installation process is complete

after python is successfully installed, we need to check whether python is successfully installed or not. Open cmd then type python command and enter.

Enough of this article, thank you so much.

Resolved error: Unable to use proxy: URL http_proxy formatted incorrectly, in composer

Alfa Riza — Sat, 28 Aug 2021 13:31:37 +0000

Assalamualaikum warahmatullahi wabarakatuh, hello everyone, this time I will share my experience with the composer error, which is Unable to use a proxy: malformed http_proxy URL.

If you are experiencing the same problem, you can check out this article. So I haven't coded Laravel for 6 months and my laptop had Windows reinstalled. When I install laravel via composer there is an error.

This problem arises because on our laptop / computer there is an environment variable http_proxy which contains the code http_proxy, the way to solve this is to delete the environment variable.

Open the control panel on our laptop / computer.

Then select system and security, then select system.

Select advanced system settings

Select environment variables

If there are user variables with the name http_proxy, click and delete. Then your problem is solved.
So many articles, hopefully useful and thank you.