Laravel:按月分期付款

CREATE TABLE installments (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    amount DECIMAL(10, 2) NOT NULL,
    due_date DATE NOT NULL,
    status ENUM('pending', 'paid', 'cancelled') NOT NULL DEFAULT 'pending',
    FOREIGN KEY (user_id) REFERENCES users(id)
);

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Installment extends Model
{
    protected $fillable = ['user_id', 'amount', 'due_date', 'status'];
}

namespace App\Http\Controllers;

use App\Models\Installment;
use Illuminate\Http\Request;

class InstallmentController extends Controller
{
    public function create(Request $request)
    {
        // 验证请求数据
        $request->validate([
            'user_id' => 'required|integer',
            'amount' => 'required|numeric',
            'due_date' => 'required|date',
        ]);

        // 创建分期付款记录
        $installment = Installment::create($request->all());

        return response()->json($installment);
    }

    public function list(Request $request)
    {
        // 获取用户的分期付款记录
        $installments = Installment::where('user_id', $request->user_id)->get();

        return response()->json($installments);
    }
}

use App\Http\Controllers\InstallmentController;

Route::post('/installments', [InstallmentController::class, 'create']);
Route::get('/installments', [InstallmentController::class, 'list']);