<?php
class UnitAssociation{ 
    function read_unit_association_content($search,$db){ 
             $unit_associations = $db -> return_result("SELECT id,name FROM `source_unit_association` WHERE status=1 AND `name` LIKE '%$search%' ORDER BY name ASC LIMIT 10");
                    $json = [];
                    foreach($unit_associations as $unit_association){
                         $json[] = ['id'=>$unit_association['name'], 'text'=>$unit_association['name']];
                    }
                    echo json_encode($json); 
    } 
 
    
     function read_unit_association_id_by_name($name,$db){   
        return $db -> select("SELECT id FROM `source_unit_association` WHERE status=1 AND `name` = '$name' ");  
    } 

    function create_unit_association($name,$db){
                    return $db -> sql_query_id("INSERT INTO source_unit_association (name,date_added,status) VALUES ('$name',NOW(),'1')");  
    }

} 
?>