One Hat Cyber Team

Edit File: GoBizUpdater810.php

<?php

namespace App\Classes;

use Illuminate\Support\Facades\DB;

class GoBizUpdater810
{
    public function runUpdate()
    {
        DB::statement("ALTER TABLE `plans` CHANGE `plan_price` `plan_price` DOUBLE(15,2) NOT NULL");
        DB::statement("INSERT INTO `config` (`config_key`, `config_value`) VALUES ('mercado_pago_public_key', 'YOUR_MERCADO_PAGO_PUBLIC_KEY'), ('mercado_pago_access_token', 'YOUR_MERCADO_PAGO_ACCESS_TOKEN')");
        DB::statement("INSERT INTO `gateways` (`payment_gateway_id`, `payment_gateway_logo`, `payment_gateway_name`, `display_name`, `client_id`, `secret_key`, `is_status`) VALUES ('776111730465', 'img/payment-method/mercado-pago.png', 'Mercado Pago', 'Mercado Pago', '20', '21', 'enabled')");
        DB::statement("INSERT INTO `config` (`config_key`, `config_value`) VALUES ('toyyibpay_api_key', 'YOUR_TOYYIBPAY_API_KEY'), ('toyyibpay_category_code', 'YOUR_TOYYIBPAY_CATEGORY_CODE')");
        DB::statement("INSERT INTO `gateways` (`payment_gateway_id`, `payment_gateway_logo`, `payment_gateway_name`, `display_name`, `client_id`, `secret_key`, `is_status`) VALUES ('767510608137', 'img/payment-method/toyyibpay.png', 'Toyyibpay', 'Toyyibpay', '22', '23', 'enabled')");
        DB::statement("INSERT INTO `config` (`config_key`, `config_value`) VALUES ('flw_public_key', 'YOUR_FLW_PUBLIC_KEY'), ('flw_secret_key', 'YOUR_FLW_SECRET_KEY'), ('flw_encryption_key', 'YOUR_FLW_ENCRYPTION_KEY')");
        DB::statement("INSERT INTO `gateways` (`payment_gateway_id`, `payment_gateway_logo`, `payment_gateway_name`, `display_name`, `client_id`, `secret_key`, `is_status`) VALUES ('754201940107', 'img/payment-method/flutterwave.png', 'Flutterwave', 'Flutterwave', '24', '25', 'enabled')");
        DB::statement("UPDATE `users` SET `email_verified_at` = '2024-10-09 13:14:48' WHERE `users`.`id` = 1");
        DB::statement("CREATE TABLE `applied_coupons` (
        `id` int UNSIGNED NOT NULL,
        `applied_coupon_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
        `user_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
        `coupon_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
        `status` int NOT NULL DEFAULT '1',
        `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci");

DB::statement("CREATE TABLE `coupons` (
        `id` int UNSIGNED NOT NULL,
        `coupon_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
        `coupon_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
        `coupon_desc` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
        `coupon_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
        `coupon_amount` double NOT NULL,
        `coupon_expired_on` datetime NOT NULL,
        `coupon_user_usage_limit` int NOT NULL,
        `coupon_total_usage_limit` int NOT NULL,
        `status` int NOT NULL DEFAULT '1',
        `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci");

DB::statement("ALTER TABLE `applied_coupons` ADD PRIMARY KEY (`id`)");

DB::statement("ALTER TABLE `coupons` ADD PRIMARY KEY (`id`)");

DB::statement("ALTER TABLE `applied_coupons` MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT");

DB::statement("ALTER TABLE `coupons` MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT");

DB::statement("ALTER TABLE `applied_coupons` ADD `transaction_id` VARCHAR(191) NOT NULL AFTER `applied_coupon_id`");

DB::statement("ALTER TABLE `plans` ADD `appointment` BOOLEAN NOT NULL DEFAULT TRUE AFTER `contact_form`");

DB::statement("CREATE TABLE `card_appointment_times` (
        `id` int UNSIGNED NOT NULL,
        `card_appointment_time_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
        `card_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
        `day` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
        `slot_duration` int NOT NULL DEFAULT '30',
        `time_slots` text COLLATE utf8mb4_unicode_ci NOT NULL,
        `price` double(15,2) NOT NULL DEFAULT '0.00',
        `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
        `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci");

DB::statement("ALTER TABLE `card_appointment_times` ADD PRIMARY KEY (`id`)");

DB::statement("ALTER TABLE `card_appointment_times` MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT");

DB::statement("CREATE TABLE `booked_appointments` (
        `id` int UNSIGNED NOT NULL,
        `booked_appointment_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
        `card_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
        `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
        `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
        `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
        `notes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
        `booking_date` date NOT NULL,
        `booking_time` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
        `total_price` double(15,2) NOT NULL DEFAULT '0.00',
        `booking_status` int NOT NULL DEFAULT '0',
        `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
        `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci");

DB::statement("ALTER TABLE `booked_appointments` ADD PRIMARY KEY (`id`)");

DB::statement("ALTER TABLE `booked_appointments` MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT");
    }
}