Queries::getInvoiceByStatus() - Code Metrics - Inspection of "added a query to get all invoices by status" - dbrax/bill-me - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — main ( 236975...3409a6 )

by Emmanuel

created 2021-03-21 13:02 UTC

Queries::getInvoiceByStatus() A

↳ Parent: Queries

Complexity

Conditions	1
Paths	1

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	4
rs	10
c	0
b	0
f	0
cc	1
nc	1
nop	1

<?php

/**
 * Author: Emmanuel Paul Mnzava
 * Twitter: @epmnzava
 * Github: https://github.com/dbrax/bill-me
 * Email: [email protected]
 *
 */

namespace Epmnzava\BillMe;

use Carbon\Carbon;
use Epmnzava\BillMe\Models\BillingPayment;
use Epmnzava\BillMe\Models\Order;
use Epmnzava\BillMe\Models\Invoice;
use Epmnzava\BillMe\Models\OrderItem;
use Epmnzava\BillMe\Mail\Client\Invoices\InvoiceCreated;
use Epmnzava\BillMe\Mail\Client\OrderReceived;
use Epmnzava\BillMe\Mail\Merchant\NewOrder;

use Mail;

class Queries extends Stats
{

    public function orders()
    {

        return Order::all();
    }


    public function orders_orderby($orderby)

    {
    }



    public function orders_today()
    {
        return Order::where('date', date('Y-m-d'))->get();
    }


    public function get_orders_with_status($status)
    {
        return Order::where('status', $status)->get();
    }

    public function pending_orders()
    {
        return Order::where('status', "pending")->get();
    }

    public function cancelled_orders()
    {
        return Order::where('status', "cancelled")->get();
    }

    public function completed_orders()
    {
        return Order::where('status', "completed")->get();
    }

    public function getOrderById($orderid)
    {
        return Order::find($orderid);
    }

    public function getOrdersOnDate($date)
    {
        return Order::where('date', $date)->get();
    }


    public function getOrdersOnDateRange($startdate, $enddate)

    {
    }


    /** Function to get an invoice */
    public function getInvoiceById($invoiceid)
    {
        return Invoice::find($invoiceid);
    }


    /** Function to get an invoice */
    public function getInvoiceByOrderId($orderid)
    {
        return Invoice::find(Order::where('id', $orderid)->first()->invoiceid);
    }



    /**
     *
     * User Queries
     */


    /** Function to get given user orders */
    public function getUserOrders($userid)
    {
        return Order::where('userid', $userid)->get();
    }


    /** Function to get given user orders by status */
    public function getUserOrdersByStatus($userid, $status)
    {
        return Order::where('userid', $userid)->where('status', $status)->get();
    }


    /** Function to get given user invoices */
    public function getUserInvoices($userid)
    {
        return Invoice::where('userid', $userid)->get();
    }


    /** Function that returns total number of user invoices */
    public function totalUserInvoices($userid): int
    {
        return Invoice::where('userid', $userid)->count();
    }




    /** Function to get given user invoices by status */
    public function getUserInvoiceByStatus($userid, $status)
    {
        return Invoice::where('userid', $userid)->where('status', $status)->get();
    }




    /** Function to get given all  invoices by status */
    public function getInvoiceByStatus( $status)
    {
        return Invoice::where('status', $status)->get();
    }


    /**
     * @param $userid
     * @param $status
     * @return mixed
     * Function to get given user invoices by status
     */
    public function sumUserInvoiceByStatus($userid, $status) : int
    {
        return Invoice::where('userid', $userid)->where('status', $status)->sum('amount');
    }





    /**
     * @param $userid
     * @param $status
     * @return mixed
     *  Function to get given user invoices by status
     */
    public function totalUserInvoiceByStatus($userid, $status)
    {
        return Invoice::where('userid', $userid)->where('status', $status)->count();
    }

    /** Function that gets full  billing history */

    public function getAllBillingHistory()
    {

        return BillingPayment::all();
    }


    /** Function that gets full user billing history*/

    public function getUserBillingHistory($userid)
    {

        return BillingPayment::where('userid', $userid)->get();
    }




    public function getUserBillingHistoryByStartDate($userid, $start_date)
    {

        return BillingPayment::where('userid', $userid)->where('date', $start_date)->get();
    }


    /** Function to get payment history of a given user for a given period */

    public function getUserBillingHistoryBetweenDates($userid, $start_date, $enddate)
    {

        return BillingPayment::where('userid', $userid)->whereBetween('date', [$start_date, $enddate])->get();
    }


    /**
     * Returns the model instance to be updated
     */
    public function updateBillingHistory($invoiceid): BillingPayment
    {
        return BillingPayment::find(BillingPayment::where('invoiceid', $invoiceid)->first()->id);
    }


    /**
     * Returns the model instance to be updated
     */
    public function updateInvoiceByInstance($invoiceid): Invoice
    {
        return Invoice::find($invoiceid);
    }

    /**
     *
     * Returns updated invoice with new due_date
     */
    public function updateDueDate($date, $invoiceid): Invoice
    {
        $invoice = $this->updateInvoiceByInstance($invoiceid);
        $invoice->due_date = $date;
        $invoice->save();
        return $invoice;
    }



 public function getBillingHistoryByStatus($status)
    {

        return BillingPayment::where('status', $status)->get();
    }


    public function getUserBillingHistoryByStatus($userid, $status)
    {

        return BillingPayment::where('userid', $userid)->where('status', $status)->get();
    }

    /** Return OrderItems for particular order
     *@param $orderid
     **/
    public function getOrderItems($orderid)
    {

        return OrderItem::where('order_id', $orderid)->get();
    }


    /** Return OrderItems for particular order gets invoiceid
     *@param $invoiceid
     **/
    public function getOrderItemsByInvoiceId($invoiceid)
    {

        return OrderItem::where('order_id', Invoice::where('id', $invoiceid)->first()->orderid)->get();
    }
}


1			<?php
2
3			/**
4			* Author: Emmanuel Paul Mnzava
5			* Twitter: @epmnzava
6			* Github: https://github.com/dbrax/bill-me
7			* Email: [email protected]
8			*
9			*/
10
11			namespace Epmnzava\BillMe;
12
13			use Carbon\Carbon;
14			use Epmnzava\BillMe\Models\BillingPayment;
15			use Epmnzava\BillMe\Models\Order;
16			use Epmnzava\BillMe\Models\Invoice;
17			use Epmnzava\BillMe\Models\OrderItem;
18			use Epmnzava\BillMe\Mail\Client\Invoices\InvoiceCreated;
19			use Epmnzava\BillMe\Mail\Client\OrderReceived;
20			use Epmnzava\BillMe\Mail\Merchant\NewOrder;
21
22			use Mail;
23
24			class Queries extends Stats
25			{
26
27			public function orders()
28			{
29
30			return Order::all();
31			}
32
33
34			public function orders_orderby($orderby)
			0 ignored issues – show Unused Code introduced 2021-02-07 15:06 UTC by Report Bug Copy Issue Report The parameter `$orderby` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
35			{
36			}
37
38
39
40			public function orders_today()
41			{
42			return Order::where('date', date('Y-m-d'))->get();
43			}
44
45
46			public function get_orders_with_status($status)
47			{
48			return Order::where('status', $status)->get();
49			}
50
51			public function pending_orders()
52			{
53			return Order::where('status', "pending")->get();
54			}
55
56			public function cancelled_orders()
57			{
58			return Order::where('status', "cancelled")->get();
59			}
60
61			public function completed_orders()
62			{
63			return Order::where('status', "completed")->get();
64			}
65
66			public function getOrderById($orderid)
67			{
68			return Order::find($orderid);
69			}
70
71			public function getOrdersOnDate($date)
72			{
73			return Order::where('date', $date)->get();
74			}
75
76
77			public function getOrdersOnDateRange($startdate, $enddate)
			0 ignored issues – show Unused Code introduced 2021-02-07 15:01 UTC by Report Bug Copy Issue Report The parameter `$startdate` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history... Unused Code introduced 2021-02-07 15:01 UTC by Report Bug Copy Issue Report The parameter `$enddate` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
78			{
79			}
80
81
82			/** Function to get an invoice */
83			public function getInvoiceById($invoiceid)
84			{
85			return Invoice::find($invoiceid);
86			}
87
88
89			/** Function to get an invoice */
90			public function getInvoiceByOrderId($orderid)
91			{
92			return Invoice::find(Order::where('id', $orderid)->first()->invoiceid);
93			}
94
95
96
97			/**
98			*
99			* User Queries
100			*/
101
102
103			/** Function to get given user orders */
104			public function getUserOrders($userid)
105			{
106			return Order::where('userid', $userid)->get();
107			}
108
109
110			/** Function to get given user orders by status */
111			public function getUserOrdersByStatus($userid, $status)
112			{
113			return Order::where('userid', $userid)->where('status', $status)->get();
114			}
115
116
117			/** Function to get given user invoices */
118			public function getUserInvoices($userid)
119			{
120			return Invoice::where('userid', $userid)->get();
121			}
122
123
124			/** Function that returns total number of user invoices */
125			public function totalUserInvoices($userid): int
126			{
127			return Invoice::where('userid', $userid)->count();
128			}
129
130
131
132
133			/** Function to get given user invoices by status */
134			public function getUserInvoiceByStatus($userid, $status)
135			{
136			return Invoice::where('userid', $userid)->where('status', $status)->get();
137			}
138
139
140
141
142			/** Function to get given all invoices by status */
143			public function getInvoiceByStatus( $status)
144			{
145			return Invoice::where('status', $status)->get();
146			}
147
148
149			/**
150			* @param $userid
151			* @param $status
152			* @return mixed
153			* Function to get given user invoices by status
154			*/
155			public function sumUserInvoiceByStatus($userid, $status) : int
156			{
157			return Invoice::where('userid', $userid)->where('status', $status)->sum('amount');
158			}
159
160
161
162
163
164			/**
165			* @param $userid
166			* @param $status
167			* @return mixed
168			* Function to get given user invoices by status
169			*/
170			public function totalUserInvoiceByStatus($userid, $status)
171			{
172			return Invoice::where('userid', $userid)->where('status', $status)->count();
173			}
174
175			/** Function that gets full billing history */
176
177			public function getAllBillingHistory()
178			{
179
180			return BillingPayment::all();
181			}
182
183
184			/** Function that gets full user billing history*/
185
186			public function getUserBillingHistory($userid)
187			{
188
189			return BillingPayment::where('userid', $userid)->get();
190			}
191
192
193
194
195			public function getUserBillingHistoryByStartDate($userid, $start_date)
196			{
197
198			return BillingPayment::where('userid', $userid)->where('date', $start_date)->get();
199			}
200
201
202			/** Function to get payment history of a given user for a given period */
203
204			public function getUserBillingHistoryBetweenDates($userid, $start_date, $enddate)
205			{
206
207			return BillingPayment::where('userid', $userid)->whereBetween('date', [$start_date, $enddate])->get();
208			}
209
210
211			/**
212			* Returns the model instance to be updated
213			*/
214			public function updateBillingHistory($invoiceid): BillingPayment
215			{
216			return BillingPayment::find(BillingPayment::where('invoiceid', $invoiceid)->first()->id);
217			}
218
219
220			/**
221			* Returns the model instance to be updated
222			*/
223			public function updateInvoiceByInstance($invoiceid): Invoice
224			{
225			return Invoice::find($invoiceid);
226			}
227
228			/**
229			*
230			* Returns updated invoice with new due_date
231			*/
232			public function updateDueDate($date, $invoiceid): Invoice
233			{
234			$invoice = $this->updateInvoiceByInstance($invoiceid);
235			$invoice->due_date = $date;
236			$invoice->save();
237			return $invoice;
238			}
239
240
241
242			public function getBillingHistoryByStatus($status)
243			{
244
245			return BillingPayment::where('status', $status)->get();
246			}
247
248
249			public function getUserBillingHistoryByStatus($userid, $status)
250			{
251
252			return BillingPayment::where('userid', $userid)->where('status', $status)->get();
253			}
254
255			/** Return OrderItems for particular order
256			*@param $orderid
257			**/
258			public function getOrderItems($orderid)
259			{
260
261			return OrderItem::where('order_id', $orderid)->get();
262			}
263
264
265			/** Return OrderItems for particular order gets invoiceid
266			*@param $invoiceid
267			**/
268			public function getOrderItemsByInvoiceId($invoiceid)
269			{
270
271			return OrderItem::where('order_id', Invoice::where('id', $invoiceid)->first()->orderid)->get();
272			}
273			}
274

dbrax / bill-me

Push — main ( 236975...3409a6 )

Queries::getInvoiceByStatus() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like