One Hat Cyber Team

Edit File: Utility.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;
use Carbon\Carbon;
// use Mail;
use Illuminate\Support\Facades\Mail;
use App\Mail\CommonEmailTemplate;
use Spatie\GoogleCalendar\Event as GoogleEvent;
use App\Models\Calendar;
use Twilio\Rest\Client;

class Utility extends Model
{
    public static function settings($user_id = 0)
    {

$data = DB::table('settings');

if (\Auth::check()) {
            // dd(Auth::user()->getCreatedBy());
            $data = $data->where('created_by', '=', Auth::user()->getCreatedBy())->get();

if (count($data) == 0) { 
                $data = DB::table('settings')->where('created_by', '=', 1)->get();
            }
        } else {
            $data->where('created_by', '=', 1);
            $data = $data->get();
        }

$settings = [
            "currency" => "USD",
            "currency_symbol" => "$",
            "site_currency" => "Dollars",
            "site_currency_symbol" => "$",
            "site_currency_symbol_position" => "pre",
            "site_date_format" => "M j, Y",
            "site_time_format" => "g:i A",
            "company_name" => "",
            "company_address" => "",
            "company_city" => "",
            "company_state" => "",
            "company_zipcode" => "",
            "company_country" => "",
            "company_telephone" => "",
            "company_email" => "",
            "company_email_from_name" => "",
            "invoice_prefix" => "#INV",
            "invoice_title" => "",
            "invoice_text" => "",
            "invoice_color" => "#6676ef",
            "purchase_invoice_prefix" => "#PUR",
            "sale_invoice_prefix" => "#SALE",
            "quotation_invoice_prefix" => "#QUO",
            "low_product_stock_threshold" => "0",
            "footer_text" => "Copyright © 2022 POSGo-SaaS",
            "default_language" => "en",
            "default_user_language" => "en",
            "invoice_footer_title" => "",
            "invoice_footer_notes" => "",
            "purchase_invoice_template" => "template1",
            "purchase_invoice_color" => "ffffff",
            "sale_invoice_template" => "template1",
            "sale_invoice_color" => "ffffff",
            "quotation_invoice_template" => "template1",
            "quotation_invoice_color" => "ffffff",
            "display_landing_page" => "on",
            "footer_link_1" => "Support",
            "footer_link_2" => "Term",
            "footer_link_3" => "Privacy",
            "footer_value_1" => "#",
            "footer_value_2" => "#",
            "footer_value_3" => "#",
            "tax_type" => "",
            "gdpr_cookie" => "on",
            "cookie_text" => "",
            'disable_signup_button' => "on",
            "color" => "theme-3",
            "cust_theme_bg" => "on",
            "cust_darklayout" => "off",
            "logo_dark" => 'logo-dark.png',
            "logo_light" => 'logo-light.png',
            "favicon" => 'favicon.png',
            "company_logo_light" => "2-logo-light.png",
            "company_logo_dark" => "2-logo-dark.png",
            "company_favicon" => "2_favicon.png",
            "SITE_RTL" => "off",
            "display_landing"=>"on",
            "storage_setting" => "",
            "local_storage_validation" => "",
            "local_storage_max_upload_size" => "",
            "s3_key" => "",
            "s3_secret" => "",
            "s3_region" => "",
            "s3_bucket" => "",
            "s3_url"    => "",
            "s3_endpoint" => "",
            "s3_max_upload_size" => "",
            "s3_storage_validation" => "",
            "wasabi_key" => "",
            "wasabi_secret" => "",
            "wasabi_region" => "",
            "wasabi_bucket" => "",
            "wasabi_url" => "",
            "wasabi_root" => "",
            "wasabi_max_upload_size" => "",
            "wasabi_storage_validation" => "",
            "barcode_type" => "code128",
            "barcode_format" =>"css",
            "google_calender_json_file" =>"",
            "google_clender_id"=>"",
            "is_enabled"=>"",
            "email_verification" => "off",
            "enable_cookie"=>"on",
            "necessary_cookies"=>"on",
            "cookie_logging"=>"on",
            "cookie_title"=>"We use cookies!",
            "cookie_description"=>"Hi, this website uses essential cookies to ensure its proper operation and tracking cookies to understand how you interact with it",
            "strictly_cookie_title"=>"Strictly necessary cookies",
            "strictly_cookie_description"=>"These cookies are essential for the proper functioning of my website. Without these cookies, the website would not work properly",
            "more_information_description"=>"For any queries in relation to our policy on cookies and your choices, please contact us",
            "contactus_url"=>"#",
            "twilio_sid"=>"",
            "twilio_token"=>"",
            "twilio_from"=>"",
            "chatgpt_key"=>"",
            "purchase_logo"=>"",
            "sale_logo"=>"",
            "quotation_logo"=>"",
            'MAIL_DRIVER' => "",
            'MAIL_HOST' => "",
            'MAIL_PORT' =>  "",
            'MAIL_USERNAME' => "",
            'MAIL_PASSWORD' => "",
            'MAIL_ENCRYPTION' => "",
            'MAIL_FROM_ADDRESS' => "",
            'MAIL_FROM_NAME'=> "",

];

foreach ($data as $row) {
            $settings[$row->name] = $row->value;
        }

return $settings;
    }

public static function settingsById($id)
    {
        // $id = \Auth::user()->creatorId();
        // dd($id);
        $data     = DB::table('settings');
        $data     = $data->where('created_by', '=', $id);
        $data     = $data->get();
        $settings = [
            "currency" => "USD",
            "currency_symbol" => "$",
            "site_currency" => "USD",
            "site_currency_symbol" => "$",
            "site_currency_symbol_position" => "pre",
            "site_date_format" => "M j, Y",
            "site_time_format" => "g:i A",
            "company_name" => "",
            "company_address" => "",
            "company_city" => "",
            "company_state" => "",
            "company_zipcode" => "",
            "company_country" => "",
            "company_telephone" => "",
            // "company_email" => "",
            // "company_email_from_name" => "",
            "invoice_prefix" => "#INVO",
            "journal_prefix" => "#JUR",
            "invoice_color" => "ffffff",
            "proposal_prefix" => "#PROP",
            "proposal_color" => "ffffff",
            "proposal_logo" => "2_proposal_logo.png",
            "retainer_logo" => "2_retainer_logo.png",
            "invoice_logo" => "2_invoice_logo.png",
            "bill_logo" => "2_bill_logo.png",
            "retainer_color" => "ffffff",
            "bill_prefix" => "#BILL",
            "bill_color" => "ffffff",
            "customer_prefix" => "#CUST",
            "vender_prefix" => "#VEND",
            "contract_prefix" => "#CON",
            "retainer_prefix" => "#RET",
            "footer_title" => "",
            "footer_notes" => "",
            "purchase_invoice_template" => "template1",
            "purchase_invoice_color" => "ffffff",
            "sale_invoice_template" => "template1",
            "sale_invoice_color" => "ffffff",
            "quotation_invoice_template" => "template1",
            "quotation_invoice_color" => "ffffff",
            "invoice_template" => "template1",
            "bill_template" => "template1",
            "proposal_template" => "template1",
            "retainer_template" => "template1",
            "contract_template" => "template1",
            "registration_number" => "",
            "vat_number" => "",
            "default_language" => "en",
            "enable_stripe" => "",
            "enable_paypal" => "",
            "paypal_mode" => "",
            "paypal_client_id" => "",
            "paypal_secret_key" => "",
            "stripe_key" => "",
            "stripe_secret" => "",
            "decimal_number" => "2",
            "tax_number" => "on",
            "tax_type" => "",
            "shipping_display" => "on",
            "journal_prefix" => "#JUR",
            "display_landing_page" => "on",
            "title_text" => "",
            // 'gdpr_cookie' => "off",
            'cookie_text' => "",
            "twilio_sid" => "",
            "twilio_token" => "",
            "twilio_from" => "",
            "chatgpt_key"=>"",
            "dark_logo" => "logo-dark.png",
            "light_logo" => "logo-light.png",
            "company_logo_light" => "2-logo-light.png",
            "company_logo_dark" => "2-logo-dark.png",
            "company_favicon" => "2_favicon.png",
            "SITE_RTL" => "off",
            "owner_signature" => "",
            "cust_darklayout" => "off",
            "payment_notification" => 1,
            "purchase_logo"=>"",
            "sale_logo"=>"",
            "quotation_logo"=>"",
            "enable_cookie"=>"on",
            "necessary_cookies"=>"on",
            "cookie_logging"=>"on",
            "cookie_title"=>"We use cookies!",
            "cookie_description"=>"Hi, this website uses essential cookies to ensure its proper operation and tracking cookies to understand how you interact with it",
            "strictly_cookie_title"=>"Strictly necessary cookies",
            "strictly_cookie_description"=>"These cookies are essential for the proper functioning of my website. Without these cookies, the website would not work properly",
            "more_information_description"=>"For any queries in relation to our policy on cookies and your choices, please contact us",
            "contactus_url"=>"#",
            'MAIL_DRIVER' => "",
            'MAIL_HOST' => "",
            'MAIL_PORT' =>  "",
            'MAIL_USERNAME' => "",
            'MAIL_PASSWORD' => "",
            'MAIL_ENCRYPTION' => "",
            'MAIL_FROM_ADDRESS' => "",
            'MAIL_FROM_NAME'=> "",
        ];
        foreach ($data as $row) {
            $settings[$row->name] = $row->value;
        }
        return $settings;
    }

public static function getStorageSetting()
    {

$data = DB::table('settings');
        $data = $data->where('created_by', '=', 1);
        $data     = $data->get();
        $settings = [
            "storage_setting" => "",
            "local_storage_validation" => "",
            "local_storage_max_upload_size" => "",
            "s3_key" => "",
            "s3_secret" => "",
            "s3_region" => "",
            "s3_bucket" => "",
            "s3_url"    => "",
            "s3_endpoint" => "",
            "s3_max_upload_size" => "",
            "s3_storage_validation" => "",
            "wasabi_key" => "",
            "wasabi_secret" => "",
            "wasabi_region" => "",
            "wasabi_bucket" => "",
            "wasabi_url" => "",
            "wasabi_root" => "",
            "wasabi_max_upload_size" => "",
            "wasabi_storage_validation" => "",
        ];

foreach($data as $row)
        {
            $settings[$row->name] = $row->value;
        }

return $settings;
    }

public static function languages()
    {
        // $dir     = base_path() . '/resources/lang/';
        // $glob    = glob($dir . "*", GLOB_ONLYDIR);
        // $arrLang = array_map(
        //     function ($value) use ($dir) {
        //         return str_replace($dir, '', $value);
        //     },
        //     $glob
        // );
        // $arrLang = array_map(
        //     function ($value) use ($dir) {
        //         return preg_replace('/[0-9]+/', '', $value);
        //     },
        //     $arrLang
        // );
        // $arrLang = array_filter($arrLang);

// return $arrLang;
// second code
        // $settings = Utility::langSetting();
        // if(!empty($settings['disable_lang'])){
        //     $disabledlang =explode(',', $settings['disable_lang']);
        //     $languages = Languages::whereNotIn('code',$disabledlang)->pluck('fullName','code');
        // }
        // else{
        //     $languages = Languages::pluck('fullName','code');
        // }
        // return $languages;
        $languages=Utility::langList();

if(\Schema::hasTable('languages')){
            $settings = Utility::langSetting();
            if(!empty($settings['disable_lang'])){
                $disabledlang =explode(',', $settings['disable_lang']);
                $languages = Languages::whereNotIn('code',$disabledlang)->pluck('fullName','code');
            }
            else{
                $languages = Languages::pluck('fullName','code');
            }
        }

return $languages;
    }

public static function delete_directory($dir)
    {
        if (!file_exists($dir)) {
            return true;
        }
        if (!is_dir($dir)) {
            return unlink($dir);
        }
        foreach (scandir($dir) as $item) {
            if ($item == '.' || $item == '..') {
                continue;
            }
            if (!self::delete_directory($dir . DIRECTORY_SEPARATOR . $item)) {
                return false;
            }
        }
        return rmdir($dir);
    }

// get font-color code accourding to bg-color
 public static function hex2rgb($hex)
 {
 $hex = str_replace("#", "", $hex);
 if (strlen($hex) == 3) {
 $r = hexdec(substr($hex, 0, 1) . substr($hex, 0, 1));
 $g = hexdec(substr($hex, 1, 1) . substr($hex, 1, 1));
 $b = hexdec(substr($hex, 2, 1) . substr($hex, 2, 1));
 } else {
 $r = hexdec(substr($hex, 0, 2));
 $g = hexdec(substr($hex, 2, 2));
 $b = hexdec(substr($hex, 4, 2));
 }
 $rgb = [$r, $g, $b];
 //return implode(",", $rgb); // returns the rgb values separated by commas
 return $rgb; // returns an array with the rgb values
 }
 public static function getFontColor($color_code)
 {
 $rgb = self::hex2rgb($color_code);
 $R = $G = $B = $C = $L = $color = '';
 $R = (floor($rgb[0]));
 $G = (floor($rgb[1]));
 $B = (floor($rgb[2]));
 $C = [
 $R / 255,
 $G / 255,
 $B / 255,
 ];
 for ($i = 0; $i < count($C); ++$i) {
 if ($C[$i] <= 0.03928) {
 $C[$i] = $C[$i] / 12.92;
 } else {
 $C[$i] = pow(($C[$i] + 0.055) / 1.055, 2.4);
 }
 }
 $L = 0.2126 * $C[0] + 0.7152 * $C[1] + 0.0722 * $C[2];

$color = $L > 0.179 ? 'black' : 'white';

return $color;
    }

public static function getValByName($key)
    {
        $setting = Utility::settings();

return (!isset($setting[$key]) || empty($setting[$key])) ? '' : $setting[$key];
    }

public static function getStartEndMonthDates()
    {
        $first_day_of_current_month = Carbon::now()->startOfMonth()->subMonths(0)->toDateString();
        $first_day_of_next_month = Carbon::now()->startOfMonth()->subMonths(-1)->toDateString();

return ['start_date' => $first_day_of_current_month, 'end_date' => $first_day_of_next_month];
    }

public static function setEnvironmentValue(array $values)
    {
        $envFile = app()->environmentFilePath();
        $str     = file_get_contents($envFile);
        if (count($values) > 0) {
            foreach ($values as $envKey => $envValue) {
                $keyPosition       = strpos($str, "{$envKey}=");
                $endOfLinePosition = strpos($str, "\n", $keyPosition);
                $oldLine           = substr($str, $keyPosition, $endOfLinePosition - $keyPosition);

// If key does not exist, add it
                if (!$keyPosition || !$endOfLinePosition || !$oldLine) {
                    $str .= "{$envKey}='{$envValue}'\n";
                } else {
                    $str = str_replace($oldLine, "{$envKey}='{$envValue}'", $str);
                }
            }
        }
        $str = substr($str, 0, -1);
        $str .= "\n";

return file_put_contents($envFile, $str) ? true : false;
    }

public static function convertStringToSlug($string = '')
    {
        return strtolower(trim(preg_replace('/[^A-Za-z0-9-]+/', '-', $string)));
    }

public static function templateData()
    {
        $array = [];
        $array['colors']    = [
            '003580',
            '666666',
            '5e72e4',
            'f50102',
            'f9b034',
            'fbdd03',
            'c1d82f',
            '37a4e4',
            '8a7966',
            '6a737b',
            '050f2c',
            '0e3666',
            '3baeff',
            '3368e6',
            'b84592',
            'f64f81',
            'f66c5f',
            'fac168',
            '46de98',
            '40c7d0',
            'be0028',
            '2f9f45',
            '371676',
            '52325d',
            '511378',
            '0f3866',
            '48c0b6',
            '297cc0',
            'ffffff',
            '000000',
        ];
        $array['templates'] = [
            "template1" => "New York",
            "template2" => "Toronto",
            "template3" => "Rio",
            "template4" => "London",
            "template5" => "Istanbul",
            "template6" => "Mumbai",
            "template7" => "Hong Kong",
            "template8" => "Tokyo",
            "template9" => "Sydney",
            "template10" => "Paris",
        ];
        return $array;
    }

public static function getSuperAdminValByName($key)
    {
        $data = DB::table('settings');
        $data = $data->where('name', '=', $key);
        $data = $data->first();
        if (!empty($data)) {
            $record = $data->value;
        } else {
            $record = '';
        }
        return $record;
    }

public static function getAdminPaymentSetting()
    {
        $data     = \DB::table('admin_payment_settings');
        $settings = [];
        if (\Auth::check()) {
            $user_id = 1;
            $data    = $data->where('created_by', '=', $user_id);
        }
        $data = $data->get();
        foreach ($data as $row) {
            $settings[$row->name] = $row->value;
        }

return $settings;
    }

public static function getCompanyPaymentSetting()
    {

$data     = \DB::table('company_payment_settings');
        $settings = [];
        if (\Auth::check()) {
            $user_id = \Auth::user()->creatorId();
            $data    = $data->where('created_by', '=', $user_id);
        }
        $data = $data->get();
        foreach ($data as $row) {
            $settings[$row->name] = $row->value;
        }

return $settings;
    }

public static function error_res($msg = "", $args = array())
    {
        $msg       = $msg == "" ? "error" : $msg;
        $msg_id    = 'error.' . $msg;
        $converted = \Lang::get($msg_id, $args);
        $msg       = $msg_id == $converted ? $msg : $converted;
        $json      = array(
            'flag' => 0,
            'msg' => $msg,
        );

return $json;
    }

public static function success_res($msg = "", $args = array())
    {
        $msg       = $msg == "" ? "success" : $msg;
        $msg_id    = 'success.' . $msg;
        $converted = \Lang::get($msg_id, $args);
        $msg       = $msg_id == $converted ? $msg : $converted;
        $json      = array(
            'flag' => 1,
            'msg' => $msg,
        );

return $json;
    }

public static function getselectedThemeColor()
    {
        $color = env('THEME_COLOR');
        if ($color == "" || $color == null) {
            $color = 'blue';
        }
        return $color;
    }

public static function getAllThemeColors()
    {
        $colors = [
            'blue', 'denim', 'sapphire', 'olympic', 'violet', 'black', 'cyan', 'dark-blue-natural', 'gray-dark', 'light-blue', 'light-purple', 'magenta', 'orange-mute', 'pale-green', 'rich-magenta', 'rich-red', 'sky-gray'
        ];
        return $colors;
    }
    public static function getDateFormated($date, $time = false)
    {
        if (!empty($date) && $date != '0000-00-00') {
            if ($time == true) {
                return date("d M Y H:i A", strtotime($date));
            } else {
                return date("d M Y", strtotime($date));
            }
        } else {
            return '';
        }
    }

public static function getCompanySetting($user_id)
    {

$data = DB::table('settings');
        $settings = [];

$data   = $data->where('created_by', '=', $user_id);
        $data = $data->get();

foreach ($data as $row) {
            $settings[$row->name] = $row->value;
        }
        return $settings;
    }

public static function colorset()
    {
        // if (\Auth::user()) {
        //     $user = \Auth::user();
        //     $setting = DB::table('settings')->pluck('value', 'name')->toArray();
        // } else {
        //     $setting = DB::table('settings')->pluck('value', 'name')->toArray();
        // }
        // return $setting;
        if (\Auth::user()) {
            if (\Auth::user()->type == 'Super Admin') {
                $user = \Auth::user();
                $setting = DB::table('settings')->where('created_by', $user->id)->pluck('value', 'name')->toArray();
            } else {
                $setting = DB::table('settings')->where('created_by', \Auth::user()->creatorId())->pluck('value', 'name')->toArray();
            }
        } else {
            $user = User::where('type', 'Super Admin')->first();
            $setting = DB::table('settings')->where('created_by', 1)->pluck('value', 'name')->toArray();
            
        }
        if (!isset($setting['color'])) {
            $setting = Utility::settings();
        }
        return $setting;
    }

public static function get_superadmin_logo()
    {

$is_dark_mode = self::getValByName('cust_darklayout');
        if ($is_dark_mode == 'on') {
            return 'logo-light.png';
        } else {
            return 'logo-dark.png';
        }
    }
    public static function get_company_logo()
    {

$is_dark_mode = self::getValByName('cust_darklayout');

if ($is_dark_mode == 'on') {
            $logo = self::getValByName('cust_darklayout');
            return Utility::getValByName('company_logo_light');
        } else {
            return Utility::getValByName('company_logo_dark');
        }
    }

public static function sendEmailTemplate($emailTemplate, $mailTo, $obj, $user_id=null)
    {
        // dd($emailTemplate);
        if(!empty($user_id)){
            $usr = User::where('id',$user_id)->first();
        }else{
            $usr = \Auth::user();
        }

//Remove Current Login user Email don't send mail to them
        unset($mailTo[$usr->id]);

$mailTo = array_values($mailTo);

// if($usr->type != 'super admin')
        // {

// find template is exist or not in our record
            $template = EmailTemplate::where('slug', $emailTemplate)->first();
            // dd($template,$emailTemplate);

if(isset($template) && !empty($template))
            {

// check template is active or not by company
                $is_active = UserEmailTemplate::where('template_id', '=', $template->id)->where('user_id', '=', $usr->creatorId())->first();
               // dd($is_active);
                if($is_active->is_active == 1)
                {

if ($usr->type == 'Super Admin') {
                        $settings = [
                            'MAIL_DRIVER' => env('MAIL_DRIVER'),
                            'MAIL_HOST' => env('MAIL_HOST'),
                            'MAIL_PORT' =>  env('MAIL_PORT'),
                            'MAIL_USERNAME' => env('MAIL_USERNAME'),
                            'MAIL_PASSWORD' => env('MAIL_PASSWORD'),
                            'MAIL_ENCRYPTION' => env('MAIL_ENCRYPTION'),
                            'MAIL_FROM_ADDRESS' => env('MAIL_FROM_ADDRESS'),
                            'MAIL_FROM_NAME' => env('MAIL_FROM_NAME'),
                        ];
                    }else{
                        $settings = self::settings();
                    }

// get email content language base
                    $content = EmailTemplateLang::where('parent_id', '=', $template->id)->where('lang', 'LIKE', $usr->lang)->first();

$content->from = $template->from;

if(!empty($content->content))
                    {
                        config(
                            [
                                'mail.driver' => $settings['MAIL_DRIVER'],
                                'mail.host' => $settings['MAIL_HOST'],
                                'mail.port' => $settings['MAIL_PORT'],
                                'mail.encryption' => $settings['MAIL_ENCRYPTION'],
                                'mail.username' => $settings['MAIL_USERNAME'],
                                'mail.password' => $settings['MAIL_PASSWORD'],
                                'mail.from.address' => $settings['MAIL_FROM_ADDRESS'],
                                'mail.from.name' => $settings['MAIL_FROM_NAME'],
                            ]
                        );
                        //    dd($content);
                        $content->content = self::replaceVariable($content->content, $obj);

// send email
                        try
                        {
                            // dd(config('mail'),$mailTo,$content, $settings);
                            Mail::to($mailTo)->send(new CommonEmailTemplate($content, $settings));

}
                        catch(\Exception $e)
                        {

$error = __('E-Mail has been not sent due to SMTP configuration');
                        }

if(isset($error))
                        {
                            $arReturn = [
                                'is_success' => false,
                                'error' => $error,
                            ];
                        }
                        else
                        {
                            $arReturn = [
                                'is_success' => true,
                                'error' => false,
                            ];
                        }
                    }
                    else
                    {
                        $arReturn = [
                            'is_success' => false,
                            'error' => __('Mail not send, email is empty'),
                        ];
                    }

return $arReturn;
                }
                else
                {
                    return [
                        'is_success' => true,
                        'error' => false,
                    ];
                }
            }
            else
            {
                return [
                    'is_success' => false,
                    'error' => __('Mail not send, email not found'),
                ];
            }
        // }
    }
    public static function defaultEmail()
    {
        // Email Template
        $emailTemplate = [
            'New user',
            'New Owner',
            'New Customer',
            'New Vendor',
            'New Quote',

];

foreach ($emailTemplate as $eTemp) {
            EmailTemplate::create(
                [
                    'name' => $eTemp,
                    'from' => env('APP_NAME'),
                    'slug' => strtolower(str_replace(' ', '_', $eTemp)),
                    'created_by' => 1,
                ]
            );
        }

$defaultTemplate = [
 'New user' => [
 'subject' => 'New user',
 'lang' => [
 'ar' => 'مرحبًا, {user_name} !
 مرحبًا بك في التطبيق الخاص بنا تفاصيل تسجيل الدخول الخاصة بـ {app_name} هو 
 البريد الإلكتروني : {user_email}
 كلمة المرور : {user_password}
 عنوان url للتطبيق : {app_url}
 شكرا لتواصلك معنا،
 {app_name}',

'da' => 'Hej, {user_name} !
 Velkommen til vores app, hvor du kan logge ind {app_name} er 
 E-mail : {user_email}
 Adgangskode : {user_password}
 App url : {app_url}
 Tak fordi du tog kontakt med os,
 {app_name}',

'de' => 'Hallo, {user_name} !
 Willkommen in unserer App für Ihre Login-Daten {app_name} ist 
 Email : {user_email}
 Passwort : {user_password}
 App-URL : {app_url}
 Danke, dass Sie sich mit uns verbunden haben,
 {app_name}',

'en' => 'Hello, {user_name} !
 Welcome to our app yore login detail for {app_name} is 
 Email : {user_email}
 Password : {user_password}
 App url : {app_url}
 Thank you for connecting with us,
 {app_name}',

'es' => 'Hola, {user_name} !
 Bienvenido a nuestra aplicación antaño detalles de inicio de sesión para {app_name} es 
 Correo electrónico : {user_email}
 Clave : {user_password}
 URL de la aplicación : {app_url}
 Gracias por conectar con nosotras,
 {app_name}',

'fr' => 'Bonjour, {user_name} !
 Bienvenue sur notre application autrefois les informations de connexion pour {app_name} est 
 E-mail : {user_email}
 Mot de passe : {user_password}
 URL de l\'application : {app_url}
 Merci de nous avoir contacté,
 {app_name}',

'it' => 'Ciao, {user_name} !
 Benvenuto nella nostra app per i tuoi dati di accesso {app_name} è 
 E-mail : {user_email}
 Parola d\'ordine : {user_password}
 URL dell\'app : {app_url}
 Grazie per esserti connesso con noi,
 {app_name}',

'ja' => 'こんにちは, {user_name} !
 私たちのアプリのyoreログインの詳細へようこそ {app_name} は 
 Eメール : {user_email}
 パスワード : {user_password}
 アプリのURL : {app_url}
 ご連絡ありがとうございます,
 {app_name}',

'nl' => 'Hallo, {user_name} !
 Welkom bij de inloggegevens van onze app voor: {app_name} is 
 E-mail : {user_email}
 Wachtwoord : {user_password}
 App-URL : {app_url}
 Bedankt voor het contact met ons,
 {app_name}',

'pl' => 'Witam, {user_name} !
 Witamy w naszej aplikacji yore dane logowania do {app_name} jest 
 E-mail : {user_email}
 Hasło : {user_password}
 URL aplikacji : {app_url}
 Dziękujemy za kontakt z nami,
 {app_name}',

'ru' => 'Привет, {user_name} !
 Добро пожаловать в наше приложение. {app_name} является 
 Эл. адрес : {user_email}
 Пароль : {user_password}
 URL приложения : {app_url}
 Спасибо, что связались с нами,
 {app_name}',

'pt' => 'Olá, {user_name} !
 Bem-vindo ao nosso aplicativo antigo detalhe de login para {app_name} é 
 E-mail : {user_email}
 Senha : {user_password}
 URL do aplicativo : {app_url}
 Obrigado por conectar com a gente,
 {app_name}',

'tr' => 'Merhaba, {user_name} !
 Uygulamamıza hoş geldiniz, eski {app_name} için giriş ayrıntısı 
 E-posta : {user_email}
 Parola : {user_password}
 Uygulama url : {app_url}
 Bizimle bağlantı kurduğunuz için teşekkür ederiz,
 {app_name}',

'he' => 'שלום, {user_name} !
 ברוך הבא לאפליקציה שלנו, פרטי ההתחברות של {app_name} הוא 
 דוא"ל: {user_email}
 סיסמה: {user_password}
 כתובת אתר של אפליקציה: {app_url}
 תודה שהתחברת אלינו,
 {app_name}',

'zh' => '您好， {user_name} ！
 欢迎使用我们的应用， {app_name} 的登录详细信息是 
 电子邮件：{user_email}
 密码：{user_password}
 应用程序网址：{app_url}
 感谢您与我们联系，
 {app_name}',

'pt-br' => 'Olá, {user_name} !
 Bem-vindo ao nosso aplicativo antigo detalhe de login para {app_name} é 
 E-mail : {user_email}
 Senha : {user_password}
 URL do aplicativo : {app_url}
 Obrigado por conectar com a gente,
 {app_name}',
 ],
 ],
 'New Owner' => [
 'subject' => 'New Owner',
 'lang' => [
 'ar' => 'مرحبًا, {owner_name} !
 مرحبًا بك في التطبيق الخاص بنا تفاصيل تسجيل الدخول الخاصة بـ {app_name} هو 
 البريد الإلكتروني : {owner_email}
 كلمة المرور : {owner_password}
 عنوان url للتطبيق : {app_url}
 شكرا لتواصلك معنا،
 {app_name}',

'da' => 'Hej, {owner_name} !
 Velkommen til vores app, hvor du kan logge ind {app_name} er 
 E-mail : {owner_email}
 Adgangskode : {owner_password}
 App url : {app_url}
 Tak fordi du tog kontakt med os,
 {app_name}',

'de' => 'Hallo, {owner_name} !
 Willkommen in unserer App für Ihre Login-Daten {app_name} ist 
 Email : {owner_email}
 Passwort : {owner_password}
 App-URL : {app_url}
 Danke, dass Sie sich mit uns verbunden haben,
 {app_name}',

'en' => 'Hello, {owner_name} !
 Welcome to our app yore login detail for {app_name} is 
 Email : {owner_email}
 Password : {owner_password}
 App url : {app_url}
 Thank you for connecting with us,
 {app_name}',

'es' => 'Hola, {owner_name} !
 Bienvenido a nuestra aplicación antaño detalles de inicio de sesión para {app_name} es 
 Correo electrónico : {owner_email}
 Clave : {owner_password}
 URL de la aplicación : {app_url}
 Gracias por conectar con nosotras,
 {app_name}',

'fr' => 'Bonjour, {owner_name} !
 Bienvenue sur notre application autrefois les informations de connexion pour {app_name} est 
 E-mail : {owner_email}
 Mot de passe : {owner_password}
 URL de l\'application : {app_url}
 Merci de nous avoir contacté,
 {app_name}',

'it' => 'Ciao, {owner_name} !
 Benvenuto nella nostra app per i tuoi dati di accesso {app_name} è 
 E-mail : {owner_email}
 Parola d\'ordine : {owner_password}
 URL dell\'app : {app_url}
 Grazie per esserti connesso con noi,
 {app_name}',

'ja' => 'こんにちは, {owner_name} !
 私たちのアプリのyoreログインの詳細へようこそ {app_name} は 
 Eメール : {owner_email}
 パスワード : {owner_password}
 アプリのURL : {app_url}
 ご連絡ありがとうございます,
 {app_name}',

'nl' => 'Hallo, {owner_name} !
 Welkom bij de inloggegevens van onze app voor: {app_name} is 
 E-mail : {owner_email}
 Wachtwoord : {owner_password}
 App-URL : {app_url}
 Bedankt voor het contact met ons,
 {app_name}',

'pl' => 'Witam, {owner_name} !
 Witamy w naszej aplikacji yore dane logowania do {app_name} jest 
 E-mail : {owner_email}
 Hasło : {owner_password}
 URL aplikacji : {app_url}
 Dziękujemy za kontakt z nami,
 {app_name}',

'ru' => 'Привет, {owner_name} !
 Добро пожаловать в наше приложение. {app_name} является 
 Эл. адрес : {owner_email}
 Пароль : {owner_password}
 URL приложения : {app_url}
 Спасибо, что связались с нами,
 {app_name}',

'pt' => 'Olá, {owner_name} !
 Bem-vindo ao nosso aplicativo antigo detalhe de login para {app_name} é 
 E-mail : {owner_email}
 Senha : {owner_password}
 URL do aplicativo : {app_url}
 Obrigado por conectar com a gente,
 {app_name}',

'tr' => 'Merhaba, {owner_name} !
 Uygulamamıza hoş geldiniz, eski {app_name} için giriş ayrıntısı 
 E-posta : {owner_email}
 Şifre : {owner_password}
 Uygulama url : {app_url}
 Bizimle bağlantı kurduğunuz için teşekkür ederiz,
 {app_name}',

'he' => 'שלום, {owner_name} !
 ברוך הבא לאפליקציה שלנו, פרטי ההתחברות של {app_name} הוא 
 דוא"ל: {owner_email}
 סיסמה: {owner_password}
 כתובת אתר של אפליקציה: {app_url}
 תודה שהתחברת אלינו,
 {app_name}',

'zh' => '您好， {owner_name} ！
 欢迎使用我们的应用， {app_name} 的登录详细信息是 
 电子邮件：{owner_email}
 密码：{owner_password}
 应用程序网址：{app_url}
 感谢您与我们联系，
 {app_name}',

'pt-br' => 'Olá, {owner_name} !
 Bem-vindo ao nosso aplicativo antigo detalhe de login para {app_name} é 
 E-mail : {owner_email}
 Senha : {owner_password}
 URL do aplicativo : {app_url}
 Obrigado por conectar com a gente,
 {app_name}',
 ],
 ],

'New Customer' => [
 'subject' => 'New Customer',
 'lang' => [
 'ar' => 'مرحبًا, {customer_name} !
 مرحبًا بك في التطبيق الخاص بنا تفاصيل تسجيل الدخول الخاصة بـ {app_name} هو 
 البريد الإلكتروني : {customer_email}
 عنوان url للتطبيق : {app_url}
 عنوان العميل : {customer_address}
 بلد العميل : {customer_country}
 الرمز البريدي للعميل : {customer_zipcode}
 شكرا لتواصلك معنا,
 {app_name}',

'da' => 'Hej, {customer_name} !
 Velkommen til vores app, hvor du kan logge ind {app_name} er 
 E-mail : {customer_email}
 App url : {app_url}
 Kundeadresse : {customer_address}
 Kundeland : {customer_country}
 Kundens postnummer : {customer_zipcode}
 Tak fordi du tog kontakt med os,
 {app_name}',

'de' => 'Hallo, {customer_name} !
 Willkommen in unserer App für Ihre Login-Daten {app_name} ist 
 Email : {customer_email}
 App-URL : {app_url}
 Kundenadresse : {customer_address}
 Kundenland : {customer_country}
 Postleitzahl des Kunden : {customer_zipcode}
 Vielen Dank, dass Sie sich mit uns verbunden haben,
 {app_name}',

'en' => 'Hello, {customer_name} !
 Welcome to our app yore login detail for {app_name} is 
 Email : {customer_email}
 App url : {app_url}
 Customer Address : {customer_address}
 Customer Country : {customer_country}
 Customer Zipcode : {customer_zipcode}
 Thank you for connecting with us,
 {app_name}',

'es' => 'Hola, {customer_name} !
 Bienvenido a nuestra aplicación antaño detalles de inicio de sesión para {app_name} es 
 Correo electrónico : {customer_email}
 URL de la aplicación : {app_url}
 Dirección del cliente : {customer_address}
 País del cliente : {customer_country}
 Código postal del cliente : {customer_zipcode}
 Gracias por conectar con nosotros,
 {app_name}',

'fr' => 'Bonjour, {customer_name} !
 Bienvenue sur notre application autrefois les informations de connexion pour {app_name} est 
 E-mail : {customer_email}
 URL de l\'application : {app_url}
 Adresse du client : {customer_address}
 Pays du client : {customer_country}
 Code postal du client : {customer_zipcode}
 Merci de nous avoir contacté,
 {app_name}',

'it' => 'Ciao, {customer_name} !
 Benvenuto nella nostra app per i tuoi dati di accesso {app_name} è 
 E-mail : {customer_email}
 URL dell\'app : {app_url}
 Indirizzo del cliente : {customer_address}
 Paese cliente : {customer_country}
 Codice postale del cliente : {customer_zipcode}
 Grazie per esserti connesso con noi,
 {app_name}',

'ja' => 'こんにちは, {customer_name} !
 私たちのアプリのyoreログインの詳細へようこそ {app_name} は 
 Eメール : {customer_email}
 アプリのURL : {app_url}
 お客様の住所 : {customer_address}
 顧客の国 : {customer_country}
 顧客の郵便番号 : {customer_zipcode}
 ご連絡ありがとうございます,
 {app_name}',

'nl' => 'Hallo, {customer_name} !
 Welkom bij de inloggegevens van onze app voor: {app_name} is 
 E-mail : {customer_email}
 App-URL : {app_url}
 Klant adres : {customer_address}
 Land van klant : {customer_country}
 Postcode klant : {customer_zipcode}
 Bedankt voor het contact met ons,
 {app_name}',

'pl' => 'Witam, {customer_name} !
 Witamy w naszej aplikacji yore dane logowania do {app_name} jest 
 E-mail : {customer_email}
 URL aplikacji : {app_url}
 Adres klienta : {customer_address}
 Kraj klienta : {customer_country}
 Kod pocztowy klienta : {customer_zipcode}
 Dziękujemy za kontakt z nami,
 {app_name}',

'ru' => 'Привет, {customer_name} !
 Добро пожаловать в наше приложение. {app_name} является 
 Эл. адрес : {customer_email}
 URL приложения : {app_url}
 Адрес клиента : {customer_address}
 Страна клиента : {customer_country}
 Страна клиента : {customer_zipcode}
 Спасибо, что связались с нами,
 {app_name}',

'pt' => 'Olá, {customer_name} !
 Bem-vindo ao nosso aplicativo antigo detalhe de login para {app_name} é 
 E-mail : {customer_email}
 URL do aplicativo : {app_url}
 Endereço do cliente : {customer_address}
 País do cliente : {customer_country}
 CEP do cliente : {customer_zipcode}
 Obrigado por conectar com a gente,
 {app_name}',

'tr' => 'Merhaba, {customer_name} !
 Uygulamamıza hoş geldiniz, eski {app_name} için giriş ayrıntısı 
 E-posta : {customer_email}
 Uygulama url : {app_url}
 Müşteri Adresi : {customer_address}
 Müşteri Ülkesi : {customer_country}
 Müşteri Posta Kodu : {customer_zipcode}
 Bizimle bağlantı kurduğunuz için teşekkür ederiz,
 {app_name}',

'he' => 'שלום, {customer_name} !
 ברוך הבא לאפליקציה שלנו, פרטי ההתחברות של {app_name} הוא 
 דוא"ל: {customer_email}
 כתובת אתר של אפליקציה: {app_url}
 כתובת לקוח: {customer_address}
 ארץ לקוח: {customer_country}
 מיקוד לקוח : {customer_zipcode}
 תודה שהתחברת אלינו,
 {app_name}',

'zh' => '您好， {customer_name} ！
 欢迎使用我们的应用， {app_name} 的登录详细信息是 
 电子邮件：{customer_email}
 应用程序网址：{app_url}
 客户地址：{customer_address}
 客户国家/地区：{customer_country}
 客户邮政编码：{customer_zipcode}
 感谢您与我们联系，
 {app_name}',

'pt-br' => 'Olá, {customer_name} !
 Bem-vindo ao nosso aplicativo antigo detalhe de login para {app_name} é 
 E-mail : {customer_email}
 URL do aplicativo : {app_url}
 Endereço do cliente : {customer_address}
 País do cliente : {customer_country}
 CEP do cliente : {customer_zipcode}
 Obrigado por conectar com a gente,
 {app_name}',
 ],
 ],

'New Vendor' => [
 'subject' => 'New Vendor',
 'lang' => [
 'ar' => 'مرحبًا, {vendor_name} !
 مرحبًا بك في التطبيق الخاص بنا تفاصيل تسجيل الدخول الخاصة بـ {app_name} هو 
 البريد الإلكتروني : {vendor_email}
 عنوان url للتطبيق : {app_url}
 عنوان البائع : {vendor_address}
 بلد البائع : {vendor_country}
 الرمز البريدي للبائع : {vendor_zipcode}
 شكرا لتواصلك معنا,
 {app_name}',

'da' => 'Hej, {vendor_name} !
 Velkommen til vores app, hvor du kan logge ind {app_name} er 
 E-mail : {vendor_email}
 App url : {app_url}
 Leverandørens adresse : {vendor_address}
 Leverandørland : {vendor_country}
 Leverandørens postnummer : {vendor_zipcode}
 Tak fordi du tog kontakt med os,
 {app_name}',

'de' => 'Hallo, {vendor_name} !
 Willkommen in unserer App für Ihre Login-Daten {app_name} ist 
 Email : {vendor_email}
 App-URL : {app_url}
 Adresse des Anbieters : {vendor_address}
 Land des Anbieters : {vendor_country}
 Postleitzahl des Anbieters : {vendor_zipcode}
 Vielen Dank, dass Sie sich mit uns verbunden haben,
 {app_name}',

'en' => 'Hello, {vendor_name} !
 Welcome to our app yore login detail for {app_name} is 
 Email : {vendor_email}
 App url : {app_url}
 Vendor Address : {vendor_address}
 Vendor Country : {vendor_country}
 Vendor Zipcode : {vendor_zipcode}
 Thank you for connecting with us,
 {app_name}',

'es' => 'Hallo, {vendor_name} !
 Willkommen in unserer App für Ihre Login-Daten {app_name} ist 
 Email : {vendor_email}
 App-URL : {app_url}
 Adresse des Anbieters : {vendor_address}
 Land des Anbieters : {vendor_country}
 Postleitzahl des Anbieters : {vendor_zipcode}
 Vielen Dank, dass Sie sich mit uns verbunden haben,
 {app_name}',

'fr' => 'Bonjour, {vendor_name} !
 Bienvenue sur notre application autrefois les informations de connexion pour {app_name} est 
 E-mail : {vendor_email}
 URL de l\'application : {app_url}
 Adresse du vendeur : {vendor_address}
 Pays du vendeur : {vendor_country}
 Code postal du vendeur : {vendor_zipcode}
 Merci de nous avoir contacté,
 {app_name}',

'it' => 'Ciao, {vendor_name} !
 Benvenuto nella nostra app per i tuoi dati di accesso {app_name} è 
 E-mail : {vendor_email}
 URL dell\'app : {app_url}
 Indirizzo del venditore : {vendor_address}
 Paese fornitore : {vendor_country}
 Codice postale del venditore : {vendor_zipcode}
 Grazie per esserti connesso con noi,
 {app_name}',

'ja' => 'こんにちは, {vendor_name} !
 私たちのアプリのyoreログインの詳細へようこそ {app_name} は 
 Eメール : {vendor_email}
 アプリのURL : {app_url}
 ベンダーの住所 : {vendor_address}
 ベンダーの国 : {vendor_country}
 ベンダーの郵便番号 : {vendor_zipcode}
 ご連絡ありがとうございます,
 {app_name}',

'nl' => 'Hallo, {vendor_name} !
 Welkom bij de inloggegevens van onze app voor: {app_name} is 
 E-mail : {vendor_email}
 App-URL : {app_url}
 Adres leverancier : {vendor_address}
 Land van leverancier : {vendor_country}
 Postcode leverancier : {vendor_zipcode}
 Bedankt voor het contact met ons,
 {app_name}',

'pl' => 'Witam, {vendor_name} !
 Witamy w naszej aplikacji yore dane logowania do {app_name} jest 
 E-mail : {vendor_email}
 URL aplikacji : {app_url}
 Adres dostawcy : {vendor_address}
 Kraj dostawcy : {vendor_country}
 Kod pocztowy dostawcy : {vendor_zipcode}
 Dziękujemy za kontakt z nami,
 {app_name}',

'ru' => 'Привет, {vendor_name} !
 Добро пожаловать в наше приложение. {app_name} является 
 Эл. адрес : {vendor_email}
 URL приложения : {app_url}
 Адрес поставщика : {vendor_address}
 Страна поставщика : {vendor_country}
 Почтовый индекс поставщика : {vendor_zipcode}
 Спасибо, что связались с нами,
 {app_name}',

'pt' => 'Olá, {vendor_name} !
 Bem-vindo ao nosso aplicativo antigo detalhe de login para {app_name} é 
 E-mail : {vendor_email}
 URL do aplicativo : {app_url}
 Endereço do fornecedor : {vendor_address}
 País do fornecedor : {vendor_country}
 CEP do fornecedor : {vendor_zipcode}
 Obrigado por conectar com a gente,
 {app_name}',

'tr' => 'Merhaba, {vendor_name} !
 Uygulamamıza hoş geldiniz, eski {app_name} için giriş ayrıntısı 
 E-posta : {vendor_email}
 Uygulama urlsi : {app_url}
 Satıcı Adresi : {vendor_address}
 Satıcı Ülke : {vendor_country}
 Satıcı Posta Kodu : {vendor_zipcode}
 Bizimle bağlantı kurduğunuz için teşekkür ederiz,
 {app_name}',

'he' => 'שלום, {vendor_name} !
 ברוך הבא לאפליקציה שלנו, פרטי ההתחברות של {app_name} הוא 
 דוא"ל: {vendor_email}
 כתובת אתר של אפליקציה: {app_url}
 כתובת ספק: {vendor_address}
 ארץ הספק: {vendor_country}
 מיקוד הספק: {vendor_zipcode}
 תודה שהתחברת אלינו,
 {app_name}',

'zh' => '您好， {vendor_name} ！
 欢迎使用我们的应用， {app_name} 的登录详细信息是 
 电子邮件：{vendor_email}
 应用程序网址：{app_url}
 供应商地址：{vendor_address}
 供应商国家/地区：{vendor_country}
 供应商邮政编码：{vendor_zipcode}
 感谢您与我们联系，
 {app_name}',

'pt-br' => 'Olá, {vendor_name} !
 Bem-vindo ao nosso aplicativo antigo detalhe de login para {app_name} é 
 E-mail : {vendor_email}
 URL do aplicativo : {app_url}
 Endereço do fornecedor : {vendor_address}
 País do fornecedor : {vendor_country}
 CEP do fornecedor : {vendor_zipcode}
 Obrigado por conectar com a gente,
 {app_name}',
 ],
 ],

'New Quote' => [
 'subject' => 'New Quote',
 'lang' => [
 'ar' => 'مرحبًا, {quotation_customers} !
 مرحبًا بك في التطبيق الخاص بنا تفاصيل تسجيل الدخول الخاصة بـ {app_name} هو 
 البريد الإلكتروني : {customer_email}
 عنوان url للتطبيق : {app_url}
 رقم مرجع الاقتباس : {quotation_reference_no}
 تاريخ الاقتباس : {quotation_date}
 شكرا لتواصلك معنا,
 {app_name}',

'da' => 'Hej, {quotation_customers} !
 Velkommen til vores app, hvor du kan logge ind {app_name} er 
 E-mail : {customer_email}
 App url : {app_url}
 Tilbudsreferencenr : {quotation_reference_no}
 Tilbudsdato : {quotation_date}
 Tak fordi du tog kontakt med os,
 {app_name}',

'de' => 'Hallo, {quotation_customers} !
 Willkommen in unserer App für Ihre Login-Daten {app_name} ist 
 Email : {customer_email}
 App-URL : {app_url}
 Zitat-Referenz-Nr : {quotation_reference_no}
 Angebotsdatum : {quotation_date}
 Vielen Dank, dass Sie sich mit uns verbunden haben,
 {app_name}',

'en' => 'Hello, {quotation_customers} !
 Welcome to our app yore login detail for {app_name} is 
 Email : {customer_email}
 App url : {app_url}
 Quotation Reference No : {quotation_reference_no}
 Quotation Date : {quotation_date}
 Thank you for connecting with us,
 {app_name}',

'es' => 'Hola, {quotation_customers} !
 Bienvenido a nuestra aplicación antaño detalles de inicio de sesión para {app_name} es 
 Correo electrónico : {customer_email}
 URL de la aplicación : {app_url}
 Número de referencia de cotización : {quotation_reference_no}
 Fecha de cotización : {quotation_date}
 Gracias por conectar con nosotras,
 {app_name}',

'fr' => 'Bonjour, {quotation_customers} !
 Bienvenue sur notre application autrefois les informations de connexion pour {app_name} est 
 E-mail : {customer_email}
 URL de l\'application : {app_url}
 Référence du devis Non : {quotation_reference_no}
 Date de cotation : {quotation_date}
 Merci de nous avoir contacté,
 {app_name}',

'it' => 'Ciao, {quotation_customers} !
 Benvenuto nella nostra app per i tuoi dati di accesso {app_name} è 
 E-mail : {customer_email}
 URL dell\'app : {app_url}
 Riferimento preventivo n : {quotation_reference_no}
 Data di preventivo : {quotation_date}
 Grazie per esserti connesso con noi,
 {app_name}',

'ja' => 'こんにちは, {quotation_customers} !
 私たちのアプリのyoreログインの詳細へようこそ {app_name} は 
 Eメール : {customer_email}
 アプリのURL : {app_url}
 見積もり参照番号 : {quotation_reference_no}
 見積もり日 : {quotation_date}
 ご連絡ありがとうございます,
 {app_name}',

'nl' => 'Hallo, {quotation_customers} !
 Welkom bij de inloggegevens van onze app voor: {app_name} is 
 E-mail : {customer_email}
 App-URL : {app_url}
 Referentienummer offerte: : {quotation_reference_no}
 Offertedatum: : {quotation_date}
 Bedankt voor het contact met ons,
 {app_name}',

'pl' => 'Witam, {quotation_customers} !
 Witamy w naszej aplikacji yore dane logowania do {app_name} jest 
 E-mail : {customer_email}
 URL aplikacji : {app_url}
 Numer referencyjny oferty : {quotation_reference_no}
 Data wyceny : {quotation_date}
 Dziękujemy za kontakt z nami,
 {app_name}',

'ru' => 'Привет, {quotation_customers} !
 Добро пожаловать в наше приложение. {app_name} является 
 Эл. адрес : {customer_email}
 URL приложения : {app_url}
 Цитата Номер ссылки : {quotation_reference_no}
 Дата котировки : {quotation_date}
 Спасибо, что связались с нами,
 {app_name}',

'pt' => 'Olá, {quotation_customers} !
 Bem-vindo ao nosso aplicativo antigo detalhe de login para {app_name} é 
 E-mail : {customer_email}
 URL do aplicativo : {app_url}
 Nº de referência de cotação : {quotation_reference_no}
 Data de cotação : {quotation_date}
 Obrigado por conectar com a gente,
 {app_name}',

'tr' => 'Merhaba, {quotation_customers} !
 Uygulamamıza hoş geldiniz, eski {app_name} için giriş ayrıntısı 
 E-posta : {customer_email}
 Uygulama url : {app_url}
 Teklif Referans No : {quotation_reference_no}
 Teklif Tarihi : {quotation_date}
 Bizimle bağlantı kurduğunuz için teşekkür ederiz,
 {app_name}',

'he' => 'שלום, {quotation_customers} !
 ברוך הבא לאפליקציה שלנו, פרטי ההתחברות של {app_name} הוא 
 דוא"ל: {customer_email}
 כתובת אתר של אפליקציה: {app_url}
 מספר סימוכין להצעת מחיר: {quotation_reference_no}
 תאריך הצעת מחיר: {quotation_date}
 תודה שהתחברת אלינו,
 {app_name}',

'zh' => '您好， {quotation_customers} ！
 欢迎使用我们的应用， {app_name} 的登录详细信息是 
 电子邮件：{customer_email}
 应用程序网址：{app_url}
 报价参考编号：{quotation_reference_no}
 报价日期：{quotation_date}
 感谢您与我们联系，
 {app_name}',

'pt-br' => 'Olá, {quotation_customers} !
 Bem-vindo ao nosso aplicativo antigo detalhe de login para {app_name} é 
 E-mail : {customer_email}
 URL do aplicativo : {app_url}
 Nº de referência de cotação : {quotation_reference_no}
 Data de cotação : {quotation_date}
 Obrigado por conectar com a gente,
 {app_name}',
 ],
 ],
 ];

$email = EmailTemplate::all();

foreach ($email as $e) {
            foreach ($defaultTemplate[$e->name]['lang'] as $lang => $content) {
                EmailTemplateLang::create(
                    [
                        'parent_id' => $e->id,
                        'lang' => $lang,
                        'subject' => $defaultTemplate[$e->name]['subject'],
                        'content' => $content,
                    ]
                );
            }
        }
    }

public static function userDefaultData()
    {
        $userid=[1,2];
        // Make Entry In User_Email_Template
        foreach ($userid as $id) {

$allEmail = EmailTemplate::all();
            foreach ($allEmail as $email) {
                UserEmailTemplate::create(
                    [
                        'template_id' => $email->id,
                        'user_id' => $id,
                        'is_active' => 1,
                    ]
                );
            }
        }

}

public static function replaceVariable($content, $obj)
    {
        $arrVariable = [
            '{user_name}',
            '{user_email}',
            '{user_password}',
            '{owner_name}',
            '{owner_email}',
            '{owner_password}',
            '{vendor_name}',
            '{vendor_email}',
            '{vendor_phone_number}',
            '{vendor_address}',
            '{vendor_country}',
            '{vendor_zipcode}',
            '{customer_name}',
            '{customer_email}',
            '{customer_phone_number}',
            '{customer_address}',
            '{customer_country}',
            '{customer_zipcode}',
            '{quotation_date}',
            '{quotation_reference_no}',
            '{quotation_customers}',
            '{app_name}',
            '{company_name}',
            '{app_url}',
            '{email}',
            '{password}',
        ];
        $arrValue    = [
            'user_name' => '-',
            'user_email' => '-',
            'user_password' => '-',
            'owner_name' => '-',
            'owner_email' => '-',
            'owner_password' => '-',
            'vendor_name' => '-',
            'vendor_email' => '-',
            'vendor_phone_number' => '-',
            'vendor_address' => '-',
            'vendor_country' => '-',
            'vendor_zipcode' => '-',
            'customer_name' => '-',
            'customer_email' => '-',
            'customer_phone_number' => '-',
            'customer_address' => '-',
            'customer_country' => '-',
            'customer_zipcode' => '-',
            'quotation_date' => '-',
            'quotation_reference_no' => '-',
            'quotation_customers' => '-',
            'app_name' => '-',
            'company_name' => '-',
            'app_url' => '-',
            'email' => '-',
            'password' => '-',
        ];

foreach($obj as $key => $val)
        {
            $arrValue[$key] = $val;
        }

$settings = Utility::settings();
        $company_name = $settings['company_name'];

$arrValue['app_name'] = (isset($company_name)&&!empty($company_name)) ? $company_name : env('APP_NAME');//$company_name;
 $arrValue['company_name'] = self::settings()['company_name'];
 $arrValue['app_url'] = '<a href="' . env('APP_URL') . '" target="_blank">' . env('APP_URL') . '</a>';

return str_replace($arrVariable, array_values($arrValue), $content);
    }

public static function upload_file($request,$key_name,$name,$path,$custom_validation =[]){

try{
            $settings = Utility::getStorageSetting();
            // dd($settings);
            if(!empty($settings['storage_setting'])){
                if($settings['storage_setting'] == 'wasabi'){

config(
                        [
                            'filesystems.disks.wasabi.key' => $settings['wasabi_key'],
                            'filesystems.disks.wasabi.secret' => $settings['wasabi_secret'],
                            'filesystems.disks.wasabi.region' => $settings['wasabi_region'],
                            'filesystems.disks.wasabi.bucket' => $settings['wasabi_bucket'],
                            'filesystems.disks.wasabi.endpoint' => 'https://s3.'.$settings['wasabi_region'].'.wasabisys.com'
                        ]
                    );

$max_size = !empty($settings['wasabi_max_upload_size'])? $settings['wasabi_max_upload_size']:'2048';
                    $mimes =  !empty($settings['wasabi_storage_validation'])? $settings['wasabi_storage_validation']:'';

}else if($settings['storage_setting'] == 's3'){
                    config(
                        [
                            'filesystems.disks.s3.key' => $settings['s3_key'],
                            'filesystems.disks.s3.secret' => $settings['s3_secret'],
                            'filesystems.disks.s3.region' => $settings['s3_region'],
                            'filesystems.disks.s3.bucket' => $settings['s3_bucket'],
                            'filesystems.disks.s3.use_path_style_endpoint' => false,
                        ]
                    );
                    $max_size = !empty($settings['s3_max_upload_size'])? $settings['s3_max_upload_size']:'2048';
                    $mimes =  !empty($settings['s3_storage_validation'])? $settings['s3_storage_validation']:'';

}else{
                    $max_size = !empty($settings['local_storage_max_upload_size'])? $settings['local_storage_max_upload_size']:'2048';

$mimes =  !empty($settings['local_storage_validation'])? $settings['local_storage_validation']:'';
                }

$file = $request->$key_name;

if(count($custom_validation) > 0){
                    $validation =$custom_validation;
                }else{

$validation =[
                        'mimes:'.$mimes,
                        'max:'.$max_size,
                    ];

}
                $validator = \Validator::make($request->all(), [
                    $key_name =>$validation
                ]);

if($validator->fails()){
                    $res = [
                        'flag' => 0,
                        'msg' => $validator->messages()->first(),
                    ];
                    return $res;
                } else {

$name = $name;

if($settings['storage_setting']=='local')
                    {
                        // dd(storage_path($path));
                        $request->$key_name->move(storage_path($path), $name);

// $request->$key_name->storeAs($path, $name);
                        $path = $path.$name;

// if($settings['storage_setting']=='local'){

//     \Storage::disk()->putFileAs(
                    //         $path,
                    //         $request->file($key_name),
                    //         $name
                    //     );
                    //     $path = $path.$name;
                    }else if($settings['storage_setting'] == 'wasabi'){

$path = \Storage::disk('wasabi')->putFileAs(
                            $path,
                            $file,
                            $name
                        );

// $path = $path.$name;

}else if($settings['storage_setting'] == 's3'){

$path = \Storage::disk('s3')->putFileAs(
                            $path,
                            $file,
                            $name
                        );

// $path = $path.$name;
                    }

$res = [
                        'flag' => 1,
                        'msg'  =>'success',
                        'url'  => $path
                    ];
                    return $res;
                }

}else{
                $res = [
                    'flag' => 0,
                    'msg' => __('Please set proper configuration for storage.'),
                ];
                return $res;
            }

}catch(\Exception $e){
            $res = [
                'flag' => 0,
                'msg' => $e->getMessage(),
            ];
            return $res;
        }
    }

public static function get_file($path){
        $settings = Utility::getStorageSetting();

try {
            if($settings['storage_setting'] == 'wasabi'){
                config(
                    [
                        'filesystems.disks.wasabi.key' => $settings['wasabi_key'],
                        'filesystems.disks.wasabi.secret' => $settings['wasabi_secret'],
                        'filesystems.disks.wasabi.region' => $settings['wasabi_region'],
                        'filesystems.disks.wasabi.bucket' => $settings['wasabi_bucket'],
                        'filesystems.disks.wasabi.endpoint' => 'https://s3.'.$settings['wasabi_region'].'.wasabisys.com'
                    ]
                );
            }elseif($settings['storage_setting'] == 's3'){
                config(
                    [
                        'filesystems.disks.s3.key' => $settings['s3_key'],
                        'filesystems.disks.s3.secret' => $settings['s3_secret'],
                        'filesystems.disks.s3.region' => $settings['s3_region'],
                        'filesystems.disks.s3.bucket' => $settings['s3_bucket'],
                        'filesystems.disks.s3.use_path_style_endpoint' => false,
                    ]
                );
            }

return \Storage::disk($settings['storage_setting'])->url($path);
        } catch (\Throwable $th) {
            return '';
        }
    }

public static function colorCodeData($type)
    {
        if($type == 'event')
        {
            return 1;
        }
        elseif ($type == 'zoom_meeting')
        {
            return 2;
        }
        elseif ($type == 'task')
        {
            return 3;
        }
        elseif ($type == 'appointment')
        {
            return 11;
        }
        elseif ($type == 'rotas')
        {
            return 3;
        }
        elseif ($type == 'holiday')
        {
            return 4;
        }
        elseif ($type == 'call')
        {
            return 10;
        }
        elseif ($type == 'meeting')
        {
            return 5;
        }
        elseif ($type == 'leave')
        {
            return 6;
        }
        elseif ($type == 'work_order')
        {
            return 7;
        }
        elseif ($type == 'lead')
        {
            return 7;
        }
        elseif ($type == 'deal')
        {
            return 8;
        }
        elseif ($type == 'interview_schedule')
        {
            return 9;
        }
        else{
            return 11;
        }

}

public static $colorCode=[
        1=>'event-warning',
        2=>'event-secondary',
        3=>'event-success',
        4=>'event-warning',
        5=>'event-danger',
        6=>'event-dark',
        7=>'event-black',
        8=>'event-info',
        9=>'event-secondary',
        10=>'event-success',
        11=>'event-warning',

];

public static function send_twilio_msg($to,$slug,$obj,$user_id = null)
    {

$notification_template = NotificationTemplates::where('slug',$slug)->first();
// dd($notification_template);
        if (!empty($notification_template) && !empty($obj))
        {
            if(!empty($user_id))
            {
                $user = User::find($user_id);
                // dd($user);
            }
            else
            {
                $user = \Auth::user();
                // dd('hi');
            }
            $curr_noti_tempLang = NotificationTemplateLangs::where('parent_id', '=', $notification_template->id)->where('lang', $user->lang)->where('created_by', '=', $user->id)->first();
            // dd($curr_noti_tempLang);
            if(empty($curr_noti_tempLang))
            {
                $curr_noti_tempLang = NotificationTemplateLangs::where('parent_id', '=', $notification_template->id)->where('lang', $user->lang)->first();
            }
            if(empty($curr_noti_tempLang))
            {
                $curr_noti_tempLang       = NotificationTemplateLangs::where('parent_id', '=', $notification_template->id)->where('lang', 'en')->first();
            }
            if (!empty($curr_noti_tempLang) && !empty($curr_noti_tempLang->content))
            {
                $msg = self::replaceVariable($curr_noti_tempLang->content, $obj);
            }
        }

//    dd($msg);

if (isset($msg))
        {
            $settings = Utility::settingsById($user->id);
            $account_sid = $settings['twilio_sid'];
            $auth_token = $settings['twilio_token'];
            $twilio_number = $settings['twilio_from'];
            try {
                $client = new Client($account_sid, $auth_token);
                $client->messages->create($to, [
                    'from' => $twilio_number,
                    'body' => $msg,
                ]);
            } catch (\Exception $e) {
            }
        }

}

public static function googleCalendarConfig()
    {
        $setting = Utility::settings();
       // $path = storage_path('googlecalender/'.$setting['google_calender_json_file']);
       $path=storage_path($setting['google_calender_json_file']);
        config([
            'google-calendar.default_auth_profile' => 'service_account',
            'google-calendar.auth_profiles.service_account.credentials_json' => $path,
            'google-calendar.auth_profiles.oauth.credentials_json' => $path,
            'google-calendar.auth_profiles.oauth.token_json' => $path,
            'google-calendar.calendar_id' => isset($setting['google_clender_id'])?$setting['google_clender_id']:'',
            'google-calendar.user_to_impersonate' => '',

]);
    }

public static function addCalendarData($request , $type)
    {
        Self::googleCalendarConfig();
        
        $event = new GoogleEvent();
        $event->name = $request->title;
        $event->startDateTime = Carbon::parse($request->start);
        $event->endDateTime = Carbon::parse($request->end);
        $event->colorId = Self::colorCodeData($type);

$event->save();
    }

public static function getCalendarData( $type)
    {

Self::googleCalendarConfig();

$data= GoogleEvent::get();

$type=Self::colorCodeData($type);
        $arrayJson = [];
        foreach($data as $val)
        {
            $end_date=date_create($val->endDateTime);
            date_add($end_date,date_interval_create_from_date_string("1 days"));

if($val->colorId=="$type"){

$arrayJson[] = [
                    "id"=> $val->id,
                    "title" => $val->summary,
                    "start" => $val->startDateTime,
                    "end" => date_format($end_date,"Y-m-d H:i:s"),
                    "className" => Self::$colorCode[$type],
                    "allDay" => true,
                ];
            }

}

return $arrayJson;
    }

public static function getSeoSetting()
    {

$data = DB::table('settings');
        $data = $data->where('created_by', '=', 1);
        $data     = $data->get();
        $settings = [
           
            "meta_image" => "",
            "meta_keywords" => "",
            "meta_description" => "",
        ];

foreach($data as $row)
        {
            $settings[$row->name] = $row->value;
        }

return $settings;
    }

public static function webhookSetting($module)
    {
        
        $webhook = Webhook::where('module', $module)->where('created_by', '=', \Auth::user()->creatorId())->first();
        // dd($webhook);
        if (!empty($webhook)) {
            $url = $webhook->url;
            $method = $webhook->method;
            $reference_url  = "https://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";

$data['method'] = $method;
            $data['reference_url'] = $reference_url;
            $data['url'] = $url;
            return $data;
        }
        return false;
    }
    
    public static function WebhookCall($url = null, $parameter = null, $method = 'POST')
    {

if (!empty($url) && !empty($parameter)) {
            try {

$curlHandle = curl_init($url);
                curl_setopt($curlHandle, CURLOPT_POSTFIELDS, $parameter);
                curl_setopt($curlHandle, CURLOPT_RETURNTRANSFER, true);
                curl_setopt($curlHandle, CURLOPT_CUSTOMREQUEST, strtoupper($method));
                $curlResponse = curl_exec($curlHandle);
                curl_close($curlHandle);
                if (empty($curlResponse)) {
                    return true;
                } else {
                    return false;
                }
            } catch (\Throwable $th) {
                return false;
            }
        } else {
            return false;
        }
    }

public static function updateStorageLimit($owner_id, $image_size)
 {
 $image_size = number_format($image_size / 1048576, 2);
 // dd($image_size);
 $user = User::find($owner_id);
 $plan = Plan::find($user->plan_id);
 
 $total_storage = $user->storage_limit + $image_size;
 // dd($total_storage);
 if($plan->storage_limit <= $total_storage && $plan->storage_limit != -1)
 {

$error= __('Plan storage limit is over so please upgrade the plan.');
            return $error;
        }
        else{
            // dd($user->storage_limit);
            $user->storage_limit = $total_storage;
        }

$user->save();
        return 1;

}

public static function changeStorageLimit($owner_id, $file_path)
    {
        $files =  \File::glob(storage_path($file_path));
        // dd($files);
        $fileSize = 0;
        foreach($files as $file){
            $fileSize += \File::size($file);
        }

$image_size = number_format($fileSize / 1048576, 2);
        $user   = User::find($owner_id);
        $plan   = Plan::find($user->plan_id);
        $total_storage = $user->storage_limit - $image_size;
        $user->storage_limit = $total_storage;
        $user->save();

$status = false;
        foreach($files as $key => $file)
        {
            if(\File::exists($file))
            {
                $status = \File::delete($file);
            }
        }

return true;

}

public static function flagOfCountry(){
        $arr = [
            'ar' => '🇦🇪 ar',
            'da' => '🇩🇰 da',
            'de' => '🇩🇪 de',
            'es' => '🇪🇸 es',
            'fr' => '🇫🇷 fr',
            'it' =>  '🇮🇹 it',
            'ja' => '🇯🇵 ja',
            'nl' => '🇳🇱 nl',
            'pl'=> '🇵🇱 pl',
            'ru' => '🇷🇺 ru',
            'pt' => '🇵🇹 pt',
            'en' => '🇮🇳 en',
            'tr' => '🇹🇷 tr',
            'pt-br' => '🇵🇹 pt-br',
        ];
        return $arr;
    }

public static function get_plan_id(){
        $user_plan = User::where('id',\Auth::user()->creatorId())->pluck('plan_id');
        $plan = Plan::where('id',$user_plan)->first();
        // dd($plan);
        return $plan['enable_chatgpt'];
    }

public static function langList(){
        $languages = [
            "ar" => "Arabic",
            "zh" => "Chinese",
            "da" => "Danish",
            "de" => "German",
            "en" => "English",
            "es" => "Spanish",
            "fr" => "French",
            "he" => "Hebrew",
            "it" => "Italian",
            "ja" => "Japanese",
            "nl" => "Dutch",
            "pl" => "Polish",
            "pt" => "Portuguese",
            "ru" => "Russian",
            "tr" => "Turkish",
            "pt-br" => "Portuguese(Brazil)",
        ];
        return $languages;
    }

public static function languagecreate(){
        
        $languages=Utility::langList();
        foreach($languages as $key => $lang)
        {
            $languageExist = Languages::where('code',$key)->first();
            if(empty($languageExist))
            {
                $language = new Languages();
                $language->code = $key;
                $language->fullName = $lang;
                $language->save();
            }
        }
    }
    public static function langSetting(){
        $data = DB::table('settings');
        $data = $data->where('created_by', '=', 1)->get();
        if (count($data) == 0) {
            $data = DB::table('settings')->where('created_by', '=', 1)->get();
        }
        $settings= [];
        foreach ($data as $row) {
            $settings[$row->name] = $row->value;
        }
        return $settings;
    }

public static function priceFormat($settings, $price)
    {
        return (($settings['site_currency_symbol_position'] == "pre") ? $settings['site_currency_symbol'] : '') . number_format($price, 2) . (($settings['site_currency_symbol_position'] == "post") ? $settings['site_currency_symbol'] : '');
    }

}