function get_top_nav_records_count($urlParamMap, $default_params, $table)
{
$where_filters = array();
foreach ($urlParamMap as $param => $value) {
if (_getRequestParamValue($param) != null) {
$where_filters[] = _widget_build_sql_condition(' a1.' . $value, _getRequestParamValue($param));
}
}
foreach ($default_params as $param => $value) {
$where_filters[] = _widget_build_sql_condition(' a1.' . $param, $value);
}
if (count($where_filters) > 0) {
$where_filter = ' where ' . implode(' and ', $where_filters);
}
$sql = 'select count(*) count
from ' . $table . ' a1
' . $where_filter;
$data = _checkbook_project_execute_sql($sql);
return $data[0]['count'];
}
static function getCurrentSubMWBEApplicableFilters($domain)
{
switch ($domain) {
case "spending":
$table = "aggregateon_subven_spending_coa_entities";
$urlParamMap = array("year" => "year_id", "yeartype" => "type_of_year", "agency" => "agency_id", "subvendor" => "vendor_id", "vendor" => "prime_vendor_id", "category" => "spending_category_id");
$where_filters = array();
foreach ($urlParamMap as $param => $value) {
if (_getRequestParamValue($param) != null) {
$where_filters[] = _widget_build_sql_condition(' a1.' . $value, _getRequestParamValue($param));
}
}
if (count($where_filters) > 0) {
$where_filter = ' where ' . implode(' and ', $where_filters);
}
$sql = 'select a1.minority_type_id
from ' . $table . ' a1
' . $where_filter . '
group by a1.minority_type_id ';
$data = _checkbook_project_execute_sql($sql);
break;
case "contracts":
$table = "aggregateon_subven_contracts_cumulative_spending";
$urlParamMap = array("year" => "fiscal_year_id", "agency" => "agency_id", "yeartype" => "type_of_year", "awdmethod" => "award_method_id", "vendor" => "prime_vendor_id", "subvendor" => "vendor_id", "status" => "status_flag", "csize" => "award_size_id", "cindustry" => "industry_type_id");
$where_filters = array();
foreach ($urlParamMap as $param => $value) {
if (_getRequestParamValue($param) != null) {
$where_filters[] = _widget_build_sql_condition(' a1.' . $value, _getRequestParamValue($param));
}
}
if (count($where_filters) > 0) {
$where_filter = ' where ' . implode(' and ', $where_filters);
}
//$where_filter .= ' and rd.document_code in (' . ContractUtil::getCurrentPageDocumentIds() . ') ';
$sql = 'select a1.minority_type_id
from {' . $table . '} a1
join {ref_document_code} rd on a1.document_code_id = rd.document_code_id
' . $where_filter . '
group by a1.minority_type_id';
$data = _checkbook_project_execute_sql($sql);
break;
}
$applicable_minority_types = array();
foreach ($data as $row) {
$applicable_minority_types[] = $row['minority_type_id'];
}
return $applicable_minority_types;
}
