Gecko [ unitednationsplay.com ]

Name	Size	Permission	Date
Auth	[ DIR ]	drwxr-xr-x	2018-12-04 21:08
AjaxController.php	23.61 KB	-rw-r--r--	2021-05-31 12:36
AuthController.php	20.44 KB	-rw-r--r--	2022-03-17 06:38
ChatsController.php	48.85 KB	-rw-r--r--	2023-02-17 19:15
Controller.php	361 B	-rw-r--r--	2021-02-09 19:47
Cpayeer.php	4.13 KB	-rw-r--r--	2021-03-29 14:58
HomeController.php	500 B	-rw-r--r--	2021-05-06 16:58
RestController.php	19.57 KB	-rw-r--r--	2023-05-03 17:49

Rename

<?php

namespace App\Http\Controllers;

use App\Events\MessageSent;
use App\Conversation;
use App\Message;
use Illuminate\Http\Request;
use Endroid\QrCode\ErrorCorrectionLevel;
use Endroid\QrCode\LabelAlignment;
use Endroid\QrCode\QrCode;
use Endroid\QrCode\Response\QrCodeResponse;
use Illuminate\Support\Facades\Redirect;
use View;
use Session;
use DB;
use Cookie;
use App\User;
//use QRCode;
use Spatie\Browsershot\Browsershot;
use App\Models\Impacts;
use \YooKassaPayout\Client;

class ChatsController extends Controller
{
    public function __construct()
    {
        //$this->middleware('auth');
    }

public function index(Request $request)
    {

if ($request->get('x')=="i") {

}

if (Session::get('save_string') AND !$request->get('auth')) {
            return Redirect::to('/save/?t='.Session::get('save_string'));
        }
        $d = 'D_100';
//select('#big-unpip')->

/*
        if ($request->get('x')) {
            //->where('id','>',2000000010)
            $users = DB::table('users')->orderBy('id', 'ASC')->get();
            foreach ($users as $u) {
                $prefix = 'f';
                //.'&prefix=f'
                Browsershot::url('https://unitednationsplay.com/unpip?id=' . $u->id.'&prefix=f')->timeout(120)->select('#big-unpip')->hideBackground()->addChromiumArguments(['no-sandbox', 'disable-setuid-sandbox'])->save(app()->request->server->get('DOCUMENT_ROOT') . '/uploads/share/' . $prefix . sprintf('%012d', $u->id) . '.png');
            }
        }
*/

$user_recommender_share = '';

$HWtotal = $balance_total = $total_users = $bonus = $HW = $HWall = $balance = $balance_all = $total_impacts = $total_impacts_increase = $total_impacts_reduce = 0;

$rate = 0.0001;
        $user_id = $recommender = '';
        $user_photo = '/img/AboveNavPanel/RoundBg4Foto.svg';
        $borders = DB::table('borders')->orderBy('id', 'asc')->get();
        $settings = array(
            'rate' => $rate,
            'bottom_border_vw' => $borders[1]->value,
            'top_border_vw' => $borders[0]->value,
            'borders_vw' => 21.63,
            'borders_delta' => ($borders[2]->value-$borders[3]->value),
            'bottom_border' => $borders[3]->value,
            'top_border' => $borders[2]->value
        );
        $countries = DB::table('indicator')->orderBy('id', 'asc')->get();

$qrcode = '';

if ($request->cookie("unitednationsplay_top_10_all")=='2' OR !$request->cookie("unitednationsplay_top_10_all"))
            $users_top_list = DB::table('users')->where('id','!=',1111111111)->orderBy('HW_all', 'DESC')->limit(10)->get();
        else
            $users_top_list = DB::table('users')->where('id','!=',1111111111)->orderBy('HW_all', 'DESC')->get();

if (!empty($users_top_list)) {
            foreach ($users_top_list as $lst) {
                $arTmp = array(
                    'id' => sprintf('%012d', $lst->id),
                    'name' => $lst->name,
                    'foto' => '/img/AboveNavPanel/Foto4Nologin.svg',
                    'flag' => '',
                    'recommender' => ''
                );
                $country = DB::table('country')->where('id', $lst->country)->get();
                if (!empty($country[0])) {
                    $arTmp['flag'] = '/img/Flags/'.$country[0]->icon;
                }

$user_recommender = DB::table('user_recommenders')->where('user_id', $lst->id)->limit(1)->get();
                if (!empty($user_recommender[0])) $arTmp["recommender"] = 1;

if ($lst->foto) $arTmp['foto'] = '/uploads/fotos/' . $lst->id . '/' . $lst->foto;

$users_top[] = $arTmp;
            }
        }

if (\Auth::check()) {
            $user_id = $current_user_id = $user_qr_id = \Auth::user()->id;
            $user_name = $current_user_name = \Auth::user()->name;
            if (\Auth::user()->foto)
                $user_photo = $current_user_photo = '/uploads/fotos/' . $user_id . '/' . \Auth::user()->foto;
            else
                $user_photo = $current_user_photo = '/img/AboveNavPanel/RoundBg4Foto.svg';

$user_flag = $current_user_flag = '';
            $country = DB::table('country')->where('id', \Auth::user()->country)->get();
            if (!empty($country)) {
                $user_flag = $current_user_flag = '/img/Flags/' . $country[0]->icon ;
            }

$HW = \Auth::user()->HW;
            $HWall = \Auth::user()->HW_all;

//if (\Auth::user()->balance_public) {
                $balance = \Auth::user()->balance;
                $balance_all = \Auth::user()->balance_all;
            //} else {
            //    $balance = '-';
            //    $balance_all = '-';
            //}

/*
            $userHW = DB::table('signings')->where(['user_id' => \Auth::user()->id, 'product_id'=>1])->get();
            if (!empty($userHW)) {
                foreach ($userHW as $hw) {
                    $HWall += $hw->productscore1;
                }
            }
*/

$userHW = DB::table('impacts')->where(['user_id' => \Auth::user()->id])->get();
            if (!empty($userHW)) {
                foreach ($userHW as $hw) {
                    //$balance_all += $hw->HW*$hw->rate;
                    $total_impacts++;
                    if ($hw->type==2) $total_impacts_increase++;
                    elseif ($hw->type==1) $total_impacts_reduce++;
                }
            }

$user_recommender = DB::table('user_recommenders')->where('user_id', \Auth::user()->id)->limit(1)->get();
            if (!empty($user_recommender[0])) { $recommender = 1; $user_recommender_share = 1; }

$user_recommenders = DB::table('user_recommenders')->where('user_id', \Auth::user()->id)->get();
            if (!empty($user_recommenders) AND count($user_recommenders)>0) {
                $followers = count($user_recommenders);
                if ($followers<1000) $bonus = 10;
                elseif ($followers>=1000 AND $followers<100000) $bonus = 20;
                elseif ($followers>=100000 AND $followers<10000000) $bonus = 30;
                elseif ($followers>=10000000 AND $followers<1000000000) $bonus = 40;
                elseif ($followers>=1000000000) $bonus = 50;
            }

}

if ($request->u) {
            $current_user = DB::table('users')->where('id', $request->u)->get();
        } elseif ($request->f) {
            $current_user = DB::table('users')->where('id', $request->f)->get();
        } else {
            if (!\Auth::check())
                $current_user = DB::table('users')->where('id','!=',1111111111)->orderBy('HW_all', 'DESC')->limit(1)->get();
        }

if (!empty($current_user[0])) {

$HWtotal = $balance_total = $total_users = $bonus = $HW = $HWall = $balance = $balance_all = $total_impacts = $total_impacts_increase = $total_impacts_reduce = 0;
            $recommender = '';

$user_id = $user_qr_id = $current_user[0]->id;
            $user_name = $current_user[0]->name;
            if ($current_user[0]->foto)
                $user_photo = '/uploads/fotos/' . $user_id . '/' . $current_user[0]->foto;
            else
                $user_photo = '/img/AboveNavPanel/RoundBg4Foto.svg';
            $user_flag = '';
            $country = DB::table('country')->where('id', $current_user[0]->country)->get();
            if (!empty($country)) {
                $user_flag = '/img/Flags/' . $country[0]->icon ;
            }
            $qrcode = "/uploads/unpip/" . sprintf('%012d', $user_id) . ".svg";

if ($current_user[0]->HW_public OR $current_user[0]->id==\Auth::user()->id) {
                $HW = $current_user[0]->HW;
                $HWall = $current_user[0]->HW_all;
            } else {
                $HW = '-';
                $HWall = '-';
            }

if ($current_user[0]->balance_public OR $current_user[0]->id==\Auth::user()->id) {
                $balance = $current_user[0]->balance;
                $balance_all = $current_user[0]->balance_all;
            } else {
                $balance = '-';
                $balance_all = '-';
            }

if ($current_user[0]->impacts_public OR $current_user[0]->id==\Auth::user()->id) {
                $userHW = DB::table('impacts')->where(['user_id' => $current_user[0]->id])->get();
                if (!empty($userHW)) {
                    foreach ($userHW as $hw) {
                        $total_impacts++;
                        if ($hw->type == 2) $total_impacts_increase++;
                        elseif ($hw->type == 1) $total_impacts_reduce++;
                    }
                }
            } else {
                $total_impacts = '-';
                $total_impacts_increase = '-';
                $total_impacts_reduce = '-';
            }

$user_recommender = DB::table('user_recommenders')->where('user_id', $current_user[0]->id)->limit(1)->get();
            if (!empty($user_recommender[0])) { $recommender = 1; /*$user_recommender_share = 1;*/ }

$user_recommenders = DB::table('user_recommenders')->where('user_id', $current_user[0]->id)->get();
            if (!empty($user_recommenders) AND count($user_recommenders)>0) {
                $followers = count($user_recommenders);
                if ($followers<1000) $bonus = 10;
                elseif ($followers>=1000 AND $followers<100000) $bonus = 20;
                elseif ($followers>=100000 AND $followers<10000000) $bonus = 30;
                elseif ($followers>=10000000 AND $followers<1000000000) $bonus = 40;
                elseif ($followers>=1000000000) $bonus = 50;
            }

}

$prefix = 'u';
        if ($recommender) $prefix = 'f';
        if (file_exists(app()->request->server->get('DOCUMENT_ROOT').'/uploads/unpip/'.$prefix.$user_qr_id.'.svg')) {
            $qrcode = "/uploads/unpip/" .$prefix. $user_qr_id . ".svg";
        } else {
            $user_qr_id = sprintf('%012d', $user_id);

$qrCode = new QrCode('https://unitednationsplay.com/'.$prefix.'/' . $user_qr_id);
            $qrCode->setSize(30);
            $qrCode->setMargin(1);

$qrCode->setWriterByName('svg');
            $qrCode->setEncoding('UTF-8');
            $qrCode->setErrorCorrectionLevel(ErrorCorrectionLevel::LOW());
            if ($recommender)
                $qrCode->setForegroundColor(['r' => 255, 'g' => 255, 'b' => 0, 'a' => 0]);
            else
                $qrCode->setForegroundColor(['r' => 255, 'g' => 255, 'b' => 255, 'a' => 0]);
            $qrCode->setBackgroundColor(['r' => 0, 'g' => 0, 'b' => 0, 'a' => 255]);
            $qrCode->setValidateResult(false);

$qrCode->setRoundBlockSize(true, QrCode::ROUND_BLOCK_SIZE_MODE_MARGIN);
            $qrCode->setRoundBlockSize(true, QrCode::ROUND_BLOCK_SIZE_MODE_ENLARGE);
            $qrCode->setRoundBlockSize(true, QrCode::ROUND_BLOCK_SIZE_MODE_SHRINK);

$qrCode->setWriterOptions(['exclude_xml_declaration' => true]);

// Directly output the QR code
            //header('Content-Type: '.$qrCode->getContentType());
            //echo $qrCode->writeString();
            $qrCode->writeFile(app()->request->server->get('DOCUMENT_ROOT') . '/uploads/unpip/'.$prefix . $user_qr_id . '.svg');
            $qrcode = "/uploads/unpip/".$prefix . $user_qr_id . ".svg";
        }

$total_users = 0;
        $arUsers = DB::table('users')->where('id','!=',1111111111)->get();
        if (!empty($arUsers)) {
            foreach ($arUsers as $usr) {
                $HWtotal += $usr->HW_all;
                $balance_total += $usr->balance_all;
                $total_users++;
            }
        }

/*
        $allHW = DB::table('signings')->where(['product_id'=>1])->get();
        if (!empty($allHW)) {
            foreach ($allHW as $hw) {
                $HWtotal += $hw->productscore1;
            }
        }

$allBal = DB::table('impacts')->get();
        if (!empty($allBal)) {
            foreach ($allBal as $bal) {
                $balance_total += $bal->HW*$bal->rate;
            }
        }f
        $total_users = User::count();
        */
        $total_impacts_all = 0;
        $total_impacts_all = Impacts::count();

if ($request->f AND \Auth::check() AND !app()->request->server->get('HTTP_REFERER')) {

$can_follow = 1;
            $user_follower = DB::table('user_recommenders')->where('follower_id', \Auth::user()->id)->get();
            if (count($user_follower)>0) $can_follow = '';

$user_follower = DB::table('user_recommenders')->where('user_id', \Auth::user()->id)->get();
            if (count($user_follower)>0) $can_follow = '';

if ($can_follow) {
                DB::table('user_recommenders')->insert([
                    'user_id' => $request->f,
                    'follower_id' => \Auth::user()->id,
                    'created_at' => date("Y-m-d H:i:s"),
                    'updated_at' => date("Y-m-d H:i:s"),
                ]);

}
        }

View::share('qrcode', $qrcode);
        View::share('user_photo', $user_photo);
        View::share('user_id', $user_id);
        View::share('user_name', $user_name);
        View::share('user_flag', $user_flag);
        View::share('current_user_photo', $current_user_photo);
        View::share('current_user_id', $current_user_id);
        View::share('current_user_name', $current_user_name);
        View::share('current_user_flag', $current_user_flag);
        View::share('recommender', $recommender);
        View::share('bonus', $bonus);
        View::share('user_recommender_share', $user_recommender_share);

$total_impacts_percent = 0;
        if ($total_impacts>0)
            $total_impacts_percent = ($total_impacts_increase*100)/$total_impacts;

if ($total_impacts_percent==0) $d = 'D_0';
        elseif ($total_impacts_percent>0 AND $total_impacts_percent<=5) $d = 'D_1-5';
        elseif ($total_impacts_percent>5 AND $total_impacts_percent<=10) $d = 'D_6-10';
        elseif ($total_impacts_percent>10 AND $total_impacts_percent<=25) $d = 'D_11-15';
        elseif ($total_impacts_percent>15 AND $total_impacts_percent<=20) $d = 'D_16-20';
        elseif ($total_impacts_percent>20 AND $total_impacts_percent<=25) $d = 'D_21-25';
        elseif ($total_impacts_percent>25 AND $total_impacts_percent<=30) $d = 'D_26-30';
        elseif ($total_impacts_percent>30 AND $total_impacts_percent<=35) $d = 'D_31-35';
        elseif ($total_impacts_percent>35 AND $total_impacts_percent<=40) $d = 'D_36-40';
        elseif ($total_impacts_percent>40 AND $total_impacts_percent<=45) $d = 'D_41-45';
        elseif ($total_impacts_percent>45 AND $total_impacts_percent<=50) $d = 'D_46-50';
        elseif ($total_impacts_percent>50 AND $total_impacts_percent<=55) $d = 'D_51-55';
        elseif ($total_impacts_percent>55 AND $total_impacts_percent<=60) $d = 'D_56-60';
        elseif ($total_impacts_percent>60 AND $total_impacts_percent<=65) $d = 'D_61-65';
        elseif ($total_impacts_percent>65 AND $total_impacts_percent<=70) $d = 'D_66-70';
        elseif ($total_impacts_percent>70 AND $total_impacts_percent<=75) $d = 'D_71-75';
        elseif ($total_impacts_percent>75 AND $total_impacts_percent<=80) $d = 'D_76-80';
        elseif ($total_impacts_percent>80 AND $total_impacts_percent<=85) $d = 'D_81-85';
        elseif ($total_impacts_percent>85 AND $total_impacts_percent<=90) $d = 'D_86-90';
        elseif ($total_impacts_percent>90 AND $total_impacts_percent<=95) $d = 'D_91-95';
        elseif ($total_impacts_percent>95) $d = 'D_100';

/*
        $message = auth()->user()->messages()->create([
            'message' => 'test1'
        ]);*/

//broadcast(new MessageSent(auth()->user(), $message))->toOthers();

return view('chat', [
            'auth'=>$auth,
            'user_id' => $user_id,
            'HW'=>$HW,
            'HWall'=>$HWall,
            'HWtotal'=>$HWtotal,
            'balance'=>$balance,
            'balance_all'=>$balance_all,
            'balance_total'=>$balance_total,
            'total_users'=>$total_users,
            'settings'=>$settings,
            'countries'=>$countries,
            'users_top' => $users_top,
            'total_impacts' => $total_impacts,
            'total_impacts_increase' => $total_impacts_increase,
            'total_impacts_reduce' => $total_impacts_reduce,
            'total_impacts_all' => $total_impacts_all,
            'D'=>$d,

]);
    }

public function chatBonuses() {

if (!\Auth::check()) {
            return view('login');
        }
/*
        $messages = array();
        $arMessages = DB::table('messages')->whereIn('user_id', [2, \Auth::user()->id])->where('chat_type',1)->orderBy('created_at', 'DESC')->limit(10)->get();
        if (!empty($arMessages)) {
            $UNPIPBot = DB::table('users')->where('id',2)->get();
            foreach ($arMessages as $m) {

$arTmp = array(
                    'message' => $m->message,
                    'message_date' => $m->created_at,
                    'user_name' => $UNPIPBot[0]->name,
                    'bot' => 1
                );
                if ($UNPIPBot[0]->foto)
                    $arTmp['user_photo'] = '/uploads/fotos/'.$UNPIPBot[0]->id.'/'.$UNPIPBot[0]->foto;
                else
                    $arTmp['user_photo'] = '/img/AboveNavPanel/Foto4Nologin.svg';

if ($m->user_id!=2) {
                    $arUser = DB::table('users')->where('id',$m->user_id)->orderBy('created_at', 'DESC')->limit(10)->get();
                    $arTmp['user_name'] = $arUser[0]->name;
                    if ($arUser[0]->foto)
                        $arTmp['user_photo'] = '/uploads/fotos/'.$arUser[0]->id.'/'.$arUser[0]->foto;
                    else
                        $arTmp['user_photo'] = '/img/AboveNavPanel/Foto4Nologin.svg';

$arTmp['bot'] = 0;
                }

$messages[] = $arTmp;
            }
        }
*/

$followers = $bonus = 0;

$followers = $bonus = $contacts_count = 0;
        $user_id = \Auth::user()->id;

$recommender_id = $bonus = $followers = 0;
        $has_bonuses = '';
        $contacts = $recommender = $arFollowers = array();

$user_follower = DB::table('user_recommenders')->where('follower_id', $user_id)->get();
        if (!empty($user_follower[0])) $recommender_id = $user_follower[0]->user_id;

$user_follower = DB::table('user_recommenders')->where('user_id', $user_id)->get();
        if (!empty($user_follower[0])) $recommender_id = $user_follower[0]->user_id;

if ($recommender_id) {
            $user_recommenders = DB::table('user_recommenders')->where('user_id', $recommender_id)->get();
            if (!empty($user_recommenders) AND count($user_recommenders) > 0) {
                $followers = count($user_recommenders);
                if ($followers < 1000) $bonus = 10;
                elseif ($followers >= 1000 AND $followers < 100000) $bonus = 20;
                elseif ($followers >= 100000 AND $followers < 10000000) $bonus = 30;
                elseif ($followers >= 10000000 AND $followers < 1000000000) $bonus = 40;
                elseif ($followers >= 1000000000) $bonus = 50;

$arRecommender = DB::table('users')->where('id', $recommender_id)->get();
                $recommender = array('id'=>$arRecommender[0]->id, 'unpip'=>sprintf('%012d', $arRecommender[0]->id));
                if ($arRecommender[0]->foto)
                    $recommender['foto'] = '/uploads/fotos/' . $arRecommender[0]->id . '/' . $arRecommender[0]->foto;
                else
                    $recommender['foto'] = '/img/AboveNavPanel/ChatMyUIPIcon.svg';
                $recommender['name'] = $arRecommender[0]->name;

foreach ($user_recommenders as $follower) {

$arTmp = array('id'=>$follower->follower_id, 'unpip'=>sprintf('%012d', $follower->follower_id));

$user = DB::table('users')->where('id', $follower->follower_id)->get();
                    if ($user[0]->foto)
                        $arTmp['foto'] = '/uploads/fotos/' . $user[0]->id . '/' . $user[0]->foto;
                    else
                        $arTmp['foto'] = '/img/AboveNavPanel/ChatMyUIPIcon.svg';

$arTmp['name'] = $user[0]->name;

$arFollowers[] = $arTmp;
                }

}
        }

return view('chat-bonuses', [
            'auth'=>$auth,
            'followers' => $followers,
            'bonus' => $bonus,
            'recommender' => $recommender,
            'arFollowers' => $arFollowers,

]);
    }

public function chatBonusesMy(Request $request)
    {

if (!\Auth::check()) {
            return view('login');
        }

$id = \Auth::user()->id;
        $chat_user = 0;
        if ($request->get('id')) {
            $id = $request->get('id');
            $chat_user = $request->get('id');

if ($id!=\Auth::user()->id) {
                $contact = DB::table('chat_contacts')->where(['user_id' => \Auth::user()->id, 'friend_id' => $id])->get();
                if (count($contact) == 0) {
                    DB::table('chat_contacts')->insert([
                        'user_id' => \Auth::user()->id,
                        'friend_id' => $id,
                        'created_at' => date('Y-m-d H:i:s'),
                        'updated_at' => date('Y-m-d H:i:s'),
                    ]);
                }
            }

$user_free = 1;
            $user_follower = DB::table('user_recommenders')->where('follower_id', \Auth::user()->id)->get();
            if (!empty($user_follower[0])) $user_free = '';

$user_follower = DB::table('user_recommenders')->where('user_id', \Auth::user()->id)->get();
            if (!empty($user_follower[0])) $user_free = '';

if ($user_free) {
                DB::table('user_recommenders')->insert([
                    'user_id' => $id,
                    'follower_id' => \Auth::user()->id,
                    'created_at' => date("Y-m-d H:i:s"),
                    'updated_at' => date("Y-m-d H:i:s"),
                ]);

}
        }

$HW_max = \Auth::user()->HW;

$messages = array();
        $conversation_ids = array();
        $conversations = DB::table('conversations')->where('user1', \Auth::user()->id)->orWhere('user2', \Auth::user()->id)->get();
        if (!empty($conversations)) {
            foreach ($conversations as $conv) {
                if ($conv->type==2) $conversation_ids[$conv->id] = $conv->id;
            }
        }

$arMessages = DB::table('messages')->whereIn('conversation_id', $conversation_ids)->where('chat_type',2)->orderBy('created_at', 'DESC')->limit(10)->get();
        if (!empty($arMessages)) {
            $UNPIPBot = DB::table('users')->where('id',1111111111)->get();
            foreach ($arMessages as $m) {

$arTmp = array(
                    'user_id' => $m->user_id,
                    'message' => $m->message,
                    'message_date' => $m->created_at,
                    'user_name' => $UNPIPBot[0]->name,
                    'bot' => 1
                );
                if ($UNPIPBot[0]->foto)
                    $arTmp['user_photo'] = '/uploads/fotos/'.$UNPIPBot[0]->id.'/'.$UNPIPBot[0]->foto;
                else
                    $arTmp['user_photo'] = '/img/AboveNavPanel/ChatMyUIPIcon.svg';

$arTmp['bot'] = 0;
                }

$messages[] = $arTmp;
            }
        }

return view('chat-bonuses-my', [
            'messages'=>$messages,
            'user_id' => $id,
            'chat_user' => $chat_user,
            'HW_max' => $HW_max
        ]);
    }

public function chatUnpip(Request $request) {

if (!\Auth::check()) {
            return view('login');
        }

$user = DB::table('users')->where('id',\Auth::user()->id)->get();
        $current_user['id'] = sprintf('%012d', $user[0]->id);
        $current_user['name'] = 'My UIP';
        if ($user[0]->foto)
            $current_user['foto'] = '/uploads/fotos/'.$user[0]->id.'/'.$user[0]->foto;
        else
            $current_user['foto'] = '/img/AboveNavPanel/ChatMyUIPIcon.svg';

$id = \Auth::user()->id;
        $chat_user = 0;
        if ($request->get('id')) {
            $id = $request->get('id');
            $chat_user = $request->get('id');

/*
            $user_free = 1;
            $user_follower = DB::table('user_recommenders')->where('follower_id', \Auth::user()->id)->get();
            if (!empty($user_follower[0])) $user_free = '';

$user_follower = DB::table('user_recommenders')->where('user_id', \Auth::user()->id)->get();
            if (!empty($user_follower[0])) $user_free = '';

}
            */
            $user = DB::table('users')->where('id',$request->get('id'))->get();
            $current_user['id'] = sprintf('%012d', $user[0]->id);
            $current_user['name'] = $user[0]->name;
            if ($user[0]->foto)
                $current_user['foto'] = '/uploads/fotos/'.$user[0]->id.'/'.$user[0]->foto;
            else
                $current_user['foto'] = '/img/AboveNavPanel/ChatMyUIPIcon.svg';
        }

$HW_max = \Auth::user()->HW;

$messages = array();
        $arMessages = DB::table('messages')->whereIn('user_id', [1111111111, $id])->where('chat_type',1)->orderBy('created_at', 'DESC')->limit(10)->get();
        if (!empty($arMessages)) {
            $UNPIPBot = DB::table('users')->where('id',1111111111)->get();
            foreach ($arMessages as $m) {

$arTmp['bot'] = 0;
                }

$messages[strtotime($m->created_at)] = $arTmp;
            }
        }

$conversation_ids = array();
        $conversations = DB::table('conversations')->where('user1', \Auth::user()->id)->orWhere('user2', \Auth::user()->id)->get();
        if (!empty($conversations)) {
            foreach ($conversations as $conv) {
                if ($conv->type==2) $conversation_ids[$conv->id] = $conv->id;
            }
        }

$arTmp['bot'] = 0;
                }

$messages[strtotime($m->created_at)] = $arTmp;
            }
        }

ksort($messages);

return view('chat-unpip', [
            'messages'=>$messages,
            'user_id' => $id,
            'chat_user' => $chat_user,
            'HW_max' => $HW_max,
            'current_user' => $current_user
        ]);
    }

public function chatSendUnpip(Request $request)
    {

if (!\Auth::check()) {
            return view('login');
        }

if ($request->get('id') AND $request->get('HW')>0 AND $request->get('HW')<=\Auth::user()->HW) {

DB::table('users')->where('id', \Auth::user()->id)->update([
                'HW' => (\Auth::user()->HW-$request->get('HW')),
                'updated_at' => date("Y-m-d H:i:s"),
            ]);

$user = DB::table('users')->where('id', $request->get('id'))->get();
            DB::table('users')->where('id', $request->get('id'))->update([
                'HW' => ($user[0]->HW+$request->get('HW')),
                'updated_at' => date("Y-m-d H:i:s"),
            ]);

$conversation = array();
            $conv = new Conversation();
            $conversations = $conv->where(['user1'=>\Auth::user()->id, 'user2'=>$request->get('id'), 'type'=>2])->get();
            if (!empty($conversations[0])) {
                $conversation = $conversations[0];
            }
            $conversations = $conv->where(['user1'=>$request->get('id'), 'user2'=>\Auth::user()->id, 'type'=>2])->get();
            if (!empty($conversations[0])) {
                $conversation = $conversations[0];
            }

if (empty($conversation)) {
                $conv = new Conversation();
                $conv->private = 1;
                $conv->direct_message = 1;
                $conv->type = 2;
                $conv->user1 = \Auth::user()->id;
                $conv->user2 = $request->get('id');
                $conv->created_at = date("Y-m-d H:i:s");
                $conv->updated_at = date("Y-m-d H:i:s");
                $conv->save();
                $conversation = $conv;
            }

$message = auth()->user()->messages()->create([
                'message' => $request->get('HW').' HW sent',
                'conversation_id' => $conversation->id,
                'chat_type' => 2
            ]);

broadcast(new MessageSent(auth()->user(), $message, $conversation))->toOthers();

}

return response()->json(array('status'=>'success'));
    }

public function chatMyUnpip(Request $request) {

if (!\Auth::check()) {
            return view('login');
        }

$Participation = 0;
        $is_recommender = $iam_recommender = $has_recommender = $user_follower = '';
        $HW = $HWall = $user_HW = $balance = $balance_all = $total_impacts = $total_impacts_increase = $total_impacts_reduce = 0;

$user_recommender = DB::table('user_recommenders')->where(['user_id'=>\Auth::user()->id])->limit(1)->get();
        if (!empty($user_recommender[0])) $iam_recommender = 1;

$user_id = $current_user_id = \Auth::user()->id;
        if ($request->get('id')) $user_id = $current_user_id = $request->get('id');

$user = DB::table('users')->where('id',$user_id)->get();

$HW = $user[0]->HW;
        $balance = $user[0]->balance;

$user_name = $current_user_name = $user[0]->name;
        if ($user[0]->foto)
            $user_photo = $current_user_photo = '/uploads/fotos/' . $user_id . '/' . $user[0]->foto;
        else
            $user_photo = $current_user_photo = '/img/AboveNavPanel/ChatMyUIPIcon.svg';

$user_HW = $user[0]->HW_all;
        $user_flag = $current_user_flag = '';
        $country = DB::table('country')->where('id', $user[0]->country)->get();
        if (!empty($country)) {
            $user_country = $country[0]->name;
            $user_flag = $current_user_flag = '/img/Flags/' . $country[0]->icon ;
        }

$userHW = DB::table('signings')->where(['user_id' => $user[0]->id, 'product_id'=>1])->get();
        if (!empty($userHW)) {
            foreach ($userHW as $hw) {
                $HWall += $hw->productscore1;
            }
        }

$userHW = DB::table('impacts')->where(['user_id' => $user[0]->id])->get();
        if (!empty($userHW)) {
            foreach ($userHW as $hw) {
                $balance_all += $hw->HW*$hw->rate;
                $total_impacts++;
                if ($hw->type==2) $total_impacts_increase++;
                elseif ($hw->type==1) $total_impacts_reduce++;
            }
        }

$user_recommender = DB::table('user_recommenders')->where(['user_id'=>$user_id, 'follower_id'=>\Auth::user()->id])->limit(1)->get();
        if (!empty($user_recommender[0])) $is_recommender = 1;

$user_recommender = DB::table('user_recommenders')->where(['follower_id'=>\Auth::user()->id])->limit(1)->get();
        if (!empty($user_recommender[0])) $has_recommender = 1;

$user_recommender = DB::table('user_recommenders')->where(['follower_id'=>$user_id])->limit(1)->get();
        if (!empty($user_recommender[0])) $user_follower = 1;

$pos = 1;
        $user_rank = '-';
        $users_top_list = DB::table('users')->where('id','!=',1111111111)->orderBy('HW_all', 'DESC')->get();
        if (!empty($users_top_list)) {
            foreach ($users_top_list as $lst) {
                if ($user[0]->id==$lst->id) $user_rank = $pos;
                $pos++;
            }
        }

$total_HW = 0;
        $uaers = DB::table('users')->where('HW_all', '>', 0)->get();
        foreach ($uaers as $user) {
            $total_HW += $user->HW_all;
        }
        if ($total_HW>0)
            $Participation = round(($user_HW*!00)/$total_HW,6);

return view('chat-unpip-my', [
            'auth'=>$auth,
            'user_id' => sprintf('%012d', $user_id),
            'user_photo' => $user_photo,
            'user_name' => $user_name,
            'user_flag' => $user_flag,
            'HW'=>$HW,
            'HWall'=>$HWall,
            'balance'=>$balance,
            'balance_all'=>$balance_all,
            'Participation' => $Participation,
            'total_users'=>$total_users,
            'countries'=>$countries,
            'user_country' => $user_country,
            'total_impacts' => $total_impacts,
            'total_impacts_increase' => $total_impacts_increase,
            'total_impacts_reduce' => $total_impacts_reduce,
            'user_rank' => $user_rank,
            'is_recommender' => $is_recommender,
            'iam_recommender' => $iam_recommender,
            'has_recommender' => $has_recommender,
            'user_follower' => $user_follower
        ]);
    }

public function topList(Request $request)
    {

Cookie::queue("unitednationsplay_top_10_all", '2', 8640000);
        $users_top_list = DB::table('users')->where('id','!=',1111111111)->orderBy('HW_all', 'DESC')->limit(10)->get();
        if (!empty($users_top_list)) {
            foreach ($users_top_list as $lst) {
                $arTmp = array(
                    'id' => sprintf('%012d', $lst->id),
                    'name' => $lst->name,
                    'foto' => '/img/AboveNavPanel/Foto4Nologin.svg',
                    'flag' => '',
                    'recommender' => ''
                );
                $country = DB::table('country')->where('id', $lst->country)->get();
                if (!empty($country[0])) {
                    $arTmp['flag'] = '/img/Flags/'.$country[0]->icon;
                }

$user_recommender = DB::table('user_recommenders')->where('user_id', $lst->id)->limit(1)->get();
                if (!empty($user_recommender[0])) $arTmp["recommender"] = 1;

if ($lst->foto) $arTmp['foto'] = '/uploads/fotos/' . $lst->id . '/' . $lst->foto;

$users_top[] = $arTmp;
            }
        }

return view('chat-peoples-list', [
            'users_top' => $users_top,
        ]);
    }

public function peoplesList(Request $request)
    {

Cookie::queue("unitednationsplay_top_10_all", '1', 8640000);
        $users_top_list = DB::table('users')->where('id','!=',1111111111)->orderBy('HW_all', 'DESC')->get();
        if (!empty($users_top_list)) {
            foreach ($users_top_list as $lst) {
                $arTmp = array(
                    'id' => sprintf('%012d', $lst->id),
                    'name' => $lst->name,
                    'foto' => '/img/AboveNavPanel/Foto4Nologin.svg',
                    'flag' => '',
                    'recommender' => ''
                );
                $country = DB::table('country')->where('id', $lst->country)->get();
                if (!empty($country[0])) {
                    $arTmp['flag'] = '/img/Flags/'.$country[0]->icon;
                }

$user_recommender = DB::table('user_recommenders')->where('user_id', $lst->id)->limit(1)->get();
                if (!empty($user_recommender[0])) $arTmp["recommender"] = 1;

if ($lst->foto) $arTmp['foto'] = '/uploads/fotos/' . $lst->id . '/' . $lst->foto;

$users_top[] = $arTmp;
            }
        }

return view('chat-peoples-list', [
            'users_top' => $users_top,
        ]);
    }

public function homeChat(Request $request)
    {

if (!\Auth::check()) {
            return view('login');
        }

$followers = $bonus = $contacts_count = 0;
        $user_id = \Auth::user()->id;

$recommender_id = $bonus = $followers = 0;
        $has_bonuses = '';
        $contacts = array();

$user_follower = DB::table('user_recommenders')->where('follower_id', $user_id)->get();
        if (!empty($user_follower[0])) $recommender_id = $user_follower[0]->user_id;

$user_follower = DB::table('user_recommenders')->where('user_id', $user_id)->get();
        if (!empty($user_follower[0])) $recommender_id = $user_follower[0]->user_id;

if ($recommender_id) {
            $has_bonuses = 1;
            $user_recommenders = DB::table('user_recommenders')->where('user_id', $recommender_id)->get();
            if (!empty($user_recommenders) AND count($user_recommenders) > 0) {
                $followers = count($user_recommenders);
                if ($followers < 1000) $bonus = 10;
                elseif ($followers >= 1000 AND $followers < 100000) $bonus = 20;
                elseif ($followers >= 100000 AND $followers < 10000000) $bonus = 30;
                elseif ($followers >= 10000000 AND $followers < 1000000000) $bonus = 40;
                elseif ($followers >= 1000000000) $bonus = 50;
            }
        }

$u_recommender = -1;
        $user_recommender = DB::table('user_recommenders')->where(['follower_id'=>$user_id])->get();
        if (!empty($user_recommender[0])) {
            $u_recommender = $user_recommender[0]->user_id;

$user = DB::table('users')->where('id', $user_recommender[0]->user_id)->get();
            $arTmp = array(
                'id'=>$user[0]->id,
                'unpip'=>sprintf('%012d', $user[0]->id),
                'muted'=>'',
                'recommender'=>$user_recommender[0]->user_id
            );
            if ($user[0]->foto)
                $arTmp['foto'] = '/uploads/fotos/' . $user[0]->id . '/' . $user[0]->foto;
            else
                $arTmp['foto'] = '/img/AboveNavPanel/Foto4Nologin.svg';
            $arTmp['name'] = $user[0]->name;

$contacts[] = $arTmp;
        }

$contacts_list = DB::table('chat_contacts')->where(['user_id'=>$user_id])->get();
        if (!empty($contacts_list)) {
            $contacts_count = count($contacts_list);
            foreach ($contacts_list as $c) {

if ($u_recommender!=$c->friend_id) {
                    $arTmp = array('id' => $c->friend_id, 'unpip' => sprintf('%012d', $c->friend_id), 'muted' => $c->muted, 'recommender' => '');

$user = DB::table('users')->where('id', $c->friend_id)->get();
                    if ($user[0]->foto)
                        $arTmp['foto'] = '/uploads/fotos/' . $user[0]->id . '/' . $user[0]->foto;
                    else
                        $arTmp['foto'] = '/img/AboveNavPanel/Foto4Nologin.svg';

$arTmp['name'] = $user[0]->name;

$contacts[] = $arTmp;
                }
            }
        }

return view('chat-home', [
            'auth'=>$auth,
            'user_id' => $user_id,
            'followers' => $followers,
            'bonus' => $bonus,
            'contacts' => $contacts,
            'contacts_count' => $contacts_count,
            'has_bonuses' => $has_bonuses,

]);
    }

public function chatUnpipMute(Request $request)
    {

if (!\Auth::check()) {
            return view('login');
        }

if ($request->get('id')) {
            $contact = DB::table('chat_contacts')->where(['user_id'=>\Auth::user()->id, 'friend_id'=>$request->get('id')])->get();
            if (!empty($contact[0])) {
                if ($contact[0]->muted==1) {
                    DB::table('chat_contacts')->where(['user_id'=>\Auth::user()->id, 'friend_id'=>$request->get('id')])->update(['muted'=>'0']);
                } else {
                    DB::table('chat_contacts')->where(['user_id'=>\Auth::user()->id, 'friend_id'=>$request->get('id')])->update(['muted'=>'1']);
                }
            }
        }

return 1;
    }

public function chatBonusesDeleteChat(Request $request)
    {

if (!\Auth::check()) {
            return view('login');
        }

if ($request->get('id')) {
            $user_id = $request->get('id');
            $is_recommender = DB::table('user_recommenders')->where(['user_id' => \Auth::user()->id, 'follower_id' => $request->get('id')])->limit(1)->get();
            if (!empty($is_recommender[0])) {
                DB::table('user_recommenders')->where(['user_id' => \Auth::user()->id, 'follower_id' => $request->get('id')])->delete();

$conversations = DB::table('conversations')->where(['user1' => \Auth::user()->id, 'user2' => $request->get('id')])->get();
                if (!empty($conversations)) {
                    foreach ($conversations as $conv) {
                        DB::table('messages')->where(['conversation_id' => $conv->id, 'chat_type' => 2])->delete();

}
                }

$conversations = DB::table('conversations')->where(['user1' => $request->get('id'), 'user2' => \Auth::user()->id])->get();
                if (!empty($conversations)) {
                    foreach ($conversations as $conv) {
                        DB::table('messages')->where(['conversation_id' => $conv->id, 'chat_type' => 2])->delete();

}
                }

}

return $this->chatBonuses();
    }

public function chatUnpipDelete(Request $request)
    {

if (!\Auth::check()) {
            return view('login');
        }

return 1;
    }

public function beRecommender(Request $request)
    {

if (!\Auth::check()) {
            return view('login');
        }

if ($request->get('id')) {

$user_id = $request->get('id');
            $is_recommender = DB::table('user_recommenders')->where(['user_id' => \Auth::user()->id])->limit(1)->get();
            if (empty($is_recommender[0])) {

$user_follower = DB::table('user_recommenders')->where(['user_id' => $user_id, 'follower_id' => \Auth::user()->id])->limit(1)->get();
                if (!empty($user_follower[0])) {
                    DB::table('user_recommenders')->where(['user_id' => $user_id, 'follower_id' => \Auth::user()->id])->delete();
                } else {
                    DB::table('user_recommenders')->where(['follower_id' => \Auth::user()->id])->delete();
                    DB::table('user_recommenders')->insert([
                        'user_id' => $user_id,
                        'follower_id' => \Auth::user()->id,
                        'created_at' => date("Y-m-d H:i:s"),
                        'updated_at' => date("Y-m-d H:i:s"),
                    ]);
                }
            }
        }

return ['status' => 'Ok'];
    }

public function fetchMessages(Request $request)
    {

$conversation_id = 1;
        if ($request->get('conversation_id')) $conversation_id = $request->get('conversation_id');

return Message::with('user')->where(['conversation_id' => $conversation_id])->get();
    }

public function sendMessage(Request $request)
    {
        $message = auth()->user()->messages()->create([
            'message' => $request->message
        ]);

broadcast(new MessageSent(auth()->user(), $message))->toOthers();

return ['status' => 'Message Sent!'];
    }

public function unpip(Request $request)
    {

$user_id = $recommender = $qrcode = '';
        $user_photo = '/img/AboveNavPanel/RoundBg4Foto.svg';

if ($request->get('id')) {
            $user_id = $current_user_id = $request->get('id');
            $current_user = DB::table('users')->where('id', $request->get('id'))->get();
            if (!empty($current_user[0])) {

$user_name = $current_user_name = $current_user[0]->name;
                if ($current_user[0]->foto)
                    $user_photo = $current_user_photo = '/uploads/fotos/' . $user_id . '/' . $current_user[0]->foto;
                else
                    $user_photo = $current_user_photo = '/img/AboveNavPanel/RoundBg4Foto.svg';

$user_flag = $current_user_flag = '';
                $country = DB::table('country')->where('id', $current_user[0]->country)->get();
                if (!empty($country)) {
                    $user_flag = $current_user_flag = '/img/Flags/' . $country[0]->icon;
                }

$user_recommender = DB::table('user_recommenders')->where('user_id', $current_user[0]->id)->limit(1)->get();
                if (!empty($user_recommender[0])) $recommender = 1;

$user_recommenders = DB::table('user_recommenders')->where('user_id', $current_user[0]->id)->get();
                if (!empty($user_recommenders) AND count($user_recommenders) > 0) {
                    $followers = count($user_recommenders);
                    if ($followers < 1000) $bonus = 10;
                    elseif ($followers >= 1000 AND $followers < 100000) $bonus = 20;
                    elseif ($followers >= 100000 AND $followers < 10000000) $bonus = 30;
                    elseif ($followers >= 10000000 AND $followers < 1000000000) $bonus = 40;
                    elseif ($followers >= 1000000000) $bonus = 50;
                }

$prefix = 'u';
                if ($recommender) $prefix = 'f';

if ($request->get('prefix')=='f') {
                    $bonus = 10;
                    $prefix = 'f';
                }

$qrcode = "/uploads/unpip/" . $prefix . sprintf('%012d', $user_id) . ".svg";
            }
        }

return view('unpip', [
            'qrcode'=>$qrcode,
            'user_id' => $user_id,
            'user_photo'=>$user_photo,
            'user_name'=>$user_name,
            'user_flag'=>$user_flag,
            'recommender'=>$recommender,
            'bonus'=>$bonus
        ]);
    }
}