芝麻web文件管理V1.00
编辑当前文件:/home/pulsehostuk9/www/invoicer.pulsehost.co.uk/app/Http/Controllers/V1/CustomersController.php
authorize('viewAny', Customer::class); $limit = $request->has('limit') ? $request->limit : 10; $customers = Customer::with('creator') ->whereCompany() ->applyFilters($request->all()) ->select( 'customers.*', DB::raw('sum(invoices.base_due_amount) as base_due_amount'), DB::raw('sum(invoices.due_amount) as due_amount'), ) ->groupBy('customers.id') ->leftJoin('invoices', 'customers.id', '=', 'invoices.customer_id') ->paginateData($limit); return CustomerResource::collection($customers) ->additional(['meta' => [ 'customer_total_count' => Customer::whereCompany()->count(), ]]); } /** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\JsonResponse */ public function store(Requests\CustomerRequest $request) { $this->authorize('create', Customer::class); $customer = Customer::createCustomer($request); return new CustomerResource($customer); } /** * Display the specified resource. * * @return \Illuminate\Http\JsonResponse */ public function show(Customer $customer) { $this->authorize('view', $customer); return new CustomerResource($customer); } /** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\JsonResponse */ public function update(Requests\CustomerRequest $request, Customer $customer) { $this->authorize('update', $customer); $customer = Customer::updateCustomer($request, $customer); if (is_string($customer)) { return respondJson('you_cannot_edit_currency', 'Cannot change currency once transactions created'); } return new CustomerResource($customer); } /** * Remove a list of Customers along side all their resources (ie. Estimates, Invoices, Payments and Addresses) * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\JsonResponse */ public function delete(DeleteCustomersRequest $request) { $this->authorize('delete multiple customers'); Customer::deleteCustomers($request->ids); return response()->json([ 'success' => true, ]); } }