App\Http\Controllers\User\AdminOrderInvoiceController

Complexity

Total Complexity

10

Size/Duplication

Total Lines	155
Duplicated Lines	0 %

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	getPaymentDetail()	0	40	3
A	getOrderDetail()	0	39	3
A	getClientInvoice()	0	68	4

<?php

namespace App\Http\Controllers\User;

use Illuminate\Http\Request;
use App\Model\Order\Invoice;
use App\Http\Controllers\Controller;

class AdminOrderInvoiceController extends Controller
{
    public function getClientInvoice($id)
    {
        $invoice = new Invoice();
        $client = $this->user->where('id', $id)->first();
        $invoices = $invoice->where('user_id', $id)->orderBy('created_at', 'desc')->get();
      
        return\ DataTables::of($invoices)
                        ->addColumn('checkbox', function ($model) {
                            return "<input type='checkbox' class='invoice_checkbox' 
                            value=".$model->id.' name=select[] id=check>';
                        })
                        ->addColumn('date', function ($model) use ($client) {
                            $date1 = new \DateTime($model->date);
                            $tz = $client->timezone()->first()->name;
                            $date1->setTimezone(new \DateTimeZone($tz));
                            $date = $date1->format('M j, Y, g:i a ');
                            return $date;
                        })
                        ->addColumn('invoice_no', function ($model) {
                            return  	'<a href='.url('invoices/show?invoiceid='.$model->id).'>'.$model->number.'</a>';
                        })
                        ->addColumn('total', function ($model) use ($client) {
                            return currency_format($model->grand_total, $code =$client->currency);
                        })
                         ->addColumn('paid', function ($model) use ($client) {
                             $payment = \App\Model\Order\Payment::where('invoice_id', $model->id)->select('amount')->get();

This line exceeds maximum limit of 120 characters; contains 123 characters

                             $c=count($payment);
                             $sum = 0;
                             for ($i=0 ;  $i <= $c-1 ; $i++) {
                                 $sum = $sum + $payment[$i]->amount;
                             }
                             return currency_format($sum, $code =$client->currency);
                         })
                         ->addColumn('balance', function ($model) use ($client) {
                             $payment = \App\Model\Order\Payment::where('invoice_id', $model->id)->select('amount')->get();

This line exceeds maximum limit of 120 characters; contains 123 characters

                             $c=count($payment);
                             $sum = 0;
                             for ($i=0 ;  $i <= $c-1 ; $i++) {
                                 $sum = $sum + $payment[$i]->amount;
                             }
                             $pendingAmount = ($model->grand_total)-($sum);
                             return currency_format($pendingAmount, $code =$client->currency);
                         })
                          ->addColumn('status', function ($model) {
                              return $model->status;
                          })
                        ->addColumn('action', function ($model) {
                            $action = '';
                            $cont = new \App\Http\Controllers\Order\TaxRatesAndCodeExpiryController();
                            $check = $cont->checkExecution($model->id);
                            if ($check == false) {
                                $action = '<a href='.url('order/execute?invoiceid='.$model->id)
                                ." class='btn btn-sm btn-primary btn-xs'>
                                <i class='fa fa-tasks' style='color:white;'>
                                 </i>&nbsp;&nbsp; Execute Order</a>";
                            }
                            $editAction = '<a href='.url('invoices/edit/'.$model->id)
                                ." class='btn btn-sm btn-primary btn-xs'>
                                <i class='fa fa-edit' style='color:white;'>
                                 </i>&nbsp;&nbsp; Edit</a>";

                            return '<a href='.url('invoices/show?invoiceid='.$model->id)
                            ." class='btn btn-sm btn-primary btn-xs'><i class='fa fa-eye' 
                            style='color:white;'> </i>&nbsp;&nbsp;View</a>"
                                    ."   $editAction $action";
                        })
                         ->rawColumns(['checkbox', 'date', 'invoice_no', 'total', 'paid', 'balance', 'status','action'])
                        ->make(true);
    }


    public function getOrderDetail($id)
    {
        $client = $this->user->where('id', $id)->first();
        $order = $client->order()->orderBy('created_at', 'desc')->get();

        return\ DataTables::of($order)
                        ->addColumn('checkbox', function ($model) {
                            return "<input type='checkbox' class='order_checkbox' 
                            value=".$model->id.' name=select[] id=checkorder>';
                        })
                        ->addColumn('date', function ($model) {
                            return ucfirst($model->created_at);
                        })
                        ->addColumn('product', function ($model) {
                            $productName = $model->product()->first() && $model->product()->first()->name ?
                            $model->product()->first()->name : 'Unknown';

                            return $productName;
                        })
                        ->addColumn('number', function ($model) {
                            $number= $model->number;

                            return ($number);
                        })
                         ->addColumn('total', function ($model) use ($client) {
                             $price = currency_format($model->price_override, $code = $client->currency);
                             return $price;
                         })
                         ->addColumn('status', function ($model) {
                             $status = $model->order_status;
                             return $status;
                         })
                        ->addColumn('action', function ($model) {
                            return '<a href='.url('orders/'.$model->id)." 
                            class='btn btn-sm btn-primary btn-xs'><i class='fa fa-eye' 
                            style='color:white;'> </i>&nbsp;&nbsp;View</a>";
                        })
                        ->rawColumns(['checkbox', 'date', 'product', 'number', 'total', 'status', 'action'])
                        ->make(true);
    }

    //Get Payment Details on Invoice Page
    public function getPaymentDetail($id)
    {
        $client = $this->user->where('id', $id)->first();
        $payments = $client->payment()->orderBy('created_at', 'desc')->get();
        $extraAmt = $this->getExtraAmtPaid($id);

        return\ DataTables::of($payments)
                        ->addColumn('checkbox', function ($model) {
                            return "<input type='checkbox' class='payment_checkbox' 
                            value=".$model->id.' name=select[] id=checkpayment>';
                        })
                        ->addColumn('invoice_no', function ($model) {
                            return $model->invoice()->first() ? $model->invoice()->first()->number : '--';
                        })
                        ->addColumn('date', function ($model) {
                            $date = $model->created_at;
                            $date1 = new \DateTime($date);
                            $tz = \Auth::user()->timezone()->first()->name;
                            $date1->setTimezone(new \DateTimeZone($tz));
                            $date = $date1->format('M j, Y, g:i a ');
                            return $date;
                        })
                        ->addColumn('payment_method', function ($model) {
                            return $model->payment_method;
                            ;
                        })
                         ->addColumn('total', function ($model) use ($client,$extraAmt) {
                             if ($model->invoice_id == 0) {
                                 $amount = currency_format($extraAmt, $code = $client->currency);
                             } else {
                                 $amount = currency_format($model->amount, $code = $client->currency);
                             }
                             return $amount;
                         })
                         ->addColumn('status', function ($model) {
                             return ucfirst($model->payment_status);
                         })
                      
                        ->rawColumns(['checkbox', 'invoice_no', 'date', 'payment_method', 'total', 'status'])
                        ->make(true);
    }
}