static function getTotalMWBELink()
{
if (preg_match('/contract/', $_GET['q'])) {
$domain = "contracts";
} else {
$domain = "spending";
}
switch ($domain) {
case "spending":
$table = "aggregateon_mwbe_spending_coa_entities";
$table_subven = "aggregateon_subven_spending_coa_entities";
$urlParamMap = array("year" => "year_id", "yeartype" => "type_of_year", "agency" => "agency_id", "vendor" => "vendor_id");
$urlParamMapSubven = array("year" => "year_id", "yeartype" => "type_of_year", "agency" => "agency_id", "vendor" => "prime_vendor_id");
$default_params = array("minority_type_id" => "2~3~4~5~9");
break;
case "contracts":
$table = "aggregateon_mwbe_contracts_cumulative_spending";
$table_subven = "aggregateon_subven_contracts_cumulative_spending";
$urlParamMap = array("year" => "fiscal_year_id", "agency" => "agency_id", "yeartype" => "type_of_year", "vendor" => "vendor_id");
$urlParamMapSubven = array("year" => "fiscal_year_id", "agency" => "agency_id", "yeartype" => "type_of_year", "vendor" => "prime_vendor_id");
$default_params = array("status_flag" => "A", "minority_type_id" => "2~3~4~5~9");
break;
}
if (self::get_top_nav_records_count($urlParamMap, $default_params, $table) > 0) {
$dashboard = "mp";
} elseif (self::get_top_nav_records_count($urlParamMapSubven, $default_params, $table_subven) > 0) {
// tm_wbe is an exception case for total MWBE link. When prime data is not present but sub data is present for the agency vendor combination.
$dashboard = "ms/tm_wbe/Y";
} else {
return "";
}
return '/' . RequestUtil::getLandingPageUrl($domain, _getRequestParamValue("year"), _getRequestParamValue("yeartype")) . "/mwbe/" . MappingUtil::$total_mwbe_cats . "/dashboard/" . $dashboard . _checkbook_project_get_url_param_string("agency") . _checkbook_project_get_url_param_string("vendor");
}
/**
* Gets the Spent to date link Url for the Sub Vendors widget
* @param $node
* @param $row
* @return string
*/
public static function getSubVendorSpentToDateLinkUrl($node, $row)
{
$dashboard = _getRequestParamValue("dashboard");
$url = "/contract/spending/transactions/csubvendor/" . $row["subvendor_subvendor"] . _checkbook_append_url_params() . _checkbook_project_get_url_param_string("status") . _checkbook_project_get_url_param_string("agency", "cagency") . _checkbook_project_get_url_param_string("awdmethod") . _checkbook_project_get_url_param_string("cindustry") . _checkbook_project_get_url_param_string("csize");
if ($node->nid == 720) {
$url .= '/doctype/CT1~CTA1' . ContractURLHelper::_checkbook_project_spending_get_year_url_param_string();
} else {
if ($dashboard == "ss" || $dashboard == "ms" || $dashboard == "sp") {
$url .= '/doctype/CT1~CTA1' . ContractURLHelper::_checkbook_project_spending_get_year_url_param_string();
} else {
$url .= '/doctype/CT1~CTA1~MA1' . ContractURLHelper::_checkbook_project_spending_get_year_url_param_string();
}
}
$url .= '/smnid/' . $node->nid . self::getSpentToDateParams() . '/newwindow';
if ($dashboard == "mp" && $node->nid == 720) {
$url = str_replace("dashboard/mp", "dashboard/ms", $url);
}
return $url;
}
/**
* Returns Agency YTD Spending Link Url based on values from current path & data row.
* This is for sub vendors Top 5 Agencies widget
*
* @param $node
* @param $row
* @return string
*/
static function getAgencyYtdSpendingUrl($node, $row)
{
//ytd_spending_sub_vendors_link
return '/spending/transactions' . '/agency/' . $row["agency_agency"] . _checkbook_project_get_url_param_string("vendor") . _checkbook_project_get_url_param_string("category") . _checkbook_project_get_url_param_string("industry") . _checkbook_project_get_year_url_param_string(false, false, true) . '/smnid/' . $node->nid . '/dtsmnid/' . $node->nid . '/newwindow';
}
function _prepare_oge_contracts_spending_url($row, $node)
{
$agencies = _checkbook_project_querydataset('checkbook_oge:agency', array('agency_id', 'agency_name'), array('agency_id' => $row['agency_id'], 'is_oge_agency' => 'Y'));
$oge_agency_name = $agencies[0]['agency_name'];
$vendors = _checkbook_project_querydataset('checkbook_oge:vendor', array('vendor_id', 'legal_name'), array('vendor_id' => $row['vendor_id']));
$oge_vendor_name = $vendors[0]['legal_name'];
$vendor_url = '';
if (strtolower($oge_agency_name) != strtolower($oge_vendor_name)) {
$vendor_url = '/svendor/' . $row['vendor_id'];
}
$year_url = '';
if (!(_getRequestParamValue('year') || _getRequestParamValue('calyear'))) {
$year_url = '/yeartype/B/year/' . _getFiscalYearID() . '/syear/' . _getFiscalYearID();
} else {
$year_url = $row['type_of_year'] == 'B' ? '/year/' . $row['fiscal_year_id'] . '/syear/' . $row['fiscal_year_id'] : '/calyear/' . $row['fiscal_year_id'] . '/scalyear/' . $row['fiscal_year_id'];
}
$url = "<a href='/spending/transactions" . ($row['master_agreement_yn'] == 'Y' ? '/magid/' : '/agid/') . $row['original_agreement_id'] . ($row['master_agreement_yn'] == 'Y' ? $vendor_url : '/svendor/' . $row['vendor_id']) . ($row['master_agreement_yn'] == 'Y' ? '' : '/scomline/' . $row['fms_commodity_line']) . $year_url . _checkbook_project_get_url_param_string('vendor') . _checkbook_append_url_params() . "/newwindow' class='new_window'>" . custom_number_formatter_basic_format($row['spending_amount_disb']) . '</a>';
return $url;
}
