public function getData(&$node)
{
$mag_id = _getRequestParamValue("magid");
$query1 = "SELECT l1.contract_number,\r\n l2.vendor_id AS vendor_id_checkbook_vendor_history,\r\n l3.legal_name AS legal_name_checkbook_vendor,\r\n l1.description,\r\n l5.agency_name AS agency_name_checkbook_agency,\r\n l5.agency_id AS agency_id_checkbook_agency,\r\n l656.award_method_name AS award_method_name_checkbook_award_method,\r\n l1.document_version,\r\n l1.tracking_number,\r\n l1.number_responses,\r\n l1.number_solicitation,\r\n l1.maximum_spending_limit,\r\n l1.board_approved_award_no,\r\n l1.original_contract_amount,\r\n l444.document_code AS document_code_checkbook_ref_document_code,\r\n l1040.date AS date_chckbk_dat_id_effctv_bgn_date_id_chckbk_hstr_mstr_agrmnt_0,\r\n l1124.date AS date_chckbk_date_id_effctv_end_dat_id_chckbk_hstr_mstr_agrmnt_1,\r\n l1208.date AS date_chckbk_date_id_rgstrd_date_id_chckbk_histr_master_agrmnt_2,\r\n rat.agreement_type_name\r\n FROM {history_master_agreement} AS l1\r\n LEFT OUTER JOIN {vendor_history} AS l2 ON l2.vendor_history_id = l1.vendor_history_id\r\n LEFT OUTER JOIN {vendor} AS l3 ON l3.vendor_id = l2.vendor_id\r\n LEFT OUTER JOIN {ref_agency_history} AS l4 ON l4.agency_history_id = l1.agency_history_id\r\n LEFT OUTER JOIN {ref_agency} AS l5 ON l5.agency_id = l4.agency_id\r\n LEFT OUTER JOIN {ref_document_code} AS l444 ON l444.document_code_id = l1.document_code_id\r\n LEFT OUTER JOIN {ref_award_method} AS l656 ON l656.award_method_id = l1.award_method_id\r\n LEFT OUTER JOIN {ref_date} AS l1040 ON l1040.date_id = l1.effective_begin_date_id\r\n LEFT OUTER JOIN {ref_date} AS l1124 ON l1124.date_id = l1.effective_end_date_id\r\n LEFT OUTER JOIN {ref_date} AS l1208 ON l1208.date_id = l1.registered_date_id\r\n LEFT OUTER JOIN {ref_agreement_type} AS rat ON l1.agreement_type_id = rat.agreement_type_id\r\n WHERE l1.original_master_agreement_id = " . $mag_id . "\r\n AND l1.latest_flag = 'Y'\r\n ";
$results1 = _checkbook_project_execute_sql_by_data_source($query1, _get_default_datasource());
$node->data = $results1;
if (_get_current_datasource() == _get_default_datasource()) {
$query2 = "select rfed_amount from {agreement_snapshot} where original_agreement_id = " . $mag_id . "\r\n \t\tand master_agreement_yn = 'Y' and latest_flag = 'Y'";
$results2 = _checkbook_project_execute_sql_by_data_source($query2, _get_default_datasource());
$spent_amount = 0;
foreach ($results2 as $row) {
$spent_amount += $row["rfed_amount"];
}
$node->spent_amount = $spent_amount;
$node->original_contract_amount = $node->data[0]['original_contract_amount'];
$node->maximum_spending_limit = $node->data[0]['maximum_spending_limit'];
$query3 = "SELECT COUNT(*) AS total_child_contracts\r\n\t FROM {history_agreement}\r\n\t WHERE master_agreement_id = " . $mag_id . "\r\n\t AND latest_flag = 'Y'";
$results3 = _checkbook_project_execute_sql_by_data_source($query3, _get_current_datasource());
$total_child_contracts = 0;
foreach ($results3 as $row) {
$total_child_contracts += $row["total_child_contracts"];
}
$node->total_child_contracts = $total_child_contracts;
} else {
$query2 = "select sum(original_amount) original_amount, sum(current_amount) current_amount, \r\n \t\t\tcount(distinct fms_contract_number) as num_associated_contracts, sum(check_amount) as spent_amount\r\n\t\t\t\tFROM {oge_contract_vendor_level} a\r\n\t\t\t\tJOIN (select distinct contract_number from {history_agreement} where master_agreement_id = " . $mag_id . ") b\r\n\t\t\t\tON a.fms_contract_number = b.contract_number\r\n\t\t\t\tLEFT JOIN (SELECT sum(check_amount) as check_amount, contract_number, vendor_id FROM {disbursement_line_item_details} group by 2,3) c\r\n\t\t\t\tON b.contract_number = c.contract_number AND a.vendor_id = c.vendor_id limit 1";
$results2 = _checkbook_project_execute_sql_by_data_source($query2, _get_current_datasource());
foreach ($results2 as $row) {
$node->spent_amount = $row['spent_amount'];
$node->original_contract_amount = $row['original_amount'];
$node->maximum_spending_limit = $row['current_amount'];
$node->total_child_contracts = $row['num_associated_contracts'];
}
$node->data_source_amounts_differ = ContractUtil::masterAgreementAmountsDiffer($mag_id);
}
}
public function getData(&$node)
{
$contract_num = _getRequestParamValue("contract");
$version_num = _getRequestParamValue("version");
$query1 = "SELECT\n vh.vendor_id,\n l1.fms_parent_contract_number AS parent_contract_number,\n l1.vendor_customer_code,\n l1.contract_number,\n l1.vendor_legal_name AS legal_name_checkbook_vendor,\n l1.vendor_id vendor_vendor,\n l1.description,\n l1.document_agency_name AS agency_name_checkbook_agency,\n l1.document_agency_id AS agency_id_checkbook_agency,\n l1.award_method_name AS award_method_name_checkbook_award_method,\n l1.document_version,\n l1.tracking_number,\n l1.board_award_number AS board_approved_award_no,\n l1.original_maximum_amount AS original_contract_amount,\n l1.revised_maximum_amount AS maximum_spending_limit,\n l444.document_code AS document_code_checkbook_ref_document_code,\n l1.start_date AS date_chckbk_dat_id_effctv_bgn_date_id_chckbk_hstr_mstr_agrmnt_0,\n l1.end_date AS date_chckbk_date_id_effctv_end_dat_id_chckbk_hstr_mstr_agrmnt_1\n FROM pending_contracts AS l1\n LEFT OUTER JOIN ref_document_code AS l444 ON l444.document_code_id = l1.document_code_id\n LEFT JOIN {vendor} v ON l1.vendor_id = v.vendor_id\n LEFT JOIN (SELECT vendor_id, MAX(vendor_history_id) AS vendor_history_id\n FROM {vendor_history} WHERE miscellaneous_vendor_flag::BIT = 0 ::BIT GROUP BY 1) vh ON v.vendor_id = vh.vendor_id\n WHERE l1.contract_number = '" . $contract_num . "' AND document_version = " . $version_num;
$results1 = _checkbook_project_execute_sql($query1);
$node->data = $results1;
$parent_contract_number = $node->data[0]['parent_contract_number'];
if (!empty($parent_contract_number)) {
$mag_details = _get_master_agreement_details_by_parent_contract_number($parent_contract_number);
$node->original_master_agreement_id = $mag_details['original_master_agreement_id'];
$node->contract_number = $mag_details['contract_number'];
$node->document_code = $mag_details['document_code@checkbook:ref_document_code'];
$node->contract_number = $parent_contract_number;
}
}
public function getData(&$node)
{
$ag_id = _getRequestParamValue("agid");
$query1 = "SELECT l1.contract_number, a.master_contract_number,\n l2.vendor_id AS vendor_id_checkbook_vendor_history,\n l529.legal_name AS legal_name_checkbook_vendor,\n l1.description,\n l531.agency_name AS agency_name_checkbook_agency,\n l531.agency_id AS agency_id_checkbook_agency,\n l1071.award_method_name AS award_method_name_checkbook_award_method,\n l1.document_version,\n l1.tracking_number,\n l1.number_responses,\n l1.number_solicitation,\n l1.maximum_contract_amount,\n l1.brd_awd_no,\n l1.original_contract_amount,\n l903.document_code AS document_code_checkbook_ref_document_code,\n l1237.date AS date_chckbk_date_id_effctv_begin_date_id_chckbk_histor_agrmnt_0,\n l1318.date AS date_checkbk_date_id_effctv_end_date_id_chckbk_history_agrmnt_1,\n l1399.date AS date_chckbk_date_id_rgstrd_date_id_checkbook_history_agreemnt_2,\n rat.agreement_type_name\n FROM history_agreement AS l1\n LEFT OUTER JOIN agreement_snapshot AS a ON l1.master_agreement_id = a.master_agreement_id\n LEFT OUTER JOIN vendor_history AS l2 ON l2.vendor_history_id = l1.vendor_history_id\n LEFT OUTER JOIN vendor AS l529 ON l529.vendor_id = l2.vendor_id\n LEFT OUTER JOIN ref_agency_history AS l530 ON l530.agency_history_id = l1.agency_history_id\n LEFT OUTER JOIN ref_agency AS l531 ON l531.agency_id = l530.agency_id\n LEFT OUTER JOIN ref_document_code AS l903 ON l903.document_code_id = l1.document_code_id\n LEFT OUTER JOIN ref_award_method AS l1071 ON l1071.award_method_id = l1.award_method_id\n LEFT OUTER JOIN ref_date AS l1237 ON l1237.date_id = l1.effective_begin_date_id\n LEFT OUTER JOIN ref_date AS l1318 ON l1318.date_id = l1.effective_end_date_id\n LEFT OUTER JOIN ref_date AS l1399 ON l1399.date_id = l1.registered_date_id\n LEFT OUTER JOIN {ref_agreement_type} AS rat ON l1.agreement_type_id = rat.agreement_type_id\n WHERE l1.original_agreement_id = " . $ag_id . "\n AND l1.latest_flag = 'Y'\n ";
$query2 = "select rfed_amount from history_agreement where original_agreement_id = " . $ag_id . " and latest_flag = 'Y' limit 1";
$results1 = _checkbook_project_execute_sql_by_data_source($query1, _get_current_datasource());
$node->data = $results1;
$magid = _get_master_agreement_id();
if (!empty($magid)) {
$magdetails = _get_master_agreement_details($magid);
$node->magid = $magid;
$node->document_code = $magdetails['document_code@checkbook:ref_document_code'];
$node->contract_number = $magdetails['contract_number'];
}
if (_get_current_datasource() == _get_default_datasource()) {
$results2 = _checkbook_project_execute_sql_by_data_source($query2, _get_current_datasource());
$spent_amount = 0;
foreach ($results2 as $row) {
$spent_amount += $row["rfed_amount"];
}
$node->spent_amount = $spent_amount;
$query3 = "SELECT COUNT(*) AS total_child_contracts\n\t FROM {history_agreement}\n\t WHERE master_agreement_id = " . $magid . "\n\t AND latest_flag = 'Y'";
$results3 = _checkbook_project_execute_sql($query3);
$total_child_contracts = 0;
foreach ($results3 as $row) {
$total_child_contracts += $row["total_child_contracts"];
}
$node->total_child_contracts = $total_child_contracts;
} else {
$query2 = "select sum(original_amount) original_amount, sum(current_amount) current_amount,\n \t\t\t sum(check_amount) as spent_amount\n\t\t\t\tFROM {oge_contract_vendor_level} a\n\t\t\t\tJOIN (select distinct contract_number from {history_agreement} where agreement_id = " . $ag_id . ") b\n\t\t\t\tON a.fms_contract_number = b.contract_number\n\t\t\t\tLEFT JOIN (SELECT sum(check_amount) as check_amount, contract_number, vendor_id FROM {disbursement_line_item_details} group by 2,3) c\n\t\t\t\tON b.contract_number = c.contract_number AND a.vendor_id = c.vendor_id limit 1";
$results2 = _checkbook_project_execute_sql_by_data_source($query2, _get_current_datasource());
foreach ($results2 as $row) {
$node->spent_amount = $row['spent_amount'];
$node->original_contract_amount = $row['original_amount'];
$node->maximum_contract_amount = $row['current_amount'];
$node->total_child_contracts = $row['num_associated_contracts'];
}
$node->data_source_amounts_differ = ContractUtil::childAgreementAmountsDiffer($ag_id);
}
}
public static function getSpentToDateParams()
{
$url = $_GET['q'];
$parameters = '';
$contract_status = _getRequestParamValue('status');
$contract_type = 'expense';
if (preg_match('/revenue/', $url)) {
$contract_type = 'revenue';
} else {
if (preg_match('/pending_exp/', $url)) {
$contract_type = 'expense';
} else {
if (preg_match('/pending_rev/', $url)) {
$contract_type = 'revenue';
}
}
}
if (isset($contract_status)) {
$parameters = '/contstatus/' . $contract_status;
}
$parameters .= '/contcat/' . $contract_type;
return $parameters;
}
<?php
/**
* This file is part of the Checkbook NYC financial transparency software.
*
* Copyright (C) 2012, 2013 New York City
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
*
* 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/>.
*/
$refURL = $_GET['refURL'];
$title = "New York City";
$agencyId = _getRequestParamValue('agency');
if (isset($agencyId)) {
$title = _checkbook_project_get_name_for_argument("agency_id", $agencyId);
}
$domain = 'Payroll';
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
*
* 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/>.
*/
$title = eval($node->widgetConfig->summaryView->templateTitleEval);
$month = '';
$year = 'FY' . _getYearValueFromID(_getRequestParamValue('year'));
$monthDetails = CheckbookDateUtil::getMonthDetails(_getRequestParamValue('month'));
$amount = custom_number_formatter_format(_getRequestParamValue('amt'), 2);
if (isset($monthDetails)) {
$month = strtoupper($monthDetails[0]['month_name']);
}
$summaryContent = <<<EOD
<div class="contract-details-heading">
\t<div class="contract-id">
\t\t<h2 class="contract-title">{$title}</h2>
\t\t<div class="spending-tx-subtitle"><b>Year</b>: {$year}<br><b>Month</b>: {$month}</div>
\t</div>
\t<div class="dollar-amounts"><div class="total-spending-amount">{$amount}<div class="amount-title">Total Spending Amount</div></div></div>
</div>
EOD;
print $summaryContent;
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
*
* 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/>.
*/
$records = $node->data;
if (is_array($records)) {
$row = $records[0];
$noContr = WidgetUtil::getLabel("no_of_contracts");
$smnid = _getRequestParamValue('smnid');
$dynamicLabel = $node->widgetConfig->summaryView->entityColumnLabel;
$dynamicValue = strtoupper($row[$node->widgetConfig->summaryView->entityColumnName]);
if ($smnid == 720) {
$noContr = WidgetUtil::getLabel("num_sub_contracts");
$mwbe_category = '<strong>' . WidgetUtil::getLabel("mwbe_category") . '</strong>: ' . strtoupper(MappingUtil::getMinorityCategoryById($row['minority_type_minority_type']));
} else {
if ($smnid == 725) {
$noContr = WidgetUtil::getLabel("num_sub_contracts");
$mwbe_category = '<strong>' . WidgetUtil::getLabel("mwbe_category") . '</strong>: ' . strtoupper(MappingUtil::getMinorityCategoryById($row['prime_minority_type_prime_minority_type']));
} else {
if ($smnid == 726 || $smnid == 727 || $smnid == 728 || $smnid == 729) {
$noContr = WidgetUtil::getLabel("num_sub_contracts");
} else {
if ($smnid == 783) {
$mwbe_category = '<strong>' . WidgetUtil::getLabel("mwbe_category") . '</strong>: ' . strtoupper(MappingUtil::getMinorityCategoryById($row['current_prime_minority_type_id']));
<th><div><span>Spending Chart</span></div></th>
<th><div><span>YTD Spending</span></div></th>
<th> </th>
</tr>
</thead>
<tbody class="hidden_body" style="display:none" >
<?php
$id = 0;
foreach ($left_agencies_data as $row) {
$agency = $row['agency_name'];
$chart = theme('mwbe_agency_grading_row_chart', array('id' => $id, 'data_row' => $row['data_row']));
if ($row['spending_amount'] > 0) {
if ($is_prime == 'sub_vendor_data') {
$link = "/spending_landing/year/" . _getRequestParamValue("year") . "/yeartype/" . _getRequestParamValue("yeartype") . "/agency/" . $row["agency_id"] . "/dashboard/sp/mwbe/" . MappingUtil::$total_mwbe_cats;
} else {
$link = "/spending_landing/year/" . _getRequestParamValue("year") . "/yeartype/" . _getRequestParamValue("yeartype") . "/agency/" . $row["agency_id"] . "/dashboard/mp/mwbe/" . MappingUtil::$total_mwbe_cats;
}
echo "<tr>\n\t\t\t\t\t\t<td><div><a href=\"" . $link . "\">" . $agency . "</a></div></td>\n\t\t\t\t\t\t<td>" . $chart . " </td>\n\t\t\t\t\t\t<td>" . $row['spending_amount'] . " </td>\n\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t</tr>\t\n\t\t\t\t\t";
}
$id += 1;
}
?>
</tbody>
</table>
</div>
<script>
$link = $url . '?expandBottomContURL=' . $bottom_url;
}
$link = preg_replace("/yeartype\\/./", "yeartype/C", $link);
$link = str_replace("/dept/" . $deptId, "/dept/" . $dept_Ids[$value['year_id']], $link);
$link = str_replace("/expcategory/" . $expCatId, "/expcategory/" . $expCatIds[$value['year_id']], $link);
}
/*For the charts with the months links, need to persist the month param for the newly selected year*/
if (isset($bottomURL) && preg_match('/month/', $bottomURL)) {
$old_month_id = RequestUtil::getRequestKeyValueFromURL("month", $bottomURL);
$year_id = $value['year_id'];
if (isset($old_month_id) && isset($year_id)) {
$new_month_id = _translateMonthIdByYear($old_month_id, $year_id, "C");
$link = preg_replace('/\\/month\\/' . $old_month_id . '/', '/month/' . $new_month_id, $link);
}
}
$calendar_year_data_array[] = array('display_text' => 'CY ' . $value['year_value'] . ' (Jan 1, ' . $value['year_value'] . ' - Dec 31, ' . $value['year_value'] . ')', 'value' => $value['year_id'] . '~C', 'link' => $link, 'selected' => $selected_cal_year);
}
}
$year_data_array = array_merge($fiscal_year_data_array, $calendar_year_data_array);
if (_getRequestParamValue('contstatus') == 'P') {
return;
}
$year_list = "<select id='year_list'>";
foreach ($year_data_array as $key => $value) {
$year_list .= "<option " . $value['selected'] . " value=" . $value['value'] . " link='" . $value['link'] . "' >" . $value['display_text'] . "</option>";
}
$year_list .= "</select>";
if ($isSelected) {
print "<span class=\"filter\" >Filter: </span>" . $year_list;
}
}
function _mwbe_spending_use_subvendor()
{
if (_getRequestParamValue('vendor') > 0 || _getRequestParamValue('mwbe') == '7' || _getRequestParamValue('mwbe') == '11') {
return true;
} else {
return false;
}
}
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;
}
static function generateLabelMappingNoDiv($labelAlias, $labelOnly = false)
{
$dynamic_labelAlias = array("current_modified", "previous_modified", "previous_1_modified", "previous_2_modified", "recognized_current", "recognized_1", "recognized_2", "recognized_3");
if (in_array($labelAlias, $dynamic_labelAlias)) {
$year = _getYearValueFromID(_getRequestParamValue('year'));
$dynamic_labels = array("current_modified" => "Modified<br/>" . $year, "previous_modified" => "Modified<br/>" . ($year - 1), "previous_1_modified" => "Modified<br/>" . ($year - 2), "previous_2_modified" => "Modified<br/>" . ($year - 3), "recognized_current" => "Recognized<br/>" . $year, "recognized_1" => "Recognized<br/>" . ($year + 1), "recognized_2" => "Recognized<br/>" . ($year + 2), "recognized_3" => "Recognized<br/>" . ($year + 3));
$label = $dynamic_labels[$labelAlias];
} else {
$label = NULL;
if ($labelOnly) {
$label = self::getLabel($labelAlias);
} else {
$label = self::$labels[$labelAlias];
}
}
return $label;
}
class="toggler collapsed <?php
echo $clickClass . ' ' . $class;
?>
"
id="master_assoc_cta_expand"></span>
<div class='contract-title-text'>Contract Spending for
<a href="/panel_html/contract_transactions/contract_details/agid/<?php
echo $contract['original_agreement_id'] . $datasource;
?>
/doctype/CTA1"
class="bottomContainerReload"><?php
echo $contract['contract_number'];
?>
</a></div>
<?php
if (_getRequestParamValue("datasource") == "checkbook_oge" && !preg_match('/newwindow/', $_GET['q']) && $contract['data_source_amounts_differ']) {
$alt_txt = "This contract agreement has information as a prime vendor.<br><br> Click this icon to view this contract as a prime vendor. ";
$url = "/contract_details/agid/" . $contract['original_agreement_id'] . "/doctype/CTA1/newwindow";
echo "<div class='contractLinkNote'><a class='new_window' href='" . $url . "' alt='" . $alt_txt . "' target='_blank' >Open in New Window</a></div>";
}
?>
<div class="assoc_amounts">
<div class="rfed-amount contract-details-assoc"><span class="amount"><?php
echo custom_number_formatter_format($contract['spent_amount'], 2, '$');
?>
</span><span class="label">Spent to Date</span></div>
<div class="rfed-amount contract-details-assoc"><span class="amount"><?php
echo custom_number_formatter_format($contract['original_amount'], 2, '$');
?>
</span><span class="label">Orignal Amount</span></div>
<div class="rfed-amount contract-details-assoc"><span class="amount"><?php
<?php
/**
* This file is part of the Checkbook NYC financial transparency software.
*
* Copyright (C) 2012, 2013 New York City
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
*
* 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/>.
*/
$categoryId = _getRequestParamValue('category');
$catname = RequestUtil::getSpendingTransactionTitle();
print '<div class="dollar-amounts"><div class="total-spending-amount">$' . custom_number_formatter_format($node->data[0]['check_amount_sum'], 2) . '<div class="amount-title">' . ($catname . ' Amount') . '</div></div></div>';
<?php
echo $count;
?>
Trust & Agency<br>Spending<br><?php
echo $dollars;
?>
<?php
}
?>
</div>
<div class="indicator"></div>
</td>
<?php
$class = "";
if (_getRequestParamValue("category") == 4) {
$class = ' active';
}
$link = RequestUtil::preparePayrollBottomNavFilter("spending_landing", 4);
$dollars = "<span class='dollars'>" . custom_number_formatter_format($dollars_by_cat[4], 1, '$') . "</span>";
?>
<td class="last<?php
echo $class;
?>
">
<div class="positioning">
<?php
if ($dollars_by_cat[4] != 0) {
?>
<a href="/<?php
echo $link;
* 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/>.
*/
?>
<h4>
Prime Vendor Information
</h4>
<?php
//TODO temp fix move bottom code to separate custom preprocess function
$contract_num = _getRequestParamValue("contract");
$version_num = _getRequestParamValue("version");
$queryVendorDetails = "SELECT\n vh.vendor_id,\n rb.business_type_code,\n p.vendor_id vendor_vendor,\n l444.document_code,\n va.address_id,\n p.vendor_legal_name AS vendor_name,\n a.address_line_1,\n a.address_line_2,\n a.city, a.state, a.zip, a.country,\n (CASE WHEN (rb.business_type_code = 'MNRT' OR rb.business_type_code = 'WMNO') THEN 'Yes' ELSE 'NO' END) AS mwbe_vendor,\n (CASE WHEN rm.minority_type_id in (4,5) then 'Asian American' ELSE rm.minority_type_name END)AS ethnicity\n\t FROM {pending_contracts} p\n\t LEFT JOIN {vendor} v ON p.vendor_id = v.vendor_id\n\t LEFT JOIN (SELECT vendor_id, MAX(vendor_history_id) AS vendor_history_id\n\t FROM {vendor_history} WHERE miscellaneous_vendor_flag::BIT = 0 ::BIT GROUP BY 1) vh ON v.vendor_id = vh.vendor_id\n\t LEFT JOIN {vendor_address} va ON vh.vendor_history_id = va.vendor_history_id\n\t LEFT JOIN {address} a ON va.address_id = a.address_id\n\t LEFT JOIN {ref_address_type} ra ON va.address_type_id = ra.address_type_id\n\t LEFT JOIN {vendor_business_type} vb ON vh.vendor_history_id = vb.vendor_history_id\n\t LEFT JOIN {ref_business_type} rb ON vb.business_type_id = rb.business_type_id\n\t LEFT JOIN {ref_minority_type} rm ON vb.minority_type_id = rm.minority_type_id\n\t LEFT JOIN {ref_document_code} AS l444 ON l444.document_code_id = p.document_code_id\n\t WHERE p.contract_number = '" . $contract_num . "'" . " AND p.document_version =" . $version_num;
$results1 = _checkbook_project_execute_sql($queryVendorDetails);
$node->data = $results1;
foreach ($node->data as $key => $value) {
if ($value['business_type_code'] == "MNRT" || $value['business_type_code'] == "WMNO") {
$node->data[0]["mwbe_vendor"] = "Yes";
}
}
if ($node->data[0]["vendor_id"]) {
$queryVendorCount = "SELECT COUNT(*) AS total_contracts_sum FROM {agreement_snapshot} WHERE latest_flag= 'Y' AND vendor_id =" . $node->data[0]["vendor_id"];
$results2 = _checkbook_project_execute_sql($queryVendorCount);
foreach ($results2 as $row) {
$total_cont += $row['total_contracts_sum'];
}
$vendor_link = '/contracts_landing/status/A/year/' . _getCurrentYearID() . '/yeartype/B/vendor/' . $node->data[0]['vendor_id'] . '?expandBottomCont=true';
<?php
echo $count;
?>
<br>Active<br>Revenue Contracts<br><?php
echo $dollars;
?>
<?php
}
?>
</div>
<div class="indicator"></div>
</td>
<?php
$class = "";
if (preg_match("/^contracts_revenue_landing/", $_GET['q']) & _getRequestParamValue("status") == "R") {
$class = ' class="active"';
}
$reg_link = ContractURLHelper::prepareActRegContractsSliderFilter('contracts_revenue_landing', 'R');
$count = "<span class='count'>" . number_format($node->data[3]['total_contracts']) . "</span>";
$dollars = "<span class='dollars'>" . custom_number_formatter_format($node->data[3]['current_amount_sum'], 1, '$') . "</span>";
?>
<td<?php
echo $class;
?>
>
<div class="positioning">
<?php
if ($node->data[3]['total_contracts'] > 0) {
?>
if ($value[0] == 4 || $value[0] == 5) {
$count = $count + $value[2];
$id = "4~5";
unset($checked[$key]);
} else {
array_push($checked, array($value[0], MappingUtil::getMinorityCategoryById($value[0]), $value[2]));
unset($checked[$key]);
}
}
if ($count > 0) {
array_push($checked, array($id, 'Asian American', $count));
}
}
//Data alteration for Vendor Type Facet
if ($node->widgetConfig->filterName == 'Vendor Type') {
$vendor_types = _getRequestParamValue('vendortype');
$vendor_type_data = MappingUtil::getVendorTypes($checked, $vendor_types);
$vendor_type_data = MappingUtil::getVendorTypes($unchecked, $vendor_types);
$checked = $vendor_type_data['checked'];
$unchecked = $vendor_type_data['unchecked'];
}
if (count($checked) == 0) {
$display_facet = "none";
$span = "";
} else {
$display_facet = "block";
$span = "open";
}
if (strtolower($filter_name) == 'agency') {
if (_checkbook_check_isEDCPage()) {
$filter_name = 'Other Government Entity';
January: 12, February: 11, March: 10, April: 9, May: 8, June: 7,
July: 6, August: 5, September: 4, October: 3, November:2, December:1
};
source.month' . $index . ' = months[val];
source.month_display' . $index . ' = "<div class=\\"text\\">" + val + "</div>";
return;
}else if (type == "display") {
return source.month_display' . $index . ';
}
return source.month' . $index . ';
},
"sClass":"' . $column->columnType . '",
"asSorting": [ "desc", "asc" ]
},
';
} elseif (($column->formatType == 'monthfy' || $column->formatType == 'month') && _getRequestParamValue('yeartype') == 'B') {
$aoColumnDefs .= ' {
"aTargets": [' . $index . '],
"aExportFn":"function",
"mDataProp": function ( source, type, val ) {
if (type == "set") {
var months_fy = {
January: 6, February: 5, March: 4, April: 3, May: 2, June: 1,
July: 12, August: 11, September: 10, October: 9, November:8, December:7
};
source.month' . $index . ' = months_fy[val];
source.month_display' . $index . ' = "<div class=\\"text\\">" + val + "</div>";
return;
}else if (type == "display") {
return source.month_display' . $index . ';
}
// dont hightlight mwbe for advanced search pages.
if (!preg_match('/smnid/', $_GET['q']) && (preg_match('/spending\\/transactions/', $_GET['q']) || preg_match('/contract\\/all\\/transactions/', $_GET['q']) || preg_match('/contract\\/search\\/transactions/', $_GET['q']))) {
$mwbeclass = ' ';
}
if ($mwbe_amount == 0 && $mwbe_amount_active_inc == 0) {
$mwbe_link = l('<div><div class="top-navigation-amount"><span class="nav-title">' . RequestUtil::getDashboardTopNavTitle("mwbe") . '</span><br> ' . custom_number_formatter_format(0, 1, '$') . '</div></div>', '', $options_disabled);
} else {
$mwbe_link = l('<div><div class="top-navigation-amount"><span class="nav-title">' . RequestUtil::getDashboardTopNavTitle("mwbe") . '</span><br> ' . custom_number_formatter_format($mwbe_amount, 1, '$') . '</div></div>', $mwbe_active_domain_link, $options);
}
if ($svendor_amount == 0 && $svendor_amount_active_inc == 0) {
$subvendors_link = l('<div><div class="top-navigation-amount"><span class="nav-title">' . RequestUtil::getDashboardTopNavTitle("subvendor") . '</span><br> ' . custom_number_formatter_format(0, 1, '$') . '</div></div>', '', $options_disabled);
} else {
$subvendors_link = l('<div><div class="top-navigation-amount"><span class="nav-title">' . RequestUtil::getDashboardTopNavTitle("subvendor") . '</span><br> ' . custom_number_formatter_format($svendor_amount, 1, '$') . '</div></div>', $svendor_active_domain_link, $options);
}
$indicator_left = true;
$featured_dashboard = _getRequestParamValue("dashboard");
if ($featured_dashboard != null) {
$indicator_left = false;
} else {
$indicator_left = true;
}
// conditions for making mwbe active.
if ($featured_dashboard == "mp" || $featured_dashboard == "ms" || $featured_dashboard != null && ($mwbe_amount > 0 || $mwbe_amount_active_inc > 0) || RequestUtil::$is_prime_mwbe_amount_zero_sub_mwbe_not_zero) {
$mwbeclass = ' active';
}
if ($featured_dashboard == "sp" || $featured_dashboard == "ss" || $featured_dashboard != null && ($svendor_amount > 0 || $svendor_amount_active_inc > 0) || RequestUtil::$is_prime_mwbe_amount_zero_sub_mwbe_not_zero) {
$svclass = ' active';
}
$expclass = '';
$rclass = '';
$cclass = '';
* 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/>.
*/
$smnid = _getRequestParamValue('smnid');
$dashboard = _getRequestParamValue('dashboard');
$contactStatus = _getRequestParamValue('contstatus');
$contactStatusLabel = 'Active';
if ($contactStatus == 'R') {
$contactStatusLabel = 'Registered';
}
$contactCategory = _getRequestParamValue('contcat');
$contactCategoryLabel = 'Expense';
if ($contactCategory == 'revenue') {
$contactCategoryLabel = 'Revenue';
}
if ($contactCategory == 'all') {
$contactCategoryLabel = '';
}
$current_url = explode('/', $_SERVER['REQUEST_URI']);
if ($current_url[1] == 'contract' && ($current_url[2] == 'search' || $current_url[2] == 'all') && $current_url[3] == 'transactions') {
$summaryTitle = "";
} else {
if (_checkbook_check_is_mwbe_page() || $dashboard) {
$summaryTitle = RequestUtil::getDashboardTitle() . " ";
}
}
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'];
}
/**
* This file is part of the Checkbook NYC financial transparency software.
*
* Copyright (C) 2012, 2013 New York City
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
*
* 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/>.
*/
$title = 'New York City';
$domain = 'Budget';
$agency = _getRequestParamValue('agency');
$expcategory = _getRequestParamValue('expcategory');
if (!empty($expcategory)) {
$expName = _checkbook_project_get_name_for_argument('object_class_id', $expcategory);
$title = $expName;
} else {
if (!empty($agency)) {
$title = _checkbook_project_get_name_for_argument('agency_id', $agency);
}
}
echo "<th{$headerClass}>" . $label . "</th>";
}
}
}
echo "</tr>\n";
?>
</thead>
<tbody>
<?php
if (isset($node->data) && is_array($node->data)) {
foreach ($node->data as $datarow) {
echo "<tr>";
foreach ($node->widgetConfig->table_columns as $row) {
if (!isset($row->datasource) || isset($row->datasource) && $row->datasource == _getRequestParamValue('datasource')) {
echo '<td class="' . $datarow[$row->classColumn] . '">' . $datarow[$row->column] . '</td>';
}
}
echo "</tr>";
}
}
?>
</tbody>
</table>
<?php
echo '<div class="tableFooter">';
if ($node->widgetConfig->enableExpand == TRUE) {
if ($node->totalDataCount > 5) {
echo '<a href="#" class="expandCollapseWidget"><img src="/' . drupal_get_path('theme', $GLOBALS['theme']) . '/images/open.png"></a>';
* 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/>.
*/
$results = $node->data[0];
if ($results) {
$total_annual_salary = custom_number_formatter_format($results['total_annual_salary'], 2, '$');
$total_gross_pay = custom_number_formatter_format($results['total_gross_pay'], 2, '$');
$total_base_pay = custom_number_formatter_format($results['total_base_pay'], 2, '$');
$total_other_payments = custom_number_formatter_format($results['total_other_payments'], 2, '$');
$total_overtime_pay = custom_number_formatter_format($results['total_overtime_pay'], 2, '$');
$total_salaried_employees = number_format($results['total_salaried_employees@checkbook:payroll_year']);
$total_hourly_employees = number_format($results['total_hourly_employees@checkbook:payroll_year']);
$total_employees = number_format($results['total_employees@checkbook:payroll_year']);
$year = $results['year_year'];
$yearType = $results['year_type_year_type'];
if (_getRequestParamValue('smnid') == 322) {
$total_overtime_employees = number_format($results['total_overtime_employees']);
$total_overtime_employees_label = WidgetUtil::getLabel('total_no_of_ot_employees') . ':';
}
$table = "\r\n<div id='payroll-tx-static-content'>\r\n <table id='payroll-tx-static-content-table'>\r\n <tr>\r\n <td width='50%'><strong>" . WidgetUtil::getLabel('annual_salary') . "</strong>: {$total_annual_salary}</td>\r\n <td width='50%'><strong>" . WidgetUtil::getLabel('total_no_of_employees') . "</strong>: {$total_employees}</td>\r\n </tr>\r\n <tr>\r\n <td><strong>" . WidgetUtil::getLabel('gross_pay_ytd') . "</strong>: {$total_gross_pay}</td>\r\n <td><strong>" . WidgetUtil::getLabel('total_no_of_sal_employees') . "</strong>: {$total_salaried_employees}</td>\r\n </tr>\r\n <tr>\r\n <td><strong>" . WidgetUtil::getLabel('base_pay_ytd') . "</strong>: {$total_base_pay}</td>\r\n <td><strong>" . WidgetUtil::getLabel('total_no_of_non_sal_employees') . "</strong>: {$total_hourly_employees}</td>\r\n </tr>\r\n <tr>\r\n <td><strong>" . WidgetUtil::getLabel('other_pay_1_ytd') . "</strong>: {$total_other_payments}</td>\r\n <td><strong>" . WidgetUtil::getLabel('overtime_pay_1_ytd') . "</strong>: {$total_overtime_pay}</td>\r\n </tr>";
if (isset($total_overtime_employees)) {
$table .= "<tr>";
$table .= "<td><strong>{$total_overtime_employees_label} </strong> {$total_overtime_employees}</td>";
$table .= "</tr>";
}
$table .= "</table></div>";
print $table;
}
$http_ref = $_SERVER['HTTP_REFERER'];
$current_url = $_GET['q'];
//Advanced Search page should not have static text
$advanced_search_page = preg_match("/contract\\/search\\/transactions/", $current_url);
$advanced_search_page = $advanced_search_page || preg_match("/contract\\/all\\/transactions/", $current_url);
$advanced_search_page = $advanced_search_page || preg_match("/contract\\/search\\/transactions/", $http_ref);
$advanced_search_page = $advanced_search_page || preg_match("/contract\\/all\\/transactions/", $http_ref);
if ($advanced_search_page) {
return;
}
$contactStatus = _getRequestParamValue('contstatus');
$contactStatusLabel = 'Active';
if ($contactStatus == 'R') {
$contactStatusLabel = 'Registered';
}
if (_checkbook_check_isEDCPage()) {
print '<div class="transactions-total-amount">$' . custom_number_formatter_format($node->data[0]['total_amount_for_transaction'], 2) . '<div class="amount-title">Total ' . $contactStatusLabel . ' Current Contract Amount</div></div>';
} else {
if (_checkbook_check_is_mwbe_page() || _getRequestParamValue('dashboard')) {
$current_url = explode('/', $_SERVER['REQUEST_URI']);
if ($current_url[1] == 'contract' && ($current_url[2] == 'search' || $current_url[2] == 'all') && $current_url[3] == 'transactions') {
$summaryTitle = "";
} else {
$summaryTitle = 'Total ' . RequestUtil::getDashboardTitle() . " ";
$summaryTitle = str_replace('Total Total', 'Total', $summaryTitle);
}
print '<div class="transactions-total-amount">$' . custom_number_formatter_format($node->data[0]['total_maximum_contract_amount'], 2) . '<div class="amount-title">Total ' . $contactStatusLabel . ' Current Contract Amount</div></div>';
} else {
print '<div class="transactions-total-amount">$' . custom_number_formatter_format($node->data[0]['total_maximum_contract_amount'], 2) . '<div class="amount-title">Total ' . $contactStatusLabel . ' Current Contract Amount</div></div>';
}
}
$total_other_payments = custom_number_formatter_format($results['total_other_payments'], 2, '$');
$total_overtime_pay = custom_number_formatter_format($results['total_overtime_pay'], 2, '$');
$total_salaried_employees = number_format($results['total_salaried_employees@checkbook:payroll_year_month']);
$total_hourly_employees = number_format($results['total_hourly_employees@checkbook:payroll_year_month']);
$total_employees = number_format($results['total_employees@checkbook:payroll_year_month']);
$year = $results['year_year'];
$month = $results['month_month'];
$yearType = $results['year_type_year_type'];
$year_value = _getYearValueFromID($year);
$month_num = _getMonthValueFromId($month);
if (isset($month_num)) {
$dateObj = DateTime::createFromFormat('!m', $month_num);
$month_value = $dateObj->format('F');
}
$yeartype = 'FY';
if (_getRequestParamValue('yeartype') == 'C') {
$yeartype = 'CY';
}
if (_getRequestParamValue('smnid') == 491) {
$total_overtime_employees_label = WidgetUtil::getLabel('total_no_of_ot_employees') . ':';
$overtime_employees_value = number_format($results['total_overtime_employees']);
}
$table = "\r\n<div id='payroll-tx-static-content'>\r\n<div class='payroll-year-month'><span class='label'>" . WidgetUtil::getLabel('month') . ": </span><span class='data'> {$month_value} </span> | <span class='label'>" . WidgetUtil::getLabel('year') . ":</span><span class='data'> {$yeartype} {$year_value}</span></div>\r\n <table id='payroll-tx-static-content-table'>\r\n <tr>\r\n <td width='50%'><strong>" . WidgetUtil::getLabel('annual_salary') . "</strong>: {$total_annual_salary}</td>\r\n <td width='50%'><strong>" . WidgetUtil::getLabel('total_no_of_employees') . "</strong>: {$total_employees}</td>\r\n </tr>\r\n <tr>\r\n <td><strong>" . WidgetUtil::getLabel('gross_pay') . "</strong>: {$total_gross_pay}</td>\r\n <td><strong>" . WidgetUtil::getLabel('total_no_of_sal_employees') . "</strong>: {$total_salaried_employees}</td>\r\n </tr>\r\n <tr>\r\n <td><strong>" . WidgetUtil::getLabel('base_pay') . "</strong>:{$total_base_pay}</td>\r\n <td><strong>" . WidgetUtil::getLabel('total_no_of_non_sal_employees') . "</strong>: {$total_hourly_employees}</td>\r\n </tr>\r\n <tr>\r\n <td><strong>" . WidgetUtil::getLabel('other_pay') . "</strong>: {$total_other_payments}</td>\r\n <td><strong>" . WidgetUtil::getLabel('overtime_pay') . "</strong>: {$total_overtime_pay}</td>\r\n </tr>";
if (isset($overtime_employees_value)) {
$table .= "<tr>";
$table .= "<td><strong>{$total_overtime_employees_label} </strong> {$overtime_employees_value}</td>";
$table .= "</tr>";
}
$table .= "</table></div>";
print $table;
}
* Copyright (C) 2012, 2013 New York City
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
*
* 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/>.
*/
if (_getRequestParamValue("datasource") == "checkbook_oge") {
$datasource = "/datasource/checkbook_oge";
}
//Main table header
$tbl['header']['title'] = "<h3>Spending by Expense Category</h3>";
$tbl['header']['columns'] = array(array('value' => WidgetUtil::generateLabelMappingNoDiv("expense_category"), 'type' => 'text'), array('value' => WidgetUtil::generateLabelMappingNoDiv("encumbered_amount"), 'type' => 'number'), array('value' => WidgetUtil::generateLabelMappingNoDiv("spent_to_date"), 'type' => 'number'));
$count = 0;
if (count($node->data) > 0) {
foreach ($node->data as $row) {
$spent_to_date_value = custom_number_formatter_format($row['spending_amount'], 2, '$');
$spent_to_date = custom_number_formatter_format($row['spending_amount'], 2, '$');
//Main table columns
$tbl['body']['rows'][$count]['columns'] = array(array('value' => $row['expenditure_object_name'], 'type' => 'text'), array('value' => custom_number_formatter_format($row['encumbered_amount'], 2, '$'), 'type' => 'number'), array('value' => $spent_to_date_value, 'type' => 'number_link', 'link_value' => $spent_to_date));
$count += 1;
}
}
?>
window.location = "/mwbe_agency_grading/sub_vendor_data/year/<?php
echo _getRequestParamValue('year');
?>
/yeartype/<?php
echo _getRequestParamValue('yeartype');
?>
/mwbe_filter/" + filter;
<?php
} else {
?>
window.location = "/mwbe_agency_grading/year/<?php
echo _getRequestParamValue('year');
?>
/yeartype/<?php
echo _getRequestParamValue('yeartype');
?>
/mwbe_filter/" + filter;
<?php
}
?>
});
}
};
}(jQuery));
</script>
* 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/>.
*/
$records = $node->data;
if (is_array($records)) {
$row = $records[0];
$title = eval($node->widgetConfig->summaryView->templateTitleEval);
$label = $node->widgetConfig->summaryView->templateLabel;
$value = eval($node->widgetConfig->summaryView->templateLabelEval);
$ytdspending = WidgetUtil::getLabel("ytd_spending");
$dept = WidgetUtil::getLabel("dept_name");
$percent_spending = WidgetUtil::getLabel("percent_spending");
$percent_spending_value = $row['percent_spending'];
if (_getRequestParamValue('smnid') == 29) {
$percent_spending = '';
$percent_spending_value = '';
}
$summaryContent = <<<EOD
<div class="contract-details-heading">
\t<div class="contract-id">
\t\t<h2 class="contract-title">{$title}</h2>
\t\t<div class="spending-tx-subtitle"><b>{$label}</b>: {$value}</div>
\t</div>
\t<div class="dollar-amounts">
<div class="ytd-spending-amount">
{$row['formatted_check_amount_sum']}
<div class="amount-title">{$ytdspending}</div>
</div>
<div class="percent-spending-amount">
