배포관리 기능을 갖춘 전사적자원관리(ERP) 시스템 구축을 위한 PHP 개발

CREATE TABLE distributor_table (
  id INT(11) AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255),
  level VARCHAR(50)
);

CREATE TABLE product_table (
  id INT(11) AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255),
  price DECIMAL(10, 2),
  category_id INT(11)
);

CREATE TABLE order_table (
  id INT(11) AUTO_INCREMENT PRIMARY KEY,
  distributor_id INT(11),
  product_id INT(11),
  status VARCHAR(50)
);

CREATE TABLE stock_table (
  product_id INT(11) PRIMARY KEY,
  quantity INT(11)
);

<?php

namespace AppHttpControllers;

use AppDistributor;
use IlluminateHttpRequest;

class DistributorController extends Controller
{
  public function index()
  {
    $distributors = Distributor::all();
    return view('distributors.index', compact('distributors'));
  }

  // 添加分销商
  public function create()
  {
    return view('distributors.create');
  }

  public function store(Request $request)
  {
    Distributor::create($request->all());
    return redirect()->route('distributors.index');
  }

  // 编辑分销商
  public function edit(Distributor $distributor)
  {
    return view('distributors.edit', compact('distributor'));
  }

  public function update(Request $request, Distributor $distributor)
  {
    $distributor->update($request->all());
    return redirect()->route('distributors.index');
  }

  // 删除分销商
  public function destroy(Distributor $distributor)
  {
    $distributor->delete();
    return redirect()->route('distributors.index');
  }
}

<?php

namespace AppHttpControllers;

use AppProduct;
use IlluminateHttpRequest;

class ProductController extends Controller
{
  public function index()
  {
    $products = Product::all();
    return view('products.index', compact('products'));
  }

  // 添加产品
  public function create()
  {
    return view('products.create');
  }

  public function store(Request $request) 
  {
    Product::create($request->all());
    return redirect()->route('products.index');
  }

  // 编辑产品
  public function edit(Product $product)
  {
    return view('products.edit', compact('product'));
  }

  public function update(Request $request, Product $product) 
  {
    $product->update($request->all());
    return redirect()->route('products.index');
  }

  // 删除产品
  public function destroy(Product $product)
  {
    $product->delete();
    return redirect()->route('products.index');
  }
}

<?php

namespace AppHttpControllers;

use AppOrder;
use IlluminateHttpRequest;

class OrderController extends Controller
{
  public function index()
  {
    $orders = Order::all();
    return view('orders.index', compact('orders'));
  }

  // 添加订单
  public function create()
  {
    return view('orders.create');
  }

  public function store(Request $request) 
  {
    Order::create($request->all());
    return redirect()->route('orders.index');
  }

  // 编辑订单
  public function edit(Order $order)
  {
    return view('orders.edit', compact('order'));
  }

  public function update(Request $request, Order $order) 
  {
    $order->update($request->all());
    return redirect()->route('orders.index');
  }

  // 删除订单
  public function destroy(Order $order)
  {
    $order->delete();
    return redirect()->route('orders.index');
  }
}