
<?php

namespace App\Http\Controllers;

use DB;
use App\SingleSmsList;
use App\Company;
use App\Member;
use App\Events\SendSMS;
use App\Group;
use App\GroupMember;
use App\GroupMsg;
use App\SmsBalance;
use App\SmsCounter;
use Brian2694\Toastr\Facades\Toastr;
use Illuminate\Http\Request;


class SmsController extends Controller
{
    public function index(Request $request)
    {
        if ($request->get('query')) {
            $query = $request->get('query');
            $sms = SingleSmsList::where('name', 'like', '%' . $query . '%')
                ->orWhere('number', 'like', '%' . $query . '%')
                ->orWhere('sms', 'like', '%' . $query . '%')
                ->where('status', 0)
                ->orderBy('id', 'ASC')
                ->get();
        } else {
            $sms = SingleSmsList::where('status', 0)->get();
        }
        $company = Company::latest()->first();
        return view('sms.index', compact('sms', 'company'));
    }
    public function send_member()
    {
        $member = Member::get();


        return view('sms.send_member', compact('member'));
    }

    public function store_single_member(Request $request)
    {
        $balance = SmsBalance::where('id', 1)->first();

        $msg = new SingleSmsList();

        $msg->name = $request->name;
        $msg->number = $request->number;
        $msg->sms = $request->sms;
        $msg->status = 0;
        $x = $request->sms;

        $x_len = strlen($x);
        $sum = round($x_len / 160);
        $sum_total =  $sum + 1;
        // dd($sum_total);
        $total_cost = $sum_total * (.55); //tk;

        $msg->sms_count = $sum_total;
        $msg->cost = $total_cost;
        //dd($msg);
        if ($balance->remain < $total_cost) {
            Toastr::error('Ups! Not sufficient balance. Please recharge! :)', 'Error');
        } else {
            $msg->save();


            $pre_remain = $balance->remain;
            $balance->remain = $pre_remain - $total_cost;

            $balance->save();


            $to =  $request->number;
            $message = $request->sms;
            event(new SendSMS($to, $message));
            $sms = new SmsCounter();
            $sms->mobile =  $msg->number;
            $sms->sms = $message;
            $sms->total = 5000;
            $sms->save();
            Toastr::success('SMS sent successfully ! :)', 'Success');
        }


        return redirect()->back();
    }
    public function edit_single_msg($id)
    {
        $grp = SingleSmsList::where('id', $id)->first();

        return view('sms.edit_single_msg', compact('grp'));
    }

    public function update_single_member(Request $request, $id)
    {
        $msg =  SingleSmsList::where('id', $id)->first();
        $pre_cost =  $msg->cost;


        $msg->name = $request->name;
        $msg->number = $request->number;
        $msg->sms = $request->cost;
        $msg->status = 0;

        $x = $request->sms;

        $x_len = strlen($x);
        $sum = ($x_len / 160);
        $sum_total =  $sum + 1;
        // dd($sum_total);
        $total_cost = $sum_total * (.55); //tk;

        $msg->sms_count = $sum_total;
        $msg->cost = $total_cost;

        $balance = SmsBalance::where('id', 1)->first();

        $pre_remain = $balance->remain + $pre_cost;
        $balance->remain = $pre_remain - $total_cost;

        $balance->save();
        if ($balance->remain < $total_cost) {
            Toastr::error('Ups! Not sufficient balance. Please recharge! :)', 'Error');
        } else {
            $msg->save();


            // echo strlen($x);
            $to = $msg->number;
            $message =  $msg->sms;
            event(new SendSMS($to, $message));
            $sms = new SmsCounter();
            $sms->mobile =  $msg->number;
            $sms->sms = $message;
            $sms->total = 5000;
            $sms->save();
            Toastr::success('SMS sent successfully ! :)', 'Success');
        }


        return redirect()->back();
    }

    public function resend_single_msg($id)
    {
        $msg1 =  SingleSmsList::where('id', $id)->first();

        // $to = $msg->number;
        // $message =  $msg->sms;

        // event(new SendSMS($to, $message));

        // Toastr::success('SMS Resent successfully ! :)', 'Success');

        // return redirect()->back();


        $balance = SmsBalance::where('id', 1)->first();

        $msg = new SingleSmsList();

        $msg->name = $msg1->name;
        $msg->number = $msg1->number;
        $msg->sms = $msg1->sms;
        $msg->status = 0;
        $x = $msg1->sms;

        $x_len = strlen($x);
        $sum = ($x_len / 160);
        $sum_total =  $sum + 1;
        // dd($sum_total);
        $total_cost = $sum_total * (.55); //tk;

        $msg->sms_count = $sum_total;
        $msg->cost = $total_cost;

        if ($balance->remain < $total_cost) {
            Toastr::error('Ups! Not sufficient balance. Please recharge! :)', 'Error');
        } else {
            $msg->save();


            $pre_remain = $balance->remain;
            $balance->remain = $pre_remain - $total_cost;

            $balance->save();


            $to =  $msg1->number;
            $message = $msg1->sms;
            event(new SendSMS($to, $message));
            $sms = new SmsCounter();
            $sms->mobile =  $msg->number;
            $sms->sms = $message;
            $sms->total = 5000;
            $sms->save();
            Toastr::success('SMS sent successfully ! :)', 'Success');
        }


        return redirect()->back();
    }
    public function delete_single_msg($id)
    {
        $grp = SingleSmsList::where('id', $id)->first();
        $grp->status = 1;
        $grp->save();

        Toastr::success('Member Deleted ! :)', 'Success');

        return redirect()->back();
    }


    public function group_list()
    {
        $group = Group::where('status', 0)->get();

        $company = Company::latest()->first();
        return view('sms.group_list', compact('group', 'company'));
    }
    public function create_group()
    {
        return view('sms.create_group');
    }
    public function store_group(Request $request)
    {
        $grp = new Group();

        $grp->name = $request->name;
        $grp->status = 0;
        $grp->save();

        Toastr::success('Group created successfully ! :)', 'Success');

        return redirect()->back();
    }
    public function group_delete($id)
    {
        $grp = Group::where('id', $id)->first();
        $grp->status = 1;
        $grp->save();

        Toastr::success('Group Deleted ! :)', 'Success');

        return redirect()->back();
    }

    public function number_list(Request $request)
    {
        if ($request->get('query')) {
            $query = $request->get('query');
            $group = GroupMember::where('group_name', 'like', '%' . $query . '%')
                ->orWhere('member_name', 'like', '%' . $query . '%')
                ->orWhere('mobile', 'like', '%' . $query . '%')

                ->orderBy('id', 'DESC')
                ->get();
        } else {
            $group = GroupMember::get();
        }
        // $group = GroupMember::where('status', 0)->get();

        $company = Company::latest()->first();
        return view('sms.number_list', compact('group', 'company'));
    }

    public function add_number()
    {
        $grp = Group::where('status',  0)->get();
        return view('sms.add_number', compact('grp'));
    }

    public function store_number(Request $request)
    {
        $grp = new GroupMember();
        $gp = Group::where('id', $request->group_id)->first();
        $grp->group_id = $request->group_id;
        $grp->group_name = $gp->name;
        $grp->mobile = $request->mobile;
        $grp->member_name = $request->member_name;
        $grp->status = 0;
        $grp->save();

        Toastr::success('Group created successfully ! :)', 'Success');

        return redirect()->back();
    }
    public function number_delete($id)
    {
        $grp = GroupMember::where('id', $id)->first();

        $grp->delete();

        Toastr::success('Member Deleted ! :)', 'Success');

        return redirect()->back();
    }


    public function group_sms_list()
    {
        $group = GroupMsg::where('status', 0)->get();

        $company = Company::latest()->first();
        return view('sms.group_sms_list', compact('group', 'company'));
    }

    public function group_message()
    {
        $grp = Group::where('status', 0)->get();


        return view('sms.group_message', compact('grp'));
    }

    public function store_group_message(Request $request)
    {
        $gp_id = $request->group_id;
        $group = GroupMember::where('group_id', $gp_id)->get();
        $group_member = GroupMember::where('group_id', $gp_id)->count();
        $balance = SmsBalance::where('id', 1)->first();

        //dd($group);
        $msg = new GroupMsg();

        $msg->group_id = $request->group_id;
        $msg->sms = $request->sms;
        $msg->status = 0;

        $x = $request->sms;

        $x_len = strlen($x);
        $sum = ($x_len / 160);
        $sum_total =  $sum + 1;

        $msg->sms_count = $group_member * $sum_total;

        $total_cost = ($group_member * $sum_total) * (.55);

        $msg->cost = $total_cost;
        if ($balance->remain < $total_cost) {
            Toastr::error('Ups! Not sufficient balance. Please recharge! :)', 'Error');
        } else {
            $msg->save();


            $pre_remain = $balance->remain;
            $balance->remain = $pre_remain - $total_cost;

            $balance->save();

            foreach ($group as  $group) {

                $to = $group->mobile;
                $message =  $request->sms;
                event(new SendSMS($to, $message));

                $sms = new SmsCounter();
                $sms->mobile =  $to;
                $sms->sms = $message;
                $sms->total = 5000;
                $sms->save();
            }


            Toastr::success('SMS sent successfully ! :)', 'Success');
        }


        return redirect()->back();
    }

    public function delete_group_message($id)
    {
        $grp = GroupMsg::where('id', $id)->first();
        $grp->status = 1;
        $grp->save();

        Toastr::success('Member Deleted ! :)', 'Success');

        return redirect()->back();
    }
    public function edit_group_msg($id)
    {
        $grp = Group::where('status', 0)->get();
        $msg = GroupMsg::where('id', $id)->first();

        return view('sms.edit_group_msg', compact('grp', 'msg'));
    }

    public function update_group_message(Request $request, $id)
    {
        $gp_id = $request->group_id;
        $group = GroupMember::where('group_id', $gp_id)->get();
        $group_member = GroupMember::where('group_id', $gp_id)->count();
        $balance = SmsBalance::where('id', 1)->first();

        //dd($group);
        $msg =  GroupMsg::where('id', $id)->first();
        $pre_cost =  $msg->cost;

        $msg->group_id = $request->group_id;
        $msg->sms = $request->sms;
        $msg->status = 0;
        $x = $request->sms;

        $x_len = strlen($x);
        $sum = ($x_len / 160);
        $sum_total =  $sum + 1;

        $msg->sms_count = $group_member * $sum_total;

        $total_cost = ($group_member * $sum_total) * (.55);

        $msg->cost = $total_cost;
        if ($balance->remain < $total_cost) {
            Toastr::error('Ups! Not sufficient balance. Please recharge! :)', 'Error');
        } else {
            $msg->save();


            $pre_remain = $balance->remain + $pre_cost;
            $balance->remain = $pre_remain - $total_cost;

            $balance->save();
            foreach ($group as  $group) {

                $to = $group->mobile;
                $message =  $request->sms;
                event(new SendSMS($to, $message));
                $sms = new SmsCounter();
                $sms->mobile =  $to;
                $sms->sms = $message;
                $sms->total = 5000;
                $sms->save();
            }


            Toastr::success('SMS sent successfully ! :)', 'Success');
        }


        return redirect()->back();
    }

    public function resend_group_msg($id)
    {

        $msg1 =  GroupMsg::where('id', $id)->first();
        $group = GroupMember::where('group_id', $msg1->group_id)->get();

        // //dd($group);
        // foreach ($group as  $group) {

        //     $to = $group->mobile;
        //     $message =  $msg1->sms;
        //     event(new SendSMS($to, $message));
        //     $sms = new SmsCounter();
        //     $sms->mobile =  $to;
        //     $sms->sms = $message;
        //     $sms->total = 5000;
        //     $sms->save();
        // }

        // Toastr::success('SMS Resent successfully ! :)', 'Success');


        $gp_id = $msg1->group_id;
        $group = GroupMember::where('group_id', $gp_id)->get();
        $group_member = GroupMember::where('group_id', $gp_id)->count();
        $balance = SmsBalance::where('id', 1)->first();

        //dd($group);
        $msg = new GroupMsg();

        $msg->group_id = $msg1->group_id;
        $msg->sms = $msg1->sms;
        $msg->status = 0;

        $x = $msg1->sms;

        $x_len = strlen($x);
        $sum = ($x_len / 160);
        $sum_total =  $sum + 1;

        $msg->sms_count = $group_member * $sum_total;

        $total_cost = ($group_member * $sum_total) * (.55);

        $msg->cost = $total_cost;
        if ($balance->remain < $total_cost) {
            Toastr::error('Ups! Not sufficient balance. Please recharge! :)', 'Error');
        } else {
            $msg->save();


            $pre_remain = $balance->remain;
            $balance->remain = $pre_remain - $total_cost;

            $balance->save();

            foreach ($group as  $group) {

                $to = $group->mobile;
                $message =  $msg1->sms;
                event(new SendSMS($to, $message));

                $sms = new SmsCounter();
                $sms->mobile =  $to;
                $sms->sms = $message;
                $sms->total = 5000;
                $sms->save();
            }


            Toastr::success('SMS sent successfully ! :)', 'Success');
        }


        return redirect()->back();

        return redirect()->back();
    }
    public function sms_counter()
    {
        // $sms = SmsCounter::count();
        $sms_single = SingleSmsList::sum('sms_count');
        $sms_group = GroupMsg::sum('sms_count');

        $rest =    2500 - ($sms_single +  $sms_group);

        $company = Company::latest()->first();
        $sms_account = SmsBalance::where('id', 1)->first();
        return view('sms.sms_counter', compact('sms_single', 'sms_group', 'company', 'rest', 'sms_account'));
    }
}