Загрузка данных


<?php

namespace App\Http\Controllers;

use App\Models\RepairOrder;
use App\Models\User;
use App\Models\Car;
use App\Models\Service;
use App\Models\Part;
use Illuminate\Http\Request;

class RepairOrderController extends Controller
{
    // Показать список всех заказ-нарядов
    public function index()
    {
        $orders = RepairOrder::with(['user', 'car', 'admin'])->get();
        return view('repair_orders.index', compact('orders'));
    }

    // Показать форму создания нового заказ-наряда
    public function create()
    {
        $clients = User::where('role_id', 1)->get(); // Клиенты (role_id = 1)
        $admins = User::where('role_id', 2)->get();  // Администраторы (role_id = 2)
        $cars = Car::all();
        $services = Service::all();
        $parts = Part::all();

        return view('repair_orders.create', compact('clients', 'admins', 'cars', 'services', 'parts'));
    }

    // Сохранить новый заказ-наряд в БД
    public function store(Request $request)
    {
        $validated = $request->validate([
            'user_id' => 'required|exists:users,id',
            'car_id' => 'required|exists:cars,id',
            'admin_id' => 'nullable|exists:users,id',
            'status' => 'required|in:pending,in_progress,completed,cancelled',
            'order_date' => 'required|date',
            'completion_date' => 'nullable|date',
            'problem_description' => 'nullable|string',
            'admin_notes' => 'nullable|string',
            'services' => 'nullable|array',
            'parts' => 'nullable|array',
        ]);

        $orderNumber = 'ORD-' . strtoupper(uniqid());

        $order = RepairOrder::create([
            'order_number' => $orderNumber,
            'user_id' => $validated['user_id'],
            'car_id' => $validated['car_id'],
            'admin_id' => $validated['admin_id'] ?? null,
            'status' => $validated['status'],
            'order_date' => $validated['order_date'],
            'completion_date' => $validated['completion_date'] ?? null,
            'problem_description' => $validated['problem_description'] ?? null,
            'admin_notes' => $validated['admin_notes'] ?? null,
            'total_labor_cost' => 0,
            'total_parts_cost' => 0,
            'total_amount' => 0,
        ]);

        $laborCost = 0;
        if (!empty($validated['services'])) {
            foreach ($validated['services'] as $serviceId => $quantity) {
                if ($quantity > 0) {
                    $service = Service::find($serviceId);
                    $order->services()->attach($serviceId, [
                        'quantity' => $quantity,
                        'price_at_time' => $service->price,
                    ]);
                    $laborCost += $quantity * $service->price;
                }
            }
        }

        $partsCost = 0;
        if (!empty($validated['parts'])) {
            foreach ($validated['parts'] as $partId => $quantity) {
                if ($quantity > 0) {
                    $part = Part::find($partId);
                    $order->parts()->attach($partId, [
                        'quantity' => $quantity,
                        'price_at_time' => $part->price,
                    ]);
                    $partsCost += $quantity * $part->price;
                }
            }
        }

        $order->update([
            'total_labor_cost' => $laborCost,
            'total_parts_cost' => $partsCost,
            'total_amount' => $laborCost + $partsCost,
        ]);

        return redirect()->route('repair_orders.index')->with('success', 'Заказ-наряд успешно создан!');
    }

    // Показать конкретный заказ-наряд
    public function show($id)
    {
        $order = RepairOrder::with(['user', 'car', 'admin', 'services', 'parts'])->findOrFail($id);
        return view('repair_orders.show', compact('order'));
    }

    // Показать форму редактирования
    public function edit($id)
    {
        $order = RepairOrder::findOrFail($id);
        $clients = User::where('role_id', 1)->get();
        $admins = User::where('role_id', 2)->get();
        $cars = Car::all();

        return view('repair_orders.edit', compact('order', 'clients', 'admins', 'cars'));
    }

    // Обновить заказ-наряд в БД
    public function update(Request $request, $id)
    {
        $order = RepairOrder::findOrFail($id);

        $validated = $request->validate([
            'user_id' => 'required|exists:users,id',
            'car_id' => 'required|exists:cars,id',
            'admin_id' => 'nullable|exists:users,id',
            'status' => 'required|in:pending,in_progress,completed,cancelled',
            'order_date' => 'required|date',
            'completion_date' => 'nullable|date',
            'problem_description' => 'nullable|string',
            'admin_notes' => 'nullable|string',
        ]);

        $order->update($validated);

        return redirect()->route('repair_orders.index')->with('success', 'Заказ-наряд обновлён!');
    }

    // Удалить заказ-наряд
    public function destroy($id)
    {
        $order = RepairOrder::findOrFail($id);
        $order->services()->detach();
        $order->parts()->detach();
        $order->delete();

        return redirect()->route('repair_orders.index')->with('success', 'Заказ-наряд удалён!');
    }
}