芝麻web文件管理V1.00

编辑当前文件:/home/qrafawbu/store.kwesioben.com/app/Traits/UpdateClass.php

<?php

namespace App\Traits;

use App\CPU\Helpers;
use App\Model\Banner;
use App\Model\BusinessSetting;
use App\Model\Order;
use App\Model\Product;
use App\User;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\File;
use Illuminate\Support\Facades\Schema;

trait UpdateClass
{
    public function insert_data_of($version_number)
    {
        if ($version_number == '13.0') {
            if (BusinessSetting::where(['type' => 'product_brand'])->first() == false) {
                DB::table('business_settings')->updateOrInsert(['type' => 'product_brand'], [
                    'value' => 1
                ]);
            }

if (BusinessSetting::where(['type' => 'digital_product'])->first() == false) {
                DB::table('business_settings')->updateOrInsert(['type' => 'digital_product'], [
                    'value' => 1
                ]);
            }
        }

if ($version_number == '13.1') {
            $refund_policy = BusinessSetting::where(['type' => 'refund-policy'])->first();
            if ($refund_policy) {
                $refund_value = json_decode($refund_policy['value'], true);
                if(!isset($refund_value['status'])){
                    BusinessSetting::where(['type' => 'refund-policy'])->update([
                        'value' => json_encode([
                            'status' => 1,
                            'content' => $refund_policy['value'],
                        ]),
                    ]);
                }
            }elseif(!$refund_policy){
                BusinessSetting::insert([
                    'type' => 'refund-policy',
                    'value' => json_encode([
                        'status' => 1,
                        'content' => '',
                    ]),
                ]);
            }

$return_policy = BusinessSetting::where(['type' => 'return-policy'])->first();
            if ($return_policy) {
                $return_value = json_decode($return_policy['value'], true);
                if(!isset($return_value['status'])){
                    BusinessSetting::where(['type' => 'return-policy'])->update([
                        'value' => json_encode([
                            'status' => 1,
                            'content' => $return_policy['value'],
                        ]),
                    ]);
                }
            }elseif(!$return_policy){
                BusinessSetting::insert([
                    'type' => 'return-policy',
                    'value' => json_encode([
                        'status' => 1,
                        'content' => '',
                    ]),
                ]);
            }

$cancellation_policy = BusinessSetting::where(['type' => 'cancellation-policy'])->first();
            if ($cancellation_policy) {
                $cancellation_value = json_decode($cancellation_policy['value'], true);
                if(!isset($cancellation_value['status'])){
                    BusinessSetting::where(['type' => 'cancellation-policy'])->update([
                        'value' => json_encode([
                            'status' => 1,
                            'content' => $cancellation_policy['value'],
                        ]),
                    ]);
                }
            }elseif(!$cancellation_policy){
                BusinessSetting::insert([
                    'type' => 'cancellation-policy',
                    'value' => json_encode([
                        'status' => 1,
                        'content' => '',
                    ]),
                ]);
            }

if (BusinessSetting::where(['type' => 'offline_payment'])->first() == false) {
                DB::table('business_settings')->insert([
                    'type' => 'offline_payment',
                    'value' => json_encode([
                        'status' => 0,
                    ]),
                    'updated_at' => now()
                ]);
            }

if (BusinessSetting::where(['type' => 'temporary_close'])->first() == false) {
                DB::table('business_settings')->insert([
                    'type' => 'temporary_close',
                    'value' => json_encode([
                        'status' => 0,
                    ]),
                    'updated_at' => now()
                ]);
            }

if (BusinessSetting::where(['type' => 'vacation_add'])->first() == false) {
                DB::table('business_settings')->insert([
                    'type' => 'vacation_add',
                    'value' => json_encode([
                        'status' => 0,
                        'vacation_start_date' => null,
                        'vacation_end_date' => null,
                        'vacation_note' => null
                    ]),
                    'updated_at' => now()
                ]);
            }

if (BusinessSetting::where(['type' => 'cookie_setting'])->first() == false) {
                DB::table('business_settings')->insert([
                    'type' => 'cookie_setting',
                    'value' => json_encode([
                        'status' => 0,
                        'cookie_text' => null
                    ]),
                    'updated_at' => now()
                ]);
            }

DB::table('colors')
                ->whereIn('id', [16,38,93])
                ->delete();
        }

if ($version_number == '14.0') {
            $colors = BusinessSetting::where('type', 'colors')->first();
            if($colors){
                $colors = json_decode($colors->value);
                BusinessSetting::where('type', 'colors')->update([
                    'value' => json_encode(
                        [
                            'primary' => $colors->primary,
                            'secondary' => $colors->secondary,
                            'primary_light' => isset($colors->primary_light) ? $colors->primary_light : '#CFDFFB',
                        ]),
                ]);
            }

DB::table('business_settings')->updateOrInsert([
                'type' => 'maximum_otp_hit',
                'value' => 0,
                'updated_at' => now()
            ]);

DB::table('business_settings')->updateOrInsert([
                'type' => 'otp_resend_time',
                'value' => 0,
                'updated_at' => now()
            ]);

DB::table('business_settings')->updateOrInsert([
                'type' => 'temporary_block_time',
                'value' => 0,
                'updated_at' => now()
            ]);

DB::table('business_settings')->updateOrInsert([
                'type' => 'maximum_login_hit',
                'value' => 0,
                'updated_at' => now()
            ]);

DB::table('business_settings')->updateOrInsert([
                'type' => 'temporary_login_block_time',
                'value' => 0,
                'updated_at' => now()
            ]);

//product category id update start
            $products = Product::all();
            foreach($products as $product){
                $categories = json_decode($product->category_ids, true);
                $i = 0;
                foreach($categories as $category){
                    if($i == 0){
                        $product->category_id = $category['id'];
                    }elseif($i == 1){
                        $product->sub_category_id = $category['id'];
                    }elseif($i == 2){
                        $product->sub_sub_category_id = $category['id'];
                    }

$product->save();
                    $i++;
                }
            }
            //product category id update end
        }

if ($version_number == '14.1') {
            // default theme folder delete from resources/views folder start
            $folder = base_path('resources/views');
            $directories = glob($folder . '/*', GLOB_ONLYDIR);
            foreach ($directories as $directory) {
                $array = explode('/', $directory);
                if (File::isDirectory($directory) && in_array(end($array), ['web-views', 'customer-view'])) {
                    File::deleteDirectory($directory);
                }
            }
            $front_end_dir = $folder . "/layouts/front-end";
            if (File::isDirectory($front_end_dir)) {
                File::deleteDirectory($front_end_dir);
            }

foreach (['home.blade.php', 'welcome.blade.php'] as $file) {
                if (File::exists($folder . '/' . $file)) {
                    unlink($folder . '/' . $file);
                }
            }
            // default theme folder dele from resources/views folder end

//apple login information insert
            if (BusinessSetting::where(['type' => 'apple_login'])->first() == false) {
                DB::table('business_settings')->insert([
                    'type' => 'apple_login',
                    'value' => json_encode([
                        [
                            'login_medium' => 'apple',
                            'client_id' => '',
                            'client_secret' => '',
                            'status' => 0,
                            'team_id' => '',
                            'key_id' => '',
                            'service_file' => '',
                            'redirect_url' => '',
                        ]
                    ]),
                    'updated_at' => now()
                ]);
            }

//referral code update for existing user
            $customers = User::whereNull('referral_code')->where('id','!=',0)->get();
            foreach($customers as $customer){
                $customer->referral_code = Helpers::generate_referer_code();
                $customer->save();
            }
            DB::table('business_settings')->updateOrInsert([
                'type' => 'ref_earning_status',
                'value' => 0,
                'updated_at' => now()
            ]);

DB::table('business_settings')->updateOrInsert([
                'type' => 'ref_earning_exchange_rate',
                'value' => 0,
                'updated_at' => now()
            ]);

// new payment module necessary table insert
            try {
                if (!Schema::hasTable('addon_settings')) {
                $sql = File::get(base_path('database/migrations/addon_settings.sql'));
                DB::unprepared($sql);
                }

if (!Schema::hasTable('payment_requests')) {
                $sql = File::get(base_path('database/migrations/payment_requests.sql'));
                DB::unprepared($sql);
                }

} catch (\Exception $exception) {
                //
            }

//existing payment gateway data import from business setting table
            $this->payment_gateway_data_update();
            $this->sms_gateway_data_update();

// guest checkout add
            DB::table('business_settings')->updateOrInsert([
                'type' => 'guest_checkout',
                'value' => 0,
                'updated_at' => now()
            ]);

// minimum_order_amount
            DB::table('business_settings')->updateOrInsert([
                'type' => 'minimum_order_amount',
                'value' => 0,
                'updated_at' => now()
            ]);

DB::table('business_settings')->updateOrInsert([
                'type' => 'minimum_order_amount_by_seller',
                'value' => 0,
                'updated_at' => now()
            ]);

DB::table('business_settings')->updateOrInsert([
                'type' => 'minimum_order_amount_status',
                'value' => 0,
                'updated_at' => now()
            ]);

//admin_login_url
            DB::table('business_settings')->updateOrInsert([
                'type' => 'admin_login_url',
                'value' => 'admin',
                'updated_at' => now()
            ]);

//employee_login_url
            DB::table('business_settings')->updateOrInsert([
                'type' => 'employee_login_url',
                'value' => 'employee',
                'updated_at' => now()
            ]);

//free_delivery_status
            DB::table('business_settings')->updateOrInsert([
                'type' => 'free_delivery_status',
                'value' => 0,
                'updated_at' => now()
            ]);

//free_delivery_responsibility
            DB::table('business_settings')->updateOrInsert([
                'type' => 'free_delivery_responsibility',
                'value' => 'admin',
                'updated_at' => now()
            ]);

//free_delivery_over_amount
            DB::table('business_settings')->updateOrInsert([
                'type' => 'free_delivery_over_amount',
                'value' => 0,
                'updated_at' => now()
            ]);

//free_delivery_over_amount
            DB::table('business_settings')->updateOrInsert([
                'type' => 'free_delivery_over_amount_seller',
                'value' => 0,
                'updated_at' => now()
            ]);

//add_funds_to_wallet
            DB::table('business_settings')->updateOrInsert([
                'type' => 'add_funds_to_wallet',
                'value' => 0,
                'updated_at' => now()
            ]);

//minimum_add_fund_amount
            DB::table('business_settings')->updateOrInsert([
                'type' => 'minimum_add_fund_amount',
                'value' => 0,
                'updated_at' => now()
            ]);

//maximum_add_fund_amount
            DB::table('business_settings')->updateOrInsert([
                'type' => 'maximum_add_fund_amount',
                'value' => 0,
                'updated_at' => now()
            ]);

//user_app_version_control
            DB::table('business_settings')->updateOrInsert([
                'type' => 'user_app_version_control',
                'value' => json_encode([
                    "for_android" => [
                        "status" => 1,
                        "version" => "14.1",
                        "link" => ""
                    ],
                    "for_ios" => [
                        "status" => 1,
                        "version" => "14.1",
                        "link" => ""
                    ]
                ]),
                'updated_at' => now()
            ]);

//seller_app_version_control
            DB::table('business_settings')->updateOrInsert([
                'type' => 'seller_app_version_control',
                'value' => json_encode([
                    "for_android" => [
                        "status" => 1,
                        "version" => "14.1",
                        "link" => ""
                    ],
                    "for_ios" => [
                        "status" => 1,
                        "version" => "14.1",
                        "link" => ""
                    ]
                ]),
                'updated_at' => now()
            ]);

//Delivery_man_app_version_control
            DB::table('business_settings')->updateOrInsert([
                'type' => 'delivery_man_app_version_control',
                'value' => json_encode([
                    "for_android" => [
                        "status" => 1,
                        "version" => "14.1",
                        "link" => ""
                    ],
                    "for_ios" => [
                        "status" => 1,
                        "version" => "14.1",
                        "link" => ""
                    ]
                ]),
                'updated_at' => now()
            ]);

// script for theme setup for existing banner
            $theme_name = theme_root_path();
            $banners = Banner::get();
            if($banners){
                foreach($banners as $banner){
                    $banner->theme = $theme_name;
                    $banner->save();
                }
            }

// current shipping responsibility add to orders table
            Order::query()->update(['shipping_responsibility'=>Helpers::get_business_settings('shipping_method')]);

//whatsapp
            $whatsapp = BusinessSetting::where(['type' => 'whatsapp'])->first();
            if(!$whatsapp) {
                DB::table('business_settings')->insert([
                    'type' => 'whatsapp',
                    'value' => json_encode([
                        "status" => 1,
                        "phone" => "00000000000"
                    ]),
                    'updated_at' => now()
                ]);
            }

//currency_symbol_position
            $currency_symbol_position = BusinessSetting::where(['type' => 'currency_symbol_position'])->first();
            if(!$currency_symbol_position){
                DB::table('business_settings')->insert([
                    'type' => 'currency_symbol_position',
                    'value' => "left",
                    'updated_at' => now()
                ]);
            }
        }
    }

private function sms_gateway_data_update(){
        try {
            $gateway = array_merge(Helpers::default_sms_gateways(), [
                        'twilio_sms',
                        'nexmo_sms',
                        '2factor_sms',
                        'msg91_sms',
                        'releans_sms',
                    ]);

$data = BusinessSetting::whereIn('type',$gateway)->pluck('value','type')->toArray();

foreach($data as $key => $value){

$decoded_value= json_decode($value , true);

$gateway=$key;
                if($key == 'twilio_sms'){
                    $gateway='twilio';
                    $additional_data = [
                        'sid' => $decoded_value['sid'],
                        'messaging_service_sid' => $decoded_value['messaging_service_sid'],
                        'token' => $decoded_value['token'],
                        'from' => $decoded_value['from'],
                        'otp_template' => $decoded_value['otp_template'],
                    ];
                }elseif($key == 'nexmo_sms'){
                    $gateway='nexmo';
                    $additional_data = [
                        'api_key' => $decoded_value['api_key'],
                        'api_secret' => $decoded_value['api_secret'],
                        'from' => $decoded_value['from'],
                        'otp_template' => $decoded_value['otp_template'],
                    ];
                }elseif($key == '2factor_sms'){
                    $gateway='2factor';
                    $additional_data = [
                        'api_key' => $decoded_value['api_key'],
                    ];
                }elseif($key == 'msg91_sms'){
                    $gateway='msg91';
                    $additional_data = [
                        'template_id' => $decoded_value['template_id'],
                        'auth_key' => $decoded_value['authkey'] ?? '',
                    ];
                }elseif($key == 'releans_sms'){
                    $gateway='releans';
                    $additional_data = [
                        'api_key' => $decoded_value['api_key'],
                        'from' => $decoded_value['from'],
                        'otp_template' => $decoded_value['otp_template'],
                    ];
                }

$default_data = [
                    'gateway' => $gateway,
                    'mode' => 'live',
                    'status' => $decoded_value['status'] ?? 0
                ];

$credentials = json_encode(array_merge($default_data, $additional_data));

$payment_additional_data=[
                    'gateway_title' => ucfirst(str_replace('_',' ',$gateway)),
                    'gateway_image' => null
                ];

DB::table('addon_settings')->updateOrInsert(['key_name' => $gateway, 'settings_type' => 'sms_config'], [
                    'key_name' => $gateway,
                    'live_values' => $credentials,
                    'test_values' => $credentials,
                    'settings_type' => 'sms_config',
                    'mode' => isset($decoded_value['status']) == 1  ?  'live': 'test',
                    'is_active' => isset($decoded_value['status']) == 1  ?  1: 0 ,
                    'additional_data' => json_encode($payment_additional_data),
                ]);

}
        } catch (\Exception $exception) {
            dd($exception);
        }
        return true;
    }

private function payment_gateway_data_update(){
        try{
            $gateway = Helpers::default_payment_gateways();
            $gateway[] = ['ssl_commerz_payment'];

$data= BusinessSetting::whereIn('type',$gateway)->pluck('value','type')->toArray();

foreach($data as $key => $value)
            {
                $gateway=$key;
                if($key == 'ssl_commerz_payment' ){
                    $gateway='ssl_commerz';
                }

$decoded_value= json_decode($value , true);
                $data= [
                    'gateway' => $gateway ,
                    'mode' =>  isset($decoded_value['status']) == 1  ?  'live': 'test'
                    ];

if ($gateway == 'ssl_commerz') {
                        $additional_data = [
                            'status' => $decoded_value['status'],
                            'store_id' => $decoded_value['store_id'],
                            'store_password' => $decoded_value['store_password'],
                        ];
                    } elseif ($gateway == 'paypal') {
                        $additional_data = [
                            'status' => $decoded_value['status'],
                            'client_id' => $decoded_value['paypal_client_id'],
                            'client_secret' => $decoded_value['paypal_secret'],
                        ];
                    } elseif ($gateway == 'stripe') {
                        $additional_data = [
                            'status' => $decoded_value['status'],
                            'api_key' => $decoded_value['api_key'],
                            'published_key' => $decoded_value['published_key'],
                        ];
                    } elseif ($gateway == 'razor_pay') {
                        $additional_data = [
                            'status' => $decoded_value['status'],
                            'api_key' => $decoded_value['razor_key'],
                            'api_secret' => $decoded_value['razor_secret'],
                        ];
                    } elseif ($gateway == 'senang_pay') {
                        $additional_data = [
                            'status' => $decoded_value['status'],
                            'callback_url' => null,
                            'secret_key' => $decoded_value['secret_key'],
                            'merchant_id' => $decoded_value['merchant_id'],
                        ];
                    } elseif ($gateway == 'paytabs') {
                        $additional_data = [
                            'status' => $decoded_value['status'],
                            'profile_id' => $decoded_value['profile_id'],
                            'server_key' => $decoded_value['server_key'],
                            'base_url' => $decoded_value['base_url'],
                        ];
                    } elseif ($gateway == 'paystack') {
                        $additional_data = [
                            'status' => $decoded_value['status'],
                            'callback_url' => $decoded_value['paymentUrl'],
                            'public_key' => $decoded_value['publicKey'],
                            'secret_key' => $decoded_value['secretKey'],
                            'merchant_email' => $decoded_value['merchantEmail'],
                        ];
                    } elseif ($gateway == 'paymob_accept') {
                        $additional_data = [
                            'status' => $decoded_value['status'],
                            'callback_url' => null,
                            'api_key' => $decoded_value['api_key'],
                            'iframe_id' => $decoded_value['iframe_id'],
                            'integration_id' => $decoded_value['integration_id'],
                            'hmac' => $decoded_value['hmac'],
                        ];
                    } elseif ($gateway == 'mercadopago') {
                        $additional_data = [
                            'status' => $decoded_value['status'],
                            'access_token' => $decoded_value['access_token'],
                            'public_key' => $decoded_value['public_key'],
                        ];
                    } elseif ($gateway == 'liqpay') {
                        $additional_data = [
                            'status' => $decoded_value['status'],
                            'private_key' => $decoded_value['public_key'],
                            'public_key' => $decoded_value['private_key'],
                        ];
                    } elseif ($gateway == 'flutterwave') {
                        $additional_data = [
                            'status' => $decoded_value['status'],
                            'secret_key' => $decoded_value['secret_key'],
                            'public_key' => $decoded_value['public_key'],
                            'hash' => $decoded_value['hash'],
                        ];
                    } elseif ($gateway == 'paytm') {
                        $additional_data = [
                            'status' => $decoded_value['status'],
                            'merchant_key' => $decoded_value['paytm_merchant_key'],
                            'merchant_id' => $decoded_value['paytm_merchant_mid'],
                            'merchant_website_link' => $decoded_value['paytm_merchant_website'],
                        ];
                    } elseif ($gateway == 'bkash') {
                        $additional_data = [
                            'status' => $decoded_value['status'],
                            'app_key' => $decoded_value['api_key'],
                            'app_secret' => $decoded_value['api_secret'],
                            'username' => $decoded_value['username'],
                            'password' => $decoded_value['password'],
                        ];
                    }

$credentials= json_encode(array_merge($data, $additional_data));

$payment_additional_data=['gateway_title' => ucfirst(str_replace('_',' ',$gateway)),
                                        'gateway_image' => null];

DB::table('addon_settings')->updateOrInsert(['key_name' => $gateway, 'settings_type' => 'payment_config'], [
                'key_name' => $gateway,
                'live_values' => $credentials,
                'test_values' => $credentials,
                'settings_type' => 'payment_config',
                'mode' => isset($decoded_value['status']) && $decoded_value['status'] == '1'  ?  'live': 'test',
                'is_active' => isset($decoded_value['status']) && $decoded_value['status'] == '1'  ?  1: 0 ,
                'additional_data' => json_encode($payment_additional_data),
                ]);
            }
        } catch (\Exception $exception) {

}
        return true;
    }

}