Admin dashboard in Laravel 8. X | HR MS
Step 1: Create Model and Migrate
By running the below command in your terminal. "2021_10_16_234538_create_sequence_tbls_table.php"
php artisan make:model
sequence_tbl -m
Step 2: CreateSequenceTblsTable
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateSequenceTblsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('sequence_tbls', function (Blueprint $table) {
$table->id();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('sequence_tbls');
}
}
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateSequenceTblsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('sequence_tbls', function (Blueprint $table) {
$table->id();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('sequence_tbls');
}
}
2021_10_16_234708_create_bookings_table.php
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateBookingsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('bookings', function (Blueprint $table) {
$table->id();
$table->string('bkg_id');
$table->string('name')->nullable();
$table->string('room_type')->nullable();
$table->string('total_numbers')->nullable();
$table->string('date')->nullable();
$table->string('time')->nullable();
$table->string('arrival_date')->nullable();
$table->string('depature_date')->nullable();
$table->string('email')->nullable();
$table->string('ph_number')->nullable();
$table->string('status')->nullable();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('bookings');
}
}
2021_10_16_235340_create_create_generate_i_d_bookings_table.php
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateCreateGenerateIDBookingsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
DB::unprepared('
CREATE TRIGGER id_store BEFORE INSERT ON bookings FOR EACH ROW
BEGIN
INSERT INTO sequence_tbls VALUES (NULL);
SET NEW.bkg_id = CONCAT("BKG-", LPAD(LAST_INSERT_ID(), 8, "0"));
END
');
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
DB::unprepared('DROP TRIGGER "id_store"');
}
}
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateCreateGenerateIDBookingsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
DB::unprepared('
CREATE TRIGGER id_store BEFORE INSERT ON bookings FOR EACH ROW
BEGIN
INSERT INTO sequence_tbls VALUES (NULL);
SET NEW.bkg_id = CONCAT("BKG-", LPAD(LAST_INSERT_ID(), 8, "0"));
END
');
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
DB::unprepared('DROP TRIGGER "id_store"');
}
}
Step 3: Make Migration
After adding the migration file now run the migrate command.
php artisan migrate
After adding the migration file now run the migrate command.
php artisan migrate
0 Comments
CAN FEEDBACK
Emoji