ClientController::advanceSearch() - Code Metrics - Inspection of "Merge branch 'development' of https://github.com/l..." - ladybirdweb/agorainvoicing - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — development ( 61259f...16e7ec )

by Ashutosh

created 2018-07-10 16:51 UTC

ClientController::advanceSearch() A

↳ Parent: ClientController

Complexity

Conditions	1
Paths	1

Size

Total Lines	11
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
eloc	7
dl	0
loc	11
rs	10
c	0
b	0
f	0
cc	1
nc	1
nop	11

How to fix Many Parameters

<?php

namespace App\Http\Controllers\User;

use App\Http\Controllers\Controller;
use App\Http\Requests\User\ClientRequest;
use App\Model\Order\Invoice;
use App\Model\Order\Order;
use App\Model\Order\Payment;
use App\Model\User\AccountActivate;
use App\User;
use Bugsnag;
use DB;
use Illuminate\Http\Request;
use Log;
use Spatie\Activitylog\Models\Activity;

class ClientController extends Controller
{
    public $user;
    public $activate;
    public $product;

    public function __construct()
    {
        $this->middleware('auth');
        // $this->middleware('admin');
        $user = new User();
        $this->user = $user;
        $activate = new AccountActivate();
        $this->activate = $activate;
        $product = new \App\Model\Product\Product();
        $this->product = $product;
    }

    /**
     * Display a listing of the resource.
     *
     * @return Response

     */
    public function index(Request $request)
    {
        $name = $request->input('name');
        $username = $request->input('username');
        $company = $request->input('company');
        $mobile = $request->input('mobile');
        $email = $request->input('email');
        $country = $request->input('country');
        $industry = $request->input('industry');
        $company_type = $request->input('company_type');
        $company_size = $request->input('company_size');
        $role = $request->input('role');
        $position = $request->input('position');

        $count_users = $this->user->get()->count();
        $pro_editions = $this->soldEdition('Faveo Helpdesk Pro');
        $community = $this->soldEdition('faveo helpdesk community');
        $product_count = $this->productCount();

        return view('themes.default1.user.client.index', compact('name', 'username', 'company', 'mobile', 'email', 'country', 'count_users', 'pro_editions', 'community', 'product_count', 'industry', 'company_type', 'company_size', 'role', 'position'));
    }

    /**
     * Get Clients for chumper datatable.
     */
    public function GetClients(Request $request)
    {
        $name = $request->input('name');
        $username = $request->input('username');
        $company = $request->input('company');
        $mobile = $request->input('mobile');
        $email = $request->input('email');
        $country = $request->input('country');
        $industry = $request->input('industry');
        $company_type = $request->input('company_type');
        $company_size = $request->input('company_size');
        $role = $request->input('role');
        $position = $request->input('position');

        $user = $this->advanceSearch($name, $username, $company, $mobile, $email, $country, $industry, $company_type, $company_size, $role, $position);

        return\ DataTables::of($user->get())

                        ->addColumn('checkbox', function ($model) {
                            return "<input type='checkbox' class='user_checkbox' value=".$model->id.' name=select[] id=check>';
                        })
                        ->addColumn('first_name', function ($model) {
                            return '<a href='.url('clients/'.$model->id).'>'.ucfirst($model->first_name).' '.ucfirst($model->last_name).'</a>';
                        })
                         ->addColumn('email', function ($model) {
                             return $model->email;
                         })
                          ->addColumn('created_at', function ($model) {
                              $ends = $model->created_at;
                              if ($ends) {
                                  $date = date_create($ends);
                                  $end = date_format($date, 'l, F j, Y H:m');
                              }

                              return $end;

                              //   return $model->created_at;
                          })
                        // ->showColumns('email', 'created_at')
                        ->addColumn('active', function ($model) {
                            if ($model->active == 1) {
                                $email = "<span class='glyphicon glyphicon-envelope' style='color:green' title='verified email'></span>";
                            } else {
                                $email = "<span class='glyphicon glyphicon-envelope' style='color:red' title='unverified email'></span>";
                            }
                            if ($model->mobile_verified == 1) {
                                $mobile = "<span class='glyphicon glyphicon-phone' style='color:green' title='verified mobile'></span>";
                            } else {
                                $mobile = "<span class='glyphicon glyphicon-phone' style='color:red' title='unverified mobile'></span>";
                            }

                            return $email.'&nbsp;&nbsp;'.$mobile;
                        })
                        ->addColumn('action', function ($model) {
                            return '<a href='.url('clients/'.$model->id.'/edit')." class='btn btn-sm btn-primary btn-xs'><i class='fa fa-edit' style='color:white;'> </i>&nbsp;&nbsp;Edit</a>"
                                    .'  <a href='.url('clients/'.$model->id)." class='btn btn-sm btn-primary btn-xs'><i class='fa fa-eye' style='color:white;'> </i>&nbsp;&nbsp;View</a>";
                            // return 'hhhh';
                        })
                        ->rawColumns(['checkbox', 'first_name', 'email',  'created_at', 'active', 'action'])
                        ->make(true);

        // ->searchColumns('email', 'first_name')
                        // ->orderColumns('email', 'first_name', 'created_at')
                        // ->make();
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return Response
     */
    public function create()
    {
        $timezones = new \App\Model\Common\Timezone();
        $timezones = $timezones->pluck('name', 'id')->toArray();
        $bussinesses = \App\Model\Common\Bussiness::pluck('name', 'short')->toArray();
        $managers = User::where('role', 'admin')->where('position', 'manager')->pluck('first_name', 'id')->toArray();

        return view('themes.default1.user.client.create', compact('timezones', 'bussinesses', 'managers'));
    }

    /**
     * Store a newly created resource in storage.
     *
     * @return Response
     */
    public function store(ClientRequest $request)
    {
        try {
            $user = $this->user;
            $str = str_random(6);
            $password = \Hash::make($str);
            $user->password = $password;
            $user->fill($request->input())->save();
            $this->sendWelcomeMail($user);

            return redirect()->back()->with('success', \Lang::get('message.saved-successfully'));
        } catch (\Swift_TransportException $e) {
            return redirect()->back()->with('warning', 'User has created successfully But email configuration has some problem!');
        } catch (\Exception $e) {
            return redirect()->back()->with('fails', $e->getMessage());
        }
    }

    /**
     * Display the specified resource.
     *
     * @param int $id
     *
     * @return Response
     */
    public function show($id)
    {
        try {
            $invoice = new Invoice();
            $order = new Order();
            $invoices = $invoice->where('user_id', $id)->orderBy('created_at', 'desc')->get();
            $invoiceSum = $this->getTotalInvoice($invoices);
            $amountReceived = $this->getAmountPaid($id);
            $pendingAmount = $invoiceSum - $amountReceived;
            $client = $this->user->where('id', $id)->first();
            $currency = $client->currency;
            $orders = $order->where('client', $id)->get();
            //dd($client);

            return view('themes.default1.user.client.show', compact('id', 'client', 'invoices', 'model_popup', 'orders', 'payments', 'invoiceSum', 'amountReceived', 'pendingAmount', 'currency'));
        } catch (\Exception $ex) {
            app('log')->useDailyFiles(storage_path().'/logs/laravel.log');
            app('log')->info($ex->getMessage());
            Bugsnag::notifyException($ex);

            return redirect()->back()->with('fails', $ex->getMessage());
        }
    }

    /**
     * Get total Amount paid for a particular invoice.
     */
    public function getAmountPaid($userId)
    {
        try {
            $amounts = Payment::where('user_id', $userId)->select('amount')->get();
            $paidSum = 0;
            foreach ($amounts as $amount) {
                $paidSum = $paidSum + $amount->amount;
            }

            return $paidSum;
        } catch (\Exception $ex) {
            app('log')->useDailyFiles(storage_path().'/laravel.log');
            app('log')->info($ex->getMessage());
            Bugsnag::notifyException($ex);

            return redirect()->back()->with('fails', $ex->getMessage());
        }
    }

    /**
     * Get total of the Invoices for a User.
     */
    public function getTotalInvoice($invoices)
    {
        try {
            $sum = 0;
            foreach ($invoices as $invoice) {
                $sum = $sum + $invoice->grand_total;
            }

            return $sum;
        } catch (\Exception $e) {
function fx() {
    try {
        doSomething();
        return true;
    }
    catch (\Exception $e) {
        return false;
    }

    return false;
}
            app('log')->useDailyFiles(storage_path().'/laravel.log');
            app('log')->info($e->getMessage());
            Bugsnag::notifyException($e);

            return redirect()->back()->with('fails', $e->getMessage());
        }
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param int $id
     *
     * @return Response
     */
    public function edit($id)
    {
        try {
            $user = $this->user->where('id', $id)->first();
            $timezones = new \App\Model\Common\Timezone();
            $timezones = $timezones->pluck('name', 'id')->toArray();

            $state = \App\Http\Controllers\Front\CartController::getStateByCode($user->state);
            $managers = User::where('role', 'admin')->where('position', 'manager')->pluck('first_name', 'id')->toArray();

            $states = \App\Http\Controllers\Front\CartController::findStateByRegionId($user->country);

            $bussinesses = \App\Model\Common\Bussiness::pluck('name', 'short')->toArray();

            return view('themes.default1.user.client.edit', compact('bussinesses', 'user', 'timezones', 'state', 'states', 'managers'));
        } catch (\Exception $ex) {
            app('log')->useDailyFiles(storage_path().'/laravel.log');
            app('log')->info($ex->getMessage());

            return redirect()->back()->with('fails', $ex->getMessage());
        }
    }

    /**
     * Update the specified resource in storage.
     *
     * @param int $id
     *
     * @return Response
     */
    public function update($id, ClientRequest $request)
    {
        $user = $this->user->where('id', $id)->first();

        $user->fill($request->input())->save();
        // activity()->log('Look mum, I logged something');

        return redirect()->back()->with('success', \Lang::get('message.updated-successfully'));
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param int $id
     *
     * @return Response
     */
    public function destroy(Request $request)
    {
        $ids = $request->input('select');
        if (!empty($ids)) {
            foreach ($ids as $id) {
                $user = $this->user->where('id', $id)->first();
                if ($user) {
                    $user->delete();
                } else {
                    echo "<div class='alert alert-success alert-dismissable'>
                    <i class='fa fa-ban'></i>
                    <b>"./* @scrutinizer ignore-type */\Lang::get('message.alert').'!</b> './* @scrutinizer ignore-type */
                    \Lang::get('message.success').'
                    <button type=button class=close data-dismiss=alert aria-hidden=true>&times;</button>
                        './* @scrutinizer ignore-type */\Lang::get('message.no-record').'
                </div>';
                    //echo \Lang::get('message.no-record') . '  [id=>' . $id . ']';
                }
            }
            echo "<div class='alert alert-success alert-dismissable'>
                    <i class='fa fa-ban'></i>
                    <b>"./* @scrutinizer ignore-type */\Lang::get('message.alert').'!</b> './* @scrutinizer ignore-type */
                    Lang::get('message.success').'

                    <button type=button class=close data-dismiss=alert aria-hidden=true>&times;</button>
                        './* @scrutinizer ignore-type */\Lang::get('message.deleted-successfully').'
                </div>';
        } else {
            echo "<div class='alert alert-success alert-dismissable'>
                    <i class='fa fa-ban'></i>
                    <b>"./* @scrutinizer ignore-type */\Lang::get('message.alert').'!</b> '.
                    /* @scrutinizer ignore-type */\Lang::get('message.success').'
                    <button type=button class=close data-dismiss=alert aria-hidden=true>&times;</button>
                        './* @scrutinizer ignore-type */\Lang::get('message.select-a-row').'
                </div>';
            //echo \Lang::get('message.select-a-row');
        }
    }

    public function getUsers(Request $request)
    {
        $options = $this->user
//->where('email','LIKE','%'.$s.'%')
                ->select('email AS text', 'id AS value')
                ->get();

        return response()->json(compact('options'));
    }

    public function advanceSearch($name = '', $username = '', $company = '', $mobile = '', $email = '', $country = '', $industry = '', $company_type = '', $company_size = '', $role = '', $position = '')
    {
        $join = DB::table('users');
        $join = $this->getNamUserCom($join,$name,$username,$company);
        $join = $this->getMobEmCoun($join,$mobile,$email,$country);
        $join = $this->getInCtCs($join,$industry,$company_type,$company_size);
        $join = $this->getRolPos($join,$role,$position);
       
         $join = $join->orderBy('created_at', 'desc')->select('id', 'first_name', 'last_name', 'email', 'created_at', 'active', 'mobile_verified', 'role', 'position');

        return $join;
    }

    /**
    * Serach for Mobile,Email,Country
    */
    public function getMobEmCoun($join,$mobile,$email,$country)
    {
        if ($mobile) {
            $join = $join->where('mobile', $mobile);
        }
        if ($email) {
            $join = $join->where('email', 'LIKE', '%'.$email.'%');
        }
        if ($country) {
            $join = $join->where('country', $country);
        }
        return $join;
    }

     
     /**
    * Serach for industry,company_type,company_size
    */
     public function getInCtCs($join,$industry,$company_type,$company_size)
    {
       if ($industry) {
            $join = $join->where('bussiness', $industry);
        }
        if ($company_type) {
            $join = $join->where('company_type', $company_type);
        }
        if ($company_size) {
            $join = $join->where('company_size', $company_size);
        }
        return $join;
    }


    /**
    * Serach for Role,Position
    */
     public function getRolPos($join,$role,$position)
    {
      if ($role) {
            $join = $join->where('role', $role);
        }
        if ($position) {
            $join = $join->where('position', $position);
        }
        return $join;
    }

     /**
    * Serach for Name,UserName,Company
    */
     public function getNamUserCom($join,$name,$username,$company)
    {
     if ($name) {
            $join = $join->where('first_name', 'LIKE', '%'.$name.'%')
                    ->orWhere('last_name', 'LIKE', '%'.$name.'%');
        }
        if ($username) {
            $join = $join->where('user_name', 'LIKE', '%'.$username.'%');
        }
        if ($company) {
            $join = $join->where('company', 'LIKE', '%'.$company.'%');
        }
        return $join;
    }

    public function soldEdition($name)
    {
        $invoice = new \App\Model\Order\InvoiceItem();
        $product_in_invoice = $invoice->where('product_name', $name)->distinct()->pluck('invoice_id');
        $order = new Order();
        $orders = $order->whereIn('invoice_id', $product_in_invoice)->get()->count();

        return $orders;
    }

    public function productCount()
    {
        $products = $this->product->get()->count();

        return $products;
    }

    public function sendWelcomeMail($user)
    {
        $activate_model = new AccountActivate();
        $str = str_random(40);
        $activate = $activate_model->create(['email' => $user->email, 'token' => $str]);
        $token = $activate->token;
        $url = url("activate/$token");
        //check in the settings
        $settings = new \App\Model\Common\Setting();
        $setting = $settings->where('id', 1)->first();
        //template
        $templates = new \App\Model\Common\Template();
        $temp_id = $setting->welcome_mail;
        $template = $templates->where('id', $temp_id)->first();
        $from = $setting->email;
        $to = $user->email;
        $subject = $template->name;
        $data = $template->data;
        $replace = ['name' => $user->first_name.' '.$user->last_name, 'username' => $user->email, 'password' => $str, 'url' => $url];
        $type = '';
        if ($template) {
            $type_id = $template->type;
            $temp_type = new \App\Model\Common\TemplateType();
            $type = $temp_type->where('id', $type_id)->first()->name;
        }
        //dd($type);
        $templateController = new \App\Http\Controllers\Common\TemplateController();
        $mail = $templateController->mailing($from, $to, $data, $subject, $replace, $type);

        return $mail;
    }
}


1			<?php
2
3			namespace App\Http\Controllers\User;
4
5			use App\Http\Controllers\Controller;
6			use App\Http\Requests\User\ClientRequest;
7			use App\Model\Order\Invoice;
8			use App\Model\Order\Order;
9			use App\Model\Order\Payment;
10			use App\Model\User\AccountActivate;
11			use App\User;
12			use Bugsnag;
13			use DB;
14			use Illuminate\Http\Request;
15			use Log;
16			use Spatie\Activitylog\Models\Activity;
17
18			class ClientController extends Controller
19			{
20			public $user;
21			public $activate;
22			public $product;
23
24			public function __construct()
25			{
26			$this->middleware('auth');
27			// $this->middleware('admin');
28			$user = new User();
29			$this->user = $user;
30			$activate = new AccountActivate();
31			$this->activate = $activate;
32			$product = new \App\Model\Product\Product();
33			$this->product = $product;
34			}
35
36			/**
37			* Display a listing of the resource.
38			*
39			* @return Response
			0 ignored issues – show Bug introduced 2018-06-18 09:39 UTC by Report Bug Copy Issue Report The type `App\Http\Controllers\User\Response` was not found. Did you mean `Response`? If so, make sure to prefix the type with `\`. Loading history...
40			*/
41			public function index(Request $request)
42			{
43			$name = $request->input('name');
44			$username = $request->input('username');
45			$company = $request->input('company');
46			$mobile = $request->input('mobile');
47			$email = $request->input('email');
48			$country = $request->input('country');
49			$industry = $request->input('industry');
50			$company_type = $request->input('company_type');
51			$company_size = $request->input('company_size');
52			$role = $request->input('role');
53			$position = $request->input('position');
54
55			$count_users = $this->user->get()->count();
56			$pro_editions = $this->soldEdition('Faveo Helpdesk Pro');
57			$community = $this->soldEdition('faveo helpdesk community');
58			$product_count = $this->productCount();
59
60			return view('themes.default1.user.client.index', compact('name', 'username', 'company', 'mobile', 'email', 'country', 'count_users', 'pro_editions', 'community', 'product_count', 'industry', 'company_type', 'company_size', 'role', 'position'));
61			}
62
63			/**
64			* Get Clients for chumper datatable.
65			*/
66			public function GetClients(Request $request)
67			{
68			$name = $request->input('name');
69			$username = $request->input('username');
70			$company = $request->input('company');
71			$mobile = $request->input('mobile');
72			$email = $request->input('email');
73			$country = $request->input('country');
74			$industry = $request->input('industry');
75			$company_type = $request->input('company_type');
76			$company_size = $request->input('company_size');
77			$role = $request->input('role');
78			$position = $request->input('position');
79
80			$user = $this->advanceSearch($name, $username, $company, $mobile, $email, $country, $industry, $company_type, $company_size, $role, $position);
81
82			return\ DataTables::of($user->get())
83
84			->addColumn('checkbox', function ($model) {
85			return "<input type='checkbox' class='user_checkbox' value=".$model->id.' name=select[] id=check>';
86			})
87			->addColumn('first_name', function ($model) {
88			return '<a href='.url('clients/'.$model->id).'>'.ucfirst($model->first_name).' '.ucfirst($model->last_name).'</a>';
89			})
90			->addColumn('email', function ($model) {
91			return $model->email;
92			})
93			->addColumn('created_at', function ($model) {
94			$ends = $model->created_at;
95			if ($ends) {
96			$date = date_create($ends);
97			$end = date_format($date, 'l, F j, Y H:m');
98			}
99
100			return $end;
101
102			// return $model->created_at;
103			})
104			// ->showColumns('email', 'created_at')
105			->addColumn('active', function ($model) {
106			if ($model->active == 1) {
107			$email = "<span class='glyphicon glyphicon-envelope' style='color:green' title='verified email'></span>";
108			} else {
109			$email = "<span class='glyphicon glyphicon-envelope' style='color:red' title='unverified email'></span>";
110			}
111			if ($model->mobile_verified == 1) {
112			$mobile = "<span class='glyphicon glyphicon-phone' style='color:green' title='verified mobile'></span>";
113			} else {
114			$mobile = "<span class='glyphicon glyphicon-phone' style='color:red' title='unverified mobile'></span>";
115			}
116
117			return $email.'  '.$mobile;
118			})
119			->addColumn('action', function ($model) {
120			return '<a href='.url('clients/'.$model->id.'/edit')." class='btn btn-sm btn-primary btn-xs'><i class='fa fa-edit' style='color:white;'> </i>  Edit</a>"
121			.' <a href='.url('clients/'.$model->id)." class='btn btn-sm btn-primary btn-xs'><i class='fa fa-eye' style='color:white;'> </i>  View</a>";
122			// return 'hhhh';
123			})
124			->rawColumns(['checkbox', 'first_name', 'email', 'created_at', 'active', 'action'])
125			->make(true);
126
127			// ->searchColumns('email', 'first_name')
128			// ->orderColumns('email', 'first_name', 'created_at')
129			// ->make();
130			}
131
132			/**
133			* Show the form for creating a new resource.
134			*
135			* @return Response
136			*/
137			public function create()
138			{
139			$timezones = new \App\Model\Common\Timezone();
140			$timezones = $timezones->pluck('name', 'id')->toArray();
141			$bussinesses = \App\Model\Common\Bussiness::pluck('name', 'short')->toArray();
142			$managers = User::where('role', 'admin')->where('position', 'manager')->pluck('first_name', 'id')->toArray();
143
144			return view('themes.default1.user.client.create', compact('timezones', 'bussinesses', 'managers'));
145			}
146
147			/**
148			* Store a newly created resource in storage.
149			*
150			* @return Response
151			*/
152			public function store(ClientRequest $request)
153			{
154			try {
155			$user = $this->user;
156			$str = str_random(6);
157			$password = \Hash::make($str);
158			$user->password = $password;
159			$user->fill($request->input())->save();
160			$this->sendWelcomeMail($user);
161
162			return redirect()->back()->with('success', \Lang::get('message.saved-successfully'));
163			} catch (\Swift_TransportException $e) {
164			return redirect()->back()->with('warning', 'User has created successfully But email configuration has some problem!');
165			} catch (\Exception $e) {
166			return redirect()->back()->with('fails', $e->getMessage());
167			}
168			}
169
170			/**
171			* Display the specified resource.
172			*
173			* @param int $id
174			*
175			* @return Response
176			*/
177			public function show($id)
178			{
179			try {
180			$invoice = new Invoice();
181			$order = new Order();
182			$invoices = $invoice->where('user_id', $id)->orderBy('created_at', 'desc')->get();
183			$invoiceSum = $this->getTotalInvoice($invoices);
184			$amountReceived = $this->getAmountPaid($id);
185			$pendingAmount = $invoiceSum - $amountReceived;
186			$client = $this->user->where('id', $id)->first();
187			$currency = $client->currency;
188			$orders = $order->where('client', $id)->get();
189			//dd($client);
190
191			return view('themes.default1.user.client.show', compact('id', 'client', 'invoices', 'model_popup', 'orders', 'payments', 'invoiceSum', 'amountReceived', 'pendingAmount', 'currency'));
192			} catch (\Exception $ex) {
193			app('log')->useDailyFiles(storage_path().'/logs/laravel.log');
194			app('log')->info($ex->getMessage());
195			Bugsnag::notifyException($ex);
196
197			return redirect()->back()->with('fails', $ex->getMessage());
198			}
199			}
200
201			/**
202			* Get total Amount paid for a particular invoice.
203			*/
204			public function getAmountPaid($userId)
205			{
206			try {
207			$amounts = Payment::where('user_id', $userId)->select('amount')->get();
208			$paidSum = 0;
209			foreach ($amounts as $amount) {
210			$paidSum = $paidSum + $amount->amount;
211			}
212
213			return $paidSum;
214			} catch (\Exception $ex) {
215			app('log')->useDailyFiles(storage_path().'/laravel.log');
216			app('log')->info($ex->getMessage());
217			Bugsnag::notifyException($ex);
218
219			return redirect()->back()->with('fails', $ex->getMessage());
220			}
221			}
222
223			/**
224			* Get total of the Invoices for a User.
225			*/
226			public function getTotalInvoice($invoices)
227			{
228			try {
229			$sum = 0;
230			foreach ($invoices as $invoice) {
231			$sum = $sum + $invoice->grand_total;
232			}
233
234			return $sum;
235			} catch (\Exception $e) {
			0 ignored issues – show Unused Code introduced 2018-07-10 13:13 UTC by Report Bug Copy Issue Report `catch (\Exception $e)` is not reachable. This check looks for unreachable code. It uses sophisticated control flow analysis techniques to find statements which will never be executed. Unreachable code is most often the result of `return`, `die` or `exit` statements that have been added for debug purposes. function fx() { try { doSomething(); return true; } catch (\Exception $e) { return false; } return false; } In the above example, the last `return false` will never be executed, because a return statement has already been met in every possible execution path. Loading history...
236			app('log')->useDailyFiles(storage_path().'/laravel.log');
237			app('log')->info($e->getMessage());
238			Bugsnag::notifyException($e);
239
240			return redirect()->back()->with('fails', $e->getMessage());
241			}
242			}
243
244			/**
245			* Show the form for editing the specified resource.
246			*
247			* @param int $id
248			*
249			* @return Response
250			*/
251			public function edit($id)
252			{
253			try {
254			$user = $this->user->where('id', $id)->first();
255			$timezones = new \App\Model\Common\Timezone();
256			$timezones = $timezones->pluck('name', 'id')->toArray();
257
258			$state = \App\Http\Controllers\Front\CartController::getStateByCode($user->state);
259			$managers = User::where('role', 'admin')->where('position', 'manager')->pluck('first_name', 'id')->toArray();
260
261			$states = \App\Http\Controllers\Front\CartController::findStateByRegionId($user->country);
262
263			$bussinesses = \App\Model\Common\Bussiness::pluck('name', 'short')->toArray();
264
265			return view('themes.default1.user.client.edit', compact('bussinesses', 'user', 'timezones', 'state', 'states', 'managers'));
266			} catch (\Exception $ex) {
267			app('log')->useDailyFiles(storage_path().'/laravel.log');
268			app('log')->info($ex->getMessage());
269
270			return redirect()->back()->with('fails', $ex->getMessage());
271			}
272			}
273
274			/**
275			* Update the specified resource in storage.
276			*
277			* @param int $id
278			*
279			* @return Response
280			*/
281			public function update($id, ClientRequest $request)
282			{
283			$user = $this->user->where('id', $id)->first();
284
285			$user->fill($request->input())->save();
286			// activity()->log('Look mum, I logged something');
287
288			return redirect()->back()->with('success', \Lang::get('message.updated-successfully'));
289			}
290
291			/**
292			* Remove the specified resource from storage.
293			*
294			* @param int $id
295			*
296			* @return Response
297			*/
298			public function destroy(Request $request)
299			{
300			$ids = $request->input('select');
301			if (!empty($ids)) {
302			foreach ($ids as $id) {
303			$user = $this->user->where('id', $id)->first();
304			if ($user) {
305			$user->delete();
306			} else {
307			echo "<div class='alert alert-success alert-dismissable'>
308			<i class='fa fa-ban'></i>
309			<b>"./* @scrutinizer ignore-type /\Lang::get('message.alert').'!</b> './ @scrutinizer ignore-type */
310			\Lang::get('message.success').'
311			<button type=button class=close data-dismiss=alert aria-hidden=true>×</button>
312			'./* @scrutinizer ignore-type */\Lang::get('message.no-record').'
313			</div>';
314			//echo \Lang::get('message.no-record') . ' [id=>' . $id . ']';
315			}
316			}
317			echo "<div class='alert alert-success alert-dismissable'>
318			<i class='fa fa-ban'></i>
319			<b>"./* @scrutinizer ignore-type /\Lang::get('message.alert').'!</b> './ @scrutinizer ignore-type */
320			Lang::get('message.success').'
			0 ignored issues – show Bug introduced 2018-07-08 20:27 UTC by Report Bug Copy Issue Report The type `App\Http\Controllers\User\Lang` was not found. Did you mean `Lang`? If so, make sure to prefix the type with `\`. Loading history...
321			<button type=button class=close data-dismiss=alert aria-hidden=true>×</button>
322			'./* @scrutinizer ignore-type */\Lang::get('message.deleted-successfully').'
323			</div>';
324			} else {
325			echo "<div class='alert alert-success alert-dismissable'>
326			<i class='fa fa-ban'></i>
327			<b>"./* @scrutinizer ignore-type */\Lang::get('message.alert').'!</b> '.
328			/* @scrutinizer ignore-type */\Lang::get('message.success').'
329			<button type=button class=close data-dismiss=alert aria-hidden=true>×</button>
330			'./* @scrutinizer ignore-type */\Lang::get('message.select-a-row').'
331			</div>';
332			//echo \Lang::get('message.select-a-row');
333			}
334			}
335
336			public function getUsers(Request $request)
337			{
338			$options = $this->user
339			//->where('email','LIKE','%'.$s.'%')
340			->select('email AS text', 'id AS value')
341			->get();
342
343			return response()->json(compact('options'));
344			}
345
346			public function advanceSearch($name = '', $username = '', $company = '', $mobile = '', $email = '', $country = '', $industry = '', $company_type = '', $company_size = '', $role = '', $position = '')
347			{
348			$join = DB::table('users');
349			$join = $this->getNamUserCom($join,$name,$username,$company);
350			$join = $this->getMobEmCoun($join,$mobile,$email,$country);
351			$join = $this->getInCtCs($join,$industry,$company_type,$company_size);
352			$join = $this->getRolPos($join,$role,$position);
353
354			$join = $join->orderBy('created_at', 'desc')->select('id', 'first_name', 'last_name', 'email', 'created_at', 'active', 'mobile_verified', 'role', 'position');
355
356			return $join;
357			}
358
359			/**
360			* Serach for Mobile,Email,Country
361			*/
362			public function getMobEmCoun($join,$mobile,$email,$country)
363			{
364			if ($mobile) {
365			$join = $join->where('mobile', $mobile);
366			}
367			if ($email) {
368			$join = $join->where('email', 'LIKE', '%'.$email.'%');
369			}
370			if ($country) {
371			$join = $join->where('country', $country);
372			}
373			return $join;
374			}
375
376
377			/**
378			* Serach for industry,company_type,company_size
379			*/
380			public function getInCtCs($join,$industry,$company_type,$company_size)
381			{
382			if ($industry) {
383			$join = $join->where('bussiness', $industry);
384			}
385			if ($company_type) {
386			$join = $join->where('company_type', $company_type);
387			}
388			if ($company_size) {
389			$join = $join->where('company_size', $company_size);
390			}
391			return $join;
392			}
393
394
395			/**
396			* Serach for Role,Position
397			*/
398			public function getRolPos($join,$role,$position)
399			{
400			if ($role) {
401			$join = $join->where('role', $role);
402			}
403			if ($position) {
404			$join = $join->where('position', $position);
405			}
406			return $join;
407			}
408
409			/**
410			* Serach for Name,UserName,Company
411			*/
412			public function getNamUserCom($join,$name,$username,$company)
413			{
414			if ($name) {
415			$join = $join->where('first_name', 'LIKE', '%'.$name.'%')
416			->orWhere('last_name', 'LIKE', '%'.$name.'%');
417			}
418			if ($username) {
419			$join = $join->where('user_name', 'LIKE', '%'.$username.'%');
420			}
421			if ($company) {
422			$join = $join->where('company', 'LIKE', '%'.$company.'%');
423			}
424			return $join;
425			}
426
427			public function soldEdition($name)
428			{
429			$invoice = new \App\Model\Order\InvoiceItem();
430			$product_in_invoice = $invoice->where('product_name', $name)->distinct()->pluck('invoice_id');
431			$order = new Order();
432			$orders = $order->whereIn('invoice_id', $product_in_invoice)->get()->count();
433
434			return $orders;
435			}
436
437			public function productCount()
438			{
439			$products = $this->product->get()->count();
440
441			return $products;
442			}
443
444			public function sendWelcomeMail($user)
445			{
446			$activate_model = new AccountActivate();
447			$str = str_random(40);
448			$activate = $activate_model->create(['email' => $user->email, 'token' => $str]);
449			$token = $activate->token;
450			$url = url("activate/$token");
451			//check in the settings
452			$settings = new \App\Model\Common\Setting();
453			$setting = $settings->where('id', 1)->first();
454			//template
455			$templates = new \App\Model\Common\Template();
456			$temp_id = $setting->welcome_mail;
457			$template = $templates->where('id', $temp_id)->first();
458			$from = $setting->email;
459			$to = $user->email;
460			$subject = $template->name;
461			$data = $template->data;
462			$replace = ['name' => $user->first_name.' '.$user->last_name, 'username' => $user->email, 'password' => $str, 'url' => $url];
463			$type = '';
464			if ($template) {
465			$type_id = $template->type;
466			$temp_type = new \App\Model\Common\TemplateType();
467			$type = $temp_type->where('id', $type_id)->first()->name;
468			}
469			//dd($type);
470			$templateController = new \App\Http\Controllers\Common\TemplateController();
471			$mail = $templateController->mailing($from, $to, $data, $subject, $replace, $type);
472
473			return $mail;
474			}
475			}
476

ladybirdweb / agorainvoicing

Push — development ( 61259f...16e7ec )

ClientController::advanceSearch() A

Complexity

Size

Duplication

Importance

How to fix Many Parameters

Many Parameters

Duplication Side-by-Side

Filter issues like