<?php
    include_once("../../cfg/db.php");
    include_once('../../api/controllers/brand.php');

    $brand = new Brand();

    $new_model_name = $db->escape(trim(strtoupper($_POST['new_model_name'])));
    $new_models_brand = $db->escape(trim($_POST['new_models_brand']));
    //$new_model_description = $db->escape(trim(strtoupper($_POST['new_model_description'])));

    //echo "hi " .$models_brand; return;

    $current_user = $_SESSION['user']['id'];
    $brand_name = $brand->read_brand_name_by_id($new_models_brand, $db);

    if(intval($db -> select("SELECT count(1) FROM source_car_model WHERE name = '$new_model_name' AND brand_id = '$new_models_brand'")) > 0){
        $return_arr['status'] = 0; //duplicate model name
        $return_arr['message'] = "Model name already existing under " . $brand_name;
        echo json_encode($return_arr);
    }
    // else if(intval($db -> select("SELECT count(1) FROM source_car_model WHERE model_variant_description != '', model_variant_description = '$new_model_description' AND brand_id = '$new_models_brand'")) > 0){
    //     $return_arr['status'] = 0; //duplicate model description name
    //     $return_arr['message'] = "Model description already existing under " . $brand_name;
    //     echo json_encode($return_arr);
    // }
    else {
        $db->sql_query("
            INSERT INTO `source_car_model` (`brand_id`, `name`, `added_by`, `status`) 
            VALUES ('$new_models_brand', '$new_model_name', '$current_user', 1)");

        $return_arr['status'] = 1;
        echo json_encode($return_arr);
    }
?>