File manager

File manager - Edit - /home/linknsbh/sabel-eltaqwa.com/assets/lfm/files/shares/events/thumbs/Exports.tar

Back
ProductPurchaseReturnReportExport.php��0000644��00000001240�15213411207�0014157 0��ustar�00��<?php namespace App\Exports; use App\Models\PurchaseReturn; use Maatwebsite\Excel\Concerns\FromView; class ProductPurchaseReturnReportExport implements FromView { public function view(): \Illuminate\Contracts\View\View { $productId = request()->get('product_id'); $purchaseReturns = PurchaseReturn::whereHas('purchaseReturnItems', function ($q) use ($productId) { $q->where('product_id', '=', $productId); })->with(['purchaseReturnItems.product', 'supplier'])->get(); return view('excel.product-purchase-return-report-excel', ['purchaseReturns' => $purchaseReturns, 'productId' => $productId]); } } ��SaleReportExport.php��0000644��00000001635�15213411207�0010540 0��ustar�00��<?php namespace App\Exports; use App\Models\Sale; use Maatwebsite\Excel\Concerns\FromView; class SaleReportExport implements FromView { public function view(): \Illuminate\Contracts\View\View { $startDate = request()->get('start_date'); $endDate = request()->get('end_date'); $userId = request()->get('user_id'); $query = Sale::with(['saleItems', 'warehouse', 'customer', 'payments']); // Filter by date if ($startDate != 'null' && $endDate != 'null' && $startDate && $endDate) { $query->whereDate('created_at', '>=', $startDate) ->whereDate('created_at', '<=', $endDate); } // Filter by user_id if ($userId && $userId != 'null') { $query->where('user_id', $userId); } $sales = $query->get(); return view('excel.all-sale-report-excel', ['sales' => $sales]); } } ��ExpenseWarehouseReportExport.php��0000644��00000001436�15213411207�0013145 0��ustar�00��<?php namespace App\Exports; use App\Models\Expense; use Maatwebsite\Excel\Concerns\FromView; class ExpenseWarehouseReportExport implements FromView { public function view(): \Illuminate\Contracts\View\View { $warehouseId = request()->get('warehouse_id'); $query = Expense::with('warehouse', 'expenseCategory', 'user')->has('warehouse'); if (isset($warehouseId) && $warehouseId != 'null') { $query->whereWarehouseId($warehouseId); } $expenses = $query->with([ 'warehouse', 'expenseCategory', 'user' => function ($query) { $query->withoutGlobalScope('tenant'); } ])->get(); return view('excel.expense-report-excel', ['expenses' => $expenses]); } } ��PurchaseReturnWarehouseReportExport.php��0000644��00000001631�15213411207�0014505 0��ustar�00��<?php namespace App\Exports; use App\Models\PurchaseReturn; use Maatwebsite\Excel\Concerns\FromView; class PurchaseReturnWarehouseReportExport implements FromView { public function view(): \Illuminate\Contracts\View\View { $warehouseId = request()->get('warehouse_id'); $supplierId = request()->get('supplier_id'); if (isset($warehouseId) && $warehouseId != 'null') { $purchaseReturns = PurchaseReturn::whereWarehouseId($warehouseId)->with('warehouse', 'supplier')->get(); } elseif (isset($supplierId) && $supplierId != 'null') { $purchaseReturns = PurchaseReturn::whereSupplierId($supplierId)->with('warehouse', 'supplier')->get(); } else { $purchaseReturns = PurchaseReturn::with('warehouse', 'supplier')->get(); } return view('excel.purchase-return-report-excel', ['purchaseReturns' => $purchaseReturns]); } } ��ProductSaleReportExport.php��0000644��00000001071�15213411207�0012073 0��ustar�00��<?php namespace App\Exports; use App\Models\Sale; use Maatwebsite\Excel\Concerns\FromView; class ProductSaleReportExport implements FromView { public function view(): \Illuminate\Contracts\View\View { $productId = request()->get('product_id'); $sales = Sale::whereHas('saleItems', function ($q) use ($productId) { $q->where('product_id', '=', $productId); })->with(['saleItems.product', 'customer'])->get(); return view('excel.product-sale-report-excel', ['sales' => $sales, 'productId' => $productId]); } } ��PurchaseReportExport.php��0000644��00000001503�15213411207�0011420 0��ustar�00��<?php namespace App\Exports; use App\Models\Purchase; use Maatwebsite\Excel\Concerns\FromView; class PurchaseReportExport implements FromView { public function view(): \Illuminate\Contracts\View\View { $startDate = request()->get('start_date'); $endDate = request()->get('end_date'); if ($startDate != 'null' && $endDate != 'null' && $startDate && $endDate) { $purchases = Purchase::with(['purchaseItems', 'warehouse', 'supplier'])->whereDate('created_at', '>=', $startDate) ->whereDate('created_at', '<=', $endDate) ->get(); } else { $purchases = Purchase::with(['purchaseItems', 'warehouse', 'supplier'])->get(); } return view('excel.all-purchase-report-excel', ['purchases' => $purchases]); } } ��PurchasesWarehouseReportExport.php��0000644��00000001527�15213411207�0013474 0��ustar�00��<?php namespace App\Exports; use App\Models\Purchase; use Maatwebsite\Excel\Concerns\FromView; class PurchasesWarehouseReportExport implements FromView { public function view(): \Illuminate\Contracts\View\View { $warehouseId = request()->get('warehouse_id'); $supplierId = request()->get('supplier_id'); if (isset($warehouseId) && $warehouseId != 'null') { $purchases = Purchase::whereWarehouseId($warehouseId)->with('warehouse', 'supplier')->get(); } elseif (isset($supplierId) && $supplierId != 'null') { $purchases = Purchase::whereSupplierId($supplierId)->with('warehouse', 'supplier')->get(); } else { $purchases = Purchase::with('warehouse', 'supplier')->get(); } return view('excel.purchase-report-excel', ['purchases' => $purchases]); } } ��ProductPurchaseReportExport.php��0000644��00000001136�15213411207�0012763 0��ustar�00��<?php namespace App\Exports; use App\Models\Purchase; use Maatwebsite\Excel\Concerns\FromView; class ProductPurchaseReportExport implements FromView { public function view(): \Illuminate\Contracts\View\View { $productId = request()->get('product_id'); $purchases = Purchase::whereHas('purchaseItems', function ($q) use ($productId) { $q->where('product_id', '=', $productId); })->with(['purchaseItems.product', 'supplier'])->get(); return view('excel.product-purchases-report-excel', ['purchases' => $purchases, 'productId' => $productId]); } } ��StockReportExport.php��0000644��00000000702�15213411207�0010731 0��ustar�00��<?php namespace App\Exports; use App\Models\ManageStock; use Maatwebsite\Excel\Concerns\FromView; class StockReportExport implements FromView { public function view(): \Illuminate\Contracts\View\View { $warehouseId = request()->get('warehouse_id'); $stocks = ManageStock::whereWarehouseId($warehouseId)->with('product', 'warehouse')->get(); return view('excel.stock-report-excel', ['stocks' => $stocks]); } } ��SaleReturnWarehouseReportExport.php��0000644��00000001214�15213411207�0013614 0��ustar�00��<?php namespace App\Exports; use App\Models\SaleReturn; use Maatwebsite\Excel\Concerns\FromView; class SaleReturnWarehouseReportExport implements FromView { public function view(): \Illuminate\Contracts\View\View { $warehouseId = request()->get('warehouse_id'); if (isset($warehouseId) && $warehouseId != 'null') { $saleReturns = SaleReturn::whereWarehouseId($warehouseId)->with('warehouse', 'customer')->get(); } else { $saleReturns = SaleReturn::with('warehouse', 'customer')->get(); } return view('excel.sale-return-report-excel', ['saleReturns' => $saleReturns]); } } ��TopSellingProductReportExport.php��0000644��00000003666�15213411207�0013303 0��ustar�00��<?php namespace App\Exports; use App\Models\Product; use Carbon\Carbon; use Maatwebsite\Excel\Concerns\FromView; class TopSellingProductReportExport implements FromView { public function view(): \Illuminate\Contracts\View\View { if (request()->get('start_date') && request()->get('start_date') && request()->get('start_date') != 'null' && request()->get('start_date') != 'null') { $startDate = Carbon::parse(request()->get('start_date'))->toDateTimeString(); $endDate = Carbon::parse(request()->get('end_date'))->toDateTimeString(); $topSelling = Product::leftJoin('sale_items', 'products.id', '=', 'sale_items.product_id') ->whereDate('sale_items.created_at', '>=', $startDate) ->whereDate('sale_items.created_at', '<=', $endDate) ->selectRaw('products., COALESCE(sum(sale_items.sub_total),0) grand_total') ->selectRaw('products., COALESCE(sum(sale_items.quantity),0) total_quantity') ->groupBy('products.id') ->orderBy('total_quantity', 'desc') ->latest() ->get(); } else { $topSelling = Product::leftJoin('sale_items', 'products.id', '=', 'sale_items.product_id') ->selectRaw('products., COALESCE(sum(sale_items.sub_total),0) grand_total') ->selectRaw('products., COALESCE(sum(sale_items.quantity),0) total_quantity') ->groupBy('products.id') ->orderBy('total_quantity', 'desc') ->latest() ->get(); } $topSellingProducts = []; foreach ($topSelling as $topSelling) { $topSellingProducts[] = $topSelling->prepareTopSellingReport(); // if ($topSelling->total_quantity != 0) { // } } return view('excel.top-selling-product-report-excel', ['topSellingProducts' => $topSellingProducts]); } } ��SalesWarehouseReportExport.php��0000644��00000001126�15213411207�0012601 0��ustar�00��<?php namespace App\Exports; use App\Models\Sale; use Maatwebsite\Excel\Concerns\FromView; class SalesWarehouseReportExport implements FromView { public function view(): \Illuminate\Contracts\View\View { $warehouseId = request()->get('warehouse_id'); if (isset($warehouseId) && $warehouseId != 'null') { $sales = Sale::whereWarehouseId($warehouseId)->with('warehouse', 'customer')->get(); } else { $sales = Sale::with('warehouse', 'customer')->get(); } return view('excel.sale-report-excel', ['sales' => $sales]); } } ��ProductExcelExport.php��0000644��00000001570�15213411207�0011057 0��ustar�00��<?php namespace App\Exports; use App\Models\Product; use Maatwebsite\Excel\Concerns\FromView; class ProductExcelExport implements FromView { public function view(): \Illuminate\Contracts\View\View { if (isset(request()->id)) { $products = Product::with([ 'productCategory', 'brand', 'stock', 'variationProduct.variation', 'variationProduct.variationType' ])->where('product_unit', request()->id)->get(); } else { $products = Product::with([ 'productCategory', 'brand', 'stock', 'variationProduct.variation', 'variationProduct.variationType' ])->get(); } return view('excel.product-excel-export', ['products' => $products]); } } ��ProductSaleReturnReportExport.php��0000644��00000001175�15213411207�0013300 0��ustar�00��<?php namespace App\Exports; use App\Models\SaleReturn; use Maatwebsite\Excel\Concerns\FromView; class ProductSaleReturnReportExport implements FromView { public function view(): \Illuminate\Contracts\View\View { $productId = request()->get('product_id'); $saleReturns = SaleReturn::whereHas('saleReturnItems', function ($q) use ($productId) { $q->where('product_id', '=', $productId); })->with(['saleReturnItems.product', 'customer'])->get(); return view('excel.product-sale-returns-report-excel', ['saleReturns' => $saleReturns, 'productId' => $productId]); } } ��

| ver. 1.4 | Github | . | PHP 8.2.31 | Generation time: 0.38 | proxy | phpinfo | Settings