Gecko [ school.pilasatech.net ]

Name	Size	Permission	Date	Action
DatabaseSeeder.php	6.73 KB	-rw-rw-rw-	2025-03-23 16:47
UserSeeder.php	284 B	-rw-rw-rw-	2025-03-23 13:11

Rename

<?php

namespace Database\Seeders;

use App\Models\User;
use App\Models\CourseEnrollment;
use App\Models\CourseAssignment;
use App\Models\Grade;
use App\Models\Mark;
use App\Models\Attendance;
use App\Models\Subject;
// use Illuminate\Database\Console\Seeds\WithoutModelEvents;
use Illuminate\Database\Seeder;
use Spatie\Permission\Models\Role;
use Spatie\Permission\Models\Permission;
use Faker\Factory as Faker;

class DatabaseSeeder extends Seeder
{
    /**
     * Seed the application's database.
     */
    public function run(): void
    {

// Create roles
        // $adminRole = Role::firstOrCreate(['name' => 'admin']);
        // $teacherRole = Role::firstOrCreate(['name' => 'teacher']);
        // $studentRole = Role::firstOrCreate(['name' => 'student']);

// // Create permissions for MarkResource
        // $markPermissions = [
        //     'view_any_mark',
        //     'view_mark',
        //     'create_mark',
        //     'update_mark',
        //     'delete_mark',
        // ];

// foreach ($markPermissions as $permission) {
        //     Permission::firstOrCreate([
        //         'name' => $permission,
        //         'guard_name' => 'web',
        //     ]);
        // }

// // Define permissions for each role
        // $adminPermissions = Permission::all()->pluck('name')->toArray();
        // $teacherPermissions = [
        //     // 'view_any_attendance',
        //     // 'view_attendance',
        //     // 'create_attendance',
        //     // 'update_attendance',
        //     // 'delete_attendance',
        //     // 'view_any_course_assignment',
        //     // 'view_course_assignment',
        //     // 'view_any_grade',
        //     // 'view_grade',
        //     // 'create_grade',
        //     // 'update_grade',
        //     // 'delete_grade',
        //     'view_any_mark',
        //     'view_mark',
        //     'create_mark',
        //     'update_mark',
        //     'delete_mark',
        // ];

// $studentPermissions = [
        //     'view_mark',
        // ];

// // Assign permissions to roles
        // $adminRole->syncPermissions($adminPermissions);
        // $teacherRole->syncPermissions($teacherPermissions);
        // $studentRole->syncPermissions($studentPermissions);

// // Create users and assign roles
        // $admin = User::firstOrCreate(
        //     ['email' => 'admin@example.com'],
        //     ['name' => 'Admin', 'password' => bcrypt('password')]
        // );
        // $admin->assignRole('admin');

// $teacher = User::firstOrCreate(
        //     ['email' => 'teacher@example.com'],
        //     ['name' => 'Teacher', 'password' => bcrypt('password')]
        // );
        // $teacher->assignRole('teacher');

// $student = User::firstOrCreate(
        //     ['email' => 'student@example.com'],
        //     ['name' => 'Student', 'password' => bcrypt('password')]
        // );
        // $student->assignRole('student');

// // Create sample data
        // $subject = Subject::firstOrCreate(
        //     ['name' => 'Math'],
        //     ['description' => 'Mathematics Course']
        // );

// $enrollment = CourseEnrollment::firstOrCreate(
        //     [
        //         'student_id' => $student->id,
        //         'course_id' => $subject->id,
        //         'year' => '2025',
        //         'semester' => 'Spring',
        //     ]
        // );

// CourseAssignment::firstOrCreate(
        //     [
        //         'course_id' => $subject->id,
        //         'teacher_id' => $teacher->id,
        //         'year' => '2025',
        //         'semester' => 'Spring',
        //     ]
        // );

// Grade::firstOrCreate(
        //     [
        //         'subject_id' => $subject->id,
        //         'teacher_id' => $teacher->id,
        //         'student_id' => $student->id,
        //     ],
        //     ['marks' => 85.5]
        // );

// Mark::firstOrCreate(
        //     [
        //         'enrollment_id' => $enrollment->id,
        //         'score' => 90,
        //     ],
        //     [
        //         'weight' => 0.3,
        //         'remark' => 'Excellent',
        //     ]
        // );

// Attendance::firstOrCreate(
        //     [
        //         'enrollment_id' => $enrollment->id,
        //         'date' => now(),
        //         'shift' => 'Morning',
        //     ],
        //     [
        //         'status' => 'present',
        //         'remark' => 'On time',
        //     ]
        // );
        // $faker = Faker::create();

// for ($i = 1; $i <= 10; $i++) {
        //     $student = User::create([
        //         'name' => $faker->name,
        //         'email' => $faker->unique()->safeEmail,
        //         'password' => bcrypt('password'),
        //     ]);

//     $student->assignRole('student');
        // }
        
        
        // Create roles
        Role::create(['name' => 'admin']);
        Role::create(['name' => 'teacher']);
        Role::create(['name' => 'student']);

// Create users and assign roles
        $admin = User::create(['name' => 'Admin', 'email' => 'admin@example.com', 'password' => bcrypt('password')]);
        $admin->assignRole('admin');

$teacher = User::create(['name' => 'Teacher', 'email' => 'teacher@example.com', 'password' => bcrypt('password')]);
        $teacher->assignRole('teacher');

$student = User::create(['name' => 'Student', 'email' => 'student@example.com', 'password' => bcrypt('password')]);
        $student->assignRole('student');

// Create sample data
        $subject = Subject::create(['name' => 'Math', 'description' => 'Mathematics Course']);

// Fixed: Remove .Concurrent
        $enrollment = CourseEnrollment::create([
            'student_id' => $student->id,
            'course_id' => $subject->id,
            'year' => '2025',
            'semester' => 'Spring',
        ]);

CourseAssignment::create([
            'course_id' => $subject->id,
            'teacher_id' => $teacher->id,
            'year' => '2025',
            'semester' => 'Spring',
        ]);

Grade::create([
            'subject_id' => $subject->id,
            'teacher_id' => $teacher->id,
            'student_id' => $student->id,
            'marks' => 85.5,
        ]);

Mark::create([
            'enrollment_id' => $enrollment->id,
            'score' => 90,
            'weight' => 0.3,
            'remark' => 'Excellent',
        ]);

Attendance::create([
            'enrollment_id' => $enrollment->id,
            'shift' => 'Morning',
            'remark' => 'On time',
            'is_present' => true,
            'date' => now(),
        ]);
    }
}