PHP _getRequestParamValue函数代码示例

 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>&nbsp</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;