<?php
use App\Models\Campaigns;
use App\Models\Countries;
use App\Models\Registrations;
use App\Models\Sources;
use App\Models\Spinthewheelwinners;
use App\Modules\Models\Registration\Registration;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;
use Intervention\Image\Facades\Image;
use Endroid\QrCode\Color\Color;
use Endroid\QrCode\Encoding\Encoding;
use Endroid\QrCode\ErrorCorrectionLevel\ErrorCorrectionLevelLow;
use Endroid\QrCode\QrCode;
use Endroid\QrCode\Label\Label;
use Endroid\QrCode\Logo\Logo;
use Endroid\QrCode\RoundBlockSizeMode\RoundBlockSizeModeMargin;
use Endroid\QrCode\Writer\PngWriter;
use Endroid\QrCode\Writer\ValidationException;
use Illuminate\Database\Schema\Blueprint;
use Revolution\Google\Sheets\Facades\Sheets;
class LMS
{
    public function __construct()
    {
        $this->initDB();
    }
    public static function spinwheelwinners()
    {
        $winners = DB::table("spinthewheelwinners")
            // ->where('status', 1)
            ->orderBy('created_at', "desc")
            ->get();
        foreach ($winners as $winner) {
            $registration = DB::table("registrations")
                ->where('status', 1)
                ->where('registration_id', $winner->registrations_id)
                ->first();
            $winner->Winner = $registration;
        }
        // dd($winners);
        return $winners;
    }
    public static function savespinwheelwinner($registration_id, $prize)
    {
        // Fetch registration data based on registration_id
        $data = DB::table("registrations")
            ->where('status', 1)
            ->where('registration_id', $registration_id)
            ->first();
        if ($data) {
            // Create a new spin wheel winner record
            Spinthewheelwinners::create([
                'title' => $data->name,
                'registrations_id' => $data->registration_id,
                'prize' => $prize
            ]);
            // Return the updated list of winners ordered by created_on in descending order
            return Spinthewheelwinners::orderBy("created_at", "desc")->get();
        } else {
            // Handle the case when no registration data is found
            return response()->json(['error' => 'Registration not found'], 404);
        }
    }
    public static function checkRegistrationByMobile($mobile)
    {
        $registration = DB::table("registrations")
            ->where('status', 1)
            ->where('mobile', $mobile)
            ->orderBy('display_order')
            ->first();
        if (!$registration) {
            // Handle the case where the registration is not found
            return;
        }
        return $registration;
    }
    public static function getLeadQR($registration_id)
    {
        $registration = DB::table("registrations")
            ->where('status', 1)
            ->where('registration_id', $registration_id)
            ->orderBy('display_order')
            ->first();
        if (!$registration) {
            // Handle the case where the registration is not found
            return;
        }
        $Campaign = Campaigns::findOrFail($registration->campaigns_id);
        $QRURL = route("registration.view", md5($registration_id));
        $writer = new PngWriter();
        $qrCode = QrCode::create($QRURL)
            ->setEncoding(new Encoding('UTF-8'))
            ->setErrorCorrectionLevel(new ErrorCorrectionLevelLow())
            ->setSize(230)
            ->setMargin(1)
            ->setRoundBlockSizeMode(new RoundBlockSizeModeMargin())
            ->setForegroundColor(new Color(0, 0, 0))
            ->setBackgroundColor(new Color(255, 255, 255));
        $result = $writer->write($qrCode);
        $dataUri = $result->getDataUri();
        if ($Campaign->pass_layout != "") {
            $pass_layout = storage_path(str_replace("storage/", "app/public/", $Campaign->pass_layout));
            $backgroundImage = Image::make($pass_layout);
        } else {
            $backgroundImage = Image::make(public_path(env("CLIENT_PATH") . '/assets/images/pass.png'));
        }
        $qrCodeImage = Image::make($dataUri);
        $qrCodePosition = ($Campaign->qr_position != "") ? $Campaign->qr_position : "100,100";
        $qrCodePosition = explode(",", $qrCodePosition);
        $backgroundImage->insert($qrCodeImage, 'top-left', $qrCodePosition[0], $qrCodePosition[1]);
        $text = $registration->registration_id;
        $idPosition = ($Campaign->id_position != "") ? $Campaign->id_position : "100,100";
        $idPosition = explode(",", $idPosition);
        $fontPath = public_path('assets/fonts/Poppins-Regular.ttf'); // Replace with the actual font path
        $backgroundImage->text($text, $idPosition[0], $idPosition[1], function ($font) use ($fontPath) {
            $font->file($fontPath);
            $font->size(28);
            $font->color('#000000');
            $font->align('left');
            $font->valign('top');
        });
        $text = $registration->name;
        $namePosition = ($Campaign->name_position != "") ? $Campaign->name_position : "100,100";
        $namePosition = explode(",", $namePosition);
        $fontPath = public_path('assets/fonts/Poppins-Regular.ttf'); // Replace with the actual font path
        $backgroundImage->text($text, $namePosition[0], $namePosition[1], function ($font) use ($fontPath) {
            $font->file($fontPath);
            $font->size(28);
            $font->color('#000000');
            $font->align('left');
            $font->valign('top');
        });
        $text = $registration->email;
        $emailPosition = ($Campaign->email_position != "") ? $Campaign->email_position : "100,100";
        $emailPosition = explode(",", $emailPosition);
        $fontPath = public_path('assets/fonts/Poppins-Regular.ttf'); // Replace with the actual font path
        $backgroundImage->text($text, $emailPosition[0], $emailPosition[1], function ($font) use ($fontPath) {
            $font->file($fontPath);
            $font->size(24);
            $font->color('#000000');
            $font->align('left');
            $font->valign('top');
        });
        $text = $registration->mobile;
        $xCoordinateText = 960; // Set the X coordinate for the text
        $yCoordinateText = 365; // Set the Y coordinate for the text
        $fontPath = public_path('assets/fonts/Poppins-Regular.ttf'); // Replace with the actual font path
        $backgroundImage->text($text, $xCoordinateText, $yCoordinateText, function ($font) use ($fontPath) {
            $font->file($fontPath);
            $font->size(24);
            $font->color('#000000');
            $font->align('left');
            $font->valign('top');
        });
        $text = $registration->intrested_for_country;
        $xCoordinateText = 960; // Set the X coordinate for the text
        $yCoordinateText = 430; // Set the Y coordinate for the text
        $fontPath = public_path('assets/fonts/Poppins-Regular.ttf'); // Replace with the actual font path
        $backgroundImage->text($text, $xCoordinateText, $yCoordinateText, function ($font) use ($fontPath) {
            $font->file($fontPath);
            $font->size(24);
            $font->color('#000000');
            $font->align('left');
            $font->valign('top');
        });
        // Save the combined image
        $outputPath = public_path(env("CLIENT_PATH") . '/assets/images/generated/pass_' . date("ymdhis") . '_image.png');
        $backgroundImage->save($outputPath);
        // Remove the temporary QR code image
        // unlink($qrCodePath);
        // You can return the output path or perform any other desired actions
        return $outputPath;
    }
    public static function sendSMSWithCurl($destination, $message)
    {
        $userName = (SITEVARS->sms_username) ? SITEVARS->sms_username : '';
        $password = (SITEVARS->sms_password) ? SITEVARS->sms_password : '';
        $sender = (SITEVARS->sms_sender) ? SITEVARS->sms_sender : '';
        $url = (SITEVARS->sms_api) ? SITEVARS->sms_api : 'http://api.ininepal.com/api/index?';
        // URL-encode the message and destination
        $encodedMessage = urlencode($message);
        $encodedDestination = urlencode($destination);
        // Construct the URL query string
        $url_query = "username={$userName}&password={$password}&message={$encodedMessage}&destination={$encodedDestination}&sender={$sender}";
        // Build the final URL
        $url_final = $url . $url_query;
        // Initialize cURL session
        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, $url_final);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        // Execute the cURL request
        $response = curl_exec($ch);
        // Check for errors and handle the response
        if ($response === false) {
            // cURL request failed, handle the error as needed
            // You can log the error or throw an exception
            return false;
        } else {
            // Check the response for success or failure
            if ($response === '1') {
                // SMS sent successfully
                return true;
            } else {
                // SMS sending failed, handle the error as needed
                // You can log the error or throw an exception
                return false;
            }
        }
        // Close the cURL session
        curl_close($ch);
    }
    public static function SaveInGoogleSheet($data)
    {
        $Campaign = Campaigns::findorfail($data['campaigns_id']);
        // $spreadsheetId = ($Campaign->google_sheet_id != "") ? $Campaign->google_sheet_id : '1g0lR_98d_10P1rDUcWMz3b0eCW1bmDFxBpgZAxCDTF4';        
        // $sheetName = ($Campaign->google_sheet_worksheet != "") ? $Campaign->google_sheet_worksheet : 'OfficeVisits';
        $spreadsheetId = ($Campaign->google_sheet_id != "") ? $Campaign->google_sheet_id : '1uwd3MiLpp_qf7kYGU3CkxO3bXrLpzrhdusNsjZueWB4';
        $sheetName = ($Campaign->google_sheet_worksheet != "") ? $Campaign->google_sheet_worksheet : 'Sheet1';
        $rows = Sheets::spreadsheet($spreadsheetId)->sheet($sheetName)->all();
        $lastRowIndex = count($rows);
        $newRowIndex = $lastRowIndex + 1;
        /* TO DUMP ALL ROWS
        $rowData = ['sn' => $lastRowIndex];
        $a=0;
        foreach ($data as $index => $value) {
            $columnName = 'col'.$a;// . ($index + 1);
            $a++;
            $rowData[$columnName] = $value;
        }
        Sheets::spreadsheet($spreadsheetId)->sheet($sheetName)->range('A' . $newRowIndex)->append([$rowData]);
        */
        Sheets::spreadsheet($spreadsheetId)->sheet($sheetName)->range('A' . $newRowIndex)->append([[
            'sn' => $lastRowIndex,
            'name' => $data['name'],
            'email' => $data['email'],
            'phone' => $data['mobile'],
            'qualification' => isset($data['highest_qualification']) ? $data['highest_qualification'] : "0",
            'passed_year' => '',
            'interested_for' => isset($data['preferred_destination']) ? $data['preferred_destination'] : "0",
            'user_source' => env('CLIENT_PATH'),
        ]]);
    }
    //CONSULTANCY RELATED TEMP FUNCTIONS
    public static function createMenuLink($text, $URL)
    {
        $isActive = request()->fullUrl() == $URL;
        $activeClass = $isActive ? 'active' : '';
?>
        <li>
            <a class="nav-link menu-link <?php echo $activeClass; ?>" href="<?php echo $URL; ?>"><i class="ri-file-text-line "></i> <span data-key="t-landing"><?php echo $text; ?></span></a>
        </li>
<?php
    }
    public static  function getCampaigns()
    {
        $Rows = DB::table("campaigns")->where("status", 1)->orderBy("display_order")->get();
        return $Rows;
    }
    public static  function getCampaignByAlias($alias)
    {
        $Rows = DB::table("campaigns")->where("status", 1)->where("alias", $alias)->first();
        return $Rows;
    }
    public static  function getActiveCampaign()
    {
        $Rows = DB::table("campaigns")->where("status", 1)->orderBy("display_order")->first();
        return $Rows;
    }
    public static  function campaignsCount()
    {
        $Rows = DB::table("campaigns")->where("status", 1)->count();
        return $Rows;
    }
    public static  function getLeadCategories()
    {
        $Rows = DB::table("leadcategories")->where("status", 1)->orderBy("display_order")->get();
        return $Rows;
    }
    public static  function getSources()
    {
        $Rows = DB::table("sources")->where("status", 1)->orderBy("display_order")->get();
        return $Rows;
    }
    public static  function getQualifications()
    {
        $Rows = DB::table("qualifications")->where("status", 1)->orderBy("display_order")->get();
        return $Rows;
    }
    public static function getSiteVars()
    {
        $siteVars = DB::table("settings")->where('status', 1)->orderby('display_order')->first();
        $siteVars->Countries = self::getCountries();
        $siteVars->Campaigns = self::getCampaigns();
        return $siteVars;
    }
    public static function leadsCount($group = null, $id = null)
    {
        $query = DB::table("registrations")->where('status', 1);
        // Apply additional conditions using a switch-case statement
        switch ($group) {
            case 'campaign':
                if ($id !== null) {
                    $query->where('campaigns_id', $id);
                }
                break;
            case 'source':
                if ($id !== null) {
                    $query->where('sources_id', $id);
                }
                break;
            case 'country':
                if ($id !== null) {
                    $query->where('countries_id', $id);
                }
                break;
            case 'category':
                if ($id !== null) {
                    $query->where('leadcategories_id', $id);
                }
                break;
            case 'agent':
                if ($id !== null) {
                    $query->where('agents_id', $id);
                }
                break;
                // Add more cases as needed
        }
        $count = $query->count();
        return $count;
    }
    public static function studentsCount($group = null, $id = null)
    {
        $query = DB::table("students")->where('status', 1);
        // Apply additional conditions using a switch-case statement
        switch ($group) {
            case 'campaign':
                if ($id !== null) {
                    $query->where('campaigns_id', $id);
                }
                break;
            case 'source':
                if ($id !== null) {
                    $query->where('sources_id', $id);
                }
                break;
            case 'country':
                if ($id !== null) {
                    $query->where('countries_id', $id);
                }
                break;
            case 'category':
                if ($id !== null) {
                    $query->where('leadcategories_id', $id);
                }
                break;
            case 'agent':
                if ($id !== null) {
                    $query->where('agents_id', $id);
                }
                break;
                // Add more cases as needed
        }
        $count = $query->count();
        return $count;
    }
    public static function countriesCount()
    {
        $Rows = DB::table("countries")->where('status', 1)->count();
        return $Rows;
    }
    public static function getCountries()
    {
        $Rows = DB::table("countries")->where('status', 1)->orderby('display_order')->get();
        return $Rows;
    }
    public static function getAgents()
    {
        $Rows = DB::table("agents")->where('status', 1)->orderby('display_order')->get();
        return $Rows;
    }
    public static function getLeads($limit = null)
    {
        $Rows = DB::table("registrations")->where('status', 1)->orderByDesc('display_order');
        if ($limit) {
            $Rows = $Rows->limit($limit);
        }
        $Rows = $Rows->get();
        foreach ($Rows as $Row) {
            $Row->countries_id = ($Row->countries_id != 0) ? $Row->countries_id : 1;
            $Row->sources_id = ($Row->sources_id != 0) ? $Row->sources_id : 1;
            $Row->Source = Sources::findorfail($Row->sources_id);
            $Row->Country = Countries::findorfail($Row->countries_id);
        }
        return $Rows;
    }
    public static function getCampaignArticlesByCampaignAlias($alias)
    {
        $subquery = DB::table('campaigns')->select('campaign_id')->where('alias', $alias)->where("status", 1);
        $articles = DB::table('campaignarticles')->where('parent_article', 0)->whereIn('campaigns_id', $subquery)->get();
        foreach ($articles as $article) {
            $article->ChildArticles = DB::table('campaignarticles')->where('parent_article', $article->campaignarticle_id)->where("status", 1)->get();
        }
        return $articles;
    }
    public static function getCountry($alias)
    {
        $Countries = DB::table("countries")->where('alias', $alias)->get();
        return $Countries[0];
    }
    public static function showForm($formID)
    {
        if (is_numeric($formID)) {
            $Form = DB::table("forms")->where('form_id', $formID)->first();
        } else {
            $Form = DB::table("forms")->where('alias', $formID)->first();
        }
        if (!$Form) {
            // Handle the case where the form with the given ID/alias doesn't exist
            return "Error: Form (ID/Alias: $formID) not found.";
        }
        $csrfToken = csrf_token();
        if (session('success')) {
            echo '<div class="alert alert-success" role="alert">';
            echo session('success');
            echo '</div>';
        }
        echo '<form class="mt-5" action="' . route("form.submit") . '" method="POST">';
        echo '<input type="hidden" name="_token" value="' . $csrfToken . '">';
        echo '<input type="hidden" name="form_id" value="' . $Form->form_id . '">';
        $form_fields = json_decode($Form->form_fields);
        foreach ($form_fields as $field) {
            $fieldAlias = strtolower($field->fieldAlias);
            $fieldName = strtolower($field->fieldName);
            $fieldType = $field->fieldType;
            $fieldDefault = $field->fieldDefault;
            $fieldCss = $field->fieldCss;
            echo '<div class="mb-3 ' . $fieldCss . '">';
            echo '<label for="' . $fieldAlias . '" class="form-label">' . ucfirst($fieldName) . '</label>';
            // Check if the "required" class is present in $fieldCss and add the required attribute
            $isRequired = strpos($fieldCss, 'required') !== false;
            if ($fieldType === 'textarea') {
                echo '<textarea class="form-control ' . ($isRequired ? 'required' : '') . '" id="' . $fieldAlias . '" name="' . $fieldAlias . '" ' . ($isRequired ? 'required' : '') . '>' . $fieldDefault . '</textarea>';
            } else {
                echo '<input type="' . $fieldType . '" class="form-control ' . ($isRequired ? 'required' : '') . '" id="' . $fieldAlias . '" name="' . $fieldAlias . '" value="' . $fieldDefault . '" ' . ($isRequired ? 'required' : '') . '>';
            }
            echo '</div>';
        }
        echo '<button type="submit" class="btn btn-primary">Submit</button>';
        echo '</form>';
    }
    private function initDB()
    {
        static $initialized = false;
        if (!$initialized) {
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_qualifications` (
                `qualification_id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                `title` VARCHAR(255),
                `alias` VARCHAR(255),
                `description` TEXT,
                `display_order` INT(11),
                `status` INT(11),
                `remarks` TEXT,
                `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP,
                `createdby` INT(11),
                `updated_at` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                `updatedby` INT(11)
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_leadcategories` (
                `leadcategory_id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                `title` VARCHAR(255),
                `alias` VARCHAR(255),
                `description` TEXT,
                `color` VARCHAR(255),
                `display_order` INT(11),
                `status` INT(11),
                `remarks` TEXT,
                `created_at` DATETIME DEFAULT NOW(),
                `createdby` INT(11),
                `updated_at` DATETIME DEFAULT NOW(),
                `updatedby` INT(11)
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_institutiontypes` (
                `institutiontype_id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                `title` VARCHAR(255),
                `alias` VARCHAR(255),
                `description` TEXT,
                `display_order` INT(11),
                `status` INT(11),
                `remarks` TEXT,
                `created_at` DATETIME DEFAULT NOW(),
                `createdby` INT(11),
                `updated_at` DATETIME DEFAULT NOW(),
                `updatedby` INT(11)
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_institutions` (
                `institution_id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                `institutiontypes_id` INT(11),
                `countries_id` INT(11),
                `title` VARCHAR(255),
                `alias` VARCHAR(255),
                `description` TEXT,
                `state` VARCHAR(255),
                `city` VARCHAR(255),
                `address` TEXT,
                `contact` VARCHAR(255),
                `logo` VARCHAR(255),
                `thumb` VARCHAR(255),
                `display_order` INT(11),
                `status` INT(11),
                `remarks` TEXT,
                `created_at` DATETIME DEFAULT NOW(),
                `createdby` INT(11),
                `updated_at` DATETIME DEFAULT NOW(),
                `updatedby` INT(11)
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_programs` (
                `program_id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                `institutions_id` INT(11),
                `title` VARCHAR(255),
                `alias` VARCHAR(255),
                `description` TEXT,
                `program_level` VARCHAR(255),
                `years` VARCHAR(255),
                `psw` VARCHAR(255),
                `prospects` TEXT,
                `intake` VARCHAR(255),
                `institution` VARCHAR(255),
                `city` VARCHAR(255),
                `application_open` VARCHAR(255),
                `application_deadline` VARCHAR(255),
                `level` VARCHAR(255),
                `min_level` VARCHAR(255),
                `min_level_faculty` VARCHAR(255),
                `min_level_score` VARCHAR(255),
                `min_level_passout` VARCHAR(255),
                `min_level_optional_requirement` VARCHAR(255),
                `prof_test_required` INT(11),
                `prof_test_accepted` VARCHAR(255),
                `prof_test_min_score` VARCHAR(255),
                `prof_test_band_score` VARCHAR(255),
                `display_order` INT(11),
                `status` INT(11),
                `remarks` TEXT,
                `created_at` DATETIME DEFAULT NOW(),
                `createdby` INT(11),
                `updated_at` DATETIME DEFAULT NOW(),
                `updatedby` INT(11)
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_agents` (
                `agent_id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                `title` VARCHAR(255),
                `alias` VARCHAR(255),
                `description` TEXT,
                `display_order` INT(11),
                `status` INT(11),
                `remarks` TEXT,
                `created_at` DATETIME DEFAULT NOW(),
                `createdby` INT(11),
                `updated_at` DATETIME DEFAULT NOW(),
                `updatedby` INT(11)
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_cities` (
                `city_id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                `districts_id` INT(11),
                `title` VARCHAR(255),
                `alias` VARCHAR(255),
                `description` TEXT,
                `display_order` INT(11),
                `status` INT(11),
                `remarks` TEXT,
                `created_at` DATETIME DEFAULT NOW(),
                `createdby` INT(11),
                `updated_at` DATETIME DEFAULT NOW(),
                `updatedby` INT(11)
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_districts` (
                `district_id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                `provinces_id` INT(11),
                `title` VARCHAR(255),
                `alias` VARCHAR(255),
                `description` TEXT,
                `display_order` INT(11),
                `status` INT(11),
                `remarks` TEXT,
                `created_at` DATETIME DEFAULT NOW(),
                `createdby` INT(11),
                `updated_at` DATETIME DEFAULT NOW(),
                `updatedby` INT(11)
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_provinces` (
                `province_id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                `title` VARCHAR(255),
                `alias` VARCHAR(255),
                `description` TEXT,
                `display_order` INT(11),
                `status` INT(11),
                `remarks` TEXT,
                `created_at` DATETIME,
                `createdby` INT(11),
                `updated_at` DATETIME,
                `updatedby` INT(11)
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_countries` (
                `country_id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                `title` VARCHAR(255),
                `alias` VARCHAR(255),
                `description` TEXT,
                `display_order` INT(11),
                `status` INT(11),
                `remarks` TEXT,
                `created_at` DATETIME,
                `createdby` INT(11),
                `updated_at` DATETIME,
                `updatedby` INT(11)
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_branches` (
                `branch_id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                `title` VARCHAR(255),
                `alias` VARCHAR(255),
                `description` TEXT,
                `email` VARCHAR(255),
                `telephone` VARCHAR(255),
                `phone1` VARCHAR(255),
                `phone2` VARCHAR(255),
                `address` VARCHAR(255),
                `company_reg` VARCHAR(255),
                `is_main` INT(11) NULL Default 0,
                `display_order` INT(11),
                `status` INT(11),
                `remarks` TEXT,
                `created_at` DATETIME,
                `createdby` INT(11),
                `updated_at` DATETIME,
                `updatedby` INT(11)
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_campaigns` (
                `campaign_id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                `title` VARCHAR(255),
                `alias` VARCHAR(255),
                `description` TEXT,
                `details` TEXT,
                `cover_photo` VARCHAR(255),
                `thumb` VARCHAR(255),
                `starts` DATE,
                `ends` DATE,
                `success_message` VARCHAR(255),
                `sms_message` VARCHAR(255),
                `coupon_codes` TEXT,
                `offered_choices` TEXT,
                `pass_layout` VARCHAR(255),
                `qr_position` VARCHAR(255),
                `id_position` VARCHAR(255),
                `name_position` VARCHAR(255),
                `email_position` VARCHAR(255),
                `notify_emails` TEXT,
                `google_sheet_id` VARCHAR(255),
                `google_sheet_worksheet` VARCHAR(255),
                `is_active` int(11),
                `og_image` VARCHAR(255),
                `seo_title` VARCHAR(255),
                `seo_keywords` VARCHAR(255),
                `seo_description` TEXT,
                `meta_tags` TEXT,
                `display_order` INT(11),
                `status` INT(11),
                `remarks` TEXT,
                `created_at` DATETIME DEFAULT NOW(),
                `createdby` INT(11),
                `updated_at` DATETIME DEFAULT NOW(),
                `updatedby` INT(11)
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;                            
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_operation_logs` (
                `operation_id` bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                `refNo` varchar(255) DEFAULT NULL,
                `user_id` int(11) DEFAULT NULL,
                `operation_start_no` bigint(20) DEFAULT NULL,
                `operation_end_no` bigint(20) DEFAULT NULL,
                `model_name` varchar(100) DEFAULT NULL,
                `model_id` int(11) DEFAULT NULL,
                `operation_name` varchar(100) DEFAULT NULL,
                `previous_values` text DEFAULT NULL,
                `new_values` longtext DEFAULT NULL,
                `created_at` timestamp NULL DEFAULT NULL,
                `updated_at` timestamp NULL DEFAULT NULL
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_error_logs` (
                `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
                `user_id` bigint(20) UNSIGNED DEFAULT NULL,
                `controller_name` varchar(255) DEFAULT NULL,
                `method_name` varchar(255) DEFAULT NULL,
                `errors` longTEXT NULL,
                `created_at` timestamp NULL DEFAULT NULL,
                `updated_at` timestamp NULL DEFAULT NULL
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_activity_logs` (
                `activity_id` bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                `user_id` int(11) DEFAULT NULL,
                `controllerName` varchar(100) DEFAULT NULL,
                `methodName` varchar(100) DEFAULT NULL,
                `actionUrl` varchar(255) DEFAULT NULL,
                `activity` varchar(255) DEFAULT NULL,
                `created_at` timestamp NULL DEFAULT NULL,
                `updated_at` timestamp NULL DEFAULT NULL
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_users` (
                `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
                `name` varchar(255) NULL,
                `email` varchar(255) NULL,
                `username` varchar(255) NULL,
                `email_verified_at` timestamp NULL DEFAULT NULL,
                `password` varchar(255) NULL,
                `remember_token` varchar(100) DEFAULT NULL,
                `display_order` INT(11) DEFAULT 1,
                `role` varchar(255),
                `status` INT(11) DEFAULT 1,
                `created_at` timestamp NULL DEFAULT NULL,
                `createdby` INT(11),
                `updated_at` timestamp NULL DEFAULT NULL,
                `updatedby` INT(11)
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_settings` (
                `setting_id` int(11) NOT NULL  AUTO_INCREMENT PRIMARY KEY,
                `title` varchar(255) NULL,
                `description` TEXT NULL,
                `url1` varchar(255) NULL,
                `url2` varchar(255) NULL,
                `email` varchar(255) NULL,
                `phone` varchar(255) NULL,
                `secondary_phone` varchar(255) NULL,
                `google_map` TEXT NULL,
                `fb` varchar(255) NULL,
                `insta` varchar(255) NULL,
                `twitter` varchar(255) NULL,
                `tiktok` varchar(255) NULL,
                `primary_logo` varchar(255) NULL,
                `secondary_logo` varchar(255) NULL,
                `thumb` varchar(255) NULL,
                `icon` varchar(255) NULL,
                `og_image` varchar(255) NULL,
                `no_image` varchar(250) NULL,
                `copyright_text` varchar(250) NULL,
                `content1` TEXT NULL,
                `content2` TEXT NULL,
                `content3` TEXT NULL,
                `seo_title` varchar(255) NULL,
                `seo_description` TEXT NULL,
                `seo_keywords` TEXT NULL,
                `og_tags` TEXT NULL,
                `display_order` int(11) NULL DEFAULT 0,
                `status` int(11) NULL DEFAULT 0,
                `created_at` timestamp NULL DEFAULT NULL,
                `updated_at` timestamp NULL DEFAULT NULL,
                `createdby` int(11) DEFAULT NULL,
                `updatedby` int(11) DEFAULT NULL
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_articles` (
                `article_id` int(11) NOT NULL  AUTO_INCREMENT PRIMARY KEY,
                `parent_article` int(11) DEFAULT 0,
                `title` varchar(250) NULL,
                `alias` varchar(250) NULL,
                `text` TEXT NULL,
                `cover_photo` varchar(500) NOT NULL,
                `thumb` varchar(255) NULL,
                `display_order` int(11) NULL DEFAULT 0,
                `status` int(11) NULL DEFAULT 0,
                `created_at` timestamp NULL DEFAULT NULL,
                `updated_at` timestamp NULL DEFAULT NULL,
                `createdby` int(11) DEFAULT NULL,
                `updatedby` int(11) DEFAULT NULL
              ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_campaignarticles` (
                `campaignarticle_id` int(11) NOT NULL  AUTO_INCREMENT PRIMARY KEY,
                `campaigns_id` int(11) DEFAULT 0,
                `parent_article` int(11) DEFAULT 0,
                `title` varchar(250) NULL,
                `alias` varchar(250) NULL,
                `link` text NULL,
                `text` TEXT NULL,
                `cover_photo` varchar(500) NOT NULL,
                `thumb` varchar(255) NULL,
                `display_order` int(11) NULL DEFAULT 0,
                `status` int(11) NULL DEFAULT 0,
                `created_at` timestamp NULL DEFAULT NULL,
                `updated_at` timestamp NULL DEFAULT NULL,
                `createdby` int(11) DEFAULT NULL,
                `updatedby` int(11) DEFAULT NULL
              ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_preparationclasses` (
                `preparationclass_id` int(11) NOT NULL  AUTO_INCREMENT PRIMARY KEY,
                `title` varchar(255) NULL,
                `alias` varchar(255) NULL,
                `parent_preparationclass` int(11) NULL DEFAULT 0,
                `details` TEXT NULL,
                `intro` TEXT NULL,
                `image` varchar(255) NULL,
                `thumb` varchar(255) NULL,
                `cover` varchar(255) NULL,
                `remarks` TEXT NULL,
                `display_order` int(11) NULL DEFAULT 0,
                `status` int(11) NULL DEFAULT 0,
                `created_at` timestamp NULL DEFAULT NULL,
                `updated_at` timestamp NULL DEFAULT NULL,
                `createdby` int(11) DEFAULT NULL,
                `updatedby` int(11) DEFAULT NULL
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_services` (
                `service_id` int(11) NOT NULL  AUTO_INCREMENT PRIMARY KEY,
                `parent_service` int(11) DEFAULT 0,
                `title` varchar(250) NULL,
                `alias` varchar(250) NULL,
                `text` TEXT NULL,
                `link` varchar(500) NOT NULL,
                `cover_photo` varchar(500) NOT NULL,
                `display_order` int(11) NULL DEFAULT 0,
                `status` int(11) NULL DEFAULT 0,
                `created_at` timestamp NULL DEFAULT NULL,
                `updated_at` timestamp NULL DEFAULT NULL,
                `createdby` int(11) DEFAULT NULL,
                `updatedby` int(11) DEFAULT NULL
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
              ");
            DB::statement("CREATE TABLE IF NOT EXISTS `tbl_countries` (
                `country_id` int(11) NOT NULL  AUTO_INCREMENT PRIMARY KEY,
                `title` varchar(255) NULL,
                `alias` varchar(255) NULL,
                `text` TEXT NULL,
                `details` TEXT NULL,
                `cover_photo` varchar(255) NULL,
                `image_thumb` varchar(255) NULL,
                `display_order` int(11) NULL DEFAULT 0,
                `status` int(11) NULL DEFAULT 0,
                `created_at` timestamp NULL DEFAULT NULL,
                `updated_at` timestamp NULL DEFAULT NULL,
                `createdby` int(11) DEFAULT NULL,
                `updatedby` int(11) DEFAULT NULL
              ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
              ");
            DB::statement('
            CREATE TABLE IF NOT EXISTS `tbl_subscribers` (
                `subscriber_id` int(11) NOT NULL  AUTO_INCREMENT PRIMARY KEY,
                `title` varchar(255) NULL,
                `alias` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
                `email` varchar(255) NULL,
                `display_order` int(11) NULL DEFAULT 0,
                `status` int(11) NULL DEFAULT 0,
                `createdby` int(11) DEFAULT NULL,
                `updatedby` int(11) DEFAULT NULL,
                `created_at` timestamp NULL DEFAULT NULL,
                `updated_at` timestamp NULL DEFAULT NULL
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8
        ');
            DB::statement('
            CREATE TABLE IF NOT EXISTS `tbl_faqs` (
                `faq_id` int(11) NOT NULL  AUTO_INCREMENT PRIMARY KEY,
                `title` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
                `text` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
                `display_order` int(11) NULL DEFAULT 0,
                `status` int(11) NULL DEFAULT 0,
                `createdby` int(11) DEFAULT NULL,
                `updatedby` int(11) DEFAULT NULL,
                `created_at` timestamp NULL DEFAULT NULL,
                `updated_at` timestamp NULL DEFAULT NULL
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
        ');
            DB::statement('
            CREATE TABLE IF NOT EXISTS `tbl_successstories` (
                `successstory_id` int(11) NOT NULL  AUTO_INCREMENT PRIMARY KEY,
                `countries_id` int(11) DEFAULT NULL,
                `title` varchar(255) DEFAULT NULL,
                `alias` varchar(200) DEFAULT NULL,
                `image` varchar(255) DEFAULT NULL,
                `text` text DEFAULT NULL,
                `remarks` varchar(255) DEFAULT NULL,
                `display_order` int(11) DEFAULT NULL,
                `status` int(11) DEFAULT NULL,
                `university` varchar(255) DEFAULT NULL,
                `faculty` varchar(255) DEFAULT NULL,
                `createdby` varchar(255) DEFAULT NULL,
                `created_at` varchar(255) DEFAULT NULL,
                `updatedby` varchar(255) DEFAULT NULL,
                `updated_at` varchar(255) DEFAULT NULL
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
        ');
            DB::statement("CREATE TABLE IF NOT EXISTS tbl_sources (
            source_id INT(11) AUTO_INCREMENT PRIMARY KEY,
            title VARCHAR(255),
            alias VARCHAR(255),
            name VARCHAR(255),
            description TEXT,
            display_order INT(11),
            status INT(11),
            remarks TEXT,
            created_at DATETIME,
            createdby INT(11),
            updated_at DATETIME,
            updatedby INT(11)
        );
        ");
            DB::statement("CREATE TABLE IF NOT EXISTS tbl_registrations (
            registration_id INT(11) AUTO_INCREMENT PRIMARY KEY,
            campaigns_id INT(11),
            sources_id INT(11),
            countries_id INT(11),
            provinces_id INT(11),
            districts_id INT(11),
            cities_id INT(11),
            leadcategories_id INT(11),
            agents_id INT(11),
            name VARCHAR(255),
            email VARCHAR(255),
            phone VARCHAR(255),
            mobile VARCHAR(255),
            address VARCHAR(255),
            qualifications_id INT(11),
            see_year VARCHAR(255),
            see_grade VARCHAR(255),
            see_stream VARCHAR(255),
            see_school VARCHAR(255),
            plus2_year VARCHAR(255),
            plus2_grade VARCHAR(255),
            plus2_stream VARCHAR(255),
            plus2_college VARCHAR(255),
            bachelors_year VARCHAR(255),
            bachelors_grade VARCHAR(255),
            bachelors_stream VARCHAR(255),
            bachelors_college VARCHAR(255),
            highest_qualification VARCHAR(255),
            highest_grade VARCHAR(255),
            highest_year VARCHAR(255),
            highest_stream VARCHAR(255),
            highest_college VARCHAR(255),
            preparation_class VARCHAR(255),
            preparation_score VARCHAR(255),
            preparation_bandscore VARCHAR(255),
            preparation_date VARCHAR(255),
            preffered_location TEXT,
            intrested_for_country TEXT,
            intrested_course TEXT,
            user_agent TEXT,
            tags TEXT,
            coupen_code VARCHAR(255),
            display_order INT(11),
            status INT(11),
            remarks TEXT,
            created_at DATETIME,
            createdby INT(11),
            updated_at DATETIME,
            updatedby INT(11)
        );
        ");
            DB::statement("CREATE TABLE IF NOT EXISTS tbl_students (
            student_id INT(11) AUTO_INCREMENT PRIMARY KEY,
            campaigns_id INT(11) NULL,
            sources_id INT(11) NULL,
            leadcategories_id INT(11) NULL,
            agents_id INT(11) NULL,
    countries_id INT(11) NULL,
    name VARCHAR(255) NULL,
    email VARCHAR(255) NULL,
    phone VARCHAR(255) NULL,
    mobile VARCHAR(255) NULL,
    address VARCHAR(255) NULL,
    dob VARCHAR(255) NULL,
    gender VARCHAR(255) NULL,
    martial_status VARCHAR(255) NULL,
    guardian_name VARCHAR(255) NULL,
    guardian_contact VARCHAR(255) NULL,
    see_year VARCHAR(255) NULL,
    see_grade VARCHAR(255) NULL,
    see_stream VARCHAR(255) NULL,
    see_school VARCHAR(255) NULL,
    plus2_year VARCHAR(255) NULL,
    plus2_grade VARCHAR(255) NULL,
    plus2_stream VARCHAR(255) NULL,
    plus2_college VARCHAR(255) NULL,
    bachelors_year VARCHAR(255) NULL,
    bachelors_grade VARCHAR(255) NULL,
    bachelors_stream VARCHAR(255) NULL,
    bachelors_college VARCHAR(255) NULL,
    highest_qualification VARCHAR(255) NULL,
    highest_grade VARCHAR(255) NULL,
    highest_stream VARCHAR(255) NULL,
    highest_college VARCHAR(255) NULL,
    work_experience TEXT NULL,
    extra_skills text NULL,
    how_know_us text NULL,
    preparation_class VARCHAR(255) NULL,
    preparation_score VARCHAR(255) NULL,
    preparation_bandscore VARCHAR(255) NULL,
    preparation_date VARCHAR(255) NULL,
    preffered_location TEXT NULL,
    intrested_for_country TEXT NULL,
    intrested_course TEXT NULL,
    user_agent TEXT NULL,
    tags TEXT NULL,
    coupen_code VARCHAR(255) NULL,
    display_order INT(11) NULL,
    status INT(11) NULL,
    remarks TEXT NULL,
    created_at DATETIME NULL,
    createdby INT(11) NULL,
    updated_at DATETIME NULL,
    updatedby INT(11) NULL
        );
        ");
            DB::statement("CREATE TABLE IF NOT EXISTS tbl_followups (
            followup_id INT(11) AUTO_INCREMENT PRIMARY KEY,
            title VARCHAR(255),
            alias VARCHAR(255),
            registrations_id INT(11),
            parent_followup INT(11),
            followup_date DATETIME,
            followup_response VARCHAR(255),
            followup_by VARCHAR(255),
            next_schedule DATETIME,
            display_order INT(11),
            status INT(11),
            remarks TEXT,
            created_at DATETIME,
            createdby INT(11),
            updated_at DATETIME,
            updatedby INT(11)
        );
        ");
            DB::statement("CREATE TABLE IF NOT EXISTS tbl_requireddocuments (
            requireddocument_id INT(11) AUTO_INCREMENT PRIMARY KEY,
            title VARCHAR(255),
            alias VARCHAR(255),
            description TEXT,
            display_order INT(11),
            status INT(11),
            remarks TEXT,
            created_at DATETIME,
            createdby INT(11),
            updated_at DATETIME,
            updatedby INT(11)
        );");
            DB::statement("CREATE TABLE IF NOT EXISTS tbl_options (
            option_id INT(11) AUTO_INCREMENT PRIMARY KEY,
            title VARCHAR(255),
            alias VARCHAR(255),
            students_id INT(11),
            programs_id INT(11),
            advice TEXT,
            description TEXT,
            display_order INT(11),
            status INT(11),
            remarks TEXT,
            created_at DATETIME,
            createdby INT(11),
            updated_at DATETIME,
            updatedby INT(11)
        );");
            DB::statement("CREATE TABLE IF NOT EXISTS tbl_spinthewheelwinners (
            spinthewheelwinner_id INT(11) AUTO_INCREMENT PRIMARY KEY,
            title VARCHAR(255),
            alias VARCHAR(255),
            registrations_id INT(11),
            prize TEXT,
            display_order INT(11),
            status INT(11),
            remarks TEXT,
            created_at DATETIME,
            createdby INT(11),
            updated_at DATETIME,
            updatedby INT(11)
        );");
            DB::statement("CREATE TABLE IF NOT EXISTS tbl_offerapplications (
            offerapplication_id INT(11) AUTO_INCREMENT PRIMARY KEY,
            title VARCHAR(255),
            alias VARCHAR(255),
            students_id INT(11),
            programs_id INT(11),
            advice TEXT,
            requireddocuments_id VARCHAR(255),
            additional_documents VARCHAR(255),
            application_date DATE,
            application_fee DOUBLE,
            applicationfee_deadline DATE,
            applicationfee_paid BOOLEAN,
            applicationfee_paymentdate DATE,
            offer_status VARCHAR(255),
            offer_letter VARCHAR(255),
            offerletter_date DATE,
            offered_conditions VARCHAR(255),
            description TEXT,
            display_order INT(11),
            status INT(11),
            remarks TEXT,
            created_at DATETIME,
            createdby INT(11),
            updated_at DATETIME,
            updatedby INT(11)
        );");
            if (!(DB::table('users')->first())) {
                DB::statement("INSERT INTO `tbl_users` (`id`, `name`, `email`, `username`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`,`role`) VALUES ('1', 'Prajwal Adhikari', 'prajwalbro@hotmail.com', 'prajwalbro@hotmail.com', NULL, '$2y$10$3zlF9VeXexzWKRDPZuDio.W7RZIC3tU.cjwMoLzG8ki8bVwAQn1WW', NULL, NULL, NULL,'Admin');");
                DB::statement("INSERT INTO `tbl_users` (`id`, `name`, `email`, `username`, `email_verified_at`, `password`, `role`) VALUES ('1', 'Prajwal Adhikari', 'prajwalbro@hotmail.com', 'prajwalbro@hotmail.com', NULL, '$2y$10$3zlF9VeXexzWKRDPZuDio.W7RZIC3tU.cjwMoLzG8ki8bVwAQn1WW','Admin');");
            }
            if (!(DB::table('settings')->first())) {
                DB::statement("INSERT INTO `tbl_settings` (`title`, `description`, `status`) VALUES ('Bibhuti LMS', '', '1');");
            }
            if (!(DB::table('campaigns')->first())) {
                DB::statement("INSERT INTO `tbl_campaigns` (`title`,`alias`,`status`) VALUES ('My First Campaign','my_first_campaign', '1');");
            }
            if (!(DB::table('countries')->first())) {
                DB::statement("INSERT INTO `tbl_countries` (`title`,`alias`,`status`) VALUES ('Not Specific','not_specific', '1');");
            }
            if (!(DB::table('leadcategories')->first())) {
                DB::statement("INSERT INTO `tbl_leadcategories` (`title`,`alias`,`status`) VALUES ('Raw Lead','raw_lead','1');");
            }
            if (!(DB::table('sources')->first())) {
                DB::statement("INSERT INTO `tbl_sources` (`title`,`alias`,`status`) VALUES ('Direct','direct','1');");
                DB::statement("INSERT INTO `tbl_sources` (`title`,`alias`,`status`) VALUES ('Office Visits','office','1');");
                DB::statement("INSERT INTO `tbl_sources` (`title`,`alias`,`status`) VALUES ('Online Registrations','online','1');");
            }
            if (!Schema::hasColumn('settings', 'meta_pixel_code')) {
                Schema::table('settings', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->text('meta_pixel_code')->nullable();
                });
            }
            if (!Schema::hasColumn('settings', 'smtp_server')) {
                Schema::table('settings', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('smtp_server')->nullable();
                });
            }
            if (!Schema::hasColumn('settings', 'smtp_user')) {
                Schema::table('settings', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('smtp_user')->nullable();
                });
            }
            if (!Schema::hasColumn('settings', 'smtp_password')) {
                Schema::table('settings', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('smtp_password')->nullable();
                });
            }
            if (!Schema::hasColumn('settings', 'smtp_port')) {
                Schema::table('settings', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('smtp_port')->nullable();
                });
            }
            if (!Schema::hasColumn('settings', 'smtp_security')) {
                Schema::table('settings', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('smtp_security')->nullable();
                });
            }
            if (!Schema::hasColumn('settings', 'sms_api')) {
                Schema::table('settings', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('sms_api')->nullable();
                });
            }
            if (!Schema::hasColumn('settings', 'sms_username')) {
                Schema::table('settings', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('sms_username')->nullable();
                });
            }
            if (!Schema::hasColumn('settings', 'sms_password')) {
                Schema::table('settings', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('sms_password')->nullable();
                });
            }
            if (!Schema::hasColumn('settings', 'sms_sender')) {
                Schema::table('settings', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('sms_sender')->nullable();
                });
            }
            if (!Schema::hasColumn('campaignarticles', 'link')) {
                Schema::table('campaignarticles', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('link')->nullable();
                });
            }
            if (!Schema::hasColumn('campaigns', 'google_sheet_id')) {
                Schema::table('campaigns', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('google_sheet_id')->nullable();
                });
            }
            if (!Schema::hasColumn('campaigns', 'google_sheet_worksheet')) {
                Schema::table('campaigns', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('google_sheet_worksheet')->nullable();
                });
            }
            if (!Schema::hasColumn('campaigns', 'pass_layout')) {
                Schema::table('campaigns', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('pass_layout')->nullable();
                });
            }
            if (!Schema::hasColumn('campaigns', 'qr_position')) {
                Schema::table('campaigns', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('qr_position')->nullable();
                });
            }
            if (!Schema::hasColumn('campaigns', 'id_position')) {
                Schema::table('campaigns', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('id_position')->nullable();
                });
            }
            if (!Schema::hasColumn('campaigns', 'name_position')) {
                Schema::table('campaigns', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('name_position')->nullable();
                });
            }
            if (!Schema::hasColumn('campaigns', 'email_position')) {
                Schema::table('campaigns', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('email_position')->nullable();
                });
            }
            if (!Schema::hasColumn('campaigns', 'notify_emails')) {
                Schema::table('campaigns', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->text('notify_emails')->nullable();
                });
            }
            if (!Schema::hasColumn('users', 'role')) {
                Schema::table('users', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('role')->nullable();
                });
            }
            if (!Schema::hasColumn('registrations', 'highest_year')) {
                Schema::table('registrations', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('highest_year')->nullable();
                });
            }
            if (!Schema::hasColumn('registrations', 'experience')) {
                Schema::table('registrations', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('experience')->nullable();
                });
            }
            if (!Schema::hasColumn('registrations', 'gender')) {
                Schema::table('registrations', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('gender')->nullable();
                });
            }
            if (!Schema::hasColumn('registrations', 'applied_before')) {
                Schema::table('registrations', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('applied_before')->nullable();
                });
            }
            if (!Schema::hasColumn('registrations', 'how_you_know')) {
                Schema::table('registrations', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('how_you_know')->nullable();
                });
            }
            if (!Schema::hasColumn('registrations', 'reference')) {
                Schema::table('registrations', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('reference')->nullable();
                });
            }
            if (!Schema::hasColumn('registrations', 'marital_status')) {
                Schema::table('registrations', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('marital_status')->nullable();
                });
            }
            if (!Schema::hasColumn('registrations', 'dob')) {
                Schema::table('registrations', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('dob')->nullable();
                });
            }
            if (!Schema::hasColumn('registrations', 'guardian_name')) {
                Schema::table('registrations', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('guardian_name')->nullable();
                });
            }
            if (!Schema::hasColumn('registrations', 'guardian_name')) {
                Schema::table('registrations', function (Blueprint $table) {
                    // Add the new column to the table
                    $table->string('guardian_name')->nullable();
                });
            }
            $initialized = true;
        }
    }
}