<?php
    class SalesConsultant { 
        function read_sales_consultant_id_by_name($name, $db){  
            return $db -> select("SELECT id FROM `source_sales_consultant` WHERE status = 1 AND `name` = '$name' AND `type` = 0");  
        } 

        function read_sales_consultant_name_by_id($id, $db){  
            return $db -> select("SELECT name FROM `source_sales_consultant` WHERE status = 1 AND `id` = '$id' AND type = 0");  
        }

        function create_sales_consultant($name, $db){ 
            return $db -> sql_query_id("INSERT INTO source_sales_consultant (`name`, `status`, `type`) VALUES ('$name', 1, 0)");  
        }
    } 
?>