<?php

use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;

class AddUtilRelationSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $excepts = [
            "customers",
            "customer_addresses",
            "service_categories",
            "city_branches",
            "provinces",
            "cities",
            "subdistricts",
            "subdistrict_areas",
            "menus",
            "roles",
            "role_acesses",
            "user",
            "user_roles",
            "customer_phones",
            "filter_invoices"
        ];

        $tables = DB::select('SHOW TABLES');

        foreach ($tables as $obj) {
            foreach ($obj as $table) {
                if (!in_array($table, $excepts)) {
                    if ($table !== "site_projects") {
                        try {
                            DB::statement("
                                ALTER TABLE `$table` ADD `site_project_id` BIGINT UNSIGNED NULL;
                            ");
                        } catch (Exception $e) {
                        }

                        try {
                            DB::statement("
                                ALTER TABLE `$table` ADD CONSTRAINT `fk_site_project_$table`
                                FOREIGN KEY (`site_project_id`) REFERENCES `site_projects`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
                            ");
                        } catch (Exception $e) {
                        }
                    }

                    if ($table !== "city_branches") {
                        try {
                            DB::statement("
                                ALTER TABLE `$table` ADD `city_branch_id` BIGINT UNSIGNED NULL;
                            ");
                        } catch (Exception $e) {
                        }

                        try {
                            DB::statement("
                                ALTER TABLE `$table` ADD CONSTRAINT `fk_city_branch_$table`
                                FOREIGN KEY (`city_branch_id`) REFERENCES `city_branches`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
                            ");
                        } catch (Exception $e) {
                        }
                    }

                    try {
                        DB::statement("
                            ALTER TABLE `$table` ADD `service_category_id` BIGINT UNSIGNED NULL;
                        ");
                    } catch (Exception $e) {
                    }

                    try {
                        DB::statement("
                            ALTER TABLE `$table` ADD CONSTRAINT `fk_service_category_$table`
                            FOREIGN KEY (`service_category_id`) REFERENCES `service_categories`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
                        ");
                    } catch (Exception $e) {
                    }
                }
            }
        }

        $this->call(AddCreatedByColumn::class);
    }
}