<?php

namespace App\Models;

use CodeIgniter\Model;

class MotorMasterProductModel extends Model
{
    protected $table            = 'motor_master_product';
    protected $primaryKey       = 'product_code';
    protected $returnType       = 'array';
    protected $useAutoIncrement = false;
    protected $protectFields    = true;
    protected $allowedFields    = ['product_code', 'product_name', 'vehicle_class', 'is_active', 'imported_at'];
    protected $useTimestamps    = false;

    public function activeList(?string $vehicleClass = null): array
    {
        $builder = $this->where('is_active', 1);
        if ($vehicleClass) {
            $builder->where('vehicle_class', $vehicleClass);
        }
        return $builder->orderBy('product_code')->findAll();
    }
}