30 lines
1.2 KiB
PHP
Executable File
30 lines
1.2 KiB
PHP
Executable File
<?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
|
|
}
|
|
}
|
|
|
|
|
|
|
|
}
|
|
|