/** * Get client details. * * @param int $clientId * @return array */ public function getClient($clientId) { $response = new AjaxResponse(); // Get client $client = Client::where('clients.id', $clientId)->where('clients.user_id', Auth::user()->id)->join('bills', 'clients.id', '=', 'bills.client_id')->select('clients.*', DB::raw('COUNT(bills.id) as total_bills'))->first(); // Make sure client exists if (!$client->id) { $response->setFailMessage(trans('clients.client_not_found')); $response->addExtraFields(['redirect_to' => url('/clients')]); return response($response->get(), $response->getDefaultErrorResponseCode()); } // Get client last unpaid bills $client->last_unpaid_bills = Clients::lastUnpaidBills($clientId); // Get client last paid bills $client->last_paid_bills = Clients::lastPaidBills($clientId); // Get client statistics $client->statistics = ClientStatistics::all($clientId); $client->money_generated = trans('clients.money_generated', ['money' => $client->statistics['earnings']]); $client->money_generated_in_current_year = trans('clients.money_generated_by_this_client_in_this_year_more_details', ['money' => $client->statistics['earnings_in_current_year']]); $client->number_of_products_sold = trans('clients.number_of_products_sold', ['number' => $client->statistics['number_of_products_ordered']]); $client->number_of_products_sold_this_year = trans('clients.number_of_products_sold_this_year', ['number' => $client->statistics['number_of_products_ordered_this_year']]); // Money user has to receive from this client $client->money_user_has_to_receive = 0; if ($client->statistics['money_user_has_to_receive'] > 0) { $client->money_user_has_to_receive = trans('clients.client_has_to_pay', ['sum' => $client->statistics['money_user_has_to_receive']]); } // Money client owes $client->money_owed_due_passed_payment_term = 0; if ($client->statistics['money_owed_due_passed_payment_term'] > 0) { $client->money_owed_due_passed_payment_term = trans('clients.client_has_to_pay_due_passed_payment_term', ['sum' => $client->statistics['money_owed_due_passed_payment_term']]); } $response->setSuccessMessage(''); $response->addExtraFields(['data' => $client]); return response($response->get()); }
/** * Make sure all method works as expected. */ public function test_all_client_statistics_method() { // Calculate expected earnings $expectedEarnings = $this->billProduct->final_price + $this->secondBillProduct->final_price; $expectedEarnings += $this->billApplicationProduct->final_price + $this->secondBillApplicationProduct->final_price; $expectedEarnings = number_format($expectedEarnings, 2); // Calculate earnings in current campaign $expectedEarningsInCurrentCampaign = 0; // Calculate money user has to receive $expectedMoneyUserHasToReceive = 0; // Calculate number of products ordered $expectedNumberOfProductsOrdered = $this->billProduct->quantity + $this->secondBillProduct->quantity; $expectedNumberOfProductsOrdered += $this->billApplicationProduct->quantity + $this->secondBillApplicationProduct->quantity; // Calculate total discount received $expectedDiscountReceived = ($this->billProduct->price - $this->billProduct->final_price) * $this->billProduct->quantity; $expectedDiscountReceived += ($this->secondBillProduct->price - $this->secondBillProduct->final_price) * $this->secondBillProduct->quantity; $expectedDiscountReceived += ($this->billApplicationProduct->price - $this->billApplicationProduct->final_price) * $this->billApplicationProduct->quantity; $expectedDiscountReceived += ($this->secondBillApplicationProduct->price - $this->secondBillApplicationProduct->final_price) * $this->secondBillApplicationProduct->quantity; $this->assertEquals($expectedEarnings, ClientStatistics::earnings($this->client->id)); $this->assertEquals(floor($expectedMoneyUserHasToReceive), floor(ClientStatistics::moneyUserHasToReceive($this->client->id))); $this->assertEquals($expectedNumberOfProductsOrdered, ClientStatistics::totalNumberOfProductsOrdered($this->client->id)); $this->assertEquals(floor($expectedDiscountReceived), floor(ClientStatistics::totalDiscountReceived($this->client->id))); }