<?php
require_once ROOT . FOLDER_CORE . '/auth.php';
require_once ROOT . '/assets/conn/SQLConnex.php';

if($auth == 1) {
    $data['status'] = true;
    $data['message'] = 'Success';
    $c = new SQLConnex();
    $sql = 'SELECT DISTINCT(MAKNatCode), MAKName, MAKRecStatus
    FROM MAKE
    WHERE MAKRecStatus = ?
    ORDER BY MAKName ASC';
    $stmt = sqlsrv_prepare($c->con, $sql, [0]);
    if(sqlsrv_execute($stmt)) {
        $i = 0;
        while($row = sqlsrv_fetch_array($stmt)) {
            $data['car_brands'][$i]['make'] = $row['MAKNatCode'];
            $data['car_brands'][$i]['name'] = $row['MAKName'];
            $i++;
        }
    }
    sqlsrv_close($c->con);
} else {
    $data['code'] = 'unauthorized_client';
    $data['message'] = 'Invalid authorization token';  
}

header("Content-type: application/json; charset=utf-8");
echo json_encode($data);

?>