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; }