1#@!#!123s

ALWAYS HENGHENG888 1#@!#!123s
: / var / www / cdcdhaka.org / database / seeders /
Filename : TaxonomySeeder.php
back
<?php

namespace Database\Seeders;

use App\Domains\Products\Models\Taxonomy;
use Database\Seeders\Traits\DisableForeignKeys;
use Database\Seeders\Traits\TruncateTable;
use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\Artisan;
use Illuminate\Support\Str;

class TaxonomySeeder extends Seeder
{
    use DisableForeignKeys, TruncateTable;


    public function insertTaxonomy(array $data, $parent_id = null, $type = null): Taxonomy
    {
        $id = rand(1, 999);
        $title = $data['name'];
        $taxonomy = new Taxonomy();
        $taxonomy->fill([
            'active' => now(),
            'name' => $title,
            'slug' => Str::slug($title),
            'banner' => "https://picsum.photos/seed/$id/300/300",
            'featured' => array_key_exists('featured', $data) ? $data['featured'] : null,
            'icon' => array_key_exists('icon', $data) ? $data['icon'] : null,
            'top' => array_key_exists('top', $data) ? $data['top'] : null,
            'meta_title' => array_key_exists('meta_title', $data) ? $data['meta_title'] : null,
            'meta_description' => array_key_exists('meta_description', $data) ? $data['meta_description'] : null,
            'parent_id' => $parent_id,
            'type' => $type,
            'user_id' => 1,
        ]);
        $taxonomy->save();

        return $taxonomy;
    }


    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $this->disableForeignKeys();
        Artisan::call('cache:clear');

        $this->truncateMultiple(['taxonomies']);

        $taxonomies = $this->initialCategories();

        foreach ($taxonomies as $taxonomy) {
            $parent1 = $this->insertTaxonomy($taxonomy);
            $children = $taxonomy['children'] ?? [];
            foreach ($children as $child) {
                $parent2 = $this->insertTaxonomy($child, $parent1->id, 'subcategory');
                $children2 = $child['children'] ?? [];
                foreach ($children2 as $child2) {
                    $this->insertTaxonomy($child2, $parent2->id, 'subsubcategory');
                }
            }
        }

        $this->enableForeignKeys();

        // php artisan db:seed --class='Database\Seeders\TaxonomySeeder'
    }


    public function initialCategories(): array
    {
        return [
            [
                'name' => 'Necessary Goods',
                'children' => [
                    [
                        'name' => 'Food Items',
                        'children' => [
                            ['name' => 'Polao Rice'],
                            ['name' => 'Mustard Oil'],
                            ['name' => 'Rich Barn Oil'],
                            ['name' => 'Soybean Oil'],
                            ['name' => 'Ghee'],
                            ['name' => 'Pure Cows Milk'],
                            ['name' => 'Butter(Matha)']
                        ],
                    ],
                    [
                        'name' => 'Clothing & Fashion',
                        'children' => [
                            ['name' => 'Tangail Sharee'],
                            ['name' => 'Panjabi'],
                            ['name' => 'T-Shirt'],
                            ['name' => 'Polo-Shirt'],
                            ['name' => 'Sports(Jersey)'],
                            ['name' => 'Leather Goods'],
                            ['name' => 'Fashion Watch'],
                            ['name' => 'Ladies Zones'],
                        ],
                    ],
                    [
                        'name' => 'Accommodations',
                        'children' => [
                            ['name' => 'Flat'],
                            ['name' => 'Plot'],
                            ['name' => 'Land']
                        ],
                    ],
                    [
                        'name' => 'Treatment & Services',
                        'children' => [
                            ['name' => 'Doctor'],
                            ['name' => 'Medicine'],
                            ['name' => 'Legal Advise'],
                            ['name' => 'Legal Consultancy'],
                            ['name' => 'Others'],
                        ],
                    ],
                    [
                        'name' => 'Educational Services',
                        'children' => [
                            ['name' => 'Books'],
                            ['name' => 'School & College Bag'],
                            ['name' => 'Admission Information']
                        ],
                    ],
                ]
            ],
            [
                'name' => 'Luxurious Goods',
                'children' => [
                    ['name' => 'Motor Cycle'],
                    ['name' => 'Private Car'],
                    ['name' => 'Gold'],
                    ['name' => 'Watch'],
                    [
                        'name' => 'Tours & Travel Service',
                        'children' => [
                            ['name' => 'Worldwide Tourist Visa'],
                            ['name' => 'Worldwide Air Tickets'],
                            ['name' => 'Worldwide Hotel Booking'],
                            ['name' => 'Worldwide Tour Activities'],
                            ['name' => 'Hajj & Umrah Package'],
                        ],
                    ]
                ],
            ],
            [
                'name' => 'Digital Marketing Service',
                'children' => [
                    ['name' => 'Corporate Project Profile'],
                    ['name' => 'Creative Design for Promotion'],
                    ['name' => 'Animation Vedio'],
                    ['name' => 'Motion Graphics'],
                    [
                        'name' => 'Social Media Promotion (Post Design)',
                        'children' => [
                            ['name' => 'Facebook'],
                            ['name' => 'Instagram'],
                            ['name' => 'Youtube'],
                            ['name' => 'LinkedIn'],
                            ['name' => 'Twitter'],
                        ],
                    ],
                    ['name' => 'Business Page Management and Boosting'],
                    ['name' => 'Online and Offline PR'],
                ],
            ],
            [
                'name' => 'IT Service',
                'children' => [
                    [
                        'name' => 'Software Development',
                        'children' => [
                            ['name' => 'Travel Portal'],
                            ['name' => 'Tour Package Management Software'],
                            ['name' => 'Visa Management Software'],
                            ['name' => 'Invitation Management Software'],
                            ['name' => 'Online News Portal'],
                            ['name' => 'Online Shop Portal/E-commerce Portal'],
                            ['name' => 'OYouTube Channel Portal'],
                        ],
                    ],
                    [
                        'name' => 'Apps',
                        'children' => [
                            ['name' => 'E-commerce Site'],
                        ],
                    ],
                    ['name' => 'Domain & Hosting'],
                    ['name' => 'Customize Website Design'],
                ],
            ],
            [
                'name' => 'Construction Goods',
                'children' => [
                    ['name' => 'Bricks'],
                    [
                        'name' => 'Sands',
                        'children' => [
                            ['name' => 'Darzer Sands'],
                            ['name' => 'Boat Sands'],
                            ['name' => 'Selection Sands 2.5'],
                        ],
                    ],
                    [
                        'name' => 'Cement',
                        'children' => [
                            ['name' => 'Insee'],
                        ],
                    ],
                    [
                        'name' => 'Stone',
                        'children' => [
                            ['name' => 'Indian Black Stone'],
                        ],
                    ]
                ],
            ],
            [
                'name' => 'Imported Goods',
                'children' => [
                    ['name' => 'Poly Carbonate (PC)'],
                    ['name' => 'Calcium Carbonate (CC)'],
                    ['name' => 'Aluminum Sheet'],
                    ['name' => 'PBT'],
                    ['name' => 'Empty Capsule'],
                    ['name' => 'Polyamide(PA)'],
                    ['name' => 'Ethyl Alcohol'],
                    ['name' => 'Limestone'],
                    ['name' => 'Capacitor'],
                    ['name' => 'Switch Socket'],
                    ['name' => 'LED BULB'],
                    ['name' => 'PVC Compound'],
                    ['name' => 'Aluminum FOIL'],
                    ['name' => 'Glass Bottle'],
                ],
            ],
            [
                'name' => 'Luxurious Goods',
                'children' => [
                    ['name' => 'Motor Cycle'],
                    ['name' => 'Private Car'],
                    ['name' => 'Gold'],
                    ['name' => 'Watch'],
                    [
                        'name' => 'Tours & Travel Service',
                        'children' => [
                            ['name' => 'Worldwide Tourist Visa'],
                            ['name' => 'Worldwide Air Tickets'],
                            ['name' => 'Worldwide Hotel Booking'],
                            ['name' => 'Worldwide Tour Activities'],
                            ['name' => 'Hajj & Umrah Package'],
                        ],
                    ]
                ],
            ],
            [
                'name' => 'Digital Marketing Service',
                'children' => [
                    ['name' => 'Corporate Project Profile'],
                    ['name' => 'Creative Design for Promotion'],
                    ['name' => 'Animation Vedio'],
                    ['name' => 'Motion Graphics'],
                    [
                        'name' => 'Social Media Promotion (Post Design)',
                        'children' => [
                            ['name' => 'Facebook'],
                            ['name' => 'Instagram'],
                            ['name' => 'Youtube'],
                            ['name' => 'LinkedIn'],
                            ['name' => 'Twitter'],
                        ],
                    ],
                    ['name' => 'Business Page Management and Boosting'],
                    ['name' => 'Online and Offline PR'],
                ],
            ],
            [
                'name' => 'IT Service',
                'children' => [
                    [
                        'name' => 'Software Development',
                        'children' => [
                            ['name' => 'Travel Portal'],
                            ['name' => 'Tour Package Management Software'],
                            ['name' => 'Visa Management Software'],
                            ['name' => 'Invitation Management Software'],
                            ['name' => 'Online News Portal'],
                            ['name' => 'Online Shop Portal/E-commerce Portal'],
                            ['name' => 'OYouTube Channel Portal'],
                        ],
                    ],
                    [
                        'name' => 'Apps',
                        'children' => [
                            ['name' => 'E-commerce Site'],
                        ],
                    ],
                    ['name' => 'Domain & Hosting'],
                    ['name' => 'Customize Website Design'],
                ],
            ],
            [
                'name' => 'Construction Goods',
                'children' => [
                    ['name' => 'Bricks'],
                    [
                        'name' => 'Sands',
                        'children' => [
                            ['name' => 'Darzer Sands'],
                            ['name' => 'Boat Sands'],
                            ['name' => 'Selection Sands 2.5'],
                        ],
                    ],
                    [
                        'name' => 'Cement',
                        'children' => [
                            ['name' => 'Insee'],
                        ],
                    ],
                    [
                        'name' => 'Stone',
                        'children' => [
                            ['name' => 'Indian Black Stone'],
                        ],
                    ]
                ],
            ],
            [
                'name' => 'Imported Goods',
                'children' => [
                    ['name' => 'Poly Carbonate (PC)'],
                    ['name' => 'Calcium Carbonate (CC)'],
                    ['name' => 'Aluminum Sheet'],
                    ['name' => 'PBT'],
                    ['name' => 'Empty Capsule'],
                    ['name' => 'Polyamide(PA)'],
                    ['name' => 'Ethyl Alcohol'],
                    ['name' => 'Limestone'],
                    ['name' => 'Capacitor'],
                    ['name' => 'Switch Socket'],
                    ['name' => 'LED BULB'],
                    ['name' => 'PVC Compound'],
                    ['name' => 'Aluminum FOIL'],
                    ['name' => 'Glass Bottle'],
                ],
            ],
        ];
    }
}