CRUD ekranlari: filtr, sahifalash, validatsiya
Amaliy mashg‘ulot oxirida siz quyidagilarni bajara olasiz...
ProductTable komponentini: qidiruv, kategoriya filtri, saralash va sahifalash bilanOrderForm hujjat formasini dinamik qatorlar bilan@can, Policy) va saqlashni servis qatlamiga (OrderService)Livewire::test() bilan va UX nazorat ro‘yxati bo‘yichaQanday bajariladi va qanday baholanadi?
Ish tartibi
- Saytga login va parolingiz bilan kiring: emro.uz/korxona/kirish.html
- 6-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.
Mahsulotlar katalogi: ProductTable
O‘rnatish va komponent yaratish
composer require livewire/livewire php artisan livewire:layout # components/layouts/app.blade.php php artisan make:livewire ProductTable php artisan make:livewire OrderForm php artisan make:request StoreProductRequest php artisan lang:publish # lang/ papkasi (keyin lang/uz)
app/Livewire/ProductTable.php resources/views/livewire/product-table.blade.php app/Livewire/OrderForm.php resources/views/livewire/order-form.blade.php app/Http/Requests/StoreProductRequest.php
lang/en ni chiqaradi; lang/uz/validation.php ni tarjima qilib qo‘shingKomponentlarni marshrutga ulash
use App\Livewire\{OrderForm, ProductTable}; Route::middleware('auth')->group(function () { Route::get('/products', ProductTable::class) ->middleware('can:products.view')->name('products.index'); Route::get('/orders/create', OrderForm::class) ->middleware('can:orders.create')->name('orders.create'); Route::resource('orders', OrderController::class) ->only(['index', 'show']); });
GET /products → ProductTable (products.view)
GET /orders/create → OrderForm (orders.create)
GET /orders, /orders/{order} → OrderController/orders/create — orders/{order} dan oldinscopeSearch va xavfsiz sortBy
// app/Models/Product.php public function scopeSearch(Builder $q, string $term): Builder { $term = trim($term); return $term === '' ? $q : $q->where(fn ($w) => $w ->where('name', 'ilike', "%{$term}%") ->orWhere('sku', 'ilike', "%{$term}%")); } // app/Livewire/ProductTable.php public function sortBy(string $col): void { abort_unless(in_array($col, ['sku', 'name', 'price'], true), 400); $this->dir = $this->sort === $col && $this->dir === 'asc' ? 'desc' : 'asc'; $this->sort = $col; $this->resetPage(); }
“Narx” bosildi: sort=price, dir=asc
“Narx” yana bosildi: sort=price, dir=desc
sortBy('password') → 400 Bad RequestProduct::search($s) yoki ->search($s) ko‘rinishida chaqiriladiHujjatlar interfeysi: buyurtmalar ro‘yxati va OrderForm
Filtrlar, ustunlar va so‘rov
| Element | Qiymat / qoida | Laravel |
|---|---|---|
| Holat filtri | draft … shipped, cancelled | Rule::enum(OrderStatus::class), where('status', ...) |
| Sana oralig‘i | from, to (Y-m-d) | whereDate('created_at', '>=', $from) |
| Raqam qidiruvi | BY-2026-000123 | where('number', 'ilike', "%$s%") |
| Summa ustuni | o‘ngga, so‘m, ming ajratgich | number_format(..., 0, '.', ' ') |
| Holat belgisi | rang + matn | $order->status->label(), color() |
| Eager loading | mijoz va ombor nomi | with(['counterparty:id,name', 'warehouse:id,code']) |
created_at desc, keyin id desc; sahifalash — paginate(25)->withQueryString().Dinamik qatorlar va xatolar
<form wire:submit="save"> <select wire:model="counterpartyId" class="form-select"> <option value="">— mijozni tanlang —</option> @foreach ($customers as $c) <option value="{{ $c->id }}">{{ $c->name }}</option> @endforeach </select> @foreach ($lines as $i => $line) <div class="row g-2" wire:key="line-{{ $i }}"> <select wire:model="lines.{{ $i }}.product_id">…</select> <input type="number" wire:model.blur="lines.{{ $i }}.quantity"> @error("lines.$i.quantity")<em>{{ $message }}</em>@enderror <button wire:click.prevent="removeLine({{ $i }})">✕</button> </div> @endforeach <button type="button" wire:click="addLine">+ Qator</button> <button type="submit" wire:loading.attr="disabled">Saqlash</button> </form>
Mijoz: “Baraka Savdo” MChJ 1) UN-001 × 10 2) GR-007 × 0 → “The lines.1.quantity field must be at least 1.” [+ Qator] [Saqlash] (so‘rov paytida o‘chiq)
save() metodiuidQator qo‘shish, o‘chirish va ma’lumotnomalar
public function addLine(): void { $this->lines[] = ['product_id' => null, 'quantity' => 1]; } public function removeLine(int $i): void { unset($this->lines[$i]); $this->lines = array_values($this->lines); } public function render() { return view('livewire.order-form', [ 'customers' => Counterparty::query() ->whereIn('type', ['customer', 'both']) ->orderBy('name')->get(['id', 'name', 'inn']), ]); }
addLine() → lines: 2 ta qator removeLine(0) → lines: [0 => ...] (indekslar qayta tartiblandi)
lines.0, lines.1 xatolari to‘g‘ri bog‘lanadiRuxsatlar, UX va tekshirish
Holat va ruxsatga bog‘liq tugmalar
<x-status-badge :status="$order->status" /> @can('confirm', $order) <form method="POST" action="{{ route('orders.confirm', $order) }}"> @csrf <button class="btn btn-sm btn-success">Tasdiqlash</button> </form> @endcan @can('cancel', $order) <form method="POST" action="{{ route('orders.cancel', $order) }}" onsubmit="return confirm('Buyurtma bekor qilinsinmi?')"> @csrf <button class="btn btn-sm btn-danger">Bekor qilish</button> </form> @endcan
Menejer, holat = draft → [Tasdiqlash] [Bekor qilish] Menejer, holat = shipped → tugmalar yo‘q Omborchi → tugmalar yo‘q (ruxsat yo‘q)
OrderStatus::label() va color() dan foydalanadiwire:confirmcan: yoki authorize() bilan himoyalanganQidiruv filtrini avtomatik tekshirish
use App\Livewire\ProductTable; use App\Models\{Product, User}; use Livewire\Livewire; it('qidiruv bo‘yicha filtrlaydi', function () { $user = User::factory()->create()->assignRole('omborchi'); Product::factory()->create(['sku' => 'UN-001', 'name' => 'Un']); Product::factory()->create(['sku' => 'GR-007', 'name' => 'Guruch']); Livewire::actingAs($user) ->test(ProductTable::class) ->set('search', 'UN-0') ->assertSee('UN-001') ->assertDontSee('GR-007'); });
PASS Tests\Feature\ProductTableTest ✓ qidiruv bo‘yicha filtrlaydi 0.21s Tests: 1 passed (2 assertions)
wire:model ga tengEkran sifatini tekshiring
✗ Yomon ekran
- Filtr natijasiz — bo‘sh oq maydon
- Filtr o‘zgardi, 7-sahifada qolib ketdi
- Narx
1250000.00ko‘rinishida, chapga tekislangan - “Saqlash” ni ikki marta bosish — ikki buyurtma
- Xato: “The given data was invalid.”
✓ Yaxshi ekran
- “Hech narsa topilmadi — filtrni tozalang”
- Filtr o‘zgarganda
resetPage()— 1-sahifa 1 250 000 so‘m, o‘ngga tekislanganwire:loading.attr="disabled"— bitta so‘rov- Maydon ostida o‘zbekcha aniq xabar
Natija va topshirish
Baholash mezonlari
ProductTable: qidiruv (debounce), kategoriya filtri, 3 ustun bo‘yicha saralash, 20 tadan sahifalash; filtrlar URL da (#[Url]) va filtr o‘zgarganda 1-sahifa- Saralash ustunlari oq ro‘yxat bilan tekshiriladi;
?sort=password500 xato bermaydi - Ro‘yxatlarda N+1 yo‘q (
with(...)), bo‘sh holat va yuklanish holati bor - Mahsulot formasi:
StoreProductRequest,old(),@error, tahrirdaRule::unique(...)->ignore(), saqlashdan keyin flash xabar OrderForm: dinamik qatorlar,lines.*qoidalari, saqlashOrderServiceorqali, servis xatolari formada ko‘rinadi- Tugmalar
@can/ Policy bilan yashiriladi va marshrutlar serverda ham himoyalangan - Xato xabarlari o‘zbek tilida (
lang/uz/validation.php), pulso‘mformatida, sanad.m.Y - Kamida 2 ta
Livewire::test()testi o‘tadi
a06-crud-ui tegi yoki Pull Request havolasi. README da ikkala modulning ekran rasmlari, rollar bo‘yicha tugmalar jadvali va testlarni ishga tushirish buyrug‘i bo‘lsin.4-topshiriq: Filtrlarni saqlovchi query string
Ro‘yxat ekranida filtr, saralash va sahifa URL da saqlanadi. Joriy parametrlar $current ga $changes qo‘llanadi ($changes ustun). Qiymati null yoki '' bo‘lgan kalitlar olib tashlanadi; page = 1 ham yozilmaydi (standart). Agar $changes da page dan boshqa kalit bo‘lsa va page ning o‘zi berilmagan bo‘lsa — page olib tashlanadi (filtr o‘zgardi → 1-sahifa). Kalitlar alifbo tartibida saralanib, http_build_query bilan satrga aylantiriladi.
Imzo: function qs_build(array $current, array $changes): string
Qaytaradi: Satr, masalan 'page=4&search=un'; parametr qolmasa — ''.
qs_build(['search' => 'un', 'page' => 3], ['page' => 4])
"page=4&search=un"
5-topshiriq: Filtrdan xavfsiz WHERE
Filtrlar paneli qiymatlaridan parametrli SQL sharti yasang. Ruxsat etilgan kalitlar va ularning tartibi: search → (name ILIKE ? OR sku ILIKE ?) (ikki marta %matn%, matndagi % va _ oldiga \ qo‘yiladi), category_id → category_id = ? (musbat butun son yoki raqamli satr, int ga aylantiriladi), is_active → is_active = ? (true/false/'1'/'0', bool ga), price_min → price >= ?, price_max → price <= ? (0 yoki musbat butun son yoki raqamli satr). Qiymati null yoki bo‘sh joydan iborat bo‘lgan filtrlar e’tiborsiz. Noma’lum kalit, noto‘g‘ri qiymat yoki price_min > price_max — InvalidArgumentException.
Imzo: function filtr_where(array $f): array
Qaytaradi: ['sql' => 'WHERE ... AND ...', 'bindings' => [...]]; shart bo‘lmasa ['sql' => '', 'bindings' => []]. Shartlar yuqoridagi kalitlar tartibida.
filtr_where(['search' => 'un', 'category_id' => 3])
{"sql":"WHERE (name ILIKE ? OR sku ILIKE ?) AND category_id = ?","bindings":["%un%","%un%",3]}6-topshiriq: Mahsulot formasini validatsiya qilish
Mahsulot formasidan kelgan $d massivini tekshiring va xatolar xaritasini qaytaring (har maydon uchun birinchi xato). sku: majburiy → SKU majburiy; /^[A-Z]{2}-\d{3}$/ ga mos emas → SKU formati: AA-000; $bandSku ichida bo‘lsa → Bu SKU band. name: majburiy → Nom majburiy; uzunligi (belgilarda, UTF-8) 2–100 emas → Nom 2–100 belgi. unit: majburiy → Birlik majburiy; dona, kg, litr, quti dan biri emas → Noma’lum birlik. price: majburiy → Narx majburiy; int yoki /^\d+(\.\d{1,2})?$/ satr emas (float ham qabul qilinmaydi) → Narx formati noto‘g‘ri; 0 dan katta emas → Narx 0 dan katta bo‘lsin. min_stock ixtiyoriy; berilsa — 0 yoki musbat int yoki raqamli satr, aks holda Minimal qoldiq noto‘g‘ri. Majburiy: kalit yo‘q, null yoki bo‘sh joydan iborat satr.
Imzo: function mahsulot_validate(array $d, array $bandSku = []): array
Qaytaradi: Xatolar: ['sku' => '...', 'name' => '...', 'unit' => '...', 'price' => '...', 'min_stock' => '...'] — faqat xatoli maydonlar, aynan shu tartibda; xato yo‘q — [].
mahsulot_validate(['sku' => 'UN-001', 'name' => 'Un oliy nav', 'unit' => 'kg', 'price' => '385000.00'])
[]
7-topshiriq: Dashboard ko‘rsatkichlari
Buyurtmalar ro‘yxati berilgan: har biri ['status' => ..., 'total' => int, 'date' => 'Y-m-d']. Bugungi sana $today (Y-m-d). Savdo deb faqat invoiced va shipped holatidagi buyurtmalar summasi hisoblanadi. Qaytaring: sales_today — bugungi savdo; orders_today — bugungi cancelled bo‘lmagan buyurtmalar soni; by_status — barcha buyurtmalar bo‘yicha 6 ta holat soni (draft, confirmed, reserved, invoiced, shipped, cancelled tartibida, 0 lari bilan); series — today − 6 dan today gacha 7 kunlik savdo ('Y-m-d' => summa, o‘sish tartibida). Noma’lum holat — DomainException; $today haqiqiy Y-m-d sana bo‘lmasa (masalan 2026-02-30) — InvalidArgumentException.
Imzo: function dashboard_kpi(array $orders, string $today): array
Qaytaradi: ['sales_today' => int, 'orders_today' => int, 'by_status' => [6 ta holat => int], 'series' => [7 ta sana => int]].
dashboard_kpi([['status' => 'shipped', 'total' => 500000, 'date' => '2026-11-10'], ['status' => 'draft', 'total' => 90000, 'date' => '2026-11-10'], ['status' => 'invoiced', 'total' => 250000, 'date' => '2026-11-08']], '2026-11-10')
{"sales_today":500000,"orders_today":2,"by_status":{"draft":1,"confirmed":0,"reserved":0,"invoiced":1,"shipped":1,"cancelled":0},"series":{"2026-11-04":0,"2026-11-05":0,"2026-11-06":0,"2026-11-07":0,"2026-11-08":250000,"2026-11-09":0,"2026-11-10":500000}}8-topshiriq: Ma’lumotlar jadvali: filtr + saralash + sahifa
Xotiradagi jadval qatorlari [sku, nom, narx, qoldiq] ko‘rinishida. So‘rov $q ixtiyoriy kalitlari: search (sku yoki nomda katta-kichik harfsiz qidiruv, trim), sort (sku, name, price, qty, boshida - bo‘lsa kamayish; standart sku), page (standart 1), per_page (standart 10, 1..50). Teng qiymatlar har doim sku bo‘yicha o‘sish tartibida joylashadi. Ruxsat etilmagan sort, page < 1 yoki per_page oraliqdan tashqarida — InvalidArgumentException. Sahifa oxirgisidan katta bo‘lsa — data bo‘sh.
Imzo: function grid(array $rows, array $q): array
Qaytaradi: ['data' => [sahifadagi sku lar], 'meta' => ['total' => int, 'current_page' => int, 'last_page' => int]]; last_page kamida 1.
grid([['UN-001', 'Un', 385, 40], ['GR-007', 'Guruch', 41, 0], ['SH-010', 'Shakar', 41, 12], ['YG-002', 'Yog', 120, 5], ['UN-002', 'Un 1-nav', 300, 8]], ['sort' => '-price', 'per_page' => 2])
{"data":["UN-001","UN-002"],"meta":{"total":5,"current_page":1,"last_page":3}}