<?php
    include_once("../../cfg/db.php");
    $id = $db->escape(trim($_POST['brand_id']));

    $type = $_POST['is_clicked'];

    $new_brand_name = $db->escape(trim(strtoupper($_POST['new_brand_name'])));
    $image_name = $db->escape(trim(strtolower($_POST['image_name'])));

    if(intval($db -> select("SELECT count(1) FROM source_brand WHERE `name` != '' AND `name` = '$new_brand_name' AND id != '$id'")) > 0){
        $arr['status'] = 0; //duplicate brand name
    } else {
        $update_query = "";

        if($type == 0){
            $update_query = "UPDATE `source_brand` SET `name`='$new_brand_name' WHERE `id` = '$id'";
        } else {
            $update_query = "UPDATE `source_brand` SET `name`='$new_brand_name', `logo` = '$image_name' WHERE `id` = '$id'";
        }
        
        //echo $update_query; return;
        $db->sql_query($update_query);

        $arr['status'] = 1; //success update
        $arr['brand_id'] = $id;
    }

    echo json_encode($arr);
?>