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); } }
/** Returns Contracts page title and Breadcrumb */ static function getContractBreadcrumbTitle() { $bottomURL = $_REQUEST['expandBottomContURL']; if (preg_match('/magid/', $bottomURL)) { $magid = RequestUtil::getRequestKeyValueFromURL("magid", $bottomURL); $contract_number = _get_master_agreement_details($magid); return $contract_number['contract_number']; } elseif (preg_match('/agid/', $bottomURL)) { $agid = RequestUtil::getRequestKeyValueFromURL("agid", $bottomURL); $contract_number = _get_child_agreement_details($agid); return $contract_number['contract_number']; } elseif (preg_match('/contract/', $bottomURL) && preg_match('/pending_contract_transactions/', $bottomURL)) { $contract_number = RequestUtil::getRequestKeyValueFromURL("contract", $bottomURL); return $contract_number; } else { if (isset($bottomURL) && preg_match('/transactions/', $bottomURL)) { $smnid = RequestUtil::getRequestKeyValueFromURL("smnid", $bottomURL); $dashboard = RequestUtil::getRequestKeyValueFromURL("dashboard", $bottomURL); $title = NodeSummaryUtil::getInitNodeSummaryTitle($smnid); if ($smnid == 720 && $dashboard != 'mp') { $title = ''; } if (preg_match('/^contracts_landing/', current_path()) && preg_match('/status\\/A/', current_path())) { $title = RequestUtil::getDashboardTitle() . ' ' . $title . ' ' . ' Active Expense Contracts Transactions'; } elseif (preg_match('/^contracts_landing/', current_path()) && preg_match('/status\\/R/', current_path())) { $title = RequestUtil::getDashboardTitle() . ' ' . $title . ' ' . ' Registered Expense Contracts Transactions'; } elseif (preg_match('/^contracts_revenue_landing/', current_path()) && preg_match('/status\\/A/', current_path())) { $title = RequestUtil::getDashboardTitle() . ' ' . $title . ' ' . ' Active Revenue Contracts Transactions'; } elseif (preg_match('/^contracts_revenue_landing/', current_path()) && preg_match('/status\\/R/', current_path())) { $title = RequestUtil::getDashboardTitle() . ' ' . $title . ' ' . ' Registered Revenue Contracts Transactions'; } elseif (preg_match('/^contracts_pending_exp_landing/', current_path())) { $title = RequestUtil::getDashboardTitle() . ' ' . $title . ' ' . ' Pending Expense Contracts Transactions'; } elseif (preg_match('/^contracts_pending_rev_landing/', current_path())) { $title = RequestUtil::getDashboardTitle() . ' ' . $title . ' ' . ' Pending Revenue Contracts Transactions'; } } elseif (preg_match('/^contracts_landing/', current_path()) && preg_match('/status\\/A/', current_path())) { $title = _get_contracts_breadcrumb_title_drilldown(false) . ' ' . RequestUtil::getDashboardTitle() . ' Active Expense Contracts'; } elseif (preg_match('/^contracts_landing/', current_path()) && preg_match('/status\\/R/', current_path())) { $title = _get_contracts_breadcrumb_title_drilldown(false) . ' ' . RequestUtil::getDashboardTitle() . ' Registered Expense Contracts'; } elseif (preg_match('/^contracts_revenue_landing/', current_path()) && preg_match('/status\\/A/', current_path())) { $title = _get_contracts_breadcrumb_title_drilldown(false) . ' ' . RequestUtil::getDashboardTitle() . ' Active Revenue Contracts'; } elseif (preg_match('/^contracts_revenue_landing/', current_path()) && preg_match('/status\\/R/', current_path())) { $title = _get_contracts_breadcrumb_title_drilldown(false) . ' ' . RequestUtil::getDashboardTitle() . ' Registered Revenue Contracts'; } elseif (preg_match('/^contracts_pending_exp_landing/', current_path())) { $title = _get_pending_contracts_breadcrumb_title_drilldown() . ' ' . RequestUtil::getDashboardTitle() . ' Pending Expense Contracts'; } elseif (preg_match('/^contracts_pending_rev_landing/', current_path())) { $title = _get_pending_contracts_breadcrumb_title_drilldown() . ' ' . RequestUtil::getDashboardTitle() . ' Pending Revenue Contracts'; } else { global $checkbook_breadcrumb_title; $title = $checkbook_breadcrumb_title; } } return html_entity_decode($title); }