<?php 
namespace App\Models;
use CodeIgniter\Model;
class VendorModel extends Model
{
    protected $table = 'vendor';
    protected $primaryKey = 'vendor_id';
    protected $allowedFields = ['vendor_id','branch_id','vendor_name','vendor_email','manufacturer_id','contact_person_name1','contact_person_name2','contact_person_name3','contact_person_mobile1','contact_person_mobile2','contact_person_mobile3','contact_person_designation1','contact_person_designation2','contact_person_designation3','gstnumber','conatct_person','vendortype','make','model','category','address','state','postal_code','city','country','description','isactive'];
   
    public function get_vendors_by_model($model_ids)
    {
        // Encode the model IDs array as JSON
        $json_model_ids = json_encode($model_ids);
    
        // Query the database to retrieve vendors based on the model IDs
        $query = $this->query("SELECT * FROM vendor WHERE JSON_CONTAINS(model, '{$json_model_ids}')")->getResult();
    
        // Check if any vendors are found
        if (!empty($query)) {
            return $query; // Return the result as an array of vendors
        } else {
            return array(); // Return an empty array if no vendors are found
        }
    }
    
    
    
}