static function getPrimeVendorEthinictyTitle($vendor_id, $domain, $is_prime_or_sub = "P")
{
switch ($domain) {
case "spending":
$ethnicity_id = SpendingUtil::getLatestMwbeCategoryByVendor($vendor_id, null, null, null, $is_prime_or_sub);
if ($ethnicity_id > 0) {
$title = " <br/><span class=\"second-line\">M/WBE Category: " . MappingUtil::getMinorityCategoryById($ethnicity_id) . "</span>";
}
break;
case "contracts":
$ethnicity_id = ContractUtil::getLatestMwbeCategoryByVendor($vendor_id, null, null, null, $is_prime_or_sub);
if (!$ethnicity_id) {
$query = "SELECT year_id, minority_type_id\n FROM contract_vendor_latest_mwbe_category\n WHERE vendor_id = " . $vendor_id . " AND is_prime_or_sub = '" . $is_prime_or_sub . "'" . " ORDER BY year_id DESC " . " LIMIT 1 ";
$results = _checkbook_project_execute_sql_by_data_source($query, 'checkbook');
if ($results) {
$ethnicity_id = $results[0]['minority_type_id'];
}
}
if ($ethnicity_id != 7 && $ethnicity_id != 11) {
$title = " <br/><span class=\"second-line\">M/WBE Category: " . MappingUtil::getMinorityCategoryById($ethnicity_id) . "</span>";
}
break;
}
return $title;
}
