drupal_add_js(drupal_get_path('module', 'widget_highstock') . '/highstock-globals.js'); } } ?> <?php echo eval($node->widgetConfig->header); $table_rows = array(); $viewAll = $_REQUEST['viewall']; $url_path = drupal_get_path_alias($_GET['q']); $path_params = explode('/', $url_path); if (in_array("year", $path_params)) { $yr_index = array_search("year", $path_params); $req_year_id = $path_params[$yr_index + 1]; } else { $req_year_id = _getCurrentYearID(); } $years = array(); foreach ($node->data as $row) { $years[$row['year_year_year_value']] = $row['year_year_year_value']; } asort($years); ?> <h2><?php echo $node->widgetConfig->table_title; ?> </h2> <div class="dataTable dynamicColumns"> <table id="table_<?php echo widget_unique_identifier($node);
//Main table header $tbl['header']['title'] = "<div class='tableHeader'><h3>Prime Vendor Information</h3> <span class='contCount'>Number of Prime Vendors: " . count($node->vendors_list) . " </span></div>"; $tbl['header']['columns'] = array(array('value' => WidgetUtil::generateLabelMappingNoDiv("prime_vendor_name"), 'type' => 'text'), array('value' => $node->widget_count_label, 'type' => 'number'), array('value' => WidgetUtil::generateLabelMappingNoDiv("spent_to_date"), 'type' => 'number'), array('value' => WidgetUtil::generateLabelMappingNoDiv("prime_vendor_address"), 'type' => 'text')); $vendor_cont_count = array(); foreach ($node->vendor_contracts_count as $vendor_cont) { $vendor_cont_count[$vendor_cont['vendor_id']]['count'] = $vendor_cont['count']; $vendor_cont_count[$vendor_cont['vendor_id']]['count'] = $vendor_cont['count']; } $count = 0; if (count($node->vendors_list) > 0) { foreach ($node->vendors_list as $vendor) { $spending_link = "/spending/transactions/vendor/" . $vendor['vendor_id'] . "/datasource/checkbook_oge/newwindow"; if (preg_match("/newwindow/", $_GET['q'])) { $vendor_name = $vendor['vendor_name']; } else { $vendor_name = "<a href='/contracts_landing/status/A/year/" . _getCurrentYearID() . "/yeartype/B/agency/" . $vendor['agency_id'] . "/datasource/checkbook_oge/vendor/" . $vendor['vendor_id'] . "?expandBottomCont=true'>" . $vendor['vendor_name'] . "</a>"; } $spent_to_date_value = custom_number_formatter_format($vendor['check_amount_sum'], 2, '$'); if (preg_match("/newwindow/", $_GET['q'])) { $spent_to_date_link = custom_number_formatter_format($vendor['check_amount_sum'], 2, '$'); } else { $spent_to_date_link = "<a class='new_window' target='_new' href='" . $spending_link . "'>" . custom_number_formatter_format($vendor['check_amount_sum'], 2, '$') . "</a>"; } //Main table columns $tbl['body']['rows'][$count]['columns'] = array(array('value' => $vendor_name, 'type' => 'text'), array('value' => $vendor_cont_count[$vendor['vendor_id']]['count'], 'type' => 'number'), array('value' => $spent_to_date_value, 'type' => 'number_link', 'link_value' => $spent_to_date_link), array('value' => $vendor['address'], 'type' => 'text')); $count++; } } $html = WidgetUtil::generateTable($tbl); echo $html; ?>
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'; if ($node->data[0]["mwbe_vendor"] == "Yes") { $vendor_link = '/contracts_landing/status/A/year/' . _getCurrentYearID() . '/yeartype/B/vendor/' . $node->data[0]['vendor_id'] . '/dashboard/mp?expandBottomCont=true'; } } else { $total_cont = 0; if ($node->data[0]['document_code'] == 'RCT1') { $vendor_link = '/contracts_pending_rev_landing/year/' . _getCurrentYearID() . '/yeartype/B/vendor/' . $node->data[0]['vendor_vendor'] . '?expandBottomCont=true'; } else { $vendor_link = '/contracts_pending_exp_landing/year/' . _getCurrentYearID() . '/yeartype/B/vendor/' . $node->data[0]['vendor_vendor'] . '?expandBottomCont=true'; } } ?> <ul class="left"> <li><span class="gi-list-item">Prime Vendor:</span> <a href="<?php echo $vendor_link; ?> " ><?php echo $node->data[0]['vendor_name']; ?> </a></li> <?php $address = $node->data[0]['address_line_1']; $address .= " " . $node->data[0]['address_line_2']; $address .= " " . $node->data[0]['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/>. */ $budget_parameter_mapping = _checkbook_smart_search_domain_fields('budget'); $linkable_fields = array("agency_name" => "/budget/year/" . _getCurrentYearID() . "/yeartype/B/agency/" . $budget_results["agency_id"], "expenditure_object_name" => "/budget/year/" . _getCurrentYearID() . "/yeartype/B/expcategory/" . $budget_results["expenditure_object_id"]); if ($budget_results['fiscal_year'][0] < 2010) { $linkable_fields = array(); } $amount_fields = array("adopted_amount", "current_budget_amount", "total_expenditure", "pre_encumbered_amount", "encumbered_amount", "accrued_expense_amount", "cash_expense_amount", "post_closing_adjustment_amount"); $count = 1; $row = array(); $rows = array(); foreach ($budget_parameter_mapping as $key => $title) { $value = $budget_results[$key]; if ($key == 'expenditure_object_name') { $value = $budget_results[$key][0]; } if ($key == 'fiscal_year') { $value = $budget_results[$key][0]; }
static function getLandingPageUrl($domain, $year = null, $yearType = null) { if ($year == null) { $year = _getCurrentYearID(); } if ($yearType == null) { $yearType = 'B'; } switch ($domain) { case "contracts": $path = "contracts_landing/status/A/yeartype/" . $yearType . "/year/" . $year; break; case "spending": $path = "spending_landing/yeartype/" . $yearType . "/year/" . $year; break; case "payroll": $path = "payroll/yeartype/B/year/" . $year; break; case "budget": $path = "budget/yeartype/B/year/" . $year; break; case "revenue": $path = "revenue/yeartype/B/year/" . $year; break; } return $path; }
if (_getRequestParamValue("datasource") == "checkbook_oge") { $datasource = "/datasource/checkbook_oge"; $oge_class = "oge-ca-details"; } else { $oge_class = "cb-ca-details"; } if (_getRequestParamValue("doctype") == "RCT1") { $vendor_link = '/contracts_revenue_landing' . $status . '/year/' . _getCurrentYearID() . '/yeartype/B/vendor/' . $node->data[0]['vendor_id_checkbook_vendor_history'] . '?expandBottomCont=true'; $agency_link = '/contracts_revenue_landing' . $status . '/year/' . _getCurrentYearID() . $datasource . '/yeartype/B/agency/' . $node->data[0]['agency_id_checkbook_agency'] . '?expandBottomCont=true'; } else { if (_is_mwbe_vendor(_getRequestParamValue("agid"))) { $vendor_link = '/contracts_landing' . $status . '/year/' . _getCurrentYearID() . '/yeartype/B/vendor/' . $node->data[0]['vendor_id_checkbook_vendor_history'] . '/dashboard/mp?expandBottomCont=true'; } else { $vendor_link = '/contracts_landing' . $status . '/year/' . _getCurrentYearID() . '/yeartype/B/vendor/' . $node->data[0]['vendor_id_checkbook_vendor_history'] . '?expandBottomCont=true'; } $agency_link = '/contracts_landing' . $status . '/year/' . _getCurrentYearID() . $datasource . '/yeartype/B/agency/' . $node->data[0]['agency_id_checkbook_agency'] . '?expandBottomCont=true'; } $spending_link = "/spending/transactions/agid/" . _getRequestParamValue("agid") . $datasource . "/newwindow"; if (_getRequestParamValue("datasource") != "checkbook_oge") { $contract_number = $node->data[0]['contract_number']; $querySubVendorCount = "SELECT COUNT(DISTINCT vendor_id) AS sub_vendor_count FROM sub_agreement_snapshot\n WHERE contract_number = '" . $contract_number . "'\n AND latest_flag = 'Y'\n LIMIT 1"; $results3 = _checkbook_project_execute_sql_by_data_source($querySubVendorCount, _get_current_datasource()); $res->data = $results3; $total_subvendor_count = $res->data[0]['sub_vendor_count']; } ?> <div class="contract-details-heading <?php echo $oge_class; ?> "> <div class="contract-id">
<h4> Sub Vendor Information </h4> <div class="spent-to-date"> <?php if (!preg_match('/newwindow/', $_GET['q'])) { ?> <a class="new_window" href="/contract/spending/transactions/contnum/<?php echo $contract_number; echo $status; ?> /dashboard/ss/yeartype/B/year/<?php echo _getCurrentYearID(); ?> /syear/<?php echo _getCurrentYearID(); ?> /smnid/721/newwindow"><?php echo custom_number_formatter_format($total_spent_todate, 2, "\$"); ?> </a> <?php } else { echo custom_number_formatter_format($total_spent_todate, 2, "\$"); ?> <?php } ?> <div class="amount-title">Total Spent to Date </div>
* 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/>. */ $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 {
/** * Returns Prime Vendor Name Link Url based on values from current path & data row. * This is for the advanced search page, if no year is provided, we use the current year * * @param $node * @param $row * @return string */ static function getPayeeNameLinkUrl($node, $row) { $year = _getRequestParamValue("year"); $calyear = _getRequestParamValue("calyear"); $year_type = isset($calyear) ? "C" : "B"; $year_id = isset($calyear) ? $calyear : (isset($year) ? $year : _getCurrentYearID()); $vendor_id = $row["vendor_id"]; $agency_id = $row["agency_id"]; $dashboard = _getRequestParamValue("dashboard"); return $row["is_sub_vendor"] == "No" ? self::getPrimeVendorLink($vendor_id, $agency_id, $year_id, $year_type, $dashboard, true) : self::getSubVendorLink($vendor_id, $agency_id, $year_id, $year_type, $dashboard, true); }
$rows = array(); foreach ($revenue_parameter_mapping as $key => $title) { $value = $revenue_results[$key]; if ($key == 'fiscal_year') { $value = $revenue_results[$key][0]; } if (strpos(strtoupper($value), strtoupper($SearchTerm)) !== FALSE) { $temp = substr($value, strpos(strtoupper($value), strtoupper($SearchTerm)), strlen($SearchTerm)); $value = str_ireplace($SearchTerm, '<em>' . $temp . '</em>', $value); $value = _checkbook_smart_search_str_html_entities($value); } if (in_array($key, $amount_fields)) { $value = custom_number_formatter_format($value, 2, '$'); } else { if (array_key_exists($key, $linkable_fields)) { $value = "<a href='/revenue/year/" . _getCurrentYearID() . $linkable_fields[$key] . "'>" . $value . "</a>"; } } if ($count % 2 == 0) { if ($title) { $row[] = '<div class="field-label">' . $title . ':</div><div class="field-content">' . $value . '</div>'; } $rows[] = $row; $row = array(); } else { if ($title) { $row[] = '<div class="field-label">' . $title . ':</div><div class="field-content">' . $value . '</div>'; } } $count++; }
private function generate_field(Field $field, $form, $data_source) { $domain = $data_source . '_' . $this->domain_name; $year_range = "'-" . (date("Y") - 1900) . ":+" . (2500 - date("Y")) . "'"; $column_left_class = "column column-left " . str_replace('_', '-', $data_source); $column_right_class = "column column-right " . str_replace('_', '-', $data_source); switch ($field->field_coordinates) { case 1: $field->prefix = '<div class="' . $column_left_class . '">'; break; case 2: $field->suffix = '</div>'; break; case 3: $field->prefix = '<div class="' . $column_right_class . '">'; break; case 4: $field->suffix = '</div>'; break; } switch ($field->field_type) { case FieldType::DateFilter: //date_filter $domain_field = "{$data_source}_{$this->domain_name}_date_filter"; //$domain_field = 'date_filter'; $form[$domain][$domain_field]['#type'] = FieldType::RadioButtons; $form[$domain][$domain_field]['#title'] = t('Date Filter'); $form[$domain][$domain_field]['#options'] = array('Year', 'Issue Date'); $form[$domain][$domain_field]['#prefix'] = $field->prefix . '<div class="datafield datefilter clearfix">'; $form[$domain][$domain_field]['#suffix'] = '</div>'; $form[$domain][$domain_field]['#attributes'] = array('class' => array('watch')); $form[$domain][$domain_field]['#default_value'] = ''; //year_filter_start //$domain_field = 'year_filter_start'; $domain_field = "{$data_source}_{$this->domain_name}_year_filter_start"; $form[$domain][$domain_field]['#markup'] = '<div class="datafield year-filters last-item">'; //issue_date_from //$domain_field = "{$this->domain_name}_issue_date_from"; $domain_field = "{$data_source}_{$this->domain_name}_issue_date_from"; $form[$domain][$domain_field]['#type'] = FieldType::DatePopup; $form[$domain][$domain_field]['#date_format'] = 'Y-m-d'; $form[$domain][$domain_field]['#date_year_range'] = $year_range; $form[$domain][$domain_field]['#prefix'] = '<div class="datafield datarange issueddate"><div class="ranges">'; $form[$domain][$domain_field]['#default_value'] = ''; // //Hidden Field // $domain_field = "{$data_source}_{$this->domain_name}_issue_date_from_exact"; // $form[$domain][$domain_field]['#type'] = FieldType::HiddenField; // $form[$domain][$domain_field]['#name'] = $domain_field; //issue_date_to //$domain_field = "{$this->domain_name}_issue_date_to"; $domain_field = "{$data_source}_{$this->domain_name}_issue_date_to"; $form[$domain][$domain_field]['#type'] = FieldType::DatePopup; $form[$domain][$domain_field]['#title'] = t('to'); $form[$domain][$domain_field]['#date_format'] = 'Y-m-d'; $form[$domain][$domain_field]['#date_year_range'] = $year_range; $form[$domain][$domain_field]['#suffix'] = '</div></div>'; $form[$domain][$domain_field]['#default_value'] = ''; //Hidden Field // $domain_field = "{$data_source}_{$this->domain_name}_issue_date_to_exact"; // // $form[$domain][$domain_field]['#type'] = FieldType::HiddenField; // $form[$domain][$domain_field]['#name'] = $domain_field; //fiscal_year //$domain_field = "{$this->domain_name}_fiscal_year"; $domain_field = "{$data_source}_{$this->domain_name}_fiscal_year"; $form[$domain][$domain_field]['#type'] = FieldType::DropDown; $form[$domain][$domain_field]['#options'] = _checkbook_advanced_search_get_year($this->domain_name, $data_source); $form[$domain][$domain_field]['#default_value'] = 'fy~' . _getCurrentYearID(); $form[$domain][$domain_field]['#attributes'] = array('class' => array('watch'), 'default_selected_value' => 'fy~' . _getCurrentYearID()); $form[$domain][$domain_field]['#prefix'] = '<div class="datafield year">'; $form[$domain][$domain_field]['#suffix'] = '</div>'; //year_filter_end // $domain_field = 'year_filter_end'; $domain_field = "{$data_source}_{$this->domain_name}_year_filter_end"; if (!is_null($field->suffix)) { $form[$domain][$domain_field]['#markup'] = '</div>' . $field->suffix; } else { $form[$domain][$domain_field]['#markup'] = '</div>'; } break; case FieldType::DropDown: $domain_field = "{$data_source}_{$this->domain_name}_{$field->field_name}"; if (!is_null($field->prefix)) { $form[$domain][$domain_field]['#prefix'] = $field->prefix; } if (!is_null($field->suffix)) { $form[$domain][$domain_field]['#suffix'] = $field->suffix; } $form[$domain][$domain_field]['#type'] = $field->field_type; $form[$domain][$domain_field]['#title'] = $field->getFieldTitle(); $form[$domain][$domain_field]['#default_value'] = $field->getDropDownDefault(); $form[$domain][$domain_field]['#options'] = $field->getDropDownOptions(); $form[$domain][$domain_field]['#validated'] = true; if (!is_null($field->disabled)) { $form[$domain][$domain_field]['#disabled'] = $field->disabled; } if (!is_null($field->option_attributes)) { $form[$domain][$domain_field]['#option_attributes'] = $field->option_attributes; } break; case FieldType::RadioButtons: $domain_field = "{$this->domain_name}_{$field->field_name}"; if (!is_null($field->prefix)) { $form[$domain][$domain_field]['#prefix'] = $field->prefix; } $form[$domain][$domain_field]['#type'] = FieldType::RadioButtons; if (!is_null($field->default_value)) { $form[$domain][$domain_field]['#default_value'] = $field->default_value; } if (!is_null($field->options)) { $form[$domain][$domain_field]['#options'] = $field->options; } break; case FieldType::RangeField: //From $domain_field = "{$data_source}_{$this->domain_name}_{$field->field_name}_from"; $css_name = str_replace('_', '-', $field->field_name); $form[$domain][$domain_field]['#type'] = FieldType::TextField; if (!is_null($field->size)) { $form[$domain][$domain_field]['#size'] = $field->size; } else { $form[$domain][$domain_field]['#size'] = 30; } //Default if (!is_null($field->maxlength)) { $form[$domain][$domain_field]['#maxlength'] = $field->maxlength; } else { $form[$domain][$domain_field]['#maxlength'] = 32; } //Default if (!is_null($field->prefix)) { $form[$domain][$domain_field]['#prefix'] = $field->prefix . '<div class="form-item form-item-' . $css_name . '"><label>' . $field->getFieldTitle() . '</label><div class="ranges">'; } else { $form[$domain][$domain_field]['#prefix'] = '<div class="form-item form-item-' . $css_name . '"><label>' . $field->getFieldTitle() . '</label><div class="ranges">'; } //To $domain_field = "{$data_source}_{$this->domain_name}_{$field->field_name}_to"; $form[$domain][$domain_field]['#type'] = FieldType::TextField; $form[$domain][$domain_field]['#title'] = t('TO'); if (!is_null($field->size)) { $form[$domain][$domain_field]['#size'] = $field->size; } else { $form[$domain][$domain_field]['#size'] = 30; } //Default if (!is_null($field->maxlength)) { $form[$domain][$domain_field]['#maxlength'] = $field->maxlength; } else { $form[$domain][$domain_field]['#maxlength'] = 32; } //Default if (!is_null($field->suffix)) { $form[$domain][$domain_field]['#suffix'] = '</div></div>' . $field->suffix; } else { $form[$domain][$domain_field]['#suffix'] = '</div></div>'; } break; case FieldType::RangeDateField: //From $domain_field = "{$data_source}_{$this->domain_name}_{$field->field_name}_from"; $css_name = str_replace('_', '-', $field->field_name); $form[$domain][$domain_field]['#type'] = FieldType::DatePopup; $form[$domain][$domain_field]['#date_format'] = 'Y-m-d'; $form[$domain][$domain_field]['#date_year_range'] = $year_range; if (!is_null($field->prefix)) { $form[$domain][$domain_field]['#prefix'] = $field->prefix . '<div class="form-item form-item-' . $css_name . '"><label>' . $field->getFieldTitle() . '</label><div class="ranges">'; } else { $form[$domain][$domain_field]['#prefix'] = '<div class="form-item form-item-' . $css_name . '"><label>' . $field->getFieldTitle() . '</label><div class="ranges">'; } //To $domain_field = "{$data_source}_{$this->domain_name}_{$field->field_name}_to"; $form[$domain][$domain_field]['#type'] = FieldType::DatePopup; $form[$domain][$domain_field]['#date_format'] = 'Y-m-d'; $form[$domain][$domain_field]['#title'] = t('TO'); if (!is_null($field->suffix)) { $form[$domain][$domain_field]['#suffix'] = '</div></div>' . $field->suffix; } else { $form[$domain][$domain_field]['#suffix'] = '</div></div>'; } break; case FieldType::SubmitField: $submit_class = "{$this->domain_name}-submit " . str_replace('_', '-', $data_source); //Next Button - visible for create alerts $domain_field = "{$this->domain_name}_next"; $form[$domain][$domain_field]['#type'] = 'button'; $form[$domain][$domain_field]['#name'] = $domain_field; $form[$domain][$domain_field]['#value'] = t('Next'); $form[$domain][$domain_field]['#prefix'] = t('<div class="' . $submit_class . '">'); $form[$domain][$domain_field]['#ajax'] = array('callback' => '_checkbook_advanced_search_create_alert_results_ajax', 'event' => 'click', 'progress' => array('type' => 'none')); //Submit Button $domain_field = "{$this->domain_name}_submit"; $form[$domain][$domain_field]['#type'] = $field->field_type; $form[$domain][$domain_field]['#name'] = $domain_field; $form[$domain][$domain_field]['#value'] = t('Submit'); //Clear All Button $domain_field = "{$this->domain_name}_clear"; $form[$domain][$domain_field]['#type'] = $field->field_type; $form[$domain][$domain_field]['#value'] = t('Clear All'); end($this->contents); $endKey = key($this->contents); if ($data_source == $endKey) { $form[$domain][$domain_field]['#suffix'] = '</div></div>'; } else { $form[$domain][$domain_field]['#suffix'] = '</div>'; } break; case FieldType::TextField: $domain_field = "{$data_source}_{$this->domain_name}_{$field->field_name}"; $form[$domain][$domain_field]['#type'] = FieldType::TextField; $form[$domain][$domain_field]['#title'] = $field->getFieldTitle(); if (!is_null($field->size)) { $form[$domain][$domain_field]['#size'] = $field->size; } else { $form[$domain][$domain_field]['#size'] = 30; } //Default if (!is_null($field->maxlength)) { $form[$domain][$domain_field]['#maxlength'] = $field->maxlength; } else { $form[$domain][$domain_field]['#maxlength'] = 32; } //Default if (!is_null($field->prefix)) { $form[$domain][$domain_field]['#prefix'] = $field->prefix; } //Hidden $domain_field = "{$data_source}_{$this->domain_name}_{$field->field_name}_exact"; $form[$domain][$domain_field]['#type'] = FieldType::HiddenField; $form[$domain][$domain_field]['#name'] = $domain_field; if (!is_null($field->suffix)) { $form[$domain][$domain_field]['#suffix'] = $field->suffix; } break; } return $form; }
public static function getLatestMwbeCategoryByVendor($vendor_id, $agency_id = null, $year_id = null, $year_type = null, $is_prime_or_sub = "P") { static $contract_vendor_latest_mwbe_category; if ($agency_id == null) { $agency_id = _getRequestParamValue('agency'); } if ($year_type == null) { $year_type = _getRequestParamValue('yeartype'); } if ($year_id == null) { $year_id = _getRequestParamValue('year'); } if ($year_id == null) { $year_id = _getRequestParamValue('calyear'); } if ($year_id == null) { $year_type = "B"; $year_id = _getCurrentYearID(); } $latest_minority_type_id = null; $agency_query = isset($agency_id) ? "agency_id = " . $agency_id : "agency_id IS NULL"; if (!isset($contract_vendor_latest_mwbe_category)) { $query = "SELECT vendor_id, agency_id, year_id, type_of_year, minority_type_id, is_prime_or_sub\n FROM contract_vendor_latest_mwbe_category\n WHERE minority_type_id IN (2,3,4,5,9) AND year_id = " . $year_id . " AND type_of_year = '" . $year_type . "'" . " AND " . $agency_query . " AND is_prime_or_sub = '" . $is_prime_or_sub . "'" . " GROUP BY vendor_id, agency_id, year_id, type_of_year, minority_type_id, is_prime_or_sub"; $results = _checkbook_project_execute_sql_by_data_source($query, 'checkbook'); foreach ($results as $row) { if (isset($row['agency_id'])) { $contract_vendor_latest_mwbe_category[$row['vendor_id']][$row['agency_id']][$row['is_prime_or_sub']]['minority_type_id'] = $row['minority_type_id']; } else { $contract_vendor_latest_mwbe_category[$row['vendor_id']][$row['is_prime_or_sub']]['minority_type_id'] = $row['minority_type_id']; } } } $latest_minority_type_id = isset($agency_id) ? $contract_vendor_latest_mwbe_category[$vendor_id][$agency_id][$is_prime_or_sub]['minority_type_id'] : $contract_vendor_latest_mwbe_category[$vendor_id][$is_prime_or_sub]['minority_type_id']; return $latest_minority_type_id; }
public function prepareActRegContractsSliderFilter($page, $status) { $pathParams = explode('/', drupal_get_path_alias($_GET['q'])); $url = $page; if (strlen($status) > 0) { $url .= "/status/" . $status; } $url .= _checkbook_append_url_params(); if (preg_match("/^contracts_pending/", drupal_get_path_alias($_GET['q']))) { $allowedFilters = array("agency", "vendor", "awrdmthd", "csize", "cindustry", "agid", "dashboard", "subvendor", "mwbe"); $url .= "/yeartype/B/year/" . _getCurrentYearID(); } else { $allowedFilters = array("year", "calyear", "agency", "yeartype", "awdmethod", "vendor", "csize", "cindustry", "agid", "dashboard", "subvendor", "mwbe"); } for ($i = 1; $i < count($pathParams); $i++) { if (in_array($pathParams[$i], $allowedFilters)) { $newPathParams = explode('/', $url); $url .= !in_array($pathParams[$i], $newPathParams) ? '/' . $pathParams[$i] . '/' . $pathParams[$i + 1] : ''; } $i++; } return $url; }