*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
$city_agencies = array();
$edc_agencies = array();
foreach ($node->data as $key => $value) {
if (array_key_exists('is_oge_agency', $value)) {
$edc_agencies[$key] = $value;
} else {
$city_agencies[$key] = $value;
}
}
$oge_filter_highlight = _checkbook_check_isEDCPage() ? 'agency_filter_highlight' : '';
$city_filter_highlight = !_checkbook_check_isEDCPage() ? 'agency_filter_highlight' : '';
$current_fy_year = _getFiscalYearID();
$current_cal_year = _getCalendarYearID();
$current_url = explode('/', $_SERVER['REQUEST_URI']);
$url = $current_url[1];
if ($current_url[1] == 'contracts_landing' || $current_url[1] == 'contracts_revenue_landing' || $current_url[1] == 'contracts' || $current_url[1] == 'contracts_pending_exp_landing' || $current_url[1] == 'contracts_pending_rev_landing') {
$all_agency_url = $url = 'contracts_landing/status/A/yeartype/B/year/' . $current_fy_year;
} else {
if ($current_url[1] == 'payroll') {
$all_agency_url = $url = 'payroll/yeartype/B/year/' . $current_fy_year;
} else {
if ($current_url[1] == 'budget') {
$all_agency_url = $url = 'budget/yeartype/B/year/' . $current_fy_year;
} else {
if ($current_url[1] == 'revenue') {
$all_agency_url = $url = 'revenue/yeartype/B/year/' . $current_fy_year;
} else {
echo '<div class="number"><span class="active">' . number_format($row[2]) . '</span></div>';
echo '</div>';
}
$checked_index++;
}
}
echo '</div>';
echo '<div class="options">';
echo '<div class="rows">';
if ($value['unchecked']) {
$unchecked_index = 0;
foreach ($value['unchecked'] as $row) {
$id = $id_title . $unchecked_index . '_unchecked';
$yearID = _getYearIDFromValue($row[0]);
if ($title == 'Fiscal Year') {
if ($yearID <= _getFiscalYearID()) {
echo '<div class="row">';
echo '<div class="checkbox"><input type="checkbox" id="' . $id . '" value="' . $row[0] . '" ' . $disabled . ' name="' . $value['name'] . '" onClick="javascript:applySearchFilters();"><label for="' . $id . '"></label></div>';
echo '<div class="name">' . htmlentities($row[1]) . '</div>';
echo '<div class="number"><span>' . htmlentities(number_format($row[2])) . '</span></div>';
echo '</div>';
}
} else {
echo '<div class="row">';
echo '<div class="checkbox"><input type="checkbox" id="' . $id . '" value="' . $row[0] . '" ' . $disabled . ' name="' . $value['name'] . '" onClick="javascript:applySearchFilters();"><label for="' . $id . '"></label></div>';
echo '<div class="name">' . htmlentities($row[1]) . '</div>';
echo '<div class="number"><span>' . htmlentities(number_format($row[2])) . '</span></div>';
echo '</div>';
}
$unchecked_index++;
}
static function getCurrentDomainURLFromParams()
{
if (preg_match('/contract/', $_GET['q'])) {
$reqParams = MappingUtil::$contractsMWBEParamMap;
$prefix = 'contracts_landing';
} else {
$reqParams = MappingUtil::$spendingMWBEParamMap;
$prefix = 'spending_landing';
}
foreach ($reqParams as $key => $value) {
$value = _getRequestParamValue($key);
if ($key == "year" && $value == null) {
$value = _getFiscalYearID();
}
if ($key == "yeartype" && $value == null) {
$value = 'B';
}
if ($key == "status" && $value == null) {
$value = 'A';
}
$prefix .= $value != null ? "/{$key}/" . $value : "";
}
return $prefix;
}
}
if (!isset($year_id_value)) {
$year_id_value = $array_q[$year_key + 1];
if (!($year_id_value > 0)) {
$year_id_value = _getFiscalYearID();
}
}
if (!isset($year_type_value)) {
$year_type_key = array_search('yeartype', $array_q);
$year_type_value = $array_q[$year_type_key + 1];
}
$cal_year_key = array_search('calyear', $array_q);
$cal_year_id_value = $cal_year_key ? $array_q[$cal_year_key + 1] : $year_id_value;
$fiscal_year_data_array = array();
$calendar_year_data_array = array();
$current_fy_id = _getFiscalYearID();
$isSelected = false;
foreach ($node->data as $key => $value) {
if ($value['year_id'] == $year_id_value && ($year_type_value == 'B' || !$year_type_value)) {
$selected_fiscal_year = 'selected = yes';
$selected_cal_year = '';
$isSelected = true;
} elseif ($value['year_id'] == $cal_year_id_value && $year_type_value == 'C') {
$selected_fiscal_year = '';
$selected_cal_year = 'selected = yes';
} else {
$selected_fiscal_year = '';
$selected_cal_year = '';
$isSelected = true;
}
if ($value['year_value'] <= $filter_years['year_value'] && $value['year_value'] != '2010') {
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
$spending_parameter_mapping = _checkbook_smart_search_domain_fields('spending', $IsOge);
if ($spending_results['fiscal_year_id'] != '') {
$fiscal_year_id = $spending_results['fiscal_year_id'][0];
} else {
$fiscal_year_id = _getCurrentYearID();
}
if ($IsOge) {
$linkable_fields = array("oge_agency_name" => "/spending_landing/category/" . $spending_results['spending_category_id'] . '/datasource/checkbook_oge' . "/year/" . _getFiscalYearID() . "/yeartype/B/agency/" . $spending_results["agency_id"], "vendor_name" => "/spending_landing/category/" . $spending_results['spending_category_id'] . '/datasource/checkbook_oge' . '/agency/' . $spending_results['agency_id'] . "/year/" . _getFiscalYearID() . "/yeartype/B/vendor/" . $spending_results["vendor_id"]);
} else {
if ($spending_results['spending_category_name'] == 'Payroll') {
$linkable_fields = array("agency_name" => "/spending_landing/category/" . $spending_results['spending_category_id'] . "/year/" . $fiscal_year_id . "/yeartype/B/agency/" . $spending_results["agency_id"], "vendor_name" => $spending_results['vendor_name']);
} elseif ($spending_results['vendor_id'] == 1) {
$linkable_fields = array("agency_name" => "/spending_landing/category/" . $spending_results['spending_category_id'] . "/year/" . $fiscal_year_id . "/yeartype/B/agency/" . $spending_results["agency_id"], "vendor_name" => "/spending_landing/category/" . $spending_results['spending_category_id'] . "/year/" . $fiscal_year_id . "/yeartype/B/vendor/" . $spending_results["vendor_id"]);
} elseif ($spending_results['is_prime_or_sub'] == 'Yes' && SpendingUtil::getLatestMwbeCategoryBySpendingVendorByTransactionYear($spending_results["vendor_id"], $fiscal_year_id, 'B') == '') {
$linkable_fields = array("agency_name" => "/spending_landing/category/" . $spending_results['spending_category_id'] . "/year/" . $fiscal_year_id . "/yeartype/B/agency/" . $spending_results["agency_id"], "vendor_name" => "/spending_landing/category/" . $spending_results['spending_category_id'] . "/year/" . $fiscal_year_id . "/yeartype/B/subvendor/" . $spending_results["vendor_id"] . "/dashboard/ss");
} elseif ($spending_results['is_prime_or_sub'] == 'No' && SpendingUtil::getLatestMwbeCategoryBySpendingVendorByTransactionYear($spending_results["vendor_id"], $fiscal_year_id, 'B') != '') {
$linkable_fields = array("agency_name" => "/spending_landing/category/" . $spending_results['spending_category_id'] . "/year/" . $fiscal_year_id . "/yeartype/B/agency/" . $spending_results["agency_id"], "vendor_name" => "/spending_landing/yeartype/B/year/" . $fiscal_year_id . "/category/" . $spending_results['spending_category_id'] . "/mwbe/2~3~4~5~9/dashboard/mp/vendor/" . $spending_results["vendor_id"]);
} elseif ($spending_results['is_prime_or_sub'] == 'Yes' && SpendingUtil::getLatestMwbeCategoryBySpendingVendorByTransactionYear($spending_results["vendor_id"], $fiscal_year_id, 'B') != '') {
$linkable_fields = array("agency_name" => "/spending_landing/category/" . $spending_results['spending_category_id'] . "/year/" . $fiscal_year_id . "/yeartype/B/agency/" . $spending_results["agency_id"], "vendor_name" => "/spending_landing/yeartype/B/year/" . $fiscal_year_id . "/category/" . $spending_results['spending_category_id'] . "/mwbe/2~3~4~5~9/dashboard/ms/subvendor/" . $spending_results["vendor_id"]);
} else {
$linkable_fields = array("agency_name" => "/spending_landing/category/" . $spending_results['spending_category_id'] . "/year/" . $fiscal_year_id . "/yeartype/B/agency/" . $spending_results["agency_id"], "vendor_name" => "/spending_landing/category/" . $spending_results['spending_category_id'] . "/year/" . $fiscal_year_id . "/yeartype/B/vendor/" . $spending_results["vendor_id"]);
}
}
<?php
if (_get_current_datasource() == "checkbook") {
?>
<!-- Total Number of Sub Vendors -->
<li><span class="gi-list-item">M/WBE Vendor:</span> <?php
echo $node->data[0]['mwbe_vendor'];
?>
</li>
<?php
if (!preg_match('/newwindow/', $_GET['q']) && $node->data[0]["mwbe_vendor"] == 'Yes') {
?>
<li><span class="gi-list-item">M/WBE Category:</span> <a href="/contracts_landing<?php
echo $status;
?>
/yeartype/B/year/<?php
echo _getFiscalYearID();
?>
/mwbe/<?php
echo $minority_type_id;
?>
/dashboard/mp"><?php
echo $ethnicity;
?>
</a></li>
<?php
} else {
?>
<li><span class="gi-list-item">M/WBE Category: </span><?php
echo $ethnicity;
?>
</li>
// if(!$IsOge && $title == "Prime Vendor"){
// $title = "Vendor";
// }
if ($key == "minority_type_name" && !$contracts_results["minority_type_name"]) {
$value = 'N/A';
} elseif ($key == "minority_type_name" && $contracts_results["minority_type_name"]) {
$id = $contracts_results["minority_type_id"];
if ($id == '4' || $id == '5') {
$id = '4~5';
}
if ($contracts_results['minority_type_id'] != '7' && $contracts_results['minority_type_id'] != '11') {
if ($contracts_results['is_prime_or_sub'] == 'Yes') {
$value = "<a href='/contracts_landing/status/A/yeartype/B/year/" . $fiscal_year_id . "/mwbe/" . $id . "/dashboard/ms'>" . $contracts_results["minority_type_name"] . "</a>";
} else {
if (strtolower($contracts_results['contract_status']) == 'pending') {
$value = "<a href='/contracts_pending_exp_landing/yeartype/B/year/" . _getFiscalYearID() . "/mwbe/" . $id . "/dashboard/mp'>" . $contracts_results["minority_type_name"] . "</a>";
} else {
$value = "<a href='/contracts_landing/status/A/yeartype/B/year/" . $fiscal_year_id . "/mwbe/" . $id . "/dashboard/mp'>" . $contracts_results["minority_type_name"] . "</a>";
}
}
if ($contract_status == 'Registered' && $reg_fiscal_year < 2010 || $effective_end_year_id < 111) {
$value = $contracts_results["minority_type_name"];
}
} else {
$value = $contracts_results["minority_type_name"];
}
}
if ($count % 2 == 0) {
if ($title) {
$row[] = '<div class="field-label">' . $title . ':</div><div class="field-content">' . $value . '</div>';
}
public static function get_mwbe_category_url($minority_type_category_id, $is_prime_or_sub = null, $doctype = null)
{
$lower_doctype = strtolower($doctype);
/* Begin update for NYCCHKBK-4676 */
$minority_type_category_name = MappingUtil::getMinorityCategoryById($minority_type_category_id);
$dtsmnid = _getRequestParamValue("dtsmnid");
$smnid = _getRequestParamValue("smnid");
$dashboard = _getRequestParamValue("dashboard");
if ($dtsmnid != null) {
$nid = $dtsmnid;
} else {
if ($smnid != null) {
$nid = $smnid;
}
}
$no_link = $dashboard == "mp" && $nid == 720;
$no_link = $no_link || preg_match('/s/', $dashboard) && ($nid == 725 || $nid == 783);
if ($no_link) {
return $minority_type_category_name;
}
/* End update for NYCCHKBK-4676 */
$mwbe_cats = MappingUtil::getMinorityCategoryMappings();
$minority_type_category_string = implode('~', $mwbe_cats[$minority_type_category_name]);
$current_url = explode('/', $_SERVER['HTTP_REFERER']);
$status_index = array_search('contstatus', $current_url);
$category_index = array_search('contcat', $current_url);
$status = filter_xss($current_url[$status_index + 1]);
$category = filter_xss($current_url[$category_index + 1]);
$dashboard = $is_prime_or_sub == 'S' ? 'ms' : 'mp';
//From sub vendors widget
if ($nid == 720) {
$dashboard = "sp";
}
if ($category == 'expense' && $status != 'P') {
$url = '/contracts_landing/status/' . $status . '/yeartype/B/year/' . _getFiscalYearID() . '/dashboard/' . $dashboard . '/mwbe/' . $minority_type_category_string;
} else {
if ($category == 'revenue' && $status != 'P') {
$url = '/contracts_revenue_landing/status/' . $status . '/yeartype/B/year/' . _getFiscalYearID() . '/dashboard/' . $dashboard . '/mwbe/' . $minority_type_category_string;
} else {
if ($category == 'expense' && $status == 'P') {
$url = '/contracts_pending_exp_landing/yeartype/B/year/' . _getFiscalYearID() . '/dashboard/' . $dashboard . '/mwbe/' . $minority_type_category_string;
} else {
if ($category == 'revenue' && $status == 'P') {
$url = '/contracts_pending_rev_landing/yeartype/B/year/' . _getFiscalYearID() . '/dashboard/' . $dashboard . '/mwbe/' . $minority_type_category_string;
} else {
if ($category == 'all' && $status != 'P') {
if (_get_contract_cat($lower_doctype) == 'revenue') {
$url = '/contracts_revenue_landing/status/' . $status . '/yeartype/B/year/' . _getFiscalYearID() . '/dashboard/' . $dashboard . '/mwbe/' . $minority_type_category_string;
} else {
$url = '/contracts_landing/status/' . $status . '/yeartype/B/year/' . _getFiscalYearID() . '/dashboard/' . $dashboard . '/mwbe/' . $minority_type_category_string;
}
} else {
if ($category == 'all' && $status == 'P') {
if (_get_contract_cat($lower_doctype) == 'revenue') {
$url = '/contracts_pending_rev_landing/yeartype/B/year/' . _getFiscalYearID() . '/dashboard/' . $dashboard . '/mwbe/' . $minority_type_category_string;
} else {
$url = '/contracts_pending_exp_landing/yeartype/B/year/' . _getFiscalYearID() . '/dashboard/' . $dashboard . '/mwbe/' . $minority_type_category_string;
}
}
}
}
}
}
}
// pending_changes
$url .= _checkbook_project_get_url_param_string("agency") . _checkbook_project_get_url_param_string("cindustry") . _checkbook_project_get_url_param_string("csize") . _checkbook_project_get_url_param_string("awdmethod") . _checkbook_project_get_url_param_string("contstatus", "status") . _checkbook_project_get_url_param_string("vendor") . _checkbook_project_get_url_param_string("subvendor");
$result = !in_array($minority_type_category_id, array(7, 11)) ? "<a href='" . $url . "'>" . $minority_type_category_name . "</a>" : $minority_type_category_name;
return $result;
}
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;
}
