Server : LiteSpeed System : Linux barito.iixcp.rumahweb.net 5.14.0-611.49.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Apr 21 16:39:08 EDT 2026 x86_64 User : elvh3918 ( 1528) PHP Version : 8.2.31 Disable Function : mail Directory :  /home/elvh3918/public_html/pmm/database/seeders/Master/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

namespace Database\Seeders\Master;

use Illuminate\Database\Console\Seeds\WithoutModelEvents;
use Illuminate\Database\Seeder;
use Carbon\Carbon;
use Illuminate\Support\Facades\DB;
use App\Models\User;

class CustomerSeeder extends Seeder
{
    /**
     * Run the database seeds.
     */
    public function run(): void
    {
        $now = Carbon::now();
        $project = config('app.project_app');
        $tenant = DB::table('tenant')->get();

        for ($i=0; $i < count($tenant); $i++) {
            $id = $tenant[$i]->id;
            
            DB::insert(
                "INSERT INTO customers (name, address, email, phone, tenant_id, created_at, updated_at) VALUES
                ('Elsa Aprelia', 'Śmiecińska 14, 06-400 Ciechanów', 'diapersky@el-vanda.com', '+48 2367 xxx', $id , '$now', '$now')
                ;"
            );
        }

        // register permissions
        app()[\Spatie\Permission\PermissionRegistrar::class]->forgetCachedPermissions();

        $now = Carbon::now();
        DB::insert(
            "INSERT INTO permissions (name, guard_name, created_at, updated_at) VALUES
            (CONCAT('$project', '_master_customers_customers_view'), 'web', '$now', '$now'),
            (CONCAT('$project', '_master_customers_customers_create'), 'web', '$now', '$now'),
            (CONCAT('$project', '_master_customers_customers_edit'), 'web', '$now', '$now'),
            (CONCAT('$project', '_master_customers_customers_delete'), 'web', '$now', '$now'),
            (CONCAT('$project', '_master_customers_customers_print'), 'web', '$now', '$now')
            ;"
        );

        $admin = User::where('name', 'tenant')->first();
        $admin->givePermissionTo($project.'_master_customers_customers_view', $project.'_master_customers_customers_create', $project.'_master_customers_customers_edit', $project.'_master_customers_customers_delete', $project.'_master_customers_customers_print');

        $admin = User::where('name', 'admin')->first();
        $admin->givePermissionTo($project.'_master_customers_customers_view', $project.'_master_customers_customers_create', $project.'_master_customers_customers_edit', $project.'_master_customers_customers_delete', $project.'_master_customers_customers_print');
    }
}