FileXXXXXXXXXXX

File manager - Edit - /var/www/payraty/inventory_main/app/Http/Controllers/Admin/Report/ReportsController.php

Back
<?php namespace App\Http\Controllers\Admin\Report; use App\Models\Warehouse; use App\Services\Product\ProductService; use App\Services\Report\ReportServices; use PDF; use Excel; use Illuminate\Support\Str; use Illuminate\Http\Request; use App\Exports\SalesReportExport; use Illuminate\Support\Collection; use App\Http\Controllers\Controller; use App\Exports\ExpensesReportExport; use App\Exports\PaymentsReportExport; use App\Exports\PurchasesReportExport; use App\Services\Invoice\InvoiceService; use App\Services\Expenses\ExpensesService; use App\Services\Purchase\PurchaseServices; use App\Services\Warehouse\WarehouseService; use Illuminate\Support\Facades\Auth; use Illuminate\Support\Facades\DB; class ReportsController extends Controller { protected $expensesService; protected $invoiceService; protected $purchaseServices; protected $productServices; protected $reportServices; protected $warehouseService; /** * __construct * * @return void / public function __construct( ExpensesService $expensesService, InvoiceService $invoiceService, PurchaseServices $purchaseServices, ProductService $productServices, ReportServices $reportServices, WarehouseService $warehouseService ) { $this->expensesService = $expensesService; $this->invoiceService = $invoiceService; $this->purchaseServices = $purchaseServices; $this->productServices = $productServices; $this->reportServices = $reportServices; $this->warehouseService = $warehouseService; $this->middleware(['permission:Expenses Report'])->only(['expenses']); $this->middleware(['permission:Sales Report'])->only(['sales']); $this->middleware(['permission:Purchases Report'])->only(['purchases']); $this->middleware(['permission:Payments Report'])->only(['payments']); } /* * expenses * * @param mixed $request * @return void / public function expenses(Request $request) { $total = 0; $data = []; $report_range = ''; $start = $request->from_date; $end = $request->to_date; if ($start && $end) { $report_range = $start . ' - ' . $end; $data = $this->expensesService->filterByDateRange($start, $end, ['category']); } if (isset($request->q) && $request->q = 'all-time') { $report_range = 'All Time'; $data = $this->expensesService->get(null, ['category']); } // Calculate total if ($data instanceof Collection) { $total = $data->sum('total'); } set_page_meta(__('custom.expenses_report')); $user = Auth::user(); $profile = DB::table('profiles')->where('user_id', $user->id)->first(); return view('admin.reports.expenses', compact('data', 'report_range', 'total', 'profile')); } /* * exportExpenses * * @param mixed $request * @return void / public function exportExpenses(Request $request) { $total = 0; $data = []; $report_range = ''; $start = $request->from_date; $end = $request->to_date; $type = $request->type; if ($start && $end) { $report_range = $start . ' - ' . $end; $data = $this->expensesService->filterByDateRange($start, $end, ['category']); } else { $report_range = 'All Time'; $data = $this->expensesService->get(null, ['category']); } // Calculate total if ($data instanceof Collection) { $total = $data->sum('total'); } // return view('admin.reports.pdf.expenses', compact('data', 'report_range', 'total')); $name = 'Expenses-report-' . Str::slug($report_range); if ($type == 'pdf') { $pdf = PDF::loadView('admin.reports.pdf.expenses', ['data' => $data, 'report_range' => $report_range, 'total' => $total]); return $pdf->download($name . '.pdf'); } else if ($type == 'csv') { return Excel::download(new ExpensesReportExport($data), $name . '.csv'); } else if ($type == 'excel') { return Excel::download(new ExpensesReportExport($data), $name . '.xlsx'); } } /* * sales * * @param mixed $request * @return void / // public function sales(Request $request) // { // $wareHouses = Warehouse::query()->pluck('name', 'id'); // $gross_total = 0; // $total_paid = 0; // $data = []; // $report_range = ''; // $start = $request->from_date; // $end = $request->to_date; // if ($start && $end) { // $report_range = $start . ' - ' . $end; // $data = $this->invoiceService->filterByDateRange($start, $end); // } // if (isset($request->q) && $request->q = 'all-time') { // $report_range = 'All Time'; // $data = $this->invoiceService->filterWareHouseWiseAll(['warehouse']); // } // // Calculate total // if ($data instanceof Collection) { // $gross_total = $data->sum('total'); // $total_paid = $data->sum('total_paid'); // } // set_page_meta(__('custom.sales_report')); // $user = Auth::user(); // $profile = DB::table('profiles')->where('user_id', $user->id)->first(); // return view('admin.reports.sales', compact('data', 'report_range', 'gross_total', 'total_paid', 'wareHouses', 'profile')); // } public function sales(Request $request) { $wareHouses = Warehouse::query()->pluck('name', 'id'); $gross_total = 0; $total_paid = 0; $data = collect(); // Default empty collection $report_range = ''; $start = $request->from_date; $end = $request->to_date; $search = $request->get('search'); if ($start && $end) { $report_range = $start . ' - ' . $end; $data = $this->invoiceService->filterByDateRange($start, $end); } if (isset($request->q) && $request->q === 'all-time') { $report_range = 'All Time'; $data = $this->invoiceService->filterWareHouseWiseAll(['warehouse']); } // Apply keyword search on filtered data (in-memory) if (!empty($search) && $data instanceof Collection) { $data = $data->filter(function ($invoice) use ($search) { $search = strtolower($search); $customerName = strtolower($invoice->customer['full_name'] ?? ''); $invoiceId = strval($invoice->id); return str_contains($customerName, $search) \|\| str_contains($invoiceId, $search); }); } // Calculate totals if ($data instanceof Collection) { $gross_total = $data->sum('total'); $total_paid = $data->sum('total_paid'); } set_page_meta(__('custom.sales_report')); $user = Auth::user(); $profile = DB::table('profiles')->where('user_id', $user->id)->first(); return view('admin.reports.sales', compact('data', 'report_range', 'gross_total', 'total_paid', 'wareHouses', 'profile')); } /* * exportSales * * @param mixed $request * @return void / public function exportSales(Request $request) { $gross_total = 0; $total_paid = 0; $data = []; $report_range = ''; $start = $request->from_date; $end = $request->to_date; $type = $request->type; if ($start && $end) { $report_range = $start . ' - ' . $end; $data = $this->invoiceService->filterByDateRange($start, $end); } else { $report_range = 'All Time'; $data = $this->invoiceService->get(null); } // Calculate total if ($data instanceof Collection) { $gross_total = $data->sum('total'); $total_paid = $data->sum('total_paid'); } // return view('admin.reports.pdf.sales', compact('data', 'report_range', 'gross_total', 'total_paid')); $name = 'Sales-report-' . Str::slug($report_range); if ($type == 'pdf') { $pdf = PDF::loadView('admin.reports.pdf.sales', ['data' => $data, 'report_range' => $report_range, 'gross_total' => $gross_total, 'total_paid' => $total_paid]); return $pdf->download($name . '.pdf'); } else if ($type == 'csv') { return Excel::download(new SalesReportExport($data), $name . '.csv'); } else if ($type == 'excel') { return Excel::download(new SalesReportExport($data), $name . '.xlsx'); } } /* * purchases * * @param mixed $request * @return void / public function purchases(Request $request) { $wareHouses = Warehouse::query()->pluck('name', 'id'); $total = 0; $data = []; $report_range = ''; $start = $request->from_date; $end = $request->to_date; if ($start && $end) { $report_range = $start . ' - ' . $end; $data = $this->purchaseServices->filterByDateRange($start, $end, ['purchaseItems', 'warehouse']); } if (isset($request->q) && $request->q = 'all-time') { $report_range = 'All Time'; $data = $this->purchaseServices->allTime(['purchaseItems', 'warehouse']); } // Calculate total if ($data instanceof Collection) { $total = $data->sum('total'); } // return $data; set_page_meta(__('custom.purchases_report')); $user = Auth::user(); $profile = DB::table('profiles')->where('user_id', $user->id)->first(); return view('admin.reports.purchases', compact('data', 'report_range', 'total', 'wareHouses', 'profile')); } /* * exportPurchases * * @param mixed $request * @return void / public function exportPurchases(Request $request) { $total = 0; $data = []; $report_range = ''; $start = $request->from_date; $end = $request->to_date; $type = $request->type; if ($start && $end) { $report_range = $start . ' - ' . $end; $data = $this->purchaseServices->filterByDateRange($start, $end); } else { $report_range = 'All Time'; $data = $this->purchaseServices->get(null); } // Calculate total if ($data instanceof Collection) { $total = $data->sum('total'); } // return view('admin.reports.pdf.purchases', compact('data', 'report_range', 'total')); $name = 'Purchase-report-' . Str::slug($report_range); if ($type == 'pdf') { $pdf = PDF::loadView('admin.reports.pdf.purchases', ['data' => $data, 'report_range' => $report_range, 'total' => $total]); return $pdf->download($name . '.pdf'); } else if ($type == 'csv') { return Excel::download(new PurchasesReportExport($data), $name . '.csv'); } else if ($type == 'excel') { return Excel::download(new PurchasesReportExport($data), $name . '.xlsx'); } } /* * payments * * @param mixed $request * @return void / public function payments(Request $request) { $wareHouses = Warehouse::query()->pluck('name', 'id'); $total = 0; $data = []; $report_range = ''; $start = $request->from_date; $end = $request->to_date; if ($start && $end) { $report_range = $start . ' - ' . $end; $data = $this->invoiceService->filterPaymentByDateRange($start, $end, ['invoice.warehouse']); } if (isset($request->q) && $request->q = 'all-time') { $report_range = 'All Time'; $data = $this->invoiceService->getAllPayments(['invoice.warehouse']); } // Calculate total if ($data instanceof Collection) { $total = $data->sum('amount'); } set_page_meta(__('custom.payments_report')); return view('admin.reports.payments', compact('data', 'report_range', 'total', 'wareHouses', 'profile')); } /* * exportPayments * * @param mixed $request * @return void / public function exportPayments(Request $request) { $total = 0; $data = []; $report_range = ''; $start = $request->from_date; $end = $request->to_date; $type = $request->type; if ($start && $end) { $report_range = $start . ' - ' . $end; $data = $this->invoiceService->filterPaymentByDateRange($start, $end); } else { $report_range = 'All Time'; $data = $this->invoiceService->getAllPayments(); } // Calculate total if ($data instanceof Collection) { $total = $data->sum('amount'); } // return view('admin.reports.pdf.payments', compact('data', 'report_range', 'total')); $name = 'Payment-report-' . Str::slug($report_range); if ($type == 'pdf') { $pdf = PDF::loadView('admin.reports.pdf.payments', ['data' => $data, 'report_range' => $report_range, 'total' => $total]); // return $pdf->download($name . '.pdf'); return $pdf->download($name . '.pdf',array("Attachment" => false)); } else if ($type == 'csv') { return Excel::download(new PaymentsReportExport($data), $name . '.csv'); } else if ($type == 'excel') { return Excel::download(new PaymentsReportExport($data), $name . '.xlsx'); } } public function warehouseStock(Request $request) { set_page_meta(__('custom.warehouse_stock_report')); $report_range = "All time"; $products = $this->productServices->productAllWarehouseStock(); $warehouses = Warehouse::query()->pluck('name', 'id'); $user = Auth::user(); $profile = DB::table('profiles')->where('user_id', $user->id)->first(); return view('admin.reports.warehouse-stock', compact('report_range', 'products', 'warehouses', 'profile')); } public function warehousePrice(Request $request) { $warehouses = Warehouse::with('product_stocks.product')->get(); $data = []; foreach ($warehouses as $warehouse) { $totalPrice = 0; $totalQuantity = 0; foreach ($warehouse->product_stocks as $productStock) { $totalPrice += optional($productStock->product)->price $productStock->quantity; $totalQuantity += $productStock->quantity; } $data [$warehouse->name] = [$totalPrice, $totalQuantity]; // dump("Total price for {$warehouse->name}: {$totalPrice}"); } // dd($data); $user = Auth::user(); $profile = DB::table('profiles')->where('user_id', $user->id)->first(); return view('admin.reports.warehouse-price', compact('data', 'profile')); } public function lossProfit(Request $request) { try { set_page_meta(__('custom.loss_profit_report')); $wareHouses = Warehouse::query()->pluck('name', 'id'); $report_range = ''; $start = $request->from_date; $end = $request->to_date; if ($start && $end) { $report_range = $start . ' - ' . $end; } if (isset($request->q) && $request->q = 'all-time') { $report_range = 'All Time'; } $loss_profit_data = $this->reportServices->lossProfitCalculation($request); $user = Auth::user(); $profile = DB::table('profiles')->where('user_id', $user->id)->first(); return view('admin.reports.loss-profit', compact('wareHouses', 'loss_profit_data', 'report_range', 'profile')); } catch (\Exception $e) { logger($e); flash(__('custom.something_want_wrong_maybe_your_product_stock_not_created_yet'))->error(); return redirect()->back(); } } }

| ver. 1.4 | Github | . | PHP 8.3.30 | Generation time: 0 | proxy | phpinfo | Settings