<?php

namespace App\Models;

use App\Core\Database;
use App\Core\Model;

class Dealer extends Model
{


    public function getCompanyDealers($company_id)
    {
        $query = "SELECT sd.id, sd.code, sd.name 
        FROM source_dealer sd 
        LEFT OUTER JOIN source_company_dealer scd 
        ON sd.id=scd.dealer_id 
        WHERE 1
        AND scd.company_id =  ?
        AND sd.status = 1 and scd.status = 1 GROUP BY sd.id ORDER BY sd.code ASC";
        $queryType = "i";
        $queryValue = array(
            $company_id,
        );
        return Database::connect()->runQuery($query, $queryType, $queryValue);
    }
}