Hisobotlar: qoldiq, savdo, debitorlik
Amaliy mashg‘ulot oxirida siz quyidagilarni bajara olasiz...
ReportService: ombor qoldiqlari, davr bo‘yicha savdo, debitorlik qarzi va uning muddatiFILTER, date_trunc va Eloquent withSum/withCount niQanday bajariladi va qanday baholanadi?
Ish tartibi
- Saytga login va parolingiz bilan kiring: emro.uz/korxona/kirish.html
- 9-amaliy sahifasini oching (oxirgi slayddagi QR kod).
- Yo‘riqnoma bo‘yicha jamoa loyihasida bosqichni bajaring, commit va push qiling.
- PHP topshiriqlarni yeching: ▶ Sinab ko‘rish → ✓ Topshirish (yashirin testlar).
- Loyiha havolasini (GitHub repo, PR yoki tag) topshiring — o‘qituvchi baho qo‘yadi.
Baholash mezonlari
- Natija — loyiha bosqichi mezonlar ro‘yxati bo‘yicha bajarilgan.
- Topshiriqlar — PHP topshiriqlar testlardan o‘tgan.
- Kod sifati — tushunarli nomlar, PSR-12, kichik va mazmunli commitlar.
- Jamoaviy hissa — har bir a’zo o‘z qismini tushuntira oladi; ko‘chirilgan ish baholanmaydi.
- Muddat — muddatdan keyin topshirilgan ish “kechikkan” deb belgilanadi.
1-qadam. ReportService va hisobot ekranlari
receivables(): qarz va muddat guruhlari
public function receivables(CarbonImmutable $asOf): Collection { $d = $asOf->toDateString(); $sum = 'SUM(i.total - i.paid_amount)'; $f = fn (string $cond) => "$sum FILTER (WHERE ?::date - i.due_at::date $cond)"; return DB::table('invoices as i') ->join('counterparties as c', 'c.id', '=', 'i.counterparty_id') ->whereIn('i.status', ['unpaid', 'partial']) ->select('c.id', 'c.name', 'c.inn') ->selectRaw("$sum AS total_debt") ->selectRaw($f('<= 0') . ' AS not_due', [$d]) ->selectRaw($f('BETWEEN 1 AND 30') . ' AS d1_30', [$d]) ->selectRaw($f('> 30') . ' AS d30_plus', [$d]) ->groupBy('c.id', 'c.name', 'c.inn') ->orderByDesc('total_debt') ->get(); }
name | inn | total_debt | not_due | d1_30 | d30_plus “Baraka Savdo” MChJ | 305123456 | 64800000 | 40000000 | 24800000 | “Sharq Ulgurji” MChJ| 301111222 | 12320000 | | | 12320000
?? 0 yoki SQL da COALESCEUchta hisobot: ustunlar va filtrlar
| Hisobot | Ustunlar | Filtrlar | Rollar |
|---|---|---|---|
| Qoldiqlar | ombor, SKU, nomi, quantity, reserved, mavjud, qiymati, kam? | ombor, faqat kam qoldiq | omborchi, menejer |
| Savdo | davr, hujjatlar soni, sof savdo, QQS, jami | from, to, group (kun/hafta/oy) | menejer, buxgalter |
| Top mahsulotlar | SKU, nomi, miqdor, summa, o‘rin | from, to, limit | menejer |
| Debitorlik | mijoz, STIR, qarz, joriy, 1–30, 31+ kun | sana (asOf) | buxgalter |
Hisobot marshrutlari va ruxsatlar
Route::middleware('auth')->prefix('reports')->name('reports.') ->controller(ReportController::class)->group(function () { Route::get('stock', 'stock')->name('stock') ->middleware('can:reports.stock'); Route::get('sales', 'sales')->name('sales') ->middleware('can:reports.sales'); Route::get('receivables', 'receivables')->name('receivables') ->middleware('can:reports.receivables'); Route::get('{report}.{format}', 'export')->name('export') ->whereIn('format', ['xlsx', 'pdf']); });
GET /reports/sales?from=2026-10-01&to=2026-10-27&group=day → 200 GET /reports/receivables (omborchi) → 403 GET /reports/sales.xlsx?from=... → savdo-2026-10-01_2026-10-27.xlsx
export metodi — xlsx yoki pdf2-qadam. Excel va PDF eksport
Debitorlik varag‘i
class ReceivablesSheet implements FromCollection, WithHeadings, WithTitle, ShouldAutoSize { public function __construct(private CarbonImmutable $asOf) {} public function collection() { return app(ReportService::class)->receivables($this->asOf) ->map(fn ($r) => [$r->name, $r->inn, (float) $r->total_debt, (float) $r->not_due, (float) $r->d1_30, (float) $r->d30_plus]); } public function headings(): array { return ['Mijoz', 'STIR', 'Qarz', 'Joriy', '1–30', '30+']; } public function title(): string { return 'Debitorlik'; } }
[Debitorlik] Mijoz | STIR | Qarz | Joriy | 1–30 kun | 30+ kun “Baraka Savdo” MChJ | 305123456 | 64 800 000,00 | 40 000 000,00 | 24 800 000,00 | 0,00
columnFormats() → ['C:F' => '#,##0.00'] — Excel mintaqasiga qarab ko‘rinadiEksport sifatini tekshirish
Raqamlar mosligi
Harflar
o‘, g‘, ’ to‘g‘ri; CSV/Excel da hamFormatlar
Ruxsat
/reports/receivables.pdf ni ocha olmaydi (403)Hajm
3-qadam. Dashboard va materiallashtirilgan ko‘rinish
Diagramma ma’lumoti: bo‘sh oylarni to‘ldirish
public function monthlyChart(CarbonImmutable $to, int $n = 12): array { $from = $to->startOfMonth()->subMonths($n - 1); $sums = SalesMonthly::query() ->where('month', '>=', $from->toDateString()) ->where('month', '<=', $to->toDateString()) ->selectRaw("to_char(month, 'YYYY-MM') AS ym") ->selectRaw('SUM(total) AS total') ->groupBy('ym') ->pluck('total', 'ym'); // ['2026-10' => '1692320000.00'] $labels = $data = []; for ($m = $from; $m <= $to; $m = $m->addMonth()) { $key = $m->format('Y-m'); $labels[] = $key; $data[] = round(((float) ($sums[$key] ?? 0)) / 1e6, 1); } return ['labels' => $labels, 'data' => $data]; }
['labels' => ['2025-11', '2025-12', ..., '2026-10'], 'data' => [1104.2, 0, 1210.4, ..., 1692.3]] // dekabr — savdo yo‘q
oy => summa lug‘atiKPI kartochkalari
<div class="grid grid-cols-4 gap-4" wire:poll.60s> <x-kpi-card title="Oktabr savdosi" :value="$kpi['sales']" unit="so‘m" :delta="$kpi['sales_delta']" /> <x-kpi-card title="Debitorlik" :value="$kpi['receivable']" unit="so‘m" :href="route('reports.receivables')" /> <x-kpi-card title="Muddati o‘tgan" :value="$kpi['overdue']" unit="so‘m" /> <x-kpi-card title="Kam qoldiq" :value="$kpi['low_stock']" unit="ta" :href="route('reports.stock', ['low' => 1])" /> </div> <p class="text-sm"> Ma’lumotlar {{ $refreshedAt->format('d.m.Y H:i') }} holatiga </p>
[Oktabr savdosi: 1 692 320 000 so‘m ▲ 16,3 %] [Debitorlik: 77 120 000 so‘m] [Muddati o‘tgan: 37 120 000 so‘m] [Kam qoldiq: 6 ta mahsulot] Ma’lumotlar 27.10.2026 03:00 holatiga
number_format bilan formatlaydiLAG yoki servisda hisoblanadiNatija va topshirish
ReportService asosidagi uchta hisobot (ombor qoldiqlari, davr bo‘yicha savdo, debitorlik va uning muddati), ularning Excel va PDF eksporti, KPI kartochkalari va 12 oylik savdo diagrammasi bilan dashboard, mv_sales_monthly materiallashtirilgan ko‘rinishi.Baholash mezonlari
ReportServicedastockBalances,salesByPeriod,receivablesmetodlari; har biri bazada agregatsiya qiladi (PHP siklida yig‘ish yo‘q).- Ko‘rsatkich ta’riflari
docs/reports.mdda yozilgan; ekran, Excel va PDF dagi jami qiymatlar bir xil. - Filtrlar (
from,to,group,warehouse_id) Form Request bilan tekshiriladi; SQL ga foydalanuvchi qiymati faqat binding orqali tushadi. - Hisobotlar rollar bo‘yicha himoyalangan (
can:middleware), menyuda faqat ruxsat etilganlari ko‘rinadi. - Excel eksport ko‘p varaqli, pul ustunlari son formatida; PDF DejaVu Sans bilan, o‘zbek harflari to‘g‘ri.
- Dashboard: 4 ta KPI kartochkasi va bo‘sh oylari to‘ldirilgan 12 oylik diagramma.
mv_sales_monthlymigratsiyasi UNIQUE indeks bilan,reports:refreshbuyrug‘iCONCURRENTLYbilan ishlaydi.- Hisobot ustunlari uchun indekslar migratsiyasi va 12 oylik seed ma’lumotlari mavjud.
feature/reports Pull Request havolasini yuboring. PR tavsifida: uchta hisobot va dashboard skrinshotlari, bitta Excel va bitta PDF namunasi (fayl sifatida biriktirilgan) hamda reports:refresh ishlashini ko‘rsatuvchi terminal chiqishi bo‘lsin.4-topshiriq: Ombor qoldiqlari hisoboti
stocks qatorlari berilgan: ['warehouse' => 'TSH-1', 'sku' => ..., 'quantity' => int, 'reserved' => int, 'min_stock' => int, 'price' => int] (narx so‘mda). Har bir qator uchun mavjud qoldiq (quantity − reserved), qiymat (quantity × price) va kam qoldiq belgisi (mavjud < min_stock) ni hisoblang; qatorlarni ombor, so‘ng SKU bo‘yicha saralang. Invariant buzilgan bo‘lsa (quantity < 0, reserved < 0 yoki reserved > quantity) — DomainException.
Imzo: function qoldiq_hisobot(array $stocks): array
Qaytaradi: ['rows' => [['warehouse' => ..., 'sku' => ..., 'available' => int, 'value' => int, 'low' => bool], ...], 'total_value' => int, 'low_count' => int].
qoldiq_hisobot([['warehouse' => 'TSH-1', 'sku' => 'UN-001', 'quantity' => 35, 'reserved' => 20, 'min_stock' => 20, 'price' => 385000], ['warehouse' => 'TSH-1', 'sku' => 'SH-010', 'quantity' => 420, 'reserved' => 100, 'min_stock' => 50, 'price' => 14500]])
{"rows":[{"warehouse":"TSH-1","sku":"SH-010","available":320,"value":6090000,"low":false},{"warehouse":"TSH-1","sku":"UN-001","available":15,"value":13475000,"low":true}],"total_value":19565000,"low_count":1}5-topshiriq: Davr bo‘yicha savdo (kun / hafta / oy)
Hisob-fakturalar ['issued_at' => 'YYYY-MM-DD', 'total' => int]. $from va $to (YYYY-MM-DD, ikkalasi ham kiradi) oralig‘idagi hujjatlarni $group bo‘yicha guruhlang: day — YYYY-MM-DD, month — YYYY-MM, week — ISO hafta YYYY-Www (masalan, 2026-W44; yil sifatida ISO yil olinadi: 2027-01-01 → 2026-W53). Noma’lum $group yoki $from > $to — InvalidArgumentException. Natija — davr kaliti bo‘yicha o‘sish tartibida saralangan davr => summa lug‘ati.
Imzo: function davr_savdo(array $invoices, string $from, string $to, string $group): array
Qaytaradi: ['davr' => int, ...]; mos hujjat bo‘lmasa [].
davr_savdo([['issued_at' => '2026-10-26', 'total' => 100], ['issued_at' => '2026-10-27', 'total' => 50], ['issued_at' => '2026-11-02', 'total' => 70]], '2026-10-01', '2026-10-31', 'day')
{"2026-10-26":100,"2026-10-27":50}6-topshiriq: Debitorlik qarzining muddati (aging)
Hisob-fakturalar ['due_at' => 'YYYY-MM-DD', 'total' => int, 'paid_amount' => int] va hisobot sanasi $sana berilgan. Qarz = total − paid_amount; qarzi 0 bo‘lganlar hisobga olinmaydi. Kechikish kunlari = $sana − due_at. Guruhlar: joriy (kechikish ≤ 0), 1-30, 31-60, 61-90, 90+. paid_amount < 0 yoki paid_amount > total — DomainException; sana YYYY-MM-DD ko‘rinishidagi mavjud sana bo‘lmasa — InvalidArgumentException.
Imzo: function debitorlik_yoshi(array $invoices, string $sana): array
Qaytaradi: ['joriy' => int, '1-30' => int, '31-60' => int, '61-90' => int, '90+' => int, 'jami' => int] — barcha kalitlar har doim, shu tartibda.
debitorlik_yoshi([['due_at' => '2026-11-10', 'total' => 1000, 'paid_amount' => 0], ['due_at' => '2026-10-01', 'total' => 500, 'paid_amount' => 200], ['due_at' => '2026-07-01', 'total' => 300, 'paid_amount' => 300]], '2026-10-27')
{"joriy":1000,"1-30":300,"31-60":0,"61-90":0,"90+":0,"jami":1300}7-topshiriq: Ombor × mahsulot pivot jadvali
Qoldiqlar ['warehouse' => 'TSH-1', 'sku' => 'UN-001', 'available' => int] ro‘yxatidan Excel dagi kabi pivot jadval yasang: qatorlar — SKU (o‘sish tartibida), ustunlar — omborlar (o‘sish tartibida) va oxirida jami; yo‘q juftlik uchun 0. Pastki jami qatori har bir ombor va umumiy yig‘indini beradi. Bitta (ombor, SKU) juftligi ikki marta kelsa — DomainException (stocks da unique(warehouse_id, product_id) invarianti).
Imzo: function pivot_qoldiq(array $rows): array
Qaytaradi: ['columns' => [ombor, ...], 'rows' => [sku => [ombor => int, ..., 'jami' => int], ...], 'jami' => [ombor => int, ..., 'jami' => int]].
pivot_qoldiq([['warehouse' => 'TSH-2', 'sku' => 'UN-001', 'available' => 5], ['warehouse' => 'TSH-1', 'sku' => 'UN-001', 'available' => 15], ['warehouse' => 'TSH-1', 'sku' => 'SH-010', 'available' => 320]])
{"columns":["TSH-1","TSH-2"],"rows":{"SH-010":{"TSH-1":320,"TSH-2":0,"jami":320},"UN-001":{"TSH-1":15,"TSH-2":5,"jami":20}},"jami":{"TSH-1":335,"TSH-2":5,"jami":340}}8-topshiriq: Diagramma uchun oylik qator
SQL natijasida savdosi yo‘q oylar bo‘lmaydi, diagrammada esa ular 0 bo‘lishi kerak. $oylik — ['YYYY-MM' => int] (so‘m), $from va $to — YYYY-MM (ikkalasi ham kiradi). Shu oraliqdagi barcha oylar uchun labels, data (yo‘q oy — 0, oraliqdan tashqaridagi kalitlar e’tiborsiz) va oldingi oyga nisbatan o‘zgarish change ni qaytaring: birinchi oy uchun null, oldingi oy 0 bo‘lsa null, aks holda round((joriy − oldingi) * 100 / oldingi, 1). Format noto‘g‘ri (oy 01–12 emas) yoki $from > $to — InvalidArgumentException; oraliq 36 oydan uzun — DomainException.
Imzo: function diagramma_malumoti(array $oylik, string $from, string $to): array
Qaytaradi: ['labels' => [string, ...], 'data' => [int, ...], 'change' => [?float, ...]] — uchala ro‘yxat bir xil uzunlikda.
diagramma_malumoti(['2026-08' => 1200, '2026-10' => 1500, '2026-09' => 1500], '2026-07', '2026-10')
{"labels":["2026-07","2026-08","2026-09","2026-10"],"data":[0,1200,1500,1500],"change":[null,null,25,0]}