<?php

namespace Database\Seeders;

use App\Models\ConsultationSlot;
use App\Models\Faq;
use App\Models\HomepageSection;
use App\Models\Service;
use App\Models\ServiceCategory;
use App\Models\ServicePackage;
use App\Models\ServiceRequirement;
use App\Models\SiteSetting;
use App\Models\Testimonial;
use App\Models\User;
use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\Hash;

class DatabaseSeeder extends Seeder
{
    public function run(): void
    {
        // Admin user
        User::create([
            'name'  => 'Texora Admin',
            'email' => 'admin@texora.pk',
            'password' => Hash::make('password'),
            'role'  => 'admin',
            'phone' => '+92-300-0000000',
        ]);

        // Demo client
        User::create([
            'name'     => 'Ahmed Khan',
            'email'    => 'ahmed@demo.com',
            'password' => Hash::make('password'),
            'role'     => 'user',
            'phone'    => '+92-321-1234567',
            'city'     => 'Karachi',
        ]);

        // Service Categories
        $pkCat = ServiceCategory::create([
            'name'       => 'Pakistan Services',
            'slug'       => 'pakistan',
            'icon'       => '🇵🇰',
            'color'      => '#10B981',
            'sort_order' => 1,
        ]);

        $intlCat = ServiceCategory::create([
            'name'       => 'International Services',
            'slug'       => 'international',
            'icon'       => '🌍',
            'color'      => '#2563EB',
            'sort_order' => 2,
        ]);

        // ────────────────────────────────────────────────────────
        // PAKISTAN SERVICES
        // ────────────────────────────────────────────────────────

        $companyReg = Service::create([
            'service_category_id' => $pkCat->id,
            'name'             => 'Company Registration',
            'slug'             => 'company-registration',
            'icon'             => '🏢',
            'badge'            => 'Most Popular',
            'short_description'=> 'Register your SMC, Pvt Ltd, or AOP with SECP — fully online.',
            'description'      => 'Get your company registered with the Securities and Exchange Commission of Pakistan (SECP) quickly and easily. We handle the entire process from name search to certificate of incorporation.',
            'what_you_get'     => [
                'Certificate of Incorporation',
                'Memorandum & Articles of Association',
                'Digital Signature (DSC)',
                'SECP Company Registration Number',
                'NTN Registration (bundled)',
                'Digital Copies of all documents',
            ],
            'process_timeline' => [
                ['day' => 'Day 1', 'title' => 'Document Submission', 'desc' => 'Submit required documents through your dashboard'],
                ['day' => 'Day 2', 'title' => 'Name Availability Check', 'desc' => 'We verify name availability on SECP portal'],
                ['day' => '3–5', 'title' => 'Processing & Filing', 'desc' => 'Our team files your application with SECP'],
                ['day' => '5–7', 'title' => 'Incorporation Certificate', 'desc' => 'Certificate issued and delivered to your dashboard'],
            ],
            'important_note'   => 'Once documents are submitted, our team will review and schedule a call to confirm details. If additional documents are required, you will be notified through your dashboard and WhatsApp.',
            'is_featured'      => true,
            'sort_order'       => 1,
        ]);

        ServicePackage::insert([
            ['service_id' => $companyReg->id, 'name' => 'SMC Private Limited', 'price' => 15000, 'currency' => 'PKR', 'delivery_days' => 7, 'is_popular' => false, 'sort_order' => 1, 'features' => json_encode(['SECP SMC Registration', 'NTN Registration', 'Digital Documents', 'Email Support']), 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $companyReg->id, 'name' => 'Private Limited (Pvt Ltd)', 'price' => 25000, 'currency' => 'PKR', 'delivery_days' => 7, 'is_popular' => true, 'sort_order' => 2, 'features' => json_encode(['SECP Pvt Ltd Registration', 'NTN Registration', 'Digital Documents', 'Dedicated Manager', 'WhatsApp Support']), 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $companyReg->id, 'name' => 'AOP (Association of Persons)', 'price' => 12000, 'currency' => 'PKR', 'delivery_days' => 5, 'is_popular' => false, 'sort_order' => 3, 'features' => json_encode(['AOP Registration', 'NTN Registration', 'Partnership Deed', 'Email Support']), 'created_at' => now(), 'updated_at' => now()],
        ]);

        ServiceRequirement::insert([
            ['service_id' => $companyReg->id, 'document_name' => 'CNIC Copy (all directors)', 'is_required' => true, 'sort_order' => 1, 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $companyReg->id, 'document_name' => '3 Business Name Options', 'is_required' => true, 'sort_order' => 2, 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $companyReg->id, 'document_name' => 'Registered Business Address', 'is_required' => true, 'sort_order' => 3, 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $companyReg->id, 'document_name' => 'Directors\' Contact Numbers & Emails', 'is_required' => true, 'sort_order' => 4, 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $companyReg->id, 'document_name' => 'Nature of Business Description', 'is_required' => true, 'sort_order' => 5, 'created_at' => now(), 'updated_at' => now()],
        ]);

        $ntn = Service::create([
            'service_category_id' => $pkCat->id,
            'name'              => 'NTN Registration',
            'slug'              => 'ntn-registration',
            'icon'              => '📋',
            'short_description' => 'Get your National Tax Number from FBR — Individual or Business.',
            'what_you_get'      => ['NTN Certificate', 'FBR Login Credentials', 'Tax Profile Setup', 'Email & WhatsApp Support'],
            'process_timeline'  => [
                ['day' => 'Day 1', 'title' => 'Submit Documents', 'desc' => 'Upload CNIC and required info'],
                ['day' => 'Day 2', 'title' => 'FBR Application', 'desc' => 'We file your NTN application on IRIS'],
                ['day' => '2–3', 'title' => 'NTN Issued', 'desc' => 'NTN number shared via dashboard'],
            ],
            'important_note' => 'NTN processing time depends on FBR system availability. Usually completed within 24–48 hours.',
            'sort_order'     => 2,
        ]);

        ServicePackage::insert([
            ['service_id' => $ntn->id, 'name' => 'Individual NTN', 'price' => 3000, 'currency' => 'PKR', 'delivery_days' => 2, 'is_popular' => false, 'sort_order' => 1, 'features' => json_encode(['FBR NTN Registration', 'IRIS Account', 'NTN Certificate']), 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $ntn->id, 'name' => 'Business NTN', 'price' => 5000, 'currency' => 'PKR', 'delivery_days' => 3, 'is_popular' => true, 'sort_order' => 2, 'features' => json_encode(['Business NTN', 'IRIS Account Setup', 'NTN Certificate', 'Tax Profile']), 'created_at' => now(), 'updated_at' => now()],
        ]);

        ServiceRequirement::insert([
            ['service_id' => $ntn->id, 'document_name' => 'CNIC Copy', 'is_required' => true, 'sort_order' => 1, 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $ntn->id, 'document_name' => 'Active Phone Number', 'is_required' => true, 'sort_order' => 2, 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $ntn->id, 'document_name' => 'Email Address', 'is_required' => true, 'sort_order' => 3, 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $ntn->id, 'document_name' => 'Residential Address', 'is_required' => true, 'sort_order' => 4, 'created_at' => now(), 'updated_at' => now()],
        ]);

        $taxFiling = Service::create([
            'service_category_id' => $pkCat->id,
            'name'              => 'Income Tax Filing',
            'slug'              => 'income-tax-filing',
            'icon'              => '📊',
            'badge'             => 'Annual',
            'short_description' => 'File your annual income tax return and wealth statement with FBR.',
            'what_you_get'      => ['Income Tax Return Filed', 'Wealth Statement Filed', 'Acknowledgement Receipt', 'Tax Computation Sheet', 'FBR Filing proof'],
            'process_timeline'  => [
                ['day' => 'Day 1', 'title' => 'Document Collection', 'desc' => 'Submit bank statements and income details'],
                ['day' => '2–3', 'title' => 'Tax Computation', 'desc' => 'Our CA reviews and computes your tax'],
                ['day' => '3–5', 'title' => 'Return Filed', 'desc' => 'Return filed and acknowledgement shared'],
            ],
            'important_note' => 'Deadline for tax filing is September 30th each year. File early to avoid penalties.',
            'sort_order'     => 3,
        ]);

        ServicePackage::insert([
            ['service_id' => $taxFiling->id, 'name' => 'Salaried Individual', 'price' => 5000, 'currency' => 'PKR', 'delivery_days' => 5, 'is_popular' => false, 'sort_order' => 1, 'features' => json_encode(['Income Tax Return', 'Wealth Statement', 'Acknowledgement']), 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $taxFiling->id, 'name' => 'Business Owner', 'price' => 10000, 'currency' => 'PKR', 'delivery_days' => 7, 'is_popular' => true, 'sort_order' => 2, 'features' => json_encode(['Business Income Return', 'Wealth Statement', 'Tax Computation', 'CA Certified', 'Dedicated Manager']), 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $taxFiling->id, 'name' => 'Freelancer / IT Export', 'price' => 7500, 'currency' => 'PKR', 'delivery_days' => 5, 'is_popular' => false, 'sort_order' => 3, 'features' => json_encode(['Freelancer Return', 'Foreign Income Disclosure', 'Wealth Statement', 'Tax exemption optimization']), 'created_at' => now(), 'updated_at' => now()],
        ]);

        $trademark = Service::create([
            'service_category_id' => $pkCat->id,
            'name'              => 'Trademark Registration',
            'slug'              => 'trademark-registration',
            'icon'              => '™️',
            'short_description' => 'Protect your brand name and logo with IPO Pakistan.',
            'what_you_get'      => ['IPO Application Filed', 'TM Number', 'Filing Receipt', 'Status Tracking', 'Objection Handling'],
            'process_timeline'  => [
                ['day' => 'Day 1', 'title' => 'Trademark Search', 'desc' => 'Free search to check availability'],
                ['day' => '2', 'title' => 'Application Filed', 'desc' => 'Filed with IPO Pakistan'],
                ['day' => '3–6 months', 'title' => 'Examination', 'desc' => 'IPO examines the application'],
                ['day' => '9–12 months', 'title' => 'Registration', 'desc' => 'Certificate of Registration issued'],
            ],
            'important_note' => 'Trademark registration takes 9–18 months. Filing date is your protection date.',
            'sort_order'     => 4,
        ]);

        ServicePackage::insert([
            ['service_id' => $trademark->id, 'name' => 'Basic Filing', 'price' => 15000, 'currency' => 'PKR', 'delivery_days' => 2, 'is_popular' => false, 'sort_order' => 1, 'features' => json_encode(['1 Class Filing', 'IPO Receipt', 'TM Number']), 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $trademark->id, 'name' => 'Full Protection', 'price' => 25000, 'currency' => 'PKR', 'delivery_days' => 2, 'is_popular' => true, 'sort_order' => 2, 'features' => json_encode(['Up to 3 Classes', 'Trademark Search', 'IPO Filing', 'Objection Handling', 'Dedicated Manager']), 'created_at' => now(), 'updated_at' => now()],
        ]);

        $salesTax = Service::create([
            'service_category_id' => $pkCat->id,
            'name'              => 'Sales Tax Registration (STRN)',
            'slug'              => 'sales-tax-registration',
            'icon'              => '🧾',
            'short_description' => 'Get your Sales Tax Registration Number (STRN) and setup monthly filing.',
            'what_you_get'      => ['STRN Certificate', 'FBR IRIS Setup', 'Monthly Filing Guide', 'First Month Filing Included'],
            'process_timeline'  => [
                ['day' => 'Day 1', 'title' => 'Documents Submitted', 'desc' => 'Business docs and bank details shared'],
                ['day' => '2–3', 'title' => 'FBR Application', 'desc' => 'STRN application filed on FBR portal'],
                ['day' => '5–7', 'title' => 'STRN Issued', 'desc' => 'Certificate shared on dashboard'],
            ],
            'important_note' => 'STRN is required if your annual turnover exceeds PKR 8 million.',
            'sort_order'     => 5,
        ]);

        ServicePackage::insert([
            ['service_id' => $salesTax->id, 'name' => 'STRN Registration', 'price' => 8000, 'currency' => 'PKR', 'delivery_days' => 7, 'is_popular' => false, 'sort_order' => 1, 'features' => json_encode(['STRN Certificate', 'IRIS Setup', 'Filing Guide']), 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $salesTax->id, 'name' => 'STRN + Monthly Filing', 'price' => 15000, 'currency' => 'PKR', 'delivery_days' => 7, 'is_popular' => true, 'sort_order' => 2, 'features' => json_encode(['STRN Certificate', 'IRIS Setup', '3 Months Filing Included', 'Dedicated Manager']), 'created_at' => now(), 'updated_at' => now()],
        ]);

        $accounting = Service::create([
            'service_category_id' => $pkCat->id,
            'name'              => 'Accounting & CA Services',
            'slug'              => 'accounting-ca-services',
            'icon'              => '📚',
            'short_description' => 'Professional bookkeeping, financial statements, and audit services.',
            'what_you_get'      => ['Monthly Bookkeeping', 'Profit & Loss Statement', 'Balance Sheet', 'CA Certified Reports', 'Annual Audit'],
            'process_timeline'  => [
                ['day' => 'Monthly', 'title' => 'Data Collection', 'desc' => 'You share bank statements and invoices'],
                ['day' => 'Monthly', 'title' => 'Bookkeeping', 'desc' => 'Our team reconciles all transactions'],
                ['day' => 'Quarterly', 'title' => 'Reports Issued', 'desc' => 'Financial reports shared on dashboard'],
            ],
            'important_note' => 'All accounting is handled by qualified Chartered Accountants (ICAP members).',
            'sort_order'     => 6,
        ]);

        ServicePackage::insert([
            ['service_id' => $accounting->id, 'name' => 'Starter Bookkeeping', 'price' => 8000, 'currency' => 'PKR', 'delivery_days' => 30, 'is_popular' => false, 'sort_order' => 1, 'features' => json_encode(['Monthly Bookkeeping', 'P&L Statement', 'Up to 100 transactions']), 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $accounting->id, 'name' => 'Business Accounting', 'price' => 15000, 'currency' => 'PKR', 'delivery_days' => 30, 'is_popular' => true, 'sort_order' => 2, 'features' => json_encode(['Full Bookkeeping', 'P&L + Balance Sheet', 'Unlimited transactions', 'CA Certified', 'Quarterly Reports']), 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $accounting->id, 'name' => 'Annual Audit', 'price' => 35000, 'currency' => 'PKR', 'delivery_days' => 30, 'is_popular' => false, 'sort_order' => 3, 'features' => json_encode(['Full Year Audit', 'CA Audit Report', 'SECP Compliant', 'Statutory Filing']), 'created_at' => now(), 'updated_at' => now()],
        ]);

        // ────────────────────────────────────────────────────────
        // INTERNATIONAL SERVICES
        // ────────────────────────────────────────────────────────

        $usaLlc = Service::create([
            'service_category_id' => $intlCat->id,
            'name'              => 'USA LLC / INC Registration',
            'slug'              => 'usa-llc-registration',
            'icon'              => '🇺🇸',
            'badge'             => 'Popular',
            'short_description' => 'Register your US LLC or Corporation — receive EIN, bank account & Stripe.',
            'what_you_get'      => ['LLC/INC Articles of Organization', 'EIN (Employer Identification Number)', 'Operating Agreement', 'US Address (1 year)', 'Bank Account Opening Assistance', 'Stripe / PayPal Setup'],
            'process_timeline'  => [
                ['day' => 'Day 1', 'title' => 'State Selection & Filing', 'desc' => 'We file in your preferred state (Wyoming or Delaware recommended)'],
                ['day' => '3–7', 'title' => 'Articles Issued', 'desc' => 'LLC approval and articles received'],
                ['day' => '7–14', 'title' => 'EIN & Banking', 'desc' => 'EIN obtained and bank account opened'],
            ],
            'important_note' => 'Non-US residents can form US LLCs. Passport copy required. No US travel needed.',
            'sort_order'     => 1,
            'is_featured'    => true,
        ]);

        ServicePackage::insert([
            ['service_id' => $usaLlc->id, 'name' => 'LLC Basic', 'price' => 85000, 'currency' => 'PKR', 'delivery_days' => 14, 'is_popular' => false, 'sort_order' => 1, 'features' => json_encode(['LLC Registration', 'EIN Number', 'Articles of Organization']), 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $usaLlc->id, 'name' => 'LLC Complete', 'price' => 125000, 'currency' => 'PKR', 'delivery_days' => 21, 'is_popular' => true, 'sort_order' => 2, 'features' => json_encode(['LLC Registration', 'EIN Number', 'US Address 1yr', 'Bank Account', 'Stripe Setup', 'Dedicated Manager']), 'created_at' => now(), 'updated_at' => now()],
        ]);

        ServiceRequirement::insert([
            ['service_id' => $usaLlc->id, 'document_name' => 'Passport Copy', 'is_required' => true, 'sort_order' => 1, 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $usaLlc->id, 'document_name' => 'Preferred Company Name (3 options)', 'is_required' => true, 'sort_order' => 2, 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $usaLlc->id, 'document_name' => 'Nature of Business', 'is_required' => true, 'sort_order' => 3, 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $usaLlc->id, 'document_name' => 'Preferred State (Wyoming/Delaware/Other)', 'is_required' => false, 'sort_order' => 4, 'created_at' => now(), 'updated_at' => now()],
        ]);

        $ukCompany = Service::create([
            'service_category_id' => $intlCat->id,
            'name'              => 'UK Company Registration',
            'slug'              => 'uk-company-registration',
            'icon'              => '🇬🇧',
            'short_description' => 'Register your UK Limited Company with Companies House — bank & payment included.',
            'what_you_get'      => ['UK Ltd Registration', 'Companies House Number', 'UK Address (1 year)', 'Bank Account Assistance', 'Stripe UK Setup', 'VAT Registration (optional)'],
            'process_timeline'  => [
                ['day' => 'Day 1', 'title' => 'Application Filed', 'desc' => 'Filed with Companies House online'],
                ['day' => '1–3', 'title' => 'Certificate of Incorporation', 'desc' => 'UK Ltd company formed'],
                ['day' => '7–14', 'title' => 'Banking & Stripe', 'desc' => 'Bank account and payment setup'],
            ],
            'important_note' => 'UK company formation is one of the fastest in the world — usually within 24 hours of filing.',
            'sort_order'     => 2,
        ]);

        ServicePackage::insert([
            ['service_id' => $ukCompany->id, 'name' => 'UK Ltd Basic', 'price' => 65000, 'currency' => 'PKR', 'delivery_days' => 7, 'is_popular' => false, 'sort_order' => 1, 'features' => json_encode(['UK Ltd Registration', 'Companies House #', 'Certificate']), 'created_at' => now(), 'updated_at' => now()],
            ['service_id' => $ukCompany->id, 'name' => 'UK Ltd Complete', 'price' => 95000, 'currency' => 'PKR', 'delivery_days' => 14, 'is_popular' => true, 'sort_order' => 2, 'features' => json_encode(['UK Ltd Registration', 'UK Address 1yr', 'Bank Account', 'Stripe Setup', 'Dedicated Manager']), 'created_at' => now(), 'updated_at' => now()],
        ]);

        // ITIN
        Service::create([
            'service_category_id' => $intlCat->id,
            'name'              => 'ITIN (USA Tax Number)',
            'slug'              => 'itin-registration',
            'icon'              => '🔢',
            'short_description' => 'Get your Individual Taxpayer Identification Number for US tax purposes.',
            'what_you_get'      => ['ITIN Application Prepared', 'IRS Application Filed', 'ITIN Certificate', 'Full Support'],
            'process_timeline'  => [
                ['day' => 'Day 1', 'title' => 'Documents Verified', 'desc' => 'Passport and application prepared'],
                ['day' => '6–8 weeks', 'title' => 'IRS Processing', 'desc' => 'IRS processes the ITIN application'],
                ['day' => '8–10 weeks', 'title' => 'ITIN Issued', 'desc' => 'ITIN number received and shared'],
            ],
            'important_note' => 'ITIN processing by IRS takes 6–10 weeks. We provide certified application preparation.',
            'sort_order'     => 3,
        ]);

        // Consultation Slots
        ConsultationSlot::insert([
            ['name' => 'Quick Chat', 'duration_minutes' => 15, 'price' => 2000, 'currency' => 'PKR', 'description' => 'Perfect for quick questions and clarifications.', 'sort_order' => 1, 'created_at' => now(), 'updated_at' => now()],
            ['name' => 'Standard Session', 'duration_minutes' => 30, 'price' => 3500, 'currency' => 'PKR', 'description' => 'In-depth consultation for your business needs.', 'sort_order' => 2, 'created_at' => now(), 'updated_at' => now()],
            ['name' => 'Deep Dive', 'duration_minutes' => 60, 'price' => 6000, 'currency' => 'PKR', 'description' => 'Comprehensive session covering all your compliance needs.', 'sort_order' => 3, 'created_at' => now(), 'updated_at' => now()],
        ]);

        // Testimonials
        Testimonial::insert([
            ['name' => 'Usman Tariq', 'business' => 'E-Commerce Owner, Lahore', 'rating' => 5, 'content' => 'Texora registered my Pvt Ltd company in just 5 days. The dashboard made tracking super easy and their team was always responsive on WhatsApp.', 'sort_order' => 1, 'created_at' => now(), 'updated_at' => now()],
            ['name' => 'Sara Ahmed', 'business' => 'Freelancer / IT Consultant, Karachi', 'rating' => 5, 'content' => 'Got my NTN and filed my first tax return stress-free. The team explained everything clearly. Highly recommend for freelancers!', 'sort_order' => 2, 'created_at' => now(), 'updated_at' => now()],
            ['name' => 'Ali Hassan', 'business' => 'SaaS Founder, Islamabad', 'rating' => 5, 'content' => 'They set up my Wyoming LLC and Stripe account within 2 weeks. Now I can accept international payments. Life-changing for Pakistani founders.', 'sort_order' => 3, 'created_at' => now(), 'updated_at' => now()],
            ['name' => 'Maria Khan', 'business' => 'Digital Agency, Rawalpindi', 'rating' => 5, 'content' => 'Used Texora for trademark registration. Very professional team, great pricing, and they handled the IPO objection on our behalf.', 'sort_order' => 4, 'created_at' => now(), 'updated_at' => now()],
        ]);

        // Site Settings
        $settings = [
            ['key' => 'site_name', 'value' => 'Texora', 'group' => 'general'],
            ['key' => 'site_tagline', 'value' => 'All-in-One Compliance & Tax Platform', 'group' => 'general'],
            ['key' => 'site_email', 'value' => 'info@texora.pk', 'group' => 'general'],
            ['key' => 'site_phone', 'value' => '+92-311-1234567', 'group' => 'general'],
            ['key' => 'whatsapp_number', 'value' => '923111234567', 'group' => 'general'],
            ['key' => 'site_address', 'value' => 'Office 1, Business Bay, Karachi, Pakistan', 'group' => 'general'],
            ['key' => 'facebook_url', 'value' => 'https://facebook.com/texorapk', 'group' => 'social'],
            ['key' => 'instagram_url', 'value' => 'https://instagram.com/texorapk', 'group' => 'social'],
            ['key' => 'linkedin_url', 'value' => 'https://linkedin.com/company/texora', 'group' => 'social'],
            ['key' => 'hero_title', 'value' => 'Start, Manage & Grow Your Business — We Handle Everything', 'group' => 'homepage'],
            ['key' => 'hero_subtitle', 'value' => 'Company Registration | NTN | Tax Filing | Trademark | Global Company Setup', 'group' => 'homepage'],
            ['key' => 'stats_companies', 'value' => '2500+', 'group' => 'stats'],
            ['key' => 'stats_clients', 'value' => '5000+', 'group' => 'stats'],
            ['key' => 'stats_filings', 'value' => '10000+', 'group' => 'stats'],
            ['key' => 'stats_countries', 'value' => '15+', 'group' => 'stats'],
        ];

        foreach ($settings as $setting) {
            SiteSetting::create(array_merge($setting, ['created_at' => now(), 'updated_at' => now()]));
        }

        $this->command->info('✅ Texora database seeded successfully!');
        $this->command->info('   Admin: admin@texora.pk / password');
        $this->command->info('   Demo user: ahmed@demo.com / password');
    }
}
